Research talk:Wikipedia article creation/Work log/Wednesday, December 11th

Wednesday, December 11th

Picking up where I left off yesterday. First up. Where do articles start?

> select original_namespace, count(*) FROM nov13_page_origin WHERE page_namespace = 0 GROUP BY 1;
+--------------------+----------+
| original_namespace | count(*) |
+--------------------+----------+
|                  0 | 13450605 |
|                  1 |     2074 |
|                  2 |    35746 |
|                  3 |      515 |
|                  7 |        2 |
|                  8 |        1 |
|                  9 |       48 |
|                 10 |      338 |
|                 12 |        3 |
|                 15 |        4 |
|                100 |       30 |
|                108 |        2 |
+--------------------+----------+
12 rows in set (18.44 sec)

Missing Wikipedia and Wikipedia_talk (4 & 5). *sigh* I know what happened. The canonical name for "Wikipedia" namespace is "Project", but no one refers to it as that. Time to re-process these moves. --Halfak (WMF) (talk) 17:52, 11 December 2013 (UTC)

---

> select original_namespace, count(*) FROM nov13_page_origin WHERE page_namespace = 0 OR page_namespace = 5 and page_title LIKE "Articles_for_creation/%" GROUP BY 1;
+--------------------+----------+
| original_namespace | count(*) |
+--------------------+----------+
|                  0 | 13443625 |
|                  1 |     2089 |
|                  2 |    40571 |
|                  3 |      533 |
|                  4 |      733 |
|                  5 |   186029 |
|                  7 |        3 |
|                  8 |        1 |
|                  9 |       48 |
|                 10 |      342 |
|                 12 |        3 |
|                 15 |        4 |
|                100 |       30 |
|                108 |        2 |
+--------------------+----------+
14 rows in set (24.58 sec)

There we go! It looks like we have a lot of pages that started in User (ns=2). Quite a few started in Wikipedia_talk (ns=5). I'm guessing that most are AfC articles (and still currently drafts). But the vast majority of pages started directly in Main (ns=0). --Halfak (WMF) (talk) 21:28, 11 December 2013 (UTC)