Page MenuHomePhabricator

Request: Top articles of 2018 on all Wikipedias
Open, Needs TriagePublic

Description

We would like to get multiple lists of the 100 most-viewed articles in various Wikipedias, for the inevitable press requests/interest in "top 50" etc. (cf. current thread on the private comcom mailing list)

I believe this has previously been done one wiki at a time, per T183903#3874401 (Zhwiki results) and similar. [because the API doesn't have a 'yearly' endpoint yet, per T154381]

A Hive query has been made that yields this list for all wikis (P7945, see discussion at T183903#4818567 ff.)

We need someone to run that query, and provide us with the results. Please and thank you!

NOTE: Details are still being discussed. In particular, we're not sure whether to wait for January 1 (to be precise/complete) or get the list now (when there's the most external interest in these types of lists). -- Maybe doing both is feasible?

Event Timeline

Restricted Application added a project: Product-Analytics. · View Herald TranscriptDec 12 2018, 10:02 PM
Restricted Application added subscribers: Cosine02, Aklapper. · View Herald Transcript

I replied at T183903#4822644 but moving discussion here.

I ran this query, similar to the suggested one:

SELECT CONCAT('https://', project, '.org/wiki/', page_title), SUM(view_count) AS views
FROM wmf.pageview_hourly
WHERE
   year = 2018
   AND agent_type = 'user'
GROUP BY project, page_title
ORDER BY views DESC LIMIT 100;

As suspected it gives us the top 100 most-viewed pages overall, across all projects. The results are still mostly uninteresting since we can't filter by namespace:

https://en.wikipedia.org/wiki/Main_Page    5379645168
https://en.wikipedia.org/wiki/-    876590140
https://en.wikipedia.org/wiki/Special:Search    672831776
https://de.wikipedia.org/wiki/Wikipedia:Hauptseite    461976764
https://it.wikipedia.org/wiki/Pagina_principale    204035882
https://wikidata.org/wiki/Special:ItemDisambiguation    200246468
https://fr.wikipedia.org/wiki/Wikipédia:Accueil_principal    199383354
https://ru.wikipedia.org/wiki/Заглавная_страница    189512927
https://es.wikipedia.org/wiki/Wikipedia:Portada    160300275
https://ja.wikipedia.org/wiki/メインページ    139959749
https://de.wikipedia.org/wiki/Spezial:Suche    110455803
https://es.wikipedia.org/wiki/Especial:Buscar    110299248
https://commons.wikimedia.org/wiki/Special:CreateAccount    103094538
https://fr.wikipedia.org/wiki/Sp?cial:Search    101980574
https://wikidata.org/wiki/Special:BlankPage    89845612
https://en.wikipedia.org/wiki/XHamster    73413875
https://zh.wikipedia.org/wiki/Wikipedia:首页    67342762
https://fr.wikipedia.org/wiki/Spécial:Recherche    58486478
https://es.wikipedia.org/wiki/-    54684470
https://en.wikipedia.org/wiki/Special:CreateAccount    50994694
https://es.wikipedia.org/wiki/Wikipedia:Comunicado_4_julio_2018    49239780
https://nl.wikipedia.org/wiki/Hoofdpagina    46661984
https://commons.wikimedia.org/wiki/Special:Search    46074040
https://ru.wikipedia.org/wiki/Служебная:Поиск    44255332
https://wikidata.org/wiki/-    41799646
https://pl.wikipedia.org/wiki/Wikipedia:Strona_główna    38886611
https://pt.wikipedia.org/wiki/Wikipédia:Página_principal    38098446
https://ar.wikipedia.org/wiki/خاص:بحث    37698677
https://pt.wikipedia.org/wiki/Especial:Pesquisar    36695478
https://en.wikipedia.org/wiki/Deaths_in_2018    36638252
https://it.wikipedia.org/wiki/Wikipedia:Comunicato_3_luglio_2018    35997248
https://ja.wikipedia.org/wiki/特別:検索    35344004
https://en.wikipedia.org/wiki/2018_FIFA_World_Cup    33443484
https://commons.wikimedia.org/wiki/Main_Page    32742629
https://en.wikipedia.org/wiki/Avengers:_Infinity_War    32159499
https://en.wikipedia.org/wiki/Darth_Vader    30968707
https://en.wikipedia.org/wiki/Louis_Tomlinson    30771483
https://de.wikipedia.org/wiki/Special:MyPage/toolserverhelferleinconfig.js    30489158
https://zh.wikipedia.org/wiki/Special:搜索    28566962
https://ja.wikipedia.org/wiki/苦行    28071940
https://ru.wikipedia.org/wiki/Borderlands:_The_Pre-Sequel!    27445616
https://en.wikipedia.org/wiki/Exo_(band)    27017620
https://en.wikipedia.org/wiki/Special:Watchlist    26907252
https://ar.wikipedia.org/wiki/الصفحة_الرئيسية    26882040
https://fr.wikipedia.org/wiki/-    24786718
https://en.wikipedia.org/wiki/Special:ElectronPdf    24276756
https://de.wikipedia.org/wiki/-    23332340
https://kk.wikipedia.org/wiki/Template:AdvancedSiteNotices/ajax    22927585
https://cs.wikipedia.org/wiki/Hlavní_strana    22906759
https://ru.wikipedia.org/wiki/-    22162828
https://it.wikipedia.org/wiki/Speciale:Ricerca    21827111
https://ar.wikipedia.org/wiki/-    21586069
https://en.wikipedia.org/wiki/Black_Panther_(film)    20966096
https://en.wikipedia.org/wiki/Freddie_Mercury    20592463
https://sv.wikipedia.org/wiki/Portal:Huvudsida    20452779
https://en.wikipedia.org/wiki/Special:RecentChangesLinked    20105863
https://en.wikipedia.org/wiki/Elizabeth_II    19237429
https://it.wikipedia.org/wiki/TG_Norba_24    18935078
https://en.wikipedia.org/wiki/List_of_United_States_stand-up_comedians    18462069
https://en.wikipedia.org/wiki/List_of_stand-up_comedians    18453179
https://en.wikipedia.org/wiki/List_of_Australian_stand-up_comedians    18391830
https://en.wikipedia.org/wiki/List_of_Canadian_stand-up_comedians    18383631
https://en.wikipedia.org/wiki/List_of_British_stand-up_comedians    18379310
https://en.wikipedia.org/wiki/Stephen_Hawking    18236502
https://zh.wikipedia.org/wiki/-    18100093
https://en.wikipedia.org/wiki/Meghan_Markle    18029873
https://ja.wikipedia.org/wiki/-    17640804
https://en.wikipedia.org/wiki/List_of_Marvel_Cinematic_Universe_films    17580795
https://en.wikipedia.org/wiki/Cristiano_Ronaldo    17488886 (edited) 
https://fi.wikipedia.org/wiki/Wikipedia:Etusivu    17160316
https://en.wikipedia.org/wiki/Cardi_B    17010723
https://en.wikipedia.org/wiki/Elon_Musk    16899563
https://en.wikipedia.org/wiki/Donald_Trump    16729532
https://en.wiktionary.org/wiki/Wiktionary:Main_Page    15981543
https://en.wikipedia.org/wiki/BTS_(band)    15323915
https://en.wikipedia.org/wiki/Portal:Current_events    15239781
https://pt.wikipedia.org/wiki/-    15125720
https://de.wikipedia.org/wiki/Special:Search    14998199
https://pl.wikipedia.org/wiki/Specjalna:Szukaj    14981937
https://en.wikipedia.org/wiki/XXXTentacion    14735395
https://en.wikipedia.org/wiki/United_States    14261908
https://en.wikipedia.org/wiki/List_of_Bollywood_films_of_2018    14000321
https://nl.wikipedia.org/wiki/Speciaal:Zoeken    13707855
https://en.wikipedia.org/wiki/Special:CiteThisPage    13465627
https://en.wiktionary.org/wiki/Special:Search    13387173
https://ko.wikipedia.org/wiki/위키백과:대문    13175873
https://en.wikipedia.org/wiki/Special:MobileMenu    13172982
https://en.wikipedia.org/wiki/Tunnel    12791300
https://id.wikipedia.org/wiki/Istimewa:Pencarian    12696208
https://en.wikipedia.org/wiki/List_of_highest-grossing_films    12289384
https://en.wikipedia.org/wiki/XXX_(franchise)    12198573
https://commons.wikimedia.org/wiki/Special:RecentChangesLinked    12005056
https://cs.wikipedia.org/wiki/Speciální:Hledání    12003088
https://en.wikipedia.org/wiki/LeBron_James    11975345
https://en.wikipedia.org/wiki/File:ITVBe_logo_2014-.svg    11909554
https://it.wikipedia.org/wiki/-    11625413
https://en.wikipedia.org/wiki/George_H._W._Bush    11603005
https://de.wikipedia.org/wiki/Spezial:Beobachtungsliste    11591257
https://en.wikipedia.org/wiki/Anthony_Bourdain    11579001
https://en.wikipedia.org/wiki/6ix9ine    11575908

