text: USE data_extracts;
  
  DROP PROCEDURE IF EXISTS populateLangSnomeds;
  
  DELIMITER //
  
  CREATE PROCEDURE populateLangSnomeds()
  
  BEGIN
  
  INSERT INTO snomed_codes (GROUP_ID, SNOMED_ID, DESCRIPTION)
  VALUES
  (6,698651000,'Main spoken language Abkhazian (finding)'),
  (6,698652007,'Main spoken language Afar (finding)'),
  (6,698653002,'Main spoken language Afrikaans (finding)'),
  (6,408525000,'Main spoken language Akan (finding)'),
  (6,407648002,'Main spoken language Albanian (finding)'),
  (6,408507007,'Main spoken language Amharic (finding)'),
  (6,315566006,'Main spoken language Arabic (finding)'),
  (6,809341000000106,'Main spoken language Aragonese (finding)'),
  (6,698885002,'Main spoken language Armenian (finding)'),
  (6,698886001,'Main spoken language Assamese (finding)'),
  (6,970441000000105,'Main spoken language Avaric (finding)'),
  (6,970451000000108,'Main spoken language Avestan (finding)'),
  (6,698887005,'Main spoken language Aymara (finding)'),
  (6,698888000,'Main spoken language Azerbaijani (finding)'),
  (6,970461000000106,'Main spoken language Bambara (finding)'),
  (6,609092003,'Main spoken language Bamun (finding)'),
  (6,698889008,'Main spoken language Bashkir (finding)'),
  (6,698654008,'Main spoken language Basque (finding)'),
  (6,698655009,'Main spoken language Belarusian (finding)'),
  (6,315567002,'Main spoken language Bengali (finding)'),
  (6,698656005,'Main spoken language Bihari (finding)'),
  (6,698890004,'Main spoken language Bislama (finding)'),
  (6,970471000000104,'Main spoken language Bosnian (finding)'),
  (6,408513003,'Main spoken language Brawa (finding)'),
  (6,698657001,'Main spoken language Breton (finding)'),
  (6,699945003,'Main spoken language Bulgarian (finding)'),
  (6,698891000,'Main spoken language Burmese (finding)'),
  (6,315568007,'Main spoken language Cantonese (finding)'),
  (6,698892007,'Main spoken language Catalan (finding)'),
  (6,698893002,'Main spoken language Central Khmer (finding)'),
  (6,970481000000102,'Main spoken language Chamorro (finding)'),
  (6,970491000000100,'Main spoken language Chechen (finding)'),
  (6,970501000000106,'Main spoken language Chinese (finding)'),
  (6,698935005,'Main spoken language Chuang (finding)'),
  (6,970511000000108,'Main spoken language Church Slavic (finding)'),
  (6,970521000000102,'Main spoken language Chuvash (finding)'),
  (6,970531000000100,'Main spoken language Cornish (finding)'),
  (6,698658006,'Main spoken language Corsican (finding)'),
  (6,970541000000109,'Main spoken language Cree (finding)'),
  (6,407650005,'Main spoken language Croatian (finding)'),
  (6,315569004,'Main spoken language Czech (finding)'),
  (6,698894008,'Main spoken language Danish (finding)'),
  (6,609093008,'Main spoken language Dari (finding)'),
  (6,970551000000107,'Main spoken language Dhivehi (finding)'),
  (6,408528003,'Main spoken language Dutch (finding)'),
  (6,315570003,'Main spoken language English (finding)'),
  (6,698896005,'Main spoken language Esperanto (finding)'),
  (6,698659003,'Main spoken language Estonian (finding)'),
  (6,408515005,'Main spoken language Ethiopian (finding)'),
  (6,970561000000105,'Main spoken language Ewe (finding)'),
  (6,698660008,'Main spoken language Faroese (finding)'),
  (6,395108007,'Main spoken language Farsi (finding)'),
  (6,698897001,'Main spoken language Fijian (finding)'),
  (6,503511000000100,'Main spoken language Filipino (finding)'),
  (6,414640006,'Main spoken language Finnish (finding)'),
  (6,408520005,'Main spoken language Flemish (finding)'),
  (6,315571004,'Main spoken language French (finding)'),
  (6,408521009,'Main spoken language French Cr�ole (finding)'),
  (6,698661007,'Main spoken language Frisian (finding)'),
  (6,729051000000103,'Main spoken language Fulani (finding)'),
  (6,408522002,'Main spoken language Gaelic (finding)'),
  (6,698662000,'Main spoken language Galician (finding)'),
  (6,698898006,'Main spoken language Georgian (finding)'),
  (6,407643006,'Main spoken language German (finding)'),
  (6,407652002,'Main spoken language Greek (finding)'),
  (6,698899003,'Main spoken language Guarani (finding)'),
  (6,315572006,'Main spoken language Gujerati (finding)'),
  (6,970601000000105,'Main spoken language Haitian (finding)'),
  (6,408523007,'Main spoken language Hakka (finding)'),
  (6,315574007,'Main spoken language Hausa (finding)'),
  (6,408524001,'Main spoken language Hebrew (finding)'),
  (6,970611000000107,'Main spoken language Herero (finding)'),
  (6,315575008,'Main spoken language Hindi (finding)'),
  (6,511841000000102,'Main spoken language Hindko (finding)'),
  (6,970621000000101,'Main spoken language Hiri Motu (finding)'),
  (6,698900008,'Main spoken language Hungarian (finding)'),
  (6,315576009,'Main spoken language Iba (finding)'),
  (6,698663005,'Main spoken language Icelandic (finding)'),
  (6,970631000000104,'Main spoken language Ido (finding)'),
  (6,408514009,'Main spoken language Igbo (finding)'),
  (6,698901007,'Main spoken language Indonesian (finding)'),
  (6,698664004,'Main spoken language Interlingua (finding)'),
  (6,698665003,'Main spoken language Inuktitut (finding)'),
  (6,698666002,'Main spoken language Inupiaq (finding)'),
  (6,698667006,'Main spoken language Irish (finding)'),
  (6,407642001,'Main spoken language Italian (finding)'),
  (6,407654001,'Main spoken language Japanese (finding)'),
  (6,698903005,'Main spoken language Javanese (finding)'),
  (6,698895009,'Main spoken language Jonkha (finding)'),
  (6,698904004,'Main spoken language Kalaallisut (finding)'),
  (6,698905003,'Main spoken language Kanarese (finding)'),
  (6,970641000000108,'Main spoken language Kanuri (finding)'),
  (6,698906002,'Main spoken language Kashmiri (finding)'),
  (6,698668001,'Main spoken language Kazakh (finding)'),
  (6,729061000000100,'Main spoken language Kikuyu (finding)'),
  (6,698908001,'Main spoken language Kirgiz (finding)'),
  (6,970651000000106,'Main spoken language Komi (finding)'),
  (6,970661000000109,'Main spoken language Kongo (finding)'),
  (6,609094002,'Main spoken language Konkani (finding)'),
  (6,407655000,'Main spoken language Korean (finding)'),
  (6,970681000000100,'Main spoken language Kuanyama (finding)'),
  (6,395109004,'Main spoken language Kurdish (finding)'),
  (6,315577000,'Main spoken language Kutchi (finding)'),
  (6,698669009,'Main spoken language Lao (finding)'),
  (6,970691000000103,'Main spoken language Latin (finding)'),
  (6,698909009,'Main spoken language Latvian (finding)'),
  (6,970701000000103,'Main spoken language Limburgan (finding)'),
  (6,408526004,'Main spoken language Lingala (finding)'),
  (6,407656004,'Main spoken language Lithuanian (finding)'),
  (6,970711000000101,'Main spoken language Luba-Katanga (finding)'),
  (6,408527008,'Main spoken language Luganda (finding)'),
  (6,970721000000107,'Main spoken language Luxembourgish (finding)'),
  (6,698670005,'Main spoken language Macedonian (finding)'),
  (6,698671009,'Main spoken language Malagasy (finding)'),
  (6,698672002,'Main spoken language Malay (finding)'),
  (6,408529006,'Main spoken language Malayalam (finding)'),
  (6,698910004,'Main spoken language Maltese (finding)'),
  (6,315578005,'Main spoken language Mandarin (finding)'),
  (6,970741000000100,'Main spoken language Manx (finding)'),
  (6,698673007,'Main spoken language Maori (finding)'),
  (6,698674001,'Main spoken language Marathi (finding)'),
  (6,970751000000102,'Main spoken language Marshallese (finding)'),
  (6,698911000,'Main spoken language Moldavian (finding)'),
  (6,698675000,'Main spoken language Mongolian (finding)'),
  (6,698912007,'Main spoken language Nauruan (finding)'),
  (6,970771000000106,'Main spoken language Navajo (finding)'),
  (6,698913002,'Main spoken language Ndebele (finding)'),
  (6,970781000000108,'Main spoken language Ndonga (finding)'),
  (6,698676004,'Main spoken language Nepali (finding)'),
  (6,970801000000109,'Main spoken language Northern Ndebele (finding)'),
  (6,970811000000106,'Main spoken language Northern Sami (finding)'),
  (6,408530001,'Main spoken language Norwegian (finding)'),
  (6,970821000000100,'Main spoken language Norwegian Bokm�l (finding)'),
  (6,970831000000103,'Main spoken language Norwegian Nynorsk (finding)'),
  (6,970961000000102,'Main spoken language Nuosu (finding)'),
  (6,729041000000101,'Main spoken language Nyanja (finding)'),
  (6,698902000,'Main spoken language Occidental (finding)'),
  (6,698914008,'Main spoken language Occitan (finding)'),
  (6,970851000000105,'Main spoken language Ojibwa (finding)'),
  (6,698915009,'Main spoken language Oriya (finding)'),
  (6,698916005,'Main spoken language Oromo (finding)'),
  (6,970871000000101,'Main spoken language Ossetian (finding)'),
  (6,970881000000104,'Main spoken language Pali (finding)'),
  (6,408531002,'Main spoken language Pashto (finding)'),
  (6,408534005,'Main spoken language Patois (finding)'),
  (6,315579002,'Main spoken language Polish (finding)'),
  (6,315580004,'Main spoken language Portuguese (finding)'),
  (6,315581000,'Main spoken language Punjabi (finding)'),
  (6,970911000000104,'Main spoken language Pushto (finding)'),
  (6,698677008,'Main spoken language Quechua (finding)'),
  (6,698678003,'Main spoken language Romanian (finding)'),
  (6,698917001,'Main spoken language Romansh (finding)'),
  (6,718512007,'Main spoken language Romany (finding)'),
  (6,698907006,'Main spoken language Ruanda (finding)'),
  (6,698679006,'Main spoken language Rundi (finding)'),
  (6,315582007,'Main spoken language Russian (finding)'),
  (6,698680009,'Main spoken language Samoan (finding)'),
  (6,698918006,'Main spoken language Sango (finding)'),
  (6,970921000000105,'Main spoken language Sanskrit (finding)'),
  (6,970931000000107,'Main spoken language Sardinian (finding)'),
  (6,970941000000103,'Main spoken language Scottish Gaelic (finding)'),
  (6,408535006,'Main spoken language Serbian (finding)'),
  (6,395110009,'Main spoken language Shona (finding)'),
  (6,698919003,'Main spoken language Sindhi (finding)'),
  (6,408518007,'Main spoken language Sinhala (finding)'),
  (6,698920009,'Main spoken language Slovak (finding)'),
  (6,698921008,'Main spoken language Slovenian (finding)'),
  (6,315583002,'Main spoken language Somali (finding)'),
  (6,970971000000109,'Main spoken language South Ndebele (finding)'),
  (6,698922001,'Main spoken language Southern Sotho (finding)'),
  (6,315584008,'Main spoken language Spanish (finding)'),
  (6,698681008,'Main spoken language Sundanese (finding)'),
  (6,315585009,'Main spoken language Swahili (finding)'),
  (6,698923006,'Main spoken language Swazi (finding)'),
  (6,408516006,'Main spoken language Swedish (finding)'),
  (6,315586005,'Main spoken language Sylheti (finding)'),
  (6,408517002,'Main spoken language Tagalog (finding)'),
  (6,970991000000108,'Main spoken language Tahitian (finding)'),
  (6,698682001,'Main spoken language Tajik (finding)'),
  (6,315587001,'Main spoken language Tamil (finding)'),
  (6,698924000,'Main spoken language Tatar (finding)'),
  (6,698925004,'Main spoken language Telugu (finding)'),
  (6,609095001,'Main spoken language Tetum (finding)'),
  (6,408519004,'Main spoken language Thai (finding)'),
  (6,698926003,'Main spoken language Tibetan (finding)'),
  (6,408533004,'Main spoken language Tigrinya (finding)'),
  (6,698927007,'Main spoken language Tongan (finding)'),
  (6,698683006,'Main spoken language Tsonga (finding)'),
  (6,698684000,'Main spoken language Tswana (finding)'),
  (6,407657008,'Main spoken language Turkish (finding)'),
  (6,698928002,'Main spoken language Turkmen (finding)'),
  (6,698685004,'Main spoken language Twi (finding)'),
  (6,698929005,'Main spoken language Uigur (finding)'),
  (6,407659006,'Main spoken language Ukrainian (finding)'),
  (6,315588006,'Main spoken language Urdu (finding)'),
  (6,698930000,'Main spoken language Uzbek (finding)'),
  (6,971011000000109,'Main spoken language Venda (finding)'),
  (6,407661002,'Main spoken language Vietnamese (finding)'),
  (6,971021000000103,'Main spoken language Volap�k (finding)'),
  (6,971031000000101,'Main spoken language Walloon (finding)'),
  (6,408532009,'Main spoken language Welsh (finding)'),
  (6,971041000000105,'Main spoken language Western Frisian (finding)'),
  (6,698932008,'Main spoken language Wolof (finding)'),
  (6,698933003,'Main spoken language Xhosa (finding)'),
  (6,698934009,'Main spoken language Yiddish (finding)'),
  (6,315589003,'Main spoken language Yoruba (finding)'),
  (6,698936006,'Main spoken language Zulu (finding)'),
  (6,520471000000105,'Preferred method of communication: British Sign Language (finding)'),
  (6,520421000000106,'Preferred method of communication: Makaton (finding)'),
  (6,415803005,'Uses British sign language (finding)'),
  (6,415805003,'Uses Makaton sign language (finding)'),
  (6,404903008,'Uses sign language (finding)'),
  (6,134441005,'Using British sign language, function (observable entity)'),
  (6,408577006,'Using Makaton sign language (observable entity)');
  
  END//
  DELIMITER ;
  