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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 17060000003185 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 104 | PA610481 | 2014-12-09 | False | |||
| 17060000003186 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 105 | PA606555 | 2014-12-09 | False | |||
| 17060000003187 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 106 | PA341246 | 2014-12-09 | False | |||
| 17060000003188 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 107 | PA331658 | 2014-12-09 | False | |||
| 17060000003189 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 108 | PA1936 | 2014-12-09 | False | |||
| 17060000003190 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 109 | PA331753 | 2014-12-09 | False | |||
| 17060000003191 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 110 | PA1963 | 2014-12-09 | False | |||
| 17060000003192 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 111 | PA330130 | 2014-12-09 | False | |||
| 17060000003193 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 112 | PA607761 | 2014-12-09 | False | |||
| 17060000003194 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 113 | PA607283 | 2014-12-09 | False | |||
| 17060000003195 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 114 | PA334116 | 2014-12-09 | False | |||
| 17060000003196 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 115 | PA332206 | 2014-12-09 | False | |||
| 17060000003197 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 116 | PA331807 | 2014-12-09 | False | |||
| 17060000003198 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 117 | PA335319 | 2014-12-09 | False | |||
| 17060000003199 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 118 | PA267479 | 2014-12-09 | False | |||
| 17060000003200 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 119 | PA334755 | 2014-12-09 | False | |||
| 17060000003201 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 120 | PA2265 | 2014-12-09 | False | |||
| 17060000003202 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 121 | PA606030 | 2014-12-09 | False | |||
| 17060000003203 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 122 | PA642885 | 2014-12-09 | False | |||
| 17060000003204 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 123 | PA610729 | 2014-12-09 | False | |||
| 17060000003205 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 124 | PA267534 | 2014-12-09 | False | |||
| 17060000003206 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 125 | PA607769 | 2014-12-09 | False | |||
| 17060000003207 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 126 | PA607595 | 2014-12-09 | False | |||
| 17060000003208 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 127 | PA2365 | 2014-12-09 | False | |||
| 17060000003209 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 128 | PA610075 | 2014-12-09 | False | |||
| 17060000003210 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 129 | PA608172 | 2014-12-09 | False | |||
| 17060000003211 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 130 | PA610354 | 2014-12-09 | False | |||
| 17060000003212 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 131 | PA606375 | 2014-12-09 | False | |||
| 17060000003213 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 132 | PA609963 | 2014-12-09 | False | |||
| 17060000003214 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 133 | PA606225 | 2014-12-09 | False | |||
| 17060000003215 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 134 | PA643069 | 2014-12-09 | False | |||
| 17060000003216 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 135 | PA331014 | 2014-12-09 | False | |||
| 17060000003217 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 136 | PA341981 | 2014-12-09 | False | |||
| 17060000003218 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 137 | PA2549 | 2014-12-09 | False | |||
| 17060000003219 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 138 | PA2603 | 2014-12-09 | False | |||
| 17060000003220 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 139 | PA606586 | 2014-12-09 | False | |||
| 17060000003221 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 140 | PA343493 | 2014-12-09 | False | |||
| 17060000003222 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 141 | PA2631 | 2014-12-09 | False | |||
| 17060000003223 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 142 | PA610752 | 2014-12-09 | False | |||
| 17060000003224 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 143 | PA335017 | 2014-12-09 | False | |||
| 17060000003225 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 144 | PA605703 | 2014-12-09 | False | |||
| 17060000003226 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 145 | PA2799 | 2014-12-09 | False | |||
| 17060000003227 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 146 | PA334768 | 2014-12-09 | False | |||
| 17060000003228 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 147 | PA607395 | 2014-12-09 | False | |||
| 17060000003229 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 148 | PA609205 | 2014-12-09 | False | |||
| 17060000003230 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 149 | PA608695 | 2014-12-09 | False | |||
| 17060000003231 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 150 | PA642788 | 2014-12-09 | False | |||
| 17060000003232 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 151 | PA606639 | 2014-12-09 | False | |||
| 17060000003233 | L17/dossiers | 17 | 17060000003080 | 17060000003080 | 152 | PA334951 | 2014-12-09 | False | |||
| 17060000003252 | L17/dossiers | 17 | 17060000003250 | 17060000003250 | 1 | PA610427 | 2015-11-25 | False |