Data Platform/Discover data

Data Platform

Discover data

• Explore datasets in DataHub
• Data Lake
  • Traffic data
  • Edits data
  • Content data
  • Events data
• Analytics Query Service (AQS)

Access, query, and analyze data

• Get access to internal data
• Analytics tools
  • Jupyter notebooks
  • Superset
  • Spark
  • Presto
• Quickstart notebook
• Internal API requests

Transform and publish data

• Get help or file a request
• Plan data lifecyle
• Build tables and datasets
  • Dataset creation process
  • Data modeling guidelines
  • Airflow developer guide
  • Hive
  • Iceberg
  • Druid
• Share data and dashboards
  • Data publication guidelines
  • Turnilo
  • Superset
  • Web publication guide
  • Dashiki
• Manage published data
  • Data incident management
  • Data issue reporting
  • Data retention guidelines
  • Event data retention
  • Event sanitization
  • Dataset archiving and deletion

Collect data

• Test Kitchen
• Instrumentation tutorial
• Event Platform

---

Data Platform infrastructure and operations

• Systems overview
• Data pipelines
• Search
  • Using search for new features
  • Search Platform
  • Wikidata Query Service (WDQS)
• Operations and team processes
  • Ops week
  • Team pages on Wikitech
  • Team and project pages on MediaWiki.org

[ ]

This page provides links to data documentation for private and public Wikimedia data sources. Its primary audience is WMF data analysts, product teams, and researchers who have an official non-disclosure agreement with the Wikimedia Foundation.

• Private data requires production data access . It includes datasets in WMF's Data Lake : a large, analytics-oriented repository of data about Wikimedia projects.
• A selection of public data sources are linked here, but public Wikimedia data is described more fully at meta:Research:Data .

Traffic data

Analytics data about wiki pageviews and site usage.

Private traffic data

Most Data Lake traffic datasets are updated at hourly granularity, with 2-3 hours lag behind real-time. This data includes:

• Webrequests
• Pageviews
• Unique devices

Full dataset list at Data Lake/Traffic .

View datasets tagged with "traffic" in DataHub (requires a developer account )

Public traffic data

APIs:

• Wikimedia Analytics API (page views, unique devices, media requests, and more)

Specialized datasets:

• Differentially private pageviews

Dumps :

• Pageview hourly & daily
• Daily pageviews (d0cmf, records grouped by local wikis)
• Mediacounts
• Clickstream

Dashboards:

• Browser statistics
• Readers:Pageviews and Unique Devices
• Wikistats
• Pageviews tool
• WikiNav

Content data

Datasets that contain full content of revisions for Wikimedia wikis.

Private content data

• mediawiki_content_history_v1 : full content of all revisions, past and present, from all wikis
• mediawiki content current v1 : full content of the latest revisions of all pages on all wikis
• wikidata_entity : Wikidata's latest content in structured form
• wikidata_item_page_link : links between Wikidata items and corresponding Wikipedia pages in various languages

You can access MediaWiki replica databases through Wikimedia Cloud Services .

Public content data

APIs:

• Revisions
• Parse
• Wikidata:REST_API

Code running on Data Platform servers such as the stat hosts should use the internal API URLs in place of the public URLs.

Dumps :

• Wikitext (use mwparserfromhell )
• HTML (use mwparserfromhtml )
• Structured data (image depicts)

Specialized datasets:

• Content Gaps

MediaWiki database tables :

• Text

Contributing and edits data

Data about wiki revisions, pages, and users. Includes data about editors and their characteristics.

Private edits data

Edits datasets are generated as monthly snapshots, not continuously updated. This data includes:

• MediaWiki_history : Fully denormalized dataset with user, page and revision data
• Raw, unprocessed copies of MediaWiki database tables , bundled to facilitate cross-wiki queries.

Full dataset list at Data Lake/Edits .

Private contributors data

Private datasets about contributors or editors includes:

• Geoeditors : Counts of editors by project by country

View datasets tagged with "editors" in DataHub (requires a developer account) )

Public edits data

APIs:

• Revisions
• Allrevisions
• MediaWiki Event Streams

Code running on Data Platform servers such as the stat hosts should use the internal API URLs in place of the public URLs.

Dumps :

• Mediawiki_history

MediaWiki database tables :

• Revision table

Dashboards:

• Wikistats
• XTools

Public contributors data

APIs:

• Geoeditors
• users
• usercontribs
• globaluserinfo

Dumps :

• Mediawiki_history
• Geoeditors

Specialized datasets:

• Differentially private geoeditors (hourly/monthly)

MediaWiki database tables :

• actor
• user
• user_groups
• user_properties

Dashboards:

• Wikistats
• XTools
• Bitergia: technical community metrics

Instrumentation and events data

View and query events data

Through the Event Platform and Metrics Platform , you can create and deploy your own instruments to collect event data.

Events are ingested into event and event_sanitized databases in the Data Lake .

• The Hive table name is a normalized version of the stream name.
• The event database stores original (unsanitized) events within a 90 day retention period.
• The event_sanitized database is an archive of sanitized events, beyond the 90 day retention period.
  • Sanitized event data is processed per WMF’s Privacy Policy and Data Retention Guidelines .

After the data becomes available, you can access it with standard query tools and create dashboards based on the data . See the Instrumentation tutorial for how to consume events directly from Kafka or through the internal EventStreams instance.

How to query private data

Visit Analyze data to learn how to run queries and generate visualizations using WMF private datasets and analysis tools.

Report data issues

Data Issue reports