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 |
|---|---|---|---|---|---|---|---|---|
| 17060000071882 | L17/dossiers | 17 | 17060000071880 | 17060000071880 | 2 | PO871502 | ||
| 17060000071884 | L17/dossiers | 17 | 17060000071883 | 17060000071883 | 1 | PA794354 | rapporteur | |
| 17060000071885 | L17/dossiers | 17 | 17060000071883 | 17060000071883 | 2 | PO419610 | ||
| 17060000071888 | L17/dossiers | 17 | 17060000071887 | 17060000071887 | 1 | PA841553 | rapporteur | |
| 17060000071889 | L17/dossiers | 17 | 17060000071887 | 17060000071887 | 2 | PO419604 | ||
| 17060000071892 | L17/dossiers | 17 | 17060000071891 | 17060000071891 | 1 | PA266797 | rapporteur | |
| 17060000071893 | L17/dossiers | 17 | 17060000071891 | 17060000071891 | 2 | PO874165 | ||
| 17060000071895 | L17/dossiers | 17 | 17060000071894 | 17060000071894 | 1 | PA719404 | rapporteur | |
| 17060000071896 | L17/dossiers | 17 | 17060000071894 | 17060000071894 | 2 | PA795430 | rapporteur | |
| 17060000071897 | L17/dossiers | 17 | 17060000071894 | 17060000071894 | 3 | PO59051 | ||
| 17060000071900 | L17/dossiers | 17 | 17060000071899 | 17060000071899 | 1 | PA719578 | rapporteur | |
| 17060000071901 | L17/dossiers | 17 | 17060000071899 | 17060000071899 | 2 | PO419610 | ||
| 17060000071904 | L17/dossiers | 17 | 17060000071903 | 17060000071903 | 1 | PA796070 | rapporteur | |
| 17060000071905 | L17/dossiers | 17 | 17060000071903 | 17060000071903 | 2 | PO419610 | ||
| 17060000071908 | L17/dossiers | 17 | 17060000071907 | 17060000071907 | 1 | PA721110 | rapporteur | |
| 17060000071909 | L17/dossiers | 17 | 17060000071907 | 17060000071907 | 2 | PO59051 | ||
| 17060000071912 | L17/dossiers | 17 | 17060000071911 | 17060000071911 | 1 | PA841023 | rapporteur | |
| 17060000071913 | L17/dossiers | 17 | 17060000071911 | 17060000071911 | 2 | PO420120 | ||
| 17060000071916 | L17/dossiers | 17 | 17060000071915 | 17060000071915 | 1 | PA791812 | rapporteur | |
| 17060000071917 | L17/dossiers | 17 | 17060000071915 | 17060000071915 | 2 | PO420120 | ||
| 17060000071920 | L17/dossiers | 17 | 17060000071919 | 17060000071919 | 1 | PA794686 | rapporteur | |
| 17060000071921 | L17/dossiers | 17 | 17060000071919 | 17060000071919 | 2 | PO420120 | ||
| 17060000071924 | L17/dossiers | 17 | 17060000071923 | 17060000071923 | 1 | PA795164 | rapporteur | |
| 17060000071925 | L17/dossiers | 17 | 17060000071923 | 17060000071923 | 2 | PO59048 | ||
| 17060000071928 | L17/dossiers | 17 | 17060000071927 | 17060000071927 | 1 | PA719550 | rapporteur | |
| 17060000071929 | L17/dossiers | 17 | 17060000071927 | 17060000071927 | 2 | PO419865 | ||
| 17060000071932 | L17/dossiers | 17 | 17060000071931 | 17060000071931 | 1 | PA795430 | rapporteur | |
| 17060000071933 | L17/dossiers | 17 | 17060000071931 | 17060000071931 | 2 | PO59051 | ||
| 17060000071936 | L17/dossiers | 17 | 17060000071935 | 17060000071935 | 1 | PA341981 | rapporteur | |
| 17060000071937 | L17/dossiers | 17 | 17060000071935 | 17060000071935 | 2 | PO420120 | ||
| 17060000071940 | L17/dossiers | 17 | 17060000071939 | 17060000071939 | 1 | PA842263 | rapporteur | |
| 17060000071941 | L17/dossiers | 17 | 17060000071939 | 17060000071939 | 2 | PO59051 | ||
| 17060000071944 | L17/dossiers | 17 | 17060000071943 | 17060000071943 | 1 | PA840829 | rapporteur | |
| 17060000071945 | L17/dossiers | 17 | 17060000071943 | 17060000071943 | 2 | PO419865 | ||
| 17060000071948 | L17/dossiers | 17 | 17060000071947 | 17060000071947 | 1 | PA643157 | rapporteur | |
| 17060000071949 | L17/dossiers | 17 | 17060000071947 | 17060000071947 | 2 | PO419610 | ||
| 17060000071952 | L17/dossiers | 17 | 17060000071951 | 17060000071951 | 1 | PA794854 | rapporteur | |
| 17060000071953 | L17/dossiers | 17 | 17060000071951 | 17060000071951 | 2 | PO419610 | ||
| 17060000071956 | L17/dossiers | 17 | 17060000071955 | 17060000071955 | 1 | PA608264 | rapporteur | |
| 17060000071957 | L17/dossiers | 17 | 17060000071955 | 17060000071955 | 2 | PO59051 | ||
| 17060000071960 | L17/dossiers | 17 | 17060000071959 | 17060000071959 | 1 | PA841091 | rapporteur | |
| 17060000071961 | L17/dossiers | 17 | 17060000071959 | 17060000071959 | 2 | PO420120 | ||
| 17060000071964 | L17/dossiers | 17 | 17060000071963 | 17060000071963 | 1 | PA340343 | rapporteur | |
| 17060000071965 | L17/dossiers | 17 | 17060000071963 | 17060000071963 | 2 | PA340343 | rapporteur | |
| 17060000071966 | L17/dossiers | 17 | 17060000071963 | 17060000071963 | 3 | PO59051 | ||
| 17060000071969 | L17/dossiers | 17 | 17060000071968 | 17060000071968 | 1 | PA721296 | rapporteur | |
| 17060000071970 | L17/dossiers | 17 | 17060000071968 | 17060000071968 | 2 | PA335054 | rapporteur | |
| 17060000071971 | L17/dossiers | 17 | 17060000071968 | 17060000071968 | 3 | PO59051 | ||
| 17060000071974 | L17/dossiers | 17 | 17060000071973 | 17060000071973 | 1 | PA642847 | rapporteur | |
| 17060000071975 | L17/dossiers | 17 | 17060000071973 | 17060000071973 | 2 | PO420120 |