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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 16060000002035 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 94 | PA331973 | 2014-12-09 | False | |||
| 16060000002036 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 95 | PA609218 | 2014-12-09 | False | |||
| 16060000002037 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 96 | PA336015 | 2014-12-09 | False | |||
| 16060000002038 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 97 | PA608684 | 2014-12-09 | False | |||
| 16060000002039 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 98 | PA606161 | 2014-12-09 | False | |||
| 16060000002040 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 99 | PA606924 | 2014-12-09 | False | |||
| 16060000002041 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 100 | PA331835 | 2014-12-09 | False | |||
| 16060000002042 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 101 | PA335054 | 2014-12-09 | False | |||
| 16060000002043 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 102 | PA608785 | 2014-12-09 | False | |||
| 16060000002044 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 103 | PA1816 | 2014-12-09 | False | |||
| 16060000002045 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 104 | PA610481 | 2014-12-09 | False | |||
| 16060000002046 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 105 | PA606555 | 2014-12-09 | False | |||
| 16060000002047 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 106 | PA341246 | 2014-12-09 | False | |||
| 16060000002048 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 107 | PA331658 | 2014-12-09 | False | |||
| 16060000002049 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 108 | PA1936 | 2014-12-09 | False | |||
| 16060000002050 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 109 | PA331753 | 2014-12-09 | False | |||
| 16060000002051 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 110 | PA1963 | 2014-12-09 | False | |||
| 16060000002052 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 111 | PA330130 | 2014-12-09 | False | |||
| 16060000002053 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 112 | PA607761 | 2014-12-09 | False | |||
| 16060000002054 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 113 | PA607283 | 2014-12-09 | False | |||
| 16060000002055 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 114 | PA334116 | 2014-12-09 | False | |||
| 16060000002056 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 115 | PA332206 | 2014-12-09 | False | |||
| 16060000002057 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 116 | PA331807 | 2014-12-09 | False | |||
| 16060000002058 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 117 | PA335319 | 2014-12-09 | False | |||
| 16060000002059 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 118 | PA267479 | 2014-12-09 | False | |||
| 16060000002060 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 119 | PA334755 | 2014-12-09 | False | |||
| 16060000002061 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 120 | PA2265 | 2014-12-09 | False | |||
| 16060000002062 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 121 | PA606030 | 2014-12-09 | False | |||
| 16060000002063 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 122 | PA642885 | 2014-12-09 | False | |||
| 16060000002064 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 123 | PA610729 | 2014-12-09 | False | |||
| 16060000002065 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 124 | PA267534 | 2014-12-09 | False | |||
| 16060000002066 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 125 | PA607769 | 2014-12-09 | False | |||
| 16060000002067 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 126 | PA607595 | 2014-12-09 | False | |||
| 16060000002068 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 127 | PA2365 | 2014-12-09 | False | |||
| 16060000002069 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 128 | PA610075 | 2014-12-09 | False | |||
| 16060000002070 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 129 | PA608172 | 2014-12-09 | False | |||
| 16060000002071 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 130 | PA610354 | 2014-12-09 | False | |||
| 16060000002072 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 131 | PA606375 | 2014-12-09 | False | |||
| 16060000002073 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 132 | PA609963 | 2014-12-09 | False | |||
| 16060000002074 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 133 | PA606225 | 2014-12-09 | False | |||
| 16060000002075 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 134 | PA643069 | 2014-12-09 | False | |||
| 16060000002076 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 135 | PA331014 | 2014-12-09 | False | |||
| 16060000002077 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 136 | PA341981 | 2014-12-09 | False | |||
| 16060000002078 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 137 | PA2549 | 2014-12-09 | False | |||
| 16060000002079 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 138 | PA2603 | 2014-12-09 | False | |||
| 16060000002080 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 139 | PA606586 | 2014-12-09 | False | |||
| 16060000002081 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 140 | PA343493 | 2014-12-09 | False | |||
| 16060000002082 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 141 | PA2631 | 2014-12-09 | False | |||
| 16060000002083 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 142 | PA610752 | 2014-12-09 | False | |||
| 16060000002084 | L16/dossiers | 16 | 16060000001940 | 16060000001940 | 143 | PA335017 | 2014-12-09 | False |