raw.acs_2024_coGenerated Columns
idunique_hash = state_fips + county_fips + metric.date_uploaded: timestampUsing Google Gemini, I randomly selected 20 counties (each in a different state) and subject table "variables" (or metrics).
Query:
SELECT * FROM "raw".acs5_2024_co
WHERE unique_hash in ('04003S0101_C03_026', '05125S1401_C01_011', '06065S2401_C01_002', '08041S1902_C01_001', '09110S2801_C01_001', '16001S1810_C03_001', '23003S0801_C01_002', '25025S2201_C02_021', '28059S0804_C01_010', '30049S0802_C01_001', '31153S0101_C01_001', '32510S2501_C01_001', '34005S1601_C02_003', '36061S1901_C01_013', '37183S0501_C01_021', '42101S1501_C01_006', '48141S0701_C01_002', '50025S1101_C01_013', '51810S2502_C01_002', '54011S1301_C01_001')
The query results are saved in the file: data_downloader\validation\acs5_2024\acs5_county_2026_06_22.csv
unique_hash: 04003S0101_C03_026
[["NAME","S0101_C03_026E","S0101_C03_026EA","S0101_C03_026M","S0101_C03_026MA","state","county"],
["Cochise County, Arizona","50652",null,"-555555555","*****","04","003"]]
Source: https://api.census.gov/data/2024/acs/acs5/subject/variables/S0101_C03_026E.json
{
"name": "S0101_C03_026E",
"label": "Estimate!!Male!!Total population!!SELECTED AGE CATEGORIES!!18 years and over",
"concept": "Age and Sex",
"predicateType": "int",
"group": "S0101",
"limit": 0,
"attributes": "S0101_C03_026EA,S0101_C03_026M,S0101_C03_026MA"
}
| id | geo_id | name | state | county | metric | estimate | estimate_flag | margin | margin_flag | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1bb9c622-85bb-4009-aa3d-dd59d47a1e5e | 0500000US04003 | Cochise County, Arizona | 04 | 003 | S0101_C03_026 | 50652 | NULL | -555555555 | ***** | 04003S0101_C03_026 | 2026-06-22 17:13:49.208119+00 |
unique_hash: 05125S1401_C01_011
[["NAME","S1401_C01_011E","S1401_C01_011EA","S1401_C01_011M","S1401_C01_011MA","state","county"],
["Saline County, Arkansas","1650",null,"382",null,"05","125"]]
| id | geo_id | name | state | county | metric | estimate | estimate_flag | margin | margin_flag | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1442c6c5-259a-42fe-9f06-5ec807f437d0 | 0500000US05125 | Saline County, Arkansas | 05 | 125 | S1401_C01_011 | 1650 | NULL | 382 | NULL | 05125S1401_C01_011 | 2026-06-22 17:14:56.041877+00 |
unique_hash: 06065S2401_C01_002
[["NAME","S2401_C01_002E","S2401_C01_002EA","S2401_C01_002M","S2401_C01_002MA","state","county"],
["Riverside County, California","374353",null,"4938",null,"06","065"]]
| id | geo_id | name | state | county | metric | estimate | estimate_flag | margin | margin_flag | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 5f020ed3-a114-469e-bb92-271d84fe8eb1 | 0500000US06065 | Riverside County, California | 06 | 065 | S2401_C01_002 | 374353 | NULL | 4938 | NULL | 06065S2401_C01_002 | 2026-06-22 17:16:28.533364+00 |
unique_hash: 08041S1902_C01_001
[["NAME","S1902_C01_001E","S1902_C01_001EA","S1902_C01_001M","S1902_C01_001MA","state","county"],
["El Paso County, Colorado","290190",null,"1184",null,"08","041"]]
| id | geo_id | name | state | county | metric | estimate | estimate_flag | margin | margin_flag | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 7f00974b-401c-4130-bd0e-b74ea5286f63 | 0500000US08041 | El Paso County, Colorado | 08 | 041 | S1902_C01_001 | 290190 | NULL | 1184 | NULL | 08041S1902_C01_001 | 2026-06-22 17:17:35.875177+00 |
unique_hash: 09110S2801_C01_001
[["NAME","S2801_C01_001E","S2801_C01_001EA","S2801_C01_001M","S2801_C01_001MA","state","county"],
["Capitol Planning Region, Connecticut","391113",null,"1213",null,"09","110"]]
| id | geo_id | name | state | county | metric | estimate | estimate_flag | margin | margin_flag | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 34cf6805-aedb-4293-93a7-088eac760991 | 0500000US09110 | Capitol Planning Region, Connecticut | 09 | 110 | S2801_C01_001 | 391113 | NULL | 1213 | NULL | 09110S2801_C01_001 | 2026-06-22 17:18:39.88006+00 |
unique_hash: 16001S1810_C03_001
[["NAME","S1810_C03_001E","S1810_C03_001EA","S1810_C03_001M","S1810_C03_001MA","state","county"],
["Ada County, Idaho","11.8",null,"0.4",null,"16","001"]]
| id | geo_id | name | state | county | metric | estimate | estimate_flag | margin | margin_flag | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|
| b2fbf600-0931-407b-9441-68db27339765 | 0500000US16001 | Ada County, Idaho | 16 | 001 | S1810_C03_001 | 11.8 | NULL | 0.4 | NULL | 16001S1810_C03_001 | 2026-06-22 17:25:06.494445+00 |
unique_hash: 23003S0801_C01_002
[["NAME","S0801_C01_002E","S0801_C01_002EA","S0801_C01_002M","S0801_C01_002MA","state","county"],
["Aroostook County, Maine","87.4",null,"1.3",null,"23","003"]]
| id | geo_id | name | state | county | metric | estimate | estimate_flag | margin | margin_flag | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|
| ee4e15d1-d1dc-405f-a913-e6a80b56d872 | 0500000US23003 | Aroostook County, Maine | 23 | 003 | S0801_C01_002 | 87.4 | NULL | 1.3 | NULL | 23003S0801_C01_002 | 2026-06-22 17:43:02.899184+00 |
unique_hash: 25025S2201_C02_021
[["NAME","S2201_C02_021E","S2201_C02_021EA","S2201_C02_021M","S2201_C02_021MA","state","county"],
["Suffolk County, Massachusetts","16.9",null,"0.6",null,"25","025"]]
| id | geo_id | name | state | county | metric | estimate | estimate_flag | margin | margin_flag | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 5d4dd92f-c10a-4c69-9585-b4d7520b41e2 | 0500000US25025 | Suffolk County, Massachusetts | 25 | 025 | S2201_C02_021 | 16.9 | NULL | 0.6 | NULL | 25025S2201_C02_021 | 2026-06-22 17:44:59.729454+00 |
unique_hash: 28059S0804_C01_010
[["NAME","S0804_C01_010E","S0804_C01_010EA","S0804_C01_010M","S0804_C01_010MA","state","county"],
["Jackson County, Mississippi","45.5",null,"1.6",null,"28","059"]]
| id | geo_id | name | state | county | metric | estimate | estimate_flag | margin | margin_flag | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 03e84204-8617-45cd-b217-7b8db13156f0 | 0500000US28059 | Jackson County, Mississippi | 28 | 059 | S0804_C01_010 | 45.5 | NULL | 1.6 | NULL | 28059S0804_C01_010 | 2026-06-22 17:51:57.226509+00 |
unique_hash: 30049S0802_C01_001
[["NAME","S0802_C01_001E","S0802_C01_001EA","S0802_C01_001M","S0802_C01_001MA","state","county"],
["Lewis and Clark County, Montana","36698",null,"841",null,"30","049"]]
| id | geo_id | name | state | county | metric | estimate | estimate_flag | margin | margin_flag | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 5fad4e94-a580-49a8-b461-cfc62f84be63 | 0500000US30049 | Lewis and Clark County, Montana | 30 | 049 | S0802_C01_001 | 36698 | NULL | 841 | NULL | 30049S0802_C01_001 | 2026-06-22 17:59:51.99465+00 |
unique_hash: 31153S0101_C01_001
[["NAME","S0101_C01_001E","S0101_C01_001EA","S0101_C01_001M","S0101_C01_001MA","state","county"],
["Sarpy County, Nebraska","197389",null,"-555555555","*****","31","153"]]
| id | geo_id | name | state | county | metric | estimate | estimate_flag | margin | margin_flag | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|
| c5412bca-d065-417b-92e7-910533207cc8 | 0500000US31153 | Sarpy County, Nebraska | 31 | 153 | S0101_C01_001 | 197389 | NULL | -555555555 | ***** | 31153S0101_C01_001 | 2026-06-22 18:03:43.256466+00 |
unique_hash: 32510S2501_C01_001
[["NAME","S2501_C01_001E","S2501_C01_001EA","S2501_C01_001M","S2501_C01_001MA","state","county"],
["Carson City, Nevada","23692",null,"385",null,"32","510"]]
| id | geo_id | name | state | county | metric | estimate | estimate_flag | margin | margin_flag | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1a8df815-84ed-40f3-a8c8-2fe7595d9082 | 0500000US32510 | Carson City, Nevada | 32 | 510 | S2501_C01_001 | 23692 | NULL | 385 | NULL | 32510S2501_C01_001 | 2026-06-22 18:11:18.616808+00 |
unique_hash: 34005S1601_C02_003
[["NAME","S1601_C02_003E","S1601_C02_003EA","S1601_C02_003M","S1601_C02_003MA","state","county"],
["Burlington County, New Jersey","14.5",null,"0.5",null,"34","005"]]
| id | geo_id | name | state | county | metric | estimate | estimate_flag | margin | margin_flag | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 67b9cf1d-0c80-4c3f-a7ab-5cea4d7b79ac | 0500000US34005 | Burlington County, New Jersey | 34 | 005 | S1601_C02_003 | 14.5 | NULL | 0.5 | NULL | 34005S1601_C02_003 | 2026-06-22 18:13:03.471989+00 |
unique_hash: 36061S1901_C01_013
[["NAME","S1901_C01_013E","S1901_C01_013EA","S1901_C01_013M","S1901_C01_013MA","state","county"],
["New York County, New York","194116",null,"2935",null,"36","061"]]
| id | geo_id | name | state | county | metric | estimate | estimate_flag | margin | margin_flag | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|
| eac1aa11-f614-4e5a-a7c3-9a949aa7d94e | 0500000US36061 | New York County, New York | 36 | 061 | S1901_C01_013 | 194116 | NULL | 2935 | NULL | 36061S1901_C01_013 | 2026-06-22 18:23:23.215348+00 |
unique_hash: 37183S0501_C01_021
[["NAME","S0501_C01_021E","S0501_C01_021EA","S0501_C01_021M","S0501_C01_021MA","state","county"],
["Wake County, North Carolina","9.5",null,"0.4",null,"37","183"]]
| id | geo_id | name | state | county | metric | estimate | estimate_flag | margin | margin_flag | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 9075aca2-5776-4c52-8709-ecbdee6a4c75 | 0500000US37183 | Wake County, North Carolina | 37 | 183 | S0501_C01_021 | 9.5 | NULL | 0.4 | NULL | 37183S0501_C01_021 | 2026-06-22 18:27:16.060579+00 |
unique_hash: 42101S1501_C01_006
[["NAME","S1501_C01_006E","S1501_C01_006EA","S1501_C01_006M","S1501_C01_006MA","state","county"],
["Philadelphia County, Pennsylvania","1089070",null,"103",null,"42","101"]]
| id | geo_id | name | state | county | metric | estimate | estimate_flag | margin | margin_flag | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 29f5e1c7-55ff-4700-be21-ae0945831e16 | 0500000US42101 | Philadelphia County, Pennsylvania | 42 | 101 | S1501_C01_006 | 1089070 | NULL | 103 | NULL | 42101S1501_C01_006 | 2026-06-22 19:13:08.568817+00 |
unique_hash: 48141S0701_C01_002
[["NAME","S0701_C01_002E","S0701_C01_002EA","S0701_C01_002M","S0701_C01_002MA","state","county"],
["El Paso County, Texas","46232",null,"900",null,"48","141"]]
| id | geo_id | name | state | county | metric | estimate | estimate_flag | margin | margin_flag | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 293b1db7-6d31-4843-aab9-1223617ea11f | 0500000US48141 | El Paso County, Texas | 48 | 141 | S0701_C01_002 | 46232 | NULL | 900 | NULL | 48141S0701_C01_002 | 2026-06-22 19:53:45.058879+00 |
unique_hash: 50025S1101_C01_013
[["NAME","S1101_C01_013E","S1101_C01_013EA","S1101_C01_013M","S1101_C01_013MA","state","county"],
["Windham County, Vermont","35.0",null,"2.1",null,"50","025"]]
| id | geo_id | name | state | county | metric | estimate | estimate_flag | margin | margin_flag | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|
| cc4df884-161d-453f-9c46-edb82a1ea14f | 0500000US50025 | Windham County, Vermont | 50 | 025 | S1101_C01_013 | 35.0 | NULL | 2.1 | NULL | 50025S1101_C01_013 | 2026-06-22 20:34:12.948574+00 |
unique_hash: 51810S2502_C01_002
[["NAME","S2502_C01_002E","S2502_C01_002EA","S2502_C01_002M","S2502_C01_002MA","state","county"],
["Virginia Beach city, Virginia","118917",null,"1167",null,"51","810"]]
| id | geo_id | name | state | county | metric | estimate | estimate_flag | margin | margin_flag | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2627360b-adf9-4731-ba82-96a96ba0f6d1 | 0500000US51810 | Virginia Beach city, Virginia | 51 | 810 | S2502_C01_002 | 118917 | NULL | 1167 | NULL | 51810S2502_C01_002 | 2026-06-22 20:54:04.06842+00 |
unique_hash: 54011S1301_C01_001
[["NAME","S1301_C01_001E","S1301_C01_001EA","S1301_C01_001M","S1301_C01_001MA","state","county"],
["Cabell County, West Virginia","22141",null,"214",null,"54","011"]]
| id | geo_id | name | state | county | metric | estimate | estimate_flag | margin | margin_flag | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|---|
| e989ec04-2211-4e56-89dd-f85367c8e0c2 | 0500000US54011 | Cabell County, West Virginia | 54 | 011 | S1301_C01_001 | 22141 | NULL | 214 | NULL | 54011S1301_C01_001 | 2026-06-22 21:13:47.915709+00 |