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 |
|---|---|---|---|---|---|---|---|---|
| 16060000084499 | L16/dossiers | 16 | 16060000084498 | 16060000084498 | 1 | PA703510 | rapporteur | |
| 16060000084500 | L16/dossiers | 16 | 16060000084498 | 16060000084498 | 2 | PA747420 | rapporteur | |
| 16060000084501 | L16/dossiers | 16 | 16060000084498 | 16060000084498 | 3 | PO826540 | ||
| 16060000084503 | L16/dossiers | 16 | 16060000084502 | 16060000084502 | 1 | PA775288 | rapporteur | |
| 16060000084504 | L16/dossiers | 16 | 16060000084502 | 16060000084502 | 2 | PA775228 | rapporteur | |
| 16060000084505 | L16/dossiers | 16 | 16060000084502 | 16060000084502 | 3 | PA736211 | rapporteur | |
| 16060000084506 | L16/dossiers | 16 | 16060000084502 | 16060000084502 | 4 | PO826726 | ||
| 16060000084508 | L16/dossiers | 16 | 16060000084507 | 16060000084507 | 1 | PA429875 | rapporteur | |
| 16060000084509 | L16/dossiers | 16 | 16060000084507 | 16060000084507 | 2 | PO211494 | ||
| 16060000084511 | L16/dossiers | 16 | 16060000084510 | 16060000084510 | 1 | PA736239 | rapporteur | |
| 16060000084512 | L16/dossiers | 16 | 16060000084510 | 16060000084510 | 2 | PO211493 | ||
| 16060000084514 | L16/dossiers | 16 | 16060000084513 | 16060000084513 | 1 | PA429869 | rapporteur | |
| 16060000084515 | L16/dossiers | 16 | 16060000084513 | 16060000084513 | 2 | PO211494 | ||
| 16060000084517 | L16/dossiers | 16 | 16060000084516 | 16060000084516 | 1 | PA703523 | rapporteur | |
| 16060000084518 | L16/dossiers | 16 | 16060000084516 | 16060000084516 | 2 | PO516753 | ||
| 16060000084520 | L16/dossiers | 16 | 16060000084519 | 16060000084519 | 1 | PA1573 | rapporteur | |
| 16060000084521 | L16/dossiers | 16 | 16060000084519 | 16060000084519 | 2 | PO211491 | ||
| 16060000084523 | L16/dossiers | 16 | 16060000084522 | 16060000084522 | 1 | PA415479 | rapporteur | |
| 16060000084524 | L16/dossiers | 16 | 16060000084522 | 16060000084522 | 2 | PO211491 | ||
| 16060000084526 | L16/dossiers | 16 | 16060000084525 | 16060000084525 | 1 | PA267081 | rapporteur | |
| 16060000084527 | L16/dossiers | 16 | 16060000084525 | 16060000084525 | 2 | PO830023 | ||
| 16060000084529 | L16/dossiers | 16 | 16060000084528 | 16060000084528 | 1 | PA703523 | rapporteur | |
| 16060000084530 | L16/dossiers | 16 | 16060000084528 | 16060000084528 | 2 | PO830797 | ||
| 16060000084532 | L16/dossiers | 16 | 16060000084531 | 16060000084531 | 1 | PA736239 | rapporteur | |
| 16060000084533 | L16/dossiers | 16 | 16060000084531 | 16060000084531 | 2 | PO830153 | ||
| 16060000084535 | L16/dossiers | 16 | 16060000084534 | 16060000084534 | 1 | PA703498 | rapporteur | |
| 16060000084536 | L16/dossiers | 16 | 16060000084534 | 16060000084534 | 2 | PO831775 | ||
| 16060000084538 | L16/dossiers | 16 | 16060000084537 | 16060000084537 | 1 | PA429875 | rapporteur | |
| 16060000084539 | L16/dossiers | 16 | 16060000084537 | 16060000084537 | 2 | PO831815 | ||
| 16060000084541 | L16/dossiers | 16 | 16060000084540 | 16060000084540 | 1 | PA429875 | rapporteur | |
| 16060000084542 | L16/dossiers | 16 | 16060000084540 | 16060000084540 | 2 | PO832738 | ||
| 16060000084544 | L16/dossiers | 16 | 16060000084543 | 16060000084543 | 1 | PA827952 | rapporteur | |
| 16060000084545 | L16/dossiers | 16 | 16060000084543 | 16060000084543 | 2 | PO211495 | ||
| 16060000084547 | L16/dossiers | 16 | 16060000084546 | 16060000084546 | 1 | PA775234 | rapporteur | |
| 16060000084548 | L16/dossiers | 16 | 16060000084546 | 16060000084546 | 2 | PO211491 | ||
| 16060000084550 | L16/dossiers | 16 | 16060000084549 | 16060000084549 | 1 | PA828014 | rapporteur | |
| 16060000084551 | L16/dossiers | 16 | 16060000084549 | 16060000084549 | 2 | PO211491 | ||
| 16060000084553 | L16/dossiers | 16 | 16060000084552 | 16060000084552 | 1 | PA827942 | rapporteur | |
| 16060000084554 | L16/dossiers | 16 | 16060000084552 | 16060000084552 | 2 | PA703541 | rapporteur | |
| 16060000084555 | L16/dossiers | 16 | 16060000084552 | 16060000084552 | 3 | PO765977 | ||
| 16060000084557 | L16/dossiers | 16 | 16060000084556 | 16060000084556 | 1 | PA736205 | rapporteur | |
| 16060000084558 | L16/dossiers | 16 | 16060000084556 | 16060000084556 | 2 | PA569 | rapporteur | |
| 16060000084559 | L16/dossiers | 16 | 16060000084556 | 16060000084556 | 3 | PO833058 | ||
| 16060000084561 | L16/dossiers | 16 | 16060000084560 | 16060000084560 | 1 | PA827932 | rapporteur | |
| 16060000084562 | L16/dossiers | 16 | 16060000084560 | 16060000084560 | 2 | PO211491 | ||
| 16060000084564 | L16/dossiers | 16 | 16060000084563 | 16060000084563 | 1 | PA205280 | rapporteur | |
| 16060000084565 | L16/dossiers | 16 | 16060000084563 | 16060000084563 | 2 | PO211491 | ||
| 16060000084567 | L16/dossiers | 16 | 16060000084566 | 16060000084566 | 1 | PA767418 | rapporteur | |
| 16060000084568 | L16/dossiers | 16 | 16060000084566 | 16060000084566 | 2 | PO516754 | ||
| 16060000084570 | L16/dossiers | 16 | 16060000084569 | 16060000084569 | 1 | PA429858 | rapporteur |