There is a new button that allows visitors to download the set of trials as a CSV.
If you do a search, say “vigabatrin,” then let the viewer load, then in the “Tools” box at the left, there’s a button labelled “Download as CSV.” If you click that, after a second or two, a download link labelled “Link” will appear.
To be strict, this is a tab-delimited file, not a CSV, but I figure most people will be able to figure this out.
This tool will come in handy if you want to parse a set of clinicaltrials.gov records in R or something, since R doesn’t read XML files as nicely.
Haven’t been here in a while, huh?
Things that I have recently fixed:
- Up until today, the programme that downloaded FDA approvals information and updated the database had stopped working. This was frustrating, because this way my go-to tool for getting FDA documents. Now it works again!
- A while back I inadvertently broke the indication searcher by adding a counter to the drug searcher. This is fixed now too!
New in version 0.17 comes the ability to add and remove basic tags to starred trials. The tags don’t do anything yet, but soon they will be awesome.
Also, you can now sort by end dates. This will be useful to me personally very soon.
You’ll notice that when you’re logged in, stars now appear in every trial that has been graphed. If you click the star (or press ‘s’ while the trial’s details are visible), the star will light up, and a “Starred trials” box will appear at the left. It’s kind of boring right now, because the only button available is the “hide” button, but even that can be useful!
Imagine if you wanted to highlight only certain trials, say only phase 3 trials for RCC of the drug in question. You could sort it by phase, go through all the phase 3’s and star the ones you’re interested in. But wait! You don’t want to hide those ones—you want to hide all the others! I’ve got you covered. Click where it says “Invert starred,” and all the starred trials will be unstarred and previously unstarred trials will be starred instead. Then you can click “Hide (h)” (or push the ‘h’ button) and all those trials will disappear.
If you want them back again, click “Show hidden trials” from the “Tools” box.
And here’s the fun part: if you’re working on a saved search, the site remembers which trials you have hidden, so you could annotate it and send the permalink of your graph to a colleague if you found something interesting.
Some users have found the panel along the left side with the study details to be difficult to use if the screen they’re using isn’t tall enough. Other users whose screen is tall enough to accommodate the entire box don’t like it because it constrains the content and they have to scroll through to see it all.
Now, there are in-line boxes that pop out of the bottom of each study as they are clicked on, which provide more details about the study.
Along the top of each search, if there have been regulatory actions by the FDA, there are now links to documents regarding those actions. For example, if you search for “pralatrexate,” you’ll notice it says “Approval” in September of 2009. You can click the link and it will bring you to an FDA document—the label for pralatrexate.
The site now allows signed-in users to attach annotations to their searches. Try it out! (You must have an account to use this feature.)
There have been some big changes since the last version. First off, you’ll notice that you can make accounts and sign in now. This is so that you can save searches, rather than just sort of keeping permalinks to searches written on napkins or whatever.
- Searches are now automatically deleted after two weeks, unless a user has saved it
- Saved searches appear on the user’s sign-in screen, under “saved searches”
- You can email the permalink to the search to yourself or tweet it to others directly from the saved searches page
- Others can still view your saved searches without being signed in, so you can send the link to your saved search, and the recipient doesn’t need to sign up to view it
- When viewing the result of a query, the year labels are fixed, so they don’t interrupt the flow of the graph
Also, I fixed a bug with the “important dates” line—they would approximately hit the bottom of the graph, but never quite exactly. Now they’re fixed.
Two new things in v 0.11:
- If you search for an indication area, before you view a drug’s full graph, the site now gives you a few pieces of information (the number of studies, the highest phase number of the selected set of studies, and the last end date).
- If you click on the title bar for the “Tools” box or the “Select a study” box or the “Legend” box (when coloured by sponsor), this collapses the box into the title bar. This is useful, in case you’re working on a computer with a small display.