Difference between revisions of "Trial Data Project"
Jump to navigation
Jump to search
| Line 5: | Line 5: | ||
All the historical USPTO data is available as XML files. Here is the tree structure for the XML files: | All the historical USPTO data is available as XML files. Here is the tree structure for the XML files: | ||
| − | -<clinical_study rank="61205"> | + | -<clinical_study rank="61205"> |
:+<required_header> | :+<required_header> | ||
:+<id_info> | :+<id_info> | ||
:<brief_title> | :<brief_title> | ||
| − | +<sponsors> | + | :+<sponsors> |
| − | <source> | + | :<source> |
| − | +<oversight_info> | + | :+<oversight_info> |
| − | +<brief_summary> | + | :+<brief_summary> |
| − | +<detailed_description> | + | :+<detailed_description> |
| − | <overall_status>Completed</overall_status> | + | :<overall_status>Completed</overall_status> |
| − | <phase>Phase 1/Phase 2</phase> | + | :<phase>Phase 1/Phase 2</phase> |
| − | <study_type> | + | :<study_type> |
| − | <study_design> | + | :<study_design> |
| − | <condition> | + | :<condition> |
| − | +<intervention> | + | :+<intervention> |
| − | +<eligibility> | + | :+<eligibility> |
| − | +<location> | + | :+<location> |
| − | +<location_countries> | + | :+<location_countries> |
| − | <verification_date> | + | :<verification_date> |
| − | <lastchanged_date> | + | :<lastchanged_date> |
| − | <firstreceived_date> | + | :<firstreceived_date> |
| − | <has_expanded_access> | + | :<has_expanded_access> |
| − | +<condition_browse> | + | :+<condition_browse> |
| − | +<intervention_browse> | + | :+<intervention_browse> |
| + | |||
| + | |||
| + | Corresponding tables are: | ||
| + | *assignment-records : assignment | ||
| + | *patent-assignors : assignors | ||
| + | *patent-assignees : assignees | ||
| + | *patent-properties : properties | ||
Revision as of 16:22, 13 February 2017
Steps Followed to Extract the Trial Data
Extracting Data from XML Files
All the historical USPTO data is available as XML files. Here is the tree structure for the XML files:
-<clinical_study rank="61205">
- +<required_header>
- +<id_info>
- <brief_title>
- +<sponsors>
- <source>
- +<oversight_info>
- +<brief_summary>
- +<detailed_description>
- <overall_status>Completed</overall_status>
- <phase>Phase 1/Phase 2</phase>
- <study_type>
- <study_design>
- <condition>
- +<intervention>
- +<eligibility>
- +<location>
- +<location_countries>
- <verification_date>
- <lastchanged_date>
- <firstreceived_date>
- <has_expanded_access>
- +<condition_browse>
- +<intervention_browse>
Corresponding tables are:
- assignment-records : assignment
- patent-assignors : assignors
- patent-assignees : assignees
- patent-properties : properties