This took about 45 minutes to complete.


I'm not the best at SQL, but borrowing from XTools Top Edits -- which shows the top 100 most-edited pages by a user for each individual namespace -- I think we might need a more complicated query like:

SELECT c.project, c.page, c.views 
FROM
(
  SELECT b.project, b.page, b.views,
    @rn := IF(@project = b.project, @rn + 1, 1) AS row_number,
    @project := b.project AS dummy
  FROM (
    SELECT project,
      CONCAT('https://', project, '.org/wiki/', page_title) AS page,
      SUM(view_count) AS views
    FROM wmf.pageview_hourly
      WHERE year = 2018
        AND agent_type = 'user'
      GROUP BY project, page_title
    ) AS b
    JOIN (SELECT @project := NULL, @rn := 0) AS vars
    ORDER BY b.project ASC, b.views DESC
  ) AS c
WHERE c.row_number <= 100

However here Hive doesn't seem to like the variable notation @rn := ..., etc.

Additionally, while it will slow down the query even more, we might add some logic like page_title NOT LIKE "%:%" to try to filter out non-mainspace, though of course there could be page titles with colons in them that are in the mainspace.

It might be easier and/or more feasible to just query for each project individually, perhaps the top 10 Wikipedias? Then whatever else, as requested.

I replied at T183903#4822644 but moving discussion here.
I ran this query, similar to the suggested one:

...

As suspected it gives us the top 100 most-viewed pages overall, across all projects. The results are still mostly uninteresting since we can't filter by namespace:

Actually, a namespace_id field was added to the pageview_hourly during 2017 (T156993), so now is the first time we can try to use it for this purpose. While it is not yet 100% accurate in the sense that there remains a small amount of pageviews that still don't have value set for this field (mainly from the mobile apps IIRC), it should work for the present purpose of excluding most non-mainspace pages from the top 100 or so pages.

MusikAnimal added a comment.EditedDec 14 2018, 2:42 AM

Actually, a namespace_id field was added to the pageview_hourly during 2017 (T156993), so now is the first time we can try to use it for this purpose. While it is not yet 100% accurate in the sense that there remains a small amount of pageviews that still don't have value set for this field (mainly from the mobile apps IIRC), it should work for the present purpose of excluding most non-mainspace pages from the top 100 or so pages.

That's fantastic! I ran your query from last year, adding in a namespace check, and this is what I got for enwiki:

https://en.wikipedia.org/wiki/Main_Page5354947262
https://en.wikipedia.org/wiki/-511021245
https://en.wikipedia.org/wiki/XHamster73414563
https://en.wikipedia.org/wiki/Deaths_in_201835012847
https://en.wikipedia.org/wiki/2018_FIFA_World_Cup32986294
https://en.wikipedia.org/wiki/Avengers:_Infinity_War31284260
https://en.wikipedia.org/wiki/Darth_Vader30951415
https://en.wikipedia.org/wiki/Louis_Tomlinson30758987
https://en.wikipedia.org/wiki/Exo_(band)27016214
https://en.wikipedia.org/wiki/Black_Panther_(film)20412487
https://en.wikipedia.org/wiki/Freddie_Mercury20306790
https://en.wikipedia.org/wiki/Elizabeth_II18958811
https://en.wikipedia.org/wiki/List_of_United_States_stand-up_comedians18460956
https://en.wikipedia.org/wiki/List_of_stand-up_comedians18452437
https://en.wikipedia.org/wiki/List_of_Australian_stand-up_comedians18391783
https://en.wikipedia.org/wiki/List_of_Canadian_stand-up_comedians18383536
https://en.wikipedia.org/wiki/List_of_British_stand-up_comedians18379405
https://en.wikipedia.org/wiki/Stephen_Hawking17989606
https://en.wikipedia.org/wiki/Meghan_Markle17911508
https://en.wikipedia.org/wiki/List_of_Marvel_Cinematic_Universe_films17327275
https://en.wikipedia.org/wiki/Cristiano_Ronaldo17307402
https://en.wikipedia.org/wiki/Cardi_B16875172
https://en.wikipedia.org/wiki/Elon_Musk16681038
https://en.wikipedia.org/wiki/Donald_Trump16536585
https://en.wikipedia.org/wiki/BTS_(band)15262920
https://en.wikipedia.org/wiki/XXXTentacion14606220
https://en.wikipedia.org/wiki/United_States14131981
https://en.wikipedia.org/wiki/List_of_Bollywood_films_of_201813925808
https://en.wikipedia.org/wiki/Tunnel12788613
https://en.wikipedia.org/wiki/XXX_(franchise)12192150
https://en.wikipedia.org/wiki/List_of_highest-grossing_films12117923
https://en.wikipedia.org/wiki/LeBron_James11861970
https://en.wikipedia.org/wiki/6ix9ine11455366
https://en.wikipedia.org/wiki/Anthony_Bourdain11446720
https://en.wikipedia.org/wiki/George_H._W._Bush11441660
https://en.wikipedia.org/wiki/Lionel_Messi11290791
https://en.wikipedia.org/wiki/A_Quiet_Place_(film)11249294
https://en.wikipedia.org/wiki/Deadpool_211122649
https://en.wikipedia.org/wiki/Ariana_Grande10954318
https://en.wikipedia.org/wiki/Avicii10880178
https://en.wikipedia.org/wiki/2018_in_film10871786
https://en.wikipedia.org/wiki/Priyanka_Chopra10779215
https://en.wikipedia.org/wiki/Facebook10758908
https://en.wikipedia.org/wiki/Stan_Lee10733955
https://en.wikipedia.org/wiki/John_McCain10654023
https://en.wikipedia.org/wiki/India10627333
https://en.wikipedia.org/wiki/Queen_Victoria10622959
https://en.wikipedia.org/wiki/Millennials10395027
https://en.wikipedia.org/wiki/Venom_(2018_film)10393206
https://en.wikipedia.org/wiki/Meghan,_Duchess_of_Sussex10352741
https://en.wikipedia.org/wiki/Tonya_Harding10303700
https://en.wikipedia.org/wiki/Charles,_Prince_of_Wales10285901
https://en.wikipedia.org/wiki/Dwayne_Johnson10185022
https://en.wikipedia.org/wiki/Princess_Margaret,_Countess_of_Snowdon10027883
https://en.wikipedia.org/wiki/YouTube9992203
https://en.wikipedia.org/wiki/Donald_Glover9990406
https://en.wikipedia.org/wiki/HTTP_cookie9822501
https://en.wikipedia.org/wiki/FIFA_World_Cup9743690
https://en.wikipedia.org/wiki/Prince_Philip,_Duke_of_Edinburgh9741349
https://en.wikipedia.org/wiki/The_Greatest_Showman9610619
https://en.wikipedia.org/wiki/Sridevi9606951
https://en.wikipedia.org/wiki/Nick_Jonas9566048
https://en.wikipedia.org/wiki/Marvel_Cinematic_Universe9556053
https://en.wikipedia.org/wiki/Winston_Churchill9398131
https://en.wikipedia.org/wiki/HTTP_4049000774
https://en.wikipedia.org/wiki/Sylvester_Stallone8956951
https://en.wikipedia.org/wiki/A_Star_Is_Born_(2018_film)8930807
https://en.wikipedia.org/wiki/Post_Malone8867471
https://en.wikipedia.org/wiki/XVideos8782601
https://en.wikipedia.org/wiki/World_War_II8740060
https://en.wikipedia.org/wiki/Fortnite8668440
https://en.wikipedia.org/wiki/Jason_Momoa8593362
https://en.wikipedia.org/wiki/Mac_Miller8578588
https://en.wikipedia.org/wiki/The_Handmaid's_Tale_(TV_series)8576224
https://en.wikipedia.org/wiki/George_VI8524417
https://en.wikipedia.org/wiki/Brett_Kavanaugh8467194
https://en.wikipedia.org/wiki/Cook's_Country8430513
https://en.wikipedia.org/wiki/Aretha_Franklin8420600
https://en.wikipedia.org/wiki/Michael_Jackson8414712
https://en.wikipedia.org/wiki/Adolf_Hitler8409426
https://en.wikipedia.org/wiki/United_Kingdom8395122
https://en.wikipedia.org/wiki/Eminem8359804
https://en.wikipedia.org/wiki/P._T._Barnum8357653
https://en.wikipedia.org/wiki/World_War_I8327202
https://en.wikipedia.org/wiki/Barack_Obama8316144
https://en.wikipedia.org/wiki/Solo:_A_Star_Wars_Story8246372
https://en.wikipedia.org/wiki/Riverdale_(2017_TV_series)8178344
https://en.wikipedia.org/wiki/Tom_Cruise8151941
https://en.wikipedia.org/wiki/Pablo_Escobar8050512
https://en.wikipedia.org/wiki/Google7978331
https://en.wikipedia.org/wiki/Jeff_Bezos7819528
https://en.wikipedia.org/wiki/Dua_Lipa7717912
https://en.wikipedia.org/wiki/Jennifer_Aniston7709341
https://en.wikipedia.org/wiki/Untitled_Avengers_film7662721
https://en.wikipedia.org/wiki/Ant-Man_and_the_Wasp7621579
https://en.wikipedia.org/wiki/Diana,_Princess_of_Wales7609622
https://en.wikipedia.org/wiki/Kylie_Jenner7604402
https://en.wikipedia.org/wiki/List_of_highest-grossing_Indian_films7578900
https://en.wikipedia.org/wiki/13_Reasons_Why7578148
https://en.wikipedia.org/wiki/XXXX7558206

