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 |
|---|---|---|---|---|---|---|---|---|
| 17060000079698 | L17/dossiers | 17 | 17060000079696 | 17060000079696 | 2 | PO211495 | ||
| 17060000079700 | L17/dossiers | 17 | 17060000079699 | 17060000079699 | 1 | PA703514 | rapporteur | |
| 17060000079701 | L17/dossiers | 17 | 17060000079699 | 17060000079699 | 2 | PO211494 | ||
| 17060000079703 | L17/dossiers | 17 | 17060000079702 | 17060000079702 | 1 | PA827894 | rapporteur | |
| 17060000079704 | L17/dossiers | 17 | 17060000079702 | 17060000079702 | 2 | PO211493 | ||
| 17060000079706 | L17/dossiers | 17 | 17060000079705 | 17060000079705 | 1 | PA715745 | rapporteur | |
| 17060000079707 | L17/dossiers | 17 | 17060000079705 | 17060000079705 | 2 | PO516753 | ||
| 17060000079709 | L17/dossiers | 17 | 17060000079708 | 17060000079708 | 1 | PA760322 | rapporteur | |
| 17060000079710 | L17/dossiers | 17 | 17060000079708 | 17060000079708 | 2 | PO516753 | ||
| 17060000079712 | L17/dossiers | 17 | 17060000079711 | 17060000079711 | 1 | PA827988 | rapporteur | |
| 17060000079713 | L17/dossiers | 17 | 17060000079711 | 17060000079711 | 2 | PO211495 | ||
| 17060000079715 | L17/dossiers | 17 | 17060000079714 | 17060000079714 | 1 | PA736205 | rapporteur | |
| 17060000079716 | L17/dossiers | 17 | 17060000079714 | 17060000079714 | 2 | PA703538 | rapporteur | |
| 17060000079717 | L17/dossiers | 17 | 17060000079714 | 17060000079714 | 3 | PO211495 | ||
| 17060000079719 | L17/dossiers | 17 | 17060000079718 | 17060000079718 | 1 | PA827960 | rapporteur | |
| 17060000079720 | L17/dossiers | 17 | 17060000079718 | 17060000079718 | 2 | PO516753 | ||
| 17060000079722 | L17/dossiers | 17 | 17060000079721 | 17060000079721 | 1 | PA703520 | rapporteur | |
| 17060000079723 | L17/dossiers | 17 | 17060000079721 | 17060000079721 | 2 | PO862694 | ||
| 17060000079725 | L17/dossiers | 17 | 17060000079724 | 17060000079724 | 1 | PA775248 | rapporteur | |
| 17060000079726 | L17/dossiers | 17 | 17060000079724 | 17060000079724 | 2 | PO211495 | ||
| 17060000079728 | L17/dossiers | 17 | 17060000079727 | 17060000079727 | 1 | PA775250 | rapporteur | |
| 17060000079729 | L17/dossiers | 17 | 17060000079727 | 17060000079727 | 2 | PA775226 | rapporteur | |
| 17060000079730 | L17/dossiers | 17 | 17060000079727 | 17060000079727 | 3 | PO211490 | ||
| 17060000079732 | L17/dossiers | 17 | 17060000079731 | 17060000079731 | 1 | PA828002 | rapporteur | |
| 17060000079733 | L17/dossiers | 17 | 17060000079731 | 17060000079731 | 2 | PO211493 | ||
| 17060000079735 | L17/dossiers | 17 | 17060000079734 | 17060000079734 | 1 | PA703510 | rapporteur | |
| 17060000079736 | L17/dossiers | 17 | 17060000079734 | 17060000079734 | 2 | PO211495 | ||
| 17060000079738 | L17/dossiers | 17 | 17060000079737 | 17060000079737 | 1 | PA736190 | rapporteur | |
| 17060000079739 | L17/dossiers | 17 | 17060000079737 | 17060000079737 | 2 | PO211493 | ||
| 17060000079741 | L17/dossiers | 17 | 17060000079740 | 17060000079740 | 1 | PA767418 | rapporteur | |
| 17060000079742 | L17/dossiers | 17 | 17060000079740 | 17060000079740 | 2 | PO516754 | ||
| 17060000079744 | L17/dossiers | 17 | 17060000079743 | 17060000079743 | 1 | PA721130 | rapporteur | |
| 17060000079745 | L17/dossiers | 17 | 17060000079743 | 17060000079743 | 2 | PO516753 | ||
| 17060000079747 | L17/dossiers | 17 | 17060000079746 | 17060000079746 | 1 | PA703532 | rapporteur | |
| 17060000079748 | L17/dossiers | 17 | 17060000079746 | 17060000079746 | 2 | PO211490 | ||
| 17060000079750 | L17/dossiers | 17 | 17060000079749 | 17060000079749 | 1 | PA827896 | rapporteur | |
| 17060000079751 | L17/dossiers | 17 | 17060000079749 | 17060000079749 | 2 | PO516754 | ||
| 17060000079753 | L17/dossiers | 17 | 17060000079752 | 17060000079752 | 1 | PA736193 | rapporteur | |
| 17060000079754 | L17/dossiers | 17 | 17060000079752 | 17060000079752 | 2 | PO516753 | ||
| 17060000079756 | L17/dossiers | 17 | 17060000079755 | 17060000079755 | 1 | PA736231 | rapporteur | |
| 17060000079757 | L17/dossiers | 17 | 17060000079755 | 17060000079755 | 2 | PA788192 | rapporteur | |
| 17060000079758 | L17/dossiers | 17 | 17060000079755 | 17060000079755 | 3 | PO516753 | ||
| 17060000079760 | L17/dossiers | 17 | 17060000079759 | 17060000079759 | 1 | PA703494 | rapporteur | |
| 17060000079761 | L17/dossiers | 17 | 17060000079759 | 17060000079759 | 2 | PO211495 | ||
| 17060000079763 | L17/dossiers | 17 | 17060000079762 | 17060000079762 | 1 | PA775178 | rapporteur | |
| 17060000079764 | L17/dossiers | 17 | 17060000079762 | 17060000079762 | 2 | PA736229 | rapporteur | |
| 17060000079765 | L17/dossiers | 17 | 17060000079762 | 17060000079762 | 3 | PO211495 | ||
| 17060000079767 | L17/dossiers | 17 | 17060000079766 | 17060000079766 | 1 | PA775178 | rapporteur | |
| 17060000079768 | L17/dossiers | 17 | 17060000079766 | 17060000079766 | 2 | PO865272 | ||
| 17060000079770 | L17/dossiers | 17 | 17060000079769 | 17060000079769 | 1 | PA758716 | rapporteur |