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:6459f92a-587f-4182-a50d-72a8d81bae91 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86921 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86921,1,'{"status":"ok","response":{"mid":86921,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Middlesex won by 23 runs","day_remaining_over":"","team_batting":"Gloucestershire","team_bowling":"Middlesex","live_inning_number":2,"live_score":{"runs":166,"overs":20,"wickets":7,"target":190,"runrate":8.3,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Josh Shaw","batsman_id":50007,"runs":5,"balls_faced":2,"fours":1,"sixes":0,"strike_rate":"250.00"},{"name":"David Payne","batsman_id":49526,"runs":7,"balls_faced":5,"fours":1,"sixes":0,"strike_rate":"140.00"}],"bowlers":[{"name":"Ryan Higgins","bowler_id":49930,"overs":4,"runs_conceded":31,"wickets":1,"maidens":0,"econ":"7.75"},{"name":"Tom Helm","bowler_id":49497,"overs":4,"runs_conceded":35,"wickets":1,"maidens":0,"econ":"8.75"}],"commentaries":[{"event_id":"12326954","event":"ball","batsman_id":"49747","bowler_id":"49930","over":"15","ball":"5","score":1,"commentary":"Ryan Higgins to Jack Taylor, 1 run,","noball_dismissal":false,"text":"","timestamp":1752259318,"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":"12326960","event":"ball","batsman_id":"84301","bowler_id":"49930","over":"15","ball":"6","score":1,"commentary":"Ryan Higgins to D''Arcy Short, 1 run,","noball_dismissal":false,"text":"","timestamp":1752259332,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":16,"runs":6,"score":"138\/3","bats":[{"runs":63,"balls_faced":44,"fours":8,"sixes":2,"batsman_id":84301},{"runs":39,"balls_faced":28,"fours":5,"sixes":1,"batsman_id":49747}],"bowls":[{"runs_conceded":22,"maidens":0,"wickets":0,"bowler_id":49930,"overs":3},{"runs_conceded":27,"maidens":0,"wickets":1,"bowler_id":133782,"overs":3}],"commentary":"End of over 16 (6 runs), Gloucestershire 138\/3"},{"event_id":"12326975","event":"ball","batsman_id":"84301","bowler_id":"140007","over":"16","ball":"1","score":1,"commentary":"Noah Cornwell to D''Arcy Short, 1 run,","noball_dismissal":false,"text":"","timestamp":1752259409,"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":"12326992","event":"ball","batsman_id":"49747","bowler_id":"140007","over":"16","ball":"2","score":0,"commentary":"Noah Cornwell to Jack Taylor, no run,","noball_dismissal":false,"text":"","timestamp":1752259514,"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":"12326993","event":"ball","batsman_id":"49747","bowler_id":"140007","over":"16","ball":"3","score":1,"commentary":"Noah Cornwell to Jack Taylor, 1 run,","noball_dismissal":false,"text":"","timestamp":1752259517,"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":"12326998","event":"wicket","batsman_id":"84301","bowler_id":"140007","over":"16","ball":"4","score":"w","commentary":"Noah Cornwell to D''Arcy Short, no run, c JB Cracknell b N Cornwell,","noball_dismissal":false,"text":"","timestamp":1752259576,"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":"84301","how_out":"c JB Cracknell b N Cornwell","batsman_runs":"64","batsman_balls":"46"},{"event_id":"12327007","event":"ball","batsman_id":"88692","bowler_id":"140007","over":"16","ball":"5","score":1,"commentary":"Noah Cornwell to Ben Charlesworth, 1 run,","noball_dismissal":false,"text":"","timestamp":1752259591,"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":"12327011","event":"ball","batsman_id":"49747","bowler_id":"140007","over":"16","ball":"6","score":1,"commentary":"Noah Cornwell to Jack Taylor, 1 run,","noball_dismissal":false,"text":"","timestamp":1752259622,"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":17,"runs":4,"score":"142\/4","bats":[{"runs":41,"balls_faced":31,"fours":5,"sixes":1,"batsman_id":49747},{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":88692}],"bowls":[{"runs_conceded":20,"maidens":0,"wickets":1,"bowler_id":140007,"overs":4},{"runs_conceded":22,"maidens":0,"wickets":0,"bowler_id":49930,"overs":3}],"commentary":"End of over 17 (4 runs), Gloucestershire 142\/4"},{"event_id":"12327029","event":"wicket","batsman_id":"49747","bowler_id":"133782","over":"17","ball":"1","score":"w","commentary":"Sebastian Morgan to Jack Taylor, no run, c K Williamson b SB Morgan,","noball_dismissal":false,"text":"","timestamp":1752259734,"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":"49747","how_out":"c K Williamson b SB Morgan","batsman_runs":"41","batsman_balls":"32"},{"event_id":"12327031","event":"ball","batsman_id":"47533","bowler_id":"133782","over":"17","ball":"2","score":1,"commentary":"Sebastian Morgan to Graeme van Buuren, 1 run,","noball_dismissal":false,"text":"","timestamp":1752259751,"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":"12327036","event":"ball","batsman_id":"88692","bowler_id":"133782","over":"17","ball":"3","score":1,"commentary":"Sebastian Morgan to Ben Charlesworth, 1 run,","noball_dismissal":false,"text":"","timestamp":1752259790,"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":"12327038","event":"ball","batsman_id":"47533","bowler_id":"133782","over":"17","ball":"4","score":1,"commentary":"Sebastian Morgan to Graeme van Buuren, 1 run,","noball_dismissal":false,"text":"","timestamp":1752259826,"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":"12327051","event":"ball","batsman_id":"88692","bowler_id":"133782","over":"17","ball":"5","score":0,"commentary":"Sebastian Morgan to Ben Charlesworth, no run,","noball_dismissal":false,"text":"","timestamp":1752259858,"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":"12327056","event":"ball","batsman_id":"88692","bowler_id":"133782","over":"17","ball":"6","score":4,"commentary":"Sebastian Morgan to Ben Charlesworth, Four,","noball_dismissal":false,"text":"","timestamp":1752259883,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event":"overend","over":18,"runs":7,"score":"149\/5","bats":[{"runs":6,"balls_faced":4,"fours":1,"sixes":0,"batsman_id":88692},{"runs":2,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":47533}],"bowls":[{"runs_conceded":34,"maidens":0,"wickets":2,"bowler_id":133782,"overs":4},{"runs_conceded":20,"maidens":0,"wickets":1,"bowler_id":140007,"overs":4}],"commentary":"End of over 18 (7 runs), Gloucestershire 149\/5"},{"event_id":"12327064","event":"wicket","batsman_id":"47533","bowler_id":"49497","over":"18","ball":"1","score":"w","commentary":"Tom Helm to Graeme van Buuren, no run, c JLdu Plooy b TG Helm,","noball_dismissal":false,"text":"","timestamp":1752259968,"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":"47533","how_out":"c JLdu Plooy b TG Helm","batsman_runs":"2","batsman_balls":"3"},{"event_id":"12327072","event":"ball","batsman_id":"49526","bowler_id":"49497","over":"18","ball":"2","score":2,"commentary":"Tom Helm to David Payne, 2 runs,","noball_dismissal":false,"text":"","timestamp":1752260003,"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":"12327076","event":"ball","batsman_id":"49526","bowler_id":"49497","over":"18","ball":"3","score":4,"commentary":"Tom Helm to David Payne, Four,","noball_dismissal":false,"text":"","timestamp":1752260030,"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":"12327084","event":"ball","batsman_id":"49526","bowler_id":"49497","over":"18","ball":"4","score":0,"commentary":"Tom Helm to David Payne, no run,","noball_dismissal":false,"text":"","timestamp":1752260080,"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":"12327086","event":"ball","batsman_id":"49526","bowler_id":"49497","over":"18","ball":"5","score":1,"commentary":"Tom Helm to David Payne, 1 run,","noball_dismissal":false,"text":"","timestamp":1752260093,"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":"12327094","event":"ball","batsman_id":"88692","bowler_id":"49497","over":"18","ball":"6","score":1,"commentary":"Tom Helm to Ben Charlesworth, 1 run,","noball_dismissal":false,"text":"","timestamp":1752260147,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":19,"runs":8,"score":"157\/6","bats":[{"runs":7,"balls_faced":5,"fours":1,"sixes":0,"batsman_id":88692},{"runs":7,"balls_faced":4,"fours":1,"sixes":0,"batsman_id":49526}],"bowls":[{"runs_conceded":35,"maidens":0,"wickets":1,"bowler_id":49497,"overs":4},{"runs_conceded":34,"maidens":0,"wickets":2,"bowler_id":133782,"overs":4}],"commentary":"End of over 19 (8 runs), Gloucestershire 157\/6"},{"event_id":"12327102","event":"ball","batsman_id":"88692","bowler_id":"49930","over":"19","ball":"1","score":2,"commentary":"Ryan Higgins to Ben Charlesworth, 2 runs,","noball_dismissal":false,"text":"","timestamp":1752260245,"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":"12327103","event":"ball","batsman_id":"88692","bowler_id":"49930","over":"19","ball":"2","score":2,"commentary":"Ryan Higgins to Ben Charlesworth, 2 runs,","noball_dismissal":false,"text":"","timestamp":1752260249,"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":"12327105","event":"wicket","batsman_id":"88692","bowler_id":"49930","over":"19","ball":"3","score":"w","commentary":"Ryan Higgins to Ben Charlesworth, no run, lbw b RF Higgins,","noball_dismissal":false,"text":"","timestamp":1752260278,"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":"88692","how_out":"lbw b RF Higgins","batsman_runs":"11","batsman_balls":"8"},{"event_id":"12327131","event":"ball","batsman_id":"50007","bowler_id":"49930","over":"19","ball":"4","score":4,"commentary":"Ryan Higgins to Josh Shaw, Four,","noball_dismissal":false,"text":"","timestamp":1752260495,"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":"12327132","event":"ball","batsman_id":"50007","bowler_id":"49930","over":"19","ball":"5","score":1,"commentary":"Ryan Higgins to Josh Shaw, 1 run,","noball_dismissal":false,"text":"","timestamp":1752260498,"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":"12327134","event":"ball","batsman_id":"49526","bowler_id":"49930","over":"19","ball":"6","score":0,"commentary":"Ryan Higgins to David Payne, no run,","noball_dismissal":false,"text":"","timestamp":1752260500,"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":20,"runs":9,"score":"166\/7","bats":[{"runs":7,"balls_faced":5,"fours":1,"sixes":0,"batsman_id":49526},{"runs":5,"balls_faced":2,"fours":1,"sixes":0,"batsman_id":50007}],"bowls":[{"runs_conceded":31,"maidens":0,"wickets":1,"bowler_id":49930,"overs":4},{"runs_conceded":35,"maidens":0,"wickets":1,"bowler_id":49497,"overs":4}],"commentary":"End of over 20 (9 runs), Gloucestershire 166\/7"}],"day":"0","session":"0","live_inning":{"iid":199486,"number":2,"name":"Gloucestershire Inning","short_name":"GLO Inning","status":2,"issuperover":"false","result":4,"batting_team_id":7017,"fielding_team_id":7044,"scores":"166\/7","scores_full":"166\/7 (20 ov)","fielder":[{"fielder_id":"53281","fielder_name":"Leus du Plooy","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"101478","fielder_name":"Joe Benjamin Cracknell","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"31","fielder_name":"Kane Williamson","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"49497","fielder_name":"Tom Helm","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":"Ben Charlesworth","batsman_id":"88692","runs":"11","balls":"8","how_out":"lbw b RF Higgins","score_at_dismissal":161,"overs_at_dismissal":"19.3","bowler_id":"49930","dismissal":"lbw","number":7},"extra_runs":{"byes":0,"legbyes":3,"wides":5,"noballs":0,"penalty":"0","total":8},"equations":{"runs":166,"wickets":7,"overs":"20","bowlers_used":6,"runrate":"8.30"},"current_partnership":{"runs":5,"balls":3,"overs":0.3,"batsmen":[{"name":"Josh Shaw","batsman_id":50007,"runs":5,"balls":2},{"name":"David Payne","batsman_id":49526,"runs":0,"balls":1}]},"did_not_bat":[{"player_id":"847","name":"Marchant de Lange"},{"player_id":"101483","name":"Ajeet Singh Dale"}],"max_over":"20","target":"190","recent_scores":"0,1,4,w,2,2,1,1,0,4,2,w,4,0,1,1,1,w","last_five_overs":"34\/4 6.80","last_ten_overs":"79\/4 7.90"},"teams":[{"tid":7017,"title":"Gloucestershire","abbr":"GLO","alt_name":"GLO","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-GLO@2x.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-GLO@2x.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"166\/7 (20 ov)","scores":"166\/7","overs":"20"},{"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":"189\/5 (20 ov)","scores":"189\/5","overs":"20"}],"players":[{"pid":31,"title":"Kane Williamson","short_name":"K Williamson","first_name":"Kane Williamson","last_name":"","middle_name":"","birthdate":"1990-08-08","birthplace":"Tauranga","country":"nz","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":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":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bat","role_str":""},{"pid":847,"title":"Marchant de Lange","short_name":"MD Lange","first_name":"Marchant de Lange","last_name":"","middle_name":"","birthdate":"1990-10-13","birthplace":"Tzaneen, Limpopo","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Marchant90","instagram_profile":"https:\/\/www.instagram.com\/marchant.delange\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bowl","role_str":""},{"pid":1043,"title":"Max Holden","short_name":"MDE Holden","first_name":"Max Holden","last_name":"","middle_name":"","birthdate":"1997-12-18","birthplace":" Cambridge","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/maxholden_4","instagram_profile":"https:\/\/www.instagram.com\/maxholden4\/","debut_data":"","bowling_type":"Spin","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/joshlittle13\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":16594,"title":"Matt Taylor","short_name":"MD Taylor","first_name":"Matt Taylor","last_name":"","middle_name":"","birthdate":"1994-07-08","birthplace":"Banbury, Oxfordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":43563,"title":"Cameron Bancroft","short_name":"CT Bancroft","first_name":"Cameron Bancroft","last_name":"","middle_name":"","birthdate":"1992-11-19","birthplace":" Attadale, Australia","country":"au","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper ","recent_match":18968,"recent_appearance":1514244600,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/cbancroft4\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"wk","role_str":"(WK)"},{"pid":44058,"title":"Zafar Gohar","short_name":"ZG Gohar","first_name":"Zafar Gohar","last_name":"","middle_name":"","birthdate":"1995-02-01","birthplace":"Lahore, Punjab","country":"pk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/iamzafargohar","instagram_profile":"https:\/\/www.instagram.com\/iamzafargohar\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bowl","role_str":""},{"pid":47533,"title":"Graeme van Buuren","short_name":"GL Buuren","first_name":"Graeme van Buuren","last_name":"","middle_name":"","birthdate":"1990-08-22","birthplace":"Pretoria, Transvaal","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/graemegvb\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":49493,"title":"Sam Robson","short_name":"SD Robson","first_name":"Sam Robson","last_name":"","middle_name":"","birthdate":"1989-07-01","birthplace":"Paddington, Sydney, New South Wales","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"https:\/\/www.facebook.com\/samrobson664\/","twitter_profile":"https:\/\/twitter.com\/Samrobsonfans12","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49497,"title":"Tom Helm","short_name":"TG Helm","first_name":"Tom Helm","last_name":"","middle_name":"","birthdate":"1994-05-07","birthplace":"Stoke Mandeville Hospital, Buckinghamshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/TomHelm7","instagram_profile":"https:\/\/www.instagram.com\/helmy__7\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":49519,"title":"Chris Dent","short_name":"CDJ Dent","first_name":"Chris Dent","last_name":"","middle_name":"","birthdate":"1991-01-20","birthplace":"Bristol","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"Occasional Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Cdent15","instagram_profile":"https:\/\/www.instagram.com\/chrisdent15\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49526,"title":"David Payne","short_name":"DA Payne","first_name":"David Payne","last_name":"","middle_name":"","birthdate":"1991-02-15","birthplace":"Poole, Dorset","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/DavidPayne_14","instagram_profile":"https:\/\/www.instagram.com\/sidpayne14\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":49747,"title":"Jack Taylor","short_name":"JMR Taylor","first_name":"Jack Taylor","last_name":"","middle_name":"","birthdate":"1991-11-12","birthplace":"Banbury, Oxfordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"pid":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":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/tobyrj21","instagram_profile":"https:\/\/www.instagram.com\/tobyrj21\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49812,"title":"Miles Hammond","short_name":"MAH Hammond","first_name":"Miles Hammond","last_name":"","middle_name":"","birthdate":"1996-01-11","birthplace":"Cheltenham, Gloucestershire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/milesAHH","instagram_profile":"https:\/\/www.instagram.com\/hammo_gram\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":50007,"title":"Josh Shaw","short_name":"J Shaw","first_name":"Josh Shaw","last_name":"","middle_name":"","birthdate":"1996-01-03","birthplace":"Wakefield, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/joshuashaw1","instagram_profile":"https:\/\/www.instagram.com\/joshshaw5931\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":50425,"title":"James Bracey","short_name":"JR Bracey","first_name":"James Bracey","last_name":"","middle_name":"","birthdate":"1997-05-03","birthplace":"Bristol","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/james_bracey\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"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":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/leusdup76","instagram_profile":"https:\/\/www.instagram.com\/leusdup76\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bat","role_str":"(C)"},{"pid":58686,"title":"Tom Smith","short_name":"TC Smith","first_name":"Tom Smith","last_name":"","middle_name":"","birthdate":"1987-08-29","birthplace":"Liverpool","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/tmjsmith6\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":84301,"title":"D''Arcy Short","short_name":"DJM Short","first_name":"D''Arcy Short","last_name":"","middle_name":"","birthdate":"1990-08-09","birthplace":" Katherine, Northern Territory","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":18958,"recent_appearance":1517646000,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/shortyjnr23\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Australia","role":"all","role_str":""},{"pid":88692,"title":"Ben Charlesworth","short_name":"BG Charlesworth","first_name":"Ben Charlesworth","last_name":"","middle_name":"","birthdate":"2000-11-19","birthplace":"Oxford","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/bencharlesworth_\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":90974,"title":"Henry Brookes","short_name":"HJH Brookes","first_name":"Henry Brookes","last_name":"","middle_name":"","birthdate":"1999-08-21","birthplace":"Solihull, Warwickshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BrookesHenry","instagram_profile":"https:\/\/www.instagram.com\/henry.brookes\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":93130,"title":"Cameron Green","short_name":"C Green","first_name":"Cameron Green","last_name":"","middle_name":"","birthdate":"1999-06-03","birthplace":"Perth, Australia","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/CameronGreen_","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":93517,"title":"Jack Davies","short_name":"JLB Davies","first_name":"Jack Davies","last_name":"","middle_name":"","birthdate":"2000-03-30","birthplace":"Reading, Berkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/daviesjlb","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/lukehollman56\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":95478,"title":"Tom Price","short_name":"TJ Price","first_name":"Tom Price","last_name":"","middle_name":"","birthdate":"2000-01-02","birthplace":"Oxford, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/joe_cracknell\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":101483,"title":"Ajeet Singh Dale","short_name":"Ajeet Singh Dale","first_name":"Ajeet Singh Dale","last_name":"","middle_name":"","birthdate":"2000-07-02","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":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":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/seskinazi","instagram_profile":"https:\/\/www.instagram.com\/seskinazi\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":""},{"pid":107311,"title":"Dominic Goodman","short_name":"DC Goodman","first_name":"Dominic Goodman","last_name":"","middle_name":"","birthdate":"2000-10-23","birthplace":"Ashford, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/domgoodman_\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":107312,"title":"Ollie Price","short_name":"O Price","first_name":"Ollie Price","last_name":"","middle_name":"","birthdate":"2001-06-12","birthplace":"Oxford","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":110606,"title":"Zaman Akhter","short_name":"Z Akhter","first_name":"Zaman Akhter","last_name":"","middle_name":"","birthdate":"1999-03-12","birthplace":"Cambridge","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":116661,"title":"Ishaan Kaushal","short_name":"I Kaushal","first_name":"Ishaan Kaushal","last_name":"","middle_name":"","birthdate":"2002-02-09","birthplace":"Hillingdon, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":116662,"title":"Luke Charlesworth","short_name":"LA Charlesworth","first_name":"Luke Charlesworth","last_name":"","middle_name":"","birthdate":"2003-04-04","birthplace":"Oxford","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":118935,"title":"Tommy Boorman","short_name":"Tommy Boorman","first_name":"Tommy Boorman","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":127440,"title":"Joe Phillips","short_name":"JP Phillips","first_name":"Joe Phillips","last_name":"","middle_name":"","birthdate":"2003-11-09","birthplace":"Truro, Cornwall","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":127503,"title":"Josh De Caires","short_name":"J D caires","first_name":"Josh De Caires","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":129244,"title":"Nathan Fernandes","short_name":"N Fernandes","first_name":"Nathan Fernandes","last_name":"","middle_name":"","birthdate":"2004-04-26","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":130759,"title":"Ahmed Mujtaba Syed","short_name":"A Mujtaba Syed","first_name":"Ahmed Mujtaba Syed","last_name":"","middle_name":"","birthdate":"2004-09-26","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":130760,"title":"Edward Middleton","short_name":"Ed Middleton","first_name":"Edward Middleton","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":133782,"title":"Sebastian Morgan","short_name":"SB Morgan","first_name":"Sebastian Morgan","last_name":"","middle_name":"","birthdate":"2007-08-30","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":139986,"title":"Archie Bailey","short_name":"A Bailey","first_name":"Archie Bailey","last_name":"","middle_name":"","birthdate":"2005-06-28","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":146167,"title":"Aaryan Sawant","short_name":"A Sawant","first_name":"Aaryan Sawant","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":149124,"title":"Aman Rao","short_name":"Aman Rao","first_name":"Aman Rao","last_name":"","middle_name":"","birthdate":"2004-06-22","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""}]},"etag":"78a63f35545cd823e0ad135d3e32f320","modified":"2025-07-15 00:19:33","datetime":"2025-07-15 00:19:33","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":86921,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Middlesex won by 23 runs","day_remaining_over":"","team_batting":"Gloucestershire","team_bowling":"Middlesex","live_inning_number":2,"live_score":{"runs":166,"overs":20,"wickets":7,"target":190,"runrate":8.3,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Josh Shaw","batsman_id":50007,"runs":5,"balls_faced":2,"fours":1,"sixes":0,"strike_rate":"250.00"},{"name":"David Payne","batsman_id":49526,"runs":7,"balls_faced":5,"fours":1,"sixes":0,"strike_rate":"140.00"}],"bowlers":[{"name":"Ryan Higgins","bowler_id":49930,"overs":4,"runs_conceded":31,"wickets":1,"maidens":0,"econ":"7.75"},{"name":"Tom Helm","bowler_id":49497,"overs":4,"runs_conceded":35,"wickets":1,"maidens":0,"econ":"8.75"}],"commentaries":[{"event_id":"12326954","event":"ball","batsman_id":"49747","bowler_id":"49930","over":"15","ball":"5","score":1,"commentary":"Ryan Higgins to Jack Taylor, 1 run,","noball_dismissal":false,"text":"","timestamp":1752259318,"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":"12326960","event":"ball","batsman_id":"84301","bowler_id":"49930","over":"15","ball":"6","score":1,"commentary":"Ryan Higgins to D''Arcy Short, 1 run,","noball_dismissal":false,"text":"","timestamp":1752259332,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":16,"runs":6,"score":"138\/3","bats":[{"runs":63,"balls_faced":44,"fours":8,"sixes":2,"batsman_id":84301},{"runs":39,"balls_faced":28,"fours":5,"sixes":1,"batsman_id":49747}],"bowls":[{"runs_conceded":22,"maidens":0,"wickets":0,"bowler_id":49930,"overs":3},{"runs_conceded":27,"maidens":0,"wickets":1,"bowler_id":133782,"overs":3}],"commentary":"End of over 16 (6 runs), Gloucestershire 138\/3"},{"event_id":"12326975","event":"ball","batsman_id":"84301","bowler_id":"140007","over":"16","ball":"1","score":1,"commentary":"Noah Cornwell to D''Arcy Short, 1 run,","noball_dismissal":false,"text":"","timestamp":1752259409,"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":"12326992","event":"ball","batsman_id":"49747","bowler_id":"140007","over":"16","ball":"2","score":0,"commentary":"Noah Cornwell to Jack Taylor, no run,","noball_dismissal":false,"text":"","timestamp":1752259514,"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":"12326993","event":"ball","batsman_id":"49747","bowler_id":"140007","over":"16","ball":"3","score":1,"commentary":"Noah Cornwell to Jack Taylor, 1 run,","noball_dismissal":false,"text":"","timestamp":1752259517,"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":"12326998","event":"wicket","batsman_id":"84301","bowler_id":"140007","over":"16","ball":"4","score":"w","commentary":"Noah Cornwell to D''Arcy Short, no run, c JB Cracknell b N Cornwell,","noball_dismissal":false,"text":"","timestamp":1752259576,"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":"84301","how_out":"c JB Cracknell b N Cornwell","batsman_runs":"64","batsman_balls":"46"},{"event_id":"12327007","event":"ball","batsman_id":"88692","bowler_id":"140007","over":"16","ball":"5","score":1,"commentary":"Noah Cornwell to Ben Charlesworth, 1 run,","noball_dismissal":false,"text":"","timestamp":1752259591,"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":"12327011","event":"ball","batsman_id":"49747","bowler_id":"140007","over":"16","ball":"6","score":1,"commentary":"Noah Cornwell to Jack Taylor, 1 run,","noball_dismissal":false,"text":"","timestamp":1752259622,"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":17,"runs":4,"score":"142\/4","bats":[{"runs":41,"balls_faced":31,"fours":5,"sixes":1,"batsman_id":49747},{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":88692}],"bowls":[{"runs_conceded":20,"maidens":0,"wickets":1,"bowler_id":140007,"overs":4},{"runs_conceded":22,"maidens":0,"wickets":0,"bowler_id":49930,"overs":3}],"commentary":"End of over 17 (4 runs), Gloucestershire 142\/4"},{"event_id":"12327029","event":"wicket","batsman_id":"49747","bowler_id":"133782","over":"17","ball":"1","score":"w","commentary":"Sebastian Morgan to Jack Taylor, no run, c K Williamson b SB Morgan,","noball_dismissal":false,"text":"","timestamp":1752259734,"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":"49747","how_out":"c K Williamson b SB Morgan","batsman_runs":"41","batsman_balls":"32"},{"event_id":"12327031","event":"ball","batsman_id":"47533","bowler_id":"133782","over":"17","ball":"2","score":1,"commentary":"Sebastian Morgan to Graeme van Buuren, 1 run,","noball_dismissal":false,"text":"","timestamp":1752259751,"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":"12327036","event":"ball","batsman_id":"88692","bowler_id":"133782","over":"17","ball":"3","score":1,"commentary":"Sebastian Morgan to Ben Charlesworth, 1 run,","noball_dismissal":false,"text":"","timestamp":1752259790,"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":"12327038","event":"ball","batsman_id":"47533","bowler_id":"133782","over":"17","ball":"4","score":1,"commentary":"Sebastian Morgan to Graeme van Buuren, 1 run,","noball_dismissal":false,"text":"","timestamp":1752259826,"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":"12327051","event":"ball","batsman_id":"88692","bowler_id":"133782","over":"17","ball":"5","score":0,"commentary":"Sebastian Morgan to Ben Charlesworth, no run,","noball_dismissal":false,"text":"","timestamp":1752259858,"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":"12327056","event":"ball","batsman_id":"88692","bowler_id":"133782","over":"17","ball":"6","score":4,"commentary":"Sebastian Morgan to Ben Charlesworth, Four,","noball_dismissal":false,"text":"","timestamp":1752259883,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event":"overend","over":18,"runs":7,"score":"149\/5","bats":[{"runs":6,"balls_faced":4,"fours":1,"sixes":0,"batsman_id":88692},{"runs":2,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":47533}],"bowls":[{"runs_conceded":34,"maidens":0,"wickets":2,"bowler_id":133782,"overs":4},{"runs_conceded":20,"maidens":0,"wickets":1,"bowler_id":140007,"overs":4}],"commentary":"End of over 18 (7 runs), Gloucestershire 149\/5"},{"event_id":"12327064","event":"wicket","batsman_id":"47533","bowler_id":"49497","over":"18","ball":"1","score":"w","commentary":"Tom Helm to Graeme van Buuren, no run, c JLdu Plooy b TG Helm,","noball_dismissal":false,"text":"","timestamp":1752259968,"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":"47533","how_out":"c JLdu Plooy b TG Helm","batsman_runs":"2","batsman_balls":"3"},{"event_id":"12327072","event":"ball","batsman_id":"49526","bowler_id":"49497","over":"18","ball":"2","score":2,"commentary":"Tom Helm to David Payne, 2 runs,","noball_dismissal":false,"text":"","timestamp":1752260003,"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":"12327076","event":"ball","batsman_id":"49526","bowler_id":"49497","over":"18","ball":"3","score":4,"commentary":"Tom Helm to David Payne, Four,","noball_dismissal":false,"text":"","timestamp":1752260030,"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":"12327084","event":"ball","batsman_id":"49526","bowler_id":"49497","over":"18","ball":"4","score":0,"commentary":"Tom Helm to David Payne, no run,","noball_dismissal":false,"text":"","timestamp":1752260080,"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":"12327086","event":"ball","batsman_id":"49526","bowler_id":"49497","over":"18","ball":"5","score":1,"commentary":"Tom Helm to David Payne, 1 run,","noball_dismissal":false,"text":"","timestamp":1752260093,"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":"12327094","event":"ball","batsman_id":"88692","bowler_id":"49497","over":"18","ball":"6","score":1,"commentary":"Tom Helm to Ben Charlesworth, 1 run,","noball_dismissal":false,"text":"","timestamp":1752260147,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":19,"runs":8,"score":"157\/6","bats":[{"runs":7,"balls_faced":5,"fours":1,"sixes":0,"batsman_id":88692},{"runs":7,"balls_faced":4,"fours":1,"sixes":0,"batsman_id":49526}],"bowls":[{"runs_conceded":35,"maidens":0,"wickets":1,"bowler_id":49497,"overs":4},{"runs_conceded":34,"maidens":0,"wickets":2,"bowler_id":133782,"overs":4}],"commentary":"End of over 19 (8 runs), Gloucestershire 157\/6"},{"event_id":"12327102","event":"ball","batsman_id":"88692","bowler_id":"49930","over":"19","ball":"1","score":2,"commentary":"Ryan Higgins to Ben Charlesworth, 2 runs,","noball_dismissal":false,"text":"","timestamp":1752260245,"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":"12327103","event":"ball","batsman_id":"88692","bowler_id":"49930","over":"19","ball":"2","score":2,"commentary":"Ryan Higgins to Ben Charlesworth, 2 runs,","noball_dismissal":false,"text":"","timestamp":1752260249,"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":"12327105","event":"wicket","batsman_id":"88692","bowler_id":"49930","over":"19","ball":"3","score":"w","commentary":"Ryan Higgins to Ben Charlesworth, no run, lbw b RF Higgins,","noball_dismissal":false,"text":"","timestamp":1752260278,"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":"88692","how_out":"lbw b RF Higgins","batsman_runs":"11","batsman_balls":"8"},{"event_id":"12327131","event":"ball","batsman_id":"50007","bowler_id":"49930","over":"19","ball":"4","score":4,"commentary":"Ryan Higgins to Josh Shaw, Four,","noball_dismissal":false,"text":"","timestamp":1752260495,"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":"12327132","event":"ball","batsman_id":"50007","bowler_id":"49930","over":"19","ball":"5","score":1,"commentary":"Ryan Higgins to Josh Shaw, 1 run,","noball_dismissal":false,"text":"","timestamp":1752260498,"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":"12327134","event":"ball","batsman_id":"49526","bowler_id":"49930","over":"19","ball":"6","score":0,"commentary":"Ryan Higgins to David Payne, no run,","noball_dismissal":false,"text":"","timestamp":1752260500,"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":20,"runs":9,"score":"166\/7","bats":[{"runs":7,"balls_faced":5,"fours":1,"sixes":0,"batsman_id":49526},{"runs":5,"balls_faced":2,"fours":1,"sixes":0,"batsman_id":50007}],"bowls":[{"runs_conceded":31,"maidens":0,"wickets":1,"bowler_id":49930,"overs":4},{"runs_conceded":35,"maidens":0,"wickets":1,"bowler_id":49497,"overs":4}],"commentary":"End of over 20 (9 runs), Gloucestershire 166\/7"}],"day":"0","session":"0","live_inning":{"iid":199486,"number":2,"name":"Gloucestershire Inning","short_name":"GLO Inning","status":2,"issuperover":"false","result":4,"batting_team_id":7017,"fielding_team_id":7044,"scores":"166\/7","scores_full":"166\/7 (20 ov)","fielder":[{"fielder_id":"53281","fielder_name":"Leus du Plooy","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"101478","fielder_name":"Joe Benjamin Cracknell","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"31","fielder_name":"Kane Williamson","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"49497","fielder_name":"Tom Helm","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":"Ben Charlesworth","batsman_id":"88692","runs":"11","balls":"8","how_out":"lbw b RF Higgins","score_at_dismissal":161,"overs_at_dismissal":"19.3","bowler_id":"49930","dismissal":"lbw","number":7},"extra_runs":{"byes":0,"legbyes":3,"wides":5,"noballs":0,"penalty":"0","total":8},"equations":{"runs":166,"wickets":7,"overs":"20","bowlers_used":6,"runrate":"8.30"},"current_partnership":{"runs":5,"balls":3,"overs":0.3,"batsmen":[{"name":"Josh Shaw","batsman_id":50007,"runs":5,"balls":2},{"name":"David Payne","batsman_id":49526,"runs":0,"balls":1}]},"did_not_bat":[{"player_id":"847","name":"Marchant de Lange"},{"player_id":"101483","name":"Ajeet Singh Dale"}],"max_over":"20","target":"190","recent_scores":"0,1,4,w,2,2,1,1,0,4,2,w,4,0,1,1,1,w","last_five_overs":"34\/4 6.80","last_ten_overs":"79\/4 7.90"},"teams":[{"tid":7017,"title":"Gloucestershire","abbr":"GLO","alt_name":"GLO","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-GLO@2x.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-GLO@2x.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"166\/7 (20 ov)","scores":"166\/7","overs":"20"},{"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":"189\/5 (20 ov)","scores":"189\/5","overs":"20"}],"players":[{"pid":31,"title":"Kane Williamson","short_name":"K Williamson","first_name":"Kane Williamson","last_name":"","middle_name":"","birthdate":"1990-08-08","birthplace":"Tauranga","country":"nz","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":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":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bat","role_str":""},{"pid":847,"title":"Marchant de Lange","short_name":"MD Lange","first_name":"Marchant de Lange","last_name":"","middle_name":"","birthdate":"1990-10-13","birthplace":"Tzaneen, Limpopo","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Marchant90","instagram_profile":"https:\/\/www.instagram.com\/marchant.delange\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bowl","role_str":""},{"pid":1043,"title":"Max Holden","short_name":"MDE Holden","first_name":"Max Holden","last_name":"","middle_name":"","birthdate":"1997-12-18","birthplace":" Cambridge","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/maxholden_4","instagram_profile":"https:\/\/www.instagram.com\/maxholden4\/","debut_data":"","bowling_type":"Spin","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/joshlittle13\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":16594,"title":"Matt Taylor","short_name":"MD Taylor","first_name":"Matt Taylor","last_name":"","middle_name":"","birthdate":"1994-07-08","birthplace":"Banbury, Oxfordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":43563,"title":"Cameron Bancroft","short_name":"CT Bancroft","first_name":"Cameron Bancroft","last_name":"","middle_name":"","birthdate":"1992-11-19","birthplace":" Attadale, Australia","country":"au","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper ","recent_match":18968,"recent_appearance":1514244600,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/cbancroft4\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"wk","role_str":"(WK)"},{"pid":44058,"title":"Zafar Gohar","short_name":"ZG Gohar","first_name":"Zafar Gohar","last_name":"","middle_name":"","birthdate":"1995-02-01","birthplace":"Lahore, Punjab","country":"pk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/iamzafargohar","instagram_profile":"https:\/\/www.instagram.com\/iamzafargohar\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bowl","role_str":""},{"pid":47533,"title":"Graeme van Buuren","short_name":"GL Buuren","first_name":"Graeme van Buuren","last_name":"","middle_name":"","birthdate":"1990-08-22","birthplace":"Pretoria, Transvaal","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/graemegvb\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":49493,"title":"Sam Robson","short_name":"SD Robson","first_name":"Sam Robson","last_name":"","middle_name":"","birthdate":"1989-07-01","birthplace":"Paddington, Sydney, New South Wales","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"https:\/\/www.facebook.com\/samrobson664\/","twitter_profile":"https:\/\/twitter.com\/Samrobsonfans12","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49497,"title":"Tom Helm","short_name":"TG Helm","first_name":"Tom Helm","last_name":"","middle_name":"","birthdate":"1994-05-07","birthplace":"Stoke Mandeville Hospital, Buckinghamshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/TomHelm7","instagram_profile":"https:\/\/www.instagram.com\/helmy__7\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":49519,"title":"Chris Dent","short_name":"CDJ Dent","first_name":"Chris Dent","last_name":"","middle_name":"","birthdate":"1991-01-20","birthplace":"Bristol","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"Occasional Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Cdent15","instagram_profile":"https:\/\/www.instagram.com\/chrisdent15\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49526,"title":"David Payne","short_name":"DA Payne","first_name":"David Payne","last_name":"","middle_name":"","birthdate":"1991-02-15","birthplace":"Poole, Dorset","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/DavidPayne_14","instagram_profile":"https:\/\/www.instagram.com\/sidpayne14\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":49747,"title":"Jack Taylor","short_name":"JMR Taylor","first_name":"Jack Taylor","last_name":"","middle_name":"","birthdate":"1991-11-12","birthplace":"Banbury, Oxfordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"pid":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":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/tobyrj21","instagram_profile":"https:\/\/www.instagram.com\/tobyrj21\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49812,"title":"Miles Hammond","short_name":"MAH Hammond","first_name":"Miles Hammond","last_name":"","middle_name":"","birthdate":"1996-01-11","birthplace":"Cheltenham, Gloucestershire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/milesAHH","instagram_profile":"https:\/\/www.instagram.com\/hammo_gram\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":50007,"title":"Josh Shaw","short_name":"J Shaw","first_name":"Josh Shaw","last_name":"","middle_name":"","birthdate":"1996-01-03","birthplace":"Wakefield, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/joshuashaw1","instagram_profile":"https:\/\/www.instagram.com\/joshshaw5931\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":50425,"title":"James Bracey","short_name":"JR Bracey","first_name":"James Bracey","last_name":"","middle_name":"","birthdate":"1997-05-03","birthplace":"Bristol","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/james_bracey\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"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":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/leusdup76","instagram_profile":"https:\/\/www.instagram.com\/leusdup76\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bat","role_str":"(C)"},{"pid":58686,"title":"Tom Smith","short_name":"TC Smith","first_name":"Tom Smith","last_name":"","middle_name":"","birthdate":"1987-08-29","birthplace":"Liverpool","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/tmjsmith6\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":84301,"title":"D''Arcy Short","short_name":"DJM Short","first_name":"D''Arcy Short","last_name":"","middle_name":"","birthdate":"1990-08-09","birthplace":" Katherine, Northern Territory","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":18958,"recent_appearance":1517646000,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/shortyjnr23\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Australia","role":"all","role_str":""},{"pid":88692,"title":"Ben Charlesworth","short_name":"BG Charlesworth","first_name":"Ben Charlesworth","last_name":"","middle_name":"","birthdate":"2000-11-19","birthplace":"Oxford","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/bencharlesworth_\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":90974,"title":"Henry Brookes","short_name":"HJH Brookes","first_name":"Henry Brookes","last_name":"","middle_name":"","birthdate":"1999-08-21","birthplace":"Solihull, Warwickshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BrookesHenry","instagram_profile":"https:\/\/www.instagram.com\/henry.brookes\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":93130,"title":"Cameron Green","short_name":"C Green","first_name":"Cameron Green","last_name":"","middle_name":"","birthdate":"1999-06-03","birthplace":"Perth, Australia","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/CameronGreen_","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":93517,"title":"Jack Davies","short_name":"JLB Davies","first_name":"Jack Davies","last_name":"","middle_name":"","birthdate":"2000-03-30","birthplace":"Reading, Berkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/daviesjlb","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/lukehollman56\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":95478,"title":"Tom Price","short_name":"TJ Price","first_name":"Tom Price","last_name":"","middle_name":"","birthdate":"2000-01-02","birthplace":"Oxford, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/joe_cracknell\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":101483,"title":"Ajeet Singh Dale","short_name":"Ajeet Singh Dale","first_name":"Ajeet Singh Dale","last_name":"","middle_name":"","birthdate":"2000-07-02","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":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":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/seskinazi","instagram_profile":"https:\/\/www.instagram.com\/seskinazi\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":""},{"pid":107311,"title":"Dominic Goodman","short_name":"DC Goodman","first_name":"Dominic Goodman","last_name":"","middle_name":"","birthdate":"2000-10-23","birthplace":"Ashford, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/domgoodman_\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":107312,"title":"Ollie Price","short_name":"O Price","first_name":"Ollie Price","last_name":"","middle_name":"","birthdate":"2001-06-12","birthplace":"Oxford","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":110606,"title":"Zaman Akhter","short_name":"Z Akhter","first_name":"Zaman Akhter","last_name":"","middle_name":"","birthdate":"1999-03-12","birthplace":"Cambridge","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":116661,"title":"Ishaan Kaushal","short_name":"I Kaushal","first_name":"Ishaan Kaushal","last_name":"","middle_name":"","birthdate":"2002-02-09","birthplace":"Hillingdon, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":116662,"title":"Luke Charlesworth","short_name":"LA Charlesworth","first_name":"Luke Charlesworth","last_name":"","middle_name":"","birthdate":"2003-04-04","birthplace":"Oxford","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":118935,"title":"Tommy Boorman","short_name":"Tommy Boorman","first_name":"Tommy Boorman","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":127440,"title":"Joe Phillips","short_name":"JP Phillips","first_name":"Joe Phillips","last_name":"","middle_name":"","birthdate":"2003-11-09","birthplace":"Truro, Cornwall","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":127503,"title":"Josh De Caires","short_name":"J D caires","first_name":"Josh De Caires","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":129244,"title":"Nathan Fernandes","short_name":"N Fernandes","first_name":"Nathan Fernandes","last_name":"","middle_name":"","birthdate":"2004-04-26","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":130759,"title":"Ahmed Mujtaba Syed","short_name":"A Mujtaba Syed","first_name":"Ahmed Mujtaba Syed","last_name":"","middle_name":"","birthdate":"2004-09-26","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":130760,"title":"Edward Middleton","short_name":"Ed Middleton","first_name":"Edward Middleton","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":133782,"title":"Sebastian Morgan","short_name":"SB Morgan","first_name":"Sebastian Morgan","last_name":"","middle_name":"","birthdate":"2007-08-30","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":139986,"title":"Archie Bailey","short_name":"A Bailey","first_name":"Archie Bailey","last_name":"","middle_name":"","birthdate":"2005-06-28","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":146167,"title":"Aaryan Sawant","short_name":"A Sawant","first_name":"Aaryan Sawant","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":149124,"title":"Aman Rao","short_name":"Aman Rao","first_name":"Aman Rao","last_name":"","middle_name":"","birthdate":"2004-06-22","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""}]},"etag":"78a63f35545cd823e0ad135d3e32f320","modified":"2025-07-15 00:19:33","datetime":"2025-07-15 00:19:33","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86921 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:6459f92a-587f-4182-a50d-72a8d81bae91 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86921 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86921,3,'{"status":"ok","response":{"match_id":86921,"title":"Middlesex vs Gloucestershire","short_title":"MID vs GLO","subtitle":"Match 101","match_number":"101","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Middlesex won by 23 runs","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129425,"title":"Vitality Blast","abbr":"Vitality Blast","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-09-13","country":"en","total_matches":"133","total_rounds":"2","total_teams":"18"},"teama":{"team_id":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":"189\/5 (20 ov)","scores":"189\/5","overs":"20"},"teamb":{"team_id":7017,"name":"Gloucestershire","short_name":"GLO","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-GLO@2x.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-GLO@2x.png","scores_full":"166\/7 (20 ov)","scores":"166\/7","overs":"20"},"date_start":"2025-07-11 16:00:00","date_end":"2025-07-12 02:00:00","timestamp_start":1752249600,"timestamp_end":1752285600,"date_start_ist":"2025-07-11 21:30:00","date_end_ist":"2025-07-12 07:30:00","venue":{"venue_id":"41","name":"Merchant Taylors'' School Ground","location":"Northwood","country":"England","timezone":""},"umpires":"Hassan Adnan (England), Naeem Ashraf (England)","referee":"Simon Hinks (England)","equation":"","live":"","result":"MID won by 23 runs","result_type":1,"win_margin":"23 runs","winning_team_id":7044,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-07-10 00:32:19","verify_time":"2025-07-12 00:41:58","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"","weather_desc":"","temp":"","humidity":"","visibility":"","wind_speed":"","clouds":""},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Middlesex elected to bat","winner":7044,"decision":1}},"etag":"b3673b3a9d30051d48a7ca2da27df8fa","modified":"2025-07-15 00:19:34","datetime":"2025-07-15 00:19:34","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":86921,"title":"Middlesex vs Gloucestershire","short_title":"MID vs GLO","subtitle":"Match 101","match_number":"101","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Middlesex won by 23 runs","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129425,"title":"Vitality Blast","abbr":"Vitality Blast","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-09-13","country":"en","total_matches":"133","total_rounds":"2","total_teams":"18"},"teama":{"team_id":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":"189\/5 (20 ov)","scores":"189\/5","overs":"20"},"teamb":{"team_id":7017,"name":"Gloucestershire","short_name":"GLO","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-GLO@2x.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-GLO@2x.png","scores_full":"166\/7 (20 ov)","scores":"166\/7","overs":"20"},"date_start":"2025-07-11 16:00:00","date_end":"2025-07-12 02:00:00","timestamp_start":1752249600,"timestamp_end":1752285600,"date_start_ist":"2025-07-11 21:30:00","date_end_ist":"2025-07-12 07:30:00","venue":{"venue_id":"41","name":"Merchant Taylors'' School Ground","location":"Northwood","country":"England","timezone":""},"umpires":"Hassan Adnan (England), Naeem Ashraf (England)","referee":"Simon Hinks (England)","equation":"","live":"","result":"MID won by 23 runs","result_type":1,"win_margin":"23 runs","winning_team_id":7044,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-07-10 00:32:19","verify_time":"2025-07-12 00:41:58","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"","weather_desc":"","temp":"","humidity":"","visibility":"","wind_speed":"","clouds":""},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Middlesex elected to bat","winner":7044,"decision":1}},"etag":"b3673b3a9d30051d48a7ca2da27df8fa","modified":"2025-07-15 00:19:34","datetime":"2025-07-15 00:19:34","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86921 AND DataTypeId = 3 END
Live Report & Scorecard of Middlesex vs Gloucestershire Match 101

