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

    free_to_read_2015_2025.csv · 1 KB · License: CC0 1.0

    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
    ColumnMeaning
    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

    free_to_read_by_year.csv · 17 KB · License: CC0 1.0

    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
    ColumnMeaning
    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

    oa_category_2015_2025.csv · 9 KB · License: CC0 1.0

    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
    ColumnMeaning
    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

    oa_category_by_year.csv · 126 KB · License: CC0 1.0

    The same, for each year from 2015 to 2026.

    Columns (7) in Open access categories, by year
    Columns in Open access categories, by year
    ColumnMeaning
    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

    publishers_2015_2025.csv · 18 KB · License: CC0 1.0

    Articles and closed articles by publisher (imprints grouped under their parent company), top publishers per entity.

    Columns (8) in Publishers
    Columns in Publishers
    ColumnMeaning
    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

    fields_2015_2025.csv · 19 KB · License: CC0 1.0

    Articles and closed articles by OpenAlex field (a broad subject group, from each article's main topic).

    Columns (8) in Fields
    Columns in Fields
    ColumnMeaning
    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

    topics_2015_2025.csv · 28 KB · License: CC0 1.0

    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
    ColumnMeaning
    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

    apc_estimates_2015_2025.csv · 3 KB · License: CC0 1.0

    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
    ColumnMeaning
    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

    apc_estimates_by_year.csv · 40 KB · License: CC0 1.0

    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
    ColumnMeaning
    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

    corresponding_coverage.csv · 3 KB · License: CC0 1.0

    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
    ColumnMeaning
    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)

    green_opportunity_2015_2025.csv · 1 KB · License: CC0 1.0

    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)
    ColumnMeaning
    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

    books_and_chapters_2015_2025.csv · 815 bytes · License: CC0 1.0

    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
    ColumnMeaning
    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

    manifest.json · 2 KB · License: CC0 1.0

    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

    repository_candidates.csv · 12.5 MB · License: CC0 1.0

    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
    ColumnMeaning
    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

    README.md · 2 KB · License: CC0 1.0

    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

    summary.csv · 589 bytes · License: CC0 1.0

    The agreement figures quoted on the Methods page, with numerators and denominators.

    Columns (5) in Cross-check summary
    Columns in Cross-check summary
    ColumnMeaning
    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

    sample.csv · 44 KB · License: CC0 1.0

    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
    ColumnMeaning
    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

    unpaywall_sample.csv · 36 KB · License: CC0 1.0

    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
    ColumnMeaning
    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

    openaire_sample.csv · 33 KB · License: CC BY 4.0, credit OpenAIRE Research Graph (doi:10.5281/zenodo.3516917)

    What the OpenAIRE Graph says about each sample article.

    Columns (8) in OpenAIRE lookups
    Columns in OpenAIRE lookups
    ColumnMeaning
    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

    doaj_journals.csv · 328 KB · License: CC0 1.0

    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
    ColumnMeaning
    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

    doaj_fee_unconfirmed.csv · 2 KB · License: CC0 1.0

    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
    ColumnMeaning
    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

    doaj_top_journals.csv · 8 KB · License: CC0 1.0

    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
    ColumnMeaning
    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

    green_proxy_journals.csv · 511 KB · License: CC0 1.0

    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
    ColumnMeaning
    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)

    openapc_summary.csv · 765 bytes · License: Contains information from OpenAPC, made available under the ODbL 1.0

    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)
    ColumnMeaning
    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

    openapc_ct_matches.csv · 112 KB · License: ODbL 1.0

    Connecticut articles whose fee was reported to OpenAPC by a co-author's institution.

    Columns (11) in OpenAPC matches
    Columns in OpenAPC matches
    ColumnMeaning
    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

    LICENSE.md · 1 KB

    Which license applies to which file.

Data quality

What was left out and why. Built by pipeline/s05_quality_report.py.

  • Exclusions summary

    exclusions_summary.csv · 277 bytes · License: CC0 1.0

    Works left out of every figure, by reason.

    Columns (3) in Exclusions summary
    Columns in Exclusions summary
    ColumnMeaning
    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

    excluded_works.csv · 510 KB · License: CC0 1.0

    Every excluded work with its reason.

    Columns (5) in Excluded works
    Columns in Excluded works
    ColumnMeaning
    work_idOpenAlex work ID
    publication_yearYear of publication in OpenAlex
    source_nameJournal or repository
    titleTitle
    exclude_reasonWhy it is excluded
  • Harvest completeness

    completeness_by_institution_year.csv · 5 KB · License: CC0 1.0

    Works downloaded compared with OpenAlex's own count, per institution and year.

    Columns (5) in Harvest completeness
    Columns in Harvest completeness
    ColumnMeaning
    institution_keyInstitution
    publication_yearYear of publication in OpenAlex
    group_by_countOpenAlex's count
    harvestedWorks downloaded
    diffDifference