{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["Table contents from SQL database"],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Table contents from SQL database","index":0,"n_rows":114,"n_cols":3,"rows_kept":114,"merged":[[0,0,0,2]],"flags":["formulas_cached_only"]}
["Additional File 3. The schema of the SQLite database"]
[]
["Table Number","Main table name","Field names from CTRI"]
[1,"BasicDetails","ctri_number"]
[null,null,"primarykey"]
[null,null,"status_of_reg"]
[null,null,"year_of_reg"]
[null,null,"last_modified_on"]
[null,null,"post_graduate_thesis"]
[null,null,"type_of_trial"]
[null,null,"type_of_study"]
[null,null,"study_design"]
[null,null,"public_title_of_study"]
[null,null,"scientific_title_of_study"]
[null,null,"secondary_id"]
[null,null,"identifier"]
[null,null,"source_of_monetary"]
[null,null,"countries_of_recruitment"]
[null,null,"regulatory_clearance_status"]
[null,null,"phase_of_trial"]
[null,null,"date_of_first_enrollment_india"]
[null,null,"date_of_study_completion_india"]
[null,null,"date_of_first_enrollment_global"]
[null,null,"date_of_study_completion_global"]
[null,null,"recruitment_status_of_trial_global"]
[null,null,"recruitment_status_of_trial_india"]
[null,null,"noofsites"]
[null,null,"noofethicalcommittees"]
[null,null,"final_enrollment_numbers_total"]
[null,null,"final_enrollment_numbers_india"]
[null,null,"total_sample_size"]
[null,null,"sample_size_from_india"]
[null,null,"method_of_generating_random_sequence"]
[null,null,"method_of_concealment"]
[null,null,"blinding_masking"]
[null,null,"primary_outcome_details"]
[null,null,"primary_outcome_timeline"]
[null,null,"secondary_outcome_details"]
[null,null,"secondary_outcome_timeline"]
[null,null,"brief_summary"]
[]
[2,"ContactPublicQuery","ctri_number"]
[null,null,"primarykey"]
[null,null,"name"]
[null,null,"designation"]
[null,null,"email"]
[null,null,"fax"]
[null,null,"phone"]
[null,null,"address"]
[null,null,"city"]
[null,null,"state"]
[null,null,"pin"]
[null,null,"country"]
[null,null,"affiliation"]
[]
[3,"ContactScientificQuery","ctri_number"]
[null,null,"primarykey"]
[null,null,"name"]
[null,null,"designation"]
[null,null,"email"]
[null,null,"fax"]
[null,null,"phone"]
[null,null,"address"]
[null,null,"city"]
[null,null,"state"]
[null,null,"pin"]
[null,null,"country"]
[null,null,"affiliation"]
[]
[4,"PrincipalInvestigatorDetails","ctri_number"]
[null,null,"primarykey"]
[null,null,"name"]
[null,null,"designation"]
[null,null,"email"]
[null,null,"fax"]
[null,null,"phone"]
[null,null,"address"]
[null,null,"city"]
[null,null,"state"]
[null,null,"pin"]
[null,null,"country"]
[null,null,"affiliation"]
[]
[5,"SitesOfStudy","ctri_number"]
[null,null,"primarykey"]
[null,null,"site"]
[null,null,"address"]
[null,null,"state"]
[null,null,"Name"]
[null,null,"city"]
[]
[6,"EthicalCommittee","ctri_number"]
[null,null,"primarykey"]
[null,null,"status"]
[null,null,"Name"]
[]
[7,"PrimarySponsor","ctri_number"]
[null,null,"primarykey"]
[null,null,"name"]
[null,null,"typeofsponsor"]
[null,null,"address"]
[]
[8,"HealthCondition","ctri_number"]
[null,null,"primarykey"]
[null,null,"health_type"]
[null,null,"condition"]
[]
[9,"InclusionExclusion","ctri_number"]
[null,null,"primarykey"]
[null,null,"inclusion_age_from"]
[null,null,"inclusion_age_to"]
[null,null,"inclusion_gender"]
[null,null,"inclusion_details"]
[null,null,"exclusion"]