Research:Daily main namespace pages created

Daily main namespace pages created

Specification

${\text{daily main namespace pages created}}(D)$ is a count of the number of page creations in namespace

0

on date

D

.

WMF Standard

no parameters

Measures

Status

completed

SQL

SET @date = "20170801";
SET @wiki = "enwiki";

SELECT
    COUNT(*) AS page_creations_main
FROM
    mediawiki_page_create_2
WHERE
    `database` = @wiki AND
    page_namespace = 0 AND
    rev_timestamp BETWEEN @date AND
        DATE_FORMAT(DATE_ADD(@date, INTERVAL 1 DAY), "%Y%m%d%H%i%S")

Daily main namespace pages created is a standardized metric used to measure the number of pages that are created in the main namespace (page_namespace == 0) on a given day.

Discussion

Time lag

As this is a daily metric, a full 24 hours must elapse after the beginning of the date (UTC) in order to calculate an uncensored value.

Analysis

Discussion

Notes