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 |
|---|---|---|---|---|---|---|---|---|
| 16060000062915 | L16/dossiers | 16 | 16060000062913 | 16060000062913 | 2 | PO211495 | ||
| 16060000062917 | L16/dossiers | 16 | 16060000062916 | 16060000062916 | 1 | PA703510 | rapporteur | |
| 16060000062918 | L16/dossiers | 16 | 16060000062916 | 16060000062916 | 2 | PO211495 | ||
| 16060000062920 | L16/dossiers | 16 | 16060000062919 | 16060000062919 | 1 | PA744079 | rapporteur | |
| 16060000062921 | L16/dossiers | 16 | 16060000062919 | 16060000062919 | 2 | PO211494 | ||
| 16060000062923 | L16/dossiers | 16 | 16060000062922 | 16060000062922 | 1 | PA775236 | rapporteur | |
| 16060000062924 | L16/dossiers | 16 | 16060000062922 | 16060000062922 | 2 | PO211490 | ||
| 16060000062926 | L16/dossiers | 16 | 16060000062925 | 16060000062925 | 1 | PA757676 | rapporteur | |
| 16060000062927 | L16/dossiers | 16 | 16060000062925 | 16060000062925 | 2 | PO211493 | ||
| 16060000062929 | L16/dossiers | 16 | 16060000062928 | 16060000062928 | 1 | PA736197 | rapporteur | |
| 16060000062930 | L16/dossiers | 16 | 16060000062928 | 16060000062928 | 2 | PO822133 | ||
| 16060000062932 | L16/dossiers | 16 | 16060000062931 | 16060000062931 | 1 | PA331381 | rapporteur | |
| 16060000062933 | L16/dossiers | 16 | 16060000062931 | 16060000062931 | 2 | PO211490 | ||
| 16060000062935 | L16/dossiers | 16 | 16060000062934 | 16060000062934 | 1 | PA703515 | rapporteur | |
| 16060000062936 | L16/dossiers | 16 | 16060000062934 | 16060000062934 | 2 | PO821826 | ||
| 16060000062938 | L16/dossiers | 16 | 16060000062937 | 16060000062937 | 1 | PA775212 | rapporteur | |
| 16060000062939 | L16/dossiers | 16 | 16060000062937 | 16060000062937 | 2 | PO516754 | ||
| 16060000062941 | L16/dossiers | 16 | 16060000062940 | 16060000062940 | 1 | PA736165 | rapporteur | |
| 16060000062942 | L16/dossiers | 16 | 16060000062940 | 16060000062940 | 2 | PO211493 | ||
| 16060000062944 | L16/dossiers | 16 | 16060000062943 | 16060000062943 | 1 | PA703520 | rapporteur | |
| 16060000062945 | L16/dossiers | 16 | 16060000062943 | 16060000062943 | 2 | PO516753 | ||
| 16060000062947 | L16/dossiers | 16 | 16060000062946 | 16060000062946 | 1 | PA775284 | rapporteur | |
| 16060000062948 | L16/dossiers | 16 | 16060000062946 | 16060000062946 | 2 | PO211494 | ||
| 16060000062950 | L16/dossiers | 16 | 16060000062949 | 16060000062949 | 1 | PA330684 | rapporteur | |
| 16060000062951 | L16/dossiers | 16 | 16060000062949 | 16060000062949 | 2 | PO211495 | ||
| 16060000062953 | L16/dossiers | 16 | 16060000062952 | 16060000062952 | 1 | PA788192 | rapporteur | |
| 16060000062954 | L16/dossiers | 16 | 16060000062952 | 16060000062952 | 2 | PO516753 | ||
| 16060000062956 | L16/dossiers | 16 | 16060000062955 | 16060000062955 | 1 | PA703492 | rapporteur | |
| 16060000062957 | L16/dossiers | 16 | 16060000062955 | 16060000062955 | 2 | PO211495 | ||
| 16060000062959 | L16/dossiers | 16 | 16060000062958 | 16060000062958 | 1 | PA736207 | rapporteur | |
| 16060000062960 | L16/dossiers | 16 | 16060000062958 | 16060000062958 | 2 | PO211493 | ||
| 16060000062962 | L16/dossiers | 16 | 16060000062961 | 16060000062961 | 1 | PA703522 | rapporteur | |
| 16060000062963 | L16/dossiers | 16 | 16060000062961 | 16060000062961 | 2 | PO211495 | ||
| 16060000062965 | L16/dossiers | 16 | 16060000062964 | 16060000062964 | 1 | PA775192 | rapporteur | |
| 16060000062966 | L16/dossiers | 16 | 16060000062964 | 16060000062964 | 2 | PO211490 | ||
| 16060000062968 | L16/dossiers | 16 | 16060000062967 | 16060000062967 | 1 | PA429842 | rapporteur | |
| 16060000062969 | L16/dossiers | 16 | 16060000062967 | 16060000062967 | 2 | PO516753 | ||
| 16060000062971 | L16/dossiers | 16 | 16060000062970 | 16060000062970 | 1 | PA736247 | rapporteur | |
| 16060000062972 | L16/dossiers | 16 | 16060000062970 | 16060000062970 | 2 | PO516753 | ||
| 16060000062974 | L16/dossiers | 16 | 16060000062973 | 16060000062973 | 1 | PA775198 | rapporteur | |
| 16060000062975 | L16/dossiers | 16 | 16060000062973 | 16060000062973 | 2 | PO211490 | ||
| 16060000062977 | L16/dossiers | 16 | 16060000062976 | 16060000062976 | 1 | PA788192 | rapporteur | |
| 16060000062978 | L16/dossiers | 16 | 16060000062976 | 16060000062976 | 2 | PO823673 | ||
| 16060000062980 | L16/dossiers | 16 | 16060000062979 | 16060000062979 | 1 | PA429858 | rapporteur | |
| 16060000062981 | L16/dossiers | 16 | 16060000062979 | 16060000062979 | 2 | PO211495 | ||
| 16060000062983 | L16/dossiers | 16 | 16060000062982 | 16060000062982 | 1 | PA736165 | rapporteur | |
| 16060000062984 | L16/dossiers | 16 | 16060000062982 | 16060000062982 | 2 | PO823528 | ||
| 16060000062986 | L16/dossiers | 16 | 16060000062985 | 16060000062985 | 1 | PA330684 | rapporteur | |
| 16060000062987 | L16/dossiers | 16 | 16060000062985 | 16060000062985 | 2 | PO823746 | ||
| 16060000062989 | L16/dossiers | 16 | 16060000062988 | 16060000062988 | 1 | PA703520 | rapporteur |