Short list of files and fields

table familyname:

• name
• language: the language the name belongs to (“Dupont” is French, “Simpson” English)
• frequency: how many people with that name have a Wikipedia entry (by country)

table givenname:

• name
• gender: Mary is female, John male
• language: the language the name belongs to (“Jean” is French, “John” English)
• frequency: how many people with that name have a Wikipedia entry (by country)

table person:

• wiki_id
• familyname
• givenname
• gender
• email
• occupation
• birth_date
• birth_country
• birth_continent
• company
• street
• city
• zip
• region
• region_abbr
• country
• continent
• phone_code
• phone
• description: summary of the Wikipedia page
• picture
• picture_url
• picture_thumb
• picture_url_local
• picture_thumb_local

table company:

• wiki_id
• name
• industry
• people: number of people
• country
• continent
• web: web site
• description: summary of the Wikipedia page
• logo
• logo_url
• logo_thumb
• logo_url_local
• logo_thumb_local

table product:

• wiki_id
• type: movie, video game, album or book
• title
• author
• date
• language
• country
• continent
• remark
• description: summary of the Wikipedia page
• picture: the cover
• picture_url
• picture_thumb
• picture_url_local
• picture_thumb_local

table city:

• wiki_id
• name
• zipcode
• region
• country
• continent
• latitude
• longitude
• people: number of people
• area
• web: web site
• mayor
• description: summary of the Wikipedia page

table country:

• wiki_id
• name
• continent
• capital
• latitude
• longitude
• currency
• people: number of people
• area
• description: summary of the Wikipedia page
• picture: the flag
• picture_url
• picture_thumb
• picture_url_local
• picture_thumb_local
• imagemap: a location map
• imagemap_url
• imagemap_thumb
• imagemap_url_local
• imagemap_thumb_local

table currency:

• name
• code

table lake:

• wiki_id
• name
• country
• continent
• latitude
• longitude
• description: summary of the Wikipedia page
• caption
• picture
• picture_url
• picture_thumb
• picture_url_local
• picture_thumb_local

table building:

• wiki_id
• name
• country
• continent
• latitude
• longitude
• description: summary of the Wikipedia page
• caption
• picture
• picture_url
• picture_thumb
• picture_url_local
• picture_thumb_local

table address:

• street
• city
• zipcode
• region: region/state
• abbr: region/state abbrevation
• country
• continent
• complete: complete address on one line

table unique_email:

• email
• givenname
• familyname
• language: the language the name belongs to (“Jean” is French, “John” English)
• gender: Mary is female, John male

table hobby:

• hobby
• type: sport…

table occupation:

• occupation

table language:

• language
• iso
• iso3
• speakers: number of speakers

table western_language:

• language
• iso

table car:

• wiki_id
• model
• class
• date
• manufacturer
• length
• height
• width
• description: summary of the Wikipedia page
• picture
• picture_url
• picture_thumb
• picture_url_local
• picture_thumb_local

table battle:

• wiki_id
• name
• conflict
• date
• outcome
• abstract
• abstract_html
• content: the whole wikipedia article
• content_html: the whole wikipedia article

table fable:

• wiki_id
• title
• author
• abstract
• abstract_html
• content: the whole wikipedia article
• content_html: the whole wikipedia article