Pokemon statistics

pokemon.sql Generation 1-9

/*This is every Pokemon from generation 1 to 9. It took me over 50 hours to compile and make work in SQL. I hope you find it useful.*/

CREATE TABLE pokemon(
  Number     INTEGER,
  Name       TEXT PRIMARY KEY,
  Type_1     TEXT,
  Type_2     TEXT,
  Total      INTEGER,
  HP         INTEGER,
  Attack     INTEGER,
  Defense    INTEGER,
  Sp_Atk     INTEGER,
  Sp_Def     INTEGER,
  Speed      INTEGER,
  Generation INTEGER
);
INSERT INTO pokemon(Number,Name,Type_1,Type_2,Total,HP,Attack,Defense,Sp_Atk,Sp_Def,Speed,Generation) VALUES 
(1,'Bulbasaur','Grass','Poison',318,45,49,49,65,65,45,1),
(2,'Ivysaur','Grass','Poison',405,60,62,63,80,80,60,1),
(3,'Venusaur','Grass','Poison',525,80,82,83,100,100,80,1),
(3.1,'Mega_Venusaur','Grass','Poison',625,80,100,123,122,120,80,6),
(4,'Charmander','Fire',NULL,309,39,52,43,60,50,65,1),
(5,'Charmeleon','Fire',NULL,405,58,64,58,80,65,80,1),
(6,'Charizard','Fire','Flying',534,78,84,78,109,85,100,1),
(6.1,'Mega_Charizard_X','Fire','Dragon',634,78,130,111,130,85,100,6),
(6.2,'Mega_Charizard_Y','Fire','Flying',634,78,104,78,159,115,100,6),
(7,'Squirtle','Water',NULL,314,44,48,65,50,64,43,1),
(8,'Wartortle','Water',NULL,405,59,63,80,65,80,58,1),
(9,'Blastoise','Water',NULL,530,79,83,100,85,105,78,1),
(9.1,'Mega_Blastoise','Water',NULL,630,79,103,120,135,115,78,6),
(10,'Caterpie','Bug',NULL,195,45,30,35,20,20,45,1),
(11,'Metapod','Bug',NULL,205,50,20,55,25,25,30,1),
(12,'Butterfree','Bug','Flying',395,60,45,50,90,80,70,1),
(13,'Weedle','Bug','Poison',195,40,35,30,20,20,50,1),
(14,'Kakuna','Bug','Poison',205,45,25,50,25,25,35,1),
(15,'Beedrill','Bug','Poison',395,65,90,40,45,80,75,1),
(15.1,'Mega_Beedrill','Bug','Poison',495,65,150,40,15,80,145,6),
(16,'Pidgey','Normal','Flying',251,40,45,40,35,35,56,1),
(17,'Pidgeotto','Normal','Flying',349,63,60,55,50,50,71,1),
(18,'Pidgeot','Normal','Flying',479,83,80,75,70,70,101,1),
(18.1,'Mega_Pidgeot','Normal','Flying',579,83,80,80,135,80,121,6),
(19,'Rattata','Normal',NULL,253,30,56,35,25,35,72,1),
(19.1,'Alolan_Rattata','Dark','Normal',253,30,56,35,25,35,72,7),
(20,'Raticate','Normal',NULL,413,55,81,60,50,70,97,1),
(20.1,'Alolan_Raticate','Dark','Normal',413,75,71,70,40,80,77,7),
(21,'Spearow','Normal','Flying',262,40,60,30,31,31,70,1),
(22,'Fearow','Normal','Flying',442,65,90,65,61,61,100,1),
(23,'Ekans','Poison',NULL,288,35,60,44,40,54,55,1),
(24,'Arbok','Poison',NULL,438,60,85,69,65,79,80,1),
(25,'Pikachu','Electric',NULL,320,35,55,40,50,50,90,1),
(25.1,'Partner_Pikachu','Electric',NULL,430,45,80,50,75,60,120,7),
(26,'Raichu','Electric',NULL,485,60,90,55,90,80,110,1),
(26.1,'Alolan_Raichu','Electric','Psychic',485,60,85,50,95,85,110,7),
(27,'Sandshrew','Ground',NULL,300,50,75,85,20,30,40,1),
(27.1,'Alolan_Sandshrew','Ice','Steel',300,50,75,90,10,35,40,7),
(28,'Sandslash','Ground',NULL,450,75,100,110,45,55,65,1),
(28.1,'Alolan_Sandslash','Ice','Steel',450,75,100,120,25,65,65,7),
(29,'Nidoran♀','Poison',NULL,275,55,47,52,40,40,41,1),
(30,'Nidorina','Poison',NULL,365,70,62,67,55,55,56,1),
(31,'Nidoqueen','Poison','Ground',505,90,92,87,75,85,76,1),
(32,'Nidoran♂','Poison',NULL,273,46,57,40,40,40,50,1),
(33,'Nidorino','Poison',NULL,365,61,72,57,55,55,65,1),
(34,'Nidoking','Poison','Ground',505,81,102,77,85,75,85,1),
(35,'Clefairy','Fairy',NULL,323,70,45,48,60,65,35,1),
(36,'Clefable','Fairy',NULL,483,95,70,73,95,90,60,1),
(37,'Vulpix','Fire',NULL,299,38,41,40,50,65,65,1),
(37.1,'Alolan_Vulpix','Ice',NULL,299,38,41,40,50,65,65,7),
(38,'Ninetales','Fire',NULL,505,73,76,75,81,100,100,1),
(38.1,'Alolan_Ninetales','Ice','Fairy',505,73,67,75,81,100,109,7),
(39,'Jigglypuff','Normal','Fairy',270,115,45,20,45,25,20,1),
(40,'Wigglytuff','Normal','Fairy',435,140,70,45,85,50,45,1),
(41,'Zubat','Poison','Flying',245,40,45,35,30,40,55,1),
(42,'Golbat','Poison','Flying',455,75,80,70,65,75,90,1),
(43,'Oddish','Grass','Poison',320,45,50,55,75,65,30,1),
(44,'Gloom','Grass','Poison',395,60,65,70,85,75,40,1),
(45,'Vileplume','Grass','Poison',490,75,80,85,110,90,50,1),
(46,'Paras','Bug','Grass',285,35,70,55,45,55,25,1),
(47,'Parasect','Bug','Grass',405,60,95,80,60,80,30,1),
(48,'Venonat','Bug','Poison',305,60,55,50,40,55,45,1),
(49,'Venomoth','Bug','Poison',450,70,65,60,90,75,90,1),
(50,'Diglett','Ground',NULL,265,10,55,25,35,45,95,1),
(50.1,'Alolan_Diglett','Ground','Steel',265,10,55,30,35,45,90,7),
(51,'Dugtrio','Ground',NULL,405,35,80,50,50,70,120,1),
(51.1,'Alolan_Dugtrio','Ground','Steel',425,35,100,60,50,70,110,7),
(52,'Meowth','Normal',NULL,290,40,45,35,40,40,90,1),
(52.1,'Alolan_Meowth','Dark',NULL,290,40,35,35,50,40,90,7),
(52.2,'Galarian_Meowth','Steel',NULL,290,50,65,55,40,40,40,8),
(53,'Persian','Normal',NULL,440,65,70,60,65,65,115,1),
(53.1,'Alolan_Persian','Dark',NULL,440,65,60,60,75,65,115,7),
(54,'Psyduck','Water',NULL,320,50,52,48,65,50,55,1),
(55,'Golduck','Water',NULL,500,80,82,78,95,80,85,1),
(56,'Mankey','Fighting',NULL,305,40,80,35,35,45,70,1),
(57,'Primeape','Fighting',NULL,455,65,105,60,60,70,95,1),
(58,'Growlithe','Fire',NULL,350,55,70,45,70,50,60,1),
(58.1,'Hisuian_Growlithe','Fire','Rock',350,60,75,45,65,50,55,8),
(59,'Arcanine','Fire',NULL,555,90,110,80,100,80,95,1),
(59.1,'Hisuian_Arcanine','Fire','Rock',555,95,115,80,95,80,90,8),
(60,'Poliwag','Water',NULL,300,40,50,40,40,40,90,1),
(61,'Poliwhirl','Water',NULL,385,65,65,65,50,50,90,1),
(62,'Poliwrath','Water','Fighting',510,90,95,95,70,90,70,1),
(63,'Abra','Psychic',NULL,310,25,20,15,105,55,90,1),
(64,'Kadabra','Psychic',NULL,400,40,35,30,120,70,105,1),
(65,'Alakazam','Psychic',NULL,500,55,50,45,135,95,120,1),
(65.1,'Mega_Alakazam','Psychic',NULL,600,55,50,65,175,105,150,6),
(66,'Machop','Fighting',NULL,305,70,80,50,35,35,35,1),
(67,'Machoke','Fighting',NULL,405,80,100,70,50,60,45,1),
(68,'Machamp','Fighting',NULL,505,90,130,80,65,85,55,1),
(69,'Bellsprout','Grass','Poison',300,50,75,35,70,30,40,1),
(70,'Weepinbell','Grass','Poison',390,65,90,50,85,45,55,1),
(71,'Victreebel','Grass','Poison',490,80,105,65,100,70,70,1),
(72,'Tentacool','Water','Poison',335,40,40,35,50,100,70,1),
(73,'Tentacruel','Water','Poison',515,80,70,65,80,120,100,1),
(74,'Geodude','Rock','Ground',300,40,80,100,30,30,20,1),
(74.1,'Alolan_Geodude','Rock','Electric',300,40,80,100,30,30,20,7),
(75,'Graveler','Rock','Ground',390,55,95,115,45,45,35,1),
(75.1,'Alolan_Graveler','Rock','Electric',390,55,95,115,45,45,35,7),
(76,'Golem','Rock','Ground',495,80,120,130,55,65,45,1),
(76.1,'Alolan_Golem','Rock','Electric',495,80,120,130,55,65,45,7),
(77,'Ponyta','Fire',NULL,410,50,85,55,65,65,90,1),
(77.1,'Galarian_Ponyta','Psychic',NULL,410,50,85,55,65,65,90,8),
(78,'Rapidash','Fire',NULL,500,65,100,70,80,80,105,1),
(78.1,'Galarian_Rapidash','Psychic','Fairy',500,65,100,70,80,80,105,8),
(79,'Slowpoke','Water','Psychic',315,90,65,65,40,40,15,1),
(79.1,'Galarian_Slowpoke','Psychic',NULL,315,90,65,65,40,40,15,8),
(80,'Slowbro','Water','Psychic',490,95,75,110,100,80,30,1),
(80.1,'Galarian_Slowbro','Poison','Psychic',490,95,100,95,100,70,30,8),
(80.2,'Mega_Slowbro','Water','Psychic',590,95,75,180,130,80,30,6),
(81,'Magnemite','Electric','Steel',325,25,35,70,95,55,45,1)
,(82,'Magneton','Electric','Steel',465,50,60,95,120,70,70,1),
(83,"Farfetch'd",'Normal','Flying',352,52,65,55,58,62,60,1),
(83.1,"Galarian_Farfetch'd",'Fighting',NULL,377,52,95,55,58,62,55,8),
(84,'Doduo','Normal','Flying',310,35,85,45,35,35,75,1),
(85,'Dodrio','Normal','Flying',460,60,110,70,60,60,100,1),
(86,'Seel','Water',NULL,325,65,45,55,45,70,45,1),
(87,'Dewgong','Water','Ice',475,90,70,80,70,95,70,1),
(88,'Grimer','Poison',NULL,325,80,80,50,40,50,25,1),
(88.1,'Alolan_Grimer','Poison','Dark',325,80,80,50,40,50,25,7),
(89,'Muk','Poison',NULL,500,105,105,75,65,100,50,1),
(89.1,'Alolan_Muk','Poison','Dark',500,105,105,75,65,100,50,7),
(90,'Shellder','Water',NULL,305,30,65,100,45,25,40,1),
(91,'Cloyster','Water','Ice',525,50,95,180,85,45,70,1),
(92,'Gastly','Ghost','Poison',310,30,35,30,100,35,80,1),
(93,'Haunter','Ghost','Poison',405,45,50,45,115,55,95,1),
(94,'Gengar','Ghost','Poison',500,60,65,60,130,75,110,1),
(94.1,'Mega_Gengar','Ghost','Poison',600,60,65,80,170,95,130,6),
(95,'Onix','Rock','Ground',385,35,45,160,30,45,70,1),
(96,'Drowzee','Psychic',NULL,328,60,48,45,43,90,42,1),
(97,'Hypno','Psychic',NULL,483,85,73,70,73,115,67,1),
(98,'Krabby','Water',NULL,325,30,105,90,25,25,50,1),
(99,'Kingler','Water',NULL,475,55,130,115,50,50,75,1),
(100,'Voltorb','Electric',NULL,330,40,30,50,55,55,100,1),
(100.1,'Hisuian_Voltorb','Electric','Grass',330,40,30,50,55,55,100,8),
(101,'Electrode','Electric',NULL,480,60,50,70,80,80,140,1),
(101.1,'Hisuian_Electrode','Electric','Grass',490,60,50,70,80,80,150,8),
(102,'Exeggcute','Grass','Psychic',325,60,40,80,60,45,40,1),
(103,'Exeggutor','Grass','Psychic',520,95,95,85,125,65,55,1),
(103.1,'Alolan_Exeggutor','Grass','Dragon',530,95,105,85,125,75,45,7),
(104,'Cubone','Ground',NULL,320,50,50,95,40,50,35,1),
(105,'Marowak','Ground',NULL,425,60,80,110,50,80,45,1),
(105.1,'Alolan_Marowak','Fire','Ghost',425,60,80,110,50,80,45,7),
(106,'Hitmonlee','Fighting',NULL,455,50,120,53,35,110,87,1),
(107,'Hitmonchan','Fighting',NULL,455,50,105,79,35,110,76,1),
(108,'Lickitung','Normal',NULL,385,90,55,75,60,75,30,1),
(109,'Koffing','Poison',NULL,340,40,65,95,60,45,35,1),
(110,'Weezing','Poison',NULL,490,65,90,120,85,70,60,1),
(110.1,'Galarian_Weezing','Poison','Fairy',490,65,90,120,85,70,60,8),
(111,'Rhyhorn','Ground','Rock',345,80,85,95,30,30,25,1),
(112,'Rhydon','Ground','Rock',485,105,130,120,45,45,40,1),
(113,'Chansey','Normal',NULL,450,250,5,5,35,105,50,1),
(114,'Tangela','Grass',NULL,435,65,55,115,100,40,60,1),
(115,'Kangaskhan','Normal',NULL,490,105,95,80,40,80,90,1),
(115.1,'Mega_Kangaskhan','Normal',NULL,590,105,125,100,60,100,100,6),
(116,'Horsea','Water',NULL,295,30,40,70,70,25,60,1),
(117,'Seadra','Water',NULL,440,55,65,95,95,45,85,1),
(118,'Goldeen','Water',NULL,320,45,67,60,35,50,63,1),
(119,'Seaking','Water',NULL,450,80,92,65,65,80,68,1),
(120,'Staryu','Water',NULL,340,30,45,55,70,55,85,1),
(121,'Starmie','Water','Psychic',520,60,75,85,100,85,115,1),
(122,'Mr_Mime','Psychic','Fairy',460,40,45,65,100,120,90,1),
(122.1,'Galarian_Mr_Mime','Ice','Psychic',460,50,65,65,90,90,100,8),
(123,'Scyther','Bug','Flying',500,70,110,80,55,80,105,1),
(124,'Jynx','Ice','Psychic',455,65,50,35,115,95,95,1),
(125,'Electabuzz','Electric',NULL,490,65,83,57,95,85,105,1),
(126,'Magmar','Fire',NULL,495,65,95,57,100,85,93,1),
(127,'Pinsir','Bug',NULL,500,65,125,100,55,70,85,1),
(127.1,'Mega_Pinsir','Bug','Flying',600,65,155,120,65,90,105,6),
(128,'Tauros','Normal',NULL,490,75,100,95,40,70,110,1),
(128.1,'Tauros_Combat_Breed','Fighting',NULL,490,75,110,105,30,70,100,9),
(128.2,'Tauros_Blaze_Breed','Fighting','Fire',490,75,110,105,30,70,100,9),
(128.3,'Tauros_Aqua_Breed','Fighting','Water',490,75,110,105,30,70,100,9),
(129,'Magikarp','Water',NULL,200,20,10,55,15,20,80,1),
(130,'Gyarados','Water','Flying',540,95,125,79,60,100,81,1),
(130.1,'Mega_Gyarados','Water','Dark',640,95,155,109,70,130,81,6),
(131,'Lapras','Water','Ice',535,130,85,80,85,95,60,1),
(132,'Ditto','Normal',NULL,288,48,48,48,48,48,48,1),
(133,'Eevee','Normal',NULL,325,55,55,50,45,65,55,1),
(133.1,'Partner_Eevee','Normal',NULL,435,65,75,70,65,85,75,7),
(134,'Vaporeon','Water',NULL,525,130,65,60,110,95,65,1),
(135,'Jolteon','Electric',NULL,525,65,65,60,110,95,130,1),
(136,'Flareon','Fire',NULL,525,65,130,60,95,110,65,1),
(137,'Porygon','Normal',NULL,395,65,60,70,85,75,40,1),
(138,'Omanyte','Rock','Water',355,35,40,100,90,55,35,1),
(139,'Omastar','Rock','Water',495,70,60,125,115,70,55,1),
(140,'Kabuto','Rock','Water',355,30,80,90,55,45,55,1),
(141,'Kabutops','Rock','Water',495,60,115,105,65,70,80,1),
(142,'Aerodactyl','Rock','Flying',515,80,105,65,60,75,130,1),
(142.1,'Mega_Aerodactyl','Rock','Flying',615,80,135,85,70,95,150,6),
(143,'Snorlax','Normal',NULL,540,160,110,65,65,110,30,1),
(144,'Articuno','Ice','Flying',580,90,85,100,95,125,85,1),
(144.1,'Galarian_Articuno','Psychic','Flying',580,90,85,85,125,100,95,8),
(145,'Zapdos','Electric','Flying',580,90,90,85,125,90,100,1),
(145.1,'Galarian_Zapdos','Fighting','Flying',580,90,125,90,85,90,100,8),
(146,'Moltres','Fire','Flying',580,90,100,90,125,85,90,1),
(146.1,'Galarian_Moltres','Dark','Flying',580,90,85,90,100,125,90,8),
(147,'Dratini','Dragon',NULL,300,41,64,45,50,50,50,1),
(148,'Dragonair','Dragon',NULL,420,61,84,65,70,70,70,1),
(149,'Dragonite','Dragon','Flying',600,91,134,95,100,100,80,1),
(150,'Mewtwo','Psychic',NULL,680,106,110,90,154,90,130,1),
(150.1,'Mega_Mewtwo_X','Psychic','Fighting',780,106,190,100,154,100,130,6),
(150.2,'Mega_Mewtwo_Y','Psychic',NULL,780,106,150,70,194,120,140,6),
(151,'Mew','Psychic',NULL,600,100,100,100,100,100,100,1);
INSERT INTO pokemon(Number,Name,Type_1,Type_2,Total,HP,Attack,Defense,Sp_Atk,Sp_Def,Speed,Generation) VALUES 
(152,'Chikorita','Grass',NULL,318,45,49,65,49,65,45,2),
(153,'Bayleef','Grass',NULL,405,60,62,80,63,80,60,2),
(154,'Meganium','Grass',NULL,525,80,82,100,83,100,80,2),
(155,'Cyndaquil','Fire',NULL,309,39,52,43,60,50,65,2),
(156,'Quilava','Fire',NULL,405,58,64,58,80,65,80,2),
(157,'Typhlosion','Fire',NULL,534,78,84,78,109,85,100,2),
(157.1,'Hisuian_Typhlosion','Fire','Ghost',534,73,84,78,119,85,95,8),
(158,'Totodile','Water',NULL,314,50,65,64,44,48,43,2),
(159,'Croconaw','Water',NULL,405,65,80,80,59,63,58,2),
(160,'Feraligatr','Water',NULL,530,85,105,100,79,83,78,2),
(161,'Sentret','Normal',NULL,215,35,46,34,35,45,20,2),
(162,'Furret','Normal',NULL,415,85,76,64,45,55,90,2),
(163,'Hoothoot','Normal','Flying',262,60,30,30,36,56,50,2),
(164,'Noctowl','Normal','Flying',452,100,50,50,86,96,70,2),
(165,'Ledyba','Bug','Flying',265,40,20,30,40,80,55,2),
(166,'Ledian','Bug','Flying',390,55,35,50,55,110,85,2),
(167,'Spinarak','Bug','Poison',250,40,60,40,40,40,30,2),
(168,'Ariados','Bug','Poison',400,70,90,70,60,70,40,2),
(169,'Crobat','Poison','Flying',535,85,90,80,70,80,130,2),
(170,'Chinchou','Water','Electric',330,75,38,38,56,56,67,2),
(171,'Lanturn','Water','Electric',460,125,58,58,76,76,67,2),
(172,'Pichu','Electric',NULL,205,20,40,15,35,35,60,2),
(173,'Cleffa','Fairy',NULL,218,50,25,28,45,55,15,2),
(174,'Igglybuff','Normal','Fairy',210,90,30,15,40,20,15,2),
(175,'Togepi','Fairy',NULL,245,35,20,65,40,65,20,2),
(176,'Togetic','Fairy','Flying',405,55,40,85,80,105,40,2),
(177,'Natu','Psychic','Flying',320,40,50,45,70,45,70,2),
(178,'Xatu','Psychic','Flying',470,65,75,70,95,70,95,2),
(179,'Mareep','Electric',NULL,280,55,40,40,65,45,35,2),
(180,'Flaaffy','Electric',NULL,365,70,55,55,80,60,45,2),
(181,'Ampharos','Electric',NULL,510,90,75,85,115,90,55,2),
(181.1,'Mega_Ampharos','Electric','Dragon',610,90,95,105,165,110,45,6),
(182,'Bellossom','Grass',NULL,490,75,80,95,90,100,50,2),
(183,'Marill','Water','Fairy',250,70,20,50,20,50,40,2),
(184,'Azumarill','Water','Fairy',420,100,50,80,60,80,50,2),
(185,'Sudowoodo','Rock',NULL,410,70,100,115,30,65,30,2),
(186,'Politoed','Water',NULL,500,90,75,75,90,100,70,2),
(187,'Hoppip','Grass','Flying',250,35,35,40,35,55,50,2),
(188,'Skiploom','Grass','Flying',340,55,45,50,45,65,80,2),
(189,'Jumpluff','Grass','Flying',460,75,55,70,55,95,110,2),
(190,'Aipom','Normal',NULL,360,55,70,55,40,55,85,2),
(191,'Sunkern','Grass',NULL,180,30,30,30,30,30,30,2),
(192,'Sunflora','Grass',NULL,425,75,75,55,105,85,30,2),
(193,'Yanma','Bug','Flying',390,65,65,45,75,45,95,2),
(194,'Wooper','Water','Ground',210,55,45,45,25,25,15,2),
(194.1,'Paldean_Wooper','Poison','Ground',210,55,45,45,25,25,15,9),
(195,'Quagsire','Water','Ground',430,95,85,85,65,65,35,2),
(196,'Espeon','Psychic',NULL,525,65,65,60,130,95,110,2),
(197,'Umbreon','Dark',NULL,525,95,65,110,60,130,65,2),
(198,'Murkrow','Dark','Flying',405,60,85,42,85,42,91,2),
(199,'Slowking','Water','Psychic',490,95,75,80,100,110,30,2),
(199.1,'Galarian_Slowking','Poison','Psychic',490,95,65,80,110,110,30,8),
(200,'Misdreavus','Ghost',NULL,435,60,60,60,85,85,85,2),
(201,'Unown_A','Psychic',NULL,336,48,72,48,72,48,48,2),
(201.1,'Unown_B','Psychic',NULL,336,48,72,48,72,48,48,2),
(201.2,'Unown_C','Psychic',NULL,336,48,72,48,72,48,48,2),
(201.3,'Unown_D','Psychic',NULL,336,48,72,48,72,48,48,2),
(201.4,'Unown_E','Psychic',NULL,336,48,72,48,72,48,48,2),
(201.5,'Unown_F','Psychic',NULL,336,48,72,48,72,48,48,2),
(201.6,'Unown_G','Psychic',NULL,336,48,72,48,72,48,48,2),
(201.7,'Unown_H','Psychic',NULL,336,48,72,48,72,48,48,2),
(201.8,'Unown_I','Psychic',NULL,336,48,72,48,72,48,48,2),
(201.9,'Unown_J','Psychic',NULL,336,48,72,48,72,48,48,2),
(201.11,'Unown_K','Psychic',NULL,336,48,72,48,72,48,48,2),
(201.12,'Unown_L','Psychic',NULL,336,48,72,48,72,48,48,2),
(201.13,'Unown_M','Psychic',NULL,336,48,72,48,72,48,48,2),
(201.14,'Unown_N','Psychic',NULL,336,48,72,48,72,48,48,2),
(201.15,'Unown_O','Psychic',NULL,336,48,72,48,72,48,48,2),
(201.16,'Unown_P','Psychic',NULL,336,48,72,48,72,48,48,2),
(201.17,'Unown_Q','Psychic',NULL,336,48,72,48,72,48,48,2),
(201.18,'Unown_R','Psychic',NULL,336,48,72,48,72,48,48,2),
(201.19,'Unown_S','Psychic',NULL,336,48,72,48,72,48,48,2),
(201.21,'Unown_T','Psychic',NULL,336,48,72,48,72,48,48,2),
(201.22,'Unown_U','Psychic',NULL,336,48,72,48,72,48,48,2),
(201.23,'Unown_V','Psychic',NULL,336,48,72,48,72,48,48,2),
(201.24,'Unown_W','Psychic',NULL,336,48,72,48,72,48,48,2),
(201.25,'Unown_X','Psychic',NULL,336,48,72,48,72,48,48,2),
(201.26,'Unown_Y','Psychic',NULL,336,48,72,48,72,48,48,2),
(201.27,'Unown_Z','Psychic',NULL,336,48,72,48,72,48,48,2),
(201.28,'Unown_!','Psychic',NULL,336,48,72,48,72,48,48,2),
(201.29,'Unown_?','Psychic',NULL,336,48,72,48,72,48,48,2),
(202,'Wobbuffet','Psychic',NULL,405,190,33,58,33,58,33,2),
(203,'Girafarig','Normal','Psychic',455,70,80,65,90,65,85,2),
(204,'Pineco','Bug',NULL,290,50,65,90,35,35,15,2),
(205,'Forretress','Bug','Steel',465,75,90,140,60,60,40,2),
(206,'Dunsparce','Normal',NULL,415,100,70,70,65,65,45,2),
(207,'Gligar','Ground','Flying',430,65,75,105,35,65,85,2),
(208,'Steelix','Steel','Ground',510,75,85,200,55,65,30,2),
(208.1,'Mega_Steelix','Steel','Ground',610,75,125,230,55,95,30,6),
(209,'Snubbull','Fairy',NULL,300,60,80,50,40,40,30,2),
(210,'Granbull','Fairy',NULL,450,90,120,75,60,60,45,2),
(211,'Qwilfish','Water','Poison',440,65,95,85,55,55,85,2),
(211.1,'Hisuian_Qwilfish','Dark','Poison',440,65,95,85,55,55,85,8),
(212,'Scizor','Bug','Steel',500,70,130,100,55,80,65,2),
(212.1,'Mega_Scizor','Bug','Steel',600,70,150,140,65,100,75,6),
(213,'Shuckle','Bug','Rock',505,20,10,230,10,230,5,2),
(214,'Heracross','Bug','Fighting',500,80,125,75,40,95,85,2),
(214.1,'Mega_Heracross','Bug','Fighting',600,80,185,115,40,105,75,6),
(215,'Sneasel','Dark','Ice',430,55,95,55,35,75,115,2),
(215.1,'Hisuian_Sneasel','Fighting','Poison',430,55,95,55,35,75,115,8),
(216,'Teddiursa','Normal',NULL,330,60,80,50,50,50,40,2),
(217,'Ursaring','Normal',NULL,500,90,130,75,75,75,55,2),
(218,'Slugma','Fire',NULL,250,40,40,40,70,40,20,2),
(219,'Magcargo','Fire','Rock',430,60,50,120,90,80,30,2),
(220,'Swinub','Ice','Ground',250,50,50,40,30,30,50,2),
(221,'Piloswine','Ice','Ground',450,100,100,80,60,60,50,2),
(222,'Corsola','Water','Rock',410,65,55,95,65,95,35,2),
(222.1,'Galarian_Corsola','Ghost',NULL,410,60,55,100,65,100,30,8),
(223,'Remoraid','Water',NULL,300,35,65,35,65,35,65,2),
(224,'Octillery','Water',NULL,480,75,105,75,105,75,45,2),
(225,'Delibird','Ice','Flying',330,45,55,45,65,45,75,2),
(226,'Mantine','Water','Flying',485,85,40,70,80,140,70,2),
(227,'Skarmory','Steel','Flying',465,65,80,140,40,70,70,2),
(228,'Houndour','Dark','Fire',330,45,60,30,80,50,65,2),
(229,'Houndoom','Dark','Fire',500,75,90,50,110,80,95,2),
(229.1,'Mega_Houndoom','Dark','Fire',600,75,90,90,140,90,115,6),
(230,'Kingdra','Water','Dragon',540,75,95,95,95,95,85,2),
(231,'Phanpy','Ground',NULL,330,90,60,60,40,40,40,2),
(232,'Donphan','Ground',NULL,500,90,120,120,60,60,50,2),
(233,'Porygon2','Normal',NULL,515,85,80,90,105,95,60,2),
(234,'Stantler','Normal',NULL,465,73,95,62,85,65,85,2),
(235,'Smeargle','Normal',NULL,250,55,20,35,20,45,75,2),
(236,'Tyrogue','Fighting',NULL,210,35,35,35,35,35,35,2),
(237,'Hitmontop','Fighting',NULL,455,50,95,95,35,110,70,2),
(238,'Smoochum','Ice','Psychic',305,45,30,15,85,65,65,2),
(239,'Elekid','Electric',NULL,360,45,63,37,65,55,95,2),
(240,'Magby','Fire',NULL,365,45,75,37,70,55,83,2),
(241,'Miltank','Normal',NULL,490,95,80,105,40,70,100,2),
(242,'Blissey','Normal',NULL,540,255,10,10,75,135,55,2),
(243,'Raikou','Electric',NULL,580,90,85,75,115,100,115,2),
(244,'Entei','Fire',NULL,580,115,115,85,90,75,100,2),
(245,'Suicune','Water',NULL,580,100,75,115,90,115,85,2),
(246,'Larvitar','Rock','Ground',300,50,64,50,45,50,41,2),
(247,'Pupitar','Rock','Ground',410,70,84,70,65,70,51,2),
(248,'Tyranitar','Rock','Dark',600,100,134,110,95,100,61,2),
(248.1,'Mega_Tyranitar','Rock','Dark',700,100,164,150,95,120,71,6),
(249,'Lugia','Psychic','Flying',680,106,90,130,90,154,110,2),
(250,'Ho_oh','Fire','Flying',680,106,130,90,110,154,90,2),
(251,'Celebi','Psychic','Grass',600,100,100,100,100,100,100,2),
(252,'Treecko','Grass',NULL,310,40,45,35,65,55,70,3),
(253,'Grovyle','Grass',NULL,405,50,65,45,85,65,95,3),
(254,'Sceptile','Grass',NULL,530,70,85,65,105,85,120,3),
(254.1,'Mega_Sceptile','Grass','Dragon',630,70,110,75,145,85,145,6),
(255,'Torchic','Fire',NULL,310,45,60,40,70,50,45,3),
(256,'Combusken','Fire','Fighting',405,60,85,60,85,60,55,3),
(257,'Blaziken','Fire','Fighting',530,80,120,70,110,70,80,3),
(257.1,'Mega_Blaziken','Fire','Fighting',630,80,160,80,130,80,100,6),
(258,'Mudkip','Water',NULL,310,50,70,50,50,50,40,3),
(259,'Marshtomp','Water','Ground',405,70,85,70,60,70,50,3),
(260,'Swampert','Water','Ground',535,100,110,90,85,90,60,3),
(260.1,'Mega_Swampert','Water','Ground',635,100,150,110,95,110,70,6),
(261,'Poochyena','Dark',NULL,220,35,55,35,30,30,35,3),
(262,'Mightyena','Dark',NULL,420,70,90,70,60,60,70,3),
(263,'Zigzagoon','Normal',NULL,240,38,30,41,30,41,60,3),
(263.1,'Galarian_Zigzagoon','Dark','Normal',240,38,30,41,30,41,60,8),
(264,'Linoone','Normal',NULL,420,78,70,61,50,61,100,3),
(264.1,'Galarian_Linoone','Dark','Normal',420,78,70,61,50,61,100,8),
(265,'Wurmple','Bug',NULL,195,45,45,35,20,30,20,3),
(266,'Silcoon','Bug',NULL,205,50,35,55,25,25,15,3),
(267,'Beautifly','Bug','Flying',395,60,70,50,100,50,65,3),
(268,'Cascoon','Bug',NULL,205,50,35,55,25,25,15,3),
(269,'Dustox','Bug','Poison',385,60,50,70,50,90,65,3),
(270,'Lotad','Water','Grass',220,40,30,30,40,50,30,3),
(271,'Lombre','Water','Grass',340,60,50,50,60,70,50,3),
(272,'Ludicolo','Water','Grass',480,80,70,70,90,100,70,3),
(273,'Seedot','Grass',NULL,220,40,40,50,30,30,30,3),
(274,'Nuzleaf','Grass','Dark',340,70,70,40,60,40,60,3),
(275,'Shiftry','Grass','Dark',480,90,100,60,90,60,80,3),
(276,'Taillow','Normal','Flying',270,40,55,30,30,30,85,3),
(277,'Swellow','Normal','Flying',455,60,85,60,75,50,125,3),
(278,'Wingull','Water','Flying',270,40,30,30,55,30,85,3),
(279,'Pelipper','Water','Flying',440,60,50,100,95,70,65,3),
(280,'Ralts','Psychic','Fairy',198,28,25,25,45,35,40,3),
(281,'Kirlia','Psychic','Fairy',278,38,35,35,65,55,50,3),
(282,'Gardevoir','Psychic','Fairy',518,68,65,65,125,115,80,3),
(282.1,'Mega_Gardevoir','Psychic','Fairy',618,68,85,65,165,135,100,6),
(283,'Surskit','Bug','Water',269,40,30,32,50,52,65,3),
(284,'Masquerain','Bug','Flying',454,70,60,62,100,82,80,3),
(285,'Shroomish','Grass',NULL,295,60,40,60,40,60,35,3),
(286,'Breloom','Grass','Fighting',460,60,130,80,60,60,70,3),
(287,'Slakoth','Normal',NULL,280,60,60,60,35,35,30,3),
(288,'Vigoroth','Normal',NULL,440,80,80,80,55,55,90,3),
(289,'Slaking','Normal',NULL,670,150,160,100,95,65,100,3),
(290,'Nincada','Bug','Ground',266,31,45,90,30,30,40,3),
(291,'Ninjask','Bug','Flying',456,61,90,45,50,50,160,3),
(292,'Shedinja','Bug','Ghost',236,1,90,45,30,30,40,3),
(293,'Whismur','Normal',NULL,240,64,51,23,51,23,28,3),
(294,'Loudred','Normal',NULL,360,84,71,43,71,43,48,3),
(295,'Exploud','Normal',NULL,490,104,91,63,91,73,68,3),
(296,'Makuhita','Fighting',NULL,237,72,60,30,20,30,25,3),
(297,'Hariyama','Fighting',NULL,474,144,120,60,40,60,50,3),
(298,'Azurill','Normal','Fairy',190,50,20,40,20,40,20,3),
(299,'Nosepass','Rock',NULL,375,30,45,135,45,90,30,3),
(300,'Skitty','Normal',NULL,260,50,45,45,35,35,50,3),
(301,'Delcatty','Normal',NULL,400,70,65,65,55,55,90,3),
(302,'Sableye','Dark','Ghost',380,50,75,75,65,65,50,3),
(302.1,'Mega_Sableye','Dark','Ghost',480,50,85,125,85,115,20,6),
(303,'Mawile','Steel','Fairy',380,50,85,85,55,55,50,3),
(303.1,'Mega_Mawile','Steel','Fairy',480,50,105,125,55,95,50,6),
(304,'Aron','Steel','Rock',330,50,70,100,40,40,30,3),
(305,'Lairon','Steel','Rock',430,60,90,140,50,50,40,3),
(306,'Aggron','Steel','Rock',530,70,110,180,60,60,50,3),
(306.1,'Mega_Aggron','Steel',NULL,630,70,140,230,60,80,50,6),
(307,'Meditite','Fighting','Psychic',280,30,40,55,40,55,60,3),
(308,'Medicham','Fighting','Psychic',410,60,60,75,60,75,80,3),
(308.1,'Mega_Medicham','Fighting','Psychic',510,60,100,85,80,85,100,6),
(309,'Electrike','Electric',NULL,295,40,45,40,65,40,65,3),
(310,'Manectric','Electric',NULL,475,70,75,60,105,60,105,3),
(310.1,'Mega_Manectric','Electric',NULL,575,70,75,80,135,80,135,6),
(311,'Plusle','Electric',NULL,405,60,50,40,85,75,95,3),
(312,'Minun','Electric',NULL,405,60,40,50,75,85,95,3),
(313,'Volbeat','Bug',NULL,430,65,73,75,47,85,85,3),
(314,'Illumise','Bug',NULL,430,65,47,75,73,85,85,3),
(315,'Roselia','Grass','Poison',400,50,60,45,100,80,65,3),
(316,'Gulpin','Poison',NULL,302,70,43,53,43,53,40,3),
(317,'Swalot','Poison',NULL,467,100,73,83,73,83,55,3),
(318,'Carvanha','Water','Dark',305,45,90,20,65,20,65,3),
(319,'Sharpedo','Water','Dark',460,70,120,40,95,40,95,3),
(319.1,'Mega_Sharpedo','Water','Dark',560,70,140,70,110,65,105,6),
(320,'Wailmer','Water',NULL,400,130,70,35,70,35,60,3),
(321,'Wailord','Water',NULL,500,170,90,45,90,45,60,3),
(322,'Numel','Fire','Ground',305,60,60,40,65,45,35,3),
(323,'Camerupt','Fire','Ground',460,70,100,70,105,75,40,3),
(323.1,'Mega_Camerupt','Fire','Ground',560,70,120,100,145,105,20,6),
(324,'Torkoal','Fire',NULL,470,70,85,140,85,70,20,3),
(325,'Spoink','Psychic',NULL,330,60,25,35,70,80,60,3),
(326,'Grumpig','Psychic',NULL,470,80,45,65,90,110,80,3),
(327,'Spinda','Normal',NULL,360,60,60,60,60,60,60,3),
(328,'Trapinch','Ground',NULL,290,45,100,45,45,45,10,3),
(329,'Vibrava','Ground','Dragon',340,50,70,50,50,50,70,3),
(330,'Flygon','Ground','Dragon',520,80,100,80,80,80,100,3),
(331,'Cacnea','Grass',NULL,335,50,85,40,85,40,35,3),
(332,'Cacturne','Grass','Dark',475,70,115,60,115,60,55,3),
(333,'Swablu','Normal','Flying',310,45,40,60,40,75,50,3),
(334,'Altaria','Dragon','Flying',490,75,70,90,70,105,80,3),
(334.1,'Mega_Altaria','Dragon','Fairy',590,75,110,110,110,105,80,6),
(335,'Zangoose','Normal',NULL,458,73,115,60,60,60,90,3),
(336,'Seviper','Poison',NULL,458,73,100,60,100,60,65,3),
(337,'Lunatone','Rock','Psychic',460,90,55,65,95,85,70,3),
(338,'Solrock','Rock','Psychic',460,90,95,85,55,65,70,3),
(339,'Barboach','Water','Ground',288,50,48,43,46,41,60,3),
(340,'Whiscash','Water','Ground',468,110,78,73,76,71,60,3),
(341,'Corphish','Water',NULL,308,43,80,65,50,35,35,3),
(342,'Crawdaunt','Water','Dark',468,63,120,85,90,55,55,3),
(343,'Baltoy','Ground','Psychic',300,40,40,55,40,70,55,3),
(344,'Claydol','Ground','Psychic',500,60,70,105,70,120,75,3),
(345,'Lileep','Rock','Grass',355,66,41,77,61,87,23,3),
(346,'Cradily','Rock','Grass',495,86,81,97,81,107,43,3),
(347,'Anorith','Rock','Bug',355,45,95,50,40,50,75,3),
(348,'Armaldo','Rock','Bug',495,75,125,100,70,80,45,3),
(349,'Feebas','Water',NULL,200,20,15,20,10,55,80,3),
(350,'Milotic','Water',NULL,540,95,60,79,100,125,81,3),
(351,'Castform','Normal',NULL,420,70,70,70,70,70,70,3),
(351.1,'Castform_Sunny_Form','Fire',NULL,420,70,70,70,70,70,70,3),
(351.2,'Castform_Rainy_Form','Water',NULL,420,70,70,70,70,70,70,3),
(351.3,'Castform_Snowy_Form','Ice',NULL,420,70,70,70,70,70,70,3),
(352,'Kecleon','Normal',NULL,440,60,90,70,60,120,40,3),
(353,'Shuppet','Ghost',NULL,295,44,75,35,63,33,45,3),
(354,'Banette','Ghost',NULL,455,64,115,65,83,63,65,3),
(354.1,'Mega_Banette','Ghost',NULL,555,64,165,75,93,83,75,6),
(355,'Duskull','Ghost',NULL,295,20,40,90,30,90,25,3),
(356,'Dusclops','Ghost',NULL,455,40,70,130,60,130,25,3),
(357,'Tropius','Grass','Flying',460,99,68,83,72,87,51,3),
(358,'Chimecho','Psychic',NULL,455,75,50,80,95,90,65,3),
(359,'Absol','Dark',NULL,465,65,130,60,75,60,75,3),
(359.1,'Mega_Absol','Dark',NULL,565,65,150,60,115,60,115,6),
(360,'Wynaut','Psychic',NULL,260,95,23,48,23,48,23,3),
(361,'Snorunt','Ice',NULL,300,50,50,50,50,50,50,3),
(362,'Glalie','Ice',NULL,480,80,80,80,80,80,80,3),
(362.1,'Mega_Glalie','Ice',NULL,580,80,120,80,120,80,100,6),
(363,'Spheal','Ice','Water',290,70,40,50,55,50,25,3),
(364,'Sealeo','Ice','Water',410,90,60,70,75,70,45,3),
(365,'Walrein','Ice','Water',530,110,80,90,95,90,65,3),
(366,'Clamperl','Water',NULL,345,35,64,85,74,55,32,3),
(367,'Huntail','Water',NULL,485,55,104,105,94,75,52,3),
(368,'Gorebyss','Water',NULL,485,55,84,105,114,75,52,3),
(369,'Relicanth','Water','Rock',485,100,90,130,45,65,55,3),
(370,'Luvdisc','Water',NULL,330,43,30,55,40,65,97,3),
(371,'Bagon','Dragon',NULL,300,45,75,60,40,30,50,3),
(372,'Shelgon','Dragon',NULL,420,65,95,100,60,50,50,3),
(373,'Salamence','Dragon','Flying',600,95,135,80,110,80,100,3),
(373.1,'Mega_Salamence','Dragon','Flying',700,95,145,130,120,90,120,6),
(374,'Beldum','Steel','Psychic',300,40,55,80,35,60,30,3),
(375,'Metang','Steel','Psychic',420,60,75,100,55,80,50,3),
(376,'Metagross','Steel','Psychic',600,80,135,130,95,90,70,3),
(376.1,'Mega_Metagross','Steel','Psychic',700,80,145,150,105,110,110,6),
(377,'Regirock','Rock',NULL,580,80,100,200,50,100,50,3),
(378,'Regice','Ice',NULL,580,80,50,100,100,200,50,3),
(379,'Registeel','Steel',NULL,580,80,75,150,75,150,50,3),
(380,'Latias','Dragon','Psychic',600,80,80,90,110,130,110,3),
(380.1,'Mega_Latias','Dragon','Psychic',700,80,100,120,140,150,110,6),
(381,'Latios','Dragon','Psychic',600,80,90,80,130,110,110,3),
(381.1,'Mega_Latios','Dragon','Psychic',700,80,130,100,160,120,110,6),
(382,'Kyogre','Water',NULL,670,100,100,90,150,140,90,3),
(382.1,'Primal_Kyogre','Water',NULL,770,100,150,90,180,160,90,6),
(383,'Groudon','Ground',NULL,670,100,150,140,100,90,90,3),
(383.1,'Primal_Groudon','Ground','Fire',770,100,180,160,150,90,90,6),
(384,'Rayquaza','Dragon','Flying',680,105,150,90,150,90,95,3),
(384.1,'Mega_Rayquaza','Dragon','Flying',780,105,180,100,180,100,115,6),
(385,'Jirachi','Steel','Psychic',600,100,100,100,100,100,100,3),
(386,'Deoxys_Normal_Forme','Psychic',NULL,600,50,150,50,150,50,150,3),
(386.1,'Deoxys_Attack_Forme','Psychic',NULL,600,50,180,20,180,20,150,3),
(386.2,'Deoxys_Defense_Forme','Psychic',NULL,600,50,70,160,70,160,90,3),
(386.3,'Deoxys_Speed_Forme','Psychic',NULL,600,50,95,90,95,90,180,3);
INSERT INTO pokemon(Number,Name,Type_1,Type_2,Total,HP,Attack,Defense,Sp_Atk,Sp_Def,Speed,Generation) VALUES

