Snowflake Marketplace

US Company Research by Stock Ticker: Papers and Researcher Moves

Listed companies tied to the research institutions that publish under their names, with 1.77 million papers by year and 1.14 million researchers, including the employer each researcher came from and went to next, updated weekly.

1,164listed companies matched
1.77Mcompany papers
1.14Mresearcher rows
Weeklyupdated
About this dataset

What’s in the listing

OpenAlex, the open catalog of research papers, records which institutions each paper’s authors belong to. Some of those institutions are companies. This listing ties those company institutions to listed companies in the SEC company ticker file, so a company’s research output and researchers can be read by stock ticker. Companies and OpenAlex share no common ID, so Civly makes the tie with name rules and a hand-reviewed list, and records how each tie was made.

Three views. COMPANIES has one row per ticker: company name, exchange, CIK, how many OpenAlex institutions were tied to it, paper and citation counts, first and last paper years, top subjects, and how the tie was made. PAPERS has one row per paper per company institution: DOI, title, year, type, venue, citations, retraction flag, and which institution and rule credited it to the ticker. PEOPLE_MOVES has one row per researcher per ticker: name, ORCID when known, paper count, first and last years at the company, and the employer the researcher came from and went to next where OpenAlex’s year-by-year employer list shows it.

Common uses: investors tracking which listed companies publish research and in what subjects, companies watching rivals’ research output and hiring from universities, and research offices following where their researchers go.

FactDetail
SourceSEC company ticker file (U.S. government work) and OpenAlex (CC0), tied by Civly
Coverage1,164 of 8,009 listed companies in the SEC file (14.5%) tie to an OpenAlex company institution. 1,765,787 papers and 1,142,697 researcher rows. Companies that do not publish research have no institution to tie
PeriodPapers from every year in OpenAlex. A company’s FIRST_PAPER_YEAR and LAST_PAPER_YEAR give its own span
RefreshWeekly, every Monday. Civly checks the sources daily and rebuilds when one has changed. UPDATED_AT gives when Civly last built each row
Free trial30 days, every company whose stock ticker begins with A: 146 companies, 165,703 papers and 118,422 researcher rows
SubscriptionEvery company, paper and researcher, billed yearly
Join keyTICKER joins all three views. PAPER_ID (OpenAlex work ID) and DOI join PAPERS to other data. RESEARCHER_ID (OpenAlex author ID) and ORCID join PEOPLE_MOVES 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
COMPANIES1,164Listed company (stock ticker)SEC company ticker file, tied by Civly
PAPERS1,765,787Paper and company institutionOpenAlex
PEOPLE_MOVES1,142,697Researcher and listed companyOpenAlex

Reading the data

Only 1,164 of the 8,009 listed companies in the SEC file tie to a company institution in OpenAlex. Most listed companies publish no research, so they have no institution to tie. Read the 14.5% as the research-active share of the listed market, not as missing data.

PAPERS has one row per paper per company institution. A paper from two institutions of the same company, or from institutions of two companies, appears more than once. Count DISTINCT PAPER_ID to count papers.

Came-from and went-to employers count only when the last year there is within five years of the researcher’s years at the company. A longer gap is a different career stage, not a move into or out of the company.

MOVE_KIND says what was found: joined_from, left_to, joined_and_left, return_or_dual_affiliation (the same institution before and after, a return to a former employer or two affiliations at once), or no_move_found.

Publishers are left out. A publishing house’s papers are what it publishes, not research it did, so Springer Nature, Wiley, Wolters Kluwer and Pearson are not credited to a ticker.

Accuracy

How the matching checks out

A company institution ties to a ticker in three ways, recorded in MATCH_BASIS on COMPANIES and MATCH_HOW on PAPERS: same name and same country; same name with the country missing on one side; same name in another country where the institution’s website is the matched company’s website. A hand-reviewed list of 561 rows sits on top of the rules: it maps institutions the rules miss (including name changes, acquisitions and splits, some for limited years only), marks institutions with no listed parent company, and rejects wrong automatic ties. The reviewed list wins over the rules.

