2020 Census Block Groups Top 50 American Community Survey Data With Seattle Neighborhoods
City of Seattle
@usgov.city_of_seattle_2020_census_block_groups_top_50_americ_5e02f184
City of Seattle
@usgov.city_of_seattle_2020_census_block_groups_top_50_americ_5e02f184
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_some_other_race_alone" BIGINT,
"not_hispanic_or_latino_two_or_more_races" BIGINT,
"hispanic_or_latino_of_any_race" BIGINT,
"people_of_color" BIGINT,
"total_households" BIGINT,
"family_households_families" BIGINT,
"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,
"public_transportation_excluding_taxicab" BIGINT,
"no_vehicles_available" BIGINT,
"travel_time_15_minutes" BIGINT,
"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,
"total_housing_units" BIGINT,
"n_1_unit_detached" BIGINT,
"low_density_housing_1_unit_att_4_units" BIGINT,
"medium_density_housing_5_49_units" BIGINT,
"high_density_housing_50_units" BIGINT,
"overcrowded_units_1_occupants_room" BIGINT,
"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,
"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,
"asian_and_pacific_island_languages_limited_english_spe_316e53b6" BIGINT,
"other_languages_limited_english_speaking_households" BIGINT,
"owner_households" BIGINT,
"renter_households" BIGINT,
"gross_rent_30_or_more_of_household_income" BIGINT,
"owner_housing_units_with_a_mortgage_where_selected_mon_a1b0cab7" BIGINT,
"monthly_costs_30_or_more_of_household_income_owners_wi_fe885e5a" BIGINT,
"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,
"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,
"family_household_income_100_000_or_more" BIGINT,
"nonfamily_household_income_100_000_or_more" BIGINT,
"median_family_household_income" VARCHAR,
"median_nonfamily_household_income" VARCHAR,
"median_earnings_all_workers" BIGINT,
"management_business_science_and_arts_occupations" BIGINT,
"service_occupations" BIGINT,
"sales_and_office_occupations" BIGINT,
"natural_resources_construction_and_maintenance_occupations" BIGINT,
"production_transportation_and_material_moving_occupations" BIGINT,
"households_with_people_under_18_years" BIGINT,
"households_with_people_65_years_and_over" BIGINT,
"working_age_adults_to_64_years" BIGINT
);
Anyone who has the link will be able to view this.