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
17060000007250L17/dossiers17170600000071671706000000716782PA8226172024-10-09False
17060000007251L17/dossiers17170600000071671706000000716783PA7960702024-10-09False
17060000007252L17/dossiers17170600000071671706000000716784PA7950102024-10-09False
17060000007253L17/dossiers17170600000071671706000000716785PA3332852024-10-09False
17060000007254L17/dossiers17170600000071671706000000716786PA6059912024-10-09False
17060000007255L17/dossiers17170600000071671706000000716787PA7942342024-10-09False
17060000007256L17/dossiers17170600000071671706000000716788PA8414192024-10-09False
17060000007257L17/dossiers17170600000071671706000000716789PA8409392024-10-09False
17060000007258L17/dossiers17170600000071671706000000716790PA2667972024-10-09False
17060000007259L17/dossiers17170600000071671706000000716791PA3319732024-10-09False
17060000007260L17/dossiers17170600000071671706000000716792PA7940582024-10-09False
17060000007261L17/dossiers17170600000071671706000000716793PA15672024-10-09False
17060000007262L17/dossiers17170600000071671706000000716794PA7953102024-10-09False
17060000007263L17/dossiers17170600000071671706000000716795PA7944782024-10-09False
17060000007264L17/dossiers17170600000071671706000000716796PA8420132024-10-09False
17060000007265L17/dossiers17170600000071671706000000716797PA8414712024-10-09False
17060000007266L17/dossiers17170600000071671706000000716798PA8422632024-10-09False
17060000007267L17/dossiers17170600000071671706000000716799PA8419472024-10-09False
17060000007268L17/dossiers171706000000716717060000007167100PA8409472024-10-09False
17060000007269L17/dossiers171706000000716717060000007167101PA8418532024-10-09False
17060000007270L17/dossiers171706000000716717060000007167102PA7940822024-10-09False
17060000007271L17/dossiers171706000000716717060000007167103PA7221502024-10-09False
17060000007272L17/dossiers171706000000716717060000007167104PA7940222024-10-09False
17060000007273L17/dossiers171706000000716717060000007167105PA7223742024-10-09False
17060000007274L17/dossiers171706000000716717060000007167106PA7200382024-10-09False
17060000007275L17/dossiers171706000000716717060000007167107PA6431922024-10-09False
17060000007276L17/dossiers171706000000716717060000007167108PA7959982024-10-09False
17060000007277L17/dossiers171706000000716717060000007167109PA3350542024-10-09False
17060000007278L17/dossiers171706000000716717060000007167110PA7951562024-10-09False
17060000007279L17/dossiers171706000000716717060000007167111PA7941302024-10-09False
17060000007280L17/dossiers171706000000716717060000007167112PA7941462024-10-09False
17060000007281L17/dossiers171706000000716717060000007167113PA8412232024-10-09False
17060000007282L17/dossiers171706000000716717060000007167114PA8417292024-10-09False
17060000007283L17/dossiers171706000000716717060000007167115PA7955162024-10-09False
17060000007284L17/dossiers171706000000716717060000007167116PA7956722024-10-09False
17060000007285L17/dossiers171706000000716717060000007167117PA7957462024-10-09False
17060000007286L17/dossiers171706000000716717060000007167118PA7749622024-10-09False
17060000007287L17/dossiers171706000000716717060000007167119PA7951082024-10-09False
17060000007288L17/dossiers171706000000716717060000007167120PA3356122024-10-09False
17060000007289L17/dossiers171706000000716717060000007167121PA8415152024-10-09False
17060000007290L17/dossiers171706000000716717060000007167122PA7918242024-10-09False
17060000007291L17/dossiers171706000000716717060000007167123PA8420292024-10-09False
17060000007292L17/dossiers171706000000716717060000007167124PA7952442024-10-09False
17060000007293L17/dossiers171706000000716717060000007167125PA7935322024-10-09False
17060000007294L17/dossiers171706000000716717060000007167126PA7749582024-10-09False
17060000007295L17/dossiers171706000000716717060000007167127PA8407652024-10-09False
17060000007296L17/dossiers171706000000716717060000007167128PA7204462024-10-09False
17060000007297L17/dossiers171706000000716717060000007167129PA7956362024-10-09False
17060000007298L17/dossiers171706000000716717060000007167130PA6060982024-10-09False
17060000007299L17/dossiers171706000000716717060000007167131PA3423842024-10-09False