As you know, some of these such as XHamster are widely viewed as false positives, at least in terms of authentic public interest.

The query strangely took around the same amount of time as the one that scanned all projects.

Nuria added a subscriber: Nuria.Dec 14 2018, 6:13 PM

Some ideas (for @Quiddity mostly)

  • Given the disparity of views among enwiki and other wikis a top 100 over the year will likely (as you might have seen) only give you results for enwiki.
  • This data is still affected by bots and non-intentional traffic, the best example of which might be XHamster page.

Commented with a better query fixing my naive first attempt here: T183903#4824489

@Nuria Yes, sorry that my description was ambiguous! We want separate lists for each Wikipedia. I.e. various Chapters want language-specific lists, to share/answer with their own press contacts.

It might be easier and/or more feasible to just query for each project individually, perhaps the top 10 Wikipedias? Then whatever else, as requested.

Yes, Top 10, or maybe Top ~40 (? would that cover most of the 37 Chapters?) would be good to start with.

p.s. Enwiki is basically already covered, by Andrew West who does it every year, and started the version for 2018 a few days ago. https://en.wikipedia.org/wiki/User:West.andrew.g/2018_Popular_pages

I'm happy to help run the query on some of the top projects if we can't find a better way. @Quiddity Do you plan on publishing this anywhere public, such as the wiki? Meta or the like? I'd love to link to the results from https://tools.wmflabs.org/topviews

I do think we should wait till January 1 (perhaps the 2nd) before going all out. If a major event happens between now and then, the corresponding articles could skyrocket their way to the top.

@Quiddity Do you plan on [...]

I was originally planning on spending 2 minutes writing a reply to an email, just pointing everyone towards Topviews as a solution for all their needs! But then I found it doesn't include yearly yet, so I fell down the rabbithole of investigating the things that lead towards T154381. (many links... much reading... hours later...). I ended up writing this task to save anyone else the bother of going through all that again! I'll CC @EdErhart-WMF who might be able/willing to do more of the actual decision-making and organising what people need and where they want it placed. /me runs away.

geraki added a subscriber: geraki.Dec 17 2018, 1:45 PM

Hello everyone! We've been talking on the Communications Committee's mailing list about this. @MusikAnimal, would it be possible to get a list of the most-viewed articles in the following languages shortly after the New Year?

German, Hebrew, Polish, Swedish, and Chinese.

Thank you!

Hello everyone! We've been talking on the Communications Committee's mailing list about this. @MusikAnimal, would it be possible to get a list of the most-viewed articles in the following languages shortly after the New Year?
German, Hebrew, Polish, Swedish, and Chinese.
Thank you!

Yes, I'm happy to help :) Five wikis is not that much.

I spoke with @Nuria about this briefly over IRC -- I have a list of false positives from crowd-sourced data provided by users of https://tools.wmflabs.org/topviews, organized by project, platform and date. I have listed this data below should it interest anyone, though much of it does not affect the request projects. For most of these I confirmed as false positives by querying Hive and seeing if 90+% of traffic came from a single city, where that city isn't particularly large. Some FPs were ascertained solely because of a crazy unlikely % mobile/desktop ratio. That said, there's no guarantee this is accurate, but I'm fairly confident these are FPs. null means all possible values for that column:

1MariaDB [s52657__metadata]> SELECT * FROM topviews_blacklist;
2+----+---------------------+-----------------------------------------------------------------+------------+
3| id | project | page | platform |
4+----+---------------------+-----------------------------------------------------------------+------------+
5| 2 | en.wikipedia | 404.php | all-access |
6| 4 | en.wikipedia | Web scraping | all-access |
7| 5 | en.wikipedia | 404.php | desktop |
8| 6 | en.wikipedia | Web scraping | desktop |
9| 7 | be-tarask.wikipedia | PST | all-access |
10| 8 | be-tarask.wikipedia | PST | desktop |
11| 10 | en.wikipedia | AMGTV | all-access |
12| 11 | en.wikipedia | AMGTV | desktop |
13| 12 | en.wikipedia | Proyecto 40 | desktop |
14| 13 | en.wikipedia | Proyecto 40 | all-access |
15| 24 | id.wikipedia | Template:AdvancedSiteNotices/ajax | all-access |
16| 30 | NULL | xss | NULL |
17| 36 | uk.wikipedia | ������ ����� ��������� | desktop |
18| 37 | uk.wikipedia | ������ ����� ��������� | all-access |
19| 38 | en.wikipedia | Dulce María | NULL |
20| 40 | en.wikipedia | Java (programming language) | desktop |
21| 41 | en.wikipedia | Java (programming language) | all-access |
22| 42 | en.wikipedia | XHamster | NULL |
23| 43 | pt.wikipedia | Lali Espósito | desktop |
24| 44 | pt.wikipedia | Lali Espósito | all-access |
25| 45 | pl.wikipedia | Biblia | all-access |
26| 46 | pl.wikipedia | Biblia | desktop |
27| 47 | eu.wikipedia | Taterillus gracilis | all-access |
28| 48 | eu.wikipedia | Gaston Julia | all-access |
29| 49 | sw.wikipedia | Template:GeoTemplate | all-access |
30| 50 | sw.wikipedia | Template:GeoTemplate | desktop |
31| 51 | fr.wikipedia | Defense Advanced Research Projects Agency | all-access |
32| 52 | fr.wikipedia | Defense Advanced Research Projects Agency | desktop |
33| 54 | fr.wikipedia | Théorie du complot | desktop |
34| 55 | fr.wikipedia | Théorie du complot | all-access |
35| 56 | en.wikipedia | List of United States stand-up comedians | desktop |
36| 57 | en.wikipedia | List of Australian stand-up comedians | desktop |
37| 58 | en.wikipedia | List of British stand-up comedians | desktop |
38| 59 | en.wikipedia | List of Canadian stand-up comedians | desktop |
39| 60 | en.wikipedia | List of stand-up comedians | desktop |
40| 61 | en.wikipedia | XXX (franchise) | desktop |
41| 62 | en.wikipedia | XXX (franchise) | all-access |
42| 64 | ga.wikipedia | Maximilian Kolbe | all-access |
43| 65 | ga.wikipedia | Maximilian Kolbe | desktop |
44| 66 | en.wikipedia | OpenText | all-access |
45| 67 | en.wikipedia | OpenText | desktop |
46| 68 | en.wikipedia | Local-density approximation | all-access |
47| 69 | en.wikipedia | Local-density approximation | desktop |
48| 70 | en.wikipedia | List of macOS components | desktop |
49| 71 | en.wikipedia | List of macOS components | all-access |
50| 72 | en.wikipedia | Otilonium bromide | all-access |
51| 73 | en.wikipedia | Otilonium bromide | desktop |
52| 74 | zh.wikipedia | éƒ­å»ºå® (製作人) | all-access |
53| 75 | zh.wikipedia | éƒ­å»ºå® (製作人) | desktop |
54| 78 | de.wikipedia | St�ckgut | all-access |
55| 79 | de.wikipedia | Sch�ttgut | all-access |
56| 80 | de.wikipedia | F�rdertechnik | all-access |
57| 81 | de.wikipedia | F�rdertechnik | desktop |
58| 82 | de.wikipedia | Sch�ttgut | desktop |
59| 83 | de.wikipedia | St�ckgut | desktop |
60| 84 | de.wikipedia | F�rderband | desktop |
61| 85 | de.wikipedia | F�rderband | all-access |
62| 87 | de.wikipedia | XHamster | NULL |
63| 88 | de.wikipedia | Pornhub | NULL |
64| 89 | ru.wikipedia | Borderlands: The Pre-Sequel! | NULL |
65| 90 | ru.wikipedia | ��������� ��� | NULL |
66| 91 | ru.wikipedia | QR-код | NULL |
67| 92 | ru.wiktionary | удивлённый | NULL |
68| 93 | ru.wiktionary | мама | NULL |
69| 94 | es.wikipedia | Lali Espósito | NULL |
70+----+---------------------+-----------------------------------------------------------------+------------+

