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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 17060000019681 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 16 | PA841801 | 2025-03-04 | False | |||
| 17060000019682 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 17 | PA794554 | 2025-03-04 | False | |||
| 17060000019683 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 18 | PA840903 | 2025-03-04 | False | |||
| 17060000019684 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 19 | PA841431 | 2025-03-04 | False | |||
| 17060000019685 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 20 | PA722390 | 2025-03-04 | False | |||
| 17060000019686 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 21 | PA793520 | 2025-03-04 | False | |||
| 17060000019687 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 22 | PA840713 | 2025-03-04 | False | |||
| 17060000019688 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 23 | PA794982 | 2025-03-04 | False | |||
| 17060000019689 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 24 | PA643175 | 2025-03-04 | False | |||
| 17060000019690 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 25 | PA607193 | 2025-03-04 | False | |||
| 17060000019691 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 26 | PA605694 | 2025-03-04 | False | |||
| 17060000019692 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 27 | PA722134 | 2025-03-04 | False | |||
| 17060000019693 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 28 | PA794234 | 2025-03-04 | False | |||
| 17060000019694 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 29 | PA267318 | 2025-03-04 | False | |||
| 17060000019695 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 30 | PA841833 | 2025-03-04 | False | |||
| 17060000019696 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 31 | PA841853 | 2025-03-04 | False | |||
| 17060000019697 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 32 | PA841017 | 2025-03-04 | False | |||
| 17060000019698 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 33 | PA720354 | 2025-03-04 | False | |||
| 17060000019699 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 34 | PA719052 | 2025-03-04 | False | |||
| 17060000019700 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 35 | PA643184 | 2025-03-04 | False | |||
| 17060000019701 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 36 | PA719404 | 2025-03-04 | False | |||
| 17060000019702 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 37 | PA345722 | 2025-03-04 | False | |||
| 17060000019703 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 38 | PA719756 | 2025-03-04 | False | |||
| 17060000019704 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 39 | PA720342 | 2025-03-04 | False | |||
| 17060000019705 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 40 | PA841601 | 2025-03-04 | False | |||
| 17060000019706 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 41 | PA794702 | 2025-03-04 | False | |||
| 17060000019707 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 42 | PA794206 | 2025-03-04 | False | |||
| 17060000019708 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 43 | PA795100 | 2025-03-04 | False | |||
| 17060000019709 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 44 | PA720146 | 2025-03-04 | False | |||
| 17060000019710 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 45 | PA841013 | 2025-03-04 | False | |||
| 17060000019711 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 46 | PA795962 | 2025-03-04 | False | |||
| 17060000019712 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 47 | PA794466 | 2025-03-04 | False | |||
| 17060000019713 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 48 | PA721486 | 2025-03-04 | False | |||
| 17060000019714 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 49 | PA795722 | 2025-03-04 | False | |||
| 17060000019715 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 50 | PA795124 | 2025-03-04 | False | |||
| 17060000019716 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 51 | PA841381 | 2025-03-04 | False | |||
| 17060000019717 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 52 | PA721234 | 2025-03-04 | False | |||
| 17060000019718 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 53 | PA721844 | 2025-03-04 | False | |||
| 17060000019719 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 54 | PA607553 | 2025-03-04 | False | |||
| 17060000019720 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 55 | PA721916 | 2025-03-04 | False | |||
| 17060000019721 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 56 | PA840955 | 2025-03-04 | False | |||
| 17060000019722 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 57 | PA720552 | 2025-03-04 | False | |||
| 17060000019723 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 58 | PA795240 | 2025-03-04 | False | |||
| 17060000019724 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 59 | PA720066 | 2025-03-04 | False | |||
| 17060000019725 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 60 | PA722252 | 2025-03-04 | False | |||
| 17060000019726 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 61 | PA795528 | 2025-03-04 | False | |||
| 17060000019727 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 62 | PA721458 | 2025-03-04 | False | |||
| 17060000019728 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 63 | PA342196 | 2025-03-04 | False | |||
| 17060000019729 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 64 | PA826635 | 2025-03-04 | False | |||
| 17060000019730 | L17/dossiers | 17 | 17060000019664 | 17060000019664 | 65 | PA841717 | 2025-03-04 | False |