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 |
|---|---|---|---|---|---|---|---|---|
| 15060000077934 | L15/dossiers | 15 | 15060000077931 | 15060000077931 | 3 | PO789726 | ||
| 15060000077936 | L15/dossiers | 15 | 15060000077935 | 15060000077935 | 1 | PA606639 | rapporteur | |
| 15060000077937 | L15/dossiers | 15 | 15060000077935 | 15060000077935 | 2 | PO59051 | ||
| 15060000077940 | L15/dossiers | 15 | 15060000077939 | 15060000077939 | 1 | PO717460 | ||
| 15060000077943 | L15/dossiers | 15 | 15060000077942 | 15060000077942 | 1 | PO717460 | ||
| 15060000077946 | L15/dossiers | 15 | 15060000077945 | 15060000077945 | 1 | PO717460 | ||
| 15060000077949 | L15/dossiers | 15 | 15060000077948 | 15060000077948 | 1 | PO717460 | ||
| 15060000077952 | L15/dossiers | 15 | 15060000077951 | 15060000077951 | 1 | PO717460 | ||
| 15060000077954 | L15/dossiers | 15 | 15060000077953 | 15060000077953 | 1 | PO717460 | ||
| 15060000077957 | L15/dossiers | 15 | 15060000077956 | 15060000077956 | 1 | PO717460 | ||
| 15060000077960 | L15/dossiers | 15 | 15060000077959 | 15060000077959 | 1 | PO717460 | ||
| 15060000077963 | L15/dossiers | 15 | 15060000077962 | 15060000077962 | 1 | PO717460 | ||
| 15060000077967 | L15/dossiers | 15 | 15060000077966 | 15060000077966 | 1 | PO717460 | ||
| 15060000077970 | L15/dossiers | 15 | 15060000077969 | 15060000077969 | 1 | PO717460 | ||
| 15060000077973 | L15/dossiers | 15 | 15060000077972 | 15060000077972 | 1 | PO717460 | ||
| 15060000077976 | L15/dossiers | 15 | 15060000077975 | 15060000077975 | 1 | PO717460 | ||
| 15060000077979 | L15/dossiers | 15 | 15060000077978 | 15060000077978 | 1 | PO717460 | ||
| 15060000077982 | L15/dossiers | 15 | 15060000077981 | 15060000077981 | 1 | PO717460 | ||
| 15060000077985 | L15/dossiers | 15 | 15060000077984 | 15060000077984 | 1 | PO717460 | ||
| 15060000077987 | L15/dossiers | 15 | 15060000077986 | 15060000077986 | 1 | PO717460 | ||
| 15060000077990 | L15/dossiers | 15 | 15060000077989 | 15060000077989 | 1 | PO717460 | ||
| 15060000077994 | L15/dossiers | 15 | 15060000077993 | 15060000077993 | 1 | PO717460 | ||
| 15060000077997 | L15/dossiers | 15 | 15060000077996 | 15060000077996 | 1 | PO717460 | ||
| 15060000078000 | L15/dossiers | 15 | 15060000077999 | 15060000077999 | 1 | PO717460 | ||
| 15060000078003 | L15/dossiers | 15 | 15060000078002 | 15060000078002 | 1 | PO717460 | ||
| 15060000078005 | L15/dossiers | 15 | 15060000078004 | 15060000078004 | 1 | PO717460 | ||
| 15060000078007 | L15/dossiers | 15 | 15060000078006 | 15060000078006 | 1 | PO717460 | ||
| 15060000078010 | L15/dossiers | 15 | 15060000078009 | 15060000078009 | 1 | PO717460 | ||
| 15060000078013 | L15/dossiers | 15 | 15060000078012 | 15060000078012 | 1 | PO717460 | ||
| 15060000078017 | L15/dossiers | 15 | 15060000078016 | 15060000078016 | 1 | PO717460 | ||
| 15060000078020 | L15/dossiers | 15 | 15060000078019 | 15060000078019 | 1 | PO717460 | ||
| 15060000078023 | L15/dossiers | 15 | 15060000078022 | 15060000078022 | 1 | PO717460 | ||
| 15060000078026 | L15/dossiers | 15 | 15060000078025 | 15060000078025 | 1 | PO717460 | ||
| 15060000078029 | L15/dossiers | 15 | 15060000078028 | 15060000078028 | 1 | PO717460 | ||
| 15060000078032 | L15/dossiers | 15 | 15060000078031 | 15060000078031 | 1 | PO717460 | ||
| 15060000078035 | L15/dossiers | 15 | 15060000078034 | 15060000078034 | 1 | PO717460 | ||
| 15060000078038 | L15/dossiers | 15 | 15060000078037 | 15060000078037 | 1 | PO717460 | ||
| 15060000078041 | L15/dossiers | 15 | 15060000078040 | 15060000078040 | 1 | PO717460 | ||
| 15060000078044 | L15/dossiers | 15 | 15060000078043 | 15060000078043 | 1 | PO717460 | ||
| 15060000078047 | L15/dossiers | 15 | 15060000078046 | 15060000078046 | 1 | PO717460 | ||
| 15060000078050 | L15/dossiers | 15 | 15060000078049 | 15060000078049 | 1 | PO717460 | ||
| 15060000078053 | L15/dossiers | 15 | 15060000078052 | 15060000078052 | 1 | PO717460 | ||
| 15060000078056 | L15/dossiers | 15 | 15060000078055 | 15060000078055 | 1 | PO717460 | ||
| 15060000078059 | L15/dossiers | 15 | 15060000078058 | 15060000078058 | 1 | PO717460 | ||
| 15060000078062 | L15/dossiers | 15 | 15060000078061 | 15060000078061 | 1 | PO717460 | ||
| 15060000078065 | L15/dossiers | 15 | 15060000078064 | 15060000078064 | 1 | PO717460 | ||
| 15060000078068 | L15/dossiers | 15 | 15060000078067 | 15060000078067 | 1 | PO717460 | ||
| 15060000078071 | L15/dossiers | 15 | 15060000078070 | 15060000078070 | 1 | PO717460 | ||
| 15060000078076 | L15/dossiers | 15 | 15060000078075 | 15060000078075 | 1 | PO717460 | ||
| 15060000078080 | L15/dossiers | 15 | 15060000078079 | 15060000078079 | 1 | PO717460 |