1MariaDB [s52657__metadata]> SELECT project, page, platform, date FROM topviews_false_positives WHERE date >= '2018-01-01' AND confirmed = 1;
2+---------------+----------------------------------------------------+------------+------------+
3| project | page | platform | date |
4+---------------+----------------------------------------------------+------------+------------+
5| en.wikipedia | undefined | all-access | 2018-01-02 |
6| en.wikipedia | List of United States stand-up comedians | all-access | 2018-01-05 |
7| en.wikipedia | List of stand-up comedians | all-access | 2018-01-05 |
8| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-01-05 |
9| en.wikipedia | List of British stand-up comedians | all-access | 2018-01-05 |
10| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-01-05 |
11| en.wikipedia | List of stand-up comedians | all-access | 2018-01-06 |
12| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-01-06 |
13| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-01-06 |
14| en.wikipedia | List of British stand-up comedians | all-access | 2018-01-06 |
15| en.wikipedia | List of United States stand-up comedians | all-access | 2018-01-06 |
16| en.wikipedia | List of United States stand-up comedians | all-access | 2018-01-07 |
17| en.wikipedia | List of stand-up comedians | all-access | 2018-01-07 |
18| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-01-07 |
19| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-01-07 |
20| en.wikipedia | List of British stand-up comedians | all-access | 2018-01-07 |
21| en.wikipedia | List of United States stand-up comedians | all-access | 2018-01-08 |
22| en.wikipedia | List of stand-up comedians | all-access | 2018-01-08 |
23| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-01-08 |
24| en.wikipedia | List of British stand-up comedians | all-access | 2018-01-08 |
25| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-01-08 |
26| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-01-09 |
27| en.wikipedia | List of British stand-up comedians | all-access | 2018-01-09 |
28| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-01-09 |
29| en.wikipedia | List of stand-up comedians | all-access | 2018-01-09 |
30| en.wikipedia | List of United States stand-up comedians | all-access | 2018-01-09 |
31| en.wikipedia | List of United States stand-up comedians | all-access | 2018-01-10 |
32| en.wikipedia | List of stand-up comedians | all-access | 2018-01-10 |
33| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-01-10 |
34| en.wikipedia | List of British stand-up comedians | all-access | 2018-01-10 |
35| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-01-10 |
36| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-01-12 |
37| en.wikipedia | List of British stand-up comedians | all-access | 2018-01-12 |
38| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-01-12 |
39| en.wikipedia | List of stand-up comedians | all-access | 2018-01-12 |
40| en.wikipedia | List of United States stand-up comedians | all-access | 2018-01-12 |
41| en.wikipedia | Cookie (disambiguation) | all-access | 2018-01-12 |
42| en.wikipedia | Magic cookie | all-access | 2018-01-12 |
43| en.wikipedia | JSON Web Token | all-access | 2018-01-12 |
44| en.wikipedia | JSON Web Token | all-access | 2018-01-13 |
45| en.wikipedia | Magic cookie | all-access | 2018-01-13 |
46| en.wikipedia | Cookie (disambiguation) | all-access | 2018-01-13 |
47| en.wikipedia | Access token | all-access | 2018-01-13 |
48| en.wikipedia | Session token | all-access | 2018-01-13 |
49| en.wikipedia | List of stand-up comedians | all-access | 2018-01-13 |
50| en.wikipedia | List of United States stand-up comedians | all-access | 2018-01-13 |
51| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-01-13 |
52| en.wikipedia | List of British stand-up comedians | all-access | 2018-01-13 |
53| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-01-13 |
54| en.wikipedia | Secure cookies | all-access | 2018-01-13 |
55| en.wikipedia | Evercookie | all-access | 2018-01-13 |
56| en.wikipedia | Zombie cookie | all-access | 2018-01-13 |
57| en.wikipedia | Web analytics | all-access | 2018-01-13 |
58| en.wikipedia | JSON Web Token | all-access | 2018-01-14 |
59| en.wikipedia | List of United States stand-up comedians | all-access | 2018-01-14 |
60| en.wikipedia | List of stand-up comedians | all-access | 2018-01-14 |
61| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-01-14 |
62| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-01-14 |
63| en.wikipedia | List of British stand-up comedians | all-access | 2018-01-14 |
64| en.wikipedia | Cookie (disambiguation) | all-access | 2018-01-14 |
65| en.wikipedia | Magic cookie | all-access | 2018-01-14 |
66| en.wikipedia | Evercookie | all-access | 2018-01-14 |
67| en.wikipedia | Zombie cookie | all-access | 2018-01-14 |
68| en.wikipedia | Web analytics | all-access | 2018-01-14 |
69| en.wikipedia | Session token | all-access | 2018-01-14 |
70| en.wikipedia | JSON Web Token | all-access | 2018-01-15 |
71| en.wikipedia | Access token | all-access | 2018-01-15 |
72| en.wikipedia | Session token | all-access | 2018-01-15 |
73| en.wikipedia | Cookie (disambiguation) | all-access | 2018-01-15 |
74| en.wikipedia | Magic cookie | all-access | 2018-01-15 |
75| en.wikipedia | Evercookie | all-access | 2018-01-15 |
76| en.wikipedia | Web analytics | all-access | 2018-01-15 |
77| en.wikipedia | Zombie cookie | all-access | 2018-01-15 |
78| en.wikipedia | List of United States stand-up comedians | all-access | 2018-01-15 |
79| en.wikipedia | List of stand-up comedians | all-access | 2018-01-15 |
80| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-01-15 |
81| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-01-15 |
82| en.wikipedia | List of British stand-up comedians | all-access | 2018-01-15 |
83| en.wikipedia | Secure cookies | all-access | 2018-01-15 |
84| en.wikipedia | Access token | all-access | 2018-01-16 |
85| en.wikipedia | HTTP cookie | all-access | 2018-01-16 |
86| en.wikipedia | Session token | all-access | 2018-01-16 |
87| en.wikipedia | Magic cookie | all-access | 2018-01-16 |
88| en.wikipedia | Cookie (disambiguation) | all-access | 2018-01-16 |
89| en.wikipedia | List of United States stand-up comedians | all-access | 2018-01-16 |
90| en.wikipedia | List of stand-up comedians | all-access | 2018-01-16 |
91| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-01-16 |
92| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-01-16 |
93| en.wikipedia | List of British stand-up comedians | all-access | 2018-01-16 |
94| en.wikipedia | Evercookie | all-access | 2018-01-16 |
95| en.wikipedia | Zombie cookie | all-access | 2018-01-16 |
96| en.wikipedia | List of United States stand-up comedians | all-access | 2018-01-17 |
97| en.wikipedia | List of stand-up comedians | all-access | 2018-01-17 |
98| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-01-17 |
99| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-01-17 |
100| en.wikipedia | List of British stand-up comedians | all-access | 2018-01-17 |
101| en.wikipedia | undefined | all-access | 2018-01-17 |
102| en.wikipedia | JSON Web Token | all-access | 2018-01-18 |
103| en.wikipedia | HTTP cookie | all-access | 2018-01-18 |
104| en.wikipedia | Access token | all-access | 2018-01-18 |
105| en.wikipedia | Session token | all-access | 2018-01-18 |
106| en.wikipedia | Cookie (disambiguation) | all-access | 2018-01-18 |
107| en.wikipedia | Magic cookie | all-access | 2018-01-18 |
108| en.wikipedia | Evercookie | all-access | 2018-01-18 |
109| en.wikipedia | Web analytics | all-access | 2018-01-18 |
110| en.wikipedia | Zombie cookie | all-access | 2018-01-18 |
111| en.wikipedia | Secure cookies | all-access | 2018-01-18 |
112| en.wikipedia | List of United States stand-up comedians | all-access | 2018-01-18 |
113| en.wikipedia | List of stand-up comedians | all-access | 2018-01-18 |
114| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-01-18 |
115| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-01-18 |
116| en.wikipedia | List of British stand-up comedians | all-access | 2018-01-18 |
117| en.wikipedia | JSON Web Token | all-access | 2018-01-19 |
118| en.wikipedia | Access token | all-access | 2018-01-19 |
119| en.wikipedia | Session token | all-access | 2018-01-19 |
120| en.wikipedia | HTTP cookie | all-access | 2018-01-19 |
121| en.wikipedia | List of United States stand-up comedians | all-access | 2018-01-19 |
122| en.wikipedia | List of stand-up comedians | all-access | 2018-01-19 |
123| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-01-19 |
124| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-01-19 |
125| en.wikipedia | List of British stand-up comedians | all-access | 2018-01-19 |
126| en.wikipedia | Magic cookie | all-access | 2018-01-19 |
127| en.wikipedia | List of United States stand-up comedians | all-access | 2018-01-20 |
128| en.wikipedia | List of stand-up comedians | all-access | 2018-01-20 |
129| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-01-20 |
130| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-01-20 |
131| en.wikipedia | List of British stand-up comedians | all-access | 2018-01-20 |
132| en.wikipedia | List of United States stand-up comedians | all-access | 2018-01-21 |
133| en.wikipedia | List of stand-up comedians | all-access | 2018-01-21 |
134| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-01-21 |
135| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-01-21 |
136| en.wikipedia | List of British stand-up comedians | all-access | 2018-01-21 |
137| en.wikipedia | List of United States stand-up comedians | all-access | 2018-01-22 |
138| en.wikipedia | List of stand-up comedians | all-access | 2018-01-22 |
139| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-01-22 |
140| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-01-22 |
141| en.wikipedia | List of British stand-up comedians | all-access | 2018-01-22 |
142| en.wikipedia | HTTP cookie | all-access | 2018-01-23 |
143| en.wikipedia | JSON Web Token | all-access | 2018-01-23 |
144| en.wikipedia | Access token | all-access | 2018-01-23 |
145| en.wikipedia | Exo (band) | all-access | 2018-01-23 |
146| en.wikipedia | Session token | all-access | 2018-01-23 |
147| en.wikipedia | Cookie (disambiguation) | all-access | 2018-01-23 |
148| en.wikipedia | List of United States stand-up comedians | all-access | 2018-01-23 |
149| en.wikipedia | List of stand-up comedians | all-access | 2018-01-23 |
150| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-01-23 |
151| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-01-23 |
152| en.wikipedia | List of British stand-up comedians | all-access | 2018-01-23 |
153| en.wikipedia | Evercookie | all-access | 2018-01-23 |
154| en.wikipedia | Magic cookie | all-access | 2018-01-23 |
155| en.wikipedia | Web analytics | all-access | 2018-01-23 |
156| en.wikipedia | Zombie cookie | all-access | 2018-01-23 |
157| en.wikipedia | Secure cookies | all-access | 2018-01-23 |
158| en.wikipedia | HTTP cookie | all-access | 2018-01-24 |
159| en.wikipedia | Session token | all-access | 2018-01-24 |
160| en.wikipedia | JSON Web Token | all-access | 2018-01-24 |
161| en.wikipedia | Access token | all-access | 2018-01-24 |
162| en.wikipedia | Cookie (disambiguation) | all-access | 2018-01-24 |
163| en.wikipedia | Magic cookie | all-access | 2018-01-24 |
164| en.wikipedia | Evercookie | all-access | 2018-01-24 |
165| en.wikipedia | Exo (band) | all-access | 2018-01-24 |
166| en.wikipedia | Web analytics | all-access | 2018-01-24 |
167| en.wikipedia | Zombie cookie | all-access | 2018-01-24 |
168| en.wikipedia | List of United States stand-up comedians | all-access | 2018-01-24 |
169| en.wikipedia | List of stand-up comedians | all-access | 2018-01-24 |
170| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-01-24 |
171| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-01-24 |
172| en.wikipedia | List of British stand-up comedians | all-access | 2018-01-24 |
173| en.wikipedia | Secure cookies | all-access | 2018-01-24 |
174| en.wikipedia | List of United States stand-up comedians | all-access | 2018-01-25 |
175| en.wikipedia | List of stand-up comedians | all-access | 2018-01-25 |
176| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-01-25 |
177| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-01-25 |
178| en.wikipedia | List of British stand-up comedians | all-access | 2018-01-25 |
179| en.wikipedia | HRT 2 | all-access | 2018-01-25 |
180| en.wikipedia | Polymath Project | all-access | 2018-01-26 |
181| en.wikipedia | HRT 2 | all-access | 2018-01-26 |
182| en.wikipedia | List of United States stand-up comedians | all-access | 2018-01-26 |
183| en.wikipedia | List of stand-up comedians | all-access | 2018-01-26 |
184| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-01-26 |
185| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-01-26 |
186| en.wikipedia | List of British stand-up comedians | all-access | 2018-01-26 |
187| en.wikipedia | HTTP cookie | all-access | 2018-01-26 |
188| en.wikipedia | Polymath Project | all-access | 2018-01-27 |
189| en.wikipedia | List of United States stand-up comedians | all-access | 2018-01-27 |
190| en.wikipedia | List of stand-up comedians | all-access | 2018-01-27 |
191| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-01-27 |
192| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-01-27 |
193| en.wikipedia | List of British stand-up comedians | all-access | 2018-01-27 |
194| en.wikipedia | HRT 2 | all-access | 2018-01-27 |
195| en.wikipedia | Polymath Project | all-access | 2018-01-28 |
196| en.wikipedia | List of United States stand-up comedians | all-access | 2018-01-28 |
197| en.wikipedia | List of stand-up comedians | all-access | 2018-01-28 |
198| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-01-28 |
199| en.wikipedia | List of British stand-up comedians | all-access | 2018-01-28 |
200| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-01-28 |
201| en.wikipedia | HRT 2 | all-access | 2018-01-28 |
202| en.wikipedia | Polymath Project | all-access | 2018-01-29 |
203| en.wikipedia | List of United States stand-up comedians | all-access | 2018-01-29 |
204| en.wikipedia | List of stand-up comedians | all-access | 2018-01-29 |
205| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-01-29 |
206| en.wikipedia | List of British stand-up comedians | all-access | 2018-01-29 |
207| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-01-29 |
208| en.wikipedia | List of United States stand-up comedians | all-access | 2018-01-30 |
209| en.wikipedia | List of stand-up comedians | all-access | 2018-01-30 |
210| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-01-30 |
211| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-01-30 |
212| en.wikipedia | List of British stand-up comedians | all-access | 2018-01-30 |
213| en.wikipedia | Exo (band) | all-access | 2018-01-30 |
214| en.wikipedia | HRT 2 | all-access | 2018-01-31 |
215| en.wikipedia | List of United States stand-up comedians | all-access | 2018-01-31 |
216| en.wikipedia | List of stand-up comedians | all-access | 2018-01-31 |
217| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-01-31 |
218| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-01-31 |
219| en.wikipedia | List of British stand-up comedians | all-access | 2018-01-31 |
220| en.wikipedia | List of United States stand-up comedians | all-access | 2018-02-01 |
221| en.wikipedia | List of stand-up comedians | all-access | 2018-02-01 |
222| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-02-01 |
223| en.wikipedia | List of British stand-up comedians | all-access | 2018-02-01 |
224| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-02-01 |
225| en.wikipedia | HRT 2 | all-access | 2018-02-01 |
226| en.wikipedia | Conversation analysis | all-access | 2018-02-01 |
227| en.wikipedia | Exo (band) | all-access | 2018-02-01 |
228| en.wikipedia | List of United States stand-up comedians | all-access | 2018-02-02 |
229| en.wikipedia | List of stand-up comedians | all-access | 2018-02-02 |
230| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-02-02 |
231| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-02-02 |
232| en.wikipedia | List of British stand-up comedians | all-access | 2018-02-02 |
233| en.wikipedia | HRT 2 | all-access | 2018-02-02 |
234| en.wikipedia | Exo (band) | all-access | 2018-02-02 |
235| en.wikipedia | List of United States stand-up comedians | all-access | 2018-02-03 |
236| en.wikipedia | List of stand-up comedians | all-access | 2018-02-03 |
237| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-02-03 |
238| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-02-03 |
239| en.wikipedia | List of British stand-up comedians | all-access | 2018-02-03 |
240| en.wikipedia | California Proposition 218 (1996) | all-access | 2018-02-03 |
241| en.wikipedia | List of United States stand-up comedians | all-access | 2018-02-05 |
242| en.wikipedia | List of stand-up comedians | all-access | 2018-02-05 |
243| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-02-05 |
244| en.wikipedia | List of British stand-up comedians | all-access | 2018-02-05 |
245| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-02-05 |
246| en.wikipedia | Exo (band) | all-access | 2018-02-05 |
247| en.wikipedia | Exo (band) | all-access | 2018-02-06 |
248| en.wikipedia | List of United States stand-up comedians | all-access | 2018-02-06 |
249| en.wikipedia | List of stand-up comedians | all-access | 2018-02-06 |
250| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-02-06 |
251| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-02-06 |
252| en.wikipedia | List of British stand-up comedians | all-access | 2018-02-06 |
253| en.wikipedia | National Tsing Hua University | all-access | 2018-02-06 |
254| en.wikipedia | Miss Universe | all-access | 2018-02-06 |
255| en.wikipedia | Id Tech 3 | all-access | 2018-02-06 |
256| en.wikipedia | Ming Chuan University | all-access | 2018-02-06 |
257| de.wikipedia | Pressstempelkanne | all-access | 2018-02-06 |
258| en.wikipedia | Exo (band) | all-access | 2018-02-07 |
259| en.wikipedia | Id Tech 3 | all-access | 2018-02-07 |
260| en.wikipedia | List of United States stand-up comedians | all-access | 2018-02-07 |
261| en.wikipedia | List of stand-up comedians | all-access | 2018-02-07 |
262| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-02-07 |
263| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-02-07 |
264| en.wikipedia | List of British stand-up comedians | all-access | 2018-02-07 |
265| en.wikipedia | HRT 2 | all-access | 2018-02-07 |
266| en.wikipedia | Dopamine receptor D5 | all-access | 2018-02-07 |
267| en.wikipedia | List of United States stand-up comedians | all-access | 2018-02-08 |
268| en.wikipedia | List of stand-up comedians | all-access | 2018-02-08 |
269| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-02-08 |
270| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-02-08 |
271| en.wikipedia | List of British stand-up comedians | all-access | 2018-02-08 |
272| en.wikipedia | Exo (band) | all-access | 2018-02-08 |
273| en.wikipedia | HRT 2 | all-access | 2018-02-08 |
274| en.wikipedia | FOSDEM | all-access | 2018-02-08 |
275| en.wikipedia | Dopamine receptor D5 | all-access | 2018-02-08 |
276| en.wikipedia | HRT 2 | all-access | 2018-02-09 |
277| en.wikipedia | List of United States stand-up comedians | all-access | 2018-02-09 |
278| en.wikipedia | List of stand-up comedians | all-access | 2018-02-09 |
279| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-02-09 |
280| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-02-09 |
281| en.wikipedia | List of British stand-up comedians | all-access | 2018-02-09 |
282| en.wikipedia | List of United States stand-up comedians | all-access | 2018-02-10 |
283| en.wikipedia | List of stand-up comedians | all-access | 2018-02-10 |
284| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-02-10 |
285| en.wikipedia | List of British stand-up comedians | all-access | 2018-02-10 |
286| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-02-10 |
287| en.wikipedia | HRT 2 | all-access | 2018-02-10 |
288| en.wikipedia | Undefined | all-access | 2018-02-10 |
289| en.wikipedia | California Proposition 218 (1996) | all-access | 2018-02-10 |
290| en.wikipedia | List of United States stand-up comedians | all-access | 2018-02-12 |
291| en.wikipedia | List of stand-up comedians | all-access | 2018-02-12 |
292| en.wikipedia | List of British stand-up comedians | all-access | 2018-02-12 |
293| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-02-12 |
294| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-02-12 |
295| en.wikipedia | Gamera vs. Viras | all-access | 2018-02-12 |
296| en.wikipedia | List of United States stand-up comedians | all-access | 2018-02-13 |
297| en.wikipedia | List of stand-up comedians | all-access | 2018-02-13 |
298| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-02-13 |
299| en.wikipedia | List of British stand-up comedians | all-access | 2018-02-13 |
300| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-02-13 |
301| en.wikipedia | LaTeX | all-access | 2018-02-13 |
302| en.wikipedia | List of United States stand-up comedians | all-access | 2018-02-14 |
303| en.wikipedia | List of stand-up comedians | all-access | 2018-02-14 |
304| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-02-14 |
305| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-02-14 |
306| en.wikipedia | List of British stand-up comedians | all-access | 2018-02-14 |
307| en.wikipedia | Exo (band) | all-access | 2018-02-14 |
308| en.wikipedia | HRT 2 | all-access | 2018-02-14 |
309| en.wikipedia | List of United States stand-up comedians | all-access | 2018-02-15 |
310| en.wikipedia | List of stand-up comedians | all-access | 2018-02-15 |
311| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-02-15 |
312| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-02-15 |
313| en.wikipedia | List of British stand-up comedians | all-access | 2018-02-15 |
314| en.wikipedia | List of United States stand-up comedians | all-access | 2018-02-17 |
315| en.wikipedia | List of stand-up comedians | all-access | 2018-02-17 |
316| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-02-17 |
317| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-02-17 |
318| en.wikipedia | List of British stand-up comedians | all-access | 2018-02-17 |
319| en.wikipedia | California Proposition 218 (1996) | all-access | 2018-02-17 |
320| en.wikipedia | Mister Sinister | all-access | 2018-02-17 |
321| en.wikipedia | Exo (band) | all-access | 2018-02-17 |
322| en.wikipedia | List of United States stand-up comedians | all-access | 2018-02-16 |
323| en.wikipedia | List of stand-up comedians | all-access | 2018-02-16 |
324| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-02-16 |
325| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-02-16 |
326| en.wikipedia | List of British stand-up comedians | all-access | 2018-02-16 |
327| en.wikipedia | List of United States stand-up comedians | all-access | 2018-02-18 |
328| en.wikipedia | List of stand-up comedians | all-access | 2018-02-18 |
329| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-02-18 |
330| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-02-18 |
331| en.wikipedia | List of British stand-up comedians | all-access | 2018-02-18 |
332| en.wikipedia | Exo (band) | all-access | 2018-02-18 |
333| en.wikipedia | List of United States stand-up comedians | all-access | 2018-02-19 |
334| en.wikipedia | List of stand-up comedians | all-access | 2018-02-19 |
335| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-02-19 |
336| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-02-19 |
337| en.wikipedia | List of British stand-up comedians | all-access | 2018-02-19 |
338| en.wikipedia | Exo (band) | all-access | 2018-02-19 |
339| en.wikipedia | Exo (band) | all-access | 2018-02-21 |
340| en.wikipedia | List of United States stand-up comedians | all-access | 2018-02-21 |
341| en.wikipedia | List of stand-up comedians | all-access | 2018-02-21 |
342| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-02-21 |
343| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-02-21 |
344| en.wikipedia | List of British stand-up comedians | all-access | 2018-02-21 |
345| en.wikipedia | List of United States stand-up comedians | all-access | 2018-02-22 |
346| en.wikipedia | List of stand-up comedians | all-access | 2018-02-22 |
347| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-02-22 |
348| en.wikipedia | List of British stand-up comedians | all-access | 2018-02-22 |
349| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-02-22 |
350| en.wikipedia | The Bitter Tears of Petra von Kant | all-access | 2018-02-22 |
351| en.wikipedia | Exo (band) | all-access | 2018-02-23 |
352| en.wikipedia | List of United States stand-up comedians | all-access | 2018-02-23 |
353| en.wikipedia | List of stand-up comedians | all-access | 2018-02-23 |
354| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-02-23 |
355| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-02-23 |
356| en.wikipedia | List of British stand-up comedians | all-access | 2018-02-23 |
357| en.wikipedia | Sign o' the Times (song) | all-access | 2018-02-23 |
358| en.wikipedia | Exo (band) | all-access | 2018-02-24 |
359| en.wikipedia | List of United States stand-up comedians | all-access | 2018-02-24 |
360| en.wikipedia | List of stand-up comedians | all-access | 2018-02-24 |
361| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-02-24 |
362| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-02-24 |
363| en.wikipedia | List of British stand-up comedians | all-access | 2018-02-24 |
364| en.wikipedia | California Proposition 218 (1996) | all-access | 2018-02-24 |
365| en.wikipedia | List of stand-up comedians | all-access | 2018-02-25 |
366| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-02-25 |
367| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-02-25 |
368| en.wikipedia | List of British stand-up comedians | all-access | 2018-02-25 |
369| en.wikipedia | Celtiberian Wars | all-access | 2018-02-25 |
370| en.wikipedia | List of United States stand-up comedians | all-access | 2018-02-26 |
371| en.wikipedia | List of stand-up comedians | all-access | 2018-02-26 |
372| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-02-26 |
373| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-02-26 |
374| en.wikipedia | List of British stand-up comedians | all-access | 2018-02-26 |
375| en.wikipedia | Verst | all-access | 2018-02-26 |
376| en.wikipedia | List of United States stand-up comedians | all-access | 2018-02 |
377| en.wikipedia | List of stand-up comedians | all-access | 2018-02 |
378| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-02 |
379| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-02 |
380| en.wikipedia | List of British stand-up comedians | all-access | 2018-02 |
381| bs.wikipedia | 19. juni | all-access | 2018-02 |
382| en.wikipedia | Grsync | all-access | 2018-03-20 |
383| en.wikipedia | Radon | all-access | 2018-03-20 |
384| en.wikipedia | Buckminster Fuller | all-access | 2018-03-22 |
385| en.wikipedia | List of Soul Reapers in Bleach | all-access | 2018-03-23 |
386| en.wikipedia | May to December | all-access | 2018-03-24 |
387| fr.wikipedia | Defense Advanced Research Projects Agency | all-access | 2018-02 |
388| ga.wikipedia | Maximilian Kolbe | all-access | 2018-02 |
389| en.wikipedia | Grsync | all-access | 2018-03-22 |
390| zh.wikipedia | Wiki | desktop | 2018-02 |
391| zh.wikipedia | 維基媒體基金會 | desktop | 2018-02 |
392| zh.wikipedia | 維基媒體基金會 | all-access | 2018-02 |
393| zh.wikipedia | Wiki | all-access | 2018-02 |
394| ga.wikipedia | Maximilian Kolbe | desktop | 2018-02 |
395| en.wikipedia | Celtiberian Wars | desktop | 2018-02-25 |
396| en.wikipedia | Mister Sinister | desktop | 2018-02-17 |
397| en.wikipedia | Dopamine receptor D5 | desktop | 2018-02-07 |
398| en.wikipedia | Id Tech 3 | desktop | 2018-02-07 |
399| en.wikipedia | Id Tech 3 | desktop | 2018-02-06 |
400| en.wikipedia | FOSDEM | desktop | 2018-02-08 |
401| en.wikipedia | Miss Universe | desktop | 2018-02-06 |
402| en.wikipedia | Ming Chuan University | desktop | 2018-02-06 |
403| en.wikipedia | Polymath Project | desktop | 2018-01-26 |
404| en.wikipedia | Polymath Project | desktop | 2018-01-27 |
405| en.wikipedia | Polymath Project | desktop | 2018-01-28 |
406| en.wikipedia | Polymath Project | desktop | 2018-01-29 |
407| en.wikipedia | Conversation analysis | desktop | 2018-02-01 |
408| en.wikipedia | National Tsing Hua University | desktop | 2018-02-06 |
409| en.wikipedia | Kakar | all-access | 2018-03 |
410| en.wikipedia | List of Australian stand-up comedians | all-access | 2018-03 |
411| en.wikipedia | List of Canadian stand-up comedians | all-access | 2018-03 |
412| en.wikipedia | List of British stand-up comedians | all-access | 2018-03 |
413| en.wikipedia | List of stand-up comedians | all-access | 2018-03 |
414| en.wikipedia | List of United States stand-up comedians | all-access | 2018-03 |
415| en.wikipedia | Golden Earring discography | all-access | 2018-03 |
416| en.wikipedia | Kakar | desktop | 2018-03 |
417| en.wikipedia | Cerro de la Silla | all-access | 2018-05-13 |
418| ru.wiktionary | от | all-access | 2018-08 |
419| en.wikipedia | Louis Tomlinson | all-access | 2018-08 |
420| ru.wikipedia | Eduroam | all-access | 2018-09-29 |
421| ru.wikipedia | Eduroam | all-access | 2018-09-30 |
422| ru.wikipedia | Eduroam | all-access | 2018-10-01 |
423| ru.wikipedia | Eduroam | all-access | 2018-09 |
424| ru.wiktionary | scam | all-access | 2018-09 |
425| ru.wikipedia | Eduroam | all-access | 2018-10-05 |
426| ru.wikipedia | Ð˜ÑÑ‚Ð¾Ñ€Ð¸Ñ Ð¡ÐµÐ²Ð°ÑÑ‚Ð¾Ð¿Ð¾Ð»Ñ | all-access | 2018-10-14 |
427| de.wikipedia | Test | all-access | 2018-10-13 |
428| de.wikipedia | Herpes Zoster | all-access | 2018-09 |
429| de.wikipedia | Wüstenrot Stiftung | all-access | 2018-09 |
430| de.wikipedia | Liste in Deutschland vorhandener Dampflokomotiven | all-access | 2018-09 |
431| de.wikipedia | Liste der Spieler des VfB Stuttgart | all-access | 2018-09 |
432| de.wikipedia | Unix-Shell | all-access | 2018-09 |
433| de.wikipedia | Liste der Spieler des 1. FC Union Berlin | all-access | 2018-09 |
434| de.wikipedia | St�ckgut | all-access | 2018-09 |
435| de.wikipedia | Sch�ttgut | all-access | 2018-09 |
436| de.wikipedia | F�rdertechnik | all-access | 2018-09 |
437| de.wikipedia | Abtreibung | all-access | 2018-09 |
438| es.wikipedia | Spécial:Recherche | all-access | 2018-09 |
439| fr.wikipedia | Oignon | desktop | 2018-09-18 |
440| fr.wikipedia | undefined | desktop | 2018-10-18 |
441| ru.wikipedia | Мамонтов, Савва Иванович | all-access | 2018-10-22 |
442| ru.wikipedia | Мамонтов, Савва Иванович | all-access | 2018-10-23 |
443| de.wikipedia | St�ckgut | all-access | 2018-10-23 |
444| de.wikipedia | Sch�ttgut | all-access | 2018-10-23 |
445| de.wikipedia | F�rdertechnik | all-access | 2018-10-23 |
446| de.wikipedia | St�ckgut | desktop | 2018-09 |
447| de.wikipedia | Sch�ttgut | desktop | 2018-09 |
448| de.wikipedia | F�rdertechnik | desktop | 2018-09 |
449| de.wikipedia | F�rderband | desktop | 2018-09 |
450| de.wikipedia | Test | all-access | 2018-10-14 |
451| de.wikipedia | Test | all-access | 2018-10-15 |
452| de.wikipedia | Test | all-access | 2018-10-12 |
453| de.wikipedia | Test | all-access | 2018-10-11 |
454| de.wikipedia | Test | desktop | 2018-10-11 |
455| de.wikipedia | Test | desktop | 2018-10-10 |
456| de.wikipedia | Test | all-access | 2018-10-10 |
457| de.wikipedia | Test | all-access | 2018-10-09 |
458| de.wikipedia | Test | desktop | 2018-10-09 |
459| de.wikipedia | Test | desktop | 2018-10-08 |
460| de.wikipedia | Test | all-access | 2018-10-08 |
461| de.wikipedia | Pressstempelkanne | desktop | 2018-02-06 |
462| en.wikipedia | Louis Tomlinson | all-access | 2018-07 |
463| ru.wikipedia | Eduroam | desktop | 2018-09 |
464| ru.wikipedia | Eduroam | desktop | 2018-10-01 |
465| ru.wikipedia | Eduroam | desktop | 2018-09-30 |
466| ru.wikipedia | Eduroam | desktop | 2018-09-29 |
467| ru.wikipedia | Eduroam | desktop | 2018-09-28 |
468| ru.wikipedia | Ð˜ÑÑ‚Ð¾Ñ€Ð¸Ñ Ð¡ÐµÐ²Ð°ÑÑ‚Ð¾Ð¿Ð¾Ð»Ñ | desktop | 2018-10-14 |
469| ru.wiktionary | scam | desktop | 2018-09 |
470| ru.wiktionary | scam | desktop | 2018-09-02 |
471| ru.wiktionary | scam | all-access | 2018-09-02 |
472| ru.wiktionary | scam | all-access | 2018-08-25 |
473| ru.wiktionary | scam | desktop | 2018-08-25 |
474| ru.wiktionary | scam | desktop | 2018-08 |
475| ru.wiktionary | scam | all-access | 2018-08 |
476| ru.wiktionary | от | desktop | 2018-08 |
477| en.wikipedia | Cook's Country | all-access | 2018-10 |
478| en.wikipedia | XXXX | all-access | 2018-10 |
479+---------------+----------------------------------------------------+------------+------------+

