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:21a39407-4467-4217-bacc-104e66870af0
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86909 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86909,1,'{"status":"ok","response":{"mid":86909,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Somerset won by 95 runs","day_remaining_over":"","team_batting":"Essex","team_bowling":"Somerset","live_inning_number":2,"live_score":{"runs":130,"overs":14.1,"wickets":10,"target":226,"runrate":9.18,"required_runrate":16.46},"commentary":1,"wagon":2,"batsmen":[{"name":"Simon Harmer","batsman_id":49087,"runs":20,"balls_faced":15,"fours":2,"sixes":0,"strike_rate":"133.33"},{"name":"Charlie Edward Bennett","batsman_id":150399,"runs":0,"balls_faced":0,"fours":0,"sixes":0,"strike_rate":"0.00"}],"bowlers":[{"name":"Craig Overton","bowler_id":49733,"overs":3.1,"runs_conceded":32,"wickets":2,"maidens":0,"econ":"10.11"},{"name":"Matt Henry","bowler_id":486,"overs":4,"runs_conceded":21,"wickets":4,"maidens":0,"econ":"5.25"}],"commentaries":[{"event_id":"12309735","event":"ball","batsman_id":"127517","bowler_id":"95554","over":"9","ball":"6","score":1,"commentary":"Lewis Goldsworthy to Noah Thain, 1 run,","noball_dismissal":false,"text":"","timestamp":1752003997,"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":10,"runs":4,"score":"85\/7","bats":[{"runs":16,"balls_faced":9,"fours":1,"sixes":1,"batsman_id":127517},{"runs":2,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":49087}],"bowls":[{"runs_conceded":9,"maidens":0,"wickets":1,"bowler_id":95554,"overs":2},{"runs_conceded":14,"maidens":0,"wickets":0,"bowler_id":49421,"overs":1}],"commentary":"End of over 10 (4 runs), Essex 85\/7"},{"event_id":"12309736","event":"ball","batsman_id":"127517","bowler_id":"1049","over":"10","ball":"1","score":1,"commentary":"Ben Green to Noah Thain, 1 run,","noball_dismissal":false,"text":"","timestamp":1752004000,"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":"12309737","event":"ball","batsman_id":"49087","bowler_id":"1049","over":"10","ball":"2","score":1,"commentary":"Ben Green to Simon Harmer, 1 run,","noball_dismissal":false,"text":"","timestamp":1752004003,"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":"12309738","event":"ball","batsman_id":"127517","bowler_id":"1049","over":"10","ball":"3","score":6,"commentary":"Ben Green to Noah Thain, Six,","noball_dismissal":false,"text":"","timestamp":1752004006,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12309741","event":"ball","batsman_id":"127517","bowler_id":"1049","over":"10","ball":"4","score":1,"commentary":"Ben Green to Noah Thain, 1 run,","noball_dismissal":false,"text":"","timestamp":1752004028,"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":"12309742","event":"ball","batsman_id":"49087","bowler_id":"1049","over":"10","ball":"5","score":2,"commentary":"Ben Green to Simon Harmer, 2 runs,","noball_dismissal":false,"text":"","timestamp":1752004045,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12309743","event":"ball","batsman_id":"49087","bowler_id":"1049","over":"10","ball":"6","score":4,"commentary":"Ben Green to Simon Harmer, Four,","noball_dismissal":false,"text":"","timestamp":1752004048,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event":"overend","over":11,"runs":15,"score":"100\/7","bats":[{"runs":9,"balls_faced":6,"fours":1,"sixes":0,"batsman_id":49087},{"runs":24,"balls_faced":12,"fours":1,"sixes":2,"batsman_id":127517}],"bowls":[{"runs_conceded":15,"maidens":0,"wickets":0,"bowler_id":1049,"overs":1},{"runs_conceded":9,"maidens":0,"wickets":1,"bowler_id":95554,"overs":2}],"commentary":"End of over 11 (15 runs), Essex 100\/7"},{"event_id":"12309746","event":"ball","batsman_id":"127517","bowler_id":"95554","over":"11","ball":"1","score":6,"commentary":"Lewis Goldsworthy to Noah Thain, Six,","noball_dismissal":false,"text":"","timestamp":1752004051,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12309747","event":"ball","batsman_id":"127517","bowler_id":"95554","over":"11","ball":"2","score":1,"commentary":"Lewis Goldsworthy to Noah Thain, 1 run,","noball_dismissal":false,"text":"","timestamp":1752004054,"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":"12309750","event":"ball","batsman_id":"49087","bowler_id":"95554","over":"11","ball":"3","score":2,"commentary":"Lewis Goldsworthy to Simon Harmer, 2 runs,","noball_dismissal":false,"text":"","timestamp":1752004099,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12309752","event":"ball","batsman_id":"49087","bowler_id":"95554","over":"11","ball":"4","score":1,"commentary":"Lewis Goldsworthy to Simon Harmer, 1 run,","noball_dismissal":false,"text":"","timestamp":1752004102,"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":"12309753","event":"ball","batsman_id":"127517","bowler_id":"95554","over":"11","ball":"5","score":6,"commentary":"Lewis Goldsworthy to Noah Thain, Six,","noball_dismissal":false,"text":"","timestamp":1752004118,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12309754","event":"ball","batsman_id":"127517","bowler_id":"95554","over":"11","ball":"6","score":1,"commentary":"Lewis Goldsworthy to Noah Thain, 1 run,","noball_dismissal":false,"text":"","timestamp":1752004148,"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":12,"runs":17,"score":"117\/7","bats":[{"runs":38,"balls_faced":16,"fours":1,"sixes":4,"batsman_id":127517},{"runs":12,"balls_faced":8,"fours":1,"sixes":0,"batsman_id":49087}],"bowls":[{"runs_conceded":26,"maidens":0,"wickets":1,"bowler_id":95554,"overs":3},{"runs_conceded":15,"maidens":0,"wickets":0,"bowler_id":1049,"overs":1}],"commentary":"End of over 12 (17 runs), Essex 117\/7"},{"event_id":"12309759","event":"wicket","batsman_id":"127517","bowler_id":"49733","over":"12","ball":"1","score":"w","commentary":"Craig Overton to Noah Thain, no run, c M Henry b C Overton,","noball_dismissal":false,"text":"","timestamp":1752004231,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"127517","how_out":"c M Henry b C Overton","batsman_runs":"38","batsman_balls":"17"},{"event_id":"12309763","event":"ball","batsman_id":"1758","bowler_id":"49733","over":"12","ball":"2","score":1,"commentary":"Craig Overton to Mohammad Amir, 1 run,","noball_dismissal":false,"text":"","timestamp":1752004283,"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":"12309765","event":"ball","batsman_id":"49087","bowler_id":"49733","over":"12","ball":"3","score":1,"commentary":"Craig Overton to Simon Harmer, 1 run,","noball_dismissal":false,"text":"","timestamp":1752004337,"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":"12309768","event":"ball","batsman_id":"1758","bowler_id":"49733","over":"12","ball":"4","score":1,"commentary":"Craig Overton to Mohammad Amir, 1 run,","noball_dismissal":false,"text":"","timestamp":1752004342,"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":"12309770","event":"ball","batsman_id":"49087","bowler_id":"49733","over":"12","ball":"5","score":1,"commentary":"Craig Overton to Simon Harmer, 1 run,","noball_dismissal":false,"text":"","timestamp":1752004361,"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":"12309773","event":"ball","batsman_id":"1758","bowler_id":"49733","over":"12","ball":"6","score":0,"commentary":"Craig Overton to Mohammad Amir, no run,","noball_dismissal":false,"text":"","timestamp":1752004596,"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":13,"runs":4,"score":"121\/8","bats":[{"runs":2,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":1758},{"runs":14,"balls_faced":10,"fours":1,"sixes":0,"batsman_id":49087}],"bowls":[{"runs_conceded":32,"maidens":0,"wickets":1,"bowler_id":49733,"overs":3},{"runs_conceded":26,"maidens":0,"wickets":1,"bowler_id":95554,"overs":3}],"commentary":"End of over 13 (4 runs), Essex 121\/8"},{"event_id":"12309777","event":"ball","batsman_id":"49087","bowler_id":"486","over":"13","ball":"1","score":1,"commentary":"Matt Henry to Simon Harmer, 1 run,","noball_dismissal":false,"text":"","timestamp":1752004470,"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":"12309779","event":"ball","batsman_id":"1758","bowler_id":"486","over":"13","ball":"2","score":3,"commentary":"Matt Henry to Mohammad Amir, 3 runs,","noball_dismissal":false,"text":"","timestamp":1752004504,"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":"12309780","event":"ball","batsman_id":"49087","bowler_id":"486","over":"13","ball":"3","score":0,"commentary":"Matt Henry to Simon Harmer, no run,","noball_dismissal":false,"text":"","timestamp":1752004529,"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":"12309783","event":"ball","batsman_id":"49087","bowler_id":"486","over":"13","ball":"4","score":4,"commentary":"Matt Henry to Simon Harmer, Four,","noball_dismissal":false,"text":"","timestamp":1752004572,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12309788","event":"ball","batsman_id":"49087","bowler_id":"486","over":"13","ball":"5","score":1,"commentary":"Matt Henry to Simon Harmer, 1 run,","noball_dismissal":false,"text":"","timestamp":1752004615,"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":"12309791","event":"wicket","batsman_id":"1758","bowler_id":"486","over":"13","ball":"6","score":"w","commentary":"Matt Henry to Mohammad Amir, no run, c TK Cadmore b M Henry,","noball_dismissal":false,"text":"","timestamp":1752004657,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"1758","how_out":"c TK Cadmore b M Henry","batsman_runs":"5","batsman_balls":"5"},{"event":"overend","over":14,"runs":9,"score":"130\/9","bats":[{"runs":5,"balls_faced":5,"fours":0,"sixes":0,"batsman_id":1758},{"runs":20,"balls_faced":14,"fours":2,"sixes":0,"batsman_id":49087}],"bowls":[{"runs_conceded":21,"maidens":0,"wickets":4,"bowler_id":486,"overs":4},{"runs_conceded":32,"maidens":0,"wickets":1,"bowler_id":49733,"overs":3}],"commentary":"End of over 14 (9 runs), Essex 130\/9"},{"event_id":"12309797","event":"wicket","batsman_id":"49087","bowler_id":"49733","over":"14","ball":"1","score":"w","commentary":"Craig Overton to Simon Harmer, no run, c W Smeed b C Overton,","noball_dismissal":false,"text":"","timestamp":1752004791,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"49087","how_out":"c W Smeed b C Overton","batsman_runs":"20","batsman_balls":"15"}],"day":"0","session":"0","live_inning":{"iid":199335,"number":2,"name":"Essex Inning","short_name":"ESS Inning","status":2,"issuperover":"false","result":1,"batting_team_id":104950,"fielding_team_id":7010,"scores":"130\/10","scores_full":"130\/10 (14.1 ov)","fielder":[{"fielder_id":"49421","fielder_name":"Lewis Gregory","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"1049","fielder_name":"Ben Green","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":1,"stumping":0,"is_substitute":"false"},{"fielder_id":"103052","fielder_name":"Will Smeed","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"49823","fielder_name":"Sean Dickson","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"486","fielder_name":"Matt Henry","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"48656","fielder_name":"Tom Kohler-Cadmore","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Simon Harmer","batsman_id":"49087","runs":"20","balls":"15","how_out":"c W Smeed b C Overton","score_at_dismissal":130,"overs_at_dismissal":"14.1","bowler_id":"49733","dismissal":"caught","number":10},"extra_runs":{"byes":0,"legbyes":0,"wides":0,"noballs":0,"penalty":"0","total":0},"equations":{"runs":130,"wickets":10,"overs":"14.1","bowlers_used":6,"runrate":"9.18"},"current_partnership":{"runs":0,"balls":1,"overs":0.1,"batsmen":[{"name":"Simon Harmer","batsman_id":49087,"runs":0,"balls":1},{"name":"Charlie Edward Bennett","batsman_id":150399,"runs":0,"balls":0}]},"did_not_bat":[],"max_over":"20","target":"226","recent_scores":"w,w,1,4,0,3,1,0,1,1,1,1,w,1,6,1,2,1","last_five_overs":"49\/3 9.80","last_ten_overs":"95\/8 9.50"},"teams":[{"tid":7010,"title":"Somerset","abbr":"SOM","alt_name":"SOM","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/somerset-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/somerset-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"225\/6 (20 ov)","scores":"225\/6","overs":"20"},{"tid":104950,"title":"Essex","abbr":"ESS","alt_name":"ESS","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"130\/10 (14.1 ov)","scores":"130\/10","overs":"14.1"}],"players":[{"pid":301,"title":"Josh Davey","short_name":"J Davey","first_name":"Josh Davey","last_name":"","middle_name":"","birthdate":"1990-08-03","birthplace":"Aberdeen, United Kingdom","country":"sct","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Scotland","role":"squad","role_str":""},{"pid":486,"title":"Matt Henry","short_name":"M Henry","first_name":"Matt Henry","last_name":"","middle_name":"","birthdate":"1991-12-14","birthplace":"Christchurch, Canterbury","country":"nz","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bowl","role_str":""},{"pid":1049,"title":"Ben Green","short_name":"BGF Green","first_name":"Ben Green","last_name":"","middle_name":"","birthdate":"1997-09-28","birthplace":"Exeter, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":1758,"title":"Mohammad Amir","short_name":"M Amir","first_name":"Mohammad Amir","last_name":"","middle_name":"","birthdate":"1992-04-13","birthplace":" Gujjar Khan, Punjab","country":"pk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/iamamirofficial","instagram_profile":"https:\/\/www.instagram.com\/official.mamir\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bowl","role_str":""},{"pid":10592,"title":"Tom Westley","short_name":"TZ Westley","first_name":"Tom Westley","last_name":"","middle_name":"","birthdate":"1989-03-13","birthplace":"Cambridge","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":10602,"title":"Nick Browne","short_name":"NLJ Browne","first_name":"Nick Browne","last_name":"","middle_name":"","birthdate":"1991-03-24","birthplace":"Leytonstone, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":10606,"title":"Jake Ball","short_name":"JT Ball","first_name":"Jake Ball","last_name":"","middle_name":"","birthdate":"1991-03-14","birthplace":"Mansfield, Nottinghamshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":18974,"recent_appearance":1517109600,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/jakeball","instagram_profile":"https:\/\/www.instagram.com\/jakeball\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":48647,"title":"Matt Critchley","short_name":"MJJ Critchley","first_name":"Matt Critchley","last_name":"","middle_name":"","birthdate":"1996-08-13","birthplace":"Preston, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/mattcritchley96","instagram_profile":"https:\/\/www.instagram.com\/critch130896\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":48656,"title":"Tom Kohler-Cadmore","short_name":"TK Cadmore","first_name":"Tom Kohler-Cadmore","last_name":"","middle_name":"","birthdate":"1994-08-19","birthplace":" Chatham, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/tomkholerCadmore32\/","twitter_profile":"https:\/\/twitter.com\/TomKCadmore32","instagram_profile":"https:\/\/www.instagram.com\/tomkcadmore","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":49015,"title":"Andrew Umeed","short_name":"ARI Umeed","first_name":"Andrew Umeed","last_name":"","middle_name":"","birthdate":"1996-04-19","birthplace":"Glasgow, Lanarkshire","country":"sct","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Scotland","role":"squad","role_str":""},{"pid":49083,"title":"Dean Elgar","short_name":"D Elgar","first_name":"Dean Elgar","last_name":"","middle_name":"","birthdate":"1987-06-11","birthplace":"Welkom, Orange Free state","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":36249,"recent_appearance":1514287800,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BoringDeanElgar","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":49087,"title":"Simon Harmer","short_name":"SR Harmer","first_name":"Simon Harmer","last_name":"","middle_name":"","birthdate":"1989-02-10","birthplace":"Pretoria, Transvaal","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Simon_Harmer_","instagram_profile":"https:\/\/www.instagram.com\/simon_harmer\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bowl","role_str":"(C)"},{"pid":49376,"title":"Adam Rossington","short_name":"AM Rossington","first_name":"Adam Rossington","last_name":"","middle_name":"","birthdate":"1993-05-05","birthplace":"Edgware, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper ","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Rossington17","instagram_profile":"https:\/\/www.instagram.com\/rossington17\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49413,"title":"Tom Abell","short_name":"TB Abell","first_name":"Tom Abell","last_name":"","middle_name":"","birthdate":"1994-03-05","birthplace":"Taunton, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/tomabell1","instagram_profile":"https:\/\/www.instagram.com\/tabell28\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":49421,"title":"Lewis Gregory","short_name":"L Gregory","first_name":"Lewis Gregory","last_name":"","middle_name":"","birthdate":"1992-05-24","birthplace":"Plymouth","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/lewisgregory23\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":"(C)"},{"pid":49425,"title":"Jack Leach","short_name":"J Leach","first_name":"Jack Leach","last_name":"","middle_name":"","birthdate":"1991-06-22","birthplace":" Taunton, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/jackleach1991?lang=gu","instagram_profile":"https:\/\/www.instagram.com\/mjleach17\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49593,"title":"Jamie Porter","short_name":"JA Porter","first_name":"Jamie Porter","last_name":"","middle_name":"","birthdate":"1993-05-25","birthplace":"Leytonstone, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","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":""},{"pid":49823,"title":"Sean Dickson","short_name":"SR Dickson","first_name":"Sean Dickson","last_name":"","middle_name":"","birthdate":"1991-09-02","birthplace":"Johannesburg, Transvaal","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bat","role_str":""},{"pid":51105,"title":"Michael-Kyle Pepper","short_name":"MKS Pepper","first_name":"Michael-Kyle Pepper","last_name":"","middle_name":"","birthdate":"1998-06-25","birthplace":"Harlow, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/michael_pep\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":""},{"pid":51266,"title":"Tom Banton","short_name":"T Banton","first_name":"Tom Banton","last_name":"","middle_name":"","birthdate":"1998-11-11","birthplace":"Chiltern, Buckinghamshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/OfficialTomBanton\/","twitter_profile":"https:\/\/twitter.com\/tbanton18","instagram_profile":"https:\/\/www.instagram.com\/tombanton\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":51346,"title":"Paul Walter","short_name":"PI Walter","first_name":"Paul Walter","last_name":"","middle_name":"","birthdate":"1994-05-28","birthplace":"Basildon, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":57592,"title":"Migael Pretorius","short_name":"M Pretorius","first_name":"Migael Pretorius","last_name":"","middle_name":"","birthdate":"1995-03-24","birthplace":"Vereeninging","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"https:\/\/www.facebook.com\/migael27\/","twitter_profile":"https:\/\/twitter.com\/migael_27","instagram_profile":"https:\/\/www.instagram.com\/migael27\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":61358,"title":"Shane Snater","short_name":"S Snater","first_name":"Shane Snater","last_name":"","middle_name":"","birthdate":"1996-03-24","birthplace":"Harare, Zimbabwe","country":"nl","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"squad","role_str":""},{"pid":68691,"title":"Samuel Cook","short_name":"S Cook","first_name":"Samuel Cook","last_name":"","middle_name":"","birthdate":"1997-08-04","birthplace":"Chelmsford, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/samcook09","instagram_profile":"https:\/\/www.instagram.com\/s_cook16\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":93329,"title":"Riley Meredith","short_name":"RP Meredith","first_name":"Riley Meredith","last_name":"","middle_name":"","birthdate":"1996-06-21","birthplace":"Hobart, Tasmania","country":"au","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/rileymeredith_\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"bowl","role_str":""},{"pid":93520,"title":"Tom Lammonby","short_name":"TA Lammonby","first_name":"Tom Lammonby","last_name":"","middle_name":"","birthdate":"2000-06-02","birthplace":" Exeter, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/TomLammonby","instagram_profile":"https:\/\/www.instagram.com\/tom_lammonby\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":94961,"title":"Jordan Cox","short_name":"J Cox","first_name":"Jordan Cox","last_name":"","middle_name":"","birthdate":"2000-10-21","birthplace":"Margate, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/jjordancox\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":95554,"title":"Lewis Goldsworthy","short_name":"L Goldsworthy","first_name":"Lewis Goldsworthy","last_name":"","middle_name":"","birthdate":"2001-01-08","birthplace":" Cornwall","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lewigoldsworthy","instagram_profile":"https:\/\/www.instagram.com\/lewisgoldsworthy\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":103052,"title":"Will Smeed","short_name":"W Smeed","first_name":"Will Smeed","last_name":"","middle_name":"","birthdate":"2001-10-26","birthplace":"Cambridge","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/will_smeed","instagram_profile":"https:\/\/www.instagram.com\/willsmeed\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":103358,"title":"Robin Das","short_name":"RJ Das","first_name":"Robin Das","last_name":"","middle_name":"","birthdate":"2002-02-27","birthplace":"Leytonstone","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"https:\/\/www.facebook.com\/robindascricketer","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/robinigblue\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":108393,"title":"Jamal Richards","short_name":"J Richards","first_name":"Jamal Richards","last_name":"","middle_name":"","birthdate":"2004-03-03","birthplace":"Edmonton, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108408,"title":"James Rew","short_name":"J Rew","first_name":"James Rew","last_name":"","middle_name":"","birthdate":"2004-01-11","birthplace":" London","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/cjrew89\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108410,"title":"Joshua Thomas","short_name":"J Thomas","first_name":"Joshua Thomas","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108420,"title":"Luc Benkenstein","short_name":"L Benkenstein","first_name":"Luc Benkenstein","last_name":"","middle_name":"","birthdate":"2004-11-02","birthplace":"Durban","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":127517,"title":"Noah Thain","short_name":"NRM Thain","first_name":"Noah Thain","last_name":"","middle_name":"","birthdate":"2005-01-13","birthplace":"Hitchinbrooke, Hertfordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":129447,"title":"Mackenzie Jones","short_name":"Mackenzie Jones","first_name":"Mackenzie Jones","last_name":"","middle_name":"","birthdate":"2005-03-06","birthplace":"","country":"sct","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Scotland","role":"squad","role_str":""},{"pid":129894,"title":"JT Langridge","short_name":"JT Langridge","first_name":"JT Langridge","last_name":"","middle_name":"","birthdate":"2005-11-03","birthplace":" Plymouth, Devon,","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":130425,"title":"Finley Hill","short_name":"F Hill","first_name":"Finley Hill","last_name":"","middle_name":"","birthdate":"2006-06-21","birthplace":" Exeter, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":134958,"title":"Charles Allison","short_name":"CW Allison","first_name":"Charles Allison","last_name":"","middle_name":"","birthdate":"2005-03-02","birthplace":"Colchester, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":137372,"title":"Archie Vaughan","short_name":"A Vaughan","first_name":"Archie Vaughan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":141341,"title":"Simon Fernandes","short_name":"Simon Fernandes","first_name":"Simon Fernandes","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":146438,"title":"Thomas Rew","short_name":"T Rew","first_name":"Thomas Rew","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":150399,"title":"Charlie Edward Bennett","short_name":"CE Bennett","first_name":"Charlie Edward Bennett","last_name":"","middle_name":"","birthdate":"2006-05-01","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""}]},"etag":"f9bc9c47ec463a2b2b58bc1b7e6b7cb2","modified":"2025-07-16 03:41:46","datetime":"2025-07-16 03:41:46","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":86909,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Somerset won by 95 runs","day_remaining_over":"","team_batting":"Essex","team_bowling":"Somerset","live_inning_number":2,"live_score":{"runs":130,"overs":14.1,"wickets":10,"target":226,"runrate":9.18,"required_runrate":16.46},"commentary":1,"wagon":2,"batsmen":[{"name":"Simon Harmer","batsman_id":49087,"runs":20,"balls_faced":15,"fours":2,"sixes":0,"strike_rate":"133.33"},{"name":"Charlie Edward Bennett","batsman_id":150399,"runs":0,"balls_faced":0,"fours":0,"sixes":0,"strike_rate":"0.00"}],"bowlers":[{"name":"Craig Overton","bowler_id":49733,"overs":3.1,"runs_conceded":32,"wickets":2,"maidens":0,"econ":"10.11"},{"name":"Matt Henry","bowler_id":486,"overs":4,"runs_conceded":21,"wickets":4,"maidens":0,"econ":"5.25"}],"commentaries":[{"event_id":"12309735","event":"ball","batsman_id":"127517","bowler_id":"95554","over":"9","ball":"6","score":1,"commentary":"Lewis Goldsworthy to Noah Thain, 1 run,","noball_dismissal":false,"text":"","timestamp":1752003997,"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":10,"runs":4,"score":"85\/7","bats":[{"runs":16,"balls_faced":9,"fours":1,"sixes":1,"batsman_id":127517},{"runs":2,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":49087}],"bowls":[{"runs_conceded":9,"maidens":0,"wickets":1,"bowler_id":95554,"overs":2},{"runs_conceded":14,"maidens":0,"wickets":0,"bowler_id":49421,"overs":1}],"commentary":"End of over 10 (4 runs), Essex 85\/7"},{"event_id":"12309736","event":"ball","batsman_id":"127517","bowler_id":"1049","over":"10","ball":"1","score":1,"commentary":"Ben Green to Noah Thain, 1 run,","noball_dismissal":false,"text":"","timestamp":1752004000,"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":"12309737","event":"ball","batsman_id":"49087","bowler_id":"1049","over":"10","ball":"2","score":1,"commentary":"Ben Green to Simon Harmer, 1 run,","noball_dismissal":false,"text":"","timestamp":1752004003,"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":"12309738","event":"ball","batsman_id":"127517","bowler_id":"1049","over":"10","ball":"3","score":6,"commentary":"Ben Green to Noah Thain, Six,","noball_dismissal":false,"text":"","timestamp":1752004006,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12309741","event":"ball","batsman_id":"127517","bowler_id":"1049","over":"10","ball":"4","score":1,"commentary":"Ben Green to Noah Thain, 1 run,","noball_dismissal":false,"text":"","timestamp":1752004028,"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":"12309742","event":"ball","batsman_id":"49087","bowler_id":"1049","over":"10","ball":"5","score":2,"commentary":"Ben Green to Simon Harmer, 2 runs,","noball_dismissal":false,"text":"","timestamp":1752004045,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12309743","event":"ball","batsman_id":"49087","bowler_id":"1049","over":"10","ball":"6","score":4,"commentary":"Ben Green to Simon Harmer, Four,","noball_dismissal":false,"text":"","timestamp":1752004048,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event":"overend","over":11,"runs":15,"score":"100\/7","bats":[{"runs":9,"balls_faced":6,"fours":1,"sixes":0,"batsman_id":49087},{"runs":24,"balls_faced":12,"fours":1,"sixes":2,"batsman_id":127517}],"bowls":[{"runs_conceded":15,"maidens":0,"wickets":0,"bowler_id":1049,"overs":1},{"runs_conceded":9,"maidens":0,"wickets":1,"bowler_id":95554,"overs":2}],"commentary":"End of over 11 (15 runs), Essex 100\/7"},{"event_id":"12309746","event":"ball","batsman_id":"127517","bowler_id":"95554","over":"11","ball":"1","score":6,"commentary":"Lewis Goldsworthy to Noah Thain, Six,","noball_dismissal":false,"text":"","timestamp":1752004051,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12309747","event":"ball","batsman_id":"127517","bowler_id":"95554","over":"11","ball":"2","score":1,"commentary":"Lewis Goldsworthy to Noah Thain, 1 run,","noball_dismissal":false,"text":"","timestamp":1752004054,"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":"12309750","event":"ball","batsman_id":"49087","bowler_id":"95554","over":"11","ball":"3","score":2,"commentary":"Lewis Goldsworthy to Simon Harmer, 2 runs,","noball_dismissal":false,"text":"","timestamp":1752004099,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12309752","event":"ball","batsman_id":"49087","bowler_id":"95554","over":"11","ball":"4","score":1,"commentary":"Lewis Goldsworthy to Simon Harmer, 1 run,","noball_dismissal":false,"text":"","timestamp":1752004102,"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":"12309753","event":"ball","batsman_id":"127517","bowler_id":"95554","over":"11","ball":"5","score":6,"commentary":"Lewis Goldsworthy to Noah Thain, Six,","noball_dismissal":false,"text":"","timestamp":1752004118,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12309754","event":"ball","batsman_id":"127517","bowler_id":"95554","over":"11","ball":"6","score":1,"commentary":"Lewis Goldsworthy to Noah Thain, 1 run,","noball_dismissal":false,"text":"","timestamp":1752004148,"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":12,"runs":17,"score":"117\/7","bats":[{"runs":38,"balls_faced":16,"fours":1,"sixes":4,"batsman_id":127517},{"runs":12,"balls_faced":8,"fours":1,"sixes":0,"batsman_id":49087}],"bowls":[{"runs_conceded":26,"maidens":0,"wickets":1,"bowler_id":95554,"overs":3},{"runs_conceded":15,"maidens":0,"wickets":0,"bowler_id":1049,"overs":1}],"commentary":"End of over 12 (17 runs), Essex 117\/7"},{"event_id":"12309759","event":"wicket","batsman_id":"127517","bowler_id":"49733","over":"12","ball":"1","score":"w","commentary":"Craig Overton to Noah Thain, no run, c M Henry b C Overton,","noball_dismissal":false,"text":"","timestamp":1752004231,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"127517","how_out":"c M Henry b C Overton","batsman_runs":"38","batsman_balls":"17"},{"event_id":"12309763","event":"ball","batsman_id":"1758","bowler_id":"49733","over":"12","ball":"2","score":1,"commentary":"Craig Overton to Mohammad Amir, 1 run,","noball_dismissal":false,"text":"","timestamp":1752004283,"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":"12309765","event":"ball","batsman_id":"49087","bowler_id":"49733","over":"12","ball":"3","score":1,"commentary":"Craig Overton to Simon Harmer, 1 run,","noball_dismissal":false,"text":"","timestamp":1752004337,"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":"12309768","event":"ball","batsman_id":"1758","bowler_id":"49733","over":"12","ball":"4","score":1,"commentary":"Craig Overton to Mohammad Amir, 1 run,","noball_dismissal":false,"text":"","timestamp":1752004342,"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":"12309770","event":"ball","batsman_id":"49087","bowler_id":"49733","over":"12","ball":"5","score":1,"commentary":"Craig Overton to Simon Harmer, 1 run,","noball_dismissal":false,"text":"","timestamp":1752004361,"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":"12309773","event":"ball","batsman_id":"1758","bowler_id":"49733","over":"12","ball":"6","score":0,"commentary":"Craig Overton to Mohammad Amir, no run,","noball_dismissal":false,"text":"","timestamp":1752004596,"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":13,"runs":4,"score":"121\/8","bats":[{"runs":2,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":1758},{"runs":14,"balls_faced":10,"fours":1,"sixes":0,"batsman_id":49087}],"bowls":[{"runs_conceded":32,"maidens":0,"wickets":1,"bowler_id":49733,"overs":3},{"runs_conceded":26,"maidens":0,"wickets":1,"bowler_id":95554,"overs":3}],"commentary":"End of over 13 (4 runs), Essex 121\/8"},{"event_id":"12309777","event":"ball","batsman_id":"49087","bowler_id":"486","over":"13","ball":"1","score":1,"commentary":"Matt Henry to Simon Harmer, 1 run,","noball_dismissal":false,"text":"","timestamp":1752004470,"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":"12309779","event":"ball","batsman_id":"1758","bowler_id":"486","over":"13","ball":"2","score":3,"commentary":"Matt Henry to Mohammad Amir, 3 runs,","noball_dismissal":false,"text":"","timestamp":1752004504,"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":"12309780","event":"ball","batsman_id":"49087","bowler_id":"486","over":"13","ball":"3","score":0,"commentary":"Matt Henry to Simon Harmer, no run,","noball_dismissal":false,"text":"","timestamp":1752004529,"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":"12309783","event":"ball","batsman_id":"49087","bowler_id":"486","over":"13","ball":"4","score":4,"commentary":"Matt Henry to Simon Harmer, Four,","noball_dismissal":false,"text":"","timestamp":1752004572,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12309788","event":"ball","batsman_id":"49087","bowler_id":"486","over":"13","ball":"5","score":1,"commentary":"Matt Henry to Simon Harmer, 1 run,","noball_dismissal":false,"text":"","timestamp":1752004615,"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":"12309791","event":"wicket","batsman_id":"1758","bowler_id":"486","over":"13","ball":"6","score":"w","commentary":"Matt Henry to Mohammad Amir, no run, c TK Cadmore b M Henry,","noball_dismissal":false,"text":"","timestamp":1752004657,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"1758","how_out":"c TK Cadmore b M Henry","batsman_runs":"5","batsman_balls":"5"},{"event":"overend","over":14,"runs":9,"score":"130\/9","bats":[{"runs":5,"balls_faced":5,"fours":0,"sixes":0,"batsman_id":1758},{"runs":20,"balls_faced":14,"fours":2,"sixes":0,"batsman_id":49087}],"bowls":[{"runs_conceded":21,"maidens":0,"wickets":4,"bowler_id":486,"overs":4},{"runs_conceded":32,"maidens":0,"wickets":1,"bowler_id":49733,"overs":3}],"commentary":"End of over 14 (9 runs), Essex 130\/9"},{"event_id":"12309797","event":"wicket","batsman_id":"49087","bowler_id":"49733","over":"14","ball":"1","score":"w","commentary":"Craig Overton to Simon Harmer, no run, c W Smeed b C Overton,","noball_dismissal":false,"text":"","timestamp":1752004791,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"49087","how_out":"c W Smeed b C Overton","batsman_runs":"20","batsman_balls":"15"}],"day":"0","session":"0","live_inning":{"iid":199335,"number":2,"name":"Essex Inning","short_name":"ESS Inning","status":2,"issuperover":"false","result":1,"batting_team_id":104950,"fielding_team_id":7010,"scores":"130\/10","scores_full":"130\/10 (14.1 ov)","fielder":[{"fielder_id":"49421","fielder_name":"Lewis Gregory","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"1049","fielder_name":"Ben Green","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":1,"stumping":0,"is_substitute":"false"},{"fielder_id":"103052","fielder_name":"Will Smeed","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"49823","fielder_name":"Sean Dickson","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"486","fielder_name":"Matt Henry","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"48656","fielder_name":"Tom Kohler-Cadmore","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Simon Harmer","batsman_id":"49087","runs":"20","balls":"15","how_out":"c W Smeed b C Overton","score_at_dismissal":130,"overs_at_dismissal":"14.1","bowler_id":"49733","dismissal":"caught","number":10},"extra_runs":{"byes":0,"legbyes":0,"wides":0,"noballs":0,"penalty":"0","total":0},"equations":{"runs":130,"wickets":10,"overs":"14.1","bowlers_used":6,"runrate":"9.18"},"current_partnership":{"runs":0,"balls":1,"overs":0.1,"batsmen":[{"name":"Simon Harmer","batsman_id":49087,"runs":0,"balls":1},{"name":"Charlie Edward Bennett","batsman_id":150399,"runs":0,"balls":0}]},"did_not_bat":[],"max_over":"20","target":"226","recent_scores":"w,w,1,4,0,3,1,0,1,1,1,1,w,1,6,1,2,1","last_five_overs":"49\/3 9.80","last_ten_overs":"95\/8 9.50"},"teams":[{"tid":7010,"title":"Somerset","abbr":"SOM","alt_name":"SOM","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/somerset-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/somerset-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"225\/6 (20 ov)","scores":"225\/6","overs":"20"},{"tid":104950,"title":"Essex","abbr":"ESS","alt_name":"ESS","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"130\/10 (14.1 ov)","scores":"130\/10","overs":"14.1"}],"players":[{"pid":301,"title":"Josh Davey","short_name":"J Davey","first_name":"Josh Davey","last_name":"","middle_name":"","birthdate":"1990-08-03","birthplace":"Aberdeen, United Kingdom","country":"sct","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Scotland","role":"squad","role_str":""},{"pid":486,"title":"Matt Henry","short_name":"M Henry","first_name":"Matt Henry","last_name":"","middle_name":"","birthdate":"1991-12-14","birthplace":"Christchurch, Canterbury","country":"nz","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bowl","role_str":""},{"pid":1049,"title":"Ben Green","short_name":"BGF Green","first_name":"Ben Green","last_name":"","middle_name":"","birthdate":"1997-09-28","birthplace":"Exeter, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":1758,"title":"Mohammad Amir","short_name":"M Amir","first_name":"Mohammad Amir","last_name":"","middle_name":"","birthdate":"1992-04-13","birthplace":" Gujjar Khan, Punjab","country":"pk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/iamamirofficial","instagram_profile":"https:\/\/www.instagram.com\/official.mamir\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bowl","role_str":""},{"pid":10592,"title":"Tom Westley","short_name":"TZ Westley","first_name":"Tom Westley","last_name":"","middle_name":"","birthdate":"1989-03-13","birthplace":"Cambridge","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":10602,"title":"Nick Browne","short_name":"NLJ Browne","first_name":"Nick Browne","last_name":"","middle_name":"","birthdate":"1991-03-24","birthplace":"Leytonstone, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":10606,"title":"Jake Ball","short_name":"JT Ball","first_name":"Jake Ball","last_name":"","middle_name":"","birthdate":"1991-03-14","birthplace":"Mansfield, Nottinghamshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":18974,"recent_appearance":1517109600,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/jakeball","instagram_profile":"https:\/\/www.instagram.com\/jakeball\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":48647,"title":"Matt Critchley","short_name":"MJJ Critchley","first_name":"Matt Critchley","last_name":"","middle_name":"","birthdate":"1996-08-13","birthplace":"Preston, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/mattcritchley96","instagram_profile":"https:\/\/www.instagram.com\/critch130896\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":48656,"title":"Tom Kohler-Cadmore","short_name":"TK Cadmore","first_name":"Tom Kohler-Cadmore","last_name":"","middle_name":"","birthdate":"1994-08-19","birthplace":" Chatham, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/tomkholerCadmore32\/","twitter_profile":"https:\/\/twitter.com\/TomKCadmore32","instagram_profile":"https:\/\/www.instagram.com\/tomkcadmore","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":49015,"title":"Andrew Umeed","short_name":"ARI Umeed","first_name":"Andrew Umeed","last_name":"","middle_name":"","birthdate":"1996-04-19","birthplace":"Glasgow, Lanarkshire","country":"sct","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Scotland","role":"squad","role_str":""},{"pid":49083,"title":"Dean Elgar","short_name":"D Elgar","first_name":"Dean Elgar","last_name":"","middle_name":"","birthdate":"1987-06-11","birthplace":"Welkom, Orange Free state","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":36249,"recent_appearance":1514287800,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BoringDeanElgar","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":49087,"title":"Simon Harmer","short_name":"SR Harmer","first_name":"Simon Harmer","last_name":"","middle_name":"","birthdate":"1989-02-10","birthplace":"Pretoria, Transvaal","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Simon_Harmer_","instagram_profile":"https:\/\/www.instagram.com\/simon_harmer\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bowl","role_str":"(C)"},{"pid":49376,"title":"Adam Rossington","short_name":"AM Rossington","first_name":"Adam Rossington","last_name":"","middle_name":"","birthdate":"1993-05-05","birthplace":"Edgware, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper ","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Rossington17","instagram_profile":"https:\/\/www.instagram.com\/rossington17\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49413,"title":"Tom Abell","short_name":"TB Abell","first_name":"Tom Abell","last_name":"","middle_name":"","birthdate":"1994-03-05","birthplace":"Taunton, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/tomabell1","instagram_profile":"https:\/\/www.instagram.com\/tabell28\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":49421,"title":"Lewis Gregory","short_name":"L Gregory","first_name":"Lewis Gregory","last_name":"","middle_name":"","birthdate":"1992-05-24","birthplace":"Plymouth","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/lewisgregory23\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":"(C)"},{"pid":49425,"title":"Jack Leach","short_name":"J Leach","first_name":"Jack Leach","last_name":"","middle_name":"","birthdate":"1991-06-22","birthplace":" Taunton, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/jackleach1991?lang=gu","instagram_profile":"https:\/\/www.instagram.com\/mjleach17\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49593,"title":"Jamie Porter","short_name":"JA Porter","first_name":"Jamie Porter","last_name":"","middle_name":"","birthdate":"1993-05-25","birthplace":"Leytonstone, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","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":""},{"pid":49823,"title":"Sean Dickson","short_name":"SR Dickson","first_name":"Sean Dickson","last_name":"","middle_name":"","birthdate":"1991-09-02","birthplace":"Johannesburg, Transvaal","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bat","role_str":""},{"pid":51105,"title":"Michael-Kyle Pepper","short_name":"MKS Pepper","first_name":"Michael-Kyle Pepper","last_name":"","middle_name":"","birthdate":"1998-06-25","birthplace":"Harlow, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/michael_pep\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":""},{"pid":51266,"title":"Tom Banton","short_name":"T Banton","first_name":"Tom Banton","last_name":"","middle_name":"","birthdate":"1998-11-11","birthplace":"Chiltern, Buckinghamshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/OfficialTomBanton\/","twitter_profile":"https:\/\/twitter.com\/tbanton18","instagram_profile":"https:\/\/www.instagram.com\/tombanton\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":51346,"title":"Paul Walter","short_name":"PI Walter","first_name":"Paul Walter","last_name":"","middle_name":"","birthdate":"1994-05-28","birthplace":"Basildon, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":57592,"title":"Migael Pretorius","short_name":"M Pretorius","first_name":"Migael Pretorius","last_name":"","middle_name":"","birthdate":"1995-03-24","birthplace":"Vereeninging","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"https:\/\/www.facebook.com\/migael27\/","twitter_profile":"https:\/\/twitter.com\/migael_27","instagram_profile":"https:\/\/www.instagram.com\/migael27\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":61358,"title":"Shane Snater","short_name":"S Snater","first_name":"Shane Snater","last_name":"","middle_name":"","birthdate":"1996-03-24","birthplace":"Harare, Zimbabwe","country":"nl","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"squad","role_str":""},{"pid":68691,"title":"Samuel Cook","short_name":"S Cook","first_name":"Samuel Cook","last_name":"","middle_name":"","birthdate":"1997-08-04","birthplace":"Chelmsford, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/samcook09","instagram_profile":"https:\/\/www.instagram.com\/s_cook16\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":93329,"title":"Riley Meredith","short_name":"RP Meredith","first_name":"Riley Meredith","last_name":"","middle_name":"","birthdate":"1996-06-21","birthplace":"Hobart, Tasmania","country":"au","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/rileymeredith_\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"bowl","role_str":""},{"pid":93520,"title":"Tom Lammonby","short_name":"TA Lammonby","first_name":"Tom Lammonby","last_name":"","middle_name":"","birthdate":"2000-06-02","birthplace":" Exeter, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/TomLammonby","instagram_profile":"https:\/\/www.instagram.com\/tom_lammonby\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":94961,"title":"Jordan Cox","short_name":"J Cox","first_name":"Jordan Cox","last_name":"","middle_name":"","birthdate":"2000-10-21","birthplace":"Margate, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/jjordancox\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":95554,"title":"Lewis Goldsworthy","short_name":"L Goldsworthy","first_name":"Lewis Goldsworthy","last_name":"","middle_name":"","birthdate":"2001-01-08","birthplace":" Cornwall","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lewigoldsworthy","instagram_profile":"https:\/\/www.instagram.com\/lewisgoldsworthy\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":103052,"title":"Will Smeed","short_name":"W Smeed","first_name":"Will Smeed","last_name":"","middle_name":"","birthdate":"2001-10-26","birthplace":"Cambridge","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/will_smeed","instagram_profile":"https:\/\/www.instagram.com\/willsmeed\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":103358,"title":"Robin Das","short_name":"RJ Das","first_name":"Robin Das","last_name":"","middle_name":"","birthdate":"2002-02-27","birthplace":"Leytonstone","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"https:\/\/www.facebook.com\/robindascricketer","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/robinigblue\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":108393,"title":"Jamal Richards","short_name":"J Richards","first_name":"Jamal Richards","last_name":"","middle_name":"","birthdate":"2004-03-03","birthplace":"Edmonton, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108408,"title":"James Rew","short_name":"J Rew","first_name":"James Rew","last_name":"","middle_name":"","birthdate":"2004-01-11","birthplace":" London","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/cjrew89\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108410,"title":"Joshua Thomas","short_name":"J Thomas","first_name":"Joshua Thomas","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108420,"title":"Luc Benkenstein","short_name":"L Benkenstein","first_name":"Luc Benkenstein","last_name":"","middle_name":"","birthdate":"2004-11-02","birthplace":"Durban","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":127517,"title":"Noah Thain","short_name":"NRM Thain","first_name":"Noah Thain","last_name":"","middle_name":"","birthdate":"2005-01-13","birthplace":"Hitchinbrooke, Hertfordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":129447,"title":"Mackenzie Jones","short_name":"Mackenzie Jones","first_name":"Mackenzie Jones","last_name":"","middle_name":"","birthdate":"2005-03-06","birthplace":"","country":"sct","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Scotland","role":"squad","role_str":""},{"pid":129894,"title":"JT Langridge","short_name":"JT Langridge","first_name":"JT Langridge","last_name":"","middle_name":"","birthdate":"2005-11-03","birthplace":" Plymouth, Devon,","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":130425,"title":"Finley Hill","short_name":"F Hill","first_name":"Finley Hill","last_name":"","middle_name":"","birthdate":"2006-06-21","birthplace":" Exeter, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":134958,"title":"Charles Allison","short_name":"CW Allison","first_name":"Charles Allison","last_name":"","middle_name":"","birthdate":"2005-03-02","birthplace":"Colchester, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":137372,"title":"Archie Vaughan","short_name":"A Vaughan","first_name":"Archie Vaughan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":141341,"title":"Simon Fernandes","short_name":"Simon Fernandes","first_name":"Simon Fernandes","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":146438,"title":"Thomas Rew","short_name":"T Rew","first_name":"Thomas Rew","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":150399,"title":"Charlie Edward Bennett","short_name":"CE Bennett","first_name":"Charlie Edward Bennett","last_name":"","middle_name":"","birthdate":"2006-05-01","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""}]},"etag":"f9bc9c47ec463a2b2b58bc1b7e6b7cb2","modified":"2025-07-16 03:41:46","datetime":"2025-07-16 03:41:46","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86909 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:d768c36c-8c41-43bf-9941-26fcdeb2c78e
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86909 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86909,3,'{"status":"ok","response":{"match_id":86909,"title":"Somerset vs Essex","short_title":"SOM vs ESS","subtitle":"Match 89","match_number":"89","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Somerset won by 95 runs","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129425,"title":"Vitality Blast","abbr":"Vitality Blast","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-09-13","country":"en","total_matches":"133","total_rounds":"2","total_teams":"18"},"teama":{"team_id":7010,"name":"Somerset","short_name":"SOM","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/somerset-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/somerset-logo.png","scores_full":"225\/6 (20 ov)","scores":"225\/6","overs":"20"},"teamb":{"team_id":104950,"name":"Essex","short_name":"ESS","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","scores_full":"130\/10 (14.1 ov)","scores":"130\/10","overs":"14.1"},"date_start":"2025-07-08 17:30:00","date_end":"2025-07-09 03:30:00","timestamp_start":1751995800,"timestamp_end":1752031800,"date_start_ist":"2025-07-08 23:00:00","date_end_ist":"2025-07-09 09:00:00","venue":{"venue_id":"40","name":"The Cooper Associates County Ground, Taunton","location":"Taunton","country":"England","timezone":""},"umpires":"Mike Burns (England), Jack Shantry (England), Paul Baldwin (England, TV)","referee":"Wayne Noon (England)","equation":"","live":"","result":"SOM won by 95 runs","result_type":1,"win_margin":"95 runs","winning_team_id":7010,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-07-06 20:32:31","verify_time":"2025-07-09 01:44:57","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"","weather_desc":"","temp":"","humidity":"","visibility":"","wind_speed":"","clouds":""},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"High Scoring","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Essex elected to bowl","winner":104950,"decision":2}},"etag":"d8a924425891e5d3aaf7a33a6b88ed39","modified":"2025-07-16 03:41:47","datetime":"2025-07-16 03:41:47","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":86909,"title":"Somerset vs Essex","short_title":"SOM vs ESS","subtitle":"Match 89","match_number":"89","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Somerset won by 95 runs","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129425,"title":"Vitality Blast","abbr":"Vitality Blast","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-09-13","country":"en","total_matches":"133","total_rounds":"2","total_teams":"18"},"teama":{"team_id":7010,"name":"Somerset","short_name":"SOM","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/somerset-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/somerset-logo.png","scores_full":"225\/6 (20 ov)","scores":"225\/6","overs":"20"},"teamb":{"team_id":104950,"name":"Essex","short_name":"ESS","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","scores_full":"130\/10 (14.1 ov)","scores":"130\/10","overs":"14.1"},"date_start":"2025-07-08 17:30:00","date_end":"2025-07-09 03:30:00","timestamp_start":1751995800,"timestamp_end":1752031800,"date_start_ist":"2025-07-08 23:00:00","date_end_ist":"2025-07-09 09:00:00","venue":{"venue_id":"40","name":"The Cooper Associates County Ground, Taunton","location":"Taunton","country":"England","timezone":""},"umpires":"Mike Burns (England), Jack Shantry (England), Paul Baldwin (England, TV)","referee":"Wayne Noon (England)","equation":"","live":"","result":"SOM won by 95 runs","result_type":1,"win_margin":"95 runs","winning_team_id":7010,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-07-06 20:32:31","verify_time":"2025-07-09 01:44:57","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"","weather_desc":"","temp":"","humidity":"","visibility":"","wind_speed":"","clouds":""},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"High Scoring","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Essex elected to bowl","winner":104950,"decision":2}},"etag":"d8a924425891e5d3aaf7a33a6b88ed39","modified":"2025-07-16 03:41:47","datetime":"2025-07-16 03:41:47","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86909 AND DataTypeId = 3 END Live Report & Scorecard of Somerset vs Essex Match 89
Somerset vs Essex, Live Cricket Commentary