*Date from 1986-2015
===Joined NIH table===
The joined nsf table with the VC table is found in db '''cities'''. The table is named '''merged_nih'''.
All the values of nih_valuegrant and nih_nogrants with missing values for years 1986-2015 are set equal to 0.
The sql script is in
Z:\HUbs\2017\sql scripts
==Clinical Trials Data==