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 |
|---|---|---|---|---|---|---|---|---|
| 16060000088500 | L16/dossiers | 16 | 16060000088499 | 16060000088499 | 1 | PA775242 | rapporteur | |
| 16060000088501 | L16/dossiers | 16 | 16060000088499 | 16060000088499 | 2 | PO211494 | ||
| 16060000088503 | L16/dossiers | 16 | 16060000088502 | 16060000088502 | 1 | PA775248 | rapporteur | |
| 16060000088504 | L16/dossiers | 16 | 16060000088502 | 16060000088502 | 2 | PO211495 | ||
| 16060000088506 | L16/dossiers | 16 | 16060000088505 | 16060000088505 | 1 | PA775302 | rapporteur | |
| 16060000088507 | L16/dossiers | 16 | 16060000088505 | 16060000088505 | 2 | PO211490 | ||
| 16060000088509 | L16/dossiers | 16 | 16060000088508 | 16060000088508 | 1 | PA703523 | rapporteur | |
| 16060000088510 | L16/dossiers | 16 | 16060000088508 | 16060000088508 | 2 | PO830797 | ||
| 16060000088512 | L16/dossiers | 16 | 16060000088511 | 16060000088511 | 1 | PA775218 | rapporteur | |
| 16060000088513 | L16/dossiers | 16 | 16060000088511 | 16060000088511 | 2 | PO516754 | ||
| 16060000088515 | L16/dossiers | 16 | 16060000088514 | 16060000088514 | 1 | PA703498 | rapporteur | |
| 16060000088516 | L16/dossiers | 16 | 16060000088514 | 16060000088514 | 2 | PA703515 | rapporteur | |
| 16060000088517 | L16/dossiers | 16 | 16060000088514 | 16060000088514 | 3 | PA267081 | rapporteur | |
| 16060000088518 | L16/dossiers | 16 | 16060000088514 | 16060000088514 | 4 | PA736223 | rapporteur | |
| 16060000088519 | L16/dossiers | 16 | 16060000088514 | 16060000088514 | 5 | PA763158 | rapporteur | |
| 16060000088520 | L16/dossiers | 16 | 16060000088514 | 16060000088514 | 6 | PA267112 | rapporteur | |
| 16060000088521 | L16/dossiers | 16 | 16060000088514 | 16060000088514 | 7 | PO211493 | ||
| 16060000088523 | L16/dossiers | 16 | 16060000088522 | 16060000088522 | 1 | PA775292 | rapporteur | |
| 16060000088524 | L16/dossiers | 16 | 16060000088522 | 16060000088522 | 2 | PO830672 | ||
| 16060000088526 | L16/dossiers | 16 | 16060000088525 | 16060000088525 | 1 | PA429858 | rapporteur | |
| 16060000088527 | L16/dossiers | 16 | 16060000088525 | 16060000088525 | 2 | PO211495 | ||
| 16060000088529 | L16/dossiers | 16 | 16060000088528 | 16060000088528 | 1 | PA775226 | rapporteur | |
| 16060000088530 | L16/dossiers | 16 | 16060000088528 | 16060000088528 | 2 | PO211490 | ||
| 16060000088532 | L16/dossiers | 16 | 16060000088531 | 16060000088531 | 1 | PA828008 | rapporteur | |
| 16060000088533 | L16/dossiers | 16 | 16060000088531 | 16060000088531 | 2 | PO211495 | ||
| 16060000088535 | L16/dossiers | 16 | 16060000088534 | 16060000088534 | 1 | PA736239 | rapporteur | |
| 16060000088536 | L16/dossiers | 16 | 16060000088534 | 16060000088534 | 2 | PO830153 | ||
| 16060000088538 | L16/dossiers | 16 | 16060000088537 | 16060000088537 | 1 | PA429875 | rapporteur | |
| 16060000088539 | L16/dossiers | 16 | 16060000088537 | 16060000088537 | 2 | PO211494 | ||
| 16060000088541 | L16/dossiers | 16 | 16060000088540 | 16060000088540 | 1 | PA429875 | rapporteur | |
| 16060000088542 | L16/dossiers | 16 | 16060000088540 | 16060000088540 | 2 | PA736204 | rapporteur | |
| 16060000088543 | L16/dossiers | 16 | 16060000088540 | 16060000088540 | 3 | PA382672 | rapporteur | |
| 16060000088544 | L16/dossiers | 16 | 16060000088540 | 16060000088540 | 4 | PA736191 | rapporteur | |
| 16060000088545 | L16/dossiers | 16 | 16060000088540 | 16060000088540 | 5 | PA775186 | rapporteur | |
| 16060000088546 | L16/dossiers | 16 | 16060000088540 | 16060000088540 | 6 | PA775242 | rapporteur | |
| 16060000088547 | L16/dossiers | 16 | 16060000088540 | 16060000088540 | 7 | PA268048 | rapporteur | |
| 16060000088548 | L16/dossiers | 16 | 16060000088540 | 16060000088540 | 8 | PA703514 | rapporteur | |
| 16060000088549 | L16/dossiers | 16 | 16060000088540 | 16060000088540 | 9 | PA827934 | rapporteur | |
| 16060000088550 | L16/dossiers | 16 | 16060000088540 | 16060000088540 | 10 | PA394676 | rapporteur | |
| 16060000088551 | L16/dossiers | 16 | 16060000088540 | 16060000088540 | 11 | PA775184 | rapporteur | |
| 16060000088552 | L16/dossiers | 16 | 16060000088540 | 16060000088540 | 12 | PA709298 | rapporteur | |
| 16060000088553 | L16/dossiers | 16 | 16060000088540 | 16060000088540 | 13 | PA775182 | rapporteur | |
| 16060000088554 | L16/dossiers | 16 | 16060000088540 | 16060000088540 | 14 | PA429867 | rapporteur | |
| 16060000088555 | L16/dossiers | 16 | 16060000088540 | 16060000088540 | 15 | PA736208 | rapporteur | |
| 16060000088556 | L16/dossiers | 16 | 16060000088540 | 16060000088540 | 16 | PA415467 | rapporteur | |
| 16060000088557 | L16/dossiers | 16 | 16060000088540 | 16060000088540 | 17 | PA828006 | rapporteur | |
| 16060000088558 | L16/dossiers | 16 | 16060000088540 | 16060000088540 | 18 | PA736211 | rapporteur | |
| 16060000088559 | L16/dossiers | 16 | 16060000088540 | 16060000088540 | 19 | PA415446 | rapporteur | |
| 16060000088560 | L16/dossiers | 16 | 16060000088540 | 16060000088540 | 20 | PA827922 | rapporteur | |
| 16060000088561 | L16/dossiers | 16 | 16060000088540 | 16060000088540 | 21 | PA429884 | rapporteur |