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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 17060000005069 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 165 | PA795046 | 2023-04-28 | False | |||
| 17060000005070 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 166 | PA718962 | 2023-04-28 | False | |||
| 17060000005071 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 167 | PA794278 | 2023-04-28 | False | |||
| 17060000005072 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 168 | PA793992 | 2023-04-28 | False | |||
| 17060000005073 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 169 | PA332228 | 2023-04-28 | False | |||
| 17060000005074 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 170 | PA795266 | 2023-04-28 | False | |||
| 17060000005075 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 171 | PA642868 | 2023-04-28 | False | |||
| 17060000005076 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 172 | PA267042 | 2023-04-28 | False | |||
| 17060000005077 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 173 | PA794470 | 2023-04-28 | False | |||
| 17060000005078 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 174 | PA794234 | 2023-04-28 | False | |||
| 17060000005079 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 175 | PA719778 | 2023-04-28 | False | |||
| 17060000005080 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 176 | PA719052 | 2023-04-28 | False | |||
| 17060000005081 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 177 | PA794818 | 2023-04-28 | False | |||
| 17060000005082 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 178 | PA719382 | 2023-04-28 | False | |||
| 17060000005083 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 179 | PA719396 | 2023-04-28 | False | |||
| 17060000005084 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 180 | PA794426 | 2023-04-28 | False | |||
| 17060000005085 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 181 | PA794838 | 2023-04-28 | False | |||
| 17060000005086 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 182 | PA720908 | 2023-04-28 | False | |||
| 17060000005087 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 183 | PA793398 | 2023-04-28 | False | |||
| 17060000005088 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 184 | PA793572 | 2023-04-28 | False | |||
| 17060000005089 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 185 | PA719528 | 2023-04-28 | False | |||
| 17060000005090 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 186 | PA795270 | 2023-04-28 | False | |||
| 17060000005091 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 187 | PA793306 | 2023-04-28 | False | |||
| 17060000005092 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 188 | PA720552 | 2023-04-28 | False | |||
| 17060000005093 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 189 | PA722336 | 2023-04-28 | False | |||
| 17060000005094 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 190 | PA795350 | 2023-04-28 | False | |||
| 17060000005095 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 191 | PA421348 | 2023-04-28 | False | |||
| 17060000005096 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 192 | PA795026 | 2023-04-28 | False | |||
| 17060000005097 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 193 | PA642764 | 2023-11-13 | False | |||
| 17060000005098 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 194 | PA643143 | 2023-11-13 | False | |||
| 17060000005099 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 195 | PA342415 | 2023-11-13 | False | |||
| 17060000005100 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 196 | PA794094 | 2023-11-13 | False | |||
| 17060000005101 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 197 | PA793624 | 2023-11-13 | False | |||
| 17060000005102 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 198 | PA795762 | 2023-11-13 | False | |||
| 17060000005103 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 199 | PA1008 | 2023-11-13 | False | |||
| 17060000005104 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 200 | PA793394 | 2023-11-13 | False | |||
| 17060000005105 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 201 | PA795430 | 2023-11-13 | False | |||
| 17060000005106 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 202 | PA609332 | 2023-11-13 | False | |||
| 17060000005107 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 203 | PA333285 | 2023-11-13 | False | |||
| 17060000005108 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 204 | PA1567 | 2023-11-13 | False | |||
| 17060000005109 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 205 | PA795828 | 2023-11-13 | False | |||
| 17060000005110 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 206 | PA643192 | 2023-11-13 | False | |||
| 17060000005111 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 207 | PA335054 | 2023-11-13 | False | |||
| 17060000005112 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 208 | PA795156 | 2023-11-13 | False | |||
| 17060000005113 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 209 | PA774958 | 2023-11-13 | False | |||
| 17060000005114 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 210 | PA643157 | 2023-11-13 | False | |||
| 17060000005115 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 211 | PA344201 | 2023-11-13 | False | |||
| 17060000005116 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 212 | PA794270 | 2023-11-13 | False | |||
| 17060000005117 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 213 | PA608172 | 2023-11-13 | False | |||
| 17060000005118 | L17/dossiers | 17 | 17060000004903 | 17060000004903 | 214 | PA607553 | 2023-11-13 | False |