DEM PCAlert Registered Recipients

Number of People who have registered their personal devices to receive PC Alert Emergency Incident Notifications as compared to 2020 US Census data of number of households x 2 (average number of adults per household). This data is tracked in the system's reports feature.

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 \"internal-open-piercecountywa-gov/dem-pcalert-registered-recipients-ckzv-6zcb\".\"dem_pcalert_registered_recipients\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.