Skip to content

Instantly share code, notes, and snippets.

@HealthDataInsight
Last active December 10, 2019 11:01
Show Gist options
  • Save HealthDataInsight/ef11d8b527226045c5c7af2d29599a85 to your computer and use it in GitHub Desktop.
Save HealthDataInsight/ef11d8b527226045c5c7af2d29599a85 to your computer and use it in GitHub Desktop.
Example democratic dashboard definition

Example democratic dashboard definition

This example is intended to reproduce the CCG COMPASS dashboard using the new democratic dashboard tool

{
"groups": [
{
"dc:title": "Vital Statistics",
"dc:coverage": "2013",
"dc:publisher": {
"schema:name": "PHE",
"schema:url": {
"@id": "https://nww.cancerstats.nhs.uk"
}
},
"charts": [
{
"dc:title": "Incidence (age standardised)",
"dc:description": "Age standardised incidence rates per 100,000.",
"type": "chart",
"source": {
"csv": "/data/cascade_all.csv",
"ccg": "ccg",
"tumour": "site",
"value": "incidence_rate_value",
"filter": {
"site": "all"
}
}
},
{
"dc:title": "Mortality (age standardised)",
"dc:description": "Age standardised mortality rates per 100,000.",
"type": "chart",
"source": {
"csv": "/data/cascade_all.csv",
"ccg": "ccg",
"tumour": "site",
"value": "mortality_rate_value",
"filter": {
"site": "all"
}
}
},
{
"dc:title": "Survival (one year)",
"dc:description": "% of people surviving their cancer for one year or more.",
"dc:coverage": "2008-2012",
"type": "chart",
"comment": "Data are available for breast, colorectal, lung and prostate tumours"
},
{
"dc:title": "Survival (five years)",
"dc:description": "% of people surviving their cancer for five years or more.",
"dc:coverage": "2004-2008",
"type": "chart",
"comment": "Data are available for breast, colorectal, lung and prostate tumours"
}
]
},
{
"dc:title": "Cancer Service Performance - All Tumours",
"dc:coverage": "Q1 2016-2017",
"dc:publisher": {
"schema:name": "NHS England",
"schema:url": {
"@id": "https://www.england.nhs.uk/statistics/statistical-work-areas/cancer-waiting-times/commissioner-based-cancer-waiting-times-statistics/"
}
},
"charts": [
{
"dc:title": "GP 2 week wait",
"dc:description": "% of patients seen within two weeks of GP referral.",
"type": "chart",
"source": {
"csv": "/data/nhs_england_cwt.csv",
"ccg": "ccg_code",
"value": "twoweekwait_percent"
}
},
{
"dc:title": "62 day waiting times",
"dc:description": "% of patients meeting cancer waiting times targets (62-day measure).",
"type": "chart",
"source": {
"csv": "/data/nhs_england_cwt.csv",
"ccg": "ccg_code",
"value": "sixtytwoday_percent"
}
}
]
},
{
"dc:title": "Early Diagnosis",
"charts": [
{
"dc:title": "Diagnoses at early stage",
"dc:description": "% of cancer patients diagnosed at stages 1 & 2.",
"dc:coverage": "2013",
"dc:publisher": {
"schema:name": "PHE",
"schema:url": {
"@id": "http://www.ncin.org.uk/"
}
},
"type": "chart",
"source": {
"csv": "/data/ncin_early_stage.csv",
"ccg": "ccg_code",
"tumour": "tumour_group",
"value": "percent",
"filter": {
"tumour_group": "all"
}
}
},
{
"dc:title": "Emergency presentation",
"dc:description": "% of cancer patients diagnosed through emergency presentation.",
"dc:coverage": "2006 - 2015",
"dc:publisher": {
"schema:name": "PHE",
"schema:url": {
"@id": "http://www.ncin.org.uk/"
}
},
"type": "chart",
"comment": "Data are available for breast, colorectal, lung and prostate tumours",
"source": {
"csv": "/data/ncin_routes.csv",
"ccg": "ccg_code",
"tumour": "tumour_group",
"value": "emergency_presentation",
"filter": {
"tumour_group": "all"
}
}
},
{
"dc:title": "Screening uptake",
"dc:description": "% of eligible people receiving screening.",
"dc:coverage": "2014",
"dc:publisher": {
"schema:name": "PHE",
"schema:url": {
"@id": "https://www.cancertoolkit.co.uk/Profiles/PracticePublic/Filters"
}
},
"type": "chart",
"comment": "Data are available for breast tumours",
"source": {
"csv": "/data/screening_uptake.csv",
"ccg": "ccg_code",
"tumour": "tumour_group",
"value": "percent",
"filter": {
"tumour_group": "all"
}
}
}
]
},
{
"dc:title": "Patient Experience",
"dc:coverage": "2017",
"dc:publisher": {
"schema:name": "NCPES",
"schema:url": {
"@id": "https://www.quality-health.co.uk/resources/surveys/national-cancer-experience-survey/2014-national-cancer-patient-experience-survey"
}
},
"charts": [
{
"dc:title": "Overall care rating analysis (Q59)",
"dc:description": "Strong positive ratings across all Cancer Patient Experience Survey measures.",
"type": "chart",
"source": {
"csv": "/data/ncpes_scoring_adjusted.csv",
"ccg": "geography_code",
"value": "adjusted_score",
"filter": {
"question": "Q59"
}
}
},
{
"dc:title": "Clinical Nurse Specialist (Q17)",
"dc:description": "Patient given the name of the CNS in charge of their care",
"type": "chart",
"source": {
"csv": "/data/ncpes_scoring_adjusted.csv",
"ccg": "geography_code",
"value": "adjusted_score",
"filter": {
"question": "Q17"
}
}
},
{
"dc:title": "GP visits before referral (Q1)",
"dc:description": "Saw GP once/twice before being told had to go to hospital",
"type": "chart",
"source": {
"csv": "/data/ncpes_scoring_adjusted.csv",
"ccg": "geography_code",
"value": "adjusted_score",
"filter": {
"question": "Q1"
}
}
},
{
"dc:title": "Working well together (Q54)",
"dc:description": "Hospital and community staff always worked well together",
"type": "chart",
"source": {
"csv": "/data/ncpes_scoring_adjusted.csv",
"ccg": "geography_code",
"value": "adjusted_score",
"filter": {
"question": "Q54"
}
}
}
]
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment