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:b2324e96-b496-4e8b-8b70-1514dbae327a Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86897 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86897,1,'{"status":"ok","response":{"mid":86897,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Gloucestershire won by 13 runs","day_remaining_over":"","team_batting":"Essex","team_bowling":"Gloucestershire","live_inning_number":2,"live_score":{"runs":171,"overs":19.3,"wickets":10,"target":185,"runrate":8.77,"required_runrate":28},"commentary":1,"wagon":2,"batsmen":[{"name":"Mohammad Amir","batsman_id":1758,"runs":5,"balls_faced":5,"fours":1,"sixes":0,"strike_rate":"100.00"},{"name":"Shane Snater","batsman_id":61358,"runs":1,"balls_faced":1,"fours":0,"sixes":0,"strike_rate":"100.00"}],"bowlers":[{"name":"Matt Taylor","bowler_id":16594,"overs":3.3,"runs_conceded":31,"wickets":1,"maidens":0,"econ":"8.86"},{"name":"Marchant de Lange","bowler_id":847,"overs":4,"runs_conceded":55,"wickets":1,"maidens":0,"econ":"13.75"}],"commentaries":[{"event_id":"12284351","event":"ball","batsman_id":"134958","bowler_id":"50007","over":"15","ball":"1","score":1,"commentary":"Josh Shaw to Charles Allison, 1 run,","noball_dismissal":false,"text":"","timestamp":1751661339,"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":"12284356","event":"ball","batsman_id":"48647","bowler_id":"50007","over":"15","ball":"2","score":0,"commentary":"Josh Shaw to Matt Critchley, no run,","noball_dismissal":false,"text":"","timestamp":1751661421,"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":"12284359","event":"wicket","batsman_id":"48647","bowler_id":"50007","over":"15","ball":"3","score":"w","commentary":"Josh Shaw to Matt Critchley, no run, b J Shaw,","noball_dismissal":false,"text":"","timestamp":1751661427,"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":"48647","how_out":"b J Shaw","batsman_runs":"27","batsman_balls":"15"},{"event_id":"12284378","event":"ball","batsman_id":"49087","bowler_id":"50007","over":"15","ball":"4","score":0,"commentary":"Josh Shaw to Simon Harmer, no run,","noball_dismissal":false,"text":"","timestamp":1751661732,"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":"12284379","event":"ball","batsman_id":"49087","bowler_id":"50007","over":"15","ball":"5","score":1,"commentary":"Josh Shaw to Simon Harmer, 1 run,","noball_dismissal":false,"text":"","timestamp":1751661736,"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":"12284380","event":"ball","batsman_id":"134958","bowler_id":"50007","over":"15","ball":"6","score":1,"commentary":"Josh Shaw to Charles Allison, 1 run,","noball_dismissal":false,"text":"","timestamp":1751661739,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":16,"runs":3,"score":"147\/6","bats":[{"runs":17,"balls_faced":10,"fours":0,"sixes":2,"batsman_id":134958},{"runs":1,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":49087}],"bowls":[{"runs_conceded":21,"maidens":0,"wickets":2,"bowler_id":50007,"overs":3},{"runs_conceded":31,"maidens":0,"wickets":1,"bowler_id":16594,"overs":3}],"commentary":"End of over 16 (3 runs), Essex 147\/6"},{"event_id":"12284381","event":"ball","batsman_id":"134958","bowler_id":"49526","over":"16","ball":"1","score":1,"commentary":"David Payne to Charles Allison, 1 run,","noball_dismissal":false,"text":"","timestamp":1751661743,"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":"12284382","event":"ball","batsman_id":"49087","bowler_id":"49526","over":"16","ball":"2","score":1,"commentary":"David Payne to Simon Harmer, 1 run,","noball_dismissal":false,"text":"","timestamp":1751661777,"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":"12284383","event":"ball","batsman_id":"134958","bowler_id":"49526","over":"16","ball":"3","score":1,"commentary":"David Payne to Charles Allison, 1 run,","noball_dismissal":false,"text":"","timestamp":1751661781,"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":"12284385","event":"ball","batsman_id":"49087","bowler_id":"49526","over":"16","ball":"4","score":0,"commentary":"David Payne to Simon Harmer, no run,","noball_dismissal":false,"text":"","timestamp":1751661791,"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":"12284390","event":"wicket","batsman_id":"49087","bowler_id":"49526","over":"16","ball":"5","score":"w","commentary":"David Payne to Simon Harmer, no run, c MD Lange b DA Payne,","noball_dismissal":false,"text":"","timestamp":1751661814,"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":"49087","how_out":"c MD Lange b DA Payne","batsman_runs":"2","batsman_balls":"5"},{"event_id":"12284396","event":"ball","batsman_id":"127517","bowler_id":"49526","over":"16","ball":"6","score":4,"commentary":"David Payne to Noah Thain, Four,","noball_dismissal":false,"text":"","timestamp":1751661980,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event":"overend","over":17,"runs":7,"score":"154\/7","bats":[{"runs":4,"balls_faced":1,"fours":1,"sixes":0,"batsman_id":127517},{"runs":19,"balls_faced":12,"fours":0,"sixes":2,"batsman_id":134958}],"bowls":[{"runs_conceded":24,"maidens":0,"wickets":1,"bowler_id":49526,"overs":4},{"runs_conceded":21,"maidens":0,"wickets":2,"bowler_id":50007,"overs":3}],"commentary":"End of over 17 (7 runs), Essex 154\/7"},{"event_id":"12284397","event":"ball","batsman_id":"134958","bowler_id":"50007","over":"17","ball":"1","score":1,"commentary":"Josh Shaw to Charles Allison, 1 run,","noball_dismissal":false,"text":"","timestamp":1751661983,"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":"12284398","event":"ball","batsman_id":"127517","bowler_id":"50007","over":"17","ball":"2","score":1,"commentary":"Josh Shaw to Noah Thain, 1 run,","noball_dismissal":false,"text":"","timestamp":1751661986,"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":"12284399","event":"ball","batsman_id":"134958","bowler_id":"50007","over":"17","ball":"3","score":1,"commentary":"Josh Shaw to Charles Allison, 1 run,","noball_dismissal":false,"text":"","timestamp":1751661996,"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":"12284403","event":"ball","batsman_id":"127517","bowler_id":"50007","over":"17","ball":"4","score":4,"commentary":"Josh Shaw to Noah Thain, Four,","noball_dismissal":false,"text":"","timestamp":1751662025,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12284404","event":"ball","batsman_id":"127517","bowler_id":"50007","over":"17","ball":"5","score":1,"commentary":"Josh Shaw to Noah Thain, 1 run,","noball_dismissal":false,"text":"","timestamp":1751662031,"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":"12284411","event":"wicket","batsman_id":"134958","bowler_id":"50007","over":"17","ball":"6","score":"w","commentary":"Josh Shaw to Charles Allison, no run, c O Price b J Shaw,","noball_dismissal":false,"text":"","timestamp":1751662132,"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":"134958","how_out":"c O Price b J Shaw","batsman_runs":"21","batsman_balls":"15"},{"event":"overend","over":18,"runs":8,"score":"162\/8","bats":[{"runs":21,"balls_faced":15,"fours":0,"sixes":2,"batsman_id":134958},{"runs":10,"balls_faced":4,"fours":2,"sixes":0,"batsman_id":127517}],"bowls":[{"runs_conceded":29,"maidens":0,"wickets":3,"bowler_id":50007,"overs":4},{"runs_conceded":24,"maidens":0,"wickets":1,"bowler_id":49526,"overs":4}],"commentary":"End of over 18 (8 runs), Essex 162\/8"},{"event_id":"12284412","event":"ball","batsman_id":"127517","bowler_id":"847","over":"18","ball":"1","score":1,"commentary":"Marchant de Lange to Noah Thain, 1 run,","noball_dismissal":false,"text":"","timestamp":1751662186,"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":"12284415","event":"ball","batsman_id":"61358","bowler_id":"847","over":"18","ball":"2","score":1,"commentary":"Marchant de Lange to Shane Snater, 1 run,","noball_dismissal":false,"text":"","timestamp":1751662314,"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":"12284416","event":"ball","batsman_id":"127517","bowler_id":"847","over":"18","ball":"3","score":2,"commentary":"Marchant de Lange to Noah Thain, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751662317,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12284417","event":"wicket","batsman_id":"127517","bowler_id":"847","over":"18","ball":"4","score":"w","commentary":"Marchant de Lange to Noah Thain, no run, c O Price b MD Lange,","noball_dismissal":false,"text":"","timestamp":1751662320,"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":"127517","how_out":"c O Price b MD Lange","batsman_runs":"13","batsman_balls":"7"},{"event_id":"12284419","event":"ball","batsman_id":"1758","bowler_id":"847","over":"18","ball":"5","score":4,"commentary":"Marchant de Lange to Mohammad Amir, Four,","noball_dismissal":false,"text":"","timestamp":1751662334,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12284423","event":"ball","batsman_id":"1758","bowler_id":"847","over":"18","ball":"6","score":1,"commentary":"Marchant de Lange to Mohammad Amir, 1 run,","noball_dismissal":false,"text":"","timestamp":1751662440,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":19,"runs":9,"score":"171\/9","bats":[{"runs":5,"balls_faced":2,"fours":1,"sixes":0,"batsman_id":1758},{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":61358}],"bowls":[{"runs_conceded":55,"maidens":0,"wickets":1,"bowler_id":847,"overs":4},{"runs_conceded":29,"maidens":0,"wickets":3,"bowler_id":50007,"overs":4}],"commentary":"End of over 19 (9 runs), Essex 171\/9"},{"event_id":"12284425","event":"ball","batsman_id":"1758","bowler_id":"16594","over":"19","ball":"1","score":0,"commentary":"Matt Taylor to Mohammad Amir, no run,","noball_dismissal":false,"text":"","timestamp":1751662521,"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":"12284426","event":"ball","batsman_id":"1758","bowler_id":"16594","over":"19","ball":"2","score":0,"commentary":"Matt Taylor to Mohammad Amir, no run,","noball_dismissal":false,"text":"","timestamp":1751662524,"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":"12284434","event":"wicket","batsman_id":"1758","bowler_id":"16594","over":"19","ball":"3","score":"w","commentary":"Matt Taylor to Mohammad Amir, no run, runout (MD Taylor \/ CT Bancroft),","noball_dismissal":false,"text":"","timestamp":1751662661,"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":"1758","how_out":"runout (MD Taylor \/ CT Bancroft)","batsman_runs":"5","batsman_balls":"5"}],"day":"0","session":"0","live_inning":{"iid":199121,"number":2,"name":"Essex Inning","short_name":"ESS Inning","status":2,"issuperover":"false","result":1,"batting_team_id":104950,"fielding_team_id":7017,"scores":"171\/10","scores_full":"171\/10 (19.3 ov)","fielder":[{"fielder_id":"49812","fielder_name":"Miles Hammond","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"88692","fielder_name":"Ben Charlesworth","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"49747","fielder_name":"Jack Taylor","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"847","fielder_name":"Marchant de Lange","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"107312","fielder_name":"Ollie Price","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"43563","fielder_name":"Cameron Bancroft","catches":0,"runout_thrower":1,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"16594","fielder_name":"Matt Taylor","catches":0,"runout_thrower":0,"runout_catcher":1,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"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":"Mohammad Amir","batsman_id":"1758","runs":"5","balls":"5","how_out":"runout (MD Taylor \/ CT Bancroft)","score_at_dismissal":171,"overs_at_dismissal":"19.3","bowler_id":"0","dismissal":"runout","number":10},"extra_runs":{"byes":4,"legbyes":3,"wides":1,"noballs":2,"penalty":"0","total":10},"equations":{"runs":171,"wickets":10,"overs":"19.3","bowlers_used":7,"runrate":"8.77"},"current_partnership":{"runs":5,"balls":5,"overs":0.5,"batsmen":[{"name":"Mohammad Amir","batsman_id":1758,"runs":5,"balls":5},{"name":"Shane Snater","batsman_id":61358,"runs":0,"balls":0}]},"did_not_bat":[],"max_over":"20","target":"185","recent_scores":"w,0,0,1,4,w,2,1,1,w,1,4,1,1,1,4,w,0","last_five_overs":"42\/5 8.13","last_ten_overs":"92\/7 8.90"},"teams":[{"tid":7017,"title":"Gloucestershire","abbr":"GLO","alt_name":"GLO","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-GLO@2x.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-GLO@2x.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"184\/7 (20 ov)","scores":"184\/7","overs":"20"},{"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":"171\/10 (19.3 ov)","scores":"171\/10","overs":"19.3"}],"players":[{"pid":847,"title":"Marchant de Lange","short_name":"MD Lange","first_name":"Marchant de Lange","last_name":"","middle_name":"","birthdate":"1990-10-13","birthplace":"Tzaneen, Limpopo","country":"za","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":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Marchant90","instagram_profile":"https:\/\/www.instagram.com\/marchant.delange\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bowl","role_str":""},{"pid":1758,"title":"Mohammad Amir","short_name":"M Amir","first_name":"Mohammad Amir","last_name":"","middle_name":"","birthdate":"1992-04-13","birthplace":" Gujjar Khan, Punjab","country":"pk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/iamamirofficial","instagram_profile":"https:\/\/www.instagram.com\/official.mamir\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bowl","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":"squad","role_str":""},{"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":16594,"title":"Matt Taylor","short_name":"MD Taylor","first_name":"Matt Taylor","last_name":"","middle_name":"","birthdate":"1994-07-08","birthplace":"Banbury, Oxfordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":43563,"title":"Cameron Bancroft","short_name":"CT Bancroft","first_name":"Cameron Bancroft","last_name":"","middle_name":"","birthdate":"1992-11-19","birthplace":" Attadale, Australia","country":"au","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper ","recent_match":18968,"recent_appearance":1514244600,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/cbancroft4\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"wk","role_str":"(WK)"},{"pid":47533,"title":"Graeme van Buuren","short_name":"GL Buuren","first_name":"Graeme van Buuren","last_name":"","middle_name":"","birthdate":"1990-08-22","birthplace":"Pretoria, Transvaal","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/graemegvb\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","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":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":"(C)"},{"pid":49376,"title":"Adam Rossington","short_name":"AM Rossington","first_name":"Adam Rossington","last_name":"","middle_name":"","birthdate":"1993-05-05","birthplace":"Edgware, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper ","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Rossington17","instagram_profile":"https:\/\/www.instagram.com\/rossington17\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49519,"title":"Chris Dent","short_name":"CDJ Dent","first_name":"Chris Dent","last_name":"","middle_name":"","birthdate":"1991-01-20","birthplace":"Bristol","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"Occasional Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Cdent15","instagram_profile":"https:\/\/www.instagram.com\/chrisdent15\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49526,"title":"David Payne","short_name":"DA Payne","first_name":"David Payne","last_name":"","middle_name":"","birthdate":"1991-02-15","birthplace":"Poole, Dorset","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/DavidPayne_14","instagram_profile":"https:\/\/www.instagram.com\/sidpayne14\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","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":49747,"title":"Jack Taylor","short_name":"JMR Taylor","first_name":"Jack Taylor","last_name":"","middle_name":"","birthdate":"1991-11-12","birthplace":"Banbury, Oxfordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"pid":49812,"title":"Miles Hammond","short_name":"MAH Hammond","first_name":"Miles Hammond","last_name":"","middle_name":"","birthdate":"1996-01-11","birthplace":"Cheltenham, Gloucestershire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/milesAHH","instagram_profile":"https:\/\/www.instagram.com\/hammo_gram\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":50007,"title":"Josh Shaw","short_name":"J Shaw","first_name":"Josh Shaw","last_name":"","middle_name":"","birthdate":"1996-01-03","birthplace":"Wakefield, Yorkshire","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,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/joshuashaw1","instagram_profile":"https:\/\/www.instagram.com\/joshshaw5931\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":50425,"title":"James Bracey","short_name":"JR Bracey","first_name":"James Bracey","last_name":"","middle_name":"","birthdate":"1997-05-03","birthplace":"Bristol","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/james_bracey\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","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":""},{"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":58686,"title":"Tom Smith","short_name":"TC Smith","first_name":"Tom Smith","last_name":"","middle_name":"","birthdate":"1987-08-29","birthplace":"Liverpool","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/tmjsmith6\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","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":7,"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":"squad","role_str":""},{"pid":84301,"title":"D''Arcy Short","short_name":"DJM Short","first_name":"D''Arcy Short","last_name":"","middle_name":"","birthdate":"1990-08-09","birthplace":" Katherine, Northern Territory","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":18958,"recent_appearance":1517646000,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/shortyjnr23\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Australia","role":"all","role_str":""},{"pid":88692,"title":"Ben Charlesworth","short_name":"BG Charlesworth","first_name":"Ben Charlesworth","last_name":"","middle_name":"","birthdate":"2000-11-19","birthplace":"Oxford","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/bencharlesworth_\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":93130,"title":"Cameron Green","short_name":"C Green","first_name":"Cameron Green","last_name":"","middle_name":"","birthdate":"1999-06-03","birthplace":"Perth, Australia","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/CameronGreen_","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","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":"(WK)"},{"pid":95478,"title":"Tom Price","short_name":"TJ Price","first_name":"Tom Price","last_name":"","middle_name":"","birthdate":"2000-01-02","birthplace":"Oxford, United Kingdom","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":101483,"title":"Ajeet Singh Dale","short_name":"Ajeet Singh Dale","first_name":"Ajeet Singh Dale","last_name":"","middle_name":"","birthdate":"2000-07-02","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.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":107311,"title":"Dominic Goodman","short_name":"DC Goodman","first_name":"Dominic Goodman","last_name":"","middle_name":"","birthdate":"2000-10-23","birthplace":"Ashford, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/domgoodman_\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":107312,"title":"Ollie Price","short_name":"O Price","first_name":"Ollie Price","last_name":"","middle_name":"","birthdate":"2001-06-12","birthplace":"Oxford","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","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":"all","role_str":""},{"pid":110606,"title":"Zaman Akhter","short_name":"Z Akhter","first_name":"Zaman Akhter","last_name":"","middle_name":"","birthdate":"1999-03-12","birthplace":"Cambridge","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":116662,"title":"Luke Charlesworth","short_name":"LA Charlesworth","first_name":"Luke Charlesworth","last_name":"","middle_name":"","birthdate":"2003-04-04","birthplace":"Oxford","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":118935,"title":"Tommy Boorman","short_name":"Tommy Boorman","first_name":"Tommy Boorman","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":127440,"title":"Joe Phillips","short_name":"JP Phillips","first_name":"Joe Phillips","last_name":"","middle_name":"","birthdate":"2003-11-09","birthplace":"Truro, Cornwall","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","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":"all","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":"squad","role_str":""},{"pid":130759,"title":"Ahmed Mujtaba Syed","short_name":"A Mujtaba Syed","first_name":"Ahmed Mujtaba Syed","last_name":"","middle_name":"","birthdate":"2004-09-26","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":130760,"title":"Edward Middleton","short_name":"Ed Middleton","first_name":"Edward Middleton","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":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":""},{"pid":139986,"title":"Archie Bailey","short_name":"A Bailey","first_name":"Archie Bailey","last_name":"","middle_name":"","birthdate":"2005-06-28","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":141341,"title":"Simon Fernandes","short_name":"Simon Fernandes","first_name":"Simon Fernandes","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":149124,"title":"Aman Rao","short_name":"Aman Rao","first_name":"Aman Rao","last_name":"","middle_name":"","birthdate":"2004-06-22","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""}]},"etag":"4d5fabde45d5549ec56a39f21a028646","modified":"2025-07-16 07:59:10","datetime":"2025-07-16 07:59:10","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":86897,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Gloucestershire won by 13 runs","day_remaining_over":"","team_batting":"Essex","team_bowling":"Gloucestershire","live_inning_number":2,"live_score":{"runs":171,"overs":19.3,"wickets":10,"target":185,"runrate":8.77,"required_runrate":28},"commentary":1,"wagon":2,"batsmen":[{"name":"Mohammad Amir","batsman_id":1758,"runs":5,"balls_faced":5,"fours":1,"sixes":0,"strike_rate":"100.00"},{"name":"Shane Snater","batsman_id":61358,"runs":1,"balls_faced":1,"fours":0,"sixes":0,"strike_rate":"100.00"}],"bowlers":[{"name":"Matt Taylor","bowler_id":16594,"overs":3.3,"runs_conceded":31,"wickets":1,"maidens":0,"econ":"8.86"},{"name":"Marchant de Lange","bowler_id":847,"overs":4,"runs_conceded":55,"wickets":1,"maidens":0,"econ":"13.75"}],"commentaries":[{"event_id":"12284351","event":"ball","batsman_id":"134958","bowler_id":"50007","over":"15","ball":"1","score":1,"commentary":"Josh Shaw to Charles Allison, 1 run,","noball_dismissal":false,"text":"","timestamp":1751661339,"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":"12284356","event":"ball","batsman_id":"48647","bowler_id":"50007","over":"15","ball":"2","score":0,"commentary":"Josh Shaw to Matt Critchley, no run,","noball_dismissal":false,"text":"","timestamp":1751661421,"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":"12284359","event":"wicket","batsman_id":"48647","bowler_id":"50007","over":"15","ball":"3","score":"w","commentary":"Josh Shaw to Matt Critchley, no run, b J Shaw,","noball_dismissal":false,"text":"","timestamp":1751661427,"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":"48647","how_out":"b J Shaw","batsman_runs":"27","batsman_balls":"15"},{"event_id":"12284378","event":"ball","batsman_id":"49087","bowler_id":"50007","over":"15","ball":"4","score":0,"commentary":"Josh Shaw to Simon Harmer, no run,","noball_dismissal":false,"text":"","timestamp":1751661732,"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":"12284379","event":"ball","batsman_id":"49087","bowler_id":"50007","over":"15","ball":"5","score":1,"commentary":"Josh Shaw to Simon Harmer, 1 run,","noball_dismissal":false,"text":"","timestamp":1751661736,"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":"12284380","event":"ball","batsman_id":"134958","bowler_id":"50007","over":"15","ball":"6","score":1,"commentary":"Josh Shaw to Charles Allison, 1 run,","noball_dismissal":false,"text":"","timestamp":1751661739,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":16,"runs":3,"score":"147\/6","bats":[{"runs":17,"balls_faced":10,"fours":0,"sixes":2,"batsman_id":134958},{"runs":1,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":49087}],"bowls":[{"runs_conceded":21,"maidens":0,"wickets":2,"bowler_id":50007,"overs":3},{"runs_conceded":31,"maidens":0,"wickets":1,"bowler_id":16594,"overs":3}],"commentary":"End of over 16 (3 runs), Essex 147\/6"},{"event_id":"12284381","event":"ball","batsman_id":"134958","bowler_id":"49526","over":"16","ball":"1","score":1,"commentary":"David Payne to Charles Allison, 1 run,","noball_dismissal":false,"text":"","timestamp":1751661743,"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":"12284382","event":"ball","batsman_id":"49087","bowler_id":"49526","over":"16","ball":"2","score":1,"commentary":"David Payne to Simon Harmer, 1 run,","noball_dismissal":false,"text":"","timestamp":1751661777,"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":"12284383","event":"ball","batsman_id":"134958","bowler_id":"49526","over":"16","ball":"3","score":1,"commentary":"David Payne to Charles Allison, 1 run,","noball_dismissal":false,"text":"","timestamp":1751661781,"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":"12284385","event":"ball","batsman_id":"49087","bowler_id":"49526","over":"16","ball":"4","score":0,"commentary":"David Payne to Simon Harmer, no run,","noball_dismissal":false,"text":"","timestamp":1751661791,"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":"12284390","event":"wicket","batsman_id":"49087","bowler_id":"49526","over":"16","ball":"5","score":"w","commentary":"David Payne to Simon Harmer, no run, c MD Lange b DA Payne,","noball_dismissal":false,"text":"","timestamp":1751661814,"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":"49087","how_out":"c MD Lange b DA Payne","batsman_runs":"2","batsman_balls":"5"},{"event_id":"12284396","event":"ball","batsman_id":"127517","bowler_id":"49526","over":"16","ball":"6","score":4,"commentary":"David Payne to Noah Thain, Four,","noball_dismissal":false,"text":"","timestamp":1751661980,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event":"overend","over":17,"runs":7,"score":"154\/7","bats":[{"runs":4,"balls_faced":1,"fours":1,"sixes":0,"batsman_id":127517},{"runs":19,"balls_faced":12,"fours":0,"sixes":2,"batsman_id":134958}],"bowls":[{"runs_conceded":24,"maidens":0,"wickets":1,"bowler_id":49526,"overs":4},{"runs_conceded":21,"maidens":0,"wickets":2,"bowler_id":50007,"overs":3}],"commentary":"End of over 17 (7 runs), Essex 154\/7"},{"event_id":"12284397","event":"ball","batsman_id":"134958","bowler_id":"50007","over":"17","ball":"1","score":1,"commentary":"Josh Shaw to Charles Allison, 1 run,","noball_dismissal":false,"text":"","timestamp":1751661983,"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":"12284398","event":"ball","batsman_id":"127517","bowler_id":"50007","over":"17","ball":"2","score":1,"commentary":"Josh Shaw to Noah Thain, 1 run,","noball_dismissal":false,"text":"","timestamp":1751661986,"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":"12284399","event":"ball","batsman_id":"134958","bowler_id":"50007","over":"17","ball":"3","score":1,"commentary":"Josh Shaw to Charles Allison, 1 run,","noball_dismissal":false,"text":"","timestamp":1751661996,"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":"12284403","event":"ball","batsman_id":"127517","bowler_id":"50007","over":"17","ball":"4","score":4,"commentary":"Josh Shaw to Noah Thain, Four,","noball_dismissal":false,"text":"","timestamp":1751662025,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12284404","event":"ball","batsman_id":"127517","bowler_id":"50007","over":"17","ball":"5","score":1,"commentary":"Josh Shaw to Noah Thain, 1 run,","noball_dismissal":false,"text":"","timestamp":1751662031,"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":"12284411","event":"wicket","batsman_id":"134958","bowler_id":"50007","over":"17","ball":"6","score":"w","commentary":"Josh Shaw to Charles Allison, no run, c O Price b J Shaw,","noball_dismissal":false,"text":"","timestamp":1751662132,"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":"134958","how_out":"c O Price b J Shaw","batsman_runs":"21","batsman_balls":"15"},{"event":"overend","over":18,"runs":8,"score":"162\/8","bats":[{"runs":21,"balls_faced":15,"fours":0,"sixes":2,"batsman_id":134958},{"runs":10,"balls_faced":4,"fours":2,"sixes":0,"batsman_id":127517}],"bowls":[{"runs_conceded":29,"maidens":0,"wickets":3,"bowler_id":50007,"overs":4},{"runs_conceded":24,"maidens":0,"wickets":1,"bowler_id":49526,"overs":4}],"commentary":"End of over 18 (8 runs), Essex 162\/8"},{"event_id":"12284412","event":"ball","batsman_id":"127517","bowler_id":"847","over":"18","ball":"1","score":1,"commentary":"Marchant de Lange to Noah Thain, 1 run,","noball_dismissal":false,"text":"","timestamp":1751662186,"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":"12284415","event":"ball","batsman_id":"61358","bowler_id":"847","over":"18","ball":"2","score":1,"commentary":"Marchant de Lange to Shane Snater, 1 run,","noball_dismissal":false,"text":"","timestamp":1751662314,"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":"12284416","event":"ball","batsman_id":"127517","bowler_id":"847","over":"18","ball":"3","score":2,"commentary":"Marchant de Lange to Noah Thain, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751662317,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12284417","event":"wicket","batsman_id":"127517","bowler_id":"847","over":"18","ball":"4","score":"w","commentary":"Marchant de Lange to Noah Thain, no run, c O Price b MD Lange,","noball_dismissal":false,"text":"","timestamp":1751662320,"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":"127517","how_out":"c O Price b MD Lange","batsman_runs":"13","batsman_balls":"7"},{"event_id":"12284419","event":"ball","batsman_id":"1758","bowler_id":"847","over":"18","ball":"5","score":4,"commentary":"Marchant de Lange to Mohammad Amir, Four,","noball_dismissal":false,"text":"","timestamp":1751662334,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12284423","event":"ball","batsman_id":"1758","bowler_id":"847","over":"18","ball":"6","score":1,"commentary":"Marchant de Lange to Mohammad Amir, 1 run,","noball_dismissal":false,"text":"","timestamp":1751662440,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":19,"runs":9,"score":"171\/9","bats":[{"runs":5,"balls_faced":2,"fours":1,"sixes":0,"batsman_id":1758},{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":61358}],"bowls":[{"runs_conceded":55,"maidens":0,"wickets":1,"bowler_id":847,"overs":4},{"runs_conceded":29,"maidens":0,"wickets":3,"bowler_id":50007,"overs":4}],"commentary":"End of over 19 (9 runs), Essex 171\/9"},{"event_id":"12284425","event":"ball","batsman_id":"1758","bowler_id":"16594","over":"19","ball":"1","score":0,"commentary":"Matt Taylor to Mohammad Amir, no run,","noball_dismissal":false,"text":"","timestamp":1751662521,"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":"12284426","event":"ball","batsman_id":"1758","bowler_id":"16594","over":"19","ball":"2","score":0,"commentary":"Matt Taylor to Mohammad Amir, no run,","noball_dismissal":false,"text":"","timestamp":1751662524,"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":"12284434","event":"wicket","batsman_id":"1758","bowler_id":"16594","over":"19","ball":"3","score":"w","commentary":"Matt Taylor to Mohammad Amir, no run, runout (MD Taylor \/ CT Bancroft),","noball_dismissal":false,"text":"","timestamp":1751662661,"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":"1758","how_out":"runout (MD Taylor \/ CT Bancroft)","batsman_runs":"5","batsman_balls":"5"}],"day":"0","session":"0","live_inning":{"iid":199121,"number":2,"name":"Essex Inning","short_name":"ESS Inning","status":2,"issuperover":"false","result":1,"batting_team_id":104950,"fielding_team_id":7017,"scores":"171\/10","scores_full":"171\/10 (19.3 ov)","fielder":[{"fielder_id":"49812","fielder_name":"Miles Hammond","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"88692","fielder_name":"Ben Charlesworth","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"49747","fielder_name":"Jack Taylor","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"847","fielder_name":"Marchant de Lange","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"107312","fielder_name":"Ollie Price","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"43563","fielder_name":"Cameron Bancroft","catches":0,"runout_thrower":1,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"16594","fielder_name":"Matt Taylor","catches":0,"runout_thrower":0,"runout_catcher":1,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"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":"Mohammad Amir","batsman_id":"1758","runs":"5","balls":"5","how_out":"runout (MD Taylor \/ CT Bancroft)","score_at_dismissal":171,"overs_at_dismissal":"19.3","bowler_id":"0","dismissal":"runout","number":10},"extra_runs":{"byes":4,"legbyes":3,"wides":1,"noballs":2,"penalty":"0","total":10},"equations":{"runs":171,"wickets":10,"overs":"19.3","bowlers_used":7,"runrate":"8.77"},"current_partnership":{"runs":5,"balls":5,"overs":0.5,"batsmen":[{"name":"Mohammad Amir","batsman_id":1758,"runs":5,"balls":5},{"name":"Shane Snater","batsman_id":61358,"runs":0,"balls":0}]},"did_not_bat":[],"max_over":"20","target":"185","recent_scores":"w,0,0,1,4,w,2,1,1,w,1,4,1,1,1,4,w,0","last_five_overs":"42\/5 8.13","last_ten_overs":"92\/7 8.90"},"teams":[{"tid":7017,"title":"Gloucestershire","abbr":"GLO","alt_name":"GLO","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-GLO@2x.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-GLO@2x.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"184\/7 (20 ov)","scores":"184\/7","overs":"20"},{"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":"171\/10 (19.3 ov)","scores":"171\/10","overs":"19.3"}],"players":[{"pid":847,"title":"Marchant de Lange","short_name":"MD Lange","first_name":"Marchant de Lange","last_name":"","middle_name":"","birthdate":"1990-10-13","birthplace":"Tzaneen, Limpopo","country":"za","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":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Marchant90","instagram_profile":"https:\/\/www.instagram.com\/marchant.delange\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bowl","role_str":""},{"pid":1758,"title":"Mohammad Amir","short_name":"M Amir","first_name":"Mohammad Amir","last_name":"","middle_name":"","birthdate":"1992-04-13","birthplace":" Gujjar Khan, Punjab","country":"pk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/iamamirofficial","instagram_profile":"https:\/\/www.instagram.com\/official.mamir\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bowl","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":"squad","role_str":""},{"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":16594,"title":"Matt Taylor","short_name":"MD Taylor","first_name":"Matt Taylor","last_name":"","middle_name":"","birthdate":"1994-07-08","birthplace":"Banbury, Oxfordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":43563,"title":"Cameron Bancroft","short_name":"CT Bancroft","first_name":"Cameron Bancroft","last_name":"","middle_name":"","birthdate":"1992-11-19","birthplace":" Attadale, Australia","country":"au","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper ","recent_match":18968,"recent_appearance":1514244600,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/cbancroft4\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"wk","role_str":"(WK)"},{"pid":47533,"title":"Graeme van Buuren","short_name":"GL Buuren","first_name":"Graeme van Buuren","last_name":"","middle_name":"","birthdate":"1990-08-22","birthplace":"Pretoria, Transvaal","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/graemegvb\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","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":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":"(C)"},{"pid":49376,"title":"Adam Rossington","short_name":"AM Rossington","first_name":"Adam Rossington","last_name":"","middle_name":"","birthdate":"1993-05-05","birthplace":"Edgware, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper ","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Rossington17","instagram_profile":"https:\/\/www.instagram.com\/rossington17\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49519,"title":"Chris Dent","short_name":"CDJ Dent","first_name":"Chris Dent","last_name":"","middle_name":"","birthdate":"1991-01-20","birthplace":"Bristol","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"Occasional Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Cdent15","instagram_profile":"https:\/\/www.instagram.com\/chrisdent15\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49526,"title":"David Payne","short_name":"DA Payne","first_name":"David Payne","last_name":"","middle_name":"","birthdate":"1991-02-15","birthplace":"Poole, Dorset","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/DavidPayne_14","instagram_profile":"https:\/\/www.instagram.com\/sidpayne14\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","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":49747,"title":"Jack Taylor","short_name":"JMR Taylor","first_name":"Jack Taylor","last_name":"","middle_name":"","birthdate":"1991-11-12","birthplace":"Banbury, Oxfordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"pid":49812,"title":"Miles Hammond","short_name":"MAH Hammond","first_name":"Miles Hammond","last_name":"","middle_name":"","birthdate":"1996-01-11","birthplace":"Cheltenham, Gloucestershire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/milesAHH","instagram_profile":"https:\/\/www.instagram.com\/hammo_gram\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":50007,"title":"Josh Shaw","short_name":"J Shaw","first_name":"Josh Shaw","last_name":"","middle_name":"","birthdate":"1996-01-03","birthplace":"Wakefield, Yorkshire","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,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/joshuashaw1","instagram_profile":"https:\/\/www.instagram.com\/joshshaw5931\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":50425,"title":"James Bracey","short_name":"JR Bracey","first_name":"James Bracey","last_name":"","middle_name":"","birthdate":"1997-05-03","birthplace":"Bristol","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/james_bracey\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","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":""},{"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":58686,"title":"Tom Smith","short_name":"TC Smith","first_name":"Tom Smith","last_name":"","middle_name":"","birthdate":"1987-08-29","birthplace":"Liverpool","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/tmjsmith6\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","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":7,"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":"squad","role_str":""},{"pid":84301,"title":"D''Arcy Short","short_name":"DJM Short","first_name":"D''Arcy Short","last_name":"","middle_name":"","birthdate":"1990-08-09","birthplace":" Katherine, Northern Territory","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":18958,"recent_appearance":1517646000,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/shortyjnr23\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Australia","role":"all","role_str":""},{"pid":88692,"title":"Ben Charlesworth","short_name":"BG Charlesworth","first_name":"Ben Charlesworth","last_name":"","middle_name":"","birthdate":"2000-11-19","birthplace":"Oxford","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/bencharlesworth_\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":93130,"title":"Cameron Green","short_name":"C Green","first_name":"Cameron Green","last_name":"","middle_name":"","birthdate":"1999-06-03","birthplace":"Perth, Australia","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/CameronGreen_","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","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":"(WK)"},{"pid":95478,"title":"Tom Price","short_name":"TJ Price","first_name":"Tom Price","last_name":"","middle_name":"","birthdate":"2000-01-02","birthplace":"Oxford, United Kingdom","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":101483,"title":"Ajeet Singh Dale","short_name":"Ajeet Singh Dale","first_name":"Ajeet Singh Dale","last_name":"","middle_name":"","birthdate":"2000-07-02","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.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":107311,"title":"Dominic Goodman","short_name":"DC Goodman","first_name":"Dominic Goodman","last_name":"","middle_name":"","birthdate":"2000-10-23","birthplace":"Ashford, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/domgoodman_\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":107312,"title":"Ollie Price","short_name":"O Price","first_name":"Ollie Price","last_name":"","middle_name":"","birthdate":"2001-06-12","birthplace":"Oxford","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","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":"all","role_str":""},{"pid":110606,"title":"Zaman Akhter","short_name":"Z Akhter","first_name":"Zaman Akhter","last_name":"","middle_name":"","birthdate":"1999-03-12","birthplace":"Cambridge","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":116662,"title":"Luke Charlesworth","short_name":"LA Charlesworth","first_name":"Luke Charlesworth","last_name":"","middle_name":"","birthdate":"2003-04-04","birthplace":"Oxford","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":118935,"title":"Tommy Boorman","short_name":"Tommy Boorman","first_name":"Tommy Boorman","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":127440,"title":"Joe Phillips","short_name":"JP Phillips","first_name":"Joe Phillips","last_name":"","middle_name":"","birthdate":"2003-11-09","birthplace":"Truro, Cornwall","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","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":"all","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":"squad","role_str":""},{"pid":130759,"title":"Ahmed Mujtaba Syed","short_name":"A Mujtaba Syed","first_name":"Ahmed Mujtaba Syed","last_name":"","middle_name":"","birthdate":"2004-09-26","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":130760,"title":"Edward Middleton","short_name":"Ed Middleton","first_name":"Edward Middleton","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":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":""},{"pid":139986,"title":"Archie Bailey","short_name":"A Bailey","first_name":"Archie Bailey","last_name":"","middle_name":"","birthdate":"2005-06-28","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":141341,"title":"Simon Fernandes","short_name":"Simon Fernandes","first_name":"Simon Fernandes","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":149124,"title":"Aman Rao","short_name":"Aman Rao","first_name":"Aman Rao","last_name":"","middle_name":"","birthdate":"2004-06-22","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""}]},"etag":"4d5fabde45d5549ec56a39f21a028646","modified":"2025-07-16 07:59:10","datetime":"2025-07-16 07:59:10","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86897 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:b2324e96-b496-4e8b-8b70-1514dbae327a Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86897 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86897,3,'{"status":"ok","response":{"match_id":86897,"title":"Essex vs Gloucestershire","short_title":"ESS vs GLO","subtitle":"Match 77","match_number":"77","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Gloucestershire won by 13 runs","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129425,"title":"Vitality Blast","abbr":"Vitality Blast","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-09-13","country":"en","total_matches":"133","total_rounds":"2","total_teams":"18"},"teama":{"team_id":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":"171\/10 (19.3 ov)","scores":"171\/10","overs":"19.3"},"teamb":{"team_id":7017,"name":"Gloucestershire","short_name":"GLO","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-GLO@2x.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-GLO@2x.png","scores_full":"184\/7 (20 ov)","scores":"184\/7","overs":"20"},"date_start":"2025-07-04 18:00:00","date_end":"2025-07-05 04:00:00","timestamp_start":1751652000,"timestamp_end":1751688000,"date_start_ist":"2025-07-04 23:30:00","date_end_ist":"2025-07-05 09:30:00","venue":{"venue_id":"45","name":"County Ground, Chelmsford","location":"","country":"England","timezone":""},"umpires":"Chris Watts (England), Rob White (England)","referee":"Peter Such (England)","equation":"","live":"","result":"GLO won by 13 runs","result_type":2,"win_margin":"13 runs","winning_team_id":7017,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-26 19:48:39","verify_time":"2025-07-05 02:50:19","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":19.37,"humidity":48,"visibility":10000,"wind_speed":"13.38","clouds":98},"pitch":{"pitch_condition":"","batting_condition":"Average","pace_bowling_condition":"Average","spine_bowling_condition":"Average"},"toss":{"text":"Essex elected to bowl","winner":104950,"decision":2}},"etag":"9e3457d2a368964dcdfd6ae9fab87cce","modified":"2025-07-16 07:59:11","datetime":"2025-07-16 07:59:11","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":86897,"title":"Essex vs Gloucestershire","short_title":"ESS vs GLO","subtitle":"Match 77","match_number":"77","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Gloucestershire won by 13 runs","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129425,"title":"Vitality Blast","abbr":"Vitality Blast","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-09-13","country":"en","total_matches":"133","total_rounds":"2","total_teams":"18"},"teama":{"team_id":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":"171\/10 (19.3 ov)","scores":"171\/10","overs":"19.3"},"teamb":{"team_id":7017,"name":"Gloucestershire","short_name":"GLO","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-GLO@2x.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-GLO@2x.png","scores_full":"184\/7 (20 ov)","scores":"184\/7","overs":"20"},"date_start":"2025-07-04 18:00:00","date_end":"2025-07-05 04:00:00","timestamp_start":1751652000,"timestamp_end":1751688000,"date_start_ist":"2025-07-04 23:30:00","date_end_ist":"2025-07-05 09:30:00","venue":{"venue_id":"45","name":"County Ground, Chelmsford","location":"","country":"England","timezone":""},"umpires":"Chris Watts (England), Rob White (England)","referee":"Peter Such (England)","equation":"","live":"","result":"GLO won by 13 runs","result_type":2,"win_margin":"13 runs","winning_team_id":7017,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-26 19:48:39","verify_time":"2025-07-05 02:50:19","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":19.37,"humidity":48,"visibility":10000,"wind_speed":"13.38","clouds":98},"pitch":{"pitch_condition":"","batting_condition":"Average","pace_bowling_condition":"Average","spine_bowling_condition":"Average"},"toss":{"text":"Essex elected to bowl","winner":104950,"decision":2}},"etag":"9e3457d2a368964dcdfd6ae9fab87cce","modified":"2025-07-16 07:59:11","datetime":"2025-07-16 07:59:11","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86897 AND DataTypeId = 3 END
Live Report & Scorecard of Essex vs Gloucestershire Match 77

