Documentation

This web site offers random items extracted from Wikipedia. These items can be used to fill-in a mock database or web site, or for testing purpose.

Description

The data are organized into tables that model real world objects, like a user profile (with name, address, e-mail, gender, etc.), a company (name, logo, country, web site url, number of employees, etc.), a battle (name, date, description, etc.), and so on.

Fields contain either short information (name, date, address, author, latitude, longitude,…), url to pictures hosted on Wikimedia servers (photos, maps, flags…), or longer texts like whole Wikipedia pages in plain text (wiki syntax) or html format.

The data are extracted from Wikipedia, so they are (mostly) consistent:

• Some data are entirely extracted from the Wikipedia data, like companies, countries, cities, lakes, etc. This means that the entire row contains real data: the name, the picture (photo, logo, flag), the location (latitude, longitude), the population, etc.
• In other cases, some data are consistent and real (the name of a person will match with their gender, country of birth, picture, etc.) while other are faked (e-mails, addresses, phone numbers, etc.).

For some tables, a Wikipedia ID is provided, so you can link to the original Wikipedia page.

List of tables

Available tables:

• address: street, city, zip code, state, country, continent…
• language: name, ISO code (2 and 3 characters), number of speakers…
• battle: name, wiki ID, date, outcome, summary (text and html), complete Wikipedia page (text and html)…
• building: name, wiki ID, country, latitude and longitude, photo, description
• car: model, wiki ID, date, photo, dimensions, description…
• city: name, wiki ID, zip code, country, state/region, number of people, area, latitude and longitude, web site, mayor, description…
• company: name, wiki ID, country, number of employees, industry, web site, logo, description…
• country: name, wiki ID, capital, latitude and longitude, currency, location map, flag, description
• currency: name and code
• fable: title, wiki ID, author, summary (text and html), complete Wikipedia page (text and html)
• family_name: name, language (Simpson sounds more English and Dupont more French…), frequency (number of people of that name that have a Wikipedia entry (for English, only a subset of Wikipedia was considered)),
• given_name: name, gender, language, frequency
• hobby: name and type (sport…)
• lake: name, wiki ID, latitude and longitude, photo, description, continent…
• western_language: name and ISO code
• occupation: name of the occupation
• person: first and last name, wiki ID, gender, picture, email, occupation, birth date, company, address, email, etc.
• product: title, wiki ID, type (book, album, video game, movie…), date, country, author, language, cover picture, description
• unique_email: first and last name, email, language (of the name), gender (of the first name)

You can download the data at github.

More documention

Please refer to the pages:

• list of tables and all their fields,
• list with additional details (number of rows, number of unique values, number of null values, type (string, integer, float), ranges, etc.).

Disclaimer

These data are designed to be used as fill-in data, for mock databases and websites or to test a setup with example data. Even if they are extracted from Wikipedia and so represent some state of the real world, they are not meant as a source of information. Some of these data are plainly incorrect, either because they have been faked (addresses, e-mails, etc.) or because the information found on Wikipedia was not correct or it has been badly retrieved.