Manufacturing Production and Orders (US)
Overview
A US manufacturing economy in miniature, monthly from 2016-01 to 2026-06. 18 sectors, 90 generated manufacturers, 453 plants producing at line grain, with matched orders and backlogs, shipments, inventories, plant employment and sector producer prices. The decade carries the cycle the industry actually lived, stated generically: steady growth to 2019, the 2020 collapse bottoming in April and rebounding, the 2021 to 2022 supply chain boom in which orders outrun shipments, backlogs peak and producer prices spike, the 2023 to 2024 destocking, and a modest late-decade recovery. The tables reconcile by construction and the build re-verifies it: sector production is the exact plant-line sum, and the inventory identity holds exactly on every row: closing inventory equals opening plus production minus shipments, per company, sector and month. Cumulative shipments never exceed cumulative orders. Built for industrial analytics, cycle and inventory modelling, ETL pipelines and BI logic. The licence and disclosure sections state the provenance of the data.
Row Counts by Table
Counted from the files that ship, not estimated.
| Table | Rows |
|---|---|
| usm_production_monthly | 367,850 |
| usm_orders_monthly | 22,177 |
| usm_shipments_monthly | 22,176 |
| usm_inventory_monthly | 22,176 |
| usm_employment_monthly | 57,078 |
| usm_price_index | 2,268 |
| usm_plants | 453 |
| usm_companies | 90 |
| usm_sectors | 18 |
Table Relationships
One parent record and seven child tables, each joined back on the same key.
Schema
Every table ships with typed columns, referential integrity, and documentation.
| Column | Type | Description |
|---|---|---|
| production_id | varchar(16) | Production row key. Primary key. |
| plant_id | varchar(8) | The producing plant. |
| line_number | varchar(8) | Production line within the plant. |
| year_month | varchar(16) | Month of production, 2016-01 to 2026-06. Import as text: spreadsheets convert values like 2020-04 to dates. |
| production_volume | numeric(6,1) | Volume produced. Idle months are missing rows except one documented plant that reports zeros: two conventions, deliberately. |
| volume_unit | varchar(16) | THS_UNITS, thousands of units. |
| Column | Type | Description |
|---|---|---|
| order_id | varchar(16) | Order row key. Primary key. One batch is deliberately posted twice. |
| company_id | varchar(8) | The manufacturer. |
| sector_code | varchar(16) | The sector of the orders. |
| year_month | varchar(16) | Month of the orders. Import as text. |
| new_orders | numeric(8,2) | New orders received in the month. |
| order_backlog | numeric(9,2) | Open orders at month end. Peaks inside the 2021 to 2022 boom. |
| volume_unit | varchar(16) | THS_UNITS. |
+1 more columns in usm_orders_monthly. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| shipment_id | varchar(16) | Shipment row key. Primary key. |
| company_id | varchar(8) | The manufacturer. |
| sector_code | varchar(16) | The sector. |
| year_month | varchar(16) | Month of shipment. Import as text. |
| shipments | numeric(8,2) | Volume shipped. Cumulative shipments never exceed cumulative orders. |
| volume_unit | varchar(16) | THS_UNITS. |
| Column | Type | Description |
|---|---|---|
| inventory_id | varchar(16) | Inventory row key. Primary key. |
| company_id | varchar(8) | The manufacturer. |
| sector_code | varchar(16) | The sector. |
| year_month | varchar(16) | Month end of the balance. Import as text. |
| opening_inventory | numeric(8,2) | Inventory at month start. |
| production_added | numeric(7,1) | Production added during the month. |
| shipments_deducted | numeric(8,2) | Shipments deducted during the month. |
+3 more columns in usm_inventory_monthly. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| employment_id | varchar(16) | Employment row key. Primary key. |
| plant_id | varchar(8) | The plant. |
| year_month | varchar(16) | Month of the headcount. Import as text. |
| headcount | integer | Employees at the plant. One company series deliberately lags its plants by one month. |
| Column | Type | Description |
|---|---|---|
| price_index_id | varchar(8) | Price index row key. Primary key. |
| sector_code | varchar(16) | The sector the index prices. |
| year_month | varchar(16) | Month of the index. Import as text. |
| producer_price_index | numeric(7,2) | Generated producer price index, base 100 in 2016, spiking through 2021 to 2022. |
| Column | Type | Description |
|---|---|---|
| plant_id | varchar(8) | Plant key. Primary key. |
| company_id | varchar(8) | The owning manufacturer. |
| plant_name | varchar(24) | Generated plant name. |
| sector_code | varchar(16) | The sector the plant produces in. |
| state_code | varchar(8) | US state of the plant. |
| opened_year | integer | Year the plant opened. |
| capacity_ths_units_month | integer | Monthly capacity in thousands of units. |
+1 more columns in usm_plants. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| company_id | varchar(8) | Manufacturer key. Primary key. |
| company_name | varchar(40) | Generated manufacturer name. Collisions with real manufacturers are a build failure. |
| primary_sector_code | varchar(16) | The company primary sector. |
| ownership_type | varchar(16) | listed, private or family_owned. |
| founded_year | integer | Year the company was founded. |
| Column | Type | Description |
|---|---|---|
| sector_code | varchar(16) | Sector key. Primary key. |
| sector_name | varchar(40) | The manufacturing sector in words. |
Sample Data
A snapshot of real rows from the dataset (values are fully synthetic).
| production_id | plant_id | line_number | year_month | production_volume | volume_unit |
|---|---|---|---|---|---|
| PR000001 | MP001 | 1 | 2016-01 | 9.7 | THS_UNITS |
| PR000002 | MP001 | 1 | 2016-02 | 10.6 | THS_UNITS |
| PR000003 | MP001 | 1 | 2016-03 | 9.3 | THS_UNITS |
Version History
| v1.0.0 | 2026-08-11 | First release. 18 sectors, 90 manufacturers, 453 plants, monthly production, orders, shipments, an exact inventory identity, employment and producer prices, 2016-01 to 2026-06. |
Related Datasets
Automotive Manufacturing Sales (EU)
ManufacturingA European automotive sales dataset across the electric transition: 12 brands, 112 models, 20 markets, four channels and five customer segments, monthly from 2016 to mid 2026, in which eight legacy European brands peak, crash, and lose a fifth of the market to battery electric entrants while their net debt climbs.
EV Battery Passport Degradation and Circularity Analytics Set (EU)
ManufacturingEU EV battery passport data linking materials, manufacturing, vehicle use, degradation, safety, second life, recycling and circular recovery.
Heavy Equipment BOM Structure (WW)
ManufacturingA heavy-equipment service parts catalogue with real bill-of-materials mechanics: six machine families, 39 variants, trees four to six levels deep with materialised paths, over a million item rows across 124,337 parts, serial-number effectivity, supersession chains with one documented loop, and a derived where-used table that reconciles exactly.