Research:Top edited English Wikipedia articles in 2016

This page documents a completed research project.


The comms team reached out for a summary of the most popular articles by edits in 2016. In this project, we'll list out those pages and state their edit counts. See [1] for past analyses.

Methods

edit

Basically, we're counting up the number of revisions that appear in the revision table for these pages. Since joining page to revision is slow, we'll aggregate revision before joining to page. This will give as a variable top N results that are actually articles from which we can take the top N that we want.

overall sql query
SELECT page_namespace, page_title, edits 
FROM (
   SELECT rev_page, COUNT(*) AS edits
   FROM revision
   WHERE rev_timestamp BETWEEN "20151210" AND "20161210"
   GROUP BY rev_page
   ORDER BY edits DESC
   LIMIT 500
) AS top_page_edits 
INNER JOIN page ON rev_page = page_id
ORDER BY page_namespace, edits DESC;
monthly sql query
(SELECT month, page_namespace, page_title, edits 
FROM (
   SELECT LEFT(rev_timestamp, 6) AS month, rev_page, COUNT(*) AS edits
   FROM revision
   WHERE rev_timestamp BETWEEN "201601" AND "201602"
   GROUP BY month, rev_page
   ORDER BY edits DESC
   LIMIT 500
) AS top_page_edits 
INNER JOIN page ON rev_page = page_id
WHERE page_namespace = 0
ORDER BY page_namespace, edits DESC
LIMIT 20)

UNION ALL 

(SELECT month, page_namespace, page_title, edits 
FROM (
   SELECT LEFT(rev_timestamp, 6) AS month, rev_page, COUNT(*) AS edits
   FROM revision
   WHERE rev_timestamp BETWEEN "201602" AND "201603"
   GROUP BY month, rev_page
   ORDER BY edits DESC
   LIMIT 500
) AS top_page_edits 
INNER JOIN page ON rev_page = page_id
WHERE page_namespace = 0
ORDER BY page_namespace, edits DESC
LIMIT 20)

UNION ALL 

(SELECT month, page_namespace, page_title, edits 
FROM (
   SELECT LEFT(rev_timestamp, 6) AS month, rev_page, COUNT(*) AS edits
   FROM revision
   WHERE rev_timestamp BETWEEN "201603" AND "201604"
   GROUP BY month, rev_page
   ORDER BY edits DESC
   LIMIT 500
) AS top_page_edits 
INNER JOIN page ON rev_page = page_id
WHERE page_namespace = 0
ORDER BY page_namespace, edits DESC
LIMIT 20)

UNION ALL 

(SELECT month, page_namespace, page_title, edits 
FROM (
   SELECT LEFT(rev_timestamp, 6) AS month, rev_page, COUNT(*) AS edits
   FROM revision
   WHERE rev_timestamp BETWEEN "201604" AND "201605"
   GROUP BY month, rev_page
   ORDER BY edits DESC
   LIMIT 500
) AS top_page_edits 
INNER JOIN page ON rev_page = page_id
WHERE page_namespace = 0
ORDER BY page_namespace, edits DESC
LIMIT 20)

UNION ALL 

(SELECT month, page_namespace, page_title, edits 
FROM (
   SELECT LEFT(rev_timestamp, 6) AS month, rev_page, COUNT(*) AS edits
   FROM revision
   WHERE rev_timestamp BETWEEN "201605" AND "201606"
   GROUP BY month, rev_page
   ORDER BY edits DESC
   LIMIT 500
) AS top_page_edits 
INNER JOIN page ON rev_page = page_id
WHERE page_namespace = 0
ORDER BY page_namespace, edits DESC
LIMIT 20)

UNION ALL 

(SELECT month, page_namespace, page_title, edits 
FROM (
   SELECT LEFT(rev_timestamp, 6) AS month, rev_page, COUNT(*) AS edits
   FROM revision
   WHERE rev_timestamp BETWEEN "201606" AND "201607"
   GROUP BY month, rev_page
   ORDER BY edits DESC
   LIMIT 500
) AS top_page_edits 
INNER JOIN page ON rev_page = page_id
WHERE page_namespace = 0
ORDER BY page_namespace, edits DESC
LIMIT 20)

