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
17060000042847L17/dossiers17170600000428211706000004282125PA8421552025-07-11False
17060000042848L17/dossiers17170600000428211706000004282126PA7952002025-07-11False
17060000042849L17/dossiers17170600000428211706000004282127PA7958442025-07-11False
17060000042850L17/dossiers17170600000428211706000004282128PA8412512025-07-11False
17060000042851L17/dossiers17170600000428211706000004282129PA7947862025-07-11False
17060000042852L17/dossiers17170600000428211706000004282130PA7948702025-07-11False
17060000042853L17/dossiers17170600000428211706000004282131PA7960702025-07-11False
17060000042854L17/dossiers17170600000428211706000004282132PA7953102025-07-11False
17060000042855L17/dossiers17170600000428211706000004282133PA7944782025-07-11False
17060000042856L17/dossiers17170600000428211706000004282134PA8419472025-07-11False
17060000042857L17/dossiers17170600000428211706000004282135PA7940822025-07-11False
17060000042858L17/dossiers17170600000428211706000004282136PA7941302025-07-11False
17060000042859L17/dossiers17170600000428211706000004282137PA7208462025-07-11False
17060000042860L17/dossiers17170600000428211706000004282138PA8417292025-07-11False
17060000042861L17/dossiers17170600000428211706000004282139PA7955162025-07-11False
17060000042862L17/dossiers17170600000428211706000004282140PA7956722025-07-11False
17060000042863L17/dossiers17170600000428211706000004282141PA7957462025-07-11False
17060000042864L17/dossiers17170600000428211706000004282142PA7951082025-07-11False
17060000042865L17/dossiers17170600000428211706000004282143PA8415152025-07-11False
17060000042866L17/dossiers17170600000428211706000004282144PA7952982025-07-11False
17060000042867L17/dossiers17170600000428211706000004282145PA7918242025-07-11False
17060000042868L17/dossiers17170600000428211706000004282146PA8420292025-07-11False
17060000042869L17/dossiers17170600000428211706000004282147PA7935322025-07-11False
17060000042870L17/dossiers17170600000428211706000004282148PA3423842025-07-11False
17060000042871L17/dossiers17170600000428211706000004282149PA7954222025-07-11False
17060000042872L17/dossiers17170600000428211706000004282150PA7946862025-07-11False
17060000042873L17/dossiers17170600000428211706000004282151PA8412152025-07-11False
17060000042874L17/dossiers17170600000428211706000004282152PA7954822025-07-11False
17060000042875L17/dossiers17170600000428211706000004282153PA6106542025-07-11False
17060000042876L17/dossiers17170600000428211706000004282154PA8411912025-07-11False
17060000042877L17/dossiers17170600000428211706000004282155PA7219602025-07-11False
17060000042878L17/dossiers17170600000428211706000004282156PA7938722025-07-11False
17060000042879L17/dossiers17170600000428211706000004282157PA8172112025-07-11False
17060000042880L17/dossiers17170600000428211706000004282158PA7937562025-07-11False
17060000042881L17/dossiers17170600000428211706000004282159PA7960622025-07-11False
17060000042882L17/dossiers17170600000428211706000004282160PA7195782025-07-11False
17060000042883L17/dossiers17170600000428211706000004282161PA7210622025-07-11False
17060000042884L17/dossiers17170600000428211706000004282162PA8418452025-07-11False
17060000042885L17/dossiers17170600000428211706000004282163PA7959822025-07-11False
17060000042886L17/dossiers17170600000428211706000004282164PA7954662025-07-11False
17060000042887L17/dossiers17170600000428211706000004282165PA7937442025-07-11False
17060000042888L17/dossiers17170600000428211706000004282166PA7209522025-07-11False
17060000042889L17/dossiers17170600000428211706000004282167PA7941062025-07-11False
17060000042890L17/dossiers17170600000428211706000004282168PA7941662025-07-11False
17060000042891L17/dossiers17170600000428211706000004282169PA7951642025-07-11False
17060000042892L17/dossiers17170600000428211706000004282170PA7955962025-07-11False
17060000042896L17/dossiers1717060000042894170600000428941PA7208922025-07-11False
17060000042897L17/dossiers1717060000042894170600000428942PA7952282025-07-11False
17060000042898L17/dossiers1717060000042894170600000428943PA7932622025-07-11False
17060000042899L17/dossiers1717060000042894170600000428944PA7949062025-07-11False