raw.bls_cpivalidation/bls/cpi_data_validation_2026_07_23.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 2016 and May 2026 (the data period injested).
The datasets are
SELECT * FROM "raw".bls_cpi
WHERE unique_hash in ('CUUR0000SAF111_2021_M05', 'CUUR0100SAH_2025_M07',
'CUURS49ASETB_2022_M06', 'CUUR0000SAA_2021_M10', 'CUUR0300SAM_2016_M12',
'SUUR0000SA0_2016_M05', 'SUUR0000SAF_2017_M06', 'SUUR0000SAH_2018_M05',
'SUUR0000SAT_2017_M03', 'SUUR0000SA0L1E_2022_M10', 'CWUR0000SA0L1E_2018_M08',
'CWUR0200SAH2_2017_M02', 'CWUR0000SETA_2018_M06', 'CWUR0400SAG_2018_M12',
'CWUR0000SEHA_2016_M04', 'APU0000701111_2022_M04', 'APU010072610_2020_M07',
'APU000074714_2023_M03', 'APU0300708111_2018_M04', 'APU0000711311_2023_M11')
CUUR0000SAF111_2021_M05CUUR0000SAF111: Food at home (U.S. City Average)Data starts on line 406_094:
{
"seriesID": "CUUR0000SAF111",
"data": [
...,
{
"year": "2021",
"period": "M05",
"periodName": "May",
"value": "286.649",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| 8d559cdf-4108-4e21-99b1-2bb1f23915a5 | CUUR0000SAF111 | 2021 | M05 | 286.649 | NULL | NULL | CUUR0000SAF111_2021_M05 | 2026-07-23 14:29:41.250491+00 |
CUUR0100SAH_2025_M07CUUR0100SAH: Housing (Northeast Region)Data point begins on line 837_582:
{
"seriesID": "CUUR0100SAH",
"data": [
...,
{
"year": "2025",
"period": "M07",
"periodName": "July",
"value": "372.091",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| 5a5e6d30-4e0b-4771-9b1c-77dfc1568122 | CUUR0100SAH | 2025 | M07 | 372.091 | NULL | NULL | CUUR0100SAH_2025_M07 | 2026-07-21 20:02:46.092349+00 |
CUURS49ASETB_2022_M06CUURS49ASETB: Motor fuel (Los Angeles-Long Beach-Anaheim, CA, Semi-Annual)Data begins on line 3_103_415.
{
"seriesID": "CUURS49ASETB",
"data": [
...,
{
"year": "2022",
"period": "M06",
"periodName": "June",
"value": "480.589",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| f8b83889-5c65-4f08-9d9e-3eb9d2a92d26 | CUURS49ASETB | 2022 | M06 | 480.589 | NULL | NULL | CUURS49ASETB_2022_M06 | 2026-07-21 20:02:46.092349+00 |
CUUR0000SAA_2021_M10CUUR0000SAA: Apparel (U.S. City Average)Data begins on line 384_323.
{
"seriesID": "CUUR0000SAA",
"data": [
...,
{
"year": "2021",
"period": "M10",
"periodName": "October",
"value": "124.323",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| de4dc7a7-c86f-4fbf-8c57-e2e4ad47c33d | CUUR0000SAA | 2021 | M10 | 124.323 | NULL | NULL | CUUR0000SAA_2021_M10 | 2026-07-21 20:02:46.092349+00 |
CUUR0300SAM_2016_M12CUUR0300SAM: Medical care (South Region)Data begins on line 1_237_605.
{
"seriesID": "CUUR0300SAM",
"data": [
...,
{
"year": "2016",
"period": "M12",
"periodName": "December",
"value": "448.393",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| e56d8f79-51ba-4019-911c-e6ebebff701f | CUUR0300SAM | 2016 | M12 | 448.393 | NULL | NULL | CUUR0300SAM_2016_M12 | 2026-07-21 20:02:46.092349+00 |
SUUR0000SA0_2016_M05SUUR0000SA0: All items (U.S. City Average)Data begins on line 7_685_602.
{
"seriesID": "SUUR0000SA0",
"data": [
...,
{
"year": "2016",
"period": "M05",
"periodName": "May",
"value": "136.895",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| 8bb0918a-d700-42e0-b091-37ceadf5c0ba | SUUR0000SA0 | 2016 | M05 | 136.895 | NULL | NULL | SUUR0000SA0_2016_M05 | 2026-07-21 20:02:46.092349+00 |
SUUR0000SAF_2017_M06SUUR0000SAF: Food and beverages (U.S. City Average)Data begins on line 7_695_961.
{
"seriesID": "SUUR0000SAF",
"data": [
...,
{
"year": "2017",
"period": "M06",
"periodName": "June",
"value": "143.015",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| f4ea5d19-e3d5-4936-b8c6-cd53a71ee366 | SUUR0000SAF | 2017 | M06 | 143.015 | NULL | NULL | SUUR0000SAF_2017_M06 | 2026-07-21 20:02:46.092349+00 |
SUUR0000SAH_2018_M05SUUR0000SAH: Housing (U.S. City Average)Data begins on line 7_702_737.
{
"seriesID": "SUUR0000SAH",
"data": [
...,
{
"year": "2018",
"period": "M05",
"periodName": "May",
"value": "151.153",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| c566903f-33c9-4496-9192-eaac1efa11ed | SUUR0000SAH | 2018 | M05 | 151.153 | NULL | NULL | SUUR0000SAH_2018_M05 | 2026-07-21 20:02:46.092349+00 |
SUUR0000SAT_2017_M03SUUR0000SAT: Transportation (U.S. City Average)Data begins on line 7_713_503.
{
"seriesID": "SUUR0000SAT",
"data": [
...,
{
"year": "2017",
"period": "M03",
"periodName": "March",
"value": "135.817",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| 5736ea34-7c30-4773-b6d5-c31f9be0b8c3 | SUUR0000SAT | 2017 | M03 | 135.817 | NULL | NULL | SUUR0000SAT_2017_M03 | 2026-07-21 20:02:46.092349+00 |
SUUR0000SA0L1E_2022_M10SUUR0000SA0L1E: All Items Less Food and Energy for the U.S. City Average, Not Seasonally Adjusted.Data begins on line 7_687_237.
{
"seriesID": "SUUR0000SA0L1E",
"data": [
...,
{
"year": "2022",
"period": "M10",
"periodName": "October",
"value": "156.532",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| cd60a895-073e-41bf-8f4f-058ab1fc4d83 | SUUR0000SA0L1E | 2022 | M10 | 156.532 | NULL | NULL | SUUR0000SA0L1E_2022_M10 | 2026-07-21 20:02:46.092349+00 |
CWUR0000SA0L1E_2018_M08CWUR0000SA0L1E: All items less food and energy (U.S. City Average)Data begins on line 4_243_695.
{
"seriesID": "CWUR0000SA0L1E",
"data": [
...,
{
"year": "2018",
"period": "M08",
"periodName": "August",
"value": "249.601",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| 78a1e5dd-5da9-40a6-891e-f560c7b737cf | CWUR0000SA0L1E | 2018 | M08 | 249.601 | NULL | NULL | CWUR0000SA0L1E_2018_M08 | 2026-07-21 20:02:46.092349+00 |
CWUR0200SAH2_2017_M02CWUR0200SAH2: Fuels and utilities (Midwest Region)Data begins on line 4_827_101.
{
"seriesID": "CWUR0200SAH2",
"data": [
...,
{
"year": "2017",
"period": "M02",
"periodName": "February",
"value": "219.524",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| 73d71ba8-dc14-4412-87dd-24dd77da8637 | CWUR0200SAH2 | 2017 | M02 | 219.524 | NULL | NULL | CWUR0200SAH2_2017_M02 | 2026-07-21 20:02:46.092349+00 |
CWUR0000SETA_2018_M06CWUR0000SETA: New vehicles (U.S. City Average)Data begins on line 4_567_347
{
"seriesID": "CWUR0000SETA",
"data": [
...,
{
"year": "2018",
"period": "M06",
"periodName": "June",
"value": "98.031",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| dec94dde-c573-4da4-bac1-2566555a0ea0 | CWUR0000SETA | 2018 | M06 | 98.031 | NULL | NULL | CWUR0000SETA_2018_M06 | 2026-07-21 20:02:46.092349+00 |
CWUR0400SAG_2018_M12CWUR0400SAG: Other goods and services (West Region)Data begins on line 5_262_506.
{
"seriesID": "CWUR0400SAG",
"data": [
...,
{
"year": "2018",
"period": "M12",
"periodName": "December",
"value": "451.920",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| 83708b5a-2aab-47ff-a62e-ed8e4453164e | CWUR0400SAG | 2018 | M12 | 451.920 | NULL | NULL | CWUR0400SAG_2018_M12 | 2026-07-21 20:02:46.092349+00 |
CWUR0000SEHA_2016_M04CWUR0000SEHA: Rent of primary residence (U.S. City Average)Data begins on line 4_469_667.
{
"seriesID": "CWUR0000SEHA",
"data": [
...,
{
"year": "2016",
"period": "M04",
"periodName": "April",
"value": "291.311",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| 5ada0f7f-3f91-477c-8ad1-5a755f0c0d7c | CWUR0000SEHA | 2016 | M04 | 291.311 | NULL | NULL | CWUR0000SEHA_2016_M04 | 2026-07-21 20:02:46.092349+00 |
APU0000701111_2022_M04APU0000701111: Flour, white, all purpose, per lb. (U.S. City Average)Data begins on line 7_718_765.
{
"seriesID": "APU0000701111",
"data": [
...,
{
"year": "2022",
"period": "M04",
"periodName": "April",
"value": "0.455",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| 1e8620c9-2350-4912-9e59-0eb4f1318516 | APU0000701111 | 2022 | M04 | 0.455 | NULL | NULL | APU0000701111_2022_M04 | 2026-07-21 20:02:46.092349+00 |
APU010072610_2020_M07APU010072610: Electricity per KWH (Northeast Region)Data begins on line 7_817_059.
{
"seriesID": "APU010072610",
"data": [
...,
{
"year": "2020",
"period": "M07",
"periodName": "July",
"value": "0.169",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| 7332c061-1fd4-44d9-bbc6-5908aa28cfe5 | APU010072610 | 2020 | M07 | 0.169 | NULL | NULL | APU010072610_2020_M07 | 2026-07-23 14:29:41.250491+00 |
APU000074714_2023_M03APU000074714: Gasoline, unleaded regular, per gallon (U.S. City Average)Data begins on line 7_772_404.
{
"seriesID": "APU000074714",
"data": [
...,
{
"year": "2023",
"period": "M03",
"periodName": "March",
"value": "3.551",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| f3cf6c18-94c4-4ccc-845d-76aa1e5a9de8 | APU000074714 | 2023 | M03 | 3.551 | NULL | NULL | APU000074714_2023_M03 | 2026-07-21 20:02:46.092349+00 |
APU0300708111_2018_M04APU0300708111: Eggs, grade A, large, per doz. (South Region)Data begins on line 7_938_490.
{
"seriesID": "APU0300708111",
"data": [
...,
{
"year": "2018",
"period": "M04",
"periodName": "April",
"value": "2.097",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| 1fef77dd-ac2a-4093-9337-b8d865d57f6f | APU0300708111 | 2018 | M04 | 2.097 | NULL | NULL | APU0300708111_2018_M04 | 2026-07-21 20:02:46.092349+00 |
APU0000711311_2023_M11APU0000711311: Average Price: Oranges, Navel (Cost per Pound / 453.6 Grams) for the U.S. City Average, Not Seasonally AdjustedData begins on line 7_750_544.
{
"seriesID": "APU0000711311",
"data": [
...,
{
"year": "2023",
"period": "M11",
"periodName": "November",
"value": "1.664",
"footnotes": [
{}
]
},
...
]
}
| id | series_id | year | period | value | footnote_codes | footnote_text | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|
| 11d6d339-423b-4950-953a-369ff2571e80 | APU0000711311 | 2023 | M11 | 1.664 | NULL | NULL | APU0000711311_2023_M11 | 2026-07-21 20:02:46.092349+00 |