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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 17060000077661 | L17/dossiers | 17 | 17060000077659 | 17060000077659 | 1 | PA703519 | 2015-10-01 | False | |||
| 17060000077662 | L17/dossiers | 17 | 17060000077659 | 17060000077659 | 2 | PA703486 | 2015-10-01 | False | |||
| 17060000077663 | L17/dossiers | 17 | 17060000077659 | 17060000077659 | 3 | PA360 | 2015-10-01 | False | |||
| 17060000077664 | L17/dossiers | 17 | 17060000077659 | 17060000077659 | 4 | PA703531 | 2015-10-01 | False | |||
| 17060000077665 | L17/dossiers | 17 | 17060000077659 | 17060000077659 | 5 | PA905 | 2015-10-01 | False | |||
| 17060000077666 | L17/dossiers | 17 | 17060000077659 | 17060000077659 | 6 | PA304071 | 2015-10-01 | False | |||
| 17060000077667 | L17/dossiers | 17 | 17060000077659 | 17060000077659 | 7 | PA429879 | 2015-10-01 | False | |||
| 17060000077668 | L17/dossiers | 17 | 17060000077659 | 17060000077659 | 8 | PA223231 | 2015-10-01 | False | |||
| 17060000077669 | L17/dossiers | 17 | 17060000077659 | 17060000077659 | 9 | PA1573 | 2015-10-01 | False | |||
| 17060000077670 | L17/dossiers | 17 | 17060000077659 | 17060000077659 | 10 | PA1667 | 2015-10-01 | False | |||
| 17060000077671 | L17/dossiers | 17 | 17060000077659 | 17060000077659 | 11 | PA703529 | 2015-10-01 | False | |||
| 17060000077672 | L17/dossiers | 17 | 17060000077659 | 17060000077659 | 12 | PA415464 | 2015-10-01 | False | |||
| 17060000077673 | L17/dossiers | 17 | 17060000077659 | 17060000077659 | 13 | PA429895 | 2015-10-01 | False | |||
| 17060000077674 | L17/dossiers | 17 | 17060000077659 | 17060000077659 | 14 | PA415480 | 2015-10-01 | False | |||
| 17060000077677 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 1 | PA227108 | 2015-11-25 | False | |||
| 17060000077678 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 2 | PA550 | 2015-11-25 | False | |||
| 17060000077679 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 3 | PA2538 | 2015-11-25 | False | |||
| 17060000077680 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 4 | PA227099 | 2015-11-25 | False | |||
| 17060000077681 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 5 | PA703532 | 2015-11-25 | False | |||
| 17060000077682 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 6 | PA703522 | 2015-11-25 | False | |||
| 17060000077683 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 7 | PA703500 | 2015-11-25 | False | |||
| 17060000077684 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 8 | PA569 | 2015-11-25 | False | |||
| 17060000077685 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 9 | PA716 | 2015-11-25 | False | |||
| 17060000077686 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 10 | PA703510 | 2015-11-25 | False | |||
| 17060000077687 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 11 | PA429884 | 2015-11-25 | False | |||
| 17060000077688 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 12 | PA429862 | 2015-11-25 | False | |||
| 17060000077689 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 13 | PA791 | 2015-11-25 | False | |||
| 17060000077690 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 14 | PA703513 | 2015-11-25 | False | |||
| 17060000077691 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 15 | PA342154 | 2015-11-25 | False | |||
| 17060000077692 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 16 | PA922 | 2015-11-25 | False | |||
| 17060000077693 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 17 | PA703483 | 2015-11-25 | False | |||
| 17060000077694 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 18 | PA304079 | 2015-11-25 | False | |||
| 17060000077695 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 19 | PA709298 | 2015-11-25 | False | |||
| 17060000077696 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 20 | PA703539 | 2015-11-25 | False | |||
| 17060000077697 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 21 | PA267112 | 2015-11-25 | False | |||
| 17060000077698 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 22 | PA1122 | 2015-11-25 | False | |||
| 17060000077699 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 23 | PA1142 | 2015-11-25 | False | |||
| 17060000077700 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 24 | PA429834 | 2015-11-25 | False | |||
| 17060000077701 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 25 | PA1203 | 2015-11-25 | False | |||
| 17060000077702 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 26 | PA429877 | 2015-11-25 | False | |||
| 17060000077703 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 27 | PA1344 | 2015-11-25 | False | |||
| 17060000077704 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 28 | PA703487 | 2015-11-25 | False | |||
| 17060000077705 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 29 | PA266795 | 2015-11-25 | False | |||
| 17060000077706 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 30 | PA415473 | 2015-11-25 | False | |||
| 17060000077707 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 31 | PA382672 | 2015-11-25 | False | |||
| 17060000077708 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 32 | PA415486 | 2015-11-25 | False | |||
| 17060000077709 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 33 | PA1562 | 2015-11-25 | False | |||
| 17060000077710 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 34 | PA267081 | 2015-11-25 | False | |||
| 17060000077711 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 35 | PA227078 | 2015-11-25 | False | |||
| 17060000077712 | L17/dossiers | 17 | 17060000077675 | 17060000077675 | 36 | PA429887 | 2015-11-25 | False |