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 |
|---|---|---|---|---|---|---|---|---|
| 16060000004307 | L16/dossiers | 16 | 16060000004306 | 16060000004306 | 1 | PO791932 | ||
| 16060000004310 | L16/dossiers | 16 | 16060000004309 | 16060000004309 | 1 | PO791932 | ||
| 16060000004313 | L16/dossiers | 16 | 16060000004312 | 16060000004312 | 1 | PO791932 | ||
| 16060000004316 | L16/dossiers | 16 | 16060000004315 | 16060000004315 | 1 | PO791932 | ||
| 16060000004319 | L16/dossiers | 16 | 16060000004318 | 16060000004318 | 1 | PO791932 | ||
| 16060000004322 | L16/dossiers | 16 | 16060000004321 | 16060000004321 | 1 | PO791932 | ||
| 16060000004325 | L16/dossiers | 16 | 16060000004324 | 16060000004324 | 1 | PO791932 | ||
| 16060000004328 | L16/dossiers | 16 | 16060000004327 | 16060000004327 | 1 | PO791932 | ||
| 16060000004331 | L16/dossiers | 16 | 16060000004330 | 16060000004330 | 1 | PO791932 | ||
| 16060000004334 | L16/dossiers | 16 | 16060000004333 | 16060000004333 | 1 | PO791932 | ||
| 16060000004337 | L16/dossiers | 16 | 16060000004336 | 16060000004336 | 1 | PO791932 | ||
| 16060000004340 | L16/dossiers | 16 | 16060000004339 | 16060000004339 | 1 | PO791932 | ||
| 16060000004343 | L16/dossiers | 16 | 16060000004342 | 16060000004342 | 1 | PO791932 | ||
| 16060000004346 | L16/dossiers | 16 | 16060000004345 | 16060000004345 | 1 | PO791932 | ||
| 16060000004349 | L16/dossiers | 16 | 16060000004348 | 16060000004348 | 1 | PO791932 | ||
| 16060000004352 | L16/dossiers | 16 | 16060000004351 | 16060000004351 | 1 | PO791932 | ||
| 16060000004355 | L16/dossiers | 16 | 16060000004354 | 16060000004354 | 1 | PO791932 | ||
| 16060000004358 | L16/dossiers | 16 | 16060000004357 | 16060000004357 | 1 | PO791932 | ||
| 16060000004361 | L16/dossiers | 16 | 16060000004360 | 16060000004360 | 1 | PO791932 | ||
| 16060000004364 | L16/dossiers | 16 | 16060000004363 | 16060000004363 | 1 | PO791932 | ||
| 16060000004367 | L16/dossiers | 16 | 16060000004366 | 16060000004366 | 1 | PO791932 | ||
| 16060000004370 | L16/dossiers | 16 | 16060000004369 | 16060000004369 | 1 | PO791932 | ||
| 16060000004373 | L16/dossiers | 16 | 16060000004372 | 16060000004372 | 1 | PO791932 | ||
| 16060000004376 | L16/dossiers | 16 | 16060000004375 | 16060000004375 | 1 | PO791932 | ||
| 16060000004379 | L16/dossiers | 16 | 16060000004378 | 16060000004378 | 1 | PO791932 | ||
| 16060000004382 | L16/dossiers | 16 | 16060000004381 | 16060000004381 | 1 | PO791932 | ||
| 16060000004385 | L16/dossiers | 16 | 16060000004384 | 16060000004384 | 1 | PO791932 | ||
| 16060000004388 | L16/dossiers | 16 | 16060000004387 | 16060000004387 | 1 | PO791932 | ||
| 16060000004391 | L16/dossiers | 16 | 16060000004390 | 16060000004390 | 1 | PO791932 | ||
| 16060000004394 | L16/dossiers | 16 | 16060000004393 | 16060000004393 | 1 | PO791932 | ||
| 16060000004397 | L16/dossiers | 16 | 16060000004396 | 16060000004396 | 1 | PO791932 | ||
| 16060000004400 | L16/dossiers | 16 | 16060000004399 | 16060000004399 | 1 | PO791932 | ||
| 16060000004403 | L16/dossiers | 16 | 16060000004402 | 16060000004402 | 1 | PO791932 | ||
| 16060000004406 | L16/dossiers | 16 | 16060000004405 | 16060000004405 | 1 | PO791932 | ||
| 16060000004409 | L16/dossiers | 16 | 16060000004408 | 16060000004408 | 1 | PO791932 | ||
| 16060000004412 | L16/dossiers | 16 | 16060000004411 | 16060000004411 | 1 | PO791932 | ||
| 16060000004415 | L16/dossiers | 16 | 16060000004414 | 16060000004414 | 1 | PO791932 | ||
| 16060000004418 | L16/dossiers | 16 | 16060000004417 | 16060000004417 | 1 | PO791932 | ||
| 16060000004421 | L16/dossiers | 16 | 16060000004420 | 16060000004420 | 1 | PO791932 | ||
| 16060000004424 | L16/dossiers | 16 | 16060000004423 | 16060000004423 | 1 | PO791932 | ||
| 16060000004427 | L16/dossiers | 16 | 16060000004426 | 16060000004426 | 1 | PO791932 | ||
| 16060000004430 | L16/dossiers | 16 | 16060000004429 | 16060000004429 | 1 | PO791932 | ||
| 16060000004433 | L16/dossiers | 16 | 16060000004432 | 16060000004432 | 1 | PO791932 | ||
| 16060000004436 | L16/dossiers | 16 | 16060000004435 | 16060000004435 | 1 | PO791932 | ||
| 16060000004439 | L16/dossiers | 16 | 16060000004438 | 16060000004438 | 1 | PO791932 | ||
| 16060000004442 | L16/dossiers | 16 | 16060000004441 | 16060000004441 | 1 | PO791932 | ||
| 16060000004445 | L16/dossiers | 16 | 16060000004444 | 16060000004444 | 1 | PO791932 | ||
| 16060000004448 | L16/dossiers | 16 | 16060000004447 | 16060000004447 | 1 | PA721486 | auteur | |
| 16060000004460 | L16/dossiers | 16 | 16060000004459 | 16060000004459 | 1 | PO791932 | ||
| 16060000004463 | L16/dossiers | 16 | 16060000004462 | 16060000004462 | 1 | PO791932 |