Premature Death Rate Data
Premature death rate measures mortality by counting deaths at earlier ages more than deaths at later ages. For example, when a person dies at 20, this death contributes 55 years of potential life lost. In contrast, when a person dies at age 70, this death contributes only five years of potential life lost to a county. For our purposes, premature deaths occur before age 75. Counties with older populations are more likely to have higher crude premature death rates than counties with younger populations. Therefore, when age-adjusted, we remove the effect of differently aged populations as a risk factor for premature death. This allows us to make a fair comparison of premature death rates across counties.
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 \"ramseycounty-us/premature-death-rate-data-c8gi-nvxs\".\"premature_death_rate_data\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.