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
17060000031528L17/dossiers17170600000314961706000003149631PA3357582025-03-25False
17060000031529L17/dossiers17170600000314961706000003149632PA8419272025-03-25False
17060000031530L17/dossiers17170600000314961706000003149633PA7214582025-03-25False
17060000031531L17/dossiers17170600000314961706000003149634PA7932702025-03-25False
17060000031532L17/dossiers17170600000314961706000003149635PA7201902025-03-25False
17060000031533L17/dossiers17170600000314961706000003149636PA7944862025-03-25False
17060000031534L17/dossiers17170600000314961706000003149637PA7959202025-03-25False
17060000031535L17/dossiers17170600000314961706000003149638PA6073952025-03-25False
17060000031536L17/dossiers17170600000314961706000003149639PA7221022025-03-25False
17060000031537L17/dossiers17170600000314961706000003149640PA7195122025-03-25False
17060000031538L17/dossiers17170600000314961706000003149641PA7931942025-03-25False
17060000031539L17/dossiers17170600000314961706000003149642PA29602025-03-25False
17060000031543L17/dossiers1717060000031541170600000315411PA7218162025-03-25False
17060000031544L17/dossiers1717060000031541170600000315412PA8408172025-03-25False
17060000031545L17/dossiers1717060000031541170600000315413PA7947982025-03-25False
17060000031546L17/dossiers1717060000031541170600000315414PA7199222025-03-25False
17060000031547L17/dossiers1717060000031541170600000315415PA7949822025-03-25False
17060000031548L17/dossiers1717060000031541170600000315416PA7946582025-03-25False
17060000031549L17/dossiers1717060000031541170600000315417PA6056942025-03-25False
17060000031550L17/dossiers1717060000031541170600000315418PA7221342025-03-25False
17060000031551L17/dossiers1717060000031541170600000315419PA8402352025-03-25False
17060000031552L17/dossiers17170600000315411706000003154110PA7223662025-03-25False
17060000031553L17/dossiers17170600000315411706000003154111PA7203542025-03-25False
17060000031554L17/dossiers17170600000315411706000003154112PA6431842025-03-25False
17060000031555L17/dossiers17170600000315411706000003154113PA8416932025-03-25False
17060000031556L17/dossiers17170600000315411706000003154114PA7197562025-03-25False
17060000031557L17/dossiers17170600000315411706000003154115PA7120142025-03-25False
17060000031558L17/dossiers17170600000315411706000003154116PA8416012025-03-25False
17060000031559L17/dossiers17170600000315411706000003154117PA7947022025-03-25False
17060000031560L17/dossiers17170600000315411706000003154118PA7204462025-03-25False
17060000031561L17/dossiers17170600000315411706000003154119PA7202302025-03-25False
17060000031562L17/dossiers17170600000315411706000003154120PA7942062025-03-25False
17060000031563L17/dossiers17170600000315411706000003154121PA7190802025-03-25False
17060000031564L17/dossiers17170600000315411706000003154122PA6774832025-03-25False
17060000031565L17/dossiers17170600000315411706000003154123PA8419312025-03-25False
17060000031566L17/dossiers17170600000315411706000003154124PA8413592025-03-25False
17060000031567L17/dossiers17170600000315411706000003154125PA7212342025-03-25False
17060000031568L17/dossiers17170600000315411706000003154126PA7219162025-03-25False
17060000031569L17/dossiers17170600000315411706000003154127PA3357582025-03-25False
17060000031570L17/dossiers17170600000315411706000003154128PA8419272025-03-25False
17060000031571L17/dossiers17170600000315411706000003154129PA7214582025-03-25False
17060000031572L17/dossiers17170600000315411706000003154130PA7932702025-03-25False
17060000031573L17/dossiers17170600000315411706000003154131PA7201902025-03-25False
17060000031574L17/dossiers17170600000315411706000003154132PA7944862025-03-25False
17060000031575L17/dossiers17170600000315411706000003154133PA7959202025-03-25False
17060000031576L17/dossiers17170600000315411706000003154134PA6073952025-03-25False
17060000031577L17/dossiers17170600000315411706000003154135PA7221022025-03-25False
17060000031581L17/dossiers1717060000031579170600000315791PA7204302025-03-18False
17060000031582L17/dossiers1717060000031579170600000315792PA7946862025-03-18False
17060000031586L17/dossiers1717060000031584170600000315841PA7199222025-06-12False