New Official Lists of Washington Counties and Cities

Have you ever needed a list of all of the counties or cities in Washington state? Have you ever needed to know what county a Washington city is in? The Office of Financial Management (OFM) has the answers in its official lists of Washington state counties and cities on data.wa.gov.

Here are some ways to use these datasets:

Look up what county a city is in.
Get the geographic codes for a county or city to share data with someone with GIS skills.
Get the Federal Information Processing Standard (FIPS) codes for cities and counties.
Analyze data that uses FIPS codes along with data that uses city names.
Establish an official list that everyone in an organization uses so there is only one spelling of Pend Oreille, for example.

Download these lists or connect an Excel workbook directly to the lists using an application programming interface (API). If you haven't used an API feed in Excel before, this is a quick feature to learn that keeps your data up to date. Learn how here: Keep Open Data Up to Date in Excel (Using APIs).

How will you use these datasets? Let us know at opendata@wa.gov.