Arrow-right Camera

The Spokesman-Review Newspaper The Spokesman-Review

Monday, May 11, 2020  Spokane, Washington  Est. May 19, 1883
Partly Cloudy Day 53° Partly Cloudy

Know Spokane

Know Spokane data repository

Calling this our data repository is a little bit of an overkill, but we wanted to provide our readers an easy way to download the various data that we used for our Know Spokane columns and until we figure out a better way to do so - this page will be the one-stop makeshift repository.

The data we're providing here won't always be the raw, original data. It will most likely be some form of processed data or the near-final version that we used for our analysis. If you're looking for the original data, or wondering if we have something different, you can shoot one of us an email and we'll see if we have it.

Parking ticket data

We received this data from the Spokane Municipal Court and it contains data from 2014-2016. This excel file contains several sheets, and comes in at 16mb.

Download data

Spokane restaurant data

This is a CSV file that we converted from the GeoJSON that we used to power our Know Spokane Restaurant Map.

It has the general categories that we use and the lat/longs as well as address information. We geolocated these locations using various scripts after receiving the original information.

Download data

Spokane road quality data

The original data we received came in the format of a GIS file and from there we extracted the data and cross referenced each block of road with the Spokane city map to group them in their respective neighborhoods.

This is a csv file converted from the spreadsheet that we use to power our database.

Download data

BeerMe data

We requested for a list of registered breweries from the region, narrowed them down to the ones we believe are relevant and local to our readers, and started reaching out to them for their tap list and manually collecting beer data.

This is a csv file converted from the JSON we use for our "Beer Here!" app.

As we update our "Beer Here!" app, this data might end up a little outdated. We will do our very best to keep this as up to date as possible.

Download data

Welcome to The Spokesman-Review’s blog for data about Spokane, North Idaho and the surrounding communities. Some of our projects live on our Know Spokane data site.

We make some of the data we use available here for download.