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_id
OpenAlex work ID
- doi
DOI link
- title
Title
- publication_year
Year published
- publication_date
Date published
- type
article, book-chapter or preprint
- language
Language code
- cited_by_count
Times cited (when collected)
- is_retracted
1 if retracted
- is_oa
1 if free to read
- oa_status
How it is free to read: gold, green, hybrid, bronze, diamond, or closed (not free)
- source_name
Journal, conference or repository
- source_type
journal, repository, conference, …
- publisher
Publisher
- licence
Licence of the primary version
- topic
Main research topic
- field
Field of the main topic
- referenced_works_count
Number of works it cites
- volume
Volume
- issue
Issue
- first_page
First page
- last_page
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_id
Work
- author_order
Position in the author list (1 = first)
- author_position
first, middle or last
- author_id
OpenAlex author ID
- author_name
Name as OpenAlex shows it
- institutions
Institutions, separated by "; "
- countries
Country codes, separated by ";"
- is_corresponding
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_id
Work
- keyword
Keyword
- score
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