Rank Wikipedia articles by their number of references

Results
Query

Viewing the first 20 of total 1,296,119 rows

url	title	reference_count
https://pt.m.wikipedia.org/wiki/Lista_de_n%C3%A3o_te%C3%ADstas	NULL	1255
https://en.wikipedia.org/wiki/Wikipedia	Wikipedia	1149
https://id.wikipedia.org/wiki/Iosif_Stalin	Josef Stalin	901
https://ru.wikipedia.org/wiki/%D0%93%D0%B0%D0%BD%D0%B0	Гана	824
https://en.wikipedia.org/wiki/United_States_Congressman	United States House of Representatives	801
https://en.wikipedia.org/wiki/List_of_Japanese_role-playing_game_franchises	List of best-selling Japanese role-playing game franchises	800
https://sv.wikipedia.org/wiki/Avlidna_2018	Avlidna 2018	782
https://sv.m.wikipedia.org/wiki/Avlidna_2018	NULL	777
https://ja.m.wikipedia.org/wiki/%E7%89%B9%E5%88%A5%E6%94%BB%E6%92%83%E9%9A%8A	NULL	773
https://ko.wikipedia.org/wiki/%EA%B5%AD%EC%A0%95%EC%9B%90_%EC%97%AC%EB%A1%A0_%EC%A1%B0%EC%9E%91_%EC%...	국가정보원 여론 조작 사건	767
https://en.wikipedia.org/wiki/Hinduism	Hinduism	752
https://de.m.wikipedia.org/wiki/Islamischer_Staat_(Organisation)	NULL	744
https://en.wikipedia.org/wiki/List_of_fairy_tales	List of fairy tales	738
https://fr.m.wikipedia.org/wiki/%C3%89tat_islamique_(organisation)	NULL	735
https://en.m.wikipedia.org/wiki/Deaths_in_January_2018	NULL	724
https://es.wikipedia.org/wiki/Anexo:Telenovelas_de_Televisa	Anexo:Telenovelas de Televisa	689
https://ja.wikipedia.org/wiki/%E3%82%A6%E3%82%A3%E3%83%AA%E3%82%A2%E3%83%A0%E3%83%BB%E3%82%B0%E3%83%...	ウィリアム・グラッドストン	689
https://en.m.wikipedia.org/wiki/Roman_empire	NULL	679
https://ru.wikipedia.org/wiki/%D0%9D%D0%A2%D0%92	НТВ	677
https://en.m.wikipedia.org/wiki/Bobby_Fischer	NULL	669

Viewing the first 20 of total 1,296,119 rows

Download Full Results

Query

select 
	url, 
	css_text_first(content, 'h1#firstHeading') as title,
	cardinality(css_text(content, 'ol.references li')) as reference_count
from 
	pages
where 
    url_domain = 'wikipedia.org' 
    	and
	url like '%/wiki/%'
order by reference_count desc

Load in editor

Data scanned 30.64 GB

Results 140.05 MB (1,296,119 rows)

Rank Wikipedia articles by their number of references

Turn the web into a database!