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
17060000040084L17/dossiers1717060000040081170600000400812PA7953502025-06-24False
17060000040085L17/dossiers1717060000040081170600000400813PA7952702025-06-24False
17060000040086L17/dossiers1717060000040081170600000400814PA7942782025-06-24False
17060000040087L17/dossiers1717060000040081170600000400815PA7939922025-06-24False
17060000040088L17/dossiers1717060000040081170600000400816PA7952782025-06-24False
17060000040089L17/dossiers1717060000040081170600000400817PA3322282025-06-24False
17060000040090L17/dossiers1717060000040081170600000400818PA7190322025-06-24False
17060000040091L17/dossiers1717060000040081170600000400819PA8413392025-06-24False
17060000040092L17/dossiers17170600000400811706000004008110PA2677802025-06-24False
17060000040093L17/dossiers17170600000400811706000004008111PA7944702025-06-24False
17060000040094L17/dossiers17170600000400811706000004008112PA7942342025-06-24False
17060000040095L17/dossiers17170600000400811706000004008113PA7197782025-06-24False
17060000040096L17/dossiers17170600000400811706000004008114PA7190522025-06-24False
17060000040097L17/dossiers17170600000400811706000004008115PA7192822025-06-24False
17060000040098L17/dossiers17170600000400811706000004008116PA8421252025-06-24False
17060000040099L17/dossiers17170600000400811706000004008117PA7944262025-06-24False
17060000040100L17/dossiers17170600000400811706000004008118PA7948382025-06-24False
17060000040101L17/dossiers17170600000400811706000004008119PA7944662025-06-24False
17060000040102L17/dossiers17170600000400811706000004008120PA7209082025-06-24False
17060000040103L17/dossiers17170600000400811706000004008121PA7933982025-06-24False
17060000040104L17/dossiers17170600000400811706000004008122PA7214582025-06-24False
17060000040105L17/dossiers17170600000400811706000004008123PA7201382025-06-24False
17060000040106L17/dossiers17170600000400811706000004008124PA7950262025-06-24False
17060000040107L17/dossiers17170600000400811706000004008125PA7218442025-06-24False
17060000040108L17/dossiers17170600000400811706000004008126PA6872142025-06-24False
17060000040109L17/dossiers17170600000400811706000004008127PA7220702025-06-24False
17060000040110L17/dossiers17170600000400811706000004008128PA7202302025-06-24False
17060000040111L17/dossiers17170600000400811706000004008129PA7935722025-06-24False
17060000040112L17/dossiers17170600000400811706000004008130PA7205522025-06-24False
17060000040113L17/dossiers17170600000400811706000004008131PA7223362025-06-24False
17060000040117L17/dossiers1717060000040115170600000401151PA7940822025-06-24False
17060000040118L17/dossiers1717060000040115170600000401152PA7946862025-06-24False
17060000040119L17/dossiers1717060000040115170600000401153PA7941662025-06-24False
17060000040120L17/dossiers1717060000040115170600000401154PA7952282025-06-24False
17060000040121L17/dossiers1717060000040115170600000401155PA7932622025-06-24False
17060000040122L17/dossiers1717060000040115170600000401156PA7949062025-06-24False
17060000040123L17/dossiers1717060000040115170600000401157PA7941382025-06-24False
17060000040124L17/dossiers1717060000040115170600000401158PA7955882025-06-24False
17060000040125L17/dossiers1717060000040115170600000401159PA7950842025-06-24False
17060000040126L17/dossiers17170600000401151706000004011510PA8421052025-06-24False
17060000040127L17/dossiers17170600000401151706000004011511PA8416572025-06-24False
17060000040128L17/dossiers17170600000401151706000004011512PA7204302025-06-24False
17060000040129L17/dossiers17170600000401151706000004011513PA7937722025-06-24False
17060000040130L17/dossiers17170600000401151706000004011514PA7956162025-06-24False
17060000040131L17/dossiers17170600000401151706000004011515PA7934442025-06-24False
17060000040132L17/dossiers17170600000401151706000004011516PA7949382025-06-24False
17060000040133L17/dossiers17170600000401151706000004011517PA7953182025-06-24False
17060000040134L17/dossiers17170600000401151706000004011518PA8410232025-06-24False
17060000040135L17/dossiers17170600000401151706000004011519PA7960902025-06-24False
17060000040136L17/dossiers17170600000401151706000004011520PA7939122025-06-24False