dossiers.document_auteur
Chemin document.auteurs.auteur · présence : L17 100 %, L16 100 %, L15 100 %, L14 100 %
59 594 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 |
|---|---|---|---|---|---|---|---|---|
| 17060000005688 | L17/dossiers | 17 | 17060000005687 | 17060000005687 | 1 | PA608172 | auteur | |
| 17060000005721 | L17/dossiers | 17 | 17060000005720 | 17060000005720 | 1 | PA795762 | auteur | |
| 17060000005769 | L17/dossiers | 17 | 17060000005768 | 17060000005768 | 1 | PA793306 | auteur | |
| 17060000005801 | L17/dossiers | 17 | 17060000005800 | 17060000005800 | 1 | PO791932 | ||
| 17060000005804 | L17/dossiers | 17 | 17060000005803 | 17060000005803 | 1 | PO791932 | ||
| 17060000005807 | L17/dossiers | 17 | 17060000005806 | 17060000005806 | 1 | PO791932 | ||
| 17060000005810 | L17/dossiers | 17 | 17060000005809 | 17060000005809 | 1 | PA795026 | auteur | |
| 17060000005842 | L17/dossiers | 17 | 17060000005841 | 17060000005841 | 1 | PO791932 | ||
| 17060000005845 | L17/dossiers | 17 | 17060000005844 | 17060000005844 | 1 | PA722150 | auteur | |
| 17060000006015 | L17/dossiers | 17 | 17060000006014 | 17060000006014 | 1 | PO791932 | ||
| 17060000006018 | L17/dossiers | 17 | 17060000006017 | 17060000006017 | 1 | PO791932 | ||
| 17060000006021 | L17/dossiers | 17 | 17060000006020 | 17060000006020 | 1 | PO791932 | ||
| 17060000006024 | L17/dossiers | 17 | 17060000006023 | 17060000006023 | 1 | PO791932 | ||
| 17060000006027 | L17/dossiers | 17 | 17060000006026 | 17060000006026 | 1 | PO791932 | ||
| 17060000006030 | L17/dossiers | 17 | 17060000006029 | 17060000006029 | 1 | PA793948 | auteur | |
| 17060000006054 | L17/dossiers | 17 | 17060000006053 | 17060000006053 | 1 | PO791932 | ||
| 17060000006057 | L17/dossiers | 17 | 17060000006056 | 17060000006056 | 1 | PO791932 | ||
| 17060000006060 | L17/dossiers | 17 | 17060000006059 | 17060000006059 | 1 | PO791932 | ||
| 17060000006063 | L17/dossiers | 17 | 17060000006062 | 17060000006062 | 1 | PO791932 | ||
| 17060000006066 | L17/dossiers | 17 | 17060000006065 | 17060000006065 | 1 | PO791932 | ||
| 17060000006069 | L17/dossiers | 17 | 17060000006068 | 17060000006068 | 1 | PO791932 | ||
| 17060000006072 | L17/dossiers | 17 | 17060000006071 | 17060000006071 | 1 | PO791932 | ||
| 17060000006075 | L17/dossiers | 17 | 17060000006074 | 17060000006074 | 1 | PO791932 | ||
| 17060000006078 | L17/dossiers | 17 | 17060000006077 | 17060000006077 | 1 | PO791932 | ||
| 17060000006081 | L17/dossiers | 17 | 17060000006080 | 17060000006080 | 1 | PO791932 | ||
| 17060000006084 | L17/dossiers | 17 | 17060000006083 | 17060000006083 | 1 | PO791932 | ||
| 17060000006087 | L17/dossiers | 17 | 17060000006086 | 17060000006086 | 1 | PO791932 | ||
| 17060000006090 | L17/dossiers | 17 | 17060000006089 | 17060000006089 | 1 | PA720692 | auteur | |
| 17060000006114 | L17/dossiers | 17 | 17060000006113 | 17060000006113 | 1 | PO791932 | ||
| 17060000006117 | L17/dossiers | 17 | 17060000006116 | 17060000006116 | 1 | PO791932 | ||
| 17060000006120 | L17/dossiers | 17 | 17060000006119 | 17060000006119 | 1 | PO791932 | ||
| 17060000006123 | L17/dossiers | 17 | 17060000006122 | 17060000006122 | 1 | PO791932 | ||
| 17060000006126 | L17/dossiers | 17 | 17060000006125 | 17060000006125 | 1 | PO791932 | ||
| 17060000006129 | L17/dossiers | 17 | 17060000006128 | 17060000006128 | 1 | PO791932 | ||
| 17060000006132 | L17/dossiers | 17 | 17060000006131 | 17060000006131 | 1 | PO791932 | ||
| 17060000006135 | L17/dossiers | 17 | 17060000006134 | 17060000006134 | 1 | PO791932 | ||
| 17060000006138 | L17/dossiers | 17 | 17060000006137 | 17060000006137 | 1 | PO791932 | ||
| 17060000006141 | L17/dossiers | 17 | 17060000006140 | 17060000006140 | 1 | PO791932 | ||
| 17060000006144 | L17/dossiers | 17 | 17060000006143 | 17060000006143 | 1 | PO791932 | ||
| 17060000006147 | L17/dossiers | 17 | 17060000006146 | 17060000006146 | 1 | PO791932 | ||
| 17060000006150 | L17/dossiers | 17 | 17060000006149 | 17060000006149 | 1 | PO791932 | ||
| 17060000006153 | L17/dossiers | 17 | 17060000006152 | 17060000006152 | 1 | PO791932 | ||
| 17060000006156 | L17/dossiers | 17 | 17060000006155 | 17060000006155 | 1 | PO791932 | ||
| 17060000006159 | L17/dossiers | 17 | 17060000006158 | 17060000006158 | 1 | PO791932 | ||
| 17060000006162 | L17/dossiers | 17 | 17060000006161 | 17060000006161 | 1 | PO791932 | ||
| 17060000006165 | L17/dossiers | 17 | 17060000006164 | 17060000006164 | 1 | PO791932 | ||
| 17060000006168 | L17/dossiers | 17 | 17060000006167 | 17060000006167 | 1 | PO791932 | ||
| 17060000006171 | L17/dossiers | 17 | 17060000006170 | 17060000006170 | 1 | PO791932 | ||
| 17060000006174 | L17/dossiers | 17 | 17060000006173 | 17060000006173 | 1 | PO791932 | ||
| 17060000006177 | L17/dossiers | 17 | 17060000006176 | 17060000006176 | 1 | PO791932 |