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 |
|---|---|---|---|---|---|---|---|---|
| 14060000062078 | L14/dossiers | 14 | 14060000062076 | 14060000062076 | 2 | PO211495 | ||
| 14060000062080 | L14/dossiers | 14 | 14060000062079 | 14060000062079 | 1 | PO717460 | ||
| 14060000062083 | L14/dossiers | 14 | 14060000062082 | 14060000062082 | 1 | PA2538 | auteur | |
| 14060000062135 | L14/dossiers | 14 | 14060000062134 | 14060000062134 | 1 | PA2952 | auteur | |
| 14060000062138 | L14/dossiers | 14 | 14060000062137 | 14060000062137 | 1 | PA330240 | auteur | |
| 14060000062166 | L14/dossiers | 14 | 14060000062165 | 14060000062165 | 1 | PA610775 | auteur | |
| 14060000062170 | L14/dossiers | 14 | 14060000062169 | 14060000062169 | 1 | PA328 | auteur | |
| 14060000062174 | L14/dossiers | 14 | 14060000062173 | 14060000062173 | 1 | PO78718 | ||
| 14060000062176 | L14/dossiers | 14 | 14060000062175 | 14060000062175 | 1 | PA610752 | rapporteur | |
| 14060000062177 | L14/dossiers | 14 | 14060000062175 | 14060000062175 | 2 | PO59047 | ||
| 14060000062179 | L14/dossiers | 14 | 14060000062178 | 14060000062178 | 1 | PA725 | rapporteur | |
| 14060000062180 | L14/dossiers | 14 | 14060000062178 | 14060000062178 | 2 | PO211491 | ||
| 14060000062182 | L14/dossiers | 14 | 14060000062181 | 14060000062181 | 1 | PA328 | auteur | |
| 14060000062184 | L14/dossiers | 14 | 14060000062183 | 14060000062183 | 1 | PA609218 | rapporteur | |
| 14060000062185 | L14/dossiers | 14 | 14060000062183 | 14060000062183 | 2 | PO415287 | ||
| 14060000062187 | L14/dossiers | 14 | 14060000062186 | 14060000062186 | 1 | PA608186 | rapporteur | |
| 14060000062188 | L14/dossiers | 14 | 14060000062186 | 14060000062186 | 2 | PO415287 | ||
| 14060000062190 | L14/dossiers | 14 | 14060000062189 | 14060000062189 | 1 | PA609816 | rapporteur | |
| 14060000062191 | L14/dossiers | 14 | 14060000062189 | 14060000062189 | 2 | PO420120 | ||
| 14060000062193 | L14/dossiers | 14 | 14060000062192 | 14060000062192 | 1 | PA609816 | auteur | |
| 14060000062213 | L14/dossiers | 14 | 14060000062212 | 14060000062212 | 1 | PO644420 | ||
| 14060000062216 | L14/dossiers | 14 | 14060000062215 | 14060000062215 | 1 | PA328 | auteur | |
| 14060000062219 | L14/dossiers | 14 | 14060000062218 | 14060000062218 | 1 | PA334 | rapporteur | |
| 14060000062220 | L14/dossiers | 14 | 14060000062218 | 14060000062218 | 2 | PO59047 | ||
| 14060000062222 | L14/dossiers | 14 | 14060000062221 | 14060000062221 | 1 | PA328 | auteur | |
| 14060000062224 | L14/dossiers | 14 | 14060000062223 | 14060000062223 | 1 | PA328 | auteur | |
| 14060000062226 | L14/dossiers | 14 | 14060000062225 | 14060000062225 | 1 | PO78718 | ||
| 14060000062228 | L14/dossiers | 14 | 14060000062227 | 14060000062227 | 1 | PO78718 | ||
| 14060000062230 | L14/dossiers | 14 | 14060000062229 | 14060000062229 | 1 | PA267622 | auteur | |
| 14060000062235 | L14/dossiers | 14 | 14060000062234 | 14060000062234 | 1 | PO644420 | ||
| 14060000062238 | L14/dossiers | 14 | 14060000062237 | 14060000062237 | 1 | PO644420 | ||
| 14060000062247 | L14/dossiers | 14 | 14060000062240 | 14060000062240 | 1 | PA609590 | rapporteur | |
| 14060000062248 | L14/dossiers | 14 | 14060000062240 | 14060000062240 | 2 | PO59048 | ||
| 14060000062250 | L14/dossiers | 14 | 14060000062249 | 14060000062249 | 1 | PA415448 | rapporteur | |
| 14060000062251 | L14/dossiers | 14 | 14060000062249 | 14060000062249 | 2 | PO716192 | ||
| 14060000062253 | L14/dossiers | 14 | 14060000062252 | 14060000062252 | 1 | PA609590 | rapporteur | |
| 14060000062254 | L14/dossiers | 14 | 14060000062252 | 14060000062252 | 2 | PO59048 | ||
| 14060000062262 | L14/dossiers | 14 | 14060000062255 | 14060000062255 | 1 | PA415448 | rapporteur | |
| 14060000062263 | L14/dossiers | 14 | 14060000062255 | 14060000062255 | 2 | PO211494 | ||
| 14060000062265 | L14/dossiers | 14 | 14060000062264 | 14060000062264 | 1 | PA415448 | rapporteur | |
| 14060000062266 | L14/dossiers | 14 | 14060000062264 | 14060000062264 | 2 | PO211494 | ||
| 14060000062268 | L14/dossiers | 14 | 14060000062267 | 14060000062267 | 1 | PA609590 | rapporteur | |
| 14060000062269 | L14/dossiers | 14 | 14060000062267 | 14060000062267 | 2 | PO59048 | ||
| 14060000062271 | L14/dossiers | 14 | 14060000062270 | 14060000062270 | 1 | PA609590 | rapporteur | |
| 14060000062272 | L14/dossiers | 14 | 14060000062270 | 14060000062270 | 2 | PO716192 | ||
| 14060000062274 | L14/dossiers | 14 | 14060000062273 | 14060000062273 | 1 | PA268019 | auteur | |
| 14060000062278 | L14/dossiers | 14 | 14060000062277 | 14060000062277 | 1 | PA2250 | auteur | |
| 14060000062300 | L14/dossiers | 14 | 14060000062299 | 14060000062299 | 1 | PA1198 | rapporteur | |
| 14060000062301 | L14/dossiers | 14 | 14060000062299 | 14060000062299 | 2 | PO59051 | ||
| 14060000062303 | L14/dossiers | 14 | 14060000062302 | 14060000062302 | 1 | PA608695 | rapporteur |