Live Cricket Match Centre

Essex vs Gloucestershire, Match 77, Vitality Blast

Completed

Vitality Blast, Completed

Essex

ESS

171/10 (19.3 ov)

Gloucestershire

GLO

184/7 (20 ov)

Gloucestershire won by 13 runs

BATTERS	R	B	4S	6S	SR
Mohammad Amir *	5	5	1	0	100.00
Shane Snater	1	1	0	0	100.00

BOWLERS	O	M	R	W	ECON
Matt Taylor *	3.3	0	31	1	8.86
Marchant de Lange	4	0	55	1	13.75

Current Partnership: 5 run (0.5 ov) | Last Wicket: Mohammad Amir 5 (5) | Fall of Wicket: 171/10 (19.3 ov)

CRR: 8.77

Recent: w••14w211w141114w•

Essex vs Gloucestershire, Live Cricket Commentary

19.3

Mohammad Amir runout (MD Taylor / CT Bancroft) 5 (5) Matt Taylor to Mohammad Amir, no run, runout (MD Taylor / CT Bancroft),

19.2

Matt Taylor to Mohammad Amir, no run,

19.1

Matt Taylor to Mohammad Amir, no run,

End of over 19 (9 runs)

Mohammad Amir 5 (2)

Shane Snater 1 (1)

