<commit_before>SELECT 
	cs.nct_id, cs.start_date, cs.completion_date, cs.completion_date_type, cs.firstreceived_date, 
	cs.brief_title, cs.overall_status, cs.phase, cs.study_type, cs.number_of_arms, cs.number_of_groups, cs.enrollment, cs.is_fda_regulated, 
	i.INTERVENTION_TYPE,
	s.agency, s.agency_class, s.any_industry, s.num_sponsors,
	l.country, l.country_class, l.num_countries,
	d.intervention_model, d.masking, d.primary_purpose, d.observational_model, d.time_perspective, d.allocation, d.endpoint
FROM clinical_study cs
JOIN hiv_studies h ON cs.nct_id = h.nct_id
JOIN interventions_simple_mod i on i.nct_id = h.nct_id
JOIN sponsors_mod s ON s.nct_id = h.nct_id
JOIN location_mod l ON l.nct_id = h.nct_id
JOIN design_mod d on d.nct_id = h.nct_id;
<commit_msg>more SQL to extract data for ph241 group<commit_after># HIV ONLY STUDIES
SELECT 
	cs.nct_id, cs.start_date, cs.completion_date, cs.completion_date_type, cs.firstreceived_date, 
	cs.brief_title, cs.overall_status, cs.phase, cs.study_type, cs.number_of_arms, cs.number_of_groups, cs.enrollment, cs.is_fda_regulated, 
	i.INTERVENTION_TYPE,
	s.agency, s.agency_class, s.any_industry, s.num_sponsors,
	l.country, l.country_class, l.num_countries,
	d.intervention_model, d.masking, d.primary_purpose, d.observational_model, d.time_perspective, d.allocation, d.endpoint
FROM clinical_study cs
JOIN hiv_studies h ON cs.nct_id = h.nct_id
JOIN interventions_simple_mod i on i.nct_id = h.nct_id
JOIN sponsors_mod s ON s.nct_id = h.nct_id
JOIN location_mod l ON l.nct_id = h.nct_id
JOIN design_mod d on d.nct_id = h.nct_id;

# ALL INTERVENTIONAL STUDIES
SELECT 
	cs.nct_id, cs.start_date, cs.completion_date, cs.completion_date_type, cs.firstreceived_date, 
	cs.brief_title, cs.overall_status, cs.phase, cs.number_of_arms, cs.number_of_groups, cs.enrollment, cs.is_fda_regulated, 
	i.INTERVENTION_TYPE,
	s.agency, s.agency_class, s.any_industry, s.num_sponsors,
	l.country, l.country_class, l.num_countries,
	d.intervention_model, d.masking, d.primary_purpose, d.observational_model, d.time_perspective, d.allocation, d.endpoint
FROM clinical_study cs
JOIN interventions_simple_mod i on i.nct_id = cs.nct_id
JOIN sponsors_mod s ON s.nct_id = cs.nct_id
JOIN location_mod l ON l.nct_id = cs.nct_id
JOIN design_mod d on d.nct_id = cs.nct_id
WHERE cs.study_type = 'Interventional';



{'fraction_non_alphanumeric': 0.09425878320479864, 'fraction_numerical': 0.0012853470437017994, 'mean_word_length': 5.577464788732394, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '1517334', 'n_tokens_mistral': 1002, 'n_tokens_neox': 942, 'n_words': 196}