Crickbuzz Cricket Dataset

This is a Dataset of different cricket matches at various locations

@kaggle.piyushchaudhari99_crickbuzz_cricket_dataset

Table List

1 table(57.81 KB)

Cricket Data

@kaggle.piyushchaudhari99_crickbuzz_cricket_dataset.cricket_data

57.81 KB
202 rows
48 columns

matchid MatchID	seriesid SeriesID	seriesname SeriesName	matchdescription MatchDescription	matchformat MatchFormat	startdate StartDate	enddate EndDate	state State	status Status	teamid TeamID	teamname TeamName	team1name Team1Name	team1imageid Team1imageID	team2teamid Team2teamId	team2name Team2Name	team2name_1 Team2Name.1	team2imageid Team2imageId	venueinfoid VenueInfoid	venueinfoground VenueInfoground	city City	timezone Timezone	latitude Latitude	longitude Longitude	currbatteamid CurrBatTeamId	seriesstartdt SeriesStartDt	seriesenddt SeriesEndDt	istimeannounced IsTimeAnnounced	statetitle StateTitle	inngs1inningsid Inngs1inningsId	inngs1runs Inngs1runs	inngs1wickets Inngs1wickets	inngs1overs Inngs1overs	inngs2inningsid Inngs2inningsId	inngs2runs Inngs2runs	inngs2wickets Inngs2wickets	inngs2overs Inngs2overs	inngs1inningsid_1 Inngs1inningsId.1	inngs1runs_1 Inngs1runs.1	inngs1wickets_1 Inngs1wickets.1	inngs1overs_1 Inngs1overs.1	inningsid InningsId	inngs2runs_1 Inngs2runs.1	inngs2wickets_1 Inngs2wickets.1	inngs2overs_1 Inngs2overs.1	inngs2isdeclared Inngs2isDeclared	inngs1isdeclared Inngs1isDeclared	inngs2isfollowon Inngs2isFollowOn	inngs1isdeclared_1 Inngs1isDeclared.1
78635	6927	England tour of India, 2024	2nd Test	TEST	1706846400000	1707217200000	Complete	India won by 106 runs	2	India	IND	172115	9	England	ENG	172123	154	Dr. Y.S. Rajasekhara Reddy ACA-VDCA Cricket Stadium	Visakhapatnam	+05:30	17.797459	83.352254	2	1706140800000	1710288000000	true	IND Won	1	396	10	111.6	3	255	10	78.3	2	253	10	55.5	4	292	10	69.2	nan	nan	nan	nan
78082	6892	South Africa tour of New Zealand, 2024	2nd Test	TEST	1707775200000	1708146000000	Complete	New Zealand won by 7 wkts	11	South Africa	RSA	172126	13	New Zealand	NZ	172128	100	Seddon Park	Hamilton	+13:00	-37.786654	175.266647	13	1706486400000	1708300800000	true	NZ Won	1	242	10	97.2	3	235	10	69.5	2	211	10	77.3	4	269	3	94.2	nan	nan	nan	nan
78075	6892	South Africa tour of New Zealand, 2024	1st Test	TEST	1706997600000	1707368400000	Complete	New Zealand won by 281 runs	13	New Zealand	NZ	172128	11	South Africa	RSA	172126	393	Bay Oval	Mount Maunganui	+13:00	-37.6703	176.212006	13	1706486400000	1708300800000	true	NZ Won	1	511	10	143.6	3	179	4	42.6	2	162	10	72.5	4	247	10	79.6	True	nan	nan	nan
87901	7481	Afghanistan tour of Sri Lanka, 2024	1st T20I	T20	1708176600000	1708189200000	Complete	Sri Lanka won by 4 runs	5	Sri Lanka	SL	172119	96	Afghanistan	AFG	172188	13	Rangiri Dambulla International Stadium	Dambulla	+05:30	7.859556	80.634026	5	1706832000000	1708646400000	true	SL Won	1	160	10	18.6					2	156	9	19.6					nan	nan	nan	nan
87897	7481	Afghanistan tour of Sri Lanka, 2024	3rd ODI	ODI	1707901200000	1707930000000	Complete	Sri Lanka won by 7 wkts	96	Afghanistan	AFG	172188	5	Sri Lanka	SL	172119	254	Pallekele International Cricket Stadium	Pallekele	+05:30	7.280691	80.722493	5	1706832000000	1708646400000	true	SL Won	1	266	10	48.2					2	267	3	35.2					nan	nan	nan	nan
87894	7481	Afghanistan tour of Sri Lanka, 2024	2nd ODI	ODI	1707642000000	1707670800000	Complete	Sri Lanka won by 155 runs	5	Sri Lanka	SL	172119	96	Afghanistan	AFG	172188	254	Pallekele International Cricket Stadium	Pallekele	+05:30	7.280691	80.722493	5	1706832000000	1708646400000	true	SL Won	1	308	6	49.6					2	153	10	33.5					nan	nan	nan	nan
87887	7481	Afghanistan tour of Sri Lanka, 2024	1st ODI	ODI	1707469200000	1707498000000	Complete	Sri Lanka won by 42 runs	5	Sri Lanka	SL	172119	96	Afghanistan	AFG	172188	254	Pallekele International Cricket Stadium	Pallekele	+05:30	7.280691	80.722493	5	1706832000000	1708646400000	true	SL Won	1	381	3	49.6					2	339	6	49.6					nan	nan	nan	nan
87880	7481	Afghanistan tour of Sri Lanka, 2024	Only Test	TEST	1706848200000	1707219000000	Complete	Sri Lanka won by 10 wkts	96	Afghanistan	AFG	172188	5	Sri Lanka	SL	172119	14	Sinhalese Sports Club	Colombo	+05:30	6.905929	79.869403	5	1706832000000	1708646400000	true	SL Won	1	198	10	62.4	3	296	10	112.3	2	439	10	109.2	4	56		7.2	nan	nan	nan	nan
89040	7553	Canada tour of Nepal, 2024	3rd ODI	ODI	1707708600000	1707737400000	Complete	Nepal won by 9 wkts	26	Canada	CAN	172140	72	Nepal	NEP	172169	458	Tribhuvan University International Cricket Ground	Kirtipur	+05:45	27.6768145	85.287199	72	1707350400000	1707868800000	true	NEP Won	1	232	8	49.6					2	234	1	44.3					nan	nan	nan	nan
89033	7553	Canada tour of Nepal, 2024	2nd ODI	ODI	1707535800000	1707564600000	Complete	Nepal won by 4 wkts	26	Canada	CAN	172140	72	Nepal	NEP	172169	458	Tribhuvan University International Cricket Ground	Kirtipur	+05:45	27.6768145	85.287199	72	1707350400000	1707868800000	true	NEP Won	1	285	9	49.6					2	287	6	45.1					nan	nan	nan	nan


