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:03016012-b651-498b-87b0-9bad5a2039c4 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86855 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86855,1,'{"status":"ok","response":{"mid":86855,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Middlesex won by 6 wickets","day_remaining_over":"","team_batting":"Middlesex","team_bowling":"Essex","live_inning_number":2,"live_score":{"runs":159,"overs":17.3,"wickets":4,"target":157,"runrate":9.09,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Ben Geddes","batsman_id":108382,"runs":34,"balls_faced":12,"fours":2,"sixes":3,"strike_rate":"283.33"},{"name":"Ryan Higgins","batsman_id":49930,"runs":8,"balls_faced":4,"fours":0,"sixes":1,"strike_rate":"200.00"}],"bowlers":[{"name":"Matt Critchley","bowler_id":48647,"overs":2.3,"runs_conceded":25,"wickets":0,"maidens":0,"econ":"10.00"},{"name":"Paul Walter","bowler_id":51346,"overs":3,"runs_conceded":34,"wickets":2,"maidens":0,"econ":"11.33"}],"commentaries":[{"event_id":"12102514","event":"wicket","batsman_id":"53281","bowler_id":"49087","over":"13","ball":"1","score":"w","commentary":"Simon Harmer to Leus du Plooy, no run, b SR Harmer,","noball_dismissal":false,"text":"","timestamp":1749396092,"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":"53281","how_out":"b SR Harmer","batsman_runs":"1","batsman_balls":"2"},{"event_id":"12102530","event":"ball","batsman_id":"93517","bowler_id":"49087","over":"13","ball":"2","score":0,"commentary":"Simon Harmer to Jack Davies, no run,","noball_dismissal":false,"text":"","timestamp":1749396143,"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":"12102531","event":"ball","batsman_id":"93517","bowler_id":"49087","over":"13","ball":"3","score":0,"commentary":"Simon Harmer to Jack Davies, no run,","noball_dismissal":false,"text":"","timestamp":1749396147,"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":"12102534","event":"ball","batsman_id":"93517","bowler_id":"49087","over":"13","ball":"4","score":0,"commentary":"Simon Harmer to Jack Davies, no run,","noball_dismissal":false,"text":"","timestamp":1749396149,"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":"12102535","event":"ball","batsman_id":"93517","bowler_id":"49087","over":"13","ball":"5","score":0,"commentary":"Simon Harmer to Jack Davies, no run,","noball_dismissal":false,"text":"","timestamp":1749396153,"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":"12102540","event":"ball","batsman_id":"93517","bowler_id":"49087","over":"13","ball":"6","score":0,"commentary":"Simon Harmer to Jack Davies, no run,","noball_dismissal":false,"text":"","timestamp":1749396157,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":14,"runs":0,"score":"106\/3","bats":[{"runs":0,"balls_faced":5,"fours":0,"sixes":0,"batsman_id":93517},{"runs":1,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":108382}],"bowls":[{"runs_conceded":9,"maidens":1,"wickets":1,"bowler_id":49087,"overs":2},{"runs_conceded":15,"maidens":0,"wickets":1,"bowler_id":51346,"overs":2}],"commentary":"End of over 14 (0 runs), Middlesex 106\/3"},{"event_id":"12102568","event":"ball","batsman_id":"108382","bowler_id":"108420","over":"14","ball":"1","score":1,"commentary":"Luc Benkenstein to Ben Geddes, 1 run,","noball_dismissal":false,"text":"","timestamp":1749396262,"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":"12102572","event":"ball","batsman_id":"93517","bowler_id":"108420","over":"14","ball":"2","score":4,"commentary":"Luc Benkenstein to Jack Davies, Four,","noball_dismissal":false,"text":"","timestamp":1749396265,"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":"12102577","event":"ball","batsman_id":"93517","bowler_id":"108420","over":"14","ball":"3","score":0,"commentary":"Luc Benkenstein to Jack Davies, no run,","noball_dismissal":false,"text":"","timestamp":1749396268,"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":"12102581","event":"ball","batsman_id":"93517","bowler_id":"108420","over":"14","ball":"4","score":1,"commentary":"Luc Benkenstein to Jack Davies, 1 run,","noball_dismissal":false,"text":"","timestamp":1749396272,"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":"12102605","event":"ball","batsman_id":"108382","bowler_id":"108420","over":"14","ball":"5","score":4,"commentary":"Luc Benkenstein to Ben Geddes, Four,","noball_dismissal":false,"text":"","timestamp":1749396295,"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":"12102610","event":"ball","batsman_id":"108382","bowler_id":"108420","over":"14","ball":"6","score":1,"commentary":"Luc Benkenstein to Ben Geddes, 1 run,","noball_dismissal":false,"text":"","timestamp":1749396309,"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":15,"runs":11,"score":"117\/3","bats":[{"runs":7,"balls_faced":5,"fours":1,"sixes":0,"batsman_id":108382},{"runs":5,"balls_faced":8,"fours":1,"sixes":0,"batsman_id":93517}],"bowls":[{"runs_conceded":16,"maidens":0,"wickets":1,"bowler_id":108420,"overs":2},{"runs_conceded":9,"maidens":1,"wickets":1,"bowler_id":49087,"overs":2}],"commentary":"End of over 15 (11 runs), Middlesex 117\/3"},{"event_id":"12102637","event":"ball","batsman_id":"108382","bowler_id":"49087","over":"15","ball":"1","score":1,"commentary":"Simon Harmer to Ben Geddes, 1 run,","noball_dismissal":false,"text":"","timestamp":1749396387,"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":"12102641","event":"ball","batsman_id":"93517","bowler_id":"49087","over":"15","ball":"2","score":6,"commentary":"Simon Harmer to Jack Davies, Six,","noball_dismissal":false,"text":"","timestamp":1749396390,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12102665","event":"ball","batsman_id":"93517","bowler_id":"49087","over":"15","ball":"3","score":0,"commentary":"Simon Harmer to Jack Davies, no run,","noball_dismissal":false,"text":"","timestamp":1749396459,"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":"12102668","event":"ball","batsman_id":"93517","bowler_id":"49087","over":"15","ball":"4","score":1,"commentary":"Simon Harmer to Jack Davies, 1 run,","noball_dismissal":false,"text":"","timestamp":1749396464,"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":"12102677","event":"ball","batsman_id":"108382","bowler_id":"49087","over":"15","ball":"5","score":2,"commentary":"Simon Harmer to Ben Geddes, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749396467,"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":"12102681","event":"ball","batsman_id":"108382","bowler_id":"49087","over":"15","ball":"6","score":2,"commentary":"Simon Harmer to Ben Geddes, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749396481,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":16,"runs":12,"score":"129\/3","bats":[{"runs":12,"balls_faced":8,"fours":1,"sixes":0,"batsman_id":108382},{"runs":12,"balls_faced":11,"fours":1,"sixes":1,"batsman_id":93517}],"bowls":[{"runs_conceded":21,"maidens":1,"wickets":1,"bowler_id":49087,"overs":3},{"runs_conceded":16,"maidens":0,"wickets":1,"bowler_id":108420,"overs":2}],"commentary":"End of over 16 (12 runs), Middlesex 129\/3"},{"event_id":"12102730","event":"wicket","batsman_id":"93517","bowler_id":"51346","over":"16","ball":"1","score":"w","commentary":"Paul Walter to Jack Davies, no run, c MKS Pepper b PI Walter,","noball_dismissal":false,"text":"","timestamp":1749396641,"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":"93517","how_out":"c MKS Pepper b PI Walter","batsman_runs":"12","batsman_balls":"12"},{"event_id":"12102744","event":"ball","batsman_id":"49930","bowler_id":"51346","over":"16","ball":"2","score":0,"commentary":"Paul Walter to Ryan Higgins, no run,","noball_dismissal":false,"text":"","timestamp":1749396671,"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":"12102746","event":"ball","batsman_id":"49930","bowler_id":"51346","over":"16","ball":"3","score":1,"commentary":"Paul Walter to Ryan Higgins, 1 run,","noball_dismissal":false,"text":"","timestamp":1749396675,"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":"12102755","event":"ball","batsman_id":"108382","bowler_id":"51346","over":"16","ball":"4","score":6,"commentary":"Paul Walter to Ben Geddes, Six,","noball_dismissal":false,"text":"","timestamp":1749396697,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12102765","event":"ball","batsman_id":"108382","bowler_id":"51346","over":"16","ball":"5","score":6,"commentary":"Paul Walter to Ben Geddes, Six,","noball_dismissal":false,"text":"","timestamp":1749396715,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12102783","event":"ball","batsman_id":"108382","bowler_id":"51346","over":"16","ball":"6","score":6,"commentary":"Paul Walter to Ben Geddes, Six,","noball_dismissal":false,"text":"","timestamp":1749396772,"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":19,"score":"148\/4","bats":[{"runs":30,"balls_faced":11,"fours":1,"sixes":3,"batsman_id":108382},{"runs":1,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":49930}],"bowls":[{"runs_conceded":34,"maidens":0,"wickets":2,"bowler_id":51346,"overs":3},{"runs_conceded":21,"maidens":1,"wickets":1,"bowler_id":49087,"overs":3}],"commentary":"End of over 17 (19 runs), Middlesex 148\/4"},{"event_id":"12102820","event":"ball","batsman_id":"49930","bowler_id":"48647","over":"17","ball":"1","score":6,"commentary":"Matt Critchley to Ryan Higgins, Six,","noball_dismissal":false,"text":"","timestamp":1749396878,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12102830","event":"ball","batsman_id":"49930","bowler_id":"48647","over":"17","ball":"2","score":1,"commentary":"Matt Critchley to Ryan Higgins, 1 run,","noball_dismissal":false,"text":"","timestamp":1749396910,"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":"12102836","event":"ball","batsman_id":"108382","bowler_id":"48647","over":"17","ball":"3","score":4,"commentary":"Matt Critchley to Ben Geddes, Four,","noball_dismissal":false,"text":"","timestamp":1749396914,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false}],"day":"0","session":"0","live_inning":{"iid":197682,"number":2,"name":"Middlesex Inning","short_name":"MID Inning","status":2,"issuperover":"false","result":3,"batting_team_id":7044,"fielding_team_id":104950,"scores":"159\/4","scores_full":"159\/4 (17.3 ov)","fielder":[{"fielder_id":"108420","fielder_name":"Luc Benkenstein","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"1758","fielder_name":"Mohammad Amir","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"51105","fielder_name":"Michael-Kyle Pepper","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Jack Davies","batsman_id":"93517","runs":"12","balls":"12","how_out":"c MKS Pepper b PI Walter","score_at_dismissal":129,"overs_at_dismissal":"16.1","bowler_id":"51346","dismissal":"caught","number":4},"extra_runs":{"byes":0,"legbyes":0,"wides":1,"noballs":0,"penalty":"0","total":1},"equations":{"runs":159,"wickets":4,"overs":"17.3","bowlers_used":7,"runrate":"9.09"},"current_partnership":{"runs":30,"balls":8,"overs":1.2,"batsmen":[{"name":"Ryan Higgins","batsman_id":49930,"runs":8,"balls":4},{"name":"Ben Geddes","batsman_id":108382,"runs":22,"balls":4}]},"did_not_bat":[{"player_id":"93519","name":"Luke Hollman"},{"player_id":"44058","name":"Zafar Gohar"},{"player_id":"49497","name":"Tom Helm"},{"player_id":"1115","name":"Josh Little"},{"player_id":"140007","name":"Noah Cornwell"}],"max_over":"20","target":"157","recent_scores":"4,1,6,6,6,6,1,0,w,2,2,1,0,6,1,1,4,1","last_five_overs":"60\/3 12.00","last_ten_overs":"95\/4 9.50"},"teams":[{"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":"159\/4 (17.3 ov)","scores":"159\/4","overs":"17.3"},{"tid":104950,"title":"Essex","abbr":"ESS","alt_name":"ESS","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"156\/9 (20 ov)","scores":"156\/9","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":9,"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":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":8,"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":"squad","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":"bowl","role_str":""},{"pid":1758,"title":"Mohammad Amir","short_name":"M Amir","first_name":"Mohammad Amir","last_name":"","middle_name":"","birthdate":"1992-04-13","birthplace":" Gujjar Khan, Punjab","country":"pk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/iamamirofficial","instagram_profile":"https:\/\/www.instagram.com\/official.mamir\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bowl","role_str":""},{"pid":10592,"title":"Tom Westley","short_name":"TZ Westley","first_name":"Tom Westley","last_name":"","middle_name":"","birthdate":"1989-03-13","birthplace":"Cambridge","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":10602,"title":"Nick Browne","short_name":"NLJ Browne","first_name":"Nick Browne","last_name":"","middle_name":"","birthdate":"1991-03-24","birthplace":"Leytonstone, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","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":7,"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":46837,"title":"Eathan Bosch","short_name":"E Bosch","first_name":"Eathan Bosch","last_name":"","middle_name":"","birthdate":"1998-04-27","birthplace":"Westville","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"https:\/\/www.facebook.com\/eathan.bosch.14\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/eathanbosch\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":48647,"title":"Matt Critchley","short_name":"MJJ Critchley","first_name":"Matt Critchley","last_name":"","middle_name":"","birthdate":"1996-08-13","birthplace":"Preston, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/mattcritchley96","instagram_profile":"https:\/\/www.instagram.com\/critch130896\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":49083,"title":"Dean Elgar","short_name":"D Elgar","first_name":"Dean Elgar","last_name":"","middle_name":"","birthdate":"1987-06-11","birthplace":"Welkom, Orange Free state","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":36249,"recent_appearance":1514287800,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BoringDeanElgar","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bat","role_str":""},{"pid":49087,"title":"Simon Harmer","short_name":"SR Harmer","first_name":"Simon Harmer","last_name":"","middle_name":"","birthdate":"1989-02-10","birthplace":"Pretoria, Transvaal","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Simon_Harmer_","instagram_profile":"https:\/\/www.instagram.com\/simon_harmer\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bowl","role_str":"(C)"},{"pid":49376,"title":"Adam Rossington","short_name":"AM Rossington","first_name":"Adam Rossington","last_name":"","middle_name":"","birthdate":"1993-05-05","birthplace":"Edgware, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper ","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Rossington17","instagram_profile":"https:\/\/www.instagram.com\/rossington17\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"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":7,"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":8,"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":49593,"title":"Jamie Porter","short_name":"JA Porter","first_name":"Jamie Porter","last_name":"","middle_name":"","birthdate":"1993-05-25","birthplace":"Leytonstone, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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.5,"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":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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":50455,"title":"Feroze Khushi","short_name":"FIN Khushi","first_name":"Feroze Khushi","last_name":"","middle_name":"","birthdate":"1999-06-23","birthplace":"Whipps Cross, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51105,"title":"Michael-Kyle Pepper","short_name":"MKS Pepper","first_name":"Michael-Kyle Pepper","last_name":"","middle_name":"","birthdate":"1998-06-25","birthplace":"Harlow, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/michael_pep\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":""},{"pid":51346,"title":"Paul Walter","short_name":"PI Walter","first_name":"Paul Walter","last_name":"","middle_name":"","birthdate":"1994-05-28","birthplace":"Basildon, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":51347,"title":"Aaron Beard","short_name":"AP Beard","first_name":"Aaron Beard","last_name":"","middle_name":"","birthdate":"1997-10-15","birthplace":"Chelmsford, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"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.5,"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":61358,"title":"Shane Snater","short_name":"S Snater","first_name":"Shane Snater","last_name":"","middle_name":"","birthdate":"1996-03-24","birthplace":"Harare, Zimbabwe","country":"nl","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"bowl","role_str":""},{"pid":68691,"title":"Samuel Cook","short_name":"S Cook","first_name":"Samuel Cook","last_name":"","middle_name":"","birthdate":"1997-08-04","birthplace":"Chelmsford, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/samcook09","instagram_profile":"https:\/\/www.instagram.com\/s_cook16\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","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":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"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":93372,"title":"Daniel Sams","short_name":"DR Sams","first_name":"Daniel Sams","last_name":"","middle_name":"","birthdate":"1992-10-27","birthplace":" Milperra, New South Wales","country":"au","primary_team":[],"logo_url":"","playing_role":"all","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\/dansams\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","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":8,"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":94961,"title":"Jordan Cox","short_name":"J Cox","first_name":"Jordan Cox","last_name":"","middle_name":"","birthdate":"2000-10-21","birthplace":"Margate, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/jjordancox\/","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95892,"title":"Ben Allison","short_name":"B Allison","first_name":"Ben Allison","last_name":"","middle_name":"","birthdate":"1999-12-18","birthplace":"Colchester, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":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":7.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.5,"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":103358,"title":"Robin Das","short_name":"RJ Das","first_name":"Robin Das","last_name":"","middle_name":"","birthdate":"2002-02-27","birthplace":"Leytonstone","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"https:\/\/www.facebook.com\/robindascricketer","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/robinigblue\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":108393,"title":"Jamal Richards","short_name":"J Richards","first_name":"Jamal Richards","last_name":"","middle_name":"","birthdate":"2004-03-03","birthplace":"Edmonton, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108420,"title":"Luc Benkenstein","short_name":"L Benkenstein","first_name":"Luc Benkenstein","last_name":"","middle_name":"","birthdate":"2004-11-02","birthplace":"Durban","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","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":6,"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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":127517,"title":"Noah Thain","short_name":"NRM Thain","first_name":"Noah Thain","last_name":"","middle_name":"","birthdate":"2005-01-13","birthplace":"Hitchinbrooke, Hertfordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":129447,"title":"Mackenzie Jones","short_name":"Mackenzie Jones","first_name":"Mackenzie Jones","last_name":"","middle_name":"","birthdate":"2005-03-06","birthplace":"","country":"sct","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Scotland","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":134958,"title":"Charles Allison","short_name":"CW Allison","first_name":"Charles Allison","last_name":"","middle_name":"","birthdate":"2005-03-02","birthplace":"Colchester, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":141341,"title":"Simon Fernandes","short_name":"Simon Fernandes","first_name":"Simon Fernandes","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":6,"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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""}]},"etag":"4d85f0f4c92a7d700b4eabbeff7e4ffe","modified":"2025-08-01 11:43:08","datetime":"2025-08-01 11:43:08","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":86855,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Middlesex won by 6 wickets","day_remaining_over":"","team_batting":"Middlesex","team_bowling":"Essex","live_inning_number":2,"live_score":{"runs":159,"overs":17.3,"wickets":4,"target":157,"runrate":9.09,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Ben Geddes","batsman_id":108382,"runs":34,"balls_faced":12,"fours":2,"sixes":3,"strike_rate":"283.33"},{"name":"Ryan Higgins","batsman_id":49930,"runs":8,"balls_faced":4,"fours":0,"sixes":1,"strike_rate":"200.00"}],"bowlers":[{"name":"Matt Critchley","bowler_id":48647,"overs":2.3,"runs_conceded":25,"wickets":0,"maidens":0,"econ":"10.00"},{"name":"Paul Walter","bowler_id":51346,"overs":3,"runs_conceded":34,"wickets":2,"maidens":0,"econ":"11.33"}],"commentaries":[{"event_id":"12102514","event":"wicket","batsman_id":"53281","bowler_id":"49087","over":"13","ball":"1","score":"w","commentary":"Simon Harmer to Leus du Plooy, no run, b SR Harmer,","noball_dismissal":false,"text":"","timestamp":1749396092,"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":"53281","how_out":"b SR Harmer","batsman_runs":"1","batsman_balls":"2"},{"event_id":"12102530","event":"ball","batsman_id":"93517","bowler_id":"49087","over":"13","ball":"2","score":0,"commentary":"Simon Harmer to Jack Davies, no run,","noball_dismissal":false,"text":"","timestamp":1749396143,"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":"12102531","event":"ball","batsman_id":"93517","bowler_id":"49087","over":"13","ball":"3","score":0,"commentary":"Simon Harmer to Jack Davies, no run,","noball_dismissal":false,"text":"","timestamp":1749396147,"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":"12102534","event":"ball","batsman_id":"93517","bowler_id":"49087","over":"13","ball":"4","score":0,"commentary":"Simon Harmer to Jack Davies, no run,","noball_dismissal":false,"text":"","timestamp":1749396149,"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":"12102535","event":"ball","batsman_id":"93517","bowler_id":"49087","over":"13","ball":"5","score":0,"commentary":"Simon Harmer to Jack Davies, no run,","noball_dismissal":false,"text":"","timestamp":1749396153,"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":"12102540","event":"ball","batsman_id":"93517","bowler_id":"49087","over":"13","ball":"6","score":0,"commentary":"Simon Harmer to Jack Davies, no run,","noball_dismissal":false,"text":"","timestamp":1749396157,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":14,"runs":0,"score":"106\/3","bats":[{"runs":0,"balls_faced":5,"fours":0,"sixes":0,"batsman_id":93517},{"runs":1,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":108382}],"bowls":[{"runs_conceded":9,"maidens":1,"wickets":1,"bowler_id":49087,"overs":2},{"runs_conceded":15,"maidens":0,"wickets":1,"bowler_id":51346,"overs":2}],"commentary":"End of over 14 (0 runs), Middlesex 106\/3"},{"event_id":"12102568","event":"ball","batsman_id":"108382","bowler_id":"108420","over":"14","ball":"1","score":1,"commentary":"Luc Benkenstein to Ben Geddes, 1 run,","noball_dismissal":false,"text":"","timestamp":1749396262,"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":"12102572","event":"ball","batsman_id":"93517","bowler_id":"108420","over":"14","ball":"2","score":4,"commentary":"Luc Benkenstein to Jack Davies, Four,","noball_dismissal":false,"text":"","timestamp":1749396265,"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":"12102577","event":"ball","batsman_id":"93517","bowler_id":"108420","over":"14","ball":"3","score":0,"commentary":"Luc Benkenstein to Jack Davies, no run,","noball_dismissal":false,"text":"","timestamp":1749396268,"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":"12102581","event":"ball","batsman_id":"93517","bowler_id":"108420","over":"14","ball":"4","score":1,"commentary":"Luc Benkenstein to Jack Davies, 1 run,","noball_dismissal":false,"text":"","timestamp":1749396272,"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":"12102605","event":"ball","batsman_id":"108382","bowler_id":"108420","over":"14","ball":"5","score":4,"commentary":"Luc Benkenstein to Ben Geddes, Four,","noball_dismissal":false,"text":"","timestamp":1749396295,"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":"12102610","event":"ball","batsman_id":"108382","bowler_id":"108420","over":"14","ball":"6","score":1,"commentary":"Luc Benkenstein to Ben Geddes, 1 run,","noball_dismissal":false,"text":"","timestamp":1749396309,"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":15,"runs":11,"score":"117\/3","bats":[{"runs":7,"balls_faced":5,"fours":1,"sixes":0,"batsman_id":108382},{"runs":5,"balls_faced":8,"fours":1,"sixes":0,"batsman_id":93517}],"bowls":[{"runs_conceded":16,"maidens":0,"wickets":1,"bowler_id":108420,"overs":2},{"runs_conceded":9,"maidens":1,"wickets":1,"bowler_id":49087,"overs":2}],"commentary":"End of over 15 (11 runs), Middlesex 117\/3"},{"event_id":"12102637","event":"ball","batsman_id":"108382","bowler_id":"49087","over":"15","ball":"1","score":1,"commentary":"Simon Harmer to Ben Geddes, 1 run,","noball_dismissal":false,"text":"","timestamp":1749396387,"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":"12102641","event":"ball","batsman_id":"93517","bowler_id":"49087","over":"15","ball":"2","score":6,"commentary":"Simon Harmer to Jack Davies, Six,","noball_dismissal":false,"text":"","timestamp":1749396390,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12102665","event":"ball","batsman_id":"93517","bowler_id":"49087","over":"15","ball":"3","score":0,"commentary":"Simon Harmer to Jack Davies, no run,","noball_dismissal":false,"text":"","timestamp":1749396459,"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":"12102668","event":"ball","batsman_id":"93517","bowler_id":"49087","over":"15","ball":"4","score":1,"commentary":"Simon Harmer to Jack Davies, 1 run,","noball_dismissal":false,"text":"","timestamp":1749396464,"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":"12102677","event":"ball","batsman_id":"108382","bowler_id":"49087","over":"15","ball":"5","score":2,"commentary":"Simon Harmer to Ben Geddes, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749396467,"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":"12102681","event":"ball","batsman_id":"108382","bowler_id":"49087","over":"15","ball":"6","score":2,"commentary":"Simon Harmer to Ben Geddes, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749396481,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":16,"runs":12,"score":"129\/3","bats":[{"runs":12,"balls_faced":8,"fours":1,"sixes":0,"batsman_id":108382},{"runs":12,"balls_faced":11,"fours":1,"sixes":1,"batsman_id":93517}],"bowls":[{"runs_conceded":21,"maidens":1,"wickets":1,"bowler_id":49087,"overs":3},{"runs_conceded":16,"maidens":0,"wickets":1,"bowler_id":108420,"overs":2}],"commentary":"End of over 16 (12 runs), Middlesex 129\/3"},{"event_id":"12102730","event":"wicket","batsman_id":"93517","bowler_id":"51346","over":"16","ball":"1","score":"w","commentary":"Paul Walter to Jack Davies, no run, c MKS Pepper b PI Walter,","noball_dismissal":false,"text":"","timestamp":1749396641,"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":"93517","how_out":"c MKS Pepper b PI Walter","batsman_runs":"12","batsman_balls":"12"},{"event_id":"12102744","event":"ball","batsman_id":"49930","bowler_id":"51346","over":"16","ball":"2","score":0,"commentary":"Paul Walter to Ryan Higgins, no run,","noball_dismissal":false,"text":"","timestamp":1749396671,"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":"12102746","event":"ball","batsman_id":"49930","bowler_id":"51346","over":"16","ball":"3","score":1,"commentary":"Paul Walter to Ryan Higgins, 1 run,","noball_dismissal":false,"text":"","timestamp":1749396675,"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":"12102755","event":"ball","batsman_id":"108382","bowler_id":"51346","over":"16","ball":"4","score":6,"commentary":"Paul Walter to Ben Geddes, Six,","noball_dismissal":false,"text":"","timestamp":1749396697,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12102765","event":"ball","batsman_id":"108382","bowler_id":"51346","over":"16","ball":"5","score":6,"commentary":"Paul Walter to Ben Geddes, Six,","noball_dismissal":false,"text":"","timestamp":1749396715,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12102783","event":"ball","batsman_id":"108382","bowler_id":"51346","over":"16","ball":"6","score":6,"commentary":"Paul Walter to Ben Geddes, Six,","noball_dismissal":false,"text":"","timestamp":1749396772,"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":19,"score":"148\/4","bats":[{"runs":30,"balls_faced":11,"fours":1,"sixes":3,"batsman_id":108382},{"runs":1,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":49930}],"bowls":[{"runs_conceded":34,"maidens":0,"wickets":2,"bowler_id":51346,"overs":3},{"runs_conceded":21,"maidens":1,"wickets":1,"bowler_id":49087,"overs":3}],"commentary":"End of over 17 (19 runs), Middlesex 148\/4"},{"event_id":"12102820","event":"ball","batsman_id":"49930","bowler_id":"48647","over":"17","ball":"1","score":6,"commentary":"Matt Critchley to Ryan Higgins, Six,","noball_dismissal":false,"text":"","timestamp":1749396878,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12102830","event":"ball","batsman_id":"49930","bowler_id":"48647","over":"17","ball":"2","score":1,"commentary":"Matt Critchley to Ryan Higgins, 1 run,","noball_dismissal":false,"text":"","timestamp":1749396910,"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":"12102836","event":"ball","batsman_id":"108382","bowler_id":"48647","over":"17","ball":"3","score":4,"commentary":"Matt Critchley to Ben Geddes, Four,","noball_dismissal":false,"text":"","timestamp":1749396914,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false}],"day":"0","session":"0","live_inning":{"iid":197682,"number":2,"name":"Middlesex Inning","short_name":"MID Inning","status":2,"issuperover":"false","result":3,"batting_team_id":7044,"fielding_team_id":104950,"scores":"159\/4","scores_full":"159\/4 (17.3 ov)","fielder":[{"fielder_id":"108420","fielder_name":"Luc Benkenstein","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"1758","fielder_name":"Mohammad Amir","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"51105","fielder_name":"Michael-Kyle Pepper","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Jack Davies","batsman_id":"93517","runs":"12","balls":"12","how_out":"c MKS Pepper b PI Walter","score_at_dismissal":129,"overs_at_dismissal":"16.1","bowler_id":"51346","dismissal":"caught","number":4},"extra_runs":{"byes":0,"legbyes":0,"wides":1,"noballs":0,"penalty":"0","total":1},"equations":{"runs":159,"wickets":4,"overs":"17.3","bowlers_used":7,"runrate":"9.09"},"current_partnership":{"runs":30,"balls":8,"overs":1.2,"batsmen":[{"name":"Ryan Higgins","batsman_id":49930,"runs":8,"balls":4},{"name":"Ben Geddes","batsman_id":108382,"runs":22,"balls":4}]},"did_not_bat":[{"player_id":"93519","name":"Luke Hollman"},{"player_id":"44058","name":"Zafar Gohar"},{"player_id":"49497","name":"Tom Helm"},{"player_id":"1115","name":"Josh Little"},{"player_id":"140007","name":"Noah Cornwell"}],"max_over":"20","target":"157","recent_scores":"4,1,6,6,6,6,1,0,w,2,2,1,0,6,1,1,4,1","last_five_overs":"60\/3 12.00","last_ten_overs":"95\/4 9.50"},"teams":[{"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":"159\/4 (17.3 ov)","scores":"159\/4","overs":"17.3"},{"tid":104950,"title":"Essex","abbr":"ESS","alt_name":"ESS","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"156\/9 (20 ov)","scores":"156\/9","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":9,"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":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":8,"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":"squad","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":"bowl","role_str":""},{"pid":1758,"title":"Mohammad Amir","short_name":"M Amir","first_name":"Mohammad Amir","last_name":"","middle_name":"","birthdate":"1992-04-13","birthplace":" Gujjar Khan, Punjab","country":"pk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/iamamirofficial","instagram_profile":"https:\/\/www.instagram.com\/official.mamir\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bowl","role_str":""},{"pid":10592,"title":"Tom Westley","short_name":"TZ Westley","first_name":"Tom Westley","last_name":"","middle_name":"","birthdate":"1989-03-13","birthplace":"Cambridge","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":10602,"title":"Nick Browne","short_name":"NLJ Browne","first_name":"Nick Browne","last_name":"","middle_name":"","birthdate":"1991-03-24","birthplace":"Leytonstone, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","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":7,"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":46837,"title":"Eathan Bosch","short_name":"E Bosch","first_name":"Eathan Bosch","last_name":"","middle_name":"","birthdate":"1998-04-27","birthplace":"Westville","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"https:\/\/www.facebook.com\/eathan.bosch.14\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/eathanbosch\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":48647,"title":"Matt Critchley","short_name":"MJJ Critchley","first_name":"Matt Critchley","last_name":"","middle_name":"","birthdate":"1996-08-13","birthplace":"Preston, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/mattcritchley96","instagram_profile":"https:\/\/www.instagram.com\/critch130896\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":49083,"title":"Dean Elgar","short_name":"D Elgar","first_name":"Dean Elgar","last_name":"","middle_name":"","birthdate":"1987-06-11","birthplace":"Welkom, Orange Free state","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":36249,"recent_appearance":1514287800,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BoringDeanElgar","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bat","role_str":""},{"pid":49087,"title":"Simon Harmer","short_name":"SR Harmer","first_name":"Simon Harmer","last_name":"","middle_name":"","birthdate":"1989-02-10","birthplace":"Pretoria, Transvaal","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Simon_Harmer_","instagram_profile":"https:\/\/www.instagram.com\/simon_harmer\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bowl","role_str":"(C)"},{"pid":49376,"title":"Adam Rossington","short_name":"AM Rossington","first_name":"Adam Rossington","last_name":"","middle_name":"","birthdate":"1993-05-05","birthplace":"Edgware, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper ","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Rossington17","instagram_profile":"https:\/\/www.instagram.com\/rossington17\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"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":7,"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":8,"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":49593,"title":"Jamie Porter","short_name":"JA Porter","first_name":"Jamie Porter","last_name":"","middle_name":"","birthdate":"1993-05-25","birthplace":"Leytonstone, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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.5,"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":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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":50455,"title":"Feroze Khushi","short_name":"FIN Khushi","first_name":"Feroze Khushi","last_name":"","middle_name":"","birthdate":"1999-06-23","birthplace":"Whipps Cross, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51105,"title":"Michael-Kyle Pepper","short_name":"MKS Pepper","first_name":"Michael-Kyle Pepper","last_name":"","middle_name":"","birthdate":"1998-06-25","birthplace":"Harlow, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/michael_pep\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":""},{"pid":51346,"title":"Paul Walter","short_name":"PI Walter","first_name":"Paul Walter","last_name":"","middle_name":"","birthdate":"1994-05-28","birthplace":"Basildon, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":51347,"title":"Aaron Beard","short_name":"AP Beard","first_name":"Aaron Beard","last_name":"","middle_name":"","birthdate":"1997-10-15","birthplace":"Chelmsford, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"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.5,"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":61358,"title":"Shane Snater","short_name":"S Snater","first_name":"Shane Snater","last_name":"","middle_name":"","birthdate":"1996-03-24","birthplace":"Harare, Zimbabwe","country":"nl","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"bowl","role_str":""},{"pid":68691,"title":"Samuel Cook","short_name":"S Cook","first_name":"Samuel Cook","last_name":"","middle_name":"","birthdate":"1997-08-04","birthplace":"Chelmsford, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/samcook09","instagram_profile":"https:\/\/www.instagram.com\/s_cook16\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","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":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"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":93372,"title":"Daniel Sams","short_name":"DR Sams","first_name":"Daniel Sams","last_name":"","middle_name":"","birthdate":"1992-10-27","birthplace":" Milperra, New South Wales","country":"au","primary_team":[],"logo_url":"","playing_role":"all","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\/dansams\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","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":8,"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":94961,"title":"Jordan Cox","short_name":"J Cox","first_name":"Jordan Cox","last_name":"","middle_name":"","birthdate":"2000-10-21","birthplace":"Margate, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/jjordancox\/","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95892,"title":"Ben Allison","short_name":"B Allison","first_name":"Ben Allison","last_name":"","middle_name":"","birthdate":"1999-12-18","birthplace":"Colchester, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":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":7.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.5,"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":103358,"title":"Robin Das","short_name":"RJ Das","first_name":"Robin Das","last_name":"","middle_name":"","birthdate":"2002-02-27","birthplace":"Leytonstone","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"https:\/\/www.facebook.com\/robindascricketer","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/robinigblue\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":108393,"title":"Jamal Richards","short_name":"J Richards","first_name":"Jamal Richards","last_name":"","middle_name":"","birthdate":"2004-03-03","birthplace":"Edmonton, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108420,"title":"Luc Benkenstein","short_name":"L Benkenstein","first_name":"Luc Benkenstein","last_name":"","middle_name":"","birthdate":"2004-11-02","birthplace":"Durban","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","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":6,"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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":127517,"title":"Noah Thain","short_name":"NRM Thain","first_name":"Noah Thain","last_name":"","middle_name":"","birthdate":"2005-01-13","birthplace":"Hitchinbrooke, Hertfordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":129447,"title":"Mackenzie Jones","short_name":"Mackenzie Jones","first_name":"Mackenzie Jones","last_name":"","middle_name":"","birthdate":"2005-03-06","birthplace":"","country":"sct","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Scotland","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":134958,"title":"Charles Allison","short_name":"CW Allison","first_name":"Charles Allison","last_name":"","middle_name":"","birthdate":"2005-03-02","birthplace":"Colchester, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":141341,"title":"Simon Fernandes","short_name":"Simon Fernandes","first_name":"Simon Fernandes","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":6,"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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""}]},"etag":"4d85f0f4c92a7d700b4eabbeff7e4ffe","modified":"2025-08-01 11:43:08","datetime":"2025-08-01 11:43:08","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86855 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:03016012-b651-498b-87b0-9bad5a2039c4 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86855 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86855,3,'{"status":"ok","response":{"match_id":86855,"title":"Essex vs Middlesex","short_title":"ESS vs MID","subtitle":"Match 35","match_number":"35","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Middlesex won by 6 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129425,"title":"Vitality Blast","abbr":"Vitality Blast","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-09-13","country":"en","total_matches":"133","total_rounds":"2","total_teams":"18"},"teama":{"team_id":104950,"name":"Essex","short_name":"ESS","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","scores_full":"156\/9 (20 ov)","scores":"156\/9","overs":"20"},"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":"159\/4 (17.3 ov)","scores":"159\/4","overs":"17.3"},"date_start":"2025-06-08 13:00:00","date_end":"2025-06-08 23:00:00","timestamp_start":1749387600,"timestamp_end":1749423600,"date_start_ist":"2025-06-08 18:30:00","date_end_ist":"2025-06-09 04:30:00","venue":{"venue_id":"45","name":"County Ground, Chelmsford","location":"","country":"England","timezone":""},"umpires":"Hassan Adnan (England), Neil Bainton (England)","referee":"Helen Pack (England)","equation":"","live":"","result":"MID won by 6 wickets","result_type":2,"win_margin":"6 wickets","winning_team_id":7044,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-07 00:20:57","verify_time":"2025-06-08 21:44:28","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"broken clouds","temp":17.56,"humidity":53,"visibility":10000,"wind_speed":"12.80","clouds":79},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Middlesex elected to bowl","winner":7044,"decision":2}},"etag":"8b2dee4439ca5c91b4b854051104b4d6","modified":"2025-08-01 11:43:09","datetime":"2025-08-01 11:43:09","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":86855,"title":"Essex vs Middlesex","short_title":"ESS vs MID","subtitle":"Match 35","match_number":"35","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Middlesex won by 6 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129425,"title":"Vitality Blast","abbr":"Vitality Blast","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-09-13","country":"en","total_matches":"133","total_rounds":"2","total_teams":"18"},"teama":{"team_id":104950,"name":"Essex","short_name":"ESS","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","scores_full":"156\/9 (20 ov)","scores":"156\/9","overs":"20"},"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":"159\/4 (17.3 ov)","scores":"159\/4","overs":"17.3"},"date_start":"2025-06-08 13:00:00","date_end":"2025-06-08 23:00:00","timestamp_start":1749387600,"timestamp_end":1749423600,"date_start_ist":"2025-06-08 18:30:00","date_end_ist":"2025-06-09 04:30:00","venue":{"venue_id":"45","name":"County Ground, Chelmsford","location":"","country":"England","timezone":""},"umpires":"Hassan Adnan (England), Neil Bainton (England)","referee":"Helen Pack (England)","equation":"","live":"","result":"MID won by 6 wickets","result_type":2,"win_margin":"6 wickets","winning_team_id":7044,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-07 00:20:57","verify_time":"2025-06-08 21:44:28","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"broken clouds","temp":17.56,"humidity":53,"visibility":10000,"wind_speed":"12.80","clouds":79},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Middlesex elected to bowl","winner":7044,"decision":2}},"etag":"8b2dee4439ca5c91b4b854051104b4d6","modified":"2025-08-01 11:43:09","datetime":"2025-08-01 11:43:09","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86855 AND DataTypeId = 3 END
Live Report & Scorecard of Essex vs Middlesex Match 35
<>
CricDirect Cricket News, Results and Stats
 

Essex vs Middlesex, Match 35, Vitality Blast

Completed
Vitality Blast, Completed
Essex
ESS
156/9 (20)
Middlesex
MID
159/4 (17.3)
Middlesex won by 6 wickets
Match Details
Date
2025-06-08 13:00:00
Venue
County Ground, Chelmsford,
Toss
Middlesex elected to bowl
Umpires
    Tv Umpires
      Match Referee
        × Close