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 |
|---|---|---|---|---|---|---|---|---|
| 15060000116700 | L15/dossiers | 15 | 15060000116699 | 15060000116699 | 1 | PA345619 | auteur | |
| 15060000116703 | L15/dossiers | 15 | 15060000116702 | 15060000116702 | 1 | PO78718 | ||
| 15060000116705 | L15/dossiers | 15 | 15060000116704 | 15060000116704 | 1 | PO78718 | ||
| 15060000116707 | L15/dossiers | 15 | 15060000116706 | 15060000116706 | 1 | PA345619 | auteur | |
| 15060000116710 | L15/dossiers | 15 | 15060000116709 | 15060000116709 | 1 | PO78718 | ||
| 15060000116712 | L15/dossiers | 15 | 15060000116711 | 15060000116711 | 1 | PO78718 | ||
| 15060000116714 | L15/dossiers | 15 | 15060000116713 | 15060000116713 | 1 | PA345619 | auteur | |
| 15060000116717 | L15/dossiers | 15 | 15060000116716 | 15060000116716 | 1 | PA345619 | auteur | |
| 15060000116720 | L15/dossiers | 15 | 15060000116719 | 15060000116719 | 1 | PA345619 | auteur | |
| 15060000116723 | L15/dossiers | 15 | 15060000116722 | 15060000116722 | 1 | PO78718 | ||
| 15060000116725 | L15/dossiers | 15 | 15060000116724 | 15060000116724 | 1 | PA345619 | auteur | |
| 15060000116728 | L15/dossiers | 15 | 15060000116727 | 15060000116727 | 1 | PA345619 | auteur | |
| 15060000116731 | L15/dossiers | 15 | 15060000116730 | 15060000116730 | 1 | PO78718 | ||
| 15060000116733 | L15/dossiers | 15 | 15060000116732 | 15060000116732 | 1 | PO78718 | ||
| 15060000116735 | L15/dossiers | 15 | 15060000116734 | 15060000116734 | 1 | PO78718 | ||
| 15060000116737 | L15/dossiers | 15 | 15060000116736 | 15060000116736 | 1 | PA345619 | auteur | |
| 15060000116740 | L15/dossiers | 15 | 15060000116739 | 15060000116739 | 1 | PO78718 | ||
| 15060000116742 | L15/dossiers | 15 | 15060000116741 | 15060000116741 | 1 | PO78718 | ||
| 15060000116744 | L15/dossiers | 15 | 15060000116743 | 15060000116743 | 1 | PO78718 | ||
| 15060000116746 | L15/dossiers | 15 | 15060000116745 | 15060000116745 | 1 | PA345619 | auteur | |
| 15060000116750 | L15/dossiers | 15 | 15060000116749 | 15060000116749 | 1 | PA345619 | auteur | |
| 15060000116754 | L15/dossiers | 15 | 15060000116753 | 15060000116753 | 1 | PA345619 | auteur | |
| 15060000116757 | L15/dossiers | 15 | 15060000116756 | 15060000116756 | 1 | PA345619 | auteur | |
| 15060000116761 | L15/dossiers | 15 | 15060000116760 | 15060000116760 | 1 | PO78718 | ||
| 15060000116763 | L15/dossiers | 15 | 15060000116762 | 15060000116762 | 1 | PO78718 | ||
| 15060000116765 | L15/dossiers | 15 | 15060000116764 | 15060000116764 | 1 | PO78718 | ||
| 15060000116767 | L15/dossiers | 15 | 15060000116766 | 15060000116766 | 1 | PA345619 | auteur | |
| 15060000116770 | L15/dossiers | 15 | 15060000116769 | 15060000116769 | 1 | PO78718 | ||
| 15060000116772 | L15/dossiers | 15 | 15060000116771 | 15060000116771 | 1 | PA345619 | auteur | |
| 15060000116775 | L15/dossiers | 15 | 15060000116774 | 15060000116774 | 1 | PA345619 | auteur | |
| 15060000116778 | L15/dossiers | 15 | 15060000116777 | 15060000116777 | 1 | PA345619 | auteur | |
| 15060000116781 | L15/dossiers | 15 | 15060000116780 | 15060000116780 | 1 | PO78718 | ||
| 15060000116783 | L15/dossiers | 15 | 15060000116782 | 15060000116782 | 1 | PO78718 | ||
| 15060000116785 | L15/dossiers | 15 | 15060000116784 | 15060000116784 | 1 | PO78718 | ||
| 15060000116787 | L15/dossiers | 15 | 15060000116786 | 15060000116786 | 1 | PA345619 | auteur | |
| 15060000116790 | L15/dossiers | 15 | 15060000116789 | 15060000116789 | 1 | PO78718 | ||
| 15060000116792 | L15/dossiers | 15 | 15060000116791 | 15060000116791 | 1 | PO78718 | ||
| 15060000116794 | L15/dossiers | 15 | 15060000116793 | 15060000116793 | 1 | PO78718 | ||
| 15060000116796 | L15/dossiers | 15 | 15060000116795 | 15060000116795 | 1 | PO78718 | ||
| 15060000116798 | L15/dossiers | 15 | 15060000116797 | 15060000116797 | 1 | PO78718 | ||
| 15060000116800 | L15/dossiers | 15 | 15060000116799 | 15060000116799 | 1 | PO78718 | ||
| 15060000116802 | L15/dossiers | 15 | 15060000116801 | 15060000116801 | 1 | PO78718 | ||
| 15060000116804 | L15/dossiers | 15 | 15060000116803 | 15060000116803 | 1 | PO78718 | ||
| 15060000116806 | L15/dossiers | 15 | 15060000116805 | 15060000116805 | 1 | PO78718 | ||
| 15060000116808 | L15/dossiers | 15 | 15060000116807 | 15060000116807 | 1 | PO78718 | ||
| 15060000116810 | L15/dossiers | 15 | 15060000116809 | 15060000116809 | 1 | PO78718 | ||
| 15060000116812 | L15/dossiers | 15 | 15060000116811 | 15060000116811 | 1 | PO78718 | ||
| 15060000116814 | L15/dossiers | 15 | 15060000116813 | 15060000116813 | 1 | PO78718 | ||
| 15060000116816 | L15/dossiers | 15 | 15060000116815 | 15060000116815 | 1 | PO78718 | ||
| 15060000116818 | L15/dossiers | 15 | 15060000116817 | 15060000116817 | 1 | PO78718 |