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 |
|---|---|---|---|---|---|---|---|---|
| 14060000019334 | L14/dossiers | 14 | 14060000019333 | 14060000019333 | 1 | PA609726 | auteur | |
| 14060000019337 | L14/dossiers | 14 | 14060000019336 | 14060000019336 | 1 | PA563 | auteur | |
| 14060000019339 | L14/dossiers | 14 | 14060000019338 | 14060000019338 | 1 | PA642836 | rapporteur | |
| 14060000019340 | L14/dossiers | 14 | 14060000019338 | 14060000019338 | 2 | PA1012 | rapporteur | |
| 14060000019341 | L14/dossiers | 14 | 14060000019338 | 14060000019338 | 3 | PO59046 | ||
| 14060000019343 | L14/dossiers | 14 | 14060000019342 | 14060000019342 | 1 | PA267785 | auteur | |
| 14060000019360 | L14/dossiers | 14 | 14060000019359 | 14060000019359 | 1 | PA2161 | rapporteur pour avis | |
| 14060000019361 | L14/dossiers | 14 | 14060000019359 | 14060000019359 | 2 | PO211495 | ||
| 14060000019363 | L14/dossiers | 14 | 14060000019362 | 14060000019362 | 1 | PA429847 | rapporteur | |
| 14060000019364 | L14/dossiers | 14 | 14060000019362 | 14060000019362 | 2 | PO310693 | ||
| 14060000019366 | L14/dossiers | 14 | 14060000019365 | 14060000019365 | 1 | PA707206 | rapporteur | |
| 14060000019367 | L14/dossiers | 14 | 14060000019365 | 14060000019365 | 2 | PO211493 | ||
| 14060000019369 | L14/dossiers | 14 | 14060000019368 | 14060000019368 | 1 | PA707206 | rapporteur | |
| 14060000019370 | L14/dossiers | 14 | 14060000019368 | 14060000019368 | 2 | PO716002 | ||
| 14060000019375 | L14/dossiers | 14 | 14060000019371 | 14060000019371 | 1 | PA336421 | rapporteur | |
| 14060000019376 | L14/dossiers | 14 | 14060000019371 | 14060000019371 | 2 | PO420120 | ||
| 14060000019378 | L14/dossiers | 14 | 14060000019377 | 14060000019377 | 1 | PA336421 | rapporteur | |
| 14060000019379 | L14/dossiers | 14 | 14060000019377 | 14060000019377 | 2 | PO420120 | ||
| 14060000019384 | L14/dossiers | 14 | 14060000019380 | 14060000019380 | 1 | PA336421 | rapporteur | |
| 14060000019385 | L14/dossiers | 14 | 14060000019380 | 14060000019380 | 2 | PO420120 | ||
| 14060000019387 | L14/dossiers | 14 | 14060000019386 | 14060000019386 | 1 | PA610075 | rapporteur pour avis | |
| 14060000019388 | L14/dossiers | 14 | 14060000019386 | 14060000019386 | 2 | PO59051 | ||
| 14060000019390 | L14/dossiers | 14 | 14060000019389 | 14060000019389 | 1 | PO78718 | ||
| 14060000019392 | L14/dossiers | 14 | 14060000019391 | 14060000019391 | 1 | PA336421 | rapporteur | |
| 14060000019393 | L14/dossiers | 14 | 14060000019391 | 14060000019391 | 2 | PO420120 | ||
| 14060000019396 | L14/dossiers | 14 | 14060000019395 | 14060000019395 | 1 | PO644420 | ||
| 14060000019399 | L14/dossiers | 14 | 14060000019398 | 14060000019398 | 1 | PO78718 | ||
| 14060000019401 | L14/dossiers | 14 | 14060000019400 | 14060000019400 | 1 | PA336421 | rapporteur | |
| 14060000019402 | L14/dossiers | 14 | 14060000019400 | 14060000019400 | 2 | PO420120 | ||
| 14060000019405 | L14/dossiers | 14 | 14060000019404 | 14060000019404 | 1 | PO644420 | ||
| 14060000019408 | L14/dossiers | 14 | 14060000019407 | 14060000019407 | 1 | PA335319 | rapporteur | |
| 14060000019409 | L14/dossiers | 14 | 14060000019407 | 14060000019407 | 2 | PA2952 | rapporteur | |
| 14060000019410 | L14/dossiers | 14 | 14060000019407 | 14060000019407 | 3 | PO59051 | ||
| 14060000019412 | L14/dossiers | 14 | 14060000019411 | 14060000019411 | 1 | PA267622 | auteur | |
| 14060000019416 | L14/dossiers | 14 | 14060000019415 | 14060000019415 | 1 | PO78718 | ||
| 14060000019418 | L14/dossiers | 14 | 14060000019417 | 14060000019417 | 1 | PA335543 | rapporteur | |
| 14060000019419 | L14/dossiers | 14 | 14060000019417 | 14060000019417 | 2 | PO59047 | ||
| 14060000019421 | L14/dossiers | 14 | 14060000019420 | 14060000019420 | 1 | PA1142 | rapporteur | |
| 14060000019422 | L14/dossiers | 14 | 14060000019420 | 14060000019420 | 2 | PO211494 | ||
| 14060000019424 | L14/dossiers | 14 | 14060000019423 | 14060000019423 | 1 | PA267622 | auteur | |
| 14060000019426 | L14/dossiers | 14 | 14060000019425 | 14060000019425 | 1 | PA337504 | rapporteur | |
| 14060000019427 | L14/dossiers | 14 | 14060000019425 | 14060000019425 | 2 | PA1445 | rapporteur | |
| 14060000019428 | L14/dossiers | 14 | 14060000019425 | 14060000019425 | 3 | PO675659 | ||
| 14060000019430 | L14/dossiers | 14 | 14060000019429 | 14060000019429 | 1 | PA328 | auteur | |
| 14060000019436 | L14/dossiers | 14 | 14060000019435 | 14060000019435 | 1 | PO644420 | ||
| 14060000019439 | L14/dossiers | 14 | 14060000019438 | 14060000019438 | 1 | PO78718 | ||
| 14060000019441 | L14/dossiers | 14 | 14060000019440 | 14060000019440 | 1 | PO78718 | ||
| 14060000019443 | L14/dossiers | 14 | 14060000019442 | 14060000019442 | 1 | PA1886 | auteur | |
| 14060000019731 | L14/dossiers | 14 | 14060000019730 | 14060000019730 | 1 | PA609590 | rapporteur pour avis | |
| 14060000019732 | L14/dossiers | 14 | 14060000019730 | 14060000019730 | 2 | PO59048 |