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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 17060000109419 | L17/dossiers | 17 | 17060000109417 | 17060000109417 | 1 | PA719938 | 2024-04-03 | True | |||
| 17060000109428 | L17/dossiers | 17 | 17060000109426 | 17060000109426 | 1 | PA842137 | 2024-05-16 | True | |||
| 17060000109487 | L17/dossiers | 17 | 17060000109485 | 17060000109485 | 1 | PA331481 | 2024-07-19 | True | |||
| 17060000109488 | L17/dossiers | 17 | 17060000109485 | 17060000109485 | 2 | PA793940 | 2024-07-19 | True | |||
| 17060000109492 | L17/dossiers | 17 | 17060000109490 | 17060000109490 | 1 | PA793940 | 2024-07-19 | True | |||
| 17060000109493 | L17/dossiers | 17 | 17060000109490 | 17060000109490 | 2 | PA331481 | 2024-07-19 | True | |||
| 17060000109498 | L17/dossiers | 17 | 17060000109496 | 17060000109496 | 1 | PA795144 | 2024-10-01 | True | |||
| 17060000109502 | L17/dossiers | 17 | 17060000109500 | 17060000109500 | 1 | PA795144 | 2024-10-10 | True | |||
| 17060000109503 | L17/dossiers | 17 | 17060000109500 | 17060000109500 | 2 | PA720878 | 2024-10-10 | True | |||
| 17060000109514 | L17/dossiers | 17 | 17060000109512 | 17060000109512 | 1 | PA719914 | 2024-10-10 | True | |||
| 17060000109515 | L17/dossiers | 17 | 17060000109512 | 17060000109512 | 2 | PA642868 | 2024-10-10 | True | |||
| 17060000109516 | L17/dossiers | 17 | 17060000109512 | 17060000109512 | 3 | PA720878 | 2024-10-10 | True | |||
| 17060000109524 | L17/dossiers | 17 | 17060000109522 | 17060000109522 | 1 | PA795144 | 2024-10-31 | True | |||
| 17060000109538 | L17/dossiers | 17 | 17060000109536 | 17060000109536 | 1 | PA795144 | 2024-11-06 | True | |||
| 17060000109539 | L17/dossiers | 17 | 17060000109536 | 17060000109536 | 2 | PA720878 | 2024-11-06 | True | |||
| 17060000109552 | L17/dossiers | 17 | 17060000109550 | 17060000109550 | 1 | PA2538 | 2024-11-22 | True | |||
| 17060000109553 | L17/dossiers | 17 | 17060000109550 | 17060000109550 | 2 | PA721836 | 2024-11-22 | True | |||
| 17060000109564 | L17/dossiers | 17 | 17060000109562 | 17060000109562 | 1 | PA795144 | 2024-12-11 | True | |||
| 17060000109565 | L17/dossiers | 17 | 17060000109562 | 17060000109562 | 2 | PA720878 | 2024-12-11 | True | |||
| 17060000109569 | L17/dossiers | 17 | 17060000109567 | 17060000109567 | 1 | PA267622 | 2025-01-08 | True | |||
| 17060000109573 | L17/dossiers | 17 | 17060000109571 | 17060000109571 | 1 | PA607846 | 2025-01-08 | True | |||
| 17060000109577 | L17/dossiers | 17 | 17060000109575 | 17060000109575 | 1 | PA855045 | 2025-01-15 | True | |||
| 17060000109581 | L17/dossiers | 17 | 17060000109579 | 17060000109579 | 1 | PA721836 | 2025-01-22 | True | |||
| 17060000109603 | L17/dossiers | 17 | 17060000109601 | 17060000109601 | 1 | PA721836 | 2025-03-05 | True | |||
| 17060000109619 | L17/dossiers | 17 | 17060000109617 | 17060000109617 | 1 | PA721836 | 2025-03-19 | True | |||
| 17060000109629 | L17/dossiers | 17 | 17060000109627 | 17060000109627 | 1 | PA721836 | 2025-05-15 | True | |||
| 17060000109640 | L17/dossiers | 17 | 17060000109638 | 17060000109638 | 1 | PA267797 | 2025-05-23 | True | |||
| 17060000109641 | L17/dossiers | 17 | 17060000109638 | 17060000109638 | 2 | PA855045 | 2025-05-23 | True | |||
| 17060000109642 | L17/dossiers | 17 | 17060000109638 | 17060000109638 | 3 | PA721670 | 2025-05-23 | True | |||
| 17060000109658 | L17/dossiers | 17 | 17060000109656 | 17060000109656 | 1 | PA721836 | 2025-06-04 | True | |||
| 17060000109683 | L17/dossiers | 17 | 17060000109681 | 17060000109681 | 1 | PA721836 | 2025-07-02 | True | |||
| 17060000109687 | L17/dossiers | 17 | 17060000109685 | 17060000109685 | 1 | PA717161 | 2025-07-30 | True | |||
| 17060000109688 | L17/dossiers | 17 | 17060000109685 | 17060000109685 | 2 | PA855049 | 2025-07-30 | True | |||
| 17060000109692 | L17/dossiers | 17 | 17060000109690 | 17060000109690 | 1 | PA721134 | 2025-10-14 | True | |||
| 17060000109693 | L17/dossiers | 17 | 17060000109690 | 17060000109690 | 2 | PA721670 | 2025-10-14 | True | |||
| 17060000109704 | L17/dossiers | 17 | 17060000109702 | 17060000109702 | 1 | PA720066 | 2025-10-14 | True | |||
| 17060000109705 | L17/dossiers | 17 | 17060000109702 | 17060000109702 | 2 | PA721670 | 2025-10-14 | True | |||
| 17060000109706 | L17/dossiers | 17 | 17060000109702 | 17060000109702 | 3 | PA873624 | 2025-10-14 | True | |||
| 17060000109714 | L17/dossiers | 17 | 17060000109712 | 17060000109712 | 1 | PA721836 | 2025-10-29 | True | |||
| 17060000109725 | L17/dossiers | 17 | 17060000109723 | 17060000109723 | 1 | PA721134 | 2025-11-10 | True | |||
| 17060000109726 | L17/dossiers | 17 | 17060000109723 | 17060000109723 | 2 | PA721670 | 2025-11-10 | True | |||
| 17060000109740 | L17/dossiers | 17 | 17060000109738 | 17060000109738 | 1 | PA721836 | 2025-12-02 | True | |||
| 17060000109751 | L17/dossiers | 17 | 17060000109749 | 17060000109749 | 1 | PA721134 | 2025-12-22 | True | |||
| 17060000109768 | L17/dossiers | 17 | 17060000109766 | 17060000109766 | 1 | PA721836 | 2026-02-11 | True | |||
| 17060000109797 | L17/dossiers | 17 | 17060000109795 | 17060000109795 | 1 | PA267797 | 2026-04-08 | True | |||
| 17060000109804 | L17/dossiers | 17 | 17060000109802 | 17060000109802 | 1 | PA605991 | 2026-04-08 | True | |||
| 17060000109821 | L17/dossiers | 17 | 17060000109819 | 17060000109819 | 1 | PA870010 | 2026-04-22 | True | |||
| 17060000109825 | L17/dossiers | 17 | 17060000109823 | 17060000109823 | 1 | PA266795 | 2026-04-27 | True | |||
| 17060000109839 | L17/dossiers | 17 | 17060000109837 | 17060000109837 | 1 | PA607846 | 2026-05-27 | True | |||
| 17060000109840 | L17/dossiers | 17 | 17060000109837 | 17060000109837 | 2 | PA873627 | 2026-05-27 | True |