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 151 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
17060000014340L17/dossiers171706000001422517060000014225114PA8423112024-12-032025-01-14False
17060000014341L17/dossiers171706000001422517060000014225115PA7199222024-12-032025-01-14False
17060000014342L17/dossiers171706000001422517060000014225116PA7939402024-12-032025-01-14False
17060000014343L17/dossiers171706000001422517060000014225117PA7194722024-12-032025-01-14False
17060000014344L17/dossiers171706000001422517060000014225118PA7958642024-12-032025-01-14False
17060000014345L17/dossiers171706000001422517060000014225119PA7959082024-12-032025-01-14False
17060000014346L17/dossiers171706000001422517060000014225120PA7191182024-12-032025-01-14False
17060000014347L17/dossiers171706000001422517060000014225121PA6078462024-12-032025-01-14False
17060000014348L17/dossiers171706000001422517060000014225122PA8407132024-12-032025-01-14False
17060000014349L17/dossiers171706000001422517060000014225123PA7949822024-12-032025-01-14False
17060000014350L17/dossiers171706000001422517060000014225124PA7223822024-12-032025-01-14False
17060000014351L17/dossiers171706000001422517060000014225125PA7201542024-12-032025-01-14False
17060000014352L17/dossiers171706000001422517060000014225126PA6431752024-10-222024-12-03False
17060000014353L17/dossiers171706000001422517060000014225127PA7946582024-12-032025-01-14False
17060000014354L17/dossiers171706000001422517060000014225128PA7221342024-12-032025-01-14False
17060000014355L17/dossiers171706000001422517060000014225129PA7958842024-10-222024-12-03False
17060000014356L17/dossiers171706000001422517060000014225130PA8402352024-12-032025-01-14False
17060000014357L17/dossiers171706000001422517060000014225131PA7223662024-12-032025-01-14False
17060000014358L17/dossiers171706000001422517060000014225132PA7223582024-12-032025-01-14False
17060000014359L17/dossiers171706000001422517060000014225133PA7212962024-12-032025-01-14False
17060000014360L17/dossiers171706000001422517060000014225134PA7217642024-12-032025-01-14False
17060000014361L17/dossiers171706000001422517060000014225135PA7210242024-10-222024-12-03False
17060000014362L17/dossiers171706000001422517060000014225136PA8417092024-12-032025-01-14False
17060000014363L17/dossiers171706000001422517060000014225137PA2672002024-12-032025-01-14False
17060000014364L17/dossiers171706000001422517060000014225138PA7186742024-10-222024-12-03False
17060000014365L17/dossiers171706000001422517060000014225139PA7203542024-12-032025-01-14False
17060000014366L17/dossiers171706000001422517060000014225140PA6431842024-12-032025-01-14False
17060000014367L17/dossiers171706000001422517060000014225141PA7197982024-12-032025-01-14False
17060000014368L17/dossiers171706000001422517060000014225142PA7959582024-10-222024-12-03False
17060000014369L17/dossiers171706000001422517060000014225143PA7210042024-12-032025-01-14False
17060000014370L17/dossiers171706000001422517060000014225144PA7200222024-12-032025-01-14False
17060000014371L17/dossiers171706000001422517060000014225145PA7193722024-10-222024-12-03False
17060000014372L17/dossiers171706000001422517060000014225146PA7194122024-12-032025-01-14False
17060000014373L17/dossiers171706000001422517060000014225147PA3457222024-12-032025-01-14False
17060000014374L17/dossiers171706000001422517060000014225148PA7193882024-12-032025-01-14False
17060000014375L17/dossiers171706000001422517060000014225149PA7197562024-12-032025-01-14False
17060000014376L17/dossiers171706000001422517060000014225150PA7203422024-12-032025-01-14False
17060000014377L17/dossiers171706000001422517060000014225151PA7218522024-12-032025-01-14False
17060000014378L17/dossiers171706000001422517060000014225152PA7953862024-12-032025-01-14False
17060000014379L17/dossiers171706000001422517060000014225153PA7211342024-12-032025-01-14False
17060000014380L17/dossiers171706000001422517060000014225154PA8416012024-12-032025-01-14False
17060000014381L17/dossiers171706000001422517060000014225155PA7204462024-12-032025-01-14False
17060000014382L17/dossiers171706000001422517060000014225156PA7173792024-12-032025-01-14False
17060000014383L17/dossiers171706000001422517060000014225157PA7957302024-12-032025-01-14False
17060000014384L17/dossiers171706000001422517060000014225158PA7942062024-12-032025-01-14False
17060000014385L17/dossiers171706000001422517060000014225159PA7190802024-12-032025-01-14False
17060000014386L17/dossiers171706000001422517060000014225160PA7201462024-12-032025-01-14False
17060000014387L17/dossiers171706000001422517060000014225161PA6774832024-12-032025-01-14False
17060000014388L17/dossiers171706000001422517060000014225162PA7203702024-12-032025-01-14False
17060000014389L17/dossiers171706000001422517060000014225163PA7951762024-12-032025-01-14False