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 |
|---|---|---|---|---|---|---|---|---|
| 17060000006410 | L17/dossiers | 17 | 17060000006409 | 17060000006409 | 1 | PO838901 | ||
| 17060000006413 | L17/dossiers | 17 | 17060000006412 | 17060000006412 | 1 | PO838901 | ||
| 17060000006416 | L17/dossiers | 17 | 17060000006415 | 17060000006415 | 1 | PO838901 | ||
| 17060000006419 | L17/dossiers | 17 | 17060000006418 | 17060000006418 | 1 | PO838901 | ||
| 17060000006422 | L17/dossiers | 17 | 17060000006421 | 17060000006421 | 1 | PO838901 | ||
| 17060000006425 | L17/dossiers | 17 | 17060000006424 | 17060000006424 | 1 | PO838901 | ||
| 17060000006428 | L17/dossiers | 17 | 17060000006427 | 17060000006427 | 1 | PO838901 | ||
| 17060000006431 | L17/dossiers | 17 | 17060000006430 | 17060000006430 | 1 | PO838901 | ||
| 17060000006434 | L17/dossiers | 17 | 17060000006433 | 17060000006433 | 1 | PO838901 | ||
| 17060000006437 | L17/dossiers | 17 | 17060000006436 | 17060000006436 | 1 | PO838901 | ||
| 17060000006440 | L17/dossiers | 17 | 17060000006439 | 17060000006439 | 1 | PO838901 | ||
| 17060000006443 | L17/dossiers | 17 | 17060000006442 | 17060000006442 | 1 | PO838901 | ||
| 17060000006446 | L17/dossiers | 17 | 17060000006445 | 17060000006445 | 1 | PO838901 | ||
| 17060000006449 | L17/dossiers | 17 | 17060000006448 | 17060000006448 | 1 | PO838901 | ||
| 17060000006452 | L17/dossiers | 17 | 17060000006451 | 17060000006451 | 1 | PO838901 | ||
| 17060000006455 | L17/dossiers | 17 | 17060000006454 | 17060000006454 | 1 | PO838901 | ||
| 17060000006458 | L17/dossiers | 17 | 17060000006457 | 17060000006457 | 1 | PO838901 | ||
| 17060000006461 | L17/dossiers | 17 | 17060000006460 | 17060000006460 | 1 | PO838901 | ||
| 17060000006464 | L17/dossiers | 17 | 17060000006463 | 17060000006463 | 1 | PO838901 | ||
| 17060000006467 | L17/dossiers | 17 | 17060000006466 | 17060000006466 | 1 | PO838901 | ||
| 17060000006470 | L17/dossiers | 17 | 17060000006469 | 17060000006469 | 1 | PO838901 | ||
| 17060000006473 | L17/dossiers | 17 | 17060000006472 | 17060000006472 | 1 | PO838901 | ||
| 17060000006476 | L17/dossiers | 17 | 17060000006475 | 17060000006475 | 1 | PO838901 | ||
| 17060000006479 | L17/dossiers | 17 | 17060000006478 | 17060000006478 | 1 | PO838901 | ||
| 17060000006482 | L17/dossiers | 17 | 17060000006481 | 17060000006481 | 1 | PO838901 | ||
| 17060000006485 | L17/dossiers | 17 | 17060000006484 | 17060000006484 | 1 | PO838901 | ||
| 17060000006488 | L17/dossiers | 17 | 17060000006487 | 17060000006487 | 1 | PO838901 | ||
| 17060000006491 | L17/dossiers | 17 | 17060000006490 | 17060000006490 | 1 | PO838901 | ||
| 17060000006494 | L17/dossiers | 17 | 17060000006493 | 17060000006493 | 1 | PO838901 | ||
| 17060000006497 | L17/dossiers | 17 | 17060000006496 | 17060000006496 | 1 | PO838901 | ||
| 17060000006500 | L17/dossiers | 17 | 17060000006499 | 17060000006499 | 1 | PO838901 | ||
| 17060000006503 | L17/dossiers | 17 | 17060000006502 | 17060000006502 | 1 | PO838901 | ||
| 17060000006506 | L17/dossiers | 17 | 17060000006505 | 17060000006505 | 1 | PO838901 | ||
| 17060000006509 | L17/dossiers | 17 | 17060000006508 | 17060000006508 | 1 | PO838901 | ||
| 17060000006512 | L17/dossiers | 17 | 17060000006511 | 17060000006511 | 1 | PO838901 | ||
| 17060000006515 | L17/dossiers | 17 | 17060000006514 | 17060000006514 | 1 | PO838901 | ||
| 17060000006518 | L17/dossiers | 17 | 17060000006517 | 17060000006517 | 1 | PO838901 | ||
| 17060000006521 | L17/dossiers | 17 | 17060000006520 | 17060000006520 | 1 | PO838901 | ||
| 17060000006524 | L17/dossiers | 17 | 17060000006523 | 17060000006523 | 1 | PO838901 | ||
| 17060000006527 | L17/dossiers | 17 | 17060000006526 | 17060000006526 | 1 | PO838901 | ||
| 17060000006530 | L17/dossiers | 17 | 17060000006529 | 17060000006529 | 1 | PO838901 | ||
| 17060000006533 | L17/dossiers | 17 | 17060000006532 | 17060000006532 | 1 | PO838901 | ||
| 17060000006536 | L17/dossiers | 17 | 17060000006535 | 17060000006535 | 1 | PO838901 | ||
| 17060000006539 | L17/dossiers | 17 | 17060000006538 | 17060000006538 | 1 | PO838901 | ||
| 17060000006542 | L17/dossiers | 17 | 17060000006541 | 17060000006541 | 1 | PO838901 | ||
| 17060000006545 | L17/dossiers | 17 | 17060000006544 | 17060000006544 | 1 | PO838901 | ||
| 17060000006548 | L17/dossiers | 17 | 17060000006547 | 17060000006547 | 1 | PO838901 | ||
| 17060000006551 | L17/dossiers | 17 | 17060000006550 | 17060000006550 | 1 | PO838901 | ||
| 17060000006554 | L17/dossiers | 17 | 17060000006553 | 17060000006553 | 1 | PO838901 | ||
| 17060000006557 | L17/dossiers | 17 | 17060000006556 | 17060000006556 | 1 | PO838901 |