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:cc08615a-0027-44fa-9ce5-e55f9a5c490d
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86901 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86901,1,'{"status":"ok","response":{"mid":86901,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Essex won by 4 wickets","day_remaining_over":"","team_batting":"Essex","team_bowling":"Surrey","live_inning_number":2,"live_score":{"runs":145,"overs":12,"wickets":6,"target":142,"runrate":12.08,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Robin Das","batsman_id":103358,"runs":1,"balls_faced":1,"fours":0,"sixes":0,"strike_rate":"100.00"},{"name":"Matt Critchley","batsman_id":48647,"runs":14,"balls_faced":6,"fours":2,"sixes":0,"strike_rate":"233.33"}],"bowlers":[{"name":"Sam Curran","bowler_id":1047,"overs":3,"runs_conceded":35,"wickets":2,"maidens":0,"econ":"11.67"},{"name":"Mitchell Santner","bowler_id":1923,"overs":2,"runs_conceded":26,"wickets":1,"maidens":0,"econ":"13.00"}],"commentaries":[{"event_id":"12297801","event":"ball","batsman_id":"134958","bowler_id":"51319","over":"7","ball":"6","score":2,"commentary":"Will Jacks to Charles Allison, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751829298,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":8,"runs":21,"score":"109\/3","bats":[{"runs":4,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":134958},{"runs":52,"balls_faced":21,"fours":5,"sixes":4,"batsman_id":51346}],"bowls":[{"runs_conceded":21,"maidens":0,"wickets":0,"bowler_id":51319,"overs":1},{"runs_conceded":12,"maidens":0,"wickets":3,"bowler_id":1965,"overs":2}],"commentary":"End of over 8 (21 runs), Essex 109\/3"},{"event_id":"12297806","event":"ball","batsman_id":"51346","bowler_id":"1965","over":"8","ball":"1","score":0,"commentary":"Adam Zampa to Paul Walter, no run,","noball_dismissal":false,"text":"","timestamp":1751829445,"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":"12297807","event":"ball","batsman_id":"51346","bowler_id":"1965","over":"8","ball":"2","score":1,"commentary":"Adam Zampa to Paul Walter, 1 run,","noball_dismissal":false,"text":"","timestamp":1751829448,"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":"12297811","event":"ball","batsman_id":"134958","bowler_id":"1965","over":"8","ball":"3","score":"1lb","commentary":"Adam Zampa to Charles Allison, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1751829451,"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":"12297813","event":"ball","batsman_id":"51346","bowler_id":"1965","over":"8","ball":"4","score":1,"commentary":"Adam Zampa to Paul Walter, 1 run,","noball_dismissal":false,"text":"","timestamp":1751829455,"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":"12297815","event":"ball","batsman_id":"134958","bowler_id":"1965","over":"8","ball":"5","score":0,"commentary":"Adam Zampa to Charles Allison, no run,","noball_dismissal":false,"text":"","timestamp":1751829458,"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":"12297816","event":"ball","batsman_id":"134958","bowler_id":"1965","over":"8","ball":"6","score":0,"commentary":"Adam Zampa to Charles Allison, no run,","noball_dismissal":false,"text":"","timestamp":1751829462,"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":9,"runs":3,"score":"112\/3","bats":[{"runs":4,"balls_faced":6,"fours":0,"sixes":0,"batsman_id":134958},{"runs":54,"balls_faced":24,"fours":5,"sixes":4,"batsman_id":51346}],"bowls":[{"runs_conceded":14,"maidens":0,"wickets":3,"bowler_id":1965,"overs":3},{"runs_conceded":21,"maidens":0,"wickets":0,"bowler_id":51319,"overs":1}],"commentary":"End of over 9 (3 runs), Essex 112\/3"},{"event_id":"12297821","event":"ball","batsman_id":"51346","bowler_id":"1047","over":"9","ball":"1","score":1,"commentary":"Sam Curran to Paul Walter, 1 run,","noball_dismissal":false,"text":"","timestamp":1751829577,"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":"12297823","event":"ball","batsman_id":"134958","bowler_id":"1047","over":"9","ball":"2","score":6,"commentary":"Sam Curran to Charles Allison, Six,","noball_dismissal":false,"text":"","timestamp":1751829734,"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_id":"12297827","event":"ball","batsman_id":"134958","bowler_id":"1047","over":"9","ball":"3","score":4,"commentary":"Sam Curran to Charles Allison, Four,","noball_dismissal":false,"text":"","timestamp":1751829738,"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":"12297828","event":"ball","batsman_id":"134958","bowler_id":"1047","over":"9","ball":"4","score":0,"commentary":"Sam Curran to Charles Allison, no run,","noball_dismissal":false,"text":"","timestamp":1751829742,"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":"12297829","event":"ball","batsman_id":"134958","bowler_id":"1047","over":"9","ball":"5","score":1,"commentary":"Sam Curran to Charles Allison, 1 run,","noball_dismissal":false,"text":"","timestamp":1751829745,"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":"12297832","event":"wicket","batsman_id":"51346","bowler_id":"1047","over":"9","ball":"6","score":"w","commentary":"Sam Curran to Paul Walter, no run, c LJ Evans b S Curran,","noball_dismissal":false,"text":"","timestamp":1751829806,"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":"51346","how_out":"c LJ Evans b S Curran","batsman_runs":"55","batsman_balls":"26"},{"event":"overend","over":10,"runs":12,"score":"124\/4","bats":[{"runs":55,"balls_faced":26,"fours":5,"sixes":4,"batsman_id":51346},{"runs":15,"balls_faced":10,"fours":1,"sixes":1,"batsman_id":134958}],"bowls":[{"runs_conceded":25,"maidens":0,"wickets":1,"bowler_id":1047,"overs":2},{"runs_conceded":14,"maidens":0,"wickets":3,"bowler_id":1965,"overs":3}],"commentary":"End of over 10 (12 runs), Essex 124\/4"},{"event_id":"12297840","event":"ball","batsman_id":"134958","bowler_id":"1923","over":"10","ball":"1","score":0,"commentary":"Mitchell Santner to Charles Allison, no run,","noball_dismissal":false,"text":"","timestamp":1751829866,"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":"12297842","event":"wicket","batsman_id":"134958","bowler_id":"1923","over":"10","ball":"2","score":"w","commentary":"Mitchell Santner to Charles Allison, no run, st LJ Evans b M Santner,","noball_dismissal":false,"text":"","timestamp":1751829947,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"134958","how_out":"st LJ Evans b M Santner","batsman_runs":"15","batsman_balls":"12"},{"event_id":"12297846","event":"ball","batsman_id":"49087","bowler_id":"1923","over":"10","ball":"3","score":1,"commentary":"Mitchell Santner to Simon Harmer, 1 run,","noball_dismissal":false,"text":"","timestamp":1751829950,"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":"12297847","event":"ball","batsman_id":"48647","bowler_id":"1923","over":"10","ball":"4","score":4,"commentary":"Mitchell Santner to Matt Critchley, Four,","noball_dismissal":false,"text":"","timestamp":1751830040,"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":"12297849","event":"ball","batsman_id":"48647","bowler_id":"1923","over":"10","ball":"5","score":"1wd","commentary":"Mitchell Santner to Matt Critchley, 1 wide,","noball_dismissal":false,"text":"","timestamp":1751830044,"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":"12297851","event":"ball","batsman_id":"48647","bowler_id":"1923","over":"10","ball":"5","score":1,"commentary":"Mitchell Santner to Matt Critchley, 1 run,","noball_dismissal":false,"text":"","timestamp":1751830068,"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":"12297853","event":"ball","batsman_id":"49087","bowler_id":"1923","over":"10","ball":"6","score":4,"commentary":"Mitchell Santner to Simon Harmer, Four,","noball_dismissal":false,"text":"","timestamp":1751830071,"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":11,"runs":11,"score":"135\/5","bats":[{"runs":5,"balls_faced":2,"fours":1,"sixes":0,"batsman_id":49087},{"runs":5,"balls_faced":2,"fours":1,"sixes":0,"batsman_id":48647}],"bowls":[{"runs_conceded":26,"maidens":0,"wickets":1,"bowler_id":1923,"overs":2},{"runs_conceded":25,"maidens":0,"wickets":1,"bowler_id":1047,"overs":2}],"commentary":"End of over 11 (11 runs), Essex 135\/5"},{"event_id":"12297861","event":"ball","batsman_id":"48647","bowler_id":"1047","over":"11","ball":"1","score":1,"commentary":"Sam Curran to Matt Critchley, 1 run,","noball_dismissal":false,"text":"","timestamp":1751830185,"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":"12297862","event":"wicket","batsman_id":"49087","bowler_id":"1047","over":"11","ball":"2","score":"w","commentary":"Sam Curran to Simon Harmer, no run, c J Roy b S Curran,","noball_dismissal":false,"text":"","timestamp":1751830254,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"49087","how_out":"c J Roy b S Curran","batsman_runs":"5","batsman_balls":"3"},{"event_id":"12297865","event":"ball","batsman_id":"103358","bowler_id":"1047","over":"11","ball":"3","score":1,"commentary":"Sam Curran to Robin Das, 1 run,","noball_dismissal":false,"text":"","timestamp":1751830337,"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":"12297869","event":"ball","batsman_id":"48647","bowler_id":"1047","over":"11","ball":"4","score":2,"commentary":"Sam Curran to Matt Critchley, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751830428,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12297872","event":"ball","batsman_id":"48647","bowler_id":"1047","over":"11","ball":"5","score":2,"commentary":"Sam Curran to Matt Critchley, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751830524,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12297875","event":"ball","batsman_id":"48647","bowler_id":"1047","over":"11","ball":"6","score":4,"commentary":"Sam Curran to Matt Critchley, Four,","noball_dismissal":false,"text":"","timestamp":1751830527,"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":12,"runs":10,"score":"145\/6","bats":[{"runs":14,"balls_faced":6,"fours":2,"sixes":0,"batsman_id":48647},{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":103358}],"bowls":[{"runs_conceded":35,"maidens":0,"wickets":2,"bowler_id":1047,"overs":3},{"runs_conceded":26,"maidens":0,"wickets":1,"bowler_id":1923,"overs":2}],"commentary":"End of over 12 (10 runs), Essex 145\/6"}],"day":"0","session":"0","live_inning":{"iid":199230,"number":2,"name":"Essex Inning","short_name":"ESS Inning","status":2,"issuperover":"false","result":3,"batting_team_id":104950,"fielding_team_id":6995,"scores":"145\/6","scores_full":"145\/6 (12 ov)","fielder":[{"fielder_id":"49029","fielder_name":"Laurie Evans","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":1,"is_substitute":"false"},{"fielder_id":"1929","fielder_name":"Jason Roy","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"454","fielder_name":"Chris Jordan","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":[],"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Simon Harmer","batsman_id":"49087","runs":"5","balls":"3","how_out":"c J Roy b S Curran","score_at_dismissal":136,"overs_at_dismissal":"11.2","bowler_id":"1047","dismissal":"caught","number":6},"extra_runs":{"byes":0,"legbyes":2,"wides":7,"noballs":0,"penalty":"0","total":9},"equations":{"runs":145,"wickets":6,"overs":"12","bowlers_used":7,"runrate":"12.08"},"current_partnership":{"runs":9,"balls":4,"overs":0.4,"batsmen":[{"name":"Robin Das","batsman_id":103358,"runs":1,"balls":1},{"name":"Matt Critchley","batsman_id":48647,"runs":8,"balls":3}]},"did_not_bat":[{"player_id":"127517","name":"Noah Thain"},{"player_id":"1758","name":"Mohammad Amir"},{"player_id":"68691","name":"Samuel Cook"}],"max_over":"12","target":"142","recent_scores":"4,2,2,1,w,1,4,1,1,4,1,w,0,w,1,0,4,6","last_five_overs":"57\/3 10.69","last_ten_overs":"110\/6 10.31"},"teams":[{"tid":6995,"title":"Surrey","abbr":"SUR","alt_name":"Surrey","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/surrey-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/surrey-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"141\/6 (12 ov)","scores":"141\/6","overs":"12"},{"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":"145\/6 (12 ov)","scores":"145\/6","overs":"12"}],"players":[{"pid":454,"title":"Chris Jordan","short_name":"C Jordan","first_name":"Chris Jordan","last_name":"","middle_name":"","birthdate":"1988-10-04","birthplace":"Barbados","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":8.5,"facebook_profile":"https:\/\/www.facebook.com\/ChrisJordanOfficial\/","twitter_profile":"https:\/\/twitter.com\/CJordan","instagram_profile":"https:\/\/www.instagram.com\/cjrjordan\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":1042,"title":"Dan Lawrence","short_name":"DW Lawrence","first_name":"Dan Lawrence","last_name":"","middle_name":"","birthdate":"1997-07-12","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":"https:\/\/www.facebook.com\/danlawrence25\/","twitter_profile":"https:\/\/twitter.com\/_DanLawrence","instagram_profile":"https:\/\/www.instagram.com\/daniellawrence28\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":1047,"title":"Sam Curran","short_name":"S Curran","first_name":"Sam Curran","last_name":"","middle_name":"","birthdate":"1998-06-03","birthplace":"Northampton","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/CurranSM\/","twitter_profile":"https:\/\/twitter.com\/CurranSM","instagram_profile":"https:\/\/www.instagram.com\/samcurran58\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":"(C)"},{"pid":1089,"title":"Nathan Smith","short_name":"N Smith","first_name":"Nathan Smith","last_name":"","middle_name":"","birthdate":"1998-07-15","birthplace":"Dunedin, Otago","country":"nz","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bowl","role_str":""},{"pid":1923,"title":"Mitchell Santner","short_name":"M Santner","first_name":"Mitchell Santner","last_name":"","middle_name":"","birthdate":"1992-02-05","birthplace":" Hamilton","country":"nz","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/mitchellsantnernz\/","twitter_profile":"https:\/\/twitter.com\/MitchellSantner","instagram_profile":"https:\/\/www.instagram.com\/mitchsantner\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"all","role_str":""},{"pid":1929,"title":"Jason Roy","short_name":"J Roy","first_name":"Jason Roy","last_name":"","middle_name":"","birthdate":"1990-07-21","birthplace":"Durban, South Africa","country":"en","primary_team":{"tid":490,"name":"","short_name":""},"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/JasonRoy20\/","twitter_profile":"https:\/\/twitter.com\/JasonRoy20","instagram_profile":"https:\/\/www.instagram.com\/jasonroy20\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":1937,"title":"Reece Topley","short_name":"R Topley","first_name":"Reece Topley","last_name":"","middle_name":"","birthdate":"1994-02-21","birthplace":"Ipswich, Suffolk","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/ReeceJamesWilliamTopley\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/reecejwtopley\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":1965,"title":"Adam Zampa","short_name":"A Zampa","first_name":"Adam Zampa","last_name":"","middle_name":"","birthdate":"1992-03-31","birthplace":"Shellharbour, New South Wales","country":"au","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":18970,"recent_appearance":1515900000,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/zampsbook\/","twitter_profile":"https:\/\/twitter.com\/AdamZampaAUS","instagram_profile":"https:\/\/www.instagram.com\/zampstagram","debut_data":"","bowling_type":"Spin","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":10598,"title":"Ben Foakes","short_name":"BT Foakes","first_name":"Ben Foakes","last_name":"","middle_name":"","birthdate":"1993-02-15","birthplace":"Colchester, 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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":10600,"title":"Rory Burns","short_name":"RJ Burns","first_name":"Rory Burns","last_name":"","middle_name":"","birthdate":"1990-08-26","birthplace":"Epsom, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"Occasional Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":43383,"title":"Jamie Overton","short_name":"J Overton","first_name":"Jamie Overton","last_name":"","middle_name":"","birthdate":"1994-04-10","birthplace":"Barnstaple, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/JamieOverton","instagram_profile":"https:\/\/www.instagram.com\/jamie_overton8\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":43389,"title":"Tom Curran","short_name":"TK Curran","first_name":"Tom Curran","last_name":"","middle_name":"","birthdate":"1995-03-12","birthplace":"Cape Town, Cape Province","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/tc59","instagram_profile":"https:\/\/www.instagram.com\/tc59\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":43630,"title":"Daniel Worrall","short_name":"DJ Worrall","first_name":"Daniel Worrall","last_name":"","middle_name":"","birthdate":"1991-07-10","birthplace":"Melbourne, Victoria","country":"au","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":48440,"title":"Jordan Clark","short_name":"J Clark","first_name":"Jordan Clark","last_name":"","middle_name":"","birthdate":"1990-10-14","birthplace":"Whitehaven, Cumbria","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"Occasional Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":48647,"title":"Matt Critchley","short_name":"MJJ Critchley","first_name":"Matt Critchley","last_name":"","middle_name":"","birthdate":"1996-08-13","birthplace":"Preston, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/mattcritchley96","instagram_profile":"https:\/\/www.instagram.com\/critch130896\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":49029,"title":"Laurie Evans","short_name":"LJ Evans","first_name":"Laurie Evans","last_name":"","middle_name":"","birthdate":"1987-10-12","birthplace":"Lambeth, London","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/laurie.evans.39\/","twitter_profile":"https:\/\/twitter.com\/LaurieEvans32","instagram_profile":"https:\/\/www.instagram.com\/laurieevans32\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":49083,"title":"Dean Elgar","short_name":"D Elgar","first_name":"Dean Elgar","last_name":"","middle_name":"","birthdate":"1987-06-11","birthplace":"Welkom, Orange Free state","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":36249,"recent_appearance":1514287800,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BoringDeanElgar","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":49087,"title":"Simon Harmer","short_name":"SR Harmer","first_name":"Simon Harmer","last_name":"","middle_name":"","birthdate":"1989-02-10","birthplace":"Pretoria, Transvaal","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Simon_Harmer_","instagram_profile":"https:\/\/www.instagram.com\/simon_harmer\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bowl","role_str":"(C)"},{"pid":49324,"title":"Matt Dunn","short_name":"MP Dunn","first_name":"Matt Dunn","last_name":"","middle_name":"","birthdate":"1992-05-05","birthplace":"Egham, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49376,"title":"Adam Rossington","short_name":"AM Rossington","first_name":"Adam Rossington","last_name":"","middle_name":"","birthdate":"1993-05-05","birthplace":"Edgware, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper ","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Rossington17","instagram_profile":"https:\/\/www.instagram.com\/rossington17\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49428,"title":"Cameron Steel","short_name":"CT Steel","first_name":"Cameron Steel","last_name":"","middle_name":"","birthdate":"1995-09-13","birthplace":"Greenbrae, California, United States of America","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49593,"title":"Jamie Porter","short_name":"JA Porter","first_name":"Jamie Porter","last_name":"","middle_name":"","birthdate":"1993-05-25","birthplace":"Leytonstone, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49743,"title":"Matthew Fisher","short_name":"MD Fisher","first_name":"Matthew Fisher","last_name":"","middle_name":"","birthdate":"1997-11-09","birthplace":"York","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/9M_Fisher","instagram_profile":"https:\/\/www.instagram.com\/9M_Fisher\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50754,"title":"Dom Sibley","short_name":"DP Sibley","first_name":"Dom Sibley","last_name":"","middle_name":"","birthdate":"1995-09-05","birthplace":"Epsom, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/michael_pep\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":""},{"pid":51290,"title":"Ollie Pope","short_name":"O Pope","first_name":"Ollie Pope","last_name":"","middle_name":"","birthdate":"1998-01-02","birthplace":"Chelsea, 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":8,"facebook_profile":"https:\/\/www.facebook.com\/OliverJohndouglaspope.3\/","twitter_profile":"https:\/\/twitter.com\/OPope32","instagram_profile":"https:\/\/www.instagram.com\/opope32\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51319,"title":"Will Jacks","short_name":"WG Jacks","first_name":"Will Jacks","last_name":"","middle_name":"","birthdate":"1998-11-21","birthplace":"Chertsey, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Wjacks9","instagram_profile":"https:\/\/www.instagram.com\/willjacks9\/","debut_data":"","bowling_type":"Spin","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":61358,"title":"Shane Snater","short_name":"S Snater","first_name":"Shane Snater","last_name":"","middle_name":"","birthdate":"1996-03-24","birthplace":"Harare, Zimbabwe","country":"nl","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"squad","role_str":""},{"pid":68691,"title":"Samuel Cook","short_name":"S Cook","first_name":"Samuel Cook","last_name":"","middle_name":"","birthdate":"1997-08-04","birthplace":"Chelmsford, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/samcook09","instagram_profile":"https:\/\/www.instagram.com\/s_cook16\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":90946,"title":"Ryan Patel","short_name":"RS Patel","first_name":"Ryan Patel","last_name":"","middle_name":"","birthdate":"1997-10-26","birthplace":"Sutton, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":93749,"title":"Gus Atkinson","short_name":"G Atkinson","first_name":"Gus Atkinson","last_name":"","middle_name":"","birthdate":"1998-01-19","birthplace":"Chelsea, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/gus_atkinson1","instagram_profile":"https:\/\/www.instagram.com\/gusatkinson\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":93751,"title":"James Taylor","short_name":"JWA Taylor","first_name":"James Taylor","last_name":"","middle_name":"","birthdate":"2001-01-19","birthplace":"Nottingham","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":93836,"title":"Jamie Smith","short_name":"JL Smith","first_name":"Jamie Smith","last_name":"","middle_name":"","birthdate":"2000-07-12","birthplace":"Epsom, Surrey","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\/jamie_smith148\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":94961,"title":"Jordan Cox","short_name":"J Cox","first_name":"Jordan Cox","last_name":"","middle_name":"","birthdate":"2000-10-21","birthplace":"Margate, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/jjordancox\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":103358,"title":"Robin Das","short_name":"RJ Das","first_name":"Robin Das","last_name":"","middle_name":"","birthdate":"2002-02-27","birthplace":"Leytonstone","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"https:\/\/www.facebook.com\/robindascricketer","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/robinigblue\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":108386,"title":"Thomas Lawes","short_name":"T Lawes","first_name":"Thomas Lawes","last_name":"","middle_name":"","birthdate":"2002-12-25","birthplace":"Singapore","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/tom_lawes\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108393,"title":"Jamal Richards","short_name":"J Richards","first_name":"Jamal Richards","last_name":"","middle_name":"","birthdate":"2004-03-03","birthplace":"Edmonton, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108420,"title":"Luc Benkenstein","short_name":"L Benkenstein","first_name":"Luc Benkenstein","last_name":"","middle_name":"","birthdate":"2004-11-02","birthplace":"Durban","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":109924,"title":"Nathan Barnwell","short_name":"NA Barnwell","first_name":"Nathan Barnwell","last_name":"","middle_name":"","birthdate":"2003-02-03","birthplace":"Ashford, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":118551,"title":"Josh Blake","short_name":"J Blake","first_name":"Josh Blake","last_name":"","middle_name":"","birthdate":"1998-09-18","birthplace":"Carshalton, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":118552,"title":"Yousef Majid","short_name":"Y Majid","first_name":"Yousef Majid","last_name":"","middle_name":"","birthdate":"2003-09-08","birthplace":"Slough, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":127517,"title":"Noah Thain","short_name":"NRM Thain","first_name":"Noah Thain","last_name":"","middle_name":"","birthdate":"2005-01-13","birthplace":"Hitchinbrooke, Hertfordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":129447,"title":"Mackenzie Jones","short_name":"Mackenzie Jones","first_name":"Mackenzie Jones","last_name":"","middle_name":"","birthdate":"2005-03-06","birthplace":"","country":"sct","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Scotland","role":"squad","role_str":""},{"pid":130468,"title":"Tommy Ealham","short_name":"TM Ealham","first_name":"Tommy Ealham","last_name":"","middle_name":"","birthdate":"2004-03-26","birthplace":"Guildford, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":134958,"title":"Charles Allison","short_name":"CW Allison","first_name":"Charles Allison","last_name":"","middle_name":"","birthdate":"2005-03-02","birthplace":"Colchester, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":141008,"title":"Ollie Sykes","short_name":"O Sykes","first_name":"Ollie Sykes","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":141341,"title":"Simon Fernandes","short_name":"Simon Fernandes","first_name":"Simon Fernandes","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":141527,"title":"Seb Stuart Reckling","short_name":"SS Reckling","first_name":"Seb Stuart Reckling","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":150399,"title":"Charlie Edward Bennett","short_name":"CE Bennett","first_name":"Charlie Edward Bennett","last_name":"","middle_name":"","birthdate":"2006-05-01","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""}]},"etag":"d6e4c44b3c8ee16f767733177b7d454a","modified":"2025-07-16 04:10:24","datetime":"2025-07-16 04:10:24","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":86901,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Essex won by 4 wickets","day_remaining_over":"","team_batting":"Essex","team_bowling":"Surrey","live_inning_number":2,"live_score":{"runs":145,"overs":12,"wickets":6,"target":142,"runrate":12.08,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Robin Das","batsman_id":103358,"runs":1,"balls_faced":1,"fours":0,"sixes":0,"strike_rate":"100.00"},{"name":"Matt Critchley","batsman_id":48647,"runs":14,"balls_faced":6,"fours":2,"sixes":0,"strike_rate":"233.33"}],"bowlers":[{"name":"Sam Curran","bowler_id":1047,"overs":3,"runs_conceded":35,"wickets":2,"maidens":0,"econ":"11.67"},{"name":"Mitchell Santner","bowler_id":1923,"overs":2,"runs_conceded":26,"wickets":1,"maidens":0,"econ":"13.00"}],"commentaries":[{"event_id":"12297801","event":"ball","batsman_id":"134958","bowler_id":"51319","over":"7","ball":"6","score":2,"commentary":"Will Jacks to Charles Allison, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751829298,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":8,"runs":21,"score":"109\/3","bats":[{"runs":4,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":134958},{"runs":52,"balls_faced":21,"fours":5,"sixes":4,"batsman_id":51346}],"bowls":[{"runs_conceded":21,"maidens":0,"wickets":0,"bowler_id":51319,"overs":1},{"runs_conceded":12,"maidens":0,"wickets":3,"bowler_id":1965,"overs":2}],"commentary":"End of over 8 (21 runs), Essex 109\/3"},{"event_id":"12297806","event":"ball","batsman_id":"51346","bowler_id":"1965","over":"8","ball":"1","score":0,"commentary":"Adam Zampa to Paul Walter, no run,","noball_dismissal":false,"text":"","timestamp":1751829445,"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":"12297807","event":"ball","batsman_id":"51346","bowler_id":"1965","over":"8","ball":"2","score":1,"commentary":"Adam Zampa to Paul Walter, 1 run,","noball_dismissal":false,"text":"","timestamp":1751829448,"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":"12297811","event":"ball","batsman_id":"134958","bowler_id":"1965","over":"8","ball":"3","score":"1lb","commentary":"Adam Zampa to Charles Allison, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1751829451,"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":"12297813","event":"ball","batsman_id":"51346","bowler_id":"1965","over":"8","ball":"4","score":1,"commentary":"Adam Zampa to Paul Walter, 1 run,","noball_dismissal":false,"text":"","timestamp":1751829455,"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":"12297815","event":"ball","batsman_id":"134958","bowler_id":"1965","over":"8","ball":"5","score":0,"commentary":"Adam Zampa to Charles Allison, no run,","noball_dismissal":false,"text":"","timestamp":1751829458,"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":"12297816","event":"ball","batsman_id":"134958","bowler_id":"1965","over":"8","ball":"6","score":0,"commentary":"Adam Zampa to Charles Allison, no run,","noball_dismissal":false,"text":"","timestamp":1751829462,"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":9,"runs":3,"score":"112\/3","bats":[{"runs":4,"balls_faced":6,"fours":0,"sixes":0,"batsman_id":134958},{"runs":54,"balls_faced":24,"fours":5,"sixes":4,"batsman_id":51346}],"bowls":[{"runs_conceded":14,"maidens":0,"wickets":3,"bowler_id":1965,"overs":3},{"runs_conceded":21,"maidens":0,"wickets":0,"bowler_id":51319,"overs":1}],"commentary":"End of over 9 (3 runs), Essex 112\/3"},{"event_id":"12297821","event":"ball","batsman_id":"51346","bowler_id":"1047","over":"9","ball":"1","score":1,"commentary":"Sam Curran to Paul Walter, 1 run,","noball_dismissal":false,"text":"","timestamp":1751829577,"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":"12297823","event":"ball","batsman_id":"134958","bowler_id":"1047","over":"9","ball":"2","score":6,"commentary":"Sam Curran to Charles Allison, Six,","noball_dismissal":false,"text":"","timestamp":1751829734,"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_id":"12297827","event":"ball","batsman_id":"134958","bowler_id":"1047","over":"9","ball":"3","score":4,"commentary":"Sam Curran to Charles Allison, Four,","noball_dismissal":false,"text":"","timestamp":1751829738,"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":"12297828","event":"ball","batsman_id":"134958","bowler_id":"1047","over":"9","ball":"4","score":0,"commentary":"Sam Curran to Charles Allison, no run,","noball_dismissal":false,"text":"","timestamp":1751829742,"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":"12297829","event":"ball","batsman_id":"134958","bowler_id":"1047","over":"9","ball":"5","score":1,"commentary":"Sam Curran to Charles Allison, 1 run,","noball_dismissal":false,"text":"","timestamp":1751829745,"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":"12297832","event":"wicket","batsman_id":"51346","bowler_id":"1047","over":"9","ball":"6","score":"w","commentary":"Sam Curran to Paul Walter, no run, c LJ Evans b S Curran,","noball_dismissal":false,"text":"","timestamp":1751829806,"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":"51346","how_out":"c LJ Evans b S Curran","batsman_runs":"55","batsman_balls":"26"},{"event":"overend","over":10,"runs":12,"score":"124\/4","bats":[{"runs":55,"balls_faced":26,"fours":5,"sixes":4,"batsman_id":51346},{"runs":15,"balls_faced":10,"fours":1,"sixes":1,"batsman_id":134958}],"bowls":[{"runs_conceded":25,"maidens":0,"wickets":1,"bowler_id":1047,"overs":2},{"runs_conceded":14,"maidens":0,"wickets":3,"bowler_id":1965,"overs":3}],"commentary":"End of over 10 (12 runs), Essex 124\/4"},{"event_id":"12297840","event":"ball","batsman_id":"134958","bowler_id":"1923","over":"10","ball":"1","score":0,"commentary":"Mitchell Santner to Charles Allison, no run,","noball_dismissal":false,"text":"","timestamp":1751829866,"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":"12297842","event":"wicket","batsman_id":"134958","bowler_id":"1923","over":"10","ball":"2","score":"w","commentary":"Mitchell Santner to Charles Allison, no run, st LJ Evans b M Santner,","noball_dismissal":false,"text":"","timestamp":1751829947,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"134958","how_out":"st LJ Evans b M Santner","batsman_runs":"15","batsman_balls":"12"},{"event_id":"12297846","event":"ball","batsman_id":"49087","bowler_id":"1923","over":"10","ball":"3","score":1,"commentary":"Mitchell Santner to Simon Harmer, 1 run,","noball_dismissal":false,"text":"","timestamp":1751829950,"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":"12297847","event":"ball","batsman_id":"48647","bowler_id":"1923","over":"10","ball":"4","score":4,"commentary":"Mitchell Santner to Matt Critchley, Four,","noball_dismissal":false,"text":"","timestamp":1751830040,"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":"12297849","event":"ball","batsman_id":"48647","bowler_id":"1923","over":"10","ball":"5","score":"1wd","commentary":"Mitchell Santner to Matt Critchley, 1 wide,","noball_dismissal":false,"text":"","timestamp":1751830044,"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":"12297851","event":"ball","batsman_id":"48647","bowler_id":"1923","over":"10","ball":"5","score":1,"commentary":"Mitchell Santner to Matt Critchley, 1 run,","noball_dismissal":false,"text":"","timestamp":1751830068,"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":"12297853","event":"ball","batsman_id":"49087","bowler_id":"1923","over":"10","ball":"6","score":4,"commentary":"Mitchell Santner to Simon Harmer, Four,","noball_dismissal":false,"text":"","timestamp":1751830071,"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":11,"runs":11,"score":"135\/5","bats":[{"runs":5,"balls_faced":2,"fours":1,"sixes":0,"batsman_id":49087},{"runs":5,"balls_faced":2,"fours":1,"sixes":0,"batsman_id":48647}],"bowls":[{"runs_conceded":26,"maidens":0,"wickets":1,"bowler_id":1923,"overs":2},{"runs_conceded":25,"maidens":0,"wickets":1,"bowler_id":1047,"overs":2}],"commentary":"End of over 11 (11 runs), Essex 135\/5"},{"event_id":"12297861","event":"ball","batsman_id":"48647","bowler_id":"1047","over":"11","ball":"1","score":1,"commentary":"Sam Curran to Matt Critchley, 1 run,","noball_dismissal":false,"text":"","timestamp":1751830185,"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":"12297862","event":"wicket","batsman_id":"49087","bowler_id":"1047","over":"11","ball":"2","score":"w","commentary":"Sam Curran to Simon Harmer, no run, c J Roy b S Curran,","noball_dismissal":false,"text":"","timestamp":1751830254,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"49087","how_out":"c J Roy b S Curran","batsman_runs":"5","batsman_balls":"3"},{"event_id":"12297865","event":"ball","batsman_id":"103358","bowler_id":"1047","over":"11","ball":"3","score":1,"commentary":"Sam Curran to Robin Das, 1 run,","noball_dismissal":false,"text":"","timestamp":1751830337,"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":"12297869","event":"ball","batsman_id":"48647","bowler_id":"1047","over":"11","ball":"4","score":2,"commentary":"Sam Curran to Matt Critchley, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751830428,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12297872","event":"ball","batsman_id":"48647","bowler_id":"1047","over":"11","ball":"5","score":2,"commentary":"Sam Curran to Matt Critchley, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751830524,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12297875","event":"ball","batsman_id":"48647","bowler_id":"1047","over":"11","ball":"6","score":4,"commentary":"Sam Curran to Matt Critchley, Four,","noball_dismissal":false,"text":"","timestamp":1751830527,"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":12,"runs":10,"score":"145\/6","bats":[{"runs":14,"balls_faced":6,"fours":2,"sixes":0,"batsman_id":48647},{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":103358}],"bowls":[{"runs_conceded":35,"maidens":0,"wickets":2,"bowler_id":1047,"overs":3},{"runs_conceded":26,"maidens":0,"wickets":1,"bowler_id":1923,"overs":2}],"commentary":"End of over 12 (10 runs), Essex 145\/6"}],"day":"0","session":"0","live_inning":{"iid":199230,"number":2,"name":"Essex Inning","short_name":"ESS Inning","status":2,"issuperover":"false","result":3,"batting_team_id":104950,"fielding_team_id":6995,"scores":"145\/6","scores_full":"145\/6 (12 ov)","fielder":[{"fielder_id":"49029","fielder_name":"Laurie Evans","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":1,"is_substitute":"false"},{"fielder_id":"1929","fielder_name":"Jason Roy","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"454","fielder_name":"Chris Jordan","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":[],"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Simon Harmer","batsman_id":"49087","runs":"5","balls":"3","how_out":"c J Roy b S Curran","score_at_dismissal":136,"overs_at_dismissal":"11.2","bowler_id":"1047","dismissal":"caught","number":6},"extra_runs":{"byes":0,"legbyes":2,"wides":7,"noballs":0,"penalty":"0","total":9},"equations":{"runs":145,"wickets":6,"overs":"12","bowlers_used":7,"runrate":"12.08"},"current_partnership":{"runs":9,"balls":4,"overs":0.4,"batsmen":[{"name":"Robin Das","batsman_id":103358,"runs":1,"balls":1},{"name":"Matt Critchley","batsman_id":48647,"runs":8,"balls":3}]},"did_not_bat":[{"player_id":"127517","name":"Noah Thain"},{"player_id":"1758","name":"Mohammad Amir"},{"player_id":"68691","name":"Samuel Cook"}],"max_over":"12","target":"142","recent_scores":"4,2,2,1,w,1,4,1,1,4,1,w,0,w,1,0,4,6","last_five_overs":"57\/3 10.69","last_ten_overs":"110\/6 10.31"},"teams":[{"tid":6995,"title":"Surrey","abbr":"SUR","alt_name":"Surrey","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/surrey-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/surrey-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"141\/6 (12 ov)","scores":"141\/6","overs":"12"},{"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":"145\/6 (12 ov)","scores":"145\/6","overs":"12"}],"players":[{"pid":454,"title":"Chris Jordan","short_name":"C Jordan","first_name":"Chris Jordan","last_name":"","middle_name":"","birthdate":"1988-10-04","birthplace":"Barbados","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":8.5,"facebook_profile":"https:\/\/www.facebook.com\/ChrisJordanOfficial\/","twitter_profile":"https:\/\/twitter.com\/CJordan","instagram_profile":"https:\/\/www.instagram.com\/cjrjordan\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":1042,"title":"Dan Lawrence","short_name":"DW Lawrence","first_name":"Dan Lawrence","last_name":"","middle_name":"","birthdate":"1997-07-12","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":"https:\/\/www.facebook.com\/danlawrence25\/","twitter_profile":"https:\/\/twitter.com\/_DanLawrence","instagram_profile":"https:\/\/www.instagram.com\/daniellawrence28\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":1047,"title":"Sam Curran","short_name":"S Curran","first_name":"Sam Curran","last_name":"","middle_name":"","birthdate":"1998-06-03","birthplace":"Northampton","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/CurranSM\/","twitter_profile":"https:\/\/twitter.com\/CurranSM","instagram_profile":"https:\/\/www.instagram.com\/samcurran58\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":"(C)"},{"pid":1089,"title":"Nathan Smith","short_name":"N Smith","first_name":"Nathan Smith","last_name":"","middle_name":"","birthdate":"1998-07-15","birthplace":"Dunedin, Otago","country":"nz","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bowl","role_str":""},{"pid":1923,"title":"Mitchell Santner","short_name":"M Santner","first_name":"Mitchell Santner","last_name":"","middle_name":"","birthdate":"1992-02-05","birthplace":" Hamilton","country":"nz","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/mitchellsantnernz\/","twitter_profile":"https:\/\/twitter.com\/MitchellSantner","instagram_profile":"https:\/\/www.instagram.com\/mitchsantner\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"all","role_str":""},{"pid":1929,"title":"Jason Roy","short_name":"J Roy","first_name":"Jason Roy","last_name":"","middle_name":"","birthdate":"1990-07-21","birthplace":"Durban, South Africa","country":"en","primary_team":{"tid":490,"name":"","short_name":""},"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/JasonRoy20\/","twitter_profile":"https:\/\/twitter.com\/JasonRoy20","instagram_profile":"https:\/\/www.instagram.com\/jasonroy20\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":1937,"title":"Reece Topley","short_name":"R Topley","first_name":"Reece Topley","last_name":"","middle_name":"","birthdate":"1994-02-21","birthplace":"Ipswich, Suffolk","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/ReeceJamesWilliamTopley\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/reecejwtopley\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":1965,"title":"Adam Zampa","short_name":"A Zampa","first_name":"Adam Zampa","last_name":"","middle_name":"","birthdate":"1992-03-31","birthplace":"Shellharbour, New South Wales","country":"au","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":18970,"recent_appearance":1515900000,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/zampsbook\/","twitter_profile":"https:\/\/twitter.com\/AdamZampaAUS","instagram_profile":"https:\/\/www.instagram.com\/zampstagram","debut_data":"","bowling_type":"Spin","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":10598,"title":"Ben Foakes","short_name":"BT Foakes","first_name":"Ben Foakes","last_name":"","middle_name":"","birthdate":"1993-02-15","birthplace":"Colchester, 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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":10600,"title":"Rory Burns","short_name":"RJ Burns","first_name":"Rory Burns","last_name":"","middle_name":"","birthdate":"1990-08-26","birthplace":"Epsom, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"Occasional Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":43383,"title":"Jamie Overton","short_name":"J Overton","first_name":"Jamie Overton","last_name":"","middle_name":"","birthdate":"1994-04-10","birthplace":"Barnstaple, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/JamieOverton","instagram_profile":"https:\/\/www.instagram.com\/jamie_overton8\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":43389,"title":"Tom Curran","short_name":"TK Curran","first_name":"Tom Curran","last_name":"","middle_name":"","birthdate":"1995-03-12","birthplace":"Cape Town, Cape Province","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/tc59","instagram_profile":"https:\/\/www.instagram.com\/tc59\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":43630,"title":"Daniel Worrall","short_name":"DJ Worrall","first_name":"Daniel Worrall","last_name":"","middle_name":"","birthdate":"1991-07-10","birthplace":"Melbourne, Victoria","country":"au","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":48440,"title":"Jordan Clark","short_name":"J Clark","first_name":"Jordan Clark","last_name":"","middle_name":"","birthdate":"1990-10-14","birthplace":"Whitehaven, Cumbria","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"Occasional Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":48647,"title":"Matt Critchley","short_name":"MJJ Critchley","first_name":"Matt Critchley","last_name":"","middle_name":"","birthdate":"1996-08-13","birthplace":"Preston, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/mattcritchley96","instagram_profile":"https:\/\/www.instagram.com\/critch130896\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":49029,"title":"Laurie Evans","short_name":"LJ Evans","first_name":"Laurie Evans","last_name":"","middle_name":"","birthdate":"1987-10-12","birthplace":"Lambeth, London","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/laurie.evans.39\/","twitter_profile":"https:\/\/twitter.com\/LaurieEvans32","instagram_profile":"https:\/\/www.instagram.com\/laurieevans32\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":49083,"title":"Dean Elgar","short_name":"D Elgar","first_name":"Dean Elgar","last_name":"","middle_name":"","birthdate":"1987-06-11","birthplace":"Welkom, Orange Free state","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":36249,"recent_appearance":1514287800,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BoringDeanElgar","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":49087,"title":"Simon Harmer","short_name":"SR Harmer","first_name":"Simon Harmer","last_name":"","middle_name":"","birthdate":"1989-02-10","birthplace":"Pretoria, Transvaal","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Simon_Harmer_","instagram_profile":"https:\/\/www.instagram.com\/simon_harmer\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bowl","role_str":"(C)"},{"pid":49324,"title":"Matt Dunn","short_name":"MP Dunn","first_name":"Matt Dunn","last_name":"","middle_name":"","birthdate":"1992-05-05","birthplace":"Egham, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49376,"title":"Adam Rossington","short_name":"AM Rossington","first_name":"Adam Rossington","last_name":"","middle_name":"","birthdate":"1993-05-05","birthplace":"Edgware, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper ","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Rossington17","instagram_profile":"https:\/\/www.instagram.com\/rossington17\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49428,"title":"Cameron Steel","short_name":"CT Steel","first_name":"Cameron Steel","last_name":"","middle_name":"","birthdate":"1995-09-13","birthplace":"Greenbrae, California, United States of America","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49593,"title":"Jamie Porter","short_name":"JA Porter","first_name":"Jamie Porter","last_name":"","middle_name":"","birthdate":"1993-05-25","birthplace":"Leytonstone, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49743,"title":"Matthew Fisher","short_name":"MD Fisher","first_name":"Matthew Fisher","last_name":"","middle_name":"","birthdate":"1997-11-09","birthplace":"York","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/9M_Fisher","instagram_profile":"https:\/\/www.instagram.com\/9M_Fisher\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50754,"title":"Dom Sibley","short_name":"DP Sibley","first_name":"Dom Sibley","last_name":"","middle_name":"","birthdate":"1995-09-05","birthplace":"Epsom, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/michael_pep\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":""},{"pid":51290,"title":"Ollie Pope","short_name":"O Pope","first_name":"Ollie Pope","last_name":"","middle_name":"","birthdate":"1998-01-02","birthplace":"Chelsea, 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":8,"facebook_profile":"https:\/\/www.facebook.com\/OliverJohndouglaspope.3\/","twitter_profile":"https:\/\/twitter.com\/OPope32","instagram_profile":"https:\/\/www.instagram.com\/opope32\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51319,"title":"Will Jacks","short_name":"WG Jacks","first_name":"Will Jacks","last_name":"","middle_name":"","birthdate":"1998-11-21","birthplace":"Chertsey, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Wjacks9","instagram_profile":"https:\/\/www.instagram.com\/willjacks9\/","debut_data":"","bowling_type":"Spin","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":61358,"title":"Shane Snater","short_name":"S Snater","first_name":"Shane Snater","last_name":"","middle_name":"","birthdate":"1996-03-24","birthplace":"Harare, Zimbabwe","country":"nl","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"squad","role_str":""},{"pid":68691,"title":"Samuel Cook","short_name":"S Cook","first_name":"Samuel Cook","last_name":"","middle_name":"","birthdate":"1997-08-04","birthplace":"Chelmsford, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/samcook09","instagram_profile":"https:\/\/www.instagram.com\/s_cook16\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":90946,"title":"Ryan Patel","short_name":"RS Patel","first_name":"Ryan Patel","last_name":"","middle_name":"","birthdate":"1997-10-26","birthplace":"Sutton, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":93749,"title":"Gus Atkinson","short_name":"G Atkinson","first_name":"Gus Atkinson","last_name":"","middle_name":"","birthdate":"1998-01-19","birthplace":"Chelsea, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/gus_atkinson1","instagram_profile":"https:\/\/www.instagram.com\/gusatkinson\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":93751,"title":"James Taylor","short_name":"JWA Taylor","first_name":"James Taylor","last_name":"","middle_name":"","birthdate":"2001-01-19","birthplace":"Nottingham","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":93836,"title":"Jamie Smith","short_name":"JL Smith","first_name":"Jamie Smith","last_name":"","middle_name":"","birthdate":"2000-07-12","birthplace":"Epsom, Surrey","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\/jamie_smith148\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":94961,"title":"Jordan Cox","short_name":"J Cox","first_name":"Jordan Cox","last_name":"","middle_name":"","birthdate":"2000-10-21","birthplace":"Margate, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/jjordancox\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":103358,"title":"Robin Das","short_name":"RJ Das","first_name":"Robin Das","last_name":"","middle_name":"","birthdate":"2002-02-27","birthplace":"Leytonstone","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"https:\/\/www.facebook.com\/robindascricketer","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/robinigblue\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":108386,"title":"Thomas Lawes","short_name":"T Lawes","first_name":"Thomas Lawes","last_name":"","middle_name":"","birthdate":"2002-12-25","birthplace":"Singapore","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/tom_lawes\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108393,"title":"Jamal Richards","short_name":"J Richards","first_name":"Jamal Richards","last_name":"","middle_name":"","birthdate":"2004-03-03","birthplace":"Edmonton, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108420,"title":"Luc Benkenstein","short_name":"L Benkenstein","first_name":"Luc Benkenstein","last_name":"","middle_name":"","birthdate":"2004-11-02","birthplace":"Durban","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":109924,"title":"Nathan Barnwell","short_name":"NA Barnwell","first_name":"Nathan Barnwell","last_name":"","middle_name":"","birthdate":"2003-02-03","birthplace":"Ashford, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":118551,"title":"Josh Blake","short_name":"J Blake","first_name":"Josh Blake","last_name":"","middle_name":"","birthdate":"1998-09-18","birthplace":"Carshalton, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":118552,"title":"Yousef Majid","short_name":"Y Majid","first_name":"Yousef Majid","last_name":"","middle_name":"","birthdate":"2003-09-08","birthplace":"Slough, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":127517,"title":"Noah Thain","short_name":"NRM Thain","first_name":"Noah Thain","last_name":"","middle_name":"","birthdate":"2005-01-13","birthplace":"Hitchinbrooke, Hertfordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":129447,"title":"Mackenzie Jones","short_name":"Mackenzie Jones","first_name":"Mackenzie Jones","last_name":"","middle_name":"","birthdate":"2005-03-06","birthplace":"","country":"sct","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Scotland","role":"squad","role_str":""},{"pid":130468,"title":"Tommy Ealham","short_name":"TM Ealham","first_name":"Tommy Ealham","last_name":"","middle_name":"","birthdate":"2004-03-26","birthplace":"Guildford, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":134958,"title":"Charles Allison","short_name":"CW Allison","first_name":"Charles Allison","last_name":"","middle_name":"","birthdate":"2005-03-02","birthplace":"Colchester, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":141008,"title":"Ollie Sykes","short_name":"O Sykes","first_name":"Ollie Sykes","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":141341,"title":"Simon Fernandes","short_name":"Simon Fernandes","first_name":"Simon Fernandes","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":141527,"title":"Seb Stuart Reckling","short_name":"SS Reckling","first_name":"Seb Stuart Reckling","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":150399,"title":"Charlie Edward Bennett","short_name":"CE Bennett","first_name":"Charlie Edward Bennett","last_name":"","middle_name":"","birthdate":"2006-05-01","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""}]},"etag":"d6e4c44b3c8ee16f767733177b7d454a","modified":"2025-07-16 04:10:24","datetime":"2025-07-16 04:10:24","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86901 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:cc08615a-0027-44fa-9ce5-e55f9a5c490d
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86901 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86901,3,'{"status":"ok","response":{"match_id":86901,"title":"Surrey vs Essex","short_title":"SUR vs ESS","subtitle":"Match 81","match_number":"81","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Essex won by 4 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129425,"title":"Vitality Blast","abbr":"Vitality Blast","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-09-13","country":"en","total_matches":"133","total_rounds":"2","total_teams":"18"},"teama":{"team_id":6995,"name":"Surrey","short_name":"SUR","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/surrey-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/surrey-logo.png","scores_full":"141\/6 (12 ov)","scores":"141\/6","overs":"12"},"teamb":{"team_id":104950,"name":"Essex","short_name":"ESS","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","scores_full":"145\/6 (12 ov)","scores":"145\/6","overs":"12"},"date_start":"2025-07-06 15:30:00","date_end":"2025-07-07 01:30:00","timestamp_start":1751815800,"timestamp_end":1751851800,"date_start_ist":"2025-07-06 21:00:00","date_end_ist":"2025-07-07 07:00:00","venue":{"venue_id":"3","name":"Kennington Oval","location":"London","country":"England","timezone":""},"umpires":"Nigel Llong (England), Mark Newell (England)","referee":"Peter Such (England)","equation":"","live":"","result":"ESS won by 4 wickets","result_type":2,"win_margin":"4 wickets","winning_team_id":104950,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-07-05 22:51:00","verify_time":"2025-07-07 01:17:42","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":18.88,"humidity":62,"visibility":10000,"wind_speed":"9.15","clouds":90},"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":"cd55bb8ae2496bfc241f5e9d037149cf","modified":"2025-07-16 04:10:25","datetime":"2025-07-16 04:10:25","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":86901,"title":"Surrey vs Essex","short_title":"SUR vs ESS","subtitle":"Match 81","match_number":"81","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Essex won by 4 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129425,"title":"Vitality Blast","abbr":"Vitality Blast","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-09-13","country":"en","total_matches":"133","total_rounds":"2","total_teams":"18"},"teama":{"team_id":6995,"name":"Surrey","short_name":"SUR","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/surrey-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/surrey-logo.png","scores_full":"141\/6 (12 ov)","scores":"141\/6","overs":"12"},"teamb":{"team_id":104950,"name":"Essex","short_name":"ESS","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","scores_full":"145\/6 (12 ov)","scores":"145\/6","overs":"12"},"date_start":"2025-07-06 15:30:00","date_end":"2025-07-07 01:30:00","timestamp_start":1751815800,"timestamp_end":1751851800,"date_start_ist":"2025-07-06 21:00:00","date_end_ist":"2025-07-07 07:00:00","venue":{"venue_id":"3","name":"Kennington Oval","location":"London","country":"England","timezone":""},"umpires":"Nigel Llong (England), Mark Newell (England)","referee":"Peter Such (England)","equation":"","live":"","result":"ESS won by 4 wickets","result_type":2,"win_margin":"4 wickets","winning_team_id":104950,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-07-05 22:51:00","verify_time":"2025-07-07 01:17:42","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":18.88,"humidity":62,"visibility":10000,"wind_speed":"9.15","clouds":90},"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":"cd55bb8ae2496bfc241f5e9d037149cf","modified":"2025-07-16 04:10:25","datetime":"2025-07-16 04:10:25","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86901 AND DataTypeId = 3 END Live Report & Scorecard of Surrey vs Essex Match 81
Surrey vs Essex, Live Cricket Commentary