I've been trying to match edit activity with pagecounts but I've encountered a couple of problems. The amazing pagecounts dumps (https://dumps.wikimedia.org/other/pagecounts-raw/) use the page url to identify the individual page:

      fr.b Special:Recherche/Achille_Baraguey_d%5C%27Hilliers 1 624
while the stub-meta-history uses the "raw" title:

    <title>Wikipedia:Community Portal</title>

so I need an easy way to map title to url. I imagine there some rules on how this "translation" is done? My google-fu has failed to encounter them.

Also, are is timezones mentioned in the meta-history files:


the same as the one used in the pagecount filenames:




Bruno Miguel Tavares Gonçalves, PhD
Homepage: www.bgoncalves.com
Email: bgoncalves@gmail.com