SQL Query
Run read-only queries against the clinical database.
Preset Queries
Schema
studies
subjects
visits
forms
form_fields
form_data
visit_data
audit_logs
edit_checks
Query Editor
20 rows · 6 columns · 12ms
| subject_id | site_id | status | field_name | field_value | created_at |
|---|---|---|---|---|---|
| TEST-001 | 001 | active | systolic_bp | 122 | 2025-03-01 14:31:55 |
| TEST-001 | 001 | active | diastolic_bp | 78 | 2025-03-01 14:31:55 |
| TEST-001 | 001 | active | heart_rate | 74 | 2025-03-01 14:31:55 |
| TEST-001 | 001 | active | wbc_10e9_l | 6.8 | 2025-03-01 14:30:12 |
| TEST-001 | 001 | active | hemoglobin_g_dl | 13.2 | 2025-02-28 09:14:22 |
| TEST-001 | 001 | active | creatinine_umol_l | 82 | 2025-02-28 09:15:44 |
| TEST-001 | 001 | active | alt_u_l | 35 | 2025-01-30 14:18:09 |
| TEST-001 | 001 | active | qtcf_ms | 412 | 2025-01-22 13:55:30 |