Renaming table columns – US census
In Figure 4.8, we are changing the column headings of the data that we will need. The ALTER TABLE function will make the requested changes and you can customize as many columns as you would like.
Figure 4.8 – Renaming the census tables for clarity
One of the most challenging aspects of working with census data is solved by the ability to create column headings that are clear and descriptive.
What do the census table codes mean?
The data you will use is redistricting data from the 2020 decennial release. Census Reporter simplifies the task so that you can focus on learning how to write SQL queries but let me give you a quick overview.
The documentation for the decennial release can be found here: https://www2.census.gov/programs-surveys/decennial/2020/technical-documentation/complete-tech-docs/summary-file/2020Census_PL94_171Redistricting_NationalTechDoc.pdf.
The files accessed in this chapter...
