--
-- PostgreSQL port of the MySQL "World" database.
--
-- The sample data used in the world database is Copyright Statistics
-- Finland, http://www.stat.fi/worldinfigures.
--
-- The schema is called Countries in PCRS.

BEGIN;

DROP SCHEMA IF EXISTS World CASCADE;
CREATE SCHEMA World;
SET search_path TO World;

SET client_encoding = 'LATIN1';

CREATE TABLE country (
    code character(3) NOT NULL,
    name text NOT NULL,
    continent text NOT NULL,
    population integer NOT NULL
);

CREATE TABLE countrylanguage (
    countrycode character(3) NOT NULL,
    countrylanguage text NOT NULL,
    isofficial boolean NOT NULL,
    percentage real NOT NULL
);


insert into country (code, name, continent, population) values
('AFG','Afghanistan','Asia',22720000),
('NLD','Netherlands','Europe',15864000),
('ANT','Netherlands Antilles','North America',217000),
('ALB','Albania','Europe',3401200),
('DZA','Algeria','Africa',31471000),
('ASM','American Samoa','Oceania',68000),
('AND','Andorra','Europe',78000),
('AGO','Angola','Africa',12878000),
('AIA','Anguilla','North America',8000),
('ATG','Antigua and Barbuda','North America',68000),
('ARE','United Arab Emirates','Asia',2441000),
('ARG','Argentina','South America',37032000),
('ARM','Armenia','Asia',3520000),
('ABW','Aruba','North America',103000),
('AUS','Australia','Oceania',18886000),
('AZE','Azerbaijan','Asia',7734000),
('BHS','Bahamas','North America',307000),
('BHR','Bahrain','Asia',617000),
('BGD','Bangladesh','Asia',129155000),
('BRB','Barbados','North America',270000),
('BEL','Belgium','Europe',10239000),
('BLZ','Belize','North America',241000),
('BEN','Benin','Africa',6097000),
('BMU','Bermuda','North America',65000),
('BTN','Bhutan','Asia',2124000),
('BOL','Bolivia','South America',8329000),
('BIH','Bosnia and Herzegovina','Europe',3972000),
('BWA','Botswana','Africa',1622000),
('BRA','Brazil','South America',170115000),
('GBR','United Kingdom','Europe',59623400),
('VGB','Virgin Islands, British','North America',21000),
('BRN','Brunei','Asia',328000),
('BGR','Bulgaria','Europe',8190900),
('BFA','Burkina Faso','Africa',11937000),
('BDI','Burundi','Africa',6695000),
('CYM','Cayman Islands','North America',38000),
('CHL','Chile','South America',15211000),
('COK','Cook Islands','Oceania',20000),
('CRI','Costa Rica','North America',4023000),
('DJI','Djibouti','Africa',638000),
('DMA','Dominica','North America',71000),
('DOM','Dominican Republic','North America',8495000),
('ECU','Ecuador','South America',12646000),
('EGY','Egypt','Africa',68470000),
('SLV','El Salvador','North America',6276000),
('ERI','Eritrea','Africa',3850000),
('ESP','Spain','Europe',39441700),
('ZAF','South Africa','Africa',40377000),
('ETH','Ethiopia','Africa',62565000),
('FLK','Falkland Islands','South America',2000),
('FJI','Fiji Islands','Oceania',817000),
('PHL','Philippines','Asia',75967000),
('FRO','Faroe Islands','Europe',43000),
('GAB','Gabon','Africa',1226000),
('GMB','Gambia','Africa',1305000),
('GEO','Georgia','Asia',4968000),
('GHA','Ghana','Africa',20212000),
('GIB','Gibraltar','Europe',25000),
('GRD','Grenada','North America',94000),
('GRL','Greenland','North America',56000),
('GLP','Guadeloupe','North America',456000),
('GUM','Guam','Oceania',168000),
('GTM','Guatemala','North America',11385000),
('GIN','Guinea','Africa',7430000),
('GNB','Guinea-Bissau','Africa',1213000),
('GUY','Guyana','South America',861000),
('HTI','Haiti','North America',8222000),
('HND','Honduras','North America',6485000),
('HKG','Hong Kong','Asia',6782000),
('SJM','Svalbard and Jan Mayen','Europe',3200),
('IDN','Indonesia','Asia',212107000),
('IND','India','Asia',1013662000),
('IRQ','Iraq','Asia',23115000),
('IRN','Iran','Asia',67702000),
('IRL','Ireland','Europe',3775100),
('ISL','Iceland','Europe',279000),
('ISR','Israel','Asia',6217000),
('ITA','Italy','Europe',57680000),
('TMP','East Timor','Asia',885000),
('AUT','Austria','Europe',8091800),
('JAM','Jamaica','North America',2583000),
('JPN','Japan','Asia',126714000),
('YEM','Yemen','Asia',18112000),
('JOR','Jordan','Asia',5083000),
('CXR','Christmas Island','Oceania',2500),
('YUG','Yugoslavia','Europe',10640000),
('KHM','Cambodia','Asia',11168000),
('CMR','Cameroon','Africa',15085000),
('CAN','Canada','North America',31147000),
('CPV','Cape Verde','Africa',428000),
('KAZ','Kazakstan','Asia',16223000),
('KEN','Kenya','Africa',30080000),
('CAF','Central African Republic','Africa',3615000),
('CHN','China','Asia',1277558000),
('KGZ','Kyrgyzstan','Asia',4699000),
('KIR','Kiribati','Oceania',83000),
('COL','Colombia','South America',42321000),
('COM','Comoros','Africa',578000),
('COG','Congo','Africa',2943000),
('COD','Congo, The Democratic Republic of the','Africa',51654000),
('CCK','Cocos (Keeling) Islands','Oceania',600),
('PRK','North Korea','Asia',24039000),
('KOR','South Korea','Asia',46844000),
('GRC','Greece','Europe',10545700),
('HRV','Croatia','Europe',4473000),
('CUB','Cuba','North America',11201000),
('KWT','Kuwait','Asia',1972000),
('CYP','Cyprus','Asia',754700),
('LAO','Laos','Asia',5433000),
('LVA','Latvia','Europe',2424200),
('LSO','Lesotho','Africa',2153000),
('LBN','Lebanon','Asia',3282000),
('LBR','Liberia','Africa',3154000),
('LBY','Libyan Arab Jamahiriya','Africa',5605000),
('LIE','Liechtenstein','Europe',32300),
('LTU','Lithuania','Europe',3698500),
('LUX','Luxembourg','Europe',435700),
('ESH','Western Sahara','Africa',293000),
('MAC','Macao','Asia',473000),
('MDG','Madagascar','Africa',15942000),
('MKD','Macedonia','Europe',2024000),
('MWI','Malawi','Africa',10925000),
('MDV','Maldives','Asia',286000),
('MYS','Malaysia','Asia',22244000),
('MLI','Mali','Africa',11234000),
('MLT','Malta','Europe',380200),
('MAR','Morocco','Africa',28351000),
('MHL','Marshall Islands','Oceania',64000),
('MTQ','Martinique','North America',395000),
('MRT','Mauritania','Africa',2670000),
('MUS','Mauritius','Africa',1158000),
('MYT','Mayotte','Africa',149000),
('MEX','Mexico','North America',98881000),
('FSM','Micronesia, Federated States of','Oceania',119000),
('MDA','Moldova','Europe',4380000),
('MCO','Monaco','Europe',34000),
('MNG','Mongolia','Asia',2662000),
('MSR','Montserrat','North America',11000),
('MOZ','Mozambique','Africa',19680000),
('MMR','Myanmar','Asia',45611000),
('NAM','Namibia','Africa',1726000),
('NRU','Nauru','Oceania',12000),
('NPL','Nepal','Asia',23930000),
('NIC','Nicaragua','North America',5074000),
('NER','Niger','Africa',10730000),
('NGA','Nigeria','Africa',111506000),
('NIU','Niue','Oceania',2000),
('NFK','Norfolk Island','Oceania',2000),
('NOR','Norway','Europe',4478500),
('CIV','Cote d''Ivoire','Africa',14786000),
('OMN','Oman','Asia',2542000),
('PAK','Pakistan','Asia',156483000),
('PLW','Palau','Oceania',19000),
('PAN','Panama','North America',2856000),
('PNG','Papua New Guinea','Oceania',4807000),
('PRY','Paraguay','South America',5496000),
('PER','Peru','South America',25662000),
('PCN','Pitcairn','Oceania',50),
('MNP','Northern Mariana Islands','Oceania',78000),
('PRT','Portugal','Europe',9997600),
('PRI','Puerto Rico','North America',3869000),
('POL','Poland','Europe',38653600),
('GNQ','Equatorial Guinea','Africa',453000),
('QAT','Qatar','Asia',599000),
('FRA','France','Europe',59225700),
('GUF','French Guiana','South America',181000),
('PYF','French Polynesia','Oceania',235000),
('REU','Reunion','Africa',699000),
('ROM','Romania','Europe',22455500),
('RWA','Rwanda','Africa',7733000),
('SWE','Sweden','Europe',8861400),
('SHN','Saint Helena','Africa',6000),
('KNA','Saint Kitts and Nevis','North America',38000),
('LCA','Saint Lucia','North America',154000),
('VCT','Saint Vincent and the Grenadines','North America',114000),
('SPM','Saint Pierre and Miquelon','North America',7000),
('DEU','Germany','Europe',82164700),
('SLB','Solomon Islands','Oceania',444000),
('ZMB','Zambia','Africa',9169000),
('WSM','Samoa','Oceania',180000),
('SMR','San Marino','Europe',27000),
('STP','Sao Tome and Principe','Africa',147000),
('SAU','Saudi Arabia','Asia',21607000),
('SEN','Senegal','Africa',9481000),
('SYC','Seychelles','Africa',77000),
('SLE','Sierra Leone','Africa',4854000),
('SGP','Singapore','Asia',3567000),
('SVK','Slovakia','Europe',5398700),
('SVN','Slovenia','Europe',1987800),
('SOM','Somalia','Africa',10097000),
('LKA','Sri Lanka','Asia',18827000),
('SDN','Sudan','Africa',29490000),
('FIN','Finland','Europe',5171300),
('SUR','Suriname','South America',417000),
('SWZ','Swaziland','Africa',1008000),
('CHE','Switzerland','Europe',7160400),
('SYR','Syria','Asia',16125000),
('TJK','Tajikistan','Asia',6188000),
('TWN','Taiwan','Asia',22256000),
('TZA','Tanzania','Africa',33517000),
('DNK','Denmark','Europe',5330000),
('THA','Thailand','Asia',61399000),
('TGO','Togo','Africa',4629000),
('TKL','Tokelau','Oceania',2000),
('TON','Tonga','Oceania',99000),
('TTO','Trinidad and Tobago','North America',1295000),
('TCD','Chad','Africa',7651000),
('CZE','Czech Republic','Europe',10278100),
('TUN','Tunisia','Africa',9586000),
('TUR','Turkey','Asia',66591000),
('TKM','Turkmenistan','Asia',4459000),
('TCA','Turks and Caicos Islands','North America',17000),
('TUV','Tuvalu','Oceania',12000),
('UGA','Uganda','Africa',21778000),
('UKR','Ukraine','Europe',50456000),
('HUN','Hungary','Europe',10043200),
('URY','Uruguay','South America',3337000),
('NCL','New Caledonia','Oceania',214000),
('NZL','New Zealand','Oceania',3862000),
('UZB','Uzbekistan','Asia',24318000),
('BLR','Belarus','Europe',10236000),
('WLF','Wallis and Futuna','Oceania',15000),
('VUT','Vanuatu','Oceania',190000),
('VAT','Holy See (Vatican City State)','Europe',1000),
('VEN','Venezuela','South America',24170000),
('RUS','Russian Federation','Europe',146934000),
('VNM','Vietnam','Asia',79832000),
('EST','Estonia','Europe',1439200),
('USA','United States','North America',278357000),
('VIR','Virgin Islands, U.S.','North America',93000),
('ZWE','Zimbabwe','Africa',11669000),
('PSE','Palestine','Asia',3101000),
('ATA','Antarctica','Antarctica',0),
('BVT','Bouvet Island','Antarctica',0),
('IOT','British Indian Ocean Territory','Africa',0),
('SGS','South Georgia and the South Sandwich Islands','Antarctica',0),
('HMD','Heard Island and McDonald Islands','Antarctica',0),
('ATF','French Southern territories','Antarctica',0),
('UMI','United States Minor Outlying Islands','Oceania',0);


