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
17060000035808L17/dossiers17170600000357511706000003575156PA7193882025-05-20False
17060000035809L17/dossiers17170600000357511706000003575157PA7197562025-05-20False
17060000035810L17/dossiers17170600000357511706000003575158PA7218522025-05-20False
17060000035811L17/dossiers17170600000357511706000003575159PA7120142025-05-20False
17060000035812L17/dossiers17170600000357511706000003575160PA7953862025-05-20False
17060000035813L17/dossiers17170600000357511706000003575161PA7211342025-05-20False
17060000035814L17/dossiers17170600000357511706000003575162PA8416012025-05-20False
17060000035815L17/dossiers17170600000357511706000003575163PA7204462025-05-20False
17060000035816L17/dossiers17170600000357511706000003575164PA7173792025-05-20False
17060000035817L17/dossiers17170600000357511706000003575165PA7957302025-05-20False
17060000035818L17/dossiers17170600000357511706000003575166PA7942062025-05-20False
17060000035819L17/dossiers17170600000357511706000003575167PA7190802025-05-20False
17060000035820L17/dossiers17170600000357511706000003575168PA7201462025-05-20False
17060000035821L17/dossiers17170600000357511706000003575169PA6774832025-05-20False
17060000035822L17/dossiers17170600000357511706000003575170PA7193382025-05-20False
17060000035823L17/dossiers17170600000357511706000003575171PA7203702025-05-20False
17060000035824L17/dossiers17170600000357511706000003575172PA7951762025-05-20False
17060000035825L17/dossiers17170600000357511706000003575173PA7956642025-05-20False
17060000035826L17/dossiers17170600000357511706000003575174PA8172032025-05-20False
17060000035827L17/dossiers17170600000357511706000003575175PA7959622025-05-20False
17060000035828L17/dossiers17170600000357511706000003575176PA7957222025-05-20False
17060000035829L17/dossiers17170600000357511706000003575177PA7196322025-05-20False
17060000035830L17/dossiers17170600000357511706000003575178PA7219162025-05-20False
17060000035831L17/dossiers17170600000357511706000003575179PA3357582025-05-20False
17060000035832L17/dossiers17170600000357511706000003575180PA7214262025-05-20False
17060000035833L17/dossiers17170600000357511706000003575181PA7200662025-05-20False
17060000035834L17/dossiers17170600000357511706000003575182PA7955282025-05-20False
17060000035835L17/dossiers17170600000357511706000003575183PA8419272025-05-20False
17060000035836L17/dossiers17170600000357511706000003575184PA7958882025-05-20False
17060000035837L17/dossiers17170600000357511706000003575185PA7932702025-05-20False
17060000035838L17/dossiers17170600000357511706000003575186PA7572252025-05-20False
17060000035839L17/dossiers17170600000357511706000003575187PA7934162025-05-20False
17060000035840L17/dossiers17170600000357511706000003575188PA7201902025-05-20False
17060000035841L17/dossiers17170600000357511706000003575189PA7195502025-05-20False
17060000035842L17/dossiers17170600000357511706000003575190PA7215842025-05-20False
17060000035843L17/dossiers17170600000357511706000003575191PA6073952025-05-20False
17060000035844L17/dossiers17170600000357511706000003575192PA7211702025-05-20False
17060000035845L17/dossiers17170600000357511706000003575193PA7950462025-05-20False
17060000035849L17/dossiers1717060000035847170600000358471PA8406652025-05-19False
17060000035850L17/dossiers1717060000035847170600000358472PA6427642025-05-19False
17060000035851L17/dossiers1717060000035847170600000358473PA8408292025-05-19False
17060000035852L17/dossiers1717060000035847170600000358474PA8422112025-05-19False
17060000035853L17/dossiers1717060000035847170600000358475PA8413152025-05-19False
17060000035854L17/dossiers1717060000035847170600000358476PA6082642025-05-19False
17060000035855L17/dossiers1717060000035847170600000358477PA8412952025-05-19False
17060000035856L17/dossiers1717060000035847170600000358478PA10082025-05-19False
17060000035857L17/dossiers1717060000035847170600000358479PA7933942025-05-19False
17060000035858L17/dossiers17170600000358471706000003584710PA8416332025-05-19False
17060000035859L17/dossiers17170600000358471706000003584711PA7948542025-05-19False
17060000035860L17/dossiers17170600000358471706000003584712PA8421952025-05-19False