dossiers.document_auteur
Chemin document.auteurs.auteur · présence : L17 100 %, L16 100 %, L15 100 %, L14 100 %
59 594 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 |
|---|---|---|---|---|---|---|---|---|
| 17060000079516 | L17/dossiers | 17 | 17060000079515 | 17060000079515 | 1 | PO78718 | ||
| 17060000079518 | L17/dossiers | 17 | 17060000079517 | 17060000079517 | 1 | PO78718 | ||
| 17060000079520 | L17/dossiers | 17 | 17060000079519 | 17060000079519 | 1 | PO78718 | ||
| 17060000079522 | L17/dossiers | 17 | 17060000079521 | 17060000079521 | 1 | PO78718 | ||
| 17060000079524 | L17/dossiers | 17 | 17060000079523 | 17060000079523 | 1 | PO78718 | ||
| 17060000079526 | L17/dossiers | 17 | 17060000079525 | 17060000079525 | 1 | PO78718 | ||
| 17060000079528 | L17/dossiers | 17 | 17060000079527 | 17060000079527 | 1 | PO78718 | ||
| 17060000079530 | L17/dossiers | 17 | 17060000079529 | 17060000079529 | 1 | PO78718 | ||
| 17060000079532 | L17/dossiers | 17 | 17060000079531 | 17060000079531 | 1 | PO78718 | ||
| 17060000079534 | L17/dossiers | 17 | 17060000079533 | 17060000079533 | 1 | PO78718 | ||
| 17060000079536 | L17/dossiers | 17 | 17060000079535 | 17060000079535 | 1 | PO78718 | ||
| 17060000079538 | L17/dossiers | 17 | 17060000079537 | 17060000079537 | 1 | PO78718 | ||
| 17060000079540 | L17/dossiers | 17 | 17060000079539 | 17060000079539 | 1 | PO78718 | ||
| 17060000079542 | L17/dossiers | 17 | 17060000079541 | 17060000079541 | 1 | PO78718 | ||
| 17060000079544 | L17/dossiers | 17 | 17060000079543 | 17060000079543 | 1 | PO78718 | ||
| 17060000079546 | L17/dossiers | 17 | 17060000079545 | 17060000079545 | 1 | PO78718 | ||
| 17060000079548 | L17/dossiers | 17 | 17060000079547 | 17060000079547 | 1 | PO78718 | ||
| 17060000079550 | L17/dossiers | 17 | 17060000079549 | 17060000079549 | 1 | PO78718 | ||
| 17060000079552 | L17/dossiers | 17 | 17060000079551 | 17060000079551 | 1 | PO78718 | ||
| 17060000079554 | L17/dossiers | 17 | 17060000079553 | 17060000079553 | 1 | PO78718 | ||
| 17060000079556 | L17/dossiers | 17 | 17060000079555 | 17060000079555 | 1 | PO78718 | ||
| 17060000079558 | L17/dossiers | 17 | 17060000079557 | 17060000079557 | 1 | PO78718 | ||
| 17060000079560 | L17/dossiers | 17 | 17060000079559 | 17060000079559 | 1 | PO78718 | ||
| 17060000079562 | L17/dossiers | 17 | 17060000079561 | 17060000079561 | 1 | PO78718 | ||
| 17060000079564 | L17/dossiers | 17 | 17060000079563 | 17060000079563 | 1 | PO78718 | ||
| 17060000079566 | L17/dossiers | 17 | 17060000079565 | 17060000079565 | 1 | PO78718 | ||
| 17060000079568 | L17/dossiers | 17 | 17060000079567 | 17060000079567 | 1 | PO78718 | ||
| 17060000079570 | L17/dossiers | 17 | 17060000079569 | 17060000079569 | 1 | PO78718 | ||
| 17060000079572 | L17/dossiers | 17 | 17060000079571 | 17060000079571 | 1 | PO78718 | ||
| 17060000079574 | L17/dossiers | 17 | 17060000079573 | 17060000079573 | 1 | PO78718 | ||
| 17060000079576 | L17/dossiers | 17 | 17060000079575 | 17060000079575 | 1 | PO78718 | ||
| 17060000079578 | L17/dossiers | 17 | 17060000079577 | 17060000079577 | 1 | PO78718 | ||
| 17060000079580 | L17/dossiers | 17 | 17060000079579 | 17060000079579 | 1 | PO78718 | ||
| 17060000079582 | L17/dossiers | 17 | 17060000079581 | 17060000079581 | 1 | PO78718 | ||
| 17060000079584 | L17/dossiers | 17 | 17060000079583 | 17060000079583 | 1 | PO78718 | ||
| 17060000079586 | L17/dossiers | 17 | 17060000079585 | 17060000079585 | 1 | PO78718 | ||
| 17060000079588 | L17/dossiers | 17 | 17060000079587 | 17060000079587 | 1 | PO78718 | ||
| 17060000079590 | L17/dossiers | 17 | 17060000079589 | 17060000079589 | 1 | PO78718 | ||
| 17060000079592 | L17/dossiers | 17 | 17060000079591 | 17060000079591 | 1 | PO78718 | ||
| 17060000079594 | L17/dossiers | 17 | 17060000079593 | 17060000079593 | 1 | PO78718 | ||
| 17060000079596 | L17/dossiers | 17 | 17060000079595 | 17060000079595 | 1 | PO78718 | ||
| 17060000079598 | L17/dossiers | 17 | 17060000079597 | 17060000079597 | 1 | PO78718 | ||
| 17060000079600 | L17/dossiers | 17 | 17060000079599 | 17060000079599 | 1 | PO78718 | ||
| 17060000079602 | L17/dossiers | 17 | 17060000079601 | 17060000079601 | 1 | PO78718 | ||
| 17060000079604 | L17/dossiers | 17 | 17060000079603 | 17060000079603 | 1 | PO78718 | ||
| 17060000079606 | L17/dossiers | 17 | 17060000079605 | 17060000079605 | 1 | PO78718 | ||
| 17060000079608 | L17/dossiers | 17 | 17060000079607 | 17060000079607 | 1 | PO78718 | ||
| 17060000079610 | L17/dossiers | 17 | 17060000079609 | 17060000079609 | 1 | PO78718 | ||
| 17060000079612 | L17/dossiers | 17 | 17060000079611 | 17060000079611 | 1 | PO78718 | ||
| 17060000079614 | L17/dossiers | 17 | 17060000079613 | 17060000079613 | 1 | PO78718 |