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
17060000034657L17/dossiers17170600000346151706000003461541PA7214262025-06-04False
17060000034658L17/dossiers17170600000346151706000003461542PA3421962025-06-04False
17060000034659L17/dossiers17170600000346151706000003461543PA8417172025-06-04False
17060000034660L17/dossiers17170600000346151706000003461544PA7749602025-06-04False
17060000034661L17/dossiers17170600000346151706000003461545PA7938162025-06-04False
17060000034662L17/dossiers17170600000346151706000003461546PA7199302025-06-04False
17060000034663L17/dossiers17170600000346151706000003461547PA7214742025-06-04False
17060000034664L17/dossiers17170600000346151706000003461548PA8416812025-06-04False
17060000034665L17/dossiers17170600000346151706000003461549PA7218442025-06-04False
17060000034666L17/dossiers17170600000346151706000003461550PA7947022025-06-04False
17060000034667L17/dossiers17170600000346151706000003461551PA7207202025-06-04False
17060000034668L17/dossiers17170600000346151706000003461552PA7935202025-06-04False
17060000034669L17/dossiers17170600000346151706000003461553PA7200922025-06-04False
17060000034670L17/dossiers17170600000346151706000003461554PA7953742025-06-04False
17060000034671L17/dossiers17170600000346151706000003461555PA7222842025-06-04False
17060000034672L17/dossiers17170600000346151706000003461556PA7951002025-06-04False
17060000034673L17/dossiers17170600000346151706000003461557PA7190242025-06-04False
17060000034674L17/dossiers17170600000346151706000003461558PA7223742025-06-04False
17060000034675L17/dossiers17170600000346151706000003461559PA7219842025-06-04False
17060000034676L17/dossiers17170600000346151706000003461560PA3315822025-06-04False
17060000034677L17/dossiers17170600000346151706000003461561PA7196402025-06-04False
17060000034678L17/dossiers17170600000346151706000003461562PA8051662025-06-04False
17060000034679L17/dossiers17170600000346151706000003461563PA3403432025-06-04False
17060000034680L17/dossiers17170600000346151706000003461564PA7949382025-06-04False
17060000034681L17/dossiers17170600000346151706000003461565PA7202302025-06-04False
17060000034682L17/dossiers17170600000346151706000003461566PA2672002025-06-04False
17060000034683L17/dossiers17170600000346151706000003461567PA8416652025-06-04False
17060000034684L17/dossiers17170600000346151706000003461568PA7202562025-06-04False
17060000034685L17/dossiers17170600000346151706000003461569PA7220002025-06-04False
17060000034686L17/dossiers17170600000346151706000003461570PA7199222025-06-04False
17060000034687L17/dossiers17170600000346151706000003461571PA7193382025-06-04False
17060000034688L17/dossiers17170600000346151706000003461572PA7223902025-06-04False
17060000034689L17/dossiers17170600000346151706000003461573PA7214582025-06-04False
17060000034690L17/dossiers17170600000346151706000003461574PA7956642025-06-04False
17060000034691L17/dossiers17170600000346151706000003461575PA7200222025-06-04False
17060000034692L17/dossiers17170600000346151706000003461576PA6955122025-06-04False
17060000034693L17/dossiers17170600000346151706000003461577PA3096432025-06-04False
17060000034694L17/dossiers17170600000346151706000003461578PA7948022025-06-04False
17060000034695L17/dossiers17170600000346151706000003461579PA8412152025-06-04False
17060000034696L17/dossiers17170600000346151706000003461580PA7955162025-06-04False
17060000034697L17/dossiers17170600000346151706000003461581PA7949822025-06-04False
17060000034698L17/dossiers17170600000346151706000003461582PA6065072025-06-04False
17060000034699L17/dossiers17170600000346151706000003461583PA8412432025-06-04False
17060000034700L17/dossiers17170600000346151706000003461584PA7952782025-06-04False
17060000034704L17/dossiers1717060000034702170600000347021PA8410672025-04-24False
17060000034705L17/dossiers1717060000034702170600000347022PA8407012025-04-24False
17060000034706L17/dossiers1717060000034702170600000347023PA8417692025-04-24False
17060000034707L17/dossiers1717060000034702170600000347024PA7947622025-04-24False
17060000034708L17/dossiers1717060000034702170600000347025PA7947702025-04-24False
17060000034712L17/dossiers1717060000034710170600000347101PA7208922025-04-17False