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 |
|---|---|---|---|---|---|---|---|---|
| 15060000115790 | L15/dossiers | 15 | 15060000115789 | 15060000115789 | 1 | PO717460 | ||
| 15060000115793 | L15/dossiers | 15 | 15060000115792 | 15060000115792 | 1 | PO717460 | ||
| 15060000115797 | L15/dossiers | 15 | 15060000115796 | 15060000115796 | 1 | PO717460 | ||
| 15060000115799 | L15/dossiers | 15 | 15060000115798 | 15060000115798 | 1 | PO717460 | ||
| 15060000115802 | L15/dossiers | 15 | 15060000115801 | 15060000115801 | 1 | PO717460 | ||
| 15060000115804 | L15/dossiers | 15 | 15060000115803 | 15060000115803 | 1 | PO717460 | ||
| 15060000115807 | L15/dossiers | 15 | 15060000115806 | 15060000115806 | 1 | PO717460 | ||
| 15060000115809 | L15/dossiers | 15 | 15060000115808 | 15060000115808 | 1 | PO717460 | ||
| 15060000115812 | L15/dossiers | 15 | 15060000115811 | 15060000115811 | 1 | PO717460 | ||
| 15060000115815 | L15/dossiers | 15 | 15060000115814 | 15060000115814 | 1 | PO717460 | ||
| 15060000115818 | L15/dossiers | 15 | 15060000115817 | 15060000115817 | 1 | PO717460 | ||
| 15060000115821 | L15/dossiers | 15 | 15060000115820 | 15060000115820 | 1 | PO717460 | ||
| 15060000115824 | L15/dossiers | 15 | 15060000115823 | 15060000115823 | 1 | PO717460 | ||
| 15060000115826 | L15/dossiers | 15 | 15060000115825 | 15060000115825 | 1 | PO717460 | ||
| 15060000115829 | L15/dossiers | 15 | 15060000115828 | 15060000115828 | 1 | PO717460 | ||
| 15060000115832 | L15/dossiers | 15 | 15060000115831 | 15060000115831 | 1 | PO717460 | ||
| 15060000115834 | L15/dossiers | 15 | 15060000115833 | 15060000115833 | 1 | PO717460 | ||
| 15060000115837 | L15/dossiers | 15 | 15060000115836 | 15060000115836 | 1 | PO717460 | ||
| 15060000115839 | L15/dossiers | 15 | 15060000115838 | 15060000115838 | 1 | PO717460 | ||
| 15060000115841 | L15/dossiers | 15 | 15060000115840 | 15060000115840 | 1 | PO717460 | ||
| 15060000115844 | L15/dossiers | 15 | 15060000115843 | 15060000115843 | 1 | PO717460 | ||
| 15060000115848 | L15/dossiers | 15 | 15060000115847 | 15060000115847 | 1 | PO717460 | ||
| 15060000115851 | L15/dossiers | 15 | 15060000115850 | 15060000115850 | 1 | PO717460 | ||
| 15060000115854 | L15/dossiers | 15 | 15060000115853 | 15060000115853 | 1 | PO717460 | ||
| 15060000115857 | L15/dossiers | 15 | 15060000115856 | 15060000115856 | 1 | PO717460 | ||
| 15060000115867 | L15/dossiers | 15 | 15060000115866 | 15060000115866 | 1 | PO717460 | ||
| 15060000115869 | L15/dossiers | 15 | 15060000115868 | 15060000115868 | 1 | PO717460 | ||
| 15060000115871 | L15/dossiers | 15 | 15060000115870 | 15060000115870 | 1 | PO717460 | ||
| 15060000115874 | L15/dossiers | 15 | 15060000115873 | 15060000115873 | 1 | PO717460 | ||
| 15060000115877 | L15/dossiers | 15 | 15060000115876 | 15060000115876 | 1 | PO717460 | ||
| 15060000115880 | L15/dossiers | 15 | 15060000115879 | 15060000115879 | 1 | PO717460 | ||
| 15060000115883 | L15/dossiers | 15 | 15060000115882 | 15060000115882 | 1 | PO717460 | ||
| 15060000115886 | L15/dossiers | 15 | 15060000115885 | 15060000115885 | 1 | PO717460 | ||
| 15060000115889 | L15/dossiers | 15 | 15060000115888 | 15060000115888 | 1 | PO717460 | ||
| 15060000115891 | L15/dossiers | 15 | 15060000115890 | 15060000115890 | 1 | PO717460 | ||
| 15060000115894 | L15/dossiers | 15 | 15060000115893 | 15060000115893 | 1 | PO717460 | ||
| 15060000115900 | L15/dossiers | 15 | 15060000115899 | 15060000115899 | 1 | PO717460 | ||
| 15060000115903 | L15/dossiers | 15 | 15060000115902 | 15060000115902 | 1 | PO717460 | ||
| 15060000115906 | L15/dossiers | 15 | 15060000115905 | 15060000115905 | 1 | PO717460 | ||
| 15060000115909 | L15/dossiers | 15 | 15060000115908 | 15060000115908 | 1 | PO717460 | ||
| 15060000115912 | L15/dossiers | 15 | 15060000115911 | 15060000115911 | 1 | PO717460 | ||
| 15060000115915 | L15/dossiers | 15 | 15060000115914 | 15060000115914 | 1 | PO717460 | ||
| 15060000115917 | L15/dossiers | 15 | 15060000115916 | 15060000115916 | 1 | PO717460 | ||
| 15060000115920 | L15/dossiers | 15 | 15060000115919 | 15060000115919 | 1 | PO717460 | ||
| 15060000115922 | L15/dossiers | 15 | 15060000115921 | 15060000115921 | 1 | PO717460 | ||
| 15060000115925 | L15/dossiers | 15 | 15060000115924 | 15060000115924 | 1 | PO717460 | ||
| 15060000115927 | L15/dossiers | 15 | 15060000115926 | 15060000115926 | 1 | PO717460 | ||
| 15060000115929 | L15/dossiers | 15 | 15060000115928 | 15060000115928 | 1 | PO717460 | ||
| 15060000115931 | L15/dossiers | 15 | 15060000115930 | 15060000115930 | 1 | PO717460 | ||
| 15060000115933 | L15/dossiers | 15 | 15060000115932 | 15060000115932 | 1 | PA345619 | auteur |