Cricket Statistics

[Demosthenes]

Just curious how many stats nerds we have out there, and where you get your data from. Do you use a web interface like Statsguru, download cubes from other websites, or compile scorecards manually to create your own database?

I have always wanted access to a reliable and comprehensive source of first class match data (not necessarily going back decades), if anyone can recommend one I'd be very appreciative. Don't really mind if it's a paid service.

 

[PhatBoy]

Statsguru is pretty good but doesn't load on phones which is where I use most of my internet.

Howstat is pretty good for an overview of all the key areas of anyone's career.

 

[Gough]

Wisden.

 

[Demosthenes]

Wisden.

Like, as in the book? Or does subscribing give you access to a cube or some other data feed?

 

[Gough]

Like, as in the book? Or does subscribing give you access to a data cube / feed?

As in the book.

 

[Demosthenes]

Groovy. Makes aggregation and analysis a bit tricky though.

 

[The_Reaper]

I've got a fully autistic set of excel spreadsheets for over a decade of sheffield shield stats.

 

[worbod]

I have always found the Cricket Archive website the best source, but today I see you can only access their info by becoming a subscriber. I'll probably pay for a membership however, as it has a great variety of info about players. You can see not only somebody's first class stats and one day stats, but also all Lancashire League and the Minor Counties matches anybody has played. Recently they acquired all Victoria District cricket matches onto their database. So even though I've talked up Cricket Archive, you'll now need to subscribe to see what they have.

 

[Spook]

Howstat.com

 

[Hellgood]

Not really a response to the OP as he was looking for sources, but somewhat related as found these recent stat based analysis cricinfo articles extremely insightful:

http://www.thecricketmonthly.com/story/1083643/collapso-relapso

http://www.thecricketmonthly.com/story/1083469/the-end-over-jitters

 

[PhatBoy]

Not really a response to the OP as he was looking for sources, but somewhat related as found these recent stat based analysis cricinfo articles extremely insightful:

http://www.thecricketmonthly.com/story/1083643/collapso-relapso

http://www.thecricketmonthly.com/story/1083469/the-end-over-jitters

Geez that first one is interesting.

Windies ftw

 

[Demosthenes]

I've got a fully autistic set of excel spreadsheets for over a decade of sheffield shield stats.

That's quite neat. Did you build them yourself from scorecards or something?

If it goes down to match-by-match detail it would probably be worth sticking them in a SQL database.

 

[TommyD13]

I just use espn cricinfo

 

[Scotland]

I am a CA selector and what is this?

 

[Carlos Danger]

I am a CA selector and what is this?

Its what's round up on the toilet rolls in your selection meeting office

 

[Doss]

I've been a cricket stats boffin since I was a kid. Various sources - but Wisden is predominant.

 

[eddiesmith]

I have always found the Cricket Archive website the best source, but today I see you can only access their info by becoming a subscriber. I'll probably pay for a membership however, as it has a great variety of info about players. You can see not only somebody's first class stats and one day stats, but also all Lancashire League and the Minor Counties matches anybody has played. Recently they acquired all Victoria District cricket matches onto their database. So even though I've talked up Cricket Archive, you'll now need to subscribe to see what they have.

Yeah always used this website also, the great breakdown of first class stats by ground and opposition especially I found useful.

Cant see myself paying for it atm so might need a new one!

 

[Hellgood]

Yeah always used this website also, the great breakdown of first class stats by ground and opposition especially I found useful.

Cant see myself paying for it atm so might need a new one!

That's interesting. Cricinfo is pretty much without peer for international statistical analysis, but lacking in depth for first class. Cricket Archive was always my go to for looking at first class too.

 

[Smoooothy]

massive on my stats

on a personal level, i've still got my original excel sheet that i created in the summer of 92/93 with all of my own cricket statistics in it, tracked all of them until i "retired' in 2011/12

my average was terrible!

on a first class/international level i use statsguru, but i'd love to get myself a sql server or something like that setup with every stat possible on it

 

[MC Bad Genius]

Stats-nerd checking in.

Can anyone point out some really interesting analyses that don't normally get covered in the cricketing world? I posted some articles about batting medians (as opposed to averages) in another thread, but I can't find them at the moment.

 

[Demosthenes]

Cricinfo's control % is quite interesting.

 

[Howard Littlejohn]

I pretty much just use Statsguru, but gettign something more comprehensive on FC, ListA, etc would be good.
And anything that was match-by-match, inninings-by-innings, full career so the real stats whizzes coiuld pull together some more stuff than just averages. if two people average 35 with the bat, and one fails a lot with a few big scores, whilke the other scores 20-50 regularly with few big scores and few failures, who is the more valuable? There isn't any easy way of seeing which players fall into which categories. It can be done with a combination of Statguru queries and some dicking about I think. (Not answering which is more valuable, but who fits which category.)

 

[Demosthenes]

So I ended up writing a little bit of VBA code that iterates through a range of URLs on the Cricinfo website and scrapes the data (based on HTML table reference) into CSV files which I can then load into SQL Server. The formatting is still a bit screwy but will fix it at some stage in the next couple of weeks. If anyone is interested in replicating I based the code mostly on the below:

www.stackoverflow.com/questions/8798260/html-parsing-of-cricinfo-scorecards

It's a bit of a cumbersome solution, so if anyone comes across actual live data feeds for FC matches I would still be interested.

 

[Gough]

I only understood bits of that.

 

[Demosthenes]

I also found a really cool little package in Ruby for ODI scorecards, which could probably be tweaked for Test and maybe FC stats.

https://www.r-bloggers.com/cricket-data-analysis/amp/

Unfortunately I can't code Ruby, because it would be a much better solution than the one I came up with.