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 |
|---|---|---|---|---|---|---|---|---|
| 17060000106281 | L17/dossiers | 17 | 17060000106276 | 17060000106276 | 2 | PO420120 | ||
| 17060000106287 | L17/dossiers | 17 | 17060000106282 | 17060000106282 | 1 | PA718784 | rapporteur | |
| 17060000106288 | L17/dossiers | 17 | 17060000106282 | 17060000106282 | 2 | PA721328 | rapporteur | |
| 17060000106289 | L17/dossiers | 17 | 17060000106282 | 17060000106282 | 3 | PO59051 | ||
| 17060000106294 | L17/dossiers | 17 | 17060000106290 | 17060000106290 | 1 | PA793122 | rapporteur | |
| 17060000106295 | L17/dossiers | 17 | 17060000106290 | 17060000106290 | 2 | PO419610 | ||
| 17060000106301 | L17/dossiers | 17 | 17060000106296 | 17060000106296 | 1 | PA605745 | rapporteur | |
| 17060000106302 | L17/dossiers | 17 | 17060000106296 | 17060000106296 | 2 | PA721976 | rapporteur | |
| 17060000106303 | L17/dossiers | 17 | 17060000106296 | 17060000106296 | 3 | PO59051 | ||
| 17060000106308 | L17/dossiers | 17 | 17060000106304 | 17060000106304 | 1 | PA608172 | rapporteur | |
| 17060000106309 | L17/dossiers | 17 | 17060000106304 | 17060000106304 | 2 | PO59048 | ||
| 17060000106314 | L17/dossiers | 17 | 17060000106310 | 17060000106310 | 1 | PA795762 | rapporteur | |
| 17060000106315 | L17/dossiers | 17 | 17060000106310 | 17060000106310 | 2 | PO420120 | ||
| 17060000106320 | L17/dossiers | 17 | 17060000106316 | 17060000106316 | 1 | PA340343 | rapporteur | |
| 17060000106321 | L17/dossiers | 17 | 17060000106316 | 17060000106316 | 2 | PO59051 | ||
| 17060000106326 | L17/dossiers | 17 | 17060000106322 | 17060000106322 | 1 | PA793306 | rapporteur | |
| 17060000106327 | L17/dossiers | 17 | 17060000106322 | 17060000106322 | 2 | PO59051 | ||
| 17060000106332 | L17/dossiers | 17 | 17060000106328 | 17060000106328 | 1 | PA795026 | rapporteur | |
| 17060000106333 | L17/dossiers | 17 | 17060000106328 | 17060000106328 | 2 | PO419865 | ||
| 17060000106335 | L17/dossiers | 17 | 17060000106334 | 17060000106334 | 1 | PA721722 | rapporteur | |
| 17060000106336 | L17/dossiers | 17 | 17060000106334 | 17060000106334 | 2 | PO59047 | ||
| 17060000106341 | L17/dossiers | 17 | 17060000106337 | 17060000106337 | 1 | PA722150 | rapporteur | |
| 17060000106342 | L17/dossiers | 17 | 17060000106337 | 17060000106337 | 2 | PO59051 | ||
| 17060000106347 | L17/dossiers | 17 | 17060000106343 | 17060000106343 | 1 | PA342415 | rapporteur | |
| 17060000106348 | L17/dossiers | 17 | 17060000106343 | 17060000106343 | 2 | PO420120 | ||
| 17060000106350 | L17/dossiers | 17 | 17060000106349 | 17060000106349 | 1 | PA720022 | rapporteur | |
| 17060000106351 | L17/dossiers | 17 | 17060000106349 | 17060000106349 | 2 | PA795794 | rapporteur | |
| 17060000106352 | L17/dossiers | 17 | 17060000106349 | 17060000106349 | 3 | PO835801 | ||
| 17060000106357 | L17/dossiers | 17 | 17060000106353 | 17060000106353 | 1 | PA793948 | rapporteur | |
| 17060000106358 | L17/dossiers | 17 | 17060000106353 | 17060000106353 | 2 | PO419865 | ||
| 17060000106360 | L17/dossiers | 17 | 17060000106359 | 17060000106359 | 1 | PA795884 | rapporteur | |
| 17060000106361 | L17/dossiers | 17 | 17060000106359 | 17060000106359 | 2 | PO835829 | ||
| 17060000106366 | L17/dossiers | 17 | 17060000106362 | 17060000106362 | 1 | PA642868 | rapporteur | |
| 17060000106367 | L17/dossiers | 17 | 17060000106362 | 17060000106362 | 2 | PO420120 | ||
| 17060000106372 | L17/dossiers | 17 | 17060000106368 | 17060000106368 | 1 | PA721584 | rapporteur | |
| 17060000106373 | L17/dossiers | 17 | 17060000106368 | 17060000106368 | 2 | PO59051 | ||
| 17060000106393 | L17/dossiers | 17 | 17060000106374 | 17060000106374 | 1 | PA720222 | rapporteur | |
| 17060000106394 | L17/dossiers | 17 | 17060000106374 | 17060000106374 | 2 | PA720342 | rapporteur | |
| 17060000106395 | L17/dossiers | 17 | 17060000106374 | 17060000106374 | 3 | PA719664 | rapporteur | |
| 17060000106396 | L17/dossiers | 17 | 17060000106374 | 17060000106374 | 4 | PA795374 | rapporteur | |
| 17060000106397 | L17/dossiers | 17 | 17060000106374 | 17060000106374 | 5 | PO419610 | ||
| 17060000106403 | L17/dossiers | 17 | 17060000106398 | 17060000106398 | 1 | PA719814 | rapporteur | |
| 17060000106404 | L17/dossiers | 17 | 17060000106398 | 17060000106398 | 2 | PA267324 | rapporteur | |
| 17060000106405 | L17/dossiers | 17 | 17060000106398 | 17060000106398 | 3 | PO419604 | ||
| 17060000106410 | L17/dossiers | 17 | 17060000106406 | 17060000106406 | 1 | PA720692 | rapporteur | |
| 17060000106411 | L17/dossiers | 17 | 17060000106406 | 17060000106406 | 2 | PO420120 | ||
| 17060000106413 | L17/dossiers | 17 | 17060000106412 | 17060000106412 | 1 | PA720334 | rapporteur | |
| 17060000106414 | L17/dossiers | 17 | 17060000106412 | 17060000106412 | 2 | PO59047 | ||
| 17060000106416 | L17/dossiers | 17 | 17060000106415 | 17060000106415 | 1 | PA722150 | rapporteur | |
| 17060000106417 | L17/dossiers | 17 | 17060000106415 | 17060000106415 | 2 | PO838264 |