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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 16060000004262 | L16/dossiers | 16 | 16060000004122 | 16060000004122 | 139 | PA718860 | 2022-07-08 | False | |||
| 16060000004263 | L16/dossiers | 16 | 16060000004122 | 16060000004122 | 140 | PA794106 | 2022-07-08 | False | |||
| 16060000004264 | L16/dossiers | 16 | 16060000004122 | 16060000004122 | 141 | PA794166 | 2022-07-08 | False | |||
| 16060000004265 | L16/dossiers | 16 | 16060000004122 | 16060000004122 | 142 | PA794650 | 2022-07-08 | False | |||
| 16060000004266 | L16/dossiers | 16 | 16060000004122 | 16060000004122 | 143 | PA793948 | 2022-07-08 | False | |||
| 16060000004267 | L16/dossiers | 16 | 16060000004122 | 16060000004122 | 144 | PA793816 | 2022-07-08 | False | |||
| 16060000004268 | L16/dossiers | 16 | 16060000004122 | 16060000004122 | 145 | PA795164 | 2022-07-08 | False | |||
| 16060000004269 | L16/dossiers | 16 | 16060000004122 | 16060000004122 | 146 | PA608695 | 2022-07-08 | False | |||
| 16060000004270 | L16/dossiers | 16 | 16060000004122 | 16060000004122 | 147 | PA795596 | 2022-07-08 | False | |||
| 16060000004271 | L16/dossiers | 16 | 16060000004122 | 16060000004122 | 148 | PA794494 | 2022-07-08 | False | |||
| 16060000004272 | L16/dossiers | 16 | 16060000004122 | 16060000004122 | 149 | PA793110 | 2022-07-08 | False | |||
| 16060000004273 | L16/dossiers | 16 | 16060000004122 | 16060000004122 | 150 | PA720992 | 2022-07-08 | False | |||
| 16060000004274 | L16/dossiers | 16 | 16060000004122 | 16060000004122 | 151 | PA722110 | 2022-07-08 | False | |||
| 16060000004449 | L16/dossiers | 16 | 16060000004447 | 16060000004447 | 1 | PA720696 | 2022-07-25 | False | |||
| 16060000004450 | L16/dossiers | 16 | 16060000004447 | 16060000004447 | 2 | PA267766 | 2022-07-25 | False | |||
| 16060000004451 | L16/dossiers | 16 | 16060000004447 | 16060000004447 | 3 | PA333421 | 2022-07-25 | False | |||
| 16060000004452 | L16/dossiers | 16 | 16060000004447 | 16060000004447 | 4 | PA720976 | 2022-07-25 | False | |||
| 16060000004453 | L16/dossiers | 16 | 16060000004447 | 16060000004447 | 5 | PA607619 | 2022-07-25 | False | |||
| 16060000004454 | L16/dossiers | 16 | 16060000004447 | 16060000004447 | 6 | PA2952 | 2022-07-25 | False | |||
| 16060000004455 | L16/dossiers | 16 | 16060000004447 | 16060000004447 | 7 | PA796078 | 2022-07-25 | False | |||
| 16060000004456 | L16/dossiers | 16 | 16060000004447 | 16060000004447 | 8 | PA795244 | 2022-07-25 | False | |||
| 16060000004457 | L16/dossiers | 16 | 16060000004447 | 16060000004447 | 9 | PA719286 | 2022-07-26 | False | |||
| 16060000004623 | L16/dossiers | 16 | 16060000004621 | 16060000004621 | 1 | PA794650 | 2022-07-25 | False | |||
| 16060000004624 | L16/dossiers | 16 | 16060000004621 | 16060000004621 | 2 | PA720838 | 2022-07-25 | False | |||
| 16060000004625 | L16/dossiers | 16 | 16060000004621 | 16060000004621 | 3 | PA721118 | 2022-07-25 | False | |||
| 16060000004626 | L16/dossiers | 16 | 16060000004621 | 16060000004621 | 4 | PA795192 | 2022-07-25 | False | |||
| 16060000004627 | L16/dossiers | 16 | 16060000004621 | 16060000004621 | 5 | PA267306 | 2022-07-25 | False | |||
| 16060000004628 | L16/dossiers | 16 | 16060000004621 | 16060000004621 | 6 | PA718926 | 2022-07-25 | False | |||
| 16060000004629 | L16/dossiers | 16 | 16060000004621 | 16060000004621 | 7 | PA722202 | 2022-07-25 | False | |||
| 16060000004630 | L16/dossiers | 16 | 16060000004621 | 16060000004621 | 8 | PA795998 | 2022-07-25 | False | |||
| 16060000004631 | L16/dossiers | 16 | 16060000004621 | 16060000004621 | 9 | PA774962 | 2022-07-25 | False | |||
| 16060000004632 | L16/dossiers | 16 | 16060000004621 | 16060000004621 | 10 | PA335612 | 2022-07-25 | False | |||
| 16060000004633 | L16/dossiers | 16 | 16060000004621 | 16060000004621 | 11 | PA795184 | 2022-07-25 | False | |||
| 16060000004634 | L16/dossiers | 16 | 16060000004621 | 16060000004621 | 12 | PA796010 | 2022-07-25 | False | |||
| 16060000004635 | L16/dossiers | 16 | 16060000004621 | 16060000004621 | 13 | PA793174 | 2022-07-25 | False | |||
| 16060000004636 | L16/dossiers | 16 | 16060000004621 | 16060000004621 | 14 | PA795820 | 2022-07-25 | False | |||
| 16060000004637 | L16/dossiers | 16 | 16060000004621 | 16060000004621 | 15 | PA795876 | 2022-07-25 | False | |||
| 16060000004638 | L16/dossiers | 16 | 16060000004621 | 16060000004621 | 16 | PA721270 | 2022-07-25 | False | |||
| 16060000004639 | L16/dossiers | 16 | 16060000004621 | 16060000004621 | 17 | PA605745 | 2022-07-25 | False | |||
| 16060000004640 | L16/dossiers | 16 | 16060000004621 | 16060000004621 | 18 | PA720992 | 2022-07-25 | False | |||
| 16060000004641 | L16/dossiers | 16 | 16060000004621 | 16060000004621 | 19 | PA722110 | 2022-07-25 | False | |||
| 16060000004642 | L16/dossiers | 16 | 16060000004621 | 16060000004621 | 20 | PA643143 | 2022-07-25 | False | |||
| 16060000004643 | L16/dossiers | 16 | 16060000004621 | 16060000004621 | 21 | PA794094 | 2022-07-25 | False | |||
| 16060000004644 | L16/dossiers | 16 | 16060000004621 | 16060000004621 | 22 | PA793624 | 2022-07-25 | False | |||
| 16060000004645 | L16/dossiers | 16 | 16060000004621 | 16060000004621 | 23 | PA795762 | 2022-07-25 | False | |||
| 16060000004646 | L16/dossiers | 16 | 16060000004621 | 16060000004621 | 24 | PA1008 | 2022-07-25 | False | |||
| 16060000004647 | L16/dossiers | 16 | 16060000004621 | 16060000004621 | 25 | PA793394 | 2022-07-25 | False | |||
| 16060000004648 | L16/dossiers | 16 | 16060000004621 | 16060000004621 | 26 | PA795430 | 2022-07-25 | False | |||
| 16060000004649 | L16/dossiers | 16 | 16060000004621 | 16060000004621 | 27 | PA794854 | 2022-07-25 | False | |||
| 16060000004650 | L16/dossiers | 16 | 16060000004621 | 16060000004621 | 28 | PA1567 | 2022-07-25 | False |