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
17060000017154L17/dossiers17170600000171431706000001714310PA13272025-02-17False
17060000017155L17/dossiers17170600000171431706000001714311PA7940382025-02-17False
17060000017156L17/dossiers17170600000171431706000001714312PA7187842025-02-17False
17060000017157L17/dossiers17170600000171431706000001714313PA6070902025-02-17False
17060000017161L17/dossiers1717060000017159170600000171591PA6431922024-10-29False
17060000017162L17/dossiers1717060000017159170600000171592PA7199302024-10-29False
17060000017163L17/dossiers1717060000017159170600000171593PA8409392024-10-29False
17060000017164L17/dossiers1717060000017159170600000171594PA8418532024-10-29False
17060000017165L17/dossiers1717060000017159170600000171595PA8406652024-10-29False
17060000017166L17/dossiers1717060000017159170600000171596PA6431432024-10-29False
17060000017167L17/dossiers1717060000017159170600000171597PA8408292024-10-29False
17060000017168L17/dossiers1717060000017159170600000171598PA3424152024-10-29False
17060000017169L17/dossiers1717060000017159170600000171599PA6067932024-10-29False
17060000017170L17/dossiers17170600000171591706000001715910PA8422112024-10-29False
17060000017171L17/dossiers17170600000171591706000001715911PA8413152024-10-29False
17060000017172L17/dossiers17170600000171591706000001715912PA7940942024-10-29False
17060000017173L17/dossiers17170600000171591706000001715913PA7936242024-10-29False
17060000017174L17/dossiers17170600000171591706000001715914PA7957622024-10-29False
17060000017175L17/dossiers17170600000171591706000001715915PA6082642024-10-29False
17060000017176L17/dossiers17170600000171591706000001715916PA8409032024-10-29False
17060000017177L17/dossiers17170600000171591706000001715917PA8412952024-10-29False
17060000017178L17/dossiers17170600000171591706000001715918PA10082024-10-29False
17060000017179L17/dossiers17170600000171591706000001715919PA7933942024-10-29False
17060000017180L17/dossiers17170600000171591706000001715920PA7954302024-10-29False
17060000017181L17/dossiers17170600000171591706000001715921PA8419192024-10-29False
17060000017182L17/dossiers17170600000171591706000001715922PA6065732024-10-29False
17060000017183L17/dossiers17170600000171591706000001715923PA8416332024-10-29False
17060000017184L17/dossiers17170600000171591706000001715924PA7948542024-10-29False
17060000017185L17/dossiers17170600000171591706000001715925PA8421952024-10-29False
17060000017186L17/dossiers17170600000171591706000001715926PA6093322024-10-29False
17060000017187L17/dossiers17170600000171591706000001715927PA8416652024-10-29False
17060000017188L17/dossiers17170600000171591706000001715928PA3332852024-10-29False
17060000017189L17/dossiers17170600000171591706000001715929PA8415392024-10-29False
17060000017190L17/dossiers17170600000171591706000001715930PA3319732024-10-29False
17060000017191L17/dossiers17170600000171591706000001715931PA8401712024-10-29False
17060000017192L17/dossiers17170600000171591706000001715932PA15672024-10-29False
17060000017193L17/dossiers17170600000171591706000001715933PA8414712024-10-29False
17060000017194L17/dossiers17170600000171591706000001715934PA8422632024-10-29False
17060000017195L17/dossiers17170600000171591706000001715935PA8418132024-10-29False
17060000017196L17/dossiers17170600000171591706000001715936PA16542024-10-29False
17060000017197L17/dossiers17170600000171591706000001715937PA3350542024-10-29False
17060000017198L17/dossiers17170600000171591706000001715938PA7951562024-10-29False
17060000017199L17/dossiers17170600000171591706000001715939PA7749582024-10-29False
17060000017200L17/dossiers17170600000171591706000001715940PA8407652024-10-29False
17060000017201L17/dossiers17170600000171591706000001715941PA8414632024-10-29False
17060000017202L17/dossiers17170600000171591706000001715942PA6431572024-10-29False
17060000017203L17/dossiers17170600000171591706000001715943PA8411072024-10-29False
17060000017204L17/dossiers17170600000171591706000001715944PA8413812024-10-29False
17060000017205L17/dossiers17170600000171591706000001715945PA8407932024-10-29False
17060000017206L17/dossiers17170600000171591706000001715946PA7942702024-10-29False