dossiers.document_auteur
Chemin document.auteurs.auteur · présence : L17 100 %, L16 100 %, L15 100 %, L14 100 %
59 600 lignes (estimation)
Colonnes
| # | Colonne | Type | Commentaire |
|---|---|---|---|
| 1 | _id | BIGINT | identifiant : code de la source × 10¹⁰ + rang |
| 2 | _source | VARCHAR | source du catalogue (catalogue.py) |
| 3 | _legislature | BIGINT | colonne constante de la source |
| 4 | _racine_id | BIGINT | _id de la ligne racine |
| 5 | _parent_id | BIGINT | _id de la ligne parente |
| 6 | _ordre | BIGINT | rang dans le tableau d'origine (1…) |
| 7 | acteur_acteur_ref | VARCHAR | document.auteurs.auteur.acteur.acteurRef · présence : L17 71 %, L16 72 %, L15 74 %, L14 86 % |
| 8 | acteur_qualite | VARCHAR | document.auteurs.auteur.acteur.qualite · présence : L17 71 %, L16 72 %, L15 74 %, L14 86 % · XSD 2016 : Rapporteur, rapporteur pour avis, général, spécial, intervenant. Ne pas mettre auteur et cosignataire. Utilisé également pour la spécialité du rapporteur sur le PLF |
| 9 | organe_organe_ref | VARCHAR | document.auteurs.auteur.organe.organeRef · présence : L17 59 %, L16 58 %, L15 56 %, L14 56 % |
Aperçu
| _id | _source | _legislature | _racine_id | _parent_id | _ordre | acteur_acteur_ref | acteur_qualite | organe_organe_ref |
|---|---|---|---|---|---|---|---|---|
| 17060000109983 | L17/dossiers | 17 | 17060000109982 | 17060000109982 | 1 | PA775286 | rapporteur | |
| 17060000109984 | L17/dossiers | 17 | 17060000109982 | 17060000109982 | 2 | PO211495 | ||
| 17060000109986 | L17/dossiers | 17 | 17060000109985 | 17060000109985 | 1 | PA267081 | rapporteur | |
| 17060000109987 | L17/dossiers | 17 | 17060000109985 | 17060000109985 | 2 | PO211493 | ||
| 17060000109989 | L17/dossiers | 17 | 17060000109988 | 17060000109988 | 1 | PA828008 | rapporteur | |
| 17060000109990 | L17/dossiers | 17 | 17060000109988 | 17060000109988 | 2 | PO211495 | ||
| 17060000109992 | L17/dossiers | 17 | 17060000109991 | 17060000109991 | 1 | PA827954 | rapporteur | |
| 17060000109993 | L17/dossiers | 17 | 17060000109991 | 17060000109991 | 2 | PO835801 | ||
| 17060000109995 | L17/dossiers | 17 | 17060000109994 | 17060000109994 | 1 | PA775292 | rapporteur | |
| 17060000109996 | L17/dossiers | 17 | 17060000109994 | 17060000109994 | 2 | PO516754 | ||
| 17060000109998 | L17/dossiers | 17 | 17060000109997 | 17060000109997 | 1 | PA426327 | rapporteur | |
| 17060000109999 | L17/dossiers | 17 | 17060000109997 | 17060000109997 | 2 | PO211495 | ||
| 17060000110001 | L17/dossiers | 17 | 17060000110000 | 17060000110000 | 1 | PA703511 | rapporteur | |
| 17060000110002 | L17/dossiers | 17 | 17060000110000 | 17060000110000 | 2 | PO211490 | ||
| 17060000110004 | L17/dossiers | 17 | 17060000110003 | 17060000110003 | 1 | PA703495 | rapporteur | |
| 17060000110005 | L17/dossiers | 17 | 17060000110003 | 17060000110003 | 2 | PO516754 | ||
| 17060000110007 | L17/dossiers | 17 | 17060000110006 | 17060000110006 | 1 | PA770871 | rapporteur | |
| 17060000110008 | L17/dossiers | 17 | 17060000110006 | 17060000110006 | 2 | PO211493 | ||
| 17060000110010 | L17/dossiers | 17 | 17060000110009 | 17060000110009 | 1 | PA703494 | rapporteur | |
| 17060000110011 | L17/dossiers | 17 | 17060000110009 | 17060000110009 | 2 | PO835829 | ||
| 17060000110013 | L17/dossiers | 17 | 17060000110012 | 17060000110012 | 1 | PA827954 | rapporteur | |
| 17060000110014 | L17/dossiers | 17 | 17060000110012 | 17060000110012 | 2 | PO211493 | ||
| 17060000110016 | L17/dossiers | 17 | 17060000110015 | 17060000110015 | 1 | PA415446 | rapporteur | |
| 17060000110017 | L17/dossiers | 17 | 17060000110015 | 17060000110015 | 2 | PO211494 | ||
| 17060000110019 | L17/dossiers | 17 | 17060000110018 | 17060000110018 | 1 | PA758716 | rapporteur | |
| 17060000110020 | L17/dossiers | 17 | 17060000110018 | 17060000110018 | 2 | PO516753 | ||
| 17060000110022 | L17/dossiers | 17 | 17060000110021 | 17060000110021 | 1 | PA703510 | rapporteur | |
| 17060000110023 | L17/dossiers | 17 | 17060000110021 | 17060000110021 | 2 | PO211495 | ||
| 17060000110025 | L17/dossiers | 17 | 17060000110024 | 17060000110024 | 1 | PA736202 | rapporteur | |
| 17060000110026 | L17/dossiers | 17 | 17060000110024 | 17060000110024 | 2 | PO516753 | ||
| 17060000110028 | L17/dossiers | 17 | 17060000110027 | 17060000110027 | 1 | PA827968 | rapporteur | |
| 17060000110029 | L17/dossiers | 17 | 17060000110027 | 17060000110027 | 2 | PO211491 | ||
| 17060000110031 | L17/dossiers | 17 | 17060000110030 | 17060000110030 | 1 | PA736227 | rapporteur | |
| 17060000110032 | L17/dossiers | 17 | 17060000110030 | 17060000110030 | 2 | PO211491 | ||
| 17060000110034 | L17/dossiers | 17 | 17060000110033 | 17060000110033 | 1 | PA736211 | rapporteur | |
| 17060000110035 | L17/dossiers | 17 | 17060000110033 | 17060000110033 | 2 | PO211494 | ||
| 17060000110037 | L17/dossiers | 17 | 17060000110036 | 17060000110036 | 1 | PA429886 | rapporteur | |
| 17060000110038 | L17/dossiers | 17 | 17060000110036 | 17060000110036 | 2 | PO211495 | ||
| 17060000110040 | L17/dossiers | 17 | 17060000110039 | 17060000110039 | 1 | PA827972 | rapporteur | |
| 17060000110041 | L17/dossiers | 17 | 17060000110039 | 17060000110039 | 2 | PO211493 | ||
| 17060000110043 | L17/dossiers | 17 | 17060000110042 | 17060000110042 | 1 | PA827986 | rapporteur | |
| 17060000110044 | L17/dossiers | 17 | 17060000110042 | 17060000110042 | 2 | PO516754 | ||
| 17060000110046 | L17/dossiers | 17 | 17060000110045 | 17060000110045 | 1 | PA2197 | rapporteur | |
| 17060000110047 | L17/dossiers | 17 | 17060000110045 | 17060000110045 | 2 | PO211493 | ||
| 17060000110049 | L17/dossiers | 17 | 17060000110048 | 17060000110048 | 1 | PA703494 | rapporteur | |
| 17060000110050 | L17/dossiers | 17 | 17060000110048 | 17060000110048 | 2 | PA827906 | rapporteur | |
| 17060000110051 | L17/dossiers | 17 | 17060000110048 | 17060000110048 | 3 | PO765977 | ||
| 17060000110053 | L17/dossiers | 17 | 17060000110052 | 17060000110052 | 1 | PA775204 | rapporteur | |
| 17060000110054 | L17/dossiers | 17 | 17060000110052 | 17060000110052 | 2 | PA775208 | rapporteur | |
| 17060000110055 | L17/dossiers | 17 | 17060000110052 | 17060000110052 | 3 | PO516753 |