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 |
|---|---|---|---|---|---|---|---|---|
| 17060000071018 | L17/dossiers | 17 | 17060000071017 | 17060000071017 | 1 | PO838901 | ||
| 17060000071021 | L17/dossiers | 17 | 17060000071020 | 17060000071020 | 1 | PO838901 | ||
| 17060000071024 | L17/dossiers | 17 | 17060000071023 | 17060000071023 | 1 | PO838901 | ||
| 17060000071027 | L17/dossiers | 17 | 17060000071026 | 17060000071026 | 1 | PO838901 | ||
| 17060000071030 | L17/dossiers | 17 | 17060000071029 | 17060000071029 | 1 | PO838901 | ||
| 17060000071033 | L17/dossiers | 17 | 17060000071032 | 17060000071032 | 1 | PO838901 | ||
| 17060000071036 | L17/dossiers | 17 | 17060000071035 | 17060000071035 | 1 | PO838901 | ||
| 17060000071039 | L17/dossiers | 17 | 17060000071038 | 17060000071038 | 1 | PO838901 | ||
| 17060000071042 | L17/dossiers | 17 | 17060000071041 | 17060000071041 | 1 | PO838901 | ||
| 17060000071044 | L17/dossiers | 17 | 17060000071043 | 17060000071043 | 1 | PO838901 | ||
| 17060000071047 | L17/dossiers | 17 | 17060000071046 | 17060000071046 | 1 | PO838901 | ||
| 17060000071051 | L17/dossiers | 17 | 17060000071050 | 17060000071050 | 1 | PO838901 | ||
| 17060000071053 | L17/dossiers | 17 | 17060000071052 | 17060000071052 | 1 | PO838901 | ||
| 17060000071058 | L17/dossiers | 17 | 17060000071057 | 17060000071057 | 1 | PO838901 | ||
| 17060000071060 | L17/dossiers | 17 | 17060000071059 | 17060000071059 | 1 | PO838901 | ||
| 17060000071063 | L17/dossiers | 17 | 17060000071062 | 17060000071062 | 1 | PO838901 | ||
| 17060000071066 | L17/dossiers | 17 | 17060000071065 | 17060000071065 | 1 | PO838901 | ||
| 17060000071068 | L17/dossiers | 17 | 17060000071067 | 17060000071067 | 1 | PO838901 | ||
| 17060000071071 | L17/dossiers | 17 | 17060000071070 | 17060000071070 | 1 | PO838901 | ||
| 17060000071074 | L17/dossiers | 17 | 17060000071073 | 17060000071073 | 1 | PO838901 | ||
| 17060000071077 | L17/dossiers | 17 | 17060000071076 | 17060000071076 | 1 | PO838901 | ||
| 17060000071079 | L17/dossiers | 17 | 17060000071078 | 17060000071078 | 1 | PO838901 | ||
| 17060000071082 | L17/dossiers | 17 | 17060000071081 | 17060000071081 | 1 | PO838901 | ||
| 17060000071084 | L17/dossiers | 17 | 17060000071083 | 17060000071083 | 1 | PO838901 | ||
| 17060000071086 | L17/dossiers | 17 | 17060000071085 | 17060000071085 | 1 | PO838901 | ||
| 17060000071089 | L17/dossiers | 17 | 17060000071088 | 17060000071088 | 1 | PO838901 | ||
| 17060000071092 | L17/dossiers | 17 | 17060000071091 | 17060000071091 | 1 | PO838901 | ||
| 17060000071095 | L17/dossiers | 17 | 17060000071094 | 17060000071094 | 1 | PO838901 | ||
| 17060000071098 | L17/dossiers | 17 | 17060000071097 | 17060000071097 | 1 | PO838901 | ||
| 17060000071101 | L17/dossiers | 17 | 17060000071100 | 17060000071100 | 1 | PO838901 | ||
| 17060000071104 | L17/dossiers | 17 | 17060000071103 | 17060000071103 | 1 | PO838901 | ||
| 17060000071107 | L17/dossiers | 17 | 17060000071106 | 17060000071106 | 1 | PO838901 | ||
| 17060000071110 | L17/dossiers | 17 | 17060000071109 | 17060000071109 | 1 | PO838901 | ||
| 17060000071113 | L17/dossiers | 17 | 17060000071112 | 17060000071112 | 1 | PO838901 | ||
| 17060000071116 | L17/dossiers | 17 | 17060000071115 | 17060000071115 | 1 | PO838901 | ||
| 17060000071119 | L17/dossiers | 17 | 17060000071118 | 17060000071118 | 1 | PO838901 | ||
| 17060000071122 | L17/dossiers | 17 | 17060000071121 | 17060000071121 | 1 | PO838901 | ||
| 17060000071125 | L17/dossiers | 17 | 17060000071124 | 17060000071124 | 1 | PO838901 | ||
| 17060000071128 | L17/dossiers | 17 | 17060000071127 | 17060000071127 | 1 | PO838901 | ||
| 17060000071131 | L17/dossiers | 17 | 17060000071130 | 17060000071130 | 1 | PO838901 | ||
| 17060000071134 | L17/dossiers | 17 | 17060000071133 | 17060000071133 | 1 | PO838901 | ||
| 17060000071137 | L17/dossiers | 17 | 17060000071136 | 17060000071136 | 1 | PO838901 | ||
| 17060000071140 | L17/dossiers | 17 | 17060000071139 | 17060000071139 | 1 | PO838901 | ||
| 17060000071143 | L17/dossiers | 17 | 17060000071142 | 17060000071142 | 1 | PO838901 | ||
| 17060000071146 | L17/dossiers | 17 | 17060000071145 | 17060000071145 | 1 | PO838901 | ||
| 17060000071149 | L17/dossiers | 17 | 17060000071148 | 17060000071148 | 1 | PO838901 | ||
| 17060000071152 | L17/dossiers | 17 | 17060000071151 | 17060000071151 | 1 | PO838901 | ||
| 17060000071155 | L17/dossiers | 17 | 17060000071154 | 17060000071154 | 1 | PO838901 | ||
| 17060000071158 | L17/dossiers | 17 | 17060000071157 | 17060000071157 | 1 | PO838901 | ||
| 17060000071161 | L17/dossiers | 17 | 17060000071160 | 17060000071160 | 1 | PO838901 |