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:0e1b136a-02a0-471f-b34b-6750364a6458
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86908 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86908,1,'{"status":"ok","response":{"mid":86908,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Derbyshire won by 7 wickets","day_remaining_over":"","team_batting":"Derbyshire","team_bowling":"Yorkshire","live_inning_number":2,"live_score":{"runs":201,"overs":17.2,"wickets":3,"target":201,"runrate":11.6,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Ross Whiteley","batsman_id":43360,"runs":29,"balls_faced":17,"fours":2,"sixes":2,"strike_rate":"170.59"},{"name":"Wayne Madsen","batsman_id":48641,"runs":38,"balls_faced":25,"fours":7,"sixes":0,"strike_rate":"152.00"}],"bowlers":[{"name":"Jordan Thompson","bowler_id":50507,"overs":3.2,"runs_conceded":28,"wickets":0,"maidens":0,"econ":"8.40"},{"name":"William O\u2019Rourke","bowler_id":96733,"overs":4,"runs_conceded":50,"wickets":1,"maidens":0,"econ":"12.50"}],"commentaries":[{"event_id":"12296467","event":"ball","batsman_id":"43360","bowler_id":"50507","over":"13","ball":"1","score":1,"commentary":"Jordan Thompson to Ross Whiteley, 1 run,","noball_dismissal":false,"text":"","timestamp":1751818741,"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":"12296470","event":"ball","batsman_id":"48641","bowler_id":"50507","over":"13","ball":"2","score":1,"commentary":"Jordan Thompson to Wayne Madsen, 1 run,","noball_dismissal":false,"text":"","timestamp":1751818743,"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":"12296478","event":"ball","batsman_id":"43360","bowler_id":"50507","over":"13","ball":"3","score":0,"commentary":"Jordan Thompson to Ross Whiteley, no run,","noball_dismissal":false,"text":"","timestamp":1751818751,"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":"12296492","event":"ball","batsman_id":"43360","bowler_id":"50507","over":"13","ball":"4","score":1,"commentary":"Jordan Thompson to Ross Whiteley, 1 run,","noball_dismissal":false,"text":"","timestamp":1751818753,"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":"12296496","event":"ball","batsman_id":"48641","bowler_id":"50507","over":"13","ball":"5","score":1,"commentary":"Jordan Thompson to Wayne Madsen, 1 run,","noball_dismissal":false,"text":"","timestamp":1751818755,"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":"12296497","event":"ball","batsman_id":"43360","bowler_id":"50507","over":"13","ball":"6","score":"1wd","commentary":"Jordan Thompson to Ross Whiteley, 1 wide,","noball_dismissal":false,"text":"","timestamp":1751818758,"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":"12296498","event":"ball","batsman_id":"43360","bowler_id":"50507","over":"13","ball":"6","score":2,"commentary":"Jordan Thompson to Ross Whiteley, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751818760,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":14,"runs":7,"score":"165\/3","bats":[{"runs":10,"balls_faced":9,"fours":1,"sixes":0,"batsman_id":43360},{"runs":21,"balls_faced":13,"fours":4,"sixes":0,"batsman_id":48641}],"bowls":[{"runs_conceded":18,"maidens":0,"wickets":0,"bowler_id":50507,"overs":3},{"runs_conceded":29,"maidens":0,"wickets":0,"bowler_id":50392,"overs":2}],"commentary":"End of over 14 (7 runs), Derbyshire 165\/3"},{"event_id":"12296502","event":"ball","batsman_id":"48641","bowler_id":"57644","over":"14","ball":"1","score":0,"commentary":"Matt Milnes to Wayne Madsen, no run,","noball_dismissal":false,"text":"","timestamp":1751818790,"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":"12296503","event":"ball","batsman_id":"48641","bowler_id":"57644","over":"14","ball":"2","score":4,"commentary":"Matt Milnes to Wayne Madsen, Four,","noball_dismissal":false,"text":"","timestamp":1751818798,"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":"12296504","event":"ball","batsman_id":"48641","bowler_id":"57644","over":"14","ball":"3","score":4,"commentary":"Matt Milnes to Wayne Madsen, Four,","noball_dismissal":false,"text":"","timestamp":1751818800,"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":"12296505","event":"ball","batsman_id":"48641","bowler_id":"57644","over":"14","ball":"4","score":1,"commentary":"Matt Milnes to Wayne Madsen, 1 run,","noball_dismissal":false,"text":"","timestamp":1751818802,"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":"12296507","event":"ball","batsman_id":"43360","bowler_id":"57644","over":"14","ball":"5","score":6,"commentary":"Matt Milnes to Ross Whiteley, Six,","noball_dismissal":false,"text":"","timestamp":1751818829,"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":"12296510","event":"ball","batsman_id":"43360","bowler_id":"57644","over":"14","ball":"6","score":0,"commentary":"Matt Milnes to Ross Whiteley, no run,","noball_dismissal":false,"text":"","timestamp":1751818836,"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":15,"runs":15,"score":"180\/3","bats":[{"runs":16,"balls_faced":11,"fours":1,"sixes":1,"batsman_id":43360},{"runs":30,"balls_faced":17,"fours":6,"sixes":0,"batsman_id":48641}],"bowls":[{"runs_conceded":35,"maidens":0,"wickets":0,"bowler_id":57644,"overs":3},{"runs_conceded":18,"maidens":0,"wickets":0,"bowler_id":50507,"overs":3}],"commentary":"End of over 15 (15 runs), Derbyshire 180\/3"},{"event_id":"12296516","event":"ball","batsman_id":"48641","bowler_id":"93358","over":"15","ball":"1","score":1,"commentary":"Will Sutherland to Wayne Madsen, 1 run,","noball_dismissal":false,"text":"","timestamp":1751818875,"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":"12296518","event":"ball","batsman_id":"43360","bowler_id":"93358","over":"15","ball":"2","score":1,"commentary":"Will Sutherland to Ross Whiteley, 1 run,","noball_dismissal":false,"text":"","timestamp":1751818877,"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":"12296523","event":"ball","batsman_id":"48641","bowler_id":"93358","over":"15","ball":"3","score":0,"commentary":"Will Sutherland to Wayne Madsen, no run,","noball_dismissal":false,"text":"","timestamp":1751818880,"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":"12296525","event":"ball","batsman_id":"48641","bowler_id":"93358","over":"15","ball":"4","score":1,"commentary":"Will Sutherland to Wayne Madsen, 1 run,","noball_dismissal":false,"text":"","timestamp":1751818882,"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":"12296529","event":"ball","batsman_id":"43360","bowler_id":"93358","over":"15","ball":"5","score":1,"commentary":"Will Sutherland to Ross Whiteley, 1 run,","noball_dismissal":false,"text":"","timestamp":1751818893,"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":"12296532","event":"ball","batsman_id":"48641","bowler_id":"93358","over":"15","ball":"6","score":1,"commentary":"Will Sutherland to Wayne Madsen, 1 run,","noball_dismissal":false,"text":"","timestamp":1751818904,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":16,"runs":5,"score":"185\/3","bats":[{"runs":33,"balls_faced":21,"fours":6,"sixes":0,"batsman_id":48641},{"runs":18,"balls_faced":13,"fours":1,"sixes":1,"batsman_id":43360}],"bowls":[{"runs_conceded":16,"maidens":0,"wickets":1,"bowler_id":93358,"overs":3},{"runs_conceded":35,"maidens":0,"wickets":0,"bowler_id":57644,"overs":3}],"commentary":"End of over 16 (5 runs), Derbyshire 185\/3"},{"event_id":"12296604","event":"ball","batsman_id":"48641","bowler_id":"96733","over":"16","ball":"1","score":0,"commentary":"William O\u2019Rourke to Wayne Madsen, no run,","noball_dismissal":false,"text":"","timestamp":1751819215,"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":"12296606","event":"ball","batsman_id":"48641","bowler_id":"96733","over":"16","ball":"2","score":4,"commentary":"William O\u2019Rourke to Wayne Madsen, Four,","noball_dismissal":false,"text":"","timestamp":1751819247,"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":"12296607","event":"ball","batsman_id":"48641","bowler_id":"96733","over":"16","ball":"3","score":0,"commentary":"William O\u2019Rourke to Wayne Madsen, no run,","noball_dismissal":false,"text":"","timestamp":1751819250,"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":"12296610","event":"ball","batsman_id":"48641","bowler_id":"96733","over":"16","ball":"4","score":1,"commentary":"William O\u2019Rourke to Wayne Madsen, 1 run,","noball_dismissal":false,"text":"","timestamp":1751819252,"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":"12296613","event":"ball","batsman_id":"43360","bowler_id":"96733","over":"16","ball":"5","score":0,"commentary":"William O\u2019Rourke to Ross Whiteley, no run,","noball_dismissal":false,"text":"","timestamp":1751819254,"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":"12296616","event":"ball","batsman_id":"43360","bowler_id":"96733","over":"16","ball":"6","score":1,"commentary":"William O\u2019Rourke to Ross Whiteley, 1 run,","noball_dismissal":false,"text":"","timestamp":1751819257,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":17,"runs":6,"score":"191\/3","bats":[{"runs":19,"balls_faced":15,"fours":1,"sixes":1,"batsman_id":43360},{"runs":38,"balls_faced":25,"fours":7,"sixes":0,"batsman_id":48641}],"bowls":[{"runs_conceded":61,"maidens":0,"wickets":1,"bowler_id":96733,"overs":4},{"runs_conceded":16,"maidens":0,"wickets":1,"bowler_id":93358,"overs":3}],"commentary":"End of over 17 (6 runs), Derbyshire 191\/3"},{"event_id":"12296620","event":"ball","batsman_id":"43360","bowler_id":"50507","over":"17","ball":"1","score":6,"commentary":"Jordan Thompson to Ross Whiteley, Six,","noball_dismissal":false,"text":"","timestamp":1751819259,"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":"12296621","event":"ball","batsman_id":"43360","bowler_id":"50507","over":"17","ball":"2","score":4,"commentary":"Jordan Thompson to Ross Whiteley, Four,","noball_dismissal":false,"text":"","timestamp":1751819261,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false}],"day":"0","session":"0","live_inning":{"iid":199217,"number":2,"name":"Derbyshire Inning","short_name":"DER Inning","status":2,"issuperover":"false","result":3,"batting_team_id":104949,"fielding_team_id":7050,"scores":"201\/3","scores_full":"201\/3 (17.2 ov)","fielder":[{"fielder_id":"102295","fielder_name":"James Wharton","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"96733","fielder_name":"William O\u2019Rourke","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"50392","fielder_name":"Dom Bess","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Samit Patel","batsman_id":"10594","runs":"6","balls":"6","how_out":"c Dom Bess b WO Rourke","score_at_dismissal":141,"overs_at_dismissal":"11.4","bowler_id":"96733","dismissal":"caught","number":3},"extra_runs":{"byes":0,"legbyes":4,"wides":8,"noballs":0,"penalty":"0","total":12},"equations":{"runs":201,"wickets":3,"overs":"17.2","bowlers_used":6,"runrate":"11.60"},"current_partnership":{"runs":60,"balls":34,"overs":5.4,"batsmen":[{"name":"Ross Whiteley","batsman_id":43360,"runs":29,"balls":17},{"name":"Wayne Madsen","batsman_id":48641,"runs":28,"balls":17}]},"did_not_bat":[{"player_id":"94962","name":"Harry Came"},{"player_id":"51064","name":"Martin Andersson"},{"player_id":"50433","name":"Alex Thomson"},{"player_id":"84689","name":"Pat Brown"},{"player_id":"49808","name":"Zak Chappell"},{"player_id":"118504","name":"Allah Mohammad Ghazanfar"}],"max_over":"20","target":"201","recent_scores":"4,6,1,0,1,0,4,0,1,1,1,0,1,1,0,6,1,4","last_five_overs":"53\/0 10.26","last_ten_overs":"104\/3 10.23"},"teams":[{"tid":7050,"title":"Yorkshire","abbr":"YOR","alt_name":"YOR","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/yorkshire-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/yorkshire-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"200\/6 (20 ov)","scores":"200\/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":"201\/3 (17.2 ov)","scores":"201\/3","overs":"17.2"}],"players":[{"pid":99,"title":"Joe Root","short_name":"J Root","first_name":"Joe Root","last_name":"","middle_name":"","birthdate":"1990-12-30","birthplace":"Sheffield, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":18968,"recent_appearance":1514244600,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/JoeRootOfficial\/","twitter_profile":"https:\/\/twitter.com\/root66","instagram_profile":"https:\/\/www.instagram.com\/root66\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"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":8,"facebook_profile":"https:\/\/www.facebook.com\/aneurin.donald\/","twitter_profile":"https:\/\/twitter.com\/AneurinDonald12","instagram_profile":"https:\/\/www.instagram.com\/aneurindonald\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":1933,"title":"Adil Rashid","short_name":"A Rashid","first_name":"Adil Rashid","last_name":"","middle_name":"","birthdate":"1988-02-17","birthplace":" Bradford, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/AdilRashid95\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/adilrashid\/","debut_data":"","bowling_type":"Spin","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":"bat","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\/davidlloyduk\/","debut_data":"","bowling_type":"Pace","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":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/samitpatel","instagram_profile":"https:\/\/www.instagram.com\/samit._.patel\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":"(C)"},{"pid":10610,"title":"Adam Lyth","short_name":"A Lyth","first_name":"Adam Lyth","last_name":"","middle_name":"","birthdate":"1987-09-25","birthplace":"Whitby, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/lythy09\/","twitter_profile":"https:\/\/twitter.com\/lythy09","instagram_profile":"https:\/\/www.instagram.com\/lythy09\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":43358,"title":"Dawid Malan","short_name":"D Malan","first_name":"Dawid Malan","last_name":"","middle_name":"","birthdate":"1987-09-03","birthplace":"Roehampton, England","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":9,"facebook_profile":"https:\/\/www.facebook.com\/D.Malanofficial\/","twitter_profile":"https:\/\/twitter.com\/dmalan29","instagram_profile":"https:\/\/www.instagram.com\/djmalan29\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"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":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/RossWhiteley44","instagram_profile":"https:\/\/www.instagram.com\/rosswhiteley44\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":44100,"title":"Jonny Bairstow","short_name":"J Bairstow","first_name":"Jonny Bairstow","last_name":"","middle_name":"","birthdate":"1989-09-26","birthplace":" Bradford, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/jbairstow21\/","twitter_profile":"https:\/\/twitter.com\/jbairstow21","instagram_profile":"https:\/\/www.instagram.com\/jbairstow21\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":45911,"title":"Daniel Moriarty","short_name":"DT Moriarty","first_name":"Daniel Moriarty","last_name":"","middle_name":"","birthdate":"1999-12-02","birthplace":"Reigate, Surrey","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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","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":7,"facebook_profile":"https:\/\/www.facebook.com\/blair.tickner\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/ticks93\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","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":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lreece17","instagram_profile":"https:\/\/www.instagram.com\/louisreece\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":48449,"title":"Ben Coad","short_name":"BO Coad","first_name":"Ben Coad","last_name":"","middle_name":"","birthdate":"1994-01-10","birthplace":"Harrogate, Yorkshire","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\/BenCoad10","instagram_profile":"https:\/\/www.instagram.com\/bencoad10\/","debut_data":"","bowling_type":"Pace","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":"","bowling_type":"","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/guesty211\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"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":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/waynemadders77","instagram_profile":"https:\/\/www.instagram.com\/waynemadsen77\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/chappooo","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":50392,"title":"Dom Bess","short_name":"Dom Bess","first_name":"Dom Bess","last_name":"","middle_name":"","birthdate":"1997-07-22","birthplace":"Exeter, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/dombess99\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","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":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/alextomo","instagram_profile":"https:\/\/www.instagram.com\/alex_thomson_racing\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":50505,"title":"Jonathan Tattersall","short_name":"JA Tattersall","first_name":"Jonathan Tattersall","last_name":"","middle_name":"","birthdate":"1994-12-15","birthplace":" Harrogate, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50507,"title":"Jordan Thompson","short_name":"JA Thompson","first_name":"Jordan Thompson","last_name":"","middle_name":"","birthdate":"1996-10-09","birthplace":"Leeds, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Tommo455","instagram_profile":"https:\/\/www.instagram.com\/jordan.a.thompson\/","debut_data":"","bowling_type":"Pace","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":5.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/AnujDal","instagram_profile":"https:\/\/www.instagram.com\/anujdal0\/","debut_data":"","bowling_type":"Pace","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":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/fynnhudson33","instagram_profile":"https:\/\/www.instagram.com\/fynnhudson33\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/MartinAnderss11","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":57644,"title":"Matt Milnes","short_name":"M Milnes","first_name":"Matt Milnes","last_name":"","middle_name":"","birthdate":"1994-07-29","birthplace":" Nottingham","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/mmilnes84","instagram_profile":"https:\/\/www.instagram.com\/matt_milnes\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":61872,"title":"Jack White","short_name":"cJ White","first_name":"Jack White","last_name":"","middle_name":"","birthdate":"1992-02-19","birthplace":" Kendal","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/patbrowny\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":90887,"title":"Harry Brook","short_name":"H Brook","first_name":"Harry Brook","last_name":"","middle_name":"","birthdate":"1999-02-22","birthplace":"Keighley, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/HarryBroook\/","twitter_profile":"https:\/\/twitter.com\/Harry_Brook_88","instagram_profile":"https:\/\/www.instagram.com\/harry_brook88\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":93358,"title":"Will Sutherland","short_name":"W Sutherland","first_name":"Will Sutherland","last_name":"","middle_name":"","birthdate":"1999-10-27","birthplace":"Melbourne, Australia","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":23792,"recent_appearance":1515891600,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/will_suth12","instagram_profile":"https:\/\/www.instagram.com\/willsutherland12\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"all","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":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/HarryCame4","instagram_profile":"https:\/\/www.instagram.com\/harrycame4\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95555,"title":"George Hill","short_name":"G Hill","first_name":"George Hill","last_name":"","middle_name":"","birthdate":"2001-01-24","birthplace":"Keighley, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95593,"title":"Finlay Bean","short_name":"F Bean","first_name":"Finlay Bean","last_name":"","middle_name":"","birthdate":"2002-04-16","birthplace":" Harrogate, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":96059,"title":"Matthew Revis","short_name":"M Revis","first_name":"Matthew Revis","last_name":"","middle_name":"","birthdate":"2001-11-15","birthplace":" Steeton, Yorkshire","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/matty.revis_\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":96606,"title":"Harry Duke","short_name":"H Duke","first_name":"Harry Duke","last_name":"","middle_name":"","birthdate":"2001-09-01","birthplace":"Pinderfields, Wakefield","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":96733,"title":"William O\u2019Rourke","short_name":"WO Rourke","first_name":"William O\u2019Rourke","last_name":"","middle_name":"","birthdate":"2001-08-06","birthplace":"Surrey","country":"nz","primary_team":{"tid":1068,"name":"","short_name":""},"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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/willorourke_\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bowl","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":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Benaitchison123","instagram_profile":"https:\/\/www.instagram.com\/baitchison13\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":102295,"title":"James Wharton","short_name":"J Wharton","first_name":"James Wharton","last_name":"","middle_name":"","birthdate":"2001-02-01","birthplace":" Huddersfield","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":109356,"title":"William Luxton","short_name":"W Luxton","first_name":"William Luxton","last_name":"","middle_name":"","birthdate":"2003-05-06","birthplace":"Keighley, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","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":5.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/mitchellwaggy?lang=en","instagram_profile":"https:\/\/www.instagram.com\/mitchellwagstaff\/?hl=en","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":112710,"title":"Benjamin Cliff","short_name":"BM Cliff","first_name":"Benjamin Cliff","last_name":"","middle_name":"","birthdate":"2002-10-23","birthplace":" Halifax, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BenjaminCliff1","instagram_profile":"https:\/\/www.instagram.com\/bencliff23\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":8.5,"facebook_profile":"https:\/\/www.facebook.com\/Ghazanfar050\/","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Afghanistan","role":"bowl","role_str":""},{"pid":120400,"title":"Jafer Chohan","short_name":"JA Chohan","first_name":"Jafer Chohan","last_name":"","middle_name":"","birthdate":"2002-07-11","birthplace":"Camden, Middlesex, England","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/chohanjafar\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":127225,"title":"Yash Vagadia","short_name":"Y Vagadia","first_name":"Yash Vagadia","last_name":"","middle_name":"","birthdate":"2005-01-01","birthplace":" Newcastle","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","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":5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/ha66y2004","instagram_profile":"https:\/\/www.instagram.com\/harrymoore72\/","debut_data":"","bowling_type":"Pace","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":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":141670,"title":"Noah M Kelly","short_name":"N M Kelly","first_name":"Noah M Kelly","last_name":"","middle_name":"","birthdate":"2005-09-21","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":146172,"title":"Alex Wade","short_name":"A Wade","first_name":"Alex Wade","last_name":"","middle_name":"","birthdate":"2006-11-28","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":147420,"title":"Jawad Akhtar","short_name":"J Akhtar","first_name":"Jawad Akhtar","last_name":"","middle_name":"","birthdate":"2005-11-19","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""}]},"etag":"6c03b9b3773885dcd9fe5354b6ee5cbc","modified":"2025-07-15 08:23:27","datetime":"2025-07-15 08:23:27","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":86908,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Derbyshire won by 7 wickets","day_remaining_over":"","team_batting":"Derbyshire","team_bowling":"Yorkshire","live_inning_number":2,"live_score":{"runs":201,"overs":17.2,"wickets":3,"target":201,"runrate":11.6,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Ross Whiteley","batsman_id":43360,"runs":29,"balls_faced":17,"fours":2,"sixes":2,"strike_rate":"170.59"},{"name":"Wayne Madsen","batsman_id":48641,"runs":38,"balls_faced":25,"fours":7,"sixes":0,"strike_rate":"152.00"}],"bowlers":[{"name":"Jordan Thompson","bowler_id":50507,"overs":3.2,"runs_conceded":28,"wickets":0,"maidens":0,"econ":"8.40"},{"name":"William O\u2019Rourke","bowler_id":96733,"overs":4,"runs_conceded":50,"wickets":1,"maidens":0,"econ":"12.50"}],"commentaries":[{"event_id":"12296467","event":"ball","batsman_id":"43360","bowler_id":"50507","over":"13","ball":"1","score":1,"commentary":"Jordan Thompson to Ross Whiteley, 1 run,","noball_dismissal":false,"text":"","timestamp":1751818741,"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":"12296470","event":"ball","batsman_id":"48641","bowler_id":"50507","over":"13","ball":"2","score":1,"commentary":"Jordan Thompson to Wayne Madsen, 1 run,","noball_dismissal":false,"text":"","timestamp":1751818743,"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":"12296478","event":"ball","batsman_id":"43360","bowler_id":"50507","over":"13","ball":"3","score":0,"commentary":"Jordan Thompson to Ross Whiteley, no run,","noball_dismissal":false,"text":"","timestamp":1751818751,"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":"12296492","event":"ball","batsman_id":"43360","bowler_id":"50507","over":"13","ball":"4","score":1,"commentary":"Jordan Thompson to Ross Whiteley, 1 run,","noball_dismissal":false,"text":"","timestamp":1751818753,"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":"12296496","event":"ball","batsman_id":"48641","bowler_id":"50507","over":"13","ball":"5","score":1,"commentary":"Jordan Thompson to Wayne Madsen, 1 run,","noball_dismissal":false,"text":"","timestamp":1751818755,"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":"12296497","event":"ball","batsman_id":"43360","bowler_id":"50507","over":"13","ball":"6","score":"1wd","commentary":"Jordan Thompson to Ross Whiteley, 1 wide,","noball_dismissal":false,"text":"","timestamp":1751818758,"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":"12296498","event":"ball","batsman_id":"43360","bowler_id":"50507","over":"13","ball":"6","score":2,"commentary":"Jordan Thompson to Ross Whiteley, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751818760,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":14,"runs":7,"score":"165\/3","bats":[{"runs":10,"balls_faced":9,"fours":1,"sixes":0,"batsman_id":43360},{"runs":21,"balls_faced":13,"fours":4,"sixes":0,"batsman_id":48641}],"bowls":[{"runs_conceded":18,"maidens":0,"wickets":0,"bowler_id":50507,"overs":3},{"runs_conceded":29,"maidens":0,"wickets":0,"bowler_id":50392,"overs":2}],"commentary":"End of over 14 (7 runs), Derbyshire 165\/3"},{"event_id":"12296502","event":"ball","batsman_id":"48641","bowler_id":"57644","over":"14","ball":"1","score":0,"commentary":"Matt Milnes to Wayne Madsen, no run,","noball_dismissal":false,"text":"","timestamp":1751818790,"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":"12296503","event":"ball","batsman_id":"48641","bowler_id":"57644","over":"14","ball":"2","score":4,"commentary":"Matt Milnes to Wayne Madsen, Four,","noball_dismissal":false,"text":"","timestamp":1751818798,"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":"12296504","event":"ball","batsman_id":"48641","bowler_id":"57644","over":"14","ball":"3","score":4,"commentary":"Matt Milnes to Wayne Madsen, Four,","noball_dismissal":false,"text":"","timestamp":1751818800,"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":"12296505","event":"ball","batsman_id":"48641","bowler_id":"57644","over":"14","ball":"4","score":1,"commentary":"Matt Milnes to Wayne Madsen, 1 run,","noball_dismissal":false,"text":"","timestamp":1751818802,"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":"12296507","event":"ball","batsman_id":"43360","bowler_id":"57644","over":"14","ball":"5","score":6,"commentary":"Matt Milnes to Ross Whiteley, Six,","noball_dismissal":false,"text":"","timestamp":1751818829,"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":"12296510","event":"ball","batsman_id":"43360","bowler_id":"57644","over":"14","ball":"6","score":0,"commentary":"Matt Milnes to Ross Whiteley, no run,","noball_dismissal":false,"text":"","timestamp":1751818836,"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":15,"runs":15,"score":"180\/3","bats":[{"runs":16,"balls_faced":11,"fours":1,"sixes":1,"batsman_id":43360},{"runs":30,"balls_faced":17,"fours":6,"sixes":0,"batsman_id":48641}],"bowls":[{"runs_conceded":35,"maidens":0,"wickets":0,"bowler_id":57644,"overs":3},{"runs_conceded":18,"maidens":0,"wickets":0,"bowler_id":50507,"overs":3}],"commentary":"End of over 15 (15 runs), Derbyshire 180\/3"},{"event_id":"12296516","event":"ball","batsman_id":"48641","bowler_id":"93358","over":"15","ball":"1","score":1,"commentary":"Will Sutherland to Wayne Madsen, 1 run,","noball_dismissal":false,"text":"","timestamp":1751818875,"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":"12296518","event":"ball","batsman_id":"43360","bowler_id":"93358","over":"15","ball":"2","score":1,"commentary":"Will Sutherland to Ross Whiteley, 1 run,","noball_dismissal":false,"text":"","timestamp":1751818877,"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":"12296523","event":"ball","batsman_id":"48641","bowler_id":"93358","over":"15","ball":"3","score":0,"commentary":"Will Sutherland to Wayne Madsen, no run,","noball_dismissal":false,"text":"","timestamp":1751818880,"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":"12296525","event":"ball","batsman_id":"48641","bowler_id":"93358","over":"15","ball":"4","score":1,"commentary":"Will Sutherland to Wayne Madsen, 1 run,","noball_dismissal":false,"text":"","timestamp":1751818882,"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":"12296529","event":"ball","batsman_id":"43360","bowler_id":"93358","over":"15","ball":"5","score":1,"commentary":"Will Sutherland to Ross Whiteley, 1 run,","noball_dismissal":false,"text":"","timestamp":1751818893,"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":"12296532","event":"ball","batsman_id":"48641","bowler_id":"93358","over":"15","ball":"6","score":1,"commentary":"Will Sutherland to Wayne Madsen, 1 run,","noball_dismissal":false,"text":"","timestamp":1751818904,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":16,"runs":5,"score":"185\/3","bats":[{"runs":33,"balls_faced":21,"fours":6,"sixes":0,"batsman_id":48641},{"runs":18,"balls_faced":13,"fours":1,"sixes":1,"batsman_id":43360}],"bowls":[{"runs_conceded":16,"maidens":0,"wickets":1,"bowler_id":93358,"overs":3},{"runs_conceded":35,"maidens":0,"wickets":0,"bowler_id":57644,"overs":3}],"commentary":"End of over 16 (5 runs), Derbyshire 185\/3"},{"event_id":"12296604","event":"ball","batsman_id":"48641","bowler_id":"96733","over":"16","ball":"1","score":0,"commentary":"William O\u2019Rourke to Wayne Madsen, no run,","noball_dismissal":false,"text":"","timestamp":1751819215,"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":"12296606","event":"ball","batsman_id":"48641","bowler_id":"96733","over":"16","ball":"2","score":4,"commentary":"William O\u2019Rourke to Wayne Madsen, Four,","noball_dismissal":false,"text":"","timestamp":1751819247,"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":"12296607","event":"ball","batsman_id":"48641","bowler_id":"96733","over":"16","ball":"3","score":0,"commentary":"William O\u2019Rourke to Wayne Madsen, no run,","noball_dismissal":false,"text":"","timestamp":1751819250,"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":"12296610","event":"ball","batsman_id":"48641","bowler_id":"96733","over":"16","ball":"4","score":1,"commentary":"William O\u2019Rourke to Wayne Madsen, 1 run,","noball_dismissal":false,"text":"","timestamp":1751819252,"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":"12296613","event":"ball","batsman_id":"43360","bowler_id":"96733","over":"16","ball":"5","score":0,"commentary":"William O\u2019Rourke to Ross Whiteley, no run,","noball_dismissal":false,"text":"","timestamp":1751819254,"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":"12296616","event":"ball","batsman_id":"43360","bowler_id":"96733","over":"16","ball":"6","score":1,"commentary":"William O\u2019Rourke to Ross Whiteley, 1 run,","noball_dismissal":false,"text":"","timestamp":1751819257,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":17,"runs":6,"score":"191\/3","bats":[{"runs":19,"balls_faced":15,"fours":1,"sixes":1,"batsman_id":43360},{"runs":38,"balls_faced":25,"fours":7,"sixes":0,"batsman_id":48641}],"bowls":[{"runs_conceded":61,"maidens":0,"wickets":1,"bowler_id":96733,"overs":4},{"runs_conceded":16,"maidens":0,"wickets":1,"bowler_id":93358,"overs":3}],"commentary":"End of over 17 (6 runs), Derbyshire 191\/3"},{"event_id":"12296620","event":"ball","batsman_id":"43360","bowler_id":"50507","over":"17","ball":"1","score":6,"commentary":"Jordan Thompson to Ross Whiteley, Six,","noball_dismissal":false,"text":"","timestamp":1751819259,"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":"12296621","event":"ball","batsman_id":"43360","bowler_id":"50507","over":"17","ball":"2","score":4,"commentary":"Jordan Thompson to Ross Whiteley, Four,","noball_dismissal":false,"text":"","timestamp":1751819261,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false}],"day":"0","session":"0","live_inning":{"iid":199217,"number":2,"name":"Derbyshire Inning","short_name":"DER Inning","status":2,"issuperover":"false","result":3,"batting_team_id":104949,"fielding_team_id":7050,"scores":"201\/3","scores_full":"201\/3 (17.2 ov)","fielder":[{"fielder_id":"102295","fielder_name":"James Wharton","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"96733","fielder_name":"William O\u2019Rourke","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"50392","fielder_name":"Dom Bess","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Samit Patel","batsman_id":"10594","runs":"6","balls":"6","how_out":"c Dom Bess b WO Rourke","score_at_dismissal":141,"overs_at_dismissal":"11.4","bowler_id":"96733","dismissal":"caught","number":3},"extra_runs":{"byes":0,"legbyes":4,"wides":8,"noballs":0,"penalty":"0","total":12},"equations":{"runs":201,"wickets":3,"overs":"17.2","bowlers_used":6,"runrate":"11.60"},"current_partnership":{"runs":60,"balls":34,"overs":5.4,"batsmen":[{"name":"Ross Whiteley","batsman_id":43360,"runs":29,"balls":17},{"name":"Wayne Madsen","batsman_id":48641,"runs":28,"balls":17}]},"did_not_bat":[{"player_id":"94962","name":"Harry Came"},{"player_id":"51064","name":"Martin Andersson"},{"player_id":"50433","name":"Alex Thomson"},{"player_id":"84689","name":"Pat Brown"},{"player_id":"49808","name":"Zak Chappell"},{"player_id":"118504","name":"Allah Mohammad Ghazanfar"}],"max_over":"20","target":"201","recent_scores":"4,6,1,0,1,0,4,0,1,1,1,0,1,1,0,6,1,4","last_five_overs":"53\/0 10.26","last_ten_overs":"104\/3 10.23"},"teams":[{"tid":7050,"title":"Yorkshire","abbr":"YOR","alt_name":"YOR","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/yorkshire-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/yorkshire-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"200\/6 (20 ov)","scores":"200\/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":"201\/3 (17.2 ov)","scores":"201\/3","overs":"17.2"}],"players":[{"pid":99,"title":"Joe Root","short_name":"J Root","first_name":"Joe Root","last_name":"","middle_name":"","birthdate":"1990-12-30","birthplace":"Sheffield, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":18968,"recent_appearance":1514244600,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/JoeRootOfficial\/","twitter_profile":"https:\/\/twitter.com\/root66","instagram_profile":"https:\/\/www.instagram.com\/root66\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"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":8,"facebook_profile":"https:\/\/www.facebook.com\/aneurin.donald\/","twitter_profile":"https:\/\/twitter.com\/AneurinDonald12","instagram_profile":"https:\/\/www.instagram.com\/aneurindonald\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":1933,"title":"Adil Rashid","short_name":"A Rashid","first_name":"Adil Rashid","last_name":"","middle_name":"","birthdate":"1988-02-17","birthplace":" Bradford, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/AdilRashid95\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/adilrashid\/","debut_data":"","bowling_type":"Spin","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":"bat","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\/davidlloyduk\/","debut_data":"","bowling_type":"Pace","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":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/samitpatel","instagram_profile":"https:\/\/www.instagram.com\/samit._.patel\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":"(C)"},{"pid":10610,"title":"Adam Lyth","short_name":"A Lyth","first_name":"Adam Lyth","last_name":"","middle_name":"","birthdate":"1987-09-25","birthplace":"Whitby, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/lythy09\/","twitter_profile":"https:\/\/twitter.com\/lythy09","instagram_profile":"https:\/\/www.instagram.com\/lythy09\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":43358,"title":"Dawid Malan","short_name":"D Malan","first_name":"Dawid Malan","last_name":"","middle_name":"","birthdate":"1987-09-03","birthplace":"Roehampton, England","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":9,"facebook_profile":"https:\/\/www.facebook.com\/D.Malanofficial\/","twitter_profile":"https:\/\/twitter.com\/dmalan29","instagram_profile":"https:\/\/www.instagram.com\/djmalan29\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"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":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/RossWhiteley44","instagram_profile":"https:\/\/www.instagram.com\/rosswhiteley44\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":44100,"title":"Jonny Bairstow","short_name":"J Bairstow","first_name":"Jonny Bairstow","last_name":"","middle_name":"","birthdate":"1989-09-26","birthplace":" Bradford, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/jbairstow21\/","twitter_profile":"https:\/\/twitter.com\/jbairstow21","instagram_profile":"https:\/\/www.instagram.com\/jbairstow21\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":45911,"title":"Daniel Moriarty","short_name":"DT Moriarty","first_name":"Daniel Moriarty","last_name":"","middle_name":"","birthdate":"1999-12-02","birthplace":"Reigate, Surrey","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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","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":7,"facebook_profile":"https:\/\/www.facebook.com\/blair.tickner\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/ticks93\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","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":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lreece17","instagram_profile":"https:\/\/www.instagram.com\/louisreece\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":48449,"title":"Ben Coad","short_name":"BO Coad","first_name":"Ben Coad","last_name":"","middle_name":"","birthdate":"1994-01-10","birthplace":"Harrogate, Yorkshire","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\/BenCoad10","instagram_profile":"https:\/\/www.instagram.com\/bencoad10\/","debut_data":"","bowling_type":"Pace","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":"","bowling_type":"","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/guesty211\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"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":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/waynemadders77","instagram_profile":"https:\/\/www.instagram.com\/waynemadsen77\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/chappooo","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":50392,"title":"Dom Bess","short_name":"Dom Bess","first_name":"Dom Bess","last_name":"","middle_name":"","birthdate":"1997-07-22","birthplace":"Exeter, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/dombess99\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","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":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/alextomo","instagram_profile":"https:\/\/www.instagram.com\/alex_thomson_racing\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":50505,"title":"Jonathan Tattersall","short_name":"JA Tattersall","first_name":"Jonathan Tattersall","last_name":"","middle_name":"","birthdate":"1994-12-15","birthplace":" Harrogate, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50507,"title":"Jordan Thompson","short_name":"JA Thompson","first_name":"Jordan Thompson","last_name":"","middle_name":"","birthdate":"1996-10-09","birthplace":"Leeds, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Tommo455","instagram_profile":"https:\/\/www.instagram.com\/jordan.a.thompson\/","debut_data":"","bowling_type":"Pace","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":5.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/AnujDal","instagram_profile":"https:\/\/www.instagram.com\/anujdal0\/","debut_data":"","bowling_type":"Pace","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":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/fynnhudson33","instagram_profile":"https:\/\/www.instagram.com\/fynnhudson33\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/MartinAnderss11","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":57644,"title":"Matt Milnes","short_name":"M Milnes","first_name":"Matt Milnes","last_name":"","middle_name":"","birthdate":"1994-07-29","birthplace":" Nottingham","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/mmilnes84","instagram_profile":"https:\/\/www.instagram.com\/matt_milnes\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":61872,"title":"Jack White","short_name":"cJ White","first_name":"Jack White","last_name":"","middle_name":"","birthdate":"1992-02-19","birthplace":" Kendal","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/patbrowny\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":90887,"title":"Harry Brook","short_name":"H Brook","first_name":"Harry Brook","last_name":"","middle_name":"","birthdate":"1999-02-22","birthplace":"Keighley, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/HarryBroook\/","twitter_profile":"https:\/\/twitter.com\/Harry_Brook_88","instagram_profile":"https:\/\/www.instagram.com\/harry_brook88\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":93358,"title":"Will Sutherland","short_name":"W Sutherland","first_name":"Will Sutherland","last_name":"","middle_name":"","birthdate":"1999-10-27","birthplace":"Melbourne, Australia","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":23792,"recent_appearance":1515891600,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/will_suth12","instagram_profile":"https:\/\/www.instagram.com\/willsutherland12\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"all","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":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/HarryCame4","instagram_profile":"https:\/\/www.instagram.com\/harrycame4\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95555,"title":"George Hill","short_name":"G Hill","first_name":"George Hill","last_name":"","middle_name":"","birthdate":"2001-01-24","birthplace":"Keighley, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95593,"title":"Finlay Bean","short_name":"F Bean","first_name":"Finlay Bean","last_name":"","middle_name":"","birthdate":"2002-04-16","birthplace":" Harrogate, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":96059,"title":"Matthew Revis","short_name":"M Revis","first_name":"Matthew Revis","last_name":"","middle_name":"","birthdate":"2001-11-15","birthplace":" Steeton, Yorkshire","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/matty.revis_\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":96606,"title":"Harry Duke","short_name":"H Duke","first_name":"Harry Duke","last_name":"","middle_name":"","birthdate":"2001-09-01","birthplace":"Pinderfields, Wakefield","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":96733,"title":"William O\u2019Rourke","short_name":"WO Rourke","first_name":"William O\u2019Rourke","last_name":"","middle_name":"","birthdate":"2001-08-06","birthplace":"Surrey","country":"nz","primary_team":{"tid":1068,"name":"","short_name":""},"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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/willorourke_\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bowl","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":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Benaitchison123","instagram_profile":"https:\/\/www.instagram.com\/baitchison13\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":102295,"title":"James Wharton","short_name":"J Wharton","first_name":"James Wharton","last_name":"","middle_name":"","birthdate":"2001-02-01","birthplace":" Huddersfield","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":109356,"title":"William Luxton","short_name":"W Luxton","first_name":"William Luxton","last_name":"","middle_name":"","birthdate":"2003-05-06","birthplace":"Keighley, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","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":5.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/mitchellwaggy?lang=en","instagram_profile":"https:\/\/www.instagram.com\/mitchellwagstaff\/?hl=en","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":112710,"title":"Benjamin Cliff","short_name":"BM Cliff","first_name":"Benjamin Cliff","last_name":"","middle_name":"","birthdate":"2002-10-23","birthplace":" Halifax, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BenjaminCliff1","instagram_profile":"https:\/\/www.instagram.com\/bencliff23\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":8.5,"facebook_profile":"https:\/\/www.facebook.com\/Ghazanfar050\/","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Afghanistan","role":"bowl","role_str":""},{"pid":120400,"title":"Jafer Chohan","short_name":"JA Chohan","first_name":"Jafer Chohan","last_name":"","middle_name":"","birthdate":"2002-07-11","birthplace":"Camden, Middlesex, England","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/chohanjafar\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":127225,"title":"Yash Vagadia","short_name":"Y Vagadia","first_name":"Yash Vagadia","last_name":"","middle_name":"","birthdate":"2005-01-01","birthplace":" Newcastle","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","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":5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/ha66y2004","instagram_profile":"https:\/\/www.instagram.com\/harrymoore72\/","debut_data":"","bowling_type":"Pace","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":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":141670,"title":"Noah M Kelly","short_name":"N M Kelly","first_name":"Noah M Kelly","last_name":"","middle_name":"","birthdate":"2005-09-21","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":146172,"title":"Alex Wade","short_name":"A Wade","first_name":"Alex Wade","last_name":"","middle_name":"","birthdate":"2006-11-28","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":147420,"title":"Jawad Akhtar","short_name":"J Akhtar","first_name":"Jawad Akhtar","last_name":"","middle_name":"","birthdate":"2005-11-19","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""}]},"etag":"6c03b9b3773885dcd9fe5354b6ee5cbc","modified":"2025-07-15 08:23:27","datetime":"2025-07-15 08:23:27","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86908 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:0e1b136a-02a0-471f-b34b-6750364a6458
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86908 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86908,3,'{"status":"ok","response":{"match_id":86908,"title":"Derbyshire vs Yorkshire","short_title":"DER vs YOR","subtitle":"Match 88","match_number":"88","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Derbyshire won by 7 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129425,"title":"Vitality Blast","abbr":"Vitality Blast","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-09-13","country":"en","total_matches":"133","total_rounds":"2","total_teams":"18"},"teama":{"team_id":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":"201\/3 (17.2 ov)","scores":"201\/3","overs":"17.2"},"teamb":{"team_id":7050,"name":"Yorkshire","short_name":"YOR","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/yorkshire-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/yorkshire-logo.png","scores_full":"200\/6 (20 ov)","scores":"200\/6","overs":"20"},"date_start":"2025-07-06 13:30:00","date_end":"2025-07-06 23:30:00","timestamp_start":1751808600,"timestamp_end":1751844600,"date_start_ist":"2025-07-06 19:00:00","date_end_ist":"2025-07-07 05:00:00","venue":{"venue_id":"232","name":"Queen''s Park","location":"Invercargill","country":"New Zealand","timezone":""},"umpires":"Neil Pratt (England), Steve O''Shaughnessy (England)","referee":"Ian Herbert (England)","equation":"","live":"","result":"DER won by 7 wickets","result_type":1,"win_margin":"7 wickets","winning_team_id":104949,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-07-05 00:17:49","verify_time":"2025-07-06 22:20:51","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"scattered clouds","temp":5.27,"humidity":94,"visibility":10000,"wind_speed":"2.86","clouds":45},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Derbyshire elected to bowl","winner":104949,"decision":2}},"etag":"7a241186561abccfb6cd088bfed4c555","modified":"2025-07-15 08:23:28","datetime":"2025-07-15 08:23:28","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":86908,"title":"Derbyshire vs Yorkshire","short_title":"DER vs YOR","subtitle":"Match 88","match_number":"88","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Derbyshire won by 7 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129425,"title":"Vitality Blast","abbr":"Vitality Blast","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-09-13","country":"en","total_matches":"133","total_rounds":"2","total_teams":"18"},"teama":{"team_id":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":"201\/3 (17.2 ov)","scores":"201\/3","overs":"17.2"},"teamb":{"team_id":7050,"name":"Yorkshire","short_name":"YOR","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/yorkshire-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/yorkshire-logo.png","scores_full":"200\/6 (20 ov)","scores":"200\/6","overs":"20"},"date_start":"2025-07-06 13:30:00","date_end":"2025-07-06 23:30:00","timestamp_start":1751808600,"timestamp_end":1751844600,"date_start_ist":"2025-07-06 19:00:00","date_end_ist":"2025-07-07 05:00:00","venue":{"venue_id":"232","name":"Queen''s Park","location":"Invercargill","country":"New Zealand","timezone":""},"umpires":"Neil Pratt (England), Steve O''Shaughnessy (England)","referee":"Ian Herbert (England)","equation":"","live":"","result":"DER won by 7 wickets","result_type":1,"win_margin":"7 wickets","winning_team_id":104949,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-07-05 00:17:49","verify_time":"2025-07-06 22:20:51","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"scattered clouds","temp":5.27,"humidity":94,"visibility":10000,"wind_speed":"2.86","clouds":45},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Derbyshire elected to bowl","winner":104949,"decision":2}},"etag":"7a241186561abccfb6cd088bfed4c555","modified":"2025-07-15 08:23:28","datetime":"2025-07-15 08:23:28","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86908 AND DataTypeId = 3 END Live Report & Scorecard of Derbyshire vs Yorkshire Match 88
Derbyshire vs Yorkshire, Live Cricket Commentary