- Database:
raw.acs5_2024_us
- Date Completed: 2026-06-19 (June 19, 2026)
- Table contains 16,318 lines (or entries).
- Program ran on server
Using Google Gemini, I randomly selected 10 metrices to test, each from a different subject table.
The database generates the following columns:
id: unique identifier for entryunique_hash: equals the metric (e.g. S0101_C01_001) at the national leveldate_uploaded: timestamp with time zone
Query:
SELECT * FROM "raw".acs5_2024_us
WHERE unique_hash in ('S0101_C01_001', 'S0801_C03_003', 'S1002_C02_008', 'S1501_C01_015', 'S1602_C02_002', 'S1701_C01_009', 'S1810_C02_028', 'S2301_C02_015', 'S2503_C03_026', 'S2801_C02_023')
The query results are saved in the file: data_downloader\validation\acs5_2024\acs5_national_2026_06_19.csv
https://api.census.gov/data/2024/acs/acs5/subject?get=NAME,S0101_C01_001E,S0101_C01_001EA,S0101_C01_001M,S0101_C01_001MA&for=us:1&key=KEY_HERE
[["NAME","S0101_C01_001E","S0101_C01_001EA","S0101_C01_001M","S0101_C01_001MA","us"],
["United States","334922499",null,"-555555555","*****","1"]]
| id |
geo_id |
name |
us |
metric |
estimate |
estimate_flag |
margin |
margin_flag |
unique_hash |
date_uploaded |
| f9784c27-7869-4149-97e7-63f56d6c93d7 |
0100000US |
United States |
1 |
S0101_C01_001 |
334922499 |
NULL |
-555555555 |
***** |
S0101_C01_001 |
2026-06-19 16:45:33.398263+00 |
https://api.census.gov/data/2024/acs/acs5/subject?get=NAME,S0801_C03_003E,S0801_C03_003EA,S0801_C03_003M,S0801_C03_003MA&for=us:1&key=KEY_HERE
[["NAME","S0801_C03_003E","S0801_C03_003EA","S0801_C03_003M","S0801_C03_003MA","us"],
["United States","67.0",null,"0.1",null,"1"]]
| id |
geo_id |
name |
us |
metric |
estimate |
estimate_flag |
margin |
margin_flag |
unique_hash |
date_uploaded |
| 729e8fe3-ed0c-46f7-bde6-d91ddad7efec |
0100000US |
United States |
1 |
S0801_C03_003 |
67.0 |
NULL |
0.1 |
NULL |
S0801_C03_003 |
2026-06-19 16:45:40.323001+00 |
https://api.census.gov/data/2024/acs/acs5/subject?get=NAME,S1002_C02_008E,S1002_C02_008EA,S1002_C02_008M,S1002_C02_008MA&for=us:1&key=KEY_HERE
[["NAME","S1002_C02_008E","S1002_C02_008EA","S1002_C02_008M","S1002_C02_008MA","us"],
["United States","8.5",null,"0.2",null,"1"]]
| id |
geo_id |
name |
us |
metric |
estimate |
estimate_flag |
margin |
margin_flag |
unique_hash |
date_uploaded |
| 1c708c10-218a-4694-8999-6d23ebf16bdf |
0100000US |
United States |
1 |
S1002_C02_008 |
8.5 |
NULL |
0.2 |
NULL |
S1002_C02_008 |
2026-06-19 16:45:42.225632+00 |
https://api.census.gov/data/2024/acs/acs5/subject?get=NAME,S1501_C01_015E,S1501_C01_015EA,S1501_C01_015M,S1501_C01_015MA&for=us:1&key=KEY_HERE
[["NAME","S1501_C01_015E","S1501_C01_015EA","S1501_C01_015M","S1501_C01_015MA","us"],
["United States","82363216",null,"400530",null,"1"]]
| id |
geo_id |
name |
us |
metric |
estimate |
estimate_flag |
margin |
margin_flag |
unique_hash |
date_uploaded |
| 1627ced8-3575-49b6-b248-191ba0f74a58 |
0100000US |
United States |
1 |
S1501_C01_015 |
82363216 |
NULL |
400530 |
NULL |
S1501_C01_015 |
2026-06-19 16:45:43.655856+00 |
https://api.census.gov/data/2024/acs/acs5/subject?get=NAME,S1602_C02_002E,S1602_C02_002EA,S1602_C02_002M,S1602_C02_002MA&for=us:1&key=KEY_HERE
[["NAME","S1602_C02_002E","S1602_C02_002EA","S1602_C02_002M","S1602_C02_002MA","us"],
["United States","13.1",null,"0.1",null,"1"]]
| id |
geo_id |
name |
us |
metric |
estimate |
estimate_flag |
margin |
margin_flag |
unique_hash |
date_uploaded |
| 9257a140-77d8-4ac8-a67b-0db7c9c26cfa |
0100000US |
United States |
1 |
S1602_C02_002 |
13.1 |
NULL |
0.1 |
NULL |
S1602_C02_002 |
2026-06-19 16:45:44.107705+00 |
https://api.census.gov/data/2024/acs/acs5/subject?get=NAME,S1701_C01_009E,S1701_C01_009EA,S1701_C01_009M,S1701_C01_009MA&for=us:1&key=KEY_HERE
[["NAME","S1701_C01_009E","S1701_C01_009EA","S1701_C01_009M","S1701_C01_009MA","us"],
["United States","77498371",null,"29580",null,"1"]]
| id |
geo_id |
name |
us |
metric |
estimate |
estimate_flag |
margin |
margin_flag |
unique_hash |
date_uploaded |
| da2f8cb2-b5a8-4ed7-87bb-0da32395030c |
0100000US |
United States |
1 |
S1701_C01_009 |
77498371 |
NULL |
29580 |
NULL |
S1701_C01_009 |
2026-06-19 16:45:44.511798+00 |
https://api.census.gov/data/2024/acs/acs5/subject?get=NAME,S1810_C02_028E,S1810_C02_028EA,S1810_C02_028M,S1810_C02_028MA&for=us:1&key=KEY_HERE
[["NAME","S1810_C02_028E","S1810_C02_028EA","S1810_C02_028M","S1810_C02_028MA","us"],
["United States","4738547",null,"20223",null,"1"]]
| id |
geo_id |
name |
us |
metric |
estimate |
estimate_flag |
margin |
margin_flag |
unique_hash |
date_uploaded |
| 053a7471-ffa4-455d-a32a-f0f2cc90e624 |
0100000US |
United States |
1 |
S1810_C02_028 |
4738547 |
NULL |
20223 |
NULL |
S1810_C02_028 |
2026-06-19 16:45:45.157689+00 |
https://api.census.gov/data/2024/acs/acs5/subject?get=NAME,S2301_C02_015E,S2301_C02_015EA,S2301_C02_015M,S2301_C02_015MA&for=us:1&key=KEY_HERE
[["NAME","S2301_C02_015E","S2301_C02_015EA","S2301_C02_015M","S2301_C02_015MA","us"],
["United States","66.8",null,"0.1",null,"1"]]
| id |
geo_id |
name |
us |
metric |
estimate |
estimate_flag |
margin |
margin_flag |
unique_hash |
date_uploaded |
| 375b1385-be1f-48c0-972e-31475c1214b9 |
0100000US |
United States |
1 |
S2301_C02_015 |
66.8 |
NULL |
0.1 |
NULL |
S2301_C02_015 |
2026-06-19 16:45:47.119485+00 |
https://api.census.gov/data/2024/acs/acs5/subject?get=NAME,S2503_C03_026E,S2503_C03_026EA,S2503_C03_026M,S2503_C03_026MA&for=us:1&key=KEY_HERE
[["NAME","S2503_C03_026E","S2503_C03_026EA","S2503_C03_026M","S2503_C03_026MA","us"],
["United States","362681",null,"4851",null,"1"]]
| id |
geo_id |
name |
us |
metric |
estimate |
estimate_flag |
margin |
margin_flag |
unique_hash |
date_uploaded |
| 4e33a09c-56cf-44ab-9485-cab9c67a2dcc |
0100000US |
United States |
1 |
S2503_C03_026 |
362681 |
NULL |
4851 |
NULL |
S2503_C03_026 |
2026-06-19 16:45:50.686752+00 |
https://api.census.gov/data/2024/acs/acs5/subject?get=NAME,S2801_C02_023E,S2801_C02_023EA,S2801_C02_023M,S2801_C02_023MA&for=us:1&key=KEY_HERE
[["NAME","S2801_C02_023E","S2801_C02_023EA","S2801_C02_023M","S2801_C02_023MA","us"],
["United States","24.8",null,"0.1",null,"1"]]
| id |
geo_id |
name |
us |
metric |
estimate |
estimate_flag |
margin |
margin_flag |
unique_hash |
date_uploaded |
| 916ae23c-0229-43ab-b966-2cdfa3bbb2a2 |
0100000US |
United States |
1 |
S2801_C02_023 |
24.8 |
NULL |
0.1 |
NULL |
S2801_C02_023 |
2026-06-19 16:45:54.206488+00 |