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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 17060000003844 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 285 | PA721808 | 2020-12-23 | False | |||
| 17060000003845 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 286 | PA719266 | 2020-12-23 | False | |||
| 17060000003846 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 287 | PA720598 | 2020-12-23 | False | |||
| 17060000003847 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 288 | PA719044 | 2020-12-23 | False | |||
| 17060000003848 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 289 | PA1276 | 2020-12-23 | False | |||
| 17060000003849 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 290 | PA267042 | 2020-12-23 | False | |||
| 17060000003850 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 291 | PA721742 | 2020-12-23 | False | |||
| 17060000003851 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 292 | PA722284 | 2020-12-23 | False | |||
| 17060000003852 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 293 | PA720006 | 2020-12-23 | False | |||
| 17060000003853 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 294 | PA720326 | 2020-12-23 | False | |||
| 17060000003854 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 295 | PA722374 | 2020-12-23 | False | |||
| 17060000003855 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 296 | PA719874 | 2020-12-23 | False | |||
| 17060000003856 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 297 | PA719060 | 2020-12-23 | False | |||
| 17060000003857 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 298 | PA719210 | 2020-12-23 | False | |||
| 17060000003858 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 299 | PA720038 | 2020-12-23 | False | |||
| 17060000003859 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 300 | PA719504 | 2020-12-23 | False | |||
| 17060000003860 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 301 | PA719918 | 2020-12-23 | False | |||
| 17060000003861 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 302 | PA718978 | 2020-12-23 | False | |||
| 17060000003862 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 303 | PA720764 | 2020-12-23 | False | |||
| 17060000003863 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 304 | PA721984 | 2020-12-23 | False | |||
| 17060000003864 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 305 | PA721996 | 2020-12-23 | False | |||
| 17060000003865 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 306 | PA721530 | 2020-12-23 | False | |||
| 17060000003866 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 307 | PA720728 | 2020-12-23 | False | |||
| 17060000003867 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 308 | PA719640 | 2020-12-23 | False | |||
| 17060000003868 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 309 | PA721734 | 2020-12-23 | False | |||
| 17060000003869 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 310 | PA721976 | 2020-12-23 | False | |||
| 17060000003870 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 311 | PA720334 | 2020-12-23 | False | |||
| 17060000003871 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 312 | PA721182 | 2020-12-23 | False | |||
| 17060000003872 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 313 | PA721234 | 2020-12-23 | False | |||
| 17060000003873 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 314 | PA720720 | 2020-12-23 | False | |||
| 17060000003874 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 315 | PA405480 | 2020-12-23 | False | |||
| 17060000003875 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 316 | PA720092 | 2020-12-23 | False | |||
| 17060000003876 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 317 | PA717151 | 2020-12-23 | False | |||
| 17060000003877 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 318 | PA719822 | 2020-12-23 | False | |||
| 17060000003878 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 319 | PA722162 | 2020-12-23 | False | |||
| 17060000003879 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 320 | PA720704 | 2020-12-23 | False | |||
| 17060000003880 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 321 | PA331582 | 2020-12-23 | False | |||
| 17060000003881 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 322 | PA720746 | 2020-12-23 | False | |||
| 17060000003882 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 323 | PA722030 | 2020-12-23 | False | |||
| 17060000003883 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 324 | PA719448 | 2020-12-23 | False | |||
| 17060000003884 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 325 | PA720996 | 2020-12-23 | False | |||
| 17060000003885 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 326 | PA722358 | 2020-12-23 | False | |||
| 17060000003886 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 327 | PA267355 | 2020-12-23 | False | |||
| 17060000003887 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 328 | PA720454 | 2020-12-23 | False | |||
| 17060000003888 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 329 | PA719700 | 2020-12-23 | False | |||
| 17060000003889 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 330 | PA719052 | 2020-12-23 | False | |||
| 17060000003890 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 331 | PA719396 | 2020-12-23 | False | |||
| 17060000003891 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 332 | PA712014 | 2020-12-23 | False | |||
| 17060000003892 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 333 | PA721632 | 2020-12-23 | False | |||
| 17060000003893 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 334 | PA720500 | 2020-12-23 | False |