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
17060000041846L17/dossiers17170600000418331706000004183312PA7937722025-07-21False
17060000041847L17/dossiers17170600000418331706000004183313PA7956162025-07-21False
17060000041848L17/dossiers17170600000418331706000004183314PA7934442025-07-21False
17060000041849L17/dossiers17170600000418331706000004183315PA7949382025-07-21False
17060000041850L17/dossiers17170600000418331706000004183316PA7953182025-07-21False
17060000041851L17/dossiers17170600000418331706000004183317PA7960902025-07-21False
17060000041852L17/dossiers17170600000418331706000004183318PA7939122025-07-21False
17060000041853L17/dossiers17170600000418331706000004183319PA8421872025-07-21False
17060000041854L17/dossiers17170600000418331706000004183320PA8420372025-07-21False
17060000041855L17/dossiers17170600000418331706000004183321PA7918122025-07-21False
17060000041856L17/dossiers17170600000418331706000004183322PA7937362025-07-21False
17060000041857L17/dossiers17170600000418331706000004183323PA7212022025-07-21False
17060000041858L17/dossiers17170600000418331706000004183324PA7951362025-07-21False
17060000041859L17/dossiers17170600000418331706000004183325PA7934642025-07-21False
17060000041860L17/dossiers17170600000418331706000004183326PA8421552025-07-21False
17060000041861L17/dossiers17170600000418331706000004183327PA7952002025-07-21False
17060000041862L17/dossiers17170600000418331706000004183328PA7958442025-07-21False
17060000041863L17/dossiers17170600000418331706000004183329PA8412512025-07-21False
17060000041864L17/dossiers17170600000418331706000004183330PA7947862025-07-21False
17060000041865L17/dossiers17170600000418331706000004183331PA7948702025-07-21False
17060000041866L17/dossiers17170600000418331706000004183332PA7960702025-07-21False
17060000041867L17/dossiers17170600000418331706000004183333PA7953102025-07-21False
17060000041868L17/dossiers17170600000418331706000004183334PA7944782025-07-21False
17060000041869L17/dossiers17170600000418331706000004183335PA8419472025-07-21False
17060000041870L17/dossiers17170600000418331706000004183336PA7940822025-07-21False
17060000041871L17/dossiers17170600000418331706000004183337PA7941302025-07-21False
17060000041872L17/dossiers17170600000418331706000004183338PA7208462025-07-21False
17060000041873L17/dossiers17170600000418331706000004183339PA8417292025-07-21False
17060000041874L17/dossiers17170600000418331706000004183340PA7955162025-07-21False
17060000041875L17/dossiers17170600000418331706000004183341PA7956722025-07-21False
17060000041876L17/dossiers17170600000418331706000004183342PA7957462025-07-21False
17060000041877L17/dossiers17170600000418331706000004183343PA7951082025-07-21False
17060000041878L17/dossiers17170600000418331706000004183344PA8415152025-07-21False
17060000041879L17/dossiers17170600000418331706000004183345PA7952982025-07-21False
17060000041880L17/dossiers17170600000418331706000004183346PA7918242025-07-21False
17060000041881L17/dossiers17170600000418331706000004183347PA8420292025-07-21False
17060000041882L17/dossiers17170600000418331706000004183348PA7935322025-07-21False
17060000041883L17/dossiers17170600000418331706000004183349PA3423842025-07-21False
17060000041884L17/dossiers17170600000418331706000004183350PA7954222025-07-21False
17060000041885L17/dossiers17170600000418331706000004183351PA7946862025-07-21False
17060000041886L17/dossiers17170600000418331706000004183352PA8412152025-07-21False
17060000041887L17/dossiers17170600000418331706000004183353PA7954822025-07-21False
17060000041888L17/dossiers17170600000418331706000004183354PA6106542025-07-21False
17060000041889L17/dossiers17170600000418331706000004183355PA7219602025-07-21False
17060000041890L17/dossiers17170600000418331706000004183356PA7938722025-07-21False
17060000041891L17/dossiers17170600000418331706000004183357PA8172112025-07-21False
17060000041892L17/dossiers17170600000418331706000004183358PA7937562025-07-21False
17060000041893L17/dossiers17170600000418331706000004183359PA7960622025-07-21False
17060000041894L17/dossiers17170600000418331706000004183360PA7195782025-07-21False
17060000041895L17/dossiers17170600000418331706000004183361PA7210622025-07-21False