Job request: 17019
- Organisation:
- Bennett Institute
- Workspace:
- opensafely-internal-interactive
- ID:
- xi7gcjwpm7qeb4r3
This page shows the technical details of what happened when the authorised researcher Catherine Stables 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
-
- Job identifier:
-
ip22gxq3riiejdbs
-
- Job identifier:
-
rokqa2rqxzhy54fi
-
- Job identifier:
-
f7mloyowt72xvsr5
-
- Job identifier:
-
6ljvmnywri2hs632
-
- Job identifier:
-
7yd4fqekp2arf4vv
-
- Job identifier:
-
7uhkcll2fvxdztc6
-
- Job identifier:
-
m5qnglv5kiuslk4m
-
- Job identifier:
-
qucwfjk4h5mbwkvr
-
- Job identifier:
-
6wxbnygshqj5nk3h
Pipeline
Show project.yaml
version: '3.0'
expectations:
population_size: 1000
actions:
generate_study_population_ethnicity_01GXQX2XHHW4CFQ3TMH3S0NJ7J:
run: cohortextractor:latest generate_cohort
--study-definition study_definition_ethnicity
--param end_date="2023-04-05"
--output-dir output/01GXQX2XHHW4CFQ3TMH3S0NJ7J --output-format=csv.gz
outputs:
highly_sensitive:
cohort: output/01GXQX2XHHW4CFQ3TMH3S0NJ7J/input_ethnicity.csv.gz
generate_study_population_01GXQX2XHHW4CFQ3TMH3S0NJ7J:
run: cohortextractor:latest generate_cohort
--study-definition study_definition
--param codelist_1_path="interactive_codelists/codelist_1.csv"
--param codelist_1_type="medication"
--param codelist_2_path="interactive_codelists/codelist_2.csv"
--param codelist_2_type="event"
--param codelist_1_frequency="monthly"
--param time_value="5"
--param time_scale="years"
--param time_event="before"
--param codelist_2_comparison_date="end_date"
--param operator="AND"
--param population="children"
--param breakdowns="age,imd,region,ethnicity,sex"
--index-date-range="2019-09-01 to 2023-04-05 by month"
--output-dir=output/01GXQX2XHHW4CFQ3TMH3S0NJ7J
--output-format=csv.gz
outputs:
highly_sensitive:
cohort: output/01GXQX2XHHW4CFQ3TMH3S0NJ7J/input_*.csv.gz
join_cohorts_01GXQX2XHHW4CFQ3TMH3S0NJ7J:
run: >
cohort-joiner:v0.0.38
--lhs output/01GXQX2XHHW4CFQ3TMH3S0NJ7J/input_20*.csv.gz
--rhs output/01GXQX2XHHW4CFQ3TMH3S0NJ7J/input_ethnicity.csv.gz
--output-dir output/01GXQX2XHHW4CFQ3TMH3S0NJ7J/joined
needs: [generate_study_population_01GXQX2XHHW4CFQ3TMH3S0NJ7J, generate_study_population_ethnicity_01GXQX2XHHW4CFQ3TMH3S0NJ7J]
outputs:
highly_sensitive:
cohort: output/01GXQX2XHHW4CFQ3TMH3S0NJ7J/joined/input_20*.csv.gz
generate_measures_01GXQX2XHHW4CFQ3TMH3S0NJ7J:
run: >
python:latest -m analysis.measures
--breakdowns="age,imd,region,ethnicity,sex"
--input_dir="output/01GXQX2XHHW4CFQ3TMH3S0NJ7J/joined"
--measure="med_review"
needs: [join_cohorts_01GXQX2XHHW4CFQ3TMH3S0NJ7J]
outputs:
moderately_sensitive:
measure: output/01GXQX2XHHW4CFQ3TMH3S0NJ7J/joined/measure*rate.csv
decile_measure: output/01GXQX2XHHW4CFQ3TMH3S0NJ7J/joined/measure*rate_deciles.csv
top_5_table_01GXQX2XHHW4CFQ3TMH3S0NJ7J:
run: >
python:latest python analysis/top_5.py
--codelist-1-path="interactive_codelists/codelist_1.csv"
--codelist-2-path="interactive_codelists/codelist_2.csv"
--output-dir="output/01GXQX2XHHW4CFQ3TMH3S0NJ7J"
needs: [generate_measures_01GXQX2XHHW4CFQ3TMH3S0NJ7J]
outputs:
moderately_sensitive:
tables: output/01GXQX2XHHW4CFQ3TMH3S0NJ7J/joined/top_5*.csv
deciles_chart_01GXQX2XHHW4CFQ3TMH3S0NJ7J:
run: >
deciles-charts:v0.0.33
--input-files output/01GXQX2XHHW4CFQ3TMH3S0NJ7J/joined/measure_practice_rate_deciles.csv
--output-dir output/01GXQX2XHHW4CFQ3TMH3S0NJ7J/joined
config:
show_outer_percentiles: true
tables:
output: true
charts:
output: true
needs: [generate_measures_01GXQX2XHHW4CFQ3TMH3S0NJ7J]
outputs:
moderately_sensitive:
deciles_charts: output/01GXQX2XHHW4CFQ3TMH3S0NJ7J/joined/deciles_*.*
plot_measure_01GXQX2XHHW4CFQ3TMH3S0NJ7J:
run: >
python:latest python analysis/plot_measures.py
--breakdowns="age,imd,region,ethnicity,sex"
--output-dir output/01GXQX2XHHW4CFQ3TMH3S0NJ7J
needs: [generate_measures_01GXQX2XHHW4CFQ3TMH3S0NJ7J]
outputs:
moderately_sensitive:
measure: output/01GXQX2XHHW4CFQ3TMH3S0NJ7J/plot_measure*.png
event_counts_01GXQX2XHHW4CFQ3TMH3S0NJ7J:
run: >
python:latest python analysis/event_counts.py --input_dir="output/01GXQX2XHHW4CFQ3TMH3S0NJ7J/joined" --output_dir="output/01GXQX2XHHW4CFQ3TMH3S0NJ7J"
needs: [join_cohorts_01GXQX2XHHW4CFQ3TMH3S0NJ7J]
outputs:
moderately_sensitive:
measure: output/01GXQX2XHHW4CFQ3TMH3S0NJ7J/event_counts.json
generate_report_01GXQX2XHHW4CFQ3TMH3S0NJ7J:
run: >
python:latest python analysis/render_report.py
--output-dir="output/01GXQX2XHHW4CFQ3TMH3S0NJ7J"
--report-title="Asthma Inhaler Salbutamol Medication & Asthma Diagnosis code"
--population="children"
--breakdowns="age,imd,region,ethnicity,sex"
--codelist-1-name="Asthma Inhaler Salbutamol Medication"
--codelist-2-name="Asthma Diagnosis code"
--codelist-1-link="opensafely/asthma-inhaler-salbutamol-medication/2020-04-15"
--codelist-2-link="primis-covid19-vacc-uptake/ast/v.1.5.3"
--time-value="5"
--time-scale="years"
--time-event="before"
--start-date="2019-09-01"
--end-date="2023-04-05"
needs: [event_counts_01GXQX2XHHW4CFQ3TMH3S0NJ7J, deciles_chart_01GXQX2XHHW4CFQ3TMH3S0NJ7J, top_5_table_01GXQX2XHHW4CFQ3TMH3S0NJ7J, plot_measure_01GXQX2XHHW4CFQ3TMH3S0NJ7J]
outputs:
moderately_sensitive:
notebook: output/01GXQX2XHHW4CFQ3TMH3S0NJ7J/report.html
Timeline
-
Created:
-
Started:
-
Finished:
-
Runtime: 34:23:41
These timestamps are generated and stored using the UTC timezone on the TPP backend.
Job request
- Status
-
Succeeded
- Backend
- TPP
- Workspace
- opensafely-internal-interactive
- Requested by
- Catherine Stables
- Branch
- main
- Force run dependencies
- Yes
- Git commit hash
- a2f49bd
- Requested actions
-
-
run_all
-
Code comparison
Compare the code used in this job request