/********************************************************/
/* Source, World Health Organization, March 12 2021     */
/********************************************************/
DROP   TABLE covid;
CREATE TABLE covid
(
    id              INT         PRIMARY KEY,
    country         VARCHAR(99) NOT NULL,
    region          VARCHAR(99) NOT NULL,
    population      INT         NOT NULL,
    cases           INT         NOT NULL,
    cases_last7days INT         NOT NULL,
    cases_last24hrs INT         NOT NULL,
    death           INT         NOT NULL,
    death_last7days INT         NOT NULL,
    death_last24hrs INT         NOT NULL,
    xmit_class      VARCHAR(9)  
);
INSERT INTO covid VALUES (1, 'China', 'Asia', 1471597122, 102276, 240, 73, 4849, 3, 0, 'CC');
INSERT INTO covid VALUES (2, 'India', 'Asia', 1380007793, 11333728, 141640, 24882, 158446, 790, 140, 'CC');
INSERT INTO covid VALUES (3, 'United States', 'North America', 331002599, 29000561, 531825, 60312, 527068, 12055, 1570, 'CT');
INSERT INTO covid VALUES (4, 'Indonesia', 'South-East Asia', 273525624, 1410134, 42065, 6412, 38229, 1203, 180, 'CT');
INSERT INTO covid VALUES (5, 'Pakistan', 'Asia', 220888415, 600198, 13184, 2701, 13430, 302, 53, 'CT');
INSERT INTO covid VALUES (6, 'Brazil', 'South America', 212559314, 11277717, 483985, 75412, 272889, 11919, 2233, 'CT');
INSERT INTO covid VALUES (7, 'Nigeria', 'Africa', 206135253, 160332, 2290, 399, 2009, 55, 8, 'CT');
INSERT INTO covid VALUES (8, 'Bangladesh', 'South-East Asia', 164690772, 555222, 6038, 1066, 8515, 74, 13, 'CT');
INSERT INTO covid VALUES (9, 'Russia', 'Europe', 145934317, 4380525, 68344, 9908, 91695, 2969, 475, 'CC');
INSERT INTO covid VALUES (10, 'Mexico', 'Central America', 128933005, 2151028, 38520, 6470, 193142, 4276, 654, 'CT');
INSERT INTO covid VALUES (11, 'Japan', 'Western Pacific', 126475263, 445585, 7693, 1296, 8509, 331, 58, 'CC');
INSERT INTO covid VALUES (12, 'Ethiopia', 'Africa', 114963027, 172571, 8499, 1361, 2510, 106, 27, 'CT');
INSERT INTO covid VALUES (13, 'Philippines', 'Western Pacific', 109581467, 611618, 23914, 4570, 12694, 271, 86, 'CT');
INSERT INTO covid VALUES (14, 'Egypt', 'Africa', 102336086, 189639, 4305, 639, 11214, 298, 45, 'CC');
INSERT INTO covid VALUES (15, 'Viet Nam', 'South-East Asia', 97328244, 2550, 49, 15, 35, 0, 0, 'CC');
INSERT INTO covid VALUES (16, 'Congo', 'Africa', 89572906, 26845, 506, 108, 712, 1, 0, 'CT');
INSERT INTO covid VALUES (17, 'Turkey', 'Middle East', 84339057, 2850930, 93470, 14941, 29356, 455, 66, 'CT');
INSERT INTO covid VALUES (18, 'Iran', 'Middle East', 83993015, 1731558, 58088, 8088, 61069, 557, 53, 'CT');
INSERT INTO covid VALUES (19, 'Germany', 'Europe', 83784054, 2558455, 66376, 12674, 73301, 1497, 239, 'CT');
INSERT INTO covid VALUES (20, 'Thailand', 'South-East Asia', 69806940, 26757, 452, 78, 86, 1, 1, 'CC');
INSERT INTO covid VALUES (21, 'United Kingdom', 'Europe', 67885963, 4248290, 40982, 6609, 125343, 1082, 175, 'CT');
INSERT INTO covid VALUES (22, 'France', 'Europe', 65273557, 3946733, 155150, 25120, 89632, 1856, 290, 'CT');
INSERT INTO covid VALUES (23, 'Italy', 'Europe', 60461849, 3175807, 152678, 26790, 101564, 2293, 380, 'CC');
INSERT INTO covid VALUES (24, 'Tanzania', 'Africa', 59882353, 509, 0, 0, 21, 0, 0, 'P');
INSERT INTO covid VALUES (25, 'South Africa', 'Africa', 59308707, 1526873, 7894, 1225, 51179, 613, 69, 'CT');
INSERT INTO covid VALUES (26, 'Myanmar', 'South-East Asia', 54409096, 142122, 122, 8, 3201, 1, 0, 'CC');
INSERT INTO covid VALUES (27, 'Kenya', 'Africa', 53770956, 111935, 4606, 750, 1901, 31, 2, 'CT');
INSERT INTO covid VALUES (28, 'North Korea', 'South-East Asia', 51710000, 0, 0, 0, 0, 0, 0, 'NC');
INSERT INTO covid VALUES (29, 'South Korea', 'South-East Asia', 51269123, 95176, 3121, 490, 1667, 35, 5, 'CC');
INSERT INTO covid VALUES (30, 'Colombia', 'South America', 50882888, 2290539, 24328, 4579, 60858, 669, 85, 'CT');
INSERT INTO covid VALUES (31, 'Spain', 'Europe', 46754751, 3183704, 24381, 0, 72258, 401, 0, 'CT');
INSERT INTO covid VALUES (32, 'Uganda', 'Africa', 45740072, 40544, 118, 9, 334, 0, 0, 'CT');
INSERT INTO covid VALUES (33, 'Argentina', 'South America', 45195733, 2185747, 43893, 7849, 53578, 794, 85, 'CT');
INSERT INTO covid VALUES (34, 'Algeria', 'Africa', 43850993, 115008, 1060, 157, 3031, 24, 3, 'CT');
INSERT INTO covid VALUES (35, 'Sudan', 'Africa', 43847465, 30873, 297, 0, 1940, 36, 0, 'CT');
INSERT INTO covid VALUES (36, 'Ukraine', 'Europe', 43733815, 1451744, 57683, 13276, 28158, 1239, 243, 'CT');
INSERT INTO covid VALUES (37, 'Iraq', 'Middle East', 40222594, 750264, 31143, 4622, 13696, 159, 25, 'CT');
INSERT INTO covid VALUES (38, 'Afghanistan', 'Asia', 38928000, 55959, 119, 0, 2454, 5, 0, 'CC');
INSERT INTO covid VALUES (39, 'Poland', 'Europe', 37846619, 1889360, 122870, 21063, 47068, 2156, 344, 'CT');
INSERT INTO covid VALUES (40, 'Canada', 'North America', 37742118, 899757, 21366, 3018, 22371, 220, 36, 'CT');
INSERT INTO covid VALUES (41, 'Morocco', 'Africa', 36910427, 488181, 2614, 431, 8716, 43, 4, 'CC');
INSERT INTO covid VALUES (42, 'Saudi Arabia', 'Middle East', 34813714, 381708, 2616, 360, 6556, 37, 5, 'SC');
INSERT INTO covid VALUES (43, 'Uzbekistan', 'Asia', 33469600, 80481, 356, 89, 622, 0, 0, 'CC');
INSERT INTO covid VALUES (44, 'Peru', 'South America', 32971855, 1394571, 44724, 7114, 48484, 1178, 161, 'CT');
INSERT INTO covid VALUES (45, 'Angola', 'Africa', 32867079, 21265, 239, 60, 519, 8, 2, 'CT');
INSERT INTO covid VALUES (46, 'Malaysia', 'Western Pacific', 32366099, 320939, 10842, 1575, 1203, 44, 3, 'CC');
INSERT INTO covid VALUES (47, 'Mozambique', 'Africa', 31255005, 64004, 2475, 359, 719, 39, 8, 'CT');
INSERT INTO covid VALUES (48, 'Ghana', 'Africa', 31072938, 86737, 1498, 0, 656, 27, 0, 'CT');
INSERT INTO covid VALUES (49, 'Yemen', 'Middle East', 29836245, 2733, 318, 62, 680, 31, 12, 'CT');
INSERT INTO covid VALUES (50, 'Nepal', 'Asia', 29136757, 275118, 510, 48, 3012, 2, 0, 'CC');
INSERT INTO covid VALUES (51, 'Venezuela', 'South America', 28435689, 144277, 3317, 481, 1415, 51, 8, 'CT');
INSERT INTO covid VALUES (52, 'Madagascar', 'Africa', 27689243, 20155, 324, 0, 300, 3, 0, 'CT');
INSERT INTO covid VALUES (53, 'Cameroon', 'Africa', 26545925, 38988, 3274, 0, 588, 37, 0, 'CT');
INSERT INTO covid VALUES (54, 'Cote d''Ivoire', 'Africa', 26378224, 36824, 3539, 313, 211, 17, 2, 'CT');
INSERT INTO covid VALUES (55, 'Australia', 'Oceania', 25498992, 29102, 82, 12, 909, 0, 0, 'CC');
INSERT INTO covid VALUES (56, 'Niger', 'Africa', 24204489, 4853, 113, 0, 180, 8, 0, 'CT');
INSERT INTO covid VALUES (57, 'Sri Lanka', 'South-East Asia', 21413046, 87286, 2326, 297, 525, 32, 5, 'CC');
INSERT INTO covid VALUES (58, 'Burkina Faso', 'Africa', 20901987, 12305, 182, 30, 145, 2, 2, 'CT');
INSERT INTO covid VALUES (59, 'Mali', 'Africa', 20250460, 8813, 304, 31, 360, 2, 1, 'CT');
INSERT INTO covid VALUES (60, 'Romania', 'Europe', 19237697, 850362, 29431, 5010, 21360, 575, 108, 'CT');
INSERT INTO covid VALUES (61, 'Malawi', 'Africa', 19129571, 32746, 389, 73, 1079, 21, 1, 'CT');
INSERT INTO covid VALUES (62, 'Chile', 'South America', 19116205, 879485, 39366, 11536, 21451, 613, 245, 'CT');
INSERT INTO covid VALUES (63, 'Kazakhstan', 'Asia', 18776709, 272420, 4763, 0, 3456, 67, 0, 'CC');
INSERT INTO covid VALUES (64, 'Zambia', 'Africa', 18383781, 84240, 2899, 327, 1149, 36, 1, 'CT');
INSERT INTO covid VALUES (65, 'Guatemala', 'Central America', 17915588, 181974, 5098, 1581, 6546, 111, 24, 'CT');
INSERT INTO covid VALUES (66, 'Ecuador', 'South America', 17643077, 299216, 8146, 1259, 16193, 196, 65, 'CT');
INSERT INTO covid VALUES (67, 'Syria', 'Middle East', 17500536, 16328, 458, 71, 1090, 36, 5, 'CT');
INSERT INTO covid VALUES (68, 'Netherlands', 'Europe', 17134873, 1144822, 34775, 6068, 16024, 264, 27, 'CT');
INSERT INTO covid VALUES (69, 'Senegal', 'Africa', 16744048, 36569, 1532, 198, 951, 55, 10, 'CT');
INSERT INTO covid VALUES (70, 'Cambodia', 'South-East Asia', 16719577, 1264, 311, 39, 1, 1, 0, 'SC');
INSERT INTO covid VALUES (71, 'Chad', 'Africa', 16425826, 4274, 185, 28, 152, 12, 1, 'CT');
INSERT INTO covid VALUES (72, 'Somalia', 'Africa', 15891892, 8820, 970, 0, 338, 64, 0, 'CT');
INSERT INTO covid VALUES (73, 'Zimbabwe', 'Africa', 14862891, 36423, 175, 46, 1496, 12, 4, 'CT');
INSERT INTO covid VALUES (74, 'Guinea', 'Africa', 13133259, 17592, 1172, 220, 102, 9, 1, 'CT');
INSERT INTO covid VALUES (75, 'Rwanda', 'Africa', 12952535, 20057, 631, 112, 275, 8, 2, 'CT');
INSERT INTO covid VALUES (76, 'Benin', 'Africa', 12124207, 6501, 430, 0, 81, 6, 0, 'CT');
INSERT INTO covid VALUES (77, 'Burundi', 'Africa', 11889917, 2441, 142, 21, 3, 0, 0, 'CT');
INSERT INTO covid VALUES (78, 'Tunisia', 'Africa', 11818646, 240617, 4261, 640, 8329, 199, 16, 'CT');
INSERT INTO covid VALUES (79, 'Bolivia', 'South America', 11673042, 257240, 4880, 778, 11903, 142, 19, 'CT');
INSERT INTO covid VALUES (80, 'Belgium', 'Europe', 11589629, 801723, 14369, 0, 22397, 150, 0, 'CT');
INSERT INTO covid VALUES (81, 'Haiti', 'Caribbean', 11402780, 12632, 96, 0, 250, -1, -1, 'CT');
INSERT INTO covid VALUES (82, 'Cuba', 'Caribbean', 11326629, 59919, 5834, 762, 365, 24, 4, 'CT');
INSERT INTO covid VALUES (83, 'South Sudan', 'Africa', 11193189, 9334, 907, 129, 104, 4, 1, 'CT');
INSERT INTO covid VALUES (84, 'Dominican Republic', 'Caribbean', 10847892, 245452, 3365, 529, 3213, 63, 9, 'CT');
INSERT INTO covid VALUES (85, 'Czechia', 'Europe', 10708984, 1392108, 79944, 15110, 23083, 1525, 218, 'CT');
INSERT INTO covid VALUES (86, 'Greece', 'Europe', 10423034, 217018, 15341, 2357, 6986, 322, 49, 'CT');
INSERT INTO covid VALUES (87, 'Jordan', 'Middle East', 10203138, 464856, 46922, 22654, 5224, 362, 178, 'CT');
INSERT INTO covid VALUES (88, 'Portugal', 'Europe', 10196711, 813152, 4747, 577, 16650, 164, 15, 'CC');
INSERT INTO covid VALUES (89, 'Azerbaijan', 'Asia', 10139172, 238959, 2947, 576, 3268, 33, 6, 'CC');
INSERT INTO covid VALUES (90, 'Sweden', 'Europe', 10099260, 712527, 27505, 5252, 13146, 39, 3, 'CT');
INSERT INTO covid VALUES (91, 'Honduras', 'Central America', 9904618, 176427, 3850, 985, 4311, 80, 10, 'CT');
INSERT INTO covid VALUES (92, 'United Arab Emirates', 'Middle East', 9890402, 422246, 20041, 2250, 1378, 92, 9, 'CT');
INSERT INTO covid VALUES (93, 'Hungary', 'Europe', 9660345, 507627, 47811, 9444, 16790, 1025, 163, 'CT');
INSERT INTO covid VALUES (94, 'Tajikistan', 'Asia', 9537520, 13714, 0, 0, 91, 0, 0, 'P');
INSERT INTO covid VALUES (95, 'Belarus', 'Europe', 9449310, 300146, 7043, 1186, 2078, 58, 8, 'CT');
INSERT INTO covid VALUES (96, 'Austria', 'Europe', 9006398, 484682, 17989, 3009, 8635, 122, 23, 'CT');
INSERT INTO covid VALUES (97, 'Papua New Guinea', 'South-East Asia', 8947368, 1819, 290, 0, 21, 5, 0, 'CT');
INSERT INTO covid VALUES (98, 'Israel', 'Middle East', 8655535, 806257, 7903, 0, 5925, 62, 0, 'CT');
INSERT INTO covid VALUES (99, 'Switzerland', 'Europe', 8654617, 567967, 6702, 6, 9359, 43, 0, 'CT');
INSERT INTO covid VALUES (100, 'Togo', 'Africa', 8278339, 7953, 525, 96, 93, 5, 0, 'CT');
INSERT INTO covid VALUES (101, 'Sierra Leone', 'Africa', 7976480, 3934, 25, 2, 79, 0, 0, 'CT');
INSERT INTO covid VALUES (102, 'Lao', 'South-East Asia', 7272727, 48, 1, 0, 0, 0, 0, 'SC');
INSERT INTO covid VALUES (103, 'Paraguay', 'South America', 7132536, 175827, 11517, 1814, 3411, 155, 24, 'CT');
INSERT INTO covid VALUES (104, 'Serbia', 'Europe', 6963761, 507959, 29081, 4668, 4670, 145, 26, 'CT');
INSERT INTO covid VALUES (105, 'Bulgaria', 'Europe', 6948449, 275859, 17474, 3159, 11196, 625, 102, 'CC');
INSERT INTO covid VALUES (106, 'Libya', 'Africa', 6871293, 143643, 6161, 972, 2348, 112, 8, 'CT');
INSERT INTO covid VALUES (107, 'Lebanon', 'Middle East', 6825442, 411839, 21786, 2930, 5278, 307, 48, 'CT');
INSERT INTO covid VALUES (108, 'Nicaragua', 'Central America', 6624333, 5216, 40, 0, 175, 1, 0, 'CT');
INSERT INTO covid VALUES (109, 'Kyrgyzstan', 'Asia', 6524186, 86818, 312, 63, 1480, 9, 0, 'CC');
INSERT INTO covid VALUES (110, 'El Salvador', 'Central America', 6486189, 61947, 1147, 133, 1940, 46, 5, 'CT');
INSERT INTO covid VALUES (111, 'Turkmenistan', 'Asia', 5942000, 0, 0, 0, 0, 0, 0, 'NC');
INSERT INTO covid VALUES (112, 'Singapore', 'South-East Asia', 5850334, 60080, 73, 10, 29, 0, 0, 'SC');
INSERT INTO covid VALUES (113, 'Denmark', 'Europe', 5792204, 219305, 5373, 645, 2387, 10, 3, 'CT');
INSERT INTO covid VALUES (114, 'Finland', 'Europe', 5540710, 65315, 3763, 706, 786, 19, 3, 'CT');
INSERT INTO covid VALUES (115, 'Congo', 'Africa', 5518159, 9329, 150, 0, 131, 0, 0, 'CT');
INSERT INTO covid VALUES (116, 'Slovakia', 'Europe', 5459646, 336235, 14131, 2363, 8440, 701, 94, 'CC');
INSERT INTO covid VALUES (117, 'Norway', 'Europe', 5421252, 78040, 4547, 872, 639, 7, 0, 'CT');
INSERT INTO covid VALUES (118, 'Oman', 'Middle East', 5106628, 145257, 2361, 0, 1600, 17, 0, 'CT');
INSERT INTO covid VALUES (119, 'Palestine (occupied territory)', 'Middle East', 5101419, 232665, 14037, 2309, 2467, 134, 22, 'CT');
INSERT INTO covid VALUES (120, 'Costa Rica', 'Central America', 5094113, 208717, 2424, 473, 2859, 30, 7, 'CT');
INSERT INTO covid VALUES (121, 'Liberia', 'Africa', 5057299, 2030, 13, 4, 85, 0, 0, 'CT');
INSERT INTO covid VALUES (122, 'Ireland', 'Europe', 4937791, 225820, 3651, 641, 4518, 113, 9, 'CT');
INSERT INTO covid VALUES (123, 'Central African Republic', 'Africa', 4829742, 5021, 24, 0, 63, 0, 0, 'CT');
INSERT INTO covid VALUES (124, 'New Zealand', 'Oceania', 4822596, 2066, 24, 5, 26, 0, 0, 'CC');
INSERT INTO covid VALUES (125, 'Mauritania', 'Africa', 4649610, 17410, 143, 16, 442, 0, 0, 'CT');
INSERT INTO covid VALUES (126, 'Panama', 'Central America', 4314769, 346775, 3494, 474, 5972, 77, 15, 'CT');
INSERT INTO covid VALUES (127, 'Kuwait', 'Middle East', 4270569, 207249, 9139, 1356, 1156, 43, 8, 'CT');
INSERT INTO covid VALUES (128, 'Croatia', 'Europe', 4105265, 250484, 4364, 823, 5670, 85, 23, 'CT');
INSERT INTO covid VALUES (129, 'Moldova', 'Europe', 4033960, 201909, 8924, 1785, 4256, 185, 36, 'CT');
INSERT INTO covid VALUES (130, 'Georgia', 'Asia', 3989165, 274721, 2104, 344, 3643, 76, 9, 'CT');
INSERT INTO covid VALUES (131, 'Eritrea', 'Africa', 3546580, 3038, 116, 29, 7, 0, 0, 'CT');
INSERT INTO covid VALUES (132, 'Uruguay', 'South America', 3473736, 67717, 6772, 1233, 683, 52, 5, 'CT');
INSERT INTO covid VALUES (133, 'Bosnia and Herzegovina', 'Europe', 3280822, 142160, 6647, 1170, 5446, 218, 36, 'CT');
INSERT INTO covid VALUES (134, 'Mongolia', 'Asia', 3278161, 3664, 511, 103, 4, 2, 0, 'CC');
INSERT INTO covid VALUES (135, 'Armenia', 'Asia', 2963241, 178799, 4542, 1695, 3253, 34, 10, 'CT');
INSERT INTO covid VALUES (136, 'Jamaica', 'Caribbean', 2961175, 29387, 4611, 419, 480, 37, 5, 'CT');
INSERT INTO covid VALUES (137, 'Qatar', 'Middle East', 2881052, 169284, 3269, 455, 265, 4, 1, 'CT');
INSERT INTO covid VALUES (138, 'Albania', 'Europe', 2877794, 116123, 4822, 681, 2018, 121, 16, 'CC');
INSERT INTO covid VALUES (139, 'Puerto Rico', 'Caribbean', 2860850, 102407, 1341, 356, 2073, 17, 2, 'CT');
INSERT INTO covid VALUES (140, 'Lithuania', 'Europe', 2722288, 204954, 3155, 598, 3389, 68, 16, 'CT');
INSERT INTO covid VALUES (141, 'Namibia', 'Africa', 2540906, 40810, 1344, 179, 456, 20, 6, 'CT');
INSERT INTO covid VALUES (142, 'Gambia', 'Africa', 2416695, 4939, 180, 88, 153, 1, 0, 'CT');
INSERT INTO covid VALUES (143, 'Botswana', 'Africa', 2351635, 34098, 2440, 0, 424, 65, 0, 'CT');
INSERT INTO covid VALUES (144, 'Gabon', 'Africa', 2225725, 16660, 1406, 347, 96, 8, 3, 'CT');
INSERT INTO covid VALUES (145, 'Lesotho', 'Africa', 2142232, 10528, 6, 0, 309, 2, 0, 'CT');
INSERT INTO covid VALUES (146, 'North Macedonia', 'Europe', 2083379, 111077, 4967, 868, 3280, 104, 15, 'CT');
INSERT INTO covid VALUES (147, 'Slovenia', 'Europe', 2078938, 199002, 4835, 770, 4205, 17, 0, 'CC');
INSERT INTO covid VALUES (148, 'Guinea-Bissau', 'Africa', 1968030, 3398, 95, 18, 52, 3, 1, 'CT');
INSERT INTO covid VALUES (149, 'Latvia', 'Europe', 1886198, 92906, 3492, 632, 1746, 66, 9, 'CT');
INSERT INTO covid VALUES (150, 'Kosovo', 'Europe', 1860381, 75927, 4036, 730, 1678, 54, 6, 'CT');
INSERT INTO covid VALUES (151, 'Bahrain', 'Middle East', 1701574, 129825, 4311, 744, 480, 12, 2, 'CC');
INSERT INTO covid VALUES (152, 'Equatorial Guinea', 'Africa', 1402976, 6562, 352, 106, 98, 5, 0, 'CT');
INSERT INTO covid VALUES (153, 'Trinidad and Tobago', 'Caribbean', 1399484, 7753, 26, 10, 140, 1, 0, 'CT');
INSERT INTO covid VALUES (154, 'Estonia', 'Europe', 1326534, 83872, 10188, 1586, 710, 66, 15, 'CC');
INSERT INTO covid VALUES (155, 'Timor-Leste', 'Western Pacific', 1318852, 170, 51, 11, 0, 0, 0, 'CC');
INSERT INTO covid VALUES (156, 'Mauritius', 'Africa', 1271857, 691, 71, 50, 10, 0, 0, 'CC');
INSERT INTO covid VALUES (157, 'Cyprus', 'Europe', 1207359, 38879, 2602, 383, 238, 6, 2, 'CC');
INSERT INTO covid VALUES (158, 'Eswatini', 'Africa', 1160167, 17225, 70, 10, 659, 5, 0, 'CT');
INSERT INTO covid VALUES (159, 'Djibouti', 'Africa', 988006, 6236, 106, 2, 63, 0, 0, 'CT');
INSERT INTO covid VALUES (160, 'Fiji', 'Western Pacific', 896739, 66, 3, 0, 2, 0, 0, 'SC');
INSERT INTO covid VALUES (161, 'Reunion', 'Africa', 895314, 13801, 676, 0, 71, 12, 0, 'CT');
INSERT INTO covid VALUES (162, 'Comoros', 'Africa', 869597, 3615, 28, 1, 146, 1, 0, 'CT');
INSERT INTO covid VALUES (163, 'Guyana', 'South America', 786555, 8993, 294, 65, 206, 7, 1, 'CC');
INSERT INTO covid VALUES (164, 'Bhutan', 'Asia', 771624, 868, 1, 0, 1, 0, 0, 'SC');
INSERT INTO covid VALUES (165, 'Solomon Islands', 'Western Pacific', 687023, 18, 0, 0, 0, 0, 0, 'NC');
INSERT INTO covid VALUES (166, 'Montenegro', 'Europe', 628066, 82603, 2818, 0, 1113, 54, 0, 'CC');
INSERT INTO covid VALUES (167, 'Luxembourg', 'Europe', 625978, 57503, 1207, 182, 681, 29, 6, 'CT');
INSERT INTO covid VALUES (168, 'Suriname', 'South America', 586632, 8997, 38, 7, 176, 1, 1, 'CC');
INSERT INTO covid VALUES (169, 'Cabo Verde', 'Africa', 555986, 15986, 303, 54, 155, 3, 0, 'CT');
INSERT INTO covid VALUES (170, 'Maldives', 'Asia', 540545, 21382, 817, 114, 64, 0, 0, 'CC');
INSERT INTO covid VALUES (171, 'Malta', 'Europe', 441543, 25969, 2098, 329, 346, 18, 5, 'CC');
INSERT INTO covid VALUES (172, 'Brunei Darussalam', 'South-East Asia', 437457, 192, 4, 0, 3, 0, 0, 'SC');
INSERT INTO covid VALUES (173, 'Guadeloupe', 'Caribbean', 400124, 10458, 0, 0, 168, 0, 0, 'CT');
INSERT INTO covid VALUES (174, 'Belize', 'Central America', 397628, 12359, 30, 4, 316, 2, 0, 'CT');
INSERT INTO covid VALUES (175, 'Bahamas', 'Caribbean', 393244, 8680, 71, 0, 185, 4, 0, 'CC');
INSERT INTO covid VALUES (176, 'Martinique', 'Caribbean', 375265, 6886, 0, 0, 47, 0, 0, 'CT');
INSERT INTO covid VALUES (177, 'Iceland', 'Europe', 341242, 6072, 13, 0, 29, 0, 0, 'CT');
INSERT INTO covid VALUES (178, 'Vanuatu', 'Western Pacific', 306122, 3, 2, 0, 0, 0, 0, 'NC');
INSERT INTO covid VALUES (179, 'French Guiana', 'South America', 298682, 16764, 71, 71, 87, 0, 0, 'CT');
INSERT INTO covid VALUES (180, 'Barbados', 'Caribbean', 287375, 3372, 186, 19, 37, 0, 0, 'CT');
INSERT INTO covid VALUES (181, 'New Caledonia', 'Western Pacific', 285529, 88, 30, 7, 0, 0, 0, 'SC');
INSERT INTO covid VALUES (182, 'French Polynesia', 'South-East Asia', 280908, 18527, 68, 10, 141, 1, 0, 'SC');
INSERT INTO covid VALUES (183, 'Mayotte', 'Africa', 272815, 18642, 502, 38, 129, 4, 0, 'CT');
INSERT INTO covid VALUES (184, 'Sao Tome and Principe', 'Africa', 219159, 2035, 112, 0, 32, 1, 0, 'CT');
INSERT INTO covid VALUES (185, 'Samoa', 'Western Pacific', 198020, 4, 0, 0, 0, 0, 0, 'NC');
INSERT INTO covid VALUES (186, 'Saint Lucia', 'Caribbean', 183627, 3966, 152, 25, 47, 4, 0, 'CT');
INSERT INTO covid VALUES (187, 'Guam', 'South-East Asia', 168775, 7557, 18, 9, 133, 0, 0, 'CC');
INSERT INTO covid VALUES (188, 'Curacao', 'Caribbean', 164093, 4915, 164, 53, 22, 0, 0, 'CT');
INSERT INTO covid VALUES (189, 'Kiribati', 'Western Pacific', 117606, 0, 0, 0, 0, 0, 0, 'NC');
INSERT INTO covid VALUES (190, 'Micronesia', 'Western Pacific', 113815, 0, 0, 0, 0, 0, 0, 'NC');
INSERT INTO covid VALUES (191, 'Grenada', 'Caribbean', 112527, 151, 0, 0, 1, 0, 0, 'SC');
INSERT INTO covid VALUES (192, 'Saint Vincent and Grenadines', 'Caribbean', 110940, 1674, 16, 0, 8, 0, 0, 'CT');
INSERT INTO covid VALUES (193, 'Jersey', 'Europe', 108800, 3222, 2, 0, 69, 0, 0, 'CT');
INSERT INTO covid VALUES (194, 'Aruba', 'Caribbean', 106766, 8272, 263, 45, 77, 2, 0, 'CT');
INSERT INTO covid VALUES (195, 'Tonga', 'Western Pacific', 104494, 0, 0, 0, 0, 0, 0, 'NC');
INSERT INTO covid VALUES (196, 'United States Virgin Islands', 'Caribbean', 104425, 2761, 47, 0, 25, 0, 0, 'CT');
INSERT INTO covid VALUES (197, 'Seychelles', 'Africa', 98347, 3132, 242, 45, 15, 2, 0, 'CT');
INSERT INTO covid VALUES (198, 'Antigua and Barbuda', 'Caribbean', 97929, 945, 176, 83, 25, 6, 3, 'CC');
INSERT INTO covid VALUES (199, 'Isle of Man', 'Europe', 85032, 1028, 482, 76, 25, 0, 0, 'NC');
INSERT INTO covid VALUES (200, 'Andorra', 'Europe', 77265, 11199, 201, 0, 112, 0, 0, 'CT');
INSERT INTO covid VALUES (201, 'Dominica', 'Caribbean', 71992, 156, 12, 5, 0, 0, 0, 'CC');
INSERT INTO covid VALUES (202, 'Cayman Islands', 'Caribbean', 65720, 463, 15, 3, 2, 0, 0, 'SC');
INSERT INTO covid VALUES (203, 'Guernsey', 'Europe', 63196, 821, 0, 0, 14, 0, 0, 'CT');
INSERT INTO covid VALUES (204, 'Bermuda', 'Caribbean', 62273, 732, 11, 1, 12, 0, 0, 'SC');
INSERT INTO covid VALUES (205, 'Marshall Islands', 'Western Pacific', 59172, 4, 0, 0, 0, 0, 0, 'NC');
INSERT INTO covid VALUES (206, 'Northern Mariana Islands', 'South-East Asia', 57557, 147, 3, 1, 2, 0, 0, 'P');
INSERT INTO covid VALUES (207, 'Greenland', 'Europe', 56777, 31, 0, 0, 0, 0, 0, 'NC');
INSERT INTO covid VALUES (208, 'American Samoa', 'Western Pacific', 55312, 0, 0, 0, 0, 0, 0, 'NC');
INSERT INTO covid VALUES (209, 'Saint Kitts and Nevis', 'Caribbean', 53191, 43, 2, 1, 0, 0, 0, 'SC');
INSERT INTO covid VALUES (210, 'Faroe Islands', 'Europe', 48865, 660, 2, 0, 1, 0, 0, 'SC');
INSERT INTO covid VALUES (211, 'Sint Maarten', 'Caribbean', 42882, 2078, 12, 1, 27, 0, 0, 'CT');
INSERT INTO covid VALUES (212, 'Monaco', 'Europe', 39244, 2097, 89, 22, 27, 1, 1, 'SC');
INSERT INTO covid VALUES (213, 'Turks and Caicos Islands', 'Caribbean', 38718, 2200, 58, 10, 15, 1, 0, 'CC');
INSERT INTO covid VALUES (214, 'Saint Martin', 'Caribbean', 38659, 1581, 0, 0, 12, 0, 0, 'CT');
INSERT INTO covid VALUES (215, 'Liechtenstein', 'Europe', 38137, 2678, 12, 0, 54, 0, 0, 'SC');
INSERT INTO covid VALUES (216, 'San Marino', 'Europe', 33938, 4126, 230, 30, 77, 1, 0, 'CT');
INSERT INTO covid VALUES (217, 'Gibraltar', 'Europe', 33691, 4259, 16, 3, 93, 0, 0, 'CC');
INSERT INTO covid VALUES (218, 'British Virgin Islands', 'Caribbean', 30237, 154, 0, 0, 1, 0, 0, 'CC');
INSERT INTO covid VALUES (219, 'Bonaire', 'Caribbean', 20915, 633, 178, 37, 6, 1, 0, 'CT');
INSERT INTO covid VALUES (220, 'Palau', 'Western Pacific', 18008, 0, 0, 0, 0, 0, 0, 'NC');
INSERT INTO covid VALUES (221, 'Cook Islands', 'Western Pacific', 17459, 0, 0, 0, 0, 0, 0, 'NC');
INSERT INTO covid VALUES (222, 'Anguilla', 'Caribbean', 15002, 19, 1, -2, 0, 0, 0, 'SC');
INSERT INTO covid VALUES (223, 'Nauru', 'Western Pacific', 12581, 0, 0, 0, 0, 0, 0, 'NC');
INSERT INTO covid VALUES (224, 'Tuvalu', 'Western Pacific', 11646, 0, 0, 0, 0, 0, 0, 'NC');
INSERT INTO covid VALUES (225, 'Wallis and Futuna', 'Western Pacific', 11246, 155, 146, 1, 0, 0, 0, 'SC');
INSERT INTO covid VALUES (226, 'Saint Barthelemy', 'Caribbean', 9885, 671, 59, 0, 0, 0, 0, 'CC');
INSERT INTO covid VALUES (227, 'Saint Helena', 'Africa', 6600, 0, 0, 0, 0, 0, 0, 'NC');
INSERT INTO covid VALUES (228, 'Saint Pierre and Miquelon', 'Caribbean', 5795, 24, 0, 0, 0, 0, 0, 'NC');
INSERT INTO covid VALUES (229, 'Montserrat', 'Caribbean', 4999, 20, 0, 0, 1, 0, 0, 'SC');
INSERT INTO covid VALUES (230, 'Falkland Islands', 'South America', 3483, 51, 0, 0, 0, 0, 0, 'NC');
INSERT INTO covid VALUES (231, 'Sint Eustatius', 'Caribbean', 3139, 20, 0, 0, 0, 0, 0, 'NC');
INSERT INTO covid VALUES (232, 'Saba', 'Caribbean', 1933, 6, 0, 0, 0, 0, 0, 'NC');
INSERT INTO covid VALUES (233, 'Niue', 'Western Pacific', 1624, 0, 0, 0, 0, 0, 0, 'NC');
INSERT INTO covid VALUES (234, 'Tokelau', 'Western Pacific', 1411, 0, 0, 0, 0, 0, 0, 'NC');
INSERT INTO covid VALUES (235, 'Holy See', 'Europe', 809, 26, 0, 0, 0, 0, 0, 'SC');
INSERT INTO covid VALUES (236, 'Pitcairn Islands', 'Western Pacific', 67, 0, 0, 0, 0, 0, 0, 'NC');
INSERT INTO covid VALUES (237, 'Other', 'Other', , 745, 0, 0, 13, 0, 0, 'NA');



DROP   TABLE covid_class;
CREATE TABLE covid_class
(
    xmit_class     VARCHAR(9)  PRIMARY KEY,
    Classification VARCHAR(99) NOT NULL
);
INSERT INTO covid_class VALUES ('CT', 'Community Transmission');
INSERT INTO covid_class VALUES ('CC', 'Cluster Cases');
INSERT INTO covid_class VALUES ('SC', 'Sporadic Cases');
INSERT INTO covid_class VALUES ('NC', 'No Cases');
INSERT INTO covid_class VALUES ('P',  'Pending');
INSERT INTO covid_class VALUES ('NA', 'Not Applicable');