raw.bls_cpivalidation/bls/bls_cpi_validation_2026_08_06.csvraw_data/bls/cpi/cpi_raw_data.jsonUsing Google Gemini, I selected 20 random dataseries (5 from each dataset) and 20 random months between January 2007 and June 2026 (the data period injested).
The datasets are
SELECT * FROM "raw".bls_cpi
WHERE unique_hash in ('CUUR0000SAF111_2014_M10', 'CUUR0100SAH_2025_M09',
'CUURS49ASETB_2009_M01', 'CUUR0000SAA_2009_M07', 'CUUR0300SAM_2023_M10',
'SUUR0000SA0_2022_M01', 'SUUR0000SAF_2019_M04', 'SUUR0000SAH_2016_M05',
'SUUR0000SAT_2011_M08', 'SUUR0000SA0L1E_2017_M08', 'CWUR0000SA0L1E_2024_M03',
'CWUR0200SAH2_2012_M10', 'CWUR0000SETA_2007_M10', 'CWUR0400SAG_2024_M10',
'CWUR0000SEHA_2025_M12', 'APU0000701111_2025_M10', 'APU010072610_2023_M05',
'APU000074714_2008_M08', 'APU0300708111_2016_M02', 'APU0000711311_2008_M04')
CUUR0000SAF111_2014_M10CUUR0000SAF111: Food at home (U.S. City Average)Data starts on line 740_183:
{
"seriesID": "CUUR0000SAF111",
"data": [
...,
{
"year": "2014",
"period": "M10",
"periodName": "October",
"value": "271.313",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| 8b8a3ad1-15b3-4f73-b193-9474e19cf7e9 | CUUR0000SAF111 | 2014 | M10 | 271.313 | NULL | NULL | CUUR0000SAF111_2014_M10 | 2026-08-06 18:53:02.491663+00 |
CUUR0100SAH_2025_M09CUUR0100SAH: Housing (Northeast Region)Data point begins on line 1_530_484:
{
"seriesID": "CUUR0100SAH",
"data": [
...,
{
"year": "2025",
"period": "M09",
"periodName": "September",
"value": "372.529",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| d9ec8bee-8bd1-4122-a87b-8af6bef18d0e | CUUR0100SAH | 2025 | M09 | 372.529 | NULL | NULL | CUUR0100SAH_2025_M09 | 2026-07-21 20:02:46.092349+00 |
CUURS49ASETB_2009_M01CUURS49ASETB: Motor fuel (Los Angeles-Long Beach-Anaheim, CA, Semi-Annual)Data begins on line 4_967_062.
{
"seriesID": "CUURS49ASETB",
"data": [
...,
{
"year": "2009",
"period": "M01",
"periodName": "January",
"value": "156.258",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| 2de884ae-69eb-46c8-b80f-a7ec1fdc4418 | CUURS49ASETB | 2009 | M01 | 156.258 | NULL | NULL | CUURS49ASETB_2009_M01 | 2026-08-06 18:53:02.491663+00 |
CUUR0000SAA_2009_M07CUUR0000SAA: Apparel (U.S. City Average)Data begins on line 701_169.
{
"seriesID": "CUUR0000SAA",
"data": [
...,
{
"year": "2009",
"period": "M07",
"periodName": "July",
"value": "115.620",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| e8f1a39b-a778-453f-8491-0feefe1406ce | CUUR0000SAA | 2009 | M07 | 115.620 | NULL | NULL | CUUR0000SAA_2009_M07 | 2026-08-06 18:53:02.491663+00 |
CUUR0300SAM_2023_M10CUUR0300SAM: Medical care (South Region)Data begins on line 2_066_722.
{
"seriesID": "CUUR0300SAM",
"data": [
...,
{
"year": "2023",
"period": "M10",
"periodName": "October",
"value": "520.015",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| 8d4f67d8-c720-412f-8dbc-f832ab68716f | CUUR0300SAM | 2023 | M10 | 520.015 | NULL | NULL | CUUR0300SAM_2023_M10 | 2026-07-21 20:02:46.092349+00 |
SUUR0000SA0_2022_M01SUUR0000SA0: All items (U.S. City Average)Data begins on line 12_048_827.
{
"seriesID": "SUUR0000SA0",
"data": [
...,
{
"year": "2022",
"period": "M01",
"periodName": "January",
"value": "157.178",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| 10213cea-f098-4c38-865f-2b553f8a4a17 | SUUR0000SA0 | 2022 | M01 | 157.178 | NULL | NULL | SUUR0000SA0_2022_M01 | 2026-07-21 20:02:46.092349+00 |
SUUR0000SAF_2019_M04SUUR0000SAF: Food and beverages (U.S. City Average)Data begins on line 12_068_348.
{
"seriesID": "SUUR0000SAF",
"data": [
...,
{
"year": "2019",
"period": "M04",
"periodName": "April",
"value": "147.227",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| c0e1ba80-f202-46ee-b78c-15422f371e7a | SUUR0000SAF | 2019 | M04 | 147.227 | NULL | NULL | SUUR0000SAF_2019_M04 | 2026-07-21 20:02:46.092349+00 |
SUUR0000SAH_2016_M05SUUR0000SAH: Housing (U.S. City Average)Data begins on line 12_079_424.
{
"seriesID": "SUUR0000SAH",
"data": [
...,
{
"year": "2016",
"period": "M05",
"periodName": "May",
"value": "142.966",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| 0dedadde-d1e9-419b-ab89-504732e3f49f | SUUR0000SAH | 2016 | M05 | 142.966 | NULL | NULL | SUUR0000SAH_2016_M05 | 2026-07-21 20:02:46.092349+00 |
SUUR0000SAT_2011_M08SUUR0000SAT: Transportation (U.S. City Average)Data begins on line 12_101_297.
{
"seriesID": "SUUR0000SAT",
"data": [
...,
{
"year": "2011",
"period": "M08",
"periodName": "August",
"value": "145.320",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| 2519d875-2200-41ee-b353-103c8667425e | SUUR0000SAT | 2011 | M08 | 145.320 | NULL | NULL | SUUR0000SAT_2011_M08 | 2026-08-06 18:53:02.491663+00 |
SUUR0000SA0L1E_2017_M08SUUR0000SA0L1E: All Items Less Food and Energy for the U.S. City Average, Not Seasonally Adjusted.Data begins on line 12_053_576.
{
"seriesID": "SUUR0000SA0L1E",
"data": [
...,
{
"year": "2017",
"period": "M08",
"periodName": "August",
"value": "134.152",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| f8a25acd-89db-47f4-93a5-3fd08eea28b6 | SUUR0000SA0L1E | 2017 | M08 | 134.152 | NULL | NULL | SUUR0000SA0L1E_2017_M08 | 2026-07-21 20:02:46.092349+00 |
CWUR0000SA0L1E_2024_M03CWUR0000SA0L1E: All items less food and energy (U.S. City Average)Data begins on line 6_743_216.
{
"seriesID": "CWUR0000SA0L1E",
"data": [
...,
{
"year": "2024",
"period": "M03",
"periodName": "March",
"value": "308.358",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| 2ba64eb3-1ab9-4b5b-a7be-af9cdb2a419c | CWUR0000SA0L1E | 2024 | M03 | 308.358 | NULL | NULL | CWUR0000SA0L1E_2024_M03 | 2026-07-21 20:02:46.092349+00 |
CWUR0200SAH2_2012_M10CWUR0200SAH2: Fuels and utilities (Midwest Region)Data begins on line 7_716_687.
{
"seriesID": "CWUR0200SAH2",
"data": [
...,
{
"year": "2012",
"period": "M10",
"periodName": "October",
"value": "203.420",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| 1237bd71-1811-43b9-80dd-f44df6a76140 | CWUR0200SAH2 | 2012 | M10 | 203.420 | NULL | NULL | CWUR0200SAH2_2012_M10 | 2026-08-06 18:53:02.491663+00 |
CWUR0000SETA_2007_M10CWUR0000SETA: New vehicles (U.S. City Average)Data begins on line 7_340_603
{
"seriesID": "CWUR0000SETA",
"data": [
...,
{
"year": "2007",
"period": "M10",
"periodName": "October",
"value": "93.268",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| 0bb7a76e-ad5f-494f-a1d6-0419ac8dc3af | CWUR0000SETA | 2007 | M10 | 93.268 | NULL | NULL | CWUR0000SETA_2007_M10 | 2026-08-06 18:53:02.491663+00 |
CWUR0400SAG_2024_M10CWUR0400SAG: Other goods and services (West Region)Data begins on line 8_276_774.
{
"seriesID": "CWUR0400SAG",
"data": [
...,
{
"year": "2024",
"period": "M10",
"periodName": "October",
"value": "576.291",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| b77183c5-93eb-4ace-a944-c10599db7851 | CWUR0400SAG | 2024 | M10 | 576.291 | NULL | NULL | CWUR0400SAG_2024_M10 | 2026-07-21 20:02:46.092349+00 |
CWUR0000SEHA_2025_M12CWUR0000SEHA: Rent of primary residence (U.S. City Average)Data begins on line 7_157_959.
{
"seriesID": "CWUR0000SEHA",
"data": [
...,
{
"year": "2025",
"period": "M12",
"periodName": "December",
"value": "438.560",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| 5c251245-6668-4a43-9850-efe707525779 | CWUR0000SEHA | 2025 | M12 | 438.560 | NULL | NULL | CWUR0000SEHA_2025_M12 | 2026-07-21 20:02:46.092349+00 |
APU0000701111_2025_M10APU0000701111: Flour, white, all purpose, per lb. (U.S. City Average)Data begins on line 12_110_435.
{
"seriesID": "APU0000701111",
"data": [
...,
{
"year": "2025",
"period": "M10",
"periodName": "October",
"value": "-",
"footnotes": [
{
"code": "X",
"text": "Data unavailable due to the 2025 lapse in appropriations"
}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| be3fecaf-49d0-4660-9226-207a88e6bc66 | APU0000701111 | 2025 | M10 | NULL | X | unavailable due to the 2025 lapse in appropriations | APU0000701111_2025_M10 | 2026-07-21 20:02:46.092349+00 |
APU010072610_2023_M05APU010072610: Electricity per KWH (Northeast Region)Data begins on line 12_300_472.
{
"seriesID": "APU010072610",
"data": [
...,
{
"year": "2023",
"period": "M05",
"periodName": "May",
"value": "0.216",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| f651b2d6-07d8-4bf5-84d2-7904ef1397c4 | APU010072610 | 2023 | M05 | 0.216 | NULL | NULL | APU010072610_2023_M05 | 2026-07-23 14:29:41.250491+00 |
APU000074714_2008_M08APU000074714: Gasoline, unleaded regular, per gallon (U.S. City Average)Data begins on line 12_217_669.
{
"seriesID": "APU000074714",
"data": [
...,
{
"year": "2008",
"period": "M08",
"periodName": "August",
"value": "3.786",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| d1a898f8-b152-4fac-a4d8-bf22e67a2a15 | APU000074714 | 2008 | M08 | 3.786 | NULL | NULL | APU000074714_2008_M08 | 2026-08-06 18:53:02.491663+00 |
APU0300708111_2016_M02APU0300708111: Eggs, grade A, large, per doz. (South Region)Data begins on line 12_513_857.
{
"seriesID": "APU0300708111",
"data": [
...,
{
"year": "2016",
"period": "M02",
"periodName": "February",
"value": "2.295",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| d934b6f9-6a82-4c28-b459-1154849ad6b1 | APU0300708111 | 2016 | M02 | 2.295 | NULL | NULL | APU0300708111_2016_M02 | 2026-07-21 20:02:46.092349+00 |
APU0000711311_2008_M04APU0000711311: Average Price: Oranges, Navel (Cost per Pound / 453.6 Grams) for the U.S. City Average, Not Seasonally AdjustedData begins on line 12_173_357.
{
"seriesID": "APU0000711311",
"data": [
...,
{
"year": "2008",
"period": "M04",
"periodName": "April",
"value": "0.931",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| 60b07d85-7a2f-4884-8430-85c019f5542f | APU0000711311 | 2008 | M04 | 0.931 | NULL | NULL | APU0000711311_2008_M04 | 2026-08-06 18:53:02.491663+00 |