7,612
edits
Changes
Jump to navigation
Jump to search
no edit summary
{{Project
|Has project output=Data,Tool
|Has sponsor=McNair Center
|Has title=Trial Data Project
|Has owner=Jeemin Sim, Catherine Kirby,
|Has project status=Complete
}}
==Summary==
This project works out how to reprocess the Clinical Trial Data from ClinicalTrials.gov into structured and cleaned datasets. The data covers 239,638 studies from 2000 to present.
== Information Source ==
* https://clinicaltrials.gov/ct2/resources/download
* https://clinicaltrials.gov/ct2/html/images/info/public.xsd
== Steps Followed to Extract the Trial Data ==
<mesh_term>Nifedipine</mesh_term>
</intervention_browse>
== File locations ==
The files/code that I have worked on all exist in this folder: E:\McNair\Projects\FDA Trials\Jeemin_Project
Trials per zipcode:
code: Jeemin_Trials_per_zipcode.py
output: Jeemin_Trials_per_zipcode_output.txt
General data ripping:
code: Jeemin_FDATrial_as_key_data_ripping.py
output: Jeemin_FDATrial_as_key_data.ripping_output.txt
== Tables ==
Table 1:
row_headers1 = ['nct_id', 'brief title', 'oversight authority', 'brief summary',
'detailed description', 'overall status', 'start date', 'completion date', 'phase',
'study type', 'study design', 'condition', 'intervention type', 'intervention name',
'eligibility description','eligibility gender', 'eligibility min age',
'eligibility max age', 'verification date', 'lastchanged date', 'firstreceived date',
'has expanded access']
Table 2:
row_headers2 = ['nct_id', 'sponsor agency', 'sponsor class', 'lead or collaborator']
Table 3:
row_headers3 = ['nct_id', 'facility name', 'city', 'state', 'zip', 'country']
Table 4:
row_headers4 = ['nct_id', 'MeSH term']
Table 5:
row_headers5 = ['nct_id', 'keyword']
