5 Year Wikiversary/Making of

Query for number of active users across all wikis for current month (>4 edits in last 30 days)
Reference Mediawiki definition of an active user.

Query for number of active users for each wiki by month (>4 edits in each month)
Reference Mediawiki definition of an active user. The sub-query for each wiki is restricted to revisions after the creation date of that wiki to exclude revisions imported from the EVA wiki, a common practice to bootstrap new wikis.

Query for EVA Wiki revision data based on admins, CX3 non-admins, and non-CX3 users
Note that some users had to be manually included or excluded since they were at one time CX3, but are no-longer in the group. Once the data dump was imported into R (Exploratory),  was applied on the timestamp column (ts).

Query for EVA Wiki view data based on admins, CX3 non-admins, and non-CX3 users
Note that some users had to be manually included or excluded since they were at one time CX3, but are no-longer in the group. Once the data dump was imported into R (Exploratory),  was applied on the timestamp column (ts).

Query for first revision date of each wiki
Note that some users had to be manually included or excluded since they were at one time CX3, but are no-longer in the group. Once the data dump was imported into R (Exploratory),  was applied on the timestamp column (ts).

Query for views and revisions across all wikis
This is a big query that retrieves view and edit events across all wikis, so it takes 1-2 minutes to execute. Once the data dump is imported into R (Exploratory), the following steps should be taken:
 * (make the timestamp a more useable format)
 * (create a new column "hour" from the timestamp)
 * (create a new column "day_of_week" from the timestamp)
 * (make rev_len numeric format)
 * (create a new column "date" with just the date from the timestamp)
 * (create a new column "year" from the timestamp)

The following steps may be taken to further filter the data. The details of which steps and in which order depends on the desired plot.
 * (only show views, not edits) or  (only show edits, not views)
 * (only use rows for the eva wiki, modify to filter by any wiki)
 * (may be used to sort by timestamp for certain plots)
 * (only use rows for user_name "Lwelsh", modify to filter by any user_name)

Query for content page creation dates across all wikis
This query retrieves the wiki name, page title (with wiki name prepended), and timestamp for the creation (first revision) date of each page in the main namespace for each wiki, for pages that are not redirects. Once the data dump is imported into R (Exploratory), the following steps should be taken:
 * (make the timestamp a more useable format)