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  -- 1-unit Detached,
  "n_1_unit_attached" BIGINT  -- 1-unit Attached,
  "n_2_units" BIGINT  -- 2 Units,
  "n_3_or_4_units" BIGINT  -- 3 Or 4 Units,
  "n_5_to_9_units" BIGINT  -- 5 To 9 Units,
  "n_10_to_19_units" BIGINT  -- 10 To 19 Units,
  "n_20_to_49_units" BIGINT  -- 20 To 49 Units,
  "n_50_or_more_units" BIGINT  -- 50 Or More Units,
  "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  -- 1 Room,
  "n_2_rooms" BIGINT  -- 2 Rooms,
  "n_3_rooms" BIGINT  -- 3 Rooms,
  "n_4_rooms" BIGINT  -- 4 Rooms,
  "n_5_rooms" BIGINT  -- 5 Rooms,
  "n_6_rooms" BIGINT  -- 6 Rooms,
  "n_7_rooms" BIGINT  -- 7 Rooms,
  "n_8_rooms" BIGINT  -- 8 Rooms,
  "n_9_or_more_rooms" BIGINT  -- 9 Or More Rooms,
  "median_number_of_rooms" DOUBLE,
  "no_bedroom" BIGINT,
  "n_1_bedroom" BIGINT  -- 1 Bedroom,
  "n_2_bedrooms" BIGINT  -- 2 Bedrooms,
  "n_3_bedrooms" BIGINT  -- 3 Bedrooms,
  "n_4_bedrooms" BIGINT  -- 4 Bedrooms,
  "n_5_or_more_bedrooms" BIGINT  -- 5 Or More Bedrooms,
  "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  -- 1 Vehicle Available,
  "n_2_vehicles_available" BIGINT  -- 2 Vehicles Available,
  "n_3_or_more_vehicles_available" BIGINT  -- 3 Or More Vehicles Available,
  "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 Less Than $50,000,
  "housing_unit_value_50_000_to_99_999" BIGINT  -- Housing Unit Value $50,000 To $99,999,
  "housing_unit_value_100_000_to_149_999" BIGINT  -- Housing Unit Value $100,000 To $149,999,
  "housing_unit_value_150_000_to_199_999" BIGINT  -- Housing Unit Value $150,000 To $199,999,
  "housing_unit_value_200_000_to_299_999" BIGINT  -- Housing Unit Value $200,000 To $299,999,
  "housing_unit_value_300_000_to_499_999" BIGINT  -- Housing Unit Value $300,000 To $499,999,
  "housing_unit_value_500_000_to_999_999" BIGINT  -- Housing Unit Value $500,000 To $999,999,
  "housing_unit_value_1_000_000_or_more" BIGINT  -- Housing Unit Value $1,000,000 Or More,
  "median_owner_occupied_housing_unit_value_dollars" DOUBLE  -- Median Owner-occupied Housing Unit Value (dollars),
  "housing_units_with_a_mortgage" BIGINT,
  "housing_units_without_a_mortgage" BIGINT,
  "with_mortgage_costs_less_than_500" BIGINT  -- With Mortgage Costs Less Than $500,
  "with_mortgage_costs_500_to_999" BIGINT  -- With Mortgage Costs $500 To $999,
  "with_mortgage_costs_1_000_to_1_499" BIGINT  -- With Mortgage Costs $1,000 To $1,499,
  "with_mortgage_costs_1_500_to_1_999" BIGINT  -- With Mortgage Costs $1,500 To $1,999,
  "with_mortgage_costs_2_000_to_2_499" BIGINT  -- With Mortgage Costs $2,000 To $2,499,
  "with_mortgage_costs_2_500_to_2_999" DOUBLE  -- With Mortgage Costs $2,500 To $2,999,
  "with_mortgage_costs_3_000_or_more" DOUBLE  -- With Mortgage Costs $3,000 Or More,
  "median_selected_monthly_owner_with_a_mortgage_costs_dollars" DOUBLE  -- Median Selected Monthly Owner With A Mortgage Costs (dollars),
  "no_mortgage_costs_less_than_250" BIGINT  -- No Mortgage Costs Less Than $250,
  "no_mortgage_costs_250_to_399" BIGINT  -- No Mortgage Costs $250 To $399,
  "no_mortgage_costs_400_to_599" BIGINT  -- No Mortgage Costs $400 To $599,
  "no_mortgage_costs_600_to_799" DOUBLE  -- No Mortgage Costs $600 To $799,
  "no_mortgage_costs_800_to_999" DOUBLE  -- No Mortgage Costs $800 To $999,
  "no_mortgage_costs_1_000_or_more" DOUBLE  -- No Mortgage Costs $1,000 Or More,
  "median_selected_monthly_owner_with_no_mortgage_costs_dollars" DOUBLE  -- Median Selected Monthly Owner With No Mortgage Costs (dollars),
  "housing_units_with_a_mortgage_where_selected_monthly_o_427d603b" BIGINT  -- Housing Units With A Mortgage Where Selected Monthly Onwer Costs A S A Percentage Of Household Income Can Be Computed,
  "with_mortgage_percentage_of_household_income_less_than_455f0796" BIGINT  -- With Mortgage Percentage Of Household Income Less Than 20.0 Percent
);