dossiers.document_division_auteur
Chemin document.divisions.division.auteurs.auteur · présence : L17 4 %, L16 4 %, L15 4 %, L14 3 %
7 614 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 | _parent_recursif_id | BIGINT | _id de la ligne de même table qui contient celle-ci (structure récursive) |
| 8 | _niveau | BIGINT | profondeur dans la structure récursive (0 = premier niveau) |
| 9 | acteur_acteur_ref | VARCHAR | document.divisions.division.auteurs.auteur.acteur.acteurRef · présence : L17 4 %, L16 4 %, L15 4 %, L14 3 % |
| 10 | acteur_qualite | VARCHAR | document.divisions.division.auteurs.auteur.acteur.qualite · présence : L17 4 %, L16 4 %, L15 4 %, L14 3 % · 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 |
| 11 | organe_organe_ref | VARCHAR | document.divisions.division.auteurs.auteur.organe.organeRef · présence : L17 4 %, L16 4 %, L15 4 %, L14 3 % |
Aperçu
| _id | _source | _legislature | _racine_id | _parent_id | _ordre | _parent_recursif_id | _niveau | acteur_acteur_ref | acteur_qualite | organe_organe_ref |
|---|---|---|---|---|---|---|---|---|---|---|
| 17060000108427 | L17/dossiers | 17 | 17060000108423 | 17060000108424 | 3 | 0 | PO59046 | |||
| 17060000108433 | L17/dossiers | 17 | 17060000108431 | 17060000108432 | 1 | 0 | PA720560 | rapporteur | ||
| 17060000108434 | L17/dossiers | 17 | 17060000108431 | 17060000108432 | 2 | 0 | PO420120 | |||
| 17060000108448 | L17/dossiers | 17 | 17060000108446 | 17060000108447 | 1 | 0 | PA795864 | rapporteur | ||
| 17060000108449 | L17/dossiers | 17 | 17060000108446 | 17060000108447 | 2 | 0 | PO419610 | |||
| 17060000108454 | L17/dossiers | 17 | 17060000108452 | 17060000108453 | 1 | 0 | PA721764 | rapporteur | ||
| 17060000108455 | L17/dossiers | 17 | 17060000108452 | 17060000108453 | 2 | 0 | PO419604 | |||
| 17060000108460 | L17/dossiers | 17 | 17060000108458 | 17060000108459 | 1 | 0 | PA795664 | rapporteur | ||
| 17060000108461 | L17/dossiers | 17 | 17060000108458 | 17060000108459 | 2 | 0 | PO59051 | |||
| 17060000108475 | L17/dossiers | 17 | 17060000108473 | 17060000108474 | 1 | 0 | PA342415 | rapporteur | ||
| 17060000108476 | L17/dossiers | 17 | 17060000108473 | 17060000108474 | 2 | 0 | PA720162 | rapporteur | ||
| 17060000108477 | L17/dossiers | 17 | 17060000108473 | 17060000108474 | 3 | 0 | PO419610 | |||
| 17060000108490 | L17/dossiers | 17 | 17060000108488 | 17060000108489 | 1 | 0 | PA795808 | rapporteur | ||
| 17060000108491 | L17/dossiers | 17 | 17060000108488 | 17060000108489 | 2 | 0 | PO420120 | |||
| 17060000108496 | L17/dossiers | 17 | 17060000108494 | 17060000108495 | 1 | 0 | PA793664 | rapporteur | ||
| 17060000108497 | L17/dossiers | 17 | 17060000108494 | 17060000108495 | 2 | 0 | PO59051 | |||
| 17060000108502 | L17/dossiers | 17 | 17060000108500 | 17060000108501 | 1 | 0 | PA794022 | rapporteur | ||
| 17060000108503 | L17/dossiers | 17 | 17060000108500 | 17060000108501 | 2 | 0 | PO419604 | |||
| 17060000108511 | L17/dossiers | 17 | 17060000108509 | 17060000108510 | 1 | 0 | PA794154 | rapporteur | ||
| 17060000108512 | L17/dossiers | 17 | 17060000108509 | 17060000108510 | 2 | 0 | PO419865 | |||
| 17060000108520 | L17/dossiers | 17 | 17060000108518 | 17060000108519 | 1 | 0 | PA736201 | rapporteur | ||
| 17060000108521 | L17/dossiers | 17 | 17060000108518 | 17060000108519 | 2 | 0 | PO419604 | |||
| 17060000108526 | L17/dossiers | 17 | 17060000108524 | 17060000108525 | 1 | 0 | PA840997 | rapporteur | ||
| 17060000108527 | L17/dossiers | 17 | 17060000108524 | 17060000108525 | 2 | 0 | PO419610 | |||
| 17060000108532 | L17/dossiers | 17 | 17060000108530 | 17060000108531 | 1 | 0 | PA794778 | rapporteur | ||
| 17060000108533 | L17/dossiers | 17 | 17060000108530 | 17060000108531 | 2 | 0 | PO59051 | |||
| 17060000108538 | L17/dossiers | 17 | 17060000108536 | 17060000108537 | 1 | 0 | PA605694 | rapporteur | ||
| 17060000108539 | L17/dossiers | 17 | 17060000108536 | 17060000108537 | 2 | 0 | PA793214 | rapporteur | ||
| 17060000108540 | L17/dossiers | 17 | 17060000108536 | 17060000108537 | 3 | 0 | PA795430 | rapporteur | ||
| 17060000108541 | L17/dossiers | 17 | 17060000108536 | 17060000108537 | 4 | 0 | PA795108 | rapporteur | ||
| 17060000108542 | L17/dossiers | 17 | 17060000108536 | 17060000108537 | 5 | 0 | PA720446 | rapporteur | ||
| 17060000108543 | L17/dossiers | 17 | 17060000108536 | 17060000108537 | 6 | 0 | PO420120 | |||
| 17060000108554 | L17/dossiers | 17 | 17060000108552 | 17060000108553 | 1 | 0 | PA722102 | rapporteur | ||
| 17060000108555 | L17/dossiers | 17 | 17060000108552 | 17060000108553 | 2 | 0 | PA794234 | rapporteur | ||
| 17060000108556 | L17/dossiers | 17 | 17060000108552 | 17060000108553 | 3 | 0 | PO420120 | |||
| 17060000108562 | L17/dossiers | 17 | 17060000108560 | 17060000108561 | 1 | 0 | PA795528 | rapporteur | ||
| 17060000108563 | L17/dossiers | 17 | 17060000108560 | 17060000108561 | 2 | 0 | PO59051 | |||
| 17060000108583 | L17/dossiers | 17 | 17060000108581 | 17060000108582 | 1 | 0 | PA794830 | rapporteur | ||
| 17060000108584 | L17/dossiers | 17 | 17060000108581 | 17060000108582 | 2 | 0 | PO419610 | |||
| 17060000108592 | L17/dossiers | 17 | 17060000108590 | 17060000108591 | 1 | 0 | PA721984 | rapporteur | ||
| 17060000108593 | L17/dossiers | 17 | 17060000108590 | 17060000108591 | 2 | 0 | PO59051 | |||
| 17060000108598 | L17/dossiers | 17 | 17060000108596 | 17060000108597 | 1 | 0 | PA719024 | rapporteur | ||
| 17060000108599 | L17/dossiers | 17 | 17060000108596 | 17060000108597 | 2 | 0 | PO419604 | |||
| 17060000108608 | L17/dossiers | 17 | 17060000108606 | 17060000108607 | 1 | 0 | PA267318 | rapporteur | ||
| 17060000108609 | L17/dossiers | 17 | 17060000108606 | 17060000108607 | 2 | 0 | PO420120 | |||
| 17060000108614 | L17/dossiers | 17 | 17060000108612 | 17060000108613 | 1 | 0 | PA805166 | rapporteur | ||
| 17060000108615 | L17/dossiers | 17 | 17060000108612 | 17060000108613 | 2 | 0 | PO419865 | |||
| 17060000108620 | L17/dossiers | 17 | 17060000108618 | 17060000108619 | 1 | 0 | PA722374 | rapporteur | ||
| 17060000108621 | L17/dossiers | 17 | 17060000108618 | 17060000108619 | 2 | 0 | PO420120 | |||
| 17060000108626 | L17/dossiers | 17 | 17060000108624 | 17060000108625 | 1 | 0 | PA721296 | rapporteur |