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
17060000053652L17/dossiers17170600000535951706000005359556PA7935202026-02-23False
17060000053653L17/dossiers17170600000535951706000005359557PA7937162026-02-23False
17060000053654L17/dossiers17170600000535951706000005359558PA7199142026-02-23False
17060000053655L17/dossiers17170600000535951706000005359559PA7200382026-02-23False
17060000053656L17/dossiers17170600000535951706000005359560PA7219842026-02-23False
17060000053657L17/dossiers17170600000535951706000005359561PA7212342026-02-23False
17060000053658L17/dossiers17170600000535951706000005359562PA7207202026-02-23False
17060000053659L17/dossiers17170600000535951706000005359563PA7200922026-02-23False
17060000053660L17/dossiers17170600000535951706000005359564PA7171612026-02-23False
17060000053661L17/dossiers17170600000535951706000005359565PA7202562026-02-23False
17060000053662L17/dossiers17170600000535951706000005359566PA7221622026-02-23False
17060000053663L17/dossiers17170600000535951706000005359567PA7952582026-02-23False
17060000053664L17/dossiers17170600000535951706000005359568PA7948302026-02-23False
17060000053665L17/dossiers17170600000535951706000005359569PA7954542026-02-23False
17060000053666L17/dossiers17170600000535951706000005359570PA7958082026-02-23False
17060000053670L17/dossiers1717060000053668170600000536681PA7223902026-03-30False
17060000053671L17/dossiers1717060000053668170600000536682PA7199682026-03-30False
17060000053675L17/dossiers1717060000053673170600000536731PA7188842026-01-08False
17060000053676L17/dossiers1717060000053673170600000536732PA7214102026-01-08False
17060000053677L17/dossiers1717060000053673170600000536733PA7218162026-01-08False
17060000053678L17/dossiers1717060000053673170600000536734PA8423112026-01-08False
17060000053679L17/dossiers1717060000053673170600000536735PA7120152026-01-08False
17060000053680L17/dossiers1717060000053673170600000536736PA7201542026-01-08False
17060000053681L17/dossiers1717060000053673170600000536737PA6088262026-01-08False
17060000053682L17/dossiers1717060000053673170600000536738PA8700092026-01-08False
17060000053683L17/dossiers1717060000053673170600000536739PA6084162026-01-08False
17060000053684L17/dossiers17170600000536731706000005367310PA8421252026-01-08False
17060000053685L17/dossiers17170600000536731706000005367311PA6955122026-01-08False
17060000053686L17/dossiers17170600000536731706000005367312PA8421412026-01-08False
17060000053687L17/dossiers17170600000536731706000005367313PA7933422026-01-08False
17060000053688L17/dossiers17170600000536731706000005367314PA7940382026-01-08False
17060000053689L17/dossiers17170600000536731706000005367315PA7952702026-01-08False
17060000053690L17/dossiers17170600000536731706000005367316PA7930942026-01-08False
17060000053691L17/dossiers17170600000536731706000005367317PA8419272026-01-08False
17060000053692L17/dossiers17170600000536731706000005367318PA7941782026-01-08False
17060000053693L17/dossiers17170600000536731706000005367319PA7937962026-01-08False
17060000053694L17/dossiers17170600000536731706000005367320PA8421212026-01-08False
17060000053695L17/dossiers17170600000536731706000005367321PA6070902026-01-08False
17060000053696L17/dossiers17170600000536731706000005367322PA7950262026-01-08False
17060000053697L17/dossiers17170600000536731706000005367323PA7214742026-01-08False
17060000053701L17/dossiers1717060000053699170600000536991PA8412152025-12-09False
17060000053702L17/dossiers1717060000053699170600000536992PA8411912025-12-09False
17060000053703L17/dossiers1717060000053699170600000536993PA7937562025-12-09False
17060000053704L17/dossiers1717060000053699170600000536994PA7208922025-12-09False
17060000053705L17/dossiers1717060000053699170600000536995PA7952282025-12-09False
17060000053706L17/dossiers1717060000053699170600000536996PA7932622025-12-09False
17060000053707L17/dossiers1717060000053699170600000536997PA7949062025-12-09False
17060000053708L17/dossiers1717060000053699170600000536998PA7941382025-12-09False
17060000053709L17/dossiers1717060000053699170600000536999PA7955882025-12-09False
17060000053710L17/dossiers17170600000536991706000005369910PA7950842025-12-09False