03-19-2024-2C FILE DESCRIPTION-FINAL SOV AND OFFICIAL CANVASS REPORT.PDF
Extracted text (via pymupdf)
4963 characters
The file is sorted by contest, based on the ContestOrder and then by PrecinctOrder and finally there is a record for each Candidate/Choice sorted by CandidateOrder within that contest. Some content for the contest and precinct is repeated on each candidate line while other columns are specific to the candidate/choice on that line. At the end of each set of records for a contest there will be an additional set of records for each candidate. The PrecinctId column will be blank on these rows and the PrecinctOrder will be 1000000. Normally these rows will contain no turnout or votes cast and would only contain data if a user performs manual data entry of results for the contest without specifying the precinct the votes should be allocated to. ContestId Sequential number assigned by the system for each contest. (may not match ContestOrder) ContestExtId Optional user assigned alphanumeric identifier. ContestName Alphanumeric ContestPartyAffiliation The contest is associated with an elector group, if that elector group is associated with a political party the abbreviation for that party will be shown. ContestVoteFor Numeric value for the vote-for ContestType From the Office record associated with the contest, either “Candidacy” or “Measure” ContestOrder Numeric value from the Global Order field of the contest PrecinctId Sequential number assigned by the system for each precinct (may not match PrecinctOrder) PrecinctExtId Optional user assigned alphanumeric identifier. PrecinctName Alphanumeric PrecinctOrder Numeric value from the Global Order field of the precinct PrecinctStatus 0 or 1, depending on whether the x-of-y value has been triggered showing the precinct as reported. Depending on various system setup option, x-of-y may or may not work. Specifically, if election day tabulators are setup with all precincts the ability to calculate x-of-y becomes more complicated. PrecinctRegistered Total registered voters from the main screen of the precinct record or in the case of a split precinct the total registered voters from all splits. In the case of a split precinct this may not be the same as the voters eligible for the specific contest on this record. PrecinctTurnout Total precinct turnout, in the case of a split precinct this may not be the same as turnout of the specific contest on this record. In the case of a multicard ballot, this would be the count of the first cards counted. PrecinctTurnoutPerc A calculated percentage value using the two previous columns (ex. 10% shown as .10) CandidateId Sequential number assigned by the system for each candidate CandidateExtId Optional user assigned alphanumeric identifier. CandidateName Alphanumeric CandidateType R=Regular, W=Write-in, M=Measure Response, N=“No Candidate” CandidateAffiliation Abbreviation of the party associated with the candidate, if any CandidateOrder While the order value is not specific to the contest, candidates do appear on the ballot and on reports in the relative order of this value within the contest. Registered Total registered voters for the contest and precinct on this record. It only includes registration numbers for the specific splits containing the contest and/or the elector group (party) containing the contest. Turnout Number of ballots counted containing this specific contest and precinct TurnoutPerc A calculated percentage value using the two previous columns (ex. 10% shown as .10) Overvotes Number of overvotes for this contest and precinct. In the case of a vote-for greater than 1, each overvoted ballot is counted as the vote-for. Undervotes Number of undervotes for this contest and precinct. Votes Votes cast for this specific candidate in this precinct. After this point the column content becomes variable depending on the counting groups defined for this particular election. For each counting group there will be four columns added, with each column containing the name of the counting group. For a normal primary or general election there will likely be two counting groups, “Early Vote” and “Election Day”, but for smaller jurisdictional elections that are all mail there may only be a single counting group called something like “Ballot By Mail”. Since these counting group names and their order are user defined, the column headings may be different from one election to the next if not careful. Turnout_*CG* Number of ballots counted containing this specific contest and precinct for ballots in this counting group Overvotes_*CG* Number of overvotes for this contest and precinct for ballots in this counting group. In the case of a vote-for greater than 1, each overvoted ballot is counted as the vote-for. Undervotes_*CG* Number of undervotes for this contest and precinct for ballots in this counting group. Votes_*CG* Votes cast for this specific candidate in this precinct for ballots in this counting group.