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:c2deb454-d1b8-4746-80aa-873c39932700 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86584 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86584,1,'{"status":"ok","response":{"mid":86584,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Yorkshire won by 5 wickets","day_remaining_over":"","team_batting":"Yorkshire","team_bowling":"Warwickshire","live_inning_number":2,"live_score":{"runs":140,"overs":32.5,"wickets":5,"target":138,"runrate":4.26,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Harry Duke","batsman_id":96606,"runs":10,"balls_faced":4,"fours":1,"sixes":1,"strike_rate":"250.00"},{"name":"George Hill","batsman_id":95555,"runs":20,"balls_faced":37,"fours":3,"sixes":0,"strike_rate":"54.05"}],"bowlers":[{"name":"Michael Booth","bowler_id":110620,"overs":6.5,"runs_conceded":29,"wickets":3,"maidens":0,"econ":"4.24"},{"name":"Ethan Bamber","bowler_id":93516,"overs":5,"runs_conceded":26,"wickets":1,"maidens":0,"econ":"5.20"}],"commentaries":[{"event_id":"12486187","event":"ball","batsman_id":"95555","bowler_id":"102808","over":"28","ball":"4","score":1,"commentary":"Jake Lintott to George Hill, 1 run,","noball_dismissal":false,"text":"","timestamp":1754406986,"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":"12486190","event":"ball","batsman_id":"45199","bowler_id":"102808","over":"28","ball":"5","score":4,"commentary":"Jake Lintott to Imam ul Haq, Four,","noball_dismissal":false,"text":"","timestamp":1754406990,"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":"12486191","event":"ball","batsman_id":"45199","bowler_id":"102808","over":"28","ball":"6","score":1,"commentary":"Jake Lintott to Imam ul Haq, 1 run,","noball_dismissal":false,"text":"","timestamp":1754406993,"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":29,"runs":9,"score":"101\/4","bats":[{"runs":39,"balls_faced":69,"fours":6,"sixes":0,"batsman_id":45199},{"runs":13,"balls_faced":31,"fours":2,"sixes":0,"batsman_id":95555}],"bowls":[{"runs_conceded":13,"maidens":0,"wickets":0,"bowler_id":102808,"overs":2},{"runs_conceded":25,"maidens":2,"wickets":1,"bowler_id":49017,"overs":9}],"commentary":"End of over 29 (9 runs), Yorkshire 101\/4"},{"event_id":"12486192","event":"ball","batsman_id":"45199","bowler_id":"49017","over":"29","ball":"1","score":4,"commentary":"Oliver Hannon-Dalby to Imam ul Haq, Four,","noball_dismissal":false,"text":"","timestamp":1754407009,"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":"12486194","event":"ball","batsman_id":"45199","bowler_id":"49017","over":"29","ball":"2","score":0,"commentary":"Oliver Hannon-Dalby to Imam ul Haq, no run,","noball_dismissal":false,"text":"","timestamp":1754407049,"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":"12486199","event":"ball","batsman_id":"45199","bowler_id":"49017","over":"29","ball":"3","score":0,"commentary":"Oliver Hannon-Dalby to Imam ul Haq, no run,","noball_dismissal":false,"text":"","timestamp":1754407053,"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":"12486200","event":"ball","batsman_id":"45199","bowler_id":"49017","over":"29","ball":"4","score":1,"commentary":"Oliver Hannon-Dalby to Imam ul Haq, 1 run,","noball_dismissal":false,"text":"","timestamp":1754407189,"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":"12486231","event":"ball","batsman_id":"95555","bowler_id":"49017","over":"29","ball":"5","score":0,"commentary":"Oliver Hannon-Dalby to George Hill, no run,","noball_dismissal":false,"text":"","timestamp":1754407192,"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":"12486232","event":"ball","batsman_id":"95555","bowler_id":"49017","over":"29","ball":"6","score":1,"commentary":"Oliver Hannon-Dalby to George Hill, 1 run,","noball_dismissal":false,"text":"","timestamp":1754407257,"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":30,"runs":6,"score":"107\/4","bats":[{"runs":14,"balls_faced":33,"fours":2,"sixes":0,"batsman_id":95555},{"runs":44,"balls_faced":73,"fours":7,"sixes":0,"batsman_id":45199}],"bowls":[{"runs_conceded":31,"maidens":2,"wickets":1,"bowler_id":49017,"overs":10},{"runs_conceded":13,"maidens":0,"wickets":0,"bowler_id":102808,"overs":2}],"commentary":"End of over 30 (6 runs), Yorkshire 107\/4"},{"event_id":"12486247","event":"ball","batsman_id":"95555","bowler_id":"102808","over":"30","ball":"1","score":1,"commentary":"Jake Lintott to George Hill, 1 run,","noball_dismissal":false,"text":"","timestamp":1754407260,"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":"12486248","event":"ball","batsman_id":"45199","bowler_id":"102808","over":"30","ball":"2","score":4,"commentary":"Jake Lintott to Imam ul Haq, Four,","noball_dismissal":false,"text":"","timestamp":1754407424,"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":"12486272","event":"ball","batsman_id":"45199","bowler_id":"102808","over":"30","ball":"3","score":1,"commentary":"Jake Lintott to Imam ul Haq, 1 run,","noball_dismissal":false,"text":"","timestamp":1754407428,"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":"12486274","event":"ball","batsman_id":"95555","bowler_id":"102808","over":"30","ball":"4","score":4,"commentary":"Jake Lintott to George Hill, Four,","noball_dismissal":false,"text":"","timestamp":1754407431,"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":"12486275","event":"ball","batsman_id":"95555","bowler_id":"102808","over":"30","ball":"5","score":1,"commentary":"Jake Lintott to George Hill, 1 run,","noball_dismissal":false,"text":"","timestamp":1754407435,"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":"12486276","event":"ball","batsman_id":"45199","bowler_id":"102808","over":"30","ball":"6","score":1,"commentary":"Jake Lintott to Imam ul Haq, 1 run,","noball_dismissal":false,"text":"","timestamp":1754407769,"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":31,"runs":12,"score":"119\/4","bats":[{"runs":50,"balls_faced":76,"fours":8,"sixes":0,"batsman_id":45199},{"runs":20,"balls_faced":36,"fours":3,"sixes":0,"batsman_id":95555}],"bowls":[{"runs_conceded":25,"maidens":0,"wickets":0,"bowler_id":102808,"overs":3},{"runs_conceded":31,"maidens":2,"wickets":1,"bowler_id":49017,"overs":10}],"commentary":"End of over 31 (12 runs), Yorkshire 119\/4"},{"event_id":"12486294","event":"ball","batsman_id":"45199","bowler_id":"93516","over":"31","ball":"1","score":0,"commentary":"Ethan Bamber to Imam ul Haq, no run,","noball_dismissal":false,"text":"","timestamp":1754407773,"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":"12486328","event":"ball","batsman_id":"45199","bowler_id":"93516","over":"31","ball":"2","score":"4lb","commentary":"Ethan Bamber to Imam ul Haq, 4 leg bye,","noball_dismissal":false,"text":"","timestamp":1754407777,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"4","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12486329","event":"ball","batsman_id":"45199","bowler_id":"93516","over":"31","ball":"3","score":4,"commentary":"Ethan Bamber to Imam ul Haq, Four,","noball_dismissal":false,"text":"","timestamp":1754407780,"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":"12486330","event":"ball","batsman_id":"45199","bowler_id":"93516","over":"31","ball":"4","score":0,"commentary":"Ethan Bamber to Imam ul Haq, no run,","noball_dismissal":false,"text":"","timestamp":1754407783,"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":"12486332","event":"ball","batsman_id":"45199","bowler_id":"93516","over":"31","ball":"5","score":1,"commentary":"Ethan Bamber to Imam ul Haq, 1 run,","noball_dismissal":false,"text":"","timestamp":1754407786,"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":"12486333","event":"ball","batsman_id":"95555","bowler_id":"93516","over":"31","ball":"6","score":0,"commentary":"Ethan Bamber to George Hill, no run,","noball_dismissal":false,"text":"","timestamp":1754407789,"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":32,"runs":9,"score":"128\/4","bats":[{"runs":20,"balls_faced":37,"fours":3,"sixes":0,"batsman_id":95555},{"runs":55,"balls_faced":81,"fours":9,"sixes":0,"batsman_id":45199}],"bowls":[{"runs_conceded":26,"maidens":0,"wickets":1,"bowler_id":93516,"overs":5},{"runs_conceded":25,"maidens":0,"wickets":0,"bowler_id":102808,"overs":3}],"commentary":"End of over 32 (9 runs), Yorkshire 128\/4"},{"event_id":"12486335","event":"ball","batsman_id":"45199","bowler_id":"110620","over":"32","ball":"1","score":0,"commentary":"Michael Booth to Imam ul Haq, no run,","noball_dismissal":false,"text":"","timestamp":1754407853,"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":"12486345","event":"wicket","batsman_id":"45199","bowler_id":"110620","over":"32","ball":"2","score":"w","commentary":"Michael Booth to Imam ul Haq, no run, c V Jani b MG Booth,","noball_dismissal":false,"text":"","timestamp":1754407857,"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":"45199","how_out":"c V Jani b MG Booth","batsman_runs":"55","batsman_balls":"83"},{"event_id":"12486370","event":"ball","batsman_id":"96606","bowler_id":"110620","over":"32","ball":"3","score":0,"commentary":"Michael Booth to Harry Duke, no run,","noball_dismissal":false,"text":"","timestamp":1754407920,"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":"12486373","event":"ball","batsman_id":"96606","bowler_id":"110620","over":"32","ball":"4","score":0,"commentary":"Michael Booth to Harry Duke, no run,","noball_dismissal":false,"text":"","timestamp":1754407955,"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":"12486378","event":"ball","batsman_id":"96606","bowler_id":"110620","over":"32","ball":"5","score":"6nb","commentary":"Michael Booth to Harry Duke, 6 no ball,","noball_dismissal":false,"text":"","timestamp":1754407958,"run":6,"noball_run":"1","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":true,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12486380","event":"ball","batsman_id":"96606","bowler_id":"110620","over":"32","ball":"5","score":6,"commentary":"Michael Booth to Harry Duke, Six,","noball_dismissal":false,"text":"","timestamp":1754407961,"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}],"day":"0","session":"0","live_inning":{"iid":200642,"number":2,"name":"Yorkshire Inning","short_name":"YOR Inning","status":2,"issuperover":"false","result":3,"batting_team_id":7050,"fielding_team_id":7002,"scores":"140\/5","scores_full":"140\/5 (32.5 ov)","fielder":[{"fielder_id":"94952","fielder_name":"Kai Smith","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"150853","fielder_name":"Vaansh Jani","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"109583","fielder_name":"Hamza Shaikh","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"95003","fielder_name":"Robert Yates","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"10"},"p2":{"startover":"10.1","endover":"40"}},"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":"Imam ul Haq","batsman_id":"45199","runs":"55","balls":"83","how_out":"c V Jani b MG Booth","score_at_dismissal":128,"overs_at_dismissal":"32.2","bowler_id":"110620","dismissal":"caught","number":5},"extra_runs":{"byes":0,"legbyes":4,"wides":1,"noballs":2,"penalty":"0","total":7},"equations":{"runs":140,"wickets":5,"overs":"32.5","bowlers_used":5,"runrate":"4.26"},"current_partnership":{"runs":12,"balls":4,"overs":0.4,"batsmen":[{"name":"Harry Duke","batsman_id":96606,"runs":10,"balls":4},{"name":"George Hill","batsman_id":95555,"runs":0,"balls":0}]},"did_not_bat":[{"player_id":"45911","name":"Daniel Moriarty"},{"player_id":"112710","name":"Benjamin Cliff"},{"player_id":"61872","name":"Jack White"},{"player_id":"50392","name":"Dom Bess"}],"max_over":"50","target":"138","recent_scores":"6,6,0,0,w,0,0,1,0,4,4,0,1,1,4,1,4,1","last_five_overs":"48\/1 9.29","last_ten_overs":"64\/1 6.30"},"teams":[{"tid":7002,"title":"Warwickshire","abbr":"WAR","alt_name":"Warwickshire","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Warwickshire.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Warwickshire.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"137\/10 (36.3 ov)","scores":"137\/10","overs":"36.3"},{"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":"140\/5 (32.5 ov)","scores":"140\/5","overs":"32.5"}],"players":[{"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":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/george_garton","instagram_profile":"https:\/\/www.instagram.com\/georgegarton\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"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":8,"facebook_profile":"https:\/\/www.facebook.com\/lythy09\/","twitter_profile":"https:\/\/twitter.com\/lythy09","instagram_profile":"https:\/\/www.instagram.com\/lythy09\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":44100,"title":"Jonny Bairstow","short_name":"J Bairstow","first_name":"Jonny Bairstow","last_name":"","middle_name":"","birthdate":"1989-09-26","birthplace":" Bradford, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/jbairstow21\/","twitter_profile":"https:\/\/twitter.com\/jbairstow21","instagram_profile":"https:\/\/www.instagram.com\/jbairstow21\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":45199,"title":"Imam ul Haq","short_name":"IU Haq","first_name":"Imam ul Haq","last_name":"","middle_name":"","birthdate":"1995-12-12","birthplace":"Lahore, Punjab","country":"pk","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":24101,"recent_appearance":1515448800,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/imam.246\/","twitter_profile":"https:\/\/twitter.com\/ImamUlHaq12","instagram_profile":"https:\/\/www.instagram.com\/imamulhaqofficial\/?hl=en-gb","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bat","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":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/aldavies23\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":""},{"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.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BenCoad10","instagram_profile":"https:\/\/www.instagram.com\/bencoad10\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":49025,"title":"Sam Hain","short_name":"SR Hain","first_name":"Sam Hain","last_name":"","middle_name":"","birthdate":"1995-07-16","birthplace":"Hong Kong","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/SammieHain","instagram_profile":"https:\/\/www.instagram.com\/sammiehain","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":"(C)"},{"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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/CMiles_18","instagram_profile":"https:\/\/www.instagram.com\/cmiles18\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/dombess99\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":"(C)"},{"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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50507,"title":"Jordan Thompson","short_name":"JA Thompson","first_name":"Jordan Thompson","last_name":"","middle_name":"","birthdate":"1996-10-09","birthplace":"Leeds, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Tommo455","instagram_profile":"https:\/\/www.instagram.com\/jordan.a.thompson\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","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":"all","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":"","bowling_type":"Pace","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","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":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":93516,"title":"Ethan Bamber","short_name":"ER Bamber","first_name":"Ethan Bamber","last_name":"","middle_name":"","birthdate":"1998-12-17","birthplace":"Westminster, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/etbamber","instagram_profile":"https:\/\/www.instagram.com\/etbamber\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","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":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"wk","role_str":"(WK)"},{"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":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":95543,"title":"Dan Mousley","short_name":"D Mousley","first_name":"Dan Mousley","last_name":"","middle_name":"","birthdate":"2001-07-08","birthplace":"Birmingham, Warwickshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/danmousley80","instagram_profile":"https:\/\/www.instagram.com\/danmousley80\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95555,"title":"George Hill","short_name":"G Hill","first_name":"George Hill","last_name":"","middle_name":"","birthdate":"2001-01-24","birthplace":"Keighley, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":95557,"title":"Dominic Leech","short_name":"D Leech","first_name":"Dominic Leech","last_name":"","middle_name":"","birthdate":"2001-01-10","birthplace":" Middlesbrough, 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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95593,"title":"Finlay Bean","short_name":"F Bean","first_name":"Finlay Bean","last_name":"","middle_name":"","birthdate":"2002-04-16","birthplace":" Harrogate, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":96059,"title":"Matthew Revis","short_name":"M Revis","first_name":"Matthew Revis","last_name":"","middle_name":"","birthdate":"2001-11-15","birthplace":" Steeton, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/matty.revis_\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":96606,"title":"Harry Duke","short_name":"H Duke","first_name":"Harry Duke","last_name":"","middle_name":"","birthdate":"2001-09-01","birthplace":"Pinderfields, Wakefield","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","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":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lintott23","instagram_profile":"https:\/\/www.instagram.com\/lintott23\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":109356,"title":"William Luxton","short_name":"W Luxton","first_name":"William Luxton","last_name":"","middle_name":"","birthdate":"2003-05-06","birthplace":"Keighley, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":109583,"title":"Hamza Shaikh","short_name":"H Shaikh","first_name":"Hamza Shaikh","last_name":"","middle_name":"","birthdate":"2006-05-29","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":110620,"title":"Michael Booth","short_name":"MG Booth","first_name":"Michael Booth","last_name":"","middle_name":"","birthdate":"2001-02-12","birthplace":" Harare","country":"za","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","role":"all","role_str":""},{"pid":112710,"title":"Benjamin Cliff","short_name":"BM Cliff","first_name":"Benjamin Cliff","last_name":"","middle_name":"","birthdate":"2002-10-23","birthplace":" Halifax, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BenjaminCliff1","instagram_profile":"https:\/\/www.instagram.com\/bencliff23\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":120400,"title":"Jafer Chohan","short_name":"JA Chohan","first_name":"Jafer Chohan","last_name":"","middle_name":"","birthdate":"2002-07-11","birthplace":"Camden, Middlesex, England","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/chohanjafar\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":127225,"title":"Yash Vagadia","short_name":"Y Vagadia","first_name":"Yash Vagadia","last_name":"","middle_name":"","birthdate":"2005-01-01","birthplace":" Newcastle","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":130019,"title":"Theo Wylie","short_name":"TO Wylie","first_name":"Theo Wylie","last_name":"","middle_name":"","birthdate":"2006-01-17","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":134957,"title":"Tazeem Chaudry Ali","short_name":"TC Ali","first_name":"Tazeem Chaudry Ali","last_name":"","middle_name":"","birthdate":"2006-06-13","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":141670,"title":"Noah M Kelly","short_name":"N M Kelly","first_name":"Noah M Kelly","last_name":"","middle_name":"","birthdate":"2005-09-21","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":146172,"title":"Alex Wade","short_name":"A Wade","first_name":"Alex Wade","last_name":"","middle_name":"","birthdate":"2006-11-28","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":147420,"title":"Jawad Akhtar","short_name":"J Akhtar","first_name":"Jawad Akhtar","last_name":"","middle_name":"","birthdate":"2005-11-19","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":150853,"title":"Vaansh Jani","short_name":"V Jani","first_name":"Vaansh Jani","last_name":"","middle_name":"","birthdate":"2005-06-06","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""}]},"etag":"6f9a77682f8ca0e522aec124903e402b","modified":"2025-08-06 09:12:24","datetime":"2025-08-06 09:12:24","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":86584,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Yorkshire won by 5 wickets","day_remaining_over":"","team_batting":"Yorkshire","team_bowling":"Warwickshire","live_inning_number":2,"live_score":{"runs":140,"overs":32.5,"wickets":5,"target":138,"runrate":4.26,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Harry Duke","batsman_id":96606,"runs":10,"balls_faced":4,"fours":1,"sixes":1,"strike_rate":"250.00"},{"name":"George Hill","batsman_id":95555,"runs":20,"balls_faced":37,"fours":3,"sixes":0,"strike_rate":"54.05"}],"bowlers":[{"name":"Michael Booth","bowler_id":110620,"overs":6.5,"runs_conceded":29,"wickets":3,"maidens":0,"econ":"4.24"},{"name":"Ethan Bamber","bowler_id":93516,"overs":5,"runs_conceded":26,"wickets":1,"maidens":0,"econ":"5.20"}],"commentaries":[{"event_id":"12486187","event":"ball","batsman_id":"95555","bowler_id":"102808","over":"28","ball":"4","score":1,"commentary":"Jake Lintott to George Hill, 1 run,","noball_dismissal":false,"text":"","timestamp":1754406986,"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":"12486190","event":"ball","batsman_id":"45199","bowler_id":"102808","over":"28","ball":"5","score":4,"commentary":"Jake Lintott to Imam ul Haq, Four,","noball_dismissal":false,"text":"","timestamp":1754406990,"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":"12486191","event":"ball","batsman_id":"45199","bowler_id":"102808","over":"28","ball":"6","score":1,"commentary":"Jake Lintott to Imam ul Haq, 1 run,","noball_dismissal":false,"text":"","timestamp":1754406993,"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":29,"runs":9,"score":"101\/4","bats":[{"runs":39,"balls_faced":69,"fours":6,"sixes":0,"batsman_id":45199},{"runs":13,"balls_faced":31,"fours":2,"sixes":0,"batsman_id":95555}],"bowls":[{"runs_conceded":13,"maidens":0,"wickets":0,"bowler_id":102808,"overs":2},{"runs_conceded":25,"maidens":2,"wickets":1,"bowler_id":49017,"overs":9}],"commentary":"End of over 29 (9 runs), Yorkshire 101\/4"},{"event_id":"12486192","event":"ball","batsman_id":"45199","bowler_id":"49017","over":"29","ball":"1","score":4,"commentary":"Oliver Hannon-Dalby to Imam ul Haq, Four,","noball_dismissal":false,"text":"","timestamp":1754407009,"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":"12486194","event":"ball","batsman_id":"45199","bowler_id":"49017","over":"29","ball":"2","score":0,"commentary":"Oliver Hannon-Dalby to Imam ul Haq, no run,","noball_dismissal":false,"text":"","timestamp":1754407049,"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":"12486199","event":"ball","batsman_id":"45199","bowler_id":"49017","over":"29","ball":"3","score":0,"commentary":"Oliver Hannon-Dalby to Imam ul Haq, no run,","noball_dismissal":false,"text":"","timestamp":1754407053,"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":"12486200","event":"ball","batsman_id":"45199","bowler_id":"49017","over":"29","ball":"4","score":1,"commentary":"Oliver Hannon-Dalby to Imam ul Haq, 1 run,","noball_dismissal":false,"text":"","timestamp":1754407189,"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":"12486231","event":"ball","batsman_id":"95555","bowler_id":"49017","over":"29","ball":"5","score":0,"commentary":"Oliver Hannon-Dalby to George Hill, no run,","noball_dismissal":false,"text":"","timestamp":1754407192,"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":"12486232","event":"ball","batsman_id":"95555","bowler_id":"49017","over":"29","ball":"6","score":1,"commentary":"Oliver Hannon-Dalby to George Hill, 1 run,","noball_dismissal":false,"text":"","timestamp":1754407257,"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":30,"runs":6,"score":"107\/4","bats":[{"runs":14,"balls_faced":33,"fours":2,"sixes":0,"batsman_id":95555},{"runs":44,"balls_faced":73,"fours":7,"sixes":0,"batsman_id":45199}],"bowls":[{"runs_conceded":31,"maidens":2,"wickets":1,"bowler_id":49017,"overs":10},{"runs_conceded":13,"maidens":0,"wickets":0,"bowler_id":102808,"overs":2}],"commentary":"End of over 30 (6 runs), Yorkshire 107\/4"},{"event_id":"12486247","event":"ball","batsman_id":"95555","bowler_id":"102808","over":"30","ball":"1","score":1,"commentary":"Jake Lintott to George Hill, 1 run,","noball_dismissal":false,"text":"","timestamp":1754407260,"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":"12486248","event":"ball","batsman_id":"45199","bowler_id":"102808","over":"30","ball":"2","score":4,"commentary":"Jake Lintott to Imam ul Haq, Four,","noball_dismissal":false,"text":"","timestamp":1754407424,"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":"12486272","event":"ball","batsman_id":"45199","bowler_id":"102808","over":"30","ball":"3","score":1,"commentary":"Jake Lintott to Imam ul Haq, 1 run,","noball_dismissal":false,"text":"","timestamp":1754407428,"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":"12486274","event":"ball","batsman_id":"95555","bowler_id":"102808","over":"30","ball":"4","score":4,"commentary":"Jake Lintott to George Hill, Four,","noball_dismissal":false,"text":"","timestamp":1754407431,"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":"12486275","event":"ball","batsman_id":"95555","bowler_id":"102808","over":"30","ball":"5","score":1,"commentary":"Jake Lintott to George Hill, 1 run,","noball_dismissal":false,"text":"","timestamp":1754407435,"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":"12486276","event":"ball","batsman_id":"45199","bowler_id":"102808","over":"30","ball":"6","score":1,"commentary":"Jake Lintott to Imam ul Haq, 1 run,","noball_dismissal":false,"text":"","timestamp":1754407769,"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":31,"runs":12,"score":"119\/4","bats":[{"runs":50,"balls_faced":76,"fours":8,"sixes":0,"batsman_id":45199},{"runs":20,"balls_faced":36,"fours":3,"sixes":0,"batsman_id":95555}],"bowls":[{"runs_conceded":25,"maidens":0,"wickets":0,"bowler_id":102808,"overs":3},{"runs_conceded":31,"maidens":2,"wickets":1,"bowler_id":49017,"overs":10}],"commentary":"End of over 31 (12 runs), Yorkshire 119\/4"},{"event_id":"12486294","event":"ball","batsman_id":"45199","bowler_id":"93516","over":"31","ball":"1","score":0,"commentary":"Ethan Bamber to Imam ul Haq, no run,","noball_dismissal":false,"text":"","timestamp":1754407773,"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":"12486328","event":"ball","batsman_id":"45199","bowler_id":"93516","over":"31","ball":"2","score":"4lb","commentary":"Ethan Bamber to Imam ul Haq, 4 leg bye,","noball_dismissal":false,"text":"","timestamp":1754407777,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"4","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12486329","event":"ball","batsman_id":"45199","bowler_id":"93516","over":"31","ball":"3","score":4,"commentary":"Ethan Bamber to Imam ul Haq, Four,","noball_dismissal":false,"text":"","timestamp":1754407780,"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":"12486330","event":"ball","batsman_id":"45199","bowler_id":"93516","over":"31","ball":"4","score":0,"commentary":"Ethan Bamber to Imam ul Haq, no run,","noball_dismissal":false,"text":"","timestamp":1754407783,"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":"12486332","event":"ball","batsman_id":"45199","bowler_id":"93516","over":"31","ball":"5","score":1,"commentary":"Ethan Bamber to Imam ul Haq, 1 run,","noball_dismissal":false,"text":"","timestamp":1754407786,"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":"12486333","event":"ball","batsman_id":"95555","bowler_id":"93516","over":"31","ball":"6","score":0,"commentary":"Ethan Bamber to George Hill, no run,","noball_dismissal":false,"text":"","timestamp":1754407789,"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":32,"runs":9,"score":"128\/4","bats":[{"runs":20,"balls_faced":37,"fours":3,"sixes":0,"batsman_id":95555},{"runs":55,"balls_faced":81,"fours":9,"sixes":0,"batsman_id":45199}],"bowls":[{"runs_conceded":26,"maidens":0,"wickets":1,"bowler_id":93516,"overs":5},{"runs_conceded":25,"maidens":0,"wickets":0,"bowler_id":102808,"overs":3}],"commentary":"End of over 32 (9 runs), Yorkshire 128\/4"},{"event_id":"12486335","event":"ball","batsman_id":"45199","bowler_id":"110620","over":"32","ball":"1","score":0,"commentary":"Michael Booth to Imam ul Haq, no run,","noball_dismissal":false,"text":"","timestamp":1754407853,"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":"12486345","event":"wicket","batsman_id":"45199","bowler_id":"110620","over":"32","ball":"2","score":"w","commentary":"Michael Booth to Imam ul Haq, no run, c V Jani b MG Booth,","noball_dismissal":false,"text":"","timestamp":1754407857,"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":"45199","how_out":"c V Jani b MG Booth","batsman_runs":"55","batsman_balls":"83"},{"event_id":"12486370","event":"ball","batsman_id":"96606","bowler_id":"110620","over":"32","ball":"3","score":0,"commentary":"Michael Booth to Harry Duke, no run,","noball_dismissal":false,"text":"","timestamp":1754407920,"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":"12486373","event":"ball","batsman_id":"96606","bowler_id":"110620","over":"32","ball":"4","score":0,"commentary":"Michael Booth to Harry Duke, no run,","noball_dismissal":false,"text":"","timestamp":1754407955,"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":"12486378","event":"ball","batsman_id":"96606","bowler_id":"110620","over":"32","ball":"5","score":"6nb","commentary":"Michael Booth to Harry Duke, 6 no ball,","noball_dismissal":false,"text":"","timestamp":1754407958,"run":6,"noball_run":"1","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":true,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12486380","event":"ball","batsman_id":"96606","bowler_id":"110620","over":"32","ball":"5","score":6,"commentary":"Michael Booth to Harry Duke, Six,","noball_dismissal":false,"text":"","timestamp":1754407961,"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}],"day":"0","session":"0","live_inning":{"iid":200642,"number":2,"name":"Yorkshire Inning","short_name":"YOR Inning","status":2,"issuperover":"false","result":3,"batting_team_id":7050,"fielding_team_id":7002,"scores":"140\/5","scores_full":"140\/5 (32.5 ov)","fielder":[{"fielder_id":"94952","fielder_name":"Kai Smith","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"150853","fielder_name":"Vaansh Jani","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"109583","fielder_name":"Hamza Shaikh","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"95003","fielder_name":"Robert Yates","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"10"},"p2":{"startover":"10.1","endover":"40"}},"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":"Imam ul Haq","batsman_id":"45199","runs":"55","balls":"83","how_out":"c V Jani b MG Booth","score_at_dismissal":128,"overs_at_dismissal":"32.2","bowler_id":"110620","dismissal":"caught","number":5},"extra_runs":{"byes":0,"legbyes":4,"wides":1,"noballs":2,"penalty":"0","total":7},"equations":{"runs":140,"wickets":5,"overs":"32.5","bowlers_used":5,"runrate":"4.26"},"current_partnership":{"runs":12,"balls":4,"overs":0.4,"batsmen":[{"name":"Harry Duke","batsman_id":96606,"runs":10,"balls":4},{"name":"George Hill","batsman_id":95555,"runs":0,"balls":0}]},"did_not_bat":[{"player_id":"45911","name":"Daniel Moriarty"},{"player_id":"112710","name":"Benjamin Cliff"},{"player_id":"61872","name":"Jack White"},{"player_id":"50392","name":"Dom Bess"}],"max_over":"50","target":"138","recent_scores":"6,6,0,0,w,0,0,1,0,4,4,0,1,1,4,1,4,1","last_five_overs":"48\/1 9.29","last_ten_overs":"64\/1 6.30"},"teams":[{"tid":7002,"title":"Warwickshire","abbr":"WAR","alt_name":"Warwickshire","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Warwickshire.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Warwickshire.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"137\/10 (36.3 ov)","scores":"137\/10","overs":"36.3"},{"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":"140\/5 (32.5 ov)","scores":"140\/5","overs":"32.5"}],"players":[{"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":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/george_garton","instagram_profile":"https:\/\/www.instagram.com\/georgegarton\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"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":8,"facebook_profile":"https:\/\/www.facebook.com\/lythy09\/","twitter_profile":"https:\/\/twitter.com\/lythy09","instagram_profile":"https:\/\/www.instagram.com\/lythy09\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":44100,"title":"Jonny Bairstow","short_name":"J Bairstow","first_name":"Jonny Bairstow","last_name":"","middle_name":"","birthdate":"1989-09-26","birthplace":" Bradford, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/jbairstow21\/","twitter_profile":"https:\/\/twitter.com\/jbairstow21","instagram_profile":"https:\/\/www.instagram.com\/jbairstow21\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":45199,"title":"Imam ul Haq","short_name":"IU Haq","first_name":"Imam ul Haq","last_name":"","middle_name":"","birthdate":"1995-12-12","birthplace":"Lahore, Punjab","country":"pk","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":24101,"recent_appearance":1515448800,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/imam.246\/","twitter_profile":"https:\/\/twitter.com\/ImamUlHaq12","instagram_profile":"https:\/\/www.instagram.com\/imamulhaqofficial\/?hl=en-gb","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bat","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":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/aldavies23\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":""},{"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.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BenCoad10","instagram_profile":"https:\/\/www.instagram.com\/bencoad10\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":49025,"title":"Sam Hain","short_name":"SR Hain","first_name":"Sam Hain","last_name":"","middle_name":"","birthdate":"1995-07-16","birthplace":"Hong Kong","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/SammieHain","instagram_profile":"https:\/\/www.instagram.com\/sammiehain","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":"(C)"},{"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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/CMiles_18","instagram_profile":"https:\/\/www.instagram.com\/cmiles18\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/dombess99\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":"(C)"},{"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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50507,"title":"Jordan Thompson","short_name":"JA Thompson","first_name":"Jordan Thompson","last_name":"","middle_name":"","birthdate":"1996-10-09","birthplace":"Leeds, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Tommo455","instagram_profile":"https:\/\/www.instagram.com\/jordan.a.thompson\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","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":"all","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":"","bowling_type":"Pace","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","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":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":93516,"title":"Ethan Bamber","short_name":"ER Bamber","first_name":"Ethan Bamber","last_name":"","middle_name":"","birthdate":"1998-12-17","birthplace":"Westminster, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/etbamber","instagram_profile":"https:\/\/www.instagram.com\/etbamber\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","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":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"wk","role_str":"(WK)"},{"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":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":95543,"title":"Dan Mousley","short_name":"D Mousley","first_name":"Dan Mousley","last_name":"","middle_name":"","birthdate":"2001-07-08","birthplace":"Birmingham, Warwickshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/danmousley80","instagram_profile":"https:\/\/www.instagram.com\/danmousley80\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95555,"title":"George Hill","short_name":"G Hill","first_name":"George Hill","last_name":"","middle_name":"","birthdate":"2001-01-24","birthplace":"Keighley, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":95557,"title":"Dominic Leech","short_name":"D Leech","first_name":"Dominic Leech","last_name":"","middle_name":"","birthdate":"2001-01-10","birthplace":" Middlesbrough, 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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95593,"title":"Finlay Bean","short_name":"F Bean","first_name":"Finlay Bean","last_name":"","middle_name":"","birthdate":"2002-04-16","birthplace":" Harrogate, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":96059,"title":"Matthew Revis","short_name":"M Revis","first_name":"Matthew Revis","last_name":"","middle_name":"","birthdate":"2001-11-15","birthplace":" Steeton, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/matty.revis_\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":96606,"title":"Harry Duke","short_name":"H Duke","first_name":"Harry Duke","last_name":"","middle_name":"","birthdate":"2001-09-01","birthplace":"Pinderfields, Wakefield","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","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":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lintott23","instagram_profile":"https:\/\/www.instagram.com\/lintott23\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":109356,"title":"William Luxton","short_name":"W Luxton","first_name":"William Luxton","last_name":"","middle_name":"","birthdate":"2003-05-06","birthplace":"Keighley, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":109583,"title":"Hamza Shaikh","short_name":"H Shaikh","first_name":"Hamza Shaikh","last_name":"","middle_name":"","birthdate":"2006-05-29","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":110620,"title":"Michael Booth","short_name":"MG Booth","first_name":"Michael Booth","last_name":"","middle_name":"","birthdate":"2001-02-12","birthplace":" Harare","country":"za","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","role":"all","role_str":""},{"pid":112710,"title":"Benjamin Cliff","short_name":"BM Cliff","first_name":"Benjamin Cliff","last_name":"","middle_name":"","birthdate":"2002-10-23","birthplace":" Halifax, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BenjaminCliff1","instagram_profile":"https:\/\/www.instagram.com\/bencliff23\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":120400,"title":"Jafer Chohan","short_name":"JA Chohan","first_name":"Jafer Chohan","last_name":"","middle_name":"","birthdate":"2002-07-11","birthplace":"Camden, Middlesex, England","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/chohanjafar\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":127225,"title":"Yash Vagadia","short_name":"Y Vagadia","first_name":"Yash Vagadia","last_name":"","middle_name":"","birthdate":"2005-01-01","birthplace":" Newcastle","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":130019,"title":"Theo Wylie","short_name":"TO Wylie","first_name":"Theo Wylie","last_name":"","middle_name":"","birthdate":"2006-01-17","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":134957,"title":"Tazeem Chaudry Ali","short_name":"TC Ali","first_name":"Tazeem Chaudry Ali","last_name":"","middle_name":"","birthdate":"2006-06-13","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":141670,"title":"Noah M Kelly","short_name":"N M Kelly","first_name":"Noah M Kelly","last_name":"","middle_name":"","birthdate":"2005-09-21","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":146172,"title":"Alex Wade","short_name":"A Wade","first_name":"Alex Wade","last_name":"","middle_name":"","birthdate":"2006-11-28","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":147420,"title":"Jawad Akhtar","short_name":"J Akhtar","first_name":"Jawad Akhtar","last_name":"","middle_name":"","birthdate":"2005-11-19","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":150853,"title":"Vaansh Jani","short_name":"V Jani","first_name":"Vaansh Jani","last_name":"","middle_name":"","birthdate":"2005-06-06","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""}]},"etag":"6f9a77682f8ca0e522aec124903e402b","modified":"2025-08-06 09:12:24","datetime":"2025-08-06 09:12:24","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86584 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:5fe0112d-aeef-4126-8f71-0d07adf3a59a Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86584 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86584,3,'{"status":"ok","response":{"match_id":86584,"title":"Yorkshire vs Warwickshire","short_title":"YOR vs WAR","subtitle":" at Scarborough","match_number":"6","format":4,"format_str":"List A","status":2,"status_str":"Completed","status_note":"Yorkshire won by 5 wickets","verified":"false","pre_squad":"false","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129430,"title":"Metro Bank One Day Cup","abbr":"EODC","type":"tournament","category":"domestic","match_format":"lista","season":"2025","status":"live","datestart":"2025-08-05","dateend":"2025-09-20","country":"en","total_matches":"77","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":"140\/5 (32.5 ov)","scores":"140\/5","overs":"32.5"},"teamb":{"team_id":7002,"name":"Warwickshire","short_name":"WAR","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Warwickshire.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Warwickshire.png","scores_full":"137\/10 (36.3 ov)","scores":"137\/10","overs":"36.3"},"date_start":"2025-08-05 10:00:00","date_end":"2025-08-06 04:00:00","timestamp_start":1754388000,"timestamp_end":1754452800,"date_start_ist":"2025-08-05 15:30:00","date_end_ist":"2025-08-06 09:30:00","venue":{"venue_id":"43","name":"North Marine Road Ground","location":"Scarborough","country":"England","timezone":""},"umpires":"Hassan Adnan (England), Peter Hartley (England)","referee":"Ian Herbert (England)","equation":"","live":"","result":"YOR won by 5 wickets","result_type":1,"win_margin":"5 wickets","winning_team_id":7050,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"","verify_time":"2025-08-05 21:08:50","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":[],"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Yorkshire elected to bowl","winner":7050,"decision":2}},"etag":"99aeb2220b403dad8ead216cbae61aa2","modified":"2025-08-06 09:12:25","datetime":"2025-08-06 09:12:25","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":86584,"title":"Yorkshire vs Warwickshire","short_title":"YOR vs WAR","subtitle":" at Scarborough","match_number":"6","format":4,"format_str":"List A","status":2,"status_str":"Completed","status_note":"Yorkshire won by 5 wickets","verified":"false","pre_squad":"false","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129430,"title":"Metro Bank One Day Cup","abbr":"EODC","type":"tournament","category":"domestic","match_format":"lista","season":"2025","status":"live","datestart":"2025-08-05","dateend":"2025-09-20","country":"en","total_matches":"77","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":"140\/5 (32.5 ov)","scores":"140\/5","overs":"32.5"},"teamb":{"team_id":7002,"name":"Warwickshire","short_name":"WAR","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Warwickshire.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Warwickshire.png","scores_full":"137\/10 (36.3 ov)","scores":"137\/10","overs":"36.3"},"date_start":"2025-08-05 10:00:00","date_end":"2025-08-06 04:00:00","timestamp_start":1754388000,"timestamp_end":1754452800,"date_start_ist":"2025-08-05 15:30:00","date_end_ist":"2025-08-06 09:30:00","venue":{"venue_id":"43","name":"North Marine Road Ground","location":"Scarborough","country":"England","timezone":""},"umpires":"Hassan Adnan (England), Peter Hartley (England)","referee":"Ian Herbert (England)","equation":"","live":"","result":"YOR won by 5 wickets","result_type":1,"win_margin":"5 wickets","winning_team_id":7050,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"","verify_time":"2025-08-05 21:08:50","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":[],"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Yorkshire elected to bowl","winner":7050,"decision":2}},"etag":"99aeb2220b403dad8ead216cbae61aa2","modified":"2025-08-06 09:12:25","datetime":"2025-08-06 09:12:25","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86584 AND DataTypeId = 3 END
Live Report & Scorecard of Yorkshire vs Warwickshire at Scarborough
<>
CricDirect Cricket News, Results and Stats
 

