About this Dataset

Washington State Cities And Counties

This dataset contains FIPS (Federal Information Processing Standard), GNIS (Geographic Name Information System common) codes for identifying Washington state counties cities and towns. This is an official list from OFM (Office of Financial Management).
Organization: State of Washington
Last updated: 2023-08-12T16:23:24.992644
Tags: city, county, towns, wa, washington

Tables

Table 1

@usgov.state_of_washington_washington_state_cities_and_counties.table_1

20.62 kB
289 rows
9 columns

CREATE TABLE table_1 (
  "county_name" VARCHAR,
  "county_fips_code" BIGINT,
  "city_name" VARCHAR,
  "city_fips_code" BIGINT,
  "city_fips_code_90" BIGINT,
  "gnis_code" BIGINT,
  "gnis_tiger_format_code" BIGINT,
  "place_name" VARCHAR,
  "multi_county_flag" VARCHAR
);