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:fd789208-6e88-49ee-bfc0-4a0f35a858c6 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86927 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86927,1,'{"status":"ok","response":{"mid":86927,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Surrey won by 67 runs","day_remaining_over":"","team_batting":"Somerset","team_bowling":"Surrey","live_inning_number":2,"live_score":{"runs":134,"overs":19.3,"wickets":10,"target":202,"runrate":6.87,"required_runrate":136},"commentary":1,"wagon":2,"batsmen":[{"name":"Lewis Goldsworthy","batsman_id":95554,"runs":3,"balls_faced":9,"fours":0,"sixes":0,"strike_rate":"33.33"},{"name":"Jack Leach","batsman_id":49425,"runs":8,"balls_faced":8,"fours":1,"sixes":0,"strike_rate":"100.00"}],"bowlers":[{"name":"Chris Jordan","bowler_id":454,"overs":3.3,"runs_conceded":34,"wickets":1,"maidens":0,"econ":"9.71"},{"name":"Sam Curran","bowler_id":1047,"overs":4,"runs_conceded":27,"wickets":2,"maidens":0,"econ":"6.75"}],"commentaries":[{"event_id":"12342455","event":"ball","batsman_id":"57592","bowler_id":"1965","over":"15","ball":"1","score":0,"commentary":"Adam Zampa to Migael Pretorius, no run,","noball_dismissal":false,"text":"","timestamp":1752427092,"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":"12342459","event":"ball","batsman_id":"57592","bowler_id":"1965","over":"15","ball":"2","score":0,"commentary":"Adam Zampa to Migael Pretorius, no run,","noball_dismissal":false,"text":"","timestamp":1752427100,"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":"12342463","event":"ball","batsman_id":"57592","bowler_id":"1965","over":"15","ball":"3","score":0,"commentary":"Adam Zampa to Migael Pretorius, no run,","noball_dismissal":false,"text":"","timestamp":1752427125,"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":"12342466","event":"ball","batsman_id":"57592","bowler_id":"1965","over":"15","ball":"4","score":1,"commentary":"Adam Zampa to Migael Pretorius, 1 run,","noball_dismissal":false,"text":"","timestamp":1752427168,"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":"12342471","event":"wicket","batsman_id":"1049","bowler_id":"1965","over":"15","ball":"5","score":"w","commentary":"Adam Zampa to Ben Green, no run, c J Roy b A Zampa,","noball_dismissal":false,"text":"","timestamp":1752427220,"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,"wicket_batsman_id":"1049","how_out":"c J Roy b A Zampa","batsman_runs":"11","batsman_balls":"12"},{"event_id":"12342478","event":"ball","batsman_id":"95554","bowler_id":"1965","over":"15","ball":"6","score":0,"commentary":"Adam Zampa to Lewis Goldsworthy, no run,","noball_dismissal":false,"text":"","timestamp":1752427299,"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":16,"runs":1,"score":"122\/7","bats":[{"runs":0,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":95554},{"runs":2,"balls_faced":6,"fours":0,"sixes":0,"batsman_id":57592}],"bowls":[{"runs_conceded":28,"maidens":0,"wickets":2,"bowler_id":1965,"overs":4},{"runs_conceded":20,"maidens":0,"wickets":2,"bowler_id":1047,"overs":3}],"commentary":"End of over 16 (1 runs), Somerset 122\/7"},{"event_id":"12342487","event":"wicket","batsman_id":"57592","bowler_id":"1937","over":"16","ball":"1","score":"w","commentary":"Reece Topley to Migael Pretorius, no run, c WG Jacks b R Topley,","noball_dismissal":false,"text":"","timestamp":1752427405,"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,"wicket_batsman_id":"57592","how_out":"c WG Jacks b R Topley","batsman_runs":"2","batsman_balls":"7"},{"event_id":"12342490","event":"ball","batsman_id":"93329","bowler_id":"1937","over":"16","ball":"2","score":0,"commentary":"Reece Topley to Riley Meredith, no run,","noball_dismissal":false,"text":"","timestamp":1752427413,"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":"12342495","event":"ball","batsman_id":"93329","bowler_id":"1937","over":"16","ball":"3","score":1,"commentary":"Reece Topley to Riley Meredith, 1 run,","noball_dismissal":false,"text":"","timestamp":1752427503,"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":"12342499","event":"ball","batsman_id":"95554","bowler_id":"1937","over":"16","ball":"4","score":1,"commentary":"Reece Topley to Lewis Goldsworthy, 1 run,","noball_dismissal":false,"text":"","timestamp":1752427541,"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":"12342506","event":"ball","batsman_id":"93329","bowler_id":"1937","over":"16","ball":"5","score":0,"commentary":"Reece Topley to Riley Meredith, no run,","noball_dismissal":false,"text":"","timestamp":1752427629,"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":"12342511","event":"wicket","batsman_id":"93329","bowler_id":"1937","over":"16","ball":"6","score":"w","commentary":"Reece Topley to Riley Meredith, no run, c WG Jacks b R Topley,","noball_dismissal":false,"text":"","timestamp":1752427701,"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,"wicket_batsman_id":"93329","how_out":"c WG Jacks b R Topley","batsman_runs":"1","batsman_balls":"4"},{"event":"overend","over":17,"runs":2,"score":"124\/9","bats":[{"runs":1,"balls_faced":4,"fours":0,"sixes":0,"batsman_id":93329},{"runs":1,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":95554}],"bowls":[{"runs_conceded":20,"maidens":0,"wickets":3,"bowler_id":1937,"overs":4},{"runs_conceded":28,"maidens":0,"wickets":2,"bowler_id":1965,"overs":4}],"commentary":"End of over 17 (2 runs), Somerset 124\/9"},{"event_id":"12342513","event":"ball","batsman_id":"95554","bowler_id":"454","over":"17","ball":"1","score":1,"commentary":"Chris Jordan to Lewis Goldsworthy, 1 run,","noball_dismissal":false,"text":"","timestamp":1752427737,"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":"12342517","event":"ball","batsman_id":"49425","bowler_id":"454","over":"17","ball":"2","score":0,"commentary":"Chris Jordan to Jack Leach, no run,","noball_dismissal":false,"text":"","timestamp":1752427755,"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":"12342519","event":"ball","batsman_id":"49425","bowler_id":"454","over":"17","ball":"3","score":0,"commentary":"Chris Jordan to Jack Leach, no run,","noball_dismissal":false,"text":"","timestamp":1752427787,"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":"12342520","event":"ball","batsman_id":"49425","bowler_id":"454","over":"17","ball":"4","score":1,"commentary":"Chris Jordan to Jack Leach, 1 run,","noball_dismissal":false,"text":"","timestamp":1752427796,"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":"12342526","event":"ball","batsman_id":"95554","bowler_id":"454","over":"17","ball":"5","score":0,"commentary":"Chris Jordan to Lewis Goldsworthy, no run,","noball_dismissal":false,"text":"","timestamp":1752427851,"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":"12342527","event":"ball","batsman_id":"95554","bowler_id":"454","over":"17","ball":"6","score":0,"commentary":"Chris Jordan to Lewis Goldsworthy, no run,","noball_dismissal":false,"text":"","timestamp":1752427859,"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":18,"runs":2,"score":"126\/9","bats":[{"runs":2,"balls_faced":5,"fours":0,"sixes":0,"batsman_id":95554},{"runs":1,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":49425}],"bowls":[{"runs_conceded":33,"maidens":0,"wickets":0,"bowler_id":454,"overs":3},{"runs_conceded":20,"maidens":0,"wickets":3,"bowler_id":1937,"overs":4}],"commentary":"End of over 18 (2 runs), Somerset 126\/9"},{"event_id":"12342533","event":"ball","batsman_id":"49425","bowler_id":"1047","over":"18","ball":"1","score":4,"commentary":"Sam Curran to Jack Leach, Four,","noball_dismissal":false,"text":"","timestamp":1752427895,"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":"12342536","event":"ball","batsman_id":"49425","bowler_id":"1047","over":"18","ball":"2","score":1,"commentary":"Sam Curran to Jack Leach, 1 run,","noball_dismissal":false,"text":"","timestamp":1752427935,"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":"12342540","event":"ball","batsman_id":"95554","bowler_id":"1047","over":"18","ball":"3","score":1,"commentary":"Sam Curran to Lewis Goldsworthy, 1 run,","noball_dismissal":false,"text":"","timestamp":1752427974,"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":"12342541","event":"ball","batsman_id":"49425","bowler_id":"1047","over":"18","ball":"4","score":0,"commentary":"Sam Curran to Jack Leach, no run,","noball_dismissal":false,"text":"","timestamp":1752428008,"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":"12342545","event":"ball","batsman_id":"49425","bowler_id":"1047","over":"18","ball":"5","score":1,"commentary":"Sam Curran to Jack Leach, 1 run,","noball_dismissal":false,"text":"","timestamp":1752428069,"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":"12342548","event":"ball","batsman_id":"95554","bowler_id":"1047","over":"18","ball":"6","score":0,"commentary":"Sam Curran to Lewis Goldsworthy, no run,","noball_dismissal":false,"text":"","timestamp":1752428109,"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":19,"runs":7,"score":"133\/9","bats":[{"runs":3,"balls_faced":7,"fours":0,"sixes":0,"batsman_id":95554},{"runs":7,"balls_faced":7,"fours":1,"sixes":0,"batsman_id":49425}],"bowls":[{"runs_conceded":27,"maidens":0,"wickets":2,"bowler_id":1047,"overs":4},{"runs_conceded":33,"maidens":0,"wickets":0,"bowler_id":454,"overs":3}],"commentary":"End of over 19 (7 runs), Somerset 133\/9"},{"event_id":"12342554","event":"ball","batsman_id":"49425","bowler_id":"454","over":"19","ball":"1","score":1,"commentary":"Chris Jordan to Jack Leach, 1 run,","noball_dismissal":false,"text":"","timestamp":1752428170,"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":"12342557","event":"ball","batsman_id":"95554","bowler_id":"454","over":"19","ball":"2","score":0,"commentary":"Chris Jordan to Lewis Goldsworthy, no run,","noball_dismissal":false,"text":"","timestamp":1752428213,"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":"12342562","event":"wicket","batsman_id":"95554","bowler_id":"454","over":"19","ball":"3","score":"w","commentary":"Chris Jordan to Lewis Goldsworthy, no run, c J Overton b C Jordan,","noball_dismissal":false,"text":"","timestamp":1752428351,"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,"wicket_batsman_id":"95554","how_out":"c J Overton b C Jordan","batsman_runs":"3","batsman_balls":"9"}],"day":"0","session":"0","live_inning":{"iid":199616,"number":2,"name":"Somerset Inning","short_name":"SOM Inning","status":2,"issuperover":"false","result":1,"batting_team_id":7010,"fielding_team_id":6995,"scores":"134\/10","scores_full":"134\/10 (19.3 ov)","fielder":[{"fielder_id":"1937","fielder_name":"Reece Topley","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"10598","fielder_name":"Ben Foakes","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"1042","fielder_name":"Dan Lawrence","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"43383","fielder_name":"Jamie Overton","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"1929","fielder_name":"Jason Roy","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"51319","fielder_name":"Will Jacks","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"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":"Lewis Goldsworthy","batsman_id":"95554","runs":"3","balls":"9","how_out":"c J Overton b C Jordan","score_at_dismissal":134,"overs_at_dismissal":"19.3","bowler_id":"454","dismissal":"caught","number":10},"extra_runs":{"byes":0,"legbyes":2,"wides":5,"noballs":0,"penalty":"0","total":7},"equations":{"runs":134,"wickets":10,"overs":"19.3","bowlers_used":5,"runrate":"6.87"},"current_partnership":{"runs":10,"balls":15,"overs":2.3,"batsmen":[{"name":"Lewis Goldsworthy","batsman_id":95554,"runs":2,"balls":7},{"name":"Jack Leach","batsman_id":49425,"runs":8,"balls":8}]},"did_not_bat":[],"max_over":"20","target":"202","recent_scores":"w,0,1,0,1,0,1,1,4,0,0,1,0,0,1,w,0,1","last_five_overs":"15\/4 2.90","last_ten_overs":"58\/6 5.61"},"teams":[{"tid":6995,"title":"Surrey","abbr":"SUR","alt_name":"Surrey","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/surrey-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/surrey-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"201\/6 (20 ov)","scores":"201\/6","overs":"20"},{"tid":7010,"title":"Somerset","abbr":"SOM","alt_name":"SOM","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/somerset-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/somerset-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"134\/10 (19.3 ov)","scores":"134\/10","overs":"19.3"}],"players":[{"pid":301,"title":"Josh Davey","short_name":"J Davey","first_name":"Josh Davey","last_name":"","middle_name":"","birthdate":"1990-08-03","birthplace":"Aberdeen, United Kingdom","country":"sct","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Scotland","role":"squad","role_str":""},{"pid":454,"title":"Chris Jordan","short_name":"C Jordan","first_name":"Chris Jordan","last_name":"","middle_name":"","birthdate":"1988-10-04","birthplace":"Barbados","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":8.5,"facebook_profile":"https:\/\/www.facebook.com\/ChrisJordanOfficial\/","twitter_profile":"https:\/\/twitter.com\/CJordan","instagram_profile":"https:\/\/www.instagram.com\/cjrjordan\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":486,"title":"Matt Henry","short_name":"M Henry","first_name":"Matt Henry","last_name":"","middle_name":"","birthdate":"1991-12-14","birthplace":"Christchurch, Canterbury","country":"nz","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"squad","role_str":""},{"pid":1042,"title":"Dan Lawrence","short_name":"DW Lawrence","first_name":"Dan Lawrence","last_name":"","middle_name":"","birthdate":"1997-07-12","birthplace":"Whipps Cross, Essex","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":6.5,"facebook_profile":"https:\/\/www.facebook.com\/danlawrence25\/","twitter_profile":"https:\/\/twitter.com\/_DanLawrence","instagram_profile":"https:\/\/www.instagram.com\/daniellawrence28\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":1047,"title":"Sam Curran","short_name":"S Curran","first_name":"Sam Curran","last_name":"","middle_name":"","birthdate":"1998-06-03","birthplace":"Northampton","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/CurranSM\/","twitter_profile":"https:\/\/twitter.com\/CurranSM","instagram_profile":"https:\/\/www.instagram.com\/samcurran58\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":"(C)"},{"pid":1049,"title":"Ben Green","short_name":"BGF Green","first_name":"Ben Green","last_name":"","middle_name":"","birthdate":"1997-09-28","birthplace":"Exeter, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"all","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":"England","role":"all","role_str":""},{"pid":1089,"title":"Nathan Smith","short_name":"N Smith","first_name":"Nathan Smith","last_name":"","middle_name":"","birthdate":"1998-07-15","birthplace":"Dunedin, Otago","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"squad","role_str":""},{"pid":1923,"title":"Mitchell Santner","short_name":"M Santner","first_name":"Mitchell Santner","last_name":"","middle_name":"","birthdate":"1992-02-05","birthplace":" Hamilton","country":"nz","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":9,"facebook_profile":"https:\/\/www.facebook.com\/mitchellsantnernz\/","twitter_profile":"https:\/\/twitter.com\/MitchellSantner","instagram_profile":"https:\/\/www.instagram.com\/mitchsantner\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"squad","role_str":""},{"pid":1929,"title":"Jason Roy","short_name":"J Roy","first_name":"Jason Roy","last_name":"","middle_name":"","birthdate":"1990-07-21","birthplace":"Durban, South Africa","country":"en","primary_team":{"tid":490,"name":"","short_name":""},"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/JasonRoy20\/","twitter_profile":"https:\/\/twitter.com\/JasonRoy20","instagram_profile":"https:\/\/www.instagram.com\/jasonroy20\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":1937,"title":"Reece Topley","short_name":"R Topley","first_name":"Reece Topley","last_name":"","middle_name":"","birthdate":"1994-02-21","birthplace":"Ipswich, Suffolk","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/ReeceJamesWilliamTopley\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/reecejwtopley\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":1965,"title":"Adam Zampa","short_name":"A Zampa","first_name":"Adam Zampa","last_name":"","middle_name":"","birthdate":"1992-03-31","birthplace":"Shellharbour, New South Wales","country":"au","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":18970,"recent_appearance":1515900000,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/zampsbook\/","twitter_profile":"https:\/\/twitter.com\/AdamZampaAUS","instagram_profile":"https:\/\/www.instagram.com\/zampstagram","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Australia","role":"bowl","role_str":""},{"pid":10598,"title":"Ben Foakes","short_name":"BT Foakes","first_name":"Ben Foakes","last_name":"","middle_name":"","birthdate":"1993-02-15","birthplace":"Colchester, 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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":10600,"title":"Rory Burns","short_name":"RJ Burns","first_name":"Rory Burns","last_name":"","middle_name":"","birthdate":"1990-08-26","birthplace":"Epsom, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"Occasional Wicketkeeper","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":10606,"title":"Jake Ball","short_name":"JT Ball","first_name":"Jake Ball","last_name":"","middle_name":"","birthdate":"1991-03-14","birthplace":"Mansfield, Nottinghamshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":18974,"recent_appearance":1517109600,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/jakeball","instagram_profile":"https:\/\/www.instagram.com\/jakeball\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":43383,"title":"Jamie Overton","short_name":"J Overton","first_name":"Jamie Overton","last_name":"","middle_name":"","birthdate":"1994-04-10","birthplace":"Barnstaple, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/JamieOverton","instagram_profile":"https:\/\/www.instagram.com\/jamie_overton8\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":43389,"title":"Tom Curran","short_name":"TK Curran","first_name":"Tom Curran","last_name":"","middle_name":"","birthdate":"1995-03-12","birthplace":"Cape Town, Cape Province","country":"en","primary_team":[],"logo_url":"","playing_role":"all","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":"https:\/\/twitter.com\/tc59","instagram_profile":"https:\/\/www.instagram.com\/tc59\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":43630,"title":"Daniel Worrall","short_name":"DJ Worrall","first_name":"Daniel Worrall","last_name":"","middle_name":"","birthdate":"1991-07-10","birthplace":"Melbourne, Victoria","country":"au","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":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":48440,"title":"Jordan Clark","short_name":"J Clark","first_name":"Jordan Clark","last_name":"","middle_name":"","birthdate":"1990-10-14","birthplace":"Whitehaven, Cumbria","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"Occasional Wicketkeeper","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":48656,"title":"Tom Kohler-Cadmore","short_name":"TK Cadmore","first_name":"Tom Kohler-Cadmore","last_name":"","middle_name":"","birthdate":"1994-08-19","birthplace":" Chatham, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/tomkholerCadmore32\/","twitter_profile":"https:\/\/twitter.com\/TomKCadmore32","instagram_profile":"https:\/\/www.instagram.com\/tomkcadmore","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(WK)"},{"pid":49015,"title":"Andrew Umeed","short_name":"ARI Umeed","first_name":"Andrew Umeed","last_name":"","middle_name":"","birthdate":"1996-04-19","birthplace":"Glasgow, Lanarkshire","country":"sct","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Scotland","role":"squad","role_str":""},{"pid":49029,"title":"Laurie Evans","short_name":"LJ Evans","first_name":"Laurie Evans","last_name":"","middle_name":"","birthdate":"1987-10-12","birthplace":"Lambeth, London","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/laurie.evans.39\/","twitter_profile":"https:\/\/twitter.com\/LaurieEvans32","instagram_profile":"https:\/\/www.instagram.com\/laurieevans32\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49324,"title":"Matt Dunn","short_name":"MP Dunn","first_name":"Matt Dunn","last_name":"","middle_name":"","birthdate":"1992-05-05","birthplace":"Egham, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49413,"title":"Tom Abell","short_name":"TB Abell","first_name":"Tom Abell","last_name":"","middle_name":"","birthdate":"1994-03-05","birthplace":"Taunton, Somerset","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":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/tomabell1","instagram_profile":"https:\/\/www.instagram.com\/tabell28\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":49421,"title":"Lewis Gregory","short_name":"L Gregory","first_name":"Lewis Gregory","last_name":"","middle_name":"","birthdate":"1992-05-24","birthplace":"Plymouth","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/lewisgregory23\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":"(C)"},{"pid":49425,"title":"Jack Leach","short_name":"J Leach","first_name":"Jack Leach","last_name":"","middle_name":"","birthdate":"1991-06-22","birthplace":" Taunton, Somerset","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":"https:\/\/twitter.com\/jackleach1991?lang=gu","instagram_profile":"https:\/\/www.instagram.com\/mjleach17\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":49428,"title":"Cameron Steel","short_name":"CT Steel","first_name":"Cameron Steel","last_name":"","middle_name":"","birthdate":"1995-09-13","birthplace":"Greenbrae, California, United States of America","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49733,"title":"Craig Overton","short_name":"C Overton","first_name":"Craig Overton","last_name":"","middle_name":"","birthdate":"1994-04-10","birthplace":"Barnstaple, Devon","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":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/craigoverton12","instagram_profile":"https:\/\/www.instagram.com\/craigoverton12\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49743,"title":"Matthew Fisher","short_name":"MD Fisher","first_name":"Matthew Fisher","last_name":"","middle_name":"","birthdate":"1997-11-09","birthplace":"York","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/9M_Fisher","instagram_profile":"https:\/\/www.instagram.com\/9M_Fisher\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49823,"title":"Sean Dickson","short_name":"SR Dickson","first_name":"Sean Dickson","last_name":"","middle_name":"","birthdate":"1991-09-02","birthplace":"Johannesburg, Transvaal","country":"za","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":"South Africa","role":"bat","role_str":""},{"pid":50754,"title":"Dom Sibley","short_name":"DP Sibley","first_name":"Dom Sibley","last_name":"","middle_name":"","birthdate":"1995-09-05","birthplace":"Epsom, Surrey","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51266,"title":"Tom Banton","short_name":"T Banton","first_name":"Tom Banton","last_name":"","middle_name":"","birthdate":"1998-11-11","birthplace":"Chiltern, Buckinghamshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/OfficialTomBanton\/","twitter_profile":"https:\/\/twitter.com\/tbanton18","instagram_profile":"https:\/\/www.instagram.com\/tombanton\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51290,"title":"Ollie Pope","short_name":"O Pope","first_name":"Ollie Pope","last_name":"","middle_name":"","birthdate":"1998-01-02","birthplace":"Chelsea, Middlesex","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,"facebook_profile":"https:\/\/www.facebook.com\/OliverJohndouglaspope.3\/","twitter_profile":"https:\/\/twitter.com\/OPope32","instagram_profile":"https:\/\/www.instagram.com\/opope32\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51319,"title":"Will Jacks","short_name":"WG Jacks","first_name":"Will Jacks","last_name":"","middle_name":"","birthdate":"1998-11-21","birthplace":"Chertsey, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Wjacks9","instagram_profile":"https:\/\/www.instagram.com\/willjacks9\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":57592,"title":"Migael Pretorius","short_name":"M Pretorius","first_name":"Migael Pretorius","last_name":"","middle_name":"","birthdate":"1995-03-24","birthplace":"Vereeninging","country":"za","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":"https:\/\/www.facebook.com\/migael27\/","twitter_profile":"https:\/\/twitter.com\/migael_27","instagram_profile":"https:\/\/www.instagram.com\/migael27\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bowl","role_str":""},{"pid":90946,"title":"Ryan Patel","short_name":"RS Patel","first_name":"Ryan Patel","last_name":"","middle_name":"","birthdate":"1997-10-26","birthplace":"Sutton, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","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":"England","role":"bat","role_str":""},{"pid":93329,"title":"Riley Meredith","short_name":"RP Meredith","first_name":"Riley Meredith","last_name":"","middle_name":"","birthdate":"1996-06-21","birthplace":"Hobart, Tasmania","country":"au","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/rileymeredith_\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"bowl","role_str":""},{"pid":93520,"title":"Tom Lammonby","short_name":"TA Lammonby","first_name":"Tom Lammonby","last_name":"","middle_name":"","birthdate":"2000-06-02","birthplace":" Exeter, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/TomLammonby","instagram_profile":"https:\/\/www.instagram.com\/tom_lammonby\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":93749,"title":"Gus Atkinson","short_name":"G Atkinson","first_name":"Gus Atkinson","last_name":"","middle_name":"","birthdate":"1998-01-19","birthplace":"Chelsea, Middlesex","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":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/gus_atkinson1","instagram_profile":"https:\/\/www.instagram.com\/gusatkinson\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":93751,"title":"James Taylor","short_name":"JWA Taylor","first_name":"James Taylor","last_name":"","middle_name":"","birthdate":"2001-01-19","birthplace":"Nottingham","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":93836,"title":"Jamie Smith","short_name":"JL Smith","first_name":"Jamie Smith","last_name":"","middle_name":"","birthdate":"2000-07-12","birthplace":"Epsom, Surrey","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\/jamie_smith148\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95554,"title":"Lewis Goldsworthy","short_name":"L Goldsworthy","first_name":"Lewis Goldsworthy","last_name":"","middle_name":"","birthdate":"2001-01-08","birthplace":" Cornwall","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lewigoldsworthy","instagram_profile":"https:\/\/www.instagram.com\/lewisgoldsworthy\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":103052,"title":"Will Smeed","short_name":"W Smeed","first_name":"Will Smeed","last_name":"","middle_name":"","birthdate":"2001-10-26","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.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/will_smeed","instagram_profile":"https:\/\/www.instagram.com\/willsmeed\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":108386,"title":"Thomas Lawes","short_name":"T Lawes","first_name":"Thomas Lawes","last_name":"","middle_name":"","birthdate":"2002-12-25","birthplace":"Singapore","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/tom_lawes\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108408,"title":"James Rew","short_name":"J Rew","first_name":"James Rew","last_name":"","middle_name":"","birthdate":"2004-01-11","birthplace":" London","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/cjrew89\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108410,"title":"Joshua Thomas","short_name":"J Thomas","first_name":"Joshua Thomas","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":109924,"title":"Nathan Barnwell","short_name":"NA Barnwell","first_name":"Nathan Barnwell","last_name":"","middle_name":"","birthdate":"2003-02-03","birthplace":"Ashford, Kent","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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":118551,"title":"Josh Blake","short_name":"J Blake","first_name":"Josh Blake","last_name":"","middle_name":"","birthdate":"1998-09-18","birthplace":"Carshalton, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":118552,"title":"Yousef Majid","short_name":"Y Majid","first_name":"Yousef Majid","last_name":"","middle_name":"","birthdate":"2003-09-08","birthplace":"Slough, United Kingdom","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":129894,"title":"JT Langridge","short_name":"JT Langridge","first_name":"JT Langridge","last_name":"","middle_name":"","birthdate":"2005-11-03","birthplace":" Plymouth, Devon,","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":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":130425,"title":"Finley Hill","short_name":"F Hill","first_name":"Finley Hill","last_name":"","middle_name":"","birthdate":"2006-06-21","birthplace":" Exeter, Devon","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":"squad","role_str":""},{"pid":130468,"title":"Tommy Ealham","short_name":"TM Ealham","first_name":"Tommy Ealham","last_name":"","middle_name":"","birthdate":"2004-03-26","birthplace":"Guildford, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":137372,"title":"Archie Vaughan","short_name":"A Vaughan","first_name":"Archie Vaughan","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":140793,"title":"Thomas Rew","short_name":"T Rew","first_name":"Thomas Rew","last_name":"","middle_name":"","birthdate":"2007-11-29","birthplace":"","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":141008,"title":"Ollie Sykes","short_name":"O Sykes","first_name":"Ollie Sykes","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":141527,"title":"Seb Stuart Reckling","short_name":"SS Reckling","first_name":"Seb Stuart Reckling","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""}]},"etag":"25eb9bb02bda34971903063465d7ebc7","modified":"2025-07-15 10:27:32","datetime":"2025-07-15 10:27:32","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":86927,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Surrey won by 67 runs","day_remaining_over":"","team_batting":"Somerset","team_bowling":"Surrey","live_inning_number":2,"live_score":{"runs":134,"overs":19.3,"wickets":10,"target":202,"runrate":6.87,"required_runrate":136},"commentary":1,"wagon":2,"batsmen":[{"name":"Lewis Goldsworthy","batsman_id":95554,"runs":3,"balls_faced":9,"fours":0,"sixes":0,"strike_rate":"33.33"},{"name":"Jack Leach","batsman_id":49425,"runs":8,"balls_faced":8,"fours":1,"sixes":0,"strike_rate":"100.00"}],"bowlers":[{"name":"Chris Jordan","bowler_id":454,"overs":3.3,"runs_conceded":34,"wickets":1,"maidens":0,"econ":"9.71"},{"name":"Sam Curran","bowler_id":1047,"overs":4,"runs_conceded":27,"wickets":2,"maidens":0,"econ":"6.75"}],"commentaries":[{"event_id":"12342455","event":"ball","batsman_id":"57592","bowler_id":"1965","over":"15","ball":"1","score":0,"commentary":"Adam Zampa to Migael Pretorius, no run,","noball_dismissal":false,"text":"","timestamp":1752427092,"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":"12342459","event":"ball","batsman_id":"57592","bowler_id":"1965","over":"15","ball":"2","score":0,"commentary":"Adam Zampa to Migael Pretorius, no run,","noball_dismissal":false,"text":"","timestamp":1752427100,"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":"12342463","event":"ball","batsman_id":"57592","bowler_id":"1965","over":"15","ball":"3","score":0,"commentary":"Adam Zampa to Migael Pretorius, no run,","noball_dismissal":false,"text":"","timestamp":1752427125,"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":"12342466","event":"ball","batsman_id":"57592","bowler_id":"1965","over":"15","ball":"4","score":1,"commentary":"Adam Zampa to Migael Pretorius, 1 run,","noball_dismissal":false,"text":"","timestamp":1752427168,"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":"12342471","event":"wicket","batsman_id":"1049","bowler_id":"1965","over":"15","ball":"5","score":"w","commentary":"Adam Zampa to Ben Green, no run, c J Roy b A Zampa,","noball_dismissal":false,"text":"","timestamp":1752427220,"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,"wicket_batsman_id":"1049","how_out":"c J Roy b A Zampa","batsman_runs":"11","batsman_balls":"12"},{"event_id":"12342478","event":"ball","batsman_id":"95554","bowler_id":"1965","over":"15","ball":"6","score":0,"commentary":"Adam Zampa to Lewis Goldsworthy, no run,","noball_dismissal":false,"text":"","timestamp":1752427299,"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":16,"runs":1,"score":"122\/7","bats":[{"runs":0,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":95554},{"runs":2,"balls_faced":6,"fours":0,"sixes":0,"batsman_id":57592}],"bowls":[{"runs_conceded":28,"maidens":0,"wickets":2,"bowler_id":1965,"overs":4},{"runs_conceded":20,"maidens":0,"wickets":2,"bowler_id":1047,"overs":3}],"commentary":"End of over 16 (1 runs), Somerset 122\/7"},{"event_id":"12342487","event":"wicket","batsman_id":"57592","bowler_id":"1937","over":"16","ball":"1","score":"w","commentary":"Reece Topley to Migael Pretorius, no run, c WG Jacks b R Topley,","noball_dismissal":false,"text":"","timestamp":1752427405,"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,"wicket_batsman_id":"57592","how_out":"c WG Jacks b R Topley","batsman_runs":"2","batsman_balls":"7"},{"event_id":"12342490","event":"ball","batsman_id":"93329","bowler_id":"1937","over":"16","ball":"2","score":0,"commentary":"Reece Topley to Riley Meredith, no run,","noball_dismissal":false,"text":"","timestamp":1752427413,"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":"12342495","event":"ball","batsman_id":"93329","bowler_id":"1937","over":"16","ball":"3","score":1,"commentary":"Reece Topley to Riley Meredith, 1 run,","noball_dismissal":false,"text":"","timestamp":1752427503,"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":"12342499","event":"ball","batsman_id":"95554","bowler_id":"1937","over":"16","ball":"4","score":1,"commentary":"Reece Topley to Lewis Goldsworthy, 1 run,","noball_dismissal":false,"text":"","timestamp":1752427541,"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":"12342506","event":"ball","batsman_id":"93329","bowler_id":"1937","over":"16","ball":"5","score":0,"commentary":"Reece Topley to Riley Meredith, no run,","noball_dismissal":false,"text":"","timestamp":1752427629,"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":"12342511","event":"wicket","batsman_id":"93329","bowler_id":"1937","over":"16","ball":"6","score":"w","commentary":"Reece Topley to Riley Meredith, no run, c WG Jacks b R Topley,","noball_dismissal":false,"text":"","timestamp":1752427701,"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,"wicket_batsman_id":"93329","how_out":"c WG Jacks b R Topley","batsman_runs":"1","batsman_balls":"4"},{"event":"overend","over":17,"runs":2,"score":"124\/9","bats":[{"runs":1,"balls_faced":4,"fours":0,"sixes":0,"batsman_id":93329},{"runs":1,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":95554}],"bowls":[{"runs_conceded":20,"maidens":0,"wickets":3,"bowler_id":1937,"overs":4},{"runs_conceded":28,"maidens":0,"wickets":2,"bowler_id":1965,"overs":4}],"commentary":"End of over 17 (2 runs), Somerset 124\/9"},{"event_id":"12342513","event":"ball","batsman_id":"95554","bowler_id":"454","over":"17","ball":"1","score":1,"commentary":"Chris Jordan to Lewis Goldsworthy, 1 run,","noball_dismissal":false,"text":"","timestamp":1752427737,"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":"12342517","event":"ball","batsman_id":"49425","bowler_id":"454","over":"17","ball":"2","score":0,"commentary":"Chris Jordan to Jack Leach, no run,","noball_dismissal":false,"text":"","timestamp":1752427755,"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":"12342519","event":"ball","batsman_id":"49425","bowler_id":"454","over":"17","ball":"3","score":0,"commentary":"Chris Jordan to Jack Leach, no run,","noball_dismissal":false,"text":"","timestamp":1752427787,"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":"12342520","event":"ball","batsman_id":"49425","bowler_id":"454","over":"17","ball":"4","score":1,"commentary":"Chris Jordan to Jack Leach, 1 run,","noball_dismissal":false,"text":"","timestamp":1752427796,"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":"12342526","event":"ball","batsman_id":"95554","bowler_id":"454","over":"17","ball":"5","score":0,"commentary":"Chris Jordan to Lewis Goldsworthy, no run,","noball_dismissal":false,"text":"","timestamp":1752427851,"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":"12342527","event":"ball","batsman_id":"95554","bowler_id":"454","over":"17","ball":"6","score":0,"commentary":"Chris Jordan to Lewis Goldsworthy, no run,","noball_dismissal":false,"text":"","timestamp":1752427859,"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":18,"runs":2,"score":"126\/9","bats":[{"runs":2,"balls_faced":5,"fours":0,"sixes":0,"batsman_id":95554},{"runs":1,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":49425}],"bowls":[{"runs_conceded":33,"maidens":0,"wickets":0,"bowler_id":454,"overs":3},{"runs_conceded":20,"maidens":0,"wickets":3,"bowler_id":1937,"overs":4}],"commentary":"End of over 18 (2 runs), Somerset 126\/9"},{"event_id":"12342533","event":"ball","batsman_id":"49425","bowler_id":"1047","over":"18","ball":"1","score":4,"commentary":"Sam Curran to Jack Leach, Four,","noball_dismissal":false,"text":"","timestamp":1752427895,"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":"12342536","event":"ball","batsman_id":"49425","bowler_id":"1047","over":"18","ball":"2","score":1,"commentary":"Sam Curran to Jack Leach, 1 run,","noball_dismissal":false,"text":"","timestamp":1752427935,"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":"12342540","event":"ball","batsman_id":"95554","bowler_id":"1047","over":"18","ball":"3","score":1,"commentary":"Sam Curran to Lewis Goldsworthy, 1 run,","noball_dismissal":false,"text":"","timestamp":1752427974,"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":"12342541","event":"ball","batsman_id":"49425","bowler_id":"1047","over":"18","ball":"4","score":0,"commentary":"Sam Curran to Jack Leach, no run,","noball_dismissal":false,"text":"","timestamp":1752428008,"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":"12342545","event":"ball","batsman_id":"49425","bowler_id":"1047","over":"18","ball":"5","score":1,"commentary":"Sam Curran to Jack Leach, 1 run,","noball_dismissal":false,"text":"","timestamp":1752428069,"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":"12342548","event":"ball","batsman_id":"95554","bowler_id":"1047","over":"18","ball":"6","score":0,"commentary":"Sam Curran to Lewis Goldsworthy, no run,","noball_dismissal":false,"text":"","timestamp":1752428109,"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":19,"runs":7,"score":"133\/9","bats":[{"runs":3,"balls_faced":7,"fours":0,"sixes":0,"batsman_id":95554},{"runs":7,"balls_faced":7,"fours":1,"sixes":0,"batsman_id":49425}],"bowls":[{"runs_conceded":27,"maidens":0,"wickets":2,"bowler_id":1047,"overs":4},{"runs_conceded":33,"maidens":0,"wickets":0,"bowler_id":454,"overs":3}],"commentary":"End of over 19 (7 runs), Somerset 133\/9"},{"event_id":"12342554","event":"ball","batsman_id":"49425","bowler_id":"454","over":"19","ball":"1","score":1,"commentary":"Chris Jordan to Jack Leach, 1 run,","noball_dismissal":false,"text":"","timestamp":1752428170,"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":"12342557","event":"ball","batsman_id":"95554","bowler_id":"454","over":"19","ball":"2","score":0,"commentary":"Chris Jordan to Lewis Goldsworthy, no run,","noball_dismissal":false,"text":"","timestamp":1752428213,"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":"12342562","event":"wicket","batsman_id":"95554","bowler_id":"454","over":"19","ball":"3","score":"w","commentary":"Chris Jordan to Lewis Goldsworthy, no run, c J Overton b C Jordan,","noball_dismissal":false,"text":"","timestamp":1752428351,"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,"wicket_batsman_id":"95554","how_out":"c J Overton b C Jordan","batsman_runs":"3","batsman_balls":"9"}],"day":"0","session":"0","live_inning":{"iid":199616,"number":2,"name":"Somerset Inning","short_name":"SOM Inning","status":2,"issuperover":"false","result":1,"batting_team_id":7010,"fielding_team_id":6995,"scores":"134\/10","scores_full":"134\/10 (19.3 ov)","fielder":[{"fielder_id":"1937","fielder_name":"Reece Topley","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"10598","fielder_name":"Ben Foakes","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"1042","fielder_name":"Dan Lawrence","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"43383","fielder_name":"Jamie Overton","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"1929","fielder_name":"Jason Roy","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"51319","fielder_name":"Will Jacks","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"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":"Lewis Goldsworthy","batsman_id":"95554","runs":"3","balls":"9","how_out":"c J Overton b C Jordan","score_at_dismissal":134,"overs_at_dismissal":"19.3","bowler_id":"454","dismissal":"caught","number":10},"extra_runs":{"byes":0,"legbyes":2,"wides":5,"noballs":0,"penalty":"0","total":7},"equations":{"runs":134,"wickets":10,"overs":"19.3","bowlers_used":5,"runrate":"6.87"},"current_partnership":{"runs":10,"balls":15,"overs":2.3,"batsmen":[{"name":"Lewis Goldsworthy","batsman_id":95554,"runs":2,"balls":7},{"name":"Jack Leach","batsman_id":49425,"runs":8,"balls":8}]},"did_not_bat":[],"max_over":"20","target":"202","recent_scores":"w,0,1,0,1,0,1,1,4,0,0,1,0,0,1,w,0,1","last_five_overs":"15\/4 2.90","last_ten_overs":"58\/6 5.61"},"teams":[{"tid":6995,"title":"Surrey","abbr":"SUR","alt_name":"Surrey","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/surrey-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/surrey-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"201\/6 (20 ov)","scores":"201\/6","overs":"20"},{"tid":7010,"title":"Somerset","abbr":"SOM","alt_name":"SOM","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/somerset-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/somerset-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"134\/10 (19.3 ov)","scores":"134\/10","overs":"19.3"}],"players":[{"pid":301,"title":"Josh Davey","short_name":"J Davey","first_name":"Josh Davey","last_name":"","middle_name":"","birthdate":"1990-08-03","birthplace":"Aberdeen, United Kingdom","country":"sct","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Scotland","role":"squad","role_str":""},{"pid":454,"title":"Chris Jordan","short_name":"C Jordan","first_name":"Chris Jordan","last_name":"","middle_name":"","birthdate":"1988-10-04","birthplace":"Barbados","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":8.5,"facebook_profile":"https:\/\/www.facebook.com\/ChrisJordanOfficial\/","twitter_profile":"https:\/\/twitter.com\/CJordan","instagram_profile":"https:\/\/www.instagram.com\/cjrjordan\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":486,"title":"Matt Henry","short_name":"M Henry","first_name":"Matt Henry","last_name":"","middle_name":"","birthdate":"1991-12-14","birthplace":"Christchurch, Canterbury","country":"nz","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"squad","role_str":""},{"pid":1042,"title":"Dan Lawrence","short_name":"DW Lawrence","first_name":"Dan Lawrence","last_name":"","middle_name":"","birthdate":"1997-07-12","birthplace":"Whipps Cross, Essex","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":6.5,"facebook_profile":"https:\/\/www.facebook.com\/danlawrence25\/","twitter_profile":"https:\/\/twitter.com\/_DanLawrence","instagram_profile":"https:\/\/www.instagram.com\/daniellawrence28\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":1047,"title":"Sam Curran","short_name":"S Curran","first_name":"Sam Curran","last_name":"","middle_name":"","birthdate":"1998-06-03","birthplace":"Northampton","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/CurranSM\/","twitter_profile":"https:\/\/twitter.com\/CurranSM","instagram_profile":"https:\/\/www.instagram.com\/samcurran58\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":"(C)"},{"pid":1049,"title":"Ben Green","short_name":"BGF Green","first_name":"Ben Green","last_name":"","middle_name":"","birthdate":"1997-09-28","birthplace":"Exeter, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"all","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":"England","role":"all","role_str":""},{"pid":1089,"title":"Nathan Smith","short_name":"N Smith","first_name":"Nathan Smith","last_name":"","middle_name":"","birthdate":"1998-07-15","birthplace":"Dunedin, Otago","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"squad","role_str":""},{"pid":1923,"title":"Mitchell Santner","short_name":"M Santner","first_name":"Mitchell Santner","last_name":"","middle_name":"","birthdate":"1992-02-05","birthplace":" Hamilton","country":"nz","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":9,"facebook_profile":"https:\/\/www.facebook.com\/mitchellsantnernz\/","twitter_profile":"https:\/\/twitter.com\/MitchellSantner","instagram_profile":"https:\/\/www.instagram.com\/mitchsantner\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"squad","role_str":""},{"pid":1929,"title":"Jason Roy","short_name":"J Roy","first_name":"Jason Roy","last_name":"","middle_name":"","birthdate":"1990-07-21","birthplace":"Durban, South Africa","country":"en","primary_team":{"tid":490,"name":"","short_name":""},"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/JasonRoy20\/","twitter_profile":"https:\/\/twitter.com\/JasonRoy20","instagram_profile":"https:\/\/www.instagram.com\/jasonroy20\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":1937,"title":"Reece Topley","short_name":"R Topley","first_name":"Reece Topley","last_name":"","middle_name":"","birthdate":"1994-02-21","birthplace":"Ipswich, Suffolk","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/ReeceJamesWilliamTopley\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/reecejwtopley\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":1965,"title":"Adam Zampa","short_name":"A Zampa","first_name":"Adam Zampa","last_name":"","middle_name":"","birthdate":"1992-03-31","birthplace":"Shellharbour, New South Wales","country":"au","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":18970,"recent_appearance":1515900000,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/zampsbook\/","twitter_profile":"https:\/\/twitter.com\/AdamZampaAUS","instagram_profile":"https:\/\/www.instagram.com\/zampstagram","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Australia","role":"bowl","role_str":""},{"pid":10598,"title":"Ben Foakes","short_name":"BT Foakes","first_name":"Ben Foakes","last_name":"","middle_name":"","birthdate":"1993-02-15","birthplace":"Colchester, 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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":10600,"title":"Rory Burns","short_name":"RJ Burns","first_name":"Rory Burns","last_name":"","middle_name":"","birthdate":"1990-08-26","birthplace":"Epsom, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"Occasional Wicketkeeper","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":10606,"title":"Jake Ball","short_name":"JT Ball","first_name":"Jake Ball","last_name":"","middle_name":"","birthdate":"1991-03-14","birthplace":"Mansfield, Nottinghamshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":18974,"recent_appearance":1517109600,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/jakeball","instagram_profile":"https:\/\/www.instagram.com\/jakeball\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":43383,"title":"Jamie Overton","short_name":"J Overton","first_name":"Jamie Overton","last_name":"","middle_name":"","birthdate":"1994-04-10","birthplace":"Barnstaple, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/JamieOverton","instagram_profile":"https:\/\/www.instagram.com\/jamie_overton8\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":43389,"title":"Tom Curran","short_name":"TK Curran","first_name":"Tom Curran","last_name":"","middle_name":"","birthdate":"1995-03-12","birthplace":"Cape Town, Cape Province","country":"en","primary_team":[],"logo_url":"","playing_role":"all","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":"https:\/\/twitter.com\/tc59","instagram_profile":"https:\/\/www.instagram.com\/tc59\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":43630,"title":"Daniel Worrall","short_name":"DJ Worrall","first_name":"Daniel Worrall","last_name":"","middle_name":"","birthdate":"1991-07-10","birthplace":"Melbourne, Victoria","country":"au","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":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":48440,"title":"Jordan Clark","short_name":"J Clark","first_name":"Jordan Clark","last_name":"","middle_name":"","birthdate":"1990-10-14","birthplace":"Whitehaven, Cumbria","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"Occasional Wicketkeeper","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":48656,"title":"Tom Kohler-Cadmore","short_name":"TK Cadmore","first_name":"Tom Kohler-Cadmore","last_name":"","middle_name":"","birthdate":"1994-08-19","birthplace":" Chatham, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/tomkholerCadmore32\/","twitter_profile":"https:\/\/twitter.com\/TomKCadmore32","instagram_profile":"https:\/\/www.instagram.com\/tomkcadmore","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(WK)"},{"pid":49015,"title":"Andrew Umeed","short_name":"ARI Umeed","first_name":"Andrew Umeed","last_name":"","middle_name":"","birthdate":"1996-04-19","birthplace":"Glasgow, Lanarkshire","country":"sct","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Scotland","role":"squad","role_str":""},{"pid":49029,"title":"Laurie Evans","short_name":"LJ Evans","first_name":"Laurie Evans","last_name":"","middle_name":"","birthdate":"1987-10-12","birthplace":"Lambeth, London","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/laurie.evans.39\/","twitter_profile":"https:\/\/twitter.com\/LaurieEvans32","instagram_profile":"https:\/\/www.instagram.com\/laurieevans32\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49324,"title":"Matt Dunn","short_name":"MP Dunn","first_name":"Matt Dunn","last_name":"","middle_name":"","birthdate":"1992-05-05","birthplace":"Egham, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49413,"title":"Tom Abell","short_name":"TB Abell","first_name":"Tom Abell","last_name":"","middle_name":"","birthdate":"1994-03-05","birthplace":"Taunton, Somerset","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":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/tomabell1","instagram_profile":"https:\/\/www.instagram.com\/tabell28\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":49421,"title":"Lewis Gregory","short_name":"L Gregory","first_name":"Lewis Gregory","last_name":"","middle_name":"","birthdate":"1992-05-24","birthplace":"Plymouth","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/lewisgregory23\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":"(C)"},{"pid":49425,"title":"Jack Leach","short_name":"J Leach","first_name":"Jack Leach","last_name":"","middle_name":"","birthdate":"1991-06-22","birthplace":" Taunton, Somerset","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":"https:\/\/twitter.com\/jackleach1991?lang=gu","instagram_profile":"https:\/\/www.instagram.com\/mjleach17\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":49428,"title":"Cameron Steel","short_name":"CT Steel","first_name":"Cameron Steel","last_name":"","middle_name":"","birthdate":"1995-09-13","birthplace":"Greenbrae, California, United States of America","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49733,"title":"Craig Overton","short_name":"C Overton","first_name":"Craig Overton","last_name":"","middle_name":"","birthdate":"1994-04-10","birthplace":"Barnstaple, Devon","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":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/craigoverton12","instagram_profile":"https:\/\/www.instagram.com\/craigoverton12\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49743,"title":"Matthew Fisher","short_name":"MD Fisher","first_name":"Matthew Fisher","last_name":"","middle_name":"","birthdate":"1997-11-09","birthplace":"York","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/9M_Fisher","instagram_profile":"https:\/\/www.instagram.com\/9M_Fisher\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49823,"title":"Sean Dickson","short_name":"SR Dickson","first_name":"Sean Dickson","last_name":"","middle_name":"","birthdate":"1991-09-02","birthplace":"Johannesburg, Transvaal","country":"za","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":"South Africa","role":"bat","role_str":""},{"pid":50754,"title":"Dom Sibley","short_name":"DP Sibley","first_name":"Dom Sibley","last_name":"","middle_name":"","birthdate":"1995-09-05","birthplace":"Epsom, Surrey","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51266,"title":"Tom Banton","short_name":"T Banton","first_name":"Tom Banton","last_name":"","middle_name":"","birthdate":"1998-11-11","birthplace":"Chiltern, Buckinghamshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/OfficialTomBanton\/","twitter_profile":"https:\/\/twitter.com\/tbanton18","instagram_profile":"https:\/\/www.instagram.com\/tombanton\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51290,"title":"Ollie Pope","short_name":"O Pope","first_name":"Ollie Pope","last_name":"","middle_name":"","birthdate":"1998-01-02","birthplace":"Chelsea, Middlesex","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,"facebook_profile":"https:\/\/www.facebook.com\/OliverJohndouglaspope.3\/","twitter_profile":"https:\/\/twitter.com\/OPope32","instagram_profile":"https:\/\/www.instagram.com\/opope32\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51319,"title":"Will Jacks","short_name":"WG Jacks","first_name":"Will Jacks","last_name":"","middle_name":"","birthdate":"1998-11-21","birthplace":"Chertsey, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Wjacks9","instagram_profile":"https:\/\/www.instagram.com\/willjacks9\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":57592,"title":"Migael Pretorius","short_name":"M Pretorius","first_name":"Migael Pretorius","last_name":"","middle_name":"","birthdate":"1995-03-24","birthplace":"Vereeninging","country":"za","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":"https:\/\/www.facebook.com\/migael27\/","twitter_profile":"https:\/\/twitter.com\/migael_27","instagram_profile":"https:\/\/www.instagram.com\/migael27\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bowl","role_str":""},{"pid":90946,"title":"Ryan Patel","short_name":"RS Patel","first_name":"Ryan Patel","last_name":"","middle_name":"","birthdate":"1997-10-26","birthplace":"Sutton, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","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":"England","role":"bat","role_str":""},{"pid":93329,"title":"Riley Meredith","short_name":"RP Meredith","first_name":"Riley Meredith","last_name":"","middle_name":"","birthdate":"1996-06-21","birthplace":"Hobart, Tasmania","country":"au","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/rileymeredith_\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"bowl","role_str":""},{"pid":93520,"title":"Tom Lammonby","short_name":"TA Lammonby","first_name":"Tom Lammonby","last_name":"","middle_name":"","birthdate":"2000-06-02","birthplace":" Exeter, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/TomLammonby","instagram_profile":"https:\/\/www.instagram.com\/tom_lammonby\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":93749,"title":"Gus Atkinson","short_name":"G Atkinson","first_name":"Gus Atkinson","last_name":"","middle_name":"","birthdate":"1998-01-19","birthplace":"Chelsea, Middlesex","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":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/gus_atkinson1","instagram_profile":"https:\/\/www.instagram.com\/gusatkinson\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":93751,"title":"James Taylor","short_name":"JWA Taylor","first_name":"James Taylor","last_name":"","middle_name":"","birthdate":"2001-01-19","birthplace":"Nottingham","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":93836,"title":"Jamie Smith","short_name":"JL Smith","first_name":"Jamie Smith","last_name":"","middle_name":"","birthdate":"2000-07-12","birthplace":"Epsom, Surrey","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\/jamie_smith148\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95554,"title":"Lewis Goldsworthy","short_name":"L Goldsworthy","first_name":"Lewis Goldsworthy","last_name":"","middle_name":"","birthdate":"2001-01-08","birthplace":" Cornwall","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lewigoldsworthy","instagram_profile":"https:\/\/www.instagram.com\/lewisgoldsworthy\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":103052,"title":"Will Smeed","short_name":"W Smeed","first_name":"Will Smeed","last_name":"","middle_name":"","birthdate":"2001-10-26","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.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/will_smeed","instagram_profile":"https:\/\/www.instagram.com\/willsmeed\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":108386,"title":"Thomas Lawes","short_name":"T Lawes","first_name":"Thomas Lawes","last_name":"","middle_name":"","birthdate":"2002-12-25","birthplace":"Singapore","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/tom_lawes\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108408,"title":"James Rew","short_name":"J Rew","first_name":"James Rew","last_name":"","middle_name":"","birthdate":"2004-01-11","birthplace":" London","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/cjrew89\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108410,"title":"Joshua Thomas","short_name":"J Thomas","first_name":"Joshua Thomas","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":109924,"title":"Nathan Barnwell","short_name":"NA Barnwell","first_name":"Nathan Barnwell","last_name":"","middle_name":"","birthdate":"2003-02-03","birthplace":"Ashford, Kent","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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":118551,"title":"Josh Blake","short_name":"J Blake","first_name":"Josh Blake","last_name":"","middle_name":"","birthdate":"1998-09-18","birthplace":"Carshalton, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":118552,"title":"Yousef Majid","short_name":"Y Majid","first_name":"Yousef Majid","last_name":"","middle_name":"","birthdate":"2003-09-08","birthplace":"Slough, United Kingdom","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":129894,"title":"JT Langridge","short_name":"JT Langridge","first_name":"JT Langridge","last_name":"","middle_name":"","birthdate":"2005-11-03","birthplace":" Plymouth, Devon,","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":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":130425,"title":"Finley Hill","short_name":"F Hill","first_name":"Finley Hill","last_name":"","middle_name":"","birthdate":"2006-06-21","birthplace":" Exeter, Devon","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":"squad","role_str":""},{"pid":130468,"title":"Tommy Ealham","short_name":"TM Ealham","first_name":"Tommy Ealham","last_name":"","middle_name":"","birthdate":"2004-03-26","birthplace":"Guildford, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":137372,"title":"Archie Vaughan","short_name":"A Vaughan","first_name":"Archie Vaughan","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":140793,"title":"Thomas Rew","short_name":"T Rew","first_name":"Thomas Rew","last_name":"","middle_name":"","birthdate":"2007-11-29","birthplace":"","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":141008,"title":"Ollie Sykes","short_name":"O Sykes","first_name":"Ollie Sykes","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":141527,"title":"Seb Stuart Reckling","short_name":"SS Reckling","first_name":"Seb Stuart Reckling","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""}]},"etag":"25eb9bb02bda34971903063465d7ebc7","modified":"2025-07-15 10:27:32","datetime":"2025-07-15 10:27:32","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86927 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:fd789208-6e88-49ee-bfc0-4a0f35a858c6 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86927 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86927,3,'{"status":"ok","response":{"match_id":86927,"title":"Surrey vs Somerset","short_title":"SUR vs SOM","subtitle":"Match 107","match_number":"107","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Surrey won by 67 runs","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129425,"title":"Vitality Blast","abbr":"Vitality Blast","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-09-13","country":"en","total_matches":"133","total_rounds":"2","total_teams":"18"},"teama":{"team_id":6995,"name":"Surrey","short_name":"SUR","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/surrey-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/surrey-logo.png","scores_full":"201\/6 (20 ov)","scores":"201\/6","overs":"20"},"teamb":{"team_id":7010,"name":"Somerset","short_name":"SOM","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/somerset-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/somerset-logo.png","scores_full":"134\/10 (19.3 ov)","scores":"134\/10","overs":"19.3"},"date_start":"2025-07-13 14:30:00","date_end":"2025-07-14 00:30:00","timestamp_start":1752417000,"timestamp_end":1752453000,"date_start_ist":"2025-07-13 20:00:00","date_end_ist":"2025-07-14 06:00:00","venue":{"venue_id":"3","name":"Kennington Oval","location":"London","country":"England","timezone":""},"umpires":"Hassan Adnan (England), Mark Newell (England)","referee":"Jason Swift (England)","equation":"","live":"","result":"SUR won by 67 runs","result_type":1,"win_margin":"67 runs","winning_team_id":6995,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-07-12 22:06:07","verify_time":"2025-07-13 23:20:58","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"few clouds","temp":26.82,"humidity":40,"visibility":10000,"wind_speed":"7.20","clouds":12},"pitch":{"pitch_condition":"Spinning Pitch","batting_condition":"Average","pace_bowling_condition":"Swing Favourable","spine_bowling_condition":"Slow Spin"},"toss":{"text":"Somerset elected to bowl","winner":7010,"decision":2}},"etag":"7dceab39e4efe3fd4341436b5f850d6a","modified":"2025-07-15 10:27:33","datetime":"2025-07-15 10:27:33","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":86927,"title":"Surrey vs Somerset","short_title":"SUR vs SOM","subtitle":"Match 107","match_number":"107","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Surrey won by 67 runs","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129425,"title":"Vitality Blast","abbr":"Vitality Blast","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-09-13","country":"en","total_matches":"133","total_rounds":"2","total_teams":"18"},"teama":{"team_id":6995,"name":"Surrey","short_name":"SUR","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/surrey-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/surrey-logo.png","scores_full":"201\/6 (20 ov)","scores":"201\/6","overs":"20"},"teamb":{"team_id":7010,"name":"Somerset","short_name":"SOM","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/somerset-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/somerset-logo.png","scores_full":"134\/10 (19.3 ov)","scores":"134\/10","overs":"19.3"},"date_start":"2025-07-13 14:30:00","date_end":"2025-07-14 00:30:00","timestamp_start":1752417000,"timestamp_end":1752453000,"date_start_ist":"2025-07-13 20:00:00","date_end_ist":"2025-07-14 06:00:00","venue":{"venue_id":"3","name":"Kennington Oval","location":"London","country":"England","timezone":""},"umpires":"Hassan Adnan (England), Mark Newell (England)","referee":"Jason Swift (England)","equation":"","live":"","result":"SUR won by 67 runs","result_type":1,"win_margin":"67 runs","winning_team_id":6995,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-07-12 22:06:07","verify_time":"2025-07-13 23:20:58","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"few clouds","temp":26.82,"humidity":40,"visibility":10000,"wind_speed":"7.20","clouds":12},"pitch":{"pitch_condition":"Spinning Pitch","batting_condition":"Average","pace_bowling_condition":"Swing Favourable","spine_bowling_condition":"Slow Spin"},"toss":{"text":"Somerset elected to bowl","winner":7010,"decision":2}},"etag":"7dceab39e4efe3fd4341436b5f850d6a","modified":"2025-07-15 10:27:33","datetime":"2025-07-15 10:27:33","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86927 AND DataTypeId = 3 END
Live Report & Scorecard of Surrey vs Somerset Match 107

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) & *162/3 (33.2 ov)

