Temporary Residences: Last Inspection

This dataset includes the name and location of active Temporary Residences operating in New York State. Active Temporary Residences include only facilities that were categorized as active (i.e., hotel, motel, or cabin colony occupied by or maintained for the occupancy by 11 people or more) on the date the data was downloaded from a Department of Health database. This data also includes the date of the last inspection and violations of Subpart 7-1 of the New York State Code of Rules and Regulations that were identified during that inspection. Additionally, the data includes the Temporary Residence owner-operator, building type, number of sleeping rooms within the facility, and whether a pool, beach, or food service establishment is operated as part of the facility. The location of the Temporary Residence includes its street address, city, state, zip code, municipality, and county.

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 \"health-data-ny-gov/temporary-residences-last-inspection-jcb4-hcyb\".\"temporary_residences_last_inspection\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.