Open repository in Console
Readme
Updated almost 5 years ago
‧ Indexed 1 month ago
Bronx 311 Air Quality 3.19.13 (population adjusted)
This is a 311 dataset combined with 2010 Census population data. The rate of air-quality complaints were divided by the population to get what is called a "population index" in get a better idea of the nature of the air-quality complaints. The more people there are in a given area, the more likely there will be more complaints. This is an attempt to correct for the population density in each census tract. The data is updated daily, so this is a snapshot of all of the complaints from 1/1/2010 to 3/19/2013.
Querying over HTTP
Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:
curl https://data.splitgraph.com/sql/query/ddn \ -H "Content-Type: application/json" \ -d@-<<EOF {"sql": " SELECT * FROM \"bronx-lehman-cuny-edu/bronx-311-air-quality-31913-population-adjusted-a35a-tqkr\".\"bronx_311_air_quality_31913_population_adjusted\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.