Archive for August 20th, 2010

One last #ausvotes Twitter election related map : Labor vs. Liberal

Posted by Laura on Friday, 20 August, 2010

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.

View full map

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

Related Posts: