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:15203dc0-abd7-4364-8928-94e0087df0f5 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86533 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86533,1,'{"status":"ok","response":{"mid":86533,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Sussex won by 80 runs","day_remaining_over":"","team_batting":"Gloucestershire","team_bowling":"Sussex","live_inning_number":2,"live_score":{"runs":93,"overs":13.3,"wickets":10,"target":174,"runrate":6.89,"required_runrate":12.46},"commentary":1,"wagon":2,"batsmen":[{"name":"Tom Smith","batsman_id":58686,"runs":2,"balls_faced":4,"fours":0,"sixes":0,"strike_rate":"50.00"},{"name":"James Bracey","batsman_id":50425,"runs":24,"balls_faced":15,"fours":2,"sixes":1,"strike_rate":"160.00"}],"bowlers":[{"name":"Tymal Mills","bowler_id":43366,"overs":2.3,"runs_conceded":13,"wickets":3,"maidens":0,"econ":"5.20"},{"name":"Nathan McAndrew","bowler_id":43634,"overs":2,"runs_conceded":9,"wickets":1,"maidens":0,"econ":"4.50"}],"commentaries":[{"event_id":"12059006","event":"ball","batsman_id":"50425","bowler_id":"101481","over":"9","ball":"2","score":1,"commentary":"Jack Joshua Carson to James Bracey, 1 run,","noball_dismissal":false,"text":"","timestamp":1748798219,"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":"12059012","event":"ball","batsman_id":"16594","bowler_id":"101481","over":"9","ball":"3","score":4,"commentary":"Jack Joshua Carson to Matt Taylor, Four,","noball_dismissal":false,"text":"","timestamp":1748798222,"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":"12059028","event":"ball","batsman_id":"16594","bowler_id":"101481","over":"9","ball":"4","score":1,"commentary":"Jack Joshua Carson to Matt Taylor, 1 run,","noball_dismissal":false,"text":"","timestamp":1748798229,"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":"12059031","event":"ball","batsman_id":"50425","bowler_id":"101481","over":"9","ball":"5","score":6,"commentary":"Jack Joshua Carson to James Bracey, Six,","noball_dismissal":false,"text":"","timestamp":1748798232,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12059040","event":"ball","batsman_id":"50425","bowler_id":"101481","over":"9","ball":"6","score":1,"commentary":"Jack Joshua Carson to James Bracey, 1 run,","noball_dismissal":false,"text":"","timestamp":1748798254,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":10,"runs":13,"score":"72\/6","bats":[{"runs":15,"balls_faced":9,"fours":1,"sixes":1,"batsman_id":50425},{"runs":8,"balls_faced":6,"fours":1,"sixes":0,"batsman_id":16594}],"bowls":[{"runs_conceded":15,"maidens":0,"wickets":2,"bowler_id":101481,"overs":2},{"runs_conceded":8,"maidens":0,"wickets":0,"bowler_id":43634,"overs":1}],"commentary":"End of over 10 (13 runs), Gloucestershire 72\/6"},{"event_id":"12059059","event":"ball","batsman_id":"50425","bowler_id":"102957","over":"10","ball":"1","score":4,"commentary":"James Coles to James Bracey, Four,","noball_dismissal":false,"text":"","timestamp":1748798387,"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":"12059060","event":"ball","batsman_id":"50425","bowler_id":"102957","over":"10","ball":"2","score":1,"commentary":"James Coles to James Bracey, 1 run,","noball_dismissal":false,"text":"","timestamp":1748798390,"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":"12059061","event":"ball","batsman_id":"16594","bowler_id":"102957","over":"10","ball":"3","score":1,"commentary":"James Coles to Matt Taylor, 1 run,","noball_dismissal":false,"text":"","timestamp":1748798393,"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":"12059063","event":"ball","batsman_id":"50425","bowler_id":"102957","over":"10","ball":"4","score":1,"commentary":"James Coles to James Bracey, 1 run,","noball_dismissal":false,"text":"","timestamp":1748798395,"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":"12059073","event":"wicket","batsman_id":"16594","bowler_id":"102957","over":"10","ball":"5","score":"w","commentary":"James Coles to Matt Taylor, no run, st JA Simpson b J Coles,","noball_dismissal":false,"text":"","timestamp":1748798433,"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":"16594","how_out":"st JA Simpson b J Coles","batsman_runs":"9","batsman_balls":"8"},{"event_id":"12059079","event":"ball","batsman_id":"49526","bowler_id":"102957","over":"10","ball":"6","score":6,"commentary":"James Coles to David Payne, Six,","noball_dismissal":false,"text":"","timestamp":1748798460,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event":"overend","over":11,"runs":13,"score":"85\/7","bats":[{"runs":6,"balls_faced":1,"fours":0,"sixes":1,"batsman_id":49526},{"runs":21,"balls_faced":12,"fours":2,"sixes":1,"batsman_id":50425}],"bowls":[{"runs_conceded":26,"maidens":0,"wickets":2,"bowler_id":102957,"overs":2},{"runs_conceded":15,"maidens":0,"wickets":2,"bowler_id":101481,"overs":2}],"commentary":"End of over 11 (13 runs), Gloucestershire 85\/7"},{"event_id":"12059097","event":"ball","batsman_id":"50425","bowler_id":"43366","over":"11","ball":"1","score":1,"commentary":"Tymal Mills to James Bracey, 1 run,","noball_dismissal":false,"text":"","timestamp":1748798544,"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":"12059103","event":"ball","batsman_id":"49526","bowler_id":"43366","over":"11","ball":"2","score":1,"commentary":"Tymal Mills to David Payne, 1 run,","noball_dismissal":false,"text":"","timestamp":1748798547,"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":"12059119","event":"ball","batsman_id":"50425","bowler_id":"43366","over":"11","ball":"3","score":1,"commentary":"Tymal Mills to James Bracey, 1 run,","noball_dismissal":false,"text":"","timestamp":1748798626,"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":"12059120","event":"ball","batsman_id":"49526","bowler_id":"43366","over":"11","ball":"4","score":0,"commentary":"Tymal Mills to David Payne, no run,","noball_dismissal":false,"text":"","timestamp":1748798629,"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":"12059137","event":"wicket","batsman_id":"49526","bowler_id":"43366","over":"11","ball":"5","score":"w","commentary":"Tymal Mills to David Payne, no run, b TS Mills,","noball_dismissal":false,"text":"","timestamp":1748798712,"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":"49526","how_out":"b TS Mills","batsman_runs":"7","batsman_balls":"4"},{"event_id":"12059152","event":"ball","batsman_id":"149124","bowler_id":"43366","over":"11","ball":"6","score":1,"commentary":"Tymal Mills to Aman Rao, 1 run,","noball_dismissal":false,"text":"","timestamp":1748798772,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":12,"runs":4,"score":"89\/8","bats":[{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":149124},{"runs":23,"balls_faced":14,"fours":2,"sixes":1,"batsman_id":50425}],"bowls":[{"runs_conceded":10,"maidens":0,"wickets":2,"bowler_id":43366,"overs":2},{"runs_conceded":26,"maidens":0,"wickets":2,"bowler_id":102957,"overs":2}],"commentary":"End of over 12 (4 runs), Gloucestershire 89\/8"},{"event_id":"12059164","event":"ball","batsman_id":"149124","bowler_id":"43634","over":"12","ball":"1","score":0,"commentary":"Nathan McAndrew to Aman Rao, no run,","noball_dismissal":false,"text":"","timestamp":1748798838,"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":"12059170","event":"ball","batsman_id":"149124","bowler_id":"43634","over":"12","ball":"2","score":0,"commentary":"Nathan McAndrew to Aman Rao, no run,","noball_dismissal":false,"text":"","timestamp":1748798841,"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":"12059177","event":"ball","batsman_id":"149124","bowler_id":"43634","over":"12","ball":"3","score":0,"commentary":"Nathan McAndrew to Aman Rao, no run,","noball_dismissal":false,"text":"","timestamp":1748798872,"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":"12059185","event":"wicket","batsman_id":"149124","bowler_id":"43634","over":"12","ball":"4","score":"w","commentary":"Nathan McAndrew to Aman Rao, no run, c J Coles b NJ McAndrew,","noball_dismissal":false,"text":"","timestamp":1748799001,"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":"149124","how_out":"c J Coles b NJ McAndrew","batsman_runs":"1","batsman_balls":"5"},{"event_id":"12059198","event":"ball","batsman_id":"58686","bowler_id":"43634","over":"12","ball":"5","score":0,"commentary":"Nathan McAndrew to Tom Smith, no run,","noball_dismissal":false,"text":"","timestamp":1748799023,"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":"12059201","event":"ball","batsman_id":"58686","bowler_id":"43634","over":"12","ball":"6","score":1,"commentary":"Nathan McAndrew to Tom Smith, 1 run,","noball_dismissal":false,"text":"","timestamp":1748799036,"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":13,"runs":1,"score":"90\/9","bats":[{"runs":1,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":58686},{"runs":23,"balls_faced":14,"fours":2,"sixes":1,"batsman_id":50425}],"bowls":[{"runs_conceded":9,"maidens":0,"wickets":1,"bowler_id":43634,"overs":2},{"runs_conceded":10,"maidens":0,"wickets":2,"bowler_id":43366,"overs":2}],"commentary":"End of over 13 (1 runs), Gloucestershire 90\/9"},{"event_id":"12059211","event":"ball","batsman_id":"58686","bowler_id":"43366","over":"13","ball":"1","score":1,"commentary":"Tymal Mills to Tom Smith, 1 run,","noball_dismissal":false,"text":"","timestamp":1748799155,"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":"12059219","event":"ball","batsman_id":"50425","bowler_id":"43366","over":"13","ball":"2","score":"1wd","commentary":"Tymal Mills to James Bracey, 1 wide,","noball_dismissal":false,"text":"","timestamp":1748799158,"run":1,"noball_run":"0","wide_run":"1","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12059223","event":"ball","batsman_id":"50425","bowler_id":"43366","over":"13","ball":"2","score":1,"commentary":"Tymal Mills to James Bracey, 1 run,","noball_dismissal":false,"text":"","timestamp":1748799187,"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":"12059242","event":"wicket","batsman_id":"58686","bowler_id":"43366","over":"13","ball":"3","score":"w","commentary":"Tymal Mills to Tom Smith, no run, c NJ McAndrew b TS Mills,","noball_dismissal":false,"text":"","timestamp":1748799315,"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":"58686","how_out":"c NJ McAndrew b TS Mills","batsman_runs":"2","batsman_balls":"4"}],"day":"0","session":"0","live_inning":{"iid":197284,"number":2,"name":"Gloucestershire Inning","short_name":"GLO Inning","status":2,"issuperover":"false","result":1,"batting_team_id":7017,"fielding_team_id":5721,"scores":"93\/10","scores_full":"93\/10 (13.3 ov)","fielder":[{"fielder_id":"102957","fielder_name":"James Coles","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"50846","fielder_name":"Tom Alsop","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"49495","fielder_name":"John Simpson","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":1,"is_substitute":"false"},{"fielder_id":"43634","fielder_name":"Nathan McAndrew","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":"Tom Smith","batsman_id":"58686","runs":"2","balls":"4","how_out":"c NJ McAndrew b TS Mills","score_at_dismissal":93,"overs_at_dismissal":"13.3","bowler_id":"43366","dismissal":"caught","number":10},"extra_runs":{"byes":0,"legbyes":1,"wides":3,"noballs":0,"penalty":"0","total":4},"equations":{"runs":93,"wickets":10,"overs":"13.3","bowlers_used":6,"runrate":"6.89"},"current_partnership":{"runs":4,"balls":5,"overs":0.5,"batsmen":[{"name":"Tom Smith","batsman_id":58686,"runs":2,"balls":4},{"name":"James Bracey","batsman_id":50425,"runs":1,"balls":1}]},"did_not_bat":[],"max_over":"20","target":"174","recent_scores":"w,1,1,1,1,0,w,0,0,0,1,w,0,1,1,1,6,w","last_five_overs":"39\/4 7.55","last_ten_overs":"68\/9 6.48"},"teams":[{"tid":5721,"title":"Sussex","abbr":"SUS","alt_name":"SUS","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/sussex-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/sussex-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"173\/10 (20 ov)","scores":"173\/10","overs":"20"},{"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":"93\/10 (13.3 ov)","scores":"93\/10","overs":"13.3"}],"players":[{"pid":682,"title":"Jaydev Unadkat","short_name":"J Unadkat","first_name":"Jaydev Unadkat","last_name":"","middle_name":"","birthdate":"1991-10-18","birthplace":"Porbandar","country":"in","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":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/JUnadkat","instagram_profile":"https:\/\/www.instagram.com\/jd_unadkat\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","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":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Marchant90","instagram_profile":"https:\/\/www.instagram.com\/marchant.delange\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":43366,"title":"Tymal Mills","short_name":"TS Mills","first_name":"Tymal Mills","last_name":"","middle_name":"","birthdate":"1992-08-12","birthplace":"Dewsbury, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/tmills15\/","twitter_profile":"https:\/\/twitter.com\/tmills15","instagram_profile":"https:\/\/www.instagram.com\/tymalmills\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":"(C)"},{"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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/cbancroft4\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"wk","role_str":""},{"pid":43634,"title":"Nathan McAndrew","short_name":"NJ McAndrew","first_name":"Nathan McAndrew","last_name":"","middle_name":"","birthdate":"1993-07-14","birthplace":"Wollongong, NSW","country":"au","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/nmcandrew44","instagram_profile":"https:\/\/www.instagram.com\/nathan_mcandrew\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/graemegvb\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49495,"title":"John Simpson","short_name":"JA Simpson","first_name":"John Simpson","last_name":"","middle_name":"","birthdate":"1988-07-13","birthplace":"Bury, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/JohnAndrewSimpson\/","twitter_profile":"https:\/\/twitter.com\/JohnSimpson_88","instagram_profile":"https:\/\/www.instagram.com\/johnsimpson_88\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"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":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Cdent15","instagram_profile":"https:\/\/www.instagram.com\/chrisdent15\/","debut_data":"","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":"","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"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":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/milesAHH","instagram_profile":"https:\/\/www.instagram.com\/hammo_gram\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":50623,"title":"Danny Lamb","short_name":"DJ Lamb","first_name":"Danny Lamb","last_name":"","middle_name":"","birthdate":"1995-09-07","birthplace":"Preston, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lamby236","instagram_profile":"https:\/\/www.instagram.com\/dannylamb190\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50846,"title":"Tom Alsop","short_name":"TP Alsop","first_name":"Tom Alsop","last_name":"","middle_name":"","birthdate":"1995-11-26","birthplace":"High Wycombe, Buckinghamshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"Wicketkeeper Batter","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/tomalsop1","instagram_profile":"https:\/\/www.instagram.com\/tom.alsop\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":""},{"pid":51091,"title":"Harrison Ward","short_name":"HD Ward","first_name":"Harrison Ward","last_name":"","middle_name":"","birthdate":"1999-10-25","birthplace":"Oxford","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/delraw09","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":51271,"title":"Tom Haines","short_name":"TJ Haines","first_name":"Tom Haines","last_name":"","middle_name":"","birthdate":"1998-10-28","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51308,"title":"Ollie Robinson","short_name":"OE Robinson","first_name":"Ollie Robinson","last_name":"","middle_name":"","birthdate":"1993-12-01","birthplace":"Margate, 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":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/OllieRobinson7","instagram_profile":"https:\/\/www.instagram.com\/ollierobinson25\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/tmjsmith6\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/shortyjnr23\/","debut_data":"","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":90598,"title":"Daniel Hughes","short_name":"DPHughes","first_name":"Daniel Hughes","last_name":"","middle_name":"","birthdate":"1989-02-16","birthplace":" Cowra","country":"au","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Hughesy1989","instagram_profile":"https:\/\/www.instagram.com\/danielhughes16\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"bat","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 Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/CameronGreen_","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95551,"title":"Tom Clark","short_name":"T Clark","first_name":"Tom Clark","last_name":"","middle_name":"","birthdate":"2001-07-02","birthplace":"Geoffrey Reeves","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/tomclark2702","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":96398,"title":"Jayden Seales","short_name":"J Seales","first_name":"Jayden Seales","last_name":"","middle_name":"","birthdate":"2001-09-10","birthplace":"Trinidad & Tobago","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/jayden_seales","instagram_profile":"https:\/\/www.instagram.com\/jay_seales\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":101481,"title":"Jack Joshua Carson","short_name":"J J Carson","first_name":"Jack Joshua Carson","last_name":"","middle_name":"","birthdate":"2000-12-03","birthplace":"Craigavon, Co Armagh, Ireland","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/_jackcarson11","instagram_profile":"https:\/\/www.instagram.com\/_jackcarson\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":101482,"title":"Henry Thomas Crocombe","short_name":"H T Crocombe","first_name":"Henry Thomas Crocombe","last_name":"","middle_name":"","birthdate":"2001-09-20","birthplace":"Eastbourne, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/henrycrocombe\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":102957,"title":"James Coles","short_name":"J Coles","first_name":"James Coles","last_name":"","middle_name":"","birthdate":"2004-04-04","birthplace":"Aylesbury, Buckinghamshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/domgoodman_\/","debut_data":"","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":107332,"title":"Sean Hunt","short_name":"S Hunt","first_name":"Sean Hunt","last_name":"","middle_name":"","birthdate":"2001-12-07","birthplace":" Guildford, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108396,"title":"Danial Ibrahim","short_name":"D Ibrahim","first_name":"Danial Ibrahim","last_name":"","middle_name":"","birthdate":"2004-08-09","birthplace":"Burnley, Lancashire, England","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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/danialibrahim\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108398,"title":"Oliver Carter","short_name":"O Carter","first_name":"Oliver Carter","last_name":"","middle_name":"","birthdate":"2001-11-02","birthplace":"Eastbourne, Sussex, England","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108400,"title":"Archie Lenham","short_name":"A Lenham","first_name":"Archie Lenham","last_name":"","middle_name":"","birthdate":"2004-07-23","birthplace":"Eastbourne, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":109542,"title":"George Thomas II","short_name":"G Thomas II","first_name":"George Thomas II","last_name":"","middle_name":"","birthdate":"2003-11-14","birthplace":"Taunton, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":114207,"title":"Ari Karvelas","short_name":"A Karvelas","first_name":"Ari Karvelas","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":118322,"title":"Bradley Currie","short_name":"BJ Currie","first_name":"Bradley Currie","last_name":"","middle_name":"","birthdate":"1998-11-08","birthplace":"Poole, United Kingdom","country":"sct","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/currie.bradley\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Scotland","role":"bowl","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":118938,"title":"Bertie Foreman","short_name":"B Foreman","first_name":"Bertie Foreman","last_name":"","middle_name":"","birthdate":"2004-05-13","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":119916,"title":"Charlie Tear","short_name":"C Tear","first_name":"Charlie Tear","last_name":"","middle_name":"","birthdate":"2004-06-12","birthplace":"","country":"sct","primary_team":[],"logo_url":"","playing_role":"wk","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":"","thumb_url":"","profile_image":"","nationality":"Scotland","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":130437,"title":"Henry Rogers","short_name":"H Rogers","first_name":"Henry Rogers","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":147226,"title":"Zach Lion Cachet","short_name":"Z Cachet","first_name":"Zach Lion Cachet","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"nl","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"squad","role_str":""},{"pid":147628,"title":"Troy Henry","short_name":"T Henry","first_name":"Troy Henry","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":149075,"title":"Nantes Oosthuizen","short_name":"N Oosthuizen","first_name":"Nantes Oosthuizen","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":4,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":149076,"title":"Ollie Moore","short_name":"O Moore","first_name":"Ollie Moore","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""}]},"etag":"e8042022a9cc324330497929e3090b25","modified":"2025-08-06 06:25:57","datetime":"2025-08-06 06:25:57","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":86533,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Sussex won by 80 runs","day_remaining_over":"","team_batting":"Gloucestershire","team_bowling":"Sussex","live_inning_number":2,"live_score":{"runs":93,"overs":13.3,"wickets":10,"target":174,"runrate":6.89,"required_runrate":12.46},"commentary":1,"wagon":2,"batsmen":[{"name":"Tom Smith","batsman_id":58686,"runs":2,"balls_faced":4,"fours":0,"sixes":0,"strike_rate":"50.00"},{"name":"James Bracey","batsman_id":50425,"runs":24,"balls_faced":15,"fours":2,"sixes":1,"strike_rate":"160.00"}],"bowlers":[{"name":"Tymal Mills","bowler_id":43366,"overs":2.3,"runs_conceded":13,"wickets":3,"maidens":0,"econ":"5.20"},{"name":"Nathan McAndrew","bowler_id":43634,"overs":2,"runs_conceded":9,"wickets":1,"maidens":0,"econ":"4.50"}],"commentaries":[{"event_id":"12059006","event":"ball","batsman_id":"50425","bowler_id":"101481","over":"9","ball":"2","score":1,"commentary":"Jack Joshua Carson to James Bracey, 1 run,","noball_dismissal":false,"text":"","timestamp":1748798219,"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":"12059012","event":"ball","batsman_id":"16594","bowler_id":"101481","over":"9","ball":"3","score":4,"commentary":"Jack Joshua Carson to Matt Taylor, Four,","noball_dismissal":false,"text":"","timestamp":1748798222,"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":"12059028","event":"ball","batsman_id":"16594","bowler_id":"101481","over":"9","ball":"4","score":1,"commentary":"Jack Joshua Carson to Matt Taylor, 1 run,","noball_dismissal":false,"text":"","timestamp":1748798229,"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":"12059031","event":"ball","batsman_id":"50425","bowler_id":"101481","over":"9","ball":"5","score":6,"commentary":"Jack Joshua Carson to James Bracey, Six,","noball_dismissal":false,"text":"","timestamp":1748798232,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12059040","event":"ball","batsman_id":"50425","bowler_id":"101481","over":"9","ball":"6","score":1,"commentary":"Jack Joshua Carson to James Bracey, 1 run,","noball_dismissal":false,"text":"","timestamp":1748798254,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":10,"runs":13,"score":"72\/6","bats":[{"runs":15,"balls_faced":9,"fours":1,"sixes":1,"batsman_id":50425},{"runs":8,"balls_faced":6,"fours":1,"sixes":0,"batsman_id":16594}],"bowls":[{"runs_conceded":15,"maidens":0,"wickets":2,"bowler_id":101481,"overs":2},{"runs_conceded":8,"maidens":0,"wickets":0,"bowler_id":43634,"overs":1}],"commentary":"End of over 10 (13 runs), Gloucestershire 72\/6"},{"event_id":"12059059","event":"ball","batsman_id":"50425","bowler_id":"102957","over":"10","ball":"1","score":4,"commentary":"James Coles to James Bracey, Four,","noball_dismissal":false,"text":"","timestamp":1748798387,"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":"12059060","event":"ball","batsman_id":"50425","bowler_id":"102957","over":"10","ball":"2","score":1,"commentary":"James Coles to James Bracey, 1 run,","noball_dismissal":false,"text":"","timestamp":1748798390,"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":"12059061","event":"ball","batsman_id":"16594","bowler_id":"102957","over":"10","ball":"3","score":1,"commentary":"James Coles to Matt Taylor, 1 run,","noball_dismissal":false,"text":"","timestamp":1748798393,"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":"12059063","event":"ball","batsman_id":"50425","bowler_id":"102957","over":"10","ball":"4","score":1,"commentary":"James Coles to James Bracey, 1 run,","noball_dismissal":false,"text":"","timestamp":1748798395,"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":"12059073","event":"wicket","batsman_id":"16594","bowler_id":"102957","over":"10","ball":"5","score":"w","commentary":"James Coles to Matt Taylor, no run, st JA Simpson b J Coles,","noball_dismissal":false,"text":"","timestamp":1748798433,"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":"16594","how_out":"st JA Simpson b J Coles","batsman_runs":"9","batsman_balls":"8"},{"event_id":"12059079","event":"ball","batsman_id":"49526","bowler_id":"102957","over":"10","ball":"6","score":6,"commentary":"James Coles to David Payne, Six,","noball_dismissal":false,"text":"","timestamp":1748798460,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event":"overend","over":11,"runs":13,"score":"85\/7","bats":[{"runs":6,"balls_faced":1,"fours":0,"sixes":1,"batsman_id":49526},{"runs":21,"balls_faced":12,"fours":2,"sixes":1,"batsman_id":50425}],"bowls":[{"runs_conceded":26,"maidens":0,"wickets":2,"bowler_id":102957,"overs":2},{"runs_conceded":15,"maidens":0,"wickets":2,"bowler_id":101481,"overs":2}],"commentary":"End of over 11 (13 runs), Gloucestershire 85\/7"},{"event_id":"12059097","event":"ball","batsman_id":"50425","bowler_id":"43366","over":"11","ball":"1","score":1,"commentary":"Tymal Mills to James Bracey, 1 run,","noball_dismissal":false,"text":"","timestamp":1748798544,"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":"12059103","event":"ball","batsman_id":"49526","bowler_id":"43366","over":"11","ball":"2","score":1,"commentary":"Tymal Mills to David Payne, 1 run,","noball_dismissal":false,"text":"","timestamp":1748798547,"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":"12059119","event":"ball","batsman_id":"50425","bowler_id":"43366","over":"11","ball":"3","score":1,"commentary":"Tymal Mills to James Bracey, 1 run,","noball_dismissal":false,"text":"","timestamp":1748798626,"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":"12059120","event":"ball","batsman_id":"49526","bowler_id":"43366","over":"11","ball":"4","score":0,"commentary":"Tymal Mills to David Payne, no run,","noball_dismissal":false,"text":"","timestamp":1748798629,"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":"12059137","event":"wicket","batsman_id":"49526","bowler_id":"43366","over":"11","ball":"5","score":"w","commentary":"Tymal Mills to David Payne, no run, b TS Mills,","noball_dismissal":false,"text":"","timestamp":1748798712,"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":"49526","how_out":"b TS Mills","batsman_runs":"7","batsman_balls":"4"},{"event_id":"12059152","event":"ball","batsman_id":"149124","bowler_id":"43366","over":"11","ball":"6","score":1,"commentary":"Tymal Mills to Aman Rao, 1 run,","noball_dismissal":false,"text":"","timestamp":1748798772,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":12,"runs":4,"score":"89\/8","bats":[{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":149124},{"runs":23,"balls_faced":14,"fours":2,"sixes":1,"batsman_id":50425}],"bowls":[{"runs_conceded":10,"maidens":0,"wickets":2,"bowler_id":43366,"overs":2},{"runs_conceded":26,"maidens":0,"wickets":2,"bowler_id":102957,"overs":2}],"commentary":"End of over 12 (4 runs), Gloucestershire 89\/8"},{"event_id":"12059164","event":"ball","batsman_id":"149124","bowler_id":"43634","over":"12","ball":"1","score":0,"commentary":"Nathan McAndrew to Aman Rao, no run,","noball_dismissal":false,"text":"","timestamp":1748798838,"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":"12059170","event":"ball","batsman_id":"149124","bowler_id":"43634","over":"12","ball":"2","score":0,"commentary":"Nathan McAndrew to Aman Rao, no run,","noball_dismissal":false,"text":"","timestamp":1748798841,"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":"12059177","event":"ball","batsman_id":"149124","bowler_id":"43634","over":"12","ball":"3","score":0,"commentary":"Nathan McAndrew to Aman Rao, no run,","noball_dismissal":false,"text":"","timestamp":1748798872,"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":"12059185","event":"wicket","batsman_id":"149124","bowler_id":"43634","over":"12","ball":"4","score":"w","commentary":"Nathan McAndrew to Aman Rao, no run, c J Coles b NJ McAndrew,","noball_dismissal":false,"text":"","timestamp":1748799001,"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":"149124","how_out":"c J Coles b NJ McAndrew","batsman_runs":"1","batsman_balls":"5"},{"event_id":"12059198","event":"ball","batsman_id":"58686","bowler_id":"43634","over":"12","ball":"5","score":0,"commentary":"Nathan McAndrew to Tom Smith, no run,","noball_dismissal":false,"text":"","timestamp":1748799023,"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":"12059201","event":"ball","batsman_id":"58686","bowler_id":"43634","over":"12","ball":"6","score":1,"commentary":"Nathan McAndrew to Tom Smith, 1 run,","noball_dismissal":false,"text":"","timestamp":1748799036,"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":13,"runs":1,"score":"90\/9","bats":[{"runs":1,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":58686},{"runs":23,"balls_faced":14,"fours":2,"sixes":1,"batsman_id":50425}],"bowls":[{"runs_conceded":9,"maidens":0,"wickets":1,"bowler_id":43634,"overs":2},{"runs_conceded":10,"maidens":0,"wickets":2,"bowler_id":43366,"overs":2}],"commentary":"End of over 13 (1 runs), Gloucestershire 90\/9"},{"event_id":"12059211","event":"ball","batsman_id":"58686","bowler_id":"43366","over":"13","ball":"1","score":1,"commentary":"Tymal Mills to Tom Smith, 1 run,","noball_dismissal":false,"text":"","timestamp":1748799155,"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":"12059219","event":"ball","batsman_id":"50425","bowler_id":"43366","over":"13","ball":"2","score":"1wd","commentary":"Tymal Mills to James Bracey, 1 wide,","noball_dismissal":false,"text":"","timestamp":1748799158,"run":1,"noball_run":"0","wide_run":"1","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12059223","event":"ball","batsman_id":"50425","bowler_id":"43366","over":"13","ball":"2","score":1,"commentary":"Tymal Mills to James Bracey, 1 run,","noball_dismissal":false,"text":"","timestamp":1748799187,"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":"12059242","event":"wicket","batsman_id":"58686","bowler_id":"43366","over":"13","ball":"3","score":"w","commentary":"Tymal Mills to Tom Smith, no run, c NJ McAndrew b TS Mills,","noball_dismissal":false,"text":"","timestamp":1748799315,"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":"58686","how_out":"c NJ McAndrew b TS Mills","batsman_runs":"2","batsman_balls":"4"}],"day":"0","session":"0","live_inning":{"iid":197284,"number":2,"name":"Gloucestershire Inning","short_name":"GLO Inning","status":2,"issuperover":"false","result":1,"batting_team_id":7017,"fielding_team_id":5721,"scores":"93\/10","scores_full":"93\/10 (13.3 ov)","fielder":[{"fielder_id":"102957","fielder_name":"James Coles","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"50846","fielder_name":"Tom Alsop","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"49495","fielder_name":"John Simpson","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":1,"is_substitute":"false"},{"fielder_id":"43634","fielder_name":"Nathan McAndrew","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":"Tom Smith","batsman_id":"58686","runs":"2","balls":"4","how_out":"c NJ McAndrew b TS Mills","score_at_dismissal":93,"overs_at_dismissal":"13.3","bowler_id":"43366","dismissal":"caught","number":10},"extra_runs":{"byes":0,"legbyes":1,"wides":3,"noballs":0,"penalty":"0","total":4},"equations":{"runs":93,"wickets":10,"overs":"13.3","bowlers_used":6,"runrate":"6.89"},"current_partnership":{"runs":4,"balls":5,"overs":0.5,"batsmen":[{"name":"Tom Smith","batsman_id":58686,"runs":2,"balls":4},{"name":"James Bracey","batsman_id":50425,"runs":1,"balls":1}]},"did_not_bat":[],"max_over":"20","target":"174","recent_scores":"w,1,1,1,1,0,w,0,0,0,1,w,0,1,1,1,6,w","last_five_overs":"39\/4 7.55","last_ten_overs":"68\/9 6.48"},"teams":[{"tid":5721,"title":"Sussex","abbr":"SUS","alt_name":"SUS","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/sussex-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/sussex-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"173\/10 (20 ov)","scores":"173\/10","overs":"20"},{"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":"93\/10 (13.3 ov)","scores":"93\/10","overs":"13.3"}],"players":[{"pid":682,"title":"Jaydev Unadkat","short_name":"J Unadkat","first_name":"Jaydev Unadkat","last_name":"","middle_name":"","birthdate":"1991-10-18","birthplace":"Porbandar","country":"in","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":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/JUnadkat","instagram_profile":"https:\/\/www.instagram.com\/jd_unadkat\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","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":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Marchant90","instagram_profile":"https:\/\/www.instagram.com\/marchant.delange\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":43366,"title":"Tymal Mills","short_name":"TS Mills","first_name":"Tymal Mills","last_name":"","middle_name":"","birthdate":"1992-08-12","birthplace":"Dewsbury, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/tmills15\/","twitter_profile":"https:\/\/twitter.com\/tmills15","instagram_profile":"https:\/\/www.instagram.com\/tymalmills\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":"(C)"},{"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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/cbancroft4\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"wk","role_str":""},{"pid":43634,"title":"Nathan McAndrew","short_name":"NJ McAndrew","first_name":"Nathan McAndrew","last_name":"","middle_name":"","birthdate":"1993-07-14","birthplace":"Wollongong, NSW","country":"au","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/nmcandrew44","instagram_profile":"https:\/\/www.instagram.com\/nathan_mcandrew\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/graemegvb\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49495,"title":"John Simpson","short_name":"JA Simpson","first_name":"John Simpson","last_name":"","middle_name":"","birthdate":"1988-07-13","birthplace":"Bury, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/JohnAndrewSimpson\/","twitter_profile":"https:\/\/twitter.com\/JohnSimpson_88","instagram_profile":"https:\/\/www.instagram.com\/johnsimpson_88\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"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":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Cdent15","instagram_profile":"https:\/\/www.instagram.com\/chrisdent15\/","debut_data":"","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":"","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"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":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/milesAHH","instagram_profile":"https:\/\/www.instagram.com\/hammo_gram\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":50623,"title":"Danny Lamb","short_name":"DJ Lamb","first_name":"Danny Lamb","last_name":"","middle_name":"","birthdate":"1995-09-07","birthplace":"Preston, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lamby236","instagram_profile":"https:\/\/www.instagram.com\/dannylamb190\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50846,"title":"Tom Alsop","short_name":"TP Alsop","first_name":"Tom Alsop","last_name":"","middle_name":"","birthdate":"1995-11-26","birthplace":"High Wycombe, Buckinghamshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"Wicketkeeper Batter","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/tomalsop1","instagram_profile":"https:\/\/www.instagram.com\/tom.alsop\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":""},{"pid":51091,"title":"Harrison Ward","short_name":"HD Ward","first_name":"Harrison Ward","last_name":"","middle_name":"","birthdate":"1999-10-25","birthplace":"Oxford","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/delraw09","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":51271,"title":"Tom Haines","short_name":"TJ Haines","first_name":"Tom Haines","last_name":"","middle_name":"","birthdate":"1998-10-28","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51308,"title":"Ollie Robinson","short_name":"OE Robinson","first_name":"Ollie Robinson","last_name":"","middle_name":"","birthdate":"1993-12-01","birthplace":"Margate, 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":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/OllieRobinson7","instagram_profile":"https:\/\/www.instagram.com\/ollierobinson25\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/tmjsmith6\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/shortyjnr23\/","debut_data":"","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":90598,"title":"Daniel Hughes","short_name":"DPHughes","first_name":"Daniel Hughes","last_name":"","middle_name":"","birthdate":"1989-02-16","birthplace":" Cowra","country":"au","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Hughesy1989","instagram_profile":"https:\/\/www.instagram.com\/danielhughes16\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"bat","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 Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/CameronGreen_","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95551,"title":"Tom Clark","short_name":"T Clark","first_name":"Tom Clark","last_name":"","middle_name":"","birthdate":"2001-07-02","birthplace":"Geoffrey Reeves","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/tomclark2702","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":96398,"title":"Jayden Seales","short_name":"J Seales","first_name":"Jayden Seales","last_name":"","middle_name":"","birthdate":"2001-09-10","birthplace":"Trinidad & Tobago","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/jayden_seales","instagram_profile":"https:\/\/www.instagram.com\/jay_seales\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":101481,"title":"Jack Joshua Carson","short_name":"J J Carson","first_name":"Jack Joshua Carson","last_name":"","middle_name":"","birthdate":"2000-12-03","birthplace":"Craigavon, Co Armagh, Ireland","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/_jackcarson11","instagram_profile":"https:\/\/www.instagram.com\/_jackcarson\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":101482,"title":"Henry Thomas Crocombe","short_name":"H T Crocombe","first_name":"Henry Thomas Crocombe","last_name":"","middle_name":"","birthdate":"2001-09-20","birthplace":"Eastbourne, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/henrycrocombe\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":102957,"title":"James Coles","short_name":"J Coles","first_name":"James Coles","last_name":"","middle_name":"","birthdate":"2004-04-04","birthplace":"Aylesbury, Buckinghamshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/domgoodman_\/","debut_data":"","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":107332,"title":"Sean Hunt","short_name":"S Hunt","first_name":"Sean Hunt","last_name":"","middle_name":"","birthdate":"2001-12-07","birthplace":" Guildford, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108396,"title":"Danial Ibrahim","short_name":"D Ibrahim","first_name":"Danial Ibrahim","last_name":"","middle_name":"","birthdate":"2004-08-09","birthplace":"Burnley, Lancashire, England","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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/danialibrahim\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108398,"title":"Oliver Carter","short_name":"O Carter","first_name":"Oliver Carter","last_name":"","middle_name":"","birthdate":"2001-11-02","birthplace":"Eastbourne, Sussex, England","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108400,"title":"Archie Lenham","short_name":"A Lenham","first_name":"Archie Lenham","last_name":"","middle_name":"","birthdate":"2004-07-23","birthplace":"Eastbourne, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":109542,"title":"George Thomas II","short_name":"G Thomas II","first_name":"George Thomas II","last_name":"","middle_name":"","birthdate":"2003-11-14","birthplace":"Taunton, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":114207,"title":"Ari Karvelas","short_name":"A Karvelas","first_name":"Ari Karvelas","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":118322,"title":"Bradley Currie","short_name":"BJ Currie","first_name":"Bradley Currie","last_name":"","middle_name":"","birthdate":"1998-11-08","birthplace":"Poole, United Kingdom","country":"sct","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/currie.bradley\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Scotland","role":"bowl","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":118938,"title":"Bertie Foreman","short_name":"B Foreman","first_name":"Bertie Foreman","last_name":"","middle_name":"","birthdate":"2004-05-13","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":119916,"title":"Charlie Tear","short_name":"C Tear","first_name":"Charlie Tear","last_name":"","middle_name":"","birthdate":"2004-06-12","birthplace":"","country":"sct","primary_team":[],"logo_url":"","playing_role":"wk","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":"","thumb_url":"","profile_image":"","nationality":"Scotland","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":130437,"title":"Henry Rogers","short_name":"H Rogers","first_name":"Henry Rogers","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":147226,"title":"Zach Lion Cachet","short_name":"Z Cachet","first_name":"Zach Lion Cachet","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"nl","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"squad","role_str":""},{"pid":147628,"title":"Troy Henry","short_name":"T Henry","first_name":"Troy Henry","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":149075,"title":"Nantes Oosthuizen","short_name":"N Oosthuizen","first_name":"Nantes Oosthuizen","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":4,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":149076,"title":"Ollie Moore","short_name":"O Moore","first_name":"Ollie Moore","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""}]},"etag":"e8042022a9cc324330497929e3090b25","modified":"2025-08-06 06:25:57","datetime":"2025-08-06 06:25:57","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86533 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:15203dc0-abd7-4364-8928-94e0087df0f5 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86533 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86533,3,'{"status":"ok","response":{"match_id":86533,"title":"Sussex vs Gloucestershire","short_title":"SUS vs GLO","subtitle":"Match 16","match_number":"16","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Sussex won by 80 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":5721,"name":"Sussex","short_name":"SUS","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/sussex-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/sussex-logo.png","scores_full":"173\/10 (20 ov)","scores":"173\/10","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":"93\/10 (13.3 ov)","scores":"93\/10","overs":"13.3"},"date_start":"2025-06-01 15:00:00","date_end":"2025-06-02 01:00:00","timestamp_start":1748790000,"timestamp_end":1748826000,"date_start_ist":"2025-06-01 20:30:00","date_end_ist":"2025-06-02 06:30:00","venue":{"venue_id":"47","name":"County Ground, Hove","location":"Brighton","country":"England","timezone":""},"umpires":"Mike Burns (England), Benjamin John Peverall (England)","referee":"","equation":"","live":"","result":"SUS won by 80 runs","result_type":1,"win_margin":"80 runs","winning_team_id":5721,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-05-31 21:04:26","verify_time":"2025-06-01 23:17:41","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"broken clouds","temp":14.16,"humidity":85,"visibility":10000,"wind_speed":"15.82","clouds":84},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Gloucestershire elected to bowl","winner":7017,"decision":2}},"etag":"31e5ba13adce6833fb7d68084d76bbe4","modified":"2025-08-06 06:25:58","datetime":"2025-08-06 06:25:58","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":86533,"title":"Sussex vs Gloucestershire","short_title":"SUS vs GLO","subtitle":"Match 16","match_number":"16","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Sussex won by 80 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":5721,"name":"Sussex","short_name":"SUS","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/sussex-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/sussex-logo.png","scores_full":"173\/10 (20 ov)","scores":"173\/10","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":"93\/10 (13.3 ov)","scores":"93\/10","overs":"13.3"},"date_start":"2025-06-01 15:00:00","date_end":"2025-06-02 01:00:00","timestamp_start":1748790000,"timestamp_end":1748826000,"date_start_ist":"2025-06-01 20:30:00","date_end_ist":"2025-06-02 06:30:00","venue":{"venue_id":"47","name":"County Ground, Hove","location":"Brighton","country":"England","timezone":""},"umpires":"Mike Burns (England), Benjamin John Peverall (England)","referee":"","equation":"","live":"","result":"SUS won by 80 runs","result_type":1,"win_margin":"80 runs","winning_team_id":5721,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-05-31 21:04:26","verify_time":"2025-06-01 23:17:41","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"broken clouds","temp":14.16,"humidity":85,"visibility":10000,"wind_speed":"15.82","clouds":84},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Gloucestershire elected to bowl","winner":7017,"decision":2}},"etag":"31e5ba13adce6833fb7d68084d76bbe4","modified":"2025-08-06 06:25:58","datetime":"2025-08-06 06:25:58","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86533 AND DataTypeId = 3 END
Live Report & Scorecard of Sussex vs Gloucestershire Match 16
<>
CricDirect Cricket News, Results and Stats
 

Sussex vs Gloucestershire, Match 16, Vitality Blast

Completed
Vitality Blast, Completed
Sussex
SUS
173/10 (20)
Gloucestershire
GLO
93/10 (13.3)
Sussex won by 80 runs
Match Details
Date
2025-06-01 15:00:00
Venue
County Ground, Hove, Brighton
Toss
Gloucestershire elected to bowl
Umpires
    Tv Umpires
      Match Referee
        × Close