SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for country
-- ----------------------------
DROP TABLE IF EXISTS `country`;
CREATE TABLE `country` (
  `Name` varchar(35) NOT NULL,
  `Code` varchar(4) NOT NULL DEFAULT '',
  `Capital` varchar(35) DEFAULT NULL,
  `Province` varchar(35) DEFAULT NULL,
  `Area` float DEFAULT NULL,
  `Population` int(11) DEFAULT NULL,
  PRIMARY KEY (`Code`) USING BTREE,
  UNIQUE KEY `ix_county_Name` (`Name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of country
-- ----------------------------
BEGIN;
INSERT INTO `country` VALUES ('Austria', 'A', 'Vienna', 'Vienna', 83850, 8023244);
INSERT INTO `country` VALUES ('Afghanistan', 'AFG', 'Kabul', 'Afghanistan', 647500, 22664136);
INSERT INTO `country` VALUES ('Antigua and Barbuda', 'AG', 'Saint Johns', 'Antigua and Barbuda', 442, 65647);
INSERT INTO `country` VALUES ('Albania', 'AL', 'Tirane', 'Albania', 28750, 3249136);
INSERT INTO `country` VALUES ('American Samoa', 'AMSA', 'Pago Pago', 'American Samoa', 199, 65628);
INSERT INTO `country` VALUES ('Andorra', 'AND', 'Andorra la Vella', 'Andorra', 450, 72766);
INSERT INTO `country` VALUES ('Angola', 'ANG', 'Luanda', 'Luanda', 1246700, 10342899);
INSERT INTO `country` VALUES ('Armenia', 'ARM', 'Yerevan', 'Armenia', 29800, 3463574);
INSERT INTO `country` VALUES ('Aruba', 'ARU', 'Oranjestad', 'Aruba', 193, 103065);
INSERT INTO `country` VALUES ('Australia', 'AUS', 'Canberra', 'Australia Capital Territory', 7686850, 18260863);
INSERT INTO `country` VALUES ('Anguilla', 'AXA', 'The Valley', 'Anguilla', 102, 14436);
INSERT INTO `country` VALUES ('Azerbaijan', 'AZ', 'Baku', 'Azerbaijan', 86600, 7676953);
INSERT INTO `country` VALUES ('Belgium', 'B', 'Brussels', 'Brabant', 30510, 10170241);
INSERT INTO `country` VALUES ('Bangladesh', 'BD', 'Dhaka', 'Bangladesh', 144000, 123062800);
INSERT INTO `country` VALUES ('Barbados', 'BDS', 'Bridgetown', 'Barbados', 430, 257030);
INSERT INTO `country` VALUES ('Benin', 'BEN', 'Porto-Novo', 'Benin', 112620, 5709529);
INSERT INTO `country` VALUES ('Bermuda', 'BERM', 'Hamilton', 'Bermuda', 53.3, 67837);
INSERT INTO `country` VALUES ('Burkina Faso', 'BF', 'Ouagadougou', 'Burkina Faso', 274200, 10623323);
INSERT INTO `country` VALUES ('Bulgaria', 'BG', 'Sofia', 'Bulgaria', 110910, 8612757);
INSERT INTO `country` VALUES ('Bhutan', 'BHT', 'Thimphu', 'Bhutan', 47000, 1822625);
INSERT INTO `country` VALUES ('Burundi', 'BI', 'Bujumbura', 'Burundi', 27830, 5943057);
INSERT INTO `country` VALUES ('Bosnia and Herzegovina', 'BIH', 'Sarajevo', 'Bosnia and Herzegovina', 51233, 2656240);
INSERT INTO `country` VALUES ('Bolivia', 'BOL', 'La Paz', 'Bolivia', 1098580, 7165257);
INSERT INTO `country` VALUES ('Brazil', 'BR', 'Brasilia', 'Distrito Federal', 8511960, 162661214);
INSERT INTO `country` VALUES ('Bahrain', 'BRN', 'Manama', 'Bahrain', 620, 590042);
INSERT INTO `country` VALUES ('Brunei', 'BRU', 'Bandar Seri Begawan', 'Brunei', 5770, 299939);
INSERT INTO `country` VALUES ('Bahamas', 'BS', 'Nassau', 'Bahamas', 13940, 259367);
INSERT INTO `country` VALUES ('British Virgin Islands', 'BVIR', 'Road Town', 'British Virgin Islands', 153, 24491);
INSERT INTO `country` VALUES ('Belarus', 'BY', 'Minsk', 'Belarus', 207600, 10415973);
INSERT INTO `country` VALUES ('Belize', 'BZ', 'Belmopan', 'Belize', 22960, 219296);
INSERT INTO `country` VALUES ('Cuba', 'C', 'Havana', 'Ciudad de la Habana', 110860, 10951334);
INSERT INTO `country` VALUES ('Cameroon', 'CAM', 'Yaounde', 'Centre', 475440, 14261557);
INSERT INTO `country` VALUES ('Cayman Islands', 'CAYM', 'George Town', 'Cayman Islands', 262, 49035);
INSERT INTO `country` VALUES ('Canada', 'CDN', 'Ottawa', 'Ontario', 9976140, 28820671);
INSERT INTO `country` VALUES ('Switzerland', 'CH', 'Bern', 'BE', 41290, 7207060);
INSERT INTO `country` VALUES ('Cote dIvoire', 'CI', 'Yamoussoukro', 'Cote dIvoire', 322460, 14762445);
INSERT INTO `country` VALUES ('Sri Lanka', 'CL', 'Colombo', 'Sri Lanka', 65610, 18553074);
INSERT INTO `country` VALUES ('Colombia', 'CO', 'Bogota', 'Santa Fe de Bogota, DC', 1138910, 36813161);
INSERT INTO `country` VALUES ('Cocos Islands', 'COCO', 'West Island', 'Cocos Islands', 14, 596);
INSERT INTO `country` VALUES ('Comoros', 'COM', 'Moroni', 'Comoros', 2170, 569237);
INSERT INTO `country` VALUES ('Cook Islands', 'COOK', 'Avarua', 'Cook Islands', 240, 11870);
INSERT INTO `country` VALUES ('Costa Rica', 'CR', 'San Jose', 'San Jose', 51100, 3463083);
INSERT INTO `country` VALUES ('Cape Verde', 'CV', 'Praia', 'Cape Verde', 4030, 449066);
INSERT INTO `country` VALUES ('Cyprus', 'CY', 'Nicosia', 'Cyprus', 9251, 744609);
INSERT INTO `country` VALUES ('Czech Republic', 'CZ', 'Prague', 'Praha', 78703, 10321120);
INSERT INTO `country` VALUES ('Germany', 'D', 'Berlin', 'Berlin', 356910, 83536115);
INSERT INTO `country` VALUES ('Djibouti', 'DJI', 'Djibouti', 'Djibouti', 22000, 427642);
INSERT INTO `country` VALUES ('Denmark', 'DK', 'Copenhagen', 'Denmark', 43070, 5249632);
INSERT INTO `country` VALUES ('Dominican Republic', 'DOM', 'Santo Domingo', 'Dominican Republic', 48730, 8088881);
INSERT INTO `country` VALUES ('Algeria', 'DZ', 'Algier', 'Algeria', 2381740, 29183032);
INSERT INTO `country` VALUES ('Spain', 'E', 'Madrid', 'Madrid', 504750, 39181114);
INSERT INTO `country` VALUES ('Kenya', 'EAK', 'Nairobi', 'Nairobi', 582650, 28176686);
INSERT INTO `country` VALUES ('Tanzania', 'EAT', 'Dar es Salaam', 'Daressalam', 945090, 29058470);
INSERT INTO `country` VALUES ('Uganda', 'EAU', 'Kampala', 'Uganda', 236040, 20158176);
INSERT INTO `country` VALUES ('Ecuador', 'EC', 'Quito', 'Ecuador', 283560, 11466291);
INSERT INTO `country` VALUES ('Eritrea', 'ER', 'Asmara', 'Eritrea', 121320, 3427883);
INSERT INTO `country` VALUES ('El Salvador', 'ES', 'San Salvador', 'El Salvador', 21040, 5828987);
INSERT INTO `country` VALUES ('Egypt', 'ET', 'Cairo', 'El Qahira', 1001450, 63575107);
INSERT INTO `country` VALUES ('Ethiopia', 'ETH', 'Addis Ababa', 'Ethiopia', 1127130, 57171662);
INSERT INTO `country` VALUES ('Estonia', 'EW', 'Tallinn', 'Estonia', 45100, 1459428);
INSERT INTO `country` VALUES ('France', 'F', 'Paris', 'Ile de France', 547030, 58317450);
INSERT INTO `country` VALUES ('Falkland Islands', 'FALK', 'Stanley', 'Falkland Islands', 12173, 3140);
INSERT INTO `country` VALUES ('Faroe Islands', 'FARX', 'Torshavn', 'Faroe Islands', 1400, 43857);
INSERT INTO `country` VALUES ('French Guiana', 'FGU', 'Cayenne', 'French Guiana', 91000, 151187);
INSERT INTO `country` VALUES ('Fiji', 'FJI', 'Suva', 'Fiji', 18270, 782381);
INSERT INTO `country` VALUES ('Liechtenstein', 'FL', 'Vaduz', 'Liechtenstein', 160, 31122);
INSERT INTO `country` VALUES ('French Polynesia', 'FPOL', 'Papeete', 'French Polynesia', 4167, 287032);
INSERT INTO `country` VALUES ('Micronesia', 'FSM', 'Palikir', 'Micronesia', 702, 125377);
INSERT INTO `country` VALUES ('Gabon', 'G', 'Libreville', 'Gabon', 267670, 1172798);
INSERT INTO `country` VALUES ('Gaza Strip', 'GAZA', NULL, NULL, 360, 813332);
INSERT INTO `country` VALUES ('United Kingdom', 'GB', 'London', 'Greater London', 244820, 58489975);
INSERT INTO `country` VALUES ('Guernsey', 'GBG', 'Saint Peter Port', 'Guernsey', 194, 62920);
INSERT INTO `country` VALUES ('Jersey', 'GBJ', 'Saint Helier', 'Jersey', 117, 87848);
INSERT INTO `country` VALUES ('Man', 'GBM', 'Douglas', 'Man', 588, 73837);
INSERT INTO `country` VALUES ('Gibraltar', 'GBZ', 'Gibraltar', 'Gibraltar', 6.5, 28765);
INSERT INTO `country` VALUES ('Guatemala', 'GCA', 'Guatemala City', 'Guatemala', 108890, 11277614);
INSERT INTO `country` VALUES ('Georgia', 'GE', 'Tbilisi', 'Georgia', 69700, 5219810);
INSERT INTO `country` VALUES ('Ghana', 'GH', 'Accra', 'Ghana', 238540, 17698271);
INSERT INTO `country` VALUES ('Guinea-Bissau', 'GNB', 'Bissau', 'Guinea-Bissau', 36120, 1151330);
INSERT INTO `country` VALUES ('Equatorial Guinea', 'GQ', 'Malabo', 'Equatorial Guinea', 28050, 431282);
INSERT INTO `country` VALUES ('Greece', 'GR', 'Athens', 'Attiki', 131940, 10538594);
INSERT INTO `country` VALUES ('Greenland', 'GROX', 'Nuuk', 'Greenland', 2175600, 58203);
INSERT INTO `country` VALUES ('Guadeloupe', 'GUAD', 'Basse-Terre', 'Guadeloupe', 1780, 407768);
INSERT INTO `country` VALUES ('Guam', 'GUAM', 'Agana', 'Guam', 541.3, 178430);
INSERT INTO `country` VALUES ('Guyana', 'GUY', 'Georgetown', 'Guyana', 214970, 712091);
INSERT INTO `country` VALUES ('Hungary', 'H', 'Budapest', 'Budapest (munic.)', 93030, 10002541);
INSERT INTO `country` VALUES ('Honduras', 'HCA', 'Tegucigalpa', 'Francisco Morazan', 112090, 5605193);
INSERT INTO `country` VALUES ('Saint Helena', 'HELX', 'Jamestown', 'Saint Helena', 413, 7637);
INSERT INTO `country` VALUES ('Hong Kong', 'HONX', 'Hong Kong', 'Hong Kong', 1092, 7055071);
INSERT INTO `country` VALUES ('Croatia', 'HR', 'Zagreb', 'Croatia', 56538, 5004112);
INSERT INTO `country` VALUES ('Italy', 'I', 'Rome', 'Lazio', 301230, 57460274);
INSERT INTO `country` VALUES ('Israel', 'IL', 'Jerusalem', 'Central', 20770, 5421995);
INSERT INTO `country` VALUES ('India', 'IND', 'New Delhi', 'Delhi', 3287590, 952107694);
INSERT INTO `country` VALUES ('Iran', 'IR', 'Tehran', 'Tehran', 1648000, 66094264);
INSERT INTO `country` VALUES ('Ireland', 'IRL', 'Dublin', 'Ireland', 70280, 3566833);
INSERT INTO `country` VALUES ('Iraq', 'IRQ', 'Baghdad', 'Baghdad', 437072, 21422292);
INSERT INTO `country` VALUES ('Iceland', 'IS', 'Reykjavik', 'Iceland', 103000, 270292);
INSERT INTO `country` VALUES ('Japan', 'J', 'Tokyo', 'Tokyo', 377835, 125449703);
INSERT INTO `country` VALUES ('Jamaica', 'JA', 'Kingston', 'Jamaica', 10991, 2595275);
INSERT INTO `country` VALUES ('Jordan', 'JOR', 'Amman', 'Jordan', 89213, 4212152);
INSERT INTO `country` VALUES ('Cambodia', 'K', 'Phnom Penh', 'Cambodia', 181040, 10861218);
INSERT INTO `country` VALUES ('Kazakstan', 'KAZ', 'Almaty', 'Almaty (munic.)', 2717300, 16916463);
INSERT INTO `country` VALUES ('Kyrgyzstan', 'KGZ', 'Bishkek', 'Kyrgyzstan', 198500, 4529648);
INSERT INTO `country` VALUES ('Kiribati', 'KIR', 'Tarawa', 'Kiribati', 717, 80919);
INSERT INTO `country` VALUES ('Saint Kitts and Nevis', 'KN', 'Basseterre', 'Saint Kitts and Nevis', 269, 41369);
INSERT INTO `country` VALUES ('Kosovo', 'KOS', 'Pristina', 'Kosovo', 10887, 1804838);
INSERT INTO `country` VALUES ('Kuwait', 'KWT', 'Kuwait', 'Kuwait', 17820, 1950047);
INSERT INTO `country` VALUES ('Luxembourg', 'L', 'Luxembourg', 'Luxembourg', 2586, 415870);
INSERT INTO `country` VALUES ('Laos', 'LAO', 'Vientiane', 'Laos', 236800, 4975772);
INSERT INTO `country` VALUES ('Libya', 'LAR', 'Tripoli', 'Libya', 1759540, 5445436);
INSERT INTO `country` VALUES ('Liberia', 'LB', 'Monrovia', 'Liberia', 111370, 2109789);
INSERT INTO `country` VALUES ('Lesotho', 'LS', 'Maseru', 'Lesotho', 30350, 1970781);
INSERT INTO `country` VALUES ('Lithuania', 'LT', 'Vilnius', 'Lithuania', 65200, 3646041);
INSERT INTO `country` VALUES ('Latvia', 'LV', 'Riga', 'Latvia', 64100, 2468982);
INSERT INTO `country` VALUES ('Malta', 'M', 'Valletta', 'Malta', 320, 375576);
INSERT INTO `country` VALUES ('Morocco', 'MA', 'Rabat', 'Morocco', 446550, 29779156);
INSERT INTO `country` VALUES ('Macau', 'MACX', 'Macau', 'Macau', 16, 496837);
INSERT INTO `country` VALUES ('Malaysia', 'MAL', 'Kuala Lumpur', 'Fed. Terr. of Kuala Lumpur', 329750, 19962893);
INSERT INTO `country` VALUES ('Martinique', 'MART', 'Fort-de-France', 'Martinique', 1128, 399151);
INSERT INTO `country` VALUES ('Mayotte', 'MAYO', 'Mamoutzou', 'Mayotte', 374, 223765);
INSERT INTO `country` VALUES ('Monaco', 'MC', 'Monaco', 'Monaco', 1.9, 31719);
INSERT INTO `country` VALUES ('Moldova', 'MD', 'Chisinau', 'Moldova', 33700, 4463847);
INSERT INTO `country` VALUES ('Mexico', 'MEX', 'Mexico City', 'Distrito Federal', 1972550, 95772462);
INSERT INTO `country` VALUES ('Marshall Islands', 'MH', 'Majuro', 'Marshall Islands', 181.3, 58363);
INSERT INTO `country` VALUES ('Macedonia', 'MK', 'Skopje', 'Macedonia', 25333, 2104035);
INSERT INTO `country` VALUES ('Montenegro', 'MNE', 'Podgorica', 'Montenegro', 14026, 672180);
INSERT INTO `country` VALUES ('Mongolia', 'MNG', 'Ulaanbaatar', 'Mongolia', 1565000, 2496617);
INSERT INTO `country` VALUES ('Montserrat', 'MNTS', 'Plymouth', 'Montserrat', 102, 5097);
INSERT INTO `country` VALUES ('Mozambique', 'MOC', 'Maputo', 'Maputo (munic.)', 801590, 17877927);
INSERT INTO `country` VALUES ('Mauritius', 'MS', 'Port Louis', 'Mauritius', 2040, 1140256);
INSERT INTO `country` VALUES ('Maldives', 'MV', 'Male', 'Maldives', 300, 270758);
INSERT INTO `country` VALUES ('Malawi', 'MW', 'Lilongwe', 'Malawi', 118480, 9452844);
INSERT INTO `country` VALUES ('Myanmar', 'MYA', 'Rangoon', 'Yangon', 678500, 45975625);
INSERT INTO `country` VALUES ('Norway', 'N', 'Oslo', 'Oslo', 324220, 4383807);
INSERT INTO `country` VALUES ('Netherlands Antilles', 'NA', 'Willemstad', 'Netherlands Antilles', 960, 227049);
INSERT INTO `country` VALUES ('Namibia', 'NAM', 'Windhoek', 'Namibia', 825418, 1677243);
INSERT INTO `country` VALUES ('Nauru', 'NAU', 'Yaren', 'Nauru', 21, 10273);
INSERT INTO `country` VALUES ('New Caledonia', 'NCA', 'Noumea', 'New Caledonia', 19060, 227436);
INSERT INTO `country` VALUES ('Nepal', 'NEP', 'Kathmandu', 'Nepal', 140800, 22094033);
INSERT INTO `country` VALUES ('Nicaragua', 'NIC', 'Managua', 'Nicaragua', 129494, 4272352);
INSERT INTO `country` VALUES ('Niue', 'NIUE', 'Alofi', 'Niue', 260, 1398);
INSERT INTO `country` VALUES ('Netherlands', 'NL', 'Amsterdam', 'Noord Holland', 37330, 15568034);
INSERT INTO `country` VALUES ('Northern Mariana Islands', 'NMIS', 'Saipan', 'Northern Mariana Islands', 477, 88662);
INSERT INTO `country` VALUES ('North Korea', 'NOK', 'Pyongyang', 'North Korea', 120540, 23904124);
INSERT INTO `country` VALUES ('Norfolk Island', 'NORF', 'Kingston', 'Norfolk Island', 34.6, 2209);
INSERT INTO `country` VALUES ('New Zealand', 'NZ', 'Wellington', 'New Zealand', 268680, 3547983);
INSERT INTO `country` VALUES ('Oman', 'OM', 'Muscat', 'Oman', 212460, 2186548);
INSERT INTO `country` VALUES ('Portugal', 'P', 'Lisbon', 'Lisbon', 92080, 9865114);
INSERT INTO `country` VALUES ('Panama', 'PA', 'Panama City', 'Panama', 78200, 2655094);
INSERT INTO `country` VALUES ('Palau', 'PAL', 'Melekeok', 'Palau', 458, 16952);
INSERT INTO `country` VALUES ('Peru', 'PE', 'Lima', 'Lima', 1285220, 24523408);
INSERT INTO `country` VALUES ('Pitcairn Islands', 'PITC', 'Adamstown', 'Pitcairn Islands', 47, 48);
INSERT INTO `country` VALUES ('Pakistan', 'PK', 'Islamabad', 'Pakistan', 803940, 129275660);
INSERT INTO `country` VALUES ('Poland', 'PL', 'Warsaw', 'Warszwaskie', 312683, 38642565);
INSERT INTO `country` VALUES ('Papua New Guinea', 'PNG', 'Port Moresby', 'Papua New Guinea', 461690, 4394537);
INSERT INTO `country` VALUES ('Puerto Rico', 'PR', 'San Juan', 'Puerto Rico', 8870, 3971020);
INSERT INTO `country` VALUES ('Paraguay', 'PY', 'Asuncion', 'Paraguay', 406750, 5504146);
INSERT INTO `country` VALUES ('Qatar', 'Q', 'Doha', 'Qatar', 11000, 547761);
INSERT INTO `country` VALUES ('Russia', 'R', 'Moscow', 'Moskva', 17075200, 148178487);
INSERT INTO `country` VALUES ('Argentina', 'RA', 'Buenos Aires', 'Distrito Federal', 2766890, 34672997);
INSERT INTO `country` VALUES ('Botswana', 'RB', 'Gaborone', 'Botswana', 600370, 1477630);
INSERT INTO `country` VALUES ('Taiwan', 'RC', 'Taipei', 'Taiwan', 36179, 21465881);
INSERT INTO `country` VALUES ('Central African Republic', 'RCA', 'Bangui', 'Central African Republic', 622980, 3274426);
INSERT INTO `country` VALUES ('Congo', 'RCB', 'Brazzaville', 'Congo', 342000, 2527841);
INSERT INTO `country` VALUES ('Chile', 'RCH', 'Santiago', 'Chile', 756950, 14333258);
INSERT INTO `country` VALUES ('Reunion', 'REUN', 'Saint-Denis', 'Reunion', 2510, 679198);
INSERT INTO `country` VALUES ('Guinea', 'RG', 'Conakry', 'Guinea', 245860, 7411981);
INSERT INTO `country` VALUES ('Haiti', 'RH', 'Port-au-Prince', 'Haiti', 27750, 6731539);
INSERT INTO `country` VALUES ('Indonesia', 'RI', 'Jakarta', 'Indonesia', 1919440, 206611600);
INSERT INTO `country` VALUES ('Mauritania', 'RIM', 'Nouakchott', 'Mauritania', 1030700, 2336048);
INSERT INTO `country` VALUES ('Lebanon', 'RL', 'Beirut', 'Lebanon', 10400, 3776317);
INSERT INTO `country` VALUES ('Madagascar', 'RM', 'Antananarivo', 'Antananarivo', 587041, 13670507);
INSERT INTO `country` VALUES ('Mali', 'RMM', 'Bamako', 'Mali', 1240000, 9653261);
INSERT INTO `country` VALUES ('Niger', 'RN', 'Niamey', 'Niger', 1267000, 9113001);
INSERT INTO `country` VALUES ('Romania', 'RO', 'Bucharest', 'Bucuresti', 237500, 21657162);
INSERT INTO `country` VALUES ('South Korea', 'ROK', 'Seoul', 'South Korea', 98480, 45482291);
INSERT INTO `country` VALUES ('Uruguay', 'ROU', 'Montevideo', 'Uruguay', 176220, 3238952);
INSERT INTO `country` VALUES ('Philippines', 'RP', 'Manila', 'Philippines', 299764, 74480848);
INSERT INTO `country` VALUES ('South Africa', 'RSA', 'Pretoria', 'Gauteng', 1219910, 41743459);
INSERT INTO `country` VALUES ('San Marino', 'RSM', 'San Marino', 'San Marino', 60, 24521);
INSERT INTO `country` VALUES ('Togo', 'RT', 'Lome', 'Togo', 56790, 4570530);
INSERT INTO `country` VALUES ('Rwanda', 'RWA', 'Kigali', 'Rwanda', 26340, 6853359);
INSERT INTO `country` VALUES ('Sweden', 'S', 'Stockholm', 'Stockholm', 449964, 8900954);
INSERT INTO `country` VALUES ('Saudi Arabia', 'SA', 'Riyadh', 'Saudi Arabia', 1960580, 19409058);
INSERT INTO `country` VALUES ('Swaziland', 'SD', 'Mbabane', 'Swaziland', 17360, 998730);
INSERT INTO `country` VALUES ('Finland', 'SF', 'Helsinki', 'Uusimaa', 337030, 5105230);
INSERT INTO `country` VALUES ('Singapore', 'SGP', 'Singapore', 'Singapore', 632.6, 3396924);
INSERT INTO `country` VALUES ('Slovakia', 'SK', 'Bratislava', 'Slovakia', 48845, 5374362);
INSERT INTO `country` VALUES ('Solomon Islands', 'SLB', 'Honiara', 'Solomon Islands', 28450, 412902);
INSERT INTO `country` VALUES ('Slovenia', 'SLO', 'Ljubljana', 'Slovenia', 20256, 1951443);
INSERT INTO `country` VALUES ('Saint Martin', 'SMAR', 'Marigot', 'Saint Martin', 54, 29820);
INSERT INTO `country` VALUES ('Suriname', 'SME', 'Paramaribo', 'Suriname', 163270, 436418);
INSERT INTO `country` VALUES ('Senegal', 'SN', 'Dakar', 'Dakar', 196190, 9092749);
INSERT INTO `country` VALUES ('Somalia', 'SP', 'Mogadishu', 'Somalia', 637660, 9639151);
INSERT INTO `country` VALUES ('Saint Pierre and Miquelon', 'SPMI', 'Saint-Pierre', 'Saint Pierre and Miquelon', 242, 6809);
INSERT INTO `country` VALUES ('Serbia', 'SRB', 'Belgrade', 'Serbia', 77474, 7379339);
INSERT INTO `country` VALUES ('Sao Tome and Principe', 'STP', 'Sao Tome', 'Sao Tome and Principe', 1001, 144128);
INSERT INTO `country` VALUES ('Sudan', 'SUD', 'Khartoum', 'al Khartum', 2505810, 31547543);
INSERT INTO `country` VALUES ('Svalbard', 'SVAX', 'Longyearbyen', 'Svalbard', 62049, 2116);
INSERT INTO `country` VALUES ('Seychelles', 'SY', 'Victoria', 'Seychelles', 455, 77575);
INSERT INTO `country` VALUES ('Syria', 'SYR', 'Damascus', 'Syria', 185180, 15608648);
INSERT INTO `country` VALUES ('Tajikistan', 'TAD', 'Dushanbe', 'Dushanbe (munic.)', 143100, 5916373);
INSERT INTO `country` VALUES ('Chad', 'TCH', 'NDjamena', 'Chad', 1284000, 6976845);
INSERT INTO `country` VALUES ('Thailand', 'THA', 'Bangkok', 'Thailand', 514000, 58851357);
INSERT INTO `country` VALUES ('China', 'TJ', 'Beijing', 'Beijing (munic.)', 9596960, 1210004956);
INSERT INTO `country` VALUES ('Timor-Leste', 'TL', 'Dili', 'Timor-Leste', 15007, 1131612);
INSERT INTO `country` VALUES ('Turkmenistan', 'TM', 'Ashgabat', 'Ahal', 488100, 4149283);
INSERT INTO `country` VALUES ('Tunisia', 'TN', 'Tunis', 'Tunisia', 163610, 9019687);
INSERT INTO `country` VALUES ('Tonga', 'TO', 'Nukualofa', 'Tonga', 748, 106466);
INSERT INTO `country` VALUES ('Turkey', 'TR', 'Ankara', 'Ankara', 780580, 62484478);
INSERT INTO `country` VALUES ('Trinidad and Tobago', 'TT', 'Port-of-Spain', 'Trinidad and Tobago', 5130, 1272385);
INSERT INTO `country` VALUES ('Turks and Caicos Islands', 'TUCA', 'Grand Turk', 'Turks and Caicos Islands', 430, 22942);
INSERT INTO `country` VALUES ('Tuvalu', 'TUV', 'Funafuti', 'Tuvalu', 26, 10146);
INSERT INTO `country` VALUES ('Ukraine', 'UA', 'Kiev', 'Kyyivska', 603700, 50864009);
INSERT INTO `country` VALUES ('United Arab Emirates', 'UAE', 'Abu Dhabi', 'Abu Dhabi', 75581, 3057337);
INSERT INTO `country` VALUES ('United States', 'USA', 'Washington', 'Distr. Columbia', 9372610, 266476278);
INSERT INTO `country` VALUES ('Uzbekistan', 'UZB', 'Tashkent', 'Toshkent', 447400, 23418381);
INSERT INTO `country` VALUES ('Holy See', 'V', 'Vatican City', 'Holy See', 0.44, 840);
INSERT INTO `country` VALUES ('Virgin Islands', 'VIRG', 'Charlotte Amalie', 'Virgin Islands', 352, 97120);
INSERT INTO `country` VALUES ('Vietnam', 'VN', 'Hanoi', 'Vietnam', 329560, 73976973);
INSERT INTO `country` VALUES ('Vanuatu', 'VU', 'Port-Vila', 'Vanuatu', 14760, 177504);
INSERT INTO `country` VALUES ('Wallis and Futuna', 'WAFU', 'Mata-Utu', 'Wallis and Futuna', 274, 15289);
INSERT INTO `country` VALUES ('Gambia', 'WAG', 'Banjul', 'Gambia', 11300, 1204984);
INSERT INTO `country` VALUES ('Sierra Leone', 'WAL', 'Freetown', 'Sierra Leone', 71740, 4793121);
INSERT INTO `country` VALUES ('Nigeria', 'WAN', 'Abuja', 'Nigeria', 923770, 103912489);
INSERT INTO `country` VALUES ('Dominica', 'WD', 'Roseau', 'Dominica', 746, 82926);
INSERT INTO `country` VALUES ('West Bank', 'WEST', NULL, NULL, 5860, 1427741);
INSERT INTO `country` VALUES ('Grenada', 'WG', 'Saint Georges', 'Grenada', 344, 94961);
INSERT INTO `country` VALUES ('Saint Lucia', 'WL', 'Castries', 'Saint Lucia', 620, 157862);
INSERT INTO `country` VALUES ('Samoa', 'WS', 'Apia', 'Samoa', 2860, 214384);
INSERT INTO `country` VALUES ('Western Sahara', 'WSA', 'El Aaiun', 'Western Sahara', 266000, 222631);
INSERT INTO `country` VALUES ('Saint Vincent and the Grenadines', 'WV', 'Kingstown', 'Saint Vincent and the Grenadines', 389, 118344);
INSERT INTO `country` VALUES ('Christmas Island', 'XMAS', 'Flying Fish Cove', 'Christmas Island', 135, 1402);
INSERT INTO `country` VALUES ('Yemen', 'YE', 'Sanaa', 'Yemen', 527970, 13483178);
INSERT INTO `country` VALUES ('Venezuela', 'YV', 'Caracas', 'Distrito Federal', 912050, 21983188);
INSERT INTO `country` VALUES ('Zambia', 'Z', 'Lusaka', 'Lusaka', 752610, 9159072);
INSERT INTO `country` VALUES ('Zaire', 'ZRE', 'Kinshasa', 'Kinshasa', 2345410, 46498539);
INSERT INTO `country` VALUES ('Zimbabwe', 'ZW', 'Harare', 'Zimbabwe', 390580, 11271314);
COMMIT;

-- ----------------------------
-- Table structure for religion
-- ----------------------------
DROP TABLE IF EXISTS `religion`;
CREATE TABLE `religion` (
  `Country` varchar(4) NOT NULL DEFAULT '',
  `Name` varchar(50) NOT NULL DEFAULT '',
  `Percentage` float DEFAULT NULL,
  PRIMARY KEY (`Name`,`Country`) USING BTREE,
  KEY `ix_religion_Country` (`Country`) USING BTREE,
  CONSTRAINT `religion_ibfk_1` FOREIGN KEY (`Country`) REFERENCES `country` (`Code`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of religion
-- ----------------------------
BEGIN;
INSERT INTO `religion` VALUES ('BERM', 'African Methodist Episcopal', 11);
INSERT INTO `religion` VALUES ('AUS', 'Anglican', 26.1);
INSERT INTO `religion` VALUES ('AXA', 'Anglican', 29);
INSERT INTO `religion` VALUES ('BERM', 'Anglican', 23);
INSERT INTO `religion` VALUES ('BS', 'Anglican', 20);
INSERT INTO `religion` VALUES ('CAYM', 'Anglican', 5.7);
INSERT INTO `religion` VALUES ('CDN', 'Anglican', 8);
INSERT INTO `religion` VALUES ('IRL', 'Anglican', 3);
INSERT INTO `religion` VALUES ('NORF', 'Anglican', 39);
INSERT INTO `religion` VALUES ('NZ', 'Anglican', 24);
INSERT INTO `religion` VALUES ('PNG', 'Anglican', 5);
INSERT INTO `religion` VALUES ('SLB', 'Anglican', 34);
INSERT INTO `religion` VALUES ('SY', 'Anglican', 8);
INSERT INTO `religion` VALUES ('TT', 'Anglican', 14.4);
INSERT INTO `religion` VALUES ('TUCA', 'Anglican', 18);
INSERT INTO `religion` VALUES ('VU', 'Anglican', 15);
INSERT INTO `religion` VALUES ('WL', 'Anglican', 3);
INSERT INTO `religion` VALUES ('GE', 'Armenian Apostolic', 8);
INSERT INTO `religion` VALUES ('IR', 'Bahai', 1);
INSERT INTO `religion` VALUES ('TUV', 'Bahai', 1);
INSERT INTO `religion` VALUES ('BS', 'Baptist', 32);
INSERT INTO `religion` VALUES ('NZ', 'Baptist', 2);
INSERT INTO `religion` VALUES ('SLB', 'Baptist', 17);
INSERT INTO `religion` VALUES ('TUCA', 'Baptist', 40);
INSERT INTO `religion` VALUES ('VIRG', 'Baptist', 42);
INSERT INTO `religion` VALUES ('BHT', 'Buddhist', 75);
INSERT INTO `religion` VALUES ('BRU', 'Buddhist', 14);
INSERT INTO `religion` VALUES ('CL', 'Buddhist', 69);
INSERT INTO `religion` VALUES ('IND', 'Buddhist', 0.7);
INSERT INTO `religion` VALUES ('J', 'Buddhist', 84);
INSERT INTO `religion` VALUES ('K', 'Buddhist', 95);
INSERT INTO `religion` VALUES ('LAO', 'Buddhist', 60);
INSERT INTO `religion` VALUES ('MACX', 'Buddhist', 45);
INSERT INTO `religion` VALUES ('MYA', 'Buddhist', 89);
INSERT INTO `religion` VALUES ('NEP', 'Buddhist', 5);
INSERT INTO `religion` VALUES ('RI', 'Buddhist', 1);
INSERT INTO `religion` VALUES ('ROK', 'Buddhist', 47.4);
INSERT INTO `religion` VALUES ('RP', 'Buddhist', 3);
INSERT INTO `religion` VALUES ('THA', 'Buddhist', 95);
INSERT INTO `religion` VALUES ('XMAS', 'Buddhist', 36);
INSERT INTO `religion` VALUES ('ROK', 'Chondogyo', 0.2);
INSERT INTO `religion` VALUES ('AUS', 'Christian', 24.3);
INSERT INTO `religion` VALUES ('BEN', 'Christian', 15);
INSERT INTO `religion` VALUES ('BF', 'Christian', 10);
INSERT INTO `religion` VALUES ('BI', 'Christian', 67);
INSERT INTO `religion` VALUES ('BRU', 'Christian', 8);
INSERT INTO `religion` VALUES ('CAM', 'Christian', 33);
INSERT INTO `religion` VALUES ('CI', 'Christian', 12);
INSERT INTO `religion` VALUES ('CL', 'Christian', 8);
INSERT INTO `religion` VALUES ('COCO', 'Christian', 20);
INSERT INTO `religion` VALUES ('COOK', 'Christian', 100);
INSERT INTO `religion` VALUES ('DJI', 'Christian', 6);
INSERT INTO `religion` VALUES ('DZ', 'Christian', 0.5);
INSERT INTO `religion` VALUES ('FJI', 'Christian', 52);
INSERT INTO `religion` VALUES ('G', 'Christian', 55);
INSERT INTO `religion` VALUES ('GAZA', 'Christian', 0.7);
INSERT INTO `religion` VALUES ('GH', 'Christian', 24);
INSERT INTO `religion` VALUES ('GNB', 'Christian', 5);
INSERT INTO `religion` VALUES ('GUY', 'Christian', 57);
INSERT INTO `religion` VALUES ('HONX', 'Christian', 10);
INSERT INTO `religion` VALUES ('IL', 'Christian', 2);
INSERT INTO `religion` VALUES ('IND', 'Christian', 2.4);
INSERT INTO `religion` VALUES ('IRQ', 'Christian', 3);
INSERT INTO `religion` VALUES ('JOR', 'Christian', 8);
INSERT INTO `religion` VALUES ('LB', 'Christian', 10);
INSERT INTO `religion` VALUES ('LS', 'Christian', 80);
INSERT INTO `religion` VALUES ('MA', 'Christian', 1.1);
INSERT INTO `religion` VALUES ('MH', 'Christian', 100);
INSERT INTO `religion` VALUES ('MOC', 'Christian', 30);
INSERT INTO `religion` VALUES ('MS', 'Christian', 28.3);
INSERT INTO `religion` VALUES ('MYA', 'Christian', 4);
INSERT INTO `religion` VALUES ('NAU', 'Christian', 100);
INSERT INTO `religion` VALUES ('RB', 'Christian', 50);
INSERT INTO `religion` VALUES ('RC', 'Christian', 4.5);
INSERT INTO `religion` VALUES ('RCB', 'Christian', 50);
INSERT INTO `religion` VALUES ('RG', 'Christian', 8);
INSERT INTO `religion` VALUES ('RL', 'Christian', 30);
INSERT INTO `religion` VALUES ('RM', 'Christian', 41);
INSERT INTO `religion` VALUES ('RMM', 'Christian', 1);
INSERT INTO `religion` VALUES ('ROK', 'Christian', 48.6);
INSERT INTO `religion` VALUES ('RT', 'Christian', 20);
INSERT INTO `religion` VALUES ('SD', 'Christian', 60);
INSERT INTO `religion` VALUES ('SN', 'Christian', 2);
INSERT INTO `religion` VALUES ('SUD', 'Christian', 5);
INSERT INTO `religion` VALUES ('SYR', 'Christian', 10);
INSERT INTO `religion` VALUES ('TCH', 'Christian', 25);
INSERT INTO `religion` VALUES ('THA', 'Christian', 0.5);
INSERT INTO `religion` VALUES ('TJ', 'Christian', 1);
INSERT INTO `religion` VALUES ('TN', 'Christian', 1);
INSERT INTO `religion` VALUES ('TO', 'Christian', 100);
INSERT INTO `religion` VALUES ('WAG', 'Christian', 9);
INSERT INTO `religion` VALUES ('WAL', 'Christian', 10);
INSERT INTO `religion` VALUES ('WAN', 'Christian', 40);
INSERT INTO `religion` VALUES ('WEST', 'Christian', 8);
INSERT INTO `religion` VALUES ('WS', 'Christian', 99.7);
INSERT INTO `religion` VALUES ('XMAS', 'Christian', 18);
INSERT INTO `religion` VALUES ('Z', 'Christian', 60);
INSERT INTO `religion` VALUES ('ZW', 'Christian', 25);
INSERT INTO `religion` VALUES ('AMSA', 'Christian Congregationalist', 50);
INSERT INTO `religion` VALUES ('AL', 'Christian Orthodox', 20);
INSERT INTO `religion` VALUES ('ARM', 'Christian Orthodox', 94);
INSERT INTO `religion` VALUES ('AZ', 'Christian Orthodox', 4.8);
INSERT INTO `religion` VALUES ('BG', 'Christian Orthodox', 85);
INSERT INTO `religion` VALUES ('BIH', 'Christian Orthodox', 31);
INSERT INTO `religion` VALUES ('BY', 'Christian Orthodox', 60);
INSERT INTO `religion` VALUES ('CY', 'Christian Orthodox', 78);
INSERT INTO `religion` VALUES ('CZ', 'Christian Orthodox', 3);
INSERT INTO `religion` VALUES ('ETH', 'Christian Orthodox', 35);
INSERT INTO `religion` VALUES ('GE', 'Christian Orthodox', 75);
INSERT INTO `religion` VALUES ('GR', 'Christian Orthodox', 98);
INSERT INTO `religion` VALUES ('HR', 'Christian Orthodox', 11.1);
INSERT INTO `religion` VALUES ('KAZ', 'Christian Orthodox', 44);
INSERT INTO `religion` VALUES ('MD', 'Christian Orthodox', 98.5);
INSERT INTO `religion` VALUES ('MK', 'Christian Orthodox', 67);
INSERT INTO `religion` VALUES ('MNE', 'Christian Orthodox', 74.2);
INSERT INTO `religion` VALUES ('RO', 'Christian Orthodox', 70);
INSERT INTO `religion` VALUES ('SF', 'Christian Orthodox', 1);
INSERT INTO `religion` VALUES ('SK', 'Christian Orthodox', 4.1);
INSERT INTO `religion` VALUES ('SRB', 'Christian Orthodox', 85);
INSERT INTO `religion` VALUES ('TM', 'Christian Orthodox', 11);
INSERT INTO `religion` VALUES ('UZB', 'Christian Orthodox', 9);
INSERT INTO `religion` VALUES ('VU', 'Church Christ', 3.8);
INSERT INTO `religion` VALUES ('BS', 'Church of God', 6);
INSERT INTO `religion` VALUES ('CAYM', 'Church of God', 26);
INSERT INTO `religion` VALUES ('TUCA', 'Church of God', 12);
INSERT INTO `religion` VALUES ('TUV', 'Church Tuvalu', 97);
INSERT INTO `religion` VALUES ('ROK', 'Confucianism', 3);
INSERT INTO `religion` VALUES ('ET', 'Coptic Christian', 6);
INSERT INTO `religion` VALUES ('IL', 'Druze', 2);
INSERT INTO `religion` VALUES ('NIUE', 'Ekalesia Niue', 61);
INSERT INTO `religion` VALUES ('VIRG', 'Episcopalian', 17);
INSERT INTO `religion` VALUES ('PNG', 'Evangelical Alliance', 4);
INSERT INTO `religion` VALUES ('BD', 'Hindu', 16);
INSERT INTO `religion` VALUES ('BHT', 'Hindu', 25);
INSERT INTO `religion` VALUES ('CL', 'Hindu', 15);
INSERT INTO `religion` VALUES ('FJI', 'Hindu', 38);
INSERT INTO `religion` VALUES ('GUAD', 'Hindu', 4);
INSERT INTO `religion` VALUES ('GUY', 'Hindu', 33);
INSERT INTO `religion` VALUES ('IND', 'Hindu', 80);
INSERT INTO `religion` VALUES ('MART', 'Hindu', 5);
INSERT INTO `religion` VALUES ('MS', 'Hindu', 52);
INSERT INTO `religion` VALUES ('NEP', 'Hindu', 90);
INSERT INTO `religion` VALUES ('RI', 'Hindu', 2);
INSERT INTO `religion` VALUES ('SME', 'Hindu', 27.4);
INSERT INTO `religion` VALUES ('THA', 'Hindu', 0.1);
INSERT INTO `religion` VALUES ('TT', 'Hindu', 24.3);
INSERT INTO `religion` VALUES ('IND', 'Jains', 0.5);
INSERT INTO `religion` VALUES ('BG', 'Jewish', 0.8);
INSERT INTO `religion` VALUES ('DZ', 'Jewish', 0.5);
INSERT INTO `religion` VALUES ('F', 'Jewish', 1);
INSERT INTO `religion` VALUES ('GAZA', 'Jewish', 0.6);
INSERT INTO `religion` VALUES ('GBZ', 'Jewish', 2);
INSERT INTO `religion` VALUES ('L', 'Jewish', 3);
INSERT INTO `religion` VALUES ('MA', 'Jewish', 0.2);
INSERT INTO `religion` VALUES ('MD', 'Jewish', 1.5);
INSERT INTO `religion` VALUES ('RA', 'Jewish', 2);
INSERT INTO `religion` VALUES ('ROU', 'Jewish', 2);
INSERT INTO `religion` VALUES ('TN', 'Jewish', 1);
INSERT INTO `religion` VALUES ('USA', 'Jewish', 2);
INSERT INTO `religion` VALUES ('WEST', 'Jewish', 17);
INSERT INTO `religion` VALUES ('IL', 'Judaism', 82);
INSERT INTO `religion` VALUES ('ZRE', 'Kimbanguist', 10);
INSERT INTO `religion` VALUES ('AXA', 'Methodist', 23.9);
INSERT INTO `religion` VALUES ('BS', 'Methodist', 6);
INSERT INTO `religion` VALUES ('NZ', 'Methodist', 5);
INSERT INTO `religion` VALUES ('TUCA', 'Methodist', 16);
INSERT INTO `religion` VALUES ('KIR', 'Mormon', 6);
INSERT INTO `religion` VALUES ('NIUE', 'Mormon', 10);
INSERT INTO `religion` VALUES ('AFG', 'Muslim', 99);
INSERT INTO `religion` VALUES ('AL', 'Muslim', 70);
INSERT INTO `religion` VALUES ('AZ', 'Muslim', 93.4);
INSERT INTO `religion` VALUES ('BD', 'Muslim', 83);
INSERT INTO `religion` VALUES ('BEN', 'Muslim', 15);
INSERT INTO `religion` VALUES ('BF', 'Muslim', 50);
INSERT INTO `religion` VALUES ('BG', 'Muslim', 13);
INSERT INTO `religion` VALUES ('BI', 'Muslim', 1);
INSERT INTO `religion` VALUES ('BIH', 'Muslim', 40);
INSERT INTO `religion` VALUES ('BRN', 'Muslim', 100);
INSERT INTO `religion` VALUES ('BRU', 'Muslim', 63);
INSERT INTO `religion` VALUES ('CAM', 'Muslim', 16);
INSERT INTO `religion` VALUES ('CI', 'Muslim', 60);
INSERT INTO `religion` VALUES ('CL', 'Muslim', 8);
INSERT INTO `religion` VALUES ('COCO', 'Muslim', 80);
INSERT INTO `religion` VALUES ('COM', 'Muslim', 86);
INSERT INTO `religion` VALUES ('CY', 'Muslim', 18);
INSERT INTO `religion` VALUES ('DJI', 'Muslim', 94);
INSERT INTO `religion` VALUES ('DZ', 'Muslim', 99);
INSERT INTO `religion` VALUES ('EAU', 'Muslim', 16);
INSERT INTO `religion` VALUES ('ET', 'Muslim', 94);
INSERT INTO `religion` VALUES ('ETH', 'Muslim', 45);
INSERT INTO `religion` VALUES ('F', 'Muslim', 1);
INSERT INTO `religion` VALUES ('FJI', 'Muslim', 8);
INSERT INTO `religion` VALUES ('G', 'Muslim', 1);
INSERT INTO `religion` VALUES ('GAZA', 'Muslim', 98.7);
INSERT INTO `religion` VALUES ('GBZ', 'Muslim', 8);
INSERT INTO `religion` VALUES ('GE', 'Muslim', 11);
INSERT INTO `religion` VALUES ('GH', 'Muslim', 30);
INSERT INTO `religion` VALUES ('GNB', 'Muslim', 30);
INSERT INTO `religion` VALUES ('GR', 'Muslim', 1.3);
INSERT INTO `religion` VALUES ('GUY', 'Muslim', 9);
INSERT INTO `religion` VALUES ('HR', 'Muslim', 1.2);
INSERT INTO `religion` VALUES ('IL', 'Muslim', 14);
INSERT INTO `religion` VALUES ('IND', 'Muslim', 14);
INSERT INTO `religion` VALUES ('IR', 'Muslim', 99);
INSERT INTO `religion` VALUES ('IRQ', 'Muslim', 97);
INSERT INTO `religion` VALUES ('JOR', 'Muslim', 92);
INSERT INTO `religion` VALUES ('KAZ', 'Muslim', 47);
INSERT INTO `religion` VALUES ('KWT', 'Muslim', 85);
INSERT INTO `religion` VALUES ('LAR', 'Muslim', 97);
INSERT INTO `religion` VALUES ('LB', 'Muslim', 20);
INSERT INTO `religion` VALUES ('MA', 'Muslim', 98.7);
INSERT INTO `religion` VALUES ('MAYO', 'Muslim', 97);
INSERT INTO `religion` VALUES ('MK', 'Muslim', 30);
INSERT INTO `religion` VALUES ('MNE', 'Muslim', 17.7);
INSERT INTO `religion` VALUES ('MNG', 'Muslim', 4);
INSERT INTO `religion` VALUES ('MOC', 'Muslim', 20);
INSERT INTO `religion` VALUES ('MS', 'Muslim', 16.6);
INSERT INTO `religion` VALUES ('MV', 'Muslim', 100);
INSERT INTO `religion` VALUES ('MW', 'Muslim', 20);
INSERT INTO `religion` VALUES ('MYA', 'Muslim', 4);
INSERT INTO `religion` VALUES ('NEP', 'Muslim', 3);
INSERT INTO `religion` VALUES ('NL', 'Muslim', 3);
INSERT INTO `religion` VALUES ('OM', 'Muslim', 75);
INSERT INTO `religion` VALUES ('PK', 'Muslim', 97);
INSERT INTO `religion` VALUES ('Q', 'Muslim', 95);
INSERT INTO `religion` VALUES ('RCA', 'Muslim', 15);
INSERT INTO `religion` VALUES ('RCB', 'Muslim', 2);
INSERT INTO `religion` VALUES ('RG', 'Muslim', 85);
INSERT INTO `religion` VALUES ('RI', 'Muslim', 87);
INSERT INTO `religion` VALUES ('RIM', 'Muslim', 100);
INSERT INTO `religion` VALUES ('RL', 'Muslim', 70);
INSERT INTO `religion` VALUES ('RM', 'Muslim', 7);
INSERT INTO `religion` VALUES ('RMM', 'Muslim', 90);
INSERT INTO `religion` VALUES ('RN', 'Muslim', 80);
INSERT INTO `religion` VALUES ('RP', 'Muslim', 5);
INSERT INTO `religion` VALUES ('RSA', 'Muslim', 2);
INSERT INTO `religion` VALUES ('RT', 'Muslim', 10);
INSERT INTO `religion` VALUES ('RWA', 'Muslim', 1);
INSERT INTO `religion` VALUES ('SA', 'Muslim', 100);
INSERT INTO `religion` VALUES ('SLO', 'Muslim', 1);
INSERT INTO `religion` VALUES ('SME', 'Muslim', 19.6);
INSERT INTO `religion` VALUES ('SN', 'Muslim', 92);
INSERT INTO `religion` VALUES ('SP', 'Muslim', 100);
INSERT INTO `religion` VALUES ('SRB', 'Muslim', 3.2);
INSERT INTO `religion` VALUES ('SUD', 'Muslim', 70);
INSERT INTO `religion` VALUES ('SYR', 'Muslim', 90);
INSERT INTO `religion` VALUES ('TAD', 'Muslim', 85);
INSERT INTO `religion` VALUES ('TCH', 'Muslim', 50);
INSERT INTO `religion` VALUES ('THA', 'Muslim', 3.8);
INSERT INTO `religion` VALUES ('TJ', 'Muslim', 2);
INSERT INTO `religion` VALUES ('TL', 'Muslim', 1);
INSERT INTO `religion` VALUES ('TM', 'Muslim', 87);
INSERT INTO `religion` VALUES ('TN', 'Muslim', 98);
INSERT INTO `religion` VALUES ('TR', 'Muslim', 99.8);
INSERT INTO `religion` VALUES ('TT', 'Muslim', 6);
INSERT INTO `religion` VALUES ('UAE', 'Muslim', 96);
INSERT INTO `religion` VALUES ('UZB', 'Muslim', 88);
INSERT INTO `religion` VALUES ('WAG', 'Muslim', 90);
INSERT INTO `religion` VALUES ('WAL', 'Muslim', 60);
INSERT INTO `religion` VALUES ('WAN', 'Muslim', 50);
INSERT INTO `religion` VALUES ('WEST', 'Muslim', 75);
INSERT INTO `religion` VALUES ('WSA', 'Muslim', 100);
INSERT INTO `religion` VALUES ('XMAS', 'Muslim', 25);
INSERT INTO `religion` VALUES ('Z', 'Muslim', 1);
INSERT INTO `religion` VALUES ('ZRE', 'Muslim', 10);
INSERT INTO `religion` VALUES ('ZW', 'Muslim', 1);
INSERT INTO `religion` VALUES ('S', 'Pentecostal', 1);
INSERT INTO `religion` VALUES ('NZ', 'Presbyterian', 18);
INSERT INTO `religion` VALUES ('PNG', 'Presbyterian', 8);
INSERT INTO `religion` VALUES ('VU', 'Presbyterian', 36.7);
INSERT INTO `religion` VALUES ('A', 'Protestant', 6);
INSERT INTO `religion` VALUES ('AMSA', 'Protestant', 30);
INSERT INTO `religion` VALUES ('ANG', 'Protestant', 15);
INSERT INTO `religion` VALUES ('ARU', 'Protestant', 9);
INSERT INTO `religion` VALUES ('AXA', 'Protestant', 30.2);
INSERT INTO `religion` VALUES ('B', 'Protestant', 25);
INSERT INTO `religion` VALUES ('BDS', 'Protestant', 67);
INSERT INTO `religion` VALUES ('BERM', 'Protestant', 18);
INSERT INTO `religion` VALUES ('BIH', 'Protestant', 4);
INSERT INTO `religion` VALUES ('BS', 'Protestant', 12);
INSERT INTO `religion` VALUES ('BVIR', 'Protestant', 86);
INSERT INTO `religion` VALUES ('BZ', 'Protestant', 30);
INSERT INTO `religion` VALUES ('CH', 'Protestant', 44.3);
INSERT INTO `religion` VALUES ('CZ', 'Protestant', 4.6);
INSERT INTO `religion` VALUES ('D', 'Protestant', 45);
INSERT INTO `religion` VALUES ('DK', 'Protestant', 91);
INSERT INTO `religion` VALUES ('EAK', 'Protestant', 38);
INSERT INTO `religion` VALUES ('EAU', 'Protestant', 33);
INSERT INTO `religion` VALUES ('F', 'Protestant', 2);
INSERT INTO `religion` VALUES ('FARX', 'Protestant', 100);
INSERT INTO `religion` VALUES ('FL', 'Protestant', 8.3);
INSERT INTO `religion` VALUES ('FPOL', 'Protestant', 54);
INSERT INTO `religion` VALUES ('FSM', 'Protestant', 47);
INSERT INTO `religion` VALUES ('GBZ', 'Protestant', 11);
INSERT INTO `religion` VALUES ('GROX', 'Protestant', 100);
INSERT INTO `religion` VALUES ('GUAD', 'Protestant', 1);
INSERT INTO `religion` VALUES ('H', 'Protestant', 25);
INSERT INTO `religion` VALUES ('HR', 'Protestant', 0.4);
INSERT INTO `religion` VALUES ('IS', 'Protestant', 96);
INSERT INTO `religion` VALUES ('JA', 'Protestant', 55.9);
INSERT INTO `religion` VALUES ('KAZ', 'Protestant', 2);
INSERT INTO `religion` VALUES ('KIR', 'Protestant', 40.9);
INSERT INTO `religion` VALUES ('MACX', 'Protestant', 1);
INSERT INTO `religion` VALUES ('MEX', 'Protestant', 6);
INSERT INTO `religion` VALUES ('MW', 'Protestant', 55);
INSERT INTO `religion` VALUES ('N', 'Protestant', 87.8);
INSERT INTO `religion` VALUES ('NAM', 'Protestant', 50);
INSERT INTO `religion` VALUES ('NCA', 'Protestant', 30);
INSERT INTO `religion` VALUES ('NIC', 'Protestant', 5);
INSERT INTO `religion` VALUES ('NL', 'Protestant', 25);
INSERT INTO `religion` VALUES ('NZ', 'Protestant', 3);
INSERT INTO `religion` VALUES ('P', 'Protestant', 1);
INSERT INTO `religion` VALUES ('PA', 'Protestant', 15);
INSERT INTO `religion` VALUES ('PNG', 'Protestant', 26);
INSERT INTO `religion` VALUES ('PR', 'Protestant', 15);
INSERT INTO `religion` VALUES ('RA', 'Protestant', 2);
INSERT INTO `religion` VALUES ('RCA', 'Protestant', 25);
INSERT INTO `religion` VALUES ('RCH', 'Protestant', 11);
INSERT INTO `religion` VALUES ('RH', 'Protestant', 16);
INSERT INTO `religion` VALUES ('RI', 'Protestant', 6);
INSERT INTO `religion` VALUES ('RO', 'Protestant', 6);
INSERT INTO `religion` VALUES ('ROU', 'Protestant', 2);
INSERT INTO `religion` VALUES ('RP', 'Protestant', 9);
INSERT INTO `religion` VALUES ('RWA', 'Protestant', 9);
INSERT INTO `religion` VALUES ('S', 'Protestant', 94);
INSERT INTO `religion` VALUES ('SF', 'Protestant', 89);
INSERT INTO `religion` VALUES ('SK', 'Protestant', 8.4);
INSERT INTO `religion` VALUES ('SLB', 'Protestant', 5);
INSERT INTO `religion` VALUES ('SME', 'Protestant', 25.2);
INSERT INTO `religion` VALUES ('SRB', 'Protestant', 1.1);
INSERT INTO `religion` VALUES ('TL', 'Protestant', 1);
INSERT INTO `religion` VALUES ('TT', 'Protestant', 14);
INSERT INTO `religion` VALUES ('USA', 'Protestant', 56);
INSERT INTO `religion` VALUES ('WD', 'Protestant', 15);
INSERT INTO `religion` VALUES ('WL', 'Protestant', 7);
INSERT INTO `religion` VALUES ('YV', 'Protestant', 2);
INSERT INTO `religion` VALUES ('ZRE', 'Protestant', 20);
INSERT INTO `religion` VALUES ('A', 'Roman Catholic', 85);
INSERT INTO `religion` VALUES ('AL', 'Roman Catholic', 10);
INSERT INTO `religion` VALUES ('AMSA', 'Roman Catholic', 20);
INSERT INTO `religion` VALUES ('AND', 'Roman Catholic', 100);
INSERT INTO `religion` VALUES ('ANG', 'Roman Catholic', 38);
INSERT INTO `religion` VALUES ('ARU', 'Roman Catholic', 80.8);
INSERT INTO `religion` VALUES ('AUS', 'Roman Catholic', 26);
INSERT INTO `religion` VALUES ('AXA', 'Roman Catholic', 5.7);
INSERT INTO `religion` VALUES ('B', 'Roman Catholic', 75);
INSERT INTO `religion` VALUES ('BDS', 'Roman Catholic', 4);
INSERT INTO `religion` VALUES ('BERM', 'Roman Catholic', 15);
INSERT INTO `religion` VALUES ('BG', 'Roman Catholic', 0.7);
INSERT INTO `religion` VALUES ('BIH', 'Roman Catholic', 15);
INSERT INTO `religion` VALUES ('BOL', 'Roman Catholic', 95);
INSERT INTO `religion` VALUES ('BR', 'Roman Catholic', 70);
INSERT INTO `religion` VALUES ('BS', 'Roman Catholic', 19);
INSERT INTO `religion` VALUES ('BVIR', 'Roman Catholic', 10);
INSERT INTO `religion` VALUES ('BZ', 'Roman Catholic', 62);
INSERT INTO `religion` VALUES ('C', 'Roman Catholic', 85);
INSERT INTO `religion` VALUES ('CAYM', 'Roman Catholic', 11);
INSERT INTO `religion` VALUES ('CDN', 'Roman Catholic', 45);
INSERT INTO `religion` VALUES ('CH', 'Roman Catholic', 47.6);
INSERT INTO `religion` VALUES ('CO', 'Roman Catholic', 95);
INSERT INTO `religion` VALUES ('COM', 'Roman Catholic', 14);
INSERT INTO `religion` VALUES ('CR', 'Roman Catholic', 95);
INSERT INTO `religion` VALUES ('CV', 'Roman Catholic', 100);
INSERT INTO `religion` VALUES ('CZ', 'Roman Catholic', 39.2);
INSERT INTO `religion` VALUES ('D', 'Roman Catholic', 37);
INSERT INTO `religion` VALUES ('DK', 'Roman Catholic', 2);
INSERT INTO `religion` VALUES ('DOM', 'Roman Catholic', 95);
INSERT INTO `religion` VALUES ('E', 'Roman Catholic', 99);
INSERT INTO `religion` VALUES ('EAK', 'Roman Catholic', 28);
INSERT INTO `religion` VALUES ('EAU', 'Roman Catholic', 33);
INSERT INTO `religion` VALUES ('EC', 'Roman Catholic', 95);
INSERT INTO `religion` VALUES ('ES', 'Roman Catholic', 75);
INSERT INTO `religion` VALUES ('F', 'Roman Catholic', 90);
INSERT INTO `religion` VALUES ('FGU', 'Roman Catholic', 100);
INSERT INTO `religion` VALUES ('FL', 'Roman Catholic', 87.3);
INSERT INTO `religion` VALUES ('FPOL', 'Roman Catholic', 30);
INSERT INTO `religion` VALUES ('FSM', 'Roman Catholic', 50);
INSERT INTO `religion` VALUES ('GBZ', 'Roman Catholic', 74);
INSERT INTO `religion` VALUES ('GQ', 'Roman Catholic', 100);
INSERT INTO `religion` VALUES ('GUAD', 'Roman Catholic', 95);
INSERT INTO `religion` VALUES ('GUAM', 'Roman Catholic', 95);
INSERT INTO `religion` VALUES ('H', 'Roman Catholic', 67.5);
INSERT INTO `religion` VALUES ('HCA', 'Roman Catholic', 97);
INSERT INTO `religion` VALUES ('HR', 'Roman Catholic', 76.5);
INSERT INTO `religion` VALUES ('I', 'Roman Catholic', 98);
INSERT INTO `religion` VALUES ('IRL', 'Roman Catholic', 93);
INSERT INTO `religion` VALUES ('IS', 'Roman Catholic', 3);
INSERT INTO `religion` VALUES ('JA', 'Roman Catholic', 5);
INSERT INTO `religion` VALUES ('KIR', 'Roman Catholic', 52.6);
INSERT INTO `religion` VALUES ('L', 'Roman Catholic', 97);
INSERT INTO `religion` VALUES ('M', 'Roman Catholic', 98);
INSERT INTO `religion` VALUES ('MACX', 'Roman Catholic', 7);
INSERT INTO `religion` VALUES ('MART', 'Roman Catholic', 95);
INSERT INTO `religion` VALUES ('MC', 'Roman Catholic', 95);
INSERT INTO `religion` VALUES ('MEX', 'Roman Catholic', 89);
INSERT INTO `religion` VALUES ('MNE', 'Roman Catholic', 3.5);
INSERT INTO `religion` VALUES ('MW', 'Roman Catholic', 20);
INSERT INTO `religion` VALUES ('N', 'Roman Catholic', 1);
INSERT INTO `religion` VALUES ('NCA', 'Roman Catholic', 60);
INSERT INTO `religion` VALUES ('NIC', 'Roman Catholic', 95);
INSERT INTO `religion` VALUES ('NIUE', 'Roman Catholic', 7.2);
INSERT INTO `religion` VALUES ('NL', 'Roman Catholic', 34);
INSERT INTO `religion` VALUES ('NORF', 'Roman Catholic', 11.7);
INSERT INTO `religion` VALUES ('NZ', 'Roman Catholic', 15);
INSERT INTO `religion` VALUES ('P', 'Roman Catholic', 97);
INSERT INTO `religion` VALUES ('PA', 'Roman Catholic', 85);
INSERT INTO `religion` VALUES ('PE', 'Roman Catholic', 100);
INSERT INTO `religion` VALUES ('PL', 'Roman Catholic', 95);
INSERT INTO `religion` VALUES ('PNG', 'Roman Catholic', 22);
INSERT INTO `religion` VALUES ('PR', 'Roman Catholic', 85);
INSERT INTO `religion` VALUES ('PY', 'Roman Catholic', 90);
INSERT INTO `religion` VALUES ('RA', 'Roman Catholic', 90);
INSERT INTO `religion` VALUES ('RCA', 'Roman Catholic', 25);
INSERT INTO `religion` VALUES ('RCH', 'Roman Catholic', 89);
INSERT INTO `religion` VALUES ('REUN', 'Roman Catholic', 94);
INSERT INTO `religion` VALUES ('RH', 'Roman Catholic', 80);
INSERT INTO `religion` VALUES ('RI', 'Roman Catholic', 3);
INSERT INTO `religion` VALUES ('RO', 'Roman Catholic', 6);
INSERT INTO `religion` VALUES ('ROU', 'Roman Catholic', 66);
INSERT INTO `religion` VALUES ('RP', 'Roman Catholic', 83);
INSERT INTO `religion` VALUES ('RSM', 'Roman Catholic', 100);
INSERT INTO `religion` VALUES ('RWA', 'Roman Catholic', 65);
INSERT INTO `religion` VALUES ('S', 'Roman Catholic', 1.5);
INSERT INTO `religion` VALUES ('SK', 'Roman Catholic', 60.3);
INSERT INTO `religion` VALUES ('SLB', 'Roman Catholic', 19);
INSERT INTO `religion` VALUES ('SLO', 'Roman Catholic', 96);
INSERT INTO `religion` VALUES ('SME', 'Roman Catholic', 22.8);
INSERT INTO `religion` VALUES ('SPMI', 'Roman Catholic', 99);
INSERT INTO `religion` VALUES ('SRB', 'Roman Catholic', 5.5);
INSERT INTO `religion` VALUES ('SY', 'Roman Catholic', 90);
INSERT INTO `religion` VALUES ('TL', 'Roman Catholic', 98);
INSERT INTO `religion` VALUES ('TT', 'Roman Catholic', 32.2);
INSERT INTO `religion` VALUES ('USA', 'Roman Catholic', 28);
INSERT INTO `religion` VALUES ('V', 'Roman Catholic', 100);
INSERT INTO `religion` VALUES ('VIRG', 'Roman Catholic', 34);
INSERT INTO `religion` VALUES ('VU', 'Roman Catholic', 15);
INSERT INTO `religion` VALUES ('WAFU', 'Roman Catholic', 99);
INSERT INTO `religion` VALUES ('WD', 'Roman Catholic', 77);
INSERT INTO `religion` VALUES ('WL', 'Roman Catholic', 90);
INSERT INTO `religion` VALUES ('YV', 'Roman Catholic', 96);
INSERT INTO `religion` VALUES ('ZRE', 'Roman Catholic', 50);
INSERT INTO `religion` VALUES ('BERM', 'Seventh-Day Adventist', 5);
INSERT INTO `religion` VALUES ('NORF', 'Seventh-Day Adventist', 4.4);
INSERT INTO `religion` VALUES ('PITC', 'Seventh-Day Adventist', 100);
INSERT INTO `religion` VALUES ('PNG', 'Seventh-Day Adventist', 1);
INSERT INTO `religion` VALUES ('SLB', 'Seventh-Day Adventist', 10);
INSERT INTO `religion` VALUES ('TUV', 'Seventh-Day Adventist', 1.4);
INSERT INTO `religion` VALUES ('VU', 'Seventh-Day Adventist', 6.2);
INSERT INTO `religion` VALUES ('IND', 'Sikh', 2);
INSERT INTO `religion` VALUES ('RC', 'Taoist', 93);
INSERT INTO `religion` VALUES ('SLB', 'United', 11);
INSERT INTO `religion` VALUES ('CAYM', 'United Church', 11.8);
INSERT INTO `religion` VALUES ('CDN', 'United Church', 12);
INSERT INTO `religion` VALUES ('NORF', 'Uniting Church Australia', 16.4);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
