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 |
|---|---|---|---|---|---|---|---|---|
| 17060000071785 | L17/dossiers | 17 | 17060000071783 | 17060000071783 | 2 | PO419610 | ||
| 17060000071788 | L17/dossiers | 17 | 17060000071787 | 17060000071787 | 1 | PA605745 | rapporteur | |
| 17060000071789 | L17/dossiers | 17 | 17060000071787 | 17060000071787 | 2 | PO59048 | ||
| 17060000071792 | L17/dossiers | 17 | 17060000071791 | 17060000071791 | 1 | PA796106 | rapporteur | |
| 17060000071793 | L17/dossiers | 17 | 17060000071791 | 17060000071791 | 2 | PO420120 | ||
| 17060000071796 | L17/dossiers | 17 | 17060000071795 | 17060000071795 | 1 | PA609332 | rapporteur | |
| 17060000071797 | L17/dossiers | 17 | 17060000071795 | 17060000071795 | 2 | PO59046 | ||
| 17060000071800 | L17/dossiers | 17 | 17060000071799 | 17060000071799 | 1 | PA794466 | rapporteur | |
| 17060000071801 | L17/dossiers | 17 | 17060000071799 | 17060000071799 | 2 | PO59051 | ||
| 17060000071804 | L17/dossiers | 17 | 17060000071803 | 17060000071803 | 1 | PA793174 | rapporteur | |
| 17060000071805 | L17/dossiers | 17 | 17060000071803 | 17060000071803 | 2 | PO59048 | ||
| 17060000071808 | L17/dossiers | 17 | 17060000071807 | 17060000071807 | 1 | PA795998 | rapporteur | |
| 17060000071809 | L17/dossiers | 17 | 17060000071807 | 17060000071807 | 2 | PO420120 | ||
| 17060000071812 | L17/dossiers | 17 | 17060000071811 | 17060000071811 | 1 | PA721474 | rapporteur | |
| 17060000071813 | L17/dossiers | 17 | 17060000071811 | 17060000071811 | 2 | PO420120 | ||
| 17060000071816 | L17/dossiers | 17 | 17060000071815 | 17060000071815 | 1 | PA720154 | rapporteur | |
| 17060000071817 | L17/dossiers | 17 | 17060000071815 | 17060000071815 | 2 | PO869203 | ||
| 17060000071819 | L17/dossiers | 17 | 17060000071818 | 17060000071818 | 1 | PA795144 | rapporteur | |
| 17060000071820 | L17/dossiers | 17 | 17060000071818 | 17060000071818 | 2 | PO419610 | ||
| 17060000071824 | L17/dossiers | 17 | 17060000071823 | 17060000071823 | 1 | PA841769 | rapporteur | |
| 17060000071825 | L17/dossiers | 17 | 17060000071823 | 17060000071823 | 2 | PO59051 | ||
| 17060000071828 | L17/dossiers | 17 | 17060000071827 | 17060000071827 | 1 | PA841769 | rapporteur | |
| 17060000071829 | L17/dossiers | 17 | 17060000071827 | 17060000071827 | 2 | PO59051 | ||
| 17060000071832 | L17/dossiers | 17 | 17060000071831 | 17060000071831 | 1 | PA267561 | rapporteur | |
| 17060000071833 | L17/dossiers | 17 | 17060000071831 | 17060000071831 | 2 | PO59051 | ||
| 17060000071836 | L17/dossiers | 17 | 17060000071835 | 17060000071835 | 1 | PA720022 | rapporteur | |
| 17060000071837 | L17/dossiers | 17 | 17060000071835 | 17060000071835 | 2 | PO420120 | ||
| 17060000071840 | L17/dossiers | 17 | 17060000071839 | 17060000071839 | 1 | PA608826 | rapporteur | |
| 17060000071841 | L17/dossiers | 17 | 17060000071839 | 17060000071839 | 2 | PA793398 | rapporteur | |
| 17060000071842 | L17/dossiers | 17 | 17060000071839 | 17060000071839 | 3 | PO419604 | ||
| 17060000071847 | L17/dossiers | 17 | 17060000071846 | 17060000071846 | 1 | PA840983 | rapporteur | |
| 17060000071848 | L17/dossiers | 17 | 17060000071846 | 17060000071846 | 2 | PO420120 | ||
| 17060000071851 | L17/dossiers | 17 | 17060000071850 | 17060000071850 | 1 | PA719404 | rapporteur | |
| 17060000071852 | L17/dossiers | 17 | 17060000071850 | 17060000071850 | 2 | PA795430 | rapporteur | |
| 17060000071853 | L17/dossiers | 17 | 17060000071850 | 17060000071850 | 3 | PO59051 | ||
| 17060000071856 | L17/dossiers | 17 | 17060000071855 | 17060000071855 | 1 | PA606098 | rapporteur | |
| 17060000071857 | L17/dossiers | 17 | 17060000071855 | 17060000071855 | 2 | PO59051 | ||
| 17060000071860 | L17/dossiers | 17 | 17060000071859 | 17060000071859 | 1 | PA721584 | rapporteur | |
| 17060000071861 | L17/dossiers | 17 | 17060000071859 | 17060000071859 | 2 | PO870970 | ||
| 17060000071863 | L17/dossiers | 17 | 17060000071862 | 17060000071862 | 1 | PA712015 | rapporteur | |
| 17060000071864 | L17/dossiers | 17 | 17060000071862 | 17060000071862 | 2 | PO870155 | ||
| 17060000071866 | L17/dossiers | 17 | 17060000071865 | 17060000071865 | 1 | PA720728 | rapporteur | |
| 17060000071867 | L17/dossiers | 17 | 17060000071865 | 17060000071865 | 2 | PO59051 | ||
| 17060000071870 | L17/dossiers | 17 | 17060000071869 | 17060000071869 | 1 | PA720190 | rapporteur | |
| 17060000071871 | L17/dossiers | 17 | 17060000071869 | 17060000071869 | 2 | PO419604 | ||
| 17060000071874 | L17/dossiers | 17 | 17060000071873 | 17060000071873 | 1 | PA841017 | rapporteur | |
| 17060000071875 | L17/dossiers | 17 | 17060000071873 | 17060000071873 | 2 | PO871404 | ||
| 17060000071877 | L17/dossiers | 17 | 17060000071876 | 17060000071876 | 1 | PA266797 | rapporteur | |
| 17060000071878 | L17/dossiers | 17 | 17060000071876 | 17060000071876 | 2 | PO59051 | ||
| 17060000071881 | L17/dossiers | 17 | 17060000071880 | 17060000071880 | 1 | PA795010 | rapporteur |