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.
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:
For some tables, a Wikipedia ID is provided, so you can link to the original Wikipedia page.
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.
Please refer to the pages:
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.