Nuria added a comment.Dec 20 2018, 8:48 PM

+1 to exclude those on list and and @EdErhart-WMF to include the fact that exclusions come from crowdsourced data from our community. I think the excluded titles make up for a blogposts themselves.

If you can add Greek, we'd be very happy :-)

Itzike added a subscriber: Itzike.Dec 23 2018, 7:47 AM

I just made a query that yields the result for all wikis simultaneously (P7945, based on @Milimetric's earlier draft) and also includes some helpful additions like the percentage of mobile views for each page (for easier anomaly detection). See T183903#4847361 for details - perhaps @MusikAnimal might be interested in running this too and posting the result in suitable form for all interested parties. The result will still need some manual vetting for each wiki.

CCing @Reke and @Shangkuanlc who have an interest in this topic as well.

Tbayer updated the task description. (Show Details)Dec 31 2018, 8:18 PM
MusikAnimal added a comment.EditedJan 2 2019, 2:25 AM

I just made a query that yields the result for all wikis simultaneously (P7945, based on milimetric's earlier draft) and also includes some helpful additions like the percentage of mobile views for each page (for easier anomaly detection). See T183903#4847361 for details - perhaps MusikAnimal might be interested in running this too and posting the result in suitable form for all interested parties. The result will still need some manual vetting for each wiki.

Going to reply here. The query is amazing!! Thank you and @Milimetric :) I ran it myself and indeed it took maybe 45 minutes. Unfortunately I can't figure how to export to disk, and the number of lines returned in the result set exceeds the max number of lines in my terminal. So, I can't see the full results. How did you do it?

I'm happy to help filter out the anomalies. I will point out that the mobile/desktop viewership % doesn't seem to work on all projects, e.g. those where mobile devices aren't as popular. Hopefully we can tell by just looking at the average % for the full list on that wiki. 800+ wikis is an awful lot, so maybe we could split up the work, or just focus on the large wikis?

Using a fancy text editor, I think wikifying the list will be pretty straightforward. Should we just dump the results on Meta, one page per wiki? Probably will limit this to the wikis of interest, to avoid having to get bot approval (800+ pages is a lot!).

@EdErhart-WMF @geraki Do you need any other formats? CSV or HTML with some specific structure?

I just made a query that yields the result for all wikis simultaneously (P7945, based on milimetric's earlier draft) and also includes some helpful additions like the percentage of mobile views for each page (for easier anomaly detection). See T183903#4847361 for details - perhaps MusikAnimal might be interested in running this too and posting the result in suitable form for all interested parties. The result will still need some manual vetting for each wiki.

Going to reply here. The query is amazing!! Thank you and @Milimetric :) I ran it myself and indeed it took maybe 45 minutes. Unfortunately I can't figure how to export to disk, and the number of lines returned in the result set exceeds the max number of lines in my terminal. So, I can't see the full results. How did you do it?

You can use Hive in batch mode and save the result in a file, see e.g.
https://wikitech.wikimedia.org/wiki/Analytics/Systems/Cluster/Hive/Queries#Batch_mode .
Personally I often use this from within a shell script that also sends me an email with the result as soon as the query has completed: P7948
(For large result files such as this, SCP may be a better option though than email for the purpose of transfering the file from the analytics server to your own machine.)

I'm happy to help filter out the anomalies. I will point out that the mobile/desktop viewership % doesn't seem to work on all projects, e.g. those where mobile devices aren't as popular. Hopefully we can tell by just looking at the average % for the full list on that wiki. 800+ wikis is an awful lot, so maybe we could split up the work, or just focus on the large wikis?

Personally I think it would be fine to just publish the raw results with the known general caveats, and leave it to interested community members or affiliate organizations to vet them and compile them into a list for an individual wiki. (That is also a task that could benefit from knowledge of the corresponding language and culture.)

Using a fancy text editor, I think wikifying the list will be pretty straightforward. Should we just dump the results on Meta, one page per wiki? Probably will limit this to the wikis of interest, to avoid having to get bot approval (800+ pages is a lot!).

Would the TSV fit into a Google spreadsheet?

@EdErhart-WMF @geraki Do you need any other formats? CSV or HTML with some specific structure?

Yes, TSV would be great and can work with both Excel and Google spreadsheet.

Would the TSV fit into a Google spreadsheet?

@EdErhart-WMF @geraki Do you need any other formats? CSV or HTML with some specific structure?

Taufik added a subscriber: Taufik.Jan 3 2019, 4:26 AM

It would be great if you can provide a list for ms.wikipedia :D

It would be great if in 11 months anyone could create the lists that they want themselves, by following some documentation.

The file produced by Tbayer's query is too big to upload to Phabricator, apparently, so I've attached each requested wiki below. All credit goes to Tbayer and Milimetric for collecting this data! I just ran the query they wrote :)







