dossiers.document_co_signataire
Chemin document.coSignataires.coSignataire · présence : L17 26 %, L16 26 %, L15 28 %, L14 29 %
309 756 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 16060000011877 | L16/dossiers | 16 | 16060000011872 | 16060000011872 | 4 | PA722390 | 2022-11-15 | False | |||
| 16060000011878 | L16/dossiers | 16 | 16060000011872 | 16060000011872 | 5 | PA330909 | 2022-11-15 | False | |||
| 16060000011879 | L16/dossiers | 16 | 16060000011872 | 16060000011872 | 6 | PA793476 | 2022-11-15 | False | |||
| 16060000011880 | L16/dossiers | 16 | 16060000011872 | 16060000011872 | 7 | PA608826 | 2022-11-15 | False | |||
| 16060000011881 | L16/dossiers | 16 | 16060000011872 | 16060000011872 | 8 | PA783457 | 2022-11-15 | False | |||
| 16060000011882 | L16/dossiers | 16 | 16060000011872 | 16060000011872 | 9 | PA346782 | 2022-11-15 | False | |||
| 16060000011883 | L16/dossiers | 16 | 16060000011872 | 16060000011872 | 10 | PA721442 | 2022-11-15 | False | |||
| 16060000011884 | L16/dossiers | 16 | 16060000011872 | 16060000011872 | 11 | PA722308 | 2022-11-15 | False | |||
| 16060000011885 | L16/dossiers | 16 | 16060000011872 | 16060000011872 | 12 | PA643134 | 2022-11-15 | False | |||
| 16060000011886 | L16/dossiers | 16 | 16060000011872 | 16060000011872 | 13 | PA721474 | 2022-11-22 | False | |||
| 16060000011887 | L16/dossiers | 16 | 16060000011872 | 16060000011872 | 14 | PA342240 | 2022-11-23 | False | |||
| 16060000011891 | L16/dossiers | 16 | 16060000011889 | 16060000011889 | 1 | PA721410 | 2022-11-15 | False | |||
| 16060000011892 | L16/dossiers | 16 | 16060000011889 | 16060000011889 | 2 | PA266793 | 2022-11-15 | False | |||
| 16060000011893 | L16/dossiers | 16 | 16060000011889 | 16060000011889 | 3 | PA718850 | 2022-11-15 | False | |||
| 16060000011894 | L16/dossiers | 16 | 16060000011889 | 16060000011889 | 4 | PA722390 | 2022-11-15 | False | |||
| 16060000011895 | L16/dossiers | 16 | 16060000011889 | 16060000011889 | 5 | PA712015 | 2022-11-15 | False | |||
| 16060000011896 | L16/dossiers | 16 | 16060000011889 | 16060000011889 | 6 | PA793476 | 2022-11-15 | False | |||
| 16060000011897 | L16/dossiers | 16 | 16060000011889 | 16060000011889 | 7 | PA794058 | 2022-11-15 | False | |||
| 16060000011898 | L16/dossiers | 16 | 16060000011889 | 16060000011889 | 8 | PA783457 | 2022-11-15 | False | |||
| 16060000011899 | L16/dossiers | 16 | 16060000011889 | 16060000011889 | 9 | PA695100 | 2022-11-15 | False | |||
| 16060000011900 | L16/dossiers | 16 | 16060000011889 | 16060000011889 | 10 | PA608416 | 2022-11-15 | False | |||
| 16060000011901 | L16/dossiers | 16 | 16060000011889 | 16060000011889 | 11 | PA608016 | 2022-11-15 | False | |||
| 16060000011902 | L16/dossiers | 16 | 16060000011889 | 16060000011889 | 12 | PA793342 | 2022-11-15 | False | |||
| 16060000011903 | L16/dossiers | 16 | 16060000011889 | 16060000011889 | 13 | PA720630 | 2022-11-15 | False | |||
| 16060000011904 | L16/dossiers | 16 | 16060000011889 | 16060000011889 | 14 | PA794038 | 2022-11-15 | False | |||
| 16060000011905 | L16/dossiers | 16 | 16060000011889 | 16060000011889 | 15 | PA718784 | 2022-11-15 | False | |||
| 16060000011906 | L16/dossiers | 16 | 16060000011889 | 16060000011889 | 16 | PA794994 | 2022-11-15 | False | |||
| 16060000011907 | L16/dossiers | 16 | 16060000011889 | 16060000011889 | 17 | PA793094 | 2022-11-15 | False | |||
| 16060000011908 | L16/dossiers | 16 | 16060000011889 | 16060000011889 | 18 | PA722308 | 2022-11-15 | False | |||
| 16060000011909 | L16/dossiers | 16 | 16060000011889 | 16060000011889 | 19 | PA643134 | 2022-11-15 | False | |||
| 16060000011910 | L16/dossiers | 16 | 16060000011889 | 16060000011889 | 20 | PA1630 | 2022-11-15 | False | |||
| 16060000011911 | L16/dossiers | 16 | 16060000011889 | 16060000011889 | 21 | PA721474 | 2022-11-24 | False | |||
| 16060000011912 | L16/dossiers | 16 | 16060000011889 | 16060000011889 | 22 | PA346782 | 2022-11-24 | False | |||
| 16060000011913 | L16/dossiers | 16 | 16060000011889 | 16060000011889 | 23 | PA795406 | 2022-11-24 | False | |||
| 16060000011914 | L16/dossiers | 16 | 16060000011889 | 16060000011889 | 24 | PA342240 | 2022-11-24 | False | |||
| 16060000011918 | L16/dossiers | 16 | 16060000011916 | 16060000011916 | 1 | PA721410 | 2022-11-15 | True | |||
| 16060000011919 | L16/dossiers | 16 | 16060000011916 | 16060000011916 | 2 | PA721816 | 2022-11-15 | True | |||
| 16060000011920 | L16/dossiers | 16 | 16060000011916 | 16060000011916 | 3 | PA330008 | 2022-11-15 | False | |||
| 16060000011921 | L16/dossiers | 16 | 16060000011916 | 16060000011916 | 4 | PA267429 | 2022-11-15 | False | |||
| 16060000011922 | L16/dossiers | 16 | 16060000011916 | 16060000011916 | 5 | PA722390 | 2022-11-15 | False | |||
| 16060000011923 | L16/dossiers | 16 | 16060000011916 | 16060000011916 | 6 | PA793476 | 2022-11-15 | False | |||
| 16060000011924 | L16/dossiers | 16 | 16060000011916 | 16060000011916 | 7 | PA608826 | 2022-11-15 | False | |||
| 16060000011925 | L16/dossiers | 16 | 16060000011916 | 16060000011916 | 8 | PA1327 | 2022-11-15 | False | |||
| 16060000011926 | L16/dossiers | 16 | 16060000011916 | 16060000011916 | 9 | PA605991 | 2022-11-15 | False | |||
| 16060000011927 | L16/dossiers | 16 | 16060000011916 | 16060000011916 | 10 | PA266797 | 2022-11-15 | False | |||
| 16060000011928 | L16/dossiers | 16 | 16060000011916 | 16060000011916 | 11 | PA794058 | 2022-11-15 | False | |||
| 16060000011929 | L16/dossiers | 16 | 16060000011916 | 16060000011916 | 12 | PA1630 | 2022-11-15 | False | |||
| 16060000011930 | L16/dossiers | 16 | 16060000011916 | 16060000011916 | 13 | PA346782 | 2022-11-15 | False | |||
| 16060000011931 | L16/dossiers | 16 | 16060000011916 | 16060000011916 | 14 | PA608016 | 2022-11-15 | False | |||
| 16060000011932 | L16/dossiers | 16 | 16060000011916 | 16060000011916 | 15 | PA346054 | 2022-11-15 | False |