2024 Primary Election Mail Ballot Requests Department of State

This dataset describes the current state of mail ballot requests for the 2024 General Election. It’s a <b>snapshot in time</b> of the current volume of ballot requests across the Commonwealth. The file contains all mail ballot requests except ballot applications that are declined as duplicate.

This point-in-time transactional data is being published for informational purposes to provide detailed data pertaining to the processing of absentee and mail-in ballots by county election offices. This data is extracted once per day from the Statewide Uniform Registry of Electors (SURE system), and it reflects activity recorded by the counties in the SURE system at the time of the data extraction.

Please note that county election offices will continue to process ballot applications (as applicable), record ballots, reconcile ballot data, and make corrections when necessary, and this will continue through, and even after, Election Day. Administrative practices for recording transactions in the system will vary by county. For example, some counties record individual transactions as they occur, while others record transactions in batches at specific intervals. These activities may result in substantial changes to a county's reported data from one day to the next. County practices also differ on when cancelled ballot data is entered into the database (i.e., before or after the election). Some counties do not enter cancelled ballot data entirely.

<b>Type of data included in this file: </b>

This data includes all mail ballot applications processed by counties, which includes voters on the permanent mail ballot list. All application types in this file are considered a type of mail ballot. Some of the applications are considered UOCAVA (Uniformed and Overseas Citizens Absentee Voting Act) or UMOVA (Uniform Military and Overseas Voters Act), these are listed below:

Application Type

• CRI - Civilian - Remote/Isolated

• CVO - Civilian Overseas

• F - Federal (Unregistered)

• M - Military

• MRI - Military - Remote/Isolated

• V - Veteran

• BV - Bedridden Veteran

• BVRI - Bedridden Veteran - Remote/Isolated

*We may not have all application types in the file for every election.

<b>When analyzing the data, please keep in mind the following:</b>

• These codes may change from election to election.

• Counties can enter cancellation codes without entering a ballot returned date.

• Some cancellation codes are part of administrative processes, meaning the ballot was never mailed to the voter before it was cancelled (e.g., there was an error when the label was printed).

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/2024-primary-election-mail-ballot-requests-8yp7-qf6j\".\"2024_primary_election_mail_ballot_requests\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.