Rank Wikipedia articles by length

Results
Query

Viewing the first 20 of total 86,740 rows

word_count	title	url
66263	Glossary of baseball	https://en.wikipedia.org/wiki/Opposite_field
53638	Timeline of Baltimore	https://en.wikipedia.org/wiki/Timeline_of_Baltimore
46818	Information and communication technologies for development	https://en.wikipedia.org/wiki/ICT4D
44796	Joint Comprehensive Plan of Action	https://en.wikipedia.org/wiki/JCPOA
42272	Kashmir conflict	https://en.wikipedia.org/wiki/Kashmir_dispute
40640	List of minor DC Comics characters	https://en.wikipedia.org/wiki/Alura
39867	Political positions of Hillary Clinton	https://en.wikipedia.org/wiki/Political_positions_of_Hillary_Clinton
39638	List of unsolved deaths	https://en.wikipedia.org/wiki/List_of_unsolved_deaths
39200	List of Fables characters	https://en.wikipedia.org/wiki/List_of_characters_in_Fables
39019	Texas Longhorns men's basketball	https://en.wikipedia.org/wiki/Texas_Longhorns_men%27s_basketball
38845	Women in Islam	https://en.wikipedia.org/wiki/Islam_and_women
38743	Soil	https://en.wikipedia.org/wiki/Soil_water
38621	List of animated works with LGBT characters	https://en.wikipedia.org/wiki/List_of_LGBT_characters_in_animation
38286	List of school shootings in the United States	https://en.wikipedia.org/wiki/List_of_school_shootings_in_the_United_States
37619	Miscegenation	https://en.wikipedia.org/wiki/Interracial_relationship
36496	Portland, Oregon	https://en.wikipedia.org/wiki/Little_Beirut
36287	World War I	https://en.wikipedia.org/wiki/First_world_war
36242	Subprime mortgage crisis	https://en.wikipedia.org/wiki/2007_Subprime_mortgage_financial_crisis
36241	List of Madagascar (franchise) characters	https://en.wikipedia.org/wiki/List_of_Madagascar_%28franchise%29_characters
35769	List of fairy tales	https://en.wikipedia.org/wiki/List_of_fairy_tales

Viewing the first 20 of total 86,740 rows

Download Full Results

Query

select
	cardinality(words(css_text_first(content, '#content'))) as word_count,
	css_text_first(content, 'h1#firstHeading') as title,
	url
from 
	pages
where 
	url_domain = 'wikipedia.org' 
		and
	url like 'https://en.wikipedia.org/wiki/%'
		and 
	url not like 'https://en.wikipedia.org/wiki/%/%'
		and 
	url not like 'https://en.wikipedia.org/wiki/Talk:%'
		and 
	url not like 'https://en.wikipedia.org/wiki/User:%'
		and 
	url not like 'https://en.wikipedia.org/wiki/User_talk:%'
		and 
	url not like 'https://en.wikipedia.org/wiki/Wikipedia:%'
order by word_count desc

Load in editor

Data scanned 30.65 GB

Results 7.22 MB (86,740 rows)

Rank Wikipedia articles by length

Turn the web into a database!