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
17060000027458L17/dossiers1717060000027452170600000274525PA7952782026-05-06False
17060000027459L17/dossiers1717060000027452170600000274526PA3322282026-05-06False
17060000027460L17/dossiers1717060000027452170600000274527PA6872142026-05-06False
17060000027461L17/dossiers1717060000027452170600000274528PA3096432026-05-06False
17060000027462L17/dossiers1717060000027452170600000274529PA8421832026-05-06False
17060000027463L17/dossiers17170600000274521706000002745210PA7201622026-05-06False
17060000027464L17/dossiers17170600000274521706000002745211PA5692026-05-06False
17060000027465L17/dossiers17170600000274521706000002745212PA7218162026-05-06False
17060000027466L17/dossiers17170600000274521706000002745213PA7940942026-05-06False
17060000027467L17/dossiers17170600000274521706000002745214PA7190322026-05-06False
17060000027468L17/dossiers17170600000274521706000002745215PA8413392026-05-06False
17060000027469L17/dossiers17170600000274521706000002745216PA7943302026-05-06False
17060000027470L17/dossiers17170600000274521706000002745217PA8408172026-05-06False
17060000027471L17/dossiers17170600000274521706000002745218PA7220002026-05-06False
17060000027472L17/dossiers17170600000274521706000002745219PA8415392025-02-182025-02-19False
17060000027473L17/dossiers17170600000274521706000002745220PA7191382026-05-06False
17060000027474L17/dossiers17170600000274521706000002745221PA7945542026-05-06False
17060000027475L17/dossiers17170600000274521706000002745222PA6428682026-05-06False
17060000027476L17/dossiers17170600000274521706000002745223PA8414312026-05-06False
17060000027477L17/dossiers17170600000274521706000002745224PA7192862026-05-06False
17060000027478L17/dossiers17170600000274521706000002745225PA7223902026-05-06False
17060000027479L17/dossiers17170600000274521706000002745226PA7935202026-05-06False
17060000027480L17/dossiers17170600000274521706000002745227PA7944302026-05-06False
17060000027481L17/dossiers17170600000274521706000002745228PA7199142026-05-06False
17060000027482L17/dossiers17170600000274521706000002745229PA7931222026-05-06False
17060000027483L17/dossiers17170600000274521706000002745230PA7949822026-05-06False
17060000027484L17/dossiers17170600000274521706000002745231PA7201542026-05-06False
17060000027485L17/dossiers17170600000274521706000002745232PA6088262026-05-06False
17060000027486L17/dossiers17170600000274521706000002745233PA7946582026-05-06False
17060000027487L17/dossiers17170600000274521706000002745234PA6056942026-05-06False
17060000027488L17/dossiers17170600000274521706000002745235PA7199382026-05-06False
17060000027489L17/dossiers17170600000274521706000002745236PA8402352026-05-06False
17060000027490L17/dossiers17170600000274521706000002745237PA7944702026-05-06False
17060000027491L17/dossiers17170600000274521706000002745238PA2673182026-05-06False
17060000027492L17/dossiers17170600000274521706000002745239PA7940582026-05-06False
17060000027493L17/dossiers17170600000274521706000002745240PA15672026-05-06False
17060000027494L17/dossiers17170600000274521706000002745241PA7220702026-05-06False
17060000027495L17/dossiers17170600000274521706000002745242PA7223742026-05-06False
17060000027496L17/dossiers17170600000274521706000002745243PA7203542026-05-06False
17060000027497L17/dossiers17170600000274521706000002745244PA8421172026-05-06False
17060000027498L17/dossiers17170600000274521706000002745245PA7197782026-05-06False
17060000027499L17/dossiers17170600000274521706000002745246PA7200382026-05-06False
17060000027500L17/dossiers17170600000274521706000002745247PA7192822026-05-06False
17060000027501L17/dossiers17170600000274521706000002745248PA8421252026-05-06False
17060000027502L17/dossiers17170600000274521706000002745249PA8416932026-05-06False
17060000027503L17/dossiers17170600000274521706000002745250PA7200222026-05-06False
17060000027504L17/dossiers17170600000274521706000002745251PA7194042026-05-06False
17060000027505L17/dossiers17170600000274521706000002745252PA7944262026-05-06False
17060000027506L17/dossiers17170600000274521706000002745253PA7197562026-05-06False
17060000027507L17/dossiers17170600000274521706000002745254PA8409792026-05-06False