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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 16060000010537 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 188 | PA605694 | 2022-11-17 | False | |||
| 16060000010538 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 189 | PA795120 | 2022-11-17 | False | |||
| 16060000010539 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 190 | PA795604 | 2022-11-17 | False | |||
| 16060000010540 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 191 | PA722284 | 2022-11-17 | False | |||
| 16060000010541 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 192 | PA721760 | 2022-11-17 | False | |||
| 16060000010542 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 193 | PA720006 | 2022-11-17 | False | |||
| 16060000010543 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 194 | PA720560 | 2022-11-17 | False | |||
| 16060000010544 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 195 | PA795258 | 2022-11-17 | False | |||
| 16060000010545 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 196 | PA722374 | 2022-11-17 | False | |||
| 16060000010546 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 197 | PA719874 | 2022-11-17 | False | |||
| 16060000010547 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 198 | PA720038 | 2022-11-17 | False | |||
| 16060000010548 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 199 | PA719918 | 2022-11-17 | False | |||
| 16060000010549 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 200 | PA718978 | 2022-11-17 | False | |||
| 16060000010550 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 201 | PA720764 | 2022-11-17 | False | |||
| 16060000010551 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 202 | PA721984 | 2022-11-17 | False | |||
| 16060000010552 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 203 | PA795374 | 2022-11-17 | False | |||
| 16060000010553 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 204 | PA794702 | 2022-11-17 | False | |||
| 16060000010554 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 205 | PA721530 | 2022-11-17 | False | |||
| 16060000010555 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 206 | PA794114 | 2022-11-17 | False | |||
| 16060000010556 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 207 | PA795100 | 2022-11-17 | False | |||
| 16060000010557 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 208 | PA719640 | 2022-11-17 | False | |||
| 16060000010558 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 209 | PA721976 | 2022-11-17 | False | |||
| 16060000010559 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 210 | PA794810 | 2022-11-17 | False | |||
| 16060000010560 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 211 | PA794830 | 2022-11-17 | False | |||
| 16060000010561 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 212 | PA720334 | 2022-11-17 | False | |||
| 16060000010562 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 213 | PA721182 | 2022-11-17 | False | |||
| 16060000010563 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 214 | PA721234 | 2022-11-17 | False | |||
| 16060000010564 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 215 | PA720720 | 2022-11-17 | False | |||
| 16060000010565 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 216 | PA720092 | 2022-11-17 | False | |||
| 16060000010566 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 217 | PA719822 | 2022-11-17 | False | |||
| 16060000010567 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 218 | PA722162 | 2022-11-17 | False | |||
| 16060000010568 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 219 | PA720704 | 2022-11-17 | False | |||
| 16060000010569 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 220 | PA331582 | 2022-11-17 | False | |||
| 16060000010570 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 221 | PA793860 | 2022-11-17 | False | |||
| 16060000010571 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 222 | PA794278 | 2022-11-21 | False | |||
| 16060000010572 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 223 | PA793992 | 2022-11-21 | False | |||
| 16060000010573 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 224 | PA795278 | 2022-11-21 | False | |||
| 16060000010574 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 225 | PA795266 | 2022-11-21 | False | |||
| 16060000010575 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 226 | PA642868 | 2022-11-21 | False | |||
| 16060000010576 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 227 | PA267042 | 2022-11-21 | False | |||
| 16060000010577 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 228 | PA794470 | 2022-11-21 | False | |||
| 16060000010578 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 229 | PA794234 | 2022-11-21 | False | |||
| 16060000010579 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 230 | PA719778 | 2022-11-21 | False | |||
| 16060000010580 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 231 | PA719052 | 2022-11-21 | False | |||
| 16060000010581 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 232 | PA794818 | 2022-11-21 | False | |||
| 16060000010582 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 233 | PA719382 | 2022-11-21 | False | |||
| 16060000010583 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 234 | PA719396 | 2022-11-21 | False | |||
| 16060000010584 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 235 | PA794426 | 2022-11-21 | False | |||
| 16060000010585 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 236 | PA794838 | 2022-11-21 | False | |||
| 16060000010586 | L16/dossiers | 16 | 16060000010348 | 16060000010348 | 237 | PA720230 | 2022-11-21 | False |