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 |
|---|---|---|---|---|---|---|---|---|
| 16060000082565 | L16/dossiers | 16 | 16060000082564 | 16060000082564 | 1 | PO791932 | ||
| 16060000082569 | L16/dossiers | 16 | 16060000082568 | 16060000082568 | 1 | PA717161 | auteur | |
| 16060000082573 | L16/dossiers | 16 | 16060000082572 | 16060000082572 | 1 | PO791932 | ||
| 16060000082576 | L16/dossiers | 16 | 16060000082575 | 16060000082575 | 1 | PO791932 | ||
| 16060000082579 | L16/dossiers | 16 | 16060000082578 | 16060000082578 | 1 | PA717161 | auteur | |
| 16060000082583 | L16/dossiers | 16 | 16060000082582 | 16060000082582 | 1 | PA717161 | auteur | |
| 16060000082587 | L16/dossiers | 16 | 16060000082586 | 16060000082586 | 1 | PA702992 | auteur | |
| 16060000082591 | L16/dossiers | 16 | 16060000082590 | 16060000082590 | 1 | PA717161 | auteur | |
| 16060000082596 | L16/dossiers | 16 | 16060000082595 | 16060000082595 | 1 | PO791932 | ||
| 16060000082599 | L16/dossiers | 16 | 16060000082598 | 16060000082598 | 1 | PO791932 | ||
| 16060000082602 | L16/dossiers | 16 | 16060000082601 | 16060000082601 | 1 | PO791932 | ||
| 16060000082608 | L16/dossiers | 16 | 16060000082607 | 16060000082607 | 1 | PO791932 | ||
| 16060000082611 | L16/dossiers | 16 | 16060000082610 | 16060000082610 | 1 | PA722190 | auteur | |
| 16060000082615 | L16/dossiers | 16 | 16060000082614 | 16060000082614 | 1 | PO791932 | ||
| 16060000082619 | L16/dossiers | 16 | 16060000082618 | 16060000082618 | 1 | PO791932 | ||
| 16060000082622 | L16/dossiers | 16 | 16060000082621 | 16060000082621 | 1 | PA722190 | auteur | |
| 16060000082626 | L16/dossiers | 16 | 16060000082625 | 16060000082625 | 1 | PO791932 | ||
| 16060000082629 | L16/dossiers | 16 | 16060000082628 | 16060000082628 | 1 | PA722190 | auteur | |
| 16060000082634 | L16/dossiers | 16 | 16060000082633 | 16060000082633 | 1 | PO791932 | ||
| 16060000082637 | L16/dossiers | 16 | 16060000082636 | 16060000082636 | 1 | PO791932 | ||
| 16060000082640 | L16/dossiers | 16 | 16060000082639 | 16060000082639 | 1 | PA722190 | auteur | |
| 16060000082644 | L16/dossiers | 16 | 16060000082643 | 16060000082643 | 1 | PO791932 | ||
| 16060000082647 | L16/dossiers | 16 | 16060000082646 | 16060000082646 | 1 | PO791932 | ||
| 16060000082650 | L16/dossiers | 16 | 16060000082649 | 16060000082649 | 1 | PO791932 | ||
| 16060000082653 | L16/dossiers | 16 | 16060000082652 | 16060000082652 | 1 | PO791932 | ||
| 16060000082656 | L16/dossiers | 16 | 16060000082655 | 16060000082655 | 1 | PO791932 | ||
| 16060000082659 | L16/dossiers | 16 | 16060000082658 | 16060000082658 | 1 | PA722190 | auteur | |
| 16060000082665 | L16/dossiers | 16 | 16060000082664 | 16060000082664 | 1 | PO791932 | ||
| 16060000082668 | L16/dossiers | 16 | 16060000082667 | 16060000082667 | 1 | PA722190 | auteur | |
| 16060000082673 | L16/dossiers | 16 | 16060000082672 | 16060000082672 | 1 | PA722190 | auteur | |
| 16060000082678 | L16/dossiers | 16 | 16060000082677 | 16060000082677 | 1 | PA722190 | auteur | |
| 16060000082682 | L16/dossiers | 16 | 16060000082681 | 16060000082681 | 1 | PA722190 | auteur | |
| 16060000082686 | L16/dossiers | 16 | 16060000082685 | 16060000082685 | 1 | PO791932 | ||
| 16060000082689 | L16/dossiers | 16 | 16060000082688 | 16060000082688 | 1 | PA722190 | auteur | |
| 16060000082696 | L16/dossiers | 16 | 16060000082695 | 16060000082695 | 1 | PO791932 | ||
| 16060000082699 | L16/dossiers | 16 | 16060000082698 | 16060000082698 | 1 | PO791932 | ||
| 16060000082702 | L16/dossiers | 16 | 16060000082701 | 16060000082701 | 1 | PO791932 | ||
| 16060000082707 | L16/dossiers | 16 | 16060000082706 | 16060000082706 | 1 | PO791932 | ||
| 16060000082709 | L16/dossiers | 16 | 16060000082708 | 16060000082708 | 1 | PO791932 | ||
| 16060000082713 | L16/dossiers | 16 | 16060000082712 | 16060000082712 | 1 | PO791932 | ||
| 16060000082716 | L16/dossiers | 16 | 16060000082715 | 16060000082715 | 1 | PO791932 | ||
| 16060000082719 | L16/dossiers | 16 | 16060000082718 | 16060000082718 | 1 | PO791932 | ||
| 16060000082722 | L16/dossiers | 16 | 16060000082721 | 16060000082721 | 1 | PO791932 | ||
| 16060000082725 | L16/dossiers | 16 | 16060000082724 | 16060000082724 | 1 | PO791932 | ||
| 16060000082729 | L16/dossiers | 16 | 16060000082728 | 16060000082728 | 1 | PO791932 | ||
| 16060000082731 | L16/dossiers | 16 | 16060000082730 | 16060000082730 | 1 | PO791932 | ||
| 16060000082734 | L16/dossiers | 16 | 16060000082733 | 16060000082733 | 1 | PO791932 | ||
| 16060000082736 | L16/dossiers | 16 | 16060000082735 | 16060000082735 | 1 | PO791932 | ||
| 16060000082739 | L16/dossiers | 16 | 16060000082738 | 16060000082738 | 1 | PO791932 | ||
| 16060000082741 | L16/dossiers | 16 | 16060000082740 | 16060000082740 | 1 | PO791932 |