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 |
|---|---|---|---|---|---|---|---|---|
| 16060000088302 | L16/dossiers | 16 | 16060000088301 | 16060000088301 | 1 | PA703520 | rapporteur | |
| 16060000088303 | L16/dossiers | 16 | 16060000088301 | 16060000088301 | 2 | PO516753 | ||
| 16060000088305 | L16/dossiers | 16 | 16060000088304 | 16060000088304 | 1 | PA703514 | rapporteur | |
| 16060000088306 | L16/dossiers | 16 | 16060000088304 | 16060000088304 | 2 | PO211494 | ||
| 16060000088308 | L16/dossiers | 16 | 16060000088307 | 16060000088307 | 1 | PA703494 | rapporteur | |
| 16060000088309 | L16/dossiers | 16 | 16060000088307 | 16060000088307 | 2 | PO211495 | ||
| 16060000088311 | L16/dossiers | 16 | 16060000088310 | 16060000088310 | 1 | PA426327 | rapporteur | |
| 16060000088312 | L16/dossiers | 16 | 16060000088310 | 16060000088310 | 2 | PO211495 | ||
| 16060000088314 | L16/dossiers | 16 | 16060000088313 | 16060000088313 | 1 | PA736238 | rapporteur | |
| 16060000088315 | L16/dossiers | 16 | 16060000088313 | 16060000088313 | 2 | PO211490 | ||
| 16060000088317 | L16/dossiers | 16 | 16060000088316 | 16060000088316 | 1 | PA747422 | rapporteur | |
| 16060000088318 | L16/dossiers | 16 | 16060000088316 | 16060000088316 | 2 | PO516754 | ||
| 16060000088320 | L16/dossiers | 16 | 16060000088319 | 16060000088319 | 1 | PA415449 | rapporteur | |
| 16060000088321 | L16/dossiers | 16 | 16060000088319 | 16060000088319 | 2 | PO211490 | ||
| 16060000088323 | L16/dossiers | 16 | 16060000088322 | 16060000088322 | 1 | PA703511 | rapporteur | |
| 16060000088324 | L16/dossiers | 16 | 16060000088322 | 16060000088322 | 2 | PO211490 | ||
| 16060000088326 | L16/dossiers | 16 | 16060000088325 | 16060000088325 | 1 | PA736237 | rapporteur | |
| 16060000088327 | L16/dossiers | 16 | 16060000088325 | 16060000088325 | 2 | PO211493 | ||
| 16060000088329 | L16/dossiers | 16 | 16060000088328 | 16060000088328 | 1 | PA304017 | rapporteur | |
| 16060000088330 | L16/dossiers | 16 | 16060000088328 | 16060000088328 | 2 | PO211490 | ||
| 16060000088332 | L16/dossiers | 16 | 16060000088331 | 16060000088331 | 1 | PA703520 | rapporteur | |
| 16060000088333 | L16/dossiers | 16 | 16060000088331 | 16060000088331 | 2 | PO824878 | ||
| 16060000088335 | L16/dossiers | 16 | 16060000088334 | 16060000088334 | 1 | PA304086 | rapporteur | |
| 16060000088336 | L16/dossiers | 16 | 16060000088334 | 16060000088334 | 2 | PO211493 | ||
| 16060000088338 | L16/dossiers | 16 | 16060000088337 | 16060000088337 | 1 | PA775288 | rapporteur | |
| 16060000088339 | L16/dossiers | 16 | 16060000088337 | 16060000088337 | 2 | PO516753 | ||
| 16060000088341 | L16/dossiers | 16 | 16060000088340 | 16060000088340 | 1 | PA304085 | rapporteur | |
| 16060000088342 | L16/dossiers | 16 | 16060000088340 | 16060000088340 | 2 | PO211491 | ||
| 16060000088344 | L16/dossiers | 16 | 16060000088343 | 16060000088343 | 1 | PA703523 | rapporteur | |
| 16060000088345 | L16/dossiers | 16 | 16060000088343 | 16060000088343 | 2 | PA767418 | rapporteur | |
| 16060000088346 | L16/dossiers | 16 | 16060000088343 | 16060000088343 | 3 | PA775276 | rapporteur | |
| 16060000088347 | L16/dossiers | 16 | 16060000088343 | 16060000088343 | 4 | PO824144 | ||
| 16060000088349 | L16/dossiers | 16 | 16060000088348 | 16060000088348 | 1 | PA775192 | rapporteur | |
| 16060000088350 | L16/dossiers | 16 | 16060000088348 | 16060000088348 | 2 | PO824749 | ||
| 16060000088352 | L16/dossiers | 16 | 16060000088351 | 16060000088351 | 1 | PA703520 | rapporteur | |
| 16060000088353 | L16/dossiers | 16 | 16060000088351 | 16060000088351 | 2 | PO516753 | ||
| 16060000088355 | L16/dossiers | 16 | 16060000088354 | 16060000088354 | 1 | PA429875 | rapporteur | |
| 16060000088356 | L16/dossiers | 16 | 16060000088354 | 16060000088354 | 2 | PO211494 | ||
| 16060000088358 | L16/dossiers | 16 | 16060000088357 | 16060000088357 | 1 | PA429875 | rapporteur | |
| 16060000088359 | L16/dossiers | 16 | 16060000088357 | 16060000088357 | 2 | PA429869 | rapporteur | |
| 16060000088360 | L16/dossiers | 16 | 16060000088357 | 16060000088357 | 3 | PA736191 | rapporteur | |
| 16060000088361 | L16/dossiers | 16 | 16060000088357 | 16060000088357 | 4 | PA775200 | rapporteur | |
| 16060000088362 | L16/dossiers | 16 | 16060000088357 | 16060000088357 | 5 | PA757678 | rapporteur | |
| 16060000088363 | L16/dossiers | 16 | 16060000088357 | 16060000088357 | 6 | PA736181 | rapporteur | |
| 16060000088364 | L16/dossiers | 16 | 16060000088357 | 16060000088357 | 7 | PA703514 | rapporteur | |
| 16060000088365 | L16/dossiers | 16 | 16060000088357 | 16060000088357 | 8 | PA429895 | rapporteur | |
| 16060000088366 | L16/dossiers | 16 | 16060000088357 | 16060000088357 | 9 | PA394676 | rapporteur | |
| 16060000088367 | L16/dossiers | 16 | 16060000088357 | 16060000088357 | 10 | PA775184 | rapporteur | |
| 16060000088368 | L16/dossiers | 16 | 16060000088357 | 16060000088357 | 11 | PA709298 | rapporteur | |
| 16060000088369 | L16/dossiers | 16 | 16060000088357 | 16060000088357 | 12 | PA775182 | rapporteur |