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
17060000031063L17/dossiers1717060000031053170600000310539PA7940942025-03-21False
17060000031064L17/dossiers17170600000310531706000003105310PA7936242025-03-21False
17060000031065L17/dossiers17170600000310531706000003105311PA7957622025-03-21False
17060000031066L17/dossiers17170600000310531706000003105312PA6082642025-03-21False
17060000031067L17/dossiers17170600000310531706000003105313PA8409032025-03-21False
17060000031068L17/dossiers17170600000310531706000003105314PA8412952025-03-21False
17060000031069L17/dossiers17170600000310531706000003105315PA10082025-03-21False
17060000031070L17/dossiers17170600000310531706000003105316PA7933942025-03-21False
17060000031071L17/dossiers17170600000310531706000003105317PA7954302025-03-21False
17060000031072L17/dossiers17170600000310531706000003105318PA8419192025-03-21False
17060000031073L17/dossiers17170600000310531706000003105319PA6065732025-03-21False
17060000031074L17/dossiers17170600000310531706000003105320PA8416332025-03-21False
17060000031075L17/dossiers17170600000310531706000003105321PA7948542025-03-21False
17060000031076L17/dossiers17170600000310531706000003105322PA8421952025-03-21False
17060000031077L17/dossiers17170600000310531706000003105323PA6093322025-03-21False
17060000031078L17/dossiers17170600000310531706000003105324PA8416652025-03-21False
17060000031079L17/dossiers17170600000310531706000003105325PA3332852025-03-21False
17060000031080L17/dossiers17170600000310531706000003105326PA8409392025-03-21False
17060000031081L17/dossiers17170600000310531706000003105327PA8415392025-03-21False
17060000031082L17/dossiers17170600000310531706000003105328PA3319732025-03-21False
17060000031083L17/dossiers17170600000310531706000003105329PA8401712025-03-21False
17060000031084L17/dossiers17170600000310531706000003105330PA15672025-03-21False
17060000031085L17/dossiers17170600000310531706000003105331PA8414712025-03-21False
17060000031086L17/dossiers17170600000310531706000003105332PA8422632025-03-21False
17060000031087L17/dossiers17170600000310531706000003105333PA8418132025-03-21False
17060000031088L17/dossiers17170600000310531706000003105334PA8418532025-03-21False
17060000031089L17/dossiers17170600000310531706000003105335PA16542025-03-21False
17060000031090L17/dossiers17170600000310531706000003105336PA6431922025-03-21False
17060000031091L17/dossiers17170600000310531706000003105337PA3350542025-03-21False
17060000031092L17/dossiers17170600000310531706000003105338PA7951562025-03-21False
17060000031093L17/dossiers17170600000310531706000003105339PA7749582025-03-21False
17060000031094L17/dossiers17170600000310531706000003105340PA8407652025-03-21False
17060000031095L17/dossiers17170600000310531706000003105341PA8414632025-03-21False
17060000031096L17/dossiers17170600000310531706000003105342PA6431572025-03-21False
17060000031097L17/dossiers17170600000310531706000003105343PA8411072025-03-21False
17060000031098L17/dossiers17170600000310531706000003105344PA8413812025-03-21False
17060000031099L17/dossiers17170600000310531706000003105345PA8407932025-03-21False
17060000031100L17/dossiers17170600000310531706000003105346PA7942702025-03-21False
17060000031101L17/dossiers17170600000310531706000003105347PA6081722025-03-21False
17060000031102L17/dossiers17170600000310531706000003105348PA6075532025-03-21False
17060000031103L17/dossiers17170600000310531706000003105349PA8409552025-03-21False
17060000031104L17/dossiers17170600000310531706000003105350PA8413672025-03-21False
17060000031105L17/dossiers17170600000310531706000003105351PA3419812025-03-21False
17060000031106L17/dossiers17170600000310531706000003105352PA8406732025-03-21False
17060000031107L17/dossiers17170600000310531706000003105353PA3421962025-03-21False
17060000031108L17/dossiers17170600000310531706000003105354PA8266352025-03-21False
17060000031109L17/dossiers17170600000310531706000003105355PA8413272025-03-21False
17060000031110L17/dossiers17170600000310531706000003105356PA8417172025-03-21False
17060000031111L17/dossiers17170600000310531706000003105357PA8412432025-03-21False
17060000031112L17/dossiers17170600000310531706000003105358PA7749602025-03-21False