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
17060000029682L17/dossiers17170600000296041706000002960477PA7950102025-03-27False
17060000029683L17/dossiers17170600000296041706000002960478PA7749622025-03-27False
17060000029684L17/dossiers17170600000296041706000002960479PA7941542025-03-27False
17060000029685L17/dossiers17170600000296041706000002960480PA8417132025-03-27False
17060000029686L17/dossiers17170600000296041706000002960481PA8414712025-03-27False
17060000029687L17/dossiers17170600000296041706000002960482PA8422632025-03-27False
17060000029691L17/dossiers1717060000029689170600000296891PA7212342025-07-01False
17060000029692L17/dossiers1717060000029689170600000296892PA7950262025-07-01False
17060000029693L17/dossiers1717060000029689170600000296893PA8413592025-07-01False
17060000029694L17/dossiers1717060000029689170600000296894PA7200382025-07-01False
17060000029695L17/dossiers1717060000029689170600000296895PA7208922025-07-01False
17060000029696L17/dossiers1717060000029689170600000296896PA7950762025-07-01False
17060000029697L17/dossiers1717060000029689170600000296897PA7937362025-07-01False
17060000029698L17/dossiers1717060000029689170600000296898PA7936242025-07-01False
17060000029699L17/dossiers1717060000029689170600000296899PA7749622025-07-01False
17060000029700L17/dossiers17170600000296891706000002968910PA6082642025-07-01False
17060000029701L17/dossiers17170600000296891706000002968911PA7950102025-07-01False
17060000029702L17/dossiers17170600000296891706000002968912PA7952402025-07-01False
17060000029703L17/dossiers17170600000296891706000002968913PA8422632025-07-01False
17060000029704L17/dossiers17170600000296891706000002968914PA7937082025-07-01False
17060000029705L17/dossiers17170600000296891706000002968915PA8418932025-07-01False
17060000029706L17/dossiers17170600000296891706000002968916PA7936642025-07-01False
17060000029707L17/dossiers17170600000296891706000002968917PA8414712025-07-01False
17060000029708L17/dossiers17170600000296891706000002968918PA7941542025-07-01False
17060000029709L17/dossiers17170600000296891706000002968919PA3424152025-07-01False
17060000029710L17/dossiers17170600000296891706000002968920PA8417132025-07-01False
17060000029711L17/dossiers17170600000296891706000002968921PA8416652025-07-01False
17060000029712L17/dossiers17170600000296891706000002968922PA7941462025-07-01False
17060000029713L17/dossiers17170600000296891706000002968923PA7940942025-07-01False
17060000029714L17/dossiers17170600000296891706000002968924PA8418132025-07-01False
17060000029715L17/dossiers17170600000296891706000002968925PA7203622025-07-01False
17060000029716L17/dossiers17170600000296891706000002968926PA7952282025-07-01False
17060000029717L17/dossiers17170600000296891706000002968927PA7932622025-07-01False
17060000029718L17/dossiers17170600000296891706000002968928PA7949062025-07-01False
17060000029719L17/dossiers17170600000296891706000002968929PA7941382025-07-01False
17060000029720L17/dossiers17170600000296891706000002968930PA7955882025-07-01False
17060000029721L17/dossiers17170600000296891706000002968931PA7950842025-07-01False
17060000029722L17/dossiers17170600000296891706000002968932PA8421052025-07-01False
17060000029723L17/dossiers17170600000296891706000002968933PA8416572025-07-01False
17060000029724L17/dossiers17170600000296891706000002968934PA7204302025-07-01False
17060000029725L17/dossiers17170600000296891706000002968935PA7937722025-07-01False
17060000029726L17/dossiers17170600000296891706000002968936PA7956162025-07-01False
17060000029727L17/dossiers17170600000296891706000002968937PA7934442025-07-01False
17060000029728L17/dossiers17170600000296891706000002968938PA7949382025-07-01False
17060000029729L17/dossiers17170600000296891706000002968939PA7953182025-07-01False
17060000029730L17/dossiers17170600000296891706000002968940PA8410232025-07-01False
17060000029731L17/dossiers17170600000296891706000002968941PA7960902025-07-01False
17060000029732L17/dossiers17170600000296891706000002968942PA7939122025-07-01False
17060000029733L17/dossiers17170600000296891706000002968943PA8421872025-07-01False
17060000029734L17/dossiers17170600000296891706000002968944PA8420372025-07-01False