NYSgptData LibraryConnectPricing

National Science Foundation

Awards by year, 1959 to 2024.

483KRecords
1Tables
98Fields
CurrentYears

Publisher: National Science Foundation

Try it

This runs against the full table, free, with no key.

Tables
Fields in nsf_awards
FieldTypeExample
agencystringNSF
awardeffectivedatestring06/30/1967
awardexpirationdatestring05/31/1969
awardtotalintnamountstring216800.00
awardamountstring216800
valuestringContract-BOA/Task Order
codestring07000000 | 1410 | 5519
abbreviationstringENG | ENG
longnamestringDirectorate For Engineering | Directorate For Engineering
signblocknamestringname not available
minamdletterdatestring06/24/1964
maxamdletterdatestring06/16/1975
tran_typestringGrant
cfda_numstring47.041
nsf_par_use_flagstring0
fund_agcy_codestring4900
awdg_agcy_codestring4900
awardidstring6400006
firstnamestringNelson
lastnamestringGrisamore
pi_mid_initstringT
pi_full_namestringNelson T Grisamore
nsf_idstring000124263
startdatestring06/30/1967
rolecodestringPrincipal Investigator
namestringNational Academy of Sciences
citynamestringWASHINGTON
zipcodestring204180007
phonenumberstring2023342254
streetaddressstring2101 CONSTITUTION AVE NW
countrynamestringUnited States
statenamestringDistrict of Columbia
statecodestringDC
congressdistrictstring00
congress_district_orgstringDC00
org_uei_numstringPKFJZHG2MLG9
org_lgl_bus_namestringNATIONAL ACADEMY OF SCIENCES
congress_district_perfstring""
textstringENG SCI IN CHEM,BIOCHEM & THER | FIRE RESEARCH
fund_oblgstring1964~10000 | 1975~22000
record_xmlstring<Award> <AwardTitle><![CDATA[Support of the Committee on Fir
source_filestringlake/v1/grants/raw/nsf-awards/2026-11-14/1964.zip :: 6400006
awardtitlestringContract For Administrative Services in Support of
emailaddressstringjbradbur@usgs.gov
pi_phonstring0000000
org_prnt_uei_numstringPKFJZHG2MLG9
org_duns_numstring089522580
org_prnt_duns_numstring161906193
pi_sufx_namestringJr.
countryflagstring1
countrycodestringUS
enddatestring
countynamestringCOOK
po_emaistringmwasko@nsf.gov
po_phonstring7032924749
app_symb_idstring
fund_symb_idstring040100
enddateepochstring
recentpiflagstring
idstring
streetaddress2string
abstractnarrationstringThe broader impact of this I-Corps project is based on the d
strongstring
h5string
pstring
arraamountstring
substring
emstring
spanstring
listring
divstring
astring
supstring
h4string
prestring
h1string
ttstring
h3string
h2string
insstring

18 more fields; select the table above to list them all.

Connect

Claude

Settings, Connectors, Add custom connector. Paste this address:

https://data.nysgpt.com/mcp

Claude Code

claude mcp add --transport http nysgpt-data https://data.nysgpt.com/mcp

HTTP

curl -s https://data.nysgpt.com/query -H "content-type: application/json" \
  -d '{"sql":"SELECT count(*) FROM govblock_awards.usaspending_contracts"}'

Any MCP client works. The tools are list_databases, list_tables, describe_table and query (Athena SQL, read-only, up to 1,000 rows a query). With a paid key, add ?key=YOUR_KEY to the address or send the header X-Api-Key.

Pricing

Free

$0

30 queries a day, 1 GB scanned per query. No key, no sign-up.

Connect

Day pass

$29

300 queries and 100 GB scanned in 24 hours. One payment.

Buy a day pass

Monthly

$149/month

2,000 queries and 200 GB scanned a day. Cancel any time.

Subscribe

Institution

$1,500/month

20,000 queries and 1 TB scanned a day, for a lab, department or team.

Subscribe

Payment is by card through Stripe. The key appears on screen as soon as payment completes.

More in Research Grants