Yorkshire vs Warwickshire, at Scarborough, Metro Bank One Day Cup

Completed
Metro Bank One Day Cup, Completed
Yorkshire
YOR
140/5 (32.5 ov)
Warwickshire
WAR
137/10 (36.3 ov)
Yorkshire won by 5 wickets
BATTERS R B 4S 6S SR
Harry Duke * 10 4 1 1 250.00
George Hill 20 37 3 0 54.05
BOWLERS O M R W ECON
Michael Booth * 6.5 0 29 3 4.24
Ethan Bamber 5 0 26 1 5.20
Current Partnership: 12 run (0.4 ov) | Last Wicket: Imam ul Haq 55 (83) | Fall of Wicket: 128/5 (32.2 ov)
CRR: 4.26
Recent: 66••w••1•44•114141

Yorkshire vs Warwickshire, Live Cricket Commentary

6
32.5
Michael Booth to Harry Duke, Six,
6nb
32.5
Michael Booth to Harry Duke, 6 no ball,
0
32.4
Michael Booth to Harry Duke, no run,
0
32.3
Michael Booth to Harry Duke, no run,
w
32.2
Imam ul Haq c V Jani b MG Booth 55 (83) Michael Booth to Imam ul Haq, no run, c V Jani b MG Booth,
0
32.1
Michael Booth to Imam ul Haq, no run,
End of over 32 (9 runs)
George Hill 20 (37)
Imam ul Haq 55 (81)
Yorkshire 128/4
Ethan Bamber 5-0-26-1
Jake Lintott 3-0-25-0
0
31.6
Ethan Bamber to George Hill, no run,
1
31.5
Ethan Bamber to Imam ul Haq, 1 run,
0
31.4
Ethan Bamber to Imam ul Haq, no run,
4
31.3
Ethan Bamber to Imam ul Haq, Four,
4lb
31.2
Ethan Bamber to Imam ul Haq, 4 leg bye,
0
31.1
Ethan Bamber to Imam ul Haq, no run,
End of over 31 (12 runs)
Imam ul Haq 50 (76)
George Hill 20 (36)
Yorkshire 119/4
Jake Lintott 3-0-25-0
Oliver Hannon-Dalby 10-2-31-1
1
30.6
Jake Lintott to Imam ul Haq, 1 run,
1
30.5
Jake Lintott to George Hill, 1 run,
4
30.4
Jake Lintott to George Hill, Four,
1
30.3
Jake Lintott to Imam ul Haq, 1 run,
4
30.2
Jake Lintott to Imam ul Haq, Four,
1
30.1
Jake Lintott to George Hill, 1 run,
End of over 30 (6 runs)
George Hill 14 (33)
Imam ul Haq 44 (73)
Yorkshire 107/4
Oliver Hannon-Dalby 10-2-31-1
Jake Lintott 2-0-13-0
1
29.6
Oliver Hannon-Dalby to George Hill, 1 run,
0
29.5
Oliver Hannon-Dalby to George Hill, no run,
1
29.4
Oliver Hannon-Dalby to Imam ul Haq, 1 run,
0
29.3
Oliver Hannon-Dalby to Imam ul Haq, no run,
0
29.2
Oliver Hannon-Dalby to Imam ul Haq, no run,
4
29.1
Oliver Hannon-Dalby to Imam ul Haq, Four,
End of over 29 (9 runs)
Imam ul Haq 39 (69)
George Hill 13 (31)
Yorkshire 101/4
Jake Lintott 2-0-13-0
Oliver Hannon-Dalby 9-2-25-1
1
28.6
Jake Lintott to Imam ul Haq, 1 run,
4
28.5
Jake Lintott to Imam ul Haq, Four,
1
28.4
Jake Lintott to George Hill, 1 run,
Match Details
Date
Tuesday, August 5, 2025 11:00
Venue
North Marine Road Ground, Scarborough
Toss
Yorkshire elected to bowl
Umpires
    Hassan Adnan (England)
    Peter Hartley (England)
Match Referee
    Ian Herbert (England)
× Close