DS4UX (Spring 2016)/Panama Papers: Difference between revisions
From CommunityData
| Line 68: | Line 68: | ||
* [https://en.wikipedia.org/wiki/Special:ApiSandbox#action=query&format=json&prop=revisions&list=&meta=&titles=Panama_Papers&rvprop=ids%7Ctimestamp%7Cflags%7Ccomment%7Cuser&rvlimit=1&rvdir=newer View query in sandbox] | * [https://en.wikipedia.org/wiki/Special:ApiSandbox#action=query&format=json&prop=revisions&list=&meta=&titles=Panama_Papers&rvprop=ids%7Ctimestamp%7Cflags%7Ccomment%7Cuser&rvlimit=1&rvdir=newer View query in sandbox] | ||
* [https://en.wikipedia.org/w/api.php?action=query&format=json&prop=revisions&list=&meta=&titles=Panama_Papers&rvprop=ids%7Ctimestamp%7Cflags%7Ccomment%7Cuser&rvlimit=1&rvdir=newer View result in browser] | * [https://en.wikipedia.org/w/api.php?action=query&format=json&prop=revisions&list=&meta=&titles=Panama_Papers&rvprop=ids%7Ctimestamp%7Cflags%7Ccomment%7Cuser&rvlimit=1&rvdir=newer View result in browser] | ||
; How many edits has the creator of Panama Papers made to Wikipedia? | |||
:* [https://en.wikipedia.org/wiki/Special:ApiSandbox#action=query&format=json&list=users&usprop=editcount%7Cregistration&ususers=Czar View query in sandbox] | :* [https://en.wikipedia.org/wiki/Special:ApiSandbox#action=query&format=json&list=users&usprop=editcount%7Cregistration&ususers=Czar View query in sandbox] | ||
:* [https://en.wikipedia.org/w/api.php?action=query&format=json&list=users&usprop=editcount%7Cregistration&ususers=Czar View result in browser] | :* [https://en.wikipedia.org/w/api.php?action=query&format=json&list=users&usprop=editcount%7Cregistration&ususers=Czar View result in browser] | ||
| Line 91: | Line 94: | ||
* View query in sandbox | * View query in sandbox | ||
* View result in browser | * View result in browser | ||
;What other articles are in the ''Category'' Panama Papers? | |||
* [https://en.wikipedia.org/wiki/Special:ApiSandbox#action=query&format=json&prop=&list=categorymembers&titles=Panama+Papers&cmtitle=Category%3APanama_Papers&cmprop=ids%7Ctitle%7Ctimestamp&cmtype=page&cmlimit=50 View query in sandbox] | |||
| Line 96: | Line 102: | ||
* View query in sandbox | * View query in sandbox | ||
* View result in browser | * View result in browser | ||
; How many other articles has Czar edited on Wikipedia since they created the Panama Papers? | |||
* [https://en.wikipedia.org/wiki/Special:ApiSandbox#action=query&format=json&prop=&list=usercontribs&titles=&uclimit=500&ucstart=2016-04-04T17%3A59%3A00.000Z&ucend=2016-05-01T00%3A22%3A24.000Z&ucuser=Czar&ucdir=newer&ucnamespace=0&ucprop=ids%7Ctitle%7Ctimestamp%7Ccomment%7Csize View query in API sandbox] | |||
<br/> | <br/> | ||
Revision as of 02:31, 2 May 2016
This page is a work in progress.
In this project, we will explore a few ways to gather data using two Wikipedia APIs: one provides data related to edits, and the other provides data related to pageviews. Once we've done that, we will extend this to code to create our own datasets of Wikipedia edits or other data that we might be able to use to ask and answer questions in the final session.
Goals
- Get set up to build datasets with Wikipedia APIs
- Have fun collecting different types of data from Wikipedia
- Practice reading API documentation
- Pracice testing API queries in an API Sandbox
- Practice reading and extending other people's code
Download and test the Wikipedia API project
Datasources
Wikipedia Edit API
- the API sandbox - a tool for building queries
Wikipedia Page View API
- Use the experimental API
- This API is a little different because it uses relative paths instead of parameters.
- This API is case-sensitive.
- Request for Panama Papers: https://wikimedia.org/api/rest_v1/metrics/pageviews/per-article/en.wikipedia/all-access/user/Panama_Papers/daily/20160401/20160420
Exercises
Building queries in the Wikipedia editing API Sandbox
- When was the most recent edit to the Panama Papers article?
- When was the article about the Panama Papers created?
- How many edits has the creator of Panama Papers made to Wikipedia?
- What was the text of the Panama Papers article 24 hours after it was created?
- Who has edited the Panama Papers article?
- View query in sandbox
- View result in browser
- What categories is the Panama Papers article in?
- View query in sandbox
- View result in browser
- What other articles are in the Category Panama Papers?
- What other articles does Panama Papers link to?
- View query in sandbox
- View result in browser
- How many other articles has Czar edited on Wikipedia since they created the Panama Papers?
Building queries in the Wikipedia page view API Sandbox
- How many views did Panama Papers have on April 3rd and 4th?
- How many views did Panama papers have on April 3rd and 4th from mobile devices?
Building queries with Python requests
- How many edits did Panama Papers receive in its first 24 hours?
- View result in browser
- How many edits has Panama Papers receive from mobile devices since it was created?
- View result in browser
- How many times was Panama Papers viewed in the first week? What proportion of those views came from mobile devices?
