Before I went to bed, I wanted one last Australian related election post. This post draws on the data and methodology from my other posts and maps.
At around 6pm, I did four additional keyword searches on Searchtastic beyond the ones in my most recent post. These were: #ausvotes, #donttrustabbott, #nocleanfeeds, #electionwire. I added them to my complete list of Tweets, then filtered the tweets based on username, location and tweet to remove duplicate tweets. This brought the total of 60,0084 Tweets down to 54,962. I then added three columns: City, State, Country. For the next few hours, I endeavored to fill in as many city fields as I could. The focus was on identifying Australian cities. Thus, for countries not Australia, I just listed the country or unknown. This was so I knew to ignore those. At 8pm, I stopped completing the fields. I just don’t have time to label everything…
Of those 54,962 tweets, some form of identification was completed for 34,213 tweets or 62% of all tweets. (Not a bad sample size from the whole.) Of these tweets, 19,165 came from Australia. Of these, 15,629 have Australian cities identified for the location of the Tweet. That I can play with.
The next step is to identify noise of Liberal, Labor and the Greens by city. The following CONTAINS filters were created on Excel to find tweets to get location data: Labor OR Gillard, Abbott OR Liberal, Brown or Greens. There were 1207, 977 and 302 tweet locations respectively. After this, the total number of Tweets per city for those terms was counted. There were 61 cities with Labor tweets, 62 cities with Liberal tweets, 38 cities with Green tweets.
After this was done, city locations were geocoded for mapping. I like to use BatchGeo. This gives me Latitude and Longitude which make the dots on the map locate more accurately. The tables were then ported over to Geocommons Maker and the following map was generated.
In table form, this map looks like:
City | States | Country | Labor Count | Liberal Count | Green Count |
Adelaide | South Australia | Australia | 56 | 66 | 6 |
Alice Springs | Northern Territory | Australia | 1 | 1 | 1 |
Ballarat | Victoria | Australia | 2 | 1 | 1 |
Bathurst | New South Wales | Australia | 1 | ||
Bayside | Victoria | Australia | 4 | 2 | |
Beechworth | Victoria | Australia | 1 | 1 | 1 |
Bellingen | New South Wales | Australia | 1 | ||
Blacktown | New South Wales | Australia | 47 | 54 | 6 |
Blue Mountains | New South Wales | Australia | 3 | ||
Boroondara | Victoria | Australia | 1 | ||
Bowen Hills | Queensland | Australia | 1 | ||
Brisbane | Queensland | Australia | 71 | 69 | 16 |
Brunswick West | New South Wales | Australia | 1 | 1 | |
Bunbury | Western Australia | Australia | 11 | 8 | 1 |
Bundaberg | Queensland | Australia | 1 | ||
Burwood | New South Wales | Australia | 3 | ||
Cairns | Queensland | Australia | 2 | 3 | |
Canberra | Australian Capital Territory | Australia | 62 | 63 | 33 |
Carlton | Victoria | Australia | 21 | 11 | 21 |
Chittaway Bay | New South Wales | Australia | 1 | ||
Clay Wells | South Australia | Australia | 1 | ||
Clovelly | New South Wales | Australia | 1 | 1 | |
Coffs Harbour | New South Wales | Australia | 1 | 1 | |
Cremorne | New South Wales | Australia | 1 | ||
Darwin | Northern Territory | Australia | 2 | 1 | |
Enmore | New South Wales | Australia | 2 | 4 | |
Footscray | Victoria | Australia | 1 | 1 | |
Fremantle | Western Australia | Australia | 2 | 2 | |
Geelong | Victoria | Australia | 1 | 2 | 2 |
Gold Coast | Queensland | Australia | 107 | 37 | 2 |
Gordon | New South Wales | Australia | 1 | ||
Gosford | New South Wales | Australia | 7 | 1 | |
Goulburn | New South Wales | Australia | 1 | 1 | |
Hastings | Victoria | Australia | 7 | 1 | |
Hobart | Tasmania | Australia | 8 | 10 | 7 |
Illawarra | New South Wales | Australia | 1 | 1 | |
Indooroopilly | Queensland | Australia | 1 | ||
Ipswich | Queensland | Australia | 1 | ||
Joondalup | Western Australia | Australia | 1 | ||
Katoomba | New South Wales | Australia | 1 | ||
Kellyville Ridge | New South Wales | Australia | 2 | ||
Kuranda | Queensland | Australia | 1 | 1 | 1 |
Launceston | Tasmania | Australia | 1 | 2 | |
Lithgow | New South Wales | Australia | 1 | ||
Mackay | Queensland | Australia | 5 | 3 | 2 |
Macleod | Victoria | Australia | 1 | ||
Mallala | South Australia | Australia | 1 | ||
Matraville | New South Wales | Australia | 1 | ||
Melbourne | Victoria | Australia | 195 | 188 | 63 |
Mitt | New South Wales | Australia | 1 | 1 | |
Moe | Victoria | Australia | 1 | ||
Mount Druitt | New South Wales | Australia | 3 | 3 | |
Mt. Isa | Queensland | Australia | 1 | ||
Newcastle | New South Wales | Australia | 33 | 20 | 9 |
Newtown | New South Wales | Australia | 1 | 1 | 1 |
North Melbourne | Victoria | Australia | 2 | 3 | 1 |
North Sydney | New South Wales | Australia | 10 | 4 | 1 |
Northcote | Victoria | Australia | 1 | ||
Orange | New South Wales | Australia | 2 | ||
Parkville | Victoria | Australia | 1 | 1 | |
Perth | Western Australia | Australia | 157 | 70 | 12 |
Point Cook | Victoria | Australia | 1 | ||
Port Macquarie | New South Wales | Australia | 13 | 5 | 3 |
Prahran | Victoria | Australia | 1 | ||
Quakers Hill | New South Wales | Australia | 1 | ||
Randwick | New South Wales | Australia | 1 | ||
Redcliffe | Queensland | Australia | 1 | 1 | |
Ringwood | Victoria | Australia | 2 | 1 | |
Robina | Queensland | Australia | 1 | ||
Rockhampton | Queensland | Australia | 2 | 2 | |
Sassafras | Victoria | Australia | 1 | ||
Shellharbour | New South Wales | Australia | 1 | ||
Shoalhaven | New South Wales | Australia | 3 | ||
South Morang | Victoria | Australia | 1 | ||
Spence | Australian Capital Territory | Australia | 1 | ||
St Leonards | Victoria | Australia | 1 | ||
St. Kilda | Victoria | Australia | 1 | ||
Strathfield | New South Wales | Australia | 1 | 3 | |
Sunshine Coast | Queensland | Australia | 4 | ||
Surry Hills | New South Wales | Australia | 1 | ||
Sydney | New South Wales | Australia | 336 | 298 | 87 |
Torquay | Victoria | Australia | 1 | ||
Townsville | Queensland | Australia | 1 | 1 | 1 |
Vermont | Victoria | Australia | 1 | 1 | |
Wagga Wagga | New South Wales | Australia | 1 | ||
Windsor | Queensland | Australia | 1 | ||
Wolli Creek | New South Wales | Australia | 1 | 1 | |
Wollongong | New South Wales | Australia | 4 | 3 | 1 |
Woodside | South Australia | Australia | 3 |