-- India (50)

insert into location values (1,'Chennai','Tamilnadu','India');
insert into location values (2,'Trichy','Tamilnadu','India');
insert into location values (3,'Madurai','Tamilnadu','India');
insert into location values (4,'Kanchi','Tamilnadu','India');
insert into location values (5,'Salem','Tamilnadu','India');
insert into location values (6,'Mumbai','Maharashtra','India');
insert into location values (7,'Pune','Maharashtra','India');
insert into location values (8,'Nasik','Maharashtra','India');
insert into location values (9,'Aurangabad','Maharashtra','India');
insert into location values (10,'Lonavala','Maharashtra','India');
insert into location values (11,'Amritsar','Punjab','India');
insert into location values (12,'Amritsar','Punjab','India');
insert into location values (13,'Ludhiana','Punjab','India');
insert into location values (14,'Patiala','Punjab','India');
insert into location values (15,'Chandigarh','Punjab','India');
insert into location values (16,'Kanpur','Uttarpradesh','India');
insert into location values (17,'Lucknow','Uttarpradesh','India');
insert into location values (18,'Varanasi','Uttarpradesh','India');
insert into location values (19,'Meerut','Uttarpradesh','India');
insert into location values (20,'Allahabad','Uttarpradesh','India');
insert into location values (21,'Warangal','Andhrapradesh','India');
insert into location values (22,'Vizag','Andhrapradesh','India');
insert into location values (23,'Guntur','Andhrapradesh','India');
insert into location values (24,'Nellore','Andhrapradesh','India');
insert into location values (25,'Hyderabad','Andhrapradesh','India');
insert into location values (26,'Gwalior','Madhyapradesh','India');
insert into location values (27,'Jabalpur','Madhyapradesh','India');
insert into location values (28,'Indore','Madhyapradesh','India');
insert into location values (29,'Bhopal','Madhyapradesh','India');
insert into location values (30,'Rajgarh','Madhyapradesh','India');
insert into location values (31,'Jaipur','Rajasthan','India');
insert into location values (32,'Jodhpur','Rajasthan','India');
insert into location values (33,'Kota','Rajasthan','India');
insert into location values (34,'Udaipur','Rajasthan','India');
insert into location values (35,'Pilani','Rajasthan','India');
insert into location values (36,'Kolkotta','WestBengal','India');
insert into location values (37,'Puruliya','WestBengal','India');
insert into location values (38,'Hugli','WestBengal','India');
insert into location values (39,'Darjiling','WestBengal','India');
insert into location values (40,'Nadia','WestBengal','India');
insert into location values (41,'Ahmedabad','Gujarat','India');
insert into location values (42,'Jamnagar','Gujarat','India');
insert into location values (43,'Surat','Gujarat','India');
insert into location values (44,'Vadodara','Gujarat','India');
insert into location values (45,'Rajkot','Gujarat','India');
insert into location values (46,'Bangalore','Karnataka','India');
insert into location values (47,'Mysore','Karnataka','India');
insert into location values (48,'Hassan','Karnataka','India');
insert into location values (49,'Raichur','Karnataka','India');
insert into location values (50,'Gulbarga','Karnataka','India');

-- Canada (35)

