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 |
|---|---|---|---|---|---|---|---|---|
| 16060000089402 | L16/dossiers | 16 | 16060000089399 | 16060000089399 | 3 | PO415287 | ||
| 16060000089404 | L16/dossiers | 16 | 16060000089403 | 16060000089403 | 1 | PA794538 | rapporteur | |
| 16060000089405 | L16/dossiers | 16 | 16060000089403 | 16060000089403 | 2 | PA795326 | rapporteur | |
| 16060000089406 | L16/dossiers | 16 | 16060000089403 | 16060000089403 | 3 | PO59047 | ||
| 16060000089408 | L16/dossiers | 16 | 16060000089407 | 16060000089407 | 1 | PA795876 | rapporteur | |
| 16060000089409 | L16/dossiers | 16 | 16060000089407 | 16060000089407 | 2 | PA721062 | rapporteur | |
| 16060000089410 | L16/dossiers | 16 | 16060000089407 | 16060000089407 | 3 | PO675659 | ||
| 16060000089412 | L16/dossiers | 16 | 16060000089411 | 16060000089411 | 1 | PA340643 | rapporteur | |
| 16060000089413 | L16/dossiers | 16 | 16060000089411 | 16060000089411 | 2 | PA794914 | rapporteur | |
| 16060000089414 | L16/dossiers | 16 | 16060000089411 | 16060000089411 | 3 | PO744127 | ||
| 16060000089416 | L16/dossiers | 16 | 16060000089415 | 16060000089415 | 1 | PA721004 | rapporteur | |
| 16060000089417 | L16/dossiers | 16 | 16060000089415 | 16060000089415 | 2 | PO201115 | ||
| 16060000089419 | L16/dossiers | 16 | 16060000089418 | 16060000089418 | 1 | PA335054 | rapporteur | |
| 16060000089420 | L16/dossiers | 16 | 16060000089418 | 16060000089418 | 2 | PO415287 | ||
| 16060000089422 | L16/dossiers | 16 | 16060000089421 | 16060000089421 | 1 | PA719472 | rapporteur | |
| 16060000089423 | L16/dossiers | 16 | 16060000089421 | 16060000089421 | 2 | PO59048 | ||
| 16060000089425 | L16/dossiers | 16 | 16060000089424 | 16060000089424 | 1 | PA774958 | rapporteur | |
| 16060000089426 | L16/dossiers | 16 | 16060000089424 | 16060000089424 | 2 | PA304086 | rapporteur | |
| 16060000089427 | L16/dossiers | 16 | 16060000089424 | 16060000089424 | 3 | PO273589 | ||
| 16060000089429 | L16/dossiers | 16 | 16060000089428 | 16060000089428 | 1 | PA1993 | rapporteur | |
| 16060000089430 | L16/dossiers | 16 | 16060000089428 | 16060000089428 | 2 | PA774958 | rapporteur | |
| 16060000089431 | L16/dossiers | 16 | 16060000089428 | 16060000089428 | 3 | PO273589 | ||
| 16060000089433 | L16/dossiers | 16 | 16060000089432 | 16060000089432 | 1 | PA720728 | rapporteur | |
| 16060000089434 | L16/dossiers | 16 | 16060000089432 | 16060000089432 | 2 | PA605745 | rapporteur | |
| 16060000089435 | L16/dossiers | 16 | 16060000089432 | 16060000089432 | 3 | PO59048 | ||
| 16060000089437 | L16/dossiers | 16 | 16060000089436 | 16060000089436 | 1 | PA794846 | rapporteur | |
| 16060000089438 | L16/dossiers | 16 | 16060000089436 | 16060000089436 | 2 | PA340343 | rapporteur | |
| 16060000089439 | L16/dossiers | 16 | 16060000089436 | 16060000089436 | 3 | PO804431 | ||
| 16060000089441 | L16/dossiers | 16 | 16060000089440 | 16060000089440 | 1 | PA719404 | rapporteur | |
| 16060000089442 | L16/dossiers | 16 | 16060000089440 | 16060000089440 | 2 | PO744127 | ||
| 16060000089444 | L16/dossiers | 16 | 16060000089443 | 16060000089443 | 1 | PA795884 | rapporteur | |
| 16060000089445 | L16/dossiers | 16 | 16060000089443 | 16060000089443 | 2 | PA1567 | rapporteur | |
| 16060000089446 | L16/dossiers | 16 | 16060000089443 | 16060000089443 | 3 | PO804107 | ||
| 16060000089448 | L16/dossiers | 16 | 16060000089447 | 16060000089447 | 1 | PA719032 | rapporteur | |
| 16060000089449 | L16/dossiers | 16 | 16060000089447 | 16060000089447 | 2 | PO304272 | ||
| 16060000089451 | L16/dossiers | 16 | 16060000089450 | 16060000089450 | 1 | PA721426 | rapporteur | |
| 16060000089452 | L16/dossiers | 16 | 16060000089450 | 16060000089450 | 2 | PO201269 | ||
| 16060000089454 | L16/dossiers | 16 | 16060000089453 | 16060000089453 | 1 | PA720560 | rapporteur | |
| 16060000089455 | L16/dossiers | 16 | 16060000089453 | 16060000089453 | 2 | PO804431 | ||
| 16060000089457 | L16/dossiers | 16 | 16060000089456 | 16060000089456 | 1 | PA794146 | rapporteur | |
| 16060000089458 | L16/dossiers | 16 | 16060000089456 | 16060000089456 | 2 | PA719882 | rapporteur | |
| 16060000089459 | L16/dossiers | 16 | 16060000089456 | 16060000089456 | 3 | PO821566 | ||
| 16060000089461 | L16/dossiers | 16 | 16060000089460 | 16060000089460 | 1 | PA721482 | rapporteur | |
| 16060000089462 | L16/dossiers | 16 | 16060000089460 | 16060000089460 | 2 | PO744127 | ||
| 16060000089464 | L16/dossiers | 16 | 16060000089463 | 16060000089463 | 1 | PA718710 | rapporteur | |
| 16060000089465 | L16/dossiers | 16 | 16060000089463 | 16060000089463 | 2 | PA793872 | rapporteur | |
| 16060000089466 | L16/dossiers | 16 | 16060000089463 | 16060000089463 | 3 | PO415287 | ||
| 16060000089468 | L16/dossiers | 16 | 16060000089467 | 16060000089467 | 1 | PA721150 | rapporteur | |
| 16060000089469 | L16/dossiers | 16 | 16060000089467 | 16060000089467 | 2 | PA335054 | rapporteur | |
| 16060000089470 | L16/dossiers | 16 | 16060000089467 | 16060000089467 | 3 | PO415287 |