dossiers.document_co_signataire
Chemin document.coSignataires.coSignataire · présence : L17 26 %, L16 26 %, L15 28 %, L14 29 %
305 264 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 17060000017425 | L17/dossiers | 17 | 17060000017309 | 17060000017309 | 115 | PA841633 | 2024-11-07 | False | |||
| 17060000017426 | L17/dossiers | 17 | 17060000017309 | 17060000017309 | 116 | PA842195 | 2024-11-07 | False | |||
| 17060000017427 | L17/dossiers | 17 | 17060000017309 | 17060000017309 | 117 | PA609332 | 2024-11-07 | False | |||
| 17060000017428 | L17/dossiers | 17 | 17060000017309 | 17060000017309 | 118 | PA841665 | 2024-11-07 | False | |||
| 17060000017429 | L17/dossiers | 17 | 17060000017309 | 17060000017309 | 119 | PA333285 | 2024-11-07 | False | |||
| 17060000017430 | L17/dossiers | 17 | 17060000017309 | 17060000017309 | 120 | PA840939 | 2024-11-07 | False | |||
| 17060000017431 | L17/dossiers | 17 | 17060000017309 | 17060000017309 | 121 | PA841539 | 2024-11-07 | False | |||
| 17060000017432 | L17/dossiers | 17 | 17060000017309 | 17060000017309 | 122 | PA331973 | 2024-11-07 | False | |||
| 17060000017433 | L17/dossiers | 17 | 17060000017309 | 17060000017309 | 123 | PA840171 | 2024-11-07 | False | |||
| 17060000017434 | L17/dossiers | 17 | 17060000017309 | 17060000017309 | 124 | PA1567 | 2024-11-07 | False | |||
| 17060000017435 | L17/dossiers | 17 | 17060000017309 | 17060000017309 | 125 | PA841471 | 2024-11-07 | False | |||
| 17060000017436 | L17/dossiers | 17 | 17060000017309 | 17060000017309 | 126 | PA842263 | 2024-11-07 | False | |||
| 17060000017437 | L17/dossiers | 17 | 17060000017309 | 17060000017309 | 127 | PA841813 | 2024-11-07 | False | |||
| 17060000017438 | L17/dossiers | 17 | 17060000017309 | 17060000017309 | 128 | PA841853 | 2024-11-07 | False | |||
| 17060000017439 | L17/dossiers | 17 | 17060000017309 | 17060000017309 | 129 | PA1654 | 2024-11-07 | False | |||
| 17060000017440 | L17/dossiers | 17 | 17060000017309 | 17060000017309 | 130 | PA643192 | 2024-11-07 | False | |||
| 17060000017441 | L17/dossiers | 17 | 17060000017309 | 17060000017309 | 131 | PA335054 | 2024-11-07 | False | |||
| 17060000017442 | L17/dossiers | 17 | 17060000017309 | 17060000017309 | 132 | PA795156 | 2024-11-07 | False | |||
| 17060000017443 | L17/dossiers | 17 | 17060000017309 | 17060000017309 | 133 | PA774958 | 2024-11-07 | False | |||
| 17060000017444 | L17/dossiers | 17 | 17060000017309 | 17060000017309 | 134 | PA840765 | 2024-11-07 | False | |||
| 17060000017445 | L17/dossiers | 17 | 17060000017309 | 17060000017309 | 135 | PA841463 | 2024-11-07 | False | |||
| 17060000017446 | L17/dossiers | 17 | 17060000017309 | 17060000017309 | 136 | PA643157 | 2024-11-07 | False | |||
| 17060000017447 | L17/dossiers | 17 | 17060000017309 | 17060000017309 | 137 | PA841107 | 2024-11-07 | False | |||
| 17060000017448 | L17/dossiers | 17 | 17060000017309 | 17060000017309 | 138 | PA841381 | 2024-11-07 | False | |||
| 17060000017449 | L17/dossiers | 17 | 17060000017309 | 17060000017309 | 139 | PA840793 | 2024-11-07 | False | |||
| 17060000017450 | L17/dossiers | 17 | 17060000017309 | 17060000017309 | 140 | PA794270 | 2024-11-07 | False | |||
| 17060000017451 | L17/dossiers | 17 | 17060000017309 | 17060000017309 | 141 | PA608172 | 2024-11-07 | False | |||
| 17060000017452 | L17/dossiers | 17 | 17060000017309 | 17060000017309 | 142 | PA607553 | 2024-11-07 | False | |||
| 17060000017453 | L17/dossiers | 17 | 17060000017309 | 17060000017309 | 143 | PA840955 | 2024-11-07 | False | |||
| 17060000017454 | L17/dossiers | 17 | 17060000017309 | 17060000017309 | 144 | PA841367 | 2024-11-07 | False | |||
| 17060000017455 | L17/dossiers | 17 | 17060000017309 | 17060000017309 | 145 | PA341981 | 2024-11-07 | False | |||
| 17060000017456 | L17/dossiers | 17 | 17060000017309 | 17060000017309 | 146 | PA840673 | 2024-11-07 | False | |||
| 17060000017457 | L17/dossiers | 17 | 17060000017309 | 17060000017309 | 147 | PA342196 | 2024-11-07 | False | |||
| 17060000017458 | L17/dossiers | 17 | 17060000017309 | 17060000017309 | 148 | PA826635 | 2024-11-07 | False | |||
| 17060000017459 | L17/dossiers | 17 | 17060000017309 | 17060000017309 | 149 | PA841327 | 2024-11-07 | False | |||
| 17060000017460 | L17/dossiers | 17 | 17060000017309 | 17060000017309 | 150 | PA841717 | 2024-11-07 | False | |||
| 17060000017461 | L17/dossiers | 17 | 17060000017309 | 17060000017309 | 151 | PA841243 | 2024-11-07 | False | |||
| 17060000017462 | L17/dossiers | 17 | 17060000017309 | 17060000017309 | 152 | PA774960 | 2024-11-07 | False | |||
| 17060000017463 | L17/dossiers | 17 | 17060000017309 | 17060000017309 | 153 | PA340343 | 2024-11-07 | False | |||
| 17060000017464 | L17/dossiers | 17 | 17060000017309 | 17060000017309 | 154 | PA841091 | 2024-11-07 | False | |||
| 17060000017465 | L17/dossiers | 17 | 17060000017309 | 17060000017309 | 155 | PA841681 | 2024-11-07 | False | |||
| 17060000017466 | L17/dossiers | 17 | 17060000017309 | 17060000017309 | 156 | PA841893 | 2024-11-07 | False | |||
| 17060000017467 | L17/dossiers | 17 | 17060000017309 | 17060000017309 | 157 | PA793816 | 2024-11-07 | False | |||
| 17060000017468 | L17/dossiers | 17 | 17060000017309 | 17060000017309 | 158 | PA794494 | 2024-11-07 | False | |||
| 17060000017469 | L17/dossiers | 17 | 17060000017309 | 17060000017309 | 159 | PA720992 | 2024-11-07 | False | |||
| 17060000017473 | L17/dossiers | 17 | 17060000017471 | 17060000017471 | 1 | PA795026 | 2025-03-12 | False | |||
| 17060000017474 | L17/dossiers | 17 | 17060000017471 | 17060000017471 | 2 | PA719218 | 2025-03-12 | False | |||
| 17060000017475 | L17/dossiers | 17 | 17060000017471 | 17060000017471 | 3 | PA794830 | 2025-03-12 | False | |||
| 17060000017476 | L17/dossiers | 17 | 17060000017471 | 17060000017471 | 4 | PA266797 | 2025-03-12 | False | |||
| 17060000017477 | L17/dossiers | 17 | 17060000017471 | 17060000017471 | 5 | PA795362 | 2025-03-12 | False |