(387,'Turtwig','Grass',NULL,318,55,68,64,45,55,31,4),
(388,'Grotle','Grass',NULL,405,75,89,85,55,65,36,4),
(389,'Torterra','Grass','Ground',525,95,109,105,75,85,56,4),
(390,'Chimchar','Fire',NULL,309,44,58,44,58,44,61,4),
(391,'Monferno','Fire','Fighting',405,64,78,52,78,52,81,4),
(392,'Infernape','Fire','Fighting',534,76,104,71,104,71,108,4),
(393,'Piplup','Water',NULL,314,53,51,53,61,56,40,4),
(394,'Prinplup','Water',NULL,405,64,66,68,81,76,50,4),
(395,'Empoleon','Water','Steel',530,84,86,88,111,101,60,4),
(396,'Starly','Normal','Flying',245,40,55,30,30,30,60,4),
(397,'Staravia','Normal','Flying',340,55,75,50,40,40,80,4),
(398,'Staraptor','Normal','Flying',485,85,120,70,50,60,100,4),
(399,'Bidoof','Normal',NULL,250,59,45,40,35,40,31,4),
(400,'Bibarel','Normal','Water',410,79,85,60,55,60,71,4),
(401,'Kricketot','Bug',NULL,194,37,25,41,25,41,25,4),
(402,'Kricketune','Bug',NULL,384,77,85,51,55,51,65,4),
(403,'Shinx','Electric',NULL,263,45,65,34,40,34,45,4),
(404,'Luxio','Electric',NULL,363,60,85,49,60,49,60,4),
(405,'Luxray','Electric',NULL,523,80,120,79,95,79,70,4),
(406,'Budew','Grass','Poison',280,40,30,35,50,70,55,4),
(407,'Roserade','Grass','Poison',515,60,70,65,125,105,90,4),
(408,'Cranidos','Rock',NULL,350,67,125,40,30,30,58,4),
(409,'Rampardos','Rock',NULL,495,97,165,60,65,50,58,4),
(410,'Shieldon','Rock','Steel',350,30,42,118,42,88,30,4),
(411,'Bastiodon','Rock','Steel',495,60,52,168,47,138,30,4),
(412,'Burmy_Plant_Cloak','Bug',NULL,224,40,29,45,29,45,36,4),
(412.1,'Burmy_Sandy_Cloak','Bug',NULL,224,40,29,45,29,45,36,4),
(412.2,'Burmy_Trash_Cloak','Bug',NULL,224,40,29,45,29,45,36,4),
(413,'Wormadam_Plant_Cloak','Bug','Grass',424,60,59,85,79,105,36,4),
(413.1,'Wormadam_Sandy_Cloak','Bug','Ground',424,60,79,105,59,85,36,4),
(413.2,'Wormadam_Trash_Cloak','Bug','Steel',424,60,69,95,69,95,36,4),
(414,'Mothim','Bug','Flying',424,70,94,50,94,50,66,4),
(415,'Combee','Bug','Flying',244,30,30,42,30,42,70,4),
(416,'Vespiquen','Bug','Flying',474,70,80,102,80,102,40,4),
(417,'Pachirisu','Electric',NULL,405,60,45,70,45,90,95,4),
(418,'Buizel','Water',NULL,330,55,65,35,60,30,85,4),
(419,'Floatzel','Water',NULL,495,85,105,55,85,50,115,4),
(420,'Cherubi','Grass',NULL,275,45,35,45,62,53,35,4),
(421,'Cherrim_Overcast_Form','Grass',NULL,450,70,60,70,87,78,85,4),
(421.1,'Cherrim_Sunshine_Form','Grass',NULL,450,70,60,70,87,78,85,4),
(422,'Shellos_West_Sea','Water',NULL,325,76,48,48,57,62,34,4),
(422.1,'Shellos_East_Sea','Water',NULL,325,76,48,48,57,62,34,4),
(423,'Gastrodon_West_Sea','Water','Ground',475,111,83,68,92,82,39,4),
(423.1,'Gastrodon_East_Sea','Water','Ground',475,111,83,68,92,82,39,4),
(424,'Ambipom','Normal',NULL,482,75,100,66,60,66,115,4),
(425,'Drifloon','Ghost','Flying',348,90,50,34,60,44,70,4),
(426,'Drifblim','Ghost','Flying',498,150,80,44,90,54,80,4),
(427,'Buneary','Normal',NULL,350,55,66,44,44,56,85,4),
(428,'Lopunny','Normal',NULL,480,65,76,84,54,96,105,4),
(428.1,'Mega_Lopunny','Normal','Fighting',580,65,136,94,54,96,135,6),
(429,'Mismagius','Ghost',NULL,495,60,60,60,105,105,105,4),
(430,'Honchkrow','Dark','Flying',505,100,125,52,105,52,71,4),
(431,'Glameow','Normal',NULL,310,49,55,42,42,37,85,4),
(432,'Purugly','Normal',NULL,452,71,82,64,64,59,112,4),
(433,'Chingling','Psychic',NULL,285,45,30,50,65,50,45,4),
(434,'Stunky','Poison','Dark',329,63,63,47,41,41,74,4),
(435,'Skuntank','Poison','Dark',479,103,93,67,71,61,84,4),
(436,'Bronzor','Steel','Psychic',300,57,24,86,24,86,23,4),
(437,'Bronzong','Steel','Psychic',500,67,89,116,79,116,33,4),
(438,'Bonsly','Rock',NULL,290,50,80,95,10,45,10,4),
(439,'Mime_Jr','Psychic','Fairy',310,20,25,45,70,90,60,4),
(440,'Happiny','Normal',NULL,220,100,5,5,15,65,30,4),
(441,'Chatot','Normal','Flying',411,76,65,45,92,42,91,4),
(442,'Spiritomb','Ghost','Dark',485,50,92,108,92,108,35,4),
(443,'Gible','Dragon','Ground',300,58,70,45,40,45,42,4),
(444,'Gabite','Dragon','Ground',410,68,90,65,50,55,82,4),
(445,'Garchomp','Dragon','Ground',600,108,130,95,80,85,102,4),
(445.1,'Mega_Garchomp','Dragon','Ground',700,108,170,115,120,95,92,6),
(446,'Munchlax','Normal',NULL,390,135,85,40,40,85,5,4),
(447,'Riolu','Fighting',NULL,285,40,70,40,35,40,60,4),
(448,'Lucario','Fighting','Steel',525,70,110,70,115,70,90,4),
(448.1,'Mega_Lucario','Fighting','Steel',625,70,145,88,140,70,112,6),
(449,'Hippopotas','Ground',NULL,330,68,72,78,38,42,32,4),
(450,'Hippowdon','Ground',NULL,525,108,112,118,68,72,47,4),
(451,'Skorupi','Poison','Bug',330,40,50,90,30,55,65,4),
(452,'Drapion','Poison','Dark',500,70,90,110,60,75,95,4),
(453,'Croagunk','Poison','Fighting',300,48,61,40,61,40,50,4),
(454,'Toxicroak','Poison','Fighting',490,83,106,65,86,65,85,4),
(455,'Carnivine','Grass',NULL,454,74,100,72,90,72,46,4),
(456,'Finneon','Water',NULL,330,49,49,56,49,61,66,4),
(457,'Lumineon','Water',NULL,460,69,69,76,69,86,91,4),
(458,'Mantyke','Water','Flying',345,45,20,50,60,120,50,4),
(459,'Snover','Grass','Ice',334,60,62,50,62,60,40,4),
(460,'Abomasnow','Grass','Ice',494,90,92,75,92,85,60,4),
(460.1,'Mega_Abomasnow','Grass','Ice',594,90,132,105,132,105,30,6),
(461,'Weavile','Dark','Ice',510,70,120,65,45,85,125,4),
(462,'Magnezone','Electric','Steel',535,70,70,115,130,90,60,4),
(463,'Lickilicky','Normal',NULL,515,110,85,95,80,95,50,4),
(464,'Rhyperior','Ground','Rock',535,115,140,130,55,55,40,4),
(465,'Tangrowth','Grass',NULL,535,100,100,125,110,50,50,4),
(466,'Electivire','Electric',NULL,540,75,123,67,95,85,95,4),
(467,'Magmortar','Fire',NULL,540,75,95,67,125,95,83,4),
(468,'Togekiss','Fairy','Flying',545,85,50,95,120,115,80,4),
(469,'Yanmega','Bug','Flying',515,86,76,86,116,56,95,4),
(470,'Leafeon','Grass',NULL,525,65,110,130,60,65,95,4),
(471,'Glaceon','Ice',NULL,525,65,60,110,130,95,65,4),
(472,'Gliscor','Ground','Flying',510,75,95,125,45,75,95,4),
(473,'Mamoswine','Ice','Ground',530,110,130,80,70,60,80,4),
(474,'Porygon_Z','Normal',NULL,535,85,80,70,135,75,90,4),
(475,'Gallade','Psychic','Fighting',518,68,125,65,65,115,80,4),
(475.1,'Mega_Gallade','Psychic','Fighting',618,68,165,95,65,115,110,6),
(476,'Probopass','Rock','Steel',525,60,55,145,75,150,40,4),
(477,'Dusknoir','Ghost',NULL,525,45,100,135,65,135,45,4),
(478,'Froslass','Ice','Ghost',480,70,80,70,80,70,110,4),
(479,'Rotom','Electric','Ghost',440,50,50,77,95,77,91,4),
(479.1,'Rotom_Heat_Rotom','Electric','Fire',520,50,65,107,105,107,86,4),
(479.2,'Rotom_Wash_Rotom','Electric','Water',520,50,65,107,105,107,86,4),
(479.3,'Rotom_Frost_Rotom','Electric','Ice',520,50,65,107,105,107,86,4),
(479.4,'Rotom_Fan_Rotom','Electric','Flying',520,50,65,107,105,107,86,4),
(479.5,'Rotom_Mow_Rotom','Electric','Grass',520,50,65,107,105,107,86,4),
(480,'Uxie','Psychic',NULL,580,75,75,130,75,130,95,4),
(481,'Mesprit','Psychic',NULL,580,80,105,105,105,105,80,4),
(482,'Azelf','Psychic',NULL,580,75,125,70,125,70,115,4),
(483,'Dialga','Steel','Dragon',680,100,120,120,150,100,90,4),
(483.1,'Dialga_Origin_Forme','Steel','Dragon',680,100,100,120,150,120,90,8),
(484,'Palkia','Water','Dragon',680,90,120,100,150,120,100,4),
(484.1,'Palkia_Origin_Forme','Water','Dragon',680,90,100,100,150,120,120,8),
(485,'Heatran','Fire','Steel',600,91,90,106,130,106,77,4),
(486,'Regigigas','Normal',NULL,670,110,160,110,80,110,100,4),
(487,'Giratina_Altered_Forme','Ghost','Dragon',680,150,100,120,100,120,90,4),
(487.1,'Giratina_Origin_Forme','Ghost','Dragon',680,150,120,100,120,100,90,4),
(488,'Cresselia','Psychic',NULL,580,120,70,110,75,120,85,4),
(489,'Phione','Water',NULL,480,80,80,80,80,80,80,4),
(490,'Manaphy','Water',NULL,600,100,100,100,100,100,100,4),
(491,'Darkrai','Dark',NULL,600,70,90,90,135,90,125,4),
(492,'Shaymin_Land_Forme','Grass',NULL,600,100,100,100,100,100,100,4),
(492.1,'Shaymin_Sky_Forme','Grass','Flying',600,100,103,75,120,75,127,4),
(493,'Arceus','Normal',NULL,720,120,120,120,120,120,120,4),
(493.1,'Arceus_Bug','Bug',NULL,720,120,120,120,120,120,120,4),
(493.2,'Arceus_Dark','Dark',NULL,720,120,120,120,120,120,120,4),
(493.3,'Arceus_Dragon','Dragon',NULL,720,120,120,120,120,120,120,4),
(493.4,'Arceus_Electric','Electric',NULL,720,120,120,120,120,120,120,4),
(493.5,'Arceus_Fairy','Fairy',NULL,720,120,120,120,120,120,120,4),
(493.6,'Arceus_Fighting','Fighting',NULL,720,120,120,120,120,120,120,4),
(493.7,'Arceus_Fire','Fire',NULL,720,120,120,120,120,120,120,4),
(493.8,'Arceus_Flying','Flying',NULL,720,120,120,120,120,120,120,4),
(493.9,'Arceus_Ghost','Ghost',NULL,720,120,120,120,120,120,120,4),
(493.11,'Arceus_Grass','Grass',NULL,720,120,120,120,120,120,120,4),
(493.12,'Arceus_Ground','Ground',NULL,720,120,120,120,120,120,120,4),
(493.13,'Arceus_Ice','Ice',NULL,720,120,120,120,120,120,120,4),
(493.14,'Arceus_Poison','Poison',NULL,720,120,120,120,120,120,120,4),
(493.15,'Arceus_Psychic','Psychic',NULL,720,120,120,120,120,120,120,4),
(493.16,'Arceus_Rock','Rock',NULL,720,120,120,120,120,120,120,4),
(493.17,'Arceus_Steel','Steel',NULL,720,120,120,120,120,120,120,4),
(493.18,'Arceus_Water','Water',NULL,720,120,120,120,120,120,120,4),
(494,'Victini','Psychic','Fire',600,100,100,100,100,100,100,5),
(495,'Snivy','Grass',NULL,308,45,45,55,45,55,63,5),
(496,'Servine','Grass',NULL,413,60,60,75,60,75,83,5),
(497,'Serperior','Grass',NULL,528,75,75,95,75,95,113,5),
(498,'Tepig','Fire',NULL,308,65,63,45,45,45,45,5),
(499,'Pignite','Fire','Fighting',418,90,93,55,70,55,55,5),
(500,'Emboar','Fire','Fighting',528,110,123,65,100,65,65,5),
(501,'Oshawott','Water',NULL,308,55,55,45,63,45,45,5),
(502,'Dewott','Water',NULL,413,75,75,60,83,60,60,5),
(503,'Samurott','Water',NULL,528,95,100,85,108,70,70,5),
(503.1,'Hisuian_Samurott','Water','Dark',528,90,108,80,100,65,85,8),
(504,'Patrat','Normal',NULL,255,45,55,39,35,39,42,5),
(505,'Watchog','Normal',NULL,420,60,85,69,60,69,77,5),
(506,'Lillipup','Normal',NULL,275,45,60,45,25,45,55,5),
(507,'Herdier','Normal',NULL,370,65,80,65,35,65,60,5),
(508,'Stoutland','Normal',NULL,500,85,110,90,45,90,80,5),
(509,'Purrloin','Dark',NULL,281,41,50,37,50,37,66,5),
(510,'Liepard','Dark',NULL,446,64,88,50,88,50,106,5),
(511,'Pansage','Grass',NULL,316,50,53,48,53,48,64,5),
(512,'Simisage','Grass',NULL,498,75,98,63,98,63,101,5),
(513,'Pansear','Fire',NULL,316,50,53,48,53,48,64,5),
(514,'Simisear','Fire',NULL,498,75,98,63,98,63,101,5),
(515,'Panpour','Water',NULL,316,50,53,48,53,48,64,5),
(516,'Simipour','Water',NULL,498,75,98,63,98,63,101,5),
(517,'Munna','Psychic',NULL,292,76,25,45,67,55,24,5),
(518,'Musharna','Psychic',NULL,487,116,55,85,107,95,29,5),
(519,'Pidove','Normal','Flying',264,50,55,50,36,30,43,5),
(520,'Tranquill','Normal','Flying',358,62,77,62,50,42,65,5),
(521,'Unfezant','Normal','Flying',488,80,115,80,65,55,93,5),
(522,'Blitzle','Electric',NULL,295,45,60,32,50,32,76,5),
(523,'Zebstrika','Electric',NULL,497,75,100,63,80,63,116,5),
(524,'Roggenrola','Rock',NULL,280,55,75,85,25,25,15,5),
(525,'Boldore','Rock',NULL,390,70,105,105,50,40,20,5),
(526,'Gigalith','Rock',NULL,515,85,135,130,60,80,25,5),
(527,'Woobat','Psychic','Flying',323,65,45,43,55,43,72,5),
(528,'Swoobat','Psychic','Flying',425,67,57,55,77,55,114,5),
(529,'Drilbur','Ground',NULL,328,60,85,40,30,45,68,5),
(530,'Excadrill','Ground','Steel',508,110,135,60,50,65,88,5),
(531,'Audino','Normal',NULL,445,103,60,86,60,86,50,5),
(531.1,'Mega_Audino','Normal','Fairy',545,103,60,126,80,126,50,6),
(532,'Timburr','Fighting',NULL,305,75,80,55,25,35,35,5),
(533,'Gurdurr','Fighting',NULL,405,85,105,85,40,50,40,5),
(534,'Conkeldurr','Fighting',NULL,505,105,140,95,55,65,45,5),
(535,'Tympole','Water',NULL,294,50,50,40,50,40,64,5),
(536,'Palpitoad','Water','Ground',384,75,65,55,65,55,69,5),
(537,'Seismitoad','Water','Ground',509,105,95,75,85,75,74,5),
(538,'Throh','Fighting',NULL,465,120,100,85,30,85,45,5),
(539,'Sawk','Fighting',NULL,465,75,125,75,30,75,85,5),
(540,'Sewaddle','Bug','Grass',310,45,53,70,40,60,42,5),
(541,'Swadloon','Bug','Grass',380,55,63,90,50,80,42,5),
(542,'Leavanny','Bug','Grass',500,75,103,80,70,80,92,5),
(543,'Venipede','Bug','Poison',260,30,45,59,30,39,57,5),
(544,'Whirlipede','Bug','Poison',360,40,55,99,40,79,47,5),
(545,'Scolipede','Bug','Poison',485,60,100,89,55,69,112,5),
(546,'Cottonee','Grass','Fairy',280,40,27,60,37,50,66,5),
(547,'Whimsicott','Grass','Fairy',480,60,67,85,77,75,116,5),
(548,'Petilil','Grass',NULL,280,45,35,50,70,50,30,5),
(549,'Lilligant','Grass',NULL,480,70,60,75,110,75,90,5),
(549.1,'Hisuian_Lilligant','Grass','Fighting',480,70,105,75,50,75,105,8), 
(550,'Basculin_Red_Striped_Form','Water',NULL,460,70,92,65,80,55,98,5),
(550.1,'Basculin_Blue_Striped_Form','Water',NULL,460,70,92,65,80,55,98,5),
(550.2,'Basculin_White_Striped_Form','Water',NULL,460,70,92,65,80,55,98,5),
(551,'Sandile','Ground','Dark',292,50,72,35,35,35,65,5),
(552,'Krokorok','Ground','Dark',351,60,82,45,45,45,74,5),
(553,'Krookodile','Ground','Dark',519,95,117,80,65,70,92,5),
(554,'Darumaka','Fire',NULL,315,70,90,45,15,45,50,5),
(554.1,'Galarian_Darumaka','Ice',NULL,315,70,90,45,15,45,50,8),
(555,'Darmanitan_Standard_Mode','Fire',NULL,480,105,140,55,30,55,95,5),
(555.1,'Darmanitan_Zen_Mode','Fire','Psychic',540,105,30,105,140,105,55,5),
(555.2,'Darmanitan_Galarian_Standard_Mode','Ice',NULL,480,105,140,55,30,55,95,8),
(555.3,'Darmanitan_Galarian_Zen_Mode','Ice','Fire',540,105,160,55,30,55,135,8),
(556,'Maractus','Grass',NULL,461,75,86,67,106,67,60,5),
(557,'Dwebble','Bug','Rock',325,50,65,85,35,35,55,5),
(558,'Crustle','Bug','Rock',485,70,105,125,65,75,45,5),
(559,'Scraggy','Dark','Fighting',348,50,75,70,35,70,48,5),
(560,'Scrafty','Dark','Fighting',488,65,90,115,45,115,58,5),
(561,'Sigilyph','Psychic','Flying',490,72,58,80,103,80,97,5),
(562,'Yamask','Ghost',NULL,303,38,30,85,55,65,30,5),
(562.1,'Galarian_Yamask','Ground','Ghost',303,38,55,85,30,65,30,8),
(563,'Cofagrigus','Ghost',NULL,483,58,50,145,95,105,30,5),
(564,'Tirtouga','Water','Rock',355,54,78,103,53,45,22,5),
(565,'Carracosta','Water','Rock',495,74,108,133,83,65,32,5),
(566,'Archen','Rock','Flying',401,55,112,45,74,45,70,5),
(567,'Archeops','Rock','Flying',567,75,140,65,112,65,110,5),
(568,'Trubbish','Poison',NULL,329,50,50,62,40,62,65,5),
(569,'Garbodor','Poison',NULL,474,80,95,82,60,82,75,5),
(570,'Zorua','Dark',NULL,330,40,65,40,80,40,65,5),
(570.1,'Hisuian_Zorua','Normal','Ghost',330,35,60,40,85,40,70,8),
(571,'Zoroark','Dark',NULL,510,60,105,60,120,60,105,5),
(571.1,'Hisuian_Zoroark','Normal','Ghost',510,60,105,60,120,60,105,8),
(572,'Minccino','Normal',NULL,300,55,50,40,40,40,75,5),
(573,'Cinccino','Normal',NULL,470,75,95,60,65,60,115,5),
(574,'Gothita','Psychic',NULL,290,45,30,50,55,65,45,5),
(575,'Gothorita','Psychic',NULL,390,60,45,70,75,85,55,5),
(576,'Gothitelle','Psychic',NULL,490,70,55,95,95,110,65,5),
(577,'Solosis','Psychic',NULL,290,45,30,40,105,50,20,5),
(578,'Duosion','Psychic',NULL,370,65,40,50,125,60,30,5),
(579,'Reuniclus','Psychic',NULL,490,110,65,75,125,85,30,5),
(580,'Ducklett','Water','Flying',305,62,44,50,44,50,55,5),
(581,'Swanna','Water','Flying',473,75,87,63,87,63,98,5),
(582,'Vanillite','Ice',NULL,305,36,50,50,65,60,44,5),
(583,'Vanillish','Ice',NULL,395,51,65,65,80,75,59,5),
(584,'Vanilluxe','Ice',NULL,535,71,95,85,110,95,79,5),
(585,'Deerling_Spring_Form','Normal','Grass',335,60,60,50,40,50,75,5),
(585.1,'Deerling_Summer_Form','Normal','Grass',335,60,60,50,40,50,75,5),
(585.2,'Deerling_Autumn_Form','Normal','Grass',335,60,60,50,40,50,75,5),
(585.3,'Deerling_Winter_Form','Normal','Grass',335,60,60,50,40,50,75,5),
(586,'Sawsbuck_Spring_Form','Normal','Grass',475,80,100,70,60,70,95,5),
(586.1,'Sawsbuck_Summer_Form','Normal','Grass',475,80,100,70,60,70,95,5),
(586.2,'Sawsbuck_Autumn_Form','Normal','Grass',475,80,100,70,60,70,95,5),
(586.3,'Sawsbuck_Winter_Form','Normal','Grass',475,80,100,70,60,70,95,5),
(587,'Emolga','Electric','Flying',428,55,75,60,75,60,103,5),
(588,'Karrablast','Bug',NULL,315,50,75,45,40,45,60,5),
(589,'Escavalier','Bug','Steel',495,70,135,105,60,105,20,5),
(590,'Foongus','Grass','Poison',294,69,55,45,55,55,15,5),
(591,'Amoonguss','Grass','Poison',464,114,85,70,85,80,30,5),
(592,'Frillish','Water','Ghost',335,55,40,50,65,85,40,5),
(593,'Jellicent','Water','Ghost',480,100,60,70,85,105,60,5),
(594,'Alomomola','Water',NULL,470,165,75,80,40,45,65,5),
(595,'Joltik','Bug','Electric',319,50,47,50,57,50,65,5),
(596,'Galvantula','Bug','Electric',472,70,77,60,97,60,108,5),
(597,'Ferroseed','Grass','Steel',305,44,50,91,24,86,10,5),
(598,'Ferrothorn','Grass','Steel',489,74,94,131,54,116,20,5),
(599,'Klink','Steel',NULL,300,40,55,70,45,60,30,5),
(600,'Klang','Steel',NULL,440,60,80,95,70,85,50,5),
(601,'Klinklang','Steel',NULL,520,60,100,115,70,85,90,5),
(602,'Tynamo','Electric',NULL,275,35,55,40,45,40,60,5),
(603,'Eelektrik','Electric',NULL,405,65,85,70,75,70,40,5),
(604,'Eelektross','Electric',NULL,515,85,115,80,105,80,50,5),
(605,'Elgyem','Psychic',NULL,335,55,55,55,85,55,30,5),
(606,'Beheeyem','Psychic',NULL,485,75,75,75,125,95,40,5),
(607,'Litwick','Ghost','Fire',275,50,30,55,65,55,20,5),
(608,'Lampent','Ghost','Fire',370,60,40,60,95,60,55,5),
(609,'Chandelure','Ghost','Fire',520,60,55,90,145,90,80,5),
(610,'Axew','Dragon',NULL,320,46,87,60,30,40,57,5),
(611,'Fraxure','Dragon',NULL,410,66,117,70,40,50,67,5),
(612,'Haxorus','Dragon',NULL,540,76,147,90,60,70,97,5),
(613,'Cubchoo','Ice',NULL,305,55,70,40,60,40,40,5),
(614,'Beartic','Ice',NULL,505,95,130,80,70,80,50,5),
(615,'Cryogonal','Ice',NULL,515,80,50,50,95,135,105,5),
(616,'Shelmet','Bug',NULL,305,50,40,85,40,65,25,5),
(617,'Accelgor','Bug',NULL,495,80,70,40,100,60,145,5),
(618,'Stunfisk','Ground','Electric',471,109,66,84,81,99,32,5),
(618.1,'Galarian_Stunfisk','Ground','Steel',471,109,81,99,66,84,32,8),
(619,'Mienfoo','Fighting',NULL,350,45,85,50,55,50,65,5),
(620,'Mienshao','Fighting',NULL,510,65,125,60,95,60,105,5),
(621,'Druddigon','Dragon',NULL,485,77,120,90,60,90,48,5),
(622,'Golett','Ground','Ghost',303,59,74,50,35,50,35,5),
(623,'Golurk','Ground','Ghost',483,89,124,80,55,80,55,5),
(624,'Pawniard','Dark','Steel',340,45,85,70,40,40,60,5),
(625,'Bisharp','Dark','Steel',490,65,125,100,60,70,70,5),
(626,'Bouffalant','Normal',NULL,490,95,110,95,40,95,55,5),
(627,'Rufflet','Normal','Flying',350,70,83,50,37,50,60,5),
(628,'Braviary','Normal','Flying',510,100,123,75,57,75,80,5),
(628.1,'Hisuian_Braviary','Psychic','Flying',510,110,83,70,112,70,65,8),
(629,'Vullaby','Dark','Flying',370,70,55,75,45,65,60,5),
(630,'Mandibuzz','Dark','Flying',510,110,65,105,55,95,80,5),
(631,'Heatmor','Fire',NULL,484,85,97,66,105,66,65,5),
(632,'Durant','Bug','Steel',484,58,109,112,48,48,109,5),
(633,'Deino','Dark','Dragon',300,52,65,50,45,50,38,5),
(634,'Zweilous','Dark','Dragon',420,72,85,70,65,70,58,5),
(635,'Hydreigon','Dark','Dragon',600,92,105,90,125,90,98,5),
(636,'Larvesta','Bug','Fire',360,55,85,55,50,55,60,5),
(637,'Volcarona','Bug','Fire',550,85,60,65,135,105,100,5),
(638,'Cobalion','Steel','Fighting',580,91,90,129,90,72,108,5),
(639,'Terrakion','Rock','Fighting',580,91,129,90,72,90,108,5),
(640,'Virizion','Grass','Fighting',580,91,90,72,90,129,108,5),
(641,'Tornadus_Incarnate_Forme','Flying',NULL,580,79,115,70,125,80,111,5),
(641.1,'Tornadus_Therian_Forme','Flying',NULL,580,79,100,80,110,90,121,5),
(642,'Thundurus_Incarnate_Forme','Electric','Flying',580,79,115,70,125,80,111,5),
(642.1,'Thundurus_Therian_Forme','Electric','Flying',580,79,105,70,145,80,101,5),
(643,'Reshiram','Dragon','Fire',680,100,120,100,150,120,90,5),
(644,'Zekrom','Dragon','Electric',680,100,150,120,120,100,90,5),
(645,'Landorus_Incarnate_Forme','Flying','Ground',600,89,125,90,115,80,101,5),
(645.1,'Landorus_Therian_Forme','Flying','Ground',600,89,145,90,105,80,91,5),
(646,'Kyurem','Ice','Dragon',660,125,130,90,130,90,95,5),
(646.1,'White_Kyurem','Ice','Dragon',700,125,120,90,170,100,95,5),
(646.2,'Black_Kyurem','Ice','Dragon',700,125,170,100,120,90,95,5),
(647,'Keldeo_Ordinary_Form','Water','Fighting',580,91,72,90,129,90,108,5),
(647.1,'Keldeo_Resolute_Form','Water','Fighting',580,91,72,90,129,90,108,5),
(648,'Meloetta_Aria_Forme','Normal','Psychic',600,100,77,77,128,128,90,5),
(648.1,'Meloetta_Pirouette_Forme','Normal','Fighting',600,100,128,90,77,77,128,5),
(649,'Genesect','Bug','Steel',600,71,120,95,120,95,99,5),
(649.1,'Genesect_Douse_Drive','Bug','Steel',600,71,120,95,120,95,99,5),
(649.2,'Genesect_Shock_Drive','Bug','Steel',600,71,120,95,120,95,99,5),
(649.3,'Genesect_Burn_Drive','Bug','Steel',600,71,120,95,120,95,99,5),
(649.4,'Genesect_Chill_Drive','Bug','Steel',600,71,120,95,120,95,99,5),
(650,'Chespin','Grass',NULL,313,56,61,65,48,45,38,6),
(651,'Quilladin','Grass',NULL,405,61,78,95,56,58,57,6),
(652,'Chesnaught','Grass','Fighting',530,88,107,122,74,75,64,6),
(653,'Fennekin','Fire',NULL,307,40,45,40,62,60,60,6),
(654,'Braixen','Fire',NULL,409,59,59,58,90,70,73,6),
(655,'Delphox','Fire','Psychic',534,75,69,72,114,100,104,6),
(656,'Froakie','Water',NULL,314,41,56,40,62,44,71,6),
(657,'Frogadier','Water',NULL,405,54,63,52,83,56,97,6),
(658,'Greninja','Water','Dark',530,72,95,67,103,71,122,6),
(658.1,'Ash_Greninja','Water','Dark',640,72,145,67,153,71,132, 7),
(659,'Bunnelby','Normal',NULL,237,38,36,38,32,36,57,6),
(660,'Diggersby','Normal','Ground',423,85,56,77,50,77,78,6),
(661,'Fletchling','Normal','Flying',278,45,50,43,40,38,62,6),
(662,'Fletchinder','Fire','Flying',382,62,73,55,56,52,84,6),
(663,'Talonflame','Fire','Flying',499,78,81,71,74,69,126,6),
(664,'Scatterbug','Bug',NULL,200,38,35,40,27,25,35,6),
(665,'Spewpa','Bug',NULL,213,45,22,60,27,30,29,6),
(666,'Vivillon_Archipelago_Pattern','Bug','Flying',411,80,52,50,90,50,89,6),
(666.1,'Vivillon_Continental_Pattern','Bug','Flying',411,80,52,50,90,50,89,6),
(666.2,'Vivillon_Elegant_Pattern','Bug','Flying',411,80,52,50,90,50,89,6),
(666.3,'Vivillon_Fancy_Pattern','Bug','Flying',411,80,52,50,90,50,89,6),
(666.4,'Vivillon_Garden_Pattern','Bug','Flying',411,80,52,50,90,50,89,6),
(666.5,'Vivillon_High_Plains_Pattern','Bug','Flying',411,80,52,50,90,50,89,6),
(666.6,'Vivillon_Icy_Snow_Pattern','Bug','Flying',411,80,52,50,90,50,89,6),
(666.7,'Vivillon_Jungle_Pattern','Bug','Flying',411,80,52,50,90,50,89,6),
(666.8,'Vivillon_Marine_Pattern','Bug','Flying',411,80,52,50,90,50,89,6),
(666.9,'Vivillon_Meadow_Pattern','Bug','Flying',411,80,52,50,90,50,89,6),
(666.11,'Vivillon_Modern_Pattern','Bug','Flying',411,80,52,50,90,50,89,6),
(666.12,'Vivillon_Monsoon_Pattern','Bug','Flying',411,80,52,50,90,50,89,6),
(666.13,'Vivillon_Ocean_Pattern','Bug','Flying',411,80,52,50,90,50,89,6),
(666.14,'Vivillon_Poké_Ball_Pattern','Bug','Flying',411,80,52,50,90,50,89,6),
(666.15,'Vivillon_Polar_Pattern','Bug','Flying',411,80,52,50,90,50,89,6),
(666.16,'Vivillon_River_Pattern','Bug','Flying',411,80,52,50,90,50,89,6),
(666.17,'Vivillon_Sandstorm_Pattern','Bug','Flying',411,80,52,50,90,50,89,6),
(666.18,'Vivillon_Savanna_Pattern','Bug','Flying',411,80,52,50,90,50,89,6),
(666.19,'Vivillon_Sun_Pattern','Bug','Flying',411,80,52,50,90,50,89,6),
(666.21,'Vivillon_Tundra_Pattern','Bug','Flying',411,80,52,50,90,50,89,6),
(667,'Litleo','Fire','Normal',369,62,50,58,73,54,72,6),
(668,'Pyroar','Fire','Normal',507,86,68,72,109,66,106,6),
(669,'Flabébé_Red_Flower','Fairy',NULL,303,44,38,39,61,79,42,6),
(669.1,'Flabébé_Yellow_Flower','Fairy',NULL,303,44,38,39,61,79,42,6),
(669.2,'Flabébé_Orange_Flower','Fairy',NULL,303,44,38,39,61,79,42,6);
INSERT INTO pokemon(Number,Name,Type_1,Type_2,Total,HP,Attack,Defense,Sp_Atk,Sp_Def,Speed,Generation) VALUES

