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.
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.
| Fact | Detail |
|---|---|
| Source | USAspending.gov (U.S. Department of the Treasury), NIH RePORTER and ExPORTER (U.S. government works) and OpenAlex (CC0), linked by Civly |
| Coverage | 357,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 |
| Period | Awards 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) |
| Refresh | Weekly, 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 trial | 30 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 |
| Subscription | Every award, link and paper, billed yearly |
| Join key | AWARD_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 use | Not for employment, tenant, credit, insurance or licensing decisions about a person. Civly is not a consumer reporting agency. |
Row counts as of November 15, 2026.
| View | Rows | One row per | Source |
|---|---|---|---|
AWARDS | 357,777 | Award: 220,631 NIH, 137,146 NSF | USAspending.gov, with NIH RePORTER and ExPORTER |
AWARD_PAPERS | 5,479,375 | Award and paper | Award numbers printed in OpenAlex papers, linked by Civly |
PAPERS | 2,494,820 | Paper | OpenAlex |
| View | Group | Rows | What it means |
|---|---|---|---|
AWARDS | AGENCY NIH | 220,631 | National Institutes of Health awards. 175,520 (79.6%) have at least one acknowledging paper. $342.5 billion obligated from fiscal 2016 on |
AWARDS | AGENCY NSF | 137,146 | National Science Foundation awards. 88,932 (64.8%) have at least one acknowledging paper. $81.6 billion obligated from fiscal 2016 on |
AWARDS | GRANT_KIND project | 276,587 | Research project awards |
AWARDS | GRANT_KIND training | 51,833 | Training awards |
AWARDS | GRANT_KIND small_business | 18,918 | Small-business research awards |
AWARDS | GRANT_KIND facility | 5,676 | Shared facility and resource awards. Thanked by many papers from outside the funded team |
AWARDS | GRANT_KIND center | 4,763 | Center awards. Thanked by many papers from outside the funded team |
AWARD_PAPERS | HOW_MATCHED grant type, institute and serial | 4,200,152 | NIH. The paper printed the full NIH number: the grant type, institute code and serial all match the award |
AWARD_PAPERS | HOW_MATCHED institute and serial (another phase of the same project) | 124,161 | NIH. The institute code and serial match, printed with the grant type of another phase of the same project |
AWARD_PAPERS | HOW_MATCHED institute and serial (grant type not printed; paper lists an NIH or HHS funder) | 273,008 | NIH. The paper printed the institute code and serial with no grant type, and lists NIH or HHS among its funders |
AWARD_PAPERS | HOW_MATCHED NSF award number (paper lists NSF, OpenAlex files the number under NSF) | 882,054 | NSF. 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.
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.
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.
AWARDSOne 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.
| Column | Type | Meaning |
|---|---|---|
AWARD_NUMBER | TEXT | Award number as USAspending carries it: the NIH core project number (e.g. R01HL158192) or the 7-digit NSF award id. |
AWARD_ID | TEXT | USAspending’s award identifier. |
AGENCY | TEXT | NIH or NSF. |
INSTITUTE_CODE | TEXT | Two-letter NIH institute code from the project number (e.g. HL, CA). Empty for NSF. |
CFDA_NUMBER | TEXT | Federal assistance listing (CFDA) number of the program. |
INSTITUTE_OR_DIRECTORATE | TEXT | Funding NIH institute or NSF directorate. |
RECIPIENT_NAME | TEXT | Recipient organization as USAspending publishes it. |
RECIPIENT_UEI | TEXT | Recipient’s SAM.gov Unique Entity ID. |
RECIPIENT_CITY | TEXT | Recipient city. |
RECIPIENT_STATE | TEXT | Recipient state, two letters. The free trial returns Massachusetts only. |
TITLE | TEXT | Award or project title. |
OBLIGATED_USD_FY2016_ON | NUMBER | Dollars obligated from federal fiscal year 2016 on, from USAspending. Earlier years are not included. |
START_DATE | DATE | Award start date in USAspending. |
END_DATE | DATE | Award end date in USAspending. |
PROJECT_START_DATE | DATE | Earliest 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_DATE | DATE | Project end date, where known. |
PRINCIPAL_INVESTIGATORS | TEXT | Principal investigators as NIH ExPORTER publishes them (NIH only). |
CONTACT_PI | TEXT | Contact principal investigator from NIH ExPORTER (NIH only). |
GRANT_KIND | TEXT | Civly grouping of the award type: project, training, small_business, facility or center. Center and facility grants are thanked by many outside papers. |
START_FISCAL_YEAR | NUMBER | Federal fiscal year the award started. |
INCOMPLETE_YEARS | BOOLEAN | True for awards starting in fiscal 2025 or later: papers lag awards, so their counts are still growing. |
ACKNOWLEDGING_PAPER_COUNT | NUMBER | Number of OpenAlex papers that acknowledge the award. |
UPDATED_AT | TIMESTAMP_NTZ | When Civly last built the row. |
AWARD_PAPERSOne 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.
| Column | Type | Meaning |
|---|---|---|
AWARD_NUMBER | TEXT | Award number, as in AWARDS. |
AGENCY | TEXT | NIH or NSF. |
PAPER_ID | TEXT | OpenAlex work id; joins PAPERS. |
HOW_MATCHED | TEXT | The 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_PRINTED | TEXT | The award number exactly as the paper printed it. |
UPDATED_AT | TIMESTAMP_NTZ | When Civly last built the row. |
PAPERSOne row per paper linked in AWARD_PAPERS: DOI, title, year, type, venue, citations, retraction flag, and author institutions and countries, from OpenAlex. 12 columns.
| Column | Type | Meaning |
|---|---|---|
PAPER_ID | TEXT | OpenAlex work id. |
DOI | TEXT | DOI, where the paper has one. |
TITLE | TEXT | Paper title. |
YEAR | NUMBER | Publication year. |
TYPE | TEXT | OpenAlex record type. Peer reviews, datasets, supplements, errata, retraction notices and dissertations are left out. |
VENUE | TEXT | Journal or other venue. |
CITED_BY_COUNT | NUMBER | Citations OpenAlex counts. |
IS_RETRACTED | BOOLEAN | OpenAlex marks the paper retracted. |
INSTITUTION_COUNT | NUMBER | Number of author institutions. |
INSTITUTIONS | TEXT | Author institutions, as OpenAlex lists them. |
COUNTRIES | TEXT | Countries of the author institutions. |
UPDATED_AT | TIMESTAMP_NTZ | When Civly last built the row. |
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.
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;
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