INSERT INTO countrylanguage (countrycode, countrylanguage, isofficial, percentage) VALUES
('AFG','Pashto',true,52.400002),
('NLD','Dutch',true,95.599998),
('ANT','Papiamento',true,86.199997),
('ALB','Albaniana',true,97.900002),
('DZA','Arabic',true,86),
('ASM','Samoan',true,90.599998),
('AND','Spanish',false,44.599998),
('AGO','Ovimbundu',false,37.200001),
('AIA','English',true,0),
('ATG','Creole English',false,95.699997),
('ARE','Arabic',true,42),
('ARG','Spanish',true,96.800003),
('ARM','Armenian',true,93.400002),
('ABW','Papiamento',false,76.699997),
('AUS','English',true,81.199997),
('AZE','Azerbaijani',true,89),
('BHS','Creole English',false,89.699997),
('BHR','Arabic',true,67.699997),
('BGD','Bengali',true,97.699997),
('BRB','Bajan',false,95.099998),
('BEL','Dutch',true,59.200001),
('BLZ','English',true,50.799999),
('BEN','Fon',false,39.799999),
('BMU','English',true,100),
('BTN','Dzongkha',true,50),
('BOL','Spanish',true,87.699997),
('BIH','Serbo-Croatian',true,99.199997),
('BWA','Tswana',false,75.5),
('BRA','Portuguese',true,97.5),
('GBR','English',true,97.300003),
('VGB','English',true,0),
('BRN','Malay',true,45.5),
('BGR','Bulgariana',true,83.199997),
('BFA','Mossi',false,50.200001),
('BDI','Kirundi',true,98.099998),
('CYM','English',true,0),
('CHL','Spanish',true,89.699997),
('COK','Maori',true,0),
('CRI','Spanish',true,97.5),
('DJI','Somali',false,43.900002),
('DMA','Creole English',false,100),
('DOM','Spanish',true,98),
('ECU','Spanish',true,93),
('EGY','Arabic',true,98.800003),
('SLV','Spanish',true,100),
('ERI','Tigrinja',true,49.099998),
('ESP','Spanish',true,74.400002),
('ZAF','Zulu',true,22.700001),
('ETH','Oromo',false,31),
('FLK','English',true,0),
('FJI','Fijian',true,50.799999),
('PHL','Pilipino',true,29.299999),
('FRO','Faroese',true,100),
('GAB','Fang',false,35.799999),
('GMB','Malinke',false,34.099998),
('GEO','Georgiana',true,71.699997),
('GHA','Akan',false,52.400002),
('GIB','English',true,88.900002),
('GRD','Creole English',false,100),
('GRL','Greenlandic',true,87.5),
('GLP','Creole French',false,95),
('GUM','English',true,37.5),
('GTM','Spanish',true,64.699997),
('GIN','Ful',false,38.599998),
('GNB','Crioulo',false,36.400002),
('GUY','Creole English',false,96.400002),
('HTI','Haiti Creole',false,100),
('HND','Spanish',true,97.199997),
('HKG','Canton Chinese',false,88.699997),
('SJM','Norwegian',true,0),
('IDN','Javanese',false,39.400002),
('IND','Hindi',true,39.900002),
('IRQ','Arabic',true,77.199997),
('IRN','Persian',true,45.700001),
('IRL','English',true,98.400002),
('ISL','Icelandic',true,95.699997),
('ISR','Hebrew',true,63.099998),
('ITA','Italian',true,94.099998),
('TMP','Sunda',false,0),
('AUT','German',true,92),
('JAM','Creole English',false,94.199997),
('JPN','Japanese',true,99.099998),
('YEM','Arabic',true,99.599998),
('JOR','Arabic',true,97.900002),
('CXR','Chinese',false,0),
('YUG','Serbo-Croatian',true,75.199997),
('KHM','Khmer',true,88.599998),
('CMR','Fang',false,19.700001),
('CAN','English',true,60.400002),
('CPV','Crioulo',false,100),
('KAZ','Kazakh',true,46),
('KEN','Kikuyu',false,20.9),
('CAF','Gbaya',false,23.799999),
('CHN','Chinese',true,92),
('KGZ','Kirgiz',true,59.700001),
('KIR','Kiribati',true,98.900002),
('COL','Spanish',true,99),
('COM','Comorian',true,75),
('COG','Kongo',false,51.5),
('COD','Luba',false,18),
('CCK','Malay',false,0),
('PRK','Korean',true,99.900002),
('KOR','Korean',true,99.900002),
('GRC','Greek',true,98.5),
('HRV','Serbo-Croatian',true,95.900002),
('CUB','Spanish',true,100),
('KWT','Arabic',true,78.099998),
('CYP','Greek',true,74.099998),
('LAO','Lao',true,67.199997),
('LVA','Latvian',true,55.099998),
('LSO','Sotho',true,85),
('LBN','Arabic',true,93),
('LBR','Kpelle',false,19.5),
('LBY','Arabic',true,96),
('LIE','German',true,89),
('LTU','Lithuanian',true,81.599998),
('LUX','Luxembourgish',true,64.400002),
('ESH','Arabic',true,100),
('MAC','Canton Chinese',false,85.599998),
('MDG','Malagasy',true,98.900002),
('MKD','Macedonian',true,66.5),
('MWI','Chichewa',true,58.299999),
('MDV','Dhivehi',true,100),
('MYS','Malay',true,58.400002),
('MLI','Bambara',false,31.799999),
('MLT','Maltese',true,95.800003),
('MAR','Arabic',true,65),
('MHL','Marshallese',true,96.800003),
('MTQ','Creole French',false,96.599998),
('MRT','Hassaniya',false,81.699997),
('MUS','Creole French',false,70.599998),
('MYT','Mahorz',false,41.900002),
('MEX','Spanish',true,92.099998),
('FSM','Trukese',false,41.599998),
('MDA','Romanian',true,61.900002),
('MCO','French',true,41.900002),
('MNG','Mongolian',true,78.800003),
('MSR','English',true,0),
('MOZ','Makua',false,27.799999),
('MMR','Burmese',true,69),
('NAM','Ovambo',false,50.700001),
('NRU','Nauru',true,57.5),
('NPL','Nepali',true,50.400002),
('NIC','Spanish',true,97.599998),
('NER','Hausa',false,53.099998),
('NGA','Joruba',false,21.4),
('NIU','Niue',false,0),
('NFK','English',true,0),
('NOR','Norwegian',true,96.599998),
('CIV','Akan',false,30),
('OMN','Arabic',true,76.699997),
('PAK','Punjabi',false,48.200001),
('PLW','Palau',true,82.199997),
('PAN','Spanish',true,76.800003),
('PNG','Papuan Languages',false,78.099998),
('PRY','Spanish',true,55.099998),
('PER','Spanish',true,79.800003),
('PCN','Pitcairnese',false,0),
('MNP','Philippene Languages',false,34.099998),
('PRT','Portuguese',true,99),
('PRI','Spanish',true,51.299999),
('POL','Polish',true,97.599998),
('GNQ','Fang',false,84.800003),
('QAT','Arabic',true,40.700001),
('FRA','French',true,93.599998),
('GUF','Creole French',false,94.300003),
('PYF','Tahitian',false,46.400002),
('REU','Creole French',false,91.5),
('ROM','Romanian',true,90.699997),
('RWA','Rwanda',true,100),
('SWE','Swedish',true,89.5),
('SHN','English',true,0),
('KNA','Creole English',false,100),
('LCA','Creole French',false,80),
('VCT','Creole English',false,99.099998),
('SPM','French',true,0),
('DEU','German',true,91.300003),
('SLB','Malenasian Languages',false,85.599998),
('ZMB','Bemba',false,29.700001),
('WSM','Samoan-English',false,52),
('SMR','Italian',true,100),
('STP','Crioulo',false,86.300003),
('SAU','Arabic',true,95),
('SEN','Wolof',true,48.099998),
('SYC','Seselwa',false,91.300003),
('SLE','Mende',false,34.799999),
('SGP','Chinese',true,77.099998),
('SVK','Slovak',true,85.599998),
('SVN','Slovene',true,87.900002),
('SOM','Somali',true,98.300003),
('LKA','Singali',true,60.299999),
('SDN','Arabic',true,49.400002),
('FIN','Finnish',true,92.699997),
('SUR','Sranantonga',false,81),
('SWZ','Swazi',true,89.900002),
('CHE','German',true,63.599998),
('SYR','Arabic',true,90),
('TJK','Tadzhik',true,62.200001),
('TWN','Min',false,66.699997),
('TZA','Nyamwesi',false,21.1),
('DNK','Danish',true,93.5),
('THA','Thai',true,52.599998),
('TGO','Ewe',true,23.200001),
('TKL','Tokelau',false,0),
('TON','Tongan',true,98.300003),
('TTO','English',false,93.5),
('TCD','Sara',false,27.700001),
('CZE','Czech',true,81.199997),
('TUN','Arabic',true,69.900002),
('TUR','Turkish',true,87.599998),
('TKM','Turkmenian',true,76.699997),
('TCA','English',true,0),
('TUV','Tuvalu',true,92.5),
('UGA','Ganda',false,18.1),
('UKR','Ukrainian',true,64.699997),
('HUN','Hungarian',true,98.5),
('URY','Spanish',true,95.699997),
('NCL','Malenasian Languages',false,45.400002),
('NZL','English',true,87),
('UZB','Uzbek',true,72.599998),
('BLR','Belorussian',true,65.599998),
('WLF','Wallis',false,0),
('VUT','Bislama',true,56.599998),
('VAT','Italian',true,0),
('VEN','Spanish',true,96.900002),
('RUS','Russian',true,86.599998),
('VNM','Vietnamese',true,86.800003),
('EST','Estonian',true,65.300003),
('USA','English',true,86.199997),
('VIR','English',true,81.699997),
('UMI','English',true,0),
('ZWE','Shona',false,72.099998),
('PSE','Arabic',false,95.900002),
('AFG','Dari',true,32.099998),
('NLD','Fries',false,3.7),
('ANT','English',false,7.8000002),
('ALB','Greek',false,1.8),
('DZA','Berberi',false,14),
('ASM','English',true,3.0999999),
('AND','Catalan',true,32.299999),
('AGO','Mbundu',false,21.6),
('ATG','English',true,0),
('ARE','Hindi',false,0),
('ARG','Italian',false,1.7),
('ARM','Azerbaijani',false,2.5999999),
('ABW','English',false,9.5),
('AUS','Italian',false,2.2),
('AZE','Russian',false,3),
('BHS','Creole French',false,10.3),
('BHR','English',false,0),
('BGD','Chakma',false,0.40000001),
('BRB','English',true,0),
('BEL','French',true,32.599998),
('BLZ','Spanish',false,31.6),
('BEN','Joruba',false,12.2),
('BTN','Nepali',false,34.799999),
('BOL','Ket?ua',true,8.1000004),
('BWA','Shona',false,12.3),
('BRA','German',false,0.5),
('GBR','Kymri',false,0.89999998),
('BRN','Malay-English',false,28.799999),
('BGR','Turkish',false,9.3999996),
('BFA','Ful',false,9.6999998),
('BDI','French',true,0),
('CHL','Araucan',false,9.6000004),
('COK','English',false,0),
('CRI','Creole English',false,2),
('DJI','Afar',false,34.799999),
('DMA','Creole French',false,0),
('DOM','Creole French',false,2),
('ECU','Ket?ua',false,7),
('EGY','Sinaberberi',false,0),
('SLV','Nahua',false,0),
('ERI','Tigre',false,31.700001),
('ESP','Catalan',false,16.9),
('ZAF','Xhosa',true,17.700001),
('ETH','Amhara',false,30),
('FJI','Hindi',false,43.700001),
('PHL','Cebuano',false,23.299999),
('FRO','Danish',true,0),
('GAB','Punu-sira-nzebi',false,17.1),
('GMB','Ful',false,16.200001),
('GEO','Russian',false,8.8000002),
('GHA','Mossi',false,15.8),
('GIB','Arabic',false,7.4000001),
('GRL','Danish',true,12.5),
('GLP','French',true,0),
('GUM','Chamorro',true,29.6),
('GTM','Quichz',false,10.1),
('GIN','Malinke',false,23.200001),
('GNB','Ful',false,16.6),
('GUY','Caribbean',false,2.2),
('HTI','French',true,0),
('HND','Garifuna',false,1.3),
('HKG','English',true,2.2),
('SJM','Russian',false,0),
('IDN','Sunda',false,15.8),
('IND','Bengali',false,8.1999998),
('IRQ','Kurdish',false,19),
('IRN','Azerbaijani',false,16.799999),
('IRL','Irish',true,1.6),
('ISL','English',false,0),
('ISR','Arabic',true,18),
('ITA','Sardinian',false,2.7),
('TMP','Portuguese',true,0),
('AUT','Serbo-Croatian',false,2.2),
('JAM','Hindi',false,1.9),
('JPN','Korean',false,0.5),
('YEM','Soqutri',false,0),
('JOR','Circassian',false,1),
('CXR','English',true,0),
('YUG','Albaniana',false,16.5),
('KHM','Vietnamese',false,5.5),
('CMR','Bamileke-bamum',false,18.6),
('CAN','French',true,23.4),
('CPV','Portuguese',true,0),
('KAZ','Russian',false,34.700001),
('KEN','Luhya',false,13.8),
('CAF','Banda',false,23.5),
('CHN','Zhuang',false,1.4),
('KGZ','Russian',true,16.200001),
('KIR','Tuvalu',false,0.5),
('COL','Chibcha',false,0.40000001),
('COM','Comorian-French',false,12.9),
('COG','Teke',false,17.299999),
('COD','Kongo',false,16),
('CCK','English',true,0),
('PRK','Chinese',false,0.1),
('KOR','Chinese',false,0.1),
('GRC','Turkish',false,0.89999998),
('HRV','Slovene',false,0),
('KWT','English',false,0),
('CYP','Turkish',true,22.4),
('LAO','Mon-khmer',false,16.5),
('LVA','Russian',false,32.5),
('LSO','Zulu',false,15),
('LBN','Armenian',false,5.9000001),
('LBR','Bassa',false,13.7),
('LBY','Berberi',false,1),
('LIE','Italian',false,2.5),
('LTU','Russian',false,8.1000004),
('LUX','Portuguese',false,13),
('MAC','Portuguese',true,2.3),
('MDG','French',true,0),
('MKD','Albaniana',false,22.9),
('MWI','Lomwe',false,18.4),
('MDV','English',false,0),
('MYS','Chinese',false,9),
('MLI','Ful',false,13.9),
('MLT','English',true,2.0999999),
('MAR','Berberi',false,33),
('MHL','English',true,0),
('MTQ','French',true,0),
('MRT','Wolof',false,6.5999999),
('MUS','Bhojpuri',false,21.1),
('MYT','French',true,20.299999),
('MEX','Nahuatl',false,1.8),
('FSM','Pohnpei',false,23.799999),
('MDA','Russian',false,23.200001),
('MCO','Monegasque',false,16.1),
('MNG','Kazakh',false,5.9000001),
('MOZ','Tsonga',false,12.4),
('MMR','Shan',false,8.5),
('NAM','Nama',false,12.4),
('NRU','Kiribati',false,17.9),
('NPL','Maithili',false,11.9),
('NIC','Miskito',false,1.6),
('NER','Songhai-zerma',false,21.200001),
('NGA','Hausa',false,21.1),
('NIU','English',true,0),
('NOR','English',false,0.5),
('CIV','Gur',false,11.7),
('OMN','Balochi',false,0),
('PAK','Pashto',false,13.1),
('PLW','Philippene Languages',false,9.1999998),
('PAN','Creole English',false,14),
('PNG','Malenasian Languages',false,20),
('PRY','Guarani',true,40.099998),
('PER','Ket?ua',true,16.4),
('MNP','Chamorro',false,30),
('PRI','English',false,47.400002),
('POL','German',false,1.3),
('GNQ','Bubi',false,8.6999998),
('QAT','Urdu',false,0),
('FRA','Arabic',false,2.5),
('GUF','Indian Languages',false,1.9),
('PYF','French',true,40.799999),
('REU','Chinese',false,2.8),
('ROM','Hungarian',false,7.1999998),
('RWA','French',true,0),
('SWE','Finnish',false,2.4000001),
('KNA','English',true,0),
('LCA','English',true,20),
('VCT','English',true,0),
('DEU','Turkish',false,2.5999999),
('SLB','Papuan Languages',false,8.6000004),
('ZMB','Tongan',false,11),
('WSM','Samoan',true,47.5),
('STP','French',false,0.69999999),
('SEN','Ful',false,21.700001),
('SYC','English',true,3.8),
('SLE','Temne',false,31.799999),
('SGP','Malay',true,14.1),
('SVK','Hungarian',false,10.5),
('SVN','Serbo-Croatian',false,7.9000001),
('SOM','Arabic',true,0),
('LKA','Tamil',true,19.6),
('SDN','Dinka',false,11.5),
('FIN','Swedish',true,5.6999998),
('SUR','Hindi',false,0),
('SWZ','Zulu',false,2),
('CHE','French',true,19.200001),
('SYR','Kurdish',false,9),
('TJK','Uzbek',false,23.200001),
('TWN','Mandarin Chinese',true,20.1),
('TZA','Swahili',true,8.8000002),
('DNK','Turkish',false,0.80000001),
('THA','Lao',false,26.9),
('TGO','Kabyz',true,13.8),
('TKL','English',true,0),
('TON','English',true,0),
('TTO','Hindi',false,3.4000001),
('TCD','Arabic',true,12.3),
('CZE','Moravian',false,12.9),
('TUN','Arabic-French',false,26.299999),
('TUR','Kurdish',false,10.6),
('TKM','Uzbek',false,9.1999998),
('TUV','Kiribati',false,7.5),
('UGA','Nkole',false,10.7),
('UKR','Russian',false,32.900002),
('HUN','Romani',false,0.5),
('NCL','French',true,34.299999),
('NZL','Maori',false,4.3000002),
('UZB','Russian',false,10.9),
('BLR','Russian',true,32),
('WLF','Futuna',false,0),
('VUT','English',true,28.299999),
('VEN','Goajiro',false,0.40000001),
('RUS','Tatar',false,3.2),
('VNM','Tho',false,1.8),
('EST','Russian',false,27.799999),
('USA','Spanish',false,7.5),
('VIR','Spanish',false,13.3),
('ZWE','Ndebele',false,16.200001),
('PSE','Hebrew',false,4.0999999),
('AFG','Uzbek',false,8.8000002),
('NLD','Arabic',false,0.89999998),
('ANT','Dutch',true,0),
('ALB','Macedonian',false,0.1),
('ASM','Tongan',false,3.0999999),
('AND','Portuguese',false,10.8),
('AGO','Kongo',false,13.2),
('ARG','Indian Languages',false,0.30000001),
('ABW','Spanish',false,7.4000001),
('AUS','Greek',false,1.6),
('AZE','Lezgian',false,2.3),
('BGD','Marma',false,0.2),
('BEL','Italian',false,2.4000001),
('BLZ','Maya Languages',false,9.6000004),
('BEN','Adja',false,11.1),
('BTN','Asami',false,15.2),
('BOL','Aimara',true,3.2),
('BWA','San',false,3.5),
('BRA','Italian',false,0.40000001),
('GBR','Gaeli',false,0.1),
('BRN','Chinese',false,9.3000002),
('BGR','Romani',false,3.7),
('BFA','Gurma',false,5.6999998),
('BDI','Swahili',false,0),
('CHL','Aimara',false,0.5),
('CRI','Chibcha',false,0.30000001),
('DJI','Arabic',true,10.6),
('ERI','Afar',false,4.3000002),
('ESP','Galecian',false,6.4000001),
('ZAF','Afrikaans',true,14.3),
('ETH','Tigrinja',false,7.1999998),
('PHL','Ilocano',false,9.3000002),
('GAB','Mpongwe',false,14.6),
('GMB','Wolof',false,12.6),
('GEO','Armenian',false,6.8000002),
('GHA','Ewe',false,11.9),
('GUM','Philippene Languages',false,19.700001),
('GTM','Cakchiquel',false,8.8999996),
('GIN','Susu',false,11),
('GNB','Balante',false,14.6),
('GUY','Arawakan',false,1.4),
('HND','Creole English',false,0.2),
('HKG','Fukien',false,1.9),
('IDN','Malay',true,12.1),
('IND','Telugu',false,7.8000002),
('IRQ','Azerbaijani',false,1.7),
('IRN','Kurdish',false,9.1000004),
('ISR','Russian',false,8.8999996),
('ITA','Friuli',false,1.2),
('AUT','Turkish',false,1.5),
('JPN','Chinese',false,0.2),
('JOR','Armenian',false,1),
('YUG','Hungarian',false,3.4000001),
('KHM','Chinese',false,3.0999999),
('CMR','Duala',false,10.9),
('CAN','Chinese',false,2.5),
('KAZ','Ukrainian',false,5),
('KEN','Luo',false,12.8),
('CAF','Mandjia',false,14.8),
('CHN','Mant?u',false,0.89999998),
('KGZ','Uzbek',false,14.1),
('COL','Creole English',false,0.1),
('COM','Comorian-madagassi',false,5.5),
('COG','Mboshi',false,11.4),
('COD','Mongo',false,13.5),
('LAO','Thai',false,7.8000002),
('LVA','Belorussian',false,4.0999999),
('LSO','English',true,0),
('LBN','French',false,0),
('LBR','Grebo',false,8.8999996),
('LIE','Turkish',false,2.5),
('LTU','Polish',false,7),
('LUX','Italian',false,4.5999999),
('MAC','Mandarin Chinese',false,1.2),
('MKD','Turkish',false,4),
('MWI','Yao',false,13.2),
('MYS','Tamil',false,3.9000001),
('MLI','Senufo and Minianka',false,12),
('MRT','Tukulor',false,5.4000001),
('MUS','French',false,3.4000001),
('MYT','Malagasy',false,16.1),
('MEX','Yucatec',false,1.1),
('FSM','Mortlock',false,7.5999999),
('MDA','Ukrainian',false,8.6000004),
('MCO','Italian',false,16.1),
('MNG','Dorbet',false,2.7),
('MOZ','Sena',false,9.3999996),
('MMR','Karen',false,6.1999998),
('NAM','Kavango',false,9.6999998),
('NRU','Chinese',false,8.5),
('NPL','Bhojpuri',false,7.5),
('NIC','Creole English',false,0.5),
('NER','Tamashek',false,10.4),
('NGA','Ibo',false,18.1),
('NOR','Danish',false,0.40000001),
('CIV','Malinke',false,11.4),
('PAK','Sindhi',false,11.8),
('PLW','English',true,3.2),
('PAN','Guaymi',false,5.3000002),
('PRY','Portuguese',false,3.2),
('PER','Aimara',true,2.3),
('MNP','Chinese',false,7.0999999),
('POL','Ukrainian',false,0.60000002),
('FRA','Portuguese',false,1.2),
('PYF','Chinese',false,2.9000001),
('REU','Comorian',false,2.8),
('ROM','Romani',true,0.69999999),
('SWE','Southern Slavic Languages',false,1.3),
('DEU','Southern Slavic Languages',false,1.4),
('SLB','Polynesian Languages',false,3.8),
('ZMB','Nyanja',false,7.8000002),
('WSM','English',true,0.60000002),
('SEN','Serer',false,12.5),
('SYC','French',true,1.3),
('SLE','Limba',false,8.3000002),
('SGP','Tamil',true,7.4000001),
('SVK','Romani',false,1.7),
('SVN','Hungarian',false,0.5),
('LKA','Mixed Languages',false,19.6),
('SDN','Nubian Languages',false,8.1000004),
('FIN','Russian',false,0.40000001),
('CHE','Italian',true,7.6999998),
('TJK','Russian',false,9.6999998),
('TWN','Hakka',false,11),
('TZA','Hehet',false,6.9000001),
('DNK','Arabic',false,0.69999999),
('THA','Chinese',false,12.1),
('TGO','Watyi',false,10.3),
('TTO','Creole English',false,2.9000001),
('TCD','Mayo-kebbi',false,11.5),
('CZE','Slovak',false,3.0999999),
('TUN','Arabic-French-English',false,3.2),
('TUR','Arabic',false,1.4),
('TKM','Russian',false,6.6999998),
('TUV','English',true,0),
('UGA','Kiga',false,8.3000002),
('UKR','Romanian',false,0.69999999),
('HUN','German',false,0.40000001),
('NCL','Polynesian Languages',false,11.6),
('UZB','Tadzhik',false,4.4000001),
('BLR','Ukrainian',false,1.3),
('VUT','French',true,14.2),
('VEN','Warrau',false,0.1),
('RUS','Ukrainian',false,1.3),
('VNM','Thai',false,1.6),
('EST','Ukrainian',false,2.8),
('USA','French',false,0.69999999),
('VIR','French',false,2.5),
('ZWE','English',true,2.2),
('AFG','Turkmenian',false,1.9),
('NLD','Turkish',false,0.80000001),
('AND','French',false,6.1999998),
('AGO','Luimbe-nganguela',false,5.4000001),
('ABW','Dutch',true,5.3000002),
('AUS','Canton Chinese',false,1.1),
('AZE','Armenian',false,2),
('BGD','Garo',false,0.1),
('BEL','Arabic',false,1.6),
('BLZ','Garifuna',false,6.8000002),
('BEN','Aizo',false,8.6999998),
('BOL','Guarani',false,0.1),
('BWA','Khoekhoe',false,2.5),
('BRA','Japanese',false,0.40000001),
('BRN','English',false,3.0999999),
('BGR','Macedonian',false,2.5999999),
('BFA','Busansi',false,3.5),
('CHL','Rapa nui',false,0.2),
('CRI','Chinese',false,0.2),
('ERI','Hadareb',false,3.8),
('ESP','Basque',false,1.6),
('ZAF','Northsotho',false,9.1000004),
('ETH','Gurage',false,4.6999998),
('PHL','Hiligaynon',false,9.1000004),
('GAB','Mbete',false,13.8),
('GMB','Diola',false,9.1999998),
('GEO','Azerbaijani',false,5.5),
('GHA','Ga-adangme',false,7.8000002),
('GUM','Korean',false,3.3),
('GTM','Kekchi',false,4.9000001),
('GIN','Kissi',false,6),
('GNB','Portuguese',true,8.1000004),
('HND','Miskito',false,0.2),
('HKG','Hakka',false,1.6),
('IDN','Madura',false,4.3000002),
('IND','Marathi',false,7.4000001),
('IRQ','Assyrian',false,0.80000001),
('IRN','Gilaki',false,5.3000002),
('ITA','French',false,0.5),
('AUT','Hungarian',false,0.40000001),
('JPN','English',false,0.1),
('YUG','Romani',false,1.4),
('KHM','T?am',false,2.4000001),
('CMR','Ful',false,9.6000004),
('CAN','Italian',false,1.7),
('KAZ','German',false,3.0999999),
('KEN','Kamba',false,11.2),
('CAF','Ngbaka',false,7.5),
('CHN','Hui',false,0.80000001),
('KGZ','Ukrainian',false,1.7),
('COL','Arawakan',false,0.1),
('COM','Comorian-Arabic',false,1.6),
('COG','Mbete',false,4.8000002),
('COD','Rwanda',false,10.3),
('LAO','Lao-Soung',false,5.1999998),
('LVA','Ukrainian',false,2.9000001),
('LBR','Gio',false,7.9000001),
('LTU','Belorussian',false,1.4),
('LUX','French',true,4.1999998),
('MAC','English',false,0.5),
('MKD','Romani',false,2.3),
('MWI','Ngoni',false,6.6999998),
('MYS','Iban',false,2.8),
('MLI','Soninke',false,8.6999998),
('MRT','Soninke',false,2.7),
('MUS','Hindi',false,1.2),
('MEX','Zapotec',false,0.60000002),
('FSM','Kosrean',false,7.3000002),
('MDA','Gagauzi',false,3.2),
('MCO','English',false,6.5),
('MNG','Bajad',false,1.9),
('MOZ','Lomwe',false,7.8000002),
('MMR','Rakhine',false,4.5),
('NAM','Afrikaans',false,9.5),
('NRU','Tuvalu',false,8.5),
('NPL','Tharu',false,5.4000001),
('NIC','Sumo',false,0.2),
('NER','Ful',false,9.6999998),
('NGA','Ful',false,11.3),
('NOR','Swedish',false,0.30000001),
('CIV','Kru',false,10.5),
('PAK','Saraiki',false,9.8000002),
('PLW','Chinese',false,1.6),
('PAN','Cuna',false,2),
('PRY','German',false,0.89999998),
('MNP','Korean',false,6.5),
('POL','Belorussian',false,0.5),
('FRA','Italian',false,0.40000001),
('REU','Malagasy',false,1.4),
('ROM','German',false,0.40000001),
('SWE','Arabic',false,0.80000001),
('DEU','Italian',false,0.69999999),
('ZMB','Lozi',false,6.4000001),
('SEN','Diola',false,5),
('SLE','Kono-vai',false,5.0999999),
('SVK','Czech and Moravian',false,1.1),
('SDN','Beja',false,6.4000001),
('FIN','Estonian',false,0.2),
('CHE','Romansh',true,0.60000002),
('TWN','Ami',false,0.60000002),
('TZA','Haya',false,5.9000001),
('DNK','German',false,0.5),
('THA','Malay',false,3.5999999),
('TGO','Kotokoli',false,5.6999998),
('TCD','Kanem-bornu',false,9),
('CZE','Polish',false,0.60000002),
('TKM','Kazakh',false,2),
('UGA','Soga',false,8.1999998),
('UKR','Bulgariana',false,0.30000001),
('HUN','Serbo-Croatian',false,0.2),
('UZB','Kazakh',false,3.8),
('BLR','Polish',false,0.60000002),
('RUS','Chuvash',false,0.89999998),
('VNM','Muong',false,1.5),
('EST','Belorussian',false,1.4),
('USA','German',false,0.69999999),
('ZWE','Nyanja',false,2.2),
('AFG','Balochi',false,0.89999998),
('AGO','Nyaneka-nkhumbi',false,5.4000001),
('AUS','Arabic',false,1),
('BGD','Khasi',false,0.1),
('BEL','German',true,1),
('BEN','Bariba',false,8.6999998),
('BWA','Ndebele',false,1.3),
('BRA','Indian Languages',false,0.2),
('BFA','Dagara',false,3.0999999),
('ERI','Bilin',false,3),
('ZAF','English',true,8.5),
('ETH','Somali',false,4.0999999),
('PHL','Bicol',false,5.6999998),
('GMB','Soninke',false,7.5999999),
('GEO','Osseetti',false,2.4000001),
('GHA','Gurma',false,3.3),
('GUM','Japanese',false,2),
('GTM','Mam',false,2.7),
('GIN','Kpelle',false,4.5999999),
('GNB','Malinke',false,6.9000001),
('HKG','Chiu chau',false,1.4),
('IDN','Minangkabau',false,2.4000001),
('IND','Tamil',false,6.3000002),
('IRQ','Persian',false,0.80000001),
('IRN','Luri',false,4.3000002),
('ITA','German',false,0.5),
('AUT','Slovene',false,0.40000001),
('JPN','Philippene Languages',false,0.1),
('YUG','Slovak',false,0.69999999),
('CMR','Tikar',false,7.4000001),
('CAN','German',false,1.6),
('KAZ','Uzbek',false,2.3),
('KEN','Kalenjin',false,10.8),
('CAF','Sara',false,6.4000001),
('CHN','Miao',false,0.69999999),
('KGZ','Tatar',false,1.3),
('COL','Caribbean',false,0.1),
('COM','Comorian-Swahili',false,0.5),
('COG','Punu',false,2.9000001),
('COD','Zande',false,6.0999999),
('LVA','Polish',false,2.0999999),
('LBR','Kru',false,7.1999998),
('LTU','Ukrainian',false,1.1),
('LUX','German',true,2.3),
('MKD','Serbo-Croatian',false,2),
('MYS','English',false,1.6),
('MLI','Tamashek',false,7.3000002),
('MRT','Ful',false,1.2),
('MUS','Tamil',false,0.80000001),
('MEX','Mixtec',false,0.60000002),
('FSM','Yap',false,5.8000002),
('MDA','Bulgariana',false,1.6),
('MNG','Buryat',false,1.7),
('MOZ','Shona',false,6.5),
('MMR','Mon',false,2.4000001),
('NAM','Herero',false,8),
('NRU','English',true,7.5),
('NPL','Tamang',false,4.9000001),
('NER','Kanuri',false,4.4000001),
('NGA','Ibibio',false,5.5999999),
('NOR','Saame',false,0),
('CIV','[South]Mande',false,7.6999998),
('PAK','Urdu',true,7.5999999),
('PAN','Embera',false,0.60000002),
('MNP','English',true,4.8000002),
('FRA','Spanish',false,0.40000001),
('REU','Tamil',false,0),
('ROM','Ukrainian',false,0.30000001),
('SWE','Spanish',false,0.60000002),
('DEU','Greek',false,0.40000001),
('ZMB','Chewa',false,5.6999998),
('SEN','Malinke',false,3.8),
('SLE','Bullom-sherbro',false,3.8),
('SVK','Ukrainian and Russian',false,0.60000002),
('SDN','Nuer',false,4.9000001),
('FIN','Saame',false,0),
('TWN','Atayal',false,0.40000001),
('TZA','Makonde',false,5.9000001),
('DNK','English',false,0.30000001),
('THA','Khmer',false,1.3),
('TGO','Ane',false,5.6999998),
('TCD','Ouaddai',false,8.6999998),
('CZE','German',false,0.5),
('UGA','Teso',false,6),
('UKR','Hungarian',false,0.30000001),
('HUN','Romanian',false,0.1),
('UZB','Karakalpak',false,2),
('RUS','Bashkir',false,0.69999999),
('VNM','Chinese',false,1.4),
('EST','Finnish',false,0.69999999),
('USA','Italian',false,0.60000002),
('AGO','Chokwe',false,4.1999998),
('AUS','Vietnamese',false,0.80000001),
('BGD','Santhali',false,0.1),
('BEL','Turkish',false,0.89999998),
('BEN','Somba',false,6.6999998),
('BFA','Dyula',false,2.5999999),
('ERI','Saho',false,3),
('ZAF','Tswana',false,8.1000004),
('ETH','Sidamo',false,3.2),
('PHL','Waray-waray',false,3.8),
('GEO','Abhyasi',false,1.7),
('GHA','Joruba',false,1.3),
('GIN','Yalunka',false,2.9000001),
('GNB','Mandyako',false,4.9000001),
('IDN','Batakki',false,2.2),
('IND','Urdu',false,5.0999999),
('IRN','Mazandarani',false,3.5999999),
('ITA','Albaniana',false,0.2),
('AUT','Polish',false,0.2),
('JPN','Ainu',false,0),
('YUG','Macedonian',false,0.5),
('CMR','Mandara',false,5.6999998),
('CAN','Polish',false,0.69999999),
('KAZ','Tatar',false,2),
('KEN','Gusii',false,6.0999999),
('CAF','Mbum',false,6.4000001),
('CHN','Uighur',false,0.60000002),
('KGZ','Kazakh',false,0.80000001),
('COG','Sango',false,2.5999999),
('COD','Ngala and Bangi',false,5.8000002),
('LVA','Lithuanian',false,1.2),
('LBR','Mano',false,7.1999998),
('MYS','Dusun',false,1.1),
('MLI','Songhai',false,6.9000001),
('MRT','Zenaga',false,1.2),
('MUS','Marathi',false,0.69999999),
('MEX','Otomi',false,0.40000001),
('FSM','Wolea',false,3.7),
('MNG','Dariganga',false,1.4),
('MOZ','Tswa',false,6),
('MMR','Chin',false,2.2),
('NAM','Caprivi',false,4.6999998),
('NPL','Newari',false,3.7),
('NGA','Kanuri',false,4.0999999),
('PAK','Balochi',false,3),
('PAN','Arabic',false,0.60000002),
('MNP','Carolinian',false,4.8000002),
('FRA','Turkish',false,0.40000001),
('ROM','Serbo-Croatian',false,0.1),
('SWE','Norwegian',false,0.5),
('DEU','Polish',false,0.30000001),
('ZMB','Nsenga',false,4.3000002),
('SEN','Soninke',false,1.3),
('SLE','Ful',false,3.8),
('SDN','Zande',false,2.7),
('TWN','Paiwan',false,0.30000001),
('TZA','Nyakusa',false,5.4000001),
('DNK','Swedish',false,0.30000001),
('THA','Kuy',false,1.1),
('TGO','Moba',false,5.4000001),
('TCD','Hadjarai',false,6.6999998),
('CZE','Silesiana',false,0.40000001),
('UGA','Lango',false,5.9000001),
('UKR','Belorussian',false,0.30000001),
('HUN','Slovak',false,0.1),
('UZB','Tatar',false,1.8),
('RUS','Chechen',false,0.60000002),
('VNM','Khmer',false,1.4),
('USA','Chinese',false,0.60000002),
('AGO','Luvale',false,3.5999999),
('AUS','Serbo-Croatian',false,0.60000002),
('BGD','Tripuri',false,0.1),
('BEN','Ful',false,5.5999999),
('ZAF','Southsotho',false,7.5999999),
('ETH','Walaita',false,2.8),
('PHL','Pampango',false,3),
('GIN','Loma',false,2.3),
('IDN','Bugi',false,2.2),
('IND','Gujarati',false,4.8000002),
('IRN','Balochi',false,2.3),
('ITA','Slovene',false,0.2),
('AUT','Czech',false,0.2),
('CMR','Maka',false,4.9000001),
('CAN','Spanish',false,0.69999999),
('KEN','Meru',false,5.5),
('CHN','Yi',false,0.60000002),
('KGZ','Tadzhik',false,0.80000001),
('COD','Rundi',false,3.8),
('LBR','Loma',false,5.8000002),
('MOZ','Chuabo',false,5.6999998),
('MMR','Kachin',false,1.4),
('NAM','San',false,1.9),
('NPL','Hindi',false,3),
('NGA','Edo',false,3.3),
('PAK','Hindko',false,2.4000001),
('SLE','Kuranko',false,3.4000001),
('SDN','Bari',false,2.5),
('TZA','Chaga and Pare',false,4.9000001),
('DNK','Norwegian',false,0.30000001),
('TGO','Naudemba',false,4.0999999),
('TCD','Tandjile',false,6.5),
('CZE','Romani',false,0.30000001),
('UGA','Lugbara',false,4.6999998),
('UKR','Polish',false,0.1),
('RUS','Mordva',false,0.5),
('VNM','Nung',false,1.1),
('USA','Tagalog',false,0.40000001),
('AGO','Ambo',false,2.4000001),
('AUS','German',false,0.60000002),
('ZAF','Tsonga',false,4.3000002),
('PHL','Pangasinan',false,1.8),
('IDN','Banja',false,1.8),
('IND','Kannada',false,3.9000001),
('IRN','Arabic',false,2.2),
('ITA','Romani',false,0.2),
('AUT','Romanian',false,0.2),
('CMR','Masana',false,3.9000001),
('CAN','Portuguese',false,0.69999999),
('KEN','Nyika',false,4.8000002),
('CHN','Tujia',false,0.5),
('COD','Teke',false,2.7),
('LBR','Malinke',false,5.0999999),
('MOZ','Ronga',false,3.7),
('MMR','Kayah',false,0.40000001),
('NAM','German',false,0.89999998),
('NGA','Tiv',false,2.3),
('PAK','Brahui',false,1.2),
('SLE','Yalunka',false,3.4000001),
('SDN','Fur',false,2.0999999),
('TZA','Luguru',false,4.9000001),
('TGO','Gurma',false,3.4000001),
('TCD','Gorane',false,6.1999998),
('CZE','Hungarian',false,0.2),
('UGA','Gisu',false,4.5),
('RUS','Kazakh',false,0.40000001),
('VNM','Miao',false,0.89999998),
('USA','Polish',false,0.30000001),
('AGO','Luchazi',false,2.4000001),
('ZAF','Swazi',false,2.5),
('PHL','Maguindanao',false,1.4),
('IDN','Bali',false,1.7),
('IND','Malajalam',false,3.5999999),
('IRN','Bakhtyari',false,1.7),
('CAN','Punjabi',false,0.69999999),
('KEN','Masai',false,1.6),
('CHN','Mongolian',false,0.40000001),
('COD','Boa',false,2.3),
('MOZ','Marendje',false,3.5),
('NGA','Ijo',false,1.8),
('SDN','Chilluk',false,1.7),
('TZA','Shambala',false,4.3000002),
('UGA','Acholi',false,4.4000001),
('RUS','Avarian',false,0.40000001),
('VNM','Man',false,0.69999999),
('USA','Korean',false,0.30000001),
('ZAF','Venda',false,2.2),
('PHL','Maranao',false,1.3),
('IND','Orija',false,3.3),
('IRN','Turkmenian',false,1.6),
('CAN','Ukrainian',false,0.60000002),
('KEN','Turkana',false,1.4),
('CHN','Tibetan',false,0.40000001),
('COD','Chokwe',false,1.8),
('MOZ','Nyanja',false,3.3),
('NGA','Bura',false,1.6),
('SDN','Lotuko',false,1.5),
('TZA','Gogo',false,3.9000001),
('UGA','Rwanda',false,3.2),
('RUS','Mari',false,0.40000001),
('USA','Vietnamese',false,0.2),
('ZAF','Ndebele',false,1.5),
('IND','Punjabi',false,2.8),
('CAN','Dutch',false,0.5),
('CHN','Puyi',false,0.2),
('TZA','Ha',false,3.5),
('RUS','Udmur',false,0.30000001),
('USA','Japanese',false,0.2),
('IND','Asami',false,1.5),
('CAN','Eskimo Languages',false,0.1),
('CHN','Dong',false,0.2),
('RUS','Belorussian',false,0.30000001),
('USA','Portuguese',false,0.2);

ALTER TABLE ONLY country
    ADD CONSTRAINT country_pkey PRIMARY KEY (code);

ALTER TABLE ONLY countrylanguage
    ADD CONSTRAINT countrylanguage_pkey PRIMARY KEY (countrycode, countrylanguage);

ALTER TABLE ONLY countrylanguage
    ADD CONSTRAINT countrylanguage_countrycode_fkey FOREIGN KEY (countrycode) REFERENCES country(code);

COMMIT;
