Skip to content

Job request: 27466

Organisation:
University of Oxford
Workspace:
vitamin-d-trends
ID:
o4xfoecuejoncc2p

This page shows the technical details of what happened when the authorised researcher Irene Kyomuhangi 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:
    generate_measures_2013
    Status:
    Pending
    Job identifier:
    gh2fyrfi6bkblt3p
    Status message:
    waiting_on_db_workers: Waiting on available database workers
  • Action:
    generate_measures_2014
    Status:
    Pending
    Job identifier:
    rc3xncbvir7wtnry
    Status message:
    waiting_on_db_workers: Waiting on available database workers
  • Action:
    generate_measures_2015
    Status:
    Pending
    Job identifier:
    hmq33ltalba3itli
    Status message:
    waiting_on_db_workers: Waiting on available database workers
  • Action:
    generate_measures_2016
    Status:
    Pending
    Job identifier:
    4zrlf2j4nso3dyz5
    Status message:
    waiting_on_db_workers: Waiting on available database workers
  • Action:
    generate_measures_2022
    Status:
    Pending
    Job identifier:
    fvqsvsgazzwz6e5z
    Status message:
    waiting_on_db_workers: Waiting on available database workers
  • Action:
    generate_measures_2023
    Status:
    Pending
    Job identifier:
    5g63hz7srzrdrpah
    Status message:
    waiting_on_db_workers: Waiting on available database workers
  • Action:
    generate_measures_2025
    Status:
    Pending
    Job identifier:
    422efvkozfavhj7n
    Status message:
    waiting_on_db_workers: Waiting on available database workers
  • Action:
    generate_measures_2026
    Status:
    Pending
    Job identifier:
    n3qlwljnpljjcifs
    Status message:
    waiting_on_db_workers: Waiting on available database workers
  • Action:
    combine_measures
    Status:
    Pending
    Job identifier:
    vijp4t6u4lut5x47
    Status message:
    waiting_on_dependencies: Waiting on dependencies
  • Action:
    generate_practice_deciles
    Status:
    Pending
    Job identifier:
    hex4n37lrvmghu33
    Status message:
    waiting_on_dependencies: Waiting on dependencies
  • Action:
    generate_measures_2021
    Status:
    Pending
    Job identifier:
    zj5fzydeobaulctu
    Status message:
    waiting_on_db_workers: Waiting on available database workers
  • Action:
    generate_covariate_plots
    Status:
    Pending
    Job identifier:
    bre25j25g6wsi7pd
    Status message:
    waiting_on_dependencies: Waiting on dependencies
  • Action:
    generate_overall_trends
    Status:
    Pending
    Job identifier:
    7bdvbb35ba5hibgg
    Status message:
    waiting_on_dependencies: Waiting on dependencies
  • Action:
    generate_measures_2009
    Status:
    Pending
    Job identifier:
    sjgs7myvsa3223ng
    Status message:
    waiting_on_db_workers: Waiting on available database workers
  • Action:
    generate_measures_2010
    Status:
    Pending
    Job identifier:
    co4ypocy7zkndu6p
    Status message:
    waiting_on_db_workers: Waiting on available database workers
  • Action:
    generate_measures_2011
    Status:
    Pending
    Job identifier:
    3yiknx6ew542jyqn
    Status message:
    waiting_on_db_workers: Waiting on available database workers
  • Action:
    generate_measures_2024
    Status:
    Pending
    Job identifier:
    fjqywe5mwm5lblwf
    Status message:
    waiting_on_db_workers: Waiting on available database workers
  • Action:
    generate_measures_2019
    Status:
    Pending
    Job identifier:
    j2etsqfvvkoqqp4l
    Status message:
    waiting_on_db_workers: Waiting on available database workers
  • Action:
    generate_measures_2012
    Status:
    Pending
    Job identifier:
    5ekbwcuab4ydgc5h
    Status message:
    waiting_on_db_workers: Waiting on available database workers
  • Action:
    generate_measures_2017
    Status:
    Pending
    Job identifier:
    cd6fotcro4kihvfg
    Status message:
    waiting_on_db_workers: Waiting on available database workers
  • Action:
    generate_measures_2018
    Status:
    Pending
    Job identifier:
    be4rknjflvhnw4wc
    Status message:
    waiting_on_db_workers: Waiting on available database workers
  • Action:
    generate_measures_2020
    Status:
    Pending
    Job identifier:
    qibrtopx56opf2d2
    Status message:
    waiting_on_db_workers: Waiting on available database workers

