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 |
|---|---|---|---|---|---|---|---|---|
| 17060000110305 | L17/dossiers | 17 | 17060000110304 | 17060000110304 | 1 | PA775248 | rapporteur | |
| 17060000110306 | L17/dossiers | 17 | 17060000110304 | 17060000110304 | 2 | PO211495 | ||
| 17060000110308 | L17/dossiers | 17 | 17060000110307 | 17060000110307 | 1 | PA775250 | rapporteur | |
| 17060000110309 | L17/dossiers | 17 | 17060000110307 | 17060000110307 | 2 | PA775226 | rapporteur | |
| 17060000110310 | L17/dossiers | 17 | 17060000110307 | 17060000110307 | 3 | PO211490 | ||
| 17060000110312 | L17/dossiers | 17 | 17060000110311 | 17060000110311 | 1 | PA828002 | rapporteur | |
| 17060000110313 | L17/dossiers | 17 | 17060000110311 | 17060000110311 | 2 | PO211493 | ||
| 17060000110315 | L17/dossiers | 17 | 17060000110314 | 17060000110314 | 1 | PA703498 | rapporteur | |
| 17060000110316 | L17/dossiers | 17 | 17060000110314 | 17060000110314 | 2 | PO211493 | ||
| 17060000110318 | L17/dossiers | 17 | 17060000110317 | 17060000110317 | 1 | PA736218 | rapporteur | |
| 17060000110319 | L17/dossiers | 17 | 17060000110317 | 17060000110317 | 2 | PA736224 | rapporteur | |
| 17060000110320 | L17/dossiers | 17 | 17060000110317 | 17060000110317 | 3 | PO864789 | ||
| 17060000110322 | L17/dossiers | 17 | 17060000110321 | 17060000110321 | 1 | PA703510 | rapporteur | |
| 17060000110323 | L17/dossiers | 17 | 17060000110321 | 17060000110321 | 2 | PO211495 | ||
| 17060000110325 | L17/dossiers | 17 | 17060000110324 | 17060000110324 | 1 | PA736190 | rapporteur | |
| 17060000110326 | L17/dossiers | 17 | 17060000110324 | 17060000110324 | 2 | PO211493 | ||
| 17060000110328 | L17/dossiers | 17 | 17060000110327 | 17060000110327 | 1 | PA767418 | rapporteur | |
| 17060000110329 | L17/dossiers | 17 | 17060000110327 | 17060000110327 | 2 | PO516754 | ||
| 17060000110331 | L17/dossiers | 17 | 17060000110330 | 17060000110330 | 1 | PA721130 | rapporteur | |
| 17060000110332 | L17/dossiers | 17 | 17060000110330 | 17060000110330 | 2 | PO516753 | ||
| 17060000110334 | L17/dossiers | 17 | 17060000110333 | 17060000110333 | 1 | PA703532 | rapporteur | |
| 17060000110335 | L17/dossiers | 17 | 17060000110333 | 17060000110333 | 2 | PO211490 | ||
| 17060000110337 | L17/dossiers | 17 | 17060000110336 | 17060000110336 | 1 | PA827896 | rapporteur | |
| 17060000110338 | L17/dossiers | 17 | 17060000110336 | 17060000110336 | 2 | PO516754 | ||
| 17060000110340 | L17/dossiers | 17 | 17060000110339 | 17060000110339 | 1 | PA736193 | rapporteur | |
| 17060000110341 | L17/dossiers | 17 | 17060000110339 | 17060000110339 | 2 | PO516753 | ||
| 17060000110343 | L17/dossiers | 17 | 17060000110342 | 17060000110342 | 1 | PA736231 | rapporteur | |
| 17060000110344 | L17/dossiers | 17 | 17060000110342 | 17060000110342 | 2 | PA788192 | rapporteur | |
| 17060000110345 | L17/dossiers | 17 | 17060000110342 | 17060000110342 | 3 | PO516753 | ||
| 17060000110347 | L17/dossiers | 17 | 17060000110346 | 17060000110346 | 1 | PA703514 | rapporteur | |
| 17060000110348 | L17/dossiers | 17 | 17060000110346 | 17060000110346 | 2 | PA703513 | rapporteur | |
| 17060000110349 | L17/dossiers | 17 | 17060000110346 | 17060000110346 | 3 | PA736227 | rapporteur | |
| 17060000110350 | L17/dossiers | 17 | 17060000110346 | 17060000110346 | 4 | PO765977 | ||
| 17060000110352 | L17/dossiers | 17 | 17060000110351 | 17060000110351 | 1 | PA703494 | rapporteur | |
| 17060000110353 | L17/dossiers | 17 | 17060000110351 | 17060000110351 | 2 | PO211495 | ||
| 17060000110355 | L17/dossiers | 17 | 17060000110354 | 17060000110354 | 1 | PA775178 | rapporteur | |
| 17060000110356 | L17/dossiers | 17 | 17060000110354 | 17060000110354 | 2 | PA736229 | rapporteur | |
| 17060000110357 | L17/dossiers | 17 | 17060000110354 | 17060000110354 | 3 | PO211495 | ||
| 17060000110359 | L17/dossiers | 17 | 17060000110358 | 17060000110358 | 1 | PA827970 | rapporteur | |
| 17060000110360 | L17/dossiers | 17 | 17060000110358 | 17060000110358 | 2 | PO516754 | ||
| 17060000110362 | L17/dossiers | 17 | 17060000110361 | 17060000110361 | 1 | PA736214 | rapporteur | |
| 17060000110363 | L17/dossiers | 17 | 17060000110361 | 17060000110361 | 2 | PO211491 | ||
| 17060000110365 | L17/dossiers | 17 | 17060000110364 | 17060000110364 | 1 | PA703506 | rapporteur | |
| 17060000110366 | L17/dossiers | 17 | 17060000110364 | 17060000110364 | 2 | PO211491 | ||
| 17060000110368 | L17/dossiers | 17 | 17060000110367 | 17060000110367 | 1 | PA267907 | rapporteur | |
| 17060000110369 | L17/dossiers | 17 | 17060000110367 | 17060000110367 | 2 | PO211491 | ||
| 17060000110371 | L17/dossiers | 17 | 17060000110370 | 17060000110370 | 1 | PA775178 | rapporteur | |
| 17060000110372 | L17/dossiers | 17 | 17060000110370 | 17060000110370 | 2 | PO865272 | ||
| 17060000110374 | L17/dossiers | 17 | 17060000110373 | 17060000110373 | 1 | PA758716 | rapporteur | |
| 17060000110375 | L17/dossiers | 17 | 17060000110373 | 17060000110373 | 2 | PO516753 |