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:

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:

B