UNION ALL 

(SELECT month, page_namespace, page_title, edits 
FROM (
   SELECT LEFT(rev_timestamp, 6) AS month, rev_page, COUNT(*) AS edits
   FROM revision
   WHERE rev_timestamp BETWEEN "201607" AND "201608"
   GROUP BY month, rev_page
   ORDER BY edits DESC
   LIMIT 500
) AS top_page_edits 
INNER JOIN page ON rev_page = page_id
WHERE page_namespace = 0
ORDER BY page_namespace, edits DESC
LIMIT 20)

UNION ALL 

(SELECT month, page_namespace, page_title, edits 
FROM (
   SELECT LEFT(rev_timestamp, 6) AS month, rev_page, COUNT(*) AS edits
   FROM revision
   WHERE rev_timestamp BETWEEN "201608" AND "201609"
   GROUP BY month, rev_page
   ORDER BY edits DESC
   LIMIT 500
) AS top_page_edits 
INNER JOIN page ON rev_page = page_id
WHERE page_namespace = 0
ORDER BY page_namespace, edits DESC
LIMIT 20)

UNION ALL 

(SELECT month, page_namespace, page_title, edits 
FROM (
   SELECT LEFT(rev_timestamp, 6) AS month, rev_page, COUNT(*) AS edits
   FROM revision
   WHERE rev_timestamp BETWEEN "201609" AND "201610"
   GROUP BY month, rev_page
   ORDER BY edits DESC
   LIMIT 500
) AS top_page_edits 
INNER JOIN page ON rev_page = page_id
WHERE page_namespace = 0
ORDER BY page_namespace, edits DESC
LIMIT 20)

UNION ALL 

(SELECT month, page_namespace, page_title, edits 
FROM (
   SELECT LEFT(rev_timestamp, 6) AS month, rev_page, COUNT(*) AS edits
   FROM revision
   WHERE rev_timestamp BETWEEN "201610" AND "201611"
   GROUP BY month, rev_page
   ORDER BY edits DESC
   LIMIT 500
) AS top_page_edits 
INNER JOIN page ON rev_page = page_id
WHERE page_namespace = 0
ORDER BY page_namespace, edits DESC
LIMIT 20)

UNION ALL 

(SELECT month, page_namespace, page_title, edits 
FROM (
   SELECT LEFT(rev_timestamp, 6) AS month, rev_page, COUNT(*) AS edits
   FROM revision
   WHERE rev_timestamp BETWEEN "201611" AND "201612"
   GROUP BY month, rev_page
   ORDER BY edits DESC
   LIMIT 500
) AS top_page_edits 
INNER JOIN page ON rev_page = page_id
WHERE page_namespace = 0
ORDER BY page_namespace, edits DESC
LIMIT 20)

UNION ALL 

(SELECT month, page_namespace, page_title, edits 
FROM (
   SELECT LEFT(rev_timestamp, 6) AS month, rev_page, COUNT(*) AS edits
   FROM revision
   WHERE rev_timestamp BETWEEN "201612" AND "201701"
   GROUP BY month, rev_page
   ORDER BY edits DESC
   LIMIT 500
) AS top_page_edits 
INNER JOIN page ON rev_page = page_id
WHERE page_namespace = 0
ORDER BY page_namespace, edits DESC
LIMIT 20);

Result

edit

Results from the query were manually filtered to only include namespace 0 -- the article namespace.

Overall

