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 |
|---|---|---|---|---|---|---|---|---|
| 15060000078230 | L15/dossiers | 15 | 15060000078229 | 15060000078229 | 1 | PO717460 | ||
| 15060000078233 | L15/dossiers | 15 | 15060000078232 | 15060000078232 | 1 | PO717460 | ||
| 15060000078236 | L15/dossiers | 15 | 15060000078235 | 15060000078235 | 1 | PO717460 | ||
| 15060000078239 | L15/dossiers | 15 | 15060000078238 | 15060000078238 | 1 | PO717460 | ||
| 15060000078242 | L15/dossiers | 15 | 15060000078241 | 15060000078241 | 1 | PO717460 | ||
| 15060000078245 | L15/dossiers | 15 | 15060000078244 | 15060000078244 | 1 | PO717460 | ||
| 15060000078248 | L15/dossiers | 15 | 15060000078247 | 15060000078247 | 1 | PO717460 | ||
| 15060000078251 | L15/dossiers | 15 | 15060000078250 | 15060000078250 | 1 | PO717460 | ||
| 15060000078254 | L15/dossiers | 15 | 15060000078253 | 15060000078253 | 1 | PO717460 | ||
| 15060000078257 | L15/dossiers | 15 | 15060000078256 | 15060000078256 | 1 | PO717460 | ||
| 15060000078260 | L15/dossiers | 15 | 15060000078259 | 15060000078259 | 1 | PO717460 | ||
| 15060000078262 | L15/dossiers | 15 | 15060000078261 | 15060000078261 | 1 | PO717460 | ||
| 15060000078264 | L15/dossiers | 15 | 15060000078263 | 15060000078263 | 1 | PO717460 | ||
| 15060000078266 | L15/dossiers | 15 | 15060000078265 | 15060000078265 | 1 | PO717460 | ||
| 15060000078268 | L15/dossiers | 15 | 15060000078267 | 15060000078267 | 1 | PO717460 | ||
| 15060000078271 | L15/dossiers | 15 | 15060000078270 | 15060000078270 | 1 | PO717460 | ||
| 15060000078274 | L15/dossiers | 15 | 15060000078273 | 15060000078273 | 1 | PO717460 | ||
| 15060000078277 | L15/dossiers | 15 | 15060000078276 | 15060000078276 | 1 | PO717460 | ||
| 15060000078281 | L15/dossiers | 15 | 15060000078280 | 15060000078280 | 1 | PO717460 | ||
| 15060000078284 | L15/dossiers | 15 | 15060000078283 | 15060000078283 | 1 | PO717460 | ||
| 15060000078287 | L15/dossiers | 15 | 15060000078286 | 15060000078286 | 1 | PO717460 | ||
| 15060000078290 | L15/dossiers | 15 | 15060000078289 | 15060000078289 | 1 | PO717460 | ||
| 15060000078292 | L15/dossiers | 15 | 15060000078291 | 15060000078291 | 1 | PO717460 | ||
| 15060000078295 | L15/dossiers | 15 | 15060000078294 | 15060000078294 | 1 | PO717460 | ||
| 15060000078298 | L15/dossiers | 15 | 15060000078297 | 15060000078297 | 1 | PO717460 | ||
| 15060000078301 | L15/dossiers | 15 | 15060000078300 | 15060000078300 | 1 | PO717460 | ||
| 15060000078304 | L15/dossiers | 15 | 15060000078303 | 15060000078303 | 1 | PO717460 | ||
| 15060000078307 | L15/dossiers | 15 | 15060000078306 | 15060000078306 | 1 | PO717460 | ||
| 15060000078310 | L15/dossiers | 15 | 15060000078309 | 15060000078309 | 1 | PO717460 | ||
| 15060000078313 | L15/dossiers | 15 | 15060000078312 | 15060000078312 | 1 | PO717460 | ||
| 15060000078316 | L15/dossiers | 15 | 15060000078315 | 15060000078315 | 1 | PO717460 | ||
| 15060000078319 | L15/dossiers | 15 | 15060000078318 | 15060000078318 | 1 | PO717460 | ||
| 15060000078322 | L15/dossiers | 15 | 15060000078321 | 15060000078321 | 1 | PO717460 | ||
| 15060000078325 | L15/dossiers | 15 | 15060000078324 | 15060000078324 | 1 | PO717460 | ||
| 15060000078328 | L15/dossiers | 15 | 15060000078327 | 15060000078327 | 1 | PO717460 | ||
| 15060000078331 | L15/dossiers | 15 | 15060000078330 | 15060000078330 | 1 | PO717460 | ||
| 15060000078334 | L15/dossiers | 15 | 15060000078333 | 15060000078333 | 1 | PO717460 | ||
| 15060000078336 | L15/dossiers | 15 | 15060000078335 | 15060000078335 | 1 | PO717460 | ||
| 15060000078338 | L15/dossiers | 15 | 15060000078337 | 15060000078337 | 1 | PO717460 | ||
| 15060000078341 | L15/dossiers | 15 | 15060000078340 | 15060000078340 | 1 | PO717460 | ||
| 15060000078344 | L15/dossiers | 15 | 15060000078343 | 15060000078343 | 1 | PO717460 | ||
| 15060000078347 | L15/dossiers | 15 | 15060000078346 | 15060000078346 | 1 | PO717460 | ||
| 15060000078350 | L15/dossiers | 15 | 15060000078349 | 15060000078349 | 1 | PO717460 | ||
| 15060000078353 | L15/dossiers | 15 | 15060000078352 | 15060000078352 | 1 | PO717460 | ||
| 15060000078355 | L15/dossiers | 15 | 15060000078354 | 15060000078354 | 1 | PO717460 | ||
| 15060000078358 | L15/dossiers | 15 | 15060000078357 | 15060000078357 | 1 | PO717460 | ||
| 15060000078361 | L15/dossiers | 15 | 15060000078360 | 15060000078360 | 1 | PO717460 | ||
| 15060000078363 | L15/dossiers | 15 | 15060000078362 | 15060000078362 | 1 | PO717460 | ||
| 15060000078365 | L15/dossiers | 15 | 15060000078364 | 15060000078364 | 1 | PO717460 | ||
| 15060000078368 | L15/dossiers | 15 | 15060000078367 | 15060000078367 | 1 | PO717460 |