Nursing Facility Registry

This registry provides a list of licensed nursing facilities in Connecticut as of September 30th each year, beginning with data from 2013. For each facility, this dataset includes aggregate resident demographic information, private pay rates for private and semi-private rooms, payment sources and occupancy levels for each year.

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 \"ct-gov/nursing-facility-registry-rm6f-b9qj\".\"nursing_facility_registry\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.