Downloads · OpenAlex data as of November 17, 2026
Download the data
Every table behind the charts, as CSV files. Free to reuse: public domain (CC0) unless a file says otherwise.
Each file lists its columns below. The whole dictionary is also a file: data dictionary (CSV). The scripts that build the files, and the log of every query, are on GitHub. The Methods page explains the definitions.
Main figures
Everything on the site's charts comes from these files. Built from OpenAlex by pipeline/s06_metrics.py and s12_green_proxy.py. Articles and reviews only, 2015 to 2025 unless a column says otherwise.
Free to read, 2015 to 2025
Articles free to read in any way (every category except closed), by institution and statewide.
Columns (5) in Free to read, 2015 to 2025
Columns in Free to read, 2015 to 2025 Column Meaning entityWhich group the row describes: an institution key (for example yale, uconn), statewide (all 17, each article once) or statewide_no_yale / statewide_without_yale (articles with at least one author at one of the other 16, each once) entity_nameDisplay name of the entity worksNumber of articles (articles and reviews), each counted once within the entity free_to_readArticles in any category except closed free_to_read_sharefree_to_read divided by works Free to read, by year
The same, for each year from 2015 to 2026. 2026 is incomplete.
Columns (7) in Free to read, by year
Columns in Free to read, by year Column Meaning entityWhich group the row describes: an institution key (for example yale, uconn), statewide (all 17, each article once) or statewide_no_yale / statewide_without_yale (articles with at least one author at one of the other 16, each once) entity_nameDisplay name of the entity publication_yearYear of publication in OpenAlex periodcomplete for 2015 to 2025; incomplete for 2026, which is still being indexed worksNumber of articles (articles and reviews), each counted once within the entity free_to_readArticles in any category except closed free_to_read_sharefree_to_read divided by works Open access categories, 2015 to 2025
Articles in each open access category, by institution and statewide.
Columns (5) in Open access categories, 2015 to 2025
Columns in Open access categories, 2015 to 2025 Column Meaning entityWhich group the row describes: an institution key (for example yale, uconn), statewide (all 17, each article once) or statewide_no_yale / statewide_without_yale (articles with at least one author at one of the other 16, each once) entity_nameDisplay name of the entity oa_categoryOpen access category: diamond, oa_fee_unconfirmed, gold, hybrid, bronze, green or closed (see the Methods page) worksNumber of articles (articles and reviews), each counted once within the entity shareworks divided by all articles for that entity (and year, if given) Open access categories, by year
The same, for each year from 2015 to 2026.
Columns (7) in Open access categories, by year
Columns in Open access categories, by year Column Meaning entityWhich group the row describes: an institution key (for example yale, uconn), statewide (all 17, each article once) or statewide_no_yale / statewide_without_yale (articles with at least one author at one of the other 16, each once) entity_nameDisplay name of the entity publication_yearYear of publication in OpenAlex periodcomplete for 2015 to 2025; incomplete for 2026, which is still being indexed oa_categoryOpen access category: diamond, oa_fee_unconfirmed, gold, hybrid, bronze, green or closed (see the Methods page) worksNumber of articles (articles and reviews), each counted once within the entity shareworks divided by all articles for that entity (and year, if given) Publishers
Articles and closed articles by publisher (imprints grouped under their parent company), top publishers per entity.
Columns (8) in Publishers
Columns in Publishers Column Meaning entityWhich group the row describes: an institution key (for example yale, uconn), statewide (all 17, each article once) or statewide_no_yale / statewide_without_yale (articles with at least one author at one of the other 16, each once) entity_nameDisplay name of the entity publisher_parent_nameTop-level publisher in OpenAlex's publisher hierarchy worksNumber of articles (articles and reviews), each counted once within the entity closedArticles in the closed category closed_shareclosed divided by works rank_by_outputRank within the entity by number of articles (1 = most) rank_by_closedRank within the entity by number of closed articles (1 = most) Fields
Articles and closed articles by OpenAlex field (a broad subject group, from each article's main topic).
Columns (8) in Fields
Columns in Fields Column Meaning entityWhich group the row describes: an institution key (for example yale, uconn), statewide (all 17, each article once) or statewide_no_yale / statewide_without_yale (articles with at least one author at one of the other 16, each once) entity_nameDisplay name of the entity field_nameOpenAlex field worksNumber of articles (articles and reviews), each counted once within the entity closedArticles in the closed category closed_shareclosed divided by works rank_by_outputRank within the entity by number of articles (1 = most) rank_by_closedRank within the entity by number of closed articles (1 = most) Topics
Articles and closed articles by OpenAlex topic (a detailed subject label, one per article), top topics per entity.
Columns (8) in Topics
Columns in Topics Column Meaning entityWhich group the row describes: an institution key (for example yale, uconn), statewide (all 17, each article once) or statewide_no_yale / statewide_without_yale (articles with at least one author at one of the other 16, each once) entity_nameDisplay name of the entity topic_nameOpenAlex topic worksNumber of articles (articles and reviews), each counted once within the entity closedArticles in the closed category closed_shareclosed divided by works rank_by_outputRank within the entity by number of articles (1 = most) rank_by_closedRank within the entity by number of closed articles (1 = most) Article fee estimates (APCs), 2015 to 2025
ESTIMATES of article processing charges, from journals' listed prices for gold and hybrid articles. Two methods, one row each.
Columns (7) in Article fee estimates (APCs), 2015 to 2025
Columns in Article fee estimates (APCs), 2015 to 2025 Column Meaning entityWhich group the row describes: an institution key (for example yale, uconn), statewide (all 17, each article once) or statewide_no_yale / statewide_without_yale (articles with at least one author at one of the other 16, each once) entity_nameDisplay name of the entity paid_oa_worksGold and hybrid articles counted by this method works_with_list_priceOf those, articles whose journal has a listed price in OpenAlex estimated_usdSum of listed prices in US dollars. An estimate, not a payment works_without_list_priceOf those, articles with no listed price (not included in the estimate) methodcorresponding_author: articles where the entity is a corresponding author's institution; upper_bound_all_authors: any author at the entity Article fee estimates, by year
The same estimates for each year from 2015 to 2026.
Columns (9) in Article fee estimates, by year
Columns in Article fee estimates, by year Column Meaning entityWhich group the row describes: an institution key (for example yale, uconn), statewide (all 17, each article once) or statewide_no_yale / statewide_without_yale (articles with at least one author at one of the other 16, each once) entity_nameDisplay name of the entity publication_yearYear of publication in OpenAlex periodcomplete for 2015 to 2025; incomplete for 2026, which is still being indexed paid_oa_worksGold and hybrid articles counted by this method works_with_list_priceOf those, articles with a listed price estimated_usdSum of listed prices in US dollars. An estimate works_without_list_priceOf those, articles with no listed price methodcorresponding_author or upper_bound_all_authors (see above) Corresponding author coverage
How many articles have a corresponding author's institution recorded in OpenAlex. The corresponding-author fee estimate depends on it.
Columns (6) in Corresponding author coverage
Columns in Corresponding author coverage Column Meaning entityWhich group the row describes: an institution key (for example yale, uconn), statewide (all 17, each article once) or statewide_no_yale / statewide_without_yale (articles with at least one author at one of the other 16, each once) entity_nameDisplay name of the entity periodcomplete for 2015 to 2025; incomplete for 2026, which is still being indexed worksNumber of articles (articles and reviews), each counted once within the entity with_corresponding_infoArticles with at least one corresponding institution recorded coverage_sharewith_corresponding_info divided by works Green open access opportunity (proxy)
Closed and bronze articles that could likely be made free in a repository, by a proxy based on what other authors in the same journal have done. Not a check of publisher policy.
Columns (10) in Green open access opportunity (proxy)
Columns in Green open access opportunity (proxy) Column Meaning entityWhich group the row describes: an institution key (for example yale, uconn), statewide (all 17, each article once) or statewide_no_yale / statewide_without_yale (articles with at least one author at one of the other 16, each once) articlesAll articles for the entity, 2015 to 2025 closedClosed articles bronzeBronze articles closed_candidatesClosed articles with no free copy, in a journal that shows deposit evidence bronze_candidatesBronze articles with no free copy except the publisher's page, in a journal that shows deposit evidence candidatesclosed_candidates plus bronze_candidates candidates_share_of_articlescandidates divided by articles candidates_if_threshold_1Candidates if one deposit in the journal counted as evidence (instead of three) candidates_if_threshold_10Candidates if ten deposits were required Books and book chapters
A count only. Books and chapters are not in the other figures.
Columns (4) in Books and book chapters
Columns in Books and book chapters Column Meaning entityWhich group the row describes: an institution key (for example yale, uconn), statewide (all 17, each article once) or statewide_no_yale / statewide_without_yale (articles with at least one author at one of the other 16, each once) entity_nameDisplay name of the entity books_and_chapters_2015_2025Books and book chapters with an author at the institution all_types_2015_2025All work types in OpenAlex, for scale Manifest
Snapshot date, build time and scope of this release.
For librarians
An article list for planning repository outreach. It is not shown on the site and names no authors.
Repository candidates
Closed and bronze articles, 2015 to 2026, with no free copy except possibly the publisher's page, in journals that show deposit evidence. One row per institution and article. A proxy: check the publisher's current policy and any embargo before depositing.
Columns (11) in Repository candidates
Columns in Repository candidates Column Meaning institutionConnecticut institution the article is credited to institution_keyShort key for the institution openalex_idOpenAlex work ID doiDOI link titleArticle title yearPublication year year_completefalse for 2026, which is still being indexed journalJournal publisherTop-level publisher current_statusclosed or bronze journal_deposit_evidence_articlesArticles in this journal (2015 to 2025, worldwide) free only as an accepted manuscript in a repository other than PubMed Central or Europe PMC. Higher means stronger evidence Read me for the candidate list
How the list was built and how to use it.
Cross-checks
Comparisons between OpenAlex and other sources, used to test OpenAlex. Their numbers are never added to the main figures. Licenses differ by file.
Cross-check summary
The agreement figures quoted on the Methods page, with numerators and denominators.
Columns (5) in Cross-check summary
Columns in Cross-check summary Column Meaning metricWhat is measured numeratorCount that meets the test denominatorCount tested shareworks divided by all articles for that entity (and year, if given) noteNotes Cross-check sample
The 510 articles checked against other sources: 30 per institution, 2015 to 2025, with a DOI.
Columns (8) in Cross-check sample
Columns in Cross-check sample Column Meaning institution_keyInstitution the article was sampled for work_idOpenAlex work ID yearPublication year doiDOI of the article oa_statusOpenAlex's own status (diamond not split) oa_categoryOpen access category: diamond, oa_fee_unconfirmed, gold, hybrid, bronze, green or closed (see the Methods page) source_idOpenAlex journal ID source_issn_lJournal ISSN-L Unpaywall lookups
What Unpaywall says about each sample article. Unpaywall runs on the OpenAlex database, so this is a consistency check, not an independent one.
Columns (8) in Unpaywall lookups
Columns in Unpaywall lookups Column Meaning work_idOpenAlex work ID doiDOI of the article foundUnpaywall knows the DOI upw_is_oaUnpaywall: free to read upw_oa_statusUnpaywall status upw_has_repository_copyUnpaywall lists a free repository copy upw_has_accepted_repository_copyThat copy is an accepted or published version upw_journal_is_in_doajUnpaywall: journal is in DOAJ OpenAIRE lookups
What the OpenAIRE Graph says about each sample article.
Columns (8) in OpenAIRE lookups
Columns in OpenAIRE lookups Column Meaning work_idOpenAlex work ID doiDOI of the article foundOpenAIRE knows the DOI oaire_accessBest access right: OPEN, CLOSED, RESTRICTED, EMBARGO, or blank (no information) oaire_colorPublisher open access color: gold, hybrid or bronze oaire_is_greenOpenAIRE lists a repository copy oaire_in_diamond_journalOpenAIRE marks the journal as diamond oaire_n_recordsOpenAIRE records found for the DOI DOAJ journal checks
Journals checked against the Directory of Open Access Journals: listed or not, fee or no fee, open access start year.
Columns (13) in DOAJ journal checks
Columns in DOAJ journal checks Column Meaning source_idOpenAlex journal ID journalJournal name in OpenAlex openalex_is_in_doajOpenAlex says the journal is in DOAJ openalex_is_oaOpenAlex says the journal is fully open access openalex_apc_usdOpenAlex listed fee, US dollars in_doajFound in DOAJ by ISSN doaj_has_apcDOAJ: journal charges an article fee doaj_max_apc_usdDOAJ: highest fee in US dollars, if given doaj_max_apc_otherDOAJ: fees in other currencies doaj_has_other_chargesDOAJ: other charges (for example submission or page fees) doaj_oa_startDOAJ: year the journal became open access doaj_addedDate added to DOAJ groupsWhy the journal was checked DOAJ answer for 'fee not confirmed' articles
What DOAJ says about articles in the 'open journal, fee not confirmed' category. Reported only; it does not change the main figures.
Columns (3) in DOAJ answer for 'fee not confirmed' articles
Columns in DOAJ answer for 'fee not confirmed' articles Column Meaning entityWhich group the row describes: an institution key (for example yale, uconn), statewide (all 17, each article once) or statewide_no_yale / statewide_without_yale (articles with at least one author at one of the other 16, each once) doaj_answerdoaj_no_fee, doaj_charges_fee, doaj_no_apc_but_other_charges, published_before_doaj_oa_start, or not_in_doaj worksNumber of articles (articles and reviews), each counted once within the entity DOAJ check of top journals
The 50 journals with the most Connecticut articles, and the 50 largest fully open access journals, with OpenAlex and DOAJ side by side.
Columns (14) in DOAJ check of top journals
Columns in DOAJ check of top journals Column Meaning source_idOpenAlex journal ID journalJournal name in OpenAlex openalex_is_in_doajOpenAlex says the journal is in DOAJ openalex_is_oaOpenAlex says the journal is fully open access openalex_apc_usdOpenAlex listed fee, US dollars in_doajFound in DOAJ by ISSN doaj_has_apcDOAJ: journal charges an article fee doaj_max_apc_usdDOAJ: highest fee in US dollars, if given doaj_max_apc_otherDOAJ: fees in other currencies doaj_has_other_chargesDOAJ: other charges (for example submission or page fees) doaj_oa_startDOAJ: year the journal became open access doaj_addedDate added to DOAJ groupsWhy the journal was checked ct_articles_2015_2025Connecticut articles in the journal, 2015 to 2025 Green proxy: journal evidence
For each journal with closed or bronze Connecticut articles, the deposit evidence count used by the green proxy.
Columns (4) in Green proxy: journal evidence
Columns in Green proxy: journal evidence Column Meaning source_idOpenAlex journal ID journalJournal name in OpenAlex accepted_manuscript_repository_articles_2015_2025Articles (worldwide) free only as an accepted manuscript in a repository other than PubMed Central or Europe PMC shows_deposit_evidencetrue if at least 3 Fees paid compared with listed prices (OpenAPC)
How fees actually paid (reported by other universities to OpenAPC) compare with listed prices, in euros.
Columns (8) in Fees paid compared with listed prices (OpenAPC)
Columns in Fees paid compared with listed prices (OpenAPC) Column Meaning comparisonWhich articles are compared articlesArticles compared total_paid_eurSum of fees paid total_list_eurSum of today's listed prices paid_as_share_of_listtotal_paid_eur divided by total_list_eur median_article_ratioMedian of paid divided by listed, per article ct_works_in_categoryAll Connecticut articles in the category coverageShare of those with a journal benchmark OpenAPC matches
Connecticut articles whose fee was reported to OpenAPC by a co-author's institution.
Columns (11) in OpenAPC matches
Columns in OpenAPC matches Column Meaning work_idOpenAlex work ID doiDOI of the article publication_yearYear of publication in OpenAlex oa_categoryOpen access category: diamond, oa_fee_unconfirmed, gold, hybrid, bronze, green or closed (see the Methods page) source_idOpenAlex journal ID journalJournal name in OpenAlex openapc_periodYear paid openapc_euroFee paid in euros, including VAT openapc_is_hybridOpenAPC: hybrid article openapc_institutionInstitution that reported the payment openalex_list_eur_todayJournal's current listed price in euros (OpenAlex) Cross-check licenses
Which license applies to which file.
Data quality
What was left out and why. Built by pipeline/s05_quality_report.py.
Exclusions summary
Works left out of every figure, by reason.
Columns (3) in Exclusions summary
Columns in Exclusions summary Column Meaning exclude_reasonrepository_record_no_doi, meeting_abstract, or affiliation_correction_no_ct_institution (see Methods) periodcomplete for 2015 to 2025; incomplete for 2026, which is still being indexed worksNumber of articles (articles and reviews), each counted once within the entity Excluded works
Every excluded work with its reason.
Columns (5) in Excluded works
Columns in Excluded works Column Meaning work_idOpenAlex work ID publication_yearYear of publication in OpenAlex source_nameJournal or repository titleTitle exclude_reasonWhy it is excluded Harvest completeness
Works downloaded compared with OpenAlex's own count, per institution and year.
Columns (5) in Harvest completeness
Columns in Harvest completeness Column Meaning institution_keyInstitution publication_yearYear of publication in OpenAlex group_by_countOpenAlex's count harvestedWorks downloaded diffDifference