insert into location values (51,'Calgary','Alberta','Canada');
insert into location values (52,'Edmonton','Alberta','Canada');
insert into location values (53,'FtMcMurray','Alberta','Canada');
insert into location values (54,'Faust','Alberta','Canada');
insert into location values (55,'Banff','Alberta','Canada');
insert into location values (56,'PrinceGeorge','BritishColumbia','Canada');
insert into location values (57,'Vancouver','BritishColumbia','Canada');
insert into location values (58,'Victoria','BritishColumbia','Canada');
insert into location values (59,'Kamloops','BritishColumbia','Canada');
insert into location values (60,'FortNelson','BritishColumbia','Canada');
insert into location values (61,'Winnipeg','Manitoba','Canada');
insert into location values (62,'Churchill','Manitoba','Canada');
insert into location values (63,'Thompson','Manitoba','Canada');
insert into location values (64,'Shamattawa','Manitoba','Canada');
insert into location values (65,'Gillam','Manitoba','Canada');
insert into location values (66,'Edmundston','NewBrunswick','Canada');
insert into location values (67,'Millinocket','NewBrunswick','Canada');
insert into location values (68,'Caribou','NewBrunswick','Canada');
insert into location values (69,'Fredericton','NewBrunswick','Canada');
insert into location values (70,'Bangor','NewBrunswick','Canada');
insert into location values (71,'Halifax','NovaScotia','Canada');
insert into location values (72,'Shelburne','NovaScotia','Canada');
insert into location values (73,'Sherbrooke','NovaScotia','Canada');
insert into location values (74,'Hawkesbury','NovaScotia','Canada');
insert into location values (75,'Caledonia','NovaScotia','Canada');
insert into location values (76,'Toronto','Ontario','Canada');
insert into location values (77,'ThunderBay','Ontario','Canada');
insert into location values (78,'Marathon','Ontario','Canada');
insert into location values (79,'Ottawa','Ontario','Canada');
insert into location values (80,'Pembroke','Ontario','Canada');
insert into location values (81,'Montreal','Quebec','Canada');
insert into location values (82,'Hull','Quebec','Canada');
insert into location values (83,'QuebecCity','Quebec','Canada');
insert into location values (84,'Parent','Quebec','Canada');
insert into location values (85,'Maniwaki','Quebec','Canada');


-- USA (50)

insert into location values (86,'Atlanta','Georgia','USA');
insert into location values (87,'Augusta','Georgia','USA');
insert into location values (88,'Cobb','Georgia','USA');
insert into location values (89,'Hamilton','Georgia','USA');
insert into location values (90,'VillaRica','Georgia','USA');
insert into location values (91,'Honolulu','Hawaii','USA');
insert into location values (92,'Hawi','Hawaii','USA');
insert into location values (93,'Kahuku','Hawaii','USA');
insert into location values (94,'PearlCity','Hawaii','USA');
insert into location values (95,'Volcano','Hawaii','USA');
insert into location values (96,'Albany','NewYork','USA');
insert into location values (97,'Almond','NewYork','USA');
insert into location values (98,'Manhattan','NewYork','USA');
insert into location values (99,'NewYorkCity','NewYork','USA');
insert into location values (100,'QueensVillage','NewYork','USA');
insert into location values (101,'Ackerman','Mississibi','USA');
insert into location values (102,'Newton','Mississibi','USA');
insert into location values (103,'Oxford','Mississibi','USA');
insert into location values (104,'Tupelo','Mississibi','USA');
insert into location values (105,'YazooCity','Mississibi','USA');
insert into location values (106,'Corona','NewMexico','USA');
insert into location values (107,'ElPrado','NewMexico','USA');
insert into location values (108,'SantaFe','NewMexico','USA');
insert into location values (109,'PeiTown','NewMexico','USA');
insert into location values (110,'Lordsburg','NewMexico','USA');
insert into location values (111,'OklahomaCity','Oklahoma','USA');
insert into location values (112,'Norman','Oklahoma','USA');
insert into location values (113,'Tulsa','Oklahoma','USA');
insert into location values (114,'BrokenArrow','Oklahoma','USA');
insert into location values (115,'Ada','Oklahoma','USA');
insert into location values (116,'Cheyenne','Wyoming','USA');
insert into location values (117,'Laramie','Wyoming','USA');
insert into location values (118,'ElkMountain','Wyoming','USA');
insert into location values (119,'DevelsTower','Wyoming','USA');
insert into location values (120,'Casper','Wyoming','USA');
insert into location values (121,'Chicken','Alaska','USA');
insert into location values (122,'ElfinCove','Alaska','USA');
insert into location values (123,'KingSalmon','Alaska','USA');
insert into location values (124,'Ruby','Alaska','USA');
insert into location values (125,'NorthPole','Alaska','USA');
insert into location values (126,'LosAngeles','California','USA');
insert into location values (127,'SanFrancisco','California','USA');
insert into location values (128,'AngelsCamp','California','USA');
insert into location values (129,'Gualala','California','USA');
insert into location values (130,'SanJose','California','USA');
insert into location values (131,'BlueHill','Maine','USA');
insert into location values (132,'Cherryfield','Maine','USA');
insert into location values (133,'SealHarbor','Maine','USA');
insert into location values (134,'York','Maine','USA');
insert into location values (135,'Rockwood','Maine','USA');


