Jump to content

Research:Top edited articles in 2014

From Meta, a Wikimedia project coordination wiki
Duration:  2014-12 – 2014-12
This page documents a completed research project.

I got a request for the most edited articles in 2014.


Methods

[edit]

Creating the monthly edits table:

SELECT
    LEFT(rev_timestamp, 6) AS month,
    rev_page AS page_id,
    COUNT(*) AS edits
FROM revision
WHERE rev_timestamp BETWEEN "2014" AND "2015"
GROUP BY month, page_id
ORDER BY month ASC, edits DESC;

Here's the aggregation up to a yearly total:

SELECT
    "2014" AS year,
    page_id,
    SUM(edits) AS edits
FROM staging.monthly_page_edits
GROUP BY page_id;

Results

[edit]

Here's the top for the whole year.

Title Edits
en:Deaths_in_2014 19324
en:Malaysia_Airlines_Flight_370 10166
en:Japanese_dissidence_during_the_Shōwa_period 8101
en:Ebola_virus_epidemic_in_West_Africa 7644
en:Islamic_State_of_Iraq_and_the_Levant 7312
en:2014_Israel–Gaza_conflict 6485
en:Shooting_of_Michael_Brown 5419
en:Malaysia_Airlines_Flight_17 5147
en:2014_Pacific_typhoon_season 4954
en:List_of_works_by_Eugène_Guillaume 4229



Here's the top by month since it tends to fluctuate (see also full list).

Month Title Edits
January en:Deaths_in_2014 1423
en:Japanese_dissidence_during_the_Shōwa_period 1307
en:2013–14_NFL_playoffs 1279
en:Fort_Lee_lane_closure_scandal 1187
en:2014_Australian_Open 1096
en:Euromaidan 978
en:2014_Australian_Open_–_Men's_Singles 888
en:List_of_works_by_Eugène_Guillaume 857
en:The_Yale_Record 849
en:2013–14_North_American_cold_wave 791
February en:2014_Ukrainian_revolution 1606
en:Deaths_in_2014 1556
en:Philip_Seymour_Hoffman 1425
en:List_of_works_by_Eugène_Guillaume 1345
en:2014_Venezuelan_protests 1078
en:Japanese_dissidence_during_the_Shōwa_period 965
en:Lizabeth_Scott 893
en:Canada_at_the_2014_Winter_Olympics 840
en:Asia's_Next_Top_Model_(cycle_2) 816
en:Marius_(giraffe) 776
March en:Malaysia_Airlines_Flight_370 7667
en:2014_Crimean_crisis 2943
en:Deaths_in_2014 2183
en:2014_Russian_military_intervention_in_Ukraine 1975
en:2014_ICC_World_Twenty20 1581
en:Crimean_status_referendum,_2014 1390
en:List_of_works_by_Eugène_Guillaume 1078
en:Asia's_Next_Top_Model_(cycle_2) 918
en:The_Voice_(U.S._season_6) 865
en:St._Mary's_College_of_Maryland 834
April en:Deaths_in_2014 2074
en:Malaysia_Airlines_Flight_370 1201
en:Bundy_standoff 1117
en:Donetsk_People's_Republic 1075
en:2014_pro-Russian_unrest_in_Ukraine 1032
en:St._Mary's_College_of_Maryland 996
en:Sgt._Pepper's_Lonely_Hearts_Club_Band 973
en:Heartbleed 961
en:List_of_works_by_Eugène_Guillaume 944
en:Sinking_of_the_MV_Sewol 826
May en:Deaths_in_2014 2100
en:2014_Isla_Vista_killings 1389
en:X-Men:_Days_of_Future_Past 1245
en:Godzilla_(2014_film) 1048
en:Japanese_dissidence_during_the_Shōwa_period 962
en:2014_pro-Russian_unrest_in_Ukraine 936
en:2014_Indian_Premier_League 919
en:2014_FIFA_World_Cup_squads 829
en:2014_IIHF_World_Championship 814
en:2014_French_Open 784
June en:Deaths_in_2014 1829
en:Japanese_dissidence_during_the_Shōwa_period 1598
en:2014_FIFA_World_Cup 1414
en:Money_in_the_Bank_(2014) 1228
en:Mohammad_Amin 1194
en:Northern_Iraq_offensive_(June_2014) 1137
en:Islamic_State_of_Iraq_and_the_Levant 1089
en:Andhra_Pradesh 854
en:2014_Wimbledon_Championships 766
en:List_of_U.S._states_by_GDP_per_capita 750
July en:Malaysia_Airlines_Flight_17 4001
en:2014_Israel–Gaza_conflict 3396
en:Japanese_dissidence_during_the_Shōwa_period 2176
en:Deaths_in_2014 1841
en:Mohammad_Amin 1451
en:2014_Pacific_typhoon_season 1194
en:Military_production_during_World_War_II 1018
en:Islamic_State_of_Iraq_and_the_Levant 955
en:Brazil_v_Germany_(2014_FIFA_World_Cup) 944
en:India_at_the_2014_Commonwealth_Games 915
July en:Shooting_of_Michael_Brown 3129
en:2014_Israel–Gaza_conflict 1906
en:Boko_Haram 1825
en:Ebola_virus_epidemic_in_West_Africa 1805
en:Robin_Williams 1603
en:Deaths_in_2014 1579
en:Ice_Bucket_Challenge 1296
en:2014_Pacific_hurricane_season 1154
en:SummerSlam_(2014) 1148
en:Islamic_State_of_Iraq_and_the_Levant 1097
August en:Ebola_virus_epidemic_in_West_Africa 1644
en:India_at_the_2014_Asian_Games 1404
en:Deaths_in_2014 1323
en:Charles_Wesley_Powell 1215
en:Islamic_State_of_Iraq_and_the_Levant 1033
en:Gamergate_controversy 1031
en:2014_FIVB_Volleyball_Men's_World_Championship 1007
en:FIFA_15 997
en:Scottish_independence_referendum,_2014 944
en:List_of_music_students_by_teacher:_A_to_M 940
October en:2014_Hong_Kong_protests 2512
en:Ebola_virus_epidemic_in_West_Africa 2199
en:2014_shootings_at_Parliament_Hill,_Ottawa 1932
en:Ebola_virus_cases_in_the_United_States 1586
en:Deaths_in_2014 1394
en:Charles_Wesley_Powell 1143
en:Gamergate_controversy 1095
en:Ebola_virus_disease 1072
en:Islamic_State_of_Iraq_and_the_Levant 994
en:America's_Next_Top_Model_(cycle_21) 912
November en:Deaths_in_2014 1325
en:Islamic_State_of_Iraq_and_the_Levant 1207
en:Survivor_Series_(2014) 1144
en:Interstellar_(film) 985
en:America's_Next_Top_Model_(cycle_21) 948
en:Dancing_with_the_Stars_(U.S._season_19) 940
en:Electronic_cigarette 900
en:Ebola_virus_epidemic_in_West_Africa 891
en:The_X_Factor_(UK_series_11) 847
en:2014_Hong_Kong_protests 787
December
(incomplete)
en:2014_Sydney_hostage_crisis 1538
en:Citizen_Kane 726
en:List_of_NHS_trusts 712
en:Deaths_in_2014 697
en:Shooting_of_Michael_Brown 680
en:TLC:_Tables,_Ladders_and_Chairs_(2014) 599
en:List_of_music_students_by_teacher:_A_to_M 594
en:Senate_Intelligence_Committee_report_on_CIA_torture 554
en:The_Pinkprint 535
en:Death_of_Eric_Garner 516