dossiers.document_co_signataire
Chemin document.coSignataires.coSignataire · présence : L17 26 %, L16 26 %, L15 28 %, L14 29 %
309 130 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 17060000077713 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 37 | PA429875 | 2015-11-25 | False | |||
| 17060000077714 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 38 | PA703515 | 2015-11-25 | False | |||
| 17060000077715 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 39 | PA415476 | 2015-11-25 | False | |||
| 17060000077716 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 40 | PA1744 | 2015-11-25 | False | |||
| 17060000077717 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 41 | PA205280 | 2015-11-25 | False | |||
| 17060000077718 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 42 | PA303992 | 2015-11-25 | False | |||
| 17060000077719 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 43 | PA703488 | 2015-11-25 | False | |||
| 17060000077720 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 44 | PA703501 | 2015-11-25 | False | |||
| 17060000077721 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 45 | PA304000 | 2015-11-25 | False | |||
| 17060000077722 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 46 | PA415451 | 2015-11-25 | False | |||
| 17060000077723 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 47 | PA415447 | 2015-11-25 | False | |||
| 17060000077724 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 48 | PA415467 | 2015-11-25 | False | |||
| 17060000077725 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 49 | PA1942 | 2015-11-25 | False | |||
| 17060000077726 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 50 | PA210741 | 2015-11-25 | False | |||
| 17060000077727 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 51 | PA227089 | 2015-11-25 | False | |||
| 17060000077728 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 52 | PA703523 | 2015-11-25 | False | |||
| 17060000077729 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 53 | PA341381 | 2015-11-25 | False | |||
| 17060000077730 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 54 | PA703537 | 2015-11-25 | False | |||
| 17060000077731 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 55 | PA703516 | 2015-11-25 | False | |||
| 17060000077732 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 56 | PA415455 | 2015-11-25 | False | |||
| 17060000077733 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 57 | PA703497 | 2015-11-25 | False | |||
| 17060000077734 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 58 | PA429832 | 2015-11-25 | False | |||
| 17060000077735 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 59 | PA707346 | 2015-11-25 | False | |||
| 17060000077736 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 60 | PA2116 | 2015-11-25 | False | |||
| 17060000077737 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 61 | PA415446 | 2015-11-25 | False | |||
| 17060000077738 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 62 | PA703480 | 2015-11-25 | False | |||
| 17060000077739 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 63 | PA415448 | 2015-11-25 | False | |||
| 17060000077740 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 64 | PA304017 | 2015-11-25 | False | |||
| 17060000077741 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 65 | PA2237 | 2015-11-25 | False | |||
| 17060000077742 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 66 | PA703518 | 2015-11-25 | False | |||
| 17060000077743 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 67 | PA429849 | 2015-11-25 | False | |||
| 17060000077744 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 68 | PA415474 | 2015-11-25 | False | |||
| 17060000077745 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 69 | PA703521 | 2015-11-25 | False | |||
| 17060000077746 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 70 | PA267328 | 2015-11-25 | False | |||
| 17060000077747 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 71 | PA304076 | 2015-11-25 | False | |||
| 17060000077748 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 72 | PA406065 | 2015-11-25 | False | |||
| 17060000077749 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 73 | PA2420 | 2015-11-25 | False | |||
| 17060000077750 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 74 | PA304015 | 2015-11-25 | False | |||
| 17060000077751 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 75 | PA1452 | 2015-11-25 | False | |||
| 17060000077752 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 76 | PA2505 | 2015-11-25 | False | |||
| 17060000077753 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 77 | PA267018 | 2015-11-25 | False | |||
| 17060000077754 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 78 | PA2543 | 2015-11-25 | False | |||
| 17060000077755 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 79 | PA429896 | 2015-11-25 | False | |||
| 17060000077756 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 80 | PA429851 | 2015-11-25 | False | |||
| 17060000077757 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 81 | PA227094 | 2015-11-25 | False | |||
| 17060000077758 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 82 | PA303996 | 2015-11-25 | False | |||
| 17060000077759 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 83 | PA703482 | 2015-11-25 | False | |||
| 17060000077760 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 84 | PA2879 | 2015-11-25 | False | |||
| 17060000077761 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 85 | PA2905 | 2015-11-25 | False | |||
| 17060000077762 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 86 | PA703527 | 2015-11-25 | False |