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 |
|---|---|---|---|---|---|---|---|---|
| 16060000088991 | L16/dossiers | 16 | 16060000088990 | 16060000088990 | 1 | PA795120 | rapporteur | |
| 16060000088992 | L16/dossiers | 16 | 16060000088990 | 16060000088990 | 2 | PA718860 | rapporteur | |
| 16060000088993 | L16/dossiers | 16 | 16060000088990 | 16060000088990 | 3 | PO419610 | ||
| 16060000088995 | L16/dossiers | 16 | 16060000088994 | 16060000088994 | 1 | PA722336 | rapporteur | |
| 16060000088996 | L16/dossiers | 16 | 16060000088994 | 16060000088994 | 2 | PO419865 | ||
| 16060000088998 | L16/dossiers | 16 | 16060000088997 | 16060000088997 | 1 | PA718710 | rapporteur | |
| 16060000088999 | L16/dossiers | 16 | 16060000088997 | 16060000088997 | 2 | PA643192 | rapporteur | |
| 16060000089000 | L16/dossiers | 16 | 16060000088997 | 16060000088997 | 3 | PO419865 | ||
| 16060000089002 | L16/dossiers | 16 | 16060000089001 | 16060000089001 | 1 | PA722336 | rapporteur | |
| 16060000089003 | L16/dossiers | 16 | 16060000089001 | 16060000089001 | 2 | PA794946 | rapporteur | |
| 16060000089004 | L16/dossiers | 16 | 16060000089001 | 16060000089001 | 3 | PO419865 | ||
| 16060000089006 | L16/dossiers | 16 | 16060000089005 | 16060000089005 | 1 | PA722284 | rapporteur | |
| 16060000089007 | L16/dossiers | 16 | 16060000089005 | 16060000089005 | 2 | PO201115 | ||
| 16060000089009 | L16/dossiers | 16 | 16060000089008 | 16060000089008 | 1 | PA719032 | rapporteur | |
| 16060000089010 | L16/dossiers | 16 | 16060000089008 | 16060000089008 | 2 | PO304272 | ||
| 16060000089012 | L16/dossiers | 16 | 16060000089011 | 16060000089011 | 1 | PA795920 | rapporteur | |
| 16060000089013 | L16/dossiers | 16 | 16060000089011 | 16060000089011 | 2 | PO201269 | ||
| 16060000089015 | L16/dossiers | 16 | 16060000089014 | 16060000089014 | 1 | PA794982 | rapporteur | |
| 16060000089016 | L16/dossiers | 16 | 16060000089014 | 16060000089014 | 2 | PO201269 | ||
| 16060000089018 | L16/dossiers | 16 | 16060000089017 | 16060000089017 | 1 | PA720862 | rapporteur | |
| 16060000089019 | L16/dossiers | 16 | 16060000089017 | 16060000089017 | 2 | PA712015 | rapporteur | |
| 16060000089020 | L16/dossiers | 16 | 16060000089017 | 16060000089017 | 3 | PO419610 | ||
| 16060000089022 | L16/dossiers | 16 | 16060000089021 | 16060000089021 | 1 | PA721170 | rapporteur | |
| 16060000089023 | L16/dossiers | 16 | 16060000089021 | 16060000089021 | 2 | PA643157 | rapporteur | |
| 16060000089024 | L16/dossiers | 16 | 16060000089021 | 16060000089021 | 3 | PO419610 | ||
| 16060000089026 | L16/dossiers | 16 | 16060000089025 | 16060000089025 | 1 | PA342415 | rapporteur | |
| 16060000089027 | L16/dossiers | 16 | 16060000089025 | 16060000089025 | 2 | PA721296 | rapporteur | |
| 16060000089028 | L16/dossiers | 16 | 16060000089025 | 16060000089025 | 3 | PO201269 | ||
| 16060000089030 | L16/dossiers | 16 | 16060000089029 | 16060000089029 | 1 | PA719550 | rapporteur | |
| 16060000089031 | L16/dossiers | 16 | 16060000089029 | 16060000089029 | 2 | PO415287 | ||
| 16060000089033 | L16/dossiers | 16 | 16060000089032 | 16060000089032 | 1 | PA793452 | rapporteur | |
| 16060000089034 | L16/dossiers | 16 | 16060000089032 | 16060000089032 | 2 | PO273589 | ||
| 16060000089036 | L16/dossiers | 16 | 16060000089035 | 16060000089035 | 1 | PA345722 | rapporteur | |
| 16060000089037 | L16/dossiers | 16 | 16060000089035 | 16060000089035 | 2 | PA793354 | rapporteur | |
| 16060000089038 | L16/dossiers | 16 | 16060000089035 | 16060000089035 | 3 | PO415287 | ||
| 16060000089040 | L16/dossiers | 16 | 16060000089039 | 16060000089039 | 1 | PA793940 | rapporteur | |
| 16060000089041 | L16/dossiers | 16 | 16060000089039 | 16060000089039 | 2 | PA608172 | rapporteur | |
| 16060000089042 | L16/dossiers | 16 | 16060000089039 | 16060000089039 | 3 | PO744127 | ||
| 16060000089044 | L16/dossiers | 16 | 16060000089043 | 16060000089043 | 1 | PA718930 | rapporteur | |
| 16060000089045 | L16/dossiers | 16 | 16060000089043 | 16060000089043 | 2 | PA796018 | rapporteur | |
| 16060000089046 | L16/dossiers | 16 | 16060000089043 | 16060000089043 | 3 | PO419610 | ||
| 16060000089048 | L16/dossiers | 16 | 16060000089047 | 16060000089047 | 1 | PA719032 | rapporteur | |
| 16060000089049 | L16/dossiers | 16 | 16060000089047 | 16060000089047 | 2 | PO304272 | ||
| 16060000089051 | L16/dossiers | 16 | 16060000089050 | 16060000089050 | 1 | PA793912 | rapporteur | |
| 16060000089052 | L16/dossiers | 16 | 16060000089050 | 16060000089050 | 2 | PA719718 | rapporteur | |
| 16060000089053 | L16/dossiers | 16 | 16060000089050 | 16060000089050 | 3 | PO419865 | ||
| 16060000089055 | L16/dossiers | 16 | 16060000089054 | 16060000089054 | 1 | PA795672 | rapporteur | |
| 16060000089056 | L16/dossiers | 16 | 16060000089054 | 16060000089054 | 2 | PA712014 | rapporteur | |
| 16060000089057 | L16/dossiers | 16 | 16060000089054 | 16060000089054 | 3 | PO59047 | ||
| 16060000089059 | L16/dossiers | 16 | 16060000089058 | 16060000089058 | 1 | PA719558 | rapporteur |