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:56d28ff0-6deb-487a-acad-a0dcd3379ea6 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86907 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86907,1,'{"status":"ok","response":{"mid":86907,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Durham won by 8 runs","day_remaining_over":"","team_batting":"Warwickshire","team_bowling":"Durham","live_inning_number":2,"live_score":{"runs":174,"overs":20,"wickets":8,"target":183,"runrate":8.7,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Jake Lintott","batsman_id":102808,"runs":15,"balls_faced":5,"fours":2,"sixes":1,"strike_rate":"300.00"},{"name":"Danny Briggs","batsman_id":49480,"runs":0,"balls_faced":1,"fours":0,"sixes":0,"strike_rate":"0.00"}],"bowlers":[{"name":"Matthew Potts","bowler_id":90886,"overs":4,"runs_conceded":37,"wickets":2,"maidens":0,"econ":"9.25"},{"name":"Jimmy Neesham","bowler_id":31430,"overs":4,"runs_conceded":30,"wickets":2,"maidens":0,"econ":"7.50"}],"commentaries":[{"event_id":"12297179","event":"ball","batsman_id":"44099","bowler_id":"95550","over":"15","ball":"6","score":4,"commentary":"Kasey Aldridge to Hasan Ali, Four,","noball_dismissal":false,"text":"","timestamp":1751822065,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event":"overend","over":16,"runs":16,"score":"127\/6","bats":[{"runs":17,"balls_faced":9,"fours":1,"sixes":1,"batsman_id":44099},{"runs":25,"balls_faced":18,"fours":2,"sixes":0,"batsman_id":49041}],"bowls":[{"runs_conceded":26,"maidens":0,"wickets":1,"bowler_id":95550,"overs":3},{"runs_conceded":30,"maidens":0,"wickets":0,"bowler_id":49916,"overs":3}],"commentary":"End of over 16 (16 runs), Warwickshire 127\/6"},{"event_id":"12297202","event":"ball","batsman_id":"49041","bowler_id":"31430","over":"16","ball":"1","score":4,"commentary":"Jimmy Neesham to Ed Barnard, Four,","noball_dismissal":false,"text":"","timestamp":1751822154,"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":"12297207","event":"ball","batsman_id":"49041","bowler_id":"31430","over":"16","ball":"2","score":4,"commentary":"Jimmy Neesham to Ed Barnard, Four,","noball_dismissal":false,"text":"","timestamp":1751822189,"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":"12297222","event":"ball","batsman_id":"49041","bowler_id":"31430","over":"16","ball":"3","score":"2b","commentary":"Jimmy Neesham to Ed Barnard, 2 bye,","noball_dismissal":false,"text":"","timestamp":1751822260,"run":2,"noball_run":"0","wide_run":"0","bye_run":"2","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12297224","event":"ball","batsman_id":"49041","bowler_id":"31430","over":"16","ball":"4","score":0,"commentary":"Jimmy Neesham to Ed Barnard, no run,","noball_dismissal":false,"text":"","timestamp":1751822262,"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":"12297227","event":"ball","batsman_id":"49041","bowler_id":"31430","over":"16","ball":"5","score":2,"commentary":"Jimmy Neesham to Ed Barnard, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751822290,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12297234","event":"ball","batsman_id":"49041","bowler_id":"31430","over":"16","ball":"6","score":1,"commentary":"Jimmy Neesham to Ed Barnard, 1 run,","noball_dismissal":false,"text":"","timestamp":1751822358,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":17,"runs":13,"score":"140\/6","bats":[{"runs":36,"balls_faced":24,"fours":4,"sixes":0,"batsman_id":49041},{"runs":17,"balls_faced":9,"fours":1,"sixes":1,"batsman_id":44099}],"bowls":[{"runs_conceded":23,"maidens":0,"wickets":1,"bowler_id":31430,"overs":3},{"runs_conceded":26,"maidens":0,"wickets":1,"bowler_id":95550,"overs":3}],"commentary":"End of over 17 (13 runs), Warwickshire 140\/6"},{"event_id":"12297238","event":"ball","batsman_id":"49041","bowler_id":"90886","over":"17","ball":"1","score":2,"commentary":"Matthew Potts to Ed Barnard, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751822432,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12297239","event":"ball","batsman_id":"49041","bowler_id":"90886","over":"17","ball":"2","score":0,"commentary":"Matthew Potts to Ed Barnard, no run,","noball_dismissal":false,"text":"","timestamp":1751822435,"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":"12297241","event":"ball","batsman_id":"49041","bowler_id":"90886","over":"17","ball":"3","score":0,"commentary":"Matthew Potts to Ed Barnard, no run,","noball_dismissal":false,"text":"","timestamp":1751822440,"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":"12297264","event":"ball","batsman_id":"49041","bowler_id":"90886","over":"17","ball":"4","score":4,"commentary":"Matthew Potts to Ed Barnard, Four,","noball_dismissal":false,"text":"","timestamp":1751822506,"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":"12297272","event":"ball","batsman_id":"49041","bowler_id":"90886","over":"17","ball":"5","score":6,"commentary":"Matthew Potts to Ed Barnard, Six,","noball_dismissal":false,"text":"","timestamp":1751822539,"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":"12297279","event":"ball","batsman_id":"49041","bowler_id":"90886","over":"17","ball":"6","score":0,"commentary":"Matthew Potts to Ed Barnard, no run,","noball_dismissal":false,"text":"","timestamp":1751822559,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":18,"runs":12,"score":"152\/6","bats":[{"runs":48,"balls_faced":30,"fours":5,"sixes":1,"batsman_id":49041},{"runs":17,"balls_faced":9,"fours":1,"sixes":1,"batsman_id":44099}],"bowls":[{"runs_conceded":22,"maidens":0,"wickets":1,"bowler_id":90886,"overs":3},{"runs_conceded":23,"maidens":0,"wickets":1,"bowler_id":31430,"overs":3}],"commentary":"End of over 18 (12 runs), Warwickshire 152\/6"},{"event_id":"12297298","event":"ball","batsman_id":"44099","bowler_id":"31430","over":"18","ball":"1","score":1,"commentary":"Jimmy Neesham to Hasan Ali, 1 run,","noball_dismissal":false,"text":"","timestamp":1751822670,"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":"12297308","event":"ball","batsman_id":"49041","bowler_id":"31430","over":"18","ball":"2","score":"1wd","commentary":"Jimmy Neesham to Ed Barnard, 1 wide,","noball_dismissal":false,"text":"","timestamp":1751822714,"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":"12297311","event":"ball","batsman_id":"49041","bowler_id":"31430","over":"18","ball":"2","score":1,"commentary":"Jimmy Neesham to Ed Barnard, 1 run,","noball_dismissal":false,"text":"","timestamp":1751822737,"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":"12297319","event":"ball","batsman_id":"44099","bowler_id":"31430","over":"18","ball":"3","score":0,"commentary":"Jimmy Neesham to Hasan Ali, no run,","noball_dismissal":false,"text":"","timestamp":1751822791,"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":"12297325","event":"ball","batsman_id":"44099","bowler_id":"31430","over":"18","ball":"4","score":4,"commentary":"Jimmy Neesham to Hasan Ali, Four,","noball_dismissal":false,"text":"","timestamp":1751822862,"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":"12297331","event":"wicket","batsman_id":"44099","bowler_id":"31430","over":"18","ball":"5","score":"w","commentary":"Jimmy Neesham to Hasan Ali, no run, c A Lees b J Neesham,","noball_dismissal":false,"text":"","timestamp":1751822955,"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":"44099","how_out":"c A Lees b J Neesham","batsman_runs":"22","batsman_balls":"13"},{"event_id":"12297349","event":"ball","batsman_id":"49480","bowler_id":"31430","over":"18","ball":"6","score":0,"commentary":"Jimmy Neesham to Danny Briggs, no run,","noball_dismissal":false,"text":"","timestamp":1751822990,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":19,"runs":7,"score":"159\/7","bats":[{"runs":0,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":49480},{"runs":49,"balls_faced":31,"fours":5,"sixes":1,"batsman_id":49041}],"bowls":[{"runs_conceded":30,"maidens":0,"wickets":2,"bowler_id":31430,"overs":4},{"runs_conceded":22,"maidens":0,"wickets":1,"bowler_id":90886,"overs":3}],"commentary":"End of over 19 (7 runs), Warwickshire 159\/7"},{"event_id":"12297356","event":"wicket","batsman_id":"49041","bowler_id":"90886","over":"19","ball":"1","score":"w","commentary":"Matthew Potts to Ed Barnard, no run, c Z Foulkes b MJ Potts,","noball_dismissal":false,"text":"","timestamp":1751823083,"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":"49041","how_out":"c Z Foulkes b MJ Potts","batsman_runs":"49","batsman_balls":"32"},{"event_id":"12297360","event":"ball","batsman_id":"102808","bowler_id":"90886","over":"19","ball":"2","score":0,"commentary":"Matthew Potts to Jake Lintott, no run,","noball_dismissal":false,"text":"","timestamp":1751823142,"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":"12297361","event":"ball","batsman_id":"102808","bowler_id":"90886","over":"19","ball":"3","score":6,"commentary":"Matthew Potts to Jake Lintott, Six,","noball_dismissal":false,"text":"","timestamp":1751823156,"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":"12297366","event":"ball","batsman_id":"102808","bowler_id":"90886","over":"19","ball":"4","score":4,"commentary":"Matthew Potts to Jake Lintott, Four,","noball_dismissal":false,"text":"","timestamp":1751823164,"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":"12297372","event":"ball","batsman_id":"102808","bowler_id":"90886","over":"19","ball":"5","score":4,"commentary":"Matthew Potts to Jake Lintott, Four,","noball_dismissal":false,"text":"","timestamp":1751823203,"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":"12297381","event":"ball","batsman_id":"102808","bowler_id":"90886","over":"19","ball":"6","score":1,"commentary":"Matthew Potts to Jake Lintott, 1 run,","noball_dismissal":false,"text":"","timestamp":1751823260,"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":20,"runs":15,"score":"174\/8","bats":[{"runs":15,"balls_faced":5,"fours":2,"sixes":1,"batsman_id":102808},{"runs":0,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":49480}],"bowls":[{"runs_conceded":37,"maidens":0,"wickets":2,"bowler_id":90886,"overs":4},{"runs_conceded":30,"maidens":0,"wickets":2,"bowler_id":31430,"overs":4}],"commentary":"End of over 20 (15 runs), Warwickshire 174\/8"}],"day":"0","session":"0","live_inning":{"iid":199224,"number":2,"name":"Warwickshire Inning","short_name":"WAR Inning","status":2,"issuperover":"false","result":4,"batting_team_id":7002,"fielding_team_id":7548,"scores":"174\/8","scores_full":"174\/8 (20 ov)","fielder":[{"fielder_id":"112844","fielder_name":"Zakary Foulkes","catches":3,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"49916","fielder_name":"Nathan Sowter","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"90886","fielder_name":"Matthew Potts","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"49725","fielder_name":"Graham Clark","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"10612","fielder_name":"Alex Lees","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":"Ed Barnard","batsman_id":"49041","runs":"49","balls":"32","how_out":"c Z Foulkes b MJ Potts","score_at_dismissal":159,"overs_at_dismissal":"19.1","bowler_id":"90886","dismissal":"caught","number":8},"extra_runs":{"byes":2,"legbyes":0,"wides":5,"noballs":0,"penalty":"0","total":7},"equations":{"runs":174,"wickets":8,"overs":"20","bowlers_used":6,"runrate":"8.70"},"current_partnership":{"runs":15,"balls":5,"overs":0.5,"batsmen":[{"name":"Jake Lintott","batsman_id":102808,"runs":15,"balls":5},{"name":"Danny Briggs","batsman_id":49480,"runs":0,"balls":0}]},"did_not_bat":[{"player_id":"49530","name":"Craig Miles"}],"max_over":"20","target":"183","recent_scores":"1,4,4,6,0,w,0,w,4,0,1,1,1,0,6,4,0,0","last_five_overs":"63\/2 11.45","last_ten_overs":"106\/4 9.94"},"teams":[{"tid":7002,"title":"Warwickshire","abbr":"WAR","alt_name":"Warwickshire","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Warwickshire.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Warwickshire.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"174\/8 (20 ov)","scores":"174\/8","overs":"20"},{"tid":7548,"title":"Durham","abbr":"DUR","alt_name":"DUR","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/duraam-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/duraam-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"182\/7 (20 ov)","scores":"182\/7","overs":"20"}],"players":[{"pid":93,"title":"Moeen Ali","short_name":"M Ali","first_name":"Moeen Ali","last_name":"","middle_name":"","birthdate":"1987-06-18","birthplace":"Birmingham","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":8,"facebook_profile":"https:\/\/www.facebook.com\/moeenmunirali\/","twitter_profile":"https:\/\/twitter.com\/MoeenaliAli","instagram_profile":"https:\/\/www.instagram.com\/moeenmunirali\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":107,"title":"Chris Woakes","short_name":"C Woakes","first_name":"Chris Woakes","last_name":"","middle_name":"","birthdate":"1989-03-02","birthplace":"Birmingham, Warwickshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/chriswoakes\/","twitter_profile":"https:\/\/twitter.com\/chriswoakes","instagram_profile":"https:\/\/www.instagram.com\/chriswoakes\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":1384,"title":"George Garton","short_name":"G Garton","first_name":"George Garton","last_name":"","middle_name":"","birthdate":"1997-04-15","birthplace":"Brighton, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/george_garton","instagram_profile":"https:\/\/www.instagram.com\/georgegarton\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":1931,"title":"Ben Stokes","short_name":"B Stokes","first_name":"Ben Stokes","last_name":"","middle_name":"","birthdate":"1991-06-04","birthplace":"Christchurch, Canterbury, New Zealand","country":"en","primary_team":[],"logo_url":"","playing_role":"all","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":"https:\/\/www.facebook.com\/BenStokes38Official","twitter_profile":"https:\/\/twitter.com\/benstokes38","instagram_profile":"https:\/\/www.instagram.com\/stokesy\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":10612,"title":"Alex Lees","short_name":"A Lees","first_name":"Alex Lees","last_name":"","middle_name":"","birthdate":"1993-04-14","birthplace":"Halifax, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/aleesy14\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"pid":10620,"title":"Will Rhodes","short_name":"WMH Rhodes","first_name":"Will Rhodes","last_name":"","middle_name":"","birthdate":"1995-03-02","birthplace":" Nottingham","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":31424,"title":"Scott Borthwick","short_name":"SG Borthwick","first_name":"Scott Borthwick","last_name":"","middle_name":"","birthdate":"1990-04-19","birthplace":"Sunderland, Co Durham","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"https:\/\/www.facebook.com\/borthwick16\/","twitter_profile":"https:\/\/twitter.com\/Borthwick16","instagram_profile":"https:\/\/www.instagram.com\/borthwick16\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":31430,"title":"Jimmy Neesham","short_name":"J Neesham","first_name":"Jimmy Neesham","last_name":"","middle_name":"","birthdate":"1990-09-17","birthplace":"Auckland","country":"nz","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":9,"facebook_profile":"https:\/\/www.facebook.com\/JimmyNeesh\/","twitter_profile":"https:\/\/twitter.com\/JimmyNeesh","instagram_profile":"https:\/\/www.instagram.com\/jimmyneesham\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"all","role_str":""},{"pid":44099,"title":"Hasan Ali","short_name":"H Ali","first_name":"Hasan Ali","last_name":"","middle_name":"","birthdate":"1994-07-02","birthplace":"Gujranwala, Punjab","country":"pk","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":"https:\/\/www.facebook.com\/Realhassan32\/","twitter_profile":"https:\/\/twitter.com\/RealHa55an","instagram_profile":"https:\/\/www.instagram.com\/ha55an_ali\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bowl","role_str":""},{"pid":44185,"title":"Tom Latham","short_name":"T Latham","first_name":"Tom Latham","last_name":"","middle_name":"","birthdate":"1992-04-02","birthplace":"Christchurch, Canterbury","country":"nz","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"wicket keeper","recent_match":23991,"recent_appearance":1513980000,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/tomlathamofficial","twitter_profile":"https:\/\/twitter.com\/Tomlatham2","instagram_profile":"https:\/\/www.instagram.com\/tomlatham2\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"wk","role_str":""},{"pid":46045,"title":"Codi Yusuf","short_name":"CE Yusuf","first_name":"Codi Yusuf","last_name":"","middle_name":"","birthdate":"1998-10-04","birthplace":"Knysna","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/codi_yusuf\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":47592,"title":"David Bedingham","short_name":"DG Bedingham","first_name":"David Bedingham","last_name":"","middle_name":"","birthdate":"1994-04-22","birthplace":"George","country":"za","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Occasional Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/dbedingham0","instagram_profile":"https:\/\/www.instagram.com\/davidbedingham\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":48430,"title":"Alex Davies","short_name":"AL Davies","first_name":"Alex Davies","last_name":"","middle_name":"","birthdate":"1994-08-23","birthplace":"Darwen, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/aldavies23\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK\/C)"},{"pid":49017,"title":"Oliver Hannon-Dalby","short_name":"OJ Hannon-Dalby","first_name":"Oliver Hannon-Dalby","last_name":"","middle_name":"","birthdate":"1989-06-20","birthplace":" Halifax, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49025,"title":"Sam Hain","short_name":"SR Hain","first_name":"Sam Hain","last_name":"","middle_name":"","birthdate":"1995-07-16","birthplace":"Hong Kong","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/SammieHain","instagram_profile":"https:\/\/www.instagram.com\/sammiehain","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":49041,"title":"Ed Barnard","short_name":"EG Barnard","first_name":"Ed Barnard","last_name":"","middle_name":"","birthdate":"1995-11-20","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":49060,"title":"Mark Wood","short_name":"M Wood","first_name":"Mark Wood","last_name":"","middle_name":"","birthdate":"1990-01-11","birthplace":"Ashington, Northumberland","country":"en","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":"https:\/\/www.facebook.com\/MAWood33\/","twitter_profile":"https:\/\/twitter.com\/MAWood33","instagram_profile":"https:\/\/www.instagram.com\/mawood33\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49320,"title":"Chris Rushworth","short_name":"C Rushworth","first_name":"Chris Rushworth","last_name":"","middle_name":"","birthdate":"1986-07-11","birthplace":"Sunderland","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49480,"title":"Danny Briggs","short_name":"DR Briggs","first_name":"Danny Briggs","last_name":"","middle_name":"","birthdate":"1991-04-30","birthplace":" Newport, Isle of Wight","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/DannyBriggs_14","instagram_profile":"https:\/\/www.instagram.com\/dannybriggs14\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":49530,"title":"Craig Miles","short_name":"CN Miles","first_name":"Craig Miles","last_name":"","middle_name":"","birthdate":"1994-07-20","birthplace":"Swindon, Wiltshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/CMiles_18","instagram_profile":"https:\/\/www.instagram.com\/cmiles18\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":49542,"title":"Paul Coughlin","short_name":"P Coughlin","first_name":"Paul Coughlin","last_name":"","middle_name":"","birthdate":"1992-10-23","birthplace":"Sunderland, Co Durham","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":"https:\/\/www.instagram.com\/pauljcoughlin\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49557,"title":"Ben Raine","short_name":"BA Raine","first_name":"Ben Raine","last_name":"","middle_name":"","birthdate":"1991-09-14","birthplace":"Sunderland, Co Durham","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":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BenRaine14","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49725,"title":"Graham Clark","short_name":"G Clark","first_name":"Graham Clark","last_name":"","middle_name":"","birthdate":"1993-03-16","birthplace":"Whitehaven, Cumbria","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/GrahamClark16","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":49751,"title":"Oliver George Robinson","short_name":"OG Robinson","first_name":"Oliver George Robinson","last_name":"","middle_name":"","birthdate":"1998-12-01","birthplace":"Sidcup, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/OllieRobinson7","instagram_profile":"https:\/\/www.instagram.com\/ollie_robbo_\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":49916,"title":"Nathan Sowter","short_name":"NA Sowter","first_name":"Nathan Sowter","last_name":"","middle_name":"","birthdate":"1992-10-12","birthplace":"Penrith, New South Wales","country":"au","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":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/NSowter","instagram_profile":"https:\/\/www.instagram.com\/nathansowter\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Australia","role":"bowl","role_str":""},{"pid":50945,"title":"Richard Gleeson","short_name":"RJ Gleeson","first_name":"Richard Gleeson","last_name":"","middle_name":"","birthdate":"1987-12-02","birthplace":" Blackpool, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/RicGleeson","instagram_profile":"https:\/\/www.instagram.com\/rgleeson33\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51050,"title":"Callum Parkinson","short_name":"CF Parkinson","first_name":"Callum Parkinson","last_name":"","middle_name":"","birthdate":"1996-10-24","birthplace":"Bolton, Lancashire","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":"https:\/\/twitter.com\/cal_parky","instagram_profile":"https:\/\/www.instagram.com\/calparky\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":52963,"title":"Colin Ackermann","short_name":"C Ackermann","first_name":"Colin Ackermann","last_name":"","middle_name":"","birthdate":"1991-04-04","birthplace":"Georgia, south africa","country":"nl","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/ackers48\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"bat","role_str":""},{"pid":53626,"title":"Beau Webster","short_name":"BJ Webster","first_name":"Beau Webster","last_name":"","middle_name":"","birthdate":"1993-12-01","birthplace":"Snug, Hobart, Tasmania","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":55651,"title":"Brydon Carse","short_name":"B Carse","first_name":"Brydon Carse","last_name":"","middle_name":"","birthdate":"1995-07-31","birthplace":"Port Elizabeth, Cape Province","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/CarseBrydon","instagram_profile":"https:\/\/www.instagram.com\/brydon_carse\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":88689,"title":"Zen Malik","short_name":"Z Malik","first_name":"Zen Malik","last_name":"","middle_name":"","birthdate":"1998-04-09","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":90886,"title":"Matthew Potts","short_name":"MJ Potts","first_name":"Matthew Potts","last_name":"","middle_name":"","birthdate":"1998-10-29","birthplace":"Sunderland, Co Durham","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"Bowler","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/matt.potts.395\/","twitter_profile":"https:\/\/twitter.com\/MattyJPotts","instagram_profile":"https:\/\/www.instagram.com\/matthewpotts35\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":90937,"title":"George Drissell","short_name":"GS Drissell","first_name":"George Drissell","last_name":"","middle_name":"","birthdate":"1999-01-20","birthplace":"Bristol","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":93415,"title":"Bas de Leede","short_name":"BD Leede","first_name":"Bas de Leede","last_name":"","middle_name":"","birthdate":"1999-11-15","birthplace":"Nootdorp, Netherlands","country":"nl","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/basdeleede","instagram_profile":"https:\/\/www.instagram.com\/basdeleede\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"squad","role_str":""},{"pid":93516,"title":"Ethan Bamber","short_name":"ER Bamber","first_name":"Ethan Bamber","last_name":"","middle_name":"","birthdate":"1998-12-17","birthplace":"Westminster, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/etbamber","instagram_profile":"https:\/\/www.instagram.com\/etbamber\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":94952,"title":"Kai Smith","short_name":"K Smith","first_name":"Kai Smith","last_name":"","middle_name":"","birthdate":"2004-11-28","birthplace":" Dubai, United Arab Emirates","country":"ae","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right 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":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"squad","role_str":""},{"pid":94982,"title":"Samuel Conners","short_name":"S Conners","first_name":"Samuel Conners","last_name":"","middle_name":"","birthdate":"1999-02-13","birthplace":"Nottingham","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/samconners7","instagram_profile":"https:\/\/www.instagram.com\/samconners_\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95003,"title":"Robert Yates","short_name":"RM Yates","first_name":"Robert Yates","last_name":"","middle_name":"","birthdate":"1999-09-19","birthplace":"Solihull, Warwickshire","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":95543,"title":"Dan Mousley","short_name":"D Mousley","first_name":"Dan Mousley","last_name":"","middle_name":"","birthdate":"2001-07-08","birthplace":"Birmingham, Warwickshire","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":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/danmousley80","instagram_profile":"https:\/\/www.instagram.com\/danmousley80\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":95550,"title":"Kasey Aldridge","short_name":"K Aldridge","first_name":"Kasey Aldridge","last_name":"","middle_name":"","birthdate":"2000-12-24","birthplace":"Bristol","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/kcaldridge5\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":96106,"title":"Emilio Gay","short_name":"E Gay","first_name":"Emilio Gay","last_name":"","middle_name":"","birthdate":"2000-04-14","birthplace":"Bedford","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":102808,"title":"Jake Lintott","short_name":"J Lintott","first_name":"Jake Lintott","last_name":"","middle_name":"","birthdate":"1993-04-22","birthplace":"Taunton, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Wrist Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lintott23","instagram_profile":"https:\/\/www.instagram.com\/lintott23\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":108388,"title":"Jacob Bethell","short_name":"J Bethell","first_name":"Jacob Bethell","last_name":"","middle_name":"","birthdate":"2003-10-23","birthplace":"Barbados","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BethellJacob","instagram_profile":"https:\/\/www.instagram.com\/jacob.bethell\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108389,"title":"Che Simmons","short_name":"C Simmons","first_name":"Che Simmons","last_name":"","middle_name":"","birthdate":"2003-12-18","birthplace":"Birmingham, England","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":109583,"title":"Hamza Shaikh","short_name":"H Shaikh","first_name":"Hamza Shaikh","last_name":"","middle_name":"","birthdate":"2006-05-29","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":110496,"title":"Tazeem Ali","short_name":"T Ali","first_name":"Tazeem Ali","last_name":"","middle_name":"","birthdate":"2006-06-13","birthplace":"","country":"nl","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"squad","role_str":""},{"pid":112844,"title":"Zakary Foulkes","short_name":"Z Foulkes","first_name":"Zakary Foulkes","last_name":"","middle_name":"","birthdate":"2002-06-05","birthplace":"","country":"nz","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bowl","role_str":""},{"pid":118932,"title":"Ben McKinney","short_name":"BS McKinney","first_name":"Ben McKinney","last_name":"","middle_name":"","birthdate":"2004-10-04","birthplace":"Sunderland, Co Durham","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/ben_mckinney9\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":119917,"title":"Adam Sylvester","short_name":"A Sylvester","first_name":"Adam Sylvester","last_name":"","middle_name":"","birthdate":"2000-05-18","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":130478,"title":"Daniel Hogg","short_name":"D Hogg","first_name":"Daniel Hogg","last_name":"","middle_name":"","birthdate":"2004-12-19","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":133776,"title":"Haydon Mustard","short_name":"HM Mustard","first_name":"Haydon Mustard","last_name":"","middle_name":"","birthdate":"2006-07-12","birthplace":"Newcastle upon Tyne, Northumberland","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":141394,"title":"James Minto","short_name":"J Minto","first_name":"James Minto","last_name":"","middle_name":"","birthdate":"2007-11-26","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""}]},"etag":"cd72be0446340f1199311956229e6f98","modified":"2025-07-30 15:36:33","datetime":"2025-07-30 15:36:33","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":86907,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Durham won by 8 runs","day_remaining_over":"","team_batting":"Warwickshire","team_bowling":"Durham","live_inning_number":2,"live_score":{"runs":174,"overs":20,"wickets":8,"target":183,"runrate":8.7,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Jake Lintott","batsman_id":102808,"runs":15,"balls_faced":5,"fours":2,"sixes":1,"strike_rate":"300.00"},{"name":"Danny Briggs","batsman_id":49480,"runs":0,"balls_faced":1,"fours":0,"sixes":0,"strike_rate":"0.00"}],"bowlers":[{"name":"Matthew Potts","bowler_id":90886,"overs":4,"runs_conceded":37,"wickets":2,"maidens":0,"econ":"9.25"},{"name":"Jimmy Neesham","bowler_id":31430,"overs":4,"runs_conceded":30,"wickets":2,"maidens":0,"econ":"7.50"}],"commentaries":[{"event_id":"12297179","event":"ball","batsman_id":"44099","bowler_id":"95550","over":"15","ball":"6","score":4,"commentary":"Kasey Aldridge to Hasan Ali, Four,","noball_dismissal":false,"text":"","timestamp":1751822065,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event":"overend","over":16,"runs":16,"score":"127\/6","bats":[{"runs":17,"balls_faced":9,"fours":1,"sixes":1,"batsman_id":44099},{"runs":25,"balls_faced":18,"fours":2,"sixes":0,"batsman_id":49041}],"bowls":[{"runs_conceded":26,"maidens":0,"wickets":1,"bowler_id":95550,"overs":3},{"runs_conceded":30,"maidens":0,"wickets":0,"bowler_id":49916,"overs":3}],"commentary":"End of over 16 (16 runs), Warwickshire 127\/6"},{"event_id":"12297202","event":"ball","batsman_id":"49041","bowler_id":"31430","over":"16","ball":"1","score":4,"commentary":"Jimmy Neesham to Ed Barnard, Four,","noball_dismissal":false,"text":"","timestamp":1751822154,"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":"12297207","event":"ball","batsman_id":"49041","bowler_id":"31430","over":"16","ball":"2","score":4,"commentary":"Jimmy Neesham to Ed Barnard, Four,","noball_dismissal":false,"text":"","timestamp":1751822189,"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":"12297222","event":"ball","batsman_id":"49041","bowler_id":"31430","over":"16","ball":"3","score":"2b","commentary":"Jimmy Neesham to Ed Barnard, 2 bye,","noball_dismissal":false,"text":"","timestamp":1751822260,"run":2,"noball_run":"0","wide_run":"0","bye_run":"2","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12297224","event":"ball","batsman_id":"49041","bowler_id":"31430","over":"16","ball":"4","score":0,"commentary":"Jimmy Neesham to Ed Barnard, no run,","noball_dismissal":false,"text":"","timestamp":1751822262,"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":"12297227","event":"ball","batsman_id":"49041","bowler_id":"31430","over":"16","ball":"5","score":2,"commentary":"Jimmy Neesham to Ed Barnard, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751822290,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12297234","event":"ball","batsman_id":"49041","bowler_id":"31430","over":"16","ball":"6","score":1,"commentary":"Jimmy Neesham to Ed Barnard, 1 run,","noball_dismissal":false,"text":"","timestamp":1751822358,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":17,"runs":13,"score":"140\/6","bats":[{"runs":36,"balls_faced":24,"fours":4,"sixes":0,"batsman_id":49041},{"runs":17,"balls_faced":9,"fours":1,"sixes":1,"batsman_id":44099}],"bowls":[{"runs_conceded":23,"maidens":0,"wickets":1,"bowler_id":31430,"overs":3},{"runs_conceded":26,"maidens":0,"wickets":1,"bowler_id":95550,"overs":3}],"commentary":"End of over 17 (13 runs), Warwickshire 140\/6"},{"event_id":"12297238","event":"ball","batsman_id":"49041","bowler_id":"90886","over":"17","ball":"1","score":2,"commentary":"Matthew Potts to Ed Barnard, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751822432,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12297239","event":"ball","batsman_id":"49041","bowler_id":"90886","over":"17","ball":"2","score":0,"commentary":"Matthew Potts to Ed Barnard, no run,","noball_dismissal":false,"text":"","timestamp":1751822435,"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":"12297241","event":"ball","batsman_id":"49041","bowler_id":"90886","over":"17","ball":"3","score":0,"commentary":"Matthew Potts to Ed Barnard, no run,","noball_dismissal":false,"text":"","timestamp":1751822440,"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":"12297264","event":"ball","batsman_id":"49041","bowler_id":"90886","over":"17","ball":"4","score":4,"commentary":"Matthew Potts to Ed Barnard, Four,","noball_dismissal":false,"text":"","timestamp":1751822506,"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":"12297272","event":"ball","batsman_id":"49041","bowler_id":"90886","over":"17","ball":"5","score":6,"commentary":"Matthew Potts to Ed Barnard, Six,","noball_dismissal":false,"text":"","timestamp":1751822539,"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":"12297279","event":"ball","batsman_id":"49041","bowler_id":"90886","over":"17","ball":"6","score":0,"commentary":"Matthew Potts to Ed Barnard, no run,","noball_dismissal":false,"text":"","timestamp":1751822559,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":18,"runs":12,"score":"152\/6","bats":[{"runs":48,"balls_faced":30,"fours":5,"sixes":1,"batsman_id":49041},{"runs":17,"balls_faced":9,"fours":1,"sixes":1,"batsman_id":44099}],"bowls":[{"runs_conceded":22,"maidens":0,"wickets":1,"bowler_id":90886,"overs":3},{"runs_conceded":23,"maidens":0,"wickets":1,"bowler_id":31430,"overs":3}],"commentary":"End of over 18 (12 runs), Warwickshire 152\/6"},{"event_id":"12297298","event":"ball","batsman_id":"44099","bowler_id":"31430","over":"18","ball":"1","score":1,"commentary":"Jimmy Neesham to Hasan Ali, 1 run,","noball_dismissal":false,"text":"","timestamp":1751822670,"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":"12297308","event":"ball","batsman_id":"49041","bowler_id":"31430","over":"18","ball":"2","score":"1wd","commentary":"Jimmy Neesham to Ed Barnard, 1 wide,","noball_dismissal":false,"text":"","timestamp":1751822714,"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":"12297311","event":"ball","batsman_id":"49041","bowler_id":"31430","over":"18","ball":"2","score":1,"commentary":"Jimmy Neesham to Ed Barnard, 1 run,","noball_dismissal":false,"text":"","timestamp":1751822737,"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":"12297319","event":"ball","batsman_id":"44099","bowler_id":"31430","over":"18","ball":"3","score":0,"commentary":"Jimmy Neesham to Hasan Ali, no run,","noball_dismissal":false,"text":"","timestamp":1751822791,"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":"12297325","event":"ball","batsman_id":"44099","bowler_id":"31430","over":"18","ball":"4","score":4,"commentary":"Jimmy Neesham to Hasan Ali, Four,","noball_dismissal":false,"text":"","timestamp":1751822862,"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":"12297331","event":"wicket","batsman_id":"44099","bowler_id":"31430","over":"18","ball":"5","score":"w","commentary":"Jimmy Neesham to Hasan Ali, no run, c A Lees b J Neesham,","noball_dismissal":false,"text":"","timestamp":1751822955,"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":"44099","how_out":"c A Lees b J Neesham","batsman_runs":"22","batsman_balls":"13"},{"event_id":"12297349","event":"ball","batsman_id":"49480","bowler_id":"31430","over":"18","ball":"6","score":0,"commentary":"Jimmy Neesham to Danny Briggs, no run,","noball_dismissal":false,"text":"","timestamp":1751822990,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":19,"runs":7,"score":"159\/7","bats":[{"runs":0,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":49480},{"runs":49,"balls_faced":31,"fours":5,"sixes":1,"batsman_id":49041}],"bowls":[{"runs_conceded":30,"maidens":0,"wickets":2,"bowler_id":31430,"overs":4},{"runs_conceded":22,"maidens":0,"wickets":1,"bowler_id":90886,"overs":3}],"commentary":"End of over 19 (7 runs), Warwickshire 159\/7"},{"event_id":"12297356","event":"wicket","batsman_id":"49041","bowler_id":"90886","over":"19","ball":"1","score":"w","commentary":"Matthew Potts to Ed Barnard, no run, c Z Foulkes b MJ Potts,","noball_dismissal":false,"text":"","timestamp":1751823083,"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":"49041","how_out":"c Z Foulkes b MJ Potts","batsman_runs":"49","batsman_balls":"32"},{"event_id":"12297360","event":"ball","batsman_id":"102808","bowler_id":"90886","over":"19","ball":"2","score":0,"commentary":"Matthew Potts to Jake Lintott, no run,","noball_dismissal":false,"text":"","timestamp":1751823142,"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":"12297361","event":"ball","batsman_id":"102808","bowler_id":"90886","over":"19","ball":"3","score":6,"commentary":"Matthew Potts to Jake Lintott, Six,","noball_dismissal":false,"text":"","timestamp":1751823156,"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":"12297366","event":"ball","batsman_id":"102808","bowler_id":"90886","over":"19","ball":"4","score":4,"commentary":"Matthew Potts to Jake Lintott, Four,","noball_dismissal":false,"text":"","timestamp":1751823164,"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":"12297372","event":"ball","batsman_id":"102808","bowler_id":"90886","over":"19","ball":"5","score":4,"commentary":"Matthew Potts to Jake Lintott, Four,","noball_dismissal":false,"text":"","timestamp":1751823203,"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":"12297381","event":"ball","batsman_id":"102808","bowler_id":"90886","over":"19","ball":"6","score":1,"commentary":"Matthew Potts to Jake Lintott, 1 run,","noball_dismissal":false,"text":"","timestamp":1751823260,"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":20,"runs":15,"score":"174\/8","bats":[{"runs":15,"balls_faced":5,"fours":2,"sixes":1,"batsman_id":102808},{"runs":0,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":49480}],"bowls":[{"runs_conceded":37,"maidens":0,"wickets":2,"bowler_id":90886,"overs":4},{"runs_conceded":30,"maidens":0,"wickets":2,"bowler_id":31430,"overs":4}],"commentary":"End of over 20 (15 runs), Warwickshire 174\/8"}],"day":"0","session":"0","live_inning":{"iid":199224,"number":2,"name":"Warwickshire Inning","short_name":"WAR Inning","status":2,"issuperover":"false","result":4,"batting_team_id":7002,"fielding_team_id":7548,"scores":"174\/8","scores_full":"174\/8 (20 ov)","fielder":[{"fielder_id":"112844","fielder_name":"Zakary Foulkes","catches":3,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"49916","fielder_name":"Nathan Sowter","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"90886","fielder_name":"Matthew Potts","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"49725","fielder_name":"Graham Clark","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"10612","fielder_name":"Alex Lees","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":"Ed Barnard","batsman_id":"49041","runs":"49","balls":"32","how_out":"c Z Foulkes b MJ Potts","score_at_dismissal":159,"overs_at_dismissal":"19.1","bowler_id":"90886","dismissal":"caught","number":8},"extra_runs":{"byes":2,"legbyes":0,"wides":5,"noballs":0,"penalty":"0","total":7},"equations":{"runs":174,"wickets":8,"overs":"20","bowlers_used":6,"runrate":"8.70"},"current_partnership":{"runs":15,"balls":5,"overs":0.5,"batsmen":[{"name":"Jake Lintott","batsman_id":102808,"runs":15,"balls":5},{"name":"Danny Briggs","batsman_id":49480,"runs":0,"balls":0}]},"did_not_bat":[{"player_id":"49530","name":"Craig Miles"}],"max_over":"20","target":"183","recent_scores":"1,4,4,6,0,w,0,w,4,0,1,1,1,0,6,4,0,0","last_five_overs":"63\/2 11.45","last_ten_overs":"106\/4 9.94"},"teams":[{"tid":7002,"title":"Warwickshire","abbr":"WAR","alt_name":"Warwickshire","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Warwickshire.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Warwickshire.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"174\/8 (20 ov)","scores":"174\/8","overs":"20"},{"tid":7548,"title":"Durham","abbr":"DUR","alt_name":"DUR","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/duraam-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/duraam-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"182\/7 (20 ov)","scores":"182\/7","overs":"20"}],"players":[{"pid":93,"title":"Moeen Ali","short_name":"M Ali","first_name":"Moeen Ali","last_name":"","middle_name":"","birthdate":"1987-06-18","birthplace":"Birmingham","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":8,"facebook_profile":"https:\/\/www.facebook.com\/moeenmunirali\/","twitter_profile":"https:\/\/twitter.com\/MoeenaliAli","instagram_profile":"https:\/\/www.instagram.com\/moeenmunirali\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":107,"title":"Chris Woakes","short_name":"C Woakes","first_name":"Chris Woakes","last_name":"","middle_name":"","birthdate":"1989-03-02","birthplace":"Birmingham, Warwickshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/chriswoakes\/","twitter_profile":"https:\/\/twitter.com\/chriswoakes","instagram_profile":"https:\/\/www.instagram.com\/chriswoakes\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":1384,"title":"George Garton","short_name":"G Garton","first_name":"George Garton","last_name":"","middle_name":"","birthdate":"1997-04-15","birthplace":"Brighton, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/george_garton","instagram_profile":"https:\/\/www.instagram.com\/georgegarton\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":1931,"title":"Ben Stokes","short_name":"B Stokes","first_name":"Ben Stokes","last_name":"","middle_name":"","birthdate":"1991-06-04","birthplace":"Christchurch, Canterbury, New Zealand","country":"en","primary_team":[],"logo_url":"","playing_role":"all","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":"https:\/\/www.facebook.com\/BenStokes38Official","twitter_profile":"https:\/\/twitter.com\/benstokes38","instagram_profile":"https:\/\/www.instagram.com\/stokesy\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":10612,"title":"Alex Lees","short_name":"A Lees","first_name":"Alex Lees","last_name":"","middle_name":"","birthdate":"1993-04-14","birthplace":"Halifax, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/aleesy14\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"pid":10620,"title":"Will Rhodes","short_name":"WMH Rhodes","first_name":"Will Rhodes","last_name":"","middle_name":"","birthdate":"1995-03-02","birthplace":" Nottingham","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":31424,"title":"Scott Borthwick","short_name":"SG Borthwick","first_name":"Scott Borthwick","last_name":"","middle_name":"","birthdate":"1990-04-19","birthplace":"Sunderland, Co Durham","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"https:\/\/www.facebook.com\/borthwick16\/","twitter_profile":"https:\/\/twitter.com\/Borthwick16","instagram_profile":"https:\/\/www.instagram.com\/borthwick16\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":31430,"title":"Jimmy Neesham","short_name":"J Neesham","first_name":"Jimmy Neesham","last_name":"","middle_name":"","birthdate":"1990-09-17","birthplace":"Auckland","country":"nz","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":9,"facebook_profile":"https:\/\/www.facebook.com\/JimmyNeesh\/","twitter_profile":"https:\/\/twitter.com\/JimmyNeesh","instagram_profile":"https:\/\/www.instagram.com\/jimmyneesham\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"all","role_str":""},{"pid":44099,"title":"Hasan Ali","short_name":"H Ali","first_name":"Hasan Ali","last_name":"","middle_name":"","birthdate":"1994-07-02","birthplace":"Gujranwala, Punjab","country":"pk","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":"https:\/\/www.facebook.com\/Realhassan32\/","twitter_profile":"https:\/\/twitter.com\/RealHa55an","instagram_profile":"https:\/\/www.instagram.com\/ha55an_ali\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bowl","role_str":""},{"pid":44185,"title":"Tom Latham","short_name":"T Latham","first_name":"Tom Latham","last_name":"","middle_name":"","birthdate":"1992-04-02","birthplace":"Christchurch, Canterbury","country":"nz","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"wicket keeper","recent_match":23991,"recent_appearance":1513980000,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/tomlathamofficial","twitter_profile":"https:\/\/twitter.com\/Tomlatham2","instagram_profile":"https:\/\/www.instagram.com\/tomlatham2\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"wk","role_str":""},{"pid":46045,"title":"Codi Yusuf","short_name":"CE Yusuf","first_name":"Codi Yusuf","last_name":"","middle_name":"","birthdate":"1998-10-04","birthplace":"Knysna","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/codi_yusuf\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":47592,"title":"David Bedingham","short_name":"DG Bedingham","first_name":"David Bedingham","last_name":"","middle_name":"","birthdate":"1994-04-22","birthplace":"George","country":"za","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Occasional Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/dbedingham0","instagram_profile":"https:\/\/www.instagram.com\/davidbedingham\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":48430,"title":"Alex Davies","short_name":"AL Davies","first_name":"Alex Davies","last_name":"","middle_name":"","birthdate":"1994-08-23","birthplace":"Darwen, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/aldavies23\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK\/C)"},{"pid":49017,"title":"Oliver Hannon-Dalby","short_name":"OJ Hannon-Dalby","first_name":"Oliver Hannon-Dalby","last_name":"","middle_name":"","birthdate":"1989-06-20","birthplace":" Halifax, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49025,"title":"Sam Hain","short_name":"SR Hain","first_name":"Sam Hain","last_name":"","middle_name":"","birthdate":"1995-07-16","birthplace":"Hong Kong","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/SammieHain","instagram_profile":"https:\/\/www.instagram.com\/sammiehain","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":49041,"title":"Ed Barnard","short_name":"EG Barnard","first_name":"Ed Barnard","last_name":"","middle_name":"","birthdate":"1995-11-20","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":49060,"title":"Mark Wood","short_name":"M Wood","first_name":"Mark Wood","last_name":"","middle_name":"","birthdate":"1990-01-11","birthplace":"Ashington, Northumberland","country":"en","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":"https:\/\/www.facebook.com\/MAWood33\/","twitter_profile":"https:\/\/twitter.com\/MAWood33","instagram_profile":"https:\/\/www.instagram.com\/mawood33\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49320,"title":"Chris Rushworth","short_name":"C Rushworth","first_name":"Chris Rushworth","last_name":"","middle_name":"","birthdate":"1986-07-11","birthplace":"Sunderland","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49480,"title":"Danny Briggs","short_name":"DR Briggs","first_name":"Danny Briggs","last_name":"","middle_name":"","birthdate":"1991-04-30","birthplace":" Newport, Isle of Wight","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/DannyBriggs_14","instagram_profile":"https:\/\/www.instagram.com\/dannybriggs14\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":49530,"title":"Craig Miles","short_name":"CN Miles","first_name":"Craig Miles","last_name":"","middle_name":"","birthdate":"1994-07-20","birthplace":"Swindon, Wiltshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/CMiles_18","instagram_profile":"https:\/\/www.instagram.com\/cmiles18\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":49542,"title":"Paul Coughlin","short_name":"P Coughlin","first_name":"Paul Coughlin","last_name":"","middle_name":"","birthdate":"1992-10-23","birthplace":"Sunderland, Co Durham","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":"https:\/\/www.instagram.com\/pauljcoughlin\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49557,"title":"Ben Raine","short_name":"BA Raine","first_name":"Ben Raine","last_name":"","middle_name":"","birthdate":"1991-09-14","birthplace":"Sunderland, Co Durham","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":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BenRaine14","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49725,"title":"Graham Clark","short_name":"G Clark","first_name":"Graham Clark","last_name":"","middle_name":"","birthdate":"1993-03-16","birthplace":"Whitehaven, Cumbria","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/GrahamClark16","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":49751,"title":"Oliver George Robinson","short_name":"OG Robinson","first_name":"Oliver George Robinson","last_name":"","middle_name":"","birthdate":"1998-12-01","birthplace":"Sidcup, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/OllieRobinson7","instagram_profile":"https:\/\/www.instagram.com\/ollie_robbo_\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":49916,"title":"Nathan Sowter","short_name":"NA Sowter","first_name":"Nathan Sowter","last_name":"","middle_name":"","birthdate":"1992-10-12","birthplace":"Penrith, New South Wales","country":"au","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":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/NSowter","instagram_profile":"https:\/\/www.instagram.com\/nathansowter\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Australia","role":"bowl","role_str":""},{"pid":50945,"title":"Richard Gleeson","short_name":"RJ Gleeson","first_name":"Richard Gleeson","last_name":"","middle_name":"","birthdate":"1987-12-02","birthplace":" Blackpool, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/RicGleeson","instagram_profile":"https:\/\/www.instagram.com\/rgleeson33\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51050,"title":"Callum Parkinson","short_name":"CF Parkinson","first_name":"Callum Parkinson","last_name":"","middle_name":"","birthdate":"1996-10-24","birthplace":"Bolton, Lancashire","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":"https:\/\/twitter.com\/cal_parky","instagram_profile":"https:\/\/www.instagram.com\/calparky\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":52963,"title":"Colin Ackermann","short_name":"C Ackermann","first_name":"Colin Ackermann","last_name":"","middle_name":"","birthdate":"1991-04-04","birthplace":"Georgia, south africa","country":"nl","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/ackers48\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"bat","role_str":""},{"pid":53626,"title":"Beau Webster","short_name":"BJ Webster","first_name":"Beau Webster","last_name":"","middle_name":"","birthdate":"1993-12-01","birthplace":"Snug, Hobart, Tasmania","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":55651,"title":"Brydon Carse","short_name":"B Carse","first_name":"Brydon Carse","last_name":"","middle_name":"","birthdate":"1995-07-31","birthplace":"Port Elizabeth, Cape Province","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/CarseBrydon","instagram_profile":"https:\/\/www.instagram.com\/brydon_carse\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":88689,"title":"Zen Malik","short_name":"Z Malik","first_name":"Zen Malik","last_name":"","middle_name":"","birthdate":"1998-04-09","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":90886,"title":"Matthew Potts","short_name":"MJ Potts","first_name":"Matthew Potts","last_name":"","middle_name":"","birthdate":"1998-10-29","birthplace":"Sunderland, Co Durham","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"Bowler","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/matt.potts.395\/","twitter_profile":"https:\/\/twitter.com\/MattyJPotts","instagram_profile":"https:\/\/www.instagram.com\/matthewpotts35\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":90937,"title":"George Drissell","short_name":"GS Drissell","first_name":"George Drissell","last_name":"","middle_name":"","birthdate":"1999-01-20","birthplace":"Bristol","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":93415,"title":"Bas de Leede","short_name":"BD Leede","first_name":"Bas de Leede","last_name":"","middle_name":"","birthdate":"1999-11-15","birthplace":"Nootdorp, Netherlands","country":"nl","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/basdeleede","instagram_profile":"https:\/\/www.instagram.com\/basdeleede\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"squad","role_str":""},{"pid":93516,"title":"Ethan Bamber","short_name":"ER Bamber","first_name":"Ethan Bamber","last_name":"","middle_name":"","birthdate":"1998-12-17","birthplace":"Westminster, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/etbamber","instagram_profile":"https:\/\/www.instagram.com\/etbamber\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":94952,"title":"Kai Smith","short_name":"K Smith","first_name":"Kai Smith","last_name":"","middle_name":"","birthdate":"2004-11-28","birthplace":" Dubai, United Arab Emirates","country":"ae","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right 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":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"squad","role_str":""},{"pid":94982,"title":"Samuel Conners","short_name":"S Conners","first_name":"Samuel Conners","last_name":"","middle_name":"","birthdate":"1999-02-13","birthplace":"Nottingham","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/samconners7","instagram_profile":"https:\/\/www.instagram.com\/samconners_\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95003,"title":"Robert Yates","short_name":"RM Yates","first_name":"Robert Yates","last_name":"","middle_name":"","birthdate":"1999-09-19","birthplace":"Solihull, Warwickshire","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":95543,"title":"Dan Mousley","short_name":"D Mousley","first_name":"Dan Mousley","last_name":"","middle_name":"","birthdate":"2001-07-08","birthplace":"Birmingham, Warwickshire","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":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/danmousley80","instagram_profile":"https:\/\/www.instagram.com\/danmousley80\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":95550,"title":"Kasey Aldridge","short_name":"K Aldridge","first_name":"Kasey Aldridge","last_name":"","middle_name":"","birthdate":"2000-12-24","birthplace":"Bristol","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/kcaldridge5\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":96106,"title":"Emilio Gay","short_name":"E Gay","first_name":"Emilio Gay","last_name":"","middle_name":"","birthdate":"2000-04-14","birthplace":"Bedford","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":102808,"title":"Jake Lintott","short_name":"J Lintott","first_name":"Jake Lintott","last_name":"","middle_name":"","birthdate":"1993-04-22","birthplace":"Taunton, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Wrist Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lintott23","instagram_profile":"https:\/\/www.instagram.com\/lintott23\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":108388,"title":"Jacob Bethell","short_name":"J Bethell","first_name":"Jacob Bethell","last_name":"","middle_name":"","birthdate":"2003-10-23","birthplace":"Barbados","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BethellJacob","instagram_profile":"https:\/\/www.instagram.com\/jacob.bethell\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108389,"title":"Che Simmons","short_name":"C Simmons","first_name":"Che Simmons","last_name":"","middle_name":"","birthdate":"2003-12-18","birthplace":"Birmingham, England","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":109583,"title":"Hamza Shaikh","short_name":"H Shaikh","first_name":"Hamza Shaikh","last_name":"","middle_name":"","birthdate":"2006-05-29","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":110496,"title":"Tazeem Ali","short_name":"T Ali","first_name":"Tazeem Ali","last_name":"","middle_name":"","birthdate":"2006-06-13","birthplace":"","country":"nl","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"squad","role_str":""},{"pid":112844,"title":"Zakary Foulkes","short_name":"Z Foulkes","first_name":"Zakary Foulkes","last_name":"","middle_name":"","birthdate":"2002-06-05","birthplace":"","country":"nz","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bowl","role_str":""},{"pid":118932,"title":"Ben McKinney","short_name":"BS McKinney","first_name":"Ben McKinney","last_name":"","middle_name":"","birthdate":"2004-10-04","birthplace":"Sunderland, Co Durham","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/ben_mckinney9\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":119917,"title":"Adam Sylvester","short_name":"A Sylvester","first_name":"Adam Sylvester","last_name":"","middle_name":"","birthdate":"2000-05-18","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":130478,"title":"Daniel Hogg","short_name":"D Hogg","first_name":"Daniel Hogg","last_name":"","middle_name":"","birthdate":"2004-12-19","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":133776,"title":"Haydon Mustard","short_name":"HM Mustard","first_name":"Haydon Mustard","last_name":"","middle_name":"","birthdate":"2006-07-12","birthplace":"Newcastle upon Tyne, Northumberland","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":141394,"title":"James Minto","short_name":"J Minto","first_name":"James Minto","last_name":"","middle_name":"","birthdate":"2007-11-26","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""}]},"etag":"cd72be0446340f1199311956229e6f98","modified":"2025-07-30 15:36:33","datetime":"2025-07-30 15:36:33","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86907 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:56d28ff0-6deb-487a-acad-a0dcd3379ea6 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86907 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86907,3,'{"status":"ok","response":{"match_id":86907,"title":"Durham vs Warwickshire","short_title":"DUR vs WAR","subtitle":"Match 87","match_number":"87","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Durham won by 8 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":7548,"name":"Durham","short_name":"DUR","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/duraam-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/duraam-logo.png","scores_full":"182\/7 (20 ov)","scores":"182\/7","overs":"20"},"teamb":{"team_id":7002,"name":"Warwickshire","short_name":"WAR","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Warwickshire.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Warwickshire.png","scores_full":"174\/8 (20 ov)","scores":"174\/8","overs":"20"},"date_start":"2025-07-06 13:30:00","date_end":"2025-07-06 23:30:00","timestamp_start":1751808600,"timestamp_end":1751844600,"date_start_ist":"2025-07-06 19:00:00","date_end_ist":"2025-07-07 05:00:00","venue":{"venue_id":"39","name":"Riverside Ground, Chester-le-Street","location":"Chester-le-Street","country":"England","timezone":""},"umpires":"Michael Gough (England), Simon Widdup (England)","referee":"James Whitaker (England)","equation":"","live":"","result":"DUR won by 8 runs","result_type":1,"win_margin":"8 runs","winning_team_id":7548,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-07-05 00:36:50","verify_time":"2025-07-06 23:41:48","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"broken clouds","temp":15.29,"humidity":83,"visibility":10000,"wind_speed":"16.37","clouds":83},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Warwickshire elected to bowl","winner":7002,"decision":2}},"etag":"ff6aaf26f7bd3f4f8f0cda2da48ba46b","modified":"2025-07-30 15:36:34","datetime":"2025-07-30 15:36:34","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":86907,"title":"Durham vs Warwickshire","short_title":"DUR vs WAR","subtitle":"Match 87","match_number":"87","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Durham won by 8 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":7548,"name":"Durham","short_name":"DUR","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/duraam-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/duraam-logo.png","scores_full":"182\/7 (20 ov)","scores":"182\/7","overs":"20"},"teamb":{"team_id":7002,"name":"Warwickshire","short_name":"WAR","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Warwickshire.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Warwickshire.png","scores_full":"174\/8 (20 ov)","scores":"174\/8","overs":"20"},"date_start":"2025-07-06 13:30:00","date_end":"2025-07-06 23:30:00","timestamp_start":1751808600,"timestamp_end":1751844600,"date_start_ist":"2025-07-06 19:00:00","date_end_ist":"2025-07-07 05:00:00","venue":{"venue_id":"39","name":"Riverside Ground, Chester-le-Street","location":"Chester-le-Street","country":"England","timezone":""},"umpires":"Michael Gough (England), Simon Widdup (England)","referee":"James Whitaker (England)","equation":"","live":"","result":"DUR won by 8 runs","result_type":1,"win_margin":"8 runs","winning_team_id":7548,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-07-05 00:36:50","verify_time":"2025-07-06 23:41:48","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"broken clouds","temp":15.29,"humidity":83,"visibility":10000,"wind_speed":"16.37","clouds":83},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Warwickshire elected to bowl","winner":7002,"decision":2}},"etag":"ff6aaf26f7bd3f4f8f0cda2da48ba46b","modified":"2025-07-30 15:36:34","datetime":"2025-07-30 15:36:34","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86907 AND DataTypeId = 3 END
Live Report & Scorecard of Durham vs Warwickshire Match 87
<>
CricDirect Cricket News, Results and Stats
 

Durham vs Warwickshire, Match 87, Vitality Blast

Completed
Vitality Blast, Completed
Durham
DUR
182/7 (20)
Warwickshire
WAR
174/8 (20)
Durham won by 8 runs
Match Details
Date
2025-07-06 13:30:00
Venue
Riverside Ground, Chester-le-Street, Chester-le-Street
Toss
Warwickshire elected to bowl
Umpires
    Tv Umpires
      Match Referee
        × Close