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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 17060000007503 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 124 | PA841223 | 2025-03-12 | False | |||
| 17060000007504 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 125 | PA795516 | 2025-03-12 | False | |||
| 17060000007505 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 126 | PA721984 | 2025-03-12 | False | |||
| 17060000007506 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 127 | PA720022 | 2025-03-12 | False | |||
| 17060000007507 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 128 | PA719412 | 2025-03-12 | False | |||
| 17060000007508 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 129 | PA719404 | 2025-03-12 | False | |||
| 17060000007509 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 130 | PA795672 | 2025-03-12 | False | |||
| 17060000007510 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 131 | PA719388 | 2025-03-12 | False | |||
| 17060000007511 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 132 | PA719756 | 2025-03-12 | False | |||
| 17060000007512 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 133 | PA720342 | 2025-03-12 | False | |||
| 17060000007513 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 134 | PA795746 | 2025-03-12 | False | |||
| 17060000007514 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 135 | PA774962 | 2025-03-12 | False | |||
| 17060000007515 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 136 | PA795108 | 2025-03-12 | False | |||
| 17060000007516 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 137 | PA795374 | 2025-03-12 | False | |||
| 17060000007517 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 138 | PA335612 | 2025-03-12 | False | |||
| 17060000007518 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 139 | PA841515 | 2025-03-12 | False | |||
| 17060000007519 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 140 | PA791824 | 2025-03-12 | False | |||
| 17060000007520 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 141 | PA842029 | 2025-03-12 | False | |||
| 17060000007521 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 142 | PA793532 | 2025-03-12 | False | |||
| 17060000007522 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 143 | PA721134 | 2025-03-12 | False | |||
| 17060000007523 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 144 | PA774958 | 2025-03-12 | False | |||
| 17060000007524 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 145 | PA841601 | 2025-03-12 | False | |||
| 17060000007525 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 146 | PA840765 | 2025-03-12 | False | |||
| 17060000007526 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 147 | PA794702 | 2025-03-12 | False | |||
| 17060000007527 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 148 | PA720446 | 2025-03-12 | False | |||
| 17060000007528 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 149 | PA795636 | 2025-03-12 | False | |||
| 17060000007529 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 150 | PA720230 | 2025-03-12 | False | |||
| 17060000007530 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 151 | PA795730 | 2025-03-12 | False | |||
| 17060000007531 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 152 | PA794206 | 2025-03-12 | False | |||
| 17060000007532 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 153 | PA794518 | 2025-03-12 | False | |||
| 17060000007533 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 154 | PA719080 | 2025-03-12 | False | |||
| 17060000007534 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 155 | PA342384 | 2025-03-12 | False | |||
| 17060000007535 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 156 | PA795100 | 2025-03-12 | False | |||
| 17060000007536 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 157 | PA720146 | 2025-03-12 | False | |||
| 17060000007537 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 158 | PA720728 | 2025-03-12 | False | |||
| 17060000007538 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 159 | PA795422 | 2025-03-12 | False | |||
| 17060000007539 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 160 | PA794686 | 2025-03-12 | False | |||
| 17060000007540 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 161 | PA841931 | 2025-03-12 | False | |||
| 17060000007541 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 162 | PA719338 | 2025-03-12 | False | |||
| 17060000007542 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 163 | PA720370 | 2025-03-12 | False | |||
| 17060000007543 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 164 | PA841463 | 2025-03-12 | False | |||
| 17060000007544 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 165 | PA841215 | 2025-03-12 | False | |||
| 17060000007545 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 166 | PA719640 | 2025-03-12 | False | |||
| 17060000007546 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 167 | PA719272 | 2025-03-12 | False | |||
| 17060000007547 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 168 | PA795482 | 2025-03-12 | False | |||
| 17060000007548 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 169 | PA794466 | 2025-03-12 | False | |||
| 17060000007549 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 170 | PA841167 | 2024-10-09 | 2024-10-10 | False | ||
| 17060000007550 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 171 | PA841191 | 2025-03-12 | False | |||
| 17060000007551 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 172 | PA841107 | 2025-03-12 | False | |||
| 17060000007552 | L17/dossiers | 17 | 17060000007378 | 17060000007378 | 173 | PA721960 | 2025-03-12 | False |