Changes

Jump to navigation Jump to search
In April 2019, Ed updated the NSF and NIH data.
===NSF=== The update process was:
*Visit https://www.nsf.gov/awardsearch/download.jsp
*Retrieve 2017, 2018, and 2019 zips to E:\projects\grants\NSF
*Run LoadNSF.sql to to product tables NSFGeneral, NSFInvestigator and NSFInstitution in dbase '''grants'''
===NIH=== The update process was:
*Visit https://exporter.nih.gov/ExPORTER_Catalog.aspx
*Retrieve 2016, 2017, and 2018 csvs to E:\projects\grants\NIH\Source Files

Navigation menu