Skip to content

Job request: 24236

Organisation:
Department of Health and Social Care
Workspace:
sv-analysis
ID:
fe3l7znu2z7jqtna
View repo View project.yaml

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 within a secure environment.

By cross-referencing the list of jobs with the pipeline section below, you can infer what security level the outputs were written to.

The output security levels are:

  • highly_sensitive
    • Researchers can never directly view these outputs
    • Researchers can only request code is run against them
  • moderately_sensitive
    • Can be viewed by an approved researcher by logging into a highly secure environment
    • These are the only outputs that can be requested for public release 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 request

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