Selected Housing Characteristics (DP04)
City of Seattle
@usgov.city_of_seattle_selected_housing_characteristics_dp04
City of Seattle
@usgov.city_of_seattle_selected_housing_characteristics_dp04
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
);
Anyone who has the link will be able to view this.