# Research:Daily non-redirect main namespace pages created

Daily non-redirect main namespace pages created
Specification
${\displaystyle {\text{daily non-redirect main namespace pages created}}(D)}$ is a count of the number of non-redirecting page creations in namespace ${\displaystyle 0}$ on date ${\displaystyle 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
page_is_redirect = 0 AND
rev_timestamp BETWEEN @date AND
DATE_FORMAT(DATE_ADD(@date, INTERVAL 1 DAY), "%Y%m%d%H%i%S")

Non-redirect pages created per day in the main namespace (ns=0) on English Wikipedia from 2017-07-21 to 2018-01-02. Note that ACTRIAL was initiated on 14 September 2017.

Daily non-redirect main namespace pages created is a standardized metric used to measure the number of non-redirect pages (page_is_redirect == 0) 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.