Hong Kong Women

Kuwait Women

LIVE06 May Match 6

Thailand Women

United Arab Emirates Women

LIVEToday1st Youth Test

England Under-19s439/10 (114.5 ov)

India Under-19s540/10 (112.5 ov) & *128/3 (27 ov)

Stumps : Day 3 - India Under-19s lead by 229 runs.

LIVEToday1st Unofficial Test

Australia A*241/4 (87 ov)

Sri Lanka A272/10 (82 ov)

Stumps : Day 2 - Australia A trail by 31 runs.

Scheduled15 July Match 15

Nabarang Club

City Cricket Club

Scheduled15 July Match 6

SC Krefeld Spartans

Lenkerbeck Marl

Scheduled15 July Match 16

Gauhati Town Club

Bud CC

Scheduled15 July Match 16

Karaikal Kniights

Ruby White Town legends

Scheduled15 July Match 7

SC Krefeld Spartans

Koln CC

Scheduled15 July Match 8

Grey Caps Aachen

Koln CC

Scheduled15 July Match 17

Yanam Royals

Ossudu Accord Warriors

Scheduled15 July Match 9

Lenkerbeck Marl

VFB Gelsenkirchen

Scheduled15 July Match 51

Durham Women

Surrey Women

Scheduled15 July Match 10

