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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 16060000002085 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 144 | PA605703 | 2014-12-09 | False | |||
| 16060000002086 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 145 | PA2799 | 2014-12-09 | False | |||
| 16060000002087 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 146 | PA334768 | 2014-12-09 | False | |||
| 16060000002088 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 147 | PA607395 | 2014-12-09 | False | |||
| 16060000002089 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 148 | PA609205 | 2014-12-09 | False | |||
| 16060000002090 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 149 | PA608695 | 2014-12-09 | False | |||
| 16060000002091 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 150 | PA642788 | 2014-12-09 | False | |||
| 16060000002092 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 151 | PA606639 | 2014-12-09 | False | |||
| 16060000002093 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 152 | PA334951 | 2014-12-09 | False | |||
| 16060000002112 | L16/dossiers | 16 | 16060000002110 | 16060000002110 | 1 | PA610427 | 2015-11-25 | False | |||
| 16060000002113 | L16/dossiers | 16 | 16060000002110 | 16060000002110 | 2 | PA605963 | 2015-11-25 | False | |||
| 16060000002114 | L16/dossiers | 16 | 16060000002110 | 16060000002110 | 3 | PA605625 | 2015-11-25 | False | |||
| 16060000002115 | L16/dossiers | 16 | 16060000002110 | 16060000002110 | 4 | PA608186 | 2015-11-25 | False | |||
| 16060000002116 | L16/dossiers | 16 | 16060000002110 | 16060000002110 | 5 | PA609016 | 2015-11-25 | False | |||
| 16060000002117 | L16/dossiers | 16 | 16060000002110 | 16060000002110 | 6 | PA606910 | 2015-11-25 | False | |||
| 16060000002118 | L16/dossiers | 16 | 16060000002110 | 16060000002110 | 7 | PA606258 | 2015-11-25 | False | |||
| 16060000002119 | L16/dossiers | 16 | 16060000002110 | 16060000002110 | 8 | PA610860 | 2015-11-25 | False | |||
| 16060000002120 | L16/dossiers | 16 | 16060000002110 | 16060000002110 | 9 | PA588872 | 2015-11-25 | False | |||
| 16060000002121 | L16/dossiers | 16 | 16060000002110 | 16060000002110 | 10 | PA605518 | 2015-11-25 | False | |||
| 16060000002122 | L16/dossiers | 16 | 16060000002110 | 16060000002110 | 11 | PA2045 | 2015-11-25 | False | |||
| 16060000002123 | L16/dossiers | 16 | 16060000002110 | 16060000002110 | 12 | PA609816 | 2015-11-25 | False | |||
| 16060000002124 | L16/dossiers | 16 | 16060000002110 | 16060000002110 | 13 | PA607619 | 2015-11-25 | False | |||
| 16060000002125 | L16/dossiers | 16 | 16060000002110 | 16060000002110 | 14 | PA609520 | 2015-11-25 | False | |||
| 16060000002126 | L16/dossiers | 16 | 16060000002110 | 16060000002110 | 15 | PA606545 | 2015-11-25 | False | |||
| 16060000002127 | L16/dossiers | 16 | 16060000002110 | 16060000002110 | 16 | PA332747 | 2015-11-25 | False | |||
| 16060000002128 | L16/dossiers | 16 | 16060000002110 | 16060000002110 | 17 | PA610002 | 2015-11-25 | False | |||
| 16060000002453 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 1 | PA718894 | 2020-12-14 | False | |||
| 16060000002454 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 2 | PA720454 | 2020-12-14 | False | |||
| 16060000002455 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 3 | PA722046 | 2020-12-14 | False | |||
| 16060000002456 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 4 | PA721166 | 2020-12-14 | False | |||
| 16060000002457 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 5 | PA720928 | 2020-12-14 | False | |||
| 16060000002458 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 6 | PA712014 | 2020-12-14 | False | |||
| 16060000002459 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 7 | PA719364 | 2020-12-14 | False | |||
| 16060000002460 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 8 | PA721600 | 2020-12-14 | False | |||
| 16060000002461 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 9 | PA719512 | 2020-12-14 | False | |||
| 16060000002462 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 10 | PA605131 | 2020-12-14 | False | |||
| 16060000002463 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 11 | PA721418 | 2020-12-14 | False | |||
| 16060000002464 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 12 | PA642935 | 2020-12-14 | False | |||
| 16060000002465 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 13 | PA721134 | 2020-12-14 | False | |||
| 16060000002466 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 14 | PA722312 | 2020-12-14 | False | |||
| 16060000002467 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 15 | PA719866 | 2020-12-14 | False | |||
| 16060000002468 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 16 | PA722038 | 2020-12-14 | False | |||
| 16060000002469 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 17 | PA721036 | 2020-12-14 | False | |||
| 16060000002470 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 18 | PA718954 | 2020-12-14 | False | |||
| 16060000002471 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 19 | PA605963 | 2020-12-14 | False | |||
| 16060000002472 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 20 | PA724827 | 2020-12-14 | False | |||
| 16060000002473 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 21 | PA721278 | 2020-12-14 | False | |||
| 16060000002474 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 22 | PA721158 | 2020-12-14 | False | |||
| 16060000002475 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 23 | PA719100 | 2020-12-14 | False | |||
| 16060000002476 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 24 | PA720310 | 2020-12-14 | False |