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:d5056115-e1a5-41a6-b2d2-7cd014e56e4a
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86879 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86879,1,'{"status":"ok","response":{"mid":86879,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Surrey won by 48 runs","day_remaining_over":"","team_batting":"Sussex","team_bowling":"Surrey","live_inning_number":2,"live_score":{"runs":162,"overs":19.5,"wickets":10,"target":211,"runrate":8.17,"required_runrate":294},"commentary":1,"wagon":2,"batsmen":[{"name":"Danny Lamb","batsman_id":50623,"runs":49,"balls_faced":34,"fours":5,"sixes":1,"strike_rate":"144.12"},{"name":"Bradley Currie","batsman_id":118322,"runs":3,"balls_faced":3,"fours":0,"sixes":0,"strike_rate":"100.00"}],"bowlers":[{"name":"Chris Jordan","bowler_id":454,"overs":3.5,"runs_conceded":35,"wickets":1,"maidens":0,"econ":"9.13"},{"name":"Reece Topley","bowler_id":1937,"overs":4,"runs_conceded":34,"wickets":3,"maidens":0,"econ":"8.50"}],"commentaries":[{"event_id":"12169484","event":"ball","batsman_id":"43634","bowler_id":"1923","over":"15","ball":"3","score":1,"commentary":"Mitchell Santner to Nathan McAndrew, 1 run,","noball_dismissal":false,"text":"","timestamp":1750277510,"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":"12169486","event":"ball","batsman_id":"50623","bowler_id":"1923","over":"15","ball":"4","score":4,"commentary":"Mitchell Santner to Danny Lamb, Four,","noball_dismissal":false,"text":"","timestamp":1750277545,"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":"12169488","event":"ball","batsman_id":"50623","bowler_id":"1923","over":"15","ball":"5","score":1,"commentary":"Mitchell Santner to Danny Lamb, 1 run,","noball_dismissal":false,"text":"","timestamp":1750277563,"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":"12169492","event":"ball","batsman_id":"43634","bowler_id":"1923","over":"15","ball":"6","score":1,"commentary":"Mitchell Santner to Nathan McAndrew, 1 run,","noball_dismissal":false,"text":"","timestamp":1750277604,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":16,"runs":7,"score":"134\/6","bats":[{"runs":2,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":43634},{"runs":34,"balls_faced":23,"fours":3,"sixes":1,"batsman_id":50623}],"bowls":[{"runs_conceded":26,"maidens":0,"wickets":3,"bowler_id":1923,"overs":4},{"runs_conceded":14,"maidens":0,"wickets":1,"bowler_id":43389,"overs":3}],"commentary":"End of over 16 (7 runs), Sussex 134\/6"},{"event_id":"12169496","event":"ball","batsman_id":"43634","bowler_id":"43389","over":"16","ball":"1","score":4,"commentary":"Tom Curran to Nathan McAndrew, Four,","noball_dismissal":false,"text":"","timestamp":1750277651,"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":"12169502","event":"ball","batsman_id":"43634","bowler_id":"43389","over":"16","ball":"2","score":2,"commentary":"Tom Curran to Nathan McAndrew, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750277711,"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":"12169509","event":"wicket","batsman_id":"43634","bowler_id":"43389","over":"16","ball":"3","score":"w","commentary":"Tom Curran to Nathan McAndrew, no run, c J Roy b TK Curran,","noball_dismissal":false,"text":"","timestamp":1750277734,"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":"43634","how_out":"c J Roy b TK Curran","batsman_runs":"8","batsman_balls":"6"},{"event_id":"12169512","event":"ball","batsman_id":"43366","bowler_id":"43389","over":"16","ball":"4","score":1,"commentary":"Tom Curran to Tymal Mills, 1 run,","noball_dismissal":false,"text":"","timestamp":1750277789,"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":"12169514","event":"ball","batsman_id":"50623","bowler_id":"43389","over":"16","ball":"5","score":2,"commentary":"Tom Curran to Danny Lamb, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750277815,"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":"12169516","event":"ball","batsman_id":"50623","bowler_id":"43389","over":"16","ball":"6","score":1,"commentary":"Tom Curran to Danny Lamb, 1 run,","noball_dismissal":false,"text":"","timestamp":1750277857,"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":10,"score":"144\/7","bats":[{"runs":37,"balls_faced":25,"fours":3,"sixes":1,"batsman_id":50623},{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":43366}],"bowls":[{"runs_conceded":24,"maidens":0,"wickets":2,"bowler_id":43389,"overs":4},{"runs_conceded":26,"maidens":0,"wickets":3,"bowler_id":1923,"overs":4}],"commentary":"End of over 17 (10 runs), Sussex 144\/7"},{"event_id":"12169518","event":"ball","batsman_id":"50623","bowler_id":"454","over":"17","ball":"1","score":0,"commentary":"Chris Jordan to Danny Lamb, no run,","noball_dismissal":false,"text":"","timestamp":1750277912,"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":"12169524","event":"ball","batsman_id":"50623","bowler_id":"454","over":"17","ball":"2","score":4,"commentary":"Chris Jordan to Danny Lamb, Four,","noball_dismissal":false,"text":"","timestamp":1750277939,"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":"12169531","event":"ball","batsman_id":"50623","bowler_id":"454","over":"17","ball":"3","score":1,"commentary":"Chris Jordan to Danny Lamb, 1 run,","noball_dismissal":false,"text":"","timestamp":1750277977,"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":"12169536","event":"ball","batsman_id":"43366","bowler_id":"454","over":"17","ball":"4","score":0,"commentary":"Chris Jordan to Tymal Mills, no run,","noball_dismissal":false,"text":"","timestamp":1750278019,"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":"12169538","event":"ball","batsman_id":"43366","bowler_id":"454","over":"17","ball":"5","score":2,"commentary":"Chris Jordan to Tymal Mills, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750278069,"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":"12169541","event":"ball","batsman_id":"43366","bowler_id":"454","over":"17","ball":"6","score":0,"commentary":"Chris Jordan to Tymal Mills, no run,","noball_dismissal":false,"text":"","timestamp":1750278107,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":18,"runs":7,"score":"151\/7","bats":[{"runs":3,"balls_faced":4,"fours":0,"sixes":0,"batsman_id":43366},{"runs":42,"balls_faced":28,"fours":4,"sixes":1,"batsman_id":50623}],"bowls":[{"runs_conceded":28,"maidens":0,"wickets":0,"bowler_id":454,"overs":3},{"runs_conceded":24,"maidens":0,"wickets":2,"bowler_id":43389,"overs":4}],"commentary":"End of over 18 (7 runs), Sussex 151\/7"},{"event_id":"12169548","event":"wicket","batsman_id":"50623","bowler_id":"1937","over":"18","ball":"1","score":"w","commentary":"Reece Topley to Danny Lamb, 1 run, runout (LJ Evans \/ S Curran),","noball_dismissal":false,"text":"","timestamp":1750278270,"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,"wicket_batsman_id":"43366","how_out":"runout (LJ Evans \/ S Curran)","batsman_runs":"3","batsman_balls":"4"},{"event_id":"12169560","event":"ball","batsman_id":"101482","bowler_id":"1937","over":"18","ball":"2","score":1,"commentary":"Reece Topley to Henry Thomas Crocombe, 1 run,","noball_dismissal":false,"text":"","timestamp":1750278294,"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":"12169561","event":"ball","batsman_id":"50623","bowler_id":"1937","over":"18","ball":"3","score":1,"commentary":"Reece Topley to Danny Lamb, 1 run,","noball_dismissal":false,"text":"","timestamp":1750278299,"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":"12169562","event":"wicket","batsman_id":"101482","bowler_id":"1937","over":"18","ball":"4","score":"w","commentary":"Reece Topley to Henry Thomas Crocombe, no run, b R Topley,","noball_dismissal":false,"text":"","timestamp":1750278331,"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":"101482","how_out":"b R Topley","batsman_runs":"1","batsman_balls":"2"},{"event_id":"12169565","event":"ball","batsman_id":"118322","bowler_id":"1937","over":"18","ball":"5","score":1,"commentary":"Reece Topley to Bradley Currie, 1 run,","noball_dismissal":false,"text":"","timestamp":1750278391,"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":"12169567","event":"ball","batsman_id":"50623","bowler_id":"1937","over":"18","ball":"6","score":0,"commentary":"Reece Topley to Danny Lamb, no run,","noball_dismissal":false,"text":"","timestamp":1750278437,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":19,"runs":4,"score":"155\/9","bats":[{"runs":44,"balls_faced":31,"fours":4,"sixes":1,"batsman_id":50623},{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":118322}],"bowls":[{"runs_conceded":34,"maidens":0,"wickets":3,"bowler_id":1937,"overs":4},{"runs_conceded":28,"maidens":0,"wickets":0,"bowler_id":454,"overs":3}],"commentary":"End of over 19 (4 runs), Sussex 155\/9"},{"event_id":"12169572","event":"ball","batsman_id":"118322","bowler_id":"454","over":"19","ball":"1","score":1,"commentary":"Chris Jordan to Bradley Currie, 1 run,","noball_dismissal":false,"text":"","timestamp":1750278502,"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":"12169575","event":"ball","batsman_id":"50623","bowler_id":"454","over":"19","ball":"2","score":1,"commentary":"Chris Jordan to Danny Lamb, 1 run,","noball_dismissal":false,"text":"","timestamp":1750278567,"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":"12169576","event":"ball","batsman_id":"118322","bowler_id":"454","over":"19","ball":"3","score":1,"commentary":"Chris Jordan to Bradley Currie, 1 run,","noball_dismissal":false,"text":"","timestamp":1750278597,"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":"12169578","event":"ball","batsman_id":"50623","bowler_id":"454","over":"19","ball":"4","score":4,"commentary":"Chris Jordan to Danny Lamb, Four,","noball_dismissal":false,"text":"","timestamp":1750278630,"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":"12169579","event":"wicket","batsman_id":"50623","bowler_id":"454","over":"19","ball":"5","score":"w","commentary":"Chris Jordan to Danny Lamb, no run, b C Jordan,","noball_dismissal":false,"text":"","timestamp":1750278689,"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":"50623","how_out":"b C Jordan","batsman_runs":"49","batsman_balls":"34"}],"day":"0","session":"0","live_inning":{"iid":198336,"number":2,"name":"Sussex Inning","short_name":"SUS Inning","status":2,"issuperover":"false","result":1,"batting_team_id":5721,"fielding_team_id":6995,"scores":"162\/10","scores_full":"162\/10 (19.5 ov)","fielder":[{"fielder_id":"51319","fielder_name":"Will Jacks","catches":2,"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":"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":0,"runout_thrower":1,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"49029","fielder_name":"Laurie Evans","catches":0,"runout_thrower":0,"runout_catcher":1,"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":"Danny Lamb","batsman_id":"50623","runs":"49","balls":"34","how_out":"b C Jordan","score_at_dismissal":162,"overs_at_dismissal":"19.5","bowler_id":"454","dismissal":"bowled","number":10},"extra_runs":{"byes":4,"legbyes":1,"wides":3,"noballs":0,"penalty":"0","total":8},"equations":{"runs":162,"wickets":10,"overs":"19.5","bowlers_used":6,"runrate":"8.17"},"current_partnership":{"runs":8,"balls":7,"overs":1.1,"batsmen":[{"name":"Bradley Currie","batsman_id":118322,"runs":3,"balls":3},{"name":"Danny Lamb","batsman_id":50623,"runs":5,"balls":4}]},"did_not_bat":[],"max_over":"20","target":"211","recent_scores":"w,4,1,1,1,0,1,w,1,1,w,0,2,0,1,4,0,1","last_five_overs":"36\/5 7.20","last_ten_overs":"80\/6 7.87"},"teams":[{"tid":5721,"title":"Sussex","abbr":"SUS","alt_name":"SUS","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/sussex-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/sussex-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"162\/10 (19.5 ov)","scores":"162\/10","overs":"19.5"},{"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":"210\/6 (20 ov)","scores":"210\/6","overs":"20"}],"players":[{"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":682,"title":"Jaydev Unadkat","short_name":"J Unadkat","first_name":"Jaydev Unadkat","last_name":"","middle_name":"","birthdate":"1991-10-18","birthplace":"Porbandar","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/JUnadkat","instagram_profile":"https:\/\/www.instagram.com\/jd_unadkat\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","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":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":43366,"title":"Tymal Mills","short_name":"TS Mills","first_name":"Tymal Mills","last_name":"","middle_name":"","birthdate":"1992-08-12","birthplace":"Dewsbury, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/tmills15\/","twitter_profile":"https:\/\/twitter.com\/tmills15","instagram_profile":"https:\/\/www.instagram.com\/tymalmills\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":"(C)"},{"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":43634,"title":"Nathan McAndrew","short_name":"NJ McAndrew","first_name":"Nathan McAndrew","last_name":"","middle_name":"","birthdate":"1993-07-14","birthplace":"Wollongong, NSW","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/nmcandrew44","instagram_profile":"https:\/\/www.instagram.com\/nathan_mcandrew\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"all","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":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":49495,"title":"John Simpson","short_name":"JA Simpson","first_name":"John Simpson","last_name":"","middle_name":"","birthdate":"1988-07-13","birthplace":"Bury, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/JohnAndrewSimpson\/","twitter_profile":"https:\/\/twitter.com\/JohnSimpson_88","instagram_profile":"https:\/\/www.instagram.com\/johnsimpson_88\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"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":50623,"title":"Danny Lamb","short_name":"DJ Lamb","first_name":"Danny Lamb","last_name":"","middle_name":"","birthdate":"1995-09-07","birthplace":"Preston, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lamby236","instagram_profile":"https:\/\/www.instagram.com\/dannylamb190\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","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":50846,"title":"Tom Alsop","short_name":"TP Alsop","first_name":"Tom Alsop","last_name":"","middle_name":"","birthdate":"1995-11-26","birthplace":"High Wycombe, Buckinghamshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"Wicketkeeper Batter","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/tomalsop1","instagram_profile":"https:\/\/www.instagram.com\/tom.alsop\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51091,"title":"Harrison Ward","short_name":"HD Ward","first_name":"Harrison Ward","last_name":"","middle_name":"","birthdate":"1999-10-25","birthplace":"Oxford","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/delraw09","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51271,"title":"Tom Haines","short_name":"TJ Haines","first_name":"Tom Haines","last_name":"","middle_name":"","birthdate":"1998-10-28","birthplace":"","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":51308,"title":"Ollie Robinson","short_name":"OE Robinson","first_name":"Ollie Robinson","last_name":"","middle_name":"","birthdate":"1993-12-01","birthplace":"Margate, Kent","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,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/OllieRobinson7","instagram_profile":"https:\/\/www.instagram.com\/ollierobinson25\/","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":90598,"title":"Daniel Hughes","short_name":"DPHughes","first_name":"Daniel Hughes","last_name":"","middle_name":"","birthdate":"1989-02-16","birthplace":" Cowra","country":"au","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":"https:\/\/twitter.com\/Hughesy1989","instagram_profile":"https:\/\/www.instagram.com\/danielhughes16\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"bat","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":95551,"title":"Tom Clark","short_name":"T Clark","first_name":"Tom Clark","last_name":"","middle_name":"","birthdate":"2001-07-02","birthplace":"Geoffrey Reeves","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":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/tomclark2702","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":96398,"title":"Jayden Seales","short_name":"J Seales","first_name":"Jayden Seales","last_name":"","middle_name":"","birthdate":"2001-09-10","birthplace":"Trinidad & Tobago","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/jayden_seales","instagram_profile":"https:\/\/www.instagram.com\/jay_seales\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":101481,"title":"Jack Joshua Carson","short_name":"J J Carson","first_name":"Jack Joshua Carson","last_name":"","middle_name":"","birthdate":"2000-12-03","birthplace":"Craigavon, Co Armagh, Ireland","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/_jackcarson11","instagram_profile":"https:\/\/www.instagram.com\/_jackcarson\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":101482,"title":"Henry Thomas Crocombe","short_name":"H T Crocombe","first_name":"Henry Thomas Crocombe","last_name":"","middle_name":"","birthdate":"2001-09-20","birthplace":"Eastbourne, United Kingdom","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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/henrycrocombe\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":102957,"title":"James Coles","short_name":"J Coles","first_name":"James Coles","last_name":"","middle_name":"","birthdate":"2004-04-04","birthplace":"Aylesbury, Buckinghamshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":107332,"title":"Sean Hunt","short_name":"S Hunt","first_name":"Sean Hunt","last_name":"","middle_name":"","birthdate":"2001-12-07","birthplace":" Guildford, Surrey","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":108396,"title":"Danial Ibrahim","short_name":"D Ibrahim","first_name":"Danial Ibrahim","last_name":"","middle_name":"","birthdate":"2004-08-09","birthplace":"Burnley, Lancashire, England","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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/danialibrahim\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108398,"title":"Oliver Carter","short_name":"O Carter","first_name":"Oliver Carter","last_name":"","middle_name":"","birthdate":"2001-11-02","birthplace":"Eastbourne, Sussex, England","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108400,"title":"Archie Lenham","short_name":"A Lenham","first_name":"Archie Lenham","last_name":"","middle_name":"","birthdate":"2004-07-23","birthplace":"Eastbourne, Sussex","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":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":109542,"title":"George Thomas II","short_name":"G Thomas II","first_name":"George Thomas II","last_name":"","middle_name":"","birthdate":"2003-11-14","birthplace":"Taunton, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","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":114207,"title":"Ari Karvelas","short_name":"A Karvelas","first_name":"Ari Karvelas","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","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":"International","role":"squad","role_str":""},{"pid":118322,"title":"Bradley Currie","short_name":"BJ Currie","first_name":"Bradley Currie","last_name":"","middle_name":"","birthdate":"1998-11-08","birthplace":"Poole, United Kingdom","country":"sct","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/currie.bradley\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Scotland","role":"bowl","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":118938,"title":"Bertie Foreman","short_name":"B Foreman","first_name":"Bertie Foreman","last_name":"","middle_name":"","birthdate":"2004-05-13","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":119916,"title":"Charlie Tear","short_name":"C Tear","first_name":"Charlie Tear","last_name":"","middle_name":"","birthdate":"2004-06-12","birthplace":"","country":"sct","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Scotland","role":"squad","role_str":""},{"pid":130437,"title":"Henry Rogers","short_name":"H Rogers","first_name":"Henry Rogers","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":"squad","role_str":""},{"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":""},{"pid":147226,"title":"Zach Lion Cachet","short_name":"Z Cachet","first_name":"Zach Lion Cachet","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"nl","primary_team":[],"logo_url":"","playing_role":"all","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":"Netherlands","role":"squad","role_str":""},{"pid":147628,"title":"Troy Henry","short_name":"T Henry","first_name":"Troy Henry","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":149075,"title":"Nantes Oosthuizen","short_name":"N Oosthuizen","first_name":"Nantes Oosthuizen","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":4,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":149076,"title":"Ollie Moore","short_name":"O Moore","first_name":"Ollie Moore","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":"1eaf23c9d917326a00818060a3b7207f","modified":"2025-07-28 19:33:07","datetime":"2025-07-28 19:33:07","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":86879,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Surrey won by 48 runs","day_remaining_over":"","team_batting":"Sussex","team_bowling":"Surrey","live_inning_number":2,"live_score":{"runs":162,"overs":19.5,"wickets":10,"target":211,"runrate":8.17,"required_runrate":294},"commentary":1,"wagon":2,"batsmen":[{"name":"Danny Lamb","batsman_id":50623,"runs":49,"balls_faced":34,"fours":5,"sixes":1,"strike_rate":"144.12"},{"name":"Bradley Currie","batsman_id":118322,"runs":3,"balls_faced":3,"fours":0,"sixes":0,"strike_rate":"100.00"}],"bowlers":[{"name":"Chris Jordan","bowler_id":454,"overs":3.5,"runs_conceded":35,"wickets":1,"maidens":0,"econ":"9.13"},{"name":"Reece Topley","bowler_id":1937,"overs":4,"runs_conceded":34,"wickets":3,"maidens":0,"econ":"8.50"}],"commentaries":[{"event_id":"12169484","event":"ball","batsman_id":"43634","bowler_id":"1923","over":"15","ball":"3","score":1,"commentary":"Mitchell Santner to Nathan McAndrew, 1 run,","noball_dismissal":false,"text":"","timestamp":1750277510,"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":"12169486","event":"ball","batsman_id":"50623","bowler_id":"1923","over":"15","ball":"4","score":4,"commentary":"Mitchell Santner to Danny Lamb, Four,","noball_dismissal":false,"text":"","timestamp":1750277545,"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":"12169488","event":"ball","batsman_id":"50623","bowler_id":"1923","over":"15","ball":"5","score":1,"commentary":"Mitchell Santner to Danny Lamb, 1 run,","noball_dismissal":false,"text":"","timestamp":1750277563,"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":"12169492","event":"ball","batsman_id":"43634","bowler_id":"1923","over":"15","ball":"6","score":1,"commentary":"Mitchell Santner to Nathan McAndrew, 1 run,","noball_dismissal":false,"text":"","timestamp":1750277604,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":16,"runs":7,"score":"134\/6","bats":[{"runs":2,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":43634},{"runs":34,"balls_faced":23,"fours":3,"sixes":1,"batsman_id":50623}],"bowls":[{"runs_conceded":26,"maidens":0,"wickets":3,"bowler_id":1923,"overs":4},{"runs_conceded":14,"maidens":0,"wickets":1,"bowler_id":43389,"overs":3}],"commentary":"End of over 16 (7 runs), Sussex 134\/6"},{"event_id":"12169496","event":"ball","batsman_id":"43634","bowler_id":"43389","over":"16","ball":"1","score":4,"commentary":"Tom Curran to Nathan McAndrew, Four,","noball_dismissal":false,"text":"","timestamp":1750277651,"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":"12169502","event":"ball","batsman_id":"43634","bowler_id":"43389","over":"16","ball":"2","score":2,"commentary":"Tom Curran to Nathan McAndrew, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750277711,"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":"12169509","event":"wicket","batsman_id":"43634","bowler_id":"43389","over":"16","ball":"3","score":"w","commentary":"Tom Curran to Nathan McAndrew, no run, c J Roy b TK Curran,","noball_dismissal":false,"text":"","timestamp":1750277734,"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":"43634","how_out":"c J Roy b TK Curran","batsman_runs":"8","batsman_balls":"6"},{"event_id":"12169512","event":"ball","batsman_id":"43366","bowler_id":"43389","over":"16","ball":"4","score":1,"commentary":"Tom Curran to Tymal Mills, 1 run,","noball_dismissal":false,"text":"","timestamp":1750277789,"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":"12169514","event":"ball","batsman_id":"50623","bowler_id":"43389","over":"16","ball":"5","score":2,"commentary":"Tom Curran to Danny Lamb, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750277815,"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":"12169516","event":"ball","batsman_id":"50623","bowler_id":"43389","over":"16","ball":"6","score":1,"commentary":"Tom Curran to Danny Lamb, 1 run,","noball_dismissal":false,"text":"","timestamp":1750277857,"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":10,"score":"144\/7","bats":[{"runs":37,"balls_faced":25,"fours":3,"sixes":1,"batsman_id":50623},{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":43366}],"bowls":[{"runs_conceded":24,"maidens":0,"wickets":2,"bowler_id":43389,"overs":4},{"runs_conceded":26,"maidens":0,"wickets":3,"bowler_id":1923,"overs":4}],"commentary":"End of over 17 (10 runs), Sussex 144\/7"},{"event_id":"12169518","event":"ball","batsman_id":"50623","bowler_id":"454","over":"17","ball":"1","score":0,"commentary":"Chris Jordan to Danny Lamb, no run,","noball_dismissal":false,"text":"","timestamp":1750277912,"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":"12169524","event":"ball","batsman_id":"50623","bowler_id":"454","over":"17","ball":"2","score":4,"commentary":"Chris Jordan to Danny Lamb, Four,","noball_dismissal":false,"text":"","timestamp":1750277939,"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":"12169531","event":"ball","batsman_id":"50623","bowler_id":"454","over":"17","ball":"3","score":1,"commentary":"Chris Jordan to Danny Lamb, 1 run,","noball_dismissal":false,"text":"","timestamp":1750277977,"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":"12169536","event":"ball","batsman_id":"43366","bowler_id":"454","over":"17","ball":"4","score":0,"commentary":"Chris Jordan to Tymal Mills, no run,","noball_dismissal":false,"text":"","timestamp":1750278019,"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":"12169538","event":"ball","batsman_id":"43366","bowler_id":"454","over":"17","ball":"5","score":2,"commentary":"Chris Jordan to Tymal Mills, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750278069,"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":"12169541","event":"ball","batsman_id":"43366","bowler_id":"454","over":"17","ball":"6","score":0,"commentary":"Chris Jordan to Tymal Mills, no run,","noball_dismissal":false,"text":"","timestamp":1750278107,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":18,"runs":7,"score":"151\/7","bats":[{"runs":3,"balls_faced":4,"fours":0,"sixes":0,"batsman_id":43366},{"runs":42,"balls_faced":28,"fours":4,"sixes":1,"batsman_id":50623}],"bowls":[{"runs_conceded":28,"maidens":0,"wickets":0,"bowler_id":454,"overs":3},{"runs_conceded":24,"maidens":0,"wickets":2,"bowler_id":43389,"overs":4}],"commentary":"End of over 18 (7 runs), Sussex 151\/7"},{"event_id":"12169548","event":"wicket","batsman_id":"50623","bowler_id":"1937","over":"18","ball":"1","score":"w","commentary":"Reece Topley to Danny Lamb, 1 run, runout (LJ Evans \/ S Curran),","noball_dismissal":false,"text":"","timestamp":1750278270,"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,"wicket_batsman_id":"43366","how_out":"runout (LJ Evans \/ S Curran)","batsman_runs":"3","batsman_balls":"4"},{"event_id":"12169560","event":"ball","batsman_id":"101482","bowler_id":"1937","over":"18","ball":"2","score":1,"commentary":"Reece Topley to Henry Thomas Crocombe, 1 run,","noball_dismissal":false,"text":"","timestamp":1750278294,"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":"12169561","event":"ball","batsman_id":"50623","bowler_id":"1937","over":"18","ball":"3","score":1,"commentary":"Reece Topley to Danny Lamb, 1 run,","noball_dismissal":false,"text":"","timestamp":1750278299,"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":"12169562","event":"wicket","batsman_id":"101482","bowler_id":"1937","over":"18","ball":"4","score":"w","commentary":"Reece Topley to Henry Thomas Crocombe, no run, b R Topley,","noball_dismissal":false,"text":"","timestamp":1750278331,"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":"101482","how_out":"b R Topley","batsman_runs":"1","batsman_balls":"2"},{"event_id":"12169565","event":"ball","batsman_id":"118322","bowler_id":"1937","over":"18","ball":"5","score":1,"commentary":"Reece Topley to Bradley Currie, 1 run,","noball_dismissal":false,"text":"","timestamp":1750278391,"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":"12169567","event":"ball","batsman_id":"50623","bowler_id":"1937","over":"18","ball":"6","score":0,"commentary":"Reece Topley to Danny Lamb, no run,","noball_dismissal":false,"text":"","timestamp":1750278437,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":19,"runs":4,"score":"155\/9","bats":[{"runs":44,"balls_faced":31,"fours":4,"sixes":1,"batsman_id":50623},{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":118322}],"bowls":[{"runs_conceded":34,"maidens":0,"wickets":3,"bowler_id":1937,"overs":4},{"runs_conceded":28,"maidens":0,"wickets":0,"bowler_id":454,"overs":3}],"commentary":"End of over 19 (4 runs), Sussex 155\/9"},{"event_id":"12169572","event":"ball","batsman_id":"118322","bowler_id":"454","over":"19","ball":"1","score":1,"commentary":"Chris Jordan to Bradley Currie, 1 run,","noball_dismissal":false,"text":"","timestamp":1750278502,"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":"12169575","event":"ball","batsman_id":"50623","bowler_id":"454","over":"19","ball":"2","score":1,"commentary":"Chris Jordan to Danny Lamb, 1 run,","noball_dismissal":false,"text":"","timestamp":1750278567,"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":"12169576","event":"ball","batsman_id":"118322","bowler_id":"454","over":"19","ball":"3","score":1,"commentary":"Chris Jordan to Bradley Currie, 1 run,","noball_dismissal":false,"text":"","timestamp":1750278597,"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":"12169578","event":"ball","batsman_id":"50623","bowler_id":"454","over":"19","ball":"4","score":4,"commentary":"Chris Jordan to Danny Lamb, Four,","noball_dismissal":false,"text":"","timestamp":1750278630,"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":"12169579","event":"wicket","batsman_id":"50623","bowler_id":"454","over":"19","ball":"5","score":"w","commentary":"Chris Jordan to Danny Lamb, no run, b C Jordan,","noball_dismissal":false,"text":"","timestamp":1750278689,"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":"50623","how_out":"b C Jordan","batsman_runs":"49","batsman_balls":"34"}],"day":"0","session":"0","live_inning":{"iid":198336,"number":2,"name":"Sussex Inning","short_name":"SUS Inning","status":2,"issuperover":"false","result":1,"batting_team_id":5721,"fielding_team_id":6995,"scores":"162\/10","scores_full":"162\/10 (19.5 ov)","fielder":[{"fielder_id":"51319","fielder_name":"Will Jacks","catches":2,"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":"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":0,"runout_thrower":1,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"49029","fielder_name":"Laurie Evans","catches":0,"runout_thrower":0,"runout_catcher":1,"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":"Danny Lamb","batsman_id":"50623","runs":"49","balls":"34","how_out":"b C Jordan","score_at_dismissal":162,"overs_at_dismissal":"19.5","bowler_id":"454","dismissal":"bowled","number":10},"extra_runs":{"byes":4,"legbyes":1,"wides":3,"noballs":0,"penalty":"0","total":8},"equations":{"runs":162,"wickets":10,"overs":"19.5","bowlers_used":6,"runrate":"8.17"},"current_partnership":{"runs":8,"balls":7,"overs":1.1,"batsmen":[{"name":"Bradley Currie","batsman_id":118322,"runs":3,"balls":3},{"name":"Danny Lamb","batsman_id":50623,"runs":5,"balls":4}]},"did_not_bat":[],"max_over":"20","target":"211","recent_scores":"w,4,1,1,1,0,1,w,1,1,w,0,2,0,1,4,0,1","last_five_overs":"36\/5 7.20","last_ten_overs":"80\/6 7.87"},"teams":[{"tid":5721,"title":"Sussex","abbr":"SUS","alt_name":"SUS","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/sussex-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/sussex-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"162\/10 (19.5 ov)","scores":"162\/10","overs":"19.5"},{"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":"210\/6 (20 ov)","scores":"210\/6","overs":"20"}],"players":[{"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":682,"title":"Jaydev Unadkat","short_name":"J Unadkat","first_name":"Jaydev Unadkat","last_name":"","middle_name":"","birthdate":"1991-10-18","birthplace":"Porbandar","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/JUnadkat","instagram_profile":"https:\/\/www.instagram.com\/jd_unadkat\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","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":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":43366,"title":"Tymal Mills","short_name":"TS Mills","first_name":"Tymal Mills","last_name":"","middle_name":"","birthdate":"1992-08-12","birthplace":"Dewsbury, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/tmills15\/","twitter_profile":"https:\/\/twitter.com\/tmills15","instagram_profile":"https:\/\/www.instagram.com\/tymalmills\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":"(C)"},{"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":43634,"title":"Nathan McAndrew","short_name":"NJ McAndrew","first_name":"Nathan McAndrew","last_name":"","middle_name":"","birthdate":"1993-07-14","birthplace":"Wollongong, NSW","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/nmcandrew44","instagram_profile":"https:\/\/www.instagram.com\/nathan_mcandrew\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"all","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":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":49495,"title":"John Simpson","short_name":"JA Simpson","first_name":"John Simpson","last_name":"","middle_name":"","birthdate":"1988-07-13","birthplace":"Bury, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/JohnAndrewSimpson\/","twitter_profile":"https:\/\/twitter.com\/JohnSimpson_88","instagram_profile":"https:\/\/www.instagram.com\/johnsimpson_88\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"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":50623,"title":"Danny Lamb","short_name":"DJ Lamb","first_name":"Danny Lamb","last_name":"","middle_name":"","birthdate":"1995-09-07","birthplace":"Preston, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lamby236","instagram_profile":"https:\/\/www.instagram.com\/dannylamb190\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","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":50846,"title":"Tom Alsop","short_name":"TP Alsop","first_name":"Tom Alsop","last_name":"","middle_name":"","birthdate":"1995-11-26","birthplace":"High Wycombe, Buckinghamshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"Wicketkeeper Batter","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/tomalsop1","instagram_profile":"https:\/\/www.instagram.com\/tom.alsop\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51091,"title":"Harrison Ward","short_name":"HD Ward","first_name":"Harrison Ward","last_name":"","middle_name":"","birthdate":"1999-10-25","birthplace":"Oxford","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/delraw09","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51271,"title":"Tom Haines","short_name":"TJ Haines","first_name":"Tom Haines","last_name":"","middle_name":"","birthdate":"1998-10-28","birthplace":"","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":51308,"title":"Ollie Robinson","short_name":"OE Robinson","first_name":"Ollie Robinson","last_name":"","middle_name":"","birthdate":"1993-12-01","birthplace":"Margate, Kent","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,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/OllieRobinson7","instagram_profile":"https:\/\/www.instagram.com\/ollierobinson25\/","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":90598,"title":"Daniel Hughes","short_name":"DPHughes","first_name":"Daniel Hughes","last_name":"","middle_name":"","birthdate":"1989-02-16","birthplace":" Cowra","country":"au","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":"https:\/\/twitter.com\/Hughesy1989","instagram_profile":"https:\/\/www.instagram.com\/danielhughes16\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"bat","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":95551,"title":"Tom Clark","short_name":"T Clark","first_name":"Tom Clark","last_name":"","middle_name":"","birthdate":"2001-07-02","birthplace":"Geoffrey Reeves","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":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/tomclark2702","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":96398,"title":"Jayden Seales","short_name":"J Seales","first_name":"Jayden Seales","last_name":"","middle_name":"","birthdate":"2001-09-10","birthplace":"Trinidad & Tobago","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/jayden_seales","instagram_profile":"https:\/\/www.instagram.com\/jay_seales\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":101481,"title":"Jack Joshua Carson","short_name":"J J Carson","first_name":"Jack Joshua Carson","last_name":"","middle_name":"","birthdate":"2000-12-03","birthplace":"Craigavon, Co Armagh, Ireland","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/_jackcarson11","instagram_profile":"https:\/\/www.instagram.com\/_jackcarson\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":101482,"title":"Henry Thomas Crocombe","short_name":"H T Crocombe","first_name":"Henry Thomas Crocombe","last_name":"","middle_name":"","birthdate":"2001-09-20","birthplace":"Eastbourne, United Kingdom","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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/henrycrocombe\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":102957,"title":"James Coles","short_name":"J Coles","first_name":"James Coles","last_name":"","middle_name":"","birthdate":"2004-04-04","birthplace":"Aylesbury, Buckinghamshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":107332,"title":"Sean Hunt","short_name":"S Hunt","first_name":"Sean Hunt","last_name":"","middle_name":"","birthdate":"2001-12-07","birthplace":" Guildford, Surrey","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":108396,"title":"Danial Ibrahim","short_name":"D Ibrahim","first_name":"Danial Ibrahim","last_name":"","middle_name":"","birthdate":"2004-08-09","birthplace":"Burnley, Lancashire, England","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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/danialibrahim\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108398,"title":"Oliver Carter","short_name":"O Carter","first_name":"Oliver Carter","last_name":"","middle_name":"","birthdate":"2001-11-02","birthplace":"Eastbourne, Sussex, England","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108400,"title":"Archie Lenham","short_name":"A Lenham","first_name":"Archie Lenham","last_name":"","middle_name":"","birthdate":"2004-07-23","birthplace":"Eastbourne, Sussex","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":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":109542,"title":"George Thomas II","short_name":"G Thomas II","first_name":"George Thomas II","last_name":"","middle_name":"","birthdate":"2003-11-14","birthplace":"Taunton, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","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":114207,"title":"Ari Karvelas","short_name":"A Karvelas","first_name":"Ari Karvelas","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","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":"International","role":"squad","role_str":""},{"pid":118322,"title":"Bradley Currie","short_name":"BJ Currie","first_name":"Bradley Currie","last_name":"","middle_name":"","birthdate":"1998-11-08","birthplace":"Poole, United Kingdom","country":"sct","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/currie.bradley\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Scotland","role":"bowl","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":118938,"title":"Bertie Foreman","short_name":"B Foreman","first_name":"Bertie Foreman","last_name":"","middle_name":"","birthdate":"2004-05-13","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":119916,"title":"Charlie Tear","short_name":"C Tear","first_name":"Charlie Tear","last_name":"","middle_name":"","birthdate":"2004-06-12","birthplace":"","country":"sct","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Scotland","role":"squad","role_str":""},{"pid":130437,"title":"Henry Rogers","short_name":"H Rogers","first_name":"Henry Rogers","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":"squad","role_str":""},{"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":""},{"pid":147226,"title":"Zach Lion Cachet","short_name":"Z Cachet","first_name":"Zach Lion Cachet","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"nl","primary_team":[],"logo_url":"","playing_role":"all","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":"Netherlands","role":"squad","role_str":""},{"pid":147628,"title":"Troy Henry","short_name":"T Henry","first_name":"Troy Henry","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":149075,"title":"Nantes Oosthuizen","short_name":"N Oosthuizen","first_name":"Nantes Oosthuizen","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":4,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":149076,"title":"Ollie Moore","short_name":"O Moore","first_name":"Ollie Moore","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":"1eaf23c9d917326a00818060a3b7207f","modified":"2025-07-28 19:33:07","datetime":"2025-07-28 19:33:07","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86879 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:d5056115-e1a5-41a6-b2d2-7cd014e56e4a
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86879 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86879,3,'{"status":"ok","response":{"match_id":86879,"title":"Surrey vs Sussex","short_title":"SUR vs SUS","subtitle":"Match 59","match_number":"59","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Surrey won by 48 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":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":"210\/6 (20 ov)","scores":"210\/6","overs":"20"},"teamb":{"team_id":5721,"name":"Sussex","short_name":"SUS","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/sussex-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/sussex-logo.png","scores_full":"162\/10 (19.5 ov)","scores":"162\/10","overs":"19.5"},"date_start":"2025-06-18 17:30:00","date_end":"2025-06-19 03:30:00","timestamp_start":1750267800,"timestamp_end":1750303800,"date_start_ist":"2025-06-18 23:00:00","date_end_ist":"2025-06-19 09:00:00","venue":{"venue_id":"3","name":"Kennington Oval","location":"London","country":"England","timezone":""},"umpires":"Benjamin Debenham (England), Paul Pollard (England)","referee":"James Whitaker (England)","equation":"","live":"","result":"SUR won by 48 runs","result_type":1,"win_margin":"48 runs","winning_team_id":6995,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-15 22:08:30","verify_time":"2025-06-19 02:11:05","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"few clouds","temp":21.19,"humidity":64,"visibility":10000,"wind_speed":"2.73","clouds":11},"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Sussex elected to bowl","winner":5721,"decision":2}},"etag":"01bb312dff34487a531060489309a375","modified":"2025-07-28 19:33:08","datetime":"2025-07-28 19:33:08","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":86879,"title":"Surrey vs Sussex","short_title":"SUR vs SUS","subtitle":"Match 59","match_number":"59","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Surrey won by 48 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":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":"210\/6 (20 ov)","scores":"210\/6","overs":"20"},"teamb":{"team_id":5721,"name":"Sussex","short_name":"SUS","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/sussex-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/sussex-logo.png","scores_full":"162\/10 (19.5 ov)","scores":"162\/10","overs":"19.5"},"date_start":"2025-06-18 17:30:00","date_end":"2025-06-19 03:30:00","timestamp_start":1750267800,"timestamp_end":1750303800,"date_start_ist":"2025-06-18 23:00:00","date_end_ist":"2025-06-19 09:00:00","venue":{"venue_id":"3","name":"Kennington Oval","location":"London","country":"England","timezone":""},"umpires":"Benjamin Debenham (England), Paul Pollard (England)","referee":"James Whitaker (England)","equation":"","live":"","result":"SUR won by 48 runs","result_type":1,"win_margin":"48 runs","winning_team_id":6995,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-15 22:08:30","verify_time":"2025-06-19 02:11:05","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"few clouds","temp":21.19,"humidity":64,"visibility":10000,"wind_speed":"2.73","clouds":11},"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Sussex elected to bowl","winner":5721,"decision":2}},"etag":"01bb312dff34487a531060489309a375","modified":"2025-07-28 19:33:08","datetime":"2025-07-28 19:33:08","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86879 AND DataTypeId = 3 END Live Report & Scorecard of Surrey vs Sussex Match 59
