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
17060000022803L17/dossiers17170600000227641706000002276438PA7932302025-03-07False
17060000022804L17/dossiers17170600000227641706000002276439PA8419812025-03-07False
17060000022805L17/dossiers17170600000227641706000002276440PA7944422025-03-07False
17060000022806L17/dossiers17170600000227641706000002276441PA7954102025-03-07False
17060000022807L17/dossiers17170600000227641706000002276442PA7949542025-03-07False
17060000022808L17/dossiers17170600000227641706000002276443PA8422552025-03-07False
17060000022809L17/dossiers17170600000227641706000002276444PA8417772025-01-132025-03-07False
17060000022810L17/dossiers17170600000227641706000002276445PA8415532025-03-07False
17060000022811L17/dossiers17170600000227641706000002276446PA7949462025-03-07False
17060000022821L17/dossiers1717060000022819170600000228191PA7223902025-02-17False
17060000022822L17/dossiers1717060000022819170600000228192PA7199682025-02-17False
17060000022823L17/dossiers1717060000022819170600000228193PA7188502025-02-17False
17060000022824L17/dossiers1717060000022819170600000228194PA7206442025-02-17False
17060000022825L17/dossiers1717060000022819170600000228195PA6080162025-02-17False
17060000022826L17/dossiers1717060000022819170600000228196PA7941782025-02-17False
17060000022827L17/dossiers1717060000022819170600000228197PA6070902025-02-17False
17060000022828L17/dossiers1717060000022819170600000228198PA7188842025-02-17False
17060000022829L17/dossiers1717060000022819170600000228199PA8421172025-02-17False
17060000022830L17/dossiers17170600000228191706000002281910PA7187842025-02-17False
17060000022831L17/dossiers17170600000228191706000002281911PA8417452025-02-17False
17060000022832L17/dossiers17170600000228191706000002281912PA3422402025-02-17False
17060000022833L17/dossiers17170600000228191706000002281913PA3325232024-12-292025-02-17False
17060000022834L17/dossiers17170600000228191706000002281914PA2667932025-02-17False
17060000022835L17/dossiers17170600000228191706000002281915PA7749542025-02-17False
17060000022836L17/dossiers17170600000228191706000002281916PA7214422025-02-17False
17060000022837L17/dossiers17170600000228191706000002281917PA7214102025-02-17False
17060000022838L17/dossiers17170600000228191706000002281918PA6428472025-02-17False
17060000022839L17/dossiers17170600000228191706000002281919PA7218162025-02-17False
17060000022840L17/dossiers17170600000228191706000002281920PA6088262025-02-17False
17060000022841L17/dossiers17170600000228191706000002281921PA3300082025-02-17False
17060000022842L17/dossiers17170600000228191706000002281922PA6060982025-02-17False
17060000022843L17/dossiers17170600000228191706000002281923PA7930942025-02-17False
17060000022847L17/dossiers1717060000022845170600000228451PA6109682026-06-08False
17060000022848L17/dossiers1717060000022845170600000228452PA7955882026-06-08False
17060000022849L17/dossiers1717060000022845170600000228453PA7950842026-06-08False
17060000022850L17/dossiers1717060000022845170600000228454PA7937802026-06-08False
17060000022851L17/dossiers1717060000022845170600000228455PA5888842026-06-08False
17060000022852L17/dossiers1717060000022845170600000228456PA8417012026-06-08False
17060000022853L17/dossiers1717060000022845170600000228457PA7953622026-06-08False
17060000022854L17/dossiers1717060000022845170600000228458PA7937722026-06-08False
17060000022855L17/dossiers1717060000022845170600000228459PA8409972026-06-08False
17060000022856L17/dossiers17170600000228451706000002284510PA8418852026-06-08False
17060000022857L17/dossiers17170600000228451706000002284511PA8415072026-06-08False
17060000022858L17/dossiers17170600000228451706000002284512PA7208382026-06-08False
17060000022859L17/dossiers17170600000228451706000002284513PA7953182026-06-08False
17060000022860L17/dossiers17170600000228451706000002284514PA8410232026-06-08False
17060000022861L17/dossiers17170600000228451706000002284515PA7960902026-06-08False
17060000022862L17/dossiers17170600000228451706000002284516PA8421872026-06-08False
17060000022863L17/dossiers17170600000228451706000002284517PA8420372026-06-08False
17060000022864L17/dossiers17170600000228451706000002284518PA7940082026-06-08False