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 |
|---|---|---|---|---|---|---|---|---|
| 16060000083906 | L16/dossiers | 16 | 16060000083905 | 16060000083905 | 1 | PA717161 | auteur | |
| 16060000083911 | L16/dossiers | 16 | 16060000083910 | 16060000083910 | 1 | PO78718 | ||
| 16060000083913 | L16/dossiers | 16 | 16060000083912 | 16060000083912 | 1 | PO78718 | ||
| 16060000083915 | L16/dossiers | 16 | 16060000083914 | 16060000083914 | 1 | PO78718 | ||
| 16060000083917 | L16/dossiers | 16 | 16060000083916 | 16060000083916 | 1 | PA717161 | auteur | |
| 16060000083922 | L16/dossiers | 16 | 16060000083921 | 16060000083921 | 1 | PO78718 | ||
| 16060000083924 | L16/dossiers | 16 | 16060000083923 | 16060000083923 | 1 | PO78718 | ||
| 16060000083926 | L16/dossiers | 16 | 16060000083925 | 16060000083925 | 1 | PA717161 | auteur | |
| 16060000083929 | L16/dossiers | 16 | 16060000083928 | 16060000083928 | 1 | PA717161 | auteur | |
| 16060000083932 | L16/dossiers | 16 | 16060000083931 | 16060000083931 | 1 | PO78718 | ||
| 16060000083934 | L16/dossiers | 16 | 16060000083933 | 16060000083933 | 1 | PA717161 | auteur | |
| 16060000083937 | L16/dossiers | 16 | 16060000083936 | 16060000083936 | 1 | PO78718 | ||
| 16060000083939 | L16/dossiers | 16 | 16060000083938 | 16060000083938 | 1 | PA717161 | auteur | |
| 16060000083942 | L16/dossiers | 16 | 16060000083941 | 16060000083941 | 1 | PO78718 | ||
| 16060000083944 | L16/dossiers | 16 | 16060000083943 | 16060000083943 | 1 | PO78718 | ||
| 16060000083946 | L16/dossiers | 16 | 16060000083945 | 16060000083945 | 1 | PO78718 | ||
| 16060000083948 | L16/dossiers | 16 | 16060000083947 | 16060000083947 | 1 | PA717161 | auteur | |
| 16060000083952 | L16/dossiers | 16 | 16060000083951 | 16060000083951 | 1 | PA717161 | auteur | |
| 16060000083955 | L16/dossiers | 16 | 16060000083954 | 16060000083954 | 1 | PA717161 | auteur | |
| 16060000083959 | L16/dossiers | 16 | 16060000083958 | 16060000083958 | 1 | PA717161 | auteur | |
| 16060000083962 | L16/dossiers | 16 | 16060000083961 | 16060000083961 | 1 | PA717161 | auteur | |
| 16060000083966 | L16/dossiers | 16 | 16060000083965 | 16060000083965 | 1 | PA717161 | auteur | |
| 16060000083969 | L16/dossiers | 16 | 16060000083968 | 16060000083968 | 1 | PA717161 | auteur | |
| 16060000083972 | L16/dossiers | 16 | 16060000083971 | 16060000083971 | 1 | PA717161 | auteur | |
| 16060000083975 | L16/dossiers | 16 | 16060000083974 | 16060000083974 | 1 | PA717161 | auteur | |
| 16060000083978 | L16/dossiers | 16 | 16060000083977 | 16060000083977 | 1 | PA717161 | auteur | |
| 16060000083983 | L16/dossiers | 16 | 16060000083982 | 16060000083982 | 1 | PO78718 | ||
| 16060000083985 | L16/dossiers | 16 | 16060000083984 | 16060000083984 | 1 | PO78718 | ||
| 16060000083987 | L16/dossiers | 16 | 16060000083986 | 16060000083986 | 1 | PO78718 | ||
| 16060000083989 | L16/dossiers | 16 | 16060000083988 | 16060000083988 | 1 | PA717161 | auteur | |
| 16060000083993 | L16/dossiers | 16 | 16060000083992 | 16060000083992 | 1 | PO78718 | ||
| 16060000083995 | L16/dossiers | 16 | 16060000083994 | 16060000083994 | 1 | PO78718 | ||
| 16060000083997 | L16/dossiers | 16 | 16060000083996 | 16060000083996 | 1 | PO78718 | ||
| 16060000083999 | L16/dossiers | 16 | 16060000083998 | 16060000083998 | 1 | PO78718 | ||
| 16060000084001 | L16/dossiers | 16 | 16060000084000 | 16060000084000 | 1 | PO78718 | ||
| 16060000084003 | L16/dossiers | 16 | 16060000084002 | 16060000084002 | 1 | PO78718 | ||
| 16060000084005 | L16/dossiers | 16 | 16060000084004 | 16060000084004 | 1 | PO78718 | ||
| 16060000084007 | L16/dossiers | 16 | 16060000084006 | 16060000084006 | 1 | PA717161 | auteur | |
| 16060000084010 | L16/dossiers | 16 | 16060000084009 | 16060000084009 | 1 | PA717161 | auteur | |
| 16060000084013 | L16/dossiers | 16 | 16060000084012 | 16060000084012 | 1 | PO78718 | ||
| 16060000084015 | L16/dossiers | 16 | 16060000084014 | 16060000084014 | 1 | PO78718 | ||
| 16060000084017 | L16/dossiers | 16 | 16060000084016 | 16060000084016 | 1 | PA717161 | auteur | |
| 16060000084020 | L16/dossiers | 16 | 16060000084019 | 16060000084019 | 1 | PO78718 | ||
| 16060000084022 | L16/dossiers | 16 | 16060000084021 | 16060000084021 | 1 | PO78718 | ||
| 16060000084024 | L16/dossiers | 16 | 16060000084023 | 16060000084023 | 1 | PO78718 | ||
| 16060000084026 | L16/dossiers | 16 | 16060000084025 | 16060000084025 | 1 | PO78718 | ||
| 16060000084028 | L16/dossiers | 16 | 16060000084027 | 16060000084027 | 1 | PO78718 | ||
| 16060000084030 | L16/dossiers | 16 | 16060000084029 | 16060000084029 | 1 | PO78718 | ||
| 16060000084032 | L16/dossiers | 16 | 16060000084031 | 16060000084031 | 1 | PO78718 | ||
| 16060000084034 | L16/dossiers | 16 | 16060000084033 | 16060000084033 | 1 | PO78718 |