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:eed1ada8-b268-4e09-b5d7-c362c3d1f3da
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86894 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86894,1,'{"status":"ok","response":{"mid":86894,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Lancashire won by 5 wickets","day_remaining_over":"","team_batting":"Lancashire","team_bowling":"Northamptonshire","live_inning_number":2,"live_score":{"runs":181,"overs":19.3,"wickets":5,"target":178,"runrate":9.28,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Luke Wells","batsman_id":49330,"runs":15,"balls_faced":4,"fours":0,"sixes":2,"strike_rate":"375.00"},{"name":"Chris Green","batsman_id":43448,"runs":0,"balls_faced":0,"fours":0,"sixes":0,"strike_rate":"0.00"}],"bowlers":[{"name":"Luke Procter","bowler_id":48438,"overs":1.3,"runs_conceded":17,"wickets":0,"maidens":0,"econ":"11.33"},{"name":"George Scrimshaw","bowler_id":50387,"overs":3,"runs_conceded":26,"wickets":2,"maidens":0,"econ":"8.67"}],"commentaries":[{"event_id":"12284128","event":"ball","batsman_id":"49818","bowler_id":"49814","over":"15","ball":"1","score":4,"commentary":"Ben Sanderson to Phil Salt, Four,","noball_dismissal":false,"text":"","timestamp":1751660293,"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":"12284133","event":"ball","batsman_id":"49818","bowler_id":"49814","over":"15","ball":"2","score":1,"commentary":"Ben Sanderson to Phil Salt, 1 run,","noball_dismissal":false,"text":"","timestamp":1751660341,"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":"12284176","event":"ball","batsman_id":"105","bowler_id":"49814","over":"15","ball":"3","score":0,"commentary":"Ben Sanderson to Jos Buttler, no run,","noball_dismissal":false,"text":"","timestamp":1751660348,"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":"12284177","event":"ball","batsman_id":"105","bowler_id":"49814","over":"15","ball":"4","score":0,"commentary":"Ben Sanderson to Jos Buttler, no run,","noball_dismissal":false,"text":"","timestamp":1751660353,"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":"12284178","event":"ball","batsman_id":"105","bowler_id":"49814","over":"15","ball":"5","score":0,"commentary":"Ben Sanderson to Jos Buttler, no run,","noball_dismissal":false,"text":"","timestamp":1751660357,"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":"12284179","event":"ball","batsman_id":"105","bowler_id":"49814","over":"15","ball":"6","score":0,"commentary":"Ben Sanderson to Jos Buttler, no run,","noball_dismissal":false,"text":"","timestamp":1751660360,"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":16,"runs":5,"score":"136\/1","bats":[{"runs":54,"balls_faced":41,"fours":2,"sixes":4,"batsman_id":105},{"runs":70,"balls_faced":51,"fours":8,"sixes":3,"batsman_id":49818}],"bowls":[{"runs_conceded":18,"maidens":0,"wickets":0,"bowler_id":49814,"overs":3},{"runs_conceded":15,"maidens":0,"wickets":0,"bowler_id":50387,"overs":2}],"commentary":"End of over 16 (5 runs), Lancashire 136\/1"},{"event_id":"12284184","event":"ball","batsman_id":"49818","bowler_id":"93459","over":"16","ball":"1","score":6,"commentary":"Lloyd Pope to Phil Salt, Six,","noball_dismissal":false,"text":"","timestamp":1751660364,"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":"12284220","event":"ball","batsman_id":"49818","bowler_id":"93459","over":"16","ball":"2","score":1,"commentary":"Lloyd Pope to Phil Salt, 1 run,","noball_dismissal":false,"text":"","timestamp":1751660555,"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":"12284227","event":"wicket","batsman_id":"105","bowler_id":"93459","over":"16","ball":"3","score":"w","commentary":"Lloyd Pope to Jos Buttler, no run, b L Pope,","noball_dismissal":false,"text":"","timestamp":1751660568,"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":"105","how_out":"b L Pope","batsman_runs":"54","batsman_balls":"42"},{"event_id":"12284230","event":"ball","batsman_id":"48436","bowler_id":"93459","over":"16","ball":"4","score":0,"commentary":"Lloyd Pope to Liam Livingstone, no run,","noball_dismissal":false,"text":"","timestamp":1751660656,"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":"12284233","event":"ball","batsman_id":"48436","bowler_id":"93459","over":"16","ball":"5","score":1,"commentary":"Lloyd Pope to Liam Livingstone, 1 run,","noball_dismissal":false,"text":"","timestamp":1751660659,"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":"12284241","event":"ball","batsman_id":"49818","bowler_id":"93459","over":"16","ball":"6","score":1,"commentary":"Lloyd Pope to Phil Salt, 1 run,","noball_dismissal":false,"text":"","timestamp":1751660672,"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":9,"score":"145\/2","bats":[{"runs":78,"balls_faced":54,"fours":8,"sixes":4,"batsman_id":49818},{"runs":1,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":48436}],"bowls":[{"runs_conceded":30,"maidens":0,"wickets":1,"bowler_id":93459,"overs":4},{"runs_conceded":18,"maidens":0,"wickets":0,"bowler_id":49814,"overs":3}],"commentary":"End of over 17 (9 runs), Lancashire 145\/2"},{"event_id":"12284253","event":"ball","batsman_id":"49818","bowler_id":"49814","over":"17","ball":"1","score":1,"commentary":"Ben Sanderson to Phil Salt, 1 run,","noball_dismissal":false,"text":"","timestamp":1751660709,"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":"12284254","event":"ball","batsman_id":"48436","bowler_id":"49814","over":"17","ball":"2","score":1,"commentary":"Ben Sanderson to Liam Livingstone, 1 run,","noball_dismissal":false,"text":"","timestamp":1751660716,"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":"12284255","event":"ball","batsman_id":"49818","bowler_id":"49814","over":"17","ball":"3","score":1,"commentary":"Ben Sanderson to Phil Salt, 1 run,","noball_dismissal":false,"text":"","timestamp":1751660719,"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":"12284265","event":"ball","batsman_id":"48436","bowler_id":"49814","over":"17","ball":"4","score":6,"commentary":"Ben Sanderson to Liam Livingstone, Six,","noball_dismissal":false,"text":"","timestamp":1751660740,"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":"12284270","event":"ball","batsman_id":"48436","bowler_id":"49814","over":"17","ball":"5","score":1,"commentary":"Ben Sanderson to Liam Livingstone, 1 run,","noball_dismissal":false,"text":"","timestamp":1751660779,"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":"12284282","event":"wicket","batsman_id":"49818","bowler_id":"49814","over":"17","ball":"6","score":"w","commentary":"Ben Sanderson to Phil Salt, no run, c Rs Vasconcelos b BW Sanderson,","noball_dismissal":false,"text":"","timestamp":1751660892,"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":"49818","how_out":"c Rs Vasconcelos b BW Sanderson","batsman_runs":"80","batsman_balls":"57"},{"event":"overend","over":18,"runs":10,"score":"155\/3","bats":[{"runs":80,"balls_faced":57,"fours":8,"sixes":4,"batsman_id":49818},{"runs":9,"balls_faced":5,"fours":0,"sixes":1,"batsman_id":48436}],"bowls":[{"runs_conceded":28,"maidens":0,"wickets":1,"bowler_id":49814,"overs":4},{"runs_conceded":30,"maidens":0,"wickets":1,"bowler_id":93459,"overs":4}],"commentary":"End of over 18 (10 runs), Lancashire 155\/3"},{"event_id":"12284294","event":"ball","batsman_id":"48436","bowler_id":"50387","over":"18","ball":"1","score":4,"commentary":"George Scrimshaw to Liam Livingstone, Four,","noball_dismissal":false,"text":"","timestamp":1751661001,"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":"12284296","event":"ball","batsman_id":"48436","bowler_id":"50387","over":"18","ball":"2","score":"1lb","commentary":"George Scrimshaw to Liam Livingstone, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1751661011,"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":"12284314","event":"wicket","batsman_id":"43584","bowler_id":"50387","over":"18","ball":"3","score":"w","commentary":"George Scrimshaw to Ashton Turner, no run, c LD McManus b GLS Scrimshaw,","noball_dismissal":false,"text":"","timestamp":1751661095,"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":"43584","how_out":"c LD McManus b GLS Scrimshaw","batsman_runs":"0","batsman_balls":"1"},{"event_id":"12284331","event":"ball","batsman_id":"49330","bowler_id":"50387","over":"18","ball":"4","score":1,"commentary":"George Scrimshaw to Luke Wells, 1 run,","noball_dismissal":false,"text":"","timestamp":1751661215,"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":"12284332","event":"ball","batsman_id":"48436","bowler_id":"50387","over":"18","ball":"5","score":6,"commentary":"George Scrimshaw to Liam Livingstone, Six,","noball_dismissal":false,"text":"","timestamp":1751661227,"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":"12284338","event":"wicket","batsman_id":"48436","bowler_id":"50387","over":"18","ball":"6","score":"w","commentary":"George Scrimshaw to Liam Livingstone, no run, b GLS Scrimshaw,","noball_dismissal":false,"text":"","timestamp":1751661249,"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":"48436","how_out":"b GLS Scrimshaw","batsman_runs":"19","batsman_balls":"9"},{"event":"overend","over":19,"runs":12,"score":"167\/5","bats":[{"runs":19,"balls_faced":9,"fours":1,"sixes":2,"batsman_id":48436},{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":49330}],"bowls":[{"runs_conceded":26,"maidens":0,"wickets":2,"bowler_id":50387,"overs":3},{"runs_conceded":28,"maidens":0,"wickets":1,"bowler_id":49814,"overs":4}],"commentary":"End of over 19 (12 runs), Lancashire 167\/5"},{"event_id":"12284350","event":"ball","batsman_id":"49330","bowler_id":"48438","over":"19","ball":"1","score":2,"commentary":"Luke Procter to Luke Wells, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751661342,"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":"12284352","event":"ball","batsman_id":"49330","bowler_id":"48438","over":"19","ball":"2","score":6,"commentary":"Luke Procter to Luke Wells, Six,","noball_dismissal":false,"text":"","timestamp":1751661347,"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":"12284362","event":"ball","batsman_id":"49330","bowler_id":"48438","over":"19","ball":"3","score":6,"commentary":"Luke Procter to Luke Wells, Six,","noball_dismissal":false,"text":"","timestamp":1751661442,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false}],"day":"0","session":"0","live_inning":{"iid":199118,"number":2,"name":"Lancashire Inning","short_name":"LAN Inning","status":2,"issuperover":"false","result":3,"batting_team_id":7023,"fielding_team_id":7038,"scores":"181\/5","scores_full":"181\/5 (19.3 ov)","fielder":[{"fielder_id":"46884","fielder_name":"Ricardo Vasconcelos","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"93459","fielder_name":"Lloyd Pope","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"50478","fielder_name":"Lewis McManus","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":"Liam Livingstone","batsman_id":"48436","runs":"19","balls":"9","how_out":"b GLS Scrimshaw","score_at_dismissal":167,"overs_at_dismissal":"18.6","bowler_id":"50387","dismissal":"bowled","number":5},"extra_runs":{"byes":0,"legbyes":3,"wides":8,"noballs":0,"penalty":"0","total":11},"equations":{"runs":181,"wickets":5,"overs":"19.3","bowlers_used":8,"runrate":"9.28"},"current_partnership":{"runs":14,"balls":3,"overs":0.3,"batsmen":[{"name":"Luke Wells","batsman_id":49330,"runs":14,"balls":3},{"name":"Chris Green","batsman_id":43448,"runs":0,"balls":0}]},"did_not_bat":[{"player_id":"93763","name":"Jack Blatherwick"},{"player_id":"50411","name":"Luke Wood"},{"player_id":"1052","name":"Saqib Mahmood"},{"player_id":"113","name":"James Anderson"}],"max_over":"20","target":"178","recent_scores":"6,6,2,w,6,1,w,1,4,w,1,6,1,1,1,1,1,0","last_five_overs":"56\/4 11.20","last_ten_overs":"106\/4 10.43"},"teams":[{"tid":7023,"title":"Lancashire","abbr":"LAN","alt_name":"LAN","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/lancashire-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/lancashire-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"181\/5 (19.3 ov)","scores":"181\/5","overs":"19.3"},{"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":"177\/10 (20 ov)","scores":"177\/10","overs":"20"}],"players":[{"pid":105,"title":"Jos Buttler","short_name":"J Buttler","first_name":"Jos Buttler","last_name":"","middle_name":"","birthdate":"1990-09-08","birthplace":"Taunton, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicket keeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/josbuttler\/","twitter_profile":"https:\/\/twitter.com\/josbuttler","instagram_profile":"https:\/\/www.instagram.com\/josbuttler\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":113,"title":"James Anderson","short_name":"J Anderson","first_name":"James Anderson","last_name":"","middle_name":"","birthdate":"1982-07-30","birthplace":"Burnley, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/JimmyAnderson\/","twitter_profile":"https:\/\/twitter.com\/jimmy9","instagram_profile":"https:\/\/www.instagram.com\/jimmya9\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"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":"squad","role_str":""},{"pid":1052,"title":"Saqib Mahmood","short_name":"S Mahmood","first_name":"Saqib Mahmood","last_name":"","middle_name":"","birthdate":"1997-02-25","birthplace":" Birmingham, Warwickshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/saqmahmood25\/","twitter_profile":"https:\/\/twitter.com\/SaqMahmood25","instagram_profile":"https:\/\/www.instagram.com\/saqmahmood25\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"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":43448,"title":"Chris Green","short_name":"CJ Green","first_name":"Chris Green","last_name":"","middle_name":"","birthdate":"1993-10-01","birthplace":"Durban, Natal, South Africa","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/chrisgreen_93\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Australia","role":"all","role_str":""},{"pid":43580,"title":"Marcus Harris","short_name":"MS Harris","first_name":"Marcus Harris","last_name":"","middle_name":"","birthdate":"1992-07-21","birthplace":"Perth, Australia","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/marcusharris14\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":43584,"title":"Ashton Turner","short_name":"AJ Turner","first_name":"Ashton Turner","last_name":"","middle_name":"","birthdate":"1993-01-25","birthplace":"Perth","country":"au","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/ashtonturner_70\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Australia","role":"bat","role_str":""},{"pid":46286,"title":"Will Williams","short_name":"WSA Williams","first_name":"Will Williams","last_name":"","middle_name":"","birthdate":"1992-10-06","birthplace":" Christchurch, Canterbury","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","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":"squad","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":48436,"title":"Liam Livingstone","short_name":"L Livingstone","first_name":"Liam Livingstone","last_name":"","middle_name":"","birthdate":"1993-08-04","birthplace":"Barrow-in-Furness, Cumberland","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/Livingstone23era\/","twitter_profile":"https:\/\/twitter.com\/liaml4893","instagram_profile":"https:\/\/www.instagram.com\/liaml4893\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","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":49330,"title":"Luke Wells","short_name":"LWP Wells","first_name":"Luke Wells","last_name":"","middle_name":"","birthdate":"1990-12-29","birthplace":"Eastbourne, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/luke_wells07","instagram_profile":"https:\/\/www.instagram.com\/l.wells07\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","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":49538,"title":"Keaton Jennings","short_name":"KK Jennings","first_name":"Keaton Jennings","last_name":"","middle_name":"","birthdate":"1992-06-19","birthplace":"Johannesburg, Transvaal","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left 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":"https:\/\/twitter.com\/jetjennings?lang=en","instagram_profile":"https:\/\/www.instagram.com\/keatonjetjennings\/?hl=en","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"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":49779,"title":"Tom Bailey","short_name":"TE Bailey","first_name":"Tom Bailey","last_name":"","middle_name":"","birthdate":"1991-04-21","birthplace":"Preston, 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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":49818,"title":"Phil Salt","short_name":"P Salt","first_name":"Phil Salt","last_name":"","middle_name":"","birthdate":"1996-08-28","birthplace":"Bodelwyddan, North Wales","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/RealPhilSalt\/","twitter_profile":"https:\/\/twitter.com\/PhilSalt1","instagram_profile":"https:\/\/www.instagram.com\/phil_salt\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"wk","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":50411,"title":"Luke Wood","short_name":"L Wood","first_name":"Luke Wood","last_name":"","middle_name":"","birthdate":"1995-08-02","birthplace":"Sheffield, Yorkshire","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/lwood_95\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","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":51279,"title":"Josh Bohannon","short_name":"JJ Bohannon","first_name":"Josh Bohannon","last_name":"","middle_name":"","birthdate":"1997-04-09","birthplace":"Bolton, Lancashire","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":"https:\/\/twitter.com\/TheCricketerMag\/status\/1517827240205115393","instagram_profile":"https:\/\/www.instagram.com\/joshbo97\/?hl=en","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":52207,"title":"Anderson Phillip","short_name":"A Phillip","first_name":"Anderson Phillip","last_name":"","middle_name":"","birthdate":"1996-08-22","birthplace":"","country":"wi","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","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":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":93640,"title":"Michael Jones","short_name":"MA Jones","first_name":"Michael Jones","last_name":"","middle_name":"","birthdate":"1998-01-05","birthplace":"Ormskirk, Lancashire","country":"sct","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\/mikejones04","instagram_profile":"https:\/\/www.instagram.com\/ah_michaeljones\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Scotland","role":"squad","role_str":""},{"pid":93763,"title":"Jack Blatherwick","short_name":"JM Blatherwick","first_name":"Jack Blatherwick","last_name":"","middle_name":"","birthdate":"1998-06-04","birthplace":" Nottingham, Nottinghamshire,","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":94941,"title":"Tom Hartley","short_name":"T Hartley","first_name":"Tom Hartley","last_name":"","middle_name":"","birthdate":"1998-05-03","birthplace":" Ormskirk, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/tomhartley100","instagram_profile":"https:\/\/www.instagram.com\/tomwhartley\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":94964,"title":"George Balderson","short_name":"G Balderson","first_name":"George Balderson","last_name":"","middle_name":"","birthdate":"2000-10-11","birthplace":"Manchester","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","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":102544,"title":"Mitchell Stanley","short_name":"M Stanley","first_name":"Mitchell Stanley","last_name":"","middle_name":"","birthdate":"2001-03-17","birthplace":"Telford, Shropshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/m.s.stanley\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":"bat","role_str":""},{"pid":108404,"title":"George Bell","short_name":"G Bell","first_name":"George Bell","last_name":"","middle_name":"","birthdate":"2002-09-25","birthplace":" Manchester, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/GeorgeB_77","instagram_profile":"https:\/\/www.instagram.com\/georgebell78\/?hl=en","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","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":109267,"title":"Tom Aspinwall","short_name":"T Aspinwall","first_name":"Tom Aspinwall","last_name":"","middle_name":"","birthdate":"2004-03-13","birthplace":"Lancaster, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":113352,"title":"Joshua Boyden","short_name":"JA Boyden","first_name":"Joshua Boyden","last_name":"","middle_name":"","birthdate":"2004-04-16","birthplace":"Chorley, Lancashire, England","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm 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":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":"bat","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":118933,"title":"Harry Singh","short_name":"HPN Singh","first_name":"Harry Singh","last_name":"","middle_name":"","birthdate":"2004-06-16","birthplace":"Blackburn, Lancashire, England","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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":118934,"title":"Matthew Hurst","short_name":"M Hurst","first_name":"Matthew Hurst","last_name":"","middle_name":"","birthdate":"2003-12-10","birthplace":"","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\/MattHurst","instagram_profile":"https:\/\/www.instagram.com\/thematthurst\/?hl=en","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":130436,"title":"Keshana Fonseka","short_name":"K Fonseka","first_name":"Keshana Fonseka","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":130438,"title":"Charlie Barnard","short_name":"CM Barnard","first_name":"Charlie Barnard","last_name":"","middle_name":"","birthdate":"2004-11-05","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","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":140792,"title":"Rocky Flintoff","short_name":"Rocky Flintoff","first_name":"Rocky Flintoff","last_name":"","middle_name":"","birthdate":"2008-04-07","birthplace":"","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":141395,"title":"Ollie Sutton","short_name":"O Sutton","first_name":"Ollie Sutton","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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":"3da8b632ebf048dc47260f80e8b31cd7","modified":"2025-07-16 01:09:26","datetime":"2025-07-16 01:09:26","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":86894,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Lancashire won by 5 wickets","day_remaining_over":"","team_batting":"Lancashire","team_bowling":"Northamptonshire","live_inning_number":2,"live_score":{"runs":181,"overs":19.3,"wickets":5,"target":178,"runrate":9.28,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Luke Wells","batsman_id":49330,"runs":15,"balls_faced":4,"fours":0,"sixes":2,"strike_rate":"375.00"},{"name":"Chris Green","batsman_id":43448,"runs":0,"balls_faced":0,"fours":0,"sixes":0,"strike_rate":"0.00"}],"bowlers":[{"name":"Luke Procter","bowler_id":48438,"overs":1.3,"runs_conceded":17,"wickets":0,"maidens":0,"econ":"11.33"},{"name":"George Scrimshaw","bowler_id":50387,"overs":3,"runs_conceded":26,"wickets":2,"maidens":0,"econ":"8.67"}],"commentaries":[{"event_id":"12284128","event":"ball","batsman_id":"49818","bowler_id":"49814","over":"15","ball":"1","score":4,"commentary":"Ben Sanderson to Phil Salt, Four,","noball_dismissal":false,"text":"","timestamp":1751660293,"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":"12284133","event":"ball","batsman_id":"49818","bowler_id":"49814","over":"15","ball":"2","score":1,"commentary":"Ben Sanderson to Phil Salt, 1 run,","noball_dismissal":false,"text":"","timestamp":1751660341,"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":"12284176","event":"ball","batsman_id":"105","bowler_id":"49814","over":"15","ball":"3","score":0,"commentary":"Ben Sanderson to Jos Buttler, no run,","noball_dismissal":false,"text":"","timestamp":1751660348,"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":"12284177","event":"ball","batsman_id":"105","bowler_id":"49814","over":"15","ball":"4","score":0,"commentary":"Ben Sanderson to Jos Buttler, no run,","noball_dismissal":false,"text":"","timestamp":1751660353,"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":"12284178","event":"ball","batsman_id":"105","bowler_id":"49814","over":"15","ball":"5","score":0,"commentary":"Ben Sanderson to Jos Buttler, no run,","noball_dismissal":false,"text":"","timestamp":1751660357,"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":"12284179","event":"ball","batsman_id":"105","bowler_id":"49814","over":"15","ball":"6","score":0,"commentary":"Ben Sanderson to Jos Buttler, no run,","noball_dismissal":false,"text":"","timestamp":1751660360,"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":16,"runs":5,"score":"136\/1","bats":[{"runs":54,"balls_faced":41,"fours":2,"sixes":4,"batsman_id":105},{"runs":70,"balls_faced":51,"fours":8,"sixes":3,"batsman_id":49818}],"bowls":[{"runs_conceded":18,"maidens":0,"wickets":0,"bowler_id":49814,"overs":3},{"runs_conceded":15,"maidens":0,"wickets":0,"bowler_id":50387,"overs":2}],"commentary":"End of over 16 (5 runs), Lancashire 136\/1"},{"event_id":"12284184","event":"ball","batsman_id":"49818","bowler_id":"93459","over":"16","ball":"1","score":6,"commentary":"Lloyd Pope to Phil Salt, Six,","noball_dismissal":false,"text":"","timestamp":1751660364,"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":"12284220","event":"ball","batsman_id":"49818","bowler_id":"93459","over":"16","ball":"2","score":1,"commentary":"Lloyd Pope to Phil Salt, 1 run,","noball_dismissal":false,"text":"","timestamp":1751660555,"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":"12284227","event":"wicket","batsman_id":"105","bowler_id":"93459","over":"16","ball":"3","score":"w","commentary":"Lloyd Pope to Jos Buttler, no run, b L Pope,","noball_dismissal":false,"text":"","timestamp":1751660568,"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":"105","how_out":"b L Pope","batsman_runs":"54","batsman_balls":"42"},{"event_id":"12284230","event":"ball","batsman_id":"48436","bowler_id":"93459","over":"16","ball":"4","score":0,"commentary":"Lloyd Pope to Liam Livingstone, no run,","noball_dismissal":false,"text":"","timestamp":1751660656,"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":"12284233","event":"ball","batsman_id":"48436","bowler_id":"93459","over":"16","ball":"5","score":1,"commentary":"Lloyd Pope to Liam Livingstone, 1 run,","noball_dismissal":false,"text":"","timestamp":1751660659,"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":"12284241","event":"ball","batsman_id":"49818","bowler_id":"93459","over":"16","ball":"6","score":1,"commentary":"Lloyd Pope to Phil Salt, 1 run,","noball_dismissal":false,"text":"","timestamp":1751660672,"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":9,"score":"145\/2","bats":[{"runs":78,"balls_faced":54,"fours":8,"sixes":4,"batsman_id":49818},{"runs":1,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":48436}],"bowls":[{"runs_conceded":30,"maidens":0,"wickets":1,"bowler_id":93459,"overs":4},{"runs_conceded":18,"maidens":0,"wickets":0,"bowler_id":49814,"overs":3}],"commentary":"End of over 17 (9 runs), Lancashire 145\/2"},{"event_id":"12284253","event":"ball","batsman_id":"49818","bowler_id":"49814","over":"17","ball":"1","score":1,"commentary":"Ben Sanderson to Phil Salt, 1 run,","noball_dismissal":false,"text":"","timestamp":1751660709,"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":"12284254","event":"ball","batsman_id":"48436","bowler_id":"49814","over":"17","ball":"2","score":1,"commentary":"Ben Sanderson to Liam Livingstone, 1 run,","noball_dismissal":false,"text":"","timestamp":1751660716,"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":"12284255","event":"ball","batsman_id":"49818","bowler_id":"49814","over":"17","ball":"3","score":1,"commentary":"Ben Sanderson to Phil Salt, 1 run,","noball_dismissal":false,"text":"","timestamp":1751660719,"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":"12284265","event":"ball","batsman_id":"48436","bowler_id":"49814","over":"17","ball":"4","score":6,"commentary":"Ben Sanderson to Liam Livingstone, Six,","noball_dismissal":false,"text":"","timestamp":1751660740,"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":"12284270","event":"ball","batsman_id":"48436","bowler_id":"49814","over":"17","ball":"5","score":1,"commentary":"Ben Sanderson to Liam Livingstone, 1 run,","noball_dismissal":false,"text":"","timestamp":1751660779,"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":"12284282","event":"wicket","batsman_id":"49818","bowler_id":"49814","over":"17","ball":"6","score":"w","commentary":"Ben Sanderson to Phil Salt, no run, c Rs Vasconcelos b BW Sanderson,","noball_dismissal":false,"text":"","timestamp":1751660892,"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":"49818","how_out":"c Rs Vasconcelos b BW Sanderson","batsman_runs":"80","batsman_balls":"57"},{"event":"overend","over":18,"runs":10,"score":"155\/3","bats":[{"runs":80,"balls_faced":57,"fours":8,"sixes":4,"batsman_id":49818},{"runs":9,"balls_faced":5,"fours":0,"sixes":1,"batsman_id":48436}],"bowls":[{"runs_conceded":28,"maidens":0,"wickets":1,"bowler_id":49814,"overs":4},{"runs_conceded":30,"maidens":0,"wickets":1,"bowler_id":93459,"overs":4}],"commentary":"End of over 18 (10 runs), Lancashire 155\/3"},{"event_id":"12284294","event":"ball","batsman_id":"48436","bowler_id":"50387","over":"18","ball":"1","score":4,"commentary":"George Scrimshaw to Liam Livingstone, Four,","noball_dismissal":false,"text":"","timestamp":1751661001,"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":"12284296","event":"ball","batsman_id":"48436","bowler_id":"50387","over":"18","ball":"2","score":"1lb","commentary":"George Scrimshaw to Liam Livingstone, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1751661011,"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":"12284314","event":"wicket","batsman_id":"43584","bowler_id":"50387","over":"18","ball":"3","score":"w","commentary":"George Scrimshaw to Ashton Turner, no run, c LD McManus b GLS Scrimshaw,","noball_dismissal":false,"text":"","timestamp":1751661095,"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":"43584","how_out":"c LD McManus b GLS Scrimshaw","batsman_runs":"0","batsman_balls":"1"},{"event_id":"12284331","event":"ball","batsman_id":"49330","bowler_id":"50387","over":"18","ball":"4","score":1,"commentary":"George Scrimshaw to Luke Wells, 1 run,","noball_dismissal":false,"text":"","timestamp":1751661215,"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":"12284332","event":"ball","batsman_id":"48436","bowler_id":"50387","over":"18","ball":"5","score":6,"commentary":"George Scrimshaw to Liam Livingstone, Six,","noball_dismissal":false,"text":"","timestamp":1751661227,"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":"12284338","event":"wicket","batsman_id":"48436","bowler_id":"50387","over":"18","ball":"6","score":"w","commentary":"George Scrimshaw to Liam Livingstone, no run, b GLS Scrimshaw,","noball_dismissal":false,"text":"","timestamp":1751661249,"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":"48436","how_out":"b GLS Scrimshaw","batsman_runs":"19","batsman_balls":"9"},{"event":"overend","over":19,"runs":12,"score":"167\/5","bats":[{"runs":19,"balls_faced":9,"fours":1,"sixes":2,"batsman_id":48436},{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":49330}],"bowls":[{"runs_conceded":26,"maidens":0,"wickets":2,"bowler_id":50387,"overs":3},{"runs_conceded":28,"maidens":0,"wickets":1,"bowler_id":49814,"overs":4}],"commentary":"End of over 19 (12 runs), Lancashire 167\/5"},{"event_id":"12284350","event":"ball","batsman_id":"49330","bowler_id":"48438","over":"19","ball":"1","score":2,"commentary":"Luke Procter to Luke Wells, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751661342,"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":"12284352","event":"ball","batsman_id":"49330","bowler_id":"48438","over":"19","ball":"2","score":6,"commentary":"Luke Procter to Luke Wells, Six,","noball_dismissal":false,"text":"","timestamp":1751661347,"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":"12284362","event":"ball","batsman_id":"49330","bowler_id":"48438","over":"19","ball":"3","score":6,"commentary":"Luke Procter to Luke Wells, Six,","noball_dismissal":false,"text":"","timestamp":1751661442,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false}],"day":"0","session":"0","live_inning":{"iid":199118,"number":2,"name":"Lancashire Inning","short_name":"LAN Inning","status":2,"issuperover":"false","result":3,"batting_team_id":7023,"fielding_team_id":7038,"scores":"181\/5","scores_full":"181\/5 (19.3 ov)","fielder":[{"fielder_id":"46884","fielder_name":"Ricardo Vasconcelos","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"93459","fielder_name":"Lloyd Pope","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"50478","fielder_name":"Lewis McManus","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":"Liam Livingstone","batsman_id":"48436","runs":"19","balls":"9","how_out":"b GLS Scrimshaw","score_at_dismissal":167,"overs_at_dismissal":"18.6","bowler_id":"50387","dismissal":"bowled","number":5},"extra_runs":{"byes":0,"legbyes":3,"wides":8,"noballs":0,"penalty":"0","total":11},"equations":{"runs":181,"wickets":5,"overs":"19.3","bowlers_used":8,"runrate":"9.28"},"current_partnership":{"runs":14,"balls":3,"overs":0.3,"batsmen":[{"name":"Luke Wells","batsman_id":49330,"runs":14,"balls":3},{"name":"Chris Green","batsman_id":43448,"runs":0,"balls":0}]},"did_not_bat":[{"player_id":"93763","name":"Jack Blatherwick"},{"player_id":"50411","name":"Luke Wood"},{"player_id":"1052","name":"Saqib Mahmood"},{"player_id":"113","name":"James Anderson"}],"max_over":"20","target":"178","recent_scores":"6,6,2,w,6,1,w,1,4,w,1,6,1,1,1,1,1,0","last_five_overs":"56\/4 11.20","last_ten_overs":"106\/4 10.43"},"teams":[{"tid":7023,"title":"Lancashire","abbr":"LAN","alt_name":"LAN","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/lancashire-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/lancashire-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"181\/5 (19.3 ov)","scores":"181\/5","overs":"19.3"},{"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":"177\/10 (20 ov)","scores":"177\/10","overs":"20"}],"players":[{"pid":105,"title":"Jos Buttler","short_name":"J Buttler","first_name":"Jos Buttler","last_name":"","middle_name":"","birthdate":"1990-09-08","birthplace":"Taunton, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicket keeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/josbuttler\/","twitter_profile":"https:\/\/twitter.com\/josbuttler","instagram_profile":"https:\/\/www.instagram.com\/josbuttler\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":113,"title":"James Anderson","short_name":"J Anderson","first_name":"James Anderson","last_name":"","middle_name":"","birthdate":"1982-07-30","birthplace":"Burnley, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/JimmyAnderson\/","twitter_profile":"https:\/\/twitter.com\/jimmy9","instagram_profile":"https:\/\/www.instagram.com\/jimmya9\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"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":"squad","role_str":""},{"pid":1052,"title":"Saqib Mahmood","short_name":"S Mahmood","first_name":"Saqib Mahmood","last_name":"","middle_name":"","birthdate":"1997-02-25","birthplace":" Birmingham, Warwickshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/saqmahmood25\/","twitter_profile":"https:\/\/twitter.com\/SaqMahmood25","instagram_profile":"https:\/\/www.instagram.com\/saqmahmood25\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"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":43448,"title":"Chris Green","short_name":"CJ Green","first_name":"Chris Green","last_name":"","middle_name":"","birthdate":"1993-10-01","birthplace":"Durban, Natal, South Africa","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/chrisgreen_93\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Australia","role":"all","role_str":""},{"pid":43580,"title":"Marcus Harris","short_name":"MS Harris","first_name":"Marcus Harris","last_name":"","middle_name":"","birthdate":"1992-07-21","birthplace":"Perth, Australia","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/marcusharris14\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":43584,"title":"Ashton Turner","short_name":"AJ Turner","first_name":"Ashton Turner","last_name":"","middle_name":"","birthdate":"1993-01-25","birthplace":"Perth","country":"au","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/ashtonturner_70\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Australia","role":"bat","role_str":""},{"pid":46286,"title":"Will Williams","short_name":"WSA Williams","first_name":"Will Williams","last_name":"","middle_name":"","birthdate":"1992-10-06","birthplace":" Christchurch, Canterbury","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","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":"squad","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":48436,"title":"Liam Livingstone","short_name":"L Livingstone","first_name":"Liam Livingstone","last_name":"","middle_name":"","birthdate":"1993-08-04","birthplace":"Barrow-in-Furness, Cumberland","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/Livingstone23era\/","twitter_profile":"https:\/\/twitter.com\/liaml4893","instagram_profile":"https:\/\/www.instagram.com\/liaml4893\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","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":49330,"title":"Luke Wells","short_name":"LWP Wells","first_name":"Luke Wells","last_name":"","middle_name":"","birthdate":"1990-12-29","birthplace":"Eastbourne, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/luke_wells07","instagram_profile":"https:\/\/www.instagram.com\/l.wells07\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","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":49538,"title":"Keaton Jennings","short_name":"KK Jennings","first_name":"Keaton Jennings","last_name":"","middle_name":"","birthdate":"1992-06-19","birthplace":"Johannesburg, Transvaal","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left 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":"https:\/\/twitter.com\/jetjennings?lang=en","instagram_profile":"https:\/\/www.instagram.com\/keatonjetjennings\/?hl=en","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"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":49779,"title":"Tom Bailey","short_name":"TE Bailey","first_name":"Tom Bailey","last_name":"","middle_name":"","birthdate":"1991-04-21","birthplace":"Preston, 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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":49818,"title":"Phil Salt","short_name":"P Salt","first_name":"Phil Salt","last_name":"","middle_name":"","birthdate":"1996-08-28","birthplace":"Bodelwyddan, North Wales","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/RealPhilSalt\/","twitter_profile":"https:\/\/twitter.com\/PhilSalt1","instagram_profile":"https:\/\/www.instagram.com\/phil_salt\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"wk","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":50411,"title":"Luke Wood","short_name":"L Wood","first_name":"Luke Wood","last_name":"","middle_name":"","birthdate":"1995-08-02","birthplace":"Sheffield, Yorkshire","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/lwood_95\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","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":51279,"title":"Josh Bohannon","short_name":"JJ Bohannon","first_name":"Josh Bohannon","last_name":"","middle_name":"","birthdate":"1997-04-09","birthplace":"Bolton, Lancashire","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":"https:\/\/twitter.com\/TheCricketerMag\/status\/1517827240205115393","instagram_profile":"https:\/\/www.instagram.com\/joshbo97\/?hl=en","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":52207,"title":"Anderson Phillip","short_name":"A Phillip","first_name":"Anderson Phillip","last_name":"","middle_name":"","birthdate":"1996-08-22","birthplace":"","country":"wi","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","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":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":93640,"title":"Michael Jones","short_name":"MA Jones","first_name":"Michael Jones","last_name":"","middle_name":"","birthdate":"1998-01-05","birthplace":"Ormskirk, Lancashire","country":"sct","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\/mikejones04","instagram_profile":"https:\/\/www.instagram.com\/ah_michaeljones\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Scotland","role":"squad","role_str":""},{"pid":93763,"title":"Jack Blatherwick","short_name":"JM Blatherwick","first_name":"Jack Blatherwick","last_name":"","middle_name":"","birthdate":"1998-06-04","birthplace":" Nottingham, Nottinghamshire,","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":94941,"title":"Tom Hartley","short_name":"T Hartley","first_name":"Tom Hartley","last_name":"","middle_name":"","birthdate":"1998-05-03","birthplace":" Ormskirk, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/tomhartley100","instagram_profile":"https:\/\/www.instagram.com\/tomwhartley\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":94964,"title":"George Balderson","short_name":"G Balderson","first_name":"George Balderson","last_name":"","middle_name":"","birthdate":"2000-10-11","birthplace":"Manchester","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","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":102544,"title":"Mitchell Stanley","short_name":"M Stanley","first_name":"Mitchell Stanley","last_name":"","middle_name":"","birthdate":"2001-03-17","birthplace":"Telford, Shropshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/m.s.stanley\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":"bat","role_str":""},{"pid":108404,"title":"George Bell","short_name":"G Bell","first_name":"George Bell","last_name":"","middle_name":"","birthdate":"2002-09-25","birthplace":" Manchester, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/GeorgeB_77","instagram_profile":"https:\/\/www.instagram.com\/georgebell78\/?hl=en","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","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":109267,"title":"Tom Aspinwall","short_name":"T Aspinwall","first_name":"Tom Aspinwall","last_name":"","middle_name":"","birthdate":"2004-03-13","birthplace":"Lancaster, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":113352,"title":"Joshua Boyden","short_name":"JA Boyden","first_name":"Joshua Boyden","last_name":"","middle_name":"","birthdate":"2004-04-16","birthplace":"Chorley, Lancashire, England","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm 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":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":"bat","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":118933,"title":"Harry Singh","short_name":"HPN Singh","first_name":"Harry Singh","last_name":"","middle_name":"","birthdate":"2004-06-16","birthplace":"Blackburn, Lancashire, England","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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":118934,"title":"Matthew Hurst","short_name":"M Hurst","first_name":"Matthew Hurst","last_name":"","middle_name":"","birthdate":"2003-12-10","birthplace":"","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\/MattHurst","instagram_profile":"https:\/\/www.instagram.com\/thematthurst\/?hl=en","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":130436,"title":"Keshana Fonseka","short_name":"K Fonseka","first_name":"Keshana Fonseka","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":130438,"title":"Charlie Barnard","short_name":"CM Barnard","first_name":"Charlie Barnard","last_name":"","middle_name":"","birthdate":"2004-11-05","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","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":140792,"title":"Rocky Flintoff","short_name":"Rocky Flintoff","first_name":"Rocky Flintoff","last_name":"","middle_name":"","birthdate":"2008-04-07","birthplace":"","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":141395,"title":"Ollie Sutton","short_name":"O Sutton","first_name":"Ollie Sutton","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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":"3da8b632ebf048dc47260f80e8b31cd7","modified":"2025-07-16 01:09:26","datetime":"2025-07-16 01:09:26","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86894 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:eed1ada8-b268-4e09-b5d7-c362c3d1f3da
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86894 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86894,3,'{"status":"ok","response":{"match_id":86894,"title":"Northamptonshire vs Lancashire","short_title":"NOR vs LAN","subtitle":"Match 74","match_number":"74","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Lancashire won by 5 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129425,"title":"Vitality Blast","abbr":"Vitality Blast","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-09-13","country":"en","total_matches":"133","total_rounds":"2","total_teams":"18"},"teama":{"team_id":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":"177\/10 (20 ov)","scores":"177\/10","overs":"20"},"teamb":{"team_id":7023,"name":"Lancashire","short_name":"LAN","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/lancashire-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/lancashire-logo.png","scores_full":"181\/5 (19.3 ov)","scores":"181\/5","overs":"19.3"},"date_start":"2025-07-04 17:30:00","date_end":"2025-07-05 03:30:00","timestamp_start":1751650200,"timestamp_end":1751686200,"date_start_ist":"2025-07-04 23:00:00","date_end_ist":"2025-07-05 09:00:00","venue":{"venue_id":"46","name":"County Ground","location":"Northampton","country":"England","timezone":""},"umpires":" Rob Bailey (England), Simon Widdup (England)","referee":" James Whitaker (England)","equation":"","live":"","result":"LAN won by 5 wickets","result_type":2,"win_margin":"5 wickets","winning_team_id":7023,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-26 20:57:44","verify_time":"2025-07-05 02:35:01","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":18.89,"humidity":58,"visibility":10000,"wind_speed":"16.28","clouds":99},"pitch":{"pitch_condition":"","batting_condition":"Average","pace_bowling_condition":"Average","spine_bowling_condition":"Average"},"toss":{"text":"Northamptonshire elected to bat","winner":7038,"decision":1}},"etag":"2f44190b3c7c3a23332ecb3a99f7a7aa","modified":"2025-07-16 01:09:27","datetime":"2025-07-16 01:09:27","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":86894,"title":"Northamptonshire vs Lancashire","short_title":"NOR vs LAN","subtitle":"Match 74","match_number":"74","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Lancashire won by 5 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129425,"title":"Vitality Blast","abbr":"Vitality Blast","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-09-13","country":"en","total_matches":"133","total_rounds":"2","total_teams":"18"},"teama":{"team_id":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":"177\/10 (20 ov)","scores":"177\/10","overs":"20"},"teamb":{"team_id":7023,"name":"Lancashire","short_name":"LAN","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/lancashire-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/lancashire-logo.png","scores_full":"181\/5 (19.3 ov)","scores":"181\/5","overs":"19.3"},"date_start":"2025-07-04 17:30:00","date_end":"2025-07-05 03:30:00","timestamp_start":1751650200,"timestamp_end":1751686200,"date_start_ist":"2025-07-04 23:00:00","date_end_ist":"2025-07-05 09:00:00","venue":{"venue_id":"46","name":"County Ground","location":"Northampton","country":"England","timezone":""},"umpires":" Rob Bailey (England), Simon Widdup (England)","referee":" James Whitaker (England)","equation":"","live":"","result":"LAN won by 5 wickets","result_type":2,"win_margin":"5 wickets","winning_team_id":7023,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-26 20:57:44","verify_time":"2025-07-05 02:35:01","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":18.89,"humidity":58,"visibility":10000,"wind_speed":"16.28","clouds":99},"pitch":{"pitch_condition":"","batting_condition":"Average","pace_bowling_condition":"Average","spine_bowling_condition":"Average"},"toss":{"text":"Northamptonshire elected to bat","winner":7038,"decision":1}},"etag":"2f44190b3c7c3a23332ecb3a99f7a7aa","modified":"2025-07-16 01:09:27","datetime":"2025-07-16 01:09:27","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86894 AND DataTypeId = 3 END Live Report & Scorecard of Northamptonshire vs Lancashire Match 74
Northamptonshire vs Lancashire, Live Cricket Commentary