SB 272 Data Systems Inventory

California State Senate Bill 272 (SB 272) requires local governments to publish an inventory of their data systems that are both a system of record and that contain information about the public. This dataset is the SB 272 inventory for the County of San Mateo. More information on SB 272 can be found in the text of the law: https://leginfo.legislature.ca.gov/faces/billNavClient.xhtml?bill_id=201520160SB272

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 \"datahub-smcgov/sb-272-data-systems-inventory-jk5a-wjr3\".\"sb_272_data_systems_inventory\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.