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 |
|---|---|---|---|---|---|---|---|---|
| 16060000055162 | L16/dossiers | 16 | 16060000055161 | 16060000055161 | 1 | PO791932 | ||
| 16060000055165 | L16/dossiers | 16 | 16060000055164 | 16060000055164 | 1 | PO791932 | ||
| 16060000055168 | L16/dossiers | 16 | 16060000055167 | 16060000055167 | 1 | PO791932 | ||
| 16060000055171 | L16/dossiers | 16 | 16060000055170 | 16060000055170 | 1 | PO791932 | ||
| 16060000055174 | L16/dossiers | 16 | 16060000055173 | 16060000055173 | 1 | PO791932 | ||
| 16060000055178 | L16/dossiers | 16 | 16060000055177 | 16060000055177 | 1 | PO791932 | ||
| 16060000055181 | L16/dossiers | 16 | 16060000055180 | 16060000055180 | 1 | PO791932 | ||
| 16060000055184 | L16/dossiers | 16 | 16060000055183 | 16060000055183 | 1 | PO791932 | ||
| 16060000055187 | L16/dossiers | 16 | 16060000055186 | 16060000055186 | 1 | PO791932 | ||
| 16060000055190 | L16/dossiers | 16 | 16060000055189 | 16060000055189 | 1 | PO791932 | ||
| 16060000055193 | L16/dossiers | 16 | 16060000055192 | 16060000055192 | 1 | PO791932 | ||
| 16060000055196 | L16/dossiers | 16 | 16060000055195 | 16060000055195 | 1 | PO791932 | ||
| 16060000055199 | L16/dossiers | 16 | 16060000055198 | 16060000055198 | 1 | PO791932 | ||
| 16060000055202 | L16/dossiers | 16 | 16060000055201 | 16060000055201 | 1 | PO791932 | ||
| 16060000055205 | L16/dossiers | 16 | 16060000055204 | 16060000055204 | 1 | PO791932 | ||
| 16060000055208 | L16/dossiers | 16 | 16060000055207 | 16060000055207 | 1 | PO791932 | ||
| 16060000055211 | L16/dossiers | 16 | 16060000055210 | 16060000055210 | 1 | PO791932 | ||
| 16060000055213 | L16/dossiers | 16 | 16060000055212 | 16060000055212 | 1 | PO791932 | ||
| 16060000055215 | L16/dossiers | 16 | 16060000055214 | 16060000055214 | 1 | PO791932 | ||
| 16060000055218 | L16/dossiers | 16 | 16060000055217 | 16060000055217 | 1 | PO791932 | ||
| 16060000055221 | L16/dossiers | 16 | 16060000055220 | 16060000055220 | 1 | PO791932 | ||
| 16060000055224 | L16/dossiers | 16 | 16060000055223 | 16060000055223 | 1 | PO791932 | ||
| 16060000055227 | L16/dossiers | 16 | 16060000055226 | 16060000055226 | 1 | PO791932 | ||
| 16060000055230 | L16/dossiers | 16 | 16060000055229 | 16060000055229 | 1 | PO791932 | ||
| 16060000055233 | L16/dossiers | 16 | 16060000055232 | 16060000055232 | 1 | PO791932 | ||
| 16060000055236 | L16/dossiers | 16 | 16060000055235 | 16060000055235 | 1 | PO791932 | ||
| 16060000055238 | L16/dossiers | 16 | 16060000055237 | 16060000055237 | 1 | PO791932 | ||
| 16060000055241 | L16/dossiers | 16 | 16060000055240 | 16060000055240 | 1 | PO791932 | ||
| 16060000055244 | L16/dossiers | 16 | 16060000055243 | 16060000055243 | 1 | PO791932 | ||
| 16060000055246 | L16/dossiers | 16 | 16060000055245 | 16060000055245 | 1 | PO791932 | ||
| 16060000055249 | L16/dossiers | 16 | 16060000055248 | 16060000055248 | 1 | PO791932 | ||
| 16060000055252 | L16/dossiers | 16 | 16060000055251 | 16060000055251 | 1 | PO791932 | ||
| 16060000055258 | L16/dossiers | 16 | 16060000055257 | 16060000055257 | 1 | PO791932 | ||
| 16060000055260 | L16/dossiers | 16 | 16060000055259 | 16060000055259 | 1 | PO791932 | ||
| 16060000055263 | L16/dossiers | 16 | 16060000055262 | 16060000055262 | 1 | PO791932 | ||
| 16060000055266 | L16/dossiers | 16 | 16060000055265 | 16060000055265 | 1 | PO791932 | ||
| 16060000055269 | L16/dossiers | 16 | 16060000055268 | 16060000055268 | 1 | PO791932 | ||
| 16060000055272 | L16/dossiers | 16 | 16060000055271 | 16060000055271 | 1 | PO791932 | ||
| 16060000055275 | L16/dossiers | 16 | 16060000055274 | 16060000055274 | 1 | PO791932 | ||
| 16060000055277 | L16/dossiers | 16 | 16060000055276 | 16060000055276 | 1 | PO791932 | ||
| 16060000055280 | L16/dossiers | 16 | 16060000055279 | 16060000055279 | 1 | PO791932 | ||
| 16060000055283 | L16/dossiers | 16 | 16060000055282 | 16060000055282 | 1 | PO791932 | ||
| 16060000055286 | L16/dossiers | 16 | 16060000055285 | 16060000055285 | 1 | PO791932 | ||
| 16060000055289 | L16/dossiers | 16 | 16060000055288 | 16060000055288 | 1 | PO791932 | ||
| 16060000055293 | L16/dossiers | 16 | 16060000055292 | 16060000055292 | 1 | PO791932 | ||
| 16060000055295 | L16/dossiers | 16 | 16060000055294 | 16060000055294 | 1 | PO791932 | ||
| 16060000055297 | L16/dossiers | 16 | 16060000055296 | 16060000055296 | 1 | PO791932 | ||
| 16060000055300 | L16/dossiers | 16 | 16060000055299 | 16060000055299 | 1 | PO791932 | ||
| 16060000055302 | L16/dossiers | 16 | 16060000055301 | 16060000055301 | 1 | PO791932 | ||
| 16060000055304 | L16/dossiers | 16 | 16060000055303 | 16060000055303 | 1 | PO791932 |