Chao Tianyi
Initium Lab
2015-Nov-23
- 4392 candidates in 1999~2015
name, occupation, party, camp, votes-obtained
- 2039 constituencies in 1999~2015
votes in total, voting rate, count of voters, population
2 dynamic webpages
1 interactive webpage
https://theinitium.com/project/20151012-hk-district-council-elections/
https://theinitium.com/project/20151012-hk-district-council-elections/
https://theinitium.com/project/20151029-hk-district-council-elections-3/desktop.html
We live in a cruel world.
You always cannot get the data you want easily.
4+ weeks 5 people
The government has already deleted
- 1999 disco election website
- 2003 disco election website
- candidate profiles before 2011
(for privacy protection concern)
Use Wayback Machine to find out old and deleted webpages.
Use other credible source, like....book.
- different Chinese used in different year
- short name VS full name
- parties are changing names
This is Solution #2
- over 60% of the candidates in 1999~2011 claimed as "independent"
- dig out their background
- find a standard to label them
- ask Professor Ma Ngok in CUHK for suggestions
Copy and paste info on official website
Input
manually
Generated by table functions, based on raw data on official website
Function: pivot table, sorting, sum, division
Tool: fusion tables, google sheet
working in a data team
infographic, interactive webpage, animation, ...
wise
Visualization
infographic, interactive webpage, animation, ...
Tool list: Google Sheets, Fusion Tables, Tableau, Baidu Echarts, Kumu,..., sketches!