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
17060000043106L17/dossiers17170600000430401706000004304065PA7937442025-07-11False
17060000043107L17/dossiers17170600000430401706000004304066PA7209522025-07-11False
17060000043108L17/dossiers17170600000430401706000004304067PA7941062025-07-11False
17060000043109L17/dossiers17170600000430401706000004304068PA7941662025-07-11False
17060000043110L17/dossiers17170600000430401706000004304069PA7951642025-07-11False
17060000043111L17/dossiers17170600000430401706000004304070PA7955962025-07-11False
17060000043115L17/dossiers1717060000043113170600000431131PA8410672025-09-17False
17060000043116L17/dossiers1717060000043113170600000431132PA2675612025-07-112025-07-11False
17060000043117L17/dossiers1717060000043113170600000431133PA7932382025-09-17False
17060000043118L17/dossiers1717060000043113170600000431134PA7933742025-09-17False
17060000043119L17/dossiers1717060000043113170600000431135PA7931582025-09-17False
17060000043120L17/dossiers1717060000043113170600000431136PA7944342025-09-17False
17060000043121L17/dossiers1717060000043113170600000431137PA8416452025-09-17False
17060000043122L17/dossiers1717060000043113170600000431138PA7208222025-09-17False
17060000043123L17/dossiers1717060000043113170600000431139PA7206682025-09-17False
17060000043124L17/dossiers17170600000431131706000004311310PA7948862025-09-17False
17060000043125L17/dossiers17170600000431131706000004311311PA7938442025-09-17False
17060000043126L17/dossiers17170600000431131706000004311312PA8411312025-09-17False
17060000043127L17/dossiers17170600000431131706000004311313PA7931822025-09-17False
17060000043128L17/dossiers17170600000431131706000004311314PA7931342025-09-17False
17060000043129L17/dossiers17170600000431131706000004311315PA7204682025-09-17False
17060000043130L17/dossiers17170600000431131706000004311316PA7935482025-09-17False
17060000043131L17/dossiers17170600000431131706000004311317PA8401192025-09-17False
17060000043132L17/dossiers17170600000431131706000004311318PA7947622025-09-17False
17060000043133L17/dossiers17170600000431131706000004311319PA7931462025-09-17False
17060000043134L17/dossiers17170600000431131706000004311320PA8401352025-09-17False
17060000043135L17/dossiers17170600000431131706000004311321PA8420732025-09-17False
17060000043136L17/dossiers17170600000431131706000004311322PA8417612025-09-17False
17060000043137L17/dossiers17170600000431131706000004311323PA8416212025-09-17False
17060000043138L17/dossiers17170600000431131706000004311324PA7932462025-09-17False
17060000043139L17/dossiers17170600000431131706000004311325PA8416132025-09-17False
17060000043140L17/dossiers17170600000431131706000004311326PA8408012025-09-17False
17060000043141L17/dossiers17170600000431131706000004311327PA8411392025-09-17False
17060000043142L17/dossiers17170600000431131706000004311328PA7938922025-09-17False
17060000043143L17/dossiers17170600000431131706000004311329PA8417372025-09-17False
17060000043144L17/dossiers17170600000431131706000004311330PA7960342025-09-17False
17060000043145L17/dossiers17170600000431131706000004311331PA7931022025-09-17False
17060000043146L17/dossiers17170600000431131706000004311332PA8416052025-09-17False
17060000043147L17/dossiers17170600000431131706000004311333PA7933622025-09-17False
17060000043148L17/dossiers17170600000431131706000004311334PA7935922025-09-17False
17060000043149L17/dossiers17170600000431131706000004311335PA8407572025-09-17False
17060000043150L17/dossiers17170600000431131706000004311336PA7947342025-09-17False
17060000043151L17/dossiers17170600000431131706000004311337PA7959002025-09-17False
17060000043152L17/dossiers17170600000431131706000004311338PA8420852025-09-17False
17060000043153L17/dossiers17170600000431131706000004311339PA8414392025-09-17False
17060000043154L17/dossiers17170600000431131706000004311340PA7940302025-09-17False
17060000043155L17/dossiers17170600000431131706000004311341PA8417492025-09-17False
17060000043156L17/dossiers17170600000431131706000004311342PA7943542025-09-17False
17060000043157L17/dossiers17170600000431131706000004311343PA7959122025-09-17False
17060000043158L17/dossiers17170600000431131706000004311344PA8418372025-09-17False