CSV Exports
Last updated
Last updated
Both tally reports and ballot count reports can be exported in comma-separated values (CSV) format.
In the CSV tally report, the vote total for each candidate or contest option is listed in a single row. In addition, there are rows for overvote and undervote totals for a contest.
For example, here is an excerpt of a tally report including the results for one contest:
The "Precinct" and "Precinct ID" columns are metadata fields that are included because this example export groups results by precinct. The other fields are standard fields:
If manual results were entered, two additional columns will be added - "Scanned Votes" and "Manual Votes." These columns denote which votes for each selection came from the scanners vs manual entry.
The results of write-in adjudication are always included in the CSV exports. All write-in candidates will appear with their adjudicated name and a UUID assigned by VxAdmin. Unadjudicated write-in candidates will appear as "Unadjudicated Write-In" with the ID "write-in". Unlike in the printed reports, write-in candidates are never consolidated.
The ballot count report CSV is the same as the table presented in the printed ballot count reports. For example:
The "Precinct", "Precinct ID" and "Voting Method" columns are metadata fields that are included because this example export groups results by precinct and voting method. The other fields are standard fields:
Any filters or groupings which apply to each row will be indicated in the row itself by metadata columns. For example, in the example export above, the "Precinct" column lists which precinct group each row represents.
If a row is filtered by a single attribute value (e.g. represents one precinct rather than multiple precincts) then the following basic metadata fields are used:
If a row is filtered by multiple attribute values, the following columns may be used:
In cases as above, where a row value includes comma-separated values, those values will be wrapped in quotation marks per typical CSV formatting in order to allow consumers to properly differentiate columns.
Header | Values |
---|---|
Header | Values |
---|---|
Header | Value |
---|---|
Header | Value |
---|---|
Contest
The title of the contest
Contest ID
The internal identifier of the contest in the election definition
Selection
The candidate name for candidate contests, the option label for yes-no contests, or "Overvotes" or "Undervotes"
Selection ID
The internal identifier of the contest option, or "overvotes" or "undervotes"
Total Votes
The vote count for the selection
BMD
The count of machine marked ballots
HMPB
The count of hand marked paper ballots. In a multi-sheet election, this is just the count of the first sheet
HMPB Sheet {N}
The count of a particular ballot sheet. The count of the second sheet of all ballots would be "HMPB Sheet 2"
Manual
The count of manually entered ballots
Total
The total ballot count
Precinct
The name of the precinct
Precinct ID
The identifier of the precinct from the election definition
Party
The short name of the party e.g. "Republican". Included by default if the ballot style is included, in a primary.
Party ID
The identifier of the party from the election definition
Ballot Style ID
The identifier of the ballot style
Voting Method
"Absentee", "Precinct", or "Provisional"
Scanner ID
The serial number of the scanner. Included by default if the batch is included.
Batch
The label of the scanned batch
Batch ID
The scanner-assigned UUID of the scanned batch
Included Precincts
The precinct identifiers separated by commas
Included Parties
The party identifiers separated by commas
Included Ballot Styles
The ballot style identifiers separated by commas
Included Voting Methods
The voting method labels ("Precinct", "Absentee", or "Provisional") separated by commas
Included Scanners
The scanner serial numbers separated by commas
Included Batches
The batch identifiers separated by commas