dossiers.document_co_signataire
Chemin document.coSignataires.coSignataire · présence : L17 26 %, L16 26 %, L15 28 %, L14 29 %
305 264 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 17060000035390 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 19 | PA795362 | 2025-05-30 | False | |||
| 17060000035391 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 20 | PA841657 | 2025-05-30 | False | |||
| 17060000035392 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 21 | PA719968 | 2025-05-30 | False | |||
| 17060000035393 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 22 | PA721410 | 2025-05-30 | False | |||
| 17060000035394 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 23 | PA794094 | 2025-05-30 | False | |||
| 17060000035395 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 24 | PA794938 | 2025-05-30 | False | |||
| 17060000035396 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 25 | PA793508 | 2025-05-30 | False | |||
| 17060000035397 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 26 | PA794710 | 2025-05-30 | False | |||
| 17060000035398 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 27 | PA841023 | 2025-05-30 | False | |||
| 17060000035399 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 28 | PA608264 | 2025-05-30 | False | |||
| 17060000035400 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 29 | PA793912 | 2025-05-30 | False | |||
| 17060000035401 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 30 | PA794554 | 2025-05-30 | False | |||
| 17060000035402 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 31 | PA719922 | 2025-05-30 | False | |||
| 17060000035403 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 32 | PA719472 | 2025-05-20 | 2025-05-21 | False | ||
| 17060000035404 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 33 | PA794008 | 2025-05-30 | False | |||
| 17060000035405 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 34 | PA840903 | 2025-05-30 | False | |||
| 17060000035406 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 35 | PA841431 | 2025-05-30 | False | |||
| 17060000035407 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 36 | PA719286 | 2025-05-30 | False | |||
| 17060000035408 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 37 | PA721202 | 2025-05-30 | False | |||
| 17060000035409 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 38 | PA718850 | 2025-05-30 | False | |||
| 17060000035410 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 39 | PA795136 | 2025-05-30 | False | |||
| 17060000035411 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 40 | PA841295 | 2025-05-30 | False | |||
| 17060000035412 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 41 | PA942 | 2025-05-30 | False | |||
| 17060000035413 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 42 | PA1008 | 2025-05-30 | False | |||
| 17060000035414 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 43 | PA793394 | 2025-05-30 | False | |||
| 17060000035415 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 44 | PA795430 | 2025-05-30 | False | |||
| 17060000035416 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 45 | PA794042 | 2025-05-30 | False | |||
| 17060000035417 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 46 | PA841919 | 2025-05-30 | False | |||
| 17060000035418 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 47 | PA712015 | 2025-05-30 | False | |||
| 17060000035419 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 48 | PA606573 | 2025-05-30 | False | |||
| 17060000035420 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 49 | PA608826 | 2025-05-30 | False | |||
| 17060000035421 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 50 | PA841633 | 2025-05-30 | False | |||
| 17060000035422 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 51 | PA795200 | 2025-05-30 | False | |||
| 17060000035423 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 52 | PA841351 | 2025-05-30 | False | |||
| 17060000035424 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 53 | PA794854 | 2025-05-30 | False | |||
| 17060000035425 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 54 | PA607193 | 2025-05-30 | False | |||
| 17060000035426 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 55 | PA842195 | 2025-05-30 | False | |||
| 17060000035427 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 56 | PA794658 | 2025-05-30 | False | |||
| 17060000035428 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 57 | PA605694 | 2025-05-30 | False | |||
| 17060000035429 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 58 | PA609332 | 2025-05-30 | False | |||
| 17060000035430 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 59 | PA841665 | 2025-05-30 | False | |||
| 17060000035431 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 60 | PA794786 | 2025-05-30 | False | |||
| 17060000035432 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 61 | PA267780 | 2025-05-30 | False | |||
| 17060000035433 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 62 | PA1327 | 2025-05-30 | False | |||
| 17060000035434 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 63 | PA793980 | 2025-05-30 | False | |||
| 17060000035435 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 64 | PA822617 | 2025-05-30 | False | |||
| 17060000035436 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 65 | PA719736 | 2025-05-30 | False | |||
| 17060000035437 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 66 | PA795010 | 2025-05-30 | False | |||
| 17060000035438 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 67 | PA333285 | 2025-05-30 | False | |||
| 17060000035439 | L17/dossiers | 17 | 17060000035370 | 17060000035370 | 68 | PA794234 | 2025-05-30 | False |