Job request: 16090
- Organisation:
- Bennett Institute
- Workspace:
- opensafely-internal-interactive
- ID:
- o35sldaz7l3wnyji
This page shows the technical details of what happened when the authorised researcher Brian Mackenna (Gmail) 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:
-
bqa73g4rfta33xve
-
- Job identifier:
-
awer7cjmaa4wiigc
-
- Job identifier:
-
qlf2xkwbf2pdzko6
-
- Job identifier:
-
ny5cky5iu3otkhbw
-
- Job identifier:
-
db45fhveo5a647mk
-
- Job identifier:
-
t7vrbqja62tqfjsi
-
- Job identifier:
-
dfrfuoauqvr53hzq
-
- Job identifier:
-
wqmnutt7davwenga
-
- Job identifier:
-
f43qkx3kubk4r27r
Pipeline
Show project.yaml
version: '3.0'
expectations:
population_size: 1000
actions:
generate_study_population_ethnicity_01GTYFWPZ8YE8BTBSPZ8MT9R5X:
run: cohortextractor:latest generate_cohort
--study-definition study_definition_ethnicity
--param end_date="2023-03-01"
--output-dir output/01GTYFWPZ8YE8BTBSPZ8MT9R5X --output-format=csv.gz
outputs:
highly_sensitive:
cohort: output/01GTYFWPZ8YE8BTBSPZ8MT9R5X/input_ethnicity.csv.gz
generate_study_population_01GTYFWPZ8YE8BTBSPZ8MT9R5X:
run: cohortextractor:latest generate_cohort
--study-definition study_definition
--param codelist_1_path="codelists/codelist_1.csv"
--param codelist_1_type="medication"
--param codelist_2_path="codelists/codelist_2.csv"
--param codelist_2_type="event"
--param codelist_1_frequency="monthly"
--param time_value="3"
--param time_scale="weeks"
--param time_event="before"
--param codelist_2_comparison_date="event_1_date"
--param operator="AND"
--param population="all"
--param breakdowns="sex"
--index-date-range="2022-09-02 to 2023-03-01 by month"
--output-dir=output/01GTYFWPZ8YE8BTBSPZ8MT9R5X
--output-format=csv.gz
outputs:
highly_sensitive:
cohort: output/01GTYFWPZ8YE8BTBSPZ8MT9R5X/input_*.csv.gz
join_cohorts_01GTYFWPZ8YE8BTBSPZ8MT9R5X:
run: >
cohort-joiner:v0.0.38
--lhs output/01GTYFWPZ8YE8BTBSPZ8MT9R5X/input_20*.csv.gz
--rhs output/01GTYFWPZ8YE8BTBSPZ8MT9R5X/input_ethnicity.csv.gz
--output-dir output/01GTYFWPZ8YE8BTBSPZ8MT9R5X/joined
needs: [generate_study_population_01GTYFWPZ8YE8BTBSPZ8MT9R5X, generate_study_population_ethnicity_01GTYFWPZ8YE8BTBSPZ8MT9R5X]
outputs:
highly_sensitive:
cohort: output/01GTYFWPZ8YE8BTBSPZ8MT9R5X/joined/input_20*.csv.gz
generate_measures_01GTYFWPZ8YE8BTBSPZ8MT9R5X:
run: >
python:latest python analysis/measures.py
--breakdowns="sex"
--input_dir="output/01GTYFWPZ8YE8BTBSPZ8MT9R5X/joined"
--measure="med_review"
needs: [join_cohorts_01GTYFWPZ8YE8BTBSPZ8MT9R5X]
outputs:
moderately_sensitive:
measure: output/01GTYFWPZ8YE8BTBSPZ8MT9R5X/joined/measure*rate.csv
decile_measure: output/01GTYFWPZ8YE8BTBSPZ8MT9R5X/joined/measure*rate_deciles.csv
top_5_table_01GTYFWPZ8YE8BTBSPZ8MT9R5X:
run: >
python:latest python analysis/top_5.py
--codelist-1-path="codelists/codelist_1.csv"
--codelist-2-path="codelists/codelist_2.csv"
--output-dir="output/01GTYFWPZ8YE8BTBSPZ8MT9R5X"
needs: [generate_measures_01GTYFWPZ8YE8BTBSPZ8MT9R5X]
outputs:
moderately_sensitive:
tables: output/01GTYFWPZ8YE8BTBSPZ8MT9R5X/joined/top_5*.csv
deciles_chart_01GTYFWPZ8YE8BTBSPZ8MT9R5X:
run: >
deciles-charts:v0.0.33
--input-files output/01GTYFWPZ8YE8BTBSPZ8MT9R5X/joined/measure_practice_rate_deciles.csv
--output-dir output/01GTYFWPZ8YE8BTBSPZ8MT9R5X/joined
config:
show_outer_percentiles: true
tables:
output: true
charts:
output: true
needs: [generate_measures_01GTYFWPZ8YE8BTBSPZ8MT9R5X]
outputs:
moderately_sensitive:
deciles_charts: output/01GTYFWPZ8YE8BTBSPZ8MT9R5X/joined/deciles_*.*
plot_measure_01GTYFWPZ8YE8BTBSPZ8MT9R5X:
run: >
python:latest python analysis/plot_measures.py
--breakdowns="sex"
--output-dir output/01GTYFWPZ8YE8BTBSPZ8MT9R5X
needs: [generate_measures_01GTYFWPZ8YE8BTBSPZ8MT9R5X]
outputs:
moderately_sensitive:
measure: output/01GTYFWPZ8YE8BTBSPZ8MT9R5X/plot_measure*.png
event_counts_01GTYFWPZ8YE8BTBSPZ8MT9R5X:
run: >
python:latest python analysis/event_counts.py --input_dir="output/01GTYFWPZ8YE8BTBSPZ8MT9R5X/joined" --output_dir="output/01GTYFWPZ8YE8BTBSPZ8MT9R5X"
needs: [join_cohorts_01GTYFWPZ8YE8BTBSPZ8MT9R5X]
outputs:
moderately_sensitive:
measure: output/01GTYFWPZ8YE8BTBSPZ8MT9R5X/event_counts.json
generate_report_01GTYFWPZ8YE8BTBSPZ8MT9R5X:
run: >
python:latest python analysis/render_report.py
--report-title="DMARDs & Care planning medication review simple reference set - NHS Digital"
--population="all"
--breakdowns="sex"
--codelist-1-name="DMARDs"
--codelist-2-name="Care planning medication review simple reference set - NHS Digital"
--codelist-1-link="opensafely/dmards/2020-06-23"
--codelist-2-link="opensafely/care-planning-medication-review-simple-reference-set-nhs-digital/61b13c39"
--time-value="3"
--time-scale="weeks"
--time-event="before"
--start-date="2022-09-02"
--end-date="2023-03-01"
--num-practices=1000
--request-id="01GTYFWPZ8YE8BTBSPZ8MT9R5X"
needs: [event_counts_01GTYFWPZ8YE8BTBSPZ8MT9R5X, deciles_chart_01GTYFWPZ8YE8BTBSPZ8MT9R5X, top_5_table_01GTYFWPZ8YE8BTBSPZ8MT9R5X, plot_measure_01GTYFWPZ8YE8BTBSPZ8MT9R5X]
outputs:
moderately_sensitive:
notebook: output/01GTYFWPZ8YE8BTBSPZ8MT9R5X/report.html
Timeline
-
Created:
-
Started:
-
Finished:
-
Runtime: 03:41:57
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
- Brian Mackenna (Gmail)
- Branch
- main
- Force run dependencies
- Yes
- Git commit hash
- 1c91a21
- Requested actions
-
-
run_all
-
Code comparison
Compare the code used in this job request