notebook.community

Edit and run



In [1]:

    
import pandas as pd
import glob
import os
import numpy as np
from time import time
import logging
import gensim
import bz2
import PyPDF2
import requests
import json









    



/Users/Barry/anaconda/lib/python3.5/site-packages/gensim/utils.py:1015: UserWarning: Pattern library is not installed, lemmatization won't be available.
  warnings.warn("Pattern library is not installed, lemmatization won't be available.")



In [15]:

    
dataset = []

path = '../datas/scrap/person/'
allFiles = glob.glob(os.path.join(path, '*.csv'))

# Load and concactenate all the files into one dataset.
for file_ in allFiles:
    data = pd.read_csv(file_)
    dataset += [data]
datas = pd.concat(dataset)

print(len(data.columns))  
#print('Length of the dataset', len(dataset))



In [16]:

    
datas = datas.dropna(axis = 0, subset = ["PersonIdCode"])



In [13]:

    
ids = datas.PersonIdCode.unique().astype(int)



In [19]:

    
url_portrait = "https://www.parlament.ch/sitecollectionimages/profil/portrait-260/"
for id in ids:
    print(id)
    f = open('../datas/pictures/' + str(id) + '.jpg','wb')
    f.write(requests.get(url_portrait + str(id) + '.jpg').content)
    f.close()



In [109]:

    
datas[datas["FirstName"] == "Peter"]









    Out[109]:






  
    
      
      Unnamed: 0
      DateOfBirth
      DateOfDeath
      FirstName
      GenderAsString
      ID
      Language
      LastName
      MaritalStatus
      MaritalStatusText
      ...
      NativeLanguage
      NumberOfChildren
      OfficialName
      PersonIdCode
      PersonNumber
      PlaceOfBirthCanton
      PlaceOfBirthCity
      Title
      TitleText
      id
    
  
  
    
      6
      6
      1942-09-03T00:00:00
      NaN
      Peter
      m
      10
      FR
      Baumberger
      2.0
      marié(e)
      ...
      D
      2.0
      Baumberger Peter
      2269.0
      10
      Zurich
      Winterthur
      6.0
      Dr. iur.
      Peter Baumberger
    
    
      12
      12
      1939-06-01T00:00:00
      NaN
      Peter
      m
      16
      FR
      Bircher
      2.0
      marié(e)
      ...
      D
      2.0
      Bircher Peter
      2260.0
      16
      Argovie
      Wölflinswil
      NaN
      NaN
      Peter Bircher
    
    
      18
      18
      1933-09-16T00:00:00
      NaN
      Peter
      m
      22
      FR
      Bloetzer
      1.0
      célibataire
      ...
      D
      NaN
      Bloetzer
      2337.0
      22
      Valais
      Brigue
      95.0
      dipl. Bauing. ETH
      Peter Bloetzer
    
    
      19
      19
      1952-03-30T00:00:00
      NaN
      Peter
      m
      23
      FR
      Bodenmann
      NaN
      NaN
      ...
      NaN
      NaN
      Bodenmann Peter
      2018.0
      23
      NaN
      NaN
      NaN
      NaN
      Peter Bodenmann
    
    
      105
      105
      1948-05-14T00:00:00
      NaN
      Peter
      m
      111
      FR
      Hess
      2.0
      marié(e)
      ...
      D
      4.0
      Hess Peter
      2085.0
      111
      Zoug
      Unterägeri
      6.0
      Dr. iur.
      Peter Hess
    
    
      115
      115
      1957-09-26T00:00:00
      NaN
      Peter
      m
      121
      FR
      Jenni
      NaN
      NaN
      ...
      D
      NaN
      Jenni
      2302.0
      121
      NaN
      NaN
      NaN
      NaN
      Peter Jenni
    
    
      190
      190
      1940-10-04T00:00:00
      NaN
      Peter
      m
      196
      FR
      Schmid
      NaN
      NaN
      ...
      NaN
      NaN
      Schmid Peter
      2161.0
      196
      NaN
      NaN
      NaN
      NaN
      Peter Schmid
    
    
      218
      218
      1940-04-26T00:00:00
      2009-07-04T00:00:00
      Peter
      m
      225
      FR
      Tschopp
      2.0
      marié(e)
      ...
      F
      2.0
      Tschopp Peter
      2329.0
      225
      Bâle-Ville
      Bâle
      91.0
      Doctorat
      Peter Tschopp
    
    
      222
      222
      1946-04-14T00:00:00
      NaN
      Peter
      m
      229
      FR
      Vollmer
      2.0
      marié(e)
      ...
      D
      3.0
      Vollmer
      2251.0
      229
      Berne
      Berne
      26.0
      Dr. rer. pol.
      Peter Vollmer
    
    
      265
      265
      1952-06-21T00:00:00
      NaN
      Peter
      m
      277
      FR
      Bieri
      2.0
      marié(e)
      ...
      D
      4.0
      Bieri
      2356.0
      277
      Zurich
      Winterthur
      226.0
      Dipl. Ing. Agr. ETH / Dr. sc. techn.
      Peter Bieri
    
    
      294
      294
      1952-12-11T00:00:00
      NaN
      Peter
      m
      321
      FR
      Föhn
      2.0
      marié(e)
      ...
      D
      4.0
      Föhn
      2385.0
      321
      Schwyz
      Muotathal
      NaN
      NaN
      Peter Föhn
    
    
      308
      308
      1956-09-16T00:00:00
      NaN
      Peter
      m
      335
      FR
      Kofmel
      2.0
      marié(e)
      ...
      D
      2.0
      Kofmel
      2398.0
      335
      Soleure
      Deitingen
      115.0
      lic. iur.
      Peter Kofmel
    
    
      339
      339
      1956-02-19T00:00:00
      NaN
      Peter
      m
      366
      FR
      Weigelt
      2.0
      marié(e)
      ...
      D
      3.0
      Weigelt
      2430.0
      366
      St-Gall
      St. Gall
      NaN
      NaN
      Peter Weigelt
    
    
      386
      386
      1955-01-26T00:00:00
      NaN
      Peter
      m
      440
      FR
      Jossen-Zinsstag
      2.0
      marié(e)
      ...
      D
      3.0
      Jossen
      2472.0
      440
      Valais
      Stalden
      115.0
      lic. iur.
      Peter Jossen-Zinsstag
    
    
      449
      449
      1959-01-09T00:00:00
      NaN
      Peter
      m
      513
      FR
      Spuhler
      2.0
      marié(e)
      ...
      D
      3.0
      Spuhler
      2535.0
      513
      NaN
      Sevilla
      NaN
      NaN
      Peter Spuhler
    
    
      464
      464
      1943-11-01T00:00:00
      NaN
      Peter
      m
      528
      FR
      Briner
      2.0
      marié(e)
      ...
      D
      2.0
      Briner
      2548.0
      528
      Zurich
      Zurich
      214.0
      -
      Peter Briner
    
    
      551
      551
      1923-06-08T00:00:00
      2012-04-11T00:00:00
      Peter
      m
      628
      FR
      Gerber
      NaN
      NaN
      ...
      D
      NaN
      Gerber
      1074.0
      628
      NaN
      NaN
      NaN
      NaN
      Peter Gerber
    
    
      552
      552
      1923-10-21T00:00:00
      NaN
      Peter
      m
      629
      FR
      Knüsel
      NaN
      NaN
      ...
      D
      NaN
      Knüsel
      1075.0
      629
      NaN
      NaN
      NaN
      NaN
      Peter Knüsel
    
    
      635
      635
      1946-11-26T00:00:00
      NaN
      Peter
      m
      714
      FR
      Aliesch
      NaN
      NaN
      ...
      NaN
      NaN
      Aliesch
      2001.0
      714
      NaN
      NaN
      NaN
      NaN
      Peter Aliesch
    
    
      660
      660
      1942-02-14T00:00:00
      NaN
      Peter
      m
      740
      FR
      Hänggi
      NaN
      NaN
      ...
      NaN
      NaN
      Hänggi Peter
      2081.0
      740
      NaN
      NaN
      NaN
      NaN
      Peter Hänggi
    
    
      685
      685
      1925-01-17T00:00:00
      2006-07-01T00:00:00
      Peter
      m
      765
      FR
      Sager
      NaN
      NaN
      ...
      NaN
      NaN
      Sager
      2155.0
      765
      NaN
      NaN
      NaN
      NaN
      Peter Sager
    
    
      688
      688
      1930-10-12T00:00:00
      2010-12-09T00:00:00
      Peter
      m
      768
      FR
      Spälti
      NaN
      NaN
      ...
      D
      NaN
      Spälti
      2170.0
      768
      NaN
      NaN
      NaN
      NaN
      Peter Spälti
    
    
      701
      701
      1922-10-06T00:00:00
      2012-09-17T00:00:00
      Peter
      m
      782
      FR
      Hefti
      NaN
      NaN
      ...
      D
      NaN
      Hefti Peter
      2215.0
      782
      NaN
      NaN
      NaN
      NaN
      Peter Hefti
    
    
      32
      32
      1960-10-18T00:00:00
      2012-09-22T00:00:00
      Peter
      m
      3896
      FR
      Malama
      2.0
      marié(e)
      ...
      D
      3.0
      Malama
      2699.0
      3896
      Zurich
      Zurich
      50.0
      lic. rer. pol.
      Peter Malama
    
    
      83
      83
      1957-04-21T00:00:00
      NaN
      Peter
      m
      4041
      FR
      Flück
      2.0
      marié(e)
      ...
      D
      2.0
      Flück Peter
      2749.0
      4041
      Berne
      Unterseen
      230.0
      dipl. Sanitärplaner
      Peter Flück
    
    
      139
      139
      1971-04-22T00:00:00
      NaN
      Peter
      m
      4098
      FR
      Keller
      NaN
      NaN
      ...
      D
      NaN
      Keller Peter
      3013.0
      4098
      Lucerne
      Lucerne
      12.0
      lic. phil. I
      Peter Keller
    
    
      164
      164
      1959-06-01T00:00:00
      NaN
      Peter
      m
      4124
      FR
      Schilliger
      2.0
      marié(e)
      ...
      D
      3.0
      Schilliger
      3029.0
      4124
      Lucerne
      Udligenswil
      NaN
      NaN
      Peter Schilliger
    
    
      191
      191
      1960-12-25T00:00:00
      NaN
      Peter
      m
      4153
      FR
      Hegglin
      2.0
      marié(e)
      ...
      D
      4.0
      Hegglin Peter
      3053.0
      4153
      Zoug
      Edlibach
      NaN
      NaN
      Peter Hegglin
    
  

