# Columns: ZIP/Location,CDI,No. of responses,Hypocentral distance,Latitude,Longitude,Suspect?,Standard deviation,City,State[,cityid]
"Port Elizabeth::Eastern Cape::South Africa",2.7,1,780,-33.9600,25.5900,0,0.330,"Port Elizabeth","",city_2009:::104659
"Bethlehem::Free State::South Africa",2.0,1,208,-28.2200,28.3000,0,0.330,"Bethlehem","",city_2009:::104669
"Bloemfontein::Free State::South Africa",2.0,1,243,-29.1500,26.2300,0,0.330,"Bloemfontein","",city_2009:::104670
"Brandfort::Free State::South Africa",4.9,2,190,-28.7000,26.4700,0,0.320,"Brandfort","",city_2009:::104672
"Bulfontein::Free State::South Africa",3.8,2,242,-29.1400,26.2300,0,0.320,"Bulfontein","",city_2009:::104673
"Dordrecht::Free State::South Africa",3.8,1,487,-31.3800,27.0600,0,0.330,"Dordrecht","",city_2009:::104676
"Hoopstad::Free State::South Africa",3.8,1,120,-27.8200,25.9200,0,0.330,"Hoopstad","",city_2009:::104681
"Kroonstad::Free State::South Africa",3.1,2,89,-27.6600,27.2100,0,0.320,"Kroonstad","",city_2009:::104684
"Ladybrand::Free State::South Africa",4.6,1,254,-29.1900,27.4600,0,0.330,"Ladybrand","",city_2009:::104686
"Parys::Free State::South Africa",4.3,2,75,-26.9100,27.4600,0,0.320,"Parys","",city_2009:::104688
"Phuthaditjhaba::Free State::South Africa",3.1,1,268,-28.5300,28.8100,0,0.330,"Phuthaditjhaba","",city_2009:::104689
"Reitz::Free State::South Africa",2.2,1,192,-27.7900,28.4300,0,0.330,"Reitz","",city_2009:::104690
"Senekal::Free State::South Africa",2.0,1,172,-28.3200,27.6200,0,0.330,"Senekal","",city_2009:::104692
"Ventersburg::Free State::South Africa",3.4,1,126,-28.0700,27.1300,0,0.330,"Ventersburg","",city_2009:::104695
"Viljoenskroon::Free State::South Africa",5.3,2,34,-27.2100,26.9500,0,0.320,"Viljoenskroon","",city_2009:::104696
"Welkom::Free State::South Africa",3.1,1,108,-27.9700,26.7300,0,0.330,"Welkom","",city_2009:::104701
"Alberton::Gauteng::South Africa",3.3,4,159,-26.3300,28.1300,0,0.302,"Alberton","",city_2009:::104705
"Benoni::Gauteng::South Africa",3.5,8,186,-26.1500,28.3300,0,0.269,"Benoni","",city_2009:::104706
"Boksburg::Gauteng::South Africa",3.4,9,171,-26.2700,28.2300,0,0.262,"Boksburg","",city_2009:::104707
"Brakpan::Gauteng::South Africa",2.0,1,183,-26.2900,28.3700,0,0.330,"Brakpan","",city_2009:::104708
"Bronkhorstspruit::Gauteng::South Africa",2.2,1,242,-25.8000,28.7400,0,0.330,"Bronkhorstspruit","",city_2009:::104709
"Carltonville::Gauteng::South Africa",6.0,1,97,-26.3400,27.3700,0,0.330,"Carltonville","",city_2009:::104710
"Cullinan::Gauteng::South Africa",3.1,1,232,-25.6700,28.5200,0,0.330,"Cullinan","",city_2009:::104711
"Johannesburg::Gauteng::South Africa",3.6,81,159,-26.1900,28.0400,0,0.099,"Johannesburg","",city_2009:::104713
"Krugersdorp::Gauteng::South Africa",3.4,8,145,-26.0900,27.7700,0,0.269,"Krugersdorp","",city_2009:::104714
"Midrand::Gauteng::South Africa",3.4,62,179,-26.0000,28.1300,0,0.109,"Midrand","",city_2009:::104715
"Pretoria::Gauteng::South Africa",3.4,37,205,-25.7300,28.2200,0,0.144,"Pretoria","",city_2009:::104717
"Randfontein::Gauteng::South Africa",3.2,3,136,-26.1500,27.7000,0,0.311,"Randfontein","",city_2009:::104718
"Randvaal::Gauteng::South Africa",4.1,2,138,-26.5800,28.0200,0,0.320,"Randvaal","",city_2009:::104719
"Soweto::Gauteng::South Africa",4.8,1,137,-26.2800,27.8400,0,0.330,"Soweto","",city_2009:::104720
"Springs::Gauteng::South Africa",3.8,1,189,-26.2700,28.4300,0,0.330,"Springs","",city_2009:::104721
"Tembisa::Gauteng::South Africa",2.7,1,187,-25.9900,28.2200,0,0.330,"Tembisa","",city_2009:::104723
"Vanderbijlpark::Gauteng::South Africa",4.1,7,115,-26.6900,27.8200,0,0.277,"Vanderbijlpark","",city_2009:::104724
"Vereeniging::Gauteng::South Africa",3.0,3,130,-26.6500,27.9600,0,0.311,"Vereeniging","",city_2009:::104725
"Verwoerdburg::Gauteng::South Africa",3.4,28,196,-25.8300,28.2000,0,0.168,"Verwoerdburg","",city_2009:::104726
"Westonaria::Gauteng::South Africa",3.4,1,119,-26.3200,27.6500,0,0.330,"Westonaria","",city_2009:::104727
"Ballitoville::KwaZulu Natal::South Africa",3.4,4,523,-29.5400,31.2000,0,0.302,"Ballitoville","",city_2009:::104728
"Durban::KwaZulu Natal::South Africa",3.2,10,527,-29.8700,30.9900,0,0.255,"Durban","",city_2009:::104730
"Emnambithi::KwaZulu Natal::South Africa",2.0,1,348,-28.5500,29.7800,0,0.330,"Emnambithi","",city_2009:::104732
"Epumalanga::KwaZulu Natal::South Africa",2.7,1,494,-29.8200,30.6100,0,0.330,"Epumalanga","",city_2009:::104734
"Newcastle::KwaZulu Natal::South Africa",4.1,1,329,-27.7500,29.9200,0,0.330,"Newcastle","",city_2009:::104746
"Pietermaritzburg::KwaZulu Natal::South Africa",2.2,2,463,-29.6100,30.3900,0,0.320,"Pietermaritzburg","",city_2009:::104747
"Port Shepstone::KwaZulu Natal::South Africa",2.7,1,552,-30.7200,30.4600,0,0.330,"Port Shepstone","",city_2009:::104748
"Richards Bay::KwaZulu Natal::South Africa",2.0,1,566,-28.8000,32.0900,0,0.330,"Richards Bay","",city_2009:::104749
"Richmond::KwaZulu Natal::South Africa",2.6,1,473,-29.8500,30.2900,0,0.330,"Richmond","",city_2009:::104750
"Mankweng::Limpopo::South Africa",2.0,1,464,-23.9000,29.8200,0,0.330,"Mankweng","",city_2009:::104765
"Balfour::Mpumalanga::South Africa",3.1,1,191,-26.6500,28.5900,0,0.330,"Balfour","",city_2009:::104777
"Belfast::Mpumalanga::South Africa",2.0,1,362,-25.6800,30.0300,0,0.330,"Belfast","",city_2009:::104779
"Delmas::Mpumalanga::South Africa",2.5,1,218,-26.1400,28.6800,0,0.330,"Delmas","",city_2009:::104782
"Middelburg::Mpumalanga::South Africa",4.1,1,307,-25.7600,29.4700,0,0.330,"Middelburg","",city_2009:::104793
"Secunda::Mpumalanga::South Africa",2.8,2,250,-26.5500,29.1700,0,0.320,"Secunda","",city_2009:::104797
"Standerton::Mpumalanga::South Africa",2.9,3,251,-26.9400,29.2400,0,0.311,"Standerton","",city_2009:::104799
"Witrivier::Mpumalanga::South Africa",3.6,1,469,-25.3100,31.0200,0,0.330,"Witrivier","",city_2009:::104802
"Brits::North West::South Africa",4.2,3,185,-25.6300,27.7800,0,0.311,"Brits","",city_2009:::104804
"GaRankuwa::North West::South Africa",2.9,4,198,-25.6200,27.9800,0,0.302,"GaRankuwa","",city_2009:::104807
"Klerksdorp::North West::South Africa",6.9,3,15,-26.8800,26.6200,0,0.311,"Klerksdorp","",city_2009:::104808
"Koster::North West::South Africa",4.3,2,126,-25.8600,26.9000,0,0.320,"Koster","",city_2009:::104809
"Letsopa::North West::South Africa",3.1,1,73,-26.8100,25.9900,0,0.330,"Letsopa","",city_2009:::104810
"Mabopane::North West::South Africa",3.4,1,214,-25.5000,28.0800,0,0.330,"Mabopane","",city_2009:::104812
"Mmabatho::North West::South Africa",4.3,1,168,-25.8300,25.6100,0,0.330,"Mmabatho","",city_2009:::104813
"Mogwase::North West::South Africa",3.8,2,203,-25.2200,27.2600,0,0.320,"Mogwase","",city_2009:::104814
"Pampierstad::North West::South Africa",2.5,1,218,-27.7800,24.6800,0,0.330,"Pampierstad","",city_2009:::104816
"Potchefstroom::North West::South Africa",4.8,4,50,-26.7000,27.1000,0,0.302,"Potchefstroom","",city_2009:::104817
"Rustenburg::North West::South Africa",4.0,5,157,-25.6500,27.2400,0,0.293,"Rustenburg","",city_2009:::104818
"Stilfontein::North West::South Africa",5.6,1,18,-26.8400,26.7600,0,0.330,"Stilfontein","",city_2009:::104820
"Vryburg::North West::South Africa",4.6,1,196,-26.9600,24.7300,0,0.330,"Vryburg","",city_2009:::104821
"Kathu::Northern Cape::South Africa",2.7,1,370,-27.7000,23.0500,0,0.330,"Kathu","",city_2009:::104831
"Kimberley::Northern Cape::South Africa",5.0,1,272,-28.7500,24.7700,0,0.330,"Kimberley","",city_2009:::104832
"Kuruman::Northern Cape::South Africa",2.5,1,329,-27.4500,23.4200,0,0.330,"Kuruman","",city_2009:::104833
"Cape Town::Western Cape::South Africa",1.0,1,1104,-33.9300,18.4600,0,0.330,"Cape Town","",city_2009:::104843
"Gaborone::Gaborone::Botswana",4.3,3,271,-24.6500,25.9100,0,0.311,"Gaborone","",city_2009:::2998
"Mochudi::Kgatleng::Botswana",2.0,1,295,-24.3700,26.1500,0,0.330,"Mochudi","",city_2009:::3017
"Molepolole::Kweneng::Botswana",3.1,1,311,-24.4000,25.5100,0,0.330,"Molepolole","",city_2009:::3037
"Maokane::Ngwaketse::Botswana",2.0,2,300,-24.9700,24.7000,0,0.320,"Maokane","",city_2009:::3074
"Tlokweng::South East::Botswana",2.2,1,282,-24.5300,25.9700,0,0.330,"Tlokweng","",city_2009:::3121
"Mafeteng::Mafeteng::Lesotho",2.7,1,319,-29.8300,27.2500,0,0.330,"Mafeteng","",city_2009:::82875
"Maseru::Maseru::Lesotho",2.0,1,268,-29.3100,27.4900,0,0.330,"Maseru","",city_2009:::82876
"Maputo::Maputo::Mozambique",2.0,1,596,-25.9500,32.5700,0,0.330,"Maputo","",city_2009:::86609