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:01d4a932-5f05-4b97-b3b7-206d25f3d022
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86883 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86883,1,'{"status":"ok","response":{"mid":86883,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Somerset won by 17 runs","day_remaining_over":"","team_batting":"Hampshire","team_bowling":"Somerset","live_inning_number":2,"live_score":{"runs":192,"overs":20,"wickets":7,"target":210,"runrate":9.6,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Benny Howell","batsman_id":49524,"runs":11,"balls_faced":10,"fours":0,"sixes":0,"strike_rate":"110.00"},{"name":"Liam Dawson","batsman_id":1945,"runs":12,"balls_faced":7,"fours":1,"sixes":1,"strike_rate":"171.43"}],"bowlers":[{"name":"Lewis Gregory","bowler_id":49421,"overs":3,"runs_conceded":29,"wickets":1,"maidens":0,"econ":"9.67"},{"name":"Riley Meredith","bowler_id":93329,"overs":4,"runs_conceded":34,"wickets":1,"maidens":0,"econ":"8.50"}],"commentaries":[{"event_id":"12175278","event":"ball","batsman_id":"32166","bowler_id":"301","over":"15","ball":"5","score":4,"commentary":"Josh Davey to James Fuller, Four,","noball_dismissal":false,"text":"","timestamp":1750363926,"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":"12175288","event":"ball","batsman_id":"32166","bowler_id":"301","over":"15","ball":"6","score":1,"commentary":"Josh Davey to James Fuller, 1 run,","noball_dismissal":false,"text":"","timestamp":1750364119,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":16,"runs":19,"score":"154\/4","bats":[{"runs":11,"balls_faced":4,"fours":1,"sixes":1,"batsman_id":32166},{"runs":23,"balls_faced":11,"fours":1,"sixes":2,"batsman_id":110871}],"bowls":[{"runs_conceded":40,"maidens":0,"wickets":0,"bowler_id":301,"overs":3},{"runs_conceded":24,"maidens":0,"wickets":0,"bowler_id":93329,"overs":2}],"commentary":"End of over 16 (19 runs), Hampshire 154\/4"},{"event_id":"12175296","event":"ball","batsman_id":"32166","bowler_id":"93329","over":"16","ball":"1","score":0,"commentary":"Riley Meredith to James Fuller, no run,","noball_dismissal":false,"text":"","timestamp":1750364182,"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":"12175299","event":"wicket","batsman_id":"32166","bowler_id":"93329","over":"16","ball":"2","score":"w","commentary":"Riley Meredith to James Fuller, no run, b RP Meredith,","noball_dismissal":false,"text":"","timestamp":1750364186,"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":"32166","how_out":"b RP Meredith","batsman_runs":"11","batsman_balls":"6"},{"event_id":"12175303","event":"ball","batsman_id":"49524","bowler_id":"93329","over":"16","ball":"3","score":"1lb","commentary":"Riley Meredith to Benny Howell, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1750364212,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"1","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12175304","event":"ball","batsman_id":"110871","bowler_id":"93329","over":"16","ball":"4","score":1,"commentary":"Riley Meredith to Dewald Brevis, 1 run,","noball_dismissal":false,"text":"","timestamp":1750364216,"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":"12175312","event":"ball","batsman_id":"49524","bowler_id":"93329","over":"16","ball":"5","score":1,"commentary":"Riley Meredith to Benny Howell, 1 run,","noball_dismissal":false,"text":"","timestamp":1750364328,"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":"12175313","event":"ball","batsman_id":"110871","bowler_id":"93329","over":"16","ball":"6","score":0,"commentary":"Riley Meredith to Dewald Brevis, no run,","noball_dismissal":false,"text":"","timestamp":1750364332,"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":17,"runs":3,"score":"157\/5","bats":[{"runs":24,"balls_faced":13,"fours":1,"sixes":2,"batsman_id":110871},{"runs":1,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":49524}],"bowls":[{"runs_conceded":26,"maidens":0,"wickets":1,"bowler_id":93329,"overs":3},{"runs_conceded":40,"maidens":0,"wickets":0,"bowler_id":301,"overs":3}],"commentary":"End of over 17 (3 runs), Hampshire 157\/5"},{"event_id":"12175315","event":"ball","batsman_id":"49524","bowler_id":"1049","over":"17","ball":"1","score":1,"commentary":"Ben Green to Benny Howell, 1 run,","noball_dismissal":false,"text":"","timestamp":1750364361,"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":"12175316","event":"ball","batsman_id":"110871","bowler_id":"1049","over":"17","ball":"2","score":6,"commentary":"Ben Green to Dewald Brevis, Six,","noball_dismissal":false,"text":"","timestamp":1750364364,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12175320","event":"ball","batsman_id":"110871","bowler_id":"1049","over":"17","ball":"3","score":6,"commentary":"Ben Green to Dewald Brevis, Six,","noball_dismissal":false,"text":"","timestamp":1750364529,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12175323","event":"wicket","batsman_id":"110871","bowler_id":"1049","over":"17","ball":"4","score":"w","commentary":"Ben Green to Dewald Brevis, no run, c L Gregory b BGF Green,","noball_dismissal":false,"text":"","timestamp":1750364533,"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":"110871","how_out":"c L Gregory b BGF Green","batsman_runs":"36","batsman_balls":"16"},{"event_id":"12175325","event":"ball","batsman_id":"1945","bowler_id":"1049","over":"17","ball":"5","score":"1b","commentary":"Ben Green to Liam Dawson, 1 bye,","noball_dismissal":false,"text":"","timestamp":1750364588,"run":1,"noball_run":"0","wide_run":"0","bye_run":"1","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12175326","event":"ball","batsman_id":"49524","bowler_id":"1049","over":"17","ball":"6","score":2,"commentary":"Ben Green to Benny Howell, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750364592,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":18,"runs":16,"score":"173\/6","bats":[{"runs":4,"balls_faced":4,"fours":0,"sixes":0,"batsman_id":49524},{"runs":0,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":1945}],"bowls":[{"runs_conceded":40,"maidens":0,"wickets":3,"bowler_id":1049,"overs":4},{"runs_conceded":26,"maidens":0,"wickets":1,"bowler_id":93329,"overs":3}],"commentary":"End of over 18 (16 runs), Hampshire 173\/6"},{"event_id":"12175331","event":"ball","batsman_id":"1945","bowler_id":"93329","over":"18","ball":"1","score":0,"commentary":"Riley Meredith to Liam Dawson, no run,","noball_dismissal":false,"text":"","timestamp":1750364671,"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":"12175332","event":"ball","batsman_id":"1945","bowler_id":"93329","over":"18","ball":"2","score":1,"commentary":"Riley Meredith to Liam Dawson, 1 run,","noball_dismissal":false,"text":"","timestamp":1750364674,"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":"12175337","event":"ball","batsman_id":"49524","bowler_id":"93329","over":"18","ball":"3","score":1,"commentary":"Riley Meredith to Benny Howell, 1 run,","noball_dismissal":false,"text":"","timestamp":1750364810,"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":"12175338","event":"ball","batsman_id":"1945","bowler_id":"93329","over":"18","ball":"4","score":1,"commentary":"Riley Meredith to Liam Dawson, 1 run,","noball_dismissal":false,"text":"","timestamp":1750364813,"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":"12175339","event":"ball","batsman_id":"49524","bowler_id":"93329","over":"18","ball":"5","score":1,"commentary":"Riley Meredith to Benny Howell, 1 run,","noball_dismissal":false,"text":"","timestamp":1750364816,"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":"12175344","event":"ball","batsman_id":"1945","bowler_id":"93329","over":"18","ball":"6","score":4,"commentary":"Riley Meredith to Liam Dawson, Four,","noball_dismissal":false,"text":"","timestamp":1750364820,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event":"overend","over":19,"runs":8,"score":"181\/6","bats":[{"runs":6,"balls_faced":5,"fours":1,"sixes":0,"batsman_id":1945},{"runs":6,"balls_faced":6,"fours":0,"sixes":0,"batsman_id":49524}],"bowls":[{"runs_conceded":34,"maidens":0,"wickets":1,"bowler_id":93329,"overs":4},{"runs_conceded":40,"maidens":0,"wickets":3,"bowler_id":1049,"overs":4}],"commentary":"End of over 19 (8 runs), Hampshire 181\/6"},{"event_id":"12175348","event":"ball","batsman_id":"49524","bowler_id":"49421","over":"19","ball":"1","score":0,"commentary":"Lewis Gregory to Benny Howell, no run,","noball_dismissal":false,"text":"","timestamp":1750364890,"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":"12175349","event":"ball","batsman_id":"49524","bowler_id":"49421","over":"19","ball":"2","score":2,"commentary":"Lewis Gregory to Benny Howell, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750364893,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12175354","event":"ball","batsman_id":"49524","bowler_id":"49421","over":"19","ball":"3","score":2,"commentary":"Lewis Gregory to Benny Howell, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750365025,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12175355","event":"ball","batsman_id":"49524","bowler_id":"49421","over":"19","ball":"4","score":1,"commentary":"Lewis Gregory to Benny Howell, 1 run,","noball_dismissal":false,"text":"","timestamp":1750365029,"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":"12175356","event":"ball","batsman_id":"1945","bowler_id":"49421","over":"19","ball":"5","score":6,"commentary":"Lewis Gregory to Liam Dawson, Six,","noball_dismissal":false,"text":"","timestamp":1750365032,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12175357","event":"wicket","batsman_id":"1945","bowler_id":"49421","over":"19","ball":"6","score":"w","commentary":"Lewis Gregory to Liam Dawson, no run, c L Goldsworthy b L Gregory,","noball_dismissal":false,"text":"","timestamp":1750365061,"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":"1945","how_out":"c L Goldsworthy b L Gregory","batsman_runs":"12","batsman_balls":"7"},{"event":"overend","over":20,"runs":11,"score":"192\/7","bats":[{"runs":12,"balls_faced":7,"fours":1,"sixes":1,"batsman_id":1945},{"runs":11,"balls_faced":10,"fours":0,"sixes":0,"batsman_id":49524}],"bowls":[{"runs_conceded":29,"maidens":0,"wickets":1,"bowler_id":49421,"overs":3},{"runs_conceded":34,"maidens":0,"wickets":1,"bowler_id":93329,"overs":4}],"commentary":"End of over 20 (11 runs), Hampshire 192\/7"}],"day":"0","session":"0","live_inning":{"iid":198395,"number":2,"name":"Hampshire Inning","short_name":"HAM Inning","status":2,"issuperover":"false","result":4,"batting_team_id":7047,"fielding_team_id":7010,"scores":"192\/7","scores_full":"192\/7 (20 ov)","fielder":[{"fielder_id":"49413","fielder_name":"Tom Abell","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"49733","fielder_name":"Craig Overton","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"48656","fielder_name":"Tom Kohler-Cadmore","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"49421","fielder_name":"Lewis Gregory","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"93329","fielder_name":"Riley Meredith","catches":0,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":1,"stumping":0,"is_substitute":"false"},{"fielder_id":"95554","fielder_name":"Lewis Goldsworthy","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":[],"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Liam Dawson","batsman_id":"1945","runs":"12","balls":"7","how_out":"c L Goldsworthy b L Gregory","score_at_dismissal":192,"overs_at_dismissal":"19.6","bowler_id":"49421","dismissal":"caught","number":7},"extra_runs":{"byes":1,"legbyes":2,"wides":3,"noballs":0,"penalty":"0","total":6},"equations":{"runs":192,"wickets":7,"overs":"20","bowlers_used":6,"runrate":"9.60"},"current_partnership":{"runs":22,"balls":14,"overs":2.2,"batsmen":[{"name":"Liam Dawson","batsman_id":1945,"runs":12,"balls":7},{"name":"Benny Howell","batsman_id":49524,"runs":9,"balls":7}]},"did_not_bat":[{"player_id":"49478","name":"Chris Wood"},{"player_id":"96605","name":"Scott Currie"},{"player_id":"118936","name":"Eddie Jack"}],"max_over":"20","target":"210","recent_scores":"w,6,1,2,2,0,4,1,1,1,1,0,2,1,w,6,6,1","last_five_overs":"57\/3 11.03","last_ten_overs":"106\/6 10.43"},"teams":[{"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":"209\/7 (20 ov)","scores":"209\/7","overs":"20"},{"tid":7047,"title":"Hampshire","abbr":"HAM","alt_name":"HAM","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/hampshire-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/hampshire-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"192\/7 (20 ov)","scores":"192\/7","overs":"20"}],"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":"","thumb_url":"","profile_image":"","nationality":"Scotland","role":"all","role_str":""},{"pid":432,"title":"Kyle Abbott","short_name":"K Abbott","first_name":"Kyle Abbott","last_name":"","middle_name":"","birthdate":"1987-06-18","birthplace":"Empangeni, KwaZulu-Natal","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":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"squad","role_str":""},{"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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":1899,"title":"Roelof van der Merwe","short_name":"R Merwe","first_name":"Roelof van der Merwe","last_name":"","middle_name":"","birthdate":"1984-12-31","birthplace":"johannesburg,Transvaal","country":"nl","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":8,"facebook_profile":"https:\/\/www.facebook.com\/people\/Roelof-Van-der-Merwe\/100083113765394\/","twitter_profile":"https:\/\/twitter.com\/roela52","instagram_profile":"https:\/\/www.instagram.com\/roela52\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"squad","role_str":""},{"pid":1945,"title":"Liam Dawson","short_name":"L Dawson","first_name":"Liam Dawson","last_name":"","middle_name":"","birthdate":"1990-03-01","birthplace":"Swindon, Wiltshire","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":"","instagram_profile":"https:\/\/www.instagram.com\/daws128\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":1949,"title":"James Vince","short_name":"J Vince","first_name":"James Vince","last_name":"","middle_name":"","birthdate":"1991-03-14","birthplace":"Cuckfield, Sussex","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":9,"facebook_profile":"https:\/\/www.facebook.com\/vincey14\/","twitter_profile":"https:\/\/twitter.com\/vincey14","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"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":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":32166,"title":"James Fuller","short_name":"JK Fuller","first_name":"James Fuller","last_name":"","middle_name":"","birthdate":"1990-01-24","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":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/James_Fuller246","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":46147,"title":"Bjorn Fortuin","short_name":"BC Fortuin","first_name":"Bjorn Fortuin","last_name":"","middle_name":"","birthdate":"1994-10-21","birthplace":"Paarl","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/bjorn_fortuin","instagram_profile":"https:\/\/www.instagram.com\/bjornfortuin\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","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":9,"facebook_profile":"https:\/\/www.facebook.com\/tomkholerCadmore32\/","twitter_profile":"https:\/\/twitter.com\/TomKCadmore32","instagram_profile":"https:\/\/www.instagram.com\/tomkcadmore","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"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":"","thumb_url":"","profile_image":"","nationality":"Scotland","role":"squad","role_str":""},{"pid":49334,"title":"Ben Brown","short_name":"BC Brown","first_name":"Ben Brown","last_name":"","middle_name":"","birthdate":"1988-11-23","birthplace":"Crawley, Sussex","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":"https:\/\/twitter.com\/Ben_Brown26","instagram_profile":"https:\/\/www.instagram.com\/benbrown26\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49343,"title":"Nick Gubbins","short_name":"NRT Gubbins","first_name":"Nick Gubbins","last_name":"","middle_name":"","birthdate":"1993-12-31","birthplace":"Richmond, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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":"","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/lewisgregory23\/","debut_data":"","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.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/jackleach1991?lang=gu","instagram_profile":"https:\/\/www.instagram.com\/mjleach17\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49478,"title":"Chris Wood","short_name":"CP Wood","first_name":"Chris Wood","last_name":"","middle_name":"","birthdate":"1990-06-27","birthplace":"Basingstoke, Hampshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/CWoody27","instagram_profile":"https:\/\/www.instagram.com\/cwood25\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":49524,"title":"Benny Howell","short_name":"BAC Howell","first_name":"Benny Howell","last_name":"","middle_name":"","birthdate":"1988-10-05","birthplace":"Bordeaux, France","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":8,"facebook_profile":"https:\/\/www.facebook.com\/BennyHowellOfficial\/","twitter_profile":"https:\/\/twitter.com\/bennytweets_","instagram_profile":"https:\/\/www.instagram.com\/bennycam13\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":49536,"title":"Mark Stoneman","short_name":"MD Stoneman","first_name":"Mark Stoneman","last_name":"","middle_name":"","birthdate":"1987-06-26","birthplace":"Newcastle upon Tyne, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":18968,"recent_appearance":1514244600,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/mark23stone","instagram_profile":"https:\/\/www.instagram.com\/mark23stone\/","debut_data":"","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","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":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bat","role_str":""},{"pid":50481,"title":"Felix Organ","short_name":"FS Organ","first_name":"Felix Organ","last_name":"","middle_name":"","birthdate":"1999-06-02","birthplace":"Sydney","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50484,"title":"Brad Wheal","short_name":"BTJ Wheal","first_name":"Brad Wheal","last_name":"","middle_name":"","birthdate":"1996-08-28","birthplace":"Durban, KwaZulu-Natal","country":"sct","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.5,"facebook_profile":"https:\/\/www.facebook.com\/brad.wheal\/","twitter_profile":"https:\/\/twitter.com\/BradWheal","instagram_profile":"https:\/\/www.instagram.com\/bradwheal\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Scotland","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":51285,"title":"Joe Weatherley","short_name":"JJ Weatherley","first_name":"Joe Weatherley","last_name":"","middle_name":"","birthdate":"1997-01-19","birthplace":"Winchester, Hampshire","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":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Joe_Weatherley","instagram_profile":"https:\/\/www.instagram.com\/jjweatherley\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":52897,"title":"Matt Renshaw","short_name":"MT Renshaw","first_name":"Matt Renshaw","last_name":"","middle_name":"","birthdate":"1996-03-28","birthplace":"Middlesbrough, Yorkshire","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/whatsmattrenshawthinking\/","twitter_profile":"https:\/\/twitter.com\/MattRenshaw449","instagram_profile":"https:\/\/www.instagram.com\/mattrenshaw449\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","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.5,"facebook_profile":"https:\/\/www.facebook.com\/migael27\/","twitter_profile":"https:\/\/twitter.com\/migael_27","instagram_profile":"https:\/\/www.instagram.com\/migael27\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":92948,"title":"Josh Thomas","short_name":"J Thomas","first_name":"Josh Thomas","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","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":"","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95550,"title":"Kasey Aldridge","short_name":"K Aldridge","first_name":"Kasey Aldridge","last_name":"","middle_name":"","birthdate":"2000-12-24","birthplace":"Bristol","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":"","instagram_profile":"https:\/\/www.instagram.com\/kcaldridge5\/","debut_data":"","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":96605,"title":"Scott Currie","short_name":"S Currie","first_name":"Scott Currie","last_name":"","middle_name":"","birthdate":"2001-05-02","birthplace":"Poole, Dorset","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","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":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/will_smeed","instagram_profile":"https:\/\/www.instagram.com\/willsmeed\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":108376,"title":"Tom Prest","short_name":"T Prest","first_name":"Tom Prest","last_name":"","middle_name":"","birthdate":"2003-03-24","birthplace":"Wimborne, Dorset","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108377,"title":"Toby Albert","short_name":"T Albert","first_name":"Toby Albert","last_name":"","middle_name":"","birthdate":"2001-11-12","birthplace":"Basingstoke, Hampshire","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":""},{"pid":108378,"title":"Fletcha Middleton","short_name":"F Middleton","first_name":"Fletcha Middleton","last_name":"","middle_name":"","birthdate":"2002-01-31","birthplace":"Winchester, Hampshire","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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108381,"title":"John Turner","short_name":"J Turner","first_name":"John Turner","last_name":"","middle_name":"","birthdate":"2001-04-10","birthplace":"Johannesburg, Gauteng","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108409,"title":"Sonny Baker","short_name":"S Baker","first_name":"Sonny Baker","last_name":"","middle_name":"","birthdate":"2003-03-13","birthplace":"Torbay, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/sonnybaker\/","debut_data":"","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":109051,"title":"Ali Orr","short_name":"AGH Orr","first_name":"Ali Orr","last_name":"","middle_name":"","birthdate":"2001-04-06","birthplace":"Eastbourne, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/alastairorr\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":110871,"title":"Dewald Brevis","short_name":"D Brevis","first_name":"Dewald Brevis","last_name":"","middle_name":"","birthdate":"2003-04-29","birthplace":"Johannesburg","country":"za","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,"facebook_profile":"https:\/\/www.facebook.com\/Brevis17\/","twitter_profile":"https:\/\/twitter.com\/BrevisDewald","instagram_profile":"https:\/\/www.instagram.com\/dewald_brevis_17\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bat","role_str":""},{"pid":118628,"title":"Alfie Ogborne","short_name":"ARJ Ogborne","first_name":"Alfie Ogborne","last_name":"","middle_name":"","birthdate":"2003-07-15","birthplace":" Yeovil, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/alfieogborne\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":118936,"title":"Eddie Jack","short_name":"EV Jack","first_name":"Eddie Jack","last_name":"","middle_name":"","birthdate":"2005-09-09","birthplace":"Barnet, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":126366,"title":"Shoaib Bashir","short_name":"S Bashir","first_name":"Shoaib Bashir","last_name":"","middle_name":"","birthdate":"2003-10-13","birthplace":"Chertsey, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":128989,"title":"Lhuan dre Pretorius","short_name":"Ld Pretorius","first_name":"Lhuan dre Pretorius","last_name":"","middle_name":"","birthdate":"2006-03-27","birthplace":"Potchefstroom","country":"za","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"wk","role_str":"(WK)"},{"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":"","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":"","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":146438,"title":"Thomas Rew","short_name":"T Rew","first_name":"Thomas Rew","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""}]},"etag":"134caf740a07dd05fa129070c72725a5","modified":"2025-07-10 13:40:36","datetime":"2025-07-10 13:40:36","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":86883,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Somerset won by 17 runs","day_remaining_over":"","team_batting":"Hampshire","team_bowling":"Somerset","live_inning_number":2,"live_score":{"runs":192,"overs":20,"wickets":7,"target":210,"runrate":9.6,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Benny Howell","batsman_id":49524,"runs":11,"balls_faced":10,"fours":0,"sixes":0,"strike_rate":"110.00"},{"name":"Liam Dawson","batsman_id":1945,"runs":12,"balls_faced":7,"fours":1,"sixes":1,"strike_rate":"171.43"}],"bowlers":[{"name":"Lewis Gregory","bowler_id":49421,"overs":3,"runs_conceded":29,"wickets":1,"maidens":0,"econ":"9.67"},{"name":"Riley Meredith","bowler_id":93329,"overs":4,"runs_conceded":34,"wickets":1,"maidens":0,"econ":"8.50"}],"commentaries":[{"event_id":"12175278","event":"ball","batsman_id":"32166","bowler_id":"301","over":"15","ball":"5","score":4,"commentary":"Josh Davey to James Fuller, Four,","noball_dismissal":false,"text":"","timestamp":1750363926,"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":"12175288","event":"ball","batsman_id":"32166","bowler_id":"301","over":"15","ball":"6","score":1,"commentary":"Josh Davey to James Fuller, 1 run,","noball_dismissal":false,"text":"","timestamp":1750364119,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":16,"runs":19,"score":"154\/4","bats":[{"runs":11,"balls_faced":4,"fours":1,"sixes":1,"batsman_id":32166},{"runs":23,"balls_faced":11,"fours":1,"sixes":2,"batsman_id":110871}],"bowls":[{"runs_conceded":40,"maidens":0,"wickets":0,"bowler_id":301,"overs":3},{"runs_conceded":24,"maidens":0,"wickets":0,"bowler_id":93329,"overs":2}],"commentary":"End of over 16 (19 runs), Hampshire 154\/4"},{"event_id":"12175296","event":"ball","batsman_id":"32166","bowler_id":"93329","over":"16","ball":"1","score":0,"commentary":"Riley Meredith to James Fuller, no run,","noball_dismissal":false,"text":"","timestamp":1750364182,"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":"12175299","event":"wicket","batsman_id":"32166","bowler_id":"93329","over":"16","ball":"2","score":"w","commentary":"Riley Meredith to James Fuller, no run, b RP Meredith,","noball_dismissal":false,"text":"","timestamp":1750364186,"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":"32166","how_out":"b RP Meredith","batsman_runs":"11","batsman_balls":"6"},{"event_id":"12175303","event":"ball","batsman_id":"49524","bowler_id":"93329","over":"16","ball":"3","score":"1lb","commentary":"Riley Meredith to Benny Howell, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1750364212,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"1","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12175304","event":"ball","batsman_id":"110871","bowler_id":"93329","over":"16","ball":"4","score":1,"commentary":"Riley Meredith to Dewald Brevis, 1 run,","noball_dismissal":false,"text":"","timestamp":1750364216,"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":"12175312","event":"ball","batsman_id":"49524","bowler_id":"93329","over":"16","ball":"5","score":1,"commentary":"Riley Meredith to Benny Howell, 1 run,","noball_dismissal":false,"text":"","timestamp":1750364328,"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":"12175313","event":"ball","batsman_id":"110871","bowler_id":"93329","over":"16","ball":"6","score":0,"commentary":"Riley Meredith to Dewald Brevis, no run,","noball_dismissal":false,"text":"","timestamp":1750364332,"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":17,"runs":3,"score":"157\/5","bats":[{"runs":24,"balls_faced":13,"fours":1,"sixes":2,"batsman_id":110871},{"runs":1,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":49524}],"bowls":[{"runs_conceded":26,"maidens":0,"wickets":1,"bowler_id":93329,"overs":3},{"runs_conceded":40,"maidens":0,"wickets":0,"bowler_id":301,"overs":3}],"commentary":"End of over 17 (3 runs), Hampshire 157\/5"},{"event_id":"12175315","event":"ball","batsman_id":"49524","bowler_id":"1049","over":"17","ball":"1","score":1,"commentary":"Ben Green to Benny Howell, 1 run,","noball_dismissal":false,"text":"","timestamp":1750364361,"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":"12175316","event":"ball","batsman_id":"110871","bowler_id":"1049","over":"17","ball":"2","score":6,"commentary":"Ben Green to Dewald Brevis, Six,","noball_dismissal":false,"text":"","timestamp":1750364364,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12175320","event":"ball","batsman_id":"110871","bowler_id":"1049","over":"17","ball":"3","score":6,"commentary":"Ben Green to Dewald Brevis, Six,","noball_dismissal":false,"text":"","timestamp":1750364529,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12175323","event":"wicket","batsman_id":"110871","bowler_id":"1049","over":"17","ball":"4","score":"w","commentary":"Ben Green to Dewald Brevis, no run, c L Gregory b BGF Green,","noball_dismissal":false,"text":"","timestamp":1750364533,"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":"110871","how_out":"c L Gregory b BGF Green","batsman_runs":"36","batsman_balls":"16"},{"event_id":"12175325","event":"ball","batsman_id":"1945","bowler_id":"1049","over":"17","ball":"5","score":"1b","commentary":"Ben Green to Liam Dawson, 1 bye,","noball_dismissal":false,"text":"","timestamp":1750364588,"run":1,"noball_run":"0","wide_run":"0","bye_run":"1","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12175326","event":"ball","batsman_id":"49524","bowler_id":"1049","over":"17","ball":"6","score":2,"commentary":"Ben Green to Benny Howell, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750364592,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":18,"runs":16,"score":"173\/6","bats":[{"runs":4,"balls_faced":4,"fours":0,"sixes":0,"batsman_id":49524},{"runs":0,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":1945}],"bowls":[{"runs_conceded":40,"maidens":0,"wickets":3,"bowler_id":1049,"overs":4},{"runs_conceded":26,"maidens":0,"wickets":1,"bowler_id":93329,"overs":3}],"commentary":"End of over 18 (16 runs), Hampshire 173\/6"},{"event_id":"12175331","event":"ball","batsman_id":"1945","bowler_id":"93329","over":"18","ball":"1","score":0,"commentary":"Riley Meredith to Liam Dawson, no run,","noball_dismissal":false,"text":"","timestamp":1750364671,"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":"12175332","event":"ball","batsman_id":"1945","bowler_id":"93329","over":"18","ball":"2","score":1,"commentary":"Riley Meredith to Liam Dawson, 1 run,","noball_dismissal":false,"text":"","timestamp":1750364674,"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":"12175337","event":"ball","batsman_id":"49524","bowler_id":"93329","over":"18","ball":"3","score":1,"commentary":"Riley Meredith to Benny Howell, 1 run,","noball_dismissal":false,"text":"","timestamp":1750364810,"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":"12175338","event":"ball","batsman_id":"1945","bowler_id":"93329","over":"18","ball":"4","score":1,"commentary":"Riley Meredith to Liam Dawson, 1 run,","noball_dismissal":false,"text":"","timestamp":1750364813,"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":"12175339","event":"ball","batsman_id":"49524","bowler_id":"93329","over":"18","ball":"5","score":1,"commentary":"Riley Meredith to Benny Howell, 1 run,","noball_dismissal":false,"text":"","timestamp":1750364816,"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":"12175344","event":"ball","batsman_id":"1945","bowler_id":"93329","over":"18","ball":"6","score":4,"commentary":"Riley Meredith to Liam Dawson, Four,","noball_dismissal":false,"text":"","timestamp":1750364820,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event":"overend","over":19,"runs":8,"score":"181\/6","bats":[{"runs":6,"balls_faced":5,"fours":1,"sixes":0,"batsman_id":1945},{"runs":6,"balls_faced":6,"fours":0,"sixes":0,"batsman_id":49524}],"bowls":[{"runs_conceded":34,"maidens":0,"wickets":1,"bowler_id":93329,"overs":4},{"runs_conceded":40,"maidens":0,"wickets":3,"bowler_id":1049,"overs":4}],"commentary":"End of over 19 (8 runs), Hampshire 181\/6"},{"event_id":"12175348","event":"ball","batsman_id":"49524","bowler_id":"49421","over":"19","ball":"1","score":0,"commentary":"Lewis Gregory to Benny Howell, no run,","noball_dismissal":false,"text":"","timestamp":1750364890,"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":"12175349","event":"ball","batsman_id":"49524","bowler_id":"49421","over":"19","ball":"2","score":2,"commentary":"Lewis Gregory to Benny Howell, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750364893,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12175354","event":"ball","batsman_id":"49524","bowler_id":"49421","over":"19","ball":"3","score":2,"commentary":"Lewis Gregory to Benny Howell, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750365025,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12175355","event":"ball","batsman_id":"49524","bowler_id":"49421","over":"19","ball":"4","score":1,"commentary":"Lewis Gregory to Benny Howell, 1 run,","noball_dismissal":false,"text":"","timestamp":1750365029,"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":"12175356","event":"ball","batsman_id":"1945","bowler_id":"49421","over":"19","ball":"5","score":6,"commentary":"Lewis Gregory to Liam Dawson, Six,","noball_dismissal":false,"text":"","timestamp":1750365032,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12175357","event":"wicket","batsman_id":"1945","bowler_id":"49421","over":"19","ball":"6","score":"w","commentary":"Lewis Gregory to Liam Dawson, no run, c L Goldsworthy b L Gregory,","noball_dismissal":false,"text":"","timestamp":1750365061,"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":"1945","how_out":"c L Goldsworthy b L Gregory","batsman_runs":"12","batsman_balls":"7"},{"event":"overend","over":20,"runs":11,"score":"192\/7","bats":[{"runs":12,"balls_faced":7,"fours":1,"sixes":1,"batsman_id":1945},{"runs":11,"balls_faced":10,"fours":0,"sixes":0,"batsman_id":49524}],"bowls":[{"runs_conceded":29,"maidens":0,"wickets":1,"bowler_id":49421,"overs":3},{"runs_conceded":34,"maidens":0,"wickets":1,"bowler_id":93329,"overs":4}],"commentary":"End of over 20 (11 runs), Hampshire 192\/7"}],"day":"0","session":"0","live_inning":{"iid":198395,"number":2,"name":"Hampshire Inning","short_name":"HAM Inning","status":2,"issuperover":"false","result":4,"batting_team_id":7047,"fielding_team_id":7010,"scores":"192\/7","scores_full":"192\/7 (20 ov)","fielder":[{"fielder_id":"49413","fielder_name":"Tom Abell","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"49733","fielder_name":"Craig Overton","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"48656","fielder_name":"Tom Kohler-Cadmore","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"49421","fielder_name":"Lewis Gregory","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"93329","fielder_name":"Riley Meredith","catches":0,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":1,"stumping":0,"is_substitute":"false"},{"fielder_id":"95554","fielder_name":"Lewis Goldsworthy","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":[],"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Liam Dawson","batsman_id":"1945","runs":"12","balls":"7","how_out":"c L Goldsworthy b L Gregory","score_at_dismissal":192,"overs_at_dismissal":"19.6","bowler_id":"49421","dismissal":"caught","number":7},"extra_runs":{"byes":1,"legbyes":2,"wides":3,"noballs":0,"penalty":"0","total":6},"equations":{"runs":192,"wickets":7,"overs":"20","bowlers_used":6,"runrate":"9.60"},"current_partnership":{"runs":22,"balls":14,"overs":2.2,"batsmen":[{"name":"Liam Dawson","batsman_id":1945,"runs":12,"balls":7},{"name":"Benny Howell","batsman_id":49524,"runs":9,"balls":7}]},"did_not_bat":[{"player_id":"49478","name":"Chris Wood"},{"player_id":"96605","name":"Scott Currie"},{"player_id":"118936","name":"Eddie Jack"}],"max_over":"20","target":"210","recent_scores":"w,6,1,2,2,0,4,1,1,1,1,0,2,1,w,6,6,1","last_five_overs":"57\/3 11.03","last_ten_overs":"106\/6 10.43"},"teams":[{"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":"209\/7 (20 ov)","scores":"209\/7","overs":"20"},{"tid":7047,"title":"Hampshire","abbr":"HAM","alt_name":"HAM","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/hampshire-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/hampshire-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"192\/7 (20 ov)","scores":"192\/7","overs":"20"}],"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":"","thumb_url":"","profile_image":"","nationality":"Scotland","role":"all","role_str":""},{"pid":432,"title":"Kyle Abbott","short_name":"K Abbott","first_name":"Kyle Abbott","last_name":"","middle_name":"","birthdate":"1987-06-18","birthplace":"Empangeni, KwaZulu-Natal","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":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"squad","role_str":""},{"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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":1899,"title":"Roelof van der Merwe","short_name":"R Merwe","first_name":"Roelof van der Merwe","last_name":"","middle_name":"","birthdate":"1984-12-31","birthplace":"johannesburg,Transvaal","country":"nl","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":8,"facebook_profile":"https:\/\/www.facebook.com\/people\/Roelof-Van-der-Merwe\/100083113765394\/","twitter_profile":"https:\/\/twitter.com\/roela52","instagram_profile":"https:\/\/www.instagram.com\/roela52\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"squad","role_str":""},{"pid":1945,"title":"Liam Dawson","short_name":"L Dawson","first_name":"Liam Dawson","last_name":"","middle_name":"","birthdate":"1990-03-01","birthplace":"Swindon, Wiltshire","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":"","instagram_profile":"https:\/\/www.instagram.com\/daws128\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":1949,"title":"James Vince","short_name":"J Vince","first_name":"James Vince","last_name":"","middle_name":"","birthdate":"1991-03-14","birthplace":"Cuckfield, Sussex","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":9,"facebook_profile":"https:\/\/www.facebook.com\/vincey14\/","twitter_profile":"https:\/\/twitter.com\/vincey14","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"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":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":32166,"title":"James Fuller","short_name":"JK Fuller","first_name":"James Fuller","last_name":"","middle_name":"","birthdate":"1990-01-24","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":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/James_Fuller246","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":46147,"title":"Bjorn Fortuin","short_name":"BC Fortuin","first_name":"Bjorn Fortuin","last_name":"","middle_name":"","birthdate":"1994-10-21","birthplace":"Paarl","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/bjorn_fortuin","instagram_profile":"https:\/\/www.instagram.com\/bjornfortuin\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","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":9,"facebook_profile":"https:\/\/www.facebook.com\/tomkholerCadmore32\/","twitter_profile":"https:\/\/twitter.com\/TomKCadmore32","instagram_profile":"https:\/\/www.instagram.com\/tomkcadmore","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"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":"","thumb_url":"","profile_image":"","nationality":"Scotland","role":"squad","role_str":""},{"pid":49334,"title":"Ben Brown","short_name":"BC Brown","first_name":"Ben Brown","last_name":"","middle_name":"","birthdate":"1988-11-23","birthplace":"Crawley, Sussex","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":"https:\/\/twitter.com\/Ben_Brown26","instagram_profile":"https:\/\/www.instagram.com\/benbrown26\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49343,"title":"Nick Gubbins","short_name":"NRT Gubbins","first_name":"Nick Gubbins","last_name":"","middle_name":"","birthdate":"1993-12-31","birthplace":"Richmond, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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":"","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/lewisgregory23\/","debut_data":"","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.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/jackleach1991?lang=gu","instagram_profile":"https:\/\/www.instagram.com\/mjleach17\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49478,"title":"Chris Wood","short_name":"CP Wood","first_name":"Chris Wood","last_name":"","middle_name":"","birthdate":"1990-06-27","birthplace":"Basingstoke, Hampshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/CWoody27","instagram_profile":"https:\/\/www.instagram.com\/cwood25\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":49524,"title":"Benny Howell","short_name":"BAC Howell","first_name":"Benny Howell","last_name":"","middle_name":"","birthdate":"1988-10-05","birthplace":"Bordeaux, France","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":8,"facebook_profile":"https:\/\/www.facebook.com\/BennyHowellOfficial\/","twitter_profile":"https:\/\/twitter.com\/bennytweets_","instagram_profile":"https:\/\/www.instagram.com\/bennycam13\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":49536,"title":"Mark Stoneman","short_name":"MD Stoneman","first_name":"Mark Stoneman","last_name":"","middle_name":"","birthdate":"1987-06-26","birthplace":"Newcastle upon Tyne, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":18968,"recent_appearance":1514244600,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/mark23stone","instagram_profile":"https:\/\/www.instagram.com\/mark23stone\/","debut_data":"","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","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":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bat","role_str":""},{"pid":50481,"title":"Felix Organ","short_name":"FS Organ","first_name":"Felix Organ","last_name":"","middle_name":"","birthdate":"1999-06-02","birthplace":"Sydney","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50484,"title":"Brad Wheal","short_name":"BTJ Wheal","first_name":"Brad Wheal","last_name":"","middle_name":"","birthdate":"1996-08-28","birthplace":"Durban, KwaZulu-Natal","country":"sct","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.5,"facebook_profile":"https:\/\/www.facebook.com\/brad.wheal\/","twitter_profile":"https:\/\/twitter.com\/BradWheal","instagram_profile":"https:\/\/www.instagram.com\/bradwheal\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Scotland","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":51285,"title":"Joe Weatherley","short_name":"JJ Weatherley","first_name":"Joe Weatherley","last_name":"","middle_name":"","birthdate":"1997-01-19","birthplace":"Winchester, Hampshire","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":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Joe_Weatherley","instagram_profile":"https:\/\/www.instagram.com\/jjweatherley\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":52897,"title":"Matt Renshaw","short_name":"MT Renshaw","first_name":"Matt Renshaw","last_name":"","middle_name":"","birthdate":"1996-03-28","birthplace":"Middlesbrough, Yorkshire","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/whatsmattrenshawthinking\/","twitter_profile":"https:\/\/twitter.com\/MattRenshaw449","instagram_profile":"https:\/\/www.instagram.com\/mattrenshaw449\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","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.5,"facebook_profile":"https:\/\/www.facebook.com\/migael27\/","twitter_profile":"https:\/\/twitter.com\/migael_27","instagram_profile":"https:\/\/www.instagram.com\/migael27\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":92948,"title":"Josh Thomas","short_name":"J Thomas","first_name":"Josh Thomas","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","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":"","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95550,"title":"Kasey Aldridge","short_name":"K Aldridge","first_name":"Kasey Aldridge","last_name":"","middle_name":"","birthdate":"2000-12-24","birthplace":"Bristol","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":"","instagram_profile":"https:\/\/www.instagram.com\/kcaldridge5\/","debut_data":"","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":96605,"title":"Scott Currie","short_name":"S Currie","first_name":"Scott Currie","last_name":"","middle_name":"","birthdate":"2001-05-02","birthplace":"Poole, Dorset","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","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":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/will_smeed","instagram_profile":"https:\/\/www.instagram.com\/willsmeed\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":108376,"title":"Tom Prest","short_name":"T Prest","first_name":"Tom Prest","last_name":"","middle_name":"","birthdate":"2003-03-24","birthplace":"Wimborne, Dorset","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108377,"title":"Toby Albert","short_name":"T Albert","first_name":"Toby Albert","last_name":"","middle_name":"","birthdate":"2001-11-12","birthplace":"Basingstoke, Hampshire","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":""},{"pid":108378,"title":"Fletcha Middleton","short_name":"F Middleton","first_name":"Fletcha Middleton","last_name":"","middle_name":"","birthdate":"2002-01-31","birthplace":"Winchester, Hampshire","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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108381,"title":"John Turner","short_name":"J Turner","first_name":"John Turner","last_name":"","middle_name":"","birthdate":"2001-04-10","birthplace":"Johannesburg, Gauteng","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108409,"title":"Sonny Baker","short_name":"S Baker","first_name":"Sonny Baker","last_name":"","middle_name":"","birthdate":"2003-03-13","birthplace":"Torbay, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/sonnybaker\/","debut_data":"","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":109051,"title":"Ali Orr","short_name":"AGH Orr","first_name":"Ali Orr","last_name":"","middle_name":"","birthdate":"2001-04-06","birthplace":"Eastbourne, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/alastairorr\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":110871,"title":"Dewald Brevis","short_name":"D Brevis","first_name":"Dewald Brevis","last_name":"","middle_name":"","birthdate":"2003-04-29","birthplace":"Johannesburg","country":"za","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,"facebook_profile":"https:\/\/www.facebook.com\/Brevis17\/","twitter_profile":"https:\/\/twitter.com\/BrevisDewald","instagram_profile":"https:\/\/www.instagram.com\/dewald_brevis_17\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bat","role_str":""},{"pid":118628,"title":"Alfie Ogborne","short_name":"ARJ Ogborne","first_name":"Alfie Ogborne","last_name":"","middle_name":"","birthdate":"2003-07-15","birthplace":" Yeovil, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/alfieogborne\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":118936,"title":"Eddie Jack","short_name":"EV Jack","first_name":"Eddie Jack","last_name":"","middle_name":"","birthdate":"2005-09-09","birthplace":"Barnet, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":126366,"title":"Shoaib Bashir","short_name":"S Bashir","first_name":"Shoaib Bashir","last_name":"","middle_name":"","birthdate":"2003-10-13","birthplace":"Chertsey, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":128989,"title":"Lhuan dre Pretorius","short_name":"Ld Pretorius","first_name":"Lhuan dre Pretorius","last_name":"","middle_name":"","birthdate":"2006-03-27","birthplace":"Potchefstroom","country":"za","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"wk","role_str":"(WK)"},{"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":"","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":"","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":146438,"title":"Thomas Rew","short_name":"T Rew","first_name":"Thomas Rew","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""}]},"etag":"134caf740a07dd05fa129070c72725a5","modified":"2025-07-10 13:40:36","datetime":"2025-07-10 13:40:36","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86883 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:c305be5b-8d68-4538-9e10-965315b68506
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86883 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86883,3,'{"status":"ok","response":{"match_id":86883,"title":"Somerset vs Hampshire","short_title":"SOM vs HAM","subtitle":"Match 63","match_number":"63","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Somerset won by 17 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":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":"209\/7 (20 ov)","scores":"209\/7","overs":"20"},"teamb":{"team_id":7047,"name":"Hampshire","short_name":"HAM","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/hampshire-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/hampshire-logo.png","scores_full":"192\/7 (20 ov)","scores":"192\/7","overs":"20"},"date_start":"2025-06-19 17:30:00","date_end":"2025-06-20 03:30:00","timestamp_start":1750354200,"timestamp_end":1750390200,"date_start_ist":"2025-06-19 23:00:00","date_end_ist":"2025-06-20 09:00:00","venue":{"venue_id":"40","name":"The Cooper Associates County Ground, Taunton","location":"Taunton","country":"England","timezone":""},"umpires":" Ian Blackwell (England), Paul Baldwin (England)","referee":"Mike Smith Jr (England)","equation":"","live":"","result":"SOM won by 17 runs","result_type":1,"win_margin":"17 runs","winning_team_id":7010,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-18 23:16:52","verify_time":"2025-06-20 02:11:50","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"","weather_desc":"","temp":"","humidity":"","visibility":"","wind_speed":"","clouds":""},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Hampshire elected to bowl","winner":7047,"decision":2}},"etag":"8ca171968224b2af41cae4cefce55a15","modified":"2025-07-10 13:40:37","datetime":"2025-07-10 13:40:37","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":86883,"title":"Somerset vs Hampshire","short_title":"SOM vs HAM","subtitle":"Match 63","match_number":"63","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Somerset won by 17 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":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":"209\/7 (20 ov)","scores":"209\/7","overs":"20"},"teamb":{"team_id":7047,"name":"Hampshire","short_name":"HAM","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/hampshire-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/hampshire-logo.png","scores_full":"192\/7 (20 ov)","scores":"192\/7","overs":"20"},"date_start":"2025-06-19 17:30:00","date_end":"2025-06-20 03:30:00","timestamp_start":1750354200,"timestamp_end":1750390200,"date_start_ist":"2025-06-19 23:00:00","date_end_ist":"2025-06-20 09:00:00","venue":{"venue_id":"40","name":"The Cooper Associates County Ground, Taunton","location":"Taunton","country":"England","timezone":""},"umpires":" Ian Blackwell (England), Paul Baldwin (England)","referee":"Mike Smith Jr (England)","equation":"","live":"","result":"SOM won by 17 runs","result_type":1,"win_margin":"17 runs","winning_team_id":7010,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-18 23:16:52","verify_time":"2025-06-20 02:11:50","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"","weather_desc":"","temp":"","humidity":"","visibility":"","wind_speed":"","clouds":""},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Hampshire elected to bowl","winner":7047,"decision":2}},"etag":"8ca171968224b2af41cae4cefce55a15","modified":"2025-07-10 13:40:37","datetime":"2025-07-10 13:40:37","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86883 AND DataTypeId = 3 END Live Report & Scorecard of Somerset vs Hampshire Match 63