2020 Census Block Groups Top 50 American Community Survey Data With Seattle Neighborhoods

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "geoid_20" BIGINT,
  "land_acres" DOUBLE,
  "water_acres" DOUBLE,
  "census_tract_number" BIGINT,
  "census_block_group" BIGINT,
  "census_tract_and_block_group" DOUBLE,
  "block_group_name" VARCHAR,
  "census_tract_label" DOUBLE,
  "council_district" BIGINT,
  "comprehensive_plan_growth_area" BIGINT,
  "comprehensive_plan_area_name" VARCHAR,
  "acs_vinatage" VARCHAR,
  "total_population" BIGINT,
  "children_under_5" BIGINT,
  "children_under_18" BIGINT,
  "older_adults_65_and_over" BIGINT,
  "median_age" DOUBLE,
  "male" BIGINT,
  "female" 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,
  "hispanic_or_latino_of_any_race" BIGINT  -- Hispanic Or Latino (of Any Race),
  "people_of_color" BIGINT,
  "total_households" BIGINT,
  "family_households_families" BIGINT  -- Family Households (families),
  "nonfamily_households" BIGINT,
  "householder_living_alone" BIGINT,
  "less_than_a_high_school_education" BIGINT,
  "bachelor_degree_or_higher" BIGINT,
  "workers_16_years_and_over" BIGINT,
  "worked_from_home" BIGINT,
  "car_truck_or_van_drove_alone" BIGINT  -- Car Truck Or Van - Drove Alone,
  "public_transportation_excluding_taxicab" BIGINT  -- Public Transportation (excluding Taxicab),
  "no_vehicles_available" BIGINT,
  "travel_time_15_minutes" BIGINT  -- Travel Time <15 Minutes,
  "travel_time_15_29_minutes" BIGINT,
  "travel_time_30_44_minutes" BIGINT,
  "travel_time_45_59_minutes" BIGINT,
  "travel_time_60_89_minutes" BIGINT,
  "travel_time_90_minutes" BIGINT  -- Travel Time 90+ Minutes,
  "total_housing_units" BIGINT,
  "n_1_unit_detached" BIGINT  -- 1-unit Detached,
  "low_density_housing_1_unit_att_4_units" BIGINT  -- Low Density Housing (1-unit Att - 4 Units),
  "medium_density_housing_5_49_units" BIGINT  -- Medium Density Housing (5-49 Units),
  "high_density_housing_50_units" BIGINT  -- High Density Housing (50+ Units),
  "overcrowded_units_1_occupants_room" BIGINT  -- Overcrowded Units (>1 Occupants/room),
  "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,
  "population_18_years_and_over" BIGINT,
  "population_18_years_and_over_with_a_disability" BIGINT,
  "population_civilian_noninstitutionalized" BIGINT,
  "population_without_health_insurance" BIGINT,
  "population_5_years_and_over" BIGINT,
  "population_speaks_a_language_other_than_english" BIGINT,
  "population_speaks_english_less_than_very_well" BIGINT,
  "households_with_limited_english" BIGINT,
  "spanish_limited_english_speaking_households" BIGINT,
  "other_indo_european_languages_limited_english_speaking_2015bd1c" BIGINT  -- Other Indo-European Languages Limited English Speaking Households,
  "asian_and_pacific_island_languages_limited_english_spe_316e53b6" BIGINT  -- Asian And Pacific Island Languages Limited English Speaking Households,
  "other_languages_limited_english_speaking_households" BIGINT,
  "owner_households" BIGINT,
  "renter_households" BIGINT,
  "gross_rent_30_or_more_of_household_income" BIGINT  -- Gross Rent 30% Or More Of Household Income,
  "owner_housing_units_with_a_mortgage_where_selected_mon_a1b0cab7" BIGINT  -- Owner Housing Units With A Mortgage Where Selected Monthly Onwer Costs As A Percentage Of Household Income Can Be Computed,
  "monthly_costs_30_or_more_of_household_income_owners_wi_fe885e5a" BIGINT  -- Monthly Costs 30% Or More Of Household Income (owners With A Mortgage),
  "population_25_years_and_over" BIGINT,
  "household_population" BIGINT,
  "family_household_population" BIGINT,
  "owner_household_population" BIGINT,
  "renter_household_population" BIGINT,
  "meidan_gross_rent" VARCHAR,
  "median_selected_monthly_owner_costs_for_households_wit_c07a5b92" VARCHAR  -- Median Selected Monthly Owner Costs For Households With A Mortgage,
  "per_capita_income" BIGINT,
  "median_household_income" VARCHAR,
  "median_earnings_males_worked_full_time_year_round" VARCHAR,
  "median_earnings_females_worked_full_time_year_round" VARCHAR,
  "household_income_100_000_or_more" BIGINT  -- Household Income $100,000 Or More,
  "family_household_income_100_000_or_more" BIGINT  -- Family Household Income $100,000 Or More,
  "nonfamily_household_income_100_000_or_more" BIGINT  -- Nonfamily Household Income $100,000 Or More,
  "median_family_household_income" VARCHAR,
  "median_nonfamily_household_income" VARCHAR,
  "median_earnings_all_workers" BIGINT,
  "management_business_science_and_arts_occupations" BIGINT  -- Management, Business, Science, And Arts Occupations,
  "service_occupations" BIGINT,
  "sales_and_office_occupations" BIGINT,
  "natural_resources_construction_and_maintenance_occupations" BIGINT  -- Natural Resources, Construction, And Maintenance Occupations,
  "production_transportation_and_material_moving_occupations" BIGINT  -- Production, Transportation, And Material Moving Occupations,
  "households_with_people_under_18_years" BIGINT,
  "households_with_people_65_years_and_over" BIGINT,
  "working_age_adults_to_64_years" BIGINT
);