dossiers.document_auteur
Chemin document.auteurs.auteur · présence : L17 100 %, L16 100 %, L15 100 %, L14 100 %
59 600 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 |
|---|---|---|---|---|---|---|---|---|
| 17060000105115 | L17/dossiers | 17 | 17060000105114 | 17060000105114 | 1 | PO838901 | ||
| 17060000105118 | L17/dossiers | 17 | 17060000105117 | 17060000105117 | 1 | PO838901 | ||
| 17060000105120 | L17/dossiers | 17 | 17060000105119 | 17060000105119 | 1 | PO838901 | ||
| 17060000105122 | L17/dossiers | 17 | 17060000105121 | 17060000105121 | 1 | PO838901 | ||
| 17060000105125 | L17/dossiers | 17 | 17060000105124 | 17060000105124 | 1 | PO838901 | ||
| 17060000105131 | L17/dossiers | 17 | 17060000105130 | 17060000105130 | 1 | PO838901 | ||
| 17060000105133 | L17/dossiers | 17 | 17060000105132 | 17060000105132 | 1 | PO838901 | ||
| 17060000105136 | L17/dossiers | 17 | 17060000105135 | 17060000105135 | 1 | PO838901 | ||
| 17060000105139 | L17/dossiers | 17 | 17060000105138 | 17060000105138 | 1 | PO838901 | ||
| 17060000105144 | L17/dossiers | 17 | 17060000105143 | 17060000105143 | 1 | PO838901 | ||
| 17060000105147 | L17/dossiers | 17 | 17060000105146 | 17060000105146 | 1 | PO838901 | ||
| 17060000105150 | L17/dossiers | 17 | 17060000105149 | 17060000105149 | 1 | PO838901 | ||
| 17060000105153 | L17/dossiers | 17 | 17060000105152 | 17060000105152 | 1 | PO838901 | ||
| 17060000105155 | L17/dossiers | 17 | 17060000105154 | 17060000105154 | 1 | PO838901 | ||
| 17060000105157 | L17/dossiers | 17 | 17060000105156 | 17060000105156 | 1 | PO838901 | ||
| 17060000105159 | L17/dossiers | 17 | 17060000105158 | 17060000105158 | 1 | PO838901 | ||
| 17060000105161 | L17/dossiers | 17 | 17060000105160 | 17060000105160 | 1 | PO838901 | ||
| 17060000105164 | L17/dossiers | 17 | 17060000105163 | 17060000105163 | 1 | PO838901 | ||
| 17060000105167 | L17/dossiers | 17 | 17060000105166 | 17060000105166 | 1 | PO838901 | ||
| 17060000105170 | L17/dossiers | 17 | 17060000105169 | 17060000105169 | 1 | PO838901 | ||
| 17060000105177 | L17/dossiers | 17 | 17060000105176 | 17060000105176 | 1 | PO838901 | ||
| 17060000105180 | L17/dossiers | 17 | 17060000105179 | 17060000105179 | 1 | PO838901 | ||
| 17060000105183 | L17/dossiers | 17 | 17060000105182 | 17060000105182 | 1 | PO838901 | ||
| 17060000105185 | L17/dossiers | 17 | 17060000105184 | 17060000105184 | 1 | PO838901 | ||
| 17060000105189 | L17/dossiers | 17 | 17060000105188 | 17060000105188 | 1 | PO838901 | ||
| 17060000105193 | L17/dossiers | 17 | 17060000105192 | 17060000105192 | 1 | PO838901 | ||
| 17060000105195 | L17/dossiers | 17 | 17060000105194 | 17060000105194 | 1 | PO838901 | ||
| 17060000105197 | L17/dossiers | 17 | 17060000105196 | 17060000105196 | 1 | PO838901 | ||
| 17060000105199 | L17/dossiers | 17 | 17060000105198 | 17060000105198 | 1 | PO838901 | ||
| 17060000105205 | L17/dossiers | 17 | 17060000105204 | 17060000105204 | 1 | PO838901 | ||
| 17060000105209 | L17/dossiers | 17 | 17060000105208 | 17060000105208 | 1 | PO838901 | ||
| 17060000105212 | L17/dossiers | 17 | 17060000105211 | 17060000105211 | 1 | PO838901 | ||
| 17060000105215 | L17/dossiers | 17 | 17060000105214 | 17060000105214 | 1 | PO838901 | ||
| 17060000105218 | L17/dossiers | 17 | 17060000105217 | 17060000105217 | 1 | PO838901 | ||
| 17060000105220 | L17/dossiers | 17 | 17060000105219 | 17060000105219 | 1 | PO838901 | ||
| 17060000105223 | L17/dossiers | 17 | 17060000105222 | 17060000105222 | 1 | PO838901 | ||
| 17060000105226 | L17/dossiers | 17 | 17060000105225 | 17060000105225 | 1 | PO838901 | ||
| 17060000105228 | L17/dossiers | 17 | 17060000105227 | 17060000105227 | 1 | PO838901 | ||
| 17060000105230 | L17/dossiers | 17 | 17060000105229 | 17060000105229 | 1 | PO838901 | ||
| 17060000105233 | L17/dossiers | 17 | 17060000105232 | 17060000105232 | 1 | PO838901 | ||
| 17060000105235 | L17/dossiers | 17 | 17060000105234 | 17060000105234 | 1 | PO838901 | ||
| 17060000105238 | L17/dossiers | 17 | 17060000105237 | 17060000105237 | 1 | PO838901 | ||
| 17060000105240 | L17/dossiers | 17 | 17060000105239 | 17060000105239 | 1 | PA717161 | auteur | |
| 17060000105243 | L17/dossiers | 17 | 17060000105242 | 17060000105242 | 1 | PO78718 | ||
| 17060000105245 | L17/dossiers | 17 | 17060000105244 | 17060000105244 | 1 | PO78718 | ||
| 17060000105247 | L17/dossiers | 17 | 17060000105246 | 17060000105246 | 1 | PO78718 | ||
| 17060000105249 | L17/dossiers | 17 | 17060000105248 | 17060000105248 | 1 | PA304085 | rapporteur | |
| 17060000105250 | L17/dossiers | 17 | 17060000105248 | 17060000105248 | 2 | PO211491 | ||
| 17060000105252 | L17/dossiers | 17 | 17060000105251 | 17060000105251 | 1 | PA304085 | rapporteur | |
| 17060000105253 | L17/dossiers | 17 | 17060000105251 | 17060000105251 | 2 | PO826014 |