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:0da4b10a-7023-42fa-ba97-9a7fa47df091
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86911 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86911,1,'{"status":"ok","response":{"mid":86911,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Hampshire won by 3 wickets","day_remaining_over":"","team_batting":"Hampshire","team_bowling":"Middlesex","live_inning_number":2,"live_score":{"runs":188,"overs":19.4,"wickets":7,"target":188,"runrate":9.56,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"James Fuller","batsman_id":32166,"runs":43,"balls_faced":26,"fours":3,"sixes":2,"strike_rate":"165.38"},{"name":"Eddie Jack","batsman_id":118936,"runs":3,"balls_faced":3,"fours":0,"sixes":0,"strike_rate":"100.00"}],"bowlers":[{"name":"Ryan Higgins","bowler_id":49930,"overs":3.4,"runs_conceded":45,"wickets":2,"maidens":0,"econ":"12.27"},{"name":"Tom Helm","bowler_id":49497,"overs":4,"runs_conceded":27,"wickets":1,"maidens":0,"econ":"6.75"}],"commentaries":[{"event_id":"12315016","event":"ball","batsman_id":"32166","bowler_id":"49497","over":"15","ball":"3","score":1,"commentary":"Tom Helm to James Fuller, 1 run,","noball_dismissal":false,"text":"","timestamp":1752086777,"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":"12315017","event":"ball","batsman_id":"49524","bowler_id":"49497","over":"15","ball":"4","score":0,"commentary":"Tom Helm to Benny Howell, no run,","noball_dismissal":false,"text":"","timestamp":1752086782,"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":"12315018","event":"ball","batsman_id":"49524","bowler_id":"49497","over":"15","ball":"5","score":1,"commentary":"Tom Helm to Benny Howell, 1 run,","noball_dismissal":false,"text":"","timestamp":1752086812,"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":"12315023","event":"ball","batsman_id":"32166","bowler_id":"49497","over":"15","ball":"6","score":1,"commentary":"Tom Helm to James Fuller, 1 run,","noball_dismissal":false,"text":"","timestamp":1752086821,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":16,"runs":6,"score":"135\/5","bats":[{"runs":11,"balls_faced":12,"fours":1,"sixes":0,"batsman_id":32166},{"runs":5,"balls_faced":7,"fours":0,"sixes":0,"batsman_id":49524}],"bowls":[{"runs_conceded":17,"maidens":0,"wickets":1,"bowler_id":49497,"overs":3},{"runs_conceded":21,"maidens":0,"wickets":2,"bowler_id":93519,"overs":4}],"commentary":"End of over 16 (6 runs), Hampshire 135\/5"},{"event_id":"12315037","event":"ball","batsman_id":"32166","bowler_id":"49930","over":"16","ball":"1","score":6,"commentary":"Ryan Higgins to James Fuller, Six,","noball_dismissal":false,"text":"","timestamp":1752086909,"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":"12315042","event":"ball","batsman_id":"32166","bowler_id":"49930","over":"16","ball":"2","score":1,"commentary":"Ryan Higgins to James Fuller, 1 run,","noball_dismissal":false,"text":"","timestamp":1752086918,"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":"12315044","event":"ball","batsman_id":"49524","bowler_id":"49930","over":"16","ball":"3","score":6,"commentary":"Ryan Higgins to Benny Howell, Six,","noball_dismissal":false,"text":"","timestamp":1752086924,"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":"12315053","event":"wicket","batsman_id":"49524","bowler_id":"49930","over":"16","ball":"4","score":"w","commentary":"Ryan Higgins to Benny Howell, no run, b RF Higgins,","noball_dismissal":false,"text":"","timestamp":1752086959,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"49524","how_out":"b RF Higgins","batsman_runs":"11","batsman_balls":"9"},{"event_id":"12315078","event":"ball","batsman_id":"1945","bowler_id":"49930","over":"16","ball":"5","score":4,"commentary":"Ryan Higgins to Liam Dawson, Four,","noball_dismissal":false,"text":"","timestamp":1752087151,"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":"12315080","event":"ball","batsman_id":"1945","bowler_id":"49930","over":"16","ball":"6","score":1,"commentary":"Ryan Higgins to Liam Dawson, 1 run,","noball_dismissal":false,"text":"","timestamp":1752087161,"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":18,"score":"153\/6","bats":[{"runs":5,"balls_faced":2,"fours":1,"sixes":0,"batsman_id":1945},{"runs":18,"balls_faced":14,"fours":1,"sixes":1,"batsman_id":32166}],"bowls":[{"runs_conceded":35,"maidens":0,"wickets":2,"bowler_id":49930,"overs":3},{"runs_conceded":17,"maidens":0,"wickets":1,"bowler_id":49497,"overs":3}],"commentary":"End of over 17 (18 runs), Hampshire 153\/6"},{"event_id":"12315099","event":"ball","batsman_id":"1945","bowler_id":"140007","over":"17","ball":"1","score":1,"commentary":"Noah Cornwell to Liam Dawson, 1 run,","noball_dismissal":false,"text":"","timestamp":1752087319,"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":"12315100","event":"ball","batsman_id":"32166","bowler_id":"140007","over":"17","ball":"2","score":1,"commentary":"Noah Cornwell to James Fuller, 1 run,","noball_dismissal":false,"text":"","timestamp":1752087322,"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":"12315105","event":"wicket","batsman_id":"1945","bowler_id":"140007","over":"17","ball":"3","score":"w","commentary":"Noah Cornwell to Liam Dawson, no run, c RF Higgins b N Cornwell,","noball_dismissal":false,"text":"","timestamp":1752087325,"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":"1945","how_out":"c RF Higgins b N Cornwell","batsman_runs":"6","batsman_balls":"4"},{"event_id":"12315120","event":"ball","batsman_id":"118936","bowler_id":"140007","over":"17","ball":"4","score":1,"commentary":"Noah Cornwell to Eddie Jack, 1 run,","noball_dismissal":false,"text":"","timestamp":1752087759,"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":"12315122","event":"ball","batsman_id":"32166","bowler_id":"140007","over":"17","ball":"5","score":0,"commentary":"Noah Cornwell to James Fuller, no run,","noball_dismissal":false,"text":"","timestamp":1752087764,"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":"12315150","event":"ball","batsman_id":"32166","bowler_id":"140007","over":"17","ball":"6","score":"6nb","commentary":"Noah Cornwell to James Fuller, 6 no ball,","noball_dismissal":false,"text":"","timestamp":1752088306,"run":6,"noball_run":"1","wide_run":"0","bye_run":"5","legbye_run":"0","bat_run":"0","noball":true,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12315153","event":"ball","batsman_id":"32166","bowler_id":"53281","over":"17","ball":"6","score":6,"commentary":"Leus du Plooy to James Fuller, Six,","noball_dismissal":false,"text":"","timestamp":1752088954,"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":18,"runs":15,"score":"168\/7","bats":[{"runs":25,"balls_faced":18,"fours":1,"sixes":2,"batsman_id":32166},{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":118936}],"bowls":[{"runs_conceded":6,"maidens":0,"wickets":0,"bowler_id":53281,"overs":0.1},{"runs_conceded":35,"maidens":0,"wickets":2,"bowler_id":140007,"overs":3.5}],"commentary":"End of over 18 (15 runs), Hampshire 168\/7"},{"event_id":"12315159","event":"ball","batsman_id":"118936","bowler_id":"49497","over":"18","ball":"1","score":1,"commentary":"Tom Helm to Eddie Jack, 1 run,","noball_dismissal":false,"text":"","timestamp":1752087897,"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":"12315160","event":"ball","batsman_id":"32166","bowler_id":"49497","over":"18","ball":"2","score":2,"commentary":"Tom Helm to James Fuller, 2 runs,","noball_dismissal":false,"text":"","timestamp":1752087905,"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":"12315163","event":"ball","batsman_id":"32166","bowler_id":"49497","over":"18","ball":"3","score":2,"commentary":"Tom Helm to James Fuller, 2 runs,","noball_dismissal":false,"text":"","timestamp":1752087909,"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":"12315166","event":"ball","batsman_id":"32166","bowler_id":"49497","over":"18","ball":"4","score":2,"commentary":"Tom Helm to James Fuller, 2 runs,","noball_dismissal":false,"text":"","timestamp":1752087913,"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":"12315167","event":"ball","batsman_id":"32166","bowler_id":"49497","over":"18","ball":"5","score":2,"commentary":"Tom Helm to James Fuller, 2 runs,","noball_dismissal":false,"text":"","timestamp":1752087916,"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":"12315168","event":"ball","batsman_id":"32166","bowler_id":"49497","over":"18","ball":"6","score":1,"commentary":"Tom Helm to James Fuller, 1 run,","noball_dismissal":false,"text":"","timestamp":1752087967,"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":19,"runs":10,"score":"178\/7","bats":[{"runs":34,"balls_faced":23,"fours":1,"sixes":2,"batsman_id":32166},{"runs":2,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":118936}],"bowls":[{"runs_conceded":27,"maidens":0,"wickets":1,"bowler_id":49497,"overs":4},{"runs_conceded":6,"maidens":0,"wickets":0,"bowler_id":53281,"overs":0.1}],"commentary":"End of over 19 (10 runs), Hampshire 178\/7"},{"event_id":"12315180","event":"ball","batsman_id":"32166","bowler_id":"49930","over":"19","ball":"1","score":1,"commentary":"Ryan Higgins to James Fuller, 1 run,","noball_dismissal":false,"text":"","timestamp":1752088061,"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":"12315181","event":"ball","batsman_id":"118936","bowler_id":"49930","over":"19","ball":"2","score":1,"commentary":"Ryan Higgins to Eddie Jack, 1 run,","noball_dismissal":false,"text":"","timestamp":1752088065,"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":"12315184","event":"ball","batsman_id":"32166","bowler_id":"49930","over":"19","ball":"3","score":4,"commentary":"Ryan Higgins to James Fuller, Four,","noball_dismissal":false,"text":"","timestamp":1752088070,"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":"12315185","event":"ball","batsman_id":"32166","bowler_id":"49930","over":"19","ball":"4","score":4,"commentary":"Ryan Higgins to James Fuller, Four,","noball_dismissal":false,"text":"","timestamp":1752088074,"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}],"day":"0","session":"0","live_inning":{"iid":199384,"number":2,"name":"Hampshire Inning","short_name":"HAM Inning","status":2,"issuperover":"false","result":3,"batting_team_id":7047,"fielding_team_id":7044,"scores":"188\/7","scores_full":"188\/7 (19.4 ov)","fielder":[{"fielder_id":"93519","fielder_name":"Luke Hollman","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"53281","fielder_name":"Leus du Plooy","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"101478","fielder_name":"Joe Benjamin Cracknell","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"49930","fielder_name":"Ryan Higgins","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":"Liam Dawson","batsman_id":"1945","runs":"6","balls":"4","how_out":"c RF Higgins b N Cornwell","score_at_dismissal":155,"overs_at_dismissal":"17.3","bowler_id":"140007","dismissal":"caught","number":7},"extra_runs":{"byes":4,"legbyes":1,"wides":0,"noballs":4,"penalty":"0","total":9},"equations":{"runs":188,"wickets":7,"overs":"19.4","bowlers_used":6,"runrate":"9.56"},"current_partnership":{"runs":33,"balls":14,"overs":2.2,"batsmen":[{"name":"Eddie Jack","batsman_id":118936,"runs":3,"balls":3},{"name":"James Fuller","batsman_id":32166,"runs":24,"balls":11}]},"did_not_bat":[{"player_id":"96605","name":"Scott Currie"},{"player_id":"108409","name":"Sonny Baker"}],"max_over":"20","target":"188","recent_scores":"4,4,1,1,1,2,2,2,2,1,6,6,0,1,w,1,1,1","last_five_overs":"60\/2 11.61","last_ten_overs":"104\/4 10.23"},"teams":[{"tid":7044,"title":"Middlesex","abbr":"MID","alt_name":"MID","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/middlesex-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/middlesex-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"187\/8 (20 ov)","scores":"187\/8","overs":"20"},{"tid":7047,"title":"Hampshire","abbr":"HAM","alt_name":"HAM","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/hampshire-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/hampshire-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"188\/7 (19.4 ov)","scores":"188\/7","overs":"19.4"}],"players":[{"pid":31,"title":"Kane Williamson","short_name":"K Williamson","first_name":"Kane Williamson","last_name":"","middle_name":"","birthdate":"1990-08-08","birthplace":"Tauranga","country":"nz","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/KaneWillTrain\/","twitter_profile":"https:\/\/twitter.com\/KaneWiliamson","instagram_profile":"https:\/\/www.instagram.com\/kane_s_w\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bat","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":1043,"title":"Max Holden","short_name":"MDE Holden","first_name":"Max Holden","last_name":"","middle_name":"","birthdate":"1997-12-18","birthplace":" Cambridge","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/maxholden_4","instagram_profile":"https:\/\/www.instagram.com\/maxholden4\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":1115,"title":"Josh Little","short_name":"JB Little","first_name":"Josh Little","last_name":"","middle_name":"","birthdate":"1999-11-01","birthplace":"Dublin","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/joshlittle13\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","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":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":44058,"title":"Zafar Gohar","short_name":"ZG Gohar","first_name":"Zafar Gohar","last_name":"","middle_name":"","birthdate":"1995-02-01","birthplace":"Lahore, Punjab","country":"pk","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":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/iamzafargohar","instagram_profile":"https:\/\/www.instagram.com\/iamzafargohar\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bowl","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":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":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":"squad","role_str":""},{"pid":49493,"title":"Sam Robson","short_name":"SD Robson","first_name":"Sam Robson","last_name":"","middle_name":"","birthdate":"1989-07-01","birthplace":"Paddington, Sydney, New South Wales","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"https:\/\/www.facebook.com\/samrobson664\/","twitter_profile":"https:\/\/twitter.com\/Samrobsonfans12","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49497,"title":"Tom Helm","short_name":"TG Helm","first_name":"Tom Helm","last_name":"","middle_name":"","birthdate":"1994-05-07","birthplace":"Stoke Mandeville Hospital, Buckinghamshire","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":"https:\/\/twitter.com\/TomHelm7","instagram_profile":"https:\/\/www.instagram.com\/helmy__7\/","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":49783,"title":"Toby Roland-Jones","short_name":"TS Roland-Jones","first_name":"Toby Roland-Jones","last_name":"","middle_name":"","birthdate":"1988-01-29","birthplace":"Ashford, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/tobyrj21","instagram_profile":"https:\/\/www.instagram.com\/tobyrj21\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49930,"title":"Ryan Higgins","short_name":"RF Higgins","first_name":"Ryan Higgins","last_name":"","middle_name":"","birthdate":"1995-01-06","birthplace":"Harare, Zimbabwe","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","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":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":53281,"title":"Leus du Plooy","short_name":"JLdu Plooy","first_name":"Leus du Plooy","last_name":"","middle_name":"","birthdate":"1995-01-12","birthplace":"Pretoria, Gauteng,","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","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\/leusdup76","instagram_profile":"https:\/\/www.instagram.com\/leusdup76\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bat","role_str":"(C)"},{"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":90974,"title":"Henry Brookes","short_name":"HJH Brookes","first_name":"Henry Brookes","last_name":"","middle_name":"","birthdate":"1999-08-21","birthplace":"Solihull, Warwickshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BrookesHenry","instagram_profile":"https:\/\/www.instagram.com\/henry.brookes\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":93517,"title":"Jack Davies","short_name":"JLB Davies","first_name":"Jack Davies","last_name":"","middle_name":"","birthdate":"2000-03-30","birthplace":"Reading, Berkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/daviesjlb","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":93519,"title":"Luke Hollman","short_name":"LBK Hollman","first_name":"Luke Hollman","last_name":"","middle_name":"","birthdate":"2000-09-16","birthplace":"Islington, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/lukehollman56\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":95552,"title":"Blake Cullen","short_name":"B Cullen","first_name":"Blake Cullen","last_name":"","middle_name":"","birthdate":"2002-02-19","birthplace":" Isleworth, Middlesex","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":96605,"title":"Scott Currie","short_name":"S Currie","first_name":"Scott Currie","last_name":"","middle_name":"","birthdate":"2001-05-02","birthplace":"Poole, Dorset","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":101478,"title":"Joe Benjamin Cracknell","short_name":"JB Cracknell","first_name":"Joe Benjamin Cracknell","last_name":"","middle_name":"","birthdate":"2000-03-16","birthplace":"Enfield, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/joe_cracknell\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":102540,"title":"Stephen Eskinazi","short_name":"S Eskinazi","first_name":"Stephen Eskinazi","last_name":"","middle_name":"","birthdate":"1994-03-28","birthplace":"Johannesburg, Transvaal, South Africa","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/seskinazi","instagram_profile":"https:\/\/www.instagram.com\/seskinazi\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","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":"bat","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":108382,"title":"Ben Geddes","short_name":"B Geddes","first_name":"Ben Geddes","last_name":"","middle_name":"","birthdate":"2001-07-31","birthplace":"Epsom, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","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":"bat","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":109051,"title":"Ali Orr","short_name":"AGH Orr","first_name":"Ali Orr","last_name":"","middle_name":"","birthdate":"2001-04-06","birthplace":"Eastbourne, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/alastairorr\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":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":116661,"title":"Ishaan Kaushal","short_name":"I Kaushal","first_name":"Ishaan Kaushal","last_name":"","middle_name":"","birthdate":"2002-02-09","birthplace":"Hillingdon, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":118572,"title":"Dominic Kelly","short_name":"DC Kelly","first_name":"Dominic Kelly","last_name":"","middle_name":"","birthdate":"2005-10-01","birthplace":"Winchester, Hampshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":118936,"title":"Eddie Jack","short_name":"EV Jack","first_name":"Eddie Jack","last_name":"","middle_name":"","birthdate":"2005-09-09","birthplace":"Barnet, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":127503,"title":"Josh De Caires","short_name":"J D caires","first_name":"Josh De Caires","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":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":129244,"title":"Nathan Fernandes","short_name":"N Fernandes","first_name":"Nathan Fernandes","last_name":"","middle_name":"","birthdate":"2004-04-26","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":133782,"title":"Sebastian Morgan","short_name":"SB Morgan","first_name":"Sebastian Morgan","last_name":"","middle_name":"","birthdate":"2007-08-30","birthplace":"","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":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":140007,"title":"Noah Cornwell","short_name":"N Cornwell","first_name":"Noah Cornwell","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":146167,"title":"Aaryan Sawant","short_name":"A Sawant","first_name":"Aaryan Sawant","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":146171,"title":"Naavya Sharma","short_name":"N Sharma","first_name":"Naavya Sharma","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""}]},"etag":"583226afa11e9c4cc4b94996ee060c58","modified":"2025-07-14 19:03:18","datetime":"2025-07-14 19:03:18","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":86911,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Hampshire won by 3 wickets","day_remaining_over":"","team_batting":"Hampshire","team_bowling":"Middlesex","live_inning_number":2,"live_score":{"runs":188,"overs":19.4,"wickets":7,"target":188,"runrate":9.56,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"James Fuller","batsman_id":32166,"runs":43,"balls_faced":26,"fours":3,"sixes":2,"strike_rate":"165.38"},{"name":"Eddie Jack","batsman_id":118936,"runs":3,"balls_faced":3,"fours":0,"sixes":0,"strike_rate":"100.00"}],"bowlers":[{"name":"Ryan Higgins","bowler_id":49930,"overs":3.4,"runs_conceded":45,"wickets":2,"maidens":0,"econ":"12.27"},{"name":"Tom Helm","bowler_id":49497,"overs":4,"runs_conceded":27,"wickets":1,"maidens":0,"econ":"6.75"}],"commentaries":[{"event_id":"12315016","event":"ball","batsman_id":"32166","bowler_id":"49497","over":"15","ball":"3","score":1,"commentary":"Tom Helm to James Fuller, 1 run,","noball_dismissal":false,"text":"","timestamp":1752086777,"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":"12315017","event":"ball","batsman_id":"49524","bowler_id":"49497","over":"15","ball":"4","score":0,"commentary":"Tom Helm to Benny Howell, no run,","noball_dismissal":false,"text":"","timestamp":1752086782,"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":"12315018","event":"ball","batsman_id":"49524","bowler_id":"49497","over":"15","ball":"5","score":1,"commentary":"Tom Helm to Benny Howell, 1 run,","noball_dismissal":false,"text":"","timestamp":1752086812,"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":"12315023","event":"ball","batsman_id":"32166","bowler_id":"49497","over":"15","ball":"6","score":1,"commentary":"Tom Helm to James Fuller, 1 run,","noball_dismissal":false,"text":"","timestamp":1752086821,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":16,"runs":6,"score":"135\/5","bats":[{"runs":11,"balls_faced":12,"fours":1,"sixes":0,"batsman_id":32166},{"runs":5,"balls_faced":7,"fours":0,"sixes":0,"batsman_id":49524}],"bowls":[{"runs_conceded":17,"maidens":0,"wickets":1,"bowler_id":49497,"overs":3},{"runs_conceded":21,"maidens":0,"wickets":2,"bowler_id":93519,"overs":4}],"commentary":"End of over 16 (6 runs), Hampshire 135\/5"},{"event_id":"12315037","event":"ball","batsman_id":"32166","bowler_id":"49930","over":"16","ball":"1","score":6,"commentary":"Ryan Higgins to James Fuller, Six,","noball_dismissal":false,"text":"","timestamp":1752086909,"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":"12315042","event":"ball","batsman_id":"32166","bowler_id":"49930","over":"16","ball":"2","score":1,"commentary":"Ryan Higgins to James Fuller, 1 run,","noball_dismissal":false,"text":"","timestamp":1752086918,"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":"12315044","event":"ball","batsman_id":"49524","bowler_id":"49930","over":"16","ball":"3","score":6,"commentary":"Ryan Higgins to Benny Howell, Six,","noball_dismissal":false,"text":"","timestamp":1752086924,"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":"12315053","event":"wicket","batsman_id":"49524","bowler_id":"49930","over":"16","ball":"4","score":"w","commentary":"Ryan Higgins to Benny Howell, no run, b RF Higgins,","noball_dismissal":false,"text":"","timestamp":1752086959,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"49524","how_out":"b RF Higgins","batsman_runs":"11","batsman_balls":"9"},{"event_id":"12315078","event":"ball","batsman_id":"1945","bowler_id":"49930","over":"16","ball":"5","score":4,"commentary":"Ryan Higgins to Liam Dawson, Four,","noball_dismissal":false,"text":"","timestamp":1752087151,"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":"12315080","event":"ball","batsman_id":"1945","bowler_id":"49930","over":"16","ball":"6","score":1,"commentary":"Ryan Higgins to Liam Dawson, 1 run,","noball_dismissal":false,"text":"","timestamp":1752087161,"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":18,"score":"153\/6","bats":[{"runs":5,"balls_faced":2,"fours":1,"sixes":0,"batsman_id":1945},{"runs":18,"balls_faced":14,"fours":1,"sixes":1,"batsman_id":32166}],"bowls":[{"runs_conceded":35,"maidens":0,"wickets":2,"bowler_id":49930,"overs":3},{"runs_conceded":17,"maidens":0,"wickets":1,"bowler_id":49497,"overs":3}],"commentary":"End of over 17 (18 runs), Hampshire 153\/6"},{"event_id":"12315099","event":"ball","batsman_id":"1945","bowler_id":"140007","over":"17","ball":"1","score":1,"commentary":"Noah Cornwell to Liam Dawson, 1 run,","noball_dismissal":false,"text":"","timestamp":1752087319,"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":"12315100","event":"ball","batsman_id":"32166","bowler_id":"140007","over":"17","ball":"2","score":1,"commentary":"Noah Cornwell to James Fuller, 1 run,","noball_dismissal":false,"text":"","timestamp":1752087322,"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":"12315105","event":"wicket","batsman_id":"1945","bowler_id":"140007","over":"17","ball":"3","score":"w","commentary":"Noah Cornwell to Liam Dawson, no run, c RF Higgins b N Cornwell,","noball_dismissal":false,"text":"","timestamp":1752087325,"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":"1945","how_out":"c RF Higgins b N Cornwell","batsman_runs":"6","batsman_balls":"4"},{"event_id":"12315120","event":"ball","batsman_id":"118936","bowler_id":"140007","over":"17","ball":"4","score":1,"commentary":"Noah Cornwell to Eddie Jack, 1 run,","noball_dismissal":false,"text":"","timestamp":1752087759,"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":"12315122","event":"ball","batsman_id":"32166","bowler_id":"140007","over":"17","ball":"5","score":0,"commentary":"Noah Cornwell to James Fuller, no run,","noball_dismissal":false,"text":"","timestamp":1752087764,"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":"12315150","event":"ball","batsman_id":"32166","bowler_id":"140007","over":"17","ball":"6","score":"6nb","commentary":"Noah Cornwell to James Fuller, 6 no ball,","noball_dismissal":false,"text":"","timestamp":1752088306,"run":6,"noball_run":"1","wide_run":"0","bye_run":"5","legbye_run":"0","bat_run":"0","noball":true,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12315153","event":"ball","batsman_id":"32166","bowler_id":"53281","over":"17","ball":"6","score":6,"commentary":"Leus du Plooy to James Fuller, Six,","noball_dismissal":false,"text":"","timestamp":1752088954,"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":18,"runs":15,"score":"168\/7","bats":[{"runs":25,"balls_faced":18,"fours":1,"sixes":2,"batsman_id":32166},{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":118936}],"bowls":[{"runs_conceded":6,"maidens":0,"wickets":0,"bowler_id":53281,"overs":0.1},{"runs_conceded":35,"maidens":0,"wickets":2,"bowler_id":140007,"overs":3.5}],"commentary":"End of over 18 (15 runs), Hampshire 168\/7"},{"event_id":"12315159","event":"ball","batsman_id":"118936","bowler_id":"49497","over":"18","ball":"1","score":1,"commentary":"Tom Helm to Eddie Jack, 1 run,","noball_dismissal":false,"text":"","timestamp":1752087897,"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":"12315160","event":"ball","batsman_id":"32166","bowler_id":"49497","over":"18","ball":"2","score":2,"commentary":"Tom Helm to James Fuller, 2 runs,","noball_dismissal":false,"text":"","timestamp":1752087905,"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":"12315163","event":"ball","batsman_id":"32166","bowler_id":"49497","over":"18","ball":"3","score":2,"commentary":"Tom Helm to James Fuller, 2 runs,","noball_dismissal":false,"text":"","timestamp":1752087909,"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":"12315166","event":"ball","batsman_id":"32166","bowler_id":"49497","over":"18","ball":"4","score":2,"commentary":"Tom Helm to James Fuller, 2 runs,","noball_dismissal":false,"text":"","timestamp":1752087913,"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":"12315167","event":"ball","batsman_id":"32166","bowler_id":"49497","over":"18","ball":"5","score":2,"commentary":"Tom Helm to James Fuller, 2 runs,","noball_dismissal":false,"text":"","timestamp":1752087916,"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":"12315168","event":"ball","batsman_id":"32166","bowler_id":"49497","over":"18","ball":"6","score":1,"commentary":"Tom Helm to James Fuller, 1 run,","noball_dismissal":false,"text":"","timestamp":1752087967,"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":19,"runs":10,"score":"178\/7","bats":[{"runs":34,"balls_faced":23,"fours":1,"sixes":2,"batsman_id":32166},{"runs":2,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":118936}],"bowls":[{"runs_conceded":27,"maidens":0,"wickets":1,"bowler_id":49497,"overs":4},{"runs_conceded":6,"maidens":0,"wickets":0,"bowler_id":53281,"overs":0.1}],"commentary":"End of over 19 (10 runs), Hampshire 178\/7"},{"event_id":"12315180","event":"ball","batsman_id":"32166","bowler_id":"49930","over":"19","ball":"1","score":1,"commentary":"Ryan Higgins to James Fuller, 1 run,","noball_dismissal":false,"text":"","timestamp":1752088061,"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":"12315181","event":"ball","batsman_id":"118936","bowler_id":"49930","over":"19","ball":"2","score":1,"commentary":"Ryan Higgins to Eddie Jack, 1 run,","noball_dismissal":false,"text":"","timestamp":1752088065,"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":"12315184","event":"ball","batsman_id":"32166","bowler_id":"49930","over":"19","ball":"3","score":4,"commentary":"Ryan Higgins to James Fuller, Four,","noball_dismissal":false,"text":"","timestamp":1752088070,"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":"12315185","event":"ball","batsman_id":"32166","bowler_id":"49930","over":"19","ball":"4","score":4,"commentary":"Ryan Higgins to James Fuller, Four,","noball_dismissal":false,"text":"","timestamp":1752088074,"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}],"day":"0","session":"0","live_inning":{"iid":199384,"number":2,"name":"Hampshire Inning","short_name":"HAM Inning","status":2,"issuperover":"false","result":3,"batting_team_id":7047,"fielding_team_id":7044,"scores":"188\/7","scores_full":"188\/7 (19.4 ov)","fielder":[{"fielder_id":"93519","fielder_name":"Luke Hollman","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"53281","fielder_name":"Leus du Plooy","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"101478","fielder_name":"Joe Benjamin Cracknell","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"49930","fielder_name":"Ryan Higgins","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":"Liam Dawson","batsman_id":"1945","runs":"6","balls":"4","how_out":"c RF Higgins b N Cornwell","score_at_dismissal":155,"overs_at_dismissal":"17.3","bowler_id":"140007","dismissal":"caught","number":7},"extra_runs":{"byes":4,"legbyes":1,"wides":0,"noballs":4,"penalty":"0","total":9},"equations":{"runs":188,"wickets":7,"overs":"19.4","bowlers_used":6,"runrate":"9.56"},"current_partnership":{"runs":33,"balls":14,"overs":2.2,"batsmen":[{"name":"Eddie Jack","batsman_id":118936,"runs":3,"balls":3},{"name":"James Fuller","batsman_id":32166,"runs":24,"balls":11}]},"did_not_bat":[{"player_id":"96605","name":"Scott Currie"},{"player_id":"108409","name":"Sonny Baker"}],"max_over":"20","target":"188","recent_scores":"4,4,1,1,1,2,2,2,2,1,6,6,0,1,w,1,1,1","last_five_overs":"60\/2 11.61","last_ten_overs":"104\/4 10.23"},"teams":[{"tid":7044,"title":"Middlesex","abbr":"MID","alt_name":"MID","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/middlesex-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/middlesex-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"187\/8 (20 ov)","scores":"187\/8","overs":"20"},{"tid":7047,"title":"Hampshire","abbr":"HAM","alt_name":"HAM","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/hampshire-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/hampshire-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"188\/7 (19.4 ov)","scores":"188\/7","overs":"19.4"}],"players":[{"pid":31,"title":"Kane Williamson","short_name":"K Williamson","first_name":"Kane Williamson","last_name":"","middle_name":"","birthdate":"1990-08-08","birthplace":"Tauranga","country":"nz","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/KaneWillTrain\/","twitter_profile":"https:\/\/twitter.com\/KaneWiliamson","instagram_profile":"https:\/\/www.instagram.com\/kane_s_w\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bat","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":1043,"title":"Max Holden","short_name":"MDE Holden","first_name":"Max Holden","last_name":"","middle_name":"","birthdate":"1997-12-18","birthplace":" Cambridge","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/maxholden_4","instagram_profile":"https:\/\/www.instagram.com\/maxholden4\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":1115,"title":"Josh Little","short_name":"JB Little","first_name":"Josh Little","last_name":"","middle_name":"","birthdate":"1999-11-01","birthplace":"Dublin","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/joshlittle13\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","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":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":44058,"title":"Zafar Gohar","short_name":"ZG Gohar","first_name":"Zafar Gohar","last_name":"","middle_name":"","birthdate":"1995-02-01","birthplace":"Lahore, Punjab","country":"pk","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":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/iamzafargohar","instagram_profile":"https:\/\/www.instagram.com\/iamzafargohar\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bowl","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":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":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":"squad","role_str":""},{"pid":49493,"title":"Sam Robson","short_name":"SD Robson","first_name":"Sam Robson","last_name":"","middle_name":"","birthdate":"1989-07-01","birthplace":"Paddington, Sydney, New South Wales","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"https:\/\/www.facebook.com\/samrobson664\/","twitter_profile":"https:\/\/twitter.com\/Samrobsonfans12","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49497,"title":"Tom Helm","short_name":"TG Helm","first_name":"Tom Helm","last_name":"","middle_name":"","birthdate":"1994-05-07","birthplace":"Stoke Mandeville Hospital, Buckinghamshire","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":"https:\/\/twitter.com\/TomHelm7","instagram_profile":"https:\/\/www.instagram.com\/helmy__7\/","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":49783,"title":"Toby Roland-Jones","short_name":"TS Roland-Jones","first_name":"Toby Roland-Jones","last_name":"","middle_name":"","birthdate":"1988-01-29","birthplace":"Ashford, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/tobyrj21","instagram_profile":"https:\/\/www.instagram.com\/tobyrj21\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49930,"title":"Ryan Higgins","short_name":"RF Higgins","first_name":"Ryan Higgins","last_name":"","middle_name":"","birthdate":"1995-01-06","birthplace":"Harare, Zimbabwe","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","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":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":53281,"title":"Leus du Plooy","short_name":"JLdu Plooy","first_name":"Leus du Plooy","last_name":"","middle_name":"","birthdate":"1995-01-12","birthplace":"Pretoria, Gauteng,","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","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\/leusdup76","instagram_profile":"https:\/\/www.instagram.com\/leusdup76\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bat","role_str":"(C)"},{"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":90974,"title":"Henry Brookes","short_name":"HJH Brookes","first_name":"Henry Brookes","last_name":"","middle_name":"","birthdate":"1999-08-21","birthplace":"Solihull, Warwickshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BrookesHenry","instagram_profile":"https:\/\/www.instagram.com\/henry.brookes\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":93517,"title":"Jack Davies","short_name":"JLB Davies","first_name":"Jack Davies","last_name":"","middle_name":"","birthdate":"2000-03-30","birthplace":"Reading, Berkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/daviesjlb","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":93519,"title":"Luke Hollman","short_name":"LBK Hollman","first_name":"Luke Hollman","last_name":"","middle_name":"","birthdate":"2000-09-16","birthplace":"Islington, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/lukehollman56\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":95552,"title":"Blake Cullen","short_name":"B Cullen","first_name":"Blake Cullen","last_name":"","middle_name":"","birthdate":"2002-02-19","birthplace":" Isleworth, Middlesex","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":96605,"title":"Scott Currie","short_name":"S Currie","first_name":"Scott Currie","last_name":"","middle_name":"","birthdate":"2001-05-02","birthplace":"Poole, Dorset","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":101478,"title":"Joe Benjamin Cracknell","short_name":"JB Cracknell","first_name":"Joe Benjamin Cracknell","last_name":"","middle_name":"","birthdate":"2000-03-16","birthplace":"Enfield, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/joe_cracknell\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":102540,"title":"Stephen Eskinazi","short_name":"S Eskinazi","first_name":"Stephen Eskinazi","last_name":"","middle_name":"","birthdate":"1994-03-28","birthplace":"Johannesburg, Transvaal, South Africa","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/seskinazi","instagram_profile":"https:\/\/www.instagram.com\/seskinazi\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","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":"bat","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":108382,"title":"Ben Geddes","short_name":"B Geddes","first_name":"Ben Geddes","last_name":"","middle_name":"","birthdate":"2001-07-31","birthplace":"Epsom, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","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":"bat","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":109051,"title":"Ali Orr","short_name":"AGH Orr","first_name":"Ali Orr","last_name":"","middle_name":"","birthdate":"2001-04-06","birthplace":"Eastbourne, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/alastairorr\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":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":116661,"title":"Ishaan Kaushal","short_name":"I Kaushal","first_name":"Ishaan Kaushal","last_name":"","middle_name":"","birthdate":"2002-02-09","birthplace":"Hillingdon, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":118572,"title":"Dominic Kelly","short_name":"DC Kelly","first_name":"Dominic Kelly","last_name":"","middle_name":"","birthdate":"2005-10-01","birthplace":"Winchester, Hampshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":118936,"title":"Eddie Jack","short_name":"EV Jack","first_name":"Eddie Jack","last_name":"","middle_name":"","birthdate":"2005-09-09","birthplace":"Barnet, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":127503,"title":"Josh De Caires","short_name":"J D caires","first_name":"Josh De Caires","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":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":129244,"title":"Nathan Fernandes","short_name":"N Fernandes","first_name":"Nathan Fernandes","last_name":"","middle_name":"","birthdate":"2004-04-26","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":133782,"title":"Sebastian Morgan","short_name":"SB Morgan","first_name":"Sebastian Morgan","last_name":"","middle_name":"","birthdate":"2007-08-30","birthplace":"","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":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":140007,"title":"Noah Cornwell","short_name":"N Cornwell","first_name":"Noah Cornwell","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":146167,"title":"Aaryan Sawant","short_name":"A Sawant","first_name":"Aaryan Sawant","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":146171,"title":"Naavya Sharma","short_name":"N Sharma","first_name":"Naavya Sharma","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""}]},"etag":"583226afa11e9c4cc4b94996ee060c58","modified":"2025-07-14 19:03:18","datetime":"2025-07-14 19:03:18","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86911 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:28b149b3-9d1e-4f9a-9b34-85db499cdcfd
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86911 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86911,3,'{"status":"ok","response":{"match_id":86911,"title":"Middlesex vs Hampshire","short_title":"MID vs HAM","subtitle":"Match 91","match_number":"91","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Hampshire won by 3 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":7044,"name":"Middlesex","short_name":"MID","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/middlesex-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/middlesex-logo.png","scores_full":"187\/8 (20 ov)","scores":"187\/8","overs":"20"},"teamb":{"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":"188\/7 (19.4 ov)","scores":"188\/7","overs":"19.4"},"date_start":"2025-07-09 16:00:00","date_end":"2025-07-10 02:00:00","timestamp_start":1752076800,"timestamp_end":1752112800,"date_start_ist":"2025-07-09 21:30:00","date_end_ist":"2025-07-10 07:30:00","venue":{"venue_id":"41","name":"Merchant Taylors'' School Ground","location":"Northwood","country":"England","timezone":""},"umpires":"Neil Bainton (England), Surendiran Shanmugam (England)","referee":"James Whitaker (England)","equation":"","live":"","result":"HAM won by 3 wickets","result_type":2,"win_margin":"3 wickets","winning_team_id":7047,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-07-06 21:17:22","verify_time":"2025-07-10 00:57:49","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"","weather_desc":"","temp":"","humidity":"","visibility":"","wind_speed":"","clouds":""},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Hampshire elected to bowl","winner":7047,"decision":2}},"etag":"244079d1f05eeedda9f6ec79eb472965","modified":"2025-07-14 19:03:19","datetime":"2025-07-14 19:03:19","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":86911,"title":"Middlesex vs Hampshire","short_title":"MID vs HAM","subtitle":"Match 91","match_number":"91","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Hampshire won by 3 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":7044,"name":"Middlesex","short_name":"MID","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/middlesex-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/middlesex-logo.png","scores_full":"187\/8 (20 ov)","scores":"187\/8","overs":"20"},"teamb":{"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":"188\/7 (19.4 ov)","scores":"188\/7","overs":"19.4"},"date_start":"2025-07-09 16:00:00","date_end":"2025-07-10 02:00:00","timestamp_start":1752076800,"timestamp_end":1752112800,"date_start_ist":"2025-07-09 21:30:00","date_end_ist":"2025-07-10 07:30:00","venue":{"venue_id":"41","name":"Merchant Taylors'' School Ground","location":"Northwood","country":"England","timezone":""},"umpires":"Neil Bainton (England), Surendiran Shanmugam (England)","referee":"James Whitaker (England)","equation":"","live":"","result":"HAM won by 3 wickets","result_type":2,"win_margin":"3 wickets","winning_team_id":7047,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-07-06 21:17:22","verify_time":"2025-07-10 00:57:49","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"","weather_desc":"","temp":"","humidity":"","visibility":"","wind_speed":"","clouds":""},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Hampshire elected to bowl","winner":7047,"decision":2}},"etag":"244079d1f05eeedda9f6ec79eb472965","modified":"2025-07-14 19:03:19","datetime":"2025-07-14 19:03:19","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86911 AND DataTypeId = 3 END Live Report & Scorecard of Middlesex vs Hampshire Match 91
Middlesex vs Hampshire, Live Cricket Commentary