CSV Exports

Both tally reports and ballot count reports can be exported in comma-separated values (CSV) format.

Tally Report CSV Structure

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:

Precinct,Precinct ID,Contest,Contest ID,Selection,Selection ID,Total Votes
West Lincoln,20,Mayor,mayor,Sherlock Holmes,sherlock-holmes,0
West Lincoln,20,Mayor,mayor,Thomas Edison,thomas-edison,0
West Lincoln,20,Mayor,mayor,Write-In,write-in,0
West Lincoln,20,Mayor,mayor,Overvotes,overvotes,0
West Lincoln,20,Mayor,mayor,Undervotes,undervotes,0

Formatted version of the above CSV excerpt

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:

Header	Values
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

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.

Ballot Count Report CSV Structure

The ballot count report CSV is the same as the table presented in the printed ballot count reports. For example:

Precinct,Precinct ID,Voting Method,BMD,HMPB,Total
West Lincoln,20,Precinct,0,0,0
West Lincoln,20,Absentee,0,0,0
East Lincoln,21,Precinct,0,0,0
East Lincoln,21,Absentee,0,0,0
South Lincoln,22,Precinct,0,0,0
South Lincoln,22,Absentee,0,0,0
North Lincoln,23,Precinct,0,0,0
North Lincoln,23,Absentee,0,0,0

Formatted version of the above CSV excerpt

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:

Header	Values
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

Shared Metadata Structure

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:

Header	Value
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

If a row is filtered by multiple attribute values, the following columns may be used:

Header	Value
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

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.