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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 17060000003794 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 235 | PA721600 | 2020-12-23 | False | |||
| 17060000003795 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 236 | PA343493 | 2020-12-23 | False | |||
| 17060000003796 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 237 | PA718902 | 2020-12-23 | False | |||
| 17060000003797 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 238 | PA722292 | 2020-12-23 | False | |||
| 17060000003798 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 239 | PA332747 | 2020-12-23 | False | |||
| 17060000003799 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 240 | PA721616 | 2020-12-23 | False | |||
| 17060000003800 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 241 | PA720878 | 2020-12-23 | False | |||
| 17060000003801 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 242 | PA720138 | 2020-12-23 | False | |||
| 17060000003802 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 243 | PA719972 | 2020-12-23 | False | |||
| 17060000003803 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 244 | PA720780 | 2020-12-23 | False | |||
| 17060000003804 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 245 | PA720960 | 2020-12-23 | False | |||
| 17060000003805 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 246 | PA721768 | 2020-12-23 | False | |||
| 17060000003806 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 247 | PA346876 | 2020-12-23 | False | |||
| 17060000003807 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 248 | PA719420 | 2020-12-23 | False | |||
| 17060000003808 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 249 | PA720190 | 2020-12-23 | False | |||
| 17060000003809 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 250 | PA720754 | 2020-12-23 | False | |||
| 17060000003810 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 251 | PA722118 | 2020-12-23 | False | |||
| 17060000003811 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 252 | PA721690 | 2020-12-23 | False | |||
| 17060000003812 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 253 | PA719550 | 2020-12-23 | False | |||
| 17060000003813 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 254 | PA720246 | 2020-12-23 | False | |||
| 17060000003814 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 255 | PA721584 | 2020-12-23 | False | |||
| 17060000003815 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 256 | PA720854 | 2020-12-23 | False | |||
| 17060000003816 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 257 | PA722336 | 2020-12-23 | False | |||
| 17060000003817 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 258 | PA720830 | 2020-12-23 | False | |||
| 17060000003818 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 259 | PA719302 | 2020-12-23 | False | |||
| 17060000003819 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 260 | PA720014 | 2020-12-23 | False | |||
| 17060000003820 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 261 | PA334768 | 2020-12-23 | False | |||
| 17060000003821 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 262 | PA2828 | 2020-12-23 | False | |||
| 17060000003822 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 263 | PA719540 | 2020-12-23 | False | |||
| 17060000003823 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 264 | PA607395 | 2020-12-23 | False | |||
| 17060000003824 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 265 | PA720394 | 2020-12-23 | False | |||
| 17060000003825 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 266 | PA718682 | 2020-12-23 | False | |||
| 17060000003826 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 267 | PA718768 | 2020-12-23 | False | |||
| 17060000003827 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 268 | PA722240 | 2020-12-23 | False | |||
| 17060000003828 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 269 | PA721542 | 2020-12-23 | False | |||
| 17060000003829 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 270 | PA722102 | 2020-12-23 | False | |||
| 17060000003830 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 271 | PA606639 | 2020-12-23 | False | |||
| 17060000003831 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 272 | PA721262 | 2020-12-23 | False | |||
| 17060000003832 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 273 | PA720318 | 2020-12-23 | False | |||
| 17060000003833 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 274 | PA721864 | 2020-12-23 | False | |||
| 17060000003834 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 275 | PA718962 | 2020-12-23 | False | |||
| 17060000003835 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 276 | PA719558 | 2020-12-23 | False | |||
| 17060000003836 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 277 | PA720256 | 2020-12-23 | False | |||
| 17060000003837 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 278 | PA721836 | 2020-12-23 | False | |||
| 17060000003838 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 279 | PA719942 | 2020-12-23 | False | |||
| 17060000003839 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 280 | PA719488 | 2020-12-23 | False | |||
| 17060000003840 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 281 | PA719024 | 2020-12-23 | False | |||
| 17060000003841 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 282 | PA720162 | 2020-12-23 | False | |||
| 17060000003842 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 283 | PA721608 | 2020-12-23 | False | |||
| 17060000003843 | L17/dossiers | 17 | 17060000003558 | 17060000003558 | 284 | PA720928 | 2020-12-23 | False |