Deaths due to Firearm-related injury (age adjusted) per 100,000 persons, New Jersey, by year: Beginning 2010

Rate: Firearm-related Deaths per 100,000 Persons (age adjusted)

Definition: Deaths with a firearm-related injury as the underlying cause of death.

ICD-10 codes: W32-W34 (unintentional), X72-X74 (suicide), X93-X95 (homicide), Y22-Y24 (undetermined intent), Y35.0 (legal intervention)

Data Sources:

1) Centers for Disease Control and Prevention, National Center for Health Statistics. Compressed Mortality File. CDC WONDER On-line Database accessed at http://wonder.cdc.gov/cmf-icd10.html

2) Death Certificate Database, Office of Vital Statistics and Registry, New Jersey Department of Health

2) Population Estimates, State Data Center, New Jersey Department of Labor and Workforce Development

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 \"healthdata-nj-gov/deaths-due-to-firearmrelated-injury-age-adjusted-kb9q-u2up\".\"deaths_due_to_firearmrelated_injury_age_adjusted\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.