Skip to content
Alex Simoes edited this page Jan 25, 2017 · 8 revisions

people.tsv

Column Descriptions

Column ID Description
curid Current wikipedia ID from last edit (not being used in pantheon)
wd_id Wikidata ID of Person (unique, this will be used in the pantheon DB since they're constant)
name Person's name
occupation Person's occupation (all caps, corresponds to Occupations)
prob_ratio Measure of accuracy of occupation prediction (0 means trained)
gender True = Male, False = Female
twitter twitter handle
alive Boolean, whether alive or not
l Number of wikipedia language editions
hpi Human popularity index (see http://www.nature.com/articles/sdata201575)
birthyear Person's year of birth
bplace_geonameid Unique ID of Person's birth city (corresponds to Places)
geacron_name Place of birth according to historical borders
deathyear Person's year of death
dplace_geonameid Unique ID of Person's death place (corresponds to Places)

Sample Rows

curid wd_id name occupation prob_ratio gender twitter alive l hpi birthyear bplace_name bplace_curid bplace_lat bplace_lon bplace_geonameid geacron_name deathyear dplace_name dplace_curid dplace_lat dplace_lon dplace_geonameid name_common region continent least_developed
437554 Q447609 Trevor Berbick BOXER 3.87911635126 True False 18 16.8645278495 1954.0 Port Antonio 3104488.0 18.175701 1.29666667 2455290 2006.0 Port Antonio 3104488.0 18.1666666667 -76.45 3489005.0 Mali Western Africa Africa True
744956 Q503809 Jean de Dunois NOBLEMAN 1.02898758275 True False 17 19.5089595187 1402.0 France 5843419.0 47.0 2.0 5039071 France 1468.0 L'Haÿ-les-Roses 48.7791666667 2.33722222222 2998632.0 France Western Europe Europe False
770670 Q311733 Titus Pomponius Atticus RELIGIOUS FIGURE 1.48199374827 True False 28 20.7979016038 -110.0 Rome 25458.0 41.9 12.5 3169070 Rome -32.0 Rome 25458.0 41.8930555556 12.4827777778 3169070.0 Italy Southern Europe Europe False
5205659 Q534814 Theodulf of Orléans WRITER 3.71311436636 True False 17 18.8631025954 750.0 Spain 26667.0 40.0 -4.0 5191870 Caliphate 821.0 Angers 82357.0 47.4727777778 -0.555555555556 3037656.0 Spain Southern Europe Europe False
585186 Q380992 Maurice Bourgès-Maunoury POLITICIAN 388.799055234 True False 17 16.0945669258 1914.0 Luisant 15163670.0 48.4325 1.4772 2997148 France 1993.0 Paris 22989.0 48.8565777778 2.35182777778 2988507.0 France Western Europe Europe False
585182 Q365413 Félix Gaillard POLITICIAN 176.412207013 True False 21 16.5000609487 1919.0 Paris 22989.0 48.8567 2.3508 2988507 France 1970.0 Jersey 15693.0 49.19 -2.11 3042091.0 France Western Europe Europe False
245351 Q57283 Emil Artin MATHEMATICIAN 90.3188498161 True False 30 17.3040212514 1898.0 Vienna 55866.0 48.2 16.36666667 2761369 Austria 1962.0 Hamburg 13467.0 53.55 10.0 2864067.0 Austria Western Europe Europe False
8194931 Q813332 Beau Biden POLITICIAN 13.4410839261 True BeauBiden False 15 12.5116831637 1969.0 Wilmington, Delaware 108930.0 39.74583333 -75.54666667 4145381 United States 2015.0 Bethesda, Maryland 43484.0 38.9827777778 -77.0988888889 4348599.0 United States Northern America Americas False
48990713 Q58670 Princess Charlotte of Prussia COMPANION 20.279545879 False False 17 17.8711654387 1860.0 Potsdam 49112.0 52.4 13.06666667 2852458 Prussia 1919.0 Baden-Baden 88156.0 48.7619444444 8.24083333333 2953504.0 Germany Western Europe Europe False
3525298 Q532238 Nguyễn Văn Thuận RELIGIOUS FIGURE 46.7903727983 True False 15 17.5397196828 1928.0 Huế 59684.0 16.46666667 107.58333333 1580240 2002.0 Rome 25458.0 41.8930555556 12.4827777778 3169070.0 Vietnam South-Eastern Asia Asia False

Pandas import

pd.read_csv("raw/people.tsv", sep="\t", na_values="null", true_values="true", false_values="false")
Clone this wiki locally