Essex 171/9

Marchant de Lange 4-0-55-1

Josh Shaw 4-0-29-3

18.6

Marchant de Lange to Mohammad Amir, 1 run,

18.5

Marchant de Lange to Mohammad Amir, Four,

18.4

Noah Thain c O Price b MD Lange 13 (7) Marchant de Lange to Noah Thain, no run, c O Price b MD Lange,

18.3

Marchant de Lange to Noah Thain, 2 runs,

18.2

Marchant de Lange to Shane Snater, 1 run,

18.1

Marchant de Lange to Noah Thain, 1 run,

End of over 18 (8 runs)

Charles Allison 21 (15)

Noah Thain 10 (4)

Essex 162/8

Josh Shaw 4-0-29-3

David Payne 4-0-24-1

17.6

Charles Allison c O Price b J Shaw 21 (15) Josh Shaw to Charles Allison, no run, c O Price b J Shaw,

17.5

Josh Shaw to Noah Thain, 1 run,

17.4

Josh Shaw to Noah Thain, Four,

17.3

Josh Shaw to Charles Allison, 1 run,

17.2

Josh Shaw to Noah Thain, 1 run,

17.1

Josh Shaw to Charles Allison, 1 run,

End of over 17 (7 runs)

Noah Thain 4 (1)

