Baselight

Selected Housing Characteristics (DP04)

City of Seattle

@usgov.city_of_seattle_selected_housing_characteristics_dp04

Loading...
Loading...

About this Dataset

Selected Housing Characteristics (DP04)

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 profile of Selected Housing Characteristics (DP04). 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, 2023

ACS Table(s) : <a href='https://data.census.gov/all?q=Dp04' style='font-family:inherit;' target='_blank' rel='n
Organization: City of Seattle
Last updated: 2024-12-16T22:35:40.776636
Tags: acs, acssnapapp, census, demographics, gis, housing, planning, seattle-gis-open-data, tracts

Tables

Table 1

@usgov.city_of_seattle_selected_housing_characteristics_dp04.table_1
  • 832.76 KB
  • 2770 rows
  • 142 columns
Loading...

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "geoid" BIGINT,
  "total_housing_units" BIGINT,
  "occupied_housing_units" BIGINT,
  "vacant_housing_units" BIGINT,
  "homeowner_vacancy_rate" DOUBLE,
  "rental_vacancy_rate" DOUBLE,
  "n_1_unit_detached" BIGINT,
  "n_1_unit_attached" BIGINT,
  "n_2_units" BIGINT,
  "n_3_or_4_units" BIGINT,
  "n_5_to_9_units" BIGINT,
  "n_10_to_19_units" BIGINT,
  "n_20_to_49_units" BIGINT,
  "n_50_or_more_units" BIGINT,
  "mobile_home" BIGINT,
  "boat_rv_van_etc" BIGINT,
  "built_2020_or_later" DOUBLE,
  "built_2010_to_2019" DOUBLE,
  "built_2000_to_2009" BIGINT,
  "built_1990_to_1999" BIGINT,
  "built_1980_to_1989" BIGINT,
  "built_1970_to_1979" BIGINT,
  "built_1960_to_1969" BIGINT,
  "built_1950_to_1959" BIGINT,
  "built_1940_to_1949" BIGINT,
  "built_1939_or_earlier" BIGINT,
  "n_1_room" BIGINT,
  "n_2_rooms" BIGINT,
  "n_3_rooms" BIGINT,
  "n_4_rooms" BIGINT,
  "n_5_rooms" BIGINT,
  "n_6_rooms" BIGINT,
  "n_7_rooms" BIGINT,
  "n_8_rooms" BIGINT,
  "n_9_or_more_rooms" BIGINT,
  "median_number_of_rooms" DOUBLE,
  "no_bedroom" BIGINT,
  "n_1_bedroom" BIGINT,
  "n_2_bedrooms" BIGINT,
  "n_3_bedrooms" BIGINT,
  "n_4_bedrooms" BIGINT,
  "n_5_or_more_bedrooms" BIGINT,
  "owner_occupied_housing_units" BIGINT,
  "renter_occupied_housing_units" BIGINT,
  "average_household_size_of_owner_occupied_unit" DOUBLE,
  "average_household_size_of_renter_occupied_unit" DOUBLE,
  "moved_in_2019_or_later" DOUBLE,
  "moved_in_2015_to_2018" DOUBLE,
  "moved_in_2010_to_2014" DOUBLE,
  "moved_in_2000_to_2009" BIGINT,
  "moved_in_1990_to_1999" BIGINT,
  "moved_in_1989_or_earlier" BIGINT,
  "no_vehicles_available" BIGINT,
  "n_1_vehicle_available" BIGINT,
  "n_2_vehicles_available" BIGINT,
  "n_3_or_more_vehicles_available" BIGINT,
  "utility_gas" BIGINT,
  "bottled_tank_or_lp_gas" BIGINT,
  "electricity" BIGINT,
  "fuel_oil_kerosene_etc" BIGINT,
  "coal_or_coke" BIGINT,
  "wood" BIGINT,
  "solar_energy" BIGINT,
  "other_fuel" BIGINT,
  "no_fuel_used" BIGINT,
  "lacking_compete_plumbing_facilities" BIGINT,
  "lacking_compete_kitchen_facilities" BIGINT,
  "no_telephone_service_available" BIGINT,
  "occupants_per_room_1_0_or_less" BIGINT,
  "occupants_per_room_1_0_to_1_5" BIGINT,
  "occupants_per_room_1_5_or_more" BIGINT,
  "housing_unit_value_less_than_50_000" BIGINT,
  "housing_unit_value_50_000_to_99_999" BIGINT,
  "housing_unit_value_100_000_to_149_999" BIGINT,
  "housing_unit_value_150_000_to_199_999" BIGINT,
  "housing_unit_value_200_000_to_299_999" BIGINT,
  "housing_unit_value_300_000_to_499_999" BIGINT,
  "housing_unit_value_500_000_to_999_999" BIGINT,
  "housing_unit_value_1_000_000_or_more" BIGINT,
  "median_owner_occupied_housing_unit_value_dollars" DOUBLE,
  "housing_units_with_a_mortgage" BIGINT,
  "housing_units_without_a_mortgage" BIGINT,
  "with_mortgage_costs_less_than_500" BIGINT,
  "with_mortgage_costs_500_to_999" BIGINT,
  "with_mortgage_costs_1_000_to_1_499" BIGINT,
  "with_mortgage_costs_1_500_to_1_999" BIGINT,
  "with_mortgage_costs_2_000_to_2_499" BIGINT,
  "with_mortgage_costs_2_500_to_2_999" DOUBLE,
  "with_mortgage_costs_3_000_or_more" DOUBLE,
  "median_selected_monthly_owner_with_a_mortgage_costs_dollars" DOUBLE,
  "no_mortgage_costs_less_than_250" BIGINT,
  "no_mortgage_costs_250_to_399" BIGINT,
  "no_mortgage_costs_400_to_599" BIGINT,
  "no_mortgage_costs_600_to_799" DOUBLE,
  "no_mortgage_costs_800_to_999" DOUBLE,
  "no_mortgage_costs_1_000_or_more" DOUBLE,
  "median_selected_monthly_owner_with_no_mortgage_costs_dollars" DOUBLE,
  "housing_units_with_a_mortgage_where_selected_monthly_o_427d603b" BIGINT,
  "with_mortgage_percentage_of_household_income_less_than_455f0796" BIGINT
);

Share link

Anyone who has the link will be able to view this.