dossiers.document_co_signataire
Chemin document.coSignataires.coSignataire · présence : L17 26 %, L16 26 %, L15 28 %, L14 29 %
305 151 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 25 %, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 17060000007453 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 74 | PA842195 | 2025-03-12 | False | |||
| 17060000007454 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 75 | PA794658 | 2025-03-12 | False | |||
| 17060000007455 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 76 | PA721896 | 2025-03-12 | False | |||
| 17060000007456 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 77 | PA609332 | 2025-03-12 | False | |||
| 17060000007457 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 78 | PA267042 | 2025-03-12 | False | |||
| 17060000007458 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 79 | PA841665 | 2025-03-12 | False | |||
| 17060000007459 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 80 | PA841251 | 2025-03-12 | False | |||
| 17060000007460 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 81 | PA794786 | 2025-03-12 | False | |||
| 17060000007461 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 82 | PA795884 | 2025-03-12 | False | |||
| 17060000007462 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 83 | PA794870 | 2025-03-12 | False | |||
| 17060000007463 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 84 | PA722134 | 2025-03-12 | False | |||
| 17060000007464 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 85 | PA793980 | 2025-03-12 | False | |||
| 17060000007465 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 86 | PA822617 | 2025-03-12 | False | |||
| 17060000007466 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 87 | PA722284 | 2025-03-12 | False | |||
| 17060000007467 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 88 | PA722366 | 2025-03-12 | False | |||
| 17060000007468 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 89 | PA796070 | 2025-03-12 | False | |||
| 17060000007469 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 90 | PA333285 | 2025-03-12 | False | |||
| 17060000007470 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 91 | PA718674 | 2025-03-12 | False | |||
| 17060000007471 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 92 | PA840939 | 2025-03-12 | False | |||
| 17060000007472 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 93 | PA841539 | 2025-03-12 | False | |||
| 17060000007473 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 94 | PA331973 | 2025-03-12 | False | |||
| 17060000007474 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 95 | PA721296 | 2025-03-12 | False | |||
| 17060000007475 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 96 | PA720560 | 2025-03-12 | False | |||
| 17060000007476 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 97 | PA840171 | 2025-03-12 | False | |||
| 17060000007477 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 98 | PA267318 | 2025-03-12 | False | |||
| 17060000007478 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 99 | PA1567 | 2025-03-12 | False | |||
| 17060000007479 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 100 | PA795310 | 2025-03-12 | False | |||
| 17060000007480 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 101 | PA794478 | 2025-03-12 | False | |||
| 17060000007481 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 102 | PA795258 | 2025-03-12 | False | |||
| 17060000007482 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 103 | PA842013 | 2025-03-12 | False | |||
| 17060000007483 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 104 | PA841471 | 2025-03-12 | False | |||
| 17060000007484 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 105 | PA842263 | 2025-03-12 | False | |||
| 17060000007485 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 106 | PA841947 | 2025-03-12 | False | |||
| 17060000007486 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 107 | PA722070 | 2025-03-12 | False | |||
| 17060000007487 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 108 | PA841813 | 2025-03-12 | False | |||
| 17060000007488 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 109 | PA840947 | 2025-03-12 | False | |||
| 17060000007489 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 110 | PA841853 | 2025-03-12 | False | |||
| 17060000007490 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 111 | PA794082 | 2025-03-12 | False | |||
| 17060000007491 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 112 | PA1654 | 2025-03-12 | False | |||
| 17060000007492 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 113 | PA722150 | 2025-03-12 | False | |||
| 17060000007493 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 114 | PA841017 | 2025-03-12 | False | |||
| 17060000007494 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 115 | PA794022 | 2025-03-12 | False | |||
| 17060000007495 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 116 | PA720038 | 2025-03-12 | False | |||
| 17060000007496 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 117 | PA643192 | 2025-03-12 | False | |||
| 17060000007497 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 118 | PA335054 | 2025-03-12 | False | |||
| 17060000007498 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 119 | PA719372 | 2025-03-12 | False | |||
| 17060000007499 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 120 | PA795156 | 2025-03-12 | False | |||
| 17060000007500 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 121 | PA794130 | 2025-03-12 | False | |||
| 17060000007501 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 122 | PA720846 | 2025-03-12 | False | |||
| 17060000007502 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 123 | PA794146 | 2025-03-12 | False |