I tested it and it did work in Google Sheets. Per above I did not vet the data myself. There are some known data anomalies listed at T211827#4838895 that you can refer to, or go by the percentage of mobile traffic (last column in the TSV), at your discretion.

I'm going to try to get this data integrated into https://tools.wmflabs.org/topviews somehow (maybe even the top 1000 pages), unless there's a possibility T154381 will get addressed soon? If I manage to get it to work, I'll do the same for 2017 and 2016.

Hi @MusikAnimal, could you export data for Serbian Wikipedia (srwiki) as well?

Hi @MusikAnimal, could you export data for Serbian Wikipedia (srwiki) as well?

I did manage to come up with a system to show the yearly data (for any project) in https://tools.wmflabs.org/topviews. It is still in development but hopefully will have it deployed tomorrow :)

@MusikAnimal: Yay! Feel free to claim T154446

I'm going to try to get this data integrated into https://tools.wmflabs.org/topviews somehow (maybe even the top 1000 pages), unless there's a possibility T154381 will get addressed soon? If I manage to get it to work, I'll do the same for 2017 and 2016.

Thank you @MusikAnimal for creating the tsv file. I have listed the [[ https://docs.google.com/spreadsheets/d/1xMfNcMFJibJkLFEscpRxuFiNIdNZgeDaWJksY-2jASw/edit?usp=sharing

Chinese Wikipedia articles by the columns you indicated ]]. However, I am confused by the above quote. What is the typical anomalies that you suggest? I have highlight in yellow in the google spreadsheet for the links that receives the pageviews by mobile traffic under 20 %. Is that the only criteria that I should tick out?
4nn1l2 added a subscriber: 4nn1l2.Jan 4 2019, 7:24 AM

