Pokemon Stats Generations 1-9

Names, typings, and base stats of all the Pokemon from generations 1 through 9

@kaggle.jkorn28_pokemon_stats_gens_1_9

Table List

1 table(48.47 KB)

Pokemon

@kaggle.jkorn28_pokemon_stats_gens_1_9.pokemon

48.47 KB
1194 rows
12 columns

dex_no Dex No	name Name	base_name Base Name	type_1 Type 1	type_2 Type 2	bst BST	hp HP	attack Attack	defense Defense	sp_attack Sp. Attack	sp_defense Sp. Defense	speed Speed
1	Bulbasaur	Bulbasaur	GRASS	POISON	318	45	49	49	65	65	45
2	Ivysaur	Ivysaur	GRASS	POISON	405	60	62	63	80	80	60
3	Venusaur	Venusaur	GRASS	POISON	525	80	82	83	100	100	80
3	Mega Venusaur	Venusaur	GRASS	POISON	625	80	100	123	122	120	80
4	Charmander	Charmander	FIRE	-	309	39	52	43	60	50	65
5	Charmeleon	Charmeleon	FIRE	-	405	58	64	58	80	65	80
6	Charizard	Charizard	FIRE	FLYING	534	78	84	78	109	85	100
6	Mega Charizard X	Charizard	FIRE	DRAGON	634	78	130	111	130	85	100
6	Mega Charizard Y	Charizard	FIRE	FLYING	634	78	104	78	159	115	100
7	Squirtle	Squirtle	WATER	-	314	44	48	65	50	64	43


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_defense" BIGINT,
  "speed" BIGINT
);