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 |
|---|---|---|---|---|---|---|---|---|
| 16060000056515 | L16/dossiers | 16 | 16060000056514 | 16060000056514 | 1 | PO791932 | ||
| 16060000056518 | L16/dossiers | 16 | 16060000056517 | 16060000056517 | 1 | PO791932 | ||
| 16060000056521 | L16/dossiers | 16 | 16060000056520 | 16060000056520 | 1 | PO791932 | ||
| 16060000056523 | L16/dossiers | 16 | 16060000056522 | 16060000056522 | 1 | PO791932 | ||
| 16060000056525 | L16/dossiers | 16 | 16060000056524 | 16060000056524 | 1 | PO791932 | ||
| 16060000056528 | L16/dossiers | 16 | 16060000056527 | 16060000056527 | 1 | PO791932 | ||
| 16060000056531 | L16/dossiers | 16 | 16060000056530 | 16060000056530 | 1 | PO791932 | ||
| 16060000056534 | L16/dossiers | 16 | 16060000056533 | 16060000056533 | 1 | PO791932 | ||
| 16060000056537 | L16/dossiers | 16 | 16060000056536 | 16060000056536 | 1 | PO791932 | ||
| 16060000056539 | L16/dossiers | 16 | 16060000056538 | 16060000056538 | 1 | PO791932 | ||
| 16060000056541 | L16/dossiers | 16 | 16060000056540 | 16060000056540 | 1 | PO791932 | ||
| 16060000056544 | L16/dossiers | 16 | 16060000056543 | 16060000056543 | 1 | PO791932 | ||
| 16060000056547 | L16/dossiers | 16 | 16060000056546 | 16060000056546 | 1 | PO791932 | ||
| 16060000056549 | L16/dossiers | 16 | 16060000056548 | 16060000056548 | 1 | PO791932 | ||
| 16060000056551 | L16/dossiers | 16 | 16060000056550 | 16060000056550 | 1 | PO791932 | ||
| 16060000056553 | L16/dossiers | 16 | 16060000056552 | 16060000056552 | 1 | PO791932 | ||
| 16060000056556 | L16/dossiers | 16 | 16060000056555 | 16060000056555 | 1 | PO44310 | ||
| 16060000056559 | L16/dossiers | 16 | 16060000056558 | 16060000056558 | 1 | PO44311 | ||
| 16060000056562 | L16/dossiers | 16 | 16060000056561 | 16060000056561 | 1 | PA2162 | auteur | |
| 16060000056565 | L16/dossiers | 16 | 16060000056564 | 16060000056564 | 1 | PO78718 | ||
| 16060000056567 | L16/dossiers | 16 | 16060000056566 | 16060000056566 | 1 | PA2332 | auteur | |
| 16060000056593 | L16/dossiers | 16 | 16060000056592 | 16060000056592 | 1 | PO78718 | ||
| 16060000056595 | L16/dossiers | 16 | 16060000056594 | 16060000056594 | 1 | PA2924 | auteur | |
| 16060000056618 | L16/dossiers | 16 | 16060000056617 | 16060000056617 | 1 | PO78718 | ||
| 16060000056620 | L16/dossiers | 16 | 16060000056619 | 16060000056619 | 1 | PO78718 | ||
| 16060000056622 | L16/dossiers | 16 | 16060000056621 | 16060000056621 | 1 | PA2607 | auteur | |
| 16060000056685 | L16/dossiers | 16 | 16060000056684 | 16060000056684 | 1 | PA2227 | auteur | |
| 16060000056689 | L16/dossiers | 16 | 16060000056688 | 16060000056688 | 1 | PA1597 | auteur | |
| 16060000056693 | L16/dossiers | 16 | 16060000056692 | 16060000056692 | 1 | PA592 | auteur | |
| 16060000056696 | L16/dossiers | 16 | 16060000056695 | 16060000056695 | 1 | PO78718 | ||
| 16060000056698 | L16/dossiers | 16 | 16060000056697 | 16060000056697 | 1 | PO78718 | ||
| 16060000056700 | L16/dossiers | 16 | 16060000056699 | 16060000056699 | 1 | PO78718 | ||
| 16060000056702 | L16/dossiers | 16 | 16060000056701 | 16060000056701 | 1 | PO78718 | ||
| 16060000056704 | L16/dossiers | 16 | 16060000056703 | 16060000056703 | 1 | PA227018 | auteur | |
| 16060000056713 | L16/dossiers | 16 | 16060000056712 | 16060000056712 | 1 | PA228 | auteur | |
| 16060000056715 | L16/dossiers | 16 | 16060000056714 | 16060000056714 | 1 | PO78718 | ||
| 16060000056717 | L16/dossiers | 16 | 16060000056716 | 16060000056716 | 1 | PO78718 | ||
| 16060000056719 | L16/dossiers | 16 | 16060000056718 | 16060000056718 | 1 | PA875 | auteur | |
| 16060000056721 | L16/dossiers | 16 | 16060000056720 | 16060000056720 | 1 | PA303997 | auteur | |
| 16060000056723 | L16/dossiers | 16 | 16060000056722 | 16060000056722 | 1 | PO78718 | ||
| 16060000056725 | L16/dossiers | 16 | 16060000056724 | 16060000056724 | 1 | PO78718 | ||
| 16060000056727 | L16/dossiers | 16 | 16060000056726 | 16060000056726 | 1 | PA227087 | rapporteur | |
| 16060000056728 | L16/dossiers | 16 | 16060000056726 | 16060000056726 | 2 | PO211495 | ||
| 16060000056730 | L16/dossiers | 16 | 16060000056729 | 16060000056729 | 1 | PA905 | auteur | |
| 16060000056745 | L16/dossiers | 16 | 16060000056744 | 16060000056744 | 1 | PA228 | auteur | |
| 16060000056748 | L16/dossiers | 16 | 16060000056747 | 16060000056747 | 1 | PO78718 | ||
| 16060000056750 | L16/dossiers | 16 | 16060000056749 | 16060000056749 | 1 | PO78718 | ||
| 16060000056752 | L16/dossiers | 16 | 16060000056751 | 16060000056751 | 1 | PO78718 | ||
| 16060000056754 | L16/dossiers | 16 | 16060000056753 | 16060000056753 | 1 | PA2905 | rapporteur | |
| 16060000056755 | L16/dossiers | 16 | 16060000056753 | 16060000056753 | 2 | PO211495 |