|
Industry-sponsored Drug Trials within last X years (random sample of 10)
This is a sample query that pulls just 10 rows at random from a filtered list of industry-sponsored, FDA-regulated drug clinical trials. |
September 03, 2024 |
|
Example: clinical trial duration (@henryweimd)
PostgreSQL query to take 5 random studies and return their NCT ID, brief titles and the trial duration based on start date and completion date. - Henry Wei MD |
July 25, 2024 |
|
MitraClip
Clinical investigations on MitraClip |
June 24, 2024 |
|
New Trial Query
new trial query |
April 30, 2024 |
|
Test2
Test2 |
November 28, 2023 |
|
Test1
Test1 |
November 28, 2023 |
|
IBD query
IBD query |
October 24, 2023 |
|
j
k |
October 17, 2023 |
|
Studies Database
see the studies database |
October 12, 2023 |
|
Leads
Querying all study |
September 06, 2023 |
|
get lead sponsor
get lead sponsor |
May 26, 2023 |
|
query result
query result |
May 24, 2023 |
|
Fetch mesh values
Fetch mesh values |
May 24, 2023 |
|
get conditions
get conditions |
May 24, 2023 |
|
Phase 1 query
Research which compounds are in phase 1 |
May 13, 2023 |
|
Phase 3 Cancer Trials Using Trastuzumab
Phase 3 cancer (conditions table) trials using the Trastuzumab drug. Study table has a phase column. Filter studies that are interventional (study_type) and are running a drug trial. |
February 15, 2023 |
|
Breast Cancer Trials From Mayo Clinic
Clinical trials from sponsor "Mayo Clinic" with condition "Breast Cancer". |
February 13, 2023 |
|
Example Covid Query
We search for the word "covid" in different fields (nct_id, brief_title, description, etc.) |
February 13, 2023 |