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 |
|---|---|---|---|---|---|---|---|---|
| 16060000085287 | L16/dossiers | 16 | 16060000085285 | 16060000085285 | 2 | PO806027 | ||
| 16060000085289 | L16/dossiers | 16 | 16060000085288 | 16060000085288 | 1 | PA267901 | rapporteur | |
| 16060000085290 | L16/dossiers | 16 | 16060000085288 | 16060000085288 | 2 | PO59051 | ||
| 16060000085292 | L16/dossiers | 16 | 16060000085291 | 16060000085291 | 1 | PA795326 | rapporteur | |
| 16060000085293 | L16/dossiers | 16 | 16060000085291 | 16060000085291 | 2 | PO59047 | ||
| 16060000085295 | L16/dossiers | 16 | 16060000085294 | 16060000085294 | 1 | PA793860 | rapporteur | |
| 16060000085296 | L16/dossiers | 16 | 16060000085294 | 16060000085294 | 2 | PO59047 | ||
| 16060000085298 | L16/dossiers | 16 | 16060000085297 | 16060000085297 | 1 | PA720100 | rapporteur | |
| 16060000085299 | L16/dossiers | 16 | 16060000085297 | 16060000085297 | 2 | PO59051 | ||
| 16060000085304 | L16/dossiers | 16 | 16060000085300 | 16060000085300 | 1 | PA719186 | rapporteur | |
| 16060000085305 | L16/dossiers | 16 | 16060000085300 | 16060000085300 | 2 | PO420120 | ||
| 16060000085307 | L16/dossiers | 16 | 16060000085306 | 16060000085306 | 1 | PA712015 | rapporteur | |
| 16060000085308 | L16/dossiers | 16 | 16060000085306 | 16060000085306 | 2 | PO420120 | ||
| 16060000085310 | L16/dossiers | 16 | 16060000085309 | 16060000085309 | 1 | PA719866 | rapporteur | |
| 16060000085311 | L16/dossiers | 16 | 16060000085309 | 16060000085309 | 2 | PO59051 | ||
| 16060000085313 | L16/dossiers | 16 | 16060000085312 | 16060000085312 | 1 | PA330240 | rapporteur | |
| 16060000085314 | L16/dossiers | 16 | 16060000085312 | 16060000085312 | 2 | PO59051 | ||
| 16060000085328 | L16/dossiers | 16 | 16060000085315 | 16060000085315 | 1 | PA793992 | rapporteur | |
| 16060000085329 | L16/dossiers | 16 | 16060000085315 | 16060000085315 | 2 | PA642695 | rapporteur | |
| 16060000085330 | L16/dossiers | 16 | 16060000085315 | 16060000085315 | 3 | PO419610 | ||
| 16060000085332 | L16/dossiers | 16 | 16060000085331 | 16060000085331 | 1 | PA721158 | rapporteur | |
| 16060000085333 | L16/dossiers | 16 | 16060000085331 | 16060000085331 | 2 | PO59051 | ||
| 16060000085335 | L16/dossiers | 16 | 16060000085334 | 16060000085334 | 1 | PA606507 | rapporteur | |
| 16060000085336 | L16/dossiers | 16 | 16060000085334 | 16060000085334 | 2 | PO806155 | ||
| 16060000085338 | L16/dossiers | 16 | 16060000085337 | 16060000085337 | 1 | PA736246 | rapporteur | |
| 16060000085339 | L16/dossiers | 16 | 16060000085337 | 16060000085337 | 2 | PA736209 | rapporteur | |
| 16060000085340 | L16/dossiers | 16 | 16060000085337 | 16060000085337 | 3 | PO273589 | ||
| 16060000085342 | L16/dossiers | 16 | 16060000085341 | 16060000085341 | 1 | PA719472 | rapporteur | |
| 16060000085343 | L16/dossiers | 16 | 16060000085341 | 16060000085341 | 2 | PO806365 | ||
| 16060000085354 | L16/dossiers | 16 | 16060000085344 | 16060000085344 | 1 | PA719472 | rapporteur général | |
| 16060000085355 | L16/dossiers | 16 | 16060000085344 | 16060000085344 | 2 | PO59048 | ||
| 16060000085357 | L16/dossiers | 16 | 16060000085356 | 16060000085356 | 1 | PA794434 | rapporteur | |
| 16060000085358 | L16/dossiers | 16 | 16060000085356 | 16060000085356 | 2 | PO420120 | ||
| 16060000085360 | L16/dossiers | 16 | 16060000085359 | 16060000085359 | 1 | PA794198 | rapporteur | |
| 16060000085361 | L16/dossiers | 16 | 16060000085359 | 16060000085359 | 2 | PO419604 | ||
| 16060000085363 | L16/dossiers | 16 | 16060000085362 | 16060000085362 | 1 | PA720468 | rapporteur | |
| 16060000085364 | L16/dossiers | 16 | 16060000085362 | 16060000085362 | 2 | PO59048 | ||
| 16060000085366 | L16/dossiers | 16 | 16060000085365 | 16060000085365 | 1 | PA795912 | rapporteur | |
| 16060000085367 | L16/dossiers | 16 | 16060000085365 | 16060000085365 | 2 | PO420120 | ||
| 16060000085372 | L16/dossiers | 16 | 16060000085368 | 16060000085368 | 1 | PA795926 | rapporteur | |
| 16060000085373 | L16/dossiers | 16 | 16060000085368 | 16060000085368 | 2 | PO419604 | ||
| 16060000085375 | L16/dossiers | 16 | 16060000085374 | 16060000085374 | 1 | PA720822 | rapporteur | |
| 16060000085376 | L16/dossiers | 16 | 16060000085374 | 16060000085374 | 2 | PO59051 | ||
| 16060000085378 | L16/dossiers | 16 | 16060000085377 | 16060000085377 | 1 | PA794502 | rapporteur | |
| 16060000085379 | L16/dossiers | 16 | 16060000085377 | 16060000085377 | 2 | PO59051 | ||
| 16060000085385 | L16/dossiers | 16 | 16060000085380 | 16060000085380 | 1 | PA720696 | rapporteur | |
| 16060000085386 | L16/dossiers | 16 | 16060000085380 | 16060000085380 | 2 | PA793382 | rapporteur | |
| 16060000085387 | L16/dossiers | 16 | 16060000085380 | 16060000085380 | 3 | PO420120 | ||
| 16060000085392 | L16/dossiers | 16 | 16060000085388 | 16060000085388 | 1 | PA642868 | rapporteur | |
| 16060000085393 | L16/dossiers | 16 | 16060000085388 | 16060000085388 | 2 | PO420120 |