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
17060000026881L17/dossiers171706000002668517060000026685195PA7939482025-03-31False
17060000026882L17/dossiers171706000002668517060000026685196PA7953102025-03-31False
17060000026883L17/dossiers171706000002668517060000026685197PA8421952025-03-31False
17060000026884L17/dossiers171706000002668517060000026685198PA7944782025-03-31False
17060000026885L17/dossiers171706000002668517060000026685199PA6093322025-03-31False
17060000026886L17/dossiers171706000002668517060000026685200PA8419472025-03-31False
17060000026887L17/dossiers171706000002668517060000026685201PA8416652025-03-31False
17060000026888L17/dossiers171706000002668517060000026685202PA7941302025-03-31False
17060000026889L17/dossiers171706000002668517060000026685203PA8409392025-03-31False
17060000026890L17/dossiers171706000002668517060000026685204PA7208462025-03-31False
17060000026891L17/dossiers171706000002668517060000026685205PA8401712025-03-31False
17060000026892L17/dossiers171706000002668517060000026685206PA8417292025-03-31False
17060000026893L17/dossiers171706000002668517060000026685207PA8414712025-03-31False
17060000026894L17/dossiers171706000002668517060000026685208PA7955162025-03-31False
17060000026895L17/dossiers171706000002668517060000026685209PA8418132025-03-31False
17060000026896L17/dossiers171706000002668517060000026685210PA7956722025-03-31False
17060000026897L17/dossiers171706000002668517060000026685211PA8418532025-03-31False
17060000026898L17/dossiers171706000002668517060000026685212PA8415152025-03-31False
17060000026899L17/dossiers171706000002668517060000026685213PA16542025-03-31False
17060000026900L17/dossiers171706000002668517060000026685214PA7957462025-03-31False
17060000026901L17/dossiers171706000002668517060000026685215PA7951562025-03-31False
17060000026902L17/dossiers171706000002668517060000026685216PA7952982025-03-31False
17060000026903L17/dossiers171706000002668517060000026685217PA8407652025-03-31False
17060000026904L17/dossiers171706000002668517060000026685218PA7918242025-03-31False
17060000026905L17/dossiers171706000002668517060000026685219PA8414632025-03-31False
17060000026906L17/dossiers171706000002668517060000026685220PA8420292025-03-31False
17060000026907L17/dossiers171706000002668517060000026685221PA6431572025-03-31False
17060000026908L17/dossiers171706000002668517060000026685222PA3423842025-03-31False
17060000026909L17/dossiers171706000002668517060000026685223PA8411072025-03-31False
17060000026910L17/dossiers171706000002668517060000026685224PA7946862025-03-31False
17060000026911L17/dossiers171706000002668517060000026685225PA8413812025-03-31False
17060000026912L17/dossiers171706000002668517060000026685226PA8412152025-03-31False
17060000026913L17/dossiers171706000002668517060000026685227PA8407932025-03-31False
17060000026914L17/dossiers171706000002668517060000026685228PA7954822025-03-31False
17060000026915L17/dossiers171706000002668517060000026685229PA7942702025-03-31False
17060000026916L17/dossiers171706000002668517060000026685230PA6106542025-03-31False
17060000026917L17/dossiers171706000002668517060000026685231PA6075532025-03-31False
17060000026918L17/dossiers171706000002668517060000026685232PA8411912025-03-31False
17060000026919L17/dossiers171706000002668517060000026685233PA8413672025-03-31False
17060000026920L17/dossiers171706000002668517060000026685234PA7219602025-03-31False
17060000026921L17/dossiers171706000002668517060000026685235PA3419812025-03-31False
17060000026922L17/dossiers171706000002668517060000026685236PA7938722025-03-31False
17060000026923L17/dossiers171706000002668517060000026685237PA3421962025-03-31False
17060000026924L17/dossiers171706000002668517060000026685238PA7208922025-03-31False
17060000026925L17/dossiers171706000002668517060000026685239PA8172112025-03-31False
17060000026926L17/dossiers171706000002668517060000026685240PA8417172025-03-31False
17060000026927L17/dossiers171706000002668517060000026685241PA7937562025-03-31False
17060000026928L17/dossiers171706000002668517060000026685242PA8412432025-03-31False
17060000026929L17/dossiers171706000002668517060000026685243PA7960622025-03-31False
17060000026930L17/dossiers171706000002668517060000026685244PA7749602025-03-31False