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 |
|---|---|---|---|---|---|---|---|---|
| 17060000079917 | L17/dossiers | 17 | 17060000079914 | 17060000079914 | 3 | PO869203 | ||
| 17060000079919 | L17/dossiers | 17 | 17060000079918 | 17060000079918 | 1 | PA828016 | rapporteur | |
| 17060000079920 | L17/dossiers | 17 | 17060000079918 | 17060000079918 | 2 | PO211495 | ||
| 17060000079922 | L17/dossiers | 17 | 17060000079921 | 17060000079921 | 1 | PA415488 | rapporteur | |
| 17060000079923 | L17/dossiers | 17 | 17060000079921 | 17060000079921 | 2 | PO516754 | ||
| 17060000079925 | L17/dossiers | 17 | 17060000079924 | 17060000079924 | 1 | PA736174 | rapporteur | |
| 17060000079926 | L17/dossiers | 17 | 17060000079924 | 17060000079924 | 2 | PO211494 | ||
| 17060000079928 | L17/dossiers | 17 | 17060000079927 | 17060000079927 | 1 | PA766947 | rapporteur | |
| 17060000079929 | L17/dossiers | 17 | 17060000079927 | 17060000079927 | 2 | PO516754 | ||
| 17060000079931 | L17/dossiers | 17 | 17060000079930 | 17060000079930 | 1 | PA758716 | rapporteur | |
| 17060000079932 | L17/dossiers | 17 | 17060000079930 | 17060000079930 | 2 | PA827918 | rapporteur | |
| 17060000079933 | L17/dossiers | 17 | 17060000079930 | 17060000079930 | 3 | PO516753 | ||
| 17060000079935 | L17/dossiers | 17 | 17060000079934 | 17060000079934 | 1 | PA827928 | rapporteur | |
| 17060000079936 | L17/dossiers | 17 | 17060000079934 | 17060000079934 | 2 | PO211494 | ||
| 17060000079938 | L17/dossiers | 17 | 17060000079937 | 17060000079937 | 1 | PA775224 | rapporteur | |
| 17060000079939 | L17/dossiers | 17 | 17060000079937 | 17060000079937 | 2 | PO516754 | ||
| 17060000079941 | L17/dossiers | 17 | 17060000079940 | 17060000079940 | 1 | PA827954 | rapporteur | |
| 17060000079942 | L17/dossiers | 17 | 17060000079940 | 17060000079940 | 2 | PO211493 | ||
| 17060000079944 | L17/dossiers | 17 | 17060000079943 | 17060000079943 | 1 | PA775264 | rapporteur | |
| 17060000079945 | L17/dossiers | 17 | 17060000079943 | 17060000079943 | 2 | PO211493 | ||
| 17060000079947 | L17/dossiers | 17 | 17060000079946 | 17060000079946 | 1 | PA719408 | rapporteur | |
| 17060000079948 | L17/dossiers | 17 | 17060000079946 | 17060000079946 | 2 | PO516754 | ||
| 17060000079950 | L17/dossiers | 17 | 17060000079949 | 17060000079949 | 1 | PA773891 | rapporteur | |
| 17060000079951 | L17/dossiers | 17 | 17060000079949 | 17060000079949 | 2 | PO211490 | ||
| 17060000079953 | L17/dossiers | 17 | 17060000079952 | 17060000079952 | 1 | PA775286 | rapporteur | |
| 17060000079954 | L17/dossiers | 17 | 17060000079952 | 17060000079952 | 2 | PA747420 | rapporteur | |
| 17060000079955 | L17/dossiers | 17 | 17060000079952 | 17060000079952 | 3 | PO211495 | ||
| 17060000079957 | L17/dossiers | 17 | 17060000079956 | 17060000079956 | 1 | PA828008 | rapporteur | |
| 17060000079958 | L17/dossiers | 17 | 17060000079956 | 17060000079956 | 2 | PO211495 | ||
| 17060000079960 | L17/dossiers | 17 | 17060000079959 | 17060000079959 | 1 | PA827952 | rapporteur | |
| 17060000079961 | L17/dossiers | 17 | 17060000079959 | 17060000079959 | 2 | PO870658 | ||
| 17060000079963 | L17/dossiers | 17 | 17060000079962 | 17060000079962 | 1 | PA736223 | rapporteur | |
| 17060000079964 | L17/dossiers | 17 | 17060000079962 | 17060000079962 | 2 | PO211493 | ||
| 17060000079966 | L17/dossiers | 17 | 17060000079965 | 17060000079965 | 1 | PA736233 | rapporteur | |
| 17060000079967 | L17/dossiers | 17 | 17060000079965 | 17060000079965 | 2 | PO211493 | ||
| 17060000079969 | L17/dossiers | 17 | 17060000079968 | 17060000079968 | 1 | PA775248 | rapporteur | |
| 17060000079970 | L17/dossiers | 17 | 17060000079968 | 17060000079968 | 2 | PO211495 | ||
| 17060000079972 | L17/dossiers | 17 | 17060000079971 | 17060000079971 | 1 | PA703494 | rapporteur | |
| 17060000079973 | L17/dossiers | 17 | 17060000079971 | 17060000079971 | 2 | PO211495 | ||
| 17060000079975 | L17/dossiers | 17 | 17060000079974 | 17060000079974 | 1 | PA1127 | rapporteur | |
| 17060000079976 | L17/dossiers | 17 | 17060000079974 | 17060000079974 | 2 | PO870970 | ||
| 17060000079978 | L17/dossiers | 17 | 17060000079977 | 17060000079977 | 1 | PA715745 | rapporteur | |
| 17060000079979 | L17/dossiers | 17 | 17060000079977 | 17060000079977 | 2 | PO870155 | ||
| 17060000079981 | L17/dossiers | 17 | 17060000079980 | 17060000079980 | 1 | PA775204 | rapporteur | |
| 17060000079982 | L17/dossiers | 17 | 17060000079980 | 17060000079980 | 2 | PA775208 | rapporteur | |
| 17060000079983 | L17/dossiers | 17 | 17060000079980 | 17060000079980 | 3 | PO516753 | ||
| 17060000079985 | L17/dossiers | 17 | 17060000079984 | 17060000079984 | 1 | PA773891 | rapporteur | |
| 17060000079986 | L17/dossiers | 17 | 17060000079984 | 17060000079984 | 2 | PO871555 | ||
| 17060000079988 | L17/dossiers | 17 | 17060000079987 | 17060000079987 | 1 | PA775302 | rapporteur | |
| 17060000079989 | L17/dossiers | 17 | 17060000079987 | 17060000079987 | 2 | PO211490 |