The rules alone tied 1,169 companies. The reviewed list raised papers credited to a ticker by 29%, to 1.75 million, and tied 26 of the 40 biggest research companies, which is every one of the 40 that has a US-listed parent in the SEC file. The other 14 are foreign or state-owned groups with no US listing.

Before this build, Civly checked the ties by hand. Of 54 rule-made ties checked, 53 were right. Of 30 combined ties checked, 28 were right, 1 was wrong (now rejected), and 1 could not be confirmed either way. Right means the institution, subject and papers are consistent with the listed company.

What is missed is unknown. A company is missed when its publishing name differs from its SEC name in a way the rules and the reviewed list do not cover, and a paper is missed when OpenAlex does not record the company institution. Research record types only: datasets, peer reviews, supplementary materials, errata, retractions and dissertations are dropped.

Schemas

Data dictionary

Three views, 46 columns in total: COMPANIES, PAPERS and PEOPLE_MOVES. The same views serve the trial and the subscription. During the free trial they return every company whose stock ticker begins with A (146 companies, 165,703 papers and 118,422 researcher rows). A subscription adds every other company.

Schema

Data dictionary: COMPANIES

One row per listed company tied to a company institution: name, exchange, paper and citation counts, year span, top subjects and how the tie was made. 14 columns.

ColumnTypeMeaning
TICKERTEXTStock ticker of the listed company.
CIKTEXTSEC Central Index Key of the listed company.
COMPANY_NAMETEXTCompany name as the SEC ticker file carries it.
EXCHANGETEXTExchange the ticker trades on, as the SEC file carries it.
INSTITUTION_COUNTNUMBEROpenAlex company institutions tied to this ticker.
PAPER_COUNTNUMBERResearch papers credited to the ticker.
PAPER_COUNT_SINCE_2015NUMBERResearch papers credited to the ticker from 2015 on.
CITATION_COUNTNUMBERCitations to those papers, as OpenAlex counts them.
AUTHOR_COUNTNUMBERResearchers with at least one paper credited to the ticker.
FIRST_PAPER_YEARNUMBERYear of the earliest paper credited to the ticker.
LAST_PAPER_YEARNUMBERYear of the latest paper credited to the ticker.
TOP_SUBJECTSTEXTMost common research subjects of the credited papers, as OpenAlex names them.
MATCH_BASISTEXTHow the tie was made: a name rule, or the hand-reviewed list.
UPDATED_ATTIMESTAMPWhen Civly last built this row.
Schema

Data dictionary: PAPERS

One row per paper per company institution credited to a ticker. 13 columns.

ColumnTypeMeaning
TICKERTEXTStock ticker the paper is credited to.
PAPER_IDTEXTOpenAlex work ID of the paper.
DOITEXTDigital Object Identifier of the paper, when it has one.
TITLETEXTPaper title as OpenAlex carries it.
YEARNUMBERPublication year.
TYPETEXTOpenAlex record type. Research record types only.
VENUETEXTJournal or venue name, when OpenAlex has one.
CITED_BY_COUNTNUMBERCitations to the paper, as OpenAlex counts them.
IS_RETRACTEDBOOLEANTrue when OpenAlex marks the paper retracted.
INSTITUTION_IDTEXTOpenAlex ID of the company institution the paper is credited through.
INSTITUTION_NAMETEXTName of that institution.
MATCH_HOWTEXTWhich rule or reviewed-list row tied the institution to the ticker.
UPDATED_ATTIMESTAMPWhen Civly last built this row.
Schema

Data dictionary: PEOPLE_MOVES

One row per researcher per ticker: papers at the company, years there, and the employers before and after. 19 columns.

