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:4aa18728-f1ea-42cb-8173-7e06c37e3810 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86847 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86847,1,'{"status":"ok","response":{"mid":86847,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Glamorgan won by 6 wickets","day_remaining_over":"","team_batting":"Glamorgan","team_bowling":"Essex","live_inning_number":2,"live_score":{"runs":185,"overs":19,"wickets":4,"target":184,"runrate":9.74,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Chris Cooke","batsman_id":49444,"runs":10,"balls_faced":8,"fours":0,"sixes":0,"strike_rate":"125.00"},{"name":"Asa Tribe","batsman_id":141478,"runs":9,"balls_faced":8,"fours":1,"sixes":0,"strike_rate":"112.50"}],"bowlers":[{"name":"Mohammad Amir","bowler_id":1758,"overs":4,"runs_conceded":38,"wickets":0,"maidens":0,"econ":"9.50"},{"name":"Paul Walter","bowler_id":51346,"overs":4,"runs_conceded":35,"wickets":2,"maidens":0,"econ":"8.75"}],"commentaries":[{"event_id":"12089639","event":"ball","batsman_id":"49739","bowler_id":"49087","over":"14","ball":"6","score":4,"commentary":"Simon Harmer to Colin Ingram, Four,","noball_dismissal":false,"text":"","timestamp":1749240235,"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":15,"runs":19,"score":"161\/2","bats":[{"runs":7,"balls_faced":5,"fours":1,"sixes":0,"batsman_id":49739},{"runs":89,"balls_faced":50,"fours":5,"sixes":6,"batsman_id":51191}],"bowls":[{"runs_conceded":35,"maidens":0,"wickets":1,"bowler_id":49087,"overs":3},{"runs_conceded":32,"maidens":0,"wickets":0,"bowler_id":1758,"overs":3}],"commentary":"End of over 15 (19 runs), Glamorgan 161\/2"},{"event_id":"12089645","event":"ball","batsman_id":"51191","bowler_id":"51346","over":"15","ball":"1","score":0,"commentary":"Paul Walter to Kiran Carlson, no run,","noball_dismissal":false,"text":"","timestamp":1749240238,"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":"12089647","event":"ball","batsman_id":"51191","bowler_id":"51346","over":"15","ball":"2","score":1,"commentary":"Paul Walter to Kiran Carlson, 1 run,","noball_dismissal":false,"text":"","timestamp":1749240241,"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":"12089655","event":"wicket","batsman_id":"49739","bowler_id":"51346","over":"15","ball":"3","score":"w","commentary":"Paul Walter to Colin Ingram, no run, c D Elgar b PI Walter,","noball_dismissal":false,"text":"","timestamp":1749240389,"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":"49739","how_out":"c D Elgar b PI Walter","batsman_runs":"7","batsman_balls":"6"},{"event_id":"12089687","event":"ball","batsman_id":"49444","bowler_id":"51346","over":"15","ball":"4","score":1,"commentary":"Paul Walter to Chris Cooke, 1 run,","noball_dismissal":false,"text":"","timestamp":1749240418,"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":"12089688","event":"ball","batsman_id":"51191","bowler_id":"51346","over":"15","ball":"5","score":1,"commentary":"Paul Walter to Kiran Carlson, 1 run,","noball_dismissal":false,"text":"","timestamp":1749240421,"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":"12089690","event":"ball","batsman_id":"49444","bowler_id":"51346","over":"15","ball":"6","score":2,"commentary":"Paul Walter to Chris Cooke, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749240425,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":16,"runs":5,"score":"166\/3","bats":[{"runs":3,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":49444},{"runs":91,"balls_faced":53,"fours":5,"sixes":6,"batsman_id":51191}],"bowls":[{"runs_conceded":29,"maidens":0,"wickets":1,"bowler_id":51346,"overs":3},{"runs_conceded":35,"maidens":0,"wickets":1,"bowler_id":49087,"overs":3}],"commentary":"End of over 16 (5 runs), Glamorgan 166\/3"},{"event_id":"12089705","event":"ball","batsman_id":"51191","bowler_id":"68691","over":"16","ball":"1","score":1,"commentary":"Samuel Cook to Kiran Carlson, 1 run,","noball_dismissal":false,"text":"","timestamp":1749240490,"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":"12089728","event":"ball","batsman_id":"49444","bowler_id":"68691","over":"16","ball":"2","score":2,"commentary":"Samuel Cook to Chris Cooke, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749240612,"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":"12089730","event":"ball","batsman_id":"49444","bowler_id":"68691","over":"16","ball":"3","score":"1wd","commentary":"Samuel Cook to Chris Cooke, 1 wide,","noball_dismissal":false,"text":"","timestamp":1749240615,"run":1,"noball_run":"0","wide_run":"1","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12089731","event":"ball","batsman_id":"49444","bowler_id":"68691","over":"16","ball":"3","score":1,"commentary":"Samuel Cook to Chris Cooke, 1 run,","noball_dismissal":false,"text":"","timestamp":1749240617,"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":"12089732","event":"ball","batsman_id":"51191","bowler_id":"68691","over":"16","ball":"4","score":1,"commentary":"Samuel Cook to Kiran Carlson, 1 run,","noball_dismissal":false,"text":"","timestamp":1749240619,"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":"12089746","event":"ball","batsman_id":"49444","bowler_id":"68691","over":"16","ball":"5","score":1,"commentary":"Samuel Cook to Chris Cooke, 1 run,","noball_dismissal":false,"text":"","timestamp":1749240679,"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":"12089748","event":"ball","batsman_id":"51191","bowler_id":"68691","over":"16","ball":"6","score":0,"commentary":"Samuel Cook to Kiran Carlson, no run,","noball_dismissal":false,"text":"","timestamp":1749240681,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":17,"runs":7,"score":"173\/3","bats":[{"runs":93,"balls_faced":56,"fours":5,"sixes":6,"batsman_id":51191},{"runs":7,"balls_faced":5,"fours":0,"sixes":0,"batsman_id":49444}],"bowls":[{"runs_conceded":28,"maidens":0,"wickets":0,"bowler_id":68691,"overs":4},{"runs_conceded":29,"maidens":0,"wickets":1,"bowler_id":51346,"overs":3}],"commentary":"End of over 17 (7 runs), Glamorgan 173\/3"},{"event_id":"12089756","event":"ball","batsman_id":"49444","bowler_id":"51346","over":"17","ball":"1","score":1,"commentary":"Paul Walter to Chris Cooke, 1 run,","noball_dismissal":false,"text":"","timestamp":1749240741,"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":"12089796","event":"wicket","batsman_id":"51191","bowler_id":"51346","over":"17","ball":"2","score":"w","commentary":"Paul Walter to Kiran Carlson, no run, c MKS Pepper b PI Walter,","noball_dismissal":false,"text":"","timestamp":1749240892,"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":"51191","how_out":"c MKS Pepper b PI Walter","batsman_runs":"93","batsman_balls":"57"},{"event_id":"12089805","event":"ball","batsman_id":"141478","bowler_id":"51346","over":"17","ball":"3","score":1,"commentary":"Paul Walter to Asa Tribe, 1 run,","noball_dismissal":false,"text":"","timestamp":1749240913,"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":"12089807","event":"ball","batsman_id":"49444","bowler_id":"51346","over":"17","ball":"4","score":1,"commentary":"Paul Walter to Chris Cooke, 1 run,","noball_dismissal":false,"text":"","timestamp":1749240915,"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":"12089828","event":"ball","batsman_id":"141478","bowler_id":"51346","over":"17","ball":"5","score":2,"commentary":"Paul Walter to Asa Tribe, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749241037,"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":"12089832","event":"ball","batsman_id":"141478","bowler_id":"51346","over":"17","ball":"6","score":1,"commentary":"Paul Walter to Asa Tribe, 1 run,","noball_dismissal":false,"text":"","timestamp":1749241039,"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":18,"runs":6,"score":"179\/4","bats":[{"runs":4,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":141478},{"runs":9,"balls_faced":7,"fours":0,"sixes":0,"batsman_id":49444}],"bowls":[{"runs_conceded":35,"maidens":0,"wickets":2,"bowler_id":51346,"overs":4},{"runs_conceded":28,"maidens":0,"wickets":0,"bowler_id":68691,"overs":4}],"commentary":"End of over 18 (6 runs), Glamorgan 179\/4"},{"event_id":"12089840","event":"ball","batsman_id":"141478","bowler_id":"1758","over":"18","ball":"1","score":0,"commentary":"Mohammad Amir to Asa Tribe, no run,","noball_dismissal":false,"text":"","timestamp":1749241084,"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":"12089843","event":"ball","batsman_id":"141478","bowler_id":"1758","over":"18","ball":"2","score":0,"commentary":"Mohammad Amir to Asa Tribe, no run,","noball_dismissal":false,"text":"","timestamp":1749241100,"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":"12089852","event":"ball","batsman_id":"141478","bowler_id":"1758","over":"18","ball":"3","score":0,"commentary":"Mohammad Amir to Asa Tribe, no run,","noball_dismissal":false,"text":"","timestamp":1749241107,"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":"12089872","event":"ball","batsman_id":"141478","bowler_id":"1758","over":"18","ball":"4","score":1,"commentary":"Mohammad Amir to Asa Tribe, 1 run,","noball_dismissal":false,"text":"","timestamp":1749241223,"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":"12089873","event":"ball","batsman_id":"49444","bowler_id":"1758","over":"18","ball":"5","score":1,"commentary":"Mohammad Amir to Chris Cooke, 1 run,","noball_dismissal":false,"text":"","timestamp":1749241225,"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":"12089875","event":"ball","batsman_id":"141478","bowler_id":"1758","over":"18","ball":"6","score":4,"commentary":"Mohammad Amir to Asa Tribe, Four,","noball_dismissal":false,"text":"","timestamp":1749241228,"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":19,"runs":6,"score":"185\/4","bats":[{"runs":9,"balls_faced":8,"fours":1,"sixes":0,"batsman_id":141478},{"runs":10,"balls_faced":8,"fours":0,"sixes":0,"batsman_id":49444}],"bowls":[{"runs_conceded":38,"maidens":0,"wickets":0,"bowler_id":1758,"overs":4},{"runs_conceded":35,"maidens":0,"wickets":2,"bowler_id":51346,"overs":4}],"commentary":"End of over 19 (6 runs), Glamorgan 185\/4"}],"day":"0","session":"0","live_inning":{"iid":197565,"number":2,"name":"Glamorgan Inning","short_name":"GLA Inning","status":2,"issuperover":"false","result":3,"batting_team_id":7020,"fielding_team_id":104950,"scores":"185\/4","scores_full":"185\/4 (19 ov)","fielder":[{"fielder_id":"51105","fielder_name":"Michael-Kyle Pepper","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"49083","fielder_name":"Dean Elgar","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"108420","fielder_name":"Luc Benkenstein","catches":1,"runout_thrower":0,"runout_catcher":0,"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":"Kiran Carlson","batsman_id":"51191","runs":"93","balls":"57","how_out":"c MKS Pepper b PI Walter","score_at_dismissal":174,"overs_at_dismissal":"17.2","bowler_id":"51346","dismissal":"caught","number":4},"extra_runs":{"byes":0,"legbyes":1,"wides":5,"noballs":2,"penalty":"0","total":8},"equations":{"runs":185,"wickets":4,"overs":"19","bowlers_used":6,"runrate":"9.74"},"current_partnership":{"runs":11,"balls":10,"overs":1.4,"batsmen":[{"name":"Asa Tribe","batsman_id":141478,"runs":9,"balls":8},{"name":"Chris Cooke","batsman_id":49444,"runs":2,"balls":2}]},"did_not_bat":[{"player_id":"51314","name":"Daniel Douthwaite"},{"player_id":"1907","name":"Timm van der Gugten"},{"player_id":"1051","name":"Mason Crane"},{"player_id":"50477","name":"Andy Gorvin"},{"player_id":"50919","name":"Jamie McIlroy"}],"max_over":"20","target":"184","recent_scores":"4,1,1,0,0,0,1,2,1,1,w,1,0,1,1,1,1,2","last_five_overs":"43\/2 8.32","last_ten_overs":"94\/3 9.10"},"teams":[{"tid":7020,"title":"Glamorgan","abbr":"GLA","alt_name":"GLA","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/glamorgan-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/glamorgan-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"185\/4 (19 ov)","scores":"185\/4","overs":"19"},{"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":"183\/8 (20 ov)","scores":"183\/8","overs":"20"}],"players":[{"pid":1051,"title":"Mason Crane","short_name":"MS Crane","first_name":"Mason Crane","last_name":"","middle_name":"","birthdate":"1997-02-18","birthplace":"Shoreham-by-Sea, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":18969,"recent_appearance":1515022200,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/masoncrane32","instagram_profile":"https:\/\/www.instagram.com\/masoncrane32\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":1143,"title":"Asitha Fernando","short_name":"A Fernando","first_name":"Asitha Fernando","last_name":"","middle_name":"","birthdate":"1997-07-31","birthplace":"Katuneriya","country":"lk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/AsithaFernando78\/","twitter_profile":"https:\/\/twitter.com\/Asitha_Fernando","instagram_profile":"https:\/\/www.instagram.com\/asitha_78\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Sri Lanka","role":"squad","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":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/iamamirofficial","instagram_profile":"https:\/\/www.instagram.com\/official.mamir\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bowl","role_str":""},{"pid":1907,"title":"Timm van der Gugten","short_name":"T Gugten","first_name":"Timm van der Gugten","last_name":"","middle_name":"","birthdate":"1991-02-25","birthplace":"Upper North Shore, Sydney","country":"au","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/hans_gugten46","instagram_profile":"https:\/\/www.instagram.com\/timmvdg\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":10604,"title":"James Harris","short_name":"JAR Harris","first_name":"James Harris","last_name":"","middle_name":"","birthdate":"1990-05-16","birthplace":"Morriston, Swansea, Glamorgan","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\/james_harris9\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":48647,"title":"Matt Critchley","short_name":"MJJ Critchley","first_name":"Matt Critchley","last_name":"","middle_name":"","birthdate":"1996-08-13","birthplace":"Preston, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/mattcritchley96","instagram_profile":"https:\/\/www.instagram.com\/critch130896\/","debut_data":"","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":"","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":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Simon_Harmer_","instagram_profile":"https:\/\/www.instagram.com\/simon_harmer\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bowl","role_str":"(C)"},{"pid":49345,"title":"Billy Root","short_name":"WT Root","first_name":"Billy Root","last_name":"","middle_name":"","birthdate":"1992-08-05","birthplace":" Sheffield, Yorkshire","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/billyroot07\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"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,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Rossington17","instagram_profile":"https:\/\/www.instagram.com\/rossington17\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":49444,"title":"Chris Cooke","short_name":"CB Cooke","first_name":"Chris Cooke","last_name":"","middle_name":"","birthdate":"1986-05-30","birthplace":"Johannesburg, Gauteng","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Cooky_24","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49617,"title":"Sam Northeast","short_name":"SA Northeast","first_name":"Sam Northeast","last_name":"","middle_name":"","birthdate":"1989-10-16","birthplace":" Ashford, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49739,"title":"Colin Ingram","short_name":"CA Ingram","first_name":"Colin Ingram","last_name":"","middle_name":"","birthdate":"1985-07-03","birthplace":" Port Elizabeth","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"Wicketkeeper ","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/ColinIngram41\/","twitter_profile":"https:\/\/twitter.com\/CAIngram41","instagram_profile":"https:\/\/www.instagram.com\/colin_ingram41_cricket\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bat","role_str":""},{"pid":50455,"title":"Feroze Khushi","short_name":"FIN Khushi","first_name":"Feroze Khushi","last_name":"","middle_name":"","birthdate":"1999-06-23","birthplace":"Whipps Cross, Essex","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50477,"title":"Andy Gorvin","short_name":"AW Gorvin","first_name":"Andy Gorvin","last_name":"","middle_name":"","birthdate":"1997-05-10","birthplace":"Winchester, Hampshire","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":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/gorv97","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":50662,"title":"Eddie Byrom","short_name":"EJ Byrom","first_name":"Eddie Byrom","last_name":"","middle_name":"","birthdate":"1997-06-17","birthplace":"Harare, Zimbabwe","country":"zw","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":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/EddieByrom","instagram_profile":"https:\/\/www.instagram.com\/eddie_byrom\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Zimbabwe","role":"squad","role_str":""},{"pid":50919,"title":"Jamie McIlroy","short_name":"JP McIlroy","first_name":"Jamie McIlroy","last_name":"","middle_name":"","birthdate":"1994-06-19","birthplace":"Hereford","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":"https:\/\/twitter.com\/Jamiemcilroy94","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/michael_pep\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":""},{"pid":51191,"title":"Kiran Carlson","short_name":"KS Carlson","first_name":"Kiran Carlson","last_name":"","middle_name":"","birthdate":"1998-05-16","birthplace":"Cardiff, Glamorgan, Wales","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/kiran_carlson\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"pid":51314,"title":"Daniel Douthwaite","short_name":"DA Douthwaite","first_name":"Daniel Douthwaite","last_name":"","middle_name":"","birthdate":"1997-02-08","birthplace":" Kingston-upon-Thames, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/dan.douthwaite.5\/","twitter_profile":"https:\/\/twitter.com\/DanDouthwaite","instagram_profile":"https:\/\/www.instagram.com\/dan_douthwaite88\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/jjordancox\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95765,"title":"Ned Leonard","short_name":"N Leonard","first_name":"Ned Leonard","last_name":"","middle_name":"","birthdate":"2002-08-15","birthplace":"Hammersmith, 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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95841,"title":"William Smale","short_name":"W Smale","first_name":"William Smale","last_name":"","middle_name":"","birthdate":"2001-02-28","birthplace":"Newport S Wales","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":""},{"pid":96508,"title":"Hayden Kerr","short_name":"H Kerr","first_name":"Hayden Kerr","last_name":"","middle_name":"","birthdate":"1996-07-10","birthplace":"Bowral, New South Wales","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/hayden.kerr.790\/","twitter_profile":"https:\/\/twitter.com\/haydenlkerr7","instagram_profile":"https:\/\/www.instagram.com\/haydenlkerr\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":102543,"title":"Alex Horton","short_name":"A Horton","first_name":"Alex Horton","last_name":"","middle_name":"","birthdate":"2004-01-07","birthplace":" Newport, Monmouthshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper ","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/AlexQuidge12","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":102545,"title":"Zain ul Hassan","short_name":"ZU Hassan","first_name":"Zain ul Hassan","last_name":"","middle_name":"","birthdate":"2000-10-28","birthplace":" Islamabad, Punjab","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left 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":"","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":7,"facebook_profile":"https:\/\/www.facebook.com\/robindascricketer","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/robinigblue\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108393,"title":"Jamal Richards","short_name":"J Richards","first_name":"Jamal Richards","last_name":"","middle_name":"","birthdate":"2004-03-03","birthplace":"Edmonton, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":110599,"title":"Tom Bevan","short_name":"TR Bevan","first_name":"Tom Bevan","last_name":"","middle_name":"","birthdate":"1999-09-09","birthplace":"Cardiff, Glamorgan","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":127041,"title":"Ben Morris","short_name":"BJ Morris","first_name":"Ben Morris","last_name":"","middle_name":"","birthdate":"2003-11-04","birthplace":" Abergavenny, Monmouthshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":127528,"title":"Benjamin Kellaway","short_name":"B Kellaway","first_name":"Benjamin Kellaway","last_name":"","middle_name":"","birthdate":"2004-01-05","birthplace":"Newport, Gwen","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":"","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":"","thumb_url":"","profile_image":"","nationality":"Scotland","role":"squad","role_str":""},{"pid":130434,"title":"Henry Hurle","short_name":"H Hurle","first_name":"Henry Hurle","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":"","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":141478,"title":"Asa Tribe","short_name":"A Tribe","first_name":"Asa Tribe","last_name":"","middle_name":"","birthdate":"2004-03-29","birthplace":"","country":"je","primary_team":[],"logo_url":"","playing_role":"bat","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":"","thumb_url":"","profile_image":"","nationality":"Jersey","role":"bat","role_str":""},{"pid":148660,"title":"Callum Nicholls","short_name":"C Nicholls","first_name":"Callum Nicholls","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""}]},"etag":"872f86a86eb8762cb3f424ac6a109f9f","modified":"2025-08-01 09:17:49","datetime":"2025-08-01 09:17:49","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":86847,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Glamorgan won by 6 wickets","day_remaining_over":"","team_batting":"Glamorgan","team_bowling":"Essex","live_inning_number":2,"live_score":{"runs":185,"overs":19,"wickets":4,"target":184,"runrate":9.74,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Chris Cooke","batsman_id":49444,"runs":10,"balls_faced":8,"fours":0,"sixes":0,"strike_rate":"125.00"},{"name":"Asa Tribe","batsman_id":141478,"runs":9,"balls_faced":8,"fours":1,"sixes":0,"strike_rate":"112.50"}],"bowlers":[{"name":"Mohammad Amir","bowler_id":1758,"overs":4,"runs_conceded":38,"wickets":0,"maidens":0,"econ":"9.50"},{"name":"Paul Walter","bowler_id":51346,"overs":4,"runs_conceded":35,"wickets":2,"maidens":0,"econ":"8.75"}],"commentaries":[{"event_id":"12089639","event":"ball","batsman_id":"49739","bowler_id":"49087","over":"14","ball":"6","score":4,"commentary":"Simon Harmer to Colin Ingram, Four,","noball_dismissal":false,"text":"","timestamp":1749240235,"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":15,"runs":19,"score":"161\/2","bats":[{"runs":7,"balls_faced":5,"fours":1,"sixes":0,"batsman_id":49739},{"runs":89,"balls_faced":50,"fours":5,"sixes":6,"batsman_id":51191}],"bowls":[{"runs_conceded":35,"maidens":0,"wickets":1,"bowler_id":49087,"overs":3},{"runs_conceded":32,"maidens":0,"wickets":0,"bowler_id":1758,"overs":3}],"commentary":"End of over 15 (19 runs), Glamorgan 161\/2"},{"event_id":"12089645","event":"ball","batsman_id":"51191","bowler_id":"51346","over":"15","ball":"1","score":0,"commentary":"Paul Walter to Kiran Carlson, no run,","noball_dismissal":false,"text":"","timestamp":1749240238,"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":"12089647","event":"ball","batsman_id":"51191","bowler_id":"51346","over":"15","ball":"2","score":1,"commentary":"Paul Walter to Kiran Carlson, 1 run,","noball_dismissal":false,"text":"","timestamp":1749240241,"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":"12089655","event":"wicket","batsman_id":"49739","bowler_id":"51346","over":"15","ball":"3","score":"w","commentary":"Paul Walter to Colin Ingram, no run, c D Elgar b PI Walter,","noball_dismissal":false,"text":"","timestamp":1749240389,"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":"49739","how_out":"c D Elgar b PI Walter","batsman_runs":"7","batsman_balls":"6"},{"event_id":"12089687","event":"ball","batsman_id":"49444","bowler_id":"51346","over":"15","ball":"4","score":1,"commentary":"Paul Walter to Chris Cooke, 1 run,","noball_dismissal":false,"text":"","timestamp":1749240418,"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":"12089688","event":"ball","batsman_id":"51191","bowler_id":"51346","over":"15","ball":"5","score":1,"commentary":"Paul Walter to Kiran Carlson, 1 run,","noball_dismissal":false,"text":"","timestamp":1749240421,"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":"12089690","event":"ball","batsman_id":"49444","bowler_id":"51346","over":"15","ball":"6","score":2,"commentary":"Paul Walter to Chris Cooke, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749240425,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":16,"runs":5,"score":"166\/3","bats":[{"runs":3,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":49444},{"runs":91,"balls_faced":53,"fours":5,"sixes":6,"batsman_id":51191}],"bowls":[{"runs_conceded":29,"maidens":0,"wickets":1,"bowler_id":51346,"overs":3},{"runs_conceded":35,"maidens":0,"wickets":1,"bowler_id":49087,"overs":3}],"commentary":"End of over 16 (5 runs), Glamorgan 166\/3"},{"event_id":"12089705","event":"ball","batsman_id":"51191","bowler_id":"68691","over":"16","ball":"1","score":1,"commentary":"Samuel Cook to Kiran Carlson, 1 run,","noball_dismissal":false,"text":"","timestamp":1749240490,"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":"12089728","event":"ball","batsman_id":"49444","bowler_id":"68691","over":"16","ball":"2","score":2,"commentary":"Samuel Cook to Chris Cooke, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749240612,"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":"12089730","event":"ball","batsman_id":"49444","bowler_id":"68691","over":"16","ball":"3","score":"1wd","commentary":"Samuel Cook to Chris Cooke, 1 wide,","noball_dismissal":false,"text":"","timestamp":1749240615,"run":1,"noball_run":"0","wide_run":"1","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12089731","event":"ball","batsman_id":"49444","bowler_id":"68691","over":"16","ball":"3","score":1,"commentary":"Samuel Cook to Chris Cooke, 1 run,","noball_dismissal":false,"text":"","timestamp":1749240617,"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":"12089732","event":"ball","batsman_id":"51191","bowler_id":"68691","over":"16","ball":"4","score":1,"commentary":"Samuel Cook to Kiran Carlson, 1 run,","noball_dismissal":false,"text":"","timestamp":1749240619,"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":"12089746","event":"ball","batsman_id":"49444","bowler_id":"68691","over":"16","ball":"5","score":1,"commentary":"Samuel Cook to Chris Cooke, 1 run,","noball_dismissal":false,"text":"","timestamp":1749240679,"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":"12089748","event":"ball","batsman_id":"51191","bowler_id":"68691","over":"16","ball":"6","score":0,"commentary":"Samuel Cook to Kiran Carlson, no run,","noball_dismissal":false,"text":"","timestamp":1749240681,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":17,"runs":7,"score":"173\/3","bats":[{"runs":93,"balls_faced":56,"fours":5,"sixes":6,"batsman_id":51191},{"runs":7,"balls_faced":5,"fours":0,"sixes":0,"batsman_id":49444}],"bowls":[{"runs_conceded":28,"maidens":0,"wickets":0,"bowler_id":68691,"overs":4},{"runs_conceded":29,"maidens":0,"wickets":1,"bowler_id":51346,"overs":3}],"commentary":"End of over 17 (7 runs), Glamorgan 173\/3"},{"event_id":"12089756","event":"ball","batsman_id":"49444","bowler_id":"51346","over":"17","ball":"1","score":1,"commentary":"Paul Walter to Chris Cooke, 1 run,","noball_dismissal":false,"text":"","timestamp":1749240741,"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":"12089796","event":"wicket","batsman_id":"51191","bowler_id":"51346","over":"17","ball":"2","score":"w","commentary":"Paul Walter to Kiran Carlson, no run, c MKS Pepper b PI Walter,","noball_dismissal":false,"text":"","timestamp":1749240892,"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":"51191","how_out":"c MKS Pepper b PI Walter","batsman_runs":"93","batsman_balls":"57"},{"event_id":"12089805","event":"ball","batsman_id":"141478","bowler_id":"51346","over":"17","ball":"3","score":1,"commentary":"Paul Walter to Asa Tribe, 1 run,","noball_dismissal":false,"text":"","timestamp":1749240913,"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":"12089807","event":"ball","batsman_id":"49444","bowler_id":"51346","over":"17","ball":"4","score":1,"commentary":"Paul Walter to Chris Cooke, 1 run,","noball_dismissal":false,"text":"","timestamp":1749240915,"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":"12089828","event":"ball","batsman_id":"141478","bowler_id":"51346","over":"17","ball":"5","score":2,"commentary":"Paul Walter to Asa Tribe, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749241037,"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":"12089832","event":"ball","batsman_id":"141478","bowler_id":"51346","over":"17","ball":"6","score":1,"commentary":"Paul Walter to Asa Tribe, 1 run,","noball_dismissal":false,"text":"","timestamp":1749241039,"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":18,"runs":6,"score":"179\/4","bats":[{"runs":4,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":141478},{"runs":9,"balls_faced":7,"fours":0,"sixes":0,"batsman_id":49444}],"bowls":[{"runs_conceded":35,"maidens":0,"wickets":2,"bowler_id":51346,"overs":4},{"runs_conceded":28,"maidens":0,"wickets":0,"bowler_id":68691,"overs":4}],"commentary":"End of over 18 (6 runs), Glamorgan 179\/4"},{"event_id":"12089840","event":"ball","batsman_id":"141478","bowler_id":"1758","over":"18","ball":"1","score":0,"commentary":"Mohammad Amir to Asa Tribe, no run,","noball_dismissal":false,"text":"","timestamp":1749241084,"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":"12089843","event":"ball","batsman_id":"141478","bowler_id":"1758","over":"18","ball":"2","score":0,"commentary":"Mohammad Amir to Asa Tribe, no run,","noball_dismissal":false,"text":"","timestamp":1749241100,"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":"12089852","event":"ball","batsman_id":"141478","bowler_id":"1758","over":"18","ball":"3","score":0,"commentary":"Mohammad Amir to Asa Tribe, no run,","noball_dismissal":false,"text":"","timestamp":1749241107,"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":"12089872","event":"ball","batsman_id":"141478","bowler_id":"1758","over":"18","ball":"4","score":1,"commentary":"Mohammad Amir to Asa Tribe, 1 run,","noball_dismissal":false,"text":"","timestamp":1749241223,"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":"12089873","event":"ball","batsman_id":"49444","bowler_id":"1758","over":"18","ball":"5","score":1,"commentary":"Mohammad Amir to Chris Cooke, 1 run,","noball_dismissal":false,"text":"","timestamp":1749241225,"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":"12089875","event":"ball","batsman_id":"141478","bowler_id":"1758","over":"18","ball":"6","score":4,"commentary":"Mohammad Amir to Asa Tribe, Four,","noball_dismissal":false,"text":"","timestamp":1749241228,"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":19,"runs":6,"score":"185\/4","bats":[{"runs":9,"balls_faced":8,"fours":1,"sixes":0,"batsman_id":141478},{"runs":10,"balls_faced":8,"fours":0,"sixes":0,"batsman_id":49444}],"bowls":[{"runs_conceded":38,"maidens":0,"wickets":0,"bowler_id":1758,"overs":4},{"runs_conceded":35,"maidens":0,"wickets":2,"bowler_id":51346,"overs":4}],"commentary":"End of over 19 (6 runs), Glamorgan 185\/4"}],"day":"0","session":"0","live_inning":{"iid":197565,"number":2,"name":"Glamorgan Inning","short_name":"GLA Inning","status":2,"issuperover":"false","result":3,"batting_team_id":7020,"fielding_team_id":104950,"scores":"185\/4","scores_full":"185\/4 (19 ov)","fielder":[{"fielder_id":"51105","fielder_name":"Michael-Kyle Pepper","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"49083","fielder_name":"Dean Elgar","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"108420","fielder_name":"Luc Benkenstein","catches":1,"runout_thrower":0,"runout_catcher":0,"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":"Kiran Carlson","batsman_id":"51191","runs":"93","balls":"57","how_out":"c MKS Pepper b PI Walter","score_at_dismissal":174,"overs_at_dismissal":"17.2","bowler_id":"51346","dismissal":"caught","number":4},"extra_runs":{"byes":0,"legbyes":1,"wides":5,"noballs":2,"penalty":"0","total":8},"equations":{"runs":185,"wickets":4,"overs":"19","bowlers_used":6,"runrate":"9.74"},"current_partnership":{"runs":11,"balls":10,"overs":1.4,"batsmen":[{"name":"Asa Tribe","batsman_id":141478,"runs":9,"balls":8},{"name":"Chris Cooke","batsman_id":49444,"runs":2,"balls":2}]},"did_not_bat":[{"player_id":"51314","name":"Daniel Douthwaite"},{"player_id":"1907","name":"Timm van der Gugten"},{"player_id":"1051","name":"Mason Crane"},{"player_id":"50477","name":"Andy Gorvin"},{"player_id":"50919","name":"Jamie McIlroy"}],"max_over":"20","target":"184","recent_scores":"4,1,1,0,0,0,1,2,1,1,w,1,0,1,1,1,1,2","last_five_overs":"43\/2 8.32","last_ten_overs":"94\/3 9.10"},"teams":[{"tid":7020,"title":"Glamorgan","abbr":"GLA","alt_name":"GLA","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/glamorgan-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/glamorgan-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"185\/4 (19 ov)","scores":"185\/4","overs":"19"},{"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":"183\/8 (20 ov)","scores":"183\/8","overs":"20"}],"players":[{"pid":1051,"title":"Mason Crane","short_name":"MS Crane","first_name":"Mason Crane","last_name":"","middle_name":"","birthdate":"1997-02-18","birthplace":"Shoreham-by-Sea, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":18969,"recent_appearance":1515022200,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/masoncrane32","instagram_profile":"https:\/\/www.instagram.com\/masoncrane32\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":1143,"title":"Asitha Fernando","short_name":"A Fernando","first_name":"Asitha Fernando","last_name":"","middle_name":"","birthdate":"1997-07-31","birthplace":"Katuneriya","country":"lk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/AsithaFernando78\/","twitter_profile":"https:\/\/twitter.com\/Asitha_Fernando","instagram_profile":"https:\/\/www.instagram.com\/asitha_78\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Sri Lanka","role":"squad","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":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/iamamirofficial","instagram_profile":"https:\/\/www.instagram.com\/official.mamir\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bowl","role_str":""},{"pid":1907,"title":"Timm van der Gugten","short_name":"T Gugten","first_name":"Timm van der Gugten","last_name":"","middle_name":"","birthdate":"1991-02-25","birthplace":"Upper North Shore, Sydney","country":"au","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/hans_gugten46","instagram_profile":"https:\/\/www.instagram.com\/timmvdg\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":10604,"title":"James Harris","short_name":"JAR Harris","first_name":"James Harris","last_name":"","middle_name":"","birthdate":"1990-05-16","birthplace":"Morriston, Swansea, Glamorgan","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\/james_harris9\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":48647,"title":"Matt Critchley","short_name":"MJJ Critchley","first_name":"Matt Critchley","last_name":"","middle_name":"","birthdate":"1996-08-13","birthplace":"Preston, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/mattcritchley96","instagram_profile":"https:\/\/www.instagram.com\/critch130896\/","debut_data":"","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":"","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":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Simon_Harmer_","instagram_profile":"https:\/\/www.instagram.com\/simon_harmer\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bowl","role_str":"(C)"},{"pid":49345,"title":"Billy Root","short_name":"WT Root","first_name":"Billy Root","last_name":"","middle_name":"","birthdate":"1992-08-05","birthplace":" Sheffield, Yorkshire","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/billyroot07\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"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,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Rossington17","instagram_profile":"https:\/\/www.instagram.com\/rossington17\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":49444,"title":"Chris Cooke","short_name":"CB Cooke","first_name":"Chris Cooke","last_name":"","middle_name":"","birthdate":"1986-05-30","birthplace":"Johannesburg, Gauteng","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Cooky_24","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49617,"title":"Sam Northeast","short_name":"SA Northeast","first_name":"Sam Northeast","last_name":"","middle_name":"","birthdate":"1989-10-16","birthplace":" Ashford, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49739,"title":"Colin Ingram","short_name":"CA Ingram","first_name":"Colin Ingram","last_name":"","middle_name":"","birthdate":"1985-07-03","birthplace":" Port Elizabeth","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"Wicketkeeper ","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/ColinIngram41\/","twitter_profile":"https:\/\/twitter.com\/CAIngram41","instagram_profile":"https:\/\/www.instagram.com\/colin_ingram41_cricket\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bat","role_str":""},{"pid":50455,"title":"Feroze Khushi","short_name":"FIN Khushi","first_name":"Feroze Khushi","last_name":"","middle_name":"","birthdate":"1999-06-23","birthplace":"Whipps Cross, Essex","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50477,"title":"Andy Gorvin","short_name":"AW Gorvin","first_name":"Andy Gorvin","last_name":"","middle_name":"","birthdate":"1997-05-10","birthplace":"Winchester, Hampshire","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":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/gorv97","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":50662,"title":"Eddie Byrom","short_name":"EJ Byrom","first_name":"Eddie Byrom","last_name":"","middle_name":"","birthdate":"1997-06-17","birthplace":"Harare, Zimbabwe","country":"zw","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":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/EddieByrom","instagram_profile":"https:\/\/www.instagram.com\/eddie_byrom\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Zimbabwe","role":"squad","role_str":""},{"pid":50919,"title":"Jamie McIlroy","short_name":"JP McIlroy","first_name":"Jamie McIlroy","last_name":"","middle_name":"","birthdate":"1994-06-19","birthplace":"Hereford","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":"https:\/\/twitter.com\/Jamiemcilroy94","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/michael_pep\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":""},{"pid":51191,"title":"Kiran Carlson","short_name":"KS Carlson","first_name":"Kiran Carlson","last_name":"","middle_name":"","birthdate":"1998-05-16","birthplace":"Cardiff, Glamorgan, Wales","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/kiran_carlson\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"pid":51314,"title":"Daniel Douthwaite","short_name":"DA Douthwaite","first_name":"Daniel Douthwaite","last_name":"","middle_name":"","birthdate":"1997-02-08","birthplace":" Kingston-upon-Thames, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/dan.douthwaite.5\/","twitter_profile":"https:\/\/twitter.com\/DanDouthwaite","instagram_profile":"https:\/\/www.instagram.com\/dan_douthwaite88\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/jjordancox\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95765,"title":"Ned Leonard","short_name":"N Leonard","first_name":"Ned Leonard","last_name":"","middle_name":"","birthdate":"2002-08-15","birthplace":"Hammersmith, 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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95841,"title":"William Smale","short_name":"W Smale","first_name":"William Smale","last_name":"","middle_name":"","birthdate":"2001-02-28","birthplace":"Newport S Wales","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":""},{"pid":96508,"title":"Hayden Kerr","short_name":"H Kerr","first_name":"Hayden Kerr","last_name":"","middle_name":"","birthdate":"1996-07-10","birthplace":"Bowral, New South Wales","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/hayden.kerr.790\/","twitter_profile":"https:\/\/twitter.com\/haydenlkerr7","instagram_profile":"https:\/\/www.instagram.com\/haydenlkerr\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":102543,"title":"Alex Horton","short_name":"A Horton","first_name":"Alex Horton","last_name":"","middle_name":"","birthdate":"2004-01-07","birthplace":" Newport, Monmouthshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper ","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/AlexQuidge12","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":102545,"title":"Zain ul Hassan","short_name":"ZU Hassan","first_name":"Zain ul Hassan","last_name":"","middle_name":"","birthdate":"2000-10-28","birthplace":" Islamabad, Punjab","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left 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":"","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":7,"facebook_profile":"https:\/\/www.facebook.com\/robindascricketer","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/robinigblue\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108393,"title":"Jamal Richards","short_name":"J Richards","first_name":"Jamal Richards","last_name":"","middle_name":"","birthdate":"2004-03-03","birthplace":"Edmonton, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":110599,"title":"Tom Bevan","short_name":"TR Bevan","first_name":"Tom Bevan","last_name":"","middle_name":"","birthdate":"1999-09-09","birthplace":"Cardiff, Glamorgan","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":127041,"title":"Ben Morris","short_name":"BJ Morris","first_name":"Ben Morris","last_name":"","middle_name":"","birthdate":"2003-11-04","birthplace":" Abergavenny, Monmouthshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":127528,"title":"Benjamin Kellaway","short_name":"B Kellaway","first_name":"Benjamin Kellaway","last_name":"","middle_name":"","birthdate":"2004-01-05","birthplace":"Newport, Gwen","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":"","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":"","thumb_url":"","profile_image":"","nationality":"Scotland","role":"squad","role_str":""},{"pid":130434,"title":"Henry Hurle","short_name":"H Hurle","first_name":"Henry Hurle","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":"","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":141478,"title":"Asa Tribe","short_name":"A Tribe","first_name":"Asa Tribe","last_name":"","middle_name":"","birthdate":"2004-03-29","birthplace":"","country":"je","primary_team":[],"logo_url":"","playing_role":"bat","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":"","thumb_url":"","profile_image":"","nationality":"Jersey","role":"bat","role_str":""},{"pid":148660,"title":"Callum Nicholls","short_name":"C Nicholls","first_name":"Callum Nicholls","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""}]},"etag":"872f86a86eb8762cb3f424ac6a109f9f","modified":"2025-08-01 09:17:49","datetime":"2025-08-01 09:17:49","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86847 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:f8e94000-f174-4a12-8389-08eadb27374f Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86847 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86847,3,'{"status":"ok","response":{"match_id":86847,"title":"Glamorgan vs Essex","short_title":"GLA vs ESS","subtitle":"Match 27","match_number":"27","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Glamorgan won by 6 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129425,"title":"Vitality Blast","abbr":"Vitality Blast","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-09-13","country":"en","total_matches":"133","total_rounds":"2","total_teams":"18"},"teama":{"team_id":7020,"name":"Glamorgan","short_name":"GLA","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/glamorgan-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/glamorgan-logo.png","scores_full":"185\/4 (19 ov)","scores":"185\/4","overs":"19"},"teamb":{"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":"183\/8 (20 ov)","scores":"183\/8","overs":"20"},"date_start":"2025-06-06 17:30:00","date_end":"2025-06-07 03:30:00","timestamp_start":1749231000,"timestamp_end":1749267000,"date_start_ist":"2025-06-06 23:00:00","date_end_ist":"2025-06-07 09:00:00","venue":{"venue_id":"7","name":"Sophia Gardens","location":"Cardiff","country":"England","timezone":""},"umpires":"Naeem Ashraf (England), Hassan Adnan (England)","referee":"Simon Hinks (England)","equation":"","live":"","result":"GLA won by 6 wickets","result_type":1,"win_margin":"6 wickets","winning_team_id":7020,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-05 01:54:37","verify_time":"2025-06-07 02:09:23","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":14.71,"humidity":72,"visibility":10000,"wind_speed":"25.95","clouds":100},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Slow Spin"},"toss":{"text":"Glamorgan elected to bowl","winner":7020,"decision":2}},"etag":"13848c5f265e2b62d79473c60cba4fc0","modified":"2025-08-01 09:17:50","datetime":"2025-08-01 09:17:50","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":86847,"title":"Glamorgan vs Essex","short_title":"GLA vs ESS","subtitle":"Match 27","match_number":"27","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Glamorgan won by 6 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129425,"title":"Vitality Blast","abbr":"Vitality Blast","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-09-13","country":"en","total_matches":"133","total_rounds":"2","total_teams":"18"},"teama":{"team_id":7020,"name":"Glamorgan","short_name":"GLA","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/glamorgan-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/glamorgan-logo.png","scores_full":"185\/4 (19 ov)","scores":"185\/4","overs":"19"},"teamb":{"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":"183\/8 (20 ov)","scores":"183\/8","overs":"20"},"date_start":"2025-06-06 17:30:00","date_end":"2025-06-07 03:30:00","timestamp_start":1749231000,"timestamp_end":1749267000,"date_start_ist":"2025-06-06 23:00:00","date_end_ist":"2025-06-07 09:00:00","venue":{"venue_id":"7","name":"Sophia Gardens","location":"Cardiff","country":"England","timezone":""},"umpires":"Naeem Ashraf (England), Hassan Adnan (England)","referee":"Simon Hinks (England)","equation":"","live":"","result":"GLA won by 6 wickets","result_type":1,"win_margin":"6 wickets","winning_team_id":7020,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-05 01:54:37","verify_time":"2025-06-07 02:09:23","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":14.71,"humidity":72,"visibility":10000,"wind_speed":"25.95","clouds":100},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Slow Spin"},"toss":{"text":"Glamorgan elected to bowl","winner":7020,"decision":2}},"etag":"13848c5f265e2b62d79473c60cba4fc0","modified":"2025-08-01 09:17:50","datetime":"2025-08-01 09:17:50","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86847 AND DataTypeId = 3 END
Live Report & Scorecard of Glamorgan vs Essex Match 27
<>
LIVE06 May Match 5

