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 |
|---|---|---|---|---|---|---|---|---|
| 17060000070038 | L17/dossiers | 17 | 17060000070037 | 17060000070037 | 1 | PA718850 | auteur | |
| 17060000070056 | L17/dossiers | 17 | 17060000070055 | 17060000070055 | 1 | PA794906 | auteur | |
| 17060000070059 | L17/dossiers | 17 | 17060000070058 | 17060000070058 | 1 | PA719632 | auteur | |
| 17060000070094 | L17/dossiers | 17 | 17060000070093 | 17060000070093 | 1 | PA330240 | auteur | |
| 17060000070113 | L17/dossiers | 17 | 17060000070112 | 17060000070112 | 1 | PA2952 | auteur | |
| 17060000070116 | L17/dossiers | 17 | 17060000070115 | 17060000070115 | 1 | PA2952 | auteur | |
| 17060000070119 | L17/dossiers | 17 | 17060000070118 | 17060000070118 | 1 | PA2952 | auteur | |
| 17060000070122 | L17/dossiers | 17 | 17060000070121 | 17060000070121 | 1 | PA2952 | auteur | |
| 17060000070125 | L17/dossiers | 17 | 17060000070124 | 17060000070124 | 1 | PA2952 | auteur | |
| 17060000070128 | L17/dossiers | 17 | 17060000070127 | 17060000070127 | 1 | PA2952 | auteur | |
| 17060000070131 | L17/dossiers | 17 | 17060000070130 | 17060000070130 | 1 | PA2952 | auteur | |
| 17060000070134 | L17/dossiers | 17 | 17060000070133 | 17060000070133 | 1 | PA720342 | auteur | |
| 17060000070137 | L17/dossiers | 17 | 17060000070136 | 17060000070136 | 1 | PA842187 | auteur | |
| 17060000070210 | L17/dossiers | 17 | 17060000070209 | 17060000070209 | 1 | PA720430 | auteur | |
| 17060000070283 | L17/dossiers | 17 | 17060000070282 | 17060000070282 | 1 | PA793744 | auteur | |
| 17060000070356 | L17/dossiers | 17 | 17060000070355 | 17060000070355 | 1 | PA795228 | auteur | |
| 17060000070429 | L17/dossiers | 17 | 17060000070428 | 17060000070428 | 1 | PA720892 | auteur | |
| 17060000070502 | L17/dossiers | 17 | 17060000070501 | 17060000070501 | 1 | PA796062 | auteur | |
| 17060000070575 | L17/dossiers | 17 | 17060000070574 | 17060000070574 | 1 | PA795046 | auteur | |
| 17060000070621 | L17/dossiers | 17 | 17060000070620 | 17060000070620 | 1 | PA794710 | auteur | |
| 17060000070639 | L17/dossiers | 17 | 17060000070638 | 17060000070638 | 1 | PA793736 | auteur | |
| 17060000070712 | L17/dossiers | 17 | 17060000070711 | 17060000070711 | 1 | PA795164 | auteur | |
| 17060000070785 | L17/dossiers | 17 | 17060000070784 | 17060000070784 | 1 | PA721110 | auteur | |
| 17060000070788 | L17/dossiers | 17 | 17060000070787 | 17060000070787 | 1 | PA841067 | auteur | |
| 17060000070799 | L17/dossiers | 17 | 17060000070798 | 17060000070798 | 1 | PO838901 | ||
| 17060000070802 | L17/dossiers | 17 | 17060000070801 | 17060000070801 | 1 | PO838901 | ||
| 17060000070805 | L17/dossiers | 17 | 17060000070804 | 17060000070804 | 1 | PO838901 | ||
| 17060000070807 | L17/dossiers | 17 | 17060000070806 | 17060000070806 | 1 | PO838901 | ||
| 17060000070810 | L17/dossiers | 17 | 17060000070809 | 17060000070809 | 1 | PO838901 | ||
| 17060000070813 | L17/dossiers | 17 | 17060000070812 | 17060000070812 | 1 | PO838901 | ||
| 17060000070816 | L17/dossiers | 17 | 17060000070815 | 17060000070815 | 1 | PO838901 | ||
| 17060000070819 | L17/dossiers | 17 | 17060000070818 | 17060000070818 | 1 | PO838901 | ||
| 17060000070822 | L17/dossiers | 17 | 17060000070821 | 17060000070821 | 1 | PO838901 | ||
| 17060000070825 | L17/dossiers | 17 | 17060000070824 | 17060000070824 | 1 | PO838901 | ||
| 17060000070828 | L17/dossiers | 17 | 17060000070827 | 17060000070827 | 1 | PO838901 | ||
| 17060000070831 | L17/dossiers | 17 | 17060000070830 | 17060000070830 | 1 | PO838901 | ||
| 17060000070834 | L17/dossiers | 17 | 17060000070833 | 17060000070833 | 1 | PO838901 | ||
| 17060000070837 | L17/dossiers | 17 | 17060000070836 | 17060000070836 | 1 | PO838901 | ||
| 17060000070840 | L17/dossiers | 17 | 17060000070839 | 17060000070839 | 1 | PO838901 | ||
| 17060000070843 | L17/dossiers | 17 | 17060000070842 | 17060000070842 | 1 | PO838901 | ||
| 17060000070846 | L17/dossiers | 17 | 17060000070845 | 17060000070845 | 1 | PO838901 | ||
| 17060000070849 | L17/dossiers | 17 | 17060000070848 | 17060000070848 | 1 | PO838901 | ||
| 17060000070852 | L17/dossiers | 17 | 17060000070851 | 17060000070851 | 1 | PO838901 | ||
| 17060000070855 | L17/dossiers | 17 | 17060000070854 | 17060000070854 | 1 | PO838901 | ||
| 17060000070858 | L17/dossiers | 17 | 17060000070857 | 17060000070857 | 1 | PO838901 | ||
| 17060000070861 | L17/dossiers | 17 | 17060000070860 | 17060000070860 | 1 | PO838901 | ||
| 17060000070864 | L17/dossiers | 17 | 17060000070863 | 17060000070863 | 1 | PO838901 | ||
| 17060000070866 | L17/dossiers | 17 | 17060000070865 | 17060000070865 | 1 | PO838901 | ||
| 17060000070869 | L17/dossiers | 17 | 17060000070868 | 17060000070868 | 1 | PO838901 | ||
| 17060000070872 | L17/dossiers | 17 | 17060000070871 | 17060000070871 | 1 | PO838901 |