• Energy
  • 19 columns
  • 200 rows
  • 8 formats

Residential Smart Meter Enrollment and Device Inventory

This dataset provides a detailed inventory of residential smart meters, capturing device specifications, installation details, firmware, communication modules, and comprehensive customer linkage including service address and contact information. It enables utilities and energy providers to manage device assets, monitor enrollment status, and support customer service operations. The data is ideal for asset tracking, operational analytics, and regulatory compliance.

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

Utility asset management and device lifecycle tracking

Sample rows

preview · 8 of 200 rows · all 19 columns
meter_serial_numberstringenrollment_statusstringservice_address_statestringmeter_makestringmeter_modelstringinstallation_datedatefirmware_versionstringcommunication_module_typestringcustomer_account_numberstringcustomer_first_namestringcustomer_last_namestringcustomer_phonestringcustomer_emailstringservice_address_streetstringservice_address_citystringservice_address_postal_codestringservice_address_countrystringlast_maintenance_datedatenotesstring
A93R-2384JactiveTXLandis+GyrE3502018-05-143.2.1rfCUST-0048SusanMorrison+1-214-555-4819susan.morrison@yahoo.com2442 Cedar LaneDallas75214USA2022-11-09No issues reported.
L321-R9X8TactiveGAItronCentron II2019-08-222.8.4cellularCUST-0136MichaelPeterson+1-404-555-2367michael.peterson@gmail.com1756 Oak Park AveAtlanta30307USA2021-09-15blank
Q84T-ZW871pendingTXSensusFlexNet2020-03-054.1.0plcCUST-0294LindaGupta+1-512-555-1097lgupta@outlook.com9809 Mesa DriveAustin78759USAblankPending activation.
R57N-Y22L8inactiveCOElsterRex22017-12-112.5.7otherCUST-0221RobertChen+1-303-555-9982rchen@icloud.com3174 Parkside CirDenver80205USA2023-02-10Meter removed from service.
M78B-56XP1activeTXLandis+GyrE4502021-07-203.4.2cellularCUST-0048SusanMorrison+1-214-555-4819susan.morrison@yahoo.com2442 Cedar LaneDallas75214USA2022-09-22blank
D42L-X72K9inactiveWASensusFlexNet2016-10-313.0.0rfCUST-0351EmilyNguyen+1-425-555-7426emily.n@gmail.com1154 Maple StreetSeattle98105USA2023-01-04Meter replaced.
K91T-AX9Q2activeFLItronCentron II2022-01-182.9.3plcCUST-0427AnnaGonzalez+1-305-555-6974anna.gonzalez@hotmail.com2221 SW 17th AveMiami33145USA2023-06-28blank
T52P-PL5W7activeILElsterRex32020-12-133.1.9cellularCUST-0193DavidSchmidt+1-630-555-8894d.schmidt@aol.com4675 Magnolia LnChicago60630USA2022-10-01blank

What the 200 rows show

from the 200-row sample
  • 4communication module types
  • 6meter makes
  • 22meter models
enrollment_status200 rows by value
055110101active51%53inactive27%46pending23%
service_address_state200 rows · top 10 of 37 values
  1. TX25
  2. MO18
  3. IL11
  4. CA11
  5. CO10
  6. FL10
  7. WA9
  8. GA8
  9. OH7
  10. AZ7
19 columns by typefrom the column list below
  • string 17
  • date 2

Columns

19 columns in two groups
blueprint · 19 columns
columntypedescriptionexample
Text 17 columns
meter_serial_numberstringUnique serial number assigned to the residential AMI meter.uniqueA93R-2384J
meter_makestringManufacturer of the AMI meter.6 makesLandis+Gyr
meter_modelstringModel name or number of the AMI meter.E350
firmware_versionstringCurrent firmware version installed on the AMI meter.3.2.1
communication_module_typestringType of communication module used in the AMI meter (e.g., cellular, RF, PLC).cellular · rf · plc · otherrf
customer_account_numberstringUnique identifier for the customer account linked to the meter.CUST-0048
customer_first_namestringFirst name of the customer associated with the account.Susan
customer_last_namestringLast name of the customer associated with the account.Morrison
customer_phonestringPrimary phone number of the customer.optional+1-214-555-4819
customer_emailstringEmail address of the customer.optionalsusan.morrison@yahoo.com
service_address_streetstringStreet address of the residential service location.2442 Cedar Lane
service_address_citystringCity of the residential service location.Dallas
service_address_statestringState or province of the residential service location.TX
service_address_postal_codestringPostal code of the residential service location.75214
service_address_countrystringCountry of the residential service location.USA
enrollment_statusstringCurrent enrollment status of the meter (e.g., active, inactive, pending).active · inactive · pendingactive
notesstringAdditional notes or comments regarding the meter or customer account.optionalNo issues reported.
Dates and times 2 columns
installation_datedateDate when the AMI meter was installed at the residential location.2018-05-14
last_maintenance_datedateDate of the last maintenance performed on the meter.optional2022-11-09

Use it for

  • rows20019 columnsrows by enrollment st…101active53inacti…46pending

    An energy dashboard

    A breakdown of service_address_state. Excel, Power BI or Tableau.

  • What pattern can you find in 200 rows?

    A class exercise

    Hand out the rows and one question. Everyone works from the same 200 rows.

  • A software demo

    Believable meter serials with meter_make, meter_model and installation_date to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 19 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 dataset200 rows19 columns
Yours1,000 rows19 columnsservice_address_street: UK only

blueprint · residential-smart-meter-enrollment-and-device-inventory

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 19 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
  • Meter serial number unique identifier
  • Manufacturer (Itron, Landis+Gyr, Sensus, Aclara, etc.)
  • Meter type: electric (single-phase, poly-phase), gas, water
  • Communication technology (RF mesh, cellular, PLC, etc.)
  • Installation date and warranty expiration
  • Firmware version for remote upgrade tracking
  • Customer account number linkage for billing
  • Service location address and GPS coordinates
Rows
Open the blueprint in Data Factory

1 credit per row. New accounts start with 25 free credits.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
residential-smart-meter-enrollment-and-device-inventory

What should your data show?

Preview 20 rows free
No signup. No card.