CiviCRM South Africa District and Municipality as County field values

insert_civicrm_county.sql

INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5139', 'Frances Baard District');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5139', 'Dikgatlong Local');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5139', 'Magareng Local');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5139', 'Phokwane Local');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5139', 'Sol Plaatje Local');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5139', 'John Taolo Gaetsewe District');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5139', 'Ga-Segonyana Local');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5139', 'Gamagara Local');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5139', 'Joe Morolong Local');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5139', 'Namakwa District');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5139', 'Hantam Local');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5139', 'Kamiesberg Local');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5139', 'Karoo Hoogland Local');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5139', 'Khai-Ma Local');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5139', 'Nama Khoi Local');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5139', 'Richtersveld Local');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5139', 'Pixley Ka Seme District');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5139', 'Emthanjeni Local');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5139', 'Kareeberg Local');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5139', 'Renosterberg Local');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5139', 'Siyancuma Local');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5139', 'Siyathemba Local');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5139', 'Thembelihle Local');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5139', 'Ubuntu Local');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5139', 'Umsobomvu Local');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5139', 'ZF Mgcawu District');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5139', '!Kheis Local');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5139', 'Dawid Kruiper Local');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5139', 'Kai !Garib Local');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5139', 'Kgatelopele Local');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5139', 'Tsantsabane Local');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5141', 'City of Cape Town Metropolitan');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5141', 'Cape Winelands District');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5141', 'Breede Valley Local');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5141', 'Drakenstein Local');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5141', 'Langeberg Local');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5141', 'Stellenbosch Local');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5141', 'Witzenberg Local');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5141', 'Central Karoo District');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5141', 'Beaufort West Local');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5141', 'Laingsburg Local');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5141', 'Prince Albert Local');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5141', 'Garden Route District');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5141', 'Bitou Local');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5141', 'George Local');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5141', 'Hessequa Local');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5141', 'Kannaland Local');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5141', 'Knysna Local');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5141', 'Mossel Bay Local');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5141', 'Oudtshoorn Local');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5141', 'Overberg District');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5141', 'Cape Agulhas Local');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5141', 'Overstrand Local');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5141', 'Swellendam Local');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5141', 'Theewaterskloof Local');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5141', 'West Coast District');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5141', 'Bergrivier Local');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5141', 'Cederberg Local');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5141', 'Matzikama Local');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5141', 'Saldanha Bay Local');
INSERT INTO `civicrm_county` (`state_province_id`, `name`) VALUES ('5141', 'Swartland Local');

Currently only populates Northern and Western Cape.

To add the additional district and municipal data the following may be useful as per version 5.23.4

1196 South Africa country_id

SELECT id, name FROM `civicrm_state_province` WHERE country_id = 1196

5134 Eastern Cape
5135 Free State
5136 Gauteng
5137 Kwazulu-Natal
5138 Mpumalanga
5139 Northern Cape
5140 Limpopo
5141 Western Cape
9000 North West