Charles Allison 19 (12)

Essex 154/7

David Payne 4-0-24-1

Josh Shaw 3-0-21-2

16.6

David Payne to Noah Thain, Four,

16.5

Simon Harmer c MD Lange b DA Payne 2 (5) David Payne to Simon Harmer, no run, c MD Lange b DA Payne,

16.4

David Payne to Simon Harmer, no run,

16.3

David Payne to Charles Allison, 1 run,

16.2

David Payne to Simon Harmer, 1 run,

16.1

David Payne to Charles Allison, 1 run,

End of over 16 (3 runs)

Charles Allison 17 (10)

Simon Harmer 1 (2)

Essex 147/6

Josh Shaw 3-0-21-2

Matt Taylor 3-0-31-1

15.6

Josh Shaw to Charles Allison, 1 run,

15.5

Josh Shaw to Simon Harmer, 1 run,

15.4

Josh Shaw to Simon Harmer, no run,

15.3

Matt Critchley b J Shaw 27 (15) Josh Shaw to Matt Critchley, no run, b J Shaw,

15.2

Josh Shaw to Matt Critchley, no run,

15.1

Josh Shaw to Charles Allison, 1 run,

Date

Friday, July 4, 2025 19:00

Venue

County Ground, Chelmsford,

Toss

Essex elected to bowl

Umpires

Match Referee

Peter Such (England)

× Close