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 |
|---|---|---|---|---|---|---|---|---|
| 16060000002302 | L16/dossiers | 16 | 16060000002301 | 16060000002301 | 1 | PO717460 | ||
| 16060000002305 | L16/dossiers | 16 | 16060000002304 | 16060000002304 | 1 | PO717460 | ||
| 16060000002308 | L16/dossiers | 16 | 16060000002307 | 16060000002307 | 1 | PO717460 | ||
| 16060000002311 | L16/dossiers | 16 | 16060000002310 | 16060000002310 | 1 | PO717460 | ||
| 16060000002314 | L16/dossiers | 16 | 16060000002313 | 16060000002313 | 1 | PO717460 | ||
| 16060000002317 | L16/dossiers | 16 | 16060000002316 | 16060000002316 | 1 | PO717460 | ||
| 16060000002320 | L16/dossiers | 16 | 16060000002319 | 16060000002319 | 1 | PO717460 | ||
| 16060000002323 | L16/dossiers | 16 | 16060000002322 | 16060000002322 | 1 | PO717460 | ||
| 16060000002326 | L16/dossiers | 16 | 16060000002325 | 16060000002325 | 1 | PO717460 | ||
| 16060000002329 | L16/dossiers | 16 | 16060000002328 | 16060000002328 | 1 | PO717460 | ||
| 16060000002332 | L16/dossiers | 16 | 16060000002331 | 16060000002331 | 1 | PO717460 | ||
| 16060000002335 | L16/dossiers | 16 | 16060000002334 | 16060000002334 | 1 | PO717460 | ||
| 16060000002338 | L16/dossiers | 16 | 16060000002337 | 16060000002337 | 1 | PO717460 | ||
| 16060000002341 | L16/dossiers | 16 | 16060000002340 | 16060000002340 | 1 | PO717460 | ||
| 16060000002344 | L16/dossiers | 16 | 16060000002343 | 16060000002343 | 1 | PO717460 | ||
| 16060000002347 | L16/dossiers | 16 | 16060000002346 | 16060000002346 | 1 | PO717460 | ||
| 16060000002350 | L16/dossiers | 16 | 16060000002349 | 16060000002349 | 1 | PO717460 | ||
| 16060000002353 | L16/dossiers | 16 | 16060000002352 | 16060000002352 | 1 | PO717460 | ||
| 16060000002356 | L16/dossiers | 16 | 16060000002355 | 16060000002355 | 1 | PO717460 | ||
| 16060000002359 | L16/dossiers | 16 | 16060000002358 | 16060000002358 | 1 | PO717460 | ||
| 16060000002362 | L16/dossiers | 16 | 16060000002361 | 16060000002361 | 1 | PO717460 | ||
| 16060000002365 | L16/dossiers | 16 | 16060000002364 | 16060000002364 | 1 | PO717460 | ||
| 16060000002368 | L16/dossiers | 16 | 16060000002367 | 16060000002367 | 1 | PO717460 | ||
| 16060000002371 | L16/dossiers | 16 | 16060000002370 | 16060000002370 | 1 | PO717460 | ||
| 16060000002374 | L16/dossiers | 16 | 16060000002373 | 16060000002373 | 1 | PO717460 | ||
| 16060000002377 | L16/dossiers | 16 | 16060000002376 | 16060000002376 | 1 | PO717460 | ||
| 16060000002380 | L16/dossiers | 16 | 16060000002379 | 16060000002379 | 1 | PO717460 | ||
| 16060000002383 | L16/dossiers | 16 | 16060000002382 | 16060000002382 | 1 | PO717460 | ||
| 16060000002386 | L16/dossiers | 16 | 16060000002385 | 16060000002385 | 1 | PO717460 | ||
| 16060000002389 | L16/dossiers | 16 | 16060000002388 | 16060000002388 | 1 | PO717460 | ||
| 16060000002392 | L16/dossiers | 16 | 16060000002391 | 16060000002391 | 1 | PO717460 | ||
| 16060000002395 | L16/dossiers | 16 | 16060000002394 | 16060000002394 | 1 | PO717460 | ||
| 16060000002398 | L16/dossiers | 16 | 16060000002397 | 16060000002397 | 1 | PO717460 | ||
| 16060000002401 | L16/dossiers | 16 | 16060000002400 | 16060000002400 | 1 | PO717460 | ||
| 16060000002404 | L16/dossiers | 16 | 16060000002403 | 16060000002403 | 1 | PO717460 | ||
| 16060000002407 | L16/dossiers | 16 | 16060000002406 | 16060000002406 | 1 | PO717460 | ||
| 16060000002410 | L16/dossiers | 16 | 16060000002409 | 16060000002409 | 1 | PO717460 | ||
| 16060000002413 | L16/dossiers | 16 | 16060000002412 | 16060000002412 | 1 | PO717460 | ||
| 16060000002416 | L16/dossiers | 16 | 16060000002415 | 16060000002415 | 1 | PO717460 | ||
| 16060000002419 | L16/dossiers | 16 | 16060000002418 | 16060000002418 | 1 | PO717460 | ||
| 16060000002422 | L16/dossiers | 16 | 16060000002421 | 16060000002421 | 1 | PO717460 | ||
| 16060000002425 | L16/dossiers | 16 | 16060000002424 | 16060000002424 | 1 | PO717460 | ||
| 16060000002428 | L16/dossiers | 16 | 16060000002427 | 16060000002427 | 1 | PO717460 | ||
| 16060000002431 | L16/dossiers | 16 | 16060000002430 | 16060000002430 | 1 | PO717460 | ||
| 16060000002434 | L16/dossiers | 16 | 16060000002433 | 16060000002433 | 1 | PO717460 | ||
| 16060000002437 | L16/dossiers | 16 | 16060000002436 | 16060000002436 | 1 | PO717460 | ||
| 16060000002440 | L16/dossiers | 16 | 16060000002439 | 16060000002439 | 1 | PO717460 | ||
| 16060000002443 | L16/dossiers | 16 | 16060000002442 | 16060000002442 | 1 | PO717460 | ||
| 16060000002446 | L16/dossiers | 16 | 16060000002445 | 16060000002445 | 1 | PO717460 | ||
| 16060000002449 | L16/dossiers | 16 | 16060000002448 | 16060000002448 | 1 | PO717460 |