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 |
|---|---|---|---|---|---|---|---|---|
| 16060000082098 | L16/dossiers | 16 | 16060000082097 | 16060000082097 | 1 | PA717161 | auteur | |
| 16060000082101 | L16/dossiers | 16 | 16060000082100 | 16060000082100 | 1 | PA717161 | auteur | |
| 16060000082104 | L16/dossiers | 16 | 16060000082103 | 16060000082103 | 1 | PA717161 | auteur | |
| 16060000082109 | L16/dossiers | 16 | 16060000082108 | 16060000082108 | 1 | PA717161 | auteur | |
| 16060000082113 | L16/dossiers | 16 | 16060000082112 | 16060000082112 | 1 | PA717161 | auteur | |
| 16060000082117 | L16/dossiers | 16 | 16060000082116 | 16060000082116 | 1 | PA717161 | auteur | |
| 16060000082123 | L16/dossiers | 16 | 16060000082122 | 16060000082122 | 1 | PA717161 | auteur | |
| 16060000082132 | L16/dossiers | 16 | 16060000082131 | 16060000082131 | 1 | PA717161 | auteur | |
| 16060000082148 | L16/dossiers | 16 | 16060000082147 | 16060000082147 | 1 | PA717161 | auteur | |
| 16060000082179 | L16/dossiers | 16 | 16060000082178 | 16060000082178 | 1 | PO791932 | ||
| 16060000082182 | L16/dossiers | 16 | 16060000082181 | 16060000082181 | 1 | PO791932 | ||
| 16060000082185 | L16/dossiers | 16 | 16060000082184 | 16060000082184 | 1 | PO791932 | ||
| 16060000082188 | L16/dossiers | 16 | 16060000082187 | 16060000082187 | 1 | PO791932 | ||
| 16060000082192 | L16/dossiers | 16 | 16060000082191 | 16060000082191 | 1 | PA717161 | auteur | |
| 16060000082196 | L16/dossiers | 16 | 16060000082195 | 16060000082195 | 1 | PO791932 | ||
| 16060000082199 | L16/dossiers | 16 | 16060000082198 | 16060000082198 | 1 | PO791932 | ||
| 16060000082202 | L16/dossiers | 16 | 16060000082201 | 16060000082201 | 1 | PA717161 | auteur | |
| 16060000082207 | L16/dossiers | 16 | 16060000082206 | 16060000082206 | 1 | PA717161 | auteur | |
| 16060000082212 | L16/dossiers | 16 | 16060000082211 | 16060000082211 | 1 | PA717161 | auteur | |
| 16060000082216 | L16/dossiers | 16 | 16060000082215 | 16060000082215 | 1 | PA717161 | auteur | |
| 16060000082220 | L16/dossiers | 16 | 16060000082219 | 16060000082219 | 1 | PA717161 | auteur | |
| 16060000082224 | L16/dossiers | 16 | 16060000082223 | 16060000082223 | 1 | PA717161 | auteur | |
| 16060000082229 | L16/dossiers | 16 | 16060000082228 | 16060000082228 | 1 | PA717161 | auteur | |
| 16060000082241 | L16/dossiers | 16 | 16060000082240 | 16060000082240 | 1 | PA717161 | auteur | |
| 16060000082248 | L16/dossiers | 16 | 16060000082247 | 16060000082247 | 1 | PA717161 | auteur | |
| 16060000082253 | L16/dossiers | 16 | 16060000082252 | 16060000082252 | 1 | PO791932 | ||
| 16060000082257 | L16/dossiers | 16 | 16060000082256 | 16060000082256 | 1 | PA717161 | auteur | |
| 16060000082261 | L16/dossiers | 16 | 16060000082260 | 16060000082260 | 1 | PO791932 | ||
| 16060000082264 | L16/dossiers | 16 | 16060000082263 | 16060000082263 | 1 | PO791932 | ||
| 16060000082267 | L16/dossiers | 16 | 16060000082266 | 16060000082266 | 1 | PO791932 | ||
| 16060000082270 | L16/dossiers | 16 | 16060000082269 | 16060000082269 | 1 | PA717161 | auteur | |
| 16060000082275 | L16/dossiers | 16 | 16060000082274 | 16060000082274 | 1 | PO791932 | ||
| 16060000082279 | L16/dossiers | 16 | 16060000082278 | 16060000082278 | 1 | PO791932 | ||
| 16060000082282 | L16/dossiers | 16 | 16060000082281 | 16060000082281 | 1 | PO791932 | ||
| 16060000082285 | L16/dossiers | 16 | 16060000082284 | 16060000082284 | 1 | PO791932 | ||
| 16060000082288 | L16/dossiers | 16 | 16060000082287 | 16060000082287 | 1 | PO791932 | ||
| 16060000082291 | L16/dossiers | 16 | 16060000082290 | 16060000082290 | 1 | PA717161 | auteur | |
| 16060000082295 | L16/dossiers | 16 | 16060000082294 | 16060000082294 | 1 | PO791932 | ||
| 16060000082302 | L16/dossiers | 16 | 16060000082301 | 16060000082301 | 1 | PA717161 | auteur | |
| 16060000082307 | L16/dossiers | 16 | 16060000082306 | 16060000082306 | 1 | PA717161 | auteur | |
| 16060000082311 | L16/dossiers | 16 | 16060000082310 | 16060000082310 | 1 | PA717161 | auteur | |
| 16060000082315 | L16/dossiers | 16 | 16060000082314 | 16060000082314 | 1 | PA717161 | auteur | |
| 16060000082320 | L16/dossiers | 16 | 16060000082319 | 16060000082319 | 1 | PA717161 | auteur | |
| 16060000082324 | L16/dossiers | 16 | 16060000082323 | 16060000082323 | 1 | PA717161 | auteur | |
| 16060000082329 | L16/dossiers | 16 | 16060000082328 | 16060000082328 | 1 | PA717161 | auteur | |
| 16060000082338 | L16/dossiers | 16 | 16060000082337 | 16060000082337 | 1 | PO791932 | ||
| 16060000082342 | L16/dossiers | 16 | 16060000082341 | 16060000082341 | 1 | PO791932 | ||
| 16060000082345 | L16/dossiers | 16 | 16060000082344 | 16060000082344 | 1 | PO791932 | ||
| 16060000082350 | L16/dossiers | 16 | 16060000082349 | 16060000082349 | 1 | PA717161 | auteur | |
| 16060000082354 | L16/dossiers | 16 | 16060000082353 | 16060000082353 | 1 | PO791932 |