Snowflake Marketplace

US Federal Research Grants and the Papers That Acknowledge Them

NIH and NSF research awards from USAspending.gov, linked to the research papers that print each award number in their funding acknowledgments, with recipients, dollars obligated from fiscal 2016 on and NIH principal investigators, updated weekly.

357,777NIH and NSF awards
5.5Maward-paper links
2.5Mpapers
Weeklyupdated
About this dataset

What’s in the listing

The National Institutes of Health (NIH) and the National Science Foundation (NSF) report their grant awards to USAspending.gov. Research papers name the grants they thank in a funding acknowledgment, often with the award number, and OpenAlex, the open catalog of research papers, records those numbers. This listing links each NIH and NSF award to the papers that print its number. The award records and the papers share no common ID, so Civly makes the links from the printed numbers. A link means the paper acknowledges the award. It does not show that the award paid for the work, so read the links as papers acknowledging an award, not papers produced by it.

Three views. AWARDS has one row per award: award number, agency, NIH institute or NSF directorate, recipient with its Unique Entity ID, city and state, title, dollars obligated from fiscal 2016 on, award and project dates, principal investigators for NIH awards, the kind of grant, and the number of papers that acknowledge it. AWARD_PAPERS has one row per award and paper, with the rule that made the link and the award number exactly as the paper printed it. PAPERS has one row per paper: DOI, title, year, type, venue, citations, retraction flag, and author institutions and countries.

Common uses: universities and research offices comparing the papers that acknowledge their awards with peer institutions, foundations and evaluators tracing the papers that thank a funding program, policy groups studying acknowledged output by agency, institute, directorate and state, and companies selling to research institutions finding recipients and investigators by subject, dollars and published work.

FactDetail
SourceUSAspending.gov (U.S. Department of the Treasury), NIH RePORTER and ExPORTER (U.S. government works) and OpenAlex (CC0), linked by Civly
Coverage357,777 NIH and NSF awards (220,631 NIH, 137,146 NSF), 5,479,375 award-paper links and 2,494,820 papers. 175,520 NIH awards (79.6%) and 88,932 NSF awards (64.8%) have at least one acknowledging paper
PeriodAwards in Civly’s USAspending.gov copy, which starts in federal fiscal year 2016. Dollar figures cover fiscal 2016 on only. Papers from every year in OpenAlex. Awards starting in fiscal 2025 or later are still gathering papers (INCOMPLETE_YEARS)
RefreshWeekly, every Monday. Civly checks the sources daily and rebuilds the links when one has changed: USAspending.gov publishes nightly, NIH ExPORTER monthly and OpenAlex in quarterly releases. UPDATED_AT gives when Civly last built each row
Free trial30 days, every award to a Massachusetts recipient (RECIPIENT_STATE = 'MA') with those awards’ links and papers: 29,063 awards and 484,859 award-paper links
SubscriptionEvery award, link and paper, billed yearly
Join keyAWARD_NUMBER joins AWARDS and AWARD_PAPERS. PAPER_ID (OpenAlex work ID) joins AWARD_PAPERS and PAPERS. RECIPIENT_UEI and DOI join to other data
Permitted useNot for employment, tenant, credit, insurance or licensing decisions about a person. Civly is not a consumer reporting agency.
Coverage

How much is in each view

Row counts as of November 15, 2026.

