Hi Bruno, Actually I'm not going to answer your question and leave it for others who have developed tools to parse the pagecount files, but while we're on the topic just wanted to point out the "redirects" and title changes. This is something that a good number of people who work with the viewership data overlook. If the title of a page is changed, the history of the page will be moved under the new title and the old title will become a redirect page (normally). But the viewership data will be split. So if you want to, for example, now the viewership of a page with current title B and old title A, you have to add up the viewership to both pages within the period under study. Just something to note... and sorry if you're already doing this! Good luck, Taha On Thu, Jul 28, 2016 at 9:00 PM, Bruno Goncalves &lt;bgoncalves(a)gmail.com&gt; wrote: -- -- ==New Paper== Wikipedia traffic data and electoral prediction: towards theoretically informed models <http://epjdatascience.springeropen.com/articles/10.1140/epjds/s13688-016-0083-3> Taha Yasseri and Jonathan Bright EPJ Data Science, 5:22 (2016). ============= Dr Taha Yasseri http://www.oii.ox.ac.uk/people/yasseri/ Research Fellow in Computational Social Science, Oxford Internet Institute, Research Fellow in Humanities and Social Sciences, Wolfson College, University of Oxford, and Faculty Fellow, Alan Turing Institute for Data Science. Tel. +44-1865-287229 1 St. Giles Oxford OX1 3JS UK

Thank you for the heads up Taha and Federico. I'm not entirely sure redirect will be a big factor in what I'm playing with but I'll definitely keep an eye out for it. From what I gather, there is no simple way to check if there is a redirect page pointing to my page of interest? I have about 400k pages I'm looking at across multiple editions so Pageviews_API might not be enough :) I'll just try my hand at implementing a PAGENAMEE encoding in Python unless there's some library out there that I'm missing. Best, B ******************************************* Bruno Miguel Tavares Gonçalves, PhD Homepage: www.bgoncalves.com Email: bgoncalves(a)gmail.com ******************************************* On Thu, Jul 28, 2016 at 4:48 PM, Federico Leva (Nemo) &lt;nemowiki(a)gmail.com&gt; wrote:

Hi Bruno, look into the redirects table. It's dumped along stub-meta-history. You'll need to join it with page if you want a title -> title edge list. I can share code if you need. Cheers, Giovanni -- Typed with my thumbs On Jul 29, 2016 15:18, "Bruno Goncalves" &lt;bgoncalves(a)gmail.com&gt; wrote:

I believe all timestamps in the database dumps are GMT. Regarding the timestamps of pageview dumps, I have always assumed they would be GMT too, and what I suppose is the source code of the old dumper seems to confirm my intuition: https://phabricator.wikimedia.org/diffusion/ANWC/browse/master/collector.c;… G Giovanni Luca Ciampaglia <http://glciampaglia.com> *∙* Assistant Research Scientist, Indiana University On Sat, Jul 30, 2016 at 1:40 PM, Bruno Goncalves &lt;bgoncalves(a)gmail.com&gt; wrote: