Database schema

Here you can explore the database schema of the Parltrack database.

This schema is generated by analyzing each record in the db and gathering occurrence statistics on the data structure. This way we can estimate how often a certain field of the record has which type or sub-schema. By dividing the shown percentages for list items by 100 we get the number of average list-items usually in this list.

Be aware that this is the structure of the entries from the db dumps. The JSON structures available from the different pages, usually contain lots of aggregated information from the other databases, but the the schema below can be considered lowest-common denominator.

Click on the names to fold/expand levels.
Dossiers
Dict (100%)
  • activities
    List (100%)
    • [0]
      Dict (703%)
      • body
        unicode (87%)
        Example: CSL
      • vote_references
        Dict (1%)
        • url
          unicode (100%)
          Example: http://www.europarl.europa.eu/oeil/DownloadSP.do?id=18883&num_rep=8241&language=en
        • title
          unicode (100%)
          Example: SP(2010)8657/2
      • documents
        List (88%)
        • [0]
          Dict (110%)
          • body
            unicode (74%)
            Example: EC
          • oj_ref
            Dict (18%)
            • url
              unicode (100%)
              Example: http://eur-lex.europa.eu/JOHtml.do?uri=OJ:C:2011:203:SOM:EN:HTML
            • title
              unicode (100%)
              Example: C 203 09.07.2011, p. 0003
          • oj_ref
            unicode (13%)
            Example: C 278 13.09.1997, p. 0006
          • title
            unicode (87%)
            Example: Council's activities
          • url
            unicode (64%)
            Example: http://www.europarl.europa.eu/oeil/resume.jsp?id=5914232&eventId=1152972&backToCaller=NO&language=en
          • text
            List (12%)
            • [0]
              unicode (561%)
              Example:

              The Council took note of the initial presentation by Commissioner De Gucht of the proposal for a comprehensive review of the GSP regulation, adopted by the Commission on 10 May 2011, and held a preliminary exchange of views.

          • celexid
            unicode (1%)
            Example: CELEX:52011PC0241:EN
          • summary_url
            unicode (44%)
            Example: http://www.europarl.europa.eu/oeil/resume.jsp?id=5914232&eventId=1152342&backToCaller=NO&language=en
          • date
            unicode (100%)
            Example: 2011-05-13
          • summary
            List (37%)
            • [0]
              unicode (869%)
              Example:

              PURPOSE: to revise, adapt and update the Regulation on applying a scheme of generalised tariff preferences (GSP).

          • type
            unicode (87%)
            Example: Commission/Council: initial legislative document
      • title
        unicode (0%)
        Example: Plenary sitting agenda, vote
      • actors
        List (99%)
        • [0]
          Dict (58%)
          • body
            unicode (100%)
            Example: CSL
          • function
            unicode (67%)
            Example: MEP
          • group
            unicode (67%)
            Example: S&D
          • council_doc
            unicode (5%)
            Example: http://www.europarl.europa.eu/oeil/resume.jsp?id=5914232&eventId=1152972&backToCaller=NO&language=en
          • meeting_id
            unicode (24%)
            Example: 3086
          • responsible
            bool (67%)
            Example: True
          • name
            unicode (67%)
            Example: Iotova Iliana Malinova
          • date
            unicode (100%)
            Example: 2011-05-13
          • department
            unicode (32%)
            Example: Foreign Affairs
          • mepref
            'bson.objectid.ObjectId (67%)
            Example: 4de1858c0fb8127435bdbf1b
          • institution
            unicode (32%)
            Example: Council of the Union
          • commitee
            unicode (67%)
            Example: Fisheries
        • [0]
          unicode (61%)
          Example: European Parlament
      • amendment_references
        unicode (3%)
        Example: http://www.europarl.europa.eu/oeil/A7-0273/2010
      • date
        unicode (99%)
        Example: 2011-05-13
      • joint_resolution
        Dict (1%)
        • url
          unicode (100%)
          Example: http://www.europarl.europa.eu/sides/getDoc.do?type=MOTION&reference=P7-RC-2011-0392&language=EN
        • title
          unicode (100%)
          Example: RC-B7-0392/2011
      • alt_refs
        List (9%)
        • [0]
          Dict (2%)
          • url
            unicode (100%)
            Example: http://www.europarl.europa.eu/sides/getDoc.do?type=JOINT-TEXT&mode=XML&reference=C5-2003-0461&language=EN
          • title
            unicode (100%)
            Example: C5-0461/2003
        • [0]
          unicode (97%)
          Example: C7-0116/2011
      • type
        unicode (99%)
        Example: Council meeting
  • _id
    'bson.objectid.ObjectId (100%)
    Example: 4dde8cd5865c0c0dfc000002
  • meta
    Dict (100%)
    • source
      unicode (100%)
      Example: http://www.europarl.europa.eu/oeil/file.jsp?id=5914232
    • updated
      datetime.datetime (98%)
      Example: 2011-07-10 01:40:29.616000
    • created
      datetime.datetime (1%)
      Example: 2011-07-10 01:08:08.821000
    • id
      int (99%)
      Example: 5914232
    • country
      unicode (100%)
      Example: eu
  • procedure
    Dict (100%)
    • dossier_of_the_committee
      unicode (68%)
      Example: INTA/7/06028
    • reference
      unicode (100%)
      Example: COD/2011/0117
    • title
      unicode (100%)
      Example: Scheme of generalised tariff preferences (repeal. Regulation (EC) No 732/2008)
    • legal_basis
      List (96%)
      • [0]
        unicode (134%)
        Example: TFEU 207
    • stage_reached
      unicode (100%)
      Example: Awaiting Parliament 1st reading / single reading / budget 1st stage
    • celexid
      unicode (0%)
      Example: CELEX:52011DC0323:EN
    • subjects
      List (99%)
      • [0]
        unicode (158%)
        Example: 6.20.01 Agreements and relations in the context of the World Trade Organisation (WTO)
    • agents
      List (78%)
      • [0]
        Dict (95%)
        • function
          unicode (81%)
          Example: MEP
        • body
          unicode (100%)
          Example: EP
        • group
          NoneType (73%)
          Example: None
        • group
          unicode (8%)
          Example: PPE
        • commitee
          unicode (81%)
          Example: Development
        • responsible
          bool (81%)
          Example: True
        • name
          NoneType (73%)
          Example: None
        • name
          unicode (8%)
          Example: Fjellner Christofer
        • department
          unicode (18%)
          Example: Maritime Affairs and Fisheries
        • date
          NoneType (73%)
          Example: None
        • date
          unicode (8%)
          Example: 2011-06-21
        • institution
          unicode (18%)
          Example: European Commission DG
        • mepref
          NoneType (73%)
          Example: None
        • mepref
          'bson.objectid.ObjectId (8%)
          Example: 4de184b90fb8127435bdbdf5
    • date
      unicode (2%)
      Example: 2011-06-10
    • subject(s)
      List (0%)
      • [0]
        unicode (200%)
        Example: 4.20 Public health
  • docs
    List (100%)
    • [0]
      Dict (25%)
      • body
        unicode (90%)
        Example: EC
      • oj_ref
        Dict (6%)
        • url
          unicode (100%)
          Example: http://eur-lex.europa.eu/JOHtml.do?uri=OJ:C:2011:101:SOM:EN:HTML
        • title
          unicode (100%)
          Example: C 101 01.04.2011, p. 0001
      • oj_ref
        unicode (0%)
        Example: C 095 24.03.1997, p. 0046
      • title
        unicode (100%)
        Example: SEC(2011)0536
      • url
        unicode (82%)
        Example: http://www.europarl.europa.eu/registre/docs_autres_institutions/commission_europeenne/sec/2011/0537/COM_SEC(2011)0537_EN.pdf
      • celexid
        unicode (13%)
        Example: CELEX:52011DC0345:EN
      • summary_url
        unicode (43%)
        Example: http://www.europarl.europa.eu/oeil/resume.jsp?id=5870492&eventId=1142050&backToCaller=NO&language=en
      • date
        unicode (100%)
        Example: 2011-05-10
      • summary
        List (43%)
        • [0]
          unicode (1104%)
          Example:

          Based on the observations contained in the revenue and expenditure account and the balance sheet of the Euratom Supply Agency for the financial year 2009, as well as on the Court of Auditor’s report and the Agency’s replies to the Court’s observations, the Council recommends that the Parliament grant the Director General of the Agency discharge in respect of the implementation of the budget for the financial year 2009.

      • type
        unicode (100%)
        Example: Document annexed to the procedure
MEPs
Dict (100%)
  • Committees
    List (99%)
    • [0]
      Dict (880%)
      • Organization
        unicode (100%)
        Example: Committee on Institutional Affairs
      • role
        unicode (100%)
        Example: Member
      • end
        datetime.datetime (100%)
        Example: 1992-01-14 00:00:00
      • committee_id
        unicode (47%)
        Example: BUDG
      • start
        datetime.datetime (100%)
        Example: 1989-07-26 00:00:00
  • Delegations
    List (92%)
    • [0]
      Dict (639%)
      • Organization
        unicode (100%)
        Example: Delegation for relations with Bulgaria, Romania and Albania
      • role
        unicode (100%)
        Example: Chair
      • end
        datetime.datetime (100%)
        Example: 1991-02-18 00:00:00
      • start
        datetime.datetime (100%)
        Example: 1989-07-26 00:00:00
  • Photo
    unicode (29%)
    Example: http://www.europarl.europa.eu/mepphoto/1941.jpg
  • Birth
    Dict (29%)
    • date
      datetime.datetime (100%)
      Example: 1965-02-01 00:00:00
    • place
      unicode (100%)
      Example: Roma
  • UserID
    unicode (100%)
    Example: 1114
  • Staff
    List (13%)
    • [0]
      Dict (263%)
      • Organization
        unicode (100%)
        Example: Conference of Presidents
      • role
        unicode (100%)
        Example: Member
      • end
        datetime.datetime (100%)
        Example: 1999-07-19 00:00:00
      • start
        datetime.datetime (100%)
        Example: 1997-01-29 00:00:00
  • active
    bool (100%)
    Example: True
  • Addresses
    Dict (29%)
    • Brussels
      Dict (100%)
      • Phone
        unicode (100%)
        Example: +32 (0)2 28 45902
      • Fax
        unicode (100%)
        Example: +32 (0)2 28 49902
      • Address
        Dict (100%)
        • Building
          unicode (100%)
          Example: Bât. Altiero Spinelli
        • City
          unicode (100%)
          Example: Bruxelles/Brussel
        • Office
          unicode (100%)
          Example: 09E130
        • Zip
          unicode (100%)
          Example: B-1047
        • building_code
          unicode (99%)
          Example: ASP
        • Street
          unicode (100%)
          Example: 60, rue Wiertz / Wiertzstraat 60
        • Organization
          unicode (100%)
          Example: Parlement européen
    • Postal
      List (100%)
      • [0]
        unicode (100%)
        Example: Parlamento europeo Rue Wiertz ASP 09E130 B-1047 Bruxelles
    • Strasbourg
      Dict (100%)
      • Phone
        unicode (100%)
        Example: +33 (0)3 88 1 75902
      • Fax
        unicode (100%)
        Example: +33 (0)3 88 1 79902
      • Address
        Dict (100%)
        • Building
          unicode (100%)
          Example: Bât. Louise Weiss
        • City
          unicode (100%)
          Example: Strasbourg Cedex
        • Office
          unicode (100%)
          Example: T12044
        • building_code
          unicode (99%)
          Example: LOW
        • Street
          unicode (100%)
          Example: 1, avenue du Président Robert Schuman
        • Zip2
          unicode (100%)
          Example: F-67070
        • Organization
          unicode (100%)
          Example: Parlement européen
        • Zip1
          unicode (100%)
          Example: CS 91024
  • Groups
    List (100%)
    • [0]
      Dict (256%)
      • Organization
        unicode (100%)
        Example: The Green Group in the European Parliament
      • role
        unicode (100%)
        Example: Chair
      • end
        datetime.datetime (100%)
        Example: 1994-07-18 00:00:00
      • groupid
        unicode (71%)
        Example: PSE
      • groupid
        List (6%)
        • [0]
          unicode (217%)
          Example: NA
      • start
        datetime.datetime (100%)
        Example: 1990-11-01 00:00:00
  • Constituencies
    List (100%)
    • [0]
      Dict (177%)
      • start
        datetime.datetime (100%)
        Example: 1989-07-25 00:00:00
      • end
        datetime.datetime (100%)
        Example: 1994-07-18 00:00:00
      • party
        unicode (100%)
        Example: Verdi Arcobaleno
      • country
        unicode (100%)
        Example: Italy
  • Mail
    unicode (29%)
    Example: roberta.angelilli@europarl.europa.eu
  • _id
    'bson.objectid.ObjectId (100%)
    Example: 4de182a30fb8127435bdbaeb
  • Homepage
    unicode (29%)
    Example: http://www.angelilli.it
  • CV
    List (26%)
    • [0]
      unicode (1%)
      Example: Qualified teacher. Businessman.
  • Curriculum vitae
    List (25%)
    • [0]
      NoneType (0%)
      Example: None
    • [0]
      unicode (498%)
      Example: Degree in political science; Masters in European Law; following degree course in communication sciences, specialising in innovation and development.
  • Name
    Dict (100%)
    • full
      unicode (100%)
      Example: AGLIETTA, Maria Adelaide
    • family
      unicode (100%)
      Example: AGLIETTA
    • title
      unicode (0%)
      Example: Sir
    • familylc
      unicode (100%)
      Example: aglietta
    • sur
      unicode (100%)
      Example: Maria Adelaide
    • aliases
      List (100%)
      • [0]
        unicode (1412%)
        Example: AGLIETTA
Votes
Dict (100%)
  • dossierid
    'bson.objectid.ObjectId (95%)
    Example: 4ddebaac865c0c17de0004c2
  • Abstain
    Dict (99%)
    • total
      unicode (100%)
      Example: 73
    • correctional
      List (9%)
      • [0]
        Dict (153%)
        • q
          int (100%)
          Example: 2
        • id
          'bson.objectid.ObjectId (100%)
          Example: 4de1851a0fb8127435bdbe85
        • orig
          unicode (100%)
          Example: Louis Grech
      • [0]
        unicode (1%)
        Example: Javier Pomes
    • groups
      List (100%)
      • [0]
        Dict (458%)
        • votes
          List (100%)
          • [0]
            Dict (495%)
            • id
              'bson.objectid.ObjectId (100%)
              Example: 4de182cf0fb8127435bdbb2f
            • orig
              unicode (100%)
              Example: Alvaro
          • [0]
            unicode (0%)
            Example: Niculeşcu
        • group
          unicode (100%)
          Example: ALDE
  • For
    Dict (99%)
    • total
      unicode (100%)
      Example: 405
    • correctional
      List (36%)
      • [0]
        Dict (236%)
        • q
          int (100%)
          Example: 2
        • id
          'bson.objectid.ObjectId (100%)
          Example: 4de183b00fb8127435bdbc74
        • orig
          unicode (100%)
          Example: Marie-Arlette Carlotti
      • [0]
        unicode (1%)
        Example: groupe Verts/ALE
    • groups
      List (100%)
      • [0]
        Dict (738%)
        • votes
          List (100%)
          • [0]
            Dict (4904%)
            • id
              'bson.objectid.ObjectId (100%)
              Example: 4de183e20fb8127435bdbcc3
            • orig
              unicode (100%)
              Example: Chiesa
          • [0]
            unicode (0%)
            Example: Jordan amCizelj
        • group
          unicode (100%)
          Example: ALDE
  • title
    unicode (100%)
    Example: Morillon report A6-0001/2004 - amended proposal
  • ts
    datetime.datetime (100%)
    Example: 2004-09-15 12:11:38
  • Against
    Dict (98%)
    • total
      unicode (100%)
      Example: 63
    • correctional
      List (27%)
      • [0]
        Dict (213%)
        • q
          int (100%)
          Example: 2
        • id
          'bson.objectid.ObjectId (100%)
          Example: 4de1888c0fb8127435bdc36d
        • orig
          unicode (100%)
          Example: Jean Spautz
      • [0]
        unicode (5%)
        Example: EvaBritt Svensson
    • groups
      List (100%)
      • [0]
        Dict (589%)
        • votes
          List (100%)
          • [0]
            Dict (3773%)
            • id
              'bson.objectid.ObjectId (100%)
              Example: 4de183e00fb8127435bdbcbf
            • orig
              unicode (100%)
              Example: Cavada
          • [0]
            unicode (0%)
            Example: Niculeşcu
        • group
          unicode (100%)
          Example: ALDE
  • issue_type
    unicode (99%)
    Example: amended proposal
  • RC
    bool (11%)
    Example: True
  • report
    unicode (96%)
    Example: A6-0001/2004
  • _id
    'bson.objectid.ObjectId (100%)
    Example: 4dfe4104e703a846c857df83
  • rapporteur
    List (100%)
    • [0]
      Dict (73%)
      • ref
        'bson.objectid.ObjectId (100%)
        Example: 4de186d10fb8127435bdc0f1
      • name
        unicode (100%)
        Example: Morillon
