Query Library

What is the average size of a Wikipedia article?

Viewing the first 1 of total 1 rows

Download Full Results
average_word_count
958.72026256848

Viewing the first 20 of total 1 rows

Download Full Results
Query
select
    avg(cardinality(words(css_text_first(content, '#content')))) as average_word_count
from 
    pages
where 
    url_domain = 'wikipedia.org' 
		and
	url like '%/wiki/%'
Load in editor
Data scanned30.64 GB
Results9 B (1 rows)

Turn the web into a database!

Mixnode is a fast, flexible and massively scalable platform to extract and analyze data from the web.

or contact us at hi@mixnode.com