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:b55ed4d0-93c8-44bd-8626-fde2313158a0 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86869 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86869,1,'{"status":"ok","response":{"mid":86869,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Warwickshire won by 32 runs","day_remaining_over":"","team_batting":"Yorkshire","team_bowling":"Warwickshire","live_inning_number":2,"live_score":{"runs":173,"overs":20,"wickets":5,"target":206,"runrate":8.65,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"George Hill","batsman_id":95555,"runs":7,"balls_faced":11,"fours":0,"sixes":0,"strike_rate":"63.64"},{"name":"Matthew Revis","batsman_id":96059,"runs":4,"balls_faced":4,"fours":0,"sixes":0,"strike_rate":"100.00"}],"bowlers":[{"name":"Ed Barnard","bowler_id":49041,"overs":3,"runs_conceded":18,"wickets":0,"maidens":0,"econ":"6.00"},{"name":"Hasan Ali","bowler_id":44099,"overs":4,"runs_conceded":32,"wickets":2,"maidens":0,"econ":"8.00"}],"commentaries":[{"event_id":"12137729","event":"ball","batsman_id":"102295","bowler_id":"49480","over":"15","ball":"5","score":"2wd","commentary":"Danny Briggs to James Wharton, 2 wide,","noball_dismissal":false,"text":"","timestamp":1749845361,"run":2,"noball_run":"0","wide_run":"2","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12137733","event":"ball","batsman_id":"93358","bowler_id":"49480","over":"15","ball":"6","score":6,"commentary":"Danny Briggs to Will Sutherland, Six,","noball_dismissal":false,"text":"","timestamp":1749845392,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event":"overend","over":16,"runs":11,"score":"152\/3","bats":[{"runs":21,"balls_faced":14,"fours":1,"sixes":2,"batsman_id":93358},{"runs":27,"balls_faced":23,"fours":2,"sixes":1,"batsman_id":102295}],"bowls":[{"runs_conceded":43,"maidens":0,"wickets":1,"bowler_id":49480,"overs":4},{"runs_conceded":30,"maidens":0,"wickets":1,"bowler_id":44099,"overs":3}],"commentary":"End of over 16 (11 runs), Yorkshire 152\/3"},{"event_id":"12137817","event":"ball","batsman_id":"102295","bowler_id":"95543","over":"16","ball":"1","score":1,"commentary":"Dan Mousley to James Wharton, 1 run,","noball_dismissal":false,"text":"","timestamp":1749845396,"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":"12137822","event":"wicket","batsman_id":"93358","bowler_id":"95543","over":"16","ball":"2","score":"w","commentary":"Dan Mousley to Will Sutherland, no run, c SR Hain b D Mousley,","noball_dismissal":false,"text":"","timestamp":1749845398,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"93358","how_out":"c SR Hain b D Mousley","batsman_runs":"20","batsman_balls":"14"},{"event_id":"12137827","event":"ball","batsman_id":"95555","bowler_id":"95543","over":"16","ball":"3","score":1,"commentary":"Dan Mousley to George Hill, 1 run,","noball_dismissal":false,"text":"","timestamp":1749845436,"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":"12137828","event":"ball","batsman_id":"102295","bowler_id":"95543","over":"16","ball":"4","score":4,"commentary":"Dan Mousley to James Wharton, Four,","noball_dismissal":false,"text":"","timestamp":1749845438,"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":"12137830","event":"ball","batsman_id":"102295","bowler_id":"95543","over":"16","ball":"5","score":1,"commentary":"Dan Mousley to James Wharton, 1 run,","noball_dismissal":false,"text":"","timestamp":1749845441,"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":"12137831","event":"ball","batsman_id":"95555","bowler_id":"95543","over":"16","ball":"6","score":0,"commentary":"Dan Mousley to George Hill, no run,","noball_dismissal":false,"text":"","timestamp":1749845443,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":17,"runs":7,"score":"159\/4","bats":[{"runs":1,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":95555},{"runs":33,"balls_faced":26,"fours":3,"sixes":1,"batsman_id":102295}],"bowls":[{"runs_conceded":26,"maidens":0,"wickets":1,"bowler_id":95543,"overs":4},{"runs_conceded":43,"maidens":0,"wickets":1,"bowler_id":49480,"overs":4}],"commentary":"End of over 17 (7 runs), Yorkshire 159\/4"},{"event_id":"12137834","event":"ball","batsman_id":"102295","bowler_id":"49041","over":"17","ball":"1","score":1,"commentary":"Ed Barnard to James Wharton, 1 run,","noball_dismissal":false,"text":"","timestamp":1749845446,"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":"12137835","event":"ball","batsman_id":"95555","bowler_id":"49041","over":"17","ball":"2","score":1,"commentary":"Ed Barnard to George Hill, 1 run,","noball_dismissal":false,"text":"","timestamp":1749845448,"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":"12137836","event":"ball","batsman_id":"102295","bowler_id":"49041","over":"17","ball":"3","score":1,"commentary":"Ed Barnard to James Wharton, 1 run,","noball_dismissal":false,"text":"","timestamp":1749845451,"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":"12137840","event":"ball","batsman_id":"95555","bowler_id":"49041","over":"17","ball":"4","score":1,"commentary":"Ed Barnard to George Hill, 1 run,","noball_dismissal":false,"text":"","timestamp":1749845541,"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":"12137862","event":"ball","batsman_id":"102295","bowler_id":"49041","over":"17","ball":"5","score":1,"commentary":"Ed Barnard to James Wharton, 1 run,","noball_dismissal":false,"text":"","timestamp":1749845571,"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":"12137871","event":"ball","batsman_id":"95555","bowler_id":"49041","over":"17","ball":"6","score":1,"commentary":"Ed Barnard to George Hill, 1 run,","noball_dismissal":false,"text":"","timestamp":1749845680,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":18,"runs":6,"score":"165\/4","bats":[{"runs":4,"balls_faced":5,"fours":0,"sixes":0,"batsman_id":95555},{"runs":36,"balls_faced":29,"fours":3,"sixes":1,"batsman_id":102295}],"bowls":[{"runs_conceded":13,"maidens":0,"wickets":0,"bowler_id":49041,"overs":2},{"runs_conceded":26,"maidens":0,"wickets":1,"bowler_id":95543,"overs":4}],"commentary":"End of over 18 (6 runs), Yorkshire 165\/4"},{"event_id":"12137883","event":"ball","batsman_id":"95555","bowler_id":"44099","over":"18","ball":"1","score":0,"commentary":"Hasan Ali to George Hill, no run,","noball_dismissal":false,"text":"","timestamp":1749845789,"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":"12137885","event":"ball","batsman_id":"95555","bowler_id":"44099","over":"18","ball":"2","score":0,"commentary":"Hasan Ali to George Hill, no run,","noball_dismissal":false,"text":"","timestamp":1749845792,"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":"12137901","event":"ball","batsman_id":"95555","bowler_id":"44099","over":"18","ball":"3","score":1,"commentary":"Hasan Ali to George Hill, 1 run,","noball_dismissal":false,"text":"","timestamp":1749845960,"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":"12137906","event":"ball","batsman_id":"102295","bowler_id":"44099","over":"18","ball":"4","score":0,"commentary":"Hasan Ali to James Wharton, no run,","noball_dismissal":false,"text":"","timestamp":1749845962,"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":"12137941","event":"wicket","batsman_id":"102295","bowler_id":"44099","over":"18","ball":"5","score":"w","commentary":"Hasan Ali to James Wharton, no run, c G Garton b H Ali,","noball_dismissal":false,"text":"","timestamp":1749845965,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"102295","how_out":"c G Garton b H Ali","batsman_runs":"37","batsman_balls":"32"},{"event_id":"12137945","event":"ball","batsman_id":"96059","bowler_id":"44099","over":"18","ball":"6","score":1,"commentary":"Hasan Ali to Matthew Revis, 1 run,","noball_dismissal":false,"text":"","timestamp":1749846004,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":19,"runs":2,"score":"167\/5","bats":[{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":96059},{"runs":5,"balls_faced":8,"fours":0,"sixes":0,"batsman_id":95555}],"bowls":[{"runs_conceded":32,"maidens":0,"wickets":2,"bowler_id":44099,"overs":4},{"runs_conceded":13,"maidens":0,"wickets":0,"bowler_id":49041,"overs":2}],"commentary":"End of over 19 (2 runs), Yorkshire 167\/5"},{"event_id":"12137947","event":"ball","batsman_id":"96059","bowler_id":"49041","over":"19","ball":"1","score":"1lb","commentary":"Ed Barnard to Matthew Revis, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1749846010,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"1","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12137949","event":"ball","batsman_id":"95555","bowler_id":"49041","over":"19","ball":"2","score":1,"commentary":"Ed Barnard to George Hill, 1 run,","noball_dismissal":false,"text":"","timestamp":1749846012,"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":"12137950","event":"ball","batsman_id":"96059","bowler_id":"49041","over":"19","ball":"3","score":2,"commentary":"Ed Barnard to Matthew Revis, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749846014,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12137951","event":"ball","batsman_id":"96059","bowler_id":"49041","over":"19","ball":"4","score":1,"commentary":"Ed Barnard to Matthew Revis, 1 run,","noball_dismissal":false,"text":"","timestamp":1749846051,"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":"12137959","event":"ball","batsman_id":"95555","bowler_id":"49041","over":"19","ball":"5","score":0,"commentary":"Ed Barnard to George Hill, no run,","noball_dismissal":false,"text":"","timestamp":1749846080,"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":"12137965","event":"ball","batsman_id":"95555","bowler_id":"49041","over":"19","ball":"6","score":1,"commentary":"Ed Barnard to George Hill, 1 run,","noball_dismissal":false,"text":"","timestamp":1749846086,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":20,"runs":6,"score":"173\/5","bats":[{"runs":7,"balls_faced":11,"fours":0,"sixes":0,"batsman_id":95555},{"runs":4,"balls_faced":4,"fours":0,"sixes":0,"batsman_id":96059}],"bowls":[{"runs_conceded":18,"maidens":0,"wickets":0,"bowler_id":49041,"overs":3},{"runs_conceded":32,"maidens":0,"wickets":2,"bowler_id":44099,"overs":4}],"commentary":"End of over 20 (6 runs), Yorkshire 173\/5"}],"day":"0","session":"0","live_inning":{"iid":198003,"number":2,"name":"Yorkshire Inning","short_name":"YOR Inning","status":2,"issuperover":"false","result":4,"batting_team_id":7050,"fielding_team_id":7002,"scores":"173\/5","scores_full":"173\/5 (20 ov)","fielder":[{"fielder_id":"93","fielder_name":"Moeen Ali","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"44099","fielder_name":"Hasan Ali","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"1384","fielder_name":"George Garton","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"49025","fielder_name":"Sam Hain","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":"James Wharton","batsman_id":"102295","runs":"37","balls":"32","how_out":"c G Garton b H Ali","score_at_dismissal":166,"overs_at_dismissal":"18.5","bowler_id":"44099","dismissal":"caught","number":5},"extra_runs":{"byes":1,"legbyes":2,"wides":5,"noballs":0,"penalty":"0","total":8},"equations":{"runs":173,"wickets":5,"overs":"20","bowlers_used":7,"runrate":"8.65"},"current_partnership":{"runs":7,"balls":7,"overs":1.1,"batsmen":[{"name":"Matthew Revis","batsman_id":96059,"runs":4,"balls":4},{"name":"George Hill","batsman_id":95555,"runs":2,"balls":3}]},"did_not_bat":[{"player_id":"50392","name":"Dom Bess"},{"player_id":"120400","name":"Jafer Chohan"},{"player_id":"96733","name":"William O''Rourke"},{"player_id":"61872","name":"Jack White"}],"max_over":"20","target":"206","recent_scores":"1,0,1,2,1,1,1,w,0,1,0,0,1,1,1,1,1,1","last_five_overs":"32\/2 6.19","last_ten_overs":"92\/3 8.76"},"teams":[{"tid":7002,"title":"Warwickshire","abbr":"WAS","alt_name":"Warwickshire","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Warwickshire.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Warwickshire.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"205\/8 (20 ov)","scores":"205\/8","overs":"20"},{"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":"173\/5 (20 ov)","scores":"173\/5","overs":"20"}],"players":[{"pid":93,"title":"Moeen Ali","short_name":"M Ali","first_name":"Moeen Ali","last_name":"","middle_name":"","birthdate":"1987-06-18","birthplace":"Birmingham","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/moeenmunirali\/","twitter_profile":"https:\/\/twitter.com\/MoeenaliAli","instagram_profile":"https:\/\/www.instagram.com\/moeenmunirali\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"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":8,"facebook_profile":"https:\/\/www.facebook.com\/JoeRootOfficial\/","twitter_profile":"https:\/\/twitter.com\/root66","instagram_profile":"https:\/\/www.instagram.com\/root66\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":107,"title":"Chris Woakes","short_name":"C Woakes","first_name":"Chris Woakes","last_name":"","middle_name":"","birthdate":"1989-03-02","birthplace":"Birmingham, Warwickshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/chriswoakes\/","twitter_profile":"https:\/\/twitter.com\/chriswoakes","instagram_profile":"https:\/\/www.instagram.com\/chriswoakes\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":1384,"title":"George Garton","short_name":"G Garton","first_name":"George Garton","last_name":"","middle_name":"","birthdate":"1997-04-15","birthplace":"Brighton, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/george_garton","instagram_profile":"https:\/\/www.instagram.com\/georgegarton\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"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.5,"facebook_profile":"https:\/\/www.facebook.com\/AdilRashid95\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/adilrashid\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"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":7.5,"facebook_profile":"https:\/\/www.facebook.com\/lythy09\/","twitter_profile":"https:\/\/twitter.com\/lythy09","instagram_profile":"https:\/\/www.instagram.com\/lythy09\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"pid":44099,"title":"Hasan Ali","short_name":"H Ali","first_name":"Hasan Ali","last_name":"","middle_name":"","birthdate":"1994-07-02","birthplace":"Gujranwala, Punjab","country":"pk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/Realhassan32\/","twitter_profile":"https:\/\/twitter.com\/RealHa55an","instagram_profile":"https:\/\/www.instagram.com\/ha55an_ali\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bowl","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":44185,"title":"Tom Latham","short_name":"T Latham","first_name":"Tom Latham","last_name":"","middle_name":"","birthdate":"1992-04-02","birthplace":"Christchurch, Canterbury","country":"nz","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"wicket keeper","recent_match":23991,"recent_appearance":1513980000,"fantasy_player_rating":7,"facebook_profile":"https:\/\/www.facebook.com\/tomlathamofficial","twitter_profile":"https:\/\/twitter.com\/Tomlatham2","instagram_profile":"https:\/\/www.instagram.com\/tomlatham2\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"wk","role_str":""},{"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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":48430,"title":"Alex Davies","short_name":"AL Davies","first_name":"Alex Davies","last_name":"","middle_name":"","birthdate":"1994-08-23","birthplace":"Darwen, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/aldavies23\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK\/C)"},{"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":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BenCoad10","instagram_profile":"https:\/\/www.instagram.com\/bencoad10\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49017,"title":"Oliver Hannon-Dalby","short_name":"OJ Hannon-Dalby","first_name":"Oliver Hannon-Dalby","last_name":"","middle_name":"","birthdate":"1989-06-20","birthplace":" Halifax, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49025,"title":"Sam Hain","short_name":"SR Hain","first_name":"Sam Hain","last_name":"","middle_name":"","birthdate":"1995-07-16","birthplace":"Hong Kong","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/SammieHain","instagram_profile":"https:\/\/www.instagram.com\/sammiehain","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":49041,"title":"Ed Barnard","short_name":"EG Barnard","first_name":"Ed Barnard","last_name":"","middle_name":"","birthdate":"1995-11-20","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":49320,"title":"Chris Rushworth","short_name":"C Rushworth","first_name":"Chris Rushworth","last_name":"","middle_name":"","birthdate":"1986-07-11","birthplace":"Sunderland","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49480,"title":"Danny Briggs","short_name":"DR Briggs","first_name":"Danny Briggs","last_name":"","middle_name":"","birthdate":"1991-04-30","birthplace":" Newport, Isle of Wight","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/DannyBriggs_14","instagram_profile":"https:\/\/www.instagram.com\/dannybriggs14\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":49530,"title":"Craig Miles","short_name":"CN Miles","first_name":"Craig Miles","last_name":"","middle_name":"","birthdate":"1994-07-20","birthplace":"Swindon, Wiltshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/CMiles_18","instagram_profile":"https:\/\/www.instagram.com\/cmiles18\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":"","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Tommo455","instagram_profile":"https:\/\/www.instagram.com\/jordan.a.thompson\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50945,"title":"Richard Gleeson","short_name":"RJ Gleeson","first_name":"Richard Gleeson","last_name":"","middle_name":"","birthdate":"1987-12-02","birthplace":" Blackpool, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/RicGleeson","instagram_profile":"https:\/\/www.instagram.com\/rgleeson33\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":53626,"title":"Beau Webster","short_name":"BJ Webster","first_name":"Beau Webster","last_name":"","middle_name":"","birthdate":"1993-12-01","birthplace":"Snug, Hobart, Tasmania","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","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":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/mmilnes84","instagram_profile":"https:\/\/www.instagram.com\/matt_milnes\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":88689,"title":"Zen Malik","short_name":"Z Malik","first_name":"Zen Malik","last_name":"","middle_name":"","birthdate":"1998-04-09","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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.5,"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":"","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.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/will_suth12","instagram_profile":"https:\/\/www.instagram.com\/willsutherland12\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"all","role_str":""},{"pid":93516,"title":"Ethan Bamber","short_name":"ER Bamber","first_name":"Ethan Bamber","last_name":"","middle_name":"","birthdate":"1998-12-17","birthplace":"Westminster, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/etbamber","instagram_profile":"https:\/\/www.instagram.com\/etbamber\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":94952,"title":"Kai Smith","short_name":"K Smith","first_name":"Kai Smith","last_name":"","middle_name":"","birthdate":"2004-11-28","birthplace":" Dubai, United Arab Emirates","country":"ae","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"bat","role_str":""},{"pid":95003,"title":"Robert Yates","short_name":"RM Yates","first_name":"Robert Yates","last_name":"","middle_name":"","birthdate":"1999-09-19","birthplace":"Solihull, Warwickshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95543,"title":"Dan Mousley","short_name":"D Mousley","first_name":"Dan Mousley","last_name":"","middle_name":"","birthdate":"2001-07-08","birthplace":"Birmingham, Warwickshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/danmousley80","instagram_profile":"https:\/\/www.instagram.com\/danmousley80\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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":"","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":96733,"title":"William O''Rourke","short_name":"WO Rourke","first_name":"William O''Rourke","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/willorourke_\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bowl","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":102808,"title":"Jake Lintott","short_name":"J Lintott","first_name":"Jake Lintott","last_name":"","middle_name":"","birthdate":"1993-04-22","birthplace":"Taunton, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Wrist Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lintott23","instagram_profile":"https:\/\/www.instagram.com\/lintott23\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":108388,"title":"Jacob Bethell","short_name":"J Bethell","first_name":"Jacob Bethell","last_name":"","middle_name":"","birthdate":"2003-10-23","birthplace":"Barbados","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BethellJacob","instagram_profile":"https:\/\/www.instagram.com\/jacob.bethell\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108389,"title":"Che Simmons","short_name":"C Simmons","first_name":"Che Simmons","last_name":"","middle_name":"","birthdate":"2003-12-18","birthplace":"Birmingham, England","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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":"bat","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(WK)"},{"pid":109583,"title":"Hamza Shaikh","short_name":"H Shaikh","first_name":"Hamza Shaikh","last_name":"","middle_name":"","birthdate":"2006-05-29","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":110496,"title":"Tazeem Ali","short_name":"T Ali","first_name":"Tazeem Ali","last_name":"","middle_name":"","birthdate":"2006-06-13","birthplace":"","country":"nl","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Netherlands","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":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BenjaminCliff1","instagram_profile":"https:\/\/www.instagram.com\/bencliff23\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":119917,"title":"Adam Sylvester","short_name":"A Sylvester","first_name":"Adam Sylvester","last_name":"","middle_name":"","birthdate":"2000-05-18","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/chohanjafar\/","debut_data":"","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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":"","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":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":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":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""}]},"etag":"8ce6d5abfa322ebbf19b53c8c0cf78cf","modified":"2025-07-30 13:30:25","datetime":"2025-07-30 13:30:25","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":86869,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Warwickshire won by 32 runs","day_remaining_over":"","team_batting":"Yorkshire","team_bowling":"Warwickshire","live_inning_number":2,"live_score":{"runs":173,"overs":20,"wickets":5,"target":206,"runrate":8.65,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"George Hill","batsman_id":95555,"runs":7,"balls_faced":11,"fours":0,"sixes":0,"strike_rate":"63.64"},{"name":"Matthew Revis","batsman_id":96059,"runs":4,"balls_faced":4,"fours":0,"sixes":0,"strike_rate":"100.00"}],"bowlers":[{"name":"Ed Barnard","bowler_id":49041,"overs":3,"runs_conceded":18,"wickets":0,"maidens":0,"econ":"6.00"},{"name":"Hasan Ali","bowler_id":44099,"overs":4,"runs_conceded":32,"wickets":2,"maidens":0,"econ":"8.00"}],"commentaries":[{"event_id":"12137729","event":"ball","batsman_id":"102295","bowler_id":"49480","over":"15","ball":"5","score":"2wd","commentary":"Danny Briggs to James Wharton, 2 wide,","noball_dismissal":false,"text":"","timestamp":1749845361,"run":2,"noball_run":"0","wide_run":"2","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12137733","event":"ball","batsman_id":"93358","bowler_id":"49480","over":"15","ball":"6","score":6,"commentary":"Danny Briggs to Will Sutherland, Six,","noball_dismissal":false,"text":"","timestamp":1749845392,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event":"overend","over":16,"runs":11,"score":"152\/3","bats":[{"runs":21,"balls_faced":14,"fours":1,"sixes":2,"batsman_id":93358},{"runs":27,"balls_faced":23,"fours":2,"sixes":1,"batsman_id":102295}],"bowls":[{"runs_conceded":43,"maidens":0,"wickets":1,"bowler_id":49480,"overs":4},{"runs_conceded":30,"maidens":0,"wickets":1,"bowler_id":44099,"overs":3}],"commentary":"End of over 16 (11 runs), Yorkshire 152\/3"},{"event_id":"12137817","event":"ball","batsman_id":"102295","bowler_id":"95543","over":"16","ball":"1","score":1,"commentary":"Dan Mousley to James Wharton, 1 run,","noball_dismissal":false,"text":"","timestamp":1749845396,"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":"12137822","event":"wicket","batsman_id":"93358","bowler_id":"95543","over":"16","ball":"2","score":"w","commentary":"Dan Mousley to Will Sutherland, no run, c SR Hain b D Mousley,","noball_dismissal":false,"text":"","timestamp":1749845398,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"93358","how_out":"c SR Hain b D Mousley","batsman_runs":"20","batsman_balls":"14"},{"event_id":"12137827","event":"ball","batsman_id":"95555","bowler_id":"95543","over":"16","ball":"3","score":1,"commentary":"Dan Mousley to George Hill, 1 run,","noball_dismissal":false,"text":"","timestamp":1749845436,"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":"12137828","event":"ball","batsman_id":"102295","bowler_id":"95543","over":"16","ball":"4","score":4,"commentary":"Dan Mousley to James Wharton, Four,","noball_dismissal":false,"text":"","timestamp":1749845438,"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":"12137830","event":"ball","batsman_id":"102295","bowler_id":"95543","over":"16","ball":"5","score":1,"commentary":"Dan Mousley to James Wharton, 1 run,","noball_dismissal":false,"text":"","timestamp":1749845441,"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":"12137831","event":"ball","batsman_id":"95555","bowler_id":"95543","over":"16","ball":"6","score":0,"commentary":"Dan Mousley to George Hill, no run,","noball_dismissal":false,"text":"","timestamp":1749845443,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":17,"runs":7,"score":"159\/4","bats":[{"runs":1,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":95555},{"runs":33,"balls_faced":26,"fours":3,"sixes":1,"batsman_id":102295}],"bowls":[{"runs_conceded":26,"maidens":0,"wickets":1,"bowler_id":95543,"overs":4},{"runs_conceded":43,"maidens":0,"wickets":1,"bowler_id":49480,"overs":4}],"commentary":"End of over 17 (7 runs), Yorkshire 159\/4"},{"event_id":"12137834","event":"ball","batsman_id":"102295","bowler_id":"49041","over":"17","ball":"1","score":1,"commentary":"Ed Barnard to James Wharton, 1 run,","noball_dismissal":false,"text":"","timestamp":1749845446,"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":"12137835","event":"ball","batsman_id":"95555","bowler_id":"49041","over":"17","ball":"2","score":1,"commentary":"Ed Barnard to George Hill, 1 run,","noball_dismissal":false,"text":"","timestamp":1749845448,"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":"12137836","event":"ball","batsman_id":"102295","bowler_id":"49041","over":"17","ball":"3","score":1,"commentary":"Ed Barnard to James Wharton, 1 run,","noball_dismissal":false,"text":"","timestamp":1749845451,"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":"12137840","event":"ball","batsman_id":"95555","bowler_id":"49041","over":"17","ball":"4","score":1,"commentary":"Ed Barnard to George Hill, 1 run,","noball_dismissal":false,"text":"","timestamp":1749845541,"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":"12137862","event":"ball","batsman_id":"102295","bowler_id":"49041","over":"17","ball":"5","score":1,"commentary":"Ed Barnard to James Wharton, 1 run,","noball_dismissal":false,"text":"","timestamp":1749845571,"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":"12137871","event":"ball","batsman_id":"95555","bowler_id":"49041","over":"17","ball":"6","score":1,"commentary":"Ed Barnard to George Hill, 1 run,","noball_dismissal":false,"text":"","timestamp":1749845680,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":18,"runs":6,"score":"165\/4","bats":[{"runs":4,"balls_faced":5,"fours":0,"sixes":0,"batsman_id":95555},{"runs":36,"balls_faced":29,"fours":3,"sixes":1,"batsman_id":102295}],"bowls":[{"runs_conceded":13,"maidens":0,"wickets":0,"bowler_id":49041,"overs":2},{"runs_conceded":26,"maidens":0,"wickets":1,"bowler_id":95543,"overs":4}],"commentary":"End of over 18 (6 runs), Yorkshire 165\/4"},{"event_id":"12137883","event":"ball","batsman_id":"95555","bowler_id":"44099","over":"18","ball":"1","score":0,"commentary":"Hasan Ali to George Hill, no run,","noball_dismissal":false,"text":"","timestamp":1749845789,"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":"12137885","event":"ball","batsman_id":"95555","bowler_id":"44099","over":"18","ball":"2","score":0,"commentary":"Hasan Ali to George Hill, no run,","noball_dismissal":false,"text":"","timestamp":1749845792,"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":"12137901","event":"ball","batsman_id":"95555","bowler_id":"44099","over":"18","ball":"3","score":1,"commentary":"Hasan Ali to George Hill, 1 run,","noball_dismissal":false,"text":"","timestamp":1749845960,"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":"12137906","event":"ball","batsman_id":"102295","bowler_id":"44099","over":"18","ball":"4","score":0,"commentary":"Hasan Ali to James Wharton, no run,","noball_dismissal":false,"text":"","timestamp":1749845962,"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":"12137941","event":"wicket","batsman_id":"102295","bowler_id":"44099","over":"18","ball":"5","score":"w","commentary":"Hasan Ali to James Wharton, no run, c G Garton b H Ali,","noball_dismissal":false,"text":"","timestamp":1749845965,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"102295","how_out":"c G Garton b H Ali","batsman_runs":"37","batsman_balls":"32"},{"event_id":"12137945","event":"ball","batsman_id":"96059","bowler_id":"44099","over":"18","ball":"6","score":1,"commentary":"Hasan Ali to Matthew Revis, 1 run,","noball_dismissal":false,"text":"","timestamp":1749846004,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":19,"runs":2,"score":"167\/5","bats":[{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":96059},{"runs":5,"balls_faced":8,"fours":0,"sixes":0,"batsman_id":95555}],"bowls":[{"runs_conceded":32,"maidens":0,"wickets":2,"bowler_id":44099,"overs":4},{"runs_conceded":13,"maidens":0,"wickets":0,"bowler_id":49041,"overs":2}],"commentary":"End of over 19 (2 runs), Yorkshire 167\/5"},{"event_id":"12137947","event":"ball","batsman_id":"96059","bowler_id":"49041","over":"19","ball":"1","score":"1lb","commentary":"Ed Barnard to Matthew Revis, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1749846010,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"1","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12137949","event":"ball","batsman_id":"95555","bowler_id":"49041","over":"19","ball":"2","score":1,"commentary":"Ed Barnard to George Hill, 1 run,","noball_dismissal":false,"text":"","timestamp":1749846012,"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":"12137950","event":"ball","batsman_id":"96059","bowler_id":"49041","over":"19","ball":"3","score":2,"commentary":"Ed Barnard to Matthew Revis, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749846014,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12137951","event":"ball","batsman_id":"96059","bowler_id":"49041","over":"19","ball":"4","score":1,"commentary":"Ed Barnard to Matthew Revis, 1 run,","noball_dismissal":false,"text":"","timestamp":1749846051,"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":"12137959","event":"ball","batsman_id":"95555","bowler_id":"49041","over":"19","ball":"5","score":0,"commentary":"Ed Barnard to George Hill, no run,","noball_dismissal":false,"text":"","timestamp":1749846080,"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":"12137965","event":"ball","batsman_id":"95555","bowler_id":"49041","over":"19","ball":"6","score":1,"commentary":"Ed Barnard to George Hill, 1 run,","noball_dismissal":false,"text":"","timestamp":1749846086,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":20,"runs":6,"score":"173\/5","bats":[{"runs":7,"balls_faced":11,"fours":0,"sixes":0,"batsman_id":95555},{"runs":4,"balls_faced":4,"fours":0,"sixes":0,"batsman_id":96059}],"bowls":[{"runs_conceded":18,"maidens":0,"wickets":0,"bowler_id":49041,"overs":3},{"runs_conceded":32,"maidens":0,"wickets":2,"bowler_id":44099,"overs":4}],"commentary":"End of over 20 (6 runs), Yorkshire 173\/5"}],"day":"0","session":"0","live_inning":{"iid":198003,"number":2,"name":"Yorkshire Inning","short_name":"YOR Inning","status":2,"issuperover":"false","result":4,"batting_team_id":7050,"fielding_team_id":7002,"scores":"173\/5","scores_full":"173\/5 (20 ov)","fielder":[{"fielder_id":"93","fielder_name":"Moeen Ali","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"44099","fielder_name":"Hasan Ali","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"1384","fielder_name":"George Garton","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"49025","fielder_name":"Sam Hain","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":"James Wharton","batsman_id":"102295","runs":"37","balls":"32","how_out":"c G Garton b H Ali","score_at_dismissal":166,"overs_at_dismissal":"18.5","bowler_id":"44099","dismissal":"caught","number":5},"extra_runs":{"byes":1,"legbyes":2,"wides":5,"noballs":0,"penalty":"0","total":8},"equations":{"runs":173,"wickets":5,"overs":"20","bowlers_used":7,"runrate":"8.65"},"current_partnership":{"runs":7,"balls":7,"overs":1.1,"batsmen":[{"name":"Matthew Revis","batsman_id":96059,"runs":4,"balls":4},{"name":"George Hill","batsman_id":95555,"runs":2,"balls":3}]},"did_not_bat":[{"player_id":"50392","name":"Dom Bess"},{"player_id":"120400","name":"Jafer Chohan"},{"player_id":"96733","name":"William O''Rourke"},{"player_id":"61872","name":"Jack White"}],"max_over":"20","target":"206","recent_scores":"1,0,1,2,1,1,1,w,0,1,0,0,1,1,1,1,1,1","last_five_overs":"32\/2 6.19","last_ten_overs":"92\/3 8.76"},"teams":[{"tid":7002,"title":"Warwickshire","abbr":"WAS","alt_name":"Warwickshire","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Warwickshire.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Warwickshire.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"205\/8 (20 ov)","scores":"205\/8","overs":"20"},{"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":"173\/5 (20 ov)","scores":"173\/5","overs":"20"}],"players":[{"pid":93,"title":"Moeen Ali","short_name":"M Ali","first_name":"Moeen Ali","last_name":"","middle_name":"","birthdate":"1987-06-18","birthplace":"Birmingham","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/moeenmunirali\/","twitter_profile":"https:\/\/twitter.com\/MoeenaliAli","instagram_profile":"https:\/\/www.instagram.com\/moeenmunirali\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"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":8,"facebook_profile":"https:\/\/www.facebook.com\/JoeRootOfficial\/","twitter_profile":"https:\/\/twitter.com\/root66","instagram_profile":"https:\/\/www.instagram.com\/root66\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":107,"title":"Chris Woakes","short_name":"C Woakes","first_name":"Chris Woakes","last_name":"","middle_name":"","birthdate":"1989-03-02","birthplace":"Birmingham, Warwickshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/chriswoakes\/","twitter_profile":"https:\/\/twitter.com\/chriswoakes","instagram_profile":"https:\/\/www.instagram.com\/chriswoakes\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":1384,"title":"George Garton","short_name":"G Garton","first_name":"George Garton","last_name":"","middle_name":"","birthdate":"1997-04-15","birthplace":"Brighton, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/george_garton","instagram_profile":"https:\/\/www.instagram.com\/georgegarton\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"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.5,"facebook_profile":"https:\/\/www.facebook.com\/AdilRashid95\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/adilrashid\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"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":7.5,"facebook_profile":"https:\/\/www.facebook.com\/lythy09\/","twitter_profile":"https:\/\/twitter.com\/lythy09","instagram_profile":"https:\/\/www.instagram.com\/lythy09\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"pid":44099,"title":"Hasan Ali","short_name":"H Ali","first_name":"Hasan Ali","last_name":"","middle_name":"","birthdate":"1994-07-02","birthplace":"Gujranwala, Punjab","country":"pk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/Realhassan32\/","twitter_profile":"https:\/\/twitter.com\/RealHa55an","instagram_profile":"https:\/\/www.instagram.com\/ha55an_ali\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bowl","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":44185,"title":"Tom Latham","short_name":"T Latham","first_name":"Tom Latham","last_name":"","middle_name":"","birthdate":"1992-04-02","birthplace":"Christchurch, Canterbury","country":"nz","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"wicket keeper","recent_match":23991,"recent_appearance":1513980000,"fantasy_player_rating":7,"facebook_profile":"https:\/\/www.facebook.com\/tomlathamofficial","twitter_profile":"https:\/\/twitter.com\/Tomlatham2","instagram_profile":"https:\/\/www.instagram.com\/tomlatham2\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"wk","role_str":""},{"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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":48430,"title":"Alex Davies","short_name":"AL Davies","first_name":"Alex Davies","last_name":"","middle_name":"","birthdate":"1994-08-23","birthplace":"Darwen, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/aldavies23\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK\/C)"},{"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":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BenCoad10","instagram_profile":"https:\/\/www.instagram.com\/bencoad10\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49017,"title":"Oliver Hannon-Dalby","short_name":"OJ Hannon-Dalby","first_name":"Oliver Hannon-Dalby","last_name":"","middle_name":"","birthdate":"1989-06-20","birthplace":" Halifax, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49025,"title":"Sam Hain","short_name":"SR Hain","first_name":"Sam Hain","last_name":"","middle_name":"","birthdate":"1995-07-16","birthplace":"Hong Kong","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/SammieHain","instagram_profile":"https:\/\/www.instagram.com\/sammiehain","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":49041,"title":"Ed Barnard","short_name":"EG Barnard","first_name":"Ed Barnard","last_name":"","middle_name":"","birthdate":"1995-11-20","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":49320,"title":"Chris Rushworth","short_name":"C Rushworth","first_name":"Chris Rushworth","last_name":"","middle_name":"","birthdate":"1986-07-11","birthplace":"Sunderland","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49480,"title":"Danny Briggs","short_name":"DR Briggs","first_name":"Danny Briggs","last_name":"","middle_name":"","birthdate":"1991-04-30","birthplace":" Newport, Isle of Wight","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/DannyBriggs_14","instagram_profile":"https:\/\/www.instagram.com\/dannybriggs14\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":49530,"title":"Craig Miles","short_name":"CN Miles","first_name":"Craig Miles","last_name":"","middle_name":"","birthdate":"1994-07-20","birthplace":"Swindon, Wiltshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/CMiles_18","instagram_profile":"https:\/\/www.instagram.com\/cmiles18\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":"","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Tommo455","instagram_profile":"https:\/\/www.instagram.com\/jordan.a.thompson\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50945,"title":"Richard Gleeson","short_name":"RJ Gleeson","first_name":"Richard Gleeson","last_name":"","middle_name":"","birthdate":"1987-12-02","birthplace":" Blackpool, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/RicGleeson","instagram_profile":"https:\/\/www.instagram.com\/rgleeson33\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":53626,"title":"Beau Webster","short_name":"BJ Webster","first_name":"Beau Webster","last_name":"","middle_name":"","birthdate":"1993-12-01","birthplace":"Snug, Hobart, Tasmania","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","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":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/mmilnes84","instagram_profile":"https:\/\/www.instagram.com\/matt_milnes\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":88689,"title":"Zen Malik","short_name":"Z Malik","first_name":"Zen Malik","last_name":"","middle_name":"","birthdate":"1998-04-09","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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.5,"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":"","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.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/will_suth12","instagram_profile":"https:\/\/www.instagram.com\/willsutherland12\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"all","role_str":""},{"pid":93516,"title":"Ethan Bamber","short_name":"ER Bamber","first_name":"Ethan Bamber","last_name":"","middle_name":"","birthdate":"1998-12-17","birthplace":"Westminster, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/etbamber","instagram_profile":"https:\/\/www.instagram.com\/etbamber\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":94952,"title":"Kai Smith","short_name":"K Smith","first_name":"Kai Smith","last_name":"","middle_name":"","birthdate":"2004-11-28","birthplace":" Dubai, United Arab Emirates","country":"ae","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"bat","role_str":""},{"pid":95003,"title":"Robert Yates","short_name":"RM Yates","first_name":"Robert Yates","last_name":"","middle_name":"","birthdate":"1999-09-19","birthplace":"Solihull, Warwickshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95543,"title":"Dan Mousley","short_name":"D Mousley","first_name":"Dan Mousley","last_name":"","middle_name":"","birthdate":"2001-07-08","birthplace":"Birmingham, Warwickshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/danmousley80","instagram_profile":"https:\/\/www.instagram.com\/danmousley80\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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":"","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":96733,"title":"William O''Rourke","short_name":"WO Rourke","first_name":"William O''Rourke","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/willorourke_\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bowl","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":102808,"title":"Jake Lintott","short_name":"J Lintott","first_name":"Jake Lintott","last_name":"","middle_name":"","birthdate":"1993-04-22","birthplace":"Taunton, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Wrist Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lintott23","instagram_profile":"https:\/\/www.instagram.com\/lintott23\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":108388,"title":"Jacob Bethell","short_name":"J Bethell","first_name":"Jacob Bethell","last_name":"","middle_name":"","birthdate":"2003-10-23","birthplace":"Barbados","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BethellJacob","instagram_profile":"https:\/\/www.instagram.com\/jacob.bethell\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108389,"title":"Che Simmons","short_name":"C Simmons","first_name":"Che Simmons","last_name":"","middle_name":"","birthdate":"2003-12-18","birthplace":"Birmingham, England","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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":"bat","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(WK)"},{"pid":109583,"title":"Hamza Shaikh","short_name":"H Shaikh","first_name":"Hamza Shaikh","last_name":"","middle_name":"","birthdate":"2006-05-29","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":110496,"title":"Tazeem Ali","short_name":"T Ali","first_name":"Tazeem Ali","last_name":"","middle_name":"","birthdate":"2006-06-13","birthplace":"","country":"nl","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Netherlands","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":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BenjaminCliff1","instagram_profile":"https:\/\/www.instagram.com\/bencliff23\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":119917,"title":"Adam Sylvester","short_name":"A Sylvester","first_name":"Adam Sylvester","last_name":"","middle_name":"","birthdate":"2000-05-18","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/chohanjafar\/","debut_data":"","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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":"","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":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":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":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""}]},"etag":"8ce6d5abfa322ebbf19b53c8c0cf78cf","modified":"2025-07-30 13:30:25","datetime":"2025-07-30 13:30:25","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86869 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:b55ed4d0-93c8-44bd-8626-fde2313158a0 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86869 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86869,3,'{"status":"ok","response":{"match_id":86869,"title":"Yorkshire vs Warwickshire","short_title":"YOR vs WAS","subtitle":"Match 49","match_number":"49","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Warwickshire won by 32 runs","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129425,"title":"Vitality Blast","abbr":"Vitality Blast","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-09-13","country":"en","total_matches":"133","total_rounds":"2","total_teams":"18"},"teama":{"team_id":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":"173\/5 (20 ov)","scores":"173\/5","overs":"20"},"teamb":{"team_id":7002,"name":"Warwickshire","short_name":"WAS","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Warwickshire.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Warwickshire.png","scores_full":"205\/8 (20 ov)","scores":"205\/8","overs":"20"},"date_start":"2025-06-13 17:30:00","date_end":"2025-06-14 03:30:00","timestamp_start":1749835800,"timestamp_end":1749871800,"date_start_ist":"2025-06-13 23:00:00","date_end_ist":"2025-06-14 09:00:00","venue":{"venue_id":"5","name":"Headingley","location":"Leeds","country":"England","timezone":""},"umpires":"","referee":"","equation":"","live":"","result":"WAS won by 32 runs","result_type":2,"win_margin":"32 runs","winning_team_id":7002,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-12 20:52:17","verify_time":"2025-06-14 02:12:27","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":18.92,"humidity":62,"visibility":10000,"wind_speed":"4.29","clouds":100},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"High Scoring","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Warwickshire elected to bat","winner":7002,"decision":1}},"etag":"40fe9031f2567acfd93d0701fefbcd47","modified":"2025-07-30 13:30:26","datetime":"2025-07-30 13:30:26","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":86869,"title":"Yorkshire vs Warwickshire","short_title":"YOR vs WAS","subtitle":"Match 49","match_number":"49","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Warwickshire won by 32 runs","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129425,"title":"Vitality Blast","abbr":"Vitality Blast","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-09-13","country":"en","total_matches":"133","total_rounds":"2","total_teams":"18"},"teama":{"team_id":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":"173\/5 (20 ov)","scores":"173\/5","overs":"20"},"teamb":{"team_id":7002,"name":"Warwickshire","short_name":"WAS","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Warwickshire.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Warwickshire.png","scores_full":"205\/8 (20 ov)","scores":"205\/8","overs":"20"},"date_start":"2025-06-13 17:30:00","date_end":"2025-06-14 03:30:00","timestamp_start":1749835800,"timestamp_end":1749871800,"date_start_ist":"2025-06-13 23:00:00","date_end_ist":"2025-06-14 09:00:00","venue":{"venue_id":"5","name":"Headingley","location":"Leeds","country":"England","timezone":""},"umpires":"","referee":"","equation":"","live":"","result":"WAS won by 32 runs","result_type":2,"win_margin":"32 runs","winning_team_id":7002,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-12 20:52:17","verify_time":"2025-06-14 02:12:27","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":18.92,"humidity":62,"visibility":10000,"wind_speed":"4.29","clouds":100},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"High Scoring","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Warwickshire elected to bat","winner":7002,"decision":1}},"etag":"40fe9031f2567acfd93d0701fefbcd47","modified":"2025-07-30 13:30:26","datetime":"2025-07-30 13:30:26","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86869 AND DataTypeId = 3 END
Live Report & Scorecard of Yorkshire vs Warwickshire Match 49
<>
LIVE06 May Match 5