VFB Gelsenkirchen

Grey Caps Aachen

Scheduled15 July Match 13

CECC-A

MEC Study Group

Scheduled15 July Match 113

Durham

Leicestershire

Scheduled15 July Match 7

Central Districts

Hobart Hurricanes

Scheduled16 July Match 17

Gauhati Town Club

91 Yard Club

Scheduled16 July Match 11

SC Krefeld Boosters

Dussledorf Blackcaps

Scheduled16 July Match 18

Bud CC

Nabarang Club

Live Cricket Match Centre

Middlesex vs Gloucestershire, Match 101, Vitality Blast

Completed

Vitality Blast, Completed

Middlesex

MID

189/5 (20 ov)

Gloucestershire

GLO

166/7 (20 ov)

Middlesex won by 23 runs

BATTERS	R	B	4S	6S	SR
Josh Shaw *	5	2	1	0	250.00
David Payne	7	5	1	0	140.00

BOWLERS	O	M	R	W	ECON
Ryan Higgins *	4	0	31	1	7.75
Tom Helm	4	0	35	1	8.75

Current Partnership: 5 run (0.3 ov) | Last Wicket: Ben Charlesworth 11 (8) | Fall of Wicket: 161/7 (19.3 ov)

CRR: 8.30

Recent: •14w2211•42w4•111w

Middlesex vs Gloucestershire, Live Cricket Commentary

End of over 20 (9 runs)

David Payne 7 (5)

Josh Shaw 5 (2)

Gloucestershire 166/7

Ryan Higgins 4-0-31-1

Tom Helm 4-0-35-1

19.6

Ryan Higgins to David Payne, no run,

19.5

Ryan Higgins to Josh Shaw, 1 run,

19.4

Ryan Higgins to Josh Shaw, Four,

19.3

Ben Charlesworth lbw b RF Higgins 11 (8) Ryan Higgins to Ben Charlesworth, no run, lbw b RF Higgins,

19.2

Ryan Higgins to Ben Charlesworth, 2 runs,

19.1

Ryan Higgins to Ben Charlesworth, 2 runs,

End of over 19 (8 runs)

Ben Charlesworth 7 (5)

David Payne 7 (4)

Gloucestershire 157/6

Tom Helm 4-0-35-1

Sebastian Morgan 4-0-34-2

18.6

Tom Helm to Ben Charlesworth, 1 run,

18.5

Tom Helm to David Payne, 1 run,

18.4

Tom Helm to David Payne, no run,

18.3

Tom Helm to David Payne, Four,

18.2

Tom Helm to David Payne, 2 runs,

18.1

Graeme van Buuren c JLdu Plooy b TG Helm 2 (3) Tom Helm to Graeme van Buuren, no run, c JLdu Plooy b TG Helm,

