An offer from GESIS – Leibniz Institute for the Social Sciences

Wikipedia Editors Information Geoeditors Daily — Snapshot Change

Changed
Previous snapshot
22 Apr 2026, 11:24 (Berlin)
f0111d8327159eedb146c87b0ffb40e0…
This snapshot
2 May 2026, 20:32 (Berlin)
c96e7f43fa2bd59b34006559f6a403e1…

Run Assessment

insignificant claude / claude-haiku-4-5

No visible change. The page's technical fingerprint changed, but no text or links differ - invisible page machinery, not content. Classified automatically without AI analysis.

+ 0 lines added
− 0 lines removed
≈ 114 formatting-only lines
https://wikitech.wikimedia.org/wiki/Data_Platform/Data_Lake/Edits/Geoeditors#Editors_daily

Line-by-line changes

768 lines
−Jump to content
+[Jump to content](https://wikitech.wikimedia.org/wiki/Data_Platform/Data_Lake/Edits/Geoeditors#bodyContent)
 
 Main menu
 
⋯   4 unchanged lines   ⋯
 
 Navigation
 
−Main page
−
−Server admin log: Prod
−
−Admin log: RelEng
−
−Incident status
−
−Deployments
−
−SRE Team Help
+- [Main page](https://wikitech.wikimedia.org/wiki/Main_Page "Visit the main page [z]")
+- [Server admin log: Prod](https://wikitech.wikimedia.org/wiki/Server_Admin_Log)
+- [Admin log: RelEng](https://wikitech.wikimedia.org/wiki/Release_Engineering/SAL)
+- [Incident status](https://wikitech.wikimedia.org/wiki/Incident_status)
+- [Deployments](https://wikitech.wikimedia.org/wiki/Deployments)
+- [SRE Team Help](https://wikitech.wikimedia.org/wiki/SRE/SRE_Team_requests)
 
 Cloud VPS & Toolforge
 
−Cloud VPS portal
−
−Toolforge portal
−
−Request VPS project
−
−Admin log: Cloud VPS
+- [Cloud VPS portal](https://wikitech.wikimedia.org/wiki/Portal:Cloud_VPS)
+- [Toolforge portal](https://wikitech.wikimedia.org/wiki/Portal:Toolforge)
+- [Request VPS project](https://phabricator.wikimedia.org/project/view/2875/)
+- [Admin log: Cloud VPS](https://wikitech.wikimedia.org/wiki/Cloud_VPS_Server_Admin_Log)
 
 wikitech.wikimedia.org
 
−Recent changes
−
−Special pages
−
−Village pump
+- [Recent changes](https://wikitech.wikimedia.org/wiki/Special:RecentChanges "A list of recent changes in the wiki [r]")
+- [Special pages](https://wikitech.wikimedia.org/wiki/Special:SpecialPages "A list of all special pages [q]")
+- [Village pump](https://wikitech.wikimedia.org/wiki/Wikitech:Village_pump)
+
+[Search](https://wikitech.wikimedia.org/wiki/Special:Search "Search Wikitech [f]")
 
 Search
 
−Search
−
−English
+- [English](https://wikitech.wikimedia.org/wiki/Data_Platform/Data_Lake/Edits/Geoeditors#)
 
 Appearance
 
−Donate
−
−Create account
−
−Log in
+- [Donate](https://donate.wikimedia.org/?wmf_source=donate&wmf_medium=sidebar&wmf_campaign=wikitech.wikimedia.org&uselang=en)
+- [Create account](https://wikitech.wikimedia.org/w/index.php?title=Special:CreateAccount&returnto=Data+Platform%2FData+Lake%2FEdits%2FGeoeditors "You are encouraged to create an account and log in; however, it is not mandatory")
+- [Log in](https://wikitech.wikimedia.org/w/index.php?title=Special:UserLogin&returnto=Data+Platform%2FData+Lake%2FEdits%2FGeoeditors "You are encouraged to log in; however, it is not mandatory [o]")
 
 Personal tools
 
−Donate
−
−Create account
−
−Log in
−
−Contents
+- [Donate](https://donate.wikimedia.org/?wmf_source=donate&wmf_medium=sidebar&wmf_campaign=wikitech.wikimedia.org&uselang=en)
+- [Create account](https://wikitech.wikimedia.org/w/index.php?title=Special:CreateAccount&returnto=Data+Platform%2FData+Lake%2FEdits%2FGeoeditors "You are encouraged to create an account and log in; however, it is not mandatory")
+- [Log in](https://wikitech.wikimedia.org/w/index.php?title=Special:UserLogin&returnto=Data+Platform%2FData+Lake%2FEdits%2FGeoeditors "You are encouraged to log in; however, it is not mandatory [o]")
+
+## Contents
 
 move to sidebar
 hide
 
−Beginning
−
−1
−Aggregated data
−
−Toggle Aggregated data subsection
−
−1.1
−Geoeditors Monthly
−
−1.2
−Geoeditors Edits Monthly
−
−1.3
−Unique Editors By Country Monthly
−
−1.4
−Archived report: Geoeditors edits yearly
−
−1.5
−Public bucketed version
−
−2
−Access
−
−3
−Raw data
−
−Toggle Raw data subsection
−
−3.1
−Editors daily
−
−3.2
−wmf_raw.mediawiki_private_cu_changes
−
−4
−Changes and known problems since 2019-09
−
−5
−Data loss 2017
−
−6
−Notes
+- [Beginning](https://wikitech.wikimedia.org/wiki/Data_Platform/Data_Lake/Edits/Geoeditors#)
+- [1
+ Aggregated data](https://wikitech.wikimedia.org/wiki/Data_Platform/Data_Lake/Edits/Geoeditors#Aggregated_data)
+
+ Toggle Aggregated data subsection
+ - [1.1
+ Geoeditors Monthly](https://wikitech.wikimedia.org/wiki/Data_Platform/Data_Lake/Edits/Geoeditors#Geoeditors_Monthly)
+ - [1.2
+ Geoeditors Edits Monthly](https://wikitech.wikimedia.org/wiki/Data_Platform/Data_Lake/Edits/Geoeditors#Geoeditors_Edits_Monthly)
+ - [1.3
+ Unique Editors By Country Monthly](https://wikitech.wikimedia.org/wiki/Data_Platform/Data_Lake/Edits/Geoeditors#Unique_Editors_By_Country_Monthly)
+ - [1.4
+ Archived report: Geoeditors edits yearly](https://wikitech.wikimedia.org/wiki/Data_Platform/Data_Lake/Edits/Geoeditors#Archived_report:_Geoeditors_edits_yearly)
+ - [1.5
+ Public bucketed version](https://wikitech.wikimedia.org/wiki/Data_Platform/Data_Lake/Edits/Geoeditors#Public_bucketed_version)
+- [2
+ Access](https://wikitech.wikimedia.org/wiki/Data_Platform/Data_Lake/Edits/Geoeditors#Access)
+- [3
+ Raw data](https://wikitech.wikimedia.org/wiki/Data_Platform/Data_Lake/Edits/Geoeditors#Raw_data)
+
+ Toggle Raw data subsection
+ - [3.1
+ Editors daily](https://wikitech.wikimedia.org/wiki/Data_Platform/Data_Lake/Edits/Geoeditors#Editors_daily)
+ - [3.2
+ wmf\_raw.mediawiki\_private\_cu\_changes](https://wikitech.wikimedia.org/wiki/Data_Platform/Data_Lake/Edits/Geoeditors#wmf_raw.mediawiki_private_cu_changes)
+- [4
+ Changes and known problems since 2019-09](https://wikitech.wikimedia.org/wiki/Data_Platform/Data_Lake/Edits/Geoeditors#Changes_and_known_problems_since_2019-09)
+- [5
+ Data loss 2017](https://wikitech.wikimedia.org/wiki/Data_Platform/Data_Lake/Edits/Geoeditors#Data_loss_2017)
+- [6
+ Notes](https://wikitech.wikimedia.org/wiki/Data_Platform/Data_Lake/Edits/Geoeditors#Notes)
 
 Toggle the table of contents
 
−Data Platform/Data Lake/Edits/Geoeditors
−
−Page
−
−Discussion
+# Data Platform/Data Lake/Edits/Geoeditors
+
+- [Page](https://wikitech.wikimedia.org/wiki/Data_Platform/Data_Lake/Edits/Geoeditors "View the content page [c]")
+- [Discussion](https://wikitech.wikimedia.org/w/index.php?title=Talk:Data_Platform/Data_Lake/Edits/Geoeditors&action=edit&redlink=1 "Discussion about the content page (page does not exist) [t]")
 
 English
 
−Read
−
−View source
−
−View history
+- [Read](https://wikitech.wikimedia.org/wiki/Data_Platform/Data_Lake/Edits/Geoeditors)
+- [View source](https://wikitech.wikimedia.org/w/index.php?title=Data_Platform/Data_Lake/Edits/Geoeditors&action=edit "This page is protected.
+ You can view its source [e]")
+- [View history](https://wikitech.wikimedia.org/w/index.php?title=Data_Platform/Data_Lake/Edits/Geoeditors&action=history "Past revisions of this page [h]")
 
 Tools
 
⋯   4 unchanged lines   ⋯
 
 Actions
 
−Read
−
−View source
−
−View history
+- [Read](https://wikitech.wikimedia.org/wiki/Data_Platform/Data_Lake/Edits/Geoeditors)
+- [View source](https://wikitech.wikimedia.org/w/index.php?title=Data_Platform/Data_Lake/Edits/Geoeditors&action=edit)
+- [View history](https://wikitech.wikimedia.org/w/index.php?title=Data_Platform/Data_Lake/Edits/Geoeditors&action=history)
 
 General
 
−What links here
−
−Related changes
−
−Permanent link
−
−Page information
−
−Cite this page
−
−Get shortened URL
+- [What links here](https://wikitech.wikimedia.org/wiki/Special:WhatLinksHere/Data_Platform/Data_Lake/Edits/Geoeditors "A list of all wiki pages that link here [j]")
+- [Related changes](https://wikitech.wikimedia.org/wiki/Special:RecentChangesLinked/Data_Platform/Data_Lake/Edits/Geoeditors "Recent changes in pages linked from this page [k]")
+- [Permanent link](https://wikitech.wikimedia.org/w/index.php?title=Data_Platform/Data_Lake/Edits/Geoeditors&oldid=2201789 "Permanent link to this revision of this page")
+- [Page information](https://wikitech.wikimedia.org/w/index.php?title=Data_Platform/Data_Lake/Edits/Geoeditors&action=info "More information about this page")
+- [Cite this page](https://wikitech.wikimedia.org/w/index.php?title=Special:CiteThisPage&page=Data_Platform%2FData_Lake%2FEdits%2FGeoeditors&id=2201789&wpFormIdentifier=titleform "Information on how to cite this page")
+- [Get shortened URL](https://wikitech.wikimedia.org/w/index.php?title=Special:UrlShortener&url=https%3A%2F%2Fwikitech.wikimedia.org%2Fwiki%2FData_Platform%2FData_Lake%2FEdits%2FGeoeditors)
 
 Print/export
 
−Create a book
−
−Download as PDF
−
−Printable version
+- [Create a book](https://wikitech.wikimedia.org/w/index.php?title=Special:Book&bookcmd=book_creator&referer=Data+Platform%2FData+Lake%2FEdits%2FGeoeditors)
+- [Download as PDF](https://wikitech.wikimedia.org/w/index.php?title=Special:DownloadAsPdf&page=Data_Platform%2FData_Lake%2FEdits%2FGeoeditors&action=show-download-screen)
+- [Printable version](https://wikitech.wikimedia.org/w/index.php?title=Data_Platform/Data_Lake/Edits/Geoeditors&printable=yes "Printable version of this page [p]")
 
 Appearance
 
⋯   2 unchanged lines   ⋯
 
 From Wikitech
 
−< Data Platform | Data Lake | Edits
−
−This is a private dataset that shows, in aggregate, what countries editors edit from. It is available only on the private cluster for now as we work out how to publish it for broader use. You can access this dataset on Superset or in the wmf.geoeditors_monthly Hive table.
+< [Data Platform](https://wikitech.wikimedia.org/wiki/Data_Platform "Data Platform") | [Data Lake](https://wikitech.wikimedia.org/wiki/Data_Platform/Data_Lake "Data Platform/Data Lake") | [Edits](https://wikitech.wikimedia.org/wiki/Data_Platform/Data_Lake/Edits "Data Platform/Data Lake/Edits")
+
+This is a private dataset that shows, in aggregate, what countries editors edit from. It is available only on the private cluster for now as we work out how to publish it for broader use. You can access this dataset on [Superset](https://wikitech.wikimedia.org/wiki/Analytics/Systems/Superset "Analytics/Systems/Superset") or in the `wmf.geoeditors_monthly` [Hive](https://wikitech.wikimedia.org/wiki/Analytics/Systems/Cluster/Hive "Analytics/Systems/Cluster/Hive") table.
 
 Public versions of this data:
 
−Analytics/Data_Lake/Edits/Geoeditors/Public
−
−AQS API: Editors by country
−
−meta:Differential_privacy/Completed/Geoeditors
−
−For details on the infrastructure that produces this data source, see Analytics/Systems/Geoeditors .
−
−Aggregated data
+- [Analytics/Data\_Lake/Edits/Geoeditors/Public](https://wikitech.wikimedia.org/wiki/Analytics/Data_Lake/Edits/Geoeditors/Public "Analytics/Data Lake/Edits/Geoeditors/Public")
+- [AQS API: Editors by country](https://wikitech.wikimedia.org/wiki/Analytics/AQS/Editors_by_country "Analytics/AQS/Editors by country")
+- [meta:Differential\_privacy/Completed/Geoeditors](https://meta.wikimedia.org/wiki/Differential_privacy/Completed/Geoeditors "meta:Differential privacy/Completed/Geoeditors")
+
+For details on the infrastructure that produces this data source, see [Analytics/Systems/Geoeditors](https://wikitech.wikimedia.org/wiki/Analytics/Systems/Geoeditors "Analytics/Systems/Geoeditors").
+
+## Aggregated data
 
 There are three datasets available with aggregated data:
 
−wmf.geoeditors_monthly counts editors by country and by wiki. Further, we publish two versions of this data: a yearly aggregate described below and a public bucketed version in the form of files that are updated every month.
−
−geoeditors_edits_monthly counts edits by country and by wiki
−
−unique_editors_by_country_monthly counts editors by country regardless of wiki.
−
−Geoeditors Monthly
−
−The wmf.geoeditors_monthly table is defined as:
−
−column
−
−data type
−
−description
−
−wiki_db
−
−string
−
−The wiki database the editors worked in
−
−country_code
−
−string
−
−The 2-letter ISO country code this group of editors geolocated to, including Unknown (--)
−
−users_are_anonymous
−
−boolean
−
−Whether or not this group of editors edited anonymously
−
−activity_level
−
−string
−
−How many edits this group of editors performed
−
−possible values: "1 to 4", "5 to 99", "100 or more"
−
−distinct_editors
−
−bigint
−
−Number of editors meeting this activity level
−
−namespace_zero_distinct_editors
−
−bigint
−
−Number of editors meeting this activity level, with only namespace zero edits
−
−month
−
−string
−
−[partition] The month in YYYY-MM format
−
−NOTE: while users are grouped by their user_name[ 1] , which is unique across all wikis, anonymous users are grouped by a hash of their User Agent and IP. This can still group multiple editors as one, but it should be rare enough that the numbers are indicative of anonymous editing patterns. Bots are identified as well as possible and filtered out, so this data does not include any bot activity we can identify.
+- `wmf.geoeditors_monthly` counts editors by country and by wiki. Further, we publish two versions of this data: a yearly aggregate described below and a public [bucketed version](https://wikitech.wikimedia.org/wiki/Analytics/Data_Lake/Edits/Geoeditors/Public "Analytics/Data Lake/Edits/Geoeditors/Public") in the form of files that are updated every month.
+- `geoeditors_edits_monthly`counts edits by country and by wiki
+- `unique_editors_by_country_monthly` counts editors by country regardless of wiki.
+
+### Geoeditors Monthly
+
+The `wmf.geoeditors_monthly` table is defined as:
+
+| column | data type | description |
+| --- | --- | --- |
+| wiki\_db | string | The wiki database the editors worked in |
+| country\_code | string | The 2-letter ISO country code this group of editors geolocated to, including Unknown (--) |
+| users\_are\_anonymous | boolean | Whether or not this group of editors edited anonymously |
+| activity\_level | string | How many edits this group of editors performed *possible values:* "1 to 4", "5 to 99", "100 or more" |
+| distinct\_editors | bigint | Number of editors meeting this activity level |
+| namespace\_zero\_distinct\_editors | bigint | Number of editors meeting this activity level, with only namespace zero edits |
+| month | string | **[partition]** The month in YYYY-MM format |
+
+NOTE: while users are grouped by their `user_name`[[1]](https://wikitech.wikimedia.org/wiki/Data_Platform/Data_Lake/Edits/Geoeditors#cite_note-user_id_change-1), which is unique across all wikis, anonymous users are grouped by a hash of their User Agent and IP. This can still group multiple editors as one, but it should be rare enough that the numbers are indicative of anonymous editing patterns. Bots are identified as well as possible and filtered out, so this data does not include any bot activity we can identify.
 
 From this table, you can find the number of editors, with different activity levels, anonymous or logged-in, in a specific project, editing from a specific country. An example query gets all this data for French Wikipedia in March 2018:
 
−select
−country_code,
−users_are_anonymous,
−activity_level,
−sum(distinct_editors) as editor_count
−from wmf.geoeditors_monthly
−where month='2018-03' and wiki_db = 'frwiki'
+```
+select
+ country_code,
+ users_are_anonymous,
+ activity_level,
+ sum(distinct_editors) as editor_count
+from wmf.geoeditors_monthly
+where month='2018-03' and wiki_db = 'frwiki'
 group by country_code, users_are_anonymous, activity_level;
−
−Geoeditors Edits Monthly
−
−The geoeditors_edits_monthly table is defined as:
−
−column
−
−data type
−
−description
−
−wiki_db
−
−string
−
−The wiki database the editors worked in
−
−country_code
−
−string
−
−The 2-letter ISO country code this group of edits geolocated to, including Unknown (--)
−
−edits_are_anonymous
−
−boolean
−
−Whether or not this group of edits were made anonymously
−
−edit_count
−
−bigint
−
−Number of edits
−
−namespace_zero_edit_count
−
−bigint
−
−Number of namespace zero edits
−
−month
−
−string
−
−[partition] The month in YYYY-MM format
−
−This is queried in similar fashion as geoeditor_edits . It is used primarily to report statistics to the Global Innovation Index (GII).
−
−Unique Editors By Country Monthly
−
−The wmf.unique_editors_by_country_monthly is similar to wmf.geoeditors_monthly , however, the data is not aggregated by wiki, thus allowing per country editor counts regardless of any particular project. The table is defined as:
−
−column
−
−data type
−
−description
−
−country_code
−
−string
−
−The 2-letter ISO country code this group of editors geolocated to, including Unknown (--)
−
−users_are_anonymous
−
−boolean
−
−Whether or not this group of editors edited anonymously
−
−activity_level
−
−string
−
−How many edits this group of editors performed
−
−possible values: "1 to 4", "5 to 99", "100 or more"
−
−distinct_editors
−
−bigint
−
−Number of editors meeting this activity level
−
−namespace_zero_distinct_editors
−
−bigint
−
−Number of editors meeting this activity level, with only namespace zero edits
−
−month
−
−string
−
−[partition] The month in YYYY-MM format
−
−It is used primarily to report metrics and dashboards by the Global Data and Insights Team.
−
−Archived report: Geoeditors edits yearly
+```
+
+### Geoeditors Edits Monthly
+
+The `geoeditors_edits_monthly` table is defined as:
+
+| column | data type | description |
+| --- | --- | --- |
+| wiki\_db | string | The wiki database the editors worked in |
+| country\_code | string | The 2-letter ISO country code this group of edits geolocated to, including Unknown (--) |
+| edits\_are\_anonymous | boolean | Whether or not this group of edits were made anonymously |
+| edit\_count | bigint | Number of edits |
+| namespace\_zero\_edit\_count | bigint | Number of namespace zero edits |
+| month | string | **[partition]** The month in YYYY-MM format |
+
+This is queried in similar fashion as `geoeditor_edits`. It is used primarily to report statistics to the Global Innovation Index (GII).
+
+### Unique Editors By Country Monthly
+
+The `wmf.unique_editors_by_country_monthly` is similar to `wmf.geoeditors_monthly`, however, the data is not aggregated by wiki, thus allowing per country editor counts regardless of any particular project. The table is defined as:
+
+| column | data type | description |
+| --- | --- | --- |
+| country\_code | string | The 2-letter ISO country code this group of editors geolocated to, including Unknown (--) |
+| users\_are\_anonymous | boolean | Whether or not this group of editors edited anonymously |
+| activity\_level | string | How many edits this group of editors performed *possible values:* "1 to 4", "5 to 99", "100 or more" |
+| distinct\_editors | bigint | Number of editors meeting this activity level |
+| namespace\_zero\_distinct\_editors | bigint | Number of editors meeting this activity level, with only namespace zero edits |
+| month | string | **[partition]** The month in YYYY-MM format |
+
+It is [used primarily to report metrics and dashboards](https://phabricator.wikimedia.org/T310224 "phab:T310224") by the Global Data and Insights Team.
+
+### Archived report: Geoeditors edits yearly
 
 A yearly report is generated presenting how many edits have been made by country and by wiki over the year. The report is split in two files, one contains edits made on all wikipedia projects, the other contains edits made on wikidata project.
 
−Public bucketed version
−
−A monthly report similar to the Geoeditors monthly, but made for public use.
−
−Access
−
−The easiest way to get to this data is by using Superset , a UI that you can use to access most of our datasources. The example geoeditors dashboard is at https://superset.wikimedia.org/superset/dashboard/9 . As an example, here's a map generated from the data:
+### Public bucketed version
+
+A [monthly report](https://wikitech.wikimedia.org/wiki/Analytics/Data_Lake/Edits/Geoeditors/Public "Analytics/Data Lake/Edits/Geoeditors/Public") similar to the Geoeditors monthly, but made for public use.
+
+## Access
+
+The easiest way to get to this data is by using [Superset](https://wikitech.wikimedia.org/wiki/Analytics/Systems/Superset "Analytics/Systems/Superset"), a UI that you can use to access most of our datasources. The example geoeditors dashboard is at <https://superset.wikimedia.org/superset/dashboard/9>. As an example, here's a map generated from the data:
 
 Screenshot of superset map generated with geoeditors data
 
−Raw data
−
−To compile the geoeditors_monthly dataset, we import MediaWiki's cu_changes table and filter out all the entries for administrative actions. This result is available as the wmf_raw.mediawiki_private_cu_changes table. We then aggregate at the day and user level, labeling anonymous users and generate the wmf.editors_daily table.
−
−Since this raw data identifies the location of individual editors, we keep it for only 90 days, in accordance with our data retention guidelines . Data older than 90 days is continuously purged from the source cu_changes table, but since we regenerate the Data Lake's editing data every month , we instead keep data in mediawiki_private_cu_changes and editors_daily for the two latest calendar months (the month of the latest mediawiki_history snapshot and the previous). Older data may be temporarily available before it is purged, but you should not rely on this.
−
−Editors daily
−
−This can be found in wmf.editors_daily
−
−column
−
−data type
−
−description
−
−wiki_db
−
−string
−
−The wiki database of origin
−
−country_code
−
−string
−
−The 2-letter ISO country code this group of edits geolocated to, including Unknown (--)
−
−user_fingerprint_or_name[ 1]
−
−string
−
−For registered users, it is the global username, unique across all wiki dbs. For anonymous users, it is a hash of IP + user agent.
−
−user_is_anonymous
−
−boolean
−
−Whether or not this user edited this group of edits anonymously
−
−date
−
−string
−
−The YYYY-MM-DD date for this group of edits. Note that date is a reserved word in SQL , so you will need to quote it using backticks in Hive or Spark (`date` ) or double quotes in Presto ("date" ).
−
−edit_count
−
−bigint
−
−The total count of edits for this grouping
−
−namespace_zero_edit_count
−
−bigint
−
−The total count of edits to namespace zero for this grouping
−
−user_is_bot_by
−
−array<string>
−
−Whether this user is identified as a bot, values can be: group, name, both or empty
−
−action_type
−
−int
−
−The action type for this group of actions - see https://www.mediawiki.org/wiki/Manual:Recentchanges_table#rc_type
−
−month
−
−string
−
−[partition] The month in YYYY-MM format, all edits from that month from the cu_changes table are aggregated in this partition
−
−wmf_raw.mediawiki_private_cu_changes
−
−cuc_id bigint 'Primary key, artificial',
−cuc_namespace bigint 'When pages are renamed, their RC entries do _not_ change.',
−cuc_title string 'When pages are renamed, their RC entries do _not_ change.',
−cuc_user bigint 'user_id, rev_user, the id of the user performing the action',
−cuc_user_text string 'user_text, rev_user_text, the name of the user at the time',
−cuc_actiontext string 'Unknown, undocumented',
−cuc_comment string 'The revision comment',
−cuc_minor boolean 'Whether this was a minor edit',
−cuc_page_id bigint 'The id of the page being edited',
−cuc_this_oldid bigint 'rev_id of the revision represented by this change',
−cuc_last_oldid bigint 'rev_id of the previous revision on this page',
−cuc_type int 'see https://www.mediawiki.org/wiki/Manual:Recentchanges_table#rc_type',
−cuc_timestamp string 'mediawiki-formatted timestamp of this event',
−cuc_ip string 'clear-text IP address of the user responsible for this event',
−cuc_agent string 'clear-text user agent of the user responsible for this event'
−
−Changes and known problems since 2019-09
−
−See also m:Research:Page view#Change log for changes to the page view definition itself, as well as Analytics/Data_Lake/Traffic/Pageview_hourly#Changes and known problems since 2015-06-16
−
−Date from
−
−Date until
−
−Task
−
−record_version
−
−Details
−
−2018-01
−
−2019-08
−
−T237072
−
−n/a
−
−The count of namespace_zero_distinct_editors was calculated incorrectly for this period of time, for the "1 to 4" activity level. We replaced the invalid values with null values. All other activity levels and measures are fine for this period of time.
−
−Data loss 2017
−
−2017: November 13th to November 20th, data not computed while the old database was decommissioned. Data will be lost if it's not re-computed by December 13th. As of this writing, we do not have capacity to save this data.
−
−2017: October 25th to November 4th, data not computed while changing database hosts. Data will be lost if it's not re-computed by November 24th (as of this writing, a few days have already been lost)
−
−Notes
−
−↑ 1.01.1 Until August 2022 , user_fingerprint_or_id, that is locally unique to a wiki_db was used.
−
−Retrieved from "https://wikitech.wikimedia.org/w/index.php?title=Data_Platform/Data_Lake/Edits/Geoeditors&oldid=2201789 "
−
−Categories :
−
−Editors data
−
−Data platform
−
−This page was last edited on 1 July 2024, at 18:10.
−
−Text is available under the Creative Commons Attribution-ShareAlike License ;
−additional terms may apply.
−See Terms of Use for details.
−
−Privacy policy
−
−About Wikitech
−
−Disclaimers
−
−Code of Conduct
−
−Developers
−
−Statistics
−
−Cookie statement
−
−Mobile view
+## Raw data
+
+To compile the `geoeditors_monthly` dataset, we import MediaWiki's [`cu_changes` table](https://www.mediawiki.org/wiki/Extension:CheckUser/cu_changes_table "mw:Extension:CheckUser/cu changes table") and filter out all the entries for administrative actions. This result is available as the `wmf_raw.mediawiki_private_cu_changes` table. We then aggregate at the day and user level, labeling anonymous users and generate the `wmf.editors_daily` table.
+
+Since this raw data identifies the location of individual editors, we keep it for only 90 days, in accordance with our [data retention guidelines](https://meta.wikimedia.org/wiki/Data_retention_guidelines "metawiki:Data retention guidelines"). Data older than 90 days is continuously purged from the source `cu_changes` table, but since we [regenerate the Data Lake's editing data every month](https://wikitech.wikimedia.org/wiki/Analytics/Systems/Cluster#Edit_data "Analytics/Systems/Cluster"), we instead keep data in `mediawiki_private_cu_changes` and `editors_daily` for the two latest calendar months (the month of the latest [mediawiki\_history](https://wikitech.wikimedia.org/wiki/Analytics/Data_Lake/Edits/Mediawiki_history "Analytics/Data Lake/Edits/Mediawiki history") snapshot and the previous). Older data may be temporarily available before it is purged, but you should not rely on this.
+
+### Editors daily
+
+This can be found in `wmf.editors_daily`
+
+| column | data type | description |
+| --- | --- | --- |
+| wiki\_db | string | The wiki database of origin |
+| country\_code | string | The 2-letter ISO country code this group of edits geolocated to, including Unknown (--) |
+| user\_fingerprint\_or\_name[[1]](https://wikitech.wikimedia.org/wiki/Data_Platform/Data_Lake/Edits/Geoeditors#cite_note-user_id_change-1) | string | For registered users, it is the global username, unique across all wiki dbs. For anonymous users, it is a hash of IP + user agent. |
+| user\_is\_anonymous | boolean | Whether or not this user edited this group of edits anonymously |
+| date | string | The YYYY-MM-DD date for this group of edits. Note that `date` is a [reserved word in SQL](https://en.wikipedia.org/wiki/List_of_SQL_reserved_words "en:List of SQL reserved words"), so you will need to quote it using backticks in Hive or Spark (`` `date` ``) or double quotes in Presto (`"date"`). |
+| edit\_count | bigint | The total count of edits for this grouping |
+| namespace\_zero\_edit\_count | bigint | The total count of edits to namespace zero for this grouping |
+| user\_is\_bot\_by | array<string> | Whether this user is identified as a bot, values can be: group, name, both or empty |
+| action\_type | int | The action type for this group of actions - see <https://www.mediawiki.org/wiki/Manual:Recentchanges_table#rc_type> |
+| month | string | **[partition]** The month in YYYY-MM format, all edits from that month from the cu\_changes table are aggregated in this partition |
+
+### wmf\_raw.mediawiki\_private\_cu\_changes
+
+```
+cuc_id bigint 'Primary key, artificial',
+cuc_namespace bigint 'When pages are renamed, their RC entries do _not_ change.',
+cuc_title string 'When pages are renamed, their RC entries do _not_ change.',
+cuc_user bigint 'user_id, rev_user, the id of the user performing the action',
+cuc_user_text string 'user_text, rev_user_text, the name of the user at the time',
+cuc_actiontext string 'Unknown, undocumented',
+cuc_comment string 'The revision comment',
+cuc_minor boolean 'Whether this was a minor edit',
+cuc_page_id bigint 'The id of the page being edited',
+cuc_this_oldid bigint 'rev_id of the revision represented by this change',
+cuc_last_oldid bigint 'rev_id of the previous revision on this page',
+cuc_type int 'see https://www.mediawiki.org/wiki/Manual:Recentchanges_table#rc_type',
+cuc_timestamp string 'mediawiki-formatted timestamp of this event',
+cuc_ip string 'clear-text IP address of the user responsible for this event',
+cuc_agent string 'clear-text user agent of the user responsible for this event'
+```
+
+## Changes and known problems since 2019-09
+
+: *See also [m:Research:Page view#Change log](https://meta.wikimedia.org/wiki/Research:Page_view#Change_log "m:Research:Page view") for changes to the page view definition itself, as well as [Analytics/Data\_Lake/Traffic/Pageview\_hourly#Changes and known problems since 2015-06-16](https://wikitech.wikimedia.org/wiki/Analytics/Data_Lake/Traffic/Pageview_hourly#Changes_and_known_problems_since_2015-06-16 "Analytics/Data Lake/Traffic/Pageview hourly")*
+
+| Date from | Date until | Task | record\_version | Details |
+| --- | --- | --- | --- | --- |
+| 2018-01 | 2019-08 | [T237072](https://phabricator.wikimedia.org/T237072) | n/a | The count of namespace\_zero\_distinct\_editors was calculated incorrectly for this period of time, for the "1 to 4" activity level. We replaced the invalid values with null values. All other activity levels and measures are fine for this period of time. |
+
+## Data loss 2017
+
+- 2017: November 13th to November 20th, data not computed while the old database was decommissioned. Data will be lost if it's not re-computed by December 13th. As of this writing, we do not have capacity to save this data.
+- 2017: October 25th to November 4th, data not computed while changing database hosts. Data will be lost if it's not re-computed by November 24th (as of this writing, a few days have already been lost)
+
+## Notes
+
+1. ↑ [1.0](https://wikitech.wikimedia.org/wiki/Data_Platform/Data_Lake/Edits/Geoeditors#cite_ref-user_id_change_1-0)[1.1](https://wikitech.wikimedia.org/wiki/Data_Platform/Data_Lake/Edits/Geoeditors#cite_ref-user_id_change_1-1) [Until August 2022](https://github.com/wikimedia/analytics-refinery/commit/04065669e69006b6bba4d0a5de0b50df9c7dca75), user\_fingerprint\_or\_id, that is locally unique to a wiki\_db was used.
+
+Retrieved from "<https://wikitech.wikimedia.org/w/index.php?title=Data_Platform/Data_Lake/Edits/Geoeditors&oldid=2201789>"
+
+[Categories](https://wikitech.wikimedia.org/wiki/Special:Categories "Special:Categories"):
+
+- [Editors data](https://wikitech.wikimedia.org/wiki/Category:Editors_data "Category:Editors data")
+- [Data platform](https://wikitech.wikimedia.org/wiki/Category:Data_platform "Category:Data platform")
+
+- This page was last edited on 1 July 2024, at 18:10.
+- Text is available under the [Creative Commons Attribution-ShareAlike License](https://creativecommons.org/licenses/by-sa/4.0/);
+ additional terms may apply.
+ See [Terms of Use](https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Terms_of_Use) for details.
+
+- [Privacy policy](https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Privacy_policy)
+- [About Wikitech](https://wikitech.wikimedia.org/wiki/Main_Page)
+- [Disclaimers](https://foundation.wikimedia.org/wiki/General_disclaimer)
+- [Code of Conduct](https://www.mediawiki.org/wiki/Special:MyLanguage/Code_of_Conduct)
+- [Developers](https://developer.wikimedia.org)
+- [Statistics](https://stats.wikimedia.org/#/wikitech.wikimedia.org)
+- [Cookie statement](https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Cookie_statement)
+- [Mobile view](https://wikitech.wikimedia.org/w/index.php?title=Data_Platform/Data_Lake/Edits/Geoeditors&mobileaction=toggle_view_mobile)
 
 Search
 
⋯   3 unchanged lines   ⋯
 
 Data Platform/Data Lake/Edits/Geoeditors
 
−Add topic
+[Add topic](https://wikitech.wikimedia.org/wiki/Data_Platform/Data_Lake/Edits/Geoeditors#)