Data Documentation

Find below a list of our data tables.
All imported data will either directly imported or converted into this structure. Data which can not directly map onto existing columns is collected in the custom json column.
More documentation and information for prospect users can be found in the Prospect wiki
grids Static data about electrical grids - minigrids as well as national grids
grids_ts Time Series data of individual grids
meter_events_ts Time Series data of events processed from meters_ts
meters Represents installations of on-grid or mini-grid meters at a specific customer.
meters_ts Time Series data of individual meters
paygo_accounts_snapshots_ts Time Series data of events processed from meters_ts
payments_ts Payment time series data for SHS Accounts or Meter Accounts
reports This table saves data from Ascent reports submitted by PIUs for both connections and non-connections based metrics. It saves them in the same level of granularity as the submitted report, allowing for validation checks and data ingestion.
shs Represents installations of Solar Home Systems at individual customers
shs_ts Time Series data of individual Solar Home Systems
targets This tables saves targets data for Ascent reports submitted by PIUs. It allows for tracking and validation of targets set for various metrics.
trust_trace Trust Trace - the results of data validations and checks on subjects from other tables. Populated by data processors.
yearly_reports This tables aggregates the data from the reports table into yearly summaries. It allows for simplification of queries on Grafana.
custom This tables saves completely custom data as json. For easier export and graphing per source views with customizable structure are automatically created.