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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 16060000002964 | L16/dossiers | 16 | 16060000002872 | 16060000002872 | 91 | PA719718 | 2021-05-04 | False | |||
| 16060000002965 | L16/dossiers | 16 | 16060000002872 | 16060000002872 | 92 | PA721946 | 2021-05-04 | False | |||
| 16060000002966 | L16/dossiers | 16 | 16060000002872 | 16060000002872 | 93 | PA719080 | 2021-05-04 | False | |||
| 16060000002967 | L16/dossiers | 16 | 16060000002872 | 16060000002872 | 94 | PA720146 | 2021-05-04 | False | |||
| 16060000002968 | L16/dossiers | 16 | 16060000002872 | 16060000002872 | 95 | PA721726 | 2021-05-04 | False | |||
| 16060000002969 | L16/dossiers | 16 | 16060000002872 | 16060000002872 | 96 | PA677483 | 2021-05-04 | False | |||
| 16060000002970 | L16/dossiers | 16 | 16060000002872 | 16060000002872 | 97 | PA719338 | 2021-05-04 | False | |||
| 16060000002971 | L16/dossiers | 16 | 16060000002872 | 16060000002872 | 98 | PA720370 | 2021-05-04 | False | |||
| 16060000002972 | L16/dossiers | 16 | 16060000002872 | 16060000002872 | 99 | PA719130 | 2021-05-04 | False | |||
| 16060000002973 | L16/dossiers | 16 | 16060000002872 | 16060000002872 | 100 | PA719952 | 2021-05-04 | False | |||
| 16060000002974 | L16/dossiers | 16 | 16060000002872 | 16060000002872 | 101 | PA721876 | 2021-05-04 | False | |||
| 16060000002975 | L16/dossiers | 16 | 16060000002872 | 16060000002872 | 102 | PA719850 | 2021-05-04 | False | |||
| 16060000002976 | L16/dossiers | 16 | 16060000002872 | 16060000002872 | 103 | PA720492 | 2021-05-04 | False | |||
| 16060000002977 | L16/dossiers | 16 | 16060000002872 | 16060000002872 | 104 | PA720402 | 2021-05-04 | False | |||
| 16060000002978 | L16/dossiers | 16 | 16060000002872 | 16060000002872 | 105 | PA720944 | 2021-05-04 | False | |||
| 16060000002979 | L16/dossiers | 16 | 16060000002872 | 16060000002872 | 106 | PA720480 | 2021-05-04 | False | |||
| 16060000002980 | L16/dossiers | 16 | 16060000002872 | 16060000002872 | 107 | PA607595 | 2021-05-04 | False | |||
| 16060000002981 | L16/dossiers | 16 | 16060000002872 | 16060000002872 | 108 | PA718802 | 2021-05-04 | False | |||
| 16060000002982 | L16/dossiers | 16 | 16060000002872 | 16060000002872 | 109 | PA718930 | 2021-05-04 | False | |||
| 16060000002983 | L16/dossiers | 16 | 16060000002872 | 16060000002872 | 110 | PA718736 | 2021-05-04 | False | |||
| 16060000002984 | L16/dossiers | 16 | 16060000002872 | 16060000002872 | 111 | PA720552 | 2021-05-04 | False | |||
| 16060000002985 | L16/dossiers | 16 | 16060000002872 | 16060000002872 | 112 | PA722398 | 2021-05-04 | False | |||
| 16060000002986 | L16/dossiers | 16 | 16060000002872 | 16060000002872 | 113 | PA721426 | 2021-05-04 | False | |||
| 16060000002987 | L16/dossiers | 16 | 16060000002872 | 16060000002872 | 114 | PA720066 | 2021-05-04 | False | |||
| 16060000002988 | L16/dossiers | 16 | 16060000002872 | 16060000002872 | 115 | PA718810 | 2021-05-04 | False | |||
| 16060000002989 | L16/dossiers | 16 | 16060000002872 | 16060000002872 | 116 | PA722022 | 2021-05-04 | False | |||
| 16060000002990 | L16/dossiers | 16 | 16060000002872 | 16060000002872 | 117 | PA721538 | 2021-05-04 | False | |||
| 16060000002991 | L16/dossiers | 16 | 16060000002872 | 16060000002872 | 118 | PA719972 | 2021-05-04 | False | |||
| 16060000002992 | L16/dossiers | 16 | 16060000002872 | 16060000002872 | 119 | PA722118 | 2021-05-04 | False | |||
| 16060000002993 | L16/dossiers | 16 | 16060000002872 | 16060000002872 | 120 | PA719350 | 2021-05-04 | False | |||
| 16060000002994 | L16/dossiers | 16 | 16060000002872 | 16060000002872 | 121 | PA719550 | 2021-05-04 | False | |||
| 16060000002995 | L16/dossiers | 16 | 16060000002872 | 16060000002872 | 122 | PA720246 | 2021-05-04 | False | |||
| 16060000002996 | L16/dossiers | 16 | 16060000002872 | 16060000002872 | 123 | PA720568 | 2021-05-04 | False | |||
| 16060000002997 | L16/dossiers | 16 | 16060000002872 | 16060000002872 | 124 | PA719302 | 2021-05-04 | False | |||
| 16060000002998 | L16/dossiers | 16 | 16060000002872 | 16060000002872 | 125 | PA720014 | 2021-05-04 | False | |||
| 16060000002999 | L16/dossiers | 16 | 16060000002872 | 16060000002872 | 126 | PA720394 | 2021-05-04 | False | |||
| 16060000003000 | L16/dossiers | 16 | 16060000002872 | 16060000002872 | 127 | PA718682 | 2021-05-04 | False | |||
| 16060000003001 | L16/dossiers | 16 | 16060000002872 | 16060000002872 | 128 | PA719092 | 2021-05-04 | False | |||
| 16060000003002 | L16/dossiers | 16 | 16060000002872 | 16060000002872 | 129 | PA722162 | 2021-05-04 | False | |||
| 16060000003003 | L16/dossiers | 16 | 16060000002872 | 16060000002872 | 130 | PA722240 | 2021-05-04 | False | |||
| 16060000003004 | L16/dossiers | 16 | 16060000002872 | 16060000002872 | 131 | PA721542 | 2021-05-04 | False | |||
| 16060000003005 | L16/dossiers | 16 | 16060000002872 | 16060000002872 | 132 | PA722102 | 2021-05-04 | False | |||
| 16060000003006 | L16/dossiers | 16 | 16060000002872 | 16060000002872 | 133 | PA606639 | 2021-05-04 | False | |||
| 16060000003007 | L16/dossiers | 16 | 16060000002872 | 16060000002872 | 134 | PA719512 | 2021-05-04 | False | |||
| 16060000003008 | L16/dossiers | 16 | 16060000002872 | 16060000002872 | 135 | PA720318 | 2021-05-04 | False | |||
| 16060000003009 | L16/dossiers | 16 | 16060000002872 | 16060000002872 | 136 | PA718962 | 2021-05-04 | False | |||
| 16060000003010 | L16/dossiers | 16 | 16060000002872 | 16060000002872 | 137 | PA720092 | 2021-05-17 | False | |||
| 16060000003011 | L16/dossiers | 16 | 16060000002872 | 16060000002872 | 138 | PA719540 | 2021-06-17 | False | |||
| 16060000003027 | L16/dossiers | 16 | 16060000003025 | 16060000003025 | 1 | PA642935 | 2021-10-12 | False | |||
| 16060000003028 | L16/dossiers | 16 | 16060000003025 | 16060000003025 | 2 | PA719448 | 2021-10-12 | False |