The file produced by Tbayer's query is too big to upload to Phabricator, apparently, so I've attached each requested wiki below. All credit goes to Tbayer and Milimetric for collecting this data! I just ran the query they wrote :)

@MusikAnimal Could you please run the querry for the Persian Wikipedia (fawiki) as well?

MusikAnimal added a comment.EditedJan 4 2019, 5:40 PM

MusikAnimal Could you please run the querry for the Persian Wikipedia (fawiki) as well?

I have listed the Chinese Wikipedia articles by the columns you indicated. However, I am confused by the above quote. What is the typical anomalies that you suggest? I have highlight in yellow in the google spreadsheet for the links that receives the pageviews by mobile traffic under 20 %. Is that the only criteria that I should tick out?

It depends on the wiki. On English Wikipedia, it's unusual for there to be very low mobile viewership, or even very low desktop. I would look at what seems normal on your wiki (based on most of the entries in your most-viewed report), and judge from that. Other tactics commonly used:

  • Does it make sense that the article would be in the most-viewed? Generally I would expect topical subjects (e.g. were in the news)
  • When looking at per-day pageviews, do you see patterns that look bot-like? Usually for genuine traffic, I see a spike, then traffic slowly gets smaller over time as public interest declines. If you see a huge spike of pageviews in a single day or short time period, then suddenly it goes back to lower pageviews, that might be suspect (unless it was "today's featured article" or the like)
  • How many edits were made in the period? Generally high viewership will also attract editing. It may be tedious to get this data by hand, but hopefully later today I'll have the yearly data on https://tools.wmflabs.org/topviews so you can quickly see what editing activity was like for each article.

