Exploring census data in the SQL Query Builder
For the remaining chapter, let’s explore the population dynamics in Los Angeles County—specifically, declines or increases in the Hispanic population. The folder download included a JSON file. We need to identify populations of interest from the dense JSON file you see in Figure 6.19:
Figure 6.19 – Demographic metadata JSON file Hispanic/non-Hispanic aged over 18
The area highlighted in Figure 6.19 is the percent change in population from the 2010 census to the 2020 census. In addition, I captured the total population and total population: Hispanic Latino for 2020, "P0040001_2020": "P4-1: Total (2020)", "P0040002_2020": "P4-2: Hispanic or Latino (2020)".
Renaming the columns in census tables is quite a task. The codes identify data products available from the census. For example, B in the column heading in Figure 6.20 is used for detailed estimates...
