-
Notifications
You must be signed in to change notification settings - Fork 3
/
bq_import_info.txt
131 lines (128 loc) · 5.2 KB
/
bq_import_info.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
In order to import the full EUCTR scrape to BQ without errors the settings must be as follows:
Source Format: CSV
Delimiter: ,
Skip Leading Rows: 1
Allow Quoted Newlines: true
Then you must use the following custom schema using the "Edit as Text" field:
eudract_number_with_country:STRING,
date_of_competent_authority_decision:DATE,
trial_dose_response:BOOLEAN,
trial_others:BOOLEAN,
trial_the_trial_involves_single_site_in_the_member_state_concer:BOOLEAN,
subject_women_of_childbearing_potential_not_using_contraception:BOOLEAN,
clinical_trial_type:STRING,
trial_is_part_of_a_paediatric_investigation_plan:BOOLEAN,
trial_open:BOOLEAN,
trial_cross_over:BOOLEAN,
placebos:STRING,
member_state_concerned:STRING,
trial_primary_end_point_s:STRING,
trial_trial_being_conducted_both_within_and_outside_the_eea:BOOLEAN,
trial_therapy:BOOLEAN,
trial_single_blind:BOOLEAN,
trial_secondary_objectives_of_the_trial:STRING,
end_of_trial_status:STRING,
ethics_committee_opinion_of_the_trial_application:STRING,
trial_the_trial_involves_multiple_sites_in_the_member_state_con:BOOLEAN,
meta_updated:TIMESTAMP,
trial_trial_contains_a_sub_study:BOOLEAN,
trial_prophylaxis:BOOLEAN,
meta_created:TIMESTAMP,
trial_therapeutic_use_phase_iv:BOOLEAN,
national_competent_authority:STRING,
subject_pregnant_women:BOOLEAN,
eudract_number:STRING,
subject_male:BOOLEAN,
meta_source:STRING,
trial_in_the_member_state_concerned_years:INTEGER,
trial_safety:BOOLEAN,
trial_therapeutic_exploratory_phase_ii:BOOLEAN,
trial_diagnosis:BOOLEAN,
trial_human_pharmacology_phase_i:BOOLEAN,
trial_bioequivalence_study:BOOLEAN,
subject_healthy_volunteers:BOOLEAN,
trial_the_trial_involves_multiple_member_states:BOOLEAN,
trial_efficacy:BOOLEAN,
trial_principal_exclusion_criteria:STRING,
meta_id:STRING,
trial_medical_condition_s_being_investigated:STRING,
trial_pharmacogenomic:BOOLEAN,
trial_bioequivalence:BOOLEAN,
trial_pharmacodynamic:BOOLEAN,
sponsors:STRING,sponsor_s_protocol_code_number:STRING,
trial_first_administration_to_humans:BOOLEAN,
trial_pharmacogenetic:BOOLEAN,
trial_therapeutic_confirmatory_phase_iii:BOOLEAN,
subject_in_the_member_state:INTEGER,
date_on_which_this_record_was_first_entered_in_the_eudract_data:DATE,
subject_others:BOOLEAN,
trial_controlled:BOOLEAN,
trial_trial_being_conducted_completely_outside_of_the_eea:BOOLEAN,
trial_placebo:BOOLEAN,
subject_subjects_incapable_of_giving_consent_personally:BOOLEAN,
subject_in_the_eea:INTEGER,
subject_women_of_childbearing_potential_using_contraception:STRING,
trial_principal_inclusion_criteria:STRING,
imps:STRING,
trial_parallel_group:BOOLEAN,
trial_pharmacoeconomic:BOOLEAN,
trial_status:STRING,
trial_condition_being_studied_is_a_rare_disease:STRING,
subject_in_the_whole_clinical_trial:INTEGER,
trial_other_medicinal_product_s:BOOLEAN,
competent_authority_decision:STRING,
subject_female:BOOLEAN,
trial_pharmacokinetic:BOOLEAN,
full_title_of_the_trial:STRING,
trial_in_all_countries_concerned_by_the_trial_years:INTEGER,
subject_nursing_women:BOOLEAN,
trial_double_blind:BOOLEAN,
trial_trial_has_a_data_monitoring_committee:BOOLEAN,
subject_emergency_situation:BOOLEAN,
trial_randomised:BOOLEAN,
subject_specific_vulnerable_populations:BOOLEAN,
subject_patients:BOOLEAN,
trial_main_objective_of_the_trial:STRING,
date_of_ethics_committee_opinion:DATE,
trial_in_all_countries_concerned_by_the_trial_months:INTEGER,
trial_definition_of_the_end_of_the_trial_and_justification_wher:STRING,
trial_in_the_member_state_concerned_months:INTEGER,
name_or_abbreviated_title_of_the_trial_where_available:STRING,
subject_plans_for_treatment_or_care_after_the_subject_has_ended:STRING,
subject_details_of_subjects_incapable_of_giving_consent:STRING,
trial_version:STRING,
trial_level:STRING,
trial_classification_code:INTEGER,
isrctn_international_standard_randomised_controlled_trial_numbe:STRING,
trial_comparator_description:STRING,
trial_number_of_sites_anticipated_in_the_eea:INTEGER,
date_of_the_global_end_of_the_trial:DATE,
trial_number_of_sites_anticipated_in_member_state_concerned:INTEGER,
trial_term:STRING,
trial_other_trial_design_description:STRING,
trial_other_trial_type_description:STRING,
trial_other_scope_of_the_trial_description:STRING,
trial_full_title_date_and_version_of_each_sub_study_and_their_r:STRING,
trial_therapeutic_area:STRING,
trial_system_organ_class:STRING,
trial_number_of_treatment_arms_in_the_trial:INTEGER,
trial_in_the_member_state_concerned_days:INTEGER,
subject_childs:INTEGER,
subject_details_of_other_specific_vulnerable_populations:BOOLEAN,
trial_in_all_countries_concerned_by_the_trial_days:INTEGER,
subject_elderly:INTEGER,
us_nct_clinicaltrials_gov_registry_number:STRING,
trial_medical_condition_in_easily_understood_language:STRING,
title_of_the_trial_for_lay_people_in_easily_understood_i_e_non_:STRING,
subject_adults:INTEGER,
trial_secondary_end_point_s:STRING,
trial_if_e_8_6_1_or_e_8_6_2_are_yes_specify_the_regions_in_whic:STRING,
trial_timepoint_s_of_evaluation_of_this_end_point:STRING,
ethics_committee_opinion_reason_s_for_unfavourable_opinion:STRING,
ema_decision_number_of_paediatric_investigation_plan:STRING,
trial_specify_the_countries_outside_of_the_eea_in_which_trial_s:STRING,
who_universal_trial_reference_number_utrn:STRING,
other_identifiers:STRING,
trial_results:STRING,
trial_other:STRING,
trial_results_url:STRING