# Sample datasets

Memgraph publishes sample graph datasets that you can load to try Cypher
queries, [graph algorithms](https://memgraph.com/docs/advanced-algorithms) and [Memgraph
Lab](https://memgraph.com/docs/memgraph-lab) visualizations. Each dataset is a [CYPHERL
file](https://memgraph.com/docs/data-migration/cypherl): Cypher queries that create its indexes, nodes
and relationships.

## Load a dataset

Load a dataset into an empty database. Loading it again, or into a database
that already has data, adds a second copy of its nodes and relationships. To
empty the database first, run:

```cypher
MATCH (n) DETACH DELETE n;
```

You can load a dataset with mgconsole or with Memgraph Lab.

### With mgconsole

If Memgraph runs in Docker, download the dataset's file and pipe it into
[mgconsole](https://memgraph.com/docs/getting-started/cli) inside the container. This command loads
Capital cities and borders:

```bash
curl -fsSL https://download.memgraph.com/datasets/country-capitals/cypherl/dataset.cypherl.gz | gunzip | docker exec -i CONTAINER_NAME mgconsole
```

`CONTAINER_NAME` is the name of your Memgraph container: `memgraph-mage` if
you started Memgraph with the [Getting started
installer](https://memgraph.com/docs/getting-started#install-memgraph-platform). For another dataset,
use its file link from the [list of datasets](#available-datasets).

Check that the counts match the dataset's row in the list. For Capital cities
and borders:

```cypher
MATCH (n) RETURN count(n) AS nodes;
```

```plaintext copy=false
+-------+
| nodes |
+-------+
| 212   |
+-------+
```

### With Memgraph Lab

In Memgraph Lab, open **Datasets** in the sidebar, find the dataset and click
**Load dataset**. Lab lists the datasets from the same catalog as the list
below.

## Available datasets

The datasets are listed by title. The slug is the dataset's name in its file
link, and the file link is what the [mgconsole command](#with-mgconsole)
loads. The same list is available as JSON at
`https://download.memgraph.com/datasets/items.v1.json`, with each dataset's
graph model and sample queries.

| Dataset | Slug | Description | Nodes | Relationships | File |
| --- | --- | --- | --- | --- | --- |
| Analysis of energy management systems | `energy-management-system` | Energy management model with connected power generators across Europe. | 8,422 | 11,437 | [CYPHERL](https://download.memgraph.com/datasets/energy-management-system/cypherl/dataset.cypherl.gz) |
| Base station network of Zagreb | `base-station-network-of-zagreb` | Artificially generated geographic data about 200 base stations in Zagreb, Croatia. | 200 | 2,388 | [CYPHERL](https://download.memgraph.com/datasets/base-station-network-of-zagreb/cypherl/dataset.cypherl.gz) |
| Business process management | `business-process-management` | Sample dataset of business process definitions and their recorded executions across an organization. | 32,594 | 112,131 | [CYPHERL](https://download.memgraph.com/datasets/business-process-management/cypherl/dataset.cypherl.gz) |
| Capital cities and borders | `country-capitals` | Network of capital cities connected as neighboring countries. | 212 | 369 | [CYPHERL](https://download.memgraph.com/datasets/country-capitals/cypherl/dataset.cypherl.gz) |
| CORA: Scientific publications classified into seven categories | `cora-scientific-publications` | 2708 scientific publications classified into one of seven classes. | 2,708 | 5,278 | [CYPHERL](https://download.memgraph.com/datasets/cora-scientific-publications/cypherl/dataset.cypherl.gz) |
| Country import and export trades | `country-trade-imports-exports` | International merchandise and commercial services trade data per country. | 190 | 27,779 | [CYPHERL](https://download.memgraph.com/datasets/country-trade-imports-exports/cypherl/dataset.cypherl.gz) |
| Drug combinations database | `drug-combinations` | Drug combinations database is comprehensive collection of drug combinations from various sources. | 2,956 | 191,387 | [CYPHERL](https://download.memgraph.com/datasets/drug-combinations/cypherl/dataset.cypherl.gz) |
| Europe backpacking | `europe-backpacking` | Tourist prices and other data for 56 of the most popular European cities. See the [tutorial](https://memgraph.com/docs/querying/exploring-datasets/backpacking-through-europe). | 92 | 349 | [CYPHERL](https://download.memgraph.com/datasets/europe-backpacking/cypherl/dataset.cypherl.gz) |
| Europe gas pipelines | `europe-gas-pipelines-scigrid` | SciGRID_gas dataset of European natural gas transmission infrastructure. | 1,604 | 2,181 | [CYPHERL](https://download.memgraph.com/datasets/europe-gas-pipelines-scigrid/cypherl/dataset.cypherl.gz) |
| Europe road network | `europe-road-network` | Road network of 999 major European cities from 39 countries. See the [tutorial](https://memgraph.com/docs/querying/exploring-datasets/exploring-the-european-road-network). | 1,038 | 65,379 | [CYPHERL](https://download.memgraph.com/datasets/europe-road-network/cypherl/dataset.cypherl.gz) |
| Eurovision voting results | `eurovision-voting-results` | Eurovision Song Contest results from 1975 to 2023. | 54 | 38,415 | [CYPHERL](https://download.memgraph.com/datasets/eurovision-voting-results/cypherl/dataset.cypherl.gz) |
| F1 races from 1950 to 2022 | `f1-races` | Dataset containing historic F1 race results, with individual drivers and constructors. | 4,372 | 48,658 | [CYPHERL](https://download.memgraph.com/datasets/f1-races/cypherl/dataset.cypherl.gz) |
| Football player's transfers | `football-player-transfers` | Football transfers in famous five European football leagues. See the [tutorial](https://memgraph.com/docs/querying/exploring-datasets/football-transfers). | 14,577 | 56,622 | [CYPHERL](https://download.memgraph.com/datasets/football-player-transfers/cypherl/dataset.cypherl.gz) |
| Football Premier league games | `football-premier-league-games` | Football matches across world's most popular leagues. See the [tutorial](https://memgraph.com/docs/querying/exploring-datasets/graphing-the-premier-league). | 78,380 | 155,570 | [CYPHERL](https://download.memgraph.com/datasets/football-premier-league-games/cypherl/dataset.cypherl.gz) |
| Game of Thrones deaths | `game-of-thrones-deaths` | Kills and deaths of various characters from the Game of Thrones TV show. See the [tutorial](https://memgraph.com/docs/querying/exploring-datasets/got-deaths). | 2,677 | 11,967 | [CYPHERL](https://download.memgraph.com/datasets/game-of-thrones-deaths/cypherl/dataset.cypherl.gz) |
| Global supply chain | `global-supply-chain` | Sample dataset of a multi-tier electronics supply chain, from raw materials and suppliers to customer deliveries and the risks that disrupt them. | 14,400 | 61,616 | [CYPHERL](https://download.memgraph.com/datasets/global-supply-chain/cypherl/dataset.cypherl.gz) |
| Graph technology landscape | `graph-technology-landscape` | Network of popular graph technologies and the categories they belong to. | 349 | 368 | [CYPHERL](https://download.memgraph.com/datasets/graph-technology-landscape/cypherl/dataset.cypherl.gz) |
| Hetionet: network of biology, disease, and pharmacology | `hetionet` | Hetionet is a hetnet — network with multiple node and edge (relationship) types — which encodes biology, disease, and pharmacology. | 47,031 | 2,250,197 | [CYPHERL](https://download.memgraph.com/datasets/hetionet/cypherl/dataset.cypherl.gz) |
| High-energy physics citation network | `physics-citation-network` | High-energy physics citation graph is from the e-print arXiv and covers some of the citations within a dataset of 395 nodes and 1106 edges. | 395 | 1,106 | [CYPHERL](https://download.memgraph.com/datasets/physics-citation-network/cypherl/dataset.cypherl.gz) |
| Identity and access management | `iam-memgraph` | A sample of identity and access management model on Memgraph. | 27 | 37 | [CYPHERL](https://download.memgraph.com/datasets/iam-memgraph/cypherl/dataset.cypherl.gz) |
| Karate club friendship network | `karate-club-friendship-network` | Zachary's karate club as a social network of a university karate club. | 34 | 78 | [CYPHERL](https://download.memgraph.com/datasets/karate-club-friendship-network/cypherl/dataset.cypherl.gz) |
| Knowledge graph of parts dependencies | `dependencies-knowledge-graph` | A sample of Knowledge Graph of parts dependencies. | 38 | 57 | [CYPHERL](https://download.memgraph.com/datasets/dependencies-knowledge-graph/cypherl/dataset.cypherl.gz) |
| Marvel Cinematic Universe | `marvel-cinematic-universe` | Social network of various comics interactions between heroes from MCU. See the [tutorial](https://memgraph.com/docs/querying/exploring-datasets/marvel-universe). | 21,732 | 682,943 | [CYPHERL](https://download.memgraph.com/datasets/marvel-cinematic-universe/cypherl/dataset.cypherl.gz) |
| MovieLens: Movies, genres and users | `movielens` | MovieLens dataset of users, genres and movie ratings. See the [tutorial](https://memgraph.com/docs/querying/exploring-datasets/movie-recommendation). | 32,436 | 122,920 | [CYPHERL](https://download.memgraph.com/datasets/movielens/cypherl/dataset.cypherl.gz) |
| Music genres social network | `music-genres-social-network` | Network of users and genres from the music streaming platform Deezer. | 2,001 | 5,170 | [CYPHERL](https://download.memgraph.com/datasets/music-genres-social-network/cypherl/dataset.cypherl.gz) |
| Network of air traffic | `air-traffic` | Dataset containing airways, airports and waypoints. | 188 | 559 | [CYPHERL](https://download.memgraph.com/datasets/air-traffic/cypherl/dataset.cypherl.gz) |
| Protein-protein interaction network | `protein-interactions` | Protein-protein interaction (PPI) networks are mathematical representations of the physical contacts between proteins in the cell. | 262 | 784 | [CYPHERL](https://download.memgraph.com/datasets/protein-interactions/cypherl/dataset.cypherl.gz) |
| Python dependency vulnerabilities | `python-dependency-vulnerabilities` | Sample dataset used for cybersecurity analysis of Python dependency packages. | 284 | 158 | [CYPHERL](https://download.memgraph.com/datasets/python-dependency-vulnerabilities/cypherl/dataset.cypherl.gz) |
| S&P 500 stock prices | `sp-500-stock-prices` | Stock price dataset containing 503 stocks that are currently part of s&p 500. | 538 | 17,639 | [CYPHERL](https://download.memgraph.com/datasets/sp-500-stock-prices/cypherl/dataset.cypherl.gz) |
| Subreddit network explorer | `subreddit-network-explorer` | Subset of posts and comments from the subreddit /r/worldnews. | 852 | 744 | [CYPHERL](https://download.memgraph.com/datasets/subreddit-network-explorer/cypherl/dataset.cypherl.gz) |
| Supply chain analysis | `supply-chain-analysis` | Sample dataset used for the analysis of a common supply chain. | 34 | 49 | [CYPHERL](https://download.memgraph.com/datasets/supply-chain-analysis/cypherl/dataset.cypherl.gz) |
| TED talks | `ted-talks` | Shows 97 TED talks filled with interconnected speakers, talks, events, and tags. See the [tutorial](https://memgraph.com/docs/querying/exploring-datasets/analyzing-ted-talks). | 354 | 2,259 | [CYPHERL](https://download.memgraph.com/datasets/ted-talks/cypherl/dataset.cypherl.gz) |
| The Pandora Papers | `icij-pandora-papers` | A sample of the Pandora Papers containing offshore entities, world leaders and public officials. | 389 | 740 | [CYPHERL](https://download.memgraph.com/datasets/icij-pandora-papers/cypherl/dataset.cypherl.gz) |
| Twitter Christmas retweets | `twitter-christmas-retweets` | A Twitter network of retweets that contain the hashtag `#Christmas`. | 1,868 | 1,967 | [CYPHERL](https://download.memgraph.com/datasets/twitter-christmas-retweets/cypherl/dataset.cypherl.gz) |
| USA national parks | `national-parks` | Various data about animals, plants and details of national parks they live in. | 13,629 | 43,204 | [CYPHERL](https://download.memgraph.com/datasets/national-parks/cypherl/dataset.cypherl.gz) |
| Vehicle insurance data | `vehicle-insurance` | Generated sample dataset of vehicle insurance claims and policies. | 8,582 | 12,128 | [CYPHERL](https://download.memgraph.com/datasets/vehicle-insurance/cypherl/dataset.cypherl.gz) |
| Video game sales | `video-game-sales` | Large amount of information on video game sales from 1980 till 2016. | 8,825 | 27,065 | [CYPHERL](https://download.memgraph.com/datasets/video-game-sales/cypherl/dataset.cypherl.gz) |
| Wikipedia articles | `wiki-articles` | Various Contents and contexts of 339 featured Wikipedia articles. | 78,181 | 310,227 | [CYPHERL](https://download.memgraph.com/datasets/wiki-articles/cypherl/dataset.cypherl.gz) |