ViewRowsOne row perSource
AWARDS357,777Award: 220,631 NIH, 137,146 NSFUSAspending.gov, with NIH RePORTER and ExPORTER
AWARD_PAPERS5,479,375Award and paperAward numbers printed in OpenAlex papers, linked by Civly
PAPERS2,494,820PaperOpenAlex
ViewGroupRowsWhat it means
AWARDSAGENCY NIH220,631National Institutes of Health awards. 175,520 (79.6%) have at least one acknowledging paper. $342.5 billion obligated from fiscal 2016 on
AWARDSAGENCY NSF137,146National Science Foundation awards. 88,932 (64.8%) have at least one acknowledging paper. $81.6 billion obligated from fiscal 2016 on
AWARDSGRANT_KIND project276,587Research project awards
AWARDSGRANT_KIND training51,833Training awards
AWARDSGRANT_KIND small_business18,918Small-business research awards
AWARDSGRANT_KIND facility5,676Shared facility and resource awards. Thanked by many papers from outside the funded team
AWARDSGRANT_KIND center4,763Center awards. Thanked by many papers from outside the funded team
AWARD_PAPERSHOW_MATCHED grant type, institute and serial4,200,152NIH. The paper printed the full NIH number: the grant type, institute code and serial all match the award
AWARD_PAPERSHOW_MATCHED institute and serial (another phase of the same project)124,161NIH. The institute code and serial match, printed with the grant type of another phase of the same project
AWARD_PAPERSHOW_MATCHED institute and serial (grant type not printed; paper lists an NIH or HHS funder)273,008NIH. The paper printed the institute code and serial with no grant type, and lists NIH or HHS among its funders
AWARD_PAPERSHOW_MATCHED NSF award number (paper lists NSF, OpenAlex files the number under NSF)882,054NSF. The paper printed a standalone 7-digit award number, lists NSF among its funders, and OpenAlex files the number under NSF

Reading the data

A link means the paper printed the award number in its funding acknowledgments. Count the links as papers acknowledging an award, not papers produced by it.

Center, facility and shared-data grants are thanked by many papers from outside the funded team, so their paper counts do not measure one team’s output. Use GRANT_KIND to separate them. The sample queries below keep GRANT_KIND = 'project' only.

AWARD_PAPERS has one row per award per paper. A paper that thanks three awards appears three times, and adding ACKNOWLEDGING_PAPER_COUNT across those awards counts it three times. Count DISTINCT PAPER_ID to count papers.

OBLIGATED_USD_FY2016_ON counts dollars obligated from federal fiscal year 2016 on, because Civly’s USAspending.gov copy starts there. For a project that began earlier, the dollars leave out the earlier years while ACKNOWLEDGING_PAPER_COUNT counts papers from every year, so papers per dollar runs high for those projects.

Awards starting in fiscal 2025 or later have INCOMPLETE_YEARS set to true. Papers appear after an award starts, so their counts are still growing. Leave them out when comparing output.

PRINCIPAL_INVESTIGATORS and CONTACT_PI are filled for NIH awards only. INSTITUTE_CODE is empty for NSF.

Accuracy

How the matching checks out

Every link between an award and a paper comes from the paper’s own printed grant numbers, as OpenAlex records them. Civly matches those numbers to NIH and NSF award numbers in USAspending.gov. HOW_MATCHED records which rule made each link, and AWARD_STRING_AS_PRINTED keeps the number exactly as the paper printed it.

NIH (4,597,321 links): a printed number links when its institute code and serial match an award, as HL and 158192 do in R01HL158192, and the grant type also matches, belongs to another phase of the same project, or is not printed. When no grant type is printed, the link is made only if the paper lists NIH or HHS among its funders.

NSF (882,054 links): a printed number links only when it is a standalone 7-digit award number, the paper lists NSF among its funders, and OpenAlex files that number under NSF.

Papers published more than a year before the project started (PROJECT_START_DATE) are dropped. Peer reviews, datasets, supplements, errata, retraction notices and dissertations are dropped.

Before this build, Civly checked 70 randomly chosen links by hand. Of 40 NIH links, 34 were right, 1 was wrong and 5 could not be confirmed either way. Of 30 NSF links, 27 were right, none were wrong and 3 could not be confirmed either way. Right means the names, institution and subject on the paper are consistent with the award. The links were not checked against the grants’ own reports.

How many acknowledging papers are missed is unknown, because there is no answer key listing every paper that thanks each award. A paper is not linked when it does not print the award number, when OpenAlex did not record the number, or when the number is printed in a form these rules do not read. Awards starting in fiscal 2025 or later are incomplete because papers lag awards. Dollar figures cover fiscal 2016 on only.

Schemas

Data dictionary

Three views, 41 columns in total: AWARDS, AWARD_PAPERS and PAPERS. The same views serve the trial and the subscription. During the free trial they return every award to a Massachusetts recipient (RECIPIENT_STATE = 'MA'), with those awards’ rows in AWARD_PAPERS and their papers in PAPERS. A subscription adds every other award.

