ecossistema_dontpad.org

Ecossistema Hadoop - dontpad

Iniciando serviços

sudo service hadoop-hdfs-namenode start
sudo service hadoop-hdfs-secondarynamenode start
sudo service hadoop-hdfs-datanode start
sudo service hadoop-yarn-nodemanager start
sudo service hadoop-yarn-resourcemanager start
sudo service hadoop-mapreduce-historyserver start
sudo service zookeeper-server start

Sqoop

sh install_sqoop.sh
mysql -u root -h localhost -pEveris@2021 < pokemon.sql

sh sqoop_import.sh
hdfs dfs -text /user/everis-bigdata/pokemon/*.gz |more

hdfs dfs- cat /user/everis-bigdata/pokemon/1/*

sudo yum install --assumeyes sqoop
cd /tmp
wget http://www.java2s.com/Code/JarDownload/java-json/java-json.jar.zip
unzip /tmp/java-json.jar.zip
sudo mv /tmp/java-json.jar /usr/lib/sqoop/lib/
sudo chown root: /usr/lib/sqoop/lib/java-json.jar
sqoop-version

Importando dados do SQL

sudo -u hdfs hdfs dfs -rm -R /user/everis-bigdata/pokemon

sudo -u hdfs sqoop import \
--connect jdbc:mysql://localhost/trainning \
--username root --password "Everis@2021" \
--fields-terminated-by "|" \
--split-by Generation \
--target-dir /user/everis-bigdata/pokemon \
--query 'SELECT * FROM pokemon WHERE $CONDITIONS' \
--where 'Number IS NOT NULL' \
--compress \
--num-mappers 4

SQL

Criando tabela de Pokémon

DROP DATABASE IF EXISTS trainning;
CREATE DATABASE trainning;

CREATE TABLE trainning.pokemon (
Number SMALLINT,
Name VARCHAR(100),
Type1 VARCHAR(100),
Type2 VARCHAR(100),
HP SMALLINT,
Attack SMALLINT,
Defense SMALLINT,
SpAtk SMALLINT,
SpDef SMALLINT,
Speed SMALLINT,
Generation TINYINT,
Legendary BOOLEAN,
PRIMARY KEY (Number)
);

INSERT INTO trainning.pokemon
VALUES
(1,'Bulbasaur','Grass','Poison',45,49,49,65,65,45,1,false),
(2,'Ivysaur','Grass','Poison',60,62,63,80,80,60,1,false),
(3,'Venusaur','Grass','Poison',80,82,83,100,100,80,1,false),
(4,'Mega Venusaur','Grass','Poison',80,100,123,122,120,80,1,false),
(5,'Charmander','Fire','',39,52,43,60,50,65,1,false),
(6,'Charmeleon','Fire','',58,64,58,80,65,80,1,false),
(7,'Charizard','Fire','Flying',78,84,78,109,85,100,1,false),
(8,'Mega Charizard X','Fire','Dragon',78,130,111,130,85,100,1,false),
(9,'Mega Charizard Y','Fire','Flying',78,104,78,159,115,100,1,false),
(10,'Squirtle','Water','',44,48,65,50,64,43,1,false),
(11,'Wartortle','Water','',59,63,80,65,80,58,1,false),
(12,'Blastoise','Water','',79,83,100,85,105,78,1,false),
(13,'Mega Blastoise','Water','',79,103,120,135,115,78,1,false),
(14,'Caterpie','Bug','',45,30,35,20,20,45,1,false),
(15,'Metapod','Bug','',50,20,55,25,25,30,1,false),
(16,'Butterfree','Bug','Flying',60,45,50,90,80,70,1,false),
(17,'Weedle','Bug','Poison',40,35,30,20,20,50,1,false),
(18,'Kakuna','Bug','Poison',45,25,50,25,25,35,1,false),
(19,'Beedrill','Bug','Poison',65,90,40,45,80,75,1,false),
(20,'Mega Beedrill','Bug','Poison',65,150,40,15,80,145,1,false),
(21,'Pidgey','Normal','Flying',40,45,40,35,35,56,1,false),
(22,'Pidgeotto','Normal','Flying',63,60,55,50,50,71,1,false),
(23,'Pidgeot','Normal','Flying',83,80,75,70,70,101,1,false),
(24,'Mega Pidgeot','Normal','Flying',83,80,80,135,80,121,1,false),
(25,'Rattata','Normal','',30,56,35,25,35,72,1,false),
(26,'Raticate','Normal','',55,81,60,50,70,97,1,false),
(27,'Spearow','Normal','Flying',40,60,30,31,31,70,1,false),
(28,'Fearow','Normal','Flying',65,90,65,61,61,100,1,false),
(29,'Ekans','Poison','',35,60,44,40,54,55,1,false),
(30,'Arbok','Poison','',60,85,69,65,79,80,1,false),
(31,'Pikachu','Electric','',35,55,40,50,50,90,1,false),
(32,'Raichu','Electric','',60,90,55,90,80,110,1,false),
(33,'Sandshrew','Ground','',50,75,85,20,30,40,1,false),
(34,'Sandslash','Ground','',75,100,110,45,55,65,1,false),
(35,'Nidoran male','Poison','',55,47,52,40,40,41,1,false),
(36,'Nidorina','Poison','',70,62,67,55,55,56,1,false),
(37,'Nidoqueen','Poison','Ground',90,92,87,75,85,76,1,false),
(38,'Nidoran female‚','Poison','',46,57,40,40,40,50,1,false),
(39,'Nidorino','Poison','',61,72,57,55,55,65,1,false),
(40,'Nidoking','Poison','Ground',81,102,77,85,75,85,1,false),
(41,'Clefairy','Fairy','',70,45,48,60,65,35,1,false),
(42,'Clefable','Fairy','',95,70,73,95,90,60,1,false),
(43,'Vulpix','Fire','',38,41,40,50,65,65,1,false),
(44,'Ninetales','Fire','',73,76,75,81,100,100,1,false),
(45,'Jigglypuff','Normal','Fairy',115,45,20,45,25,20,1,false),
(46,'Wigglytuff','Normal','Fairy',140,70,45,85,50,45,1,false),
(47,'Zubat','Poison','Flying',40,45,35,30,40,55,1,false),
(48,'Golbat','Poison','Flying',75,80,70,65,75,90,1,false),
(49,'Oddish','Grass','Poison',45,50,55,75,65,30,1,false),
(50,'Gloom','Grass','Poison',60,65,70,85,75,40,1,false),
(51,'Vileplume','Grass','Poison',75,80,85,110,90,50,1,false),
(52,'Paras','Bug','Grass',35,70,55,45,55,25,1,false),
(53,'Parasect','Bug','Grass',60,95,80,60,80,30,1,false),
(54,'Venonat','Bug','Poison',60,55,50,40,55,45,1,false),
(55,'Venomoth','Bug','Poison',70,65,60,90,75,90,1,false),
(56,'Diglett','Ground','',10,55,25,35,45,95,1,false),
(57,'Dugtrio','Ground','',35,80,50,50,70,120,1,false),
(58,'Meowth','Normal','',40,45,35,40,40,90,1,false),
(59,'Persian','Normal','',65,70,60,65,65,115,1,false),
(60,'Psyduck','Water','',50,52,48,65,50,55,1,false),
(61,'Golduck','Water','',80,82,78,95,80,85,1,false),
(62,'Mankey','Fighting','',40,80,35,35,45,70,1,false),
(63,'Primeape','Fighting','',65,105,60,60,70,95,1,false),
(64,'Growlithe','Fire','',55,70,45,70,50,60,1,false),
(65,'Arcanine','Fire','',90,110,80,100,80,95,1,false),
(66,'Poliwag','Water','',40,50,40,40,40,90,1,false),
(67,'Poliwhirl','Water','',65,65,65,50,50,90,1,false),
(68,'Poliwrath','Water','Fighting',90,95,95,70,90,70,1,false),
(69,'Abra','Psychic','',25,20,15,105,55,90,1,false),
(70,'Kadabra','Psychic','',40,35,30,120,70,105,1,false),
(71,'Alakazam','Psychic','',55,50,45,135,95,120,1,false),
(72,'Mega Alakazam','Psychic','',55,50,65,175,95,150,1,false),
(73,'Machop','Fighting','',70,80,50,35,35,35,1,false),
(74,'Machoke','Fighting','',80,100,70,50,60,45,1,false),
(75,'Machamp','Fighting','',90,130,80,65,85,55,1,false),
(76,'Bellsprout','Grass','Poison',50,75,35,70,30,40,1,false),
(77,'Weepinbell','Grass','Poison',65,90,50,85,45,55,1,false),
(78,'Victreebel','Grass','Poison',80,105,65,100,70,70,1,false),
(79,'Tentacool','Water','Poison',40,40,35,50,100,70,1,false),
(80,'Tentacruel','Water','Poison',80,70,65,80,120,100,1,false),
(81,'Geodude','Rock','Ground',40,80,100,30,30,20,1,false),
(82,'Graveler','Rock','Ground',55,95,115,45,45,35,1,false),
(83,'Golem','Rock','Ground',80,120,130,55,65,45,1,false),
(84,'Ponyta','Fire','',50,85,55,65,65,90,1,false),
(85,'Rapidash','Fire','',65,100,70,80,80,105,1,false),
(86,'Slowpoke','Water','Psychic',90,65,65,40,40,15,1,false),
(87,'Slowbro','Water','Psychic',95,75,110,100,80,30,1,false),
(88,'Mega Slowbro','Water','Psychic',95,75,180,130,80,30,1,false),
(89,'Magnemite','Electric','Steel',25,35,70,95,55,45,1,false),
(90,'Magneton','Electric','Steel',50,60,95,120,70,70,1,false),
(91,'Farfetchd','Normal','Flying',52,65,55,58,62,60,1,false),
(92,'Doduo','Normal','Flying',35,85,45,35,35,75,1,false),
(93,'Dodrio','Normal','Flying',60,110,70,60,60,100,1,false),
(94,'Seel','Water','',65,45,55,45,70,45,1,false),
(95,'Dewgong','Water','Ice',90,70,80,70,95,70,1,false),
(96,'Grimer','Poison','',80,80,50,40,50,25,1,false),
(97,'Muk','Poison','',105,105,75,65,100,50,1,false),
(98,'Shellder','Water','',30,65,100,45,25,40,1,false),
(99,'Cloyster','Water','Ice',50,95,180,85,45,70,1,false),
(100,'Gastly','Ghost','Poison',30,35,30,100,35,80,1,false),
(101,'Haunter','Ghost','Poison',45,50,45,115,55,95,1,false),
(102,'Gengar','Ghost','Poison',60,65,60,130,75,110,1,false),
(103,'Mega Gengar','Ghost','Poison',60,65,80,170,95,130,1,false),
(104,'Onix','Rock','Ground',35,45,160,30,45,70,1,false),
(105,'Drowzee','Psychic','',60,48,45,43,90,42,1,false),
(106,'Hypno','Psychic','',85,73,70,73,115,67,1,false),
(107,'Krabby','Water','',30,105,90,25,25,50,1,false),
(108,'Kingler','Water','',55,130,115,50,50,75,1,false),
(109,'Voltorb','Electric','',40,30,50,55,55,100,1,false),
(110,'Electrode','Electric','',60,50,70,80,80,140,1,false),
(111,'Exeggcute','Grass','Psychic',60,40,80,60,45,40,1,false),
(112,'Exeggutor','Grass','Psychic',95,95,85,125,65,55,1,false),
(113,'Cubone','Ground','',50,50,95,40,50,35,1,false),
(114,'Marowak','Ground','',60,80,110,50,80,45,1,false),
(115,'Hitmonlee','Fighting','',50,120,53,35,110,87,1,false),
(116,'Hitmonchan','Fighting','',50,105,79,35,110,76,1,false),
(117,'Lickitung','Normal','',90,55,75,60,75,30,1,false),
(118,'Koffing','Poison','',40,65,95,60,45,35,1,false),
(119,'Weezing','Poison','',65,90,120,85,70,60,1,false),
(120,'Rhyhorn','Ground','Rock',80,85,95,30,30,25,1,false),
(121,'Rhydon','Ground','Rock',105,130,120,45,45,40,1,false),
(122,'Chansey','Normal','',250,5,5,35,105,50,1,false),
(123,'Tangela','Grass','',65,55,115,100,40,60,1,false),
(124,'Kangaskhan','Normal','',105,95,80,40,80,90,1,false),
(125,'Mega Kangaskhan','Normal','',105,125,100,60,100,100,1,false),
(126,'Horsea','Water','',30,40,70,70,25,60,1,false),
(127,'Seadra','Water','',55,65,95,95,45,85,1,false),
(128,'Goldeen','Water','',45,67,60,35,50,63,1,false),
(129,'Seaking','Water','',80,92,65,65,80,68,1,false),
(130,'Staryu','Water','',30,45,55,70,55,85,1,false),
(131,'Starmie','Water','Psychic',60,75,85,100,85,115,1,false),
(132,'Mr. Mime','Psychic','Fairy',40,45,65,100,120,90,1,false),
(133,'Scyther','Bug','Flying',70,110,80,55,80,105,1,false),
(134,'Jynx','Ice','Psychic',65,50,35,115,95,95,1,false),
(135,'Electabuzz','Electric','',65,83,57,95,85,105,1,false),
(136,'Magmar','Fire','',65,95,57,100,85,93,1,false),
(137,'Pinsir','Bug','',65,125,100,55,70,85,1,false),
(138,'Mega Pinsir','Bug','Flying',65,155,120,65,90,105,1,false),
(139,'Tauros','Normal','',75,100,95,40,70,110,1,false),
(140,'Magikarp','Water','',20,10,55,15,20,80,1,false),
(141,'Gyarados','Water','Flying',95,125,79,60,100,81,1,false),
(142,'Mega Gyarados','Water','Dark',95,155,109,70,130,81,1,false),
(143,'Lapras','Water','Ice',130,85,80,85,95,60,1,false),
(144,'Ditto','Normal','',48,48,48,48,48,48,1,false),
(145,'Eevee','Normal','',55,55,50,45,65,55,1,false),
(146,'Vaporeon','Water','',130,65,60,110,95,65,1,false),
(147,'Jolteon','Electric','',65,65,60,110,95,130,1,false),
(148,'Flareon','Fire','',65,130,60,95,110,65,1,false),
(149,'Porygon','Normal','',65,60,70,85,75,40,1,false),
(150,'Omanyte','Rock','Water',35,40,100,90,55,35,1,false),
(151,'Omastar','Rock','Water',70,60,125,115,70,55,1,false),
(152,'Kabuto','Rock','Water',30,80,90,55,45,55,1,false),
(153,'Kabutops','Rock','Water',60,115,105,65,70,80,1,false),
(154,'Aerodactyl','Rock','Flying',80,105,65,60,75,130,1,false),
(155,'Mega Aerodactyl','Rock','Flying',80,135,85,70,95,150,1,false),
(156,'Snorlax','Normal','',160,110,65,65,110,30,1,false),
(157,'Articuno','Ice','Flying',90,85,100,95,125,85,1,true),
(158,'Zapdos','Electric','Flying',90,90,85,125,90,100,1,true),
(159,'Moltres','Fire','Flying',90,100,90,125,85,90,1,true),
(160,'Dratini','Dragon','',41,64,45,50,50,50,1,false),
(161,'Dragonair','Dragon','',61,84,65,70,70,70,1,false),
(162,'Dragonite','Dragon','Flying',91,134,95,100,100,80,1,false),
(163,'Mewtwo','Psychic','',106,110,90,154,90,130,1,true),
(164,'Mega Mewtwo X','Psychic','Fighting',106,190,100,154,100,130,1,true),
(165,'Mega Mewtwo Y','Psychic','',106,150,70,194,120,140,1,true),
(166,'Mew','Psychic','',100,100,100,100,100,100,1,false),
(167,'Chikorita','Grass','',45,49,65,49,65,45,2,false),
(168,'Bayleef','Grass','',60,62,80,63,80,60,2,false),
(169,'Meganium','Grass','',80,82,100,83,100,80,2,false),
(170,'Cyndaquil','Fire','',39,52,43,60,50,65,2,false),
(171,'Quilava','Fire','',58,64,58,80,65,80,2,false),
(172,'Typhlosion','Fire','',78,84,78,109,85,100,2,false),
(173,'Totodile','Water','',50,65,64,44,48,43,2,false),
(174,'Croconaw','Water','',65,80,80,59,63,58,2,false),
(175,'Feraligatr','Water','',85,105,100,79,83,78,2,false),
(176,'Sentret','Normal','',35,46,34,35,45,20,2,false),
(177,'Furret','Normal','',85,76,64,45,55,90,2,false),
(178,'Hoothoot','Normal','Flying',60,30,30,36,56,50,2,false),
(179,'Noctowl','Normal','Flying',100,50,50,76,96,70,2,false),
(180,'Ledyba','Bug','Flying',40,20,30,40,80,55,2,false),
(181,'Ledian','Bug','Flying',55,35,50,55,110,85,2,false),
(182,'Spinarak','Bug','Poison',40,60,40,40,40,30,2,false),
(183,'Ariados','Bug','Poison',70,90,70,60,60,40,2,false),
(184,'Crobat','Poison','Flying',85,90,80,70,80,130,2,false),
(185,'Chinchou','Water','Electric',75,38,38,56,56,67,2,false),
(186,'Lanturn','Water','Electric',125,58,58,76,76,67,2,false),
(187,'Pichu','Electric','',20,40,15,35,35,60,2,false),
(188,'Cleffa','Fairy','',50,25,28,45,55,15,2,false),
(189,'Igglybuff','Normal','Fairy',90,30,15,40,20,15,2,false),
(190,'Togepi','Fairy','',35,20,65,40,65,20,2,false),
(191,'Togetic','Fairy','Flying',55,40,85,80,105,40,2,false),
(192,'Natu','Psychic','Flying',40,50,45,70,45,70,2,false),
(193,'Xatu','Psychic','Flying',65,75,70,95,70,95,2,false),
(194,'Mareep','Electric','',55,40,40,65,45,35,2,false),
(195,'Flaaffy','Electric','',70,55,55,80,60,45,2,false),
(196,'Ampharos','Electric','',90,75,85,115,90,55,2,false),
(197,'Mega Ampharos','Electric','Dragon',90,95,105,165,110,45,2,false),
(198,'Bellossom','Grass','',75,80,95,90,100,50,2,false),
(199,'Marill','Water','Fairy',70,20,50,20,50,40,2,false),
(200,'Azumarill','Water','Fairy',100,50,80,60,80,50,2,false),
(201,'Sudowoodo','Rock','',70,100,115,30,65,30,2,false),
(202,'Politoed','Water','',90,75,75,90,100,70,2,false),
(203,'Hoppip','Grass','Flying',35,35,40,35,55,50,2,false),
(204,'Skiploom','Grass','Flying',55,45,50,45,65,80,2,false),
(205,'Jumpluff','Grass','Flying',75,55,70,55,95,110,2,false),
(206,'Aipom','Normal','',55,70,55,40,55,85,2,false),
(207,'Sunkern','Grass','',30,30,30,30,30,30,2,false),
(208,'Sunflora','Grass','',75,75,55,105,85,30,2,false),
(209,'Yanma','Bug','Flying',65,65,45,75,45,95,2,false),
(210,'Wooper','Water','Ground',55,45,45,25,25,15,2,false),
(211,'Quagsire','Water','Ground',95,85,85,65,65,35,2,false),
(212,'Espeon','Psychic','',65,65,60,130,95,110,2,false),
(213,'Umbreon','Dark','',95,65,110,60,130,65,2,false),
(214,'Murkrow','Dark','Flying',60,85,42,85,42,91,2,false),
(215,'Slowking','Water','Psychic',95,75,80,100,110,30,2,false),
(216,'Misdreavus','Ghost','',60,60,60,85,85,85,2,false),
(217,'Unown','Psychic','',48,72,48,72,48,48,2,false),
(218,'Wobbuffet','Psychic','',190,33,58,33,58,33,2,false),
(219,'Girafarig','Normal','Psychic',70,80,65,90,65,85,2,false),
(220,'Pineco','Bug','',50,65,90,35,35,15,2,false),
(221,'Forretress','Bug','Steel',75,90,140,60,60,40,2,false),
(222,'Dunsparce','Normal','',100,70,70,65,65,45,2,false),
(223,'Gligar','Ground','Flying',65,75,105,35,65,85,2,false),
(224,'Steelix','Steel','Ground',75,85,200,55,65,30,2,false),
(225,'Mega Steelix','Steel','Ground',75,125,230,55,95,30,2,false),
(226,'Snubbull','Fairy','',60,80,50,40,40,30,2,false),
(227,'Granbull','Fairy','',90,120,75,60,60,45,2,false),
(228,'Qwilfish','Water','Poison',65,95,75,55,55,85,2,false),
(229,'Scizor','Bug','Steel',70,130,100,55,80,65,2,false),
(230,'Mega Scizor','Bug','Steel',70,150,140,65,100,75,2,false),
(231,'Shuckle','Bug','Rock',20,10,230,10,230,5,2,false),
(232,'Heracross','Bug','Fighting',80,125,75,40,95,85,2,false),
(233,'Mega Heracross','Bug','Fighting',80,185,115,40,105,75,2,false),
(234,'Sneasel','Dark','Ice',55,95,55,35,75,115,2,false),
(235,'Teddiursa','Normal','',60,80,50,50,50,40,2,false),
(236,'Ursaring','Normal','',90,130,75,75,75,55,2,false),
(237,'Slugma','Fire','',40,40,40,70,40,20,2,false),
(238,'Magcargo','Fire','Rock',50,50,120,80,80,30,2,false),
(239,'Swinub','Ice','Ground',50,50,40,30,30,50,2,false),
(240,'Piloswine','Ice','Ground',100,100,80,60,60,50,2,false),
(241,'Corsola','Water','Rock',55,55,85,65,85,35,2,false),
(242,'Remoraid','Water','',35,65,35,65,35,65,2,false),
(243,'Octillery','Water','',75,105,75,105,75,45,2,false),
(244,'Delibird','Ice','Flying',45,55,45,65,45,75,2,false),
(245,'Mantine','Water','Flying',65,40,70,80,140,70,2,false),
(246,'Skarmory','Steel','Flying',65,80,140,40,70,70,2,false),
(247,'Houndour','Dark','Fire',45,60,30,80,50,65,2,false),
(248,'Houndoom','Dark','Fire',75,90,50,110,80,95,2,false),
(249,'Mega Houndoom','Dark','Fire',75,90,90,140,90,115,2,false),
(250,'Kingdra','Water','Dragon',75,95,95,95,95,85,2,false),
(251,'Phanpy','Ground','',90,60,60,40,40,40,2,false),
(252,'Donphan','Ground','',90,120,120,60,60,50,2,false),
(253,'Porygon2','Normal','',85,80,90,105,95,60,2,false),
(254,'Stantler','Normal','',73,95,62,85,65,85,2,false),
(255,'Smeargle','Normal','',55,20,35,20,45,75,2,false),
(256,'Tyrogue','Fighting','',35,35,35,35,35,35,2,false),
(257,'Hitmontop','Fighting','',50,95,95,35,110,70,2,false),
(258,'Smoochum','Ice','Psychic',45,30,15,85,65,65,2,false),
(259,'Elekid','Electric','',45,63,37,65,55,95,2,false),
(260,'Magby','Fire','',45,75,37,70,55,83,2,false),
(261,'Miltank','Normal','',95,80,105,40,70,100,2,false),
(262,'Blissey','Normal','',255,10,10,75,135,55,2,false),
(263,'Raikou','Electric','',90,85,75,115,100,115,2,true),
(264,'Entei','Fire','',115,115,85,90,75,100,2,true),
(265,'Suicune','Water','',100,75,115,90,115,85,2,true),
(266,'Larvitar','Rock','Ground',50,64,50,45,50,41,2,false),
(267,'Pupitar','Rock','Ground',70,84,70,65,70,51,2,false),
(268,'Tyranitar','Rock','Dark',100,134,110,95,100,61,2,false),
(269,'Mega Tyranitar','Rock','Dark',100,164,150,95,120,71,2,false),
(270,'Lugia','Psychic','Flying',106,90,130,90,154,110,2,true),
(271,'Ho-oh','Fire','Flying',106,130,90,110,154,90,2,true),
(272,'Celebi','Psychic','Grass',100,100,100,100,100,100,2,false),
(273,'Treecko','Grass','',40,45,35,65,55,70,3,false),
(274,'Grovyle','Grass','',50,65,45,85,65,95,3,false),
(275,'Sceptile','Grass','',70,85,65,105,85,120,3,false),
(276,'Mega Sceptile','Grass','Dragon',70,110,75,145,85,145,3,false),
(277,'Torchic','Fire','',45,60,40,70,50,45,3,false),
(278,'Combusken','Fire','Fighting',60,85,60,85,60,55,3,false),
(279,'Blaziken','Fire','Fighting',80,120,70,110,70,80,3,false),
(280,'Mega Blaziken','Fire','Fighting',80,160,80,130,80,100,3,false),
(281,'Mudkip','Water','',50,70,50,50,50,40,3,false),
(282,'Marshtomp','Water','Ground',70,85,70,60,70,50,3,false),
(283,'Swampert','Water','Ground',100,110,90,85,90,60,3,false),
(284,'Mega Swampert','Water','Ground',100,150,110,95,110,70,3,false),
(285,'Poochyena','Dark','',35,55,35,30,30,35,3,false),
(286,'Mightyena','Dark','',70,90,70,60,60,70,3,false),
(287,'Zigzagoon','Normal','',38,30,41,30,41,60,3,false),
(288,'Linoone','Normal','',78,70,61,50,61,100,3,false),
(289,'Wurmple','Bug','',45,45,35,20,30,20,3,false),
(290,'Silcoon','Bug','',50,35,55,25,25,15,3,false),
(291,'Beautifly','Bug','Flying',60,70,50,100,50,65,3,false),
(292,'Cascoon','Bug','',50,35,55,25,25,15,3,false),
(293,'Dustox','Bug','Poison',60,50,70,50,90,65,3,false),
(294,'Lotad','Water','Grass',40,30,30,40,50,30,3,false),
(295,'Lombre','Water','Grass',60,50,50,60,70,50,3,false),
(296,'Ludicolo','Water','Grass',80,70,70,90,100,70,3,false),
(297,'Seedot','Grass','',40,40,50,30,30,30,3,false),
(298,'Nuzleaf','Grass','Dark',70,70,40,60,40,60,3,false),
(299,'Shiftry','Grass','Dark',90,100,60,90,60,80,3,false),
(300,'Taillow','Normal','Flying',40,55,30,30,30,85,3,false),
(301,'Swellow','Normal','Flying',60,85,60,50,50,125,3,false),
(302,'Wingull','Water','Flying',40,30,30,55,30,85,3,false),
(303,'Pelipper','Water','Flying',60,50,100,85,70,65,3,false),
(304,'Ralts','Psychic','Fairy',28,25,25,45,35,40,3,false),
(305,'Kirlia','Psychic','Fairy',38,35,35,65,55,50,3,false),
(306,'Gardevoir','Psychic','Fairy',68,65,65,125,115,80,3,false),
(307,'Mega Gardevoir','Psychic','Fairy',68,85,65,165,135,100,3,false),
(308,'Surskit','Bug','Water',40,30,32,50,52,65,3,false),
(309,'Masquerain','Bug','Flying',70,60,62,80,82,60,3,false),
(310,'Shroomish','Grass','',60,40,60,40,60,35,3,false),
(311,'Breloom','Grass','Fighting',60,130,80,60,60,70,3,false),
(312,'Slakoth','Normal','',60,60,60,35,35,30,3,false),
(313,'Vigoroth','Normal','',80,80,80,55,55,90,3,false),
(314,'Slaking','Normal','',150,160,100,95,65,100,3,false),
(315,'Nincada','Bug','Ground',31,45,90,30,30,40,3,false),
(316,'Ninjask','Bug','Flying',61,90,45,50,50,160,3,false),
(317,'Shedinja','Bug','Ghost',1,90,45,30,30,40,3,false),
(318,'Whismur','Normal','',64,51,23,51,23,28,3,false),
(319,'Loudred','Normal','',84,71,43,71,43,48,3,false),
(320,'Exploud','Normal','',104,91,63,91,73,68,3,false),
(321,'Makuhita','Fighting','',72,60,30,20,30,25,3,false),
(322,'Hariyama','Fighting','',144,120,60,40,60,50,3,false),
(323,'Azurill','Normal','Fairy',50,20,40,20,40,20,3,false),
(324,'Nosepass','Rock','',30,45,135,45,90,30,3,false),
(325,'Skitty','Normal','',50,45,45,35,35,50,3,false),
(326,'Delcatty','Normal','',70,65,65,55,55,70,3,false),
(327,'Sableye','Dark','Ghost',50,75,75,65,65,50,3,false),
(328,'Mega Sableye','Dark','Ghost',50,85,125,85,115,20,3,false),
(329,'Mawile','Steel','Fairy',50,85,85,55,55,50,3,false),
(330,'Mega Mawile','Steel','Fairy',50,105,125,55,95,50,3,false),
(331,'Aron','Steel','Rock',50,70,100,40,40,30,3,false),
(332,'Lairon','Steel','Rock',60,90,140,50,50,40,3,false),
(333,'Aggron','Steel','Rock',70,110,180,60,60,50,3,false),
(334,'Mega Aggron','Steel','',70,140,230,60,80,50,3,false),
(335,'Meditite','Fighting','Psychic',30,40,55,40,55,60,3,false),
(336,'Medicham','Fighting','Psychic',60,60,75,60,75,80,3,false),
(337,'Mega Medicham','Fighting','Psychic',60,100,85,80,85,100,3,false),
(338,'Electrike','Electric','',40,45,40,65,40,65,3,false),
(339,'Manectric','Electric','',70,75,60,105,60,105,3,false),
(340,'Mega Manectric','Electric','',70,75,80,135,80,135,3,false),
(341,'Plusle','Electric','',60,50,40,85,75,95,3,false),
(342,'Minun','Electric','',60,40,50,75,85,95,3,false),
(343,'Volbeat','Bug','',65,73,55,47,75,85,3,false),
(344,'Illumise','Bug','',65,47,55,73,75,85,3,false),
(345,'Roselia','Grass','Poison',50,60,45,100,80,65,3,false),
(346,'Gulpin','Poison','',70,43,53,43,53,40,3,false),
(347,'Swalot','Poison','',100,73,83,73,83,55,3,false),
(348,'Carvanha','Water','Dark',45,90,20,65,20,65,3,false),
(349,'Sharpedo','Water','Dark',70,120,40,95,40,95,3,false),
(350,'Mega Sharpedo','Water','Dark',70,140,70,110,65,105,3,false),
(351,'Wailmer','Water','',130,70,35,70,35,60,3,false),
(352,'Wailord','Water','',170,90,45,90,45,60,3,false),
(353,'Numel','Fire','Ground',60,60,40,65,45,35,3,false),
(354,'Camerupt','Fire','Ground',70,100,70,105,75,40,3,false),
(355,'Mega Camerupt','Fire','Ground',70,120,100,145,105,20,3,false),
(356,'Torkoal','Fire','',70,85,140,85,70,20,3,false),
(357,'Spoink','Psychic','',60,25,35,70,80,60,3,false),
(358,'Grumpig','Psychic','',80,45,65,90,110,80,3,false),
(359,'Spinda','Normal','',60,60,60,60,60,60,3,false),
(360,'Trapinch','Ground','',45,100,45,45,45,10,3,false),
(361,'Vibrava','Ground','Dragon',50,70,50,50,50,70,3,false),
(362,'Flygon','Ground','Dragon',80,100,80,80,80,100,3,false),
(363,'Cacnea','Grass','',50,85,40,85,40,35,3,false),
(364,'Cacturne','Grass','Dark',70,115,60,115,60,55,3,false),
(365,'Swablu','Normal','Flying',45,40,60,40,75,50,3,false),
(366,'Altaria','Dragon','Flying',75,70,90,70,105,80,3,false),
(367,'Mega Altaria','Dragon','Fairy',75,110,110,110,105,80,3,false),
(368,'Zangoose','Normal','',73,115,60,60,60,90,3,false),
(369,'Seviper','Poison','',73,100,60,100,60,65,3,false),
(370,'Lunatone','Rock','Psychic',70,55,65,95,85,70,3,false),
(371,'Solrock','Rock','Psychic',70,95,85,55,65,70,3,false),
(372,'Barboach','Water','Ground',50,48,43,46,41,60,3,false),
(373,'Whiscash','Water','Ground',110,78,73,76,71,60,3,false),
(374,'Corphish','Water','',43,80,65,50,35,35,3,false),
(375,'Crawdaunt','Water','Dark',63,120,85,90,55,55,3,false),
(376,'Baltoy','Ground','Psychic',40,40,55,40,70,55,3,false),
(377,'Claydol','Ground','Psychic',60,70,105,70,120,75,3,false),
(378,'Lileep','Rock','Grass',66,41,77,61,87,23,3,false),
(379,'Cradily','Rock','Grass',86,81,97,81,107,43,3,false),
(380,'Anorith','Rock','Bug',45,95,50,40,50,75,3,false),
(381,'Armaldo','Rock','Bug',75,125,100,70,80,45,3,false),
(382,'Feebas','Water','',20,15,20,10,55,80,3,false),
(383,'Milotic','Water','',95,60,79,100,125,81,3,false),
(384,'Castform','Normal','',70,70,70,70,70,70,3,false),
(385,'Kecleon','Normal','',60,90,70,60,120,40,3,false),
(386,'Shuppet','Ghost','',44,75,35,63,33,45,3,false),
(387,'Banette','Ghost','',64,115,65,83,63,65,3,false),
(388,'Mega Banette','Ghost','',64,165,75,93,83,75,3,false),
(389,'Duskull','Ghost','',20,40,90,30,90,25,3,false),
(390,'Dusclops','Ghost','',40,70,130,60,130,25,3,false),
(391,'Tropius','Grass','Flying',99,68,83,72,87,51,3,false),
(392,'Chimecho','Psychic','',65,50,70,95,80,65,3,false),
(393,'Absol','Dark','',65,130,60,75,60,75,3,false),
(394,'Mega Absol','Dark','',65,150,60,115,60,115,3,false),
(395,'Wynaut','Psychic','',95,23,48,23,48,23,3,false),
(396,'Snorunt','Ice','',50,50,50,50,50,50,3,false),
(397,'Glalie','Ice','',80,80,80,80,80,80,3,false),
(398,'Mega Glalie','Ice','',80,120,80,120,80,100,3,false),
(399,'Spheal','Ice','Water',70,40,50,55,50,25,3,false),
(400,'Sealeo','Ice','Water',90,60,70,75,70,45,3,false),
(401,'Walrein','Ice','Water',110,80,90,95,90,65,3,false),
(402,'Clamperl','Water','',35,64,85,74,55,32,3,false),
(403,'Huntail','Water','',55,104,105,94,75,52,3,false),
(404,'Gorebyss','Water','',55,84,105,114,75,52,3,false),
(405,'Relicanth','Water','Rock',100,90,130,45,65,55,3,false),
(406,'Luvdisc','Water','',43,30,55,40,65,97,3,false),
(407,'Bagon','Dragon','',45,75,60,40,30,50,3,false),
(408,'Shelgon','Dragon','',65,95,100,60,50,50,3,false),
(409,'Salamence','Dragon','Flying',95,135,80,110,80,100,3,false),
(410,'Mega Salamence','Dragon','Flying',95,145,130,120,90,120,3,false),
(411,'Beldum','Steel','Psychic',40,55,80,35,60,30,3,false),
(412,'Metang','Steel','Psychic',60,75,100,55,80,50,3,false),
(413,'Metagross','Steel','Psychic',80,135,130,95,90,70,3,false),
(414,'Mega Metagross','Steel','Psychic',80,145,150,105,110,110,3,false),
(415,'Regirock','Rock','',80,100,200,50,100,50,3,true),
(416,'Regice','Ice','',80,50,100,100,200,50,3,true),
(417,'Registeel','Steel','',80,75,150,75,150,50,3,true),
(418,'Latias','Dragon','Psychic',80,80,90,110,130,110,3,true),
(419,'Mega Latias','Dragon','Psychic',80,100,120,140,150,110,3,true),
(420,'Latios','Dragon','Psychic',80,90,80,130,110,110,3,true),
(421,'Mega Latios','Dragon','Psychic',80,130,100,160,120,110,3,true),
(422,'Kyogre','Water','',100,100,90,150,140,90,3,true),
(423,'Primal Kyogre','Water','',100,150,90,180,160,90,3,true),
(424,'Groudon','Ground','',100,150,140,100,90,90,3,true),
(425,'Primal Groudon','Ground','Fire',100,180,160,150,90,90,3,true),
(426,'Rayquaza','Dragon','Flying',105,150,90,150,90,95,3,true),
(427,'Mega Rayquaza','Dragon','Flying',105,180,100,180,100,115,3,true),
(428,'Jirachi','Steel','Psychic',100,100,100,100,100,100,3,true),
(429,'Deoxys Normal Forme','Psychic','',50,150,50,150,50,150,3,true),
(430,'DeoxysAttack Forme','Psychic','',50,180,20,180,20,150,3,true),
(431,'Deoxys Defense Forme','Psychic','',50,70,160,70,160,90,3,true),
(432,'Deoxys Speed Forme','Psychic','',50,95,90,95,90,180,3,true),
(433,'Turtwig','Grass','',55,68,64,45,55,31,4,false),
(434,'Grotle','Grass','',75,89,85,55,65,36,4,false),
(435,'Torterra','Grass','Ground',95,109,105,75,85,56,4,false),
(436,'Chimchar','Fire','',44,58,44,58,44,61,4,false),
(437,'Monferno','Fire','Fighting',64,78,52,78,52,81,4,false),
(438,'Infernape','Fire','Fighting',76,104,71,104,71,108,4,false),
(439,'Piplup','Water','',53,51,53,61,56,40,4,false),
(440,'Prinplup','Water','',64,66,68,81,76,50,4,false),
(441,'Empoleon','Water','Steel',84,86,88,111,101,60,4,false),
(442,'Starly','Normal','Flying',40,55,30,30,30,60,4,false),
(443,'Staravia','Normal','Flying',55,75,50,40,40,80,4,false),
(444,'Staraptor','Normal','Flying',85,120,70,50,60,100,4,false),
(445,'Bidoof','Normal','',59,45,40,35,40,31,4,false),
(446,'Bibarel','Normal','Water',79,85,60,55,60,71,4,false),
(447,'Kricketot','Bug','',37,25,41,25,41,25,4,false),
(448,'Kricketune','Bug','',77,85,51,55,51,65,4,false),
(449,'Shinx','Electric','',45,65,34,40,34,45,4,false),
(450,'Luxio','Electric','',60,85,49,60,49,60,4,false),
(451,'Luxray','Electric','',80,120,79,95,79,70,4,false),
(452,'Budew','Grass','Poison',40,30,35,50,70,55,4,false),
(453,'Roserade','Grass','Poison',60,70,65,125,105,90,4,false),
(454,'Cranidos','Rock','',67,125,40,30,30,58,4,false),
(455,'Rampardos','Rock','',97,165,60,65,50,58,4,false),
(456,'Shieldon','Rock','Steel',30,42,118,42,88,30,4,false),
(457,'Bastiodon','Rock','Steel',60,52,168,47,138,30,4,false),
(458,'Burmy','Bug','',40,29,45,29,45,36,4,false),
(459,'Wormadam Plant Cloak','Bug','Grass',60,59,85,79,105,36,4,false),
(460,'Wormadam Sandy Cloak','Bug','Ground',60,79,105,59,85,36,4,false),
(461,'Wormadam Trash Cloak','Bug','Steel',60,69,95,69,95,36,4,false),
(462,'Mothim','Bug','Flying',70,94,50,94,50,66,4,false),
(463,'Combee','Bug','Flying',30,30,42,30,42,70,4,false),
(464,'Vespiquen','Bug','Flying',70,80,102,80,102,40,4,false),
(465,'Pachirisu','Electric','',60,45,70,45,90,95,4,false),
(466,'Buizel','Water','',55,65,35,60,30,85,4,false),
(467,'Floatzel','Water','',85,105,55,85,50,115,4,false),
(468,'Cherubi','Grass','',45,35,45,62,53,35,4,false),
(469,'Cherrim','Grass','',70,60,70,87,78,85,4,false),
(470,'Shellos','Water','',76,48,48,57,62,34,4,false),
(471,'Gastrodon','Water','Ground',111,83,68,92,82,39,4,false),
(472,'Ambipom','Normal','',75,100,66,60,66,115,4,false),
(473,'Drifloon','Ghost','Flying',90,50,34,60,44,70,4,false),
(474,'Drifblim','Ghost','Flying',150,80,44,90,54,80,4,false),
(475,'Buneary','Normal','',55,66,44,44,56,85,4,false),
(476,'Lopunny','Normal','',65,76,84,54,96,105,4,false),
(477,'Mega Lopunny','Normal','Fighting',65,136,94,54,96,135,4,false),
(478,'Mismagius','Ghost','',60,60,60,105,105,105,4,false),
(479,'Honchkrow','Dark','Flying',100,125,52,105,52,71,4,false),
(480,'Glameow','Normal','',49,55,42,42,37,85,4,false),
(481,'Purugly','Normal','',71,82,64,64,59,112,4,false),
(482,'Chingling','Psychic','',45,30,50,65,50,45,4,false),
(483,'Stunky','Poison','Dark',63,63,47,41,41,74,4,false),
(484,'Skuntank','Poison','Dark',103,93,67,71,61,84,4,false),
(485,'Bronzor','Steel','Psychic',57,24,86,24,86,23,4,false),
(486,'Bronzong','Steel','Psychic',67,89,116,79,116,33,4,false),
(487,'Bonsly','Rock','',50,80,95,10,45,10,4,false),
(488,'Mime Jr.','Psychic','Fairy',20,25,45,70,90,60,4,false),
(489,'Happiny','Normal','',100,5,5,15,65,30,4,false),
(490,'Chatot','Normal','Flying',76,65,45,92,42,91,4,false),
(491,'Spiritomb','Ghost','Dark',50,92,108,92,108,35,4,false),
(492,'Gible','Dragon','Ground',58,70,45,40,45,42,4,false),
(493,'Gabite','Dragon','Ground',68,90,65,50,55,82,4,false),
(494,'Garchomp','Dragon','Ground',108,130,95,80,85,102,4,false),
(495,'Mega Garchomp','Dragon','Ground',108,170,115,120,95,92,4,false),
(496,'Munchlax','Normal','',135,85,40,40,85,5,4,false),
(497,'Riolu','Fighting','',40,70,40,35,40,60,4,false),
(498,'Lucario','Fighting','Steel',70,110,70,115,70,90,4,false),
(499,'Mega Lucario','Fighting','Steel',70,145,88,140,70,112,4,false),
(500,'Hippopotas','Ground','',68,72,78,38,42,32,4,false),
(501,'Hippowdon','Ground','',108,112,118,68,72,47,4,false),
(502,'Skorupi','Poison','Bug',40,50,90,30,55,65,4,false),
(503,'Drapion','Poison','Dark',70,90,110,60,75,95,4,false),
(504,'Croagunk','Poison','Fighting',48,61,40,61,40,50,4,false),
(505,'Toxicroak','Poison','Fighting',83,106,65,86,65,85,4,false),
(506,'Carnivine','Grass','',74,100,72,90,72,46,4,false),
(507,'Finneon','Water','',49,49,56,49,61,66,4,false),
(508,'Lumineon','Water','',69,69,76,69,86,91,4,false),
(509,'Mantyke','Water','Flying',45,20,50,60,120,50,4,false),
(510,'Snover','Grass','Ice',60,62,50,62,60,40,4,false),
(511,'Abomasnow','Grass','Ice',90,92,75,92,85,60,4,false),
(512,'Mega Abomasnow','Grass','Ice',90,132,105,132,105,30,4,false),
(513,'Weavile','Dark','Ice',70,120,65,45,85,125,4,false),
(514,'Magnezone','Electric','Steel',70,70,115,130,90,60,4,false),
(515,'Lickilicky','Normal','',110,85,95,80,95,50,4,false),
(516,'Rhyperior','Ground','Rock',115,140,130,55,55,40,4,false),
(517,'Tangrowth','Grass','',100,100,125,110,50,50,4,false),
(518,'Electivire','Electric','',75,123,67,95,85,95,4,false),
(519,'Magmortar','Fire','',75,95,67,125,95,83,4,false),
(520,'Togekiss','Fairy','Flying',85,50,95,120,115,80,4,false),
(521,'Yanmega','Bug','Flying',86,76,86,116,56,95,4,false),
(522,'Leafeon','Grass','',65,110,130,60,65,95,4,false),
(523,'Glaceon','Ice','',65,60,110,130,95,65,4,false),
(524,'Gliscor','Ground','Flying',75,95,125,45,75,95,4,false),
(525,'Mamoswine','Ice','Ground',110,130,80,70,60,80,4,false),
(526,'Porygon-Z','Normal','',85,80,70,135,75,90,4,false),
(527,'Gallade','Psychic','Fighting',68,125,65,65,115,80,4,false),
(528,'Mega Gallade','Psychic','Fighting',68,165,95,65,115,110,4,false),
(529,'Probopass','Rock','Steel',60,55,145,75,150,40,4,false),
(530,'Dusknoir','Ghost','',45,100,135,65,135,45,4,false),
(531,'Froslass','Ice','Ghost',70,80,70,80,70,110,4,false),
(532,'Rotom','Electric','Ghost',50,50,77,95,77,91,4,false),
(533,'Heat Rotom','Electric','Fire',50,65,107,105,107,86,4,false),
(534,'Wash Rotom','Electric','Water',50,65,107,105,107,86,4,false),
(535,'Frost Rotom','Electric','Ice',50,65,107,105,107,86,4,false),
(536,'Fan Rotom','Electric','Flying',50,65,107,105,107,86,4,false),
(537,'Mow Rotom','Electric','Grass',50,65,107,105,107,86,4,false),
(538,'Uxie','Psychic','',75,75,130,75,130,95,4,true),
(539,'Mesprit','Psychic','',80,105,105,105,105,80,4,true),
(540,'Azelf','Psychic','',75,125,70,125,70,115,4,true),
(541,'Dialga','Steel','Dragon',100,120,120,150,100,90,4,true),
(542,'Palkia','Water','Dragon',90,120,100,150,120,100,4,true),
(543,'Heatran','Fire','Steel',91,90,106,130,106,77,4,true),
(544,'Regigigas','Normal','',110,160,110,80,110,100,4,true),
(545,'Giratina Altered Forme','Ghost','Dragon',150,100,120,100,120,90,4,true),
(546,'Giratina Origin Forme','Ghost','Dragon',150,120,100,120,100,90,4,true),
(547,'Cresselia','Psychic','',120,70,120,75,130,85,4,false),
(548,'Phione','Water','',80,80,80,80,80,80,4,false),
(549,'Manaphy','Water','',100,100,100,100,100,100,4,false),
(550,'Darkrai','Dark','',70,90,90,135,90,125,4,true),
(551,'Shaymin Land Forme','Grass','',100,100,100,100,100,100,4,true),
(552,'Shaymin Sky Forme','Grass','Flying',100,103,75,120,75,127,4,true),
(553,'Arceus','Normal','',120,120,120,120,120,120,4,true),
(554,'Victini','Psychic','Fire',100,100,100,100,100,100,5,true),
(555,'Snivy','Grass','',45,45,55,45,55,63,5,false),
(556,'Servine','Grass','',60,60,75,60,75,83,5,false),
(557,'Serperior','Grass','',75,75,95,75,95,113,5,false),
(558,'Tepig','Fire','',65,63,45,45,45,45,5,false),
(559,'Pignite','Fire','Fighting',90,93,55,70,55,55,5,false),
(560,'Emboar','Fire','Fighting',110,123,65,100,65,65,5,false),
(561,'Oshawott','Water','',55,55,45,63,45,45,5,false),
(562,'Dewott','Water','',75,75,60,83,60,60,5,false),
(563,'Samurott','Water','',95,100,85,108,70,70,5,false),
(564,'Patrat','Normal','',45,55,39,35,39,42,5,false),
(565,'Watchog','Normal','',60,85,69,60,69,77,5,false),
(566,'Lillipup','Normal','',45,60,45,25,45,55,5,false),
(567,'Herdier','Normal','',65,80,65,35,65,60,5,false),
(568,'Stoutland','Normal','',85,110,90,45,90,80,5,false),
(569,'Purrloin','Dark','',41,50,37,50,37,66,5,false),
(570,'Liepard','Dark','',64,88,50,88,50,106,5,false),
(571,'Pansage','Grass','',50,53,48,53,48,64,5,false),
(572,'Simisage','Grass','',75,98,63,98,63,101,5,false),
(573,'Pansear','Fire','',50,53,48,53,48,64,5,false),
(574,'Simisear','Fire','',75,98,63,98,63,101,5,false),
(575,'Panpour','Water','',50,53,48,53,48,64,5,false),
(576,'Simipour','Water','',75,98,63,98,63,101,5,false),
(577,'Munna','Psychic','',76,25,45,67,55,24,5,false),
(578,'Musharna','Psychic','',116,55,85,107,95,29,5,false),
(579,'Pidove','Normal','Flying',50,55,50,36,30,43,5,false),
(580,'Tranquill','Normal','Flying',62,77,62,50,42,65,5,false),
(581,'Unfezant','Normal','Flying',80,115,80,65,55,93,5,false),
(582,'Blitzle','Electric','',45,60,32,50,32,76,5,false),
(583,'Zebstrika','Electric','',75,100,63,80,63,116,5,false),
(584,'Roggenrola','Rock','',55,75,85,25,25,15,5,false),
(585,'Boldore','Rock','',70,105,105,50,40,20,5,false),
(586,'Gigalith','Rock','',85,135,130,60,80,25,5,false),
(587,'Woobat','Psychic','Flying',55,45,43,55,43,72,5,false),
(588,'Swoobat','Psychic','Flying',67,57,55,77,55,114,5,false),
(589,'Drilbur','Ground','',60,85,40,30,45,68,5,false),
(590,'Excadrill','Ground','Steel',110,135,60,50,65,88,5,false),
(591,'Audino','Normal','',103,60,86,60,86,50,5,false),
(592,'Mega Audino','Normal','Fairy',103,60,126,80,126,50,5,false),
(593,'Timburr','Fighting','',75,80,55,25,35,35,5,false),
(594,'Gurdurr','Fighting','',85,105,85,40,50,40,5,false),
(595,'Conkeldurr','Fighting','',105,140,95,55,65,45,5,false),
(596,'Tympole','Water','',50,50,40,50,40,64,5,false),
(597,'Palpitoad','Water','Ground',75,65,55,65,55,69,5,false),
(598,'Seismitoad','Water','Ground',105,95,75,85,75,74,5,false),
(599,'Throh','Fighting','',120,100,85,30,85,45,5,false),
(600,'Sawk','Fighting','',75,125,75,30,75,85,5,false),
(601,'Sewaddle','Bug','Grass',45,53,70,40,60,42,5,false),
(602,'Swadloon','Bug','Grass',55,63,90,50,80,42,5,false),
(603,'Leavanny','Bug','Grass',75,103,80,70,80,92,5,false),
(604,'Venipede','Bug','Poison',30,45,59,30,39,57,5,false),
(605,'Whirlipede','Bug','Poison',40,55,99,40,79,47,5,false),
(606,'Scolipede','Bug','Poison',60,100,89,55,69,112,5,false),
(607,'Cottonee','Grass','Fairy',40,27,60,37,50,66,5,false),
(608,'Whimsicott','Grass','Fairy',60,67,85,77,75,116,5,false),
(609,'Petilil','Grass','',45,35,50,70,50,30,5,false),
(610,'Lilligant','Grass','',70,60,75,110,75,90,5,false),
(611,'Basculin','Water','',70,92,65,80,55,98,5,false),
(612,'Sandile','Ground','Dark',50,72,35,35,35,65,5,false),
(613,'Krokorok','Ground','Dark',60,82,45,45,45,74,5,false),
(614,'Krookodile','Ground','Dark',95,117,80,65,70,92,5,false),
(615,'Darumaka','Fire','',70,90,45,15,45,50,5,false),
(616,'Darmanitan Standard Mode','Fire','',105,140,55,30,55,95,5,false),
(617,'Darmanitan Zen Mode','Fire','Psychic',105,30,105,140,105,55,5,false),
(618,'Maractus','Grass','',75,86,67,106,67,60,5,false),
(619,'Dwebble','Bug','Rock',50,65,85,35,35,55,5,false),
(620,'Crustle','Bug','Rock',70,95,125,65,75,45,5,false),
(621,'Scraggy','Dark','Fighting',50,75,70,35,70,48,5,false),
(622,'Scrafty','Dark','Fighting',65,90,115,45,115,58,5,false),
(623,'Sigilyph','Psychic','Flying',72,58,80,103,80,97,5,false),
(624,'Yamask','Ghost','',38,30,85,55,65,30,5,false),
(625,'Cofagrigus','Ghost','',58,50,145,95,105,30,5,false),
(626,'Tirtouga','Water','Rock',54,78,103,53,45,22,5,false),
(627,'Carracosta','Water','Rock',74,108,133,83,65,32,5,false),
(628,'Archen','Rock','Flying',55,112,45,74,45,70,5,false),
(629,'Archeops','Rock','Flying',75,140,65,112,65,110,5,false),
(630,'Trubbish','Poison','',50,50,62,40,62,65,5,false),
(631,'Garbodor','Poison','',80,95,82,60,82,75,5,false),
(632,'Zorua','Dark','',40,65,40,80,40,65,5,false),
(633,'Zoroark','Dark','',60,105,60,120,60,105,5,false),
(634,'Minccino','Normal','',55,50,40,40,40,75,5,false),
(635,'Cinccino','Normal','',75,95,60,65,60,115,5,false),
(636,'Gothita','Psychic','',45,30,50,55,65,45,5,false),
(637,'Gothorita','Psychic','',60,45,70,75,85,55,5,false),
(638,'Gothitelle','Psychic','',70,55,95,95,110,65,5,false),
(639,'Solosis','Psychic','',45,30,40,105,50,20,5,false),
(640,'Duosion','Psychic','',65,40,50,125,60,30,5,false),
(641,'Reuniclus','Psychic','',110,65,75,125,85,30,5,false),
(642,'Ducklett','Water','Flying',62,44,50,44,50,55,5,false),
(643,'Swanna','Water','Flying',75,87,63,87,63,98,5,false),
(644,'Vanillite','Ice','',36,50,50,65,60,44,5,false),
(645,'Vanillish','Ice','',51,65,65,80,75,59,5,false),
(646,'Vanilluxe','Ice','',71,95,85,110,95,79,5,false),
(647,'Deerling','Normal','Grass',60,60,50,40,50,75,5,false),
(648,'Sawsbuck','Normal','Grass',80,100,70,60,70,95,5,false),
(649,'Emolga','Electric','Flying',55,75,60,75,60,103,5,false),
(650,'Karrablast','Bug','',50,75,45,40,45,60,5,false),
(651,'Escavalier','Bug','Steel',70,135,105,60,105,20,5,false),
(652,'Foongus','Grass','Poison',69,55,45,55,55,15,5,false),
(653,'Amoonguss','Grass','Poison',114,85,70,85,80,30,5,false),
(654,'Frillish','Water','Ghost',55,40,50,65,85,40,5,false),
(655,'Jellicent','Water','Ghost',100,60,70,85,105,60,5,false),
(656,'Alomomola','Water','',165,75,80,40,45,65,5,false),
(657,'Joltik','Bug','Electric',50,47,50,57,50,65,5,false),
(658,'Galvantula','Bug','Electric',70,77,60,97,60,108,5,false),
(659,'Ferroseed','Grass','Steel',44,50,91,24,86,10,5,false),
(660,'Ferrothorn','Grass','Steel',74,94,131,54,116,20,5,false),
(661,'Klink','Steel','',40,55,70,45,60,30,5,false),
(662,'Klang','Steel','',60,80,95,70,85,50,5,false),
(663,'Klinklang','Steel','',60,100,115,70,85,90,5,false),
(664,'Tynamo','Electric','',35,55,40,45,40,60,5,false),
(665,'Eelektrik','Electric','',65,85,70,75,70,40,5,false),
(666,'Eelektross','Electric','',85,115,80,105,80,50,5,false),
(667,'Elgyem','Psychic','',55,55,55,85,55,30,5,false),
(668,'Beheeyem','Psychic','',75,75,75,125,95,40,5,false),
(669,'Litwick','Ghost','Fire',50,30,55,65,55,20,5,false),
(670,'Lampent','Ghost','Fire',60,40,60,95,60,55,5,false),
(671,'Chandelure','Ghost','Fire',60,55,90,145,90,80,5,false),
(672,'Axew','Dragon','',46,87,60,30,40,57,5,false),
(673,'Fraxure','Dragon','',66,117,70,40,50,67,5,false),
(674,'Haxorus','Dragon','',76,147,90,60,70,97,5,false),
(675,'Cubchoo','Ice','',55,70,40,60,40,40,5,false),
(676,'Beartic','Ice','',95,110,80,70,80,50,5,false),
(677,'Cryogonal','Ice','',70,50,30,95,135,105,5,false),
(678,'Shelmet','Bug','',50,40,85,40,65,25,5,false),
(679,'Accelgor','Bug','',80,70,40,100,60,145,5,false),
(680,'Stunfisk','Ground','Electric',109,66,84,81,99,32,5,false),
(681,'Mienfoo','Fighting','',45,85,50,55,50,65,5,false),
(682,'Mienshao','Fighting','',65,125,60,95,60,105,5,false),
(683,'Druddigon','Dragon','',77,120,90,60,90,48,5,false),
(684,'Golett','Ground','Ghost',59,74,50,35,50,35,5,false),
(685,'Golurk','Ground','Ghost',89,124,80,55,80,55,5,false),
(686,'Pawniard','Dark','Steel',45,85,70,40,40,60,5,false),
(687,'Bisharp','Dark','Steel',65,125,100,60,70,70,5,false),
(688,'Bouffalant','Normal','',95,110,95,40,95,55,5,false),
(689,'Rufflet','Normal','Flying',70,83,50,37,50,60,5,false),
(690,'Braviary','Normal','Flying',100,123,75,57,75,80,5,false),
(691,'Vullaby','Dark','Flying',70,55,75,45,65,60,5,false),
(692,'Mandibuzz','Dark','Flying',110,65,105,55,95,80,5,false),
(693,'Heatmor','Fire','',85,97,66,105,66,65,5,false),
(694,'Durant','Bug','Steel',58,109,112,48,48,109,5,false),
(695,'Deino','Dark','Dragon',52,65,50,45,50,38,5,false),
(696,'Zweilous','Dark','Dragon',72,85,70,65,70,58,5,false),
(697,'Hydreigon','Dark','Dragon',92,105,90,125,90,98,5,false),
(698,'Larvesta','Bug','Fire',55,85,55,50,55,60,5,false),
(699,'Volcarona','Bug','Fire',85,60,65,135,105,100,5,false),
(700,'Cobalion','Steel','Fighting',91,90,129,90,72,108,5,true),
(701,'Terrakion','Rock','Fighting',91,129,90,72,90,108,5,true),
(702,'Virizion','Grass','Fighting',91,90,72,90,129,108,5,true),
(703,'Tornadus Incarnate Forme','Flying','',79,115,70,125,80,111,5,true),
(704,'Tornadus Therian Forme','Flying','',79,100,80,110,90,121,5,true),
(705,'Thundurus Incarnate Forme','Electric','Flying',79,115,70,125,80,111,5,true),
(706,'Thundurus Therian Forme','Electric','Flying',79,105,70,145,80,101,5,true),
(707,'Reshiram','Dragon','Fire',100,120,100,150,120,90,5,true),
(708,'Zekrom','Dragon','Electric',100,150,120,120,100,90,5,true),
(709,'Landorus Incarnate Forme','Ground','Flying',89,125,90,115,80,101,5,true),
(710,'Landorus Therian Forme','Ground','Flying',89,145,90,105,80,91,5,true),
(711,'Kyurem','Dragon','Ice',125,130,90,130,90,95,5,true),
(712,'Kyurem Black Kyurem','Dragon','Ice',125,170,100,120,90,95,5,true),
(713,'Kyurem White Kyurem','Dragon','Ice',125,120,90,170,100,95,5,true),
(714,'Keldeo Ordinary Forme','Water','Fighting',91,72,90,129,90,108,5,false),
(715,'Keldeo Resolute Forme','Water','Fighting',91,72,90,129,90,108,5,false),
(716,'Meloetta Aria Forme','Normal','Psychic',100,77,77,128,128,90,5,false),
(717,'Meloetta Pirouette Forme','Normal','Fighting',100,128,90,77,77,128,5,false),
(718,'Genesect','Bug','Steel',71,120,95,120,95,99,5,false),
(719,'Chespin','Grass','',56,61,65,48,45,38,6,false),
(720,'Quilladin','Grass','',61,78,95,56,58,57,6,false),
(721,'Chesnaught','Grass','Fighting',88,107,122,74,75,64,6,false),
(722,'Fennekin','Fire','',40,45,40,62,60,60,6,false),
(723,'Braixen','Fire','',59,59,58,90,70,73,6,false),
(724,'Delphox','Fire','Psychic',75,69,72,114,100,104,6,false),
(725,'Froakie','Water','',41,56,40,62,44,71,6,false),
(726,'Frogadier','Water','',54,63,52,83,56,97,6,false),
(727,'Greninja','Water','Dark',72,95,67,103,71,122,6,false),
(728,'Bunnelby','Normal','',38,36,38,32,36,57,6,false),
(729,'Diggersby','Normal','Ground',85,56,77,50,77,78,6,false),
(730,'Fletchling','Normal','Flying',45,50,43,40,38,62,6,false),
(731,'Fletchinder','Fire','Flying',62,73,55,56,52,84,6,false),
(732,'Talonflame','Fire','Flying',78,81,71,74,69,126,6,false),
(733,'Scatterbug','Bug','',38,35,40,27,25,35,6,false),
(734,'Spewpa','Bug','',45,22,60,27,30,29,6,false),
(735,'Vivillon','Bug','Flying',80,52,50,90,50,89,6,false),
(736,'Litleo','Fire','Normal',62,50,58,73,54,72,6,false),
(737,'Pyroar','Fire','Normal',86,68,72,109,66,106,6,false),
(738,'Flabébé','Fairy','',44,38,39,61,79,42,6,false),
(739,'Floette','Fairy','',54,45,47,75,98,52,6,false),
(740,'Florges','Fairy','',78,65,68,112,154,75,6,false),
(741,'Skiddo','Grass','',66,65,48,62,57,52,6,false),
(742,'Gogoat','Grass','',123,100,62,97,81,68,6,false),
(743,'Pancham','Fighting','',67,82,62,46,48,43,6,false),
(744,'Pangoro','Fighting','Dark',95,124,78,69,71,58,6,false),
(745,'Furfrou','Normal','',75,80,60,65,90,102,6,false),
(746,'Espurr','Psychic','',62,48,54,63,60,68,6,false),
(747,'Meowstic Male','Psychic','',74,48,76,83,81,104,6,false),
(748,'Meowstic Female','Psychic','',74,48,76,83,81,104,6,false),
(749,'Honedge','Steel','Ghost',45,80,100,35,37,28,6,false),
(750,'Doublade','Steel','Ghost',59,110,150,45,49,35,6,false),
(751,'Aegislash Blade Forme','Steel','Ghost',60,150,50,150,50,60,6,false),
(752,'Aegislash Shield Forme','Steel','Ghost',60,50,150,50,150,60,6,false),
(753,'Spritzee','Fairy','',78,52,60,63,65,23,6,false),
(754,'Aromatisse','Fairy','',101,72,72,99,89,29,6,false),
(755,'Swirlix','Fairy','',62,48,66,59,57,49,6,false),
(756,'Slurpuff','Fairy','',82,80,86,85,75,72,6,false),
(757,'Inkay','Dark','Psychic',53,54,53,37,46,45,6,false),
(758,'Malamar','Dark','Psychic',86,92,88,68,75,73,6,false),
(759,'Binacle','Rock','Water',42,52,67,39,56,50,6,false),
(760,'Barbaracle','Rock','Water',72,105,115,54,86,68,6,false),
(761,'Skrelp','Poison','Water',50,60,60,60,60,30,6,false),
(762,'Dragalge','Poison','Dragon',65,75,90,97,123,44,6,false),
(763,'Clauncher','Water','',50,53,62,58,63,44,6,false),
(764,'Clawitzer','Water','',71,73,88,120,89,59,6,false),
(765,'Helioptile','Electric','Normal',44,38,33,61,43,70,6,false),
(766,'Heliolisk','Electric','Normal',62,55,52,109,94,109,6,false),
(767,'Tyrunt','Rock','Dragon',58,89,77,45,45,48,6,false),
(768,'Tyrantrum','Rock','Dragon',82,121,119,69,59,71,6,false),
(769,'Amaura','Rock','Ice',77,59,50,67,63,46,6,false),
(770,'Aurorus','Rock','Ice',123,77,72,99,92,58,6,false),
(771,'Sylveon','Fairy','',95,65,65,110,130,60,6,false),
(772,'Hawlucha','Fighting','Flying',78,92,75,74,63,118,6,false),
(773,'Dedenne','Electric','Fairy',67,58,57,81,67,101,6,false),
(774,'Carbink','Rock','Fairy',50,50,150,50,150,50,6,false),
(775,'Goomy','Dragon','',45,50,35,55,75,40,6,false),
(776,'Sliggoo','Dragon','',68,75,53,83,113,60,6,false),
(777,'Goodra','Dragon','',90,100,70,110,150,80,6,false),
(778,'Klefki','Steel','Fairy',57,80,91,80,87,75,6,false),
(779,'Phantump','Ghost','Grass',43,70,48,50,60,38,6,false),
(780,'Trevenant','Ghost','Grass',85,110,76,65,82,56,6,false),
(781,'Pumpkaboo Average Size','Ghost','Grass',49,66,70,44,55,51,6,false),
(782,'Pumpkaboo Small Size','Ghost','Grass',44,66,70,44,55,56,6,false),
(783,'Pumpkaboo Large Size','Ghost','Grass',54,66,70,44,55,46,6,false),
(784,'Pumpkaboo Super Size','Ghost','Grass',59,66,70,44,55,41,6,false),
(785,'Gourgeist Average Size','Ghost','Grass',65,90,122,58,75,84,6,false),
(786,'Gourgeist Small Size','Ghost','Grass',55,85,122,58,75,99,6,false),
(787,'Gourgeist Large Size','Ghost','Grass',75,95,122,58,75,69,6,false),
(788,'Gourgeist Super Size','Ghost','Grass',85,100,122,58,75,54,6,false),
(789,'Bergmite','Ice','',55,69,85,32,35,28,6,false),
(790,'Avalugg','Ice','',95,117,184,44,46,28,6,false),
(791,'Noibat','Flying','Dragon',40,30,35,45,40,55,6,false),
(792,'Noivern','Flying','Dragon',85,70,80,97,80,123,6,false),
(793,'Xerneas','Fairy','',126,131,95,131,98,99,6,true),
(794,'Yveltal','Dark','Flying',126,131,95,131,98,99,6,true),
(795,'Zygarde Half Forme','Dragon','Ground',108,100,121,81,95,95,6,true),
(796,'Diancie','Rock','Fairy',50,100,150,100,150,50,6,true),
(797,'Mega Diancie','Rock','Fairy',50,160,110,160,110,110,6,true),
(798,'Hoopa Confined','Psychic','Ghost',80,110,60,150,130,70,6,true),
(799,'Hoopa Unbound','Psychic','Dark',80,160,60,170,130,80,6,true),
(800,'Volcanion','Fire','Water',80,110,120,130,90,70,6,true);