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 |
|---|---|---|---|---|---|---|---|---|
| 16060000002452 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 1 | PA722022 | auteur | |
| 16060000002782 | L16/dossiers | 16 | 16060000002781 | 16060000002781 | 1 | PA722162 | auteur | |
| 16060000002842 | L16/dossiers | 16 | 16060000002841 | 16060000002841 | 1 | PO717460 | ||
| 16060000002846 | L16/dossiers | 16 | 16060000002845 | 16060000002845 | 1 | PO717460 | ||
| 16060000002849 | L16/dossiers | 16 | 16060000002848 | 16060000002848 | 1 | PO717460 | ||
| 16060000002852 | L16/dossiers | 16 | 16060000002851 | 16060000002851 | 1 | PO717460 | ||
| 16060000002855 | L16/dossiers | 16 | 16060000002854 | 16060000002854 | 1 | PO717460 | ||
| 16060000002858 | L16/dossiers | 16 | 16060000002857 | 16060000002857 | 1 | PO717460 | ||
| 16060000002861 | L16/dossiers | 16 | 16060000002860 | 16060000002860 | 1 | PO717460 | ||
| 16060000002864 | L16/dossiers | 16 | 16060000002863 | 16060000002863 | 1 | PO717460 | ||
| 16060000002867 | L16/dossiers | 16 | 16060000002866 | 16060000002866 | 1 | PO717460 | ||
| 16060000002870 | L16/dossiers | 16 | 16060000002869 | 16060000002869 | 1 | PO717460 | ||
| 16060000002873 | L16/dossiers | 16 | 16060000002872 | 16060000002872 | 1 | PA718876 | auteur | |
| 16060000003014 | L16/dossiers | 16 | 16060000003013 | 16060000003013 | 1 | PO717460 | ||
| 16060000003017 | L16/dossiers | 16 | 16060000003016 | 16060000003016 | 1 | PO717460 | ||
| 16060000003020 | L16/dossiers | 16 | 16060000003019 | 16060000003019 | 1 | PO717460 | ||
| 16060000003023 | L16/dossiers | 16 | 16060000003022 | 16060000003022 | 1 | PO717460 | ||
| 16060000003026 | L16/dossiers | 16 | 16060000003025 | 16060000003025 | 1 | PA719448 | auteur | |
| 16060000003164 | L16/dossiers | 16 | 16060000003163 | 16060000003163 | 1 | PO717460 | ||
| 16060000003167 | L16/dossiers | 16 | 16060000003166 | 16060000003166 | 1 | PO717460 | ||
| 16060000003170 | L16/dossiers | 16 | 16060000003169 | 16060000003169 | 1 | PA720846 | auteur | |
| 16060000003216 | L16/dossiers | 16 | 16060000003215 | 16060000003215 | 1 | PO717460 | ||
| 16060000003219 | L16/dossiers | 16 | 16060000003218 | 16060000003218 | 1 | PO717460 | ||
| 16060000003222 | L16/dossiers | 16 | 16060000003221 | 16060000003221 | 1 | PA340357 | auteur | |
| 16060000003254 | L16/dossiers | 16 | 16060000003253 | 16060000003253 | 1 | PO717460 | ||
| 16060000003257 | L16/dossiers | 16 | 16060000003256 | 16060000003256 | 1 | PO717460 | ||
| 16060000003260 | L16/dossiers | 16 | 16060000003259 | 16060000003259 | 1 | PO717460 | ||
| 16060000003263 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 1 | PA718756 | auteur | |
| 16060000003534 | L16/dossiers | 16 | 16060000003533 | 16060000003533 | 1 | PO717460 | ||
| 16060000003537 | L16/dossiers | 16 | 16060000003536 | 16060000003536 | 1 | PO717460 | ||
| 16060000003540 | L16/dossiers | 16 | 16060000003539 | 16060000003539 | 1 | PO717460 | ||
| 16060000003543 | L16/dossiers | 16 | 16060000003542 | 16060000003542 | 1 | PO717460 | ||
| 16060000003546 | L16/dossiers | 16 | 16060000003545 | 16060000003545 | 1 | PO717460 | ||
| 16060000003549 | L16/dossiers | 16 | 16060000003548 | 16060000003548 | 1 | PO717460 | ||
| 16060000003553 | L16/dossiers | 16 | 16060000003552 | 16060000003552 | 1 | PO717460 | ||
| 16060000003556 | L16/dossiers | 16 | 16060000003555 | 16060000003555 | 1 | PO717460 | ||
| 16060000003558 | L16/dossiers | 16 | 16060000003557 | 16060000003557 | 1 | PO717460 | ||
| 16060000003561 | L16/dossiers | 16 | 16060000003560 | 16060000003560 | 1 | PO717460 | ||
| 16060000003563 | L16/dossiers | 16 | 16060000003562 | 16060000003562 | 1 | PO717460 | ||
| 16060000003566 | L16/dossiers | 16 | 16060000003565 | 16060000003565 | 1 | PO717460 | ||
| 16060000003569 | L16/dossiers | 16 | 16060000003568 | 16060000003568 | 1 | PO717460 | ||
| 16060000003572 | L16/dossiers | 16 | 16060000003571 | 16060000003571 | 1 | PO717460 | ||
| 16060000003575 | L16/dossiers | 16 | 16060000003574 | 16060000003574 | 1 | PA607553 | rapporteur | |
| 16060000003576 | L16/dossiers | 16 | 16060000003574 | 16060000003574 | 2 | PO420120 | ||
| 16060000003579 | L16/dossiers | 16 | 16060000003578 | 16060000003578 | 1 | PA722162 | rapporteur | |
| 16060000003580 | L16/dossiers | 16 | 16060000003578 | 16060000003578 | 2 | PO419610 | ||
| 16060000003583 | L16/dossiers | 16 | 16060000003582 | 16060000003582 | 1 | PA718894 | rapporteur | |
| 16060000003584 | L16/dossiers | 16 | 16060000003582 | 16060000003582 | 2 | PA720454 | rapporteur | |
| 16060000003585 | L16/dossiers | 16 | 16060000003582 | 16060000003582 | 3 | PA722022 | rapporteur | |
| 16060000003586 | L16/dossiers | 16 | 16060000003582 | 16060000003582 | 4 | PO419610 |