dossiers.document_auteur
Chemin document.auteurs.auteur · présence : L17 100 %, L16 100 %, L15 100 %, L14 100 %
59 594 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 |
|---|---|---|---|---|---|---|---|---|
| 17060000104351 | L17/dossiers | 17 | 17060000104350 | 17060000104350 | 1 | PO838901 | ||
| 17060000104355 | L17/dossiers | 17 | 17060000104354 | 17060000104354 | 1 | PO838901 | ||
| 17060000104358 | L17/dossiers | 17 | 17060000104357 | 17060000104357 | 1 | PA643210 | auteur | |
| 17060000104362 | L17/dossiers | 17 | 17060000104361 | 17060000104361 | 1 | PO838901 | ||
| 17060000104366 | L17/dossiers | 17 | 17060000104365 | 17060000104365 | 1 | PO838901 | ||
| 17060000104369 | L17/dossiers | 17 | 17060000104368 | 17060000104368 | 1 | PO838901 | ||
| 17060000104372 | L17/dossiers | 17 | 17060000104371 | 17060000104371 | 1 | PO838901 | ||
| 17060000104375 | L17/dossiers | 17 | 17060000104374 | 17060000104374 | 1 | PA643210 | auteur | |
| 17060000104379 | L17/dossiers | 17 | 17060000104378 | 17060000104378 | 1 | PO838901 | ||
| 17060000104382 | L17/dossiers | 17 | 17060000104381 | 17060000104381 | 1 | PO838901 | ||
| 17060000104385 | L17/dossiers | 17 | 17060000104384 | 17060000104384 | 1 | PO838901 | ||
| 17060000104388 | L17/dossiers | 17 | 17060000104387 | 17060000104387 | 1 | PO838901 | ||
| 17060000104395 | L17/dossiers | 17 | 17060000104394 | 17060000104394 | 1 | PO838901 | ||
| 17060000104398 | L17/dossiers | 17 | 17060000104397 | 17060000104397 | 1 | PO838901 | ||
| 17060000104401 | L17/dossiers | 17 | 17060000104400 | 17060000104400 | 1 | PO838901 | ||
| 17060000104404 | L17/dossiers | 17 | 17060000104403 | 17060000104403 | 1 | PA643210 | auteur | |
| 17060000104411 | L17/dossiers | 17 | 17060000104410 | 17060000104410 | 1 | PA643210 | auteur | |
| 17060000104416 | L17/dossiers | 17 | 17060000104415 | 17060000104415 | 1 | PO838901 | ||
| 17060000104419 | L17/dossiers | 17 | 17060000104418 | 17060000104418 | 1 | PO838901 | ||
| 17060000104422 | L17/dossiers | 17 | 17060000104421 | 17060000104421 | 1 | PO838901 | ||
| 17060000104425 | L17/dossiers | 17 | 17060000104424 | 17060000104424 | 1 | PO838901 | ||
| 17060000104428 | L17/dossiers | 17 | 17060000104427 | 17060000104427 | 1 | PA643210 | auteur | |
| 17060000104432 | L17/dossiers | 17 | 17060000104431 | 17060000104431 | 1 | PA702992 | auteur | |
| 17060000104436 | L17/dossiers | 17 | 17060000104435 | 17060000104435 | 1 | PO838901 | ||
| 17060000104440 | L17/dossiers | 17 | 17060000104439 | 17060000104439 | 1 | PO838901 | ||
| 17060000104443 | L17/dossiers | 17 | 17060000104442 | 17060000104442 | 1 | PO838901 | ||
| 17060000104446 | L17/dossiers | 17 | 17060000104445 | 17060000104445 | 1 | PA643210 | auteur | |
| 17060000104452 | L17/dossiers | 17 | 17060000104451 | 17060000104451 | 1 | PA643210 | auteur | |
| 17060000104459 | L17/dossiers | 17 | 17060000104458 | 17060000104458 | 1 | PO838901 | ||
| 17060000104462 | L17/dossiers | 17 | 17060000104461 | 17060000104461 | 1 | PO838901 | ||
| 17060000104465 | L17/dossiers | 17 | 17060000104464 | 17060000104464 | 1 | PO838901 | ||
| 17060000104468 | L17/dossiers | 17 | 17060000104467 | 17060000104467 | 1 | PO838901 | ||
| 17060000104471 | L17/dossiers | 17 | 17060000104470 | 17060000104470 | 1 | PA643210 | auteur | |
| 17060000104475 | L17/dossiers | 17 | 17060000104474 | 17060000104474 | 1 | PO838901 | ||
| 17060000104478 | L17/dossiers | 17 | 17060000104477 | 17060000104477 | 1 | PO838901 | ||
| 17060000104481 | L17/dossiers | 17 | 17060000104480 | 17060000104480 | 1 | PO838901 | ||
| 17060000104484 | L17/dossiers | 17 | 17060000104483 | 17060000104483 | 1 | PO838901 | ||
| 17060000104487 | L17/dossiers | 17 | 17060000104486 | 17060000104486 | 1 | PO838901 | ||
| 17060000104491 | L17/dossiers | 17 | 17060000104490 | 17060000104490 | 1 | PO838901 | ||
| 17060000104494 | L17/dossiers | 17 | 17060000104493 | 17060000104493 | 1 | PO838901 | ||
| 17060000104497 | L17/dossiers | 17 | 17060000104496 | 17060000104496 | 1 | PO838901 | ||
| 17060000104501 | L17/dossiers | 17 | 17060000104500 | 17060000104500 | 1 | PO838901 | ||
| 17060000104511 | L17/dossiers | 17 | 17060000104510 | 17060000104510 | 1 | PO838901 | ||
| 17060000104514 | L17/dossiers | 17 | 17060000104513 | 17060000104513 | 1 | PO838901 | ||
| 17060000104516 | L17/dossiers | 17 | 17060000104515 | 17060000104515 | 1 | PO838901 | ||
| 17060000104518 | L17/dossiers | 17 | 17060000104517 | 17060000104517 | 1 | PO838901 | ||
| 17060000104521 | L17/dossiers | 17 | 17060000104520 | 17060000104520 | 1 | PO838901 | ||
| 17060000104524 | L17/dossiers | 17 | 17060000104523 | 17060000104523 | 1 | PO838901 | ||
| 17060000104526 | L17/dossiers | 17 | 17060000104525 | 17060000104525 | 1 | PO838901 | ||
| 17060000104528 | L17/dossiers | 17 | 17060000104527 | 17060000104527 | 1 | PO838901 |