<commit_before>HEADER,NULL
NUM_REG_PARTICIPANTS,'select count(catissue_coll_prot_reg.participant_id) from catissue_coll_prot_reg,catissue_specimen_protocol where catissue_coll_prot_reg.collection_protocol_id=catissue_specimen_protocol.identifier and catissue_specimen_protocol.identifier =? and catissue_specimen_protocol.activity_status=''Active'' and catissue_coll_prot_reg.activity_status=''Active'''
NUM_MALE_PARTICIPANTS,'select count(catissue_participant.identifier)from catissue_participant,catissue_coll_prot_reg where catissue_participant.identifier=catissue_coll_prot_reg.participant_id and catissue_participant.gender=''Male Gender'' and catissue_coll_prot_reg.collection_protocol_id=?'
NUM_FEMALE_PARTICIPANTS,'select count(catissue_participant.identifier)from catissue_participant,catissue_coll_prot_reg where catissue_participant.identifier=catissue_coll_prot_reg.participant_id and catissue_participant.gender=''Female Gender'' and catissue_coll_prot_reg.collection_protocol_id=?'
NUM_ALIVE_PARTICIPANTS,'select count(catissue_participant.identifier)from catissue_participant,catissue_coll_prot_reg where catissue_participant.identifier=catissue_coll_prot_reg.participant_id and catissue_participant.vital_status=''Alive'' and catissue_coll_prot_reg.collection_protocol_id=?'
NUM_DEAD_PARTICIPANTS,'select count(catissue_participant.identifier)from catissue_participant,catissue_coll_prot_reg where catissue_participant.identifier=catissue_coll_prot_reg.participant_id and catissue_participant.vital_status=''Dead''and catissue_coll_prot_reg.collection_protocol_id=?'
NUM_CONSENTED_PARTICIPANT,'select count(DISTINCT catissue_participant.identifier)from catissue_participant,catissue_coll_prot_reg,catissue_consent_tier_response where catissue_participant.identifier=catissue_coll_prot_reg.participant_id and catissue_coll_prot_reg.identifier=catissue_consent_tier_response.coll_prot_reg_id and catissue_participant.activity_status=''Active'' and catissue_coll_prot_reg.activity_status=''Active'' and catissue_consent_tier_response.response NOT IN ('Not Specified') and catissue_coll_prot_reg.collection_protocol_id=?'
NUM_WHITE_RACE_PARTICIPANTS,'select count(catissue_participant.identifier)from catissue_participant,catissue_coll_prot_reg,catissue_race where catissue_participant.identifier=catissue_coll_prot_reg.participant_id and catissue_coll_prot_reg.participant_id=catissue_race.participant_id and catissue_participant.activity_status=''Active'' and catissue_coll_prot_reg.activity_status=''Active''and catissue_race.race_name=''White''and catissue_coll_prot_reg.collection_protocol_id=?'
NUM_ASIAN_RACE_PARTICIPANTS,'select count(catissue_participant.identifier)from catissue_participant,catissue_coll_prot_reg,catissue_race where catissue_participant.identifier=catissue_coll_prot_reg.participant_id and catissue_coll_prot_reg.participant_id=catissue_race.participant_id and catissue_participant.activity_status=''Active''and catissue_coll_prot_reg.activity_status=''Active''and catissue_race.race_name=''Asian''and catissue_coll_prot_reg.collection_protocol_id=?'
NUM_AME_IND_OR_ALASKA_NATIVE,'select count(catissue_participant.identifier)from catissue_participant,catissue_coll_prot_reg,catissue_race where catissue_participant.identifier=catissue_coll_prot_reg.participant_id and catissue_coll_prot_reg.participant_id=catissue_race.participant_id and catissue_participant.activity_status=''Active''and catissue_coll_prot_reg.activity_status=''Active''and catissue_race.race_name=''American Indian or Alaska Native''and catissue_coll_prot_reg.collection_protocol_id=?'
NUM_BLACK_OR_AFRICAN_AMERICAN,'select count(catissue_participant.identifier)from catissue_participant,catissue_coll_prot_reg,catissue_race where catissue_participant.identifier=catissue_coll_prot_reg.participant_id and catissue_coll_prot_reg.participant_id=catissue_race.participant_id and catissue_participant.activity_status=''Active''and catissue_coll_prot_reg.activity_status=''Active''and catissue_race.race_name=''Black or African American''and catissue_coll_prot_reg.collection_protocol_id=?'
NUM_NATIVE_HAWAIIAN_OR_PACIFIC_ISLANDER,'select count(catissue_participant.identifier)from catissue_participant,catissue_coll_prot_reg,catissue_race where catissue_participant.identifier=catissue_coll_prot_reg.participant_id and catissue_coll_prot_reg.participant_id=catissue_race.participant_id and catissue_participant.activity_status=''Active''and catissue_coll_prot_reg.activity_status=''Active''and catissue_race.race_name=''Native Hawaiian or Other Pacific Islander''and catissue_coll_prot_reg.collection_protocol_id=?'
NUM_COMPLETE_SCG,'select count(catissue_specimen_coll_group.identifier) from catissue_specimen_coll_group,catissue_abs_speci_coll_group,catissue_coll_prot_reg where catissue_specimen_coll_group.collection_protocol_reg_id=catissue_coll_prot_reg.identifier and catissue_abs_speci_coll_group.IDENTIFIER=catissue_specimen_coll_group.IDENTIFIER and catissue_coll_prot_reg.collection_protocol_id=? and catissue_abs_speci_coll_group.ACTIVITY_STATUS=''Active'' and catissue_coll_prot_reg.activity_status=''Active'' and catissue_specimen_coll_group.collection_status=''Complete'''
NUM_PENDING_SCG,'select count(catissue_specimen_coll_group.identifier) from catissue_specimen_coll_group,catissue_abs_speci_coll_group,catissue_coll_prot_reg where catissue_specimen_coll_group.collection_protocol_reg_id=catissue_coll_prot_reg.identifier and catissue_abs_speci_coll_group.IDENTIFIER=catissue_specimen_coll_group.IDENTIFIER and catissue_coll_prot_reg.collection_protocol_id=? and catissue_abs_speci_coll_group.ACTIVITY_STATUS=''Active'' and catissue_coll_prot_reg.activity_status=''Active'' and catissue_specimen_coll_group.collection_status=''Pending'''
NUM_PENDING_SPECIMEN,'select count(catissue_specimen.identifier)from catissue_specimen,catissue_specimen_coll_group,catissue_coll_prot_reg where catissue_specimen.specimen_collection_group_id=catissue_specimen_coll_group.identifier and catissue_specimen_coll_group.collection_protocol_reg_id=catissue_coll_prot_reg.identifier and catissue_specimen.activity_status=''Active''and catissue_coll_prot_reg.activity_status=''Active''and catissue_coll_prot_reg.collection_protocol_id=? and catissue_specimen.collection_status=''Pending'''
NUM_CELL_SPECIMEN_COLLECTED,'select count(catissue_specimen.identifier)from catissue_specimen,catissue_cell_specimen,catissue_specimen_coll_group,catissue_coll_prot_reg where catissue_specimen.identifier=catissue_cell_specimen.identifier and catissue_specimen.specimen_collection_group_id=catissue_specimen_coll_group.identifier and catissue_specimen_coll_group.collection_protocol_reg_id=catissue_coll_prot_reg.identifier and catissue_specimen.activity_status=''Active''and catissue_coll_prot_reg.activity_status=''Active''and catissue_coll_prot_reg.collection_protocol_id=? and catissue_specimen.collection_status=''Collected'''
NUM_TISSUE_SPECIMEN_COLLECTED,'select count(catissue_specimen.identifier)from catissue_specimen,catissue_tissue_specimen,catissue_specimen_coll_group,catissue_coll_prot_reg where catissue_specimen.identifier=catissue_tissue_specimen.identifier and catissue_specimen.specimen_collection_group_id=catissue_specimen_coll_group.identifier and catissue_specimen_coll_group.collection_protocol_reg_id=catissue_coll_prot_reg.identifier and catissue_specimen.activity_status=''Active''and catissue_coll_prot_reg.activity_status=''Active''and catissue_coll_prot_reg.collection_protocol_id=? and catissue_specimen.collection_status=''Collected'''
NUM_FLUID_SPECIMEN_COLLECTED,'select count(catissue_specimen.identifier)from catissue_specimen,catissue_fluid_specimen,catissue_specimen_coll_group,catissue_coll_prot_reg where catissue_specimen.identifier=catissue_fluid_specimen.identifier and catissue_specimen.specimen_collection_group_id=catissue_specimen_coll_group.identifier and catissue_specimen_coll_group.collection_protocol_reg_id=catissue_coll_prot_reg.identifier and catissue_specimen.activity_status=''Active''and catissue_coll_prot_reg.activity_status=''Active''and catissue_coll_prot_reg.collection_protocol_id=? and catissue_specimen.collection_status=''Collected'''<commit_msg>updated query for consent count. (on behalf of <NAME>).<commit_after>HEADER,NULL
NUM_REG_PARTICIPANTS,'select count(catissue_coll_prot_reg.participant_id) from catissue_coll_prot_reg,catissue_specimen_protocol where catissue_coll_prot_reg.collection_protocol_id=catissue_specimen_protocol.identifier and catissue_specimen_protocol.identifier =? and catissue_specimen_protocol.activity_status=''Active'' and catissue_coll_prot_reg.activity_status=''Active'''
NUM_MALE_PARTICIPANTS,'select count(catissue_participant.identifier)from catissue_participant,catissue_coll_prot_reg where catissue_participant.identifier=catissue_coll_prot_reg.participant_id and catissue_participant.gender=''Male Gender'' and catissue_coll_prot_reg.collection_protocol_id=?'
NUM_FEMALE_PARTICIPANTS,'select count(catissue_participant.identifier)from catissue_participant,catissue_coll_prot_reg where catissue_participant.identifier=catissue_coll_prot_reg.participant_id and catissue_participant.gender=''Female Gender'' and catissue_coll_prot_reg.collection_protocol_id=?'
NUM_ALIVE_PARTICIPANTS,'select count(catissue_participant.identifier)from catissue_participant,catissue_coll_prot_reg where catissue_participant.identifier=catissue_coll_prot_reg.participant_id and catissue_participant.vital_status=''Alive'' and catissue_coll_prot_reg.collection_protocol_id=?'
NUM_DEAD_PARTICIPANTS,'select count(catissue_participant.identifier)from catissue_participant,catissue_coll_prot_reg where catissue_participant.identifier=catissue_coll_prot_reg.participant_id and catissue_participant.vital_status=''Dead''and catissue_coll_prot_reg.collection_protocol_id=?'
NUM_CONSENTED_PARTICIPANT,'select count(DISTINCT catissue_participant.identifier)from catissue_participant,catissue_coll_prot_reg,catissue_consent_tier_response where catissue_participant.identifier=catissue_coll_prot_reg.participant_id and catissue_coll_prot_reg.identifier=catissue_consent_tier_response.coll_prot_reg_id and catissue_participant.activity_status=''Active'' and catissue_coll_prot_reg.activity_status=''Active'' and catissue_consent_tier_response.response NOT IN (''Not Specified'') and catissue_coll_prot_reg.collection_protocol_id=?'
NUM_WHITE_RACE_PARTICIPANTS,'select count(catissue_participant.identifier)from catissue_participant,catissue_coll_prot_reg,catissue_race where catissue_participant.identifier=catissue_coll_prot_reg.participant_id and catissue_coll_prot_reg.participant_id=catissue_race.participant_id and catissue_participant.activity_status=''Active'' and catissue_coll_prot_reg.activity_status=''Active''and catissue_race.race_name=''White''and catissue_coll_prot_reg.collection_protocol_id=?'
NUM_ASIAN_RACE_PARTICIPANTS,'select count(catissue_participant.identifier)from catissue_participant,catissue_coll_prot_reg,catissue_race where catissue_participant.identifier=catissue_coll_prot_reg.participant_id and catissue_coll_prot_reg.participant_id=catissue_race.participant_id and catissue_participant.activity_status=''Active''and catissue_coll_prot_reg.activity_status=''Active''and catissue_race.race_name=''Asian''and catissue_coll_prot_reg.collection_protocol_id=?'
NUM_AME_IND_OR_ALASKA_NATIVE,'select count(catissue_participant.identifier)from catissue_participant,catissue_coll_prot_reg,catissue_race where catissue_participant.identifier=catissue_coll_prot_reg.participant_id and catissue_coll_prot_reg.participant_id=catissue_race.participant_id and catissue_participant.activity_status=''Active''and catissue_coll_prot_reg.activity_status=''Active''and catissue_race.race_name=''American Indian or Alaska Native''and catissue_coll_prot_reg.collection_protocol_id=?'
NUM_BLACK_OR_AFRICAN_AMERICAN,'select count(catissue_participant.identifier)from catissue_participant,catissue_coll_prot_reg,catissue_race where catissue_participant.identifier=catissue_coll_prot_reg.participant_id and catissue_coll_prot_reg.participant_id=catissue_race.participant_id and catissue_participant.activity_status=''Active''and catissue_coll_prot_reg.activity_status=''Active''and catissue_race.race_name=''Black or African American''and catissue_coll_prot_reg.collection_protocol_id=?'
NUM_NATIVE_HAWAIIAN_OR_PACIFIC_ISLANDER,'select count(catissue_participant.identifier)from catissue_participant,catissue_coll_prot_reg,catissue_race where catissue_participant.identifier=catissue_coll_prot_reg.participant_id and catissue_coll_prot_reg.participant_id=catissue_race.participant_id and catissue_participant.activity_status=''Active''and catissue_coll_prot_reg.activity_status=''Active''and catissue_race.race_name=''Native Hawaiian or Other Pacific Islander''and catissue_coll_prot_reg.collection_protocol_id=?'
NUM_COMPLETE_SCG,'select count(catissue_specimen_coll_group.identifier) from catissue_specimen_coll_group,catissue_abs_speci_coll_group,catissue_coll_prot_reg where catissue_specimen_coll_group.collection_protocol_reg_id=catissue_coll_prot_reg.identifier and catissue_abs_speci_coll_group.IDENTIFIER=catissue_specimen_coll_group.IDENTIFIER and catissue_coll_prot_reg.collection_protocol_id=? and catissue_abs_speci_coll_group.ACTIVITY_STATUS=''Active'' and catissue_coll_prot_reg.activity_status=''Active'' and catissue_specimen_coll_group.collection_status=''Complete'''
NUM_PENDING_SCG,'select count(catissue_specimen_coll_group.identifier) from catissue_specimen_coll_group,catissue_abs_speci_coll_group,catissue_coll_prot_reg where catissue_specimen_coll_group.collection_protocol_reg_id=catissue_coll_prot_reg.identifier and catissue_abs_speci_coll_group.IDENTIFIER=catissue_specimen_coll_group.IDENTIFIER and catissue_coll_prot_reg.collection_protocol_id=? and catissue_abs_speci_coll_group.ACTIVITY_STATUS=''Active'' and catissue_coll_prot_reg.activity_status=''Active'' and catissue_specimen_coll_group.collection_status=''Pending'''
NUM_PENDING_SPECIMEN,'select count(catissue_specimen.identifier)from catissue_specimen,catissue_specimen_coll_group,catissue_coll_prot_reg where catissue_specimen.specimen_collection_group_id=catissue_specimen_coll_group.identifier and catissue_specimen_coll_group.collection_protocol_reg_id=catissue_coll_prot_reg.identifier and catissue_specimen.activity_status=''Active''and catissue_coll_prot_reg.activity_status=''Active''and catissue_coll_prot_reg.collection_protocol_id=? and catissue_specimen.collection_status=''Pending'''
NUM_CELL_SPECIMEN_COLLECTED,'select count(catissue_specimen.identifier)from catissue_specimen,catissue_cell_specimen,catissue_specimen_coll_group,catissue_coll_prot_reg where catissue_specimen.identifier=catissue_cell_specimen.identifier and catissue_specimen.specimen_collection_group_id=catissue_specimen_coll_group.identifier and catissue_specimen_coll_group.collection_protocol_reg_id=catissue_coll_prot_reg.identifier and catissue_specimen.activity_status=''Active''and catissue_coll_prot_reg.activity_status=''Active''and catissue_coll_prot_reg.collection_protocol_id=? and catissue_specimen.collection_status=''Collected'''
NUM_TISSUE_SPECIMEN_COLLECTED,'select count(catissue_specimen.identifier)from catissue_specimen,catissue_tissue_specimen,catissue_specimen_coll_group,catissue_coll_prot_reg where catissue_specimen.identifier=catissue_tissue_specimen.identifier and catissue_specimen.specimen_collection_group_id=catissue_specimen_coll_group.identifier and catissue_specimen_coll_group.collection_protocol_reg_id=catissue_coll_prot_reg.identifier and catissue_specimen.activity_status=''Active''and catissue_coll_prot_reg.activity_status=''Active''and catissue_coll_prot_reg.collection_protocol_id=? and catissue_specimen.collection_status=''Collected'''
NUM_FLUID_SPECIMEN_COLLECTED,'select count(catissue_specimen.identifier)from catissue_specimen,catissue_fluid_specimen,catissue_specimen_coll_group,catissue_coll_prot_reg where catissue_specimen.identifier=catissue_fluid_specimen.identifier and catissue_specimen.specimen_collection_group_id=catissue_specimen_coll_group.identifier and catissue_specimen_coll_group.collection_protocol_reg_id=catissue_coll_prot_reg.identifier and catissue_specimen.activity_status=''Active''and catissue_coll_prot_reg.activity_status=''Active''and catissue_coll_prot_reg.collection_protocol_id=? and catissue_specimen.collection_status=''Collected'''
{'fraction_non_alphanumeric': 0.06559766763848396, 'fraction_numerical': 0.0, 'mean_word_length': 20.750330250990753, 'pattern_counts': {'":': 0, '<': 4, '<?xml version=': 0, '>': 4, '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': '6603051', 'n_tokens_mistral': 5378, 'n_tokens_neox': 5176, 'n_words': 473}