#UPRLKA: Complete tweet archive and related visualisation around Sri Lanka’s UPR review

HRC 22
Image courtesy Sydney Morning Herald

On 1st November 2012, Sri Lanka was taken up for discussion as part of the Universal Periodic Review (UPR) at the UN Human Rights Council (HRC). The last UPR was in 2008, and under scrutiny was Sri Lanka’s human rights record over the past four years, that significantly, saw the end of the country’s 27 year old war.

A number of leading Sri Lankan and international human rights organisations, independent media including Groundviews and Vikalpa, as well as other leading voices on Twitter agreed to use #UPRLKA and #UPR14 hashtags in tweets around Sri Lanka’s case at the UPR. Since #UPR14 was a generic hashtag, #UPRLKA was encouraged as the primary hashtag to use when tweeting on Sri Lanka.

Groundviews started to archive every single tweet (and retweet) with #UPRLKA on 29th October (Monday). At the time of writing, we have archived 3,592 tweets, the majority of which were posted on 1st November, leading up to and during the session on Sri Lanka, from 2.30pm – 6pm in Geneva.

Simply put, there is no easy way to archive tweets, and though the company has promised to make this easier for individual accounts later this year, tweets anchored to a specific hashtag, event, process or day, given the sheer quantity of tweets published globally per second, soon disappear, making it close to impossible for students, researchers and historians to search for, access and ascertain the timbre of discussions on the platform days, weeks and months after the peak of content generation. This data loss is a real problem, especially in repressive regimes, where very serious challenges, concerns and entire conversations are conducted and communicated over Twitter.

After evaluating a number of options, we settled on Martin Hawskey’s method to use Twitter’s Developer API with Google Spreadsheet to archive every single #UPRLKA tweet. Setting it up was relatively easy, and we started our archival process the same day #UPRLKA was announced through various platforms, including via a Press Release we sent out, as the hashtag of choice to use during the course of the week for updates dealing with Sri Lanka’s UPR appearance.

Embedded below is the complete list of tweets. Please note that this spreadsheet is automatically updated every half hour with any tweet that has the #UPRLKA hashtag, so the nearly 3,600 we recorded at the time of writing may well increase much more as time goes by.

You can access this spreadsheet in a larger window by clicking here.

Using Martin Hawskey’s template, we’ve also created a comprehensive data visualisation of all the tweets during this week. Again, note that this visualisation is dynamic, and will in the future reflect additional tweets with the #UPRLKA hashtag.

Given the size of the dataset, you’ll also need a fairly powerful computer to see this visualisation, which offers graphical perspectives of every single tweet published, the top tweeters, the top hashtags used and the top conversationalists. You can zoom in and out of the visualisation using the scroll button on your mouse. Clicking on any dot will give you information about the user, including the total number of tweets, replies to tweets and mentions.

Click here or on image above for the live data visualisation.

Finally, all of the tweets archived by us as of today can be download as a PDF here, and as a Microsoft Excel spreadsheet here.

  • Kana

    Tamils want an international independent investigation for the war crimes.Genocide will be proved by the investigation and the solution is the separate nation for the Tamils. We lost more than 200,000 people for a free nation for more than 6 decades.

    • Ponnaiah

      Oh my, so it’s gone up to “200,000” now. The dead must be breeding like rats.

      • silva

        149,000 in the Vanni in the last 8 months + …… in Northeast in the last 30yrs = 200,000+

        • Ponnaiah

          Yes yes, keep cranking those numbers up – but be careful not to go over the entire population of Sri Lanka though, or even gullible idiots will start doing double takes.

  • Ward

    In my 36 yrs of government service I’ve come across several people named Ponniah. This is the first time I see a Ponnaiah.

    • Ponnaiah

      You, a government servant in genocidal Sinhala Lanka? Never! Were you Oberkapo at one of the Tamil concentration camps?

      • Rohith Fonseka

        Just returned from Jaffna. My first visit to the area. Entire nothern province 100 % normal. we were roaming the city until about midnight every day. Commercial activities improving. hotels springing up. stayed at Heritage Hotel 3 or 4 star accomdation. good stuff. service is poor though. kitchen couldnt make a decent Dosai for us. Visited most of the war torn areas including Pudumatalan the final battle area. Infra structure development is commendable. Military is helping develop the area and day to day life of the people. There are less Policemen in the streets than in Colombo. Was told a high rate of burglaries. Military presence noted after 6 pm. Domestic tourism increasing. Great Holiday. Will go there again.

  • Pingback: #unlk: Archive and visualisation of tweets on Sri Lanka at HRC’s 22nd Session | Sri Lanka()