About this Dataset

Selected Demographic And Housing Estimates (DP05)

Data from:American Community Survey, 5-year Series

King County, Washington census tracts with nonoverlapping vintages of the 5-year American Community Survey (ACS) estimates starting in 2010 from the U.S. Census Bureau's demographic and housing estimates (DP05). Also includes the most recent release annually with the vintage identified in the "ACS Vintage" field.

The census tract boundaries match the vintage of the ACS data (currently 2010 and 2020) so please note the geographic changes between the decades.

Tracts have been coded as being within the City of Seattle as well as assigned to neighborhood groups called "Community Reporting Areas". These areas were created after the 2000 census to provide geographically consistent neighborhoods through time for reporting U.S. Census Bureau data. This is not an attempt to identify neighborhood boundaries as defined by neighborhoods themselves.

Vintages : 2010, 2015, 2020, 2021, 2022<span style='font-family:inherit
Organization: City of Seattle
Last updated: 2024-12-16T22:22:04.732837
Tags: acs, acssnapapp, census, demographics, gis, planning, population, race, race-and-ethnicity, seattle-gis-open-data, tracts

Tables

Table 1

@usgov.city_of_seattle_selected_demographic_and_housing_estimates_dp05.table_1

555.33 kB
2,770 rows
79 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "geoid" BIGINT,
  "total_population" BIGINT,
  "male" BIGINT,
  "female" BIGINT,
  "under_5_years" BIGINT,
  "n_5_to_9_years" BIGINT  -- 5 To 9 Years,
  "n_10_to_14_years" BIGINT  -- 10 To 14 Years,
  "n_15_to_19_years" BIGINT  -- 15 To 19 Years,
  "n_20_to_24_years" BIGINT  -- 20 To 24 Years,
  "n_25_to_34_years" BIGINT  -- 25 To 34 Years,
  "n_35_to_44_years" BIGINT  -- 35 To 44 Years,
  "n_45_to_54_years" BIGINT  -- 45 To 54 Years,
  "n_55_to_59_years" BIGINT  -- 55 To 59 Years,
  "n_60_to_64_years" BIGINT  -- 60 To 64 Years,
  "n_65_to_74_years" BIGINT  -- 65 To 74 Years,
  "n_75_to_84_years" BIGINT  -- 75 To 84 Years,
  "n_85_years_and_over" BIGINT  -- 85 Years And Over,
  "median_age_years" DOUBLE  -- Median Age (years),
  "n_18_years_and_over" BIGINT  -- 18 Years And Over,
  "n_21_years_and_over" BIGINT  -- 21 Years And Over,
  "n_62_years_and_over" BIGINT  -- 62 Years And Over,
  "n_65_years_and_over" BIGINT  -- 65 Years And Over,
  "n_18_years_and_over_male" BIGINT  -- 18 Years And Over Male,
  "n_18_years_and_over_female" BIGINT  -- 18 Years And Over Female,
  "n_65_years_and_over_male" BIGINT  -- 65 Years And Over Male,
  "n_65_years_and_over_female" BIGINT  -- 65 Years And Over Female,
  "population_of_one_race" BIGINT,
  "white_alone" BIGINT,
  "black_or_african_american_alone" BIGINT,
  "american_indian_and_alaska_native_alone" BIGINT,
  "asian_alone" BIGINT,
  "asian_indian" BIGINT,
  "chinese" BIGINT,
  "filipino" BIGINT,
  "japanese" BIGINT,
  "korean" BIGINT,
  "vietnamese" BIGINT,
  "other_asian" BIGINT,
  "native_hawaiian_and_other_pacific_islander_alone" BIGINT,
  "native_hawaiian" BIGINT,
  "guamanian_or_chamorro" BIGINT,
  "samoan" BIGINT,
  "other_pacific_islander" BIGINT,
  "some_other_race_alone" BIGINT,
  "two_or_more_races" BIGINT,
  "white_and_black_or_african_american" BIGINT,
  "white_and_american_indian_and_alaska_native" BIGINT,
  "white_and_asian" BIGINT,
  "black_or_african_american_and_american_indian_and_alaska_native" BIGINT,
  "white_in_combination_with_one_or_more_other_races" BIGINT,
  "black_or_african_american_in_combination_with_one_or_m_134398d2" BIGINT  -- Black Or African American In Combination With One Or More Other Races,
  "american_indian_and_alaska_native_in_combination_with__d6075b19" BIGINT  -- American Indian And Alaska Native In Combination With One Or More Other Races,
  "asian_in_combination_with_one_or_more_other_races" BIGINT,
  "native_hawaiian_and_other_pacific_islander_in_combinat_6ddc86af" BIGINT  -- Native Hawaiian And Other Pacific Islander In Combination With One Or More Other Races,
  "some_other_race_in_combination_with_one_or_more_other_races" BIGINT,
  "hispanic_or_latino_of_any_race" BIGINT  -- Hispanic Or Latino (of Any Race),
  "mexican" BIGINT,
  "puerto_rican" BIGINT,
  "cuban" BIGINT,
  "other_hispanic_or_latino" BIGINT,
  "not_hispanic_or_latino" BIGINT,
  "not_hispanic_or_latino_white_alone" BIGINT,
  "not_hispanic_or_latino_black_or_african_american_alone" BIGINT,
  "not_hispanic_or_latino_american_indian_and_alaska_native_alone" BIGINT,
  "not_hispanic_or_latino_asian_alone" BIGINT,
  "not_hispanic_or_latino_native_hawaiian_and_other_pacif_4b4b9797" BIGINT  -- Not Hispanic Or Latino Native Hawaiian And Other Pacific Islander Alone,
  "not_hispanic_or_latino_some_other_race_alone" BIGINT,
  "not_hispanic_or_latino_two_or_more_races" BIGINT,
  "not_hispanic_or_latino_two_races_including_some_other_race" BIGINT,
  "not_hispanic_or_latino_two_races_excluding_some_other__e5380e8d" BIGINT  -- Not Hispanic Or Latino Two Races Excluding Some Other Race And Three Or More Races,
  "total_housing_units" BIGINT,
  "acs_vintage" VARCHAR,
  "jurisdiction" VARCHAR,
  "community_reporting_area_id" DOUBLE,
  "community_reporting_area_group" DOUBLE,
  "community_reporting_area_name" VARCHAR,
  "community_reporting_area_neighborhoods" VARCHAR,
  "tract_label" DOUBLE
);