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
Yorkshire vs Essex, Live Cricket Commentary