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
17060000017634L17/dossiers17170600000175551706000001755578PA8415072025-03-07False
17060000017635L17/dossiers17170600000175551706000001755579PA7940382025-03-07False
17060000017636L17/dossiers17170600000175551706000001755580PA7948102025-03-07False
17060000017637L17/dossiers17170600000175551706000001755581PA8414192025-03-07False
17060000017638L17/dossiers17170600000175551706000001755582PA2677802025-03-07False
17060000017639L17/dossiers17170600000175551706000001755583PA7947982025-03-07False
17060000017640L17/dossiers17170600000175551706000001755584PA7953302025-03-07False
17060000017641L17/dossiers17170600000175551706000001755585PA7946582025-03-07False
17060000017642L17/dossiers17170600000175551706000001755586PA6056942025-03-07False
17060000017643L17/dossiers17170600000175551706000001755587PA8402352025-03-07False
17060000017653L17/dossiers1717060000017651170600000176511PA8410672024-11-19False
17060000017654L17/dossiers1717060000017651170600000176512PA8412072024-11-19False
17060000017655L17/dossiers1717060000017651170600000176513PA2675612024-11-19False
17060000017656L17/dossiers1717060000017651170600000176514PA8408892024-11-19False
17060000017657L17/dossiers1717060000017651170600000176515PA8407012024-11-19False
17060000017658L17/dossiers1717060000017651170600000176516PA8407212024-11-19False
17060000017659L17/dossiers1717060000017651170600000176517PA7933222024-11-19False
17060000017660L17/dossiers1717060000017651170600000176518PA8407732024-11-19False
17060000017661L17/dossiers1717060000017651170600000176519PA8409832024-11-19False
17060000017662L17/dossiers17170600000176511706000001765110PA8411832024-11-19False
17060000017663L17/dossiers17170600000176511706000001765111PA8413952024-11-19False
17060000017664L17/dossiers17170600000176511706000001765112PA8417692024-11-19False
17060000017665L17/dossiers17170600000176511706000001765113PA8406852024-11-19False
17060000017666L17/dossiers17170600000176511706000001765114PA8406572024-11-19False
17060000017667L17/dossiers17170600000176511706000001765115PA8408092024-11-19False
17060000017674L17/dossiers1717060000017672170600000176721PA7948102024-11-19False
17060000017675L17/dossiers1717060000017672170600000176722PA7947022024-11-19False
17060000017676L17/dossiers1717060000017672170600000176723PA3315822024-11-19False
17060000017677L17/dossiers1717060000017672170600000176724PA6056942024-11-19False
17060000017678L17/dossiers1717060000017672170600000176725PA7211822024-11-19False
17060000017679L17/dossiers1717060000017672170600000176726PA7207202024-11-19False
17060000017680L17/dossiers1717060000017672170600000176727PA7937162024-11-19False
17060000017684L17/dossiers1717060000017682170600000176821PA7957222026-03-19False
17060000017685L17/dossiers1717060000017682170600000176822PA7223662026-03-19False
17060000017686L17/dossiers1717060000017682170600000176823PA7949822026-03-19False
17060000017687L17/dossiers1717060000017682170600000176824PA7200222026-03-19False
17060000017688L17/dossiers1717060000017682170600000176825PA7190802026-03-19False
17060000017689L17/dossiers1717060000017682170600000176826PA7221022026-03-19False
17060000017690L17/dossiers1717060000017682170600000176827PA7219162026-03-19False
17060000017691L17/dossiers1717060000017682170600000176828PA7939922026-03-19False
17060000017692L17/dossiers1717060000017682170600000176829PA7944862026-03-19False
17060000017693L17/dossiers17170600000176821706000001768210PA7223362026-03-19False
17060000017694L17/dossiers17170600000176821706000001768211PA7201542026-03-19False
17060000017695L17/dossiers17170600000176821706000001768212PA7218442026-03-19False
17060000017696L17/dossiers17170600000176821706000001768213PA3322282026-03-19False
17060000017697L17/dossiers17170600000176821706000001768214PA7943302026-03-19False
17060000017701L17/dossiers1717060000017699170600000176991PA7952282024-11-19False
17060000017702L17/dossiers1717060000017699170600000176992PA7932622024-11-19False
17060000017703L17/dossiers1717060000017699170600000176993PA7949062024-11-19False
17060000017704L17/dossiers1717060000017699170600000176994PA7941382024-11-19False