SQL playground
Run SQL on the whole dataset, right here in your browser. The database downloads once (about 4 MB) and every query runs on your own computer. Nothing you type is sent to a server.
The table
One table, trials, with columns: nct_id, title, status, phase, sponsor, conditions, interventions, start_date, completion_date, why_stopped, category, also, non_scientific, confidence, enrollment, enrollment_type. non_scientific is 1 for funding, enrollment, supply, regulatory or logistics reasons. enrollment_type is A for actual and E for estimated. Labels are automatic and unverified; see the methodology.
About this
This is SQLite running as WebAssembly (the open-source sql.js, hosted on this site, nothing loaded from elsewhere), so use SQLite's SQL dialect. Queries that run longer than 20 seconds are stopped, and at most 500 rows are shown. You can also download the database or the CSV and use DuckDB, pandas or any tool you like.