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 |
|---|---|---|---|---|---|---|---|---|
| 16060000088426 | L16/dossiers | 16 | 16060000088424 | 16060000088424 | 2 | PO825399 | ||
| 16060000088428 | L16/dossiers | 16 | 16060000088427 | 16060000088427 | 1 | PA415446 | rapporteur | |
| 16060000088429 | L16/dossiers | 16 | 16060000088427 | 16060000088427 | 2 | PO825406 | ||
| 16060000088431 | L16/dossiers | 16 | 16060000088430 | 16060000088430 | 1 | PA1344 | rapporteur | |
| 16060000088432 | L16/dossiers | 16 | 16060000088430 | 16060000088430 | 2 | PO211491 | ||
| 16060000088434 | L16/dossiers | 16 | 16060000088433 | 16060000088433 | 1 | PA703537 | rapporteur | |
| 16060000088435 | L16/dossiers | 16 | 16060000088433 | 16060000088433 | 2 | PO211491 | ||
| 16060000088437 | L16/dossiers | 16 | 16060000088436 | 16060000088436 | 1 | PA763158 | rapporteur | |
| 16060000088438 | L16/dossiers | 16 | 16060000088436 | 16060000088436 | 2 | PO826002 | ||
| 16060000088440 | L16/dossiers | 16 | 16060000088439 | 16060000088439 | 1 | PA778908 | rapporteur | |
| 16060000088441 | L16/dossiers | 16 | 16060000088439 | 16060000088439 | 2 | PO825929 | ||
| 16060000088443 | L16/dossiers | 16 | 16060000088442 | 16060000088442 | 1 | PA775184 | rapporteur | |
| 16060000088444 | L16/dossiers | 16 | 16060000088442 | 16060000088442 | 2 | PO825849 | ||
| 16060000088446 | L16/dossiers | 16 | 16060000088445 | 16060000088445 | 1 | PA304085 | rapporteur | |
| 16060000088447 | L16/dossiers | 16 | 16060000088445 | 16060000088445 | 2 | PO826014 | ||
| 16060000088449 | L16/dossiers | 16 | 16060000088448 | 16060000088448 | 1 | PA429842 | rapporteur | |
| 16060000088450 | L16/dossiers | 16 | 16060000088448 | 16060000088448 | 2 | PO516753 | ||
| 16060000088452 | L16/dossiers | 16 | 16060000088451 | 16060000088451 | 1 | PA703494 | rapporteur | |
| 16060000088453 | L16/dossiers | 16 | 16060000088451 | 16060000088451 | 2 | PO211495 | ||
| 16060000088455 | L16/dossiers | 16 | 16060000088454 | 16060000088454 | 1 | PA703520 | rapporteur | |
| 16060000088456 | L16/dossiers | 16 | 16060000088454 | 16060000088454 | 2 | PO516753 | ||
| 16060000088458 | L16/dossiers | 16 | 16060000088457 | 16060000088457 | 1 | PA703510 | rapporteur | |
| 16060000088459 | L16/dossiers | 16 | 16060000088457 | 16060000088457 | 2 | PA747420 | rapporteur | |
| 16060000088460 | L16/dossiers | 16 | 16060000088457 | 16060000088457 | 3 | PO826540 | ||
| 16060000088462 | L16/dossiers | 16 | 16060000088461 | 16060000088461 | 1 | PA775288 | rapporteur | |
| 16060000088463 | L16/dossiers | 16 | 16060000088461 | 16060000088461 | 2 | PA775228 | rapporteur | |
| 16060000088464 | L16/dossiers | 16 | 16060000088461 | 16060000088461 | 3 | PA736211 | rapporteur | |
| 16060000088465 | L16/dossiers | 16 | 16060000088461 | 16060000088461 | 4 | PO826726 | ||
| 16060000088467 | L16/dossiers | 16 | 16060000088466 | 16060000088466 | 1 | PA429875 | rapporteur | |
| 16060000088468 | L16/dossiers | 16 | 16060000088466 | 16060000088466 | 2 | PO211494 | ||
| 16060000088470 | L16/dossiers | 16 | 16060000088469 | 16060000088469 | 1 | PA736239 | rapporteur | |
| 16060000088471 | L16/dossiers | 16 | 16060000088469 | 16060000088469 | 2 | PO211493 | ||
| 16060000088473 | L16/dossiers | 16 | 16060000088472 | 16060000088472 | 1 | PA429869 | rapporteur | |
| 16060000088474 | L16/dossiers | 16 | 16060000088472 | 16060000088472 | 2 | PO211494 | ||
| 16060000088476 | L16/dossiers | 16 | 16060000088475 | 16060000088475 | 1 | PA703523 | rapporteur | |
| 16060000088477 | L16/dossiers | 16 | 16060000088475 | 16060000088475 | 2 | PO516753 | ||
| 16060000088479 | L16/dossiers | 16 | 16060000088478 | 16060000088478 | 1 | PA1573 | rapporteur | |
| 16060000088480 | L16/dossiers | 16 | 16060000088478 | 16060000088478 | 2 | PO211491 | ||
| 16060000088482 | L16/dossiers | 16 | 16060000088481 | 16060000088481 | 1 | PA415479 | rapporteur | |
| 16060000088483 | L16/dossiers | 16 | 16060000088481 | 16060000088481 | 2 | PO211491 | ||
| 16060000088485 | L16/dossiers | 16 | 16060000088484 | 16060000088484 | 1 | PA775292 | rapporteur | |
| 16060000088486 | L16/dossiers | 16 | 16060000088484 | 16060000088484 | 2 | PO516754 | ||
| 16060000088488 | L16/dossiers | 16 | 16060000088487 | 16060000088487 | 1 | PA1127 | rapporteur | |
| 16060000088489 | L16/dossiers | 16 | 16060000088487 | 16060000088487 | 2 | PO516754 | ||
| 16060000088491 | L16/dossiers | 16 | 16060000088490 | 16060000088490 | 1 | PA703515 | rapporteur | |
| 16060000088492 | L16/dossiers | 16 | 16060000088490 | 16060000088490 | 2 | PO211493 | ||
| 16060000088494 | L16/dossiers | 16 | 16060000088493 | 16060000088493 | 1 | PA267081 | rapporteur | |
| 16060000088495 | L16/dossiers | 16 | 16060000088493 | 16060000088493 | 2 | PO830023 | ||
| 16060000088497 | L16/dossiers | 16 | 16060000088496 | 16060000088496 | 1 | PA775170 | rapporteur | |
| 16060000088498 | L16/dossiers | 16 | 16060000088496 | 16060000088496 | 2 | PO211495 |