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
17060000023831L17/dossiers1717060000023828170600000238282PA7939922025-01-21False
17060000023832L17/dossiers1717060000023828170600000238283PA7952782025-01-21False
17060000023833L17/dossiers1717060000023828170600000238284PA6872142025-01-21False
17060000023834L17/dossiers1717060000023828170600000238285PA7190322025-01-21False
17060000023835L17/dossiers1717060000023828170600000238286PA8413392025-01-21False
17060000023836L17/dossiers1717060000023828170600000238287PA8414312025-01-21False
17060000023837L17/dossiers1717060000023828170600000238288PA2677802025-01-21False
17060000023838L17/dossiers1717060000023828170600000238289PA7944702025-01-21False
17060000023839L17/dossiers17170600000238281706000002382810PA7942342025-01-21False
17060000023840L17/dossiers17170600000238281706000002382811PA8418332025-01-21False
17060000023841L17/dossiers17170600000238281706000002382812PA7220702025-01-21False
17060000023842L17/dossiers17170600000238281706000002382813PA7190522025-01-21False
17060000023843L17/dossiers17170600000238281706000002382814PA8421252025-01-21False
17060000023844L17/dossiers17170600000238281706000002382815PA7944262025-01-21False
17060000023845L17/dossiers17170600000238281706000002382816PA7948382025-01-21False
17060000023846L17/dossiers17170600000238281706000002382817PA7202302025-01-21False
17060000023847L17/dossiers17170600000238281706000002382818PA6057822025-01-21False
17060000023848L17/dossiers17170600000238281706000002382819PA7945182025-01-21False
17060000023849L17/dossiers17170600000238281706000002382820PA8410132025-01-21False
17060000023850L17/dossiers17170600000238281706000002382821PA7944662025-01-21False
17060000023851L17/dossiers17170600000238281706000002382822PA7209082025-01-21False
17060000023852L17/dossiers17170600000238281706000002382823PA7933982025-01-21False
17060000023853L17/dossiers17170600000238281706000002382824PA7218442025-01-21False
17060000023854L17/dossiers17170600000238281706000002382825PA7935722025-01-21False
17060000023855L17/dossiers17170600000238281706000002382826PA7195282025-01-21False
17060000023856L17/dossiers17170600000238281706000002382827PA7205522025-01-21False
17060000023857L17/dossiers17170600000238281706000002382828PA7214582025-01-21False
17060000023858L17/dossiers17170600000238281706000002382829PA7201382025-01-21False
17060000023859L17/dossiers17170600000238281706000002382830PA7223362025-01-21False
17060000023860L17/dossiers17170600000238281706000002382831PA7953502025-01-21False
17060000023861L17/dossiers17170600000238281706000002382832PA7950262025-01-21False
17060000023865L17/dossiers1717060000023863170600000238631PA7217642025-01-21False
17060000023866L17/dossiers1717060000023863170600000238632PA8417092025-01-21False
17060000023867L17/dossiers1717060000023863170600000238633PA7959502025-01-21False
17060000023868L17/dossiers1717060000023863170600000238634PA7959622025-01-21False
17060000023872L17/dossiers1717060000023870170600000238701PA8408892025-01-21False
17060000023873L17/dossiers1717060000023870170600000238702PA8407012025-01-21False
17060000023874L17/dossiers1717060000023870170600000238703PA8407212025-01-21False
17060000023875L17/dossiers1717060000023870170600000238704PA8409832025-01-21False
17060000023876L17/dossiers1717060000023870170600000238705PA8411832025-01-21False
17060000023880L17/dossiers1717060000023878170600000238781PA8410672025-01-21False
17060000023881L17/dossiers1717060000023878170600000238782PA8412072025-01-21False
17060000023882L17/dossiers1717060000023878170600000238783PA8407012025-01-21False
17060000023883L17/dossiers1717060000023878170600000238784PA8407212025-01-21False
17060000023884L17/dossiers1717060000023878170600000238785PA8411832025-01-21False
17060000023885L17/dossiers1717060000023878170600000238786PA8406572025-01-21False
17060000023889L17/dossiers1717060000023887170600000238871PA7120152025-02-18False
17060000023890L17/dossiers1717060000023887170600000238872PA3421962025-02-18False
17060000023891L17/dossiers1717060000023887170600000238873PA3322282025-02-18False
17060000023892L17/dossiers1717060000023887170600000238874PA8409972025-02-18False