Schema

Data dictionary: AWARDS

One row per NIH or NSF award: award number, agency, institute or directorate, recipient, title, dollars, award and project dates, principal investigators, grant kind and the number of acknowledging papers. 23 columns. Dollar columns are in US dollars.

ColumnTypeMeaning
AWARD_NUMBERTEXTAward number as USAspending carries it: the NIH core project number (e.g. R01HL158192) or the 7-digit NSF award id.
AWARD_IDTEXTUSAspending’s award identifier.
AGENCYTEXTNIH or NSF.
INSTITUTE_CODETEXTTwo-letter NIH institute code from the project number (e.g. HL, CA). Empty for NSF.
CFDA_NUMBERTEXTFederal assistance listing (CFDA) number of the program.
INSTITUTE_OR_DIRECTORATETEXTFunding NIH institute or NSF directorate.
RECIPIENT_NAMETEXTRecipient organization as USAspending publishes it.
RECIPIENT_UEITEXTRecipient’s SAM.gov Unique Entity ID.
RECIPIENT_CITYTEXTRecipient city.
RECIPIENT_STATETEXTRecipient state, two letters. The free trial returns Massachusetts only.
TITLETEXTAward or project title.
OBLIGATED_USD_FY2016_ONNUMBERDollars obligated from federal fiscal year 2016 on, from USAspending. Earlier years are not included.
START_DATEDATEAward start date in USAspending.
END_DATEDATEAward end date in USAspending.
PROJECT_START_DATEDATEEarliest known project start, used for the early-paper filter: the earliest of USAspending, NIH ExPORTER and NIH’s own grant records. Dates before 1950 are ignored.
PROJECT_END_DATEDATEProject end date, where known.
PRINCIPAL_INVESTIGATORSTEXTPrincipal investigators as NIH ExPORTER publishes them (NIH only).
CONTACT_PITEXTContact principal investigator from NIH ExPORTER (NIH only).
GRANT_KINDTEXTCivly grouping of the award type: project, training, small_business, facility or center. Center and facility grants are thanked by many outside papers.
START_FISCAL_YEARNUMBERFederal fiscal year the award started.
INCOMPLETE_YEARSBOOLEANTrue for awards starting in fiscal 2025 or later: papers lag awards, so their counts are still growing.
ACKNOWLEDGING_PAPER_COUNTNUMBERNumber of OpenAlex papers that acknowledge the award.
UPDATED_ATTIMESTAMP_NTZWhen Civly last built the row.
Schema

Data dictionary: AWARD_PAPERS

One row per award and paper: a paper that printed the award’s number in its funding acknowledgments, the rule that made the link, and the number as the paper printed it. 6 columns.

ColumnTypeMeaning
AWARD_NUMBERTEXTAward number, as in AWARDS.
AGENCYTEXTNIH or NSF.
PAPER_IDTEXTOpenAlex work id; joins PAPERS.
HOW_MATCHEDTEXTThe rule that linked the paper: the full NIH number, the NIH institute and serial with another phase of the same project, the institute and serial with no grant type printed (only when the paper lists an NIH or HHS funder), or the NSF award number (only when the paper lists NSF).
AWARD_STRING_AS_PRINTEDTEXTThe award number exactly as the paper printed it.
UPDATED_ATTIMESTAMP_NTZWhen Civly last built the row.
Schema

Data dictionary: PAPERS

One row per paper linked in AWARD_PAPERS: DOI, title, year, type, venue, citations, retraction flag, and author institutions and countries, from OpenAlex. 12 columns.

ColumnTypeMeaning
PAPER_IDTEXTOpenAlex work id.
DOITEXTDOI, where the paper has one.
TITLETEXTPaper title.
YEARNUMBERPublication year.
TYPETEXTOpenAlex record type. Peer reviews, datasets, supplements, errata, retraction notices and dissertations are left out.
VENUETEXTJournal or other venue.
CITED_BY_COUNTNUMBERCitations OpenAlex counts.
IS_RETRACTEDBOOLEANOpenAlex marks the paper retracted.
INSTITUTION_COUNTNUMBERNumber of author institutions.
INSTITUTIONSTEXTAuthor institutions, as OpenAlex lists them.
COUNTRIESTEXTCountries of the author institutions.
UPDATED_ATTIMESTAMP_NTZWhen Civly last built the row.
Matching