28 rows × 23 columns



In [110]:

    
datas['id'] = datas['FirstName']+' '+datas['LastName']
links = datas[["PersonIdCode"  ,"id"]]



In [111]:

    
links[links['id']== "Peter Schilliger"]









    Out[111]:






  
    
      
      PersonIdCode
      id
    
  
  
    
      164
      3029.0
      Peter Schilliger



In [112]:

    
dictionary = dict(zip(datas["id"].values.tolist(),datas["PersonIdCode"].astype(int).values.tolist()))



In [113]:

    
dictionary









    Out[113]:





{'Kurt Bürer': 1005,
 'Paul Wyss': 2191,
 'Serge Beck': 2461,
 'Jean-Claude Rennwald': 2413,
 'Flavio Cotti': 1082,
 'Hubert Bonvin': 2020,
 'Fritz Stalder': 2297,
 'Elisabeth Blunschy-Steiner': 1002,
 'Isabelle Chevalley': 3604,
 'Valentine Friedli': 1022,
 'Maximilian Reimann': 2147,
 'Theo Maissen': 2359,
 'Rudolf jun. Reichling': 2145,
 'Duri Campell': 3066,
 'Christoph Blocher': 2017,
 'Judith Stamm': 2173,
 'Hans Ulrich Baumberger': 1151,
 'Thomas Burgener': 2450,
 'Jean-Nils de Dardel': 2282,
 'Jean Christophe Schwaab': 3020,
 'Jacqueline Badran': 2762,
 'Christine Egerszegi-Obrist': 2380,
 'Werner Hösli': 3047,
 'Pierre Gassmann': 1153,
 'Lisa Mazzone': 3086,
 'Yvette Estermann': 2679,
 'Daniela Schneeberger': 2766,
 'Jean-Pierre Bonny': 2019,
 'Leo Müller': 3012,
 'Werner Carobbio': 2032,
 'Ursula Haller Vannini': 2496,
 'Walter Hess': 2499,
 'Walter Decurtins': 2482,
 'Marco Borradori': 2273,
 'Louis Schelbert': 2654,
 'Martina Munz': 3036,
 'Ernst Leuenberger': 2102,
 'Thomas Hardegger': 2763,
 'Bea Heim': 2601,
 'Laurent Rebeaud': 2142,
 'Ulrich Fischer': 2065,
 'Hardi Bischof': 2271,
 'Walter Müller': 2617,
 'Raymond Junod': 1120,
 'Mauro Tuena': 3097,
 'Jean-Claude Zwahlen': 2334,
 'Jacques Nicolet': 3089,
 'Philippe Nantermod': 3088,
 'Erich von Siebenthal': 2713,
 'Petra Gössi': 3023,
 'Roland Ostermann': 2346,
 'Alma Bacciarini': 1101,
 'Sylvia Flückiger-Bäni': 2681,
 'David Linder': 1125,
 'Jean-François Steiert': 2669,
 'Gertrud Spiess': 1145,
 'Jakob Schönenberger': 2238,
 'Franz Dietrich': 2045,
 'Hans Stöckli': 2647,
 'Mathias Reynard': 2795,
 'Isidor Baumann': 2793,
 'Otto Zwygart': 2199,
 'Fabienne Bugnon': 2350,
 'Kathrin Hilber': 2392,
 'Roland F. Borer': 2272,
 'Matthias Aebischer': 2760,
 'Helen Leumann': 2437,
 'Hansjakob Leutenegger': 2509,
 'Markus Hutter': 2605,
 'François Couchepin': 9301,
 'Hansjürg Weder': 2186,
 'Dominique de Buman': 2593,
 'Erika Forster-Vannini': 2432,
 'Irène Gardiol': 2253,
 'Madeleine Amgwerd': 2639,
 'Didier Burkhalter': 2589,
 'Martha Ribi': 1138,
 'Ernst Rüesch': 2235,
 'Rudolf Ruch': 1049,
 'Franz-Joseph Hildbrand': 2086,
 'Silvio de Capitani': 1106,
 'Ursula Wyss': 2544,
 'Walter Renschler': 1041,
 'Walter Donzé': 2564,
 'Eric Voruz': 2714,
 'Yvonne Feri': 2777,
 'Jakob Büchler': 2588,
 'Heinz Allenspach': 2002,
 'Gilbert Coutau': 2039,
 'Willy Loretan': 2106,
 'Oswald Ziegler': 2244,
 'Peter Tschopp': 2329,
 'Jean Guinand': 2075,
 'Hans Steffen': 2175,
 'Rolf Escher': 2557,
 'Robert Keller': 2504,
 'Norbert Zumbühl': 2246,
 'Konrad Basler': 2009,
 'Hansjörg Knecht': 3021,
 'Theo Meyer': 2261,
 'Regina Ammann Schoch': 2467,
 'Yves Nidegger': 2701,
 'Chiara Simoneschi-Cortesi': 2533,
 'Anita Lachenmeier-Thüring': 2696,
 'Hanspeter Thür': 2180,
 'Beda Humbel': 2090,
 'Christian Lohr': 3024,
 'Melchior Ehrler': 2381,
 'Fulvio Pelli': 2409,
 'Christoph Mörgeli': 2519,
 'Lili Nabholz': 2124,
 'Werner Vetterli': 2330,
 'Ida Glanzmann-Hunkeler': 2657,
 'Brigitte Häberli-Koller': 2600,
 'Christiane Langenberger': 2361,
 'Edouard Delalay': 2208,
 'Franziska Teuscher': 2422,
 'Claude Béglé': 3060,
 'Jean-François Rime': 2627,
 'Max Binder': 2270,
 'André Bugnon': 2477,
 'Barbara Haering': 2254,
 'Philippe Bauer': 3059,
 'Hubert Lauper': 2401,
 'Rebecca Ana Ruiz': 3045,
 'Franz Jung': 2095,
 'Pierre Etique': 2055,
 'Jean-Marc Narbel': 2314,
 'Jean Revaclier': 1042,
 'Paul-André Roux': 2742,
 'Christian Lüscher': 2698,
 'Ernst Schibli': 2572,
 'Balthasar Glättli': 3003,
 'Victor Ruffy': 2151,
 'Giuliano Bignasca': 2360,
 'Liliane Chappuis': 2478,
 'Bruno Hunziker': 2217,
 'Jean-Pierre Graber': 2687,
 'Meinrado Robbiani': 2526,
 'Otto Nauer': 1037,
 'Rudolf Rechsteiner': 2412,
 'Eric Nussbaumer': 2702,
 'Bernhard Guhl': 2785,
 'Hans Widmer': 2446,
 'Josef Lang': 2611,
 'Barbara Marty Kälin': 2563,
 'Denis de la Reussille': 3068,
 'Jean Riesen': 1043,
 'Jean-Jérôme Filliez': 2384,
 'Wilfried Hophan': 1089,
 'François Jeanneret': 2093,
 'Daniel Stolz': 3031,
 'Max Chopard-Acklin': 2734,
 'This Jenny': 2458,
 'Claude Massy': 2112,
 'Christine Wirz-von Planta': 2570,
 'Jean-Claude Crevoisier': 1107,
 'Therese Frösch': 2596,
 'Rolf Büttiker': 2030,
 'Duri Bezzola': 2264,
 'Josef Lötscher': 2403,
 'Rolf Engler': 2053,
 'Peter Vollmer': 2251,
 'Erwin Akeret': 1098,
 'Thomas de Courten': 2757,
 'Ursula Leemann': 2263,
 'Sylvie Perrinjaquet': 2703,
 'Benoît Genecand': 3073,
 'Bernhard Müller': 1036,
 'Emmanuella Blaser': 2371,
 'Evi Allemann': 2583,
 'Willy Messmer': 1130,
 'Alexander Tschäppät': 2328,
 'Claude Frey': 2066,
 'Pierre Rime': 1044,
 'Pierre Paupe': 2434,
 'Susanna Daepp-Heiniger': 2247,
 'Annemarie Huber-Hotz': 2576,
 'Fritz Räz': 1136,
 'François Borel': 2021,
 'Remo Giosué Galli': 2490,
 'Werner Jöri': 2303,
 'Luregn Mathias Cavelty': 2205,
 'Heidi Deneys': 1015,
 'Andrea Gmür-Schönenberger': 3075,
 'Guy Parmelin': 2621,
 'Yvette Jaggi': 2219,
 'Jean-François Leuba': 2101,
 'Lukas Fierz': 2062,
 'Lilian Uchtenhagen': 2182,
 'Pierre Aguet': 2200,
 'Lucrezia Meier-Schatz': 2516,
 'Adriano Imfeld': 2571,
 'Paul Wagner': 1058,
 'Pierre de Chastonay': 1010,
 'Christian Levrat': 2613,
 'Alois Gmür': 3001,
 'Hans Roth': 1139,
 'Pierre-Alain Gentil': 2433,
 'Heiner Studer': 2537,
 'Alice Glauser-Zufferey': 2686,
 'Corina Eichenberger-Walther': 2678,
 'Rolf Mauch': 2114,
 'Reinhard Müller': 2123,
 'Philippe Pidoux': 2138,
 'Ernst Mühlemann': 2120,
 'Luciano Giudici': 1025,
 'Barbara Gurtner': 1027,
 'Claude Ruey': 2528,
 'Caspar Baader': 2454,
 'Heinz Bratschi': 1004,
 'Ruedi Lustenberger': 2512,
 'Bernard Dupont': 1018,
 'Hans Bisig': 2336,
 'Leo Weber': 1060,
 'Arthur Hänsenberger': 2214,
 'Arthur Züger': 2197,
 'Francis Matthey': 2113,
 'Laurent Wehrli': 3100,
 'Walter Steinemann': 2325,
 'Andreas Gerwig': 1116,
 'Christoph von Rotz': 2712,
 'Hans-Jürg Fehr': 2488,
 'Tiana Angelina Moser': 2700,
 'Hans Hofmann': 2460,
 'Félicien Morel': 1131,
 'Laurent Butty': 1006,
 'Urs Nussbaumer': 2128,
 'Raymond Clottu': 3037,
 'Carl jun. Miville': 2228,
 'Samuel Meier': 2265,
 'Yves Guisan': 2389,
 'Gertrude Girard': 1117,
 'Josias F. Gasser': 3015,
 'Jacques Bourgeois': 2675,
 'Emilie Lieberherr': 1156,
 'Jean-Pierre Grin': 2688,
 'Hans Letsch': 1076,
 'Rudolf Hafner': 2078,
 'Hans Wicki': 3054,
 'Rolf Weber': 1061,
 'Hans Zbinden': 2193,
 'Kurt Fluri': 2594,
 'Albert Rüttimann': 2153,
 'Roberto Zanetti': 2546,
 'Dario Robbiani': 1046,
 'Roland Rino Büchel': 2740,
 'Marina Carobbio Guscetti': 2666,
 'Ernst Hasler': 2444,
 'Lothar Ziörjen': 3008,
 'Thérèse Meyer-Kaelin': 2470,
 'Verena Herzog': 3033,
 'Paul Fäh': 2057,
 'Pierre Tillmanns': 2556,
 'Ricardo Lumengo': 2697,
 'Jean-Claude Cornu': 2549,
 'Hans-Rudolf Merz': 2451,
 'Hansruedi Stadler': 2551,
 'Peter Bodenmann': 2018,
 'Rudolf Rohr': 2364,
 'Ernst Cincera': 2035,
 'Fabio Pedrina': 2522,
 'Anne Mahrer': 3038,
 'Markus Lehmann': 3011,
 'Michèle-Irène Berger': 2554,
 'Marguerite Misteli': 2312,
 'Fritz Reimann': 2146,
 'Josef Leu': 2306,
 'Werner Martignoni': 1033,
 'Hans Werner Widrig': 2189,
 'Paul Niederberger': 2722,
 'Jean Savary': 2157,
 'Otto Piller': 2230,
 'Pierre Triponez': 2538,
 'Otto G. Loretan': 2402,
 'Jasmin Hutter-Hutter': 2604,
 'Milli Wittenwiler': 2332,
 'Martin Landolt': 2735,
 'Rosmarie Quadranti': 2779,
 'Ruedi Baumann': 2268,
 'Erwin Jutzet': 2397,
 'Hans Munz': 1158,
 'Karl Weber': 2185,
 'Sibel Arslan': 3058,
 'Paul Günter': 2076,
 'Marguerite Florio': 2463,
 'Toni Brunner': 2372,
 'Urs Scheidegger': 2159,
 'Walter Biel': 2014,
 'Hildegard Fässler-Osterwalder': 2448,
 'Ulrich Siegrist': 2532,
 'Martin Candinas': 2770,
 'Andy Tschümperlin': 2665,
 'Gilles Petitpierre': 2136,
 'Hanna Muralt Müller': 2582,
 'Thomas Weibel': 2728,
 'Fritz Hofmann': 1028,
 'Franz Wicki': 2438,
 'Johannes Randegger': 2410,
 'Adèle Thorens Goumaz': 2710,
 'Thomas Minder': 3019,
 'Claude Janiak': 2501,
 'Fritz Lanz': 2099,
 'Angeline Fankhauser': 2058,
 'Bernard Rohrbasser': 2148,
 'Peter Schilliger': 3029,
 'Roberta Pantani': 2773,
 'Alexander Euler': 2056,
 'Otto Hess': 2084,
 'Anton Schaller': 2471,
 'Richard Reich': 2144,
 'Jean-Philippe Gloor': 1026,
 'André Perey': 2135,
 'Ernst Eggenberg': 2050,
 'Verena Singeisen': 2353,
 'Felix Müri': 2618,
 'Beat Arnold': 3057,
 'Katrin Kuhn': 2469,
 'Andreas Aebi': 2670,
 'Thomas Müller': 2661,
 'Cesla Amarelle': 3014,
 'Trix Heberlein': 2267,
 'Pierre-André Page': 3090,
 'Thomas Burgherr': 3064,
 'Jean Cavadini': 2204,
 'Paul Biderbost': 1105,
 'Hugues Hiltpold': 2691,
 'Josef Kühne': 2098,
 'Toni Cantieni': 1009,
 'Hansjörg Braunschweig': 2022,
 'Achille Casanova': 2581,
 'Gret Haller': 2080,
 'Valentin Oehen': 1039,
 'Albrecht Rychen': 2154,
 'Bastien Girod': 2685,
 'Corrado Pardini': 2751,
 'Simeon Bühler': 2026,
 'Peter Bieri': 2356,
 'Margrith von Felten': 2290,
 'Ursula Koch': 2505,
 'Hans Rüegg': 1142,
 'Vreni Müller-Hemmi': 2407,
 'Thomas Maier': 3022,
 'Markus Wäfler': 2636,
 'Mario Soldini': 1053,
 'Franco Cavalli': 2373,
 'Hermann Hess': 3079,
 'Christian Jost': 1119,
 'Max Dünki': 2049,
 'Gaston Brahier': 1088,
 'Kurt Meyer': 1034,
 'Gilbert Debons': 2462,
 'Jean Ziegler': 2195,
 'Andreas Dürr': 1110,
 'Monique Bauer-Lagier': 1067,
 'André Reymond': 2626,
 'Daniel Fässler': 2767,
 'Adriano Cavadini': 2033,
 'Walter Bosshard': 2445,
 'Kurt Müller': 2122,
 'Markus Kündig': 2223,
 'Anne-Catherine Menétrey-Savary': 2517,
 'Pascale Bruderer Wyss': 2573,
 'Paul Rechsteiner': 2143,
 'Ueli Maurer': 2310,
 'Peter Bloetzer': 2337,
 'Pierre-André Monnard': 3049,
 'Charles-Albert Antille': 2456,
 'Jakob Stucki': 1055,
 'Ruth Mascarin-Bircher': 1091,
 'Pierre-Alain Fridez': 2778,
 'Ernst Huggenberger': 1118,
 'Joseph Iten': 2091,
 'Walter Schmied': 2321,
 'Charles Favre': 2487,
 'Bernard Comby': 2281,
 'Ruth Metzler-Arnold': 2567,
 'Felix Auer': 2006,
 'Raphaël Comte': 2741,
 'Marc Frédéric Suter': 2327,
 'Georges Theiler': 2424,
 'Theo Fischer': 2063,
 'Alain Berset': 2642,
 'Fritz Abraham Oehrli': 2408,
 'Regine Aeppli': 2365,
 'Ueli Leuenberger': 2579,
 'Marianne Slongo': 2550,
 'Ulrich Ammann': 1001,
 'Eduard Belser': 1068,
 'Christian Merz': 1129,
 'Sepp Stappung': 2174,
 'Max Affolter': 2201,
 'Françoise Saudan': 2435,
 'Christian Miesch': 2311,
 'Eugen David': 2042,
 'Otto Fischer': 1112,
 'Rémy Scheurer': 2320,
 'Hans Grunder': 2689,
 'Andrea Martina Geissbühler': 2683,
 'Max Chopard': 1011,
 'Jost Gross': 2388,
 'René Vaudroz': 2540,
 'Markus Ritter': 2754,
 'Ernst Steiner': 1081,
 'Ulrich Giezendanner': 2292,
 'Géraldine Marchand-Balet': 3083,
 'Olivier Chevallaz': 2280,
 'Georges Thévoz': 1056,
 'Roland Fischer': 2794,
 'Claudius Alder': 1099,
 'Armin Jans': 2396,
 'Alex Heim': 2452,
 'Heinz Siegenthaler': 3048,
 'Gilbert Duboule': 1109,
 'Stefan Cornaz': 2349,
 'Reto Wehrli': 2637,
 'Ulrich Gadient': 2212,
 'Silvia Schenker': 2630,
 'Jakob Freund': 2386,
 'Erich Müller': 2406,
 'Bernard Meizoz': 2118,
 'Simonetta Sommaruga': 2534,
 'Albert Eggli': 1019,
 'Peter Jenni': 2302,
 'Doris Morf': 2119,
 'Peter Hess': 2085,
 'Franz Muheim': 1080,
 'Michel Béguelin': 2012,
 'Gottlieb Geissbühler': 1024,
 'Geo Camponovo': 2278,
 'Verena Grendelmeier': 2073,
 'Rico Wenger': 2553,
 'Jacques-Simon Eggly': 2051,
 'Susi Eppenberger': 2054,
 'Kaspar Villiger': 2242,
 'Felix Gutzwiller': 2495,
 'Gabriel Theubet': 2179,
 'Mario Fehr': 2489,
 'Willy Donzé': 1152,
 'Ivo Bischofberger': 2667,
 'Christian Wasserfallen': 2715,
 'Josy Gyr-Steiner': 2599,
 'Hans Hess': 2459,
 'Hans Killer': 2695,
 'Beat Vonlanthen': 3106,
 'Fabio Regazzi': 2776,
 'Pier Felice Barchi': 1103,
 'Nicolas Carnat': 2358,
 'Christian Grobet': 2387,
 'Jakob Bürgi': 2029,
 'Urs Kunz': 1123,
 'Susanne Leutenegger Oberholzer': 2129,
 'Werner Salzmann': 3092,
 'Hanspeter Seiler': 2168,
 'Jean-François Aubert': 1066,
 'Guy Genoud': 1073,
 'Rosmarie Zapfl': 2431,
 'Jean Studer': 2555,
 'Markus Ruf': 2150,
 'René Moser': 2313,
 'François Loeb': 2104,
 'Hans Danioth': 2207,
 'Armin Kern': 2305,
 'Jean-Pascal Delamuraz': 1108,
 'Margret Kiener Nellen': 2608,
 'Walter Weber': 1059,
 'Alfred Affolter': 1097,
 'Thomas Ammann': 3056,
 'Bernhard Hess': 2498,
 'Sep Cathomas': 2590,
 'Pierre Aeby': 2440,
 'Elmar Ledergerber': 2100,
 'Jean-Michel Cina': 2480,
 'Guy-Olivier Segond': 2167,
 'Urs Schweizer': 2662,
 'Fernand Mariétan': 2514,
 'François Lachat': 2400,
 'Heinz Schwab': 2165,
 'Giovanni Baggi': 2007,
 'Beat Flach': 2765,
 'Paul Luder': 2107,
 'Anita Thanei': 2423,
 'Martin Naef': 3018,
 'Jean-Jacques Cevey': 2034,
 'Philipp Stähelin': 2552,
 'Pius Segmüller': 2709,
 'Otto Ineichen': 2606,
 'Mauro Poggia': 2797,
 'Otto Laubacher': 2508,
 'Marlies Bänziger': 2672,
 'Peter Keller': 3013,
 'Arnold Koller': 1084,
 'Martin Burckhardt': 2028,
 'Marco Romano': 3025,
 'Richard Bäumlin': 2010,
 'Renzo Respini': 2442,
 'Rose-Marie Ducrot': 2376,
 'Arnold Müller': 1035,
 'Pirmin Bischof': 2674,
 'Walter Ammann': 2003,
 'Frédéric Borloz': 3061,
 'Hannes Germann': 2575,
 'Marcel Dobler': 3070,
 'Flavio Maspoli': 2309,
 'Arthur Loepfe': 2511,
 'Gianfranco Cotti': 2037,
 'Silva Semadeni': 2417,
 'Edouard Debétaz': 1071,
 'Paul Gemperli': 2339,
 'Lorenz Hess': 2799,
 'Christine Häsler': 3051,
 'Josef Risi': 1045,
 'Hansueli Raggenbass': 2316,
 'Hermann Wellauer': 2187,
 'Alex Kuprecht': 2641,
 'Geneviève Aubry': 2005,
 'Daniel Jositsch': 2694,
 'Ruth Grossenbacher-Schmid': 2266,
 'Gisèle Ory': 2643,
 'André Daguet': 2591,
 'Remigio Ratti': 2411,
 'Boris Banga': 2367,
 'Marcel Dubois': 1017,
 'Albert Vitali': 2761,
 'Eva Segmüller': 2166,
 'Franz Steinegger': 2176,
 'Heinz Brand': 2772,
 'Hans Rutschmann': 2644,
 'Min Li Marti': 3084,
 'Alfred Heer': 2690,
 'Maya Graf': 2569,
 'Beat Jans': 2745,
 'Toni Eberhard': 2379,
 'Eduard Rothen': 1140,
 'Ulrich Bremi-Forrer': 2024,
 'Bruno Frick': 2338,
 'Menga Danuser': 2040,
 'Jean-Charles Rielle': 2706,
 'Bernhard Seiler': 2239,
 'Thierry Burkart': 3065,
 'Natalie Rickli': 2705,
 'Roger Dafflon': 1092,
 'Hans Meier': 2226,
 'Karl Vogler': 2787,
 'Jürg Scherrer': 2160,
 'Heinrich Schalcher': 1143,
 'Peter Malama': 2699,
 'Claude Hêche': 2719,
 'Franz Jaeger': 2092,
 'Elisabeth Kopp': 1094,
 'Anton Muheim': 1157,
 'Beat Walti': 3044,
 'Hans Rudolf Gysin': 2077,
 'Robert Bühler': 2250,
 'Ruth-Gaby Vermot-Mangold': 2426,
 'Franz Eng': 1020,
 'Giovan Battista Pedrazzini': 1135,
 'Kaspar Rhyner': 2256,
 'Hans Kaufmann': 2503,
 'Elisabeth Zölch': 2196,
 'Walter Thurnherr': 3112,
 'Jean Fattebert': 2486,
 'Barbara Schmid-Federer': 2707,
 'Marianne Streiff-Feller': 2747,
 'Franco Matossi': 1077,
 'Guillaume Barazzone': 3040,
 'Barbara Polla': 2524,
 'Jacqueline Fehr': 2455,
 'Hanspeter Fischer': 1111,
 'Walter Stamm': 1054,
 'Karl Tschuppert': 2181,
 'Thomas Onken': 2229,
 'Robert Tochon': 1149,
 'Heinz Moll': 1079,
 'Gerhard Pfister': 2623,
 'Christine Beerli': 2335,
 'Luc Barthassat': 2649,
 'Simon Schenk': 2351,
 'Simon Epiney': 2286,
 'Christian Imark': 3080,
 'Silvio Bircher': 2015,
 'Luc Recordon': 2624,
 'Cornelia Füeg': 1114,
 'Doris Leuthard': 2510,
 'Fritz Hari': 2082,
 'Roger Golay': 3039,
 'Agnes Weber': 2429,
 'Pierre Kohler': 2610,
 'Thomas Matter': 3046,
 'Philipp Hadorn': 2792,
 'Karl Flubacher': 1021,
 'Hans Steiger': 2324,
 'Thomas Fuchs': 2753,
 'Valérie Piller Carrard': 3009,
 'Oskar Freysinger': 2595,
 'Erich Hess': 3078,
 'Remo Gysin': 2391,
 'Ursula Bäumlin': 2011,
 'Christine Bulliard-Marbach': 3017,
 'Giorgio Morniroli': 2340,
 'Kathrin Amacker-Amann': 2671,
 'Toni Dettling': 2284,
 'Peter Hegglin': 3053,
 'Walter Jermann': 2607,
 'Pierre-David Candaux': 1008,
 'Amélia Christinat': 1012,
 'Peter Jossen-Zinsstag': 2472,
 'Peter Kofmel': 2398,
 'Tim Guldimann': 3077,
 'Hans Uhlmann': 2241,
 'Hansruedi Wandfluh': 2542,
 'Gabriele Gendotti': 2492,
 'Otto Schoch': 2237,
 'Werner Marti': 2308,
 'Jean Spielmann': 2171,
 'Herbert Maeder': 2108,
 'Nadine Masshardt': 3034,
 'Dorle Vallender': 2425,
 'Rudolf Steiner': 2343,
 'Pierre Duvoisin': 2285,
 'Rosemarie Simmen': 2240,
 'Pascal Couchepin': 2038,
 'Rudolf Imhof': 2395,
 'Anne Seydoux-Christe': 2723,
 'Urs Gasche': 2764,
 'Odilo Schmid': 2416,
 'Peter Schmid': 2161,
 'Jean Wilhelm': 1150,
 'Hugo Wick': 2331,
 'Jörg De Bernardi': 3093,
 'Pierre Bonhôte': 2653,
 'Fritz Schiesser': 2257,
 'Massimo Pini': 2139,
 'Pierre Chiffelle': 2374,
 'Jean-Pierre Berger': 2013,
 'Jean-Michel Gros': 2074,
 'Luzi Stamm': 2323,
 'Manfred Aregger': 2004,
 'Hubert Reymond': 2232,
 'Dominique Baettig': 2673,
 'Alfred Neukomm': 2127,
 'Philippe Mamie': 2307,
 'Alain Ribaux': 3006,
 'Peter Hänggi': 2081,
 'Jean-Charles Simon': 2418,
 'Monika Weber': 2243,
 'Ruth Humbel': 2580,
 'Jean-Claude Vaudroz': 2539,
 'Josef Zisyadis': 2333,
 'René Longet': 2105,
 'Fritz Ganz': 1115,
 'Gregor Rutz': 3030,
 'Matthias Samuel Jauslin': 3109,
 'Barbara Steinemann': 3096,
 'Christian Waber': 2449,
 'Andreas Zeller': 2658,
 'Othmar Andermatt': 1087,
 "Maya Lalive d'Epinay": 2507,
 'Beat Rieder': 3105,
 'Roland Eberle': 2774,
 'Hans Rohrer': 1086,
 'Willy Pfund': 1040,
 'Priska Seiler Graf': 3094,
 'Marlyse Dormond Béguelin': 2483,
 'Sandra Sollberger': 3095,
 'Mario Grassi': 2072,
 'Laurent Favre': 2725,
 'Laurence Fehlmann Rielle': 3071,
 'Roberto Schmidt': 2708,
 'Käthi Bangerter': 2368,
 'Fabio Abate': 2565,
 'Daniel Vogel': 2427,
 'Gerold Bührer': 2277,
 'Theophil Pfister': 2523,
 'Maria Bernasconi': 2436,
 'Pierre Salvi': 2574,
 'Andreas Brönnimann': 2737,
 'René Meylan': 1078,
 'Brigit Wyss': 2716,
 'Lisbeth Fehr': 2289,
 'Norman Gobbi': 2739,
 'Mimi Lepori Bonetti': 2345,
 'Walter Röthlin': 1047,
 'Jürg Stahl': 2536,
 'Eveline Widmer-Schlumpf': 2730,
 'Filippo Leutenegger': 2612,
 'Esther Bührer': 2203,
 'William Wyss': 2192,
 'Carlo Schmid-Sutter': 2236,
 'Joachim Eder': 2780,
 'Adalbert Durrer': 2378,
 'Hans-Ueli Vogt': 3098,
 'Michel Flückiger': 2211,
 'Aline Trede': 3032,
 'Marco Chiesa': 3067,
 'Cédric Wermuth': 2759,
 'Charles Poncet': 2315,
 'Sebastian Frehner': 2750,
 'Christian van Singer': 2727,
 'Pierre Dreyer': 1072,
 'Christian Wanner': 2184,
 'Hans-Peter Portmann': 3043,
 'Robert Cramer': 2717,
 'Jean-Paul Glasson': 2493,
 'David Zuberbühler': 3102,
 'Peter Weigelt': 2430,
 'Paul-René Martin': 2111,
 'Konrad Graber': 2724,
 'Heinrich Estermann': 2485,
 'Yvonne Gilli': 2684,
 'Norbert Hochreutener': 2393,
 'Moritz Leuenberger': 2103,
 'Rosemarie Antille': 2249,
 'Leo Arnold': 1065,
 'Oscar Fritschi': 2291,
 'Anton Scherer': 1144,
 'Andreas Glarner': 3074,
 'Suzette Sandoz': 2318,
 'Verena Diener Lenz': 2044,
 'Rolf Schweiger': 2466,
 'Hermann Fehr': 2059,
 'Thomas Pfisterer': 2560,
 'Ursula Schneider Schüttel': 3028,
 'Liliane Maury Pasquier': 2405,
 'Françoise Pitteloud': 2183,
 'Paul Jäggi': 2301,
 'Kathrin Bertschy': 3016,
 'Kurt Wasserfallen': 2543,
 'Jacques Neirynck': 2521,
 'Francine John-Calame': 2650,
 'Paul Rutishauser': 2152,
 'Hans Jörg Huber': 2216,
 'Hans Schmid': 1095,
 'Gilbert Baechtold': 1102,
 'Peter Föhn': 2385,
 'Peter Baumberger': 2269,
 'Dumeni Columberg': 2036,
 'Paul Kurrus': 2506,
 'Peter Spuhler': 2535,
 'Jean Jacques Schwaab': 2531,
 'Maja Ingold': 2744,
 'Roland Wiederkehr': 2190,
 'Ignazio Cassis': 2664,
 'Corina Casanova': 2731,
 'Kathy Riklin': 2525,
 'Mattea Meyer': 3087,
 'Christine Keller': 2453,
 'Karin Keller-Sutter': 2769,
 'Marie-Thérèse Weber-Gobet': 2733,
 'Helmut Hubacher': 2089,
 'Thomas Aeschi': 2758,
 'Damian Müller': 3108,
 'Pankraz Freitag': 2729,
 'Felix Walker': 2562,
 'Doris Stump': 2421,
 'Heinrich Schnyder': 1051,
 'Rolf Graber': 2342,
 'Christoph Eymann': 2287,
 'Markus Stadler': 2746,
 'Daniel Vischer': 2635,
 'Fernand Cuche': 2481,
 'Kurt Schüle': 2164,
 'Armand Magnin': 1032,
 'Elisabeth Déglise': 2043,
 'Jacques-André Maire': 2738,
 'Urs Hany': 2659,
 'Jean-Luc Addor': 3055,
 'Valérie Garbani': 2491,
 'Thomas Böhni': 2756,
 'Vital Darbellay': 2041,
 'Alexis Gobet': 2293,
 'Armand-Auguste Forel': 1113,
 'Heinrich Ott': 2133,
 'Carlo Sommaruga': 2632,
 'Martin Bundi': 2027,
 'Dominique Ducret': 2210,
 'Filippo Lombardi': 2561,
 'Albert Rösti': 3010,
 'Hans Oester': 2131,
 'Ursula Hafner': 2079,
 'Fulvio Caccia': 2031,
 'Peter Flück': 2749,
 'Peter Sager': 2155,
 'Burkhard Vetsch': 1096,
 'Urs Hofmann': 2500,
 'Julius Binder': 1069,
 'Katharina Prelicz-Huber': 2732,
 'Francine Jeanprêtre': 2094,
 'André Gautier': 2213,
 'Isabelle Moret': 2660,
 'Pierre Vanek': 2633,
 'Hermann Weyeneth': 2347,
 'Pierre Teuscher': 1148,
 'Thomas Hurter': 2693,
 'Stefan Engler': 2768,
 'Cyrill Brügger': 2025,
 'Antonio Hodgers': 2692,
 'Brigitta M. Gadient': 2354,
 'Barbara Keller-Inhelder': 3081,
 'Bruno Walliser': 3099,
 'Pierre Savary': 2158,
 'Angelo Barrile': 3104,
 'Martine Brunschwig Graf': 2587,
 'Josef Landolt': 1030,
 'Stéphane Rossini': 2527,
 'Theodor Schnider': 2163,
 'Christian Speck': 2419,
 'Jean-Nicolas Philipona': 2137,
 'Rosmarie Dormann': 2046,
 'Fritz Hösli': 2087,
 'Monika Stocker-Meier': 2177,
 'Rolf Seiler': 2169,
 'Pirmin Schwander': 2631,
 'Magdalena Martullo-Blocher': 3085,
 'Camillo Jelmini': 2221,
 'Peter Spälti': 2170,
 'Chantal Galladé': 2597,
 'Christa Markwalder': 2614,
 'Jürg Michel': 2663,
 'Franz Grüter': 3076,
 'Walter Frey': 2067,
 'Hansjörg Walter': 2541,
 'Elvira Bader': 2474,
 'Andreas Iten': 2218,
 'Georg Nef': 1038,
 'Georg Stucky': 2178,
 'Alberto Stefani': 1159,
 'Jean-Jacques Hegg': 1093,
 'Charles Friderici': 2068,
 'Luigi Generali': 1154,
 'Barbara Gysi': 3026,
 'Elisabeth Caspar-Hutter': 2279,
 'Hans Altherr': 2645,
 'Bruno Pezzatti': 2784,
 'Christine Goll': 2294,
 'Maurice Chevrier': 2479,
 'Cécile Bühlmann': 2276,
 'Josef Dittli': 3052,
 'Martin Schmid': 2783,
 'Franz Brun': 2578,
 'Paul Zbinden': 2194,
 'Anton Keller': 2096,
 'Doris Fiala': 2680,
 'René Imoberdorf': 2720,
 'Richard Müller': 1134,
 'Marianne Kleiner': 2609,
 'Jacques Martin': 2110,
 'Olivier Français': 2682,
 'Xaver Reichmuth': 2231,
 'Odilo Guntern': 1155,
 'Titus Giger': 2070,
 'Jacques Pagan': 2620,
 'Rudolf Joder': 2502,
 'Josiane Aubert': 2668,
 'Franco Donati': 2464,
 'Pierre-Yves Maillard': 2513,
 'Markus Hausammann': 3002,
 'Dick Marty': 2441,
 'Anton Cottier': 2206,
 'Josef Ziegler': 1064,
 'Paul Bürgi': 1070,
 'Andrea Hämmerle': 2298,
 'Thierry Béguin': 2202,
 'Martin Bäumle': 2585,
 'Claude Bonnard': 1003,
 'Peter-Josef Schallberger': 2259,
 'Eric Rochat': 2439,
 'Kurt Reiniger': 1137,
 'Pia Hollenstein': 2300,
 'Otto Stich': 1147,
 'Paul Schmidhalter': 2162,
 'Jean Henri Dunant': 2484,
 'Raoul Kohler': 2097,
 'Georges Eggenberger': 2258,
 'Hans-Rudolf Feigenwinter': 2060,
 'Barbara Eberhard-Halter': 2363,
 'Didier Berberat': 2370,
 'Edith Graf-Litscher': 2652,
 'André Simonazzi': 2736,
 'Rudolf Keller': 2304,
 'Attilio Bignasca': 2586,
 'Lukas Reimann': 2704,
 'Françoise Vannay': 1057,
 'Samuel Schmid': 2348,
 'Marcel Scherer': 2529,
 'Marcel Dettling': 3069,
 'Michaël Buffat': 3062,
 'J. Alexander Baumann': 2369,
 'Manfred Bühler': 3063,
 'Josef Ulrich': 1160,
 'Urs Schläfli': 3027,
 'Walter Straumann': 2420,
 'Walter Wobmann': 2638,
 'Marianne Huguenin': 2603,
 'Riccardo Jagmetti': 2220,
 'Edgar Oehler': 2130,
 'Ruth Dreifuss': 2566,
 'Hans Egloff': 3005,
 'Margrit Camenzind': 1007,
 'Guido Zäch': 2545,
 'Urs Bernhardsgrütter': 2655,
 'Rudolf Winkler': 3050,
 'Werner Meier': 1128,
 'Claudio Zanetti': 3101,
 'Alois Dobler': 2209,
 'Viola Amherd': 2646,
 'Lieni Füglistaller': 2651,
 'Claudia Friedl': 3035,
 'Alfons Müller': 1132,
 'Vreni Hubmann': 2394,
 'Liselotte Spreng': 1146,
 'John Dupraz': 2377,
 'Pierre-François Veillon': 2634,
 'Lorenzo Quadri': 2752,
 'Josi J. Meier': 2227,
 'Hans Schärli': 1050,
 'Prisca Birrer-Heimo': 2743,
 'Christophe Darbellay': 2592,
 'Daniel Lauber': 2224,
 'Francis Loetscher': 1126,
 'Barbara Geiser': 2465,
 'Ernst Sieber': 2322,
 'Josef Kunz': 2399,
 'Daniel Brélaz': 2023,
 'Manuel Tornare': 3007,
 'Ursula Mauch': 2115,
 'Hans-Rudolf Früh': 2069,
 'Adolf Ogi': 2132,
 'Marie-Madeleine Prongué': 2355,
 'Kaspar Meier': 1127,
 'Peter Hefti': 2215,
 'Ruth Gonseth': 2295,
 'Peter Bircher': 2260,
 'Hans-Rudolf Nebiker': 2125,
 'Joseph Deiss': 2283,
 'Erich Ettlin': 3107,
 'Hans-Ulrich Graf': 2071,
 'Bruno Zuppiger': 2547,
 'Thomas Helbling': 3111,
 'Rolf Hegetschweiler': 2299,
 'Herbert Dirren': 1016,
 'Ada Marra': 2726,
 'Jean-René Fournier': 2718,
 'Nadja Pieren': 2781,
 'Hans Ruckstuhl': 2149,
 'Marcel Sandoz': 2414,
 'Rosmarie Bär': 2008,
 'Ruth Kalbermatten': 2468,
 'Thomas Baerlocher': 2252,
 'Adrian Amstutz': 2584,
 'Hermann Bürgi': 2559,
 'Alain Schweingruber': 2344,
 'Christiane Jaquet-Berger': 2447,
 'Niklaus Küchler': 2222,
 'Hugo Fasel': 2288,
 'Ulrich Blatter': 2016,
 'Roger Nordmann': 2648,
 'Tarzisius Caviezel': 2677,
 'Gabriel Roy': 1141,
 'Margrit Kessler': 2782,
 'Fathi Derder': 2788,
 'Jonas Fricker': 3072,
 'Gabi Huber': 2602,
 'Jean-Paul Gschwind': 2798,
 'Roger Schaffter': 1090,
 'Olivier Feller': 2789,
 'Micheline Calmy-Rey': 2577,
 'Andreas Gross': 2296,
 'Philipp Müller': 2616,
 'Patrice Mugny': 2520,
 'Jürg Grossen': 2786,
 'Andrea Caroni': 2775,
 'Hansueli von Allmen': 2428,
 'Peter Aliesch': 2001,
 'Markus Zemp': 2656,
 'Sigmund Widmer': 2188,
 'Ulrich Zimmerli': 2245,
 'Willi Neuenschwander': 2126,
 'Toni Bortoluzzi': 2274,
 'Walter Glur': 2494,
 'Pierre Rusconi': 2755,
 'Theodor Kloter': 1122,
 'Louis Barras': 1104,
 'Laura Sadis': 2628,
 'Hans Frei': 1083,
 'Yvan Perrin': 2622,
 'Vreni Spoerry': 2172,
 'Hedi Lang-Gehri': 1124,
 'Ruedi Aeschbacher': 2473,
 'Walter Zwingli': 2198,
 'Hansjörg Hassler': 2497,
 'Anita Fetz': 2061,
 'Esther Egger-Wyss': 2676,
 'Christiane Brunner': 2275,
 'Hans Lauri': 2568,
 'Roger Köppel': 3082,
 'Geri Müller': 2615,
 'Théo Christian Portmann': 2141,
 'Franco Masoni': 2225,
 'Jean Clivaz': 1013,
 ...}



