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 |
|---|---|---|---|---|---|---|---|---|
| 15060000113038 | L15/dossiers | 15 | 15060000113037 | 15060000113037 | 1 | PO717460 | ||
| 15060000113041 | L15/dossiers | 15 | 15060000113040 | 15060000113040 | 1 | PO717460 | ||
| 15060000113045 | L15/dossiers | 15 | 15060000113044 | 15060000113044 | 1 | PO717460 | ||
| 15060000113047 | L15/dossiers | 15 | 15060000113046 | 15060000113046 | 1 | PO717460 | ||
| 15060000113050 | L15/dossiers | 15 | 15060000113049 | 15060000113049 | 1 | PO717460 | ||
| 15060000113053 | L15/dossiers | 15 | 15060000113052 | 15060000113052 | 1 | PO717460 | ||
| 15060000113056 | L15/dossiers | 15 | 15060000113055 | 15060000113055 | 1 | PO717460 | ||
| 15060000113059 | L15/dossiers | 15 | 15060000113058 | 15060000113058 | 1 | PO717460 | ||
| 15060000113063 | L15/dossiers | 15 | 15060000113062 | 15060000113062 | 1 | PO717460 | ||
| 15060000113066 | L15/dossiers | 15 | 15060000113065 | 15060000113065 | 1 | PO717460 | ||
| 15060000113070 | L15/dossiers | 15 | 15060000113069 | 15060000113069 | 1 | PO717460 | ||
| 15060000113072 | L15/dossiers | 15 | 15060000113071 | 15060000113071 | 1 | PO717460 | ||
| 15060000113075 | L15/dossiers | 15 | 15060000113074 | 15060000113074 | 1 | PO717460 | ||
| 15060000113079 | L15/dossiers | 15 | 15060000113078 | 15060000113078 | 1 | PO717460 | ||
| 15060000113082 | L15/dossiers | 15 | 15060000113081 | 15060000113081 | 1 | PO717460 | ||
| 15060000113085 | L15/dossiers | 15 | 15060000113084 | 15060000113084 | 1 | PO717460 | ||
| 15060000113088 | L15/dossiers | 15 | 15060000113087 | 15060000113087 | 1 | PO717460 | ||
| 15060000113098 | L15/dossiers | 15 | 15060000113097 | 15060000113097 | 1 | PO717460 | ||
| 15060000113101 | L15/dossiers | 15 | 15060000113100 | 15060000113100 | 1 | PO717460 | ||
| 15060000113104 | L15/dossiers | 15 | 15060000113103 | 15060000113103 | 1 | PO717460 | ||
| 15060000113108 | L15/dossiers | 15 | 15060000113107 | 15060000113107 | 1 | PO717460 | ||
| 15060000113111 | L15/dossiers | 15 | 15060000113110 | 15060000113110 | 1 | PO717460 | ||
| 15060000113114 | L15/dossiers | 15 | 15060000113113 | 15060000113113 | 1 | PO717460 | ||
| 15060000113117 | L15/dossiers | 15 | 15060000113116 | 15060000113116 | 1 | PO717460 | ||
| 15060000113120 | L15/dossiers | 15 | 15060000113119 | 15060000113119 | 1 | PO717460 | ||
| 15060000113123 | L15/dossiers | 15 | 15060000113122 | 15060000113122 | 1 | PO717460 | ||
| 15060000113126 | L15/dossiers | 15 | 15060000113125 | 15060000113125 | 1 | PO717460 | ||
| 15060000113129 | L15/dossiers | 15 | 15060000113128 | 15060000113128 | 1 | PO717460 | ||
| 15060000113132 | L15/dossiers | 15 | 15060000113131 | 15060000113131 | 1 | PO717460 | ||
| 15060000113135 | L15/dossiers | 15 | 15060000113134 | 15060000113134 | 1 | PO717460 | ||
| 15060000113138 | L15/dossiers | 15 | 15060000113137 | 15060000113137 | 1 | PO717460 | ||
| 15060000113140 | L15/dossiers | 15 | 15060000113139 | 15060000113139 | 1 | PO717460 | ||
| 15060000113143 | L15/dossiers | 15 | 15060000113142 | 15060000113142 | 1 | PO717460 | ||
| 15060000113147 | L15/dossiers | 15 | 15060000113146 | 15060000113146 | 1 | PO717460 | ||
| 15060000113150 | L15/dossiers | 15 | 15060000113149 | 15060000113149 | 1 | PO717460 | ||
| 15060000113153 | L15/dossiers | 15 | 15060000113152 | 15060000113152 | 1 | PO717460 | ||
| 15060000113158 | L15/dossiers | 15 | 15060000113157 | 15060000113157 | 1 | PO717460 | ||
| 15060000113161 | L15/dossiers | 15 | 15060000113160 | 15060000113160 | 1 | PO717460 | ||
| 15060000113164 | L15/dossiers | 15 | 15060000113163 | 15060000113163 | 1 | PO717460 | ||
| 15060000113167 | L15/dossiers | 15 | 15060000113166 | 15060000113166 | 1 | PO717460 | ||
| 15060000113170 | L15/dossiers | 15 | 15060000113169 | 15060000113169 | 1 | PO717460 | ||
| 15060000113173 | L15/dossiers | 15 | 15060000113172 | 15060000113172 | 1 | PO717460 | ||
| 15060000113175 | L15/dossiers | 15 | 15060000113174 | 15060000113174 | 1 | PO717460 | ||
| 15060000113177 | L15/dossiers | 15 | 15060000113176 | 15060000113176 | 1 | PO717460 | ||
| 15060000113180 | L15/dossiers | 15 | 15060000113179 | 15060000113179 | 1 | PO717460 | ||
| 15060000113184 | L15/dossiers | 15 | 15060000113183 | 15060000113183 | 1 | PO717460 | ||
| 15060000113187 | L15/dossiers | 15 | 15060000113186 | 15060000113186 | 1 | PO717460 | ||
| 15060000113190 | L15/dossiers | 15 | 15060000113189 | 15060000113189 | 1 | PO717460 | ||
| 15060000113192 | L15/dossiers | 15 | 15060000113191 | 15060000113191 | 1 | PO717460 | ||
| 15060000113195 | L15/dossiers | 15 | 15060000113194 | 15060000113194 | 1 | PO717460 |