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 |
|---|---|---|---|---|---|---|---|---|
| 15060000078083 | L15/dossiers | 15 | 15060000078082 | 15060000078082 | 1 | PO717460 | ||
| 15060000078086 | L15/dossiers | 15 | 15060000078085 | 15060000078085 | 1 | PO717460 | ||
| 15060000078089 | L15/dossiers | 15 | 15060000078088 | 15060000078088 | 1 | PO717460 | ||
| 15060000078092 | L15/dossiers | 15 | 15060000078091 | 15060000078091 | 1 | PO717460 | ||
| 15060000078096 | L15/dossiers | 15 | 15060000078095 | 15060000078095 | 1 | PO717460 | ||
| 15060000078099 | L15/dossiers | 15 | 15060000078098 | 15060000078098 | 1 | PO717460 | ||
| 15060000078102 | L15/dossiers | 15 | 15060000078101 | 15060000078101 | 1 | PO717460 | ||
| 15060000078105 | L15/dossiers | 15 | 15060000078104 | 15060000078104 | 1 | PO717460 | ||
| 15060000078108 | L15/dossiers | 15 | 15060000078107 | 15060000078107 | 1 | PO717460 | ||
| 15060000078111 | L15/dossiers | 15 | 15060000078110 | 15060000078110 | 1 | PO717460 | ||
| 15060000078114 | L15/dossiers | 15 | 15060000078113 | 15060000078113 | 1 | PO717460 | ||
| 15060000078117 | L15/dossiers | 15 | 15060000078116 | 15060000078116 | 1 | PO717460 | ||
| 15060000078120 | L15/dossiers | 15 | 15060000078119 | 15060000078119 | 1 | PO717460 | ||
| 15060000078123 | L15/dossiers | 15 | 15060000078122 | 15060000078122 | 1 | PO717460 | ||
| 15060000078126 | L15/dossiers | 15 | 15060000078125 | 15060000078125 | 1 | PO717460 | ||
| 15060000078128 | L15/dossiers | 15 | 15060000078127 | 15060000078127 | 1 | PO717460 | ||
| 15060000078132 | L15/dossiers | 15 | 15060000078131 | 15060000078131 | 1 | PO717460 | ||
| 15060000078135 | L15/dossiers | 15 | 15060000078134 | 15060000078134 | 1 | PO717460 | ||
| 15060000078137 | L15/dossiers | 15 | 15060000078136 | 15060000078136 | 1 | PO717460 | ||
| 15060000078140 | L15/dossiers | 15 | 15060000078139 | 15060000078139 | 1 | PO717460 | ||
| 15060000078143 | L15/dossiers | 15 | 15060000078142 | 15060000078142 | 1 | PO717460 | ||
| 15060000078146 | L15/dossiers | 15 | 15060000078145 | 15060000078145 | 1 | PO717460 | ||
| 15060000078148 | L15/dossiers | 15 | 15060000078147 | 15060000078147 | 1 | PO717460 | ||
| 15060000078151 | L15/dossiers | 15 | 15060000078150 | 15060000078150 | 1 | PO717460 | ||
| 15060000078153 | L15/dossiers | 15 | 15060000078152 | 15060000078152 | 1 | PO717460 | ||
| 15060000078156 | L15/dossiers | 15 | 15060000078155 | 15060000078155 | 1 | PO717460 | ||
| 15060000078159 | L15/dossiers | 15 | 15060000078158 | 15060000078158 | 1 | PO717460 | ||
| 15060000078162 | L15/dossiers | 15 | 15060000078161 | 15060000078161 | 1 | PO717460 | ||
| 15060000078165 | L15/dossiers | 15 | 15060000078164 | 15060000078164 | 1 | PO717460 | ||
| 15060000078168 | L15/dossiers | 15 | 15060000078167 | 15060000078167 | 1 | PO717460 | ||
| 15060000078171 | L15/dossiers | 15 | 15060000078170 | 15060000078170 | 1 | PO717460 | ||
| 15060000078174 | L15/dossiers | 15 | 15060000078173 | 15060000078173 | 1 | PO717460 | ||
| 15060000078177 | L15/dossiers | 15 | 15060000078176 | 15060000078176 | 1 | PO717460 | ||
| 15060000078180 | L15/dossiers | 15 | 15060000078179 | 15060000078179 | 1 | PO717460 | ||
| 15060000078182 | L15/dossiers | 15 | 15060000078181 | 15060000078181 | 1 | PO717460 | ||
| 15060000078185 | L15/dossiers | 15 | 15060000078184 | 15060000078184 | 1 | PO717460 | ||
| 15060000078188 | L15/dossiers | 15 | 15060000078187 | 15060000078187 | 1 | PO717460 | ||
| 15060000078191 | L15/dossiers | 15 | 15060000078190 | 15060000078190 | 1 | PO717460 | ||
| 15060000078194 | L15/dossiers | 15 | 15060000078193 | 15060000078193 | 1 | PO717460 | ||
| 15060000078197 | L15/dossiers | 15 | 15060000078196 | 15060000078196 | 1 | PO717460 | ||
| 15060000078200 | L15/dossiers | 15 | 15060000078199 | 15060000078199 | 1 | PO717460 | ||
| 15060000078203 | L15/dossiers | 15 | 15060000078202 | 15060000078202 | 1 | PO717460 | ||
| 15060000078206 | L15/dossiers | 15 | 15060000078205 | 15060000078205 | 1 | PO717460 | ||
| 15060000078209 | L15/dossiers | 15 | 15060000078208 | 15060000078208 | 1 | PO717460 | ||
| 15060000078212 | L15/dossiers | 15 | 15060000078211 | 15060000078211 | 1 | PO717460 | ||
| 15060000078215 | L15/dossiers | 15 | 15060000078214 | 15060000078214 | 1 | PO717460 | ||
| 15060000078218 | L15/dossiers | 15 | 15060000078217 | 15060000078217 | 1 | PO717460 | ||
| 15060000078221 | L15/dossiers | 15 | 15060000078220 | 15060000078220 | 1 | PO717460 | ||
| 15060000078224 | L15/dossiers | 15 | 15060000078223 | 15060000078223 | 1 | PO717460 | ||
| 15060000078227 | L15/dossiers | 15 | 15060000078226 | 15060000078226 | 1 | PO717460 |