search

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 180 forks source link

2010 Game POS Ordering #21

Closed ash106 closed 10 years ago

ash106 commented 10 years ago

I'm trying to make a visualization that is dependent on knowing the order the games were played in and I'm just wondering where the POS data came from? As far as I can tell, the 3rd and 4th games are out of order unless I'm misunderstanding how it works. I tried to order the games by play_at date using the query "Event.last.games.order('play_at')", but my query contains "ORDER BY pos, play_at". Any ideas on whether the data is wrong or why the 'sportdb/console' automatically orders by 'pos'?

geraldb commented 10 years ago

Thanks for your interest in football.db. Please post questions to the mailing list/forum. Thanks. Cheers.