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
17060000045344L17/dossiers17170600000452481706000004524895PA7955522025-09-17False
17060000045345L17/dossiers17170600000452481706000004524896PA7946702025-09-17False
17060000045346L17/dossiers17170600000452481706000004524897PA8411992025-09-17False
17060000045347L17/dossiers17170600000452481706000004524898PA7945822025-09-17False
17060000045348L17/dossiers17170600000452481706000004524899PA7936562025-09-17False
17060000045349L17/dossiers171706000004524817060000045248100PA7959662025-09-17False
17060000045350L17/dossiers171706000004524817060000045248101PA7932302025-09-17False
17060000045351L17/dossiers171706000004524817060000045248102PA7932542025-09-17False
17060000045352L17/dossiers171706000004524817060000045248103PA8419552025-09-17False
17060000045353L17/dossiers171706000004524817060000045248104PA8419812025-09-17False
17060000045354L17/dossiers171706000004524817060000045248105PA8422272025-09-17False
17060000045355L17/dossiers171706000004524817060000045248106PA7944422025-09-17False
17060000045356L17/dossiers171706000004524817060000045248107PA7954102025-09-17False
17060000045357L17/dossiers171706000004524817060000045248108PA8420972025-09-17False
17060000045358L17/dossiers171706000004524817060000045248109PA7948942025-09-17False
17060000045359L17/dossiers171706000004524817060000045248110PA7945702025-09-17False
17060000045360L17/dossiers171706000004524817060000045248111PA7949542025-09-17False
17060000045361L17/dossiers171706000004524817060000045248112PA7960502025-09-17False
17060000045362L17/dossiers171706000004524817060000045248113PA8422552025-09-17False
17060000045363L17/dossiers171706000004524817060000045248114PA7933822025-09-17False
17060000045364L17/dossiers171706000004524817060000045248115PA7957782025-09-17False
17060000045365L17/dossiers171706000004524817060000045248116PA7945022025-09-17False
17060000045366L17/dossiers171706000004524817060000045248117PA8415532025-09-17False
17060000045367L17/dossiers171706000004524817060000045248118PA7932982025-09-17False
17060000045368L17/dossiers171706000004524817060000045248119PA8407812025-09-17False
17060000045369L17/dossiers171706000004524817060000045248120PA7949462025-09-17False
17060000045370L17/dossiers171706000004524817060000045248121PA8415752025-09-17False
17060000045371L17/dossiers171706000004524817060000045248122PA8414792025-09-17False
17060000045375L17/dossiers1717060000045373170600000453731PA8401712025-10-01False
17060000045376L17/dossiers1717060000045373170600000453732PA7952402025-10-01False
17060000045377L17/dossiers1717060000045373170600000453733PA7362012025-10-01False
17060000045378L17/dossiers1717060000045373170600000453734PA7212102025-10-01False
17060000045379L17/dossiers1717060000045373170600000453735PA7950762025-10-01False
17060000045380L17/dossiers1717060000045373170600000453736PA3356122025-10-01False
17060000045381L17/dossiers1717060000045373170600000453737PA8413592025-10-01False
17060000045382L17/dossiers1717060000045373170600000453738PA7953622025-10-01False
17060000045383L17/dossiers1717060000045373170600000453739PA7941542025-10-01False
17060000045384L17/dossiers17170600000453731706000004537310PA7958762025-10-01False
17060000045385L17/dossiers17170600000453731706000004537311PA6431572025-10-01False
17060000045386L17/dossiers17170600000453731706000004537312PA8414192025-10-01False
17060000045387L17/dossiers17170600000453731706000004537313PA8416812025-10-01False
17060000045388L17/dossiers17170600000453731706000004537314PA8409032025-10-01False
17060000045389L17/dossiers17170600000453731706000004537315PA7936642025-10-01False
17060000045390L17/dossiers17170600000453731706000004537316PA3403432025-10-01False
17060000045391L17/dossiers17170600000453731706000004537317PA8418932025-10-01False
17060000045392L17/dossiers17170600000453731706000004537318PA7941662025-10-01False
17060000045393L17/dossiers17170600000453731706000004537319PA7208382025-10-01False
17060000045394L17/dossiers17170600000453731706000004537320PA7939802025-10-01False
17060000045395L17/dossiers17170600000453731706000004537321PA8409472025-10-01False
17060000045396L17/dossiers17170600000453731706000004537322PA8417132025-10-01False