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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 17060000109841 | L17/dossiers | 17 | 17060000109837 | 17060000109837 | 3 | PA720066 | 2026-05-27 | True | |||
| 17060000109845 | L17/dossiers | 17 | 17060000109843 | 17060000109843 | 1 | PA873624 | 2026-05-27 | True | |||
| 17060000109846 | L17/dossiers | 17 | 17060000109843 | 17060000109843 | 2 | PA720066 | 2026-05-27 | True | |||
| 17060000109847 | L17/dossiers | 17 | 17060000109843 | 17060000109843 | 3 | PA795950 | 2026-05-27 | True | |||
| 17060000109864 | L17/dossiers | 17 | 17060000109862 | 17060000109862 | 1 | PA842117 | 2026-06-24 | True | |||
| 17060000109887 | L17/dossiers | 17 | 17060000109885 | 17060000109885 | 1 | PA721134 | 2026-10-01 | True | |||
| 17060000109888 | L17/dossiers | 17 | 17060000109885 | 17060000109885 | 2 | PA795950 | 2026-10-01 | True | |||
| 17060000109899 | L17/dossiers | 17 | 17060000109897 | 17060000109897 | 1 | PA873624 | 2026-10-01 | True | |||
| 17060000109900 | L17/dossiers | 17 | 17060000109897 | 17060000109897 | 2 | PA795950 | 2026-10-01 | True | |||
| 17060000109901 | L17/dossiers | 17 | 17060000109897 | 17060000109897 | 3 | PA720066 | 2026-10-01 | True | |||
| 17060000109927 | L17/dossiers | 17 | 17060000109925 | 17060000109925 | 1 | PA721134 | 2026-11-04 | True | |||
| 17060000109928 | L17/dossiers | 17 | 17060000109925 | 17060000109925 | 2 | PA795950 | 2026-11-04 | True | |||
| 17060000110570 | L17/dossiers | 17 | 17060000110568 | 17060000110568 | 1 | PA312976 | 2022-06-15 | True | |||
| 17060000110587 | L17/dossiers | 17 | 17060000110585 | 17060000110585 | 1 | PA842137 | 2024-03-13 | True | |||
| 17060000110592 | L17/dossiers | 17 | 17060000110590 | 17060000110590 | 1 | PA842137 | 2024-04-17 | True | |||
| 17060000110595 | L17/dossiers | 17 | 17060000110593 | 17060000110593 | 1 | PA842137 | 2024-04-17 | True | |||
| 17060000110598 | L17/dossiers | 17 | 17060000110596 | 17060000110596 | 1 | PA331481 | 2024-04-24 | True | |||
| 17060000110605 | L17/dossiers | 17 | 17060000110603 | 17060000110603 | 1 | PA842137 | 2024-06-12 | True | |||
| 17060000110645 | L17/dossiers | 17 | 17060000110643 | 17060000110643 | 1 | PA795144 | 2024-10-15 | True | |||
| 17060000110646 | L17/dossiers | 17 | 17060000110643 | 17060000110643 | 2 | PA608416 | 2024-10-15 | True | |||
| 17060000110651 | L17/dossiers | 17 | 17060000110649 | 17060000110649 | 1 | PA2189 | 2024-10-23 | True | |||
| 17060000110654 | L17/dossiers | 17 | 17060000110652 | 17060000110652 | 1 | PA2189 | 2024-10-23 | True | |||
| 17060000110657 | L17/dossiers | 17 | 17060000110655 | 17060000110655 | 1 | PA721836 | 2024-10-31 | True | |||
| 17060000110666 | L17/dossiers | 17 | 17060000110664 | 17060000110664 | 1 | PA721836 | 2024-11-27 | True | |||
| 17060000110669 | L17/dossiers | 17 | 17060000110667 | 17060000110667 | 1 | PA795050 | 2024-12-11 | True | |||
| 17060000110670 | L17/dossiers | 17 | 17060000110667 | 17060000110667 | 2 | PA303997 | 2024-12-11 | True | |||
| 17060000110675 | L17/dossiers | 17 | 17060000110673 | 17060000110673 | 1 | PA855045 | 2025-01-08 | True | |||
| 17060000110678 | L17/dossiers | 17 | 17060000110676 | 17060000110676 | 1 | PA721836 | 2025-01-08 | True | |||
| 17060000110683 | L17/dossiers | 17 | 17060000110681 | 17060000110681 | 1 | PA855045 | 2025-01-29 | True | |||
| 17060000110688 | L17/dossiers | 17 | 17060000110686 | 17060000110686 | 1 | PA721836 | 2025-02-13 | True | |||
| 17060000110695 | L17/dossiers | 17 | 17060000110693 | 17060000110693 | 1 | PA721836 | 2025-03-26 | True | |||
| 17060000110702 | L17/dossiers | 17 | 17060000110700 | 17060000110700 | 1 | PA267622 | 2025-04-22 | True | |||
| 17060000110705 | L17/dossiers | 17 | 17060000110703 | 17060000110703 | 1 | PA267622 | 2025-04-22 | True | |||
| 17060000110708 | L17/dossiers | 17 | 17060000110706 | 17060000110706 | 1 | PA717161 | 2025-04-22 | True | |||
| 17060000110709 | L17/dossiers | 17 | 17060000110706 | 17060000110706 | 2 | PA267622 | 2025-04-22 | True | |||
| 17060000110712 | L17/dossiers | 17 | 17060000110710 | 17060000110710 | 1 | PA415496 | 2025-04-28 | True | |||
| 17060000110715 | L17/dossiers | 17 | 17060000110713 | 17060000110713 | 1 | PA721836 | 2025-04-28 | True | |||
| 17060000110718 | L17/dossiers | 17 | 17060000110716 | 17060000110716 | 1 | PA267797 | 2025-05-07 | True | |||
| 17060000110721 | L17/dossiers | 17 | 17060000110719 | 17060000110719 | 1 | PA721836 | 2025-05-15 | True | |||
| 17060000110724 | L17/dossiers | 17 | 17060000110722 | 17060000110722 | 1 | PA855047 | 2025-05-15 | True | |||
| 17060000110729 | L17/dossiers | 17 | 17060000110727 | 17060000110727 | 1 | PA607846 | 2025-05-23 | True | |||
| 17060000110732 | L17/dossiers | 17 | 17060000110730 | 17060000110730 | 1 | PA855045 | 2025-06-04 | True | |||
| 17060000110741 | L17/dossiers | 17 | 17060000110739 | 17060000110739 | 1 | PA721836 | 2025-06-19 | True | |||
| 17060000110750 | L17/dossiers | 17 | 17060000110748 | 17060000110748 | 1 | PA267622 | 2025-07-02 | True | |||
| 17060000110751 | L17/dossiers | 17 | 17060000110748 | 17060000110748 | 2 | PA415496 | 2025-07-02 | True | |||
| 17060000110758 | L17/dossiers | 17 | 17060000110756 | 17060000110756 | 1 | PA721836 | 2025-07-11 | True | |||
| 17060000110761 | L17/dossiers | 17 | 17060000110759 | 17060000110759 | 1 | PA721836 | 2025-07-16 | True | |||
| 17060000110764 | L17/dossiers | 17 | 17060000110762 | 17060000110762 | 1 | PA415496 | 2025-07-30 | True | |||
| 17060000110767 | L17/dossiers | 17 | 17060000110765 | 17060000110765 | 1 | PA267622 | 2025-07-30 | True | |||
| 17060000110770 | L17/dossiers | 17 | 17060000110768 | 17060000110768 | 1 | PA387829 | 2025-07-30 | True |