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
17060000029526L17/dossiers17170600000294921706000002949233PA8416812025-03-11False
17060000029527L17/dossiers17170600000294921706000002949234PA8418932025-03-11False
17060000029528L17/dossiers17170600000294921706000002949235PA7938162025-03-11False
17060000029529L17/dossiers17170600000294921706000002949236PA7199302025-03-11False
17060000029533L17/dossiers1717060000029531170600000295311PA7937562025-03-11False
17060000029534L17/dossiers1717060000029531170600000295312PA7918122025-03-11False
17060000029535L17/dossiers1717060000029531170600000295313PA7956162025-03-11False
17060000029536L17/dossiers1717060000029531170600000295314PA7949382025-03-11False
17060000029537L17/dossiers1717060000029531170600000295315PA7208922025-03-11False
17060000029538L17/dossiers1717060000029531170600000295316PA7952282025-03-11False
17060000029539L17/dossiers1717060000029531170600000295317PA7932622025-03-11False
17060000029540L17/dossiers1717060000029531170600000295318PA7949062025-03-11False
17060000029541L17/dossiers1717060000029531170600000295319PA7941382025-03-11False
17060000029542L17/dossiers17170600000295311706000002953110PA7955882025-03-11False
17060000029543L17/dossiers17170600000295311706000002953111PA7950842025-03-11False
17060000029544L17/dossiers17170600000295311706000002953112PA8421052025-03-11False
17060000029545L17/dossiers17170600000295311706000002953113PA8416572025-03-11False
17060000029546L17/dossiers17170600000295311706000002953114PA7204302025-03-11False
17060000029547L17/dossiers17170600000295311706000002953115PA7937722025-03-11False
17060000029548L17/dossiers17170600000295311706000002953116PA7934442025-03-11False
17060000029549L17/dossiers17170600000295311706000002953117PA7953182025-03-11False
17060000029550L17/dossiers17170600000295311706000002953118PA8410232025-03-11False
17060000029551L17/dossiers17170600000295311706000002953119PA7960902025-03-11False
17060000029552L17/dossiers17170600000295311706000002953120PA7939122025-03-11False
17060000029553L17/dossiers17170600000295311706000002953121PA8421872025-03-11False
17060000029554L17/dossiers17170600000295311706000002953122PA8420372025-03-11False
17060000029555L17/dossiers17170600000295311706000002953123PA7937362025-03-11False
17060000029556L17/dossiers17170600000295311706000002953124PA7212022025-03-11False
17060000029557L17/dossiers17170600000295311706000002953125PA7951362025-03-11False
17060000029558L17/dossiers17170600000295311706000002953126PA8421552025-03-11False
17060000029559L17/dossiers17170600000295311706000002953127PA7952002025-03-11False
17060000029560L17/dossiers17170600000295311706000002953128PA7958442025-03-11False
17060000029561L17/dossiers17170600000295311706000002953129PA8412512025-03-11False
17060000029562L17/dossiers17170600000295311706000002953130PA7947862025-03-11False
17060000029563L17/dossiers17170600000295311706000002953131PA7948702025-03-11False
17060000029564L17/dossiers17170600000295311706000002953132PA7960702025-03-11False
17060000029565L17/dossiers17170600000295311706000002953133PA7953102025-03-11False
17060000029566L17/dossiers17170600000295311706000002953134PA7944782025-03-11False
17060000029567L17/dossiers17170600000295311706000002953135PA8419472025-03-11False
17060000029568L17/dossiers17170600000295311706000002953136PA7940822025-03-11False
17060000029569L17/dossiers17170600000295311706000002953137PA7941302025-03-11False
17060000029570L17/dossiers17170600000295311706000002953138PA7208462025-03-11False
17060000029571L17/dossiers17170600000295311706000002953139PA8417292025-03-11False
17060000029572L17/dossiers17170600000295311706000002953140PA7955162025-03-11False
17060000029573L17/dossiers17170600000295311706000002953141PA7956722025-03-11False
17060000029574L17/dossiers17170600000295311706000002953142PA8415152025-03-11False
17060000029575L17/dossiers17170600000295311706000002953143PA7957462025-03-11False
17060000029576L17/dossiers17170600000295311706000002953144PA7951082025-03-11False
17060000029577L17/dossiers17170600000295311706000002953145PA7952982025-03-11False
17060000029578L17/dossiers17170600000295311706000002953146PA7918242025-03-11False