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
17060000040449L17/dossiers17170600000403491706000004034999PA6073952026-01-13False
17060000040450L17/dossiers171706000004034917060000040349100PA7941182026-01-13False
17060000040451L17/dossiers171706000004034917060000040349101PA7221022026-01-13False
17060000040452L17/dossiers171706000004034917060000040349102PA6070902026-01-13False
17060000040453L17/dossiers171706000004034917060000040349103PA3315822026-01-13False
17060000040454L17/dossiers171706000004034917060000040349104PA7214742026-01-13False
17060000040455L17/dossiers171706000004034917060000040349105PA7931942026-01-13False
17060000040475L17/dossiers1717060000040473170600000404731PA7208922025-07-30False
17060000040476L17/dossiers1717060000040473170600000404732PA7952282025-07-30False
17060000040477L17/dossiers1717060000040473170600000404733PA7932622025-07-30False
17060000040478L17/dossiers1717060000040473170600000404734PA7949062025-07-30False
17060000040479L17/dossiers1717060000040473170600000404735PA7941382025-07-30False
17060000040480L17/dossiers1717060000040473170600000404736PA7955882025-07-30False
17060000040481L17/dossiers1717060000040473170600000404737PA7950842025-07-30False
17060000040482L17/dossiers1717060000040473170600000404738PA8421052025-07-30False
17060000040483L17/dossiers1717060000040473170600000404739PA8416572025-07-30False
17060000040484L17/dossiers17170600000404731706000004047310PA7204302025-07-30False
17060000040485L17/dossiers17170600000404731706000004047311PA7937722025-07-30False
17060000040486L17/dossiers17170600000404731706000004047312PA7956162025-07-30False
17060000040487L17/dossiers17170600000404731706000004047313PA7934442025-07-30False
17060000040488L17/dossiers17170600000404731706000004047314PA8418852025-07-30False
17060000040489L17/dossiers17170600000404731706000004047315PA7949382025-07-30False
17060000040490L17/dossiers17170600000404731706000004047316PA7208382025-07-30False
17060000040491L17/dossiers17170600000404731706000004047317PA7953182025-07-30False
17060000040492L17/dossiers17170600000404731706000004047318PA7936242025-07-30False
17060000040493L17/dossiers17170600000404731706000004047319PA8410232025-07-30False
17060000040494L17/dossiers17170600000404731706000004047320PA7960902025-07-30False
17060000040495L17/dossiers17170600000404731706000004047321PA7939122025-07-30False
17060000040496L17/dossiers17170600000404731706000004047322PA8421872025-07-30False
17060000040497L17/dossiers17170600000404731706000004047323PA8420372025-07-30False
17060000040498L17/dossiers17170600000404731706000004047324PA7918122025-07-30False
17060000040499L17/dossiers17170600000404731706000004047325PA7937362025-07-30False
17060000040500L17/dossiers17170600000404731706000004047326PA7212022025-07-30False
17060000040501L17/dossiers17170600000404731706000004047327PA7212102025-07-30False
17060000040502L17/dossiers17170600000404731706000004047328PA7951362025-07-30False
17060000040503L17/dossiers17170600000404731706000004047329PA7934522025-07-30False
17060000040504L17/dossiers17170600000404731706000004047330PA7934642025-07-30False
17060000040505L17/dossiers17170600000404731706000004047331PA8421552025-07-30False
17060000040506L17/dossiers17170600000404731706000004047332PA7952002025-07-30False
17060000040507L17/dossiers17170600000404731706000004047333PA8416652025-07-30False
17060000040508L17/dossiers17170600000404731706000004047334PA8412512025-07-30False
17060000040509L17/dossiers17170600000404731706000004047335PA7947862025-07-30False
17060000040510L17/dossiers17170600000404731706000004047336PA7948702025-07-30False
17060000040511L17/dossiers17170600000404731706000004047337PA7960702025-07-30False
17060000040512L17/dossiers17170600000404731706000004047338PA7950102025-07-30False
17060000040513L17/dossiers17170600000404731706000004047339PA7953102025-07-30False
17060000040514L17/dossiers17170600000404731706000004047340PA7944782025-07-30False
17060000040515L17/dossiers17170600000404731706000004047341PA8419472025-07-30False
17060000040516L17/dossiers17170600000404731706000004047342PA7940822025-07-30False
17060000040517L17/dossiers17170600000404731706000004047343PA7941302025-07-30False