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
17060000020326L17/dossiers1717060000020321170600000203214PA7200382024-12-16False
17060000020327L17/dossiers1717060000020321170600000203215PA7217642024-12-16False
17060000020328L17/dossiers1717060000020321170600000203216PA7212962024-12-16False
17060000020329L17/dossiers1717060000020321170600000203217PA6088262024-12-16False
17060000020330L17/dossiers1717060000020321170600000203218PA7173792024-12-16False
17060000020331L17/dossiers1717060000020321170600000203219PA8423112024-12-16False
17060000020332L17/dossiers17170600000203211706000002032110PA8051662024-12-16False
17060000020333L17/dossiers17170600000203211706000002032111PA3096432024-12-16False
17060000020334L17/dossiers17170600000203211706000002032112PA7190242024-12-16False
17060000020335L17/dossiers17170600000203211706000002032113PA6426952024-12-16False
17060000020336L17/dossiers17170600000203211706000002032114PA7218162024-12-16False
17060000020337L17/dossiers17170600000203211706000002032115PA7943302024-12-16False
17060000020338L17/dossiers17170600000203211706000002032116PA7220002024-12-16False
17060000020339L17/dossiers17170600000203211706000002032117PA8418012024-12-16False
17060000020340L17/dossiers17170600000203211706000002032118PA7194722024-12-16False
17060000020341L17/dossiers17170600000203211706000002032119PA7958642024-12-16False
17060000020342L17/dossiers17170600000203211706000002032120PA8414312024-12-16False
17060000020343L17/dossiers17170600000203211706000002032121PA7935202024-12-16False
17060000020344L17/dossiers17170600000203211706000002032122PA7937162024-12-16False
17060000020345L17/dossiers17170600000203211706000002032123PA8407132024-12-16False
17060000020346L17/dossiers17170600000203211706000002032124PA7946582024-12-16False
17060000020347L17/dossiers17170600000203211706000002032125PA7939402024-12-16False
17060000020348L17/dossiers17170600000203211706000002032126PA7221342024-12-16False
17060000020349L17/dossiers17170600000203211706000002032127PA8402352024-12-16False
17060000020350L17/dossiers17170600000203211706000002032128PA7223662024-12-16False
17060000020351L17/dossiers17170600000203211706000002032129PA7942342024-12-16False
17060000020352L17/dossiers17170600000203211706000002032130PA8418332024-12-16False
17060000020353L17/dossiers17170600000203211706000002032131PA7220702024-12-16False
17060000020354L17/dossiers17170600000203211706000002032132PA2672002024-12-16False
17060000020355L17/dossiers17170600000203211706000002032133PA7203542024-12-16False
17060000020356L17/dossiers17170600000203211706000002032134PA8421172024-12-16False
17060000020357L17/dossiers17170600000203211706000002032135PA7190522024-12-16False
17060000020358L17/dossiers17170600000203211706000002032136PA6431842024-12-16False
17060000020359L17/dossiers17170600000203211706000002032137PA7210042024-12-16False
17060000020360L17/dossiers17170600000203211706000002032138PA8416932024-12-16False
17060000020361L17/dossiers17170600000203211706000002032139PA7200222024-12-16False
17060000020362L17/dossiers17170600000203211706000002032140PA7194122024-12-16False
17060000020363L17/dossiers17170600000203211706000002032141PA7194042024-12-16False
17060000020364L17/dossiers17170600000203211706000002032142PA3457222024-12-16False
17060000020365L17/dossiers17170600000203211706000002032143PA7197562024-12-16False
17060000020366L17/dossiers17170600000203211706000002032144PA7203422024-12-16False
17060000020367L17/dossiers17170600000203211706000002032145PA7953862024-12-16False
17060000020368L17/dossiers17170600000203211706000002032146PA8416012024-12-16False
17060000020369L17/dossiers17170600000203211706000002032147PA7947022024-12-16False
17060000020370L17/dossiers17170600000203211706000002032148PA7204462024-12-16False
17060000020371L17/dossiers17170600000203211706000002032149PA7202302024-12-16False
17060000020372L17/dossiers17170600000203211706000002032150PA7957302024-12-16False
17060000020373L17/dossiers17170600000203211706000002032151PA7942062024-12-16False
17060000020374L17/dossiers17170600000203211706000002032152PA7933422024-12-16False
17060000020375L17/dossiers17170600000203211706000002032153PA7201462024-12-16False