Skip to content

Job request: 27522

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

This page shows the technical details of what happened when the authorised researcher James Osmond 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

  • Action:
    measures_demo_sex
    Status:
    Pending
    Job identifier:
    mj7blohilxk56unl
    Status message:
    waiting_on_db_workers: Waiting on available database workers
  • Action:
    measures_disorder
    Status:
    Pending
    Job identifier:
    h3rahetbe3pvvpct
    Status message:
    waiting_on_db_workers: Waiting on available database workers
  • Action:
    measures_ppp_and_contraceptives
    Status:
    Pending
    Job identifier:
    vjmygcapjxxeyfuo
    Status message:
    waiting_on_db_workers: Waiting on available database workers
  • Action:
    measures_birth_and_pregnancy_events
    Status:
    Pending
    Job identifier:
    o6ht42oayrvzpruy
    Status message:
    waiting_on_db_workers: Waiting on available database workers

Pipeline

Show project.yaml
version: '5.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 "2014-01-01"
      --intervals 144
    outputs:
      moderately_sensitive:
        measure_csv: output/measures_base.csv

  measures_demo_age:
    run: ehrql:v1 generate-measures analysis/measures_demo_age.py
      --output output/measures_demo_age.csv
      --
      --start-date "2014-01-01"
      --intervals 144
    outputs:
      moderately_sensitive:
        measure_csv: output/measures_demo_age.csv

  measures_demo_imd:
    run: ehrql:v1 generate-measures analysis/measures_demo_imd.py
      --output output/measures_demo_imd.csv
      --
      --start-date "2014-01-01"
      --intervals 144
    outputs:
      moderately_sensitive:
        measure_csv: output/measures_demo_imd.csv

  measures_demo_sex:
    run: ehrql:v1 generate-measures analysis/measures_demo_sex.py
      --output output/measures_demo_sex.csv
      --
      --start-date "2014-01-01"
      --intervals 144
    outputs:
      moderately_sensitive:
        measure_csv: output/measures_demo_sex.csv

  measures_demo_female_age_band:
    run: ehrql:v1 generate-measures analysis/measures_demo_female_age_band.py
      --output output/measures_demo_female_age_band.csv
      --
      --start-date "2014-01-01"
      --intervals 144
    outputs:
      moderately_sensitive:
        measure_csv: output/measures_demo_female_age_band.csv

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

  measures_disorder:
    run: ehrql:v1 generate-measures analysis/measures_disorder.py
      --output output/measures_disorder.csv
      --
      --start-date "2014-01-01"
      --intervals 144
    outputs:
      moderately_sensitive:
        measure_csv: output/measures_disorder.csv

  measures_ppp_and_contraceptives:
    run: ehrql:v1 generate-measures analysis/measures_ppp_and_contraceptives.py
      --output output/measures_ppp_and_contraceptives.csv
      --
      --start-date "2014-01-01"
      --intervals 144
    outputs:
      moderately_sensitive:
        measure_csv: output/measures_ppp_and_contraceptives.csv

  measures_birth_and_pregnancy_events:
    run: ehrql:v1 generate-measures analysis/measures_birth_and_pregnancy_events.py
      --output output/measures_birth_and_pregnancy_events.csv
      --
      --start-date "2014-01-01"
      --intervals 144
    outputs:
      moderately_sensitive:
        measure_csv: output/measures_birth_and_pregnancy_events.csv

  measures_epilepsy_prescribing:
    run: ehrql:v1 generate-measures analysis/measures_epilepsy_prescribing.py
      --output output/measures_epilepsy_prescribing.csv
      --
      --start-date "2014-01-01"
      --intervals 144
    outputs:
      moderately_sensitive:
        measure_csv: output/measures_epilepsy_prescribing.csv

  # rates:
  #   run: python:v2 -m analysis.plots.rates_analysis
  #         --output output/monthly_sv_prescribed_female_cba.svg
  #         --output output/monthly_new_starters_female_cba.svg
  #         --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
  #       plot_sv_prescribed_females_cba: output/monthly_sv_prescribed_female_cba.svg
  #       plot_new_starters_females_cba: output/monthly_new_starters_female_cba.svg
  #       sv_new_starter_females_cba_ppp_time_series: output/sv_new_starter_females_cba_ppp_time_series.svg
  #       sv_prescribed_females_cba_ppp_time_series: output/sv_prescribed_females_cba_ppp_time_series.svg

  # rates_comorbidity:
  #   run: python:v2 -m analysis.plots.sv_prescription_rates_by_condition
  #         --output output/prescription_rates_by_condition.svg
  #         --output output/prescription_rates_by_condition_interrupted_time_series.svg
  #   needs: [measures_comorbidity, measures_disorder]
  #   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

  # age_analysis:
  #   run: python:v2 -m analysis.plots.age_analysis
  #         --output output/yearly_age_band_female_new_starter.svg
  #   needs: [measures_demo_female_age_band]
  #   outputs:
  #     moderately_sensitive:
  #       plot_new_starter: output/yearly_age_band_female_new_starter.svg

  # rates_by_demographics:
  #   run: python:v2 -m analysis.plots.sv_prescription_demographics_timeseries
  #         --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_age, measures_demo_imd, measures_demo_sex]
  #   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_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_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
  
  # plots_ppp_and_contraceptives:
  #   run: python:v2 -m analysis.plots.plots_ppp_and_contraceptives
  #   needs: [measures_ppp_and_contraceptives, measures_base]
  #   outputs:
  #     moderately_sensitive:
  #       plot_contraceptive_use: output/monthly_contraceptive_use.svg
  #       plot_contraceptive_use_trendlines: output/monthly_contraceptive_use_trendlines.svg
  #       plot_new_starters_to_ppp_and_sv: output/new_starters_to_ppp_and_sv.svg
  #       plot_new_starters_to_ppp_and_sv_trendlines: output/new_starters_to_ppp_and_sv_trendlines.svg
  #       new_sv_starter_contraceptive_use: output/new_sv_starter_contraceptive_use.svg
  #       new_sv_starter_contraceptive_use_trendlines: output/new_sv_starter_contraceptive_use_trendlines.svg
  #       sv_prescription_females_cba_contraception_comparison: output/sv_prescription_females_cba_contraception_comparison.svg

  # plots_birth_and_pregnancy_events:
  #   run: python:v2 -m analysis.plots.birth_and_pregnancy_events_on_sv
  #   needs: [measures_birth_and_pregnancy_events]
  #   outputs:
  #     moderately_sensitive:
  #       plot_births_or_pregnancies_with_valproate_history_ppp: output/births_or_pregnancies_with_valproate_history_ppp_trendlines.svg
  #       plot_births_or_pregnancies_with_valproate_history_covid: output/births_or_pregnancies_with_valproate_history_covid_trendlines.svg
  #       plot_valproate_history_with_births_or_pregnancies_ppp_trendlines: output/valproate_history_with_births_or_pregnancies_ppp_trendlines.svg
  #       plot_valproate_history_with_births_or_pregnancies_covid_trendlines: output/valproate_history_with_births_or_pregnancies_covid_trendlines.svg
  #       plot_births_or_pregnancies_with_recent_valproate_history_ppp: output/births_or_pregnancies_with_recent_valproate_history_ppp_trendlines.svg
  #       plot_births_or_pregnancies_with_recent_valproate_history_covid: output/births_or_pregnancies_with_recent_valproate_history_covid_trendlines.svg

  # plots_last_resort_prescribing:
  #   run: python:v2 -m analysis.plots.last_resort_prescribing
  #   needs: [measures_epilepsy_prescribing]
  #   outputs:
  #     moderately_sensitive:
  #       plot_epilepsy_patient_prescribed_sv: output/epilepsy_patient_prescribed_sv.svg
  #       plot_prescribed_sv_has_epilepsy: output/prescribed_sv_has_epilepsy.svg
  #       plot_new_starter_prescribed_sv_as_first_epilepsy_med: output/new_starter_prescribed_sv_as_first_epilepsy_med.svg
  #       plot_new_starter_prescribed_sv_as_first_epilepsy_med_covid_trendlines: output/new_starter_prescribed_sv_as_first_epilepsy_med_covid_trendlines.svg
  #       plot_new_starter_prescribed_sv_as_first_epilepsy_med_ppp_trendlines: output/new_starter_prescribed_sv_as_first_epilepsy_med_ppp_trendlines.svg

Job statistics

Status Count Percentage
Pending 4 100%
Running 0 0%
Succeeded 0 0%
Failed 0 0%

0 / 4 (0%) complete

Timeline

  • Created:

  • Runtime:

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

Job request

Status
Pending
Backend
TPP
Workspace
sv-analysis
Requested by
James Osmond
Branch
main
Force run dependencies
No
Git commit hash
8599910
Requested actions
  • run_all

Code comparison

Compare the code used in this job request