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 |
|---|---|---|---|---|---|---|---|---|
| 16060000089060 | L16/dossiers | 16 | 16060000089058 | 16060000089058 | 2 | PA794778 | rapporteur | |
| 16060000089061 | L16/dossiers | 16 | 16060000089058 | 16060000089058 | 3 | PO59051 | ||
| 16060000089063 | L16/dossiers | 16 | 16060000089062 | 16060000089062 | 1 | PA719080 | rapporteur | |
| 16060000089064 | L16/dossiers | 16 | 16060000089062 | 16060000089062 | 2 | PA794418 | rapporteur | |
| 16060000089065 | L16/dossiers | 16 | 16060000089062 | 16060000089062 | 3 | PO419610 | ||
| 16060000089067 | L16/dossiers | 16 | 16060000089066 | 16060000089066 | 1 | PA721608 | rapporteur | |
| 16060000089068 | L16/dossiers | 16 | 16060000089066 | 16060000089066 | 2 | PA795330 | rapporteur | |
| 16060000089069 | L16/dossiers | 16 | 16060000089066 | 16060000089066 | 3 | PA1630 | rapporteur | |
| 16060000089070 | L16/dossiers | 16 | 16060000089066 | 16060000089066 | 4 | PA795228 | rapporteur | |
| 16060000089071 | L16/dossiers | 16 | 16060000089066 | 16060000089066 | 5 | PA794538 | rapporteur | |
| 16060000089072 | L16/dossiers | 16 | 16060000089066 | 16060000089066 | 6 | PO59047 | ||
| 16060000089074 | L16/dossiers | 16 | 16060000089073 | 16060000089073 | 1 | PA736209 | rapporteur | |
| 16060000089075 | L16/dossiers | 16 | 16060000089073 | 16060000089073 | 2 | PO273589 | ||
| 16060000089077 | L16/dossiers | 16 | 16060000089076 | 16060000089076 | 1 | PA775234 | rapporteur | |
| 16060000089078 | L16/dossiers | 16 | 16060000089076 | 16060000089076 | 2 | PO273589 | ||
| 16060000089080 | L16/dossiers | 16 | 16060000089079 | 16060000089079 | 1 | PA775238 | rapporteur | |
| 16060000089081 | L16/dossiers | 16 | 16060000089079 | 16060000089079 | 2 | PO273589 | ||
| 16060000089083 | L16/dossiers | 16 | 16060000089082 | 16060000089082 | 1 | PA720154 | rapporteur | |
| 16060000089084 | L16/dossiers | 16 | 16060000089082 | 16060000089082 | 2 | PO804431 | ||
| 16060000089086 | L16/dossiers | 16 | 16060000089085 | 16060000089085 | 1 | PA720430 | rapporteur | |
| 16060000089087 | L16/dossiers | 16 | 16060000089085 | 16060000089085 | 2 | PA721880 | rapporteur | |
| 16060000089088 | L16/dossiers | 16 | 16060000089085 | 16060000089085 | 3 | PO59051 | ||
| 16060000089090 | L16/dossiers | 16 | 16060000089089 | 16060000089089 | 1 | PA720446 | rapporteur | |
| 16060000089091 | L16/dossiers | 16 | 16060000089089 | 16060000089089 | 2 | PA794270 | rapporteur | |
| 16060000089092 | L16/dossiers | 16 | 16060000089089 | 16060000089089 | 3 | PO59046 | ||
| 16060000089094 | L16/dossiers | 16 | 16060000089093 | 16060000089093 | 1 | PA794386 | rapporteur | |
| 16060000089095 | L16/dossiers | 16 | 16060000089093 | 16060000089093 | 2 | PA795982 | rapporteur | |
| 16060000089096 | L16/dossiers | 16 | 16060000089093 | 16060000089093 | 3 | PO59046 | ||
| 16060000089098 | L16/dossiers | 16 | 16060000089097 | 16060000089097 | 1 | PA720334 | rapporteur | |
| 16060000089099 | L16/dossiers | 16 | 16060000089097 | 16060000089097 | 2 | PA342240 | rapporteur | |
| 16060000089100 | L16/dossiers | 16 | 16060000089097 | 16060000089097 | 3 | PO419610 | ||
| 16060000089102 | L16/dossiers | 16 | 16060000089101 | 16060000089101 | 1 | PA795908 | rapporteur | |
| 16060000089103 | L16/dossiers | 16 | 16060000089101 | 16060000089101 | 2 | PA794598 | rapporteur | |
| 16060000089104 | L16/dossiers | 16 | 16060000089101 | 16060000089101 | 3 | PO59046 | ||
| 16060000089106 | L16/dossiers | 16 | 16060000089105 | 16060000089105 | 1 | PA720772 | rapporteur | |
| 16060000089107 | L16/dossiers | 16 | 16060000089105 | 16060000089105 | 2 | PA793254 | rapporteur | |
| 16060000089108 | L16/dossiers | 16 | 16060000089105 | 16060000089105 | 3 | PO59046 | ||
| 16060000089110 | L16/dossiers | 16 | 16060000089109 | 16060000089109 | 1 | PA721916 | rapporteur | |
| 16060000089111 | L16/dossiers | 16 | 16060000089109 | 16060000089109 | 2 | PA643089 | rapporteur | |
| 16060000089112 | L16/dossiers | 16 | 16060000089109 | 16060000089109 | 3 | PO59046 | ||
| 16060000089114 | L16/dossiers | 16 | 16060000089113 | 16060000089113 | 1 | PA794570 | rapporteur | |
| 16060000089115 | L16/dossiers | 16 | 16060000089113 | 16060000089113 | 2 | PO415287 | ||
| 16060000089117 | L16/dossiers | 16 | 16060000089116 | 16060000089116 | 1 | PA793672 | rapporteur | |
| 16060000089118 | L16/dossiers | 16 | 16060000089116 | 16060000089116 | 2 | PO804431 | ||
| 16060000089120 | L16/dossiers | 16 | 16060000089119 | 16060000089119 | 1 | PA795616 | rapporteur | |
| 16060000089121 | L16/dossiers | 16 | 16060000089119 | 16060000089119 | 2 | PA609520 | rapporteur | |
| 16060000089122 | L16/dossiers | 16 | 16060000089119 | 16060000089119 | 3 | PO59047 | ||
| 16060000089124 | L16/dossiers | 16 | 16060000089123 | 16060000089123 | 1 | PA719294 | rapporteur | |
| 16060000089125 | L16/dossiers | 16 | 16060000089123 | 16060000089123 | 2 | PO59047 | ||
| 16060000089127 | L16/dossiers | 16 | 16060000089126 | 16060000089126 | 1 | PA793992 | rapporteur |