Hong Kong WomenHong Kong Women

Kuwait Women

 
LIVE06 May Match 6

Thailand WomenThailand Women

United Arab Emirates Women

 
LIVEToday51st Match

DurhamDurham153/10 (55.1 ov)

Surrey*322/10 (68.1 ov)

 Lunch Break : Day 2 - Surrey lead by 169 runs.
LIVEToday55th Match

NottinghamshireNottinghamshire

Somerset438/10 (132.3 ov)

 Innings Break : Day 2 - Nottinghamshire elected to bowl
LIVEToday54th Match

WorcestershireWorcestershire

Hampshire*248/7 (79.2 ov)

 Day 2 - Worcestershire elected to bowl
LIVEToday52nd Match

EssexEssex*539/5 (141 ov)

Warwickshire

 Day 2 - Warwickshire elected to bowl
LIVEToday53rd Match

YorkshireYorkshire*109/2 (36.2 ov)

Sussex222/10 (99.5 ov)

 Day 2 - Yorkshire trail by 113 runs.
LIVEToday42nd Match

GloucestershireGloucestershire

Middlesex*314/4 (70.5 ov)

 Day 2 - Middlesex elected to bat
LIVEToday44th Match

KentKent*31/0 (8.4 ov)

Leicestershire471/10 (114.5 ov)

 Day 2 - Kent trail by 440 runs.
