Preference Data for each ballot paper scrutinised at the election (including informal papers).
The link below is a download link and contains a zip file with all Legislative Assembly preference markings for the district of Willoughby.
Each record in the file represents a preference marking. The format has been determined to allow the greatest flexibility for analysis using excel pivot tables. The file has the following format and can be readily imported into an excel spreadsheet as a tab delimited file.
| Field Name | Field Value | Data Type |
|---|---|---|
| District | Short District Name | Varchar, not null |
| PollingPlaceName | This field holds either the Venue name where vote is taken for a voting centre or early voting centre which holds all the votes for all venues within each district or 'Enrolment/Provisional', 'iVote', 'Postal'. | Varchar, not null |
| BPNumber | Virtual ballot paper id which uniquely identifies a ballot paper within a contest. Not a unique record id. | Integer, not null |
| Formality | Identifies if ballot paper is Formal or Informal. | Varchar, not null |
| CandidateName | Candidate name as shown on the ballot. | Varchar, not null |
| PrefMarking | Preference marking as shown on the ballot paper. Either a series of numbers comprising characters 0 to 9 or / or x. | Varchar or null |
| PrefCounted | Preference number as interpreted from preference marking used in count. Must be an integer greater than zero. Only shown where the formality of the ballot paper is Formal. | Integer, not null |
The formality rules used to determine the formality in the above file are Ballot paper formality guidelines for Legislative Assembly [116 KB PDF]
The legislation defining the LA count can be found at Constitution Act - Seventh Schedule Conduct of Legislative Assembly elections