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

[welshboy06]

Does it convert well to a MySql database?

I've not tried it myself, I don't see why not.
All the fields are labeled, so should be easy enough to map to tables. You'd probably need to make a quick python script to spit out the relevant sql.

[welshboy06]

PL 2017-2018 in games where the home team opened the scoring on 8 minutes or before > exactly 8 minutes will be in bold

4-3 3-3

2016-2017

I dont understand what you're asking?
But I've made the data available to the forum, so I'm sure you could use it to prove your own theories.

[spreadbetting]

Thanks I'll give it a try after racing and thanks again for putting it up.

[Dallas]

"can you tell me for example what is the average goal production since 2011-2012 in games where the home team in the PL opened the scoring on 8 minutes ?

Since 2011-2012 = 3.73
11-12 = 3.28
12-13 = 4.0
13-14 = 4.25
14-15 = 4.25
15-16 = 3.66
16-17 = 3.37

[jonnyg]

there were many more games then 84 in the Pl since 2011-2012 where the home team opened the scoring on or before 8 minutes

[jonnyg]

"can you tell me for example what is the average goal production since 2011-2012 in games where the home team in the PL opened the scoring on 8 minutes ?

3.73

hang on will just check that

[jonnyg]

Watford
3 - 3
Liverpool View events More info
S. Okaka 8'
1 - 0
1 - 1
29' S. Mané
A. Doucouré 32'
2 - 1
2 - 2
55' Roberto Firmino (PG)
2 - 3
57' Mohamed Salah
M. Britos 90'
3 - 3

Arsenal
3 - 1
Everton View events More info
Bellerín 8'
1 - 0
A. Sánchez 27'
2 - 0
2 - 1
58' R. Lukaku (PG)
A. Ramsey 90'
3 - 1


Middlesbrough
1 - 0
Sunderland View events More info
M. de Roon 8'
1 - 0


Liverpool
3 - 1
Everton View events More info
S. Mané 8'
1 - 0
1 - 1
28' M. Pennington
Philippe Coutinho 31'
2 - 1
D. Origi 60'
3 - 1


Liverpool
1 - 0
Manchester City View events More info
G. Wijnaldum 8'
1 - 0


Stoke City
2 - 0
Sunderland View events More info
J. Allen 8'
1 - 0
J. Allen 45'
2 - 0

Swansea City
1 - 2
Liverpool View events More info
L. Fer 8'
1 - 0
1 - 1
54' Roberto Firmino
1 - 2
84' J. Milner (PG)

West Bromwich …
4 - 2
West Ham United View events More info
N. Chadli (PG) 8'
1 - 0
S. Rondón 37'
2 - 0
J. McClean 44'
3 - 0
N. Chadli 56'
4 - 0
4 - 1
61' M. Antonio
4 - 2
65' M. Lanzini (PG)


Manchester City
2 - 2
Arsenal View events More info
S. Agüero 8'
1 - 0
1 - 1
10' O. Giroud
K. De Bruyne 51'
2 - 1
2 - 2
68' A. Sánchez


Manchester United
1 - 1
Leicester City View events More info
A. Martial 8'
1 - 0
1 - 1
17' W. Morgan

Liverpool
4 - 1
Stoke City View events More info
Alberto Moreno 8'
1 - 0
1 - 1
22' Bojan
D. Sturridge 32'
2 - 1
D. Origi 50'
3 - 1
D. Origi 65'
4 - 1


West Bromwich …
2 - 3
Leicester City View events More info
D. Fletcher 8'
1 - 0
1 - 1
20' D. Nugent
C. Gardner 26'
2 - 1
2 - 2
80' R. Huth
2 - 3
90' J. Vardy

Arsenal
5 - 0
Aston Villa View events More info
O. Giroud 8'
1 - 0
M. Özil 56'
2 - 0
T. Walcott 63'
3 - 0
Santi Cazorla (PG) 75'
4 - 0
Bellerín 90'
5 - 0

Hull City
1 - 2
Tottenham Hotspur View events More info
J. Livermore 8'
1 - 0
1 - 1
61' H. Kane
1 - 2
90' C. Eriksen

West Bromwich …
2 - 2
Manchester United View events More info
S. Sessègnon 8'
1 - 0
1 - 1
48' M. Fellaini
S. Berahino 66'
2 - 1
2 - 2
87' D. Blind


Fulham
2 - 3
Liverpool View events More info
K. Touré (OG) 8'
1 - 0
1 - 1
41' D. Sturridge
K. Richardson 63'
2 - 1
2 - 2
72' Philippe Coutinho
2 - 3
90' S. Gerrard (PG)

Manchester City
3 - 0
Swansea City View events More info
Álvaro Negredo 8'
1 - 0
S. Nasri 58'
2 - 0
S. Nasri 77'
3 - 0

Everton
2 - 1
Hull City View events More info
G. Barry 8'
1 - 0
1 - 1
30' Y. Sagbo
S. Pienaar 57'
2 - 1

Fulham
3 - 2
Queens Park Ra… View events More info
D. Berbatov (PG) 8'
1 - 0
D. Berbatov 22'
2 - 0
C. Hill (OG) 41'
3 - 0
3 - 1
45' A. Taarabt
3 - 2
51' L. Rémy

