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:acf69159-c8df-43f2-bfc8-f43d022dca1b Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86920 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86920,1,'{"status":"ok","response":{"mid":86920,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Northamptonshire won by 13 runs","day_remaining_over":"","team_batting":"Derbyshire","team_bowling":"Northamptonshire","live_inning_number":2,"live_score":{"runs":224,"overs":20,"wickets":6,"target":238,"runrate":11.2,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Harry Came","batsman_id":94962,"runs":35,"balls_faced":25,"fours":1,"sixes":3,"strike_rate":"140.00"},{"name":"Alex Thomson","batsman_id":50433,"runs":0,"balls_faced":2,"fours":0,"sixes":0,"strike_rate":"0.00"}],"bowlers":[{"name":"Luke Procter","bowler_id":48438,"overs":4,"runs_conceded":39,"wickets":2,"maidens":0,"econ":"9.80"},{"name":"Ben Sanderson","bowler_id":49814,"overs":4,"runs_conceded":36,"wickets":0,"maidens":0,"econ":"9.00"}],"commentaries":[{"event_id":"12328061","event":"ball","batsman_id":"10594","bowler_id":"48438","over":"15","ball":"6","score":2,"commentary":"Luke Procter to Samit Patel, 2 runs,","noball_dismissal":false,"text":"","timestamp":1752264737,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":16,"runs":10,"score":"186\/5","bats":[{"runs":5,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":10594},{"runs":15,"balls_faced":14,"fours":0,"sixes":1,"batsman_id":94962}],"bowls":[{"runs_conceded":32,"maidens":0,"wickets":1,"bowler_id":48438,"overs":3},{"runs_conceded":56,"maidens":0,"wickets":2,"bowler_id":50387,"overs":4}],"commentary":"End of over 16 (10 runs), Derbyshire 186\/5"},{"event_id":"12328093","event":"ball","batsman_id":"94962","bowler_id":"49814","over":"16","ball":"1","score":0,"commentary":"Ben Sanderson to Harry Came, no run,","noball_dismissal":false,"text":"","timestamp":1752264909,"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":"12328095","event":"ball","batsman_id":"94962","bowler_id":"49814","over":"16","ball":"2","score":6,"commentary":"Ben Sanderson to Harry Came, Six,","noball_dismissal":false,"text":"","timestamp":1752264912,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12328096","event":"ball","batsman_id":"94962","bowler_id":"49814","over":"16","ball":"3","score":0,"commentary":"Ben Sanderson to Harry Came, no run,","noball_dismissal":false,"text":"","timestamp":1752264915,"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":"12328098","event":"ball","batsman_id":"94962","bowler_id":"49814","over":"16","ball":"4","score":1,"commentary":"Ben Sanderson to Harry Came, 1 run,","noball_dismissal":false,"text":"","timestamp":1752264918,"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":"12328102","event":"ball","batsman_id":"10594","bowler_id":"49814","over":"16","ball":"5","score":0,"commentary":"Ben Sanderson to Samit Patel, no run,","noball_dismissal":false,"text":"","timestamp":1752264921,"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":"12328103","event":"ball","batsman_id":"10594","bowler_id":"49814","over":"16","ball":"6","score":1,"commentary":"Ben Sanderson to Samit Patel, 1 run,","noball_dismissal":false,"text":"","timestamp":1752264924,"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":8,"score":"194\/5","bats":[{"runs":6,"balls_faced":5,"fours":0,"sixes":0,"batsman_id":10594},{"runs":22,"balls_faced":18,"fours":0,"sixes":2,"batsman_id":94962}],"bowls":[{"runs_conceded":25,"maidens":0,"wickets":0,"bowler_id":49814,"overs":3},{"runs_conceded":32,"maidens":0,"wickets":1,"bowler_id":48438,"overs":3}],"commentary":"End of over 17 (8 runs), Derbyshire 194\/5"},{"event_id":"12328117","event":"ball","batsman_id":"10594","bowler_id":"1935","over":"17","ball":"1","score":1,"commentary":"David Willey to Samit Patel, 1 run,","noball_dismissal":false,"text":"","timestamp":1752264987,"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":"12328118","event":"ball","batsman_id":"94962","bowler_id":"1935","over":"17","ball":"2","score":1,"commentary":"David Willey to Harry Came, 1 run,","noball_dismissal":false,"text":"","timestamp":1752264990,"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":"12328119","event":"ball","batsman_id":"10594","bowler_id":"1935","over":"17","ball":"3","score":1,"commentary":"David Willey to Samit Patel, 1 run,","noball_dismissal":false,"text":"","timestamp":1752264995,"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":"12328135","event":"ball","batsman_id":"94962","bowler_id":"1935","over":"17","ball":"4","score":"4nb","commentary":"David Willey to Harry Came, 4 no ball,","noball_dismissal":false,"text":"","timestamp":1752265080,"run":4,"noball_run":"1","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":true,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12328136","event":"ball","batsman_id":"94962","bowler_id":"1935","over":"17","ball":"4","score":"1lb","commentary":"David Willey to Harry Came, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1752266130,"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":"12328155","event":"ball","batsman_id":"10594","bowler_id":"1935","over":"17","ball":"5","score":0,"commentary":"David Willey to Samit Patel, no run,","noball_dismissal":false,"text":"","timestamp":1752265239,"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":"12328160","event":"ball","batsman_id":"10594","bowler_id":"1935","over":"17","ball":"6","score":4,"commentary":"David Willey to Samit Patel, Four,","noball_dismissal":false,"text":"","timestamp":1752265242,"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":18,"runs":12,"score":"206\/5","bats":[{"runs":12,"balls_faced":9,"fours":1,"sixes":0,"batsman_id":10594},{"runs":25,"balls_faced":21,"fours":0,"sixes":2,"batsman_id":94962}],"bowls":[{"runs_conceded":42,"maidens":0,"wickets":0,"bowler_id":1935,"overs":4},{"runs_conceded":25,"maidens":0,"wickets":0,"bowler_id":49814,"overs":3}],"commentary":"End of over 18 (12 runs), Derbyshire 206\/5"},{"event_id":"12328162","event":"ball","batsman_id":"94962","bowler_id":"49814","over":"18","ball":"1","score":"1lb","commentary":"Ben Sanderson to Harry Came, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1752265279,"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":"12328165","event":"ball","batsman_id":"10594","bowler_id":"49814","over":"18","ball":"2","score":0,"commentary":"Ben Sanderson to Samit Patel, no run,","noball_dismissal":false,"text":"","timestamp":1752265282,"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":"12328166","event":"ball","batsman_id":"10594","bowler_id":"49814","over":"18","ball":"3","score":1,"commentary":"Ben Sanderson to Samit Patel, 1 run,","noball_dismissal":false,"text":"","timestamp":1752265286,"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":"12328168","event":"ball","batsman_id":"94962","bowler_id":"49814","over":"18","ball":"4","score":6,"commentary":"Ben Sanderson to Harry Came, Six,","noball_dismissal":false,"text":"","timestamp":1752265289,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12328171","event":"ball","batsman_id":"94962","bowler_id":"49814","over":"18","ball":"5","score":0,"commentary":"Ben Sanderson to Harry Came, no run,","noball_dismissal":false,"text":"","timestamp":1752265301,"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":"12328175","event":"ball","batsman_id":"94962","bowler_id":"49814","over":"18","ball":"6","score":4,"commentary":"Ben Sanderson to Harry Came, Four,","noball_dismissal":false,"text":"","timestamp":1752265341,"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":19,"runs":12,"score":"218\/5","bats":[{"runs":35,"balls_faced":25,"fours":1,"sixes":3,"batsman_id":94962},{"runs":13,"balls_faced":11,"fours":1,"sixes":0,"batsman_id":10594}],"bowls":[{"runs_conceded":36,"maidens":0,"wickets":0,"bowler_id":49814,"overs":4},{"runs_conceded":42,"maidens":0,"wickets":0,"bowler_id":1935,"overs":4}],"commentary":"End of over 19 (12 runs), Derbyshire 218\/5"},{"event_id":"12328194","event":"ball","batsman_id":"10594","bowler_id":"48438","over":"19","ball":"1","score":4,"commentary":"Luke Procter to Samit Patel, Four,","noball_dismissal":false,"text":"","timestamp":1752265464,"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":"12328195","event":"ball","batsman_id":"10594","bowler_id":"48438","over":"19","ball":"2","score":0,"commentary":"Luke Procter to Samit Patel, no run,","noball_dismissal":false,"text":"","timestamp":1752265468,"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":"12328199","event":"ball","batsman_id":"10594","bowler_id":"48438","over":"19","ball":"3","score":2,"commentary":"Luke Procter to Samit Patel, 2 runs,","noball_dismissal":false,"text":"","timestamp":1752265849,"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":"12328205","event":"wicket","batsman_id":"10594","bowler_id":"48438","over":"19","ball":"4","score":"w","commentary":"Luke Procter to Samit Patel, no run, c LD McManus b LA Procter,","noball_dismissal":false,"text":"","timestamp":1752265893,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"10594","how_out":"c LD McManus b LA Procter","batsman_runs":"19","batsman_balls":"15"},{"event_id":"12328218","event":"ball","batsman_id":"50433","bowler_id":"48438","over":"19","ball":"5","score":0,"commentary":"Luke Procter to Alex Thomson, no run,","noball_dismissal":false,"text":"","timestamp":1752265879,"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":"12328246","event":"ball","batsman_id":"50433","bowler_id":"48438","over":"19","ball":"6","score":0,"commentary":"Luke Procter to Alex Thomson, no run,","noball_dismissal":false,"text":"","timestamp":1752265897,"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":20,"runs":6,"score":"224\/6","bats":[{"runs":0,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":50433},{"runs":35,"balls_faced":25,"fours":1,"sixes":3,"batsman_id":94962}],"bowls":[{"runs_conceded":38,"maidens":0,"wickets":2,"bowler_id":48438,"overs":4},{"runs_conceded":36,"maidens":0,"wickets":0,"bowler_id":49814,"overs":4}],"commentary":"End of over 20 (6 runs), Derbyshire 224\/6"}],"day":"0","session":"0","live_inning":{"iid":199495,"number":2,"name":"Derbyshire Inning","short_name":"DER Inning","status":2,"issuperover":"false","result":4,"batting_team_id":104949,"fielding_team_id":7038,"scores":"224\/6","scores_full":"224\/6 (20 ov)","fielder":[{"fielder_id":"50478","fielder_name":"Lewis McManus","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"49814","fielder_name":"Ben Sanderson","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"1935","fielder_name":"David Willey","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Samit Patel","batsman_id":"10594","runs":"19","balls":"15","how_out":"c LD McManus b LA Procter","score_at_dismissal":224,"overs_at_dismissal":"19.4","bowler_id":"48438","dismissal":"caught","number":6},"extra_runs":{"byes":0,"legbyes":7,"wides":2,"noballs":4,"penalty":"0","total":13},"equations":{"runs":224,"wickets":6,"overs":"20","bowlers_used":6,"runrate":"11.20"},"current_partnership":{"runs":0,"balls":2,"overs":0.2,"batsmen":[{"name":"Alex Thomson","batsman_id":50433,"runs":0,"balls":2},{"name":"Harry Came","batsman_id":94962,"runs":0,"balls":0}]},"did_not_bat":[{"player_id":"49808","name":"Zak Chappell"},{"player_id":"118504","name":"Allah Mohammad Ghazanfar"},{"player_id":"101484","name":"Ben William Aitchison"}],"max_over":"20","target":"238","recent_scores":"0,0,w,2,0,4,4,0,6,1,0,1,4,0,1,4,1,1","last_five_overs":"48\/2 9.00","last_ten_overs":"93\/4 8.72"},"teams":[{"tid":7038,"title":"Northamptonshire","abbr":"NOR","alt_name":"NOR","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/northamptonshire-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/northamptonshire-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"237\/4 (20 ov)","scores":"237\/4","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":"224\/6 (20 ov)","scores":"224\/6","overs":"20"}],"players":[{"pid":474,"title":"Ravi Bopara","short_name":"R Bopara","first_name":"Ravi Bopara","last_name":"","middle_name":"","birthdate":"1985-05-04","birthplace":" Forest Gate, London","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/ravibopara","instagram_profile":"https:\/\/www.instagram.com\/ravibopara\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":1046,"title":"George Bartlett","short_name":"GA Bartlett","first_name":"George Bartlett","last_name":"","middle_name":"","birthdate":"1998-03-14","birthplace":"Frimley, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":1259,"title":"Aneurin Donald","short_name":"A Donald","first_name":"Aneurin Donald","last_name":"","middle_name":"","birthdate":"1996-12-20","birthplace":"Swansea, Glamorgan","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/aneurin.donald\/","twitter_profile":"https:\/\/twitter.com\/AneurinDonald12","instagram_profile":"https:\/\/www.instagram.com\/aneurindonald\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":1935,"title":"David Willey","short_name":"D Willey","first_name":"David Willey","last_name":"","middle_name":"","birthdate":"1990-02-28","birthplace":"Northampton","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":18974,"recent_appearance":1517109600,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/DavidWilleyCricket\/","twitter_profile":"https:\/\/twitter.com\/david_willey","instagram_profile":"https:\/\/www.instagram.com\/david_willey72\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":"(C)"},{"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":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":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":46852,"title":"Matthew Breetzke","short_name":"MP Breetzke","first_name":"Matthew Breetzke","last_name":"","middle_name":"","birthdate":"1998-11-03","birthplace":"Gqeberha, South Africa","country":"za","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":23791,"recent_appearance":1515879000,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/matt_03_","instagram_profile":"https:\/\/www.instagram.com\/i3mbreetzke\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"wk","role_str":""},{"pid":46884,"title":"Ricardo Vasconcelos","short_name":"Rs Vasconcelos","first_name":"Ricardo Vasconcelos","last_name":"","middle_name":"","birthdate":"1997-10-27","birthplace":" Johannesburg, Gauteng","country":"za","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":7.5,"facebook_profile":"https:\/\/www.facebook.com\/ricardo.vasconcelos.169\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/ricardo27vasco\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bat","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":48438,"title":"Luke Procter","short_name":"LA Procter","first_name":"Luke Procter","last_name":"","middle_name":"","birthdate":"1988-06-24","birthplace":" Oldham, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","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":49372,"title":"Rob Keogh","short_name":"RI Keogh","first_name":"Rob Keogh","last_name":"","middle_name":"","birthdate":"1991-10-21","birthplace":" Dunstable, United","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49770,"title":"Saif Zaib","short_name":"SA Zaib","first_name":"Saif Zaib","last_name":"","middle_name":"","birthdate":"1998-05-22","birthplace":" High Wycombe, Buckinghamshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/zaib_05","instagram_profile":"https:\/\/www.instagram.com\/saif_zaib18\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","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":49814,"title":"Ben Sanderson","short_name":"BW Sanderson","first_name":"Ben Sanderson","last_name":"","middle_name":"","birthdate":"1989-01-03","birthplace":"Sheffield, Yorkshire","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":50387,"title":"George Scrimshaw","short_name":"GLS Scrimshaw","first_name":"George Scrimshaw","last_name":"","middle_name":"","birthdate":"1998-02-10","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":7.5,"facebook_profile":"https:\/\/www.facebook.com\/george.scrimshaw.1\/","twitter_profile":"https:\/\/twitter.com\/Gscrimshaw98","instagram_profile":"https:\/\/www.instagram.com\/gscrimshaw9\/","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":50478,"title":"Lewis McManus","short_name":"LD McManus","first_name":"Lewis McManus","last_name":"","middle_name":"","birthdate":"1994-10-09","birthplace":"Poole Hospital","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lewis_mcmanus","instagram_profile":"https:\/\/www.instagram.com\/lewismcmanus18\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"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":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":52878,"title":"Liam Guthrie","short_name":"L Guthrie","first_name":"Liam Guthrie","last_name":"","middle_name":"","birthdate":"1997-04-09","birthplace":"","country":"au","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/lguthrie7\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","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":"squad","role_str":""},{"pid":93459,"title":"Lloyd Pope","short_name":"L Pope","first_name":"Lloyd Pope","last_name":"","middle_name":"","birthdate":"1999-12-01","birthplace":"","country":"au","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":23792,"recent_appearance":1515891600,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/lloydpoonslayer69\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/lloyd_pope24\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Australia","role":"bowl","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":95557,"title":"Dominic Leech","short_name":"D Leech","first_name":"Dominic Leech","last_name":"","middle_name":"","birthdate":"2001-01-10","birthplace":" Middlesbrough, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":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":"bowl","role_str":""},{"pid":108384,"title":"Justin Broad","short_name":"J Broad","first_name":"Justin Broad","last_name":"","middle_name":"","birthdate":"2000-06-30","birthplace":"Cape Town, South Africa","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":108411,"title":"Gus Miller","short_name":"G Miller","first_name":"Gus Miller","last_name":"","middle_name":"","birthdate":"2002-01-08","birthplace":"Oxford","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108414,"title":"Freddie Heldreich","short_name":"F Heldreich","first_name":"Freddie Heldreich","last_name":"","middle_name":"","birthdate":"2001-09-12","birthplace":"Ipswich, Suffolk","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Wrist Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108418,"title":"James Sales","short_name":"J Sales","first_name":"James Sales","last_name":"","middle_name":"","birthdate":"2003-02-11","birthplace":"Northampton","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","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":114663,"title":"Tim Robinson","short_name":"T Robinson","first_name":"Tim Robinson","last_name":"","middle_name":"","birthdate":"2002-04-28","birthplace":"","country":"nz","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":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","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":118723,"title":"Arush Buchake","short_name":"A Buchake","first_name":"Arush Buchake","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","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":118724,"title":"Aadi Sharma","short_name":"A Sharma","first_name":"Aadi Sharma","last_name":"","middle_name":"","birthdate":"2006-02-23","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","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":130479,"title":"Raphael Weatherall","short_name":"R Weatherall","first_name":"Raphael Weatherall","last_name":"","middle_name":"","birthdate":"2004-10-24","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"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":148504,"title":"Tiaan Louw","short_name":"T Louw","first_name":"Tiaan Louw","last_name":"","middle_name":"","birthdate":"2006-04-16","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""}]},"etag":"168bfcc2f53a06138b2b18b8d2aa41bc","modified":"2025-07-16 01:19:42","datetime":"2025-07-16 01:19:42","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":86920,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Northamptonshire won by 13 runs","day_remaining_over":"","team_batting":"Derbyshire","team_bowling":"Northamptonshire","live_inning_number":2,"live_score":{"runs":224,"overs":20,"wickets":6,"target":238,"runrate":11.2,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Harry Came","batsman_id":94962,"runs":35,"balls_faced":25,"fours":1,"sixes":3,"strike_rate":"140.00"},{"name":"Alex Thomson","batsman_id":50433,"runs":0,"balls_faced":2,"fours":0,"sixes":0,"strike_rate":"0.00"}],"bowlers":[{"name":"Luke Procter","bowler_id":48438,"overs":4,"runs_conceded":39,"wickets":2,"maidens":0,"econ":"9.80"},{"name":"Ben Sanderson","bowler_id":49814,"overs":4,"runs_conceded":36,"wickets":0,"maidens":0,"econ":"9.00"}],"commentaries":[{"event_id":"12328061","event":"ball","batsman_id":"10594","bowler_id":"48438","over":"15","ball":"6","score":2,"commentary":"Luke Procter to Samit Patel, 2 runs,","noball_dismissal":false,"text":"","timestamp":1752264737,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":16,"runs":10,"score":"186\/5","bats":[{"runs":5,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":10594},{"runs":15,"balls_faced":14,"fours":0,"sixes":1,"batsman_id":94962}],"bowls":[{"runs_conceded":32,"maidens":0,"wickets":1,"bowler_id":48438,"overs":3},{"runs_conceded":56,"maidens":0,"wickets":2,"bowler_id":50387,"overs":4}],"commentary":"End of over 16 (10 runs), Derbyshire 186\/5"},{"event_id":"12328093","event":"ball","batsman_id":"94962","bowler_id":"49814","over":"16","ball":"1","score":0,"commentary":"Ben Sanderson to Harry Came, no run,","noball_dismissal":false,"text":"","timestamp":1752264909,"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":"12328095","event":"ball","batsman_id":"94962","bowler_id":"49814","over":"16","ball":"2","score":6,"commentary":"Ben Sanderson to Harry Came, Six,","noball_dismissal":false,"text":"","timestamp":1752264912,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12328096","event":"ball","batsman_id":"94962","bowler_id":"49814","over":"16","ball":"3","score":0,"commentary":"Ben Sanderson to Harry Came, no run,","noball_dismissal":false,"text":"","timestamp":1752264915,"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":"12328098","event":"ball","batsman_id":"94962","bowler_id":"49814","over":"16","ball":"4","score":1,"commentary":"Ben Sanderson to Harry Came, 1 run,","noball_dismissal":false,"text":"","timestamp":1752264918,"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":"12328102","event":"ball","batsman_id":"10594","bowler_id":"49814","over":"16","ball":"5","score":0,"commentary":"Ben Sanderson to Samit Patel, no run,","noball_dismissal":false,"text":"","timestamp":1752264921,"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":"12328103","event":"ball","batsman_id":"10594","bowler_id":"49814","over":"16","ball":"6","score":1,"commentary":"Ben Sanderson to Samit Patel, 1 run,","noball_dismissal":false,"text":"","timestamp":1752264924,"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":8,"score":"194\/5","bats":[{"runs":6,"balls_faced":5,"fours":0,"sixes":0,"batsman_id":10594},{"runs":22,"balls_faced":18,"fours":0,"sixes":2,"batsman_id":94962}],"bowls":[{"runs_conceded":25,"maidens":0,"wickets":0,"bowler_id":49814,"overs":3},{"runs_conceded":32,"maidens":0,"wickets":1,"bowler_id":48438,"overs":3}],"commentary":"End of over 17 (8 runs), Derbyshire 194\/5"},{"event_id":"12328117","event":"ball","batsman_id":"10594","bowler_id":"1935","over":"17","ball":"1","score":1,"commentary":"David Willey to Samit Patel, 1 run,","noball_dismissal":false,"text":"","timestamp":1752264987,"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":"12328118","event":"ball","batsman_id":"94962","bowler_id":"1935","over":"17","ball":"2","score":1,"commentary":"David Willey to Harry Came, 1 run,","noball_dismissal":false,"text":"","timestamp":1752264990,"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":"12328119","event":"ball","batsman_id":"10594","bowler_id":"1935","over":"17","ball":"3","score":1,"commentary":"David Willey to Samit Patel, 1 run,","noball_dismissal":false,"text":"","timestamp":1752264995,"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":"12328135","event":"ball","batsman_id":"94962","bowler_id":"1935","over":"17","ball":"4","score":"4nb","commentary":"David Willey to Harry Came, 4 no ball,","noball_dismissal":false,"text":"","timestamp":1752265080,"run":4,"noball_run":"1","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":true,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12328136","event":"ball","batsman_id":"94962","bowler_id":"1935","over":"17","ball":"4","score":"1lb","commentary":"David Willey to Harry Came, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1752266130,"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":"12328155","event":"ball","batsman_id":"10594","bowler_id":"1935","over":"17","ball":"5","score":0,"commentary":"David Willey to Samit Patel, no run,","noball_dismissal":false,"text":"","timestamp":1752265239,"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":"12328160","event":"ball","batsman_id":"10594","bowler_id":"1935","over":"17","ball":"6","score":4,"commentary":"David Willey to Samit Patel, Four,","noball_dismissal":false,"text":"","timestamp":1752265242,"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":18,"runs":12,"score":"206\/5","bats":[{"runs":12,"balls_faced":9,"fours":1,"sixes":0,"batsman_id":10594},{"runs":25,"balls_faced":21,"fours":0,"sixes":2,"batsman_id":94962}],"bowls":[{"runs_conceded":42,"maidens":0,"wickets":0,"bowler_id":1935,"overs":4},{"runs_conceded":25,"maidens":0,"wickets":0,"bowler_id":49814,"overs":3}],"commentary":"End of over 18 (12 runs), Derbyshire 206\/5"},{"event_id":"12328162","event":"ball","batsman_id":"94962","bowler_id":"49814","over":"18","ball":"1","score":"1lb","commentary":"Ben Sanderson to Harry Came, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1752265279,"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":"12328165","event":"ball","batsman_id":"10594","bowler_id":"49814","over":"18","ball":"2","score":0,"commentary":"Ben Sanderson to Samit Patel, no run,","noball_dismissal":false,"text":"","timestamp":1752265282,"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":"12328166","event":"ball","batsman_id":"10594","bowler_id":"49814","over":"18","ball":"3","score":1,"commentary":"Ben Sanderson to Samit Patel, 1 run,","noball_dismissal":false,"text":"","timestamp":1752265286,"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":"12328168","event":"ball","batsman_id":"94962","bowler_id":"49814","over":"18","ball":"4","score":6,"commentary":"Ben Sanderson to Harry Came, Six,","noball_dismissal":false,"text":"","timestamp":1752265289,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12328171","event":"ball","batsman_id":"94962","bowler_id":"49814","over":"18","ball":"5","score":0,"commentary":"Ben Sanderson to Harry Came, no run,","noball_dismissal":false,"text":"","timestamp":1752265301,"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":"12328175","event":"ball","batsman_id":"94962","bowler_id":"49814","over":"18","ball":"6","score":4,"commentary":"Ben Sanderson to Harry Came, Four,","noball_dismissal":false,"text":"","timestamp":1752265341,"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":19,"runs":12,"score":"218\/5","bats":[{"runs":35,"balls_faced":25,"fours":1,"sixes":3,"batsman_id":94962},{"runs":13,"balls_faced":11,"fours":1,"sixes":0,"batsman_id":10594}],"bowls":[{"runs_conceded":36,"maidens":0,"wickets":0,"bowler_id":49814,"overs":4},{"runs_conceded":42,"maidens":0,"wickets":0,"bowler_id":1935,"overs":4}],"commentary":"End of over 19 (12 runs), Derbyshire 218\/5"},{"event_id":"12328194","event":"ball","batsman_id":"10594","bowler_id":"48438","over":"19","ball":"1","score":4,"commentary":"Luke Procter to Samit Patel, Four,","noball_dismissal":false,"text":"","timestamp":1752265464,"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":"12328195","event":"ball","batsman_id":"10594","bowler_id":"48438","over":"19","ball":"2","score":0,"commentary":"Luke Procter to Samit Patel, no run,","noball_dismissal":false,"text":"","timestamp":1752265468,"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":"12328199","event":"ball","batsman_id":"10594","bowler_id":"48438","over":"19","ball":"3","score":2,"commentary":"Luke Procter to Samit Patel, 2 runs,","noball_dismissal":false,"text":"","timestamp":1752265849,"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":"12328205","event":"wicket","batsman_id":"10594","bowler_id":"48438","over":"19","ball":"4","score":"w","commentary":"Luke Procter to Samit Patel, no run, c LD McManus b LA Procter,","noball_dismissal":false,"text":"","timestamp":1752265893,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"10594","how_out":"c LD McManus b LA Procter","batsman_runs":"19","batsman_balls":"15"},{"event_id":"12328218","event":"ball","batsman_id":"50433","bowler_id":"48438","over":"19","ball":"5","score":0,"commentary":"Luke Procter to Alex Thomson, no run,","noball_dismissal":false,"text":"","timestamp":1752265879,"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":"12328246","event":"ball","batsman_id":"50433","bowler_id":"48438","over":"19","ball":"6","score":0,"commentary":"Luke Procter to Alex Thomson, no run,","noball_dismissal":false,"text":"","timestamp":1752265897,"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":20,"runs":6,"score":"224\/6","bats":[{"runs":0,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":50433},{"runs":35,"balls_faced":25,"fours":1,"sixes":3,"batsman_id":94962}],"bowls":[{"runs_conceded":38,"maidens":0,"wickets":2,"bowler_id":48438,"overs":4},{"runs_conceded":36,"maidens":0,"wickets":0,"bowler_id":49814,"overs":4}],"commentary":"End of over 20 (6 runs), Derbyshire 224\/6"}],"day":"0","session":"0","live_inning":{"iid":199495,"number":2,"name":"Derbyshire Inning","short_name":"DER Inning","status":2,"issuperover":"false","result":4,"batting_team_id":104949,"fielding_team_id":7038,"scores":"224\/6","scores_full":"224\/6 (20 ov)","fielder":[{"fielder_id":"50478","fielder_name":"Lewis McManus","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"49814","fielder_name":"Ben Sanderson","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"1935","fielder_name":"David Willey","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Samit Patel","batsman_id":"10594","runs":"19","balls":"15","how_out":"c LD McManus b LA Procter","score_at_dismissal":224,"overs_at_dismissal":"19.4","bowler_id":"48438","dismissal":"caught","number":6},"extra_runs":{"byes":0,"legbyes":7,"wides":2,"noballs":4,"penalty":"0","total":13},"equations":{"runs":224,"wickets":6,"overs":"20","bowlers_used":6,"runrate":"11.20"},"current_partnership":{"runs":0,"balls":2,"overs":0.2,"batsmen":[{"name":"Alex Thomson","batsman_id":50433,"runs":0,"balls":2},{"name":"Harry Came","batsman_id":94962,"runs":0,"balls":0}]},"did_not_bat":[{"player_id":"49808","name":"Zak Chappell"},{"player_id":"118504","name":"Allah Mohammad Ghazanfar"},{"player_id":"101484","name":"Ben William Aitchison"}],"max_over":"20","target":"238","recent_scores":"0,0,w,2,0,4,4,0,6,1,0,1,4,0,1,4,1,1","last_five_overs":"48\/2 9.00","last_ten_overs":"93\/4 8.72"},"teams":[{"tid":7038,"title":"Northamptonshire","abbr":"NOR","alt_name":"NOR","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/northamptonshire-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/northamptonshire-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"237\/4 (20 ov)","scores":"237\/4","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":"224\/6 (20 ov)","scores":"224\/6","overs":"20"}],"players":[{"pid":474,"title":"Ravi Bopara","short_name":"R Bopara","first_name":"Ravi Bopara","last_name":"","middle_name":"","birthdate":"1985-05-04","birthplace":" Forest Gate, London","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/ravibopara","instagram_profile":"https:\/\/www.instagram.com\/ravibopara\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":1046,"title":"George Bartlett","short_name":"GA Bartlett","first_name":"George Bartlett","last_name":"","middle_name":"","birthdate":"1998-03-14","birthplace":"Frimley, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":1259,"title":"Aneurin Donald","short_name":"A Donald","first_name":"Aneurin Donald","last_name":"","middle_name":"","birthdate":"1996-12-20","birthplace":"Swansea, Glamorgan","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/aneurin.donald\/","twitter_profile":"https:\/\/twitter.com\/AneurinDonald12","instagram_profile":"https:\/\/www.instagram.com\/aneurindonald\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":1935,"title":"David Willey","short_name":"D Willey","first_name":"David Willey","last_name":"","middle_name":"","birthdate":"1990-02-28","birthplace":"Northampton","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":18974,"recent_appearance":1517109600,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/DavidWilleyCricket\/","twitter_profile":"https:\/\/twitter.com\/david_willey","instagram_profile":"https:\/\/www.instagram.com\/david_willey72\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":"(C)"},{"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":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":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":46852,"title":"Matthew Breetzke","short_name":"MP Breetzke","first_name":"Matthew Breetzke","last_name":"","middle_name":"","birthdate":"1998-11-03","birthplace":"Gqeberha, South Africa","country":"za","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":23791,"recent_appearance":1515879000,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/matt_03_","instagram_profile":"https:\/\/www.instagram.com\/i3mbreetzke\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"wk","role_str":""},{"pid":46884,"title":"Ricardo Vasconcelos","short_name":"Rs Vasconcelos","first_name":"Ricardo Vasconcelos","last_name":"","middle_name":"","birthdate":"1997-10-27","birthplace":" Johannesburg, Gauteng","country":"za","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":7.5,"facebook_profile":"https:\/\/www.facebook.com\/ricardo.vasconcelos.169\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/ricardo27vasco\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bat","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":48438,"title":"Luke Procter","short_name":"LA Procter","first_name":"Luke Procter","last_name":"","middle_name":"","birthdate":"1988-06-24","birthplace":" Oldham, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","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":49372,"title":"Rob Keogh","short_name":"RI Keogh","first_name":"Rob Keogh","last_name":"","middle_name":"","birthdate":"1991-10-21","birthplace":" Dunstable, United","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49770,"title":"Saif Zaib","short_name":"SA Zaib","first_name":"Saif Zaib","last_name":"","middle_name":"","birthdate":"1998-05-22","birthplace":" High Wycombe, Buckinghamshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/zaib_05","instagram_profile":"https:\/\/www.instagram.com\/saif_zaib18\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","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":49814,"title":"Ben Sanderson","short_name":"BW Sanderson","first_name":"Ben Sanderson","last_name":"","middle_name":"","birthdate":"1989-01-03","birthplace":"Sheffield, Yorkshire","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":50387,"title":"George Scrimshaw","short_name":"GLS Scrimshaw","first_name":"George Scrimshaw","last_name":"","middle_name":"","birthdate":"1998-02-10","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":7.5,"facebook_profile":"https:\/\/www.facebook.com\/george.scrimshaw.1\/","twitter_profile":"https:\/\/twitter.com\/Gscrimshaw98","instagram_profile":"https:\/\/www.instagram.com\/gscrimshaw9\/","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":50478,"title":"Lewis McManus","short_name":"LD McManus","first_name":"Lewis McManus","last_name":"","middle_name":"","birthdate":"1994-10-09","birthplace":"Poole Hospital","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lewis_mcmanus","instagram_profile":"https:\/\/www.instagram.com\/lewismcmanus18\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"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":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":52878,"title":"Liam Guthrie","short_name":"L Guthrie","first_name":"Liam Guthrie","last_name":"","middle_name":"","birthdate":"1997-04-09","birthplace":"","country":"au","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/lguthrie7\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","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":"squad","role_str":""},{"pid":93459,"title":"Lloyd Pope","short_name":"L Pope","first_name":"Lloyd Pope","last_name":"","middle_name":"","birthdate":"1999-12-01","birthplace":"","country":"au","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":23792,"recent_appearance":1515891600,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/lloydpoonslayer69\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/lloyd_pope24\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Australia","role":"bowl","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":95557,"title":"Dominic Leech","short_name":"D Leech","first_name":"Dominic Leech","last_name":"","middle_name":"","birthdate":"2001-01-10","birthplace":" Middlesbrough, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":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":"bowl","role_str":""},{"pid":108384,"title":"Justin Broad","short_name":"J Broad","first_name":"Justin Broad","last_name":"","middle_name":"","birthdate":"2000-06-30","birthplace":"Cape Town, South Africa","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":108411,"title":"Gus Miller","short_name":"G Miller","first_name":"Gus Miller","last_name":"","middle_name":"","birthdate":"2002-01-08","birthplace":"Oxford","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108414,"title":"Freddie Heldreich","short_name":"F Heldreich","first_name":"Freddie Heldreich","last_name":"","middle_name":"","birthdate":"2001-09-12","birthplace":"Ipswich, Suffolk","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Wrist Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108418,"title":"James Sales","short_name":"J Sales","first_name":"James Sales","last_name":"","middle_name":"","birthdate":"2003-02-11","birthplace":"Northampton","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","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":114663,"title":"Tim Robinson","short_name":"T Robinson","first_name":"Tim Robinson","last_name":"","middle_name":"","birthdate":"2002-04-28","birthplace":"","country":"nz","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":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","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":118723,"title":"Arush Buchake","short_name":"A Buchake","first_name":"Arush Buchake","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","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":118724,"title":"Aadi Sharma","short_name":"A Sharma","first_name":"Aadi Sharma","last_name":"","middle_name":"","birthdate":"2006-02-23","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","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":130479,"title":"Raphael Weatherall","short_name":"R Weatherall","first_name":"Raphael Weatherall","last_name":"","middle_name":"","birthdate":"2004-10-24","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"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":148504,"title":"Tiaan Louw","short_name":"T Louw","first_name":"Tiaan Louw","last_name":"","middle_name":"","birthdate":"2006-04-16","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""}]},"etag":"168bfcc2f53a06138b2b18b8d2aa41bc","modified":"2025-07-16 01:19:42","datetime":"2025-07-16 01:19:42","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86920 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:acf69159-c8df-43f2-bfc8-f43d022dca1b Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86920 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86920,3,'{"status":"ok","response":{"match_id":86920,"title":"Northamptonshire vs Derbyshire","short_title":"NOR vs DER","subtitle":"Match 100","match_number":"100","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Northamptonshire won by 13 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":7038,"name":"Northamptonshire","short_name":"NOR","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/northamptonshire-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/northamptonshire-logo.png","scores_full":"237\/4 (20 ov)","scores":"237\/4","overs":"20"},"teamb":{"team_id":104949,"name":"Derbyshire","short_name":"DER","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/derbyshire-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/derbyshire-logo.png","scores_full":"224\/6 (20 ov)","scores":"224\/6","overs":"20"},"date_start":"2025-07-11 17:30:00","date_end":"2025-07-12 03:30:00","timestamp_start":1752255000,"timestamp_end":1752291000,"date_start_ist":"2025-07-11 23:00:00","date_end_ist":"2025-07-12 09:00:00","venue":{"venue_id":"46","name":"County Ground","location":"Northampton","country":"England","timezone":""},"umpires":"James Middlebrook (England), Tom Lungley (England)","referee":"Sarah Bartlett (England)","equation":"","live":"","result":"NOR won by 13 runs","result_type":1,"win_margin":"13 runs","winning_team_id":7038,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-07-11 00:04:53","verify_time":"2025-07-12 02:13:11","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clear","weather_desc":"clear sky","temp":23.79,"humidity":55,"visibility":10000,"wind_speed":"7.61","clouds":0},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Derbyshire elected to bowl","winner":104949,"decision":2}},"etag":"8ab8135f7355eaefc5867cb7ca82fa6c","modified":"2025-07-16 01:19:43","datetime":"2025-07-16 01:19:43","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":86920,"title":"Northamptonshire vs Derbyshire","short_title":"NOR vs DER","subtitle":"Match 100","match_number":"100","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Northamptonshire won by 13 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":7038,"name":"Northamptonshire","short_name":"NOR","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/northamptonshire-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/northamptonshire-logo.png","scores_full":"237\/4 (20 ov)","scores":"237\/4","overs":"20"},"teamb":{"team_id":104949,"name":"Derbyshire","short_name":"DER","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/derbyshire-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/derbyshire-logo.png","scores_full":"224\/6 (20 ov)","scores":"224\/6","overs":"20"},"date_start":"2025-07-11 17:30:00","date_end":"2025-07-12 03:30:00","timestamp_start":1752255000,"timestamp_end":1752291000,"date_start_ist":"2025-07-11 23:00:00","date_end_ist":"2025-07-12 09:00:00","venue":{"venue_id":"46","name":"County Ground","location":"Northampton","country":"England","timezone":""},"umpires":"James Middlebrook (England), Tom Lungley (England)","referee":"Sarah Bartlett (England)","equation":"","live":"","result":"NOR won by 13 runs","result_type":1,"win_margin":"13 runs","winning_team_id":7038,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-07-11 00:04:53","verify_time":"2025-07-12 02:13:11","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clear","weather_desc":"clear sky","temp":23.79,"humidity":55,"visibility":10000,"wind_speed":"7.61","clouds":0},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Derbyshire elected to bowl","winner":104949,"decision":2}},"etag":"8ab8135f7355eaefc5867cb7ca82fa6c","modified":"2025-07-16 01:19:43","datetime":"2025-07-16 01:19:43","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86920 AND DataTypeId = 3 END
Live Report & Scorecard of Northamptonshire vs Derbyshire Match 100
CricDirect Cricket News, Results and Stats
 

