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
17060000022143L17/dossiers17170600000221001706000002210042PA3309092025-03-24False
17060000022144L17/dossiers17170600000221001706000002210043PA8172112025-03-202025-03-24False
17060000022145L17/dossiers17170600000221001706000002210044PA3096432025-03-24False
17060000022146L17/dossiers17170600000221001706000002210045PA8410232025-03-202025-03-24False
17060000022147L17/dossiers17170600000221001706000002210046PA8419472025-03-202025-03-24False
17060000022148L17/dossiers17170600000221001706000002210047PA7955162025-03-202025-03-24False
17060000022149L17/dossiers17170600000221001706000002210048PA7195782025-03-202025-03-24False
17060000022150L17/dossiers17170600000221001706000002210049PA7212022025-03-202025-03-24False
17060000022154L17/dossiers1717060000022152170600000221521PA7208922024-12-19False
17060000022155L17/dossiers1717060000022152170600000221522PA7952282024-12-19False
17060000022156L17/dossiers1717060000022152170600000221523PA7932622024-12-19False
17060000022157L17/dossiers1717060000022152170600000221524PA7949062024-12-19False
17060000022158L17/dossiers1717060000022152170600000221525PA7941382024-12-19False
17060000022159L17/dossiers1717060000022152170600000221526PA7955882024-12-19False
17060000022160L17/dossiers1717060000022152170600000221527PA7950842024-12-19False
17060000022161L17/dossiers1717060000022152170600000221528PA8421052024-12-19False
17060000022162L17/dossiers1717060000022152170600000221529PA8416572024-12-19False
17060000022163L17/dossiers17170600000221521706000002215210PA7204302024-12-19False
17060000022164L17/dossiers17170600000221521706000002215211PA7937722024-12-19False
17060000022165L17/dossiers17170600000221521706000002215212PA7956162024-12-19False
17060000022166L17/dossiers17170600000221521706000002215213PA7934442024-12-19False
17060000022167L17/dossiers17170600000221521706000002215214PA7949382024-12-19False
17060000022168L17/dossiers17170600000221521706000002215215PA7953182024-12-19False
17060000022169L17/dossiers17170600000221521706000002215216PA8410232024-12-19False
17060000022170L17/dossiers17170600000221521706000002215217PA7960902024-12-19False
17060000022171L17/dossiers17170600000221521706000002215218PA7939122024-12-19False
17060000022172L17/dossiers17170600000221521706000002215219PA8421872024-12-19False
17060000022173L17/dossiers17170600000221521706000002215220PA8420372024-12-19False
17060000022174L17/dossiers17170600000221521706000002215221PA7918122024-12-19False
17060000022175L17/dossiers17170600000221521706000002215222PA7937362024-12-19False
17060000022176L17/dossiers17170600000221521706000002215223PA7212022024-12-19False
17060000022177L17/dossiers17170600000221521706000002215224PA7951362024-12-19False
17060000022178L17/dossiers17170600000221521706000002215225PA7934642024-12-19False
17060000022179L17/dossiers17170600000221521706000002215226PA7952002024-12-19False
17060000022180L17/dossiers17170600000221521706000002215227PA7958442024-12-19False
17060000022181L17/dossiers17170600000221521706000002215228PA8412512024-12-19False
17060000022182L17/dossiers17170600000221521706000002215229PA7947862024-12-19False
17060000022183L17/dossiers17170600000221521706000002215230PA7948702024-12-19False
17060000022184L17/dossiers17170600000221521706000002215231PA7960702024-12-19False
17060000022185L17/dossiers17170600000221521706000002215232PA7953102024-12-19False
17060000022186L17/dossiers17170600000221521706000002215233PA7944782024-12-19False
17060000022187L17/dossiers17170600000221521706000002215234PA8419472024-12-19False
17060000022188L17/dossiers17170600000221521706000002215235PA7940822024-12-19False
17060000022189L17/dossiers17170600000221521706000002215236PA7941302024-12-19False
17060000022190L17/dossiers17170600000221521706000002215237PA7208462024-12-19False
17060000022191L17/dossiers17170600000221521706000002215238PA8417292024-12-19False
17060000022192L17/dossiers17170600000221521706000002215239PA7955162024-12-19False
17060000022193L17/dossiers17170600000221521706000002215240PA7956722024-12-19False
17060000022194L17/dossiers17170600000221521706000002215241PA7957462024-12-19False
17060000022195L17/dossiers17170600000221521706000002215242PA7951082024-12-19False