Skip to content

Instantly share code, notes, and snippets.

@fgregg
Created May 4, 2015 00:44
Show Gist options
  • Select an option

  • Save fgregg/b9dd2ea43fe0790b352c to your computer and use it in GitHub Desktop.

Select an option

Save fgregg/b9dd2ea43fe0790b352c to your computer and use it in GitHub Desktop.
Chicago FOIA counts
Buildings,https://data.cityofchicago.org/resource/ucsz-xe6d.json?$select=date_trunc_y(date_received)%20as%20year,COUNT(*)&$group=year&$order=year
Revenue,https://data.cityofchicago.org/resource/zrv6-shhf.json?$select=date_trunc_y(date_received)%20as%20year,COUNT(*)&$group=year&$order=year
311,https://data.cityofchicago.org/resource/j2p9-gdf5.json?$select=date_trunc_y(date_received)%20as%20year,COUNT(*)&$group=year&$order=year
Transportation,https://data.cityofchicago.org/resource/u9qt-tv7d.json?$select=date_trunc_y(date_received)%20as%20year,COUNT(*)&$group=year&$order=year
Law,https://data.cityofchicago.org/resource/44bx-ncpi.json?$select=date_trunc_y(date_received)%20as%20year,COUNT(*)&$group=year&$order=year
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment