Changes
Jump to navigation
Jump to search
← Older edit
Trial Data Project
(view source)
Revision as of 13:44, 21 September 2020
1,393 bytes added
,
13:44, 21 September 2020
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 ==
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']
Ed
Bureaucrats
,
Interface administrators
,
Administrators (Semantic MediaWiki)
,
Administrators
7,647
edits
Navigation menu
Personal tools
Log in
Request account
Namespaces
Page
Discussion
Variants
Views
Read
View source
View history
More
Search
Navigation
Sites
Wiki
Articles
Sections
Projects
Papers in Development
Paper Reviews
Team Members
Legislation
Research Computing
Organizations
Incubator Project
McNair Center
Berkeley's BPP Group
NBER Patent Data
Help
General help
Team help
Administration
Batch Upload Files
Tools
Special pages