7,649
edits
Changes
Jump to navigation
Jump to search
→NSF
*Extract them to E:\projects\grants\NSF\XML
*Remove 3 bad XML files that cause the parser to crash
*Run Move the whole thing back to E:\mcnair\Projects\Federal Grant Data\NSF\NSF Extracted Data*Fix up and run Jeemin_NSF_XML_Parser.py*Add new data to old, removing dups so that it also takes ProgramElement (see below) and creating three filesmake:**general.txt**institutions.txt**investigators.txt*Run LoadNSF.sql to to product produce tables NSFGeneral, NSFInvestigator and NSFInstitution in dbase '''grants'''
Note that SBIR '''program_code'''s are available from https://www.nsf.gov/awardsearch/lookup?type=program&qrytxt=*SBIR*
