dossiers.document_co_signataire
Chemin document.coSignataires.coSignataire · présence : L17 26 %, L16 26 %, L15 28 %, L14 29 %
309 130 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 17060000077050 | L17/dossiers | 17 | 17060000077026 | 17060000077026 | 23 | PA1390 | 2000-10-04 | False | |||
| 17060000077051 | L17/dossiers | 17 | 17060000077026 | 17060000077026 | 24 | PA1447 | 2000-10-04 | False | |||
| 17060000077052 | L17/dossiers | 17 | 17060000077026 | 17060000077026 | 25 | PA1460 | 2000-10-04 | False | |||
| 17060000077053 | L17/dossiers | 17 | 17060000077026 | 17060000077026 | 26 | PA1461 | 2000-10-04 | False | |||
| 17060000077054 | L17/dossiers | 17 | 17060000077026 | 17060000077026 | 27 | PA1479 | 2000-10-04 | False | |||
| 17060000077055 | L17/dossiers | 17 | 17060000077026 | 17060000077026 | 28 | PA1486 | 2000-10-04 | False | |||
| 17060000077056 | L17/dossiers | 17 | 17060000077026 | 17060000077026 | 29 | PA1523 | 2000-10-04 | False | |||
| 17060000077057 | L17/dossiers | 17 | 17060000077026 | 17060000077026 | 30 | PA1527 | 2000-10-04 | False | |||
| 17060000077058 | L17/dossiers | 17 | 17060000077026 | 17060000077026 | 31 | PA1530 | 2000-10-04 | False | |||
| 17060000077059 | L17/dossiers | 17 | 17060000077026 | 17060000077026 | 32 | PA1563 | 2000-10-04 | False | |||
| 17060000077060 | L17/dossiers | 17 | 17060000077026 | 17060000077026 | 33 | PA1597 | 2000-10-04 | False | |||
| 17060000077061 | L17/dossiers | 17 | 17060000077026 | 17060000077026 | 34 | PA205280 | 2000-10-04 | False | |||
| 17060000077062 | L17/dossiers | 17 | 17060000077026 | 17060000077026 | 35 | PA1824 | 2000-10-04 | False | |||
| 17060000077063 | L17/dossiers | 17 | 17060000077026 | 17060000077026 | 36 | PA1828 | 2000-10-04 | False | |||
| 17060000077064 | L17/dossiers | 17 | 17060000077026 | 17060000077026 | 37 | PA1851 | 2000-10-04 | False | |||
| 17060000077065 | L17/dossiers | 17 | 17060000077026 | 17060000077026 | 38 | PA1902 | 2000-10-04 | False | |||
| 17060000077066 | L17/dossiers | 17 | 17060000077026 | 17060000077026 | 39 | PA1879 | 2000-10-04 | False | |||
| 17060000077067 | L17/dossiers | 17 | 17060000077026 | 17060000077026 | 40 | PA1951 | 2000-10-04 | False | |||
| 17060000077068 | L17/dossiers | 17 | 17060000077026 | 17060000077026 | 41 | PA2003 | 2000-10-04 | False | |||
| 17060000077069 | L17/dossiers | 17 | 17060000077026 | 17060000077026 | 42 | PA210810 | 2000-10-04 | False | |||
| 17060000077070 | L17/dossiers | 17 | 17060000077026 | 17060000077026 | 43 | PA2081 | 2000-10-04 | False | |||
| 17060000077071 | L17/dossiers | 17 | 17060000077026 | 17060000077026 | 44 | PA2093 | 2000-10-04 | False | |||
| 17060000077072 | L17/dossiers | 17 | 17060000077026 | 17060000077026 | 45 | PA2180 | 2000-10-04 | False | |||
| 17060000077073 | L17/dossiers | 17 | 17060000077026 | 17060000077026 | 46 | PA2202 | 2000-10-04 | False | |||
| 17060000077074 | L17/dossiers | 17 | 17060000077026 | 17060000077026 | 47 | PA2254 | 2000-10-04 | False | |||
| 17060000077075 | L17/dossiers | 17 | 17060000077026 | 17060000077026 | 48 | PA2263 | 2000-10-04 | False | |||
| 17060000077076 | L17/dossiers | 17 | 17060000077026 | 17060000077026 | 49 | PA2292 | 2000-10-04 | False | |||
| 17060000077077 | L17/dossiers | 17 | 17060000077026 | 17060000077026 | 50 | PA2303 | 2000-10-04 | False | |||
| 17060000077078 | L17/dossiers | 17 | 17060000077026 | 17060000077026 | 51 | PA2306 | 2000-10-04 | False | |||
| 17060000077079 | L17/dossiers | 17 | 17060000077026 | 17060000077026 | 52 | PA2389 | 2000-10-04 | False | |||
| 17060000077080 | L17/dossiers | 17 | 17060000077026 | 17060000077026 | 53 | PA2556 | 2000-10-04 | False | |||
| 17060000077081 | L17/dossiers | 17 | 17060000077026 | 17060000077026 | 54 | PA2539 | 2000-10-04 | False | |||
| 17060000077082 | L17/dossiers | 17 | 17060000077026 | 17060000077026 | 55 | PA2708 | 2000-10-04 | False | |||
| 17060000077083 | L17/dossiers | 17 | 17060000077026 | 17060000077026 | 56 | PA2758 | 2000-10-04 | False | |||
| 17060000077084 | L17/dossiers | 17 | 17060000077026 | 17060000077026 | 57 | PA2835 | 2000-10-04 | False | |||
| 17060000077085 | L17/dossiers | 17 | 17060000077026 | 17060000077026 | 58 | PA2860 | 2000-10-04 | False | |||
| 17060000077086 | L17/dossiers | 17 | 17060000077026 | 17060000077026 | 59 | PA2879 | 2000-10-04 | False | |||
| 17060000077087 | L17/dossiers | 17 | 17060000077026 | 17060000077026 | 60 | PA2905 | 2000-10-04 | False | |||
| 17060000077088 | L17/dossiers | 17 | 17060000077026 | 17060000077026 | 61 | PA2924 | 2000-10-04 | False | |||
| 17060000077091 | L17/dossiers | 17 | 17060000077089 | 17060000077089 | 1 | PA1597 | 2000-11-14 | True | |||
| 17060000077092 | L17/dossiers | 17 | 17060000077089 | 17060000077089 | 2 | 2000-11-14 | False | PO77714 | False | ||
| 17060000077095 | L17/dossiers | 17 | 17060000077093 | 17060000077093 | 1 | PA1037 | 2001-01-16 | True | |||
| 17060000077096 | L17/dossiers | 17 | 17060000077093 | 17060000077093 | 2 | PA2227 | 2001-01-16 | True | |||
| 17060000077099 | L17/dossiers | 17 | 17060000077097 | 17060000077097 | 1 | 2001-06-12 | False | PO77707 | False | ||
| 17060000077110 | L17/dossiers | 17 | 17060000077108 | 17060000077108 | 1 | PA287 | 2004-07-30 | False | |||
| 17060000077111 | L17/dossiers | 17 | 17060000077108 | 17060000077108 | 2 | PA222783 | 2004-07-30 | False | |||
| 17060000077112 | L17/dossiers | 17 | 17060000077108 | 17060000077108 | 3 | PA1075 | 2004-07-30 | False | |||
| 17060000077113 | L17/dossiers | 17 | 17060000077108 | 17060000077108 | 4 | PA1203 | 2004-07-30 | False | |||
| 17060000077114 | L17/dossiers | 17 | 17060000077108 | 17060000077108 | 5 | PA1442 | 2004-07-30 | False | |||
| 17060000077115 | L17/dossiers | 17 | 17060000077108 | 17060000077108 | 6 | PA227091 | 2004-07-30 | False |