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 |
|---|---|---|---|---|---|---|---|---|
| 16060000082905 | L16/dossiers | 16 | 16060000082904 | 16060000082904 | 1 | PO791932 | ||
| 16060000082909 | L16/dossiers | 16 | 16060000082908 | 16060000082908 | 1 | PO791932 | ||
| 16060000082912 | L16/dossiers | 16 | 16060000082911 | 16060000082911 | 1 | PO791932 | ||
| 16060000082915 | L16/dossiers | 16 | 16060000082914 | 16060000082914 | 1 | PO791932 | ||
| 16060000082918 | L16/dossiers | 16 | 16060000082917 | 16060000082917 | 1 | PO791932 | ||
| 16060000082921 | L16/dossiers | 16 | 16060000082920 | 16060000082920 | 1 | PO791932 | ||
| 16060000082924 | L16/dossiers | 16 | 16060000082923 | 16060000082923 | 1 | PO791932 | ||
| 16060000082927 | L16/dossiers | 16 | 16060000082926 | 16060000082926 | 1 | PO791932 | ||
| 16060000082930 | L16/dossiers | 16 | 16060000082929 | 16060000082929 | 1 | PO791932 | ||
| 16060000082933 | L16/dossiers | 16 | 16060000082932 | 16060000082932 | 1 | PO791932 | ||
| 16060000082936 | L16/dossiers | 16 | 16060000082935 | 16060000082935 | 1 | PO791932 | ||
| 16060000082939 | L16/dossiers | 16 | 16060000082938 | 16060000082938 | 1 | PO791932 | ||
| 16060000082941 | L16/dossiers | 16 | 16060000082940 | 16060000082940 | 1 | PO791932 | ||
| 16060000082943 | L16/dossiers | 16 | 16060000082942 | 16060000082942 | 1 | PO791932 | ||
| 16060000082945 | L16/dossiers | 16 | 16060000082944 | 16060000082944 | 1 | PO791932 | ||
| 16060000082948 | L16/dossiers | 16 | 16060000082947 | 16060000082947 | 1 | PO791932 | ||
| 16060000082952 | L16/dossiers | 16 | 16060000082951 | 16060000082951 | 1 | PO791932 | ||
| 16060000082955 | L16/dossiers | 16 | 16060000082954 | 16060000082954 | 1 | PO791932 | ||
| 16060000082965 | L16/dossiers | 16 | 16060000082964 | 16060000082964 | 1 | PO791932 | ||
| 16060000082967 | L16/dossiers | 16 | 16060000082966 | 16060000082966 | 1 | PO791932 | ||
| 16060000082969 | L16/dossiers | 16 | 16060000082968 | 16060000082968 | 1 | PO791932 | ||
| 16060000082972 | L16/dossiers | 16 | 16060000082971 | 16060000082971 | 1 | PO791932 | ||
| 16060000082974 | L16/dossiers | 16 | 16060000082973 | 16060000082973 | 1 | PO791932 | ||
| 16060000082976 | L16/dossiers | 16 | 16060000082975 | 16060000082975 | 1 | PO791932 | ||
| 16060000082979 | L16/dossiers | 16 | 16060000082978 | 16060000082978 | 1 | PO791932 | ||
| 16060000082982 | L16/dossiers | 16 | 16060000082981 | 16060000082981 | 1 | PO791932 | ||
| 16060000082985 | L16/dossiers | 16 | 16060000082984 | 16060000082984 | 1 | PO791932 | ||
| 16060000082988 | L16/dossiers | 16 | 16060000082987 | 16060000082987 | 1 | PO791932 | ||
| 16060000082992 | L16/dossiers | 16 | 16060000082991 | 16060000082991 | 1 | PO791932 | ||
| 16060000082995 | L16/dossiers | 16 | 16060000082994 | 16060000082994 | 1 | PO791932 | ||
| 16060000082998 | L16/dossiers | 16 | 16060000082997 | 16060000082997 | 1 | PO791932 | ||
| 16060000083001 | L16/dossiers | 16 | 16060000083000 | 16060000083000 | 1 | PO791932 | ||
| 16060000083003 | L16/dossiers | 16 | 16060000083002 | 16060000083002 | 1 | PO791932 | ||
| 16060000083006 | L16/dossiers | 16 | 16060000083005 | 16060000083005 | 1 | PO791932 | ||
| 16060000083009 | L16/dossiers | 16 | 16060000083008 | 16060000083008 | 1 | PO791932 | ||
| 16060000083012 | L16/dossiers | 16 | 16060000083011 | 16060000083011 | 1 | PO791932 | ||
| 16060000083015 | L16/dossiers | 16 | 16060000083014 | 16060000083014 | 1 | PO791932 | ||
| 16060000083018 | L16/dossiers | 16 | 16060000083017 | 16060000083017 | 1 | PO791932 | ||
| 16060000083021 | L16/dossiers | 16 | 16060000083020 | 16060000083020 | 1 | PO791932 | ||
| 16060000083024 | L16/dossiers | 16 | 16060000083023 | 16060000083023 | 1 | PO791932 | ||
| 16060000083030 | L16/dossiers | 16 | 16060000083029 | 16060000083029 | 1 | PO791932 | ||
| 16060000083034 | L16/dossiers | 16 | 16060000083033 | 16060000083033 | 1 | PO791932 | ||
| 16060000083037 | L16/dossiers | 16 | 16060000083036 | 16060000083036 | 1 | PO791932 | ||
| 16060000083039 | L16/dossiers | 16 | 16060000083038 | 16060000083038 | 1 | PO791932 | ||
| 16060000083042 | L16/dossiers | 16 | 16060000083041 | 16060000083041 | 1 | PO791932 | ||
| 16060000083045 | L16/dossiers | 16 | 16060000083044 | 16060000083044 | 1 | PO791932 | ||
| 16060000083048 | L16/dossiers | 16 | 16060000083047 | 16060000083047 | 1 | PO791932 | ||
| 16060000083051 | L16/dossiers | 16 | 16060000083050 | 16060000083050 | 1 | PO791932 | ||
| 16060000083053 | L16/dossiers | 16 | 16060000083052 | 16060000083052 | 1 | PO791932 | ||
| 16060000083055 | L16/dossiers | 16 | 16060000083054 | 16060000083054 | 1 | PO791932 |