135
edits
Changes
Jump to navigation
Jump to search
Data The file which contains the number of trials in each city and year is located in: Z:\Hubs\2017
File The name of the file is ctrialsSummary.txtIt contains: ctrialsdata*city*yearDatabase is '''cities'''*city_state_yearSQL script is: merged_ctrials.sql*noctrials - number of trials
→Joined clinical trials data
===Joined clinical trials data===
The ctrials is joined with vc_city_state_year.
The joined SQL script is: merged_ctrials.sql
It contains:
*City city*State state*City_state_id city_state_id*City_state_year city_state_year*Year year*Phase noctrials*Zip code seedamtm*Founding_yearearlyamtm*lateramtm*selamtm*numseeds*numearly*numlater*numsel
==Population Data==
