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
17060000016509L17/dossiers17170600000164801706000001648028PA8420372025-10-28False
17060000016510L17/dossiers17170600000164801706000001648029PA7918122025-10-28False
17060000016511L17/dossiers17170600000164801706000001648030PA7937362025-10-28False
17060000016512L17/dossiers17170600000164801706000001648031PA7212022025-10-28False
17060000016513L17/dossiers17170600000164801706000001648032PA7212102025-10-28False
17060000016514L17/dossiers17170600000164801706000001648033PA7951362025-10-28False
17060000016515L17/dossiers17170600000164801706000001648034PA7934522025-10-28False
17060000016516L17/dossiers17170600000164801706000001648035PA7934642025-10-28False
17060000016517L17/dossiers17170600000164801706000001648036PA8421552025-10-28False
17060000016518L17/dossiers17170600000164801706000001648037PA8416332025-10-28False
17060000016519L17/dossiers17170600000164801706000001648038PA7952002025-10-28False
17060000016520L17/dossiers17170600000164801706000001648039PA7958442025-10-28False
17060000016521L17/dossiers17170600000164801706000001648040PA8421952025-10-28False
17060000016522L17/dossiers17170600000164801706000001648041PA8412512025-10-28False
17060000016523L17/dossiers17170600000164801706000001648042PA7947862025-10-28False
17060000016524L17/dossiers17170600000164801706000001648043PA7948702025-10-28False
17060000016525L17/dossiers17170600000164801706000001648044PA7960702025-10-28False
17060000016526L17/dossiers17170600000164801706000001648045PA3332852025-10-28False
17060000016527L17/dossiers17170600000164801706000001648046PA7950102025-10-28False
17060000016528L17/dossiers17170600000164801706000001648047PA8414192025-10-28False
17060000016529L17/dossiers17170600000164801706000001648048PA7953102025-10-28False
17060000016530L17/dossiers17170600000164801706000001648049PA7944782025-10-28False
17060000016531L17/dossiers17170600000164801706000001648050PA8419472025-10-28False
17060000016532L17/dossiers17170600000164801706000001648051PA7940822025-10-28False
17060000016533L17/dossiers17170600000164801706000001648052PA8411672024-10-292024-10-31False
17060000016534L17/dossiers17170600000164801706000001648053PA7959982025-10-28False
17060000016535L17/dossiers17170600000164801706000001648054PA7941302025-10-28False
17060000016536L17/dossiers17170600000164801706000001648055PA7208462025-10-28False
17060000016537L17/dossiers17170600000164801706000001648056PA8417292025-10-28False
17060000016538L17/dossiers17170600000164801706000001648057PA7955162025-10-28False
17060000016539L17/dossiers17170600000164801706000001648058PA7956722025-10-28False
17060000016540L17/dossiers17170600000164801706000001648059PA7957462025-10-28False
17060000016541L17/dossiers17170600000164801706000001648060PA7951082025-10-28False
17060000016542L17/dossiers17170600000164801706000001648061PA8415152025-10-28False
17060000016543L17/dossiers17170600000164801706000001648062PA7952982025-10-28False
17060000016544L17/dossiers17170600000164801706000001648063PA7918242025-10-28False
17060000016545L17/dossiers17170600000164801706000001648064PA8420292025-10-28False
17060000016546L17/dossiers17170600000164801706000001648065PA7935322025-10-28False
17060000016547L17/dossiers17170600000164801706000001648066PA3423842025-10-28False
17060000016548L17/dossiers17170600000164801706000001648067PA7954222025-10-28False
17060000016549L17/dossiers17170600000164801706000001648068PA8422712025-10-28False
17060000016550L17/dossiers17170600000164801706000001648069PA7946862025-10-28False
17060000016551L17/dossiers17170600000164801706000001648070PA8412152025-10-28False
17060000016552L17/dossiers17170600000164801706000001648071PA7954822025-10-28False
17060000016553L17/dossiers17170600000164801706000001648072PA6106542025-10-28False
17060000016554L17/dossiers17170600000164801706000001648073PA8411912025-10-28False
17060000016555L17/dossiers17170600000164801706000001648074PA7219602025-10-28False
17060000016556L17/dossiers17170600000164801706000001648075PA7938722025-10-28False
17060000016557L17/dossiers17170600000164801706000001648076PA7208922025-10-28False
17060000016558L17/dossiers17170600000164801706000001648077PA7212702025-10-28False