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 |
|---|---|---|---|---|---|---|---|---|
| 17060000071164 | L17/dossiers | 17 | 17060000071163 | 17060000071163 | 1 | PO838901 | ||
| 17060000071167 | L17/dossiers | 17 | 17060000071166 | 17060000071166 | 1 | PO838901 | ||
| 17060000071170 | L17/dossiers | 17 | 17060000071169 | 17060000071169 | 1 | PO838901 | ||
| 17060000071173 | L17/dossiers | 17 | 17060000071172 | 17060000071172 | 1 | PO838901 | ||
| 17060000071176 | L17/dossiers | 17 | 17060000071175 | 17060000071175 | 1 | PO838901 | ||
| 17060000071179 | L17/dossiers | 17 | 17060000071178 | 17060000071178 | 1 | PO838901 | ||
| 17060000071182 | L17/dossiers | 17 | 17060000071181 | 17060000071181 | 1 | PO838901 | ||
| 17060000071185 | L17/dossiers | 17 | 17060000071184 | 17060000071184 | 1 | PO838901 | ||
| 17060000071188 | L17/dossiers | 17 | 17060000071187 | 17060000071187 | 1 | PO838901 | ||
| 17060000071191 | L17/dossiers | 17 | 17060000071190 | 17060000071190 | 1 | PO838901 | ||
| 17060000071194 | L17/dossiers | 17 | 17060000071193 | 17060000071193 | 1 | PO838901 | ||
| 17060000071197 | L17/dossiers | 17 | 17060000071196 | 17060000071196 | 1 | PO838901 | ||
| 17060000071200 | L17/dossiers | 17 | 17060000071199 | 17060000071199 | 1 | PO838901 | ||
| 17060000071203 | L17/dossiers | 17 | 17060000071202 | 17060000071202 | 1 | PO838901 | ||
| 17060000071206 | L17/dossiers | 17 | 17060000071205 | 17060000071205 | 1 | PO838901 | ||
| 17060000071209 | L17/dossiers | 17 | 17060000071208 | 17060000071208 | 1 | PO838901 | ||
| 17060000071212 | L17/dossiers | 17 | 17060000071211 | 17060000071211 | 1 | PO838901 | ||
| 17060000071215 | L17/dossiers | 17 | 17060000071214 | 17060000071214 | 1 | PO838901 | ||
| 17060000071218 | L17/dossiers | 17 | 17060000071217 | 17060000071217 | 1 | PO838901 | ||
| 17060000071221 | L17/dossiers | 17 | 17060000071220 | 17060000071220 | 1 | PO838901 | ||
| 17060000071224 | L17/dossiers | 17 | 17060000071223 | 17060000071223 | 1 | PO838901 | ||
| 17060000071227 | L17/dossiers | 17 | 17060000071226 | 17060000071226 | 1 | PO838901 | ||
| 17060000071230 | L17/dossiers | 17 | 17060000071229 | 17060000071229 | 1 | PO838901 | ||
| 17060000071233 | L17/dossiers | 17 | 17060000071232 | 17060000071232 | 1 | PO838901 | ||
| 17060000071235 | L17/dossiers | 17 | 17060000071234 | 17060000071234 | 1 | PO838901 | ||
| 17060000071238 | L17/dossiers | 17 | 17060000071237 | 17060000071237 | 1 | PO838901 | ||
| 17060000071241 | L17/dossiers | 17 | 17060000071240 | 17060000071240 | 1 | PO838901 | ||
| 17060000071244 | L17/dossiers | 17 | 17060000071243 | 17060000071243 | 1 | PO838901 | ||
| 17060000071247 | L17/dossiers | 17 | 17060000071246 | 17060000071246 | 1 | PO838901 | ||
| 17060000071250 | L17/dossiers | 17 | 17060000071249 | 17060000071249 | 1 | PO838901 | ||
| 17060000071253 | L17/dossiers | 17 | 17060000071252 | 17060000071252 | 1 | PO838901 | ||
| 17060000071256 | L17/dossiers | 17 | 17060000071255 | 17060000071255 | 1 | PO838901 | ||
| 17060000071259 | L17/dossiers | 17 | 17060000071258 | 17060000071258 | 1 | PO838901 | ||
| 17060000071262 | L17/dossiers | 17 | 17060000071261 | 17060000071261 | 1 | PO838901 | ||
| 17060000071265 | L17/dossiers | 17 | 17060000071264 | 17060000071264 | 1 | PO838901 | ||
| 17060000071268 | L17/dossiers | 17 | 17060000071267 | 17060000071267 | 1 | PO838901 | ||
| 17060000071271 | L17/dossiers | 17 | 17060000071270 | 17060000071270 | 1 | PO838901 | ||
| 17060000071274 | L17/dossiers | 17 | 17060000071273 | 17060000071273 | 1 | PO838901 | ||
| 17060000071277 | L17/dossiers | 17 | 17060000071276 | 17060000071276 | 1 | PO838901 | ||
| 17060000071280 | L17/dossiers | 17 | 17060000071279 | 17060000071279 | 1 | PO838901 | ||
| 17060000071283 | L17/dossiers | 17 | 17060000071282 | 17060000071282 | 1 | PO838901 | ||
| 17060000071286 | L17/dossiers | 17 | 17060000071285 | 17060000071285 | 1 | PO838901 | ||
| 17060000071289 | L17/dossiers | 17 | 17060000071288 | 17060000071288 | 1 | PO838901 | ||
| 17060000071292 | L17/dossiers | 17 | 17060000071291 | 17060000071291 | 1 | PO838901 | ||
| 17060000071295 | L17/dossiers | 17 | 17060000071294 | 17060000071294 | 1 | PO838901 | ||
| 17060000071298 | L17/dossiers | 17 | 17060000071297 | 17060000071297 | 1 | PO838901 | ||
| 17060000071301 | L17/dossiers | 17 | 17060000071300 | 17060000071300 | 1 | PO838901 | ||
| 17060000071304 | L17/dossiers | 17 | 17060000071303 | 17060000071303 | 1 | PO838901 | ||
| 17060000071307 | L17/dossiers | 17 | 17060000071306 | 17060000071306 | 1 | PO838901 | ||
| 17060000071310 | L17/dossiers | 17 | 17060000071309 | 17060000071309 | 1 | PO838901 |