dossiers.document_co_signataire
Chemin document.coSignataires.coSignataire · présence : L17 26 %, L16 26 %, L15 28 %, L14 29 %
309 130 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 17060000079026 | L17/dossiers | 17 | 17060000078966 | 17060000078966 | 59 | PA703541 | 2018-12-18 | False | |||
| 17060000079027 | L17/dossiers | 17 | 17060000078966 | 17060000078966 | 60 | PA267328 | 2018-12-18 | False | |||
| 17060000079028 | L17/dossiers | 17 | 17060000078966 | 17060000078966 | 61 | PA304076 | 2018-12-18 | False | |||
| 17060000079029 | L17/dossiers | 17 | 17060000078966 | 17060000078966 | 62 | PA2447 | 2018-12-18 | False | |||
| 17060000079030 | L17/dossiers | 17 | 17060000078966 | 17060000078966 | 63 | PA1452 | 2018-12-18 | False | |||
| 17060000079031 | L17/dossiers | 17 | 17060000078966 | 17060000078966 | 64 | PA736166 | 2018-12-18 | False | |||
| 17060000079032 | L17/dossiers | 17 | 17060000078966 | 17060000078966 | 65 | PA267018 | 2018-12-18 | False | |||
| 17060000079033 | L17/dossiers | 17 | 17060000078966 | 17060000078966 | 66 | PA736193 | 2018-12-18 | False | |||
| 17060000079034 | L17/dossiers | 17 | 17060000078966 | 17060000078966 | 67 | PA2538 | 2018-12-18 | False | |||
| 17060000079035 | L17/dossiers | 17 | 17060000078966 | 17060000078966 | 68 | PA2543 | 2018-12-18 | False | |||
| 17060000079036 | L17/dossiers | 17 | 17060000078966 | 17060000078966 | 69 | PA429851 | 2018-12-18 | False | |||
| 17060000079037 | L17/dossiers | 17 | 17060000078966 | 17060000078966 | 70 | PA429874 | 2018-12-18 | False | |||
| 17060000079038 | L17/dossiers | 17 | 17060000078966 | 17060000078966 | 71 | PA301592 | 2018-12-18 | False | |||
| 17060000079039 | L17/dossiers | 17 | 17060000078966 | 17060000078966 | 72 | PA227094 | 2018-12-18 | False | |||
| 17060000079040 | L17/dossiers | 17 | 17060000078966 | 17060000078966 | 73 | PA736237 | 2018-12-18 | False | |||
| 17060000079041 | L17/dossiers | 17 | 17060000078966 | 17060000078966 | 74 | PA227098 | 2018-12-18 | False | |||
| 17060000079042 | L17/dossiers | 17 | 17060000078966 | 17060000078966 | 75 | PA703482 | 2018-12-18 | False | |||
| 17060000079043 | L17/dossiers | 17 | 17060000078966 | 17060000078966 | 76 | PA703527 | 2018-12-18 | False | |||
| 17060000079046 | L17/dossiers | 17 | 17060000079044 | 17060000079044 | 1 | PA905 | 2018-12-21 | True | |||
| 17060000079047 | L17/dossiers | 17 | 17060000079044 | 17060000079044 | 2 | PA429895 | 2018-12-21 | True | |||
| 17060000079048 | L17/dossiers | 17 | 17060000079044 | 17060000079044 | 3 | PA703486 | 2018-12-21 | False | |||
| 17060000079049 | L17/dossiers | 17 | 17060000079044 | 17060000079044 | 4 | PA267840 | 2018-12-21 | False | |||
| 17060000079050 | L17/dossiers | 17 | 17060000079044 | 17060000079044 | 5 | PA429890 | 2018-12-21 | False | |||
| 17060000079051 | L17/dossiers | 17 | 17060000079044 | 17060000079044 | 6 | PA736190 | 2018-12-21 | False | |||
| 17060000079052 | L17/dossiers | 17 | 17060000079044 | 17060000079044 | 7 | PA703531 | 2018-12-21 | False | |||
| 17060000079053 | L17/dossiers | 17 | 17060000079044 | 17060000079044 | 8 | PA268007 | 2018-12-21 | False | |||
| 17060000079054 | L17/dossiers | 17 | 17060000079044 | 17060000079044 | 9 | PA736235 | 2018-12-21 | False | |||
| 17060000079055 | L17/dossiers | 17 | 17060000079044 | 17060000079044 | 10 | PA703487 | 2018-12-21 | False | |||
| 17060000079056 | L17/dossiers | 17 | 17060000079044 | 17060000079044 | 11 | PA736228 | 2018-12-21 | False | |||
| 17060000079057 | L17/dossiers | 17 | 17060000079044 | 17060000079044 | 12 | PA1573 | 2018-12-21 | False | |||
| 17060000079058 | L17/dossiers | 17 | 17060000079044 | 17060000079044 | 13 | PA736168 | 2018-12-21 | False | |||
| 17060000079059 | L17/dossiers | 17 | 17060000079044 | 17060000079044 | 14 | PA703529 | 2018-12-21 | False | |||
| 17060000079060 | L17/dossiers | 17 | 17060000079044 | 17060000079044 | 15 | PA429866 | 2018-12-21 | False | |||
| 17060000079061 | L17/dossiers | 17 | 17060000079044 | 17060000079044 | 16 | PA415464 | 2018-12-21 | False | |||
| 17060000079062 | L17/dossiers | 17 | 17060000079044 | 17060000079044 | 17 | PA736242 | 2018-12-21 | False | |||
| 17060000079063 | L17/dossiers | 17 | 17060000079044 | 17060000079044 | 18 | PA736224 | 2018-12-21 | False | |||
| 17060000079064 | L17/dossiers | 17 | 17060000079044 | 17060000079044 | 19 | PA703495 | 2018-12-21 | False | |||
| 17060000079065 | L17/dossiers | 17 | 17060000079044 | 17060000079044 | 20 | PA415480 | 2018-12-21 | False | |||
| 17060000079071 | L17/dossiers | 17 | 17060000079069 | 17060000079069 | 1 | PA513 | 2019-02-05 | False | |||
| 17060000079072 | L17/dossiers | 17 | 17060000079069 | 17060000079069 | 2 | PA736174 | 2019-02-05 | False | |||
| 17060000079073 | L17/dossiers | 17 | 17060000079069 | 17060000079069 | 3 | PA703534 | 2019-02-05 | False | |||
| 17060000079074 | L17/dossiers | 17 | 17060000079069 | 17060000079069 | 4 | PA267762 | 2019-02-05 | False | |||
| 17060000079075 | L17/dossiers | 17 | 17060000079069 | 17060000079069 | 5 | PA266867 | 2019-02-05 | False | |||
| 17060000079076 | L17/dossiers | 17 | 17060000079069 | 17060000079069 | 6 | PA429887 | 2019-02-05 | False | |||
| 17060000079077 | L17/dossiers | 17 | 17060000079069 | 17060000079069 | 7 | PA736220 | 2019-02-05 | False | |||
| 17060000079078 | L17/dossiers | 17 | 17060000079069 | 17060000079069 | 8 | PA703516 | 2019-02-05 | False | |||
| 17060000079079 | L17/dossiers | 17 | 17060000079069 | 17060000079069 | 9 | PA2042 | 2019-02-05 | False | |||
| 17060000079080 | L17/dossiers | 17 | 17060000079069 | 17060000079069 | 10 | PA304021 | 2019-02-05 | False | |||
| 17060000079081 | L17/dossiers | 17 | 17060000079069 | 17060000079069 | 11 | PA736196 | 2019-02-05 | False | |||
| 17060000086627 | L17/dossiers | 17 | 17060000086625 | 17060000086625 | 1 | PA345722 | 2024-07-22 | False |