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 |
|---|---|---|---|---|---|---|---|---|
| 16060000084136 | L16/dossiers | 16 | 16060000084135 | 16060000084135 | 1 | PO78718 | ||
| 16060000084138 | L16/dossiers | 16 | 16060000084137 | 16060000084137 | 1 | PO78718 | ||
| 16060000084140 | L16/dossiers | 16 | 16060000084139 | 16060000084139 | 1 | PO78718 | ||
| 16060000084142 | L16/dossiers | 16 | 16060000084141 | 16060000084141 | 1 | PO78718 | ||
| 16060000084144 | L16/dossiers | 16 | 16060000084143 | 16060000084143 | 1 | PA736173 | rapporteur | |
| 16060000084145 | L16/dossiers | 16 | 16060000084143 | 16060000084143 | 2 | PO211491 | ||
| 16060000084147 | L16/dossiers | 16 | 16060000084146 | 16060000084146 | 1 | PA267673 | rapporteur | |
| 16060000084148 | L16/dossiers | 16 | 16060000084146 | 16060000084146 | 2 | PO211491 | ||
| 16060000084150 | L16/dossiers | 16 | 16060000084149 | 16060000084149 | 1 | PA1001 | rapporteur | |
| 16060000084151 | L16/dossiers | 16 | 16060000084149 | 16060000084149 | 2 | PA703492 | rapporteur | |
| 16060000084152 | L16/dossiers | 16 | 16060000084149 | 16060000084149 | 3 | PO211495 | ||
| 16060000084154 | L16/dossiers | 16 | 16060000084153 | 16060000084153 | 1 | PA736239 | rapporteur | |
| 16060000084155 | L16/dossiers | 16 | 16060000084153 | 16060000084153 | 2 | PA736223 | rapporteur | |
| 16060000084156 | L16/dossiers | 16 | 16060000084153 | 16060000084153 | 3 | PO211493 | ||
| 16060000084158 | L16/dossiers | 16 | 16060000084157 | 16060000084157 | 1 | PA227096 | rapporteur | |
| 16060000084159 | L16/dossiers | 16 | 16060000084157 | 16060000084157 | 2 | PO211491 | ||
| 16060000084161 | L16/dossiers | 16 | 16060000084160 | 16060000084160 | 1 | PA775234 | rapporteur | |
| 16060000084162 | L16/dossiers | 16 | 16060000084160 | 16060000084160 | 2 | PO211491 | ||
| 16060000084164 | L16/dossiers | 16 | 16060000084163 | 16060000084163 | 1 | PA429875 | rapporteur | |
| 16060000084165 | L16/dossiers | 16 | 16060000084163 | 16060000084163 | 2 | PO211494 | ||
| 16060000084167 | L16/dossiers | 16 | 16060000084166 | 16060000084166 | 1 | PA736239 | rapporteur | |
| 16060000084168 | L16/dossiers | 16 | 16060000084166 | 16060000084166 | 2 | PA736223 | rapporteur | |
| 16060000084169 | L16/dossiers | 16 | 16060000084166 | 16060000084166 | 3 | PO805375 | ||
| 16060000084171 | L16/dossiers | 16 | 16060000084170 | 16060000084170 | 1 | PA703498 | rapporteur | |
| 16060000084172 | L16/dossiers | 16 | 16060000084170 | 16060000084170 | 2 | PO805843 | ||
| 16060000084174 | L16/dossiers | 16 | 16060000084173 | 16060000084173 | 1 | PA429875 | rapporteur | |
| 16060000084175 | L16/dossiers | 16 | 16060000084173 | 16060000084173 | 2 | PO806027 | ||
| 16060000084177 | L16/dossiers | 16 | 16060000084176 | 16060000084176 | 1 | PA1001 | rapporteur | |
| 16060000084178 | L16/dossiers | 16 | 16060000084176 | 16060000084176 | 2 | PA703492 | rapporteur | |
| 16060000084179 | L16/dossiers | 16 | 16060000084176 | 16060000084176 | 3 | PO806155 | ||
| 16060000084181 | L16/dossiers | 16 | 16060000084180 | 16060000084180 | 1 | PA429875 | rapporteur | |
| 16060000084182 | L16/dossiers | 16 | 16060000084180 | 16060000084180 | 2 | PO806365 | ||
| 16060000084184 | L16/dossiers | 16 | 16060000084183 | 16060000084183 | 1 | PA267081 | rapporteur | |
| 16060000084185 | L16/dossiers | 16 | 16060000084183 | 16060000084183 | 2 | PO211493 | ||
| 16060000084187 | L16/dossiers | 16 | 16060000084186 | 16060000084186 | 1 | PA429875 | rapporteur | |
| 16060000084188 | L16/dossiers | 16 | 16060000084186 | 16060000084186 | 2 | PO806319 | ||
| 16060000084190 | L16/dossiers | 16 | 16060000084189 | 16060000084189 | 1 | PA703530 | rapporteur | |
| 16060000084191 | L16/dossiers | 16 | 16060000084189 | 16060000084189 | 2 | PO516753 | ||
| 16060000084193 | L16/dossiers | 16 | 16060000084192 | 16060000084192 | 1 | PA703510 | rapporteur | |
| 16060000084194 | L16/dossiers | 16 | 16060000084192 | 16060000084192 | 2 | PO211495 | ||
| 16060000084196 | L16/dossiers | 16 | 16060000084195 | 16060000084195 | 1 | PA736186 | rapporteur | |
| 16060000084197 | L16/dossiers | 16 | 16060000084195 | 16060000084195 | 2 | PO211491 | ||
| 16060000084199 | L16/dossiers | 16 | 16060000084198 | 16060000084198 | 1 | PA736240 | rapporteur | |
| 16060000084200 | L16/dossiers | 16 | 16060000084198 | 16060000084198 | 2 | PO211491 | ||
| 16060000084202 | L16/dossiers | 16 | 16060000084201 | 16060000084201 | 1 | PA775234 | rapporteur | |
| 16060000084203 | L16/dossiers | 16 | 16060000084201 | 16060000084201 | 2 | PO211491 | ||
| 16060000084205 | L16/dossiers | 16 | 16060000084204 | 16060000084204 | 1 | PA703540 | rapporteur | |
| 16060000084206 | L16/dossiers | 16 | 16060000084204 | 16060000084204 | 2 | PO211491 | ||
| 16060000084208 | L16/dossiers | 16 | 16060000084207 | 16060000084207 | 1 | PA429842 | rapporteur | |
| 16060000084209 | L16/dossiers | 16 | 16060000084207 | 16060000084207 | 2 | PA703497 | rapporteur |