openfootball / worldcup

Free open public domain football data for the World Cup (incl. Qatar 2022, Russia 2018, Brazil 2014, etc.) and World Cup Quali(fiers)
Creative Commons Zero v1.0 Universal
544 stars 179 forks source link

Connect to Wikidata? #51

Open lubianat opened 1 year ago

lubianat commented 1 year ago

Hello! Congrats on the amazing dataset.

I am studying ways of parsing it and adding the information to Wikidata, that is also CC0 and people can query using the SPARQL query language.

Just thought to let you know.

I'm still thinking about ways to model the data there; it is amazing to have a CC0 resource like yours, kudos!

Here is an example entry: https://www.wikidata.org/wiki/Q115329387

Cheers!

geraldb commented 1 year ago

I am studying ways of parsing it [the worldcup football.txt datasets].

Note: You do NOT need to parse the football.txt datasets - you can (re)use the sportdb machinery (parser) and than work with the structured data in SQL for export to Wikidata or any other format.

Thanks for the update. Big fan of wikidata - I have my own ideas for import / export to wikidata / wikipedia - see https://github.com/wikiscript for example but alas so far I am always running out of time. Keep us up-to-date on how it goes. All the best. PS: The official forum is http://groups.google.com/group/opensport.

lubianat commented 1 year ago

Sure! Eventually I'll add it to the Google Group, then, thanks. I'm playing around with the idea here: https://github.com/lubianat/footballdb2wikidata

But it will take some time;

I kind of want to play around with parsing it (though it might not be the most efficient/sustainable way) , but I'll keep the suggestion in mind

geraldb commented 1 year ago

Thanks for the update and the link.

FYI: To avoid any misunderstanding - The easiest (suggested) way would be read in the football.txt datasets with the sportdb command-line tool (e.g. try $ sportdb new worldcup2022) than you get a single-file (local) sport.db SQLite database. Than in step two use your languages of choice e.g. use a python script, for example, to connect to the (local single-file SQLite) sport.db and export to whatever format you need. Greetings from (near) Vienna, Austria.