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.
Sample rows
preview · 8 of 200 rows · all 19 columns| meter_serial_numberstring | enrollment_statusstring | service_address_statestring | meter_makestring | meter_modelstring | installation_datedate | firmware_versionstring | communication_module_typestring | customer_account_numberstring | customer_first_namestring | customer_last_namestring | customer_phonestring | customer_emailstring | service_address_streetstring | service_address_citystring | service_address_postal_codestring | service_address_countrystring | last_maintenance_datedate | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A93R-2384J | active | TX | Landis+Gyr | E350 | 2018-05-14 | 3.2.1 | rf | CUST-0048 | Susan | Morrison | +1-214-555-4819 | susan.morrison@ | 2442 Cedar Lane | Dallas | 75214 | USA | 2022-11-09 | No issues reported. |
| L321-R9X8T | active | GA | Itron | Centron II | 2019-08-22 | 2.8.4 | cellular | CUST-0136 | Michael | Peterson | +1-404-555-2367 | michael.peterson@ | 1756 Oak Park Ave | Atlanta | 30307 | USA | 2021-09-15 | blank |
| Q84T-ZW871 | pending | TX | Sensus | FlexNet | 2020-03-05 | 4.1.0 | plc | CUST-0294 | Linda | Gupta | +1-512-555-1097 | lgupta@ | 9809 Mesa Drive | Austin | 78759 | USA | blank | Pending activation. |
| R57N-Y22L8 | inactive | CO | Elster | Rex2 | 2017-12-11 | 2.5.7 | other | CUST-0221 | Robert | Chen | +1-303-555-9982 | rchen@ | 3174 Parkside Cir | Denver | 80205 | USA | 2023-02-10 | Meter removed from service. |
| M78B-56XP1 | active | TX | Landis+Gyr | E450 | 2021-07-20 | 3.4.2 | cellular | CUST-0048 | Susan | Morrison | +1-214-555-4819 | susan.morrison@ | 2442 Cedar Lane | Dallas | 75214 | USA | 2022-09-22 | blank |
| D42L-X72K9 | inactive | WA | Sensus | FlexNet | 2016-10-31 | 3.0.0 | rf | CUST-0351 | Emily | Nguyen | +1-425-555-7426 | emily.n@ | 1154 Maple Street | Seattle | 98105 | USA | 2023-01-04 | Meter replaced. |
| K91T-AX9Q2 | active | FL | Itron | Centron II | 2022-01-18 | 2.9.3 | plc | CUST-0427 | Anna | Gonzalez | +1-305-555-6974 | anna.gonzalez@ | 2221 SW 17th Ave | Miami | 33145 | USA | 2023-06-28 | blank |
| T52P-PL5W7 | active | IL | Elster | Rex3 | 2020-12-13 | 3.1.9 | cellular | CUST-0193 | David | Schmidt | +1-630-555-8894 | d.schmidt@ | 4675 Magnolia Ln | Chicago | 60630 | USA | 2022-10-01 | blank |
| Z21F-MT2B5 | pending | GA | Landis+Gyr | E350 | 2015-06-25 | 2.2.4 | rf | CUST-0136 | Michael | Peterson | +1-404-555-2367 | michael.peterson@ | 1756 Oak Park Ave | Atlanta | 30307 | USA | 2022-08-13 | Awaiting verification. |
| W47H-9B6Q1 | active | NV | Sensus | FlexNet | 2023-03-18 | 4.3.2 | cellular | CUST-0538 | Jennifer | King | +1-702-555-4720 | jen.king@ | 6894 Desert Willow Dr | Las Vegas | 89103 | USA | blank | New meter installation. |
| J83B-3L4C6 | inactive | TX | Itron | Centron II | 2018-09-29 | 3.0.2 | rf | CUST-0294 | Linda | Gupta | +1-512-555-1097 | lgupta@ | 9809 Mesa Drive | Austin | 78759 | USA | 2022-07-20 | Customer requested meter swap. |
| G24L-Q38Z2 | inactive | CO | Elster | Rex2 | 2017-03-04 | 2.9.1 | other | CUST-0221 | Robert | Chen | +1-303-555-9982 | rchen@ | 3174 Parkside Cir | Denver | 80205 | USA | blank | Device not communicating. |
| E65F-5N2V8 | active | MO | Landis+Gyr | E350 | 2019-11-15 | 3.2.8 | cellular | CUST-0562 | Paul | Jenkins | +1-816-555-2519 | pjenkins@ | 3945 Swope Parkway | Kansas City | 64130 | USA | blank | blank |
| P65M-1L7X3 | active | FL | Sensus | FlexNet | 2021-02-10 | 4.0.6 | rf | CUST-0427 | Anna | Gonzalez | +1-305-555-6974 | anna.gonzalez@ | 2221 SW 17th Ave | Miami | 33145 | USA | 2022-12-30 | blank |
| S41Z-W8N2B | inactive | WA | Itron | Centron II | 2018-04-01 | 2.7.4 | plc | CUST-0351 | Emily | Nguyen | +1-425-555-7426 | emily.n@ | 1154 Maple Street | Seattle | 98105 | USA | 2021-05-10 | blank |
| N18J-92Y5B | active | NV | Elster | Rex3 | 2022-10-09 | 3.3.7 | cellular | CUST-0538 | Jennifer | King | +1-702-555-4720 | jen.king@ | 6894 Desert Willow Dr | Las Vegas | 89103 | USA | 2023-07-02 | blank |
| U23L-7Q5T1 | pending | MO | Landis+Gyr | E450 | 2016-08-16 | 2.6.0 | rf | CUST-0562 | Paul | Jenkins | +1-816-555-2519 | pjenkins@ | 3945 Swope Parkway | Kansas City | 64130 | USA | blank | Enrollment to be finalized. |
| H57R-V6P1K | inactive | IL | Sensus | FlexNet | 2020-07-10 | 4.1.5 | plc | CUST-0193 | David | Schmidt | +1-630-555-8894 | d.schmidt@ | 4675 Magnolia Ln | Chicago | 60630 | USA | 2022-11-22 | blank |
| B35N-4Q7T1 | pending | FL | Elster | Rex2 | 2021-09-05 | 3.2.0 | other | CUST-0427 | Anna | Gonzalez | +1-305-555-6974 | anna.gonzalez@ | 2221 SW 17th Ave | Miami | 33145 | USA | blank | Awaiting service order. |
| F52J-8T1W9 | active | GA | Landis+Gyr | E350 | 2017-07-21 | 2.5.9 | cellular | CUST-0136 | Michael | Peterson | +1-404-555-2367 | michael.peterson@ | 1756 Oak Park Ave | Atlanta | 30307 | USA | 2022-01-19 | Firmware updated. |
What the 200 rows show
from the 200-row sample- 4communication module types
- 6meter makes
- 22meter models
- string 17
- date 2
Columns
19 columns in two groups| column | type | description | example |
|---|---|---|---|
| Text 17 columns | |||
meter_serial_number | string | Unique serial number assigned to the residential AMI meter.unique | A93R-2384J |
meter_make | string | Manufacturer of the AMI meter.6 makes | Landis+Gyr |
meter_model | string | Model name or number of the AMI meter. | E350 |
firmware_version | string | Current firmware version installed on the AMI meter. | 3.2.1 |
communication_module_type | string | Type of communication module used in the AMI meter (e.g., cellular, RF, PLC).cellular · rf · plc · other | rf |
customer_account_number | string | Unique identifier for the customer account linked to the meter. | CUST-0048 |
customer_first_name | string | First name of the customer associated with the account. | Susan |
customer_last_name | string | Last name of the customer associated with the account. | Morrison |
customer_phone | string | Primary phone number of the customer.optional | +1-214-555-4819 |
customer_email | string | Email address of the customer.optional | susan.morrison@ |
service_address_street | string | Street address of the residential service location. | 2442 Cedar Lane |
service_address_city | string | City of the residential service location. | Dallas |
service_address_state | string | State or province of the residential service location. | TX |
service_address_postal_code | string | Postal code of the residential service location. | 75214 |
service_address_country | string | Country of the residential service location. | USA |
enrollment_status | string | Current enrollment status of the meter (e.g., active, inactive, pending).active · inactive · pending | active |
notes | string | Additional notes or comments regarding the meter or customer account.optional | No issues reported. |
| Dates and times 2 columns | |||
installation_date | date | Date when the AMI meter was installed at the residential location. | 2018-05-14 |
last_maintenance_date | date | Date of the last maintenance performed on the meter.optional | 2022-11-09 |
Use it for
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.
- Meter serials200A93R-2384JactiveL321-R9X8TactiveQ84T-ZW871pending
A software demo
Believable meter serials with meter_
make, meter_ model and installation_ date to fill a screen in front of a buyer.
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.
- 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
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