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
Essex vs Hampshire, Live Cricket Commentary