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 |
|---|---|---|---|---|---|---|---|---|
| 16060000088154 | L16/dossiers | 16 | 16060000088152 | 16060000088152 | 2 | PO211491 | ||
| 16060000088156 | L16/dossiers | 16 | 16060000088155 | 16060000088155 | 1 | PA721130 | rapporteur | |
| 16060000088157 | L16/dossiers | 16 | 16060000088155 | 16060000088155 | 2 | PO516753 | ||
| 16060000088159 | L16/dossiers | 16 | 16060000088158 | 16060000088158 | 1 | PA703534 | rapporteur | |
| 16060000088160 | L16/dossiers | 16 | 16060000088158 | 16060000088158 | 2 | PO211493 | ||
| 16060000088162 | L16/dossiers | 16 | 16060000088161 | 16060000088161 | 1 | PA775184 | rapporteur | |
| 16060000088163 | L16/dossiers | 16 | 16060000088161 | 16060000088161 | 2 | PO765977 | ||
| 16060000088165 | L16/dossiers | 16 | 16060000088164 | 16060000088164 | 1 | PA736169 | rapporteur | |
| 16060000088166 | L16/dossiers | 16 | 16060000088164 | 16060000088164 | 2 | PO820607 | ||
| 16060000088168 | L16/dossiers | 16 | 16060000088167 | 16060000088167 | 1 | PA736197 | rapporteur | |
| 16060000088169 | L16/dossiers | 16 | 16060000088167 | 16060000088167 | 2 | PO516754 | ||
| 16060000088171 | L16/dossiers | 16 | 16060000088170 | 16060000088170 | 1 | PA703523 | rapporteur | |
| 16060000088172 | L16/dossiers | 16 | 16060000088170 | 16060000088170 | 2 | PO820592 | ||
| 16060000088174 | L16/dossiers | 16 | 16060000088173 | 16060000088173 | 1 | PA736173 | rapporteur | |
| 16060000088175 | L16/dossiers | 16 | 16060000088173 | 16060000088173 | 2 | PO211491 | ||
| 16060000088177 | L16/dossiers | 16 | 16060000088176 | 16060000088176 | 1 | PA736205 | rapporteur | |
| 16060000088178 | L16/dossiers | 16 | 16060000088176 | 16060000088176 | 2 | PA569 | rapporteur | |
| 16060000088179 | L16/dossiers | 16 | 16060000088176 | 16060000088176 | 3 | PO211495 | ||
| 16060000088181 | L16/dossiers | 16 | 16060000088180 | 16060000088180 | 1 | PA703498 | rapporteur | |
| 16060000088182 | L16/dossiers | 16 | 16060000088180 | 16060000088180 | 2 | PA429851 | rapporteur | |
| 16060000088183 | L16/dossiers | 16 | 16060000088180 | 16060000088180 | 3 | PO821760 | ||
| 16060000088185 | L16/dossiers | 16 | 16060000088184 | 16060000088184 | 1 | PA703523 | rapporteur | |
| 16060000088186 | L16/dossiers | 16 | 16060000088184 | 16060000088184 | 2 | PA767418 | rapporteur | |
| 16060000088187 | L16/dossiers | 16 | 16060000088184 | 16060000088184 | 3 | PA775276 | rapporteur | |
| 16060000088188 | L16/dossiers | 16 | 16060000088184 | 16060000088184 | 4 | PO765977 | ||
| 16060000088190 | L16/dossiers | 16 | 16060000088189 | 16060000088189 | 1 | PA775220 | rapporteur | |
| 16060000088191 | L16/dossiers | 16 | 16060000088189 | 16060000088189 | 2 | PO211495 | ||
| 16060000088193 | L16/dossiers | 16 | 16060000088192 | 16060000088192 | 1 | PA1993 | rapporteur | |
| 16060000088194 | L16/dossiers | 16 | 16060000088192 | 16060000088192 | 2 | PO211494 | ||
| 16060000088196 | L16/dossiers | 16 | 16060000088195 | 16060000088195 | 1 | PA703494 | rapporteur | |
| 16060000088197 | L16/dossiers | 16 | 16060000088195 | 16060000088195 | 2 | PO211495 | ||
| 16060000088199 | L16/dossiers | 16 | 16060000088198 | 16060000088198 | 1 | PA703510 | rapporteur | |
| 16060000088200 | L16/dossiers | 16 | 16060000088198 | 16060000088198 | 2 | PO211495 | ||
| 16060000088202 | L16/dossiers | 16 | 16060000088201 | 16060000088201 | 1 | PA744079 | rapporteur | |
| 16060000088203 | L16/dossiers | 16 | 16060000088201 | 16060000088201 | 2 | PO211494 | ||
| 16060000088205 | L16/dossiers | 16 | 16060000088204 | 16060000088204 | 1 | PA775236 | rapporteur | |
| 16060000088206 | L16/dossiers | 16 | 16060000088204 | 16060000088204 | 2 | PO211490 | ||
| 16060000088208 | L16/dossiers | 16 | 16060000088207 | 16060000088207 | 1 | PA757676 | rapporteur | |
| 16060000088209 | L16/dossiers | 16 | 16060000088207 | 16060000088207 | 2 | PO211493 | ||
| 16060000088211 | L16/dossiers | 16 | 16060000088210 | 16060000088210 | 1 | PA736197 | rapporteur | |
| 16060000088212 | L16/dossiers | 16 | 16060000088210 | 16060000088210 | 2 | PO822133 | ||
| 16060000088214 | L16/dossiers | 16 | 16060000088213 | 16060000088213 | 1 | PA703510 | rapporteur | |
| 16060000088215 | L16/dossiers | 16 | 16060000088213 | 16060000088213 | 2 | PO822403 | ||
| 16060000088217 | L16/dossiers | 16 | 16060000088216 | 16060000088216 | 1 | PA331381 | rapporteur | |
| 16060000088218 | L16/dossiers | 16 | 16060000088216 | 16060000088216 | 2 | PO211490 | ||
| 16060000088220 | L16/dossiers | 16 | 16060000088219 | 16060000088219 | 1 | PA703515 | rapporteur | |
| 16060000088221 | L16/dossiers | 16 | 16060000088219 | 16060000088219 | 2 | PO821826 | ||
| 16060000088223 | L16/dossiers | 16 | 16060000088222 | 16060000088222 | 1 | PA775212 | rapporteur | |
| 16060000088224 | L16/dossiers | 16 | 16060000088222 | 16060000088222 | 2 | PO516754 | ||
| 16060000088226 | L16/dossiers | 16 | 16060000088225 | 16060000088225 | 1 | PA736165 | rapporteur |