bronx-lehman-cuny-edu/bronx-311-air-quality-31913-population-adjusted-a35a-tqkr
Icon for Socrata external plugin
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.

 
Preview
  • bronx_311_air_quality_31913_population_adjusted