Since but 26122 has been fixed, any reason not to use the deletion log instead?
On Thu, Aug 15, 2019 at 10:27 AM Aaron Halfaker <[email protected]> wrote: > Here's a related bit of work: > https://meta.wikimedia.org/wiki/Research:Wikipedia_article_creation > > In this research project, I used a mix of both the deletion log and the > archive table to get a sense for when pages were being deleted. > > Ultimately, I found that the easiest deletion event to operationalize was > to look at the most recent ar_timestamp for a page in the archive table. > I could only go back to 2008 with this metric because the archive table > didn't exist before then. > > The archive table is available in quarry. See > https://quarry.wmflabs.org/query/38414 for an example query that gets the > timestamp of an article's last revision. > > The logging table is also in quarry. See > https://quarry.wmflabs.org/query/38415 for an example query that gets > deletion events. > > On Tue, Aug 13, 2019 at 2:51 PM Haifeng Zhang <[email protected]> > wrote: > > > Dear all, > > > > Is there an easy way to get the number of articles deleted over time > > (e.g., month) in Wikipedia? > > > > Can I use Quarry? What tables should I use? > > > > > > Thanks, > > > > Haifeng Zhang > > _______________________________________________ > > Wiki-research-l mailing list > > [email protected] > > https://lists.wikimedia.org/mailman/listinfo/wiki-research-l > > > _______________________________________________ > Wiki-research-l mailing list > [email protected] > https://lists.wikimedia.org/mailman/listinfo/wiki-research-l > -- Samuel Klein @metasj w:user:sj +1 617 529 4266 _______________________________________________ Wiki-research-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wiki-research-l
