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 |
|---|---|---|---|---|---|---|---|---|
| 16060000059377 | L16/dossiers | 16 | 16060000059364 | 16060000059364 | 13 | PA732419 | auteur | |
| 16060000059378 | L16/dossiers | 16 | 16060000059364 | 16060000059364 | 14 | PA732419 | auteur | |
| 16060000059379 | L16/dossiers | 16 | 16060000059364 | 16060000059364 | 15 | PA736191 | auteur | |
| 16060000059380 | L16/dossiers | 16 | 16060000059364 | 16060000059364 | 16 | PA708633 | auteur | |
| 16060000059381 | L16/dossiers | 16 | 16060000059364 | 16060000059364 | 17 | PA415477 | auteur | |
| 16060000059382 | L16/dossiers | 16 | 16060000059364 | 16060000059364 | 18 | PA415477 | auteur | |
| 16060000059383 | L16/dossiers | 16 | 16060000059364 | 16060000059364 | 19 | PA736187 | auteur | |
| 16060000059384 | L16/dossiers | 16 | 16060000059364 | 16060000059364 | 20 | PA766947 | auteur | |
| 16060000059385 | L16/dossiers | 16 | 16060000059364 | 16060000059364 | 21 | PA642756 | auteur | |
| 16060000059386 | L16/dossiers | 16 | 16060000059364 | 16060000059364 | 22 | PA736241 | auteur | |
| 16060000059387 | L16/dossiers | 16 | 16060000059364 | 16060000059364 | 23 | PA703536 | auteur | |
| 16060000059388 | L16/dossiers | 16 | 16060000059364 | 16060000059364 | 24 | PA736229 | auteur | |
| 16060000059389 | L16/dossiers | 16 | 16060000059364 | 16060000059364 | 25 | PA605888 | auteur | |
| 16060000059390 | L16/dossiers | 16 | 16060000059364 | 16060000059364 | 26 | PA268048 | auteur | |
| 16060000059391 | L16/dossiers | 16 | 16060000059364 | 16060000059364 | 27 | PA429888 | auteur | |
| 16060000059392 | L16/dossiers | 16 | 16060000059364 | 16060000059364 | 28 | PA775254 | auteur | |
| 16060000059393 | L16/dossiers | 16 | 16060000059364 | 16060000059364 | 29 | PA775256 | auteur | |
| 16060000059394 | L16/dossiers | 16 | 16060000059364 | 16060000059364 | 30 | PA703512 | auteur | |
| 16060000059395 | L16/dossiers | 16 | 16060000059364 | 16060000059364 | 31 | PA643211 | auteur | |
| 16060000059396 | L16/dossiers | 16 | 16060000059364 | 16060000059364 | 32 | PA775268 | auteur | |
| 16060000059397 | L16/dossiers | 16 | 16060000059364 | 16060000059364 | 33 | PA703505 | auteur | |
| 16060000059398 | L16/dossiers | 16 | 16060000059364 | 16060000059364 | 34 | PA775274 | auteur | |
| 16060000059399 | L16/dossiers | 16 | 16060000059364 | 16060000059364 | 35 | PA703511 | auteur | |
| 16060000059400 | L16/dossiers | 16 | 16060000059364 | 16060000059364 | 36 | PA429883 | auteur | |
| 16060000059401 | L16/dossiers | 16 | 16060000059364 | 16060000059364 | 37 | PA736217 | auteur | |
| 16060000059402 | L16/dossiers | 16 | 16060000059364 | 16060000059364 | 38 | PA227096 | auteur | |
| 16060000059403 | L16/dossiers | 16 | 16060000059364 | 16060000059364 | 39 | PA227096 | auteur | |
| 16060000059404 | L16/dossiers | 16 | 16060000059364 | 16060000059364 | 40 | PA775294 | auteur | |
| 16060000059405 | L16/dossiers | 16 | 16060000059364 | 16060000059364 | 41 | PA2870 | auteur | |
| 16060000059406 | L16/dossiers | 16 | 16060000059364 | 16060000059364 | 42 | PA2870 | auteur | |
| 16060000059407 | L16/dossiers | 16 | 16060000059364 | 16060000059364 | 43 | PA736162 | auteur | |
| 16060000059408 | L16/dossiers | 16 | 16060000059364 | 16060000059364 | 44 | PA429852 | auteur | |
| 16060000059410 | L16/dossiers | 16 | 16060000059409 | 16060000059409 | 1 | PO78718 | ||
| 16060000059412 | L16/dossiers | 16 | 16060000059411 | 16060000059411 | 1 | PO78718 | ||
| 16060000059414 | L16/dossiers | 16 | 16060000059413 | 16060000059413 | 1 | PO78718 | ||
| 16060000059416 | L16/dossiers | 16 | 16060000059415 | 16060000059415 | 1 | PO78718 | ||
| 16060000059418 | L16/dossiers | 16 | 16060000059417 | 16060000059417 | 1 | PO78718 | ||
| 16060000059420 | L16/dossiers | 16 | 16060000059419 | 16060000059419 | 1 | PO78718 | ||
| 16060000059422 | L16/dossiers | 16 | 16060000059421 | 16060000059421 | 1 | PO78718 | ||
| 16060000059424 | L16/dossiers | 16 | 16060000059423 | 16060000059423 | 1 | PO78718 | ||
| 16060000059426 | L16/dossiers | 16 | 16060000059425 | 16060000059425 | 1 | PO78718 | ||
| 16060000059428 | L16/dossiers | 16 | 16060000059427 | 16060000059427 | 1 | PO78718 | ||
| 16060000059430 | L16/dossiers | 16 | 16060000059429 | 16060000059429 | 1 | PO78718 | ||
| 16060000059432 | L16/dossiers | 16 | 16060000059431 | 16060000059431 | 1 | PO78718 | ||
| 16060000059434 | L16/dossiers | 16 | 16060000059433 | 16060000059433 | 1 | PO78718 | ||
| 16060000059436 | L16/dossiers | 16 | 16060000059435 | 16060000059435 | 1 | PO78718 | ||
| 16060000059438 | L16/dossiers | 16 | 16060000059437 | 16060000059437 | 1 | PO78718 | ||
| 16060000059440 | L16/dossiers | 16 | 16060000059439 | 16060000059439 | 1 | PO78718 | ||
| 16060000059442 | L16/dossiers | 16 | 16060000059441 | 16060000059441 | 1 | PO78718 | ||
| 16060000059444 | L16/dossiers | 16 | 16060000059443 | 16060000059443 | 1 | PO78718 |