Historical Inspection Requests
This dataset includes requests for inspections not associated with issuance of a permit, beginning in November 1997 and ending in March 2005, from the Safety and Permits Information Network (SPIN). Inspection requests include complaints about violations of City code reported to Safety and Permits (e.g. building, zoning, and health codes) as well as non-complaint-related inspection requests for new business applications, alcoholic beverage outlets (ABO), zoning verifications, subdivisions, and address changes.
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 \"nola-gov/historical-inspection-requests-grqp-bvwk\".\"historical_inspection_requests\"
LIMIT 100
"}
EOFSee the Splitgraph documentation
for more information.
