Clinical Trial Metrics from ct.gov

Approach

In order to provide a consistent and automated review, the following has been developed.

• A monthly automated download of the entire CT.GOV site (1st of the month)
• Parsing and creating a database of all the trials data (402,977 as of 2/1/2022)
• We are then able to develop reports of snapshots of current state
• We are then able to develop trending reports/graphs over time of of F&MCW and selected peers.

Rules

The following rules are being used for overall metrics, analysis and trending.

• Facility is located in the United States (~210 countries are represented)
• Study Type is Interventional
• Enrollment for those >17 years of age
• Facility name is not blank
• Facility state is not blank
• Study is
  • Recruiting
  • Not Yet Recruiting
  • Enrolling by Invitation
  • Null
• Facility is
  • Recruiting
  • Not Yet Recruiting
  • Enrolling by Invitation
  • Null

Challenges

• There are approximately 30,000 distinctly named facility locations after the previous rules are applied
• There are
  • Misspellings
  • Case insensitive names
  • Clinic names included in the site name
  • Numerous other variations that cause challenges