dossiers.document_auteur
Chemin document.auteurs.auteur · présence : L17 100 %, L16 100 %, L15 100 %, L14 100 %
59 594 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 |
|---|---|---|---|---|---|---|---|---|
| 17060000002891 | L17/dossiers | 17 | 17060000002890 | 17060000002890 | 1 | PO230434 | ||
| 17060000002894 | L17/dossiers | 17 | 17060000002893 | 17060000002893 | 1 | PO230434 | ||
| 17060000002897 | L17/dossiers | 17 | 17060000002896 | 17060000002896 | 1 | PO230434 | ||
| 17060000002900 | L17/dossiers | 17 | 17060000002899 | 17060000002899 | 1 | PO384266 | ||
| 17060000002903 | L17/dossiers | 17 | 17060000002902 | 17060000002902 | 1 | PO384266 | ||
| 17060000002906 | L17/dossiers | 17 | 17060000002905 | 17060000002905 | 1 | PO384266 | ||
| 17060000002909 | L17/dossiers | 17 | 17060000002908 | 17060000002908 | 1 | PO384266 | ||
| 17060000002912 | L17/dossiers | 17 | 17060000002911 | 17060000002911 | 1 | PO384266 | ||
| 17060000002915 | L17/dossiers | 17 | 17060000002914 | 17060000002914 | 1 | PO384266 | ||
| 17060000002918 | L17/dossiers | 17 | 17060000002917 | 17060000002917 | 1 | PO384266 | ||
| 17060000002921 | L17/dossiers | 17 | 17060000002920 | 17060000002920 | 1 | PO384266 | ||
| 17060000002924 | L17/dossiers | 17 | 17060000002923 | 17060000002923 | 1 | PO384266 | ||
| 17060000002927 | L17/dossiers | 17 | 17060000002926 | 17060000002926 | 1 | PO384266 | ||
| 17060000002930 | L17/dossiers | 17 | 17060000002929 | 17060000002929 | 1 | PO384266 | ||
| 17060000002933 | L17/dossiers | 17 | 17060000002932 | 17060000002932 | 1 | PA2295 | auteur | |
| 17060000002972 | L17/dossiers | 17 | 17060000002971 | 17060000002971 | 1 | PO384266 | ||
| 17060000002975 | L17/dossiers | 17 | 17060000002974 | 17060000002974 | 1 | PO384266 | ||
| 17060000002978 | L17/dossiers | 17 | 17060000002977 | 17060000002977 | 1 | PO384266 | ||
| 17060000002981 | L17/dossiers | 17 | 17060000002980 | 17060000002980 | 1 | PO384266 | ||
| 17060000002984 | L17/dossiers | 17 | 17060000002983 | 17060000002983 | 1 | PO384266 | ||
| 17060000002987 | L17/dossiers | 17 | 17060000002986 | 17060000002986 | 1 | PO384266 | ||
| 17060000002990 | L17/dossiers | 17 | 17060000002989 | 17060000002989 | 1 | PA267469 | rapporteur | |
| 17060000002991 | L17/dossiers | 17 | 17060000002989 | 17060000002989 | 2 | PO419610 | ||
| 17060000002994 | L17/dossiers | 17 | 17060000002993 | 17060000002993 | 1 | PO644420 | ||
| 17060000002997 | L17/dossiers | 17 | 17060000002996 | 17060000002996 | 1 | PO644420 | ||
| 17060000003000 | L17/dossiers | 17 | 17060000002999 | 17060000002999 | 1 | PO644420 | ||
| 17060000003003 | L17/dossiers | 17 | 17060000003002 | 17060000003002 | 1 | PO644420 | ||
| 17060000003006 | L17/dossiers | 17 | 17060000003005 | 17060000003005 | 1 | PO644420 | ||
| 17060000003009 | L17/dossiers | 17 | 17060000003008 | 17060000003008 | 1 | PO644420 | ||
| 17060000003012 | L17/dossiers | 17 | 17060000003011 | 17060000003011 | 1 | PO644420 | ||
| 17060000003015 | L17/dossiers | 17 | 17060000003014 | 17060000003014 | 1 | PO644420 | ||
| 17060000003018 | L17/dossiers | 17 | 17060000003017 | 17060000003017 | 1 | PO644420 | ||
| 17060000003021 | L17/dossiers | 17 | 17060000003020 | 17060000003020 | 1 | PO644420 | ||
| 17060000003024 | L17/dossiers | 17 | 17060000003023 | 17060000003023 | 1 | PO644420 | ||
| 17060000003027 | L17/dossiers | 17 | 17060000003026 | 17060000003026 | 1 | PO644420 | ||
| 17060000003030 | L17/dossiers | 17 | 17060000003029 | 17060000003029 | 1 | PO644420 | ||
| 17060000003033 | L17/dossiers | 17 | 17060000003032 | 17060000003032 | 1 | PO644420 | ||
| 17060000003036 | L17/dossiers | 17 | 17060000003035 | 17060000003035 | 1 | PO644420 | ||
| 17060000003039 | L17/dossiers | 17 | 17060000003038 | 17060000003038 | 1 | PO644420 | ||
| 17060000003042 | L17/dossiers | 17 | 17060000003041 | 17060000003041 | 1 | PO644420 | ||
| 17060000003045 | L17/dossiers | 17 | 17060000003044 | 17060000003044 | 1 | PO644420 | ||
| 17060000003048 | L17/dossiers | 17 | 17060000003047 | 17060000003047 | 1 | PO644420 | ||
| 17060000003051 | L17/dossiers | 17 | 17060000003050 | 17060000003050 | 1 | PO644420 | ||
| 17060000003054 | L17/dossiers | 17 | 17060000003053 | 17060000003053 | 1 | PO644420 | ||
| 17060000003057 | L17/dossiers | 17 | 17060000003056 | 17060000003056 | 1 | PO644420 | ||
| 17060000003060 | L17/dossiers | 17 | 17060000003059 | 17060000003059 | 1 | PO644420 | ||
| 17060000003063 | L17/dossiers | 17 | 17060000003062 | 17060000003062 | 1 | PO644420 | ||
| 17060000003066 | L17/dossiers | 17 | 17060000003065 | 17060000003065 | 1 | PO644420 | ||
| 17060000003069 | L17/dossiers | 17 | 17060000003068 | 17060000003068 | 1 | PO644420 | ||
| 17060000003072 | L17/dossiers | 17 | 17060000003071 | 17060000003071 | 1 | PO644420 |