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 |
|---|---|---|---|---|---|---|---|---|
| 17060000104153 | L17/dossiers | 17 | 17060000104152 | 17060000104152 | 1 | PO838901 | ||
| 17060000104156 | L17/dossiers | 17 | 17060000104155 | 17060000104155 | 1 | PO838901 | ||
| 17060000104159 | L17/dossiers | 17 | 17060000104158 | 17060000104158 | 1 | PA368 | auteur | |
| 17060000104165 | L17/dossiers | 17 | 17060000104164 | 17060000104164 | 1 | PO838901 | ||
| 17060000104168 | L17/dossiers | 17 | 17060000104167 | 17060000104167 | 1 | PO838901 | ||
| 17060000104171 | L17/dossiers | 17 | 17060000104170 | 17060000104170 | 1 | PA368 | auteur | |
| 17060000104176 | L17/dossiers | 17 | 17060000104175 | 17060000104175 | 1 | PA410 | auteur | |
| 17060000104180 | L17/dossiers | 17 | 17060000104179 | 17060000104179 | 1 | PA410 | auteur | |
| 17060000104184 | L17/dossiers | 17 | 17060000104183 | 17060000104183 | 1 | PA410 | auteur | |
| 17060000104188 | L17/dossiers | 17 | 17060000104187 | 17060000104187 | 1 | PA410 | auteur | |
| 17060000104192 | L17/dossiers | 17 | 17060000104191 | 17060000104191 | 1 | PO838901 | ||
| 17060000104195 | L17/dossiers | 17 | 17060000104194 | 17060000104194 | 1 | PO838901 | ||
| 17060000104198 | L17/dossiers | 17 | 17060000104197 | 17060000104197 | 1 | PO838901 | ||
| 17060000104201 | L17/dossiers | 17 | 17060000104200 | 17060000104200 | 1 | PO838901 | ||
| 17060000104204 | L17/dossiers | 17 | 17060000104203 | 17060000104203 | 1 | PO838901 | ||
| 17060000104207 | L17/dossiers | 17 | 17060000104206 | 17060000104206 | 1 | PO838901 | ||
| 17060000104210 | L17/dossiers | 17 | 17060000104209 | 17060000104209 | 1 | PA410 | auteur | |
| 17060000104214 | L17/dossiers | 17 | 17060000104213 | 17060000104213 | 1 | PO838901 | ||
| 17060000104217 | L17/dossiers | 17 | 17060000104216 | 17060000104216 | 1 | PO838901 | ||
| 17060000104220 | L17/dossiers | 17 | 17060000104219 | 17060000104219 | 1 | PO838901 | ||
| 17060000104223 | L17/dossiers | 17 | 17060000104222 | 17060000104222 | 1 | PO838901 | ||
| 17060000104226 | L17/dossiers | 17 | 17060000104225 | 17060000104225 | 1 | PA410 | auteur | |
| 17060000104230 | L17/dossiers | 17 | 17060000104229 | 17060000104229 | 1 | PO838901 | ||
| 17060000104233 | L17/dossiers | 17 | 17060000104232 | 17060000104232 | 1 | PA410 | auteur | |
| 17060000104236 | L17/dossiers | 17 | 17060000104235 | 17060000104235 | 1 | PA410 | auteur | |
| 17060000104240 | L17/dossiers | 17 | 17060000104239 | 17060000104239 | 1 | PO838901 | ||
| 17060000104243 | L17/dossiers | 17 | 17060000104242 | 17060000104242 | 1 | PO838901 | ||
| 17060000104247 | L17/dossiers | 17 | 17060000104246 | 17060000104246 | 1 | PA410 | auteur | |
| 17060000104254 | L17/dossiers | 17 | 17060000104253 | 17060000104253 | 1 | PO838901 | ||
| 17060000104259 | L17/dossiers | 17 | 17060000104258 | 17060000104258 | 1 | PO838901 | ||
| 17060000104262 | L17/dossiers | 17 | 17060000104261 | 17060000104261 | 1 | PO838901 | ||
| 17060000104265 | L17/dossiers | 17 | 17060000104264 | 17060000104264 | 1 | PA410 | auteur | |
| 17060000104270 | L17/dossiers | 17 | 17060000104269 | 17060000104269 | 1 | PO838901 | ||
| 17060000104273 | L17/dossiers | 17 | 17060000104272 | 17060000104272 | 1 | PO838901 | ||
| 17060000104276 | L17/dossiers | 17 | 17060000104275 | 17060000104275 | 1 | PO838901 | ||
| 17060000104280 | L17/dossiers | 17 | 17060000104279 | 17060000104279 | 1 | PO838901 | ||
| 17060000104283 | L17/dossiers | 17 | 17060000104282 | 17060000104282 | 1 | PO838901 | ||
| 17060000104290 | L17/dossiers | 17 | 17060000104289 | 17060000104289 | 1 | PA410 | auteur | |
| 17060000104294 | L17/dossiers | 17 | 17060000104293 | 17060000104293 | 1 | PA410 | auteur | |
| 17060000104299 | L17/dossiers | 17 | 17060000104298 | 17060000104298 | 1 | PA643210 | auteur | |
| 17060000104311 | L17/dossiers | 17 | 17060000104310 | 17060000104310 | 1 | PA643210 | auteur | |
| 17060000104318 | L17/dossiers | 17 | 17060000104317 | 17060000104317 | 1 | PO838901 | ||
| 17060000104321 | L17/dossiers | 17 | 17060000104320 | 17060000104320 | 1 | PA643210 | auteur | |
| 17060000104326 | L17/dossiers | 17 | 17060000104325 | 17060000104325 | 1 | PO838901 | ||
| 17060000104329 | L17/dossiers | 17 | 17060000104328 | 17060000104328 | 1 | PO838901 | ||
| 17060000104332 | L17/dossiers | 17 | 17060000104331 | 17060000104331 | 1 | PA643210 | auteur | |
| 17060000104337 | L17/dossiers | 17 | 17060000104336 | 17060000104336 | 1 | PO838901 | ||
| 17060000104341 | L17/dossiers | 17 | 17060000104340 | 17060000104340 | 1 | PO838901 | ||
| 17060000104344 | L17/dossiers | 17 | 17060000104343 | 17060000104343 | 1 | PO838901 | ||
| 17060000104347 | L17/dossiers | 17 | 17060000104346 | 17060000104346 | 1 | PA643210 | auteur |