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 |
|---|---|---|---|---|---|---|---|---|
| 15060000076209 | L15/dossiers | 15 | 15060000076208 | 15060000076208 | 1 | PO717460 | ||
| 15060000076212 | L15/dossiers | 15 | 15060000076211 | 15060000076211 | 1 | PO717460 | ||
| 15060000076215 | L15/dossiers | 15 | 15060000076214 | 15060000076214 | 1 | PO717460 | ||
| 15060000076218 | L15/dossiers | 15 | 15060000076217 | 15060000076217 | 1 | PO717460 | ||
| 15060000076221 | L15/dossiers | 15 | 15060000076220 | 15060000076220 | 1 | PO717460 | ||
| 15060000076223 | L15/dossiers | 15 | 15060000076222 | 15060000076222 | 1 | PO717460 | ||
| 15060000076226 | L15/dossiers | 15 | 15060000076225 | 15060000076225 | 1 | PO717460 | ||
| 15060000076229 | L15/dossiers | 15 | 15060000076228 | 15060000076228 | 1 | PO717460 | ||
| 15060000076232 | L15/dossiers | 15 | 15060000076231 | 15060000076231 | 1 | PO717460 | ||
| 15060000076235 | L15/dossiers | 15 | 15060000076234 | 15060000076234 | 1 | PO717460 | ||
| 15060000076238 | L15/dossiers | 15 | 15060000076237 | 15060000076237 | 1 | PO717460 | ||
| 15060000076241 | L15/dossiers | 15 | 15060000076240 | 15060000076240 | 1 | PO717460 | ||
| 15060000076244 | L15/dossiers | 15 | 15060000076243 | 15060000076243 | 1 | PO717460 | ||
| 15060000076248 | L15/dossiers | 15 | 15060000076247 | 15060000076247 | 1 | PO717460 | ||
| 15060000076251 | L15/dossiers | 15 | 15060000076250 | 15060000076250 | 1 | PO717460 | ||
| 15060000076254 | L15/dossiers | 15 | 15060000076253 | 15060000076253 | 1 | PO717460 | ||
| 15060000076257 | L15/dossiers | 15 | 15060000076256 | 15060000076256 | 1 | PO717460 | ||
| 15060000076260 | L15/dossiers | 15 | 15060000076259 | 15060000076259 | 1 | PO717460 | ||
| 15060000076263 | L15/dossiers | 15 | 15060000076262 | 15060000076262 | 1 | PO717460 | ||
| 15060000076266 | L15/dossiers | 15 | 15060000076265 | 15060000076265 | 1 | PO717460 | ||
| 15060000076269 | L15/dossiers | 15 | 15060000076268 | 15060000076268 | 1 | PO717460 | ||
| 15060000076271 | L15/dossiers | 15 | 15060000076270 | 15060000076270 | 1 | PO717460 | ||
| 15060000076274 | L15/dossiers | 15 | 15060000076273 | 15060000076273 | 1 | PO717460 | ||
| 15060000076277 | L15/dossiers | 15 | 15060000076276 | 15060000076276 | 1 | PO717460 | ||
| 15060000076281 | L15/dossiers | 15 | 15060000076280 | 15060000076280 | 1 | PO717460 | ||
| 15060000076284 | L15/dossiers | 15 | 15060000076283 | 15060000076283 | 1 | PO717460 | ||
| 15060000076287 | L15/dossiers | 15 | 15060000076286 | 15060000076286 | 1 | PO717460 | ||
| 15060000076290 | L15/dossiers | 15 | 15060000076289 | 15060000076289 | 1 | PO717460 | ||
| 15060000076292 | L15/dossiers | 15 | 15060000076291 | 15060000076291 | 1 | PO717460 | ||
| 15060000076294 | L15/dossiers | 15 | 15060000076293 | 15060000076293 | 1 | PO717460 | ||
| 15060000076297 | L15/dossiers | 15 | 15060000076296 | 15060000076296 | 1 | PO717460 | ||
| 15060000076300 | L15/dossiers | 15 | 15060000076299 | 15060000076299 | 1 | PO717460 | ||
| 15060000076304 | L15/dossiers | 15 | 15060000076303 | 15060000076303 | 1 | PO717460 | ||
| 15060000076307 | L15/dossiers | 15 | 15060000076306 | 15060000076306 | 1 | PO717460 | ||
| 15060000076310 | L15/dossiers | 15 | 15060000076309 | 15060000076309 | 1 | PO717460 | ||
| 15060000076313 | L15/dossiers | 15 | 15060000076312 | 15060000076312 | 1 | PO717460 | ||
| 15060000076316 | L15/dossiers | 15 | 15060000076315 | 15060000076315 | 1 | PO717460 | ||
| 15060000076319 | L15/dossiers | 15 | 15060000076318 | 15060000076318 | 1 | PO717460 | ||
| 15060000076322 | L15/dossiers | 15 | 15060000076321 | 15060000076321 | 1 | PO717460 | ||
| 15060000076325 | L15/dossiers | 15 | 15060000076324 | 15060000076324 | 1 | PO717460 | ||
| 15060000076328 | L15/dossiers | 15 | 15060000076327 | 15060000076327 | 1 | PO717460 | ||
| 15060000076331 | L15/dossiers | 15 | 15060000076330 | 15060000076330 | 1 | PO717460 | ||
| 15060000076334 | L15/dossiers | 15 | 15060000076333 | 15060000076333 | 1 | PO717460 | ||
| 15060000076337 | L15/dossiers | 15 | 15060000076336 | 15060000076336 | 1 | PO717460 | ||
| 15060000076340 | L15/dossiers | 15 | 15060000076339 | 15060000076339 | 1 | PO717460 | ||
| 15060000076343 | L15/dossiers | 15 | 15060000076342 | 15060000076342 | 1 | PO717460 | ||
| 15060000076346 | L15/dossiers | 15 | 15060000076345 | 15060000076345 | 1 | PO717460 | ||
| 15060000076349 | L15/dossiers | 15 | 15060000076348 | 15060000076348 | 1 | PO717460 | ||
| 15060000076352 | L15/dossiers | 15 | 15060000076351 | 15060000076351 | 1 | PO717460 | ||
| 15060000076355 | L15/dossiers | 15 | 15060000076354 | 15060000076354 | 1 | PO717460 |