About this Dataset

WAOFM - Census - Population And Housing, 2000 And 2010

Population and housing information extracted from decennial census Public Law 94-171 redistricting summary files for Washington state for years 2000 and 2010.
Organization: State of Washington
Last updated: 2020-11-10T17:21:28.884629
Tags: 2000, 2010, census, city, county, housing, ofm, population, state, wa, washington

Tables

Table 1

@usgov.state_of_washington_waofm_census_population_and_housin_5441a2ad.table_1

87.42 kB
281 rows
35 columns

CREATE TABLE table_1 (
  "city_name" VARCHAR,
  "total_population_2000" DOUBLE,
  "total_population_2010" BIGINT,
  "total_population_numeric_change_2000_to_2010" DOUBLE,
  "total_population_percent_change_2000_to_2010" DOUBLE,
  "population_rank_2000" DOUBLE,
  "population_rank_2010" BIGINT,
  "population_rank_change_in_rank_2000_to_2010" DOUBLE,
  "population_density_persons_square_mile_2000" DOUBLE  -- Population Density (Persons / Square Mile) 2000,
  "population_density_persons_square_mile_2010" DOUBLE  -- Population Density (Persons / Square Mile) 2010,
  "population_density_numeric_change_2000_to_2010" DOUBLE,
  "population_density_percent_change_2000_to_2010" DOUBLE,
  "total_housing_units_2000" DOUBLE,
  "total_housing_units_2010" BIGINT,
  "total_housing_units_numeric_change_2000_to_2010" DOUBLE,
  "total_housing_units_percent_change_2000_to_2010" DOUBLE,
  "occupied_housing_units_2000" DOUBLE,
  "occupied_housing_units_2010" BIGINT,
  "vacant_housing_units_2000" DOUBLE,
  "vacant_housing_units_2010" BIGINT,
  "occupancy_rate_2000" DOUBLE  -- Occupancy Rate (%) 2000,
  "occupancy_rate_2010" DOUBLE  -- Occupancy Rate (%) 2010,
  "occupancy_rate_numeric_change_2000_to_2010" DOUBLE,
  "vacancy_rate_2000" DOUBLE  -- Vacancy Rate (%) 2000,
  "vacancy_rate_2010" DOUBLE  -- Vacancy Rate (%) 2010,
  "vacancy_rate_numeric_change_2000_to_2010" DOUBLE,
  "land_area_square_miles_2000" DOUBLE  -- Land Area (Square Miles) 2000,
  "land_area_square_miles_2010" DOUBLE  -- Land Area (Square Miles) 2010,
  "total_area_square_miles_2000" DOUBLE  -- Total Area (Square Miles) 2000,
  "total_area_square_miles_2010" DOUBLE  -- Total Area (Square Miles) 2010,
  "water_area_2000" DOUBLE  -- Water Area (%) 2000,
  "water_area_2010" DOUBLE  -- Water Area (%) 2010,
  "geoid" BIGINT,
  "location_1" VARCHAR,
  "location_1_state" VARCHAR  -- Location 1 (state)
);