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 |
|---|---|---|---|---|---|---|---|---|
| 14060000008417 | L14/dossiers | 14 | 14060000008416 | 14060000008416 | 1 | PA551 | rapporteur | |
| 14060000008418 | L14/dossiers | 14 | 14060000008416 | 14060000008416 | 2 | PO59048 | ||
| 14060000008420 | L14/dossiers | 14 | 14060000008419 | 14060000008419 | 1 | PA563 | auteur | |
| 14060000008423 | L14/dossiers | 14 | 14060000008422 | 14060000008422 | 1 | PA423245 | rapporteur | |
| 14060000008424 | L14/dossiers | 14 | 14060000008422 | 14060000008422 | 2 | PO211493 | ||
| 14060000008426 | L14/dossiers | 14 | 14060000008425 | 14060000008425 | 1 | PA606375 | rapporteur | |
| 14060000008427 | L14/dossiers | 14 | 14060000008425 | 14060000008425 | 2 | PO59046 | ||
| 14060000008429 | L14/dossiers | 14 | 14060000008428 | 14060000008428 | 1 | PO644420 | ||
| 14060000008432 | L14/dossiers | 14 | 14060000008431 | 14060000008431 | 1 | PA606375 | rapporteur | |
| 14060000008433 | L14/dossiers | 14 | 14060000008431 | 14060000008431 | 2 | PO59046 | ||
| 14060000008436 | L14/dossiers | 14 | 14060000008435 | 14060000008435 | 1 | PA335054 | rapporteur | |
| 14060000008437 | L14/dossiers | 14 | 14060000008435 | 14060000008435 | 2 | PO415287 | ||
| 14060000008439 | L14/dossiers | 14 | 14060000008438 | 14060000008438 | 1 | PA1579 | rapporteur | |
| 14060000008440 | L14/dossiers | 14 | 14060000008438 | 14060000008438 | 2 | PO59047 | ||
| 14060000008442 | L14/dossiers | 14 | 14060000008441 | 14060000008441 | 1 | PA608186 | rapporteur | |
| 14060000008443 | L14/dossiers | 14 | 14060000008441 | 14060000008441 | 2 | PO415287 | ||
| 14060000008445 | L14/dossiers | 14 | 14060000008444 | 14060000008444 | 1 | PA2876 | auteur | |
| 14060000008448 | L14/dossiers | 14 | 14060000008447 | 14060000008447 | 1 | PA1152 | auteur | |
| 14060000008468 | L14/dossiers | 14 | 14060000008467 | 14060000008467 | 1 | PA230 | auteur | |
| 14060000008476 | L14/dossiers | 14 | 14060000008475 | 14060000008475 | 1 | PA2056 | rapporteur | |
| 14060000008477 | L14/dossiers | 14 | 14060000008475 | 14060000008475 | 2 | PO211494 | ||
| 14060000008479 | L14/dossiers | 14 | 14060000008478 | 14060000008478 | 1 | PA331594 | rapporteur | |
| 14060000008480 | L14/dossiers | 14 | 14060000008478 | 14060000008478 | 2 | PO59051 | ||
| 14060000008482 | L14/dossiers | 14 | 14060000008481 | 14060000008481 | 1 | PA331594 | rapporteur | |
| 14060000008483 | L14/dossiers | 14 | 14060000008481 | 14060000008481 | 2 | PO59051 | ||
| 14060000008485 | L14/dossiers | 14 | 14060000008484 | 14060000008484 | 1 | PO78718 | ||
| 14060000008487 | L14/dossiers | 14 | 14060000008486 | 14060000008486 | 1 | PA746 | auteur | |
| 14060000008492 | L14/dossiers | 14 | 14060000008491 | 14060000008491 | 1 | PO644420 | ||
| 14060000008495 | L14/dossiers | 14 | 14060000008494 | 14060000008494 | 1 | PA331594 | rapporteur | |
| 14060000008496 | L14/dossiers | 14 | 14060000008494 | 14060000008494 | 2 | PO59051 | ||
| 14060000008499 | L14/dossiers | 14 | 14060000008498 | 14060000008498 | 1 | PA331594 | rapporteur | |
| 14060000008500 | L14/dossiers | 14 | 14060000008498 | 14060000008498 | 2 | PO59051 | ||
| 14060000008503 | L14/dossiers | 14 | 14060000008502 | 14060000008502 | 1 | PA267622 | auteur | |
| 14060000008506 | L14/dossiers | 14 | 14060000008505 | 14060000008505 | 1 | PA610481 | auteur | |
| 14060000008510 | L14/dossiers | 14 | 14060000008509 | 14060000008509 | 1 | PO644420 | ||
| 14060000008513 | L14/dossiers | 14 | 14060000008512 | 14060000008512 | 1 | PO717460 | ||
| 14060000008516 | L14/dossiers | 14 | 14060000008515 | 14060000008515 | 1 | PA720438 | rapporteur | |
| 14060000008517 | L14/dossiers | 14 | 14060000008515 | 14060000008515 | 2 | PO59047 | ||
| 14060000008519 | L14/dossiers | 14 | 14060000008518 | 14060000008518 | 1 | PA382672 | rapporteur | |
| 14060000008520 | L14/dossiers | 14 | 14060000008518 | 14060000008518 | 2 | PO211491 | ||
| 14060000008522 | L14/dossiers | 14 | 14060000008521 | 14060000008521 | 1 | PA267622 | auteur | |
| 14060000008524 | L14/dossiers | 14 | 14060000008523 | 14060000008523 | 1 | PA607761 | rapporteur | |
| 14060000008525 | L14/dossiers | 14 | 14060000008523 | 14060000008523 | 2 | PO419610 | ||
| 14060000008529 | L14/dossiers | 14 | 14060000008528 | 14060000008528 | 1 | PO78718 | ||
| 14060000008531 | L14/dossiers | 14 | 14060000008530 | 14060000008530 | 1 | PA328 | auteur | |
| 14060000008536 | L14/dossiers | 14 | 14060000008535 | 14060000008535 | 1 | PA415485 | rapporteur | |
| 14060000008537 | L14/dossiers | 14 | 14060000008535 | 14060000008535 | 2 | PO516753 | ||
| 14060000008539 | L14/dossiers | 14 | 14060000008538 | 14060000008538 | 1 | PA607761 | rapporteur | |
| 14060000008540 | L14/dossiers | 14 | 14060000008538 | 14060000008538 | 2 | PO419610 | ||
| 14060000008542 | L14/dossiers | 14 | 14060000008541 | 14060000008541 | 1 | PA267762 | auteur |