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:98d316a1-6e9f-4dc3-b0cf-b632fc765c52 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 88326 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (88326,1,'{"status":"ok","response":{"mid":88326,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Match Drawn","day_remaining_over":"90","team_batting":"Essex","team_bowling":"Hampshire","live_inning_number":3,"live_score":{"runs":358,"overs":119,"wickets":6,"target":0,"runrate":3.01,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Tom Westley","batsman_id":10592,"runs":130,"balls_faced":322,"fours":12,"sixes":0,"strike_rate":"40.37"},{"name":"Simon Harmer","batsman_id":49087,"runs":5,"balls_faced":15,"fours":0,"sixes":0,"strike_rate":"33.33"}],"bowlers":[{"name":"Tom Prest","bowler_id":108376,"overs":3,"runs_conceded":10,"wickets":1,"maidens":0,"econ":"3.33"},{"name":"Felix Organ","bowler_id":50481,"overs":20,"runs_conceded":57,"wickets":0,"maidens":0,"econ":"2.85"}],"commentaries":[{"event_id":"12226572","event":"ball","batsman_id":"51105","bowler_id":"108376","over":"114","ball":"5","score":0,"commentary":"Tom Prest to Michael-Kyle Pepper, no run,","noball_dismissal":false,"text":"","timestamp":1750868017,"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":"12226577","event":"wicket","batsman_id":"51105","bowler_id":"108376","over":"114","ball":"6","score":"w","commentary":"Tom Prest to Michael-Kyle Pepper, no run, c K Abbott b T Prest,","noball_dismissal":false,"text":"","timestamp":1750868021,"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":"51105","how_out":"c K Abbott b T Prest","batsman_runs":"140","batsman_balls":"154"},{"event":"overend","over":115,"runs":3,"score":"346\/6","bats":[{"runs":140,"balls_faced":154,"fours":20,"sixes":1,"batsman_id":51105},{"runs":123,"balls_faced":313,"fours":12,"sixes":0,"batsman_id":10592}],"bowls":[{"runs_conceded":3,"maidens":0,"wickets":1,"bowler_id":108376,"overs":1},{"runs_conceded":52,"maidens":0,"wickets":0,"bowler_id":50481,"overs":18}],"commentary":"End of over 115 (3 runs), Essex 346\/6"},{"event_id":"12226581","event":"ball","batsman_id":"10592","bowler_id":"50481","over":"115","ball":"1","score":1,"commentary":"Felix Organ to Tom Westley, 1 run,","noball_dismissal":false,"text":"","timestamp":1750868028,"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":"12226583","event":"ball","batsman_id":"49087","bowler_id":"50481","over":"115","ball":"2","score":1,"commentary":"Felix Organ to Simon Harmer, 1 run,","noball_dismissal":false,"text":"","timestamp":1750868032,"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":"12226584","event":"ball","batsman_id":"10592","bowler_id":"50481","over":"115","ball":"3","score":0,"commentary":"Felix Organ to Tom Westley, no run,","noball_dismissal":false,"text":"","timestamp":1750868036,"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":"12226585","event":"ball","batsman_id":"10592","bowler_id":"50481","over":"115","ball":"4","score":0,"commentary":"Felix Organ to Tom Westley, no run,","noball_dismissal":false,"text":"","timestamp":1750868041,"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":"12226586","event":"ball","batsman_id":"10592","bowler_id":"50481","over":"115","ball":"5","score":1,"commentary":"Felix Organ to Tom Westley, 1 run,","noball_dismissal":false,"text":"","timestamp":1750868048,"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":"12226587","event":"ball","batsman_id":"49087","bowler_id":"50481","over":"115","ball":"6","score":0,"commentary":"Felix Organ to Simon Harmer, no run,","noball_dismissal":false,"text":"","timestamp":1750868051,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":116,"runs":3,"score":"349\/6","bats":[{"runs":1,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":49087},{"runs":125,"balls_faced":317,"fours":12,"sixes":0,"batsman_id":10592}],"bowls":[{"runs_conceded":55,"maidens":0,"wickets":0,"bowler_id":50481,"overs":19},{"runs_conceded":3,"maidens":0,"wickets":1,"bowler_id":108376,"overs":1}],"commentary":"End of over 116 (3 runs), Essex 349\/6"},{"event_id":"12226591","event":"ball","batsman_id":"10592","bowler_id":"108376","over":"116","ball":"1","score":1,"commentary":"Tom Prest to Tom Westley, 1 run,","noball_dismissal":false,"text":"","timestamp":1750868055,"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":"12226596","event":"ball","batsman_id":"49087","bowler_id":"108376","over":"116","ball":"2","score":0,"commentary":"Tom Prest to Simon Harmer, no run,","noball_dismissal":false,"text":"","timestamp":1750868059,"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":"12226597","event":"ball","batsman_id":"49087","bowler_id":"108376","over":"116","ball":"3","score":1,"commentary":"Tom Prest to Simon Harmer, 1 run,","noball_dismissal":false,"text":"","timestamp":1750868063,"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":"12226600","event":"ball","batsman_id":"10592","bowler_id":"108376","over":"116","ball":"4","score":1,"commentary":"Tom Prest to Tom Westley, 1 run,","noball_dismissal":false,"text":"","timestamp":1750868067,"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":"12226601","event":"ball","batsman_id":"49087","bowler_id":"108376","over":"116","ball":"5","score":0,"commentary":"Tom Prest to Simon Harmer, no run,","noball_dismissal":false,"text":"","timestamp":1750868072,"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":"12226603","event":"ball","batsman_id":"49087","bowler_id":"108376","over":"116","ball":"6","score":1,"commentary":"Tom Prest to Simon Harmer, 1 run,","noball_dismissal":false,"text":"","timestamp":1750868076,"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":117,"runs":4,"score":"353\/6","bats":[{"runs":3,"balls_faced":6,"fours":0,"sixes":0,"batsman_id":49087},{"runs":127,"balls_faced":319,"fours":12,"sixes":0,"batsman_id":10592}],"bowls":[{"runs_conceded":7,"maidens":0,"wickets":1,"bowler_id":108376,"overs":2},{"runs_conceded":55,"maidens":0,"wickets":0,"bowler_id":50481,"overs":19}],"commentary":"End of over 117 (4 runs), Essex 353\/6"},{"event_id":"12226607","event":"ball","batsman_id":"49087","bowler_id":"50481","over":"117","ball":"1","score":0,"commentary":"Felix Organ to Simon Harmer, no run,","noball_dismissal":false,"text":"","timestamp":1750868081,"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":"12226608","event":"ball","batsman_id":"49087","bowler_id":"50481","over":"117","ball":"2","score":0,"commentary":"Felix Organ to Simon Harmer, no run,","noball_dismissal":false,"text":"","timestamp":1750868085,"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":"12226609","event":"ball","batsman_id":"49087","bowler_id":"50481","over":"117","ball":"3","score":1,"commentary":"Felix Organ to Simon Harmer, 1 run,","noball_dismissal":false,"text":"","timestamp":1750868088,"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":"12226611","event":"ball","batsman_id":"10592","bowler_id":"50481","over":"117","ball":"4","score":1,"commentary":"Felix Organ to Tom Westley, 1 run,","noball_dismissal":false,"text":"","timestamp":1750868092,"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":"12226612","event":"ball","batsman_id":"49087","bowler_id":"50481","over":"117","ball":"5","score":0,"commentary":"Felix Organ to Simon Harmer, no run,","noball_dismissal":false,"text":"","timestamp":1750868095,"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":"12226614","event":"ball","batsman_id":"49087","bowler_id":"50481","over":"117","ball":"6","score":0,"commentary":"Felix Organ to Simon Harmer, no run,","noball_dismissal":false,"text":"","timestamp":1750868098,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":118,"runs":2,"score":"355\/6","bats":[{"runs":4,"balls_faced":11,"fours":0,"sixes":0,"batsman_id":49087},{"runs":128,"balls_faced":320,"fours":12,"sixes":0,"batsman_id":10592}],"bowls":[{"runs_conceded":57,"maidens":0,"wickets":0,"bowler_id":50481,"overs":20},{"runs_conceded":7,"maidens":0,"wickets":1,"bowler_id":108376,"overs":2}],"commentary":"End of over 118 (2 runs), Essex 355\/6"},{"event_id":"12226615","event":"ball","batsman_id":"10592","bowler_id":"108376","over":"118","ball":"1","score":1,"commentary":"Tom Prest to Tom Westley, 1 run,","noball_dismissal":false,"text":"","timestamp":1750868101,"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":"12226616","event":"ball","batsman_id":"49087","bowler_id":"108376","over":"118","ball":"2","score":1,"commentary":"Tom Prest to Simon Harmer, 1 run,","noball_dismissal":false,"text":"","timestamp":1750868113,"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":"12226617","event":"ball","batsman_id":"10592","bowler_id":"108376","over":"118","ball":"3","score":1,"commentary":"Tom Prest to Tom Westley, 1 run,","noball_dismissal":false,"text":"","timestamp":1750868118,"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":"12226618","event":"ball","batsman_id":"49087","bowler_id":"108376","over":"118","ball":"4","score":0,"commentary":"Tom Prest to Simon Harmer, no run,","noball_dismissal":false,"text":"","timestamp":1750868123,"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":"12226619","event":"ball","batsman_id":"49087","bowler_id":"108376","over":"118","ball":"5","score":0,"commentary":"Tom Prest to Simon Harmer, no run,","noball_dismissal":false,"text":"","timestamp":1750868127,"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":"12226620","event":"ball","batsman_id":"49087","bowler_id":"108376","over":"118","ball":"6","score":0,"commentary":"Tom Prest to Simon Harmer, no run,","noball_dismissal":false,"text":"","timestamp":1750868130,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":119,"runs":3,"score":"358\/6","bats":[{"runs":5,"balls_faced":15,"fours":0,"sixes":0,"batsman_id":49087},{"runs":130,"balls_faced":322,"fours":12,"sixes":0,"batsman_id":10592}],"bowls":[{"runs_conceded":10,"maidens":0,"wickets":1,"bowler_id":108376,"overs":3},{"runs_conceded":57,"maidens":0,"wickets":0,"bowler_id":50481,"overs":20}],"commentary":"End of over 119 (3 runs), Essex 358\/6"}],"day":"0","session":"0","live_inning":{"iid":198672,"number":3,"name":"Essex 2nd Inning","short_name":"ESS 2nd Inning","status":2,"issuperover":"false","result":2,"batting_team_id":104950,"fielding_team_id":7047,"scores":"358\/6","scores_full":"358\/6 (119 ov)","fielder":[{"fielder_id":"94429","fielder_name":"N. Tilak Varma","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"49334","fielder_name":"Ben Brown","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"108376","fielder_name":"Tom Prest","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"432","fielder_name":"Kyle Abbott","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":"Michael-Kyle Pepper","batsman_id":"51105","runs":"140","balls":"154","how_out":"c K Abbott b T Prest","score_at_dismissal":346,"overs_at_dismissal":"114.6","bowler_id":"108376","dismissal":"caught","number":6},"extra_runs":{"byes":5,"legbyes":4,"wides":0,"noballs":0,"penalty":"0","total":9},"equations":{"runs":358,"wickets":6,"overs":"119","bowlers_used":8,"runrate":"3.01"},"current_partnership":{"runs":12,"balls":24,"overs":4,"batsmen":[{"name":"Tom Westley","batsman_id":10592,"runs":7,"balls":9},{"name":"Simon Harmer","batsman_id":49087,"runs":5,"balls":15}]},"did_not_bat":[{"player_id":"61358","name":"Shane Snater"},{"player_id":"68691","name":"Samuel Cook"},{"player_id":"129447","name":"Mackenzie Jones"}],"max_over":"0","target":"0","recent_scores":"0,0,0,1,1,1,0,0,1,1,0,0,1,0,1,1,0,1","last_five_overs":"15\/1 3.00","last_ten_overs":"34\/1 3.40"},"teams":[{"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":"453\/10 (138.1 ov)","scores":"453\/10","overs":"138.1"},{"tid":104950,"title":"Essex","abbr":"ESS","alt_name":"ESS","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"296\/10 (98.1 ov) & 358\/6d (119 ov)","scores":"296\/10 & 358\/6d","overs":"98.1 & 119"}],"players":[{"pid":432,"title":"Kyle Abbott","short_name":"K Abbott","first_name":"Kyle Abbott","last_name":"","middle_name":"","birthdate":"1987-06-18","birthplace":"Empangeni, KwaZulu-Natal","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bowl","role_str":""},{"pid":1051,"title":"Mason Crane","short_name":"MS Crane","first_name":"Mason Crane","last_name":"","middle_name":"","birthdate":"1997-02-18","birthplace":"Shoreham-by-Sea, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":18969,"recent_appearance":1515022200,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/masoncrane32","instagram_profile":"https:\/\/www.instagram.com\/masoncrane32\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":1259,"title":"Aneurin Donald","short_name":"A Donald","first_name":"Aneurin Donald","last_name":"","middle_name":"","birthdate":"1996-12-20","birthplace":"Swansea, Glamorgan","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","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":"https:\/\/www.facebook.com\/aneurin.donald\/","twitter_profile":"https:\/\/twitter.com\/AneurinDonald12","instagram_profile":"https:\/\/www.instagram.com\/aneurindonald\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","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":7.5,"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":"squad","role_str":""},{"pid":10592,"title":"Tom Westley","short_name":"TZ Westley","first_name":"Tom Westley","last_name":"","middle_name":"","birthdate":"1989-03-13","birthplace":"Cambridge","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"pid":10602,"title":"Nick Browne","short_name":"NLJ Browne","first_name":"Nick Browne","last_name":"","middle_name":"","birthdate":"1991-03-24","birthplace":"Leytonstone, Essex","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":32166,"title":"James Fuller","short_name":"JK Fuller","first_name":"James Fuller","last_name":"","middle_name":"","birthdate":"1990-01-24","birthplace":"Cape Town, Cape Province","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/James_Fuller246","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":43360,"title":"Ross Whiteley","short_name":"RA Whiteley","first_name":"Ross Whiteley","last_name":"","middle_name":"","birthdate":"1988-09-13","birthplace":"Sheffield, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/RossWhiteley44","instagram_profile":"https:\/\/www.instagram.com\/rosswhiteley44\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":43476,"title":"Michael Neser","short_name":"MG Neser","first_name":"Michael Neser","last_name":"","middle_name":"","birthdate":"1990-03-29","birthplace":"Pretoria, South Africa","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/m.facebook.com\/michael.neser\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/michaelneser\/?hl=en","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":43625,"title":"Ben McDermott","short_name":"BR McDermott","first_name":"Ben McDermott","last_name":"","middle_name":"","birthdate":"1994-12-12","birthplace":"Brisbane","country":"au","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"Wicketkeeper ","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"https:\/\/www.facebook.com\/bxpxm\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/benrmcd28\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":45206,"title":"Mohammad Abbas","short_name":"M Abbas","first_name":"Mohammad Abbas","last_name":"","middle_name":"","birthdate":"1990-03-10","birthplace":"Sialkot, Punjab","country":"pk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"squad","role_str":""},{"pid":48647,"title":"Matt Critchley","short_name":"MJJ Critchley","first_name":"Matt Critchley","last_name":"","middle_name":"","birthdate":"1996-08-13","birthplace":"Preston, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","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":"","twitter_profile":"https:\/\/twitter.com\/mattcritchley96","instagram_profile":"https:\/\/www.instagram.com\/critch130896\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":49033,"title":"Keith Barker","short_name":"KHD Barker","first_name":"Keith Barker","last_name":"","middle_name":"","birthdate":"1986-10-21","birthplace":"Manchester, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49083,"title":"Dean Elgar","short_name":"D Elgar","first_name":"Dean Elgar","last_name":"","middle_name":"","birthdate":"1987-06-11","birthplace":"Welkom, Orange Free state","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":36249,"recent_appearance":1514287800,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BoringDeanElgar","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bat","role_str":""},{"pid":49087,"title":"Simon Harmer","short_name":"SR Harmer","first_name":"Simon Harmer","last_name":"","middle_name":"","birthdate":"1989-02-10","birthplace":"Pretoria, Transvaal","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Simon_Harmer_","instagram_profile":"https:\/\/www.instagram.com\/simon_harmer\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bowl","role_str":""},{"pid":49334,"title":"Ben Brown","short_name":"BC Brown","first_name":"Ben Brown","last_name":"","middle_name":"","birthdate":"1988-11-23","birthplace":"Crawley, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper ","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Ben_Brown26","instagram_profile":"https:\/\/www.instagram.com\/benbrown26\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK\/C)"},{"pid":49343,"title":"Nick Gubbins","short_name":"NRT Gubbins","first_name":"Nick Gubbins","last_name":"","middle_name":"","birthdate":"1993-12-31","birthplace":"Richmond, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":49478,"title":"Chris Wood","short_name":"CP Wood","first_name":"Chris Wood","last_name":"","middle_name":"","birthdate":"1990-06-27","birthplace":"Basingstoke, Hampshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/CWoody27","instagram_profile":"https:\/\/www.instagram.com\/cwood25\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49524,"title":"Benny Howell","short_name":"BAC Howell","first_name":"Benny Howell","last_name":"","middle_name":"","birthdate":"1988-10-05","birthplace":"Bordeaux, France","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/BennyHowellOfficial\/","twitter_profile":"https:\/\/twitter.com\/bennytweets_","instagram_profile":"https:\/\/www.instagram.com\/bennycam13\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49593,"title":"Jamie Porter","short_name":"JA Porter","first_name":"Jamie Porter","last_name":"","middle_name":"","birthdate":"1993-05-25","birthplace":"Leytonstone, Essex","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50481,"title":"Felix Organ","short_name":"FS Organ","first_name":"Felix Organ","last_name":"","middle_name":"","birthdate":"1999-06-02","birthplace":"Sydney","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":50484,"title":"Brad Wheal","short_name":"BTJ Wheal","first_name":"Brad Wheal","last_name":"","middle_name":"","birthdate":"1996-08-28","birthplace":"Durban, KwaZulu-Natal","country":"sct","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/brad.wheal\/","twitter_profile":"https:\/\/twitter.com\/BradWheal","instagram_profile":"https:\/\/www.instagram.com\/bradwheal\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Scotland","role":"squad","role_str":""},{"pid":51105,"title":"Michael-Kyle Pepper","short_name":"MKS Pepper","first_name":"Michael-Kyle Pepper","last_name":"","middle_name":"","birthdate":"1998-06-25","birthplace":"Harlow, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/michael_pep\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":51285,"title":"Joe Weatherley","short_name":"JJ Weatherley","first_name":"Joe Weatherley","last_name":"","middle_name":"","birthdate":"1997-01-19","birthplace":"Winchester, Hampshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"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":"squad","role_str":""},{"pid":51346,"title":"Paul Walter","short_name":"PI Walter","first_name":"Paul Walter","last_name":"","middle_name":"","birthdate":"1994-05-28","birthplace":"Basildon, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","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":"all","role_str":""},{"pid":55109,"title":"Ian Holland","short_name":"I Holland","first_name":"Ian Holland","last_name":"","middle_name":"","birthdate":"1990-10-03","birthplace":"Stevens Point, Wisconsin","country":"us","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"United States","role":"squad","role_str":""},{"pid":61358,"title":"Shane Snater","short_name":"S Snater","first_name":"Shane Snater","last_name":"","middle_name":"","birthdate":"1996-03-24","birthplace":"Harare, Zimbabwe","country":"nl","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"bowl","role_str":""},{"pid":68691,"title":"Samuel Cook","short_name":"S Cook","first_name":"Samuel Cook","last_name":"","middle_name":"","birthdate":"1997-08-04","birthplace":"Chelmsford, Essex","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":5.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/samcook09","instagram_profile":"https:\/\/www.instagram.com\/s_cook16\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":94429,"title":"N. Tilak Varma","short_name":"TL Varma","first_name":"N. Tilak Varma","last_name":"","middle_name":"","birthdate":"2002-11-08","birthplace":"Hyderabad, Andhra Pradesh ","country":"in","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\/TilakV9","instagram_profile":"https:\/\/www.instagram.com\/tilakvarma9\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":""},{"pid":94961,"title":"Jordan Cox","short_name":"J Cox","first_name":"Jordan Cox","last_name":"","middle_name":"","birthdate":"2000-10-21","birthplace":"Margate, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/jjordancox\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":""},{"pid":95512,"title":"Jack Campbell","short_name":"JOI Campbell","first_name":"Jack Campbell","last_name":"","middle_name":"","birthdate":"1999-11-11","birthplace":"Portsmouth, 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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":96089,"title":"Nathan Ellis","short_name":"N Ellis","first_name":"Nathan Ellis","last_name":"","middle_name":"","birthdate":"1994-09-22","birthplace":"Greenacre, New South Wales","country":"au","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/RealNathanellis","instagram_profile":"https:\/\/www.instagram.com\/ellis106\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":96605,"title":"Scott Currie","short_name":"S Currie","first_name":"Scott Currie","last_name":"","middle_name":"","birthdate":"2001-05-02","birthplace":"Poole, Dorset","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":103358,"title":"Robin Das","short_name":"RJ Das","first_name":"Robin Das","last_name":"","middle_name":"","birthdate":"2002-02-27","birthplace":"Leytonstone","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":6.5,"facebook_profile":"https:\/\/www.facebook.com\/robindascricketer","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/robinigblue\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108378,"title":"Fletcha Middleton","short_name":"F Middleton","first_name":"Fletcha Middleton","last_name":"","middle_name":"","birthdate":"2002-01-31","birthplace":"Winchester, Hampshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":108381,"title":"John Turner","short_name":"J Turner","first_name":"John Turner","last_name":"","middle_name":"","birthdate":"2001-04-10","birthplace":"Johannesburg, Gauteng","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108393,"title":"Jamal Richards","short_name":"J Richards","first_name":"Jamal Richards","last_name":"","middle_name":"","birthdate":"2004-03-03","birthplace":"Edmonton, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108420,"title":"Luc Benkenstein","short_name":"L Benkenstein","first_name":"Luc Benkenstein","last_name":"","middle_name":"","birthdate":"2004-11-02","birthplace":"Durban","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":109051,"title":"Ali Orr","short_name":"AGH Orr","first_name":"Ali Orr","last_name":"","middle_name":"","birthdate":"2001-04-06","birthplace":"Eastbourne, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/alastairorr\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":109925,"title":"Harry Petrie","short_name":"HW Petrie","first_name":"Harry Petrie","last_name":"","middle_name":"","birthdate":"2002-09-06","birthplace":"Wycombe, Buckinghamshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":118936,"title":"Eddie Jack","short_name":"EV Jack","first_name":"Eddie Jack","last_name":"","middle_name":"","birthdate":"2005-09-09","birthplace":"Barnet, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":119435,"title":"Joseph Eckland","short_name":"JR Eckland","first_name":"Joseph Eckland","last_name":"","middle_name":"","birthdate":"2004-05-22","birthplace":"Yeovil, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":127517,"title":"Noah Thain","short_name":"NRM Thain","first_name":"Noah Thain","last_name":"","middle_name":"","birthdate":"2005-01-13","birthplace":"Hitchinbrooke, Hertfordshire","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":129447,"title":"Mackenzie Jones","short_name":"Mackenzie Jones","first_name":"Mackenzie Jones","last_name":"","middle_name":"","birthdate":"2005-03-06","birthplace":"","country":"sct","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Scotland","role":"bowl","role_str":""},{"pid":134958,"title":"Charles Allison","short_name":"CW Allison","first_name":"Charles Allison","last_name":"","middle_name":"","birthdate":"2005-03-02","birthplace":"Colchester, Essex","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""}]},"etag":"1caa759b67dce85220d5e210537adb3d","modified":"2025-07-14 07:38:41","datetime":"2025-07-14 07:38:41","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":88326,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Match Drawn","day_remaining_over":"90","team_batting":"Essex","team_bowling":"Hampshire","live_inning_number":3,"live_score":{"runs":358,"overs":119,"wickets":6,"target":0,"runrate":3.01,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Tom Westley","batsman_id":10592,"runs":130,"balls_faced":322,"fours":12,"sixes":0,"strike_rate":"40.37"},{"name":"Simon Harmer","batsman_id":49087,"runs":5,"balls_faced":15,"fours":0,"sixes":0,"strike_rate":"33.33"}],"bowlers":[{"name":"Tom Prest","bowler_id":108376,"overs":3,"runs_conceded":10,"wickets":1,"maidens":0,"econ":"3.33"},{"name":"Felix Organ","bowler_id":50481,"overs":20,"runs_conceded":57,"wickets":0,"maidens":0,"econ":"2.85"}],"commentaries":[{"event_id":"12226572","event":"ball","batsman_id":"51105","bowler_id":"108376","over":"114","ball":"5","score":0,"commentary":"Tom Prest to Michael-Kyle Pepper, no run,","noball_dismissal":false,"text":"","timestamp":1750868017,"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":"12226577","event":"wicket","batsman_id":"51105","bowler_id":"108376","over":"114","ball":"6","score":"w","commentary":"Tom Prest to Michael-Kyle Pepper, no run, c K Abbott b T Prest,","noball_dismissal":false,"text":"","timestamp":1750868021,"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":"51105","how_out":"c K Abbott b T Prest","batsman_runs":"140","batsman_balls":"154"},{"event":"overend","over":115,"runs":3,"score":"346\/6","bats":[{"runs":140,"balls_faced":154,"fours":20,"sixes":1,"batsman_id":51105},{"runs":123,"balls_faced":313,"fours":12,"sixes":0,"batsman_id":10592}],"bowls":[{"runs_conceded":3,"maidens":0,"wickets":1,"bowler_id":108376,"overs":1},{"runs_conceded":52,"maidens":0,"wickets":0,"bowler_id":50481,"overs":18}],"commentary":"End of over 115 (3 runs), Essex 346\/6"},{"event_id":"12226581","event":"ball","batsman_id":"10592","bowler_id":"50481","over":"115","ball":"1","score":1,"commentary":"Felix Organ to Tom Westley, 1 run,","noball_dismissal":false,"text":"","timestamp":1750868028,"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":"12226583","event":"ball","batsman_id":"49087","bowler_id":"50481","over":"115","ball":"2","score":1,"commentary":"Felix Organ to Simon Harmer, 1 run,","noball_dismissal":false,"text":"","timestamp":1750868032,"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":"12226584","event":"ball","batsman_id":"10592","bowler_id":"50481","over":"115","ball":"3","score":0,"commentary":"Felix Organ to Tom Westley, no run,","noball_dismissal":false,"text":"","timestamp":1750868036,"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":"12226585","event":"ball","batsman_id":"10592","bowler_id":"50481","over":"115","ball":"4","score":0,"commentary":"Felix Organ to Tom Westley, no run,","noball_dismissal":false,"text":"","timestamp":1750868041,"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":"12226586","event":"ball","batsman_id":"10592","bowler_id":"50481","over":"115","ball":"5","score":1,"commentary":"Felix Organ to Tom Westley, 1 run,","noball_dismissal":false,"text":"","timestamp":1750868048,"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":"12226587","event":"ball","batsman_id":"49087","bowler_id":"50481","over":"115","ball":"6","score":0,"commentary":"Felix Organ to Simon Harmer, no run,","noball_dismissal":false,"text":"","timestamp":1750868051,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":116,"runs":3,"score":"349\/6","bats":[{"runs":1,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":49087},{"runs":125,"balls_faced":317,"fours":12,"sixes":0,"batsman_id":10592}],"bowls":[{"runs_conceded":55,"maidens":0,"wickets":0,"bowler_id":50481,"overs":19},{"runs_conceded":3,"maidens":0,"wickets":1,"bowler_id":108376,"overs":1}],"commentary":"End of over 116 (3 runs), Essex 349\/6"},{"event_id":"12226591","event":"ball","batsman_id":"10592","bowler_id":"108376","over":"116","ball":"1","score":1,"commentary":"Tom Prest to Tom Westley, 1 run,","noball_dismissal":false,"text":"","timestamp":1750868055,"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":"12226596","event":"ball","batsman_id":"49087","bowler_id":"108376","over":"116","ball":"2","score":0,"commentary":"Tom Prest to Simon Harmer, no run,","noball_dismissal":false,"text":"","timestamp":1750868059,"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":"12226597","event":"ball","batsman_id":"49087","bowler_id":"108376","over":"116","ball":"3","score":1,"commentary":"Tom Prest to Simon Harmer, 1 run,","noball_dismissal":false,"text":"","timestamp":1750868063,"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":"12226600","event":"ball","batsman_id":"10592","bowler_id":"108376","over":"116","ball":"4","score":1,"commentary":"Tom Prest to Tom Westley, 1 run,","noball_dismissal":false,"text":"","timestamp":1750868067,"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":"12226601","event":"ball","batsman_id":"49087","bowler_id":"108376","over":"116","ball":"5","score":0,"commentary":"Tom Prest to Simon Harmer, no run,","noball_dismissal":false,"text":"","timestamp":1750868072,"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":"12226603","event":"ball","batsman_id":"49087","bowler_id":"108376","over":"116","ball":"6","score":1,"commentary":"Tom Prest to Simon Harmer, 1 run,","noball_dismissal":false,"text":"","timestamp":1750868076,"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":117,"runs":4,"score":"353\/6","bats":[{"runs":3,"balls_faced":6,"fours":0,"sixes":0,"batsman_id":49087},{"runs":127,"balls_faced":319,"fours":12,"sixes":0,"batsman_id":10592}],"bowls":[{"runs_conceded":7,"maidens":0,"wickets":1,"bowler_id":108376,"overs":2},{"runs_conceded":55,"maidens":0,"wickets":0,"bowler_id":50481,"overs":19}],"commentary":"End of over 117 (4 runs), Essex 353\/6"},{"event_id":"12226607","event":"ball","batsman_id":"49087","bowler_id":"50481","over":"117","ball":"1","score":0,"commentary":"Felix Organ to Simon Harmer, no run,","noball_dismissal":false,"text":"","timestamp":1750868081,"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":"12226608","event":"ball","batsman_id":"49087","bowler_id":"50481","over":"117","ball":"2","score":0,"commentary":"Felix Organ to Simon Harmer, no run,","noball_dismissal":false,"text":"","timestamp":1750868085,"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":"12226609","event":"ball","batsman_id":"49087","bowler_id":"50481","over":"117","ball":"3","score":1,"commentary":"Felix Organ to Simon Harmer, 1 run,","noball_dismissal":false,"text":"","timestamp":1750868088,"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":"12226611","event":"ball","batsman_id":"10592","bowler_id":"50481","over":"117","ball":"4","score":1,"commentary":"Felix Organ to Tom Westley, 1 run,","noball_dismissal":false,"text":"","timestamp":1750868092,"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":"12226612","event":"ball","batsman_id":"49087","bowler_id":"50481","over":"117","ball":"5","score":0,"commentary":"Felix Organ to Simon Harmer, no run,","noball_dismissal":false,"text":"","timestamp":1750868095,"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":"12226614","event":"ball","batsman_id":"49087","bowler_id":"50481","over":"117","ball":"6","score":0,"commentary":"Felix Organ to Simon Harmer, no run,","noball_dismissal":false,"text":"","timestamp":1750868098,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":118,"runs":2,"score":"355\/6","bats":[{"runs":4,"balls_faced":11,"fours":0,"sixes":0,"batsman_id":49087},{"runs":128,"balls_faced":320,"fours":12,"sixes":0,"batsman_id":10592}],"bowls":[{"runs_conceded":57,"maidens":0,"wickets":0,"bowler_id":50481,"overs":20},{"runs_conceded":7,"maidens":0,"wickets":1,"bowler_id":108376,"overs":2}],"commentary":"End of over 118 (2 runs), Essex 355\/6"},{"event_id":"12226615","event":"ball","batsman_id":"10592","bowler_id":"108376","over":"118","ball":"1","score":1,"commentary":"Tom Prest to Tom Westley, 1 run,","noball_dismissal":false,"text":"","timestamp":1750868101,"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":"12226616","event":"ball","batsman_id":"49087","bowler_id":"108376","over":"118","ball":"2","score":1,"commentary":"Tom Prest to Simon Harmer, 1 run,","noball_dismissal":false,"text":"","timestamp":1750868113,"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":"12226617","event":"ball","batsman_id":"10592","bowler_id":"108376","over":"118","ball":"3","score":1,"commentary":"Tom Prest to Tom Westley, 1 run,","noball_dismissal":false,"text":"","timestamp":1750868118,"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":"12226618","event":"ball","batsman_id":"49087","bowler_id":"108376","over":"118","ball":"4","score":0,"commentary":"Tom Prest to Simon Harmer, no run,","noball_dismissal":false,"text":"","timestamp":1750868123,"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":"12226619","event":"ball","batsman_id":"49087","bowler_id":"108376","over":"118","ball":"5","score":0,"commentary":"Tom Prest to Simon Harmer, no run,","noball_dismissal":false,"text":"","timestamp":1750868127,"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":"12226620","event":"ball","batsman_id":"49087","bowler_id":"108376","over":"118","ball":"6","score":0,"commentary":"Tom Prest to Simon Harmer, no run,","noball_dismissal":false,"text":"","timestamp":1750868130,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":119,"runs":3,"score":"358\/6","bats":[{"runs":5,"balls_faced":15,"fours":0,"sixes":0,"batsman_id":49087},{"runs":130,"balls_faced":322,"fours":12,"sixes":0,"batsman_id":10592}],"bowls":[{"runs_conceded":10,"maidens":0,"wickets":1,"bowler_id":108376,"overs":3},{"runs_conceded":57,"maidens":0,"wickets":0,"bowler_id":50481,"overs":20}],"commentary":"End of over 119 (3 runs), Essex 358\/6"}],"day":"0","session":"0","live_inning":{"iid":198672,"number":3,"name":"Essex 2nd Inning","short_name":"ESS 2nd Inning","status":2,"issuperover":"false","result":2,"batting_team_id":104950,"fielding_team_id":7047,"scores":"358\/6","scores_full":"358\/6 (119 ov)","fielder":[{"fielder_id":"94429","fielder_name":"N. Tilak Varma","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"49334","fielder_name":"Ben Brown","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"108376","fielder_name":"Tom Prest","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"432","fielder_name":"Kyle Abbott","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":"Michael-Kyle Pepper","batsman_id":"51105","runs":"140","balls":"154","how_out":"c K Abbott b T Prest","score_at_dismissal":346,"overs_at_dismissal":"114.6","bowler_id":"108376","dismissal":"caught","number":6},"extra_runs":{"byes":5,"legbyes":4,"wides":0,"noballs":0,"penalty":"0","total":9},"equations":{"runs":358,"wickets":6,"overs":"119","bowlers_used":8,"runrate":"3.01"},"current_partnership":{"runs":12,"balls":24,"overs":4,"batsmen":[{"name":"Tom Westley","batsman_id":10592,"runs":7,"balls":9},{"name":"Simon Harmer","batsman_id":49087,"runs":5,"balls":15}]},"did_not_bat":[{"player_id":"61358","name":"Shane Snater"},{"player_id":"68691","name":"Samuel Cook"},{"player_id":"129447","name":"Mackenzie Jones"}],"max_over":"0","target":"0","recent_scores":"0,0,0,1,1,1,0,0,1,1,0,0,1,0,1,1,0,1","last_five_overs":"15\/1 3.00","last_ten_overs":"34\/1 3.40"},"teams":[{"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":"453\/10 (138.1 ov)","scores":"453\/10","overs":"138.1"},{"tid":104950,"title":"Essex","abbr":"ESS","alt_name":"ESS","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"296\/10 (98.1 ov) & 358\/6d (119 ov)","scores":"296\/10 & 358\/6d","overs":"98.1 & 119"}],"players":[{"pid":432,"title":"Kyle Abbott","short_name":"K Abbott","first_name":"Kyle Abbott","last_name":"","middle_name":"","birthdate":"1987-06-18","birthplace":"Empangeni, KwaZulu-Natal","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bowl","role_str":""},{"pid":1051,"title":"Mason Crane","short_name":"MS Crane","first_name":"Mason Crane","last_name":"","middle_name":"","birthdate":"1997-02-18","birthplace":"Shoreham-by-Sea, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":18969,"recent_appearance":1515022200,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/masoncrane32","instagram_profile":"https:\/\/www.instagram.com\/masoncrane32\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":1259,"title":"Aneurin Donald","short_name":"A Donald","first_name":"Aneurin Donald","last_name":"","middle_name":"","birthdate":"1996-12-20","birthplace":"Swansea, Glamorgan","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","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":"https:\/\/www.facebook.com\/aneurin.donald\/","twitter_profile":"https:\/\/twitter.com\/AneurinDonald12","instagram_profile":"https:\/\/www.instagram.com\/aneurindonald\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","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":7.5,"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":"squad","role_str":""},{"pid":10592,"title":"Tom Westley","short_name":"TZ Westley","first_name":"Tom Westley","last_name":"","middle_name":"","birthdate":"1989-03-13","birthplace":"Cambridge","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"pid":10602,"title":"Nick Browne","short_name":"NLJ Browne","first_name":"Nick Browne","last_name":"","middle_name":"","birthdate":"1991-03-24","birthplace":"Leytonstone, Essex","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":32166,"title":"James Fuller","short_name":"JK Fuller","first_name":"James Fuller","last_name":"","middle_name":"","birthdate":"1990-01-24","birthplace":"Cape Town, Cape Province","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/James_Fuller246","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":43360,"title":"Ross Whiteley","short_name":"RA Whiteley","first_name":"Ross Whiteley","last_name":"","middle_name":"","birthdate":"1988-09-13","birthplace":"Sheffield, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/RossWhiteley44","instagram_profile":"https:\/\/www.instagram.com\/rosswhiteley44\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":43476,"title":"Michael Neser","short_name":"MG Neser","first_name":"Michael Neser","last_name":"","middle_name":"","birthdate":"1990-03-29","birthplace":"Pretoria, South Africa","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/m.facebook.com\/michael.neser\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/michaelneser\/?hl=en","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":43625,"title":"Ben McDermott","short_name":"BR McDermott","first_name":"Ben McDermott","last_name":"","middle_name":"","birthdate":"1994-12-12","birthplace":"Brisbane","country":"au","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"Wicketkeeper ","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"https:\/\/www.facebook.com\/bxpxm\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/benrmcd28\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":45206,"title":"Mohammad Abbas","short_name":"M Abbas","first_name":"Mohammad Abbas","last_name":"","middle_name":"","birthdate":"1990-03-10","birthplace":"Sialkot, Punjab","country":"pk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"squad","role_str":""},{"pid":48647,"title":"Matt Critchley","short_name":"MJJ Critchley","first_name":"Matt Critchley","last_name":"","middle_name":"","birthdate":"1996-08-13","birthplace":"Preston, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","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":"","twitter_profile":"https:\/\/twitter.com\/mattcritchley96","instagram_profile":"https:\/\/www.instagram.com\/critch130896\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":49033,"title":"Keith Barker","short_name":"KHD Barker","first_name":"Keith Barker","last_name":"","middle_name":"","birthdate":"1986-10-21","birthplace":"Manchester, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49083,"title":"Dean Elgar","short_name":"D Elgar","first_name":"Dean Elgar","last_name":"","middle_name":"","birthdate":"1987-06-11","birthplace":"Welkom, Orange Free state","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":36249,"recent_appearance":1514287800,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BoringDeanElgar","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bat","role_str":""},{"pid":49087,"title":"Simon Harmer","short_name":"SR Harmer","first_name":"Simon Harmer","last_name":"","middle_name":"","birthdate":"1989-02-10","birthplace":"Pretoria, Transvaal","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Simon_Harmer_","instagram_profile":"https:\/\/www.instagram.com\/simon_harmer\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bowl","role_str":""},{"pid":49334,"title":"Ben Brown","short_name":"BC Brown","first_name":"Ben Brown","last_name":"","middle_name":"","birthdate":"1988-11-23","birthplace":"Crawley, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper ","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Ben_Brown26","instagram_profile":"https:\/\/www.instagram.com\/benbrown26\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK\/C)"},{"pid":49343,"title":"Nick Gubbins","short_name":"NRT Gubbins","first_name":"Nick Gubbins","last_name":"","middle_name":"","birthdate":"1993-12-31","birthplace":"Richmond, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":49478,"title":"Chris Wood","short_name":"CP Wood","first_name":"Chris Wood","last_name":"","middle_name":"","birthdate":"1990-06-27","birthplace":"Basingstoke, Hampshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/CWoody27","instagram_profile":"https:\/\/www.instagram.com\/cwood25\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49524,"title":"Benny Howell","short_name":"BAC Howell","first_name":"Benny Howell","last_name":"","middle_name":"","birthdate":"1988-10-05","birthplace":"Bordeaux, France","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/BennyHowellOfficial\/","twitter_profile":"https:\/\/twitter.com\/bennytweets_","instagram_profile":"https:\/\/www.instagram.com\/bennycam13\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49593,"title":"Jamie Porter","short_name":"JA Porter","first_name":"Jamie Porter","last_name":"","middle_name":"","birthdate":"1993-05-25","birthplace":"Leytonstone, Essex","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50481,"title":"Felix Organ","short_name":"FS Organ","first_name":"Felix Organ","last_name":"","middle_name":"","birthdate":"1999-06-02","birthplace":"Sydney","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":50484,"title":"Brad Wheal","short_name":"BTJ Wheal","first_name":"Brad Wheal","last_name":"","middle_name":"","birthdate":"1996-08-28","birthplace":"Durban, KwaZulu-Natal","country":"sct","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/brad.wheal\/","twitter_profile":"https:\/\/twitter.com\/BradWheal","instagram_profile":"https:\/\/www.instagram.com\/bradwheal\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Scotland","role":"squad","role_str":""},{"pid":51105,"title":"Michael-Kyle Pepper","short_name":"MKS Pepper","first_name":"Michael-Kyle Pepper","last_name":"","middle_name":"","birthdate":"1998-06-25","birthplace":"Harlow, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/michael_pep\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":51285,"title":"Joe Weatherley","short_name":"JJ Weatherley","first_name":"Joe Weatherley","last_name":"","middle_name":"","birthdate":"1997-01-19","birthplace":"Winchester, Hampshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"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":"squad","role_str":""},{"pid":51346,"title":"Paul Walter","short_name":"PI Walter","first_name":"Paul Walter","last_name":"","middle_name":"","birthdate":"1994-05-28","birthplace":"Basildon, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","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":"all","role_str":""},{"pid":55109,"title":"Ian Holland","short_name":"I Holland","first_name":"Ian Holland","last_name":"","middle_name":"","birthdate":"1990-10-03","birthplace":"Stevens Point, Wisconsin","country":"us","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"United States","role":"squad","role_str":""},{"pid":61358,"title":"Shane Snater","short_name":"S Snater","first_name":"Shane Snater","last_name":"","middle_name":"","birthdate":"1996-03-24","birthplace":"Harare, Zimbabwe","country":"nl","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"bowl","role_str":""},{"pid":68691,"title":"Samuel Cook","short_name":"S Cook","first_name":"Samuel Cook","last_name":"","middle_name":"","birthdate":"1997-08-04","birthplace":"Chelmsford, Essex","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":5.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/samcook09","instagram_profile":"https:\/\/www.instagram.com\/s_cook16\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":94429,"title":"N. Tilak Varma","short_name":"TL Varma","first_name":"N. Tilak Varma","last_name":"","middle_name":"","birthdate":"2002-11-08","birthplace":"Hyderabad, Andhra Pradesh ","country":"in","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\/TilakV9","instagram_profile":"https:\/\/www.instagram.com\/tilakvarma9\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":""},{"pid":94961,"title":"Jordan Cox","short_name":"J Cox","first_name":"Jordan Cox","last_name":"","middle_name":"","birthdate":"2000-10-21","birthplace":"Margate, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/jjordancox\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":""},{"pid":95512,"title":"Jack Campbell","short_name":"JOI Campbell","first_name":"Jack Campbell","last_name":"","middle_name":"","birthdate":"1999-11-11","birthplace":"Portsmouth, 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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":96089,"title":"Nathan Ellis","short_name":"N Ellis","first_name":"Nathan Ellis","last_name":"","middle_name":"","birthdate":"1994-09-22","birthplace":"Greenacre, New South Wales","country":"au","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/RealNathanellis","instagram_profile":"https:\/\/www.instagram.com\/ellis106\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":96605,"title":"Scott Currie","short_name":"S Currie","first_name":"Scott Currie","last_name":"","middle_name":"","birthdate":"2001-05-02","birthplace":"Poole, Dorset","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":103358,"title":"Robin Das","short_name":"RJ Das","first_name":"Robin Das","last_name":"","middle_name":"","birthdate":"2002-02-27","birthplace":"Leytonstone","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":6.5,"facebook_profile":"https:\/\/www.facebook.com\/robindascricketer","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/robinigblue\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108378,"title":"Fletcha Middleton","short_name":"F Middleton","first_name":"Fletcha Middleton","last_name":"","middle_name":"","birthdate":"2002-01-31","birthplace":"Winchester, Hampshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":108381,"title":"John Turner","short_name":"J Turner","first_name":"John Turner","last_name":"","middle_name":"","birthdate":"2001-04-10","birthplace":"Johannesburg, Gauteng","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108393,"title":"Jamal Richards","short_name":"J Richards","first_name":"Jamal Richards","last_name":"","middle_name":"","birthdate":"2004-03-03","birthplace":"Edmonton, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108420,"title":"Luc Benkenstein","short_name":"L Benkenstein","first_name":"Luc Benkenstein","last_name":"","middle_name":"","birthdate":"2004-11-02","birthplace":"Durban","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":109051,"title":"Ali Orr","short_name":"AGH Orr","first_name":"Ali Orr","last_name":"","middle_name":"","birthdate":"2001-04-06","birthplace":"Eastbourne, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/alastairorr\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":109925,"title":"Harry Petrie","short_name":"HW Petrie","first_name":"Harry Petrie","last_name":"","middle_name":"","birthdate":"2002-09-06","birthplace":"Wycombe, Buckinghamshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":118936,"title":"Eddie Jack","short_name":"EV Jack","first_name":"Eddie Jack","last_name":"","middle_name":"","birthdate":"2005-09-09","birthplace":"Barnet, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":119435,"title":"Joseph Eckland","short_name":"JR Eckland","first_name":"Joseph Eckland","last_name":"","middle_name":"","birthdate":"2004-05-22","birthplace":"Yeovil, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":127517,"title":"Noah Thain","short_name":"NRM Thain","first_name":"Noah Thain","last_name":"","middle_name":"","birthdate":"2005-01-13","birthplace":"Hitchinbrooke, Hertfordshire","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":129447,"title":"Mackenzie Jones","short_name":"Mackenzie Jones","first_name":"Mackenzie Jones","last_name":"","middle_name":"","birthdate":"2005-03-06","birthplace":"","country":"sct","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Scotland","role":"bowl","role_str":""},{"pid":134958,"title":"Charles Allison","short_name":"CW Allison","first_name":"Charles Allison","last_name":"","middle_name":"","birthdate":"2005-03-02","birthplace":"Colchester, Essex","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""}]},"etag":"1caa759b67dce85220d5e210537adb3d","modified":"2025-07-14 07:38:41","datetime":"2025-07-14 07:38:41","api_version":"3.0"}', Modified = GetDate() WHERE Id = 88326 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:98d316a1-6e9f-4dc3-b0cf-b632fc765c52 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 88326 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (88326,3,'{"status":"ok","response":{"match_id":88326,"title":"Essex vs Hampshire","short_title":"ESS vs HAM","subtitle":"37th Match","match_number":"37","format":5,"format_str":"First Class","status":2,"status_str":"Completed","status_note":"Match Drawn","verified":"true","pre_squad":"false","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129481,"title":"County Championship Division One","abbr":"County Championship 2025 DIV-I","type":"tournament","category":"domestic","match_format":"firstclass","season":"2025","status":"live","datestart":"2025-04-04","dateend":"2025-09-27","country":"en","total_matches":"70","total_rounds":"1","total_teams":"10"},"teama":{"team_id":104950,"name":"Essex","short_name":"ESS","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","scores_full":"296\/10 (98.1 ov) & 358\/6d (119 ov)","scores":"296\/10 & 358\/6d","overs":"98.1 & 119"},"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":"453\/10 (138.1 ov)","scores":"453\/10","overs":"138.1"},"date_start":"2025-06-22 10:00:00","date_end":"2025-06-27 10:00:00","timestamp_start":1750586400,"timestamp_end":1751018400,"date_start_ist":"2025-06-22 15:30:00","date_end_ist":"2025-06-27 15:30:00","venue":{"venue_id":"45","name":"County Ground, Chelmsford","location":"","country":"England","timezone":""},"umpires":"","referee":"","equation":"Match Drawn","live":"","result":"Match Drawn","result_type":3,"win_margin":"","winning_team_id":0,"commentary":1,"wagon":2,"latest_inning_number":3,"presquad_time":"","verify_time":"2025-06-25 22:24:43","match_dls_affected":"false","live_inning_number":3,"day":"0","session":"0","weather":[],"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Essex elected to bat","winner":104950,"decision":1}},"etag":"118c7fb53bb440985ef42ef476eb15f8","modified":"2025-07-14 07:38:42","datetime":"2025-07-14 07:38:42","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":88326,"title":"Essex vs Hampshire","short_title":"ESS vs HAM","subtitle":"37th Match","match_number":"37","format":5,"format_str":"First Class","status":2,"status_str":"Completed","status_note":"Match Drawn","verified":"true","pre_squad":"false","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129481,"title":"County Championship Division One","abbr":"County Championship 2025 DIV-I","type":"tournament","category":"domestic","match_format":"firstclass","season":"2025","status":"live","datestart":"2025-04-04","dateend":"2025-09-27","country":"en","total_matches":"70","total_rounds":"1","total_teams":"10"},"teama":{"team_id":104950,"name":"Essex","short_name":"ESS","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","scores_full":"296\/10 (98.1 ov) & 358\/6d (119 ov)","scores":"296\/10 & 358\/6d","overs":"98.1 & 119"},"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":"453\/10 (138.1 ov)","scores":"453\/10","overs":"138.1"},"date_start":"2025-06-22 10:00:00","date_end":"2025-06-27 10:00:00","timestamp_start":1750586400,"timestamp_end":1751018400,"date_start_ist":"2025-06-22 15:30:00","date_end_ist":"2025-06-27 15:30:00","venue":{"venue_id":"45","name":"County Ground, Chelmsford","location":"","country":"England","timezone":""},"umpires":"","referee":"","equation":"Match Drawn","live":"","result":"Match Drawn","result_type":3,"win_margin":"","winning_team_id":0,"commentary":1,"wagon":2,"latest_inning_number":3,"presquad_time":"","verify_time":"2025-06-25 22:24:43","match_dls_affected":"false","live_inning_number":3,"day":"0","session":"0","weather":[],"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Essex elected to bat","winner":104950,"decision":1}},"etag":"118c7fb53bb440985ef42ef476eb15f8","modified":"2025-07-14 07:38:42","datetime":"2025-07-14 07:38:42","api_version":"3.0"}', Modified = GetDate() WHERE Id = 88326 AND DataTypeId = 3 END
Live Report & Scorecard of Essex vs Hampshire 37th Match
CricDirect Cricket News, Results and Stats
 

Essex vs Hampshire, 37th Match, County Championship Division One

Completed
County Championship Division One, Completed
Essex
ESS
296/10 (98.1 ov) & 358/6d (119 ov)
Hampshire
HAM
453/10 (138.1 ov)
Match Drawn
BATTERS R B 4S 6S SR
Tom Westley * 130 322 12 0 40.37
Simon Harmer 5 15 0 0 33.33
BOWLERS O M R W ECON
Tom Prest * 3 0 10 1 3.33
Felix Organ 20 0 57 0 2.85
Current Partnership: 12 run (4 ov) | Last Wicket: Michael-Kyle Pepper 140 (154) | Fall of Wicket: 346/6 (114.6 ov)
CRR: 3.01
Recent: 111111111

Essex vs Hampshire, Live Cricket Commentary

End of over 119 (3 runs)
Simon Harmer 5 (15)
Tom Westley 130 (322)
Essex 358/6
Tom Prest 3-0-10-1
Felix Organ 20-0-57-0
0
118.6
Tom Prest to Simon Harmer, no run,
0
118.5
Tom Prest to Simon Harmer, no run,
0
118.4
Tom Prest to Simon Harmer, no run,
1
118.3
Tom Prest to Tom Westley, 1 run,
1
118.2
Tom Prest to Simon Harmer, 1 run,
1
118.1
Tom Prest to Tom Westley, 1 run,
End of over 118 (2 runs)
Simon Harmer 4 (11)
Tom Westley 128 (320)
Essex 355/6
Felix Organ 20-0-57-0
Tom Prest 2-0-7-1
0
117.6
Felix Organ to Simon Harmer, no run,
0
117.5
Felix Organ to Simon Harmer, no run,
1
117.4
Felix Organ to Tom Westley, 1 run,
1
117.3
Felix Organ to Simon Harmer, 1 run,
0
117.2
Felix Organ to Simon Harmer, no run,
0
117.1
Felix Organ to Simon Harmer, no run,
End of over 117 (4 runs)
Simon Harmer 3 (6)
Tom Westley 127 (319)
Essex 353/6
Tom Prest 2-0-7-1
Felix Organ 19-0-55-0
1
116.6
Tom Prest to Simon Harmer, 1 run,
0
116.5
Tom Prest to Simon Harmer, no run,
1
116.4
Tom Prest to Tom Westley, 1 run,
1
116.3
Tom Prest to Simon Harmer, 1 run,
0
116.2
Tom Prest to Simon Harmer, no run,
1
116.1
Tom Prest to Tom Westley, 1 run,
End of over 116 (3 runs)
Simon Harmer 1 (2)
Tom Westley 125 (317)
Essex 349/6
Felix Organ 19-0-55-0
Tom Prest 1-0-3-1
0
115.6
Felix Organ to Simon Harmer, no run,
1
115.5
Felix Organ to Tom Westley, 1 run,
0
115.4
Felix Organ to Tom Westley, no run,
0
115.3
Felix Organ to Tom Westley, no run,
1
115.2
Felix Organ to Simon Harmer, 1 run,
1
115.1
Felix Organ to Tom Westley, 1 run,
End of over 115 (3 runs)
Michael-Kyle Pepper 140 (154)
Tom Westley 123 (313)
Essex 346/6
Tom Prest 1-0-3-1
Felix Organ 18-0-52-0
w
114.6
Michael-Kyle Pepper c K Abbott b T Prest 140 (154) Tom Prest to Michael-Kyle Pepper, no run, c K Abbott b T Prest,
0
114.5
Tom Prest to Michael-Kyle Pepper, no run,
Match Details
Date
Sunday, June 22, 2025 11:00
Venue
County Ground, Chelmsford,
Toss
Essex elected to bat
Umpires
    Match Referee
      × Close