Changes

NSF Data (view source)

607 bytes added , 16:32, 20 June 2017

no edit summary

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:

*Award ID

*AwardTitle

*AwardEffectiveDate

*AwardExpirationDate

*AwardAmount

*AwardInstrument

*Organization Code

*Organization Directorate

*Organization Division

*ProgramOfficer

*AbstractNarration

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.

Coverage appears good 1968-2017.

==Sample XML==

Sample XML schema

76

edits