Changes

Jump to navigation Jump to search
107 bytes added ,  14:30, 26 June 2017
Database is '''cities'''
 
 
SQL script is: nsf_2017.sql
 
 
The source file is nsf2017.txt, copied from table titled '''nsf''' in the biotech db.
 
 
It contains:
*Award ID
Output file is nsfSummary.txt. It contains:
*Variables: City, year, nogrants, valuegrant,
*1900-2017
 
Cities are not unique. Eg. NEW YORK and New York are two different cities. Need to merge their data.
*3854 cities
76

edits

Navigation menu