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

Post Reply
User avatar
jonnyg
Posts: 691
Joined: Wed Jan 18, 2017 8:11 pm

Dallas wrote:
Sun Aug 13, 2017 3:16 pm
jonnyg wrote:
Sun Aug 13, 2017 2:49 pm
"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
User avatar
jonnyg
Posts: 691
Joined: Wed Jan 18, 2017 8:11 pm

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
Last edited by jonnyg on Sun Aug 13, 2017 4:28 pm, edited 17 times in total.
LinusP
Posts: 1871
Joined: Mon Jul 02, 2012 10:45 pm

Thanks for sharing!

Jonnyg do you have to fill this thread up as well?
spreadbetting
Posts: 3140
Joined: Sun Jan 31, 2010 8:06 pm

LinusP wrote:
Sun Aug 13, 2017 3:40 pm
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
User avatar
Dallas
Posts: 22674
Joined: Sun Aug 09, 2015 10:57 pm
Location: Working From Home

Dallas wrote:
Sun Aug 13, 2017 3:16 pm
jonnyg wrote:
Sun Aug 13, 2017 2:49 pm
"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
You do not have the required permissions to view the files attached to this post.
User avatar
jonnyg
Posts: 691
Joined: Wed Jan 18, 2017 8:11 pm

your 84 game chap has provided the wrong data > :!:

although pleasing to see people looking at the effect of the early goal
welshboy06
Posts: 165
Joined: Wed Mar 01, 2017 2:06 pm

jonnyg wrote:
Sun Aug 13, 2017 3:51 pm
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.
User avatar
jonnyg
Posts: 691
Joined: Wed Jan 18, 2017 8:11 pm

welshboy06 wrote:
Sun Aug 13, 2017 4:13 pm
jonnyg wrote:
Sun Aug 13, 2017 3:51 pm
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 :!:
User avatar
jonnyg
Posts: 691
Joined: Wed Jan 18, 2017 8:11 pm

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 >
Last edited by jonnyg on Sun Aug 13, 2017 4:42 pm, edited 5 times in total.
User avatar
jonnyg
Posts: 691
Joined: Wed Jan 18, 2017 8:11 pm

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
User avatar
jonnyg
Posts: 691
Joined: Wed Jan 18, 2017 8:11 pm

jonnyg wrote:
Sun Aug 13, 2017 2:49 pm
welshboy06 wrote:
Sun Aug 13, 2017 9:45 am
Hi 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 ? :idea:
User avatar
Euler
Posts: 24701
Joined: Wed Nov 10, 2010 1:39 pm
Location: Bet Angel HQ

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.
User avatar
jonnyg
Posts: 691
Joined: Wed Jan 18, 2017 8:11 pm

Euler wrote:
Sun Aug 13, 2017 4:40 pm
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.

Well at least in my final post i showed how easy it is to scrape the wrong data :!:
welshboy06
Posts: 165
Joined: Wed Mar 01, 2017 2:06 pm

jonnyg wrote:
Sun Aug 13, 2017 4:38 pm
jonnyg wrote:
Sun Aug 13, 2017 2:49 pm
welshboy06 wrote:
Sun Aug 13, 2017 9:45 am
Hi 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 ? :idea:
The 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.

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
welshboy06
Posts: 165
Joined: Wed Mar 01, 2017 2:06 pm

Dallas wrote:
Sun Aug 13, 2017 3:48 pm
Dallas wrote:
Sun Aug 13, 2017 3:16 pm
jonnyg wrote:
Sun Aug 13, 2017 2:49 pm
"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
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
Post Reply

Return to “Betfair Data”