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 |
|---|---|---|---|---|---|---|---|---|
| 17060000072758 | L17/dossiers | 17 | 17060000072757 | 17060000072757 | 1 | PO838901 | ||
| 17060000072761 | L17/dossiers | 17 | 17060000072760 | 17060000072760 | 1 | PO838901 | ||
| 17060000072764 | L17/dossiers | 17 | 17060000072763 | 17060000072763 | 1 | PO838901 | ||
| 17060000072767 | L17/dossiers | 17 | 17060000072766 | 17060000072766 | 1 | PO838901 | ||
| 17060000072770 | L17/dossiers | 17 | 17060000072769 | 17060000072769 | 1 | PO838901 | ||
| 17060000072772 | L17/dossiers | 17 | 17060000072771 | 17060000072771 | 1 | PO838901 | ||
| 17060000072775 | L17/dossiers | 17 | 17060000072774 | 17060000072774 | 1 | PO838901 | ||
| 17060000072778 | L17/dossiers | 17 | 17060000072777 | 17060000072777 | 1 | PO838901 | ||
| 17060000072781 | L17/dossiers | 17 | 17060000072780 | 17060000072780 | 1 | PO838901 | ||
| 17060000072784 | L17/dossiers | 17 | 17060000072783 | 17060000072783 | 1 | PO838901 | ||
| 17060000072787 | L17/dossiers | 17 | 17060000072786 | 17060000072786 | 1 | PO838901 | ||
| 17060000072790 | L17/dossiers | 17 | 17060000072789 | 17060000072789 | 1 | PO838901 | ||
| 17060000072793 | L17/dossiers | 17 | 17060000072792 | 17060000072792 | 1 | PO838901 | ||
| 17060000072796 | L17/dossiers | 17 | 17060000072795 | 17060000072795 | 1 | PO838901 | ||
| 17060000072799 | L17/dossiers | 17 | 17060000072798 | 17060000072798 | 1 | PO838901 | ||
| 17060000072802 | L17/dossiers | 17 | 17060000072801 | 17060000072801 | 1 | PO838901 | ||
| 17060000072805 | L17/dossiers | 17 | 17060000072804 | 17060000072804 | 1 | PO838901 | ||
| 17060000072808 | L17/dossiers | 17 | 17060000072807 | 17060000072807 | 1 | PO838901 | ||
| 17060000072811 | L17/dossiers | 17 | 17060000072810 | 17060000072810 | 1 | PO838901 | ||
| 17060000072814 | L17/dossiers | 17 | 17060000072813 | 17060000072813 | 1 | PO838901 | ||
| 17060000072817 | L17/dossiers | 17 | 17060000072816 | 17060000072816 | 1 | PO838901 | ||
| 17060000072820 | L17/dossiers | 17 | 17060000072819 | 17060000072819 | 1 | PO838901 | ||
| 17060000072823 | L17/dossiers | 17 | 17060000072822 | 17060000072822 | 1 | PO838901 | ||
| 17060000072826 | L17/dossiers | 17 | 17060000072825 | 17060000072825 | 1 | PO838901 | ||
| 17060000072829 | L17/dossiers | 17 | 17060000072828 | 17060000072828 | 1 | PO838901 | ||
| 17060000072832 | L17/dossiers | 17 | 17060000072831 | 17060000072831 | 1 | PO838901 | ||
| 17060000072835 | L17/dossiers | 17 | 17060000072834 | 17060000072834 | 1 | PO838901 | ||
| 17060000072838 | L17/dossiers | 17 | 17060000072837 | 17060000072837 | 1 | PO838901 | ||
| 17060000072841 | L17/dossiers | 17 | 17060000072840 | 17060000072840 | 1 | PO838901 | ||
| 17060000072844 | L17/dossiers | 17 | 17060000072843 | 17060000072843 | 1 | PO838901 | ||
| 17060000072847 | L17/dossiers | 17 | 17060000072846 | 17060000072846 | 1 | PO838901 | ||
| 17060000072849 | L17/dossiers | 17 | 17060000072848 | 17060000072848 | 1 | PO838901 | ||
| 17060000072851 | L17/dossiers | 17 | 17060000072850 | 17060000072850 | 1 | PO838901 | ||
| 17060000072853 | L17/dossiers | 17 | 17060000072852 | 17060000072852 | 1 | PO838901 | ||
| 17060000072855 | L17/dossiers | 17 | 17060000072854 | 17060000072854 | 1 | PO838901 | ||
| 17060000072858 | L17/dossiers | 17 | 17060000072857 | 17060000072857 | 1 | PO838901 | ||
| 17060000072861 | L17/dossiers | 17 | 17060000072860 | 17060000072860 | 1 | PO838901 | ||
| 17060000072864 | L17/dossiers | 17 | 17060000072863 | 17060000072863 | 1 | PO838901 | ||
| 17060000072867 | L17/dossiers | 17 | 17060000072866 | 17060000072866 | 1 | PO838901 | ||
| 17060000072870 | L17/dossiers | 17 | 17060000072869 | 17060000072869 | 1 | PO838901 | ||
| 17060000072872 | L17/dossiers | 17 | 17060000072871 | 17060000072871 | 1 | PO838901 | ||
| 17060000072874 | L17/dossiers | 17 | 17060000072873 | 17060000072873 | 1 | PO838901 | ||
| 17060000072876 | L17/dossiers | 17 | 17060000072875 | 17060000072875 | 1 | PO838901 | ||
| 17060000072878 | L17/dossiers | 17 | 17060000072877 | 17060000072877 | 1 | PO838901 | ||
| 17060000072880 | L17/dossiers | 17 | 17060000072879 | 17060000072879 | 1 | PO44310 | ||
| 17060000072883 | L17/dossiers | 17 | 17060000072882 | 17060000072882 | 1 | PA2162 | auteur | |
| 17060000072886 | L17/dossiers | 17 | 17060000072885 | 17060000072885 | 1 | PO78718 | ||
| 17060000072888 | L17/dossiers | 17 | 17060000072887 | 17060000072887 | 1 | PO78718 | ||
| 17060000072890 | L17/dossiers | 17 | 17060000072889 | 17060000072889 | 1 | PA2607 | auteur | |
| 17060000072953 | L17/dossiers | 17 | 17060000072952 | 17060000072952 | 1 | PA2227 | auteur |