System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'StatusId'. Invalid column name 'ErrorLog'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Etoz.ConnectData.DataAccess.ExecuteQuery(String query) in c:\inetpub\wwwroot\cricdirect.com\api\v6\App_Code\db\data_access.cs:line 117 ClientConnectionId:20d720e2-7c5b-498d-9ead-b5201c39c8db Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 88140 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (88140,1,'{"status":"ok","response":{"mid":88140,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Yorkshire won by 10 wickets","day_remaining_over":"37.5","team_batting":"Yorkshire","team_bowling":"Essex","live_inning_number":4,"live_score":{"runs":41,"overs":9,"wickets":0,"target":41,"runrate":4.56,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Adam Lyth","batsman_id":10610,"runs":15,"balls_faced":26,"fours":2,"sixes":0,"strike_rate":"57.69"},{"name":"Finlay Bean","batsman_id":95593,"runs":18,"balls_faced":32,"fours":3,"sixes":0,"strike_rate":"56.25"}],"bowlers":[{"name":"Noah Thain","bowler_id":127517,"overs":1,"runs_conceded":9,"wickets":0,"maidens":0,"econ":"9.00"},{"name":"Syed Khaleel Ahmed","bowler_id":1106,"overs":4,"runs_conceded":24,"wickets":0,"maidens":1,"econ":"6.00"}],"commentaries":[{"event":"overend","over":5,"runs":0,"score":"13\/0","bats":[{"runs":8,"balls_faced":20,"fours":1,"sixes":0,"batsman_id":95593},{"runs":1,"balls_faced":12,"fours":0,"sixes":0,"batsman_id":10610}],"bowls":[{"runs_conceded":5,"maidens":1,"wickets":0,"bowler_id":61358,"overs":3},{"runs_conceded":6,"maidens":1,"wickets":0,"bowler_id":1106,"overs":2}],"commentary":"End of over 5 (0 runs), Yorkshire 13\/0"},{"event_id":"12273793","event":"ball","batsman_id":"10610","bowler_id":"1106","over":"5","ball":"1","score":0,"commentary":"Syed Khaleel Ahmed to Adam Lyth, no run,","noball_dismissal":false,"text":"","timestamp":1751470421,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12273796","event":"ball","batsman_id":"10610","bowler_id":"1106","over":"5","ball":"2","score":"2nb","commentary":"Syed Khaleel Ahmed to Adam Lyth, 2 no ball,","noball_dismissal":false,"text":"","timestamp":1751470425,"run":2,"noball_run":"1","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":true,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12273798","event":"ball","batsman_id":"10610","bowler_id":"1106","over":"5","ball":"2","score":4,"commentary":"Syed Khaleel Ahmed to Adam Lyth, Four,","noball_dismissal":false,"text":"","timestamp":1751470427,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12273799","event":"ball","batsman_id":"10610","bowler_id":"1106","over":"5","ball":"3","score":1,"commentary":"Syed Khaleel Ahmed to Adam Lyth, 1 run,","noball_dismissal":false,"text":"","timestamp":1751470431,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12273801","event":"ball","batsman_id":"95593","bowler_id":"1106","over":"5","ball":"4","score":0,"commentary":"Syed Khaleel Ahmed to Finlay Bean, no run,","noball_dismissal":false,"text":"","timestamp":1751470434,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12273803","event":"ball","batsman_id":"95593","bowler_id":"1106","over":"5","ball":"5","score":0,"commentary":"Syed Khaleel Ahmed to Finlay Bean, no run,","noball_dismissal":false,"text":"","timestamp":1751470460,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12273836","event":"ball","batsman_id":"95593","bowler_id":"1106","over":"5","ball":"6","score":"2nb","commentary":"Syed Khaleel Ahmed to Finlay Bean, 2 no ball,","noball_dismissal":false,"text":"","timestamp":1751470463,"run":2,"noball_run":"1","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":true,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12273839","event":"ball","batsman_id":"95593","bowler_id":"1106","over":"5","ball":"6","score":4,"commentary":"Syed Khaleel Ahmed to Finlay Bean, Four,","noball_dismissal":false,"text":"","timestamp":1751470467,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event":"overend","over":6,"runs":13,"score":"26\/0","bats":[{"runs":12,"balls_faced":24,"fours":2,"sixes":0,"batsman_id":95593},{"runs":6,"balls_faced":16,"fours":1,"sixes":0,"batsman_id":10610}],"bowls":[{"runs_conceded":17,"maidens":1,"wickets":0,"bowler_id":1106,"overs":3},{"runs_conceded":5,"maidens":1,"wickets":0,"bowler_id":61358,"overs":3}],"commentary":"End of over 6 (13 runs), Yorkshire 26\/0"},{"event_id":"12273856","event":"ball","batsman_id":"10610","bowler_id":"61358","over":"6","ball":"1","score":0,"commentary":"Shane Snater to Adam Lyth, no run,","noball_dismissal":false,"text":"","timestamp":1751470541,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12273857","event":"ball","batsman_id":"10610","bowler_id":"61358","over":"6","ball":"2","score":2,"commentary":"Shane Snater to Adam Lyth, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751470546,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12273859","event":"ball","batsman_id":"10610","bowler_id":"61358","over":"6","ball":"3","score":0,"commentary":"Shane Snater to Adam Lyth, no run,","noball_dismissal":false,"text":"","timestamp":1751470549,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12273861","event":"ball","batsman_id":"10610","bowler_id":"61358","over":"6","ball":"4","score":0,"commentary":"Shane Snater to Adam Lyth, no run,","noball_dismissal":false,"text":"","timestamp":1751470553,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12273862","event":"ball","batsman_id":"10610","bowler_id":"61358","over":"6","ball":"5","score":0,"commentary":"Shane Snater to Adam Lyth, no run,","noball_dismissal":false,"text":"","timestamp":1751470556,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12273863","event":"ball","batsman_id":"10610","bowler_id":"61358","over":"6","ball":"6","score":0,"commentary":"Shane Snater to Adam Lyth, no run,","noball_dismissal":false,"text":"","timestamp":1751470560,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":7,"runs":2,"score":"28\/0","bats":[{"runs":8,"balls_faced":22,"fours":1,"sixes":0,"batsman_id":10610},{"runs":12,"balls_faced":24,"fours":2,"sixes":0,"batsman_id":95593}],"bowls":[{"runs_conceded":7,"maidens":1,"wickets":0,"bowler_id":61358,"overs":4},{"runs_conceded":17,"maidens":1,"wickets":0,"bowler_id":1106,"overs":3}],"commentary":"End of over 7 (2 runs), Yorkshire 28\/0"},{"event_id":"12273912","event":"ball","batsman_id":"95593","bowler_id":"1106","over":"7","ball":"1","score":0,"commentary":"Syed Khaleel Ahmed to Finlay Bean, no run,","noball_dismissal":false,"text":"","timestamp":1751470791,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12273913","event":"ball","batsman_id":"95593","bowler_id":"1106","over":"7","ball":"2","score":0,"commentary":"Syed Khaleel Ahmed to Finlay Bean, no run,","noball_dismissal":false,"text":"","timestamp":1751470794,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12273915","event":"ball","batsman_id":"95593","bowler_id":"1106","over":"7","ball":"3","score":0,"commentary":"Syed Khaleel Ahmed to Finlay Bean, no run,","noball_dismissal":false,"text":"","timestamp":1751470797,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12273916","event":"ball","batsman_id":"95593","bowler_id":"1106","over":"7","ball":"4","score":0,"commentary":"Syed Khaleel Ahmed to Finlay Bean, no run,","noball_dismissal":false,"text":"","timestamp":1751470801,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12273917","event":"ball","batsman_id":"95593","bowler_id":"1106","over":"7","ball":"5","score":0,"commentary":"Syed Khaleel Ahmed to Finlay Bean, no run,","noball_dismissal":false,"text":"","timestamp":1751470811,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12273918","event":"ball","batsman_id":"95593","bowler_id":"1106","over":"7","ball":"6","score":4,"commentary":"Syed Khaleel Ahmed to Finlay Bean, Four,","noball_dismissal":false,"text":"","timestamp":1751470814,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event":"overend","over":8,"runs":4,"score":"32\/0","bats":[{"runs":16,"balls_faced":30,"fours":3,"sixes":0,"batsman_id":95593},{"runs":8,"balls_faced":22,"fours":1,"sixes":0,"batsman_id":10610}],"bowls":[{"runs_conceded":21,"maidens":1,"wickets":0,"bowler_id":1106,"overs":4},{"runs_conceded":7,"maidens":1,"wickets":0,"bowler_id":61358,"overs":4}],"commentary":"End of over 8 (4 runs), Yorkshire 32\/0"},{"event_id":"12273951","event":"ball","batsman_id":"10610","bowler_id":"127517","over":"8","ball":"1","score":4,"commentary":"Noah Thain to Adam Lyth, Four,","noball_dismissal":false,"text":"","timestamp":1751471021,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12273955","event":"ball","batsman_id":"10610","bowler_id":"127517","over":"8","ball":"2","score":1,"commentary":"Noah Thain to Adam Lyth, 1 run,","noball_dismissal":false,"text":"","timestamp":1751471033,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12273960","event":"ball","batsman_id":"95593","bowler_id":"127517","over":"8","ball":"3","score":1,"commentary":"Noah Thain to Finlay Bean, 1 run,","noball_dismissal":false,"text":"","timestamp":1751471039,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12273961","event":"ball","batsman_id":"10610","bowler_id":"127517","over":"8","ball":"4","score":1,"commentary":"Noah Thain to Adam Lyth, 1 run,","noball_dismissal":false,"text":"","timestamp":1751471042,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12273965","event":"ball","batsman_id":"95593","bowler_id":"127517","over":"8","ball":"5","score":1,"commentary":"Noah Thain to Finlay Bean, 1 run,","noball_dismissal":false,"text":"","timestamp":1751471049,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12273966","event":"ball","batsman_id":"10610","bowler_id":"127517","over":"8","ball":"6","score":1,"commentary":"Noah Thain to Adam Lyth, 1 run,","noball_dismissal":false,"text":"","timestamp":1751471054,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":9,"runs":9,"score":"41\/0","bats":[{"runs":15,"balls_faced":26,"fours":2,"sixes":0,"batsman_id":10610},{"runs":18,"balls_faced":32,"fours":3,"sixes":0,"batsman_id":95593}],"bowls":[{"runs_conceded":9,"maidens":0,"wickets":0,"bowler_id":127517,"overs":1},{"runs_conceded":21,"maidens":1,"wickets":0,"bowler_id":1106,"overs":4}],"commentary":"End of over 9 (9 runs), Yorkshire 41\/0"}],"day":"4","session":"0","live_inning":{"iid":199037,"number":4,"name":"Yorkshire 2nd Inning","short_name":"YOR 2nd Inning","status":2,"issuperover":"false","result":3,"batting_team_id":7050,"fielding_team_id":104950,"scores":"41\/0","scores_full":"41\/0 (9 ov)","fielder":[],"powerplay":[],"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":[],"extra_runs":{"byes":0,"legbyes":0,"wides":0,"noballs":8,"penalty":"0","total":8},"equations":{"runs":41,"wickets":0,"overs":"9","bowlers_used":3,"runrate":"4.56"},"current_partnership":{"runs":41,"balls":58,"overs":9.4,"batsmen":[{"name":"Adam Lyth","batsman_id":10610,"runs":15,"balls":26},{"name":"Finlay Bean","batsman_id":95593,"runs":18,"balls":32}]},"did_not_bat":[{"player_id":102295,"name":"James Wharton"},{"player_id":48460,"name":"Abdullah Shafique"},{"player_id":44100,"name":"Jonny Bairstow"},{"player_id":95555,"name":"George Hill"},{"player_id":96059,"name":"Matthew Revis"},{"player_id":50392,"name":"Dom Bess"},{"player_id":48449,"name":"Ben Coad"},{"player_id":93358,"name":"Will Sutherland"},{"player_id":61872,"name":"Jack White"}],"max_over":"0","target":"41","recent_scores":"1,1,1,1,1,4,4,0,0,0,0,0,0,0,0,0,2,0","last_five_overs":"28\/0 5.25","last_ten_overs":"41\/0 4.24"},"teams":[{"tid":7050,"title":"Yorkshire","abbr":"YOR","alt_name":"YOR","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/yorkshire-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/yorkshire-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"459\/10 (131.2 ov) & 41\/0 (9 ov)","scores":"459\/10 & 41\/0","overs":"131.2 & 9"},{"tid":104950,"title":"Essex","abbr":"ESS","alt_name":"ESS","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"368\/10 (136 ov) & 131\/10 (59.1 ov)","scores":"368\/10 & 131\/10","overs":"136 & 59.1"}],"players":[{"pid":1091,"title":"Ben Sears","short_name":"B Sears","first_name":"Ben Sears","last_name":"","middle_name":"","birthdate":"1998-02-11","birthplace":"Wellington","country":"nz","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"squad","role_str":""},{"pid":1106,"title":"Syed Khaleel Ahmed","short_name":"KK Ahmed","first_name":"Syed Khaleel Ahmed","last_name":"","middle_name":"","birthdate":"1997-12-05","birthplace":"Tonk, Rajasthan","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"https:\/\/www.facebook.com\/KhaleelAhmedCricketer","twitter_profile":"https:\/\/twitter.com\/imK_Ahmed13","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":10592,"title":"Tom Westley","short_name":"TZ Westley","first_name":"Tom Westley","last_name":"","middle_name":"","birthdate":"1989-03-13","birthplace":"Cambridge","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"pid":10610,"title":"Adam Lyth","short_name":"A Lyth","first_name":"Adam Lyth","last_name":"","middle_name":"","birthdate":"1987-09-25","birthplace":"Whitby, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/lythy09\/","twitter_profile":"https:\/\/twitter.com\/lythy09","instagram_profile":"https:\/\/www.instagram.com\/lythy09\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":43358,"title":"Dawid Malan","short_name":"D Malan","first_name":"Dawid Malan","last_name":"","middle_name":"","birthdate":"1987-09-03","birthplace":"Roehampton, England","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/D.Malanofficial\/","twitter_profile":"https:\/\/twitter.com\/dmalan29","instagram_profile":"https:\/\/www.instagram.com\/djmalan29\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":44001,"title":"Kasun Rajitha","short_name":"K Rajitha","first_name":"Kasun Rajitha","last_name":"","middle_name":"","birthdate":"1993-06-01","birthplace":"Matara","country":"lk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/kasunsl21","instagram_profile":"https:\/\/www.instagram.com\/kasunrajitha77\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Sri Lanka","role":"squad","role_str":""},{"pid":44100,"title":"Jonny Bairstow","short_name":"J Bairstow","first_name":"Jonny Bairstow","last_name":"","middle_name":"","birthdate":"1989-09-26","birthplace":" Bradford, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/jbairstow21\/","twitter_profile":"https:\/\/twitter.com\/jbairstow21","instagram_profile":"https:\/\/www.instagram.com\/jbairstow21\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK\/C)"},{"pid":45911,"title":"Daniel Moriarty","short_name":"DT Moriarty","first_name":"Daniel Moriarty","last_name":"","middle_name":"","birthdate":"1999-12-02","birthplace":"Reigate, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":48449,"title":"Ben Coad","short_name":"BO Coad","first_name":"Ben Coad","last_name":"","middle_name":"","birthdate":"1994-01-10","birthplace":"Harrogate, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BenCoad10","instagram_profile":"https:\/\/www.instagram.com\/bencoad10\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":48460,"title":"Abdullah Shafique","short_name":"A Shafique","first_name":"Abdullah Shafique","last_name":"","middle_name":"","birthdate":"1999-11-20","birthplace":"Sialkot","country":"pk","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/Abdullahshafique28\/","twitter_profile":"https:\/\/twitter.com\/imabd28","instagram_profile":"https:\/\/www.instagram.com\/imabd28\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bat","role_str":""},{"pid":48647,"title":"Matt Critchley","short_name":"MJJ Critchley","first_name":"Matt Critchley","last_name":"","middle_name":"","birthdate":"1996-08-13","birthplace":"Preston, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/mattcritchley96","instagram_profile":"https:\/\/www.instagram.com\/critch130896\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":49083,"title":"Dean Elgar","short_name":"D Elgar","first_name":"Dean Elgar","last_name":"","middle_name":"","birthdate":"1987-06-11","birthplace":"Welkom, Orange Free state","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":36249,"recent_appearance":1514287800,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BoringDeanElgar","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bat","role_str":""},{"pid":49087,"title":"Simon Harmer","short_name":"SR Harmer","first_name":"Simon Harmer","last_name":"","middle_name":"","birthdate":"1989-02-10","birthplace":"Pretoria, Transvaal","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Simon_Harmer_","instagram_profile":"https:\/\/www.instagram.com\/simon_harmer\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bowl","role_str":""},{"pid":49593,"title":"Jamie Porter","short_name":"JA Porter","first_name":"Jamie Porter","last_name":"","middle_name":"","birthdate":"1993-05-25","birthplace":"Leytonstone, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50392,"title":"Dom Bess","short_name":"Dom Bess","first_name":"Dom Bess","last_name":"","middle_name":"","birthdate":"1997-07-22","birthplace":"Exeter, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/dombess99\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":50507,"title":"Jordan Thompson","short_name":"JA Thompson","first_name":"Jordan Thompson","last_name":"","middle_name":"","birthdate":"1996-10-09","birthplace":"Leeds, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Tommo455","instagram_profile":"https:\/\/www.instagram.com\/jordan.a.thompson\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51105,"title":"Michael-Kyle Pepper","short_name":"MKS Pepper","first_name":"Michael-Kyle Pepper","last_name":"","middle_name":"","birthdate":"1998-06-25","birthplace":"Harlow, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/michael_pep\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":51346,"title":"Paul Walter","short_name":"PI Walter","first_name":"Paul Walter","last_name":"","middle_name":"","birthdate":"1994-05-28","birthplace":"Basildon, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":61358,"title":"Shane Snater","short_name":"S Snater","first_name":"Shane Snater","last_name":"","middle_name":"","birthdate":"1996-03-24","birthplace":"Harare, Zimbabwe","country":"nl","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"bowl","role_str":""},{"pid":61872,"title":"Jack White","short_name":"cJ White","first_name":"Jack White","last_name":"","middle_name":"","birthdate":"1992-02-19","birthplace":" Kendal","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":68691,"title":"Samuel Cook","short_name":"S Cook","first_name":"Samuel Cook","last_name":"","middle_name":"","birthdate":"1997-08-04","birthplace":"Chelmsford, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/samcook09","instagram_profile":"https:\/\/www.instagram.com\/s_cook16\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":93358,"title":"Will Sutherland","short_name":"W Sutherland","first_name":"Will Sutherland","last_name":"","middle_name":"","birthdate":"1999-10-27","birthplace":"Melbourne, Australia","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":23792,"recent_appearance":1515891600,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/will_suth12","instagram_profile":"https:\/\/www.instagram.com\/willsutherland12\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"all","role_str":""},{"pid":94961,"title":"Jordan Cox","short_name":"J Cox","first_name":"Jordan Cox","last_name":"","middle_name":"","birthdate":"2000-10-21","birthplace":"Margate, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/jjordancox\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":""},{"pid":95555,"title":"George Hill","short_name":"G Hill","first_name":"George Hill","last_name":"","middle_name":"","birthdate":"2001-01-24","birthplace":"Keighley, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":95593,"title":"Finlay Bean","short_name":"F Bean","first_name":"Finlay Bean","last_name":"","middle_name":"","birthdate":"2002-04-16","birthplace":" Harrogate, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":96059,"title":"Matthew Revis","short_name":"M Revis","first_name":"Matthew Revis","last_name":"","middle_name":"","birthdate":"2001-11-15","birthplace":" Steeton, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/matty.revis_\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":96733,"title":"William O\u2019Rourke","short_name":"WO Rourke","first_name":"William O\u2019Rourke","last_name":"","middle_name":"","birthdate":"2001-08-06","birthplace":"Surrey","country":"nz","primary_team":{"tid":1068,"name":"","short_name":""},"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/willorourke_\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"squad","role_str":""},{"pid":102295,"title":"James Wharton","short_name":"J Wharton","first_name":"James Wharton","last_name":"","middle_name":"","birthdate":"2001-02-01","birthplace":" Huddersfield","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":109356,"title":"William Luxton","short_name":"W Luxton","first_name":"William Luxton","last_name":"","middle_name":"","birthdate":"2003-05-06","birthplace":"Keighley, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":112710,"title":"Benjamin Cliff","short_name":"BM Cliff","first_name":"Benjamin Cliff","last_name":"","middle_name":"","birthdate":"2002-10-23","birthplace":" Halifax, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BenjaminCliff1","instagram_profile":"https:\/\/www.instagram.com\/bencliff23\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":127517,"title":"Noah Thain","short_name":"NRM Thain","first_name":"Noah Thain","last_name":"","middle_name":"","birthdate":"2005-01-13","birthplace":"Hitchinbrooke, Hertfordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":129447,"title":"Mackenzie Jones","short_name":"Mackenzie Jones","first_name":"Mackenzie Jones","last_name":"","middle_name":"","birthdate":"2005-03-06","birthplace":"","country":"sct","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Scotland","role":"squad","role_str":""},{"pid":134958,"title":"Charles Allison","short_name":"CW Allison","first_name":"Charles Allison","last_name":"","middle_name":"","birthdate":"2005-03-02","birthplace":"Colchester, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""}]},"etag":"80176965345f9f3fda3ae0c9a3210fd6","modified":"2025-07-11 17:06:29","datetime":"2025-07-11 17:06:29","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":88140,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Yorkshire won by 10 wickets","day_remaining_over":"37.5","team_batting":"Yorkshire","team_bowling":"Essex","live_inning_number":4,"live_score":{"runs":41,"overs":9,"wickets":0,"target":41,"runrate":4.56,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Adam Lyth","batsman_id":10610,"runs":15,"balls_faced":26,"fours":2,"sixes":0,"strike_rate":"57.69"},{"name":"Finlay Bean","batsman_id":95593,"runs":18,"balls_faced":32,"fours":3,"sixes":0,"strike_rate":"56.25"}],"bowlers":[{"name":"Noah Thain","bowler_id":127517,"overs":1,"runs_conceded":9,"wickets":0,"maidens":0,"econ":"9.00"},{"name":"Syed Khaleel Ahmed","bowler_id":1106,"overs":4,"runs_conceded":24,"wickets":0,"maidens":1,"econ":"6.00"}],"commentaries":[{"event":"overend","over":5,"runs":0,"score":"13\/0","bats":[{"runs":8,"balls_faced":20,"fours":1,"sixes":0,"batsman_id":95593},{"runs":1,"balls_faced":12,"fours":0,"sixes":0,"batsman_id":10610}],"bowls":[{"runs_conceded":5,"maidens":1,"wickets":0,"bowler_id":61358,"overs":3},{"runs_conceded":6,"maidens":1,"wickets":0,"bowler_id":1106,"overs":2}],"commentary":"End of over 5 (0 runs), Yorkshire 13\/0"},{"event_id":"12273793","event":"ball","batsman_id":"10610","bowler_id":"1106","over":"5","ball":"1","score":0,"commentary":"Syed Khaleel Ahmed to Adam Lyth, no run,","noball_dismissal":false,"text":"","timestamp":1751470421,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12273796","event":"ball","batsman_id":"10610","bowler_id":"1106","over":"5","ball":"2","score":"2nb","commentary":"Syed Khaleel Ahmed to Adam Lyth, 2 no ball,","noball_dismissal":false,"text":"","timestamp":1751470425,"run":2,"noball_run":"1","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":true,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12273798","event":"ball","batsman_id":"10610","bowler_id":"1106","over":"5","ball":"2","score":4,"commentary":"Syed Khaleel Ahmed to Adam Lyth, Four,","noball_dismissal":false,"text":"","timestamp":1751470427,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12273799","event":"ball","batsman_id":"10610","bowler_id":"1106","over":"5","ball":"3","score":1,"commentary":"Syed Khaleel Ahmed to Adam Lyth, 1 run,","noball_dismissal":false,"text":"","timestamp":1751470431,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12273801","event":"ball","batsman_id":"95593","bowler_id":"1106","over":"5","ball":"4","score":0,"commentary":"Syed Khaleel Ahmed to Finlay Bean, no run,","noball_dismissal":false,"text":"","timestamp":1751470434,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12273803","event":"ball","batsman_id":"95593","bowler_id":"1106","over":"5","ball":"5","score":0,"commentary":"Syed Khaleel Ahmed to Finlay Bean, no run,","noball_dismissal":false,"text":"","timestamp":1751470460,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12273836","event":"ball","batsman_id":"95593","bowler_id":"1106","over":"5","ball":"6","score":"2nb","commentary":"Syed Khaleel Ahmed to Finlay Bean, 2 no ball,","noball_dismissal":false,"text":"","timestamp":1751470463,"run":2,"noball_run":"1","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":true,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12273839","event":"ball","batsman_id":"95593","bowler_id":"1106","over":"5","ball":"6","score":4,"commentary":"Syed Khaleel Ahmed to Finlay Bean, Four,","noball_dismissal":false,"text":"","timestamp":1751470467,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event":"overend","over":6,"runs":13,"score":"26\/0","bats":[{"runs":12,"balls_faced":24,"fours":2,"sixes":0,"batsman_id":95593},{"runs":6,"balls_faced":16,"fours":1,"sixes":0,"batsman_id":10610}],"bowls":[{"runs_conceded":17,"maidens":1,"wickets":0,"bowler_id":1106,"overs":3},{"runs_conceded":5,"maidens":1,"wickets":0,"bowler_id":61358,"overs":3}],"commentary":"End of over 6 (13 runs), Yorkshire 26\/0"},{"event_id":"12273856","event":"ball","batsman_id":"10610","bowler_id":"61358","over":"6","ball":"1","score":0,"commentary":"Shane Snater to Adam Lyth, no run,","noball_dismissal":false,"text":"","timestamp":1751470541,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12273857","event":"ball","batsman_id":"10610","bowler_id":"61358","over":"6","ball":"2","score":2,"commentary":"Shane Snater to Adam Lyth, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751470546,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12273859","event":"ball","batsman_id":"10610","bowler_id":"61358","over":"6","ball":"3","score":0,"commentary":"Shane Snater to Adam Lyth, no run,","noball_dismissal":false,"text":"","timestamp":1751470549,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12273861","event":"ball","batsman_id":"10610","bowler_id":"61358","over":"6","ball":"4","score":0,"commentary":"Shane Snater to Adam Lyth, no run,","noball_dismissal":false,"text":"","timestamp":1751470553,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12273862","event":"ball","batsman_id":"10610","bowler_id":"61358","over":"6","ball":"5","score":0,"commentary":"Shane Snater to Adam Lyth, no run,","noball_dismissal":false,"text":"","timestamp":1751470556,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12273863","event":"ball","batsman_id":"10610","bowler_id":"61358","over":"6","ball":"6","score":0,"commentary":"Shane Snater to Adam Lyth, no run,","noball_dismissal":false,"text":"","timestamp":1751470560,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":7,"runs":2,"score":"28\/0","bats":[{"runs":8,"balls_faced":22,"fours":1,"sixes":0,"batsman_id":10610},{"runs":12,"balls_faced":24,"fours":2,"sixes":0,"batsman_id":95593}],"bowls":[{"runs_conceded":7,"maidens":1,"wickets":0,"bowler_id":61358,"overs":4},{"runs_conceded":17,"maidens":1,"wickets":0,"bowler_id":1106,"overs":3}],"commentary":"End of over 7 (2 runs), Yorkshire 28\/0"},{"event_id":"12273912","event":"ball","batsman_id":"95593","bowler_id":"1106","over":"7","ball":"1","score":0,"commentary":"Syed Khaleel Ahmed to Finlay Bean, no run,","noball_dismissal":false,"text":"","timestamp":1751470791,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12273913","event":"ball","batsman_id":"95593","bowler_id":"1106","over":"7","ball":"2","score":0,"commentary":"Syed Khaleel Ahmed to Finlay Bean, no run,","noball_dismissal":false,"text":"","timestamp":1751470794,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12273915","event":"ball","batsman_id":"95593","bowler_id":"1106","over":"7","ball":"3","score":0,"commentary":"Syed Khaleel Ahmed to Finlay Bean, no run,","noball_dismissal":false,"text":"","timestamp":1751470797,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12273916","event":"ball","batsman_id":"95593","bowler_id":"1106","over":"7","ball":"4","score":0,"commentary":"Syed Khaleel Ahmed to Finlay Bean, no run,","noball_dismissal":false,"text":"","timestamp":1751470801,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12273917","event":"ball","batsman_id":"95593","bowler_id":"1106","over":"7","ball":"5","score":0,"commentary":"Syed Khaleel Ahmed to Finlay Bean, no run,","noball_dismissal":false,"text":"","timestamp":1751470811,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12273918","event":"ball","batsman_id":"95593","bowler_id":"1106","over":"7","ball":"6","score":4,"commentary":"Syed Khaleel Ahmed to Finlay Bean, Four,","noball_dismissal":false,"text":"","timestamp":1751470814,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event":"overend","over":8,"runs":4,"score":"32\/0","bats":[{"runs":16,"balls_faced":30,"fours":3,"sixes":0,"batsman_id":95593},{"runs":8,"balls_faced":22,"fours":1,"sixes":0,"batsman_id":10610}],"bowls":[{"runs_conceded":21,"maidens":1,"wickets":0,"bowler_id":1106,"overs":4},{"runs_conceded":7,"maidens":1,"wickets":0,"bowler_id":61358,"overs":4}],"commentary":"End of over 8 (4 runs), Yorkshire 32\/0"},{"event_id":"12273951","event":"ball","batsman_id":"10610","bowler_id":"127517","over":"8","ball":"1","score":4,"commentary":"Noah Thain to Adam Lyth, Four,","noball_dismissal":false,"text":"","timestamp":1751471021,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12273955","event":"ball","batsman_id":"10610","bowler_id":"127517","over":"8","ball":"2","score":1,"commentary":"Noah Thain to Adam Lyth, 1 run,","noball_dismissal":false,"text":"","timestamp":1751471033,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12273960","event":"ball","batsman_id":"95593","bowler_id":"127517","over":"8","ball":"3","score":1,"commentary":"Noah Thain to Finlay Bean, 1 run,","noball_dismissal":false,"text":"","timestamp":1751471039,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12273961","event":"ball","batsman_id":"10610","bowler_id":"127517","over":"8","ball":"4","score":1,"commentary":"Noah Thain to Adam Lyth, 1 run,","noball_dismissal":false,"text":"","timestamp":1751471042,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12273965","event":"ball","batsman_id":"95593","bowler_id":"127517","over":"8","ball":"5","score":1,"commentary":"Noah Thain to Finlay Bean, 1 run,","noball_dismissal":false,"text":"","timestamp":1751471049,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12273966","event":"ball","batsman_id":"10610","bowler_id":"127517","over":"8","ball":"6","score":1,"commentary":"Noah Thain to Adam Lyth, 1 run,","noball_dismissal":false,"text":"","timestamp":1751471054,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":9,"runs":9,"score":"41\/0","bats":[{"runs":15,"balls_faced":26,"fours":2,"sixes":0,"batsman_id":10610},{"runs":18,"balls_faced":32,"fours":3,"sixes":0,"batsman_id":95593}],"bowls":[{"runs_conceded":9,"maidens":0,"wickets":0,"bowler_id":127517,"overs":1},{"runs_conceded":21,"maidens":1,"wickets":0,"bowler_id":1106,"overs":4}],"commentary":"End of over 9 (9 runs), Yorkshire 41\/0"}],"day":"4","session":"0","live_inning":{"iid":199037,"number":4,"name":"Yorkshire 2nd Inning","short_name":"YOR 2nd Inning","status":2,"issuperover":"false","result":3,"batting_team_id":7050,"fielding_team_id":104950,"scores":"41\/0","scores_full":"41\/0 (9 ov)","fielder":[],"powerplay":[],"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":[],"extra_runs":{"byes":0,"legbyes":0,"wides":0,"noballs":8,"penalty":"0","total":8},"equations":{"runs":41,"wickets":0,"overs":"9","bowlers_used":3,"runrate":"4.56"},"current_partnership":{"runs":41,"balls":58,"overs":9.4,"batsmen":[{"name":"Adam Lyth","batsman_id":10610,"runs":15,"balls":26},{"name":"Finlay Bean","batsman_id":95593,"runs":18,"balls":32}]},"did_not_bat":[{"player_id":102295,"name":"James Wharton"},{"player_id":48460,"name":"Abdullah Shafique"},{"player_id":44100,"name":"Jonny Bairstow"},{"player_id":95555,"name":"George Hill"},{"player_id":96059,"name":"Matthew Revis"},{"player_id":50392,"name":"Dom Bess"},{"player_id":48449,"name":"Ben Coad"},{"player_id":93358,"name":"Will Sutherland"},{"player_id":61872,"name":"Jack White"}],"max_over":"0","target":"41","recent_scores":"1,1,1,1,1,4,4,0,0,0,0,0,0,0,0,0,2,0","last_five_overs":"28\/0 5.25","last_ten_overs":"41\/0 4.24"},"teams":[{"tid":7050,"title":"Yorkshire","abbr":"YOR","alt_name":"YOR","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/yorkshire-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/yorkshire-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"459\/10 (131.2 ov) & 41\/0 (9 ov)","scores":"459\/10 & 41\/0","overs":"131.2 & 9"},{"tid":104950,"title":"Essex","abbr":"ESS","alt_name":"ESS","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"368\/10 (136 ov) & 131\/10 (59.1 ov)","scores":"368\/10 & 131\/10","overs":"136 & 59.1"}],"players":[{"pid":1091,"title":"Ben Sears","short_name":"B Sears","first_name":"Ben Sears","last_name":"","middle_name":"","birthdate":"1998-02-11","birthplace":"Wellington","country":"nz","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"squad","role_str":""},{"pid":1106,"title":"Syed Khaleel Ahmed","short_name":"KK Ahmed","first_name":"Syed Khaleel Ahmed","last_name":"","middle_name":"","birthdate":"1997-12-05","birthplace":"Tonk, Rajasthan","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"https:\/\/www.facebook.com\/KhaleelAhmedCricketer","twitter_profile":"https:\/\/twitter.com\/imK_Ahmed13","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":10592,"title":"Tom Westley","short_name":"TZ Westley","first_name":"Tom Westley","last_name":"","middle_name":"","birthdate":"1989-03-13","birthplace":"Cambridge","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"pid":10610,"title":"Adam Lyth","short_name":"A Lyth","first_name":"Adam Lyth","last_name":"","middle_name":"","birthdate":"1987-09-25","birthplace":"Whitby, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/lythy09\/","twitter_profile":"https:\/\/twitter.com\/lythy09","instagram_profile":"https:\/\/www.instagram.com\/lythy09\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":43358,"title":"Dawid Malan","short_name":"D Malan","first_name":"Dawid Malan","last_name":"","middle_name":"","birthdate":"1987-09-03","birthplace":"Roehampton, England","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/D.Malanofficial\/","twitter_profile":"https:\/\/twitter.com\/dmalan29","instagram_profile":"https:\/\/www.instagram.com\/djmalan29\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":44001,"title":"Kasun Rajitha","short_name":"K Rajitha","first_name":"Kasun Rajitha","last_name":"","middle_name":"","birthdate":"1993-06-01","birthplace":"Matara","country":"lk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/kasunsl21","instagram_profile":"https:\/\/www.instagram.com\/kasunrajitha77\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Sri Lanka","role":"squad","role_str":""},{"pid":44100,"title":"Jonny Bairstow","short_name":"J Bairstow","first_name":"Jonny Bairstow","last_name":"","middle_name":"","birthdate":"1989-09-26","birthplace":" Bradford, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/jbairstow21\/","twitter_profile":"https:\/\/twitter.com\/jbairstow21","instagram_profile":"https:\/\/www.instagram.com\/jbairstow21\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK\/C)"},{"pid":45911,"title":"Daniel Moriarty","short_name":"DT Moriarty","first_name":"Daniel Moriarty","last_name":"","middle_name":"","birthdate":"1999-12-02","birthplace":"Reigate, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":48449,"title":"Ben Coad","short_name":"BO Coad","first_name":"Ben Coad","last_name":"","middle_name":"","birthdate":"1994-01-10","birthplace":"Harrogate, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BenCoad10","instagram_profile":"https:\/\/www.instagram.com\/bencoad10\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":48460,"title":"Abdullah Shafique","short_name":"A Shafique","first_name":"Abdullah Shafique","last_name":"","middle_name":"","birthdate":"1999-11-20","birthplace":"Sialkot","country":"pk","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/Abdullahshafique28\/","twitter_profile":"https:\/\/twitter.com\/imabd28","instagram_profile":"https:\/\/www.instagram.com\/imabd28\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bat","role_str":""},{"pid":48647,"title":"Matt Critchley","short_name":"MJJ Critchley","first_name":"Matt Critchley","last_name":"","middle_name":"","birthdate":"1996-08-13","birthplace":"Preston, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/mattcritchley96","instagram_profile":"https:\/\/www.instagram.com\/critch130896\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":49083,"title":"Dean Elgar","short_name":"D Elgar","first_name":"Dean Elgar","last_name":"","middle_name":"","birthdate":"1987-06-11","birthplace":"Welkom, Orange Free state","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":36249,"recent_appearance":1514287800,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BoringDeanElgar","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bat","role_str":""},{"pid":49087,"title":"Simon Harmer","short_name":"SR Harmer","first_name":"Simon Harmer","last_name":"","middle_name":"","birthdate":"1989-02-10","birthplace":"Pretoria, Transvaal","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Simon_Harmer_","instagram_profile":"https:\/\/www.instagram.com\/simon_harmer\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bowl","role_str":""},{"pid":49593,"title":"Jamie Porter","short_name":"JA Porter","first_name":"Jamie Porter","last_name":"","middle_name":"","birthdate":"1993-05-25","birthplace":"Leytonstone, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50392,"title":"Dom Bess","short_name":"Dom Bess","first_name":"Dom Bess","last_name":"","middle_name":"","birthdate":"1997-07-22","birthplace":"Exeter, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/dombess99\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":50507,"title":"Jordan Thompson","short_name":"JA Thompson","first_name":"Jordan Thompson","last_name":"","middle_name":"","birthdate":"1996-10-09","birthplace":"Leeds, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Tommo455","instagram_profile":"https:\/\/www.instagram.com\/jordan.a.thompson\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51105,"title":"Michael-Kyle Pepper","short_name":"MKS Pepper","first_name":"Michael-Kyle Pepper","last_name":"","middle_name":"","birthdate":"1998-06-25","birthplace":"Harlow, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/michael_pep\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":51346,"title":"Paul Walter","short_name":"PI Walter","first_name":"Paul Walter","last_name":"","middle_name":"","birthdate":"1994-05-28","birthplace":"Basildon, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":61358,"title":"Shane Snater","short_name":"S Snater","first_name":"Shane Snater","last_name":"","middle_name":"","birthdate":"1996-03-24","birthplace":"Harare, Zimbabwe","country":"nl","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"bowl","role_str":""},{"pid":61872,"title":"Jack White","short_name":"cJ White","first_name":"Jack White","last_name":"","middle_name":"","birthdate":"1992-02-19","birthplace":" Kendal","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":68691,"title":"Samuel Cook","short_name":"S Cook","first_name":"Samuel Cook","last_name":"","middle_name":"","birthdate":"1997-08-04","birthplace":"Chelmsford, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/samcook09","instagram_profile":"https:\/\/www.instagram.com\/s_cook16\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":93358,"title":"Will Sutherland","short_name":"W Sutherland","first_name":"Will Sutherland","last_name":"","middle_name":"","birthdate":"1999-10-27","birthplace":"Melbourne, Australia","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":23792,"recent_appearance":1515891600,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/will_suth12","instagram_profile":"https:\/\/www.instagram.com\/willsutherland12\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"all","role_str":""},{"pid":94961,"title":"Jordan Cox","short_name":"J Cox","first_name":"Jordan Cox","last_name":"","middle_name":"","birthdate":"2000-10-21","birthplace":"Margate, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/jjordancox\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":""},{"pid":95555,"title":"George Hill","short_name":"G Hill","first_name":"George Hill","last_name":"","middle_name":"","birthdate":"2001-01-24","birthplace":"Keighley, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":95593,"title":"Finlay Bean","short_name":"F Bean","first_name":"Finlay Bean","last_name":"","middle_name":"","birthdate":"2002-04-16","birthplace":" Harrogate, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":96059,"title":"Matthew Revis","short_name":"M Revis","first_name":"Matthew Revis","last_name":"","middle_name":"","birthdate":"2001-11-15","birthplace":" Steeton, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/matty.revis_\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":96733,"title":"William O\u2019Rourke","short_name":"WO Rourke","first_name":"William O\u2019Rourke","last_name":"","middle_name":"","birthdate":"2001-08-06","birthplace":"Surrey","country":"nz","primary_team":{"tid":1068,"name":"","short_name":""},"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/willorourke_\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"squad","role_str":""},{"pid":102295,"title":"James Wharton","short_name":"J Wharton","first_name":"James Wharton","last_name":"","middle_name":"","birthdate":"2001-02-01","birthplace":" Huddersfield","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":109356,"title":"William Luxton","short_name":"W Luxton","first_name":"William Luxton","last_name":"","middle_name":"","birthdate":"2003-05-06","birthplace":"Keighley, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":112710,"title":"Benjamin Cliff","short_name":"BM Cliff","first_name":"Benjamin Cliff","last_name":"","middle_name":"","birthdate":"2002-10-23","birthplace":" Halifax, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BenjaminCliff1","instagram_profile":"https:\/\/www.instagram.com\/bencliff23\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":127517,"title":"Noah Thain","short_name":"NRM Thain","first_name":"Noah Thain","last_name":"","middle_name":"","birthdate":"2005-01-13","birthplace":"Hitchinbrooke, Hertfordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":129447,"title":"Mackenzie Jones","short_name":"Mackenzie Jones","first_name":"Mackenzie Jones","last_name":"","middle_name":"","birthdate":"2005-03-06","birthplace":"","country":"sct","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Scotland","role":"squad","role_str":""},{"pid":134958,"title":"Charles Allison","short_name":"CW Allison","first_name":"Charles Allison","last_name":"","middle_name":"","birthdate":"2005-03-02","birthplace":"Colchester, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""}]},"etag":"80176965345f9f3fda3ae0c9a3210fd6","modified":"2025-07-11 17:06:29","datetime":"2025-07-11 17:06:29","api_version":"3.0"}', Modified = GetDate() WHERE Id = 88140 AND DataTypeId = 1 END

System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'StatusId'. Invalid column name 'ErrorLog'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Etoz.ConnectData.DataAccess.ExecuteQuery(String query) in c:\inetpub\wwwroot\cricdirect.com\api\v6\App_Code\db\data_access.cs:line 117 ClientConnectionId:20d720e2-7c5b-498d-9ead-b5201c39c8db Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 88140 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (88140,3,'{"status":"ok","response":{"match_id":88140,"title":"Yorkshire vs Essex","short_title":"YOR vs ESS","subtitle":"41st Match","match_number":"41","format":5,"format_str":"First Class","status":2,"status_str":"Completed","status_note":"Yorkshire won by 10 wickets","verified":"true","pre_squad":"false","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129481,"title":"County Championship Division One","abbr":"County Championship 2025 DIV-I","type":"tournament","category":"domestic","match_format":"firstclass","season":"2025","status":"live","datestart":"2025-04-04","dateend":"2025-09-27","country":"en","total_matches":"70","total_rounds":"1","total_teams":"10"},"teama":{"team_id":7050,"name":"Yorkshire","short_name":"YOR","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/yorkshire-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/yorkshire-logo.png","scores_full":"459\/10 (131.2 ov) & 41\/0 (9 ov)","scores":"459\/10 & 41\/0","overs":"131.2 & 9"},"teamb":{"team_id":104950,"name":"Essex","short_name":"ESS","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","scores_full":"368\/10 (136 ov) & 131\/10 (59.1 ov)","scores":"368\/10 & 131\/10","overs":"136 & 59.1"},"date_start":"2025-06-29 10:00:00","date_end":"2025-07-04 10:00:00","timestamp_start":1751191200,"timestamp_end":1751623200,"date_start_ist":"2025-06-29 15:30:00","date_end_ist":"2025-07-04 15:30:00","venue":{"venue_id":"342","name":"York Cricket Club","location":"York","country":"England","timezone":""},"umpires":"Michael Gough (England), Peter Hartley (England)","referee":"Will Smith (England)","equation":"","live":"","result":"YOR won by 10 wickets","result_type":1,"win_margin":"10 wickets","winning_team_id":7050,"commentary":1,"wagon":2,"latest_inning_number":4,"presquad_time":"","verify_time":"2025-07-02 21:47:58","match_dls_affected":"false","live_inning_number":4,"day":"4","session":"0","weather":[],"pitch":{"pitch_condition":"Green Pitch","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Essex elected to bat","winner":104950,"decision":1}},"etag":"80176965345f9f3fda3ae0c9a3210fd6","modified":"2025-07-11 17:06:29","datetime":"2025-07-11 17:06:29","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":88140,"title":"Yorkshire vs Essex","short_title":"YOR vs ESS","subtitle":"41st Match","match_number":"41","format":5,"format_str":"First Class","status":2,"status_str":"Completed","status_note":"Yorkshire won by 10 wickets","verified":"true","pre_squad":"false","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129481,"title":"County Championship Division One","abbr":"County Championship 2025 DIV-I","type":"tournament","category":"domestic","match_format":"firstclass","season":"2025","status":"live","datestart":"2025-04-04","dateend":"2025-09-27","country":"en","total_matches":"70","total_rounds":"1","total_teams":"10"},"teama":{"team_id":7050,"name":"Yorkshire","short_name":"YOR","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/yorkshire-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/yorkshire-logo.png","scores_full":"459\/10 (131.2 ov) & 41\/0 (9 ov)","scores":"459\/10 & 41\/0","overs":"131.2 & 9"},"teamb":{"team_id":104950,"name":"Essex","short_name":"ESS","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","scores_full":"368\/10 (136 ov) & 131\/10 (59.1 ov)","scores":"368\/10 & 131\/10","overs":"136 & 59.1"},"date_start":"2025-06-29 10:00:00","date_end":"2025-07-04 10:00:00","timestamp_start":1751191200,"timestamp_end":1751623200,"date_start_ist":"2025-06-29 15:30:00","date_end_ist":"2025-07-04 15:30:00","venue":{"venue_id":"342","name":"York Cricket Club","location":"York","country":"England","timezone":""},"umpires":"Michael Gough (England), Peter Hartley (England)","referee":"Will Smith (England)","equation":"","live":"","result":"YOR won by 10 wickets","result_type":1,"win_margin":"10 wickets","winning_team_id":7050,"commentary":1,"wagon":2,"latest_inning_number":4,"presquad_time":"","verify_time":"2025-07-02 21:47:58","match_dls_affected":"false","live_inning_number":4,"day":"4","session":"0","weather":[],"pitch":{"pitch_condition":"Green Pitch","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Essex elected to bat","winner":104950,"decision":1}},"etag":"80176965345f9f3fda3ae0c9a3210fd6","modified":"2025-07-11 17:06:29","datetime":"2025-07-11 17:06:29","api_version":"3.0"}', Modified = GetDate() WHERE Id = 88140 AND DataTypeId = 3 END
Live Report & Scorecard of Yorkshire vs Essex 41st Match
CricDirect Cricket News, Results and Stats
 

Yorkshire vs Essex, 41st Match, County Championship Division One

Completed
County Championship Division One, Completed
Yorkshire
YOR
459/10 (131.2 ov) & 41/0 (9 ov)
Essex
ESS
368/10 (136 ov) & 131/10 (59.1 ov)
Yorkshire won by 10 wickets
BATTERS R B 4S 6S SR
Adam Lyth * 15 26 2 0 57.69
Finlay Bean 18 32 3 0 56.25
BOWLERS O M R W ECON
Noah Thain * 1 0 9 0 9.00
Syed Khaleel Ahmed 4 1 24 0 6.00
Current Partnership: 41 run (9.4 ov) | Last Wicket: () | Fall of Wicket: 0/0 ( ov)
CRR: 4.56
Recent: 11111442

Yorkshire vs Essex, Live Cricket Commentary

End of over 9 (9 runs)
Adam Lyth 15 (26)
Finlay Bean 18 (32)
Yorkshire 41/0
Noah Thain 1-0-9-0
Syed Khaleel Ahmed 4-1-21-0
1
8.6
Noah Thain to Adam Lyth, 1 run,
1
8.5
Noah Thain to Finlay Bean, 1 run,
1
8.4
Noah Thain to Adam Lyth, 1 run,
1
8.3
Noah Thain to Finlay Bean, 1 run,
1
8.2
Noah Thain to Adam Lyth, 1 run,
4
8.1
Noah Thain to Adam Lyth, Four,
End of over 8 (4 runs)
Finlay Bean 16 (30)
Adam Lyth 8 (22)
Yorkshire 32/0
Syed Khaleel Ahmed 4-1-21-0
Shane Snater 4-1-7-0
4
7.6
Syed Khaleel Ahmed to Finlay Bean, Four,
0
7.5
Syed Khaleel Ahmed to Finlay Bean, no run,
0
7.4
Syed Khaleel Ahmed to Finlay Bean, no run,
0
7.3
Syed Khaleel Ahmed to Finlay Bean, no run,
0
7.2
Syed Khaleel Ahmed to Finlay Bean, no run,
0
7.1
Syed Khaleel Ahmed to Finlay Bean, no run,
End of over 7 (2 runs)
Adam Lyth 8 (22)
Finlay Bean 12 (24)
Yorkshire 28/0
Shane Snater 4-1-7-0
Syed Khaleel Ahmed 3-1-17-0
0
6.6
Shane Snater to Adam Lyth, no run,
0
6.5
Shane Snater to Adam Lyth, no run,
0
6.4
Shane Snater to Adam Lyth, no run,
0
6.3
Shane Snater to Adam Lyth, no run,
2
6.2
Shane Snater to Adam Lyth, 2 runs,
0
6.1
Shane Snater to Adam Lyth, no run,
End of over 6 (13 runs)
Finlay Bean 12 (24)
Adam Lyth 6 (16)
Yorkshire 26/0
Syed Khaleel Ahmed 3-1-17-0
Shane Snater 3-1-5-0
4
5.6
Syed Khaleel Ahmed to Finlay Bean, Four,
2nb
5.6
Syed Khaleel Ahmed to Finlay Bean, 2 no ball,
0
5.5
Syed Khaleel Ahmed to Finlay Bean, no run,
0
5.4
Syed Khaleel Ahmed to Finlay Bean, no run,
1
5.3
Syed Khaleel Ahmed to Adam Lyth, 1 run,
4
5.2
Syed Khaleel Ahmed to Adam Lyth, Four,
2nb
5.2
Syed Khaleel Ahmed to Adam Lyth, 2 no ball,
0
5.1
Syed Khaleel Ahmed to Adam Lyth, no run,
End of over 5 (0 runs)
Finlay Bean 8 (20)
Adam Lyth 1 (12)
Yorkshire 13/0
Shane Snater 3-1-5-0
Syed Khaleel Ahmed 2-1-6-0
Match Details
Date
Sunday, June 29, 2025 11:00
Venue
York Cricket Club, York
Toss
Essex elected to bat
Umpires
    Michael Gough (England)
    Peter Hartley (England)
Match Referee
    Will Smith (England)
× Close