End of over 18 (7 runs)

Ben Charlesworth 6 (4)

Graeme van Buuren 2 (2)

Gloucestershire 149/5

Sebastian Morgan 4-0-34-2

Noah Cornwell 4-0-20-1

17.6

Sebastian Morgan to Ben Charlesworth, Four,

17.5

Sebastian Morgan to Ben Charlesworth, no run,

17.4

Sebastian Morgan to Graeme van Buuren, 1 run,

17.3

Sebastian Morgan to Ben Charlesworth, 1 run,

17.2

Sebastian Morgan to Graeme van Buuren, 1 run,

17.1

Jack Taylor c K Williamson b SB Morgan 41 (32) Sebastian Morgan to Jack Taylor, no run, c K Williamson b SB Morgan,

End of over 17 (4 runs)

Jack Taylor 41 (31)

Ben Charlesworth 1 (1)

Gloucestershire 142/4

Noah Cornwell 4-0-20-1

Ryan Higgins 3-0-22-0

16.6

Noah Cornwell to Jack Taylor, 1 run,

16.5

Noah Cornwell to Ben Charlesworth, 1 run,

16.4

D'Arcy Short c JB Cracknell b N Cornwell 64 (46) Noah Cornwell to D'Arcy Short, no run, c JB Cracknell b N Cornwell,

16.3

Noah Cornwell to Jack Taylor, 1 run,

16.2

Noah Cornwell to Jack Taylor, no run,

16.1

Noah Cornwell to D'Arcy Short, 1 run,

End of over 16 (6 runs)

D'Arcy Short 63 (44)

Jack Taylor 39 (28)

Gloucestershire 138/3

Ryan Higgins 3-0-22-0

Sebastian Morgan 3-0-27-1

15.6

Ryan Higgins to D'Arcy Short, 1 run,

15.5

Ryan Higgins to Jack Taylor, 1 run,

Date

Friday, July 11, 2025 17:00

Venue

Merchant Taylors' School Ground, Northwood

Toss

Middlesex elected to bat

Umpires

Match Referee

Simon Hinks (England)

× Close