Day 4 - India Under-19s lead by 263 runs.

LIVEToday1st Unofficial Test

Australia A486/10 (161.4 ov)

Sri Lanka A272/10 (82 ov) & *49/1 (13 ov)

Stumps : Day 3 - Sri Lanka A trail by 165 runs.

LIVETodayMatch 16

Gauhati Town Club*63/0 (9 ov)

Bud CC129/9 (20 ov)

Gauhati Town Club need 67 runs in 11.0 remaining overs

LIVETodayMatch 16

Karaikal Kniights*14/0 (1.1 ov)

Ruby White Town legends178/3 (20 ov)

Karaikal Kniights need 165 runs in 18.5 remaining overs

LIVETodayMatch 7

SC Krefeld Spartans196/2 (10 ov)

Koln CC*57/5 (6.1 ov)

Koln CC need 140 runs in 23 remaining balls

LIVETodayMatch 8

Grey Caps Aachen

Koln CC

Grey Caps Aachen elected to bowl

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

Scheduled16 July Match 18

Villianur Mohit Kings

Mahe Megalo Strikers

Scheduled16 July Match 12

SC Krefeld Boosters

Strass Rising Stars

Live Cricket Match Centre

Surrey vs Somerset, Match 107, Vitality Blast

Completed

Vitality Blast, Completed