edit
Article edits
Deaths in 2016 18230
Donald Trump 8933
List of Hillary Clinton presidential campaign endorsements 6527
United States presidential election 6162
Republican Party presidential primaries 5715
2016 Orlando nightclub shooting 5540
Bailando 2015 5342
List of Donald Trump presidential campaign endorsements 5328
2016 in sports 5277
2016 in South Korean music 5074
Beverly Gray 4957
Statewide opinion polling for the United States presidential election 4743
Panama Papers 4659
2016 in Philippine television 4600
2016 Pacific typhoon season 4244
2016 Atlantic hurricane season 3874
Democratic Party presidential primaries 3736
Batman v Superman: Dawn of Justice 3593
The Life of Pablo 3574
Vincent van Gogh 3551
Donald Trump presidential campaign 3513
United Kingdom European Union membership referendum 3433
2016 ATP Challenger Tour 3412
Miss Universe 2016 3358
A.J. Styles 3357
WrestleMania 32 3307
Occupation of the Malheur National Wildlife Refuge 3289
2016 Nice attack 3262
2016 in film 3236
Views 3168
2016 Pacific hurricane season 2848
2016 2773
El Coyote 2715
Transformers: The Last Knight 2711
List of 2016 albums 2703
Manchán of Mohill 2702
List of most viewed YouTube videos 2698
Big Brother 18 2691
List of original programs distributed by Netflix 2603
Protests against Donald Trump 2592
The Jungle Book 2582
The Voice 2567
2016 in American television 2566
List of WWE personnel 2559
RuPaul's Drag Race 2554
Athletics at the 2016 Summer Olympics – Qualification 2508
2016 WTA Finals 2490
Finding Dory 2472
DC Extended Universe 2467
2016 Turkish coup d'état attempt 2464
The Voice 2458
RuPaul's Drag Race: All Stars 2414
Lonnie Mack 2351
2016 WTA Tour 2335
2016 ATP World Tour 2327
Star Wars: The Force Awakens 2320
Planet Nine 2318
List of Autobots 2276
X-Men: Apocalypse 2271
American Idol 2258
Deadpool 2257
The X Factor 2252
Forcade 2236
Nationwide opinion polling for the United States presidential election 2227
Pokémon Go 2219
America's Got Talent 2216
Zootopia 2202
Jordan 2201
Captain America: Civil War 2188
2016 Brussels bombings 2187
Political positions of Donald Trump 2185
Great Britain at the 2016 Summer Olympics 2140
Nuestra Belleza Latina 2016 2138
United States at the 2016 Summer Olympics 2120
2017 in sports 2118
Muhammad Ali 2115
Sausage Party 2112
List of earthquakes in 2016 2107
Hillary Clinton 2082
Independence Day: Resurgence 2081
EgyptAir Flight 804 2081
Newspaper endorsements in the United States presidential election 2072
Dangerous Woman 2065
List of current champions in WWE 2055
The Revenant 2044
Bailando 2016 2019
2016 AFL season 2015
Brexit 2014
Big Brother Canada 2007
Bigg Boss 10 1997
List of terrorist incidents 1983
Garage rock 1965
Ghostbusters 1960
List of American Horror Story characters 1958
Edge 1957
India at the 2016 Summer Olympics 1953
List of Decepticons 1930
Legalism 1929
David Bowie 1928
Twice 1924
2016 shooting of Dallas police officers 1900
List of Bernie Sanders presidential campaign endorsements 1892
Big Brother: Over the Top 1891
Panathinaikos B.C. 1872
2016 Munich shooting 1867
Asia's Next Top Model 1867
2015–16 Zika virus epidemic 1856
List of Philippine television specials aired in 2016 1855
List of deaths in rock and roll 1854
Open Era tennis records – men's singles 1848
2016 in video gaming 1841
Strictly Come Dancing 1834
2016–17 United States network television schedule 1825
Canada at the 2016 Summer Olympics 1818
Baal Veer 1814
2016 in British television 1807
Turkish military intervention in Syria 1807
The Loud House 1802
Naagin 1801
Cary Grant 1800
2016 ATP World Tour Finals 1795
ATP World Tour records 1792
Eurovision Song Contest 2016 1785
Suicide Squad 1779
Endorsements in the United Kingdom European Union membership referendum 1771
Rodrigo Duterte 1764
List of The Flash episodes 1757
List of Running Man episodes 1753
2016 NBA Playoffs 1732
Prince 1715
Hurricane Matthew 1714
Anti 1712
Alt-right 1704
Copa América Centenario 1693
Survivor Series 1689
2016 clown sightings 1685
Flint water crisis 1683
2016 World Series 1671
List of highest-grossing animated films 1662
List of Steven Universe characters 1659
2016 Indian Premier League 1658
88th Academy Awards 1657
Conor McGregor 1648
List of 2016–17 NBA season transactions 1646
List of Steven Universe episodes 1640
2016–17 FC Barcelona season 1632
The Secret Life of Pets 1624
Dancing with the Stars 1623
X-Men 1623
List of White Pass and Yukon Route locomotives and cars 1612
Endorsements for the Republican Party presidential primaries 1610
John C. Calhoun 1609
2016 World Snooker Championship 1607
Donald Trump sexual misconduct allegations 1607
Work Capability Assessment 1605
Legends of Tomorrow 1601
Doctor Strange 1601
World Chess Championship 2016 1594
List of programs broadcast by GMA Network 1594
Pinoy Big Brother: Lucky 7 1593
2016 in the United States 1588
United States presidential election 1587
MTA Regional Bus Operations bus fleet 1580
List of people named in the Panama Papers 1577
Ang Probinsyano 1577
Australian federal election 1575
Cabinet of Donald Trump 1571
Statewide opinion polling for the Democratic Party presidential primaries 1570
Dol-de-Bretagne's Cathedral 1565
2016 NASCAR Sprint Cup Series 1562
2016 Indian Super League season 1561
SummerSlam 1561
2016 in the Philippines 1557
Heavy metals 1555
Work from Home 1553
Encantadia 1551
United States House of Representatives elections 1551
Great Britain at the 2016 Summer Paralympics 1551
Fantastic Beasts and Where to Find Them 1550
Dancing with the Stars 1548
Björn Kuipers 1547
Zika virus 1543
Doble Kara 1541
Birds in the Trap Sing McKnight 1541
Russia at the 2016 Summer Olympics 1540
2016 Summer Olympics medal table 1538
Drake 1534
Junior Eurovision Song Contest 2016 1534
Vladimir Putin 1532
Portsmouth 1527
ASAP 1527
2016–17 Premier League 1525
Chronological summary of the 2016 Summer Olympics 1522
List of EastEnders characters 1515
List of countries by GDP 1515
Moana 1514
Flydubai Flight 981 1508
List of countries and dependencies by population 1502
Bernie Sanders 1493
Snooker world ranking points 2016/2017 1488
Tornadoes of 2016 1484
Lemonade 1482
Leicester City F.C. 1480
Miraculous: Tales of Ladybug & Cat Noir 1477
Kabali 1476
Florida Gators football 1472

