Skip to content

Job request: 24236

Organisation:
Department of Health and Social Care
Workspace:
sv-analysis
ID:
fe3l7znu2z7jqtna

This page shows the technical details of what happened when the authorised researcher George Jenkins requested one or more actions to be run against real patient data in the project, within a secure environment.

By cross-referencing the list of jobs with the pipeline section below, you can infer what security level various outputs were written to. Researchers can never directly view outputs marked as highly_sensitive ; they can only request that code runs against them. Outputs marked as moderately_sensitive can be viewed by an approved researcher by logging into a highly secure environment. Only outputs marked as moderately_sensitive can be requested for release to the public, via a controlled output review service.

Jobs

Pipeline

Show project.yaml
version: '4.0'

actions:
  generate_dataset:
    run: ehrql:v1 generate-dataset analysis/dataset_definition.py 
          --output output/dataset.csv.gz
    outputs:
      highly_sensitive:
        dataset: output/dataset.csv.gz


  measures_base:
    run: ehrql:v1 generate-measures analysis/measures_base.py
      --output output/measures_base.csv
      --
      --start-date "2018-01-01"
      --intervals 72
    outputs:
      moderately_sensitive:
        measure_csv: output/measures_base.csv

  measures_demo:
    run: ehrql:v1 generate-measures analysis/measures_demo.py
      --output output/measures_demo.csv.gz
      --
      --start-date "2014-01-01"
      --intervals 120
    outputs:
      highly_sensitive:
        measure_csv: output/measures_demo.csv.gz

  measures_comorbidity:
    run: ehrql:v1 generate-measures analysis/measures_comorbidity.py
      --output output/measures_comorbidity.csv.gz
      --
      --start-date "2014-01-01"
      --intervals 120
    outputs:
      highly_sensitive:
        measure_csv: output/measures_comorbidity.csv.gz

  rates:
    run: python:latest analysis/rates_analysis.py
          --output output/monthly_sv_prescribed.svg
          --output output/monthly_new_starters.svg
    needs: [measures_base]
    outputs:
      moderately_sensitive:
        plot_total: output/monthly_sv_prescribed.svg
        plot_new_starter: output/monthly_new_starters.svg

  rates_comorbidity:
    run: python:latest analysis/sv_prescription_rates_by_condition.py
          --output output/prescription_rates_by_condition.svg
          --output output/prescription_rates_by_condition_interrupted_time_series.svg
    needs: [measures_comorbidity]
    outputs:
      moderately_sensitive:
        plot_conditions: output/prescription_rates_by_condition.svg
        plot_conditions_interrupted_time_series: output/prescription_rates_by_condition_interrupted_time_series.svg

  rates_by_demographics:
    run: python:latest analysis/sv_prescription_demographics_timeseries.py
          --output output/monthly_new_sv_starters_prescribed_ratio_by_sex.svg --output output/monthly_sv_conditions_prescribed_ratio_by_sex.svg
          --output output/monthly_new_sv_starters_prescribed_ratio_by_ethnicity.svg --output output/monthly_sv_conditions_prescribed_ratio_by_ethnicity.svg
          --output output/monthly_new_sv_starters_prescribed_ratio_by_age.svg --output output/monthly_sv_conditions_prescribed_ratio_by_age.svg
          --output output/monthly_new_sv_starters_prescribed_ratio_by_region.svg --output output/monthly_sv_conditions_prescribed_ratio_by_region.svg
          --output output/monthly_new_sv_starters_prescribed_ratio_by_imd_quintile.svg --output output/monthly_sv_conditions_prescribed_ratio_by_imd_quintile.svg
    needs: [measures_demo]
    outputs:
      moderately_sensitive:
        plot_sex_new_starter: output/monthly_new_sv_starters_prescribed_ratio_by_sex.svg
        plot_sex_sv_prescriptions: output/monthly_sv_conditions_prescribed_ratio_by_sex.svg
        plot_ethnicity_new_starter: output/monthly_new_sv_starters_prescribed_ratio_by_ethnicity.svg
        plot_ethnicity_sv_prescriptions: output/monthly_sv_conditions_prescribed_ratio_by_ethnicity.svg
        plot_age_new_starter: output/monthly_new_sv_starters_prescribed_ratio_by_age.svg
        plot_age_sv_prescriptions: output/monthly_sv_conditions_prescribed_ratio_by_age.svg
        plot_region_new_starter: output/monthly_new_sv_starters_prescribed_ratio_by_region.svg
        plot_region_sv_prescriptions: output/monthly_sv_conditions_prescribed_ratio_by_region.svg
        plot_imd_quintile_new_starter: output/monthly_new_sv_starters_prescribed_ratio_by_imd_quintile.svg
        plot_imd_quintile_sv_prescriptions: output/monthly_sv_conditions_prescribed_ratio_by_imd_quintile.svg

Timeline

  • Created:

  • Started:

  • Finished:

  • Runtime: 84:32:52

These timestamps are generated and stored using the UTC timezone on the TPP backend.

Job information

Status
Succeeded
Backend
TPP
Workspace
sv-analysis
Requested by
George Jenkins
Branch
main
Force run dependencies
No
Git commit hash
8131f8c
Requested actions
  • run_all

Code comparison

Compare the code used in this Job Request

  • No previous Job Request available for comparison