dossiers.document_co_signataire
Chemin document.coSignataires.coSignataire · présence : L17 26 %, L16 26 %, L15 28 %, L14 29 %
305 264 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 17060000026781 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 95 | PA608826 | 2025-03-31 | False | |||
| 17060000026782 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 96 | PA794106 | 2025-03-31 | False | |||
| 17060000026783 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 97 | PA794554 | 2025-03-31 | False | |||
| 17060000026784 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 98 | PA721984 | 2025-03-31 | False | |||
| 17060000026785 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 99 | PA840955 | 2025-03-31 | False | |||
| 17060000026786 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 100 | PA841885 | 2025-03-31 | False | |||
| 17060000026787 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 101 | PA719632 | 2025-03-31 | False | |||
| 17060000026788 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 102 | PA795240 | 2025-03-31 | False | |||
| 17060000026789 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 103 | PA795228 | 2025-03-31 | False | |||
| 17060000026790 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 104 | PA794702 | 2025-03-31 | False | |||
| 17060000026791 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 105 | PA608172 | 2025-03-31 | False | |||
| 17060000026792 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 106 | PA841507 | 2025-03-31 | False | |||
| 17060000026793 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 107 | PA841601 | 2025-03-31 | False | |||
| 17060000026794 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 108 | PA795876 | 2025-03-31 | False | |||
| 17060000026795 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 109 | PA840979 | 2025-03-31 | False | |||
| 17060000026796 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 110 | PA794906 | 2025-03-31 | False | |||
| 17060000026797 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 111 | PA774958 | 2025-03-31 | False | |||
| 17060000026798 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 112 | PA794008 | 2025-03-31 | False | |||
| 17060000026799 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 113 | PA794798 | 2025-03-31 | False | |||
| 17060000026800 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 114 | PA842299 | 2025-03-31 | False | |||
| 17060000026801 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 115 | PA695512 | 2025-03-31 | False | |||
| 17060000026802 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 116 | PA794138 | 2025-03-31 | False | |||
| 17060000026803 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 117 | PA794830 | 2025-03-31 | False | |||
| 17060000026804 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 118 | PA335054 | 2025-03-31 | False | |||
| 17060000026805 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 119 | PA721210 | 2025-03-31 | False | |||
| 17060000026806 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 120 | PA796106 | 2025-03-31 | False | |||
| 17060000026807 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 121 | PA719272 | 2025-03-31 | False | |||
| 17060000026808 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 122 | PA795588 | 2025-03-31 | False | |||
| 17060000026809 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 123 | PA720720 | 2025-03-31 | False | |||
| 17060000026810 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 124 | PA842263 | 2025-03-31 | False | |||
| 17060000026811 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 125 | PA793452 | 2025-03-31 | False | |||
| 17060000026812 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 126 | PA721442 | 2025-03-28 | 2025-03-31 | False | ||
| 17060000026813 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 127 | PA795084 | 2025-03-31 | False | |||
| 17060000026814 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 128 | PA1567 | 2025-03-31 | False | |||
| 17060000026815 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 129 | PA793980 | 2025-03-31 | False | |||
| 17060000026816 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 130 | PA842105 | 2025-03-31 | False | |||
| 17060000026817 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 131 | PA795120 | 2025-03-31 | False | |||
| 17060000026818 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 132 | PA331973 | 2025-03-31 | False | |||
| 17060000026819 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 133 | PA795010 | 2025-03-31 | False | |||
| 17060000026820 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 134 | PA794118 | 2025-03-31 | False | |||
| 17060000026821 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 135 | PA841657 | 2025-03-31 | False | |||
| 17060000026822 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 136 | PA794178 | 2025-03-03 | 2025-03-18 | False | ||
| 17060000026823 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 137 | PA841539 | 2025-03-31 | False | |||
| 17060000026824 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 138 | PA841419 | 2025-03-31 | False | |||
| 17060000026825 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 139 | PA842117 | 2025-03-31 | False | |||
| 17060000026826 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 140 | PA720430 | 2025-03-31 | False | |||
| 17060000026827 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 141 | PA841295 | 2025-03-31 | False | |||
| 17060000026828 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 142 | PA842013 | 2025-03-31 | False | |||
| 17060000026829 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 143 | PA642725 | 2025-03-31 | False | |||
| 17060000026830 | L17/dossiers | 17 | 17060000026685 | 17060000026685 | 144 | PA793772 | 2025-03-31 | False |