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 |
|---|---|---|---|---|---|---|---|---|
| 15060000115173 | L15/dossiers | 15 | 15060000115172 | 15060000115172 | 1 | PO717460 | ||
| 15060000115177 | L15/dossiers | 15 | 15060000115176 | 15060000115176 | 1 | PO717460 | ||
| 15060000115179 | L15/dossiers | 15 | 15060000115178 | 15060000115178 | 1 | PO717460 | ||
| 15060000115182 | L15/dossiers | 15 | 15060000115181 | 15060000115181 | 1 | PO717460 | ||
| 15060000115184 | L15/dossiers | 15 | 15060000115183 | 15060000115183 | 1 | PO717460 | ||
| 15060000115186 | L15/dossiers | 15 | 15060000115185 | 15060000115185 | 1 | PO717460 | ||
| 15060000115189 | L15/dossiers | 15 | 15060000115188 | 15060000115188 | 1 | PO717460 | ||
| 15060000115195 | L15/dossiers | 15 | 15060000115194 | 15060000115194 | 1 | PO717460 | ||
| 15060000115198 | L15/dossiers | 15 | 15060000115197 | 15060000115197 | 1 | PO717460 | ||
| 15060000115202 | L15/dossiers | 15 | 15060000115201 | 15060000115201 | 1 | PO717460 | ||
| 15060000115207 | L15/dossiers | 15 | 15060000115206 | 15060000115206 | 1 | PO717460 | ||
| 15060000115210 | L15/dossiers | 15 | 15060000115209 | 15060000115209 | 1 | PO717460 | ||
| 15060000115212 | L15/dossiers | 15 | 15060000115211 | 15060000115211 | 1 | PO717460 | ||
| 15060000115215 | L15/dossiers | 15 | 15060000115214 | 15060000115214 | 1 | PO717460 | ||
| 15060000115219 | L15/dossiers | 15 | 15060000115218 | 15060000115218 | 1 | PO717460 | ||
| 15060000115225 | L15/dossiers | 15 | 15060000115224 | 15060000115224 | 1 | PO717460 | ||
| 15060000115227 | L15/dossiers | 15 | 15060000115226 | 15060000115226 | 1 | PO717460 | ||
| 15060000115232 | L15/dossiers | 15 | 15060000115231 | 15060000115231 | 1 | PO717460 | ||
| 15060000115235 | L15/dossiers | 15 | 15060000115234 | 15060000115234 | 1 | PO717460 | ||
| 15060000115238 | L15/dossiers | 15 | 15060000115237 | 15060000115237 | 1 | PO717460 | ||
| 15060000115240 | L15/dossiers | 15 | 15060000115239 | 15060000115239 | 1 | PO717460 | ||
| 15060000115243 | L15/dossiers | 15 | 15060000115242 | 15060000115242 | 1 | PO717460 | ||
| 15060000115246 | L15/dossiers | 15 | 15060000115245 | 15060000115245 | 1 | PO717460 | ||
| 15060000115248 | L15/dossiers | 15 | 15060000115247 | 15060000115247 | 1 | PO717460 | ||
| 15060000115251 | L15/dossiers | 15 | 15060000115250 | 15060000115250 | 1 | PO717460 | ||
| 15060000115254 | L15/dossiers | 15 | 15060000115253 | 15060000115253 | 1 | PO717460 | ||
| 15060000115257 | L15/dossiers | 15 | 15060000115256 | 15060000115256 | 1 | PO717460 | ||
| 15060000115260 | L15/dossiers | 15 | 15060000115259 | 15060000115259 | 1 | PO717460 | ||
| 15060000115263 | L15/dossiers | 15 | 15060000115262 | 15060000115262 | 1 | PO717460 | ||
| 15060000115265 | L15/dossiers | 15 | 15060000115264 | 15060000115264 | 1 | PO717460 | ||
| 15060000115268 | L15/dossiers | 15 | 15060000115267 | 15060000115267 | 1 | PO717460 | ||
| 15060000115272 | L15/dossiers | 15 | 15060000115271 | 15060000115271 | 1 | PO717460 | ||
| 15060000115275 | L15/dossiers | 15 | 15060000115274 | 15060000115274 | 1 | PO717460 | ||
| 15060000115277 | L15/dossiers | 15 | 15060000115276 | 15060000115276 | 1 | PO717460 | ||
| 15060000115280 | L15/dossiers | 15 | 15060000115279 | 15060000115279 | 1 | PO717460 | ||
| 15060000115282 | L15/dossiers | 15 | 15060000115281 | 15060000115281 | 1 | PO717460 | ||
| 15060000115286 | L15/dossiers | 15 | 15060000115285 | 15060000115285 | 1 | PO717460 | ||
| 15060000115289 | L15/dossiers | 15 | 15060000115288 | 15060000115288 | 1 | PO717460 | ||
| 15060000115299 | L15/dossiers | 15 | 15060000115298 | 15060000115298 | 1 | PO717460 | ||
| 15060000115302 | L15/dossiers | 15 | 15060000115301 | 15060000115301 | 1 | PO717460 | ||
| 15060000115305 | L15/dossiers | 15 | 15060000115304 | 15060000115304 | 1 | PO717460 | ||
| 15060000115308 | L15/dossiers | 15 | 15060000115307 | 15060000115307 | 1 | PO717460 | ||
| 15060000115311 | L15/dossiers | 15 | 15060000115310 | 15060000115310 | 1 | PO717460 | ||
| 15060000115314 | L15/dossiers | 15 | 15060000115313 | 15060000115313 | 1 | PO717460 | ||
| 15060000115317 | L15/dossiers | 15 | 15060000115316 | 15060000115316 | 1 | PO717460 | ||
| 15060000115320 | L15/dossiers | 15 | 15060000115319 | 15060000115319 | 1 | PO717460 | ||
| 15060000115323 | L15/dossiers | 15 | 15060000115322 | 15060000115322 | 1 | PO717460 | ||
| 15060000115326 | L15/dossiers | 15 | 15060000115325 | 15060000115325 | 1 | PO717460 | ||
| 15060000115330 | L15/dossiers | 15 | 15060000115329 | 15060000115329 | 1 | PO717460 | ||
| 15060000115332 | L15/dossiers | 15 | 15060000115331 | 15060000115331 | 1 | PO717460 |