76
edits
Changes
Jump to navigation
Jump to search
It containsThey contain:
Cities are not unique. Eg. NEW YORK and New York are two different cities. Need to merge their data.
*3854 cities
→NSF Data
SQL script is: nsf_2017.sql
The source file is files are: nsf2017.txt, copied from table titled '''nsf''' in , and nsf_institution copied from table '''nsf_grants_institution''' from the biotech db.
*Award ID
*Award Institution
*Institution city
*Award Value
*Organization state code
From 1900 - 2017
Output file is nsfSummary.txt. It contains:
*Variables: City, State code year, nograntsnsf_nogrants, valuegrant nsf_valuegrant
*1900-2017
==NIH Data==
