View using General Election Mail Ballot Request by County, Applicant Party Designation with Counts

This view is created from the 2020 General Election Mail Ballot Requests dataset which describes the current state of mail ballot requests. It’s a snapshot in time of the current volume of ballot requests across the Commonwealth.

This view is created to assist with analyzing the original dataset of over 3M rows. This view is an aggregated count of rows by County and by Party Designation.

Original Dataset is here - https://data.pa.gov/Government-Efficiency-Citizen-Engagement/2020-General-Election-Mail-Ballot-Requests-Departm/mcba-yywm

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 \"pa-gov/view-using-general-election-mail-ballot-request-by-3jze-5pr7\".\"view_using_general_election_mail_ballot_request_by\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.