This issue was converted from https://jira.toolserver.org/browse/DBQ-204.
Summary: SQL query for pages created on dates between October 2011 and March 2013
Issue type: Task - A task that needs to be done.
Priority: Major
Status: Open
Assignee: John R. Frank <jrf@mit.edu>

From: John R. Frank <jrf@mit.edu>

Date: Thu, 21 Mar 2013 16:57:56

Would it be possible for someone to run a SQL query for pages created on dates between October 2011 and March 2013 in the English Wikipedia? This would be very helpful to the TREC KBA research effort at NIST:
http://trec.nist.gov/
http://trec-kba.org

Any text format output is fine. Just need the page creation date and the URL. For example:

2011-10-02T04:04:03Z http://en.wikipedia.org/wiki/Interesting_Topic1
2011-10-02T04:05:03Z http://en.wikipedia.org/wiki/Interesting_Topic2

If the date range is challenging, then limiting to pages created in 2012 or the even just the first half of 2012 would be still be very helpful.

Thank you for your help!

Regards,
John

jrf@mit.edu

Version: unspecified
Severity: normal