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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 16060000003459 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 196 | PA720414 | 2022-01-11 | False | |||
| 16060000003460 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 197 | PA721568 | 2022-01-11 | False | |||
| 16060000003461 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 198 | PA718930 | 2022-01-11 | False | |||
| 16060000003462 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 199 | PA722090 | 2022-01-11 | False | |||
| 16060000003463 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 200 | PA718736 | 2022-01-11 | False | |||
| 16060000003464 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 201 | PA721710 | 2022-01-11 | False | |||
| 16060000003465 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 202 | PA721372 | 2022-01-11 | False | |||
| 16060000003466 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 203 | PA721844 | 2022-01-11 | False | |||
| 16060000003467 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 204 | PA718910 | 2022-01-11 | False | |||
| 16060000003468 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 205 | PA2449 | 2022-01-11 | False | |||
| 16060000003469 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 206 | PA719528 | 2022-01-11 | False | |||
| 16060000003470 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 207 | PA719600 | 2022-01-11 | False | |||
| 16060000003471 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 208 | PA721916 | 2022-01-11 | False | |||
| 16060000003472 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 209 | PA722194 | 2022-01-11 | False | |||
| 16060000003473 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 210 | PA643127 | 2022-01-11 | False | |||
| 16060000003474 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 211 | PA718944 | 2022-01-11 | False | |||
| 16060000003475 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 212 | PA721888 | 2022-01-11 | False | |||
| 16060000003476 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 213 | PA720552 | 2022-01-11 | False | |||
| 16060000003477 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 214 | PA722398 | 2022-01-11 | False | |||
| 16060000003478 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 215 | PA721824 | 2022-01-11 | False | |||
| 16060000003479 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 216 | PA720900 | 2022-01-11 | False | |||
| 16060000003480 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 217 | PA721426 | 2022-01-11 | False | |||
| 16060000003481 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 218 | PA720066 | 2022-01-11 | False | |||
| 16060000003482 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 219 | PA722252 | 2022-01-11 | False | |||
| 16060000003483 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 220 | PA718810 | 2022-01-11 | False | |||
| 16060000003484 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 221 | PA722022 | 2022-01-11 | False | |||
| 16060000003485 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 222 | PA721538 | 2022-01-11 | False | |||
| 16060000003486 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 223 | PA721458 | 2022-01-11 | False | |||
| 16060000003487 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 224 | PA721600 | 2022-01-11 | False | |||
| 16060000003488 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 225 | PA343493 | 2022-01-11 | False | |||
| 16060000003489 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 226 | PA718902 | 2022-01-11 | False | |||
| 16060000003490 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 227 | PA722292 | 2022-01-11 | False | |||
| 16060000003491 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 228 | PA332747 | 2022-01-11 | False | |||
| 16060000003492 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 229 | PA721616 | 2022-01-11 | False | |||
| 16060000003493 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 230 | PA720878 | 2022-01-11 | False | |||
| 16060000003494 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 231 | PA720138 | 2022-01-11 | False | |||
| 16060000003495 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 232 | PA719972 | 2022-01-11 | False | |||
| 16060000003496 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 233 | PA720780 | 2022-01-11 | False | |||
| 16060000003497 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 234 | PA720960 | 2022-01-11 | False | |||
| 16060000003498 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 235 | PA721768 | 2022-01-11 | False | |||
| 16060000003499 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 236 | PA346876 | 2022-01-11 | False | |||
| 16060000003500 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 237 | PA719420 | 2022-01-11 | False | |||
| 16060000003501 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 238 | PA720190 | 2022-01-11 | False | |||
| 16060000003502 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 239 | PA720754 | 2022-01-11 | False | |||
| 16060000003503 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 240 | PA722118 | 2022-01-11 | False | |||
| 16060000003504 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 241 | PA719350 | 2022-01-11 | False | |||
| 16060000003505 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 242 | PA721690 | 2022-01-11 | False | |||
| 16060000003506 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 243 | PA719550 | 2022-01-11 | False | |||
| 16060000003507 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 244 | PA720246 | 2022-01-11 | False | |||
| 16060000003508 | L16/dossiers | 16 | 16060000003262 | 16060000003262 | 245 | PA721584 | 2022-01-11 | False |