NSF Data - Revision history

Ed at 17:41, 21 September 2020

2020-09-21T17:41:45Z

2020-09-21T17:34:20Z

2020-09-20T17:20:07Z

2020-09-20T17:12:20Z

2017-10-31T15:10:03Z

2017-06-21T17:55:23Z

2017-06-21T17:49:58Z

2017-06-20T21:18:16Z

2017-06-20T20:32:55Z

2017-04-03T18:18:01Z

@@ Line 1: / Line 1: @@
 {{Project
-|Has project output=
+|Has project output=Data
 |Has sponsor=McNair Center
 |Has title=NSF Data

@@ Line 1: / Line 1: @@
 {{Project
 |Has sponsor=McNair Center
 |Has title=NSF Data

@@ Line 1: / Line 1: @@
 {{Project
 |Has title=NSF Data
 |Has owner=Catherine Kirby,

@@ Line 1: / Line 1: @@
-{{McNair Projects
+{{Project
 |Has title=NSF Data
 |Has owner=Catherine Kirby,

@@ Line 4: / Line 4: @@
 |Has start date=03/31/17
 |Has keywords=NSF,
-|Has project status=Active
+|Has project status=Subsume
 }}
 Each folder by year has around 10,000 awards. While the total number of awards seems to be less than NIH, the downloads appear to have been done properly. The categories in the grant award by institution include: Award ID, Institution Name, Institution City Name, Institution Zipcode, Institution Phone, instituion street address, instituion country name, Instiution State Name, and Institution state code. Currently this data is available on the RDP but has not been put in a data base. Catherine has used primarily the zipcodes in the file for her project.

@@ Line 48: / Line 48: @@
 *Institution State Name
 *Institution State Code
 grant_award_investigator_info includes the following:
@@ Line 65: / Line 66: @@
   Z:\Biotech\biotech.sql
-Note that only grant_award_institution_info appears to be loaded.
+Note that only grant_award_institution_info appears to be loaded. Data related to grant_award_general is probably loaded in table nsfgeneral and data related to grants_awards_investigator is in table nsfinvestigator.
 Coverage appears good 1968-2017.

@@ Line 23: / Line 23: @@
   grant_award_investigator_info.txt
-grant_award_general_info.txt:
+grant_award_general_info.txt includes:
 *Award ID
 *AwardTitle
@@ Line 36: / Line 36: @@
 *AbstractNarration
@@ Line 45: / Line 66: @@
 Note that only grant_award_institution_info appears to be loaded.
 Coverage appears good 1968-2017.

@@ Line 17: / Line 17: @@
 Data is located in:
   E:\McNair\Projects\Federal Grant Data\NSF
 Sample XML schema

@@ Line 6: / Line 6: @@
 |Has project status=Active
 }}
 ==NSF Grant Data==