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
17060000053496L17/dossiers1717060000053491170600000534914PA7949062025-12-09False
17060000053497L17/dossiers1717060000053491170600000534915PA7941382025-12-09False
17060000053498L17/dossiers1717060000053491170600000534916PA7955882025-12-09False
17060000053499L17/dossiers1717060000053491170600000534917PA7950842025-12-09False
17060000053500L17/dossiers1717060000053491170600000534918PA8421052025-12-09False
17060000053501L17/dossiers1717060000053491170600000534919PA8416572025-12-09False
17060000053502L17/dossiers17170600000534911706000005349110PA7204302025-12-09False
17060000053503L17/dossiers17170600000534911706000005349111PA7937722025-12-09False
17060000053504L17/dossiers17170600000534911706000005349112PA7956162025-12-09False
17060000053505L17/dossiers17170600000534911706000005349113PA7934442025-12-09False
17060000053506L17/dossiers17170600000534911706000005349114PA7949382025-12-09False
17060000053507L17/dossiers17170600000534911706000005349115PA7953182025-12-09False
17060000053508L17/dossiers17170600000534911706000005349116PA8410232025-12-09False
17060000053509L17/dossiers17170600000534911706000005349117PA7960902025-12-09False
17060000053510L17/dossiers17170600000534911706000005349118PA7939122025-12-09False
17060000053511L17/dossiers17170600000534911706000005349119PA8421872025-12-09False
17060000053512L17/dossiers17170600000534911706000005349120PA8420372025-12-09False
17060000053513L17/dossiers17170600000534911706000005349121PA7918122025-12-09False
17060000053514L17/dossiers17170600000534911706000005349122PA7212022025-12-09False
17060000053515L17/dossiers17170600000534911706000005349123PA7951362025-12-09False
17060000053516L17/dossiers17170600000534911706000005349124PA7934642025-12-09False
17060000053517L17/dossiers17170600000534911706000005349125PA8421552025-12-09False
17060000053518L17/dossiers17170600000534911706000005349126PA7952002025-12-09False
17060000053519L17/dossiers17170600000534911706000005349127PA7958442025-12-09False
17060000053520L17/dossiers17170600000534911706000005349128PA8412512025-12-09False
17060000053521L17/dossiers17170600000534911706000005349129PA7947862025-12-09False
17060000053522L17/dossiers17170600000534911706000005349130PA7948702025-12-09False
17060000053523L17/dossiers17170600000534911706000005349131PA7960702025-12-09False
17060000053524L17/dossiers17170600000534911706000005349132PA7953102025-12-09False
17060000053525L17/dossiers17170600000534911706000005349133PA7944782025-12-09False
17060000053526L17/dossiers17170600000534911706000005349134PA8419472025-12-09False
17060000053527L17/dossiers17170600000534911706000005349135PA7940822025-12-09False
17060000053528L17/dossiers17170600000534911706000005349136PA7941302025-12-09False
17060000053529L17/dossiers17170600000534911706000005349137PA7208462025-12-09False
17060000053530L17/dossiers17170600000534911706000005349138PA8417292025-12-09False
17060000053531L17/dossiers17170600000534911706000005349139PA7955162025-12-09False
17060000053532L17/dossiers17170600000534911706000005349140PA7956722025-12-09False
17060000053533L17/dossiers17170600000534911706000005349141PA8415152025-12-09False
17060000053534L17/dossiers17170600000534911706000005349142PA7957462025-12-09False
17060000053535L17/dossiers17170600000534911706000005349143PA7951082025-12-09False
17060000053536L17/dossiers17170600000534911706000005349144PA7952982025-12-09False
17060000053537L17/dossiers17170600000534911706000005349145PA7918242025-12-09False
17060000053538L17/dossiers17170600000534911706000005349146PA8420292025-12-09False
17060000053539L17/dossiers17170600000534911706000005349147PA7935322025-12-09False
17060000053540L17/dossiers17170600000534911706000005349148PA3423842025-12-09False
17060000053541L17/dossiers17170600000534911706000005349149PA7954222025-12-09False
17060000053542L17/dossiers17170600000534911706000005349150PA7946862025-12-09False
17060000053543L17/dossiers17170600000534911706000005349151PA8412152025-12-09False
17060000053544L17/dossiers17170600000534911706000005349152PA7954822025-12-09False
17060000053545L17/dossiers17170600000534911706000005349153PA6106542025-12-09False