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 |
|---|---|---|---|---|---|---|---|---|
| 14060000023795 | L14/dossiers | 14 | 14060000023793 | 14060000023793 | 2 | PA1684 | rapporteur | |
| 14060000023796 | L14/dossiers | 14 | 14060000023793 | 14060000023793 | 3 | PO211495 | ||
| 14060000023798 | L14/dossiers | 14 | 14060000023797 | 14060000023797 | 1 | PA330357 | rapporteur | |
| 14060000023799 | L14/dossiers | 14 | 14060000023797 | 14060000023797 | 2 | PO59051 | ||
| 14060000023801 | L14/dossiers | 14 | 14060000023800 | 14060000023800 | 1 | PO78718 | ||
| 14060000023803 | L14/dossiers | 14 | 14060000023802 | 14060000023802 | 1 | PA335159 | auteur | |
| 14060000023841 | L14/dossiers | 14 | 14060000023840 | 14060000023840 | 1 | PA332747 | auteur | |
| 14060000023858 | L14/dossiers | 14 | 14060000023857 | 14060000023857 | 1 | PA606991 | rapporteur | |
| 14060000023859 | L14/dossiers | 14 | 14060000023857 | 14060000023857 | 2 | PO420120 | ||
| 14060000023861 | L14/dossiers | 14 | 14060000023860 | 14060000023860 | 1 | PA337568 | rapporteur | |
| 14060000023862 | L14/dossiers | 14 | 14060000023860 | 14060000023860 | 2 | PA2295 | rapporteur | |
| 14060000023863 | L14/dossiers | 14 | 14060000023860 | 14060000023860 | 3 | PO675659 | ||
| 14060000023865 | L14/dossiers | 14 | 14060000023864 | 14060000023864 | 1 | PA268019 | auteur | |
| 14060000023868 | L14/dossiers | 14 | 14060000023867 | 14060000023867 | 1 | PA230 | auteur | |
| 14060000023870 | L14/dossiers | 14 | 14060000023869 | 14060000023869 | 1 | PA2503 | rapporteur | |
| 14060000023871 | L14/dossiers | 14 | 14060000023869 | 14060000023869 | 2 | PO59051 | ||
| 14060000023873 | L14/dossiers | 14 | 14060000023872 | 14060000023872 | 1 | PA2045 | auteur | |
| 14060000023892 | L14/dossiers | 14 | 14060000023891 | 14060000023891 | 1 | PA605349 | rapporteur | |
| 14060000023893 | L14/dossiers | 14 | 14060000023891 | 14060000023891 | 2 | PO419610 | ||
| 14060000023895 | L14/dossiers | 14 | 14060000023894 | 14060000023894 | 1 | PO78718 | ||
| 14060000023897 | L14/dossiers | 14 | 14060000023896 | 14060000023896 | 1 | PA1886 | auteur | |
| 14060000023898 | L14/dossiers | 14 | 14060000023896 | 14060000023896 | 2 | PA605349 | auteur | |
| 14060000023916 | L14/dossiers | 14 | 14060000023915 | 14060000023915 | 1 | PA605349 | rapporteur | |
| 14060000023917 | L14/dossiers | 14 | 14060000023915 | 14060000023915 | 2 | PO419610 | ||
| 14060000023920 | L14/dossiers | 14 | 14060000023919 | 14060000023919 | 1 | PA328 | auteur | |
| 14060000023923 | L14/dossiers | 14 | 14060000023922 | 14060000023922 | 1 | PO644420 | ||
| 14060000023926 | L14/dossiers | 14 | 14060000023925 | 14060000023925 | 1 | PA1229 | rapporteur | |
| 14060000023927 | L14/dossiers | 14 | 14060000023925 | 14060000023925 | 2 | PO211491 | ||
| 14060000023929 | L14/dossiers | 14 | 14060000023928 | 14060000023928 | 1 | PA328 | auteur | |
| 14060000023931 | L14/dossiers | 14 | 14060000023930 | 14060000023930 | 1 | PA2073 | rapporteur | |
| 14060000023932 | L14/dossiers | 14 | 14060000023930 | 14060000023930 | 2 | PO59047 | ||
| 14060000023934 | L14/dossiers | 14 | 14060000023933 | 14060000023933 | 1 | PA689 | auteur | |
| 14060000023944 | L14/dossiers | 14 | 14060000023943 | 14060000023943 | 1 | PA266774 | auteur | |
| 14060000023983 | L14/dossiers | 14 | 14060000023982 | 14060000023982 | 1 | PA267622 | auteur | |
| 14060000023986 | L14/dossiers | 14 | 14060000023985 | 14060000023985 | 1 | PA267622 | auteur | |
| 14060000023989 | L14/dossiers | 14 | 14060000023988 | 14060000023988 | 1 | PO644420 | ||
| 14060000023992 | L14/dossiers | 14 | 14060000023991 | 14060000023991 | 1 | PA605426 | rapporteur | |
| 14060000023993 | L14/dossiers | 14 | 14060000023991 | 14060000023991 | 2 | PO59051 | ||
| 14060000023996 | L14/dossiers | 14 | 14060000023995 | 14060000023995 | 1 | PA605426 | rapporteur | |
| 14060000023997 | L14/dossiers | 14 | 14060000023995 | 14060000023995 | 2 | PO59051 | ||
| 14060000023999 | L14/dossiers | 14 | 14060000023998 | 14060000023998 | 1 | PA945 | rapporteur | |
| 14060000024000 | L14/dossiers | 14 | 14060000023998 | 14060000023998 | 2 | PO211495 | ||
| 14060000024002 | L14/dossiers | 14 | 14060000024001 | 14060000024001 | 1 | PA328 | auteur | |
| 14060000024006 | L14/dossiers | 14 | 14060000024005 | 14060000024005 | 1 | PO78718 | ||
| 14060000024008 | L14/dossiers | 14 | 14060000024007 | 14060000024007 | 1 | PA227097 | rapporteur | |
| 14060000024009 | L14/dossiers | 14 | 14060000024007 | 14060000024007 | 2 | PO211491 | ||
| 14060000024011 | L14/dossiers | 14 | 14060000024010 | 14060000024010 | 1 | PA2045 | rapporteur | |
| 14060000024012 | L14/dossiers | 14 | 14060000024010 | 14060000024010 | 2 | PO59047 | ||
| 14060000024014 | L14/dossiers | 14 | 14060000024013 | 14060000024013 | 1 | PA328 | auteur | |
| 14060000024016 | L14/dossiers | 14 | 14060000024015 | 14060000024015 | 1 | PA2971 | auteur |