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 |
|---|---|---|---|---|---|---|---|---|
| 17060000079616 | L17/dossiers | 17 | 17060000079615 | 17060000079615 | 1 | PO78718 | ||
| 17060000079618 | L17/dossiers | 17 | 17060000079617 | 17060000079617 | 1 | PO78718 | ||
| 17060000079620 | L17/dossiers | 17 | 17060000079619 | 17060000079619 | 1 | PO78718 | ||
| 17060000079622 | L17/dossiers | 17 | 17060000079621 | 17060000079621 | 1 | PO78718 | ||
| 17060000079624 | L17/dossiers | 17 | 17060000079623 | 17060000079623 | 1 | PO78718 | ||
| 17060000079626 | L17/dossiers | 17 | 17060000079625 | 17060000079625 | 1 | PO78718 | ||
| 17060000079628 | L17/dossiers | 17 | 17060000079627 | 17060000079627 | 1 | PO78718 | ||
| 17060000079630 | L17/dossiers | 17 | 17060000079629 | 17060000079629 | 1 | PO78718 | ||
| 17060000079632 | L17/dossiers | 17 | 17060000079631 | 17060000079631 | 1 | PO78718 | ||
| 17060000079634 | L17/dossiers | 17 | 17060000079633 | 17060000079633 | 1 | PO78718 | ||
| 17060000079636 | L17/dossiers | 17 | 17060000079635 | 17060000079635 | 1 | PO78718 | ||
| 17060000079638 | L17/dossiers | 17 | 17060000079637 | 17060000079637 | 1 | PO78718 | ||
| 17060000079640 | L17/dossiers | 17 | 17060000079639 | 17060000079639 | 1 | PO78718 | ||
| 17060000079642 | L17/dossiers | 17 | 17060000079641 | 17060000079641 | 1 | PO78718 | ||
| 17060000079644 | L17/dossiers | 17 | 17060000079643 | 17060000079643 | 1 | PO78718 | ||
| 17060000079646 | L17/dossiers | 17 | 17060000079645 | 17060000079645 | 1 | PO78718 | ||
| 17060000079648 | L17/dossiers | 17 | 17060000079647 | 17060000079647 | 1 | PO78718 | ||
| 17060000079650 | L17/dossiers | 17 | 17060000079649 | 17060000079649 | 1 | PA703511 | rapporteur | |
| 17060000079651 | L17/dossiers | 17 | 17060000079649 | 17060000079649 | 2 | PO211490 | ||
| 17060000079653 | L17/dossiers | 17 | 17060000079652 | 17060000079652 | 1 | PA775176 | rapporteur | |
| 17060000079654 | L17/dossiers | 17 | 17060000079652 | 17060000079652 | 2 | PO211494 | ||
| 17060000079656 | L17/dossiers | 17 | 17060000079655 | 17060000079655 | 1 | PA721742 | rapporteur | |
| 17060000079657 | L17/dossiers | 17 | 17060000079655 | 17060000079655 | 2 | PO211495 | ||
| 17060000079659 | L17/dossiers | 17 | 17060000079658 | 17060000079658 | 1 | PA429858 | rapporteur | |
| 17060000079660 | L17/dossiers | 17 | 17060000079658 | 17060000079658 | 2 | PA610850 | rapporteur | |
| 17060000079661 | L17/dossiers | 17 | 17060000079658 | 17060000079658 | 3 | PO211495 | ||
| 17060000079663 | L17/dossiers | 17 | 17060000079662 | 17060000079662 | 1 | PA736238 | rapporteur | |
| 17060000079664 | L17/dossiers | 17 | 17060000079662 | 17060000079662 | 2 | PO211494 | ||
| 17060000079666 | L17/dossiers | 17 | 17060000079665 | 17060000079665 | 1 | PA711156 | rapporteur | |
| 17060000079667 | L17/dossiers | 17 | 17060000079665 | 17060000079665 | 2 | PO211494 | ||
| 17060000079669 | L17/dossiers | 17 | 17060000079668 | 17060000079668 | 1 | PA703494 | rapporteur | |
| 17060000079670 | L17/dossiers | 17 | 17060000079668 | 17060000079668 | 2 | PO211495 | ||
| 17060000079672 | L17/dossiers | 17 | 17060000079671 | 17060000079671 | 1 | PA757676 | rapporteur | |
| 17060000079673 | L17/dossiers | 17 | 17060000079671 | 17060000079671 | 2 | PO211493 | ||
| 17060000079675 | L17/dossiers | 17 | 17060000079674 | 17060000079674 | 1 | PA758716 | rapporteur | |
| 17060000079676 | L17/dossiers | 17 | 17060000079674 | 17060000079674 | 2 | PA429875 | rapporteur | |
| 17060000079677 | L17/dossiers | 17 | 17060000079674 | 17060000079674 | 3 | PO838126 | ||
| 17060000079679 | L17/dossiers | 17 | 17060000079678 | 17060000079678 | 1 | PA736239 | rapporteur | |
| 17060000079680 | L17/dossiers | 17 | 17060000079678 | 17060000079678 | 2 | PO211493 | ||
| 17060000079682 | L17/dossiers | 17 | 17060000079681 | 17060000079681 | 1 | PA827996 | rapporteur | |
| 17060000079683 | L17/dossiers | 17 | 17060000079681 | 17060000079681 | 2 | PO211493 | ||
| 17060000079685 | L17/dossiers | 17 | 17060000079684 | 17060000079684 | 1 | PA736205 | rapporteur | |
| 17060000079686 | L17/dossiers | 17 | 17060000079684 | 17060000079684 | 2 | PO211495 | ||
| 17060000079688 | L17/dossiers | 17 | 17060000079687 | 17060000079687 | 1 | PA775248 | rapporteur | |
| 17060000079689 | L17/dossiers | 17 | 17060000079687 | 17060000079687 | 2 | PO211495 | ||
| 17060000079691 | L17/dossiers | 17 | 17060000079690 | 17060000079690 | 1 | PA708632 | rapporteur | |
| 17060000079692 | L17/dossiers | 17 | 17060000079690 | 17060000079690 | 2 | PO211495 | ||
| 17060000079694 | L17/dossiers | 17 | 17060000079693 | 17060000079693 | 1 | PA828016 | rapporteur | |
| 17060000079695 | L17/dossiers | 17 | 17060000079693 | 17060000079693 | 2 | PO211495 | ||
| 17060000079697 | L17/dossiers | 17 | 17060000079696 | 17060000079696 | 1 | PA827990 | rapporteur |