timgentry · November 6, 2019 19:06
diff --git a/README.md b/README.md
diff --git a/all_data_csv_by_indicator_id_336.csv b/all_data_csv_by_indicator_id_336.csv
diff --git a/dashboard.json b/dashboard.json
 {
  "groups": [
    {
      "dc:title": "Fingertips",
      "charts": [
        {
          "dc:title": "% aged 65+ years",
          "dc:description": "Proportion of the GP registered population (in percent) aged 65 years or over",
          "dc:coverage": "2018",
          "type": "chart",
          "source": {
            "csv": "https://gist.githubusercontent.com/timgentry/0ab9f55595324a595f6ca1115ef3175b/raw/all_data_csv_by_indicator_id_336.csv",
            "ccg": "Area Code",
            "value": "Value",
            "filter": {
              "Time period": "2018"
            }
          }
        }
      ]
    },
    {
      "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": "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"
            }
          }
        }
      ]
    }
  ]
 }
	{
	"groups": [
	{
	"dc:title": "Fingertips",
	"charts": [
	{
	"dc:title": "% aged 65+ years",
	"dc:description": "Proportion of the GP registered population (in percent) aged 65 years or over",
	"dc:coverage": "2018",
	"type": "chart",
	"source": {
	"csv": "https://gist.githubusercontent.com/timgentry/0ab9f55595324a595f6ca1115ef3175b/raw/all_data_csv_by_indicator_id_336.csv",
	"ccg": "Area Code",
	"value": "Value",
	"filter": {
	"Time period": "2018"
	}
	}
	}
	]
	},
	{
	"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": "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"
	}
	}
	}
	]
	}
	]
	}