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 |
|---|---|---|---|---|---|---|---|---|
| 17060000081705 | L17/dossiers | 17 | 17060000081704 | 17060000081704 | 1 | PO78718 | ||
| 17060000081707 | L17/dossiers | 17 | 17060000081706 | 17060000081706 | 1 | PO78718 | ||
| 17060000081709 | L17/dossiers | 17 | 17060000081708 | 17060000081708 | 1 | PO78718 | ||
| 17060000081711 | L17/dossiers | 17 | 17060000081710 | 17060000081710 | 1 | PO78718 | ||
| 17060000081713 | L17/dossiers | 17 | 17060000081712 | 17060000081712 | 1 | PO78718 | ||
| 17060000081715 | L17/dossiers | 17 | 17060000081714 | 17060000081714 | 1 | PO78718 | ||
| 17060000081717 | L17/dossiers | 17 | 17060000081716 | 17060000081716 | 1 | PO78718 | ||
| 17060000081719 | L17/dossiers | 17 | 17060000081718 | 17060000081718 | 1 | PO78718 | ||
| 17060000081721 | L17/dossiers | 17 | 17060000081720 | 17060000081720 | 1 | PO78718 | ||
| 17060000081723 | L17/dossiers | 17 | 17060000081722 | 17060000081722 | 1 | PO78718 | ||
| 17060000081725 | L17/dossiers | 17 | 17060000081724 | 17060000081724 | 1 | PO78718 | ||
| 17060000081727 | L17/dossiers | 17 | 17060000081726 | 17060000081726 | 1 | PO78718 | ||
| 17060000081729 | L17/dossiers | 17 | 17060000081728 | 17060000081728 | 1 | PO78718 | ||
| 17060000081731 | L17/dossiers | 17 | 17060000081730 | 17060000081730 | 1 | PO78718 | ||
| 17060000081733 | L17/dossiers | 17 | 17060000081732 | 17060000081732 | 1 | PO78718 | ||
| 17060000081735 | L17/dossiers | 17 | 17060000081734 | 17060000081734 | 1 | PO78718 | ||
| 17060000081737 | L17/dossiers | 17 | 17060000081736 | 17060000081736 | 1 | PO78718 | ||
| 17060000081739 | L17/dossiers | 17 | 17060000081738 | 17060000081738 | 1 | PO78718 | ||
| 17060000081741 | L17/dossiers | 17 | 17060000081740 | 17060000081740 | 1 | PO78718 | ||
| 17060000081743 | L17/dossiers | 17 | 17060000081742 | 17060000081742 | 1 | PO78718 | ||
| 17060000081745 | L17/dossiers | 17 | 17060000081744 | 17060000081744 | 1 | PO78718 | ||
| 17060000081747 | L17/dossiers | 17 | 17060000081746 | 17060000081746 | 1 | PO78718 | ||
| 17060000081749 | L17/dossiers | 17 | 17060000081748 | 17060000081748 | 1 | PO78718 | ||
| 17060000081751 | L17/dossiers | 17 | 17060000081750 | 17060000081750 | 1 | PO78718 | ||
| 17060000081753 | L17/dossiers | 17 | 17060000081752 | 17060000081752 | 1 | PO78718 | ||
| 17060000081755 | L17/dossiers | 17 | 17060000081754 | 17060000081754 | 1 | PO78718 | ||
| 17060000081757 | L17/dossiers | 17 | 17060000081756 | 17060000081756 | 1 | PO78718 | ||
| 17060000081759 | L17/dossiers | 17 | 17060000081758 | 17060000081758 | 1 | PO78718 | ||
| 17060000081761 | L17/dossiers | 17 | 17060000081760 | 17060000081760 | 1 | PO78718 | ||
| 17060000081763 | L17/dossiers | 17 | 17060000081762 | 17060000081762 | 1 | PO78718 | ||
| 17060000081765 | L17/dossiers | 17 | 17060000081764 | 17060000081764 | 1 | PO78718 | ||
| 17060000081767 | L17/dossiers | 17 | 17060000081766 | 17060000081766 | 1 | PO78718 | ||
| 17060000081769 | L17/dossiers | 17 | 17060000081768 | 17060000081768 | 1 | PO78718 | ||
| 17060000081771 | L17/dossiers | 17 | 17060000081770 | 17060000081770 | 1 | PO78718 | ||
| 17060000081773 | L17/dossiers | 17 | 17060000081772 | 17060000081772 | 1 | PO78718 | ||
| 17060000081775 | L17/dossiers | 17 | 17060000081774 | 17060000081774 | 1 | PA703510 | rapporteur | |
| 17060000081776 | L17/dossiers | 17 | 17060000081774 | 17060000081774 | 2 | PA610850 | rapporteur | |
| 17060000081777 | L17/dossiers | 17 | 17060000081774 | 17060000081774 | 3 | PO211495 | ||
| 17060000081779 | L17/dossiers | 17 | 17060000081778 | 17060000081778 | 1 | PA429875 | rapporteur | |
| 17060000081780 | L17/dossiers | 17 | 17060000081778 | 17060000081778 | 2 | PO211494 | ||
| 17060000081782 | L17/dossiers | 17 | 17060000081781 | 17060000081781 | 1 | PA415454 | rapporteur | |
| 17060000081783 | L17/dossiers | 17 | 17060000081781 | 17060000081781 | 2 | PO211495 | ||
| 17060000081785 | L17/dossiers | 17 | 17060000081784 | 17060000081784 | 1 | PA736169 | rapporteur | |
| 17060000081786 | L17/dossiers | 17 | 17060000081784 | 17060000081784 | 2 | PA736229 | rapporteur | |
| 17060000081787 | L17/dossiers | 17 | 17060000081784 | 17060000081784 | 3 | PA849528 | rapporteur | |
| 17060000081788 | L17/dossiers | 17 | 17060000081784 | 17060000081784 | 4 | PO211495 | ||
| 17060000081790 | L17/dossiers | 17 | 17060000081789 | 17060000081789 | 1 | PA827954 | rapporteur | |
| 17060000081791 | L17/dossiers | 17 | 17060000081789 | 17060000081789 | 2 | PA736168 | rapporteur | |
| 17060000081792 | L17/dossiers | 17 | 17060000081789 | 17060000081789 | 3 | PO211493 | ||
| 17060000081794 | L17/dossiers | 17 | 17060000081793 | 17060000081793 | 1 | PA708632 | rapporteur |