Monthly breakdown

edit
rank January February March April
1 Occupation of the Malheur National Wildlife Refuge 2158 The Life of Pablo 1520 Deaths in 2016 2107 Panama Papers 3425
2 Deaths in 2016 2014 Deaths in 2016 1470 2016 Brussels bombings 1896 Beverly Gray 1630
3 Planet Nine 1319 Republican Party presidential primaries, 2016 1149 Republican Party presidential primaries, 2016 1638 Deaths in 2016 1607
4 2016 Australian Open 1225 2016 Pakistan Super League 1101 Batman v Superman: Dawn of Justice 1446 WrestleMania 32 1539
5 Jascha Spivakovsky 1175 American Idol (season 15) 1050 Flydubai Flight 981 1316 Bailando 2015 1412
6 David Bowie 1133 Deadpool (film) 919 The Voice (U.S. season 10) 1304 2016 World Snooker Championship 1347
7 Florida Gators football 978 First observation of gravitational waves 907 List of Donald Trump presidential campaign endorsements, 2016 1139 Republican Party presidential primaries, 2016 1307
8 2015–16 NFL playoffs 949 2016 in sports 906 Donald Trump 1115 Prince (musician) 1247
9 2016 Australian Open – Men's Singles 840 Democratic Party presidential primaries, 2016 885 2016 NCAA Men's Division I Basketball Tournament 1006 The Jungle Book (2016 film) 1190
10 2016 in sports 833 2016 Under-19 Cricket World Cup 795 RuPaul's Drag Race (season 8) 989 RuPaul's Drag Race (season 8) 1155
11 Flint water crisis 831 A.J. Styles 716 Beverly Gray 960 List of people named in the Panama Papers 1064
12 January 2016 United States blizzard 824 Lech Wałęsa 705 Democratic Party presidential primaries, 2016 893 2016 Nagorno-Karabakh clashes 1039
13 The Revenant (2015 film) 824 2015–16 Zika virus epidemic 692 Forcade 883 Views (album) 981
14 New Year's Eve sexual assaults in Germany 812 Antonin Scalia 670 Fleet of the Royal Canadian Navy 812 Batman v Superman: Dawn of Justice 862
15 Jeanette Aw 767 Super Bowl 50 663 Confederate States Army 795 Big Brother Canada (season 4) 787
16 Computational anatomy 765 Athletics at the 2016 Summer Olympics – Qualification 653 Jordan 784 2016 Indian Premier League 782
17 Henry Jasper Redfern 747 Forcade 641 WrestleMania 32 771 2016 NBA Playoffs 758
18 The Life of Pablo 726 George Bernard Shaw 637 Asia's Next Top Model (cycle 4) 760 The Voice (U.S. season 10) 702
19 Celebrity Big Brother 17 725 Beverly Gray 625 Donald J Drumpf 735 Democratic Party presidential primaries, 2016 593
20 2016 European Men's Handball Championship 694 Donald Trump 622 2016 ICC World Twenty20 717 2016 in Philippine television 585
rank May June July August
1 EgyptAir Flight 804 1626 2016 Orlando nightclub shooting 4430 2016 Nice attack 2764 Great Britain at the 2016 Summer Olympics 1578
2 Bailando 2015 1507 Bailando 2015 1597 2016 Turkish coup d'état attempt 1937 2016 Summer Olympics medal table 1500
3 Deaths in 2016 1411 Deaths in 2016 1525 2016 shooting of Dallas police officers 1756 United States at the 2016 Summer Olympics 1444
4 2016 French Open 1082 United Kingdom European Union membership referendum, 2016 1506 Deaths in 2016 1747 Chronological summary of the 2016 Summer Olympics 1434
5 Captain America: Civil War 1077 Cary Grant 1460 2016 Munich shooting 1720 Deaths in 2016 1398
6 Republican Party presidential primaries, 2016 1023 Muhammad Ali 1322 Pokémon Go 1428 Vincent van Gogh 1095
7 Panama Papers 1000 Copa América Centenario 1038 Big Brother 18 (U.S.) 1113 Canada at the 2016 Summer Olympics 998
8 X-Men: Apocalypse 996 Jo Cox 1005 2016 Pacific hurricane season 1081 Russia at the 2016 Summer Olympics 967
9 Views (album) 959 2016 FIVB Volleyball World Grand Prix 927 Theresa May 1055 Celebrity Big Brother 18 908
10 Donald Trump 923 Independence Day: Resurgence 922 Metropolitan Stores 929 2016 Pacific typhoon season 895
11 List of countries by GDP (nominal) 878 Omar Mateen 834 Vincent van Gogh 858 Miss Universe 2016 891
12 Nuestra Belleza Latina 2016 821 People v. Turner 817 Beverly Gray 842 Suicide Squad (film) 847
13 2016 Fort McMurray wildfire 738 The Conjuring 2 767 Andrea Leadsom 814 India at the 2016 Summer Olympics 842
14 List of Donald Trump presidential campaign endorsements, 2016 696 Christina Grimmie 754 Australian federal election, 2016 799 France at the 2016 Summer Olympics 838
15 Tamil Nadu Legislative Assembly election, 2016 679 2016 Atatürk Airport attack 721 2016 Orlando nightclub shooting 745 SummerSlam (2016) 830
16 2016 Indian Premier League 678 UEFA Euro 2016 statistics 695 Conservative Party (UK) leadership election, 2016 740 Beacham Theatre 821
17 2016–17 United States network television schedule 645 Athletics at the 2016 Summer Olympics – Qualification 691 List of 2016–17 NBA season transactions 731 2016 Paul Hunter Classic 810
18 2016 French Open – Men's Singles 642 Dol-de-Bretagne's Cathedral (Cathédrale Saint-Samson de Dol) 675 List of terrorist incidents in July 2016 717 China at the 2016 Summer Olympics 807
19 Britain's Got Talent (series 10) 639 Results of the United Kingdom European Union membership referendum, 2016 673 Ghostbusters (2016 film) 705 Sausage Party 802
20 Payback (2016) 610 2016 Riga Masters 671 Shooting of Philando Castile 695 Jill Stein 785
rank September October November December 1-15th
1 Deaths in 2016 1377 Newspaper endorsements in the United States presidential election, 2016 1525 Protests against Donald Trump 1832 Bigg Boss 10 830
2 Great Britain at the 2016 Summer Paralympics 1293 Donald Trump sexual misconduct allegations 1493 United States presidential election, 2016 1749 Fake news website 747
3 2016 New York and New Jersey bombings 1123 Hurricane Matthew 1424 Donald Trump 1475 Deaths in 2016 727
4 List of Hillary Clinton presidential campaign endorsements, 2016 1014 Deaths in 2016 1424 Survivor Series (2016) 1446 Aleppo offensive 678
5 RuPaul's Drag Race: All Stars (season 2) 929 Statewide opinion polling for the United States presidential election, 2016 1371 Deaths in 2016 1420 2016 United States election interference by Russia 641
6 2016 Pacific typhoon season 923 2016 Atlantic hurricane season 1158 El Coyote (character) 1240 2016 Oakland warehouse fire 638
7 Archdeacon of Kells 890 Donald Trump 1151 Cabinet of Donald Trump 1217 2016 Scottish Open 581
8 2016 Atlantic hurricane season 884 Manchán of Mohill 1145 Manchán of Mohill 1206 Donald Trump 565
9 Birds in the Trap Sing McKnight 746 2016 clown sightings 1089 2016 UK Championship 1161 Pakistan International Airlines Flight 661 538
10 Statewide opinion polling for the United States presidential election, 2016 724 El Coyote (character) 1017 2016 Northern Ireland Open 955 LaMia Flight 2933 529
11 America's Got Talent (season 11) 687 2016 World Series 952 Miss Universe 2016 869 2017 German Masters 527
12 2016 FIFA Futsal World Cup 686 List of Hillary Clinton presidential campaign endorsements, 2016 950 Fantastic Beasts and Where to Find Them (film) 835 4 Your Eyez Only 498
13 List of Donald Trump presidential campaign endorsements, 2016 684 2016 Pacific typhoon season 935 Indian 500 and 1000 rupee note demonetisation 817 John Glenn 494
14 Art Deco 661 RuPaul's Drag Race: All Stars (season 2) 794 Steve Bannon 815 List of awards and nominations received by Netflix 483
15 WWE Clash of Champions 651 2016 English Open (snooker) 777 Bigg Boss 10 805 Palmyra 479
16 Turkish military intervention in Syria 643 Barrackpore Mutiny of 1824 761 The Voice (U.S. season 11) 792 en:United States presidential election, 2016 474
17 Madeline (video game series) 628 List of coupled cousins 743 Garage rock 782 en:List of ships built by Fincantieri 461
18 Miss Universe 2016 587 Miss Earth 2016 739 Death and state funeral of Fidel Castro 772 2016 Mnet Asian Music Awards 445
19 Brazil at the 2016 Summer Paralympics 577 The Voice (U.S. season 11) 731 World Chess Championship 2016 762 Rex Tillerson 444
20 2016 Pacific hurricane season 565 Strictly Come Dancing (series 14) 723 LaMia Flight 2933 705 Pizzagate 432

References

edit