Northamptonshire vs Derbyshire, Match 100, Vitality Blast

Completed
Vitality Blast, Completed
Northamptonshire
NOR
237/4 (20 ov)
Derbyshire
DER
224/6 (20 ov)
Northamptonshire won by 13 runs
BATTERS R B 4S 6S SR
Harry Came * 35 25 1 3 140.00
Alex Thomson 0 2 0 0 0.00
BOWLERS O M R W ECON
Luke Procter * 4 0 39 2 9.80
Ben Sanderson 4 0 36 0 9.00
Current Partnership: 0 run (0.2 ov) | Last Wicket: Samit Patel 19 (15) | Fall of Wicket: 224/6 (19.4 ov)
CRR: 11.20
Recent: ••w2•44•61•14•1411

Northamptonshire vs Derbyshire, Live Cricket Commentary

End of over 20 (6 runs)
Alex Thomson 0 (2)
Harry Came 35 (25)
Derbyshire 224/6
Luke Procter 4-0-38-2
Ben Sanderson 4-0-36-0
0
19.6
Luke Procter to Alex Thomson, no run,
0
19.5
Luke Procter to Alex Thomson, no run,
w
19.4
Samit Patel c LD McManus b LA Procter 19 (15) Luke Procter to Samit Patel, no run, c LD McManus b LA Procter,
2
19.3
Luke Procter to Samit Patel, 2 runs,
0
19.2
Luke Procter to Samit Patel, no run,
4
19.1
Luke Procter to Samit Patel, Four,
End of over 19 (12 runs)
Harry Came 35 (25)
Samit Patel 13 (11)
Derbyshire 218/5
Ben Sanderson 4-0-36-0
David Willey 4-0-42-0
4
18.6
Ben Sanderson to Harry Came, Four,
0
18.5
Ben Sanderson to Harry Came, no run,
6
18.4
Ben Sanderson to Harry Came, Six,
1
18.3
Ben Sanderson to Samit Patel, 1 run,
0
18.2
Ben Sanderson to Samit Patel, no run,
1lb
18.1
Ben Sanderson to Harry Came, 1 leg bye,
End of over 18 (12 runs)
Samit Patel 12 (9)
Harry Came 25 (21)
Derbyshire 206/5
David Willey 4-0-42-0
Ben Sanderson 3-0-25-0
4
17.6
David Willey to Samit Patel, Four,
0
17.5
David Willey to Samit Patel, no run,
1lb
17.4
David Willey to Harry Came, 1 leg bye,
4nb
17.4
David Willey to Harry Came, 4 no ball,
1
17.3
David Willey to Samit Patel, 1 run,
1
17.2
David Willey to Harry Came, 1 run,
1
17.1
David Willey to Samit Patel, 1 run,
End of over 17 (8 runs)
Samit Patel 6 (5)
Harry Came 22 (18)
Derbyshire 194/5
Ben Sanderson 3-0-25-0
Luke Procter 3-0-32-1
1
16.6
Ben Sanderson to Samit Patel, 1 run,
0
16.5
Ben Sanderson to Samit Patel, no run,
1
16.4
Ben Sanderson to Harry Came, 1 run,
0
16.3
Ben Sanderson to Harry Came, no run,
6
16.2
Ben Sanderson to Harry Came, Six,
0
16.1
Ben Sanderson to Harry Came, no run,
End of over 16 (10 runs)
Samit Patel 5 (3)
Harry Came 15 (14)
Derbyshire 186/5
Luke Procter 3-0-32-1
George Scrimshaw 4-0-56-2
2
15.6
Luke Procter to Samit Patel, 2 runs,
Match Details
Date
Friday, July 11, 2025 18:30
Venue
County Ground, Northampton
Toss
Derbyshire elected to bowl
Umpires
    James Middlebrook (England)
    Tom Lungley (England)
Match Referee
    Sarah Bartlett (England)
× Close