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 |
|---|---|---|---|---|---|---|---|---|
| 17060000006281 | L17/dossiers | 17 | 17060000006279 | 17060000006279 | 2 | PO420120 | ||
| 17060000006284 | L17/dossiers | 17 | 17060000006283 | 17060000006283 | 1 | PA720022 | rapporteur | |
| 17060000006285 | L17/dossiers | 17 | 17060000006283 | 17060000006283 | 2 | PA795794 | rapporteur | |
| 17060000006286 | L17/dossiers | 17 | 17060000006283 | 17060000006283 | 3 | PO835801 | ||
| 17060000006288 | L17/dossiers | 17 | 17060000006287 | 17060000006287 | 1 | PA793948 | rapporteur | |
| 17060000006289 | L17/dossiers | 17 | 17060000006287 | 17060000006287 | 2 | PO419865 | ||
| 17060000006292 | L17/dossiers | 17 | 17060000006291 | 17060000006291 | 1 | PA642868 | rapporteur | |
| 17060000006293 | L17/dossiers | 17 | 17060000006291 | 17060000006291 | 2 | PO420120 | ||
| 17060000006296 | L17/dossiers | 17 | 17060000006295 | 17060000006295 | 1 | PA721584 | rapporteur | |
| 17060000006297 | L17/dossiers | 17 | 17060000006295 | 17060000006295 | 2 | PO59051 | ||
| 17060000006300 | L17/dossiers | 17 | 17060000006299 | 17060000006299 | 1 | PA719814 | rapporteur | |
| 17060000006301 | L17/dossiers | 17 | 17060000006299 | 17060000006299 | 2 | PA267324 | rapporteur | |
| 17060000006302 | L17/dossiers | 17 | 17060000006299 | 17060000006299 | 3 | PO419604 | ||
| 17060000006305 | L17/dossiers | 17 | 17060000006304 | 17060000006304 | 1 | PA720692 | rapporteur | |
| 17060000006306 | L17/dossiers | 17 | 17060000006304 | 17060000006304 | 2 | PO420120 | ||
| 17060000006309 | L17/dossiers | 17 | 17060000006308 | 17060000006308 | 1 | PA722150 | rapporteur | |
| 17060000006310 | L17/dossiers | 17 | 17060000006308 | 17060000006308 | 2 | PO838264 | ||
| 17060000006312 | L17/dossiers | 17 | 17060000006311 | 17060000006311 | 1 | PO791932 | ||
| 17060000006315 | L17/dossiers | 17 | 17060000006314 | 17060000006314 | 1 | PO791932 | ||
| 17060000006318 | L17/dossiers | 17 | 17060000006317 | 17060000006317 | 1 | PO791932 | ||
| 17060000006321 | L17/dossiers | 17 | 17060000006320 | 17060000006320 | 1 | PO791932 | ||
| 17060000006324 | L17/dossiers | 17 | 17060000006323 | 17060000006323 | 1 | PO791932 | ||
| 17060000006327 | L17/dossiers | 17 | 17060000006326 | 17060000006326 | 1 | PO791932 | ||
| 17060000006330 | L17/dossiers | 17 | 17060000006329 | 17060000006329 | 1 | PO791932 | ||
| 17060000006333 | L17/dossiers | 17 | 17060000006332 | 17060000006332 | 1 | PO791932 | ||
| 17060000006336 | L17/dossiers | 17 | 17060000006335 | 17060000006335 | 1 | PO791932 | ||
| 17060000006339 | L17/dossiers | 17 | 17060000006338 | 17060000006338 | 1 | PO791932 | ||
| 17060000006342 | L17/dossiers | 17 | 17060000006341 | 17060000006341 | 1 | PO791932 | ||
| 17060000006345 | L17/dossiers | 17 | 17060000006344 | 17060000006344 | 1 | PO791932 | ||
| 17060000006348 | L17/dossiers | 17 | 17060000006347 | 17060000006347 | 1 | PO791932 | ||
| 17060000006351 | L17/dossiers | 17 | 17060000006350 | 17060000006350 | 1 | PO791932 | ||
| 17060000006354 | L17/dossiers | 17 | 17060000006353 | 17060000006353 | 1 | PO791932 | ||
| 17060000006357 | L17/dossiers | 17 | 17060000006356 | 17060000006356 | 1 | PO791932 | ||
| 17060000006360 | L17/dossiers | 17 | 17060000006359 | 17060000006359 | 1 | PO791932 | ||
| 17060000006363 | L17/dossiers | 17 | 17060000006362 | 17060000006362 | 1 | PO791932 | ||
| 17060000006366 | L17/dossiers | 17 | 17060000006365 | 17060000006365 | 1 | PO791932 | ||
| 17060000006369 | L17/dossiers | 17 | 17060000006368 | 17060000006368 | 1 | PO791932 | ||
| 17060000006372 | L17/dossiers | 17 | 17060000006371 | 17060000006371 | 1 | PO791932 | ||
| 17060000006374 | L17/dossiers | 17 | 17060000006373 | 17060000006373 | 1 | PA345722 | auteur | |
| 17060000006377 | L17/dossiers | 17 | 17060000006376 | 17060000006376 | 1 | PO838901 | ||
| 17060000006380 | L17/dossiers | 17 | 17060000006379 | 17060000006379 | 1 | PO838901 | ||
| 17060000006383 | L17/dossiers | 17 | 17060000006382 | 17060000006382 | 1 | PO838901 | ||
| 17060000006386 | L17/dossiers | 17 | 17060000006385 | 17060000006385 | 1 | PO838901 | ||
| 17060000006389 | L17/dossiers | 17 | 17060000006388 | 17060000006388 | 1 | PO838901 | ||
| 17060000006392 | L17/dossiers | 17 | 17060000006391 | 17060000006391 | 1 | PO838901 | ||
| 17060000006395 | L17/dossiers | 17 | 17060000006394 | 17060000006394 | 1 | PO838901 | ||
| 17060000006398 | L17/dossiers | 17 | 17060000006397 | 17060000006397 | 1 | PO838901 | ||
| 17060000006401 | L17/dossiers | 17 | 17060000006400 | 17060000006400 | 1 | PO838901 | ||
| 17060000006404 | L17/dossiers | 17 | 17060000006403 | 17060000006403 | 1 | PO838901 | ||
| 17060000006407 | L17/dossiers | 17 | 17060000006406 | 17060000006406 | 1 | PO838901 |