I have been trying to find a time efficient way of sourcing census data for all block groups in a State. The AFF site only allows this for one county at a time. Data Ferrett looks like it is no longer maintained. Whether or not that is true, our network security will not allow the use of Java to enable that site's functionality. PUMS appears to not offer the option we need.
I imagine someone might now suggest I use the Summary files to create what we need. Although I am of intermediate level in Excel and GIS, I find the instructions to do so obscure and incomplete.
What is the best way to achieve assembly of census data for all block groups in a State, particularly the relatively simple data set of total population and total households (occupied housing units)?
Should be simple, no? This data need does not seem like it should rise to the level of a special data request.
If you know any R, you could use the tidycensus package to do this: walkerke.github.io/.../. I wrote up some examples for how to pull all block groups and other geographies on my blog: mattherman.info/.../