Cricket stats database

[ganeshran]

Does anyone have a database of cricket statistics updated recently. I have been looking for an updated one for quite sometime without much luck.

If you have it, please share. Thanks,

 

[Jayzamann]

HowSTAT! The Cricket Statisticians - Home Page

That's used quite a lot here.

 

[weldone]

espncricinfo statsguru is another...

 

[ganeshran]

Actually, I meant a database where I could run a SQL query to get data - works to be much more flexible than Statsguru and Howstat.

 

[Prince EWS]

I kind of do.

 

[ganeshran]

I kind of do.

Can you please share it, if you are ok with it?

 

[weldone]

I kind of do.

Ah! Do you maintain a .mdb file? I thought your works were primarily based on excel s/s...

 

[Prince EWS]

Can you please share it, if you are ok with it?

The format it's in makes it impossible to really do that at the moment, but if you give me a couple of days I'll make it into a couple of SQL databases (one for batting and one for bowling) and post some links up.

How raw do you want it to be exactly? Do you want a record for each and every Test batting innings for example so you can create php pages with queries, or just a record for each player's Test batting stats? (same for bowling obv)

 

[Prince EWS]

Ah! Do you maintain a .mdb file? I thought your works were primarily based on excel s/s...

My works on based on massive notepad files (ripped off 500 page StatsGuru query results ) which are analysed by Visual Basic programs I've created. The good thing about that is that I can export them in any format I like if I put the code in though.

 

[ganeshran]

The format it's in makes it impossible to really do that at the moment, but if you give me a couple of days I'll make it into a couple of SQL databases (one for batting and one for bowling) and post some links up.

How raw do you want it to be exactly? Do you want a record for each and every Test batting innings for example so you can create php pages with queries, or just a record for each player's Test batting stats? (same for bowling obv)

Thanks

I was trying for a database which is quite raw and has aggregated data as well. For e.g. A record of each batting and bowling innings in separate tables. This can connect to a table with the overall match data in a separate table. Would really make it easier to pull out data for any match and any player's performance too.

I can also help by editing the parser code to change it in a SQL database.

 

[Prince EWS]

Thanks

I was trying for a database which is quite raw and has aggregated data as well. For e.g. A record of each batting and bowling innings in separate tables. This can connect to a table with the overall match data in a separate table. Would really make it easier to pull out data for any match and any player's performance too.

I can also help by editing the parser code to change it in a SQL database.

So ideally you'd want one database with four tables in it.

Batting
Bowling
BattingAggregate
BowlingAggregate

I can do that. I've got some other stuff to do first but it won't take me long so I'll try to get it to you in the next few days. I'll just post the link up in here when it's done.

 

[ganeshran]

So ideally you'd one database with four tables in it.

Batting
Bowling
BattingAggregate
BowlingAggregate

I can do that. I've got some other stuff to do first but it won't take me long so I'll try to get it to you in the next few days. I'll just post the link up in here when it's done.

Thanks Prince..

 

[weldone]

Just a little clarification here: will you be providing innings-by-innings scores for every batsman? That'll help me greatly, because I'm looking to conduct an analysis for test batsmthat'll require standard deviation of scores for each batsman, among other things.

 

[Prince EWS]

Just a little clarification here: will you be providing innings-by-innings scores for every batsman? That'll help me greatly, because I'm looking to conduct an analysis for test batsmthat'll require standard deviation of scores for each batsman, among other things.

Yep. I can give you the entire contents of this query (all 401 pages) in any format you like. All the values are picked up as variables in the program I created, so they can be outputted any way you wish. It actually does the home query and the away/neutral query separately so there will be a field for that too.

 

[Jayzamann]

this query

That'll put hair on any data entry gremlin's ballsack

 

[ganeshran]

Yep. I can give you the entire contents of this query (all 401 pages) in any format you like. All the values are picked up as variables in the program I created, so they can be outputted any way you wish. It actually does the home query and the away/neutral query separately so there will be a field for that too.

I wrote a parser for the cricinfo query mentioned by PEWS for Tests and ODIs.

Here is the Excel file with every Test and ODI innings played till now.

CricketInnings.xlsx - 4shared.com - online file sharing and storage - download

Edit:

I uploaded it to Google docs. The 4shared.com site makes you wait 15 mins before download

https://docs.google.com/open?id=0B7WmnIBRP7RrOTQzYTU4YmEtNDU2OS00NjJhLTg0NGMtMjQyNTBjMzNmODky

 

[jahanzaib]

Yep. I can give you the entire contents of this query (all 401 pages) in any format you like. All the values are picked up as variables in the program I created, so they can be outputted any way you wish. It actually does the home query and the away/neutral query separately so there will be a field for that too.

i need stats for Bating, Bowling and team for ODI and T20. If you have please share i have to complete my final year project for University. Please Help me

 

[jahanzaib]

I wrote a parser for the cricinfo query mentioned by PEWS for Tests and ODIs.

Here is the Excel file with every Test and ODI innings played till now.

CricketInnings.xlsx - 4shared.com - online file sharing and storage - download

Edit:

I uploaded it to Google docs. The 4shared.com site makes you wait 15 mins before download

https://docs.google.com/open?id=0B7WmnIBRP7RrOTQzYTU4YmEtNDU2OS00NjJhLTg0NGMtMjQyNTBjMzNmODky

Can you share the parser i need a lot of data from Stats Guru or help me in collecting it

 

[Daemon]

Sure mate, give me a moment

 

[jahanzaib]

Sure mate, give me a moment

Thanks I m waiting