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
17060000033634L17/dossiers17170600000335981706000003359835PA29402025-04-07False
17060000033635L17/dossiers17170600000335981706000003359836PA8420132025-04-07False
17060000033636L17/dossiers17170600000335981706000003359837PA8420452025-04-07False
17060000033637L17/dossiers17170600000335981706000003359838PA3421962025-04-07False
17060000033638L17/dossiers17170600000335981706000003359839PA8414192025-04-07False
17060000033645L17/dossiers1717060000033643170600000336431PA7212342025-04-30False
17060000033646L17/dossiers1717060000033643170600000336432PA7572252025-04-30False
17060000033647L17/dossiers1717060000033643170600000336433PA6431432025-04-30False
17060000033648L17/dossiers1717060000033643170600000336434PA7192862025-04-30False
17060000033649L17/dossiers1717060000033643170600000336435PA7951762025-04-30False
17060000033650L17/dossiers1717060000033643170600000336436PA8407212025-04-30False
17060000033651L17/dossiers1717060000033643170600000336437PA8413592025-04-30False
17060000033652L17/dossiers1717060000033643170600000336438PA8408172025-04-30False
17060000033653L17/dossiers1717060000033643170600000336439PA8402352025-04-30False
17060000033654L17/dossiers17170600000336431706000003364310PA7945542025-04-30False
17060000033655L17/dossiers17170600000336431706000003364311PA8419312025-04-30False
17060000033656L17/dossiers17170600000336431706000003364312PA7958762025-04-30False
17060000033657L17/dossiers17170600000336431706000003364313PA7952582025-04-30False
17060000033658L17/dossiers17170600000336431706000003364314PA8420132025-04-30False
17060000033659L17/dossiers17170600000336431706000003364315PA7960782025-04-30False
17060000033660L17/dossiers17170600000336431706000003364316PA7214742025-04-30False
17060000033661L17/dossiers17170600000336431706000003364317PA2677632025-04-30False
17060000033662L17/dossiers17170600000336431706000003364318PA7209762025-04-30False
17060000033663L17/dossiers17170600000336431706000003364319PA8406732025-04-30False
17060000033664L17/dossiers17170600000336431706000003364320PA7946582025-04-30False
17060000033665L17/dossiers17170600000336431706000003364321PA7120142025-04-30False
17060000033666L17/dossiers17170600000336431706000003364322PA3315822025-04-30False
17060000033667L17/dossiers17170600000336431706000003364323PA7201902025-04-30False
17060000033668L17/dossiers17170600000336431706000003364324PA7940942025-04-30False
17060000033669L17/dossiers17170600000336431706000003364325PA7952442025-04-30False
17060000033670L17/dossiers17170600000336431706000003364326PA7191382025-04-30False
17060000033671L17/dossiers17170600000336431706000003364327PA2670422025-04-30False
17060000033672L17/dossiers17170600000336431706000003364328PA6076192025-04-30False
17060000033673L17/dossiers17170600000336431706000003364329PA7947022025-04-30False
17060000033674L17/dossiers17170600000336431706000003364330PA7954542025-04-30False
17060000033675L17/dossiers17170600000336431706000003364331PA7209922025-04-30False
17060000033676L17/dossiers17170600000336431706000003364332PA7957622025-04-30False
17060000033677L17/dossiers17170600000336431706000003364333PA7209602025-04-30False
17060000033678L17/dossiers17170600000336431706000003364334PA7214862025-04-30False
17060000033679L17/dossiers17170600000336431706000003364335PA2667972025-04-30False
17060000033680L17/dossiers17170600000336431706000003364336PA7202562025-04-30False
17060000033681L17/dossiers17170600000336431706000003364337PA7197562025-04-30False
17060000033682L17/dossiers17170600000336431706000003364338PA7932102025-04-30False
17060000033686L17/dossiers1717060000033684170600000336841PA7932102025-05-07False
17060000033687L17/dossiers1717060000033684170600000336842PA2677632025-05-07False
17060000033688L17/dossiers1717060000033684170600000336843PA8408172025-05-07False
17060000033689L17/dossiers1717060000033684170600000336844PA7191382025-05-07False
17060000033690L17/dossiers1717060000033684170600000336845PA7945542025-05-07False
17060000033691L17/dossiers1717060000033684170600000336846PA2670422025-05-07False
17060000033692L17/dossiers1717060000033684170600000336847PA8226172025-05-07False