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 |
|---|---|---|---|---|---|---|---|---|
| 17060000004362 | L17/dossiers | 17 | 17060000004361 | 17060000004361 | 1 | PA721750 | rapporteur | |
| 17060000004363 | L17/dossiers | 17 | 17060000004361 | 17060000004361 | 2 | PA721888 | rapporteur | |
| 17060000004364 | L17/dossiers | 17 | 17060000004361 | 17060000004361 | 3 | PA718902 | rapporteur | |
| 17060000004365 | L17/dossiers | 17 | 17060000004361 | 17060000004361 | 4 | PO419604 | ||
| 17060000004368 | L17/dossiers | 17 | 17060000004367 | 17060000004367 | 1 | PO717460 | ||
| 17060000004371 | L17/dossiers | 17 | 17060000004370 | 17060000004370 | 1 | PO717460 | ||
| 17060000004374 | L17/dossiers | 17 | 17060000004373 | 17060000004373 | 1 | PO717460 | ||
| 17060000004376 | L17/dossiers | 17 | 17060000004375 | 17060000004375 | 1 | PO717460 | ||
| 17060000004379 | L17/dossiers | 17 | 17060000004378 | 17060000004378 | 1 | PO717460 | ||
| 17060000004382 | L17/dossiers | 17 | 17060000004381 | 17060000004381 | 1 | PO717460 | ||
| 17060000004385 | L17/dossiers | 17 | 17060000004384 | 17060000004384 | 1 | PO791932 | ||
| 17060000004388 | L17/dossiers | 17 | 17060000004387 | 17060000004387 | 1 | PO791932 | ||
| 17060000004391 | L17/dossiers | 17 | 17060000004390 | 17060000004390 | 1 | PO791932 | ||
| 17060000004394 | L17/dossiers | 17 | 17060000004393 | 17060000004393 | 1 | PO791932 | ||
| 17060000004397 | L17/dossiers | 17 | 17060000004396 | 17060000004396 | 1 | PO791932 | ||
| 17060000004400 | L17/dossiers | 17 | 17060000004399 | 17060000004399 | 1 | PO791932 | ||
| 17060000004403 | L17/dossiers | 17 | 17060000004402 | 17060000004402 | 1 | PO791932 | ||
| 17060000004406 | L17/dossiers | 17 | 17060000004405 | 17060000004405 | 1 | PO791932 | ||
| 17060000004409 | L17/dossiers | 17 | 17060000004408 | 17060000004408 | 1 | PO791932 | ||
| 17060000004412 | L17/dossiers | 17 | 17060000004411 | 17060000004411 | 1 | PO791932 | ||
| 17060000004415 | L17/dossiers | 17 | 17060000004414 | 17060000004414 | 1 | PO791932 | ||
| 17060000004418 | L17/dossiers | 17 | 17060000004417 | 17060000004417 | 1 | PO791932 | ||
| 17060000004421 | L17/dossiers | 17 | 17060000004420 | 17060000004420 | 1 | PO791932 | ||
| 17060000004424 | L17/dossiers | 17 | 17060000004423 | 17060000004423 | 1 | PO791932 | ||
| 17060000004427 | L17/dossiers | 17 | 17060000004426 | 17060000004426 | 1 | PO791932 | ||
| 17060000004430 | L17/dossiers | 17 | 17060000004429 | 17060000004429 | 1 | PO791932 | ||
| 17060000004433 | L17/dossiers | 17 | 17060000004432 | 17060000004432 | 1 | PO791932 | ||
| 17060000004436 | L17/dossiers | 17 | 17060000004435 | 17060000004435 | 1 | PO791932 | ||
| 17060000004439 | L17/dossiers | 17 | 17060000004438 | 17060000004438 | 1 | PO791932 | ||
| 17060000004442 | L17/dossiers | 17 | 17060000004441 | 17060000004441 | 1 | PO791932 | ||
| 17060000004445 | L17/dossiers | 17 | 17060000004444 | 17060000004444 | 1 | PO791932 | ||
| 17060000004448 | L17/dossiers | 17 | 17060000004447 | 17060000004447 | 1 | PO791932 | ||
| 17060000004451 | L17/dossiers | 17 | 17060000004450 | 17060000004450 | 1 | PO791932 | ||
| 17060000004454 | L17/dossiers | 17 | 17060000004453 | 17060000004453 | 1 | PO791932 | ||
| 17060000004457 | L17/dossiers | 17 | 17060000004456 | 17060000004456 | 1 | PO791932 | ||
| 17060000004460 | L17/dossiers | 17 | 17060000004459 | 17060000004459 | 1 | PO791932 | ||
| 17060000004463 | L17/dossiers | 17 | 17060000004462 | 17060000004462 | 1 | PO791932 | ||
| 17060000004466 | L17/dossiers | 17 | 17060000004465 | 17060000004465 | 1 | PO791932 | ||
| 17060000004469 | L17/dossiers | 17 | 17060000004468 | 17060000004468 | 1 | PO791932 | ||
| 17060000004472 | L17/dossiers | 17 | 17060000004471 | 17060000004471 | 1 | PO791932 | ||
| 17060000004475 | L17/dossiers | 17 | 17060000004474 | 17060000004474 | 1 | PO791932 | ||
| 17060000004478 | L17/dossiers | 17 | 17060000004477 | 17060000004477 | 1 | PO791932 | ||
| 17060000004481 | L17/dossiers | 17 | 17060000004480 | 17060000004480 | 1 | PO791932 | ||
| 17060000004484 | L17/dossiers | 17 | 17060000004483 | 17060000004483 | 1 | PO791932 | ||
| 17060000004487 | L17/dossiers | 17 | 17060000004486 | 17060000004486 | 1 | PO791932 | ||
| 17060000004490 | L17/dossiers | 17 | 17060000004489 | 17060000004489 | 1 | PO791932 | ||
| 17060000004493 | L17/dossiers | 17 | 17060000004492 | 17060000004492 | 1 | PO791932 | ||
| 17060000004496 | L17/dossiers | 17 | 17060000004495 | 17060000004495 | 1 | PO791932 | ||
| 17060000004499 | L17/dossiers | 17 | 17060000004498 | 17060000004498 | 1 | PO791932 | ||
| 17060000004502 | L17/dossiers | 17 | 17060000004501 | 17060000004501 | 1 | PO791932 |