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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 16060000013784 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 169 | PA795278 | 2022-11-29 | False | |||
| 16060000013785 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 170 | PA332228 | 2022-11-29 | False | |||
| 16060000013786 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 171 | PA795266 | 2022-11-29 | False | |||
| 16060000013787 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 172 | PA642868 | 2022-11-29 | False | |||
| 16060000013788 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 173 | PA267042 | 2022-11-29 | False | |||
| 16060000013789 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 174 | PA794470 | 2022-11-29 | False | |||
| 16060000013790 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 175 | PA794234 | 2022-11-29 | False | |||
| 16060000013791 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 176 | PA719778 | 2022-11-29 | False | |||
| 16060000013792 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 177 | PA719052 | 2022-11-29 | False | |||
| 16060000013793 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 178 | PA794818 | 2022-11-29 | False | |||
| 16060000013794 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 179 | PA719382 | 2022-11-29 | False | |||
| 16060000013795 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 180 | PA794426 | 2022-11-29 | False | |||
| 16060000013796 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 181 | PA794838 | 2022-11-29 | False | |||
| 16060000013797 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 182 | PA720230 | 2022-11-29 | False | |||
| 16060000013798 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 183 | PA720908 | 2022-11-29 | False | |||
| 16060000013799 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 184 | PA793398 | 2022-11-29 | False | |||
| 16060000013800 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 185 | PA793572 | 2022-11-29 | False | |||
| 16060000013801 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 186 | PA719528 | 2022-11-29 | False | |||
| 16060000013802 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 187 | PA795270 | 2022-11-29 | False | |||
| 16060000013803 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 188 | PA793306 | 2022-11-29 | False | |||
| 16060000013804 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 189 | PA720552 | 2022-11-29 | False | |||
| 16060000013805 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 190 | PA722336 | 2022-11-29 | False | |||
| 16060000013806 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 191 | PA795350 | 2022-11-29 | False | |||
| 16060000013807 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 192 | PA421348 | 2022-11-29 | False | |||
| 16060000013808 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 193 | PA795026 | 2022-11-29 | False | |||
| 16060000013809 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 194 | PA719396 | 2022-11-29 | False | |||
| 16060000013810 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 195 | PA607193 | 2022-11-29 | 2022-12-12 | False | ||
| 16060000013811 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 196 | PA793560 | 2023-04-13 | False | |||
| 16060000013812 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 197 | PA719558 | 2023-04-13 | False | |||
| 16060000013813 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 198 | PA720256 | 2023-04-13 | False | |||
| 16060000013814 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 199 | PA805166 | 2023-04-13 | False | |||
| 16060000013815 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 200 | PA719488 | 2023-04-13 | False | |||
| 16060000013816 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 201 | PA719024 | 2023-04-13 | False | |||
| 16060000013817 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 202 | PA720162 | 2023-04-13 | False | |||
| 16060000013818 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 203 | PA721608 | 2023-04-13 | False | |||
| 16060000013819 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 204 | PA721336 | 2023-04-13 | False | |||
| 16060000013820 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 205 | PA720772 | 2023-04-13 | False | |||
| 16060000013821 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 206 | PA793520 | 2023-04-13 | False | |||
| 16060000013822 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 207 | PA793716 | 2023-04-13 | False | |||
| 16060000013823 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 208 | PA719266 | 2023-04-13 | False | |||
| 16060000013824 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 209 | PA793122 | 2023-04-13 | False | |||
| 16060000013825 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 210 | PA794194 | 2023-04-13 | False | |||
| 16060000013826 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 211 | PA793792 | 2023-04-13 | False | |||
| 16060000013827 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 212 | PA605694 | 2023-04-13 | False | |||
| 16060000013828 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 213 | PA795120 | 2023-04-13 | False | |||
| 16060000013829 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 214 | PA795604 | 2023-04-13 | False | |||
| 16060000013830 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 215 | PA722284 | 2023-04-13 | False | |||
| 16060000013831 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 216 | PA721760 | 2023-04-13 | False | |||
| 16060000013832 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 217 | PA720006 | 2023-04-13 | False | |||
| 16060000013833 | L16/dossiers | 16 | 16060000013614 | 16060000013614 | 218 | PA720560 | 2023-04-13 | False |