In [25]:

    
links.to_json("linkspersons.json")



In [107]:

    
with open('linkspersons.json', 'w') as outfile:
    json.dump(dictionary, outfile)



In [ ]:

	Unnamed: 0	DateOfBirth	DateOfDeath	FirstName	GenderAsString	ID	Language	LastName	MaritalStatus	MaritalStatusText	...	NativeLanguage	NumberOfChildren	OfficialName	PersonIdCode	PersonNumber	PlaceOfBirthCanton	PlaceOfBirthCity	Title	TitleText	id
6	6	1942-09-03T00:00:00	NaN	Peter	m	10	FR	Baumberger	2.0	marié(e)	...	D	2.0	Baumberger Peter	2269.0	10	Zurich	Winterthur	6.0	Dr. iur.	Peter Baumberger
12	12	1939-06-01T00:00:00	NaN	Peter	m	16	FR	Bircher	2.0	marié(e)	...	D	2.0	Bircher Peter	2260.0	16	Argovie	Wölflinswil	NaN	NaN	Peter Bircher
18	18	1933-09-16T00:00:00	NaN	Peter	m	22	FR	Bloetzer	1.0	célibataire	...	D	NaN	Bloetzer	2337.0	22	Valais	Brigue	95.0	dipl. Bauing. ETH	Peter Bloetzer
19	19	1952-03-30T00:00:00	NaN	Peter	m	23	FR	Bodenmann	NaN	NaN	...	NaN	NaN	Bodenmann Peter	2018.0	23	NaN	NaN	NaN	NaN	Peter Bodenmann
105	105	1948-05-14T00:00:00	NaN	Peter	m	111	FR	Hess	2.0	marié(e)	...	D	4.0	Hess Peter	2085.0	111	Zoug	Unterägeri	6.0	Dr. iur.	Peter Hess
115	115	1957-09-26T00:00:00	NaN	Peter	m	121	FR	Jenni	NaN	NaN	...	D	NaN	Jenni	2302.0	121	NaN	NaN	NaN	NaN	Peter Jenni
190	190	1940-10-04T00:00:00	NaN	Peter	m	196	FR	Schmid	NaN	NaN	...	NaN	NaN	Schmid Peter	2161.0	196	NaN	NaN	NaN	NaN	Peter Schmid
218	218	1940-04-26T00:00:00	2009-07-04T00:00:00	Peter	m	225	FR	Tschopp	2.0	marié(e)	...	F	2.0	Tschopp Peter	2329.0	225	Bâle-Ville	Bâle	91.0	Doctorat	Peter Tschopp
222	222	1946-04-14T00:00:00	NaN	Peter	m	229	FR	Vollmer	2.0	marié(e)	...	D	3.0	Vollmer	2251.0	229	Berne	Berne	26.0	Dr. rer. pol.	Peter Vollmer
265	265	1952-06-21T00:00:00	NaN	Peter	m	277	FR	Bieri	2.0	marié(e)	...	D	4.0	Bieri	2356.0	277	Zurich	Winterthur	226.0	Dipl. Ing. Agr. ETH / Dr. sc. techn.	Peter Bieri
294	294	1952-12-11T00:00:00	NaN	Peter	m	321	FR	Föhn	2.0	marié(e)	...	D	4.0	Föhn	2385.0	321	Schwyz	Muotathal	NaN	NaN	Peter Föhn
308	308	1956-09-16T00:00:00	NaN	Peter	m	335	FR	Kofmel	2.0	marié(e)	...	D	2.0	Kofmel	2398.0	335	Soleure	Deitingen	115.0	lic. iur.	Peter Kofmel
339	339	1956-02-19T00:00:00	NaN	Peter	m	366	FR	Weigelt	2.0	marié(e)	...	D	3.0	Weigelt	2430.0	366	St-Gall	St. Gall	NaN	NaN	Peter Weigelt
386	386	1955-01-26T00:00:00	NaN	Peter	m	440	FR	Jossen-Zinsstag	2.0	marié(e)	...	D	3.0	Jossen	2472.0	440	Valais	Stalden	115.0	lic. iur.	Peter Jossen-Zinsstag
449	449	1959-01-09T00:00:00	NaN	Peter	m	513	FR	Spuhler	2.0	marié(e)	...	D	3.0	Spuhler	2535.0	513	NaN	Sevilla	NaN	NaN	Peter Spuhler
464	464	1943-11-01T00:00:00	NaN	Peter	m	528	FR	Briner	2.0	marié(e)	...	D	2.0	Briner	2548.0	528	Zurich	Zurich	214.0	-	Peter Briner
551	551	1923-06-08T00:00:00	2012-04-11T00:00:00	Peter	m	628	FR	Gerber	NaN	NaN	...	D	NaN	Gerber	1074.0	628	NaN	NaN	NaN	NaN	Peter Gerber
552	552	1923-10-21T00:00:00	NaN	Peter	m	629	FR	Knüsel	NaN	NaN	...	D	NaN	Knüsel	1075.0	629	NaN	NaN	NaN	NaN	Peter Knüsel
635	635	1946-11-26T00:00:00	NaN	Peter	m	714	FR	Aliesch	NaN	NaN	...	NaN	NaN	Aliesch	2001.0	714	NaN	NaN	NaN	NaN	Peter Aliesch
660	660	1942-02-14T00:00:00	NaN	Peter	m	740	FR	Hänggi	NaN	NaN	...	NaN	NaN	Hänggi Peter	2081.0	740	NaN	NaN	NaN	NaN	Peter Hänggi
685	685	1925-01-17T00:00:00	2006-07-01T00:00:00	Peter	m	765	FR	Sager	NaN	NaN	...	NaN	NaN	Sager	2155.0	765	NaN	NaN	NaN	NaN	Peter Sager
688	688	1930-10-12T00:00:00	2010-12-09T00:00:00	Peter	m	768	FR	Spälti	NaN	NaN	...	D	NaN	Spälti	2170.0	768	NaN	NaN	NaN	NaN	Peter Spälti
701	701	1922-10-06T00:00:00	2012-09-17T00:00:00	Peter	m	782	FR	Hefti	NaN	NaN	...	D	NaN	Hefti Peter	2215.0	782	NaN	NaN	NaN	NaN	Peter Hefti
32	32	1960-10-18T00:00:00	2012-09-22T00:00:00	Peter	m	3896	FR	Malama	2.0	marié(e)	...	D	3.0	Malama	2699.0	3896	Zurich	Zurich	50.0	lic. rer. pol.	Peter Malama
83	83	1957-04-21T00:00:00	NaN	Peter	m	4041	FR	Flück	2.0	marié(e)	...	D	2.0	Flück Peter	2749.0	4041	Berne	Unterseen	230.0	dipl. Sanitärplaner	Peter Flück
139	139	1971-04-22T00:00:00	NaN	Peter	m	4098	FR	Keller	NaN	NaN	...	D	NaN	Keller Peter	3013.0	4098	Lucerne	Lucerne	12.0	lic. phil. I	Peter Keller
164	164	1959-06-01T00:00:00	NaN	Peter	m	4124	FR	Schilliger	2.0	marié(e)	...	D	3.0	Schilliger	3029.0	4124	Lucerne	Udligenswil	NaN	NaN	Peter Schilliger
191	191	1960-12-25T00:00:00	NaN	Peter	m	4153	FR	Hegglin	2.0	marié(e)	...	D	4.0	Hegglin Peter	3053.0	4153	Zoug	Edlibach	NaN	NaN	Peter Hegglin