Generate fake AMI Field Operations data

A water-meter replacement contractor: installers, cycles, accounts, and work orders. Mirrors the Umbra demo shape — the base template the Data Detective game extends.

Generate AMI Field Operations data →Browse all generators

CSV exportJSON exportSQL exportSQLite exportdeterministicno signup

What's in this dataset

installers

table

Field	Type
`installer_id`	integer
`name`	text
`region`	text
`crew`	text

cycles

table

Field	Type
`region`	text
`region_abbr`	text
`cycle_code`	text
`total_accounts`	integer
`progress`	decimal
`installed_count`	integer
`open_wo_count`	integer
`pct_complete`	decimal
`status`	text
`last_refreshed_at`	text

accounts

child table

Field	Type
`account_id`	integer
`address`	text
`region`	text
`cycle_code`	text
`meter_size`	text
`status`	text
`old_serial`	text
`new_serial`	text
`install_date`	text
`installer`	text

work_orders

child table

Field	Type
`wo_id`	integer
`account_id`	integer
`cycle_code`	text
`region`	text
`wo_type`	text
`status`	text
`issue`	text
`installer`	text
`created_date`	date
`closed_date`	text

What you can do with it

Seed a database or demo environment
Build dashboards & BI prototypes
Test imports, forms, and pipelines
Teach SQL or data analysis
Download as CSV, JSON, SQL, or SQLite
Reproducible — same seed, same data

Open the AMI Field Operations generator →

Need 100k+ rows, an API, or no limits?

Join the Pro waitlist — bulk generation, JSON/SQL/Excel export, and a developer API for generating data on demand.