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 151 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
17060000014081L17/dossiers1717060000014078170600000140782PA7199682024-10-15False
17060000014082L17/dossiers1717060000014078170600000140783PA6070902024-10-15False
17060000014083L17/dossiers1717060000014078170600000140784PA8409792024-10-15False
17060000014084L17/dossiers1717060000014078170600000140785PA3422402024-10-15False
17060000014085L17/dossiers1717060000014078170600000140786PA7218162024-10-15False
17060000014086L17/dossiers1717060000014078170600000140787PA6428472024-10-15False
17060000014087L17/dossiers1717060000014078170600000140788PA7935082024-10-15False
17060000014088L17/dossiers1717060000014078170600000140789PA7188382024-10-15False
17060000014089L17/dossiers17170600000140781706000001407810PA7940382024-10-15False
17060000014090L17/dossiers17170600000140781706000001407811PA7214422024-10-15False
17060000014094L17/dossiers1717060000014092170600000140921PA7194122025-01-28False
17060000014095L17/dossiers1717060000014092170600000140922PA7935202025-01-28False
17060000014096L17/dossiers1717060000014092170600000140923PA7223362025-01-28False
17060000014097L17/dossiers1717060000014092170600000140924PA7200382025-01-28False
17060000014098L17/dossiers1717060000014092170600000140925PA7958202025-01-28False
17060000014099L17/dossiers1717060000014092170600000140926PA7203342025-01-28False
17060000014100L17/dossiers1717060000014092170600000140927PA7214582025-01-28False
17060000014101L17/dossiers1717060000014092170600000140928PA8413392025-01-28False
17060000014102L17/dossiers1717060000014092170600000140929PA7951762025-01-28False
17060000014103L17/dossiers17170600000140921706000001409210PA8413592025-01-28False
17060000014104L17/dossiers17170600000140921706000001409211PA7952442025-01-28False
17060000014105L17/dossiers17170600000140921706000001409212PA2677802025-01-28False
17060000014106L17/dossiers17170600000140921706000001409213PA7194042025-01-28False
17060000014107L17/dossiers17170600000140921706000001409214PA7957222025-01-28False
17060000014108L17/dossiers17170600000140921706000001409215PA7203422025-01-28False
17060000014109L17/dossiers17170600000140921706000001409216PA7948022025-01-28False
17060000014110L17/dossiers17170600000140921706000001409217PA7201542025-01-28False
17060000014111L17/dossiers17170600000140921706000001409218PA7220002025-01-28False
17060000014112L17/dossiers17170600000140921706000001409219PA7193382025-01-28False
17060000014113L17/dossiers17170600000140921706000001409220PA8402352025-01-28False
17060000014114L17/dossiers17170600000140921706000001409221PA7214262025-01-28False
17060000014115L17/dossiers17170600000140921706000001409222PA6065072025-01-28False
17060000014116L17/dossiers17170600000140921706000001409223PA7202302025-01-28False
17060000014117L17/dossiers17170600000140921706000001409224PA7959082025-01-28False
17060000014118L17/dossiers17170600000140921706000001409225PA7212342025-01-28False
17060000014119L17/dossiers17170600000140921706000001409226PA7946582025-01-28False
17060000014120L17/dossiers17170600000140921706000001409227PA7196402025-01-28False
17060000014121L17/dossiers17170600000140921706000001409228PA3322282025-01-28False
17060000014122L17/dossiers17170600000140921706000001409229PA7195502025-01-28False
17060000014123L17/dossiers17170600000140921706000001409230PA6056942025-01-28False
17060000014124L17/dossiers17170600000140921706000001409231PA7190322025-01-28False
17060000014125L17/dossiers17170600000140921706000001409232PA7947022025-01-28False
17060000014126L17/dossiers17170600000140921706000001409233PA7190242025-01-28False
17060000014127L17/dossiers17170600000140921706000001409234PA6071932025-01-28False
17060000014128L17/dossiers17170600000140921706000001409235PA7209762025-01-28False
17060000014129L17/dossiers17170600000140921706000001409236PA8413812025-01-28False
17060000014130L17/dossiers17170600000140921706000001409237PA7952402025-01-28False
17060000014131L17/dossiers17170600000140921706000001409238PA7942702025-01-28False
17060000014132L17/dossiers17170600000140921706000001409239PA2677632025-01-28False
17060000014133L17/dossiers17170600000140921706000001409240PA7938162025-01-28False