Guided tour
Sample data · no sign-up
Rows loaded
18000
Accounts
1500
3 customer classes
Period
2023-01-29
to 2024-01-01
Unit
kWh
Analysis readiness
What this dataset's columns support. Missing inputs can be enriched (e.g. weather) or supplied by you — see how it works.
Column mapping
How this extract's columns map to UnitTrack's canonical schema. PII is flagged and kept out of analysis (NIST SP 800-122).
| Source column | UnitTrack field | Role |
|---|---|---|
| ACCT_NO | account_id · string | Identifier |
| CUST_NAME | customer_name · string | PII (protected) |
| SVC_ADDR | service_address · string | PII (protected) |
| SVC_CITY | service_city · string | Geography |
| SVC_ZIP | service_zip · string | Geography |
| LATITUDE | latitude · float | Geography |
| LONGITUDE | longitude · float | Geography |
| METER_ID | meter_id · string | Identifier |
| RATE_CLASS | rate_class · string | Dimension |
| RATE_SCHED | rate_schedule · string | Dimension |
| SERVICE_TYPE | service_type · string | Dimension |
| PRIOR_READ_DT | prior_read_date · date | Time |
| READ_DT | read_date · date | Time |
| PRIOR_READ | prior_read · float | Measure |
| CURR_READ | current_read · float | Measure |
| USAGE | consumption · float | Measure |
| UNIT | unit · string | Attribute |
| EST_FLAG | estimated_flag · string | Attribute |
| TEMP_AVG_F | avg_temp_f · float | Attribute |
| FLOOR_AREA | floor_area_sqft · float | Attribute |
| PEAK_KW | peak_demand_kw · float | Attribute |
| PEAK_HOUR | peak_hour · int | Attribute |
Data preview
First rows as ingested. PII columns never enter the analysis path.
| account_id | customer_name | service_address | rate_class | read_date | consumption | unit |
|---|---|---|---|---|---|---|
| 100000 | •••••• | •••••• | COMMERCIAL | 2023-01-29 | 8221.59 | kWh |
| 100000 | •••••• | •••••• | COMMERCIAL | 2023-03-02 | 7861.91 | kWh |
| 100000 | •••••• | •••••• | COMMERCIAL | 2023-04-03 | 10863.13 | kWh |
| 100000 | •••••• | •••••• | COMMERCIAL | 2023-05-06 | 9185.11 | kWh |
| 100000 | •••••• | •••••• | COMMERCIAL | 2023-06-05 | 12578.25 | kWh |
| 100000 | •••••• | •••••• | COMMERCIAL | 2023-07-03 | 14553.57 | kWh |
| 100000 | •••••• | •••••• | COMMERCIAL | 2023-07-30 | 11887.46 | kWh |
| 100000 | •••••• | •••••• | COMMERCIAL | 2023-08-30 | 14601.15 | kWh |