(669.3,'Flabébé_Blue_Flower','Fairy',NULL,303,44,38,39,61,79,42,6),
(669.4,'Flabébé_White_Flower','Fairy',NULL,303,44,38,39,61,79,42,6),
(670,'Floette_Red_Flower','Fairy',NULL,371,54,45,47,75,98,52,6),
(670.1,'Floette_Yellow_Flower','Fairy',NULL,371,54,45,47,75,98,52,6),
(670.2,'Floette_Orange_Flower','Fairy',NULL,371,54,45,47,75,98,52,6),
(670.3,'Floette_Blue_Flower','Fairy',NULL,371,54,45,47,75,98,52,6),
(670.4,'Floette_White_Flower','Fairy',NULL,371,54,45,47,75,98,52,6),
(671,'Florges_Red_Flower','Fairy',NULL,552,78,65,68,112,154,75,6),
(671.1,'Florges_Yellow_Flower','Fairy',NULL,552,78,65,68,112,154,75,6),
(671.2,'Florges_Orange_Flower','Fairy',NULL,552,78,65,68,112,154,75,6),
(671.3,'Florges_Blue_Flower','Fairy',NULL,552,78,65,68,112,154,75,6),
(671.4,'Florges_White_Flower','Fairy',NULL,552,78,65,68,112,154,75,6),
(672,'Skiddo','Grass',NULL,350,66,65,48,62,57,52,6),
(673,'Gogoat','Grass',NULL,531,123,100,62,97,81,68,6),
(674,'Pancham','Fighting',NULL,348,67,82,62,46,48,43,6),
(675,'Pangoro','Fighting','Dark',495,95,124,78,69,71,58,6),
(676,'Furfrou_Natural_Form','Normal',NULL,472,75,80,60,65,90,102,6),
(676.1,'Furfrou_Heart_Trim','Normal',NULL,472,75,80,60,65,90,102,6),
(676.2,'Furfrou_Star_Trim','Normal',NULL,472,75,80,60,65,90,102,6),
(676.3,'Furfrou_Diamond_Trim','Normal',NULL,472,75,80,60,65,90,102,6),
(676.4,'Furfrou_Debutante_Trim','Normal',NULL,472,75,80,60,65,90,102,6),
(676.5,'Furfrou_Matron_Trim	','Normal',NULL,472,75,80,60,65,90,102,6),
(676.6,'Furfrou_Dandy_Trim','Normal',NULL,472,75,80,60,65,90,102,6),
(676.7,'Furfrou_La_Reine_Trim','Normal',NULL,472,75,80,60,65,90,102,6),
(676.8,'Furfrou_Kabuki_Trim','Normal',NULL,472,75,80,60,65,90,102,6),
(676.9,'Furfrou_Pharaoh_Trim','Normal',NULL,472,75,80,60,65,90,102,6),
(677,'Espurr','Psychic',NULL,355,62,48,54,63,60,68,6),
(678,'Meowstic♂','Psychic',NULL,466,74,48,76,83,81,104,6),
(678.1,'Meowstic♀','Psychic',NULL,466,74,48,76,83,81,104,6),
(679,'Honedge','Steel','Ghost',325,45,80,100,35,37,28,6),
(680,'Doublade','Steel','Ghost',448,59,110,150,45,49,35,6),
(681,'Aegislash_Shield_Forme','Steel','Ghost',500,60,50,140,50,140,60,6),
(681.1,'Aegislash_Blade_Forme','Steel','Ghost',500,60,140,50,140,50,60,6),
(682,'Spritzee','Fairy',NULL,341,78,52,60,63,65,23,6),
(683,'Aromatisse','Fairy',NULL,462,101,72,72,99,89,29,6),
(684,'Swirlix','Fairy',NULL,341,62,48,66,59,57,49,6),
(685,'Slurpuff','Fairy',NULL,480,82,80,86,85,75,72,6),
(686,'Inkay','Dark','Psychic',288,53,54,53,37,46,45,6),
(687,'Malamar','Dark','Psychic',482,86,92,88,68,75,73,6),
(688,'Binacle','Rock','Water',306,42,52,67,39,56,50,6),
(689,'Barbaracle','Rock','Water',500,72,105,115,54,86,68,6),
(690,'Skrelp','Poison','Water',320,50,60,60,60,60,30,6),
(691,'Dragalge','Poison','Dragon',494,65,75,90,97,123,44,6),
(692,'Clauncher','Water',NULL,330,50,53,62,58,63,44,6),
(693,'Clawitzer','Water',NULL,500,71,73,88,120,89,59,6),
(694,'Helioptile','Electric','Normal',289,44,38,33,61,43,70,6),
(695,'Heliolisk','Electric','Normal',481,62,55,52,109,94,109,6),
(696,'Tyrunt','Rock','Dragon',362,58,89,77,45,45,48,6),
(697,'Tyrantrum','Rock','Dragon',521,82,121,119,69,59,71,6),
(698,'Amaura','Rock','Ice',362,77,59,50,67,63,46,6),
(699,'Aurorus','Rock','Ice',521,123,77,72,99,92,58,6),
(700,'Sylveon','Fairy',NULL,525,95,65,65,110,130,60,6),
(701,'Hawlucha','Fighting','Flying',500,78,92,75,74,63,118,6),
(702,'Dedenne','Electric','Fairy',431,67,58,57,81,67,101,6),
(703,'Carbink','Rock','Fairy',500,50,50,150,50,150,50,6),
(704,'Goomy','Dragon',NULL,300,45,50,35,55,75,40,6),
(705,'Sliggoo','Dragon',NULL,452,68,75,53,83,113,60,6),
(705.1,'Hisuian_Sliggoo','Steel','Dragon',452,58,75,83,83,113,40,8),
(706,'Goodra','Dragon',NULL,600,90,100,70,110,150,80,6),
(706.1,'Hisuian_Goodra','Steel','Dragon',600,80,100,100,110,150,60,8),
(707,'Klefki','Steel','Fairy',470,57,80,91,80,87,75,6),
(708,'Phantump','Ghost','Grass',309,43,70,48,50,60,38,6),
(709,'Trevenant','Ghost','Grass',474,85,110,76,65,82,56,6),
(710,'Pumpkaboo_Average_Size','Ghost','Grass',335,49,66,70,44,55,51,6),
(710.1,'Pumpkaboo_Small_Size','Ghost','Grass',335,44,66,70,44,55,56,6),
(710.2,'Pumpkaboo_Large_Size','Ghost','Grass',335,54,66,70,44,55,46,6),
(710.3,'Pumpkaboo_Super_Size','Ghost','Grass',335,59,66,70,44,55,41,6),
(711,'Gourgeist_Average_Size','Ghost','Grass',494,65,90,122,58,75,84,6),
(711.1,'Gourgeist_Small_Size','Ghost','Grass',494,55,85,122,58,75,99,6),
(711.2,'Gourgeist_Large_Size','Ghost','Grass',494,75,95,122,58,75,69,6),
(711.3,'Gourgeist_Super_Size','Ghost','Grass',494,85,100,122,58,75,54,6),
(712,'Bergmite','Ice',NULL,304,55,69,85,32,35,28,6),
(713,'Avalugg','Ice',NULL,514,95,117,184,44,46,28,6),
(713.1,'Hisuian_Avalugg','Ice','Rock',514,95,127,184,34,36,38,8),
(714,'Noibat','Flying','Dragon',245,40,30,35,45,40,55,6),
(715,'Noivern','Flying','Dragon',535,85,70,80,97,80,123,6),
(716,'Xerneas_Neutral_Mode','Fairy',NULL,680,126,131,95,131,98,99,6),
(716.1,'Xerneas_Active_Mode','Fairy',NULL,680,126,131,95,131,98,99,6),
(717,'Yveltal','Dark','Flying',680,126,131,95,131,98,99,6),
(718,'Zygarde10%_Forme','Dragon','Ground',486,54,100,71,61,85,115,7),
(718.1,'Zygarde50%_Forme','Dragon','Ground',600,108,100,121,81,95,95,6),
(718.2,'Zygarde_Complete_Forme','Dragon','Ground',708,216,100,121,91,95,85,7),
(719,'Diancie','Rock','Fairy',600,50,100,150,100,150,50,6),
(719.1,'Mega_Diancie','Rock','Fairy',700,50,160,110,160,110,110,6),
(720,'Hoopa_Confined','Psychic','Ghost',600,80,110,60,150,130,70,6),
(720.1,'Hoopa_Unbound','Psychic','Dark',680,80,160,60,170,130,80,6),
(721,'Volcanion','Fire','Water',600,80,110,120,130,90,70,6),
(722,'Rowlet','Grass','Flying',320,68,55,55,50,50,42,7),
(723,'Dartrix','Grass','Flying',420,78,75,75,70,70,52,7),
(724,'Decidueye','Grass','Ghost',530,78,107,75,100,100,70,7),
(724.1,'Hisuian_Decidueye','Grass','Fighting',530,88,112,80,95,95,60,8),
(725,'Litten','Fire',NULL,320,45,65,40,60,40,70,7),
(726,'Torracat','Fire',NULL,420,65,85,50,80,50,90,7),
(727,'Incineroar','Fire','Dark',530,95,115,90,80,90,60,7),
(728,'Popplio','Water',NULL,320,50,54,54,66,56,40,7),
(729,'Brionne','Water',NULL,420,60,69,69,91,81,50,7),
(730,'Primarina','Water','Fairy',530,80,74,74,126,116,60,7),
(731,'Pikipek','Normal','Flying',265,35,75,30,30,30,65,7),
(732,'Trumbeak','Normal','Flying',355,55,85,50,40,50,75,7),
(733,'Toucannon','Normal','Flying',485,80,120,75,75,75,60,7),
(734,'Yungoos','Normal',NULL,253,48,70,30,30,30,45,7),
(735,'Gumshoos','Normal',NULL,418,88,110,60,55,60,45,7),
(736,'Grubbin','Bug',NULL,300,47,62,45,55,45,46,7),
(737,'Charjabug','Bug','Electric',400,57,82,95,55,75,36,7),
(738,'Vikavolt','Bug','Electric',500,77,70,90,145,75,43,7),
(739,'Crabrawler','Fighting',NULL,338,47,82,57,42,47,63,7),
(740,'Crabominable','Fighting','Ice',478,97,132,77,62,67,43,7),
(741,'Oricorio_Baile_Style','Fire','Flying',476,75,70,70,98,70,93,7),
(741.1,'Oricorio_Pom_Pom_Style','Electric','Flying',476,75,70,70,98,70,93,7),
(741.2,"Oricorio_Pa'u_Style",'Psychic','Flying',476,75,70,70,98,70,93,7),
(741.3,'Oricorio_Sensu_Style','Ghost','Flying',476,75,70,70,98,70,93,7),
(742,'Cutiefly','Bug','Fairy',304,40,45,40,55,40,84,7),
(743,'Ribombee','Bug','Fairy',464,60,55,60,95,70,124,7),
(744,'Rockruff','Rock',NULL,280,45,65,40,30,40,60,7),
(745,'Lycanroc_Midday_Form','Rock',NULL,487,75,115,65,55,65,112,7),
(745.1,'Lycanroc_Midnight_Form','Rock',NULL,487,85,115,75,55,75,82,7),
(745.2,'Lycanroc_Dusk_Form','Rock',NULL,487,75,117,65,55,65,110,7),
(746,'Wishiwashi_Solo_Form','Water',NULL,175,45,20,20,25,25,40,7),
(746.1,'Wishiwashi_School_Form"','Water',NULL,620,45,140,130,140,135,30,7),
(747,'Mareanie','Poison','Water',305,50,53,62,43,52,45,7),
(748,'Toxapex','Poison','Water',495,50,63,152,53,142,35,7),
(749,'Mudbray','Ground',NULL,385,70,100,70,45,55,45,7),
(750,'Mudsdale','Ground',NULL,500,100,125,100,55,85,35,7),
(751,'Dewpider','Water','Bug',269,38,40,52,40,72,27,7),
(752,'Araquanid','Water','Bug',454,68,70,92,50,132,42,7),
(753,'Fomantis','Grass',NULL,250,40,55,35,50,35,35,7),
(754,'Lurantis','Grass',NULL,480,70,105,90,80,90,45,7),
(755,'Morelull','Grass','Fairy',285,40,35,55,65,75,15,7),
(756,'Shiinotic','Grass','Fairy',405,60,45,80,90,100,30,7),
(757,'Salandit','Poison','Fire',320,48,44,40,71,40,77,7),
(758,'Salazzle','Poison','Fire',480,68,64,60,111,60,117,7),
(759,'Stufful','Normal','Fighting',340,70,75,50,45,50,50,7),
(760,'Bewear','Normal','Fighting',500,120,125,80,55,60,60,7),
(761,'Bounsweet','Grass',NULL,210,42,30,38,30,38,32,7),
(762,'Steenee','Grass',NULL,290,52,40,48,40,48,62,7),
(763,'Tsareena','Grass',NULL,510,72,120,98,50,98,72,7),
(764,'Comfey','Fairy',NULL,485,51,52,90,82,110,100,7),
(765,'Oranguru','Normal','Psychic',490,90,60,80,90,110,60,7),
(766,'Passimian','Fighting',NULL,490,100,120,90,40,60,80,7),
(767,'Wimpod','Bug','Water',230,25,35,40,20,30,80,7),
(768,'Golisopod','Bug','Water',530,75,125,140,60,90,40,7),
(769,'Sandygast','Ghost','Ground',320,55,55,80,70,45,15,7),
(770,'Palossand','Ghost','Ground',480,85,75,110,100,75,35,7),
(771,'Pyukumuku','Water',NULL,410,55,60,130,30,130,5,7),
(772,'Type:_Null','Normal',NULL,534,95,95,95,95,95,59,7),
(773,'Silvally','Normal',NULL,570,95,95,95,95,95,95,7),
(773.1,'Silvally_Bug','Bug',NULL,570,95,95,95,95,95,95,7),
(773.2,'Silvally_Dark','Dark',NULL,570,95,95,95,95,95,95,7),
(773.3,'Silvally_Dragon','Dragon',NULL,570,95,95,95,95,95,95,7),
(773.4,'Silvally_Electric','Electric',NULL,570,95,95,95,95,95,95,7),
(773.5,'Silvally_Fairy','Fairy',NULL,570,95,95,95,95,95,95,7),
(773.6,'Silvally_Fighting','Fighting',NULL,570,95,95,95,95,95,95,7),
(773.7,'Silvally_Fire','Fire',NULL,570,95,95,95,95,95,95,7),
(773.8,'Silvally_Flying','Flying',NULL,570,95,95,95,95,95,95,7),
(773.9,'Silvally_Ghost','Ghost',NULL,570,95,95,95,95,95,95,7),
(773.11,'Silvally_Grass','Grass',NULL,570,95,95,95,95,95,95,7),
(773.12,'Silvally_Ground','Ground',NULL,570,95,95,95,95,95,95,7),
(773.13,'Silvally_Ice','Ice',NULL,570,95,95,95,95,95,95,7),
(773.14,'Silvally_Poison','Poison',NULL,570,95,95,95,95,95,95,7),
(773.15,'Silvally_Psychic','Psychic',NULL,570,95,95,95,95,95,95,7),
(773.16,'Silvally_Rock','Rock',NULL,570,95,95,95,95,95,95,7),
(773.17,'Silvally_Steel','Steel',NULL,570,95,95,95,95,95,95,7),
(773.18,'Silvally_Water','Water',NULL,570,95,95,95,95,95,95,7),
(774,'Minior_Meteor_Form','Rock','Flying',440,60,60,100,60,100,60,7),
(774.1,'Minior_Red_Core','Rock','Flying',500,60,100,60,100,60,120,7),
(774.2,'Minior_Orange_Core','Rock','Flying',500,60,100,60,100,60,120,7),
(774.3,'Minior_Yellow_Core','Rock','Flying',500,60,100,60,100,60,120,7),
(774.4,'Minior_Green_Core','Rock','Flying',500,60,100,60,100,60,120,7),
(774.5,'Minior_Blue_Core','Rock','Flying',500,60,100,60,100,60,120,7),
(774.6,'Minior_Indigo_Core','Rock','Flying',500,60,100,60,100,60,120,7),
(774.7,'Minior_Violet_Core','Rock','Flying',500,60,100,60,100,60,120,7),
(775,'Komala','Normal',NULL,480,65,115,65,75,95,65,7),
(776,'Turtonator','Fire','Dragon',485,60,78,135,91,85,36,7),
(777,'Togedemaru','Electric','Steel',435,65,98,63,40,73,96,7),
(778,'Mimikyu_Disguised_Form','Ghost','Fairy',476,55,90,80,50,105,96,7),
(778.1,'Mimikyu_Busted_Form','Ghost','Fairy',476,55,90,80,50,105,96,7),
(779,'Bruxish','Water','Psychic',475,68,105,70,70,70,92,7),
(780,'Drampa','Normal','Dragon',485,78,60,85,135,91,36,7),
(781,'Dhelmise','Ghost','Grass',517,70,131,100,86,90,40,7),
(782,'Jangmo_o','Dragon',NULL,300,45,55,65,45,45,45,7),
(783,'Hakamo_o','Dragon','Fighting',420,55,75,90,65,70,65,7),
(784,'Kommo_o','Dragon','Fighting',600,75,110,125,100,105,85,7),
(785,'Tapu_Koko','Electric','Fairy',570,70,115,85,95,75,130,7),
(786,'Tapu_Lele','Psychic','Fairy',570,70,85,75,130,115,95,7),
(787,'Tapu_Bulu','Grass','Fairy',570,70,130,115,85,95,75,7),
(788,'Tapu_Fini','Water','Fairy',570,70,75,115,95,130,85,7),
(789,'Cosmog','Psychic',NULL,200,43,29,31,29,31,37,7),
(790,'Cosmoem','Psychic',NULL,400,43,29,131,29,131,37,7),
(791,'Solgaleo','Psychic','Steel',680,137,137,107,113,89,97,7),
(792,'Lunala','Psychic','Ghost',680,137,113,89,137,107,97,7),
(793,'Nihilego','Rock','Poison',570,109,53,47,127,131,103,7),
(794,'Buzzwole','Bug','Fighting',570,107,139,139,53,53,79,7),
(795,'Pheromosa','Bug','Fighting',570,71,137,37,137,37,151,7),
(796,'Xurkitree','Electric',NULL,570,83,89,71,173,71,83,7),
(797,'Celesteela','Steel','Flying',570,97,101,103,107,101,61,7),
(798,'Kartana','Grass','Steel',570,59,181,131,59,31,109,7),
(799,'Guzzlord','Dark','Dragon',570,223,101,53,97,53,43,7),
(800,'Necrozma','Psychic',NULL,600,97,107,101,127,89,79,7),
(800.1,'Dusk_Mane_Necrozma','Psychic','Steel',680,97,157,127,113,109,77,7),
(800.2,'Dawn_Wings_Necrozma','Psychic','Ghost',680,97,113,109,157,127,77,7),
(800.3,'Ultra_Necrozma','Psychic','Dragon',754,97,167,97,167,97,129,7),
(801,'Magearna','Steel','Fairy',600,80,95,115,130,115,65,7),
(801.1,'Magearna_Original','Steel','Fairy',600,80,95,115,130,115,65,7),
(802,'Marshadow','Fighting','Ghost',600,90,125,80,90,90,125,7),
(803,'Poipole','Poison',NULL,420,67,73,67,73,67,73,7),
(804,'Naganadel','Poison','Dragon',540,73,73,73,127,73,121,7),
(805,'Stakataka','Rock','Steel',570,61,131,211,53,101,13,7),
(806,'Blacephalon','Fire','Ghost',570,53,127,53,151,79,107,7),
(807,'Zeraora','Electric',NULL,600,88,112,75,102,80,143,7),
(808,'Meltan','Steel',NULL,300,46,65,65,55,35,34,7),
(809,'Melmetal','Steel',NULL,600,135,143,143,80,65,34,7),
(810,'Grookey','Grass',NULL,310,50,65,50,40,40,65,8),
(811,'Thwackey','Grass',NULL,420,70,85,70,55,60,80,8),
(812,'Rillaboom','Grass',NULL,530,100,125,90,60,70,85,8),
(813,'Scorbunny','Fire',NULL,310,50,71,40,40,40,69,8),
(814,'Raboot','Fire',NULL,420,65,86,60,55,60,94,8),
(815,'Cinderace','Fire',NULL,530,80,116,75,65,75,119,8),
(816,'Sobble','Water',NULL,310,50,40,40,70,40,70,8),
(817,'Drizzile','Water',NULL,420,65,60,55,95,55,90,8),
(818,'Inteleon','Water',NULL,530,70,85,65,125,65,120,8),
(819,'Skwovet','Normal',NULL,275,70,55,55,35,35,25,8),
(820,'Greedent','Normal',NULL,460,120,95,95,55,75,20,8),
(821,'Rookidee','Flying',NULL,245,38,47,35,33,35,57,8),
(822,'Corvisquire','Flying',NULL,365,68,67,55,43,55,77,8),
(823,'Corviknight','Flying','Steel',495,98,87,105,53,85,67,8),
(824,'Blipbug','Bug',NULL,180,25,20,20,25,45,45,8),
(825,'Dottler','Bug','Psychic',335,50,35,80,50,90,30,8),
(826,'Orbeetle','Bug','Psychic',505,60,45,110,80,120,90,8),
(827,'Nickit','Dark',NULL,245,40,28,28,47,52,50,8),
(828,'Thievul','Dark',NULL,455,70,58,58,87,92,90,8),
(829,'Gossifleur','Grass',NULL,250,40,40,60,40,60,10,8),
(830,'Eldegoss','Grass',NULL,460,60,50,90,80,120,60,8),
(831,'Wooloo','Normal',NULL,270,42,40,55,40,45,48,8),
(832,'Dubwool','Normal',NULL,490,72,80,100,60,90,88,8),
(833,'Chewtle','Water',NULL,284,50,64,50,38,38,44,8),
(834,'Drednaw','Water','Rock',485,90,115,90,48,68,74,8),
(835,'Yamper','Electric',NULL,270,59,45,50,40,50,26,8),
(836,'Boltund','Electric',NULL,490,69,90,60,90,60,121,8),
(837,'Rolycoly','Rock',NULL,240,30,40,50,40,50,30,8),
(838,'Carkol','Rock','Fire',410,80,60,90,60,70,50,8),
(839,'Coalossal','Rock','Fire',510,110,80,120,80,90,30,8),
(840,'Applin','Grass','Dragon',260,40,40,80,40,40,20,8),
(841,'Flapple','Grass','Dragon',485,70,110,80,95,60,70,8),
(842,'Appletun','Grass','Dragon',485,110,85,80,100,80,30,8),
(843,'Silicobra','Ground',NULL,315,52,57,75,35,50,46,8),
(844,'Sandaconda','Ground',NULL,510,72,107,125,65,70,71,8),
(845,'Cramorant','Flying','Water',475,70,85,55,85,95,85,8),
(845.1,'Cramorant_Gulping_Form','Flying','Water',475,70,85,55,85,95,85,8),
(845.2,'Cramorant_Gorging_Form','Flying','Water',475,70,85,55,85,95,85,8),
(846,'Arrokuda','Water',NULL,280,41,63,40,40,30,66,8),
(847,'Barraskewda','Water',NULL,490,61,123,60,60,50,136,8),
(848,'Toxel','Electric','Poison',242,40,38,35,54,35,40,8),
(849,'Toxtricity_Amped_Form','Electric','Poison',502,75,98,70,114,70,75,8),
(849.1,'Toxtricity_Low_Key_Form','Electric','Poison',502,75,98,70,114,70,75,8),
(850,'Sizzlipede','Fire','Bug',305,50,65,45,50,50,45,8),
(851,'Centiskorch','Fire','Bug',525,100,115,65,90,90,65,8),
(852,'Clobbopus','Fighting',NULL,310,50,68,60,50,50,32,8),
(853,'Grapploct','Fighting',NULL,480,80,118,90,70,80,42,8),
(854,'Sinistea_Phony_Form','Ghost',NULL,308,40,45,45,74,54,50,8),
(854.1,'Sinistea_Antique_Form','Ghost',NULL,308,40,45,45,74,54,50,8),
(855,'Polteageist_Phony_Form','Ghost',NULL,508,60,65,65,134,114,70,8),
(855.1,'Polteageist_Antique_Form','Ghost',NULL,508,60,65,65,134,114,70,8),
(856,'Hatenna','Psychic',NULL,265,42,30,45,56,53,39,8),
(857,'Hattrem','Psychic',NULL,370,57,40,65,86,73,49,8),
(858,'Hatterene','Psychic','Fairy',510,57,90,95,136,103,29,8),
(859,'Impidimp','Dark','Fairy',265,45,45,30,55,40,50,8),
(860,'Morgrem','Dark','Fairy',370,65,60,45,75,55,70,8),
(861,'Grimmsnarl','Dark','Fairy',510,95,120,65,95,75,60,8),
(862,'Obstagoon','Dark','Normal',520,93,90,101,60,81,95,8),
(863,'Perrserker','Steel',NULL,440,70,110,100,50,60,50,8),
(864,'Cursola','Ghost',NULL,510,60,95,50,145,130,30,8),
(865,"Sirfetch'd",'Fighting',NULL,507,62,135,95,68,82,65,8),
(866,'Mr_Rime','Ice','Psychic',520,80,85,75,110,100,70,8),
(867,'Runerigus','Ground','Ghost',483,58,95,145,50,105,30,8),
(868,'Milcery','Fairy',NULL,270,45,40,40,50,61,34,8),
(869,'Alcremie_Vanilla_Cream','Fairy',NULL,495,65,60,75,110,121,64,8),
(869.1,'Alcremie_Ruby_Cream','Fairy',NULL,495,65,60,75,110,121,64,8),
(869.2,'Alcremie_Matcha_Cream','Fairy',NULL,495,65,60,75,110,121,64,8),
(869.3,'Alcremie_Mint_Cream','Fairy',NULL,495,65,60,75,110,121,64,8),
(869.4,'Alcremie_Lemon_Cream','Fairy',NULL,495,65,60,75,110,121,64,8),
(869.5,'Alcremie_Salted_Cream','Fairy',NULL,495,65,60,75,110,121,64,8),
(869.6,'Alcremie_Ruby_Swirl','Fairy',NULL,495,65,60,75,110,121,64,8),
(869.7,'Alcremie_Caramel_Swirl','Fairy',NULL,495,65,60,75,110,121,64,8),
(869.8,'Alcremie_Rainbow_Swirl','Fairy',NULL,495,65,60,75,110,121,64,8),
(870,'Falinks','Fighting',NULL,470,65,100,100,70,60,75,8),
(871,'Pincurchin','Electric',NULL,435,48,101,95,91,85,15,8),
(872,'Snom','Ice','Bug',185,30,25,35,45,30,20,8),
(873,'Frosmoth','Ice','Bug',475,70,65,60,125,90,65,8),
(874,'Stonjourner','Rock',NULL,470,100,125,135,20,20,70,8),
(875,'Eiscue_Ice_Face','Ice',NULL,470,75,80,110,65,90,50,8),
(875.1,'Eiscue_Noice_Face','Ice',NULL,470,75,80,70,65,50,130,8),
(876,'Indeedee♂','Psychic','Normal',475,60,65,55,105,95,95,8),
(876.1,'Indeedee♀','Psychic','Normal',475,70,55,65,95,105,85,8),
(877,'Morpeko_Full_Belly_Mode','Electric','Dark',436,58,95,58,70,58,97,8),
(877.1,'Morpeko_Hangry_Mode','Electric','Dark',436,58,95,58,70,58,97,8),
(878,'Cufant','Steel',NULL,330,72,80,49,40,49,40,8),
(879,'Copperajah','Steel',NULL,500,122,130,69,80,69,30,8),
(880,'Dracozolt','Electric','Dragon',505,90,100,90,80,70,75,8);
INSERT INTO pokemon(Number,Name,Type_1,Type_2,Total,HP,Attack,Defense,Sp_Atk,Sp_Def,Speed,Generation) VALUES
(881,'Arctozolt','Electric','Ice',505,90,100,90,90,80,55,8),
(882,'Dracovish','Water','Dragon',505,90,90,100,70,80,75,8),
(883,'Arctovish','Water','Ice',505,90,90,100,80,90,55,8),
(884,'Duraludon','Steel','Dragon',535,70,95,115,120,50,85,8),
(885,'Dreepy','Dragon','Ghost',270,28,60,30,40,30,82,8),
(886,'Drakloak','Dragon','Ghost',410,68,80,50,60,50,102,8),
(887,'Dragapult','Dragon','Ghost',600,88,120,75,100,75,142,8),
(888,'Zacian_Hero_of_Many_Battle','Fairy',NULL,660,92,120,115,80,115,138,8),
(888.1,'Zacian_Crowned_Sword','Fairy','Steel',700,92,150,115,80,115,148,8),
(889,'Zamazenta_Hero_of_Many_Battle','Fighting',NULL,660,92,120,115,80,115,138,8),
(889.1,'Zamazenta_Crowned_Shield','Fighting','Steel',700,92,120,140,80,140,128,8),
(890,'Eternatus','Poison','Dragon',690,140,85,95,145,95,130,8),
(890.1,'Eternatus_Eternamax','Poison','Dragon',1125,255,115,250,125,250,130,8),
(891,'Kubfu','Fighting',NULL,385,60,90,60,53,50,72,8),
(892,'Urshifu_Single_Strike_Style','Fighting','Dark',550,100,130,100,63,60,97,8),
(892.1,'Urshifu_Rapid_Strike_Style','Fighting','Water',550,100,130,100,63,60,97,8),
(893,'Zarude','Dark','Grass',600,105,120,105,70,95,105,8),
(893.1,'Zarude_Dada','Dark','Grass',600,105,120,105,70,95,105,8),
(894,'Regieleki','Electric',NULL,580,80,100,50,100,50,200,8),
(895,'Regidrago','Dragon',NULL,580,200,100,50,100,50,80,8),
(896,'Glastrier','Ice',NULL,580,100,145,130,65,110,30,8),
(897,'Spectrier','Ghost',NULL,580,100,65,60,145,80,130,8),
(898,'Calyrex','Psychic','Grass',500,100,80,80,80,80,80,8),
(898.1,'Calyrex_Ice_Rider','Psychic','Ice',680,100,165,150,85,130,50,8),
(898.2,'Calyrex_Shadow_Rider','Psychic','Ghost',680,100,85,80,165,100,150,8),
(899,'Wyrdeer','Normal','Psychic',525,103,105,72,105,75,65,8),
(900,'Kleavor','Bug','Rock',500,70,130,95,45,75,85,8),
(901,'Ursaluna','Ground','Normal',550,130,140,105,45,80,50,8),
(901.1,'Bloodmoon_Ursaluna','Ground','Normal',555,113,70,120,135,65,52,9),
(902,'Basculegion♂','Water','Ghost',530,120,112,65,80,75,78,8),
(902.1,'Basculegion♀','Water','Ghost',530,120,92,65,100,75,78,8),
(903,'Sneasler','Fighting','Poison',510,80,130,60,40,80,120,8),
(904,'Overqwil','Dark','Poison',510,85,115,95,65,65,85,8),
(905,'Enamorus_Incarnate_Forme','Fairy','Flying',580,74,115,70,135,80,106,8),
(905.1,'Enamorus_Therian_Forme','Fairy','Flying',580,74,115,110,135,100,46,8),
(906,'Sprigatito','Grass',NULL,310,40,61,54,45,45,65,9),
(907,'Floragato','Grass',NULL,410,61,80,63,60,63,83,9),
(908,'Meowscarada','Grass','Dark',530,76,110,70,81,70,123,9),
(909,'Fuecoco','Fire',NULL,310,67,45,59,63,40,36,9),
(910,'Crocalor','Fire',NULL,411,81,55,78,90,58,49,9),
(911,'Skeledirge','Fire','Ghost',530,104,75,100,110,75,66,9),
(912,'Quaxly','Water',NULL,310,55,65,45,50,45,50,9),
(913,'Quaxwell','Water',NULL,410,70,85,65,65,60,65,9),
(914,'Quaquaval','Water','Fighting',530,85,120,80,85,75,85,9),
(915,'Lechonk','Normal',NULL,254,54,45,40,35,45,35,9),
(916,'Oinkologne♂','Normal',NULL,489,110,100,75,59,80,65,9),
(916.1,'Oinkologne♀','Normal',NULL,489,115,90,70,59,90,65,9),
(917,'Tarountula','Bug',NULL,210,35,41,45,29,40,20,9),
(918,'Spidops','Bug',NULL,404,60,79,92,52,86,35,9),
(919,'Nymble','Bug',NULL,210,33,46,40,21,25,45,9),
(920,'Lokix','Bug','Dark',450,71,102,78,52,55,92,9),
(921,'Pawmi','Electric',NULL,240,45,50,20,40,25,60,9),
(922,'Pawmo','Electric','Fighting',350,60,75,40,50,40,85,9),
(923,'Pawmot','Electric','Fighting',490,70,115,70,70,60,105,9),
(924,'Tandemaus','Normal',NULL,305,50,50,45,40,45,75,9),
(925,'Maushold_Family_of_Four','Normal',NULL,470,74,75,70,65,75,111,9),
(925.1,'Maushold_Family_of_Three','Normal',NULL,470,74,75,70,65,75,111,9),
(926,'Fidough','Fairy',NULL,312,37,55,70,30,55,65,9),
(927,'Dachsbun','Fairy',NULL,477,57,80,115,50,80,95,9),
(928,'Smoliv','Grass','Normal',260,41,35,45,58,51,30,9),
(929,'Dolliv','Grass','Normal',354,52,53,60,78,78,33,9),
(930,'Arboliva','Grass','Normal',510,78,69,90,125,109,39,9),
(931,'Squawkabilly_Green_Plumage','Normal','Flying',417,82,96,51,45,51,92,9),
(931.1,'Squawkabilly_Blue_Plumage','Normal','Flying',417,82,96,51,45,51,92,9),
(931.2,'Squawkabilly_Yellow_Plumage','Normal','Flying',417,82,96,51,45,51,92,9),
(931.3,'Squawkabilly_White_Plumage','Normal','Flying',417,82,96,51,45,51,92,9),
(932,'Nacli','Rock',NULL,280,55,55,75,35,35,25,9),
(933,'Naclstack','Rock',NULL,355,60,60,100,35,65,35,9),
(934,'Garganacl','Rock',NULL,500,100,100,130,45,90,35,9),
(935,'Charcadet','Fire',NULL,255,40,50,40,50,40,35,9),
(936,'Armarouge','Fire','Psychic',525,85,60,100,125,80,75,9),
(937,'Ceruledge','Fire','Ghost',525,75,125,80,60,100,85,9),
(938,'Tadbulb','Electric',NULL,272,61,31,41,59,35,45,9),
(939,'Bellibolt','Electric',NULL,495,109,64,91,103,83,45,9),
(940,'Wattrel','Electric','Flying',280,40,40,35,55,40,70,9),
(941,'Kilowattrel','Electric','Flying',490,70,70,60,105,60,125,9),
(942,'Maschiff','Dark',NULL,340,60,78,60,40,51,51,9),
(943,'Mabosstiff','Dark',NULL,505,80,120,90,60,70,85,9),
(944,'Shroodle','Poison','Normal',290,40,65,35,40,35,75,9),
(945,'Grafaiai','Poison','Normal',485,63,95,65,80,72,110,9),
(946,'Bramblin','Grass','Ghost',275,40,65,30,45,35,60,9),
(947,'Brambleghast','Grass','Ghost',480,55,115,70,80,70,90,9),
(948,'Toedscool','Ground','Grass',335,40,40,35,50,100,70,9),
(949,'Toedscruel','Ground','Grass',515,80,70,65,80,120,100,9),
(950,'Klawf','Rock',NULL,450,70,100,115,35,55,75,9),
(951,'Capsakid','Grass',NULL,304,50,62,40,62,40,50,9),
(952,'Scovillain','Grass','Fire',486,65,108,65,108,65,75,9),
(953,'Rellor','Bug',NULL,270,41,50,60,31,58,30,9),
(954,'Rabsca','Bug','Psychic',470,75,50,85,115,100,45,9),
(955,'Flittle','Psychic',NULL,255,30,35,30,55,30,75,9),
(956,'Espathra','Psychic',NULL,481,95,60,60,101,60,105,9),
(957,'Tinkatink','Fairy','Steel',297,50,45,45,35,64,58,9),
(958,'Tinkatuff','Fairy','Steel',380,65,55,55,45,82,78,9),
(959,'Tinkaton','Fairy','Steel',506,85,75,77,70,105,94,9),
(960,'Wiglett','Water',NULL,245,10,55,25,35,25,95,9),
(961,'Wugtrio','Water',NULL,425,35,100,50,50,70,120,9),
(962,'Bombirdier','Flying','Dark',485,70,103,85,60,85,82,9),
(963,'Finizen','Water',NULL,315,70,45,40,45,40,75,9),
(964,'Palafin_Zero_Form','Water',NULL,457,100,70,72,53,62,100,9),
(964.1,'Palafin_Hero_Form','Water',NULL,650,100,160,97,106,87,100,9),
(965,'Varoom','Steel','Poison',300,45,70,63,30,45,47,9),
(966,'Revavroom','Steel','Poison',500,80,119,90,54,67,90,9),
(967,'Cyclizar','Dragon',NULL,501,70,95,65,85,65,121,9),
(968,'Orthworm','Steel',NULL,480,70,85,145,60,55,65,9),
(969,'Glimmet','Rock','Poison',350,48,35,42,105,60,60,9),
(970,'Glimmora','Rock','Poison',525,83,55,90,130,81,86,9),
(971,'Greavard','Ghost',NULL,290,50,61,60,30,55,34,9),
(972,'Houndstone','Ghost',NULL,488,72,101,100,50,97,68,9),
(973,'Flamigo','Flying','Fighting',500,82,115,74,75,64,90,9),
(974,'Cetoddle','Ice',NULL,334,108,68,45,30,40,43,9),
(975,'Cetitan','Ice',NULL,521,170,113,65,45,55,73,9),
(976,'Veluza','Water','Psychic',478,90,102,73,78,65,70,9),
(977,'Dondozo','Water',NULL,530,150,100,115,65,65,35,9),
(978,'Tatsugiri_Curly_Form','Dragon','Water',475,68,50,60,120,95,82,9),
(978.1,'Tatsugiri_Droopy_Form','Dragon','Water',475,68,50,60,120,95,82,9),
(978.2,'Tatsugiri_Stretchy_Form','Dragon','Water',475,68,50,60,120,95,82,9),
(979,'Annihilape','Fighting','Ghost',535,110,115,80,50,90,90,9),
(980,'Clodsire','Poison','Ground',430,130,75,60,45,100,20,9),
(981,'Farigiraf','Normal','Psychic',520,120,90,70,110,70,60,9),
(982,'Dudunsparce_Two_Segment_Form','Normal',NULL,520,125,100,80,85,75,55,9),
(982.1,'Dudunsparce_Three_Segment_Form','Normal',NULL,520,125,100,80,85,75,55,9),
(983,'Kingambit','Dark','Steel',550,100,135,120,60,85,50,9),
(984,'Great_Tusk','Ground','Fighting',570,115,131,131,53,53,87,9),
(985,'Scream_Tail','Fairy','Psychic',570,115,65,99,65,115,111,9),
(986,'Brute_Bonnet','Grass','Dark',570,111,127,99,79,99,55,9),
(987,'Flutter_Mane','Ghost','Fairy',570,55,55,55,135,135,135,9),
(988,'Slither_Wing','Bug','Fighting',570,85,135,79,85,105,81,9),
(989,'Sandy_Shocks','Electric','Ground',570,85,81,97,121,85,101,9),
(990,'Iron_Treads','Ground','Steel',570,90,112,120,72,70,106,9),
(991,'Iron_Bundle','Ice','Water',570,56,80,114,124,60,136,9),
(992,'Iron_Hands','Fighting','Electric',570,154,140,108,50,68,50,9),
(993,'Iron_Jugulis','Dark','Flying',570,94,80,86,122,80,108,9),
(994,'Iron_Moth','Fire','Poison',570,80,70,60,140,110,110,9),
(995,'Iron_Thorns','Rock','Electric',570,100,134,110,70,84,72,9),
(996,'Frigibax','Dragon','Ice',320,65,75,45,35,45,55,9),
(997,'Arctibax','Dragon','Ice',423,90,95,66,45,65,62,9),
(998,'Baxcalibur','Dragon','Ice',600,115,145,92,75,86,87,9),
(999,'Gimmighoul_Chest_Form','Ghost',NULL,300,45,30,70,75,70,10,9),
(999.1,'Gimmighoul_Roaming_Form','Ghost',NULL,300,45,30,25,75,45,80,9),
(1000,'Gholdengo','Steel','Ghost',550,87,60,95,133,91,84,9),
(1001,'Wo_Chien','Dark','Grass',570,85,85,100,95,135,70,9),
(1002,'Chien_Pao','Dark','Ice',570,80,120,80,90,65,135,9),
(1003,'Ting_Lu','Dark','Ground',570,155,110,125,55,80,45,9),
(1004,'Chi_Yu','Dark','Fire',570,55,80,80,135,120,100,9),
(1005,'Roaring_Moon','Dragon','Dark',590,105,139,71,55,101,119,9),
(1006,'Iron_Valiant','Fairy','Fighting',590,74,130,90,120,60,116,9),
(1007,'Koraidon','Fighting','Dragon',670,100,135,115,85,100,135,9),
(1008,'Miraidon','Electric','Dragon',670,100,85,100,135,115,135,9),
(1009,'Walking_Wake','Water','Dragon',590,99,83,91,125,83,109,9),
(1010,'Iron_Leaves','Grass','Psychic',590,90,130,88,70,108,104,9),
(1011,'Dipplin','Grass','Dragon',485,80,80,110,95,80,40,9),
(1012,'Poltchageist_Counterfeit_Form','Grass','Ghost',308,40,45,45,74,54,50,9),
(1012.1,'Poltchageist_Artisan_Form','Grass','Ghost',308,40,45,45,74,54,50,9),
(1013,'Sinistcha_Unremarkable_Form','Grass','Ghost',508,77,60,106,121,80,70,9),
(1013.1,'Sinistcha_Masterpiece_Form','Grass','Ghost',508,77,60,106,121,80,70,9),
(1014,'Okidogi','Poison','Fighting',555,88,128,115,58,86,80,9),
(1015,'Munkidori','Poison','Psychic',555,88,75,66,130,90,106,9),
(1016,'Fezandipiti','Poison','Fairy',555,88,91,82,70,125,99,9),
(1017,'Ogerpon_Teal_Mask','Grass',NULL,550,80,120,84,60,96,110,9),
(1017.1,'Ogerpon_Wellspring_Mask','Grass','Water',550,80,120,84,60,96,110,9),
(1017.2,'Ogerpon_Hearthflame_Mask','Grass','Fire',550,80,120,84,60,96,110,9),
(1017.3,'Ogerpon_Cornerstone_Mask','Grass','Rock',550,80,120,84,60,96,110,9),
(1018,'Archaludon','Steel','Dragon',600,90,105,130,125,65,85,9),
(1019,'Hydrapple','Grass','Dragon',540,106,80,110,120,80,44,9),
(1020,'Gouging_Fire','Fire','Dragon',590,105,115,121,65,93,91,9),
(1021,'Raging_Bolt','Electric','Dragon',590,125,73,91,137,89,75,9),
(1022,'Iron_Boulder','Rock','Psychic',590,90,120,80,68,108,124,9),
(1023,'Iron_Crown','Steel','Psychic',590,90,72,100,122,108,98,9),
(1024,'Terapagos_Normal_Form','Normal',NULL,450,90,65,85,65,85,60,9),
(1024.1,'Terapagos_Terastal_Form','Normal',NULL,600,95,95,110,105,110,85,9),
(1024.2,'Terapagos_Stellar_Form','Normal',NULL,700,160,105,110,130,110,85,9),
(1025,'Pecharunt','Poison','Ghost',600,88,88,160,88,88,88,9);