Weekly DSS Application Activity Before and During COVID-19 Emergency

Paper and online applications submitted directly to the Department of Social Services by week since the week of 2/3/2020. Does not include MAGI Medicaid or CHIP applications. Includes:

Weekly applications received: All programs

Weekly applications received: Cash assistance

Weekly applications received: Non-MAGI medical assistance

Weekly applications received: SNAP

Daily average applications received: All programs

Daily average applications received: Cash assistance

Daily average applications received: Non-MAGI medical assistance

Daily average applications received: SNAP

Percentage of weekly applications: Cash assistance

Percentage of weekly applications: Non-MAGI medical assistance

Percentage of weekly applications: SNAP

Weekly Percent Change Compared to Average Week before Mar 16 (baseline): All programs

Weekly Percent Change Compared to Average Week before Mar 16 (baseline): Cash assistance

Weekly Percent Change Compared to Average Week before Mar 16 (baseline): Medical assistance

Weekly Percent Change Compared to Average Week before Mar 16 (baseline): SNAP

Data updated weekly.

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 \"ct-gov/weekly-dss-application-activity-before-and-during-ymej-83fh\".\"weekly_dss_application_activity_before_and_during\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.