| 1999 General Election Data |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Overview |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Main sources of data:
Star newspaper website. |
|
|
|
|
|
|
|
|
|
|
http://polls.thestar.com.my/results/results.html |
|
|
|
|
|
|
|
|
|
|
An example page -
http://polls.thestar.com.my/results/01/01p.html |
|
|
|
|
|
|
|
|
original Star data were in multiple pages |
|
|
|
|
|
|
|
|
|
|
these data have been consolidated into a
near-database format, saved in Excel file format |
|
|
|
|
|
|
The data are at best as accurate as Star's data |
|
|
|
|
|
|
|
|
|
|
There are further possibility of error in the
filtering, extraction, and consolidation process |
|
|
|
|
|
|
Users are welcome to do checking or random
checking and to provide feedback |
|
|
|
|
|
|
The Chinese name data are from Kwong Wah Yit
Poh newspaper website |
|
|
|
|
|
|
|
|
http://www.kwongwah.com.my/ge/welcome.htm |
|
|
|
|
|
|
|
|
|
Main output sheet is "Consol by
candidates" |
|
|
|
|
|
|
|
|
|
|
|
This sheet alone consolidate all the data |
|
|
|
|
|
|
|
|
|
|
Other sheets do not offer additional fact |
|
|
|
|
|
|
|
|
|
|
Other sheets, however, include all the links
and can be used to trace the data, check the correctness of the
filtering/linking process |
|
Arrangement, sorting and user tips |
|
|
|
|
|
|
|
|
|
|
|
This database table is arranged by candidates,
and because of multiple candidacy in a district, involves duplicate data by
rows |
|
|
The data can be sorted to show only winning
candidates - by sorting for fields NorP, StateNo, SeatNo2, Won |
|
|
|
Further analyses possible |
|
|
|
|
|
|
|
|
|
|
|
|
|
"Details" field can help further
analyses, with information on the seat, rural or urban setting, employment,
eg |
|
|
|
|
Race component data is also useful for further
analysis |
|
|
|
|
|
|
|
|
|
Previous election vote counts and info also
useful |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Field Names |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Short |
|
Long name |
|
|
|
|
Example |
|
|
|
|
|
|
SeatCode |
Code with State Number, P or N, and SeatNo2 |
|
01P1 for Padang Besar, Perlis, Parliamentary
seat |
|
|
NorP |
|
Negeri or Parlimen seat |
|
|
|
N, P |
|
|
|
|
|
|
StateNo |
State
number, standardised, with "0" in front of single digit |
01 for Perlis |
|
|
|
|
|
SeatNo |
|
Seat No |
|
|
|
|
|
P1 for Padang Besar for Perlis |
|
|
|
|
SeatNo2 |
Seat
number, without "0" in front of single digit. For sorting |
1 for Padang Besar for Perlis |
|
|
|
|
State |
|
State name |
|
|
|
|
Perlis |
|
|
|
|
|
|
SeatName |
Name of location |
|
|
|
|
PADANG BESAR |
|
|
|
|
|
Party |
|
Name of party of candidate |
|
|
|
KEADILAN |
|
|
|
|
|
Coalition |
Name of coalition, only BN or BA |
|
|
BA |
|
|
|
|
|
|
Candidate |
Candiate name |
|
|
|
|
|
|
|
|
|
|
|
Voter |
|
Total number of eligible voters |
|
|
|
|
|
|
|
|
|
|
Turnout |
Total number of turnout for district |
|
|
|
|
|
|
|
|
|
Turnout% |
% of turnout |
|
|
|
|
|
|
|
|
|
|
|
Spoiled |
Spoiled votes for district |
|
|
|
|
|
|
|
|
|
|
VoteWon |
Number of vote won by candidate |
|
|
|
|
|
|
|
|
|
Majority |
Margin between winner and runner-up in this
seat |
|
|
|
|
|
|
|
|
Won |
|
True or Not That The Candidate Won |
|
|
|
|
|
|
|
|
|
DepstFf |
True or Not That Deposit Was Forfeited |
|
|
|
|
|
|
|
|
|
ChinName |
Chinese Name where available |
|
|
|
|
|
|
|
|
|
PrevWin |
Winning candidate in previous election |
|
|
|
|
|
|
|
|
|
PreWCoal |
Winning coalition in previous election |
|
|
|
|
|
|
|
|
|
PreWPty |
Winning party in previous election |
|
|
|
|
|
|
|
|
|
PrevMaj |
Majority in the previous election in this seat |
|
|
|
|
|
|
|
|
PrevVoter |
Total voter number in the previous election |
|
|
|
|
|
|
|
|
CurrVoter |
Total voter number in the current election |
|
Should equal Voter |
|
|
|
|
|
Mal |
|
Ethnic Malay as % of local voter population |
|
|
|
|
|
|
|
|
Chi |
|
Ethnic Chinese as % of local voter population |
|
|
|
|
|
|
|
|
Ind |
|
Ethnic Indian as % of local voter population |
|
|
|
|
|
|
|
|
Oth |
|
Ethnic other groups as % of local voter
population |
|
|
|
|
|
|
|
|
Details |
|
Notes on local voter profile |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
RunnerUp |
Runner up candidate in the latest election |
|
Calculated from formula |
|
|
|
|
Coal-R |
|
Coalition that the runner up candidate belongs
to |
|
Calculated from formula |
|
|
|
|
Party-R |
Party that the runner up candidate belongs to |
|
Calculated from formula |
|
|
|
|
VoteWon2 |
Vote won by the runner up candidate |
|
|
Calculated from formula |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
USED
FOR PROGRAMMING ONLY, FOLDED (Some columns/fields are repeated for programming purpose) |
|
|
|
|
|
|
|
NextSeat |
|
|
|
|
|
|
Beginning row for next P or N seat |
|
|
|
RankInSeat |
|
|
|
|
|
|
Candidate's rank in the seat in terms of vote
count |
|
|
StartingRowOfSeat-ProgrammingOnly |
|
|
|
Beginning
row number for this P or N seat - in full cell address |
|
StartingRowOfSeatRowNumber-ProgrammingOnly |
|
|
Ending
row number for this P or N seat - in row number only |
|
EndingRowOfSeat-ProgrammingOnly |
|
|
|
Ending
row number for this P or N seat - full cell address |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Records |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Records (rows) are presened by current
candidate names. |
|
|
|
|
|
|
|
|
Caution: Substantial duplication ! |
|
|
|
|
|
|
|
|
|
|
Typically, 2 candidates compete in the same
district |
|
|
|
|
|
|
|
|
|
Hence
there are significant duplication of some data on the same district, |
|
|
|
|
|
|
|
|
such as duplicate data on spoiled vote,
turnout, SeatCode, Details, etc |
|
|
|
|
|
|
|
For
example, if there are 2 contestants in Padang Besar, Perlis, the Total Voter,
Majority, |
|
|
|
|
|
|
Spoiled votes data appear twice, with each of
two candidates |
|
|
|
|
|
|
|
Currently,
the records are grouped by |
|
|
|
|
|
|
|
|
|
|
|
State (N) or Parliamentary (P) seats, N for
Negeri or State, P for Parliament |
|
|
|
|
|
|
|
State, eg, 01 for Perlis, 02 for Kedah |
|
|
|
|
|
|
|
|
|
|
|
State seat number, eg, 01P1, 01P2, 01P3, 02P4,
02P5, … and later 01N1, 01N2 |
|
|
|
|
|
|
Coalition by alphabetical order, ie, BA, BN,
IND (independent) |
|
|
|
|
|
|
|
|
Winning candidate |
|
|
|
|
|
|
|
|
|
|
|
In general, the records are currently arranged
by SeatCode and party in alphabetical order, ie, 01P1, 01P1, 01P2, 01P2,
01P3, … |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Sources of
data, consolidation and organisation: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Most of the data came from Star newspaper
website, supplemented with Chinese name data from Kwong Wah Yit Po website. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
There
are 3 sets of files, representing |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Summary of the original data |
|
|
|
|
|
|
|
|
|
|
|
|
File name is |
GE1999-S.XLS |
|
|
|
|
|
|
|
|
|
|
|
Size |
|
Unzipped in MB |
0.7 |
zipped in MB |
0.2 |
|
|
|
|
|
|
|
Contents |
|
This "Legend" intro sheet, and
"consol by candidates" |
|
|
|
|
|
|
|
Notes |
|
This
is a summary of the below file. |
|
|
|
|
|
|
|
|
|
|
|
Full election details are consolidated here |
|
|
|
|
|
|
|
|
|
|
|
Data are in "value" form, not in
linked formula |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Consolidation and processing Excel file |
|
|
|
|
|
|
|
|
|
|
|
File name is |
GE1999.XLS |
|
|
|
|
|
|
|
|
|
|
|
Size |
|
Unzipped in MB |
6 |
zipped in MB |
1.7 |
|
|
|
|
|
|
|
Contents |
|
Legend, "consol by candidates",
intermediate files, webpages from Star imported into Excel |
|
|
|
|
Notes |
|
It contains detailed formula linking, filtering
and consolidating from source files |
|
|
|
|
|
|
|
It also contains some of the source files for
Parliament data |
|
|
|
|
|
|
|
|
|
This large fle GE1999.XLS allows the user to
trace the data backa to the Star HTML files |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Original data from Star and Kwong Wah |
|
|
|
|
|
|
|
|
|
|
|
Files |
|
HTML files presenting 1999 election data in
many ways, spread over many HTML files |
|
|
|
|
|
Format |
|
HTML files, zipped version available |
|
|
|
|
|
|
|
|
|
Location |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Website, directory and file names |
|
|
|
|
|
|
|
|
|
|
|
|
Star newspaper on-line and an example page |
|
|
|
|
|
|
|
|
|
|
|
http://polls.thestar.com.my/results/results.html |
|
|
|
|
|
|
|
|
|
|
http://polls.thestar.com.my/results/01/01p.html |
|
|
|
|
|
|
|
|
|
Kwong Wah Yit Po |
|
|
|
|
|
|
|
|
|
|
|
|
Zipped version is avaialble in the name of |
|
|
|
|
|
|
|
|
|
|
|
polls.thestar.com.my.zip |
1.6MB |
|
|
|
|
|
|
|
|
|
|
|
www.kwongwah.com.my.zip |
0.25MB |
|
|
|
|
|
|
|
|
|
|
Use of zipped source files: |
|
|
|
|
|
|
|
|
|
|
|
|
|
For
the HTML links to function, these files should be unzipped into these folders
under C:\ drive, |
|
|
|
|
|
|
|
c:\my intranet\polls.thestar.com.my\ |
|
|
|
|
|
|
|
|
|
|
|
c:\my intranet\www.kwongwah.com.my\ |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Other ad-hoc analysis files maybe available |
|
|
|
|
|
|
|
|
|
|
|
They are based on the above |
|
|
|
|
|
|
|
|
|
|
|
One example is ineligible.xls, which analyses
the possible impact of 685,000 registered-but-ineligible voters on
Parliamntary seats |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|