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:6ba607c1-4736-4edc-9014-f79a243d02b6
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86914 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86914,1,'{"status":"ok","response":{"mid":86914,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Worcestershire won by 12 runs","day_remaining_over":"","team_batting":"Derbyshire","team_bowling":"Worcestershire","live_inning_number":2,"live_score":{"runs":162,"overs":20,"wickets":6,"target":175,"runrate":8.1,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Zak Chappell","batsman_id":49808,"runs":6,"balls_faced":5,"fours":0,"sixes":0,"strike_rate":"120.00"},{"name":"Wayne Madsen","batsman_id":48641,"runs":77,"balls_faced":53,"fours":10,"sixes":2,"strike_rate":"145.28"}],"bowlers":[{"name":"Khurram Shahzad","bowler_id":103478,"overs":4,"runs_conceded":27,"wickets":0,"maidens":0,"econ":"6.75"},{"name":"Ben Dwarshuis","bowler_id":43605,"overs":4,"runs_conceded":29,"wickets":1,"maidens":0,"econ":"7.25"}],"commentaries":[{"event_id":"12321513","event":"ball","batsman_id":"48641","bowler_id":"103478","over":"15","ball":"6","score":4,"commentary":"Khurram Shahzad to Wayne Madsen, Four,","noball_dismissal":false,"text":"","timestamp":1752179475,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event":"overend","over":16,"runs":12,"score":"134\/5","bats":[{"runs":62,"balls_faced":39,"fours":8,"sixes":2,"batsman_id":48641},{"runs":12,"balls_faced":7,"fours":1,"sixes":1,"batsman_id":51064}],"bowls":[{"runs_conceded":19,"maidens":0,"wickets":0,"bowler_id":103478,"overs":3},{"runs_conceded":33,"maidens":0,"wickets":2,"bowler_id":48645,"overs":4}],"commentary":"End of over 16 (12 runs), Derbyshire 134\/5"},{"event_id":"12321514","event":"ball","batsman_id":"51064","bowler_id":"43605","over":"16","ball":"1","score":1,"commentary":"Ben Dwarshuis to Martin Andersson, 1 run,","noball_dismissal":false,"text":"","timestamp":1752179536,"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":"12321517","event":"ball","batsman_id":"48641","bowler_id":"43605","over":"16","ball":"2","score":0,"commentary":"Ben Dwarshuis to Wayne Madsen, no run,","noball_dismissal":false,"text":"","timestamp":1752179568,"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":"12321524","event":"ball","batsman_id":"48641","bowler_id":"43605","over":"16","ball":"3","score":1,"commentary":"Ben Dwarshuis to Wayne Madsen, 1 run,","noball_dismissal":false,"text":"","timestamp":1752179684,"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":"12321527","event":"ball","batsman_id":"51064","bowler_id":"43605","over":"16","ball":"4","score":1,"commentary":"Ben Dwarshuis to Martin Andersson, 1 run,","noball_dismissal":false,"text":"","timestamp":1752179719,"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":"12321530","event":"ball","batsman_id":"48641","bowler_id":"43605","over":"16","ball":"5","score":1,"commentary":"Ben Dwarshuis to Wayne Madsen, 1 run,","noball_dismissal":false,"text":"","timestamp":1752179746,"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":"12321532","event":"ball","batsman_id":"51064","bowler_id":"43605","over":"16","ball":"6","score":1,"commentary":"Ben Dwarshuis to Martin Andersson, 1 run,","noball_dismissal":false,"text":"","timestamp":1752179777,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":17,"runs":5,"score":"139\/5","bats":[{"runs":15,"balls_faced":10,"fours":1,"sixes":1,"batsman_id":51064},{"runs":64,"balls_faced":42,"fours":8,"sixes":2,"batsman_id":48641}],"bowls":[{"runs_conceded":23,"maidens":0,"wickets":1,"bowler_id":43605,"overs":3},{"runs_conceded":19,"maidens":0,"wickets":0,"bowler_id":103478,"overs":3}],"commentary":"End of over 17 (5 runs), Derbyshire 139\/5"},{"event_id":"12321536","event":"ball","batsman_id":"51064","bowler_id":"93518","over":"17","ball":"1","score":"1lb","commentary":"Adam Finch to Martin Andersson, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1752179844,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"1","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12321540","event":"ball","batsman_id":"48641","bowler_id":"93518","over":"17","ball":"2","score":1,"commentary":"Adam Finch to Wayne Madsen, 1 run,","noball_dismissal":false,"text":"","timestamp":1752179880,"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":"12321542","event":"ball","batsman_id":"51064","bowler_id":"93518","over":"17","ball":"3","score":1,"commentary":"Adam Finch to Martin Andersson, 1 run,","noball_dismissal":false,"text":"","timestamp":1752179919,"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":"12321545","event":"ball","batsman_id":"48641","bowler_id":"93518","over":"17","ball":"4","score":4,"commentary":"Adam Finch to Wayne Madsen, Four,","noball_dismissal":false,"text":"","timestamp":1752179953,"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":"12321548","event":"wicket","batsman_id":"48641","bowler_id":"93518","over":"17","ball":"5","score":"w","commentary":"Adam Finch to Wayne Madsen, 1 run, runout (AW Finch \/ AJ Hose),","noball_dismissal":false,"text":"","timestamp":1752180129,"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,"wicket_batsman_id":"51064","how_out":"runout (AW Finch \/ AJ Hose)","batsman_runs":"16","batsman_balls":"12"},{"event_id":"12321555","event":"ball","batsman_id":"48641","bowler_id":"93518","over":"17","ball":"6","score":0,"commentary":"Adam Finch to Wayne Madsen, no run,","noball_dismissal":false,"text":"","timestamp":1752180136,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":18,"runs":8,"score":"147\/6","bats":[{"runs":70,"balls_faced":46,"fours":9,"sixes":2,"batsman_id":48641},{"runs":0,"balls_faced":0,"fours":0,"sixes":0,"batsman_id":49808}],"bowls":[{"runs_conceded":32,"maidens":0,"wickets":1,"bowler_id":93518,"overs":4},{"runs_conceded":23,"maidens":0,"wickets":1,"bowler_id":43605,"overs":3}],"commentary":"End of over 18 (8 runs), Derbyshire 147\/6"},{"event_id":"12321560","event":"ball","batsman_id":"49808","bowler_id":"43605","over":"18","ball":"1","score":2,"commentary":"Ben Dwarshuis to Zak Chappell, 2 runs,","noball_dismissal":false,"text":"","timestamp":1752180191,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12321563","event":"ball","batsman_id":"49808","bowler_id":"43605","over":"18","ball":"2","score":"1wd","commentary":"Ben Dwarshuis to Zak Chappell, 1 wide,","noball_dismissal":false,"text":"","timestamp":1752180213,"run":1,"noball_run":"0","wide_run":"1","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12321566","event":"ball","batsman_id":"49808","bowler_id":"43605","over":"18","ball":"2","score":1,"commentary":"Ben Dwarshuis to Zak Chappell, 1 run,","noball_dismissal":false,"text":"","timestamp":1752180241,"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":"12321568","event":"ball","batsman_id":"48641","bowler_id":"43605","over":"18","ball":"3","score":1,"commentary":"Ben Dwarshuis to Wayne Madsen, 1 run,","noball_dismissal":false,"text":"","timestamp":1752180279,"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":"12321569","event":"ball","batsman_id":"49808","bowler_id":"43605","over":"18","ball":"4","score":1,"commentary":"Ben Dwarshuis to Zak Chappell, 1 run,","noball_dismissal":false,"text":"","timestamp":1752180310,"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":"12321572","event":"ball","batsman_id":"48641","bowler_id":"43605","over":"18","ball":"5","score":0,"commentary":"Ben Dwarshuis to Wayne Madsen, no run,","noball_dismissal":false,"text":"","timestamp":1752180340,"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":"12321574","event":"ball","batsman_id":"48641","bowler_id":"43605","over":"18","ball":"6","score":"1lb","commentary":"Ben Dwarshuis to Wayne Madsen, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1752180373,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"1","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":19,"runs":7,"score":"154\/6","bats":[{"runs":71,"balls_faced":49,"fours":9,"sixes":2,"batsman_id":48641},{"runs":4,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":49808}],"bowls":[{"runs_conceded":29,"maidens":0,"wickets":1,"bowler_id":43605,"overs":4},{"runs_conceded":32,"maidens":0,"wickets":1,"bowler_id":93518,"overs":4}],"commentary":"End of over 19 (7 runs), Derbyshire 154\/6"},{"event_id":"12321582","event":"ball","batsman_id":"48641","bowler_id":"103478","over":"19","ball":"1","score":1,"commentary":"Khurram Shahzad to Wayne Madsen, 1 run,","noball_dismissal":false,"text":"","timestamp":1752180507,"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":"12321583","event":"ball","batsman_id":"49808","bowler_id":"103478","over":"19","ball":"2","score":1,"commentary":"Khurram Shahzad to Zak Chappell, 1 run,","noball_dismissal":false,"text":"","timestamp":1752180510,"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":"12321587","event":"ball","batsman_id":"48641","bowler_id":"103478","over":"19","ball":"3","score":4,"commentary":"Khurram Shahzad to Wayne Madsen, Four,","noball_dismissal":false,"text":"","timestamp":1752180586,"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":"12321588","event":"ball","batsman_id":"48641","bowler_id":"103478","over":"19","ball":"4","score":0,"commentary":"Khurram Shahzad to Wayne Madsen, no run,","noball_dismissal":false,"text":"","timestamp":1752180631,"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":"12321589","event":"ball","batsman_id":"48641","bowler_id":"103478","over":"19","ball":"5","score":1,"commentary":"Khurram Shahzad to Wayne Madsen, 1 run,","noball_dismissal":false,"text":"","timestamp":1752180680,"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":"12321590","event":"ball","batsman_id":"49808","bowler_id":"103478","over":"19","ball":"6","score":1,"commentary":"Khurram Shahzad to Zak Chappell, 1 run,","noball_dismissal":false,"text":"","timestamp":1752180717,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":20,"runs":8,"score":"162\/6","bats":[{"runs":6,"balls_faced":5,"fours":0,"sixes":0,"batsman_id":49808},{"runs":77,"balls_faced":53,"fours":10,"sixes":2,"batsman_id":48641}],"bowls":[{"runs_conceded":27,"maidens":0,"wickets":0,"bowler_id":103478,"overs":4},{"runs_conceded":29,"maidens":0,"wickets":1,"bowler_id":43605,"overs":4}],"commentary":"End of over 20 (8 runs), Derbyshire 162\/6"}],"day":"0","session":"0","live_inning":{"iid":199441,"number":2,"name":"Derbyshire Inning","short_name":"DER Inning","status":2,"issuperover":"false","result":4,"batting_team_id":104949,"fielding_team_id":7000,"scores":"162\/6","scores_full":"162\/6 (20 ov)","fielder":[{"fielder_id":"49521","fielder_name":"Gareth Roderick","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"49732","fielder_name":"Adam Hose","catches":1,"runout_thrower":1,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"93518","fielder_name":"Adam Finch","catches":0,"runout_thrower":0,"runout_catcher":1,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Martin Andersson","batsman_id":"51064","runs":"16","balls":"12","how_out":"runout (AW Finch \/ AJ Hose)","score_at_dismissal":147,"overs_at_dismissal":"17.5","bowler_id":"0","dismissal":"runout","number":6},"extra_runs":{"byes":0,"legbyes":8,"wides":4,"noballs":0,"penalty":"0","total":12},"equations":{"runs":162,"wickets":6,"overs":"20","bowlers_used":6,"runrate":"8.10"},"current_partnership":{"runs":15,"balls":13,"overs":2.1,"batsmen":[{"name":"Wayne Madsen","batsman_id":48641,"runs":7,"balls":8},{"name":"Zak Chappell","batsman_id":49808,"runs":6,"balls":5}]},"did_not_bat":[{"player_id":"50433","name":"Alex Thomson"},{"player_id":"84689","name":"Pat Brown"},{"player_id":"118504","name":"Allah Mohammad Ghazanfar"}],"max_over":"20","target":"175","recent_scores":"1,1,0,4,1,1,1,0,1,1,1,1,2,0,w,4,1,1","last_five_overs":"40\/1 7.74","last_ten_overs":"92\/2 9.05"},"teams":[{"tid":7000,"title":"Worcestershire","abbr":"WOR","alt_name":"WOR","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/worsestershire-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/worsestershire-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"174\/6 (20 ov)","scores":"174\/6","overs":"20"},{"tid":104949,"title":"Derbyshire","abbr":"DER","alt_name":"DER","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/derbyshire-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/derbyshire-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"162\/6 (20 ov)","scores":"162\/6","overs":"20"}],"players":[{"pid":1259,"title":"Aneurin Donald","short_name":"A Donald","first_name":"Aneurin Donald","last_name":"","middle_name":"","birthdate":"1996-12-20","birthplace":"Swansea, Glamorgan","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/aneurin.donald\/","twitter_profile":"https:\/\/twitter.com\/AneurinDonald12","instagram_profile":"https:\/\/www.instagram.com\/aneurindonald\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":1967,"title":"Henry Nicholls","short_name":"H Nicholls","first_name":"Henry Nicholls","last_name":"","middle_name":"","birthdate":"1991-11-15","birthplace":"Christchurch","country":"nz","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,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/HenryNicholls27","instagram_profile":"https:\/\/www.instagram.com\/henrynicholls27\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"squad","role_str":""},{"pid":7735,"title":"David Lloyd","short_name":"DL Lloyd","first_name":"David Lloyd","last_name":"","middle_name":"","birthdate":"1992-06-15","birthplace":"St Asaph, Flintshire, Wales","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/davidlloyduk\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":10594,"title":"Samit Patel","short_name":"SR Patel","first_name":"Samit Patel","last_name":"","middle_name":"","birthdate":"1984-11-30","birthplace":"Leicester","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/samitpatel","instagram_profile":"https:\/\/www.instagram.com\/samit._.patel\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":"(C)"},{"pid":16566,"title":"Jacob Duffy","short_name":"JA Duffy","first_name":"Jacob Duffy","last_name":"","middle_name":"","birthdate":"1994-08-02","birthplace":"","country":"nz","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"squad","role_str":""},{"pid":43360,"title":"Ross Whiteley","short_name":"RA Whiteley","first_name":"Ross Whiteley","last_name":"","middle_name":"","birthdate":"1988-09-13","birthplace":"Sheffield, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/RossWhiteley44","instagram_profile":"https:\/\/www.instagram.com\/rosswhiteley44\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":43605,"title":"Ben Dwarshuis","short_name":"BJ Dwarshuis","first_name":"Ben Dwarshuis","last_name":"","middle_name":"","birthdate":"1994-06-23","birthplace":"Kareela, New South Wales","country":"au","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/ben.dwarshuis\/","twitter_profile":"https:\/\/twitter.com\/bendwarshuis?lang=en","instagram_profile":"https:\/\/www.instagram.com\/ben_dwarshuis\/?hl=en","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"bowl","role_str":""},{"pid":46310,"title":"Blair Tickner","short_name":"BM Tickner","first_name":"Blair Tickner","last_name":"","middle_name":"","birthdate":"1993-10-13","birthplace":"Napier, Hawke''s Bay","country":"nz","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"https:\/\/www.facebook.com\/blair.tickner\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/ticks93\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"squad","role_str":""},{"pid":48428,"title":"Luis Reece","short_name":"LM Reece","first_name":"Luis Reece","last_name":"","middle_name":"","birthdate":"1990-08-04","birthplace":"Taunton, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lreece17","instagram_profile":"https:\/\/www.instagram.com\/louisreece\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":48446,"title":"Matthew Waite","short_name":"MJ Waite","first_name":"Matthew Waite","last_name":"","middle_name":"","birthdate":"1995-12-24","birthplace":"Leeds, Yorkshire","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":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/mat_waite","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":48498,"title":"Caleb Jewell","short_name":"CP Jewell","first_name":"Caleb Jewell","last_name":"","middle_name":"","birthdate":"1997-04-21","birthplace":"Hobart, Tasmania","country":"au","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/caleb.jewell.148\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/cjewell_32\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"bat","role_str":""},{"pid":48508,"title":"Brooke Guest","short_name":"BD Guest","first_name":"Brooke Guest","last_name":"","middle_name":"","birthdate":"1997-05-14","birthplace":"Whitworth Park, Manchester, England","country":"au","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/guesty211\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":48641,"title":"Wayne Madsen","short_name":"WL Madsen","first_name":"Wayne Madsen","last_name":"","middle_name":"","birthdate":"1984-01-02","birthplace":"Durban","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/waynemadders77","instagram_profile":"https:\/\/www.instagram.com\/waynemadsen77\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":48645,"title":"Tom Taylor","short_name":"TAI Taylor","first_name":"Tom Taylor","last_name":"","middle_name":"","birthdate":"1994-12-21","birthplace":" Stoke-on-Trent, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":49039,"title":"Brett D''Oliveira","short_name":"BL D''Oliveira","first_name":"Brett D''Oliveira","last_name":"","middle_name":"","birthdate":"1992-02-28","birthplace":" Worcester, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"all","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":"https:\/\/www.facebook.com\/brett.doliveira.3\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/bdolly09\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":"(C)"},{"pid":49432,"title":"Ed Pollock","short_name":"EJ Pollock","first_name":"Ed Pollock","last_name":"","middle_name":"","birthdate":"1995-07-10","birthplace":"High Wycombe, Buckinghamshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/EdPollock10","instagram_profile":"https:\/\/www.instagram.com\/edpollock10\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49521,"title":"Gareth Roderick","short_name":"GH Roderick","first_name":"Gareth Roderick","last_name":"","middle_name":"","birthdate":"1991-08-29","birthplace":"Durban, Natal","country":"za","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/roders369\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","role":"wk","role_str":"(WK)"},{"pid":49732,"title":"Adam Hose","short_name":"AJ Hose","first_name":"Adam Hose","last_name":"","middle_name":"","birthdate":"1992-10-25","birthplace":"Newport, Isle of Wight","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/adamhose21","instagram_profile":"https:\/\/www.instagram.com\/adamhose21\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":49808,"title":"Zak Chappell","short_name":"ZJ Chappell","first_name":"Zak Chappell","last_name":"","middle_name":"","birthdate":"1996-08-21","birthplace":"Grantham, Lincolnshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/chappooo","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":50433,"title":"Alex Thomson","short_name":"AT Thomson","first_name":"Alex Thomson","last_name":"","middle_name":"","birthdate":"1993-10-30","birthplace":"Stoke-on-Trent, Staffordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/alextomo","instagram_profile":"https:\/\/www.instagram.com\/alex_thomson_racing\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":50528,"title":"Anuj Dal","short_name":"AK Dal","first_name":"Anuj Dal","last_name":"","middle_name":"","birthdate":"1996-07-08","birthplace":"Newcastle-under-Lyme, Staffordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/AnujDal","instagram_profile":"https:\/\/www.instagram.com\/anujdal0\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50621,"title":"Rob Jones","short_name":"RP Jones","first_name":"Rob Jones","last_name":"","middle_name":"","birthdate":"1995-11-03","birthplace":"Warrington, Cheshire","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":5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/robpeterjones","instagram_profile":"https:\/\/www.instagram.com\/robjones119\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51064,"title":"Martin Andersson","short_name":"MK Andersson","first_name":"Martin Andersson","last_name":"","middle_name":"","birthdate":"1996-09-06","birthplace":"Reading, Berkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/MartinAnderss11","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":51094,"title":"Jake Libby","short_name":"JD Libby","first_name":"Jake Libby","last_name":"","middle_name":"","birthdate":"1993-01-03","birthplace":"Plymouth","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/JakeLibby1","instagram_profile":"https:\/\/www.instagram.com\/libbyjake\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":84689,"title":"Pat Brown","short_name":"PR Brown","first_name":"Pat Brown","last_name":"","middle_name":"","birthdate":"1998-08-23","birthplace":"Peterborough, Cambridgeshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/patbrowny\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":93518,"title":"Adam Finch","short_name":"AW Finch","first_name":"Adam Finch","last_name":"","middle_name":"","birthdate":"2000-05-28","birthplace":"Wordsley, Stourbridge, Worcestershire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":23809,"recent_appearance":1516397400,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Adamfinch00","instagram_profile":"https:\/\/www.instagram.com\/adamfinch00\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":93880,"title":"Kashif Ali","short_name":"K Ali","first_name":"Kashif Ali","last_name":"","middle_name":"","birthdate":"1998-02-07","birthplace":"Kashmir","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":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Kash798","instagram_profile":"https:\/\/www.instagram.com\/kash.ali.official\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":94962,"title":"Harry Came","short_name":"H Came","first_name":"Harry Came","last_name":"","middle_name":"","birthdate":"1998-08-27","birthplace":"Hampshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/HarryCame4","instagram_profile":"https:\/\/www.instagram.com\/harrycame4\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":94963,"title":"Jack Morley","short_name":"J Morley","first_name":"Jack Morley","last_name":"","middle_name":"","birthdate":"2001-06-25","birthplace":"Rochdale, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95892,"title":"Ben Allison","short_name":"B Allison","first_name":"Ben Allison","last_name":"","middle_name":"","birthdate":"1999-12-18","birthplace":"Colchester, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":96053,"title":"Ethan Brookes","short_name":"E Brookes","first_name":"Ethan Brookes","last_name":"","middle_name":"","birthdate":"2001-05-23","birthplace":"Solihull, Warwickshire","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":101484,"title":"Ben William Aitchison","short_name":"B W Aitchison","first_name":"Ben William Aitchison","last_name":"","middle_name":"","birthdate":"1999-07-06","birthplace":"Southport, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Benaitchison123","instagram_profile":"https:\/\/www.instagram.com\/baitchison13\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":103478,"title":"Khurram Shahzad","short_name":"K Shahzad","first_name":"Khurram Shahzad","last_name":"","middle_name":"","birthdate":"1999-11-25","birthplace":"","country":"pk","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":"Pakistan","role":"bowl","role_str":""},{"pid":108397,"title":"Tom Hinley","short_name":"T Hinley","first_name":"Tom Hinley","last_name":"","middle_name":"","birthdate":"2003-02-05","birthplace":"Frimley, 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":"https:\/\/twitter.com\/tomhinley42","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108417,"title":"Fateh Singh","short_name":"F Singh","first_name":"Fateh Singh","last_name":"","middle_name":"","birthdate":"2004-04-20","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","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":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":108454,"title":"Henry Cullen","short_name":"H Cullen","first_name":"Henry Cullen","last_name":"","middle_name":"","birthdate":"2003-04-29","birthplace":"Redditch, Worcestershire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108586,"title":"Nick Potts","short_name":"N Potts","first_name":"Nick Potts","last_name":"","middle_name":"","birthdate":"2002-07-17","birthplace":"Burton-on-Trent, Staffordshire,","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/nickwpotts\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":109363,"title":"Mitchell Wagstaff","short_name":"M Wagstaff","first_name":"Mitchell Wagstaff","last_name":"","middle_name":"","birthdate":"2003-09-02","birthplace":"Derby","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/mitchellwaggy?lang=en","instagram_profile":"https:\/\/www.instagram.com\/mitchellwagstaff\/?hl=en","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":115917,"title":"Ben Gibbon","short_name":"BJ Gibbon","first_name":"Ben Gibbon","last_name":"","middle_name":"","birthdate":"2000-06-09","birthplace":"Chester, Cheshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/bengibbon29","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":118504,"title":"Allah Mohammad Ghazanfar","short_name":"AM Ghazanfar","first_name":"Allah Mohammad Ghazanfar","last_name":"","middle_name":"","birthdate":"2007-07-15","birthplace":"","country":"af","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/Ghazanfar050\/","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Afghanistan","role":"bowl","role_str":""},{"pid":127140,"title":"Rehaan Edavalath","short_name":"RM Edavalath","first_name":"Rehaan Edavalath","last_name":"","middle_name":"","birthdate":"2004-03-04","birthplace":"Wolverhampton, Staffordshire","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":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":129744,"title":"Harry Darley","short_name":"HC Darley","first_name":"Harry Darley","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":130162,"title":"Harry Moore","short_name":"HJ Moore","first_name":"Harry Moore","last_name":"","middle_name":"","birthdate":"2007-04-26","birthplace":"Houston, Florida","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/ha66y2004","instagram_profile":"https:\/\/www.instagram.com\/harrymoore72\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":138144,"title":"Yadvinder Singh","short_name":"Y Singh","first_name":"Yadvinder Singh","last_name":"","middle_name":"","birthdate":"1996-01-18","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":141249,"title":"Jack Home","short_name":"J Home","first_name":"Jack Home","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":141343,"title":"Yousaf Bin Naeem","short_name":"YB Naeem","first_name":"Yousaf Bin Naeem","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":150036,"title":"Issac Mohammed","short_name":"I Mohammed","first_name":"Issac Mohammed","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""}]},"etag":"3d16eb4176ec5917bce3b52bb32e47e2","modified":"2025-07-15 08:23:37","datetime":"2025-07-15 08:23:37","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":86914,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Worcestershire won by 12 runs","day_remaining_over":"","team_batting":"Derbyshire","team_bowling":"Worcestershire","live_inning_number":2,"live_score":{"runs":162,"overs":20,"wickets":6,"target":175,"runrate":8.1,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Zak Chappell","batsman_id":49808,"runs":6,"balls_faced":5,"fours":0,"sixes":0,"strike_rate":"120.00"},{"name":"Wayne Madsen","batsman_id":48641,"runs":77,"balls_faced":53,"fours":10,"sixes":2,"strike_rate":"145.28"}],"bowlers":[{"name":"Khurram Shahzad","bowler_id":103478,"overs":4,"runs_conceded":27,"wickets":0,"maidens":0,"econ":"6.75"},{"name":"Ben Dwarshuis","bowler_id":43605,"overs":4,"runs_conceded":29,"wickets":1,"maidens":0,"econ":"7.25"}],"commentaries":[{"event_id":"12321513","event":"ball","batsman_id":"48641","bowler_id":"103478","over":"15","ball":"6","score":4,"commentary":"Khurram Shahzad to Wayne Madsen, Four,","noball_dismissal":false,"text":"","timestamp":1752179475,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event":"overend","over":16,"runs":12,"score":"134\/5","bats":[{"runs":62,"balls_faced":39,"fours":8,"sixes":2,"batsman_id":48641},{"runs":12,"balls_faced":7,"fours":1,"sixes":1,"batsman_id":51064}],"bowls":[{"runs_conceded":19,"maidens":0,"wickets":0,"bowler_id":103478,"overs":3},{"runs_conceded":33,"maidens":0,"wickets":2,"bowler_id":48645,"overs":4}],"commentary":"End of over 16 (12 runs), Derbyshire 134\/5"},{"event_id":"12321514","event":"ball","batsman_id":"51064","bowler_id":"43605","over":"16","ball":"1","score":1,"commentary":"Ben Dwarshuis to Martin Andersson, 1 run,","noball_dismissal":false,"text":"","timestamp":1752179536,"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":"12321517","event":"ball","batsman_id":"48641","bowler_id":"43605","over":"16","ball":"2","score":0,"commentary":"Ben Dwarshuis to Wayne Madsen, no run,","noball_dismissal":false,"text":"","timestamp":1752179568,"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":"12321524","event":"ball","batsman_id":"48641","bowler_id":"43605","over":"16","ball":"3","score":1,"commentary":"Ben Dwarshuis to Wayne Madsen, 1 run,","noball_dismissal":false,"text":"","timestamp":1752179684,"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":"12321527","event":"ball","batsman_id":"51064","bowler_id":"43605","over":"16","ball":"4","score":1,"commentary":"Ben Dwarshuis to Martin Andersson, 1 run,","noball_dismissal":false,"text":"","timestamp":1752179719,"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":"12321530","event":"ball","batsman_id":"48641","bowler_id":"43605","over":"16","ball":"5","score":1,"commentary":"Ben Dwarshuis to Wayne Madsen, 1 run,","noball_dismissal":false,"text":"","timestamp":1752179746,"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":"12321532","event":"ball","batsman_id":"51064","bowler_id":"43605","over":"16","ball":"6","score":1,"commentary":"Ben Dwarshuis to Martin Andersson, 1 run,","noball_dismissal":false,"text":"","timestamp":1752179777,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":17,"runs":5,"score":"139\/5","bats":[{"runs":15,"balls_faced":10,"fours":1,"sixes":1,"batsman_id":51064},{"runs":64,"balls_faced":42,"fours":8,"sixes":2,"batsman_id":48641}],"bowls":[{"runs_conceded":23,"maidens":0,"wickets":1,"bowler_id":43605,"overs":3},{"runs_conceded":19,"maidens":0,"wickets":0,"bowler_id":103478,"overs":3}],"commentary":"End of over 17 (5 runs), Derbyshire 139\/5"},{"event_id":"12321536","event":"ball","batsman_id":"51064","bowler_id":"93518","over":"17","ball":"1","score":"1lb","commentary":"Adam Finch to Martin Andersson, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1752179844,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"1","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12321540","event":"ball","batsman_id":"48641","bowler_id":"93518","over":"17","ball":"2","score":1,"commentary":"Adam Finch to Wayne Madsen, 1 run,","noball_dismissal":false,"text":"","timestamp":1752179880,"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":"12321542","event":"ball","batsman_id":"51064","bowler_id":"93518","over":"17","ball":"3","score":1,"commentary":"Adam Finch to Martin Andersson, 1 run,","noball_dismissal":false,"text":"","timestamp":1752179919,"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":"12321545","event":"ball","batsman_id":"48641","bowler_id":"93518","over":"17","ball":"4","score":4,"commentary":"Adam Finch to Wayne Madsen, Four,","noball_dismissal":false,"text":"","timestamp":1752179953,"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":"12321548","event":"wicket","batsman_id":"48641","bowler_id":"93518","over":"17","ball":"5","score":"w","commentary":"Adam Finch to Wayne Madsen, 1 run, runout (AW Finch \/ AJ Hose),","noball_dismissal":false,"text":"","timestamp":1752180129,"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,"wicket_batsman_id":"51064","how_out":"runout (AW Finch \/ AJ Hose)","batsman_runs":"16","batsman_balls":"12"},{"event_id":"12321555","event":"ball","batsman_id":"48641","bowler_id":"93518","over":"17","ball":"6","score":0,"commentary":"Adam Finch to Wayne Madsen, no run,","noball_dismissal":false,"text":"","timestamp":1752180136,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":18,"runs":8,"score":"147\/6","bats":[{"runs":70,"balls_faced":46,"fours":9,"sixes":2,"batsman_id":48641},{"runs":0,"balls_faced":0,"fours":0,"sixes":0,"batsman_id":49808}],"bowls":[{"runs_conceded":32,"maidens":0,"wickets":1,"bowler_id":93518,"overs":4},{"runs_conceded":23,"maidens":0,"wickets":1,"bowler_id":43605,"overs":3}],"commentary":"End of over 18 (8 runs), Derbyshire 147\/6"},{"event_id":"12321560","event":"ball","batsman_id":"49808","bowler_id":"43605","over":"18","ball":"1","score":2,"commentary":"Ben Dwarshuis to Zak Chappell, 2 runs,","noball_dismissal":false,"text":"","timestamp":1752180191,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12321563","event":"ball","batsman_id":"49808","bowler_id":"43605","over":"18","ball":"2","score":"1wd","commentary":"Ben Dwarshuis to Zak Chappell, 1 wide,","noball_dismissal":false,"text":"","timestamp":1752180213,"run":1,"noball_run":"0","wide_run":"1","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12321566","event":"ball","batsman_id":"49808","bowler_id":"43605","over":"18","ball":"2","score":1,"commentary":"Ben Dwarshuis to Zak Chappell, 1 run,","noball_dismissal":false,"text":"","timestamp":1752180241,"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":"12321568","event":"ball","batsman_id":"48641","bowler_id":"43605","over":"18","ball":"3","score":1,"commentary":"Ben Dwarshuis to Wayne Madsen, 1 run,","noball_dismissal":false,"text":"","timestamp":1752180279,"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":"12321569","event":"ball","batsman_id":"49808","bowler_id":"43605","over":"18","ball":"4","score":1,"commentary":"Ben Dwarshuis to Zak Chappell, 1 run,","noball_dismissal":false,"text":"","timestamp":1752180310,"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":"12321572","event":"ball","batsman_id":"48641","bowler_id":"43605","over":"18","ball":"5","score":0,"commentary":"Ben Dwarshuis to Wayne Madsen, no run,","noball_dismissal":false,"text":"","timestamp":1752180340,"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":"12321574","event":"ball","batsman_id":"48641","bowler_id":"43605","over":"18","ball":"6","score":"1lb","commentary":"Ben Dwarshuis to Wayne Madsen, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1752180373,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"1","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":19,"runs":7,"score":"154\/6","bats":[{"runs":71,"balls_faced":49,"fours":9,"sixes":2,"batsman_id":48641},{"runs":4,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":49808}],"bowls":[{"runs_conceded":29,"maidens":0,"wickets":1,"bowler_id":43605,"overs":4},{"runs_conceded":32,"maidens":0,"wickets":1,"bowler_id":93518,"overs":4}],"commentary":"End of over 19 (7 runs), Derbyshire 154\/6"},{"event_id":"12321582","event":"ball","batsman_id":"48641","bowler_id":"103478","over":"19","ball":"1","score":1,"commentary":"Khurram Shahzad to Wayne Madsen, 1 run,","noball_dismissal":false,"text":"","timestamp":1752180507,"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":"12321583","event":"ball","batsman_id":"49808","bowler_id":"103478","over":"19","ball":"2","score":1,"commentary":"Khurram Shahzad to Zak Chappell, 1 run,","noball_dismissal":false,"text":"","timestamp":1752180510,"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":"12321587","event":"ball","batsman_id":"48641","bowler_id":"103478","over":"19","ball":"3","score":4,"commentary":"Khurram Shahzad to Wayne Madsen, Four,","noball_dismissal":false,"text":"","timestamp":1752180586,"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":"12321588","event":"ball","batsman_id":"48641","bowler_id":"103478","over":"19","ball":"4","score":0,"commentary":"Khurram Shahzad to Wayne Madsen, no run,","noball_dismissal":false,"text":"","timestamp":1752180631,"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":"12321589","event":"ball","batsman_id":"48641","bowler_id":"103478","over":"19","ball":"5","score":1,"commentary":"Khurram Shahzad to Wayne Madsen, 1 run,","noball_dismissal":false,"text":"","timestamp":1752180680,"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":"12321590","event":"ball","batsman_id":"49808","bowler_id":"103478","over":"19","ball":"6","score":1,"commentary":"Khurram Shahzad to Zak Chappell, 1 run,","noball_dismissal":false,"text":"","timestamp":1752180717,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":20,"runs":8,"score":"162\/6","bats":[{"runs":6,"balls_faced":5,"fours":0,"sixes":0,"batsman_id":49808},{"runs":77,"balls_faced":53,"fours":10,"sixes":2,"batsman_id":48641}],"bowls":[{"runs_conceded":27,"maidens":0,"wickets":0,"bowler_id":103478,"overs":4},{"runs_conceded":29,"maidens":0,"wickets":1,"bowler_id":43605,"overs":4}],"commentary":"End of over 20 (8 runs), Derbyshire 162\/6"}],"day":"0","session":"0","live_inning":{"iid":199441,"number":2,"name":"Derbyshire Inning","short_name":"DER Inning","status":2,"issuperover":"false","result":4,"batting_team_id":104949,"fielding_team_id":7000,"scores":"162\/6","scores_full":"162\/6 (20 ov)","fielder":[{"fielder_id":"49521","fielder_name":"Gareth Roderick","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"49732","fielder_name":"Adam Hose","catches":1,"runout_thrower":1,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"93518","fielder_name":"Adam Finch","catches":0,"runout_thrower":0,"runout_catcher":1,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Martin Andersson","batsman_id":"51064","runs":"16","balls":"12","how_out":"runout (AW Finch \/ AJ Hose)","score_at_dismissal":147,"overs_at_dismissal":"17.5","bowler_id":"0","dismissal":"runout","number":6},"extra_runs":{"byes":0,"legbyes":8,"wides":4,"noballs":0,"penalty":"0","total":12},"equations":{"runs":162,"wickets":6,"overs":"20","bowlers_used":6,"runrate":"8.10"},"current_partnership":{"runs":15,"balls":13,"overs":2.1,"batsmen":[{"name":"Wayne Madsen","batsman_id":48641,"runs":7,"balls":8},{"name":"Zak Chappell","batsman_id":49808,"runs":6,"balls":5}]},"did_not_bat":[{"player_id":"50433","name":"Alex Thomson"},{"player_id":"84689","name":"Pat Brown"},{"player_id":"118504","name":"Allah Mohammad Ghazanfar"}],"max_over":"20","target":"175","recent_scores":"1,1,0,4,1,1,1,0,1,1,1,1,2,0,w,4,1,1","last_five_overs":"40\/1 7.74","last_ten_overs":"92\/2 9.05"},"teams":[{"tid":7000,"title":"Worcestershire","abbr":"WOR","alt_name":"WOR","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/worsestershire-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/worsestershire-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"174\/6 (20 ov)","scores":"174\/6","overs":"20"},{"tid":104949,"title":"Derbyshire","abbr":"DER","alt_name":"DER","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/derbyshire-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/derbyshire-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"162\/6 (20 ov)","scores":"162\/6","overs":"20"}],"players":[{"pid":1259,"title":"Aneurin Donald","short_name":"A Donald","first_name":"Aneurin Donald","last_name":"","middle_name":"","birthdate":"1996-12-20","birthplace":"Swansea, Glamorgan","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/aneurin.donald\/","twitter_profile":"https:\/\/twitter.com\/AneurinDonald12","instagram_profile":"https:\/\/www.instagram.com\/aneurindonald\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":1967,"title":"Henry Nicholls","short_name":"H Nicholls","first_name":"Henry Nicholls","last_name":"","middle_name":"","birthdate":"1991-11-15","birthplace":"Christchurch","country":"nz","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,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/HenryNicholls27","instagram_profile":"https:\/\/www.instagram.com\/henrynicholls27\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"squad","role_str":""},{"pid":7735,"title":"David Lloyd","short_name":"DL Lloyd","first_name":"David Lloyd","last_name":"","middle_name":"","birthdate":"1992-06-15","birthplace":"St Asaph, Flintshire, Wales","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/davidlloyduk\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":10594,"title":"Samit Patel","short_name":"SR Patel","first_name":"Samit Patel","last_name":"","middle_name":"","birthdate":"1984-11-30","birthplace":"Leicester","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/samitpatel","instagram_profile":"https:\/\/www.instagram.com\/samit._.patel\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":"(C)"},{"pid":16566,"title":"Jacob Duffy","short_name":"JA Duffy","first_name":"Jacob Duffy","last_name":"","middle_name":"","birthdate":"1994-08-02","birthplace":"","country":"nz","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"squad","role_str":""},{"pid":43360,"title":"Ross Whiteley","short_name":"RA Whiteley","first_name":"Ross Whiteley","last_name":"","middle_name":"","birthdate":"1988-09-13","birthplace":"Sheffield, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/RossWhiteley44","instagram_profile":"https:\/\/www.instagram.com\/rosswhiteley44\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":43605,"title":"Ben Dwarshuis","short_name":"BJ Dwarshuis","first_name":"Ben Dwarshuis","last_name":"","middle_name":"","birthdate":"1994-06-23","birthplace":"Kareela, New South Wales","country":"au","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/ben.dwarshuis\/","twitter_profile":"https:\/\/twitter.com\/bendwarshuis?lang=en","instagram_profile":"https:\/\/www.instagram.com\/ben_dwarshuis\/?hl=en","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"bowl","role_str":""},{"pid":46310,"title":"Blair Tickner","short_name":"BM Tickner","first_name":"Blair Tickner","last_name":"","middle_name":"","birthdate":"1993-10-13","birthplace":"Napier, Hawke''s Bay","country":"nz","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"https:\/\/www.facebook.com\/blair.tickner\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/ticks93\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"squad","role_str":""},{"pid":48428,"title":"Luis Reece","short_name":"LM Reece","first_name":"Luis Reece","last_name":"","middle_name":"","birthdate":"1990-08-04","birthplace":"Taunton, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lreece17","instagram_profile":"https:\/\/www.instagram.com\/louisreece\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":48446,"title":"Matthew Waite","short_name":"MJ Waite","first_name":"Matthew Waite","last_name":"","middle_name":"","birthdate":"1995-12-24","birthplace":"Leeds, Yorkshire","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":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/mat_waite","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":48498,"title":"Caleb Jewell","short_name":"CP Jewell","first_name":"Caleb Jewell","last_name":"","middle_name":"","birthdate":"1997-04-21","birthplace":"Hobart, Tasmania","country":"au","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/caleb.jewell.148\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/cjewell_32\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"bat","role_str":""},{"pid":48508,"title":"Brooke Guest","short_name":"BD Guest","first_name":"Brooke Guest","last_name":"","middle_name":"","birthdate":"1997-05-14","birthplace":"Whitworth Park, Manchester, England","country":"au","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/guesty211\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":48641,"title":"Wayne Madsen","short_name":"WL Madsen","first_name":"Wayne Madsen","last_name":"","middle_name":"","birthdate":"1984-01-02","birthplace":"Durban","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/waynemadders77","instagram_profile":"https:\/\/www.instagram.com\/waynemadsen77\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":48645,"title":"Tom Taylor","short_name":"TAI Taylor","first_name":"Tom Taylor","last_name":"","middle_name":"","birthdate":"1994-12-21","birthplace":" Stoke-on-Trent, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":49039,"title":"Brett D''Oliveira","short_name":"BL D''Oliveira","first_name":"Brett D''Oliveira","last_name":"","middle_name":"","birthdate":"1992-02-28","birthplace":" Worcester, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"all","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":"https:\/\/www.facebook.com\/brett.doliveira.3\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/bdolly09\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":"(C)"},{"pid":49432,"title":"Ed Pollock","short_name":"EJ Pollock","first_name":"Ed Pollock","last_name":"","middle_name":"","birthdate":"1995-07-10","birthplace":"High Wycombe, Buckinghamshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/EdPollock10","instagram_profile":"https:\/\/www.instagram.com\/edpollock10\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49521,"title":"Gareth Roderick","short_name":"GH Roderick","first_name":"Gareth Roderick","last_name":"","middle_name":"","birthdate":"1991-08-29","birthplace":"Durban, Natal","country":"za","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/roders369\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","role":"wk","role_str":"(WK)"},{"pid":49732,"title":"Adam Hose","short_name":"AJ Hose","first_name":"Adam Hose","last_name":"","middle_name":"","birthdate":"1992-10-25","birthplace":"Newport, Isle of Wight","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/adamhose21","instagram_profile":"https:\/\/www.instagram.com\/adamhose21\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":49808,"title":"Zak Chappell","short_name":"ZJ Chappell","first_name":"Zak Chappell","last_name":"","middle_name":"","birthdate":"1996-08-21","birthplace":"Grantham, Lincolnshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/chappooo","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":50433,"title":"Alex Thomson","short_name":"AT Thomson","first_name":"Alex Thomson","last_name":"","middle_name":"","birthdate":"1993-10-30","birthplace":"Stoke-on-Trent, Staffordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/alextomo","instagram_profile":"https:\/\/www.instagram.com\/alex_thomson_racing\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":50528,"title":"Anuj Dal","short_name":"AK Dal","first_name":"Anuj Dal","last_name":"","middle_name":"","birthdate":"1996-07-08","birthplace":"Newcastle-under-Lyme, Staffordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/AnujDal","instagram_profile":"https:\/\/www.instagram.com\/anujdal0\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50621,"title":"Rob Jones","short_name":"RP Jones","first_name":"Rob Jones","last_name":"","middle_name":"","birthdate":"1995-11-03","birthplace":"Warrington, Cheshire","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":5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/robpeterjones","instagram_profile":"https:\/\/www.instagram.com\/robjones119\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51064,"title":"Martin Andersson","short_name":"MK Andersson","first_name":"Martin Andersson","last_name":"","middle_name":"","birthdate":"1996-09-06","birthplace":"Reading, Berkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/MartinAnderss11","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":51094,"title":"Jake Libby","short_name":"JD Libby","first_name":"Jake Libby","last_name":"","middle_name":"","birthdate":"1993-01-03","birthplace":"Plymouth","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/JakeLibby1","instagram_profile":"https:\/\/www.instagram.com\/libbyjake\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":84689,"title":"Pat Brown","short_name":"PR Brown","first_name":"Pat Brown","last_name":"","middle_name":"","birthdate":"1998-08-23","birthplace":"Peterborough, Cambridgeshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/patbrowny\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":93518,"title":"Adam Finch","short_name":"AW Finch","first_name":"Adam Finch","last_name":"","middle_name":"","birthdate":"2000-05-28","birthplace":"Wordsley, Stourbridge, Worcestershire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":23809,"recent_appearance":1516397400,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Adamfinch00","instagram_profile":"https:\/\/www.instagram.com\/adamfinch00\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":93880,"title":"Kashif Ali","short_name":"K Ali","first_name":"Kashif Ali","last_name":"","middle_name":"","birthdate":"1998-02-07","birthplace":"Kashmir","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":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Kash798","instagram_profile":"https:\/\/www.instagram.com\/kash.ali.official\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":94962,"title":"Harry Came","short_name":"H Came","first_name":"Harry Came","last_name":"","middle_name":"","birthdate":"1998-08-27","birthplace":"Hampshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/HarryCame4","instagram_profile":"https:\/\/www.instagram.com\/harrycame4\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":94963,"title":"Jack Morley","short_name":"J Morley","first_name":"Jack Morley","last_name":"","middle_name":"","birthdate":"2001-06-25","birthplace":"Rochdale, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95892,"title":"Ben Allison","short_name":"B Allison","first_name":"Ben Allison","last_name":"","middle_name":"","birthdate":"1999-12-18","birthplace":"Colchester, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":96053,"title":"Ethan Brookes","short_name":"E Brookes","first_name":"Ethan Brookes","last_name":"","middle_name":"","birthdate":"2001-05-23","birthplace":"Solihull, Warwickshire","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":101484,"title":"Ben William Aitchison","short_name":"B W Aitchison","first_name":"Ben William Aitchison","last_name":"","middle_name":"","birthdate":"1999-07-06","birthplace":"Southport, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Benaitchison123","instagram_profile":"https:\/\/www.instagram.com\/baitchison13\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":103478,"title":"Khurram Shahzad","short_name":"K Shahzad","first_name":"Khurram Shahzad","last_name":"","middle_name":"","birthdate":"1999-11-25","birthplace":"","country":"pk","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":"Pakistan","role":"bowl","role_str":""},{"pid":108397,"title":"Tom Hinley","short_name":"T Hinley","first_name":"Tom Hinley","last_name":"","middle_name":"","birthdate":"2003-02-05","birthplace":"Frimley, 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":"https:\/\/twitter.com\/tomhinley42","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108417,"title":"Fateh Singh","short_name":"F Singh","first_name":"Fateh Singh","last_name":"","middle_name":"","birthdate":"2004-04-20","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","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":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":108454,"title":"Henry Cullen","short_name":"H Cullen","first_name":"Henry Cullen","last_name":"","middle_name":"","birthdate":"2003-04-29","birthplace":"Redditch, Worcestershire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108586,"title":"Nick Potts","short_name":"N Potts","first_name":"Nick Potts","last_name":"","middle_name":"","birthdate":"2002-07-17","birthplace":"Burton-on-Trent, Staffordshire,","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/nickwpotts\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":109363,"title":"Mitchell Wagstaff","short_name":"M Wagstaff","first_name":"Mitchell Wagstaff","last_name":"","middle_name":"","birthdate":"2003-09-02","birthplace":"Derby","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/mitchellwaggy?lang=en","instagram_profile":"https:\/\/www.instagram.com\/mitchellwagstaff\/?hl=en","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":115917,"title":"Ben Gibbon","short_name":"BJ Gibbon","first_name":"Ben Gibbon","last_name":"","middle_name":"","birthdate":"2000-06-09","birthplace":"Chester, Cheshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/bengibbon29","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":118504,"title":"Allah Mohammad Ghazanfar","short_name":"AM Ghazanfar","first_name":"Allah Mohammad Ghazanfar","last_name":"","middle_name":"","birthdate":"2007-07-15","birthplace":"","country":"af","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/Ghazanfar050\/","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Afghanistan","role":"bowl","role_str":""},{"pid":127140,"title":"Rehaan Edavalath","short_name":"RM Edavalath","first_name":"Rehaan Edavalath","last_name":"","middle_name":"","birthdate":"2004-03-04","birthplace":"Wolverhampton, Staffordshire","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":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":129744,"title":"Harry Darley","short_name":"HC Darley","first_name":"Harry Darley","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":130162,"title":"Harry Moore","short_name":"HJ Moore","first_name":"Harry Moore","last_name":"","middle_name":"","birthdate":"2007-04-26","birthplace":"Houston, Florida","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/ha66y2004","instagram_profile":"https:\/\/www.instagram.com\/harrymoore72\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":138144,"title":"Yadvinder Singh","short_name":"Y Singh","first_name":"Yadvinder Singh","last_name":"","middle_name":"","birthdate":"1996-01-18","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":141249,"title":"Jack Home","short_name":"J Home","first_name":"Jack Home","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":141343,"title":"Yousaf Bin Naeem","short_name":"YB Naeem","first_name":"Yousaf Bin Naeem","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":150036,"title":"Issac Mohammed","short_name":"I Mohammed","first_name":"Issac Mohammed","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""}]},"etag":"3d16eb4176ec5917bce3b52bb32e47e2","modified":"2025-07-15 08:23:37","datetime":"2025-07-15 08:23:37","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86914 AND DataTypeId = 1 END
System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'StatusId'.
Invalid column name 'ErrorLog'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Etoz.ConnectData.DataAccess.ExecuteQuery(String query) in c:\inetpub\wwwroot\cricdirect.com\api\v6\App_Code\db\data_access.cs:line 117
ClientConnectionId:0e1b136a-02a0-471f-b34b-6750364a6458
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86914 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86914,3,'{"status":"ok","response":{"match_id":86914,"title":"Derbyshire vs Worcestershire","short_title":"DER vs WOR","subtitle":"Match 94","match_number":"94","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Worcestershire won by 12 runs","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129425,"title":"Vitality Blast","abbr":"Vitality Blast","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-09-13","country":"en","total_matches":"133","total_rounds":"2","total_teams":"18"},"teama":{"team_id":104949,"name":"Derbyshire","short_name":"DER","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/derbyshire-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/derbyshire-logo.png","scores_full":"162\/6 (20 ov)","scores":"162\/6","overs":"20"},"teamb":{"team_id":7000,"name":"Worcestershire","short_name":"WOR","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/worsestershire-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/worsestershire-logo.png","scores_full":"174\/6 (20 ov)","scores":"174\/6","overs":"20"},"date_start":"2025-07-10 18:00:00","date_end":"2025-07-11 04:00:00","timestamp_start":1752170400,"timestamp_end":1752206400,"date_start_ist":"2025-07-10 23:30:00","date_end_ist":"2025-07-11 09:30:00","venue":{"venue_id":"49","name":"County Ground","location":"Derby","country":"England","timezone":""},"umpires":"James Middlebrook (England), Tom Lungley (England), Rob White (England, TV)","referee":"Wayne Noon (England)","equation":"","live":"","result":"WOR won by 12 runs","result_type":2,"win_margin":"12 runs","winning_team_id":7000,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-07-10 00:12:31","verify_time":"2025-07-11 02:36:34","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":21.98,"humidity":57,"visibility":10000,"wind_speed":"6.04","clouds":100},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Worcestershire elected to bat","winner":7000,"decision":1}},"etag":"fc9ad32fc3dafb325a2c432e782f849e","modified":"2025-07-15 08:23:38","datetime":"2025-07-15 08:23:38","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":86914,"title":"Derbyshire vs Worcestershire","short_title":"DER vs WOR","subtitle":"Match 94","match_number":"94","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Worcestershire won by 12 runs","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129425,"title":"Vitality Blast","abbr":"Vitality Blast","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-09-13","country":"en","total_matches":"133","total_rounds":"2","total_teams":"18"},"teama":{"team_id":104949,"name":"Derbyshire","short_name":"DER","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/derbyshire-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/derbyshire-logo.png","scores_full":"162\/6 (20 ov)","scores":"162\/6","overs":"20"},"teamb":{"team_id":7000,"name":"Worcestershire","short_name":"WOR","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/worsestershire-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/worsestershire-logo.png","scores_full":"174\/6 (20 ov)","scores":"174\/6","overs":"20"},"date_start":"2025-07-10 18:00:00","date_end":"2025-07-11 04:00:00","timestamp_start":1752170400,"timestamp_end":1752206400,"date_start_ist":"2025-07-10 23:30:00","date_end_ist":"2025-07-11 09:30:00","venue":{"venue_id":"49","name":"County Ground","location":"Derby","country":"England","timezone":""},"umpires":"James Middlebrook (England), Tom Lungley (England), Rob White (England, TV)","referee":"Wayne Noon (England)","equation":"","live":"","result":"WOR won by 12 runs","result_type":2,"win_margin":"12 runs","winning_team_id":7000,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-07-10 00:12:31","verify_time":"2025-07-11 02:36:34","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":21.98,"humidity":57,"visibility":10000,"wind_speed":"6.04","clouds":100},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Worcestershire elected to bat","winner":7000,"decision":1}},"etag":"fc9ad32fc3dafb325a2c432e782f849e","modified":"2025-07-15 08:23:38","datetime":"2025-07-15 08:23:38","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86914 AND DataTypeId = 3 END Live Report & Scorecard of Derbyshire vs Worcestershire Match 94
Derbyshire vs Worcestershire, Live Cricket Commentary