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 |
|---|---|---|---|---|---|---|---|---|
| 15060000088282 | L15/dossiers | 15 | 15060000088272 | 15060000088272 | 10 | PA775246 | auteur | |
| 15060000088283 | L15/dossiers | 15 | 15060000088272 | 15060000088272 | 11 | PA678263 | auteur | |
| 15060000088284 | L15/dossiers | 15 | 15060000088272 | 15060000088272 | 12 | PA1978 | auteur | |
| 15060000088285 | L15/dossiers | 15 | 15060000088272 | 15060000088272 | 13 | PA736243 | auteur | |
| 15060000088286 | L15/dossiers | 15 | 15060000088272 | 15060000088272 | 14 | PA736175 | auteur | |
| 15060000088287 | L15/dossiers | 15 | 15060000088272 | 15060000088272 | 15 | PA775296 | auteur | |
| 15060000088289 | L15/dossiers | 15 | 15060000088288 | 15060000088288 | 1 | PA267762 | auteur | |
| 15060000088290 | L15/dossiers | 15 | 15060000088288 | 15060000088288 | 2 | PA703534 | auteur | |
| 15060000088292 | L15/dossiers | 15 | 15060000088291 | 15060000088291 | 1 | PA429895 | auteur | |
| 15060000088294 | L15/dossiers | 15 | 15060000088293 | 15060000088293 | 1 | PO78718 | ||
| 15060000088296 | L15/dossiers | 15 | 15060000088295 | 15060000088295 | 1 | PO78718 | ||
| 15060000088298 | L15/dossiers | 15 | 15060000088297 | 15060000088297 | 1 | PO78718 | ||
| 15060000088300 | L15/dossiers | 15 | 15060000088299 | 15060000088299 | 1 | PO78718 | ||
| 15060000088302 | L15/dossiers | 15 | 15060000088301 | 15060000088301 | 1 | PO78718 | ||
| 15060000088304 | L15/dossiers | 15 | 15060000088303 | 15060000088303 | 1 | PO78718 | ||
| 15060000088306 | L15/dossiers | 15 | 15060000088305 | 15060000088305 | 1 | PO78718 | ||
| 15060000088308 | L15/dossiers | 15 | 15060000088307 | 15060000088307 | 1 | PO78718 | ||
| 15060000088310 | L15/dossiers | 15 | 15060000088309 | 15060000088309 | 1 | PO78718 | ||
| 15060000088312 | L15/dossiers | 15 | 15060000088311 | 15060000088311 | 1 | PO78718 | ||
| 15060000088314 | L15/dossiers | 15 | 15060000088313 | 15060000088313 | 1 | PO78718 | ||
| 15060000088316 | L15/dossiers | 15 | 15060000088315 | 15060000088315 | 1 | PO78718 | ||
| 15060000088318 | L15/dossiers | 15 | 15060000088317 | 15060000088317 | 1 | PO78718 | ||
| 15060000088320 | L15/dossiers | 15 | 15060000088319 | 15060000088319 | 1 | PO78718 | ||
| 15060000088322 | L15/dossiers | 15 | 15060000088321 | 15060000088321 | 1 | PO78718 | ||
| 15060000088324 | L15/dossiers | 15 | 15060000088323 | 15060000088323 | 1 | PO78718 | ||
| 15060000088326 | L15/dossiers | 15 | 15060000088325 | 15060000088325 | 1 | PO78718 | ||
| 15060000088328 | L15/dossiers | 15 | 15060000088327 | 15060000088327 | 1 | PO78718 | ||
| 15060000088330 | L15/dossiers | 15 | 15060000088329 | 15060000088329 | 1 | PO78718 | ||
| 15060000088332 | L15/dossiers | 15 | 15060000088331 | 15060000088331 | 1 | PO78718 | ||
| 15060000088334 | L15/dossiers | 15 | 15060000088333 | 15060000088333 | 1 | PO78718 | ||
| 15060000088336 | L15/dossiers | 15 | 15060000088335 | 15060000088335 | 1 | PO78718 | ||
| 15060000088338 | L15/dossiers | 15 | 15060000088337 | 15060000088337 | 1 | PO78718 | ||
| 15060000088340 | L15/dossiers | 15 | 15060000088339 | 15060000088339 | 1 | PO78718 | ||
| 15060000088342 | L15/dossiers | 15 | 15060000088341 | 15060000088341 | 1 | PO78718 | ||
| 15060000088344 | L15/dossiers | 15 | 15060000088343 | 15060000088343 | 1 | PO78718 | ||
| 15060000088346 | L15/dossiers | 15 | 15060000088345 | 15060000088345 | 1 | PO78718 | ||
| 15060000088348 | L15/dossiers | 15 | 15060000088347 | 15060000088347 | 1 | PO78718 | ||
| 15060000088350 | L15/dossiers | 15 | 15060000088349 | 15060000088349 | 1 | PO78718 | ||
| 15060000088352 | L15/dossiers | 15 | 15060000088351 | 15060000088351 | 1 | PO78718 | ||
| 15060000088354 | L15/dossiers | 15 | 15060000088353 | 15060000088353 | 1 | PO78718 | ||
| 15060000088356 | L15/dossiers | 15 | 15060000088355 | 15060000088355 | 1 | PO78718 | ||
| 15060000088358 | L15/dossiers | 15 | 15060000088357 | 15060000088357 | 1 | PO78718 | ||
| 15060000088360 | L15/dossiers | 15 | 15060000088359 | 15060000088359 | 1 | PO78718 | ||
| 15060000088362 | L15/dossiers | 15 | 15060000088361 | 15060000088361 | 1 | PO78718 | ||
| 15060000088364 | L15/dossiers | 15 | 15060000088363 | 15060000088363 | 1 | PO78718 | ||
| 15060000088366 | L15/dossiers | 15 | 15060000088365 | 15060000088365 | 1 | PO78718 | ||
| 15060000088368 | L15/dossiers | 15 | 15060000088367 | 15060000088367 | 1 | PO78718 | ||
| 15060000088370 | L15/dossiers | 15 | 15060000088369 | 15060000088369 | 1 | PO78718 | ||
| 15060000088372 | L15/dossiers | 15 | 15060000088371 | 15060000088371 | 1 | PO78718 | ||
| 15060000088374 | L15/dossiers | 15 | 15060000088373 | 15060000088373 | 1 | PO78718 |