Iowa Aging Services Consumer Counts by Fiscal Year, Age Group, and Service

Data provides consumer counts for services provided to aging citizens of Iowa funded through federal and state programs starting in 2009 and is updated annually. It includes self-reported demographic information for services provided by age group, gender, live alone status, rural status, poverty status, racial identity, and ethnicity (per U.S. Census definitions). Counts include only those individuals who provided a response on intake. Intakes are completed on service initiation and annually thereafter. Unduplicated counts are by service; an individual may have received more than one service.

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 \"mydata-iowa-gov/iowa-aging-services-consumer-counts-by-fiscal-year-3qxc-gxc2\".\"iowa_aging_services_consumer_counts_by_fiscal_year\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.