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 |
|---|---|---|---|---|---|---|---|---|
| 16060000082744 | L16/dossiers | 16 | 16060000082743 | 16060000082743 | 1 | PO791932 | ||
| 16060000082747 | L16/dossiers | 16 | 16060000082746 | 16060000082746 | 1 | PO791932 | ||
| 16060000082750 | L16/dossiers | 16 | 16060000082749 | 16060000082749 | 1 | PO791932 | ||
| 16060000082754 | L16/dossiers | 16 | 16060000082753 | 16060000082753 | 1 | PO791932 | ||
| 16060000082764 | L16/dossiers | 16 | 16060000082763 | 16060000082763 | 1 | PO791932 | ||
| 16060000082767 | L16/dossiers | 16 | 16060000082766 | 16060000082766 | 1 | PO791932 | ||
| 16060000082769 | L16/dossiers | 16 | 16060000082768 | 16060000082768 | 1 | PO791932 | ||
| 16060000082772 | L16/dossiers | 16 | 16060000082771 | 16060000082771 | 1 | PO791932 | ||
| 16060000082775 | L16/dossiers | 16 | 16060000082774 | 16060000082774 | 1 | PO791932 | ||
| 16060000082779 | L16/dossiers | 16 | 16060000082778 | 16060000082778 | 1 | PO791932 | ||
| 16060000082781 | L16/dossiers | 16 | 16060000082780 | 16060000082780 | 1 | PO791932 | ||
| 16060000082784 | L16/dossiers | 16 | 16060000082783 | 16060000082783 | 1 | PO791932 | ||
| 16060000082787 | L16/dossiers | 16 | 16060000082786 | 16060000082786 | 1 | PO791932 | ||
| 16060000082789 | L16/dossiers | 16 | 16060000082788 | 16060000082788 | 1 | PO791932 | ||
| 16060000082792 | L16/dossiers | 16 | 16060000082791 | 16060000082791 | 1 | PO791932 | ||
| 16060000082795 | L16/dossiers | 16 | 16060000082794 | 16060000082794 | 1 | PO791932 | ||
| 16060000082798 | L16/dossiers | 16 | 16060000082797 | 16060000082797 | 1 | PO791932 | ||
| 16060000082801 | L16/dossiers | 16 | 16060000082800 | 16060000082800 | 1 | PO791932 | ||
| 16060000082805 | L16/dossiers | 16 | 16060000082804 | 16060000082804 | 1 | PO791932 | ||
| 16060000082812 | L16/dossiers | 16 | 16060000082811 | 16060000082811 | 1 | PO791932 | ||
| 16060000082815 | L16/dossiers | 16 | 16060000082814 | 16060000082814 | 1 | PO791932 | ||
| 16060000082818 | L16/dossiers | 16 | 16060000082817 | 16060000082817 | 1 | PO791932 | ||
| 16060000082820 | L16/dossiers | 16 | 16060000082819 | 16060000082819 | 1 | PO791932 | ||
| 16060000082823 | L16/dossiers | 16 | 16060000082822 | 16060000082822 | 1 | PO791932 | ||
| 16060000082826 | L16/dossiers | 16 | 16060000082825 | 16060000082825 | 1 | PO791932 | ||
| 16060000082828 | L16/dossiers | 16 | 16060000082827 | 16060000082827 | 1 | PO791932 | ||
| 16060000082831 | L16/dossiers | 16 | 16060000082830 | 16060000082830 | 1 | PO791932 | ||
| 16060000082834 | L16/dossiers | 16 | 16060000082833 | 16060000082833 | 1 | PO791932 | ||
| 16060000082836 | L16/dossiers | 16 | 16060000082835 | 16060000082835 | 1 | PO791932 | ||
| 16060000082840 | L16/dossiers | 16 | 16060000082839 | 16060000082839 | 1 | PO791932 | ||
| 16060000082845 | L16/dossiers | 16 | 16060000082844 | 16060000082844 | 1 | PO791932 | ||
| 16060000082847 | L16/dossiers | 16 | 16060000082846 | 16060000082846 | 1 | PO791932 | ||
| 16060000082850 | L16/dossiers | 16 | 16060000082849 | 16060000082849 | 1 | PO791932 | ||
| 16060000082853 | L16/dossiers | 16 | 16060000082852 | 16060000082852 | 1 | PO791932 | ||
| 16060000082855 | L16/dossiers | 16 | 16060000082854 | 16060000082854 | 1 | PO791932 | ||
| 16060000082858 | L16/dossiers | 16 | 16060000082857 | 16060000082857 | 1 | PO791932 | ||
| 16060000082861 | L16/dossiers | 16 | 16060000082860 | 16060000082860 | 1 | PO791932 | ||
| 16060000082864 | L16/dossiers | 16 | 16060000082863 | 16060000082863 | 1 | PO791932 | ||
| 16060000082868 | L16/dossiers | 16 | 16060000082867 | 16060000082867 | 1 | PO791932 | ||
| 16060000082874 | L16/dossiers | 16 | 16060000082873 | 16060000082873 | 1 | PO791932 | ||
| 16060000082877 | L16/dossiers | 16 | 16060000082876 | 16060000082876 | 1 | PO791932 | ||
| 16060000082881 | L16/dossiers | 16 | 16060000082880 | 16060000082880 | 1 | PO791932 | ||
| 16060000082884 | L16/dossiers | 16 | 16060000082883 | 16060000082883 | 1 | PO791932 | ||
| 16060000082887 | L16/dossiers | 16 | 16060000082886 | 16060000082886 | 1 | PO791932 | ||
| 16060000082890 | L16/dossiers | 16 | 16060000082889 | 16060000082889 | 1 | PO791932 | ||
| 16060000082894 | L16/dossiers | 16 | 16060000082893 | 16060000082893 | 1 | PO791932 | ||
| 16060000082897 | L16/dossiers | 16 | 16060000082896 | 16060000082896 | 1 | PO791932 | ||
| 16060000082899 | L16/dossiers | 16 | 16060000082898 | 16060000082898 | 1 | PO791932 | ||
| 16060000082901 | L16/dossiers | 16 | 16060000082900 | 16060000082900 | 1 | PO791932 | ||
| 16060000082903 | L16/dossiers | 16 | 16060000082902 | 16060000082902 | 1 | PO791932 |