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 |
|---|---|---|---|---|---|---|---|---|
| 16060000088080 | L16/dossiers | 16 | 16060000088077 | 16060000088077 | 3 | PO814996 | ||
| 16060000088082 | L16/dossiers | 16 | 16060000088081 | 16060000088081 | 1 | PA736202 | rapporteur | |
| 16060000088083 | L16/dossiers | 16 | 16060000088081 | 16060000088081 | 2 | PO516753 | ||
| 16060000088085 | L16/dossiers | 16 | 16060000088084 | 16060000088084 | 1 | PA429875 | rapporteur | |
| 16060000088086 | L16/dossiers | 16 | 16060000088084 | 16060000088084 | 2 | PA415448 | rapporteur | |
| 16060000088087 | L16/dossiers | 16 | 16060000088084 | 16060000088084 | 3 | PO211494 | ||
| 16060000088089 | L16/dossiers | 16 | 16060000088088 | 16060000088088 | 1 | PA775184 | rapporteur | |
| 16060000088090 | L16/dossiers | 16 | 16060000088088 | 16060000088088 | 2 | PO211494 | ||
| 16060000088092 | L16/dossiers | 16 | 16060000088091 | 16060000088091 | 1 | PA267081 | rapporteur | |
| 16060000088093 | L16/dossiers | 16 | 16060000088091 | 16060000088091 | 2 | PO211493 | ||
| 16060000088095 | L16/dossiers | 16 | 16060000088094 | 16060000088094 | 1 | PA426327 | rapporteur | |
| 16060000088096 | L16/dossiers | 16 | 16060000088094 | 16060000088094 | 2 | PO211495 | ||
| 16060000088098 | L16/dossiers | 16 | 16060000088097 | 16060000088097 | 1 | PA429889 | rapporteur | |
| 16060000088099 | L16/dossiers | 16 | 16060000088097 | 16060000088097 | 2 | PO211493 | ||
| 16060000088101 | L16/dossiers | 16 | 16060000088100 | 16060000088100 | 1 | PA703510 | rapporteur | |
| 16060000088102 | L16/dossiers | 16 | 16060000088100 | 16060000088100 | 2 | PO211495 | ||
| 16060000088104 | L16/dossiers | 16 | 16060000088103 | 16060000088103 | 1 | PA736177 | rapporteur | |
| 16060000088105 | L16/dossiers | 16 | 16060000088103 | 16060000088103 | 2 | PO211491 | ||
| 16060000088107 | L16/dossiers | 16 | 16060000088106 | 16060000088106 | 1 | PA736169 | rapporteur | |
| 16060000088108 | L16/dossiers | 16 | 16060000088106 | 16060000088106 | 2 | PO211495 | ||
| 16060000088110 | L16/dossiers | 16 | 16060000088109 | 16060000088109 | 1 | PA736207 | rapporteur | |
| 16060000088111 | L16/dossiers | 16 | 16060000088109 | 16060000088109 | 2 | PO211493 | ||
| 16060000088113 | L16/dossiers | 16 | 16060000088112 | 16060000088112 | 1 | PA703523 | rapporteur | |
| 16060000088114 | L16/dossiers | 16 | 16060000088112 | 16060000088112 | 2 | PO516753 | ||
| 16060000088116 | L16/dossiers | 16 | 16060000088115 | 16060000088115 | 1 | PA703515 | rapporteur | |
| 16060000088117 | L16/dossiers | 16 | 16060000088115 | 16060000088115 | 2 | PO211493 | ||
| 16060000088119 | L16/dossiers | 16 | 16060000088118 | 16060000088118 | 1 | PA736206 | rapporteur | |
| 16060000088120 | L16/dossiers | 16 | 16060000088118 | 16060000088118 | 2 | PO211493 | ||
| 16060000088122 | L16/dossiers | 16 | 16060000088121 | 16060000088121 | 1 | PA720634 | rapporteur | |
| 16060000088123 | L16/dossiers | 16 | 16060000088121 | 16060000088121 | 2 | PO211491 | ||
| 16060000088125 | L16/dossiers | 16 | 16060000088124 | 16060000088124 | 1 | PA267081 | rapporteur | |
| 16060000088126 | L16/dossiers | 16 | 16060000088124 | 16060000088124 | 2 | PO816676 | ||
| 16060000088128 | L16/dossiers | 16 | 16060000088127 | 16060000088127 | 1 | PA773891 | rapporteur | |
| 16060000088129 | L16/dossiers | 16 | 16060000088127 | 16060000088127 | 2 | PO211495 | ||
| 16060000088131 | L16/dossiers | 16 | 16060000088130 | 16060000088130 | 1 | PA703498 | rapporteur | |
| 16060000088132 | L16/dossiers | 16 | 16060000088130 | 16060000088130 | 2 | PA429851 | rapporteur | |
| 16060000088133 | L16/dossiers | 16 | 16060000088130 | 16060000088130 | 3 | PO211493 | ||
| 16060000088135 | L16/dossiers | 16 | 16060000088134 | 16060000088134 | 1 | PA703492 | rapporteur | |
| 16060000088136 | L16/dossiers | 16 | 16060000088134 | 16060000088134 | 2 | PO211495 | ||
| 16060000088138 | L16/dossiers | 16 | 16060000088137 | 16060000088137 | 1 | PA775178 | rapporteur | |
| 16060000088139 | L16/dossiers | 16 | 16060000088137 | 16060000088137 | 2 | PO211495 | ||
| 16060000088141 | L16/dossiers | 16 | 16060000088140 | 16060000088140 | 1 | PA267512 | rapporteur | |
| 16060000088142 | L16/dossiers | 16 | 16060000088140 | 16060000088140 | 2 | PO211495 | ||
| 16060000088144 | L16/dossiers | 16 | 16060000088143 | 16060000088143 | 1 | PA708632 | rapporteur | |
| 16060000088145 | L16/dossiers | 16 | 16060000088143 | 16060000088143 | 2 | PO211495 | ||
| 16060000088147 | L16/dossiers | 16 | 16060000088146 | 16060000088146 | 1 | PA775226 | rapporteur | |
| 16060000088148 | L16/dossiers | 16 | 16060000088146 | 16060000088146 | 2 | PO211490 | ||
| 16060000088150 | L16/dossiers | 16 | 16060000088149 | 16060000088149 | 1 | PA330684 | rapporteur | |
| 16060000088151 | L16/dossiers | 16 | 16060000088149 | 16060000088149 | 2 | PO211495 | ||
| 16060000088153 | L16/dossiers | 16 | 16060000088152 | 16060000088152 | 1 | PA429835 | rapporteur |