raw.bls_ppivalidation/bls/bls_ppi_validation_2026_08_03.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 2007 and June 2026 (the data period ingested).
The datasets are
SELECT * FROM "raw".bls_ppi
WHERE unique_hash in ('PCU324110324110_2018_M09', 'PCU3254123254121_2008_M09', 'PCU333611333611_2010_M07', 'PCU325199325199_2024_M01', 'PCU441110441110_2019_M03', 'PCU481111481111_2014_M02', 'PCU513110513110_2014_M03', 'PCU522110522110_2019_M08', 'PCU541110541110_2024_M05', 'PCU621111621111_2020_M09', 'WPU0561_2021_M06', 'WPU061_2015_M08', 'WPU081_2016_M11', 'WPU10_2024_M03', 'WPU061302_2009_M07', 'WPU101705_2016_M03', 'WPU1145_2016_M08', 'WPU141101_2013_M11', 'WPU301101_2021_M08', 'WPU451101_2017_M08')
PCU324110324110_2018_M09PCU324110324110: Petroleum refineries (Refined petroleum products, including motor gasoline, diesel, and jet fuel)Data starts on line 9_661_346:
{
"seriesID": "PCU324110324110",
"data": [
...,
{
"year": "2018",
"period": "M09",
"periodName": "September",
"value": "293.5",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| a28f367f-a5c1-4ae6-9811-8f7f6cd54aa2 | PCU324110324110 | 2018 | M09 | 293.5 | NULL | NULL | PCU324110324110_2018_M09 | 2026-07-21 19:12:45.538324+00 |
PCU3254123254121_2008_M09PCU3254123254121: Pharmaceuticals Affecting Neoplasms, the Endocrine System, and Metabolic DiseasesData starts on line 9_934_834:
{
"seriesID": "PCU3254123254121",
"data": [
...,
{
"year": "2008",
"period": "M09",
"periodName": "September",
"value": "157.8",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| 407f2f76-1871-444c-98d8-f9ed19681829 | PCU3254123254121 | 2008 | M09 | 157.8 | NULL | NULL | PCU3254123254121_2008_M09 | 2026-08-03 21:12:08.205749+00 |
PCU333611333611_2010_M07PCU333611333611: Turbine and turbine generator set units manufacturingData starts on line 11_586_313:
{
"seriesID": "PCU333611333611",
"data": [
...,
{
"year": "2010",
"period": "M07",
"periodName": "July",
"value": "210.3",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| e45416c0-3d04-4a8d-ad95-283fb8610e04 | PCU333611333611 | 2010 | M07 | 210.3 | NULL | NULL | PCU333611333611_2010_M07 | 2026-08-03 21:12:08.205749+00 |
PCU325199325199_2024_M01PCU325199325199: All other basic organic chemical manufacturingData starts on line 9_824_943:
{
"seriesID": "PCU325199325199",
"data": [
...,
{
"year": "2024",
"period": "M01",
"periodName": "January",
"value": "230.852",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| 17eef4df-214b-4ea6-85bc-f9811b696c13 | PCU325199325199 | 2024 | M01 | 230.852 | NULL | NULL | PCU325199325199_2024_M01 | 2026-07-21 19:12:45.538324+00 |
PCU441110441110_2019_M03PCU441110441110: New car dealersData starts on line 12_982_423:
{
"seriesID": "PCU441110441110",
"data": [
...,
{
"year": "2019",
"period": "M03",
"periodName": "March",
"value": "156.3",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| c47605b8-f740-4ede-b66e-5f4baf029f59 | PCU441110441110 | 2019 | M03 | 156.3 | NULL | NULL | PCU441110441110_2019_M03 | 2026-07-21 19:12:45.538324+00 |
PCU481111481111_2014_M02Data starts on line 13_302_341:
{
"seriesID": "PCU481111481111",
"data": [
...,
{
"year": "2014",
"period": "M02",
"periodName": "February",
"value": "277.9",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| 44df1bb0-6e8f-4d67-9416-8c4426daf241 | PCU481111481111 | 2014 | M02 | 277.9 | NULL | NULL | PCU481111481111_2014_M02 | 2026-08-03 21:12:08.205749+00 |
PCU513110513110_2024_M03PCU513110513110: Newspaper publishersData starts on line 13_672_746:
{
"seriesID": "PCU513110513110",
"data": [
...,
{
"year": "2024",
"period": "M03",
"periodName": "March",
"value": "101.022",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| bb96d0cd-f9d6-4971-95ca-4b6147e2fc59 | PCU513110513110 | 2024 | M03 | 101.022 | NULL | NULL | PCU513110513110_2024_M03 | 2026-07-21 19:12:45.538324+00 |
PCU522110522110_2019_M08PCU522110522110: Commercial bankingData starts on line 13_869_711:
{
"seriesID": "PCU522110522110",
"data": [
...,
{
"year": "2019",
"period": "M08",
"periodName": "August",
"value": "113.2",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| 20a148a2-a854-436e-a7e9-ba4e274fd29b | PCU522110522110 | 2019 | M08 | 113.2 | NULL | NULL | PCU522110522110_2019_M08 | 2026-07-21 19:12:45.538324+00 |
PCU541110541110_2024_M05PCU541110541110: Offices of lawyersData starts on line 14_194_142:
{
"seriesID": "PCU541110541110",
"data": [
...,
{
"year": "2024",
"period": "M05",
"periodName": "May",
"value": "292.862",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| 4c136f8f-a59f-41b1-ae44-e26759837c79 | PCU541110541110 | 2024 | M05 | 292.862 | NULL | NULL | PCU541110541110_2024_M05 | 2026-07-21 19:12:45.538324+00 |
PCU621111621111_2020_M09PCU621111621111: Offices of physiciansData starts on line 14_398_028:
{
"seriesID": "PCU621111621111",
"data": [
...,
{
"year": "2020",
"period": "M09",
"periodName": "September",
"value": "148.5",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| 847963f9-ba4c-4285-a818-3b2f794635b9 | PCU621111621111 | 2020 | M09 | 148.5 | NULL | NULL | PCU621111621111_2020_M09 | 2026-07-21 19:12:45.538324+00 |
WPU0561_2021_M06WPU0561: Crude petroleum (domestic production)Data starts on line 2_438_382:
{
"seriesID": "WPU0561",
"data": [
...,
{
"year": "2021",
"period": "M06",
"periodName": "June",
"value": "194.0",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| 70811370-1c3d-49ae-b133-9d8710869e8f | WPU0561 | 2021 | M06 | 194.0 | NULL | NULL | WPU0561_2021_M06 | 2026-07-21 19:12:45.538324+00 |
WPU061_2015_M08WPU061: Industrial chemicalsData starts on line 2_521_986:
{
"seriesID": "WPU061",
"data": [
...,
{
"year": "2015",
"period": "M08",
"periodName": "August",
"value": "245.2",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| 54a52161-1727-4282-8cf0-92abd53eb1f5 | WPU061 | 2015 | M08 | 245.2 | NULL | NULL | WPU061_2015_M08 | 2026-08-03 21:12:08.205749+00 |
WPU081_2016_M11WPU081: Lumber and Wood Products - LumberData starts on line 3_070_752:
{
"seriesID": "WPU081",
"data": [
...,
{
"year": "2016",
"period": "M11",
"periodName": "November",
"value": "203.5",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| 71394a31-b1d9-48e6-873e-d73c3781a12d | WPU081 | 2016 | M11 | 203.5 | NULL | NULL | WPU081_2016_M11 | 2026-07-21 19:12:45.538324+00 |
WPU10_2024_M03WPU10: Metals and metal productsData starts on line 3_465_892:
{
"seriesID": "WPU10",
"data": [
...,
{
"year": "2024",
"period": "M03",
"periodName": "March",
"value": "307.579",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| ef39eb8b-c81b-421b-a4a0-ef311fe949e7 | WPU10 | 2024 | M03 | 307.579 | NULL | NULL | WPU10_2024_M03 | 2026-07-21 19:12:45.538324+00 |
WPU061302_2009_M07Data starts on line 2_526_891:
{
"seriesID": "WPU061302",
"data": [
...,
{
"year": "2009",
"period": "M07",
"periodName": "July",
"value": "273.5",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| d1cb79ea-52b3-4a81-8085-834ecb8a4aea | WPU061302 | 2009 | M07 | 273.5 | NULL | NULL | WPU061302_2009_M07 | 2026-08-03 21:12:08.205749+00 |
WPU101705_2016_M03WPU101705: Hot rolled steel sheets and stripData starts on line 3_552_756:
{
"seriesID": "WPU101705",
"data": [
...,
{
"year": "2016",
"period": "M03",
"periodName": "March",
"value": "226.7",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| 0c0250da-555e-4776-b7f7-32fd2c01a024 | WPU101705 | 2016 | M03 | 226.7 | NULL | NULL | WPU101705_2016_M03 | 2026-07-21 19:12:45.538324+00 |
WPU1145_2016_M08WPU1145: Electronic computers and computer equipmentData starts on line 4_316_828:
{
"seriesID": "WPU1145",
"data": [
...,
{
"year": "2016",
"period": "M08",
"periodName": "August",
"value": "260.0",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| 5064c71a-c663-43b0-bd96-2e5498f6e610 | WPU1145 | 2016 | M08 | 260.0 | NULL | NULL | WPU1145_2016_M08 | 2026-07-21 19:12:45.538324+00 |
WPU141101_2013_M11WPU141101: Passenger cars (Commodity basis)Data starts on line 5_293_227:
{
"seriesID": "WPU141101",
"data": [
...,
{
"year": "2013",
"period": "M11",
"periodName": "November",
"value": "131.4",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| 885f3dd2-3c3b-455d-a267-bbd1bf22b574 | WPU141101 | 2013 | M11 | 131.4 | NULL | NULL | WPU141101_2013_M11 | 2026-08-03 21:12:08.205749+00 |
WPU301101_2021_M08WPU301101: Concrete block and brickData starts on line 5_716_127:
{
"seriesID": "WPU301101",
"data": [
...,
{
"year": "2021",
"period": "M08",
"periodName": "August",
"value": "135.918",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| e56b6fde-ee5b-49d1-a1a7-c2671bb17528 | WPU301101 | 2021 | M08 | 135.918 | NULL | NULL | WPU301101_2021_M08 | 2026-07-21 19:12:45.538324+00 |
WPU451101_2017_M08WPU451101: Freight transportation warehousing and storage servicesData starts on line 6_262_020:
{
"seriesID": "WPU451101",
"data": [
...,
{
"year": "2017",
"period": "M08",
"periodName": "August",
"value": "127.7",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| b23d2ec0-43d8-4a1b-a959-97b448df3c0f | WPU451101 | 2017 | M08 | 127.7 | NULL | NULL | WPU451101_2017_M08 | 2026-07-21 19:12:45.538324+00 |