Apologize if this is not the appropriate forum for the question.
I am trying to access the content of Category pages from either the dump or APIs.
For example, I would like to get a complete list of rivers
http://en.wikipedia.org/wiki/Category:Lists_of_rivers
The API does provide the content but it is throttled
https://en.wikipedia.org/w/api.php?action=query&list=categorymembers&...
Therefore I would like to find the content in the dumps. However, I cannot find this information in the dumps. I have looked inside
http://dumps.wikimedia.org/enwiki/latest/enwiki-latest-pages-articles.xml
and find nothing there. The pages are referenced in the the page SQL dumps
http://dumps.wikimedia.org/enwiki/latest/enwiki-latest-page.sql.gz
Do any of the dumps contain the category page content?
thank you