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:a76b4079-d332-4371-a256-7a768234f428 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86877 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86877,1,'{"status":"ok","response":{"mid":86877,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Surrey won by 69 runs","day_remaining_over":"","team_batting":"Hampshire","team_bowling":"Surrey","live_inning_number":2,"live_score":{"runs":124,"overs":17.5,"wickets":10,"target":194,"runrate":6.95,"required_runrate":32.31},"commentary":1,"wagon":2,"batsmen":[{"name":"John Turner","batsman_id":108381,"runs":4,"balls_faced":8,"fours":0,"sixes":0,"strike_rate":"50.00"},{"name":"Scott Currie","batsman_id":96605,"runs":10,"balls_faced":8,"fours":1,"sixes":0,"strike_rate":"125.00"}],"bowlers":[{"name":"Nathan Smith","bowler_id":1089,"overs":2.5,"runs_conceded":18,"wickets":3,"maidens":0,"econ":"6.40"},{"name":"Chris Jordan","bowler_id":454,"overs":4,"runs_conceded":17,"wickets":2,"maidens":0,"econ":"4.25"}],"commentaries":[{"event_id":"12163689","event":"ball","batsman_id":"49478","bowler_id":"1937","over":"13","ball":"4","score":0,"commentary":"Reece Topley to Chris Wood, no run,","noball_dismissal":false,"text":"","timestamp":1750192678,"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":"12163690","event":"ball","batsman_id":"49478","bowler_id":"1937","over":"13","ball":"5","score":0,"commentary":"Reece Topley to Chris Wood, no run,","noball_dismissal":false,"text":"","timestamp":1750192687,"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":"12163693","event":"ball","batsman_id":"49478","bowler_id":"1937","over":"13","ball":"6","score":1,"commentary":"Reece Topley to Chris Wood, 1 run,","noball_dismissal":false,"text":"","timestamp":1750192691,"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":14,"runs":3,"score":"101\/7","bats":[{"runs":2,"balls_faced":4,"fours":0,"sixes":0,"batsman_id":49478},{"runs":4,"balls_faced":4,"fours":0,"sixes":0,"batsman_id":49524}],"bowls":[{"runs_conceded":24,"maidens":0,"wickets":2,"bowler_id":1937,"overs":3},{"runs_conceded":27,"maidens":0,"wickets":1,"bowler_id":1923,"overs":3}],"commentary":"End of over 14 (3 runs), Hampshire 101\/7"},{"event_id":"12163697","event":"ball","batsman_id":"49478","bowler_id":"1923","over":"14","ball":"1","score":1,"commentary":"Mitchell Santner to Chris Wood, 1 run,","noball_dismissal":false,"text":"","timestamp":1750192696,"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":"12163701","event":"ball","batsman_id":"49524","bowler_id":"1923","over":"14","ball":"2","score":1,"commentary":"Mitchell Santner to Benny Howell, 1 run,","noball_dismissal":false,"text":"","timestamp":1750192727,"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":"12163702","event":"wicket","batsman_id":"49478","bowler_id":"1923","over":"14","ball":"3","score":"w","commentary":"Mitchell Santner to Chris Wood, no run, b M Santner,","noball_dismissal":false,"text":"","timestamp":1750192729,"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":"49478","how_out":"b M Santner","batsman_runs":"3","batsman_balls":"6"},{"event_id":"12163703","event":"ball","batsman_id":"96605","bowler_id":"1923","over":"14","ball":"4","score":"1wd","commentary":"Mitchell Santner to Scott Currie, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750192760,"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":"12163707","event":"ball","batsman_id":"96605","bowler_id":"1923","over":"14","ball":"4","score":1,"commentary":"Mitchell Santner to Scott Currie, 1 run,","noball_dismissal":false,"text":"","timestamp":1750192810,"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":"12163708","event":"ball","batsman_id":"49524","bowler_id":"1923","over":"14","ball":"5","score":4,"commentary":"Mitchell Santner to Benny Howell, Four,","noball_dismissal":false,"text":"","timestamp":1750192814,"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":"12163709","event":"ball","batsman_id":"49524","bowler_id":"1923","over":"14","ball":"6","score":1,"commentary":"Mitchell Santner to Benny Howell, 1 run,","noball_dismissal":false,"text":"","timestamp":1750192817,"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":15,"runs":9,"score":"110\/8","bats":[{"runs":10,"balls_faced":7,"fours":1,"sixes":0,"batsman_id":49524},{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":96605}],"bowls":[{"runs_conceded":36,"maidens":0,"wickets":2,"bowler_id":1923,"overs":4},{"runs_conceded":24,"maidens":0,"wickets":2,"bowler_id":1937,"overs":3}],"commentary":"End of over 15 (9 runs), Hampshire 110\/8"},{"event_id":"12163713","event":"ball","batsman_id":"49524","bowler_id":"1089","over":"15","ball":"1","score":1,"commentary":"Nathan Smith to Benny Howell, 1 run,","noball_dismissal":false,"text":"","timestamp":1750192852,"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":"12163714","event":"ball","batsman_id":"96605","bowler_id":"1089","over":"15","ball":"2","score":1,"commentary":"Nathan Smith to Scott Currie, 1 run,","noball_dismissal":false,"text":"","timestamp":1750192880,"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":"12163716","event":"wicket","batsman_id":"49524","bowler_id":"1089","over":"15","ball":"3","score":"w","commentary":"Nathan Smith to Benny Howell, no run, c J Roy b N Smith,","noball_dismissal":false,"text":"","timestamp":1750193070,"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":"49524","how_out":"c J Roy b N Smith","batsman_runs":"10","batsman_balls":"9"},{"event_id":"12163722","event":"ball","batsman_id":"108381","bowler_id":"1089","over":"15","ball":"4","score":1,"commentary":"Nathan Smith to John Turner, 1 run,","noball_dismissal":false,"text":"","timestamp":1750193073,"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":"12163723","event":"ball","batsman_id":"96605","bowler_id":"1089","over":"15","ball":"5","score":0,"commentary":"Nathan Smith to Scott Currie, no run,","noball_dismissal":false,"text":"","timestamp":1750193076,"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":"12163724","event":"ball","batsman_id":"96605","bowler_id":"1089","over":"15","ball":"6","score":4,"commentary":"Nathan Smith to Scott Currie, Four,","noball_dismissal":false,"text":"","timestamp":1750193098,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event":"overend","over":16,"runs":7,"score":"117\/9","bats":[{"runs":6,"balls_faced":4,"fours":1,"sixes":0,"batsman_id":96605},{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":108381}],"bowls":[{"runs_conceded":14,"maidens":0,"wickets":2,"bowler_id":1089,"overs":2},{"runs_conceded":36,"maidens":0,"wickets":2,"bowler_id":1923,"overs":4}],"commentary":"End of over 16 (7 runs), Hampshire 117\/9"},{"event_id":"12163728","event":"ball","batsman_id":"108381","bowler_id":"454","over":"16","ball":"1","score":0,"commentary":"Chris Jordan to John Turner, no run,","noball_dismissal":false,"text":"","timestamp":1750193213,"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":"12163729","event":"ball","batsman_id":"108381","bowler_id":"454","over":"16","ball":"2","score":0,"commentary":"Chris Jordan to John Turner, no run,","noball_dismissal":false,"text":"","timestamp":1750193216,"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":"12163733","event":"ball","batsman_id":"108381","bowler_id":"454","over":"16","ball":"3","score":0,"commentary":"Chris Jordan to John Turner, no run,","noball_dismissal":false,"text":"","timestamp":1750193225,"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":"12163734","event":"ball","batsman_id":"108381","bowler_id":"454","over":"16","ball":"4","score":1,"commentary":"Chris Jordan to John Turner, 1 run,","noball_dismissal":false,"text":"","timestamp":1750193289,"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":"12163736","event":"ball","batsman_id":"96605","bowler_id":"454","over":"16","ball":"5","score":0,"commentary":"Chris Jordan to Scott Currie, no run,","noball_dismissal":false,"text":"","timestamp":1750193303,"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":"12163738","event":"ball","batsman_id":"96605","bowler_id":"454","over":"16","ball":"6","score":1,"commentary":"Chris Jordan to Scott Currie, 1 run,","noball_dismissal":false,"text":"","timestamp":1750193341,"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":2,"score":"119\/9","bats":[{"runs":7,"balls_faced":6,"fours":1,"sixes":0,"batsman_id":96605},{"runs":2,"balls_faced":5,"fours":0,"sixes":0,"batsman_id":108381}],"bowls":[{"runs_conceded":17,"maidens":0,"wickets":2,"bowler_id":454,"overs":4},{"runs_conceded":14,"maidens":0,"wickets":2,"bowler_id":1089,"overs":2}],"commentary":"End of over 17 (2 runs), Hampshire 119\/9"},{"event_id":"12163740","event":"ball","batsman_id":"96605","bowler_id":"1089","over":"17","ball":"1","score":2,"commentary":"Nathan Smith to Scott Currie, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750193410,"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":"12163744","event":"ball","batsman_id":"96605","bowler_id":"1089","over":"17","ball":"2","score":1,"commentary":"Nathan Smith to Scott Currie, 1 run,","noball_dismissal":false,"text":"","timestamp":1750193456,"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":"12163745","event":"ball","batsman_id":"108381","bowler_id":"1089","over":"17","ball":"3","score":2,"commentary":"Nathan Smith to John Turner, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750193465,"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":"12163747","event":"ball","batsman_id":"108381","bowler_id":"1089","over":"17","ball":"4","score":0,"commentary":"Nathan Smith to John Turner, no run,","noball_dismissal":false,"text":"","timestamp":1750193489,"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":"12163748","event":"wicket","batsman_id":"108381","bowler_id":"1089","over":"17","ball":"5","score":"w","commentary":"Nathan Smith to John Turner, no run, c C Jordan b N Smith,","noball_dismissal":false,"text":"","timestamp":1750193533,"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":"108381","how_out":"c C Jordan b N Smith","batsman_runs":"4","batsman_balls":"8"}],"day":"0","session":"0","live_inning":{"iid":198275,"number":2,"name":"Hampshire Inning","short_name":"HAM Inning","status":2,"issuperover":"false","result":1,"batting_team_id":7047,"fielding_team_id":6995,"scores":"124\/10","scores_full":"124\/10 (17.5 ov)","fielder":[{"fielder_id":"1937","fielder_name":"Reece Topley","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"454","fielder_name":"Chris Jordan","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"49029","fielder_name":"Laurie Evans","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"141008","fielder_name":"Ollie Sykes","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"1089","fielder_name":"Nathan Smith","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"51319","fielder_name":"Will Jacks","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"1929","fielder_name":"Jason Roy","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"1047","fielder_name":"Sam Curran","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"John Turner","batsman_id":"108381","runs":"4","balls":"8","how_out":"c C Jordan b N Smith","score_at_dismissal":124,"overs_at_dismissal":"17.5","bowler_id":"1089","dismissal":"caught","number":10},"extra_runs":{"byes":0,"legbyes":2,"wides":2,"noballs":0,"penalty":"0","total":4},"equations":{"runs":124,"wickets":10,"overs":"17.5","bowlers_used":6,"runrate":"6.95"},"current_partnership":{"runs":12,"balls":14,"overs":2.2,"batsmen":[{"name":"John Turner","batsman_id":108381,"runs":4,"balls":8},{"name":"Scott Currie","batsman_id":96605,"runs":8,"balls":6}]},"did_not_bat":[],"max_over":"20","target":"194","recent_scores":"w,0,2,1,2,1,0,1,0,0,0,4,0,1,w,1,1,1","last_five_overs":"27\/4 5.23","last_ten_overs":"61\/7 6.00"},"teams":[{"tid":6995,"title":"Surrey","abbr":"SUR","alt_name":"Surrey","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/surrey-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/surrey-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"193\/6 (20 ov)","scores":"193\/6","overs":"20"},{"tid":7047,"title":"Hampshire","abbr":"HAM","alt_name":"HAM","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/hampshire-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/hampshire-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"124\/10 (17.5 ov)","scores":"124\/10","overs":"17.5"}],"players":[{"pid":432,"title":"Kyle Abbott","short_name":"K Abbott","first_name":"Kyle Abbott","last_name":"","middle_name":"","birthdate":"1987-06-18","birthplace":"Empangeni, KwaZulu-Natal","country":"za","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":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":454,"title":"Chris Jordan","short_name":"C Jordan","first_name":"Chris Jordan","last_name":"","middle_name":"","birthdate":"1988-10-04","birthplace":"Barbados","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.5,"facebook_profile":"https:\/\/www.facebook.com\/ChrisJordanOfficial\/","twitter_profile":"https:\/\/twitter.com\/CJordan","instagram_profile":"https:\/\/www.instagram.com\/cjrjordan\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":1042,"title":"Dan Lawrence","short_name":"DW Lawrence","first_name":"Dan Lawrence","last_name":"","middle_name":"","birthdate":"1997-07-12","birthplace":"Whipps Cross, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"https:\/\/www.facebook.com\/danlawrence25\/","twitter_profile":"https:\/\/twitter.com\/_DanLawrence","instagram_profile":"https:\/\/www.instagram.com\/daniellawrence28\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":1047,"title":"Sam Curran","short_name":"S Curran","first_name":"Sam Curran","last_name":"","middle_name":"","birthdate":"1998-06-03","birthplace":"Northampton","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/CurranSM\/","twitter_profile":"https:\/\/twitter.com\/CurranSM","instagram_profile":"https:\/\/www.instagram.com\/samcurran58\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":"(C)"},{"pid":1089,"title":"Nathan Smith","short_name":"N Smith","first_name":"Nathan Smith","last_name":"","middle_name":"","birthdate":"1998-07-15","birthplace":"Dunedin, Otago","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":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bowl","role_str":""},{"pid":1923,"title":"Mitchell Santner","short_name":"M Santner","first_name":"Mitchell Santner","last_name":"","middle_name":"","birthdate":"1992-02-05","birthplace":" Hamilton","country":"nz","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/mitchellsantnernz\/","twitter_profile":"https:\/\/twitter.com\/MitchellSantner","instagram_profile":"https:\/\/www.instagram.com\/mitchsantner\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"all","role_str":""},{"pid":1929,"title":"Jason Roy","short_name":"J Roy","first_name":"Jason Roy","last_name":"","middle_name":"","birthdate":"1990-07-21","birthplace":"Durban, South Africa","country":"en","primary_team":{"tid":490,"name":"","short_name":""},"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/JasonRoy20\/","twitter_profile":"https:\/\/twitter.com\/JasonRoy20","instagram_profile":"https:\/\/www.instagram.com\/jasonroy20\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":1937,"title":"Reece Topley","short_name":"R Topley","first_name":"Reece Topley","last_name":"","middle_name":"","birthdate":"1994-02-21","birthplace":"Ipswich, Suffolk","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/ReeceJamesWilliamTopley\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/reecejwtopley\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":1945,"title":"Liam Dawson","short_name":"L Dawson","first_name":"Liam Dawson","last_name":"","middle_name":"","birthdate":"1990-03-01","birthplace":"Swindon, Wiltshire","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/daws128\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":1949,"title":"James Vince","short_name":"J Vince","first_name":"James Vince","last_name":"","middle_name":"","birthdate":"1991-03-14","birthplace":"Cuckfield, Sussex","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":9,"facebook_profile":"https:\/\/www.facebook.com\/vincey14\/","twitter_profile":"https:\/\/twitter.com\/vincey14","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"pid":10598,"title":"Ben Foakes","short_name":"BT Foakes","first_name":"Ben Foakes","last_name":"","middle_name":"","birthdate":"1993-02-15","birthplace":"Colchester, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":10600,"title":"Rory Burns","short_name":"RJ Burns","first_name":"Rory Burns","last_name":"","middle_name":"","birthdate":"1990-08-26","birthplace":"Epsom, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"Occasional Wicketkeeper","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":32166,"title":"James Fuller","short_name":"JK Fuller","first_name":"James Fuller","last_name":"","middle_name":"","birthdate":"1990-01-24","birthplace":"Cape Town, Cape Province","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/James_Fuller246","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":43383,"title":"Jamie Overton","short_name":"J Overton","first_name":"Jamie Overton","last_name":"","middle_name":"","birthdate":"1994-04-10","birthplace":"Barnstaple, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/JamieOverton","instagram_profile":"https:\/\/www.instagram.com\/jamie_overton8\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":43389,"title":"Tom Curran","short_name":"TK Curran","first_name":"Tom Curran","last_name":"","middle_name":"","birthdate":"1995-03-12","birthplace":"Cape Town, Cape Province","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/tc59","instagram_profile":"https:\/\/www.instagram.com\/tc59\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":43630,"title":"Daniel Worrall","short_name":"DJ Worrall","first_name":"Daniel Worrall","last_name":"","middle_name":"","birthdate":"1991-07-10","birthplace":"Melbourne, Victoria","country":"au","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":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":46147,"title":"Bjorn Fortuin","short_name":"BC Fortuin","first_name":"Bjorn Fortuin","last_name":"","middle_name":"","birthdate":"1994-10-21","birthplace":"Paarl","country":"za","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":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/bjorn_fortuin","instagram_profile":"https:\/\/www.instagram.com\/bjornfortuin\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":48440,"title":"Jordan Clark","short_name":"J Clark","first_name":"Jordan Clark","last_name":"","middle_name":"","birthdate":"1990-10-14","birthplace":"Whitehaven, Cumbria","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"Occasional Wicketkeeper","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":49029,"title":"Laurie Evans","short_name":"LJ Evans","first_name":"Laurie Evans","last_name":"","middle_name":"","birthdate":"1987-10-12","birthplace":"Lambeth, London","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/laurie.evans.39\/","twitter_profile":"https:\/\/twitter.com\/LaurieEvans32","instagram_profile":"https:\/\/www.instagram.com\/laurieevans32\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(WK)"},{"pid":49324,"title":"Matt Dunn","short_name":"MP Dunn","first_name":"Matt Dunn","last_name":"","middle_name":"","birthdate":"1992-05-05","birthplace":"Egham, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Fast","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":49334,"title":"Ben Brown","short_name":"BC Brown","first_name":"Ben Brown","last_name":"","middle_name":"","birthdate":"1988-11-23","birthplace":"Crawley, Sussex","country":"en","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":"https:\/\/twitter.com\/Ben_Brown26","instagram_profile":"https:\/\/www.instagram.com\/benbrown26\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49343,"title":"Nick Gubbins","short_name":"NRT Gubbins","first_name":"Nick Gubbins","last_name":"","middle_name":"","birthdate":"1993-12-31","birthplace":"Richmond, Surrey","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49428,"title":"Cameron Steel","short_name":"CT Steel","first_name":"Cameron Steel","last_name":"","middle_name":"","birthdate":"1995-09-13","birthplace":"Greenbrae, California, United States of America","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","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":49478,"title":"Chris Wood","short_name":"CP Wood","first_name":"Chris Wood","last_name":"","middle_name":"","birthdate":"1990-06-27","birthplace":"Basingstoke, Hampshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/CWoody27","instagram_profile":"https:\/\/www.instagram.com\/cwood25\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":49524,"title":"Benny Howell","short_name":"BAC Howell","first_name":"Benny Howell","last_name":"","middle_name":"","birthdate":"1988-10-05","birthplace":"Bordeaux, France","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":"https:\/\/www.facebook.com\/BennyHowellOfficial\/","twitter_profile":"https:\/\/twitter.com\/bennytweets_","instagram_profile":"https:\/\/www.instagram.com\/bennycam13\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":49536,"title":"Mark Stoneman","short_name":"MD Stoneman","first_name":"Mark Stoneman","last_name":"","middle_name":"","birthdate":"1987-06-26","birthplace":"Newcastle upon Tyne, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":18968,"recent_appearance":1514244600,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/mark23stone","instagram_profile":"https:\/\/www.instagram.com\/mark23stone\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49743,"title":"Matthew Fisher","short_name":"MD Fisher","first_name":"Matthew Fisher","last_name":"","middle_name":"","birthdate":"1997-11-09","birthplace":"York","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/9M_Fisher","instagram_profile":"https:\/\/www.instagram.com\/9M_Fisher\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50481,"title":"Felix Organ","short_name":"FS Organ","first_name":"Felix Organ","last_name":"","middle_name":"","birthdate":"1999-06-02","birthplace":"Sydney","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":50484,"title":"Brad Wheal","short_name":"BTJ Wheal","first_name":"Brad Wheal","last_name":"","middle_name":"","birthdate":"1996-08-28","birthplace":"Durban, KwaZulu-Natal","country":"sct","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/brad.wheal\/","twitter_profile":"https:\/\/twitter.com\/BradWheal","instagram_profile":"https:\/\/www.instagram.com\/bradwheal\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Scotland","role":"squad","role_str":""},{"pid":50754,"title":"Dom Sibley","short_name":"DP Sibley","first_name":"Dom Sibley","last_name":"","middle_name":"","birthdate":"1995-09-05","birthplace":"Epsom, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":51285,"title":"Joe Weatherley","short_name":"JJ Weatherley","first_name":"Joe Weatherley","last_name":"","middle_name":"","birthdate":"1997-01-19","birthplace":"Winchester, 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":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Joe_Weatherley","instagram_profile":"https:\/\/www.instagram.com\/jjweatherley\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":51290,"title":"Ollie Pope","short_name":"O Pope","first_name":"Ollie Pope","last_name":"","middle_name":"","birthdate":"1998-01-02","birthplace":"Chelsea, Middlesex","country":"en","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":8.5,"facebook_profile":"https:\/\/www.facebook.com\/OliverJohndouglaspope.3\/","twitter_profile":"https:\/\/twitter.com\/OPope32","instagram_profile":"https:\/\/www.instagram.com\/opope32\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51319,"title":"Will Jacks","short_name":"WG Jacks","first_name":"Will Jacks","last_name":"","middle_name":"","birthdate":"1998-11-21","birthplace":"Chertsey, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Wjacks9","instagram_profile":"https:\/\/www.instagram.com\/willjacks9\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":90946,"title":"Ryan Patel","short_name":"RS Patel","first_name":"Ryan Patel","last_name":"","middle_name":"","birthdate":"1997-10-26","birthplace":"Sutton, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":93749,"title":"Gus Atkinson","short_name":"G Atkinson","first_name":"Gus Atkinson","last_name":"","middle_name":"","birthdate":"1998-01-19","birthplace":"Chelsea, Middlesex","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":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/gus_atkinson1","instagram_profile":"https:\/\/www.instagram.com\/gusatkinson\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":93751,"title":"James Taylor","short_name":"JWA Taylor","first_name":"James Taylor","last_name":"","middle_name":"","birthdate":"2001-01-19","birthplace":"Nottingham","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","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":93836,"title":"Jamie Smith","short_name":"JL Smith","first_name":"Jamie Smith","last_name":"","middle_name":"","birthdate":"2000-07-12","birthplace":"Epsom, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/jamie_smith148\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":96605,"title":"Scott Currie","short_name":"S Currie","first_name":"Scott Currie","last_name":"","middle_name":"","birthdate":"2001-05-02","birthplace":"Poole, Dorset","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":108376,"title":"Tom Prest","short_name":"T Prest","first_name":"Tom Prest","last_name":"","middle_name":"","birthdate":"2003-03-24","birthplace":"Wimborne, Dorset","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108377,"title":"Toby Albert","short_name":"T Albert","first_name":"Toby Albert","last_name":"","middle_name":"","birthdate":"2001-11-12","birthplace":"Basingstoke, Hampshire","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":""},{"pid":108378,"title":"Fletcha Middleton","short_name":"F Middleton","first_name":"Fletcha Middleton","last_name":"","middle_name":"","birthdate":"2002-01-31","birthplace":"Winchester, 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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108381,"title":"John Turner","short_name":"J Turner","first_name":"John Turner","last_name":"","middle_name":"","birthdate":"2001-04-10","birthplace":"Johannesburg, Gauteng","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":108386,"title":"Thomas Lawes","short_name":"T Lawes","first_name":"Thomas Lawes","last_name":"","middle_name":"","birthdate":"2002-12-25","birthplace":"Singapore","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/tom_lawes\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108409,"title":"Sonny Baker","short_name":"S Baker","first_name":"Sonny Baker","last_name":"","middle_name":"","birthdate":"2003-03-13","birthplace":"Torbay, Devon","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\/sonnybaker\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":109051,"title":"Ali Orr","short_name":"AGH Orr","first_name":"Ali Orr","last_name":"","middle_name":"","birthdate":"2001-04-06","birthplace":"Eastbourne, Sussex","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":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/alastairorr\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":109924,"title":"Nathan Barnwell","short_name":"NA Barnwell","first_name":"Nathan Barnwell","last_name":"","middle_name":"","birthdate":"2003-02-03","birthplace":"Ashford, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":110871,"title":"Dewald Brevis","short_name":"D Brevis","first_name":"Dewald Brevis","last_name":"","middle_name":"","birthdate":"2003-04-29","birthplace":"Johannesburg","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/Brevis17\/","twitter_profile":"https:\/\/twitter.com\/BrevisDewald","instagram_profile":"https:\/\/www.instagram.com\/dewald_brevis_17\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bat","role_str":""},{"pid":118551,"title":"Josh Blake","short_name":"J Blake","first_name":"Josh Blake","last_name":"","middle_name":"","birthdate":"1998-09-18","birthplace":"Carshalton, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","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":118552,"title":"Yousef Majid","short_name":"Y Majid","first_name":"Yousef Majid","last_name":"","middle_name":"","birthdate":"2003-09-08","birthplace":"Slough, United Kingdom","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":118936,"title":"Eddie Jack","short_name":"EV Jack","first_name":"Eddie Jack","last_name":"","middle_name":"","birthdate":"2005-09-09","birthplace":"Barnet, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left 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":"England","role":"squad","role_str":""},{"pid":128989,"title":"Lhuan dre Pretorius","short_name":"Ld Pretorius","first_name":"Lhuan dre Pretorius","last_name":"","middle_name":"","birthdate":"2006-03-27","birthplace":"Potchefstroom","country":"za","primary_team":[],"logo_url":"","playing_role":"wk","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":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"wk","role_str":"(WK)"},{"pid":130468,"title":"Tommy Ealham","short_name":"TM Ealham","first_name":"Tommy Ealham","last_name":"","middle_name":"","birthdate":"2004-03-26","birthplace":"Guildford, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":141008,"title":"Ollie Sykes","short_name":"O Sykes","first_name":"Ollie Sykes","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":141527,"title":"Seb Stuart Reckling","short_name":"SS Reckling","first_name":"Seb Stuart Reckling","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""}]},"etag":"22182f4a72e6cba4f11216e61af68de8","modified":"2025-08-05 23:15:23","datetime":"2025-08-05 23:15:23","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":86877,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Surrey won by 69 runs","day_remaining_over":"","team_batting":"Hampshire","team_bowling":"Surrey","live_inning_number":2,"live_score":{"runs":124,"overs":17.5,"wickets":10,"target":194,"runrate":6.95,"required_runrate":32.31},"commentary":1,"wagon":2,"batsmen":[{"name":"John Turner","batsman_id":108381,"runs":4,"balls_faced":8,"fours":0,"sixes":0,"strike_rate":"50.00"},{"name":"Scott Currie","batsman_id":96605,"runs":10,"balls_faced":8,"fours":1,"sixes":0,"strike_rate":"125.00"}],"bowlers":[{"name":"Nathan Smith","bowler_id":1089,"overs":2.5,"runs_conceded":18,"wickets":3,"maidens":0,"econ":"6.40"},{"name":"Chris Jordan","bowler_id":454,"overs":4,"runs_conceded":17,"wickets":2,"maidens":0,"econ":"4.25"}],"commentaries":[{"event_id":"12163689","event":"ball","batsman_id":"49478","bowler_id":"1937","over":"13","ball":"4","score":0,"commentary":"Reece Topley to Chris Wood, no run,","noball_dismissal":false,"text":"","timestamp":1750192678,"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":"12163690","event":"ball","batsman_id":"49478","bowler_id":"1937","over":"13","ball":"5","score":0,"commentary":"Reece Topley to Chris Wood, no run,","noball_dismissal":false,"text":"","timestamp":1750192687,"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":"12163693","event":"ball","batsman_id":"49478","bowler_id":"1937","over":"13","ball":"6","score":1,"commentary":"Reece Topley to Chris Wood, 1 run,","noball_dismissal":false,"text":"","timestamp":1750192691,"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":14,"runs":3,"score":"101\/7","bats":[{"runs":2,"balls_faced":4,"fours":0,"sixes":0,"batsman_id":49478},{"runs":4,"balls_faced":4,"fours":0,"sixes":0,"batsman_id":49524}],"bowls":[{"runs_conceded":24,"maidens":0,"wickets":2,"bowler_id":1937,"overs":3},{"runs_conceded":27,"maidens":0,"wickets":1,"bowler_id":1923,"overs":3}],"commentary":"End of over 14 (3 runs), Hampshire 101\/7"},{"event_id":"12163697","event":"ball","batsman_id":"49478","bowler_id":"1923","over":"14","ball":"1","score":1,"commentary":"Mitchell Santner to Chris Wood, 1 run,","noball_dismissal":false,"text":"","timestamp":1750192696,"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":"12163701","event":"ball","batsman_id":"49524","bowler_id":"1923","over":"14","ball":"2","score":1,"commentary":"Mitchell Santner to Benny Howell, 1 run,","noball_dismissal":false,"text":"","timestamp":1750192727,"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":"12163702","event":"wicket","batsman_id":"49478","bowler_id":"1923","over":"14","ball":"3","score":"w","commentary":"Mitchell Santner to Chris Wood, no run, b M Santner,","noball_dismissal":false,"text":"","timestamp":1750192729,"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":"49478","how_out":"b M Santner","batsman_runs":"3","batsman_balls":"6"},{"event_id":"12163703","event":"ball","batsman_id":"96605","bowler_id":"1923","over":"14","ball":"4","score":"1wd","commentary":"Mitchell Santner to Scott Currie, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750192760,"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":"12163707","event":"ball","batsman_id":"96605","bowler_id":"1923","over":"14","ball":"4","score":1,"commentary":"Mitchell Santner to Scott Currie, 1 run,","noball_dismissal":false,"text":"","timestamp":1750192810,"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":"12163708","event":"ball","batsman_id":"49524","bowler_id":"1923","over":"14","ball":"5","score":4,"commentary":"Mitchell Santner to Benny Howell, Four,","noball_dismissal":false,"text":"","timestamp":1750192814,"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":"12163709","event":"ball","batsman_id":"49524","bowler_id":"1923","over":"14","ball":"6","score":1,"commentary":"Mitchell Santner to Benny Howell, 1 run,","noball_dismissal":false,"text":"","timestamp":1750192817,"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":15,"runs":9,"score":"110\/8","bats":[{"runs":10,"balls_faced":7,"fours":1,"sixes":0,"batsman_id":49524},{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":96605}],"bowls":[{"runs_conceded":36,"maidens":0,"wickets":2,"bowler_id":1923,"overs":4},{"runs_conceded":24,"maidens":0,"wickets":2,"bowler_id":1937,"overs":3}],"commentary":"End of over 15 (9 runs), Hampshire 110\/8"},{"event_id":"12163713","event":"ball","batsman_id":"49524","bowler_id":"1089","over":"15","ball":"1","score":1,"commentary":"Nathan Smith to Benny Howell, 1 run,","noball_dismissal":false,"text":"","timestamp":1750192852,"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":"12163714","event":"ball","batsman_id":"96605","bowler_id":"1089","over":"15","ball":"2","score":1,"commentary":"Nathan Smith to Scott Currie, 1 run,","noball_dismissal":false,"text":"","timestamp":1750192880,"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":"12163716","event":"wicket","batsman_id":"49524","bowler_id":"1089","over":"15","ball":"3","score":"w","commentary":"Nathan Smith to Benny Howell, no run, c J Roy b N Smith,","noball_dismissal":false,"text":"","timestamp":1750193070,"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":"49524","how_out":"c J Roy b N Smith","batsman_runs":"10","batsman_balls":"9"},{"event_id":"12163722","event":"ball","batsman_id":"108381","bowler_id":"1089","over":"15","ball":"4","score":1,"commentary":"Nathan Smith to John Turner, 1 run,","noball_dismissal":false,"text":"","timestamp":1750193073,"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":"12163723","event":"ball","batsman_id":"96605","bowler_id":"1089","over":"15","ball":"5","score":0,"commentary":"Nathan Smith to Scott Currie, no run,","noball_dismissal":false,"text":"","timestamp":1750193076,"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":"12163724","event":"ball","batsman_id":"96605","bowler_id":"1089","over":"15","ball":"6","score":4,"commentary":"Nathan Smith to Scott Currie, Four,","noball_dismissal":false,"text":"","timestamp":1750193098,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event":"overend","over":16,"runs":7,"score":"117\/9","bats":[{"runs":6,"balls_faced":4,"fours":1,"sixes":0,"batsman_id":96605},{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":108381}],"bowls":[{"runs_conceded":14,"maidens":0,"wickets":2,"bowler_id":1089,"overs":2},{"runs_conceded":36,"maidens":0,"wickets":2,"bowler_id":1923,"overs":4}],"commentary":"End of over 16 (7 runs), Hampshire 117\/9"},{"event_id":"12163728","event":"ball","batsman_id":"108381","bowler_id":"454","over":"16","ball":"1","score":0,"commentary":"Chris Jordan to John Turner, no run,","noball_dismissal":false,"text":"","timestamp":1750193213,"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":"12163729","event":"ball","batsman_id":"108381","bowler_id":"454","over":"16","ball":"2","score":0,"commentary":"Chris Jordan to John Turner, no run,","noball_dismissal":false,"text":"","timestamp":1750193216,"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":"12163733","event":"ball","batsman_id":"108381","bowler_id":"454","over":"16","ball":"3","score":0,"commentary":"Chris Jordan to John Turner, no run,","noball_dismissal":false,"text":"","timestamp":1750193225,"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":"12163734","event":"ball","batsman_id":"108381","bowler_id":"454","over":"16","ball":"4","score":1,"commentary":"Chris Jordan to John Turner, 1 run,","noball_dismissal":false,"text":"","timestamp":1750193289,"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":"12163736","event":"ball","batsman_id":"96605","bowler_id":"454","over":"16","ball":"5","score":0,"commentary":"Chris Jordan to Scott Currie, no run,","noball_dismissal":false,"text":"","timestamp":1750193303,"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":"12163738","event":"ball","batsman_id":"96605","bowler_id":"454","over":"16","ball":"6","score":1,"commentary":"Chris Jordan to Scott Currie, 1 run,","noball_dismissal":false,"text":"","timestamp":1750193341,"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":2,"score":"119\/9","bats":[{"runs":7,"balls_faced":6,"fours":1,"sixes":0,"batsman_id":96605},{"runs":2,"balls_faced":5,"fours":0,"sixes":0,"batsman_id":108381}],"bowls":[{"runs_conceded":17,"maidens":0,"wickets":2,"bowler_id":454,"overs":4},{"runs_conceded":14,"maidens":0,"wickets":2,"bowler_id":1089,"overs":2}],"commentary":"End of over 17 (2 runs), Hampshire 119\/9"},{"event_id":"12163740","event":"ball","batsman_id":"96605","bowler_id":"1089","over":"17","ball":"1","score":2,"commentary":"Nathan Smith to Scott Currie, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750193410,"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":"12163744","event":"ball","batsman_id":"96605","bowler_id":"1089","over":"17","ball":"2","score":1,"commentary":"Nathan Smith to Scott Currie, 1 run,","noball_dismissal":false,"text":"","timestamp":1750193456,"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":"12163745","event":"ball","batsman_id":"108381","bowler_id":"1089","over":"17","ball":"3","score":2,"commentary":"Nathan Smith to John Turner, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750193465,"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":"12163747","event":"ball","batsman_id":"108381","bowler_id":"1089","over":"17","ball":"4","score":0,"commentary":"Nathan Smith to John Turner, no run,","noball_dismissal":false,"text":"","timestamp":1750193489,"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":"12163748","event":"wicket","batsman_id":"108381","bowler_id":"1089","over":"17","ball":"5","score":"w","commentary":"Nathan Smith to John Turner, no run, c C Jordan b N Smith,","noball_dismissal":false,"text":"","timestamp":1750193533,"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":"108381","how_out":"c C Jordan b N Smith","batsman_runs":"4","batsman_balls":"8"}],"day":"0","session":"0","live_inning":{"iid":198275,"number":2,"name":"Hampshire Inning","short_name":"HAM Inning","status":2,"issuperover":"false","result":1,"batting_team_id":7047,"fielding_team_id":6995,"scores":"124\/10","scores_full":"124\/10 (17.5 ov)","fielder":[{"fielder_id":"1937","fielder_name":"Reece Topley","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"454","fielder_name":"Chris Jordan","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"49029","fielder_name":"Laurie Evans","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"141008","fielder_name":"Ollie Sykes","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"1089","fielder_name":"Nathan Smith","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"51319","fielder_name":"Will Jacks","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"1929","fielder_name":"Jason Roy","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"1047","fielder_name":"Sam Curran","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"John Turner","batsman_id":"108381","runs":"4","balls":"8","how_out":"c C Jordan b N Smith","score_at_dismissal":124,"overs_at_dismissal":"17.5","bowler_id":"1089","dismissal":"caught","number":10},"extra_runs":{"byes":0,"legbyes":2,"wides":2,"noballs":0,"penalty":"0","total":4},"equations":{"runs":124,"wickets":10,"overs":"17.5","bowlers_used":6,"runrate":"6.95"},"current_partnership":{"runs":12,"balls":14,"overs":2.2,"batsmen":[{"name":"John Turner","batsman_id":108381,"runs":4,"balls":8},{"name":"Scott Currie","batsman_id":96605,"runs":8,"balls":6}]},"did_not_bat":[],"max_over":"20","target":"194","recent_scores":"w,0,2,1,2,1,0,1,0,0,0,4,0,1,w,1,1,1","last_five_overs":"27\/4 5.23","last_ten_overs":"61\/7 6.00"},"teams":[{"tid":6995,"title":"Surrey","abbr":"SUR","alt_name":"Surrey","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/surrey-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/surrey-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"193\/6 (20 ov)","scores":"193\/6","overs":"20"},{"tid":7047,"title":"Hampshire","abbr":"HAM","alt_name":"HAM","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/hampshire-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/hampshire-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"124\/10 (17.5 ov)","scores":"124\/10","overs":"17.5"}],"players":[{"pid":432,"title":"Kyle Abbott","short_name":"K Abbott","first_name":"Kyle Abbott","last_name":"","middle_name":"","birthdate":"1987-06-18","birthplace":"Empangeni, KwaZulu-Natal","country":"za","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":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":454,"title":"Chris Jordan","short_name":"C Jordan","first_name":"Chris Jordan","last_name":"","middle_name":"","birthdate":"1988-10-04","birthplace":"Barbados","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.5,"facebook_profile":"https:\/\/www.facebook.com\/ChrisJordanOfficial\/","twitter_profile":"https:\/\/twitter.com\/CJordan","instagram_profile":"https:\/\/www.instagram.com\/cjrjordan\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":1042,"title":"Dan Lawrence","short_name":"DW Lawrence","first_name":"Dan Lawrence","last_name":"","middle_name":"","birthdate":"1997-07-12","birthplace":"Whipps Cross, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"https:\/\/www.facebook.com\/danlawrence25\/","twitter_profile":"https:\/\/twitter.com\/_DanLawrence","instagram_profile":"https:\/\/www.instagram.com\/daniellawrence28\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":1047,"title":"Sam Curran","short_name":"S Curran","first_name":"Sam Curran","last_name":"","middle_name":"","birthdate":"1998-06-03","birthplace":"Northampton","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/CurranSM\/","twitter_profile":"https:\/\/twitter.com\/CurranSM","instagram_profile":"https:\/\/www.instagram.com\/samcurran58\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":"(C)"},{"pid":1089,"title":"Nathan Smith","short_name":"N Smith","first_name":"Nathan Smith","last_name":"","middle_name":"","birthdate":"1998-07-15","birthplace":"Dunedin, Otago","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":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bowl","role_str":""},{"pid":1923,"title":"Mitchell Santner","short_name":"M Santner","first_name":"Mitchell Santner","last_name":"","middle_name":"","birthdate":"1992-02-05","birthplace":" Hamilton","country":"nz","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/mitchellsantnernz\/","twitter_profile":"https:\/\/twitter.com\/MitchellSantner","instagram_profile":"https:\/\/www.instagram.com\/mitchsantner\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"all","role_str":""},{"pid":1929,"title":"Jason Roy","short_name":"J Roy","first_name":"Jason Roy","last_name":"","middle_name":"","birthdate":"1990-07-21","birthplace":"Durban, South Africa","country":"en","primary_team":{"tid":490,"name":"","short_name":""},"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/JasonRoy20\/","twitter_profile":"https:\/\/twitter.com\/JasonRoy20","instagram_profile":"https:\/\/www.instagram.com\/jasonroy20\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":1937,"title":"Reece Topley","short_name":"R Topley","first_name":"Reece Topley","last_name":"","middle_name":"","birthdate":"1994-02-21","birthplace":"Ipswich, Suffolk","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/ReeceJamesWilliamTopley\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/reecejwtopley\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":1945,"title":"Liam Dawson","short_name":"L Dawson","first_name":"Liam Dawson","last_name":"","middle_name":"","birthdate":"1990-03-01","birthplace":"Swindon, Wiltshire","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/daws128\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":1949,"title":"James Vince","short_name":"J Vince","first_name":"James Vince","last_name":"","middle_name":"","birthdate":"1991-03-14","birthplace":"Cuckfield, Sussex","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":9,"facebook_profile":"https:\/\/www.facebook.com\/vincey14\/","twitter_profile":"https:\/\/twitter.com\/vincey14","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"pid":10598,"title":"Ben Foakes","short_name":"BT Foakes","first_name":"Ben Foakes","last_name":"","middle_name":"","birthdate":"1993-02-15","birthplace":"Colchester, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":10600,"title":"Rory Burns","short_name":"RJ Burns","first_name":"Rory Burns","last_name":"","middle_name":"","birthdate":"1990-08-26","birthplace":"Epsom, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"Occasional Wicketkeeper","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":32166,"title":"James Fuller","short_name":"JK Fuller","first_name":"James Fuller","last_name":"","middle_name":"","birthdate":"1990-01-24","birthplace":"Cape Town, Cape Province","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/James_Fuller246","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":43383,"title":"Jamie Overton","short_name":"J Overton","first_name":"Jamie Overton","last_name":"","middle_name":"","birthdate":"1994-04-10","birthplace":"Barnstaple, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/JamieOverton","instagram_profile":"https:\/\/www.instagram.com\/jamie_overton8\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":43389,"title":"Tom Curran","short_name":"TK Curran","first_name":"Tom Curran","last_name":"","middle_name":"","birthdate":"1995-03-12","birthplace":"Cape Town, Cape Province","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/tc59","instagram_profile":"https:\/\/www.instagram.com\/tc59\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":43630,"title":"Daniel Worrall","short_name":"DJ Worrall","first_name":"Daniel Worrall","last_name":"","middle_name":"","birthdate":"1991-07-10","birthplace":"Melbourne, Victoria","country":"au","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":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":46147,"title":"Bjorn Fortuin","short_name":"BC Fortuin","first_name":"Bjorn Fortuin","last_name":"","middle_name":"","birthdate":"1994-10-21","birthplace":"Paarl","country":"za","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":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/bjorn_fortuin","instagram_profile":"https:\/\/www.instagram.com\/bjornfortuin\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":48440,"title":"Jordan Clark","short_name":"J Clark","first_name":"Jordan Clark","last_name":"","middle_name":"","birthdate":"1990-10-14","birthplace":"Whitehaven, Cumbria","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"Occasional Wicketkeeper","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":49029,"title":"Laurie Evans","short_name":"LJ Evans","first_name":"Laurie Evans","last_name":"","middle_name":"","birthdate":"1987-10-12","birthplace":"Lambeth, London","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/laurie.evans.39\/","twitter_profile":"https:\/\/twitter.com\/LaurieEvans32","instagram_profile":"https:\/\/www.instagram.com\/laurieevans32\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(WK)"},{"pid":49324,"title":"Matt Dunn","short_name":"MP Dunn","first_name":"Matt Dunn","last_name":"","middle_name":"","birthdate":"1992-05-05","birthplace":"Egham, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Fast","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":49334,"title":"Ben Brown","short_name":"BC Brown","first_name":"Ben Brown","last_name":"","middle_name":"","birthdate":"1988-11-23","birthplace":"Crawley, Sussex","country":"en","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":"https:\/\/twitter.com\/Ben_Brown26","instagram_profile":"https:\/\/www.instagram.com\/benbrown26\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49343,"title":"Nick Gubbins","short_name":"NRT Gubbins","first_name":"Nick Gubbins","last_name":"","middle_name":"","birthdate":"1993-12-31","birthplace":"Richmond, Surrey","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49428,"title":"Cameron Steel","short_name":"CT Steel","first_name":"Cameron Steel","last_name":"","middle_name":"","birthdate":"1995-09-13","birthplace":"Greenbrae, California, United States of America","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","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":49478,"title":"Chris Wood","short_name":"CP Wood","first_name":"Chris Wood","last_name":"","middle_name":"","birthdate":"1990-06-27","birthplace":"Basingstoke, Hampshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/CWoody27","instagram_profile":"https:\/\/www.instagram.com\/cwood25\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":49524,"title":"Benny Howell","short_name":"BAC Howell","first_name":"Benny Howell","last_name":"","middle_name":"","birthdate":"1988-10-05","birthplace":"Bordeaux, France","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":"https:\/\/www.facebook.com\/BennyHowellOfficial\/","twitter_profile":"https:\/\/twitter.com\/bennytweets_","instagram_profile":"https:\/\/www.instagram.com\/bennycam13\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":49536,"title":"Mark Stoneman","short_name":"MD Stoneman","first_name":"Mark Stoneman","last_name":"","middle_name":"","birthdate":"1987-06-26","birthplace":"Newcastle upon Tyne, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":18968,"recent_appearance":1514244600,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/mark23stone","instagram_profile":"https:\/\/www.instagram.com\/mark23stone\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49743,"title":"Matthew Fisher","short_name":"MD Fisher","first_name":"Matthew Fisher","last_name":"","middle_name":"","birthdate":"1997-11-09","birthplace":"York","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/9M_Fisher","instagram_profile":"https:\/\/www.instagram.com\/9M_Fisher\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50481,"title":"Felix Organ","short_name":"FS Organ","first_name":"Felix Organ","last_name":"","middle_name":"","birthdate":"1999-06-02","birthplace":"Sydney","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":50484,"title":"Brad Wheal","short_name":"BTJ Wheal","first_name":"Brad Wheal","last_name":"","middle_name":"","birthdate":"1996-08-28","birthplace":"Durban, KwaZulu-Natal","country":"sct","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/brad.wheal\/","twitter_profile":"https:\/\/twitter.com\/BradWheal","instagram_profile":"https:\/\/www.instagram.com\/bradwheal\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Scotland","role":"squad","role_str":""},{"pid":50754,"title":"Dom Sibley","short_name":"DP Sibley","first_name":"Dom Sibley","last_name":"","middle_name":"","birthdate":"1995-09-05","birthplace":"Epsom, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":51285,"title":"Joe Weatherley","short_name":"JJ Weatherley","first_name":"Joe Weatherley","last_name":"","middle_name":"","birthdate":"1997-01-19","birthplace":"Winchester, 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":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Joe_Weatherley","instagram_profile":"https:\/\/www.instagram.com\/jjweatherley\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":51290,"title":"Ollie Pope","short_name":"O Pope","first_name":"Ollie Pope","last_name":"","middle_name":"","birthdate":"1998-01-02","birthplace":"Chelsea, Middlesex","country":"en","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":8.5,"facebook_profile":"https:\/\/www.facebook.com\/OliverJohndouglaspope.3\/","twitter_profile":"https:\/\/twitter.com\/OPope32","instagram_profile":"https:\/\/www.instagram.com\/opope32\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51319,"title":"Will Jacks","short_name":"WG Jacks","first_name":"Will Jacks","last_name":"","middle_name":"","birthdate":"1998-11-21","birthplace":"Chertsey, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Wjacks9","instagram_profile":"https:\/\/www.instagram.com\/willjacks9\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":90946,"title":"Ryan Patel","short_name":"RS Patel","first_name":"Ryan Patel","last_name":"","middle_name":"","birthdate":"1997-10-26","birthplace":"Sutton, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":93749,"title":"Gus Atkinson","short_name":"G Atkinson","first_name":"Gus Atkinson","last_name":"","middle_name":"","birthdate":"1998-01-19","birthplace":"Chelsea, Middlesex","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":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/gus_atkinson1","instagram_profile":"https:\/\/www.instagram.com\/gusatkinson\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":93751,"title":"James Taylor","short_name":"JWA Taylor","first_name":"James Taylor","last_name":"","middle_name":"","birthdate":"2001-01-19","birthplace":"Nottingham","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","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":93836,"title":"Jamie Smith","short_name":"JL Smith","first_name":"Jamie Smith","last_name":"","middle_name":"","birthdate":"2000-07-12","birthplace":"Epsom, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/jamie_smith148\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":96605,"title":"Scott Currie","short_name":"S Currie","first_name":"Scott Currie","last_name":"","middle_name":"","birthdate":"2001-05-02","birthplace":"Poole, Dorset","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":108376,"title":"Tom Prest","short_name":"T Prest","first_name":"Tom Prest","last_name":"","middle_name":"","birthdate":"2003-03-24","birthplace":"Wimborne, Dorset","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108377,"title":"Toby Albert","short_name":"T Albert","first_name":"Toby Albert","last_name":"","middle_name":"","birthdate":"2001-11-12","birthplace":"Basingstoke, Hampshire","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":""},{"pid":108378,"title":"Fletcha Middleton","short_name":"F Middleton","first_name":"Fletcha Middleton","last_name":"","middle_name":"","birthdate":"2002-01-31","birthplace":"Winchester, 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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108381,"title":"John Turner","short_name":"J Turner","first_name":"John Turner","last_name":"","middle_name":"","birthdate":"2001-04-10","birthplace":"Johannesburg, Gauteng","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":108386,"title":"Thomas Lawes","short_name":"T Lawes","first_name":"Thomas Lawes","last_name":"","middle_name":"","birthdate":"2002-12-25","birthplace":"Singapore","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/tom_lawes\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108409,"title":"Sonny Baker","short_name":"S Baker","first_name":"Sonny Baker","last_name":"","middle_name":"","birthdate":"2003-03-13","birthplace":"Torbay, Devon","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\/sonnybaker\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":109051,"title":"Ali Orr","short_name":"AGH Orr","first_name":"Ali Orr","last_name":"","middle_name":"","birthdate":"2001-04-06","birthplace":"Eastbourne, Sussex","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":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/alastairorr\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":109924,"title":"Nathan Barnwell","short_name":"NA Barnwell","first_name":"Nathan Barnwell","last_name":"","middle_name":"","birthdate":"2003-02-03","birthplace":"Ashford, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":110871,"title":"Dewald Brevis","short_name":"D Brevis","first_name":"Dewald Brevis","last_name":"","middle_name":"","birthdate":"2003-04-29","birthplace":"Johannesburg","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/Brevis17\/","twitter_profile":"https:\/\/twitter.com\/BrevisDewald","instagram_profile":"https:\/\/www.instagram.com\/dewald_brevis_17\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bat","role_str":""},{"pid":118551,"title":"Josh Blake","short_name":"J Blake","first_name":"Josh Blake","last_name":"","middle_name":"","birthdate":"1998-09-18","birthplace":"Carshalton, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","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":118552,"title":"Yousef Majid","short_name":"Y Majid","first_name":"Yousef Majid","last_name":"","middle_name":"","birthdate":"2003-09-08","birthplace":"Slough, United Kingdom","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":118936,"title":"Eddie Jack","short_name":"EV Jack","first_name":"Eddie Jack","last_name":"","middle_name":"","birthdate":"2005-09-09","birthplace":"Barnet, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left 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":"England","role":"squad","role_str":""},{"pid":128989,"title":"Lhuan dre Pretorius","short_name":"Ld Pretorius","first_name":"Lhuan dre Pretorius","last_name":"","middle_name":"","birthdate":"2006-03-27","birthplace":"Potchefstroom","country":"za","primary_team":[],"logo_url":"","playing_role":"wk","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":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"wk","role_str":"(WK)"},{"pid":130468,"title":"Tommy Ealham","short_name":"TM Ealham","first_name":"Tommy Ealham","last_name":"","middle_name":"","birthdate":"2004-03-26","birthplace":"Guildford, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":141008,"title":"Ollie Sykes","short_name":"O Sykes","first_name":"Ollie Sykes","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":141527,"title":"Seb Stuart Reckling","short_name":"SS Reckling","first_name":"Seb Stuart Reckling","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""}]},"etag":"22182f4a72e6cba4f11216e61af68de8","modified":"2025-08-05 23:15:23","datetime":"2025-08-05 23:15:23","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86877 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:a55787e5-a593-401d-b613-e68643e1e904 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86877 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86877,3,'{"status":"ok","response":{"match_id":86877,"title":"Hampshire vs Surrey","short_title":"HAM vs SUR","subtitle":"Match 57","match_number":"57","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Surrey won by 69 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":7047,"name":"Hampshire","short_name":"HAM","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/hampshire-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/hampshire-logo.png","scores_full":"124\/10 (17.5 ov)","scores":"124\/10","overs":"17.5"},"teamb":{"team_id":6995,"name":"Surrey","short_name":"SUR","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/surrey-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/surrey-logo.png","scores_full":"193\/6 (20 ov)","scores":"193\/6","overs":"20"},"date_start":"2025-06-17 18:00:00","date_end":"2025-06-18 04:00:00","timestamp_start":1750183200,"timestamp_end":1750219200,"date_start_ist":"2025-06-17 23:30:00","date_end_ist":"2025-06-18 09:30:00","venue":{"venue_id":"9","name":"The Rose Bowl","location":"Southampton","country":"England","timezone":""},"umpires":"","referee":"","equation":"","live":"","result":"SUR won by 69 runs","result_type":2,"win_margin":"69 runs","winning_team_id":6995,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-15 21:28:57","verify_time":"2025-06-18 02:37:32","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"scattered clouds","temp":18.35,"humidity":77,"visibility":10000,"wind_speed":"7.81","clouds":43},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Hampshire elected to bowl","winner":7047,"decision":2}},"etag":"ac9f416f14fc2546fae5a856eee4a67c","modified":"2025-08-05 23:15:24","datetime":"2025-08-05 23:15:24","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":86877,"title":"Hampshire vs Surrey","short_title":"HAM vs SUR","subtitle":"Match 57","match_number":"57","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Surrey won by 69 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":7047,"name":"Hampshire","short_name":"HAM","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/hampshire-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/hampshire-logo.png","scores_full":"124\/10 (17.5 ov)","scores":"124\/10","overs":"17.5"},"teamb":{"team_id":6995,"name":"Surrey","short_name":"SUR","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/surrey-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/surrey-logo.png","scores_full":"193\/6 (20 ov)","scores":"193\/6","overs":"20"},"date_start":"2025-06-17 18:00:00","date_end":"2025-06-18 04:00:00","timestamp_start":1750183200,"timestamp_end":1750219200,"date_start_ist":"2025-06-17 23:30:00","date_end_ist":"2025-06-18 09:30:00","venue":{"venue_id":"9","name":"The Rose Bowl","location":"Southampton","country":"England","timezone":""},"umpires":"","referee":"","equation":"","live":"","result":"SUR won by 69 runs","result_type":2,"win_margin":"69 runs","winning_team_id":6995,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-15 21:28:57","verify_time":"2025-06-18 02:37:32","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"scattered clouds","temp":18.35,"humidity":77,"visibility":10000,"wind_speed":"7.81","clouds":43},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Hampshire elected to bowl","winner":7047,"decision":2}},"etag":"ac9f416f14fc2546fae5a856eee4a67c","modified":"2025-08-05 23:15:24","datetime":"2025-08-05 23:15:24","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86877 AND DataTypeId = 3 END
Live Report & Scorecard of Hampshire vs Surrey Match 57