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
17060000030050L17/dossiers17170600000300281706000003002821PA7209082025-04-29False
17060000030051L17/dossiers17170600000300281706000003002822PA8420452025-04-29False
17060000030052L17/dossiers17170600000300281706000003002823PA8413812025-04-29False
17060000030053L17/dossiers17170600000300281706000003002824PA7212342025-04-29False
17060000030054L17/dossiers17170600000300281706000003002825PA7937082025-04-29False
17060000030055L17/dossiers17170600000300281706000003002826PA6081722025-04-29False
17060000030056L17/dossiers17170600000300281706000003002827PA7941542025-04-29False
17060000030057L17/dossiers17170600000300281706000003002828PA7958762025-04-29False
17060000030058L17/dossiers17170600000300281706000003002829PA8406732025-04-29False
17060000030059L17/dossiers17170600000300281706000003002830PA8266352025-04-29False
17060000030060L17/dossiers17170600000300281706000003002831PA7749602025-04-29False
17060000030061L17/dossiers17170600000300281706000003002832PA3403432025-04-29False
17060000030062L17/dossiers17170600000300281706000003002833PA7958082025-04-29False
17060000030063L17/dossiers17170600000300281706000003002834PA8417132025-04-29False
17060000030064L17/dossiers17170600000300281706000003002835PA8418932025-04-29False
17060000030071L17/dossiers1717060000030069170600000300691PA7200382025-05-02False
17060000030072L17/dossiers1717060000030069170600000300692PA7212342025-05-02False
17060000030073L17/dossiers1717060000030069170600000300693PA8226172025-05-02False
17060000030074L17/dossiers1717060000030069170600000300694PA3424152025-05-02False
17060000030075L17/dossiers1717060000030069170600000300695PA8422112025-05-02False
17060000030076L17/dossiers1717060000030069170600000300696PA7208922025-05-02False
17060000030077L17/dossiers1717060000030069170600000300697PA7952282025-05-02False
17060000030078L17/dossiers1717060000030069170600000300698PA7932622025-05-02False
17060000030079L17/dossiers1717060000030069170600000300699PA7949062025-05-02False
17060000030080L17/dossiers17170600000300691706000003006910PA7941382025-05-02False
17060000030081L17/dossiers17170600000300691706000003006911PA7955882025-05-02False
17060000030082L17/dossiers17170600000300691706000003006912PA7950842025-05-02False
17060000030083L17/dossiers17170600000300691706000003006913PA8421052025-05-02False
17060000030084L17/dossiers17170600000300691706000003006914PA8416572025-05-02False
17060000030085L17/dossiers17170600000300691706000003006915PA7204302025-05-02False
17060000030086L17/dossiers17170600000300691706000003006916PA7937722025-05-02False
17060000030087L17/dossiers17170600000300691706000003006917PA7956162025-05-02False
17060000030088L17/dossiers17170600000300691706000003006918PA7934442025-05-02False
17060000030089L17/dossiers17170600000300691706000003006919PA7949382025-05-02False
17060000030090L17/dossiers17170600000300691706000003006920PA7953182025-05-02False
17060000030091L17/dossiers17170600000300691706000003006921PA8410232025-05-02False
17060000030092L17/dossiers17170600000300691706000003006922PA7960902025-05-02False
17060000030093L17/dossiers17170600000300691706000003006923PA8421872025-05-02False
17060000030094L17/dossiers17170600000300691706000003006924PA8420372025-05-02False
17060000030095L17/dossiers17170600000300691706000003006925PA7918122025-05-02False
17060000030096L17/dossiers17170600000300691706000003006926PA7937362025-05-02False
17060000030097L17/dossiers17170600000300691706000003006927PA7212022025-05-02False
17060000030098L17/dossiers17170600000300691706000003006928PA7951362025-05-02False
17060000030099L17/dossiers17170600000300691706000003006929PA7934642025-05-02False
17060000030100L17/dossiers17170600000300691706000003006930PA8421552025-05-02False
17060000030101L17/dossiers17170600000300691706000003006931PA7952002025-05-02False
17060000030102L17/dossiers17170600000300691706000003006932PA7958442025-05-02False
17060000030103L17/dossiers17170600000300691706000003006933PA8412512025-05-02False
17060000030104L17/dossiers17170600000300691706000003006934PA7947862025-05-02False
17060000030105L17/dossiers17170600000300691706000003006935PA7959982025-05-02False