Finding updated Census data

[vince-br-549]

Where can I download an update to the census data that you have.
I'm on chapter six and I used chatgpt to help me generate some queries against the Ohio registered voters database that I have. Great book. I have been using PostgreSQL for years. I didn't see an index on normalizing.

[anthonydb]

@vince-br-549
The book uses various Census products. In chapter 5, we import population data for counties that I collected from the Census population estimates program:

https://www.census.gov/programs-surveys/popest.html

This is the most recent version:

https://www.census.gov/data/tables/time-series/demo/popest/2020s-counties-total.html

Elsewhere, we use American Community Survey data, which is slightly more complicated to collect. But you can find it at https://data.census.gov/