raw.acs5_2024_stGenerated Columns
id: uuidunique_hash = state_fips + metricdate_uploaded: timestamp with time zoneI have chosen 15 random states and subject table "variables" (or metrics).
Query:
SELECT * FROM "raw".acs5_2024_st
WHERE unique_hash in ('02S2701_C03_001', '05S2301_C04_001', '08S0802_C03_005', '11S1901_C01_012', '19S1810_C03_001', '20S0701_C01_014', '21S0801_C01_003', '26S2503_C01_024', '27S1501_C02_015', '28S2801_C01_012', '29S1601_C01_003', '30S0101_C01_002', '36S1701_C03_001', '42S1301_C01_026', '46S1101_C01_002')
Query results are saved in the file: data_downloader/validation/acs5_2024/acs5_state_2026_06_22.csv.
Result
[["NAME","S2701_C03_001E","S2701_C03_001EA","S2701_C03_001M","S2701_C03_001MA","state"],
["Alaska","89.0",null,"0.3",null,"02"]]
| id | geo_id | name | state | metric | estimate | estimate_flag | margin | margin_flag | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|
| b6cedf77-0fd2-4b29-a6b7-70cd5746fbd5 | 0400000US02 | Alaska | 02 | S2701_C03_001 | 89.0 | NULL | 0.3 | NULL | 02S2701_C03_001 | 2026-06-22 16:52:22.134264+00 |
Result
[["NAME","S2301_C04_001E","S2301_C04_001EA","S2301_C04_001M","S2301_C04_001MA","state"],
["Arkansas","4.9",null,"0.2",null,"05"]]
| id | geo_id | name | state | metric | estimate | estimate_flag | margin | margin_flag | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|
| 81701986-e490-49d5-b312-1d3d6d748ee0 | 0400000US05 | Arkansas | 05 | S2301_C04_001 | 4.9 | NULL | 0.2 | NULL | 05S2301_C04_001 | 2026-06-22 16:52:56.752302+00 |
Result
[["NAME","S0802_C03_005E","S0802_C03_005EA","S0802_C03_005M","S0802_C03_005MA","state"],
["Colorado","17.1",null,"0.6",null,"08"]]
| id | geo_id | name | state | metric | estimate | estimate_flag | margin | margin_flag | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|
| cefbf9ab-ae31-46fb-81a4-a326ce260adf | 0400000US08 | Colorado | 08 | S0802_C03_005 | 17.1 | NULL | 0.6 | NULL | 08S0802_C03_005 | 2026-06-22 16:53:35.59231+00 |
Result
[["NAME","S1901_C01_012E","S1901_C01_012EA","S1901_C01_012M","S1901_C01_012MA","state"],
["District of Columbia","109870",null,"1937",null,"11"]]
| id | geo_id | name | state | metric | estimate | estimate_flag | margin | margin_flag | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|
| ef2e9587-eb26-49e4-9110-cc1b68b1d6e1 | 0400000US11 | District of Columbia | 11 | S1901_C01_012 | 109870 | NULL | 1937 | NULL | 11S1901_C01_012 | 2026-06-22 16:54:49.653271+00 |
Result
[["NAME","S1810_C03_001E","S1810_C03_001EA","S1810_C03_001M","S1810_C03_001MA","state"],
["Iowa","12.6",null,"0.1",null,"19"]]
| id | geo_id | name | state | metric | estimate | estimate_flag | margin | margin_flag | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|
| c2be5af4-bf5b-4f79-8062-e505383055ce | 0400000US19 | Iowa | 19 | S1810_C03_001 | 12.6 | NULL | 0.1 | NULL | 19S1810_C03_001 | 2026-06-22 16:57:16.003642+00 |
Result
[["NAME","S0701_C01_014E","S0701_C01_014EA","S0701_C01_014M","S0701_C01_014MA","state"],
["Kansas","2608231",null,"5148",null,"20"]]
| id | geo_id | name | state | metric | estimate | estimate_flag | margin | margin_flag | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|
| fbb0dd0d-4cc6-47b3-81d5-65abea536ada | 0400000US20 | Kansas | 20 | S0701_C01_014 | 2608231 | NULL | 5148 | NULL | 20S0701_C01_014 | 2026-06-22 16:57:31.12943+00 |
Result
[["NAME","S0801_C01_003E","S0801_C01_003EA","S0801_C01_003M","S0801_C01_003MA","state"],
["Kentucky","76.6",null,"0.3",null,"21"]]
| id | geo_id | name | state | metric | estimate | estimate_flag | margin | margin_flag | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|
| e06a5c7e-a5f7-4e9b-b327-43f4bd9ecdc6 | 0400000US21 | Kentucky | 21 | S0801_C01_003 | 76.6 | NULL | 0.3 | NULL | 21S0801_C01_003 | 2026-06-22 16:57:52.945813+00 |
Result
[["NAME","S2503_C01_024E","S2503_C01_024EA","S2503_C01_024M","S2503_C01_024MA","state"],
["Michigan","1111",null,"3",null,"26"]]
| id | geo_id | name | state | metric | estimate | estimate_flag | margin | margin_flag | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|
| 865c4abc-481a-483b-8085-4288a3c9efdf | 0400000US26 | Michigan | 26 | S2503_C01_024 | 1111 | NULL | 3 | NULL | 26S2503_C01_024 | 2026-06-22 16:59:50.127905+00 |
Result
[["NAME","S1501_C02_015E","S1501_C02_015EA","S1501_C02_015M","S1501_C02_015MA","state"],
["Minnesota","39.4",null,"0.2",null,"27"]]
| id | geo_id | name | state | metric | estimate | estimate_flag | margin | margin_flag | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|
| 68343550-b6e7-449c-a354-c4409b084d41 | 0400000US27 | Minnesota | 27 | S1501_C02_015 | 39.4 | NULL | 0.2 | NULL | 27S1501_C02_015 | 2026-06-22 17:00:05.770457+00 |
Result
[["NAME","S2801_C01_012E","S2801_C01_012EA","S2801_C01_012M","S2801_C01_012MA","state"],
["Mississippi","964698",null,"6092",null,"28"]]
| id | geo_id | name | state | metric | estimate | estimate_flag | margin | margin_flag | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|
| d6bd7841-3170-4949-ab50-fa8dda96d9e0 | 0400000US28 | Mississippi | 28 | S2801_C01_012 | 964698 | NULL | 6092 | NULL | 28S2801_C01_012 | 2026-06-22 17:00:40.840555+00 |
Result
[["NAME","S1601_C01_003E","S1601_C01_003EA","S1601_C01_003M","S1601_C01_003MA","state"],
["Missouri","391604",null,"6601",null,"29"]]
| id | geo_id | name | state | metric | estimate | estimate_flag | margin | margin_flag | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|
| 07fc5070-4125-4541-aecf-35ded5aa7dff | 0400000US29 | Missouri | 29 | S1601_C01_003 | 391604 | NULL | 6601 | NULL | 29S1601_C01_003 | 2026-06-22 17:00:52.301892+00 |
Result
[["NAME","S0101_C01_002E","S0101_C01_002EA","S0101_C01_002M","S0101_C01_002MA","state"],
["Montana","57941",null,"282",null,"30"]]
| id | geo_id | name | state | metric | estimate | estimate_flag | margin | margin_flag | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|
| b9f29f33-2f3d-4b04-b80b-81e7cca4bccd | 0400000US30 | Montana | 30 | S0101_C01_002 | 57941 | NULL | 282 | NULL | 30S0101_C01_002 | 2026-06-22 17:01:04.235876+00 |
Result
[["NAME","S1701_C03_001E","S1701_C03_001EA","S1701_C03_001M","S1701_C03_001MA","state"],
["New York","14.0",null,"0.2",null,"36"]]
| id | geo_id | name | state | metric | estimate | estimate_flag | margin | margin_flag | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|
| f5a297cd-3201-4d42-bbf1-7c86053fa3d6 | 0400000US36 | New York | 36 | S1701_C03_001 | 14.0 | NULL | 0.2 | NULL | 36S1701_C03_001 | 2026-06-22 17:03:22.47272+00 |
Result
[["NAME","S1301_C01_026E","S1301_C01_026EA","S1301_C01_026M","S1301_C01_026MA","state"],
["Pennsylvania","2827408",null,"3159",null,"42"]]
| id | geo_id | name | state | metric | estimate | estimate_flag | margin | margin_flag | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|
| 226d621f-0f4b-4a04-8801-de3bbc0951c8 | 0400000US42 | Pennsylvania | 42 | S1301_C01_026 | 2827408 | NULL | 3159 | NULL | 42S1301_C01_026 | 2026-06-22 17:05:24.726673+00 |
Result
[["NAME","S1101_C01_002E","S1101_C01_002EA","S1101_C01_002M","S1101_C01_002MA","state"],
["South Dakota","2.39",null,"0.01",null,"46"]]
| id | geo_id | name | state | metric | estimate | estimate_flag | margin | margin_flag | unique_hash | date_uploaded |
|---|---|---|---|---|---|---|---|---|---|---|
| 33ad588d-c7e5-471b-8d33-e7fb8dbf40d3 | 0400000US46 | South Dakota | 46 | S1101_C01_002 | 2.39 | NULL | 0.01 | NULL | 46S1101_C01_002 | 2026-06-22 17:06:30.484498+00 |