football.db is a "free open public
domain football (soccer) database". Instructions to construct an SQLite
data file from the data are on the website. The database consists of 40
tables; its schema looks normalized. With the World Cup 2014 and dependent
data, the file weighs in at ~1MB.
Let's see what we can do with the data using ROE.
Each league/tournament is given an event ID; the World Cup's event_id
The above code snippet results in a RAProjection instance. We can see its
content by the following (pretty-printed by hand):
(Ivory Coast's proper name in the output doesn't look right in Pharo. The
SQLite database is correct though.)