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 |
|---|---|---|---|---|---|---|---|---|
| 14060000034230 | L14/dossiers | 14 | 14060000034227 | 14060000034227 | 3 | PO59046 | ||
| 14060000034232 | L14/dossiers | 14 | 14060000034231 | 14060000034231 | 1 | PA267794 | auteur | |
| 14060000034261 | L14/dossiers | 14 | 14060000034260 | 14060000034260 | 1 | PO78718 | ||
| 14060000034263 | L14/dossiers | 14 | 14060000034262 | 14060000034262 | 1 | PA606555 | rapporteur | |
| 14060000034264 | L14/dossiers | 14 | 14060000034262 | 14060000034262 | 2 | PO59051 | ||
| 14060000034267 | L14/dossiers | 14 | 14060000034266 | 14060000034266 | 1 | PA328 | auteur | |
| 14060000034271 | L14/dossiers | 14 | 14060000034270 | 14060000034270 | 1 | PO644420 | ||
| 14060000034274 | L14/dossiers | 14 | 14060000034273 | 14060000034273 | 1 | PA304002 | rapporteur | |
| 14060000034275 | L14/dossiers | 14 | 14060000034273 | 14060000034273 | 2 | PO697328 | ||
| 14060000034277 | L14/dossiers | 14 | 14060000034276 | 14060000034276 | 1 | PA304002 | rapporteur | |
| 14060000034278 | L14/dossiers | 14 | 14060000034276 | 14060000034276 | 2 | PO211490 | ||
| 14060000034280 | L14/dossiers | 14 | 14060000034279 | 14060000034279 | 1 | PA606555 | rapporteur | |
| 14060000034281 | L14/dossiers | 14 | 14060000034279 | 14060000034279 | 2 | PO59051 | ||
| 14060000034283 | L14/dossiers | 14 | 14060000034282 | 14060000034282 | 1 | PA606555 | rapporteur | |
| 14060000034284 | L14/dossiers | 14 | 14060000034282 | 14060000034282 | 2 | PO697328 | ||
| 14060000034286 | L14/dossiers | 14 | 14060000034285 | 14060000034285 | 1 | PA328 | auteur | |
| 14060000034288 | L14/dossiers | 14 | 14060000034287 | 14060000034287 | 1 | PA735 | auteur | |
| 14060000034290 | L14/dossiers | 14 | 14060000034289 | 14060000034289 | 1 | PA810 | rapporteur | |
| 14060000034291 | L14/dossiers | 14 | 14060000034289 | 14060000034289 | 2 | PO419865 | ||
| 14060000034293 | L14/dossiers | 14 | 14060000034292 | 14060000034292 | 1 | PA2011 | auteur | |
| 14060000034297 | L14/dossiers | 14 | 14060000034296 | 14060000034296 | 1 | PA267306 | auteur | |
| 14060000034309 | L14/dossiers | 14 | 14060000034308 | 14060000034308 | 1 | PA330684 | auteur | |
| 14060000034350 | L14/dossiers | 14 | 14060000034349 | 14060000034349 | 1 | PA230 | auteur | |
| 14060000034354 | L14/dossiers | 14 | 14060000034353 | 14060000034353 | 1 | PA608662 | auteur | |
| 14060000034413 | L14/dossiers | 14 | 14060000034412 | 14060000034412 | 1 | PA267622 | auteur | |
| 14060000034417 | L14/dossiers | 14 | 14060000034416 | 14060000034416 | 1 | PO78718 | ||
| 14060000034419 | L14/dossiers | 14 | 14060000034418 | 14060000034418 | 1 | PA1931 | rapporteur | |
| 14060000034420 | L14/dossiers | 14 | 14060000034418 | 14060000034418 | 2 | PO59047 | ||
| 14060000034422 | L14/dossiers | 14 | 14060000034421 | 14060000034421 | 1 | PA1037 | rapporteur | |
| 14060000034423 | L14/dossiers | 14 | 14060000034421 | 14060000034421 | 2 | PO211491 | ||
| 14060000034425 | L14/dossiers | 14 | 14060000034424 | 14060000034424 | 1 | PA330788 | auteur | |
| 14060000034452 | L14/dossiers | 14 | 14060000034451 | 14060000034451 | 1 | PA1886 | auteur | |
| 14060000034586 | L14/dossiers | 14 | 14060000034585 | 14060000034585 | 1 | PA268019 | auteur | |
| 14060000034589 | L14/dossiers | 14 | 14060000034588 | 14060000034588 | 1 | PO717460 | ||
| 14060000034592 | L14/dossiers | 14 | 14060000034591 | 14060000034591 | 1 | PA267622 | auteur | |
| 14060000034595 | L14/dossiers | 14 | 14060000034594 | 14060000034594 | 1 | PA429835 | rapporteur | |
| 14060000034596 | L14/dossiers | 14 | 14060000034594 | 14060000034594 | 2 | PO211491 | ||
| 14060000034598 | L14/dossiers | 14 | 14060000034597 | 14060000034597 | 1 | PA267622 | auteur | |
| 14060000034600 | L14/dossiers | 14 | 14060000034599 | 14060000034599 | 1 | PA605922 | rapporteur | |
| 14060000034601 | L14/dossiers | 14 | 14060000034599 | 14060000034599 | 2 | PO419610 | ||
| 14060000034603 | L14/dossiers | 14 | 14060000034602 | 14060000034602 | 1 | PA429866 | rapporteur | |
| 14060000034604 | L14/dossiers | 14 | 14060000034602 | 14060000034602 | 2 | PO516753 | ||
| 14060000034606 | L14/dossiers | 14 | 14060000034605 | 14060000034605 | 1 | PO78718 | ||
| 14060000034608 | L14/dossiers | 14 | 14060000034607 | 14060000034607 | 1 | PA605922 | auteur | |
| 14060000034628 | L14/dossiers | 14 | 14060000034627 | 14060000034627 | 1 | PO717460 | ||
| 14060000034631 | L14/dossiers | 14 | 14060000034630 | 14060000034630 | 1 | PA605922 | rapporteur | |
| 14060000034632 | L14/dossiers | 14 | 14060000034630 | 14060000034630 | 2 | PO419610 | ||
| 14060000034635 | L14/dossiers | 14 | 14060000034634 | 14060000034634 | 1 | PO644420 | ||
| 14060000034638 | L14/dossiers | 14 | 14060000034637 | 14060000034637 | 1 | PA735 | rapporteur | |
| 14060000034639 | L14/dossiers | 14 | 14060000034637 | 14060000034637 | 2 | PA1630 | rapporteur |