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:1db46ddb-cd69-4c9f-9e8a-33580b1aa8f4 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86862 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86862,1,'{"status":"ok","response":{"mid":86862,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Glamorgan won by 40 runs","day_remaining_over":"","team_batting":"Essex","team_bowling":"Glamorgan","live_inning_number":2,"live_score":{"runs":180,"overs":19.5,"wickets":10,"target":221,"runrate":9.08,"required_runrate":246},"commentary":1,"wagon":2,"batsmen":[{"name":"Luc Benkenstein","batsman_id":108420,"runs":62,"balls_faced":32,"fours":6,"sixes":4,"strike_rate":"193.75"},{"name":"Mohammad Amir","batsman_id":1758,"runs":0,"balls_faced":0,"fours":0,"sixes":0,"strike_rate":"0.00"}],"bowlers":[{"name":"Andy Gorvin","bowler_id":50477,"overs":2.5,"runs_conceded":38,"wickets":1,"maidens":0,"econ":"13.41"},{"name":"Daniel Douthwaite","bowler_id":51314,"overs":3,"runs_conceded":25,"wickets":1,"maidens":0,"econ":"8.33"}],"commentaries":[{"event_id":"12130118","event":"ball","batsman_id":"108420","bowler_id":"127528","over":"15","ball":"4","score":4,"commentary":"Benjamin Kellaway to Luc Benkenstein, Four,","noball_dismissal":false,"text":"","timestamp":1749758959,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12130120","event":"ball","batsman_id":"108420","bowler_id":"127528","over":"15","ball":"5","score":4,"commentary":"Benjamin Kellaway to Luc Benkenstein, Four,","noball_dismissal":false,"text":"","timestamp":1749758975,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12130123","event":"ball","batsman_id":"108420","bowler_id":"127528","over":"15","ball":"6","score":1,"commentary":"Benjamin Kellaway to Luc Benkenstein, 1 run,","noball_dismissal":false,"text":"","timestamp":1749759002,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":16,"runs":16,"score":"145\/7","bats":[{"runs":39,"balls_faced":19,"fours":3,"sixes":3,"batsman_id":108420},{"runs":0,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":61358}],"bowls":[{"runs_conceded":29,"maidens":0,"wickets":2,"bowler_id":127528,"overs":3},{"runs_conceded":23,"maidens":0,"wickets":1,"bowler_id":95765,"overs":3}],"commentary":"End of over 16 (16 runs), Essex 145\/7"},{"event_id":"12130143","event":"ball","batsman_id":"108420","bowler_id":"95765","over":"16","ball":"1","score":1,"commentary":"Ned Leonard to Luc Benkenstein, 1 run,","noball_dismissal":false,"text":"","timestamp":1749759197,"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":"12130144","event":"ball","batsman_id":"61358","bowler_id":"95765","over":"16","ball":"2","score":"1lb","commentary":"Ned Leonard to Shane Snater, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1749759200,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"1","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12130145","event":"ball","batsman_id":"108420","bowler_id":"95765","over":"16","ball":"3","score":1,"commentary":"Ned Leonard to Luc Benkenstein, 1 run,","noball_dismissal":false,"text":"","timestamp":1749759239,"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":"12130146","event":"ball","batsman_id":"61358","bowler_id":"95765","over":"16","ball":"4","score":4,"commentary":"Ned Leonard to Shane Snater, Four,","noball_dismissal":false,"text":"","timestamp":1749759241,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12130147","event":"ball","batsman_id":"61358","bowler_id":"95765","over":"16","ball":"5","score":1,"commentary":"Ned Leonard to Shane Snater, 1 run,","noball_dismissal":false,"text":"","timestamp":1749759249,"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":"12130148","event":"ball","batsman_id":"108420","bowler_id":"95765","over":"16","ball":"6","score":4,"commentary":"Ned Leonard to Luc Benkenstein, Four,","noball_dismissal":false,"text":"","timestamp":1749759251,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event":"overend","over":17,"runs":12,"score":"157\/7","bats":[{"runs":45,"balls_faced":22,"fours":4,"sixes":3,"batsman_id":108420},{"runs":5,"balls_faced":4,"fours":1,"sixes":0,"batsman_id":61358}],"bowls":[{"runs_conceded":34,"maidens":0,"wickets":1,"bowler_id":95765,"overs":4},{"runs_conceded":29,"maidens":0,"wickets":2,"bowler_id":127528,"overs":3}],"commentary":"End of over 17 (12 runs), Essex 157\/7"},{"event_id":"12130156","event":"ball","batsman_id":"61358","bowler_id":"1051","over":"17","ball":"1","score":1,"commentary":"Mason Crane to Shane Snater, 1 run,","noball_dismissal":false,"text":"","timestamp":1749759329,"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":"12130157","event":"ball","batsman_id":"108420","bowler_id":"1051","over":"17","ball":"2","score":1,"commentary":"Mason Crane to Luc Benkenstein, 1 run,","noball_dismissal":false,"text":"","timestamp":1749759332,"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":"12130158","event":"wicket","batsman_id":"61358","bowler_id":"1051","over":"17","ball":"3","score":"w","commentary":"Mason Crane to Shane Snater, no run, c B Kellaway b MS Crane,","noball_dismissal":false,"text":"","timestamp":1749759409,"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":"61358","how_out":"c B Kellaway b MS Crane","batsman_runs":"6","batsman_balls":"6"},{"event_id":"12130168","event":"ball","batsman_id":"68691","bowler_id":"1051","over":"17","ball":"4","score":0,"commentary":"Mason Crane to Samuel Cook, no run,","noball_dismissal":false,"text":"","timestamp":1749759429,"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":"12130173","event":"ball","batsman_id":"68691","bowler_id":"1051","over":"17","ball":"5","score":1,"commentary":"Mason Crane to Samuel Cook, 1 run,","noball_dismissal":false,"text":"","timestamp":1749759470,"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":"12130174","event":"ball","batsman_id":"108420","bowler_id":"1051","over":"17","ball":"6","score":6,"commentary":"Mason Crane to Luc Benkenstein, Six,","noball_dismissal":false,"text":"","timestamp":1749759473,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event":"overend","over":18,"runs":9,"score":"166\/8","bats":[{"runs":52,"balls_faced":24,"fours":4,"sixes":4,"batsman_id":108420},{"runs":1,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":68691}],"bowls":[{"runs_conceded":24,"maidens":0,"wickets":3,"bowler_id":1051,"overs":4},{"runs_conceded":34,"maidens":0,"wickets":1,"bowler_id":95765,"overs":4}],"commentary":"End of over 18 (9 runs), Essex 166\/8"},{"event_id":"12130190","event":"ball","batsman_id":"68691","bowler_id":"51314","over":"18","ball":"1","score":1,"commentary":"Daniel Douthwaite to Samuel Cook, 1 run,","noball_dismissal":false,"text":"","timestamp":1749759615,"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":"12130192","event":"ball","batsman_id":"108420","bowler_id":"51314","over":"18","ball":"2","score":0,"commentary":"Daniel Douthwaite to Luc Benkenstein, no run,","noball_dismissal":false,"text":"","timestamp":1749759618,"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":"12130193","event":"ball","batsman_id":"108420","bowler_id":"51314","over":"18","ball":"3","score":4,"commentary":"Daniel Douthwaite to Luc Benkenstein, Four,","noball_dismissal":false,"text":"","timestamp":1749759624,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12130194","event":"ball","batsman_id":"108420","bowler_id":"51314","over":"18","ball":"4","score":1,"commentary":"Daniel Douthwaite to Luc Benkenstein, 1 run,","noball_dismissal":false,"text":"","timestamp":1749759633,"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":"12130196","event":"ball","batsman_id":"68691","bowler_id":"51314","over":"18","ball":"5","score":1,"commentary":"Daniel Douthwaite to Samuel Cook, 1 run,","noball_dismissal":false,"text":"","timestamp":1749759676,"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":"12130198","event":"ball","batsman_id":"108420","bowler_id":"51314","over":"18","ball":"6","score":0,"commentary":"Daniel Douthwaite to Luc Benkenstein, no run,","noball_dismissal":false,"text":"","timestamp":1749759697,"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":19,"runs":7,"score":"173\/8","bats":[{"runs":57,"balls_faced":28,"fours":5,"sixes":4,"batsman_id":108420},{"runs":3,"balls_faced":4,"fours":0,"sixes":0,"batsman_id":68691}],"bowls":[{"runs_conceded":25,"maidens":0,"wickets":1,"bowler_id":51314,"overs":3},{"runs_conceded":24,"maidens":0,"wickets":3,"bowler_id":1051,"overs":4}],"commentary":"End of over 19 (7 runs), Essex 173\/8"},{"event_id":"12130215","event":"ball","batsman_id":"68691","bowler_id":"50477","over":"19","ball":"1","score":1,"commentary":"Andy Gorvin to Samuel Cook, 1 run,","noball_dismissal":false,"text":"","timestamp":1749759874,"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":"12130216","event":"ball","batsman_id":"108420","bowler_id":"50477","over":"19","ball":"2","score":"1wd","commentary":"Andy Gorvin to Luc Benkenstein, 1 wide,","noball_dismissal":false,"text":"","timestamp":1749759877,"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":"12130217","event":"ball","batsman_id":"108420","bowler_id":"50477","over":"19","ball":"2","score":4,"commentary":"Andy Gorvin to Luc Benkenstein, Four,","noball_dismissal":false,"text":"","timestamp":1749759880,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12130218","event":"wicket","batsman_id":"108420","bowler_id":"50477","over":"19","ball":"3","score":"w","commentary":"Andy Gorvin to Luc Benkenstein, 1 run, runout (AW Gorvin \/ A Tribe),","noball_dismissal":false,"text":"","timestamp":1749760056,"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,"wicket_batsman_id":"68691","how_out":"runout (AW Gorvin \/ A Tribe)","batsman_runs":"4","batsman_balls":"5"},{"event_id":"12130225","event":"ball","batsman_id":"108420","bowler_id":"50477","over":"19","ball":"4","score":0,"commentary":"Andy Gorvin to Luc Benkenstein, no run,","noball_dismissal":false,"text":"","timestamp":1749759948,"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":"12130226","event":"wicket","batsman_id":"108420","bowler_id":"50477","over":"19","ball":"5","score":"w","commentary":"Andy Gorvin to Luc Benkenstein, no run, c CA Ingram b AW Gorvin,","noball_dismissal":false,"text":"","timestamp":1749760063,"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":"108420","how_out":"c CA Ingram b AW Gorvin","batsman_runs":"62","batsman_balls":"32"}],"day":"0","session":"0","live_inning":{"iid":197937,"number":2,"name":"Essex Inning","short_name":"ESS Inning","status":2,"issuperover":"false","result":1,"batting_team_id":104950,"fielding_team_id":7020,"scores":"180\/10","scores_full":"180\/10 (19.5 ov)","fielder":[{"fielder_id":"49739","fielder_name":"Colin Ingram","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"51314","fielder_name":"Daniel Douthwaite","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"49444","fielder_name":"Chris Cooke","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"141478","fielder_name":"Asa Tribe","catches":1,"runout_thrower":1,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"50477","fielder_name":"Andy Gorvin","catches":1,"runout_thrower":0,"runout_catcher":1,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"127528","fielder_name":"Benjamin Kellaway","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":"Luc Benkenstein","batsman_id":"108420","runs":"62","balls":"32","how_out":"c CA Ingram b AW Gorvin","score_at_dismissal":180,"overs_at_dismissal":"19.5","bowler_id":"50477","dismissal":"caught","number":10},"extra_runs":{"byes":4,"legbyes":2,"wides":2,"noballs":0,"penalty":"0","total":8},"equations":{"runs":180,"wickets":10,"overs":"19.5","bowlers_used":6,"runrate":"9.08"},"current_partnership":{"runs":0,"balls":2,"overs":0.2,"batsmen":[{"name":"Luc Benkenstein","batsman_id":108420,"runs":0,"balls":2},{"name":"Mohammad Amir","batsman_id":1758,"runs":0,"balls":0}]},"did_not_bat":[],"max_over":"20","target":"221","recent_scores":"w,0,w,4,1,1,0,1,1,4,0,1,6,1,0,w,1,1","last_five_overs":"52\/4 10.06","last_ten_overs":"89\/6 8.75"},"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":"220\/6 (20 ov)","scores":"220\/6","overs":"20"},{"tid":104950,"title":"Essex","abbr":"ESS","alt_name":"ESS","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"180\/10 (19.5 ov)","scores":"180\/10","overs":"19.5"}],"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.5,"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,"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":8.5,"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":7.5,"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,"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,"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":6.5,"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":46837,"title":"Eathan Bosch","short_name":"E Bosch","first_name":"Eathan Bosch","last_name":"","middle_name":"","birthdate":"1998-04-27","birthplace":"Westville","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"https:\/\/www.facebook.com\/eathan.bosch.14\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/eathanbosch\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":48647,"title":"Matt Critchley","short_name":"MJJ Critchley","first_name":"Matt Critchley","last_name":"","middle_name":"","birthdate":"1996-08-13","birthplace":"Preston, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/mattcritchley96","instagram_profile":"https:\/\/www.instagram.com\/critch130896\/","debut_data":"","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":9,"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.5,"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,"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":7.5,"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,"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":8.5,"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,"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,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Jamiemcilroy94","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51105,"title":"Michael-Kyle Pepper","short_name":"MKS Pepper","first_name":"Michael-Kyle Pepper","last_name":"","middle_name":"","birthdate":"1998-06-25","birthplace":"Harlow, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/michael_pep\/","debut_data":"","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.5,"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":9,"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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":51347,"title":"Aaron Beard","short_name":"AP Beard","first_name":"Aaron Beard","last_name":"","middle_name":"","birthdate":"1997-10-15","birthplace":"Chelmsford, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Fast 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":61358,"title":"Shane Snater","short_name":"S Snater","first_name":"Shane Snater","last_name":"","middle_name":"","birthdate":"1996-03-24","birthplace":"Harare, Zimbabwe","country":"nl","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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":93372,"title":"Daniel Sams","short_name":"DR Sams","first_name":"Daniel Sams","last_name":"","middle_name":"","birthdate":"1992-10-27","birthplace":" Milperra, 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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/dansams\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":94961,"title":"Jordan Cox","short_name":"J Cox","first_name":"Jordan Cox","last_name":"","middle_name":"","birthdate":"2000-10-21","birthplace":"Margate, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/jjordancox\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","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":"all","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":""},{"pid":95892,"title":"Ben Allison","short_name":"B Allison","first_name":"Ben Allison","last_name":"","middle_name":"","birthdate":"1999-12-18","birthplace":"Colchester, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":8.5,"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":6.5,"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":6.5,"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":7.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,"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":8,"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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":141341,"title":"Simon Fernandes","short_name":"Simon Fernandes","first_name":"Simon Fernandes","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":8,"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":"062f05e43e21ae962fcf35a3e31c72e2","modified":"2025-07-31 23:06:23","datetime":"2025-07-31 23:06:23","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":86862,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Glamorgan won by 40 runs","day_remaining_over":"","team_batting":"Essex","team_bowling":"Glamorgan","live_inning_number":2,"live_score":{"runs":180,"overs":19.5,"wickets":10,"target":221,"runrate":9.08,"required_runrate":246},"commentary":1,"wagon":2,"batsmen":[{"name":"Luc Benkenstein","batsman_id":108420,"runs":62,"balls_faced":32,"fours":6,"sixes":4,"strike_rate":"193.75"},{"name":"Mohammad Amir","batsman_id":1758,"runs":0,"balls_faced":0,"fours":0,"sixes":0,"strike_rate":"0.00"}],"bowlers":[{"name":"Andy Gorvin","bowler_id":50477,"overs":2.5,"runs_conceded":38,"wickets":1,"maidens":0,"econ":"13.41"},{"name":"Daniel Douthwaite","bowler_id":51314,"overs":3,"runs_conceded":25,"wickets":1,"maidens":0,"econ":"8.33"}],"commentaries":[{"event_id":"12130118","event":"ball","batsman_id":"108420","bowler_id":"127528","over":"15","ball":"4","score":4,"commentary":"Benjamin Kellaway to Luc Benkenstein, Four,","noball_dismissal":false,"text":"","timestamp":1749758959,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12130120","event":"ball","batsman_id":"108420","bowler_id":"127528","over":"15","ball":"5","score":4,"commentary":"Benjamin Kellaway to Luc Benkenstein, Four,","noball_dismissal":false,"text":"","timestamp":1749758975,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12130123","event":"ball","batsman_id":"108420","bowler_id":"127528","over":"15","ball":"6","score":1,"commentary":"Benjamin Kellaway to Luc Benkenstein, 1 run,","noball_dismissal":false,"text":"","timestamp":1749759002,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":16,"runs":16,"score":"145\/7","bats":[{"runs":39,"balls_faced":19,"fours":3,"sixes":3,"batsman_id":108420},{"runs":0,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":61358}],"bowls":[{"runs_conceded":29,"maidens":0,"wickets":2,"bowler_id":127528,"overs":3},{"runs_conceded":23,"maidens":0,"wickets":1,"bowler_id":95765,"overs":3}],"commentary":"End of over 16 (16 runs), Essex 145\/7"},{"event_id":"12130143","event":"ball","batsman_id":"108420","bowler_id":"95765","over":"16","ball":"1","score":1,"commentary":"Ned Leonard to Luc Benkenstein, 1 run,","noball_dismissal":false,"text":"","timestamp":1749759197,"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":"12130144","event":"ball","batsman_id":"61358","bowler_id":"95765","over":"16","ball":"2","score":"1lb","commentary":"Ned Leonard to Shane Snater, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1749759200,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"1","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12130145","event":"ball","batsman_id":"108420","bowler_id":"95765","over":"16","ball":"3","score":1,"commentary":"Ned Leonard to Luc Benkenstein, 1 run,","noball_dismissal":false,"text":"","timestamp":1749759239,"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":"12130146","event":"ball","batsman_id":"61358","bowler_id":"95765","over":"16","ball":"4","score":4,"commentary":"Ned Leonard to Shane Snater, Four,","noball_dismissal":false,"text":"","timestamp":1749759241,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12130147","event":"ball","batsman_id":"61358","bowler_id":"95765","over":"16","ball":"5","score":1,"commentary":"Ned Leonard to Shane Snater, 1 run,","noball_dismissal":false,"text":"","timestamp":1749759249,"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":"12130148","event":"ball","batsman_id":"108420","bowler_id":"95765","over":"16","ball":"6","score":4,"commentary":"Ned Leonard to Luc Benkenstein, Four,","noball_dismissal":false,"text":"","timestamp":1749759251,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event":"overend","over":17,"runs":12,"score":"157\/7","bats":[{"runs":45,"balls_faced":22,"fours":4,"sixes":3,"batsman_id":108420},{"runs":5,"balls_faced":4,"fours":1,"sixes":0,"batsman_id":61358}],"bowls":[{"runs_conceded":34,"maidens":0,"wickets":1,"bowler_id":95765,"overs":4},{"runs_conceded":29,"maidens":0,"wickets":2,"bowler_id":127528,"overs":3}],"commentary":"End of over 17 (12 runs), Essex 157\/7"},{"event_id":"12130156","event":"ball","batsman_id":"61358","bowler_id":"1051","over":"17","ball":"1","score":1,"commentary":"Mason Crane to Shane Snater, 1 run,","noball_dismissal":false,"text":"","timestamp":1749759329,"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":"12130157","event":"ball","batsman_id":"108420","bowler_id":"1051","over":"17","ball":"2","score":1,"commentary":"Mason Crane to Luc Benkenstein, 1 run,","noball_dismissal":false,"text":"","timestamp":1749759332,"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":"12130158","event":"wicket","batsman_id":"61358","bowler_id":"1051","over":"17","ball":"3","score":"w","commentary":"Mason Crane to Shane Snater, no run, c B Kellaway b MS Crane,","noball_dismissal":false,"text":"","timestamp":1749759409,"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":"61358","how_out":"c B Kellaway b MS Crane","batsman_runs":"6","batsman_balls":"6"},{"event_id":"12130168","event":"ball","batsman_id":"68691","bowler_id":"1051","over":"17","ball":"4","score":0,"commentary":"Mason Crane to Samuel Cook, no run,","noball_dismissal":false,"text":"","timestamp":1749759429,"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":"12130173","event":"ball","batsman_id":"68691","bowler_id":"1051","over":"17","ball":"5","score":1,"commentary":"Mason Crane to Samuel Cook, 1 run,","noball_dismissal":false,"text":"","timestamp":1749759470,"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":"12130174","event":"ball","batsman_id":"108420","bowler_id":"1051","over":"17","ball":"6","score":6,"commentary":"Mason Crane to Luc Benkenstein, Six,","noball_dismissal":false,"text":"","timestamp":1749759473,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event":"overend","over":18,"runs":9,"score":"166\/8","bats":[{"runs":52,"balls_faced":24,"fours":4,"sixes":4,"batsman_id":108420},{"runs":1,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":68691}],"bowls":[{"runs_conceded":24,"maidens":0,"wickets":3,"bowler_id":1051,"overs":4},{"runs_conceded":34,"maidens":0,"wickets":1,"bowler_id":95765,"overs":4}],"commentary":"End of over 18 (9 runs), Essex 166\/8"},{"event_id":"12130190","event":"ball","batsman_id":"68691","bowler_id":"51314","over":"18","ball":"1","score":1,"commentary":"Daniel Douthwaite to Samuel Cook, 1 run,","noball_dismissal":false,"text":"","timestamp":1749759615,"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":"12130192","event":"ball","batsman_id":"108420","bowler_id":"51314","over":"18","ball":"2","score":0,"commentary":"Daniel Douthwaite to Luc Benkenstein, no run,","noball_dismissal":false,"text":"","timestamp":1749759618,"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":"12130193","event":"ball","batsman_id":"108420","bowler_id":"51314","over":"18","ball":"3","score":4,"commentary":"Daniel Douthwaite to Luc Benkenstein, Four,","noball_dismissal":false,"text":"","timestamp":1749759624,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12130194","event":"ball","batsman_id":"108420","bowler_id":"51314","over":"18","ball":"4","score":1,"commentary":"Daniel Douthwaite to Luc Benkenstein, 1 run,","noball_dismissal":false,"text":"","timestamp":1749759633,"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":"12130196","event":"ball","batsman_id":"68691","bowler_id":"51314","over":"18","ball":"5","score":1,"commentary":"Daniel Douthwaite to Samuel Cook, 1 run,","noball_dismissal":false,"text":"","timestamp":1749759676,"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":"12130198","event":"ball","batsman_id":"108420","bowler_id":"51314","over":"18","ball":"6","score":0,"commentary":"Daniel Douthwaite to Luc Benkenstein, no run,","noball_dismissal":false,"text":"","timestamp":1749759697,"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":19,"runs":7,"score":"173\/8","bats":[{"runs":57,"balls_faced":28,"fours":5,"sixes":4,"batsman_id":108420},{"runs":3,"balls_faced":4,"fours":0,"sixes":0,"batsman_id":68691}],"bowls":[{"runs_conceded":25,"maidens":0,"wickets":1,"bowler_id":51314,"overs":3},{"runs_conceded":24,"maidens":0,"wickets":3,"bowler_id":1051,"overs":4}],"commentary":"End of over 19 (7 runs), Essex 173\/8"},{"event_id":"12130215","event":"ball","batsman_id":"68691","bowler_id":"50477","over":"19","ball":"1","score":1,"commentary":"Andy Gorvin to Samuel Cook, 1 run,","noball_dismissal":false,"text":"","timestamp":1749759874,"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":"12130216","event":"ball","batsman_id":"108420","bowler_id":"50477","over":"19","ball":"2","score":"1wd","commentary":"Andy Gorvin to Luc Benkenstein, 1 wide,","noball_dismissal":false,"text":"","timestamp":1749759877,"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":"12130217","event":"ball","batsman_id":"108420","bowler_id":"50477","over":"19","ball":"2","score":4,"commentary":"Andy Gorvin to Luc Benkenstein, Four,","noball_dismissal":false,"text":"","timestamp":1749759880,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12130218","event":"wicket","batsman_id":"108420","bowler_id":"50477","over":"19","ball":"3","score":"w","commentary":"Andy Gorvin to Luc Benkenstein, 1 run, runout (AW Gorvin \/ A Tribe),","noball_dismissal":false,"text":"","timestamp":1749760056,"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,"wicket_batsman_id":"68691","how_out":"runout (AW Gorvin \/ A Tribe)","batsman_runs":"4","batsman_balls":"5"},{"event_id":"12130225","event":"ball","batsman_id":"108420","bowler_id":"50477","over":"19","ball":"4","score":0,"commentary":"Andy Gorvin to Luc Benkenstein, no run,","noball_dismissal":false,"text":"","timestamp":1749759948,"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":"12130226","event":"wicket","batsman_id":"108420","bowler_id":"50477","over":"19","ball":"5","score":"w","commentary":"Andy Gorvin to Luc Benkenstein, no run, c CA Ingram b AW Gorvin,","noball_dismissal":false,"text":"","timestamp":1749760063,"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":"108420","how_out":"c CA Ingram b AW Gorvin","batsman_runs":"62","batsman_balls":"32"}],"day":"0","session":"0","live_inning":{"iid":197937,"number":2,"name":"Essex Inning","short_name":"ESS Inning","status":2,"issuperover":"false","result":1,"batting_team_id":104950,"fielding_team_id":7020,"scores":"180\/10","scores_full":"180\/10 (19.5 ov)","fielder":[{"fielder_id":"49739","fielder_name":"Colin Ingram","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"51314","fielder_name":"Daniel Douthwaite","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"49444","fielder_name":"Chris Cooke","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"141478","fielder_name":"Asa Tribe","catches":1,"runout_thrower":1,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"50477","fielder_name":"Andy Gorvin","catches":1,"runout_thrower":0,"runout_catcher":1,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"127528","fielder_name":"Benjamin Kellaway","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":"Luc Benkenstein","batsman_id":"108420","runs":"62","balls":"32","how_out":"c CA Ingram b AW Gorvin","score_at_dismissal":180,"overs_at_dismissal":"19.5","bowler_id":"50477","dismissal":"caught","number":10},"extra_runs":{"byes":4,"legbyes":2,"wides":2,"noballs":0,"penalty":"0","total":8},"equations":{"runs":180,"wickets":10,"overs":"19.5","bowlers_used":6,"runrate":"9.08"},"current_partnership":{"runs":0,"balls":2,"overs":0.2,"batsmen":[{"name":"Luc Benkenstein","batsman_id":108420,"runs":0,"balls":2},{"name":"Mohammad Amir","batsman_id":1758,"runs":0,"balls":0}]},"did_not_bat":[],"max_over":"20","target":"221","recent_scores":"w,0,w,4,1,1,0,1,1,4,0,1,6,1,0,w,1,1","last_five_overs":"52\/4 10.06","last_ten_overs":"89\/6 8.75"},"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":"220\/6 (20 ov)","scores":"220\/6","overs":"20"},{"tid":104950,"title":"Essex","abbr":"ESS","alt_name":"ESS","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"180\/10 (19.5 ov)","scores":"180\/10","overs":"19.5"}],"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.5,"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,"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":8.5,"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":7.5,"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,"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,"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":6.5,"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":46837,"title":"Eathan Bosch","short_name":"E Bosch","first_name":"Eathan Bosch","last_name":"","middle_name":"","birthdate":"1998-04-27","birthplace":"Westville","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"https:\/\/www.facebook.com\/eathan.bosch.14\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/eathanbosch\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":48647,"title":"Matt Critchley","short_name":"MJJ Critchley","first_name":"Matt Critchley","last_name":"","middle_name":"","birthdate":"1996-08-13","birthplace":"Preston, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/mattcritchley96","instagram_profile":"https:\/\/www.instagram.com\/critch130896\/","debut_data":"","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":9,"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.5,"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,"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":7.5,"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,"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":8.5,"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,"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,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Jamiemcilroy94","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51105,"title":"Michael-Kyle Pepper","short_name":"MKS Pepper","first_name":"Michael-Kyle Pepper","last_name":"","middle_name":"","birthdate":"1998-06-25","birthplace":"Harlow, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/michael_pep\/","debut_data":"","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.5,"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":9,"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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":51347,"title":"Aaron Beard","short_name":"AP Beard","first_name":"Aaron Beard","last_name":"","middle_name":"","birthdate":"1997-10-15","birthplace":"Chelmsford, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Fast 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":61358,"title":"Shane Snater","short_name":"S Snater","first_name":"Shane Snater","last_name":"","middle_name":"","birthdate":"1996-03-24","birthplace":"Harare, Zimbabwe","country":"nl","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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":93372,"title":"Daniel Sams","short_name":"DR Sams","first_name":"Daniel Sams","last_name":"","middle_name":"","birthdate":"1992-10-27","birthplace":" Milperra, 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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/dansams\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":94961,"title":"Jordan Cox","short_name":"J Cox","first_name":"Jordan Cox","last_name":"","middle_name":"","birthdate":"2000-10-21","birthplace":"Margate, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/jjordancox\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","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":"all","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":""},{"pid":95892,"title":"Ben Allison","short_name":"B Allison","first_name":"Ben Allison","last_name":"","middle_name":"","birthdate":"1999-12-18","birthplace":"Colchester, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":8.5,"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":6.5,"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":6.5,"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":7.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,"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":8,"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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":141341,"title":"Simon Fernandes","short_name":"Simon Fernandes","first_name":"Simon Fernandes","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":8,"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":"062f05e43e21ae962fcf35a3e31c72e2","modified":"2025-07-31 23:06:23","datetime":"2025-07-31 23:06:23","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86862 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:1db46ddb-cd69-4c9f-9e8a-33580b1aa8f4 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86862 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86862,3,'{"status":"ok","response":{"match_id":86862,"title":"Essex vs Glamorgan","short_title":"ESS vs GLA","subtitle":"Match 42","match_number":"42","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Glamorgan won by 40 runs","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129425,"title":"Vitality Blast","abbr":"Vitality Blast","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-09-13","country":"en","total_matches":"133","total_rounds":"2","total_teams":"18"},"teama":{"team_id":104950,"name":"Essex","short_name":"ESS","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","scores_full":"180\/10 (19.5 ov)","scores":"180\/10","overs":"19.5"},"teamb":{"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":"220\/6 (20 ov)","scores":"220\/6","overs":"20"},"date_start":"2025-06-12 17:30:00","date_end":"2025-06-13 03:30:00","timestamp_start":1749749400,"timestamp_end":1749785400,"date_start_ist":"2025-06-12 23:00:00","date_end_ist":"2025-06-13 09:00:00","venue":{"venue_id":"45","name":"County Ground, Chelmsford","location":"","country":"England","timezone":""},"umpires":" David Millns (England), Rob White (England), Neil Bainton (England, TV)","referee":"Steve Davis (Australia)","equation":"","live":"","result":"GLA won by 40 runs","result_type":2,"win_margin":"40 runs","winning_team_id":7020,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-11 23:35:03","verify_time":"2025-06-13 02:22:42","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clear","weather_desc":"clear sky","temp":19.44,"humidity":81,"visibility":10000,"wind_speed":"6.71","clouds":5},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Essex elected to bowl","winner":104950,"decision":2}},"etag":"f314859881f082a8ca28b3a41d9215db","modified":"2025-07-31 23:06:25","datetime":"2025-07-31 23:06:25","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":86862,"title":"Essex vs Glamorgan","short_title":"ESS vs GLA","subtitle":"Match 42","match_number":"42","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Glamorgan won by 40 runs","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129425,"title":"Vitality Blast","abbr":"Vitality Blast","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-09-13","country":"en","total_matches":"133","total_rounds":"2","total_teams":"18"},"teama":{"team_id":104950,"name":"Essex","short_name":"ESS","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","scores_full":"180\/10 (19.5 ov)","scores":"180\/10","overs":"19.5"},"teamb":{"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":"220\/6 (20 ov)","scores":"220\/6","overs":"20"},"date_start":"2025-06-12 17:30:00","date_end":"2025-06-13 03:30:00","timestamp_start":1749749400,"timestamp_end":1749785400,"date_start_ist":"2025-06-12 23:00:00","date_end_ist":"2025-06-13 09:00:00","venue":{"venue_id":"45","name":"County Ground, Chelmsford","location":"","country":"England","timezone":""},"umpires":" David Millns (England), Rob White (England), Neil Bainton (England, TV)","referee":"Steve Davis (Australia)","equation":"","live":"","result":"GLA won by 40 runs","result_type":2,"win_margin":"40 runs","winning_team_id":7020,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-11 23:35:03","verify_time":"2025-06-13 02:22:42","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clear","weather_desc":"clear sky","temp":19.44,"humidity":81,"visibility":10000,"wind_speed":"6.71","clouds":5},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Essex elected to bowl","winner":104950,"decision":2}},"etag":"f314859881f082a8ca28b3a41d9215db","modified":"2025-07-31 23:06:25","datetime":"2025-07-31 23:06:25","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86862 AND DataTypeId = 3 END
Live Report & Scorecard of Essex vs Glamorgan Match 42
<>
CricDirect Cricket News, Results and Stats
 

Essex vs Glamorgan, Match 42, Vitality Blast

Completed
Vitality Blast, Completed
Essex
ESS
180/10 (19.5)
Glamorgan
GLA
220/6 (20)
Glamorgan won by 40 runs
Match Details
Date
2025-06-12 17:30:00
Venue
County Ground, Chelmsford,
Toss
Essex elected to bowl
Umpires
    Tv Umpires
      Match Referee
        × Close