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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 16060000003129 | L16/dossiers | 16 | 16060000003025 | 16060000003025 | 103 | PA718810 | 2021-10-12 | False | |||
| 16060000003130 | L16/dossiers | 16 | 16060000003025 | 16060000003025 | 104 | PA721600 | 2021-10-12 | False | |||
| 16060000003131 | L16/dossiers | 16 | 16060000003025 | 16060000003025 | 105 | PA721110 | 2021-10-12 | False | |||
| 16060000003132 | L16/dossiers | 16 | 16060000003025 | 16060000003025 | 106 | PA774960 | 2021-10-12 | False | |||
| 16060000003133 | L16/dossiers | 16 | 16060000003025 | 16060000003025 | 107 | PA267204 | 2021-10-12 | False | |||
| 16060000003134 | L16/dossiers | 16 | 16060000003025 | 16060000003025 | 108 | PA721768 | 2021-10-12 | False | |||
| 16060000003135 | L16/dossiers | 16 | 16060000003025 | 16060000003025 | 109 | PA719592 | 2021-10-12 | False | |||
| 16060000003136 | L16/dossiers | 16 | 16060000003025 | 16060000003025 | 110 | PA720488 | 2021-10-12 | False | |||
| 16060000003137 | L16/dossiers | 16 | 16060000003025 | 16060000003025 | 111 | PA722118 | 2021-10-12 | False | |||
| 16060000003138 | L16/dossiers | 16 | 16060000003025 | 16060000003025 | 112 | PA718860 | 2021-10-12 | False | |||
| 16060000003139 | L16/dossiers | 16 | 16060000003025 | 16060000003025 | 113 | PA720672 | 2021-10-12 | False | |||
| 16060000003140 | L16/dossiers | 16 | 16060000003025 | 16060000003025 | 114 | PA720014 | 2021-10-12 | False | |||
| 16060000003141 | L16/dossiers | 16 | 16060000003025 | 16060000003025 | 115 | PA334768 | 2021-10-12 | False | |||
| 16060000003142 | L16/dossiers | 16 | 16060000003025 | 16060000003025 | 116 | PA718780 | 2021-10-12 | False | |||
| 16060000003143 | L16/dossiers | 16 | 16060000003025 | 16060000003025 | 117 | PA720394 | 2021-10-12 | False | |||
| 16060000003144 | L16/dossiers | 16 | 16060000003025 | 16060000003025 | 118 | PA718682 | 2021-10-12 | False | |||
| 16060000003145 | L16/dossiers | 16 | 16060000003025 | 16060000003025 | 119 | PA719092 | 2021-10-12 | False | |||
| 16060000003146 | L16/dossiers | 16 | 16060000003025 | 16060000003025 | 120 | PA643134 | 2021-10-12 | False | |||
| 16060000003147 | L16/dossiers | 16 | 16060000003025 | 16060000003025 | 121 | PA718768 | 2021-10-12 | False | |||
| 16060000003148 | L16/dossiers | 16 | 16060000003025 | 16060000003025 | 122 | PA719930 | 2021-10-12 | False | |||
| 16060000003149 | L16/dossiers | 16 | 16060000003025 | 16060000003025 | 123 | PA720704 | 2021-10-12 | False | |||
| 16060000003150 | L16/dossiers | 16 | 16060000003025 | 16060000003025 | 124 | PA331582 | 2021-10-12 | False | |||
| 16060000003151 | L16/dossiers | 16 | 16060000003025 | 16060000003025 | 125 | PA719512 | 2021-10-12 | False | |||
| 16060000003152 | L16/dossiers | 16 | 16060000003025 | 16060000003025 | 126 | PA722260 | 2021-10-12 | False | |||
| 16060000003153 | L16/dossiers | 16 | 16060000003025 | 16060000003025 | 127 | PA721474 | 2021-10-12 | False | |||
| 16060000003154 | L16/dossiers | 16 | 16060000003025 | 16060000003025 | 128 | PA2952 | 2021-10-12 | False | |||
| 16060000003155 | L16/dossiers | 16 | 16060000003025 | 16060000003025 | 129 | PA722030 | 2021-10-12 | False | |||
| 16060000003156 | L16/dossiers | 16 | 16060000003025 | 16060000003025 | 130 | PA342415 | 2021-10-12 | False | |||
| 16060000003157 | L16/dossiers | 16 | 16060000003025 | 16060000003025 | 131 | PA607553 | 2021-10-12 | False | |||
| 16060000003158 | L16/dossiers | 16 | 16060000003025 | 16060000003025 | 132 | PA719600 | 2021-10-12 | False | |||
| 16060000003159 | L16/dossiers | 16 | 16060000003025 | 16060000003025 | 133 | PA719420 | 2021-10-12 | False | |||
| 16060000003160 | L16/dossiers | 16 | 16060000003025 | 16060000003025 | 134 | PA334116 | 2021-10-12 | False | |||
| 16060000003161 | L16/dossiers | 16 | 16060000003025 | 16060000003025 | 135 | PA2155 | 2021-10-12 | False | |||
| 16060000003171 | L16/dossiers | 16 | 16060000003169 | 16060000003169 | 1 | PA2150 | 2021-11-03 | False | |||
| 16060000003172 | L16/dossiers | 16 | 16060000003169 | 16060000003169 | 2 | PA720892 | 2021-11-03 | False | |||
| 16060000003173 | L16/dossiers | 16 | 16060000003169 | 16060000003169 | 3 | PA721210 | 2021-11-03 | False | |||
| 16060000003174 | L16/dossiers | 16 | 16060000003169 | 16060000003169 | 4 | PA588884 | 2021-11-03 | False | |||
| 16060000003175 | L16/dossiers | 16 | 16060000003169 | 16060000003169 | 5 | PA720430 | 2021-11-03 | False | |||
| 16060000003176 | L16/dossiers | 16 | 16060000003169 | 16060000003169 | 6 | PA721202 | 2021-11-03 | False | |||
| 16060000003177 | L16/dossiers | 16 | 16060000003169 | 16060000003169 | 7 | PA720286 | 2021-11-03 | False | |||
| 16060000003178 | L16/dossiers | 16 | 16060000003169 | 16060000003169 | 8 | PA718868 | 2021-11-03 | False | |||
| 16060000003179 | L16/dossiers | 16 | 16060000003169 | 16060000003169 | 9 | PA721960 | 2021-11-03 | False | |||
| 16060000003180 | L16/dossiers | 16 | 16060000003169 | 16060000003169 | 10 | PA719578 | 2021-11-03 | False | |||
| 16060000003181 | L16/dossiers | 16 | 16060000003169 | 16060000003169 | 11 | PA720422 | 2021-11-03 | False | |||
| 16060000003182 | L16/dossiers | 16 | 16060000003169 | 16060000003169 | 12 | PA721062 | 2021-11-03 | False | |||
| 16060000003183 | L16/dossiers | 16 | 16060000003169 | 16060000003169 | 13 | PA719676 | 2021-11-03 | False | |||
| 16060000003184 | L16/dossiers | 16 | 16060000003169 | 16060000003169 | 14 | PA721226 | 2021-11-03 | False | |||
| 16060000003185 | L16/dossiers | 16 | 16060000003169 | 16060000003169 | 15 | PA722142 | 2021-11-03 | False | |||
| 16060000003186 | L16/dossiers | 16 | 16060000003169 | 16060000003169 | 16 | PA718860 | 2021-11-03 | False | |||
| 16060000003187 | L16/dossiers | 16 | 16060000003169 | 16060000003169 | 17 | PA719448 | 2021-12-06 | False |