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 |
|---|---|---|---|---|---|---|---|---|
| 17060000105363 | L17/dossiers | 17 | 17060000105362 | 17060000105362 | 1 | PO78718 | ||
| 17060000105365 | L17/dossiers | 17 | 17060000105364 | 17060000105364 | 1 | PA410 | auteur | |
| 17060000105368 | L17/dossiers | 17 | 17060000105367 | 17060000105367 | 1 | PO78718 | ||
| 17060000105370 | L17/dossiers | 17 | 17060000105369 | 17060000105369 | 1 | PO78718 | ||
| 17060000105372 | L17/dossiers | 17 | 17060000105371 | 17060000105371 | 1 | PA410 | auteur | |
| 17060000105375 | L17/dossiers | 17 | 17060000105374 | 17060000105374 | 1 | PA410 | auteur | |
| 17060000105378 | L17/dossiers | 17 | 17060000105377 | 17060000105377 | 1 | PA410 | auteur | |
| 17060000105382 | L17/dossiers | 17 | 17060000105381 | 17060000105381 | 1 | PA410 | auteur | |
| 17060000105385 | L17/dossiers | 17 | 17060000105384 | 17060000105384 | 1 | PA410 | auteur | |
| 17060000105388 | L17/dossiers | 17 | 17060000105387 | 17060000105387 | 1 | PA410 | auteur | |
| 17060000105391 | L17/dossiers | 17 | 17060000105390 | 17060000105390 | 1 | PA410 | auteur | |
| 17060000105394 | L17/dossiers | 17 | 17060000105393 | 17060000105393 | 1 | PA410 | auteur | |
| 17060000105397 | L17/dossiers | 17 | 17060000105396 | 17060000105396 | 1 | PO78718 | ||
| 17060000105399 | L17/dossiers | 17 | 17060000105398 | 17060000105398 | 1 | PA410 | auteur | |
| 17060000105402 | L17/dossiers | 17 | 17060000105401 | 17060000105401 | 1 | PA410 | auteur | |
| 17060000105405 | L17/dossiers | 17 | 17060000105404 | 17060000105404 | 1 | PO78718 | ||
| 17060000105407 | L17/dossiers | 17 | 17060000105406 | 17060000105406 | 1 | PO78718 | ||
| 17060000105409 | L17/dossiers | 17 | 17060000105408 | 17060000105408 | 1 | PO78718 | ||
| 17060000105411 | L17/dossiers | 17 | 17060000105410 | 17060000105410 | 1 | PA410 | auteur | |
| 17060000105414 | L17/dossiers | 17 | 17060000105413 | 17060000105413 | 1 | PO78718 | ||
| 17060000105416 | L17/dossiers | 17 | 17060000105415 | 17060000105415 | 1 | PO78718 | ||
| 17060000105418 | L17/dossiers | 17 | 17060000105417 | 17060000105417 | 1 | PO78718 | ||
| 17060000105420 | L17/dossiers | 17 | 17060000105419 | 17060000105419 | 1 | PA410 | auteur | |
| 17060000105424 | L17/dossiers | 17 | 17060000105423 | 17060000105423 | 1 | PO78718 | ||
| 17060000105426 | L17/dossiers | 17 | 17060000105425 | 17060000105425 | 1 | PO78718 | ||
| 17060000105428 | L17/dossiers | 17 | 17060000105427 | 17060000105427 | 1 | PA410 | auteur | |
| 17060000105431 | L17/dossiers | 17 | 17060000105430 | 17060000105430 | 1 | PA410 | auteur | |
| 17060000105434 | L17/dossiers | 17 | 17060000105433 | 17060000105433 | 1 | PA410 | auteur | |
| 17060000105437 | L17/dossiers | 17 | 17060000105436 | 17060000105436 | 1 | PA410 | auteur | |
| 17060000105440 | L17/dossiers | 17 | 17060000105439 | 17060000105439 | 1 | PA410 | auteur | |
| 17060000105443 | L17/dossiers | 17 | 17060000105442 | 17060000105442 | 1 | PA410 | auteur | |
| 17060000105446 | L17/dossiers | 17 | 17060000105445 | 17060000105445 | 1 | PO78718 | ||
| 17060000105448 | L17/dossiers | 17 | 17060000105447 | 17060000105447 | 1 | PO78718 | ||
| 17060000105450 | L17/dossiers | 17 | 17060000105449 | 17060000105449 | 1 | PO78718 | ||
| 17060000105452 | L17/dossiers | 17 | 17060000105451 | 17060000105451 | 1 | PO78718 | ||
| 17060000105454 | L17/dossiers | 17 | 17060000105453 | 17060000105453 | 1 | PO78718 | ||
| 17060000105456 | L17/dossiers | 17 | 17060000105455 | 17060000105455 | 1 | PO78718 | ||
| 17060000105458 | L17/dossiers | 17 | 17060000105457 | 17060000105457 | 1 | PO78718 | ||
| 17060000105460 | L17/dossiers | 17 | 17060000105459 | 17060000105459 | 1 | PO78718 | ||
| 17060000105462 | L17/dossiers | 17 | 17060000105461 | 17060000105461 | 1 | PO78718 | ||
| 17060000105464 | L17/dossiers | 17 | 17060000105463 | 17060000105463 | 1 | PO78718 | ||
| 17060000105466 | L17/dossiers | 17 | 17060000105465 | 17060000105465 | 1 | PO78718 | ||
| 17060000105468 | L17/dossiers | 17 | 17060000105467 | 17060000105467 | 1 | PO78718 | ||
| 17060000105470 | L17/dossiers | 17 | 17060000105469 | 17060000105469 | 1 | PO78718 | ||
| 17060000105472 | L17/dossiers | 17 | 17060000105471 | 17060000105471 | 1 | PO78718 | ||
| 17060000105474 | L17/dossiers | 17 | 17060000105473 | 17060000105473 | 1 | PO78718 | ||
| 17060000105476 | L17/dossiers | 17 | 17060000105475 | 17060000105475 | 1 | PO78718 | ||
| 17060000105478 | L17/dossiers | 17 | 17060000105477 | 17060000105477 | 1 | PO78718 | ||
| 17060000105480 | L17/dossiers | 17 | 17060000105479 | 17060000105479 | 1 | PO78718 | ||
| 17060000105482 | L17/dossiers | 17 | 17060000105481 | 17060000105481 | 1 | PO78718 |