Dataset: Stardew Valley FULL Catalog

About this Dataset

Stardew Valley FULL Catalog

Context

NOTE: DATA CONTAINS SPOILERS!

This data was compiled from the [Official Stardew Valley Wiki](stardewvalleywiki.com as a comprehensive dataset containing Stardew Valley information.
According to Wikipedia:

Stardew Valley is a simulation role-playing video game developed by Eric "ConcernedApe" Barone. It initially released for Microsoft Windows in February 2016 before being ported to several other computer, console, and mobile platforms.

Content

Because I'm just getting started, I'm hoping to add new data every day! The data was collected by myself using information from the Official Stardew Valley Wiki for public use. The database contains the original raw data. At the time of writing, the official wiki page was updated on March 3, 2022. Please contribute or comment if there is anything you'd like to see!

Acknowledgements

All of this information comes from the creators of the Official Stardew Valley Wiki as well as Eric Barone - the creator of Stardew Valley! Please checkout the wiki, the official Stardew Valley Website, as well as the Stardew Valley Discord Server to join the large community of Stardew lovers like myself!

Inspiration

I've been playing Stardew Valley since 2019... it was the game that got me into gaming! I've loved every minute I've spent farming, building, crafting and creating in Stardew, and along the way I've found many helpful online resources to aid me. I thought this would be a fun way to practice my data skills, as well as provide some information to my fellow farmers!

Tables

Crabpotandothercatchables

@kaggle.jessicaebrown_stardew_valley_full_catelog.crabpotandothercatchables

8.52 KB
14 rows
10 columns


CREATE TABLE crabpotandothercatchables (
  "name" VARCHAR,
  "description" VARCHAR,
  "price" VARCHAR,
  "fisher_profession_25" VARCHAR,
  "angler_profession_50" VARCHAR,
  "location" VARCHAR,
  "trap_chance" VARCHAR,
  "unnamed_7" VARCHAR,
  "size_inches" VARCHAR,
  "used_in" VARCHAR
);

Fish Detail

@kaggle.jessicaebrown_stardew_valley_full_catelog.fish_detail

11.38 KB
47 rows
10 columns


CREATE TABLE fish_detail (
  "name" VARCHAR,
  "description" VARCHAR,
  "location" VARCHAR,
  "time" VARCHAR,
  "season" VARCHAR,
  "weather" VARCHAR,
  "size_inches" VARCHAR,
  "difficulty_behavior" VARCHAR,
  "base_xp" BIGINT,
  "used_in" VARCHAR
);

Fish Price Breakdown

@kaggle.jessicaebrown_stardew_valley_full_catelog.fish_price_breakdown

30.3 KB
12 rows
48 columns


CREATE TABLE fish_price_breakdown (
  "name" VARCHAR,
  "pufferfish" VARCHAR,
  "anchovy" VARCHAR,
  "tuna" VARCHAR,
  "sardine" VARCHAR,
  "bream" VARCHAR,
  "largemouth_bass" VARCHAR,
  "smallmouth_bass" VARCHAR,
  "rainbow_trout" VARCHAR,
  "salmon" VARCHAR,
  "walleye" VARCHAR,
  "perch" VARCHAR,
  "carp" VARCHAR,
  "catfish" VARCHAR,
  "pike" VARCHAR,
  "sunfish" VARCHAR,
  "red_mullet" VARCHAR,
  "herring" VARCHAR,
  "eel" VARCHAR,
  "octopus" VARCHAR,
  "red_snapper" VARCHAR,
  "squid" VARCHAR,
  "sea_cucumber" VARCHAR,
  "super_cucumber" VARCHAR,
  "ghostfish" VARCHAR,
  "stonefish" VARCHAR,
  "ice_pip" VARCHAR,
  "lava_eel" VARCHAR,
  "sandfish" VARCHAR,
  "scorpion_carp" VARCHAR,
  "flounder" VARCHAR,
  "midnight_carp" VARCHAR,
  "sturgeon" VARCHAR,
  "tiger_trout" VARCHAR,
  "bullhead" VARCHAR,
  "tilapia" VARCHAR,
  "chub" VARCHAR,
  "dorado" VARCHAR,
  "albacore" VARCHAR,
  "shad" VARCHAR,
  "lingcod" VARCHAR,
  "halibut" VARCHAR,
  "woodskip" VARCHAR,
  "void_salmon" VARCHAR,
  "slimejack" VARCHAR,
  "stingray" VARCHAR,
  "lionfish" VARCHAR,
  "blue_discus" VARCHAR
);

Legendaryfishii

@kaggle.jessicaebrown_stardew_valley_full_catelog.legendaryfishii

10.02 KB
5 rows
12 columns


CREATE TABLE legendaryfishii (
  "name" VARCHAR,
  "description" VARCHAR,
  "price" VARCHAR,
  "fisher_profession_25" VARCHAR,
  "angler_profession_50" VARCHAR,
  "location" VARCHAR,
  "time" VARCHAR,
  "season" VARCHAR,
  "weather" VARCHAR,
  "size_inches" VARCHAR,
  "difficulty_behavior" VARCHAR,
  "base_xp" BIGINT
);

Legendary Fish Detail

@kaggle.jessicaebrown_stardew_valley_full_catelog.legendary_fish_detail

7.18 KB
5 rows
9 columns


CREATE TABLE legendary_fish_detail (
  "name" VARCHAR,
  "description" VARCHAR,
  "location" VARCHAR,
  "time" VARCHAR,
  "season" VARCHAR,
  "weather" VARCHAR,
  "size_inches" VARCHAR,
  "difficulty_behavior" VARCHAR,
  "base_xp" BIGINT
);

Legendary Fish Price Breakdown

@kaggle.jessicaebrown_stardew_valley_full_catelog.legendary_fish_price_breakdown

4.77 KB
12 rows
6 columns


CREATE TABLE legendary_fish_price_breakdown (
  "name" VARCHAR,
  "crimsonfish" VARCHAR,
  "angler" VARCHAR,
  "legend" VARCHAR,
  "glacierfish" VARCHAR,
  "mutant_carp" VARCHAR
);

Nightmarketfish

@kaggle.jessicaebrown_stardew_valley_full_catelog.nightmarketfish

7.75 KB
3 rows
9 columns


CREATE TABLE nightmarketfish (
  "name" VARCHAR,
  "description" VARCHAR,
  "price" VARCHAR,
  "fish_profession_25" VARCHAR,
  "angler_profession_50" VARCHAR,
  "size" VARCHAR,
  "difficulty_behavior" VARCHAR,
  "base_xp" BIGINT,
  "used_in" VARCHAR
);

Villagers

@kaggle.jessicaebrown_stardew_valley_full_catelog.villagers

4.33 KB
45 rows
5 columns


CREATE TABLE villagers (
  "name" VARCHAR,
  "gender" VARCHAR,
  "marriage_candidate" VARCHAR,
  "giftable" VARCHAR,
  "heart_events" BIGINT
);