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
17060000022529L17/dossiers1717060000022527170600000225271PA8414392025-01-07False
17060000022530L17/dossiers1717060000022527170600000225272PA8422272025-01-07False
17060000022531L17/dossiers1717060000022527170600000225273PA7206682025-01-07False
17060000022532L17/dossiers1717060000022527170600000225274PA7954102025-01-07False
17060000022533L17/dossiers1717060000022527170600000225275PA8415872025-01-07False
17060000022534L17/dossiers1717060000022527170600000225276PA7959662025-01-07False
17060000022535L17/dossiers1717060000022527170600000225277PA7931662025-01-07False
17060000022536L17/dossiers1717060000022527170600000225278PA7957862025-01-07False
17060000022537L17/dossiers1717060000022527170600000225279PA7948942025-01-07False
17060000022538L17/dossiers17170600000225271706000002252710PA8409672025-01-07False
17060000022539L17/dossiers17170600000225271706000002252711PA7947342025-01-07False
17060000022540L17/dossiers17170600000225271706000002252712PA8416132025-01-07False
17060000022541L17/dossiers17170600000225271706000002252713PA7933142025-01-07False
17060000022542L17/dossiers17170600000225271706000002252714PA8407812025-01-07False
17060000022543L17/dossiers17170600000225271706000002252715PA7933542025-01-07False
17060000022544L17/dossiers17170600000225271706000002252716PA7935482025-01-07False
17060000022545L17/dossiers17170600000225271706000002252717PA8418732025-01-07False
17060000022546L17/dossiers17170600000225271706000002252718PA8401352025-01-07False
17060000022547L17/dossiers17170600000225271706000002252719PA8420732025-01-07False
17060000022548L17/dossiers17170600000225271706000002252720PA8407572025-01-07False
17060000022549L17/dossiers17170600000225271706000002252721PA7932182025-01-07False
17060000022550L17/dossiers17170600000225271706000002252722PA7960262025-01-07False
17060000022551L17/dossiers17170600000225271706000002252723PA7936082025-01-07False
17060000022552L17/dossiers17170600000225271706000002252724PA8420852025-01-07False
17060000022553L17/dossiers17170600000225271706000002252725PA7932542025-01-07False
17060000022554L17/dossiers17170600000225271706000002252726PA7940302025-01-07False
17060000022555L17/dossiers17170600000225271706000002252727PA7936562025-01-07False
17060000022556L17/dossiers17170600000225271706000002252728PA7931582025-01-07False
17060000022557L17/dossiers17170600000225271706000002252729PA8420972025-01-07False
17060000022558L17/dossiers17170600000225271706000002252730PA7944342025-01-07False
17060000022559L17/dossiers17170600000225271706000002252731PA7933822025-01-07False
17060000022560L17/dossiers17170600000225271706000002252732PA8411392025-01-07False
17060000022561L17/dossiers17170600000225271706000002252733PA8418252025-01-07False
17060000022562L17/dossiers17170600000225271706000002252734PA7947702025-01-07False
17060000022563L17/dossiers17170600000225271706000002252735PA7932302025-01-07False
17060000022564L17/dossiers17170600000225271706000002252736PA7932902025-01-07False
17060000022565L17/dossiers17170600000225271706000002252737PA7955522025-01-07False
17060000022566L17/dossiers17170600000225271706000002252738PA6429882025-01-07False
17060000022567L17/dossiers17170600000225271706000002252739PA7959002025-01-07False
17060000022568L17/dossiers17170600000225271706000002252740PA7936322025-01-07False
17060000022569L17/dossiers17170600000225271706000002252741PA7959122025-01-07False
17060000022570L17/dossiers17170600000225271706000002252742PA7194362025-01-07False
17060000022571L17/dossiers17170600000225271706000002252743PA7960342025-01-07False
17060000022572L17/dossiers17170600000225271706000002252744PA7949542025-01-07False
17060000022573L17/dossiers17170600000225271706000002252745PA7956442025-01-07False
17060000022574L17/dossiers17170600000225271706000002252746PA7944422025-01-07False
17060000022575L17/dossiers17170600000225271706000002252747PA7938922025-01-07False
17060000022576L17/dossiers17170600000225271706000002252748PA7932462025-01-07False
17060000022577L17/dossiers17170600000225271706000002252749PA8414512025-01-07False
17060000022578L17/dossiers17170600000225271706000002252750PA7945302025-01-07False