Skip to content

Instantly share code, notes, and snippets.

{'References': 186,
'External links': 177,
'Notes': 132,
'Early life': 98,
'Legacy': 82,
'See also': 76,
'Bibliography': 69,
'Further reading': 60,
'Sources': 43,
'Death': 34,
{'References': 456,
'External links': 326,
'Notes': 234,
'Early life': 209,
'See also': 161,
'Bibliography': 134,
'Further reading': 118,
'Legacy': 108,
'Personal life': 53,
'Death': 51,
Note: these are 3106 section headers that appear only once among all GA-class articles on English Wikipedia.
['Football career',
'Act of Rancagua',
'Le Van Duyet',
'Albert A. Murphree',
'Electoral history',
'English barrister',
'The road to Waterloo',
'World War II and Quit India',
page_info['title'] page_info['page_id'] ntd_c_historiographical ntd_c_popular_history ntd_c_adj_historian ntd_c_ealiest_works ntd_c_academic_interest ntd_c_earliest_histories ntd_c_other_hand ntd_c_bias ntd_c_academic ntd_c_popular_historian ntd_c_biographer ntd_c_probably ntd_c_historiography ntd_c_historian ntd_c_possibly ntd_c_according ntd_c_one_view
Guy Bradley 14984826 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1 0
Golding Bird 8660239 0 0 0 0 0 0 2 0 0 0 0 1 0 0 0 4 0
RamÌ_n Emeterio Betances 2735721 0 0 0 0 0 0 1 0 0 0 0 1 0 9 1 6 0
Fanny Imlay 11535913 0 0 0 0 0 0 1 0 0 0 1 3 0 0 0 7 0
Daniel Boone 1428575 0 0 0 0 0 0 0 0 0 0 0 1 0 9 0 11 0
George Washington Dixon 3479965 0 0 0 0 0 0 0 0 0 0 0 2 0 0 3 1 0
Henry Cornelius Burnett 6697460 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Georg Cantor 104141 0 0 0 0 0 0 0 1 0 0 0 0 4 1 0 1 0
Georges Bizet 1790785 0 0 0 1 0 0 0 0 0 0 0 1 0 0 0 5 0
page_info['title'] page_info['page_id'] ntd_c_historiographical ntd_c_popular_history ntd_c_adj_historian ntd_c_ealiest_works ntd_c_academic_interest ntd_c_earliest_histories ntd_c_other_hand ntd_c_bias ntd_c_academic ntd_c_popular_historian ntd_c_biographer ntd_c_probably ntd_c_historiography ntd_c_historian ntd_c_possibly ntd_c_according ntd_c_one_view
Thomas Bewick 10699920 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0
John Breathitt 6404606 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
BahÌÁ'u'llÌÁh 1050359 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4 0
Oliver Bosbyshell 37156804 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0
Henry Ward Beecher 7025557 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 0
Charles Boycott 2917086 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 11 0
Dan Brouthers 6247136 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Black Widows of Liverpool 21820732 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0
Marion L. Brittain 11548991 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
We can make this file beautiful and searchable if this error is corrected: Unclosed quoted field in line 4.
page_info['title'],page_info['page_id'],ah_current,ah_actions,ah_article_history,ah_assessment_list,ah_assessment_count,ah_latest_action_age,ah_oldest_action_age,ah_topic
Guy Bradley,14984826,FA,"[{u'date': u'2010-07-15 15:50:00', u'type': u'GAN', u'result': u'listed'}, {u'date': u'2010-07-27 16:04:00', u'type': u'FAC', u'result': u'promoted'}, {u'date': u'2011-03-06 00:00:00', u'type': u'WPR', u'result': u'Maindate'}]",3,"[u'FA', u'FA', u'FA', u'FA']",4,74754949.81,94915549.81,History
Golding Bird,8660239,FA,"[{u'date': u'2011-08-03 02:24:00', u'type': u'GAN', u'result': u'listed'}, {u'date': u'2011-10-22 23:41:00', u'type': u'PR', u'result': u'reviewed'}, {u'date': u'2012-03-13 21:24:00', u'type': u'FAC', u'result': u'promoted'}]",3,"[u'FA', u'FA', u'FA']",3,42450709.81,61786309.81,Natsci
RamÌ_n Emeterio Betances,2735721,FA,"[{u'date': u'2007-04-07 21:30:00', u'type': u'WPR', u'result': None}, {u'date': u'2007-08-04 00:20:00', u'type': u'GAN', u'result': u'listed'}, {u'date': u'2007-08-16 17:06:00', u'type'
We can make this file beautiful and searchable if this error is corrected: It looks like row 6 should actually have 10 columns, instead of 9. in line 5.
page_info['title'],page_info['page_id'],ah_current,ah_actions,ah_article_history,ah_assessment_list,ah_assessment_count,ah_latest_action_age,ah_oldest_action_age,ah_topic
Thomas Bewick,10699920,GA,"[{u'date': u'2013-06-23 15:15:00', u'type': u'GAN', u'result': u'listed'}]",1,"[u'GA', u'GA', u'GA']",3,4635869.922,4635869.922,Biology and medicine
John Breathitt,6404606,GA,"[{u'date': u'2009-02-15 18:33:00', u'type': u'GAN', u'result': u'listed'}, {u'date': u'2011-01-18 03:46:00', u'type': u'GTC', u'result': u'promoted'}]",2,"[u'GA', u'GA', u'GA']",3,81314010.63,141913590.6,History
BahÌÁ'u'llÌÁh,1050359,GA,"[{u'date': u'2012-06-06 01:22:00', u'type': u'GAN', u'result': u'listed'}]",1,"[u'GA', u'GA', u'GA', u'GA']",4,37690649.89,37690649.89,Philrelig
Oliver Bosbyshell,37156804,GA,"[{u'date': u'2012-10-08 23:34:00', u'type': u'GAN', u'result': u'listed'}]",1,"[u'GA', u'GA', u'GA', u'GA', u'GA', u'GA']",6,26897153.33,26897153.33,Politics and government
Henry Ward Beecher,7025557,NO,[],0,"[u'GA', u'GA', u'GA']",3,0,
@slaporte
slaporte / GA-cite.csv
Created August 30, 2013 20:52
GA-cite.csv
We can't make this file beautiful and searchable because it's too large.
page_info['title'],page_info['page_id'],ntd_cite_book,ntd_cite_cl,ntd_cite_count,ntd_cite_episode,ntd_cite_journal,ntd_cite_news,ntd_cite_newsgroup,ntd_cite_patent,ntd_cite_pressrelease,ntd_cite_report,ntd_cite_video,ntd_cite_videogame,ntd_cite_web,ntd_ref_count,ntd_ref_needed_span_count,ntd_ref_text_count,ntd_reflist_count,custom_cite_all,custom_years_list,custom_yearsdetected,custom_tmpl_list,custom_pbl_list,custom_use_count
Thomas Bewick,10699920,10,20,52,0,0,2,0,0,0,0,0,0,8,76,0,52,2,52,"[2006, 2006, 2006, 2006, 2006, 2004, 2006, 2006, 2006, 1826, 2006, 2011, 2006, 2006, 1947, 2006, 2010, 2004, 2006, 1818, 2006, 2006, 2006, 2006, 2006, 2006, 2010, 2010, 2006, 2010, 2006, 2010, 2006, 1947, 2006, 2006, 2009, 2010, 2013, 1784, 1776, 1999, 2010, 2009, 1947, 2006]",46,"[u'None', u'None', u'None', u'None', u'None', u'Cite web', u'None', u'None', u'None', u'None', u'None', u'None', u'None', u'None', u'Cite web', u'Cite web', u'None', u'None', u'Cite web', u'None', u'Citation', u'Cite web', u'None', u'Cite book',
We can't make this file beautiful and searchable because it's too large.
page_info['title'],page_info['page_id'],ntd_cite_book,ntd_cite_cl,ntd_cite_count,ntd_cite_episode,ntd_cite_journal,ntd_cite_news,ntd_cite_newsgroup,ntd_cite_patent,ntd_cite_pressrelease,ntd_cite_report,ntd_cite_video,ntd_cite_videogame,ntd_cite_web,ntd_ref_count,ntd_ref_needed_span_count,ntd_ref_text_count,ntd_reflist_count,custom_cite_all,custom_years_list,custom_yearsdetected,custom_tmpl_list,custom_pbl_list,custom_use_count
Guy Bradley,14984826,0,0,49,0,0,0,0,0,0,0,0,0,0,59,0,49,1,49,"[1909, 1990, 1909, 1905]",4,"[u'None', u'None', u'None', u'None', u'None', u'None', u'None', u'None', u'None', u'None', u'None', u'None', u'None', u'None', u'None', u'None', u'None', u'None', u'None', u'None', u'None', u'None', u'None', u'None', u'None', u'None', u'None', u'None', u'None', u'None', u'None', u'None', u'None', u'None', u'None', u'None', u'None', u'None', u'None', u'None', u'None', u'None', u'None', u'None', u'None', u'None', u'None', u'None', u'None']","[u'None found', u'None found', u'None found', u'None found
[u'Martin W. Bates',
u'Joseph Sydney Yorke',
u'Princess Eugenia Maximilianovna of Leuchtenberg',
u'Lafcadio Hearn',
u'John Seybert',
u'Friedrich Nietzsche',
u'Nikola Tesla',
u'Joseph Standing',
u'Daniel Sickles',
u'Thomas Forsaith',