Jaco du Plessis

Who Gets The Most Dough From South Africa's Lotto?

lotto sql

So one Sunday evening I found a dataset on the internet that contains all grants made by the SA Lotto between 2002 and 2016. I cleaned it up and imported to SQLite.


Top 30 organisation who got most.

select name, sum(amount) as total, location from lotto group by name order by total desc limit 30;

name                                                  total        location  
----------------------------------------------------  -----------  -------------
SA SPORTS CONFEDERATION & OLYMPIC COMMITTEE (SASCOC)  657 967 722  GAUTENG   
2010 FIFA WORLD CUP ORGANISING COMMITTEE SA           199 524 380  GAUTENG   
CANCER ASSOCIATION OF SOUTH AFRICA (CANSA)            144 071 533  GAUTENG   
BADISA                                                140 371 676  WESTERN CAPE
SPORTS TRUST                                          134 090 331  GAUTENG   
NICRO                                                 105 623 595  WESTERN CAPE
AFRICAN CONSERVATION TRUST                            87 716 249   KWAZULU NATAL
HEALTH SYSTEMS TRUST                                  85 281 528   KWAZULU NATAL
NATIONAL ARTS FESTIVAL GRAHAMSTOWN                    68 672 297   EASTERN CAPE
WEST COAST FOSSIL PARK TRUST                          67 000 000   WESTERN CAPE
JOHANNESBURG PHILHARMONIC ORCHESTRA                   66 643 855   GAUTENG   
AFRICA RESOURCES TRUST                                65 789 140   LIMPOPO   
SWIMMING SOUTH AFRICA                                 65 178 927   GAUTENG   
NATIONAL HERITAGE COUNCIL                             64 472 793   GAUTENG   
LULAMISA COMMUNITY DEVELOPMENT ORGINISATION           64 000 000   GAUTENG   
LIMPOPO ACADEMY OF SPORT                              62 716 240   LIMPOPO   
MARKET THEATRE FOUNDATION                             62 234 839   GAUTENG   
FREEDOM PARK TRUST                                    60 494 000   GAUTENG   
SA FOOTBALL ASSOCIATION                               58 137 383   GAUTENG   
2 KONANI PFUNZO LEARNING CENTRE                       55 463 735   LIMPOPO   
CAPE TOWN MINSTREL CARNIVAL ASSOCIATION               54 893 058   WESTERN CAPE
ATHLETICS SOUTH AFRICA                                53 366 011   GAUTENG   
UNIVERSITY OF KWAZULU NATAL                           49 889 287   KWAZULU NATAL
JAZZ FOUNDATION OF SOUTH AFRICA                       47 563 440   UNSPECIFIED
PHOENIX CHILD AND FAMILY WELFARE SOCIETY              45 601 284   KWAZULU NATAL
MAAFRIKA TIKKUN ASSOCIATION                           43 774 095   GAUTENG   
SA SPORTS ASSOCIATION FOR THE INTELLECTUALLY IMPAIRE  42 797 912   LIMPOPO   
CAPE PHILHARMONIC ORCHESTRA                           42 155 363   WESTERN CAPE
NATIONAL FILM & VIDEO FOUNDATION                      42 050 000   GAUTENG   
MAKHAYA ART & CULTURAL DEVELOPMENT                    41 078 252   UNSPECIFIED

In case your counting digits, let me help you:

  1. SASCOC ~ R658 million
  2. FIFA Committee ~ R200 million
  3. CANSA ~ R144 million

Those numbers are interesting, but the real story would be to look at how they spend that money. Perhaps I'm cynical, but if even half of that did not disappear via fraud then I would be impressed.

Looking at the bottom feeders, it was interesting to note that some poor fuckers in Potgietersrus somehow went into the red. (It's probably just a typo, though.)

select name, sum(amount) as total, location from lotto group by name order by total asc limit 10;

name                                         total       location   
-------------------------------------------  ----------  -----------
SAVF POTGIETERSRUS (TINA FOUCHE KINDERLAND)  -16 588    UNSPECIFIED
CHRISTELIKE MAATSKAPLIKE RAAD                0          WESTERN CAP
HOPE IN VICTORY CARE GIVERS                  0          UNSPECIFIED
SAVF WIELIE WALIE KLEUTERSKOOL               0          UNSPECIFIED
AC MILAN FOOTBALL CLUB                       1 000      EASTERN CAP
SASSU FREE SATE                              2 200      FREE STATE 
SOLOS SWIMMING CLUB                          3 800      NORTHERN CA
BULTFONTEIN CRICKET CLUB                     4 000      FREE STATE 
ZEBRAS VOLLEYBALL CLUB                       4 000      FREE STATE 
HAPPY TIGERS FC                              4 916      EASTERN CAP

Breakdown by province.

select location, sum(amount) as total from lotto group by location order by total desc;

location        total        
-----------     -------------
UNSPECIFIED     7 085 107 174
GAUTENG         5 095 247 347 
WESTERN CAPE    2 421 578 616
KWAZULU NATAL   1 755 564 074 
LIMPOPO         1 252 230 448 
EASTERN CAPE    1 235 230 538 
NATIONAL BODIES 913 850 730  
NORTH WEST      685 099 547  
FREE STATE      648 102 903  
MPUMALANGA      512 346 647  
NORTHERN CAPE   445 557 407

(It would be interesting to see this normalized by population count.)

In total

select sum(amount) from lotto;

22 049 915 432.09

22 billion ZAR. (Afrikaans: 22 miljard ZAR).

That's all. Don't play Lotto, it's a waste of money.

Have a comment? Email me at jaco@jacoduplessis.co.za.