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:948bb729-ad1a-4a36-a5b3-ba5a734c59ce
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86899 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86899,1,'{"status":"ok","response":{"mid":86899,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Lancashire won by 42 runs","day_remaining_over":"","team_batting":"Derbyshire","team_bowling":"Lancashire","live_inning_number":2,"live_score":{"runs":136,"overs":20,"wickets":6,"target":179,"runrate":6.8,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Zak Chappell","batsman_id":49808,"runs":34,"balls_faced":26,"fours":3,"sixes":1,"strike_rate":"130.77"},{"name":"Ross Whiteley","batsman_id":43360,"runs":14,"balls_faced":12,"fours":0,"sixes":1,"strike_rate":"116.67"}],"bowlers":[{"name":"Chris Green","bowler_id":43448,"overs":4,"runs_conceded":26,"wickets":2,"maidens":0,"econ":"6.50"},{"name":"Luke Wood","bowler_id":50411,"overs":4,"runs_conceded":25,"wickets":3,"maidens":0,"econ":"6.25"}],"commentaries":[{"event_id":"12289337","event":"ball","batsman_id":"43360","bowler_id":"43448","over":"15","ball":"6","score":1,"commentary":"Chris Green to Ross Whiteley, 1 run,","noball_dismissal":false,"text":"","timestamp":1751733817,"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":16,"runs":6,"score":"96\/6","bats":[{"runs":3,"balls_faced":5,"fours":0,"sixes":0,"batsman_id":43360},{"runs":7,"balls_faced":9,"fours":0,"sixes":0,"batsman_id":49808}],"bowls":[{"runs_conceded":16,"maidens":0,"wickets":2,"bowler_id":43448,"overs":3},{"runs_conceded":15,"maidens":0,"wickets":0,"bowler_id":93763,"overs":3}],"commentary":"End of over 16 (6 runs), Derbyshire 96\/6"},{"event_id":"12289351","event":"ball","batsman_id":"43360","bowler_id":"49330","over":"16","ball":"1","score":1,"commentary":"Luke Wells to Ross Whiteley, 1 run,","noball_dismissal":false,"text":"","timestamp":1751734046,"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":"12289355","event":"ball","batsman_id":"49808","bowler_id":"49330","over":"16","ball":"2","score":4,"commentary":"Luke Wells to Zak Chappell, Four,","noball_dismissal":false,"text":"","timestamp":1751734050,"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":"12289357","event":"ball","batsman_id":"49808","bowler_id":"49330","over":"16","ball":"3","score":0,"commentary":"Luke Wells to Zak Chappell, no run,","noball_dismissal":false,"text":"","timestamp":1751734053,"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":"12289358","event":"ball","batsman_id":"49808","bowler_id":"49330","over":"16","ball":"4","score":1,"commentary":"Luke Wells to Zak Chappell, 1 run,","noball_dismissal":false,"text":"","timestamp":1751734055,"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":"12289359","event":"ball","batsman_id":"43360","bowler_id":"49330","over":"16","ball":"5","score":1,"commentary":"Luke Wells to Ross Whiteley, 1 run,","noball_dismissal":false,"text":"","timestamp":1751734058,"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":"12289363","event":"ball","batsman_id":"49808","bowler_id":"49330","over":"16","ball":"6","score":1,"commentary":"Luke Wells to Zak Chappell, 1 run,","noball_dismissal":false,"text":"","timestamp":1751734066,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":17,"runs":8,"score":"104\/6","bats":[{"runs":13,"balls_faced":13,"fours":1,"sixes":0,"batsman_id":49808},{"runs":5,"balls_faced":7,"fours":0,"sixes":0,"batsman_id":43360}],"bowls":[{"runs_conceded":30,"maidens":0,"wickets":1,"bowler_id":49330,"overs":4},{"runs_conceded":16,"maidens":0,"wickets":2,"bowler_id":43448,"overs":3}],"commentary":"End of over 17 (8 runs), Derbyshire 104\/6"},{"event_id":"12289369","event":"ball","batsman_id":"49808","bowler_id":"93763","over":"17","ball":"1","score":1,"commentary":"Jack Blatherwick to Zak Chappell, 1 run,","noball_dismissal":false,"text":"","timestamp":1751735010,"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":"12289370","event":"ball","batsman_id":"43360","bowler_id":"93763","over":"17","ball":"2","score":1,"commentary":"Jack Blatherwick to Ross Whiteley, 1 run,","noball_dismissal":false,"text":"","timestamp":1751735004,"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":"12289373","event":"ball","batsman_id":"49808","bowler_id":"93763","over":"17","ball":"3","score":1,"commentary":"Jack Blatherwick to Zak Chappell, 1 run,","noball_dismissal":false,"text":"","timestamp":1751734994,"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":"12289378","event":"ball","batsman_id":"43360","bowler_id":"93763","over":"17","ball":"4","score":6,"commentary":"Jack Blatherwick to Ross Whiteley, Six,","noball_dismissal":false,"text":"","timestamp":1751734985,"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":"12289380","event":"ball","batsman_id":"43360","bowler_id":"93763","over":"17","ball":"5","score":"1lb","commentary":"Jack Blatherwick to Ross Whiteley, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1751734980,"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":"12289381","event":"ball","batsman_id":"49808","bowler_id":"93763","over":"17","ball":"6","score":1,"commentary":"Jack Blatherwick to Zak Chappell, 1 run,","noball_dismissal":false,"text":"","timestamp":1751734969,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":18,"runs":11,"score":"115\/6","bats":[{"runs":16,"balls_faced":16,"fours":1,"sixes":0,"batsman_id":49808},{"runs":12,"balls_faced":10,"fours":0,"sixes":1,"batsman_id":43360}],"bowls":[{"runs_conceded":25,"maidens":0,"wickets":0,"bowler_id":93763,"overs":4},{"runs_conceded":30,"maidens":0,"wickets":1,"bowler_id":49330,"overs":4}],"commentary":"End of over 18 (11 runs), Derbyshire 115\/6"},{"event_id":"12289390","event":"ball","batsman_id":"49808","bowler_id":"50411","over":"18","ball":"1","score":0,"commentary":"Luke Wood to Zak Chappell, no run,","noball_dismissal":false,"text":"","timestamp":1751734366,"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":"12289392","event":"ball","batsman_id":"49808","bowler_id":"50411","over":"18","ball":"2","score":6,"commentary":"Luke Wood to Zak Chappell, Six,","noball_dismissal":false,"text":"","timestamp":1751734390,"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":"12289401","event":"ball","batsman_id":"49808","bowler_id":"50411","over":"18","ball":"3","score":0,"commentary":"Luke Wood to Zak Chappell, no run,","noball_dismissal":false,"text":"","timestamp":1751734440,"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":"12289411","event":"ball","batsman_id":"49808","bowler_id":"50411","over":"18","ball":"4","score":"1wd","commentary":"Luke Wood to Zak Chappell, 1 wide,","noball_dismissal":false,"text":"","timestamp":1751734496,"run":1,"noball_run":"0","wide_run":"1","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12289414","event":"ball","batsman_id":"49808","bowler_id":"50411","over":"18","ball":"4","score":0,"commentary":"Luke Wood to Zak Chappell, no run,","noball_dismissal":false,"text":"","timestamp":1751734608,"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":"12289418","event":"ball","batsman_id":"49808","bowler_id":"50411","over":"18","ball":"5","score":4,"commentary":"Luke Wood to Zak Chappell, Four,","noball_dismissal":false,"text":"","timestamp":1751734618,"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":"12289419","event":"ball","batsman_id":"49808","bowler_id":"50411","over":"18","ball":"6","score":0,"commentary":"Luke Wood to Zak Chappell, no run,","noball_dismissal":false,"text":"","timestamp":1751734628,"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":19,"runs":11,"score":"126\/6","bats":[{"runs":26,"balls_faced":22,"fours":2,"sixes":1,"batsman_id":49808},{"runs":12,"balls_faced":10,"fours":0,"sixes":1,"batsman_id":43360}],"bowls":[{"runs_conceded":25,"maidens":0,"wickets":3,"bowler_id":50411,"overs":4},{"runs_conceded":25,"maidens":0,"wickets":0,"bowler_id":93763,"overs":4}],"commentary":"End of over 19 (11 runs), Derbyshire 126\/6"},{"event_id":"12289422","event":"ball","batsman_id":"43360","bowler_id":"43448","over":"19","ball":"1","score":1,"commentary":"Chris Green to Ross Whiteley, 1 run,","noball_dismissal":false,"text":"","timestamp":1751734649,"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":"12289423","event":"ball","batsman_id":"49808","bowler_id":"43448","over":"19","ball":"2","score":2,"commentary":"Chris Green to Zak Chappell, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751734699,"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":"12289426","event":"ball","batsman_id":"49808","bowler_id":"43448","over":"19","ball":"3","score":1,"commentary":"Chris Green to Zak Chappell, 1 run,","noball_dismissal":false,"text":"","timestamp":1751734720,"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":"12289427","event":"ball","batsman_id":"43360","bowler_id":"43448","over":"19","ball":"4","score":1,"commentary":"Chris Green to Ross Whiteley, 1 run,","noball_dismissal":false,"text":"","timestamp":1751734729,"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":"12289429","event":"ball","batsman_id":"49808","bowler_id":"43448","over":"19","ball":"5","score":4,"commentary":"Chris Green to Zak Chappell, Four,","noball_dismissal":false,"text":"","timestamp":1751734761,"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":"12289433","event":"ball","batsman_id":"49808","bowler_id":"43448","over":"19","ball":"6","score":1,"commentary":"Chris Green to Zak Chappell, 1 run,","noball_dismissal":false,"text":"","timestamp":1751734779,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":20,"runs":10,"score":"136\/6","bats":[{"runs":34,"balls_faced":26,"fours":3,"sixes":1,"batsman_id":49808},{"runs":14,"balls_faced":12,"fours":0,"sixes":1,"batsman_id":43360}],"bowls":[{"runs_conceded":26,"maidens":0,"wickets":2,"bowler_id":43448,"overs":4},{"runs_conceded":25,"maidens":0,"wickets":3,"bowler_id":50411,"overs":4}],"commentary":"End of over 20 (10 runs), Derbyshire 136\/6"}],"day":"0","session":"0","live_inning":{"iid":199160,"number":2,"name":"Derbyshire Inning","short_name":"DER Inning","status":2,"issuperover":"false","result":4,"batting_team_id":104949,"fielding_team_id":7023,"scores":"136\/6","scores_full":"136\/6 (20 ov)","fielder":[{"fielder_id":"49538","fielder_name":"Keaton Jennings","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"1052","fielder_name":"Saqib Mahmood","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"50411","fielder_name":"Luke Wood","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"49818","fielder_name":"Phil Salt","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":"Wayne Madsen","batsman_id":"48641","runs":"53","balls":"40","how_out":"c KK Jennings b CJ Green","score_at_dismissal":86,"overs_at_dismissal":"13.5","bowler_id":"43448","dismissal":"caught","number":6},"extra_runs":{"byes":1,"legbyes":2,"wides":2,"noballs":0,"penalty":"0","total":5},"equations":{"runs":136,"wickets":6,"overs":"20","bowlers_used":6,"runrate":"6.80"},"current_partnership":{"runs":50,"balls":37,"overs":6.1,"batsmen":[{"name":"Zak Chappell","batsman_id":49808,"runs":34,"balls":26},{"name":"Ross Whiteley","batsman_id":43360,"runs":13,"balls":11}]},"did_not_bat":[{"player_id":"84689","name":"Pat Brown"},{"player_id":"101484","name":"Ben William Aitchison"},{"player_id":"118504","name":"Allah Mohammad Ghazanfar"}],"max_over":"20","target":"179","recent_scores":"1,4,1,1,2,1,0,4,0,1,0,6,0,1,1,6,1,1","last_five_overs":"46\/0 8.90","last_ten_overs":"77\/3 7.57"},"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":"178\/6 (20 ov)","scores":"178\/6","overs":"20"},{"tid":104949,"title":"Derbyshire","abbr":"DER","alt_name":"DER","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/derbyshire-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/derbyshire-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"136\/6 (20 ov)","scores":"136\/6","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":"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":1259,"title":"Aneurin Donald","short_name":"A Donald","first_name":"Aneurin Donald","last_name":"","middle_name":"","birthdate":"1996-12-20","birthplace":"Swansea, Glamorgan","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/aneurin.donald\/","twitter_profile":"https:\/\/twitter.com\/AneurinDonald12","instagram_profile":"https:\/\/www.instagram.com\/aneurindonald\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":""},{"pid":7735,"title":"David Lloyd","short_name":"DL Lloyd","first_name":"David Lloyd","last_name":"","middle_name":"","birthdate":"1992-06-15","birthplace":"St Asaph, Flintshire, Wales","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/davidlloyduk\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":10594,"title":"Samit Patel","short_name":"SR Patel","first_name":"Samit Patel","last_name":"","middle_name":"","birthdate":"1984-11-30","birthplace":"Leicester","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/samitpatel","instagram_profile":"https:\/\/www.instagram.com\/samit._.patel\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":"(C)"},{"pid":43360,"title":"Ross Whiteley","short_name":"RA Whiteley","first_name":"Ross Whiteley","last_name":"","middle_name":"","birthdate":"1988-09-13","birthplace":"Sheffield, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/RossWhiteley44","instagram_profile":"https:\/\/www.instagram.com\/rosswhiteley44\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":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":46310,"title":"Blair Tickner","short_name":"BM Tickner","first_name":"Blair Tickner","last_name":"","middle_name":"","birthdate":"1993-10-13","birthplace":"Napier, Hawke''s Bay","country":"nz","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"https:\/\/www.facebook.com\/blair.tickner\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/ticks93\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"squad","role_str":""},{"pid":48428,"title":"Luis Reece","short_name":"LM Reece","first_name":"Luis Reece","last_name":"","middle_name":"","birthdate":"1990-08-04","birthplace":"Taunton, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lreece17","instagram_profile":"https:\/\/www.instagram.com\/louisreece\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":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":48498,"title":"Caleb Jewell","short_name":"CP Jewell","first_name":"Caleb Jewell","last_name":"","middle_name":"","birthdate":"1997-04-21","birthplace":"Hobart, Tasmania","country":"au","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/caleb.jewell.148\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/cjewell_32\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"bat","role_str":""},{"pid":48508,"title":"Brooke Guest","short_name":"BD Guest","first_name":"Brooke Guest","last_name":"","middle_name":"","birthdate":"1997-05-14","birthplace":"Whitworth Park, Manchester, England","country":"au","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/guesty211\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"wk","role_str":"(WK)"},{"pid":48641,"title":"Wayne Madsen","short_name":"WL Madsen","first_name":"Wayne Madsen","last_name":"","middle_name":"","birthdate":"1984-01-02","birthplace":"Durban","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/waynemadders77","instagram_profile":"https:\/\/www.instagram.com\/waynemadsen77\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":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":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":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":49808,"title":"Zak Chappell","short_name":"ZJ Chappell","first_name":"Zak Chappell","last_name":"","middle_name":"","birthdate":"1996-08-21","birthplace":"Grantham, Lincolnshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/chappooo","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":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":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":50433,"title":"Alex Thomson","short_name":"AT Thomson","first_name":"Alex Thomson","last_name":"","middle_name":"","birthdate":"1993-10-30","birthplace":"Stoke-on-Trent, Staffordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/alextomo","instagram_profile":"https:\/\/www.instagram.com\/alex_thomson_racing\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50528,"title":"Anuj Dal","short_name":"AK Dal","first_name":"Anuj Dal","last_name":"","middle_name":"","birthdate":"1996-07-08","birthplace":"Newcastle-under-Lyme, Staffordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/AnujDal","instagram_profile":"https:\/\/www.instagram.com\/anujdal0\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50663,"title":"Fynn Hudson-Prentice","short_name":"FJ Hudson-Prentice","first_name":"Fynn Hudson-Prentice","last_name":"","middle_name":"","birthdate":"1996-01-12","birthplace":"Haywards Heath, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/fynnhudson33","instagram_profile":"https:\/\/www.instagram.com\/fynnhudson33\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51064,"title":"Martin Andersson","short_name":"MK Andersson","first_name":"Martin Andersson","last_name":"","middle_name":"","birthdate":"1996-09-06","birthplace":"Reading, Berkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/MartinAnderss11","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":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":84689,"title":"Pat Brown","short_name":"PR Brown","first_name":"Pat Brown","last_name":"","middle_name":"","birthdate":"1998-08-23","birthplace":"Peterborough, Cambridgeshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/patbrowny\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":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":"bat","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":94962,"title":"Harry Came","short_name":"H Came","first_name":"Harry Came","last_name":"","middle_name":"","birthdate":"1998-08-27","birthplace":"Hampshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/HarryCame4","instagram_profile":"https:\/\/www.instagram.com\/harrycame4\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":94963,"title":"Jack Morley","short_name":"J Morley","first_name":"Jack Morley","last_name":"","middle_name":"","birthdate":"2001-06-25","birthplace":"Rochdale, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":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":101484,"title":"Ben William Aitchison","short_name":"B W Aitchison","first_name":"Ben William Aitchison","last_name":"","middle_name":"","birthdate":"1999-07-06","birthplace":"Southport, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Benaitchison123","instagram_profile":"https:\/\/www.instagram.com\/baitchison13\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":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":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":108586,"title":"Nick Potts","short_name":"N Potts","first_name":"Nick Potts","last_name":"","middle_name":"","birthdate":"2002-07-17","birthplace":"Burton-on-Trent, Staffordshire,","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/nickwpotts\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":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":109363,"title":"Mitchell Wagstaff","short_name":"M Wagstaff","first_name":"Mitchell Wagstaff","last_name":"","middle_name":"","birthdate":"2003-09-02","birthplace":"Derby","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/mitchellwaggy?lang=en","instagram_profile":"https:\/\/www.instagram.com\/mitchellwagstaff\/?hl=en","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":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":118504,"title":"Allah Mohammad Ghazanfar","short_name":"AM Ghazanfar","first_name":"Allah Mohammad Ghazanfar","last_name":"","middle_name":"","birthdate":"2007-07-15","birthplace":"","country":"af","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/Ghazanfar050\/","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Afghanistan","role":"bowl","role_str":""},{"pid":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":130162,"title":"Harry Moore","short_name":"HJ Moore","first_name":"Harry Moore","last_name":"","middle_name":"","birthdate":"2007-04-26","birthplace":"Houston, Florida","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/ha66y2004","instagram_profile":"https:\/\/www.instagram.com\/harrymoore72\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":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":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":141343,"title":"Yousaf Bin Naeem","short_name":"YB Naeem","first_name":"Yousaf Bin Naeem","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":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":""}]},"etag":"04c8b07d74c5e1545b22607691a4426e","modified":"2025-07-15 23:25:26","datetime":"2025-07-15 23:25:26","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":86899,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Lancashire won by 42 runs","day_remaining_over":"","team_batting":"Derbyshire","team_bowling":"Lancashire","live_inning_number":2,"live_score":{"runs":136,"overs":20,"wickets":6,"target":179,"runrate":6.8,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Zak Chappell","batsman_id":49808,"runs":34,"balls_faced":26,"fours":3,"sixes":1,"strike_rate":"130.77"},{"name":"Ross Whiteley","batsman_id":43360,"runs":14,"balls_faced":12,"fours":0,"sixes":1,"strike_rate":"116.67"}],"bowlers":[{"name":"Chris Green","bowler_id":43448,"overs":4,"runs_conceded":26,"wickets":2,"maidens":0,"econ":"6.50"},{"name":"Luke Wood","bowler_id":50411,"overs":4,"runs_conceded":25,"wickets":3,"maidens":0,"econ":"6.25"}],"commentaries":[{"event_id":"12289337","event":"ball","batsman_id":"43360","bowler_id":"43448","over":"15","ball":"6","score":1,"commentary":"Chris Green to Ross Whiteley, 1 run,","noball_dismissal":false,"text":"","timestamp":1751733817,"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":16,"runs":6,"score":"96\/6","bats":[{"runs":3,"balls_faced":5,"fours":0,"sixes":0,"batsman_id":43360},{"runs":7,"balls_faced":9,"fours":0,"sixes":0,"batsman_id":49808}],"bowls":[{"runs_conceded":16,"maidens":0,"wickets":2,"bowler_id":43448,"overs":3},{"runs_conceded":15,"maidens":0,"wickets":0,"bowler_id":93763,"overs":3}],"commentary":"End of over 16 (6 runs), Derbyshire 96\/6"},{"event_id":"12289351","event":"ball","batsman_id":"43360","bowler_id":"49330","over":"16","ball":"1","score":1,"commentary":"Luke Wells to Ross Whiteley, 1 run,","noball_dismissal":false,"text":"","timestamp":1751734046,"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":"12289355","event":"ball","batsman_id":"49808","bowler_id":"49330","over":"16","ball":"2","score":4,"commentary":"Luke Wells to Zak Chappell, Four,","noball_dismissal":false,"text":"","timestamp":1751734050,"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":"12289357","event":"ball","batsman_id":"49808","bowler_id":"49330","over":"16","ball":"3","score":0,"commentary":"Luke Wells to Zak Chappell, no run,","noball_dismissal":false,"text":"","timestamp":1751734053,"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":"12289358","event":"ball","batsman_id":"49808","bowler_id":"49330","over":"16","ball":"4","score":1,"commentary":"Luke Wells to Zak Chappell, 1 run,","noball_dismissal":false,"text":"","timestamp":1751734055,"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":"12289359","event":"ball","batsman_id":"43360","bowler_id":"49330","over":"16","ball":"5","score":1,"commentary":"Luke Wells to Ross Whiteley, 1 run,","noball_dismissal":false,"text":"","timestamp":1751734058,"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":"12289363","event":"ball","batsman_id":"49808","bowler_id":"49330","over":"16","ball":"6","score":1,"commentary":"Luke Wells to Zak Chappell, 1 run,","noball_dismissal":false,"text":"","timestamp":1751734066,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":17,"runs":8,"score":"104\/6","bats":[{"runs":13,"balls_faced":13,"fours":1,"sixes":0,"batsman_id":49808},{"runs":5,"balls_faced":7,"fours":0,"sixes":0,"batsman_id":43360}],"bowls":[{"runs_conceded":30,"maidens":0,"wickets":1,"bowler_id":49330,"overs":4},{"runs_conceded":16,"maidens":0,"wickets":2,"bowler_id":43448,"overs":3}],"commentary":"End of over 17 (8 runs), Derbyshire 104\/6"},{"event_id":"12289369","event":"ball","batsman_id":"49808","bowler_id":"93763","over":"17","ball":"1","score":1,"commentary":"Jack Blatherwick to Zak Chappell, 1 run,","noball_dismissal":false,"text":"","timestamp":1751735010,"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":"12289370","event":"ball","batsman_id":"43360","bowler_id":"93763","over":"17","ball":"2","score":1,"commentary":"Jack Blatherwick to Ross Whiteley, 1 run,","noball_dismissal":false,"text":"","timestamp":1751735004,"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":"12289373","event":"ball","batsman_id":"49808","bowler_id":"93763","over":"17","ball":"3","score":1,"commentary":"Jack Blatherwick to Zak Chappell, 1 run,","noball_dismissal":false,"text":"","timestamp":1751734994,"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":"12289378","event":"ball","batsman_id":"43360","bowler_id":"93763","over":"17","ball":"4","score":6,"commentary":"Jack Blatherwick to Ross Whiteley, Six,","noball_dismissal":false,"text":"","timestamp":1751734985,"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":"12289380","event":"ball","batsman_id":"43360","bowler_id":"93763","over":"17","ball":"5","score":"1lb","commentary":"Jack Blatherwick to Ross Whiteley, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1751734980,"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":"12289381","event":"ball","batsman_id":"49808","bowler_id":"93763","over":"17","ball":"6","score":1,"commentary":"Jack Blatherwick to Zak Chappell, 1 run,","noball_dismissal":false,"text":"","timestamp":1751734969,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":18,"runs":11,"score":"115\/6","bats":[{"runs":16,"balls_faced":16,"fours":1,"sixes":0,"batsman_id":49808},{"runs":12,"balls_faced":10,"fours":0,"sixes":1,"batsman_id":43360}],"bowls":[{"runs_conceded":25,"maidens":0,"wickets":0,"bowler_id":93763,"overs":4},{"runs_conceded":30,"maidens":0,"wickets":1,"bowler_id":49330,"overs":4}],"commentary":"End of over 18 (11 runs), Derbyshire 115\/6"},{"event_id":"12289390","event":"ball","batsman_id":"49808","bowler_id":"50411","over":"18","ball":"1","score":0,"commentary":"Luke Wood to Zak Chappell, no run,","noball_dismissal":false,"text":"","timestamp":1751734366,"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":"12289392","event":"ball","batsman_id":"49808","bowler_id":"50411","over":"18","ball":"2","score":6,"commentary":"Luke Wood to Zak Chappell, Six,","noball_dismissal":false,"text":"","timestamp":1751734390,"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":"12289401","event":"ball","batsman_id":"49808","bowler_id":"50411","over":"18","ball":"3","score":0,"commentary":"Luke Wood to Zak Chappell, no run,","noball_dismissal":false,"text":"","timestamp":1751734440,"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":"12289411","event":"ball","batsman_id":"49808","bowler_id":"50411","over":"18","ball":"4","score":"1wd","commentary":"Luke Wood to Zak Chappell, 1 wide,","noball_dismissal":false,"text":"","timestamp":1751734496,"run":1,"noball_run":"0","wide_run":"1","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12289414","event":"ball","batsman_id":"49808","bowler_id":"50411","over":"18","ball":"4","score":0,"commentary":"Luke Wood to Zak Chappell, no run,","noball_dismissal":false,"text":"","timestamp":1751734608,"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":"12289418","event":"ball","batsman_id":"49808","bowler_id":"50411","over":"18","ball":"5","score":4,"commentary":"Luke Wood to Zak Chappell, Four,","noball_dismissal":false,"text":"","timestamp":1751734618,"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":"12289419","event":"ball","batsman_id":"49808","bowler_id":"50411","over":"18","ball":"6","score":0,"commentary":"Luke Wood to Zak Chappell, no run,","noball_dismissal":false,"text":"","timestamp":1751734628,"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":19,"runs":11,"score":"126\/6","bats":[{"runs":26,"balls_faced":22,"fours":2,"sixes":1,"batsman_id":49808},{"runs":12,"balls_faced":10,"fours":0,"sixes":1,"batsman_id":43360}],"bowls":[{"runs_conceded":25,"maidens":0,"wickets":3,"bowler_id":50411,"overs":4},{"runs_conceded":25,"maidens":0,"wickets":0,"bowler_id":93763,"overs":4}],"commentary":"End of over 19 (11 runs), Derbyshire 126\/6"},{"event_id":"12289422","event":"ball","batsman_id":"43360","bowler_id":"43448","over":"19","ball":"1","score":1,"commentary":"Chris Green to Ross Whiteley, 1 run,","noball_dismissal":false,"text":"","timestamp":1751734649,"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":"12289423","event":"ball","batsman_id":"49808","bowler_id":"43448","over":"19","ball":"2","score":2,"commentary":"Chris Green to Zak Chappell, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751734699,"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":"12289426","event":"ball","batsman_id":"49808","bowler_id":"43448","over":"19","ball":"3","score":1,"commentary":"Chris Green to Zak Chappell, 1 run,","noball_dismissal":false,"text":"","timestamp":1751734720,"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":"12289427","event":"ball","batsman_id":"43360","bowler_id":"43448","over":"19","ball":"4","score":1,"commentary":"Chris Green to Ross Whiteley, 1 run,","noball_dismissal":false,"text":"","timestamp":1751734729,"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":"12289429","event":"ball","batsman_id":"49808","bowler_id":"43448","over":"19","ball":"5","score":4,"commentary":"Chris Green to Zak Chappell, Four,","noball_dismissal":false,"text":"","timestamp":1751734761,"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":"12289433","event":"ball","batsman_id":"49808","bowler_id":"43448","over":"19","ball":"6","score":1,"commentary":"Chris Green to Zak Chappell, 1 run,","noball_dismissal":false,"text":"","timestamp":1751734779,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":20,"runs":10,"score":"136\/6","bats":[{"runs":34,"balls_faced":26,"fours":3,"sixes":1,"batsman_id":49808},{"runs":14,"balls_faced":12,"fours":0,"sixes":1,"batsman_id":43360}],"bowls":[{"runs_conceded":26,"maidens":0,"wickets":2,"bowler_id":43448,"overs":4},{"runs_conceded":25,"maidens":0,"wickets":3,"bowler_id":50411,"overs":4}],"commentary":"End of over 20 (10 runs), Derbyshire 136\/6"}],"day":"0","session":"0","live_inning":{"iid":199160,"number":2,"name":"Derbyshire Inning","short_name":"DER Inning","status":2,"issuperover":"false","result":4,"batting_team_id":104949,"fielding_team_id":7023,"scores":"136\/6","scores_full":"136\/6 (20 ov)","fielder":[{"fielder_id":"49538","fielder_name":"Keaton Jennings","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"1052","fielder_name":"Saqib Mahmood","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"50411","fielder_name":"Luke Wood","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"49818","fielder_name":"Phil Salt","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":"Wayne Madsen","batsman_id":"48641","runs":"53","balls":"40","how_out":"c KK Jennings b CJ Green","score_at_dismissal":86,"overs_at_dismissal":"13.5","bowler_id":"43448","dismissal":"caught","number":6},"extra_runs":{"byes":1,"legbyes":2,"wides":2,"noballs":0,"penalty":"0","total":5},"equations":{"runs":136,"wickets":6,"overs":"20","bowlers_used":6,"runrate":"6.80"},"current_partnership":{"runs":50,"balls":37,"overs":6.1,"batsmen":[{"name":"Zak Chappell","batsman_id":49808,"runs":34,"balls":26},{"name":"Ross Whiteley","batsman_id":43360,"runs":13,"balls":11}]},"did_not_bat":[{"player_id":"84689","name":"Pat Brown"},{"player_id":"101484","name":"Ben William Aitchison"},{"player_id":"118504","name":"Allah Mohammad Ghazanfar"}],"max_over":"20","target":"179","recent_scores":"1,4,1,1,2,1,0,4,0,1,0,6,0,1,1,6,1,1","last_five_overs":"46\/0 8.90","last_ten_overs":"77\/3 7.57"},"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":"178\/6 (20 ov)","scores":"178\/6","overs":"20"},{"tid":104949,"title":"Derbyshire","abbr":"DER","alt_name":"DER","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/derbyshire-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/derbyshire-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"136\/6 (20 ov)","scores":"136\/6","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":"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":1259,"title":"Aneurin Donald","short_name":"A Donald","first_name":"Aneurin Donald","last_name":"","middle_name":"","birthdate":"1996-12-20","birthplace":"Swansea, Glamorgan","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/aneurin.donald\/","twitter_profile":"https:\/\/twitter.com\/AneurinDonald12","instagram_profile":"https:\/\/www.instagram.com\/aneurindonald\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":""},{"pid":7735,"title":"David Lloyd","short_name":"DL Lloyd","first_name":"David Lloyd","last_name":"","middle_name":"","birthdate":"1992-06-15","birthplace":"St Asaph, Flintshire, Wales","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/davidlloyduk\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":10594,"title":"Samit Patel","short_name":"SR Patel","first_name":"Samit Patel","last_name":"","middle_name":"","birthdate":"1984-11-30","birthplace":"Leicester","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/samitpatel","instagram_profile":"https:\/\/www.instagram.com\/samit._.patel\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":"(C)"},{"pid":43360,"title":"Ross Whiteley","short_name":"RA Whiteley","first_name":"Ross Whiteley","last_name":"","middle_name":"","birthdate":"1988-09-13","birthplace":"Sheffield, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/RossWhiteley44","instagram_profile":"https:\/\/www.instagram.com\/rosswhiteley44\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":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":46310,"title":"Blair Tickner","short_name":"BM Tickner","first_name":"Blair Tickner","last_name":"","middle_name":"","birthdate":"1993-10-13","birthplace":"Napier, Hawke''s Bay","country":"nz","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"https:\/\/www.facebook.com\/blair.tickner\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/ticks93\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"squad","role_str":""},{"pid":48428,"title":"Luis Reece","short_name":"LM Reece","first_name":"Luis Reece","last_name":"","middle_name":"","birthdate":"1990-08-04","birthplace":"Taunton, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lreece17","instagram_profile":"https:\/\/www.instagram.com\/louisreece\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":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":48498,"title":"Caleb Jewell","short_name":"CP Jewell","first_name":"Caleb Jewell","last_name":"","middle_name":"","birthdate":"1997-04-21","birthplace":"Hobart, Tasmania","country":"au","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/caleb.jewell.148\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/cjewell_32\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"bat","role_str":""},{"pid":48508,"title":"Brooke Guest","short_name":"BD Guest","first_name":"Brooke Guest","last_name":"","middle_name":"","birthdate":"1997-05-14","birthplace":"Whitworth Park, Manchester, England","country":"au","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/guesty211\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"wk","role_str":"(WK)"},{"pid":48641,"title":"Wayne Madsen","short_name":"WL Madsen","first_name":"Wayne Madsen","last_name":"","middle_name":"","birthdate":"1984-01-02","birthplace":"Durban","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/waynemadders77","instagram_profile":"https:\/\/www.instagram.com\/waynemadsen77\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":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":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":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":49808,"title":"Zak Chappell","short_name":"ZJ Chappell","first_name":"Zak Chappell","last_name":"","middle_name":"","birthdate":"1996-08-21","birthplace":"Grantham, Lincolnshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/chappooo","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":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":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":50433,"title":"Alex Thomson","short_name":"AT Thomson","first_name":"Alex Thomson","last_name":"","middle_name":"","birthdate":"1993-10-30","birthplace":"Stoke-on-Trent, Staffordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/alextomo","instagram_profile":"https:\/\/www.instagram.com\/alex_thomson_racing\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50528,"title":"Anuj Dal","short_name":"AK Dal","first_name":"Anuj Dal","last_name":"","middle_name":"","birthdate":"1996-07-08","birthplace":"Newcastle-under-Lyme, Staffordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/AnujDal","instagram_profile":"https:\/\/www.instagram.com\/anujdal0\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50663,"title":"Fynn Hudson-Prentice","short_name":"FJ Hudson-Prentice","first_name":"Fynn Hudson-Prentice","last_name":"","middle_name":"","birthdate":"1996-01-12","birthplace":"Haywards Heath, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/fynnhudson33","instagram_profile":"https:\/\/www.instagram.com\/fynnhudson33\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51064,"title":"Martin Andersson","short_name":"MK Andersson","first_name":"Martin Andersson","last_name":"","middle_name":"","birthdate":"1996-09-06","birthplace":"Reading, Berkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/MartinAnderss11","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":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":84689,"title":"Pat Brown","short_name":"PR Brown","first_name":"Pat Brown","last_name":"","middle_name":"","birthdate":"1998-08-23","birthplace":"Peterborough, Cambridgeshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/patbrowny\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":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":"bat","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":94962,"title":"Harry Came","short_name":"H Came","first_name":"Harry Came","last_name":"","middle_name":"","birthdate":"1998-08-27","birthplace":"Hampshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/HarryCame4","instagram_profile":"https:\/\/www.instagram.com\/harrycame4\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":94963,"title":"Jack Morley","short_name":"J Morley","first_name":"Jack Morley","last_name":"","middle_name":"","birthdate":"2001-06-25","birthplace":"Rochdale, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":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":101484,"title":"Ben William Aitchison","short_name":"B W Aitchison","first_name":"Ben William Aitchison","last_name":"","middle_name":"","birthdate":"1999-07-06","birthplace":"Southport, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Benaitchison123","instagram_profile":"https:\/\/www.instagram.com\/baitchison13\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":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":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":108586,"title":"Nick Potts","short_name":"N Potts","first_name":"Nick Potts","last_name":"","middle_name":"","birthdate":"2002-07-17","birthplace":"Burton-on-Trent, Staffordshire,","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/nickwpotts\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":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":109363,"title":"Mitchell Wagstaff","short_name":"M Wagstaff","first_name":"Mitchell Wagstaff","last_name":"","middle_name":"","birthdate":"2003-09-02","birthplace":"Derby","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/mitchellwaggy?lang=en","instagram_profile":"https:\/\/www.instagram.com\/mitchellwagstaff\/?hl=en","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":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":118504,"title":"Allah Mohammad Ghazanfar","short_name":"AM Ghazanfar","first_name":"Allah Mohammad Ghazanfar","last_name":"","middle_name":"","birthdate":"2007-07-15","birthplace":"","country":"af","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/Ghazanfar050\/","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Afghanistan","role":"bowl","role_str":""},{"pid":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":130162,"title":"Harry Moore","short_name":"HJ Moore","first_name":"Harry Moore","last_name":"","middle_name":"","birthdate":"2007-04-26","birthplace":"Houston, Florida","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/ha66y2004","instagram_profile":"https:\/\/www.instagram.com\/harrymoore72\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":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":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":141343,"title":"Yousaf Bin Naeem","short_name":"YB Naeem","first_name":"Yousaf Bin Naeem","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":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":""}]},"etag":"04c8b07d74c5e1545b22607691a4426e","modified":"2025-07-15 23:25:26","datetime":"2025-07-15 23:25:26","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86899 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:948bb729-ad1a-4a36-a5b3-ba5a734c59ce
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86899 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86899,3,'{"status":"ok","response":{"match_id":86899,"title":"Lancashire vs Derbyshire","short_title":"LAN vs DER","subtitle":"Match 79","match_number":"79","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Lancashire won by 42 runs","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129425,"title":"Vitality Blast","abbr":"Vitality Blast","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-09-13","country":"en","total_matches":"133","total_rounds":"2","total_teams":"18"},"teama":{"team_id":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":"178\/6 (20 ov)","scores":"178\/6","overs":"20"},"teamb":{"team_id":104949,"name":"Derbyshire","short_name":"DER","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/derbyshire-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/derbyshire-logo.png","scores_full":"136\/6 (20 ov)","scores":"136\/6","overs":"20"},"date_start":"2025-07-05 14:00:00","date_end":"2025-07-06 00:00:00","timestamp_start":1751724000,"timestamp_end":1751760000,"date_start_ist":"2025-07-05 19:30:00","date_end_ist":"2025-07-06 05:30:00","venue":{"venue_id":"31","name":"Old Trafford","location":"Manchester","country":"England","timezone":""},"umpires":"Hassan Adnan (England), Jack Shantry (England)","referee":"Alec Swann (England)","equation":"","live":"","result":"LAN won by 42 runs","result_type":1,"win_margin":"42 runs","winning_team_id":7023,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-07-04 23:35:17","verify_time":"2025-07-05 22:41:34","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":20.49,"humidity":72,"visibility":10000,"wind_speed":"10.63","clouds":100},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Derbyshire elected to bowl","winner":104949,"decision":2}},"etag":"f07a61a6c69879ed965c991ee381e3dd","modified":"2025-07-15 23:25:27","datetime":"2025-07-15 23:25:27","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":86899,"title":"Lancashire vs Derbyshire","short_title":"LAN vs DER","subtitle":"Match 79","match_number":"79","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Lancashire won by 42 runs","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129425,"title":"Vitality Blast","abbr":"Vitality Blast","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-09-13","country":"en","total_matches":"133","total_rounds":"2","total_teams":"18"},"teama":{"team_id":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":"178\/6 (20 ov)","scores":"178\/6","overs":"20"},"teamb":{"team_id":104949,"name":"Derbyshire","short_name":"DER","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/derbyshire-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/derbyshire-logo.png","scores_full":"136\/6 (20 ov)","scores":"136\/6","overs":"20"},"date_start":"2025-07-05 14:00:00","date_end":"2025-07-06 00:00:00","timestamp_start":1751724000,"timestamp_end":1751760000,"date_start_ist":"2025-07-05 19:30:00","date_end_ist":"2025-07-06 05:30:00","venue":{"venue_id":"31","name":"Old Trafford","location":"Manchester","country":"England","timezone":""},"umpires":"Hassan Adnan (England), Jack Shantry (England)","referee":"Alec Swann (England)","equation":"","live":"","result":"LAN won by 42 runs","result_type":1,"win_margin":"42 runs","winning_team_id":7023,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-07-04 23:35:17","verify_time":"2025-07-05 22:41:34","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":20.49,"humidity":72,"visibility":10000,"wind_speed":"10.63","clouds":100},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Derbyshire elected to bowl","winner":104949,"decision":2}},"etag":"f07a61a6c69879ed965c991ee381e3dd","modified":"2025-07-15 23:25:27","datetime":"2025-07-15 23:25:27","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86899 AND DataTypeId = 3 END Live Report & Scorecard of Lancashire vs Derbyshire Match 79
Lancashire vs Derbyshire, Live Cricket Commentary