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 |
|---|---|---|---|---|---|---|---|---|
| 16060000002158 | L16/dossiers | 16 | 16060000002157 | 16060000002157 | 1 | PO644420 | ||
| 16060000002161 | L16/dossiers | 16 | 16060000002160 | 16060000002160 | 1 | PO644420 | ||
| 16060000002164 | L16/dossiers | 16 | 16060000002163 | 16060000002163 | 1 | PO644420 | ||
| 16060000002167 | L16/dossiers | 16 | 16060000002166 | 16060000002166 | 1 | PO644420 | ||
| 16060000002170 | L16/dossiers | 16 | 16060000002169 | 16060000002169 | 1 | PO644420 | ||
| 16060000002173 | L16/dossiers | 16 | 16060000002172 | 16060000002172 | 1 | PA330357 | rapporteur | |
| 16060000002174 | L16/dossiers | 16 | 16060000002172 | 16060000002172 | 2 | PO59051 | ||
| 16060000002177 | L16/dossiers | 16 | 16060000002176 | 16060000002176 | 1 | PA605922 | rapporteur | |
| 16060000002178 | L16/dossiers | 16 | 16060000002176 | 16060000002176 | 2 | PO419610 | ||
| 16060000002181 | L16/dossiers | 16 | 16060000002180 | 16060000002180 | 1 | PA333335 | rapporteur | |
| 16060000002182 | L16/dossiers | 16 | 16060000002180 | 16060000002180 | 2 | PO59051 | ||
| 16060000002185 | L16/dossiers | 16 | 16060000002184 | 16060000002184 | 1 | PO717460 | ||
| 16060000002188 | L16/dossiers | 16 | 16060000002187 | 16060000002187 | 1 | PO717460 | ||
| 16060000002191 | L16/dossiers | 16 | 16060000002190 | 16060000002190 | 1 | PO717460 | ||
| 16060000002194 | L16/dossiers | 16 | 16060000002193 | 16060000002193 | 1 | PO717460 | ||
| 16060000002197 | L16/dossiers | 16 | 16060000002196 | 16060000002196 | 1 | PO717460 | ||
| 16060000002200 | L16/dossiers | 16 | 16060000002199 | 16060000002199 | 1 | PO717460 | ||
| 16060000002203 | L16/dossiers | 16 | 16060000002202 | 16060000002202 | 1 | PO717460 | ||
| 16060000002206 | L16/dossiers | 16 | 16060000002205 | 16060000002205 | 1 | PO717460 | ||
| 16060000002209 | L16/dossiers | 16 | 16060000002208 | 16060000002208 | 1 | PO717460 | ||
| 16060000002212 | L16/dossiers | 16 | 16060000002211 | 16060000002211 | 1 | PO717460 | ||
| 16060000002215 | L16/dossiers | 16 | 16060000002214 | 16060000002214 | 1 | PO717460 | ||
| 16060000002218 | L16/dossiers | 16 | 16060000002217 | 16060000002217 | 1 | PO717460 | ||
| 16060000002221 | L16/dossiers | 16 | 16060000002220 | 16060000002220 | 1 | PO717460 | ||
| 16060000002224 | L16/dossiers | 16 | 16060000002223 | 16060000002223 | 1 | PO717460 | ||
| 16060000002227 | L16/dossiers | 16 | 16060000002226 | 16060000002226 | 1 | PO717460 | ||
| 16060000002230 | L16/dossiers | 16 | 16060000002229 | 16060000002229 | 1 | PO717460 | ||
| 16060000002233 | L16/dossiers | 16 | 16060000002232 | 16060000002232 | 1 | PO717460 | ||
| 16060000002236 | L16/dossiers | 16 | 16060000002235 | 16060000002235 | 1 | PO717460 | ||
| 16060000002239 | L16/dossiers | 16 | 16060000002238 | 16060000002238 | 1 | PO717460 | ||
| 16060000002242 | L16/dossiers | 16 | 16060000002241 | 16060000002241 | 1 | PO717460 | ||
| 16060000002245 | L16/dossiers | 16 | 16060000002244 | 16060000002244 | 1 | PO717460 | ||
| 16060000002248 | L16/dossiers | 16 | 16060000002247 | 16060000002247 | 1 | PO717460 | ||
| 16060000002251 | L16/dossiers | 16 | 16060000002250 | 16060000002250 | 1 | PO717460 | ||
| 16060000002254 | L16/dossiers | 16 | 16060000002253 | 16060000002253 | 1 | PO717460 | ||
| 16060000002257 | L16/dossiers | 16 | 16060000002256 | 16060000002256 | 1 | PO717460 | ||
| 16060000002260 | L16/dossiers | 16 | 16060000002259 | 16060000002259 | 1 | PO717460 | ||
| 16060000002263 | L16/dossiers | 16 | 16060000002262 | 16060000002262 | 1 | PO717460 | ||
| 16060000002266 | L16/dossiers | 16 | 16060000002265 | 16060000002265 | 1 | PO717460 | ||
| 16060000002269 | L16/dossiers | 16 | 16060000002268 | 16060000002268 | 1 | PO717460 | ||
| 16060000002272 | L16/dossiers | 16 | 16060000002271 | 16060000002271 | 1 | PO717460 | ||
| 16060000002275 | L16/dossiers | 16 | 16060000002274 | 16060000002274 | 1 | PO717460 | ||
| 16060000002278 | L16/dossiers | 16 | 16060000002277 | 16060000002277 | 1 | PO717460 | ||
| 16060000002281 | L16/dossiers | 16 | 16060000002280 | 16060000002280 | 1 | PO717460 | ||
| 16060000002284 | L16/dossiers | 16 | 16060000002283 | 16060000002283 | 1 | PO717460 | ||
| 16060000002287 | L16/dossiers | 16 | 16060000002286 | 16060000002286 | 1 | PO717460 | ||
| 16060000002290 | L16/dossiers | 16 | 16060000002289 | 16060000002289 | 1 | PO717460 | ||
| 16060000002293 | L16/dossiers | 16 | 16060000002292 | 16060000002292 | 1 | PO717460 | ||
| 16060000002296 | L16/dossiers | 16 | 16060000002295 | 16060000002295 | 1 | PO717460 | ||
| 16060000002299 | L16/dossiers | 16 | 16060000002298 | 16060000002298 | 1 | PO717460 |