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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 16060000002727 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 275 | PA1276 | 2020-12-14 | False | |||
| 16060000002728 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 276 | PA267042 | 2020-12-14 | False | |||
| 16060000002729 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 277 | PA721742 | 2020-12-14 | False | |||
| 16060000002730 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 278 | PA722284 | 2020-12-14 | False | |||
| 16060000002731 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 279 | PA720006 | 2020-12-14 | False | |||
| 16060000002732 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 280 | PA720326 | 2020-12-14 | False | |||
| 16060000002733 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 281 | PA722374 | 2020-12-14 | False | |||
| 16060000002734 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 282 | PA719874 | 2020-12-14 | False | |||
| 16060000002735 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 283 | PA719060 | 2020-12-14 | False | |||
| 16060000002736 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 284 | PA719210 | 2020-12-14 | False | |||
| 16060000002737 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 285 | PA720038 | 2020-12-14 | False | |||
| 16060000002738 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 286 | PA719504 | 2020-12-14 | False | |||
| 16060000002739 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 287 | PA719918 | 2020-12-14 | False | |||
| 16060000002740 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 288 | PA718978 | 2020-12-14 | False | |||
| 16060000002741 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 289 | PA720764 | 2020-12-14 | False | |||
| 16060000002742 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 290 | PA721984 | 2020-12-14 | False | |||
| 16060000002743 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 291 | PA721996 | 2020-12-14 | False | |||
| 16060000002744 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 292 | PA721530 | 2020-12-14 | False | |||
| 16060000002745 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 293 | PA720728 | 2020-12-14 | False | |||
| 16060000002746 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 294 | PA719640 | 2020-12-14 | False | |||
| 16060000002747 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 295 | PA721734 | 2020-12-14 | False | |||
| 16060000002748 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 296 | PA721976 | 2020-12-14 | False | |||
| 16060000002749 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 297 | PA720334 | 2020-12-14 | False | |||
| 16060000002750 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 298 | PA721182 | 2020-12-14 | False | |||
| 16060000002751 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 299 | PA721234 | 2020-12-14 | False | |||
| 16060000002752 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 300 | PA720720 | 2020-12-14 | False | |||
| 16060000002753 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 301 | PA405480 | 2020-12-14 | False | |||
| 16060000002754 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 302 | PA720092 | 2020-12-14 | False | |||
| 16060000002755 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 303 | PA717151 | 2020-12-14 | False | |||
| 16060000002756 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 304 | PA719822 | 2020-12-14 | False | |||
| 16060000002757 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 305 | PA722162 | 2020-12-14 | False | |||
| 16060000002758 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 306 | PA721924 | 2020-12-14 | False | |||
| 16060000002759 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 307 | PA720704 | 2020-12-14 | False | |||
| 16060000002760 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 308 | PA331582 | 2020-12-14 | False | |||
| 16060000002761 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 309 | PA720746 | 2020-12-14 | False | |||
| 16060000002762 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 310 | PA722030 | 2020-12-14 | False | |||
| 16060000002763 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 311 | PA719448 | 2020-12-14 | False | |||
| 16060000002764 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 312 | PA642868 | 2020-12-14 | False | |||
| 16060000002765 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 313 | PA720996 | 2020-12-14 | False | |||
| 16060000002766 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 314 | PA719616 | 2020-12-14 | False | |||
| 16060000002767 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 315 | PA267780 | 2020-12-14 | False | |||
| 16060000002768 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 316 | PA722358 | 2020-12-14 | False | |||
| 16060000002769 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 317 | PA267355 | 2020-12-14 | False | |||
| 16060000002770 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 318 | PA719700 | 2020-12-14 | False | |||
| 16060000002771 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 319 | PA720214 | 2020-12-14 | False | |||
| 16060000002772 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 320 | PA331567 | 2020-12-14 | False | |||
| 16060000002773 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 321 | PA719396 | 2020-12-14 | False | |||
| 16060000002774 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 322 | PA721632 | 2020-12-14 | False | |||
| 16060000002775 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 323 | PA720230 | 2020-12-14 | False | |||
| 16060000002776 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 324 | PA720500 | 2020-12-14 | False |