cityofchicago/311-service-requests-alley-lights-out-historical-t28b-ys7j
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 5 years ago
Indexed 1 month ago

311 Service Requests - Alley Lights Out - Historical

As described in http://bit.ly/311HistoricalPost, the function of this dataset was replaced by https://data.cityofchicago.org/d/v6vf-nfxy. This dataset is historical-only.

This dataset contains all open 311 reports of one or more lights out on a wooden pole in the alley and all completed requests since January 1, 2011. If two requests regarding the same address are made within 30 calendar days of each other, the newest CSR is automatically given the status of “Duplicate (Open)”. Once the alley light is repaired, the CSR status will read “Completed” for the original request and “Duplicate (Closed)” for any duplicate requests. Data is updated daily.

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 \"cityofchicago/311-service-requests-alley-lights-out-historical-t28b-ys7j\".\"311_service_requests_alley_lights_out_historical\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • 311_service_requests_alley_lights_out_historical
     
     
     
     
     
Upstream Metadata