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
17060000051181L17/dossiers171706000005105617060000051056124PA7952402025-12-24False
17060000051182L17/dossiers171706000005105617060000051056125PA7214582025-12-24False
17060000051183L17/dossiers171706000005105617060000051056126PA7209602025-12-24False
17060000051184L17/dossiers171706000005105617060000051056127PA7937962025-12-24False
17060000051185L17/dossiers171706000005105617060000051056128PA7939482025-12-24False
17060000051186L17/dossiers171706000005105617060000051056129PA7941182025-12-24False
17060000051187L17/dossiers171706000005105617060000051056130PA7931942025-12-24False
17060000051191L17/dossiers1717060000051189170600000511891PA7961062025-11-18False
17060000051192L17/dossiers1717060000051189170600000511892PA7208382025-11-18False
17060000051193L17/dossiers1717060000051189170600000511893PA7947102025-11-18False
17060000051194L17/dossiers1717060000051189170600000511894PA7958682025-11-18False
17060000051195L17/dossiers1717060000051189170600000511895PA7218962025-11-18False
17060000051196L17/dossiers1717060000051189170600000511896PA7959982025-11-18False
17060000051197L17/dossiers1717060000051189170600000511897PA7749622025-11-18False
17060000051198L17/dossiers1717060000051189170600000511898PA3356122025-11-18False
17060000051199L17/dossiers1717060000051189170600000511899PA8422712025-11-18False
17060000051200L17/dossiers17170600000511891706000005118910PA7931742025-11-18False
17060000051201L17/dossiers17170600000511891706000005118911PA7958202025-11-18False
17060000051202L17/dossiers17170600000511891706000005118912PA7212702025-11-18False
17060000051203L17/dossiers17170600000511891706000005118913PA7952402025-11-18False
17060000051204L17/dossiers17170600000511891706000005118914PA7958762025-11-18False
17060000051205L17/dossiers17170600000511891706000005118915PA6057452025-11-18False
17060000051206L17/dossiers17170600000511891706000005118916PA8422992025-11-18False
17060000051210L17/dossiers1717060000051208170600000512081PA7942782026-02-10False
17060000051211L17/dossiers1717060000051208170600000512082PA8410672026-02-10False
17060000051212L17/dossiers1717060000051208170600000512083PA6428472026-02-10False
17060000051213L17/dossiers1717060000051208170600000512084PA7188842026-02-10False
17060000051214L17/dossiers1717060000051208170600000512085PA3096432026-02-10False
17060000051215L17/dossiers1717060000051208170600000512086PA8408892026-02-10False
17060000051216L17/dossiers1717060000051208170600000512087PA7218162026-02-10False
17060000051217L17/dossiers1717060000051208170600000512088PA8413392026-02-10False
17060000051218L17/dossiers1717060000051208170600000512089PA7188382026-02-10False
17060000051219L17/dossiers17170600000512081706000005120810PA7191382026-02-10False
17060000051220L17/dossiers17170600000512081706000005120811PA7939402026-02-10False
17060000051221L17/dossiers17170600000512081706000005120812PA7192862026-02-10False
17060000051222L17/dossiers17170600000512081706000005120813PA7223902026-02-10False
17060000051223L17/dossiers17170600000512081706000005120814PA6088262026-02-10False
17060000051224L17/dossiers17170600000512081706000005120815PA8700092026-02-10False
17060000051225L17/dossiers17170600000512081706000005120816PA6056942026-02-10False
17060000051226L17/dossiers17170600000512081706000005120817PA8411512026-02-10False
17060000051227L17/dossiers17170600000512081706000005120818PA7944702026-02-10False
17060000051228L17/dossiers17170600000512081706000005120819PA16302026-02-10False
17060000051229L17/dossiers17170600000512081706000005120820PA3467822026-02-10False
17060000051230L17/dossiers17170600000512081706000005120821PA2270892026-02-10False
17060000051231L17/dossiers17170600000512081706000005120822PA7936082026-02-10False
17060000051232L17/dossiers17170600000512081706000005120823PA8407652026-02-10False
17060000051233L17/dossiers17170600000512081706000005120824PA6080162026-02-10False
17060000051234L17/dossiers17170600000512081706000005120825PA8421412026-02-10False
17060000051235L17/dossiers17170600000512081706000005120826PA7941142026-02-10False
17060000051236L17/dossiers17170600000512081706000005120827PA8415632026-02-10False