Cricket Test Matches Inningswise Between 1900-2021
2200+ Tests after removing ~120 outlier matches & streamlining to 6-ball overs
@kaggle.abhijeet0706_cricket_test_match_inningswise_between_19002021
Testmatches Dataset
@kaggle.abhijeet0706_cricket_test_match_inningswise_between_19002021.testmatches_dataset
- 128.48 KB
- 8291 rows
- 14 columns
matchkeyMatchKey | battingteamBattingTeam | scoreScore | wicketsWickets | inningsresultInningsResult | oversOvers | rpoRPO | leadLead | innsInns | resultResult | oppositionOpposition | hostcountryHostCountry | startdateStartDate | unnamed_13Unnamed: 13 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | England | 464 | 10 | End | 186 | 2.49 | 464 | 1 | won | Australia | Australia | Fri Dec 13 1901 00:00:00 GMT+0000 (Coordinated Universal Time) | |
| 1 | Australia | 168 | 10 | End | 72.1 | 2.33 | -296 | 2 | lost | England | Australia | Fri Dec 13 1901 00:00:00 GMT+0000 (Coordinated Universal Time) | |
| 1 | Australia | 172 | 10 | End | 57.4 | 3 | -124 | 3 | lost | England | Australia | Fri Dec 13 1901 00:00:00 GMT+0000 (Coordinated Universal Time) | |
| 2 | Australia | 112 | 10 | End | 32.1 | 3.49 | 112 | 1 | won | England | Australia | Wed Jan 01 1902 00:00:00 GMT+0000 (Coordinated Universal Time) | |
| 2 | England | 61 | 10 | End | 15.4 | 3.96 | -51 | 2 | lost | Australia | Australia | Wed Jan 01 1902 00:00:00 GMT+0000 (Coordinated Universal Time) | |
| 2 | Australia | 353 | 10 | End | 156.2 | 2.26 | 404 | 3 | won | England | Australia | Wed Jan 01 1902 00:00:00 GMT+0000 (Coordinated Universal Time) | |
| 2 | England | 175 | 10 | End | 79.5 | 2.2 | -229 | 4 | lost | Australia | Australia | Wed Jan 01 1902 00:00:00 GMT+0000 (Coordinated Universal Time) | |
| 3 | England | 388 | 10 | End | 170 | 2.28 | 388 | 1 | lost | Australia | Australia | Fri Jan 17 1902 00:00:00 GMT+0000 (Coordinated Universal Time) | |
| 3 | Australia | 321 | 10 | End | 113 | 2.84 | -67 | 2 | won | England | Australia | Fri Jan 17 1902 00:00:00 GMT+0000 (Coordinated Universal Time) | |
| 3 | England | 247 | 10 | End | 111 | 2.23 | 314 | 3 | lost | Australia | Australia | Fri Jan 17 1902 00:00:00 GMT+0000 (Coordinated Universal Time) |
CREATE TABLE testmatches_dataset (
"matchkey" BIGINT,
"battingteam" VARCHAR,
"score" BIGINT,
"wickets" BIGINT,
"inningsresult" VARCHAR,
"overs" DOUBLE,
"rpo" VARCHAR,
"lead" BIGINT,
"inns" BIGINT,
"result" VARCHAR,
"opposition" VARCHAR,
"hostcountry" VARCHAR,
"startdate" TIMESTAMP,
"unnamed_13" VARCHAR
);