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 |
|---|---|---|---|---|---|---|---|---|
| 17060000003075 | L17/dossiers | 17 | 17060000003074 | 17060000003074 | 1 | PO644420 | ||
| 17060000003078 | L17/dossiers | 17 | 17060000003077 | 17060000003077 | 1 | PO644420 | ||
| 17060000003081 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 1 | PA1886 | auteur | |
| 17060000003236 | L17/dossiers | 17 | 17060000003235 | 17060000003235 | 1 | PO644420 | ||
| 17060000003239 | L17/dossiers | 17 | 17060000003238 | 17060000003238 | 1 | PO644420 | ||
| 17060000003242 | L17/dossiers | 17 | 17060000003241 | 17060000003241 | 1 | PO644420 | ||
| 17060000003245 | L17/dossiers | 17 | 17060000003244 | 17060000003244 | 1 | PO644420 | ||
| 17060000003248 | L17/dossiers | 17 | 17060000003247 | 17060000003247 | 1 | PO644420 | ||
| 17060000003251 | L17/dossiers | 17 | 17060000003250 | 17060000003250 | 1 | PA605922 | auteur | |
| 17060000003271 | L17/dossiers | 17 | 17060000003270 | 17060000003270 | 1 | PO644420 | ||
| 17060000003274 | L17/dossiers | 17 | 17060000003273 | 17060000003273 | 1 | PO644420 | ||
| 17060000003277 | L17/dossiers | 17 | 17060000003276 | 17060000003276 | 1 | PO644420 | ||
| 17060000003280 | L17/dossiers | 17 | 17060000003279 | 17060000003279 | 1 | PO644420 | ||
| 17060000003283 | L17/dossiers | 17 | 17060000003282 | 17060000003282 | 1 | PO644420 | ||
| 17060000003286 | L17/dossiers | 17 | 17060000003285 | 17060000003285 | 1 | PO644420 | ||
| 17060000003289 | L17/dossiers | 17 | 17060000003288 | 17060000003288 | 1 | PO644420 | ||
| 17060000003292 | L17/dossiers | 17 | 17060000003291 | 17060000003291 | 1 | PO644420 | ||
| 17060000003295 | L17/dossiers | 17 | 17060000003294 | 17060000003294 | 1 | PO644420 | ||
| 17060000003298 | L17/dossiers | 17 | 17060000003297 | 17060000003297 | 1 | PO644420 | ||
| 17060000003301 | L17/dossiers | 17 | 17060000003300 | 17060000003300 | 1 | PA330357 | rapporteur | |
| 17060000003302 | L17/dossiers | 17 | 17060000003300 | 17060000003300 | 2 | PO59051 | ||
| 17060000003305 | L17/dossiers | 17 | 17060000003304 | 17060000003304 | 1 | PA605922 | rapporteur | |
| 17060000003306 | L17/dossiers | 17 | 17060000003304 | 17060000003304 | 2 | PO419610 | ||
| 17060000003309 | L17/dossiers | 17 | 17060000003308 | 17060000003308 | 1 | PA333335 | rapporteur | |
| 17060000003310 | L17/dossiers | 17 | 17060000003308 | 17060000003308 | 2 | PO59051 | ||
| 17060000003313 | L17/dossiers | 17 | 17060000003312 | 17060000003312 | 1 | PO717460 | ||
| 17060000003316 | L17/dossiers | 17 | 17060000003315 | 17060000003315 | 1 | PO717460 | ||
| 17060000003319 | L17/dossiers | 17 | 17060000003318 | 17060000003318 | 1 | PO717460 | ||
| 17060000003322 | L17/dossiers | 17 | 17060000003321 | 17060000003321 | 1 | PO717460 | ||
| 17060000003325 | L17/dossiers | 17 | 17060000003324 | 17060000003324 | 1 | PO717460 | ||
| 17060000003328 | L17/dossiers | 17 | 17060000003327 | 17060000003327 | 1 | PO717460 | ||
| 17060000003331 | L17/dossiers | 17 | 17060000003330 | 17060000003330 | 1 | PO717460 | ||
| 17060000003334 | L17/dossiers | 17 | 17060000003333 | 17060000003333 | 1 | PO717460 | ||
| 17060000003337 | L17/dossiers | 17 | 17060000003336 | 17060000003336 | 1 | PO717460 | ||
| 17060000003340 | L17/dossiers | 17 | 17060000003339 | 17060000003339 | 1 | PO717460 | ||
| 17060000003343 | L17/dossiers | 17 | 17060000003342 | 17060000003342 | 1 | PO717460 | ||
| 17060000003346 | L17/dossiers | 17 | 17060000003345 | 17060000003345 | 1 | PO717460 | ||
| 17060000003349 | L17/dossiers | 17 | 17060000003348 | 17060000003348 | 1 | PO717460 | ||
| 17060000003352 | L17/dossiers | 17 | 17060000003351 | 17060000003351 | 1 | PO717460 | ||
| 17060000003355 | L17/dossiers | 17 | 17060000003354 | 17060000003354 | 1 | PO717460 | ||
| 17060000003358 | L17/dossiers | 17 | 17060000003357 | 17060000003357 | 1 | PO717460 | ||
| 17060000003361 | L17/dossiers | 17 | 17060000003360 | 17060000003360 | 1 | PO717460 | ||
| 17060000003364 | L17/dossiers | 17 | 17060000003363 | 17060000003363 | 1 | PO717460 | ||
| 17060000003367 | L17/dossiers | 17 | 17060000003366 | 17060000003366 | 1 | PO717460 | ||
| 17060000003370 | L17/dossiers | 17 | 17060000003369 | 17060000003369 | 1 | PO717460 | ||
| 17060000003373 | L17/dossiers | 17 | 17060000003372 | 17060000003372 | 1 | PO717460 | ||
| 17060000003376 | L17/dossiers | 17 | 17060000003375 | 17060000003375 | 1 | PO717460 | ||
| 17060000003379 | L17/dossiers | 17 | 17060000003378 | 17060000003378 | 1 | PO717460 | ||
| 17060000003382 | L17/dossiers | 17 | 17060000003381 | 17060000003381 | 1 | PO717460 | ||
| 17060000003385 | L17/dossiers | 17 | 17060000003384 | 17060000003384 | 1 | PO717460 |