Example Datasets
We have prepared a series of datasets for you to play to dive in MotherDuck!
The database sample_data
is readily available for all new users, as it's automatically attached to your account.
Other databases are available for you to attach, and you can do so by running the following command:
ATTACH <attach_url> AS <database_name>
Database | schema.table | Description | Share URL | Attached by default |
---|---|---|---|---|
sample_database | who.ambient_air_quality | Historical air quality data from the World Health Organization. | 'md:_share/sample_data/23b0d623-1361-421d-ae77-62d701d471e6' | Yes |
sample_database | nyc.taxi | Taxi Ride data from November 2020 | 'md:_share/sample_data/23b0d623-1361-421d-ae77-62d701d471e6' | Yes |
sample_database | nyc.rideshare | Ride share trips (Lyft, Uber etc) in NYC | 'md:_share/sample_data/23b0d623-1361-421d-ae77-62d701d471e6' | Yes |
sample_database | nyc.service_requests | Requests to NYC's 311 complaint hotline via phone and web | 'md:_share/sample_data/23b0d623-1361-421d-ae77-62d701d471e6' | Yes |
sample_database | hn.hacker_news | Sample of comments from Hacker News | 'md:_share/sample_data/23b0d623-1361-421d-ae77-62d701d471e6' | Yes |
sample_database | kaggle.movies | Sample of the movies dataset from Kaggle | 'md:_share/sample_data/23b0d623-1361-421d-ae77-62d701d471e6' | Yes |
sample_database | stackoverflow_survey.survey_results | Survey results from 2017 to 2024 | 'md:_share/sample_data/23b0d623-1361-421d-ae77-62d701d471e6' | Yes |
sample_database | stackoverflow_survey.survey_schemas | Survey schemas (questions from the survey) from 2017 to 2024 | 'md:_share/sample_data/23b0d623-1361-421d-ae77-62d701d471e6' | Yes |
stackoverflow | main.badges | Full StackOverflow data dump up to May 2023 | 'md:_share/stackoverflow/6c318917-6888-425a-bea1-5860c29947e5' | No |
stackoverflow | main.comments | Full StackOverflow data dump up to May 2023 | 'md:_share/stackoverflow/6c318917-6888-425a-bea1-5860c29947e5' | No |
stackoverflow | main.post_links | Full StackOverflow data dump up to May 2023 | 'md:_share/stackoverflow/6c318917-6888-425a-bea1-5860c29947e5' | No |
stackoverflow | main.posts | Full StackOverflow data dump up to May 2023 | 'md:_share/stackoverflow/6c318917-6888-425a-bea1-5860c29947e5' | No |
stackoverflow | main.tags | Full StackOverflow data dump up to May 2023 | 'md:_share/stackoverflow/6c318917-6888-425a-bea1-5860c29947e5' | No |
stackoverflow | main.votes | Full StackOverflow data dump up to May 2023 | 'md:_share/stackoverflow/6c318917-6888-425a-bea1-5860c29947e5' | No |
stackoverflow | main.users | Full StackOverflow data dump up to May 2023 | 'md:_share/stackoverflow/6c318917-6888-425a-bea1-5860c29947e5' | No |
duckdb_stats | PyPi data on DuckDB project | Pythons data download from PyPi on the duckdb Python package, refreshed daily | 'md:_share/duckdb_stats/1eb684bf-faff-4860-8e7d-92af4ff9a410' | No |
hacker_news | hacker_news.hacker_news | Full Hacker News datasets from 2016 to 2025 | 'md:_share/hacker_news/de11a0e3-9d68-48d2-ac44-40e07a1d496b' | No |