-- China (50)

insert into location values (136,'Anqing','Anhui','China');
insert into location values (137,'Hefei','Anhui','China');
insert into location values (138,'Huangshan','Anhui','China');
insert into location values (139,'Wuhu','Anhui','China');
insert into location values (140,'Chaohu','Anhui','China');
insert into location values (141,'Xiamen','Fujian','China');
insert into location values (142,'Fuzhou','Fujian','China');
insert into location values (143,'Wuyishan','Fujian','China');
insert into location values (144,'Longyan','Fujian','China');
insert into location values (145,'Dongshan','Fujian','China');
insert into location values (146,'Guangzhou','Guangdong','China');
insert into location values (147,'Shenzhen','Guangdong','China');
insert into location values (148,'Foshan','Guangdong','China');
insert into location values (149,'Zhongshan','Guangdong','China');
insert into location values (150,'Zhanjiang','Guangdong','China');
insert into location values (151,'Lasa','Tibet','China');
insert into location values (152,'Linzhi','Tibet','China');
insert into location values (153,'Changdu','Tibet','China');
insert into location values (154,'Naqu','Tibet','China');
insert into location values (155,'Rigeze','Tibet','China');
insert into location values (156,'Suzhou','Jiangsu','China');
insert into location values (157,'Wuxi','Jiangsu','China');
insert into location values (158,'Xuzhou','Jiangsu','China');
insert into location values (159,'Nanjing','Jiangsu','China');
insert into location values (160,'Changzhou','Jiangsu','China');
insert into location values (161,'Nanchang','Jiangxi','China');
insert into location values (162,'Jiujiang','Jiangxi','China');
insert into location values (163,'Jinggangshan','Jiangxi','China');
insert into location values (164,'Jingdezhen','Jiangxi','China');
insert into location values (165,'Ruijin','Jiangxi','China');
insert into location values (166,'Wulumuqi','Xinjiang','China');
insert into location values (167,'Atushi','Xinjiang','China');
insert into location values (168,'Akesu','Xinjiang','China');
insert into location values (169,'Tunufan','Xinjiang','China');
insert into location values (170,'Kenumayi','Xinjiang','China');
insert into location values (171,'Shijiazhuang','Hebei','China');
insert into location values (172,'Zhangjiakou','Hebei','China');
insert into location values (173,'Qinhuangdao','Hebei','China');
insert into location values (174,'Chengde','Hebei','China');
insert into location values (175,'Xuanhua','Hebei','China');
insert into location values (176,'Guiyang','Guizhou','China');
insert into location values (177,'Zunyi','Guizhou','China');
insert into location values (178,'Liupanshui','Guizhou','China');
insert into location values (179,'Tongren','Guizhou','China');
insert into location values (180,'Tianzhu','Guizhou','China');
insert into location values (181,'Chengdu','Sichuan','China');
insert into location values (182,'Emeishan','Sichuan','China');
insert into location values (183,'Jiuzhaigou','Sichuan','China');
insert into location values (184,'Mianyang','Sichuan','China');
insert into location values (185,'Dujiangyan','Sichuan','China');
