raw.bls_ppivalidation/bls/bls_ppi_validation_2026_07_21.csvraw_data/bls/ppi/combined_ppi_complete_raw.jsonUsing Google Gemini, I selected 20 random dataseries (10 from each dataset) and 20 random months between January 2016 and May 2026 (the data period ingested).
The datasets are
SELECT * FROM "raw".bls_ppi
WHERE unique_hash in ('PCU324110324110_2017_M04', 'PCU3254123254121_2019_M05', 'PCU333611333611_2021_M05',
'PCU325199325199_2021_M06','PCU441110441110_2022_M11', 'PCU481111481111_2025_M03',
'PCU513110513110_2023_M02', 'PCU522110522110_2018_M05', 'PCU541110541110_2022_M05',
'PCU621111621111_2022_M08', 'WPU0561_2021_M12', 'WPU061_2020_M06',
'WPU081_2024_M05', 'WPU10_2022_M02', 'WPU061302_2021_M11',
'WPU101705_2024_M12', 'WPU1145_2023_M10', 'WPU141101_2024_M04',
'WPU301101_2024_M03', 'WPU451101_2021_M03')
PCU324110324110_2017_M04PCU324110324110: Petroleum refineries (Refined petroleum products, including motor gasoline, diesel, and jet fuel)Data starts on line 5_880_215:
{
"seriesID": "PCU324110324110",
"data": [
...,
{
"year": "2017",
"period": "M04",
"periodName": "April",
"value": "216.1",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| 42699975-287c-415b-a947-ef3cef5588ce | PCU324110324110 | 2017 | M04 | 216.1 | NULL | NULL | PCU324110324110_2017_M04 | 2026-07-21 19:12:45.538324+00 |
PCU3254123254121_2019_M05PCU3254123254121: Pharmaceuticals Affecting Neoplasms, the Endocrine System, and Metabolic DiseasesData starts on line 6_034_973:
{
"seriesID": "PCU3254123254121",
"data": [
...,
{
"year": "2019",
"period": "M05",
"periodName": "May",
"value": "303.7",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| 1ee9908e-bf50-4a90-a25a-a916f1b6a396 | PCU3254123254121 | 2019 | M05 | 303.7 | NULL | NULL | PCU3254123254121_2019_M05 | 2026-07-21 19:12:45.538324+00 |
PCU333611333611_2021_M05PCU333611333611: Turbine and turbine generator set units manufacturingData starts on line 6_973_316:
{
"seriesID": "PCU333611333611",
"data": [
...,
{
"year": "2021",
"period": "M05",
"periodName": "May",
"value": "234.6",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| 0aa4311d-037e-4df1-b547-395a1eaa0e2a | PCU333611333611 | 2021 | M05 | 234.6 | NULL | NULL | PCU333611333611_2021_M05 | 2026-07-21 19:12:45.538324+00 |
PCU325199325199_2021_M06PCU325199325199: All other basic organic chemical manufacturingData starts on line 5_974_362:
{
"seriesID": "PCU325199325199",
"data": [
...,
{
"year": "2021",
"period": "M06",
"periodName": "June",
"value": "198.1",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| 2316fd54-df34-4a5e-bb42-69ab320624cf | PCU325199325199 | 2021 | M06 | 198.1 | NULL | NULL | PCU325199325199_2021_M06 | 2026-07-21 19:12:45.538324+00 |
PCU441110441110_2022_M11PCU441110441110: New car dealersData starts on line 7_765_787:
{
"seriesID": "PCU441110441110",
"data": [
...,
{
"year": "2022",
"period": "M11",
"periodName": "November",
"value": "223.457",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| 6aed9c92-b46f-4b4a-833a-0dd2d9830466 | PCU441110441110 | 2022 | M11 | 223.457 | NULL | NULL | PCU441110441110_2022_M11 | 2026-07-21 19:12:45.538324+00 |
PCU481111481111_2025_M03Data starts on line 7_957_492:
{
"seriesID": "PCU481111481111",
"data": [
...,
{
"year": "2025",
"period": "M03",
"periodName": "March",
"value": "335.527",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| 7b4a404d-9f68-455f-9350-4aff6476e18a | PCU481111481111 | 2025 | M03 | 335.527 | NULL | NULL | PCU481111481111_2025_M03 | 2026-07-21 19:12:45.538324+00 |
PCU513110513110_2023_M02PCU513110513110: Newspaper publishersData starts on line 8_177_699:
{
"seriesID": "PCU513110513110",
"data": [
...,
{
"year": "2023",
"period": "M02",
"periodName": "February",
"value": "99.690",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| 409df3e3-2a60-41b3-b603-ae3bfa046c45 | PCU513110513110 | 2023 | M02 | 99.690 | NULL | NULL | PCU513110513110_2023_M02 | 2026-07-21 19:12:45.538324+00 |
PCU522110522110_2018_M05PCU522110522110: Commercial bankingData starts on line 8_296_020:
{
"seriesID": "PCU522110522110",
"data": [
...,
{
"year": "2018",
"period": "M05",
"periodName": "May",
"value": "107.0",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| cc43cc2f-8b90-4a9f-8d1f-77c826f6ff25 | PCU522110522110 | 2018 | M05 | 107.0 | NULL | NULL | PCU522110522110_2018_M05 | 2026-07-21 19:12:45.538324+00 |
PCU541110541110_2022_M05Data starts on line 8_478_435:
{
"seriesID": "PCU541110541110",
"data": [
...,
{
"year": "2022",
"period": "M05",
"periodName": "May",
"value": "255.237",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| f76aef45-237e-4979-b59d-5fd01bb011c2 | PCU541110541110 | 2022 | M05 | 255.237 | NULL | NULL | PCU541110541110_2022_M05 | 2026-07-21 19:12:45.538324+00 |
PCU621111621111_2022_M08PCU621111621111: Offices of physiciansData starts on line 8_596_158:
{
"seriesID": "PCU621111621111",
"data": [
...,
{
"year": "2022",
"period": "M08",
"periodName": "August",
"value": "154.113",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| e237911d-4222-40ff-846b-8aeb2cfa0dc8 | PCU621111621111 | 2022 | M08 | 154.113 | NULL | NULL | PCU621111621111_2022_M08 | 2026-07-21 19:12:45.538324+00 |
WPU0561_2021_M12WPU0561: Crude petroleum (domestic production)Data starts on line 1_521_285:
{
"seriesID": "WPU0561",
"data": [
...,
{
"year": "2021",
"period": "M12",
"periodName": "December",
"value": "197.098",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| 06a6b0de-625b-4440-9ea3-83f5e3ed022f | WPU0561 | 2021 | M12 | 197.098 | NULL | NULL | WPU0561_2021_M12 | 2026-07-21 19:12:45.538324+00 |
WPU061_2020_M06WPU061: Industrial chemicalsData starts on line 1_566_639:
{
"seriesID": "WPU061",
"data": [
...,
{
"year": "2020",
"period": "M06",
"periodName": "June",
"value": "209.0",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| ff2655f7-770f-4212-bde5-6952bf0cde00 | WPU061 | 2020 | M06 | 209.0 | NULL | NULL | WPU061_2020_M06 | 2026-07-21 19:12:45.538324+00 |
WPU081_2024_M05WPU081:Data starts on line 1_899_484:
{
"seriesID": "WPU081",
"data": [
...,
{
"year": "2024",
"period": "M05",
"periodName": "May",
"value": "250.461",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| 3a8bd2b0-949d-4532-9d14-36dab75d990c | WPU081 | 2024 | M05 | 250.461 | NULL | NULL | WPU081_2024_M05 | 2026-07-21 19:12:45.538324+00 |
WPU10_2022_M02WPU10: Metals and metal productsData starts on line 2_133_774:
{
"seriesID": "WPU10",
"data": [
...,
{
"year": "2022",
"period": "M02",
"periodName": "February",
"value": "330.014",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| f8122f9e-aa9a-477f-b901-54a9ef5d6489 | WPU10 | 2022 | M02 | 330.014 | NULL | NULL | WPU10_2022_M02 | 2026-07-21 19:12:45.538324+00 |
WPU061302_2021_M11Data starts on line 1_568_790:
{
"seriesID": "WPU061302",
"data": [
...,
{
"year": "2021",
"period": "M11",
"periodName": "November",
"value": "304.060",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| 746ed605-d065-4b90-89af-d10011162ea6 | WPU061302 | 2021 | M11 | 304.060 | NULL | NULL | WPU061302_2021_M11 | 2026-07-21 19:12:45.538324+00 |
WPU101705_2024_M12WPU101705: Hot rolled steel sheets and stripData starts on line 2_181_474:
{
"seriesID": "WPU101705",
"data": [
...,
{
"year": "2024",
"period": "M12",
"periodName": "December",
"value": "359.026",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| ea15b27f-630a-4720-a7cb-f8f20790e82a | WPU101705 | 2024 | M12 | 359.026 | NULL | NULL | WPU101705_2024_M12 | 2026-07-21 19:12:45.538324+00 |
WPU1145_2023_M10WPU1145: Electronic computers and computer equipmentData starts on line 2_614_381:
{
"seriesID": "WPU1145",
"data": [
...,
{
"year": "2023",
"period": "M10",
"periodName": "October",
"value": "365.300",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| db0669f6-4891-41a9-8558-f8b63db54952 | WPU1145 | 2023 | M10 | 365.300 | NULL | NULL | WPU1145_2023_M10 | 2026-07-21 19:12:45.538324+00 |
WPU141101_2024_M04WPU141101: Passenger cars (Commodity basis)Data starts on line 3_179_797:
{
"seriesID": "WPU141101",
"data": [
...,
{
"year": "2024",
"period": "M04",
"periodName": "April",
"value": "138.315",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| 7f36c0b3-b0c9-4bc5-a7f0-7b767d7504f1 | WPU141101 | 2024 | M04 | 138.315 | NULL | NULL | WPU141101_2024_M04 | 2026-07-21 19:12:45.538324+00 |
WPU301101_2024_M03WPU301101: Concrete block and brickData starts on line 3_427_559:
{
"seriesID": "WPU301101",
"data": [
...,
{
"year": "2024",
"period": "M03",
"periodName": "March",
"value": "151.960",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| 8f3996c7-aa89-4958-ba93-cb0f9d8bb4b1 | WPU301101 | 2024 | M03 | 151.960 | NULL | NULL | WPU301101_2024_M03 | 2026-07-21 |
WPU451101_2021_M03WPU451101: Freight transportation warehousing and storage servicesData starts on line 3_767_862:
{
"seriesID": "WPU451101",
"data": [
{
"year": "2021",
"period": "M03",
"periodName": "March",
"value": "145.1",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| f7e168f7-e0ae-4abd-bbd9-a5ed006d86c9 | WPU451101 | 2021 | M03 | 145.1 | NULL | NULL | WPU451101_2021_M03 | 2026-07-21 19:12:45.538324+00 |