CREATE TABLE cricket_data (
  "matchid" DOUBLE,
  "seriesid" DOUBLE,
  "seriesname" VARCHAR,
  "matchdescription" VARCHAR,
  "matchformat" VARCHAR,
  "startdate" BIGINT,
  "enddate" BIGINT,
  "state" VARCHAR,
  "status" VARCHAR,
  "teamid" DOUBLE,
  "teamname" VARCHAR,
  "team1name" VARCHAR,
  "team1imageid" DOUBLE,
  "team2teamid" DOUBLE,
  "team2name" VARCHAR,
  "team2name_1" VARCHAR,
  "team2imageid" DOUBLE,
  "venueinfoid" DOUBLE,
  "venueinfoground" VARCHAR,
  "city" VARCHAR,
  "timezone" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "currbatteamid" DOUBLE,
  "seriesstartdt" BIGINT,
  "seriesenddt" BIGINT,
  "istimeannounced" BOOLEAN,
  "statetitle" VARCHAR,
  "inngs1inningsid" DOUBLE,
  "inngs1runs" DOUBLE,
  "inngs1wickets" DOUBLE,
  "inngs1overs" DOUBLE,
  "inngs2inningsid" DOUBLE,
  "inngs2runs" DOUBLE,
  "inngs2wickets" DOUBLE,
  "inngs2overs" DOUBLE,
  "inngs1inningsid_1" DOUBLE,
  "inngs1runs_1" DOUBLE,
  "inngs1wickets_1" DOUBLE,
  "inngs1overs_1" DOUBLE,
  "inningsid" DOUBLE,
  "inngs2runs_1" DOUBLE,
  "inngs2wickets_1" DOUBLE,
  "inngs2overs_1" DOUBLE,
  "inngs2isdeclared" VARCHAR,
  "inngs1isdeclared" VARCHAR,
  "inngs2isfollowon" VARCHAR,
  "inngs1isdeclared_1" VARCHAR
);