Wikimedia Product/Data dictionary/mediawiki_geoeditors_monthly
This page describes the data set mediawiki_geoeditors_monthly that stores on Druid Datasources, which can be accessed via Superset/Turnilo. mediawiki_geoeditors_monthly on Druid is directly loaded from wmf.mediawiki_geoeditors_monthly on Hive, while wmf.mediawiki_geoeditors_monthly on Hive is extracted from wmf.editors_daily.
Schema
edit| Field name | data type | description | data example | source schema | source field |
|---|---|---|---|---|---|
| distinct_editors | bigint | Number of editors meeting this activity level | 1 | wmf.editors_daily | count(*) |
| users_are_anonymous | boolean | Whether or not this group of editors edited anonymously | 1, 0 | wmf.editors_daily | user_is_anonymous |
| country_code | string | The 2-letter ISO country code this group of editors geolocated to, including Unknown (--) | "CN", "GE", etc. | wmf.editors_daily | country_code |
| activity_level | string | How many edits this group of editors performed, can be "1 to 4", "5 to 99", or "100 or more" | "1 to 4", "5 to 99", "100 or more" | wmf.editors_daily | edit_count |
| wiki_db | string | The wiki database the editors worked in | abwiki | wmf.editors_daily | wiki_db |
| namespace_zero_distinct_editors | bigint | Number of editors meeting this activity level with only namespace zero edits | 4 | wmf.editors_daily | count(*) with condition that namespace_zero_edit_count > 0 |