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:ac1fa28d-bf05-4ad6-9a97-a61413b8ea05
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86858 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86858,1,'{"status":"ok","response":{"mid":86858,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Northamptonshire won by 10 runs","day_remaining_over":"","team_batting":"Warwickshire","team_bowling":"Northamptonshire","live_inning_number":2,"live_score":{"runs":174,"overs":20,"wickets":8,"target":185,"runrate":8.7,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Kai Smith","batsman_id":94952,"runs":1,"balls_faced":3,"fours":0,"sixes":0,"strike_rate":"33.33"},{"name":"Danny Briggs","batsman_id":49480,"runs":12,"balls_faced":5,"fours":2,"sixes":0,"strike_rate":"240.00"}],"bowlers":[{"name":"Luke Procter","bowler_id":48438,"overs":3,"runs_conceded":36,"wickets":0,"maidens":0,"econ":"12.00"},{"name":"Ben Sanderson","bowler_id":49814,"overs":4,"runs_conceded":31,"wickets":3,"maidens":0,"econ":"7.75"}],"commentaries":[{"event":"overend","over":16,"runs":9,"score":"141\/4","bats":[{"runs":0,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":49041},{"runs":18,"balls_faced":14,"fours":1,"sixes":1,"batsman_id":93}],"bowls":[{"runs_conceded":27,"maidens":0,"wickets":2,"bowler_id":1935,"overs":4},{"runs_conceded":24,"maidens":0,"wickets":0,"bowler_id":48438,"overs":2}],"commentary":"End of over 16 (9 runs), Warwickshire 141\/4"},{"event_id":"12121781","event":"ball","batsman_id":"93","bowler_id":"108384","over":"16","ball":"1","score":"1wd","commentary":"Justin Broad to Moeen Ali, 1 wide,","noball_dismissal":false,"text":"","timestamp":1749672922,"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":"12121788","event":"ball","batsman_id":"93","bowler_id":"108384","over":"16","ball":"1","score":6,"commentary":"Justin Broad to Moeen Ali, Six,","noball_dismissal":false,"text":"","timestamp":1749672955,"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":"12121799","event":"ball","batsman_id":"93","bowler_id":"108384","over":"16","ball":"2","score":0,"commentary":"Justin Broad to Moeen Ali, no run,","noball_dismissal":false,"text":"","timestamp":1749673026,"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":"12121800","event":"ball","batsman_id":"93","bowler_id":"108384","over":"16","ball":"3","score":1,"commentary":"Justin Broad to Moeen Ali, 1 run,","noball_dismissal":false,"text":"","timestamp":1749673029,"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":"12121802","event":"ball","batsman_id":"49041","bowler_id":"108384","over":"16","ball":"4","score":1,"commentary":"Justin Broad to Ed Barnard, 1 run,","noball_dismissal":false,"text":"","timestamp":1749673051,"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":"12121804","event":"ball","batsman_id":"93","bowler_id":"108384","over":"16","ball":"5","score":"1lb","commentary":"Justin Broad to Moeen Ali, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1749673075,"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":"12121817","event":"wicket","batsman_id":"49041","bowler_id":"108384","over":"16","ball":"6","score":"w","commentary":"Justin Broad to Ed Barnard, no run, c D Willey b J Broad,","noball_dismissal":false,"text":"","timestamp":1749673211,"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":"49041","how_out":"c D Willey b J Broad","batsman_runs":"1","batsman_balls":"3"},{"event":"overend","over":17,"runs":10,"score":"151\/5","bats":[{"runs":1,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":49041},{"runs":25,"balls_faced":18,"fours":1,"sixes":2,"batsman_id":93}],"bowls":[{"runs_conceded":9,"maidens":0,"wickets":1,"bowler_id":108384,"overs":1},{"runs_conceded":27,"maidens":0,"wickets":2,"bowler_id":1935,"overs":4}],"commentary":"End of over 17 (10 runs), Warwickshire 151\/5"},{"event_id":"12121820","event":"ball","batsman_id":"93","bowler_id":"50387","over":"17","ball":"1","score":2,"commentary":"George Scrimshaw to Moeen Ali, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749673225,"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":"12121824","event":"ball","batsman_id":"93","bowler_id":"50387","over":"17","ball":"2","score":0,"commentary":"George Scrimshaw to Moeen Ali, no run,","noball_dismissal":false,"text":"","timestamp":1749673250,"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":"12121831","event":"ball","batsman_id":"93","bowler_id":"50387","over":"17","ball":"3","score":0,"commentary":"George Scrimshaw to Moeen Ali, no run,","noball_dismissal":false,"text":"","timestamp":1749673308,"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":"12121832","event":"ball","batsman_id":"93","bowler_id":"50387","over":"17","ball":"4","score":"1lb","commentary":"George Scrimshaw to Moeen Ali, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1749673305,"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":"12121834","event":"ball","batsman_id":"1384","bowler_id":"50387","over":"17","ball":"5","score":1,"commentary":"George Scrimshaw to George Garton, 1 run,","noball_dismissal":false,"text":"","timestamp":1749673316,"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":"12121841","event":"ball","batsman_id":"93","bowler_id":"50387","over":"17","ball":"6","score":4,"commentary":"George Scrimshaw to Moeen Ali, Four,","noball_dismissal":false,"text":"","timestamp":1749673363,"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":18,"runs":8,"score":"159\/5","bats":[{"runs":31,"balls_faced":23,"fours":2,"sixes":2,"batsman_id":93},{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":1384}],"bowls":[{"runs_conceded":25,"maidens":0,"wickets":2,"bowler_id":50387,"overs":4},{"runs_conceded":9,"maidens":0,"wickets":1,"bowler_id":108384,"overs":1}],"commentary":"End of over 18 (8 runs), Warwickshire 159\/5"},{"event_id":"12121848","event":"ball","batsman_id":"1384","bowler_id":"49814","over":"18","ball":"1","score":0,"commentary":"Ben Sanderson to George Garton, no run,","noball_dismissal":false,"text":"","timestamp":1749673451,"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":"12121853","event":"wicket","batsman_id":"1384","bowler_id":"49814","over":"18","ball":"2","score":"w","commentary":"Ben Sanderson to George Garton, no run, b BW Sanderson,","noball_dismissal":false,"text":"","timestamp":1749673523,"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":"1384","how_out":"b BW Sanderson","batsman_runs":"1","batsman_balls":"3"},{"event_id":"12121856","event":"ball","batsman_id":"94952","bowler_id":"49814","over":"18","ball":"3","score":1,"commentary":"Ben Sanderson to Kai Smith, 1 run,","noball_dismissal":false,"text":"","timestamp":1749673582,"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":"12121858","event":"wicket","batsman_id":"93","bowler_id":"49814","over":"18","ball":"4","score":"w","commentary":"Ben Sanderson to Moeen Ali, no run, lbw b BW Sanderson,","noball_dismissal":false,"text":"","timestamp":1749673618,"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":"93","how_out":"lbw b BW Sanderson","batsman_runs":"31","batsman_balls":"24"},{"event_id":"12121864","event":"wicket","batsman_id":"44099","bowler_id":"49814","over":"18","ball":"5","score":"w","commentary":"Ben Sanderson to Hasan Ali, no run, c J Broad b BW Sanderson,","noball_dismissal":false,"text":"","timestamp":1749673740,"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":"44099","how_out":"c J Broad b BW Sanderson","batsman_runs":"0","batsman_balls":"1"},{"event_id":"12121865","event":"ball","batsman_id":"49480","bowler_id":"49814","over":"18","ball":"6","score":1,"commentary":"Ben Sanderson to Danny Briggs, 1 run,","noball_dismissal":false,"text":"","timestamp":1749673767,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":19,"runs":2,"score":"161\/8","bats":[{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":49480},{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":94952}],"bowls":[{"runs_conceded":31,"maidens":0,"wickets":3,"bowler_id":49814,"overs":4},{"runs_conceded":25,"maidens":0,"wickets":2,"bowler_id":50387,"overs":4}],"commentary":"End of over 19 (2 runs), Warwickshire 161\/8"},{"event_id":"12121869","event":"ball","batsman_id":"49480","bowler_id":"48438","over":"19","ball":"1","score":2,"commentary":"Luke Procter to Danny Briggs, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749673839,"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":"12121870","event":"ball","batsman_id":"49480","bowler_id":"48438","over":"19","ball":"2","score":1,"commentary":"Luke Procter to Danny Briggs, 1 run,","noball_dismissal":false,"text":"","timestamp":1749673842,"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":"12121875","event":"ball","batsman_id":"94952","bowler_id":"48438","over":"19","ball":"3","score":"1wd","commentary":"Luke Procter to Kai Smith, 1 wide,","noball_dismissal":false,"text":"","timestamp":1749673899,"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":"12121876","event":"ball","batsman_id":"94952","bowler_id":"48438","over":"19","ball":"3","score":0,"commentary":"Luke Procter to Kai Smith, no run,","noball_dismissal":false,"text":"","timestamp":1749673913,"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":"12121878","event":"ball","batsman_id":"94952","bowler_id":"48438","over":"19","ball":"4","score":"1lb","commentary":"Luke Procter to Kai Smith, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1749674002,"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":"12121879","event":"ball","batsman_id":"49480","bowler_id":"48438","over":"19","ball":"5","score":4,"commentary":"Luke Procter to Danny Briggs, Four,","noball_dismissal":false,"text":"","timestamp":1749674005,"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":"12121880","event":"ball","batsman_id":"49480","bowler_id":"48438","over":"19","ball":"6","score":4,"commentary":"Luke Procter to Danny Briggs, Four,","noball_dismissal":false,"text":"","timestamp":1749674013,"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":20,"runs":13,"score":"174\/8","bats":[{"runs":12,"balls_faced":5,"fours":2,"sixes":0,"batsman_id":49480},{"runs":1,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":94952}],"bowls":[{"runs_conceded":36,"maidens":0,"wickets":0,"bowler_id":48438,"overs":3},{"runs_conceded":31,"maidens":0,"wickets":3,"bowler_id":49814,"overs":4}],"commentary":"End of over 20 (13 runs), Warwickshire 174\/8"}],"day":"0","session":"0","live_inning":{"iid":197860,"number":2,"name":"Warwickshire Inning","short_name":"WAS Inning","status":2,"issuperover":"false","result":4,"batting_team_id":7002,"fielding_team_id":7038,"scores":"174\/8","scores_full":"174\/8 (20 ov)","fielder":[{"fielder_id":"50387","fielder_name":"George Scrimshaw","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"49770","fielder_name":"Saif Zaib","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"50478","fielder_name":"Lewis McManus","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"1935","fielder_name":"David Willey","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"108384","fielder_name":"Justin Broad","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":"Hasan Ali","batsman_id":"44099","runs":"0","balls":"1","how_out":"c J Broad b BW Sanderson","score_at_dismissal":160,"overs_at_dismissal":"18.5","bowler_id":"49814","dismissal":"caught","number":8},"extra_runs":{"byes":0,"legbyes":10,"wides":6,"noballs":0,"penalty":"0","total":16},"equations":{"runs":174,"wickets":8,"overs":"20","bowlers_used":7,"runrate":"8.70"},"current_partnership":{"runs":14,"balls":7,"overs":1.1,"batsmen":[{"name":"Danny Briggs","batsman_id":49480,"runs":12,"balls":5},{"name":"Kai Smith","batsman_id":94952,"runs":0,"balls":2}]},"did_not_bat":[{"player_id":"102808","name":"Jake Lintott"}],"max_over":"20","target":"185","recent_scores":"4,4,1,0,1,1,2,1,w,w,1,w,0,4,1,1,0,0","last_five_overs":"42\/5 7.41","last_ten_overs":"80\/6 7.50"},"teams":[{"tid":7002,"title":"Warwickshire","abbr":"WAS","alt_name":"Warwickshire","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Warwickshire.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Warwickshire.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"174\/8 (20 ov)","scores":"174\/8","overs":"20"},{"tid":7038,"title":"Northamptonshire","abbr":"NOR","alt_name":"NOR","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/northamptonshire-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/northamptonshire-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"184\/6 (20 ov)","scores":"184\/6","overs":"20"}],"players":[{"pid":93,"title":"Moeen Ali","short_name":"M Ali","first_name":"Moeen Ali","last_name":"","middle_name":"","birthdate":"1987-06-18","birthplace":"Birmingham","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/moeenmunirali\/","twitter_profile":"https:\/\/twitter.com\/MoeenaliAli","instagram_profile":"https:\/\/www.instagram.com\/moeenmunirali\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":107,"title":"Chris Woakes","short_name":"C Woakes","first_name":"Chris Woakes","last_name":"","middle_name":"","birthdate":"1989-03-02","birthplace":"Birmingham, Warwickshire","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":"https:\/\/www.facebook.com\/chriswoakes\/","twitter_profile":"https:\/\/twitter.com\/chriswoakes","instagram_profile":"https:\/\/www.instagram.com\/chriswoakes\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":474,"title":"Ravi Bopara","short_name":"R Bopara","first_name":"Ravi Bopara","last_name":"","middle_name":"","birthdate":"1985-05-04","birthplace":" Forest Gate, London","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/ravibopara","instagram_profile":"https:\/\/www.instagram.com\/ravibopara\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":1046,"title":"George Bartlett","short_name":"GA Bartlett","first_name":"George Bartlett","last_name":"","middle_name":"","birthdate":"1998-03-14","birthplace":"Frimley, Surrey","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":1384,"title":"George Garton","short_name":"G Garton","first_name":"George Garton","last_name":"","middle_name":"","birthdate":"1997-04-15","birthplace":"Brighton, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/george_garton","instagram_profile":"https:\/\/www.instagram.com\/georgegarton\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":1935,"title":"David Willey","short_name":"D Willey","first_name":"David Willey","last_name":"","middle_name":"","birthdate":"1990-02-28","birthplace":"Northampton","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":18974,"recent_appearance":1517109600,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/DavidWilleyCricket\/","twitter_profile":"https:\/\/twitter.com\/david_willey","instagram_profile":"https:\/\/www.instagram.com\/david_willey72\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":"(C)"},{"pid":44099,"title":"Hasan Ali","short_name":"H Ali","first_name":"Hasan Ali","last_name":"","middle_name":"","birthdate":"1994-07-02","birthplace":"Gujranwala, Punjab","country":"pk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/Realhassan32\/","twitter_profile":"https:\/\/twitter.com\/RealHa55an","instagram_profile":"https:\/\/www.instagram.com\/ha55an_ali\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bowl","role_str":""},{"pid":44185,"title":"Tom Latham","short_name":"T Latham","first_name":"Tom Latham","last_name":"","middle_name":"","birthdate":"1992-04-02","birthplace":"Christchurch, Canterbury","country":"nz","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"wicket keeper","recent_match":23991,"recent_appearance":1513980000,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/tomlathamofficial","twitter_profile":"https:\/\/twitter.com\/Tomlatham2","instagram_profile":"https:\/\/www.instagram.com\/tomlatham2\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"wk","role_str":"(WK)"},{"pid":46852,"title":"Matthew Breetzke","short_name":"MP Breetzke","first_name":"Matthew Breetzke","last_name":"","middle_name":"","birthdate":"1998-11-03","birthplace":"Gqeberha, South Africa","country":"za","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":23791,"recent_appearance":1515879000,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/matt_03_","instagram_profile":"https:\/\/www.instagram.com\/i3mbreetzke\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"wk","role_str":""},{"pid":46884,"title":"Ricardo Vasconcelos","short_name":"Rs Vasconcelos","first_name":"Ricardo Vasconcelos","last_name":"","middle_name":"","birthdate":"1997-10-27","birthplace":" Johannesburg, Gauteng","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/ricardo.vasconcelos.169\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/ricardo27vasco\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bat","role_str":""},{"pid":48430,"title":"Alex Davies","short_name":"AL Davies","first_name":"Alex Davies","last_name":"","middle_name":"","birthdate":"1994-08-23","birthplace":"Darwen, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/aldavies23\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(C)"},{"pid":48438,"title":"Luke Procter","short_name":"LA Procter","first_name":"Luke Procter","last_name":"","middle_name":"","birthdate":"1988-06-24","birthplace":" Oldham, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":49017,"title":"Oliver Hannon-Dalby","short_name":"OJ Hannon-Dalby","first_name":"Oliver Hannon-Dalby","last_name":"","middle_name":"","birthdate":"1989-06-20","birthplace":" Halifax, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49025,"title":"Sam Hain","short_name":"SR Hain","first_name":"Sam Hain","last_name":"","middle_name":"","birthdate":"1995-07-16","birthplace":"Hong Kong","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.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/SammieHain","instagram_profile":"https:\/\/www.instagram.com\/sammiehain","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":49041,"title":"Ed Barnard","short_name":"EG Barnard","first_name":"Ed Barnard","last_name":"","middle_name":"","birthdate":"1995-11-20","birthplace":"","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":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":49320,"title":"Chris Rushworth","short_name":"C Rushworth","first_name":"Chris Rushworth","last_name":"","middle_name":"","birthdate":"1986-07-11","birthplace":"Sunderland","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49372,"title":"Rob Keogh","short_name":"RI Keogh","first_name":"Rob Keogh","last_name":"","middle_name":"","birthdate":"1991-10-21","birthplace":" Dunstable, United","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49480,"title":"Danny Briggs","short_name":"DR Briggs","first_name":"Danny Briggs","last_name":"","middle_name":"","birthdate":"1991-04-30","birthplace":" Newport, Isle of Wight","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/DannyBriggs_14","instagram_profile":"https:\/\/www.instagram.com\/dannybriggs14\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":49530,"title":"Craig Miles","short_name":"CN Miles","first_name":"Craig Miles","last_name":"","middle_name":"","birthdate":"1994-07-20","birthplace":"Swindon, Wiltshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/CMiles_18","instagram_profile":"https:\/\/www.instagram.com\/cmiles18\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49770,"title":"Saif Zaib","short_name":"SA Zaib","first_name":"Saif Zaib","last_name":"","middle_name":"","birthdate":"1998-05-22","birthplace":" High Wycombe, Buckinghamshire","country":"en","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":"","twitter_profile":"https:\/\/twitter.com\/zaib_05","instagram_profile":"https:\/\/www.instagram.com\/saif_zaib18\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":49814,"title":"Ben Sanderson","short_name":"BW Sanderson","first_name":"Ben Sanderson","last_name":"","middle_name":"","birthdate":"1989-01-03","birthplace":"Sheffield, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":50387,"title":"George Scrimshaw","short_name":"GLS Scrimshaw","first_name":"George Scrimshaw","last_name":"","middle_name":"","birthdate":"1998-02-10","birthplace":"Burton-on-Trent, Staffordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"https:\/\/www.facebook.com\/george.scrimshaw.1\/","twitter_profile":"https:\/\/twitter.com\/Gscrimshaw98","instagram_profile":"https:\/\/www.instagram.com\/gscrimshaw9\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":50478,"title":"Lewis McManus","short_name":"LD McManus","first_name":"Lewis McManus","last_name":"","middle_name":"","birthdate":"1994-10-09","birthplace":"Poole Hospital","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lewis_mcmanus","instagram_profile":"https:\/\/www.instagram.com\/lewismcmanus18\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":50945,"title":"Richard Gleeson","short_name":"RJ Gleeson","first_name":"Richard Gleeson","last_name":"","middle_name":"","birthdate":"1987-12-02","birthplace":" Blackpool, Lancashire","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,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/RicGleeson","instagram_profile":"https:\/\/www.instagram.com\/rgleeson33\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":52878,"title":"Liam Guthrie","short_name":"L Guthrie","first_name":"Liam Guthrie","last_name":"","middle_name":"","birthdate":"1997-04-09","birthplace":"","country":"au","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/lguthrie7\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":53626,"title":"Beau Webster","short_name":"BJ Webster","first_name":"Beau Webster","last_name":"","middle_name":"","birthdate":"1993-12-01","birthplace":"Snug, Hobart, Tasmania","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":88689,"title":"Zen Malik","short_name":"Z Malik","first_name":"Zen Malik","last_name":"","middle_name":"","birthdate":"1998-04-09","birthplace":"","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":93459,"title":"Lloyd Pope","short_name":"L Pope","first_name":"Lloyd Pope","last_name":"","middle_name":"","birthdate":"1999-12-01","birthplace":"","country":"au","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":23792,"recent_appearance":1515891600,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/lloydpoonslayer69\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/lloyd_pope24\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"bowl","role_str":""},{"pid":93516,"title":"Ethan Bamber","short_name":"ER Bamber","first_name":"Ethan Bamber","last_name":"","middle_name":"","birthdate":"1998-12-17","birthplace":"Westminster, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/etbamber","instagram_profile":"https:\/\/www.instagram.com\/etbamber\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":94952,"title":"Kai Smith","short_name":"K Smith","first_name":"Kai Smith","last_name":"","middle_name":"","birthdate":"2004-11-28","birthplace":" Dubai, United Arab Emirates","country":"ae","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"wk","role_str":""},{"pid":95003,"title":"Robert Yates","short_name":"RM Yates","first_name":"Robert Yates","last_name":"","middle_name":"","birthdate":"1999-09-19","birthplace":"Solihull, Warwickshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95543,"title":"Dan Mousley","short_name":"D Mousley","first_name":"Dan Mousley","last_name":"","middle_name":"","birthdate":"2001-07-08","birthplace":"Birmingham, Warwickshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/danmousley80","instagram_profile":"https:\/\/www.instagram.com\/danmousley80\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":95557,"title":"Dominic Leech","short_name":"D Leech","first_name":"Dominic Leech","last_name":"","middle_name":"","birthdate":"2001-01-10","birthplace":" Middlesbrough, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":102808,"title":"Jake Lintott","short_name":"J Lintott","first_name":"Jake Lintott","last_name":"","middle_name":"","birthdate":"1993-04-22","birthplace":"Taunton, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Wrist Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lintott23","instagram_profile":"https:\/\/www.instagram.com\/lintott23\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":108384,"title":"Justin Broad","short_name":"J Broad","first_name":"Justin Broad","last_name":"","middle_name":"","birthdate":"2000-06-30","birthplace":"Cape Town, South Africa","country":"za","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"all","role_str":""},{"pid":108388,"title":"Jacob Bethell","short_name":"J Bethell","first_name":"Jacob Bethell","last_name":"","middle_name":"","birthdate":"2003-10-23","birthplace":"Barbados","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BethellJacob","instagram_profile":"https:\/\/www.instagram.com\/jacob.bethell\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108389,"title":"Che Simmons","short_name":"C Simmons","first_name":"Che Simmons","last_name":"","middle_name":"","birthdate":"2003-12-18","birthplace":"Birmingham, England","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108411,"title":"Gus Miller","short_name":"G Miller","first_name":"Gus Miller","last_name":"","middle_name":"","birthdate":"2002-01-08","birthplace":"Oxford","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108414,"title":"Freddie Heldreich","short_name":"F Heldreich","first_name":"Freddie Heldreich","last_name":"","middle_name":"","birthdate":"2001-09-12","birthplace":"Ipswich, Suffolk","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Wrist Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108418,"title":"James Sales","short_name":"J Sales","first_name":"James Sales","last_name":"","middle_name":"","birthdate":"2003-02-11","birthplace":"Northampton","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":109583,"title":"Hamza Shaikh","short_name":"H Shaikh","first_name":"Hamza Shaikh","last_name":"","middle_name":"","birthdate":"2006-05-29","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":110496,"title":"Tazeem Ali","short_name":"T Ali","first_name":"Tazeem Ali","last_name":"","middle_name":"","birthdate":"2006-06-13","birthplace":"","country":"nl","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"squad","role_str":""},{"pid":118723,"title":"Arush Buchake","short_name":"A Buchake","first_name":"Arush Buchake","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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":118724,"title":"Aadi Sharma","short_name":"A Sharma","first_name":"Aadi Sharma","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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":119917,"title":"Adam Sylvester","short_name":"A Sylvester","first_name":"Adam Sylvester","last_name":"","middle_name":"","birthdate":"2000-05-18","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":130479,"title":"Raphael Weatherall","short_name":"R Weatherall","first_name":"Raphael Weatherall","last_name":"","middle_name":"","birthdate":"2004-10-24","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":148504,"title":"Tiaan Louw","short_name":"T Louw","first_name":"Tiaan Louw","last_name":"","middle_name":"","birthdate":"2006-04-16","birthplace":"","country":"en","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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""}]},"etag":"fcf01398d8850d76703211957e257c94","modified":"2025-07-27 16:35:57","datetime":"2025-07-27 16:35:57","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":86858,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Northamptonshire won by 10 runs","day_remaining_over":"","team_batting":"Warwickshire","team_bowling":"Northamptonshire","live_inning_number":2,"live_score":{"runs":174,"overs":20,"wickets":8,"target":185,"runrate":8.7,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Kai Smith","batsman_id":94952,"runs":1,"balls_faced":3,"fours":0,"sixes":0,"strike_rate":"33.33"},{"name":"Danny Briggs","batsman_id":49480,"runs":12,"balls_faced":5,"fours":2,"sixes":0,"strike_rate":"240.00"}],"bowlers":[{"name":"Luke Procter","bowler_id":48438,"overs":3,"runs_conceded":36,"wickets":0,"maidens":0,"econ":"12.00"},{"name":"Ben Sanderson","bowler_id":49814,"overs":4,"runs_conceded":31,"wickets":3,"maidens":0,"econ":"7.75"}],"commentaries":[{"event":"overend","over":16,"runs":9,"score":"141\/4","bats":[{"runs":0,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":49041},{"runs":18,"balls_faced":14,"fours":1,"sixes":1,"batsman_id":93}],"bowls":[{"runs_conceded":27,"maidens":0,"wickets":2,"bowler_id":1935,"overs":4},{"runs_conceded":24,"maidens":0,"wickets":0,"bowler_id":48438,"overs":2}],"commentary":"End of over 16 (9 runs), Warwickshire 141\/4"},{"event_id":"12121781","event":"ball","batsman_id":"93","bowler_id":"108384","over":"16","ball":"1","score":"1wd","commentary":"Justin Broad to Moeen Ali, 1 wide,","noball_dismissal":false,"text":"","timestamp":1749672922,"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":"12121788","event":"ball","batsman_id":"93","bowler_id":"108384","over":"16","ball":"1","score":6,"commentary":"Justin Broad to Moeen Ali, Six,","noball_dismissal":false,"text":"","timestamp":1749672955,"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":"12121799","event":"ball","batsman_id":"93","bowler_id":"108384","over":"16","ball":"2","score":0,"commentary":"Justin Broad to Moeen Ali, no run,","noball_dismissal":false,"text":"","timestamp":1749673026,"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":"12121800","event":"ball","batsman_id":"93","bowler_id":"108384","over":"16","ball":"3","score":1,"commentary":"Justin Broad to Moeen Ali, 1 run,","noball_dismissal":false,"text":"","timestamp":1749673029,"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":"12121802","event":"ball","batsman_id":"49041","bowler_id":"108384","over":"16","ball":"4","score":1,"commentary":"Justin Broad to Ed Barnard, 1 run,","noball_dismissal":false,"text":"","timestamp":1749673051,"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":"12121804","event":"ball","batsman_id":"93","bowler_id":"108384","over":"16","ball":"5","score":"1lb","commentary":"Justin Broad to Moeen Ali, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1749673075,"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":"12121817","event":"wicket","batsman_id":"49041","bowler_id":"108384","over":"16","ball":"6","score":"w","commentary":"Justin Broad to Ed Barnard, no run, c D Willey b J Broad,","noball_dismissal":false,"text":"","timestamp":1749673211,"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":"49041","how_out":"c D Willey b J Broad","batsman_runs":"1","batsman_balls":"3"},{"event":"overend","over":17,"runs":10,"score":"151\/5","bats":[{"runs":1,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":49041},{"runs":25,"balls_faced":18,"fours":1,"sixes":2,"batsman_id":93}],"bowls":[{"runs_conceded":9,"maidens":0,"wickets":1,"bowler_id":108384,"overs":1},{"runs_conceded":27,"maidens":0,"wickets":2,"bowler_id":1935,"overs":4}],"commentary":"End of over 17 (10 runs), Warwickshire 151\/5"},{"event_id":"12121820","event":"ball","batsman_id":"93","bowler_id":"50387","over":"17","ball":"1","score":2,"commentary":"George Scrimshaw to Moeen Ali, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749673225,"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":"12121824","event":"ball","batsman_id":"93","bowler_id":"50387","over":"17","ball":"2","score":0,"commentary":"George Scrimshaw to Moeen Ali, no run,","noball_dismissal":false,"text":"","timestamp":1749673250,"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":"12121831","event":"ball","batsman_id":"93","bowler_id":"50387","over":"17","ball":"3","score":0,"commentary":"George Scrimshaw to Moeen Ali, no run,","noball_dismissal":false,"text":"","timestamp":1749673308,"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":"12121832","event":"ball","batsman_id":"93","bowler_id":"50387","over":"17","ball":"4","score":"1lb","commentary":"George Scrimshaw to Moeen Ali, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1749673305,"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":"12121834","event":"ball","batsman_id":"1384","bowler_id":"50387","over":"17","ball":"5","score":1,"commentary":"George Scrimshaw to George Garton, 1 run,","noball_dismissal":false,"text":"","timestamp":1749673316,"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":"12121841","event":"ball","batsman_id":"93","bowler_id":"50387","over":"17","ball":"6","score":4,"commentary":"George Scrimshaw to Moeen Ali, Four,","noball_dismissal":false,"text":"","timestamp":1749673363,"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":18,"runs":8,"score":"159\/5","bats":[{"runs":31,"balls_faced":23,"fours":2,"sixes":2,"batsman_id":93},{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":1384}],"bowls":[{"runs_conceded":25,"maidens":0,"wickets":2,"bowler_id":50387,"overs":4},{"runs_conceded":9,"maidens":0,"wickets":1,"bowler_id":108384,"overs":1}],"commentary":"End of over 18 (8 runs), Warwickshire 159\/5"},{"event_id":"12121848","event":"ball","batsman_id":"1384","bowler_id":"49814","over":"18","ball":"1","score":0,"commentary":"Ben Sanderson to George Garton, no run,","noball_dismissal":false,"text":"","timestamp":1749673451,"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":"12121853","event":"wicket","batsman_id":"1384","bowler_id":"49814","over":"18","ball":"2","score":"w","commentary":"Ben Sanderson to George Garton, no run, b BW Sanderson,","noball_dismissal":false,"text":"","timestamp":1749673523,"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":"1384","how_out":"b BW Sanderson","batsman_runs":"1","batsman_balls":"3"},{"event_id":"12121856","event":"ball","batsman_id":"94952","bowler_id":"49814","over":"18","ball":"3","score":1,"commentary":"Ben Sanderson to Kai Smith, 1 run,","noball_dismissal":false,"text":"","timestamp":1749673582,"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":"12121858","event":"wicket","batsman_id":"93","bowler_id":"49814","over":"18","ball":"4","score":"w","commentary":"Ben Sanderson to Moeen Ali, no run, lbw b BW Sanderson,","noball_dismissal":false,"text":"","timestamp":1749673618,"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":"93","how_out":"lbw b BW Sanderson","batsman_runs":"31","batsman_balls":"24"},{"event_id":"12121864","event":"wicket","batsman_id":"44099","bowler_id":"49814","over":"18","ball":"5","score":"w","commentary":"Ben Sanderson to Hasan Ali, no run, c J Broad b BW Sanderson,","noball_dismissal":false,"text":"","timestamp":1749673740,"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":"44099","how_out":"c J Broad b BW Sanderson","batsman_runs":"0","batsman_balls":"1"},{"event_id":"12121865","event":"ball","batsman_id":"49480","bowler_id":"49814","over":"18","ball":"6","score":1,"commentary":"Ben Sanderson to Danny Briggs, 1 run,","noball_dismissal":false,"text":"","timestamp":1749673767,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":19,"runs":2,"score":"161\/8","bats":[{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":49480},{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":94952}],"bowls":[{"runs_conceded":31,"maidens":0,"wickets":3,"bowler_id":49814,"overs":4},{"runs_conceded":25,"maidens":0,"wickets":2,"bowler_id":50387,"overs":4}],"commentary":"End of over 19 (2 runs), Warwickshire 161\/8"},{"event_id":"12121869","event":"ball","batsman_id":"49480","bowler_id":"48438","over":"19","ball":"1","score":2,"commentary":"Luke Procter to Danny Briggs, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749673839,"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":"12121870","event":"ball","batsman_id":"49480","bowler_id":"48438","over":"19","ball":"2","score":1,"commentary":"Luke Procter to Danny Briggs, 1 run,","noball_dismissal":false,"text":"","timestamp":1749673842,"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":"12121875","event":"ball","batsman_id":"94952","bowler_id":"48438","over":"19","ball":"3","score":"1wd","commentary":"Luke Procter to Kai Smith, 1 wide,","noball_dismissal":false,"text":"","timestamp":1749673899,"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":"12121876","event":"ball","batsman_id":"94952","bowler_id":"48438","over":"19","ball":"3","score":0,"commentary":"Luke Procter to Kai Smith, no run,","noball_dismissal":false,"text":"","timestamp":1749673913,"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":"12121878","event":"ball","batsman_id":"94952","bowler_id":"48438","over":"19","ball":"4","score":"1lb","commentary":"Luke Procter to Kai Smith, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1749674002,"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":"12121879","event":"ball","batsman_id":"49480","bowler_id":"48438","over":"19","ball":"5","score":4,"commentary":"Luke Procter to Danny Briggs, Four,","noball_dismissal":false,"text":"","timestamp":1749674005,"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":"12121880","event":"ball","batsman_id":"49480","bowler_id":"48438","over":"19","ball":"6","score":4,"commentary":"Luke Procter to Danny Briggs, Four,","noball_dismissal":false,"text":"","timestamp":1749674013,"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":20,"runs":13,"score":"174\/8","bats":[{"runs":12,"balls_faced":5,"fours":2,"sixes":0,"batsman_id":49480},{"runs":1,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":94952}],"bowls":[{"runs_conceded":36,"maidens":0,"wickets":0,"bowler_id":48438,"overs":3},{"runs_conceded":31,"maidens":0,"wickets":3,"bowler_id":49814,"overs":4}],"commentary":"End of over 20 (13 runs), Warwickshire 174\/8"}],"day":"0","session":"0","live_inning":{"iid":197860,"number":2,"name":"Warwickshire Inning","short_name":"WAS Inning","status":2,"issuperover":"false","result":4,"batting_team_id":7002,"fielding_team_id":7038,"scores":"174\/8","scores_full":"174\/8 (20 ov)","fielder":[{"fielder_id":"50387","fielder_name":"George Scrimshaw","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"49770","fielder_name":"Saif Zaib","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"50478","fielder_name":"Lewis McManus","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"1935","fielder_name":"David Willey","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"108384","fielder_name":"Justin Broad","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":"Hasan Ali","batsman_id":"44099","runs":"0","balls":"1","how_out":"c J Broad b BW Sanderson","score_at_dismissal":160,"overs_at_dismissal":"18.5","bowler_id":"49814","dismissal":"caught","number":8},"extra_runs":{"byes":0,"legbyes":10,"wides":6,"noballs":0,"penalty":"0","total":16},"equations":{"runs":174,"wickets":8,"overs":"20","bowlers_used":7,"runrate":"8.70"},"current_partnership":{"runs":14,"balls":7,"overs":1.1,"batsmen":[{"name":"Danny Briggs","batsman_id":49480,"runs":12,"balls":5},{"name":"Kai Smith","batsman_id":94952,"runs":0,"balls":2}]},"did_not_bat":[{"player_id":"102808","name":"Jake Lintott"}],"max_over":"20","target":"185","recent_scores":"4,4,1,0,1,1,2,1,w,w,1,w,0,4,1,1,0,0","last_five_overs":"42\/5 7.41","last_ten_overs":"80\/6 7.50"},"teams":[{"tid":7002,"title":"Warwickshire","abbr":"WAS","alt_name":"Warwickshire","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Warwickshire.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Warwickshire.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"174\/8 (20 ov)","scores":"174\/8","overs":"20"},{"tid":7038,"title":"Northamptonshire","abbr":"NOR","alt_name":"NOR","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/northamptonshire-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/northamptonshire-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"184\/6 (20 ov)","scores":"184\/6","overs":"20"}],"players":[{"pid":93,"title":"Moeen Ali","short_name":"M Ali","first_name":"Moeen Ali","last_name":"","middle_name":"","birthdate":"1987-06-18","birthplace":"Birmingham","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/moeenmunirali\/","twitter_profile":"https:\/\/twitter.com\/MoeenaliAli","instagram_profile":"https:\/\/www.instagram.com\/moeenmunirali\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":107,"title":"Chris Woakes","short_name":"C Woakes","first_name":"Chris Woakes","last_name":"","middle_name":"","birthdate":"1989-03-02","birthplace":"Birmingham, Warwickshire","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":"https:\/\/www.facebook.com\/chriswoakes\/","twitter_profile":"https:\/\/twitter.com\/chriswoakes","instagram_profile":"https:\/\/www.instagram.com\/chriswoakes\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":474,"title":"Ravi Bopara","short_name":"R Bopara","first_name":"Ravi Bopara","last_name":"","middle_name":"","birthdate":"1985-05-04","birthplace":" Forest Gate, London","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/ravibopara","instagram_profile":"https:\/\/www.instagram.com\/ravibopara\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":1046,"title":"George Bartlett","short_name":"GA Bartlett","first_name":"George Bartlett","last_name":"","middle_name":"","birthdate":"1998-03-14","birthplace":"Frimley, Surrey","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":1384,"title":"George Garton","short_name":"G Garton","first_name":"George Garton","last_name":"","middle_name":"","birthdate":"1997-04-15","birthplace":"Brighton, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/george_garton","instagram_profile":"https:\/\/www.instagram.com\/georgegarton\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":1935,"title":"David Willey","short_name":"D Willey","first_name":"David Willey","last_name":"","middle_name":"","birthdate":"1990-02-28","birthplace":"Northampton","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":18974,"recent_appearance":1517109600,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/DavidWilleyCricket\/","twitter_profile":"https:\/\/twitter.com\/david_willey","instagram_profile":"https:\/\/www.instagram.com\/david_willey72\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":"(C)"},{"pid":44099,"title":"Hasan Ali","short_name":"H Ali","first_name":"Hasan Ali","last_name":"","middle_name":"","birthdate":"1994-07-02","birthplace":"Gujranwala, Punjab","country":"pk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/Realhassan32\/","twitter_profile":"https:\/\/twitter.com\/RealHa55an","instagram_profile":"https:\/\/www.instagram.com\/ha55an_ali\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bowl","role_str":""},{"pid":44185,"title":"Tom Latham","short_name":"T Latham","first_name":"Tom Latham","last_name":"","middle_name":"","birthdate":"1992-04-02","birthplace":"Christchurch, Canterbury","country":"nz","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"wicket keeper","recent_match":23991,"recent_appearance":1513980000,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/tomlathamofficial","twitter_profile":"https:\/\/twitter.com\/Tomlatham2","instagram_profile":"https:\/\/www.instagram.com\/tomlatham2\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"wk","role_str":"(WK)"},{"pid":46852,"title":"Matthew Breetzke","short_name":"MP Breetzke","first_name":"Matthew Breetzke","last_name":"","middle_name":"","birthdate":"1998-11-03","birthplace":"Gqeberha, South Africa","country":"za","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":23791,"recent_appearance":1515879000,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/matt_03_","instagram_profile":"https:\/\/www.instagram.com\/i3mbreetzke\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"wk","role_str":""},{"pid":46884,"title":"Ricardo Vasconcelos","short_name":"Rs Vasconcelos","first_name":"Ricardo Vasconcelos","last_name":"","middle_name":"","birthdate":"1997-10-27","birthplace":" Johannesburg, Gauteng","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/ricardo.vasconcelos.169\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/ricardo27vasco\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bat","role_str":""},{"pid":48430,"title":"Alex Davies","short_name":"AL Davies","first_name":"Alex Davies","last_name":"","middle_name":"","birthdate":"1994-08-23","birthplace":"Darwen, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/aldavies23\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(C)"},{"pid":48438,"title":"Luke Procter","short_name":"LA Procter","first_name":"Luke Procter","last_name":"","middle_name":"","birthdate":"1988-06-24","birthplace":" Oldham, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":49017,"title":"Oliver Hannon-Dalby","short_name":"OJ Hannon-Dalby","first_name":"Oliver Hannon-Dalby","last_name":"","middle_name":"","birthdate":"1989-06-20","birthplace":" Halifax, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49025,"title":"Sam Hain","short_name":"SR Hain","first_name":"Sam Hain","last_name":"","middle_name":"","birthdate":"1995-07-16","birthplace":"Hong Kong","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.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/SammieHain","instagram_profile":"https:\/\/www.instagram.com\/sammiehain","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":49041,"title":"Ed Barnard","short_name":"EG Barnard","first_name":"Ed Barnard","last_name":"","middle_name":"","birthdate":"1995-11-20","birthplace":"","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":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":49320,"title":"Chris Rushworth","short_name":"C Rushworth","first_name":"Chris Rushworth","last_name":"","middle_name":"","birthdate":"1986-07-11","birthplace":"Sunderland","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49372,"title":"Rob Keogh","short_name":"RI Keogh","first_name":"Rob Keogh","last_name":"","middle_name":"","birthdate":"1991-10-21","birthplace":" Dunstable, United","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49480,"title":"Danny Briggs","short_name":"DR Briggs","first_name":"Danny Briggs","last_name":"","middle_name":"","birthdate":"1991-04-30","birthplace":" Newport, Isle of Wight","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/DannyBriggs_14","instagram_profile":"https:\/\/www.instagram.com\/dannybriggs14\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":49530,"title":"Craig Miles","short_name":"CN Miles","first_name":"Craig Miles","last_name":"","middle_name":"","birthdate":"1994-07-20","birthplace":"Swindon, Wiltshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/CMiles_18","instagram_profile":"https:\/\/www.instagram.com\/cmiles18\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49770,"title":"Saif Zaib","short_name":"SA Zaib","first_name":"Saif Zaib","last_name":"","middle_name":"","birthdate":"1998-05-22","birthplace":" High Wycombe, Buckinghamshire","country":"en","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":"","twitter_profile":"https:\/\/twitter.com\/zaib_05","instagram_profile":"https:\/\/www.instagram.com\/saif_zaib18\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":49814,"title":"Ben Sanderson","short_name":"BW Sanderson","first_name":"Ben Sanderson","last_name":"","middle_name":"","birthdate":"1989-01-03","birthplace":"Sheffield, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":50387,"title":"George Scrimshaw","short_name":"GLS Scrimshaw","first_name":"George Scrimshaw","last_name":"","middle_name":"","birthdate":"1998-02-10","birthplace":"Burton-on-Trent, Staffordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"https:\/\/www.facebook.com\/george.scrimshaw.1\/","twitter_profile":"https:\/\/twitter.com\/Gscrimshaw98","instagram_profile":"https:\/\/www.instagram.com\/gscrimshaw9\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":50478,"title":"Lewis McManus","short_name":"LD McManus","first_name":"Lewis McManus","last_name":"","middle_name":"","birthdate":"1994-10-09","birthplace":"Poole Hospital","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lewis_mcmanus","instagram_profile":"https:\/\/www.instagram.com\/lewismcmanus18\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":50945,"title":"Richard Gleeson","short_name":"RJ Gleeson","first_name":"Richard Gleeson","last_name":"","middle_name":"","birthdate":"1987-12-02","birthplace":" Blackpool, Lancashire","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,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/RicGleeson","instagram_profile":"https:\/\/www.instagram.com\/rgleeson33\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":52878,"title":"Liam Guthrie","short_name":"L Guthrie","first_name":"Liam Guthrie","last_name":"","middle_name":"","birthdate":"1997-04-09","birthplace":"","country":"au","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/lguthrie7\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":53626,"title":"Beau Webster","short_name":"BJ Webster","first_name":"Beau Webster","last_name":"","middle_name":"","birthdate":"1993-12-01","birthplace":"Snug, Hobart, Tasmania","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":88689,"title":"Zen Malik","short_name":"Z Malik","first_name":"Zen Malik","last_name":"","middle_name":"","birthdate":"1998-04-09","birthplace":"","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":93459,"title":"Lloyd Pope","short_name":"L Pope","first_name":"Lloyd Pope","last_name":"","middle_name":"","birthdate":"1999-12-01","birthplace":"","country":"au","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":23792,"recent_appearance":1515891600,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/lloydpoonslayer69\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/lloyd_pope24\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"bowl","role_str":""},{"pid":93516,"title":"Ethan Bamber","short_name":"ER Bamber","first_name":"Ethan Bamber","last_name":"","middle_name":"","birthdate":"1998-12-17","birthplace":"Westminster, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/etbamber","instagram_profile":"https:\/\/www.instagram.com\/etbamber\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":94952,"title":"Kai Smith","short_name":"K Smith","first_name":"Kai Smith","last_name":"","middle_name":"","birthdate":"2004-11-28","birthplace":" Dubai, United Arab Emirates","country":"ae","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"wk","role_str":""},{"pid":95003,"title":"Robert Yates","short_name":"RM Yates","first_name":"Robert Yates","last_name":"","middle_name":"","birthdate":"1999-09-19","birthplace":"Solihull, Warwickshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95543,"title":"Dan Mousley","short_name":"D Mousley","first_name":"Dan Mousley","last_name":"","middle_name":"","birthdate":"2001-07-08","birthplace":"Birmingham, Warwickshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/danmousley80","instagram_profile":"https:\/\/www.instagram.com\/danmousley80\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":95557,"title":"Dominic Leech","short_name":"D Leech","first_name":"Dominic Leech","last_name":"","middle_name":"","birthdate":"2001-01-10","birthplace":" Middlesbrough, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":102808,"title":"Jake Lintott","short_name":"J Lintott","first_name":"Jake Lintott","last_name":"","middle_name":"","birthdate":"1993-04-22","birthplace":"Taunton, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Wrist Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lintott23","instagram_profile":"https:\/\/www.instagram.com\/lintott23\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":108384,"title":"Justin Broad","short_name":"J Broad","first_name":"Justin Broad","last_name":"","middle_name":"","birthdate":"2000-06-30","birthplace":"Cape Town, South Africa","country":"za","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"all","role_str":""},{"pid":108388,"title":"Jacob Bethell","short_name":"J Bethell","first_name":"Jacob Bethell","last_name":"","middle_name":"","birthdate":"2003-10-23","birthplace":"Barbados","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BethellJacob","instagram_profile":"https:\/\/www.instagram.com\/jacob.bethell\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108389,"title":"Che Simmons","short_name":"C Simmons","first_name":"Che Simmons","last_name":"","middle_name":"","birthdate":"2003-12-18","birthplace":"Birmingham, England","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":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108411,"title":"Gus Miller","short_name":"G Miller","first_name":"Gus Miller","last_name":"","middle_name":"","birthdate":"2002-01-08","birthplace":"Oxford","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108414,"title":"Freddie Heldreich","short_name":"F Heldreich","first_name":"Freddie Heldreich","last_name":"","middle_name":"","birthdate":"2001-09-12","birthplace":"Ipswich, Suffolk","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Wrist Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108418,"title":"James Sales","short_name":"J Sales","first_name":"James Sales","last_name":"","middle_name":"","birthdate":"2003-02-11","birthplace":"Northampton","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":109583,"title":"Hamza Shaikh","short_name":"H Shaikh","first_name":"Hamza Shaikh","last_name":"","middle_name":"","birthdate":"2006-05-29","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":110496,"title":"Tazeem Ali","short_name":"T Ali","first_name":"Tazeem Ali","last_name":"","middle_name":"","birthdate":"2006-06-13","birthplace":"","country":"nl","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"squad","role_str":""},{"pid":118723,"title":"Arush Buchake","short_name":"A Buchake","first_name":"Arush Buchake","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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":118724,"title":"Aadi Sharma","short_name":"A Sharma","first_name":"Aadi Sharma","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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":119917,"title":"Adam Sylvester","short_name":"A Sylvester","first_name":"Adam Sylvester","last_name":"","middle_name":"","birthdate":"2000-05-18","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":130479,"title":"Raphael Weatherall","short_name":"R Weatherall","first_name":"Raphael Weatherall","last_name":"","middle_name":"","birthdate":"2004-10-24","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":148504,"title":"Tiaan Louw","short_name":"T Louw","first_name":"Tiaan Louw","last_name":"","middle_name":"","birthdate":"2006-04-16","birthplace":"","country":"en","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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""}]},"etag":"fcf01398d8850d76703211957e257c94","modified":"2025-07-27 16:35:57","datetime":"2025-07-27 16:35:57","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86858 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:659e4e3f-0a18-49b2-8489-be141613724e
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86858 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86858,3,'{"status":"ok","response":{"match_id":86858,"title":"Northamptonshire vs Warwickshire","short_title":"NOR vs WAS","subtitle":"Match 38","match_number":"38","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Northamptonshire won by 10 runs","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129425,"title":"Vitality Blast","abbr":"Vitality Blast","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-09-13","country":"en","total_matches":"133","total_rounds":"2","total_teams":"18"},"teama":{"team_id":7038,"name":"Northamptonshire","short_name":"NOR","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/northamptonshire-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/northamptonshire-logo.png","scores_full":"184\/6 (20 ov)","scores":"184\/6","overs":"20"},"teamb":{"team_id":7002,"name":"Warwickshire","short_name":"WAS","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Warwickshire.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Warwickshire.png","scores_full":"174\/8 (20 ov)","scores":"174\/8","overs":"20"},"date_start":"2025-06-11 17:30:00","date_end":"2025-06-12 03:30:00","timestamp_start":1749663000,"timestamp_end":1749699000,"date_start_ist":"2025-06-11 23:00:00","date_end_ist":"2025-06-12 09:00:00","venue":{"venue_id":"46","name":"County Ground","location":"Northampton","country":"England","timezone":""},"umpires":"Paul Pollard (England), James Middlebrook (England)","referee":"James Whitaker (England)","equation":"","live":"","result":"NOR won by 10 runs","result_type":1,"win_margin":"10 runs","winning_team_id":7038,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-10 00:31:04","verify_time":"2025-06-12 02:17:40","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"broken clouds","temp":17.19,"humidity":70,"visibility":10000,"wind_speed":"9.60","clouds":82},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Warwickshire elected to bowl","winner":7002,"decision":2}},"etag":"608245a6f1e0b976aa26ad33d71ba251","modified":"2025-07-27 16:35:58","datetime":"2025-07-27 16:35:58","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":86858,"title":"Northamptonshire vs Warwickshire","short_title":"NOR vs WAS","subtitle":"Match 38","match_number":"38","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Northamptonshire won by 10 runs","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129425,"title":"Vitality Blast","abbr":"Vitality Blast","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-09-13","country":"en","total_matches":"133","total_rounds":"2","total_teams":"18"},"teama":{"team_id":7038,"name":"Northamptonshire","short_name":"NOR","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/northamptonshire-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/northamptonshire-logo.png","scores_full":"184\/6 (20 ov)","scores":"184\/6","overs":"20"},"teamb":{"team_id":7002,"name":"Warwickshire","short_name":"WAS","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Warwickshire.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Warwickshire.png","scores_full":"174\/8 (20 ov)","scores":"174\/8","overs":"20"},"date_start":"2025-06-11 17:30:00","date_end":"2025-06-12 03:30:00","timestamp_start":1749663000,"timestamp_end":1749699000,"date_start_ist":"2025-06-11 23:00:00","date_end_ist":"2025-06-12 09:00:00","venue":{"venue_id":"46","name":"County Ground","location":"Northampton","country":"England","timezone":""},"umpires":"Paul Pollard (England), James Middlebrook (England)","referee":"James Whitaker (England)","equation":"","live":"","result":"NOR won by 10 runs","result_type":1,"win_margin":"10 runs","winning_team_id":7038,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-10 00:31:04","verify_time":"2025-06-12 02:17:40","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"broken clouds","temp":17.19,"humidity":70,"visibility":10000,"wind_speed":"9.60","clouds":82},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Warwickshire elected to bowl","winner":7002,"decision":2}},"etag":"608245a6f1e0b976aa26ad33d71ba251","modified":"2025-07-27 16:35:58","datetime":"2025-07-27 16:35:58","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86858 AND DataTypeId = 3 END Live Report & Scorecard of Northamptonshire vs Warwickshire Match 38