2024 Heat Related Deaths by Zip Code

Number of heat related deaths, by place of injury, reported by Maricopa County Public Health Department during 2024. Deaths are based on initially certified causes of death reported on the death certificate. Counts are sourced from <a href="https://app.powerbigov.us/view?r=eyJrIjoiZDA3ZTUzNzAtMzIwMS00YzA3LTlhMzEtZmJhZGQzY2FlYmZlIiwidCI6IjMwY2QzNWQ0LTk5NTEtNGE3Mi05NzhlLTg5NjU1MDc1YzE3ZiJ9&pageName=ReportSectionbef9ca449ecbb17eb765">Public Health Heat Related Deaths Dashboard</a>. Zip code centroids sourced from <a href="https://citydata.mesaaz.gov/dataset/Mesa-Zip-Codes/wpn5-n8am/about_data">Mesa Zip Codes</a>.

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 \"citydata-mesaaz-gov/2024-heat-related-deaths-by-zip-code-hhmy-8dpz\".\"2024_heat_related_deaths_by_zip_code\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.