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
17060000029205L17/dossiers17170600000291651706000002916539PA7944422025-03-11False
17060000029206L17/dossiers17170600000291651706000002916540PA7936162025-03-11False
17060000029210L17/dossiers1717060000029208170600000292081PA7201542026-01-13False
17060000029211L17/dossiers1717060000029208170600000292082PA7218442026-01-13False
17060000029212L17/dossiers1717060000029208170600000292083PA7749602026-01-13False
17060000029213L17/dossiers1717060000029208170600000292084PA7196402026-01-13False
17060000029214L17/dossiers1717060000029208170600000292085PA7946582026-01-13False
17060000029215L17/dossiers1717060000029208170600000292086PA8172032026-01-13False
17060000029216L17/dossiers1717060000029208170600000292087PA7197562026-01-13False
17060000029217L17/dossiers1717060000029208170600000292088PA7211702026-01-13False
17060000029218L17/dossiers1717060000029208170600000292089PA8414312026-01-13False
17060000029219L17/dossiers17170600000292081706000002920810PA7933422026-01-13False
17060000029220L17/dossiers17170600000292081706000002920811PA8422632026-01-13False
17060000029221L17/dossiers17170600000292081706000002920812PA7209602026-01-13False
17060000029222L17/dossiers17170600000292081706000002920813PA7208382026-01-13False
17060000029223L17/dossiers17170600000292081706000002920814PA7195582026-01-13False
17060000029224L17/dossiers17170600000292081706000002920815PA8051662026-01-13False
17060000029225L17/dossiers17170600000292081706000002920816PA7190242026-01-13False
17060000029226L17/dossiers17170600000292081706000002920817PA7213362026-01-13False
17060000029227L17/dossiers17170600000292081706000002920818PA7937162026-01-13False
17060000029228L17/dossiers17170600000292081706000002920819PA7199142026-01-13False
17060000029229L17/dossiers17170600000292081706000002920820PA6056942026-01-13False
17060000029230L17/dossiers17170600000292081706000002920821PA7951202026-01-13False
17060000029231L17/dossiers17170600000292081706000002920822PA2673182026-01-13False
17060000029232L17/dossiers17170600000292081706000002920823PA7200382026-01-13False
17060000029233L17/dossiers17170600000292081706000002920824PA7219842026-01-13False
17060000029234L17/dossiers17170600000292081706000002920825PA7953742026-01-13False
17060000029235L17/dossiers17170600000292081706000002920826PA7947022026-01-13False
17060000029236L17/dossiers17170600000292081706000002920827PA7951002026-01-13False
17060000029237L17/dossiers17170600000292081706000002920828PA7948302026-01-13False
17060000029238L17/dossiers17170600000292081706000002920829PA7211822026-01-13False
17060000029239L17/dossiers17170600000292081706000002920830PA7221622026-01-13False
17060000029240L17/dossiers17170600000292081706000002920831PA7192182026-01-13False
17060000029241L17/dossiers17170600000292081706000002920832PA7947982026-01-13False
17060000029242L17/dossiers17170600000292081706000002920833PA7194722026-01-13False
17060000029243L17/dossiers17170600000292081706000002920834PA7949822026-01-13False
17060000029244L17/dossiers17170600000292081706000002920835PA7221342026-01-13False
17060000029245L17/dossiers17170600000292081706000002920836PA8402352026-01-13False
17060000029246L17/dossiers17170600000292081706000002920837PA7212962026-01-13False
17060000029247L17/dossiers17170600000292081706000002920838PA7959622026-01-13False
17060000029248L17/dossiers17170600000292081706000002920839PA6431842026-01-13False
17060000029249L17/dossiers17170600000292081706000002920840PA7953862026-01-13False
17060000029250L17/dossiers17170600000292081706000002920841PA7204462026-01-13False
17060000029251L17/dossiers17170600000292081706000002920842PA7196322026-01-13False
17060000029252L17/dossiers17170600000292081706000002920843PA7214262026-01-13False
17060000029253L17/dossiers17170600000292081706000002920844PA7222522026-01-13False
17060000029254L17/dossiers17170600000292081706000002920845PA8419272026-01-13False
17060000029255L17/dossiers17170600000292081706000002920846PA7944862026-01-13False
17060000029256L17/dossiers17170600000292081706000002920847PA7221022026-01-13False
17060000029257L17/dossiers17170600000292081706000002920848PA6428682026-01-13False