A couple of learnings about article deletions from the ACTRIAL analysis: 1. The logging table does not appear to contain correct page IDs of deleted pages until some time in 2014[1]. If you're looking at historical data and want to combine earlier deletions with other information, following Aaron's lead and using the archive table is probably the way to go. 2. The article namespace doesn't just contain "articles", it also contains redirects and disambiguation pages. Particularly redirects can affect measurements of number of pages deleted[2] because there have been instances of cleanup of substantial numbers of redirects. There's no information about redirect status in the archive table, as far as I know, but the log comment can be used to identify a substantial number of such deletions. The code I used in our analysis of deletion reasons, which also covers the article namespace, is on GitHub: https://github.com/nettrom/actrial/blob/master/python/deletionreasons.py Footnotes: 1. https://meta.wikimedia.org/wiki/Research_talk:Autoconfirmed_article_creatio… 2. https://meta.wikimedia.org/wiki/Research_talk:Autoconfirmed_article_creatio… Cheers, Morten On Fri, 16 Aug 2019 at 05:31, Samuel Klein <meta.sj(a)gmail.com> wrote: