use Mondial;

INSERT INTO country VALUES ('Albania','AL','Tirane','Albania',28750,3249136);
INSERT INTO country VALUES ('Greece','GR','Athens','Greece',131940,10538594);
INSERT INTO country VALUES ('Macedonia','MK','Skopje','Macedonia',25333,2104035);
INSERT INTO country VALUES ('Serbia and Montenegro','YU','Belgrade','Serbia and Montenegro',102350,10614558);
INSERT INTO country VALUES ('Andorra','AND','Andorra la Vella','Andorra',450,72766);
INSERT INTO country VALUES ('France','F','Paris','Ile de France',547030,58317450);
INSERT INTO country VALUES ('Spain','E','Madrid','Madrid',504750,39181114);
INSERT INTO country VALUES ('Austria','A','Vienna','Vienna',83850,8023244);
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 ('Hungary','H','Budapest','Budapest (munic.)',93030,10002541);
INSERT INTO country VALUES ('Italy','I','Rome','Lazio',301230,57460274);
INSERT INTO country VALUES ('Liechtenstein','FL','Vaduz','Liechtenstein',160,31122);
INSERT INTO country VALUES ('Slovakia','SK','Bratislava','Slovakia',48845,5374362);
INSERT INTO country VALUES ('Slovenia','SLO','Ljubljana','Slovenia',20256,1951443);
INSERT INTO country VALUES ('Switzerland','CH','Bern','BE',41290,7207060);
INSERT INTO country VALUES ('Belarus','BY','Minsk','Belarus',207600,10415973);
INSERT INTO country VALUES ('Latvia','LV','Riga','Latvia',64100,2468982);
INSERT INTO country VALUES ('Lithuania','LT','Vilnius','Lithuania',65200,3646041);
INSERT INTO country VALUES ('Poland','PL','Warsaw','Warszwaskie',312683,38642565);
INSERT INTO country VALUES ('Ukraine','UA','Kiev','Kyyivska',603700,50864009);
INSERT INTO country VALUES ('Russia','R','Moscow','Moskva',17075200,148178487);
INSERT INTO country VALUES ('Belgium','B','Brussels','Brabant',30510,10170241);
INSERT INTO country VALUES ('Luxembourg','L','Luxembourg','Luxembourg',2586,415870);
INSERT INTO country VALUES ('Netherlands','NL','Amsterdam','Noord Holland',37330,15568034);
INSERT INTO country VALUES ('Bosnia and Herzegovina','BIH','Sarajevo','Bosnia and Herzegovina',51233,2656240);
INSERT INTO country VALUES ('Croatia','HR','Zagreb','Croatia',56538,5004112);
INSERT INTO country VALUES ('Bulgaria','BG','Sofia','Bulgaria',110910,8612757);
INSERT INTO country VALUES ('Romania','RO','Bucharest','Bucuresti',237500,21657162);
INSERT INTO country VALUES ('Turkey','TR','Ankara','Ankara',780580,62484478);
INSERT INTO country VALUES ('Denmark','DK','Copenhagen','Denmark',43070,5249632);
INSERT INTO country VALUES ('Estonia','EW','Tallinn','Estonia',45100,1459428);
INSERT INTO country VALUES ('Finland','SF','Helsinki','Uusimaa',337030,5105230);
INSERT INTO country VALUES ('Norway','N','Oslo','Oslo',324220,4383807);
INSERT INTO country VALUES ('Sweden','S','Stockholm','Stockholm',449964,8900954);
INSERT INTO country VALUES ('Monaco','MC','Monaco','Monaco',1.9,31719);
INSERT INTO country VALUES ('Holy See','V','Vatican City','Holy See',0.44,840);
INSERT INTO country VALUES ('Iceland','IS','Reykjavik','Iceland',103000,270292);
INSERT INTO country VALUES ('Ireland','IRL','Dublin','Ireland',70280,3566833);
INSERT INTO country VALUES ('San Marino','RSM','San Marino','San Marino',60,24521);
INSERT INTO country VALUES ('Malta','M','Valletta','Malta',320,375576);
INSERT INTO country VALUES ('Moldova','MD','Chisinau','Moldova',33700,4463847);
INSERT INTO country VALUES ('Portugal','P','Lisbon','Lisbon',92080,9865114);
INSERT INTO country VALUES ('United Kingdom','GB','London','Greater London',244820,58489975);
INSERT INTO country VALUES ('Afghanistan','AFG','Kabul','Afghanistan',647500,22664136);
INSERT INTO country VALUES ('China','TJ','Beijing','Beijing (munic.)',9596960,1210004956);
INSERT INTO country VALUES ('Iran','IR','Tehran','Tehran',1648000,66094264);
INSERT INTO country VALUES ('Pakistan','PK','Islamabad','Pakistan',803940,129275660);
INSERT INTO country VALUES ('Tajikistan','TAD','Dushanbe','Dushanbe (munic.)',143100,5916373);
INSERT INTO country VALUES ('Turkmenistan','TM','Ashgabat','Ahal',488100,4149283);
INSERT INTO country VALUES ('Uzbekistan','UZB','Tashkent','Toshkent',447400,23418381);
INSERT INTO country VALUES ('Armenia','ARM','Yerevan','Armenia',29800,3463574);
INSERT INTO country VALUES ('Georgia','GE','Tbilisi','Georgia',69700,5219810);
INSERT INTO country VALUES ('Azerbaijan','AZ','Baku','Azerbaijan',86600,7676953);
INSERT INTO country VALUES ('Bahrain','BRN','Manama','Bahrain',620,590042);
INSERT INTO country VALUES ('Bangladesh','BD','Dhaka','Bangladesh',144000,123062800);
INSERT INTO country VALUES ('Burma','MYA','Rangoon','Yangon',678500,45975625);
INSERT INTO country VALUES ('India','IND','New Delhi','Delhi',3287590,952107694);
INSERT INTO country VALUES ('Bhutan','BHT','Thimphu','Bhutan',47000,1822625);
INSERT INTO country VALUES ('Brunei','BRU','Bandar Seri Begawan','Brunei',5770,299939);
INSERT INTO country VALUES ('Malaysia','MAL','Kuala Lumpur','Fed. Terr. of Kuala Lumpur',329750,19962893);
INSERT INTO country VALUES ('Laos','LAO','Vientiane','Laos',236800,4975772);
INSERT INTO country VALUES ('Thailand','THA','Bangkok','Thailand',514000,58851357);
INSERT INTO country VALUES ('Cambodia','K','Phnom Penh','Cambodia',181040,10861218);
INSERT INTO country VALUES ('Vietnam','VN','Hanoi','Vietnam',329560,73976973);
INSERT INTO country VALUES ('Kazakstan','KAZ','Almaty','Almaty (munic.)',2717300,16916463);
INSERT INTO country VALUES ('North Korea','NOK','Pyongyang','North Korea',120540,23904124);
INSERT INTO country VALUES ('Kyrgyzstan','KGZ','Bishkek','Kyrgyzstan',198500,4529648);
INSERT INTO country VALUES ('Mongolia','MNG','Ulaanbaatar','Mongolia',1565000,2496617);
INSERT INTO country VALUES ('Nepal','NEP','Kathmandu','Nepal',140800,22094033);
INSERT INTO country VALUES ('Cyprus','CY','Nicosia','Cyprus',9250,744609);
INSERT INTO country VALUES ('Israel','IL','Jerusalem','Central',20770,5421995);
INSERT INTO country VALUES ('Egypt','ET','Cairo','El Qahira (munic.)',1001450,63575107);
INSERT INTO country VALUES ('Indonesia','RI','Jakarta','Indonesia',1919440,206611600);
INSERT INTO country VALUES ('Papua New Guinea','PNG','Port Moresby','Papua New Guinea',461690,4394537);
INSERT INTO country VALUES ('Iraq','IRQ','Baghdad','Baghdad',437072,21422292);
INSERT INTO country VALUES ('Jordan','JOR','Amman','Jordan',89213,4212152);
INSERT INTO country VALUES ('Kuwait','KWT','Kuwait','Kuwait',17820,1950047);
INSERT INTO country VALUES ('Saudi Arabia','SA','Riyadh','Saudi Arabia',1960582,19409058);
INSERT INTO country VALUES ('Syria','SYR','Damascus','Syria',185180,15608648);
INSERT INTO country VALUES ('Lebanon','RL','Beirut','Lebanon',10400,3776317);
INSERT INTO country VALUES ('Japan','J','Tokyo','Tokyo',377835,125449703);
INSERT INTO country VALUES ('South Korea','ROK','Seoul','South Korea',98480,45482291);
INSERT INTO country VALUES ('Maldives','MV','Male','Maldives',300,270758);
INSERT INTO country VALUES ('Oman','OM','Muscat','Oman',212460,2186548);
INSERT INTO country VALUES ('United Arab Emirates','UAE','Abu Dhabi','United Arab Emirates',75581,3057337);
INSERT INTO country VALUES ('Yemen','YE','Sanaa','Yemen',527970,13483178);
INSERT INTO country VALUES ('Philippines','RP','Manila','Philippines',300000,74480848);
INSERT INTO country VALUES ('Qatar','Q','Doha','Qatar',11000,547761);
INSERT INTO country VALUES ('Singapore','SGP','Singapore','Singapore',632.6,3396924);
INSERT INTO country VALUES ('Sri Lanka','CL','Colombo','Sri Lanka',65610,18553074);
INSERT INTO country VALUES ('Taiwan','RC','Taipei','Taiwan',35980,21465881);
INSERT INTO country VALUES ('Antigua and Barbuda','AG','Saint Johns','Antigua and Barbuda',440,65647);
INSERT INTO country VALUES ('Bahamas','BS','Nassau','Bahamas',13940,259367);
INSERT INTO country VALUES ('Barbados','BDS','Bridgetown','Barbados',430,257030);
INSERT INTO country VALUES ('Belize','BZ','Belmopan','Belize',22960,219296);
INSERT INTO country VALUES ('Guatemala','GCA','Guatemala City','Guatemala',108890,11277614);
INSERT INTO country VALUES ('Mexico','MEX','Mexico City','Distrito Federal',1972550,95772462);
INSERT INTO country VALUES ('Canada','CDN','Ottawa','Ontario',9976140,28820671);
INSERT INTO country VALUES ('United States','USA','Washington','Distr. Columbia',9372610,266476278);
INSERT INTO country VALUES ('Costa Rica','CR','San Jose','San Jose',51100,3463083);
INSERT INTO country VALUES ('Nicaragua','NIC','Managua','Nicaragua',129494,4272352);
INSERT INTO country VALUES ('Panama','PA','Panama City','Panama',78200,2655094);
INSERT INTO country VALUES ('Cuba','C','Havana','Ciudad de la Habana',110860,10951334);
INSERT INTO country VALUES ('Dominica','WD','Roseau','Dominica',750,82926);
INSERT INTO country VALUES ('Dominican Republic','DOM','Santo Domingo','Dominican Republic',48730,8088881);
INSERT INTO country VALUES ('Haiti','RH','Port-au-Prince','Haiti',27750,6731539);
INSERT INTO country VALUES ('El Salvador','ES','San Salvador','El Salvador',21040,5828987);
INSERT INTO country VALUES ('Honduras','HCA','Tegucigalpa','Francisco Morazan',112090,5605193);
INSERT INTO country VALUES ('Grenada','WG','Saint Georges','Grenada',340,94961);
INSERT INTO country VALUES ('Jamaica','JA','Kingston','Jamaica',10990,2595275);
INSERT INTO country VALUES ('Colombia','CO','Bogota','Santa Fe de Bogota, DC',1138910,36813161);
INSERT INTO country VALUES ('Saint Kitts and Nevis','KN','Basseterre','Saint Kitts and Nevis',269,41369);
INSERT INTO country VALUES ('Saint Lucia','WL','Castries','Saint Lucia',620,157862);
INSERT INTO country VALUES ('Saint Vincent and the Grenadines','WV','Kingstown','Saint Vincent and the Grenadines',340,118344);
INSERT INTO country VALUES ('Trinidad and Tobago','TT','Port-of-Spain','Trinidad and Tobago',5130,1272385);
INSERT INTO country VALUES ('Australia','AUS','Canberra','Australia Capital Territory',7686850,18260863);
INSERT INTO country VALUES ('Fiji','FJI','Suva','Fiji',18270,782381);
INSERT INTO country VALUES ('Kiribati','KIR','Tarawa','Kiribati',717,80919);
INSERT INTO country VALUES ('Marshall Islands','MH','Majuro','Marshall Islands',181.3,58363);
INSERT INTO country VALUES ('Micronesia','FSM','Kolonia','Micronesia',702,125377);
INSERT INTO country VALUES ('Nauru','NAU','Yaren','Nauru',21,10273);
INSERT INTO country VALUES ('New Caledonia','NCA','Noumea','New Caledonia',19060,187784);
INSERT INTO country VALUES ('New Zealand','NZ','Wellington','New Zealand',268680,3547983);
INSERT INTO country VALUES ('Palau','PAL','Koror','Palau',458,16952);
INSERT INTO country VALUES ('Solomon Islands','SLB','Honiara','Solomon Islands',28450,412902);
INSERT INTO country VALUES ('Tonga','TO','Nukualofa','Tonga',748,106466);
INSERT INTO country VALUES ('Tuvalu','TUV','Funafuti','Tuvalu',26,10146);
INSERT INTO country VALUES ('Vanuatu','VU','Port-Vila','Vanuatu',14760,177504);
INSERT INTO country VALUES ('Western Samoa','WS','Apia','Western Samoa',2860,214384);
INSERT INTO country VALUES ('Argentina','RA','Buenos Aires','Distrito Federal',2766890,34672997);
INSERT INTO country VALUES ('Bolivia','BOL','La Paz','Bolivia',1098580,7165257);
INSERT INTO country VALUES ('Brazil','BR','Brasilia','Distrito Federal',8511965,162661214);
INSERT INTO country VALUES ('Chile','RCH','Santiago','Chile',756950,14333258);
INSERT INTO country VALUES ('Paraguay','PY','Asuncion','Paraguay',406750,5504146);
INSERT INTO country VALUES ('Uruguay','ROU','Montevideo','Uruguay',176220,3238952);
INSERT INTO country VALUES ('Peru','PE','Lima','Lima',1285220,24523408);
INSERT INTO country VALUES ('French Guiana','FGU','Cayenne','French Guiana',91000,151187);
INSERT INTO country VALUES ('Guyana','GUY','Georgetown','Guyana',214970,712091);
INSERT INTO country VALUES ('Suriname','SME','Paramaribo','Suriname',163270,436418);
INSERT INTO country VALUES ('Venezuela','YV','Caracas','Distrito Federal',912050,21983188);
INSERT INTO country VALUES ('Ecuador','EC','Quito','Ecuador',283560,11466291);
INSERT INTO country VALUES ('Algeria','DZ','Algiers','Algeria',2381740,29183032);
INSERT INTO country VALUES ('Libya','LAR','Tripoli','Libya',1759540,5445436);
INSERT INTO country VALUES ('Mali','RMM','Bamako','Mali',1240000,9653261);
INSERT INTO country VALUES ('Mauritania','RIM','Nouakchott','Mauritania',1030700,2336048);
INSERT INTO country VALUES ('Morocco','MA','Rabat','Morocco',446550,29779156);
INSERT INTO country VALUES ('Niger','RN','Niamey','Niger',1267000,9113001);
INSERT INTO country VALUES ('Tunisia','TN','Tunis','Tunisia',163610,9019687);
INSERT INTO country VALUES ('Western Sahara','WSA','El Alaiun','Western Sahara',266000,222631);
INSERT INTO country VALUES ('Angola','ANG','Luanda','Luanda',1246700,10342899);
INSERT INTO country VALUES ('Congo','RCB','Brazzaville','Congo',342000,2527841);
INSERT INTO country VALUES ('Namibia','NAM','Windhoek','Namibia',825418,1677243);
INSERT INTO country VALUES ('Zaire','ZRE','Kinshasa','Kinshasa',2345410,46498539);
INSERT INTO country VALUES ('Zambia','Z','Lusaka','Lusaka',752610,9159072);
INSERT INTO country VALUES ('Benin','BEN','Porto-Novo','Benin',112620,5709529);
INSERT INTO country VALUES ('Burkina Faso','BF','Ouagadougou','Burkina Faso',274200,10623323);
INSERT INTO country VALUES ('Nigeria','WAN','Abuja','Nigeria',923770,103912489);
INSERT INTO country VALUES ('Togo','RT','Lome','Togo',56790,4570530);
INSERT INTO country VALUES ('Botswana','RB','Gaborone','Botswana',600370,1477630);
INSERT INTO country VALUES ('South Africa','RSA','Pretoria','South Africa',1219912,41743459);
INSERT INTO country VALUES ('Zimbabwe','ZW','Harare','Zimbabwe',390580,11271314);
INSERT INTO country VALUES ('Cote dIvoire','CI','Yamoussoukro','Cote dIvoire',322460,14762445);
INSERT INTO country VALUES ('Ghana','GH','Accra','Ghana',238540,17698271);
INSERT INTO country VALUES ('Burundi','BI','Bujumbura','Burundi',27830,5943057);
INSERT INTO country VALUES ('Rwanda','RWA','Kigali','Rwanda',26340,6853359);
INSERT INTO country VALUES ('Tanzania','EAT','Dar es Salaam','Daressalam',945090,29058470);
INSERT INTO country VALUES ('Cameroon','CAM','Yaounde','Centre',475440,14261557);
INSERT INTO country VALUES ('Central African Republic','RCA','Bangui','Central African Republic',622980,3274426);
INSERT INTO country VALUES ('Chad','TCH','NDjamena','Chad',1284000,6976845);
INSERT INTO country VALUES ('Equatorial Guinea','GQ','Malabo','Equatorial Guinea',28050,431282);
INSERT INTO country VALUES ('Gabon','G','Libreville','Gabon',267670,1172798);
INSERT INTO country VALUES ('Cape Verde','CV','Praia','Cape Verde',4030,449066);
INSERT INTO country VALUES ('Sudan','SUD','Khartoum','al Khartum',2505810,31547543);
INSERT INTO country VALUES ('Comoros','COM','Moroni','Comoros',2170,569237);
INSERT INTO country VALUES ('Guinea','RG','Conakry','Guinea',245860,7411981);
INSERT INTO country VALUES ('Liberia','LB','Monrovia','Liberia',111370,2109789);
INSERT INTO country VALUES ('Djibouti','DJI','Djibouti','Djibouti',22000,427642);
INSERT INTO country VALUES ('Eritrea','ER','Asmara','Eritrea',121320,3427883);
INSERT INTO country VALUES ('Ethiopia','ETH','Addis Ababa','Ethiopia',1127127,57171662);
INSERT INTO country VALUES ('Somalia','SP','Mogadishu','Somalia',637660,9639151);
INSERT INTO country VALUES ('Kenya','EAK','Nairobi','Nairobi',582650,28176686);
INSERT INTO country VALUES ('Gambia','WAG','Banjul','Gambia',11300,1204984);
INSERT INTO country VALUES ('Senegal','SN','Dakar','Dakar',196190,9092749);
INSERT INTO country VALUES ('Guinea-Bissau','GNB','Bissau','Guinea-Bissau',36120,1151330);
INSERT INTO country VALUES ('Sierra Leone','WAL','Freetown','Sierra Leone',71740,4793121);
INSERT INTO country VALUES ('Uganda','EAU','Kampala','Uganda',236040,20158176);
INSERT INTO country VALUES ('Lesotho','LS','Maseru','Lesotho',30350,1970781);
INSERT INTO country VALUES ('Madagascar','RM','Antananarivo','Antananarivo',587040,13670507);
INSERT INTO country VALUES ('Malawi','MW','Lilongwe','Malawi',118480,9452844);
INSERT INTO country VALUES ('Mozambique','MOC','Maputo','Maputo (munic.)',801590,17877927);
INSERT INTO country VALUES ('Mauritius','MS','Port Louis','Mauritius',1860,1140256);
INSERT INTO country VALUES ('Swaziland','SD','Mbabane','Swaziland',17360,998730);
INSERT INTO country VALUES ('Sao Tome and Principe','STP','Sao Tome','Sao Tome and Principe',960,144128);
INSERT INTO country VALUES ('Seychelles','SY','Victoria','Seychelles',455,77575);

COMMIT;



INSERT INTO population VALUES ('AL',1.34,49.2);
INSERT INTO population VALUES ('GR',0.42,7.4);
INSERT INTO population VALUES ('MK',0.46,29.7);
INSERT INTO population VALUES ('YU',NULL,NULL);
INSERT INTO population VALUES ('AND',2.96,2.2);
INSERT INTO population VALUES ('F',0.34,5.3);
INSERT INTO population VALUES ('E',0.16,6.3);
INSERT INTO population VALUES ('A',0.41,6.2);
INSERT INTO population VALUES ('CZ',-0.03,8.4);
INSERT INTO population VALUES ('D',0.67,6);
INSERT INTO population VALUES ('H',-0.68,12.3);
INSERT INTO population VALUES ('I',0.13,6.9);
INSERT INTO population VALUES ('FL',1.08,5.3);
INSERT INTO population VALUES ('SK',0.34,10.7);
INSERT INTO population VALUES ('SLO',-0.27,7.3);
INSERT INTO population VALUES ('CH',0.59,5.4);
INSERT INTO population VALUES ('BY',0.2,13.4);
INSERT INTO population VALUES ('LV',-1.39,21.2);
INSERT INTO population VALUES ('LT',-0.35,17);
INSERT INTO population VALUES ('PL',0.14,12.4);
INSERT INTO population VALUES ('UA',-0.4,22.5);
INSERT INTO population VALUES ('R',-0.07,24.7);
INSERT INTO population VALUES ('B',0.33,6.4);
INSERT INTO population VALUES ('L',1.57,4.7);
INSERT INTO population VALUES ('NL',0.56,4.9);
INSERT INTO population VALUES ('BIH',-2.84,43.2);
INSERT INTO population VALUES ('HR',0.58,10.2);
INSERT INTO population VALUES ('BG',0.46,15.7);
INSERT INTO population VALUES ('RO',-1.21,23.2);
INSERT INTO population VALUES ('TR',1.67,43.2);
INSERT INTO population VALUES ('DK',0.38,4.8);
INSERT INTO population VALUES ('EW',-1.13,17.4);
INSERT INTO population VALUES ('SF',0.1,4.9);
INSERT INTO population VALUES ('N',0.48,4.9);
INSERT INTO population VALUES ('S',0.56,4.5);
INSERT INTO population VALUES ('MC',0.59,6.9);
INSERT INTO population VALUES ('V',NULL,NULL);
INSERT INTO population VALUES ('IS',0.83,4.3);
INSERT INTO population VALUES ('IRL',-0.22,6.4);
INSERT INTO population VALUES ('RSM',0.82,5.5);
INSERT INTO population VALUES ('M',1.01,6.9);
INSERT INTO population VALUES ('MD',0.18,47.6);
INSERT INTO population VALUES ('P',0.02,7.6);
INSERT INTO population VALUES ('GB',0.22,6.4);
INSERT INTO population VALUES ('AFG',4.78,149.7);
INSERT INTO population VALUES ('TJ',0.98,39.6);
INSERT INTO population VALUES ('IR',2.21,52.7);
INSERT INTO population VALUES ('PK',2.24,96.8);
INSERT INTO population VALUES ('TAD',1.54,113.1);
INSERT INTO population VALUES ('TM',1.82,81.6);
INSERT INTO population VALUES ('UZB',1.87,79.6);
INSERT INTO population VALUES ('ARM',0.02,38.9);
INSERT INTO population VALUES ('GE',-1.02,22.5);
INSERT INTO population VALUES ('AZ',0.78,74.5);
INSERT INTO population VALUES ('BRN',2.27,17.1);
INSERT INTO population VALUES ('BD',1.85,102.3);
INSERT INTO population VALUES ('MYA',1.84,80.7);
INSERT INTO population VALUES ('IND',1.64,71.1);
INSERT INTO population VALUES ('BHT',2.32,116.3);
INSERT INTO population VALUES ('BRU',2.56,24.2);
INSERT INTO population VALUES ('MAL',2.07,24);
INSERT INTO population VALUES ('LAO',2.81,96.8);
INSERT INTO population VALUES ('THA',1.03,33.4);
INSERT INTO population VALUES ('K',2.77,107.8);
INSERT INTO population VALUES ('VN',1.57,38.4);
INSERT INTO population VALUES ('KAZ',-0.15,63.2);
INSERT INTO population VALUES ('NOK',1.74,25.9);
INSERT INTO population VALUES ('KGZ',0.07,77.8);
INSERT INTO population VALUES ('MNG',1.69,69.7);
INSERT INTO population VALUES ('NEP',2.45,79);
INSERT INTO population VALUES ('CY',1.11,8.4);
INSERT INTO population VALUES ('IL',2.11,8.5);
INSERT INTO population VALUES ('ET',1.91,72.8);
INSERT INTO population VALUES ('RI',1.53,63.1);
INSERT INTO population VALUES ('PNG',2.29,60.1);
INSERT INTO population VALUES ('IRQ',3.69,60);
INSERT INTO population VALUES ('JOR',2.65,31.5);
INSERT INTO population VALUES ('KWT',6.65,11.1);
INSERT INTO population VALUES ('SA',3.45,46.4);
INSERT INTO population VALUES ('SYR',3.37,40);
INSERT INTO population VALUES ('RL',2.16,36.7);
INSERT INTO population VALUES ('J',0.21,4.4);
INSERT INTO population VALUES ('ROK',1.02,8.2);
INSERT INTO population VALUES ('MV',3.52,47);
INSERT INTO population VALUES ('OM',3.53,27.3);
INSERT INTO population VALUES ('UAE',4.33,20.4);
INSERT INTO population VALUES ('YE',3.56,71.5);
INSERT INTO population VALUES ('RP',2.18,35.9);
INSERT INTO population VALUES ('Q',2.39,19.6);
INSERT INTO population VALUES ('SGP',1.9,4.7);
INSERT INTO population VALUES ('CL',1.13,20.8);
INSERT INTO population VALUES ('RC',0.89,7);
INSERT INTO population VALUES ('AG',0.76,17.2);
INSERT INTO population VALUES ('BS',1.05,23.3);
INSERT INTO population VALUES ('BDS',0.26,18.7);
INSERT INTO population VALUES ('BZ',2.42,33.9);
INSERT INTO population VALUES ('GCA',2.48,50.7);
INSERT INTO population VALUES ('MEX',1.87,25);
INSERT INTO population VALUES ('CDN',1.06,6.1);
INSERT INTO population VALUES ('USA',0.91,6.7);
INSERT INTO population VALUES ('CR',2.06,13.5);
INSERT INTO population VALUES ('NIC',2.67,45.8);
INSERT INTO population VALUES ('PA',1.64,29.7);
INSERT INTO population VALUES ('C',0.44,9);
INSERT INTO population VALUES ('WD',0.38,9.6);
INSERT INTO population VALUES ('DOM',1.73,47.7);
INSERT INTO population VALUES ('RH',1.77,103.8);
INSERT INTO population VALUES ('ES',1.81,31.9);
INSERT INTO population VALUES ('HCA',2.6,41.8);
INSERT INTO population VALUES ('WG',0.55,11.9);
INSERT INTO population VALUES ('JA',0.8,15.6);
INSERT INTO population VALUES ('CO',1.66,25.8);
INSERT INTO population VALUES ('KN',0.98,18.9);
INSERT INTO population VALUES ('WL',1.14,20);
INSERT INTO population VALUES ('WV',0.64,16.8);
INSERT INTO population VALUES ('TT',0.08,18.2);
INSERT INTO population VALUES ('AUS',0.99,5.5);
INSERT INTO population VALUES ('FJI',1.28,17.4);
INSERT INTO population VALUES ('KIR',1.89,52.9);
INSERT INTO population VALUES ('MH',3.85,46.9);
INSERT INTO population VALUES ('FSM',3.34,35.8);
INSERT INTO population VALUES ('NAU',1.33,40.6);
INSERT INTO population VALUES ('NCA',1.72,13.8);
INSERT INTO population VALUES ('NZ',1.12,6.7);
INSERT INTO population VALUES ('PAL',1.71,25.07);
INSERT INTO population VALUES ('SLB',3.35,25.8);
INSERT INTO population VALUES ('TO',0.82,40.26);
INSERT INTO population VALUES ('TUV',1.51,27.6);
INSERT INTO population VALUES ('VU',2.17,64.6);
INSERT INTO population VALUES ('WS',2.37,34.3);
INSERT INTO population VALUES ('RA',1.1,28.3);
INSERT INTO population VALUES ('BOL',1.82,67.5);
INSERT INTO population VALUES ('BR',1.16,55.3);
INSERT INTO population VALUES ('RCH',1.24,13.6);
INSERT INTO population VALUES ('PY',2.67,23.2);
INSERT INTO population VALUES ('ROU',0.7,15.4);
INSERT INTO population VALUES ('PE',1.74,52.2);
INSERT INTO population VALUES ('FGU',3.86,14.6);
INSERT INTO population VALUES ('GUY',-0.9,51.4);
INSERT INTO population VALUES ('SME',1.6,29.3);
INSERT INTO population VALUES ('YV',1.89,29.5);
INSERT INTO population VALUES ('EC',1.96,34.8);
INSERT INTO population VALUES ('DZ',2.21,48.7);
INSERT INTO population VALUES ('LAR',3.67,59.5);
INSERT INTO population VALUES ('RMM',2.95,102.7);
INSERT INTO population VALUES ('RIM',3.17,81.7);
INSERT INTO population VALUES ('MA',2.05,43.2);
INSERT INTO population VALUES ('RN',2.99,117.6);
INSERT INTO population VALUES ('TN',1.81,35.1);
INSERT INTO population VALUES ('WSA',2.46,145.82);
INSERT INTO population VALUES ('ANG',2.68,138.9);
INSERT INTO population VALUES ('RCB',2.19,108.1);
INSERT INTO population VALUES ('NAM',2.93,47.2);
INSERT INTO population VALUES ('ZRE',1.67,108);
INSERT INTO population VALUES ('Z',2.11,96.1);
INSERT INTO population VALUES ('BEN',3.32,105.1);
INSERT INTO population VALUES ('BF',2.53,117.8);
INSERT INTO population VALUES ('WAN',3.05,72.4);
INSERT INTO population VALUES ('RT',3.56,84.3);
INSERT INTO population VALUES ('RB',1.63,54.2);
INSERT INTO population VALUES ('RSA',1.76,48.8);
INSERT INTO population VALUES ('ZW',1.41,72.8);
INSERT INTO population VALUES ('CI',2.92,82.4);
INSERT INTO population VALUES ('GH',2.29,80.3);
INSERT INTO population VALUES ('BI',1.54,102.2);
INSERT INTO population VALUES ('RWA',16.49,118.8);
INSERT INTO population VALUES ('EAT',1.15,105.9);
INSERT INTO population VALUES ('CAM',2.89,78.7);
INSERT INTO population VALUES ('RCA',2.08,111.7);
INSERT INTO population VALUES ('TCH',2.68,120.4);
INSERT INTO population VALUES ('GQ',2.58,98);
INSERT INTO population VALUES ('G',1.47,90.1);
INSERT INTO population VALUES ('CV',2.93,54.3);
INSERT INTO population VALUES ('SUD',3.48,76);
INSERT INTO population VALUES ('COM',3.55,75.3);
INSERT INTO population VALUES ('RG',1.85,134.1);
INSERT INTO population VALUES ('LB',2.13,108.1);
INSERT INTO population VALUES ('DJI',1.5,106.7);
INSERT INTO population VALUES ('ER',2.79,118.9);
INSERT INTO population VALUES ('ETH',2.72,122.8);
INSERT INTO population VALUES ('SP',3.1,121.1);
INSERT INTO population VALUES ('EAK',2.27,55.3);
INSERT INTO population VALUES ('WAG',3.55,80.5);
INSERT INTO population VALUES ('SN',3.37,64);
INSERT INTO population VALUES ('GNB',2.35,115.8);
INSERT INTO population VALUES ('WAL',4.14,135.6);
INSERT INTO population VALUES ('EAU',2.24,99.4);
INSERT INTO population VALUES ('LS',1.9,81.6);
INSERT INTO population VALUES ('RM',2.83,93.5);
INSERT INTO population VALUES ('MW',1.71,139.9);
INSERT INTO population VALUES ('MOC',2.65,125.6);
INSERT INTO population VALUES ('MS',1.23,17.2);
INSERT INTO population VALUES ('SD',3.24,88.4);
INSERT INTO population VALUES ('STP',2.58,61.1);
INSERT INTO population VALUES ('SY',0.76,12.5);

COMMIT;



INSERT INTO politics VALUES ('AL','28 11 1912','emerging democracy');
INSERT INTO politics VALUES ('GR','01 01 1829','parliamentary republic');
INSERT INTO politics VALUES ('MK','17 09 1991','emerging democracy');
INSERT INTO politics VALUES ('YU','11 04 1992','republic');
INSERT INTO politics VALUES ('AND',NULL,'parliamentary democracy that retains as its heads of state a coprincipality');
INSERT INTO politics VALUES ('F',NULL,'republic');
INSERT INTO politics VALUES ('E','01 01 1492','parliamentary monarchy');
INSERT INTO politics VALUES ('A','12 11 1918','federal republic');
INSERT INTO politics VALUES ('CZ','01 01 1993','parliamentary democracy');
INSERT INTO politics VALUES ('D','18 01 1871','federal republic');
INSERT INTO politics VALUES ('H','01 01 1001','republic');
INSERT INTO politics VALUES ('I','17 03 1861','republic');
INSERT INTO politics VALUES ('FL','23 01 1719','hereditary constitutional monarchy');
INSERT INTO politics VALUES ('SK','01 01 1993','parliamentary democracy');
INSERT INTO politics VALUES ('SLO','25 06 1991','emerging democracy');
INSERT INTO politics VALUES ('CH',NULL,'federal republic');
INSERT INTO politics VALUES ('BY','25 08 1991','republic');
INSERT INTO politics VALUES ('LV','06 09 1991','republic');
INSERT INTO politics VALUES ('LT','06 09 1991','republic');
INSERT INTO politics VALUES ('PL','11 11 1918','democratic state');
INSERT INTO politics VALUES ('UA','01 12 1991','republic');
INSERT INTO politics VALUES ('R','24 08 1991','federation');
INSERT INTO politics VALUES ('B','04 10 1830','constitutional monarchy');
INSERT INTO politics VALUES ('L',NULL,'constitutional monarchy');
INSERT INTO politics VALUES ('NL','01 01 1579','constitutional monarchy');
INSERT INTO politics VALUES ('BIH','01 04 1992','emerging democracy');
INSERT INTO politics VALUES ('HR','25 06 1991','parliamentary democracy');
INSERT INTO politics VALUES ('BG','22 09 1908','emerging democracy');
INSERT INTO politics VALUES ('RO','01 01 1881','republic');
INSERT INTO politics VALUES ('TR','29 10 1923','republican parliamentary democracy');
INSERT INTO politics VALUES ('DK',NULL,'constitutional monarchy');
INSERT INTO politics VALUES ('EW','06 09 1991','republic');
INSERT INTO politics VALUES ('SF','06 12 1917','republic');
INSERT INTO politics VALUES ('N','26 10 1905','constitutional monarchy');
INSERT INTO politics VALUES ('S',NULL,'constitutional monarchy');
INSERT INTO politics VALUES ('MC','01 01 1419','constitutional monarchy');
INSERT INTO politics VALUES ('V','11 02 1929','monarchical sacerdotal state');
INSERT INTO politics VALUES ('IS','17 06 1944','republic');
INSERT INTO politics VALUES ('IRL','06 12 1921','republic');
INSERT INTO politics VALUES ('RSM','01 01 0301','republic');
INSERT INTO politics VALUES ('M','21 09 1964','parliamentary democracy');
INSERT INTO politics VALUES ('MD','27 08 1991','republic');
INSERT INTO politics VALUES ('P','01 01 1140','republic');
INSERT INTO politics VALUES ('GB','01 01 1801','constitutional monarchy');
INSERT INTO politics VALUES ('AFG','19 08 1919','transitional government');
INSERT INTO politics VALUES ('TJ',NULL,'Communist state');
INSERT INTO politics VALUES ('IR','01 04 1979','theocratic republic');
INSERT INTO politics VALUES ('PK','14 08 1947','republic');
INSERT INTO politics VALUES ('TAD','09 09 1991','republic');
INSERT INTO politics VALUES ('TM','27 10 1991','republic');
INSERT INTO politics VALUES ('UZB','31 08 1991','republic');
INSERT INTO politics VALUES ('ARM','28 05 1918','republic');
INSERT INTO politics VALUES ('GE','09 04 1991','republic');
INSERT INTO politics VALUES ('AZ','30 08 1991','republic');
INSERT INTO politics VALUES ('BRN','15 08 1971','traditional monarchy');
INSERT INTO politics VALUES ('BD','16 12 1971','republic');
INSERT INTO politics VALUES ('MYA','04 01 1948','military regime');
INSERT INTO politics VALUES ('IND','15 08 1947','federal republic');
INSERT INTO politics VALUES ('BHT','08 08 1949','monarchy');
INSERT INTO politics VALUES ('BRU','01 01 1984','constitutional sultanate');
INSERT INTO politics VALUES ('MAL','31 08 1957','constitutional monarchy');
INSERT INTO politics VALUES ('LAO','19 07 1949','Communist state');
INSERT INTO politics VALUES ('THA','01 01 1238','constitutional monarchy');
INSERT INTO politics VALUES ('K','09 11 1949','multiparty liberal democracy under a constitutional monarchy established in September 1993');
INSERT INTO politics VALUES ('VN','02 09 1945','Communist state');
INSERT INTO politics VALUES ('KAZ','16 12 1991','republic');
INSERT INTO politics VALUES ('NOK',NULL,'Communist state');
INSERT INTO politics VALUES ('KGZ','31 08 1991','republic');
INSERT INTO politics VALUES ('MNG','13 03 1921','republic');
INSERT INTO politics VALUES ('NEP','01 01 1768','parliamentary democracy as of 12 May 1991');
INSERT INTO politics VALUES ('CY','16 08 1960','republic');
INSERT INTO politics VALUES ('IL','14 05 1948','republic');
INSERT INTO politics VALUES ('ET','28 02 1922','republic');
INSERT INTO politics VALUES ('RI','17 08 1945','republic');
INSERT INTO politics VALUES ('PNG','16 09 1975','parliamentary democracy');
INSERT INTO politics VALUES ('IRQ','03 10 1932','republic');
INSERT INTO politics VALUES ('JOR','25 05 1946','constitutional monarchy');
INSERT INTO politics VALUES ('KWT','19 06 1961','nominal constitutional monarchy');
INSERT INTO politics VALUES ('SA','23 09 1932','monarchy');
INSERT INTO politics VALUES ('SYR','17 04 1946','republic under military regime since March 1963');
INSERT INTO politics VALUES ('RL','22 11 1943','republic');
INSERT INTO politics VALUES ('J',NULL,'constitutional monarchy');
INSERT INTO politics VALUES ('ROK',NULL,'republic');
INSERT INTO politics VALUES ('MV','26 07 1965','republic');
INSERT INTO politics VALUES ('OM','01 01 1650','monarchy');
INSERT INTO politics VALUES ('UAE','02 12 1971','federation with specified powers delegated to the UAE central government and other powers reserved to member emirates');
INSERT INTO politics VALUES ('YE','22 05 1990','republic');
INSERT INTO politics VALUES ('RP','04 07 1946','republic');
INSERT INTO politics VALUES ('Q','03 09 1971','traditional monarchy');
INSERT INTO politics VALUES ('SGP','09 08 1965','republic within Commonwealth');
INSERT INTO politics VALUES ('CL','04 02 1948','republic');
INSERT INTO politics VALUES ('RC',NULL,'multiparty democratic regime');
INSERT INTO politics VALUES ('AG','01 11 1981','parliamentary democracy');
INSERT INTO politics VALUES ('BS','10 07 1973','commonwealth');
INSERT INTO politics VALUES ('BDS','30 11 1966','parliamentary democracy');
INSERT INTO politics VALUES ('BZ','21 09 1981','parliamentary democracy');
INSERT INTO politics VALUES ('GCA','15 09 1821','republic');
INSERT INTO politics VALUES ('MEX','16 09 1810','federal republic operating under a centralized government');
INSERT INTO politics VALUES ('CDN','01 07 1867','confederation with parliamentary democracy');
INSERT INTO politics VALUES ('USA','04 07 1776','federal republic');
INSERT INTO politics VALUES ('CR','15 09 1821','democratic republic');
INSERT INTO politics VALUES ('NIC','15 09 1821','republic');
INSERT INTO politics VALUES ('PA','03 11 1903','constitutional republic');
INSERT INTO politics VALUES ('C','20 05 1902','Communist state');
INSERT INTO politics VALUES ('WD','03 11 1978','parliamentary democracy');
INSERT INTO politics VALUES ('DOM','27 02 1844','republic');
INSERT INTO politics VALUES ('RH','01 01 1804','republic');
INSERT INTO politics VALUES ('ES','15 09 1821','republic');
INSERT INTO politics VALUES ('HCA','15 09 1821','republic');
INSERT INTO politics VALUES ('WG','07 02 1974','parliamentary democracy');
INSERT INTO politics VALUES ('JA','06 08 1962','parliamentary democracy');
INSERT INTO politics VALUES ('CO','20 07 1810','republic');
INSERT INTO politics VALUES ('KN','19 09 1983','constitutional monarchy');
INSERT INTO politics VALUES ('WL','22 02 1979','parliamentary democracy');
INSERT INTO politics VALUES ('WV','27 10 1979','constitutional monarchy');
INSERT INTO politics VALUES ('TT','31 08 1962','parliamentary democracy');
INSERT INTO politics VALUES ('AUS','01 01 1901','federal parliamentary state');
INSERT INTO politics VALUES ('FJI','10 10 1970','republic');
INSERT INTO politics VALUES ('KIR','12 07 1979','republic');
INSERT INTO politics VALUES ('MH','21 10 1986','constitutional government in free association with the US');
INSERT INTO politics VALUES ('FSM','03 11 1986','constitutional government in free association with the US');
INSERT INTO politics VALUES ('NAU','31 01 1968','republic');
INSERT INTO politics VALUES ('NCA',NULL,'overseas territory of France since 1956');
INSERT INTO politics VALUES ('NZ','26 09 1907','parliamentary democracy');
INSERT INTO politics VALUES ('PAL','01 10 1994','constitutional government in free association with the US');
INSERT INTO politics VALUES ('SLB','07 07 1978','parliamentary democracy');
INSERT INTO politics VALUES ('TO','04 06 1970','hereditary constitutional monarchy');
INSERT INTO politics VALUES ('TUV','01 10 1978','democracy');
INSERT INTO politics VALUES ('VU','30 07 1980','republic');
INSERT INTO politics VALUES ('WS','01 01 1962','constitutional monarchy under native chief');
INSERT INTO politics VALUES ('RA','09 07 1816','republic');
INSERT INTO politics VALUES ('BOL','06 08 1825','republic');
INSERT INTO politics VALUES ('BR','07 09 1822','federal republic');
INSERT INTO politics VALUES ('RCH','18 09 1810','republic');
INSERT INTO politics VALUES ('PY','14 05 1811','republic');
INSERT INTO politics VALUES ('ROU','25 08 1828','republic');
INSERT INTO politics VALUES ('PE','28 07 1821','republic');
INSERT INTO politics VALUES ('FGU',NULL,'overseas department of France');
INSERT INTO politics VALUES ('GUY','26 05 1966','republic');
INSERT INTO politics VALUES ('SME','25 11 1975','republic');
INSERT INTO politics VALUES ('YV','05 07 1811','republic');
INSERT INTO politics VALUES ('EC','24 05 1822','republic');
INSERT INTO politics VALUES ('DZ','05 07 1962','republic');
INSERT INTO politics VALUES ('LAR','24 12 1951','Jamahiriya in theory');
INSERT INTO politics VALUES ('RMM','22 09 1960','republic');
INSERT INTO politics VALUES ('RIM','28 11 1960','republic');
INSERT INTO politics VALUES ('MA','02 03 1956','constitutional monarchy');
INSERT INTO politics VALUES ('RN','03 08 1960','republic');
INSERT INTO politics VALUES ('TN','20 03 1956','republic');
INSERT INTO politics VALUES ('WSA',NULL,'legal status of territory and question of sovereignty unresolved');
INSERT INTO politics VALUES ('ANG','11 11 1975','transitional government nominally a multiparty democracy with a strong presidential system');
INSERT INTO politics VALUES ('RCB','15 08 1960','republic');
INSERT INTO politics VALUES ('NAM','21 03 1990','republic');
INSERT INTO politics VALUES ('ZRE','30 06 1960','republic with a strong presidential system');
INSERT INTO politics VALUES ('Z','24 10 1964','republic');
INSERT INTO politics VALUES ('BEN','01 08 1960','republic under multiparty democratic rule dropped Marxism Leninism December 1989');
INSERT INTO politics VALUES ('BF','05 08 1960','parliamentary');
INSERT INTO politics VALUES ('WAN','01 10 1960','military government');
INSERT INTO politics VALUES ('RT','27 04 1960','republic under transition to multiparty democratic rule');
INSERT INTO politics VALUES ('RB','30 09 1966','parliamentary republic');
INSERT INTO politics VALUES ('RSA','31 05 1910','republic');
INSERT INTO politics VALUES ('ZW','18 04 1980','parliamentary democracy');
INSERT INTO politics VALUES ('CI','07 08 1960','republic');
INSERT INTO politics VALUES ('GH','06 03 1957','constitutional democracy');
INSERT INTO politics VALUES ('BI','01 07 1962','republic');
INSERT INTO politics VALUES ('RWA','01 07 1962','republic');
INSERT INTO politics VALUES ('EAT','26 04 1964','republic');
INSERT INTO politics VALUES ('CAM','01 01 1960','unitary republic');
INSERT INTO politics VALUES ('RCA','13 08 1960','republic');
INSERT INTO politics VALUES ('TCH','11 08 1960','republic');
INSERT INTO politics VALUES ('GQ','12 10 1968','republic in transition to multiparty democracy');
INSERT INTO politics VALUES ('G','17 08 1960','republic');
INSERT INTO politics VALUES ('CV','05 07 1975','republic');
INSERT INTO politics VALUES ('SUD','01 01 1956','transitional previously ruling military junta');
INSERT INTO politics VALUES ('COM','06 07 1975','independent republic');
INSERT INTO politics VALUES ('RG','02 10 1958','republic');
INSERT INTO politics VALUES ('LB',NULL,'republic');
INSERT INTO politics VALUES ('DJI','27 06 1977','republic');
INSERT INTO politics VALUES ('ER','27 05 1993','transitional government');
INSERT INTO politics VALUES ('ETH',NULL,'federal republic');
INSERT INTO politics VALUES ('SP','01 07 1960','none');
INSERT INTO politics VALUES ('EAK','12 12 1963','republic');
INSERT INTO politics VALUES ('WAG','18 02 1965','republic under multiparty democratic rule');
INSERT INTO politics VALUES ('SN','20 08 1960','republic under multiparty democratic rule');
INSERT INTO politics VALUES ('GNB','10 09 1974','republic');
INSERT INTO politics VALUES ('WAL','27 04 1961','constitutional democracy');
INSERT INTO politics VALUES ('EAU','09 10 1962','republic');
INSERT INTO politics VALUES ('LS','04 10 1966','modified constitutional monarchy');
INSERT INTO politics VALUES ('RM','26 06 1960','republic');
INSERT INTO politics VALUES ('MW','06 07 1964','multiparty democracy');
INSERT INTO politics VALUES ('MOC','25 06 1975','republic');
INSERT INTO politics VALUES ('MS','12 03 1968','parliamentary democracy');
INSERT INTO politics VALUES ('SD','06 09 1968','monarchy');
INSERT INTO politics VALUES ('STP','12 07 1975','republic');
INSERT INTO politics VALUES ('SY','29 06 1976','republic');

COMMIT;



INSERT INTO economy VALUES ('AL',4100,55,NULL,NULL,16);
INSERT INTO economy VALUES ('GR',101700,11.8,22.2,66,8.1);
INSERT INTO economy VALUES ('MK',1900,24,44,32,14.8);
INSERT INTO economy VALUES ('YU',20600,NULL,NULL,NULL,20);
INSERT INTO economy VALUES ('AND',1000,NULL,NULL,NULL,NULL);
INSERT INTO economy VALUES ('F',1173000,2.4,26.5,71.1,1.7);
INSERT INTO economy VALUES ('E',565000,3.6,33.6,62.8,4.3);
INSERT INTO economy VALUES ('A',152000,2,34,64,2.3);
INSERT INTO economy VALUES ('CZ',106200,5.8,40.7,53.5,9.1);
INSERT INTO economy VALUES ('D',1452200,1,34.2,64.8,NULL);
INSERT INTO economy VALUES ('H',72500,7.3,37.5,55.2,28.3);
INSERT INTO economy VALUES ('I',1088600,2.9,31.6,65.5,5.4);
INSERT INTO economy VALUES ('FL',630,NULL,NULL,NULL,5.4);
INSERT INTO economy VALUES ('SK',39000,6.7,47.6,45.7,7.5);
INSERT INTO economy VALUES ('SLO',22600,5.3,39.9,54.8,8);
INSERT INTO economy VALUES ('CH',158500,3,33.5,63.5,1.8);
INSERT INTO economy VALUES ('BY',49200,21,49,30,244);
INSERT INTO economy VALUES ('LV',14700,9,31,60,20);
INSERT INTO economy VALUES ('LT',13300,20,42,38,35);
INSERT INTO economy VALUES ('PL',226700,7,38,55,21.6);
INSERT INTO economy VALUES ('UA',174600,31,43,26,9);
INSERT INTO economy VALUES ('R',796000,6,41,53,7);
INSERT INTO economy VALUES ('B',197000,2,28,70,1.6);
INSERT INTO economy VALUES ('L',10000,1.4,33.7,64.9,3.6);
INSERT INTO economy VALUES ('NL',301900,3.4,26.9,69.7,2.25);
INSERT INTO economy VALUES ('BIH',1000,NULL,NULL,NULL,NULL);
INSERT INTO economy VALUES ('HR',20100,12.7,30.6,56.7,3.7);
INSERT INTO economy VALUES ('BG',43200,12,36,52,35);
INSERT INTO economy VALUES ('RO',105700,19.6,36.3,44.1,25);
INSERT INTO economy VALUES ('TR',345700,15.5,33.2,51.3,94);
INSERT INTO economy VALUES ('DK',112800,3,23.5,73.5,2.4);
INSERT INTO economy VALUES ('EW',12300,10,37,53,29);
INSERT INTO economy VALUES ('SF',92400,4.6,28,67.4,2);
INSERT INTO economy VALUES ('N',106200,2.9,34.7,62.4,2.5);
INSERT INTO economy VALUES ('S',177300,2,27,71,2.6);
INSERT INTO economy VALUES ('MC',788,NULL,NULL,NULL,NULL);
INSERT INTO economy VALUES ('V',NULL,NULL,NULL,NULL,NULL);
INSERT INTO economy VALUES ('IS',5000,9.6,22.1,68.3,2.5);
INSERT INTO economy VALUES ('IRL',54600,6.8,35.3,57.9,2.8);
INSERT INTO economy VALUES ('RSM',380,NULL,NULL,NULL,5.5);
INSERT INTO economy VALUES ('M',4400,NULL,NULL,NULL,5);
INSERT INTO economy VALUES ('MD',10400,33,36,31,24);
INSERT INTO economy VALUES ('P',116200,6,35.8,58.2,4.6);
INSERT INTO economy VALUES ('GB',1138400,1.7,27.7,70.6,3.1);
INSERT INTO economy VALUES ('AFG',12800,65,15,20,NULL);
INSERT INTO economy VALUES ('TJ',3500000,19,48,33,10.1);
INSERT INTO economy VALUES ('IR',323500,21,37,42,60);
INSERT INTO economy VALUES ('PK',274200,24,27,49,13);
INSERT INTO economy VALUES ('TAD',6400,NULL,NULL,NULL,28);
INSERT INTO economy VALUES ('TM',11500,32.5,33.4,34.1,25);
INSERT INTO economy VALUES ('UZB',54700,NULL,NULL,NULL,7.7);
INSERT INTO economy VALUES ('ARM',9100,57,36,7,32.2);
INSERT INTO economy VALUES ('GE',6200,70.4,10.2,19.4,2.2);
INSERT INTO economy VALUES ('AZ',11500,NULL,NULL,NULL,85);
INSERT INTO economy VALUES ('BRN',7300,NULL,NULL,NULL,3);
INSERT INTO economy VALUES ('BD',144500,NULL,NULL,NULL,4.5);
INSERT INTO economy VALUES ('MYA',47000,60,10,30,38);
INSERT INTO economy VALUES ('IND',1408700,NULL,NULL,NULL,9);
INSERT INTO economy VALUES ('BHT',1300,NULL,NULL,NULL,8.6);
INSERT INTO economy VALUES ('BRU',4600,3,42,55,2.4);
INSERT INTO economy VALUES ('MAL',193600,8,25,67,5.3);
INSERT INTO economy VALUES ('LAO',5200,50,17,33,20);
INSERT INTO economy VALUES ('THA',416700,10.2,30.6,59.2,5.8);
INSERT INTO economy VALUES ('K',7000,52,13.5,34.5,6);
INSERT INTO economy VALUES ('VN',97000,28,28,44,14);
INSERT INTO economy VALUES ('KAZ',46900,28.5,41.5,30,60.3);
INSERT INTO economy VALUES ('NOK',21500,25,60,15,NULL);
INSERT INTO economy VALUES ('KGZ',5400,NULL,NULL,NULL,32);
INSERT INTO economy VALUES ('MNG',4900,28,35,37,53);
INSERT INTO economy VALUES ('NEP',25200,49.3,18.4,32.3,6.7);
INSERT INTO economy VALUES ('CY',7800,5.6,24.9,69.5,NULL);
INSERT INTO economy VALUES ('IL',80100,3.5,22,74.5,10.1);
INSERT INTO economy VALUES ('ET',171000,NULL,NULL,NULL,9.4);
INSERT INTO economy VALUES ('RI',710900,17,32.6,50.4,8.6);
INSERT INTO economy VALUES ('PNG',10200,NULL,NULL,NULL,15);
INSERT INTO economy VALUES ('IRQ',41100,NULL,NULL,NULL,NULL);
INSERT INTO economy VALUES ('JOR',19300,11,25,64,3);
INSERT INTO economy VALUES ('KWT',30800,0,55,45,5);
INSERT INTO economy VALUES ('SA',189300,9,50,41,5);
INSERT INTO economy VALUES ('SYR',91200,30,25,45,15.1);
INSERT INTO economy VALUES ('RL',18300,13,28,59,9);
INSERT INTO economy VALUES ('J',2679200,2.1,40.2,57.7,-0.1);
INSERT INTO economy VALUES ('ROK',590700,8,45,47,4.3);
INSERT INTO economy VALUES ('MV',390,21.5,15.3,63.2,16.5);
INSERT INTO economy VALUES ('OM',19100,3,60,37,-0.7);
INSERT INTO economy VALUES ('UAE',70100,2,55,43,4.6);
INSERT INTO economy VALUES ('YE',37100,21,24,55,71.3);
INSERT INTO economy VALUES ('RP',179700,22,30,48,8.1);
INSERT INTO economy VALUES ('Q',10700,1,50,49,3);
INSERT INTO economy VALUES ('SGP',66100,NULL,28,72,1.7);
INSERT INTO economy VALUES ('CL',65600,24,24,52,8.4);
INSERT INTO economy VALUES ('RC',290500,3.6,37.3,59.1,4);
INSERT INTO economy VALUES ('AG',425,3.5,19.3,77.2,3.5);
INSERT INTO economy VALUES ('BS',4800,3,35,62,1.5);
INSERT INTO economy VALUES ('BDS',2500,6.4,39.3,54.3,1.7);
INSERT INTO economy VALUES ('BZ',575,30,NULL,NULL,2.3);
INSERT INTO economy VALUES ('GCA',36700,25,20,55,9);
INSERT INTO economy VALUES ('MEX',721400,8.5,28.4,63.1,52);
INSERT INTO economy VALUES ('CDN',694000,2,26,72,2.4);
INSERT INTO economy VALUES ('USA',7247700,2,23,75,2.5);
INSERT INTO economy VALUES ('CR',18400,NULL,NULL,NULL,22.5);
INSERT INTO economy VALUES ('NIC',7100,NULL,NULL,NULL,11.4);
INSERT INTO economy VALUES ('PA',13600,10,16,74,1.1);
INSERT INTO economy VALUES ('C',14700,7,30,63,NULL);
INSERT INTO economy VALUES ('WD',200,26,NULL,NULL,0.4);
INSERT INTO economy VALUES ('DOM',26800,13,32,55,9.5);
INSERT INTO economy VALUES ('RH',6500,34.8,23,42.2,14.5);
INSERT INTO economy VALUES ('ES',11400,NULL,NULL,NULL,11.4);
INSERT INTO economy VALUES ('HCA',10800,30,20,50,30);
INSERT INTO economy VALUES ('WG',284,10.2,40.3,49.5,3);
INSERT INTO economy VALUES ('JA',8200,7.9,28.1,64,25.5);
INSERT INTO economy VALUES ('CO',192500,21.5,29,49.5,19.5);
INSERT INTO economy VALUES ('KN',220,6.2,35.7,58.1,-0.9);
INSERT INTO economy VALUES ('WL',640,13.8,17.4,68.8,0.8);
INSERT INTO economy VALUES ('WV',240,24,33.1,42.9,-0.2);
INSERT INTO economy VALUES ('TT',16200,4.8,44.5,50.7,5.4);
INSERT INTO economy VALUES ('AUS',405400,3.1,27.7,69.2,4.75);
INSERT INTO economy VALUES ('FJI',4700,22,17,61,2);
INSERT INTO economy VALUES ('KIR',68,NULL,NULL,NULL,5.5);
INSERT INTO economy VALUES ('MH',94,NULL,NULL,NULL,4);
INSERT INTO economy VALUES ('FSM',205,NULL,NULL,NULL,4);
INSERT INTO economy VALUES ('NAU',100,NULL,NULL,NULL,-3.6);
INSERT INTO economy VALUES ('NCA',1500,5,35,60,1.4);
INSERT INTO economy VALUES ('NZ',62300,7.3,25.9,66.8,2);
INSERT INTO economy VALUES ('PAL',81.8,NULL,NULL,NULL,NULL);
INSERT INTO economy VALUES ('SLB',1000,NULL,NULL,NULL,13);
INSERT INTO economy VALUES ('TO',228,40,NULL,NULL,3);
INSERT INTO economy VALUES ('TUV',7.8,NULL,NULL,NULL,2.9);
INSERT INTO economy VALUES ('VU',210,NULL,NULL,NULL,7);
INSERT INTO economy VALUES ('WS',415,50,NULL,NULL,18);
INSERT INTO economy VALUES ('RA',278500,6,31,63,1.7);
INSERT INTO economy VALUES ('BOL',20000,NULL,NULL,NULL,12);
INSERT INTO economy VALUES ('BR',976800,16,25,59,23);
INSERT INTO economy VALUES ('RCH',113200,7.4,36.4,56.2,8.1);
INSERT INTO economy VALUES ('PY',17000,25.7,25.8,48.5,10.5);
INSERT INTO economy VALUES ('ROU',24400,10.5,27.5,62,35.4);
INSERT INTO economy VALUES ('PE',87000,NULL,NULL,NULL,10.2);
INSERT INTO economy VALUES ('FGU',800,NULL,NULL,NULL,2.5);
INSERT INTO economy VALUES ('GUY',1600,26.5,27.8,45.7,8.1);
INSERT INTO economy VALUES ('SME',1300,21.6,23.7,54.7,62);
INSERT INTO economy VALUES ('YV',195500,5,41,54,57);
INSERT INTO economy VALUES ('EC',44600,13,39,48,25);
INSERT INTO economy VALUES ('DZ',108700,12,50,38,28);
INSERT INTO economy VALUES ('LAR',32900,NULL,NULL,NULL,25);
INSERT INTO economy VALUES ('RMM',5400,42.4,15.4,42.2,8);
INSERT INTO economy VALUES ('RIM',2800,27.1,29.5,43.4,3.5);
INSERT INTO economy VALUES ('MA',87400,14.3,32.2,53.5,5.4);
INSERT INTO economy VALUES ('RN',5500,38.5,17.9,43.6,35.6);
INSERT INTO economy VALUES ('TN',37100,15,30,55,5.5);
INSERT INTO economy VALUES ('WSA',NULL,NULL,NULL,NULL,NULL);
INSERT INTO economy VALUES ('ANG',7400,12,56,32,20);
INSERT INTO economy VALUES ('RCB',7700,11.4,35.2,53.4,61);
INSERT INTO economy VALUES ('NAM',5800,NULL,NULL,NULL,11);
INSERT INTO economy VALUES ('ZRE',16500,NULL,NULL,NULL,12);
INSERT INTO economy VALUES ('Z',8900,32,22,46,55);
INSERT INTO economy VALUES ('BEN',7600,36.8,12.6,50.6,55);
INSERT INTO economy VALUES ('BF',7400,32,24,44,5);
INSERT INTO economy VALUES ('WAN',135900,38,22,40,57);
INSERT INTO economy VALUES ('RT',4100,49.2,17.7,33.1,8.8);
INSERT INTO economy VALUES ('RB',4500,5,NULL,NULL,10);
INSERT INTO economy VALUES ('RSA',215000,NULL,NULL,NULL,8.7);
INSERT INTO economy VALUES ('ZW',18100,18.3,35.3,46.4,25.8);
INSERT INTO economy VALUES ('CI',21900,37,24,39,10);
INSERT INTO economy VALUES ('GH',25100,47,16,37,69);
INSERT INTO economy VALUES ('BI',4000,54.1,16.8,29.1,10);
INSERT INTO economy VALUES ('RWA',3800,52,13,35,64);
INSERT INTO economy VALUES ('EAT',23100,58,8,34,25);
INSERT INTO economy VALUES ('CAM',16500,29,24,47,48);
INSERT INTO economy VALUES ('RCA',2500,50,14,36,45);
INSERT INTO economy VALUES ('TCH',3300,49,17,34,41);
INSERT INTO economy VALUES ('GQ',325,47,26,27,41);
INSERT INTO economy VALUES ('G',6000,8.2,44.7,47.1,15);
INSERT INTO economy VALUES ('CV',440,13,17,70,5);
INSERT INTO economy VALUES ('SUD',25000,33,17,50,66);
INSERT INTO economy VALUES ('COM',370,NULL,NULL,NULL,15);
INSERT INTO economy VALUES ('RG',6500,24,31,45,4.1);
INSERT INTO economy VALUES ('LB',2300,NULL,NULL,NULL,50);
INSERT INTO economy VALUES ('DJI',500,3,21,76,6);
INSERT INTO economy VALUES ('ER',2000,NULL,NULL,NULL,10);
INSERT INTO economy VALUES ('ETH',24200,48,15,37,10);
INSERT INTO economy VALUES ('SP',3600,NULL,NULL,NULL,NULL);
INSERT INTO economy VALUES ('EAK',36800,27,19,54,1.7);
INSERT INTO economy VALUES ('WAG',1100,27,15,58,1.7);
INSERT INTO economy VALUES ('SN',14500,NULL,NULL,NULL,6.1);
INSERT INTO economy VALUES ('GNB',1000,44,8,48,15);
INSERT INTO economy VALUES ('WAL',4400,40,17,43,24);
INSERT INTO economy VALUES ('EAU',16800,55,12,33,6.1);
INSERT INTO economy VALUES ('LS',2800,10.4,48.8,40.8,9.5);
INSERT INTO economy VALUES ('RM',11400,35,15,50,35);
INSERT INTO economy VALUES ('MW',6900,31,14,55,83.3);
INSERT INTO economy VALUES ('MOC',12200,33,12,55,50);
INSERT INTO economy VALUES ('MS',10900,NULL,NULL,NULL,9.4);
INSERT INTO economy VALUES ('SD',3600,25,40,35,14.7);
INSERT INTO economy VALUES ('STP',138,28,14,58,38);
INSERT INTO economy VALUES ('SY',430,NULL,NULL,NULL,3.9);

COMMIT;



INSERT INTO language VALUES ('MK','Albanian',21);
INSERT INTO language VALUES ('MK','Macedonian',70);
INSERT INTO language VALUES ('MK','Turkish',3);
INSERT INTO language VALUES ('MK','Serbo-Croatian',3);
INSERT INTO language VALUES ('YU','Albanian',5);
INSERT INTO language VALUES ('YU','Serbo-Croatian',95);
INSERT INTO language VALUES ('F','French',100);
INSERT INTO language VALUES ('E','Castilian Spanish',NULL);
INSERT INTO language VALUES ('E','Catalan',17);
INSERT INTO language VALUES ('E','Galician',7);
INSERT INTO language VALUES ('E','Basque',2);
INSERT INTO language VALUES ('A','German',100);
INSERT INTO language VALUES ('D','German',100);
INSERT INTO language VALUES ('H','Hungarian',98.2);
INSERT INTO language VALUES ('SLO','Slovenian',91);
INSERT INTO language VALUES ('SLO','Serbo-Croatian',7);
INSERT INTO language VALUES ('CH','French',18);
INSERT INTO language VALUES ('CH','German',65);
INSERT INTO language VALUES ('CH','Italian',12);
INSERT INTO language VALUES ('CH','Romansch',1);
INSERT INTO language VALUES ('PL','Polish',100);
INSERT INTO language VALUES ('R','Russian',100);
INSERT INTO language VALUES ('B','French',32);
INSERT INTO language VALUES ('B','German',1);
INSERT INTO language VALUES ('B','Dutch',56);
INSERT INTO language VALUES ('NL','Dutch',100);
INSERT INTO language VALUES ('BIH','Serbo-Croatian',99);
INSERT INTO language VALUES ('HR','Serbo-Croatian',96);
INSERT INTO language VALUES ('BG','Bulgarian',100);
INSERT INTO language VALUES ('SF','Swedish',6.3);
INSERT INTO language VALUES ('SF','Finnish',93.5);
INSERT INTO language VALUES ('SF','Lapp- Russian-speaking',NULL);
INSERT INTO language VALUES ('N','Norwegian',100);
INSERT INTO language VALUES ('S','Swedish',100);
INSERT INTO language VALUES ('IS','Icelandic',100);
INSERT INTO language VALUES ('RSM','Italian',100);
INSERT INTO language VALUES ('P','Portuguese',100);
INSERT INTO language VALUES ('AFG','Turkic',11);
INSERT INTO language VALUES ('AFG','Pashtu',35);
INSERT INTO language VALUES ('AFG','Afghan Persian',50);
INSERT INTO language VALUES ('IR','Turkish',1);
INSERT INTO language VALUES ('IR','Kurdish',9);
INSERT INTO language VALUES ('IR','Baloch',1);
INSERT INTO language VALUES ('IR','Arabic',1);
INSERT INTO language VALUES ('IR','Luri',2);
INSERT INTO language VALUES ('IR','Persian Persian',58);
INSERT INTO language VALUES ('IR','Turkic Turkic',26);
INSERT INTO language VALUES ('PK','English',NULL);
INSERT INTO language VALUES ('PK','Pashtu',8);
INSERT INTO language VALUES ('PK','Urdu',8);
INSERT INTO language VALUES ('PK','Punjabi',48);
INSERT INTO language VALUES ('PK','Sindhi',12);
INSERT INTO language VALUES ('PK','Burushaski',NULL);
INSERT INTO language VALUES ('PK','Balochi',3);
INSERT INTO language VALUES ('PK','Hindko',2);
INSERT INTO language VALUES ('PK','Brahui',1);
INSERT INTO language VALUES ('PK','Siraiki',10);
INSERT INTO language VALUES ('TM','Russian',12);
INSERT INTO language VALUES ('TM','Uzbek',9);
INSERT INTO language VALUES ('TM','Turkmen',72);
INSERT INTO language VALUES ('UZB','Russian',14.2);
INSERT INTO language VALUES ('UZB','Tajik',4.4);
INSERT INTO language VALUES ('UZB','Uzbek',74.3);
INSERT INTO language VALUES ('ARM','Russian',2);
INSERT INTO language VALUES ('ARM','Armenian',96);
INSERT INTO language VALUES ('GE','Russian',9);
INSERT INTO language VALUES ('GE','Armenian',7);
INSERT INTO language VALUES ('GE','Azeri',6);
INSERT INTO language VALUES ('GE','Georgian',71);
INSERT INTO language VALUES ('AZ','Russian',3);
INSERT INTO language VALUES ('AZ','Armenian',2);
INSERT INTO language VALUES ('AZ','Azeri',89);
INSERT INTO language VALUES ('MYA','Burmese',100);
INSERT INTO language VALUES ('IND','Hindi',30);
INSERT INTO language VALUES ('KAZ','Kazak',40);
INSERT INTO language VALUES ('NOK','Korean',100);
INSERT INTO language VALUES ('MNG','Khalkha Mongol',90);
INSERT INTO language VALUES ('NEP','Nepali',100);
INSERT INTO language VALUES ('PNG','English',1);
INSERT INTO language VALUES ('SA','Arabic',100);
INSERT INTO language VALUES ('J','Japanese',100);
INSERT INTO language VALUES ('YE','Arabic',100);
INSERT INTO language VALUES ('CL','Tamil',18);
INSERT INTO language VALUES ('CL','Sinhala',74);
INSERT INTO language VALUES ('AG','English',100);
INSERT INTO language VALUES ('BDS','English',100);
INSERT INTO language VALUES ('GCA','Spanish',60);
INSERT INTO language VALUES ('GCA','Indian',40);
INSERT INTO language VALUES ('NIC','Spanish',100);
INSERT INTO language VALUES ('PA','English',14);
INSERT INTO language VALUES ('C','Spanish',100);
INSERT INTO language VALUES ('DOM','Spanish',100);
INSERT INTO language VALUES ('RH','French',10);
INSERT INTO language VALUES ('CO','Spanish',100);
INSERT INTO language VALUES ('KN','English',100);
INSERT INTO language VALUES ('AUS','English',100);
INSERT INTO language VALUES ('SLB','English',1);
INSERT INTO language VALUES ('RCH','Spanish',100);
INSERT INTO language VALUES ('FGU','French',100);
INSERT INTO language VALUES ('RMM','Bambara',80);
INSERT INTO language VALUES ('NAM','German',32);
INSERT INTO language VALUES ('NAM','English',7);
INSERT INTO language VALUES ('NAM','Herero',NULL);
INSERT INTO language VALUES ('NAM','Nama',NULL);
INSERT INTO language VALUES ('NAM','Afrikaans',60);
INSERT INTO language VALUES ('NAM','languages: Oshivambo',NULL);
INSERT INTO language VALUES ('RG','French',100);
INSERT INTO language VALUES ('LB','English',20);
INSERT INTO language VALUES ('MOC','Portuguese',100);
INSERT INTO language VALUES ('STP','Portuguese',100);

COMMIT;



INSERT INTO ethnic_group VALUES ('AL','Greeks',3);
INSERT INTO ethnic_group VALUES ('AL','Albanian',95);
INSERT INTO ethnic_group VALUES ('GR','Greek',98);
INSERT INTO ethnic_group VALUES ('MK','Albanian',22);
INSERT INTO ethnic_group VALUES ('MK','Serb',2);
INSERT INTO ethnic_group VALUES ('MK','Macedonian',65);
INSERT INTO ethnic_group VALUES ('MK','Turkish',4);
INSERT INTO ethnic_group VALUES ('MK','Gypsies',3);
INSERT INTO ethnic_group VALUES ('YU','Serbs',63);
INSERT INTO ethnic_group VALUES ('YU','Albanians',14);
INSERT INTO ethnic_group VALUES ('YU','Montenegrins',6);
INSERT INTO ethnic_group VALUES ('YU','Hungarians',4);
INSERT INTO ethnic_group VALUES ('AND','French',6);
INSERT INTO ethnic_group VALUES ('AND','Spanish',61);
INSERT INTO ethnic_group VALUES ('AND','Andorran',30);
INSERT INTO ethnic_group VALUES ('E','Mediterranean Nordic',100);
INSERT INTO ethnic_group VALUES ('A','German',99.4);
INSERT INTO ethnic_group VALUES ('A','Slovene',0.2);
INSERT INTO ethnic_group VALUES ('A','Croatian',0.3);
INSERT INTO ethnic_group VALUES ('CZ','German',0.5);
INSERT INTO ethnic_group VALUES ('CZ','Polish',0.6);
INSERT INTO ethnic_group VALUES ('CZ','Gypsy',0.3);
INSERT INTO ethnic_group VALUES ('CZ','Hungarian',0.2);
INSERT INTO ethnic_group VALUES ('CZ','Czech',94.4);
INSERT INTO ethnic_group VALUES ('CZ','Slovak',3);
INSERT INTO ethnic_group VALUES ('D','Greeks',0.4);
INSERT INTO ethnic_group VALUES ('D','Turkish',2.3);
INSERT INTO ethnic_group VALUES ('D','German',95.1);
INSERT INTO ethnic_group VALUES ('D','Italians',0.7);
INSERT INTO ethnic_group VALUES ('D','Poles',0.4);
INSERT INTO ethnic_group VALUES ('H','Serb',2);
INSERT INTO ethnic_group VALUES ('H','German',2.6);
INSERT INTO ethnic_group VALUES ('H','Gypsy',4);
INSERT INTO ethnic_group VALUES ('H','Hungarian',89.9);
INSERT INTO ethnic_group VALUES ('H','Slovak',0.8);
INSERT INTO ethnic_group VALUES ('H','Romanian',0.7);
INSERT INTO ethnic_group VALUES ('FL','Italian',5);
INSERT INTO ethnic_group VALUES ('FL','Alemannic',95);
INSERT INTO ethnic_group VALUES ('SK','German',0.1);
INSERT INTO ethnic_group VALUES ('SK','Polish',0.1);
INSERT INTO ethnic_group VALUES ('SK','Gypsy',1.5);
INSERT INTO ethnic_group VALUES ('SK','Hungarian',10.7);
INSERT INTO ethnic_group VALUES ('SK','Czech',1);
INSERT INTO ethnic_group VALUES ('SK','Slovak',85.7);
INSERT INTO ethnic_group VALUES ('SK','Ukrainian',0.3);
INSERT INTO ethnic_group VALUES ('SK','Ruthenian',0.3);
INSERT INTO ethnic_group VALUES ('SLO','Serb',2);
INSERT INTO ethnic_group VALUES ('SLO','Slovene',91);
INSERT INTO ethnic_group VALUES ('SLO','Muslim',1);
INSERT INTO ethnic_group VALUES ('SLO','Croat',3);
INSERT INTO ethnic_group VALUES ('BY','Polish',4.1);
INSERT INTO ethnic_group VALUES ('BY','Ukrainian',2.9);
INSERT INTO ethnic_group VALUES ('BY','Russian',13.2);
INSERT INTO ethnic_group VALUES ('BY','Byelorussian',77.9);
INSERT INTO ethnic_group VALUES ('LV','Polish',2.3);
INSERT INTO ethnic_group VALUES ('LV','Ukrainian',3.4);
INSERT INTO ethnic_group VALUES ('LV','Russian',33.8);
INSERT INTO ethnic_group VALUES ('LV','Byelorussian',4.5);
INSERT INTO ethnic_group VALUES ('LV','Latvian',51.8);
INSERT INTO ethnic_group VALUES ('LT','Polish',7.7);
INSERT INTO ethnic_group VALUES ('LT','Russian',8.6);
INSERT INTO ethnic_group VALUES ('LT','Byelorussian',1.5);
INSERT INTO ethnic_group VALUES ('LT','Lithuanian',80.1);
INSERT INTO ethnic_group VALUES ('PL','German',1.3);
INSERT INTO ethnic_group VALUES ('PL','Polish',97.6);
INSERT INTO ethnic_group VALUES ('PL','Ukrainian',0.6);
INSERT INTO ethnic_group VALUES ('PL','Byelorussian',0.5);
INSERT INTO ethnic_group VALUES ('UA','Ukrainian',73);
INSERT INTO ethnic_group VALUES ('UA','Russian',22);
INSERT INTO ethnic_group VALUES ('UA','Jewish',1);
INSERT INTO ethnic_group VALUES ('R','Ukrainian',3);
INSERT INTO ethnic_group VALUES ('R','Russian',81.5);
INSERT INTO ethnic_group VALUES ('R','Byelorussian',0.8);
INSERT INTO ethnic_group VALUES ('R','Tatar',3.8);
INSERT INTO ethnic_group VALUES ('R','Chuvash',1.2);
INSERT INTO ethnic_group VALUES ('R','Bashkir',0.9);
INSERT INTO ethnic_group VALUES ('R','Moldavian',0.7);
INSERT INTO ethnic_group VALUES ('B','Fleming',55);
INSERT INTO ethnic_group VALUES ('B','Walloon',33);
INSERT INTO ethnic_group VALUES ('NL','Dutch',96);
INSERT INTO ethnic_group VALUES ('BIH','Serb',40);
INSERT INTO ethnic_group VALUES ('BIH','Muslim',38);
INSERT INTO ethnic_group VALUES ('BIH','Croat',22);
INSERT INTO ethnic_group VALUES ('HR','Serb',12);
INSERT INTO ethnic_group VALUES ('HR','Hungarian',0.5);
INSERT INTO ethnic_group VALUES ('HR','Muslim',0.9);
INSERT INTO ethnic_group VALUES ('HR','Croat',78);
INSERT INTO ethnic_group VALUES ('HR','Slovenian',0.5);
INSERT INTO ethnic_group VALUES ('BG','Macedonian',2.5);
INSERT INTO ethnic_group VALUES ('BG','Gypsy',2.6);
INSERT INTO ethnic_group VALUES ('BG','Russian',0.2);
INSERT INTO ethnic_group VALUES ('BG','Turk',8.5);
INSERT INTO ethnic_group VALUES ('BG','Bulgarian',85.3);
INSERT INTO ethnic_group VALUES ('BG','Armenian',0.3);
INSERT INTO ethnic_group VALUES ('RO','Serb',NULL);
INSERT INTO ethnic_group VALUES ('RO','German',0.4);
INSERT INTO ethnic_group VALUES ('RO','Gypsy',1.6);
INSERT INTO ethnic_group VALUES ('RO','Hungarian',8.9);
INSERT INTO ethnic_group VALUES ('RO','Romanian',89.1);
INSERT INTO ethnic_group VALUES ('RO','Ukrainian',NULL);
INSERT INTO ethnic_group VALUES ('RO','Croat',NULL);
INSERT INTO ethnic_group VALUES ('RO','Russian',NULL);
INSERT INTO ethnic_group VALUES ('RO','Turk',NULL);
INSERT INTO ethnic_group VALUES ('TR','Turkish',80);
INSERT INTO ethnic_group VALUES ('TR','Kurdish',20);
INSERT INTO ethnic_group VALUES ('EW','Ukrainian',3.2);
INSERT INTO ethnic_group VALUES ('EW','Russian',30.3);
INSERT INTO ethnic_group VALUES ('EW','Byelorussian',1.8);
INSERT INTO ethnic_group VALUES ('EW','Finn',1.1);
INSERT INTO ethnic_group VALUES ('EW','Estonian',61.5);
INSERT INTO ethnic_group VALUES ('S','foreign-born first-generation',12);
INSERT INTO ethnic_group VALUES ('MC','French',47);
INSERT INTO ethnic_group VALUES ('MC','Italian',16);
INSERT INTO ethnic_group VALUES ('MC','Monegasque',16);
INSERT INTO ethnic_group VALUES ('IS','Norwegians Celts',100);
INSERT INTO ethnic_group VALUES ('MD','Ukrainian',13.8);
INSERT INTO ethnic_group VALUES ('MD','Russian',13);
INSERT INTO ethnic_group VALUES ('MD','Jewish',1.5);
INSERT INTO ethnic_group VALUES ('MD','Bulgarian',2);
INSERT INTO ethnic_group VALUES ('MD','Gagauz',3.5);
INSERT INTO ethnic_group VALUES ('MD','Moldavian/Romanian',64.5);
INSERT INTO ethnic_group VALUES ('GB','English',81.5);
INSERT INTO ethnic_group VALUES ('GB','West Indian',NULL);
INSERT INTO ethnic_group VALUES ('GB','Indian',NULL);
INSERT INTO ethnic_group VALUES ('GB','Pakistani',NULL);
INSERT INTO ethnic_group VALUES ('GB','Irish',2.4);
INSERT INTO ethnic_group VALUES ('GB','Welsh',1.9);
INSERT INTO ethnic_group VALUES ('GB','Scottish',9.6);
INSERT INTO ethnic_group VALUES ('GB','Ulster',1.8);
INSERT INTO ethnic_group VALUES ('AFG','Tajik',25);
INSERT INTO ethnic_group VALUES ('AFG','Pashtun',38);
INSERT INTO ethnic_group VALUES ('AFG','Uzbek',6);
INSERT INTO ethnic_group VALUES ('AFG','Hazara',19);
INSERT INTO ethnic_group VALUES ('TJ','Han Chinese',91.9);
INSERT INTO ethnic_group VALUES ('IR','Arab',3);
INSERT INTO ethnic_group VALUES ('IR','Persian',51);
INSERT INTO ethnic_group VALUES ('IR','Baloch',2);
INSERT INTO ethnic_group VALUES ('IR','Azerbaijani',24);
INSERT INTO ethnic_group VALUES ('IR','Kurd',7);
INSERT INTO ethnic_group VALUES ('IR','Lur',2);
INSERT INTO ethnic_group VALUES ('IR','Turkmen',2);
INSERT INTO ethnic_group VALUES ('IR','Gilaki Mazandarani',8);
INSERT INTO ethnic_group VALUES ('TAD','Russian',3.5);
INSERT INTO ethnic_group VALUES ('TAD','Tajik',64.9);
INSERT INTO ethnic_group VALUES ('TAD','Uzbek',25);
INSERT INTO ethnic_group VALUES ('TM','Russian',9.8);
INSERT INTO ethnic_group VALUES ('TM','Uzbek',9);
INSERT INTO ethnic_group VALUES ('TM','Turkmen',73.3);
INSERT INTO ethnic_group VALUES ('TM','Kazak',2);
INSERT INTO ethnic_group VALUES ('UZB','Russian',8.3);
INSERT INTO ethnic_group VALUES ('UZB','Tatar',2.4);
INSERT INTO ethnic_group VALUES ('UZB','Tajik',4.7);
INSERT INTO ethnic_group VALUES ('UZB','Uzbek',71.4);
INSERT INTO ethnic_group VALUES ('UZB','Kazak',4.1);
INSERT INTO ethnic_group VALUES ('UZB','Karakalpak',2.1);
INSERT INTO ethnic_group VALUES ('ARM','Russian',2);
INSERT INTO ethnic_group VALUES ('ARM','Armenian',93);
INSERT INTO ethnic_group VALUES ('ARM','Azeri',3);
INSERT INTO ethnic_group VALUES ('GE','Russian',6.3);
INSERT INTO ethnic_group VALUES ('GE','Armenian',8.1);
INSERT INTO ethnic_group VALUES ('GE','Azeri',5.7);
INSERT INTO ethnic_group VALUES ('GE','Georgian',70.1);
INSERT INTO ethnic_group VALUES ('GE','Ossetian',3);
INSERT INTO ethnic_group VALUES ('GE','Abkhaz',1.8);
INSERT INTO ethnic_group VALUES ('AZ','Russian',2.5);
INSERT INTO ethnic_group VALUES ('AZ','Armenian',2.3);
INSERT INTO ethnic_group VALUES ('AZ','Azeri',90);
INSERT INTO ethnic_group VALUES ('AZ','Dagestani Peoples',3.2);
INSERT INTO ethnic_group VALUES ('BRN','Arab',10);
INSERT INTO ethnic_group VALUES ('BRN','Asian',13);
INSERT INTO ethnic_group VALUES ('BRN','Bahraini',63);
INSERT INTO ethnic_group VALUES ('BRN','Iranian',8);
INSERT INTO ethnic_group VALUES ('BD','Bengali',98);
INSERT INTO ethnic_group VALUES ('MYA','Indian',2);
INSERT INTO ethnic_group VALUES ('MYA','Chinese',3);
INSERT INTO ethnic_group VALUES ('MYA','Burman',68);
INSERT INTO ethnic_group VALUES ('MYA','Shan',9);
INSERT INTO ethnic_group VALUES ('MYA','Karen',7);
INSERT INTO ethnic_group VALUES ('MYA','Rakhine',4);
INSERT INTO ethnic_group VALUES ('MYA','Mon',2);
INSERT INTO ethnic_group VALUES ('IND','Dravidian',25);
INSERT INTO ethnic_group VALUES ('IND','Indo-Aryan',72);
INSERT INTO ethnic_group VALUES ('IND','Mongoloid',3);
INSERT INTO ethnic_group VALUES ('BHT','Bhote',50);
INSERT INTO ethnic_group VALUES ('BHT','Nepalese',35);
INSERT INTO ethnic_group VALUES ('BRU','Chinese',20);
INSERT INTO ethnic_group VALUES ('BRU','Malay',64);
INSERT INTO ethnic_group VALUES ('MAL','Indian',9);
INSERT INTO ethnic_group VALUES ('MAL','Chinese',32);
INSERT INTO ethnic_group VALUES ('MAL','Malay',59);
INSERT INTO ethnic_group VALUES ('LAO','Lao Loum',68);
INSERT INTO ethnic_group VALUES ('LAO','Lao Theung',22);
INSERT INTO ethnic_group VALUES ('LAO','Lao Soung Hmong Yao',9);
INSERT INTO ethnic_group VALUES ('LAO','Vietnamese/Chinese',1);
INSERT INTO ethnic_group VALUES ('THA','Chinese',14);
INSERT INTO ethnic_group VALUES ('THA','Thai',75);
INSERT INTO ethnic_group VALUES ('K','Chinese',1);
INSERT INTO ethnic_group VALUES ('K','Khmer',90);
INSERT INTO ethnic_group VALUES ('K','Vietnamese',5);
INSERT INTO ethnic_group VALUES ('VN','Man',NULL);
INSERT INTO ethnic_group VALUES ('VN','Chinese',3);
INSERT INTO ethnic_group VALUES ('VN','Thai',NULL);
INSERT INTO ethnic_group VALUES ('VN','Khmer',NULL);
INSERT INTO ethnic_group VALUES ('VN','Vietnamese',85);
INSERT INTO ethnic_group VALUES ('VN','Muong',NULL);
INSERT INTO ethnic_group VALUES ('VN','Meo',NULL);
INSERT INTO ethnic_group VALUES ('VN','Cham',NULL);
INSERT INTO ethnic_group VALUES ('KAZ','German',4.7);
INSERT INTO ethnic_group VALUES ('KAZ','Ukrainian',5.2);
INSERT INTO ethnic_group VALUES ('KAZ','Russian',37);
INSERT INTO ethnic_group VALUES ('KAZ','Tatar',2);
INSERT INTO ethnic_group VALUES ('KAZ','Uzbek',2.1);
INSERT INTO ethnic_group VALUES ('KAZ','Kazak',41.9);
INSERT INTO ethnic_group VALUES ('KGZ','German',2.4);
INSERT INTO ethnic_group VALUES ('KGZ','Ukrainian',2.5);
INSERT INTO ethnic_group VALUES ('KGZ','Russian',21.5);
INSERT INTO ethnic_group VALUES ('KGZ','Uzbek',12.9);
INSERT INTO ethnic_group VALUES ('KGZ','Kirghiz',52.4);
INSERT INTO ethnic_group VALUES ('MNG','Russian',2);
INSERT INTO ethnic_group VALUES ('MNG','Kazak',4);
INSERT INTO ethnic_group VALUES ('MNG','Chinese',2);
INSERT INTO ethnic_group VALUES ('MNG','Mongol',90);
INSERT INTO ethnic_group VALUES ('IL','Jewish',82);
INSERT INTO ethnic_group VALUES ('IL','non-Jewish',18);
INSERT INTO ethnic_group VALUES ('ET','Greek',NULL);
INSERT INTO ethnic_group VALUES ('ET','Armenian',NULL);
INSERT INTO ethnic_group VALUES ('ET','European',1);
INSERT INTO ethnic_group VALUES ('ET','Nubian',NULL);
INSERT INTO ethnic_group VALUES ('ET','Eastern Hamitic',99);
INSERT INTO ethnic_group VALUES ('RI','Javanese',45);
INSERT INTO ethnic_group VALUES ('RI','Sundanese',14);
INSERT INTO ethnic_group VALUES ('RI','Madurese',7.5);
INSERT INTO ethnic_group VALUES ('RI','Malays',7.5);
INSERT INTO ethnic_group VALUES ('IRQ','Kurdish',15);
INSERT INTO ethnic_group VALUES ('IRQ','Arab',75);
INSERT INTO ethnic_group VALUES ('IRQ','Turkoman',NULL);
INSERT INTO ethnic_group VALUES ('IRQ','Assyrian',5);
INSERT INTO ethnic_group VALUES ('JOR','Armenian',1);
INSERT INTO ethnic_group VALUES ('JOR','Arab',98);
INSERT INTO ethnic_group VALUES ('JOR','Circassian',1);
INSERT INTO ethnic_group VALUES ('KWT','Arab',35);
INSERT INTO ethnic_group VALUES ('KWT','Iranian',4);
INSERT INTO ethnic_group VALUES ('KWT','South Asian',9);
INSERT INTO ethnic_group VALUES ('KWT','Kuwaiti',45);
INSERT INTO ethnic_group VALUES ('SA','Arab',90);
INSERT INTO ethnic_group VALUES ('SA','Afro-Asian',10);
INSERT INTO ethnic_group VALUES ('SYR','Arab',90.3);
INSERT INTO ethnic_group VALUES ('RL','Armenian',4);
INSERT INTO ethnic_group VALUES ('RL','Arab',95);
INSERT INTO ethnic_group VALUES ('J','Japanese',99.4);
INSERT INTO ethnic_group VALUES ('UAE','South Asian',50);
INSERT INTO ethnic_group VALUES ('UAE','Emiri',19);
INSERT INTO ethnic_group VALUES ('UAE','Arab Iranian',23);
INSERT INTO ethnic_group VALUES ('RP','Chinese',1.5);
INSERT INTO ethnic_group VALUES ('RP','Christian Malay',91.5);
INSERT INTO ethnic_group VALUES ('RP','Muslim Malay',4);
INSERT INTO ethnic_group VALUES ('Q','Indian',18);
INSERT INTO ethnic_group VALUES ('Q','Pakistani',18);
INSERT INTO ethnic_group VALUES ('Q','Arab',40);
INSERT INTO ethnic_group VALUES ('Q','Iranian',10);
INSERT INTO ethnic_group VALUES ('SGP','Indian',6.4);
INSERT INTO ethnic_group VALUES ('SGP','Chinese',76.4);
INSERT INTO ethnic_group VALUES ('SGP','Malay',14.9);
INSERT INTO ethnic_group VALUES ('CL','Malay',NULL);
INSERT INTO ethnic_group VALUES ('CL','Sinhalese',74);
INSERT INTO ethnic_group VALUES ('CL','Burgher',NULL);
INSERT INTO ethnic_group VALUES ('CL','Tamil',18);
INSERT INTO ethnic_group VALUES ('CL','Moor',7);
INSERT INTO ethnic_group VALUES ('CL','Vedda',1);
INSERT INTO ethnic_group VALUES ('RC','Chinese',14);
INSERT INTO ethnic_group VALUES ('RC','Taiwanese',84);
INSERT INTO ethnic_group VALUES ('BDS','European',4);
INSERT INTO ethnic_group VALUES ('BDS','African',80);
INSERT INTO ethnic_group VALUES ('BZ','Creole',30);
INSERT INTO ethnic_group VALUES ('BZ','Garifuna',7);
INSERT INTO ethnic_group VALUES ('BZ','Maya',11);
INSERT INTO ethnic_group VALUES ('GCA','Mestizo - Amerindian-Spanish',56);
INSERT INTO ethnic_group VALUES ('GCA','Amerindian Amerindian',44);
INSERT INTO ethnic_group VALUES ('MEX','Amerindian Amerindian',30);
INSERT INTO ethnic_group VALUES ('MEX','Caucasian Caucasian',9);
INSERT INTO ethnic_group VALUES ('CDN','French',27);
INSERT INTO ethnic_group VALUES ('CDN','Asian',11.5);
INSERT INTO ethnic_group VALUES ('CDN','European',20);
INSERT INTO ethnic_group VALUES ('CDN','British Isles',40);
INSERT INTO ethnic_group VALUES ('CDN','Indian Eskimo',1.5);
INSERT INTO ethnic_group VALUES ('USA','Asian',3.3);
INSERT INTO ethnic_group VALUES ('USA','Native American',0.8);
INSERT INTO ethnic_group VALUES ('CR','Indian',1);
INSERT INTO ethnic_group VALUES ('CR','Chinese',1);
INSERT INTO ethnic_group VALUES ('NIC','Indian',5);
INSERT INTO ethnic_group VALUES ('PA','West Indian',14);
INSERT INTO ethnic_group VALUES ('PA','Indian',6);
INSERT INTO ethnic_group VALUES ('C','Chinese',1);
INSERT INTO ethnic_group VALUES ('WD','Carib Indians',100);
INSERT INTO ethnic_group VALUES ('RH','European',5);
INSERT INTO ethnic_group VALUES ('ES','Indian',5);
INSERT INTO ethnic_group VALUES ('HCA','Indian',7);
INSERT INTO ethnic_group VALUES ('WG','African',100);
INSERT INTO ethnic_group VALUES ('JA','African',76.3);
INSERT INTO ethnic_group VALUES ('JA','Afro-European',15.1);
INSERT INTO ethnic_group VALUES ('JA','East Indian Afro-East Indian',3);
INSERT INTO ethnic_group VALUES ('JA','Chinese Afro-Chinese',1.2);
INSERT INTO ethnic_group VALUES ('CO','Indian',1);
INSERT INTO ethnic_group VALUES ('CO','black-Indian',3);
INSERT INTO ethnic_group VALUES ('KN','African',100);
INSERT INTO ethnic_group VALUES ('WL','African',90.3);
INSERT INTO ethnic_group VALUES ('WL','East Indian',3.2);
INSERT INTO ethnic_group VALUES ('TT','Chinese',1);
INSERT INTO ethnic_group VALUES ('TT','East Indian',40);
INSERT INTO ethnic_group VALUES ('AUS','Asian',4);
INSERT INTO ethnic_group VALUES ('AUS','Caucasian',95);
INSERT INTO ethnic_group VALUES ('FJI','Indian',46);
INSERT INTO ethnic_group VALUES ('FJI','Chinese',NULL);
INSERT INTO ethnic_group VALUES ('FJI','European',NULL);
INSERT INTO ethnic_group VALUES ('FJI','Pacific Islanders',NULL);
INSERT INTO ethnic_group VALUES ('FJI','Fijian',49);
INSERT INTO ethnic_group VALUES ('KIR','Micronesian',100);
INSERT INTO ethnic_group VALUES ('MH','Micronesian',100);
INSERT INTO ethnic_group VALUES ('FSM','Micronesian Polynesian',100);
INSERT INTO ethnic_group VALUES ('NAU','Chinese',8);
INSERT INTO ethnic_group VALUES ('NAU','European',8);
INSERT INTO ethnic_group VALUES ('NAU','Nauruan',58);
INSERT INTO ethnic_group VALUES ('NAU','Pacific Islander',26);
INSERT INTO ethnic_group VALUES ('NCA','Vietnamese',1.6);
INSERT INTO ethnic_group VALUES ('NCA','European',37.1);
INSERT INTO ethnic_group VALUES ('NCA','Polynesian',3.8);
INSERT INTO ethnic_group VALUES ('NCA','Melanesian',42.5);
INSERT INTO ethnic_group VALUES ('NCA','Wallisian',8.4);
INSERT INTO ethnic_group VALUES ('NCA','Indonesian',3.6);
INSERT INTO ethnic_group VALUES ('NZ','European',88);
INSERT INTO ethnic_group VALUES ('NZ','Pacific Islander',2.9);
INSERT INTO ethnic_group VALUES ('NZ','Maori',8.9);
INSERT INTO ethnic_group VALUES ('SLB','Chinese',0.3);
INSERT INTO ethnic_group VALUES ('SLB','European',0.8);
INSERT INTO ethnic_group VALUES ('SLB','Polynesian',4);
INSERT INTO ethnic_group VALUES ('SLB','Micronesian',1.5);
INSERT INTO ethnic_group VALUES ('SLB','Melanesian',93);
INSERT INTO ethnic_group VALUES ('TUV','Polynesian',96);
INSERT INTO ethnic_group VALUES ('VU','French',4);
INSERT INTO ethnic_group VALUES ('VU','Chinese',NULL);
INSERT INTO ethnic_group VALUES ('VU','Vietnamese',NULL);
INSERT INTO ethnic_group VALUES ('VU','Pacific Islanders',NULL);
INSERT INTO ethnic_group VALUES ('VU','Melanesian',94);
INSERT INTO ethnic_group VALUES ('WS','Europeans',0.4);
INSERT INTO ethnic_group VALUES ('WS','Samoan',92.6);
INSERT INTO ethnic_group VALUES ('WS','Euronesians',7);
INSERT INTO ethnic_group VALUES ('RA','Indian',100);
INSERT INTO ethnic_group VALUES ('BOL','European',5);
INSERT INTO ethnic_group VALUES ('BOL','Quechua',30);
INSERT INTO ethnic_group VALUES ('BOL','Aymara',25);
INSERT INTO ethnic_group VALUES ('BR','African',44);
INSERT INTO ethnic_group VALUES ('RCH','Indian',3);
INSERT INTO ethnic_group VALUES ('RCH','European European-Indian',95);
INSERT INTO ethnic_group VALUES ('PY','Amerindians',5);
INSERT INTO ethnic_group VALUES ('PE','Indian',45);
INSERT INTO ethnic_group VALUES ('FGU','Amerindian',12);
INSERT INTO ethnic_group VALUES ('GUY','East Indian',51);
INSERT INTO ethnic_group VALUES ('GUY','Amerindian',4);
INSERT INTO ethnic_group VALUES ('GUY','European Chinese',2);
INSERT INTO ethnic_group VALUES ('SME','Chinese',1.7);
INSERT INTO ethnic_group VALUES ('SME','Javanese',15.3);
INSERT INTO ethnic_group VALUES ('SME','Creole',31);
INSERT INTO ethnic_group VALUES ('SME','Europeans',1);
INSERT INTO ethnic_group VALUES ('SME','Amerindian',2.6);
INSERT INTO ethnic_group VALUES ('SME','Hindustani',37);
INSERT INTO ethnic_group VALUES ('SME','Bush Black',NULL);
INSERT INTO ethnic_group VALUES ('YV','Amerindian',2);
INSERT INTO ethnic_group VALUES ('EC','Spanish',10);
INSERT INTO ethnic_group VALUES ('EC','Indian',25);
INSERT INTO ethnic_group VALUES ('DZ','European',1);
INSERT INTO ethnic_group VALUES ('DZ','Arab-Berber',99);
INSERT INTO ethnic_group VALUES ('LAR','Berber Arab',97);
INSERT INTO ethnic_group VALUES ('RMM','Mande',50);
INSERT INTO ethnic_group VALUES ('RMM','Peul',17);
INSERT INTO ethnic_group VALUES ('RMM','Voltaic',12);
INSERT INTO ethnic_group VALUES ('RMM','Songhai',6);
INSERT INTO ethnic_group VALUES ('RMM','Tuareg Moor',10);
INSERT INTO ethnic_group VALUES ('RIM','Maur',30);
INSERT INTO ethnic_group VALUES ('RIM','Maur/black',40);
INSERT INTO ethnic_group VALUES ('MA','Jewish',0.2);
INSERT INTO ethnic_group VALUES ('MA','Arab-Berber',99.1);
INSERT INTO ethnic_group VALUES ('RN','French',NULL);
INSERT INTO ethnic_group VALUES ('RN','Arab',NULL);
INSERT INTO ethnic_group VALUES ('RN','Toubou',NULL);
INSERT INTO ethnic_group VALUES ('RN','Fula',8.5);
INSERT INTO ethnic_group VALUES ('RN','Hausa',56);
INSERT INTO ethnic_group VALUES ('RN','Djerma',22);
INSERT INTO ethnic_group VALUES ('RN','Tuareg',8);
INSERT INTO ethnic_group VALUES ('RN','Beri Beri',4.3);
INSERT INTO ethnic_group VALUES ('RN','Gourmantche',1.2);
INSERT INTO ethnic_group VALUES ('TN','Jewish',1);
INSERT INTO ethnic_group VALUES ('TN','European',1);
INSERT INTO ethnic_group VALUES ('TN','Arab-Berber',98);
INSERT INTO ethnic_group VALUES ('ANG','European',1);
INSERT INTO ethnic_group VALUES ('ANG','Ovimbundu',37);
INSERT INTO ethnic_group VALUES ('ANG','Kimbundu',25);
INSERT INTO ethnic_group VALUES ('ANG','Bakongo',13);
INSERT INTO ethnic_group VALUES ('ZRE','Mangbetu-Azande',45);
INSERT INTO ethnic_group VALUES ('Z','European',1.1);
INSERT INTO ethnic_group VALUES ('Z','African',98.7);
INSERT INTO ethnic_group VALUES ('BEN','African',99);
INSERT INTO ethnic_group VALUES ('BF','Mossi',24);
INSERT INTO ethnic_group VALUES ('WAN','non-Africans 27000',100);
INSERT INTO ethnic_group VALUES ('RT','African',99);
INSERT INTO ethnic_group VALUES ('RT','European Syrian-Lebanese',1);
INSERT INTO ethnic_group VALUES ('RB','Kalanga',NULL);
INSERT INTO ethnic_group VALUES ('RB','Basarwa',NULL);
INSERT INTO ethnic_group VALUES ('RB','Batswana',95);
INSERT INTO ethnic_group VALUES ('RB','Kgalagadi',4);
INSERT INTO ethnic_group VALUES ('RSA','Indian',2.6);
INSERT INTO ethnic_group VALUES ('RSA','Colored',8.6);
INSERT INTO ethnic_group VALUES ('ZW','Asian',1);
INSERT INTO ethnic_group VALUES ('ZW','African',98);
INSERT INTO ethnic_group VALUES ('CI','Agni',NULL);
INSERT INTO ethnic_group VALUES ('CI','Malinke',11);
INSERT INTO ethnic_group VALUES ('CI','Baoule',23);
INSERT INTO ethnic_group VALUES ('CI','Bete',18);
INSERT INTO ethnic_group VALUES ('CI','Senoufou',15);
INSERT INTO ethnic_group VALUES ('CI','Africans',NULL);
INSERT INTO ethnic_group VALUES ('CI','non-Africans 330000',NULL);
INSERT INTO ethnic_group VALUES ('GH','European',0.2);
INSERT INTO ethnic_group VALUES ('GH','African',99.8);
INSERT INTO ethnic_group VALUES ('RWA','Hutu',80);
INSERT INTO ethnic_group VALUES ('RWA','Tutsi',19);
INSERT INTO ethnic_group VALUES ('RWA','Twa',1);
INSERT INTO ethnic_group VALUES ('CAM','African',13);
INSERT INTO ethnic_group VALUES ('CAM','Fulani',10);
INSERT INTO ethnic_group VALUES ('CAM','Cameroon Highlanders',31);
INSERT INTO ethnic_group VALUES ('CAM','Equatorial Bantu',19);
INSERT INTO ethnic_group VALUES ('CAM','Kirdi',11);
INSERT INTO ethnic_group VALUES ('CAM','Northwestern Bantu',8);
INSERT INTO ethnic_group VALUES ('CAM','Eastern Nigritic',7);
INSERT INTO ethnic_group VALUES ('CAM','non-African',1);
INSERT INTO ethnic_group VALUES ('RCA','Europeans 6500',NULL);
INSERT INTO ethnic_group VALUES ('RCA','Baya',34);
INSERT INTO ethnic_group VALUES ('RCA','Banda',27);
INSERT INTO ethnic_group VALUES ('RCA','Sara',10);
INSERT INTO ethnic_group VALUES ('RCA','Mandjia',21);
INSERT INTO ethnic_group VALUES ('RCA','Mboum',4);
INSERT INTO ethnic_group VALUES ('RCA','MBaka',4);
INSERT INTO ethnic_group VALUES ('CV','European',1);
INSERT INTO ethnic_group VALUES ('CV','African',28);
INSERT INTO ethnic_group VALUES ('CV','Creole',71);
INSERT INTO ethnic_group VALUES ('SUD','Arab',39);
INSERT INTO ethnic_group VALUES ('SUD','Beja',6);
INSERT INTO ethnic_group VALUES ('RG','Malinke',30);
INSERT INTO ethnic_group VALUES ('RG','Peuhl',40);
INSERT INTO ethnic_group VALUES ('RG','Soussou',20);
INSERT INTO ethnic_group VALUES ('LB','African',95);
INSERT INTO ethnic_group VALUES ('LB','Americo-Liberians',5);
INSERT INTO ethnic_group VALUES ('DJI','French',NULL);
INSERT INTO ethnic_group VALUES ('DJI','Italian',5);
INSERT INTO ethnic_group VALUES ('DJI','Arab',NULL);
INSERT INTO ethnic_group VALUES ('DJI','Ethiopian',NULL);
INSERT INTO ethnic_group VALUES ('DJI','Afar',35);
INSERT INTO ethnic_group VALUES ('DJI','Somali',60);
INSERT INTO ethnic_group VALUES ('ER','Afar',4);
INSERT INTO ethnic_group VALUES ('ER','Tigrinya',50);
INSERT INTO ethnic_group VALUES ('ER','Tigre Kunama',40);
INSERT INTO ethnic_group VALUES ('ER','Saho',3);
INSERT INTO ethnic_group VALUES ('ETH','Afar',4);
INSERT INTO ethnic_group VALUES ('ETH','Somali',6);
INSERT INTO ethnic_group VALUES ('ETH','Oromo',40);
INSERT INTO ethnic_group VALUES ('ETH','Sidamo',9);
INSERT INTO ethnic_group VALUES ('ETH','Shankella',6);
INSERT INTO ethnic_group VALUES ('ETH','Gurage',2);
INSERT INTO ethnic_group VALUES ('ETH','Amhara Tigrean',32);
INSERT INTO ethnic_group VALUES ('SP','Somali',85);
INSERT INTO ethnic_group VALUES ('EAK','Arab',1);
INSERT INTO ethnic_group VALUES ('EAK','Asian',NULL);
INSERT INTO ethnic_group VALUES ('EAK','European',NULL);
INSERT INTO ethnic_group VALUES ('EAK','Kikuyu',22);
INSERT INTO ethnic_group VALUES ('EAK','Luhya',14);
INSERT INTO ethnic_group VALUES ('EAK','Luo',13);
INSERT INTO ethnic_group VALUES ('EAK','Kalenjin',12);
INSERT INTO ethnic_group VALUES ('EAK','Kamba',11);
INSERT INTO ethnic_group VALUES ('EAK','Kisii',6);
INSERT INTO ethnic_group VALUES ('EAK','Meru',6);
INSERT INTO ethnic_group VALUES ('WAG','African',99);
INSERT INTO ethnic_group VALUES ('WAG','non-Gambian',1);
INSERT INTO ethnic_group VALUES ('SN','Fulani',17);
INSERT INTO ethnic_group VALUES ('SN','Wolof',36);
INSERT INTO ethnic_group VALUES ('SN','Diola',9);
INSERT INTO ethnic_group VALUES ('SN','Mandingo',9);
INSERT INTO ethnic_group VALUES ('SN','Serer',17);
INSERT INTO ethnic_group VALUES ('SN','Toucouleur',9);
INSERT INTO ethnic_group VALUES ('SN','European Lebanese',1);
INSERT INTO ethnic_group VALUES ('GNB','European',1);
INSERT INTO ethnic_group VALUES ('GNB','African',99);
INSERT INTO ethnic_group VALUES ('WAL','Asian',1);
INSERT INTO ethnic_group VALUES ('WAL','European',NULL);
INSERT INTO ethnic_group VALUES ('WAL','African',99);
INSERT INTO ethnic_group VALUES ('WAL','Creole',NULL);
INSERT INTO ethnic_group VALUES ('WAL','Lebanese',NULL);
INSERT INTO ethnic_group VALUES ('EAU','Rwanda',6);
INSERT INTO ethnic_group VALUES ('EAU','Arab',1);
INSERT INTO ethnic_group VALUES ('EAU','Asian',NULL);
INSERT INTO ethnic_group VALUES ('EAU','European',NULL);
INSERT INTO ethnic_group VALUES ('EAU','Baganda',17);
INSERT INTO ethnic_group VALUES ('EAU','Karamojong',12);
INSERT INTO ethnic_group VALUES ('EAU','Basogo',8);
INSERT INTO ethnic_group VALUES ('EAU','Iteso',8);
INSERT INTO ethnic_group VALUES ('EAU','Langi',6);
INSERT INTO ethnic_group VALUES ('EAU','Bagisu',5);
INSERT INTO ethnic_group VALUES ('EAU','Acholi',4);
INSERT INTO ethnic_group VALUES ('EAU','Lugbara',4);
INSERT INTO ethnic_group VALUES ('EAU','Bunyoro',3);
INSERT INTO ethnic_group VALUES ('EAU','Batobo',3);
INSERT INTO ethnic_group VALUES ('LS','Sotho',99.7);
INSERT INTO ethnic_group VALUES ('MOC','Europeans',0.06);
INSERT INTO ethnic_group VALUES ('MOC','Indians',0.08);
INSERT INTO ethnic_group VALUES ('MOC','Euro-Africans',0.2);
INSERT INTO ethnic_group VALUES ('MS','Creole',27);
INSERT INTO ethnic_group VALUES ('MS','Indo-Mauritian',68);
INSERT INTO ethnic_group VALUES ('MS','Sino-Mauritian',3);
INSERT INTO ethnic_group VALUES ('MS','Franco-Mauritian',2);
INSERT INTO ethnic_group VALUES ('SD','European',3);
INSERT INTO ethnic_group VALUES ('SD','African',97);
INSERT INTO ethnic_group VALUES ('STP','Europeans',100);
INSERT INTO ethnic_group VALUES ('SY','Seychellois',100);

COMMIT;



INSERT INTO religion VALUES ('AL','Muslim',70);
INSERT INTO religion VALUES ('AL','Roman Catholic',10);
INSERT INTO religion VALUES ('AL','Albanian Orthodox',20);
INSERT INTO religion VALUES ('GR','Muslim',1.3);
INSERT INTO religion VALUES ('GR','Greek Orthodox',98);
INSERT INTO religion VALUES ('MK','Muslim',30);
INSERT INTO religion VALUES ('MK','Eastern Orthodox',67);
INSERT INTO religion VALUES ('YU','Muslim',19);
INSERT INTO religion VALUES ('YU','Roman Catholic',4);
INSERT INTO religion VALUES ('YU','Protestant',1);
INSERT INTO religion VALUES ('YU','Orthodox',65);
INSERT INTO religion VALUES ('AND','Roman Catholic',100);
INSERT INTO religion VALUES ('F','Muslim',1);
INSERT INTO religion VALUES ('F','Jewish',1);
INSERT INTO religion VALUES ('F','Roman Catholic',90);
INSERT INTO religion VALUES ('F','Protestant',2);
INSERT INTO religion VALUES ('E','Roman Catholic',99);
INSERT INTO religion VALUES ('A','Roman Catholic',85);
INSERT INTO religion VALUES ('A','Protestant',6);
INSERT INTO religion VALUES ('CZ','Roman Catholic',39.2);
INSERT INTO religion VALUES ('CZ','Protestant',4.6);
INSERT INTO religion VALUES ('CZ','Orthodox',3);
INSERT INTO religion VALUES ('D','Roman Catholic',37);
INSERT INTO religion VALUES ('D','Protestant',45);
INSERT INTO religion VALUES ('H','Roman Catholic',67.5);
INSERT INTO religion VALUES ('H','Lutheran',5);
INSERT INTO religion VALUES ('H','Calvinist',20);
INSERT INTO religion VALUES ('I','Roman Catholic',98);
INSERT INTO religion VALUES ('FL','Roman Catholic',87.3);
INSERT INTO religion VALUES ('FL','Protestant',8.3);
INSERT INTO religion VALUES ('SK','Roman Catholic',60.3);
INSERT INTO religion VALUES ('SK','Protestant',8.4);
INSERT INTO religion VALUES ('SK','Orthodox',4.1);
INSERT INTO religion VALUES ('SLO','Muslim',1);
INSERT INTO religion VALUES ('SLO','Roman Catholic',96);
INSERT INTO religion VALUES ('CH','Roman Catholic',47.6);
INSERT INTO religion VALUES ('CH','Protestant',44.3);
INSERT INTO religion VALUES ('BY','Eastern Orthodox',60);
INSERT INTO religion VALUES ('PL','Roman Catholic',95);
INSERT INTO religion VALUES ('B','Roman Catholic',75);
INSERT INTO religion VALUES ('B','Protestant',25);
INSERT INTO religion VALUES ('L','Roman Catholic',97);
INSERT INTO religion VALUES ('L','Protestant Jewish',3);
INSERT INTO religion VALUES ('NL','Muslim',3);
INSERT INTO religion VALUES ('NL','Roman Catholic',34);
INSERT INTO religion VALUES ('NL','Protestant',25);
INSERT INTO religion VALUES ('BIH','Muslim',40);
INSERT INTO religion VALUES ('BIH','Protestant',4);
INSERT INTO religion VALUES ('BIH','Orthodox',31);
INSERT INTO religion VALUES ('BIH','Catholic',15);
INSERT INTO religion VALUES ('HR','Protestant',0.4);
INSERT INTO religion VALUES ('HR','Orthodox',11.1);
INSERT INTO religion VALUES ('HR','Catholic',76.5);
INSERT INTO religion VALUES ('HR','Slavic Muslim',1.2);
INSERT INTO religion VALUES ('BG','Muslim',13);
INSERT INTO religion VALUES ('BG','Jewish',0.8);
INSERT INTO religion VALUES ('BG','Roman Catholic',0.5);
INSERT INTO religion VALUES ('BG','Protestant',NULL);
INSERT INTO religion VALUES ('BG','Gregorian-Armenian',NULL);
INSERT INTO religion VALUES ('BG','Bulgarian Orthodox',85);
INSERT INTO religion VALUES ('BG','Uniate Catholic',0.2);
INSERT INTO religion VALUES ('RO','Roman Catholic',6);
INSERT INTO religion VALUES ('RO','Protestant',6);
INSERT INTO religion VALUES ('RO','Romanian Orthodox',70);
INSERT INTO religion VALUES ('TR','Muslim',99.8);
INSERT INTO religion VALUES ('DK','Evangelical Lutheran',91);
INSERT INTO religion VALUES ('DK','Protestant Roman Catholic',2);
INSERT INTO religion VALUES ('SF','Greek Orthodox',1);
INSERT INTO religion VALUES ('SF','Evangelical Lutheran',89);
INSERT INTO religion VALUES ('N','Evangelical Lutheran',87.8);
INSERT INTO religion VALUES ('N','Protestant Roman Catholic',3.8);
INSERT INTO religion VALUES ('S','Roman Catholic',1.5);
INSERT INTO religion VALUES ('S','Evangelical Lutheran',94);
INSERT INTO religion VALUES ('S','Pentecostal',1);
INSERT INTO religion VALUES ('MC','Roman Catholic',95);
INSERT INTO religion VALUES ('V','Roman Catholic',100);
INSERT INTO religion VALUES ('IS','Evangelical Lutheran',96);
INSERT INTO religion VALUES ('IS','Protestant Roman Catholic',3);
INSERT INTO religion VALUES ('IRL','Roman Catholic',93);
INSERT INTO religion VALUES ('IRL','Anglican',3);
INSERT INTO religion VALUES ('RSM','Roman Catholic',100);
INSERT INTO religion VALUES ('M','Roman Catholic',98);
INSERT INTO religion VALUES ('MD','Jewish',1.5);
INSERT INTO religion VALUES ('MD','Eastern Orthodox',98.5);
INSERT INTO religion VALUES ('MD','Baptist',NULL);
INSERT INTO religion VALUES ('P','Roman Catholic',97);
INSERT INTO religion VALUES ('P','Protestant',1);
INSERT INTO religion VALUES ('AFG','Sunni Muslim',84);
INSERT INTO religion VALUES ('AFG','Shia Muslim',15);
INSERT INTO religion VALUES ('TJ','Muslim',2);
INSERT INTO religion VALUES ('TJ','Christian',1);
INSERT INTO religion VALUES ('TJ','Buddhism',NULL);
INSERT INTO religion VALUES ('TJ','Daoism',NULL);
INSERT INTO religion VALUES ('IR','Jewish',NULL);
INSERT INTO religion VALUES ('IR','Sunni Muslim',10);
INSERT INTO religion VALUES ('IR','Shia Muslim',89);
INSERT INTO religion VALUES ('IR','Christian',NULL);
INSERT INTO religion VALUES ('IR','Zoroastrian',NULL);
INSERT INTO religion VALUES ('IR','Bahai',1);
INSERT INTO religion VALUES ('PK','Muslim',97);
INSERT INTO religion VALUES ('TAD','Sunni Muslim',80);
INSERT INTO religion VALUES ('TAD','Shia Muslim',5);
INSERT INTO religion VALUES ('TM','Muslim',87);
INSERT INTO religion VALUES ('TM','Eastern Orthodox',11);
INSERT INTO religion VALUES ('UZB','Muslim',88);
INSERT INTO religion VALUES ('UZB','Eastern Orthodox',9);
INSERT INTO religion VALUES ('ARM','Armenian Orthodox',94);
INSERT INTO religion VALUES ('GE','Muslim',11);
INSERT INTO religion VALUES ('GE','Armenian Apostolic',8);
INSERT INTO religion VALUES ('GE','Christian Orthodox',75);
INSERT INTO religion VALUES ('AZ','Muslim',93.4);
INSERT INTO religion VALUES ('AZ','Armenian Orthodox',2.3);
INSERT INTO religion VALUES ('AZ','Russian Orthodox',2.5);
INSERT INTO religion VALUES ('BRN','Sunni Muslim',25);
INSERT INTO religion VALUES ('BRN','Shia Muslim',75);
INSERT INTO religion VALUES ('BD','Muslim',83);
INSERT INTO religion VALUES ('BD','Christian',NULL);
INSERT INTO religion VALUES ('BD','Buddhist',NULL);
INSERT INTO religion VALUES ('BD','Hindu',16);
INSERT INTO religion VALUES ('MYA','Muslim',4);
INSERT INTO religion VALUES ('MYA','Christian',4);
INSERT INTO religion VALUES ('MYA','Buddhist',89);
INSERT INTO religion VALUES ('IND','Muslim',14);
INSERT INTO religion VALUES ('IND','Christian',2.4);
INSERT INTO religion VALUES ('IND','Buddhist',0.7);
INSERT INTO religion VALUES ('IND','Hindu',80);
INSERT INTO religion VALUES ('IND','Sikh',2);
INSERT INTO religion VALUES ('IND','Jains',0.5);
INSERT INTO religion VALUES ('BHT','Lamaistic Buddhism',75);
INSERT INTO religion VALUES ('BHT','Indian- Nepalese-influenced Hinduism',25);
INSERT INTO religion VALUES ('BRU','Muslim',63);
INSERT INTO religion VALUES ('BRU','Christian',8);
INSERT INTO religion VALUES ('BRU','Buddhism',14);
INSERT INTO religion VALUES ('LAO','Buddhist',60);
INSERT INTO religion VALUES ('THA','Muslim',3.8);
INSERT INTO religion VALUES ('THA','Buddhism',95);
INSERT INTO religion VALUES ('THA','Christianity',0.5);
INSERT INTO religion VALUES ('THA','Hinduism',0.1);
INSERT INTO religion VALUES ('K','Theravada Buddhism',95);
INSERT INTO religion VALUES ('KAZ','Muslim',47);
INSERT INTO religion VALUES ('KAZ','Protestant',2);
INSERT INTO religion VALUES ('KAZ','Russian Orthodox',44);
INSERT INTO religion VALUES ('MNG','Muslim',4);
INSERT INTO religion VALUES ('NEP','Muslim',3);
INSERT INTO religion VALUES ('NEP','Buddhist',5);
INSERT INTO religion VALUES ('NEP','Hindu',90);
INSERT INTO religion VALUES ('CY','Muslim',18);
INSERT INTO religion VALUES ('CY','Greek Orthodox',78);
INSERT INTO religion VALUES ('CY','Armenian Apostolic',NULL);
INSERT INTO religion VALUES ('CY','Maronite',NULL);
INSERT INTO religion VALUES ('IL','Christian',2);
INSERT INTO religion VALUES ('IL','Islam',14);
INSERT INTO religion VALUES ('IL','Druze',2);
INSERT INTO religion VALUES ('IL','Judaism',82);
INSERT INTO religion VALUES ('ET','Muslim',94);
INSERT INTO religion VALUES ('ET','Coptic Christian',6);
INSERT INTO religion VALUES ('RI','Muslim',87);
INSERT INTO religion VALUES ('RI','Roman Catholic',3);
INSERT INTO religion VALUES ('RI','Protestant',6);
INSERT INTO religion VALUES ('RI','Buddhist',1);
INSERT INTO religion VALUES ('RI','Hindu',2);
INSERT INTO religion VALUES ('PNG','Roman Catholic',22);
INSERT INTO religion VALUES ('PNG','Protestant',10);
INSERT INTO religion VALUES ('PNG','Lutheran',16);
INSERT INTO religion VALUES ('PNG','Anglican',5);
INSERT INTO religion VALUES ('PNG','Seventh-Day Adventist',1);
INSERT INTO religion VALUES ('PNG','Presbyterian/Methodist/London Missionary Society',8);
INSERT INTO religion VALUES ('PNG','Evangelical Alliance',4);
INSERT INTO religion VALUES ('IRQ','Muslim',97);
INSERT INTO religion VALUES ('IRQ','Christian',3);
INSERT INTO religion VALUES ('JOR','Sunni Muslim',92);
INSERT INTO religion VALUES ('JOR','Christian',8);
INSERT INTO religion VALUES ('KWT','Muslim',85);
INSERT INTO religion VALUES ('SA','Muslim',100);
INSERT INTO religion VALUES ('SYR','Muslim',16);
INSERT INTO religion VALUES ('SYR','Jewish',NULL);
INSERT INTO religion VALUES ('SYR','Sunni Muslim',74);
INSERT INTO religion VALUES ('SYR','Christian',10);
INSERT INTO religion VALUES ('SYR','Druze',NULL);
INSERT INTO religion VALUES ('SYR','Alawite',NULL);
INSERT INTO religion VALUES ('RL','Christian',30);
INSERT INTO religion VALUES ('RL','Islam',70);
INSERT INTO religion VALUES ('J','Shinto Buddhist',84);
INSERT INTO religion VALUES ('ROK','Buddhism',47.4);
INSERT INTO religion VALUES ('ROK','Christianity',48.6);
INSERT INTO religion VALUES ('ROK','Confucianism',3);
INSERT INTO religion VALUES ('ROK','Chondogyo',0.2);
INSERT INTO religion VALUES ('MV','Sunni Muslim',100);
INSERT INTO religion VALUES ('OM','Ibadhi Muslim',75);
INSERT INTO religion VALUES ('UAE','Muslim',96);
INSERT INTO religion VALUES ('RP','Muslim',5);
INSERT INTO religion VALUES ('RP','Roman Catholic',83);
INSERT INTO religion VALUES ('RP','Protestant',9);
INSERT INTO religion VALUES ('RP','Buddhist',3);
INSERT INTO religion VALUES ('Q','Muslim',95);
INSERT INTO religion VALUES ('CL','Muslim',8);
INSERT INTO religion VALUES ('CL','Christian',8);
INSERT INTO religion VALUES ('CL','Buddhist',69);
INSERT INTO religion VALUES ('CL','Hindu',15);
INSERT INTO religion VALUES ('RC','Christian',4.5);
INSERT INTO religion VALUES ('RC','Buddhist',NULL);
INSERT INTO religion VALUES ('RC','Confucian',NULL);
INSERT INTO religion VALUES ('RC','Taoist',93);
INSERT INTO religion VALUES ('BS','Roman Catholic',19);
INSERT INTO religion VALUES ('BS','Protestant',12);
INSERT INTO religion VALUES ('BS','Anglican',20);
INSERT INTO religion VALUES ('BS','Baptist',32);
INSERT INTO religion VALUES ('BS','Methodist',6);
INSERT INTO religion VALUES ('BS','Church God',6);
INSERT INTO religion VALUES ('BDS','Roman Catholic',4);
INSERT INTO religion VALUES ('BDS','Protestant',67);
INSERT INTO religion VALUES ('BZ','Roman Catholic',62);
INSERT INTO religion VALUES ('BZ','Protestant',30);
INSERT INTO religion VALUES ('MEX','Roman Catholic',89);
INSERT INTO religion VALUES ('MEX','Protestant',6);
INSERT INTO religion VALUES ('CDN','Roman Catholic',45);
INSERT INTO religion VALUES ('CDN','Anglican',8);
INSERT INTO religion VALUES ('CDN','United Church',12);
INSERT INTO religion VALUES ('USA','Jewish',2);
INSERT INTO religion VALUES ('USA','Roman Catholic',28);
INSERT INTO religion VALUES ('USA','Protestant',56);
INSERT INTO religion VALUES ('CR','Roman Catholic',95);
INSERT INTO religion VALUES ('NIC','Roman Catholic',95);
INSERT INTO religion VALUES ('NIC','Protestant',5);
INSERT INTO religion VALUES ('PA','Roman Catholic',85);
INSERT INTO religion VALUES ('PA','Protestant',15);
INSERT INTO religion VALUES ('C','Roman Catholic',85);
INSERT INTO religion VALUES ('WD','Roman Catholic',77);
INSERT INTO religion VALUES ('WD','Protestant',15);
INSERT INTO religion VALUES ('DOM','Roman Catholic',95);
INSERT INTO religion VALUES ('RH','Roman Catholic',80);
INSERT INTO religion VALUES ('RH','Protestant',16);
INSERT INTO religion VALUES ('ES','Roman Catholic',75);
INSERT INTO religion VALUES ('HCA','Roman Catholic',97);
INSERT INTO religion VALUES ('JA','Roman Catholic',5);
INSERT INTO religion VALUES ('JA','Protestant',55.9);
INSERT INTO religion VALUES ('CO','Roman Catholic',95);
INSERT INTO religion VALUES ('WL','Roman Catholic',90);
INSERT INTO religion VALUES ('WL','Protestant',7);
INSERT INTO religion VALUES ('WL','Anglican',3);
INSERT INTO religion VALUES ('TT','Muslim',6);
INSERT INTO religion VALUES ('TT','Roman Catholic',32.2);
INSERT INTO religion VALUES ('TT','Protestant',14);
INSERT INTO religion VALUES ('TT','Anglican',14.4);
INSERT INTO religion VALUES ('TT','Hindu',24.3);
INSERT INTO religion VALUES ('AUS','Roman Catholic',26);
INSERT INTO religion VALUES ('AUS','Anglican',26.1);
INSERT INTO religion VALUES ('AUS','Christian',24.3);
INSERT INTO religion VALUES ('FJI','Muslim',8);
INSERT INTO religion VALUES ('FJI','Christian',52);
INSERT INTO religion VALUES ('FJI','Hindu',38);
INSERT INTO religion VALUES ('KIR','Roman Catholic',52.6);
INSERT INTO religion VALUES ('KIR','Protestant',40.9);
INSERT INTO religion VALUES ('KIR','Bahai',NULL);
INSERT INTO religion VALUES ('KIR','Seventh-Day Adventist',NULL);
INSERT INTO religion VALUES ('KIR','Church God',NULL);
INSERT INTO religion VALUES ('KIR','Mormon',6);
INSERT INTO religion VALUES ('MH','Christian',100);
INSERT INTO religion VALUES ('FSM','Roman Catholic',50);
INSERT INTO religion VALUES ('FSM','Protestant',47);
INSERT INTO religion VALUES ('NAU','Christian',100);
INSERT INTO religion VALUES ('NCA','Roman Catholic',60);
INSERT INTO religion VALUES ('NCA','Protestant',30);
INSERT INTO religion VALUES ('NZ','Roman Catholic',15);
INSERT INTO religion VALUES ('NZ','Protestant',3);
INSERT INTO religion VALUES ('NZ','Anglican',24);
INSERT INTO religion VALUES ('NZ','Baptist',2);
INSERT INTO religion VALUES ('NZ','Methodist',5);
INSERT INTO religion VALUES ('NZ','Presbyterian',18);
INSERT INTO religion VALUES ('SLB','Roman Catholic',19);
INSERT INTO religion VALUES ('SLB','Protestant',5);
INSERT INTO religion VALUES ('SLB','Anglican',34);
INSERT INTO religion VALUES ('SLB','Baptist',17);
INSERT INTO religion VALUES ('SLB','Seventh-Day Adventist',10);
INSERT INTO religion VALUES ('SLB','United',11);
INSERT INTO religion VALUES ('TO','Christian',100);
INSERT INTO religion VALUES ('TUV','Bahai',1);
INSERT INTO religion VALUES ('TUV','Seventh-Day Adventist',1.4);
INSERT INTO religion VALUES ('TUV','Church Tuvalu',97);
INSERT INTO religion VALUES ('VU','Catholic',15);
INSERT INTO religion VALUES ('VU','Anglican',15);
INSERT INTO religion VALUES ('VU','Seventh-Day Adventist',6.2);
INSERT INTO religion VALUES ('VU','Presbyterian',36.7);
INSERT INTO religion VALUES ('VU','Church Christ',3.8);
INSERT INTO religion VALUES ('WS','Christian',99.7);
INSERT INTO religion VALUES ('RA','Jewish',2);
INSERT INTO religion VALUES ('RA','Roman Catholic',90);
INSERT INTO religion VALUES ('RA','Protestant',2);
INSERT INTO religion VALUES ('BOL','Roman Catholic',95);
INSERT INTO religion VALUES ('BR','Roman Catholic',70);
INSERT INTO religion VALUES ('RCH','Jewish',NULL);
INSERT INTO religion VALUES ('RCH','Roman Catholic',89);
INSERT INTO religion VALUES ('RCH','Protestant',11);
INSERT INTO religion VALUES ('PY','Roman Catholic',90);
INSERT INTO religion VALUES ('ROU','Jewish',2);
INSERT INTO religion VALUES ('ROU','Roman Catholic',66);
INSERT INTO religion VALUES ('ROU','Protestant',2);
INSERT INTO religion VALUES ('PE','Roman Catholic',100);
INSERT INTO religion VALUES ('FGU','Roman Catholic',100);
INSERT INTO religion VALUES ('GUY','Muslim',9);
INSERT INTO religion VALUES ('GUY','Christian',57);
INSERT INTO religion VALUES ('GUY','Hindu',33);
INSERT INTO religion VALUES ('SME','Muslim',19.6);
INSERT INTO religion VALUES ('SME','Roman Catholic',22.8);
INSERT INTO religion VALUES ('SME','Protestant',25.2);
INSERT INTO religion VALUES ('SME','Hindu',27.4);
INSERT INTO religion VALUES ('YV','Roman Catholic',96);
INSERT INTO religion VALUES ('YV','Protestant',2);
INSERT INTO religion VALUES ('EC','Roman Catholic',95);
INSERT INTO religion VALUES ('DZ','Sunni Muslim',99);
INSERT INTO religion VALUES ('DZ','Christian Jewish',1);
INSERT INTO religion VALUES ('LAR','Sunni Muslim',97);
INSERT INTO religion VALUES ('RMM','Muslim',90);
INSERT INTO religion VALUES ('RMM','Christian',1);
INSERT INTO religion VALUES ('RIM','Muslim',100);
INSERT INTO religion VALUES ('MA','Muslim',98.7);
INSERT INTO religion VALUES ('MA','Jewish',0.2);
INSERT INTO religion VALUES ('MA','Christian',1.1);
INSERT INTO religion VALUES ('RN','Muslim',80);
INSERT INTO religion VALUES ('TN','Muslim',98);
INSERT INTO religion VALUES ('TN','Jewish',1);
INSERT INTO religion VALUES ('TN','Christian',1);
INSERT INTO religion VALUES ('WSA','Muslim',100);
INSERT INTO religion VALUES ('ANG','Roman Catholic',38);
INSERT INTO religion VALUES ('ANG','Protestant',15);
INSERT INTO religion VALUES ('RCB','Muslim',2);
INSERT INTO religion VALUES ('RCB','Christian',50);
INSERT INTO religion VALUES ('NAM','Lutheran',50);
INSERT INTO religion VALUES ('ZRE','Muslim',10);
INSERT INTO religion VALUES ('ZRE','Roman Catholic',50);
INSERT INTO religion VALUES ('ZRE','Protestant',20);
INSERT INTO religion VALUES ('ZRE','Kimbanguist',10);
INSERT INTO religion VALUES ('Z','Christian',50);
INSERT INTO religion VALUES ('Z','Muslim Hindu',24);
INSERT INTO religion VALUES ('BEN','Muslim',15);
INSERT INTO religion VALUES ('BEN','Christian',15);
INSERT INTO religion VALUES ('BF','Muslim',50);
INSERT INTO religion VALUES ('BF','Christian',10);
INSERT INTO religion VALUES ('WAN','Muslim',50);
INSERT INTO religion VALUES ('WAN','Christian',40);
INSERT INTO religion VALUES ('RT','Muslim',10);
INSERT INTO religion VALUES ('RT','Christian',20);
INSERT INTO religion VALUES ('RB','Christian',50);
INSERT INTO religion VALUES ('RSA','Muslim',2);
INSERT INTO religion VALUES ('ZW','Muslim',1);
INSERT INTO religion VALUES ('ZW','Christian',25);
INSERT INTO religion VALUES ('CI','Muslim',60);
INSERT INTO religion VALUES ('CI','Christian',12);
INSERT INTO religion VALUES ('GH','Muslim',30);
INSERT INTO religion VALUES ('GH','Christian',24);
INSERT INTO religion VALUES ('BI','Muslim',1);
INSERT INTO religion VALUES ('BI','Christian',67);
INSERT INTO religion VALUES ('RWA','Muslim',1);
INSERT INTO religion VALUES ('RWA','Roman Catholic',65);
INSERT INTO religion VALUES ('RWA','Protestant',9);
INSERT INTO religion VALUES ('CAM','Muslim',16);
INSERT INTO religion VALUES ('CAM','Christian',33);
INSERT INTO religion VALUES ('RCA','Muslim',15);
INSERT INTO religion VALUES ('RCA','Roman Catholic',25);
INSERT INTO religion VALUES ('RCA','Protestant',25);
INSERT INTO religion VALUES ('TCH','Muslim',50);
INSERT INTO religion VALUES ('TCH','Christian',25);
INSERT INTO religion VALUES ('GQ','Christian Roman Catholic',100);
INSERT INTO religion VALUES ('G','Muslim',1);
INSERT INTO religion VALUES ('G','Christian',55);
INSERT INTO religion VALUES ('CV','Roman Catholicism',100);
INSERT INTO religion VALUES ('SUD','Sunni Muslim',70);
INSERT INTO religion VALUES ('SUD','Christian',5);
INSERT INTO religion VALUES ('COM','Roman Catholic',14);
INSERT INTO religion VALUES ('COM','Sunni Muslim',86);
INSERT INTO religion VALUES ('RG','Muslim',85);
INSERT INTO religion VALUES ('RG','Christian',8);
INSERT INTO religion VALUES ('LB','Muslim',20);
INSERT INTO religion VALUES ('LB','Christian',10);
INSERT INTO religion VALUES ('DJI','Muslim',94);
INSERT INTO religion VALUES ('DJI','Christian',6);
INSERT INTO religion VALUES ('ETH','Muslim',45);
INSERT INTO religion VALUES ('ETH','Ethiopian Orthodox',35);
INSERT INTO religion VALUES ('SP','Sunni Muslim',100);
INSERT INTO religion VALUES ('EAK','Roman Catholic',28);
INSERT INTO religion VALUES ('EAK','Protestant',38);
INSERT INTO religion VALUES ('WAG','Muslim',90);
INSERT INTO religion VALUES ('WAG','Christian',9);
INSERT INTO religion VALUES ('SN','Muslim',92);
INSERT INTO religion VALUES ('SN','Christian',2);
INSERT INTO religion VALUES ('GNB','Muslim',30);
INSERT INTO religion VALUES ('GNB','Christian',5);
INSERT INTO religion VALUES ('WAL','Muslim',60);
INSERT INTO religion VALUES ('WAL','Christian',10);
INSERT INTO religion VALUES ('EAU','Muslim',16);
INSERT INTO religion VALUES ('EAU','Roman Catholic',33);
INSERT INTO religion VALUES ('EAU','Protestant',33);
INSERT INTO religion VALUES ('LS','Christian',80);
INSERT INTO religion VALUES ('RM','Muslim',7);
INSERT INTO religion VALUES ('RM','Christian',41);
INSERT INTO religion VALUES ('MW','Muslim',20);
INSERT INTO religion VALUES ('MW','Roman Catholic',20);
INSERT INTO religion VALUES ('MW','Protestant',55);
INSERT INTO religion VALUES ('MOC','Muslim',20);
INSERT INTO religion VALUES ('MOC','Christian',30);
INSERT INTO religion VALUES ('MS','Muslim',16.6);
INSERT INTO religion VALUES ('MS','Christian',28.3);
INSERT INTO religion VALUES ('MS','Hindu',52);
INSERT INTO religion VALUES ('SD','Christian',60);
INSERT INTO religion VALUES ('SY','Roman Catholic',90);
INSERT INTO religion VALUES ('SY','Anglican',8);

COMMIT;



INSERT INTO borders VALUES ('AL','GR',282);
INSERT INTO borders VALUES ('AL','YU',287);
INSERT INTO borders VALUES ('GR','TR',206);
INSERT INTO borders VALUES ('MK','AL',151);
INSERT INTO borders VALUES ('MK','GR',228);
INSERT INTO borders VALUES ('MK','YU',221);
INSERT INTO borders VALUES ('MK','BG',148);
INSERT INTO borders VALUES ('YU','BG',318);
INSERT INTO borders VALUES ('YU','RO',476);
INSERT INTO borders VALUES ('AND','F',60);
INSERT INTO borders VALUES ('AND','E',65);
INSERT INTO borders VALUES ('E','F',623);
INSERT INTO borders VALUES ('A','D',784);
INSERT INTO borders VALUES ('A','H',366);
INSERT INTO borders VALUES ('A','I',430);
INSERT INTO borders VALUES ('CZ','A',362);
INSERT INTO borders VALUES ('CZ','D',646);
INSERT INTO borders VALUES ('CZ','PL',658);
INSERT INTO borders VALUES ('D','F',451);
INSERT INTO borders VALUES ('H','YU',151);
INSERT INTO borders VALUES ('H','UA',103);
INSERT INTO borders VALUES ('H','RO',443);
INSERT INTO borders VALUES ('I','F',488);
INSERT INTO borders VALUES ('FL','A',37);
INSERT INTO borders VALUES ('FL','CH',41);
INSERT INTO borders VALUES ('SK','A',91);
INSERT INTO borders VALUES ('SK','CZ',215);
INSERT INTO borders VALUES ('SK','H',515);
INSERT INTO borders VALUES ('SK','PL',444);
INSERT INTO borders VALUES ('SK','UA',90);
INSERT INTO borders VALUES ('SLO','A',324);
INSERT INTO borders VALUES ('SLO','H',102);
INSERT INTO borders VALUES ('SLO','I',235);
INSERT INTO borders VALUES ('SLO','HR',546);
INSERT INTO borders VALUES ('CH','F',573);
INSERT INTO borders VALUES ('CH','A',164);
INSERT INTO borders VALUES ('CH','D',334);
INSERT INTO borders VALUES ('CH','I',740);
INSERT INTO borders VALUES ('BY','PL',605);
INSERT INTO borders VALUES ('BY','UA',891);
INSERT INTO borders VALUES ('BY','R',959);
INSERT INTO borders VALUES ('LV','BY',141);
INSERT INTO borders VALUES ('LV','LT',453);
INSERT INTO borders VALUES ('LV','R',217);
INSERT INTO borders VALUES ('LT','BY',502);
INSERT INTO borders VALUES ('LT','PL',91);
INSERT INTO borders VALUES ('LT','R',227);
INSERT INTO borders VALUES ('PL','D',456);
INSERT INTO borders VALUES ('PL','UA',428);
INSERT INTO borders VALUES ('PL','R',206);
INSERT INTO borders VALUES ('UA','R',1576);
INSERT INTO borders VALUES ('B','F',620);
INSERT INTO borders VALUES ('B','D',167);
INSERT INTO borders VALUES ('B','NL',450);
INSERT INTO borders VALUES ('L','F',73);
INSERT INTO borders VALUES ('L','D',138);
INSERT INTO borders VALUES ('L','B',148);
INSERT INTO borders VALUES ('NL','D',577);
INSERT INTO borders VALUES ('BIH','YU',527);
INSERT INTO borders VALUES ('BIH','HR',932);
INSERT INTO borders VALUES ('HR','YU',266);
INSERT INTO borders VALUES ('HR','H',329);
INSERT INTO borders VALUES ('BG','GR',494);
INSERT INTO borders VALUES ('BG','RO',608);
INSERT INTO borders VALUES ('BG','TR',240);
INSERT INTO borders VALUES ('RO','UA',531);
INSERT INTO borders VALUES ('TR','IR',499);
INSERT INTO borders VALUES ('DK','D',68);
INSERT INTO borders VALUES ('EW','LV',267);
INSERT INTO borders VALUES ('EW','R',290);
INSERT INTO borders VALUES ('SF','R',1313);
INSERT INTO borders VALUES ('SF','S',586);
INSERT INTO borders VALUES ('N','R',167);
INSERT INTO borders VALUES ('N','SF',729);
INSERT INTO borders VALUES ('N','S',1619);
INSERT INTO borders VALUES ('MC','F',4.4);
INSERT INTO borders VALUES ('V','I',3.2);
INSERT INTO borders VALUES ('IRL','GB',360);
INSERT INTO borders VALUES ('RSM','I',39);
INSERT INTO borders VALUES ('MD','UA',939);
INSERT INTO borders VALUES ('MD','RO',450);
INSERT INTO borders VALUES ('P','E',1214);
INSERT INTO borders VALUES ('AFG','TJ',76);
INSERT INTO borders VALUES ('AFG','IR',936);
INSERT INTO borders VALUES ('AFG','PK',2430);
INSERT INTO borders VALUES ('TJ','R',3645);
INSERT INTO borders VALUES ('PK','TJ',523);
INSERT INTO borders VALUES ('PK','IR',909);
INSERT INTO borders VALUES ('PK','IND',2912);
INSERT INTO borders VALUES ('TAD','AFG',1206);
INSERT INTO borders VALUES ('TAD','TJ',414);
INSERT INTO borders VALUES ('TAD','UZB',1161);
INSERT INTO borders VALUES ('TAD','KGZ',870);
INSERT INTO borders VALUES ('TM','AFG',744);
INSERT INTO borders VALUES ('TM','IR',992);
INSERT INTO borders VALUES ('TM','KAZ',379);
INSERT INTO borders VALUES ('UZB','AFG',137);
INSERT INTO borders VALUES ('UZB','TM',1621);
INSERT INTO borders VALUES ('UZB','KAZ',2203);
INSERT INTO borders VALUES ('ARM','TR',268);
INSERT INTO borders VALUES ('ARM','IR',35);
INSERT INTO borders VALUES ('ARM','GE',164);
INSERT INTO borders VALUES ('ARM','AZ',787);
INSERT INTO borders VALUES ('GE','R',723);
INSERT INTO borders VALUES ('GE','TR',252);
INSERT INTO borders VALUES ('GE','AZ',322);
INSERT INTO borders VALUES ('AZ','R',284);
INSERT INTO borders VALUES ('AZ','TR',9);
INSERT INTO borders VALUES ('AZ','IR',611);
INSERT INTO borders VALUES ('BD','MYA',193);
INSERT INTO borders VALUES ('BD','IND',4053);
INSERT INTO borders VALUES ('MYA','TJ',2185);
INSERT INTO borders VALUES ('MYA','IND',1463);
INSERT INTO borders VALUES ('IND','TJ',3380);
INSERT INTO borders VALUES ('BHT','TJ',470);
INSERT INTO borders VALUES ('BHT','IND',605);
INSERT INTO borders VALUES ('BRU','MAL',381);
INSERT INTO borders VALUES ('MAL','THA',506);
INSERT INTO borders VALUES ('MAL','RI',1782);
INSERT INTO borders VALUES ('LAO','TJ',423);
INSERT INTO borders VALUES ('LAO','MYA',235);
INSERT INTO borders VALUES ('LAO','THA',1754);
INSERT INTO borders VALUES ('LAO','VN',2130);
INSERT INTO borders VALUES ('THA','MYA',1800);
INSERT INTO borders VALUES ('K','LAO',541);
INSERT INTO borders VALUES ('K','THA',803);
INSERT INTO borders VALUES ('K','VN',1228);
INSERT INTO borders VALUES ('VN','TJ',1281);
INSERT INTO borders VALUES ('KAZ','R',6846);
INSERT INTO borders VALUES ('KAZ','TJ',1533);
INSERT INTO borders VALUES ('NOK','R',19);
INSERT INTO borders VALUES ('NOK','TJ',1416);
INSERT INTO borders VALUES ('KGZ','TJ',858);
INSERT INTO borders VALUES ('KGZ','UZB',1099);
INSERT INTO borders VALUES ('KGZ','KAZ',1051);
INSERT INTO borders VALUES ('MNG','R',3441);
INSERT INTO borders VALUES ('MNG','TJ',4673);
INSERT INTO borders VALUES ('NEP','TJ',1236);
INSERT INTO borders VALUES ('NEP','IND',1690);
INSERT INTO borders VALUES ('IL','ET',255);
INSERT INTO borders VALUES ('IL','JOR',238);
INSERT INTO borders VALUES ('IL','SYR',76);
INSERT INTO borders VALUES ('ET','LAR',1150);
INSERT INTO borders VALUES ('ET','SUD',1273);
INSERT INTO borders VALUES ('PNG','RI',820);
INSERT INTO borders VALUES ('IRQ','TR',331);
INSERT INTO borders VALUES ('IRQ','IR',1458);
INSERT INTO borders VALUES ('IRQ','SA',814);
INSERT INTO borders VALUES ('JOR','IRQ',181);
INSERT INTO borders VALUES ('JOR','SA',728);
INSERT INTO borders VALUES ('JOR','SYR',375);
INSERT INTO borders VALUES ('KWT','IRQ',242);
INSERT INTO borders VALUES ('KWT','SA',222);
INSERT INTO borders VALUES ('SYR','TR',822);
INSERT INTO borders VALUES ('SYR','IRQ',605);
INSERT INTO borders VALUES ('RL','IL',79);
INSERT INTO borders VALUES ('RL','SYR',375);
INSERT INTO borders VALUES ('ROK','NOK',238);
INSERT INTO borders VALUES ('OM','SA',676);
INSERT INTO borders VALUES ('OM','YE',288);
INSERT INTO borders VALUES ('UAE','SA',457);
INSERT INTO borders VALUES ('UAE','OM',410);
INSERT INTO borders VALUES ('YE','SA',1458);
INSERT INTO borders VALUES ('Q','SA',60);
INSERT INTO borders VALUES ('BZ','GCA',266);
INSERT INTO borders VALUES ('BZ','MEX',250);
INSERT INTO borders VALUES ('GCA','MEX',962);
INSERT INTO borders VALUES ('GCA','HCA',256);
INSERT INTO borders VALUES ('MEX','USA',3326);
INSERT INTO borders VALUES ('USA','CDN',8893);
INSERT INTO borders VALUES ('CR','NIC',309);
INSERT INTO borders VALUES ('CR','PA',330);
INSERT INTO borders VALUES ('PA','CO',225);
INSERT INTO borders VALUES ('C','USA',29);
INSERT INTO borders VALUES ('RH','DOM',275);
INSERT INTO borders VALUES ('ES','GCA',203);
INSERT INTO borders VALUES ('ES','HCA',342);
INSERT INTO borders VALUES ('HCA','NIC',922);
INSERT INTO borders VALUES ('CO','BR',1643);
INSERT INTO borders VALUES ('CO','PE',2900);
INSERT INTO borders VALUES ('RA','BR',1224);
INSERT INTO borders VALUES ('BOL','RA',832);
INSERT INTO borders VALUES ('BOL','BR',3400);
INSERT INTO borders VALUES ('BOL','PE',900);
INSERT INTO borders VALUES ('RCH','RA',5150);
INSERT INTO borders VALUES ('RCH','BOL',861);
INSERT INTO borders VALUES ('RCH','PE',160);
INSERT INTO borders VALUES ('PY','RA',1880);
INSERT INTO borders VALUES ('PY','BOL',750);
INSERT INTO borders VALUES ('PY','BR',1290);
INSERT INTO borders VALUES ('ROU','RA',579);
INSERT INTO borders VALUES ('ROU','BR',985);
INSERT INTO borders VALUES ('PE','BR',1560);
INSERT INTO borders VALUES ('FGU','BR',673);
INSERT INTO borders VALUES ('FGU','SME',510);
INSERT INTO borders VALUES ('GUY','BR',1119);
INSERT INTO borders VALUES ('GUY','YV',743);
INSERT INTO borders VALUES ('SME','BR',597);
INSERT INTO borders VALUES ('SME','GUY',600);
INSERT INTO borders VALUES ('YV','CO',2050);
INSERT INTO borders VALUES ('YV','BR',2200);
INSERT INTO borders VALUES ('EC','CO',590);
INSERT INTO borders VALUES ('EC','PE',1420);
INSERT INTO borders VALUES ('LAR','DZ',982);
INSERT INTO borders VALUES ('LAR','SUD',383);
INSERT INTO borders VALUES ('RMM','DZ',1376);
INSERT INTO borders VALUES ('RMM','RN',821);
INSERT INTO borders VALUES ('RIM','DZ',463);
INSERT INTO borders VALUES ('RIM','RMM',2237);
INSERT INTO borders VALUES ('MA','DZ',1559);
INSERT INTO borders VALUES ('RN','DZ',956);
INSERT INTO borders VALUES ('RN','LAR',354);
INSERT INTO borders VALUES ('RN','TCH',1175);
INSERT INTO borders VALUES ('TN','DZ',965);
INSERT INTO borders VALUES ('TN','LAR',459);
INSERT INTO borders VALUES ('WSA','DZ',42);
INSERT INTO borders VALUES ('WSA','RIM',1561);
INSERT INTO borders VALUES ('WSA','MA',443);
INSERT INTO borders VALUES ('ANG','ZRE',2511);
INSERT INTO borders VALUES ('RCB','ANG',201);
INSERT INTO borders VALUES ('RCB','ZRE',2410);
INSERT INTO borders VALUES ('RCB','CAM',523);
INSERT INTO borders VALUES ('RCB','RCA',467);
INSERT INTO borders VALUES ('NAM','ANG',1376);
INSERT INTO borders VALUES ('NAM','RSA',855);
INSERT INTO borders VALUES ('ZRE','SUD',628);
INSERT INTO borders VALUES ('ZRE','EAT',459);
INSERT INTO borders VALUES ('Z','ANG',1110);
INSERT INTO borders VALUES ('Z','NAM',233);
INSERT INTO borders VALUES ('Z','ZRE',1930);
INSERT INTO borders VALUES ('Z','EAT',338);
INSERT INTO borders VALUES ('Z','MOC',419);
INSERT INTO borders VALUES ('BEN','RN',266);
INSERT INTO borders VALUES ('BEN','BF',306);
INSERT INTO borders VALUES ('BEN','WAN',773);
INSERT INTO borders VALUES ('BF','RMM',1000);
INSERT INTO borders VALUES ('BF','RN',628);
INSERT INTO borders VALUES ('BF','CI',584);
INSERT INTO borders VALUES ('WAN','RN',1497);
INSERT INTO borders VALUES ('WAN','TCH',87);
INSERT INTO borders VALUES ('RT','BEN',644);
INSERT INTO borders VALUES ('RT','BF',126);
INSERT INTO borders VALUES ('RT','GH',877);
INSERT INTO borders VALUES ('RB','NAM',1360);
INSERT INTO borders VALUES ('RB','RSA',1840);
INSERT INTO borders VALUES ('ZW','Z',797);
INSERT INTO borders VALUES ('ZW','RB',813);
INSERT INTO borders VALUES ('ZW','RSA',225);
INSERT INTO borders VALUES ('ZW','MOC',1231);
INSERT INTO borders VALUES ('CI','RMM',532);
INSERT INTO borders VALUES ('GH','BF',548);
INSERT INTO borders VALUES ('GH','CI',668);
INSERT INTO borders VALUES ('BI','ZRE',233);
INSERT INTO borders VALUES ('BI','EAT',451);
INSERT INTO borders VALUES ('RWA','ZRE',217);
INSERT INTO borders VALUES ('RWA','BI',290);
INSERT INTO borders VALUES ('RWA','EAT',217);
INSERT INTO borders VALUES ('RWA','EAU',169);
INSERT INTO borders VALUES ('CAM','WAN',1690);
INSERT INTO borders VALUES ('CAM','RCA',797);
INSERT INTO borders VALUES ('CAM','TCH',1094);
INSERT INTO borders VALUES ('RCA','ZRE',1577);
INSERT INTO borders VALUES ('RCA','TCH',1197);
INSERT INTO borders VALUES ('RCA','SUD',1165);
INSERT INTO borders VALUES ('TCH','LAR',1055);
INSERT INTO borders VALUES ('TCH','SUD',1360);
INSERT INTO borders VALUES ('GQ','CAM',189);
INSERT INTO borders VALUES ('GQ','G',350);
INSERT INTO borders VALUES ('G','RCB',1903);
INSERT INTO borders VALUES ('G','CAM',298);
INSERT INTO borders VALUES ('RG','RMM',858);
INSERT INTO borders VALUES ('RG','CI',610);
INSERT INTO borders VALUES ('LB','CI',716);
INSERT INTO borders VALUES ('LB','RG',563);
INSERT INTO borders VALUES ('DJI','ER',113);
INSERT INTO borders VALUES ('DJI','ETH',337);
INSERT INTO borders VALUES ('DJI','SP',58);
INSERT INTO borders VALUES ('ER','SUD',605);
INSERT INTO borders VALUES ('ER','ETH',912);
INSERT INTO borders VALUES ('ETH','SUD',1606);
INSERT INTO borders VALUES ('SP','ETH',1626);
INSERT INTO borders VALUES ('EAK','EAT',769);
INSERT INTO borders VALUES ('EAK','SUD',232);
INSERT INTO borders VALUES ('EAK','ETH',830);
INSERT INTO borders VALUES ('EAK','SP',682);
INSERT INTO borders VALUES ('WAG','SN',740);
INSERT INTO borders VALUES ('SN','RMM',419);
INSERT INTO borders VALUES ('SN','RIM',813);
INSERT INTO borders VALUES ('SN','RG',330);
INSERT INTO borders VALUES ('GNB','RG',386);
INSERT INTO borders VALUES ('GNB','SN',338);
INSERT INTO borders VALUES ('WAL','RG',652);
INSERT INTO borders VALUES ('WAL','LB',306);
INSERT INTO borders VALUES ('EAU','ZRE',765);
INSERT INTO borders VALUES ('EAU','EAT',396);
INSERT INTO borders VALUES ('EAU','SUD',435);
INSERT INTO borders VALUES ('EAU','EAK',933);
INSERT INTO borders VALUES ('LS','RSA',909);
INSERT INTO borders VALUES ('MW','Z',837);
INSERT INTO borders VALUES ('MW','EAT',475);
INSERT INTO borders VALUES ('MW','MOC',1569);
INSERT INTO borders VALUES ('MOC','RSA',491);
INSERT INTO borders VALUES ('MOC','EAT',756);
INSERT INTO borders VALUES ('SD','RSA',430);
INSERT INTO borders VALUES ('SD','MOC',105);

COMMIT;



INSERT INTO continent VALUES ('Europe',9562488);
INSERT INTO continent VALUES ('Asia',45095292);
INSERT INTO continent VALUES ('Australia/Oceania',8503474);
INSERT INTO continent VALUES ('Africa',30254708);
INSERT INTO continent VALUES ('America',39872000);

COMMIT;



INSERT INTO encompasses VALUES ('AL','Europe',100);
INSERT INTO encompasses VALUES ('GR','Europe',100);
INSERT INTO encompasses VALUES ('MK','Europe',100);
INSERT INTO encompasses VALUES ('YU','Europe',100);
INSERT INTO encompasses VALUES ('AND','Europe',100);
INSERT INTO encompasses VALUES ('F','Europe',100);
INSERT INTO encompasses VALUES ('E','Europe',100);
INSERT INTO encompasses VALUES ('A','Europe',100);
INSERT INTO encompasses VALUES ('CZ','Europe',100);
INSERT INTO encompasses VALUES ('D','Europe',100);
INSERT INTO encompasses VALUES ('H','Europe',100);
INSERT INTO encompasses VALUES ('I','Europe',100);
INSERT INTO encompasses VALUES ('FL','Europe',100);
INSERT INTO encompasses VALUES ('SK','Europe',100);
INSERT INTO encompasses VALUES ('SLO','Europe',100);
INSERT INTO encompasses VALUES ('CH','Europe',100);
INSERT INTO encompasses VALUES ('BY','Europe',100);
INSERT INTO encompasses VALUES ('LV','Europe',100);
INSERT INTO encompasses VALUES ('LT','Europe',100);
INSERT INTO encompasses VALUES ('PL','Europe',100);
INSERT INTO encompasses VALUES ('UA','Europe',100);
INSERT INTO encompasses VALUES ('R','Europe',20);
INSERT INTO encompasses VALUES ('R','Asia',80);
INSERT INTO encompasses VALUES ('B','Europe',100);
INSERT INTO encompasses VALUES ('L','Europe',100);
INSERT INTO encompasses VALUES ('NL','Europe',100);
INSERT INTO encompasses VALUES ('BIH','Europe',100);
INSERT INTO encompasses VALUES ('HR','Europe',100);
INSERT INTO encompasses VALUES ('BG','Europe',100);
INSERT INTO encompasses VALUES ('RO','Europe',100);
INSERT INTO encompasses VALUES ('TR','Europe',32);
INSERT INTO encompasses VALUES ('TR','Asia',68);
INSERT INTO encompasses VALUES ('DK','Europe',100);
INSERT INTO encompasses VALUES ('EW','Europe',100);
INSERT INTO encompasses VALUES ('SF','Europe',100);
INSERT INTO encompasses VALUES ('N','Europe',100);
INSERT INTO encompasses VALUES ('S','Europe',100);
INSERT INTO encompasses VALUES ('MC','Europe',100);
INSERT INTO encompasses VALUES ('V','Europe',100);
INSERT INTO encompasses VALUES ('IS','Europe',100);
INSERT INTO encompasses VALUES ('IRL','Europe',100);
INSERT INTO encompasses VALUES ('RSM','Europe',100);
INSERT INTO encompasses VALUES ('M','Europe',100);
INSERT INTO encompasses VALUES ('MD','Europe',100);
INSERT INTO encompasses VALUES ('P','Europe',100);
INSERT INTO encompasses VALUES ('GB','Europe',100);
INSERT INTO encompasses VALUES ('AFG','Asia',100);
INSERT INTO encompasses VALUES ('TJ','Asia',100);
INSERT INTO encompasses VALUES ('IR','Asia',100);
INSERT INTO encompasses VALUES ('PK','Asia',100);
INSERT INTO encompasses VALUES ('TAD','Asia',100);
INSERT INTO encompasses VALUES ('TM','Asia',100);
INSERT INTO encompasses VALUES ('UZB','Asia',100);
INSERT INTO encompasses VALUES ('ARM','Asia',100);
INSERT INTO encompasses VALUES ('GE','Asia',100);
INSERT INTO encompasses VALUES ('AZ','Asia',100);
INSERT INTO encompasses VALUES ('BRN','Asia',100);
INSERT INTO encompasses VALUES ('BD','Asia',100);
INSERT INTO encompasses VALUES ('MYA','Asia',100);
INSERT INTO encompasses VALUES ('IND','Asia',100);
INSERT INTO encompasses VALUES ('BHT','Asia',100);
INSERT INTO encompasses VALUES ('BRU','Asia',100);
INSERT INTO encompasses VALUES ('MAL','Asia',100);
INSERT INTO encompasses VALUES ('LAO','Asia',100);
INSERT INTO encompasses VALUES ('THA','Asia',100);
INSERT INTO encompasses VALUES ('K','Asia',100);
INSERT INTO encompasses VALUES ('VN','Asia',100);
INSERT INTO encompasses VALUES ('KAZ','Asia',100);
INSERT INTO encompasses VALUES ('NOK','Asia',100);
INSERT INTO encompasses VALUES ('KGZ','Asia',100);
INSERT INTO encompasses VALUES ('MNG','Asia',100);
INSERT INTO encompasses VALUES ('NEP','Asia',100);
INSERT INTO encompasses VALUES ('CY','Europe',100);
INSERT INTO encompasses VALUES ('IL','Asia',100);
INSERT INTO encompasses VALUES ('ET','Asia',10);
INSERT INTO encompasses VALUES ('ET','Africa',90);
INSERT INTO encompasses VALUES ('RI','Asia',100);
INSERT INTO encompasses VALUES ('PNG','Australia/Oceania',100);
INSERT INTO encompasses VALUES ('IRQ','Asia',100);
INSERT INTO encompasses VALUES ('JOR','Asia',100);
INSERT INTO encompasses VALUES ('KWT','Asia',100);
INSERT INTO encompasses VALUES ('SA','Asia',100);
INSERT INTO encompasses VALUES ('SYR','Asia',100);
INSERT INTO encompasses VALUES ('RL','Asia',100);
INSERT INTO encompasses VALUES ('J','Asia',100);
INSERT INTO encompasses VALUES ('ROK','Asia',100);
INSERT INTO encompasses VALUES ('MV','Asia',100);
INSERT INTO encompasses VALUES ('OM','Asia',100);
INSERT INTO encompasses VALUES ('UAE','Asia',100);
INSERT INTO encompasses VALUES ('YE','Asia',100);
INSERT INTO encompasses VALUES ('RP','Asia',100);
INSERT INTO encompasses VALUES ('Q','Asia',100);
INSERT INTO encompasses VALUES ('SGP','Asia',100);
INSERT INTO encompasses VALUES ('CL','Asia',100);
INSERT INTO encompasses VALUES ('RC','Asia',100);
INSERT INTO encompasses VALUES ('AG','America',100);
INSERT INTO encompasses VALUES ('BS','America',100);
INSERT INTO encompasses VALUES ('BDS','America',100);
INSERT INTO encompasses VALUES ('BZ','America',100);
INSERT INTO encompasses VALUES ('GCA','America',100);
INSERT INTO encompasses VALUES ('MEX','America',100);
INSERT INTO encompasses VALUES ('CDN','America',100);
INSERT INTO encompasses VALUES ('USA','America',100);
INSERT INTO encompasses VALUES ('CR','America',100);
INSERT INTO encompasses VALUES ('NIC','America',100);
INSERT INTO encompasses VALUES ('PA','America',100);
INSERT INTO encompasses VALUES ('C','America',100);
INSERT INTO encompasses VALUES ('WD','America',100);
INSERT INTO encompasses VALUES ('DOM','America',100);
INSERT INTO encompasses VALUES ('RH','America',100);
INSERT INTO encompasses VALUES ('ES','America',100);
INSERT INTO encompasses VALUES ('HCA','America',100);
INSERT INTO encompasses VALUES ('WG','America',100);
INSERT INTO encompasses VALUES ('JA','America',100);
INSERT INTO encompasses VALUES ('CO','America',100);
INSERT INTO encompasses VALUES ('KN','America',100);
INSERT INTO encompasses VALUES ('WL','America',100);
INSERT INTO encompasses VALUES ('WV','America',100);
INSERT INTO encompasses VALUES ('TT','America',100);
INSERT INTO encompasses VALUES ('AUS','Australia/Oceania',100);
INSERT INTO encompasses VALUES ('FJI','Australia/Oceania',100);
INSERT INTO encompasses VALUES ('KIR','Australia/Oceania',100);
INSERT INTO encompasses VALUES ('MH','Australia/Oceania',100);
INSERT INTO encompasses VALUES ('FSM','Australia/Oceania',100);
INSERT INTO encompasses VALUES ('NAU','Australia/Oceania',100);
INSERT INTO encompasses VALUES ('NCA','Australia/Oceania',100);
INSERT INTO encompasses VALUES ('NZ','Australia/Oceania',100);
INSERT INTO encompasses VALUES ('PAL','Australia/Oceania',100);
INSERT INTO encompasses VALUES ('SLB','Australia/Oceania',100);
INSERT INTO encompasses VALUES ('TO','Australia/Oceania',100);
INSERT INTO encompasses VALUES ('TUV','Australia/Oceania',100);
INSERT INTO encompasses VALUES ('VU','Australia/Oceania',100);
INSERT INTO encompasses VALUES ('WS','Australia/Oceania',100);
INSERT INTO encompasses VALUES ('RA','America',100);
INSERT INTO encompasses VALUES ('BOL','America',100);
INSERT INTO encompasses VALUES ('BR','America',100);
INSERT INTO encompasses VALUES ('RCH','America',100);
INSERT INTO encompasses VALUES ('PY','America',100);
INSERT INTO encompasses VALUES ('ROU','America',100);
INSERT INTO encompasses VALUES ('PE','America',100);
INSERT INTO encompasses VALUES ('FGU','America',100);
INSERT INTO encompasses VALUES ('GUY','America',100);
INSERT INTO encompasses VALUES ('SME','America',100);
INSERT INTO encompasses VALUES ('YV','America',100);
INSERT INTO encompasses VALUES ('EC','America',100);
INSERT INTO encompasses VALUES ('DZ','Africa',100);
INSERT INTO encompasses VALUES ('LAR','Africa',100);
INSERT INTO encompasses VALUES ('RMM','Africa',100);
INSERT INTO encompasses VALUES ('RIM','Africa',100);
INSERT INTO encompasses VALUES ('MA','Africa',100);
INSERT INTO encompasses VALUES ('RN','Africa',100);
INSERT INTO encompasses VALUES ('TN','Africa',100);
INSERT INTO encompasses VALUES ('WSA','Africa',100);
INSERT INTO encompasses VALUES ('ANG','Africa',100);
INSERT INTO encompasses VALUES ('RCB','Africa',100);
INSERT INTO encompasses VALUES ('NAM','Africa',100);
INSERT INTO encompasses VALUES ('ZRE','Africa',100);
INSERT INTO encompasses VALUES ('Z','Africa',100);
INSERT INTO encompasses VALUES ('BEN','