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 |
|---|---|---|---|---|---|---|---|---|
| 16060000055307 | L16/dossiers | 16 | 16060000055306 | 16060000055306 | 1 | PO791932 | ||
| 16060000055310 | L16/dossiers | 16 | 16060000055309 | 16060000055309 | 1 | PO791932 | ||
| 16060000055313 | L16/dossiers | 16 | 16060000055312 | 16060000055312 | 1 | PO791932 | ||
| 16060000055316 | L16/dossiers | 16 | 16060000055315 | 16060000055315 | 1 | PO791932 | ||
| 16060000055319 | L16/dossiers | 16 | 16060000055318 | 16060000055318 | 1 | PO791932 | ||
| 16060000055321 | L16/dossiers | 16 | 16060000055320 | 16060000055320 | 1 | PO791932 | ||
| 16060000055324 | L16/dossiers | 16 | 16060000055323 | 16060000055323 | 1 | PO791932 | ||
| 16060000055327 | L16/dossiers | 16 | 16060000055326 | 16060000055326 | 1 | PO791932 | ||
| 16060000055330 | L16/dossiers | 16 | 16060000055329 | 16060000055329 | 1 | PO791932 | ||
| 16060000055333 | L16/dossiers | 16 | 16060000055332 | 16060000055332 | 1 | PO791932 | ||
| 16060000055336 | L16/dossiers | 16 | 16060000055335 | 16060000055335 | 1 | PO791932 | ||
| 16060000055339 | L16/dossiers | 16 | 16060000055338 | 16060000055338 | 1 | PO791932 | ||
| 16060000055342 | L16/dossiers | 16 | 16060000055341 | 16060000055341 | 1 | PO791932 | ||
| 16060000055345 | L16/dossiers | 16 | 16060000055344 | 16060000055344 | 1 | PO791932 | ||
| 16060000055348 | L16/dossiers | 16 | 16060000055347 | 16060000055347 | 1 | PO791932 | ||
| 16060000055351 | L16/dossiers | 16 | 16060000055350 | 16060000055350 | 1 | PO791932 | ||
| 16060000055354 | L16/dossiers | 16 | 16060000055353 | 16060000055353 | 1 | PO791932 | ||
| 16060000055357 | L16/dossiers | 16 | 16060000055356 | 16060000055356 | 1 | PO791932 | ||
| 16060000055360 | L16/dossiers | 16 | 16060000055359 | 16060000055359 | 1 | PO791932 | ||
| 16060000055363 | L16/dossiers | 16 | 16060000055362 | 16060000055362 | 1 | PO791932 | ||
| 16060000055365 | L16/dossiers | 16 | 16060000055364 | 16060000055364 | 1 | PO791932 | ||
| 16060000055367 | L16/dossiers | 16 | 16060000055366 | 16060000055366 | 1 | PO791932 | ||
| 16060000055369 | L16/dossiers | 16 | 16060000055368 | 16060000055368 | 1 | PO791932 | ||
| 16060000055371 | L16/dossiers | 16 | 16060000055370 | 16060000055370 | 1 | PO791932 | ||
| 16060000055374 | L16/dossiers | 16 | 16060000055373 | 16060000055373 | 1 | PO791932 | ||
| 16060000055377 | L16/dossiers | 16 | 16060000055376 | 16060000055376 | 1 | PO791932 | ||
| 16060000055380 | L16/dossiers | 16 | 16060000055379 | 16060000055379 | 1 | PO791932 | ||
| 16060000055383 | L16/dossiers | 16 | 16060000055382 | 16060000055382 | 1 | PO791932 | ||
| 16060000055386 | L16/dossiers | 16 | 16060000055385 | 16060000055385 | 1 | PO791932 | ||
| 16060000055389 | L16/dossiers | 16 | 16060000055388 | 16060000055388 | 1 | PO791932 | ||
| 16060000055392 | L16/dossiers | 16 | 16060000055391 | 16060000055391 | 1 | PO791932 | ||
| 16060000055395 | L16/dossiers | 16 | 16060000055394 | 16060000055394 | 1 | PO791932 | ||
| 16060000055398 | L16/dossiers | 16 | 16060000055397 | 16060000055397 | 1 | PO791932 | ||
| 16060000055401 | L16/dossiers | 16 | 16060000055400 | 16060000055400 | 1 | PO791932 | ||
| 16060000055404 | L16/dossiers | 16 | 16060000055403 | 16060000055403 | 1 | PO791932 | ||
| 16060000055407 | L16/dossiers | 16 | 16060000055406 | 16060000055406 | 1 | PO791932 | ||
| 16060000055410 | L16/dossiers | 16 | 16060000055409 | 16060000055409 | 1 | PO791932 | ||
| 16060000055413 | L16/dossiers | 16 | 16060000055412 | 16060000055412 | 1 | PO791932 | ||
| 16060000055416 | L16/dossiers | 16 | 16060000055415 | 16060000055415 | 1 | PO791932 | ||
| 16060000055419 | L16/dossiers | 16 | 16060000055418 | 16060000055418 | 1 | PO791932 | ||
| 16060000055422 | L16/dossiers | 16 | 16060000055421 | 16060000055421 | 1 | PO791932 | ||
| 16060000055425 | L16/dossiers | 16 | 16060000055424 | 16060000055424 | 1 | PO791932 | ||
| 16060000055428 | L16/dossiers | 16 | 16060000055427 | 16060000055427 | 1 | PO791932 | ||
| 16060000055431 | L16/dossiers | 16 | 16060000055430 | 16060000055430 | 1 | PO791932 | ||
| 16060000055434 | L16/dossiers | 16 | 16060000055433 | 16060000055433 | 1 | PO791932 | ||
| 16060000055437 | L16/dossiers | 16 | 16060000055436 | 16060000055436 | 1 | PO791932 | ||
| 16060000055440 | L16/dossiers | 16 | 16060000055439 | 16060000055439 | 1 | PO791932 | ||
| 16060000055442 | L16/dossiers | 16 | 16060000055441 | 16060000055441 | 1 | PO791932 | ||
| 16060000055444 | L16/dossiers | 16 | 16060000055443 | 16060000055443 | 1 | PO791932 | ||
| 16060000055447 | L16/dossiers | 16 | 16060000055446 | 16060000055446 | 1 | PO791932 |