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 |
|---|---|---|---|---|---|---|---|---|
| 14060000019870 | L14/dossiers | 14 | 14060000019869 | 14060000019869 | 1 | PA2161 | rapporteur | |
| 14060000019871 | L14/dossiers | 14 | 14060000019869 | 14060000019869 | 2 | PO712266 | ||
| 14060000019873 | L14/dossiers | 14 | 14060000019872 | 14060000019872 | 1 | PA610354 | rapporteur | |
| 14060000019874 | L14/dossiers | 14 | 14060000019872 | 14060000019872 | 2 | PA608264 | rapporteur | |
| 14060000019875 | L14/dossiers | 14 | 14060000019872 | 14060000019872 | 3 | PO712266 | ||
| 14060000019883 | L14/dossiers | 14 | 14060000019876 | 14060000019876 | 1 | PA2161 | rapporteur | |
| 14060000019884 | L14/dossiers | 14 | 14060000019876 | 14060000019876 | 2 | PO211495 | ||
| 14060000019886 | L14/dossiers | 14 | 14060000019885 | 14060000019885 | 1 | PA610354 | rapporteur | |
| 14060000019887 | L14/dossiers | 14 | 14060000019885 | 14060000019885 | 2 | PA608264 | rapporteur | |
| 14060000019888 | L14/dossiers | 14 | 14060000019885 | 14060000019885 | 3 | PO59051 | ||
| 14060000019890 | L14/dossiers | 14 | 14060000019889 | 14060000019889 | 1 | PO78718 | ||
| 14060000019892 | L14/dossiers | 14 | 14060000019891 | 14060000019891 | 1 | PA267622 | auteur | |
| 14060000019896 | L14/dossiers | 14 | 14060000019895 | 14060000019895 | 1 | PA332206 | rapporteur | |
| 14060000019897 | L14/dossiers | 14 | 14060000019895 | 14060000019895 | 2 | PO59047 | ||
| 14060000019899 | L14/dossiers | 14 | 14060000019898 | 14060000019898 | 1 | PA267622 | auteur | |
| 14060000019901 | L14/dossiers | 14 | 14060000019900 | 14060000019900 | 1 | PA267622 | auteur | |
| 14060000019903 | L14/dossiers | 14 | 14060000019902 | 14060000019902 | 1 | PA1263 | auteur | |
| 14060000019934 | L14/dossiers | 14 | 14060000019933 | 14060000019933 | 1 | PA332305 | rapporteur | |
| 14060000019935 | L14/dossiers | 14 | 14060000019933 | 14060000019933 | 2 | PO420120 | ||
| 14060000019939 | L14/dossiers | 14 | 14060000019938 | 14060000019938 | 1 | PO644420 | ||
| 14060000019942 | L14/dossiers | 14 | 14060000019941 | 14060000019941 | 1 | PO78718 | ||
| 14060000019944 | L14/dossiers | 14 | 14060000019943 | 14060000019943 | 1 | PA328 | auteur | |
| 14060000019949 | L14/dossiers | 14 | 14060000019948 | 14060000019948 | 1 | PA341339 | rapporteur pour avis | |
| 14060000019950 | L14/dossiers | 14 | 14060000019948 | 14060000019948 | 2 | PO419604 | ||
| 14060000019952 | L14/dossiers | 14 | 14060000019951 | 14060000019951 | 1 | PA2337 | rapporteur pour avis | |
| 14060000019953 | L14/dossiers | 14 | 14060000019951 | 14060000019951 | 2 | PO211494 | ||
| 14060000019955 | L14/dossiers | 14 | 14060000019954 | 14060000019954 | 1 | PA856 | rapporteur | |
| 14060000019956 | L14/dossiers | 14 | 14060000019954 | 14060000019954 | 2 | PA332305 | rapporteur | |
| 14060000019957 | L14/dossiers | 14 | 14060000019954 | 14060000019954 | 3 | PO420120 | ||
| 14060000019965 | L14/dossiers | 14 | 14060000019958 | 14060000019958 | 1 | PA332305 | rapporteur | |
| 14060000019966 | L14/dossiers | 14 | 14060000019958 | 14060000019958 | 2 | PO420120 | ||
| 14060000019968 | L14/dossiers | 14 | 14060000019967 | 14060000019967 | 1 | PA415494 | rapporteur | |
| 14060000019969 | L14/dossiers | 14 | 14060000019967 | 14060000019967 | 2 | PO211493 | ||
| 14060000019971 | L14/dossiers | 14 | 14060000019970 | 14060000019970 | 1 | PA415494 | rapporteur | |
| 14060000019972 | L14/dossiers | 14 | 14060000019970 | 14060000019970 | 2 | PO700314 | ||
| 14060000019974 | L14/dossiers | 14 | 14060000019973 | 14060000019973 | 1 | PA328 | auteur | |
| 14060000019976 | L14/dossiers | 14 | 14060000019975 | 14060000019975 | 1 | PA332305 | rapporteur | |
| 14060000019977 | L14/dossiers | 14 | 14060000019975 | 14060000019975 | 2 | PO700314 | ||
| 14060000019979 | L14/dossiers | 14 | 14060000019978 | 14060000019978 | 1 | PA609345 | auteur | |
| 14060000020029 | L14/dossiers | 14 | 14060000020028 | 14060000020028 | 1 | PA785 | auteur | |
| 14060000020032 | L14/dossiers | 14 | 14060000020031 | 14060000020031 | 1 | PA2503 | rapporteur | |
| 14060000020033 | L14/dossiers | 14 | 14060000020031 | 14060000020031 | 2 | PO59051 | ||
| 14060000020035 | L14/dossiers | 14 | 14060000020034 | 14060000020034 | 1 | PA609726 | auteur | |
| 14060000020038 | L14/dossiers | 14 | 14060000020037 | 14060000020037 | 1 | PA267801 | auteur | |
| 14060000020041 | L14/dossiers | 14 | 14060000020040 | 14060000020040 | 1 | PA2229 | rapporteur | |
| 14060000020042 | L14/dossiers | 14 | 14060000020040 | 14060000020040 | 2 | PO677422 | ||
| 14060000020044 | L14/dossiers | 14 | 14060000020043 | 14060000020043 | 1 | PA309643 | auteur | |
| 14060000020047 | L14/dossiers | 14 | 14060000020046 | 14060000020046 | 1 | PA230 | auteur | |
| 14060000020051 | L14/dossiers | 14 | 14060000020050 | 14060000020050 | 1 | PA2161 | rapporteur | |
| 14060000020052 | L14/dossiers | 14 | 14060000020050 | 14060000020050 | 2 | PO211495 |