scrapers icon indicating copy to clipboard operation
scrapers copied to clipboard

Published 20 hours ago • verified publisher icon Police-Data-Accessibility-Project

Aurora, CO scraper requested

Open josh-chamberlain opened this issue 2 years ago • 1 comments

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.

josh-chamberlain avatar Sep 24 '21 16:09 josh-chamberlain

Wrong agency ID btw. image Better query is

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

Actual agency id is d416a8794d1c4a31bbf0cb464a40d498

CaptainStabs avatar Oct 25 '21 14:10 CaptainStabs