All recently added Men's match data in CSV format
=================================================

The background
--------------

As an experiment, after being asked by a user of the site, I started
converting the YAML data provided on the site into a CSV format. That
initial version was heavily influenced by the format used by the baseball
project Retrosheet. I wasn't sure of the usefulness of my CSV format, but
nothing better was suggested so I persisted with it. Later Ashwin Raman
(https://twitter.com/AshwinRaman_) send me a detailed example of a format
he felt might work and, liking what I saw, I started to produce data in
a slightly modified version of that initial example.

This particular zip folder contains the CSV data for...
  All recently added Men's matches
...for which we have data.

How you can help
----------------

Providing feedback on the data would be the most helpful. Tell me what you
like and what you don't. Is there anything that is in the JSON data that
you'd like to be included in the CSV? Could something be included in a better
format? General views and comments help, as well as incredibly detailed
feedback. All information is of use to me at this stage. I can only improve
the data if people tell me what does works and what doesn't. I'd like to make
the data as useful as possible but I need your help to do it. Also, which of
the 2 CSV formats do you prefer, this one or the original? Ideally I'd like
to settle on a single CSV format so what should be kept from each?

Finally, any feedback as to the licence the data should be released under
would be greatly appreciated. Licensing is a strange little world and I'd
like to choose the "right" licence. My basic criteria may be that:

  * the data should be free,
  * corrections are encouraged/required to be reported to the project,
  * derivative works are allowed,
  * you can't just take data and sell it.

Feedback, pointers, comments, etc on licensing are welcome.

The format of the data
----------------------

Full documentation of this CSV format can be found at:
  https://cricsheet.org/format/csv_ashwin/
but the following is a brief summary of the details...

This format consists of 2 files per match, although you can get all of
the ball-by-ball data from just one of the files. The files for a match
are named <id>.csv (for the ball-by-ball data), and <id>_info.csv (for
the match info), where <id> is the Cricinfo id for the match. The
ball-by-ball file contains one row per delivery in the match, while the
match info file contains match information such as dates the match was
played, the outcome, and lists of the players involved in the match.

The match info file format
--------------------------

The info section contains the information on the actual match, such as
when and where it was played, any event 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.

The ball-by-ball file format
----------------------------

The first row of each ball-by-ball CSV file contains the headers for the
file, with each subsequent row providing details on a single delivery.
The headers in the file are:

  * match_id
  * season
  * start_date
  * venue
  * innings
  * ball
  * batting_team
  * bowling_team
  * striker
  * non_striker
  * bowler
  * runs_off_bat
  * extras
  * wides
  * noballs
  * byes
  * legbyes
  * penalty
  * wicket_type
  * player_dismissed
  * other_wicket_type
  * other_player_dismissed

Most of the fields above should, hopefully, be self-explanatory, but some may
benefit from clarification...

"innings" contains the number of the innings within the match. If a match is
one that would normally have 2 innings, such as a T20 or ODI, then any innings
of more than 2 can be regarded as a super over.

"ball" is a combination of the over and delivery. For example, "0.3" represents
the 3rd ball of the 1st over.

"wides", "noballs", "byes", "legbyes", and "penalty" contain the total of each
particular type of extras, or are blank if not relevant to the delivery.

If a wicket occurred on a delivery then "wicket_type" will contain the method
of dismissal, while "player_dismissed" will indicate who was dismissed. There
is also the, admittedly remote, possibility that a second dismissal can be
recorded on the delivery (such as when a player retires on the same delivery
as another dismissal occurs). In this case "other_wicket_type" will record
the reason, while "other_player_dismissed" will show who was dismissed.

Matches included in this archive
--------------------------------

2026-05-29 - international - T20 - male - 1535430 - Kenya vs Botswana
2026-05-29 - international - T20 - male - 1535429 - Ivory Coast vs Sierra Leone
2026-05-29 - international - T20 - male - 1535428 - Cameroon vs Mali
2026-05-28 - international - T20 - male - 1535427 - Cameroon vs Kenya
2026-05-28 - international - T20 - male - 1535426 - Sierra Leone vs Rwanda
2026-05-28 - international - T20 - male - 1535425 - Botswana vs Ivory Coast
2026-05-27 - international - Test - male - 1528547 - New Zealand vs Ireland
2026-05-27 - club - NTB - male - 1512793 - Derbyshire vs Leicestershire
2026-05-27 - club - IPL - male - 1535463 - Rajasthan Royals vs Sunrisers Hyderabad
2026-05-26 - international - T20 - male - 1535424 - Cameroon vs Ivory Coast
2026-05-26 - international - T20 - male - 1535423 - Kenya vs Sierra Leone
2026-05-26 - international - T20 - male - 1535422 - Mali vs Rwanda
2026-05-26 - club - NTB - male - 1512792 - Hampshire vs Essex
2026-05-26 - club - IPL - male - 1535462 - Royal Challengers Bengaluru vs Gujarat Titans
2026-05-25 - international - T20 - male - 1535421 - Ivory Coast vs Mali
2026-05-25 - international - T20 - male - 1535420 - Botswana vs Cameroon
2026-05-25 - international - T20 - male - 1535419 - Kenya vs Rwanda
2026-05-25 - club - NTB - male - 1512791 - Sussex vs Kent
2026-05-25 - club - NTB - male - 1512790 - Lancashire vs Nottinghamshire
2026-05-24 - international - T20 - male - 1535418 - Sierra Leone vs Cameroon
2026-05-24 - international - T20 - male - 1535417 - Mali vs Botswana
2026-05-24 - international - T20 - male - 1535416 - Rwanda vs Ivory Coast
2026-05-24 - club - NTB - male - 1512789 - Northamptonshire vs Worcestershire
2026-05-24 - club - NTB - male - 1512788 - Middlesex vs Surrey
2026-05-24 - club - NTB - male - 1512787 - Derbyshire vs Yorkshire
2026-05-24 - club - NTB - male - 1512786 - Birmingham Bears vs Somerset
2026-05-24 - club - NTB - male - 1512785 - Leicestershire vs Durham
2026-05-24 - club - IPL - male - 1529313 - Delhi Capitals vs Kolkata Knight Riders
2026-05-24 - club - IPL - male - 1529312 - Rajasthan Royals vs Mumbai Indians
2026-05-23 - international - T20 - male - 1535415 - Kenya vs Mali
2026-05-23 - international - T20 - male - 1535414 - Botswana vs Sierra Leone
2026-05-23 - international - T20 - male - 1535413 - Cameroon vs Rwanda
2026-05-23 - international - T20 - male - 1534061 - Guernsey vs Jersey
2026-05-23 - international - T20 - male - 1534060 - Croatia vs Austria
2026-05-23 - international - T20 - male - 1534059 - Malta vs Switzerland
2026-05-23 - international - T20 - male - 1534058 - France vs Sweden
2026-05-23 - club - NTB - male - 1512784 - Glamorgan vs Gloucestershire
2026-05-23 - club - IPL - male - 1529311 - Lucknow Super Giants vs Punjab Kings
2026-05-22 - international - T20 - male - 1534057 - Slovenia vs Malta
2026-05-22 - international - T20 - male - 1534056 - Croatia vs Cyprus
2026-05-22 - international - T20 - male - 1534055 - Austria vs Sweden
2026-05-22 - international - T20 - male - 1534054 - France vs Switzerland
2026-05-22 - international - ODI - male - 1531707 - Nepal vs United States of America
2026-05-22 - club - NTB - male - 1512783 - Worcestershire vs Leicestershire
2026-05-22 - club - NTB - male - 1512782 - Nottinghamshire vs Yorkshire
2026-05-22 - club - NTB - male - 1512781 - Gloucestershire vs Birmingham Bears
2026-05-22 - club - NTB - male - 1512780 - Northamptonshire vs Glamorgan
2026-05-22 - club - NTB - male - 1512779 - Hampshire vs Somerset
2026-05-22 - club - NTB - male - 1512778 - Durham vs Derbyshire
2026-05-22 - club - NTB - male - 1512777 - Kent vs Middlesex
2026-05-22 - club - NTB - male - 1512776 - Surrey vs Lancashire
2026-05-22 - club - NTB - male - 1512775 - Essex vs Sussex
2026-05-22 - club - IPL - male - 1529310 - Sunrisers Hyderabad vs Royal Challengers Bengaluru
2026-05-21 - club - IPL - male - 1529309 - Gujarat Titans vs Chennai Super Kings
2026-05-20 - international - T20 - male - 1534053 - Jersey vs Croatia
2026-05-20 - international - T20 - male - 1534052 - Sweden vs Malta
2026-05-20 - international - T20 - male - 1534051 - Switzerland vs Cyprus
2026-05-20 - international - T20 - male - 1534050 - Slovenia vs Guernsey
2026-05-20 - international - ODI - male - 1531706 - Scotland vs United States of America
2026-05-20 - club - IPL - male - 1529308 - Mumbai Indians vs Kolkata Knight Riders
2026-05-19 - international - T20 - male - 1534049 - Guernsey vs Austria
2026-05-19 - international - T20 - male - 1534048 - Croatia vs Switzerland
2026-05-19 - international - T20 - male - 1534047 - Slovenia vs Sweden
2026-05-19 - international - T20 - male - 1534046 - France vs Jersey
2026-05-19 - club - IPL - male - 1529307 - Lucknow Super Giants vs Rajasthan Royals
2026-05-18 - international - T20 - male - 1532663 - Japan vs Papua New Guinea
2026-05-18 - international - T20 - male - 1532662 - Cook Islands vs Samoa
2026-05-18 - international - ODI - male - 1531705 - Scotland vs Nepal
2026-05-18 - club - IPL - male - 1529306 - Chennai Super Kings vs Sunrisers Hyderabad
2026-05-17 - international - T20 - male - 1534045 - Jersey vs Cyprus
2026-05-17 - international - T20 - male - 1534044 - Slovenia vs Austria
2026-05-17 - international - T20 - male - 1534043 - France vs Croatia
2026-05-17 - international - T20 - male - 1534042 - Malta vs Guernsey
2026-05-17 - international - T20 - male - 1532660 - Papua New Guinea vs Vanuatu
2026-05-17 - international - T20 - male - 1532659 - Cook Islands vs Indonesia
2026-05-17 - international - T20 - male - 1532658 - Fiji vs South Korea
2026-05-17 - club - IPL - male - 1529305 - Rajasthan Royals vs Delhi Capitals
2026-05-17 - club - IPL - male - 1529304 - Royal Challengers Bengaluru vs Punjab Kings
2026-05-16 - international - Test - male - 1532487 - Bangladesh vs Pakistan
2026-05-16 - international - T20 - male - 1534041 - Malta vs Austria
2026-05-16 - international - T20 - male - 1534040 - Switzerland vs Jersey
2026-05-16 - international - T20 - male - 1534039 - Guernsey vs Sweden
2026-05-16 - international - T20 - male - 1534038 - Cyprus vs France
2026-05-16 - international - T20 - male - 1532657 - Philippines vs South Korea
2026-05-16 - international - T20 - male - 1532656 - Samoa vs Japan
2026-05-16 - international - T20 - male - 1532655 - Vanuatu vs Indonesia
2026-05-16 - international - ODI - male - 1531704 - United States of America vs Nepal
2026-05-16 - club - IPL - male - 1529303 - Kolkata Knight Riders vs Gujarat Titans
2026-05-15 - club - IPL - male - 1529302 - Chennai Super Kings vs Lucknow Super Giants
2026-05-15 - club - CCH - male - 1513419 - Worcestershire vs Lancashire
2026-05-15 - club - CCH - male - 1513418 - Middlesex vs Derbyshire
2026-05-15 - club - CCH - male - 1513417 - Gloucestershire vs Northamptonshire
2026-05-15 - club - CCH - male - 1513416 - Kent vs Durham
2026-05-15 - club - CCH - male - 1513355 - Somerset vs Sussex
2026-05-15 - club - CCH - male - 1513354 - Yorkshire vs Surrey
2026-05-15 - club - CCH - male - 1513353 - Glamorgan vs Warwickshire
2026-05-15 - club - CCH - male - 1513352 - Hampshire vs Nottinghamshire
2026-05-15 - club - CCH - male - 1513351 - Leicestershire vs Essex
2026-05-14 - international - T20 - male - 1532654 - Japan vs Cook Islands
2026-05-14 - international - T20 - male - 1532653 - Papua New Guinea vs Indonesia
2026-05-14 - international - T20 - male - 1532652 - Fiji vs Philippines
2026-05-14 - international - ODI - male - 1531703 - Scotland vs United States of America
2026-05-14 - club - IPL - male - 1529301 - Punjab Kings vs Mumbai Indians
2026-05-13 - international - T20 - male - 1532651 - Cook Islands vs Vanuatu
2026-05-13 - international - T20 - male - 1532650 - Samoa vs Papua New Guinea
2026-05-13 - international - T20 - male - 1532649 - Fiji vs South Korea
2026-05-13 - club - IPL - male - 1529300 - Kolkata Knight Riders vs Royal Challengers Bengaluru
2026-05-12 - international - T20 - male - 1532648 - Japan vs Indonesia
2026-05-12 - international - T20 - male - 1532647 - Philippines vs South Korea
2026-05-12 - international - T20 - male - 1532646 - Vanuatu vs Samoa
2026-05-12 - international - ODI - male - 1531702 - Scotland vs Nepal
2026-05-12 - club - IPL - male - 1529299 - Gujarat Titans vs Sunrisers Hyderabad
2026-05-11 - club - IPL - male - 1529298 - Punjab Kings vs Delhi Capitals
2026-05-10 - international - T20 - male - 1534594 - Romania vs Bulgaria
2026-05-10 - international - T20 - male - 1532645 - Papua New Guinea vs Cook Islands
2026-05-10 - international - T20 - male - 1532644 - Fiji vs Japan
2026-05-10 - international - T20 - male - 1532643 - Samoa vs Philippines
2026-05-10 - club - IPL - male - 1529297 - Mumbai Indians vs Royal Challengers Bengaluru
2026-05-10 - club - IPL - male - 1529296 - Lucknow Super Giants vs Chennai Super Kings
2026-05-09 - international - T20 - male - 1534592 - Romania vs Bulgaria
2026-05-09 - international - T20 - male - 1534591 - Romania vs Bulgaria
2026-05-09 - international - T20 - male - 1533400 - Finland vs Cyprus
2026-05-09 - international - T20 - male - 1533399 - Finland vs Cyprus
2026-05-09 - international - T20 - male - 1532642 - Papua New Guinea vs South Korea
2026-05-09 - international - T20 - male - 1532641 - Japan vs Vanuatu
2026-05-09 - international - T20 - male - 1532640 - Indonesia vs Samoa
2026-05-09 - international - T20 - male - 1531873 - Malta vs Gibraltar
2026-05-09 - international - T20 - male - 1531685 - Gibraltar vs Malta
2026-05-09 - club - IPL - male - 1529295 - Gujarat Titans vs Rajasthan Royals
2026-05-08 - international - Test - male - 1532486 - Bangladesh vs Pakistan
2026-05-08 - international - T20 - male - 1534590 - Romania vs Bulgaria
2026-05-08 - international - T20 - male - 1533398 - Cyprus vs Finland
2026-05-08 - international - T20 - male - 1533397 - Cyprus vs Finland
2026-05-08 - international - T20 - male - 1532639 - South Korea vs Cook Islands
2026-05-08 - international - T20 - male - 1532638 - Vanuatu vs Fiji
2026-05-08 - international - T20 - male - 1532637 - Indonesia vs Philippines
2026-05-08 - international - T20 - male - 1531684 - Malta vs Gibraltar
2026-05-08 - international - T20 - male - 1531683 - Gibraltar vs Malta
2026-05-08 - club - IPL - male - 1529294 - Delhi Capitals vs Kolkata Knight Riders
2026-05-08 - club - CCH - male - 1513415 - Lancashire vs Middlesex
2026-05-08 - club - CCH - male - 1513414 - Worcestershire vs Durham
2026-05-08 - club - CCH - male - 1513413 - Gloucestershire vs Kent
2026-05-08 - club - CCH - male - 1513412 - Derbyshire vs Northamptonshire
2026-05-08 - club - CCH - male - 1513350 - Leicestershire vs Sussex
2026-05-08 - club - CCH - male - 1513349 - Somerset vs Glamorgan
2026-05-08 - club - CCH - male - 1513348 - Nottinghamshire vs Surrey
2026-05-08 - club - CCH - male - 1513347 - Warwickshire vs Yorkshire
2026-05-08 - club - CCH - male - 1513346 - Hampshire vs Essex
2026-05-07 - international - T20 - male - 1531682 - Malta vs Gibraltar
2026-05-07 - international - T20 - male - 1531681 - Malta vs Gibraltar
2026-05-07 - club - IPL - male - 1529293 - Lucknow Super Giants vs Royal Challengers Bengaluru
2026-05-06 - club - IPL - male - 1529292 - Sunrisers Hyderabad vs Punjab Kings
2026-05-05 - international - T20 - male - 1533393 - Indonesia vs Malaysia
2026-05-05 - international - ODI - male - 1531701 - Nepal vs Oman
2026-05-05 - club - IPL - male - 1529291 - Delhi Capitals vs Chennai Super Kings
2026-05-04 - international - T20 - male - 1533392 - Malaysia vs Indonesia
2026-05-04 - club - IPL - male - 1529290 - Lucknow Super Giants vs Mumbai Indians
2026-05-03 - international - T20 - male - 1533396 - Guernsey vs Isle of Man
2026-05-03 - international - T20 - male - 1533395 - Guernsey vs Isle of Man
2026-05-03 - international - T20 - male - 1533389 - Austria vs Germany
2026-05-03 - international - ODI - male - 1531700 - United Arab Emirates vs Oman
2026-05-03 - club - PSL - male - 1527595 - Hyderabad Kingsmen vs Peshawar Zalmi
2026-05-03 - club - IPL - male - 1529289 - Punjab Kings vs Gujarat Titans
2026-05-03 - club - IPL - male - 1529288 - Sunrisers Hyderabad vs Kolkata Knight Riders
2026-05-02 - international - T20 - male - 1533394 - Isle of Man vs Guernsey
2026-05-02 - international - T20 - male - 1533391 - Malaysia vs Indonesia
2026-05-02 - international - T20 - male - 1533387 - Germany vs Austria
2026-05-02 - international - T20 - male - 1528277 - Bangladesh vs New Zealand
2026-05-02 - club - IPL - male - 1529287 - Mumbai Indians vs Chennai Super Kings
2026-05-01 - international - T20 - male - 1533390 - Indonesia vs Malaysia
2026-05-01 - international - T20 - male - 1533386 - Austria vs Germany
2026-05-01 - international - T20 - male - 1533385 - Germany vs Austria
2026-05-01 - international - ODI - male - 1531699 - Nepal vs United Arab Emirates
2026-05-01 - club - PSL - male - 1527594 - Hyderabad Kingsmen vs Islamabad United
2026-05-01 - club - IPL - male - 1529286 - Rajasthan Royals vs Delhi Capitals
2026-05-01 - club - CCH - male - 1513411 - Middlesex vs Durham
2026-05-01 - club - CCH - male - 1513410 - Worcestershire vs Northamptonshire
2026-05-01 - club - CCH - male - 1513409 - Kent vs Derbyshire
2026-05-01 - club - CCH - male - 1513345 - Nottinghamshire vs Leicestershire
2026-05-01 - club - CCH - male - 1513344 - Yorkshire vs Somerset
2026-05-01 - club - CCH - male - 1513343 - Glamorgan vs Hampshire
2026-05-01 - club - CCH - male - 1513342 - Sussex vs Surrey
2026-04-30 - club - IPL - male - 1529285 - Royal Challengers Bengaluru vs Gujarat Titans
2026-04-29 - international - ODI - male - 1531698 - Oman vs Nepal
2026-04-29 - club - PSL - male - 1527593 - Multan Sultans vs Hyderabad Kingsmen
2026-04-29 - club - IPL - male - 1529284 - Mumbai Indians vs Sunrisers Hyderabad

Further information
-------------------

You can find all of our currently available data at https://cricsheet.org/

You can contact me via the following methods:
  Email   : stephen@cricsheet.org
  Mastodon: @cricsheet@deeden.co.uk
