Match another 100 Trials #41

Open
opened 3 years ago by youainti · 1 comments
youainti commented 3 years ago (Migrated from gitea.kgjk.icu)

Match another 100 trials, i.e. move from 400 to 500 hand matched trials

Match another 100 trials, i.e. move from 400 to 500 hand matched trials

to get a count of trials that have been successfully hand matched, run:

select count(distinct nct_id ) 
from "DiseaseBurden".trial_to_icd10 tti 
where approved = 'accepted'

to get a count of trials with formatted data:

select count(distinct nct_id) from formatted_data fd;
to get a count of trials that have been successfully hand matched, run: ```sql select count(distinct nct_id ) from "DiseaseBurden".trial_to_icd10 tti where approved = 'accepted' ``` to get a count of trials with formatted data: ```sql select count(distinct nct_id) from formatted_data fd; ```
Sign in to join this conversation.
No Milestone
No project
No Assignees
1 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: youainti/ClinicalTrialsDataProcessing#41
Loading…
There is no content yet.