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:84c2ca59-4360-4207-bb1a-9c7adda71e78
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 88139 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (88139,1,'{"status":"ok","response":{"mid":88139,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Match Drawn","day_remaining_over":"26","team_batting":"Warwickshire","team_bowling":"Sussex","live_inning_number":3,"live_score":{"runs":260,"overs":88,"wickets":4,"target":0,"runrate":2.95,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Ed Barnard","batsman_id":49041,"runs":9,"balls_faced":17,"fours":1,"sixes":0,"strike_rate":"52.94"},{"name":"Sam Hain","batsman_id":49025,"runs":53,"balls_faced":170,"fours":0,"sixes":0,"strike_rate":"31.18"}],"bowlers":[{"name":"Fynn Hudson-Prentice","bowler_id":50663,"overs":2,"runs_conceded":5,"wickets":0,"maidens":1,"econ":"2.50"},{"name":"Daniel Hughes","bowler_id":90598,"overs":1,"runs_conceded":1,"wickets":0,"maidens":0,"econ":"1.00"}],"commentaries":[{"event_id":"12274856","event":"ball","batsman_id":"49041","bowler_id":"108396","over":"83","ball":"6","score":0,"commentary":"Danial Ibrahim to Ed Barnard, no run,","noball_dismissal":false,"text":"","timestamp":1751477529,"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":84,"runs":3,"score":"247\/4","bats":[{"runs":2,"balls_faced":8,"fours":0,"sixes":0,"batsman_id":49041},{"runs":49,"balls_faced":154,"fours":0,"sixes":0,"batsman_id":49025}],"bowls":[{"runs_conceded":19,"maidens":0,"wickets":0,"bowler_id":108396,"overs":4},{"runs_conceded":81,"maidens":7,"wickets":1,"bowler_id":101481,"overs":33}],"commentary":"End of over 84 (3 runs), Warwickshire 247\/4"},{"event_id":"12274860","event":"ball","batsman_id":"49025","bowler_id":"50663","over":"84","ball":"1","score":1,"commentary":"Fynn Hudson-Prentice to Sam Hain, 1 run,","noball_dismissal":false,"text":"","timestamp":1751477532,"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":"12274861","event":"ball","batsman_id":"49041","bowler_id":"50663","over":"84","ball":"2","score":0,"commentary":"Fynn Hudson-Prentice to Ed Barnard, no run,","noball_dismissal":false,"text":"","timestamp":1751477536,"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":"12274863","event":"ball","batsman_id":"49041","bowler_id":"50663","over":"84","ball":"3","score":4,"commentary":"Fynn Hudson-Prentice to Ed Barnard, Four,","noball_dismissal":false,"text":"","timestamp":1751477540,"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":"12274864","event":"ball","batsman_id":"49041","bowler_id":"50663","over":"84","ball":"4","score":0,"commentary":"Fynn Hudson-Prentice to Ed Barnard, no run,","noball_dismissal":false,"text":"","timestamp":1751477543,"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":"12274865","event":"ball","batsman_id":"49041","bowler_id":"50663","over":"84","ball":"5","score":0,"commentary":"Fynn Hudson-Prentice to Ed Barnard, no run,","noball_dismissal":false,"text":"","timestamp":1751477547,"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":"12274867","event":"ball","batsman_id":"49041","bowler_id":"50663","over":"84","ball":"6","score":0,"commentary":"Fynn Hudson-Prentice to Ed Barnard, no run,","noball_dismissal":false,"text":"","timestamp":1751477550,"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":85,"runs":5,"score":"252\/4","bats":[{"runs":6,"balls_faced":13,"fours":1,"sixes":0,"batsman_id":49041},{"runs":50,"balls_faced":155,"fours":0,"sixes":0,"batsman_id":49025}],"bowls":[{"runs_conceded":5,"maidens":0,"wickets":0,"bowler_id":50663,"overs":1},{"runs_conceded":19,"maidens":0,"wickets":0,"bowler_id":108396,"overs":4}],"commentary":"End of over 85 (5 runs), Warwickshire 252\/4"},{"event_id":"12274873","event":"ball","batsman_id":"49025","bowler_id":"108396","over":"85","ball":"1","score":0,"commentary":"Danial Ibrahim to Sam Hain, no run,","noball_dismissal":false,"text":"","timestamp":1751477554,"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":"12274894","event":"ball","batsman_id":"49025","bowler_id":"108396","over":"85","ball":"2","score":0,"commentary":"Danial Ibrahim to Sam Hain, no run,","noball_dismissal":false,"text":"","timestamp":1751477557,"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":"12274897","event":"ball","batsman_id":"49025","bowler_id":"108396","over":"85","ball":"3","score":1,"commentary":"Danial Ibrahim to Sam Hain, 1 run,","noball_dismissal":false,"text":"","timestamp":1751477561,"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":"12274899","event":"ball","batsman_id":"49041","bowler_id":"108396","over":"85","ball":"4","score":0,"commentary":"Danial Ibrahim to Ed Barnard, no run,","noball_dismissal":false,"text":"","timestamp":1751477564,"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":"12274902","event":"ball","batsman_id":"49041","bowler_id":"108396","over":"85","ball":"5","score":3,"commentary":"Danial Ibrahim to Ed Barnard, 3 runs,","noball_dismissal":false,"text":"","timestamp":1751477567,"run":3,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"3","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12274908","event":"ball","batsman_id":"49025","bowler_id":"108396","over":"85","ball":"6","score":"3nb","commentary":"Danial Ibrahim to Sam Hain, 3 no ball,","noball_dismissal":false,"text":"","timestamp":1751477571,"run":3,"noball_run":"1","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":true,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12274912","event":"ball","batsman_id":"49041","bowler_id":"108396","over":"85","ball":"6","score":0,"commentary":"Danial Ibrahim to Ed Barnard, no run,","noball_dismissal":false,"text":"","timestamp":1751477575,"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":86,"runs":7,"score":"259\/4","bats":[{"runs":9,"balls_faced":16,"fours":1,"sixes":0,"batsman_id":49041},{"runs":52,"balls_faced":159,"fours":0,"sixes":0,"batsman_id":49025}],"bowls":[{"runs_conceded":25,"maidens":0,"wickets":0,"bowler_id":108396,"overs":5},{"runs_conceded":5,"maidens":0,"wickets":0,"bowler_id":50663,"overs":1}],"commentary":"End of over 86 (7 runs), Warwickshire 259\/4"},{"event_id":"12274916","event":"ball","batsman_id":"49025","bowler_id":"90598","over":"86","ball":"1","score":0,"commentary":"Daniel Hughes to Sam Hain, no run,","noball_dismissal":false,"text":"","timestamp":1751477580,"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":"12274917","event":"ball","batsman_id":"49025","bowler_id":"90598","over":"86","ball":"2","score":0,"commentary":"Daniel Hughes to Sam Hain, no run,","noball_dismissal":false,"text":"","timestamp":1751477584,"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":"12274918","event":"ball","batsman_id":"49025","bowler_id":"90598","over":"86","ball":"3","score":0,"commentary":"Daniel Hughes to Sam Hain, no run,","noball_dismissal":false,"text":"","timestamp":1751477588,"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":"12274920","event":"ball","batsman_id":"49025","bowler_id":"90598","over":"86","ball":"4","score":0,"commentary":"Daniel Hughes to Sam Hain, no run,","noball_dismissal":false,"text":"","timestamp":1751477591,"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":"12274922","event":"ball","batsman_id":"49025","bowler_id":"90598","over":"86","ball":"5","score":1,"commentary":"Daniel Hughes to Sam Hain, 1 run,","noball_dismissal":false,"text":"","timestamp":1751477594,"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":"12274923","event":"ball","batsman_id":"49041","bowler_id":"90598","over":"86","ball":"6","score":0,"commentary":"Daniel Hughes to Ed Barnard, no run,","noball_dismissal":false,"text":"","timestamp":1751477597,"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":87,"runs":1,"score":"260\/4","bats":[{"runs":9,"balls_faced":17,"fours":1,"sixes":0,"batsman_id":49041},{"runs":53,"balls_faced":164,"fours":0,"sixes":0,"batsman_id":49025}],"bowls":[{"runs_conceded":1,"maidens":0,"wickets":0,"bowler_id":90598,"overs":1},{"runs_conceded":25,"maidens":0,"wickets":0,"bowler_id":108396,"overs":5}],"commentary":"End of over 87 (1 runs), Warwickshire 260\/4"},{"event_id":"12274926","event":"ball","batsman_id":"49025","bowler_id":"50663","over":"87","ball":"1","score":0,"commentary":"Fynn Hudson-Prentice to Sam Hain, no run,","noball_dismissal":false,"text":"","timestamp":1751477601,"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":"12274927","event":"ball","batsman_id":"49025","bowler_id":"50663","over":"87","ball":"2","score":0,"commentary":"Fynn Hudson-Prentice to Sam Hain, no run,","noball_dismissal":false,"text":"","timestamp":1751477605,"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":"12274928","event":"ball","batsman_id":"49025","bowler_id":"50663","over":"87","ball":"3","score":0,"commentary":"Fynn Hudson-Prentice to Sam Hain, no run,","noball_dismissal":false,"text":"","timestamp":1751477608,"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":"12274929","event":"ball","batsman_id":"49025","bowler_id":"50663","over":"87","ball":"4","score":0,"commentary":"Fynn Hudson-Prentice to Sam Hain, no run,","noball_dismissal":false,"text":"","timestamp":1751477613,"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":"12274930","event":"ball","batsman_id":"49025","bowler_id":"50663","over":"87","ball":"5","score":0,"commentary":"Fynn Hudson-Prentice to Sam Hain, no run,","noball_dismissal":false,"text":"","timestamp":1751477617,"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":"12274932","event":"ball","batsman_id":"49025","bowler_id":"50663","over":"87","ball":"6","score":0,"commentary":"Fynn Hudson-Prentice to Sam Hain, no run,","noball_dismissal":false,"text":"","timestamp":1751477621,"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":88,"runs":0,"score":"260\/4","bats":[{"runs":53,"balls_faced":170,"fours":0,"sixes":0,"batsman_id":49025},{"runs":9,"balls_faced":17,"fours":1,"sixes":0,"batsman_id":49041}],"bowls":[{"runs_conceded":5,"maidens":1,"wickets":0,"bowler_id":50663,"overs":2},{"runs_conceded":1,"maidens":0,"wickets":0,"bowler_id":90598,"overs":1}],"commentary":"End of over 88 (0 runs), Warwickshire 260\/4"}],"day":"4","session":"0","live_inning":{"iid":198995,"number":3,"name":"Warwickshire 2nd Inning","short_name":"WAS 2nd Inning","status":2,"issuperover":"false","result":4,"batting_team_id":7002,"fielding_team_id":5721,"scores":"260\/4","scores_full":"260\/4 (88 ov)","fielder":[{"fielder_id":"51271","fielder_name":"Tom Haines","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"108396","fielder_name":"Danial Ibrahim","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"102957","fielder_name":"James Coles","catches":0,"runout_thrower":0,"runout_catcher":1,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"50663","fielder_name":"Fynn Hudson-Prentice","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":[],"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":"Zen Malik","batsman_id":"88689","runs":"44","balls":"80","how_out":"c FJ Hudson-Prentice b J J Carson","score_at_dismissal":240,"overs_at_dismissal":"80.6","bowler_id":"101481","dismissal":"caught","number":4},"extra_runs":{"byes":0,"legbyes":4,"wides":0,"noballs":12,"penalty":"0","total":16},"equations":{"runs":260,"wickets":4,"overs":"88","bowlers_used":9,"runrate":"2.95"},"current_partnership":{"runs":20,"balls":43,"overs":7.1,"batsmen":[{"name":"Sam Hain","batsman_id":49025,"runs":9,"balls":26},{"name":"Ed Barnard","batsman_id":49041,"runs":9,"balls":17}]},"did_not_bat":[{"player_id":"94952","name":"Kai Smith"},{"player_id":"93516","name":"Ethan Bamber"},{"player_id":"49017","name":"Oliver Hannon-Dalby"},{"player_id":"49320","name":"Chris Rushworth"},{"player_id":"103483","name":"Corey Rocchiccioli"}],"max_over":"0","target":"0","recent_scores":"0,0,0,0,0,0,0,1,0,0,0,0,0,3,3,0,1,0","last_five_overs":"16\/0 3.10","last_ten_overs":"34\/1 3.34"},"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":"533\/10 (151.4 ov)","scores":"533\/10","overs":"151.4"},{"tid":7002,"title":"Warwickshire","abbr":"WAS","alt_name":"Warwickshire","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Warwickshire.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Warwickshire.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"415\/10 (107.5 ov) & 260\/4 (88 ov)","scores":"415\/10 & 260\/4","overs":"107.5 & 88"}],"players":[{"pid":77,"title":"Steven Smith","short_name":"S Smith","first_name":"Steven Smith","last_name":"","middle_name":"","birthdate":"1989-06-02","birthplace":"Sydney, New South Wales","country":"au","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":9,"facebook_profile":"https:\/\/www.facebook.com\/SteveSmith\/","twitter_profile":"https:\/\/twitter.com\/stevesmith49","instagram_profile":"https:\/\/www.instagram.com\/steve_smith49\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":107,"title":"Chris Woakes","short_name":"C Woakes","first_name":"Chris Woakes","last_name":"","middle_name":"","birthdate":"1989-03-02","birthplace":"Birmingham, Warwickshire","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":8,"facebook_profile":"https:\/\/www.facebook.com\/chriswoakes\/","twitter_profile":"https:\/\/twitter.com\/chriswoakes","instagram_profile":"https:\/\/www.instagram.com\/chriswoakes\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":820,"title":"Gurinder Sandhu","short_name":"GS Sandhu","first_name":"Gurinder Sandhu","last_name":"","middle_name":"","birthdate":"1993-06-14","birthplace":"Blacktown, New South Wales","country":"au","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,"facebook_profile":"https:\/\/www.facebook.com\/Gsandhu206\/","twitter_profile":"https:\/\/twitter.com\/gurinder_19","instagram_profile":"https:\/\/www.instagram.com\/gurinder_19\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"bowl","role_str":""},{"pid":1384,"title":"George Garton","short_name":"G Garton","first_name":"George Garton","last_name":"","middle_name":"","birthdate":"1997-04-15","birthplace":"Brighton, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/george_garton","instagram_profile":"https:\/\/www.instagram.com\/georgegarton\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":43985,"title":"Vishwa Fernando","short_name":"V Fernando","first_name":"Vishwa Fernando","last_name":"","middle_name":"","birthdate":"1991-09-18","birthplace":"Colombo","country":"lk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":37263,"recent_appearance":1513776600,"fantasy_player_rating":7,"facebook_profile":"https:\/\/www.facebook.com\/VishwaFernandoSLC\/","twitter_profile":"https:\/\/twitter.com\/vrnfernando1","instagram_profile":"https:\/\/www.instagram.com\/vishwa_fernando68\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Sri Lanka","role":"squad","role_str":""},{"pid":44099,"title":"Hasan Ali","short_name":"H Ali","first_name":"Hasan Ali","last_name":"","middle_name":"","birthdate":"1994-07-02","birthplace":"Gujranwala, Punjab","country":"pk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/Realhassan32\/","twitter_profile":"https:\/\/twitter.com\/RealHa55an","instagram_profile":"https:\/\/www.instagram.com\/ha55an_ali\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"squad","role_str":""},{"pid":44185,"title":"Tom Latham","short_name":"T Latham","first_name":"Tom Latham","last_name":"","middle_name":"","birthdate":"1992-04-02","birthplace":"Christchurch, Canterbury","country":"nz","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"wicket keeper","recent_match":23991,"recent_appearance":1513980000,"fantasy_player_rating":7,"facebook_profile":"https:\/\/www.facebook.com\/tomlathamofficial","twitter_profile":"https:\/\/twitter.com\/Tomlatham2","instagram_profile":"https:\/\/www.instagram.com\/tomlatham2\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"wk","role_str":""},{"pid":48430,"title":"Alex Davies","short_name":"AL Davies","first_name":"Alex Davies","last_name":"","middle_name":"","birthdate":"1994-08-23","birthplace":"Darwen, Lancashire","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":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/aldavies23\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(C)"},{"pid":49017,"title":"Oliver Hannon-Dalby","short_name":"OJ Hannon-Dalby","first_name":"Oliver Hannon-Dalby","last_name":"","middle_name":"","birthdate":"1989-06-20","birthplace":" Halifax, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":49025,"title":"Sam Hain","short_name":"SR Hain","first_name":"Sam Hain","last_name":"","middle_name":"","birthdate":"1995-07-16","birthplace":"Hong Kong","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":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/SammieHain","instagram_profile":"https:\/\/www.instagram.com\/sammiehain","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":49041,"title":"Ed Barnard","short_name":"EG Barnard","first_name":"Ed Barnard","last_name":"","middle_name":"","birthdate":"1995-11-20","birthplace":"","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":49091,"title":"Cheteshwar Pujara","short_name":"CA Pujara","first_name":"Cheteshwar Pujara","last_name":"","middle_name":"","birthdate":"1988-01-25","birthplace":"Rajkot","country":"in","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":9,"facebook_profile":"https:\/\/www.facebook.com\/OfficialCheteshwarPujara\/","twitter_profile":"https:\/\/twitter.com\/i\/flow\/login?redirect_after_login=%2Fcheteshwar1","instagram_profile":"https:\/\/www.instagram.com\/cheteshwar_pujara\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":49320,"title":"Chris Rushworth","short_name":"C Rushworth","first_name":"Chris Rushworth","last_name":"","middle_name":"","birthdate":"1986-07-11","birthplace":"Sunderland","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":49480,"title":"Danny Briggs","short_name":"DR Briggs","first_name":"Danny Briggs","last_name":"","middle_name":"","birthdate":"1991-04-30","birthplace":" Newport, Isle of Wight","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/DannyBriggs_14","instagram_profile":"https:\/\/www.instagram.com\/dannybriggs14\/","debut_data":"","bowling_type":"Spin","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK\/C)"},{"pid":49530,"title":"Craig Miles","short_name":"CN Miles","first_name":"Craig Miles","last_name":"","middle_name":"","birthdate":"1994-07-20","birthplace":"Swindon, Wiltshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/CMiles_18","instagram_profile":"https:\/\/www.instagram.com\/cmiles18\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50663,"title":"Fynn Hudson-Prentice","short_name":"FJ Hudson-Prentice","first_name":"Fynn Hudson-Prentice","last_name":"","middle_name":"","birthdate":"1996-01-12","birthplace":"Haywards Heath, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/fynnhudson33","instagram_profile":"https:\/\/www.instagram.com\/fynnhudson33\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","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":"","bowling_type":"","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":53626,"title":"Beau Webster","short_name":"BJ Webster","first_name":"Beau Webster","last_name":"","middle_name":"","birthdate":"1993-12-01","birthplace":"Snug, Hobart, Tasmania","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":88689,"title":"Zen Malik","short_name":"Z Malik","first_name":"Zen Malik","last_name":"","middle_name":"","birthdate":"1998-04-09","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"bat","role_str":""},{"pid":93516,"title":"Ethan Bamber","short_name":"ER Bamber","first_name":"Ethan Bamber","last_name":"","middle_name":"","birthdate":"1998-12-17","birthplace":"Westminster, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/etbamber","instagram_profile":"https:\/\/www.instagram.com\/etbamber\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":94952,"title":"Kai Smith","short_name":"K Smith","first_name":"Kai Smith","last_name":"","middle_name":"","birthdate":"2004-11-28","birthplace":" Dubai, United Arab Emirates","country":"ae","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"bat","role_str":"(WK)"},{"pid":95003,"title":"Robert Yates","short_name":"RM Yates","first_name":"Robert Yates","last_name":"","middle_name":"","birthdate":"1999-09-19","birthplace":"Solihull, Warwickshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":95543,"title":"Dan Mousley","short_name":"D Mousley","first_name":"Dan Mousley","last_name":"","middle_name":"","birthdate":"2001-07-08","birthplace":"Birmingham, Warwickshire","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.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/danmousley80","instagram_profile":"https:\/\/www.instagram.com\/danmousley80\/","debut_data":"","bowling_type":"Spin","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":"","bowling_type":"Pace","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":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/jayden_seales","instagram_profile":"https:\/\/www.instagram.com\/jay_seales\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":97581,"title":"Aristides Karvelas","short_name":"A Karvelas","first_name":"Aristides Karvelas","last_name":"","middle_name":"","birthdate":"1994-03-20","birthplace":"Johannesburg, Gauteng","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/ari_karvelas\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","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":"","bowling_type":"Spin","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":102808,"title":"Jake Lintott","short_name":"J Lintott","first_name":"Jake Lintott","last_name":"","middle_name":"","birthdate":"1993-04-22","birthplace":"Taunton, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Wrist Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lintott23","instagram_profile":"https:\/\/www.instagram.com\/lintott23\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":103483,"title":"Corey Rocchiccioli","short_name":"C Rocchiccioli","first_name":"Corey Rocchiccioli","last_name":"","middle_name":"","birthdate":"1997-10-08","birthplace":"Subiaco, Perth, Western Australia","country":"au","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/_rockets23","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Australia","role":"bowl","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108389,"title":"Che Simmons","short_name":"C Simmons","first_name":"Che Simmons","last_name":"","middle_name":"","birthdate":"2003-12-18","birthplace":"Birmingham, England","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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":109051,"title":"Ali Orr","short_name":"AGH Orr","first_name":"Ali Orr","last_name":"","middle_name":"","birthdate":"2001-04-06","birthplace":"Eastbourne, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/alastairorr\/","debut_data":"","bowling_type":"Pace","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":109583,"title":"Hamza Shaikh","short_name":"H Shaikh","first_name":"Hamza Shaikh","last_name":"","middle_name":"","birthdate":"2006-05-29","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":110620,"title":"Michael Booth","short_name":"MG Booth","first_name":"Michael Booth","last_name":"","middle_name":"","birthdate":"2001-02-12","birthplace":" Harare","country":"za","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":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Scotland","role":"squad","role_str":""},{"pid":134957,"title":"Tazeem Chaudry Ali","short_name":"TC Ali","first_name":"Tazeem Chaudry Ali","last_name":"","middle_name":"","birthdate":"2006-06-13","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":147627,"title":"Nantes Thomas","short_name":"N Thomas","first_name":"Nantes Thomas","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""}]},"etag":"eb6faee0233e037647be72bc6b3fe4e9","modified":"2025-07-16 10:57:52","datetime":"2025-07-16 10:57:52","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":88139,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Match Drawn","day_remaining_over":"26","team_batting":"Warwickshire","team_bowling":"Sussex","live_inning_number":3,"live_score":{"runs":260,"overs":88,"wickets":4,"target":0,"runrate":2.95,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Ed Barnard","batsman_id":49041,"runs":9,"balls_faced":17,"fours":1,"sixes":0,"strike_rate":"52.94"},{"name":"Sam Hain","batsman_id":49025,"runs":53,"balls_faced":170,"fours":0,"sixes":0,"strike_rate":"31.18"}],"bowlers":[{"name":"Fynn Hudson-Prentice","bowler_id":50663,"overs":2,"runs_conceded":5,"wickets":0,"maidens":1,"econ":"2.50"},{"name":"Daniel Hughes","bowler_id":90598,"overs":1,"runs_conceded":1,"wickets":0,"maidens":0,"econ":"1.00"}],"commentaries":[{"event_id":"12274856","event":"ball","batsman_id":"49041","bowler_id":"108396","over":"83","ball":"6","score":0,"commentary":"Danial Ibrahim to Ed Barnard, no run,","noball_dismissal":false,"text":"","timestamp":1751477529,"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":84,"runs":3,"score":"247\/4","bats":[{"runs":2,"balls_faced":8,"fours":0,"sixes":0,"batsman_id":49041},{"runs":49,"balls_faced":154,"fours":0,"sixes":0,"batsman_id":49025}],"bowls":[{"runs_conceded":19,"maidens":0,"wickets":0,"bowler_id":108396,"overs":4},{"runs_conceded":81,"maidens":7,"wickets":1,"bowler_id":101481,"overs":33}],"commentary":"End of over 84 (3 runs), Warwickshire 247\/4"},{"event_id":"12274860","event":"ball","batsman_id":"49025","bowler_id":"50663","over":"84","ball":"1","score":1,"commentary":"Fynn Hudson-Prentice to Sam Hain, 1 run,","noball_dismissal":false,"text":"","timestamp":1751477532,"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":"12274861","event":"ball","batsman_id":"49041","bowler_id":"50663","over":"84","ball":"2","score":0,"commentary":"Fynn Hudson-Prentice to Ed Barnard, no run,","noball_dismissal":false,"text":"","timestamp":1751477536,"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":"12274863","event":"ball","batsman_id":"49041","bowler_id":"50663","over":"84","ball":"3","score":4,"commentary":"Fynn Hudson-Prentice to Ed Barnard, Four,","noball_dismissal":false,"text":"","timestamp":1751477540,"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":"12274864","event":"ball","batsman_id":"49041","bowler_id":"50663","over":"84","ball":"4","score":0,"commentary":"Fynn Hudson-Prentice to Ed Barnard, no run,","noball_dismissal":false,"text":"","timestamp":1751477543,"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":"12274865","event":"ball","batsman_id":"49041","bowler_id":"50663","over":"84","ball":"5","score":0,"commentary":"Fynn Hudson-Prentice to Ed Barnard, no run,","noball_dismissal":false,"text":"","timestamp":1751477547,"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":"12274867","event":"ball","batsman_id":"49041","bowler_id":"50663","over":"84","ball":"6","score":0,"commentary":"Fynn Hudson-Prentice to Ed Barnard, no run,","noball_dismissal":false,"text":"","timestamp":1751477550,"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":85,"runs":5,"score":"252\/4","bats":[{"runs":6,"balls_faced":13,"fours":1,"sixes":0,"batsman_id":49041},{"runs":50,"balls_faced":155,"fours":0,"sixes":0,"batsman_id":49025}],"bowls":[{"runs_conceded":5,"maidens":0,"wickets":0,"bowler_id":50663,"overs":1},{"runs_conceded":19,"maidens":0,"wickets":0,"bowler_id":108396,"overs":4}],"commentary":"End of over 85 (5 runs), Warwickshire 252\/4"},{"event_id":"12274873","event":"ball","batsman_id":"49025","bowler_id":"108396","over":"85","ball":"1","score":0,"commentary":"Danial Ibrahim to Sam Hain, no run,","noball_dismissal":false,"text":"","timestamp":1751477554,"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":"12274894","event":"ball","batsman_id":"49025","bowler_id":"108396","over":"85","ball":"2","score":0,"commentary":"Danial Ibrahim to Sam Hain, no run,","noball_dismissal":false,"text":"","timestamp":1751477557,"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":"12274897","event":"ball","batsman_id":"49025","bowler_id":"108396","over":"85","ball":"3","score":1,"commentary":"Danial Ibrahim to Sam Hain, 1 run,","noball_dismissal":false,"text":"","timestamp":1751477561,"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":"12274899","event":"ball","batsman_id":"49041","bowler_id":"108396","over":"85","ball":"4","score":0,"commentary":"Danial Ibrahim to Ed Barnard, no run,","noball_dismissal":false,"text":"","timestamp":1751477564,"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":"12274902","event":"ball","batsman_id":"49041","bowler_id":"108396","over":"85","ball":"5","score":3,"commentary":"Danial Ibrahim to Ed Barnard, 3 runs,","noball_dismissal":false,"text":"","timestamp":1751477567,"run":3,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"3","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12274908","event":"ball","batsman_id":"49025","bowler_id":"108396","over":"85","ball":"6","score":"3nb","commentary":"Danial Ibrahim to Sam Hain, 3 no ball,","noball_dismissal":false,"text":"","timestamp":1751477571,"run":3,"noball_run":"1","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":true,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12274912","event":"ball","batsman_id":"49041","bowler_id":"108396","over":"85","ball":"6","score":0,"commentary":"Danial Ibrahim to Ed Barnard, no run,","noball_dismissal":false,"text":"","timestamp":1751477575,"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":86,"runs":7,"score":"259\/4","bats":[{"runs":9,"balls_faced":16,"fours":1,"sixes":0,"batsman_id":49041},{"runs":52,"balls_faced":159,"fours":0,"sixes":0,"batsman_id":49025}],"bowls":[{"runs_conceded":25,"maidens":0,"wickets":0,"bowler_id":108396,"overs":5},{"runs_conceded":5,"maidens":0,"wickets":0,"bowler_id":50663,"overs":1}],"commentary":"End of over 86 (7 runs), Warwickshire 259\/4"},{"event_id":"12274916","event":"ball","batsman_id":"49025","bowler_id":"90598","over":"86","ball":"1","score":0,"commentary":"Daniel Hughes to Sam Hain, no run,","noball_dismissal":false,"text":"","timestamp":1751477580,"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":"12274917","event":"ball","batsman_id":"49025","bowler_id":"90598","over":"86","ball":"2","score":0,"commentary":"Daniel Hughes to Sam Hain, no run,","noball_dismissal":false,"text":"","timestamp":1751477584,"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":"12274918","event":"ball","batsman_id":"49025","bowler_id":"90598","over":"86","ball":"3","score":0,"commentary":"Daniel Hughes to Sam Hain, no run,","noball_dismissal":false,"text":"","timestamp":1751477588,"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":"12274920","event":"ball","batsman_id":"49025","bowler_id":"90598","over":"86","ball":"4","score":0,"commentary":"Daniel Hughes to Sam Hain, no run,","noball_dismissal":false,"text":"","timestamp":1751477591,"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":"12274922","event":"ball","batsman_id":"49025","bowler_id":"90598","over":"86","ball":"5","score":1,"commentary":"Daniel Hughes to Sam Hain, 1 run,","noball_dismissal":false,"text":"","timestamp":1751477594,"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":"12274923","event":"ball","batsman_id":"49041","bowler_id":"90598","over":"86","ball":"6","score":0,"commentary":"Daniel Hughes to Ed Barnard, no run,","noball_dismissal":false,"text":"","timestamp":1751477597,"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":87,"runs":1,"score":"260\/4","bats":[{"runs":9,"balls_faced":17,"fours":1,"sixes":0,"batsman_id":49041},{"runs":53,"balls_faced":164,"fours":0,"sixes":0,"batsman_id":49025}],"bowls":[{"runs_conceded":1,"maidens":0,"wickets":0,"bowler_id":90598,"overs":1},{"runs_conceded":25,"maidens":0,"wickets":0,"bowler_id":108396,"overs":5}],"commentary":"End of over 87 (1 runs), Warwickshire 260\/4"},{"event_id":"12274926","event":"ball","batsman_id":"49025","bowler_id":"50663","over":"87","ball":"1","score":0,"commentary":"Fynn Hudson-Prentice to Sam Hain, no run,","noball_dismissal":false,"text":"","timestamp":1751477601,"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":"12274927","event":"ball","batsman_id":"49025","bowler_id":"50663","over":"87","ball":"2","score":0,"commentary":"Fynn Hudson-Prentice to Sam Hain, no run,","noball_dismissal":false,"text":"","timestamp":1751477605,"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":"12274928","event":"ball","batsman_id":"49025","bowler_id":"50663","over":"87","ball":"3","score":0,"commentary":"Fynn Hudson-Prentice to Sam Hain, no run,","noball_dismissal":false,"text":"","timestamp":1751477608,"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":"12274929","event":"ball","batsman_id":"49025","bowler_id":"50663","over":"87","ball":"4","score":0,"commentary":"Fynn Hudson-Prentice to Sam Hain, no run,","noball_dismissal":false,"text":"","timestamp":1751477613,"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":"12274930","event":"ball","batsman_id":"49025","bowler_id":"50663","over":"87","ball":"5","score":0,"commentary":"Fynn Hudson-Prentice to Sam Hain, no run,","noball_dismissal":false,"text":"","timestamp":1751477617,"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":"12274932","event":"ball","batsman_id":"49025","bowler_id":"50663","over":"87","ball":"6","score":0,"commentary":"Fynn Hudson-Prentice to Sam Hain, no run,","noball_dismissal":false,"text":"","timestamp":1751477621,"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":88,"runs":0,"score":"260\/4","bats":[{"runs":53,"balls_faced":170,"fours":0,"sixes":0,"batsman_id":49025},{"runs":9,"balls_faced":17,"fours":1,"sixes":0,"batsman_id":49041}],"bowls":[{"runs_conceded":5,"maidens":1,"wickets":0,"bowler_id":50663,"overs":2},{"runs_conceded":1,"maidens":0,"wickets":0,"bowler_id":90598,"overs":1}],"commentary":"End of over 88 (0 runs), Warwickshire 260\/4"}],"day":"4","session":"0","live_inning":{"iid":198995,"number":3,"name":"Warwickshire 2nd Inning","short_name":"WAS 2nd Inning","status":2,"issuperover":"false","result":4,"batting_team_id":7002,"fielding_team_id":5721,"scores":"260\/4","scores_full":"260\/4 (88 ov)","fielder":[{"fielder_id":"51271","fielder_name":"Tom Haines","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"108396","fielder_name":"Danial Ibrahim","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"102957","fielder_name":"James Coles","catches":0,"runout_thrower":0,"runout_catcher":1,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"50663","fielder_name":"Fynn Hudson-Prentice","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":[],"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":"Zen Malik","batsman_id":"88689","runs":"44","balls":"80","how_out":"c FJ Hudson-Prentice b J J Carson","score_at_dismissal":240,"overs_at_dismissal":"80.6","bowler_id":"101481","dismissal":"caught","number":4},"extra_runs":{"byes":0,"legbyes":4,"wides":0,"noballs":12,"penalty":"0","total":16},"equations":{"runs":260,"wickets":4,"overs":"88","bowlers_used":9,"runrate":"2.95"},"current_partnership":{"runs":20,"balls":43,"overs":7.1,"batsmen":[{"name":"Sam Hain","batsman_id":49025,"runs":9,"balls":26},{"name":"Ed Barnard","batsman_id":49041,"runs":9,"balls":17}]},"did_not_bat":[{"player_id":"94952","name":"Kai Smith"},{"player_id":"93516","name":"Ethan Bamber"},{"player_id":"49017","name":"Oliver Hannon-Dalby"},{"player_id":"49320","name":"Chris Rushworth"},{"player_id":"103483","name":"Corey Rocchiccioli"}],"max_over":"0","target":"0","recent_scores":"0,0,0,0,0,0,0,1,0,0,0,0,0,3,3,0,1,0","last_five_overs":"16\/0 3.10","last_ten_overs":"34\/1 3.34"},"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":"533\/10 (151.4 ov)","scores":"533\/10","overs":"151.4"},{"tid":7002,"title":"Warwickshire","abbr":"WAS","alt_name":"Warwickshire","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Warwickshire.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Warwickshire.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"415\/10 (107.5 ov) & 260\/4 (88 ov)","scores":"415\/10 & 260\/4","overs":"107.5 & 88"}],"players":[{"pid":77,"title":"Steven Smith","short_name":"S Smith","first_name":"Steven Smith","last_name":"","middle_name":"","birthdate":"1989-06-02","birthplace":"Sydney, New South Wales","country":"au","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":9,"facebook_profile":"https:\/\/www.facebook.com\/SteveSmith\/","twitter_profile":"https:\/\/twitter.com\/stevesmith49","instagram_profile":"https:\/\/www.instagram.com\/steve_smith49\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":107,"title":"Chris Woakes","short_name":"C Woakes","first_name":"Chris Woakes","last_name":"","middle_name":"","birthdate":"1989-03-02","birthplace":"Birmingham, Warwickshire","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":8,"facebook_profile":"https:\/\/www.facebook.com\/chriswoakes\/","twitter_profile":"https:\/\/twitter.com\/chriswoakes","instagram_profile":"https:\/\/www.instagram.com\/chriswoakes\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":820,"title":"Gurinder Sandhu","short_name":"GS Sandhu","first_name":"Gurinder Sandhu","last_name":"","middle_name":"","birthdate":"1993-06-14","birthplace":"Blacktown, New South Wales","country":"au","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,"facebook_profile":"https:\/\/www.facebook.com\/Gsandhu206\/","twitter_profile":"https:\/\/twitter.com\/gurinder_19","instagram_profile":"https:\/\/www.instagram.com\/gurinder_19\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"bowl","role_str":""},{"pid":1384,"title":"George Garton","short_name":"G Garton","first_name":"George Garton","last_name":"","middle_name":"","birthdate":"1997-04-15","birthplace":"Brighton, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/george_garton","instagram_profile":"https:\/\/www.instagram.com\/georgegarton\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":43985,"title":"Vishwa Fernando","short_name":"V Fernando","first_name":"Vishwa Fernando","last_name":"","middle_name":"","birthdate":"1991-09-18","birthplace":"Colombo","country":"lk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":37263,"recent_appearance":1513776600,"fantasy_player_rating":7,"facebook_profile":"https:\/\/www.facebook.com\/VishwaFernandoSLC\/","twitter_profile":"https:\/\/twitter.com\/vrnfernando1","instagram_profile":"https:\/\/www.instagram.com\/vishwa_fernando68\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Sri Lanka","role":"squad","role_str":""},{"pid":44099,"title":"Hasan Ali","short_name":"H Ali","first_name":"Hasan Ali","last_name":"","middle_name":"","birthdate":"1994-07-02","birthplace":"Gujranwala, Punjab","country":"pk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/Realhassan32\/","twitter_profile":"https:\/\/twitter.com\/RealHa55an","instagram_profile":"https:\/\/www.instagram.com\/ha55an_ali\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"squad","role_str":""},{"pid":44185,"title":"Tom Latham","short_name":"T Latham","first_name":"Tom Latham","last_name":"","middle_name":"","birthdate":"1992-04-02","birthplace":"Christchurch, Canterbury","country":"nz","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"wicket keeper","recent_match":23991,"recent_appearance":1513980000,"fantasy_player_rating":7,"facebook_profile":"https:\/\/www.facebook.com\/tomlathamofficial","twitter_profile":"https:\/\/twitter.com\/Tomlatham2","instagram_profile":"https:\/\/www.instagram.com\/tomlatham2\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"wk","role_str":""},{"pid":48430,"title":"Alex Davies","short_name":"AL Davies","first_name":"Alex Davies","last_name":"","middle_name":"","birthdate":"1994-08-23","birthplace":"Darwen, Lancashire","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":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/aldavies23\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(C)"},{"pid":49017,"title":"Oliver Hannon-Dalby","short_name":"OJ Hannon-Dalby","first_name":"Oliver Hannon-Dalby","last_name":"","middle_name":"","birthdate":"1989-06-20","birthplace":" Halifax, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":49025,"title":"Sam Hain","short_name":"SR Hain","first_name":"Sam Hain","last_name":"","middle_name":"","birthdate":"1995-07-16","birthplace":"Hong Kong","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":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/SammieHain","instagram_profile":"https:\/\/www.instagram.com\/sammiehain","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":49041,"title":"Ed Barnard","short_name":"EG Barnard","first_name":"Ed Barnard","last_name":"","middle_name":"","birthdate":"1995-11-20","birthplace":"","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":49091,"title":"Cheteshwar Pujara","short_name":"CA Pujara","first_name":"Cheteshwar Pujara","last_name":"","middle_name":"","birthdate":"1988-01-25","birthplace":"Rajkot","country":"in","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":9,"facebook_profile":"https:\/\/www.facebook.com\/OfficialCheteshwarPujara\/","twitter_profile":"https:\/\/twitter.com\/i\/flow\/login?redirect_after_login=%2Fcheteshwar1","instagram_profile":"https:\/\/www.instagram.com\/cheteshwar_pujara\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":49320,"title":"Chris Rushworth","short_name":"C Rushworth","first_name":"Chris Rushworth","last_name":"","middle_name":"","birthdate":"1986-07-11","birthplace":"Sunderland","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":49480,"title":"Danny Briggs","short_name":"DR Briggs","first_name":"Danny Briggs","last_name":"","middle_name":"","birthdate":"1991-04-30","birthplace":" Newport, Isle of Wight","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/DannyBriggs_14","instagram_profile":"https:\/\/www.instagram.com\/dannybriggs14\/","debut_data":"","bowling_type":"Spin","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK\/C)"},{"pid":49530,"title":"Craig Miles","short_name":"CN Miles","first_name":"Craig Miles","last_name":"","middle_name":"","birthdate":"1994-07-20","birthplace":"Swindon, Wiltshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/CMiles_18","instagram_profile":"https:\/\/www.instagram.com\/cmiles18\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50663,"title":"Fynn Hudson-Prentice","short_name":"FJ Hudson-Prentice","first_name":"Fynn Hudson-Prentice","last_name":"","middle_name":"","birthdate":"1996-01-12","birthplace":"Haywards Heath, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/fynnhudson33","instagram_profile":"https:\/\/www.instagram.com\/fynnhudson33\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","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":"","bowling_type":"","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":53626,"title":"Beau Webster","short_name":"BJ Webster","first_name":"Beau Webster","last_name":"","middle_name":"","birthdate":"1993-12-01","birthplace":"Snug, Hobart, Tasmania","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":88689,"title":"Zen Malik","short_name":"Z Malik","first_name":"Zen Malik","last_name":"","middle_name":"","birthdate":"1998-04-09","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"bat","role_str":""},{"pid":93516,"title":"Ethan Bamber","short_name":"ER Bamber","first_name":"Ethan Bamber","last_name":"","middle_name":"","birthdate":"1998-12-17","birthplace":"Westminster, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/etbamber","instagram_profile":"https:\/\/www.instagram.com\/etbamber\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":94952,"title":"Kai Smith","short_name":"K Smith","first_name":"Kai Smith","last_name":"","middle_name":"","birthdate":"2004-11-28","birthplace":" Dubai, United Arab Emirates","country":"ae","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"bat","role_str":"(WK)"},{"pid":95003,"title":"Robert Yates","short_name":"RM Yates","first_name":"Robert Yates","last_name":"","middle_name":"","birthdate":"1999-09-19","birthplace":"Solihull, Warwickshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":95543,"title":"Dan Mousley","short_name":"D Mousley","first_name":"Dan Mousley","last_name":"","middle_name":"","birthdate":"2001-07-08","birthplace":"Birmingham, Warwickshire","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.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/danmousley80","instagram_profile":"https:\/\/www.instagram.com\/danmousley80\/","debut_data":"","bowling_type":"Spin","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":"","bowling_type":"Pace","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":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/jayden_seales","instagram_profile":"https:\/\/www.instagram.com\/jay_seales\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":97581,"title":"Aristides Karvelas","short_name":"A Karvelas","first_name":"Aristides Karvelas","last_name":"","middle_name":"","birthdate":"1994-03-20","birthplace":"Johannesburg, Gauteng","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/ari_karvelas\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","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":"","bowling_type":"Spin","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":102808,"title":"Jake Lintott","short_name":"J Lintott","first_name":"Jake Lintott","last_name":"","middle_name":"","birthdate":"1993-04-22","birthplace":"Taunton, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Wrist Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lintott23","instagram_profile":"https:\/\/www.instagram.com\/lintott23\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":103483,"title":"Corey Rocchiccioli","short_name":"C Rocchiccioli","first_name":"Corey Rocchiccioli","last_name":"","middle_name":"","birthdate":"1997-10-08","birthplace":"Subiaco, Perth, Western Australia","country":"au","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/_rockets23","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Australia","role":"bowl","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108389,"title":"Che Simmons","short_name":"C Simmons","first_name":"Che Simmons","last_name":"","middle_name":"","birthdate":"2003-12-18","birthplace":"Birmingham, England","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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":109051,"title":"Ali Orr","short_name":"AGH Orr","first_name":"Ali Orr","last_name":"","middle_name":"","birthdate":"2001-04-06","birthplace":"Eastbourne, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/alastairorr\/","debut_data":"","bowling_type":"Pace","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":109583,"title":"Hamza Shaikh","short_name":"H Shaikh","first_name":"Hamza Shaikh","last_name":"","middle_name":"","birthdate":"2006-05-29","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":110620,"title":"Michael Booth","short_name":"MG Booth","first_name":"Michael Booth","last_name":"","middle_name":"","birthdate":"2001-02-12","birthplace":" Harare","country":"za","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":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Scotland","role":"squad","role_str":""},{"pid":134957,"title":"Tazeem Chaudry Ali","short_name":"TC Ali","first_name":"Tazeem Chaudry Ali","last_name":"","middle_name":"","birthdate":"2006-06-13","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":147627,"title":"Nantes Thomas","short_name":"N Thomas","first_name":"Nantes Thomas","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""}]},"etag":"eb6faee0233e037647be72bc6b3fe4e9","modified":"2025-07-16 10:57:52","datetime":"2025-07-16 10:57:52","api_version":"3.0"}', Modified = GetDate() WHERE Id = 88139 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:84c2ca59-4360-4207-bb1a-9c7adda71e78
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 88139 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (88139,3,'{"status":"ok","response":{"match_id":88139,"title":"Sussex vs Warwickshire","short_title":"SUS vs WAS","subtitle":"45th Match","match_number":"45","format":5,"format_str":"First Class","status":2,"status_str":"Completed","status_note":"Match Drawn","verified":"true","pre_squad":"false","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129481,"title":"County Championship Division One","abbr":"County Championship 2025 DIV-I","type":"tournament","category":"domestic","match_format":"firstclass","season":"2025","status":"live","datestart":"2025-04-04","dateend":"2025-09-27","country":"en","total_matches":"70","total_rounds":"1","total_teams":"10"},"teama":{"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":"533\/10 (151.4 ov)","scores":"533\/10","overs":"151.4"},"teamb":{"team_id":7002,"name":"Warwickshire","short_name":"WAS","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Warwickshire.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Warwickshire.png","scores_full":"415\/10 (107.5 ov) & 260\/4 (88 ov)","scores":"415\/10 & 260\/4","overs":"107.5 & 88"},"date_start":"2025-06-29 10:00:00","date_end":"2025-07-04 10:00:00","timestamp_start":1751191200,"timestamp_end":1751623200,"date_start_ist":"2025-06-29 15:30:00","date_end_ist":"2025-07-04 15:30:00","venue":{"venue_id":"47","name":"County Ground, Hove","location":"Brighton","country":"England","timezone":""},"umpires":"","referee":"","equation":"Match Drawn","live":"","result":"Match Drawn","result_type":3,"win_margin":"","winning_team_id":0,"commentary":1,"wagon":2,"latest_inning_number":3,"presquad_time":"","verify_time":"2025-07-02 23:51:56","match_dls_affected":"false","live_inning_number":3,"day":"4","session":"0","weather":[],"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Warwickshire elected to bat","winner":7002,"decision":1}},"etag":"688a4eecb40769b7074819e093714f70","modified":"2025-07-16 10:57:53","datetime":"2025-07-16 10:57:53","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":88139,"title":"Sussex vs Warwickshire","short_title":"SUS vs WAS","subtitle":"45th Match","match_number":"45","format":5,"format_str":"First Class","status":2,"status_str":"Completed","status_note":"Match Drawn","verified":"true","pre_squad":"false","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129481,"title":"County Championship Division One","abbr":"County Championship 2025 DIV-I","type":"tournament","category":"domestic","match_format":"firstclass","season":"2025","status":"live","datestart":"2025-04-04","dateend":"2025-09-27","country":"en","total_matches":"70","total_rounds":"1","total_teams":"10"},"teama":{"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":"533\/10 (151.4 ov)","scores":"533\/10","overs":"151.4"},"teamb":{"team_id":7002,"name":"Warwickshire","short_name":"WAS","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Warwickshire.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Warwickshire.png","scores_full":"415\/10 (107.5 ov) & 260\/4 (88 ov)","scores":"415\/10 & 260\/4","overs":"107.5 & 88"},"date_start":"2025-06-29 10:00:00","date_end":"2025-07-04 10:00:00","timestamp_start":1751191200,"timestamp_end":1751623200,"date_start_ist":"2025-06-29 15:30:00","date_end_ist":"2025-07-04 15:30:00","venue":{"venue_id":"47","name":"County Ground, Hove","location":"Brighton","country":"England","timezone":""},"umpires":"","referee":"","equation":"Match Drawn","live":"","result":"Match Drawn","result_type":3,"win_margin":"","winning_team_id":0,"commentary":1,"wagon":2,"latest_inning_number":3,"presquad_time":"","verify_time":"2025-07-02 23:51:56","match_dls_affected":"false","live_inning_number":3,"day":"4","session":"0","weather":[],"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Warwickshire elected to bat","winner":7002,"decision":1}},"etag":"688a4eecb40769b7074819e093714f70","modified":"2025-07-16 10:57:53","datetime":"2025-07-16 10:57:53","api_version":"3.0"}', Modified = GetDate() WHERE Id = 88139 AND DataTypeId = 3 END Live Report & Scorecard of Sussex vs Warwickshire 45th Match
Sussex vs Warwickshire, Live Cricket Commentary