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 |
|---|---|---|---|---|---|---|---|---|
| 16060000056228 | L16/dossiers | 16 | 16060000056227 | 16060000056227 | 1 | PO791932 | ||
| 16060000056231 | L16/dossiers | 16 | 16060000056230 | 16060000056230 | 1 | PO791932 | ||
| 16060000056234 | L16/dossiers | 16 | 16060000056233 | 16060000056233 | 1 | PO791932 | ||
| 16060000056237 | L16/dossiers | 16 | 16060000056236 | 16060000056236 | 1 | PO791932 | ||
| 16060000056240 | L16/dossiers | 16 | 16060000056239 | 16060000056239 | 1 | PO791932 | ||
| 16060000056243 | L16/dossiers | 16 | 16060000056242 | 16060000056242 | 1 | PO791932 | ||
| 16060000056246 | L16/dossiers | 16 | 16060000056245 | 16060000056245 | 1 | PO791932 | ||
| 16060000056250 | L16/dossiers | 16 | 16060000056249 | 16060000056249 | 1 | PO791932 | ||
| 16060000056253 | L16/dossiers | 16 | 16060000056252 | 16060000056252 | 1 | PO791932 | ||
| 16060000056256 | L16/dossiers | 16 | 16060000056255 | 16060000056255 | 1 | PO791932 | ||
| 16060000056259 | L16/dossiers | 16 | 16060000056258 | 16060000056258 | 1 | PO791932 | ||
| 16060000056262 | L16/dossiers | 16 | 16060000056261 | 16060000056261 | 1 | PO791932 | ||
| 16060000056265 | L16/dossiers | 16 | 16060000056264 | 16060000056264 | 1 | PO791932 | ||
| 16060000056268 | L16/dossiers | 16 | 16060000056267 | 16060000056267 | 1 | PO791932 | ||
| 16060000056271 | L16/dossiers | 16 | 16060000056270 | 16060000056270 | 1 | PO791932 | ||
| 16060000056274 | L16/dossiers | 16 | 16060000056273 | 16060000056273 | 1 | PO791932 | ||
| 16060000056277 | L16/dossiers | 16 | 16060000056276 | 16060000056276 | 1 | PO791932 | ||
| 16060000056279 | L16/dossiers | 16 | 16060000056278 | 16060000056278 | 1 | PO791932 | ||
| 16060000056281 | L16/dossiers | 16 | 16060000056280 | 16060000056280 | 1 | PO791932 | ||
| 16060000056284 | L16/dossiers | 16 | 16060000056283 | 16060000056283 | 1 | PO791932 | ||
| 16060000056287 | L16/dossiers | 16 | 16060000056286 | 16060000056286 | 1 | PO791932 | ||
| 16060000056290 | L16/dossiers | 16 | 16060000056289 | 16060000056289 | 1 | PO791932 | ||
| 16060000056293 | L16/dossiers | 16 | 16060000056292 | 16060000056292 | 1 | PO791932 | ||
| 16060000056296 | L16/dossiers | 16 | 16060000056295 | 16060000056295 | 1 | PO791932 | ||
| 16060000056299 | L16/dossiers | 16 | 16060000056298 | 16060000056298 | 1 | PO791932 | ||
| 16060000056301 | L16/dossiers | 16 | 16060000056300 | 16060000056300 | 1 | PO791932 | ||
| 16060000056304 | L16/dossiers | 16 | 16060000056303 | 16060000056303 | 1 | PO791932 | ||
| 16060000056307 | L16/dossiers | 16 | 16060000056306 | 16060000056306 | 1 | PO791932 | ||
| 16060000056309 | L16/dossiers | 16 | 16060000056308 | 16060000056308 | 1 | PO791932 | ||
| 16060000056312 | L16/dossiers | 16 | 16060000056311 | 16060000056311 | 1 | PO791932 | ||
| 16060000056315 | L16/dossiers | 16 | 16060000056314 | 16060000056314 | 1 | PO791932 | ||
| 16060000056321 | L16/dossiers | 16 | 16060000056320 | 16060000056320 | 1 | PO791932 | ||
| 16060000056323 | L16/dossiers | 16 | 16060000056322 | 16060000056322 | 1 | PO791932 | ||
| 16060000056326 | L16/dossiers | 16 | 16060000056325 | 16060000056325 | 1 | PO791932 | ||
| 16060000056329 | L16/dossiers | 16 | 16060000056328 | 16060000056328 | 1 | PO791932 | ||
| 16060000056332 | L16/dossiers | 16 | 16060000056331 | 16060000056331 | 1 | PO791932 | ||
| 16060000056335 | L16/dossiers | 16 | 16060000056334 | 16060000056334 | 1 | PO791932 | ||
| 16060000056337 | L16/dossiers | 16 | 16060000056336 | 16060000056336 | 1 | PO791932 | ||
| 16060000056340 | L16/dossiers | 16 | 16060000056339 | 16060000056339 | 1 | PO791932 | ||
| 16060000056343 | L16/dossiers | 16 | 16060000056342 | 16060000056342 | 1 | PO791932 | ||
| 16060000056346 | L16/dossiers | 16 | 16060000056345 | 16060000056345 | 1 | PO791932 | ||
| 16060000056350 | L16/dossiers | 16 | 16060000056349 | 16060000056349 | 1 | PO791932 | ||
| 16060000056352 | L16/dossiers | 16 | 16060000056351 | 16060000056351 | 1 | PO791932 | ||
| 16060000056354 | L16/dossiers | 16 | 16060000056353 | 16060000056353 | 1 | PO791932 | ||
| 16060000056357 | L16/dossiers | 16 | 16060000056356 | 16060000056356 | 1 | PO791932 | ||
| 16060000056359 | L16/dossiers | 16 | 16060000056358 | 16060000056358 | 1 | PO791932 | ||
| 16060000056361 | L16/dossiers | 16 | 16060000056360 | 16060000056360 | 1 | PO791932 | ||
| 16060000056364 | L16/dossiers | 16 | 16060000056363 | 16060000056363 | 1 | PO791932 | ||
| 16060000056367 | L16/dossiers | 16 | 16060000056366 | 16060000056366 | 1 | PO791932 | ||
| 16060000056370 | L16/dossiers | 16 | 16060000056369 | 16060000056369 | 1 | PO791932 |