Hong Kong WomenHong Kong Women

Kuwait Women

 
LIVE06 May Match 6

Thailand WomenThailand Women

United Arab Emirates Women

 
LIVEToday55th Match

NottinghamshireNottinghamshire*511/6 (151 ov)

Somerset438/10 (132.3 ov)

 Stumps : Day 3 - Nottinghamshire lead by 73 runs.
LIVEToday54th Match

WorcestershireWorcestershire249/10 (91.1 ov)

Hampshire293/10 (87.3 ov) & *139/2 (42 ov)

 Stumps : Day 3 - Hampshire lead by 183 runs.
LIVEToday52nd Match

EssexEssex602/6d (149 ov)

Warwickshire*465/9 (127.4 ov)

 Stumps : Day 3 - Warwickshire trail by 137 runs.
LIVEToday53rd Match

YorkshireYorkshire545/9d (140 ov)

Sussex222/10 (99.5 ov) & *115/3 (44 ov)

 Stumps : Day 3 - Sussex trail by 208 runs.
LIVEToday42nd Match

GloucestershireGloucestershire*54/1 (21 ov)

Middlesex445/10 (108.5 ov)

 Stumps : Day 3 - Gloucestershire trail by 391 runs.
LIVEToday44th Match

KentKent*217/3 (78.5 ov)

