==General==Working with <onlyinclude>The [[Federal Grant Data]] project collects and processes [[NIHData]], [[NSFData]], and other federal grant datainformation from structured government sources and imports it into a relational database for use. See also: The [[Trial Data Project]] and the [[FDA Trials Data]] project.</onlyinclude>
==Latest Update==
*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 *STTR: https://www.nsf.gov/awardsearch/lookup?type=program&qrytxt=*STTR**SBIR: https://www.nsf.gov/awardsearch/lookup?type=program&qrytxt=*SBIR*