Alert Marin Emergency Notification Registrations

Registrations for emergency alert information in Marin County, using the Alert Marin notification system. Data includes number of households in each zip code, and number of registrations, and some percentage registration numbers.

The Adjusted Percent of Households column reflects that more than one person may have signed up per household. So 99% is assumed for any zip codes whereby the number of registrations is greater than the number of households. There cannot be more households signing up than there are households.

The numbers per zip code are adjusted for the Marin County portion of any zip codes that extend beyond the County boundary. Data is collected calendar quarterly starting with the first quarter of 2020.

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 \"marincounty/alert-marin-emergency-notification-registrations-42xa-vdtp\".\"alert_marin_emergency_notification_registrations\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.