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:34a8eb0d-82af-4ab4-8150-aa75f7fedaed
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86890 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86890,1,'{"status":"ok","response":{"mid":86890,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Lancashire won by 80 runs","day_remaining_over":"","team_batting":"Derbyshire","team_bowling":"Lancashire","live_inning_number":2,"live_score":{"runs":163,"overs":17.2,"wickets":10,"target":244,"runrate":9.4,"required_runrate":30.38},"commentary":1,"wagon":2,"batsmen":[{"name":"Caleb Jewell","batsman_id":48498,"runs":65,"balls_faced":43,"fours":5,"sixes":3,"strike_rate":"151.16"},{"name":"Pat Brown","batsman_id":84689,"runs":1,"balls_faced":1,"fours":0,"sixes":0,"strike_rate":"100.00"}],"bowlers":[{"name":"Liam Livingstone","bowler_id":48436,"overs":1.2,"runs_conceded":17,"wickets":2,"maidens":0,"econ":"12.75"},{"name":"Jack Blatherwick","bowler_id":93763,"overs":4,"runs_conceded":40,"wickets":2,"maidens":0,"econ":"10.00"}],"commentaries":[{"event_id":"12183377","event":"ball","batsman_id":"48498","bowler_id":"1052","over":"13","ball":"1","score":1,"commentary":"Saqib Mahmood to Caleb Jewell, 1 run,","noball_dismissal":false,"text":"","timestamp":1750451769,"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":"12183378","event":"ball","batsman_id":"118504","bowler_id":"1052","over":"13","ball":"2","score":4,"commentary":"Saqib Mahmood to Allah Mohammad Ghazanfar, Four,","noball_dismissal":false,"text":"","timestamp":1750451771,"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":"12183379","event":"ball","batsman_id":"118504","bowler_id":"1052","over":"13","ball":"3","score":1,"commentary":"Saqib Mahmood to Allah Mohammad Ghazanfar, 1 run,","noball_dismissal":false,"text":"","timestamp":1750451774,"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":"12183388","event":"ball","batsman_id":"48498","bowler_id":"1052","over":"13","ball":"4","score":1,"commentary":"Saqib Mahmood to Caleb Jewell, 1 run,","noball_dismissal":false,"text":"","timestamp":1750451845,"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":"12183395","event":"ball","batsman_id":"118504","bowler_id":"1052","over":"13","ball":"5","score":0,"commentary":"Saqib Mahmood to Allah Mohammad Ghazanfar, no run,","noball_dismissal":false,"text":"","timestamp":1750451848,"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":"12183398","event":"ball","batsman_id":"118504","bowler_id":"1052","over":"13","ball":"6","score":4,"commentary":"Saqib Mahmood to Allah Mohammad Ghazanfar, Four,","noball_dismissal":false,"text":"","timestamp":1750451860,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event":"overend","over":14,"runs":11,"score":"127\/7","bats":[{"runs":28,"balls_faced":12,"fours":2,"sixes":3,"batsman_id":118504},{"runs":39,"balls_faced":30,"fours":2,"sixes":2,"batsman_id":48498}],"bowls":[{"runs_conceded":34,"maidens":0,"wickets":1,"bowler_id":1052,"overs":3},{"runs_conceded":13,"maidens":0,"wickets":0,"bowler_id":94941,"overs":1}],"commentary":"End of over 14 (11 runs), Derbyshire 127\/7"},{"event_id":"12183418","event":"ball","batsman_id":"48498","bowler_id":"93763","over":"14","ball":"1","score":1,"commentary":"Jack Blatherwick to Caleb Jewell, 1 run,","noball_dismissal":false,"text":"","timestamp":1750451989,"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":"12183419","event":"ball","batsman_id":"118504","bowler_id":"93763","over":"14","ball":"2","score":0,"commentary":"Jack Blatherwick to Allah Mohammad Ghazanfar, no run,","noball_dismissal":false,"text":"","timestamp":1750451992,"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":"12183429","event":"wicket","batsman_id":"118504","bowler_id":"93763","over":"14","ball":"3","score":"w","commentary":"Jack Blatherwick to Allah Mohammad Ghazanfar, no run, c LWP Wells b JM Blatherwick,","noball_dismissal":false,"text":"","timestamp":1750452209,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"118504","how_out":"c LWP Wells b JM Blatherwick","batsman_runs":"28","batsman_balls":"14"},{"event_id":"12183452","event":"ball","batsman_id":"101484","bowler_id":"93763","over":"14","ball":"4","score":1,"commentary":"Jack Blatherwick to Ben William Aitchison, 1 run,","noball_dismissal":false,"text":"","timestamp":1750452221,"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":"12183454","event":"ball","batsman_id":"48498","bowler_id":"93763","over":"14","ball":"5","score":1,"commentary":"Jack Blatherwick to Caleb Jewell, 1 run,","noball_dismissal":false,"text":"","timestamp":1750452223,"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":"12183455","event":"ball","batsman_id":"101484","bowler_id":"93763","over":"14","ball":"6","score":6,"commentary":"Jack Blatherwick to Ben William Aitchison, Six,","noball_dismissal":false,"text":"","timestamp":1750452226,"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":"overend","over":15,"runs":9,"score":"136\/8","bats":[{"runs":7,"balls_faced":2,"fours":0,"sixes":1,"batsman_id":101484},{"runs":41,"balls_faced":32,"fours":2,"sixes":2,"batsman_id":48498}],"bowls":[{"runs_conceded":23,"maidens":0,"wickets":2,"bowler_id":93763,"overs":3},{"runs_conceded":34,"maidens":0,"wickets":1,"bowler_id":1052,"overs":3}],"commentary":"End of over 15 (9 runs), Derbyshire 136\/8"},{"event_id":"12183462","event":"ball","batsman_id":"48498","bowler_id":"43448","over":"15","ball":"1","score":1,"commentary":"Chris Green to Caleb Jewell, 1 run,","noball_dismissal":false,"text":"","timestamp":1750452320,"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":"12183465","event":"ball","batsman_id":"101484","bowler_id":"43448","over":"15","ball":"2","score":1,"commentary":"Chris Green to Ben William Aitchison, 1 run,","noball_dismissal":false,"text":"","timestamp":1750452323,"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":"12183466","event":"ball","batsman_id":"48498","bowler_id":"43448","over":"15","ball":"3","score":2,"commentary":"Chris Green to Caleb Jewell, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750452326,"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":"12183469","event":"ball","batsman_id":"48498","bowler_id":"43448","over":"15","ball":"4","score":0,"commentary":"Chris Green to Caleb Jewell, no run,","noball_dismissal":false,"text":"","timestamp":1750452332,"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":"12183482","event":"ball","batsman_id":"48498","bowler_id":"43448","over":"15","ball":"5","score":1,"commentary":"Chris Green to Caleb Jewell, 1 run,","noball_dismissal":false,"text":"","timestamp":1750452428,"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":"12183484","event":"wicket","batsman_id":"101484","bowler_id":"43448","over":"15","ball":"6","score":"w","commentary":"Chris Green to Ben William Aitchison, no run, c JM Blatherwick b CJ Green,","noball_dismissal":false,"text":"","timestamp":1750452448,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"101484","how_out":"c JM Blatherwick b CJ Green","batsman_runs":"8","batsman_balls":"4"},{"event":"overend","over":16,"runs":5,"score":"141\/9","bats":[{"runs":8,"balls_faced":4,"fours":0,"sixes":1,"batsman_id":101484},{"runs":45,"balls_faced":36,"fours":2,"sixes":2,"batsman_id":48498}],"bowls":[{"runs_conceded":16,"maidens":0,"wickets":3,"bowler_id":43448,"overs":4},{"runs_conceded":23,"maidens":0,"wickets":2,"bowler_id":93763,"overs":3}],"commentary":"End of over 16 (5 runs), Derbyshire 141\/9"},{"event_id":"12183492","event":"ball","batsman_id":"48498","bowler_id":"93763","over":"16","ball":"1","score":6,"commentary":"Jack Blatherwick to Caleb Jewell, Six,","noball_dismissal":false,"text":"","timestamp":1750452505,"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":"12183504","event":"ball","batsman_id":"48498","bowler_id":"93763","over":"16","ball":"2","score":4,"commentary":"Jack Blatherwick to Caleb Jewell, Four,","noball_dismissal":false,"text":"","timestamp":1750452594,"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":"12183505","event":"ball","batsman_id":"48498","bowler_id":"93763","over":"16","ball":"3","score":1,"commentary":"Jack Blatherwick to Caleb Jewell, 1 run,","noball_dismissal":false,"text":"","timestamp":1750452597,"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":"12183506","event":"ball","batsman_id":"84689","bowler_id":"93763","over":"16","ball":"4","score":1,"commentary":"Jack Blatherwick to Pat Brown, 1 run,","noball_dismissal":false,"text":"","timestamp":1750452599,"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":"12183507","event":"ball","batsman_id":"48498","bowler_id":"93763","over":"16","ball":"5","score":4,"commentary":"Jack Blatherwick to Caleb Jewell, Four,","noball_dismissal":false,"text":"","timestamp":1750452619,"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":"12183512","event":"ball","batsman_id":"48498","bowler_id":"93763","over":"16","ball":"6","score":1,"commentary":"Jack Blatherwick to Caleb Jewell, 1 run,","noball_dismissal":false,"text":"","timestamp":1750452654,"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":17,"score":"158\/9","bats":[{"runs":61,"balls_faced":41,"fours":4,"sixes":3,"batsman_id":48498},{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":84689}],"bowls":[{"runs_conceded":40,"maidens":0,"wickets":2,"bowler_id":93763,"overs":4},{"runs_conceded":16,"maidens":0,"wickets":3,"bowler_id":43448,"overs":4}],"commentary":"End of over 17 (17 runs), Derbyshire 158\/9"},{"event_id":"12183517","event":"ball","batsman_id":"48498","bowler_id":"48436","over":"17","ball":"1","score":4,"commentary":"Liam Livingstone to Caleb Jewell, Four,","noball_dismissal":false,"text":"","timestamp":1750452707,"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":"12183521","event":"ball","batsman_id":"48498","bowler_id":"48436","over":"17","ball":"2","score":"1wd","commentary":"Liam Livingstone to Caleb Jewell, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750452764,"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":"12183523","event":"wicket","batsman_id":"48498","bowler_id":"48436","over":"17","ball":"2","score":"w","commentary":"Liam Livingstone to Caleb Jewell, no run, b L Livingstone,","noball_dismissal":false,"text":"","timestamp":1750452767,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"48498","how_out":"b L Livingstone","batsman_runs":"65","batsman_balls":"43"}],"day":"0","session":"0","live_inning":{"iid":198469,"number":2,"name":"Derbyshire Inning","short_name":"DER Inning","status":2,"issuperover":"false","result":1,"batting_team_id":104949,"fielding_team_id":7023,"scores":"163\/10","scores_full":"163\/10 (17.2 ov)","fielder":[{"fielder_id":"49330","fielder_name":"Luke Wells","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"93763","fielder_name":"Jack Blatherwick","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"49538","fielder_name":"Keaton Jennings","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"118934","fielder_name":"Matthew Hurst","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"43584","fielder_name":"Ashton Turner","catches":2,"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":"Caleb Jewell","batsman_id":"48498","runs":"65","balls":"43","how_out":"b L Livingstone","score_at_dismissal":163,"overs_at_dismissal":"17.2","bowler_id":"48436","dismissal":"bowled","number":10},"extra_runs":{"byes":0,"legbyes":1,"wides":3,"noballs":0,"penalty":"0","total":4},"equations":{"runs":163,"wickets":10,"overs":"17.2","bowlers_used":7,"runrate":"9.40"},"current_partnership":{"runs":22,"balls":8,"overs":1.2,"batsmen":[{"name":"Caleb Jewell","batsman_id":48498,"runs":20,"balls":7},{"name":"Pat Brown","batsman_id":84689,"runs":1,"balls":1}]},"did_not_bat":[],"max_over":"20","target":"244","recent_scores":"w,1,4,1,4,1,1,4,6,w,1,0,2,1,1,6,1,1","last_five_overs":"53\/3 10.26","last_ten_overs":"106\/5 10.10"},"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":"243\/7 (20 ov)","scores":"243\/7","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":"163\/10 (17.2 ov)","scores":"163\/10","overs":"17.2"}],"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":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"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":"","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":"","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":7.5,"facebook_profile":"https:\/\/www.facebook.com\/aneurin.donald\/","twitter_profile":"https:\/\/twitter.com\/AneurinDonald12","instagram_profile":"https:\/\/www.instagram.com\/aneurindonald\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/davidlloyduk\/","debut_data":"","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":"","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.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/RossWhiteley44","instagram_profile":"https:\/\/www.instagram.com\/rosswhiteley44\/","debut_data":"","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":"","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/marcusharris14\/","debut_data":"","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":"","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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.5,"facebook_profile":"https:\/\/www.facebook.com\/blair.tickner\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/ticks93\/","debut_data":"","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":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lreece17","instagram_profile":"https:\/\/www.instagram.com\/louisreece\/","debut_data":"","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":"","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":7.5,"facebook_profile":"https:\/\/www.facebook.com\/caleb.jewell.148\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/cjewell_32\/","debut_data":"","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/guesty211\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"wk","role_str":""},{"pid":48641,"title":"Wayne Madsen","short_name":"WL Madsen","first_name":"Wayne Madsen","last_name":"","middle_name":"","birthdate":"1984-01-02","birthplace":"Durban","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/waynemadders77","instagram_profile":"https:\/\/www.instagram.com\/waynemadsen77\/","debut_data":"","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":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/luke_wells07","instagram_profile":"https:\/\/www.instagram.com\/l.wells07\/","debut_data":"","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":"","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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":"","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":"","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":"","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":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/AnujDal","instagram_profile":"https:\/\/www.instagram.com\/anujdal0\/","debut_data":"","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":"","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":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/MartinAnderss11","instagram_profile":"","debut_data":"","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":"","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":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/patbrowny\/","debut_data":"","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":"","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":"","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":94962,"title":"Harry Came","short_name":"H Came","first_name":"Harry Came","last_name":"","middle_name":"","birthdate":"1998-08-27","birthplace":"Hampshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/HarryCame4","instagram_profile":"https:\/\/www.instagram.com\/harrycame4\/","debut_data":"","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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":"","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/m.s.stanley\/","debut_data":"","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":"","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/nickwpotts\/","debut_data":"","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":"","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":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/mitchellwaggy?lang=en","instagram_profile":"https:\/\/www.instagram.com\/mitchellwagstaff\/?hl=en","debut_data":"","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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":"","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"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.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/ha66y2004","instagram_profile":"https:\/\/www.instagram.com\/harrymoore72\/","debut_data":"","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":"","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":"","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":"","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""}]},"etag":"1a5129a9923464e31e01dc1550896090","modified":"2025-07-15 11:16:34","datetime":"2025-07-15 11:16:34","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":86890,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Lancashire won by 80 runs","day_remaining_over":"","team_batting":"Derbyshire","team_bowling":"Lancashire","live_inning_number":2,"live_score":{"runs":163,"overs":17.2,"wickets":10,"target":244,"runrate":9.4,"required_runrate":30.38},"commentary":1,"wagon":2,"batsmen":[{"name":"Caleb Jewell","batsman_id":48498,"runs":65,"balls_faced":43,"fours":5,"sixes":3,"strike_rate":"151.16"},{"name":"Pat Brown","batsman_id":84689,"runs":1,"balls_faced":1,"fours":0,"sixes":0,"strike_rate":"100.00"}],"bowlers":[{"name":"Liam Livingstone","bowler_id":48436,"overs":1.2,"runs_conceded":17,"wickets":2,"maidens":0,"econ":"12.75"},{"name":"Jack Blatherwick","bowler_id":93763,"overs":4,"runs_conceded":40,"wickets":2,"maidens":0,"econ":"10.00"}],"commentaries":[{"event_id":"12183377","event":"ball","batsman_id":"48498","bowler_id":"1052","over":"13","ball":"1","score":1,"commentary":"Saqib Mahmood to Caleb Jewell, 1 run,","noball_dismissal":false,"text":"","timestamp":1750451769,"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":"12183378","event":"ball","batsman_id":"118504","bowler_id":"1052","over":"13","ball":"2","score":4,"commentary":"Saqib Mahmood to Allah Mohammad Ghazanfar, Four,","noball_dismissal":false,"text":"","timestamp":1750451771,"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":"12183379","event":"ball","batsman_id":"118504","bowler_id":"1052","over":"13","ball":"3","score":1,"commentary":"Saqib Mahmood to Allah Mohammad Ghazanfar, 1 run,","noball_dismissal":false,"text":"","timestamp":1750451774,"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":"12183388","event":"ball","batsman_id":"48498","bowler_id":"1052","over":"13","ball":"4","score":1,"commentary":"Saqib Mahmood to Caleb Jewell, 1 run,","noball_dismissal":false,"text":"","timestamp":1750451845,"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":"12183395","event":"ball","batsman_id":"118504","bowler_id":"1052","over":"13","ball":"5","score":0,"commentary":"Saqib Mahmood to Allah Mohammad Ghazanfar, no run,","noball_dismissal":false,"text":"","timestamp":1750451848,"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":"12183398","event":"ball","batsman_id":"118504","bowler_id":"1052","over":"13","ball":"6","score":4,"commentary":"Saqib Mahmood to Allah Mohammad Ghazanfar, Four,","noball_dismissal":false,"text":"","timestamp":1750451860,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event":"overend","over":14,"runs":11,"score":"127\/7","bats":[{"runs":28,"balls_faced":12,"fours":2,"sixes":3,"batsman_id":118504},{"runs":39,"balls_faced":30,"fours":2,"sixes":2,"batsman_id":48498}],"bowls":[{"runs_conceded":34,"maidens":0,"wickets":1,"bowler_id":1052,"overs":3},{"runs_conceded":13,"maidens":0,"wickets":0,"bowler_id":94941,"overs":1}],"commentary":"End of over 14 (11 runs), Derbyshire 127\/7"},{"event_id":"12183418","event":"ball","batsman_id":"48498","bowler_id":"93763","over":"14","ball":"1","score":1,"commentary":"Jack Blatherwick to Caleb Jewell, 1 run,","noball_dismissal":false,"text":"","timestamp":1750451989,"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":"12183419","event":"ball","batsman_id":"118504","bowler_id":"93763","over":"14","ball":"2","score":0,"commentary":"Jack Blatherwick to Allah Mohammad Ghazanfar, no run,","noball_dismissal":false,"text":"","timestamp":1750451992,"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":"12183429","event":"wicket","batsman_id":"118504","bowler_id":"93763","over":"14","ball":"3","score":"w","commentary":"Jack Blatherwick to Allah Mohammad Ghazanfar, no run, c LWP Wells b JM Blatherwick,","noball_dismissal":false,"text":"","timestamp":1750452209,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"118504","how_out":"c LWP Wells b JM Blatherwick","batsman_runs":"28","batsman_balls":"14"},{"event_id":"12183452","event":"ball","batsman_id":"101484","bowler_id":"93763","over":"14","ball":"4","score":1,"commentary":"Jack Blatherwick to Ben William Aitchison, 1 run,","noball_dismissal":false,"text":"","timestamp":1750452221,"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":"12183454","event":"ball","batsman_id":"48498","bowler_id":"93763","over":"14","ball":"5","score":1,"commentary":"Jack Blatherwick to Caleb Jewell, 1 run,","noball_dismissal":false,"text":"","timestamp":1750452223,"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":"12183455","event":"ball","batsman_id":"101484","bowler_id":"93763","over":"14","ball":"6","score":6,"commentary":"Jack Blatherwick to Ben William Aitchison, Six,","noball_dismissal":false,"text":"","timestamp":1750452226,"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":"overend","over":15,"runs":9,"score":"136\/8","bats":[{"runs":7,"balls_faced":2,"fours":0,"sixes":1,"batsman_id":101484},{"runs":41,"balls_faced":32,"fours":2,"sixes":2,"batsman_id":48498}],"bowls":[{"runs_conceded":23,"maidens":0,"wickets":2,"bowler_id":93763,"overs":3},{"runs_conceded":34,"maidens":0,"wickets":1,"bowler_id":1052,"overs":3}],"commentary":"End of over 15 (9 runs), Derbyshire 136\/8"},{"event_id":"12183462","event":"ball","batsman_id":"48498","bowler_id":"43448","over":"15","ball":"1","score":1,"commentary":"Chris Green to Caleb Jewell, 1 run,","noball_dismissal":false,"text":"","timestamp":1750452320,"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":"12183465","event":"ball","batsman_id":"101484","bowler_id":"43448","over":"15","ball":"2","score":1,"commentary":"Chris Green to Ben William Aitchison, 1 run,","noball_dismissal":false,"text":"","timestamp":1750452323,"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":"12183466","event":"ball","batsman_id":"48498","bowler_id":"43448","over":"15","ball":"3","score":2,"commentary":"Chris Green to Caleb Jewell, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750452326,"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":"12183469","event":"ball","batsman_id":"48498","bowler_id":"43448","over":"15","ball":"4","score":0,"commentary":"Chris Green to Caleb Jewell, no run,","noball_dismissal":false,"text":"","timestamp":1750452332,"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":"12183482","event":"ball","batsman_id":"48498","bowler_id":"43448","over":"15","ball":"5","score":1,"commentary":"Chris Green to Caleb Jewell, 1 run,","noball_dismissal":false,"text":"","timestamp":1750452428,"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":"12183484","event":"wicket","batsman_id":"101484","bowler_id":"43448","over":"15","ball":"6","score":"w","commentary":"Chris Green to Ben William Aitchison, no run, c JM Blatherwick b CJ Green,","noball_dismissal":false,"text":"","timestamp":1750452448,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"101484","how_out":"c JM Blatherwick b CJ Green","batsman_runs":"8","batsman_balls":"4"},{"event":"overend","over":16,"runs":5,"score":"141\/9","bats":[{"runs":8,"balls_faced":4,"fours":0,"sixes":1,"batsman_id":101484},{"runs":45,"balls_faced":36,"fours":2,"sixes":2,"batsman_id":48498}],"bowls":[{"runs_conceded":16,"maidens":0,"wickets":3,"bowler_id":43448,"overs":4},{"runs_conceded":23,"maidens":0,"wickets":2,"bowler_id":93763,"overs":3}],"commentary":"End of over 16 (5 runs), Derbyshire 141\/9"},{"event_id":"12183492","event":"ball","batsman_id":"48498","bowler_id":"93763","over":"16","ball":"1","score":6,"commentary":"Jack Blatherwick to Caleb Jewell, Six,","noball_dismissal":false,"text":"","timestamp":1750452505,"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":"12183504","event":"ball","batsman_id":"48498","bowler_id":"93763","over":"16","ball":"2","score":4,"commentary":"Jack Blatherwick to Caleb Jewell, Four,","noball_dismissal":false,"text":"","timestamp":1750452594,"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":"12183505","event":"ball","batsman_id":"48498","bowler_id":"93763","over":"16","ball":"3","score":1,"commentary":"Jack Blatherwick to Caleb Jewell, 1 run,","noball_dismissal":false,"text":"","timestamp":1750452597,"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":"12183506","event":"ball","batsman_id":"84689","bowler_id":"93763","over":"16","ball":"4","score":1,"commentary":"Jack Blatherwick to Pat Brown, 1 run,","noball_dismissal":false,"text":"","timestamp":1750452599,"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":"12183507","event":"ball","batsman_id":"48498","bowler_id":"93763","over":"16","ball":"5","score":4,"commentary":"Jack Blatherwick to Caleb Jewell, Four,","noball_dismissal":false,"text":"","timestamp":1750452619,"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":"12183512","event":"ball","batsman_id":"48498","bowler_id":"93763","over":"16","ball":"6","score":1,"commentary":"Jack Blatherwick to Caleb Jewell, 1 run,","noball_dismissal":false,"text":"","timestamp":1750452654,"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":17,"score":"158\/9","bats":[{"runs":61,"balls_faced":41,"fours":4,"sixes":3,"batsman_id":48498},{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":84689}],"bowls":[{"runs_conceded":40,"maidens":0,"wickets":2,"bowler_id":93763,"overs":4},{"runs_conceded":16,"maidens":0,"wickets":3,"bowler_id":43448,"overs":4}],"commentary":"End of over 17 (17 runs), Derbyshire 158\/9"},{"event_id":"12183517","event":"ball","batsman_id":"48498","bowler_id":"48436","over":"17","ball":"1","score":4,"commentary":"Liam Livingstone to Caleb Jewell, Four,","noball_dismissal":false,"text":"","timestamp":1750452707,"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":"12183521","event":"ball","batsman_id":"48498","bowler_id":"48436","over":"17","ball":"2","score":"1wd","commentary":"Liam Livingstone to Caleb Jewell, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750452764,"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":"12183523","event":"wicket","batsman_id":"48498","bowler_id":"48436","over":"17","ball":"2","score":"w","commentary":"Liam Livingstone to Caleb Jewell, no run, b L Livingstone,","noball_dismissal":false,"text":"","timestamp":1750452767,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"48498","how_out":"b L Livingstone","batsman_runs":"65","batsman_balls":"43"}],"day":"0","session":"0","live_inning":{"iid":198469,"number":2,"name":"Derbyshire Inning","short_name":"DER Inning","status":2,"issuperover":"false","result":1,"batting_team_id":104949,"fielding_team_id":7023,"scores":"163\/10","scores_full":"163\/10 (17.2 ov)","fielder":[{"fielder_id":"49330","fielder_name":"Luke Wells","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"93763","fielder_name":"Jack Blatherwick","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"49538","fielder_name":"Keaton Jennings","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"118934","fielder_name":"Matthew Hurst","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"43584","fielder_name":"Ashton Turner","catches":2,"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":"Caleb Jewell","batsman_id":"48498","runs":"65","balls":"43","how_out":"b L Livingstone","score_at_dismissal":163,"overs_at_dismissal":"17.2","bowler_id":"48436","dismissal":"bowled","number":10},"extra_runs":{"byes":0,"legbyes":1,"wides":3,"noballs":0,"penalty":"0","total":4},"equations":{"runs":163,"wickets":10,"overs":"17.2","bowlers_used":7,"runrate":"9.40"},"current_partnership":{"runs":22,"balls":8,"overs":1.2,"batsmen":[{"name":"Caleb Jewell","batsman_id":48498,"runs":20,"balls":7},{"name":"Pat Brown","batsman_id":84689,"runs":1,"balls":1}]},"did_not_bat":[],"max_over":"20","target":"244","recent_scores":"w,1,4,1,4,1,1,4,6,w,1,0,2,1,1,6,1,1","last_five_overs":"53\/3 10.26","last_ten_overs":"106\/5 10.10"},"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":"243\/7 (20 ov)","scores":"243\/7","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":"163\/10 (17.2 ov)","scores":"163\/10","overs":"17.2"}],"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":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"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":"","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":"","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":7.5,"facebook_profile":"https:\/\/www.facebook.com\/aneurin.donald\/","twitter_profile":"https:\/\/twitter.com\/AneurinDonald12","instagram_profile":"https:\/\/www.instagram.com\/aneurindonald\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/davidlloyduk\/","debut_data":"","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":"","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.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/RossWhiteley44","instagram_profile":"https:\/\/www.instagram.com\/rosswhiteley44\/","debut_data":"","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":"","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/marcusharris14\/","debut_data":"","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":"","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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.5,"facebook_profile":"https:\/\/www.facebook.com\/blair.tickner\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/ticks93\/","debut_data":"","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":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lreece17","instagram_profile":"https:\/\/www.instagram.com\/louisreece\/","debut_data":"","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":"","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":7.5,"facebook_profile":"https:\/\/www.facebook.com\/caleb.jewell.148\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/cjewell_32\/","debut_data":"","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/guesty211\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"wk","role_str":""},{"pid":48641,"title":"Wayne Madsen","short_name":"WL Madsen","first_name":"Wayne Madsen","last_name":"","middle_name":"","birthdate":"1984-01-02","birthplace":"Durban","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/waynemadders77","instagram_profile":"https:\/\/www.instagram.com\/waynemadsen77\/","debut_data":"","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":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/luke_wells07","instagram_profile":"https:\/\/www.instagram.com\/l.wells07\/","debut_data":"","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":"","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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":"","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":"","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":"","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":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/AnujDal","instagram_profile":"https:\/\/www.instagram.com\/anujdal0\/","debut_data":"","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":"","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":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/MartinAnderss11","instagram_profile":"","debut_data":"","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":"","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":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/patbrowny\/","debut_data":"","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":"","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":"","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":94962,"title":"Harry Came","short_name":"H Came","first_name":"Harry Came","last_name":"","middle_name":"","birthdate":"1998-08-27","birthplace":"Hampshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/HarryCame4","instagram_profile":"https:\/\/www.instagram.com\/harrycame4\/","debut_data":"","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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":"","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/m.s.stanley\/","debut_data":"","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":"","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/nickwpotts\/","debut_data":"","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":"","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":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/mitchellwaggy?lang=en","instagram_profile":"https:\/\/www.instagram.com\/mitchellwagstaff\/?hl=en","debut_data":"","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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":"","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"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.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/ha66y2004","instagram_profile":"https:\/\/www.instagram.com\/harrymoore72\/","debut_data":"","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":"","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":"","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":"","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""}]},"etag":"1a5129a9923464e31e01dc1550896090","modified":"2025-07-15 11:16:34","datetime":"2025-07-15 11:16:34","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86890 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:d99b14a0-f776-45e1-abad-64541647efa9
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86890 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86890,3,'{"status":"ok","response":{"match_id":86890,"title":"Derbyshire vs Lancashire","short_title":"DER vs LAN","subtitle":"Match 70","match_number":"70","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Lancashire won by 80 runs","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129425,"title":"Vitality Blast","abbr":"Vitality Blast","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-09-13","country":"en","total_matches":"133","total_rounds":"2","total_teams":"18"},"teama":{"team_id":104949,"name":"Derbyshire","short_name":"DER","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/derbyshire-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/derbyshire-logo.png","scores_full":"163\/10 (17.2 ov)","scores":"163\/10","overs":"17.2"},"teamb":{"team_id":7023,"name":"Lancashire","short_name":"LAN","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/lancashire-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/lancashire-logo.png","scores_full":"243\/7 (20 ov)","scores":"243\/7","overs":"20"},"date_start":"2025-06-20 18:00:00","date_end":"2025-06-21 04:00:00","timestamp_start":1750442400,"timestamp_end":1750478400,"date_start_ist":"2025-06-20 23:30:00","date_end_ist":"2025-06-21 09:30:00","venue":{"venue_id":"49","name":"County Ground","location":"Derby","country":"England","timezone":""},"umpires":" David Millns (England), Simon Widdup (England)","referee":"Wayne Noon (England)","equation":"","live":"","result":"LAN won by 80 runs","result_type":2,"win_margin":"80 runs","winning_team_id":7023,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-20 00:57:50","verify_time":"2025-06-21 02:40:19","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"broken clouds","temp":21.14,"humidity":67,"visibility":10000,"wind_speed":"6.40","clouds":59},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"High Scoring","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Sharp Turn"},"toss":{"text":"Derbyshire elected to bowl","winner":104949,"decision":2}},"etag":"1a5129a9923464e31e01dc1550896090","modified":"2025-07-15 11:16:34","datetime":"2025-07-15 11:16:34","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":86890,"title":"Derbyshire vs Lancashire","short_title":"DER vs LAN","subtitle":"Match 70","match_number":"70","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Lancashire won by 80 runs","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129425,"title":"Vitality Blast","abbr":"Vitality Blast","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-09-13","country":"en","total_matches":"133","total_rounds":"2","total_teams":"18"},"teama":{"team_id":104949,"name":"Derbyshire","short_name":"DER","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/derbyshire-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/derbyshire-logo.png","scores_full":"163\/10 (17.2 ov)","scores":"163\/10","overs":"17.2"},"teamb":{"team_id":7023,"name":"Lancashire","short_name":"LAN","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/lancashire-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/lancashire-logo.png","scores_full":"243\/7 (20 ov)","scores":"243\/7","overs":"20"},"date_start":"2025-06-20 18:00:00","date_end":"2025-06-21 04:00:00","timestamp_start":1750442400,"timestamp_end":1750478400,"date_start_ist":"2025-06-20 23:30:00","date_end_ist":"2025-06-21 09:30:00","venue":{"venue_id":"49","name":"County Ground","location":"Derby","country":"England","timezone":""},"umpires":" David Millns (England), Simon Widdup (England)","referee":"Wayne Noon (England)","equation":"","live":"","result":"LAN won by 80 runs","result_type":2,"win_margin":"80 runs","winning_team_id":7023,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-20 00:57:50","verify_time":"2025-06-21 02:40:19","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"broken clouds","temp":21.14,"humidity":67,"visibility":10000,"wind_speed":"6.40","clouds":59},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"High Scoring","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Sharp Turn"},"toss":{"text":"Derbyshire elected to bowl","winner":104949,"decision":2}},"etag":"1a5129a9923464e31e01dc1550896090","modified":"2025-07-15 11:16:34","datetime":"2025-07-15 11:16:34","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86890 AND DataTypeId = 3 END Live Report & Scorecard of Derbyshire vs Lancashire Match 70
Derbyshire vs Lancashire, Live Cricket Commentary