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.
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.
| Fact | Detail |
|---|---|
| Source | SEC company ticker file (U.S. government work) and OpenAlex (CC0), tied by Civly |
| Coverage | 1,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 |
| Period | Papers from every year in OpenAlex. A company’s FIRST_PAPER_YEAR and LAST_PAPER_YEAR give its own span |
| Refresh | Weekly, every Monday. Civly checks the sources daily and rebuilds when one has changed. UPDATED_AT gives when Civly last built each row |
| Free trial | 30 days, every company whose stock ticker begins with A: 146 companies, 165,703 papers and 118,422 researcher rows |
| Subscription | Every company, paper and researcher, billed yearly |
| Join key | TICKER 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 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 |
|---|---|---|---|
COMPANIES | 1,164 | Listed company (stock ticker) | SEC company ticker file, tied by Civly |
PAPERS | 1,765,787 | Paper and company institution | OpenAlex |
PEOPLE_MOVES | 1,142,697 | Researcher and listed company | OpenAlex |
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.
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.
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.
COMPANIESOne 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.
| Column | Type | Meaning |
|---|---|---|
TICKER | TEXT | Stock ticker of the listed company. |
CIK | TEXT | SEC Central Index Key of the listed company. |
COMPANY_NAME | TEXT | Company name as the SEC ticker file carries it. |
EXCHANGE | TEXT | Exchange the ticker trades on, as the SEC file carries it. |
INSTITUTION_COUNT | NUMBER | OpenAlex company institutions tied to this ticker. |
PAPER_COUNT | NUMBER | Research papers credited to the ticker. |
PAPER_COUNT_SINCE_2015 | NUMBER | Research papers credited to the ticker from 2015 on. |
CITATION_COUNT | NUMBER | Citations to those papers, as OpenAlex counts them. |
AUTHOR_COUNT | NUMBER | Researchers with at least one paper credited to the ticker. |
FIRST_PAPER_YEAR | NUMBER | Year of the earliest paper credited to the ticker. |
LAST_PAPER_YEAR | NUMBER | Year of the latest paper credited to the ticker. |
TOP_SUBJECTS | TEXT | Most common research subjects of the credited papers, as OpenAlex names them. |
MATCH_BASIS | TEXT | How the tie was made: a name rule, or the hand-reviewed list. |
UPDATED_AT | TIMESTAMP | When Civly last built this row. |
PAPERSOne row per paper per company institution credited to a ticker. 13 columns.
| Column | Type | Meaning |
|---|---|---|
TICKER | TEXT | Stock ticker the paper is credited to. |
PAPER_ID | TEXT | OpenAlex work ID of the paper. |
DOI | TEXT | Digital Object Identifier of the paper, when it has one. |
TITLE | TEXT | Paper title as OpenAlex carries it. |
YEAR | NUMBER | Publication year. |
TYPE | TEXT | OpenAlex record type. Research record types only. |
VENUE | TEXT | Journal or venue name, when OpenAlex has one. |
CITED_BY_COUNT | NUMBER | Citations to the paper, as OpenAlex counts them. |
IS_RETRACTED | BOOLEAN | True when OpenAlex marks the paper retracted. |
INSTITUTION_ID | TEXT | OpenAlex ID of the company institution the paper is credited through. |
INSTITUTION_NAME | TEXT | Name of that institution. |
MATCH_HOW | TEXT | Which rule or reviewed-list row tied the institution to the ticker. |
UPDATED_AT | TIMESTAMP | When Civly last built this row. |
PEOPLE_MOVESOne row per researcher per ticker: papers at the company, years there, and the employers before and after. 19 columns.
| Column | Type | Meaning |
|---|---|---|
TICKER | TEXT | Stock ticker of the listed company. |
RESEARCHER_ID | TEXT | OpenAlex researcher id. |
RESEARCHER_NAME | TEXT | Researcher name as OpenAlex publishes it. A professional record, not contact details. |
ORCID | TEXT | ORCID iD when OpenAlex has one. |
PAPER_COUNT | NUMBER | Research papers by this researcher counted for the company. |
FIRST_YEAR_HERE | NUMBER | First year the researcher is seen at the company. |
LAST_YEAR_HERE | NUMBER | Last year seen at the company. |
EMPLOYER_YEARS_CONFIRMED | BOOLEAN | True 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_NOW | BOOLEAN | True when the researcher’s current employer in OpenAlex is one of the company’s institutions. |
CAME_FROM_INSTITUTION_ID | TEXT | Institution 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_INSTITUTION | TEXT | Name of the came-from institution. |
CAME_FROM_TYPE | TEXT | OpenAlex type of the came-from institution (education, company, government and so on). |
CAME_FROM_YEAR | NUMBER | The last year the researcher is listed at the came-from institution before joining. |
WENT_TO_INSTITUTION_ID | TEXT | Institution 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_INSTITUTION | TEXT | Name of the went-to institution. |
WENT_TO_TYPE | TEXT | OpenAlex type of the went-to institution. |
WENT_TO_YEAR | NUMBER | The first year the researcher is listed at the went-to institution after leaving. |
MOVE_KIND | TEXT | joined_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_AT | TIMESTAMP | When Civly last built this row. |
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.
After installing, set your worksheet’s database selector to the installed database and these run as written.
| Question | Query |
|---|---|
| Biggest research publishers by ticker | SELECT TICKER, COMPANY_NAME, PAPER_COUNT FROM COMPANY_RESEARCH.COMPANIES ORDER BY PAPER_COUNT DESC LIMIT 25; |
| One company’s papers by year | SELECT YEAR, COUNT(*) AS PAPERS FROM COMPANY_RESEARCH.PAPERS WHERE TICKER = 'IBM' GROUP BY YEAR ORDER BY YEAR; |
| Researchers who joined a company from a university | SELECT 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; |
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