Leicestershire471/10 (114.5 ov)

 Stumps : Day 3 - Kent trail by 254 runs.
LIVEToday43rd Match

LancashireLancashire137/10 (52.3 ov) & *226/5 (51 ov)

Glamorgan261/10 (97.2 ov) & 348/7d (76 ov)

 Stumps : Day 3 - Lancashire need 247 runs to win.
LIVEToday41st Match

NorthamptonshireNorthamptonshire550/9d (155.5 ov)

Derbyshire377/10 (104.2 ov) & *52/4 (24 ov)

 Stumps : Day 3 - Derbyshire trail by 121 runs.
LIVEToday1st Test

ZimbabweZimbabwe149/10 (60.3 ov) & *82/4 (29.1 ov)

New Zealand307/10 (96.1 ov)

 Day 3 - Session 1, Zimbabwe trail by 76 runs.
LIVEToday5th Test

EnglandEngland

India*204/6 (64 ov)

 Stumps : Day 1 - England elected to bowl
LIVETodayMatch 3

PerakPerak206/6 (20 ov)

Kuala lumpur*165/7 (18.3 ov)

 Kuala lumpur need 42 runs in 9 remaining balls
LIVETodayMatch 4

SarawakSarawak187/5 (20 ov)

Penang*154/2 (11.3 ov)

 Penang need 34 runs in 51 remaining balls
LIVETodayMatch 1

Paratus JetsParatus Jets202/3 (20 ov)

NPL Bears0/0 ( ov)

 Innings Break : NPL Bears need 203 runs in 20 remaining overs
LIVETodayMatch 10

Guwahati GiantsGuwahati Giants

City Cricket Club95/10 (19.4 ov)

 Innings Break : City Cricket Club elected to bat
LIVETodayMatch 21

London County CricketLondon County Cricket

Wimbledon*51/2 (3.2 ov)

 London County Cricket elected to bowl
CancelledTodayMatch 1

PiratesPirates

Comets

 Match Abondoned
CancelledTodayMatch 2

MarlinsMarlins

Rockets

 Match Abondoned
Scheduled01 August Match 22

GuildfordGuildford

Wimbledon

 
CricDirect Cricket News, Results and Stats
 

Glamorgan vs Essex, Match 27, Vitality Blast

Completed
Vitality Blast, Completed
Glamorgan
GLA
185/4 (19)
Essex
ESS
183/8 (20)
Glamorgan won by 6 wickets
Match Details
Date
2025-06-06 17:30:00
Venue
Sophia Gardens, Cardiff
Toss
Glamorgan elected to bowl
Umpires
    Tv Umpires
      Match Referee
        × Close