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 |
|---|---|---|---|---|---|---|---|---|
| 17060000079424 | L17/dossiers | 17 | 17060000079402 | 17060000079402 | 22 | PA703517 | auteur | |
| 17060000079425 | L17/dossiers | 17 | 17060000079402 | 17060000079402 | 23 | PA736186 | auteur | |
| 17060000079426 | L17/dossiers | 17 | 17060000079402 | 17060000079402 | 24 | PA773891 | auteur | |
| 17060000079427 | L17/dossiers | 17 | 17060000079402 | 17060000079402 | 25 | PA703537 | auteur | |
| 17060000079428 | L17/dossiers | 17 | 17060000079402 | 17060000079402 | 26 | PA775298 | auteur | |
| 17060000079429 | L17/dossiers | 17 | 17060000079402 | 17060000079402 | 27 | PA775270 | auteur | |
| 17060000079430 | L17/dossiers | 17 | 17060000079402 | 17060000079402 | 28 | PA267075 | auteur | |
| 17060000079431 | L17/dossiers | 17 | 17060000079402 | 17060000079402 | 29 | PA775178 | auteur | |
| 17060000079433 | L17/dossiers | 17 | 17060000079432 | 17060000079432 | 1 | PA715322 | auteur | |
| 17060000079435 | L17/dossiers | 17 | 17060000079434 | 17060000079434 | 1 | PA415486 | auteur | |
| 17060000079437 | L17/dossiers | 17 | 17060000079436 | 17060000079436 | 1 | PA785857 | auteur | |
| 17060000079438 | L17/dossiers | 17 | 17060000079436 | 17060000079436 | 2 | PA827978 | auteur | |
| 17060000079440 | L17/dossiers | 17 | 17060000079439 | 17060000079439 | 1 | PA736179 | auteur | |
| 17060000079442 | L17/dossiers | 17 | 17060000079441 | 17060000079441 | 1 | PA775254 | auteur | |
| 17060000079444 | L17/dossiers | 17 | 17060000079443 | 17060000079443 | 1 | PO78718 | ||
| 17060000079446 | L17/dossiers | 17 | 17060000079445 | 17060000079445 | 1 | PO78718 | ||
| 17060000079448 | L17/dossiers | 17 | 17060000079447 | 17060000079447 | 1 | PO78718 | ||
| 17060000079450 | L17/dossiers | 17 | 17060000079449 | 17060000079449 | 1 | PO78718 | ||
| 17060000079452 | L17/dossiers | 17 | 17060000079451 | 17060000079451 | 1 | PO78718 | ||
| 17060000079454 | L17/dossiers | 17 | 17060000079453 | 17060000079453 | 1 | PO78718 | ||
| 17060000079456 | L17/dossiers | 17 | 17060000079455 | 17060000079455 | 1 | PO78718 | ||
| 17060000079458 | L17/dossiers | 17 | 17060000079457 | 17060000079457 | 1 | PO78718 | ||
| 17060000079460 | L17/dossiers | 17 | 17060000079459 | 17060000079459 | 1 | PO78718 | ||
| 17060000079462 | L17/dossiers | 17 | 17060000079461 | 17060000079461 | 1 | PO78718 | ||
| 17060000079464 | L17/dossiers | 17 | 17060000079463 | 17060000079463 | 1 | PO78718 | ||
| 17060000079466 | L17/dossiers | 17 | 17060000079465 | 17060000079465 | 1 | PO78718 | ||
| 17060000079468 | L17/dossiers | 17 | 17060000079467 | 17060000079467 | 1 | PO78718 | ||
| 17060000079470 | L17/dossiers | 17 | 17060000079469 | 17060000079469 | 1 | PO78718 | ||
| 17060000079472 | L17/dossiers | 17 | 17060000079471 | 17060000079471 | 1 | PO78718 | ||
| 17060000079474 | L17/dossiers | 17 | 17060000079473 | 17060000079473 | 1 | PO78718 | ||
| 17060000079476 | L17/dossiers | 17 | 17060000079475 | 17060000079475 | 1 | PO78718 | ||
| 17060000079478 | L17/dossiers | 17 | 17060000079477 | 17060000079477 | 1 | PO78718 | ||
| 17060000079480 | L17/dossiers | 17 | 17060000079479 | 17060000079479 | 1 | PO78718 | ||
| 17060000079482 | L17/dossiers | 17 | 17060000079481 | 17060000079481 | 1 | PO78718 | ||
| 17060000079484 | L17/dossiers | 17 | 17060000079483 | 17060000079483 | 1 | PO78718 | ||
| 17060000079486 | L17/dossiers | 17 | 17060000079485 | 17060000079485 | 1 | PO78718 | ||
| 17060000079488 | L17/dossiers | 17 | 17060000079487 | 17060000079487 | 1 | PO78718 | ||
| 17060000079490 | L17/dossiers | 17 | 17060000079489 | 17060000079489 | 1 | PO78718 | ||
| 17060000079492 | L17/dossiers | 17 | 17060000079491 | 17060000079491 | 1 | PO78718 | ||
| 17060000079494 | L17/dossiers | 17 | 17060000079493 | 17060000079493 | 1 | PO78718 | ||
| 17060000079496 | L17/dossiers | 17 | 17060000079495 | 17060000079495 | 1 | PO78718 | ||
| 17060000079498 | L17/dossiers | 17 | 17060000079497 | 17060000079497 | 1 | PO78718 | ||
| 17060000079500 | L17/dossiers | 17 | 17060000079499 | 17060000079499 | 1 | PO78718 | ||
| 17060000079502 | L17/dossiers | 17 | 17060000079501 | 17060000079501 | 1 | PO78718 | ||
| 17060000079504 | L17/dossiers | 17 | 17060000079503 | 17060000079503 | 1 | PO78718 | ||
| 17060000079506 | L17/dossiers | 17 | 17060000079505 | 17060000079505 | 1 | PO78718 | ||
| 17060000079508 | L17/dossiers | 17 | 17060000079507 | 17060000079507 | 1 | PO78718 | ||
| 17060000079510 | L17/dossiers | 17 | 17060000079509 | 17060000079509 | 1 | PO78718 | ||
| 17060000079512 | L17/dossiers | 17 | 17060000079511 | 17060000079511 | 1 | PO78718 | ||
| 17060000079514 | L17/dossiers | 17 | 17060000079513 | 17060000079513 | 1 | PO78718 |