dossiers.document_co_signataire
Chemin document.coSignataires.coSignataire · présence : L17 26 %, L16 26 %, L15 28 %, L14 29 %
309 313 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.coSignataires.coSignataire.acteur.acteurRef · présence : L17 26 %, L16 26 %, L15 28 %, L14 29 % |
| 8 | date_cosignature | DATE | document.coSignataires.coSignataire.dateCosignature · présence : L17 26 %, L16 26 %, L15 28 %, L14 29 % |
| 9 | date_retrait_cosignature | DATE | document.coSignataires.coSignataire.dateRetraitCosignature · présence : L17 26 %, L16 26 %, L15 28 %, L14 29 % |
| 10 | edite | BOOLEAN | document.coSignataires.coSignataire.edite · présence : L17 26 %, L16 26 %, L15 28 %, L14 29 % |
| 11 | organe_organe_ref | VARCHAR | document.coSignataires.coSignataire.organe.organeRef · présence : L17 0 %, L16 1 %, L15 1 %, L14 2 % |
| 12 | organe_et_apparentes | BOOLEAN | document.coSignataires.coSignataire.organe.etApparentes · présence : L17 0 %, L16 1 %, L15 1 %, L14 2 % |
Aperçu
| _id | _source | _legislature | _racine_id | _parent_id | _ordre | acteur_acteur_ref | date_cosignature | date_retrait_cosignature | edite | organe_organe_ref | organe_et_apparentes |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 17060000111145 | L17/dossiers | 17 | 17060000111143 | 17060000111143 | 1 | PA873625 | 2026-07-09 | True | |||
| 17060000111152 | L17/dossiers | 17 | 17060000111150 | 17060000111150 | 1 | PA759834 | 2026-07-22 | True | |||
| 17060000111155 | L17/dossiers | 17 | 17060000111153 | 17060000111153 | 1 | PA720908 | 2026-07-22 | True | |||
| 17060000111158 | L17/dossiers | 17 | 17060000111156 | 17060000111156 | 1 | PA721836 | 2026-07-27 | True | |||
| 17060000111161 | L17/dossiers | 17 | 17060000111159 | 17060000111159 | 1 | PA721836 | 2026-07-27 | True | |||
| 17060000111164 | L17/dossiers | 17 | 17060000111162 | 17060000111162 | 1 | PA873624 | 2026-09-10 | True | |||
| 17060000111165 | L17/dossiers | 17 | 17060000111162 | 17060000111162 | 2 | PA795950 | 2026-09-10 | True | |||
| 17060000111168 | L17/dossiers | 17 | 17060000111166 | 17060000111166 | 1 | PA721836 | 2026-09-16 | True | |||
| 17060000111171 | L17/dossiers | 17 | 17060000111169 | 17060000111169 | 1 | PA759834 | 2026-09-16 | True | |||
| 17060000111172 | L17/dossiers | 17 | 17060000111169 | 17060000111169 | 2 | PA607846 | 2026-09-16 | True | |||
| 17060000111173 | L17/dossiers | 17 | 17060000111169 | 17060000111169 | 3 | PA720066 | 2026-09-16 | True | |||
| 17060000111176 | L17/dossiers | 17 | 17060000111174 | 17060000111174 | 1 | PA720908 | 2026-09-16 | True | |||
| 17060000111452 | L17/dossiers | 17 | 17060000111450 | 17060000111450 | 1 | PA721134 | 2026-10-14 | True | |||
| 17060000111455 | L17/dossiers | 17 | 17060000111453 | 17060000111453 | 1 | PA721134 | 2026-10-14 | True | |||
| 17060000111458 | L17/dossiers | 17 | 17060000111456 | 17060000111456 | 1 | PA721836 | 2026-10-22 | True | |||
| 17060000111461 | L17/dossiers | 17 | 17060000111459 | 17060000111459 | 1 | PA721836 | 2026-10-22 | True | |||
| 16060000000622 | L16/dossiers | 16 | 16060000000620 | 16060000000620 | 1 | PA331481 | 2022-10-19 | True | |||
| 16060000000623 | L16/dossiers | 16 | 16060000000620 | 16060000000620 | 2 | PA722190 | 2022-10-19 | True | |||
| 16060000000626 | L16/dossiers | 16 | 16060000000624 | 16060000000624 | 1 | PA331481 | 2022-11-02 | True | |||
| 16060000000627 | L16/dossiers | 16 | 16060000000624 | 16060000000624 | 2 | PA722190 | 2022-11-02 | True | |||
| 16060000000630 | L16/dossiers | 16 | 16060000000628 | 16060000000628 | 1 | PA722190 | 2022-10-20 | True | |||
| 16060000000631 | L16/dossiers | 16 | 16060000000628 | 16060000000628 | 2 | PA331481 | 2022-10-20 | True | |||
| 16060000000632 | L16/dossiers | 16 | 16060000000628 | 16060000000628 | 3 | PA801862 | 2022-10-20 | True | |||
| 16060000000635 | L16/dossiers | 16 | 16060000000633 | 16060000000633 | 1 | PA722190 | 2022-10-26 | True | |||
| 16060000000636 | L16/dossiers | 16 | 16060000000633 | 16060000000633 | 2 | PA331481 | 2022-10-26 | True | |||
| 16060000000637 | L16/dossiers | 16 | 16060000000633 | 16060000000633 | 3 | PA801862 | 2022-10-26 | True | |||
| 16060000000658 | L16/dossiers | 16 | 16060000000656 | 16060000000656 | 1 | PA331481 | 2023-10-18 | True | |||
| 16060000000659 | L16/dossiers | 16 | 16060000000656 | 16060000000656 | 2 | PA793940 | 2023-10-18 | True | |||
| 16060000000662 | L16/dossiers | 16 | 16060000000660 | 16060000000660 | 1 | PA331481 | 2023-11-07 | True | |||
| 16060000000663 | L16/dossiers | 16 | 16060000000660 | 16060000000660 | 2 | PA793940 | 2023-11-07 | True | |||
| 16060000000666 | L16/dossiers | 16 | 16060000000664 | 16060000000664 | 1 | PA331481 | 2023-10-25 | True | |||
| 16060000000667 | L16/dossiers | 16 | 16060000000664 | 16060000000664 | 2 | PA826635 | 2023-10-25 | True | |||
| 16060000000668 | L16/dossiers | 16 | 16060000000664 | 16060000000664 | 3 | PA793940 | 2023-10-25 | True | |||
| 16060000000671 | L16/dossiers | 16 | 16060000000669 | 16060000000669 | 1 | PA331481 | 2023-10-30 | True | |||
| 16060000000672 | L16/dossiers | 16 | 16060000000669 | 16060000000669 | 2 | PA826635 | 2023-10-30 | True | |||
| 16060000000673 | L16/dossiers | 16 | 16060000000669 | 16060000000669 | 3 | PA793940 | 2023-10-30 | True | |||
| 16060000001521 | L16/dossiers | 16 | 16060000001519 | 16060000001519 | 1 | PA331481 | 2022-09-26 | True | |||
| 16060000001522 | L16/dossiers | 16 | 16060000001519 | 16060000001519 | 2 | PA722190 | 2022-09-26 | True | |||
| 16060000001533 | L16/dossiers | 16 | 16060000001531 | 16060000001531 | 1 | PA331481 | 2022-09-26 | True | |||
| 16060000001534 | L16/dossiers | 16 | 16060000001531 | 16060000001531 | 2 | PA722190 | 2022-09-26 | True | |||
| 16060000001545 | L16/dossiers | 16 | 16060000001543 | 16060000001543 | 1 | PA331481 | 2022-09-26 | True | |||
| 16060000001546 | L16/dossiers | 16 | 16060000001543 | 16060000001543 | 2 | PA722190 | 2022-09-26 | True | |||
| 16060000001557 | L16/dossiers | 16 | 16060000001555 | 16060000001555 | 1 | PA722190 | 2022-09-26 | True | |||
| 16060000001558 | L16/dossiers | 16 | 16060000001555 | 16060000001555 | 2 | PA331481 | 2022-09-26 | True | |||
| 16060000001559 | L16/dossiers | 16 | 16060000001555 | 16060000001555 | 3 | PA801862 | 2022-09-26 | True | |||
| 16060000001564 | L16/dossiers | 16 | 16060000001562 | 16060000001562 | 1 | PA722190 | 2022-09-26 | True | |||
| 16060000001565 | L16/dossiers | 16 | 16060000001562 | 16060000001562 | 2 | PA331481 | 2022-09-26 | True | |||
| 16060000001566 | L16/dossiers | 16 | 16060000001562 | 16060000001562 | 3 | PA801862 | 2022-09-26 | True | |||
| 16060000001571 | L16/dossiers | 16 | 16060000001569 | 16060000001569 | 1 | PA722190 | 2022-09-26 | True | |||
| 16060000001572 | L16/dossiers | 16 | 16060000001569 | 16060000001569 | 2 | PA331481 | 2022-09-26 | True |