dossiers.document_co_signataire
Chemin document.coSignataires.coSignataire · présence : L17 26 %, L16 26 %, L15 28 %, L14 29 %
309 313 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 16060000002677 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 225 | PA332747 | 2020-12-14 | False | |||
| 16060000002678 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 226 | PA721616 | 2020-12-14 | False | |||
| 16060000002679 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 227 | PA720878 | 2020-12-14 | False | |||
| 16060000002680 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 228 | PA720138 | 2020-12-14 | False | |||
| 16060000002681 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 229 | PA719972 | 2020-12-14 | False | |||
| 16060000002682 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 230 | PA720780 | 2020-12-14 | False | |||
| 16060000002683 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 231 | PA720960 | 2020-12-14 | False | |||
| 16060000002684 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 232 | PA721768 | 2020-12-14 | False | |||
| 16060000002685 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 233 | PA346876 | 2020-12-14 | False | |||
| 16060000002686 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 234 | PA719420 | 2020-12-14 | False | |||
| 16060000002687 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 235 | PA720190 | 2020-12-14 | False | |||
| 16060000002688 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 236 | PA720754 | 2020-12-14 | False | |||
| 16060000002689 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 237 | PA722118 | 2020-12-14 | False | |||
| 16060000002690 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 238 | PA719350 | 2020-12-14 | False | |||
| 16060000002691 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 239 | PA721690 | 2020-12-14 | False | |||
| 16060000002692 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 240 | PA719550 | 2020-12-14 | False | |||
| 16060000002693 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 241 | PA720246 | 2020-12-14 | False | |||
| 16060000002694 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 242 | PA721584 | 2020-12-14 | False | |||
| 16060000002695 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 243 | PA720854 | 2020-12-14 | False | |||
| 16060000002696 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 244 | PA722336 | 2020-12-14 | False | |||
| 16060000002697 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 245 | PA720830 | 2020-12-14 | False | |||
| 16060000002698 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 246 | PA719302 | 2020-12-14 | False | |||
| 16060000002699 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 247 | PA720014 | 2020-12-14 | False | |||
| 16060000002700 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 248 | PA334768 | 2020-12-14 | False | |||
| 16060000002701 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 249 | PA2828 | 2020-12-14 | False | |||
| 16060000002702 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 250 | PA719540 | 2020-12-14 | False | |||
| 16060000002703 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 251 | PA720394 | 2020-12-14 | False | |||
| 16060000002704 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 252 | PA718682 | 2020-12-14 | False | |||
| 16060000002705 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 253 | PA718768 | 2020-12-14 | False | |||
| 16060000002706 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 254 | PA718728 | 2020-12-14 | False | |||
| 16060000002707 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 255 | PA721542 | 2020-12-14 | False | |||
| 16060000002708 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 256 | PA722102 | 2020-12-14 | False | |||
| 16060000002709 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 257 | PA606639 | 2020-12-14 | False | |||
| 16060000002710 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 258 | PA721262 | 2020-12-14 | False | |||
| 16060000002711 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 259 | PA720318 | 2020-12-14 | False | |||
| 16060000002712 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 260 | PA721864 | 2020-12-14 | False | |||
| 16060000002713 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 261 | PA718962 | 2020-12-14 | False | |||
| 16060000002714 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 262 | PA719558 | 2020-12-14 | False | |||
| 16060000002715 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 263 | PA720256 | 2020-12-14 | False | |||
| 16060000002716 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 264 | PA721836 | 2020-12-14 | False | |||
| 16060000002717 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 265 | PA719942 | 2020-12-14 | False | |||
| 16060000002718 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 266 | PA719488 | 2020-12-14 | False | |||
| 16060000002719 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 267 | PA719024 | 2020-12-14 | False | |||
| 16060000002720 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 268 | PA720162 | 2020-12-14 | False | |||
| 16060000002721 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 269 | PA721608 | 2020-12-14 | False | |||
| 16060000002722 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 270 | PA721808 | 2020-12-14 | False | |||
| 16060000002723 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 271 | PA719266 | 2020-12-14 | False | |||
| 16060000002724 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 272 | PA720598 | 2020-12-14 | False | |||
| 16060000002725 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 273 | PA720652 | 2020-12-14 | False | |||
| 16060000002726 | L16/dossiers | 16 | 16060000002451 | 16060000002451 | 274 | PA719044 | 2020-12-14 | False |