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
17060000032085L17/dossiers17170600000320171706000003201767PA7941062025-03-28False
17060000032086L17/dossiers17170600000320171706000003201768PA7941662025-03-28False
17060000032087L17/dossiers17170600000320171706000003201769PA7951642025-03-28False
17060000032088L17/dossiers17170600000320171706000003201770PA7955962025-03-28False
17060000032095L17/dossiers1717060000032093170600000320931PA7208922025-04-01False
17060000032096L17/dossiers1717060000032093170600000320932PA7952282025-04-01False
17060000032097L17/dossiers1717060000032093170600000320933PA7932622025-04-01False
17060000032098L17/dossiers1717060000032093170600000320934PA7949062025-04-01False
17060000032099L17/dossiers1717060000032093170600000320935PA7941382025-04-01False
17060000032100L17/dossiers1717060000032093170600000320936PA7955882025-04-01False
17060000032101L17/dossiers1717060000032093170600000320937PA7950842025-04-01False
17060000032102L17/dossiers1717060000032093170600000320938PA8421052025-04-01False
17060000032103L17/dossiers1717060000032093170600000320939PA8416572025-04-01False
17060000032104L17/dossiers17170600000320931706000003209310PA7204302025-04-01False
17060000032105L17/dossiers17170600000320931706000003209311PA7956162025-04-01False
17060000032106L17/dossiers17170600000320931706000003209312PA7934442025-04-01False
17060000032107L17/dossiers17170600000320931706000003209313PA7949382025-04-01False
17060000032108L17/dossiers17170600000320931706000003209314PA7953182025-04-01False
17060000032109L17/dossiers17170600000320931706000003209315PA8410232025-04-01False
17060000032110L17/dossiers17170600000320931706000003209316PA7960902025-04-01False
17060000032111L17/dossiers17170600000320931706000003209317PA7939122025-04-01False
17060000032112L17/dossiers17170600000320931706000003209318PA8421872025-04-01False
17060000032113L17/dossiers17170600000320931706000003209319PA8420372025-04-01False
17060000032114L17/dossiers17170600000320931706000003209320PA7918122025-04-01False
17060000032115L17/dossiers17170600000320931706000003209321PA7937362025-04-01False
17060000032116L17/dossiers17170600000320931706000003209322PA7212022025-04-01False
17060000032117L17/dossiers17170600000320931706000003209323PA7951362025-04-01False
17060000032118L17/dossiers17170600000320931706000003209324PA7934642025-04-01False
17060000032119L17/dossiers17170600000320931706000003209325PA8421552025-04-01False
17060000032120L17/dossiers17170600000320931706000003209326PA7952002025-04-01False
17060000032121L17/dossiers17170600000320931706000003209327PA7958442025-04-01False
17060000032122L17/dossiers17170600000320931706000003209328PA8412512025-04-01False
17060000032123L17/dossiers17170600000320931706000003209329PA7947862025-04-01False
17060000032124L17/dossiers17170600000320931706000003209330PA7948702025-04-01False
17060000032125L17/dossiers17170600000320931706000003209331PA7960702025-04-01False
17060000032126L17/dossiers17170600000320931706000003209332PA7953102025-04-01False
17060000032127L17/dossiers17170600000320931706000003209333PA7944782025-04-01False
17060000032128L17/dossiers17170600000320931706000003209334PA8419472025-04-01False
17060000032129L17/dossiers17170600000320931706000003209335PA7940822025-04-01False
17060000032130L17/dossiers17170600000320931706000003209336PA7941302025-04-01False
17060000032131L17/dossiers17170600000320931706000003209337PA7208462025-04-01False
17060000032132L17/dossiers17170600000320931706000003209338PA8417292025-04-01False
17060000032133L17/dossiers17170600000320931706000003209339PA7955162025-04-01False
17060000032134L17/dossiers17170600000320931706000003209340PA7956722025-04-01False
17060000032135L17/dossiers17170600000320931706000003209341PA7957462025-04-01False
17060000032136L17/dossiers17170600000320931706000003209342PA7951082025-04-01False
17060000032137L17/dossiers17170600000320931706000003209343PA8415152025-04-01False
17060000032138L17/dossiers17170600000320931706000003209344PA7952982025-04-01False
17060000032139L17/dossiers17170600000320931706000003209345PA7918242025-04-01False
17060000032140L17/dossiers17170600000320931706000003209346PA8420292025-04-01False