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
"}
EOFSee the Splitgraph documentation
for more information.
