football.json Datasets 2019/20 Update - Bonus: New Article - Generating Football JSON Datasets

29 views
Skip to first unread message

Gerald Bauer

unread,
May 25, 2020, 11:30:42 AM5/25/20
to open...@googlegroups.com
Hello,

Using the new football.json scripts [1] I have updated
the 2019/20 season from the football.txt sources. The leagues include:
- English Premier League
- Deutsche Bundesliga
- Deutsche 2. Bundesliga
- Spanish Primera División ("La Liga")
- Italian Serie A

As a bonus I've written up a little article
on Generating JSON Datasets [2] in the sport.db Scripts & Tools Guide
Series. You can use the football.json datasets as (static) web
services
with no API key or signup required ;-), for example.
The article kicks off with the English Premier League.
Enjoy data wrangling and the beautiful game with the sport.db
scripting machinery.

Alternatives - of course - always welcome. Cheers. Prost.

[1] https://github.com/yorobot/football.json
[2] https://github.com/sportdb/docs/blob/master/generating-json-datasets.md

Oscar Batori

unread,
May 27, 2020, 3:37:51 AM5/27/20
to opensport
Gerald - a big fan of the work you have been doing. I work on product at DoltHub, which is optimized for distributing data, and free for open data. I am wondering if you would consider collaborating on hosting this on DoltHub so that users can run one command and clone all data across all leagues and seasons, rather than a file per league per season?

We blogged about using our product for distribution.

-Oscar

Gerald Bauer

unread,
May 27, 2020, 3:47:58 AM5/27/20
to open...@googlegroups.com
Hello,
Again thanks for the invitation and highlighting dolt and dolthub.
Unfortunately, I can only do so much in a week, in a month, etc. and
I can't even get to upgrade my ruby installation not to speak of the
operating system. Sorry, for the next weeks I try to get more of the
sources converted to the "new" zero-config v2.0 format and so it goes
week for week.

Once I've got an automatic build in some month I'm more than happy
to explore more SQLite database distributions - but for now I'm "stuck
on the basics". Thanks for your understanding.

Keep it up. Cheers. Prost.
Reply all
Reply to author
Forward
0 new messages