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 151 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
17060000016945L17/dossiers1717060000016939170600000169395PA8416652024-10-29False
17060000016946L17/dossiers1717060000016939170600000169396PA8418132024-10-29False
17060000016947L17/dossiers1717060000016939170600000169397PA8406732024-10-29False
17060000016948L17/dossiers1717060000016939170600000169398PA8410912024-10-29False
17060000016949L17/dossiers1717060000016939170600000169399PA7749602024-10-29False
17060000016950L17/dossiers17170600000169391706000001693910PA8406652024-10-29False
17060000016951L17/dossiers17170600000169391706000001693911PA6427642024-10-29False
17060000016952L17/dossiers17170600000169391706000001693912PA6431432024-10-29False
17060000016953L17/dossiers17170600000169391706000001693913PA8408292024-10-29False
17060000016954L17/dossiers17170600000169391706000001693914PA3424152024-10-29False
17060000016955L17/dossiers17170600000169391706000001693915PA6067932024-10-29False
17060000016956L17/dossiers17170600000169391706000001693916PA8422112024-10-29False
17060000016957L17/dossiers17170600000169391706000001693917PA8413152024-10-29False
17060000016958L17/dossiers17170600000169391706000001693918PA7940942024-10-29False
17060000016959L17/dossiers17170600000169391706000001693919PA7936242024-10-29False
17060000016960L17/dossiers17170600000169391706000001693920PA7957622024-10-29False
17060000016961L17/dossiers17170600000169391706000001693921PA8409032024-10-29False
17060000016962L17/dossiers17170600000169391706000001693922PA10082024-10-29False
17060000016963L17/dossiers17170600000169391706000001693923PA7954302024-10-29False
17060000016964L17/dossiers17170600000169391706000001693924PA8419192024-10-29False
17060000016965L17/dossiers17170600000169391706000001693925PA6065732024-10-29False
17060000016966L17/dossiers17170600000169391706000001693926PA8416332024-10-29False
17060000016967L17/dossiers17170600000169391706000001693927PA7948542024-10-29False
17060000016968L17/dossiers17170600000169391706000001693928PA8421952024-10-29False
17060000016969L17/dossiers17170600000169391706000001693929PA6093322024-10-29False
17060000016970L17/dossiers17170600000169391706000001693930PA3332852024-10-29False
17060000016971L17/dossiers17170600000169391706000001693931PA8409392024-10-29False
17060000016972L17/dossiers17170600000169391706000001693932PA8415392024-10-29False
17060000016973L17/dossiers17170600000169391706000001693933PA3319732024-10-29False
17060000016974L17/dossiers17170600000169391706000001693934PA8401712024-10-29False
17060000016975L17/dossiers17170600000169391706000001693935PA15672024-10-29False
17060000016976L17/dossiers17170600000169391706000001693936PA8414712024-10-29False
17060000016977L17/dossiers17170600000169391706000001693937PA8422632024-10-29False
17060000016978L17/dossiers17170600000169391706000001693938PA16542024-10-29False
17060000016979L17/dossiers17170600000169391706000001693939PA6431922024-10-29False
17060000016980L17/dossiers17170600000169391706000001693940PA3350542024-10-29False
17060000016981L17/dossiers17170600000169391706000001693941PA7951562024-10-29False
17060000016982L17/dossiers17170600000169391706000001693942PA7749582024-10-29False
17060000016983L17/dossiers17170600000169391706000001693943PA8407652024-10-29False
17060000016984L17/dossiers17170600000169391706000001693944PA8414632024-10-29False
17060000016985L17/dossiers17170600000169391706000001693945PA6431572024-10-29False
17060000016986L17/dossiers17170600000169391706000001693946PA8411072024-10-29False
17060000016987L17/dossiers17170600000169391706000001693947PA8413812024-10-29False
17060000016988L17/dossiers17170600000169391706000001693948PA8407932024-10-29False
17060000016989L17/dossiers17170600000169391706000001693949PA7942702024-10-29False
17060000016990L17/dossiers17170600000169391706000001693950PA6081722024-10-29False
17060000016991L17/dossiers17170600000169391706000001693951PA6075532024-10-29False
17060000016992L17/dossiers17170600000169391706000001693952PA8409552024-10-29False
17060000016993L17/dossiers17170600000169391706000001693953PA8413672024-10-29False
17060000016994L17/dossiers17170600000169391706000001693954PA3419812024-10-29False