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
17060000023239L17/dossiers1717060000023231170600000232317PA5888842025-02-11False
17060000023240L17/dossiers1717060000023231170600000232318PA8417012025-02-11False
17060000023241L17/dossiers1717060000023231170600000232319PA3359992025-02-11False
17060000023242L17/dossiers17170600000232311706000002323110PA7953622025-02-11False
17060000023243L17/dossiers17170600000232311706000002323111PA8416572025-02-11False
17060000023244L17/dossiers17170600000232311706000002323112PA7954542025-02-11False
17060000023245L17/dossiers17170600000232311706000002323113PA8409972025-02-11False
17060000023246L17/dossiers17170600000232311706000002323114PA8418852025-02-11False
17060000023247L17/dossiers17170600000232311706000002323115PA8415072025-02-11False
17060000023248L17/dossiers17170600000232311706000002323116PA7949382025-02-11False
17060000023249L17/dossiers17170600000232311706000002323117PA8410232025-02-11False
17060000023250L17/dossiers17170600000232311706000002323118PA8421872025-02-11False
17060000023251L17/dossiers17170600000232311706000002323119PA8420372025-02-11False
17060000023252L17/dossiers17170600000232311706000002323120PA7940082025-02-11False
17060000023253L17/dossiers17170600000232311706000002323121PA7918122025-02-11False
17060000023254L17/dossiers17170600000232311706000002323122PA7937362025-02-11False
17060000023255L17/dossiers17170600000232311706000002323123PA7212102025-02-11False
17060000023256L17/dossiers17170600000232311706000002323124PA7934522025-02-11False
17060000023257L17/dossiers17170600000232311706000002323125PA7933942025-02-11False
17060000023258L17/dossiers17170600000232311706000002323126PA8413512025-02-11False
17060000023259L17/dossiers17170600000232311706000002323127PA7947862025-02-11False
17060000023260L17/dossiers17170600000232311706000002323128PA7939802025-02-11False
17060000023261L17/dossiers17170600000232311706000002323129PA7960702025-02-11False
17060000023262L17/dossiers17170600000232311706000002323130PA7950102025-02-11False
17060000023263L17/dossiers17170600000232311706000002323131PA8414192025-02-11False
17060000023264L17/dossiers17170600000232311706000002323132PA7953102025-02-11False
17060000023265L17/dossiers17170600000232311706000002323133PA8420132025-02-11False
17060000023266L17/dossiers17170600000232311706000002323134PA8419472025-02-11False
17060000023267L17/dossiers17170600000232311706000002323135PA8409472025-02-11False
17060000023268L17/dossiers17170600000232311706000002323136PA7940222025-02-11False
17060000023269L17/dossiers17170600000232311706000002323137PA7941462025-02-11False
17060000023270L17/dossiers17170600000232311706000002323138PA8412232025-02-11False
17060000023271L17/dossiers17170600000232311706000002323139PA8417292025-02-11False
17060000023272L17/dossiers17170600000232311706000002323140PA7955162025-02-11False
17060000023273L17/dossiers17170600000232311706000002323141PA7749622025-02-11False
17060000023274L17/dossiers17170600000232311706000002323142PA8415152025-02-11False
17060000023275L17/dossiers17170600000232311706000002323143PA7946862025-02-11False
17060000023276L17/dossiers17170600000232311706000002323144PA8412152025-02-11False
17060000023277L17/dossiers17170600000232311706000002323145PA8411912025-02-11False
17060000023278L17/dossiers17170600000232311706000002323146PA8420452025-02-11False
17060000023279L17/dossiers17170600000232311706000002323147PA7937082025-02-11False
17060000023280L17/dossiers17170600000232311706000002323148PA8172112025-02-11False
17060000023281L17/dossiers17170600000232311706000002323149PA7936642025-02-11False
17060000023282L17/dossiers17170600000232311706000002323150PA7941542025-02-11False
17060000023283L17/dossiers17170600000232311706000002323151PA7947782025-02-11False
17060000023284L17/dossiers17170600000232311706000002323152PA6065452025-02-11False
17060000023285L17/dossiers17170600000232311706000002323153PA7950762025-02-11False
17060000023286L17/dossiers17170600000232311706000002323154PA7221422025-02-11False
17060000023287L17/dossiers17170600000232311706000002323155PA8418452025-02-11False
17060000023288L17/dossiers17170600000232311706000002323156PA6100022025-02-11False