Joining the views

AWARD_NUMBER joins AWARDS to AWARD_PAPERS, and PAPER_ID joins AWARD_PAPERS to PAPERS. AWARDS has one row per award, AWARD_PAPERS one row per AWARD_NUMBER and PAPER_ID, and PAPERS one row per PAPER_ID. RECIPIENT_UEI is the recipient’s SAM.gov Unique Entity ID, for matching to other federal award data, such as PRIME_AWARDEE_UEI and SUBAWARDEE_UEI in the Federal Buying Signals listing’s subaward reports. DOI is the paper’s DOI and PAPER_ID its OpenAlex work ID, for matching to other publication data, such as the US Physician Researchers listing’s papers.

Getting started

Sample queries

After installing, set your worksheet’s database selector to the installed database and these run as written.

-- Papers acknowledging one award
SELECT p.TITLE, p.YEAR, p.VENUE, p.CITED_BY_COUNT
FROM US_GRANTS_TO_PAPERS.AWARD_PAPERS l
JOIN US_GRANTS_TO_PAPERS.PAPERS p ON p.PAPER_ID = l.PAPER_ID
WHERE l.AWARD_NUMBER = 'R01HL158192'
ORDER BY p.YEAR;

-- Most-acknowledged research awards by recipient
SELECT RECIPIENT_NAME, COUNT(*) AS AWARDS, SUM(ACKNOWLEDGING_PAPER_COUNT) AS PAPER_LINKS,
       SUM(OBLIGATED_USD_FY2016_ON) AS USD_FY2016_ON
FROM US_GRANTS_TO_PAPERS.AWARDS
WHERE GRANT_KIND = 'project'
GROUP BY RECIPIENT_NAME
ORDER BY PAPER_LINKS DESC
LIMIT 25;

-- Papers per million dollars by NIH institute, complete years only
SELECT INSTITUTE_OR_DIRECTORATE, COUNT(*) AS AWARDS,
       SUM(ACKNOWLEDGING_PAPER_COUNT) / NULLIF(SUM(OBLIGATED_USD_FY2016_ON) / 1e6, 0) AS PAPER_LINKS_PER_USD_MILLION
FROM US_GRANTS_TO_PAPERS.AWARDS
WHERE AGENCY = 'NIH' AND NOT INCOMPLETE_YEARS AND GRANT_KIND = 'project'
GROUP BY 1
ORDER BY AWARDS DESC
LIMIT 20;
Provenance

Sourcing and attribution

Sources: USAspending.gov, published by the U.S. Department of the Treasury, for the awards, recipients and dollars. NIH RePORTER and ExPORTER, published by the National Institutes of Health, for principal investigators and project dates. OpenAlex, from OurResearch, for the papers and the award numbers they print. USAspending.gov, RePORTER and ExPORTER are U.S. government works. OpenAlex is released under CC0 and needs no attribution. Civly credits it as “OpenAlex, OurResearch” as a courtesy.

What Civly did: read the award numbers each paper prints, matched them to NIH and NSF award numbers, dropped papers published more than a year before the project started and the record types listed above, and grouped awards by kind. The links, HOW_MATCHED, GRANT_KIND, PROJECT_START_DATE, INCOMPLETE_YEARS and ACKNOWLEDGING_PAPER_COUNT are Civly’s work. Award details are USAspending.gov’s and NIH’s, and paper details are OpenAlex’s. When you publish analysis based on this dataset, credit USAspending.gov, NIH RePORTER and OpenAlex (OpenAlex, OurResearch) as sources and Civly as compiler.

Principal investigators’ names are as NIH publishes them in its public grant records. The listing has no home addresses, phone numbers or email addresses.

This product is not endorsed by NIH or NSF.

Permitted use: not for employment, tenant, credit, insurance or licensing decisions about a person. Civly is not a consumer reporting agency.

For coverage or access questions: matthew@civly.ai