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:cd234670-a342-45a0-b84d-ef37474ae9cb
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86863 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86863,1,'{"status":"ok","response":{"mid":86863,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Somerset won by 6 wickets","day_remaining_over":"","team_batting":"Somerset","team_bowling":"Gloucestershire","live_inning_number":2,"live_score":{"runs":137,"overs":17.4,"wickets":4,"target":136,"runrate":7.75,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Lewis Gregory","batsman_id":49421,"runs":33,"balls_faced":17,"fours":2,"sixes":3,"strike_rate":"194.12"},{"name":"Will Smeed","batsman_id":103052,"runs":51,"balls_faced":45,"fours":8,"sixes":1,"strike_rate":"113.33"}],"bowlers":[{"name":"Ajeet Singh Dale","bowler_id":101483,"overs":3.4,"runs_conceded":31,"wickets":1,"maidens":0,"econ":"8.45"},{"name":"Jack Taylor","bowler_id":49747,"overs":2,"runs_conceded":13,"wickets":0,"maidens":0,"econ":"6.50"}],"commentaries":[{"event_id":"12137960","event":"ball","batsman_id":"49823","bowler_id":"110606","over":"13","ball":"2","score":1,"commentary":"Zaman Akhter to Sean Dickson, 1 run,","noball_dismissal":false,"text":"","timestamp":1749846171,"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":"12137962","event":"ball","batsman_id":"103052","bowler_id":"110606","over":"13","ball":"3","score":4,"commentary":"Zaman Akhter to Will Smeed, Four,","noball_dismissal":false,"text":"","timestamp":1749846072,"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":"12137969","event":"ball","batsman_id":"103052","bowler_id":"110606","over":"13","ball":"4","score":1,"commentary":"Zaman Akhter to Will Smeed, 1 run,","noball_dismissal":false,"text":"","timestamp":1749846098,"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":"12137973","event":"wicket","batsman_id":"49823","bowler_id":"110606","over":"13","ball":"5","score":"w","commentary":"Zaman Akhter to Sean Dickson, no run, b Z Akhter,","noball_dismissal":false,"text":"","timestamp":1749846187,"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":"49823","how_out":"b Z Akhter","batsman_runs":"23","batsman_balls":"17"},{"event_id":"12137983","event":"ball","batsman_id":"49421","bowler_id":"110606","over":"13","ball":"6","score":1,"commentary":"Zaman Akhter to Lewis Gregory, 1 run,","noball_dismissal":false,"text":"","timestamp":1749846246,"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":14,"runs":9,"score":"102\/4","bats":[{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":49421},{"runs":48,"balls_faced":39,"fours":8,"sixes":1,"batsman_id":103052}],"bowls":[{"runs_conceded":25,"maidens":0,"wickets":1,"bowler_id":110606,"overs":2},{"runs_conceded":28,"maidens":0,"wickets":1,"bowler_id":84301,"overs":4}],"commentary":"End of over 14 (9 runs), Somerset 102\/4"},{"event_id":"12137988","event":"ball","batsman_id":"49421","bowler_id":"49747","over":"14","ball":"1","score":4,"commentary":"Jack Taylor to Lewis Gregory, Four,","noball_dismissal":false,"text":"","timestamp":1749846286,"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":"12137990","event":"ball","batsman_id":"49421","bowler_id":"49747","over":"14","ball":"2","score":1,"commentary":"Jack Taylor to Lewis Gregory, 1 run,","noball_dismissal":false,"text":"","timestamp":1749846299,"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":"12137995","event":"ball","batsman_id":"103052","bowler_id":"49747","over":"14","ball":"3","score":0,"commentary":"Jack Taylor to Will Smeed, no run,","noball_dismissal":false,"text":"","timestamp":1749846317,"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":"12137997","event":"ball","batsman_id":"103052","bowler_id":"49747","over":"14","ball":"4","score":1,"commentary":"Jack Taylor to Will Smeed, 1 run,","noball_dismissal":false,"text":"","timestamp":1749846333,"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":"12138000","event":"ball","batsman_id":"49421","bowler_id":"49747","over":"14","ball":"5","score":0,"commentary":"Jack Taylor to Lewis Gregory, no run,","noball_dismissal":false,"text":"","timestamp":1749846351,"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":"12138001","event":"ball","batsman_id":"49421","bowler_id":"49747","over":"14","ball":"6","score":0,"commentary":"Jack Taylor to Lewis Gregory, no run,","noball_dismissal":false,"text":"","timestamp":1749846361,"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":15,"runs":6,"score":"108\/4","bats":[{"runs":6,"balls_faced":5,"fours":1,"sixes":0,"batsman_id":49421},{"runs":49,"balls_faced":41,"fours":8,"sixes":1,"batsman_id":103052}],"bowls":[{"runs_conceded":6,"maidens":0,"wickets":0,"bowler_id":49747,"overs":1},{"runs_conceded":25,"maidens":0,"wickets":1,"bowler_id":110606,"overs":2}],"commentary":"End of over 15 (6 runs), Somerset 108\/4"},{"event_id":"12138013","event":"ball","batsman_id":"103052","bowler_id":"49526","over":"15","ball":"1","score":1,"commentary":"David Payne to Will Smeed, 1 run,","noball_dismissal":false,"text":"","timestamp":1749846489,"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":"12138015","event":"ball","batsman_id":"49421","bowler_id":"49526","over":"15","ball":"2","score":1,"commentary":"David Payne to Lewis Gregory, 1 run,","noball_dismissal":false,"text":"","timestamp":1749846492,"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":"12138018","event":"ball","batsman_id":"103052","bowler_id":"49526","over":"15","ball":"3","score":1,"commentary":"David Payne to Will Smeed, 1 run,","noball_dismissal":false,"text":"","timestamp":1749846519,"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":"12138025","event":"ball","batsman_id":"49421","bowler_id":"49526","over":"15","ball":"4","score":0,"commentary":"David Payne to Lewis Gregory, no run,","noball_dismissal":false,"text":"","timestamp":1749846552,"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":"12138029","event":"ball","batsman_id":"49421","bowler_id":"49526","over":"15","ball":"5","score":6,"commentary":"David Payne to Lewis Gregory, Six,","noball_dismissal":false,"text":"","timestamp":1749846584,"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":"12138032","event":"ball","batsman_id":"49421","bowler_id":"49526","over":"15","ball":"6","score":1,"commentary":"David Payne to Lewis Gregory, 1 run,","noball_dismissal":false,"text":"","timestamp":1749846671,"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":10,"score":"118\/4","bats":[{"runs":14,"balls_faced":9,"fours":1,"sixes":1,"batsman_id":49421},{"runs":51,"balls_faced":43,"fours":8,"sixes":1,"batsman_id":103052}],"bowls":[{"runs_conceded":15,"maidens":0,"wickets":1,"bowler_id":49526,"overs":4},{"runs_conceded":6,"maidens":0,"wickets":0,"bowler_id":49747,"overs":1}],"commentary":"End of over 16 (10 runs), Somerset 118\/4"},{"event_id":"12138036","event":"ball","batsman_id":"49421","bowler_id":"49747","over":"16","ball":"1","score":6,"commentary":"Jack Taylor to Lewis Gregory, Six,","noball_dismissal":false,"text":"","timestamp":1749846740,"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":"12138037","event":"ball","batsman_id":"49421","bowler_id":"49747","over":"16","ball":"2","score":0,"commentary":"Jack Taylor to Lewis Gregory, no run,","noball_dismissal":false,"text":"","timestamp":1749846766,"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":"12138039","event":"ball","batsman_id":"49421","bowler_id":"49747","over":"16","ball":"3","score":0,"commentary":"Jack Taylor to Lewis Gregory, no run,","noball_dismissal":false,"text":"","timestamp":1749846779,"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":"12138040","event":"ball","batsman_id":"49421","bowler_id":"49747","over":"16","ball":"4","score":1,"commentary":"Jack Taylor to Lewis Gregory, 1 run,","noball_dismissal":false,"text":"","timestamp":1749846805,"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":"12138041","event":"ball","batsman_id":"103052","bowler_id":"49747","over":"16","ball":"5","score":0,"commentary":"Jack Taylor to Will Smeed, no run,","noball_dismissal":false,"text":"","timestamp":1749846817,"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":"12138043","event":"ball","batsman_id":"103052","bowler_id":"49747","over":"16","ball":"6","score":0,"commentary":"Jack Taylor to Will Smeed, no run,","noball_dismissal":false,"text":"","timestamp":1749846830,"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":7,"score":"125\/4","bats":[{"runs":51,"balls_faced":45,"fours":8,"sixes":1,"batsman_id":103052},{"runs":21,"balls_faced":13,"fours":1,"sixes":2,"batsman_id":49421}],"bowls":[{"runs_conceded":13,"maidens":0,"wickets":0,"bowler_id":49747,"overs":2},{"runs_conceded":15,"maidens":0,"wickets":1,"bowler_id":49526,"overs":4}],"commentary":"End of over 17 (7 runs), Somerset 125\/4"},{"event_id":"12138045","event":"ball","batsman_id":"49421","bowler_id":"101483","over":"17","ball":"1","score":0,"commentary":"Ajeet Singh Dale to Lewis Gregory, no run,","noball_dismissal":false,"text":"","timestamp":1749846893,"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":"12138047","event":"ball","batsman_id":"49421","bowler_id":"101483","over":"17","ball":"2","score":2,"commentary":"Ajeet Singh Dale to Lewis Gregory, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749846938,"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":"12138049","event":"ball","batsman_id":"49421","bowler_id":"101483","over":"17","ball":"3","score":6,"commentary":"Ajeet Singh Dale to Lewis Gregory, Six,","noball_dismissal":false,"text":"","timestamp":1749847014,"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":"12138050","event":"ball","batsman_id":"49421","bowler_id":"101483","over":"17","ball":"4","score":4,"commentary":"Ajeet Singh Dale to Lewis Gregory, Four,","noball_dismissal":false,"text":"","timestamp":1749847017,"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}],"day":"0","session":"0","live_inning":{"iid":198009,"number":2,"name":"Somerset Inning","short_name":"SOM Inning","status":2,"issuperover":"false","result":3,"batting_team_id":7010,"fielding_team_id":7017,"scores":"137\/4","scores_full":"137\/4 (17.4 ov)","fielder":[{"fielder_id":"50425","fielder_name":"James Bracey","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"49812","fielder_name":"Miles Hammond","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Sean Dickson","batsman_id":"49823","runs":"23","balls":"17","how_out":"b Z Akhter","score_at_dismissal":101,"overs_at_dismissal":"13.5","bowler_id":"110606","dismissal":"bowled","number":4},"extra_runs":{"byes":1,"legbyes":2,"wides":0,"noballs":0,"penalty":"0","total":3},"equations":{"runs":137,"wickets":4,"overs":"17.4","bowlers_used":6,"runrate":"7.75"},"current_partnership":{"runs":36,"balls":23,"overs":3.5,"batsmen":[{"name":"Lewis Gregory","batsman_id":49421,"runs":33,"balls":17},{"name":"Will Smeed","batsman_id":103052,"runs":3,"balls":6}]},"did_not_bat":[{"player_id":"1049","name":"Ben Green"},{"player_id":"95554","name":"Lewis Goldsworthy"},{"player_id":"49733","name":"Craig Overton"},{"player_id":"486","name":"Matt Henry"},{"player_id":"93329","name":"Riley Meredith"}],"max_over":"20","target":"136","recent_scores":"4,6,2,0,0,0,1,0,0,6,1,6,0,1,1,1,0,0","last_five_overs":"45\/1 9.00","last_ten_overs":"80\/2 8.00"},"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":"137\/4 (17.4 ov)","scores":"137\/4","overs":"17.4"},{"tid":7017,"title":"Gloucestershire","abbr":"GLO","alt_name":"GLO","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-GLO@2x.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-GLO@2x.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"135\/7 (20 ov)","scores":"135\/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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Scotland","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bowl","role_str":""},{"pid":847,"title":"Marchant de Lange","short_name":"MD Lange","first_name":"Marchant de Lange","last_name":"","middle_name":"","birthdate":"1990-10-13","birthplace":"Tzaneen, Limpopo","country":"za","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":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Marchant90","instagram_profile":"https:\/\/www.instagram.com\/marchant.delange\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","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":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"squad","role_str":""},{"pid":10606,"title":"Jake Ball","short_name":"JT Ball","first_name":"Jake Ball","last_name":"","middle_name":"","birthdate":"1991-03-14","birthplace":"Mansfield, Nottinghamshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":18974,"recent_appearance":1517109600,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/jakeball","instagram_profile":"https:\/\/www.instagram.com\/jakeball\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":16594,"title":"Matt Taylor","short_name":"MD Taylor","first_name":"Matt Taylor","last_name":"","middle_name":"","birthdate":"1994-07-08","birthplace":"Banbury, Oxfordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":43563,"title":"Cameron Bancroft","short_name":"CT Bancroft","first_name":"Cameron Bancroft","last_name":"","middle_name":"","birthdate":"1992-11-19","birthplace":" Attadale, Australia","country":"au","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper ","recent_match":18968,"recent_appearance":1514244600,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/cbancroft4\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"wk","role_str":""},{"pid":47533,"title":"Graeme van Buuren","short_name":"GL Buuren","first_name":"Graeme van Buuren","last_name":"","middle_name":"","birthdate":"1990-08-22","birthplace":"Pretoria, Transvaal","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/graemegvb\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":48656,"title":"Tom Kohler-Cadmore","short_name":"TK Cadmore","first_name":"Tom Kohler-Cadmore","last_name":"","middle_name":"","birthdate":"1994-08-19","birthplace":" Chatham, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/tomkholerCadmore32\/","twitter_profile":"https:\/\/twitter.com\/TomKCadmore32","instagram_profile":"https:\/\/www.instagram.com\/tomkcadmore","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":49015,"title":"Andrew Umeed","short_name":"ARI Umeed","first_name":"Andrew Umeed","last_name":"","middle_name":"","birthdate":"1996-04-19","birthplace":"Glasgow, Lanarkshire","country":"sct","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Scotland","role":"squad","role_str":""},{"pid":49413,"title":"Tom Abell","short_name":"TB Abell","first_name":"Tom Abell","last_name":"","middle_name":"","birthdate":"1994-03-05","birthplace":"Taunton, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/tomabell1","instagram_profile":"https:\/\/www.instagram.com\/tabell28\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":49421,"title":"Lewis Gregory","short_name":"L Gregory","first_name":"Lewis Gregory","last_name":"","middle_name":"","birthdate":"1992-05-24","birthplace":"Plymouth","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/lewisgregory23\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":"(C)"},{"pid":49425,"title":"Jack Leach","short_name":"J Leach","first_name":"Jack Leach","last_name":"","middle_name":"","birthdate":"1991-06-22","birthplace":" Taunton, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/jackleach1991?lang=gu","instagram_profile":"https:\/\/www.instagram.com\/mjleach17\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49519,"title":"Chris Dent","short_name":"CDJ Dent","first_name":"Chris Dent","last_name":"","middle_name":"","birthdate":"1991-01-20","birthplace":"Bristol","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"Occasional Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Cdent15","instagram_profile":"https:\/\/www.instagram.com\/chrisdent15\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49526,"title":"David Payne","short_name":"DA Payne","first_name":"David Payne","last_name":"","middle_name":"","birthdate":"1991-02-15","birthplace":"Poole, Dorset","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/DavidPayne_14","instagram_profile":"https:\/\/www.instagram.com\/sidpayne14\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":49733,"title":"Craig Overton","short_name":"C Overton","first_name":"Craig Overton","last_name":"","middle_name":"","birthdate":"1994-04-10","birthplace":"Barnstaple, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/craigoverton12","instagram_profile":"https:\/\/www.instagram.com\/craigoverton12\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":49747,"title":"Jack Taylor","short_name":"JMR Taylor","first_name":"Jack Taylor","last_name":"","middle_name":"","birthdate":"1991-11-12","birthplace":"Banbury, Oxfordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"pid":49812,"title":"Miles Hammond","short_name":"MAH Hammond","first_name":"Miles Hammond","last_name":"","middle_name":"","birthdate":"1996-01-11","birthplace":"Cheltenham, Gloucestershire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/milesAHH","instagram_profile":"https:\/\/www.instagram.com\/hammo_gram\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":49823,"title":"Sean Dickson","short_name":"SR Dickson","first_name":"Sean Dickson","last_name":"","middle_name":"","birthdate":"1991-09-02","birthplace":"Johannesburg, Transvaal","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bat","role_str":""},{"pid":50007,"title":"Josh Shaw","short_name":"J Shaw","first_name":"Josh Shaw","last_name":"","middle_name":"","birthdate":"1996-01-03","birthplace":"Wakefield, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/joshuashaw1","instagram_profile":"https:\/\/www.instagram.com\/joshshaw5931\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50425,"title":"James Bracey","short_name":"JR Bracey","first_name":"James Bracey","last_name":"","middle_name":"","birthdate":"1997-05-03","birthplace":"Bristol","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/james_bracey\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":51266,"title":"Tom Banton","short_name":"T Banton","first_name":"Tom Banton","last_name":"","middle_name":"","birthdate":"1998-11-11","birthplace":"Chiltern, Buckinghamshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/OfficialTomBanton\/","twitter_profile":"https:\/\/twitter.com\/tbanton18","instagram_profile":"https:\/\/www.instagram.com\/tombanton\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"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":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"https:\/\/www.facebook.com\/whatsmattrenshawthinking\/","twitter_profile":"https:\/\/twitter.com\/MattRenshaw449","instagram_profile":"https:\/\/www.instagram.com\/mattrenshaw449\/","debut_data":"","bowling_type":"Spin","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,"facebook_profile":"https:\/\/www.facebook.com\/migael27\/","twitter_profile":"https:\/\/twitter.com\/migael_27","instagram_profile":"https:\/\/www.instagram.com\/migael27\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":58686,"title":"Tom Smith","short_name":"TC Smith","first_name":"Tom Smith","last_name":"","middle_name":"","birthdate":"1987-08-29","birthplace":"Liverpool","country":"en","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/tmjsmith6\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":84301,"title":"D''Arcy Short","short_name":"DJM Short","first_name":"D''Arcy Short","last_name":"","middle_name":"","birthdate":"1990-08-09","birthplace":" Katherine, Northern Territory","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":18958,"recent_appearance":1517646000,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/shortyjnr23\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Australia","role":"all","role_str":""},{"pid":88692,"title":"Ben Charlesworth","short_name":"BG Charlesworth","first_name":"Ben Charlesworth","last_name":"","middle_name":"","birthdate":"2000-11-19","birthplace":"Oxford","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left 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":"https:\/\/www.instagram.com\/bencharlesworth_\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":93130,"title":"Cameron Green","short_name":"C Green","first_name":"Cameron Green","last_name":"","middle_name":"","birthdate":"1999-06-03","birthplace":"Perth, Australia","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/CameronGreen_","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"bowl","role_str":""},{"pid":93520,"title":"Tom Lammonby","short_name":"TA Lammonby","first_name":"Tom Lammonby","last_name":"","middle_name":"","birthdate":"2000-06-02","birthplace":" Exeter, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/TomLammonby","instagram_profile":"https:\/\/www.instagram.com\/tom_lammonby\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95478,"title":"Tom Price","short_name":"TJ Price","first_name":"Tom Price","last_name":"","middle_name":"","birthdate":"2000-01-02","birthplace":"Oxford, United Kingdom","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","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":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/kcaldridge5\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95554,"title":"Lewis Goldsworthy","short_name":"L Goldsworthy","first_name":"Lewis Goldsworthy","last_name":"","middle_name":"","birthdate":"2001-01-08","birthplace":" Cornwall","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lewigoldsworthy","instagram_profile":"https:\/\/www.instagram.com\/lewisgoldsworthy\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":101483,"title":"Ajeet Singh Dale","short_name":"Ajeet Singh Dale","first_name":"Ajeet Singh Dale","last_name":"","middle_name":"","birthdate":"2000-07-02","birthplace":"","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":"","bowling_type":"Pace","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":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/will_smeed","instagram_profile":"https:\/\/www.instagram.com\/willsmeed\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":107311,"title":"Dominic Goodman","short_name":"DC Goodman","first_name":"Dominic Goodman","last_name":"","middle_name":"","birthdate":"2000-10-23","birthplace":"Ashford, Kent","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/domgoodman_\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":107312,"title":"Ollie Price","short_name":"O Price","first_name":"Ollie Price","last_name":"","middle_name":"","birthdate":"2001-06-12","birthplace":"Oxford","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":108408,"title":"James Rew","short_name":"J Rew","first_name":"James Rew","last_name":"","middle_name":"","birthdate":"2004-01-11","birthplace":" London","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/cjrew89\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108410,"title":"Joshua Thomas","short_name":"J Thomas","first_name":"Joshua Thomas","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":110606,"title":"Zaman Akhter","short_name":"Z Akhter","first_name":"Zaman Akhter","last_name":"","middle_name":"","birthdate":"1999-03-12","birthplace":"Cambridge","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":116662,"title":"Luke Charlesworth","short_name":"LA Charlesworth","first_name":"Luke Charlesworth","last_name":"","middle_name":"","birthdate":"2003-04-04","birthplace":"Oxford","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":118935,"title":"Tommy Boorman","short_name":"Tommy Boorman","first_name":"Tommy Boorman","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":127440,"title":"Joe Phillips","short_name":"JP Phillips","first_name":"Joe Phillips","last_name":"","middle_name":"","birthdate":"2003-11-09","birthplace":"Truro, Cornwall","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":129894,"title":"JT Langridge","short_name":"JT Langridge","first_name":"JT Langridge","last_name":"","middle_name":"","birthdate":"2005-11-03","birthplace":" Plymouth, Devon,","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":130425,"title":"Finley Hill","short_name":"F Hill","first_name":"Finley Hill","last_name":"","middle_name":"","birthdate":"2006-06-21","birthplace":" Exeter, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":130759,"title":"Ahmed Mujtaba Syed","short_name":"A Mujtaba Syed","first_name":"Ahmed Mujtaba Syed","last_name":"","middle_name":"","birthdate":"2004-09-26","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":130760,"title":"Edward Middleton","short_name":"Ed Middleton","first_name":"Edward Middleton","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":137372,"title":"Archie Vaughan","short_name":"A Vaughan","first_name":"Archie Vaughan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":139986,"title":"Archie Bailey","short_name":"A Bailey","first_name":"Archie Bailey","last_name":"","middle_name":"","birthdate":"2005-06-28","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":149124,"title":"Aman Rao","short_name":"Aman Rao","first_name":"Aman Rao","last_name":"","middle_name":"","birthdate":"2004-06-22","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""}]},"etag":"5a38e2357dca2eb02637570af867822a","modified":"2025-07-30 17:14:20","datetime":"2025-07-30 17:14:20","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":86863,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Somerset won by 6 wickets","day_remaining_over":"","team_batting":"Somerset","team_bowling":"Gloucestershire","live_inning_number":2,"live_score":{"runs":137,"overs":17.4,"wickets":4,"target":136,"runrate":7.75,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Lewis Gregory","batsman_id":49421,"runs":33,"balls_faced":17,"fours":2,"sixes":3,"strike_rate":"194.12"},{"name":"Will Smeed","batsman_id":103052,"runs":51,"balls_faced":45,"fours":8,"sixes":1,"strike_rate":"113.33"}],"bowlers":[{"name":"Ajeet Singh Dale","bowler_id":101483,"overs":3.4,"runs_conceded":31,"wickets":1,"maidens":0,"econ":"8.45"},{"name":"Jack Taylor","bowler_id":49747,"overs":2,"runs_conceded":13,"wickets":0,"maidens":0,"econ":"6.50"}],"commentaries":[{"event_id":"12137960","event":"ball","batsman_id":"49823","bowler_id":"110606","over":"13","ball":"2","score":1,"commentary":"Zaman Akhter to Sean Dickson, 1 run,","noball_dismissal":false,"text":"","timestamp":1749846171,"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":"12137962","event":"ball","batsman_id":"103052","bowler_id":"110606","over":"13","ball":"3","score":4,"commentary":"Zaman Akhter to Will Smeed, Four,","noball_dismissal":false,"text":"","timestamp":1749846072,"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":"12137969","event":"ball","batsman_id":"103052","bowler_id":"110606","over":"13","ball":"4","score":1,"commentary":"Zaman Akhter to Will Smeed, 1 run,","noball_dismissal":false,"text":"","timestamp":1749846098,"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":"12137973","event":"wicket","batsman_id":"49823","bowler_id":"110606","over":"13","ball":"5","score":"w","commentary":"Zaman Akhter to Sean Dickson, no run, b Z Akhter,","noball_dismissal":false,"text":"","timestamp":1749846187,"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":"49823","how_out":"b Z Akhter","batsman_runs":"23","batsman_balls":"17"},{"event_id":"12137983","event":"ball","batsman_id":"49421","bowler_id":"110606","over":"13","ball":"6","score":1,"commentary":"Zaman Akhter to Lewis Gregory, 1 run,","noball_dismissal":false,"text":"","timestamp":1749846246,"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":14,"runs":9,"score":"102\/4","bats":[{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":49421},{"runs":48,"balls_faced":39,"fours":8,"sixes":1,"batsman_id":103052}],"bowls":[{"runs_conceded":25,"maidens":0,"wickets":1,"bowler_id":110606,"overs":2},{"runs_conceded":28,"maidens":0,"wickets":1,"bowler_id":84301,"overs":4}],"commentary":"End of over 14 (9 runs), Somerset 102\/4"},{"event_id":"12137988","event":"ball","batsman_id":"49421","bowler_id":"49747","over":"14","ball":"1","score":4,"commentary":"Jack Taylor to Lewis Gregory, Four,","noball_dismissal":false,"text":"","timestamp":1749846286,"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":"12137990","event":"ball","batsman_id":"49421","bowler_id":"49747","over":"14","ball":"2","score":1,"commentary":"Jack Taylor to Lewis Gregory, 1 run,","noball_dismissal":false,"text":"","timestamp":1749846299,"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":"12137995","event":"ball","batsman_id":"103052","bowler_id":"49747","over":"14","ball":"3","score":0,"commentary":"Jack Taylor to Will Smeed, no run,","noball_dismissal":false,"text":"","timestamp":1749846317,"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":"12137997","event":"ball","batsman_id":"103052","bowler_id":"49747","over":"14","ball":"4","score":1,"commentary":"Jack Taylor to Will Smeed, 1 run,","noball_dismissal":false,"text":"","timestamp":1749846333,"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":"12138000","event":"ball","batsman_id":"49421","bowler_id":"49747","over":"14","ball":"5","score":0,"commentary":"Jack Taylor to Lewis Gregory, no run,","noball_dismissal":false,"text":"","timestamp":1749846351,"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":"12138001","event":"ball","batsman_id":"49421","bowler_id":"49747","over":"14","ball":"6","score":0,"commentary":"Jack Taylor to Lewis Gregory, no run,","noball_dismissal":false,"text":"","timestamp":1749846361,"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":15,"runs":6,"score":"108\/4","bats":[{"runs":6,"balls_faced":5,"fours":1,"sixes":0,"batsman_id":49421},{"runs":49,"balls_faced":41,"fours":8,"sixes":1,"batsman_id":103052}],"bowls":[{"runs_conceded":6,"maidens":0,"wickets":0,"bowler_id":49747,"overs":1},{"runs_conceded":25,"maidens":0,"wickets":1,"bowler_id":110606,"overs":2}],"commentary":"End of over 15 (6 runs), Somerset 108\/4"},{"event_id":"12138013","event":"ball","batsman_id":"103052","bowler_id":"49526","over":"15","ball":"1","score":1,"commentary":"David Payne to Will Smeed, 1 run,","noball_dismissal":false,"text":"","timestamp":1749846489,"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":"12138015","event":"ball","batsman_id":"49421","bowler_id":"49526","over":"15","ball":"2","score":1,"commentary":"David Payne to Lewis Gregory, 1 run,","noball_dismissal":false,"text":"","timestamp":1749846492,"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":"12138018","event":"ball","batsman_id":"103052","bowler_id":"49526","over":"15","ball":"3","score":1,"commentary":"David Payne to Will Smeed, 1 run,","noball_dismissal":false,"text":"","timestamp":1749846519,"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":"12138025","event":"ball","batsman_id":"49421","bowler_id":"49526","over":"15","ball":"4","score":0,"commentary":"David Payne to Lewis Gregory, no run,","noball_dismissal":false,"text":"","timestamp":1749846552,"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":"12138029","event":"ball","batsman_id":"49421","bowler_id":"49526","over":"15","ball":"5","score":6,"commentary":"David Payne to Lewis Gregory, Six,","noball_dismissal":false,"text":"","timestamp":1749846584,"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":"12138032","event":"ball","batsman_id":"49421","bowler_id":"49526","over":"15","ball":"6","score":1,"commentary":"David Payne to Lewis Gregory, 1 run,","noball_dismissal":false,"text":"","timestamp":1749846671,"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":10,"score":"118\/4","bats":[{"runs":14,"balls_faced":9,"fours":1,"sixes":1,"batsman_id":49421},{"runs":51,"balls_faced":43,"fours":8,"sixes":1,"batsman_id":103052}],"bowls":[{"runs_conceded":15,"maidens":0,"wickets":1,"bowler_id":49526,"overs":4},{"runs_conceded":6,"maidens":0,"wickets":0,"bowler_id":49747,"overs":1}],"commentary":"End of over 16 (10 runs), Somerset 118\/4"},{"event_id":"12138036","event":"ball","batsman_id":"49421","bowler_id":"49747","over":"16","ball":"1","score":6,"commentary":"Jack Taylor to Lewis Gregory, Six,","noball_dismissal":false,"text":"","timestamp":1749846740,"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":"12138037","event":"ball","batsman_id":"49421","bowler_id":"49747","over":"16","ball":"2","score":0,"commentary":"Jack Taylor to Lewis Gregory, no run,","noball_dismissal":false,"text":"","timestamp":1749846766,"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":"12138039","event":"ball","batsman_id":"49421","bowler_id":"49747","over":"16","ball":"3","score":0,"commentary":"Jack Taylor to Lewis Gregory, no run,","noball_dismissal":false,"text":"","timestamp":1749846779,"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":"12138040","event":"ball","batsman_id":"49421","bowler_id":"49747","over":"16","ball":"4","score":1,"commentary":"Jack Taylor to Lewis Gregory, 1 run,","noball_dismissal":false,"text":"","timestamp":1749846805,"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":"12138041","event":"ball","batsman_id":"103052","bowler_id":"49747","over":"16","ball":"5","score":0,"commentary":"Jack Taylor to Will Smeed, no run,","noball_dismissal":false,"text":"","timestamp":1749846817,"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":"12138043","event":"ball","batsman_id":"103052","bowler_id":"49747","over":"16","ball":"6","score":0,"commentary":"Jack Taylor to Will Smeed, no run,","noball_dismissal":false,"text":"","timestamp":1749846830,"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":7,"score":"125\/4","bats":[{"runs":51,"balls_faced":45,"fours":8,"sixes":1,"batsman_id":103052},{"runs":21,"balls_faced":13,"fours":1,"sixes":2,"batsman_id":49421}],"bowls":[{"runs_conceded":13,"maidens":0,"wickets":0,"bowler_id":49747,"overs":2},{"runs_conceded":15,"maidens":0,"wickets":1,"bowler_id":49526,"overs":4}],"commentary":"End of over 17 (7 runs), Somerset 125\/4"},{"event_id":"12138045","event":"ball","batsman_id":"49421","bowler_id":"101483","over":"17","ball":"1","score":0,"commentary":"Ajeet Singh Dale to Lewis Gregory, no run,","noball_dismissal":false,"text":"","timestamp":1749846893,"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":"12138047","event":"ball","batsman_id":"49421","bowler_id":"101483","over":"17","ball":"2","score":2,"commentary":"Ajeet Singh Dale to Lewis Gregory, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749846938,"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":"12138049","event":"ball","batsman_id":"49421","bowler_id":"101483","over":"17","ball":"3","score":6,"commentary":"Ajeet Singh Dale to Lewis Gregory, Six,","noball_dismissal":false,"text":"","timestamp":1749847014,"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":"12138050","event":"ball","batsman_id":"49421","bowler_id":"101483","over":"17","ball":"4","score":4,"commentary":"Ajeet Singh Dale to Lewis Gregory, Four,","noball_dismissal":false,"text":"","timestamp":1749847017,"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}],"day":"0","session":"0","live_inning":{"iid":198009,"number":2,"name":"Somerset Inning","short_name":"SOM Inning","status":2,"issuperover":"false","result":3,"batting_team_id":7010,"fielding_team_id":7017,"scores":"137\/4","scores_full":"137\/4 (17.4 ov)","fielder":[{"fielder_id":"50425","fielder_name":"James Bracey","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"49812","fielder_name":"Miles Hammond","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Sean Dickson","batsman_id":"49823","runs":"23","balls":"17","how_out":"b Z Akhter","score_at_dismissal":101,"overs_at_dismissal":"13.5","bowler_id":"110606","dismissal":"bowled","number":4},"extra_runs":{"byes":1,"legbyes":2,"wides":0,"noballs":0,"penalty":"0","total":3},"equations":{"runs":137,"wickets":4,"overs":"17.4","bowlers_used":6,"runrate":"7.75"},"current_partnership":{"runs":36,"balls":23,"overs":3.5,"batsmen":[{"name":"Lewis Gregory","batsman_id":49421,"runs":33,"balls":17},{"name":"Will Smeed","batsman_id":103052,"runs":3,"balls":6}]},"did_not_bat":[{"player_id":"1049","name":"Ben Green"},{"player_id":"95554","name":"Lewis Goldsworthy"},{"player_id":"49733","name":"Craig Overton"},{"player_id":"486","name":"Matt Henry"},{"player_id":"93329","name":"Riley Meredith"}],"max_over":"20","target":"136","recent_scores":"4,6,2,0,0,0,1,0,0,6,1,6,0,1,1,1,0,0","last_five_overs":"45\/1 9.00","last_ten_overs":"80\/2 8.00"},"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":"137\/4 (17.4 ov)","scores":"137\/4","overs":"17.4"},{"tid":7017,"title":"Gloucestershire","abbr":"GLO","alt_name":"GLO","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-GLO@2x.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-GLO@2x.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"135\/7 (20 ov)","scores":"135\/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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Scotland","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bowl","role_str":""},{"pid":847,"title":"Marchant de Lange","short_name":"MD Lange","first_name":"Marchant de Lange","last_name":"","middle_name":"","birthdate":"1990-10-13","birthplace":"Tzaneen, Limpopo","country":"za","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":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Marchant90","instagram_profile":"https:\/\/www.instagram.com\/marchant.delange\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","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":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"squad","role_str":""},{"pid":10606,"title":"Jake Ball","short_name":"JT Ball","first_name":"Jake Ball","last_name":"","middle_name":"","birthdate":"1991-03-14","birthplace":"Mansfield, Nottinghamshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":18974,"recent_appearance":1517109600,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/jakeball","instagram_profile":"https:\/\/www.instagram.com\/jakeball\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":16594,"title":"Matt Taylor","short_name":"MD Taylor","first_name":"Matt Taylor","last_name":"","middle_name":"","birthdate":"1994-07-08","birthplace":"Banbury, Oxfordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":43563,"title":"Cameron Bancroft","short_name":"CT Bancroft","first_name":"Cameron Bancroft","last_name":"","middle_name":"","birthdate":"1992-11-19","birthplace":" Attadale, Australia","country":"au","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper ","recent_match":18968,"recent_appearance":1514244600,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/cbancroft4\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"wk","role_str":""},{"pid":47533,"title":"Graeme van Buuren","short_name":"GL Buuren","first_name":"Graeme van Buuren","last_name":"","middle_name":"","birthdate":"1990-08-22","birthplace":"Pretoria, Transvaal","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/graemegvb\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":48656,"title":"Tom Kohler-Cadmore","short_name":"TK Cadmore","first_name":"Tom Kohler-Cadmore","last_name":"","middle_name":"","birthdate":"1994-08-19","birthplace":" Chatham, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/tomkholerCadmore32\/","twitter_profile":"https:\/\/twitter.com\/TomKCadmore32","instagram_profile":"https:\/\/www.instagram.com\/tomkcadmore","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":49015,"title":"Andrew Umeed","short_name":"ARI Umeed","first_name":"Andrew Umeed","last_name":"","middle_name":"","birthdate":"1996-04-19","birthplace":"Glasgow, Lanarkshire","country":"sct","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Scotland","role":"squad","role_str":""},{"pid":49413,"title":"Tom Abell","short_name":"TB Abell","first_name":"Tom Abell","last_name":"","middle_name":"","birthdate":"1994-03-05","birthplace":"Taunton, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/tomabell1","instagram_profile":"https:\/\/www.instagram.com\/tabell28\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":49421,"title":"Lewis Gregory","short_name":"L Gregory","first_name":"Lewis Gregory","last_name":"","middle_name":"","birthdate":"1992-05-24","birthplace":"Plymouth","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/lewisgregory23\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":"(C)"},{"pid":49425,"title":"Jack Leach","short_name":"J Leach","first_name":"Jack Leach","last_name":"","middle_name":"","birthdate":"1991-06-22","birthplace":" Taunton, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/jackleach1991?lang=gu","instagram_profile":"https:\/\/www.instagram.com\/mjleach17\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49519,"title":"Chris Dent","short_name":"CDJ Dent","first_name":"Chris Dent","last_name":"","middle_name":"","birthdate":"1991-01-20","birthplace":"Bristol","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"Occasional Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Cdent15","instagram_profile":"https:\/\/www.instagram.com\/chrisdent15\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49526,"title":"David Payne","short_name":"DA Payne","first_name":"David Payne","last_name":"","middle_name":"","birthdate":"1991-02-15","birthplace":"Poole, Dorset","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/DavidPayne_14","instagram_profile":"https:\/\/www.instagram.com\/sidpayne14\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":49733,"title":"Craig Overton","short_name":"C Overton","first_name":"Craig Overton","last_name":"","middle_name":"","birthdate":"1994-04-10","birthplace":"Barnstaple, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/craigoverton12","instagram_profile":"https:\/\/www.instagram.com\/craigoverton12\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":49747,"title":"Jack Taylor","short_name":"JMR Taylor","first_name":"Jack Taylor","last_name":"","middle_name":"","birthdate":"1991-11-12","birthplace":"Banbury, Oxfordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"pid":49812,"title":"Miles Hammond","short_name":"MAH Hammond","first_name":"Miles Hammond","last_name":"","middle_name":"","birthdate":"1996-01-11","birthplace":"Cheltenham, Gloucestershire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/milesAHH","instagram_profile":"https:\/\/www.instagram.com\/hammo_gram\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":49823,"title":"Sean Dickson","short_name":"SR Dickson","first_name":"Sean Dickson","last_name":"","middle_name":"","birthdate":"1991-09-02","birthplace":"Johannesburg, Transvaal","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bat","role_str":""},{"pid":50007,"title":"Josh Shaw","short_name":"J Shaw","first_name":"Josh Shaw","last_name":"","middle_name":"","birthdate":"1996-01-03","birthplace":"Wakefield, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/joshuashaw1","instagram_profile":"https:\/\/www.instagram.com\/joshshaw5931\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50425,"title":"James Bracey","short_name":"JR Bracey","first_name":"James Bracey","last_name":"","middle_name":"","birthdate":"1997-05-03","birthplace":"Bristol","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/james_bracey\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":51266,"title":"Tom Banton","short_name":"T Banton","first_name":"Tom Banton","last_name":"","middle_name":"","birthdate":"1998-11-11","birthplace":"Chiltern, Buckinghamshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/OfficialTomBanton\/","twitter_profile":"https:\/\/twitter.com\/tbanton18","instagram_profile":"https:\/\/www.instagram.com\/tombanton\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"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":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"https:\/\/www.facebook.com\/whatsmattrenshawthinking\/","twitter_profile":"https:\/\/twitter.com\/MattRenshaw449","instagram_profile":"https:\/\/www.instagram.com\/mattrenshaw449\/","debut_data":"","bowling_type":"Spin","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,"facebook_profile":"https:\/\/www.facebook.com\/migael27\/","twitter_profile":"https:\/\/twitter.com\/migael_27","instagram_profile":"https:\/\/www.instagram.com\/migael27\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":58686,"title":"Tom Smith","short_name":"TC Smith","first_name":"Tom Smith","last_name":"","middle_name":"","birthdate":"1987-08-29","birthplace":"Liverpool","country":"en","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/tmjsmith6\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":84301,"title":"D''Arcy Short","short_name":"DJM Short","first_name":"D''Arcy Short","last_name":"","middle_name":"","birthdate":"1990-08-09","birthplace":" Katherine, Northern Territory","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":18958,"recent_appearance":1517646000,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/shortyjnr23\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Australia","role":"all","role_str":""},{"pid":88692,"title":"Ben Charlesworth","short_name":"BG Charlesworth","first_name":"Ben Charlesworth","last_name":"","middle_name":"","birthdate":"2000-11-19","birthplace":"Oxford","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left 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":"https:\/\/www.instagram.com\/bencharlesworth_\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":93130,"title":"Cameron Green","short_name":"C Green","first_name":"Cameron Green","last_name":"","middle_name":"","birthdate":"1999-06-03","birthplace":"Perth, Australia","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/CameronGreen_","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"bowl","role_str":""},{"pid":93520,"title":"Tom Lammonby","short_name":"TA Lammonby","first_name":"Tom Lammonby","last_name":"","middle_name":"","birthdate":"2000-06-02","birthplace":" Exeter, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/TomLammonby","instagram_profile":"https:\/\/www.instagram.com\/tom_lammonby\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95478,"title":"Tom Price","short_name":"TJ Price","first_name":"Tom Price","last_name":"","middle_name":"","birthdate":"2000-01-02","birthplace":"Oxford, United Kingdom","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","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":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/kcaldridge5\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95554,"title":"Lewis Goldsworthy","short_name":"L Goldsworthy","first_name":"Lewis Goldsworthy","last_name":"","middle_name":"","birthdate":"2001-01-08","birthplace":" Cornwall","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lewigoldsworthy","instagram_profile":"https:\/\/www.instagram.com\/lewisgoldsworthy\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":101483,"title":"Ajeet Singh Dale","short_name":"Ajeet Singh Dale","first_name":"Ajeet Singh Dale","last_name":"","middle_name":"","birthdate":"2000-07-02","birthplace":"","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":"","bowling_type":"Pace","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":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/will_smeed","instagram_profile":"https:\/\/www.instagram.com\/willsmeed\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":107311,"title":"Dominic Goodman","short_name":"DC Goodman","first_name":"Dominic Goodman","last_name":"","middle_name":"","birthdate":"2000-10-23","birthplace":"Ashford, Kent","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/domgoodman_\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":107312,"title":"Ollie Price","short_name":"O Price","first_name":"Ollie Price","last_name":"","middle_name":"","birthdate":"2001-06-12","birthplace":"Oxford","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":108408,"title":"James Rew","short_name":"J Rew","first_name":"James Rew","last_name":"","middle_name":"","birthdate":"2004-01-11","birthplace":" London","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/cjrew89\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108410,"title":"Joshua Thomas","short_name":"J Thomas","first_name":"Joshua Thomas","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":110606,"title":"Zaman Akhter","short_name":"Z Akhter","first_name":"Zaman Akhter","last_name":"","middle_name":"","birthdate":"1999-03-12","birthplace":"Cambridge","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":116662,"title":"Luke Charlesworth","short_name":"LA Charlesworth","first_name":"Luke Charlesworth","last_name":"","middle_name":"","birthdate":"2003-04-04","birthplace":"Oxford","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":118935,"title":"Tommy Boorman","short_name":"Tommy Boorman","first_name":"Tommy Boorman","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":127440,"title":"Joe Phillips","short_name":"JP Phillips","first_name":"Joe Phillips","last_name":"","middle_name":"","birthdate":"2003-11-09","birthplace":"Truro, Cornwall","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":129894,"title":"JT Langridge","short_name":"JT Langridge","first_name":"JT Langridge","last_name":"","middle_name":"","birthdate":"2005-11-03","birthplace":" Plymouth, Devon,","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":130425,"title":"Finley Hill","short_name":"F Hill","first_name":"Finley Hill","last_name":"","middle_name":"","birthdate":"2006-06-21","birthplace":" Exeter, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":130759,"title":"Ahmed Mujtaba Syed","short_name":"A Mujtaba Syed","first_name":"Ahmed Mujtaba Syed","last_name":"","middle_name":"","birthdate":"2004-09-26","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":130760,"title":"Edward Middleton","short_name":"Ed Middleton","first_name":"Edward Middleton","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":137372,"title":"Archie Vaughan","short_name":"A Vaughan","first_name":"Archie Vaughan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":139986,"title":"Archie Bailey","short_name":"A Bailey","first_name":"Archie Bailey","last_name":"","middle_name":"","birthdate":"2005-06-28","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":149124,"title":"Aman Rao","short_name":"Aman Rao","first_name":"Aman Rao","last_name":"","middle_name":"","birthdate":"2004-06-22","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""}]},"etag":"5a38e2357dca2eb02637570af867822a","modified":"2025-07-30 17:14:20","datetime":"2025-07-30 17:14:20","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86863 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:cd234670-a342-45a0-b84d-ef37474ae9cb
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86863 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86863,3,'{"status":"ok","response":{"match_id":86863,"title":"Gloucestershire vs Somerset","short_title":"GLO vs SOM","subtitle":"Match 43","match_number":"43","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Somerset won by 6 wickets","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":7017,"name":"Gloucestershire","short_name":"GLO","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-GLO@2x.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-GLO@2x.png","scores_full":"135\/7 (20 ov)","scores":"135\/7","overs":"20"},"teamb":{"team_id":7010,"name":"Somerset","short_name":"SOM","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/somerset-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/somerset-logo.png","scores_full":"137\/4 (17.4 ov)","scores":"137\/4","overs":"17.4"},"date_start":"2025-06-13 18:00:00","date_end":"2025-06-14 04:00:00","timestamp_start":1749837600,"timestamp_end":1749873600,"date_start_ist":"2025-06-13 23:30:00","date_end_ist":"2025-06-14 09:30:00","venue":{"venue_id":"38","name":"County Ground, Bristol","location":"Bristol","country":"England","timezone":""},"umpires":"Paul Pollard (England), Mike Burns (England)","referee":"Simon Hinks (England)","equation":"","live":"","result":"SOM won by 6 wickets","result_type":2,"win_margin":"6 wickets","winning_team_id":7010,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-12 22:13:40","verify_time":"2025-06-14 02:41:08","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":17.82,"humidity":80,"visibility":10000,"wind_speed":"2.13","clouds":100},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Somerset elected to bowl","winner":7010,"decision":2}},"etag":"5a38e2357dca2eb02637570af867822a","modified":"2025-07-30 17:14:20","datetime":"2025-07-30 17:14:20","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":86863,"title":"Gloucestershire vs Somerset","short_title":"GLO vs SOM","subtitle":"Match 43","match_number":"43","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Somerset won by 6 wickets","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":7017,"name":"Gloucestershire","short_name":"GLO","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-GLO@2x.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-GLO@2x.png","scores_full":"135\/7 (20 ov)","scores":"135\/7","overs":"20"},"teamb":{"team_id":7010,"name":"Somerset","short_name":"SOM","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/somerset-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/somerset-logo.png","scores_full":"137\/4 (17.4 ov)","scores":"137\/4","overs":"17.4"},"date_start":"2025-06-13 18:00:00","date_end":"2025-06-14 04:00:00","timestamp_start":1749837600,"timestamp_end":1749873600,"date_start_ist":"2025-06-13 23:30:00","date_end_ist":"2025-06-14 09:30:00","venue":{"venue_id":"38","name":"County Ground, Bristol","location":"Bristol","country":"England","timezone":""},"umpires":"Paul Pollard (England), Mike Burns (England)","referee":"Simon Hinks (England)","equation":"","live":"","result":"SOM won by 6 wickets","result_type":2,"win_margin":"6 wickets","winning_team_id":7010,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-12 22:13:40","verify_time":"2025-06-14 02:41:08","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":17.82,"humidity":80,"visibility":10000,"wind_speed":"2.13","clouds":100},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Somerset elected to bowl","winner":7010,"decision":2}},"etag":"5a38e2357dca2eb02637570af867822a","modified":"2025-07-30 17:14:20","datetime":"2025-07-30 17:14:20","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86863 AND DataTypeId = 3 END Live Report & Scorecard of Gloucestershire vs Somerset Match 43