Annual Population And Housing Estimates For 2020 Census Blocks In Seattle
City of Seattle
@usgov.city_of_seattle_annual_population_and_housing_estimate_8fe3c29e
City of Seattle
@usgov.city_of_seattle_annual_population_and_housing_estimate_8fe3c29e
CREATE TABLE table_1 (
"objectid" BIGINT,
"geoid_20" BIGINT,
"land_acres" DOUBLE,
"water_acres" DOUBLE,
"place" VARCHAR,
"block_name" VARCHAR,
"tract" BIGINT,
"block" BIGINT,
"tract_and_block" DOUBLE,
"all_water_flag_1_0" BIGINT,
"county_name" VARCHAR,
"xcoord" DOUBLE,
"ycoord" DOUBLE,
"population_2010" DOUBLE,
"population_2011" DOUBLE,
"population_2012" DOUBLE,
"population_2013" DOUBLE,
"population_2014" DOUBLE,
"population_2015" DOUBLE,
"population_2016" DOUBLE,
"population_2017" DOUBLE,
"population_2018" DOUBLE,
"population_2019" DOUBLE,
"pl_population_2020" BIGINT,
"population_2020" DOUBLE,
"population_2021" DOUBLE,
"population_2022" DOUBLE,
"population_2023" DOUBLE,
"change_in_population_from_2020" DOUBLE,
"percent_change_in_population_from_2020" DOUBLE,
"household_population_2010" DOUBLE,
"household_population_2011" DOUBLE,
"household_population_2012" DOUBLE,
"household_population_2013" DOUBLE,
"household_population_2014" DOUBLE,
"household_population_2015" DOUBLE,
"household_population_2016" DOUBLE,
"household_population_2017" DOUBLE,
"household_population_2018" DOUBLE,
"household_population_2019" DOUBLE,
"pl_household_population_2020" BIGINT,
"household_population_2020" DOUBLE,
"household_population_2021" DOUBLE,
"household_population_2022" DOUBLE,
"household_population_2023" DOUBLE,
"change_in_household_population_from_2020" DOUBLE,
"percent_change_in_household_population_from_2020" DOUBLE,
"group_quarters_population_2010" DOUBLE,
"group_quarters_population_2011" DOUBLE,
"group_quarters_population_2012" DOUBLE,
"group_quarters_population_2013" DOUBLE,
"group_quarters_population_2014" DOUBLE,
"group_quarters_population_2015" DOUBLE,
"group_quarters_population_2016" DOUBLE,
"group_quarters_population_2017" DOUBLE,
"group_quarters_population_2018" DOUBLE,
"group_quarters_population_2019" DOUBLE,
"pl_group_quarters_population_2020" BIGINT,
"group_quarters_population_2020" BIGINT,
"group_quarters_population_2021" DOUBLE,
"group_quarters_population_2022" DOUBLE,
"group_quarters_population_2023" DOUBLE,
"change_in_group_quarter_population_from_2020" DOUBLE,
"percent_change_in_group_quarter_population_from_2020" DOUBLE,
"housing_units_2010" DOUBLE,
"housing_units_2011" DOUBLE,
"housing_units_2012" DOUBLE,
"housing_units_2013" DOUBLE,
"housing_units_2014" DOUBLE,
"housing_units_2015" DOUBLE,
"housing_units_2016" DOUBLE,
"housing_units_2017" DOUBLE,
"housing_units_2018" DOUBLE,
"housing_units_2019" DOUBLE,
"pl_housing_units_2020" BIGINT,
"housing_units_2020" BIGINT,
"housing_units_2021" DOUBLE,
"housing_units_2022" DOUBLE,
"housing_units_2023" DOUBLE,
"change_in_housing_units_from_2020" DOUBLE,
"percent_change_in_housing_units_from_2020" DOUBLE,
"occupied_housing_units_2010" DOUBLE,
"occupied_housing_units_2011" DOUBLE,
"occupied_housing_units_2012" DOUBLE,
"occupied_housing_units_2013" DOUBLE,
"occupied_housing_units_2014" DOUBLE,
"occupied_housing_units_2015" DOUBLE,
"occupied_housing_units_2016" DOUBLE,
"occupied_housing_units_2017" DOUBLE,
"occupied_housing_units_2018" DOUBLE,
"occupied_housing_units_2019" DOUBLE,
"pl_occupied_housing_units_2020" BIGINT,
"occupied_housing_units_2020" DOUBLE,
"occupied_housing_units_2021" DOUBLE,
"occupied_housing_units_2022" DOUBLE,
"occupied_housing_units_2023" DOUBLE,
"change_in_occupied_housing_units_from_2020" DOUBLE,
"percent_change_in_occupied_housing_units_from_2020" DOUBLE,
"urban_village_number" DOUBLE,
"community_reporting_area_id" DOUBLE
);
Anyone who has the link will be able to view this.