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:d8a2c097-c431-4da8-bf9b-365b10a3899f
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 88135 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (88135,1,'{"status":"ok","response":{"mid":88135,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Match Drawn","day_remaining_over":"7.5","team_batting":"Warwickshire","team_bowling":"Somerset","live_inning_number":4,"live_score":{"runs":161,"overs":56,"wickets":4,"target":378,"runrate":2.88,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Sam Hain","batsman_id":49025,"runs":68,"balls_faced":157,"fours":9,"sixes":1,"strike_rate":"43.31"},{"name":"Ed Barnard","batsman_id":49041,"runs":11,"balls_faced":30,"fours":2,"sixes":0,"strike_rate":"36.67"}],"bowlers":[{"name":"Jack Leach","bowler_id":49425,"overs":19,"runs_conceded":49,"wickets":1,"maidens":3,"econ":"2.58"},{"name":"Matt Henry","bowler_id":486,"overs":8,"runs_conceded":25,"wickets":1,"maidens":1,"econ":"3.13"}],"commentaries":[{"event_id":"12226734","event":"ball","batsman_id":"49025","bowler_id":"57592","over":"51","ball":"5","score":0,"commentary":"Migael Pretorius to Sam Hain, no run,","noball_dismissal":false,"text":"","timestamp":1750868562,"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":"12226750","event":"ball","batsman_id":"49025","bowler_id":"57592","over":"51","ball":"6","score":0,"commentary":"Migael Pretorius to Sam Hain, no run,","noball_dismissal":false,"text":"","timestamp":1750868691,"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":52,"runs":2,"score":"154\/4","bats":[{"runs":63,"balls_faced":145,"fours":9,"sixes":1,"batsman_id":49025},{"runs":9,"balls_faced":18,"fours":2,"sixes":0,"batsman_id":49041}],"bowls":[{"runs_conceded":40,"maidens":1,"wickets":1,"bowler_id":57592,"overs":11},{"runs_conceded":21,"maidens":0,"wickets":1,"bowler_id":486,"overs":6}],"commentary":"End of over 52 (2 runs), Warwickshire 154\/4"},{"event_id":"12226756","event":"ball","batsman_id":"49041","bowler_id":"486","over":"52","ball":"1","score":0,"commentary":"Matt Henry to Ed Barnard, no run,","noball_dismissal":false,"text":"","timestamp":1750868694,"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":"12226759","event":"ball","batsman_id":"49041","bowler_id":"486","over":"52","ball":"2","score":0,"commentary":"Matt Henry to Ed Barnard, no run,","noball_dismissal":false,"text":"","timestamp":1750868727,"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":"12226765","event":"ball","batsman_id":"49041","bowler_id":"486","over":"52","ball":"3","score":0,"commentary":"Matt Henry to Ed Barnard, no run,","noball_dismissal":false,"text":"","timestamp":1750868760,"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":"12226766","event":"ball","batsman_id":"49041","bowler_id":"486","over":"52","ball":"4","score":0,"commentary":"Matt Henry to Ed Barnard, no run,","noball_dismissal":false,"text":"","timestamp":1750868764,"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":"12226775","event":"ball","batsman_id":"49041","bowler_id":"486","over":"52","ball":"5","score":0,"commentary":"Matt Henry to Ed Barnard, no run,","noball_dismissal":false,"text":"","timestamp":1750868815,"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":"12226780","event":"ball","batsman_id":"49041","bowler_id":"486","over":"52","ball":"6","score":0,"commentary":"Matt Henry to Ed Barnard, no run,","noball_dismissal":false,"text":"","timestamp":1750868888,"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":53,"runs":0,"score":"154\/4","bats":[{"runs":9,"balls_faced":24,"fours":2,"sixes":0,"batsman_id":49041},{"runs":63,"balls_faced":145,"fours":9,"sixes":1,"batsman_id":49025}],"bowls":[{"runs_conceded":21,"maidens":1,"wickets":1,"bowler_id":486,"overs":7},{"runs_conceded":40,"maidens":1,"wickets":1,"bowler_id":57592,"overs":11}],"commentary":"End of over 53 (0 runs), Warwickshire 154\/4"},{"event_id":"12226791","event":"ball","batsman_id":"49025","bowler_id":"49425","over":"53","ball":"1","score":0,"commentary":"Jack Leach to Sam Hain, no run,","noball_dismissal":false,"text":"","timestamp":1750868991,"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":"12226792","event":"ball","batsman_id":"49025","bowler_id":"49425","over":"53","ball":"2","score":0,"commentary":"Jack Leach to Sam Hain, no run,","noball_dismissal":false,"text":"","timestamp":1750868996,"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":"12226795","event":"ball","batsman_id":"49025","bowler_id":"49425","over":"53","ball":"3","score":0,"commentary":"Jack Leach to Sam Hain, no run,","noball_dismissal":false,"text":"","timestamp":1750869150,"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":"12226797","event":"ball","batsman_id":"49025","bowler_id":"49425","over":"53","ball":"4","score":0,"commentary":"Jack Leach to Sam Hain, no run,","noball_dismissal":false,"text":"","timestamp":1750869153,"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":"12226803","event":"ball","batsman_id":"49025","bowler_id":"49425","over":"53","ball":"5","score":1,"commentary":"Jack Leach to Sam Hain, 1 run,","noball_dismissal":false,"text":"","timestamp":1750869193,"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":"12226805","event":"ball","batsman_id":"49041","bowler_id":"49425","over":"53","ball":"6","score":0,"commentary":"Jack Leach to Ed Barnard, no run,","noball_dismissal":false,"text":"","timestamp":1750869197,"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":54,"runs":1,"score":"155\/4","bats":[{"runs":9,"balls_faced":25,"fours":2,"sixes":0,"batsman_id":49041},{"runs":64,"balls_faced":150,"fours":9,"sixes":1,"batsman_id":49025}],"bowls":[{"runs_conceded":47,"maidens":3,"wickets":1,"bowler_id":49425,"overs":18},{"runs_conceded":21,"maidens":1,"wickets":1,"bowler_id":486,"overs":7}],"commentary":"End of over 54 (1 runs), Warwickshire 155\/4"},{"event_id":"12226806","event":"ball","batsman_id":"49025","bowler_id":"486","over":"54","ball":"1","score":0,"commentary":"Matt Henry to Sam Hain, no run,","noball_dismissal":false,"text":"","timestamp":1750869200,"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":"12226807","event":"ball","batsman_id":"49025","bowler_id":"486","over":"54","ball":"2","score":0,"commentary":"Matt Henry to Sam Hain, no run,","noball_dismissal":false,"text":"","timestamp":1750869203,"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":"12226808","event":"ball","batsman_id":"49025","bowler_id":"486","over":"54","ball":"3","score":0,"commentary":"Matt Henry to Sam Hain, no run,","noball_dismissal":false,"text":"","timestamp":1750869213,"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":"12226840","event":"ball","batsman_id":"49025","bowler_id":"486","over":"54","ball":"4","score":0,"commentary":"Matt Henry to Sam Hain, no run,","noball_dismissal":false,"text":"","timestamp":1750869341,"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":"12226841","event":"ball","batsman_id":"49025","bowler_id":"486","over":"54","ball":"5","score":3,"commentary":"Matt Henry to Sam Hain, 3 runs,","noball_dismissal":false,"text":"","timestamp":1750869345,"run":3,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"3","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12226842","event":"ball","batsman_id":"49041","bowler_id":"486","over":"54","ball":"6","score":1,"commentary":"Matt Henry to Ed Barnard, 1 run,","noball_dismissal":false,"text":"","timestamp":1750869348,"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":55,"runs":4,"score":"159\/4","bats":[{"runs":10,"balls_faced":26,"fours":2,"sixes":0,"batsman_id":49041},{"runs":67,"balls_faced":155,"fours":9,"sixes":1,"batsman_id":49025}],"bowls":[{"runs_conceded":25,"maidens":1,"wickets":1,"bowler_id":486,"overs":8},{"runs_conceded":47,"maidens":3,"wickets":1,"bowler_id":49425,"overs":18}],"commentary":"End of over 55 (4 runs), Warwickshire 159\/4"},{"event_id":"12226858","event":"ball","batsman_id":"49041","bowler_id":"49425","over":"55","ball":"1","score":0,"commentary":"Jack Leach to Ed Barnard, no run,","noball_dismissal":false,"text":"","timestamp":1750869454,"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":"12226860","event":"ball","batsman_id":"49041","bowler_id":"49425","over":"55","ball":"2","score":0,"commentary":"Jack Leach to Ed Barnard, no run,","noball_dismissal":false,"text":"","timestamp":1750869457,"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":"12226861","event":"ball","batsman_id":"49041","bowler_id":"49425","over":"55","ball":"3","score":1,"commentary":"Jack Leach to Ed Barnard, 1 run,","noball_dismissal":false,"text":"","timestamp":1750869461,"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":"12226864","event":"ball","batsman_id":"49025","bowler_id":"49425","over":"55","ball":"4","score":0,"commentary":"Jack Leach to Sam Hain, no run,","noball_dismissal":false,"text":"","timestamp":1750869500,"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":"12226881","event":"ball","batsman_id":"49025","bowler_id":"49425","over":"55","ball":"5","score":1,"commentary":"Jack Leach to Sam Hain, 1 run,","noball_dismissal":false,"text":"","timestamp":1750869580,"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":"12226885","event":"ball","batsman_id":"49041","bowler_id":"49425","over":"55","ball":"6","score":0,"commentary":"Jack Leach to Ed Barnard, no run,","noball_dismissal":false,"text":"","timestamp":1750869584,"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":56,"runs":2,"score":"161\/4","bats":[{"runs":11,"balls_faced":30,"fours":2,"sixes":0,"batsman_id":49041},{"runs":68,"balls_faced":157,"fours":9,"sixes":1,"batsman_id":49025}],"bowls":[{"runs_conceded":49,"maidens":3,"wickets":1,"bowler_id":49425,"overs":19},{"runs_conceded":25,"maidens":1,"wickets":1,"bowler_id":486,"overs":8}],"commentary":"End of over 56 (2 runs), Warwickshire 161\/4"}],"day":"4","session":"0","live_inning":{"iid":198726,"number":4,"name":"Warwickshire 2nd Inning","short_name":"WAS 2nd Inning","status":2,"issuperover":"false","result":4,"batting_team_id":7002,"fielding_team_id":7010,"scores":"161\/4","scores_full":"161\/4 (56 ov)","fielder":[{"fielder_id":"49733","fielder_name":"Craig Overton","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"49413","fielder_name":"Tom Abell","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":[],"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Jacob Bethell","batsman_id":"108388","runs":"12","balls":"24","how_out":"c TB Abell b M Pretorius","score_at_dismissal":131,"overs_at_dismissal":"45.4","bowler_id":"57592","dismissal":"caught","number":4},"extra_runs":{"byes":2,"legbyes":0,"wides":1,"noballs":2,"penalty":"0","total":5},"equations":{"runs":161,"wickets":4,"overs":"56","bowlers_used":6,"runrate":"2.88"},"current_partnership":{"runs":30,"balls":62,"overs":10.2,"batsmen":[{"name":"Ed Barnard","batsman_id":49041,"runs":11,"balls":30},{"name":"Sam Hain","batsman_id":49025,"runs":19,"balls":32}]},"did_not_bat":[{"player_id":"94952","name":"Kai Smith"},{"player_id":"93516","name":"Ethan Bamber"},{"player_id":"108389","name":"Che Simmons"},{"player_id":"49017","name":"Oliver Hannon-Dalby"},{"player_id":"103483","name":"Corey Rocchiccioli"}],"max_over":"0","target":"378","recent_scores":"0,1,0,1,0,0,1,3,0,0,0,0,0,1,0,0,0,0","last_five_overs":"9\/0 1.80","last_ten_overs":"30\/0 3.00"},"teams":[{"tid":7002,"title":"Warwickshire","abbr":"WAS","alt_name":"Warwickshire","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Warwickshire.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Warwickshire.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"351\/10 (121.1 ov) & 161\/4 (56 ov)","scores":"351\/10 & 161\/4","overs":"121.1 & 56"},{"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":"498\/10 (133.3 ov) & 229\/8d (53.1 ov)","scores":"498\/10 & 229\/8d","overs":"133.3 & 53.1"}],"players":[{"pid":107,"title":"Chris Woakes","short_name":"C Woakes","first_name":"Chris Woakes","last_name":"","middle_name":"","birthdate":"1989-03-02","birthplace":"Birmingham, Warwickshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/chriswoakes\/","twitter_profile":"https:\/\/twitter.com\/chriswoakes","instagram_profile":"https:\/\/www.instagram.com\/chriswoakes\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"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":"all","role_str":""},{"pid":486,"title":"Matt Henry","short_name":"M Henry","first_name":"Matt Henry","last_name":"","middle_name":"","birthdate":"1991-12-14","birthplace":"Christchurch, Canterbury","country":"nz","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bowl","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":43985,"title":"Vishwa Fernando","short_name":"V Fernando","first_name":"Vishwa Fernando","last_name":"","middle_name":"","birthdate":"1991-09-18","birthplace":"Colombo","country":"lk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":37263,"recent_appearance":1513776600,"fantasy_player_rating":7,"facebook_profile":"https:\/\/www.facebook.com\/VishwaFernandoSLC\/","twitter_profile":"https:\/\/twitter.com\/vrnfernando1","instagram_profile":"https:\/\/www.instagram.com\/vishwa_fernando68\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Sri Lanka","role":"squad","role_str":""},{"pid":44099,"title":"Hasan Ali","short_name":"H Ali","first_name":"Hasan Ali","last_name":"","middle_name":"","birthdate":"1994-07-02","birthplace":"Gujranwala, Punjab","country":"pk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/Realhassan32\/","twitter_profile":"https:\/\/twitter.com\/RealHa55an","instagram_profile":"https:\/\/www.instagram.com\/ha55an_ali\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"squad","role_str":""},{"pid":44185,"title":"Tom Latham","short_name":"T Latham","first_name":"Tom Latham","last_name":"","middle_name":"","birthdate":"1992-04-02","birthplace":"Christchurch, Canterbury","country":"nz","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"wicket keeper","recent_match":23991,"recent_appearance":1513980000,"fantasy_player_rating":7,"facebook_profile":"https:\/\/www.facebook.com\/tomlathamofficial","twitter_profile":"https:\/\/twitter.com\/Tomlatham2","instagram_profile":"https:\/\/www.instagram.com\/tomlatham2\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"wk","role_str":""},{"pid":48430,"title":"Alex Davies","short_name":"AL Davies","first_name":"Alex Davies","last_name":"","middle_name":"","birthdate":"1994-08-23","birthplace":"Darwen, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/aldavies23\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK\/C)"},{"pid":48656,"title":"Tom Kohler-Cadmore","short_name":"TK Cadmore","first_name":"Tom Kohler-Cadmore","last_name":"","middle_name":"","birthdate":"1994-08-19","birthplace":" Chatham, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/tomkholerCadmore32\/","twitter_profile":"https:\/\/twitter.com\/TomKCadmore32","instagram_profile":"https:\/\/www.instagram.com\/tomkcadmore","debut_data":"","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":49017,"title":"Oliver Hannon-Dalby","short_name":"OJ Hannon-Dalby","first_name":"Oliver Hannon-Dalby","last_name":"","middle_name":"","birthdate":"1989-06-20","birthplace":" Halifax, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":49025,"title":"Sam Hain","short_name":"SR Hain","first_name":"Sam Hain","last_name":"","middle_name":"","birthdate":"1995-07-16","birthplace":"Hong Kong","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/SammieHain","instagram_profile":"https:\/\/www.instagram.com\/sammiehain","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":49041,"title":"Ed Barnard","short_name":"EG Barnard","first_name":"Ed Barnard","last_name":"","middle_name":"","birthdate":"1995-11-20","birthplace":"","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":49320,"title":"Chris Rushworth","short_name":"C Rushworth","first_name":"Chris Rushworth","last_name":"","middle_name":"","birthdate":"1986-07-11","birthplace":"Sunderland","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49413,"title":"Tom Abell","short_name":"TB Abell","first_name":"Tom Abell","last_name":"","middle_name":"","birthdate":"1994-03-05","birthplace":"Taunton, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/tomabell1","instagram_profile":"https:\/\/www.instagram.com\/tabell28\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":49421,"title":"Lewis Gregory","short_name":"L Gregory","first_name":"Lewis Gregory","last_name":"","middle_name":"","birthdate":"1992-05-24","birthplace":"Plymouth","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/lewisgregory23\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49425,"title":"Jack Leach","short_name":"J Leach","first_name":"Jack Leach","last_name":"","middle_name":"","birthdate":"1991-06-22","birthplace":" Taunton, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/jackleach1991?lang=gu","instagram_profile":"https:\/\/www.instagram.com\/mjleach17\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":49480,"title":"Danny Briggs","short_name":"DR Briggs","first_name":"Danny Briggs","last_name":"","middle_name":"","birthdate":"1991-04-30","birthplace":" Newport, Isle of Wight","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":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/DannyBriggs_14","instagram_profile":"https:\/\/www.instagram.com\/dannybriggs14\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49530,"title":"Craig Miles","short_name":"CN Miles","first_name":"Craig Miles","last_name":"","middle_name":"","birthdate":"1994-07-20","birthplace":"Swindon, Wiltshire","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.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/CMiles_18","instagram_profile":"https:\/\/www.instagram.com\/cmiles18\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49733,"title":"Craig Overton","short_name":"C Overton","first_name":"Craig Overton","last_name":"","middle_name":"","birthdate":"1994-04-10","birthplace":"Barnstaple, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/craigoverton12","instagram_profile":"https:\/\/www.instagram.com\/craigoverton12\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":"(C)"},{"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":"squad","role_str":""},{"pid":51266,"title":"Tom Banton","short_name":"T Banton","first_name":"Tom Banton","last_name":"","middle_name":"","birthdate":"1998-11-11","birthplace":"Chiltern, Buckinghamshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/OfficialTomBanton\/","twitter_profile":"https:\/\/twitter.com\/tbanton18","instagram_profile":"https:\/\/www.instagram.com\/tombanton\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":""},{"pid":52897,"title":"Matt Renshaw","short_name":"MT Renshaw","first_name":"Matt Renshaw","last_name":"","middle_name":"","birthdate":"1996-03-28","birthplace":"Middlesbrough, Yorkshire","country":"au","primary_team":[],"logo_url":"","playing_role":"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":53626,"title":"Beau Webster","short_name":"BJ Webster","first_name":"Beau Webster","last_name":"","middle_name":"","birthdate":"1993-12-01","birthplace":"Snug, Hobart, Tasmania","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":57592,"title":"Migael Pretorius","short_name":"M Pretorius","first_name":"Migael Pretorius","last_name":"","middle_name":"","birthdate":"1995-03-24","birthplace":"Vereeninging","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/migael27\/","twitter_profile":"https:\/\/twitter.com\/migael_27","instagram_profile":"https:\/\/www.instagram.com\/migael27\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bowl","role_str":""},{"pid":60761,"title":"Brett Randell","short_name":"Brett Randell","first_name":"Brett Randell","last_name":"","middle_name":"","birthdate":"1995-05-20","birthplace":"","country":"nz","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","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":"squad","role_str":""},{"pid":93516,"title":"Ethan Bamber","short_name":"ER Bamber","first_name":"Ethan Bamber","last_name":"","middle_name":"","birthdate":"1998-12-17","birthplace":"Westminster, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/etbamber","instagram_profile":"https:\/\/www.instagram.com\/etbamber\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":93520,"title":"Tom Lammonby","short_name":"TA Lammonby","first_name":"Tom Lammonby","last_name":"","middle_name":"","birthdate":"2000-06-02","birthplace":" Exeter, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/TomLammonby","instagram_profile":"https:\/\/www.instagram.com\/tom_lammonby\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":94952,"title":"Kai Smith","short_name":"K Smith","first_name":"Kai Smith","last_name":"","middle_name":"","birthdate":"2004-11-28","birthplace":" Dubai, United Arab Emirates","country":"ae","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"Wicketkeeper","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":"United Arab Emirates","role":"bat","role_str":""},{"pid":95003,"title":"Robert Yates","short_name":"RM Yates","first_name":"Robert Yates","last_name":"","middle_name":"","birthdate":"1999-09-19","birthplace":"Solihull, Warwickshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":95543,"title":"Dan Mousley","short_name":"D Mousley","first_name":"Dan Mousley","last_name":"","middle_name":"","birthdate":"2001-07-08","birthplace":"Birmingham, Warwickshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/danmousley80","instagram_profile":"https:\/\/www.instagram.com\/danmousley80\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95550,"title":"Kasey Aldridge","short_name":"K Aldridge","first_name":"Kasey Aldridge","last_name":"","middle_name":"","birthdate":"2000-12-24","birthplace":"Bristol","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/kcaldridge5\/","debut_data":"","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":"squad","role_str":""},{"pid":102808,"title":"Jake Lintott","short_name":"J Lintott","first_name":"Jake Lintott","last_name":"","middle_name":"","birthdate":"1993-04-22","birthplace":"Taunton, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Wrist Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lintott23","instagram_profile":"https:\/\/www.instagram.com\/lintott23\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":103052,"title":"Will Smeed","short_name":"W Smeed","first_name":"Will Smeed","last_name":"","middle_name":"","birthdate":"2001-10-26","birthplace":"Cambridge","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/will_smeed","instagram_profile":"https:\/\/www.instagram.com\/willsmeed\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":103483,"title":"Corey Rocchiccioli","short_name":"C Rocchiccioli","first_name":"Corey Rocchiccioli","last_name":"","middle_name":"","birthdate":"1997-10-08","birthplace":"Subiaco, Perth, Western Australia","country":"au","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/_rockets23","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Australia","role":"bowl","role_str":""},{"pid":108388,"title":"Jacob Bethell","short_name":"J Bethell","first_name":"Jacob Bethell","last_name":"","middle_name":"","birthdate":"2003-10-23","birthplace":"Barbados","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BethellJacob","instagram_profile":"https:\/\/www.instagram.com\/jacob.bethell\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":108389,"title":"Che Simmons","short_name":"C Simmons","first_name":"Che Simmons","last_name":"","middle_name":"","birthdate":"2003-12-18","birthplace":"Birmingham, England","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","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":"wk","role_str":"(WK)"},{"pid":109583,"title":"Hamza Shaikh","short_name":"H Shaikh","first_name":"Hamza Shaikh","last_name":"","middle_name":"","birthdate":"2006-05-29","birthplace":"","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":110620,"title":"Michael Booth","short_name":"MG Booth","first_name":"Michael Booth","last_name":"","middle_name":"","birthdate":"2001-02-12","birthplace":" Harare","country":"za","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","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":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":134957,"title":"Tazeem Chaudry Ali","short_name":"TC Ali","first_name":"Tazeem Chaudry Ali","last_name":"","middle_name":"","birthdate":"2006-06-13","birthplace":"","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":137372,"title":"Archie Vaughan","short_name":"A Vaughan","first_name":"Archie Vaughan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""}]},"etag":"973405f80d96d5be7b57a1254136d969","modified":"2025-07-12 20:17:57","datetime":"2025-07-12 20:17:57","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":88135,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Match Drawn","day_remaining_over":"7.5","team_batting":"Warwickshire","team_bowling":"Somerset","live_inning_number":4,"live_score":{"runs":161,"overs":56,"wickets":4,"target":378,"runrate":2.88,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Sam Hain","batsman_id":49025,"runs":68,"balls_faced":157,"fours":9,"sixes":1,"strike_rate":"43.31"},{"name":"Ed Barnard","batsman_id":49041,"runs":11,"balls_faced":30,"fours":2,"sixes":0,"strike_rate":"36.67"}],"bowlers":[{"name":"Jack Leach","bowler_id":49425,"overs":19,"runs_conceded":49,"wickets":1,"maidens":3,"econ":"2.58"},{"name":"Matt Henry","bowler_id":486,"overs":8,"runs_conceded":25,"wickets":1,"maidens":1,"econ":"3.13"}],"commentaries":[{"event_id":"12226734","event":"ball","batsman_id":"49025","bowler_id":"57592","over":"51","ball":"5","score":0,"commentary":"Migael Pretorius to Sam Hain, no run,","noball_dismissal":false,"text":"","timestamp":1750868562,"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":"12226750","event":"ball","batsman_id":"49025","bowler_id":"57592","over":"51","ball":"6","score":0,"commentary":"Migael Pretorius to Sam Hain, no run,","noball_dismissal":false,"text":"","timestamp":1750868691,"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":52,"runs":2,"score":"154\/4","bats":[{"runs":63,"balls_faced":145,"fours":9,"sixes":1,"batsman_id":49025},{"runs":9,"balls_faced":18,"fours":2,"sixes":0,"batsman_id":49041}],"bowls":[{"runs_conceded":40,"maidens":1,"wickets":1,"bowler_id":57592,"overs":11},{"runs_conceded":21,"maidens":0,"wickets":1,"bowler_id":486,"overs":6}],"commentary":"End of over 52 (2 runs), Warwickshire 154\/4"},{"event_id":"12226756","event":"ball","batsman_id":"49041","bowler_id":"486","over":"52","ball":"1","score":0,"commentary":"Matt Henry to Ed Barnard, no run,","noball_dismissal":false,"text":"","timestamp":1750868694,"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":"12226759","event":"ball","batsman_id":"49041","bowler_id":"486","over":"52","ball":"2","score":0,"commentary":"Matt Henry to Ed Barnard, no run,","noball_dismissal":false,"text":"","timestamp":1750868727,"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":"12226765","event":"ball","batsman_id":"49041","bowler_id":"486","over":"52","ball":"3","score":0,"commentary":"Matt Henry to Ed Barnard, no run,","noball_dismissal":false,"text":"","timestamp":1750868760,"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":"12226766","event":"ball","batsman_id":"49041","bowler_id":"486","over":"52","ball":"4","score":0,"commentary":"Matt Henry to Ed Barnard, no run,","noball_dismissal":false,"text":"","timestamp":1750868764,"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":"12226775","event":"ball","batsman_id":"49041","bowler_id":"486","over":"52","ball":"5","score":0,"commentary":"Matt Henry to Ed Barnard, no run,","noball_dismissal":false,"text":"","timestamp":1750868815,"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":"12226780","event":"ball","batsman_id":"49041","bowler_id":"486","over":"52","ball":"6","score":0,"commentary":"Matt Henry to Ed Barnard, no run,","noball_dismissal":false,"text":"","timestamp":1750868888,"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":53,"runs":0,"score":"154\/4","bats":[{"runs":9,"balls_faced":24,"fours":2,"sixes":0,"batsman_id":49041},{"runs":63,"balls_faced":145,"fours":9,"sixes":1,"batsman_id":49025}],"bowls":[{"runs_conceded":21,"maidens":1,"wickets":1,"bowler_id":486,"overs":7},{"runs_conceded":40,"maidens":1,"wickets":1,"bowler_id":57592,"overs":11}],"commentary":"End of over 53 (0 runs), Warwickshire 154\/4"},{"event_id":"12226791","event":"ball","batsman_id":"49025","bowler_id":"49425","over":"53","ball":"1","score":0,"commentary":"Jack Leach to Sam Hain, no run,","noball_dismissal":false,"text":"","timestamp":1750868991,"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":"12226792","event":"ball","batsman_id":"49025","bowler_id":"49425","over":"53","ball":"2","score":0,"commentary":"Jack Leach to Sam Hain, no run,","noball_dismissal":false,"text":"","timestamp":1750868996,"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":"12226795","event":"ball","batsman_id":"49025","bowler_id":"49425","over":"53","ball":"3","score":0,"commentary":"Jack Leach to Sam Hain, no run,","noball_dismissal":false,"text":"","timestamp":1750869150,"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":"12226797","event":"ball","batsman_id":"49025","bowler_id":"49425","over":"53","ball":"4","score":0,"commentary":"Jack Leach to Sam Hain, no run,","noball_dismissal":false,"text":"","timestamp":1750869153,"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":"12226803","event":"ball","batsman_id":"49025","bowler_id":"49425","over":"53","ball":"5","score":1,"commentary":"Jack Leach to Sam Hain, 1 run,","noball_dismissal":false,"text":"","timestamp":1750869193,"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":"12226805","event":"ball","batsman_id":"49041","bowler_id":"49425","over":"53","ball":"6","score":0,"commentary":"Jack Leach to Ed Barnard, no run,","noball_dismissal":false,"text":"","timestamp":1750869197,"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":54,"runs":1,"score":"155\/4","bats":[{"runs":9,"balls_faced":25,"fours":2,"sixes":0,"batsman_id":49041},{"runs":64,"balls_faced":150,"fours":9,"sixes":1,"batsman_id":49025}],"bowls":[{"runs_conceded":47,"maidens":3,"wickets":1,"bowler_id":49425,"overs":18},{"runs_conceded":21,"maidens":1,"wickets":1,"bowler_id":486,"overs":7}],"commentary":"End of over 54 (1 runs), Warwickshire 155\/4"},{"event_id":"12226806","event":"ball","batsman_id":"49025","bowler_id":"486","over":"54","ball":"1","score":0,"commentary":"Matt Henry to Sam Hain, no run,","noball_dismissal":false,"text":"","timestamp":1750869200,"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":"12226807","event":"ball","batsman_id":"49025","bowler_id":"486","over":"54","ball":"2","score":0,"commentary":"Matt Henry to Sam Hain, no run,","noball_dismissal":false,"text":"","timestamp":1750869203,"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":"12226808","event":"ball","batsman_id":"49025","bowler_id":"486","over":"54","ball":"3","score":0,"commentary":"Matt Henry to Sam Hain, no run,","noball_dismissal":false,"text":"","timestamp":1750869213,"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":"12226840","event":"ball","batsman_id":"49025","bowler_id":"486","over":"54","ball":"4","score":0,"commentary":"Matt Henry to Sam Hain, no run,","noball_dismissal":false,"text":"","timestamp":1750869341,"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":"12226841","event":"ball","batsman_id":"49025","bowler_id":"486","over":"54","ball":"5","score":3,"commentary":"Matt Henry to Sam Hain, 3 runs,","noball_dismissal":false,"text":"","timestamp":1750869345,"run":3,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"3","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12226842","event":"ball","batsman_id":"49041","bowler_id":"486","over":"54","ball":"6","score":1,"commentary":"Matt Henry to Ed Barnard, 1 run,","noball_dismissal":false,"text":"","timestamp":1750869348,"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":55,"runs":4,"score":"159\/4","bats":[{"runs":10,"balls_faced":26,"fours":2,"sixes":0,"batsman_id":49041},{"runs":67,"balls_faced":155,"fours":9,"sixes":1,"batsman_id":49025}],"bowls":[{"runs_conceded":25,"maidens":1,"wickets":1,"bowler_id":486,"overs":8},{"runs_conceded":47,"maidens":3,"wickets":1,"bowler_id":49425,"overs":18}],"commentary":"End of over 55 (4 runs), Warwickshire 159\/4"},{"event_id":"12226858","event":"ball","batsman_id":"49041","bowler_id":"49425","over":"55","ball":"1","score":0,"commentary":"Jack Leach to Ed Barnard, no run,","noball_dismissal":false,"text":"","timestamp":1750869454,"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":"12226860","event":"ball","batsman_id":"49041","bowler_id":"49425","over":"55","ball":"2","score":0,"commentary":"Jack Leach to Ed Barnard, no run,","noball_dismissal":false,"text":"","timestamp":1750869457,"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":"12226861","event":"ball","batsman_id":"49041","bowler_id":"49425","over":"55","ball":"3","score":1,"commentary":"Jack Leach to Ed Barnard, 1 run,","noball_dismissal":false,"text":"","timestamp":1750869461,"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":"12226864","event":"ball","batsman_id":"49025","bowler_id":"49425","over":"55","ball":"4","score":0,"commentary":"Jack Leach to Sam Hain, no run,","noball_dismissal":false,"text":"","timestamp":1750869500,"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":"12226881","event":"ball","batsman_id":"49025","bowler_id":"49425","over":"55","ball":"5","score":1,"commentary":"Jack Leach to Sam Hain, 1 run,","noball_dismissal":false,"text":"","timestamp":1750869580,"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":"12226885","event":"ball","batsman_id":"49041","bowler_id":"49425","over":"55","ball":"6","score":0,"commentary":"Jack Leach to Ed Barnard, no run,","noball_dismissal":false,"text":"","timestamp":1750869584,"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":56,"runs":2,"score":"161\/4","bats":[{"runs":11,"balls_faced":30,"fours":2,"sixes":0,"batsman_id":49041},{"runs":68,"balls_faced":157,"fours":9,"sixes":1,"batsman_id":49025}],"bowls":[{"runs_conceded":49,"maidens":3,"wickets":1,"bowler_id":49425,"overs":19},{"runs_conceded":25,"maidens":1,"wickets":1,"bowler_id":486,"overs":8}],"commentary":"End of over 56 (2 runs), Warwickshire 161\/4"}],"day":"4","session":"0","live_inning":{"iid":198726,"number":4,"name":"Warwickshire 2nd Inning","short_name":"WAS 2nd Inning","status":2,"issuperover":"false","result":4,"batting_team_id":7002,"fielding_team_id":7010,"scores":"161\/4","scores_full":"161\/4 (56 ov)","fielder":[{"fielder_id":"49733","fielder_name":"Craig Overton","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"49413","fielder_name":"Tom Abell","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":[],"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Jacob Bethell","batsman_id":"108388","runs":"12","balls":"24","how_out":"c TB Abell b M Pretorius","score_at_dismissal":131,"overs_at_dismissal":"45.4","bowler_id":"57592","dismissal":"caught","number":4},"extra_runs":{"byes":2,"legbyes":0,"wides":1,"noballs":2,"penalty":"0","total":5},"equations":{"runs":161,"wickets":4,"overs":"56","bowlers_used":6,"runrate":"2.88"},"current_partnership":{"runs":30,"balls":62,"overs":10.2,"batsmen":[{"name":"Ed Barnard","batsman_id":49041,"runs":11,"balls":30},{"name":"Sam Hain","batsman_id":49025,"runs":19,"balls":32}]},"did_not_bat":[{"player_id":"94952","name":"Kai Smith"},{"player_id":"93516","name":"Ethan Bamber"},{"player_id":"108389","name":"Che Simmons"},{"player_id":"49017","name":"Oliver Hannon-Dalby"},{"player_id":"103483","name":"Corey Rocchiccioli"}],"max_over":"0","target":"378","recent_scores":"0,1,0,1,0,0,1,3,0,0,0,0,0,1,0,0,0,0","last_five_overs":"9\/0 1.80","last_ten_overs":"30\/0 3.00"},"teams":[{"tid":7002,"title":"Warwickshire","abbr":"WAS","alt_name":"Warwickshire","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Warwickshire.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Warwickshire.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"351\/10 (121.1 ov) & 161\/4 (56 ov)","scores":"351\/10 & 161\/4","overs":"121.1 & 56"},{"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":"498\/10 (133.3 ov) & 229\/8d (53.1 ov)","scores":"498\/10 & 229\/8d","overs":"133.3 & 53.1"}],"players":[{"pid":107,"title":"Chris Woakes","short_name":"C Woakes","first_name":"Chris Woakes","last_name":"","middle_name":"","birthdate":"1989-03-02","birthplace":"Birmingham, Warwickshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/chriswoakes\/","twitter_profile":"https:\/\/twitter.com\/chriswoakes","instagram_profile":"https:\/\/www.instagram.com\/chriswoakes\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"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":"all","role_str":""},{"pid":486,"title":"Matt Henry","short_name":"M Henry","first_name":"Matt Henry","last_name":"","middle_name":"","birthdate":"1991-12-14","birthplace":"Christchurch, Canterbury","country":"nz","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bowl","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":43985,"title":"Vishwa Fernando","short_name":"V Fernando","first_name":"Vishwa Fernando","last_name":"","middle_name":"","birthdate":"1991-09-18","birthplace":"Colombo","country":"lk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":37263,"recent_appearance":1513776600,"fantasy_player_rating":7,"facebook_profile":"https:\/\/www.facebook.com\/VishwaFernandoSLC\/","twitter_profile":"https:\/\/twitter.com\/vrnfernando1","instagram_profile":"https:\/\/www.instagram.com\/vishwa_fernando68\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Sri Lanka","role":"squad","role_str":""},{"pid":44099,"title":"Hasan Ali","short_name":"H Ali","first_name":"Hasan Ali","last_name":"","middle_name":"","birthdate":"1994-07-02","birthplace":"Gujranwala, Punjab","country":"pk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/Realhassan32\/","twitter_profile":"https:\/\/twitter.com\/RealHa55an","instagram_profile":"https:\/\/www.instagram.com\/ha55an_ali\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"squad","role_str":""},{"pid":44185,"title":"Tom Latham","short_name":"T Latham","first_name":"Tom Latham","last_name":"","middle_name":"","birthdate":"1992-04-02","birthplace":"Christchurch, Canterbury","country":"nz","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"wicket keeper","recent_match":23991,"recent_appearance":1513980000,"fantasy_player_rating":7,"facebook_profile":"https:\/\/www.facebook.com\/tomlathamofficial","twitter_profile":"https:\/\/twitter.com\/Tomlatham2","instagram_profile":"https:\/\/www.instagram.com\/tomlatham2\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"wk","role_str":""},{"pid":48430,"title":"Alex Davies","short_name":"AL Davies","first_name":"Alex Davies","last_name":"","middle_name":"","birthdate":"1994-08-23","birthplace":"Darwen, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/aldavies23\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK\/C)"},{"pid":48656,"title":"Tom Kohler-Cadmore","short_name":"TK Cadmore","first_name":"Tom Kohler-Cadmore","last_name":"","middle_name":"","birthdate":"1994-08-19","birthplace":" Chatham, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/tomkholerCadmore32\/","twitter_profile":"https:\/\/twitter.com\/TomKCadmore32","instagram_profile":"https:\/\/www.instagram.com\/tomkcadmore","debut_data":"","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":49017,"title":"Oliver Hannon-Dalby","short_name":"OJ Hannon-Dalby","first_name":"Oliver Hannon-Dalby","last_name":"","middle_name":"","birthdate":"1989-06-20","birthplace":" Halifax, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":49025,"title":"Sam Hain","short_name":"SR Hain","first_name":"Sam Hain","last_name":"","middle_name":"","birthdate":"1995-07-16","birthplace":"Hong Kong","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/SammieHain","instagram_profile":"https:\/\/www.instagram.com\/sammiehain","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":49041,"title":"Ed Barnard","short_name":"EG Barnard","first_name":"Ed Barnard","last_name":"","middle_name":"","birthdate":"1995-11-20","birthplace":"","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":49320,"title":"Chris Rushworth","short_name":"C Rushworth","first_name":"Chris Rushworth","last_name":"","middle_name":"","birthdate":"1986-07-11","birthplace":"Sunderland","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49413,"title":"Tom Abell","short_name":"TB Abell","first_name":"Tom Abell","last_name":"","middle_name":"","birthdate":"1994-03-05","birthplace":"Taunton, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/tomabell1","instagram_profile":"https:\/\/www.instagram.com\/tabell28\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":49421,"title":"Lewis Gregory","short_name":"L Gregory","first_name":"Lewis Gregory","last_name":"","middle_name":"","birthdate":"1992-05-24","birthplace":"Plymouth","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/lewisgregory23\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49425,"title":"Jack Leach","short_name":"J Leach","first_name":"Jack Leach","last_name":"","middle_name":"","birthdate":"1991-06-22","birthplace":" Taunton, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/jackleach1991?lang=gu","instagram_profile":"https:\/\/www.instagram.com\/mjleach17\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":49480,"title":"Danny Briggs","short_name":"DR Briggs","first_name":"Danny Briggs","last_name":"","middle_name":"","birthdate":"1991-04-30","birthplace":" Newport, Isle of Wight","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":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/DannyBriggs_14","instagram_profile":"https:\/\/www.instagram.com\/dannybriggs14\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49530,"title":"Craig Miles","short_name":"CN Miles","first_name":"Craig Miles","last_name":"","middle_name":"","birthdate":"1994-07-20","birthplace":"Swindon, Wiltshire","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.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/CMiles_18","instagram_profile":"https:\/\/www.instagram.com\/cmiles18\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49733,"title":"Craig Overton","short_name":"C Overton","first_name":"Craig Overton","last_name":"","middle_name":"","birthdate":"1994-04-10","birthplace":"Barnstaple, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/craigoverton12","instagram_profile":"https:\/\/www.instagram.com\/craigoverton12\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":"(C)"},{"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":"squad","role_str":""},{"pid":51266,"title":"Tom Banton","short_name":"T Banton","first_name":"Tom Banton","last_name":"","middle_name":"","birthdate":"1998-11-11","birthplace":"Chiltern, Buckinghamshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/OfficialTomBanton\/","twitter_profile":"https:\/\/twitter.com\/tbanton18","instagram_profile":"https:\/\/www.instagram.com\/tombanton\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":""},{"pid":52897,"title":"Matt Renshaw","short_name":"MT Renshaw","first_name":"Matt Renshaw","last_name":"","middle_name":"","birthdate":"1996-03-28","birthplace":"Middlesbrough, Yorkshire","country":"au","primary_team":[],"logo_url":"","playing_role":"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":53626,"title":"Beau Webster","short_name":"BJ Webster","first_name":"Beau Webster","last_name":"","middle_name":"","birthdate":"1993-12-01","birthplace":"Snug, Hobart, Tasmania","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":57592,"title":"Migael Pretorius","short_name":"M Pretorius","first_name":"Migael Pretorius","last_name":"","middle_name":"","birthdate":"1995-03-24","birthplace":"Vereeninging","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/migael27\/","twitter_profile":"https:\/\/twitter.com\/migael_27","instagram_profile":"https:\/\/www.instagram.com\/migael27\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bowl","role_str":""},{"pid":60761,"title":"Brett Randell","short_name":"Brett Randell","first_name":"Brett Randell","last_name":"","middle_name":"","birthdate":"1995-05-20","birthplace":"","country":"nz","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","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":"squad","role_str":""},{"pid":93516,"title":"Ethan Bamber","short_name":"ER Bamber","first_name":"Ethan Bamber","last_name":"","middle_name":"","birthdate":"1998-12-17","birthplace":"Westminster, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/etbamber","instagram_profile":"https:\/\/www.instagram.com\/etbamber\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":93520,"title":"Tom Lammonby","short_name":"TA Lammonby","first_name":"Tom Lammonby","last_name":"","middle_name":"","birthdate":"2000-06-02","birthplace":" Exeter, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/TomLammonby","instagram_profile":"https:\/\/www.instagram.com\/tom_lammonby\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":94952,"title":"Kai Smith","short_name":"K Smith","first_name":"Kai Smith","last_name":"","middle_name":"","birthdate":"2004-11-28","birthplace":" Dubai, United Arab Emirates","country":"ae","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"Wicketkeeper","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":"United Arab Emirates","role":"bat","role_str":""},{"pid":95003,"title":"Robert Yates","short_name":"RM Yates","first_name":"Robert Yates","last_name":"","middle_name":"","birthdate":"1999-09-19","birthplace":"Solihull, Warwickshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":95543,"title":"Dan Mousley","short_name":"D Mousley","first_name":"Dan Mousley","last_name":"","middle_name":"","birthdate":"2001-07-08","birthplace":"Birmingham, Warwickshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/danmousley80","instagram_profile":"https:\/\/www.instagram.com\/danmousley80\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95550,"title":"Kasey Aldridge","short_name":"K Aldridge","first_name":"Kasey Aldridge","last_name":"","middle_name":"","birthdate":"2000-12-24","birthplace":"Bristol","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/kcaldridge5\/","debut_data":"","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":"squad","role_str":""},{"pid":102808,"title":"Jake Lintott","short_name":"J Lintott","first_name":"Jake Lintott","last_name":"","middle_name":"","birthdate":"1993-04-22","birthplace":"Taunton, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Wrist Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lintott23","instagram_profile":"https:\/\/www.instagram.com\/lintott23\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":103052,"title":"Will Smeed","short_name":"W Smeed","first_name":"Will Smeed","last_name":"","middle_name":"","birthdate":"2001-10-26","birthplace":"Cambridge","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/will_smeed","instagram_profile":"https:\/\/www.instagram.com\/willsmeed\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":103483,"title":"Corey Rocchiccioli","short_name":"C Rocchiccioli","first_name":"Corey Rocchiccioli","last_name":"","middle_name":"","birthdate":"1997-10-08","birthplace":"Subiaco, Perth, Western Australia","country":"au","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/_rockets23","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Australia","role":"bowl","role_str":""},{"pid":108388,"title":"Jacob Bethell","short_name":"J Bethell","first_name":"Jacob Bethell","last_name":"","middle_name":"","birthdate":"2003-10-23","birthplace":"Barbados","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BethellJacob","instagram_profile":"https:\/\/www.instagram.com\/jacob.bethell\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":108389,"title":"Che Simmons","short_name":"C Simmons","first_name":"Che Simmons","last_name":"","middle_name":"","birthdate":"2003-12-18","birthplace":"Birmingham, England","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","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":"wk","role_str":"(WK)"},{"pid":109583,"title":"Hamza Shaikh","short_name":"H Shaikh","first_name":"Hamza Shaikh","last_name":"","middle_name":"","birthdate":"2006-05-29","birthplace":"","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":110620,"title":"Michael Booth","short_name":"MG Booth","first_name":"Michael Booth","last_name":"","middle_name":"","birthdate":"2001-02-12","birthplace":" Harare","country":"za","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","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":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":134957,"title":"Tazeem Chaudry Ali","short_name":"TC Ali","first_name":"Tazeem Chaudry Ali","last_name":"","middle_name":"","birthdate":"2006-06-13","birthplace":"","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":137372,"title":"Archie Vaughan","short_name":"A Vaughan","first_name":"Archie Vaughan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""}]},"etag":"973405f80d96d5be7b57a1254136d969","modified":"2025-07-12 20:17:57","datetime":"2025-07-12 20:17:57","api_version":"3.0"}', Modified = GetDate() WHERE Id = 88135 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:0135263f-8f60-4c63-bfa8-1583902b7f4d
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 88135 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (88135,3,'{"status":"ok","response":{"match_id":88135,"title":"Warwickshire vs Somerset","short_title":"WAS vs SOM","subtitle":"38th Match","match_number":"38","format":5,"format_str":"First Class","status":2,"status_str":"Completed","status_note":"Match Drawn","verified":"true","pre_squad":"false","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129481,"title":"County Championship Division One","abbr":"County Championship 2025 DIV-I","type":"tournament","category":"domestic","match_format":"firstclass","season":"2025","status":"live","datestart":"2025-04-04","dateend":"2025-09-27","country":"en","total_matches":"70","total_rounds":"1","total_teams":"10"},"teama":{"team_id":7002,"name":"Warwickshire","short_name":"WAS","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Warwickshire.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Warwickshire.png","scores_full":"351\/10 (121.1 ov) & 161\/4 (56 ov)","scores":"351\/10 & 161\/4","overs":"121.1 & 56"},"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":"498\/10 (133.3 ov) & 229\/8d (53.1 ov)","scores":"498\/10 & 229\/8d","overs":"133.3 & 53.1"},"date_start":"2025-06-22 10:00:00","date_end":"2025-06-27 10:00:00","timestamp_start":1750586400,"timestamp_end":1751018400,"date_start_ist":"2025-06-22 15:30:00","date_end_ist":"2025-06-27 15:30:00","venue":{"venue_id":"32","name":"Edgbaston","location":"Birmingham","country":"England","timezone":""},"umpires":"","referee":"","equation":"Match Drawn","live":"","result":"Match Drawn","result_type":3,"win_margin":"","winning_team_id":0,"commentary":1,"wagon":2,"latest_inning_number":4,"presquad_time":"","verify_time":"2025-06-25 22:47:33","match_dls_affected":"false","live_inning_number":4,"day":"4","session":"0","weather":[],"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Somerset elected to bat","winner":7010,"decision":1}},"etag":"e25913bd65bb8306bbfae0ba545afe9d","modified":"2025-07-13 23:30:08","datetime":"2025-07-13 23:30:08","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":88135,"title":"Warwickshire vs Somerset","short_title":"WAS vs SOM","subtitle":"38th Match","match_number":"38","format":5,"format_str":"First Class","status":2,"status_str":"Completed","status_note":"Match Drawn","verified":"true","pre_squad":"false","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129481,"title":"County Championship Division One","abbr":"County Championship 2025 DIV-I","type":"tournament","category":"domestic","match_format":"firstclass","season":"2025","status":"live","datestart":"2025-04-04","dateend":"2025-09-27","country":"en","total_matches":"70","total_rounds":"1","total_teams":"10"},"teama":{"team_id":7002,"name":"Warwickshire","short_name":"WAS","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Warwickshire.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Warwickshire.png","scores_full":"351\/10 (121.1 ov) & 161\/4 (56 ov)","scores":"351\/10 & 161\/4","overs":"121.1 & 56"},"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":"498\/10 (133.3 ov) & 229\/8d (53.1 ov)","scores":"498\/10 & 229\/8d","overs":"133.3 & 53.1"},"date_start":"2025-06-22 10:00:00","date_end":"2025-06-27 10:00:00","timestamp_start":1750586400,"timestamp_end":1751018400,"date_start_ist":"2025-06-22 15:30:00","date_end_ist":"2025-06-27 15:30:00","venue":{"venue_id":"32","name":"Edgbaston","location":"Birmingham","country":"England","timezone":""},"umpires":"","referee":"","equation":"Match Drawn","live":"","result":"Match Drawn","result_type":3,"win_margin":"","winning_team_id":0,"commentary":1,"wagon":2,"latest_inning_number":4,"presquad_time":"","verify_time":"2025-06-25 22:47:33","match_dls_affected":"false","live_inning_number":4,"day":"4","session":"0","weather":[],"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Somerset elected to bat","winner":7010,"decision":1}},"etag":"e25913bd65bb8306bbfae0ba545afe9d","modified":"2025-07-13 23:30:08","datetime":"2025-07-13 23:30:08","api_version":"3.0"}', Modified = GetDate() WHERE Id = 88135 AND DataTypeId = 3 END Live Report & Scorecard of Warwickshire vs Somerset 38th Match
Warwickshire vs Somerset, Live Cricket Commentary