LIVEToday43rd Match

LancashireLancashire*62/2 (22 ov)

Glamorgan261/10 (97.2 ov)

 Day 2 - Lancashire trail by 199 runs.
LIVEToday41st Match

NorthamptonshireNorthamptonshire*94/2 (29.1 ov)

Derbyshire377/10 (104.2 ov)

 Day 2 - Northamptonshire trail by 283 runs.
LIVEToday1st Test

ZimbabweZimbabwe149/10 (60.3 ov)

New Zealand0/0 ( ov)

 Innings Break : Day 1 - Session 3,
LIVETodayMatch 37

Hampshire WomenHampshire Women

The Blaze Women

 Not covered live
LIVETodayMatch 38

Lancashire WomenLancashire Women306/4 (50 ov)

Essex Women*10/0 (2.1 ov)

 Essex Women need 297 runs in 47.5 remaining overs
LIVETodayMatch 39

Somerset WomenSomerset Women*0/0 ( ov)

Durham Women315/9 (50 ov)

 Innings Break : Somerset Women need 316 runs in 50 remaining overs
LIVETodayMatch 40

Warwickshire WomenWarwickshire Women239/10 (42.5 ov)

Surrey Women*53/1 (7.4 ov)

 Surrey Women need 187 runs in 42.2 remaining overs
LIVETodayMatch 13

East MoleseyEast Molesey*46/5 (3.4 ov)

Weybridge

 Weybridge elected to bowl
ScheduledTodayMatch 4

West Indies Women Under-19sWest Indies Women Under-19s

United States of America Women Under-19s

 
Scheduled30 July Match 14

WeybridgeWeybridge

Twickenham

 
Scheduled30 July Match 3

Royal TrivianzRoyal Trivianz

Keraniganj Challengers

 
CricDirect Cricket News, Results and Stats
 

Yorkshire vs Warwickshire, Match 49, Vitality Blast

Completed
Vitality Blast, Completed
Yorkshire
YOR
173/5 (20)
Warwickshire
WAS
205/8 (20)
Warwickshire won by 32 runs
Match Details
Date
2025-06-13 17:30:00
Venue
Headingley, Leeds
Toss
Warwickshire elected to bat
Umpires
    Tv Umpires
      Match Referee
        × Close