Open data by agency

This dataset includes information about state agencies publishing data on the CT Open Data Portal, including number of datasets, maps, external datasets (href), federated datasets (federated href), and data stories. It also includes a summary of the freshness of the data and the completeness of the metadata by agency.

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/open-data-by-agency-r763-fcmz\".\"open_data_by_agency\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.