Dataset: Pokemon Database

About this Dataset

Pokemon Database

Context

This database was originally created as a class project but I have since expanded greatly on the original purpose.

Content

This database contains all information regarding each pokemon, including typing, abilities, egg groups, evolutions, alternate forms and more!

Tables

Pokemon Database

@kaggle.mrdew25_pokemon_database.pokemon_database

136.05 KB
1382 rows
45 columns


CREATE TABLE pokemon_database (
  "pokemon_id" BIGINT,
  "pokedex_number" BIGINT,
  "pokemon_name" VARCHAR,
  "classification" VARCHAR,
  "alternate_form_name" VARCHAR,
  "original_pokemon_id" DOUBLE,
  "legendary_type" VARCHAR,
  "pokemon_height" DOUBLE,
  "pokemon_weight" DOUBLE,
  "primary_type" VARCHAR,
  "secondary_type" VARCHAR,
  "primary_ability" VARCHAR,
  "primary_ability_description" VARCHAR,
  "secondary_ability" VARCHAR,
  "secondary_ability_description" VARCHAR,
  "hidden_ability" VARCHAR,
  "hidden_ability_description" VARCHAR,
  "special_event_ability" VARCHAR,
  "special_event_ability_description" VARCHAR,
  "male_ratio" DOUBLE,
  "female_ratio" DOUBLE,
  "base_happiness" BIGINT,
  "game_s_of_origin" VARCHAR,
  "health_stat" BIGINT,
  "attack_stat" BIGINT,
  "defense_stat" BIGINT,
  "special_attack_stat" BIGINT,
  "special_defense_stat" BIGINT,
  "speed_stat" BIGINT,
  "base_stat_total" BIGINT,
  "health_ev" BIGINT,
  "attack_ev" BIGINT,
  "defense_ev" BIGINT,
  "special_attack_ev" BIGINT,
  "special_defense_ev" BIGINT,
  "speed_ev" BIGINT,
  "ev_yield_total" BIGINT,
  "catch_rate" BIGINT,
  "experience_growth" VARCHAR,
  "experience_growth_total" BIGINT,
  "primary_egg_group" VARCHAR,
  "secondary_egg_group" VARCHAR,
  "egg_cycle_count" BIGINT,
  "pre_evolution_pokemon_id" DOUBLE,
  "evolution_details" VARCHAR
);