From the crowd-sourced data I have three Chinese articles listed as likely false positives:

  • 郭建宏 (製作人) -- Almost all traffic is from desktop. Pageviews chart suggests quick, isolated periods of interest. Compare with 如懿传 for example where you can see traffic slowly tapered off, which to me seems more natural.
  • 維基媒體基金會 -- This is a redirect that had zero edits in 2018. The pageviews chart looks suspicious, especially from April through August where there were almost exactly the same number of pageviews every day.
  • Wiki -- The pageviews chart looks similar to 維基媒體基金會. Only 7 edits for the year.

If there are any other articles you're unsure about, we can look at private data (such as where traffic originated from geographically), but this is tedious.

For the record, to others with access to the analytics cluster, this is an example query I use to confirm anomalies (or "false positives" as I call them):

SELECT city, SUM(view_count) AS viewcount
FROM pageview_hourly
WHERE page_title = "Foo bar"
 AND project = "en.wikipedia"
 AND year = 2018
 AND month = 11
 AND day = 11
GROUP BY city
ORDER BY viewcount DESC
LIMIT 5;

Usually a very high amount of traffic will come from a single random city, and that city is often is not very large, or in a country that doesn't have many speakers of the language the article was written in.

Topviews now has yearly data for 2017 and 2018: https://tools.wmflabs.org/topviews/?project=zh.wikipedia.org&date=2018 and I'll be adding 2016 shortly.

Due to storage concerns, I've only included the top 500 pages in the mainspace, and only for 'all-access' platform (desktop and mobile combined). I admittedly cobbled together the code as quick as possible. There may be some UI bugs (e.g. you click on thing and another thing doesn't work anymore), but the data you see should be accurate.

Many of the false positives mentioned above (T211827#4855654 specifically) have been removed from Topviews. I'm going through other large projects and removing other obvious false positives. You can help, too! See https://tools.wmflabs.org/topviews/faq/#false_positive for more info. You can also see which pages were removed in the tool itself, look for the link at "[N pages] have been automatically excluded" below the Search bar.

Hope this helps!

@MusikAnimal Can you do for Malay Wikipedia (ms.wikipedia.org)? The one you did was Malayalam (ml.wikipedia.org)

MusikAnimal added a comment.EditedJan 5 2019, 12:49 AM

@MusikAnimal Can you do for Malay Wikipedia (ms.wikipedia.org)? The one you did was Malayalam (ml.wikipedia.org)

Sorry about that. Note you can now get the data at https://tools.wmflabs.org/topviews/?project=ms.wikipedia.org&date=2018. This also includes editing statistics. You can then use DownloadCSV to export as CSV. I can add TSV if needed. There is also sort of a bug here -- the CSV won't include editing data except for the articles shown on the screen. So just click "Show more" at the bottom 5 times to load the rest of the editing data.

Hopefully the above will suffice for others, but anyway here's the TSV for ms.wikipedia (does not include editing stats):

Topviews now has yearly data for 2017 and 2018: https://tools.wmflabs.org/topviews/?project=zh.wikipedia.org&date=2018 and I'll be adding 2016 shortly.

@MusikAnimal Thanks! There is a weird issue with the links, however. I can see the topviews list for the Persian Wikipedia following this link https://tools.wmflabs.org/topviews/?project=fa.wikipedia.org&platform=all-access&date=2018&excludes= on Chrome v. 67, but not on Firefox v. 64! On Firefox, it jumsps to the monthly viewes (December 2018).

Shizhao added a subscriber: Shizhao.Jan 7 2019, 3:50 AM
在T211827#4855654中,@MusikAnimal写道:
  • 維基媒體基金會 -- This is a redirect that had zero edits in 2018. The pageviews chart looks suspicious, especially from April through August where there were almost exactly the same number of pageviews every day.
  • Wiki -- The pageviews chart looks similar to 維基媒體基金會. Only 7 edits for the year.

If there are any other articles you're unsure about, we can look at private data (such as where traffic originated from geographically), but this is tedious.

About this, see T172379

I guess this task can be closed now?

BTW it might be nice to collect some of the pieces have been published based on this data, e.g.: