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 |
|---|---|---|---|---|---|---|---|---|
| 17060000105653 | L17/dossiers | 17 | 17060000105652 | 17060000105652 | 1 | PA643210 | auteur | |
| 17060000105656 | L17/dossiers | 17 | 17060000105655 | 17060000105655 | 1 | PO78718 | ||
| 17060000105658 | L17/dossiers | 17 | 17060000105657 | 17060000105657 | 1 | PO78718 | ||
| 17060000105660 | L17/dossiers | 17 | 17060000105659 | 17060000105659 | 1 | PO78718 | ||
| 17060000105662 | L17/dossiers | 17 | 17060000105661 | 17060000105661 | 1 | PA643210 | auteur | |
| 17060000105665 | L17/dossiers | 17 | 17060000105664 | 17060000105664 | 1 | PA643210 | auteur | |
| 17060000105668 | L17/dossiers | 17 | 17060000105667 | 17060000105667 | 1 | PA643210 | auteur | |
| 17060000105671 | L17/dossiers | 17 | 17060000105670 | 17060000105670 | 1 | PO78718 | ||
| 17060000105673 | L17/dossiers | 17 | 17060000105672 | 17060000105672 | 1 | PA643210 | auteur | |
| 17060000105676 | L17/dossiers | 17 | 17060000105675 | 17060000105675 | 1 | PO78718 | ||
| 17060000105678 | L17/dossiers | 17 | 17060000105677 | 17060000105677 | 1 | PO78718 | ||
| 17060000105680 | L17/dossiers | 17 | 17060000105679 | 17060000105679 | 1 | PO78718 | ||
| 17060000105682 | L17/dossiers | 17 | 17060000105681 | 17060000105681 | 1 | PA643210 | auteur | |
| 17060000105685 | L17/dossiers | 17 | 17060000105684 | 17060000105684 | 1 | PA643210 | auteur | |
| 17060000105688 | L17/dossiers | 17 | 17060000105687 | 17060000105687 | 1 | PA643210 | auteur | |
| 17060000105691 | L17/dossiers | 17 | 17060000105690 | 17060000105690 | 1 | PO78718 | ||
| 17060000105693 | L17/dossiers | 17 | 17060000105692 | 17060000105692 | 1 | PA643210 | auteur | |
| 17060000105698 | L17/dossiers | 17 | 17060000105697 | 17060000105697 | 1 | PO78718 | ||
| 17060000105700 | L17/dossiers | 17 | 17060000105699 | 17060000105699 | 1 | PO78718 | ||
| 17060000105702 | L17/dossiers | 17 | 17060000105701 | 17060000105701 | 1 | PA643210 | auteur | |
| 17060000105705 | L17/dossiers | 17 | 17060000105704 | 17060000105704 | 1 | PA643210 | auteur | |
| 17060000105708 | L17/dossiers | 17 | 17060000105707 | 17060000105707 | 1 | PA643210 | auteur | |
| 17060000105711 | L17/dossiers | 17 | 17060000105710 | 17060000105710 | 1 | PA643210 | auteur | |
| 17060000105714 | L17/dossiers | 17 | 17060000105713 | 17060000105713 | 1 | PA643210 | auteur | |
| 17060000105717 | L17/dossiers | 17 | 17060000105716 | 17060000105716 | 1 | PA643210 | auteur | |
| 17060000105720 | L17/dossiers | 17 | 17060000105719 | 17060000105719 | 1 | PA643210 | auteur | |
| 17060000105723 | L17/dossiers | 17 | 17060000105722 | 17060000105722 | 1 | PA643210 | auteur | |
| 17060000105726 | L17/dossiers | 17 | 17060000105725 | 17060000105725 | 1 | PA643210 | auteur | |
| 17060000105729 | L17/dossiers | 17 | 17060000105728 | 17060000105728 | 1 | PA643210 | auteur | |
| 17060000105732 | L17/dossiers | 17 | 17060000105731 | 17060000105731 | 1 | PA643210 | auteur | |
| 17060000105735 | L17/dossiers | 17 | 17060000105734 | 17060000105734 | 1 | PA643210 | auteur | |
| 17060000105738 | L17/dossiers | 17 | 17060000105737 | 17060000105737 | 1 | PA643210 | auteur | |
| 17060000105741 | L17/dossiers | 17 | 17060000105740 | 17060000105740 | 1 | PA643210 | auteur | |
| 17060000105744 | L17/dossiers | 17 | 17060000105743 | 17060000105743 | 1 | PA643210 | auteur | |
| 17060000105747 | L17/dossiers | 17 | 17060000105746 | 17060000105746 | 1 | PO78718 | ||
| 17060000105749 | L17/dossiers | 17 | 17060000105748 | 17060000105748 | 1 | PO78718 | ||
| 17060000105751 | L17/dossiers | 17 | 17060000105750 | 17060000105750 | 1 | PA643210 | auteur | |
| 17060000105754 | L17/dossiers | 17 | 17060000105753 | 17060000105753 | 1 | PO78718 | ||
| 17060000105756 | L17/dossiers | 17 | 17060000105755 | 17060000105755 | 1 | PA643210 | auteur | |
| 17060000105759 | L17/dossiers | 17 | 17060000105758 | 17060000105758 | 1 | PA643210 | auteur | |
| 17060000105762 | L17/dossiers | 17 | 17060000105761 | 17060000105761 | 1 | PA643210 | auteur | |
| 17060000105765 | L17/dossiers | 17 | 17060000105764 | 17060000105764 | 1 | PO78718 | ||
| 17060000105767 | L17/dossiers | 17 | 17060000105766 | 17060000105766 | 1 | PA643210 | auteur | |
| 17060000105770 | L17/dossiers | 17 | 17060000105769 | 17060000105769 | 1 | PA643210 | auteur | |
| 17060000105774 | L17/dossiers | 17 | 17060000105773 | 17060000105773 | 1 | PA643210 | auteur | |
| 17060000105777 | L17/dossiers | 17 | 17060000105776 | 17060000105776 | 1 | PA643210 | auteur | |
| 17060000105780 | L17/dossiers | 17 | 17060000105779 | 17060000105779 | 1 | PO78718 | ||
| 17060000105782 | L17/dossiers | 17 | 17060000105781 | 17060000105781 | 1 | PA643210 | auteur | |
| 17060000105785 | L17/dossiers | 17 | 17060000105784 | 17060000105784 | 1 | PA643210 | auteur | |
| 17060000105788 | L17/dossiers | 17 | 17060000105787 | 17060000105787 | 1 | PO78718 |