Swansea City
4 - 1
Queens Park Ra… View events More info
Michu 8'
1 - 0
Àngel Rangel 18'
2 - 0
2 - 1
48' B. Zamora
Pablo Hernández 50'
3 - 1
Michu 67'
4 - 1


Fulham
1 - 1
Southampton View events More info
D. Berbatov 8'
1 - 0
1 - 1
85' R. Lambert (PG)

Liverpool
4 - 0
Fulham View events More info
M. Škrtel 8'
1 - 0
S. Gerrard 36'
2 - 0
S. Downing 52'
3 - 0
L. Suárez 90'
4 - 0

Norwich City
2 - 1
Sunderland View events More info
S. Bassong 8'
1 - 0
A. Pilkington 37'
2 - 0
2 - 1
44' C. Gardner


Reading
3 - 4
Manchester United View events More info
H. Robson-Kanu 8'
1 - 0
1 - 1
13' Anderson
1 - 2
16' W. Rooney (PG)
A. Le Fondre 19'
2 - 2
S. Morrison 23'
3 - 2
3 - 3
30' W. Rooney
3 - 4
34' R. van Persie

Wigan Athletic
2 - 1
West Ham United View events More info
Ramis 8'
1 - 0
J. McArthur 47'
2 - 0
2 - 1
90' J. Tomkins

Norwich City
2 - 0
Aston Villa View events More info
G. Holt 8'
1 - 0
S. Jackson 22'
2 - 0

Arsenal
1 - 1
Wolverhampton … View events More info
Y. Gervinho 8'
1 - 0
1 - 1
38' S. Fletcher


Manchester United
5 - 0
Wigan Athletic View events More info
Ji-Sung Park 8'
1 - 0
D. Berbatov 41'
2 - 0
D. Berbatov 58'
3 - 0
A. Valencia 75'
4 - 0
D. Berbatov (PG) 78'
5 - 0

Tottenham Hotspur
1 - 1
Chelsea View events More info
E. Adebayor 8'
1 - 0
1 - 1
23' D. Sturridge

Sunderland
1 - 2
Wigan Athletic View events More info
S. Larsson 8'
1 - 0
1 - 1
44' Jordi Gómez (PG)
1 - 2
90' F. Di Santo


Stoke City
2 - 3
Queens Park Ra… View events More info
J. Walters 8'
1 - 0
1 - 1
22' H. Helguson
1 - 2
44' L. Young
1 - 3
54' H. Helguson
R. Shawcross 64'
2 - 3

West Bromwich …
2 - 0
Wolverhampton … View events More info
C. Brunt 8'
1 - 0
P. Odemwingie 76'
2 - 0

Manchester United
3 - 1
Chelsea View events More info
C. Smalling 8'
1 - 0
Nani 37'
2 - 0
W. Rooney 45'
3 - 0
3 - 1
46' Fernando Torres

[LinusP]

Thanks for sharing!

Jonnyg do you have to fill this thread up as well?

[spreadbetting]

Thanks for sharing!

Jonnyg do you have to fill this thread up as well?

+1

Posting lists of scores with the odd winking smily really isn't needed on this thread

[Dallas]

"can you tell me for example what is the average goal production since 2011-2012 in games where the home team in the PL opened the scoring on 8 minutes ?

Since 2011-2012 = 3.73
11-12 = 3.28
12-13 = 4.0
13-14 = 4.25
14-15 = 4.25
15-16 = 3.66
16-17 = 3.37

In case anyone want the actual data before the thread gets cluttered with it typed out

*Edit* looks like i was to late

[jonnyg]

your 84 game chap has provided the wrong data >

although pleasing to see people looking at the effect of the early goal

[welshboy06]

your 84 game chap has provided the wrong data >

although pleasing to see people looking at the effect of the early goal

I admit that there was an error in my code which didn't pick up all of the games. That was mainly due to me writing messy code, just to get the number you asked for.

Please don't spam this thread with your lists and lists of data. Thats not why I created it.
Also there's no need to take issue with someone who's trying to help you.

[jonnyg]

your 84 game chap has provided the wrong data >

although pleasing to see people looking at the effect of the early goal

I admit that there was an error in my code which didn't pick up all of the games. That was mainly due to me writing messy code, just to get the number you asked for.

Please don't spam this thread with your lists and lists of data. Thats not why I created it.
Also there's no need to take issue with someone who's trying to help you.

It is nice to see a chap = me who has spent over 5 years looking at the early goal inspiring people to do the same > I have the largest early goal data bank but people dont want me to share it

[jonnyg]

In the PL since 2011-2012 where the home team opened the scoring on 8 minutes >

33 games >

19-7-7

average goal production = Dallas said 3.73 and i am sure they will be spot on > I make it > 3.64 < close enough for me

footnote < naturally if people are not interested in my football data and analysis I am not going to force them into it >

my data is manually collated so open to human error >

[jonnyg]

I can see that I am not welcome on the forum so will not hang around < let me just finish the 8 minute data <
one thing I have learned is that it is not easy to scrape the time of the opening goal data >

look forward to reading about a site that has done it to a high level very soon <

good luck everyone