Job request: 16259
- Organisation:
- Bennett Institute
- Workspace:
- opensafely-internal-interactive
- ID:
- l5z536eqm3xgytk2
This page shows the technical details of what happened when the authorised researcher George Hickman 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:
-
vewqrakcqz7qwkni
-
- Job identifier:
-
kcy274ykywoimsru
-
- Job identifier:
-
av5hs7vvobbpxxzm
-
- Job identifier:
-
ccyz2qc3vxd3ft3f
-
- Job identifier:
-
w2ikwnjyjm3u7aed
-
- Job identifier:
-
y7s5qhoqyjzevgeo
-
- Job identifier:
-
rpmlisi3mcwtekpk
-
- Job identifier:
-
ep6kr7vpzwfo2xx5
-
- Job identifier:
-
pcu7qde5itcl5lij
Pipeline
Show project.yaml
version: '3.0'
expectations:
population_size: 1000
actions:
generate_study_population_ethnicity_01GVDPH4C178NC5XKZHCFPNQJ2:
run: cohortextractor:latest generate_cohort
--study-definition study_definition_ethnicity
--param end_date="2023-03-01"
--output-dir output/01GVDPH4C178NC5XKZHCFPNQJ2 --output-format=csv.gz
outputs:
highly_sensitive:
cohort: output/01GVDPH4C178NC5XKZHCFPNQJ2/input_ethnicity.csv.gz
generate_study_population_01GVDPH4C178NC5XKZHCFPNQJ2:
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="5"
--param time_scale="years"
--param time_event="before"
--param codelist_2_comparison_date="end_date"
--param operator="AND"
--param population="all"
--param breakdowns="sex,age"
--index-date-range="2022-09-02 to 2023-03-01 by month"
--output-dir=output/01GVDPH4C178NC5XKZHCFPNQJ2
--output-format=csv.gz
outputs:
highly_sensitive:
cohort: output/01GVDPH4C178NC5XKZHCFPNQJ2/input_*.csv.gz
join_cohorts_01GVDPH4C178NC5XKZHCFPNQJ2:
run: >
cohort-joiner:v0.0.38
--lhs output/01GVDPH4C178NC5XKZHCFPNQJ2/input_20*.csv.gz
--rhs output/01GVDPH4C178NC5XKZHCFPNQJ2/input_ethnicity.csv.gz
--output-dir output/01GVDPH4C178NC5XKZHCFPNQJ2/joined
needs: [generate_study_population_01GVDPH4C178NC5XKZHCFPNQJ2, generate_study_population_ethnicity_01GVDPH4C178NC5XKZHCFPNQJ2]
outputs:
highly_sensitive:
cohort: output/01GVDPH4C178NC5XKZHCFPNQJ2/joined/input_20*.csv.gz
generate_measures_01GVDPH4C178NC5XKZHCFPNQJ2:
run: >
python:latest python -m analysis.measures
--breakdowns="sex,age"
--input_dir="output/01GVDPH4C178NC5XKZHCFPNQJ2/joined"
--measure="med_review"
needs: [join_cohorts_01GVDPH4C178NC5XKZHCFPNQJ2]
outputs:
moderately_sensitive:
measure: output/01GVDPH4C178NC5XKZHCFPNQJ2/joined/measure*rate.csv
decile_measure: output/01GVDPH4C178NC5XKZHCFPNQJ2/joined/measure*rate_deciles.csv
top_5_table_01GVDPH4C178NC5XKZHCFPNQJ2:
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/01GVDPH4C178NC5XKZHCFPNQJ2"
needs: [generate_measures_01GVDPH4C178NC5XKZHCFPNQJ2]
outputs:
moderately_sensitive:
tables: output/01GVDPH4C178NC5XKZHCFPNQJ2/joined/top_5*.csv
deciles_chart_01GVDPH4C178NC5XKZHCFPNQJ2:
run: >
deciles-charts:v0.0.33
--input-files output/01GVDPH4C178NC5XKZHCFPNQJ2/joined/measure_practice_rate_deciles.csv
--output-dir output/01GVDPH4C178NC5XKZHCFPNQJ2/joined
config:
show_outer_percentiles: true
tables:
output: true
charts:
output: true
needs: [generate_measures_01GVDPH4C178NC5XKZHCFPNQJ2]
outputs:
moderately_sensitive:
deciles_charts: output/01GVDPH4C178NC5XKZHCFPNQJ2/joined/deciles_*.*
plot_measure_01GVDPH4C178NC5XKZHCFPNQJ2:
run: >
python:latest python analysis/plot_measures.py
--breakdowns="sex,age"
--output-dir output/01GVDPH4C178NC5XKZHCFPNQJ2
needs: [generate_measures_01GVDPH4C178NC5XKZHCFPNQJ2]
outputs:
moderately_sensitive:
measure: output/01GVDPH4C178NC5XKZHCFPNQJ2/plot_measure*.png
event_counts_01GVDPH4C178NC5XKZHCFPNQJ2:
run: >
python:latest python analysis/event_counts.py --input_dir="output/01GVDPH4C178NC5XKZHCFPNQJ2/joined" --output_dir="output/01GVDPH4C178NC5XKZHCFPNQJ2"
needs: [join_cohorts_01GVDPH4C178NC5XKZHCFPNQJ2]
outputs:
moderately_sensitive:
measure: output/01GVDPH4C178NC5XKZHCFPNQJ2/event_counts.json
generate_report_01GVDPH4C178NC5XKZHCFPNQJ2:
run: >
python:latest python analysis/render_report.py
--report-title="DMARDs & Medication Review - OpenSAFELY Service Restoration Observatory"
--population="all"
--breakdowns="sex,age"
--codelist-1-name="DMARDs"
--codelist-2-name="Medication Review - OpenSAFELY Service Restoration Observatory"
--codelist-1-link="opensafely/dmards/2020-06-23"
--codelist-2-link="opensafely/medication-review-opensafely-service-restoration-observatory/24b50f64"
--time-value="5"
--time-scale="years"
--time-event="before"
--start-date="2022-09-02"
--end-date="2023-03-01"
--request-id="01GVDPH4C178NC5XKZHCFPNQJ2"
needs: [event_counts_01GVDPH4C178NC5XKZHCFPNQJ2, deciles_chart_01GVDPH4C178NC5XKZHCFPNQJ2, top_5_table_01GVDPH4C178NC5XKZHCFPNQJ2, plot_measure_01GVDPH4C178NC5XKZHCFPNQJ2]
outputs:
moderately_sensitive:
notebook: output/01GVDPH4C178NC5XKZHCFPNQJ2/report-01GVDPH4C178NC5XKZHCFPNQJ2.html
Timeline
-
Created:
-
Started:
-
Finished:
-
Runtime: 03:55:21
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
- George Hickman
- Branch
- main
- Force run dependencies
- Yes
- Git commit hash
- 234b823
- Requested actions
-
-
run_all
-
Code comparison
Compare the code used in this job request