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:21fa5d73-3aac-4dd2-b982-69ba10def43a Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86861 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86861,1,'{"status":"ok","response":{"mid":86861,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Somerset won by 5 wickets","day_remaining_over":"","team_batting":"Somerset","team_bowling":"Middlesex","live_inning_number":2,"live_score":{"runs":235,"overs":19.2,"wickets":5,"target":230,"runrate":12.16,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Lewis Gregory","batsman_id":49421,"runs":58,"balls_faced":23,"fours":3,"sixes":6,"strike_rate":"252.17"},{"name":"Ben Green","batsman_id":1049,"runs":27,"balls_faced":15,"fours":4,"sixes":0,"strike_rate":"180.00"}],"bowlers":[{"name":"Noah Cornwell","bowler_id":140007,"overs":3.2,"runs_conceded":36,"wickets":2,"maidens":0,"econ":"10.80"},{"name":"Tom Helm","bowler_id":49497,"overs":4,"runs_conceded":51,"wickets":0,"maidens":0,"econ":"12.75"}],"commentaries":[{"event_id":"12130085","event":"ball","batsman_id":"49823","bowler_id":"49497","over":"15","ball":"1","score":1,"commentary":"Tom Helm to Sean Dickson, 1 run,","noball_dismissal":false,"text":"","timestamp":1749758614,"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":"12130086","event":"ball","batsman_id":"49421","bowler_id":"49497","over":"15","ball":"2","score":0,"commentary":"Tom Helm to Lewis Gregory, no run,","noball_dismissal":false,"text":"","timestamp":1749758624,"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":"12130091","event":"ball","batsman_id":"49421","bowler_id":"49497","over":"15","ball":"3","score":0,"commentary":"Tom Helm to Lewis Gregory, no run,","noball_dismissal":false,"text":"","timestamp":1749758657,"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":"12130098","event":"ball","batsman_id":"49421","bowler_id":"49497","over":"15","ball":"4","score":1,"commentary":"Tom Helm to Lewis Gregory, 1 run,","noball_dismissal":false,"text":"","timestamp":1749758718,"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":"12130099","event":"ball","batsman_id":"49823","bowler_id":"49497","over":"15","ball":"5","score":1,"commentary":"Tom Helm to Sean Dickson, 1 run,","noball_dismissal":false,"text":"","timestamp":1749758728,"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":"12130106","event":"ball","batsman_id":"49421","bowler_id":"49497","over":"15","ball":"6","score":6,"commentary":"Tom Helm to Lewis Gregory, Six,","noball_dismissal":false,"text":"","timestamp":1749758787,"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":"overend","over":16,"runs":9,"score":"192\/4","bats":[{"runs":44,"balls_faced":19,"fours":3,"sixes":4,"batsman_id":49421},{"runs":76,"balls_faced":37,"fours":6,"sixes":5,"batsman_id":49823}],"bowls":[{"runs_conceded":34,"maidens":0,"wickets":0,"bowler_id":49497,"overs":3},{"runs_conceded":64,"maidens":0,"wickets":0,"bowler_id":44058,"overs":4}],"commentary":"End of over 16 (9 runs), Somerset 192\/4"},{"event_id":"12130117","event":"wicket","batsman_id":"49823","bowler_id":"93519","over":"16","ball":"1","score":"w","commentary":"Luke Hollman to Sean Dickson, no run, c (sub JB Cracknell) b LBK Hollman,","noball_dismissal":false,"text":"","timestamp":1749758990,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"49823","how_out":"c (sub JB Cracknell) b LBK Hollman","batsman_runs":"76","batsman_balls":"38"},{"event_id":"12130119","event":"ball","batsman_id":"1049","bowler_id":"93519","over":"16","ball":"2","score":0,"commentary":"Luke Hollman to Ben Green, no run,","noball_dismissal":false,"text":"","timestamp":1749758994,"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":"12130121","event":"ball","batsman_id":"1049","bowler_id":"93519","over":"16","ball":"3","score":1,"commentary":"Luke Hollman to Ben Green, 1 run,","noball_dismissal":false,"text":"","timestamp":1749758998,"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":"12130122","event":"ball","batsman_id":"49421","bowler_id":"93519","over":"16","ball":"4","score":1,"commentary":"Luke Hollman to Lewis Gregory, 1 run,","noball_dismissal":false,"text":"","timestamp":1749759007,"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":"12130126","event":"ball","batsman_id":"1049","bowler_id":"93519","over":"16","ball":"5","score":1,"commentary":"Luke Hollman to Ben Green, 1 run,","noball_dismissal":false,"text":"","timestamp":1749759018,"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":"12130127","event":"ball","batsman_id":"49421","bowler_id":"93519","over":"16","ball":"6","score":6,"commentary":"Luke Hollman to Lewis Gregory, Six,","noball_dismissal":false,"text":"","timestamp":1749759031,"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":"overend","over":17,"runs":9,"score":"201\/5","bats":[{"runs":51,"balls_faced":21,"fours":3,"sixes":5,"batsman_id":49421},{"runs":2,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":1049}],"bowls":[{"runs_conceded":49,"maidens":0,"wickets":2,"bowler_id":93519,"overs":4},{"runs_conceded":34,"maidens":0,"wickets":0,"bowler_id":49497,"overs":3}],"commentary":"End of over 17 (9 runs), Somerset 201\/5"},{"event_id":"12130135","event":"ball","batsman_id":"1049","bowler_id":"49930","over":"17","ball":"1","score":4,"commentary":"Ryan Higgins to Ben Green, Four,","noball_dismissal":false,"text":"","timestamp":1749759131,"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":"12130139","event":"ball","batsman_id":"1049","bowler_id":"49930","over":"17","ball":"2","score":2,"commentary":"Ryan Higgins to Ben Green, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749759142,"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":"12130141","event":"ball","batsman_id":"1049","bowler_id":"49930","over":"17","ball":"3","score":1,"commentary":"Ryan Higgins to Ben Green, 1 run,","noball_dismissal":false,"text":"","timestamp":1749759176,"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":"12130152","event":"ball","batsman_id":"49421","bowler_id":"49930","over":"17","ball":"4","score":1,"commentary":"Ryan Higgins to Lewis Gregory, 1 run,","noball_dismissal":false,"text":"","timestamp":1749759277,"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":"12130154","event":"ball","batsman_id":"1049","bowler_id":"49930","over":"17","ball":"5","score":0,"commentary":"Ryan Higgins to Ben Green, no run,","noball_dismissal":false,"text":"","timestamp":1749759281,"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":"12130155","event":"ball","batsman_id":"1049","bowler_id":"49930","over":"17","ball":"6","score":1,"commentary":"Ryan Higgins to Ben Green, 1 run,","noball_dismissal":false,"text":"","timestamp":1749759293,"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":18,"runs":9,"score":"210\/5","bats":[{"runs":10,"balls_faced":8,"fours":1,"sixes":0,"batsman_id":1049},{"runs":52,"balls_faced":22,"fours":3,"sixes":5,"batsman_id":49421}],"bowls":[{"runs_conceded":31,"maidens":0,"wickets":1,"bowler_id":49930,"overs":4},{"runs_conceded":49,"maidens":0,"wickets":2,"bowler_id":93519,"overs":4}],"commentary":"End of over 18 (9 runs), Somerset 210\/5"},{"event_id":"12130163","event":"ball","batsman_id":"1049","bowler_id":"49497","over":"18","ball":"1","score":2,"commentary":"Tom Helm to Ben Green, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749759390,"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":"12130165","event":"ball","batsman_id":"1049","bowler_id":"49497","over":"18","ball":"2","score":4,"commentary":"Tom Helm to Ben Green, Four,","noball_dismissal":false,"text":"","timestamp":1749759394,"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":"12130169","event":"ball","batsman_id":"1049","bowler_id":"49497","over":"18","ball":"3","score":2,"commentary":"Tom Helm to Ben Green, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749759433,"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":"12130176","event":"ball","batsman_id":"1049","bowler_id":"49497","over":"18","ball":"4","score":4,"commentary":"Tom Helm to Ben Green, Four,","noball_dismissal":false,"text":"","timestamp":1749759489,"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":"12130183","event":"ball","batsman_id":"1049","bowler_id":"49497","over":"18","ball":"5","score":4,"commentary":"Tom Helm to Ben Green, Four,","noball_dismissal":false,"text":"","timestamp":1749759548,"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":"12130185","event":"ball","batsman_id":"1049","bowler_id":"49497","over":"18","ball":"6","score":1,"commentary":"Tom Helm to Ben Green, 1 run,","noball_dismissal":false,"text":"","timestamp":1749759581,"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":19,"runs":17,"score":"227\/5","bats":[{"runs":27,"balls_faced":14,"fours":4,"sixes":0,"batsman_id":1049},{"runs":52,"balls_faced":22,"fours":3,"sixes":5,"batsman_id":49421}],"bowls":[{"runs_conceded":51,"maidens":0,"wickets":0,"bowler_id":49497,"overs":4},{"runs_conceded":31,"maidens":0,"wickets":1,"bowler_id":49930,"overs":4}],"commentary":"End of over 19 (17 runs), Somerset 227\/5"},{"event_id":"12130199","event":"ball","batsman_id":"1049","bowler_id":"140007","over":"19","ball":"1","score":"1lb","commentary":"Noah Cornwell to Ben Green, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1749759704,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"1","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12130200","event":"ball","batsman_id":"49421","bowler_id":"140007","over":"19","ball":"2","score":"1wd","commentary":"Noah Cornwell to Lewis Gregory, 1 wide,","noball_dismissal":false,"text":"","timestamp":1749759708,"run":1,"noball_run":"0","wide_run":"1","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12130203","event":"ball","batsman_id":"49421","bowler_id":"140007","over":"19","ball":"2","score":6,"commentary":"Noah Cornwell to Lewis Gregory, Six,","noball_dismissal":false,"text":"","timestamp":1749759768,"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}],"day":"0","session":"0","live_inning":{"iid":197936,"number":2,"name":"Somerset Inning","short_name":"SOM Inning","status":2,"issuperover":"false","result":3,"batting_team_id":7010,"fielding_team_id":7044,"scores":"235\/5","scores_full":"235\/5 (19.2 ov)","fielder":[{"fielder_id":"93519","fielder_name":"Luke Hollman","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"53281","fielder_name":"Leus du Plooy","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"101478","fielder_name":"Joe Benjamin Cracknell","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"true"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Sean Dickson","batsman_id":"49823","runs":"76","balls":"38","how_out":"c (sub JB Cracknell) b LBK Hollman","score_at_dismissal":192,"overs_at_dismissal":"16.1","bowler_id":"93519","dismissal":"caught","number":5},"extra_runs":{"byes":0,"legbyes":3,"wides":4,"noballs":2,"penalty":"0","total":9},"equations":{"runs":235,"wickets":5,"overs":"19.2","bowlers_used":5,"runrate":"12.16"},"current_partnership":{"runs":43,"balls":19,"overs":3.1,"batsmen":[{"name":"Ben Green","batsman_id":1049,"runs":27,"balls":15},{"name":"Lewis Gregory","batsman_id":49421,"runs":14,"balls":4}]},"did_not_bat":[{"player_id":"95554","name":"Lewis Goldsworthy"},{"player_id":"49733","name":"Craig Overton"},{"player_id":"486","name":"Matt Henry"},{"player_id":"93329","name":"Riley Meredith"}],"max_over":"20","target":"230","recent_scores":"6,1,1,1,4,4,2,4,2,1,0,1,1,2,4,6,1,1","last_five_overs":"72\/1 13.94","last_ten_overs":"144\/1 13.71"},"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":"235\/5 (19.2 ov)","scores":"235\/5","overs":"19.2"},{"tid":7044,"title":"Middlesex","abbr":"MID","alt_name":"MID","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/middlesex-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/middlesex-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"229\/5 (20 ov)","scores":"229\/5","overs":"20"}],"players":[{"pid":31,"title":"Kane Williamson","short_name":"K Williamson","first_name":"Kane Williamson","last_name":"","middle_name":"","birthdate":"1990-08-08","birthplace":"Tauranga","country":"nz","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":"https:\/\/www.facebook.com\/KaneWillTrain\/","twitter_profile":"https:\/\/twitter.com\/KaneWiliamson","instagram_profile":"https:\/\/www.instagram.com\/kane_s_w\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bat","role_str":""},{"pid":301,"title":"Josh Davey","short_name":"J Davey","first_name":"Josh Davey","last_name":"","middle_name":"","birthdate":"1990-08-03","birthplace":"Aberdeen, United Kingdom","country":"sct","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bowl","role_str":""},{"pid":1043,"title":"Max Holden","short_name":"MDE Holden","first_name":"Max Holden","last_name":"","middle_name":"","birthdate":"1997-12-18","birthplace":" Cambridge","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/maxholden_4","instagram_profile":"https:\/\/www.instagram.com\/maxholden4\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":1049,"title":"Ben Green","short_name":"BGF Green","first_name":"Ben Green","last_name":"","middle_name":"","birthdate":"1997-09-28","birthplace":"Exeter, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":1115,"title":"Josh Little","short_name":"JB Little","first_name":"Josh Little","last_name":"","middle_name":"","birthdate":"1999-11-01","birthplace":"Dublin","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/joshlittle13\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":44058,"title":"Zafar Gohar","short_name":"ZG Gohar","first_name":"Zafar Gohar","last_name":"","middle_name":"","birthdate":"1995-02-01","birthplace":"Lahore, Punjab","country":"pk","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":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/iamzafargohar","instagram_profile":"https:\/\/www.instagram.com\/iamzafargohar\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bowl","role_str":""},{"pid":48656,"title":"Tom Kohler-Cadmore","short_name":"TK Cadmore","first_name":"Tom Kohler-Cadmore","last_name":"","middle_name":"","birthdate":"1994-08-19","birthplace":" Chatham, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/tomkholerCadmore32\/","twitter_profile":"https:\/\/twitter.com\/TomKCadmore32","instagram_profile":"https:\/\/www.instagram.com\/tomkcadmore","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":49015,"title":"Andrew Umeed","short_name":"ARI Umeed","first_name":"Andrew Umeed","last_name":"","middle_name":"","birthdate":"1996-04-19","birthplace":"Glasgow, Lanarkshire","country":"sct","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Scotland","role":"squad","role_str":""},{"pid":49413,"title":"Tom Abell","short_name":"TB Abell","first_name":"Tom Abell","last_name":"","middle_name":"","birthdate":"1994-03-05","birthplace":"Taunton, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/tomabell1","instagram_profile":"https:\/\/www.instagram.com\/tabell28\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":49421,"title":"Lewis Gregory","short_name":"L Gregory","first_name":"Lewis Gregory","last_name":"","middle_name":"","birthdate":"1992-05-24","birthplace":"Plymouth","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/lewisgregory23\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":"(C)"},{"pid":49425,"title":"Jack Leach","short_name":"J Leach","first_name":"Jack Leach","last_name":"","middle_name":"","birthdate":"1991-06-22","birthplace":" Taunton, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/jackleach1991?lang=gu","instagram_profile":"https:\/\/www.instagram.com\/mjleach17\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49493,"title":"Sam Robson","short_name":"SD Robson","first_name":"Sam Robson","last_name":"","middle_name":"","birthdate":"1989-07-01","birthplace":"Paddington, Sydney, New South Wales","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"https:\/\/www.facebook.com\/samrobson664\/","twitter_profile":"https:\/\/twitter.com\/Samrobsonfans12","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49497,"title":"Tom Helm","short_name":"TG Helm","first_name":"Tom Helm","last_name":"","middle_name":"","birthdate":"1994-05-07","birthplace":"Stoke Mandeville Hospital, Buckinghamshire","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":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/TomHelm7","instagram_profile":"https:\/\/www.instagram.com\/helmy__7\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":49733,"title":"Craig Overton","short_name":"C Overton","first_name":"Craig Overton","last_name":"","middle_name":"","birthdate":"1994-04-10","birthplace":"Barnstaple, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/craigoverton12","instagram_profile":"https:\/\/www.instagram.com\/craigoverton12\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":49783,"title":"Toby Roland-Jones","short_name":"TS Roland-Jones","first_name":"Toby Roland-Jones","last_name":"","middle_name":"","birthdate":"1988-01-29","birthplace":"Ashford, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/tobyrj21","instagram_profile":"https:\/\/www.instagram.com\/tobyrj21\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49823,"title":"Sean Dickson","short_name":"SR Dickson","first_name":"Sean Dickson","last_name":"","middle_name":"","birthdate":"1991-09-02","birthplace":"Johannesburg, Transvaal","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bat","role_str":""},{"pid":49930,"title":"Ryan Higgins","short_name":"RF Higgins","first_name":"Ryan Higgins","last_name":"","middle_name":"","birthdate":"1995-01-06","birthplace":"Harare, Zimbabwe","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":51266,"title":"Tom Banton","short_name":"T Banton","first_name":"Tom Banton","last_name":"","middle_name":"","birthdate":"1998-11-11","birthplace":"Chiltern, Buckinghamshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/OfficialTomBanton\/","twitter_profile":"https:\/\/twitter.com\/tbanton18","instagram_profile":"https:\/\/www.instagram.com\/tombanton\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":53281,"title":"Leus du Plooy","short_name":"JLdu Plooy","first_name":"Leus du Plooy","last_name":"","middle_name":"","birthdate":"1995-01-12","birthplace":"Pretoria, Gauteng,","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/leusdup76","instagram_profile":"https:\/\/www.instagram.com\/leusdup76\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bat","role_str":""},{"pid":57592,"title":"Migael Pretorius","short_name":"M Pretorius","first_name":"Migael Pretorius","last_name":"","middle_name":"","birthdate":"1995-03-24","birthplace":"Vereeninging","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/migael27\/","twitter_profile":"https:\/\/twitter.com\/migael_27","instagram_profile":"https:\/\/www.instagram.com\/migael27\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":90974,"title":"Henry Brookes","short_name":"HJH Brookes","first_name":"Henry Brookes","last_name":"","middle_name":"","birthdate":"1999-08-21","birthplace":"Solihull, Warwickshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BrookesHenry","instagram_profile":"https:\/\/www.instagram.com\/henry.brookes\/","debut_data":"","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":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"bowl","role_str":""},{"pid":93517,"title":"Jack Davies","short_name":"JLB Davies","first_name":"Jack Davies","last_name":"","middle_name":"","birthdate":"2000-03-30","birthplace":"Reading, Berkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/daviesjlb","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":93519,"title":"Luke Hollman","short_name":"LBK Hollman","first_name":"Luke Hollman","last_name":"","middle_name":"","birthdate":"2000-09-16","birthplace":"Islington, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/lukehollman56\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":93520,"title":"Tom Lammonby","short_name":"TA Lammonby","first_name":"Tom Lammonby","last_name":"","middle_name":"","birthdate":"2000-06-02","birthplace":" Exeter, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/TomLammonby","instagram_profile":"https:\/\/www.instagram.com\/tom_lammonby\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95550,"title":"Kasey Aldridge","short_name":"K Aldridge","first_name":"Kasey Aldridge","last_name":"","middle_name":"","birthdate":"2000-12-24","birthplace":"Bristol","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/kcaldridge5\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95552,"title":"Blake Cullen","short_name":"B Cullen","first_name":"Blake Cullen","last_name":"","middle_name":"","birthdate":"2002-02-19","birthplace":" Isleworth, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95554,"title":"Lewis Goldsworthy","short_name":"L Goldsworthy","first_name":"Lewis Goldsworthy","last_name":"","middle_name":"","birthdate":"2001-01-08","birthplace":" Cornwall","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lewigoldsworthy","instagram_profile":"https:\/\/www.instagram.com\/lewisgoldsworthy\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":101478,"title":"Joe Benjamin Cracknell","short_name":"JB Cracknell","first_name":"Joe Benjamin Cracknell","last_name":"","middle_name":"","birthdate":"2000-03-16","birthplace":"Enfield, 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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/joe_cracknell\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":102540,"title":"Stephen Eskinazi","short_name":"S Eskinazi","first_name":"Stephen Eskinazi","last_name":"","middle_name":"","birthdate":"1994-03-28","birthplace":"Johannesburg, Transvaal, South Africa","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":"https:\/\/twitter.com\/seskinazi","instagram_profile":"https:\/\/www.instagram.com\/seskinazi\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(C)"},{"pid":103052,"title":"Will Smeed","short_name":"W Smeed","first_name":"Will Smeed","last_name":"","middle_name":"","birthdate":"2001-10-26","birthplace":"Cambridge","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/will_smeed","instagram_profile":"https:\/\/www.instagram.com\/willsmeed\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":108382,"title":"Ben Geddes","short_name":"B Geddes","first_name":"Ben Geddes","last_name":"","middle_name":"","birthdate":"2001-07-31","birthplace":"Epsom, Surrey","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":108408,"title":"James Rew","short_name":"J Rew","first_name":"James Rew","last_name":"","middle_name":"","birthdate":"2004-01-11","birthplace":" London","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/cjrew89\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108410,"title":"Joshua Thomas","short_name":"J Thomas","first_name":"Joshua Thomas","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":116661,"title":"Ishaan Kaushal","short_name":"I Kaushal","first_name":"Ishaan Kaushal","last_name":"","middle_name":"","birthdate":"2002-02-09","birthplace":"Hillingdon, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":127503,"title":"Josh De Caires","short_name":"J D caires","first_name":"Josh De Caires","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":129244,"title":"Nathan Fernandes","short_name":"N Fernandes","first_name":"Nathan Fernandes","last_name":"","middle_name":"","birthdate":"2004-04-26","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":129894,"title":"JT Langridge","short_name":"JT Langridge","first_name":"JT Langridge","last_name":"","middle_name":"","birthdate":"2005-11-03","birthplace":" Plymouth, Devon,","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":130425,"title":"Finley Hill","short_name":"F Hill","first_name":"Finley Hill","last_name":"","middle_name":"","birthdate":"2006-06-21","birthplace":" Exeter, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":133782,"title":"Sebastian Morgan","short_name":"SB Morgan","first_name":"Sebastian Morgan","last_name":"","middle_name":"","birthdate":"2007-08-30","birthplace":"","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":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":137372,"title":"Archie Vaughan","short_name":"A Vaughan","first_name":"Archie Vaughan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":140007,"title":"Noah Cornwell","short_name":"N Cornwell","first_name":"Noah Cornwell","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":146167,"title":"Aaryan Sawant","short_name":"A Sawant","first_name":"Aaryan Sawant","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":146171,"title":"Naavya Sharma","short_name":"N Sharma","first_name":"Naavya Sharma","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":146438,"title":"Thomas Rew","short_name":"T Rew","first_name":"Thomas Rew","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""}]},"etag":"d7cee738271af250f9025ee34420e221","modified":"2025-07-29 17:44:26","datetime":"2025-07-29 17:44:26","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":86861,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Somerset won by 5 wickets","day_remaining_over":"","team_batting":"Somerset","team_bowling":"Middlesex","live_inning_number":2,"live_score":{"runs":235,"overs":19.2,"wickets":5,"target":230,"runrate":12.16,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Lewis Gregory","batsman_id":49421,"runs":58,"balls_faced":23,"fours":3,"sixes":6,"strike_rate":"252.17"},{"name":"Ben Green","batsman_id":1049,"runs":27,"balls_faced":15,"fours":4,"sixes":0,"strike_rate":"180.00"}],"bowlers":[{"name":"Noah Cornwell","bowler_id":140007,"overs":3.2,"runs_conceded":36,"wickets":2,"maidens":0,"econ":"10.80"},{"name":"Tom Helm","bowler_id":49497,"overs":4,"runs_conceded":51,"wickets":0,"maidens":0,"econ":"12.75"}],"commentaries":[{"event_id":"12130085","event":"ball","batsman_id":"49823","bowler_id":"49497","over":"15","ball":"1","score":1,"commentary":"Tom Helm to Sean Dickson, 1 run,","noball_dismissal":false,"text":"","timestamp":1749758614,"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":"12130086","event":"ball","batsman_id":"49421","bowler_id":"49497","over":"15","ball":"2","score":0,"commentary":"Tom Helm to Lewis Gregory, no run,","noball_dismissal":false,"text":"","timestamp":1749758624,"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":"12130091","event":"ball","batsman_id":"49421","bowler_id":"49497","over":"15","ball":"3","score":0,"commentary":"Tom Helm to Lewis Gregory, no run,","noball_dismissal":false,"text":"","timestamp":1749758657,"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":"12130098","event":"ball","batsman_id":"49421","bowler_id":"49497","over":"15","ball":"4","score":1,"commentary":"Tom Helm to Lewis Gregory, 1 run,","noball_dismissal":false,"text":"","timestamp":1749758718,"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":"12130099","event":"ball","batsman_id":"49823","bowler_id":"49497","over":"15","ball":"5","score":1,"commentary":"Tom Helm to Sean Dickson, 1 run,","noball_dismissal":false,"text":"","timestamp":1749758728,"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":"12130106","event":"ball","batsman_id":"49421","bowler_id":"49497","over":"15","ball":"6","score":6,"commentary":"Tom Helm to Lewis Gregory, Six,","noball_dismissal":false,"text":"","timestamp":1749758787,"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":"overend","over":16,"runs":9,"score":"192\/4","bats":[{"runs":44,"balls_faced":19,"fours":3,"sixes":4,"batsman_id":49421},{"runs":76,"balls_faced":37,"fours":6,"sixes":5,"batsman_id":49823}],"bowls":[{"runs_conceded":34,"maidens":0,"wickets":0,"bowler_id":49497,"overs":3},{"runs_conceded":64,"maidens":0,"wickets":0,"bowler_id":44058,"overs":4}],"commentary":"End of over 16 (9 runs), Somerset 192\/4"},{"event_id":"12130117","event":"wicket","batsman_id":"49823","bowler_id":"93519","over":"16","ball":"1","score":"w","commentary":"Luke Hollman to Sean Dickson, no run, c (sub JB Cracknell) b LBK Hollman,","noball_dismissal":false,"text":"","timestamp":1749758990,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"49823","how_out":"c (sub JB Cracknell) b LBK Hollman","batsman_runs":"76","batsman_balls":"38"},{"event_id":"12130119","event":"ball","batsman_id":"1049","bowler_id":"93519","over":"16","ball":"2","score":0,"commentary":"Luke Hollman to Ben Green, no run,","noball_dismissal":false,"text":"","timestamp":1749758994,"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":"12130121","event":"ball","batsman_id":"1049","bowler_id":"93519","over":"16","ball":"3","score":1,"commentary":"Luke Hollman to Ben Green, 1 run,","noball_dismissal":false,"text":"","timestamp":1749758998,"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":"12130122","event":"ball","batsman_id":"49421","bowler_id":"93519","over":"16","ball":"4","score":1,"commentary":"Luke Hollman to Lewis Gregory, 1 run,","noball_dismissal":false,"text":"","timestamp":1749759007,"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":"12130126","event":"ball","batsman_id":"1049","bowler_id":"93519","over":"16","ball":"5","score":1,"commentary":"Luke Hollman to Ben Green, 1 run,","noball_dismissal":false,"text":"","timestamp":1749759018,"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":"12130127","event":"ball","batsman_id":"49421","bowler_id":"93519","over":"16","ball":"6","score":6,"commentary":"Luke Hollman to Lewis Gregory, Six,","noball_dismissal":false,"text":"","timestamp":1749759031,"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":"overend","over":17,"runs":9,"score":"201\/5","bats":[{"runs":51,"balls_faced":21,"fours":3,"sixes":5,"batsman_id":49421},{"runs":2,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":1049}],"bowls":[{"runs_conceded":49,"maidens":0,"wickets":2,"bowler_id":93519,"overs":4},{"runs_conceded":34,"maidens":0,"wickets":0,"bowler_id":49497,"overs":3}],"commentary":"End of over 17 (9 runs), Somerset 201\/5"},{"event_id":"12130135","event":"ball","batsman_id":"1049","bowler_id":"49930","over":"17","ball":"1","score":4,"commentary":"Ryan Higgins to Ben Green, Four,","noball_dismissal":false,"text":"","timestamp":1749759131,"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":"12130139","event":"ball","batsman_id":"1049","bowler_id":"49930","over":"17","ball":"2","score":2,"commentary":"Ryan Higgins to Ben Green, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749759142,"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":"12130141","event":"ball","batsman_id":"1049","bowler_id":"49930","over":"17","ball":"3","score":1,"commentary":"Ryan Higgins to Ben Green, 1 run,","noball_dismissal":false,"text":"","timestamp":1749759176,"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":"12130152","event":"ball","batsman_id":"49421","bowler_id":"49930","over":"17","ball":"4","score":1,"commentary":"Ryan Higgins to Lewis Gregory, 1 run,","noball_dismissal":false,"text":"","timestamp":1749759277,"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":"12130154","event":"ball","batsman_id":"1049","bowler_id":"49930","over":"17","ball":"5","score":0,"commentary":"Ryan Higgins to Ben Green, no run,","noball_dismissal":false,"text":"","timestamp":1749759281,"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":"12130155","event":"ball","batsman_id":"1049","bowler_id":"49930","over":"17","ball":"6","score":1,"commentary":"Ryan Higgins to Ben Green, 1 run,","noball_dismissal":false,"text":"","timestamp":1749759293,"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":18,"runs":9,"score":"210\/5","bats":[{"runs":10,"balls_faced":8,"fours":1,"sixes":0,"batsman_id":1049},{"runs":52,"balls_faced":22,"fours":3,"sixes":5,"batsman_id":49421}],"bowls":[{"runs_conceded":31,"maidens":0,"wickets":1,"bowler_id":49930,"overs":4},{"runs_conceded":49,"maidens":0,"wickets":2,"bowler_id":93519,"overs":4}],"commentary":"End of over 18 (9 runs), Somerset 210\/5"},{"event_id":"12130163","event":"ball","batsman_id":"1049","bowler_id":"49497","over":"18","ball":"1","score":2,"commentary":"Tom Helm to Ben Green, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749759390,"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":"12130165","event":"ball","batsman_id":"1049","bowler_id":"49497","over":"18","ball":"2","score":4,"commentary":"Tom Helm to Ben Green, Four,","noball_dismissal":false,"text":"","timestamp":1749759394,"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":"12130169","event":"ball","batsman_id":"1049","bowler_id":"49497","over":"18","ball":"3","score":2,"commentary":"Tom Helm to Ben Green, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749759433,"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":"12130176","event":"ball","batsman_id":"1049","bowler_id":"49497","over":"18","ball":"4","score":4,"commentary":"Tom Helm to Ben Green, Four,","noball_dismissal":false,"text":"","timestamp":1749759489,"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":"12130183","event":"ball","batsman_id":"1049","bowler_id":"49497","over":"18","ball":"5","score":4,"commentary":"Tom Helm to Ben Green, Four,","noball_dismissal":false,"text":"","timestamp":1749759548,"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":"12130185","event":"ball","batsman_id":"1049","bowler_id":"49497","over":"18","ball":"6","score":1,"commentary":"Tom Helm to Ben Green, 1 run,","noball_dismissal":false,"text":"","timestamp":1749759581,"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":19,"runs":17,"score":"227\/5","bats":[{"runs":27,"balls_faced":14,"fours":4,"sixes":0,"batsman_id":1049},{"runs":52,"balls_faced":22,"fours":3,"sixes":5,"batsman_id":49421}],"bowls":[{"runs_conceded":51,"maidens":0,"wickets":0,"bowler_id":49497,"overs":4},{"runs_conceded":31,"maidens":0,"wickets":1,"bowler_id":49930,"overs":4}],"commentary":"End of over 19 (17 runs), Somerset 227\/5"},{"event_id":"12130199","event":"ball","batsman_id":"1049","bowler_id":"140007","over":"19","ball":"1","score":"1lb","commentary":"Noah Cornwell to Ben Green, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1749759704,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"1","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12130200","event":"ball","batsman_id":"49421","bowler_id":"140007","over":"19","ball":"2","score":"1wd","commentary":"Noah Cornwell to Lewis Gregory, 1 wide,","noball_dismissal":false,"text":"","timestamp":1749759708,"run":1,"noball_run":"0","wide_run":"1","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12130203","event":"ball","batsman_id":"49421","bowler_id":"140007","over":"19","ball":"2","score":6,"commentary":"Noah Cornwell to Lewis Gregory, Six,","noball_dismissal":false,"text":"","timestamp":1749759768,"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}],"day":"0","session":"0","live_inning":{"iid":197936,"number":2,"name":"Somerset Inning","short_name":"SOM Inning","status":2,"issuperover":"false","result":3,"batting_team_id":7010,"fielding_team_id":7044,"scores":"235\/5","scores_full":"235\/5 (19.2 ov)","fielder":[{"fielder_id":"93519","fielder_name":"Luke Hollman","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"53281","fielder_name":"Leus du Plooy","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"101478","fielder_name":"Joe Benjamin Cracknell","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"true"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Sean Dickson","batsman_id":"49823","runs":"76","balls":"38","how_out":"c (sub JB Cracknell) b LBK Hollman","score_at_dismissal":192,"overs_at_dismissal":"16.1","bowler_id":"93519","dismissal":"caught","number":5},"extra_runs":{"byes":0,"legbyes":3,"wides":4,"noballs":2,"penalty":"0","total":9},"equations":{"runs":235,"wickets":5,"overs":"19.2","bowlers_used":5,"runrate":"12.16"},"current_partnership":{"runs":43,"balls":19,"overs":3.1,"batsmen":[{"name":"Ben Green","batsman_id":1049,"runs":27,"balls":15},{"name":"Lewis Gregory","batsman_id":49421,"runs":14,"balls":4}]},"did_not_bat":[{"player_id":"95554","name":"Lewis Goldsworthy"},{"player_id":"49733","name":"Craig Overton"},{"player_id":"486","name":"Matt Henry"},{"player_id":"93329","name":"Riley Meredith"}],"max_over":"20","target":"230","recent_scores":"6,1,1,1,4,4,2,4,2,1,0,1,1,2,4,6,1,1","last_five_overs":"72\/1 13.94","last_ten_overs":"144\/1 13.71"},"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":"235\/5 (19.2 ov)","scores":"235\/5","overs":"19.2"},{"tid":7044,"title":"Middlesex","abbr":"MID","alt_name":"MID","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/middlesex-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/middlesex-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"229\/5 (20 ov)","scores":"229\/5","overs":"20"}],"players":[{"pid":31,"title":"Kane Williamson","short_name":"K Williamson","first_name":"Kane Williamson","last_name":"","middle_name":"","birthdate":"1990-08-08","birthplace":"Tauranga","country":"nz","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":"https:\/\/www.facebook.com\/KaneWillTrain\/","twitter_profile":"https:\/\/twitter.com\/KaneWiliamson","instagram_profile":"https:\/\/www.instagram.com\/kane_s_w\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bat","role_str":""},{"pid":301,"title":"Josh Davey","short_name":"J Davey","first_name":"Josh Davey","last_name":"","middle_name":"","birthdate":"1990-08-03","birthplace":"Aberdeen, United Kingdom","country":"sct","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bowl","role_str":""},{"pid":1043,"title":"Max Holden","short_name":"MDE Holden","first_name":"Max Holden","last_name":"","middle_name":"","birthdate":"1997-12-18","birthplace":" Cambridge","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/maxholden_4","instagram_profile":"https:\/\/www.instagram.com\/maxholden4\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":1049,"title":"Ben Green","short_name":"BGF Green","first_name":"Ben Green","last_name":"","middle_name":"","birthdate":"1997-09-28","birthplace":"Exeter, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":1115,"title":"Josh Little","short_name":"JB Little","first_name":"Josh Little","last_name":"","middle_name":"","birthdate":"1999-11-01","birthplace":"Dublin","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/joshlittle13\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":44058,"title":"Zafar Gohar","short_name":"ZG Gohar","first_name":"Zafar Gohar","last_name":"","middle_name":"","birthdate":"1995-02-01","birthplace":"Lahore, Punjab","country":"pk","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":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/iamzafargohar","instagram_profile":"https:\/\/www.instagram.com\/iamzafargohar\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bowl","role_str":""},{"pid":48656,"title":"Tom Kohler-Cadmore","short_name":"TK Cadmore","first_name":"Tom Kohler-Cadmore","last_name":"","middle_name":"","birthdate":"1994-08-19","birthplace":" Chatham, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/tomkholerCadmore32\/","twitter_profile":"https:\/\/twitter.com\/TomKCadmore32","instagram_profile":"https:\/\/www.instagram.com\/tomkcadmore","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":49015,"title":"Andrew Umeed","short_name":"ARI Umeed","first_name":"Andrew Umeed","last_name":"","middle_name":"","birthdate":"1996-04-19","birthplace":"Glasgow, Lanarkshire","country":"sct","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Scotland","role":"squad","role_str":""},{"pid":49413,"title":"Tom Abell","short_name":"TB Abell","first_name":"Tom Abell","last_name":"","middle_name":"","birthdate":"1994-03-05","birthplace":"Taunton, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/tomabell1","instagram_profile":"https:\/\/www.instagram.com\/tabell28\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":49421,"title":"Lewis Gregory","short_name":"L Gregory","first_name":"Lewis Gregory","last_name":"","middle_name":"","birthdate":"1992-05-24","birthplace":"Plymouth","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/lewisgregory23\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":"(C)"},{"pid":49425,"title":"Jack Leach","short_name":"J Leach","first_name":"Jack Leach","last_name":"","middle_name":"","birthdate":"1991-06-22","birthplace":" Taunton, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/jackleach1991?lang=gu","instagram_profile":"https:\/\/www.instagram.com\/mjleach17\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49493,"title":"Sam Robson","short_name":"SD Robson","first_name":"Sam Robson","last_name":"","middle_name":"","birthdate":"1989-07-01","birthplace":"Paddington, Sydney, New South Wales","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"https:\/\/www.facebook.com\/samrobson664\/","twitter_profile":"https:\/\/twitter.com\/Samrobsonfans12","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49497,"title":"Tom Helm","short_name":"TG Helm","first_name":"Tom Helm","last_name":"","middle_name":"","birthdate":"1994-05-07","birthplace":"Stoke Mandeville Hospital, Buckinghamshire","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":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/TomHelm7","instagram_profile":"https:\/\/www.instagram.com\/helmy__7\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":49733,"title":"Craig Overton","short_name":"C Overton","first_name":"Craig Overton","last_name":"","middle_name":"","birthdate":"1994-04-10","birthplace":"Barnstaple, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/craigoverton12","instagram_profile":"https:\/\/www.instagram.com\/craigoverton12\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":49783,"title":"Toby Roland-Jones","short_name":"TS Roland-Jones","first_name":"Toby Roland-Jones","last_name":"","middle_name":"","birthdate":"1988-01-29","birthplace":"Ashford, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/tobyrj21","instagram_profile":"https:\/\/www.instagram.com\/tobyrj21\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49823,"title":"Sean Dickson","short_name":"SR Dickson","first_name":"Sean Dickson","last_name":"","middle_name":"","birthdate":"1991-09-02","birthplace":"Johannesburg, Transvaal","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bat","role_str":""},{"pid":49930,"title":"Ryan Higgins","short_name":"RF Higgins","first_name":"Ryan Higgins","last_name":"","middle_name":"","birthdate":"1995-01-06","birthplace":"Harare, Zimbabwe","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":51266,"title":"Tom Banton","short_name":"T Banton","first_name":"Tom Banton","last_name":"","middle_name":"","birthdate":"1998-11-11","birthplace":"Chiltern, Buckinghamshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/OfficialTomBanton\/","twitter_profile":"https:\/\/twitter.com\/tbanton18","instagram_profile":"https:\/\/www.instagram.com\/tombanton\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":53281,"title":"Leus du Plooy","short_name":"JLdu Plooy","first_name":"Leus du Plooy","last_name":"","middle_name":"","birthdate":"1995-01-12","birthplace":"Pretoria, Gauteng,","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/leusdup76","instagram_profile":"https:\/\/www.instagram.com\/leusdup76\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bat","role_str":""},{"pid":57592,"title":"Migael Pretorius","short_name":"M Pretorius","first_name":"Migael Pretorius","last_name":"","middle_name":"","birthdate":"1995-03-24","birthplace":"Vereeninging","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/migael27\/","twitter_profile":"https:\/\/twitter.com\/migael_27","instagram_profile":"https:\/\/www.instagram.com\/migael27\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":90974,"title":"Henry Brookes","short_name":"HJH Brookes","first_name":"Henry Brookes","last_name":"","middle_name":"","birthdate":"1999-08-21","birthplace":"Solihull, Warwickshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BrookesHenry","instagram_profile":"https:\/\/www.instagram.com\/henry.brookes\/","debut_data":"","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":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"bowl","role_str":""},{"pid":93517,"title":"Jack Davies","short_name":"JLB Davies","first_name":"Jack Davies","last_name":"","middle_name":"","birthdate":"2000-03-30","birthplace":"Reading, Berkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/daviesjlb","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":93519,"title":"Luke Hollman","short_name":"LBK Hollman","first_name":"Luke Hollman","last_name":"","middle_name":"","birthdate":"2000-09-16","birthplace":"Islington, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/lukehollman56\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":93520,"title":"Tom Lammonby","short_name":"TA Lammonby","first_name":"Tom Lammonby","last_name":"","middle_name":"","birthdate":"2000-06-02","birthplace":" Exeter, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/TomLammonby","instagram_profile":"https:\/\/www.instagram.com\/tom_lammonby\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95550,"title":"Kasey Aldridge","short_name":"K Aldridge","first_name":"Kasey Aldridge","last_name":"","middle_name":"","birthdate":"2000-12-24","birthplace":"Bristol","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/kcaldridge5\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95552,"title":"Blake Cullen","short_name":"B Cullen","first_name":"Blake Cullen","last_name":"","middle_name":"","birthdate":"2002-02-19","birthplace":" Isleworth, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95554,"title":"Lewis Goldsworthy","short_name":"L Goldsworthy","first_name":"Lewis Goldsworthy","last_name":"","middle_name":"","birthdate":"2001-01-08","birthplace":" Cornwall","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lewigoldsworthy","instagram_profile":"https:\/\/www.instagram.com\/lewisgoldsworthy\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":101478,"title":"Joe Benjamin Cracknell","short_name":"JB Cracknell","first_name":"Joe Benjamin Cracknell","last_name":"","middle_name":"","birthdate":"2000-03-16","birthplace":"Enfield, 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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/joe_cracknell\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":102540,"title":"Stephen Eskinazi","short_name":"S Eskinazi","first_name":"Stephen Eskinazi","last_name":"","middle_name":"","birthdate":"1994-03-28","birthplace":"Johannesburg, Transvaal, South Africa","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":"https:\/\/twitter.com\/seskinazi","instagram_profile":"https:\/\/www.instagram.com\/seskinazi\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(C)"},{"pid":103052,"title":"Will Smeed","short_name":"W Smeed","first_name":"Will Smeed","last_name":"","middle_name":"","birthdate":"2001-10-26","birthplace":"Cambridge","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/will_smeed","instagram_profile":"https:\/\/www.instagram.com\/willsmeed\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":108382,"title":"Ben Geddes","short_name":"B Geddes","first_name":"Ben Geddes","last_name":"","middle_name":"","birthdate":"2001-07-31","birthplace":"Epsom, Surrey","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":108408,"title":"James Rew","short_name":"J Rew","first_name":"James Rew","last_name":"","middle_name":"","birthdate":"2004-01-11","birthplace":" London","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/cjrew89\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108410,"title":"Joshua Thomas","short_name":"J Thomas","first_name":"Joshua Thomas","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":116661,"title":"Ishaan Kaushal","short_name":"I Kaushal","first_name":"Ishaan Kaushal","last_name":"","middle_name":"","birthdate":"2002-02-09","birthplace":"Hillingdon, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":127503,"title":"Josh De Caires","short_name":"J D caires","first_name":"Josh De Caires","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":129244,"title":"Nathan Fernandes","short_name":"N Fernandes","first_name":"Nathan Fernandes","last_name":"","middle_name":"","birthdate":"2004-04-26","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":129894,"title":"JT Langridge","short_name":"JT Langridge","first_name":"JT Langridge","last_name":"","middle_name":"","birthdate":"2005-11-03","birthplace":" Plymouth, Devon,","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":130425,"title":"Finley Hill","short_name":"F Hill","first_name":"Finley Hill","last_name":"","middle_name":"","birthdate":"2006-06-21","birthplace":" Exeter, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":133782,"title":"Sebastian Morgan","short_name":"SB Morgan","first_name":"Sebastian Morgan","last_name":"","middle_name":"","birthdate":"2007-08-30","birthplace":"","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":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":137372,"title":"Archie Vaughan","short_name":"A Vaughan","first_name":"Archie Vaughan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":140007,"title":"Noah Cornwell","short_name":"N Cornwell","first_name":"Noah Cornwell","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":146167,"title":"Aaryan Sawant","short_name":"A Sawant","first_name":"Aaryan Sawant","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":146171,"title":"Naavya Sharma","short_name":"N Sharma","first_name":"Naavya Sharma","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":146438,"title":"Thomas Rew","short_name":"T Rew","first_name":"Thomas Rew","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""}]},"etag":"d7cee738271af250f9025ee34420e221","modified":"2025-07-29 17:44:26","datetime":"2025-07-29 17:44:26","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86861 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:21fa5d73-3aac-4dd2-b982-69ba10def43a Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86861 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86861,3,'{"status":"ok","response":{"match_id":86861,"title":"Somerset vs Middlesex","short_title":"SOM vs MID","subtitle":"Match 41","match_number":"41","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Somerset won by 5 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129425,"title":"Vitality Blast","abbr":"Vitality Blast","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-09-13","country":"en","total_matches":"133","total_rounds":"2","total_teams":"18"},"teama":{"team_id":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":"235\/5 (19.2 ov)","scores":"235\/5","overs":"19.2"},"teamb":{"team_id":7044,"name":"Middlesex","short_name":"MID","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/middlesex-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/middlesex-logo.png","scores_full":"229\/5 (20 ov)","scores":"229\/5","overs":"20"},"date_start":"2025-06-12 17:30:00","date_end":"2025-06-13 03:30:00","timestamp_start":1749749400,"timestamp_end":1749785400,"date_start_ist":"2025-06-12 23:00:00","date_end_ist":"2025-06-13 09:00:00","venue":{"venue_id":"40","name":"The Cooper Associates County Ground, Taunton","location":"Taunton","country":"England","timezone":""},"umpires":"Mark Newell (England), Anthony Harris (England)","referee":"Jason Swift (England)","equation":"","live":"","result":"SOM won by 5 wickets","result_type":1,"win_margin":"5 wickets","winning_team_id":7010,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-11 23:52:21","verify_time":"2025-06-13 02:07:09","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"","weather_desc":"","temp":"","humidity":"","visibility":"","wind_speed":"","clouds":""},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Somerset elected to bowl","winner":7010,"decision":2}},"etag":"c034040f180a816865407fed19188d46","modified":"2025-07-29 17:44:27","datetime":"2025-07-29 17:44:27","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":86861,"title":"Somerset vs Middlesex","short_title":"SOM vs MID","subtitle":"Match 41","match_number":"41","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Somerset won by 5 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129425,"title":"Vitality Blast","abbr":"Vitality Blast","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-09-13","country":"en","total_matches":"133","total_rounds":"2","total_teams":"18"},"teama":{"team_id":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":"235\/5 (19.2 ov)","scores":"235\/5","overs":"19.2"},"teamb":{"team_id":7044,"name":"Middlesex","short_name":"MID","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/middlesex-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/middlesex-logo.png","scores_full":"229\/5 (20 ov)","scores":"229\/5","overs":"20"},"date_start":"2025-06-12 17:30:00","date_end":"2025-06-13 03:30:00","timestamp_start":1749749400,"timestamp_end":1749785400,"date_start_ist":"2025-06-12 23:00:00","date_end_ist":"2025-06-13 09:00:00","venue":{"venue_id":"40","name":"The Cooper Associates County Ground, Taunton","location":"Taunton","country":"England","timezone":""},"umpires":"Mark Newell (England), Anthony Harris (England)","referee":"Jason Swift (England)","equation":"","live":"","result":"SOM won by 5 wickets","result_type":1,"win_margin":"5 wickets","winning_team_id":7010,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-11 23:52:21","verify_time":"2025-06-13 02:07:09","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"","weather_desc":"","temp":"","humidity":"","visibility":"","wind_speed":"","clouds":""},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Somerset elected to bowl","winner":7010,"decision":2}},"etag":"c034040f180a816865407fed19188d46","modified":"2025-07-29 17:44:27","datetime":"2025-07-29 17:44:27","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86861 AND DataTypeId = 3 END
Live Report & Scorecard of Somerset vs Middlesex Match 41
<>
CricDirect Cricket News, Results and Stats
 

Somerset vs Middlesex, Match 41, Vitality Blast

Completed
Vitality Blast, Completed
Somerset
SOM
235/5 (19.2)
Middlesex
MID
229/5 (20)
Somerset won by 5 wickets
Match Details
Date
2025-06-12 17:30:00
Venue
The Cooper Associates County Ground, Taunton, Taunton
Toss
Somerset elected to bowl
Umpires
    Tv Umpires
      Match Referee
        × Close