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
17060000039812L17/dossiers1717060000039807170600000398074PA7201542025-09-11False
17060000039813L17/dossiers1717060000039807170600000398075PA6088262025-09-11False
17060000039814L17/dossiers1717060000039807170600000398076PA6056942025-09-11False
17060000039815L17/dossiers1717060000039807170600000398077PA7221342025-09-11False
17060000039816L17/dossiers1717060000039807170600000398078PA8402352025-09-11False
17060000039817L17/dossiers1717060000039807170600000398079PA7223662025-09-11False
17060000039818L17/dossiers17170600000398071706000003980710PA7212962025-09-11False
17060000039819L17/dossiers17170600000398071706000003980711PA8417092025-09-11False
17060000039820L17/dossiers17170600000398071706000003980712PA7203542025-09-11False
17060000039821L17/dossiers17170600000398071706000003980713PA8421172025-09-11False
17060000039822L17/dossiers17170600000398071706000003980714PA7200382025-09-11False
17060000039823L17/dossiers17170600000398071706000003980715PA7194122025-09-11False
17060000039824L17/dossiers17170600000398071706000003980716PA3457222025-09-11False
17060000039825L17/dossiers17170600000398071706000003980717PA7120142025-09-11False
17060000039826L17/dossiers17170600000398071706000003980718PA7947022025-09-11False
17060000039827L17/dossiers17170600000398071706000003980719PA7190802025-09-11False
17060000039828L17/dossiers17170600000398071706000003980720PA7959622025-09-11False
17060000039829L17/dossiers17170600000398071706000003980721PA7196322025-09-11False
17060000039830L17/dossiers17170600000398071706000003980722PA7219162025-09-11False
17060000039831L17/dossiers17170600000398071706000003980723PA7205522025-09-11False
17060000039832L17/dossiers17170600000398071706000003980724PA7214262025-09-11False
17060000039833L17/dossiers17170600000398071706000003980725PA7200662025-09-11False
17060000039834L17/dossiers17170600000398071706000003980726PA8419272025-09-11False
17060000039835L17/dossiers17170600000398071706000003980727PA7948022025-09-11False
17060000039836L17/dossiers17170600000398071706000003980728PA7944862025-09-11False
17060000039837L17/dossiers17170600000398071706000003980729PA7195502025-09-11False
17060000039838L17/dossiers17170600000398071706000003980730PA7223362025-09-11False
17060000039839L17/dossiers17170600000398071706000003980731PA7953502025-09-11False
17060000039840L17/dossiers17170600000398071706000003980732PA7221022025-09-11False
17060000039841L17/dossiers17170600000398071706000003980733PA7195122025-09-11False
17060000039878L17/dossiers1717060000039876170600000398761PA7961062025-09-12False
17060000039879L17/dossiers1717060000039876170600000398762PA7947102025-09-12False
17060000039880L17/dossiers1717060000039876170600000398763PA7958682025-09-12False
17060000039881L17/dossiers1717060000039876170600000398764PA7218962025-09-12False
17060000039882L17/dossiers1717060000039876170600000398765PA7749622025-09-12False
17060000039883L17/dossiers1717060000039876170600000398766PA3356122025-09-12False
17060000039884L17/dossiers1717060000039876170600000398767PA7960102025-09-12False
17060000039885L17/dossiers1717060000039876170600000398768PA7931742025-09-12False
17060000039886L17/dossiers1717060000039876170600000398769PA7958202025-09-12False
17060000039887L17/dossiers17170600000398761706000003987610PA7212702025-09-12False
17060000039888L17/dossiers17170600000398761706000003987611PA6057452025-09-12False
17060000039889L17/dossiers17170600000398761706000003987612PA7934522025-09-12False
17060000039890L17/dossiers17170600000398761706000003987613PA8401712025-09-12False
17060000039891L17/dossiers17170600000398761706000003987614PA7950762025-09-12False
17060000039892L17/dossiers17170600000398761706000003987615PA8412952025-09-12False
17060000039893L17/dossiers17170600000398761706000003987616PA29402025-09-12False
17060000039894L17/dossiers17170600000398761706000003987617PA7212962025-09-12False
17060000039895L17/dossiers17170600000398761706000003987618PA8409032025-09-12False
17060000039896L17/dossiers17170600000398761706000003987619PA8414192025-09-12False
17060000039897L17/dossiers17170600000398761706000003987620PA8416332025-09-12False