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 |
|---|---|---|---|---|---|---|---|---|
| 17060000109086 | L17/dossiers | 17 | 17060000109085 | 17060000109085 | 1 | PA793218 | rapporteur | |
| 17060000109087 | L17/dossiers | 17 | 17060000109085 | 17060000109085 | 2 | PO415287 | ||
| 17060000109092 | L17/dossiers | 17 | 17060000109088 | 17060000109088 | 1 | PA2952 | rapporteur | |
| 17060000109093 | L17/dossiers | 17 | 17060000109088 | 17060000109088 | 2 | PO420120 | ||
| 17060000109098 | L17/dossiers | 17 | 17060000109094 | 17060000109094 | 1 | PA719138 | rapporteur | |
| 17060000109099 | L17/dossiers | 17 | 17060000109094 | 17060000109094 | 2 | PO59048 | ||
| 17060000109104 | L17/dossiers | 17 | 17060000109100 | 17060000109100 | 1 | PA227089 | rapporteur | |
| 17060000109105 | L17/dossiers | 17 | 17060000109100 | 17060000109100 | 2 | PO419610 | ||
| 17060000109110 | L17/dossiers | 17 | 17060000109106 | 17060000109106 | 1 | PA794486 | rapporteur | |
| 17060000109111 | L17/dossiers | 17 | 17060000109106 | 17060000109106 | 2 | PO419604 | ||
| 17060000109116 | L17/dossiers | 17 | 17060000109112 | 17060000109112 | 1 | PA795762 | rapporteur | |
| 17060000109117 | L17/dossiers | 17 | 17060000109112 | 17060000109112 | 2 | PO420120 | ||
| 17060000109119 | L17/dossiers | 17 | 17060000109118 | 17060000109118 | 1 | PA719338 | rapporteur | |
| 17060000109120 | L17/dossiers | 17 | 17060000109118 | 17060000109118 | 2 | PO419865 | ||
| 17060000109125 | L17/dossiers | 17 | 17060000109121 | 17060000109121 | 1 | PA840997 | rapporteur | |
| 17060000109126 | L17/dossiers | 17 | 17060000109121 | 17060000109121 | 2 | PO419610 | ||
| 17060000109131 | L17/dossiers | 17 | 17060000109127 | 17060000109127 | 1 | PA2952 | rapporteur | |
| 17060000109132 | L17/dossiers | 17 | 17060000109127 | 17060000109127 | 2 | PO59051 | ||
| 17060000109137 | L17/dossiers | 17 | 17060000109133 | 17060000109133 | 1 | PA794710 | rapporteur | |
| 17060000109138 | L17/dossiers | 17 | 17060000109133 | 17060000109133 | 2 | PO420120 | ||
| 17060000109140 | L17/dossiers | 17 | 17060000109139 | 17060000109139 | 1 | PA720952 | rapporteur | |
| 17060000109141 | L17/dossiers | 17 | 17060000109139 | 17060000109139 | 2 | PO59047 | ||
| 17060000109149 | L17/dossiers | 17 | 17060000109142 | 17060000109142 | 1 | PA346782 | rapporteur | |
| 17060000109150 | L17/dossiers | 17 | 17060000109142 | 17060000109142 | 2 | PO59048 | ||
| 17060000109152 | L17/dossiers | 17 | 17060000109151 | 17060000109151 | 1 | PA342415 | rapporteur | |
| 17060000109153 | L17/dossiers | 17 | 17060000109151 | 17060000109151 | 2 | PO881031 | ||
| 17060000109161 | L17/dossiers | 17 | 17060000109154 | 17060000109154 | 1 | PA793354 | rapporteur | |
| 17060000109162 | L17/dossiers | 17 | 17060000109154 | 17060000109154 | 2 | PO877008 | ||
| 17060000109164 | L17/dossiers | 17 | 17060000109163 | 17060000109163 | 1 | PA720446 | rapporteur | |
| 17060000109165 | L17/dossiers | 17 | 17060000109163 | 17060000109163 | 2 | PO881963 | ||
| 17060000109167 | L17/dossiers | 17 | 17060000109166 | 17060000109166 | 1 | PA720838 | rapporteur | |
| 17060000109168 | L17/dossiers | 17 | 17060000109166 | 17060000109166 | 2 | PO419604 | ||
| 17060000109170 | L17/dossiers | 17 | 17060000109169 | 17060000109169 | 1 | PA642847 | rapporteur | |
| 17060000109171 | L17/dossiers | 17 | 17060000109169 | 17060000109169 | 2 | PO420120 | ||
| 17060000109173 | L17/dossiers | 17 | 17060000109172 | 17060000109172 | 1 | PA842271 | rapporteur | |
| 17060000109174 | L17/dossiers | 17 | 17060000109172 | 17060000109172 | 2 | PO419604 | ||
| 17060000109179 | L17/dossiers | 17 | 17060000109175 | 17060000109175 | 1 | PA606507 | rapporteur | |
| 17060000109180 | L17/dossiers | 17 | 17060000109175 | 17060000109175 | 2 | PO59051 | ||
| 17060000109185 | L17/dossiers | 17 | 17060000109181 | 17060000109181 | 1 | PA796010 | rapporteur | |
| 17060000109186 | L17/dossiers | 17 | 17060000109181 | 17060000109181 | 2 | PO420120 | ||
| 17060000109191 | L17/dossiers | 17 | 17060000109187 | 17060000109187 | 1 | PA774962 | rapporteur | |
| 17060000109192 | L17/dossiers | 17 | 17060000109187 | 17060000109187 | 2 | PO420120 | ||
| 17060000109194 | L17/dossiers | 17 | 17060000109193 | 17060000109193 | 1 | PA795868 | rapporteur | |
| 17060000109195 | L17/dossiers | 17 | 17060000109193 | 17060000109193 | 2 | PO419610 | ||
| 17060000109197 | L17/dossiers | 17 | 17060000109196 | 17060000109196 | 1 | PA793194 | rapporteur | |
| 17060000109198 | L17/dossiers | 17 | 17060000109196 | 17060000109196 | 2 | PO59047 | ||
| 17060000109200 | L17/dossiers | 17 | 17060000109199 | 17060000109199 | 1 | PA840903 | rapporteur | |
| 17060000109201 | L17/dossiers | 17 | 17060000109199 | 17060000109199 | 2 | PO415287 | ||
| 17060000109203 | L17/dossiers | 17 | 17060000109202 | 17060000109202 | 1 | PA795164 | rapporteur | |
| 17060000109204 | L17/dossiers | 17 | 17060000109202 | 17060000109202 | 2 | PA605745 | rapporteur |