VvebOIDC/install/sql/insert/geoip/region.sql

441 lines
14 KiB
SQL

INSERT INTO `region` VALUES
(1, 1, 'Badakhshan', 'BDS', 0),
(2, 1, 'Badghis', 'BDG', 0),
(3, 1, 'Baghlan', 'BGL', 0),
(4, 1, 'Balkh', 'BAL', 0),
(5, 1, 'Bamian', 'BAM', 0),
(6, 1, 'Farah', 'FRA', 0),
(7, 1, 'Faryab', 'FYB', 0),
(8, 1, 'Ghazni', 'GHA', 0),
(9, 1, 'Ghowr', 'GHO', 0),
(10, 1, 'Helmand', 'HEL', 0),
(11, 1, 'Herat', 'HER', 0),
(12, 1, 'Jowzjan', 'JOW', 0),
(13, 1, 'Kabul', 'KAB', 0),
(14, 1, 'Kandahar', 'KAN', 0),
(15, 1, 'Kapisa', 'KAP', 0),
(16, 1, 'Khost', 'KHO', 0),
(17, 1, 'Konar', 'KNR', 0),
(18, 1, 'Kondoz', 'KDZ', 0),
(19, 1, 'Laghman', 'LAG', 0),
(20, 1, 'Lowgar', 'LOW', 0),
(21, 1, 'Nangrahar', 'NAN', 0),
(22, 1, 'Nimruz', 'NIM', 0),
(23, 1, 'Nurestan', 'NUR', 0),
(24, 1, 'Oruzgan', 'ORU', 0),
(25, 1, 'Paktia', 'PIA', 0),
(26, 1, 'Paktika', 'PKA', 0),
(27, 1, 'Parwan', 'PAR', 0),
(28, 1, 'Samangan', 'SAM', 0),
(29, 1, 'Sar-e Pol', 'SAR', 0),
(30, 1, 'Takhar', 'TAK', 0),
(31, 1, 'Wardak', 'WAR', 0),
(32, 1, 'Zabol', 'ZAB', 0),
(33, 2, 'Berat', 'BR', 0),
(34, 2, 'Bulqize', 'BU', 0),
(35, 2, 'Delvine', 'DL', 0),
(36, 2, 'Devoll', 'DV', 0),
(37, 2, 'Diber', 'DI', 0),
(38, 2, 'Durres', 'DR', 0),
(39, 2, 'Elbasan', 'EL', 0),
(40, 2, 'Kolonje', 'ER', 0),
(41, 2, 'Fier', 'FR', 0),
(42, 2, 'Gjirokaster', 'GJ', 0),
(43, 2, 'Gramsh', 'GR', 0),
(44, 2, 'Has', 'HA', 0),
(45, 2, 'Kavaje', 'KA', 0),
(46, 2, 'Kurbin', 'KB', 0),
(47, 2, 'Kucove', 'KC', 0),
(48, 2, 'Korce', 'KO', 0),
(49, 2, 'Kruje', 'KR', 0),
(50, 2, 'Kukes', 'KU', 0),
(51, 2, 'Librazhd', 'LB', 0),
(52, 2, 'Lezhe', 'LE', 0),
(53, 2, 'Lushnje', 'LU', 0),
(54, 2, 'Malesi e Madhe', 'MM', 0),
(55, 2, 'Mallakaster', 'MK', 0),
(56, 2, 'Mat', 'MT', 0),
(57, 2, 'Mirdite', 'MR', 0),
(58, 2, 'Peqin', 'PQ', 0),
(59, 2, 'Permet', 'PR', 0),
(60, 2, 'Pogradec', 'PG', 0),
(61, 2, 'Puke', 'PU', 0),
(62, 2, 'Shkoder', 'SH', 0),
(63, 2, 'Skrapar', 'SK', 0),
(64, 2, 'Sarande', 'SR', 0),
(65, 2, 'Tepelene', 'TE', 0),
(66, 2, 'Tropoje', 'TP', 0),
(67, 2, 'Tirane', 'TR', 0),
(68, 2, 'Vlore', 'VL', 0),
(69, 3, 'Adrar', '01', 0),
(70, 3, 'Ain Defla', '44', 0),
(71, 3, 'Ain Temouchent', '46', 0),
(72, 3, 'Alger', '16', 0),
(73, 3, 'Annaba', '23', 0),
(74, 3, 'Batna', '05', 0),
(75, 3, 'Bechar', '08', 0),
(76, 3, 'Bejaia', '06', 0),
(77, 3, 'Biskra', '07', 0),
(78, 3, 'Blida', '09', 0),
(79, 3, 'Bordj Bou Arreridj', '34', 0),
(80, 3, 'Bouira', '10', 0),
(81, 3, 'Boumerdes', '35', 0),
(82, 3, 'Chlef', '02', 0),
(83, 3, 'Constantine', '26', 0),
(84, 3, 'Djelfa', '17', 0),
(85, 3, 'El Bayadh', '32', 0),
(86, 3, 'El Oued', '39', 0),
(87, 3, 'El Tarf', '36', 0),
(88, 3, 'Ghardaia', '47', 0),
(89, 3, 'Guelma', '24', 0),
(90, 3, 'Illizi', '33', 0),
(91, 3, 'Jijel', '18', 0),
(92, 3, 'Khenchela', '40', 0),
(93, 3, 'Laghouat', '03', 0),
(94, 3, 'Mascara', '29', 0),
(95, 3, 'Medea', '26', 0),
(96, 3, 'Mila', '43', 0),
(97, 3, 'Mostaganem', '27', 0),
(98, 3, 'M`Sila', '28', 0),
(99, 3, 'Naama', '45', 0),
(100, 3, 'Oran', '31', 0),
(101, 3, 'Ouargla', '30', 0),
(102, 3, 'Oum el-Bouaghi', '04', 0),
(103, 3, 'Relizane', '48', 0),
(104, 3, 'Saida', '20', 0),
(105, 3, 'Setif', '19', 0),
(106, 3, 'Sidi Bel Abbes', '22', 0),
(107, 3, 'Skikda', '21', 0),
(108, 3, 'Souk Ahras', '41', 0),
(109, 3, 'Tamanrasset', '11', 0),
(110, 3, 'Tebessa', '12', 0),
(111, 3, 'Tiaret', '14', 0),
(112, 3, 'Tindouf', '37', 0),
(113, 3, 'Tipaza', '42', 0),
(114, 3, 'Tissemsilt', '38', 0),
(115, 3, 'Tizi Ouzou', '15', 0),
(116, 3, 'Tlemcen', '13', 0),
(117, 4, 'Eastern', 'E', 0),
(118, 4, 'Manu`a', 'M', 0),
(119, 4, 'Rose Island', 'R', 0),
(120, 4, 'Swains Island', 'S', 0),
(121, 4, 'Western', 'W', 0),
(122, 5, 'Andorra la Vella', 'ALV', 0),
(123, 5, 'Canillo', 'CAN', 0),
(124, 5, 'Encamp', 'ENC', 0),
(125, 5, 'Escaldes-Engordany', 'ESE', 0),
(126, 5, 'La Massana', 'LMA', 0),
(127, 5, 'Ordino', 'ORD', 0),
(128, 5, 'Sant Julia de Loria', 'SJL', 0),
(129, 6, 'Bengo', 'BGO', 0),
(130, 6, 'Benguela', 'BGU', 0),
(131, 6, 'Bie', 'BIE', 0),
(132, 6, 'Cabinda', 'CAB', 0),
(133, 6, 'Cuando-Cubango', 'CCU', 0),
(134, 6, 'Cuanza Norte', 'CNO', 0),
(135, 6, 'Cuanza Sul', 'CUS', 0),
(136, 6, 'Cunene', 'CNN', 0),
(137, 6, 'Huambo', 'HUA', 0),
(138, 6, 'Huila', 'HUI', 0),
(139, 6, 'Luanda', 'LUA', 0),
(140, 6, 'Lunda Norte', 'LNO', 0),
(141, 6, 'Lunda Sul', 'LSU', 0),
(142, 6, 'Malange', 'MAL', 0),
(143, 6, 'Moxico', 'MOX', 0),
(144, 6, 'Namibe', 'NAM', 0),
(145, 6, 'Uige', 'UIG', 0),
(146, 6, 'Zaire', 'ZAI', 0),
(147, 9, 'Saint George', 'ASG', 0),
(148, 9, 'Saint John', 'ASJ', 0),
(149, 9, 'Saint Mary', 'ASM', 0),
(150, 9, 'Saint Paul', 'ASL', 0),
(151, 9, 'Saint Peter', 'ASR', 0),
(152, 9, 'Saint Philip', 'ASH', 0),
(153, 9, 'Barbuda', 'BAR', 0),
(154, 9, 'Redonda', 'RED', 0),
(155, 10, 'Antartida e Islas del Atlantico', 'AN', 0),
(156, 10, 'Buenos Aires', 'B', 0),
(157, 10, 'Catamarca', 'K', 0),
(158, 10, 'Chaco', 'H', 0),
(159, 10, 'Chubut', 'U', 0),
(160, 10, 'Cordoba', 'X', 0),
(161, 10, 'Corrientes', 'W', 0),
(162, 10, 'Ciudad Autónoma de Buenos Aires', 'C', 0),
(163, 10, 'Entre Rios', 'E', 0),
(164, 10, 'Formosa', 'P', 0),
(165, 10, 'Jujuy', 'Y', 0),
(166, 10, 'La Pampa', 'L', 0),
(167, 10, 'La Rioja', 'F', 0),
(168, 10, 'Mendoza', 'M', 0),
(169, 10, 'Misiones', 'N', 0),
(170, 10, 'Neuquen', 'Q', 0),
(171, 10, 'Rio Negro', 'R', 0),
(172, 10, 'Salta', 'A', 0),
(173, 10, 'San Juan', 'J', 0),
(174, 10, 'San Luis', 'D', 0),
(175, 10, 'Santa Cruz', 'Z', 0),
(176, 10, 'Santa Fe', 'S', 0),
(177, 10, 'Santiago del Estero', 'G', 0),
(178, 10, 'Tierra del Fuego', 'V', 0),
(179, 10, 'Tucuman', 'T', 0),
(180, 11, 'Aragatsotn', 'AGT', 0),
(181, 11, 'Ararat', 'ARR', 0),
(182, 11, 'Armavir', 'ARM', 0),
(183, 11, 'Geghark`unik`', 'GEG', 0),
(184, 11, 'Kotayk`', 'KOT', 0),
(185, 11, 'Lorri', 'LOR', 0),
(186, 11, 'Shirak', 'SHI', 0),
(187, 11, 'Syunik`', 'SYU', 0),
(188, 11, 'Tavush', 'TAV', 0),
(189, 11, 'Vayots` Dzor', 'VAY', 0),
(190, 11, 'Yerevan', 'YER', 0),
(191, 13, 'Australian Capital Territory', 'ACT', 0),
(192, 13, 'New South Wales', 'NSW', 0),
(193, 13, 'Northern Territory', 'NT', 0),
(194, 13, 'Queensland', 'QLD', 0),
(195, 13, 'South Australia', 'SA', 0),
(196, 13, 'Tasmania', 'TAS', 0),
(197, 13, 'Victoria', 'VIC', 0),
(198, 13, 'Western Australia', 'WA', 0),
(199, 14, 'Burgenland', '1', 0),
(200, 14, 'Kärnten', '2', 0),
(201, 14, 'Niederösterreich', '3', 0),
(202, 14, 'Oberösterreich', '4', 0),
(203, 14, 'Salzburg', '5', 0),
(204, 14, 'Steiermark', '6', 0),
(205, 14, 'Tirol', '7', 0),
(206, 14, 'Vorarlberg', '8', 0),
(207, 14, 'Wien', '9', 0),
(208, 15, 'Ali Bayramli', 'AB', 0),
(209, 15, 'Abseron', 'ABS', 0),
(210, 15, 'AgcabAdi', 'AGC', 0),
(211, 15, 'Agdam', 'AGM', 0),
(212, 15, 'Agdas', 'AGS', 0),
(213, 15, 'Agstafa', 'AGA', 0),
(214, 15, 'Agsu', 'AGU', 0),
(215, 15, 'Astara', 'AST', 0),
(216, 15, 'Baki', 'BA', 0),
(217, 15, 'BabAk', 'BAB', 0),
(218, 15, 'BalakAn', 'BAL', 0),
(219, 15, 'BArdA', 'BAR', 0),
(220, 15, 'Beylaqan', 'BEY', 0),
(221, 15, 'Bilasuvar', 'BIL', 0),
(222, 15, 'Cabrayil', 'CAB', 0),
(223, 15, 'Calilabab', 'CAL', 0),
(224, 15, 'Culfa', 'CUL', 0),
(225, 15, 'Daskasan', 'DAS', 0),
(226, 15, 'Davaci', 'DAV', 0),
(227, 15, 'Fuzuli', 'FUZ', 0),
(228, 15, 'Ganca', 'GA', 0),
(229, 15, 'Gadabay', 'GAD', 0),
(230, 15, 'Goranboy', 'GOR', 0),
(231, 15, 'Goycay', 'GOY', 0),
(232, 15, 'Haciqabul', 'HAC', 0),
(233, 15, 'Imisli', 'IMI', 0),
(234, 15, 'Ismayilli', 'ISM', 0),
(235, 15, 'Kalbacar', 'KAL', 0),
(236, 15, 'Kurdamir', 'KUR', 0),
(237, 15, 'Lankaran', 'LA', 0),
(238, 15, 'Lacin', 'LAC', 0),
(239, 15, 'Lankaran', 'LAN', 0),
(240, 15, 'Lerik', 'LER', 0),
(241, 15, 'Masalli', 'MAS', 0),
(242, 15, 'Mingacevir', 'MI', 0),
(243, 15, 'Naftalan', 'NA', 0),
(244, 15, 'Neftcala', 'NEF', 0),
(245, 15, 'Oguz', 'OGU', 0),
(246, 15, 'Ordubad', 'ORD', 0),
(247, 15, 'Qabala', 'QAB', 0),
(248, 15, 'Qax', 'QAX', 0),
(249, 15, 'Qazax', 'QAZ', 0),
(250, 15, 'Qobustan', 'QOB', 0),
(251, 15, 'Quba', 'QBA', 0),
(252, 15, 'Qubadli', 'QBI', 0),
(253, 15, 'Qusar', 'QUS', 0),
(254, 15, 'Saki', 'SA', 0),
(255, 15, 'Saatli', 'SAT', 0),
(256, 15, 'Sabirabad', 'SAB', 0),
(257, 15, 'Sadarak', 'SAD', 0),
(258, 15, 'Sahbuz', 'SAH', 0),
(259, 15, 'Saki', 'SAK', 0),
(260, 15, 'Salyan', 'SAL', 0),
(261, 15, 'Sumqayit', 'SM', 0),
(262, 15, 'Samaxi', 'SMI', 0),
(263, 15, 'Samkir', 'SKR', 0),
(264, 15, 'Samux', 'SMX', 0),
(265, 15, 'Sarur', 'SAR', 0),
(266, 15, 'Siyazan', 'SIY', 0),
(267, 15, 'Susa', 'SS', 0),
(268, 15, 'Susa', 'SUS', 0),
(269, 15, 'Tartar', 'TAR', 0),
(270, 15, 'Tovuz', 'TOV', 0),
(271, 15, 'Ucar', 'UCA', 0),
(272, 15, 'Xankandi', 'XA', 0),
(273, 15, 'Xacmaz', 'XAC', 0),
(274, 15, 'Xanlar', 'XAN', 0),
(275, 15, 'Xizi', 'XIZ', 0),
(276, 15, 'Xocali', 'XCI', 0),
(277, 15, 'Xocavand', 'XVD', 0),
(278, 15, 'Yardimli', 'YAR', 0),
(279, 15, 'Yevlax', 'YEV', 0),
(280, 15, 'Zangilan', 'ZAN', 0),
(281, 15, 'Zaqatala', 'ZAQ', 0),
(282, 15, 'Zardab', 'ZAR', 0),
(283, 15, 'Naxcivan', 'NX', 0),
(284, 16, 'Acklins', 'ACK', 0),
(285, 16, 'Berry Islands', 'BER', 0),
(286, 16, 'Bimini', 'BIM', 0),
(287, 16, 'Black Point', 'BLK', 0),
(288, 16, 'Cat Island', 'CAT', 0),
(289, 16, 'Central Abaco', 'CAB', 0),
(290, 16, 'Central Andros', 'CAN', 0),
(291, 16, 'Central Eleuthera', 'CEL', 0),
(292, 16, 'City of Freeport', 'FRE', 0),
(293, 16, 'Crooked Island', 'CRO', 0),
(294, 16, 'East Grand Bahama', 'EGB', 0),
(295, 16, 'Exuma', 'EXU', 0),
(296, 16, 'Grand Cay', 'GRD', 0),
(297, 16, 'Harbour Island', 'HAR', 0),
(298, 16, 'Hope Town', 'HOP', 0),
(299, 16, 'Inagua', 'INA', 0),
(300, 16, 'Long Island', 'LNG', 0),
(301, 16, 'Mangrove Cay', 'MAN', 0),
(302, 16, 'Mayaguana', 'MAY', 0),
(303, 16, 'Moore`s Island', 'MOO', 0),
(304, 16, 'North Abaco', 'NAB', 0),
(305, 16, 'North Andros', 'NAN', 0),
(306, 16, 'North Eleuthera', 'NEL', 0),
(307, 16, 'Ragged Island', 'RAG', 0),
(308, 16, 'Rum Cay', 'RUM', 0),
(309, 16, 'San Salvador', 'SAL', 0),
(310, 16, 'South Abaco', 'SAB', 0),
(311, 16, 'South Andros', 'SAN', 0),
(312, 16, 'South Eleuthera', 'SEL', 0),
(313, 16, 'Spanish Wells', 'SWE', 0),
(314, 16, 'West Grand Bahama', 'WGB', 0),
(315, 17, 'Capital', 'CAP', 0),
(316, 17, 'Central', 'CEN', 0),
(317, 17, 'Muharraq', 'MUH', 0),
(318, 17, 'Northern', 'NOR', 0),
(319, 17, 'Southern', 'SOU', 0),
(320, 18, 'Barisal', 'BAR', 0),
(321, 18, 'Chittagong', 'CHI', 0),
(322, 18, 'Dhaka', 'DHA', 0),
(323, 18, 'Khulna', 'KHU', 0),
(324, 18, 'Rajshahi', 'RAJ', 0),
(325, 18, 'Sylhet', 'SYL', 0),
(326, 19, 'Christ Church', 'CC', 0),
(327, 19, 'Saint Andrew', 'AND', 0),
(328, 19, 'Saint George', 'GEO', 0),
(329, 19, 'Saint James', 'JAM', 0),
(330, 19, 'Saint John', 'JOH', 0),
(331, 19, 'Saint Joseph', 'JOS', 0),
(332, 19, 'Saint Lucy', 'LUC', 0),
(333, 19, 'Saint Michael', 'MIC', 0),
(334, 19, 'Saint Peter', 'PET', 0),
(335, 19, 'Saint Philip', 'PHI', 0),
(336, 19, 'Saint Thomas', 'THO', 0),
(337, 20, 'Brestskaya (Brest)', 'BR', 0),
(338, 20, 'Homyel`skaya (Homyel`)', 'HO', 0),
(339, 20, 'Horad Minsk', 'HM', 0),
(340, 20, 'Hrodzyenskaya (Hrodna)', 'HR', 0),
(341, 20, 'Mahilyowskaya (Mahilyow)', 'MA', 0),
(342, 20, 'Minskaya', 'MI', 0),
(343, 20, 'Vitsyebskaya (Vitsyebsk)', 'VI', 0),
(344, 21, 'Antwerpen', 'VAN', 0),
(345, 21, 'Brabant Wallon', 'WBR', 0),
(346, 21, 'Hainaut', 'WHT', 0),
(347, 21, 'Liège', 'WLG', 0),
(348, 21, 'Limburg', 'VLI', 0),
(349, 21, 'Luxembourg', 'WLX', 0),
(350, 21, 'Namur', 'WNA', 0),
(351, 21, 'Oost-Vlaanderen', 'VOV', 0),
(352, 21, 'Vlaams Brabant', 'VBR', 0),
(353, 21, 'West-Vlaanderen', 'VWV', 0),
(354, 22, 'Belize', 'BZ', 0),
(355, 22, 'Cayo', 'CY', 0),
(356, 22, 'Corozal', 'CR', 0),
(357, 22, 'Orange Walk', 'OW', 0),
(358, 22, 'Stann Creek', 'SC', 0),
(359, 22, 'Toledo', 'TO', 0),
(360, 23, 'Alibori', 'AL', 0),
(361, 23, 'Atakora', 'AK', 0),
(362, 23, 'Atlantique', 'AQ', 0),
(363, 23, 'Borgou', 'BO', 0),
(364, 23, 'Collines', 'CO', 0),
(365, 23, 'Donga', 'DO', 0),
(366, 23, 'Kouffo', 'KO', 0),
(367, 23, 'Littoral', 'LI', 0),
(368, 23, 'Mono', 'MO', 0),
(369, 23, 'Oueme', 'OU', 0),
(370, 23, 'Plateau', 'PL', 0),
(371, 23, 'Zou', 'ZO', 0),
(372, 24, 'Devonshire', 'DS', 0),
(373, 24, 'Hamilton City', 'HC', 0),
(374, 24, 'Hamilton', 'HA', 0),
(375, 24, 'Paget', 'PG', 0),
(376, 24, 'Pembroke', 'PB', 0),
(377, 24, 'Saint George City', 'GC', 0),
(378, 24, 'Saint George`s', 'SG', 0),
(379, 24, 'Sandys', 'SA', 0),
(380, 24, 'Smith`s', 'SM', 0),
(381, 24, 'Southampton', 'SH', 0),
(382, 24, 'Warwick', 'WA', 0),
(383, 25, 'Bumthang', 'BUM', 0),
(384, 25, 'Chukha', 'CHU', 0),
(385, 25, 'Dagana', 'DAG', 0),
(386, 25, 'Gasa', 'GAS', 0),
(387, 25, 'Haa', 'HAA', 0),
(388, 25, 'Lhuntse', 'LHU', 0),
(389, 25, 'Mongar', 'MON', 0),
(390, 25, 'Paro', 'PAR', 0),
(391, 25, 'Pemagatshel', 'PEM', 0),
(392, 25, 'Punakha', 'PUN', 0),
(393, 25, 'Samdrup Jongkhar', 'SJO', 0),
(394, 25, 'Samtse', 'SAT', 0),
(395, 25, 'Sarpang', 'SAR', 0),
(396, 25, 'Thimphu', 'THI', 0),
(397, 25, 'Trashigang', 'TRG', 0),
(398, 25, 'Trashiyangste', 'TRY', 0),
(399, 25, 'Trongsa', 'TRO', 0),
(400, 25, 'Tsirang', 'TSI', 0),
(401, 25, 'Wangdue Phodrang', 'WPH', 0),
(402, 25, 'Zhemgang', 'ZHE', 0),
(403, 26, 'Beni', 'BEN', 0),
(404, 26, 'Chuquisaca', 'CHU', 0),
(405, 26, 'Cochabamba', 'COC', 0),
(406, 26, 'La Paz', 'LPZ', 0),
(407, 26, 'Oruro', 'ORU', 0),
(408, 26, 'Pando', 'PAN', 0),
(409, 26, 'Potosi', 'POT', 0),
(410, 26, 'Santa Cruz', 'SCZ', 0),
(411, 26, 'Tarija', 'TAR', 0),
(412, 27, 'Brcko district', 'BRO', 0),
(413, 27, 'Unsko-Sanski Kanton', 'FUS', 0),
(414, 27, 'Posavski Kanton', 'FPO', 0),
(415, 27, 'Tuzlanski Kanton', 'FTU', 0),
(416, 27, 'Zenicko-Dobojski Kanton', 'FZE', 0),
(417, 27, 'Bosanskopodrinjski Kanton', 'FBP', 0),
(418, 27, 'Srednjebosanski Kanton', 'FSB', 0),
(419, 27, 'Hercegovacko-neretvanski Kanton', 'FHN', 0),
(420, 27, 'Zapadnohercegovacka Zupanija', 'FZH', 0),
(421, 27, 'Kanton Sarajevo', 'FSA', 0),
(422, 27, 'Zapadnobosanska', 'FZA', 0),
(423, 27, 'Banja Luka', 'SBL', 0),
(424, 27, 'Doboj', 'SDO', 0),
(425, 27, 'Bijeljina', 'SBI', 0),
(426, 27, 'Vlasenica', 'SVL', 0),
(427, 27, 'Sarajevo-Romanija or Sokolac', 'SSR', 0),
(428, 27, 'Foca', 'SFO', 0),
(429, 27, 'Trebinje', 'STR', 0),
(430, 28, 'Central', 'CE', 0),
(431, 28, 'Ghanzi', 'GH', 0),
(432, 28, 'Kgalagadi', 'KD', 0),
(433, 28, 'Kgatleng', 'KT', 0),
(434, 28, 'Kweneng', 'KW', 0),
(435, 28, 'Ngamiland', 'NG', 0),
(436, 28, 'North East', 'NE', 0),
(437, 28, 'North West', 'NW', 0),
(438, 28, 'South East', 'SE', 0),
(439, 28, 'Southern', 'SO', 0);