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
17060000045241L17/dossiers171706000004512317060000045123117PA8415532025-09-17False
17060000045242L17/dossiers171706000004512317060000045123118PA7932982025-09-17False
17060000045243L17/dossiers171706000004512317060000045123119PA8407812025-09-17False
17060000045244L17/dossiers171706000004512317060000045123120PA7949462025-09-17False
17060000045245L17/dossiers171706000004512317060000045123121PA8415752025-09-17False
17060000045246L17/dossiers171706000004512317060000045123122PA8414792025-09-17False
17060000045250L17/dossiers1717060000045248170600000452481PA7934322025-09-17False
17060000045251L17/dossiers1717060000045248170600000452482PA8414952025-09-17False
17060000045252L17/dossiers1717060000045248170600000452483PA7961182025-09-17False
17060000045253L17/dossiers1717060000045248170600000452484PA7945622025-09-17False
17060000045254L17/dossiers1717060000045248170600000452485PA8422792025-09-17False
17060000045255L17/dossiers1717060000045248170600000452486PA7932382025-09-17False
17060000045256L17/dossiers1717060000045248170600000452487PA7933742025-09-17False
17060000045257L17/dossiers1717060000045248170600000452488PA7931582025-09-17False
17060000045258L17/dossiers1717060000045248170600000452489PA7944342025-09-17False
17060000045259L17/dossiers17170600000452481706000004524810PA8416452025-09-17False
17060000045260L17/dossiers17170600000452481706000004524811PA8420012025-09-17False
17060000045261L17/dossiers17170600000452481706000004524812PA7208222025-09-17False
17060000045262L17/dossiers17170600000452481706000004524813PA7206682025-09-17False
17060000045263L17/dossiers17170600000452481706000004524814PA7948862025-09-17False
17060000045264L17/dossiers17170600000452481706000004524815PA7960422025-09-17False
17060000045265L17/dossiers17170600000452481706000004524816PA7938442025-09-17False
17060000045266L17/dossiers17170600000452481706000004524817PA8414872025-09-17False
17060000045267L17/dossiers17170600000452481706000004524818PA8411312025-09-17False
17060000045268L17/dossiers17170600000452481706000004524819PA7931822025-09-17False
17060000045269L17/dossiers17170600000452481706000004524820PA7931342025-09-17False
17060000045270L17/dossiers17170600000452481706000004524821PA8400752025-09-17False
17060000045271L17/dossiers17170600000452481706000004524822PA7204682025-09-17False
17060000045272L17/dossiers17170600000452481706000004524823PA7941982025-09-17False
17060000045273L17/dossiers17170600000452481706000004524824PA7935482025-09-17False
17060000045274L17/dossiers17170600000452481706000004524825PA7956442025-09-17False
17060000045275L17/dossiers17170600000452481706000004524826PA8401192025-09-17False
17060000045276L17/dossiers17170600000452481706000004524827PA7931662025-09-17False
17060000045277L17/dossiers17170600000452481706000004524828PA7939282025-09-17False
17060000045278L17/dossiers17170600000452481706000004524829PA7947622025-09-17False
17060000045279L17/dossiers17170600000452481706000004524830PA7931462025-09-17False
17060000045280L17/dossiers17170600000452481706000004524831PA8401352025-09-17False
17060000045281L17/dossiers17170600000452481706000004524832PA8420732025-09-17False
17060000045282L17/dossiers17170600000452481706000004524833PA8417612025-09-17False
17060000045283L17/dossiers17170600000452481706000004524834PA8416212025-09-17False
17060000045284L17/dossiers17170600000452481706000004524835PA7932462025-09-17False
17060000045285L17/dossiers17170600000452481706000004524836PA8416132025-09-17False
17060000045286L17/dossiers17170600000452481706000004524837PA8401432025-09-17False
17060000045287L17/dossiers17170600000452481706000004524838PA8408012025-09-17False
17060000045288L17/dossiers17170600000452481706000004524839PA7946782025-09-17False
17060000045289L17/dossiers17170600000452481706000004524840PA8411392025-09-17False
17060000045290L17/dossiers17170600000452481706000004524841PA7938922025-09-17False
17060000045291L17/dossiers17170600000452481706000004524842PA8417372025-09-17False
17060000045292L17/dossiers17170600000452481706000004524843PA7960342025-09-17False
17060000045293L17/dossiers17170600000452481706000004524844PA7938322025-09-17False