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 |
|---|---|---|---|---|---|---|---|---|
| 16060000084916 | L16/dossiers | 16 | 16060000084915 | 16060000084915 | 1 | PA795672 | rapporteur | |
| 16060000084917 | L16/dossiers | 16 | 16060000084915 | 16060000084915 | 2 | PO59047 | ||
| 16060000084922 | L16/dossiers | 16 | 16060000084918 | 16060000084918 | 1 | PA719472 | rapporteur | |
| 16060000084923 | L16/dossiers | 16 | 16060000084918 | 16060000084918 | 2 | PO802358 | ||
| 16060000084925 | L16/dossiers | 16 | 16060000084924 | 16060000084924 | 1 | PA719866 | rapporteur | |
| 16060000084926 | L16/dossiers | 16 | 16060000084924 | 16060000084924 | 2 | PO802351 | ||
| 16060000084928 | L16/dossiers | 16 | 16060000084927 | 16060000084927 | 1 | PA719472 | rapporteur | |
| 16060000084929 | L16/dossiers | 16 | 16060000084927 | 16060000084927 | 2 | PO59048 | ||
| 16060000084931 | L16/dossiers | 16 | 16060000084930 | 16060000084930 | 1 | PA721608 | rapporteur | |
| 16060000084932 | L16/dossiers | 16 | 16060000084930 | 16060000084930 | 2 | PO59047 | ||
| 16060000084934 | L16/dossiers | 16 | 16060000084933 | 16060000084933 | 1 | PA721262 | rapporteur | |
| 16060000084935 | L16/dossiers | 16 | 16060000084933 | 16060000084933 | 2 | PO802774 | ||
| 16060000084937 | L16/dossiers | 16 | 16060000084936 | 16060000084936 | 1 | PA795990 | rapporteur | |
| 16060000084938 | L16/dossiers | 16 | 16060000084936 | 16060000084936 | 2 | PA720480 | rapporteur | |
| 16060000084939 | L16/dossiers | 16 | 16060000084936 | 16060000084936 | 3 | PO802944 | ||
| 16060000084941 | L16/dossiers | 16 | 16060000084940 | 16060000084940 | 1 | PA721004 | rapporteur | |
| 16060000084942 | L16/dossiers | 16 | 16060000084940 | 16060000084940 | 2 | PO59047 | ||
| 16060000084944 | L16/dossiers | 16 | 16060000084943 | 16060000084943 | 1 | PA719472 | rapporteur | |
| 16060000084945 | L16/dossiers | 16 | 16060000084943 | 16060000084943 | 2 | PO59048 | ||
| 16060000084947 | L16/dossiers | 16 | 16060000084946 | 16060000084946 | 1 | PA719472 | rapporteur | |
| 16060000084948 | L16/dossiers | 16 | 16060000084946 | 16060000084946 | 2 | PO803014 | ||
| 16060000084950 | L16/dossiers | 16 | 16060000084949 | 16060000084949 | 1 | PA643184 | rapporteur | |
| 16060000084951 | L16/dossiers | 16 | 16060000084949 | 16060000084949 | 2 | PO59047 | ||
| 16060000084956 | L16/dossiers | 16 | 16060000084952 | 16060000084952 | 1 | PA795884 | rapporteur | |
| 16060000084957 | L16/dossiers | 16 | 16060000084952 | 16060000084952 | 2 | PO420120 | ||
| 16060000084962 | L16/dossiers | 16 | 16060000084958 | 16060000084958 | 1 | PA721530 | rapporteur | |
| 16060000084963 | L16/dossiers | 16 | 16060000084958 | 16060000084958 | 2 | PO59048 | ||
| 16060000084968 | L16/dossiers | 16 | 16060000084964 | 16060000084964 | 1 | PA722284 | rapporteur | |
| 16060000084969 | L16/dossiers | 16 | 16060000084964 | 16060000084964 | 2 | PO420120 | ||
| 16060000084974 | L16/dossiers | 16 | 16060000084970 | 16060000084970 | 1 | PA720092 | rapporteur | |
| 16060000084975 | L16/dossiers | 16 | 16060000084970 | 16060000084970 | 2 | PO419865 | ||
| 16060000084980 | L16/dossiers | 16 | 16060000084976 | 16060000084976 | 1 | PA720334 | rapporteur | |
| 16060000084981 | L16/dossiers | 16 | 16060000084976 | 16060000084976 | 2 | PO419865 | ||
| 16060000084983 | L16/dossiers | 16 | 16060000084982 | 16060000084982 | 1 | PA719472 | rapporteur | |
| 16060000084984 | L16/dossiers | 16 | 16060000084982 | 16060000084982 | 2 | PO59048 | ||
| 16060000084986 | L16/dossiers | 16 | 16060000084985 | 16060000084985 | 1 | PA795144 | rapporteur | |
| 16060000084987 | L16/dossiers | 16 | 16060000084985 | 16060000084985 | 2 | PO419610 | ||
| 16060000085151 | L16/dossiers | 16 | 16060000084988 | 16060000084988 | 1 | PA719472 | rapporteur général | |
| 16060000085152 | L16/dossiers | 16 | 16060000084988 | 16060000084988 | 2 | PO59048 | ||
| 16060000085154 | L16/dossiers | 16 | 16060000085153 | 16060000085153 | 1 | PA795068 | rapporteur | |
| 16060000085155 | L16/dossiers | 16 | 16060000085153 | 16060000085153 | 2 | PO59051 | ||
| 16060000085157 | L16/dossiers | 16 | 16060000085156 | 16060000085156 | 1 | PA795466 | rapporteur | |
| 16060000085158 | L16/dossiers | 16 | 16060000085156 | 16060000085156 | 2 | PO59047 | ||
| 16060000085160 | L16/dossiers | 16 | 16060000085159 | 16060000085159 | 1 | PA720684 | rapporteur | |
| 16060000085161 | L16/dossiers | 16 | 16060000085159 | 16060000085159 | 2 | PO59047 | ||
| 16060000085191 | L16/dossiers | 16 | 16060000085162 | 16060000085162 | 1 | PA720066 | rapporteur | |
| 16060000085192 | L16/dossiers | 16 | 16060000085162 | 16060000085162 | 2 | PA720074 | rapporteur | |
| 16060000085193 | L16/dossiers | 16 | 16060000085162 | 16060000085162 | 3 | PA642868 | rapporteur | |
| 16060000085194 | L16/dossiers | 16 | 16060000085162 | 16060000085162 | 4 | PA722374 | rapporteur | |
| 16060000085195 | L16/dossiers | 16 | 16060000085162 | 16060000085162 | 5 | PA642847 | rapporteur |