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 |
|---|---|---|---|---|---|---|---|---|
| 16060000083711 | L16/dossiers | 16 | 16060000083710 | 16060000083710 | 1 | PO78718 | ||
| 16060000083713 | L16/dossiers | 16 | 16060000083712 | 16060000083712 | 1 | PO78718 | ||
| 16060000083715 | L16/dossiers | 16 | 16060000083714 | 16060000083714 | 1 | PO78718 | ||
| 16060000083717 | L16/dossiers | 16 | 16060000083716 | 16060000083716 | 1 | PO78718 | ||
| 16060000083719 | L16/dossiers | 16 | 16060000083718 | 16060000083718 | 1 | PA773441 | auteur | |
| 16060000083722 | L16/dossiers | 16 | 16060000083721 | 16060000083721 | 1 | PA717161 | auteur | |
| 16060000083726 | L16/dossiers | 16 | 16060000083725 | 16060000083725 | 1 | PA717161 | auteur | |
| 16060000083729 | L16/dossiers | 16 | 16060000083728 | 16060000083728 | 1 | PO78718 | ||
| 16060000083731 | L16/dossiers | 16 | 16060000083730 | 16060000083730 | 1 | PA717161 | auteur | |
| 16060000083734 | L16/dossiers | 16 | 16060000083733 | 16060000083733 | 1 | PA717161 | auteur | |
| 16060000083738 | L16/dossiers | 16 | 16060000083737 | 16060000083737 | 1 | PO78718 | ||
| 16060000083740 | L16/dossiers | 16 | 16060000083739 | 16060000083739 | 1 | PA717161 | auteur | |
| 16060000083743 | L16/dossiers | 16 | 16060000083742 | 16060000083742 | 1 | PA717161 | auteur | |
| 16060000083746 | L16/dossiers | 16 | 16060000083745 | 16060000083745 | 1 | PO78718 | ||
| 16060000083748 | L16/dossiers | 16 | 16060000083747 | 16060000083747 | 1 | PO78718 | ||
| 16060000083750 | L16/dossiers | 16 | 16060000083749 | 16060000083749 | 1 | PO78718 | ||
| 16060000083752 | L16/dossiers | 16 | 16060000083751 | 16060000083751 | 1 | PO78718 | ||
| 16060000083754 | L16/dossiers | 16 | 16060000083753 | 16060000083753 | 1 | PO78718 | ||
| 16060000083756 | L16/dossiers | 16 | 16060000083755 | 16060000083755 | 1 | PO78718 | ||
| 16060000083758 | L16/dossiers | 16 | 16060000083757 | 16060000083757 | 1 | PA717161 | auteur | |
| 16060000083761 | L16/dossiers | 16 | 16060000083760 | 16060000083760 | 1 | PA717161 | auteur | |
| 16060000083764 | L16/dossiers | 16 | 16060000083763 | 16060000083763 | 1 | PO78718 | ||
| 16060000083766 | L16/dossiers | 16 | 16060000083765 | 16060000083765 | 1 | PO78718 | ||
| 16060000083768 | L16/dossiers | 16 | 16060000083767 | 16060000083767 | 1 | PO78718 | ||
| 16060000083770 | L16/dossiers | 16 | 16060000083769 | 16060000083769 | 1 | PO78718 | ||
| 16060000083772 | L16/dossiers | 16 | 16060000083771 | 16060000083771 | 1 | PO78718 | ||
| 16060000083774 | L16/dossiers | 16 | 16060000083773 | 16060000083773 | 1 | PO78718 | ||
| 16060000083776 | L16/dossiers | 16 | 16060000083775 | 16060000083775 | 1 | PO78718 | ||
| 16060000083778 | L16/dossiers | 16 | 16060000083777 | 16060000083777 | 1 | PO78718 | ||
| 16060000083780 | L16/dossiers | 16 | 16060000083779 | 16060000083779 | 1 | PO78718 | ||
| 16060000083782 | L16/dossiers | 16 | 16060000083781 | 16060000083781 | 1 | PO78718 | ||
| 16060000083784 | L16/dossiers | 16 | 16060000083783 | 16060000083783 | 1 | PO78718 | ||
| 16060000083786 | L16/dossiers | 16 | 16060000083785 | 16060000083785 | 1 | PO78718 | ||
| 16060000083788 | L16/dossiers | 16 | 16060000083787 | 16060000083787 | 1 | PO78718 | ||
| 16060000083790 | L16/dossiers | 16 | 16060000083789 | 16060000083789 | 1 | PO78718 | ||
| 16060000083792 | L16/dossiers | 16 | 16060000083791 | 16060000083791 | 1 | PO78718 | ||
| 16060000083794 | L16/dossiers | 16 | 16060000083793 | 16060000083793 | 1 | PO78718 | ||
| 16060000083796 | L16/dossiers | 16 | 16060000083795 | 16060000083795 | 1 | PO78718 | ||
| 16060000083798 | L16/dossiers | 16 | 16060000083797 | 16060000083797 | 1 | PO78718 | ||
| 16060000083800 | L16/dossiers | 16 | 16060000083799 | 16060000083799 | 1 | PO78718 | ||
| 16060000083802 | L16/dossiers | 16 | 16060000083801 | 16060000083801 | 1 | PA736218 | rapporteur | |
| 16060000083803 | L16/dossiers | 16 | 16060000083801 | 16060000083801 | 2 | PO516753 | ||
| 16060000083805 | L16/dossiers | 16 | 16060000083804 | 16060000083804 | 1 | PA267340 | rapporteur | |
| 16060000083806 | L16/dossiers | 16 | 16060000083804 | 16060000083804 | 2 | PO211495 | ||
| 16060000083808 | L16/dossiers | 16 | 16060000083807 | 16060000083807 | 1 | PA415486 | rapporteur | |
| 16060000083809 | L16/dossiers | 16 | 16060000083807 | 16060000083807 | 2 | PO211491 | ||
| 16060000083811 | L16/dossiers | 16 | 16060000083810 | 16060000083810 | 1 | PA703525 | rapporteur | |
| 16060000083812 | L16/dossiers | 16 | 16060000083810 | 16060000083810 | 2 | PO211491 | ||
| 16060000083814 | L16/dossiers | 16 | 16060000083813 | 16060000083813 | 1 | PA590034 | rapporteur | |
| 16060000083815 | L16/dossiers | 16 | 16060000083813 | 16060000083813 | 2 | PO211491 |