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
17060000052459L17/dossiers17170600000523881706000005238870PA7209602026-01-23False
17060000052460L17/dossiers17170600000523881706000005238871PA7954662026-01-23False
17060000052461L17/dossiers17170600000523881706000005238872PA7362012026-01-23False
17060000052462L17/dossiers17170600000523881706000005238873PA7937722026-01-23False
17060000052463L17/dossiers17170600000523881706000005238874PA7955882026-01-23False
17060000052464L17/dossiers17170600000523881706000005238875PA7195782026-01-23False
17060000052465L17/dossiers17170600000523881706000005238876PA7948542026-01-23False
17060000052466L17/dossiers17170600000523881706000005238877PA8172112026-01-23False
17060000052467L17/dossiers17170600000523881706000005238878PA7935322026-01-23False
17060000052468L17/dossiers17170600000523881706000005238879PA8418932026-01-23False
17060000052469L17/dossiers17170600000523881706000005238880PA7953102026-01-23False
17060000052470L17/dossiers17170600000523881706000005238881PA7941662026-01-23False
17060000052471L17/dossiers17170600000523881706000005238882PA6100022026-01-23False
17060000052475L17/dossiers1717060000052473170600000524731PA7362012025-12-02False
17060000052476L17/dossiers1717060000052473170600000524732PA8418852025-12-02False
17060000052477L17/dossiers1717060000052473170600000524733PA7218162025-12-02False
17060000052478L17/dossiers1717060000052473170600000524734PA7940942025-12-02False
17060000052479L17/dossiers1717060000052473170600000524735PA6082642025-12-02False
17060000052480L17/dossiers1717060000052473170600000524736PA7191382025-12-02False
17060000052481L17/dossiers1717060000052473170600000524737PA8412952025-12-02False
17060000052482L17/dossiers1717060000052473170600000524738PA7948542025-12-02False
17060000052483L17/dossiers1717060000052473170600000524739PA8416652025-12-02False
17060000052484L17/dossiers17170600000524731706000005247310PA8414192025-12-02False
17060000052485L17/dossiers17170600000524731706000005247311PA8401712025-12-02False
17060000052486L17/dossiers17170600000524731706000005247312PA8422632025-12-02False
17060000052487L17/dossiers17170600000524731706000005247313PA8418532025-12-02False
17060000052488L17/dossiers17170600000524731706000005247314PA8407652025-12-02False
17060000052489L17/dossiers17170600000524731706000005247315PA8413592025-12-02False
17060000052490L17/dossiers17170600000524731706000005247316PA8407932025-12-02False
17060000052491L17/dossiers17170600000524731706000005247317PA7212342025-12-02False
17060000052492L17/dossiers17170600000524731706000005247318PA6081722025-12-02False
17060000052493L17/dossiers17170600000524731706000005247319PA7936642025-12-02False
17060000052494L17/dossiers17170600000524731706000005247320PA7941542025-12-02False
17060000052495L17/dossiers17170600000524731706000005247321PA7952402025-12-02False
17060000052496L17/dossiers17170600000524731706000005247322PA3421962025-12-02False
17060000052497L17/dossiers17170600000524731706000005247323PA6100022025-12-02False
17060000052498L17/dossiers17170600000524731706000005247324PA8417132025-12-02False
17060000052499L17/dossiers17170600000524731706000005247325PA29402025-12-02False
17060000052500L17/dossiers17170600000524731706000005247326PA8409032025-12-02False
17060000052504L17/dossiers1717060000052502170600000525021PA6082642026-03-25False
17060000052505L17/dossiers1717060000052502170600000525022PA6431432026-03-25False
17060000052506L17/dossiers1717060000052502170600000525023PA7200382026-03-25False
17060000052507L17/dossiers1717060000052502170600000525024PA7950102026-03-25False
17060000052508L17/dossiers1717060000052502170600000525025PA3467822026-03-25False
17060000052509L17/dossiers1717060000052502170600000525026PA7952402026-03-25False
17060000052510L17/dossiers1717060000052502170600000525027PA7952702026-03-25False
17060000052511L17/dossiers1717060000052502170600000525028PA8413592026-03-25False
17060000052512L17/dossiers1717060000052502170600000525029PA8422112026-03-25False
17060000052513L17/dossiers17170600000525021706000005250210PA8413812026-03-25False
17060000052514L17/dossiers17170600000525021706000005250211PA8418532026-03-25False