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
17060000048476L17/dossiers1717060000048471170600000484714PA7932622025-10-14False
17060000048477L17/dossiers1717060000048471170600000484715PA7949062025-10-14False
17060000048478L17/dossiers1717060000048471170600000484716PA7941382025-10-14False
17060000048479L17/dossiers1717060000048471170600000484717PA7955882025-10-14False
17060000048480L17/dossiers1717060000048471170600000484718PA7950842025-10-14False
17060000048481L17/dossiers1717060000048471170600000484719PA8421052025-10-14False
17060000048482L17/dossiers17170600000484711706000004847110PA8416572025-10-14False
17060000048483L17/dossiers17170600000484711706000004847111PA7204302025-10-14False
17060000048484L17/dossiers17170600000484711706000004847112PA7937722025-10-14False
17060000048485L17/dossiers17170600000484711706000004847113PA7956162025-10-14False
17060000048486L17/dossiers17170600000484711706000004847114PA7934442025-10-14False
17060000048487L17/dossiers17170600000484711706000004847115PA7949382025-10-14False
17060000048488L17/dossiers17170600000484711706000004847116PA7953182025-10-14False
17060000048489L17/dossiers17170600000484711706000004847117PA8410232025-10-14False
17060000048490L17/dossiers17170600000484711706000004847118PA7960902025-10-14False
17060000048491L17/dossiers17170600000484711706000004847119PA7939122025-10-14False
17060000048492L17/dossiers17170600000484711706000004847120PA8421872025-10-14False
17060000048493L17/dossiers17170600000484711706000004847121PA8420372025-10-14False
17060000048494L17/dossiers17170600000484711706000004847122PA7918122025-10-14False
17060000048495L17/dossiers17170600000484711706000004847123PA7212022025-10-14False
17060000048496L17/dossiers17170600000484711706000004847124PA7951362025-10-14False
17060000048497L17/dossiers17170600000484711706000004847125PA7934642025-10-14False
17060000048498L17/dossiers17170600000484711706000004847126PA8421552025-10-14False
17060000048499L17/dossiers17170600000484711706000004847127PA7952002025-10-14False
17060000048500L17/dossiers17170600000484711706000004847128PA7958442025-10-14False
17060000048501L17/dossiers17170600000484711706000004847129PA8412512025-10-14False
17060000048502L17/dossiers17170600000484711706000004847130PA7947862025-10-14False
17060000048503L17/dossiers17170600000484711706000004847131PA7948702025-10-14False
17060000048504L17/dossiers17170600000484711706000004847132PA7960702025-10-14False
17060000048505L17/dossiers17170600000484711706000004847133PA7953102025-10-14False
17060000048506L17/dossiers17170600000484711706000004847134PA7944782025-10-14False
17060000048507L17/dossiers17170600000484711706000004847135PA8419472025-10-14False
17060000048508L17/dossiers17170600000484711706000004847136PA7940822025-10-14False
17060000048509L17/dossiers17170600000484711706000004847137PA7941302025-10-14False
17060000048510L17/dossiers17170600000484711706000004847138PA7208462025-10-14False
17060000048511L17/dossiers17170600000484711706000004847139PA8417292025-10-14False
17060000048512L17/dossiers17170600000484711706000004847140PA7955162025-10-14False
17060000048513L17/dossiers17170600000484711706000004847141PA7956722025-10-14False
17060000048514L17/dossiers17170600000484711706000004847142PA7957462025-10-14False
17060000048515L17/dossiers17170600000484711706000004847143PA7951082025-10-14False
17060000048516L17/dossiers17170600000484711706000004847144PA8415152025-10-14False
17060000048517L17/dossiers17170600000484711706000004847145PA7952982025-10-14False
17060000048518L17/dossiers17170600000484711706000004847146PA7918242025-10-14False
17060000048519L17/dossiers17170600000484711706000004847147PA8420292025-10-14False
17060000048520L17/dossiers17170600000484711706000004847148PA7935322025-10-14False
17060000048521L17/dossiers17170600000484711706000004847149PA3423842025-10-14False
17060000048522L17/dossiers17170600000484711706000004847150PA7954222025-10-14False
17060000048523L17/dossiers17170600000484711706000004847151PA8412152025-10-14False
17060000048524L17/dossiers17170600000484711706000004847152PA7954822025-10-14False
17060000048525L17/dossiers17170600000484711706000004847153PA6106542025-10-14False