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
17060000043489L17/dossiers1717060000043485170600000434853PA16302025-10-10False
17060000043490L17/dossiers1717060000043485170600000434854PA7941782025-10-10False
17060000043491L17/dossiers1717060000043485170600000434855PA3096432025-10-10False
17060000043492L17/dossiers1717060000043485170600000434856PA7203542025-10-10False
17060000043493L17/dossiers1717060000043485170600000434857PA8700102025-10-10False
17060000043494L17/dossiers1717060000043485170600000434858PA7191382025-10-10False
17060000043495L17/dossiers1717060000043485170600000434859PA7933422025-10-10False
17060000043496L17/dossiers17170600000434851706000004348510PA8419312025-10-10False
17060000043497L17/dossiers17170600000434851706000004348511PA7949942025-10-10False
17060000043498L17/dossiers17170600000434851706000004348512PA7218162025-10-10False
17060000043499L17/dossiers17170600000434851706000004348513PA7223902025-10-10False
17060000043500L17/dossiers17170600000434851706000004348514PA7188842025-10-10False
17060000043501L17/dossiers17170600000434851706000004348515PA8413592025-10-10False
17060000043502L17/dossiers17170600000434851706000004348516PA3300082025-10-10False
17060000043506L17/dossiers1717060000043504170600000435041PA6088262025-10-07False
17060000043507L17/dossiers1717060000043504170600000435042PA7214422025-10-07False
17060000043508L17/dossiers1717060000043504170600000435043PA7959502025-10-07False
17060000043509L17/dossiers1717060000043504170600000435044PA7211582025-10-07False
17060000043510L17/dossiers1717060000043504170600000435045PA7951442025-10-07False
17060000043511L17/dossiers1717060000043504170600000435046PA7221902025-10-07False
17060000043512L17/dossiers1717060000043504170600000435047PA6428472025-10-07False
17060000043513L17/dossiers1717060000043504170600000435048PA6429352025-10-07False
17060000043514L17/dossiers1717060000043504170600000435049PA8051662025-10-07False
17060000043515L17/dossiers17170600000435041706000004350410PA7192182025-10-07False
17060000043516L17/dossiers17170600000435041706000004350411PA7199682025-10-07False
17060000043517L17/dossiers17170600000435041706000004350412PA6426952025-10-07False
17060000043518L17/dossiers17170600000435041706000004350413PA7218162025-10-07False
17060000043519L17/dossiers17170600000435041706000004350414PA6065072025-10-07False
17060000043520L17/dossiers17170600000435041706000004350415PA7959902025-10-07False
17060000043521L17/dossiers17170600000435041706000004350416PA7943302025-10-07False
17060000043522L17/dossiers17170600000435041706000004350417PA7198902025-10-07False
17060000043523L17/dossiers17170600000435041706000004350418PA8408172025-10-07False
17060000043524L17/dossiers17170600000435041706000004350419PA7220002025-10-07False
17060000043525L17/dossiers17170600000435041706000004350420PA7947982025-10-07False
17060000043526L17/dossiers17170600000435041706000004350421PA7217502025-10-07False
17060000043527L17/dossiers17170600000435041706000004350422PA6082642025-10-07False
17060000043528L17/dossiers17170600000435041706000004350423PA7953302025-10-07False
17060000043529L17/dossiers17170600000435041706000004350424PA7191382025-10-07False
17060000043530L17/dossiers17170600000435041706000004350425PA8423112025-10-07False
17060000043531L17/dossiers17170600000435041706000004350426PA7199222025-10-07False
17060000043532L17/dossiers17170600000435041706000004350427PA7939402025-10-07False
17060000043533L17/dossiers17170600000435041706000004350428PA7194722025-10-07False
17060000043534L17/dossiers17170600000435041706000004350429PA7958642025-10-07False
17060000043535L17/dossiers17170600000435041706000004350430PA7959082025-10-07False
17060000043536L17/dossiers17170600000435041706000004350431PA8414312025-10-07False
17060000043537L17/dossiers17170600000435041706000004350432PA7191182025-10-07False
17060000043538L17/dossiers17170600000435041706000004350433PA7223902025-10-07False
17060000043539L17/dossiers17170600000435041706000004350434PA7931222025-10-07False
17060000043540L17/dossiers17170600000435041706000004350435PA7949822025-10-07False
17060000043541L17/dossiers17170600000435041706000004350436PA8413592025-10-07False