init_notebook_modetrusted

Interactive Search¶

Welcome to our interactive search page¶

Cancer Data Aggregator is an effort to unite data of multiple types by indexing, harmonizing and aggregating data from multiple data centers. CDA makes these varied datasets uniformly searchable by a common set of terms, regardless of modeling differences at the original source.

This page contains a full listing of all subjects in CDA and many of their categorical values, to allow you to search interactively on this website. For detailed instructions on using this tool, click here.

To interact with the entire CDA dataset including numerical subject values, more categorical values, and data about the types of files associated with all of these subjects, you will need to use cdapython directly.

Search Tool¶

Loading ITables v2.7.3 from the init_notebook_mode cell... (need help?)

Data sources¶

Data is currently is curated from:

Need more data to search?¶

Our database contains much more data than is available on this page. To search everything with minimal setup try our low-code, no-install notebooks or contact us for individualized help.

Is this the final product?¶

No. CDA is actively working to provide in-browser search across our entire database, and we hope to share it with you soon. This is just a teaser :)

Questions and Comments¶

If you have questions, comments or suggestions about our data, interface, or anything else, please email us at cancerdataaggregator @ gmail.com

Interactive search instructions¶

The page should load with a simple search already filled in, which is filtering the table below to only have subjects with a primary_diagnosis_condition that contains the word "adenocarcinoma"

Quick start¶

You can change this filter to anything you like, or clear it and build your own. The table will automatically filter to whatever search settings you give it, as soon as the settings are selected. You don't need to hit enter or to "start" the search in any way. Just change search settings and the table will respond.

Saving your results¶

The search settings will reset to the default whenever you reload the page, so if you find interesting results, you might want to save them for later. At the bottom of the table you will find three buttons: copy, CSV, and Excel. Click copy to save the results to your clipboard and paste them anywhere. the CSV and Excel buttons will download a copy of the results table to your computer in the requested format.

Search Builder functions:¶

`Clear All`¶

This will remove all of the current search conditions (but will not reset the free-text search box)

`Add Condition`¶

Allows you to add a search condition. Clicking it will bring up three selector boxes, which must be filled in order from left to right:

Add Condition:`Data`¶

Choose the name of a column

Add Condition:`Condition`¶

Choose how you want to filter that column

Add Condition: `Value`¶

Type or choose the value you want to filter on, for that column. If you chose the Empty or Not Empty condition, the Value box will not appear

And (the vertical box)¶

This box will get taller and taller as you add more conditions to your search. You can change its behavior at anytime by clicking it, wich will change it from And to an Or. Clicking the small x in the bottom right corner of this box will delete the box, and all of the conditions nested inside of it

Or¶

To apply an Or condition, click the And box that corrosponds to the search parameters you want to Or

> ¶

This is a nesting button. It allows you to make arbitrarily complex queries with both Ands and Ors. Let's say you want to find women with adenocarcinomas of the breast or lymph nodes. You might start by doing this: But if you just add another condition for lymph node, it will add it to your And, instead, push the > button next to breast: Now the primary_diagnosis_site part of the query is nested, and has it's own Add Condition button. Use it to add lymph node: and finally, click the nested And to change it to an Or:

x ¶

Clicking this will delete the corrosponding line