• Energy
  • 15 columns
  • 150 rows
  • 8 formats

AMI Billing Determinants and Usage Summary

This dataset provides detailed monthly billing summaries derived from smart meter interval data, including total and time-of-use electricity consumption, peak demand, service days, and metering multipliers. It enables granular analysis of energy usage patterns, billing accuracy, and tariff impacts for utilities and energy analysts. The dataset is ideal for operational reporting, customer segmentation, and regulatory compliance in the energy sector.

  • last updated 2 Nov 2025
  • by GoMask
The brief that made it

Utility billing and revenue assurance

Sample rows

preview · 8 of 150 rows · all 15 columns
billing_idstringrate_codestringmeter_multiplierfloatcurrencystringcustomer_idstringmeter_idstringbilling_period_startdatebilling_period_enddateservice_daysintegertotal_kwhfloatpeak_demand_kwfloattou_on_peak_kwhfloattou_off_peak_kwhfloattou_mid_peak_kwhfloatbilling_amountfloat
BILL-0001RES-STD1.2USDCUST-001MTR-1012023-01-012023-01-3131420.56.8176.2206.33868.35
BILL-0002RES-STD1.1USDCUST-002MTR-1022023-01-012023-01-3131385.46.2162.1201.32261.87
BILL-0003RES-STD1.4USDCUST-003MTR-1032023-01-012023-01-3030498.7819525548.780.45
BILL-0004RES-GRN1CADCUST-004MTR-1042023-01-152023-01-291572.32.330.138.2412.78
BILL-0005RES-GRN1.2USDCUST-005MTR-1052023-02-012023-02-16161103.45354319.56
BILL-0006RES-GRN1.3USDCUST-006MTR-1062023-02-012023-02-2828158.62.16278.218.424.18
BILL-0007RES-LOW1.1USDCUST-007MTR-1072023-02-012023-02-20202207.2801202026.11
BILL-0008RES-LOW0.1USDCUST-008MTR-1082023-03-012023-03-01100blankblankblank0

What the 150 rows show

from the 150-row sample

IND-TOU (rate code) stands out: mean meter_multiplier is 10.0, against 1.1 for the rest.

  • 1.1median meter_multiplier
  • 31median service_days
  • 372.6median total_kwh
  • 5.8median peak_demand_kw
  • 165.2median tou_on_peak_kwh
  • 206.3median tou_off_peak_kwh
Mean meter_multiplier by rate_code150 rows
05101.2RES-…49 ro…0.57RES-…29 ro…1.2RES-…21 ro…10.0IND-…15 ro…0.78RES-…13 ro…1.6COM-…12 ro…1.9COM-…11 ro…
meter_multiplier150 rows, in bands of 1
050100281007000000150510meter_multiplier →

Median 1.1, from 0.10 to 10.0.

currency150 rows · 5 values
  1. USD105
  2. EUR15
  3. CAD13
  4. GBP11
  5. AUD6
15 columns by typefrom the column list below
  • string 5
  • integer 1
  • float 7
  • date 2

Columns

15 columns in three groups
blueprint · 15 columns
columntypedescriptionexample
Text 5 columns
billing_idstringUnique identifier for each monthly billing summary recorduniqueBILL-0001
customer_idstringUnique identifier for the customer or accountCUST-001
meter_idstringUnique identifier for the smart meterMTR-101
rate_codestringCode representing the applicable rate or tariff for the billing period7 codesRES-STD
currencystringCurrency code for the billing amount (e.g., USD, EUR)USD · EUR · GBP · CAD · AUD · optionalUSD
Numbers 8 columns
service_daysintegerNumber of service days within the billing period1 or more31
total_kwhfloatTotal kilowatt-hours consumed during the billing period0 or more420.5
peak_demand_kwfloatMaximum kilowatt demand recorded in the billing period0 or more6.8
tou_on_peak_kwhfloatKilowatt-hours consumed during on-peak time-of-use periods0 or more · optional176.2
tou_off_peak_kwhfloatKilowatt-hours consumed during off-peak time-of-use periods0 or more · optional206.3
tou_mid_peak_kwhfloatKilowatt-hours consumed during mid-peak time-of-use periods0 or more · optional38
meter_multiplierfloatMultiplier factor applied to meter readings for revenue metering0.1 or more1.2
billing_amountfloatTotal amount billed for the period (if available)0 or more · optional68.35
Dates and times 2 columns
billing_period_startdateStart date of the billing period2023-01-01
billing_period_enddateEnd date of the billing period2023-01-31

Use it for

  • median meter m…1.1150 rowsmean meter multiplier…1.2RES-…0.57RES-…1.2RES-…10.0IND-…

    An energy dashboard

    Meter_multiplier by rate_code and a breakdown of currency. Excel, Power BI or Tableau.

  • Why do the 15 IND-TOU rows have a mean meter_multiplier of 10.0?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable billings with customer_id, meter_id and billing_period_start to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 15 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset150 rows15 columns
Yours1,000 rows15 columns

blueprint · ami-billing-determinants-and-usage-summary

Behind this dataset

Same schema. As many rows as you need.

These 150 rows came out of a blueprint — 15 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • Account number links to customer master and meter ID
  • Bill period start and end dates with service days count
  • Total kWh consumption for billing period
  • Peak demand (kW) for demand-based rate classes
  • TOU buckets: on-peak, off-peak, shoulder periods
  • Multiplier factors (CT/PT ratios) for large commercial meters
  • Estimated vs. actual read flag
  • Rate schedule and tariff code for billing calculation
Rows
Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
ami-billing-determinants-and-usage-summary

More in Energy

Browse all
Also in EnergyEnergy Consumption Time SeriesSCADA Alarm and Event ManagementCommercial & Industrial (C&I) Demand ProfilesAll 1,966 datasets

What should your data show?

Preview 20 rows free
No signup. No card.