Rodent Inspection

Dataset contains information on rat inspections.

Rat Information Portal Data Release Notes April 20, 2015

The Rat Information Portal (RIP) is a web-based mapping application where users can view rat inspection data.

Data sources: NYC Department of Health and Mental Hygiene (DOHMH), Division of Environmental Health Pest Control Database

Notes on data limitations: Please note that if a property/taxlot does not appear in the file, that does not indicate an absence of rats - rather just that it has not been inspected. Similarly, neighborhoods with higher numbers properties with active rat signs may not actually have higher rat populations but simply have more inspections.

See our Data Disclaimer:

http://www.nyc.gov/rats

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 \"cityofnewyork-us/rodent-inspection-p937-wjvj\".\"rodent_inspection\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.