hang on will just check that
Football Data (CSV, JSON) - UPDATED 16/08/17
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
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
Last edited by jonnyg on Sun Aug 13, 2017 4:28 pm, edited 17 times in total.
-
- Posts: 3140
- Joined: Sun Jan 31, 2010 8:06 pm
In case anyone want the actual data before the thread gets cluttered with it typed out
*Edit* looks like i was to late
You do not have the required permissions to view the files attached to this post.
-
- Posts: 165
- Joined: Wed Mar 01, 2017 2:06 pm
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 itwelshboy06 wrote: ↑Sun Aug 13, 2017 4:13 pmI 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.
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 >
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 >
Last edited by jonnyg on Sun Aug 13, 2017 4:42 pm, edited 5 times in total.
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
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
jonnyg wrote: ↑Sun Aug 13, 2017 2:49 pmwelshboy06 wrote: ↑Sun Aug 13, 2017 9:45 amHi All,
I've decided to start collecting football data. Mainly because I have an interest in the sport and also because of a certain jonnyg throwing stats around in a very hard to read format.
The data is quite simple and was just scraped from HKJC.
The data is in json format, but you should be able to convert it to csv and import it to Excel. I chose json as it reduces data duplication, is structured and can be read reasonably well by the human eye. It also works really well with Python (Which I'm using to scrape and also analyse the data)
The data contains the following info.
League
Season
Game Date
Home Team
Away Team
And also Goals and Red cards (Player, Time and Team)
At the moment I've only gotten around to scraping the BPL seasons that have all goal data on hkjc (04-05 to 16-17) I may also add in corners, however that would be total for the game, not timings.
More Leagues and seasons will be coming soon, but I'm pretty busy with work etc atm.
The file is a .txt file stored in the below zip (Couldn't upload .txt directly) and is less than 2mb! So should be easy to read and manipulate on anyones setup.
Just to note: The data is all scraped from HKJC, so if there are any errors it would be down to the data they provided.
BPL.zip
Now for one of the main reasons I did this, @jonnyg Asked me a question in another thread...
when you say easy ?
how easy ?
Well the answer to that question is 3.5gls (Total goals / Total Games)
Since the 2011-2012 season, the amount of games where the Home team scored first and the First goal was scored On or Before the 8th minute...
Total Games: 84 Total Goals: 294 Average Goals: 3.5
Min Goals: 1
Max Goals: 9
Cheers,
Adam
the key point is that how many people have the ability to be aware instantly that the data was way off ?
Lot's people have built models around key metrics that date back for many years. I started looking at football in the 80's.
It doesn't help just posting up reams of stuff. Most people will take data put it into a model and pop out an equation. Just no point in cluttering up threads endlessly. It's spoiling discussion.
It doesn't help just posting up reams of stuff. Most people will take data put it into a model and pop out an equation. Just no point in cluttering up threads endlessly. It's spoiling discussion.
Euler wrote: ↑Sun Aug 13, 2017 4:40 pmLot's people have built models around key metrics that date back for many years. I started looking at football in the 80's.
It doesn't help just posting up reams of stuff. Most people will take data put it into a model and pop out an equation. Just no point in cluttering up threads endlessly. It's spoiling discussion.
Well at least in my final post i showed how easy it is to scrape the wrong data
-
- Posts: 165
- Joined: Wed Mar 01, 2017 2:06 pm
jonnyg wrote: ↑Sun Aug 13, 2017 4:38 pmjonnyg wrote: ↑Sun Aug 13, 2017 2:49 pmThe data wasn't way off. The code which drew the conclusion was (Which I've stated in a previous post). As far as I'm aware the data on the hkjc site is accurate. That's where I scraped it from.welshboy06 wrote: ↑Sun Aug 13, 2017 9:45 amHi All,
I've decided to start collecting football data. Mainly because I have an interest in the sport and also because of a certain jonnyg throwing stats around in a very hard to read format.
The data is quite simple and was just scraped from HKJC.
The data is in json format, but you should be able to convert it to csv and import it to Excel. I chose json as it reduces data duplication, is structured and can be read reasonably well by the human eye. It also works really well with Python (Which I'm using to scrape and also analyse the data)
The data contains the following info.
League
Season
Game Date
Home Team
Away Team
And also Goals and Red cards (Player, Time and Team)
At the moment I've only gotten around to scraping the BPL seasons that have all goal data on hkjc (04-05 to 16-17) I may also add in corners, however that would be total for the game, not timings.
More Leagues and seasons will be coming soon, but I'm pretty busy with work etc atm.
The file is a .txt file stored in the below zip (Couldn't upload .txt directly) and is less than 2mb! So should be easy to read and manipulate on anyones setup.
Just to note: The data is all scraped from HKJC, so if there are any errors it would be down to the data they provided.
BPL.zip
Now for one of the main reasons I did this, @jonnyg Asked me a question in another thread...
the key point is that how many people have the ability to be aware instantly that the data was way off ?
If you have all of the data collected already, then please zip it up and post it. I'm sure it would help a lot of people
Cheers,
Adam
-
- Posts: 165
- Joined: Wed Mar 01, 2017 2:06 pm
I was having a look over this spreadsheet and scratching my head, trying to figure out why our numbers dont match. Looks like some of the games in the spreadhseet are a day out, either that or hkjc is out.
Liverpool v Fulham - 01/05/2012 on the spreadhseet
But has a date of 02/05/2012 on hkjc. I picked out a few others. But I suppose the date of a game doesn't really matter too much (Being only 1 day out)
Thanks for the spreadsheet, it's helping me double check my findings.
Adam