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
17060000052094L17/dossiers17170600000520671706000005206726PA2668082026-01-22False
17060000052095L17/dossiers17170600000520671706000005206727PA2677942026-01-22False
17060000052096L17/dossiers17170600000520671706000005206728PA7941782026-01-22False
17060000052097L17/dossiers17170600000520671706000005206729PA6430892026-01-22False
17060000052098L17/dossiers17170600000520671706000005206730PA6070902026-01-22False
17060000052102L17/dossiers1717060000052100170600000521001PA7937802025-12-02False
17060000052103L17/dossiers1717060000052100170600000521002PA8422112025-12-02False
17060000052104L17/dossiers1717060000052100170600000521003PA8418852025-12-02False
17060000052105L17/dossiers1717060000052100170600000521004PA7940942025-12-02False
17060000052106L17/dossiers1717060000052100170600000521005PA8409032025-12-02False
17060000052107L17/dossiers1717060000052100170600000521006PA8412952025-12-02False
17060000052108L17/dossiers1717060000052100170600000521007PA7933942025-12-02False
17060000052109L17/dossiers1717060000052100170600000521008PA7120152025-12-02False
17060000052110L17/dossiers1717060000052100170600000521009PA7948542025-12-02False
17060000052111L17/dossiers17170600000521001706000005210010PA8416652025-12-02False
17060000052112L17/dossiers17170600000521001706000005210011PA7950102025-12-02False
17060000052113L17/dossiers17170600000521001706000005210012PA8401712025-12-02False
17060000052114L17/dossiers17170600000521001706000005210013PA7219842025-12-02False
17060000052115L17/dossiers17170600000521001706000005210014PA3356122025-12-02False
17060000052116L17/dossiers17170600000521001706000005210015PA7954222025-12-02False
17060000052117L17/dossiers17170600000521001706000005210016PA8414632025-12-02False
17060000052118L17/dossiers17170600000521001706000005210017PA6431572025-12-02False
17060000052119L17/dossiers17170600000521001706000005210018PA6081722025-12-02False
17060000052120L17/dossiers17170600000521001706000005210019PA7936642025-12-02False
17060000052121L17/dossiers17170600000521001706000005210020PA6075532025-12-02False
17060000052122L17/dossiers17170600000521001706000005210021PA7200922025-12-02False
17060000052123L17/dossiers17170600000521001706000005210022PA7941542025-12-02False
17060000052124L17/dossiers17170600000521001706000005210023PA3421962025-12-02False
17060000052125L17/dossiers17170600000521001706000005210024PA6100022025-12-02False
17060000052126L17/dossiers17170600000521001706000005210025PA8417132025-12-02False
17060000052127L17/dossiers17170600000521001706000005210026PA8418932025-12-02False
17060000052131L17/dossiers1717060000052129170600000521291PA7195582026-07-03False
17060000052132L17/dossiers1717060000052129170600000521292PA6082642026-07-03False
17060000052133L17/dossiers1717060000052129170600000521293PA8413152026-07-03False
17060000052134L17/dossiers1717060000052129170600000521294PA8418132026-07-03False
17060000052135L17/dossiers1717060000052129170600000521295PA8418852026-07-03False
17060000052136L17/dossiers1717060000052129170600000521296PA8418532026-07-03False
17060000052137L17/dossiers1717060000052129170600000521297PA7212962026-07-03False
17060000052138L17/dossiers1717060000052129170600000521298PA8414632026-07-03False
17060000052139L17/dossiers1717060000052129170600000521299PA7205522026-07-03False
17060000052140L17/dossiers17170600000521291706000005212910PA8401712026-07-03False
17060000052141L17/dossiers17170600000521291706000005212911PA7950102026-07-03False
17060000052142L17/dossiers17170600000521291706000005212912PA7749622026-07-03False
17060000052143L17/dossiers17170600000521291706000005212913PA8409392026-07-03False
17060000052144L17/dossiers17170600000521291706000005212914PA6093322026-07-03False
17060000052145L17/dossiers17170600000521291706000005212915PA7199302026-07-03False
17060000052146L17/dossiers17170600000521291706000005212916PA7212702026-07-03False
17060000052147L17/dossiers17170600000521291706000005212917PA6065072026-07-03False
17060000052148L17/dossiers17170600000521291706000005212918PA8406652026-07-03False
17060000052149L17/dossiers17170600000521291706000005212919PA6427642026-07-03False