TABLE III. Deaths in 122 U.S. cities

TABLE III. Deaths in 122 U.S. cities - 2015122 Cities Mortality Reporting System ��� Each week, the vital statistics offices of 122 cities across the United States report the total number of death certificates processed and the number of those for which pneumonia or influenza was listed as the underlying or contributing cause of death by age group (Under 28 days, 28 days ���1 year, 1-14 years, 15-24 years, 25-44 years, 45-64 years, 65-74 years, 75-84 years, and ��� 85 years).FOOTNOTE:U: Unavailable -: No reported cases * Mortality data in this table are voluntarily reported from 122 cities in the United States, most of which have populations of 100,000 or more. A death is reported by the place of its occurrence and by the week that the death certificate was filed. Fetal deaths are not included. Totals include unknown ages. * Partial counts for this city.

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 \"cdc-gov/table-iii-deaths-in-122-us-cities-7esm-uptm\".\"table_iii_deaths_in_122_us_cities\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.