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:7d8bad48-d93e-46bf-a485-b869d004c342 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 88134 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (88134,1,'{"status":"ok","response":{"mid":88134,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Match Drawn","day_remaining_over":"90","team_batting":"Nottinghamshire","team_bowling":"Yorkshire","live_inning_number":3,"live_score":{"runs":148,"overs":48,"wickets":1,"target":0,"runrate":3.08,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Freddie McCann","batsman_id":137369,"runs":30,"balls_faced":86,"fours":4,"sixes":0,"strike_rate":"34.88"},{"name":"Ben Slater","batsman_id":48635,"runs":74,"balls_faced":145,"fours":9,"sixes":1,"strike_rate":"51.03"}],"bowlers":[{"name":"Jonny Bairstow","bowler_id":44100,"overs":1,"runs_conceded":6,"wickets":0,"maidens":0,"econ":"6.00"},{"name":"James Wharton","bowler_id":102295,"overs":2,"runs_conceded":5,"wickets":0,"maidens":0,"econ":"2.50"}],"commentaries":[{"event_id":"12226097","event":"ball","batsman_id":"137369","bowler_id":"45911","over":"43","ball":"5","score":0,"commentary":"Daniel Moriarty to Freddie McCann, no run,","noball_dismissal":false,"text":"","timestamp":1750865625,"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":"12226133","event":"ball","batsman_id":"137369","bowler_id":"45911","over":"43","ball":"6","score":2,"commentary":"Daniel Moriarty to Freddie McCann, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750865691,"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":"overend","over":44,"runs":2,"score":"137\/1","bats":[{"runs":27,"balls_faced":73,"fours":4,"sixes":0,"batsman_id":137369},{"runs":66,"balls_faced":134,"fours":8,"sixes":1,"batsman_id":48635}],"bowls":[{"runs_conceded":43,"maidens":6,"wickets":1,"bowler_id":45911,"overs":20},{"runs_conceded":48,"maidens":3,"wickets":0,"bowler_id":50392,"overs":14}],"commentary":"End of over 44 (2 runs), Nottinghamshire 137\/1"},{"event_id":"12226206","event":"ball","batsman_id":"48635","bowler_id":"102295","over":"44","ball":"1","score":0,"commentary":"James Wharton to Ben Slater, no run,","noball_dismissal":false,"text":"","timestamp":1750865959,"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":"12226207","event":"ball","batsman_id":"48635","bowler_id":"102295","over":"44","ball":"2","score":1,"commentary":"James Wharton to Ben Slater, 1 run,","noball_dismissal":false,"text":"","timestamp":1750865962,"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":"12226208","event":"ball","batsman_id":"137369","bowler_id":"102295","over":"44","ball":"3","score":0,"commentary":"James Wharton to Freddie McCann, no run,","noball_dismissal":false,"text":"","timestamp":1750866009,"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":"12226214","event":"ball","batsman_id":"137369","bowler_id":"102295","over":"44","ball":"4","score":0,"commentary":"James Wharton to Freddie McCann, no run,","noball_dismissal":false,"text":"","timestamp":1750866012,"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":"12226215","event":"ball","batsman_id":"137369","bowler_id":"102295","over":"44","ball":"5","score":0,"commentary":"James Wharton to Freddie McCann, no run,","noball_dismissal":false,"text":"","timestamp":1750866692,"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":"12226366","event":"ball","batsman_id":"137369","bowler_id":"102295","over":"44","ball":"6","score":1,"commentary":"James Wharton to Freddie McCann, 1 run,","noball_dismissal":false,"text":"","timestamp":1750866779,"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":45,"runs":2,"score":"139\/1","bats":[{"runs":28,"balls_faced":77,"fours":4,"sixes":0,"batsman_id":137369},{"runs":67,"balls_faced":136,"fours":8,"sixes":1,"batsman_id":48635}],"bowls":[{"runs_conceded":2,"maidens":0,"wickets":0,"bowler_id":102295,"overs":1},{"runs_conceded":43,"maidens":6,"wickets":1,"bowler_id":45911,"overs":20}],"commentary":"End of over 45 (2 runs), Nottinghamshire 139\/1"},{"event_id":"12226367","event":"ball","batsman_id":"137369","bowler_id":"45911","over":"45","ball":"1","score":0,"commentary":"Daniel Moriarty to Freddie McCann, no run,","noball_dismissal":false,"text":"","timestamp":1750866781,"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":"12226368","event":"ball","batsman_id":"137369","bowler_id":"45911","over":"45","ball":"2","score":0,"commentary":"Daniel Moriarty to Freddie McCann, no run,","noball_dismissal":false,"text":"","timestamp":1750866790,"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":"12226369","event":"ball","batsman_id":"137369","bowler_id":"45911","over":"45","ball":"3","score":0,"commentary":"Daniel Moriarty to Freddie McCann, no run,","noball_dismissal":false,"text":"","timestamp":1750866793,"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":"12226370","event":"ball","batsman_id":"137369","bowler_id":"45911","over":"45","ball":"4","score":0,"commentary":"Daniel Moriarty to Freddie McCann, no run,","noball_dismissal":false,"text":"","timestamp":1750866795,"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":"12226371","event":"ball","batsman_id":"137369","bowler_id":"45911","over":"45","ball":"5","score":0,"commentary":"Daniel Moriarty to Freddie McCann, no run,","noball_dismissal":false,"text":"","timestamp":1750866798,"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":"12226372","event":"ball","batsman_id":"137369","bowler_id":"45911","over":"45","ball":"6","score":0,"commentary":"Daniel Moriarty to Freddie McCann, no run,","noball_dismissal":false,"text":"","timestamp":1750866800,"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":46,"runs":0,"score":"139\/1","bats":[{"runs":28,"balls_faced":83,"fours":4,"sixes":0,"batsman_id":137369},{"runs":67,"balls_faced":136,"fours":8,"sixes":1,"batsman_id":48635}],"bowls":[{"runs_conceded":43,"maidens":7,"wickets":1,"bowler_id":45911,"overs":21},{"runs_conceded":2,"maidens":0,"wickets":0,"bowler_id":102295,"overs":1}],"commentary":"End of over 46 (0 runs), Nottinghamshire 139\/1"},{"event_id":"12226375","event":"ball","batsman_id":"48635","bowler_id":"102295","over":"46","ball":"1","score":1,"commentary":"James Wharton to Ben Slater, 1 run,","noball_dismissal":false,"text":"","timestamp":1750866802,"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":"12226376","event":"ball","batsman_id":"137369","bowler_id":"102295","over":"46","ball":"2","score":0,"commentary":"James Wharton to Freddie McCann, no run,","noball_dismissal":false,"text":"","timestamp":1750866805,"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":"12226378","event":"ball","batsman_id":"137369","bowler_id":"102295","over":"46","ball":"3","score":1,"commentary":"James Wharton to Freddie McCann, 1 run,","noball_dismissal":false,"text":"","timestamp":1750866808,"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":"12226380","event":"ball","batsman_id":"48635","bowler_id":"102295","over":"46","ball":"4","score":0,"commentary":"James Wharton to Ben Slater, no run,","noball_dismissal":false,"text":"","timestamp":1750866812,"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":"12226381","event":"ball","batsman_id":"48635","bowler_id":"102295","over":"46","ball":"5","score":1,"commentary":"James Wharton to Ben Slater, 1 run,","noball_dismissal":false,"text":"","timestamp":1750866815,"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":"12226382","event":"ball","batsman_id":"137369","bowler_id":"102295","over":"46","ball":"6","score":0,"commentary":"James Wharton to Freddie McCann, no run,","noball_dismissal":false,"text":"","timestamp":1750866817,"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":47,"runs":3,"score":"142\/1","bats":[{"runs":29,"balls_faced":86,"fours":4,"sixes":0,"batsman_id":137369},{"runs":69,"balls_faced":139,"fours":8,"sixes":1,"batsman_id":48635}],"bowls":[{"runs_conceded":5,"maidens":0,"wickets":0,"bowler_id":102295,"overs":2},{"runs_conceded":43,"maidens":7,"wickets":1,"bowler_id":45911,"overs":21}],"commentary":"End of over 47 (3 runs), Nottinghamshire 142\/1"},{"event_id":"12226386","event":"ball","batsman_id":"48635","bowler_id":"44100","over":"47","ball":"1","score":1,"commentary":"Jonny Bairstow to Ben Slater, 1 run,","noball_dismissal":false,"text":"","timestamp":1750866820,"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":"12226387","event":"ball","batsman_id":"137369","bowler_id":"44100","over":"47","ball":"2","score":1,"commentary":"Jonny Bairstow to Freddie McCann, 1 run,","noball_dismissal":false,"text":"","timestamp":1750866823,"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":"12226388","event":"ball","batsman_id":"48635","bowler_id":"44100","over":"47","ball":"3","score":4,"commentary":"Jonny Bairstow to Ben Slater, Four,","noball_dismissal":false,"text":"","timestamp":1750866826,"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":"12226390","event":"ball","batsman_id":"48635","bowler_id":"44100","over":"47","ball":"4","score":0,"commentary":"Jonny Bairstow to Ben Slater, no run,","noball_dismissal":false,"text":"","timestamp":1750866829,"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":"12226391","event":"ball","batsman_id":"48635","bowler_id":"44100","over":"47","ball":"5","score":0,"commentary":"Jonny Bairstow to Ben Slater, no run,","noball_dismissal":false,"text":"","timestamp":1750866832,"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":"12226393","event":"ball","batsman_id":"48635","bowler_id":"44100","over":"47","ball":"6","score":0,"commentary":"Jonny Bairstow to Ben Slater, no run,","noball_dismissal":false,"text":"","timestamp":1750866837,"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":48,"runs":6,"score":"148\/1","bats":[{"runs":74,"balls_faced":144,"fours":9,"sixes":1,"batsman_id":48635},{"runs":30,"balls_faced":87,"fours":4,"sixes":0,"batsman_id":137369}],"bowls":[{"runs_conceded":6,"maidens":1,"wickets":0,"bowler_id":44100,"overs":2},{"runs_conceded":5,"maidens":0,"wickets":0,"bowler_id":102295,"overs":2}],"commentary":"End of over 48 (6 runs), Nottinghamshire 148\/1"}],"day":"0","session":"0","live_inning":{"iid":198729,"number":3,"name":"Nottinghamshire 2nd Inning","short_name":"NOT 2nd Inning","status":2,"issuperover":"false","result":2,"batting_team_id":6035,"fielding_team_id":7050,"scores":"148\/1","scores_full":"148\/1 (48 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":{"name":"Haseeb Hameed","batsman_id":"48488","runs":"38","balls":"58","how_out":"b DT Moriarty","score_at_dismissal":81,"overs_at_dismissal":"19.5","bowler_id":"45911","dismissal":"bowled","number":1},"extra_runs":{"byes":4,"legbyes":0,"wides":0,"noballs":2,"penalty":"0","total":6},"equations":{"runs":148,"wickets":1,"overs":"48","bowlers_used":7,"runrate":"3.08"},"current_partnership":{"runs":67,"balls":169,"overs":28.1,"batsmen":[{"name":"Freddie McCann","batsman_id":137369,"runs":30,"balls":87},{"name":"Ben Slater","batsman_id":48635,"runs":37,"balls":82}]},"did_not_bat":[{"player_id":"43362","name":"Joe Clarke"},{"player_id":"94965","name":"Jack Haynes"},{"player_id":"93953","name":"Lyndon James"},{"player_id":"94986","name":"Liam Patterson-White"},{"player_id":"131217","name":"Farhan Ahmed"},{"player_id":"93521","name":"Dillon Pennington"},{"player_id":"45206","name":"Mohammad Abbas"},{"player_id":"1097","name":"Ishan Kishan"}],"max_over":"0","target":"0","recent_scores":"0,0,0,4,1,1,0,1,0,1,0,1,0,0,0,0,0,0","last_five_overs":"13\/0 2.60","last_ten_overs":"27\/0 2.70"},"teams":[{"tid":6035,"title":"Nottinghamshire","abbr":"NOT","alt_name":"NOT","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/nottinghamshire-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/nottinghamshire-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"487\/10 (132.4 ov) & 148\/1d (48 ov)","scores":"487\/10 & 148\/1d","overs":"132.4 & 48"},{"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":"510\/10 (185.4 ov)","scores":"510\/10","overs":"185.4"}],"players":[{"pid":1026,"title":"Kyle Verreynne","short_name":"K Verreynne","first_name":"Kyle Verreynne","last_name":"","middle_name":"","birthdate":"1997-05-12","birthplace":"Pretoria, South Africa","country":"za","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"Wicketkeeper ","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/kyle_verreynne","instagram_profile":"https:\/\/www.instagram.com\/kyle_verreynne\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"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":1097,"title":"Ishan Kishan","short_name":"I Kishan","first_name":"Ishan Kishan","last_name":"","middle_name":"","birthdate":"1998-07-18","birthplace":"Patna, Bihar","country":"in","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"Wicket keeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/iamishankishan\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/ishankishan23\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"wk","role_str":""},{"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":"bat","role_str":""},{"pid":43362,"title":"Joe Clarke","short_name":"JM Clarke","first_name":"Joe Clarke","last_name":"","middle_name":"","birthdate":"1996-05-26","birthplace":"Shrewsbury, Shropshire","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":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/C1arke28","instagram_profile":"https:\/\/www.instagram.com\/realdealjoe11\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(C)"},{"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":45206,"title":"Mohammad Abbas","short_name":"M Abbas","first_name":"Mohammad Abbas","last_name":"","middle_name":"","birthdate":"1990-03-10","birthplace":"Sialkot, Punjab","country":"pk","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":"Pakistan","role":"bowl","role_str":""},{"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":"bowl","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":"squad","role_str":""},{"pid":48488,"title":"Haseeb Hameed","short_name":"H Hameed","first_name":"Haseeb Hameed","last_name":"","middle_name":"","birthdate":"1997-01-17","birthplace":"Bolton, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":48635,"title":"Ben Slater","short_name":"BT Slater","first_name":"Ben Slater","last_name":"","middle_name":"","birthdate":"1991-08-26","birthplace":" Chesterfield, Derbyshire","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":48666,"title":"Josh Tongue","short_name":"JC Tongue","first_name":"Josh Tongue","last_name":"","middle_name":"","birthdate":"1997-11-15","birthplace":"Redditch, United Kingdom","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/josh.tongue123\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49793,"title":"Brett Hutton","short_name":"BA Hutton","first_name":"Brett Hutton","last_name":"","middle_name":"","birthdate":"1993-02-06","birthplace":" Doncaster, 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":7,"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":60432,"title":"Matthew Montgomery","short_name":"M Montgomery","first_name":"Matthew Montgomery","last_name":"","middle_name":"","birthdate":"2000-05-10","birthplace":"Johannesburg","country":"de","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Germany","role":"squad","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":93521,"title":"Dillon Pennington","short_name":"D Pennington","first_name":"Dillon Pennington","last_name":"","middle_name":"","birthdate":"1999-02-26","birthplace":"Shrewsbury, Shropshire","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":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/DillonPenningt4","instagram_profile":"https:\/\/www.instagram.com\/dillonp___\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":93953,"title":"Lyndon James","short_name":"LW James","first_name":"Lyndon James","last_name":"","middle_name":"","birthdate":"1997-12-27","birthplace":" Worksop","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","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":"England","role":"bat","role_str":""},{"pid":94965,"title":"Jack Haynes","short_name":"J Haynes","first_name":"Jack Haynes","last_name":"","middle_name":"","birthdate":"2001-01-30","birthplace":"Worcester","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":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/jack_haynes1","instagram_profile":"https:\/\/www.instagram.com\/jack.hayness\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":94986,"title":"Liam Patterson-White","short_name":"LP White","first_name":"Liam Patterson-White","last_name":"","middle_name":"","birthdate":"1998-11-08","birthplace":"Sunderland, Co Durham","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","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":"all","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":"bowl","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":113822,"title":"Fergus O''Neill","short_name":"F O''Neill","first_name":"Fergus O''Neill","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"au","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","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":"Australia","role":"squad","role_str":""},{"pid":131217,"title":"Farhan Ahmed","short_name":"F Ahmed","first_name":"Farhan Ahmed","last_name":"","middle_name":"","birthdate":"2008-02-22","birthplace":"Nottingham","country":"en","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":137369,"title":"Freddie McCann","short_name":"F McCann","first_name":"Freddie McCann","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","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":"all","role_str":"(WK)"}]},"etag":"6fa639602154ee4e884aabaad6ac38b0","modified":"2025-07-15 00:10:08","datetime":"2025-07-15 00:10:08","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":88134,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Match Drawn","day_remaining_over":"90","team_batting":"Nottinghamshire","team_bowling":"Yorkshire","live_inning_number":3,"live_score":{"runs":148,"overs":48,"wickets":1,"target":0,"runrate":3.08,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Freddie McCann","batsman_id":137369,"runs":30,"balls_faced":86,"fours":4,"sixes":0,"strike_rate":"34.88"},{"name":"Ben Slater","batsman_id":48635,"runs":74,"balls_faced":145,"fours":9,"sixes":1,"strike_rate":"51.03"}],"bowlers":[{"name":"Jonny Bairstow","bowler_id":44100,"overs":1,"runs_conceded":6,"wickets":0,"maidens":0,"econ":"6.00"},{"name":"James Wharton","bowler_id":102295,"overs":2,"runs_conceded":5,"wickets":0,"maidens":0,"econ":"2.50"}],"commentaries":[{"event_id":"12226097","event":"ball","batsman_id":"137369","bowler_id":"45911","over":"43","ball":"5","score":0,"commentary":"Daniel Moriarty to Freddie McCann, no run,","noball_dismissal":false,"text":"","timestamp":1750865625,"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":"12226133","event":"ball","batsman_id":"137369","bowler_id":"45911","over":"43","ball":"6","score":2,"commentary":"Daniel Moriarty to Freddie McCann, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750865691,"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":"overend","over":44,"runs":2,"score":"137\/1","bats":[{"runs":27,"balls_faced":73,"fours":4,"sixes":0,"batsman_id":137369},{"runs":66,"balls_faced":134,"fours":8,"sixes":1,"batsman_id":48635}],"bowls":[{"runs_conceded":43,"maidens":6,"wickets":1,"bowler_id":45911,"overs":20},{"runs_conceded":48,"maidens":3,"wickets":0,"bowler_id":50392,"overs":14}],"commentary":"End of over 44 (2 runs), Nottinghamshire 137\/1"},{"event_id":"12226206","event":"ball","batsman_id":"48635","bowler_id":"102295","over":"44","ball":"1","score":0,"commentary":"James Wharton to Ben Slater, no run,","noball_dismissal":false,"text":"","timestamp":1750865959,"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":"12226207","event":"ball","batsman_id":"48635","bowler_id":"102295","over":"44","ball":"2","score":1,"commentary":"James Wharton to Ben Slater, 1 run,","noball_dismissal":false,"text":"","timestamp":1750865962,"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":"12226208","event":"ball","batsman_id":"137369","bowler_id":"102295","over":"44","ball":"3","score":0,"commentary":"James Wharton to Freddie McCann, no run,","noball_dismissal":false,"text":"","timestamp":1750866009,"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":"12226214","event":"ball","batsman_id":"137369","bowler_id":"102295","over":"44","ball":"4","score":0,"commentary":"James Wharton to Freddie McCann, no run,","noball_dismissal":false,"text":"","timestamp":1750866012,"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":"12226215","event":"ball","batsman_id":"137369","bowler_id":"102295","over":"44","ball":"5","score":0,"commentary":"James Wharton to Freddie McCann, no run,","noball_dismissal":false,"text":"","timestamp":1750866692,"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":"12226366","event":"ball","batsman_id":"137369","bowler_id":"102295","over":"44","ball":"6","score":1,"commentary":"James Wharton to Freddie McCann, 1 run,","noball_dismissal":false,"text":"","timestamp":1750866779,"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":45,"runs":2,"score":"139\/1","bats":[{"runs":28,"balls_faced":77,"fours":4,"sixes":0,"batsman_id":137369},{"runs":67,"balls_faced":136,"fours":8,"sixes":1,"batsman_id":48635}],"bowls":[{"runs_conceded":2,"maidens":0,"wickets":0,"bowler_id":102295,"overs":1},{"runs_conceded":43,"maidens":6,"wickets":1,"bowler_id":45911,"overs":20}],"commentary":"End of over 45 (2 runs), Nottinghamshire 139\/1"},{"event_id":"12226367","event":"ball","batsman_id":"137369","bowler_id":"45911","over":"45","ball":"1","score":0,"commentary":"Daniel Moriarty to Freddie McCann, no run,","noball_dismissal":false,"text":"","timestamp":1750866781,"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":"12226368","event":"ball","batsman_id":"137369","bowler_id":"45911","over":"45","ball":"2","score":0,"commentary":"Daniel Moriarty to Freddie McCann, no run,","noball_dismissal":false,"text":"","timestamp":1750866790,"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":"12226369","event":"ball","batsman_id":"137369","bowler_id":"45911","over":"45","ball":"3","score":0,"commentary":"Daniel Moriarty to Freddie McCann, no run,","noball_dismissal":false,"text":"","timestamp":1750866793,"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":"12226370","event":"ball","batsman_id":"137369","bowler_id":"45911","over":"45","ball":"4","score":0,"commentary":"Daniel Moriarty to Freddie McCann, no run,","noball_dismissal":false,"text":"","timestamp":1750866795,"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":"12226371","event":"ball","batsman_id":"137369","bowler_id":"45911","over":"45","ball":"5","score":0,"commentary":"Daniel Moriarty to Freddie McCann, no run,","noball_dismissal":false,"text":"","timestamp":1750866798,"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":"12226372","event":"ball","batsman_id":"137369","bowler_id":"45911","over":"45","ball":"6","score":0,"commentary":"Daniel Moriarty to Freddie McCann, no run,","noball_dismissal":false,"text":"","timestamp":1750866800,"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":46,"runs":0,"score":"139\/1","bats":[{"runs":28,"balls_faced":83,"fours":4,"sixes":0,"batsman_id":137369},{"runs":67,"balls_faced":136,"fours":8,"sixes":1,"batsman_id":48635}],"bowls":[{"runs_conceded":43,"maidens":7,"wickets":1,"bowler_id":45911,"overs":21},{"runs_conceded":2,"maidens":0,"wickets":0,"bowler_id":102295,"overs":1}],"commentary":"End of over 46 (0 runs), Nottinghamshire 139\/1"},{"event_id":"12226375","event":"ball","batsman_id":"48635","bowler_id":"102295","over":"46","ball":"1","score":1,"commentary":"James Wharton to Ben Slater, 1 run,","noball_dismissal":false,"text":"","timestamp":1750866802,"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":"12226376","event":"ball","batsman_id":"137369","bowler_id":"102295","over":"46","ball":"2","score":0,"commentary":"James Wharton to Freddie McCann, no run,","noball_dismissal":false,"text":"","timestamp":1750866805,"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":"12226378","event":"ball","batsman_id":"137369","bowler_id":"102295","over":"46","ball":"3","score":1,"commentary":"James Wharton to Freddie McCann, 1 run,","noball_dismissal":false,"text":"","timestamp":1750866808,"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":"12226380","event":"ball","batsman_id":"48635","bowler_id":"102295","over":"46","ball":"4","score":0,"commentary":"James Wharton to Ben Slater, no run,","noball_dismissal":false,"text":"","timestamp":1750866812,"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":"12226381","event":"ball","batsman_id":"48635","bowler_id":"102295","over":"46","ball":"5","score":1,"commentary":"James Wharton to Ben Slater, 1 run,","noball_dismissal":false,"text":"","timestamp":1750866815,"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":"12226382","event":"ball","batsman_id":"137369","bowler_id":"102295","over":"46","ball":"6","score":0,"commentary":"James Wharton to Freddie McCann, no run,","noball_dismissal":false,"text":"","timestamp":1750866817,"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":47,"runs":3,"score":"142\/1","bats":[{"runs":29,"balls_faced":86,"fours":4,"sixes":0,"batsman_id":137369},{"runs":69,"balls_faced":139,"fours":8,"sixes":1,"batsman_id":48635}],"bowls":[{"runs_conceded":5,"maidens":0,"wickets":0,"bowler_id":102295,"overs":2},{"runs_conceded":43,"maidens":7,"wickets":1,"bowler_id":45911,"overs":21}],"commentary":"End of over 47 (3 runs), Nottinghamshire 142\/1"},{"event_id":"12226386","event":"ball","batsman_id":"48635","bowler_id":"44100","over":"47","ball":"1","score":1,"commentary":"Jonny Bairstow to Ben Slater, 1 run,","noball_dismissal":false,"text":"","timestamp":1750866820,"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":"12226387","event":"ball","batsman_id":"137369","bowler_id":"44100","over":"47","ball":"2","score":1,"commentary":"Jonny Bairstow to Freddie McCann, 1 run,","noball_dismissal":false,"text":"","timestamp":1750866823,"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":"12226388","event":"ball","batsman_id":"48635","bowler_id":"44100","over":"47","ball":"3","score":4,"commentary":"Jonny Bairstow to Ben Slater, Four,","noball_dismissal":false,"text":"","timestamp":1750866826,"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":"12226390","event":"ball","batsman_id":"48635","bowler_id":"44100","over":"47","ball":"4","score":0,"commentary":"Jonny Bairstow to Ben Slater, no run,","noball_dismissal":false,"text":"","timestamp":1750866829,"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":"12226391","event":"ball","batsman_id":"48635","bowler_id":"44100","over":"47","ball":"5","score":0,"commentary":"Jonny Bairstow to Ben Slater, no run,","noball_dismissal":false,"text":"","timestamp":1750866832,"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":"12226393","event":"ball","batsman_id":"48635","bowler_id":"44100","over":"47","ball":"6","score":0,"commentary":"Jonny Bairstow to Ben Slater, no run,","noball_dismissal":false,"text":"","timestamp":1750866837,"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":48,"runs":6,"score":"148\/1","bats":[{"runs":74,"balls_faced":144,"fours":9,"sixes":1,"batsman_id":48635},{"runs":30,"balls_faced":87,"fours":4,"sixes":0,"batsman_id":137369}],"bowls":[{"runs_conceded":6,"maidens":1,"wickets":0,"bowler_id":44100,"overs":2},{"runs_conceded":5,"maidens":0,"wickets":0,"bowler_id":102295,"overs":2}],"commentary":"End of over 48 (6 runs), Nottinghamshire 148\/1"}],"day":"0","session":"0","live_inning":{"iid":198729,"number":3,"name":"Nottinghamshire 2nd Inning","short_name":"NOT 2nd Inning","status":2,"issuperover":"false","result":2,"batting_team_id":6035,"fielding_team_id":7050,"scores":"148\/1","scores_full":"148\/1 (48 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":{"name":"Haseeb Hameed","batsman_id":"48488","runs":"38","balls":"58","how_out":"b DT Moriarty","score_at_dismissal":81,"overs_at_dismissal":"19.5","bowler_id":"45911","dismissal":"bowled","number":1},"extra_runs":{"byes":4,"legbyes":0,"wides":0,"noballs":2,"penalty":"0","total":6},"equations":{"runs":148,"wickets":1,"overs":"48","bowlers_used":7,"runrate":"3.08"},"current_partnership":{"runs":67,"balls":169,"overs":28.1,"batsmen":[{"name":"Freddie McCann","batsman_id":137369,"runs":30,"balls":87},{"name":"Ben Slater","batsman_id":48635,"runs":37,"balls":82}]},"did_not_bat":[{"player_id":"43362","name":"Joe Clarke"},{"player_id":"94965","name":"Jack Haynes"},{"player_id":"93953","name":"Lyndon James"},{"player_id":"94986","name":"Liam Patterson-White"},{"player_id":"131217","name":"Farhan Ahmed"},{"player_id":"93521","name":"Dillon Pennington"},{"player_id":"45206","name":"Mohammad Abbas"},{"player_id":"1097","name":"Ishan Kishan"}],"max_over":"0","target":"0","recent_scores":"0,0,0,4,1,1,0,1,0,1,0,1,0,0,0,0,0,0","last_five_overs":"13\/0 2.60","last_ten_overs":"27\/0 2.70"},"teams":[{"tid":6035,"title":"Nottinghamshire","abbr":"NOT","alt_name":"NOT","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/nottinghamshire-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/nottinghamshire-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"487\/10 (132.4 ov) & 148\/1d (48 ov)","scores":"487\/10 & 148\/1d","overs":"132.4 & 48"},{"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":"510\/10 (185.4 ov)","scores":"510\/10","overs":"185.4"}],"players":[{"pid":1026,"title":"Kyle Verreynne","short_name":"K Verreynne","first_name":"Kyle Verreynne","last_name":"","middle_name":"","birthdate":"1997-05-12","birthplace":"Pretoria, South Africa","country":"za","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"Wicketkeeper ","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/kyle_verreynne","instagram_profile":"https:\/\/www.instagram.com\/kyle_verreynne\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"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":1097,"title":"Ishan Kishan","short_name":"I Kishan","first_name":"Ishan Kishan","last_name":"","middle_name":"","birthdate":"1998-07-18","birthplace":"Patna, Bihar","country":"in","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"Wicket keeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/iamishankishan\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/ishankishan23\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"wk","role_str":""},{"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":"bat","role_str":""},{"pid":43362,"title":"Joe Clarke","short_name":"JM Clarke","first_name":"Joe Clarke","last_name":"","middle_name":"","birthdate":"1996-05-26","birthplace":"Shrewsbury, Shropshire","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":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/C1arke28","instagram_profile":"https:\/\/www.instagram.com\/realdealjoe11\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(C)"},{"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":45206,"title":"Mohammad Abbas","short_name":"M Abbas","first_name":"Mohammad Abbas","last_name":"","middle_name":"","birthdate":"1990-03-10","birthplace":"Sialkot, Punjab","country":"pk","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":"Pakistan","role":"bowl","role_str":""},{"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":"bowl","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":"squad","role_str":""},{"pid":48488,"title":"Haseeb Hameed","short_name":"H Hameed","first_name":"Haseeb Hameed","last_name":"","middle_name":"","birthdate":"1997-01-17","birthplace":"Bolton, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":48635,"title":"Ben Slater","short_name":"BT Slater","first_name":"Ben Slater","last_name":"","middle_name":"","birthdate":"1991-08-26","birthplace":" Chesterfield, Derbyshire","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":48666,"title":"Josh Tongue","short_name":"JC Tongue","first_name":"Josh Tongue","last_name":"","middle_name":"","birthdate":"1997-11-15","birthplace":"Redditch, United Kingdom","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/josh.tongue123\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49793,"title":"Brett Hutton","short_name":"BA Hutton","first_name":"Brett Hutton","last_name":"","middle_name":"","birthdate":"1993-02-06","birthplace":" Doncaster, 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":7,"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":60432,"title":"Matthew Montgomery","short_name":"M Montgomery","first_name":"Matthew Montgomery","last_name":"","middle_name":"","birthdate":"2000-05-10","birthplace":"Johannesburg","country":"de","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Germany","role":"squad","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":93521,"title":"Dillon Pennington","short_name":"D Pennington","first_name":"Dillon Pennington","last_name":"","middle_name":"","birthdate":"1999-02-26","birthplace":"Shrewsbury, Shropshire","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":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/DillonPenningt4","instagram_profile":"https:\/\/www.instagram.com\/dillonp___\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":93953,"title":"Lyndon James","short_name":"LW James","first_name":"Lyndon James","last_name":"","middle_name":"","birthdate":"1997-12-27","birthplace":" Worksop","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","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":"England","role":"bat","role_str":""},{"pid":94965,"title":"Jack Haynes","short_name":"J Haynes","first_name":"Jack Haynes","last_name":"","middle_name":"","birthdate":"2001-01-30","birthplace":"Worcester","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":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/jack_haynes1","instagram_profile":"https:\/\/www.instagram.com\/jack.hayness\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":94986,"title":"Liam Patterson-White","short_name":"LP White","first_name":"Liam Patterson-White","last_name":"","middle_name":"","birthdate":"1998-11-08","birthplace":"Sunderland, Co Durham","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","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":"all","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":"bowl","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":113822,"title":"Fergus O''Neill","short_name":"F O''Neill","first_name":"Fergus O''Neill","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"au","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","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":"Australia","role":"squad","role_str":""},{"pid":131217,"title":"Farhan Ahmed","short_name":"F Ahmed","first_name":"Farhan Ahmed","last_name":"","middle_name":"","birthdate":"2008-02-22","birthplace":"Nottingham","country":"en","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":137369,"title":"Freddie McCann","short_name":"F McCann","first_name":"Freddie McCann","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","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":"all","role_str":"(WK)"}]},"etag":"6fa639602154ee4e884aabaad6ac38b0","modified":"2025-07-15 00:10:08","datetime":"2025-07-15 00:10:08","api_version":"3.0"}', Modified = GetDate() WHERE Id = 88134 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:7d8bad48-d93e-46bf-a485-b869d004c342 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 88134 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (88134,3,'{"status":"ok","response":{"match_id":88134,"title":"Nottinghamshire vs Yorkshire","short_title":"NOT vs YOR","subtitle":"40th Match","match_number":"40","format":5,"format_str":"First Class","status":2,"status_str":"Completed","status_note":"Match Drawn","verified":"false","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":6035,"name":"Nottinghamshire","short_name":"NOT","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/nottinghamshire-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/nottinghamshire-logo.png","scores_full":"487\/10 (132.4 ov) & 148\/1d (48 ov)","scores":"487\/10 & 148\/1d","overs":"132.4 & 48"},"teamb":{"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":"510\/10 (185.4 ov)","scores":"510\/10","overs":"185.4"},"date_start":"2025-06-22 10:00:00","date_end":"2025-06-27 10:00:00","timestamp_start":1750586400,"timestamp_end":1751018400,"date_start_ist":"2025-06-22 15:30:00","date_end_ist":"2025-06-27 15:30:00","venue":{"venue_id":"6","name":"Trent Bridge","location":"Nottingham","country":"England","timezone":""},"umpires":"Steve O''Shaughnessy (England), Russell Warren (England)","referee":"Phil Whitticase (England)","equation":"Match Drawn","live":"","result":"Match Drawn","result_type":3,"win_margin":"","winning_team_id":0,"commentary":1,"wagon":2,"latest_inning_number":3,"presquad_time":"","verify_time":"","match_dls_affected":"false","live_inning_number":3,"day":"0","session":"0","weather":[],"pitch":{"pitch_condition":"","batting_condition":"Average","pace_bowling_condition":"Average","spine_bowling_condition":"Average"},"toss":{"text":"Nottinghamshire elected to bat","winner":6035,"decision":1}},"etag":"c59c9eabbdbb4fb061a80cb15dc7e248","modified":"2025-07-15 00:10:09","datetime":"2025-07-15 00:10:09","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":88134,"title":"Nottinghamshire vs Yorkshire","short_title":"NOT vs YOR","subtitle":"40th Match","match_number":"40","format":5,"format_str":"First Class","status":2,"status_str":"Completed","status_note":"Match Drawn","verified":"false","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":6035,"name":"Nottinghamshire","short_name":"NOT","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/nottinghamshire-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/nottinghamshire-logo.png","scores_full":"487\/10 (132.4 ov) & 148\/1d (48 ov)","scores":"487\/10 & 148\/1d","overs":"132.4 & 48"},"teamb":{"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":"510\/10 (185.4 ov)","scores":"510\/10","overs":"185.4"},"date_start":"2025-06-22 10:00:00","date_end":"2025-06-27 10:00:00","timestamp_start":1750586400,"timestamp_end":1751018400,"date_start_ist":"2025-06-22 15:30:00","date_end_ist":"2025-06-27 15:30:00","venue":{"venue_id":"6","name":"Trent Bridge","location":"Nottingham","country":"England","timezone":""},"umpires":"Steve O''Shaughnessy (England), Russell Warren (England)","referee":"Phil Whitticase (England)","equation":"Match Drawn","live":"","result":"Match Drawn","result_type":3,"win_margin":"","winning_team_id":0,"commentary":1,"wagon":2,"latest_inning_number":3,"presquad_time":"","verify_time":"","match_dls_affected":"false","live_inning_number":3,"day":"0","session":"0","weather":[],"pitch":{"pitch_condition":"","batting_condition":"Average","pace_bowling_condition":"Average","spine_bowling_condition":"Average"},"toss":{"text":"Nottinghamshire elected to bat","winner":6035,"decision":1}},"etag":"c59c9eabbdbb4fb061a80cb15dc7e248","modified":"2025-07-15 00:10:09","datetime":"2025-07-15 00:10:09","api_version":"3.0"}', Modified = GetDate() WHERE Id = 88134 AND DataTypeId = 3 END
Live Report & Scorecard of Nottinghamshire vs Yorkshire 40th Match

Hong Kong Women

Kuwait Women

LIVE06 May Match 6

Thailand Women

United Arab Emirates Women

LIVEToday1st Youth Test

England Under-19s439/10 (114.5 ov)

India Under-19s540/10 (112.5 ov) & *128/3 (27 ov)

Stumps : Day 3 - India Under-19s lead by 229 runs.

LIVEToday1st Unofficial Test

Australia A*241/4 (87 ov)

Sri Lanka A272/10 (82 ov)

Stumps : Day 2 - Australia A trail by 31 runs.

Scheduled15 July Match 15

Nabarang Club

City Cricket Club

Scheduled15 July Match 6

SC Krefeld Spartans

Lenkerbeck Marl

Scheduled15 July Match 16

Gauhati Town Club

Bud CC

Scheduled15 July Match 16

Karaikal Kniights

Ruby White Town legends

Scheduled15 July Match 7

SC Krefeld Spartans

Koln CC

Scheduled15 July Match 8

Grey Caps Aachen

Koln CC

Scheduled15 July Match 17

Yanam Royals

Ossudu Accord Warriors

Scheduled15 July Match 9

Lenkerbeck Marl

VFB Gelsenkirchen

Scheduled15 July Match 51

Durham Women

Surrey Women

Scheduled15 July Match 10

VFB Gelsenkirchen

Grey Caps Aachen

Scheduled15 July Match 13

CECC-A

MEC Study Group

Scheduled15 July Match 113

Durham

Leicestershire

Scheduled15 July Match 7

Central Districts

Hobart Hurricanes

Scheduled16 July Match 17

Gauhati Town Club

91 Yard Club

Scheduled16 July Match 11

SC Krefeld Boosters

Dussledorf Blackcaps

Scheduled16 July Match 18

Bud CC

Nabarang Club

Live Cricket Match Centre

Nottinghamshire vs Yorkshire, 40th Match, County Championship Division One

Completed

County Championship Division One, Completed

Nottinghamshire

NOT

487/10 (132.4 ov) & 148/1d (48 ov)

Yorkshire

YOR

510/10 (185.4 ov)

Match Drawn

BATTERS	R	B	4S	6S	SR
Freddie McCann *	30	86	4	0	34.88
Ben Slater	74	145	9	1	51.03

BOWLERS	O	M	R	W	ECON
Jonny Bairstow *	1	0	6	0	6.00
James Wharton	2	0	5	0	2.50

Current Partnership: 67 run (28.1 ov) | Last Wicket: Haseeb Hameed 38 (58) | Fall of Wicket: 81/1 (19.5 ov)

CRR: 3.08

Recent: •••411•1•1•1••••••

Nottinghamshire vs Yorkshire, Live Cricket Commentary

End of over 48 (6 runs)

Ben Slater 74 (144)

Freddie McCann 30 (87)

Nottinghamshire 148/1

Jonny Bairstow 2-1-6-0

James Wharton 2-0-5-0

47.6

Jonny Bairstow to Ben Slater, no run,

47.5

Jonny Bairstow to Ben Slater, no run,

47.4

Jonny Bairstow to Ben Slater, no run,

47.3

Jonny Bairstow to Ben Slater, Four,

47.2

Jonny Bairstow to Freddie McCann, 1 run,

47.1

Jonny Bairstow to Ben Slater, 1 run,

End of over 47 (3 runs)

Freddie McCann 29 (86)

Ben Slater 69 (139)

Nottinghamshire 142/1

James Wharton 2-0-5-0

Daniel Moriarty 21-7-43-1

46.6

James Wharton to Freddie McCann, no run,

46.5

James Wharton to Ben Slater, 1 run,

46.4

James Wharton to Ben Slater, no run,

46.3

James Wharton to Freddie McCann, 1 run,

46.2

James Wharton to Freddie McCann, no run,

46.1

James Wharton to Ben Slater, 1 run,

End of over 46 (0 runs)

Freddie McCann 28 (83)

Ben Slater 67 (136)

Nottinghamshire 139/1

Daniel Moriarty 21-7-43-1

James Wharton 1-0-2-0

45.6

Daniel Moriarty to Freddie McCann, no run,

45.5

Daniel Moriarty to Freddie McCann, no run,

45.4

Daniel Moriarty to Freddie McCann, no run,

45.3

Daniel Moriarty to Freddie McCann, no run,

45.2

Daniel Moriarty to Freddie McCann, no run,

45.1

Daniel Moriarty to Freddie McCann, no run,

End of over 45 (2 runs)

Freddie McCann 28 (77)

Ben Slater 67 (136)

Nottinghamshire 139/1

James Wharton 1-0-2-0

Daniel Moriarty 20-6-43-1

44.6

James Wharton to Freddie McCann, 1 run,

44.5

James Wharton to Freddie McCann, no run,

44.4

James Wharton to Freddie McCann, no run,

44.3

James Wharton to Freddie McCann, no run,

44.2

James Wharton to Ben Slater, 1 run,

44.1

James Wharton to Ben Slater, no run,

End of over 44 (2 runs)

Freddie McCann 27 (73)

Ben Slater 66 (134)

Nottinghamshire 137/1

Daniel Moriarty 20-6-43-1

Dom Bess 14-3-48-0

43.6

Daniel Moriarty to Freddie McCann, 2 runs,

43.5

Daniel Moriarty to Freddie McCann, no run,

Date

Sunday, June 22, 2025 11:00

Venue

Trent Bridge, Nottingham

Toss

Nottinghamshire elected to bat

Umpires

Match Referee

Phil Whitticase (England)

× Close