Z:\Hubs\2017
The file is in: Z:\Hubs\2017\clean dataThe name of the file is :
ctrialsSummary.txt
It contains:
*city
*noctrials - number of trials
The ctrials is joined with VC table ('''vc_city_state_year'''). The joined SQL script is: '''new_ctrials.sql'''The name of the joined file is '''new_merged_ctrials'''.
It contains: