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 |
|---|---|---|---|---|---|---|---|---|
| 16060000081983 | L16/dossiers | 16 | 16060000081982 | 16060000081982 | 1 | PO717460 | ||
| 16060000081986 | L16/dossiers | 16 | 16060000081985 | 16060000081985 | 1 | PO717460 | ||
| 16060000081989 | L16/dossiers | 16 | 16060000081988 | 16060000081988 | 1 | PO717460 | ||
| 16060000081993 | L16/dossiers | 16 | 16060000081992 | 16060000081992 | 1 | PO717460 | ||
| 16060000081996 | L16/dossiers | 16 | 16060000081995 | 16060000081995 | 1 | PO717460 | ||
| 16060000082000 | L16/dossiers | 16 | 16060000081999 | 16060000081999 | 1 | PO717460 | ||
| 16060000082002 | L16/dossiers | 16 | 16060000082001 | 16060000082001 | 1 | PO717460 | ||
| 16060000082004 | L16/dossiers | 16 | 16060000082003 | 16060000082003 | 1 | PO717460 | ||
| 16060000082007 | L16/dossiers | 16 | 16060000082006 | 16060000082006 | 1 | PO717460 | ||
| 16060000082010 | L16/dossiers | 16 | 16060000082009 | 16060000082009 | 1 | PO717460 | ||
| 16060000082013 | L16/dossiers | 16 | 16060000082012 | 16060000082012 | 1 | PO717460 | ||
| 16060000082017 | L16/dossiers | 16 | 16060000082016 | 16060000082016 | 1 | PO717460 | ||
| 16060000082020 | L16/dossiers | 16 | 16060000082019 | 16060000082019 | 1 | PO717460 | ||
| 16060000082023 | L16/dossiers | 16 | 16060000082022 | 16060000082022 | 1 | PO717460 | ||
| 16060000082026 | L16/dossiers | 16 | 16060000082025 | 16060000082025 | 1 | PO717460 | ||
| 16060000082029 | L16/dossiers | 16 | 16060000082028 | 16060000082028 | 1 | PO717460 | ||
| 16060000082032 | L16/dossiers | 16 | 16060000082031 | 16060000082031 | 1 | PO717460 | ||
| 16060000082034 | L16/dossiers | 16 | 16060000082033 | 16060000082033 | 1 | PA722178 | rapporteur | |
| 16060000082035 | L16/dossiers | 16 | 16060000082033 | 16060000082033 | 2 | PO59047 | ||
| 16060000082039 | L16/dossiers | 16 | 16060000082038 | 16060000082038 | 1 | PA719472 | rapporteur | |
| 16060000082040 | L16/dossiers | 16 | 16060000082038 | 16060000082038 | 2 | PA722046 | rapporteur | |
| 16060000082041 | L16/dossiers | 16 | 16060000082038 | 16060000082038 | 3 | PA719850 | rapporteur | |
| 16060000082042 | L16/dossiers | 16 | 16060000082038 | 16060000082038 | 4 | PA722038 | rapporteur | |
| 16060000082043 | L16/dossiers | 16 | 16060000082038 | 16060000082038 | 5 | PA718962 | rapporteur | |
| 16060000082044 | L16/dossiers | 16 | 16060000082038 | 16060000082038 | 6 | PA719520 | rapporteur | |
| 16060000082045 | L16/dossiers | 16 | 16060000082038 | 16060000082038 | 7 | PA719922 | rapporteur | |
| 16060000082046 | L16/dossiers | 16 | 16060000082038 | 16060000082038 | 8 | PA719310 | rapporteur | |
| 16060000082047 | L16/dossiers | 16 | 16060000082038 | 16060000082038 | 9 | PA719558 | rapporteur | |
| 16060000082048 | L16/dossiers | 16 | 16060000082038 | 16060000082038 | 10 | PO780850 | ||
| 16060000082051 | L16/dossiers | 16 | 16060000082050 | 16060000082050 | 1 | PA721372 | rapporteur | |
| 16060000082052 | L16/dossiers | 16 | 16060000082050 | 16060000082050 | 2 | PO419865 | ||
| 16060000082056 | L16/dossiers | 16 | 16060000082055 | 16060000082055 | 1 | PA719472 | rapporteur | |
| 16060000082057 | L16/dossiers | 16 | 16060000082055 | 16060000082055 | 2 | PO784067 | ||
| 16060000082059 | L16/dossiers | 16 | 16060000082058 | 16060000082058 | 1 | PA721372 | rapporteur | |
| 16060000082060 | L16/dossiers | 16 | 16060000082058 | 16060000082058 | 2 | PA718756 | rapporteur | |
| 16060000082061 | L16/dossiers | 16 | 16060000082058 | 16060000082058 | 3 | PO784473 | ||
| 16060000082063 | L16/dossiers | 16 | 16060000082062 | 16060000082062 | 1 | PA720862 | rapporteur | |
| 16060000082064 | L16/dossiers | 16 | 16060000082062 | 16060000082062 | 2 | PO419610 | ||
| 16060000082067 | L16/dossiers | 16 | 16060000082066 | 16060000082066 | 1 | PA720862 | rapporteur | |
| 16060000082068 | L16/dossiers | 16 | 16060000082066 | 16060000082066 | 2 | PO789667 | ||
| 16060000082070 | L16/dossiers | 16 | 16060000082069 | 16060000082069 | 1 | PO717460 | ||
| 16060000082073 | L16/dossiers | 16 | 16060000082072 | 16060000082072 | 1 | PO717460 | ||
| 16060000082077 | L16/dossiers | 16 | 16060000082076 | 16060000082076 | 1 | PO717460 | ||
| 16060000082079 | L16/dossiers | 16 | 16060000082078 | 16060000082078 | 1 | PO717460 | ||
| 16060000082081 | L16/dossiers | 16 | 16060000082080 | 16060000082080 | 1 | PO717460 | ||
| 16060000082084 | L16/dossiers | 16 | 16060000082083 | 16060000082083 | 1 | PO717460 | ||
| 16060000082086 | L16/dossiers | 16 | 16060000082085 | 16060000082085 | 1 | PO791932 | ||
| 16060000082089 | L16/dossiers | 16 | 16060000082088 | 16060000082088 | 1 | PO791932 | ||
| 16060000082092 | L16/dossiers | 16 | 16060000082091 | 16060000082091 | 1 | PO791932 | ||
| 16060000082095 | L16/dossiers | 16 | 16060000082094 | 16060000082094 | 1 | PO791932 |