Using the Clinical Collections Application
- What sorts of things can I do in the Clinical Collections application?
- What views are available for me to explore?
- Can I sort the data?
- Can I export the data in my collection?
- Can I share my collection with others?
- How do I build a Clinical Collection?
- How do I refine the data displayed in the Collection Views?
- How can I get a new view of the data?
- Can I save my collection?
- How can I learn more about the collection that someone has sent me?
- What do bookmarklets let me do?
- What is the source of the data?
- How often is the data refreshed and kept current?
- Are you looking at other data types or sources?
- How big can a collection be?
- What is MeSH?
- Some ct.gov fields are not displayed, such as inclusion/exclusion criteria. Where are they?
- I do not see trial results. How can I see the results?
- The data is a bit messy, is it possible to have it cleaned up such as typos or upper/lower case?
- Why can’t I use Internet Explorer?
- What export formats are available?
- What technologies did you use to create Clinical Collections?
- What type of support do you offer?
- Is there someone I can talk to about the Clinical Collections application?
Clinical Collections How-To Video
Applied Clinical Collections
Clinical Collections Bookmarklet
Using the Clinical Collections Application
What sorts of things can I do in the Clinical Collections application?
Build a collection. The Clinical Collections app makes it easy to build and customize your own collection of clinical information using data housed in Clinical Collections. Today, the more than 124,000 clinical trials cataloged in the NIH clinicaltrials.gov registry have been imported into Clinical Collections for use in your collections.
Explore your collection. Once you have built a collection, you can easily explore it to find answers and gain insights. Filtering a Collection is simple and the resulting set of trials can be visualized in maps, timelines, and tables. You can bookmark your customized collections for later use.
Share your collection. Lastly, we have made it simple for you to share your customized collection with colleagues and community members.
How do I build a clinical collection?
Building a collection is easy. Simply search for trials. You can do a Google style term search or browse the topic index. The data for each trial will be assembled into a dataset that you can explore with the Collection Viewer. This viewer will allow you to explore, refine, and share a variety of interactive visualizations, including maps, timelines, listings, and tables.
What views are available for me to explore?
The main panel in the Collection Viewer has 5 views that you can select: Listing, Summary, Outcomes Table, Timeline by Phases, and Map by Phase. The views are interactive, so we encourage you to play around with the features in each one.
How do I refine the data displayed in the Collection Views?
The simplest way is with Keyword Search. This narrows the data displayed in the views by matching text across all the data in your collection. You also can filter with precision. To do this, open filters in the left column of the Collection Viewer and select the particular data you want. All of the views will automatically update to reflect your selected refinements. As you set filters, notice that the number of matching items changes in the views.
Can I sort the data?
Yes. The Listing, Summary, and Outcome Table Views allow sorting. You can also group results by your sort criteria.
How can I get a new view of the data?
What do bookmarklets let me do?
- Read about bookmarklets here
- Get Bookmarklets here
- Demonstration video: Clinical Collections Bookmarklets
Can I export the data in my collection?
Yes. Click the orange scissors icon to export. This icon appears when you move your mouse into any of the Collection Views. It also appears in the filters used to refine data. This feature is really handy for getting your hands on individual lists such as trial ids, locations, interventions or sponsors. When exporting, select Tab Separated Values if you want to import into a spreadsheet.
Can I save my collection?
Yes. Simply bookmark the page with your web browser. The bookmark will open the collection with the same filter settings and view. Please note that our trial data is refreshed nightly. As a result, over time the data in your views will automatically change to reflect additions or updates to data in Clinical Collections.
Can I share my collection with others?
Yes. We have made it simple for you to share your customized collection with colleagues and community members with the Share This button at the bottom of the page. You can also share the URL via email or send it to your favorite networks including Twitter, Facebook, and Linkedin. Our Twitter handle is @Lilly_COI.
How can I learn more about the collection that someone has sent me?
Click the “About Collection” link.
What is the source of the data?
Trial data is sourced from the clinicaltrial.gov public trial registry.
How often is the data refreshed and kept current?
We refresh the clinical collections every day, matching the refresh frequency of the clinicaltrials.gov data.
Are you looking at other data types or sources?
Yes. We intend to grow the data in Clinical Collections, eventually allowing you to build, explore, and share Clinical Collections with drug information, site/lab information, and regulatory actions. Our prioritization will come largely through your feedback and community needs.
back to top | go to Clinical Collections
How big can a collection be?
The Clinical Collections software is designed to handle collections of up to 1,500 items. When opening a collection that is too big you will be ask to filter the collection to a smaller set of items.
What is MeSH?
Medical Subject Headings (MeSH) is the National Library of Medicine’s controlled vocabulary thesaurus. MeSH terms are applied by clinicaltrials.gov to the condition and intervention data attributes. MeSH is a helpful categorization thesaurus to harmonize data, especially where the raw data is represented in many different ways. A good example is ACS, Acute Cardiac Syndrome, Acute Coronary Syndrome all are harmonized in MeSH as Acute Coronary Syndrome.
Learn more about MeSH.
Some ct.gov fields are not displayed, such as inclusion/exclusion criteria. Where are they?
We have chosen to keep collection data as lean as possible for performance reasons. You can click through to the source record in clinicaltrials.gov to see all the trial data.
I do not see trial results. How can I see the results?
We have not imported trial results into Clinical Collections at this time. We do provide links to results when they exist. Please note that you can use the “Results” filter to limit the data to only those with results posted in ClinicalTrials.gov.
The data is a bit messy, is it possible to have it cleaned up such as typos or upper/lower case?
Clinical Collections display data as it was entered at clinicaltrials.gov by the trial sponsor. In future releases, we will provide tools and workflows to support curation and annotation.
back to top | go to Clinical Collections
Why can’t I use Internet Explorer?
We want your experience to be productive. Internet Explorer is not fast enough to support our Clinical Collections application. Chrome and Firefox are supported and Safari should work as well. If you must use IE, our application is designed to utilize the Google IE browser plug-in (ChromeFrame).
What export formats are available?
Data displayed in the Collection Views can be exported in Tab Separated Values (good for excel), Semantic wikitext, and Exhibit JSON. Data listed in filters can be copied to your clipboard and then pasted into any application including a spreadsheet.
What technologies did you use to create Clinical Collections?
What type of support do you offer?
The Lilly Clinical Open Innovation team is a small team. We have designed the Clinical Collections application to minimize support needs and maximize self-service. The servers are designed to autoscale on demand. We monitor the system for uptime and any system errors. If you have any questions, please Contact Us and let us know how we can help.