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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 16060000006271 | L16/dossiers | 16 | 16060000006262 | 16060000006262 | 8 | PA720976 | 2022-09-20 | False | |||
| 16060000006272 | L16/dossiers | 16 | 16060000006262 | 16060000006262 | 9 | PA333421 | 2022-09-20 | False | |||
| 16060000006273 | L16/dossiers | 16 | 16060000006262 | 16060000006262 | 10 | PA794410 | 2022-09-20 | False | |||
| 16060000006274 | L16/dossiers | 16 | 16060000006262 | 16060000006262 | 11 | PA793892 | 2022-09-20 | False | |||
| 16060000006275 | L16/dossiers | 16 | 16060000006262 | 16060000006262 | 12 | PA720386 | 2022-09-20 | False | |||
| 16060000006276 | L16/dossiers | 16 | 16060000006262 | 16060000006262 | 13 | PA793928 | 2022-09-20 | False | |||
| 16060000006277 | L16/dossiers | 16 | 16060000006262 | 16060000006262 | 14 | PA793122 | 2022-09-20 | False | |||
| 16060000006278 | L16/dossiers | 16 | 16060000006262 | 16060000006262 | 15 | PA719608 | 2022-09-20 | False | |||
| 16060000006279 | L16/dossiers | 16 | 16060000006262 | 16060000006262 | 16 | PA795974 | 2022-09-20 | False | |||
| 16060000006280 | L16/dossiers | 16 | 16060000006262 | 16060000006262 | 17 | PA309643 | 2022-09-20 | False | |||
| 16060000006281 | L16/dossiers | 16 | 16060000006262 | 16060000006262 | 18 | PA795778 | 2022-09-20 | False | |||
| 16060000006282 | L16/dossiers | 16 | 16060000006262 | 16060000006262 | 19 | PA1206 | 2022-09-20 | False | |||
| 16060000006283 | L16/dossiers | 16 | 16060000006262 | 16060000006262 | 20 | PA794810 | 2022-09-20 | False | |||
| 16060000006284 | L16/dossiers | 16 | 16060000006262 | 16060000006262 | 21 | PA643134 | 2022-09-20 | False | |||
| 16060000006285 | L16/dossiers | 16 | 16060000006262 | 16060000006262 | 22 | PA796050 | 2022-09-20 | False | |||
| 16060000006286 | L16/dossiers | 16 | 16060000006262 | 16060000006262 | 23 | PA794718 | 2022-09-20 | False | |||
| 16060000006287 | L16/dossiers | 16 | 16060000006262 | 16060000006262 | 24 | PA1327 | 2022-09-20 | False | |||
| 16060000006288 | L16/dossiers | 16 | 16060000006262 | 16060000006262 | 25 | PA1592 | 2022-09-20 | False | |||
| 16060000006289 | L16/dossiers | 16 | 16060000006262 | 16060000006262 | 26 | PA794638 | 2022-09-20 | False | |||
| 16060000006290 | L16/dossiers | 16 | 16060000006262 | 16060000006262 | 27 | PA783457 | 2022-09-20 | False | |||
| 16060000006291 | L16/dossiers | 16 | 16060000006262 | 16060000006262 | 28 | PA720468 | 2022-09-20 | False | |||
| 16060000006292 | L16/dossiers | 16 | 16060000006262 | 16060000006262 | 29 | PA795552 | 2022-09-20 | False | |||
| 16060000006293 | L16/dossiers | 16 | 16060000006262 | 16060000006262 | 30 | PA722390 | 2022-09-20 | False | |||
| 16060000006294 | L16/dossiers | 16 | 16060000006262 | 16060000006262 | 31 | PA795836 | 2022-09-20 | False | |||
| 16060000006295 | L16/dossiers | 16 | 16060000006262 | 16060000006262 | 32 | PA642988 | 2022-09-20 | False | |||
| 16060000006296 | L16/dossiers | 16 | 16060000006262 | 16060000006262 | 33 | PA794030 | 2022-09-20 | False | |||
| 16060000006297 | L16/dossiers | 16 | 16060000006262 | 16060000006262 | 34 | PA796118 | 2022-09-20 | False | |||
| 16060000006298 | L16/dossiers | 16 | 16060000006262 | 16060000006262 | 35 | PA794354 | 2022-09-20 | False | |||
| 16060000006299 | L16/dossiers | 16 | 16060000006262 | 16060000006262 | 36 | PA794818 | 2022-09-20 | False | |||
| 16060000006300 | L16/dossiers | 16 | 16060000006262 | 16060000006262 | 37 | PA794502 | 2022-09-20 | False | |||
| 16060000006301 | L16/dossiers | 16 | 16060000006262 | 16060000006262 | 38 | PA695100 | 2022-09-20 | False | |||
| 16060000006302 | L16/dossiers | 16 | 16060000006262 | 16060000006262 | 39 | PA794314 | 2022-09-20 | False | |||
| 16060000006303 | L16/dossiers | 16 | 16060000006262 | 16060000006262 | 40 | PA794114 | 2022-09-20 | False | |||
| 16060000006304 | L16/dossiers | 16 | 16060000006262 | 16060000006262 | 41 | PA793508 | 2022-09-20 | False | |||
| 16060000006305 | L16/dossiers | 16 | 16060000006262 | 16060000006262 | 42 | PA793374 | 2022-09-20 | False | |||
| 16060000006306 | L16/dossiers | 16 | 16060000006262 | 16060000006262 | 43 | PA794322 | 2022-09-20 | False | |||
| 16060000006307 | L16/dossiers | 16 | 16060000006262 | 16060000006262 | 44 | PA794678 | 2022-09-20 | False | |||
| 16060000006308 | L16/dossiers | 16 | 16060000006262 | 16060000006262 | 45 | PA719436 | 2022-09-20 | False | |||
| 16060000006309 | L16/dossiers | 16 | 16060000006262 | 16060000006262 | 46 | PA342240 | 2022-09-20 | False | |||
| 16060000006310 | L16/dossiers | 16 | 16060000006262 | 16060000006262 | 47 | PA267042 | 2022-09-20 | False | |||
| 16060000006311 | L16/dossiers | 16 | 16060000006262 | 16060000006262 | 48 | PA794418 | 2022-09-20 | False | |||
| 16060000006312 | L16/dossiers | 16 | 16060000006262 | 16060000006262 | 49 | PA642847 | 2022-09-20 | False | |||
| 16060000006313 | L16/dossiers | 16 | 16060000006262 | 16060000006262 | 50 | PA795216 | 2022-09-20 | False | |||
| 16060000006314 | L16/dossiers | 16 | 16060000006262 | 16060000006262 | 51 | PA267429 | 2022-10-24 | False | |||
| 16060000006315 | L16/dossiers | 16 | 16060000006262 | 16060000006262 | 52 | PA719318 | 2022-11-09 | False | |||
| 16060000006319 | L16/dossiers | 16 | 16060000006317 | 16060000006317 | 1 | PA721046 | 2022-09-20 | False | |||
| 16060000006320 | L16/dossiers | 16 | 16060000006317 | 16060000006317 | 2 | PA267766 | 2022-09-20 | False | |||
| 16060000006321 | L16/dossiers | 16 | 16060000006317 | 16060000006317 | 3 | PA720696 | 2022-09-20 | False | |||
| 16060000006322 | L16/dossiers | 16 | 16060000006317 | 16060000006317 | 4 | PA795244 | 2022-09-20 | False | |||
| 16060000006323 | L16/dossiers | 16 | 16060000006317 | 16060000006317 | 5 | PA721486 | 2022-09-20 | False |