AN · données ouvertes
Explorateur / dossiers

dossiers.document_co_signataire

Chemin document.coSignataires.coSignataire · présence : L17 26 %, L16 26 %, L15 28 %, L14 29 %

305 264 lignes (estimation)

Colonnes

#ColonneTypeCommentaire
1_idBIGINTidentifiant : code de la source × 10¹⁰ + rang
2_sourceVARCHARsource du catalogue (catalogue.py)
3_legislatureBIGINTcolonne constante de la source
4_racine_idBIGINT_id de la ligne racine
5_parent_idBIGINT_id de la ligne parente
6_ordreBIGINTrang dans le tableau d'origine (1…)
7acteur_acteur_refVARCHARdocument.coSignataires.coSignataire.acteur.acteurRef · présence : L17 25 %, L16 26 %, L15 28 %, L14 29 %
8date_cosignatureDATEdocument.coSignataires.coSignataire.dateCosignature · présence : L17 26 %, L16 26 %, L15 28 %, L14 29 %
9date_retrait_cosignatureDATEdocument.coSignataires.coSignataire.dateRetraitCosignature · présence : L17 26 %, L16 26 %, L15 28 %, L14 29 %
10editeBOOLEANdocument.coSignataires.coSignataire.edite · présence : L17 26 %, L16 26 %, L15 28 %, L14 29 %
11organe_organe_refVARCHARdocument.coSignataires.coSignataire.organe.organeRef · présence : L17 0 %, L16 1 %, L15 1 %, L14 2 %
12organe_et_apparentesBOOLEANdocument.coSignataires.coSignataire.organe.etApparentes · présence : L17 0 %, L16 1 %, L15 1 %, L14 2 %

Aperçu

_id_source_legislature_racine_id_parent_id_ordreacteur_acteur_refdate_cosignaturedate_retrait_cosignatureediteorgane_organe_reforgane_et_apparentes
17060000025947L17/dossiers17170600000258821706000002588264PA7951762025-03-31False
17060000025948L17/dossiers17170600000258821706000002588265PA7956642025-03-31False
17060000025949L17/dossiers17170600000258821706000002588266PA8172032025-03-31False
17060000025950L17/dossiers17170600000258821706000002588267PA7959622025-03-31False
17060000025951L17/dossiers17170600000258821706000002588268PA7957222025-03-31False
17060000025952L17/dossiers17170600000258821706000002588269PA7196322025-03-31False
17060000025953L17/dossiers17170600000258821706000002588270PA7219162025-03-31False
17060000025954L17/dossiers17170600000258821706000002588271PA3357582025-03-31False
17060000025955L17/dossiers17170600000258821706000002588272PA7214262025-03-31False
17060000025956L17/dossiers17170600000258821706000002588273PA7200662025-03-31False
17060000025957L17/dossiers17170600000258821706000002588274PA7222522025-03-31False
17060000025958L17/dossiers17170600000258821706000002588275PA7955282025-03-31False
17060000025959L17/dossiers17170600000258821706000002588276PA8419272025-03-31False
17060000025960L17/dossiers17170600000258821706000002588277PA7958882025-03-31False
17060000025961L17/dossiers17170600000258821706000002588278PA7932702025-03-31False
17060000025962L17/dossiers17170600000258821706000002588279PA7572252025-03-31False
17060000025963L17/dossiers17170600000258821706000002588280PA7934162025-03-31False
17060000025964L17/dossiers17170600000258821706000002588281PA7948022025-03-31False
17060000025965L17/dossiers17170600000258821706000002588282PA7201902025-03-31False
17060000025966L17/dossiers17170600000258821706000002588283PA7944862025-03-31False
17060000025967L17/dossiers17170600000258821706000002588284PA7195502025-03-31False
17060000025968L17/dossiers17170600000258821706000002588285PA7215842025-03-31False
17060000025969L17/dossiers17170600000258821706000002588286PA7959202025-03-31False
17060000025970L17/dossiers17170600000258821706000002588287PA6073952025-03-31False
17060000025971L17/dossiers17170600000258821706000002588288PA7221022025-03-31False
17060000025972L17/dossiers17170600000258821706000002588289PA7195122025-03-31False
17060000025973L17/dossiers17170600000258821706000002588290PA7211702025-03-31False
17060000025974L17/dossiers17170600000258821706000002588291PA29602025-03-31False
17060000025975L17/dossiers17170600000258821706000002588292PA7950462025-03-31False
17060000025979L17/dossiers1717060000025977170600000259771PA6428682025-02-04False
17060000025980L17/dossiers1717060000025977170600000259772PA7939922025-02-04False
17060000025981L17/dossiers1717060000025977170600000259773PA7952782025-02-04False
17060000025982L17/dossiers1717060000025977170600000259774PA3322282025-02-04False
17060000025983L17/dossiers1717060000025977170600000259775PA6872142025-02-04False
17060000025984L17/dossiers1717060000025977170600000259776PA7190322025-02-04False
17060000025985L17/dossiers1717060000025977170600000259777PA8413392025-02-04False
17060000025986L17/dossiers1717060000025977170600000259778PA8414312025-02-04False
17060000025987L17/dossiers1717060000025977170600000259779PA2677802025-02-04False
17060000025988L17/dossiers17170600000259771706000002597710PA7944702025-02-04False
17060000025989L17/dossiers17170600000259771706000002597711PA7942342025-02-04False
17060000025990L17/dossiers17170600000259771706000002597712PA7220702025-02-04False
17060000025991L17/dossiers17170600000259771706000002597713PA7197782025-02-04False
17060000025992L17/dossiers17170600000259771706000002597714PA7190522025-02-04False
17060000025993L17/dossiers17170600000259771706000002597715PA7192822025-02-04False
17060000025994L17/dossiers17170600000259771706000002597716PA8421252025-02-04False
17060000025995L17/dossiers17170600000259771706000002597717PA7944262025-02-04False
17060000025996L17/dossiers17170600000259771706000002597718PA7948382025-02-04False
17060000025997L17/dossiers17170600000259771706000002597719PA7202302025-02-04False
17060000025998L17/dossiers17170600000259771706000002597720PA7944662025-02-04False
17060000025999L17/dossiers17170600000259771706000002597721PA7209082025-02-04False