Pipeline

Show project.yaml
version: '5.0'

actions:

  generate_measures_2009:
    run: >
      ehrql:v1 generate-measures analysis/n50_measures.py
      --output output/measures_2009.csv.gz
      --
      --full
      --start_intv 2009-01-01
      --n_months 12
    outputs:
      highly_sensitive:
        measures: output/measures_2009.csv.gz

  generate_measures_2010:
    run: >
      ehrql:v1 generate-measures analysis/n50_measures.py
      --output output/measures_2010.csv.gz
      --
      --full
      --start_intv 2010-01-01
      --n_months 12
    outputs:
      highly_sensitive:
        measures: output/measures_2010.csv.gz

  generate_measures_2011:
    run: >
      ehrql:v1 generate-measures analysis/n50_measures.py
      --output output/measures_2011.csv.gz
      --
      --full
      --start_intv 2011-01-01
      --n_months 12
    outputs:
      highly_sensitive:
        measures: output/measures_2011.csv.gz

  generate_measures_2012:
    run: >
      ehrql:v1 generate-measures analysis/n50_measures.py
      --output output/measures_2012.csv.gz
      --
      --full
      --start_intv 2012-01-01
      --n_months 12
    outputs:
      highly_sensitive:
        measures: output/measures_2012.csv.gz

  generate_measures_2013:
    run: >
      ehrql:v1 generate-measures analysis/n50_measures.py
      --output output/measures_2013.csv.gz
      --
      --full
      --start_intv 2013-01-01
      --n_months 12
    outputs:
      highly_sensitive:
        measures: output/measures_2013.csv.gz

  generate_measures_2014:
    run: >
      ehrql:v1 generate-measures analysis/n50_measures.py
      --output output/measures_2014.csv.gz
      --
      --full
      --start_intv 2014-01-01
      --n_months 12
    outputs:
      highly_sensitive:
        measures: output/measures_2014.csv.gz

  generate_measures_2015:
    run: >
      ehrql:v1 generate-measures analysis/n50_measures.py
      --output output/measures_2015.csv.gz
      --
      --full
      --start_intv 2015-01-01
      --n_months 12
    outputs:
      highly_sensitive:
        measures: output/measures_2015.csv.gz

  generate_measures_2016:
    run: >
      ehrql:v1 generate-measures analysis/n50_measures.py
      --output output/measures_2016.csv.gz
      --
      --full
      --start_intv 2016-01-01
      --n_months 12
    outputs:
      highly_sensitive:
        measures: output/measures_2016.csv.gz

  generate_measures_2017:
    run: >
      ehrql:v1 generate-measures analysis/n50_measures.py
      --output output/measures_2017.csv.gz
      --
      --full
      --start_intv 2017-01-01
      --n_months 12
    outputs:
      highly_sensitive:
        measures: output/measures_2017.csv.gz

  generate_measures_2018:
    run: >
      ehrql:v1 generate-measures analysis/n50_measures.py
      --output output/measures_2018.csv.gz
      --
      --full
      --start_intv 2018-01-01
      --n_months 12
    outputs:
      highly_sensitive:
        measures: output/measures_2018.csv.gz

  generate_measures_2019:
    run: >
      ehrql:v1 generate-measures analysis/n50_measures.py
      --output output/measures_2019.csv.gz
      --
      --full
      --start_intv 2019-01-01
      --n_months 12
    outputs:
      highly_sensitive:
        measures: output/measures_2019.csv.gz

  generate_measures_2020:
    run: >
      ehrql:v1 generate-measures analysis/n50_measures.py
      --output output/measures_2020.csv.gz
      --
      --full
      --start_intv 2020-01-01
      --n_months 12
    outputs:
      highly_sensitive:
        measures: output/measures_2020.csv.gz

  generate_measures_2021:
    run: >
      ehrql:v1 generate-measures analysis/n50_measures.py
      --output output/measures_2021.csv.gz
      --
      --full
      --start_intv 2021-01-01
      --n_months 12
    outputs:
      highly_sensitive:
        measures: output/measures_2021.csv.gz

  generate_measures_2022:
    run: >
      ehrql:v1 generate-measures analysis/n50_measures.py
      --output output/measures_2022.csv.gz
      --
      --full
      --start_intv 2022-01-01
      --n_months 12
    outputs:
      highly_sensitive:
        measures: output/measures_2022.csv.gz

  generate_measures_2023:
    run: >
      ehrql:v1 generate-measures analysis/n50_measures.py
      --output output/measures_2023.csv.gz
      --
      --full
      --start_intv 2023-01-01
      --n_months 12
    outputs:
      highly_sensitive:
        measures: output/measures_2023.csv.gz

  generate_measures_2024:
    run: >
      ehrql:v1 generate-measures analysis/n50_measures.py
      --output output/measures_2024.csv.gz
      --
      --full
      --start_intv 2024-01-01
      --n_months 12
    outputs:
      highly_sensitive:
        measures: output/measures_2024.csv.gz

  generate_measures_2025:
    run: >
      ehrql:v1 generate-measures analysis/n50_measures.py
      --output output/measures_2025.csv.gz
      --
      --full
      --start_intv 2025-01-01
      --n_months 12
    outputs:
      highly_sensitive:
        measures: output/measures_2025.csv.gz

  generate_measures_2026:
    run: >
      ehrql:v1 generate-measures analysis/n50_measures.py
      --output output/measures_2026.csv.gz
      --
      --full
      --start_intv 2026-01-01
      --n_months 8
    outputs:
      highly_sensitive:
        measures: output/measures_2026.csv.gz

  generate_measures_test:
    run: >
      ehrql:v1 generate-measures analysis/n50_measures.py
      --output output/measures_test.csv
      --
      --test
    outputs:
      highly_sensitive:
        measures: output/measures_test.csv

  combine_measures:
    run: >
      python:v2 analysis/n81_combine_measures.py
      --start_year 2009
      --end_year 2026
    needs: [generate_measures_2009, generate_measures_2010, generate_measures_2011, generate_measures_2012, generate_measures_2013, generate_measures_2014, generate_measures_2015, generate_measures_2016, generate_measures_2017, generate_measures_2018, generate_measures_2019, generate_measures_2020, generate_measures_2021, generate_measures_2022, generate_measures_2023, generate_measures_2024, generate_measures_2025, generate_measures_2026]
    outputs:
      highly_sensitive:
        measures: output/measures.csv.gz

  generate_overall_trends:
    run: r:v2 analysis/n91_overall_trends.R --full
    needs: [combine_measures]
    outputs:
      moderately_sensitive:
        plots: output/91_overall_trends.png

  generate_overall_trends_test:
    run: r:v2 analysis/n91_overall_trends.R --test
    needs: [generate_measures_test]
    outputs:
      moderately_sensitive:
        plots: output/91_overall_trends_test.png

  generate_practice_deciles:
    run: r:v2 analysis/n92_practice_decile_plots.R --full
    needs: [combine_measures]
    outputs:
      moderately_sensitive:
        plots: output/92_practice_deciles.png

  generate_practice_deciles_test:
    run: r:v2 analysis/n92_practice_decile_plots.R --test
    needs: [generate_measures_test]
    outputs:
      moderately_sensitive:
        plots: output/92_practice_deciles_test.png

  generate_covariate_plots:
    run: r:v2 analysis/n93_covariate_plots.R --full
    needs: [combine_measures]
    outputs:
      moderately_sensitive:
        plots: output/93_covariates_*.png

  generate_covariate_plots_test:
    run: r:v2 analysis/n93_covariate_plots.R --test
    needs: [generate_measures_test]
    outputs:
      moderately_sensitive:
        plots: output/93_covariates_*_test.png
 
  assure_dataset:
    run: >
        ehrql:v1 generate-dataset
        analysis/n60_assure_definition.py
        --test-data-file analysis/n70_test_dataset.py
        --output output/dataset.csv
        --
        --assure
    outputs:
      highly_sensitive:
        population: output/dataset.csv

Job statistics

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

0 / 22 (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
vitamin-d-trends
Requested by
Irene Kyomuhangi
Branch
main
Force run dependencies
No
Git commit hash
74ac600
Requested actions
  • combine_measures
  • generate_overall_trends
  • generate_practice_deciles
  • generate_covariate_plots

Code comparison

Compare the code used in this job request