.
Many thanks to Adam (welshboy 06). Fantastic work, much appreciated.
Football Data (CSV, JSON) - UPDATED 16/08/17
-
- 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
https://goaltimes.000webhostapp.com/index.php
Nice work Spreadbettingspreadbetting wrote: ↑Wed Aug 23, 2017 10:18 pmI 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
-
- 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
I've done something similar myself, but using an ipython notebook. Was considering making a simple webpage, but you're already on the case
-
- 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.
.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.
-
- 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.
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.
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.
-
- Posts: 165
- Joined: Wed Mar 01, 2017 2:06 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.
welshboy06 wrote: ↑Wed Aug 30, 2017 8:35 pmI'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.