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 limited, curated dataset that consists of the searchable categorical values for all subjects who have data at more than one data center, (e.g. GDC and PDC, or CDS, PDC and IDC).
This dataset best demonstrates the power of CDAs database, and by reducing the data to this curated set, we can make it searchable in your browser. For detailed instructions on using this tool, click here.
Search Tool¶
data_sources | ethnicity | race | sex | species | vital_status | cause_of_death | research_project | primary_diagnosis_condition | primary_diagnosis_site | anatomical_site | primary_disease_type | source_material_type | researchsubject_id | researchsubject_data_source_id | id_data_source | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
subject_id | ||||||||||||||||
Loading... (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 And
s and Or
s.
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