Name: Pokemon Stats Generations 1-9
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Pokemon Stats Generations 1-9

This dataset encompasses the statistics of all 1008 Pokémon featured in the Pokémon Games, excluding Pokémon Cards and Pokémon GO.

Dex No: Pokedex number (Identification Number) for each individual Pokémon.
Name: The name of each Pokémon. Some Pokemon have multiple forms and this is where form information is stored
Base Name: The base name of the Pokemon, regardless of the form
Type 1: Each Pokémon possesses a primary type, which determines its weaknesses and resistances to attacks.
Type 2: Certain Pokémon exhibit a dual type, giving it more/less resistances and weaknesses
BST: Stands for Base Stat Total, the sum of all the Pokemon's statistics, providing a general gauge of a Pokémon's strength.
HP: The Hit Points stat of the Pokemon, denoting the health and the amount of damage a Pokémon can endure before fainting.
Attack: The regular attack stat of the Pokemon, which controls the modifier for physical attacks
Defense: The regular defense stat of the Pokemon, which controls its resistance to physical attacks
Sp Attack: The special attack stat of the Pokemon, which controls the modifier for special attacks
Sp Defense: The special defense stat of the Pokemon, which controls its resistance to special attacks
Speed: The speed stat of the Pokemon. In battle, the Pokemon with the higher speed stat moves first

The data for this compilation was sourced from: pokemondb

Tables

Pokemon

@kaggle.jkorn28_pokemon_stats_gens_1_9.pokemon

49.63 kB
1,194 rows
12 columns

CREATE TABLE pokemon (
  "dex_no" BIGINT,
  "name" VARCHAR,
  "base_name" VARCHAR,
  "type_1" VARCHAR,
  "type_2" VARCHAR,
  "bst" BIGINT,
  "hp" BIGINT,
  "attack" BIGINT,
  "defense" BIGINT,
  "sp_attack" BIGINT  -- Sp. Attack,
  "sp_defense" BIGINT  -- Sp. Defense,
  "speed" BIGINT
);