text: SELECT resident_evil_db;
  INSERT INTO capitals (id, name, longitude, latitude)
  VALUES
  (1,'Kabul',34.53,69.17),
  (2,'Tirana',41.33,19.82),
  (3,'Algiers',36.75,3.04),
  (4,'Pago Pago',-14.28,-170.7),
  (5,'Andorra la Vella',42.51,1.52),
  (6,'Luanda',-8.84,13.23),
  (7,'The Valley',18.22,-63.06),
  (8,'St. Johns',17.12,-61.85),
  (9,'Buenos Aires',-34.61,-58.38),
  (10,'Yerevan',40.18,44.51),
  (11,'Oranjestad',12.52,-70.03),
  (12,'Canberra',-35.28,149.13),
  (13,'Vienna',48.21,16.37),
  (14,'Baku',40.38,49.89),
  (15,'Nassau',25.06,-77.34),
  (16,'Manama',26.22,50.58),
  (17,'Dhaka',23.71,90.41),
  (18,'Bridgetown',13.1,-59.62),
  (19,'Minsk',53.9,27.57),
  (20,'Brussels',50.85,4.35),
  (21,'Belmopan',17.25,-88.77),
  (22,'Porto-Novo',6.5,2.6),
  (23,'Hamilton',32.29,-64.78),
  (24,'Thimphu',27.47,89.64),
  (25,'Sucre',-19.03,-65.26),
  (26,'Sarajevo',43.85,18.36),
  (27,'Gaborone',-24.65,25.91),
  (28,'Brasília',-15.78,-47.93),
  (29,'Diego Garcia',72.46,7.24),
  (30,'Road Town',18.42,-64.62),
  (31,'Bandar Seri Begawan',4.94,114.95),
  (32,'Sofia',42.7,23.32),
  (33,'Ouagadougou',12.37,-1.53),
  (34,'Bujumbura',-3.38,29.36),
  (35,'Phnom Penh',11.56,104.92),
  (36,'Yaoundé',3.87,11.52),
  (37,'Ottawa',45.41,-75.7),
  (38,'Praia',14.93,-23.51),
  (39,'George Town',19.29,-81.37),
  (40,'Bangui',4.36,18.55),
  (41,'N Djamena',12.11,15.04),
  (42,'Santiago',-33.46,-70.65),
  (43,'Beijing',39.91,116.4),
  (44,'The Settlement',-10.42,105.68),
  (45,'West Island',-12.16,96.82),
  (46,'Bogotá',4.61,-74.08),
  (47,'Moroni',-11.7,43.26),
  (48,'Avarua',-21.21,-159.78),
  (49,'San José',9.93,-84.08),
  (50,'Zagreb',45.81,15.98),
  (51,'Havana',23.13,-82.38),
  (52,'Nicosia',35.17,33.37),
  (53,'Prague',50.09,14.42),
  (54,'Kinshasa',-4.32,15.31),
  (55,'Copenhagen',55.68,12.57),
  (56,'Djibouti',11.59,43.15),
  (57,'Roseau',15.3,-61.39),
  (58,'Santo Domingo',18.5,-69.99),
  (59,'Dili',-8.56,125.57),
  (60,'Quito',-0.23,-78.52),
  (61,'Cairo',30.06,31.25),
  (62,'San Salvador',13.69,-89.19),
  (63,'Malabo',3.75,8.78),
  (64,'Asmara',15.33,38.93),
  (65,'Tallinn',59.44,24.75),
  (66,'Addis Ababa',9.02,38.75),
  (67,'Stanley',-51.7,-57.85),
  (68,'Tórshavn',62.01,-6.77),
  (69,'Suva',-18.14,178.44),
  (70,'Helsinki',60.17,24.94),
  (71,'Paris',48.85,2.35),
  (72,'Cayenne',4.93,-52.33),
  (73,'Papeete',-17.53,-149.57),
  (74,'Libreville',0.39,9.45),
  (75,'Banjul',13.45,-16.58),
  (76,'Tbilisi',41.69,44.83),
  (77,'Berlin',52.52,13.41),
  (78,'Accra',5.56,-0.2),
  (79,'Gibraltar',36.14,-5.35),
  (80,'Athens',37.98,23.72),
  (81,'Nuuk (Godthåb)',64.18,-51.72),
  (82,'St. Georges',12.06,-61.75),
  (83,'Basse-Terre',16,-61.73),
  (84,'Hagåtña',13.48,144.75),
  (85,'New Guatemala',14.64,-90.51),
  (86,'St Peter Port',49.46,-2.54),
  (87,'Conakry',9.54,-13.68),
  (88,'Bissau',11.86,-15.6),
  (89,'Georgetown',6.8,-58.16),
  (90,'Port-au-Prince',18.54,-72.34),
  (91,'Tegucigalpa',14.08,-87.21),
  (92,'Hong Kong',22.29,114.16),
  (93,'Budapest',47.5,19.04),
  (94,'Reykjavík',64.14,-21.9),
  (95,'New Delhi',28.64,77.22),
  (96,'Jakarta',-6.21,106.85),
  (97,'Tehran',35.69,51.42),
  (98,'Baghdad',33.34,44.4),
  (99,'Dublin',53.33,-6.25),
  (100,'Douglas',54.15,-4.48),
  (101,'Jerusalem',35.23,31.77),
  (102,'Rome',41.89,12.48),
  (103,'Yamoussoukro',6.82,-5.28),
  (104,'Kingston',18,-76.79),
  (105,'Edo',35.69,139.69),
  (106,'Saint Helier',49.19,-2.1),
  (107,'Amman',31.96,35.95),
  (108,'Astana',51.18,71.45),
  (109,'Nairobi',-1.28,36.82),
  (110,'South Tarawa',1.33,172.98),
  (111,'Pristina',42.67,21.17),
  (112,'Kuwait City',29.37,47.98),
  (113,'Bishkek',42.87,74.59),
  (114,'Vientiane',17.97,102.6),
  (115,'Riga',56.95,24.11),
  (116,'Beirut',33.89,35.49),
  (117,'Maseru',-29.32,27.48),
  (118,'Monrovia',6.3,-10.8),
  (119,'Tripoli',32.88,13.19),
  (120,'Vaduz',47.14,9.52),
  (121,'Vilnius',54.69,25.28),
  (122,'Luxembourg',49.61,6.13),
  (123,'Macao',22.2,113.55),
  (124,'Skopje',42,21.43),
  (125,'Antananarivo',-18.91,47.54),
  (126,'Lilongwe',-13.97,33.79),
  (127,'Kuala Lumpur',3.14,101.69),
  (128,'Malé',4.17,73.51),
  (129,'Bamako',12.65,-8),
  (130,'Valletta',35.9,14.51),
  (131,'Majuro',7.09,171.38),
  (132,'Fort-de-France',14.61,-61.07),
  (133,'Nouakchott',18.09,-15.98),
  (134,'Port Louis',-20.16,57.5),
  (135,'Mamoutzou',-12.78,45.23),
  (136,'Mexico City',19.43,-99.13),
  (137,'Palikir',6.92,158.16),
  (138,'Chişinău',47.01,28.86),
  (139,'Monaco',43.73,7.42),
  (140,'Ulan Bator',47.91,106.88),
  (141,'Podgorica',42.44,19.26),
  (142,'Plymouth',16.71,-62.21),
  (143,'Rabat',34.01,-6.83),
  (144,'Maputo',-25.97,32.58),
  (145,'Nay Pyi Taw',19.75,96.13),
  (146,'Windhoek',-22.56,17.08),
  (147,'Yaren',166.93,-0.54),
  (148,'Kathmandu',27.7,85.32),
  (149,'Amsterdam',52.37,4.89),
  (150,'Willemstad',-68.92,12.1),
  (151,'Noumea',-22.28,166.46),
  (152,'Wellington',-41.29,174.78),
  (153,'Managua',12.13,-86.25),
  (154,'Niamey',13.51,2.11),
  (155,'Abuja',9.07,7.48),
  (156,'Alofi',-19.06,-169.92),
  (157,'Kingston',-29.05,167.97),
  (158,'Pyongyang',39.03,125.75),
  (159,'Saipan',15.21,145.75),
  (160,'Oslo',59.91,10.75),
  (161,'Muscat',23.61,58.59),
  (162,'Islamabad',33.72,73.04),
  (163,'Melekeok',7.5,134.62),
  (164,'East Jerusalem',35.23,31.77),
  (165,'Panama City',8.99,-79.52),
  (166,'Port Moresby',-9.44,147.18),
  (167,'Asunción',-25.3,-57.64),
  (168,'Lima',-12.04,-77.03),
  (169,'Manila',14.6,120.98),
  (170,'Adamstown',-25.07,-130.1),
  (171,'Warsaw',52.23,21.01),
  (172,'Lisbon',38.72,-9.13),
  (173,'San Juan',18.47,-66.11),
  (174,'Doha',25.28,51.52),
  (175,'Brazzaville',-4.27,15.28),
  (176,'Saint-Denis',-20.88,55.45),
  (177,'Bucharest',44.43,26.11),
  (178,'Moscow',55.75,37.62),
  (179,'Kigali',-1.95,30.06),
  (180,'Gustavia',17.9,-62.85),
  (181,'Jamestown',-15.94,-5.72),
  (182,'Basseterre',17.29,-62.73),
  (183,'Castries',14,-61.01),
  (184,'Marigot',18.07,-63.08),
  (185,'Saint-Pierre',46.78,-56.17),
  (186,'Kingstown',13.16,-61.22),
  (187,'Apia',-13.83,-171.77),
  (188,'San Marino',43.94,12.45),
  (189,'São Tomé',0.34,6.73),
  (190,'Riyadh',24.69,46.72),
  (191,'Dakar',14.69,-17.44),
  (192,'Belgrade',44.8,20.47),
  (193,'Victoria',-4.62,55.45),
  (194,'Freetown',8.48,-13.23),
  (195,'Singapore',1.29,103.85),
  (196,'Bratislava',48.15,17.11),
  (197,'Ljubljana',46.05,14.51),
  (198,'Honiara',-9.43,159.95),
  (199,'Mogadishu',2.04,45.34),
  (200,'Pretoria',-25.74,28.19),
  (201,'Grytviken',-54.28,-36.51),
  (202,'Seoul',37.57,126.98),
  (203,'Madrid',40.42,-3.7),
  (204,'Colombo',6.93,79.85),
  (205,'Khartoum',15.55,32.53),
  (206,'Paramaribo',5.87,-55.17),
  (207,'Longyearbyen',78.22,15.64),
  (208,'Mbabane',-26.32,31.13),
  (209,'Stockholm',59.33,18.06),
  (210,'Berne',46.95,7.45),
  (211,'Damascus',33.51,36.29),
  (212,'Taipei',25.05,121.53),
  (213,'Dushanbe',38.54,68.78),
  (214,'Dodoma',-6.17,35.74),
  (215,'Bangkok',13.75,100.5),
  (216,'Lomé',6.14,1.21),
  (217,'Nukunonu',-171.85,-9.2),
  (218,'Nuku alofa',-21.13,-175.2),
  (219,'Port of Spain',10.67,-61.52),
  (220,'Tunis',36.82,10.17),
  (221,'Ankara',39.92,32.85),
  (222,'Ashkhabad',37.95,58.38),
  (223,'Cockburn Town',21.46,-71.14),
  (224,'Funafuti',-8.52,179.19),
  (225,'Charlotte Amalie',18.34,-64.93),
  (226,'Kampala',0.32,32.58),
  (227,'Kiev',50.45,30.52),
  (228,'Abu Dhabi',24.47,54.37),
  (229,'London',51.51,-0.13),
  (230,'Washington',38.9,-77.04),
  (231,'Montevideo',-34.83,-56.17),
  (232,'Tashkent',41.26,69.22),
  (233,'Port Vila',-17.73,168.32),
  (234,'Vatican',41.9,12.45),
  (235,'Caracas',10.49,-66.88),
  (236,'Hanoi',21.02,105.84),
  (237,'Mata-Utu',-13.28,-176.17),
  (238,'El Aaiún',27.16,-13.2),
  (239,'Sanaa',15.35,44.21),
  (240,'Lusaka',-15.41,28.29),
  (241,'Harare',-17.83,31.05)