Surrey

SUR

201/6 (20 ov)

Somerset

SOM

134/10 (19.3 ov)

Surrey won by 67 runs

BATTERS	R	B	4S	6S	SR
Lewis Goldsworthy *	3	9	0	0	33.33
Jack Leach	8	8	1	0	100.00

BOWLERS	O	M	R	W	ECON
Chris Jordan *	3.3	0	34	1	9.71
Sam Curran	4	0	27	2	6.75

Current Partnership: 10 run (2.3 ov) | Last Wicket: Lewis Goldsworthy 3 (9) | Fall of Wicket: 134/10 (19.3 ov)

CRR: 6.87

Recent: w•1•1•114••1••1w•1

Surrey vs Somerset, Live Cricket Commentary

19.3

Lewis Goldsworthy c J Overton b C Jordan 3 (9) Chris Jordan to Lewis Goldsworthy, no run, c J Overton b C Jordan,

19.2

Chris Jordan to Lewis Goldsworthy, no run,

19.1

Chris Jordan to Jack Leach, 1 run,

End of over 19 (7 runs)

Lewis Goldsworthy 3 (7)

Jack Leach 7 (7)

Somerset 133/9

Sam Curran 4-0-27-2

Chris Jordan 3-0-33-0

18.6

Sam Curran to Lewis Goldsworthy, no run,

