HHSC CCL Sections and Standards Evaluated Data

This data set contains the list of sections evaluated along with number of standards evaluated and violated in each section for activities (inspections, investigations and assessments) done in each operation. The Operation ID and Activity ID can be used to link back to the HHSC CCL Inspection / Investigation / Assessment Dataset and HHSC CCL Operations Dataset.

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 \"texas-gov/hhsc-ccl-sections-and-standards-evaluated-data-ywgb-2ig8\".\"hhsc_ccl_sections_and_standards_evaluated_data\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.