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 |
|---|---|---|---|---|---|---|---|---|
| 15060000076800 | L15/dossiers | 15 | 15060000076799 | 15060000076799 | 1 | PO717460 | ||
| 15060000076803 | L15/dossiers | 15 | 15060000076802 | 15060000076802 | 1 | PO717460 | ||
| 15060000076807 | L15/dossiers | 15 | 15060000076806 | 15060000076806 | 1 | PO717460 | ||
| 15060000076810 | L15/dossiers | 15 | 15060000076809 | 15060000076809 | 1 | PO717460 | ||
| 15060000076813 | L15/dossiers | 15 | 15060000076812 | 15060000076812 | 1 | PO717460 | ||
| 15060000076816 | L15/dossiers | 15 | 15060000076815 | 15060000076815 | 1 | PO717460 | ||
| 15060000076819 | L15/dossiers | 15 | 15060000076818 | 15060000076818 | 1 | PO717460 | ||
| 15060000076822 | L15/dossiers | 15 | 15060000076821 | 15060000076821 | 1 | PO717460 | ||
| 15060000076825 | L15/dossiers | 15 | 15060000076824 | 15060000076824 | 1 | PO717460 | ||
| 15060000076828 | L15/dossiers | 15 | 15060000076827 | 15060000076827 | 1 | PO717460 | ||
| 15060000076831 | L15/dossiers | 15 | 15060000076830 | 15060000076830 | 1 | PO717460 | ||
| 15060000076834 | L15/dossiers | 15 | 15060000076833 | 15060000076833 | 1 | PO717460 | ||
| 15060000076837 | L15/dossiers | 15 | 15060000076836 | 15060000076836 | 1 | PO717460 | ||
| 15060000076840 | L15/dossiers | 15 | 15060000076839 | 15060000076839 | 1 | PO717460 | ||
| 15060000076842 | L15/dossiers | 15 | 15060000076841 | 15060000076841 | 1 | PO717460 | ||
| 15060000076845 | L15/dossiers | 15 | 15060000076844 | 15060000076844 | 1 | PO717460 | ||
| 15060000076848 | L15/dossiers | 15 | 15060000076847 | 15060000076847 | 1 | PO717460 | ||
| 15060000076851 | L15/dossiers | 15 | 15060000076850 | 15060000076850 | 1 | PO717460 | ||
| 15060000076854 | L15/dossiers | 15 | 15060000076853 | 15060000076853 | 1 | PO717460 | ||
| 15060000076857 | L15/dossiers | 15 | 15060000076856 | 15060000076856 | 1 | PO717460 | ||
| 15060000076859 | L15/dossiers | 15 | 15060000076858 | 15060000076858 | 1 | PO717460 | ||
| 15060000076862 | L15/dossiers | 15 | 15060000076861 | 15060000076861 | 1 | PO717460 | ||
| 15060000076865 | L15/dossiers | 15 | 15060000076864 | 15060000076864 | 1 | PO717460 | ||
| 15060000076868 | L15/dossiers | 15 | 15060000076867 | 15060000076867 | 1 | PO717460 | ||
| 15060000076870 | L15/dossiers | 15 | 15060000076869 | 15060000076869 | 1 | PO717460 | ||
| 15060000076872 | L15/dossiers | 15 | 15060000076871 | 15060000076871 | 1 | PO717460 | ||
| 15060000076875 | L15/dossiers | 15 | 15060000076874 | 15060000076874 | 1 | PO717460 | ||
| 15060000076878 | L15/dossiers | 15 | 15060000076877 | 15060000076877 | 1 | PO717460 | ||
| 15060000076880 | L15/dossiers | 15 | 15060000076879 | 15060000076879 | 1 | PO717460 | ||
| 15060000076882 | L15/dossiers | 15 | 15060000076881 | 15060000076881 | 1 | PO717460 | ||
| 15060000076885 | L15/dossiers | 15 | 15060000076884 | 15060000076884 | 1 | PO717460 | ||
| 15060000076888 | L15/dossiers | 15 | 15060000076887 | 15060000076887 | 1 | PO717460 | ||
| 15060000076891 | L15/dossiers | 15 | 15060000076890 | 15060000076890 | 1 | PO717460 | ||
| 15060000076894 | L15/dossiers | 15 | 15060000076893 | 15060000076893 | 1 | PO717460 | ||
| 15060000076897 | L15/dossiers | 15 | 15060000076896 | 15060000076896 | 1 | PO717460 | ||
| 15060000076900 | L15/dossiers | 15 | 15060000076899 | 15060000076899 | 1 | PO717460 | ||
| 15060000076903 | L15/dossiers | 15 | 15060000076902 | 15060000076902 | 1 | PO717460 | ||
| 15060000076906 | L15/dossiers | 15 | 15060000076905 | 15060000076905 | 1 | PO717460 | ||
| 15060000076909 | L15/dossiers | 15 | 15060000076908 | 15060000076908 | 1 | PO717460 | ||
| 15060000076912 | L15/dossiers | 15 | 15060000076911 | 15060000076911 | 1 | PO717460 | ||
| 15060000076915 | L15/dossiers | 15 | 15060000076914 | 15060000076914 | 1 | PO717460 | ||
| 15060000076918 | L15/dossiers | 15 | 15060000076917 | 15060000076917 | 1 | PO717460 | ||
| 15060000076921 | L15/dossiers | 15 | 15060000076920 | 15060000076920 | 1 | PO717460 | ||
| 15060000076924 | L15/dossiers | 15 | 15060000076923 | 15060000076923 | 1 | PO717460 | ||
| 15060000076927 | L15/dossiers | 15 | 15060000076926 | 15060000076926 | 1 | PO717460 | ||
| 15060000076929 | L15/dossiers | 15 | 15060000076928 | 15060000076928 | 1 | PO717460 | ||
| 15060000076931 | L15/dossiers | 15 | 15060000076930 | 15060000076930 | 1 | PO717460 | ||
| 15060000076933 | L15/dossiers | 15 | 15060000076932 | 15060000076932 | 1 | PO717460 | ||
| 15060000076936 | L15/dossiers | 15 | 15060000076935 | 15060000076935 | 1 | PO717460 | ||
| 15060000076938 | L15/dossiers | 15 | 15060000076937 | 15060000076937 | 1 | PO717460 |