| Codebook | ||||||||
| for Local Council Elections Database | ||||||||
| Column | Variable | Description | ||||||
| A | CASE | Unique case number for each candidacy | ||||||
| First four digits indicate year of election | ||||||||
| B | ID | Unique ID number for each candidate | ||||||
| C | NAME | Candidate's name | ||||||
| D | TOWN | Code number for the particular locality | ||||||
| E | TOWN NAME | Name of the particular locality | ||||||
| F | DATE | Date of the election | ||||||
| G | YEAR | Year of the election | ||||||
| H | ROUND | Round of elections conducted in the locality | ||||||
| 1 = First round (1993 - 1994) | 2 = Second round (1996 - 1998) | |||||||
| 2 = Third round (1999 - 2001) | 3 = Fourth round (2002 - 2004) | |||||||
| 5 = Fifth round (2005 - 2007) | 6 = Sixth round (2008 - ) | |||||||
| I | COMPETITION | 1 = Competitive election took place | ||||||
| -1 = No competitive election because the number | ||||||||
| of candidates equaled the number of seats | ||||||||
| J | MAJORITY | Party or group which obtained a majority of Council seats | ||||||
| (See Party variable, below, for identification) | ||||||||
| NO MAJORITY? | ||||||||
| K | MAYOR | 1 = Person was chosen as Mayor | ||||||
| -1 = Person was not chosen as Mayor | ||||||||
| L | INCUMBENT | 1 = Was an incumbent Council member | ||||||
| 0 = Was not an incumbent Council member | ||||||||
| M | SEX | 1 = Male; 2 = Female | ||||||
| N | Q-SHARE | Candidate's percentage of all first-count votes | ||||||
| O | Q-RANK | Candidate's rank in terms of first-count votes | ||||||
| P | P-TOTAL | Number of first-count votes by all members of the | ||||||
| party or group | ||||||||
| Q | P-SIZE | Party's or group's share of all first-count votes | ||||||
| R | P-SHARE | Share of first-count votes by the party or group | ||||||
| S | P-RANK | Candidate's success rank among candidates of the same party or group: | ||||||
| 1 = received highest number of 1st-count votes; 2 = received second-highest | ||||||||
| number of 1st-count votes; etc. | ||||||||
| T | PARTY | 13 = MLP; 15 = PN; 28 = AD; 50 = Independent | ||||||
| For all others, see: www.maltadata.com/ad_hoc_groups.xls | ||||||||
| U | REGISTERED | Number of registered voters | ||||||
| V | VOTING | Number of voters casting a ballot | ||||||
| W | VALID | Number of valid votes | ||||||
| X | INVALID | Number of invalid votes | ||||||
| Y | CANDIDATES | Number of all candidates | ||||||
| Z | OWN CAND. | Number of candidates of this candidate's party or group | ||||||
| AA | BALLOT | Candidate's ranked ballot position | ||||||
| Being at the top of the list = 1; etc. | ||||||||
| AB | AGAIN | Number of times the candidate has competed in Council electons | ||||||
| 1 = first time; 2 = second time; etc. | ||||||||
| AC | ROUNDS | Electoral rounds in which this candidate participated | ||||||
| A = First round (1993 - 1994) | B = Second round (1996 - 1998) | |||||||
| C = Third round (1999 - 2001) | D = Fourth round (2002 - 2004) | |||||||
| E = Fifth round (2005 - 2007) | F = Sixth round (2008 - ) | |||||||
| AD | SEATS | Total of of council seats in this election | ||||||
| AE | QUOTA | The electoral quota in this locality in this election | ||||||
| AF | COUNTS | Number of counts needed to complete the election | ||||||
| AG | WIN | 1 = Candidate won election; 0 = Candidate did not win election | ||||||
| AH | TOPS | The candidate's highest number of votes on any of the counts | ||||||
| AI | COUNT 1 | Number of votes on the first count | ||||||
| thru | etc. ===== to | } ===== | Number of votes on | |||||
| BH | COUNT 26 | } ===== | the subsequent counts | |||||