7,612
edits
Changes
Jump to navigation
Jump to search
no edit summary
{{Project|Has project output=Data|Has sponsor=McNair ProjectsCenter
|Has title=NSF Data
|Has owner=Catherine Kirby,
|Has start date=03/31/17
|Has keywords=NSF,
|Has project status=ActiveSubsume
}}
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.
Data is located in:
E:\McNair\Projects\Federal Grant Data\NSF
The three data files are:
grant_award_general_info.txt - 394,610 rows
grant_award_institution_info.txt
grant_award_investigator_info.txt
grant_award_general_info.txt includes:
*Award ID
*AwardTitle
*AwardEffectiveDate
*AwardExpirationDate
*AwardAmount
*AwardInstrument
*Organization Code
*Organization Directorate
*Organization Division
*ProgramOfficer
*AbstractNarration
grant_award_institution_info.txt includes the following:
*Award ID
*Institution Name
*Institution CityName
*Institution ZipCode
*Institution Phone#
*Institution Street Address
*Institution Country Name
*Institution State Name
*Institution State Code
grant_award_investigator_info includes the following:
*Award ID
*Investigator First Name
*Investigator Last Name
*Investigator Email Address
*StartDate
*Investigator Role Code
Data is currently loaded into dbase '''biotech'''.
The load script and some processing is in:
Z:\Biotech\biotech.sql
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.
==Sample XML==
Sample XML schema
