dossiers.document_auteur
Chemin document.auteurs.auteur · présence : L17 100 %, L16 100 %, L15 100 %, L14 100 %
59 594 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 |
|---|---|---|---|---|---|---|---|---|
| 17060000079771 | L17/dossiers | 17 | 17060000079769 | 17060000079769 | 2 | PO516753 | ||
| 17060000079773 | L17/dossiers | 17 | 17060000079772 | 17060000079772 | 1 | PA736246 | rapporteur | |
| 17060000079774 | L17/dossiers | 17 | 17060000079772 | 17060000079772 | 2 | PO211493 | ||
| 17060000079776 | L17/dossiers | 17 | 17060000079775 | 17060000079775 | 1 | PA827952 | rapporteur | |
| 17060000079777 | L17/dossiers | 17 | 17060000079775 | 17060000079775 | 2 | PO211495 | ||
| 17060000079779 | L17/dossiers | 17 | 17060000079778 | 17060000079778 | 1 | PA415454 | rapporteur | |
| 17060000079780 | L17/dossiers | 17 | 17060000079778 | 17060000079778 | 2 | PO211495 | ||
| 17060000079782 | L17/dossiers | 17 | 17060000079781 | 17060000079781 | 1 | PA828016 | rapporteur | |
| 17060000079783 | L17/dossiers | 17 | 17060000079781 | 17060000079781 | 2 | PO211495 | ||
| 17060000079785 | L17/dossiers | 17 | 17060000079784 | 17060000079784 | 1 | PA775220 | rapporteur | |
| 17060000079786 | L17/dossiers | 17 | 17060000079784 | 17060000079784 | 2 | PO211495 | ||
| 17060000079788 | L17/dossiers | 17 | 17060000079787 | 17060000079787 | 1 | PA775300 | rapporteur | |
| 17060000079789 | L17/dossiers | 17 | 17060000079787 | 17060000079787 | 2 | PO211490 | ||
| 17060000079791 | L17/dossiers | 17 | 17060000079790 | 17060000079790 | 1 | PA828012 | rapporteur | |
| 17060000079792 | L17/dossiers | 17 | 17060000079790 | 17060000079790 | 2 | PO516754 | ||
| 17060000079794 | L17/dossiers | 17 | 17060000079793 | 17060000079793 | 1 | PA775208 | rapporteur | |
| 17060000079795 | L17/dossiers | 17 | 17060000079793 | 17060000079793 | 2 | PO516753 | ||
| 17060000079797 | L17/dossiers | 17 | 17060000079796 | 17060000079796 | 1 | PA828008 | rapporteur | |
| 17060000079798 | L17/dossiers | 17 | 17060000079796 | 17060000079796 | 2 | PO211495 | ||
| 17060000079800 | L17/dossiers | 17 | 17060000079799 | 17060000079799 | 1 | PA775248 | rapporteur | |
| 17060000079801 | L17/dossiers | 17 | 17060000079799 | 17060000079799 | 2 | PO211495 | ||
| 17060000079803 | L17/dossiers | 17 | 17060000079802 | 17060000079802 | 1 | PA775276 | rapporteur | |
| 17060000079804 | L17/dossiers | 17 | 17060000079802 | 17060000079802 | 2 | PO516753 | ||
| 17060000079806 | L17/dossiers | 17 | 17060000079805 | 17060000079805 | 1 | PA758716 | rapporteur | |
| 17060000079807 | L17/dossiers | 17 | 17060000079805 | 17060000079805 | 2 | PO516753 | ||
| 17060000079809 | L17/dossiers | 17 | 17060000079808 | 17060000079808 | 1 | PA775286 | rapporteur | |
| 17060000079810 | L17/dossiers | 17 | 17060000079808 | 17060000079808 | 2 | PA747420 | rapporteur | |
| 17060000079811 | L17/dossiers | 17 | 17060000079808 | 17060000079808 | 3 | PO211495 | ||
| 17060000079813 | L17/dossiers | 17 | 17060000079812 | 17060000079812 | 1 | PA703530 | rapporteur | |
| 17060000079814 | L17/dossiers | 17 | 17060000079812 | 17060000079812 | 2 | PA703523 | rapporteur | |
| 17060000079815 | L17/dossiers | 17 | 17060000079812 | 17060000079812 | 3 | PO516753 | ||
| 17060000079817 | L17/dossiers | 17 | 17060000079816 | 17060000079816 | 1 | PA267512 | rapporteur | |
| 17060000079818 | L17/dossiers | 17 | 17060000079816 | 17060000079816 | 2 | PO211495 | ||
| 17060000079820 | L17/dossiers | 17 | 17060000079819 | 17060000079819 | 1 | PA703528 | rapporteur | |
| 17060000079821 | L17/dossiers | 17 | 17060000079819 | 17060000079819 | 2 | PO516753 | ||
| 17060000079823 | L17/dossiers | 17 | 17060000079822 | 17060000079822 | 1 | PA775248 | rapporteur | |
| 17060000079824 | L17/dossiers | 17 | 17060000079822 | 17060000079822 | 2 | PO867651 | ||
| 17060000079826 | L17/dossiers | 17 | 17060000079825 | 17060000079825 | 1 | PA719408 | rapporteur | |
| 17060000079827 | L17/dossiers | 17 | 17060000079825 | 17060000079825 | 2 | PO516754 | ||
| 17060000079829 | L17/dossiers | 17 | 17060000079828 | 17060000079828 | 1 | PA703530 | rapporteur | |
| 17060000079830 | L17/dossiers | 17 | 17060000079828 | 17060000079828 | 2 | PA703523 | rapporteur | |
| 17060000079831 | L17/dossiers | 17 | 17060000079828 | 17060000079828 | 3 | PO868026 | ||
| 17060000079833 | L17/dossiers | 17 | 17060000079832 | 17060000079832 | 1 | PA736216 | rapporteur | |
| 17060000079834 | L17/dossiers | 17 | 17060000079832 | 17060000079832 | 2 | PO211490 | ||
| 17060000079836 | L17/dossiers | 17 | 17060000079835 | 17060000079835 | 1 | PA736205 | rapporteur | |
| 17060000079837 | L17/dossiers | 17 | 17060000079835 | 17060000079835 | 2 | PA703538 | rapporteur | |
| 17060000079838 | L17/dossiers | 17 | 17060000079835 | 17060000079835 | 3 | PO867950 | ||
| 17060000079840 | L17/dossiers | 17 | 17060000079839 | 17060000079839 | 1 | PA736207 | rapporteur | |
| 17060000079841 | L17/dossiers | 17 | 17060000079839 | 17060000079839 | 2 | PA827996 | rapporteur | |
| 17060000079842 | L17/dossiers | 17 | 17060000079839 | 17060000079839 | 3 | PO211493 |