18.5

Sam Curran to Jack Leach, 1 run,

18.4

Sam Curran to Jack Leach, no run,

18.3

Sam Curran to Lewis Goldsworthy, 1 run,

18.2

Sam Curran to Jack Leach, 1 run,

18.1

Sam Curran to Jack Leach, Four,

End of over 18 (2 runs)

Lewis Goldsworthy 2 (5)

Jack Leach 1 (3)

Somerset 126/9

Chris Jordan 3-0-33-0

Reece Topley 4-0-20-3

17.6

Chris Jordan to Lewis Goldsworthy, no run,

17.5

Chris Jordan to Lewis Goldsworthy, no run,

17.4

Chris Jordan to Jack Leach, 1 run,

17.3

Chris Jordan to Jack Leach, no run,

17.2

Chris Jordan to Jack Leach, no run,

17.1

Chris Jordan to Lewis Goldsworthy, 1 run,

End of over 17 (2 runs)

Riley Meredith 1 (4)

Lewis Goldsworthy 1 (2)

Somerset 124/9

Reece Topley 4-0-20-3

Adam Zampa 4-0-28-2

16.6

Riley Meredith c WG Jacks b R Topley 1 (4) Reece Topley to Riley Meredith, no run, c WG Jacks b R Topley,

16.5

Reece Topley to Riley Meredith, no run,

16.4

Reece Topley to Lewis Goldsworthy, 1 run,

16.3

Reece Topley to Riley Meredith, 1 run,

16.2

Reece Topley to Riley Meredith, no run,

16.1

Migael Pretorius c WG Jacks b R Topley 2 (7) Reece Topley to Migael Pretorius, no run, c WG Jacks b R Topley,

End of over 16 (1 runs)

Lewis Goldsworthy 0 (1)

Migael Pretorius 2 (6)

Somerset 122/7

Adam Zampa 4-0-28-2

Sam Curran 3-0-20-2

15.6

Adam Zampa to Lewis Goldsworthy, no run,

15.5

Ben Green c J Roy b A Zampa 11 (12) Adam Zampa to Ben Green, no run, c J Roy b A Zampa,

15.4

Adam Zampa to Migael Pretorius, 1 run,

15.3

Adam Zampa to Migael Pretorius, no run,

15.2

Adam Zampa to Migael Pretorius, no run,

15.1

Adam Zampa to Migael Pretorius, no run,

Date

Sunday, July 13, 2025 15:30

Venue

Kennington Oval, London

Toss

Somerset elected to bowl

Umpires

Match Referee

Jason Swift (England)

× Close