Research talk:Editor month dataset

From Meta, a Wikimedia project coordination wiki

Non-content wikis covered[edit]

I was wondering which non-content wikis are included in the dataset; leaving the result here in case anyone else has the same question:

  • wikimediafoundation.org
  • mediawiki.org
  • meta.wikimedia.org
  • incubator.wikimedia.org

(via:

SELECT DISTINCT wiki FROM staging.editor_month
WHERE wiki NOT RLIKE '^...?wiki' # Wikipedias with 2- or 3-letter language code
AND wiki NOT RLIKE '^.*_.*wiki' # wikis with a "-" in their language code (e.g. zh-min-nan.wikipedia.org )
AND wiki NOT LIKE '%wiktionary'
AND wiki NOT LIKE '%wikisource'
AND wiki NOT LIKE '%wikibooks'
AND wiki NOT LIKE '%wikinews'
AND wiki NOT LIKE '%wikiquote'
AND wiki NOT LIKE '%wikivoyage'
AND wiki NOT LIKE '%wikiversity'
ORDER BY wiki;
+----------------+
| wiki |
+----------------+
| commonswiki |
| foundationwiki |
| incubatorwiki |
| mediawikiwiki |
| metawiki |
| simplewiki |
| sourceswiki |
| specieswiki |
| wikidatawiki |
+----------------+
9 rows in set (0.01 sec)

Regards, Tbayer (WMF) (talk) 06:47, 10 March 2018 (UTC)[reply]