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 |
|---|---|---|---|---|---|---|---|---|
| 15060000111654 | L15/dossiers | 15 | 15060000111653 | 15060000111653 | 1 | PA345619 | auteur | |
| 15060000111658 | L15/dossiers | 15 | 15060000111657 | 15060000111657 | 1 | PO717460 | ||
| 15060000111661 | L15/dossiers | 15 | 15060000111660 | 15060000111660 | 1 | PO717460 | ||
| 15060000111664 | L15/dossiers | 15 | 15060000111663 | 15060000111663 | 1 | PA345619 | auteur | |
| 15060000111668 | L15/dossiers | 15 | 15060000111667 | 15060000111667 | 1 | PO717460 | ||
| 15060000111671 | L15/dossiers | 15 | 15060000111670 | 15060000111670 | 1 | PO717460 | ||
| 15060000111674 | L15/dossiers | 15 | 15060000111673 | 15060000111673 | 1 | PO717460 | ||
| 15060000111677 | L15/dossiers | 15 | 15060000111676 | 15060000111676 | 1 | PO717460 | ||
| 15060000111681 | L15/dossiers | 15 | 15060000111680 | 15060000111680 | 1 | PA345619 | auteur | |
| 15060000111684 | L15/dossiers | 15 | 15060000111683 | 15060000111683 | 1 | PO717460 | ||
| 15060000111687 | L15/dossiers | 15 | 15060000111686 | 15060000111686 | 1 | PA345619 | auteur | |
| 15060000111690 | L15/dossiers | 15 | 15060000111689 | 15060000111689 | 1 | PO717460 | ||
| 15060000111693 | L15/dossiers | 15 | 15060000111692 | 15060000111692 | 1 | PA345619 | auteur | |
| 15060000111697 | L15/dossiers | 15 | 15060000111696 | 15060000111696 | 1 | PO717460 | ||
| 15060000111700 | L15/dossiers | 15 | 15060000111699 | 15060000111699 | 1 | PA345619 | auteur | |
| 15060000111704 | L15/dossiers | 15 | 15060000111703 | 15060000111703 | 1 | PO717460 | ||
| 15060000111707 | L15/dossiers | 15 | 15060000111706 | 15060000111706 | 1 | PA345619 | auteur | |
| 15060000111711 | L15/dossiers | 15 | 15060000111710 | 15060000111710 | 1 | PA345619 | auteur | |
| 15060000111715 | L15/dossiers | 15 | 15060000111714 | 15060000111714 | 1 | PA345619 | auteur | |
| 15060000111719 | L15/dossiers | 15 | 15060000111718 | 15060000111718 | 1 | PA345619 | auteur | |
| 15060000111723 | L15/dossiers | 15 | 15060000111722 | 15060000111722 | 1 | PA345619 | auteur | |
| 15060000111734 | L15/dossiers | 15 | 15060000111733 | 15060000111733 | 1 | PA345619 | auteur | |
| 15060000111740 | L15/dossiers | 15 | 15060000111739 | 15060000111739 | 1 | PA345619 | auteur | |
| 15060000111744 | L15/dossiers | 15 | 15060000111743 | 15060000111743 | 1 | PO717460 | ||
| 15060000111747 | L15/dossiers | 15 | 15060000111746 | 15060000111746 | 1 | PO717460 | ||
| 15060000111750 | L15/dossiers | 15 | 15060000111749 | 15060000111749 | 1 | PA345619 | auteur | |
| 15060000111754 | L15/dossiers | 15 | 15060000111753 | 15060000111753 | 1 | PA345619 | auteur | |
| 15060000111759 | L15/dossiers | 15 | 15060000111758 | 15060000111758 | 1 | PO717460 | ||
| 15060000111762 | L15/dossiers | 15 | 15060000111761 | 15060000111761 | 1 | PO717460 | ||
| 15060000111766 | L15/dossiers | 15 | 15060000111765 | 15060000111765 | 1 | PO717460 | ||
| 15060000111769 | L15/dossiers | 15 | 15060000111768 | 15060000111768 | 1 | PO717460 | ||
| 15060000111772 | L15/dossiers | 15 | 15060000111771 | 15060000111771 | 1 | PA345619 | auteur | |
| 15060000111777 | L15/dossiers | 15 | 15060000111776 | 15060000111776 | 1 | PA345619 | auteur | |
| 15060000111781 | L15/dossiers | 15 | 15060000111780 | 15060000111780 | 1 | PO717460 | ||
| 15060000111784 | L15/dossiers | 15 | 15060000111783 | 15060000111783 | 1 | PO717460 | ||
| 15060000111787 | L15/dossiers | 15 | 15060000111786 | 15060000111786 | 1 | PA345619 | auteur | |
| 15060000111791 | L15/dossiers | 15 | 15060000111790 | 15060000111790 | 1 | PA345619 | auteur | |
| 15060000111795 | L15/dossiers | 15 | 15060000111794 | 15060000111794 | 1 | PO717460 | ||
| 15060000111798 | L15/dossiers | 15 | 15060000111797 | 15060000111797 | 1 | PO717460 | ||
| 15060000111801 | L15/dossiers | 15 | 15060000111800 | 15060000111800 | 1 | PO717460 | ||
| 15060000111804 | L15/dossiers | 15 | 15060000111803 | 15060000111803 | 1 | PO717460 | ||
| 15060000111808 | L15/dossiers | 15 | 15060000111807 | 15060000111807 | 1 | PA345619 | auteur | |
| 15060000111814 | L15/dossiers | 15 | 15060000111813 | 15060000111813 | 1 | PA345619 | auteur | |
| 15060000111818 | L15/dossiers | 15 | 15060000111817 | 15060000111817 | 1 | PA345619 | auteur | |
| 15060000111822 | L15/dossiers | 15 | 15060000111821 | 15060000111821 | 1 | PA345619 | auteur | |
| 15060000111826 | L15/dossiers | 15 | 15060000111825 | 15060000111825 | 1 | PO717460 | ||
| 15060000111829 | L15/dossiers | 15 | 15060000111828 | 15060000111828 | 1 | PO717460 | ||
| 15060000111833 | L15/dossiers | 15 | 15060000111832 | 15060000111832 | 1 | PO717460 | ||
| 15060000111836 | L15/dossiers | 15 | 15060000111835 | 15060000111835 | 1 | PA345619 | auteur | |
| 15060000111841 | L15/dossiers | 15 | 15060000111840 | 15060000111840 | 1 | PO717460 |