NAV

Introduction to the "Ashwin" CSV format

This document details the "Ashwin" CSV data provided by Cricsheet. This was the second CSV version provided, and takes it's nickname from Ashwin Raman who kindly suggested the initial format that I tweaked (in a few minor ways). This is probably the most straightforward data format to use if you're looking to do something with Cricsheet data.

This page describes the organisation of the file and attempts to give some idea of the possible contents for each field. Unlike the "original" CSV format this file doesn't contain different types of rows. Instead there is a single header row, with names for each column, and then each subsequent row details a single delivery, with information on the match itself duplicated on each delivery row.

The current version number for the "Ashwin" format is 2.0.0, although this is mostly an internal designation and doesn't appear in the data.

The row format

A delivery with no runs scored, featuring Anderson bowling to Kolhi, with Ashwin at the non-strikers end. It was the first ball of the 47th over in the 4th innings.

1243384,2020/21,2021-02-05,MA Chidambaram Stadium,4,46.1,India,England,V Kohli,R Ashwin,JM Anderson,0,0,,,,,,,,,

A delivery where a single was scored, featuring Ecclestone bowling to Devine, with Satterthwaite at the non-strikers end. It was the third ball of the 12th over in the 2nd innings.

1249234,2020/21,2021-02-28,University Oval,2,11.3,New Zealand,England,SFM Devine,AE Satterthwaite,S Ecclestone,1,0,,,,,,,,,

A delivery where a wide was bowled, featuring Naveen-ul-Haq bowling to Shumba, with Musakanda at the non-strikers end. It was the second ball of the 7th over in the 2nd innings.

1252060,2020/21,2021-03-20,Sheikh Zayed Stadium,2,6.2,Zimbabwe,Afghanistan,M Shumba,TK Musakanda,Naveen-ul-Haq,0,1,1,,,,,,,,

A delivery where a wicket took place, with the batter being dismissed leg before wicket, featuring Boland bowling to Philippe, with Vince at the non-strikers end. It was the 3rd ball of the 4th over in the 2nd innings.

1226827,2020/21,2021-01-24,Melbourne Cricket Ground,2,2.3,Sydney Sixers,Hobart Hurricanes,JR Philippe,JM Vince,SM Boland,0,0,,,,,,lbw,JR Philippe,,

The info section contains the information on the actual match, such as when and where it was played, any competition it was part of, the type of match etc. The fields included in the info section will each appear as one or more rows in the data. Some of the fields are required, whereas some are optional. If a field has multiple values, such as team, then each value will appear on a row of it's own. In the example Afghanistan, and Canada both appear on an info,team row of their own.

Field Description
match_id string (required) The id for the match. Currently this is the ID as used by ESPNCricinfo.
season string (required) The season during which the match took place, such as 2018, or 2011/12.
start_date string (required) The start date of the match took place, in the format YYYY/MM/DD. Matches with multiple days will only show the first.
venue string The venue in which the game took place, such as Old Trafford. If not provided this will be blank.
innings integer (required) The number of the innings in which the delivery took place.
ball string (required) An identifier for the delivery (such as 23.5) specifies the particular ball (in that case the 5th ball of the 24th over).
batting_team string (required) The name of the team which was batting for the delivery.
bowling_team string (required) The name of the team which was bowling for the delivery.
striker string (required) The name of the batter who faced the delivery.
non_striker string (required) The name of the non-striker during the delivery.
bowler string (required) The name of the bowler during the delivery.
runs_off_bat integer (required) The total number of runs scored by the batter off the ball. If the batter failed to score this will show 0
extras integer (required) The total number of runs conceded via extras off the ball. If no extras were conceded this will show 0.
wides integer The number of wides conceded on the delivery. If no wides were conceded this will be blank.
noballs integer The number of no-balls conceded on the delivery. If no no-balls were conceded this will be blank.
byes integer The number of byes conceded on the delivery. If no byes were conceded this will be blank.
legbyes integer The number of legbyes conceded on the delivery. If no leg-byes were conceded this will be blank.
penalty integer The number of penalty runs conceded on the delivery. If no penalty runs were conceded this will be blank.
wicket_type string If a wicket fell on this delivery then this will be the kind of dismissal that took place. This will be one of bowled, caught, caught and bowled, lbw, stumped, run out, retired hurt, hit wicket, obstructing the field, hit the ball twice, handled the ball, or timed out. If no dismissals took place this will be an empty string.
player_dismissed string If a wicket fell on this delivery then this will be the name of the dismissed player. If no dismissals took place this will be an empty string.
other_wicket_type string If a second wicket occurs on the delivery (such as due to a player retiring hurt when another wicket falls) this will be the type of the dismissal, one of bowled, caught, caught and bowled, lbw, stumped, run out, retired hurt, hit wicket, obstructing the field, hit the ball twice, handled the ball, or timed out. If no dismissals took place this will be an empty string.
other_player_dismissed string If a second wicket fell on this delivery then this will be the name of the second dismissed player. If no dismissals took place this will be an empty string.