search

Police-Data-Accessibility-Project / scrapers

Code relating to scraping public police data.
https://pdap.io
GNU General Public License v3.0
157 stars 33 forks source link

Aurora, CO scraper requested #152

Closed josh-chamberlain closed 1 year ago

josh-chamberlain commented 2 years ago

Discord user Steel requested information from Aurora Colorado.

https://www.dolthub.com/repositories/pdap/datasets/query/master?q=SELECT+*%0AFROM+%60agencies%60%0Awhere+%60city%60+like+%22Aurora%22&active=Tables

agency id b577cf2d087741e88e8851e1fc48baee in our system, but no current datasets.

CaptainStabs commented 2 years ago

Wrong agency ID btw. image Better query is

SELECT * FROM agencies where city like "Aurora" and state_iso = "CO"

Actual agency id is d416a8794d1c4a31bbf0cb464a40d498