dossiers.document_auteur
Chemin document.auteurs.auteur · présence : L17 100 %, L16 100 %, L15 100 %, L14 100 %
59 594 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 |
|---|---|---|---|---|---|---|---|---|
| 17060000004655 | L17/dossiers | 17 | 17060000004654 | 17060000004654 | 1 | PO791932 | ||
| 17060000004658 | L17/dossiers | 17 | 17060000004657 | 17060000004657 | 1 | PO791932 | ||
| 17060000004661 | L17/dossiers | 17 | 17060000004660 | 17060000004660 | 1 | PO791932 | ||
| 17060000004664 | L17/dossiers | 17 | 17060000004663 | 17060000004663 | 1 | PO791932 | ||
| 17060000004667 | L17/dossiers | 17 | 17060000004666 | 17060000004666 | 1 | PO791932 | ||
| 17060000004670 | L17/dossiers | 17 | 17060000004669 | 17060000004669 | 1 | PO791932 | ||
| 17060000004673 | L17/dossiers | 17 | 17060000004672 | 17060000004672 | 1 | PO791932 | ||
| 17060000004676 | L17/dossiers | 17 | 17060000004675 | 17060000004675 | 1 | PO791932 | ||
| 17060000004679 | L17/dossiers | 17 | 17060000004678 | 17060000004678 | 1 | PO791932 | ||
| 17060000004682 | L17/dossiers | 17 | 17060000004681 | 17060000004681 | 1 | PO791932 | ||
| 17060000004685 | L17/dossiers | 17 | 17060000004684 | 17060000004684 | 1 | PO791932 | ||
| 17060000004688 | L17/dossiers | 17 | 17060000004687 | 17060000004687 | 1 | PA795794 | auteur | |
| 17060000004846 | L17/dossiers | 17 | 17060000004845 | 17060000004845 | 1 | PA720704 | auteur | |
| 17060000004847 | L17/dossiers | 17 | 17060000004845 | 17060000004845 | 2 | PA266797 | auteur | |
| 17060000004850 | L17/dossiers | 17 | 17060000004849 | 17060000004849 | 1 | PO791932 | ||
| 17060000004853 | L17/dossiers | 17 | 17060000004852 | 17060000004852 | 1 | PO791932 | ||
| 17060000004856 | L17/dossiers | 17 | 17060000004855 | 17060000004855 | 1 | PO791932 | ||
| 17060000004859 | L17/dossiers | 17 | 17060000004858 | 17060000004858 | 1 | PA795076 | auteur | |
| 17060000004883 | L17/dossiers | 17 | 17060000004882 | 17060000004882 | 1 | PO791932 | ||
| 17060000004886 | L17/dossiers | 17 | 17060000004885 | 17060000004885 | 1 | PO791932 | ||
| 17060000004889 | L17/dossiers | 17 | 17060000004888 | 17060000004888 | 1 | PO791932 | ||
| 17060000004892 | L17/dossiers | 17 | 17060000004891 | 17060000004891 | 1 | PO791932 | ||
| 17060000004895 | L17/dossiers | 17 | 17060000004894 | 17060000004894 | 1 | PO791932 | ||
| 17060000004898 | L17/dossiers | 17 | 17060000004897 | 17060000004897 | 1 | PO791932 | ||
| 17060000004901 | L17/dossiers | 17 | 17060000004900 | 17060000004900 | 1 | PO791932 | ||
| 17060000004904 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 1 | PA719388 | auteur | |
| 17060000005130 | L17/dossiers | 17 | 17060000005129 | 17060000005129 | 1 | PO791932 | ||
| 17060000005133 | L17/dossiers | 17 | 17060000005132 | 17060000005132 | 1 | PO791932 | ||
| 17060000005136 | L17/dossiers | 17 | 17060000005135 | 17060000005135 | 1 | PO791932 | ||
| 17060000005139 | L17/dossiers | 17 | 17060000005138 | 17060000005138 | 1 | PO791932 | ||
| 17060000005142 | L17/dossiers | 17 | 17060000005141 | 17060000005141 | 1 | PO791932 | ||
| 17060000005145 | L17/dossiers | 17 | 17060000005144 | 17060000005144 | 1 | PO791932 | ||
| 17060000005148 | L17/dossiers | 17 | 17060000005147 | 17060000005147 | 1 | PO791932 | ||
| 17060000005151 | L17/dossiers | 17 | 17060000005150 | 17060000005150 | 1 | PO791932 | ||
| 17060000005154 | L17/dossiers | 17 | 17060000005153 | 17060000005153 | 1 | PO791932 | ||
| 17060000005157 | L17/dossiers | 17 | 17060000005156 | 17060000005156 | 1 | PA795884 | auteur | |
| 17060000005325 | L17/dossiers | 17 | 17060000005324 | 17060000005324 | 1 | PO791932 | ||
| 17060000005328 | L17/dossiers | 17 | 17060000005327 | 17060000005327 | 1 | PA721328 | auteur | |
| 17060000005339 | L17/dossiers | 17 | 17060000005338 | 17060000005338 | 1 | PA342415 | auteur | |
| 17060000005368 | L17/dossiers | 17 | 17060000005367 | 17060000005367 | 1 | PA794038 | auteur | |
| 17060000005371 | L17/dossiers | 17 | 17060000005370 | 17060000005370 | 1 | PO791932 | ||
| 17060000005374 | L17/dossiers | 17 | 17060000005373 | 17060000005373 | 1 | PO791932 | ||
| 17060000005377 | L17/dossiers | 17 | 17060000005376 | 17060000005376 | 1 | PO791932 | ||
| 17060000005380 | L17/dossiers | 17 | 17060000005379 | 17060000005379 | 1 | PO791932 | ||
| 17060000005383 | L17/dossiers | 17 | 17060000005382 | 17060000005382 | 1 | PO791932 | ||
| 17060000005386 | L17/dossiers | 17 | 17060000005385 | 17060000005385 | 1 | PA722162 | auteur | |
| 17060000005439 | L17/dossiers | 17 | 17060000005438 | 17060000005438 | 1 | PO791932 | ||
| 17060000005442 | L17/dossiers | 17 | 17060000005441 | 17060000005441 | 1 | PO791932 | ||
| 17060000005445 | L17/dossiers | 17 | 17060000005444 | 17060000005444 | 1 | PA793122 | auteur | |
| 17060000005525 | L17/dossiers | 17 | 17060000005524 | 17060000005524 | 1 | PA721584 | auteur |