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:d97ba01e-a7a1-4c7f-9351-dd51aa7c4240
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86904 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86904,1,'{"status":"ok","response":{"mid":86904,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Somerset won by 4 wickets","day_remaining_over":"","team_batting":"Somerset","team_bowling":"Hampshire","live_inning_number":2,"live_score":{"runs":179,"overs":19.5,"wickets":6,"target":179,"runrate":9.03,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Lewis Goldsworthy","batsman_id":95554,"runs":8,"balls_faced":3,"fours":0,"sixes":1,"strike_rate":"266.67"},{"name":"Ben Green","batsman_id":1049,"runs":19,"balls_faced":10,"fours":1,"sixes":1,"strike_rate":"190.00"}],"bowlers":[{"name":"Sonny Baker","bowler_id":108409,"overs":3.5,"runs_conceded":38,"wickets":0,"maidens":0,"econ":"9.91"},{"name":"Scott Currie","bowler_id":96605,"overs":4,"runs_conceded":32,"wickets":3,"maidens":0,"econ":"8.00"}],"commentaries":[{"event_id":"12297145","event":"ball","batsman_id":"49413","bowler_id":"49524","over":"15","ball":"3","score":4,"commentary":"Benny Howell to Tom Abell, Four,","noball_dismissal":false,"text":"","timestamp":1751821888,"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":"12297147","event":"ball","batsman_id":"49413","bowler_id":"49524","over":"15","ball":"4","score":1,"commentary":"Benny Howell to Tom Abell, 1 run,","noball_dismissal":false,"text":"","timestamp":1751821890,"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":"12297158","event":"wicket","batsman_id":"49823","bowler_id":"49524","over":"15","ball":"5","score":"w","commentary":"Benny Howell to Sean Dickson, no run, c L Dawson b BAC Howell,","noball_dismissal":false,"text":"","timestamp":1751825187,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"49823","how_out":"c L Dawson b BAC Howell","batsman_runs":"52","batsman_balls":"33"},{"event_id":"12297208","event":"ball","batsman_id":"93520","bowler_id":"49524","over":"15","ball":"6","score":2,"commentary":"Benny Howell to Tom Lammonby, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751822232,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":16,"runs":11,"score":"141\/4","bats":[{"runs":2,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":93520},{"runs":36,"balls_faced":24,"fours":5,"sixes":0,"batsman_id":49413}],"bowls":[{"runs_conceded":32,"maidens":0,"wickets":1,"bowler_id":49524,"overs":3},{"runs_conceded":29,"maidens":0,"wickets":1,"bowler_id":1945,"overs":4}],"commentary":"End of over 16 (11 runs), Somerset 141\/4"},{"event_id":"12297209","event":"ball","batsman_id":"49413","bowler_id":"96605","over":"16","ball":"1","score":1,"commentary":"Scott Currie to Tom Abell, 1 run,","noball_dismissal":false,"text":"","timestamp":1751822235,"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":"12297210","event":"ball","batsman_id":"93520","bowler_id":"96605","over":"16","ball":"2","score":1,"commentary":"Scott Currie to Tom Lammonby, 1 run,","noball_dismissal":false,"text":"","timestamp":1751822238,"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":"12297216","event":"wicket","batsman_id":"49413","bowler_id":"96605","over":"16","ball":"3","score":"w","commentary":"Scott Currie to Tom Abell, no run, c & b S Currie,","noball_dismissal":false,"text":"","timestamp":1751822240,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"49413","how_out":"c & b S Currie","batsman_runs":"37","batsman_balls":"26"},{"event_id":"12297253","event":"ball","batsman_id":"1049","bowler_id":"96605","over":"16","ball":"4","score":1,"commentary":"Scott Currie to Ben Green, 1 run,","noball_dismissal":false,"text":"","timestamp":1751822498,"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":"12297256","event":"ball","batsman_id":"93520","bowler_id":"96605","over":"16","ball":"5","score":1,"commentary":"Scott Currie to Tom Lammonby, 1 run,","noball_dismissal":false,"text":"","timestamp":1751822501,"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":"12297259","event":"ball","batsman_id":"1049","bowler_id":"96605","over":"16","ball":"6","score":1,"commentary":"Scott Currie to Ben Green, 1 run,","noball_dismissal":false,"text":"","timestamp":1751822504,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":17,"runs":5,"score":"146\/5","bats":[{"runs":2,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":1049},{"runs":4,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":93520}],"bowls":[{"runs_conceded":20,"maidens":0,"wickets":2,"bowler_id":96605,"overs":3},{"runs_conceded":32,"maidens":0,"wickets":1,"bowler_id":49524,"overs":3}],"commentary":"End of over 17 (5 runs), Somerset 146\/5"},{"event_id":"12297267","event":"ball","batsman_id":"1049","bowler_id":"108409","over":"17","ball":"1","score":1,"commentary":"Sonny Baker to Ben Green, 1 run,","noball_dismissal":false,"text":"","timestamp":1751822635,"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":"12297269","event":"ball","batsman_id":"93520","bowler_id":"108409","over":"17","ball":"2","score":1,"commentary":"Sonny Baker to Tom Lammonby, 1 run,","noball_dismissal":false,"text":"","timestamp":1751822638,"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":"12297286","event":"ball","batsman_id":"1049","bowler_id":"108409","over":"17","ball":"3","score":1,"commentary":"Sonny Baker to Ben Green, 1 run,","noball_dismissal":false,"text":"","timestamp":1751822641,"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":"12297287","event":"ball","batsman_id":"93520","bowler_id":"108409","over":"17","ball":"4","score":2,"commentary":"Sonny Baker to Tom Lammonby, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751822649,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12297288","event":"ball","batsman_id":"93520","bowler_id":"108409","over":"17","ball":"5","score":4,"commentary":"Sonny Baker to Tom Lammonby, Four,","noball_dismissal":false,"text":"","timestamp":1751822652,"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":"12297322","event":"ball","batsman_id":"93520","bowler_id":"108409","over":"17","ball":"6","score":"1lb","commentary":"Sonny Baker to Tom Lammonby, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1751822925,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"1","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":18,"runs":10,"score":"156\/5","bats":[{"runs":11,"balls_faced":7,"fours":1,"sixes":0,"batsman_id":93520},{"runs":4,"balls_faced":4,"fours":0,"sixes":0,"batsman_id":1049}],"bowls":[{"runs_conceded":27,"maidens":0,"wickets":0,"bowler_id":108409,"overs":3},{"runs_conceded":20,"maidens":0,"wickets":2,"bowler_id":96605,"overs":3}],"commentary":"End of over 18 (10 runs), Somerset 156\/5"},{"event_id":"12297333","event":"ball","batsman_id":"93520","bowler_id":"96605","over":"18","ball":"1","score":0,"commentary":"Scott Currie to Tom Lammonby, no run,","noball_dismissal":false,"text":"","timestamp":1751822928,"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":"12297334","event":"wicket","batsman_id":"93520","bowler_id":"96605","over":"18","ball":"2","score":"w","commentary":"Scott Currie to Tom Lammonby, no run, c BAC Howell b S Currie,","noball_dismissal":false,"text":"","timestamp":1751822932,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"93520","how_out":"c BAC Howell b S Currie","batsman_runs":"11","batsman_balls":"9"},{"event_id":"12297338","event":"ball","batsman_id":"95554","bowler_id":"96605","over":"18","ball":"3","score":1,"commentary":"Scott Currie to Lewis Goldsworthy, 1 run,","noball_dismissal":false,"text":"","timestamp":1751822962,"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":"12297340","event":"ball","batsman_id":"1049","bowler_id":"96605","over":"18","ball":"4","score":4,"commentary":"Scott Currie to Ben Green, Four,","noball_dismissal":false,"text":"","timestamp":1751822964,"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":"12297342","event":"ball","batsman_id":"1049","bowler_id":"96605","over":"18","ball":"5","score":1,"commentary":"Scott Currie to Ben Green, 1 run,","noball_dismissal":false,"text":"","timestamp":1751822967,"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":"12297344","event":"ball","batsman_id":"95554","bowler_id":"96605","over":"18","ball":"6","score":6,"commentary":"Scott Currie to Lewis Goldsworthy, Six,","noball_dismissal":false,"text":"","timestamp":1751822969,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event":"overend","over":19,"runs":12,"score":"168\/6","bats":[{"runs":7,"balls_faced":2,"fours":0,"sixes":1,"batsman_id":95554},{"runs":9,"balls_faced":6,"fours":1,"sixes":0,"batsman_id":1049}],"bowls":[{"runs_conceded":32,"maidens":0,"wickets":3,"bowler_id":96605,"overs":4},{"runs_conceded":27,"maidens":0,"wickets":0,"bowler_id":108409,"overs":3}],"commentary":"End of over 19 (12 runs), Somerset 168\/6"},{"event_id":"12297353","event":"ball","batsman_id":"1049","bowler_id":"108409","over":"19","ball":"1","score":1,"commentary":"Sonny Baker to Ben Green, 1 run,","noball_dismissal":false,"text":"","timestamp":1751823032,"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":"12297358","event":"ball","batsman_id":"95554","bowler_id":"108409","over":"19","ball":"2","score":1,"commentary":"Sonny Baker to Lewis Goldsworthy, 1 run,","noball_dismissal":false,"text":"","timestamp":1751823216,"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":"12297374","event":"ball","batsman_id":"1049","bowler_id":"108409","over":"19","ball":"3","score":6,"commentary":"Sonny Baker to Ben Green, Six,","noball_dismissal":false,"text":"","timestamp":1751823219,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12297375","event":"ball","batsman_id":"1049","bowler_id":"108409","over":"19","ball":"4","score":2,"commentary":"Sonny Baker to Ben Green, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751823223,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12297377","event":"ball","batsman_id":"1049","bowler_id":"108409","over":"19","ball":"5","score":1,"commentary":"Sonny Baker to Ben Green, 1 run,","noball_dismissal":false,"text":"","timestamp":1751824845,"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}],"day":"0","session":"0","live_inning":{"iid":199223,"number":2,"name":"Somerset Inning","short_name":"SOM Inning","status":2,"issuperover":"false","result":3,"batting_team_id":7010,"fielding_team_id":7047,"scores":"179\/6","scores_full":"179\/6 (19.5 ov)","fielder":[{"fielder_id":"1949","fielder_name":"James Vince","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"108377","fielder_name":"Toby Albert","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"96605","fielder_name":"Scott Currie","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"1945","fielder_name":"Liam Dawson","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"49524","fielder_name":"Benny Howell","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":"Tom Lammonby","batsman_id":"93520","runs":"11","balls":"9","how_out":"c BAC Howell b S Currie","score_at_dismissal":156,"overs_at_dismissal":"18.2","bowler_id":"96605","dismissal":"caught","number":6},"extra_runs":{"byes":4,"legbyes":3,"wides":0,"noballs":0,"penalty":"0","total":7},"equations":{"runs":179,"wickets":6,"overs":"19.5","bowlers_used":6,"runrate":"9.03"},"current_partnership":{"runs":23,"balls":9,"overs":1.3,"batsmen":[{"name":"Lewis Goldsworthy","batsman_id":95554,"runs":8,"balls":3},{"name":"Ben Green","batsman_id":1049,"runs":15,"balls":6}]},"did_not_bat":[{"player_id":"49733","name":"Craig Overton"},{"player_id":"486","name":"Matt Henry"},{"player_id":"93329","name":"Riley Meredith"}],"max_over":"20","target":"179","recent_scores":"1,2,6,1,1,6,1,4,1,w,0,1,4,2,1,1,1,1","last_five_overs":"50\/3 10.00","last_ten_overs":"100\/3 10.00"},"teams":[{"tid":7010,"title":"Somerset","abbr":"SOM","alt_name":"SOM","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/somerset-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/somerset-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"179\/6 (19.5 ov)","scores":"179\/6","overs":"19.5"},{"tid":7047,"title":"Hampshire","abbr":"HAM","alt_name":"HAM","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/hampshire-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/hampshire-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"178\/3 (20 ov)","scores":"178\/3","overs":"20"}],"players":[{"pid":301,"title":"Josh Davey","short_name":"J Davey","first_name":"Josh Davey","last_name":"","middle_name":"","birthdate":"1990-08-03","birthplace":"Aberdeen, United Kingdom","country":"sct","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":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Scotland","role":"squad","role_str":""},{"pid":432,"title":"Kyle Abbott","short_name":"K Abbott","first_name":"Kyle Abbott","last_name":"","middle_name":"","birthdate":"1987-06-18","birthplace":"Empangeni, KwaZulu-Natal","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":486,"title":"Matt Henry","short_name":"M Henry","first_name":"Matt Henry","last_name":"","middle_name":"","birthdate":"1991-12-14","birthplace":"Christchurch, Canterbury","country":"nz","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bowl","role_str":""},{"pid":1049,"title":"Ben Green","short_name":"BGF Green","first_name":"Ben Green","last_name":"","middle_name":"","birthdate":"1997-09-28","birthplace":"Exeter, Devon","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":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":1945,"title":"Liam Dawson","short_name":"L Dawson","first_name":"Liam Dawson","last_name":"","middle_name":"","birthdate":"1990-03-01","birthplace":"Swindon, Wiltshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/daws128\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":1949,"title":"James Vince","short_name":"J Vince","first_name":"James Vince","last_name":"","middle_name":"","birthdate":"1991-03-14","birthplace":"Cuckfield, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/vincey14\/","twitter_profile":"https:\/\/twitter.com\/vincey14","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"pid":10606,"title":"Jake Ball","short_name":"JT Ball","first_name":"Jake Ball","last_name":"","middle_name":"","birthdate":"1991-03-14","birthplace":"Mansfield, Nottinghamshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":18974,"recent_appearance":1517109600,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/jakeball","instagram_profile":"https:\/\/www.instagram.com\/jakeball\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":32166,"title":"James Fuller","short_name":"JK Fuller","first_name":"James Fuller","last_name":"","middle_name":"","birthdate":"1990-01-24","birthplace":"Cape Town, Cape Province","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/James_Fuller246","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":43508,"title":"Chris Lynn","short_name":"CA Lynn","first_name":"Chris Lynn","last_name":"","middle_name":"","birthdate":"1990-04-10","birthplace":" Brisbane, Queensland","country":"au","primary_team":[],"logo_url":"","playing_role":"bat","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":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":46147,"title":"Bjorn Fortuin","short_name":"BC Fortuin","first_name":"Bjorn Fortuin","last_name":"","middle_name":"","birthdate":"1994-10-21","birthplace":"Paarl","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/bjorn_fortuin","instagram_profile":"https:\/\/www.instagram.com\/bjornfortuin\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":48656,"title":"Tom Kohler-Cadmore","short_name":"TK Cadmore","first_name":"Tom Kohler-Cadmore","last_name":"","middle_name":"","birthdate":"1994-08-19","birthplace":" Chatham, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/tomkholerCadmore32\/","twitter_profile":"https:\/\/twitter.com\/TomKCadmore32","instagram_profile":"https:\/\/www.instagram.com\/tomkcadmore","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"pid":49015,"title":"Andrew Umeed","short_name":"ARI Umeed","first_name":"Andrew Umeed","last_name":"","middle_name":"","birthdate":"1996-04-19","birthplace":"Glasgow, Lanarkshire","country":"sct","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":"Scotland","role":"squad","role_str":""},{"pid":49334,"title":"Ben Brown","short_name":"BC Brown","first_name":"Ben Brown","last_name":"","middle_name":"","birthdate":"1988-11-23","birthplace":"Crawley, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper ","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Ben_Brown26","instagram_profile":"https:\/\/www.instagram.com\/benbrown26\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49343,"title":"Nick Gubbins","short_name":"NRT Gubbins","first_name":"Nick Gubbins","last_name":"","middle_name":"","birthdate":"1993-12-31","birthplace":"Richmond, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49413,"title":"Tom Abell","short_name":"TB Abell","first_name":"Tom Abell","last_name":"","middle_name":"","birthdate":"1994-03-05","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":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/tomabell1","instagram_profile":"https:\/\/www.instagram.com\/tabell28\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":49421,"title":"Lewis Gregory","short_name":"L Gregory","first_name":"Lewis Gregory","last_name":"","middle_name":"","birthdate":"1992-05-24","birthplace":"Plymouth","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/lewisgregory23\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49425,"title":"Jack Leach","short_name":"J Leach","first_name":"Jack Leach","last_name":"","middle_name":"","birthdate":"1991-06-22","birthplace":" Taunton, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/jackleach1991?lang=gu","instagram_profile":"https:\/\/www.instagram.com\/mjleach17\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49478,"title":"Chris Wood","short_name":"CP Wood","first_name":"Chris Wood","last_name":"","middle_name":"","birthdate":"1990-06-27","birthplace":"Basingstoke, Hampshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/CWoody27","instagram_profile":"https:\/\/www.instagram.com\/cwood25\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":49524,"title":"Benny Howell","short_name":"BAC Howell","first_name":"Benny Howell","last_name":"","middle_name":"","birthdate":"1988-10-05","birthplace":"Bordeaux, France","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/BennyHowellOfficial\/","twitter_profile":"https:\/\/twitter.com\/bennytweets_","instagram_profile":"https:\/\/www.instagram.com\/bennycam13\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":49536,"title":"Mark Stoneman","short_name":"MD Stoneman","first_name":"Mark Stoneman","last_name":"","middle_name":"","birthdate":"1987-06-26","birthplace":"Newcastle upon Tyne, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":18968,"recent_appearance":1514244600,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/mark23stone","instagram_profile":"https:\/\/www.instagram.com\/mark23stone\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49733,"title":"Craig Overton","short_name":"C Overton","first_name":"Craig Overton","last_name":"","middle_name":"","birthdate":"1994-04-10","birthplace":"Barnstaple, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/craigoverton12","instagram_profile":"https:\/\/www.instagram.com\/craigoverton12\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":49823,"title":"Sean Dickson","short_name":"SR Dickson","first_name":"Sean Dickson","last_name":"","middle_name":"","birthdate":"1991-09-02","birthplace":"Johannesburg, Transvaal","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bat","role_str":""},{"pid":50481,"title":"Felix Organ","short_name":"FS Organ","first_name":"Felix Organ","last_name":"","middle_name":"","birthdate":"1999-06-02","birthplace":"Sydney","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50484,"title":"Brad Wheal","short_name":"BTJ Wheal","first_name":"Brad Wheal","last_name":"","middle_name":"","birthdate":"1996-08-28","birthplace":"Durban, KwaZulu-Natal","country":"sct","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"https:\/\/www.facebook.com\/brad.wheal\/","twitter_profile":"https:\/\/twitter.com\/BradWheal","instagram_profile":"https:\/\/www.instagram.com\/bradwheal\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Scotland","role":"squad","role_str":""},{"pid":51266,"title":"Tom Banton","short_name":"T Banton","first_name":"Tom Banton","last_name":"","middle_name":"","birthdate":"1998-11-11","birthplace":"Chiltern, Buckinghamshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/OfficialTomBanton\/","twitter_profile":"https:\/\/twitter.com\/tbanton18","instagram_profile":"https:\/\/www.instagram.com\/tombanton\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":51285,"title":"Joe Weatherley","short_name":"JJ Weatherley","first_name":"Joe Weatherley","last_name":"","middle_name":"","birthdate":"1997-01-19","birthplace":"Winchester, Hampshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Joe_Weatherley","instagram_profile":"https:\/\/www.instagram.com\/jjweatherley\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":55591,"title":"Hilton Cartwright","short_name":"H Cartwright","first_name":"Hilton Cartwright","last_name":"","middle_name":"","birthdate":"1992-02-14","birthplace":"Harare, Zimbabwe","country":"au","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/HiltonC149","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"bat","role_str":""},{"pid":57592,"title":"Migael Pretorius","short_name":"M Pretorius","first_name":"Migael Pretorius","last_name":"","middle_name":"","birthdate":"1995-03-24","birthplace":"Vereeninging","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"https:\/\/www.facebook.com\/migael27\/","twitter_profile":"https:\/\/twitter.com\/migael_27","instagram_profile":"https:\/\/www.instagram.com\/migael27\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":93329,"title":"Riley Meredith","short_name":"RP Meredith","first_name":"Riley Meredith","last_name":"","middle_name":"","birthdate":"1996-06-21","birthplace":"Hobart, Tasmania","country":"au","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/rileymeredith_\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"bowl","role_str":""},{"pid":93520,"title":"Tom Lammonby","short_name":"TA Lammonby","first_name":"Tom Lammonby","last_name":"","middle_name":"","birthdate":"2000-06-02","birthplace":" Exeter, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left 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":"https:\/\/twitter.com\/TomLammonby","instagram_profile":"https:\/\/www.instagram.com\/tom_lammonby\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":95554,"title":"Lewis Goldsworthy","short_name":"L Goldsworthy","first_name":"Lewis Goldsworthy","last_name":"","middle_name":"","birthdate":"2001-01-08","birthplace":" Cornwall","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lewigoldsworthy","instagram_profile":"https:\/\/www.instagram.com\/lewisgoldsworthy\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":96605,"title":"Scott Currie","short_name":"S Currie","first_name":"Scott Currie","last_name":"","middle_name":"","birthdate":"2001-05-02","birthplace":"Poole, Dorset","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":103052,"title":"Will Smeed","short_name":"W Smeed","first_name":"Will Smeed","last_name":"","middle_name":"","birthdate":"2001-10-26","birthplace":"Cambridge","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/will_smeed","instagram_profile":"https:\/\/www.instagram.com\/willsmeed\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":108376,"title":"Tom Prest","short_name":"T Prest","first_name":"Tom Prest","last_name":"","middle_name":"","birthdate":"2003-03-24","birthplace":"Wimborne, Dorset","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108377,"title":"Toby Albert","short_name":"T Albert","first_name":"Toby Albert","last_name":"","middle_name":"","birthdate":"2001-11-12","birthplace":"Basingstoke, Hampshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":108378,"title":"Fletcha Middleton","short_name":"F Middleton","first_name":"Fletcha Middleton","last_name":"","middle_name":"","birthdate":"2002-01-31","birthplace":"Winchester, Hampshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108381,"title":"John Turner","short_name":"J Turner","first_name":"John Turner","last_name":"","middle_name":"","birthdate":"2001-04-10","birthplace":"Johannesburg, Gauteng","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108408,"title":"James Rew","short_name":"J Rew","first_name":"James Rew","last_name":"","middle_name":"","birthdate":"2004-01-11","birthplace":" London","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/cjrew89\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108409,"title":"Sonny Baker","short_name":"S Baker","first_name":"Sonny Baker","last_name":"","middle_name":"","birthdate":"2003-03-13","birthplace":"Torbay, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/sonnybaker\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":108410,"title":"Joshua Thomas","short_name":"J Thomas","first_name":"Joshua 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":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":"bat","role_str":""},{"pid":110871,"title":"Dewald Brevis","short_name":"D Brevis","first_name":"Dewald Brevis","last_name":"","middle_name":"","birthdate":"2003-04-29","birthplace":"Johannesburg","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/Brevis17\/","twitter_profile":"https:\/\/twitter.com\/BrevisDewald","instagram_profile":"https:\/\/www.instagram.com\/dewald_brevis_17\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":118936,"title":"Eddie Jack","short_name":"EV Jack","first_name":"Eddie Jack","last_name":"","middle_name":"","birthdate":"2005-09-09","birthplace":"Barnet, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":128989,"title":"Lhuan dre Pretorius","short_name":"Ld Pretorius","first_name":"Lhuan dre Pretorius","last_name":"","middle_name":"","birthdate":"2006-03-27","birthplace":"Potchefstroom","country":"za","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":129894,"title":"JT Langridge","short_name":"JT Langridge","first_name":"JT Langridge","last_name":"","middle_name":"","birthdate":"2005-11-03","birthplace":" Plymouth, Devon,","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":130425,"title":"Finley Hill","short_name":"F Hill","first_name":"Finley Hill","last_name":"","middle_name":"","birthdate":"2006-06-21","birthplace":" Exeter, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":137372,"title":"Archie Vaughan","short_name":"A Vaughan","first_name":"Archie Vaughan","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":146438,"title":"Thomas Rew","short_name":"T Rew","first_name":"Thomas Rew","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","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":""}]},"etag":"a23bb686a56049e4ac837337280d2b8e","modified":"2025-07-15 16:54:13","datetime":"2025-07-15 16:54:13","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":86904,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Somerset won by 4 wickets","day_remaining_over":"","team_batting":"Somerset","team_bowling":"Hampshire","live_inning_number":2,"live_score":{"runs":179,"overs":19.5,"wickets":6,"target":179,"runrate":9.03,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Lewis Goldsworthy","batsman_id":95554,"runs":8,"balls_faced":3,"fours":0,"sixes":1,"strike_rate":"266.67"},{"name":"Ben Green","batsman_id":1049,"runs":19,"balls_faced":10,"fours":1,"sixes":1,"strike_rate":"190.00"}],"bowlers":[{"name":"Sonny Baker","bowler_id":108409,"overs":3.5,"runs_conceded":38,"wickets":0,"maidens":0,"econ":"9.91"},{"name":"Scott Currie","bowler_id":96605,"overs":4,"runs_conceded":32,"wickets":3,"maidens":0,"econ":"8.00"}],"commentaries":[{"event_id":"12297145","event":"ball","batsman_id":"49413","bowler_id":"49524","over":"15","ball":"3","score":4,"commentary":"Benny Howell to Tom Abell, Four,","noball_dismissal":false,"text":"","timestamp":1751821888,"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":"12297147","event":"ball","batsman_id":"49413","bowler_id":"49524","over":"15","ball":"4","score":1,"commentary":"Benny Howell to Tom Abell, 1 run,","noball_dismissal":false,"text":"","timestamp":1751821890,"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":"12297158","event":"wicket","batsman_id":"49823","bowler_id":"49524","over":"15","ball":"5","score":"w","commentary":"Benny Howell to Sean Dickson, no run, c L Dawson b BAC Howell,","noball_dismissal":false,"text":"","timestamp":1751825187,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"49823","how_out":"c L Dawson b BAC Howell","batsman_runs":"52","batsman_balls":"33"},{"event_id":"12297208","event":"ball","batsman_id":"93520","bowler_id":"49524","over":"15","ball":"6","score":2,"commentary":"Benny Howell to Tom Lammonby, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751822232,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":16,"runs":11,"score":"141\/4","bats":[{"runs":2,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":93520},{"runs":36,"balls_faced":24,"fours":5,"sixes":0,"batsman_id":49413}],"bowls":[{"runs_conceded":32,"maidens":0,"wickets":1,"bowler_id":49524,"overs":3},{"runs_conceded":29,"maidens":0,"wickets":1,"bowler_id":1945,"overs":4}],"commentary":"End of over 16 (11 runs), Somerset 141\/4"},{"event_id":"12297209","event":"ball","batsman_id":"49413","bowler_id":"96605","over":"16","ball":"1","score":1,"commentary":"Scott Currie to Tom Abell, 1 run,","noball_dismissal":false,"text":"","timestamp":1751822235,"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":"12297210","event":"ball","batsman_id":"93520","bowler_id":"96605","over":"16","ball":"2","score":1,"commentary":"Scott Currie to Tom Lammonby, 1 run,","noball_dismissal":false,"text":"","timestamp":1751822238,"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":"12297216","event":"wicket","batsman_id":"49413","bowler_id":"96605","over":"16","ball":"3","score":"w","commentary":"Scott Currie to Tom Abell, no run, c & b S Currie,","noball_dismissal":false,"text":"","timestamp":1751822240,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"49413","how_out":"c & b S Currie","batsman_runs":"37","batsman_balls":"26"},{"event_id":"12297253","event":"ball","batsman_id":"1049","bowler_id":"96605","over":"16","ball":"4","score":1,"commentary":"Scott Currie to Ben Green, 1 run,","noball_dismissal":false,"text":"","timestamp":1751822498,"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":"12297256","event":"ball","batsman_id":"93520","bowler_id":"96605","over":"16","ball":"5","score":1,"commentary":"Scott Currie to Tom Lammonby, 1 run,","noball_dismissal":false,"text":"","timestamp":1751822501,"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":"12297259","event":"ball","batsman_id":"1049","bowler_id":"96605","over":"16","ball":"6","score":1,"commentary":"Scott Currie to Ben Green, 1 run,","noball_dismissal":false,"text":"","timestamp":1751822504,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":17,"runs":5,"score":"146\/5","bats":[{"runs":2,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":1049},{"runs":4,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":93520}],"bowls":[{"runs_conceded":20,"maidens":0,"wickets":2,"bowler_id":96605,"overs":3},{"runs_conceded":32,"maidens":0,"wickets":1,"bowler_id":49524,"overs":3}],"commentary":"End of over 17 (5 runs), Somerset 146\/5"},{"event_id":"12297267","event":"ball","batsman_id":"1049","bowler_id":"108409","over":"17","ball":"1","score":1,"commentary":"Sonny Baker to Ben Green, 1 run,","noball_dismissal":false,"text":"","timestamp":1751822635,"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":"12297269","event":"ball","batsman_id":"93520","bowler_id":"108409","over":"17","ball":"2","score":1,"commentary":"Sonny Baker to Tom Lammonby, 1 run,","noball_dismissal":false,"text":"","timestamp":1751822638,"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":"12297286","event":"ball","batsman_id":"1049","bowler_id":"108409","over":"17","ball":"3","score":1,"commentary":"Sonny Baker to Ben Green, 1 run,","noball_dismissal":false,"text":"","timestamp":1751822641,"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":"12297287","event":"ball","batsman_id":"93520","bowler_id":"108409","over":"17","ball":"4","score":2,"commentary":"Sonny Baker to Tom Lammonby, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751822649,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12297288","event":"ball","batsman_id":"93520","bowler_id":"108409","over":"17","ball":"5","score":4,"commentary":"Sonny Baker to Tom Lammonby, Four,","noball_dismissal":false,"text":"","timestamp":1751822652,"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":"12297322","event":"ball","batsman_id":"93520","bowler_id":"108409","over":"17","ball":"6","score":"1lb","commentary":"Sonny Baker to Tom Lammonby, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1751822925,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"1","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":18,"runs":10,"score":"156\/5","bats":[{"runs":11,"balls_faced":7,"fours":1,"sixes":0,"batsman_id":93520},{"runs":4,"balls_faced":4,"fours":0,"sixes":0,"batsman_id":1049}],"bowls":[{"runs_conceded":27,"maidens":0,"wickets":0,"bowler_id":108409,"overs":3},{"runs_conceded":20,"maidens":0,"wickets":2,"bowler_id":96605,"overs":3}],"commentary":"End of over 18 (10 runs), Somerset 156\/5"},{"event_id":"12297333","event":"ball","batsman_id":"93520","bowler_id":"96605","over":"18","ball":"1","score":0,"commentary":"Scott Currie to Tom Lammonby, no run,","noball_dismissal":false,"text":"","timestamp":1751822928,"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":"12297334","event":"wicket","batsman_id":"93520","bowler_id":"96605","over":"18","ball":"2","score":"w","commentary":"Scott Currie to Tom Lammonby, no run, c BAC Howell b S Currie,","noball_dismissal":false,"text":"","timestamp":1751822932,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"93520","how_out":"c BAC Howell b S Currie","batsman_runs":"11","batsman_balls":"9"},{"event_id":"12297338","event":"ball","batsman_id":"95554","bowler_id":"96605","over":"18","ball":"3","score":1,"commentary":"Scott Currie to Lewis Goldsworthy, 1 run,","noball_dismissal":false,"text":"","timestamp":1751822962,"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":"12297340","event":"ball","batsman_id":"1049","bowler_id":"96605","over":"18","ball":"4","score":4,"commentary":"Scott Currie to Ben Green, Four,","noball_dismissal":false,"text":"","timestamp":1751822964,"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":"12297342","event":"ball","batsman_id":"1049","bowler_id":"96605","over":"18","ball":"5","score":1,"commentary":"Scott Currie to Ben Green, 1 run,","noball_dismissal":false,"text":"","timestamp":1751822967,"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":"12297344","event":"ball","batsman_id":"95554","bowler_id":"96605","over":"18","ball":"6","score":6,"commentary":"Scott Currie to Lewis Goldsworthy, Six,","noball_dismissal":false,"text":"","timestamp":1751822969,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event":"overend","over":19,"runs":12,"score":"168\/6","bats":[{"runs":7,"balls_faced":2,"fours":0,"sixes":1,"batsman_id":95554},{"runs":9,"balls_faced":6,"fours":1,"sixes":0,"batsman_id":1049}],"bowls":[{"runs_conceded":32,"maidens":0,"wickets":3,"bowler_id":96605,"overs":4},{"runs_conceded":27,"maidens":0,"wickets":0,"bowler_id":108409,"overs":3}],"commentary":"End of over 19 (12 runs), Somerset 168\/6"},{"event_id":"12297353","event":"ball","batsman_id":"1049","bowler_id":"108409","over":"19","ball":"1","score":1,"commentary":"Sonny Baker to Ben Green, 1 run,","noball_dismissal":false,"text":"","timestamp":1751823032,"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":"12297358","event":"ball","batsman_id":"95554","bowler_id":"108409","over":"19","ball":"2","score":1,"commentary":"Sonny Baker to Lewis Goldsworthy, 1 run,","noball_dismissal":false,"text":"","timestamp":1751823216,"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":"12297374","event":"ball","batsman_id":"1049","bowler_id":"108409","over":"19","ball":"3","score":6,"commentary":"Sonny Baker to Ben Green, Six,","noball_dismissal":false,"text":"","timestamp":1751823219,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12297375","event":"ball","batsman_id":"1049","bowler_id":"108409","over":"19","ball":"4","score":2,"commentary":"Sonny Baker to Ben Green, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751823223,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12297377","event":"ball","batsman_id":"1049","bowler_id":"108409","over":"19","ball":"5","score":1,"commentary":"Sonny Baker to Ben Green, 1 run,","noball_dismissal":false,"text":"","timestamp":1751824845,"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}],"day":"0","session":"0","live_inning":{"iid":199223,"number":2,"name":"Somerset Inning","short_name":"SOM Inning","status":2,"issuperover":"false","result":3,"batting_team_id":7010,"fielding_team_id":7047,"scores":"179\/6","scores_full":"179\/6 (19.5 ov)","fielder":[{"fielder_id":"1949","fielder_name":"James Vince","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"108377","fielder_name":"Toby Albert","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"96605","fielder_name":"Scott Currie","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"1945","fielder_name":"Liam Dawson","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"49524","fielder_name":"Benny Howell","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":"Tom Lammonby","batsman_id":"93520","runs":"11","balls":"9","how_out":"c BAC Howell b S Currie","score_at_dismissal":156,"overs_at_dismissal":"18.2","bowler_id":"96605","dismissal":"caught","number":6},"extra_runs":{"byes":4,"legbyes":3,"wides":0,"noballs":0,"penalty":"0","total":7},"equations":{"runs":179,"wickets":6,"overs":"19.5","bowlers_used":6,"runrate":"9.03"},"current_partnership":{"runs":23,"balls":9,"overs":1.3,"batsmen":[{"name":"Lewis Goldsworthy","batsman_id":95554,"runs":8,"balls":3},{"name":"Ben Green","batsman_id":1049,"runs":15,"balls":6}]},"did_not_bat":[{"player_id":"49733","name":"Craig Overton"},{"player_id":"486","name":"Matt Henry"},{"player_id":"93329","name":"Riley Meredith"}],"max_over":"20","target":"179","recent_scores":"1,2,6,1,1,6,1,4,1,w,0,1,4,2,1,1,1,1","last_five_overs":"50\/3 10.00","last_ten_overs":"100\/3 10.00"},"teams":[{"tid":7010,"title":"Somerset","abbr":"SOM","alt_name":"SOM","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/somerset-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/somerset-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"179\/6 (19.5 ov)","scores":"179\/6","overs":"19.5"},{"tid":7047,"title":"Hampshire","abbr":"HAM","alt_name":"HAM","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/hampshire-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/hampshire-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"178\/3 (20 ov)","scores":"178\/3","overs":"20"}],"players":[{"pid":301,"title":"Josh Davey","short_name":"J Davey","first_name":"Josh Davey","last_name":"","middle_name":"","birthdate":"1990-08-03","birthplace":"Aberdeen, United Kingdom","country":"sct","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":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Scotland","role":"squad","role_str":""},{"pid":432,"title":"Kyle Abbott","short_name":"K Abbott","first_name":"Kyle Abbott","last_name":"","middle_name":"","birthdate":"1987-06-18","birthplace":"Empangeni, KwaZulu-Natal","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":486,"title":"Matt Henry","short_name":"M Henry","first_name":"Matt Henry","last_name":"","middle_name":"","birthdate":"1991-12-14","birthplace":"Christchurch, Canterbury","country":"nz","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bowl","role_str":""},{"pid":1049,"title":"Ben Green","short_name":"BGF Green","first_name":"Ben Green","last_name":"","middle_name":"","birthdate":"1997-09-28","birthplace":"Exeter, Devon","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":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":1945,"title":"Liam Dawson","short_name":"L Dawson","first_name":"Liam Dawson","last_name":"","middle_name":"","birthdate":"1990-03-01","birthplace":"Swindon, Wiltshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/daws128\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":1949,"title":"James Vince","short_name":"J Vince","first_name":"James Vince","last_name":"","middle_name":"","birthdate":"1991-03-14","birthplace":"Cuckfield, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/vincey14\/","twitter_profile":"https:\/\/twitter.com\/vincey14","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"pid":10606,"title":"Jake Ball","short_name":"JT Ball","first_name":"Jake Ball","last_name":"","middle_name":"","birthdate":"1991-03-14","birthplace":"Mansfield, Nottinghamshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":18974,"recent_appearance":1517109600,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/jakeball","instagram_profile":"https:\/\/www.instagram.com\/jakeball\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":32166,"title":"James Fuller","short_name":"JK Fuller","first_name":"James Fuller","last_name":"","middle_name":"","birthdate":"1990-01-24","birthplace":"Cape Town, Cape Province","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/James_Fuller246","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":43508,"title":"Chris Lynn","short_name":"CA Lynn","first_name":"Chris Lynn","last_name":"","middle_name":"","birthdate":"1990-04-10","birthplace":" Brisbane, Queensland","country":"au","primary_team":[],"logo_url":"","playing_role":"bat","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":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":46147,"title":"Bjorn Fortuin","short_name":"BC Fortuin","first_name":"Bjorn Fortuin","last_name":"","middle_name":"","birthdate":"1994-10-21","birthplace":"Paarl","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/bjorn_fortuin","instagram_profile":"https:\/\/www.instagram.com\/bjornfortuin\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":48656,"title":"Tom Kohler-Cadmore","short_name":"TK Cadmore","first_name":"Tom Kohler-Cadmore","last_name":"","middle_name":"","birthdate":"1994-08-19","birthplace":" Chatham, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/tomkholerCadmore32\/","twitter_profile":"https:\/\/twitter.com\/TomKCadmore32","instagram_profile":"https:\/\/www.instagram.com\/tomkcadmore","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"pid":49015,"title":"Andrew Umeed","short_name":"ARI Umeed","first_name":"Andrew Umeed","last_name":"","middle_name":"","birthdate":"1996-04-19","birthplace":"Glasgow, Lanarkshire","country":"sct","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":"Scotland","role":"squad","role_str":""},{"pid":49334,"title":"Ben Brown","short_name":"BC Brown","first_name":"Ben Brown","last_name":"","middle_name":"","birthdate":"1988-11-23","birthplace":"Crawley, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper ","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Ben_Brown26","instagram_profile":"https:\/\/www.instagram.com\/benbrown26\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49343,"title":"Nick Gubbins","short_name":"NRT Gubbins","first_name":"Nick Gubbins","last_name":"","middle_name":"","birthdate":"1993-12-31","birthplace":"Richmond, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49413,"title":"Tom Abell","short_name":"TB Abell","first_name":"Tom Abell","last_name":"","middle_name":"","birthdate":"1994-03-05","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":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/tomabell1","instagram_profile":"https:\/\/www.instagram.com\/tabell28\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":49421,"title":"Lewis Gregory","short_name":"L Gregory","first_name":"Lewis Gregory","last_name":"","middle_name":"","birthdate":"1992-05-24","birthplace":"Plymouth","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/lewisgregory23\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49425,"title":"Jack Leach","short_name":"J Leach","first_name":"Jack Leach","last_name":"","middle_name":"","birthdate":"1991-06-22","birthplace":" Taunton, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/jackleach1991?lang=gu","instagram_profile":"https:\/\/www.instagram.com\/mjleach17\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49478,"title":"Chris Wood","short_name":"CP Wood","first_name":"Chris Wood","last_name":"","middle_name":"","birthdate":"1990-06-27","birthplace":"Basingstoke, Hampshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/CWoody27","instagram_profile":"https:\/\/www.instagram.com\/cwood25\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":49524,"title":"Benny Howell","short_name":"BAC Howell","first_name":"Benny Howell","last_name":"","middle_name":"","birthdate":"1988-10-05","birthplace":"Bordeaux, France","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/BennyHowellOfficial\/","twitter_profile":"https:\/\/twitter.com\/bennytweets_","instagram_profile":"https:\/\/www.instagram.com\/bennycam13\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":49536,"title":"Mark Stoneman","short_name":"MD Stoneman","first_name":"Mark Stoneman","last_name":"","middle_name":"","birthdate":"1987-06-26","birthplace":"Newcastle upon Tyne, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":18968,"recent_appearance":1514244600,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/mark23stone","instagram_profile":"https:\/\/www.instagram.com\/mark23stone\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49733,"title":"Craig Overton","short_name":"C Overton","first_name":"Craig Overton","last_name":"","middle_name":"","birthdate":"1994-04-10","birthplace":"Barnstaple, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/craigoverton12","instagram_profile":"https:\/\/www.instagram.com\/craigoverton12\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":49823,"title":"Sean Dickson","short_name":"SR Dickson","first_name":"Sean Dickson","last_name":"","middle_name":"","birthdate":"1991-09-02","birthplace":"Johannesburg, Transvaal","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bat","role_str":""},{"pid":50481,"title":"Felix Organ","short_name":"FS Organ","first_name":"Felix Organ","last_name":"","middle_name":"","birthdate":"1999-06-02","birthplace":"Sydney","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50484,"title":"Brad Wheal","short_name":"BTJ Wheal","first_name":"Brad Wheal","last_name":"","middle_name":"","birthdate":"1996-08-28","birthplace":"Durban, KwaZulu-Natal","country":"sct","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"https:\/\/www.facebook.com\/brad.wheal\/","twitter_profile":"https:\/\/twitter.com\/BradWheal","instagram_profile":"https:\/\/www.instagram.com\/bradwheal\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Scotland","role":"squad","role_str":""},{"pid":51266,"title":"Tom Banton","short_name":"T Banton","first_name":"Tom Banton","last_name":"","middle_name":"","birthdate":"1998-11-11","birthplace":"Chiltern, Buckinghamshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/OfficialTomBanton\/","twitter_profile":"https:\/\/twitter.com\/tbanton18","instagram_profile":"https:\/\/www.instagram.com\/tombanton\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":51285,"title":"Joe Weatherley","short_name":"JJ Weatherley","first_name":"Joe Weatherley","last_name":"","middle_name":"","birthdate":"1997-01-19","birthplace":"Winchester, Hampshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Joe_Weatherley","instagram_profile":"https:\/\/www.instagram.com\/jjweatherley\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":55591,"title":"Hilton Cartwright","short_name":"H Cartwright","first_name":"Hilton Cartwright","last_name":"","middle_name":"","birthdate":"1992-02-14","birthplace":"Harare, Zimbabwe","country":"au","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/HiltonC149","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"bat","role_str":""},{"pid":57592,"title":"Migael Pretorius","short_name":"M Pretorius","first_name":"Migael Pretorius","last_name":"","middle_name":"","birthdate":"1995-03-24","birthplace":"Vereeninging","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"https:\/\/www.facebook.com\/migael27\/","twitter_profile":"https:\/\/twitter.com\/migael_27","instagram_profile":"https:\/\/www.instagram.com\/migael27\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":93329,"title":"Riley Meredith","short_name":"RP Meredith","first_name":"Riley Meredith","last_name":"","middle_name":"","birthdate":"1996-06-21","birthplace":"Hobart, Tasmania","country":"au","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/rileymeredith_\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"bowl","role_str":""},{"pid":93520,"title":"Tom Lammonby","short_name":"TA Lammonby","first_name":"Tom Lammonby","last_name":"","middle_name":"","birthdate":"2000-06-02","birthplace":" Exeter, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left 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":"https:\/\/twitter.com\/TomLammonby","instagram_profile":"https:\/\/www.instagram.com\/tom_lammonby\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":95554,"title":"Lewis Goldsworthy","short_name":"L Goldsworthy","first_name":"Lewis Goldsworthy","last_name":"","middle_name":"","birthdate":"2001-01-08","birthplace":" Cornwall","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lewigoldsworthy","instagram_profile":"https:\/\/www.instagram.com\/lewisgoldsworthy\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":96605,"title":"Scott Currie","short_name":"S Currie","first_name":"Scott Currie","last_name":"","middle_name":"","birthdate":"2001-05-02","birthplace":"Poole, Dorset","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":103052,"title":"Will Smeed","short_name":"W Smeed","first_name":"Will Smeed","last_name":"","middle_name":"","birthdate":"2001-10-26","birthplace":"Cambridge","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/will_smeed","instagram_profile":"https:\/\/www.instagram.com\/willsmeed\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":108376,"title":"Tom Prest","short_name":"T Prest","first_name":"Tom Prest","last_name":"","middle_name":"","birthdate":"2003-03-24","birthplace":"Wimborne, Dorset","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108377,"title":"Toby Albert","short_name":"T Albert","first_name":"Toby Albert","last_name":"","middle_name":"","birthdate":"2001-11-12","birthplace":"Basingstoke, Hampshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":108378,"title":"Fletcha Middleton","short_name":"F Middleton","first_name":"Fletcha Middleton","last_name":"","middle_name":"","birthdate":"2002-01-31","birthplace":"Winchester, Hampshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108381,"title":"John Turner","short_name":"J Turner","first_name":"John Turner","last_name":"","middle_name":"","birthdate":"2001-04-10","birthplace":"Johannesburg, Gauteng","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108408,"title":"James Rew","short_name":"J Rew","first_name":"James Rew","last_name":"","middle_name":"","birthdate":"2004-01-11","birthplace":" London","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/cjrew89\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108409,"title":"Sonny Baker","short_name":"S Baker","first_name":"Sonny Baker","last_name":"","middle_name":"","birthdate":"2003-03-13","birthplace":"Torbay, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/sonnybaker\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":108410,"title":"Joshua Thomas","short_name":"J Thomas","first_name":"Joshua 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":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":"bat","role_str":""},{"pid":110871,"title":"Dewald Brevis","short_name":"D Brevis","first_name":"Dewald Brevis","last_name":"","middle_name":"","birthdate":"2003-04-29","birthplace":"Johannesburg","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/Brevis17\/","twitter_profile":"https:\/\/twitter.com\/BrevisDewald","instagram_profile":"https:\/\/www.instagram.com\/dewald_brevis_17\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":118936,"title":"Eddie Jack","short_name":"EV Jack","first_name":"Eddie Jack","last_name":"","middle_name":"","birthdate":"2005-09-09","birthplace":"Barnet, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":128989,"title":"Lhuan dre Pretorius","short_name":"Ld Pretorius","first_name":"Lhuan dre Pretorius","last_name":"","middle_name":"","birthdate":"2006-03-27","birthplace":"Potchefstroom","country":"za","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":129894,"title":"JT Langridge","short_name":"JT Langridge","first_name":"JT Langridge","last_name":"","middle_name":"","birthdate":"2005-11-03","birthplace":" Plymouth, Devon,","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":130425,"title":"Finley Hill","short_name":"F Hill","first_name":"Finley Hill","last_name":"","middle_name":"","birthdate":"2006-06-21","birthplace":" Exeter, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":137372,"title":"Archie Vaughan","short_name":"A Vaughan","first_name":"Archie Vaughan","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":146438,"title":"Thomas Rew","short_name":"T Rew","first_name":"Thomas Rew","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","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":""}]},"etag":"a23bb686a56049e4ac837337280d2b8e","modified":"2025-07-15 16:54:13","datetime":"2025-07-15 16:54:13","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86904 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:d97ba01e-a7a1-4c7f-9351-dd51aa7c4240
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86904 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86904,3,'{"status":"ok","response":{"match_id":86904,"title":"Hampshire vs Somerset","short_title":"HAM vs SOM","subtitle":"Match 84","match_number":"84","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Somerset won by 4 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129425,"title":"Vitality Blast","abbr":"Vitality Blast","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-09-13","country":"en","total_matches":"133","total_rounds":"2","total_teams":"18"},"teama":{"team_id":7047,"name":"Hampshire","short_name":"HAM","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/hampshire-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/hampshire-logo.png","scores_full":"178\/3 (20 ov)","scores":"178\/3","overs":"20"},"teamb":{"team_id":7010,"name":"Somerset","short_name":"SOM","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/somerset-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/somerset-logo.png","scores_full":"179\/6 (19.5 ov)","scores":"179\/6","overs":"19.5"},"date_start":"2025-07-06 14:00:00","date_end":"2025-07-07 00:00:00","timestamp_start":1751810400,"timestamp_end":1751846400,"date_start_ist":"2025-07-06 19:30:00","date_end_ist":"2025-07-07 05:30:00","venue":{"venue_id":"9","name":"The Rose Bowl","location":"Southampton","country":"England","timezone":""},"umpires":" Mike Burns (England), Benjamin John Peverall (England)","referee":"Sarah Bartlett (England)","equation":"","live":"","result":"SOM won by 4 wickets","result_type":2,"win_margin":"4 wickets","winning_team_id":7010,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-07-05 21:16:43","verify_time":"2025-07-06 23:47:41","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"broken clouds","temp":20.11,"humidity":64,"visibility":10000,"wind_speed":"13.31","clouds":52},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Somerset elected to bowl","winner":7010,"decision":2}},"etag":"d6f507ccbab0900597b48fdce91caad3","modified":"2025-07-15 16:54:14","datetime":"2025-07-15 16:54:14","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":86904,"title":"Hampshire vs Somerset","short_title":"HAM vs SOM","subtitle":"Match 84","match_number":"84","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Somerset won by 4 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129425,"title":"Vitality Blast","abbr":"Vitality Blast","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-09-13","country":"en","total_matches":"133","total_rounds":"2","total_teams":"18"},"teama":{"team_id":7047,"name":"Hampshire","short_name":"HAM","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/hampshire-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/hampshire-logo.png","scores_full":"178\/3 (20 ov)","scores":"178\/3","overs":"20"},"teamb":{"team_id":7010,"name":"Somerset","short_name":"SOM","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/somerset-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/somerset-logo.png","scores_full":"179\/6 (19.5 ov)","scores":"179\/6","overs":"19.5"},"date_start":"2025-07-06 14:00:00","date_end":"2025-07-07 00:00:00","timestamp_start":1751810400,"timestamp_end":1751846400,"date_start_ist":"2025-07-06 19:30:00","date_end_ist":"2025-07-07 05:30:00","venue":{"venue_id":"9","name":"The Rose Bowl","location":"Southampton","country":"England","timezone":""},"umpires":" Mike Burns (England), Benjamin John Peverall (England)","referee":"Sarah Bartlett (England)","equation":"","live":"","result":"SOM won by 4 wickets","result_type":2,"win_margin":"4 wickets","winning_team_id":7010,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-07-05 21:16:43","verify_time":"2025-07-06 23:47:41","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"broken clouds","temp":20.11,"humidity":64,"visibility":10000,"wind_speed":"13.31","clouds":52},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Somerset elected to bowl","winner":7010,"decision":2}},"etag":"d6f507ccbab0900597b48fdce91caad3","modified":"2025-07-15 16:54:14","datetime":"2025-07-15 16:54:14","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86904 AND DataTypeId = 3 END Live Report & Scorecard of Hampshire vs Somerset Match 84
Hampshire vs Somerset, Live Cricket Commentary