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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 17060000010211 | L17/dossiers | 17 | 17060000010190 | 17060000010190 | 20 | PA721442 | 2025-02-17 | False | |||
| 17060000010212 | L17/dossiers | 17 | 17060000010190 | 17060000010190 | 21 | PA794994 | 2025-02-17 | False | |||
| 17060000010213 | L17/dossiers | 17 | 17060000010190 | 17060000010190 | 22 | PA793094 | 2025-02-17 | False | |||
| 17060000010214 | L17/dossiers | 17 | 17060000010190 | 17060000010190 | 23 | PA266808 | 2025-02-17 | False | |||
| 17060000010215 | L17/dossiers | 17 | 17060000010190 | 17060000010190 | 24 | PA643089 | 2025-02-17 | False | |||
| 17060000010216 | L17/dossiers | 17 | 17060000010190 | 17060000010190 | 25 | PA721474 | 2025-02-17 | False | |||
| 17060000010220 | L17/dossiers | 17 | 17060000010218 | 17060000010218 | 1 | PA642847 | 2024-10-15 | False | |||
| 17060000010221 | L17/dossiers | 17 | 17060000010218 | 17060000010218 | 2 | PA774954 | 2024-10-15 | False | |||
| 17060000010222 | L17/dossiers | 17 | 17060000010218 | 17060000010218 | 3 | PA342240 | 2024-10-15 | False | |||
| 17060000010223 | L17/dossiers | 17 | 17060000010218 | 17060000010218 | 4 | PA793508 | 2024-10-15 | False | |||
| 17060000010224 | L17/dossiers | 17 | 17060000010218 | 17060000010218 | 5 | PA718838 | 2024-10-15 | False | |||
| 17060000010225 | L17/dossiers | 17 | 17060000010218 | 17060000010218 | 6 | PA722390 | 2024-10-15 | False | |||
| 17060000010226 | L17/dossiers | 17 | 17060000010218 | 17060000010218 | 7 | PA330909 | 2024-10-15 | False | |||
| 17060000010227 | L17/dossiers | 17 | 17060000010218 | 17060000010218 | 8 | PA720386 | 2024-10-15 | False | |||
| 17060000010228 | L17/dossiers | 17 | 17060000010218 | 17060000010218 | 9 | PA712015 | 2024-10-15 | False | |||
| 17060000010229 | L17/dossiers | 17 | 17060000010218 | 17060000010218 | 10 | PA794058 | 2024-10-15 | False | |||
| 17060000010230 | L17/dossiers | 17 | 17060000010218 | 17060000010218 | 11 | PA1630 | 2024-10-15 | False | |||
| 17060000010231 | L17/dossiers | 17 | 17060000010218 | 17060000010218 | 12 | PA695512 | 2024-10-15 | False | |||
| 17060000010232 | L17/dossiers | 17 | 17060000010218 | 17060000010218 | 13 | PA608016 | 2024-10-15 | False | |||
| 17060000010233 | L17/dossiers | 17 | 17060000010218 | 17060000010218 | 14 | PA794038 | 2024-10-15 | False | |||
| 17060000010234 | L17/dossiers | 17 | 17060000010218 | 17060000010218 | 15 | PA720644 | 2024-10-15 | False | |||
| 17060000010235 | L17/dossiers | 17 | 17060000010218 | 17060000010218 | 16 | PA721442 | 2024-10-15 | False | |||
| 17060000010236 | L17/dossiers | 17 | 17060000010218 | 17060000010218 | 17 | PA793094 | 2024-10-15 | False | |||
| 17060000010237 | L17/dossiers | 17 | 17060000010218 | 17060000010218 | 18 | PA721314 | 2024-10-15 | False | |||
| 17060000010241 | L17/dossiers | 17 | 17060000010239 | 17060000010239 | 1 | PA721410 | 2025-02-17 | False | |||
| 17060000010242 | L17/dossiers | 17 | 17060000010239 | 17060000010239 | 2 | PA721816 | 2025-02-17 | False | |||
| 17060000010243 | L17/dossiers | 17 | 17060000010239 | 17060000010239 | 3 | PA342240 | 2025-02-17 | False | |||
| 17060000010244 | L17/dossiers | 17 | 17060000010239 | 17060000010239 | 4 | PA793508 | 2025-02-17 | False | |||
| 17060000010245 | L17/dossiers | 17 | 17060000010239 | 17060000010239 | 5 | PA718838 | 2025-02-17 | False | |||
| 17060000010246 | L17/dossiers | 17 | 17060000010239 | 17060000010239 | 6 | PA722390 | 2025-02-17 | False | |||
| 17060000010247 | L17/dossiers | 17 | 17060000010239 | 17060000010239 | 7 | PA712015 | 2025-02-17 | False | |||
| 17060000010248 | L17/dossiers | 17 | 17060000010239 | 17060000010239 | 8 | PA332523 | 2024-10-15 | 2025-02-17 | False | ||
| 17060000010249 | L17/dossiers | 17 | 17060000010239 | 17060000010239 | 9 | PA1327 | 2025-02-17 | False | |||
| 17060000010250 | L17/dossiers | 17 | 17060000010239 | 17060000010239 | 10 | PA266797 | 2025-02-17 | False | |||
| 17060000010251 | L17/dossiers | 17 | 17060000010239 | 17060000010239 | 11 | PA794058 | 2025-02-17 | False | |||
| 17060000010252 | L17/dossiers | 17 | 17060000010239 | 17060000010239 | 12 | PA1630 | 2025-02-17 | False | |||
| 17060000010253 | L17/dossiers | 17 | 17060000010239 | 17060000010239 | 13 | PA346782 | 2025-02-17 | False | |||
| 17060000010254 | L17/dossiers | 17 | 17060000010239 | 17060000010239 | 14 | PA695512 | 2025-02-17 | False | |||
| 17060000010255 | L17/dossiers | 17 | 17060000010239 | 17060000010239 | 15 | PA608016 | 2025-02-17 | False | |||
| 17060000010256 | L17/dossiers | 17 | 17060000010239 | 17060000010239 | 16 | PA794038 | 2025-02-17 | False | |||
| 17060000010257 | L17/dossiers | 17 | 17060000010239 | 17060000010239 | 17 | PA718784 | 2025-02-17 | False | |||
| 17060000010258 | L17/dossiers | 17 | 17060000010239 | 17060000010239 | 18 | PA721442 | 2025-02-17 | False | |||
| 17060000010259 | L17/dossiers | 17 | 17060000010239 | 17060000010239 | 19 | PA793094 | 2025-02-17 | False | |||
| 17060000010260 | L17/dossiers | 17 | 17060000010239 | 17060000010239 | 20 | PA266808 | 2025-02-17 | False | |||
| 17060000010261 | L17/dossiers | 17 | 17060000010239 | 17060000010239 | 21 | PA794118 | 2025-02-17 | False | |||
| 17060000010262 | L17/dossiers | 17 | 17060000010239 | 17060000010239 | 22 | PA721474 | 2025-02-17 | False | |||
| 17060000010263 | L17/dossiers | 17 | 17060000010239 | 17060000010239 | 23 | PA718884 | 2025-02-17 | False | |||
| 17060000010267 | L17/dossiers | 17 | 17060000010265 | 17060000010265 | 1 | PA718884 | 2025-02-17 | False | |||
| 17060000010268 | L17/dossiers | 17 | 17060000010265 | 17060000010265 | 2 | PA719968 | 2025-02-17 | False | |||
| 17060000010269 | L17/dossiers | 17 | 17060000010265 | 17060000010265 | 3 | PA721816 | 2025-02-17 | False |