Difference between revisions of "Trial Data Project"

From edegan.com
Jump to navigation Jump to search
Line 9: Line 9:
 
     +<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>
  
  

Revision as of 16:26, 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