ColumnTypeMeaning
TICKERTEXTStock ticker of the listed company.
RESEARCHER_IDTEXTOpenAlex researcher id.
RESEARCHER_NAMETEXTResearcher name as OpenAlex publishes it. A professional record, not contact details.
ORCIDTEXTORCID iD when OpenAlex has one.
PAPER_COUNTNUMBERResearch papers by this researcher counted for the company.
FIRST_YEAR_HERENUMBERFirst year the researcher is seen at the company.
LAST_YEAR_HERENUMBERLast year seen at the company.
EMPLOYER_YEARS_CONFIRMEDBOOLEANTrue when OpenAlex’s year-by-year employer list shows the researcher at the company in at least one year. Came-from and went-to are only filled when this is true.
LISTED_THERE_NOWBOOLEANTrue when the researcher’s current employer in OpenAlex is one of the company’s institutions.
CAME_FROM_INSTITUTION_IDTEXTInstitution the researcher listed in the closest year before joining, only when their last year there is at most five years before the first year here. Otherwise empty.
CAME_FROM_INSTITUTIONTEXTName of the came-from institution.
CAME_FROM_TYPETEXTOpenAlex type of the came-from institution (education, company, government and so on).
CAME_FROM_YEARNUMBERThe last year the researcher is listed at the came-from institution before joining.
WENT_TO_INSTITUTION_IDTEXTInstitution the researcher listed in the closest year after leaving, only when their first year there is at most five years after the last year here. Otherwise empty.
WENT_TO_INSTITUTIONTEXTName of the went-to institution.
WENT_TO_TYPETEXTOpenAlex type of the went-to institution.
WENT_TO_YEARNUMBERThe first year the researcher is listed at the went-to institution after leaving.
MOVE_KINDTEXTjoined_from: came-from only. left_to: went-to only. joined_and_left: both, different institutions. return_or_dual_affiliation: same institution before and after. no_move_found: neither.
UPDATED_ATTIMESTAMPWhen Civly last built this row.
Joins

Joining the views

TICKER joins all three views. PAPER_ID and DOI join PAPERS to other paper data. RESEARCHER_ID and ORCID join PEOPLE_MOVES to other researcher data. The OpenAlex institution IDs (INSTITUTION_ID, CAME_FROM_INSTITUTION_ID, WENT_TO_INSTITUTION_ID) join to OpenAlex institution records.

Examples

Sample queries

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

QuestionQuery
Biggest research publishers by tickerSELECT TICKER, COMPANY_NAME, PAPER_COUNT FROM COMPANY_RESEARCH.COMPANIES ORDER BY PAPER_COUNT DESC LIMIT 25;
One company’s papers by yearSELECT YEAR, COUNT(*) AS PAPERS FROM COMPANY_RESEARCH.PAPERS WHERE TICKER = 'IBM' GROUP BY YEAR ORDER BY YEAR;
Researchers who joined a company from a universitySELECT RESEARCHER_NAME, CAME_FROM_INSTITUTION, CAME_FROM_YEAR, FIRST_YEAR_HERE FROM COMPANY_RESEARCH.PEOPLE_MOVES WHERE TICKER = 'NVDA' AND CAME_FROM_TYPE = 'education' ORDER BY FIRST_YEAR_HERE DESC;
Provenance

Sourcing and attribution

Sources: the SEC company ticker file, published by the U.S. Securities and Exchange Commission, for listed companies, tickers and exchanges. OpenAlex, from OurResearch, for institutions, papers, researchers and employer years. The SEC file is a U.S. government work. OpenAlex is released under CC0 and needs no attribution. Civly credits it as “OpenAlex, OurResearch” as a courtesy.

What Civly did: tied OpenAlex company institutions to tickers with the name rules and hand-reviewed list described above, credited each paper through the institution it was tied by, worked out each researcher’s years at the company and the employers before and after, and dropped the record types listed above and the publishers. The ties, MATCH_BASIS, MATCH_HOW and MOVE_KIND are Civly’s work. Company details are the SEC’s, and paper and researcher details are OpenAlex’s. When you publish analysis based on this dataset, credit the SEC company ticker file and OpenAlex (OpenAlex, OurResearch) as sources and Civly as compiler.

Researcher names and employers are as OpenAlex publishes them in its public professional records. The listing has no home addresses, phone numbers or email addresses.

This product is not endorsed by the SEC.

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