Washington: Washington State Cities and Counties

Source

data.wa.gov

Quality score: 100/100.

Initial recorded revision.

Dataset refresh metadata

Current Source Files

• Washington_State_Cities_and_Counties.csv 20260926191940-6d786cc49df5 Provider source

Contract Versions

• 20260926191940-6d786cc49df5 Copy YAML link

Current Open Data Contract YAML

Open raw YAML

dataset_id: wa-washington-state-cities-and-counties
title: 'Washington: Washington State Cities and Counties'
description: 'Washington: Washington State Cities and Counties discovered from data.wa.gov.'
source_name: data.wa.gov
source_url: https://data.wa.gov/api/views/g2kf-7usg/rows.csv?accessType=DOWNLOAD
update_frequency: adhoc
next_scan_at: '2026-09-29T02:00:00+00:00'
license:
  name: Open Data Commons Public Domain Dedication and License
  url: https://data.wa.gov/demographics/Washington-State-Cities-and-Counties/g2kf-7usg
tags:
- data.wa.gov
- geography
geography:
- Washington
revisions:
- revision_id: 20260926191940-6d786cc49df5
  detected_at: '2026-09-26T19:19:40+00:00'
  source_updated_at: Wed, 02 Aug 2023 18:08:12 GMT
  context: Washington_State_Cities_and_Counties.csv detected from rows.csv.
  assets:
  - asset_id: asset-987fef88728abadf
    name: Washington_State_Cities_and_Counties.csv
    source_url: https://data.wa.gov/api/views/g2kf-7usg/rows.csv?accessType=DOWNLOAD
    media_type: text/csv; charset=utf-8
    content_hash: 987fef88728abadf7ad64055ba857f6d704eb7056d6c5319ac6c58cbd96a7f3f
    size_bytes: 20183
    parent_archive_id: null
  row_count: 289
  headers:
  - COUNTY NAME
  - COUNTY FIPS CODE
  - CITY NAME
  - CITY FIPS CODE
  - CITY FIPS CODE 90
  - GNIS CODE
  - GNIS TIGER FORMAT CODE
  - PLACE NAME
  - MULTI-COUNTY FLAG
  sample_rows:
  - COUNTY NAME: Adams
    COUNTY FIPS CODE: '001'
    CITY NAME: Hatton
    CITY FIPS CODE: '30060'
    CITY FIPS CODE 90: '0555'
    GNIS CODE: '2412736'
    GNIS TIGER FORMAT CODE: '02412736'
    PLACE NAME: Town of Hatton
    MULTI-COUNTY FLAG: 'NO'
  - COUNTY NAME: Adams
    COUNTY FIPS CODE: '001'
    CITY NAME: Lind
    CITY FIPS CODE: '39510'
    CITY FIPS CODE 90: 0685
    GNIS CODE: '2412899'
    GNIS TIGER FORMAT CODE: 02412899
    PLACE NAME: Town of Lind
    MULTI-COUNTY FLAG: 'NO'
  - COUNTY NAME: Adams
    COUNTY FIPS CODE: '001'
    CITY NAME: Othello
    CITY FIPS CODE: '52215'
    CITY FIPS CODE 90: 0945
    GNIS CODE: '2411341'
    GNIS TIGER FORMAT CODE: '02411341'
    PLACE NAME: City of Othello
    MULTI-COUNTY FLAG: 'NO'
  - COUNTY NAME: Adams
    COUNTY FIPS CODE: '001'
    CITY NAME: Ritzville
    CITY FIPS CODE: '58725'
    CITY FIPS CODE 90: '1090'
    GNIS CODE: '2410959'
    GNIS TIGER FORMAT CODE: 02410959
    PLACE NAME: City of Ritzville
    MULTI-COUNTY FLAG: 'NO'
  - COUNTY NAME: Adams
    COUNTY FIPS CODE: '001'
    CITY NAME: Washtucna
    CITY FIPS CODE: '76440'
    CITY FIPS CODE 90: '1390'
    GNIS CODE: '2413453'
    GNIS TIGER FORMAT CODE: '02413453'
    PLACE NAME: Town of Washtucna
    MULTI-COUNTY FLAG: 'NO'
  parser_errors: []
  logical_asset_id: 5cd434a1dba799128122dc26
related_dataset_ids: []
quality:
  score: 100
  parsing_errors: []
  stale_warning: null
  broken_source_report: null
rss_feed_url: null
odc_version: '0.1'
last_successful_scan_at: '2026-09-26T19:19:40+00:00'

Current dbt Source YAML

Open raw YAML

version: 2
sources:
- name: wa_washington_state_cities_and_counties
  description: 'Washington: Washington State Cities and Counties discovered from data.wa.gov.'
  meta:
    opendataodc:
      dataset_id: wa-washington-state-cities-and-counties
      revision_id: 20260926191940-6d786cc49df5
      detected_at: '2026-09-26T19:19:40+00:00'
      source_url: https://data.wa.gov/api/views/g2kf-7usg/rows.csv?accessType=DOWNLOAD
  tables:
  - name: washington_state_cities_and_counties_csv
    description: Source asset Washington_State_Cities_and_Counties.csv.
    meta:
      opendataodc:
        source_url: https://data.wa.gov/api/views/g2kf-7usg/rows.csv?accessType=DOWNLOAD
        content_hash: 987fef88728abadf7ad64055ba857f6d704eb7056d6c5319ac6c58cbd96a7f3f
        row_count: 289
        parser_errors: []
    columns:
    - name: COUNTY NAME
    - name: COUNTY FIPS CODE
    - name: CITY NAME
    - name: CITY FIPS CODE
    - name: CITY FIPS CODE 90
    - name: GNIS CODE
    - name: GNIS TIGER FORMAT CODE
    - name: PLACE NAME
    - name: MULTI-COUNTY FLAG

Sample Rows

Washington_State_Cities_and_Counties.csv

289 parsed rows. 20260926191940-6d786cc49df5