Researchers · research-secondary-data

Accessing health data for research — the round trip, live

Each step below ran just now against the sandbox. Links open the real resources.

done The cohort, as the CDR holds it in ehrbase

4 blood-pressure observations across 4 subjects, read with one AQL query. Run UC-08 and UC-01 first if this is empty.

Show payload

SELECT e/ehr_id/value AS ehr_id, e/ehr_status/subject/external_ref/id/value AS subject, o/data[at0001]/events[at0006]/data[at0003]/items[at0004]/value/magnitude AS systolic FROM EHR e CONTAINS COMPOSITION c CONTAINS OBSERVATION o[openEHR-EHR-OBSERVATION.blood_pressure.v2]

-> [['4a6ece6b-2f57-4539-8a64-e5e51070a076', 'nirog-demo-001', 124.0], ['ab709141-cfdd-42b4-aa0b-ed8d57e14d41', '23', 131.0], ['72312d2a-7961-4927-8a9f-d9b7f6247026', '63', 146.0], ['013ac958-f3ba-4a50-ace2-c980a0246290', '114', 146.0]]

done Opt-outs on record in hapi-fhir

0 subject(s) have an active Consent that denies research use (EHDS Art. 71). Recorded in the PHR (UC-04); the research query must honour it.

Open in the sandbox →
Show payload
```
(none yet — run UC-04 in the PHR to see the count change)
```
done The cohort the researcher may use in ehrbase

4 observations remain; 0 removed because their subject opted out. The opt-out is enforced at query time by the access body, not by deleting data.
Show payload
```
[124.0, 131.0, 146.0, 146.0]
```
done What leaves the secure environment in ehrbase

A data permit (UC-14) grants access inside a secure processing environment; only aggregates leave it. Here: mean systolic 136.8 mm[Hg] over 4 observations — no record-level data.

Staged records: research cohort: 4 observations

← Back to Accessing health data for research Run it again