About this Dataset

Austin MSA Racial And Ethnic Diversity Index

These are the data used for the Racial and Ethnic Diversity for the Austin MSA story map. The story map was published July 2024 but displays data from 2000, 2010, and 2020.

Decennial census data were used for all three years.
2000: DEC Summary File 1, P004
2010: DEC Redistricting Data (PL 94-171), P2
2020: DEC Redistricting Data (PL 94-171), P2

Geographic crosswalks were used to harmonize 2000, 2010, and 2020 geographies.

Racial and Ethnic Diversity Index for the Austin MSA Storymap: https://storymaps.arcgis.com/stories/88ee265f00934af7a750b57f7faebd2c

City of Austin Open Data Terms of Use – https://data.austintexas.gov/stories/s/ranj-cccq
Organization: City of Austin
Last updated: 2024-11-25T12:11:29.300921
Tags: demographics

Tables

Table 1

@usgov.city_of_austin_austin_msa_racial_and_ethnic_diversity_index.table_1

103.3 kB
512 rows
39 columns

CREATE TABLE table_1 (
  "geography" VARCHAR,
  "geoid" DOUBLE,
  "geographic_area_name" VARCHAR,
  "total_population_2000" DOUBLE,
  "hispanic_latina_o_x_2000" DOUBLE,
  "white_2000" DOUBLE,
  "black_african_american_2000" DOUBLE,
  "aian_2000" DOUBLE,
  "asian_asian_american_2000" DOUBLE,
  "nhpi_2000" DOUBLE,
  "of_another_race_2000" DOUBLE,
  "multiracial_2000" DOUBLE,
  "diversity_index_2000" DOUBLE,
  "total_population_2010" DOUBLE,
  "hispanic_latina_o_x_2010" DOUBLE,
  "white_2010" DOUBLE,
  "black_african_american_2010" DOUBLE,
  "aian_2010" DOUBLE,
  "asian_asian_american_2010" DOUBLE,
  "nhpi_2010" DOUBLE,
  "of_another_race_2010" DOUBLE,
  "multiracial_2010" DOUBLE,
  "diversity_index_2010" DOUBLE,
  "total_population_2020" BIGINT,
  "hispanic_latina_o_x_2020" BIGINT,
  "white_2020" BIGINT,
  "black_african_american_2020" BIGINT,
  "aian_2020" BIGINT,
  "asian_asian_american_2020" BIGINT,
  "nhpi_2020" BIGINT,
  "of_another_race_2020" BIGINT,
  "mulitracial_2020" BIGINT,
  "diversity_index_2020" DOUBLE,
  "population_change_2000_to_2010" DOUBLE,
  "population_change_2000_to_2020" DOUBLE,
  "population_change_2010_to_2020" DOUBLE,
  "diversity_change_2000_to_2010" DOUBLE,
  "diversity_change_2000_to_2020" DOUBLE,
  "diversity_change_2010_to_2020" DOUBLE
);