Committee Meetings
Dict (100%)
  • src
    unicode (100%)
    Example: http://www.europarl.europa.eu/meetdocs/2009_2014/documents/afet/dv/201/201107/20110712_bric_prog_en.pdf
  • docref
    'bson.objectid.ObjectId (37%)
    Example: 4dde8d0d865c0c0dfc000040
  • tabling_deadline
    datetime.datetime (13%)
    Example: 2011-07-13 17:30:00
  • committee
    unicode (100%)
    Example: AFET
  • title
    unicode (100%)
    Example: 00 - 16.10 Cyrill Nunn - Ministry of Foreign Affairs of Germany, Managing Director for Asian Affairs The relevance of the BRICS in foreign policy terms: reflections on the
  • comdoc
    unicode (27%)
    Example: COM(2011)0228
  • epdoc
    unicode (37%)
    Example: BUD/2011/2020
  • Responsible
    List (38%)
    • [0]
      Dict (100%)
      • docs
        List (100%)
        • [0]
          List (51%)
          • [0]
            unicode (200%)
            Example: PR
      • rapporteurs
        List (100%)
        • [0]
          'bson.objectid.ObjectId (60%)
          Example: 4de183720fb8127435bdbc19
      • committee
        unicode (100%)
        Example: BUDG
  • Misc
    List (54%)
    • [0]
      unicode (140%)
      Example: 2 May 2011 PV – PE462.793v01-00
  • otherdoc
    unicode (13%)
    Example: C7-0116/2011
  • seq_no
    int (100%)
    Example: 16
  • procedure
    unicode (12%)
    Example: ***
  • meeting_date
    datetime.datetime (100%)
    Example: 2011-07-12 00:00:00
  • Opinions
    List (17%)
    • [0]
      Dict (291%)
      • docs
        List (100%)
        • [0]
          List (67%)
          • [0]
            unicode (200%)
            Example: AD
      • rapporteurs
        List (100%)
        • [0]
          'bson.objectid.ObjectId (44%)
          Example: 4de188d90fb8127435bdc3d8
      • response
        unicode (22%)
        Example: Decision: no opinion
      • committee
        unicode (100%)
        Example: ENVI
  • _id
    'bson.objectid.ObjectId (100%)
    Example: 4e190697e95be483479fe229
  • comdossier
    unicode (50%)
    Example: DEVE/7/06313
  • reading
    unicode (9%)
    Example: I
  • Rapporteur
    Dict (40%)
    • docs
      List (100%)
      • [0]
        List (133%)
        • [0]
          unicode (200%)
          Example: PA
    • rapporteurs
      List (100%)
      • [0]
        'bson.objectid.ObjectId (98%)
        Example: 4de184ec0fb8127435bdbe3f