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 |
|---|---|---|---|---|---|---|---|---|
| 15060000115489 | L15/dossiers | 15 | 15060000115488 | 15060000115488 | 1 | PO717460 | ||
| 15060000115492 | L15/dossiers | 15 | 15060000115491 | 15060000115491 | 1 | PO717460 | ||
| 15060000115495 | L15/dossiers | 15 | 15060000115494 | 15060000115494 | 1 | PO717460 | ||
| 15060000115497 | L15/dossiers | 15 | 15060000115496 | 15060000115496 | 1 | PO717460 | ||
| 15060000115499 | L15/dossiers | 15 | 15060000115498 | 15060000115498 | 1 | PO717460 | ||
| 15060000115502 | L15/dossiers | 15 | 15060000115501 | 15060000115501 | 1 | PO717460 | ||
| 15060000115505 | L15/dossiers | 15 | 15060000115504 | 15060000115504 | 1 | PO717460 | ||
| 15060000115508 | L15/dossiers | 15 | 15060000115507 | 15060000115507 | 1 | PO717460 | ||
| 15060000115511 | L15/dossiers | 15 | 15060000115510 | 15060000115510 | 1 | PO717460 | ||
| 15060000115514 | L15/dossiers | 15 | 15060000115513 | 15060000115513 | 1 | PO717460 | ||
| 15060000115517 | L15/dossiers | 15 | 15060000115516 | 15060000115516 | 1 | PO717460 | ||
| 15060000115519 | L15/dossiers | 15 | 15060000115518 | 15060000115518 | 1 | PO717460 | ||
| 15060000115522 | L15/dossiers | 15 | 15060000115521 | 15060000115521 | 1 | PO717460 | ||
| 15060000115524 | L15/dossiers | 15 | 15060000115523 | 15060000115523 | 1 | PO717460 | ||
| 15060000115527 | L15/dossiers | 15 | 15060000115526 | 15060000115526 | 1 | PO717460 | ||
| 15060000115529 | L15/dossiers | 15 | 15060000115528 | 15060000115528 | 1 | PO717460 | ||
| 15060000115532 | L15/dossiers | 15 | 15060000115531 | 15060000115531 | 1 | PO717460 | ||
| 15060000115534 | L15/dossiers | 15 | 15060000115533 | 15060000115533 | 1 | PO717460 | ||
| 15060000115537 | L15/dossiers | 15 | 15060000115536 | 15060000115536 | 1 | PO717460 | ||
| 15060000115540 | L15/dossiers | 15 | 15060000115539 | 15060000115539 | 1 | PO717460 | ||
| 15060000115543 | L15/dossiers | 15 | 15060000115542 | 15060000115542 | 1 | PO717460 | ||
| 15060000115546 | L15/dossiers | 15 | 15060000115545 | 15060000115545 | 1 | PO717460 | ||
| 15060000115548 | L15/dossiers | 15 | 15060000115547 | 15060000115547 | 1 | PO717460 | ||
| 15060000115551 | L15/dossiers | 15 | 15060000115550 | 15060000115550 | 1 | PO717460 | ||
| 15060000115554 | L15/dossiers | 15 | 15060000115553 | 15060000115553 | 1 | PO717460 | ||
| 15060000115557 | L15/dossiers | 15 | 15060000115556 | 15060000115556 | 1 | PO717460 | ||
| 15060000115560 | L15/dossiers | 15 | 15060000115559 | 15060000115559 | 1 | PO717460 | ||
| 15060000115563 | L15/dossiers | 15 | 15060000115562 | 15060000115562 | 1 | PO717460 | ||
| 15060000115566 | L15/dossiers | 15 | 15060000115565 | 15060000115565 | 1 | PO717460 | ||
| 15060000115569 | L15/dossiers | 15 | 15060000115568 | 15060000115568 | 1 | PO717460 | ||
| 15060000115572 | L15/dossiers | 15 | 15060000115571 | 15060000115571 | 1 | PO717460 | ||
| 15060000115576 | L15/dossiers | 15 | 15060000115575 | 15060000115575 | 1 | PO717460 | ||
| 15060000115579 | L15/dossiers | 15 | 15060000115578 | 15060000115578 | 1 | PO717460 | ||
| 15060000115582 | L15/dossiers | 15 | 15060000115581 | 15060000115581 | 1 | PO717460 | ||
| 15060000115585 | L15/dossiers | 15 | 15060000115584 | 15060000115584 | 1 | PO717460 | ||
| 15060000115587 | L15/dossiers | 15 | 15060000115586 | 15060000115586 | 1 | PO717460 | ||
| 15060000115590 | L15/dossiers | 15 | 15060000115589 | 15060000115589 | 1 | PO717460 | ||
| 15060000115593 | L15/dossiers | 15 | 15060000115592 | 15060000115592 | 1 | PO717460 | ||
| 15060000115596 | L15/dossiers | 15 | 15060000115595 | 15060000115595 | 1 | PO717460 | ||
| 15060000115601 | L15/dossiers | 15 | 15060000115600 | 15060000115600 | 1 | PO717460 | ||
| 15060000115604 | L15/dossiers | 15 | 15060000115603 | 15060000115603 | 1 | PO717460 | ||
| 15060000115608 | L15/dossiers | 15 | 15060000115607 | 15060000115607 | 1 | PO717460 | ||
| 15060000115611 | L15/dossiers | 15 | 15060000115610 | 15060000115610 | 1 | PO717460 | ||
| 15060000115615 | L15/dossiers | 15 | 15060000115614 | 15060000115614 | 1 | PO717460 | ||
| 15060000115620 | L15/dossiers | 15 | 15060000115619 | 15060000115619 | 1 | PO717460 | ||
| 15060000115623 | L15/dossiers | 15 | 15060000115622 | 15060000115622 | 1 | PO717460 | ||
| 15060000115627 | L15/dossiers | 15 | 15060000115626 | 15060000115626 | 1 | PO717460 | ||
| 15060000115629 | L15/dossiers | 15 | 15060000115628 | 15060000115628 | 1 | PO717460 | ||
| 15060000115631 | L15/dossiers | 15 | 15060000115630 | 15060000115630 | 1 | PO717460 | ||
| 15060000115634 | L15/dossiers | 15 | 15060000115633 | 15060000115633 | 1 | PO717460 |