runtime

datasets real and made-up data to practise on

Datasets

Data for the Playground, Database Lab and Performance Lab. Pick one and open its files.

The 1,200 most-cited research works from 2019–2024 that mention Python, with authors and venues.

200 papers3 tablesJan 2019 – Dec 2024

what to watch for

Tricky rows

  • Works with no DOI3 rows
  • Works with no page numbers35 rows
  • Authorships with no institution216 rows
  • Works with more than 20 authors27 rows

files

Open a file to see what one row means, its columns and a preview. Open in Playground starts a new file there with code that loads it.

works200 rows · 22 columns · CSV

One research work (article, chapter or preprint).

In your code: data/works.csv

  • work_idtextkey

    OpenAlex work ID

  • doitext · can be empty

    DOI link

  • titletext · can be empty

    Title

  • publication_yearinteger

    Year published

  • publication_datedate

    Date published

  • typetext

    article, book-chapter or preprint

  • languagetext · can be empty

    Language code

  • cited_by_countinteger

    Times cited (when collected)

  • is_retractedinteger

    1 if retracted

  • is_oainteger

    1 if free to read

  • oa_statustext · can be empty

    How it is free to read: gold, green, hybrid, bronze, diamond, or closed (not free)

  • source_nametext · can be empty

    Journal, conference or repository

  • source_typetext · can be empty

    journal, repository, conference, …

  • publishertext · can be empty

    Publisher

  • licencetext · can be empty

    Licence of the primary version

  • topictext · can be empty

    Main research topic

  • fieldtext · can be empty

    Field of the main topic

  • referenced_works_countinteger

    Number of works it cites

  • volumetext · can be empty

    Volume

  • issuetext · can be empty

    Issue

  • first_pagetext · can be empty

    First page

  • last_pagetext · can be empty

    Last page

authorships2,007 rows · 8 columns · CSV

One author of one work, in the order the paper lists them.

In your code: data/authorships.csv

  • work_idtextkey→ works

    Work

  • author_orderintegerkey

    Position in the author list (1 = first)

  • author_positiontext

    first, middle or last

  • author_idtext · can be empty

    OpenAlex author ID

  • author_nametext · can be empty

    Name as OpenAlex shows it

  • institutionstext · can be empty

    Institutions, separated by "; "

  • countriestext · can be empty

    Country codes, separated by ";"

  • is_correspondinginteger

    1 for the author who handles contact about the paper

keywords1,648 rows · 3 columns · CSV

One keyword OpenAlex assigned to a work, with its score.

In your code: data/keywords.csv

  • work_idtextkey→ works

    Work

  • keywordtextkey

    Keyword

  • scoredecimal

    Relevance, 0–1

data/works.jsonl200 records · JSON Lines

One research work (article, chapter or preprint).

In your code: data/works.jsonl

data/api/works-page-1.json200 records · JSON

One research work (article, chapter or preprint).

In your code: data/api/works-page-1.json

relationships

How to join these tables. Left column matches the right column.

  • authorships.work_id → works.work_id
  • keywords.work_id → works.work_id

where the course uses it

Lessons and practice questions use small samples of Research Papers; projects open its files.

Research Papers dataset — Python Datasets · Runtime