Football Data (CSV, JSON) - UPDATED 16/08/17

Post Reply
rostov
Posts: 50
Joined: Mon Jul 02, 2012 3:45 pm

.
Many thanks to Adam (welshboy 06). Fantastic work, much appreciated.
spreadbetting
Posts: 3140
Joined: Sun Jan 31, 2010 8:06 pm

I stuck welshboy's data up on a simple website, I'll try and make it a big more searchable when I figure out php7 :(

https://goaltimes.000webhostapp.com/index.php
User avatar
Dallas
Posts: 22671
Joined: Sun Aug 09, 2015 10:57 pm
Location: Working From Home

spreadbetting wrote:
Wed Aug 23, 2017 10:18 pm
I stuck welshboy's data up on a simple website, I'll try and make it a big more searchable when I figure out php7 :(

https://goaltimes.000webhostapp.com/index.php
Nice work Spreadbetting :)
welshboy06
Posts: 165
Joined: Wed Mar 01, 2017 2:06 pm

Nice one spreadbetting!

I've done something similar myself, but using an ipython notebook. Was considering making a simple webpage, but you're already on the case :P
spreadbetting
Posts: 3140
Joined: Sun Jan 31, 2010 8:06 pm

Unfortunately putting it up made me realise why I haven't done any html for ages, just about everythings changed, I've only php 5 something on my pc and everythings moved over to php 7 so most of the code I use on y own snippets are now redundant :) I'll be interested to see if the firstgoal times do have any drastic bearing on the outcome come Saturday.


.000webhost seem to be a decent free source if you want to trial a website especially as you have the scrapping code already in place , welshboy06, mysql , php etc all free as far as I can see for now.
spreadbetting
Posts: 3140
Joined: Sun Jan 31, 2010 8:06 pm

Here the database scrape for the Newcastle game , goal scord at 36mins

Results from 1-0 first goal between 30 and 45 minutes

Newcastle 1 - 0 Away Team
30 games. 70% won. 23% drawn 7% lost.

Home Team 1 - 0 West Ham

24 games. 8% won. 12% drawn 79% lost.

Odds are pretty much in line 1.4, 4.8 ,12.5


Palace vs Swansea, Swansea score 44

Results from 0-1 first goal between 30 and 45 minutes, first goal time in brackets

Crystal Palace 0 - 1 Away Team
13 games. 0% won. 15% drawn 85% lost.

Home Team 0 - 1 Swansea
8 games. 38% won. 38% drawn 25% lost.

odds 7.4, 3.45 , 1.73


If we look at data from 4o minutes onwards it seems Palace don't have a good record of coming back to win and Swansea haven't lost either

Results from 0-1 first goal between 40 and 90 minutes, first goal time in brackets

Crystal Palace 0 - 1 Away Team

Crystal Palace 1 - 1 Newcastle (42)
Crystal Palace 1 - 2 Swansea (42)
Crystal Palace 0 - 1 Chelsea (43)
Crystal Palace 1 - 2 Manchester Utd (45)
Crystal Palace 0 - 2 Arsenal (47)
Crystal Palace 2 - 1 Tottenham (49)
Crystal Palace 0 - 1 Tottenham (50)
Crystal Palace 0 - 2 Hull City (51)
Crystal Palace 1 - 2 Manchester City (55)
Crystal Palace 0 - 2 Manchester Utd (62)
Crystal Palace 1 - 1 Arsenal (63)
Crystal Palace 0 - 1 Portsmouth (69)
Crystal Palace 0 - 1 West Bromwich (74)
Crystal Palace 0 - 1 Tottenham (78)
Crystal Palace 0 - 2 Newcastle (79)
Crystal Palace 0 - 1 Sunderland (80)
Crystal Palace 0 - 1 Everton (87)
Crystal Palace 0 - 1 Manchester City (90)
Crystal Palace 0 - 1 Charlton (90)

19 games. 5% won. 11% drawn 84% lost.

Home Team 0 - 1 Swansea

Everton 1 - 1 Swansea (41)
Crystal Palace 1 - 2 Swansea (42)
Wigan 0 - 2 Swansea (45)
Sunderland 1 - 1 Swansea (45)
Liverpool 2 - 3 Swansea (48)
Fulham 1 - 2 Swansea (56)
Newcastle 1 - 2 Swansea (58)
Burnley 0 - 1 Swansea (64)
West Bromwich 1 - 1 Swansea (64)
Burnley 0 - 1 Swansea (82)
Southampton 0 - 1 Swansea (83)
Arsenal 0 - 1 Swansea (85)
Aston Villa 0 - 1 Swansea (87)
Arsenal 0 - 2 Swansea (88)

14 games. 79% won. 21% drawn 0% lost.
Last edited by spreadbetting on Sat Aug 26, 2017 4:02 pm, edited 3 times in total.
User avatar
Naffman
Posts: 5626
Joined: Sun Aug 11, 2013 5:46 am

C'mon JonnyG tell us what to do ;)
User avatar
Westerner
Posts: 161
Joined: Fri Apr 17, 2009 10:03 am

Shame to see this thread revert to Jonny talking to himself.
User avatar
Euler
Posts: 24700
Joined: Wed Nov 10, 2010 1:39 pm
Location: Bet Angel HQ

Not going to allow it to happen, as it's a decent thread. The mods will move or delete the posts.
User avatar
Naffman
Posts: 5626
Joined: Sun Aug 11, 2013 5:46 am

Think he just needs deleting.

Kind of feel he just wants to be annoying.
User avatar
Euler
Posts: 24700
Joined: Wed Nov 10, 2010 1:39 pm
Location: Bet Angel HQ

I agree, we have given plenty of slack and asked kindly. It's not too hard to get on with others. If you have something that works, that's great but constantly drowning out threads endlessly is killing genuine discussion.
Atho55
Posts: 637
Joined: Tue Oct 06, 2015 1:37 pm
Location: Home of Triumph Motorcycles

Is the solution to give Jonny his own thread that he confines his posts to. Other forum members then have the choice to read it or not. Any posts he makes in other threads automatically deleted.
dm1900
Posts: 71
Joined: Sun Jan 15, 2017 10:02 pm

Any chance of an updated data set, but with yellow cards as well? Or is that data not available?

Thanks again!
welshboy06
Posts: 165
Joined: Wed Mar 01, 2017 2:06 pm

doovd wrote:
Wed Aug 30, 2017 11:02 am
Any chance of an updated data set, but with yellow cards as well? Or is that data not available?

Thanks again!
I'm working on this at the moment. Not been able to find a reliable source for yellow card timings though.
At the moment i'm using the csv's from football-data.co.uk. Which has shots, shots on target, yellows, fowls, reds, goals, result (all for HT and FT) as well as odds for 1x2, o2.5,u2.5 from Pinnacle and an average from a selection of oter bookies. Theres no timings though, just totals for HT/FT. But it'll do for now.
User avatar
knome
Posts: 60
Joined: Fri Jun 17, 2016 8:48 am

welshboy06 wrote:
Wed Aug 30, 2017 8:35 pm
I'm working on this at the moment. Not been able to find a reliable source for yellow card timings though.
At the moment i'm using the csv's from football-data.co.uk. Which has shots, shots on target, yellows, fowls, reds, goals, result (all for HT and FT) as well as odds for 1x2, o2.5,u2.5 from Pinnacle and an average from a selection of oter bookies. Theres no timings though, just totals for HT/FT. But it'll do for now.

Have a look at https://www.fctables.com/
Oodles of data... Tooltip pop-ups with reds/yellows and goals.
Post Reply

Return to “Betfair Data”