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:961d4d3e-72b6-4949-98af-e113d250607e
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86857 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86857,1,'{"status":"ok","response":{"mid":86857,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Durham won by 16 runs","day_remaining_over":"","team_batting":"Derbyshire","team_bowling":"Durham","live_inning_number":2,"live_score":{"runs":152,"overs":19.3,"wickets":10,"target":169,"runrate":7.79,"required_runrate":34},"commentary":1,"wagon":2,"batsmen":[{"name":"Allah Mohammad Ghazanfar","batsman_id":118504,"runs":16,"balls_faced":11,"fours":0,"sixes":2,"strike_rate":"145.45"},{"name":"Pat Brown","batsman_id":84689,"runs":1,"balls_faced":1,"fours":0,"sixes":0,"strike_rate":"100.00"}],"bowlers":[{"name":"Ben Raine","bowler_id":49557,"overs":3.3,"runs_conceded":21,"wickets":3,"maidens":0,"econ":"6.00"},{"name":"Jimmy Neesham","bowler_id":31430,"overs":4,"runs_conceded":23,"wickets":2,"maidens":0,"econ":"5.75"}],"commentaries":[{"event_id":"12121631","event":"ball","batsman_id":"48641","bowler_id":"51050","over":"15","ball":"2","score":1,"commentary":"Callum Parkinson to Wayne Madsen, 1 run,","noball_dismissal":false,"text":"","timestamp":1749671886,"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":"12121632","event":"ball","batsman_id":"50663","bowler_id":"51050","over":"15","ball":"3","score":4,"commentary":"Callum Parkinson to Fynn Hudson-Prentice, Four,","noball_dismissal":false,"text":"","timestamp":1749671890,"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":"12121633","event":"ball","batsman_id":"50663","bowler_id":"51050","over":"15","ball":"4","score":0,"commentary":"Callum Parkinson to Fynn Hudson-Prentice, no run,","noball_dismissal":false,"text":"","timestamp":1749671893,"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":"12121634","event":"ball","batsman_id":"50663","bowler_id":"51050","over":"15","ball":"5","score":1,"commentary":"Callum Parkinson to Fynn Hudson-Prentice, 1 run,","noball_dismissal":false,"text":"","timestamp":1749671896,"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":"12121637","event":"wicket","batsman_id":"48641","bowler_id":"51050","over":"15","ball":"6","score":"w","commentary":"Callum Parkinson to Wayne Madsen, no run, c WMH Rhodes b CF Parkinson,","noball_dismissal":false,"text":"","timestamp":1749671919,"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":"48641","how_out":"c WMH Rhodes b CF Parkinson","batsman_runs":"37","batsman_balls":"31"},{"event":"overend","over":16,"runs":8,"score":"128\/7","bats":[{"runs":37,"balls_faced":31,"fours":3,"sixes":1,"batsman_id":48641},{"runs":18,"balls_faced":7,"fours":4,"sixes":0,"batsman_id":50663}],"bowls":[{"runs_conceded":37,"maidens":0,"wickets":2,"bowler_id":51050,"overs":4},{"runs_conceded":28,"maidens":0,"wickets":1,"bowler_id":112844,"overs":3}],"commentary":"End of over 16 (8 runs), Derbyshire 128\/7"},{"event_id":"12121659","event":"wicket","batsman_id":"50663","bowler_id":"31430","over":"16","ball":"1","score":"w","commentary":"Jimmy Neesham to Fynn Hudson-Prentice, no run, c K Aldridge b J Neesham,","noball_dismissal":false,"text":"","timestamp":1749672166,"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":"50663","how_out":"c K Aldridge b J Neesham","batsman_runs":"18","batsman_balls":"8"},{"event_id":"12121663","event":"ball","batsman_id":"118504","bowler_id":"31430","over":"16","ball":"2","score":1,"commentary":"Jimmy Neesham to Allah Mohammad Ghazanfar, 1 run,","noball_dismissal":false,"text":"","timestamp":1749672210,"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":"12121665","event":"ball","batsman_id":"50433","bowler_id":"31430","over":"16","ball":"3","score":1,"commentary":"Jimmy Neesham to Alex Thomson, 1 run,","noball_dismissal":false,"text":"","timestamp":1749672213,"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":"12121668","event":"ball","batsman_id":"118504","bowler_id":"31430","over":"16","ball":"4","score":"1wd","commentary":"Jimmy Neesham to Allah Mohammad Ghazanfar, 1 wide,","noball_dismissal":false,"text":"","timestamp":1749672215,"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":"12121669","event":"ball","batsman_id":"118504","bowler_id":"31430","over":"16","ball":"4","score":1,"commentary":"Jimmy Neesham to Allah Mohammad Ghazanfar, 1 run,","noball_dismissal":false,"text":"","timestamp":1749672219,"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":"12121670","event":"ball","batsman_id":"50433","bowler_id":"31430","over":"16","ball":"5","score":0,"commentary":"Jimmy Neesham to Alex Thomson, no run,","noball_dismissal":false,"text":"","timestamp":1749672223,"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":"12121693","event":"ball","batsman_id":"50433","bowler_id":"31430","over":"16","ball":"6","score":0,"commentary":"Jimmy Neesham to Alex Thomson, no run,","noball_dismissal":false,"text":"","timestamp":1749672319,"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":17,"runs":4,"score":"132\/8","bats":[{"runs":1,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":50433},{"runs":2,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":118504}],"bowls":[{"runs_conceded":14,"maidens":0,"wickets":2,"bowler_id":31430,"overs":3},{"runs_conceded":37,"maidens":0,"wickets":2,"bowler_id":51050,"overs":4}],"commentary":"End of over 17 (4 runs), Derbyshire 132\/8"},{"event_id":"12121695","event":"ball","batsman_id":"118504","bowler_id":"49557","over":"17","ball":"1","score":0,"commentary":"Ben Raine to Allah Mohammad Ghazanfar, no run,","noball_dismissal":false,"text":"","timestamp":1749672343,"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":"12121704","event":"ball","batsman_id":"118504","bowler_id":"49557","over":"17","ball":"2","score":6,"commentary":"Ben Raine to Allah Mohammad Ghazanfar, Six,","noball_dismissal":false,"text":"","timestamp":1749672392,"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":"12121705","event":"ball","batsman_id":"118504","bowler_id":"49557","over":"17","ball":"3","score":1,"commentary":"Ben Raine to Allah Mohammad Ghazanfar, 1 run,","noball_dismissal":false,"text":"","timestamp":1749672451,"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":"12121707","event":"ball","batsman_id":"50433","bowler_id":"49557","over":"17","ball":"4","score":1,"commentary":"Ben Raine to Alex Thomson, 1 run,","noball_dismissal":false,"text":"","timestamp":1749672455,"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":"12121708","event":"ball","batsman_id":"118504","bowler_id":"49557","over":"17","ball":"5","score":"1lb","commentary":"Ben Raine to Allah Mohammad Ghazanfar, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1749672458,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"1","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12121717","event":"ball","batsman_id":"50433","bowler_id":"49557","over":"17","ball":"6","score":1,"commentary":"Ben Raine to Alex Thomson, 1 run,","noball_dismissal":false,"text":"","timestamp":1749672497,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":18,"runs":10,"score":"142\/8","bats":[{"runs":3,"balls_faced":5,"fours":0,"sixes":0,"batsman_id":50433},{"runs":9,"balls_faced":6,"fours":0,"sixes":1,"batsman_id":118504}],"bowls":[{"runs_conceded":20,"maidens":0,"wickets":1,"bowler_id":49557,"overs":3},{"runs_conceded":14,"maidens":0,"wickets":2,"bowler_id":31430,"overs":3}],"commentary":"End of over 18 (10 runs), Derbyshire 142\/8"},{"event_id":"12121731","event":"ball","batsman_id":"50433","bowler_id":"31430","over":"18","ball":"1","score":1,"commentary":"Jimmy Neesham to Alex Thomson, 1 run,","noball_dismissal":false,"text":"","timestamp":1749672580,"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":"12121732","event":"ball","batsman_id":"118504","bowler_id":"31430","over":"18","ball":"2","score":1,"commentary":"Jimmy Neesham to Allah Mohammad Ghazanfar, 1 run,","noball_dismissal":false,"text":"","timestamp":1749672583,"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":"12121743","event":"ball","batsman_id":"50433","bowler_id":"31430","over":"18","ball":"3","score":1,"commentary":"Jimmy Neesham to Alex Thomson, 1 run,","noball_dismissal":false,"text":"","timestamp":1749672660,"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":"12121747","event":"ball","batsman_id":"118504","bowler_id":"31430","over":"18","ball":"4","score":6,"commentary":"Jimmy Neesham to Allah Mohammad Ghazanfar, Six,","noball_dismissal":false,"text":"","timestamp":1749672730,"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":"12121755","event":"ball","batsman_id":"118504","bowler_id":"31430","over":"18","ball":"5","score":0,"commentary":"Jimmy Neesham to Allah Mohammad Ghazanfar, no run,","noball_dismissal":false,"text":"","timestamp":1749672859,"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":"12121771","event":"ball","batsman_id":"118504","bowler_id":"31430","over":"18","ball":"6","score":0,"commentary":"Jimmy Neesham to Allah Mohammad Ghazanfar, no run,","noball_dismissal":false,"text":"","timestamp":1749672862,"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":9,"score":"151\/8","bats":[{"runs":16,"balls_faced":10,"fours":0,"sixes":2,"batsman_id":118504},{"runs":5,"balls_faced":7,"fours":0,"sixes":0,"batsman_id":50433}],"bowls":[{"runs_conceded":23,"maidens":0,"wickets":2,"bowler_id":31430,"overs":4},{"runs_conceded":20,"maidens":0,"wickets":1,"bowler_id":49557,"overs":3}],"commentary":"End of over 19 (9 runs), Derbyshire 151\/8"},{"event_id":"12121776","event":"wicket","batsman_id":"50433","bowler_id":"49557","over":"19","ball":"1","score":"w","commentary":"Ben Raine to Alex Thomson, no run, b BA Raine,","noball_dismissal":false,"text":"","timestamp":1749672866,"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":"50433","how_out":"b BA Raine","batsman_runs":"5","batsman_balls":"8"},{"event_id":"12121784","event":"ball","batsman_id":"84689","bowler_id":"49557","over":"19","ball":"2","score":1,"commentary":"Ben Raine to Pat Brown, 1 run,","noball_dismissal":false,"text":"","timestamp":1749672943,"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":"12121791","event":"wicket","batsman_id":"118504","bowler_id":"49557","over":"19","ball":"3","score":"w","commentary":"Ben Raine to Allah Mohammad Ghazanfar, no run, lbw b BA Raine,","noball_dismissal":false,"text":"","timestamp":1749672970,"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":"118504","how_out":"lbw b BA Raine","batsman_runs":"16","batsman_balls":"11"}],"day":"0","session":"0","live_inning":{"iid":197857,"number":2,"name":"Derbyshire Inning","short_name":"DER Inning","status":2,"issuperover":"false","result":1,"batting_team_id":104949,"fielding_team_id":7548,"scores":"152\/10","scores_full":"152\/10 (19.3 ov)","fielder":[{"fielder_id":"95550","fielder_name":"Kasey Aldridge","catches":3,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"10620","fielder_name":"Will Rhodes","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":"2","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"2","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"2","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"2","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Allah Mohammad Ghazanfar","batsman_id":"118504","runs":"16","balls":"11","how_out":"lbw b BA Raine","score_at_dismissal":152,"overs_at_dismissal":"19.3","bowler_id":"49557","dismissal":"lbw","number":10},"extra_runs":{"byes":0,"legbyes":2,"wides":4,"noballs":0,"penalty":"0","total":6},"equations":{"runs":152,"wickets":10,"overs":"19.3","bowlers_used":6,"runrate":"7.79"},"current_partnership":{"runs":1,"balls":2,"overs":0.2,"batsmen":[{"name":"Pat Brown","batsman_id":84689,"runs":1,"balls":1},{"name":"Allah Mohammad Ghazanfar","batsman_id":118504,"runs":0,"balls":1}]},"did_not_bat":[],"max_over":"20","target":"169","recent_scores":"w,1,w,0,0,6,1,1,1,1,1,1,1,6,0,0,0,1","last_five_overs":"44\/4 8.52","last_ten_overs":"83\/6 8.03"},"teams":[{"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":"168\/6 (20 ov)","scores":"168\/6","overs":"20"},{"tid":104949,"title":"Derbyshire","abbr":"DER","alt_name":"DER","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/derbyshire-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/derbyshire-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"152\/10 (19.3 ov)","scores":"152\/10","overs":"19.3"}],"players":[{"pid":1259,"title":"Aneurin Donald","short_name":"A Donald","first_name":"Aneurin Donald","last_name":"","middle_name":"","birthdate":"1996-12-20","birthplace":"Swansea, Glamorgan","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/aneurin.donald\/","twitter_profile":"https:\/\/twitter.com\/AneurinDonald12","instagram_profile":"https:\/\/www.instagram.com\/aneurindonald\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","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":9,"facebook_profile":"https:\/\/www.facebook.com\/BenStokes38Official","twitter_profile":"https:\/\/twitter.com\/benstokes38","instagram_profile":"https:\/\/www.instagram.com\/stokesy\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":7735,"title":"David Lloyd","short_name":"DL Lloyd","first_name":"David Lloyd","last_name":"","middle_name":"","birthdate":"1992-06-15","birthplace":"St Asaph, Flintshire, Wales","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/davidlloyduk\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":10594,"title":"Samit Patel","short_name":"SR Patel","first_name":"Samit Patel","last_name":"","middle_name":"","birthdate":"1984-11-30","birthplace":"Leicester","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/samitpatel","instagram_profile":"https:\/\/www.instagram.com\/samit._.patel\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":"(C)"},{"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":"","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":"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":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","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":7.5,"facebook_profile":"https:\/\/www.facebook.com\/borthwick16\/","twitter_profile":"https:\/\/twitter.com\/Borthwick16","instagram_profile":"https:\/\/www.instagram.com\/borthwick16\/","debut_data":"","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":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"all","role_str":""},{"pid":43360,"title":"Ross Whiteley","short_name":"RA Whiteley","first_name":"Ross Whiteley","last_name":"","middle_name":"","birthdate":"1988-09-13","birthplace":"Sheffield, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/RossWhiteley44","instagram_profile":"https:\/\/www.instagram.com\/rosswhiteley44\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/codi_yusuf\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":46310,"title":"Blair Tickner","short_name":"BM Tickner","first_name":"Blair Tickner","last_name":"","middle_name":"","birthdate":"1993-10-13","birthplace":"Napier, Hawke''s Bay","country":"nz","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\/blair.tickner\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/ticks93\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","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":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/dbedingham0","instagram_profile":"https:\/\/www.instagram.com\/davidbedingham\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":48428,"title":"Luis Reece","short_name":"LM Reece","first_name":"Luis Reece","last_name":"","middle_name":"","birthdate":"1990-08-04","birthplace":"Taunton, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lreece17","instagram_profile":"https:\/\/www.instagram.com\/louisreece\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":48498,"title":"Caleb Jewell","short_name":"CP Jewell","first_name":"Caleb Jewell","last_name":"","middle_name":"","birthdate":"1997-04-21","birthplace":"Hobart, Tasmania","country":"au","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/caleb.jewell.148\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/cjewell_32\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"bat","role_str":""},{"pid":48508,"title":"Brooke Guest","short_name":"BD Guest","first_name":"Brooke Guest","last_name":"","middle_name":"","birthdate":"1997-05-14","birthplace":"Whitworth Park, Manchester, England","country":"au","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\/guesty211\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"wk","role_str":"(WK)"},{"pid":48641,"title":"Wayne Madsen","short_name":"WL Madsen","first_name":"Wayne Madsen","last_name":"","middle_name":"","birthdate":"1984-01-02","birthplace":"Durban","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\/waynemadders77","instagram_profile":"https:\/\/www.instagram.com\/waynemadsen77\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","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":9,"facebook_profile":"https:\/\/www.facebook.com\/MAWood33\/","twitter_profile":"https:\/\/twitter.com\/MAWood33","instagram_profile":"https:\/\/www.instagram.com\/mawood33\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/pauljcoughlin\/","debut_data":"","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,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BenRaine14","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","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":"","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,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/OllieRobinson7","instagram_profile":"https:\/\/www.instagram.com\/ollie_robbo_\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":49808,"title":"Zak Chappell","short_name":"ZJ Chappell","first_name":"Zak Chappell","last_name":"","middle_name":"","birthdate":"1996-08-21","birthplace":"Grantham, Lincolnshire","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/chappooo","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"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":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/NSowter","instagram_profile":"https:\/\/www.instagram.com\/nathansowter\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"bowl","role_str":""},{"pid":50433,"title":"Alex Thomson","short_name":"AT Thomson","first_name":"Alex Thomson","last_name":"","middle_name":"","birthdate":"1993-10-30","birthplace":"Stoke-on-Trent, Staffordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/alextomo","instagram_profile":"https:\/\/www.instagram.com\/alex_thomson_racing\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":50528,"title":"Anuj Dal","short_name":"AK Dal","first_name":"Anuj Dal","last_name":"","middle_name":"","birthdate":"1996-07-08","birthplace":"Newcastle-under-Lyme, Staffordshire","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":"https:\/\/twitter.com\/AnujDal","instagram_profile":"https:\/\/www.instagram.com\/anujdal0\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50663,"title":"Fynn Hudson-Prentice","short_name":"FJ Hudson-Prentice","first_name":"Fynn Hudson-Prentice","last_name":"","middle_name":"","birthdate":"1996-01-12","birthplace":"Haywards Heath, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/fynnhudson33","instagram_profile":"https:\/\/www.instagram.com\/fynnhudson33\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","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":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/cal_parky","instagram_profile":"https:\/\/www.instagram.com\/calparky\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":51064,"title":"Martin Andersson","short_name":"MK Andersson","first_name":"Martin Andersson","last_name":"","middle_name":"","birthdate":"1996-09-06","birthplace":"Reading, Berkshire","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":"https:\/\/twitter.com\/MartinAnderss11","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/ackers48\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"bat","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.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/CarseBrydon","instagram_profile":"https:\/\/www.instagram.com\/brydon_carse\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":84689,"title":"Pat Brown","short_name":"PR Brown","first_name":"Pat Brown","last_name":"","middle_name":"","birthdate":"1998-08-23","birthplace":"Peterborough, Cambridgeshire","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/patbrowny\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","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.5,"facebook_profile":"https:\/\/www.facebook.com\/matt.potts.395\/","twitter_profile":"https:\/\/twitter.com\/MattyJPotts","instagram_profile":"https:\/\/www.instagram.com\/matthewpotts35\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/basdeleede","instagram_profile":"https:\/\/www.instagram.com\/basdeleede\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"squad","role_str":""},{"pid":94962,"title":"Harry Came","short_name":"H Came","first_name":"Harry Came","last_name":"","middle_name":"","birthdate":"1998-08-27","birthplace":"Hampshire","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":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/HarryCame4","instagram_profile":"https:\/\/www.instagram.com\/harrycame4\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":94963,"title":"Jack Morley","short_name":"J Morley","first_name":"Jack Morley","last_name":"","middle_name":"","birthdate":"2001-06-25","birthplace":"Rochdale, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","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.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/samconners7","instagram_profile":"https:\/\/www.instagram.com\/samconners_\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95550,"title":"Kasey Aldridge","short_name":"K Aldridge","first_name":"Kasey Aldridge","last_name":"","middle_name":"","birthdate":"2000-12-24","birthplace":"Bristol","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/kcaldridge5\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":101484,"title":"Ben William Aitchison","short_name":"B W Aitchison","first_name":"Ben William Aitchison","last_name":"","middle_name":"","birthdate":"1999-07-06","birthplace":"Southport, 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":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Benaitchison123","instagram_profile":"https:\/\/www.instagram.com\/baitchison13\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108586,"title":"Nick Potts","short_name":"N Potts","first_name":"Nick Potts","last_name":"","middle_name":"","birthdate":"2002-07-17","birthplace":"Burton-on-Trent, Staffordshire,","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/nickwpotts\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":109363,"title":"Mitchell Wagstaff","short_name":"M Wagstaff","first_name":"Mitchell Wagstaff","last_name":"","middle_name":"","birthdate":"2003-09-02","birthplace":"Derby","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":"","twitter_profile":"https:\/\/twitter.com\/mitchellwaggy?lang=en","instagram_profile":"https:\/\/www.instagram.com\/mitchellwagstaff\/?hl=en","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","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":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"all","role_str":""},{"pid":118504,"title":"Allah Mohammad Ghazanfar","short_name":"AM Ghazanfar","first_name":"Allah Mohammad Ghazanfar","last_name":"","middle_name":"","birthdate":"2007-07-15","birthplace":"","country":"af","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":7.5,"facebook_profile":"https:\/\/www.facebook.com\/Ghazanfar050\/","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Afghanistan","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/ben_mckinney9\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":130162,"title":"Harry Moore","short_name":"HJ Moore","first_name":"Harry Moore","last_name":"","middle_name":"","birthdate":"2007-04-26","birthplace":"Houston, Florida","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\/ha66y2004","instagram_profile":"https:\/\/www.instagram.com\/harrymoore72\/","debut_data":"","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":141343,"title":"Yousaf Bin Naeem","short_name":"YB Naeem","first_name":"Yousaf Bin Naeem","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""}]},"etag":"d3d4bde42b4cde85caad13cd9422607c","modified":"2025-07-10 09:06:46","datetime":"2025-07-10 09:06:46","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":86857,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Durham won by 16 runs","day_remaining_over":"","team_batting":"Derbyshire","team_bowling":"Durham","live_inning_number":2,"live_score":{"runs":152,"overs":19.3,"wickets":10,"target":169,"runrate":7.79,"required_runrate":34},"commentary":1,"wagon":2,"batsmen":[{"name":"Allah Mohammad Ghazanfar","batsman_id":118504,"runs":16,"balls_faced":11,"fours":0,"sixes":2,"strike_rate":"145.45"},{"name":"Pat Brown","batsman_id":84689,"runs":1,"balls_faced":1,"fours":0,"sixes":0,"strike_rate":"100.00"}],"bowlers":[{"name":"Ben Raine","bowler_id":49557,"overs":3.3,"runs_conceded":21,"wickets":3,"maidens":0,"econ":"6.00"},{"name":"Jimmy Neesham","bowler_id":31430,"overs":4,"runs_conceded":23,"wickets":2,"maidens":0,"econ":"5.75"}],"commentaries":[{"event_id":"12121631","event":"ball","batsman_id":"48641","bowler_id":"51050","over":"15","ball":"2","score":1,"commentary":"Callum Parkinson to Wayne Madsen, 1 run,","noball_dismissal":false,"text":"","timestamp":1749671886,"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":"12121632","event":"ball","batsman_id":"50663","bowler_id":"51050","over":"15","ball":"3","score":4,"commentary":"Callum Parkinson to Fynn Hudson-Prentice, Four,","noball_dismissal":false,"text":"","timestamp":1749671890,"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":"12121633","event":"ball","batsman_id":"50663","bowler_id":"51050","over":"15","ball":"4","score":0,"commentary":"Callum Parkinson to Fynn Hudson-Prentice, no run,","noball_dismissal":false,"text":"","timestamp":1749671893,"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":"12121634","event":"ball","batsman_id":"50663","bowler_id":"51050","over":"15","ball":"5","score":1,"commentary":"Callum Parkinson to Fynn Hudson-Prentice, 1 run,","noball_dismissal":false,"text":"","timestamp":1749671896,"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":"12121637","event":"wicket","batsman_id":"48641","bowler_id":"51050","over":"15","ball":"6","score":"w","commentary":"Callum Parkinson to Wayne Madsen, no run, c WMH Rhodes b CF Parkinson,","noball_dismissal":false,"text":"","timestamp":1749671919,"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":"48641","how_out":"c WMH Rhodes b CF Parkinson","batsman_runs":"37","batsman_balls":"31"},{"event":"overend","over":16,"runs":8,"score":"128\/7","bats":[{"runs":37,"balls_faced":31,"fours":3,"sixes":1,"batsman_id":48641},{"runs":18,"balls_faced":7,"fours":4,"sixes":0,"batsman_id":50663}],"bowls":[{"runs_conceded":37,"maidens":0,"wickets":2,"bowler_id":51050,"overs":4},{"runs_conceded":28,"maidens":0,"wickets":1,"bowler_id":112844,"overs":3}],"commentary":"End of over 16 (8 runs), Derbyshire 128\/7"},{"event_id":"12121659","event":"wicket","batsman_id":"50663","bowler_id":"31430","over":"16","ball":"1","score":"w","commentary":"Jimmy Neesham to Fynn Hudson-Prentice, no run, c K Aldridge b J Neesham,","noball_dismissal":false,"text":"","timestamp":1749672166,"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":"50663","how_out":"c K Aldridge b J Neesham","batsman_runs":"18","batsman_balls":"8"},{"event_id":"12121663","event":"ball","batsman_id":"118504","bowler_id":"31430","over":"16","ball":"2","score":1,"commentary":"Jimmy Neesham to Allah Mohammad Ghazanfar, 1 run,","noball_dismissal":false,"text":"","timestamp":1749672210,"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":"12121665","event":"ball","batsman_id":"50433","bowler_id":"31430","over":"16","ball":"3","score":1,"commentary":"Jimmy Neesham to Alex Thomson, 1 run,","noball_dismissal":false,"text":"","timestamp":1749672213,"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":"12121668","event":"ball","batsman_id":"118504","bowler_id":"31430","over":"16","ball":"4","score":"1wd","commentary":"Jimmy Neesham to Allah Mohammad Ghazanfar, 1 wide,","noball_dismissal":false,"text":"","timestamp":1749672215,"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":"12121669","event":"ball","batsman_id":"118504","bowler_id":"31430","over":"16","ball":"4","score":1,"commentary":"Jimmy Neesham to Allah Mohammad Ghazanfar, 1 run,","noball_dismissal":false,"text":"","timestamp":1749672219,"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":"12121670","event":"ball","batsman_id":"50433","bowler_id":"31430","over":"16","ball":"5","score":0,"commentary":"Jimmy Neesham to Alex Thomson, no run,","noball_dismissal":false,"text":"","timestamp":1749672223,"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":"12121693","event":"ball","batsman_id":"50433","bowler_id":"31430","over":"16","ball":"6","score":0,"commentary":"Jimmy Neesham to Alex Thomson, no run,","noball_dismissal":false,"text":"","timestamp":1749672319,"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":17,"runs":4,"score":"132\/8","bats":[{"runs":1,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":50433},{"runs":2,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":118504}],"bowls":[{"runs_conceded":14,"maidens":0,"wickets":2,"bowler_id":31430,"overs":3},{"runs_conceded":37,"maidens":0,"wickets":2,"bowler_id":51050,"overs":4}],"commentary":"End of over 17 (4 runs), Derbyshire 132\/8"},{"event_id":"12121695","event":"ball","batsman_id":"118504","bowler_id":"49557","over":"17","ball":"1","score":0,"commentary":"Ben Raine to Allah Mohammad Ghazanfar, no run,","noball_dismissal":false,"text":"","timestamp":1749672343,"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":"12121704","event":"ball","batsman_id":"118504","bowler_id":"49557","over":"17","ball":"2","score":6,"commentary":"Ben Raine to Allah Mohammad Ghazanfar, Six,","noball_dismissal":false,"text":"","timestamp":1749672392,"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":"12121705","event":"ball","batsman_id":"118504","bowler_id":"49557","over":"17","ball":"3","score":1,"commentary":"Ben Raine to Allah Mohammad Ghazanfar, 1 run,","noball_dismissal":false,"text":"","timestamp":1749672451,"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":"12121707","event":"ball","batsman_id":"50433","bowler_id":"49557","over":"17","ball":"4","score":1,"commentary":"Ben Raine to Alex Thomson, 1 run,","noball_dismissal":false,"text":"","timestamp":1749672455,"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":"12121708","event":"ball","batsman_id":"118504","bowler_id":"49557","over":"17","ball":"5","score":"1lb","commentary":"Ben Raine to Allah Mohammad Ghazanfar, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1749672458,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"1","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12121717","event":"ball","batsman_id":"50433","bowler_id":"49557","over":"17","ball":"6","score":1,"commentary":"Ben Raine to Alex Thomson, 1 run,","noball_dismissal":false,"text":"","timestamp":1749672497,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":18,"runs":10,"score":"142\/8","bats":[{"runs":3,"balls_faced":5,"fours":0,"sixes":0,"batsman_id":50433},{"runs":9,"balls_faced":6,"fours":0,"sixes":1,"batsman_id":118504}],"bowls":[{"runs_conceded":20,"maidens":0,"wickets":1,"bowler_id":49557,"overs":3},{"runs_conceded":14,"maidens":0,"wickets":2,"bowler_id":31430,"overs":3}],"commentary":"End of over 18 (10 runs), Derbyshire 142\/8"},{"event_id":"12121731","event":"ball","batsman_id":"50433","bowler_id":"31430","over":"18","ball":"1","score":1,"commentary":"Jimmy Neesham to Alex Thomson, 1 run,","noball_dismissal":false,"text":"","timestamp":1749672580,"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":"12121732","event":"ball","batsman_id":"118504","bowler_id":"31430","over":"18","ball":"2","score":1,"commentary":"Jimmy Neesham to Allah Mohammad Ghazanfar, 1 run,","noball_dismissal":false,"text":"","timestamp":1749672583,"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":"12121743","event":"ball","batsman_id":"50433","bowler_id":"31430","over":"18","ball":"3","score":1,"commentary":"Jimmy Neesham to Alex Thomson, 1 run,","noball_dismissal":false,"text":"","timestamp":1749672660,"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":"12121747","event":"ball","batsman_id":"118504","bowler_id":"31430","over":"18","ball":"4","score":6,"commentary":"Jimmy Neesham to Allah Mohammad Ghazanfar, Six,","noball_dismissal":false,"text":"","timestamp":1749672730,"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":"12121755","event":"ball","batsman_id":"118504","bowler_id":"31430","over":"18","ball":"5","score":0,"commentary":"Jimmy Neesham to Allah Mohammad Ghazanfar, no run,","noball_dismissal":false,"text":"","timestamp":1749672859,"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":"12121771","event":"ball","batsman_id":"118504","bowler_id":"31430","over":"18","ball":"6","score":0,"commentary":"Jimmy Neesham to Allah Mohammad Ghazanfar, no run,","noball_dismissal":false,"text":"","timestamp":1749672862,"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":9,"score":"151\/8","bats":[{"runs":16,"balls_faced":10,"fours":0,"sixes":2,"batsman_id":118504},{"runs":5,"balls_faced":7,"fours":0,"sixes":0,"batsman_id":50433}],"bowls":[{"runs_conceded":23,"maidens":0,"wickets":2,"bowler_id":31430,"overs":4},{"runs_conceded":20,"maidens":0,"wickets":1,"bowler_id":49557,"overs":3}],"commentary":"End of over 19 (9 runs), Derbyshire 151\/8"},{"event_id":"12121776","event":"wicket","batsman_id":"50433","bowler_id":"49557","over":"19","ball":"1","score":"w","commentary":"Ben Raine to Alex Thomson, no run, b BA Raine,","noball_dismissal":false,"text":"","timestamp":1749672866,"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":"50433","how_out":"b BA Raine","batsman_runs":"5","batsman_balls":"8"},{"event_id":"12121784","event":"ball","batsman_id":"84689","bowler_id":"49557","over":"19","ball":"2","score":1,"commentary":"Ben Raine to Pat Brown, 1 run,","noball_dismissal":false,"text":"","timestamp":1749672943,"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":"12121791","event":"wicket","batsman_id":"118504","bowler_id":"49557","over":"19","ball":"3","score":"w","commentary":"Ben Raine to Allah Mohammad Ghazanfar, no run, lbw b BA Raine,","noball_dismissal":false,"text":"","timestamp":1749672970,"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":"118504","how_out":"lbw b BA Raine","batsman_runs":"16","batsman_balls":"11"}],"day":"0","session":"0","live_inning":{"iid":197857,"number":2,"name":"Derbyshire Inning","short_name":"DER Inning","status":2,"issuperover":"false","result":1,"batting_team_id":104949,"fielding_team_id":7548,"scores":"152\/10","scores_full":"152\/10 (19.3 ov)","fielder":[{"fielder_id":"95550","fielder_name":"Kasey Aldridge","catches":3,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"10620","fielder_name":"Will Rhodes","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":"2","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"2","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"2","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"2","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Allah Mohammad Ghazanfar","batsman_id":"118504","runs":"16","balls":"11","how_out":"lbw b BA Raine","score_at_dismissal":152,"overs_at_dismissal":"19.3","bowler_id":"49557","dismissal":"lbw","number":10},"extra_runs":{"byes":0,"legbyes":2,"wides":4,"noballs":0,"penalty":"0","total":6},"equations":{"runs":152,"wickets":10,"overs":"19.3","bowlers_used":6,"runrate":"7.79"},"current_partnership":{"runs":1,"balls":2,"overs":0.2,"batsmen":[{"name":"Pat Brown","batsman_id":84689,"runs":1,"balls":1},{"name":"Allah Mohammad Ghazanfar","batsman_id":118504,"runs":0,"balls":1}]},"did_not_bat":[],"max_over":"20","target":"169","recent_scores":"w,1,w,0,0,6,1,1,1,1,1,1,1,6,0,0,0,1","last_five_overs":"44\/4 8.52","last_ten_overs":"83\/6 8.03"},"teams":[{"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":"168\/6 (20 ov)","scores":"168\/6","overs":"20"},{"tid":104949,"title":"Derbyshire","abbr":"DER","alt_name":"DER","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/derbyshire-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/derbyshire-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"152\/10 (19.3 ov)","scores":"152\/10","overs":"19.3"}],"players":[{"pid":1259,"title":"Aneurin Donald","short_name":"A Donald","first_name":"Aneurin Donald","last_name":"","middle_name":"","birthdate":"1996-12-20","birthplace":"Swansea, Glamorgan","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/aneurin.donald\/","twitter_profile":"https:\/\/twitter.com\/AneurinDonald12","instagram_profile":"https:\/\/www.instagram.com\/aneurindonald\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","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":9,"facebook_profile":"https:\/\/www.facebook.com\/BenStokes38Official","twitter_profile":"https:\/\/twitter.com\/benstokes38","instagram_profile":"https:\/\/www.instagram.com\/stokesy\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":7735,"title":"David Lloyd","short_name":"DL Lloyd","first_name":"David Lloyd","last_name":"","middle_name":"","birthdate":"1992-06-15","birthplace":"St Asaph, Flintshire, Wales","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/davidlloyduk\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":10594,"title":"Samit Patel","short_name":"SR Patel","first_name":"Samit Patel","last_name":"","middle_name":"","birthdate":"1984-11-30","birthplace":"Leicester","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/samitpatel","instagram_profile":"https:\/\/www.instagram.com\/samit._.patel\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":"(C)"},{"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":"","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":"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":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","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":7.5,"facebook_profile":"https:\/\/www.facebook.com\/borthwick16\/","twitter_profile":"https:\/\/twitter.com\/Borthwick16","instagram_profile":"https:\/\/www.instagram.com\/borthwick16\/","debut_data":"","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":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"all","role_str":""},{"pid":43360,"title":"Ross Whiteley","short_name":"RA Whiteley","first_name":"Ross Whiteley","last_name":"","middle_name":"","birthdate":"1988-09-13","birthplace":"Sheffield, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/RossWhiteley44","instagram_profile":"https:\/\/www.instagram.com\/rosswhiteley44\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/codi_yusuf\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":46310,"title":"Blair Tickner","short_name":"BM Tickner","first_name":"Blair Tickner","last_name":"","middle_name":"","birthdate":"1993-10-13","birthplace":"Napier, Hawke''s Bay","country":"nz","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\/blair.tickner\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/ticks93\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","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":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/dbedingham0","instagram_profile":"https:\/\/www.instagram.com\/davidbedingham\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":48428,"title":"Luis Reece","short_name":"LM Reece","first_name":"Luis Reece","last_name":"","middle_name":"","birthdate":"1990-08-04","birthplace":"Taunton, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lreece17","instagram_profile":"https:\/\/www.instagram.com\/louisreece\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":48498,"title":"Caleb Jewell","short_name":"CP Jewell","first_name":"Caleb Jewell","last_name":"","middle_name":"","birthdate":"1997-04-21","birthplace":"Hobart, Tasmania","country":"au","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/caleb.jewell.148\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/cjewell_32\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"bat","role_str":""},{"pid":48508,"title":"Brooke Guest","short_name":"BD Guest","first_name":"Brooke Guest","last_name":"","middle_name":"","birthdate":"1997-05-14","birthplace":"Whitworth Park, Manchester, England","country":"au","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\/guesty211\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"wk","role_str":"(WK)"},{"pid":48641,"title":"Wayne Madsen","short_name":"WL Madsen","first_name":"Wayne Madsen","last_name":"","middle_name":"","birthdate":"1984-01-02","birthplace":"Durban","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\/waynemadders77","instagram_profile":"https:\/\/www.instagram.com\/waynemadsen77\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","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":9,"facebook_profile":"https:\/\/www.facebook.com\/MAWood33\/","twitter_profile":"https:\/\/twitter.com\/MAWood33","instagram_profile":"https:\/\/www.instagram.com\/mawood33\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/pauljcoughlin\/","debut_data":"","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,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BenRaine14","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","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":"","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,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/OllieRobinson7","instagram_profile":"https:\/\/www.instagram.com\/ollie_robbo_\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":49808,"title":"Zak Chappell","short_name":"ZJ Chappell","first_name":"Zak Chappell","last_name":"","middle_name":"","birthdate":"1996-08-21","birthplace":"Grantham, Lincolnshire","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/chappooo","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"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":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/NSowter","instagram_profile":"https:\/\/www.instagram.com\/nathansowter\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"bowl","role_str":""},{"pid":50433,"title":"Alex Thomson","short_name":"AT Thomson","first_name":"Alex Thomson","last_name":"","middle_name":"","birthdate":"1993-10-30","birthplace":"Stoke-on-Trent, Staffordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/alextomo","instagram_profile":"https:\/\/www.instagram.com\/alex_thomson_racing\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":50528,"title":"Anuj Dal","short_name":"AK Dal","first_name":"Anuj Dal","last_name":"","middle_name":"","birthdate":"1996-07-08","birthplace":"Newcastle-under-Lyme, Staffordshire","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":"https:\/\/twitter.com\/AnujDal","instagram_profile":"https:\/\/www.instagram.com\/anujdal0\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50663,"title":"Fynn Hudson-Prentice","short_name":"FJ Hudson-Prentice","first_name":"Fynn Hudson-Prentice","last_name":"","middle_name":"","birthdate":"1996-01-12","birthplace":"Haywards Heath, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/fynnhudson33","instagram_profile":"https:\/\/www.instagram.com\/fynnhudson33\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","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":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/cal_parky","instagram_profile":"https:\/\/www.instagram.com\/calparky\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":51064,"title":"Martin Andersson","short_name":"MK Andersson","first_name":"Martin Andersson","last_name":"","middle_name":"","birthdate":"1996-09-06","birthplace":"Reading, Berkshire","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":"https:\/\/twitter.com\/MartinAnderss11","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/ackers48\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"bat","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.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/CarseBrydon","instagram_profile":"https:\/\/www.instagram.com\/brydon_carse\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":84689,"title":"Pat Brown","short_name":"PR Brown","first_name":"Pat Brown","last_name":"","middle_name":"","birthdate":"1998-08-23","birthplace":"Peterborough, Cambridgeshire","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/patbrowny\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","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.5,"facebook_profile":"https:\/\/www.facebook.com\/matt.potts.395\/","twitter_profile":"https:\/\/twitter.com\/MattyJPotts","instagram_profile":"https:\/\/www.instagram.com\/matthewpotts35\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/basdeleede","instagram_profile":"https:\/\/www.instagram.com\/basdeleede\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"squad","role_str":""},{"pid":94962,"title":"Harry Came","short_name":"H Came","first_name":"Harry Came","last_name":"","middle_name":"","birthdate":"1998-08-27","birthplace":"Hampshire","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":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/HarryCame4","instagram_profile":"https:\/\/www.instagram.com\/harrycame4\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":94963,"title":"Jack Morley","short_name":"J Morley","first_name":"Jack Morley","last_name":"","middle_name":"","birthdate":"2001-06-25","birthplace":"Rochdale, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","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.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/samconners7","instagram_profile":"https:\/\/www.instagram.com\/samconners_\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95550,"title":"Kasey Aldridge","short_name":"K Aldridge","first_name":"Kasey Aldridge","last_name":"","middle_name":"","birthdate":"2000-12-24","birthplace":"Bristol","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/kcaldridge5\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":101484,"title":"Ben William Aitchison","short_name":"B W Aitchison","first_name":"Ben William Aitchison","last_name":"","middle_name":"","birthdate":"1999-07-06","birthplace":"Southport, 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":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Benaitchison123","instagram_profile":"https:\/\/www.instagram.com\/baitchison13\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108586,"title":"Nick Potts","short_name":"N Potts","first_name":"Nick Potts","last_name":"","middle_name":"","birthdate":"2002-07-17","birthplace":"Burton-on-Trent, Staffordshire,","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/nickwpotts\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":109363,"title":"Mitchell Wagstaff","short_name":"M Wagstaff","first_name":"Mitchell Wagstaff","last_name":"","middle_name":"","birthdate":"2003-09-02","birthplace":"Derby","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":"","twitter_profile":"https:\/\/twitter.com\/mitchellwaggy?lang=en","instagram_profile":"https:\/\/www.instagram.com\/mitchellwagstaff\/?hl=en","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","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":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"all","role_str":""},{"pid":118504,"title":"Allah Mohammad Ghazanfar","short_name":"AM Ghazanfar","first_name":"Allah Mohammad Ghazanfar","last_name":"","middle_name":"","birthdate":"2007-07-15","birthplace":"","country":"af","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":7.5,"facebook_profile":"https:\/\/www.facebook.com\/Ghazanfar050\/","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Afghanistan","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/ben_mckinney9\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":130162,"title":"Harry Moore","short_name":"HJ Moore","first_name":"Harry Moore","last_name":"","middle_name":"","birthdate":"2007-04-26","birthplace":"Houston, Florida","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\/ha66y2004","instagram_profile":"https:\/\/www.instagram.com\/harrymoore72\/","debut_data":"","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":141343,"title":"Yousaf Bin Naeem","short_name":"YB Naeem","first_name":"Yousaf Bin Naeem","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""}]},"etag":"d3d4bde42b4cde85caad13cd9422607c","modified":"2025-07-10 09:06:46","datetime":"2025-07-10 09:06:46","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86857 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:961d4d3e-72b6-4949-98af-e113d250607e
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86857 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86857,3,'{"status":"ok","response":{"match_id":86857,"title":"Durham vs Derbyshire","short_title":"DUR vs DER","subtitle":"Match 37","match_number":"37","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Durham won by 16 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":"168\/6 (20 ov)","scores":"168\/6","overs":"20"},"teamb":{"team_id":104949,"name":"Derbyshire","short_name":"DER","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/derbyshire-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/derbyshire-logo.png","scores_full":"152\/10 (19.3 ov)","scores":"152\/10","overs":"19.3"},"date_start":"2025-06-11 17:30:00","date_end":"2025-06-12 03:30:00","timestamp_start":1749663000,"timestamp_end":1749699000,"date_start_ist":"2025-06-11 23:00:00","date_end_ist":"2025-06-12 09:00:00","venue":{"venue_id":"39","name":"Riverside Ground, Chester-le-Street","location":"Chester-le-Street","country":"England","timezone":""},"umpires":"Michael Gough (England), Neil Pratt (England)","referee":"Will Smith (England)","equation":"","live":"","result":"DUR won by 16 runs","result_type":1,"win_margin":"16 runs","winning_team_id":7548,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-10 00:26:10","verify_time":"2025-06-12 01:57:17","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"scattered clouds","temp":13.16,"humidity":84,"visibility":10000,"wind_speed":"18.23","clouds":30},"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"High Scoring","pace_bowling_condition":"Average","spine_bowling_condition":"Slow Spin"},"toss":{"text":"Derbyshire elected to bowl","winner":104949,"decision":2}},"etag":"d3d4bde42b4cde85caad13cd9422607c","modified":"2025-07-10 09:06:46","datetime":"2025-07-10 09:06:46","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":86857,"title":"Durham vs Derbyshire","short_title":"DUR vs DER","subtitle":"Match 37","match_number":"37","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Durham won by 16 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":"168\/6 (20 ov)","scores":"168\/6","overs":"20"},"teamb":{"team_id":104949,"name":"Derbyshire","short_name":"DER","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/derbyshire-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/derbyshire-logo.png","scores_full":"152\/10 (19.3 ov)","scores":"152\/10","overs":"19.3"},"date_start":"2025-06-11 17:30:00","date_end":"2025-06-12 03:30:00","timestamp_start":1749663000,"timestamp_end":1749699000,"date_start_ist":"2025-06-11 23:00:00","date_end_ist":"2025-06-12 09:00:00","venue":{"venue_id":"39","name":"Riverside Ground, Chester-le-Street","location":"Chester-le-Street","country":"England","timezone":""},"umpires":"Michael Gough (England), Neil Pratt (England)","referee":"Will Smith (England)","equation":"","live":"","result":"DUR won by 16 runs","result_type":1,"win_margin":"16 runs","winning_team_id":7548,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-10 00:26:10","verify_time":"2025-06-12 01:57:17","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"scattered clouds","temp":13.16,"humidity":84,"visibility":10000,"wind_speed":"18.23","clouds":30},"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"High Scoring","pace_bowling_condition":"Average","spine_bowling_condition":"Slow Spin"},"toss":{"text":"Derbyshire elected to bowl","winner":104949,"decision":2}},"etag":"d3d4bde42b4cde85caad13cd9422607c","modified":"2025-07-10 09:06:46","datetime":"2025-07-10 09:06:46","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86857 AND DataTypeId = 3 END Live Report & Scorecard of Durham vs Derbyshire Match 37