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 |
|---|---|---|---|---|---|---|---|---|
| 17060000110596 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 1 | PA429875 | rapporteur | |
| 17060000110597 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 2 | PA382672 | rapporteur | |
| 17060000110598 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 3 | PA736191 | rapporteur | |
| 17060000110599 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 4 | PA775186 | rapporteur | |
| 17060000110600 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 5 | PA775242 | rapporteur | |
| 17060000110601 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 6 | PA268048 | rapporteur | |
| 17060000110602 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 7 | PA703514 | rapporteur | |
| 17060000110603 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 8 | PA827934 | rapporteur | |
| 17060000110604 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 9 | PA394676 | rapporteur | |
| 17060000110605 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 10 | PA775184 | rapporteur | |
| 17060000110606 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 11 | PA709298 | rapporteur | |
| 17060000110607 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 12 | PA775182 | rapporteur | |
| 17060000110608 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 13 | PA429867 | rapporteur | |
| 17060000110609 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 14 | PA736208 | rapporteur | |
| 17060000110610 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 15 | PA415467 | rapporteur | |
| 17060000110611 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 16 | PA828006 | rapporteur | |
| 17060000110612 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 17 | PA736211 | rapporteur | |
| 17060000110613 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 18 | PA415446 | rapporteur | |
| 17060000110614 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 19 | PA827922 | rapporteur | |
| 17060000110615 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 20 | PA429884 | rapporteur | |
| 17060000110616 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 21 | PA775210 | rapporteur | |
| 17060000110617 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 22 | PA429833 | rapporteur | |
| 17060000110618 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 23 | PA415448 | rapporteur | |
| 17060000110619 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 24 | PA343988 | rapporteur | |
| 17060000110620 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 25 | PA703493 | rapporteur | |
| 17060000110621 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 26 | PA827928 | rapporteur | |
| 17060000110622 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 27 | PA775288 | rapporteur | |
| 17060000110623 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 28 | PA775214 | rapporteur | |
| 17060000110624 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 29 | PA415447 | rapporteur | |
| 17060000110625 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 30 | PA736238 | rapporteur | |
| 17060000110626 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 31 | PA415499 | rapporteur | |
| 17060000110627 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 32 | PA267387 | rapporteur | |
| 17060000110628 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 33 | PA703505 | rapporteur | |
| 17060000110629 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 34 | PA827904 | rapporteur | |
| 17060000110630 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 35 | PA775260 | rapporteur | |
| 17060000110631 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 36 | PA711156 | rapporteur | |
| 17060000110632 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 37 | PA736158 | rapporteur | |
| 17060000110633 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 38 | PA775284 | rapporteur | |
| 17060000110634 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 39 | PA775200 | rapporteur | |
| 17060000110635 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 40 | PA736175 | rapporteur | |
| 17060000110636 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 41 | PA429869 | rapporteur | |
| 17060000110637 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 42 | PA775176 | rapporteur | |
| 17060000110638 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 43 | PA703527 | rapporteur | |
| 17060000110639 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 44 | PA736188 | rapporteur | |
| 17060000110640 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 45 | PA827898 | rapporteur | |
| 17060000110641 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 46 | PA703509 | rapporteur | |
| 17060000110642 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 47 | PA736174 | rapporteur | |
| 17060000110643 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 48 | PA828000 | rapporteur | |
| 17060000110644 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 49 | PA736204 | rapporteur | |
| 17060000110645 | L17/dossiers | 17 | 17060000110595 | 17060000110595 | 50 | PO211494 |