dossiers.document_co_signataire
Chemin document.coSignataires.coSignataire · présence : L17 26 %, L16 26 %, L15 28 %, L14 29 %
309 756 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 16060000016218 | L16/dossiers | 16 | 16060000016140 | 16060000016140 | 76 | PA721234 | 2023-01-13 | False | |||
| 16060000016219 | L16/dossiers | 16 | 16060000016140 | 16060000016140 | 77 | PA794582 | 2023-01-13 | False | |||
| 16060000016220 | L16/dossiers | 16 | 16060000016140 | 16060000016140 | 78 | PA793656 | 2023-01-13 | False | |||
| 16060000016221 | L16/dossiers | 16 | 16060000016140 | 16060000016140 | 79 | PA794994 | 2023-01-13 | False | |||
| 16060000016222 | L16/dossiers | 16 | 16060000016140 | 16060000016140 | 80 | PA793230 | 2023-01-13 | False | |||
| 16060000016223 | L16/dossiers | 16 | 16060000016140 | 16060000016140 | 81 | PA793094 | 2023-01-13 | False | |||
| 16060000016224 | L16/dossiers | 16 | 16060000016140 | 16060000016140 | 82 | PA794442 | 2023-01-13 | False | |||
| 16060000016225 | L16/dossiers | 16 | 16060000016140 | 16060000016140 | 83 | PA794626 | 2023-01-13 | False | |||
| 16060000016226 | L16/dossiers | 16 | 16060000016140 | 16060000016140 | 84 | PA793382 | 2023-01-13 | False | |||
| 16060000016227 | L16/dossiers | 16 | 16060000016140 | 16060000016140 | 85 | PA794178 | 2023-01-13 | False | |||
| 16060000016228 | L16/dossiers | 16 | 16060000016140 | 16060000016140 | 86 | PA794502 | 2023-01-13 | False | |||
| 16060000016229 | L16/dossiers | 16 | 16060000016140 | 16060000016140 | 87 | PA794118 | 2023-01-13 | False | |||
| 16060000016230 | L16/dossiers | 16 | 16060000016140 | 16060000016140 | 88 | PA607090 | 2023-01-13 | False | |||
| 16060000016231 | L16/dossiers | 16 | 16060000016140 | 16060000016140 | 89 | PA794946 | 2023-01-13 | False | |||
| 16060000016232 | L16/dossiers | 16 | 16060000016140 | 16060000016140 | 90 | PA793194 | 2023-01-13 | False | |||
| 16060000016233 | L16/dossiers | 16 | 16060000016140 | 16060000016140 | 91 | PA796078 | 2023-01-13 | False | |||
| 16060000016234 | L16/dossiers | 16 | 16060000016140 | 16060000016140 | 92 | PA793500 | 2023-01-13 | False | |||
| 16060000016235 | L16/dossiers | 16 | 16060000016140 | 16060000016140 | 93 | PA605694 | 2023-01-13 | False | |||
| 16060000016236 | L16/dossiers | 16 | 16060000016140 | 16060000016140 | 94 | PA783457 | 2023-01-13 | False | |||
| 16060000016237 | L16/dossiers | 16 | 16060000016140 | 16060000016140 | 95 | PA796110 | 2023-01-13 | False | |||
| 16060000016238 | L16/dossiers | 16 | 16060000016140 | 16060000016140 | 96 | PA794770 | 2023-01-13 | False | |||
| 16060000016239 | L16/dossiers | 16 | 16060000016140 | 16060000016140 | 97 | PA793314 | 2023-01-13 | False | |||
| 16060000016240 | L16/dossiers | 16 | 16060000016140 | 16060000016140 | 98 | PA720976 | 2023-01-13 | False | |||
| 16060000016241 | L16/dossiers | 16 | 16060000016140 | 16060000016140 | 99 | PA793852 | 2023-01-13 | False | |||
| 16060000016242 | L16/dossiers | 16 | 16060000016140 | 16060000016140 | 100 | PA607619 | 2023-01-13 | False | |||
| 16060000016243 | L16/dossiers | 16 | 16060000016140 | 16060000016140 | 101 | PA610654 | 2023-01-13 | False | |||
| 16060000016244 | L16/dossiers | 16 | 16060000016140 | 16060000016140 | 102 | PA795722 | 2023-01-13 | False | |||
| 16060000016245 | L16/dossiers | 16 | 16060000016140 | 16060000016140 | 103 | PA794830 | 2023-01-13 | False | |||
| 16060000016246 | L16/dossiers | 16 | 16060000016140 | 16060000016140 | 104 | PA719528 | 2023-01-13 | False | |||
| 16060000016247 | L16/dossiers | 16 | 16060000016140 | 16060000016140 | 105 | PA795966 | 2023-01-13 | False | |||
| 16060000016248 | L16/dossiers | 16 | 16060000016140 | 16060000016140 | 106 | PA794954 | 2023-01-13 | False | |||
| 16060000016249 | L16/dossiers | 16 | 16060000016140 | 16060000016140 | 107 | PA796050 | 2023-01-13 | False | |||
| 16060000016250 | L16/dossiers | 16 | 16060000016140 | 16060000016140 | 108 | PA720960 | 2023-01-13 | False | |||
| 16060000016251 | L16/dossiers | 16 | 16060000016140 | 16060000016140 | 109 | PA793298 | 2023-01-13 | False | |||
| 16060000016252 | L16/dossiers | 16 | 16060000016140 | 16060000016140 | 110 | PA331582 | 2023-01-13 | False | |||
| 16060000016253 | L16/dossiers | 16 | 16060000016140 | 16060000016140 | 111 | PA795100 | 2023-01-13 | False | |||
| 16060000016254 | L16/dossiers | 16 | 16060000016140 | 16060000016140 | 112 | PA1327 | 2023-01-13 | False | |||
| 16060000016255 | L16/dossiers | 16 | 16060000016140 | 16060000016140 | 113 | PA722202 | 2023-01-13 | 2023-03-10 | False | ||
| 16060000016256 | L16/dossiers | 16 | 16060000016140 | 16060000016140 | 114 | PA721118 | 2023-01-13 | 2023-03-10 | False | ||
| 16060000016257 | L16/dossiers | 16 | 16060000016140 | 16060000016140 | 115 | PA795184 | 2023-01-13 | 2023-03-10 | False | ||
| 16060000016261 | L16/dossiers | 16 | 16060000016259 | 16060000016259 | 1 | PA642764 | 2023-01-17 | False | |||
| 16060000016262 | L16/dossiers | 16 | 16060000016259 | 16060000016259 | 2 | PA643143 | 2023-01-17 | False | |||
| 16060000016263 | L16/dossiers | 16 | 16060000016259 | 16060000016259 | 3 | PA342415 | 2023-01-17 | False | |||
| 16060000016264 | L16/dossiers | 16 | 16060000016259 | 16060000016259 | 4 | PA794094 | 2023-01-17 | False | |||
| 16060000016265 | L16/dossiers | 16 | 16060000016259 | 16060000016259 | 5 | PA793624 | 2023-01-17 | False | |||
| 16060000016266 | L16/dossiers | 16 | 16060000016259 | 16060000016259 | 6 | PA795762 | 2023-01-17 | False | |||
| 16060000016267 | L16/dossiers | 16 | 16060000016259 | 16060000016259 | 7 | PA1008 | 2023-01-17 | False | |||
| 16060000016268 | L16/dossiers | 16 | 16060000016259 | 16060000016259 | 8 | PA793394 | 2023-01-17 | False | |||
| 16060000016269 | L16/dossiers | 16 | 16060000016259 | 16060000016259 | 9 | PA795430 | 2023-01-17 | False | |||
| 16060000016270 | L16/dossiers | 16 | 16060000016259 | 16060000016259 | 10 | PA794854 | 2023-01-17 | False |