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:91b2f18e-9b8f-4e40-8623-dd84e4c180ec
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86848 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86848,1,'{"status":"ok","response":{"mid":86848,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Nottinghamshire won by 7 wickets (DLS method)","day_remaining_over":"","team_batting":"Nottinghamshire","team_bowling":"Derbyshire","live_inning_number":2,"live_score":{"runs":120,"overs":13.5,"wickets":3,"target":120,"runrate":8.57,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Tom Moores","batsman_id":1383,"runs":21,"balls_faced":16,"fours":4,"sixes":0,"strike_rate":"131.25"},{"name":"Freddie McCann","batsman_id":137369,"runs":7,"balls_faced":8,"fours":1,"sixes":0,"strike_rate":"87.50"}],"bowlers":[{"name":"Pat Brown","bowler_id":84689,"overs":2.5,"runs_conceded":27,"wickets":1,"maidens":0,"econ":"9.53"},{"name":"David Lloyd","bowler_id":7735,"overs":2,"runs_conceded":15,"wickets":0,"maidens":0,"econ":"7.50"}],"commentaries":[{"event_id":"12089735","event":"ball","batsman_id":"1383","bowler_id":"84689","over":"9","ball":"5","score":0,"commentary":"Pat Brown to Tom Moores, no run,","noball_dismissal":false,"text":"","timestamp":1749240640,"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":"12089736","event":"ball","batsman_id":"1383","bowler_id":"84689","over":"9","ball":"6","score":1,"commentary":"Pat Brown to Tom Moores, 1 run,","noball_dismissal":false,"text":"","timestamp":1749240642,"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":10,"runs":6,"score":"84\/2","bats":[{"runs":1,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":1383},{"runs":37,"balls_faced":26,"fours":3,"sixes":1,"batsman_id":93953}],"bowls":[{"runs_conceded":20,"maidens":0,"wickets":1,"bowler_id":84689,"overs":2},{"runs_conceded":9,"maidens":0,"wickets":0,"bowler_id":7735,"overs":1}],"commentary":"End of over 10 (6 runs), Nottinghamshire 84\/2"},{"event_id":"12089744","event":"ball","batsman_id":"1383","bowler_id":"118504","over":"10","ball":"1","score":0,"commentary":"Allah Mohammad Ghazanfar to Tom Moores, no run,","noball_dismissal":false,"text":"","timestamp":1749240677,"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":"12089747","event":"ball","batsman_id":"1383","bowler_id":"118504","over":"10","ball":"2","score":4,"commentary":"Allah Mohammad Ghazanfar to Tom Moores, Four,","noball_dismissal":false,"text":"","timestamp":1749240680,"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":"12089762","event":"ball","batsman_id":"1383","bowler_id":"118504","over":"10","ball":"3","score":0,"commentary":"Allah Mohammad Ghazanfar to Tom Moores, no run,","noball_dismissal":false,"text":"","timestamp":1749240781,"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":"12089766","event":"ball","batsman_id":"1383","bowler_id":"118504","over":"10","ball":"4","score":"4nb","commentary":"Allah Mohammad Ghazanfar to Tom Moores, 4 no ball,","noball_dismissal":false,"text":"","timestamp":1749241271,"run":4,"noball_run":"1","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":true,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12089768","event":"ball","batsman_id":"1383","bowler_id":"118504","over":"10","ball":"4","score":4,"commentary":"Allah Mohammad Ghazanfar to Tom Moores, Four,","noball_dismissal":false,"text":"","timestamp":1749240790,"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":"12089773","event":"ball","batsman_id":"1383","bowler_id":"118504","over":"10","ball":"5","score":0,"commentary":"Allah Mohammad Ghazanfar to Tom Moores, no run,","noball_dismissal":false,"text":"","timestamp":1749240799,"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":"12089800","event":"ball","batsman_id":"1383","bowler_id":"118504","over":"10","ball":"6","score":0,"commentary":"Allah Mohammad Ghazanfar to Tom Moores, no run,","noball_dismissal":false,"text":"","timestamp":1749240933,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":11,"runs":12,"score":"96\/2","bats":[{"runs":11,"balls_faced":9,"fours":2,"sixes":0,"batsman_id":1383},{"runs":37,"balls_faced":26,"fours":3,"sixes":1,"batsman_id":93953}],"bowls":[{"runs_conceded":27,"maidens":0,"wickets":0,"bowler_id":118504,"overs":3},{"runs_conceded":20,"maidens":0,"wickets":1,"bowler_id":84689,"overs":2}],"commentary":"End of over 11 (12 runs), Nottinghamshire 96\/2"},{"event_id":"12089808","event":"ball","batsman_id":"93953","bowler_id":"51064","over":"11","ball":"1","score":6,"commentary":"Martin Andersson to Lyndon James, Six,","noball_dismissal":false,"text":"","timestamp":1749240936,"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":"12089811","event":"wicket","batsman_id":"93953","bowler_id":"51064","over":"11","ball":"2","score":"w","commentary":"Martin Andersson to Lyndon James, no run, c WL Madsen b MK Andersson,","noball_dismissal":false,"text":"","timestamp":1749241134,"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":"93953","how_out":"c WL Madsen b MK Andersson","batsman_runs":"43","batsman_balls":"28"},{"event_id":"12089859","event":"ball","batsman_id":"137369","bowler_id":"51064","over":"11","ball":"3","score":1,"commentary":"Martin Andersson to Freddie McCann, 1 run,","noball_dismissal":false,"text":"","timestamp":1749241156,"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":"12089860","event":"ball","batsman_id":"1383","bowler_id":"51064","over":"11","ball":"4","score":4,"commentary":"Martin Andersson to Tom Moores, Four,","noball_dismissal":false,"text":"","timestamp":1749241158,"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":"12089862","event":"ball","batsman_id":"1383","bowler_id":"51064","over":"11","ball":"5","score":0,"commentary":"Martin Andersson to Tom Moores, no run,","noball_dismissal":false,"text":"","timestamp":1749241161,"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":"12089864","event":"ball","batsman_id":"1383","bowler_id":"51064","over":"11","ball":"6","score":0,"commentary":"Martin Andersson to Tom Moores, no run,","noball_dismissal":false,"text":"","timestamp":1749241163,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":12,"runs":11,"score":"107\/3","bats":[{"runs":15,"balls_faced":12,"fours":3,"sixes":0,"batsman_id":1383},{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":137369}],"bowls":[{"runs_conceded":25,"maidens":0,"wickets":1,"bowler_id":51064,"overs":3},{"runs_conceded":27,"maidens":0,"wickets":0,"bowler_id":118504,"overs":3}],"commentary":"End of over 12 (11 runs), Nottinghamshire 107\/3"},{"event_id":"12089919","event":"ball","batsman_id":"137369","bowler_id":"7735","over":"12","ball":"1","score":0,"commentary":"David Lloyd to Freddie McCann, no run,","noball_dismissal":false,"text":"","timestamp":1749241432,"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":"12089920","event":"ball","batsman_id":"137369","bowler_id":"7735","over":"12","ball":"2","score":0,"commentary":"David Lloyd to Freddie McCann, no run,","noball_dismissal":false,"text":"","timestamp":1749241434,"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":"12089922","event":"ball","batsman_id":"137369","bowler_id":"7735","over":"12","ball":"3","score":1,"commentary":"David Lloyd to Freddie McCann, 1 run,","noball_dismissal":false,"text":"","timestamp":1749241437,"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":"12090163","event":"ball","batsman_id":"1383","bowler_id":"7735","over":"12","ball":"4","score":0,"commentary":"David Lloyd to Tom Moores, no run,","noball_dismissal":false,"text":"","timestamp":1749244569,"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":"12090164","event":"ball","batsman_id":"1383","bowler_id":"7735","over":"12","ball":"5","score":1,"commentary":"David Lloyd to Tom Moores, 1 run,","noball_dismissal":false,"text":"","timestamp":1749244583,"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":"12090165","event":"ball","batsman_id":"137369","bowler_id":"7735","over":"12","ball":"6","score":4,"commentary":"David Lloyd to Freddie McCann, Four,","noball_dismissal":false,"text":"","timestamp":1749244585,"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":13,"runs":6,"score":"113\/3","bats":[{"runs":6,"balls_faced":5,"fours":1,"sixes":0,"batsman_id":137369},{"runs":16,"balls_faced":14,"fours":3,"sixes":0,"batsman_id":1383}],"bowls":[{"runs_conceded":15,"maidens":0,"wickets":0,"bowler_id":7735,"overs":2},{"runs_conceded":25,"maidens":0,"wickets":1,"bowler_id":51064,"overs":3}],"commentary":"End of over 13 (6 runs), Nottinghamshire 113\/3"},{"event_id":"12090166","event":"ball","batsman_id":"1383","bowler_id":"84689","over":"13","ball":"1","score":1,"commentary":"Pat Brown to Tom Moores, 1 run,","noball_dismissal":false,"text":"","timestamp":1749244594,"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":"12090167","event":"ball","batsman_id":"137369","bowler_id":"84689","over":"13","ball":"2","score":0,"commentary":"Pat Brown to Freddie McCann, no run,","noball_dismissal":false,"text":"","timestamp":1749244596,"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":"12090168","event":"ball","batsman_id":"137369","bowler_id":"84689","over":"13","ball":"3","score":0,"commentary":"Pat Brown to Freddie McCann, no run,","noball_dismissal":false,"text":"","timestamp":1749244599,"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":"12090169","event":"ball","batsman_id":"137369","bowler_id":"84689","over":"13","ball":"4","score":1,"commentary":"Pat Brown to Freddie McCann, 1 run,","noball_dismissal":false,"text":"","timestamp":1749244604,"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":"12090170","event":"ball","batsman_id":"1383","bowler_id":"84689","over":"13","ball":"5","score":4,"commentary":"Pat Brown to Tom Moores, Four,","noball_dismissal":false,"text":"","timestamp":1749244616,"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":"12090171","event":"ball","batsman_id":"1383","bowler_id":"84689","over":"13","ball":"6","score":"1wd","commentary":"Pat Brown to Tom Moores, 1 wide,","noball_dismissal":false,"text":"","timestamp":1749244640,"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}],"day":"0","session":"0","live_inning":{"iid":197569,"number":2,"name":"Nottinghamshire Inning","short_name":"NOT Inning","status":2,"issuperover":"false","result":3,"batting_team_id":6035,"fielding_team_id":104949,"scores":"120\/3","scores_full":"120\/3 (13.5 ov)","fielder":[{"fielder_id":"48641","fielder_name":"Wayne Madsen","catches":3,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Lyndon James","batsman_id":"93953","runs":"43","balls":"28","how_out":"c WL Madsen b MK Andersson","score_at_dismissal":102,"overs_at_dismissal":"11.2","bowler_id":"51064","dismissal":"caught","number":3},"extra_runs":{"byes":0,"legbyes":0,"wides":3,"noballs":2,"penalty":"0","total":5},"equations":{"runs":120,"wickets":3,"overs":"13.5","bowlers_used":6,"runrate":"8.57"},"current_partnership":{"runs":18,"balls":15,"overs":2.3,"batsmen":[{"name":"Freddie McCann","batsman_id":137369,"runs":7,"balls":8},{"name":"Tom Moores","batsman_id":1383,"runs":10,"balls":7}]},"did_not_bat":[{"player_id":"60432","name":"Matthew Montgomery"},{"player_id":"93372","name":"Daniel Sams"},{"player_id":"50422","name":"Calvin Harrison"},{"player_id":"94986","name":"Liam Patterson-White"},{"player_id":"1401","name":"Conor McKerr"},{"player_id":"93521","name":"Dillon Pennington"}],"max_over":"15","target":"120","recent_scores":"1,4,1,0,0,1,4,1,0,1,0,0,0,0,4,1,w,6","last_five_overs":"42\/2 8.13","last_ten_overs":"85\/2 8.36"},"teams":[{"tid":6035,"title":"Nottinghamshire","abbr":"NOT","alt_name":"NOT","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/nottinghamshire-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/nottinghamshire-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"120\/3 (13.5 ov)","scores":"120\/3","overs":"13.5"},{"tid":104949,"title":"Derbyshire","abbr":"DER","alt_name":"DER","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/derbyshire-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/derbyshire-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"162\/9 (20 ov)","scores":"162\/9","overs":"20"}],"players":[{"pid":748,"title":"Moises Henriques","short_name":"M Henriques","first_name":"Moises Henriques","last_name":"","middle_name":"","birthdate":"1987-02-01","birthplace":"Funchal, Portugal","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/mozzie21\/","twitter_profile":"https:\/\/twitter.com\/mozzie21?lang=en","instagram_profile":"https:\/\/www.instagram.com\/mozzie21\/?hl=en","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":1259,"title":"Aneurin Donald","short_name":"A Donald","first_name":"Aneurin Donald","last_name":"","middle_name":"","birthdate":"1996-12-20","birthplace":"Swansea, Glamorgan","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","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":"https:\/\/www.facebook.com\/aneurin.donald\/","twitter_profile":"https:\/\/twitter.com\/AneurinDonald12","instagram_profile":"https:\/\/www.instagram.com\/aneurindonald\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":""},{"pid":1383,"title":"Tom Moores","short_name":"T Moores","first_name":"Tom Moores","last_name":"","middle_name":"","birthdate":"1996-09-04","birthplace":"Brighton, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"Wicketkeeper ","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/tommoores23\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":1401,"title":"Conor McKerr","short_name":"C McKerr","first_name":"Conor McKerr","last_name":"","middle_name":"","birthdate":"1998-01-19","birthplace":"Johannesburg, South Africa","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/conormckerr3\/","twitter_profile":"https:\/\/twitter.com\/mckerr83","instagram_profile":"https:\/\/www.instagram.com\/conor_mckerr\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bowl","role_str":""},{"pid":7735,"title":"David Lloyd","short_name":"DL Lloyd","first_name":"David Lloyd","last_name":"","middle_name":"","birthdate":"1992-06-15","birthplace":"St Asaph, Flintshire, Wales","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/davidlloyduk\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":10594,"title":"Samit Patel","short_name":"SR Patel","first_name":"Samit Patel","last_name":"","middle_name":"","birthdate":"1984-11-30","birthplace":"Leicester","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/samitpatel","instagram_profile":"https:\/\/www.instagram.com\/samit._.patel\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":"(C)"},{"pid":43360,"title":"Ross Whiteley","short_name":"RA Whiteley","first_name":"Ross Whiteley","last_name":"","middle_name":"","birthdate":"1988-09-13","birthplace":"Sheffield, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/RossWhiteley44","instagram_profile":"https:\/\/www.instagram.com\/rosswhiteley44\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":43362,"title":"Joe Clarke","short_name":"JM Clarke","first_name":"Joe Clarke","last_name":"","middle_name":"","birthdate":"1996-05-26","birthplace":"Shrewsbury, Shropshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/C1arke28","instagram_profile":"https:\/\/www.instagram.com\/realdealjoe11\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(C)"},{"pid":45654,"title":"Dane Schadendorf","short_name":"D Schadendorf","first_name":"Dane Schadendorf","last_name":"","middle_name":"","birthdate":"2002-07-31","birthplace":"Harare, Zimbabwe","country":"zw","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Zimbabwe","role":"squad","role_str":""},{"pid":46310,"title":"Blair Tickner","short_name":"BM Tickner","first_name":"Blair Tickner","last_name":"","middle_name":"","birthdate":"1993-10-13","birthplace":"Napier, Hawke''s Bay","country":"nz","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/blair.tickner\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/ticks93\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"squad","role_str":""},{"pid":48428,"title":"Luis Reece","short_name":"LM Reece","first_name":"Luis Reece","last_name":"","middle_name":"","birthdate":"1990-08-04","birthplace":"Taunton, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lreece17","instagram_profile":"https:\/\/www.instagram.com\/louisreece\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":48488,"title":"Haseeb Hameed","short_name":"H Hameed","first_name":"Haseeb Hameed","last_name":"","middle_name":"","birthdate":"1997-01-17","birthplace":"Bolton, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":48498,"title":"Caleb Jewell","short_name":"CP Jewell","first_name":"Caleb Jewell","last_name":"","middle_name":"","birthdate":"1997-04-21","birthplace":"Hobart, Tasmania","country":"au","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,"facebook_profile":"https:\/\/www.facebook.com\/caleb.jewell.148\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/cjewell_32\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"bat","role_str":""},{"pid":48508,"title":"Brooke Guest","short_name":"BD Guest","first_name":"Brooke Guest","last_name":"","middle_name":"","birthdate":"1997-05-14","birthplace":"Whitworth Park, Manchester, England","country":"au","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/guesty211\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"wk","role_str":"(WK)"},{"pid":48635,"title":"Ben Slater","short_name":"BT Slater","first_name":"Ben Slater","last_name":"","middle_name":"","birthdate":"1991-08-26","birthplace":" Chesterfield, Derbyshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":48641,"title":"Wayne Madsen","short_name":"WL Madsen","first_name":"Wayne Madsen","last_name":"","middle_name":"","birthdate":"1984-01-02","birthplace":"Durban","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/waynemadders77","instagram_profile":"https:\/\/www.instagram.com\/waynemadsen77\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":48666,"title":"Josh Tongue","short_name":"JC Tongue","first_name":"Josh Tongue","last_name":"","middle_name":"","birthdate":"1997-11-15","birthplace":"Redditch, United Kingdom","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":"","instagram_profile":"https:\/\/www.instagram.com\/josh.tongue123\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49378,"title":"Ben Duckett","short_name":"BM Duckett","first_name":"Ben Duckett","last_name":"","middle_name":"","birthdate":"1994-10-17","birthplace":"Farnborough, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/benduckett17\/","twitter_profile":"https:\/\/twitter.com\/BenDuckett1","instagram_profile":"https:\/\/www.instagram.com\/benduckett1\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49382,"title":"Olly Stone","short_name":"OP Stone","first_name":"Olly Stone","last_name":"","middle_name":"","birthdate":"1993-10-09","birthplace":"Norwich, Norfolk","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/ollystone2","instagram_profile":"https:\/\/www.instagram.com\/ollystone93\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49793,"title":"Brett Hutton","short_name":"BA Hutton","first_name":"Brett Hutton","last_name":"","middle_name":"","birthdate":"1993-02-06","birthplace":" Doncaster, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49808,"title":"Zak Chappell","short_name":"ZJ Chappell","first_name":"Zak Chappell","last_name":"","middle_name":"","birthdate":"1996-08-21","birthplace":"Grantham, Lincolnshire","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":"","instagram_profile":"https:\/\/www.instagram.com\/chappooo","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50422,"title":"Calvin Harrison","short_name":"Calvin Harrison","first_name":"Calvin Harrison","last_name":"","middle_name":"","birthdate":"1998-04-29","birthplace":" Durban, KwaZulu-Natal","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/calvinh_98","instagram_profile":"https:\/\/www.instagram.com\/calvin_harrison_\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":50433,"title":"Alex Thomson","short_name":"AT Thomson","first_name":"Alex Thomson","last_name":"","middle_name":"","birthdate":"1993-10-30","birthplace":"Stoke-on-Trent, Staffordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/alextomo","instagram_profile":"https:\/\/www.instagram.com\/alex_thomson_racing\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50528,"title":"Anuj Dal","short_name":"AK Dal","first_name":"Anuj Dal","last_name":"","middle_name":"","birthdate":"1996-07-08","birthplace":"Newcastle-under-Lyme, Staffordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/AnujDal","instagram_profile":"https:\/\/www.instagram.com\/anujdal0\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51064,"title":"Martin Andersson","short_name":"MK Andersson","first_name":"Martin Andersson","last_name":"","middle_name":"","birthdate":"1996-09-06","birthplace":"Reading, Berkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/MartinAnderss11","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":60432,"title":"Matthew Montgomery","short_name":"M Montgomery","first_name":"Matthew Montgomery","last_name":"","middle_name":"","birthdate":"2000-05-10","birthplace":"Johannesburg","country":"de","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"bowl","role_str":""},{"pid":84689,"title":"Pat Brown","short_name":"PR Brown","first_name":"Pat Brown","last_name":"","middle_name":"","birthdate":"1998-08-23","birthplace":"Peterborough, Cambridgeshire","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":"","instagram_profile":"https:\/\/www.instagram.com\/patbrowny\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":93372,"title":"Daniel Sams","short_name":"DR Sams","first_name":"Daniel Sams","last_name":"","middle_name":"","birthdate":"1992-10-27","birthplace":" Milperra, New South Wales","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/dansams\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"all","role_str":""},{"pid":93521,"title":"Dillon Pennington","short_name":"D Pennington","first_name":"Dillon Pennington","last_name":"","middle_name":"","birthdate":"1999-02-26","birthplace":"Shrewsbury, Shropshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/DillonPenningt4","instagram_profile":"https:\/\/www.instagram.com\/dillonp___\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":93953,"title":"Lyndon James","short_name":"LW James","first_name":"Lyndon James","last_name":"","middle_name":"","birthdate":"1997-12-27","birthplace":" Worksop","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":94962,"title":"Harry Came","short_name":"H Came","first_name":"Harry Came","last_name":"","middle_name":"","birthdate":"1998-08-27","birthplace":"Hampshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/HarryCame4","instagram_profile":"https:\/\/www.instagram.com\/harrycame4\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":94963,"title":"Jack Morley","short_name":"J Morley","first_name":"Jack Morley","last_name":"","middle_name":"","birthdate":"2001-06-25","birthplace":"Rochdale, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":94965,"title":"Jack Haynes","short_name":"J Haynes","first_name":"Jack Haynes","last_name":"","middle_name":"","birthdate":"2001-01-30","birthplace":"Worcester","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/jack_haynes1","instagram_profile":"https:\/\/www.instagram.com\/jack.hayness\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":94986,"title":"Liam Patterson-White","short_name":"LP White","first_name":"Liam Patterson-White","last_name":"","middle_name":"","birthdate":"1998-11-08","birthplace":"Sunderland, Co Durham","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":101484,"title":"Ben William Aitchison","short_name":"B W Aitchison","first_name":"Ben William Aitchison","last_name":"","middle_name":"","birthdate":"1999-07-06","birthplace":"Southport, 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":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Benaitchison123","instagram_profile":"https:\/\/www.instagram.com\/baitchison13\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":108415,"title":"Sam King","short_name":"S King","first_name":"Sam King","last_name":"","middle_name":"","birthdate":"2003-01-12","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108416,"title":"Benjamin Martindale","short_name":"B Martindale","first_name":"Benjamin Martindale","last_name":"","middle_name":"","birthdate":"2002-12-12","birthplace":"Nottingham","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108441,"title":"Robert Lord","short_name":"R Lord","first_name":"Robert Lord","last_name":"","middle_name":"","birthdate":"2001-05-04","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108586,"title":"Nick Potts","short_name":"N Potts","first_name":"Nick Potts","last_name":"","middle_name":"","birthdate":"2002-07-17","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":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/nickwpotts\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":109363,"title":"Mitchell Wagstaff","short_name":"M Wagstaff","first_name":"Mitchell Wagstaff","last_name":"","middle_name":"","birthdate":"2003-09-02","birthplace":"Derby","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/mitchellwaggy?lang=en","instagram_profile":"https:\/\/www.instagram.com\/mitchellwagstaff\/?hl=en","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":109543,"title":"James Hayes","short_name":"JPH Hayes","first_name":"James Hayes","last_name":"","middle_name":"","birthdate":"2001-06-27","birthplace":"Haywards Heath, Sussex","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":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":118504,"title":"Allah Mohammad Ghazanfar","short_name":"AM Ghazanfar","first_name":"Allah Mohammad Ghazanfar","last_name":"","middle_name":"","birthdate":"2007-07-15","birthplace":"","country":"af","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":7.5,"facebook_profile":"https:\/\/www.facebook.com\/Ghazanfar050\/","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Afghanistan","role":"bowl","role_str":""},{"pid":130162,"title":"Harry Moore","short_name":"HJ Moore","first_name":"Harry Moore","last_name":"","middle_name":"","birthdate":"2007-04-26","birthplace":"Houston, Florida","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":"https:\/\/twitter.com\/ha66y2004","instagram_profile":"https:\/\/www.instagram.com\/harrymoore72\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":130480,"title":"Tom Giles","short_name":"T Giles","first_name":"Tom Giles","last_name":"","middle_name":"","birthdate":"2006-05-17","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":130481,"title":"Travis Holland","short_name":"T Holland","first_name":"Travis Holland","last_name":"","middle_name":"","birthdate":"2006-01-21","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":131217,"title":"Farhan Ahmed","short_name":"F Ahmed","first_name":"Farhan Ahmed","last_name":"","middle_name":"","birthdate":"2008-02-22","birthplace":"Nottingham","country":"en","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":137369,"title":"Freddie McCann","short_name":"F McCann","first_name":"Freddie McCann","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":141343,"title":"Yousaf Bin Naeem","short_name":"YB Naeem","first_name":"Yousaf Bin Naeem","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":149077,"title":"Sam Seecharan","short_name":"Sam Seecharan","first_name":"Sam Seecharan","last_name":"","middle_name":"","birthdate":"2006-08-16","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":149078,"title":"Francis Moore","short_name":"F Moore","first_name":"Francis Moore","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""}]},"etag":"49d715ab4907988f637599f8b078a8fd","modified":"2025-08-01 08:54:56","datetime":"2025-08-01 08:54:56","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":86848,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Nottinghamshire won by 7 wickets (DLS method)","day_remaining_over":"","team_batting":"Nottinghamshire","team_bowling":"Derbyshire","live_inning_number":2,"live_score":{"runs":120,"overs":13.5,"wickets":3,"target":120,"runrate":8.57,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Tom Moores","batsman_id":1383,"runs":21,"balls_faced":16,"fours":4,"sixes":0,"strike_rate":"131.25"},{"name":"Freddie McCann","batsman_id":137369,"runs":7,"balls_faced":8,"fours":1,"sixes":0,"strike_rate":"87.50"}],"bowlers":[{"name":"Pat Brown","bowler_id":84689,"overs":2.5,"runs_conceded":27,"wickets":1,"maidens":0,"econ":"9.53"},{"name":"David Lloyd","bowler_id":7735,"overs":2,"runs_conceded":15,"wickets":0,"maidens":0,"econ":"7.50"}],"commentaries":[{"event_id":"12089735","event":"ball","batsman_id":"1383","bowler_id":"84689","over":"9","ball":"5","score":0,"commentary":"Pat Brown to Tom Moores, no run,","noball_dismissal":false,"text":"","timestamp":1749240640,"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":"12089736","event":"ball","batsman_id":"1383","bowler_id":"84689","over":"9","ball":"6","score":1,"commentary":"Pat Brown to Tom Moores, 1 run,","noball_dismissal":false,"text":"","timestamp":1749240642,"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":10,"runs":6,"score":"84\/2","bats":[{"runs":1,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":1383},{"runs":37,"balls_faced":26,"fours":3,"sixes":1,"batsman_id":93953}],"bowls":[{"runs_conceded":20,"maidens":0,"wickets":1,"bowler_id":84689,"overs":2},{"runs_conceded":9,"maidens":0,"wickets":0,"bowler_id":7735,"overs":1}],"commentary":"End of over 10 (6 runs), Nottinghamshire 84\/2"},{"event_id":"12089744","event":"ball","batsman_id":"1383","bowler_id":"118504","over":"10","ball":"1","score":0,"commentary":"Allah Mohammad Ghazanfar to Tom Moores, no run,","noball_dismissal":false,"text":"","timestamp":1749240677,"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":"12089747","event":"ball","batsman_id":"1383","bowler_id":"118504","over":"10","ball":"2","score":4,"commentary":"Allah Mohammad Ghazanfar to Tom Moores, Four,","noball_dismissal":false,"text":"","timestamp":1749240680,"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":"12089762","event":"ball","batsman_id":"1383","bowler_id":"118504","over":"10","ball":"3","score":0,"commentary":"Allah Mohammad Ghazanfar to Tom Moores, no run,","noball_dismissal":false,"text":"","timestamp":1749240781,"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":"12089766","event":"ball","batsman_id":"1383","bowler_id":"118504","over":"10","ball":"4","score":"4nb","commentary":"Allah Mohammad Ghazanfar to Tom Moores, 4 no ball,","noball_dismissal":false,"text":"","timestamp":1749241271,"run":4,"noball_run":"1","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":true,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12089768","event":"ball","batsman_id":"1383","bowler_id":"118504","over":"10","ball":"4","score":4,"commentary":"Allah Mohammad Ghazanfar to Tom Moores, Four,","noball_dismissal":false,"text":"","timestamp":1749240790,"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":"12089773","event":"ball","batsman_id":"1383","bowler_id":"118504","over":"10","ball":"5","score":0,"commentary":"Allah Mohammad Ghazanfar to Tom Moores, no run,","noball_dismissal":false,"text":"","timestamp":1749240799,"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":"12089800","event":"ball","batsman_id":"1383","bowler_id":"118504","over":"10","ball":"6","score":0,"commentary":"Allah Mohammad Ghazanfar to Tom Moores, no run,","noball_dismissal":false,"text":"","timestamp":1749240933,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":11,"runs":12,"score":"96\/2","bats":[{"runs":11,"balls_faced":9,"fours":2,"sixes":0,"batsman_id":1383},{"runs":37,"balls_faced":26,"fours":3,"sixes":1,"batsman_id":93953}],"bowls":[{"runs_conceded":27,"maidens":0,"wickets":0,"bowler_id":118504,"overs":3},{"runs_conceded":20,"maidens":0,"wickets":1,"bowler_id":84689,"overs":2}],"commentary":"End of over 11 (12 runs), Nottinghamshire 96\/2"},{"event_id":"12089808","event":"ball","batsman_id":"93953","bowler_id":"51064","over":"11","ball":"1","score":6,"commentary":"Martin Andersson to Lyndon James, Six,","noball_dismissal":false,"text":"","timestamp":1749240936,"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":"12089811","event":"wicket","batsman_id":"93953","bowler_id":"51064","over":"11","ball":"2","score":"w","commentary":"Martin Andersson to Lyndon James, no run, c WL Madsen b MK Andersson,","noball_dismissal":false,"text":"","timestamp":1749241134,"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":"93953","how_out":"c WL Madsen b MK Andersson","batsman_runs":"43","batsman_balls":"28"},{"event_id":"12089859","event":"ball","batsman_id":"137369","bowler_id":"51064","over":"11","ball":"3","score":1,"commentary":"Martin Andersson to Freddie McCann, 1 run,","noball_dismissal":false,"text":"","timestamp":1749241156,"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":"12089860","event":"ball","batsman_id":"1383","bowler_id":"51064","over":"11","ball":"4","score":4,"commentary":"Martin Andersson to Tom Moores, Four,","noball_dismissal":false,"text":"","timestamp":1749241158,"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":"12089862","event":"ball","batsman_id":"1383","bowler_id":"51064","over":"11","ball":"5","score":0,"commentary":"Martin Andersson to Tom Moores, no run,","noball_dismissal":false,"text":"","timestamp":1749241161,"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":"12089864","event":"ball","batsman_id":"1383","bowler_id":"51064","over":"11","ball":"6","score":0,"commentary":"Martin Andersson to Tom Moores, no run,","noball_dismissal":false,"text":"","timestamp":1749241163,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":12,"runs":11,"score":"107\/3","bats":[{"runs":15,"balls_faced":12,"fours":3,"sixes":0,"batsman_id":1383},{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":137369}],"bowls":[{"runs_conceded":25,"maidens":0,"wickets":1,"bowler_id":51064,"overs":3},{"runs_conceded":27,"maidens":0,"wickets":0,"bowler_id":118504,"overs":3}],"commentary":"End of over 12 (11 runs), Nottinghamshire 107\/3"},{"event_id":"12089919","event":"ball","batsman_id":"137369","bowler_id":"7735","over":"12","ball":"1","score":0,"commentary":"David Lloyd to Freddie McCann, no run,","noball_dismissal":false,"text":"","timestamp":1749241432,"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":"12089920","event":"ball","batsman_id":"137369","bowler_id":"7735","over":"12","ball":"2","score":0,"commentary":"David Lloyd to Freddie McCann, no run,","noball_dismissal":false,"text":"","timestamp":1749241434,"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":"12089922","event":"ball","batsman_id":"137369","bowler_id":"7735","over":"12","ball":"3","score":1,"commentary":"David Lloyd to Freddie McCann, 1 run,","noball_dismissal":false,"text":"","timestamp":1749241437,"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":"12090163","event":"ball","batsman_id":"1383","bowler_id":"7735","over":"12","ball":"4","score":0,"commentary":"David Lloyd to Tom Moores, no run,","noball_dismissal":false,"text":"","timestamp":1749244569,"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":"12090164","event":"ball","batsman_id":"1383","bowler_id":"7735","over":"12","ball":"5","score":1,"commentary":"David Lloyd to Tom Moores, 1 run,","noball_dismissal":false,"text":"","timestamp":1749244583,"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":"12090165","event":"ball","batsman_id":"137369","bowler_id":"7735","over":"12","ball":"6","score":4,"commentary":"David Lloyd to Freddie McCann, Four,","noball_dismissal":false,"text":"","timestamp":1749244585,"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":13,"runs":6,"score":"113\/3","bats":[{"runs":6,"balls_faced":5,"fours":1,"sixes":0,"batsman_id":137369},{"runs":16,"balls_faced":14,"fours":3,"sixes":0,"batsman_id":1383}],"bowls":[{"runs_conceded":15,"maidens":0,"wickets":0,"bowler_id":7735,"overs":2},{"runs_conceded":25,"maidens":0,"wickets":1,"bowler_id":51064,"overs":3}],"commentary":"End of over 13 (6 runs), Nottinghamshire 113\/3"},{"event_id":"12090166","event":"ball","batsman_id":"1383","bowler_id":"84689","over":"13","ball":"1","score":1,"commentary":"Pat Brown to Tom Moores, 1 run,","noball_dismissal":false,"text":"","timestamp":1749244594,"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":"12090167","event":"ball","batsman_id":"137369","bowler_id":"84689","over":"13","ball":"2","score":0,"commentary":"Pat Brown to Freddie McCann, no run,","noball_dismissal":false,"text":"","timestamp":1749244596,"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":"12090168","event":"ball","batsman_id":"137369","bowler_id":"84689","over":"13","ball":"3","score":0,"commentary":"Pat Brown to Freddie McCann, no run,","noball_dismissal":false,"text":"","timestamp":1749244599,"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":"12090169","event":"ball","batsman_id":"137369","bowler_id":"84689","over":"13","ball":"4","score":1,"commentary":"Pat Brown to Freddie McCann, 1 run,","noball_dismissal":false,"text":"","timestamp":1749244604,"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":"12090170","event":"ball","batsman_id":"1383","bowler_id":"84689","over":"13","ball":"5","score":4,"commentary":"Pat Brown to Tom Moores, Four,","noball_dismissal":false,"text":"","timestamp":1749244616,"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":"12090171","event":"ball","batsman_id":"1383","bowler_id":"84689","over":"13","ball":"6","score":"1wd","commentary":"Pat Brown to Tom Moores, 1 wide,","noball_dismissal":false,"text":"","timestamp":1749244640,"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}],"day":"0","session":"0","live_inning":{"iid":197569,"number":2,"name":"Nottinghamshire Inning","short_name":"NOT Inning","status":2,"issuperover":"false","result":3,"batting_team_id":6035,"fielding_team_id":104949,"scores":"120\/3","scores_full":"120\/3 (13.5 ov)","fielder":[{"fielder_id":"48641","fielder_name":"Wayne Madsen","catches":3,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Lyndon James","batsman_id":"93953","runs":"43","balls":"28","how_out":"c WL Madsen b MK Andersson","score_at_dismissal":102,"overs_at_dismissal":"11.2","bowler_id":"51064","dismissal":"caught","number":3},"extra_runs":{"byes":0,"legbyes":0,"wides":3,"noballs":2,"penalty":"0","total":5},"equations":{"runs":120,"wickets":3,"overs":"13.5","bowlers_used":6,"runrate":"8.57"},"current_partnership":{"runs":18,"balls":15,"overs":2.3,"batsmen":[{"name":"Freddie McCann","batsman_id":137369,"runs":7,"balls":8},{"name":"Tom Moores","batsman_id":1383,"runs":10,"balls":7}]},"did_not_bat":[{"player_id":"60432","name":"Matthew Montgomery"},{"player_id":"93372","name":"Daniel Sams"},{"player_id":"50422","name":"Calvin Harrison"},{"player_id":"94986","name":"Liam Patterson-White"},{"player_id":"1401","name":"Conor McKerr"},{"player_id":"93521","name":"Dillon Pennington"}],"max_over":"15","target":"120","recent_scores":"1,4,1,0,0,1,4,1,0,1,0,0,0,0,4,1,w,6","last_five_overs":"42\/2 8.13","last_ten_overs":"85\/2 8.36"},"teams":[{"tid":6035,"title":"Nottinghamshire","abbr":"NOT","alt_name":"NOT","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/nottinghamshire-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/nottinghamshire-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"120\/3 (13.5 ov)","scores":"120\/3","overs":"13.5"},{"tid":104949,"title":"Derbyshire","abbr":"DER","alt_name":"DER","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/derbyshire-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/derbyshire-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"162\/9 (20 ov)","scores":"162\/9","overs":"20"}],"players":[{"pid":748,"title":"Moises Henriques","short_name":"M Henriques","first_name":"Moises Henriques","last_name":"","middle_name":"","birthdate":"1987-02-01","birthplace":"Funchal, Portugal","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/mozzie21\/","twitter_profile":"https:\/\/twitter.com\/mozzie21?lang=en","instagram_profile":"https:\/\/www.instagram.com\/mozzie21\/?hl=en","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":1259,"title":"Aneurin Donald","short_name":"A Donald","first_name":"Aneurin Donald","last_name":"","middle_name":"","birthdate":"1996-12-20","birthplace":"Swansea, Glamorgan","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","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":"https:\/\/www.facebook.com\/aneurin.donald\/","twitter_profile":"https:\/\/twitter.com\/AneurinDonald12","instagram_profile":"https:\/\/www.instagram.com\/aneurindonald\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":""},{"pid":1383,"title":"Tom Moores","short_name":"T Moores","first_name":"Tom Moores","last_name":"","middle_name":"","birthdate":"1996-09-04","birthplace":"Brighton, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"Wicketkeeper ","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/tommoores23\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":1401,"title":"Conor McKerr","short_name":"C McKerr","first_name":"Conor McKerr","last_name":"","middle_name":"","birthdate":"1998-01-19","birthplace":"Johannesburg, South Africa","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/conormckerr3\/","twitter_profile":"https:\/\/twitter.com\/mckerr83","instagram_profile":"https:\/\/www.instagram.com\/conor_mckerr\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bowl","role_str":""},{"pid":7735,"title":"David Lloyd","short_name":"DL Lloyd","first_name":"David Lloyd","last_name":"","middle_name":"","birthdate":"1992-06-15","birthplace":"St Asaph, Flintshire, Wales","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/davidlloyduk\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":10594,"title":"Samit Patel","short_name":"SR Patel","first_name":"Samit Patel","last_name":"","middle_name":"","birthdate":"1984-11-30","birthplace":"Leicester","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/samitpatel","instagram_profile":"https:\/\/www.instagram.com\/samit._.patel\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":"(C)"},{"pid":43360,"title":"Ross Whiteley","short_name":"RA Whiteley","first_name":"Ross Whiteley","last_name":"","middle_name":"","birthdate":"1988-09-13","birthplace":"Sheffield, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/RossWhiteley44","instagram_profile":"https:\/\/www.instagram.com\/rosswhiteley44\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":43362,"title":"Joe Clarke","short_name":"JM Clarke","first_name":"Joe Clarke","last_name":"","middle_name":"","birthdate":"1996-05-26","birthplace":"Shrewsbury, Shropshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/C1arke28","instagram_profile":"https:\/\/www.instagram.com\/realdealjoe11\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(C)"},{"pid":45654,"title":"Dane Schadendorf","short_name":"D Schadendorf","first_name":"Dane Schadendorf","last_name":"","middle_name":"","birthdate":"2002-07-31","birthplace":"Harare, Zimbabwe","country":"zw","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Zimbabwe","role":"squad","role_str":""},{"pid":46310,"title":"Blair Tickner","short_name":"BM Tickner","first_name":"Blair Tickner","last_name":"","middle_name":"","birthdate":"1993-10-13","birthplace":"Napier, Hawke''s Bay","country":"nz","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/blair.tickner\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/ticks93\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"squad","role_str":""},{"pid":48428,"title":"Luis Reece","short_name":"LM Reece","first_name":"Luis Reece","last_name":"","middle_name":"","birthdate":"1990-08-04","birthplace":"Taunton, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lreece17","instagram_profile":"https:\/\/www.instagram.com\/louisreece\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":48488,"title":"Haseeb Hameed","short_name":"H Hameed","first_name":"Haseeb Hameed","last_name":"","middle_name":"","birthdate":"1997-01-17","birthplace":"Bolton, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":48498,"title":"Caleb Jewell","short_name":"CP Jewell","first_name":"Caleb Jewell","last_name":"","middle_name":"","birthdate":"1997-04-21","birthplace":"Hobart, Tasmania","country":"au","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,"facebook_profile":"https:\/\/www.facebook.com\/caleb.jewell.148\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/cjewell_32\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"bat","role_str":""},{"pid":48508,"title":"Brooke Guest","short_name":"BD Guest","first_name":"Brooke Guest","last_name":"","middle_name":"","birthdate":"1997-05-14","birthplace":"Whitworth Park, Manchester, England","country":"au","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/guesty211\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"wk","role_str":"(WK)"},{"pid":48635,"title":"Ben Slater","short_name":"BT Slater","first_name":"Ben Slater","last_name":"","middle_name":"","birthdate":"1991-08-26","birthplace":" Chesterfield, Derbyshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":48641,"title":"Wayne Madsen","short_name":"WL Madsen","first_name":"Wayne Madsen","last_name":"","middle_name":"","birthdate":"1984-01-02","birthplace":"Durban","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/waynemadders77","instagram_profile":"https:\/\/www.instagram.com\/waynemadsen77\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":48666,"title":"Josh Tongue","short_name":"JC Tongue","first_name":"Josh Tongue","last_name":"","middle_name":"","birthdate":"1997-11-15","birthplace":"Redditch, United Kingdom","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":"","instagram_profile":"https:\/\/www.instagram.com\/josh.tongue123\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49378,"title":"Ben Duckett","short_name":"BM Duckett","first_name":"Ben Duckett","last_name":"","middle_name":"","birthdate":"1994-10-17","birthplace":"Farnborough, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/benduckett17\/","twitter_profile":"https:\/\/twitter.com\/BenDuckett1","instagram_profile":"https:\/\/www.instagram.com\/benduckett1\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49382,"title":"Olly Stone","short_name":"OP Stone","first_name":"Olly Stone","last_name":"","middle_name":"","birthdate":"1993-10-09","birthplace":"Norwich, Norfolk","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/ollystone2","instagram_profile":"https:\/\/www.instagram.com\/ollystone93\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49793,"title":"Brett Hutton","short_name":"BA Hutton","first_name":"Brett Hutton","last_name":"","middle_name":"","birthdate":"1993-02-06","birthplace":" Doncaster, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49808,"title":"Zak Chappell","short_name":"ZJ Chappell","first_name":"Zak Chappell","last_name":"","middle_name":"","birthdate":"1996-08-21","birthplace":"Grantham, Lincolnshire","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":"","instagram_profile":"https:\/\/www.instagram.com\/chappooo","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50422,"title":"Calvin Harrison","short_name":"Calvin Harrison","first_name":"Calvin Harrison","last_name":"","middle_name":"","birthdate":"1998-04-29","birthplace":" Durban, KwaZulu-Natal","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/calvinh_98","instagram_profile":"https:\/\/www.instagram.com\/calvin_harrison_\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":50433,"title":"Alex Thomson","short_name":"AT Thomson","first_name":"Alex Thomson","last_name":"","middle_name":"","birthdate":"1993-10-30","birthplace":"Stoke-on-Trent, Staffordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/alextomo","instagram_profile":"https:\/\/www.instagram.com\/alex_thomson_racing\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50528,"title":"Anuj Dal","short_name":"AK Dal","first_name":"Anuj Dal","last_name":"","middle_name":"","birthdate":"1996-07-08","birthplace":"Newcastle-under-Lyme, Staffordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/AnujDal","instagram_profile":"https:\/\/www.instagram.com\/anujdal0\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51064,"title":"Martin Andersson","short_name":"MK Andersson","first_name":"Martin Andersson","last_name":"","middle_name":"","birthdate":"1996-09-06","birthplace":"Reading, Berkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/MartinAnderss11","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":60432,"title":"Matthew Montgomery","short_name":"M Montgomery","first_name":"Matthew Montgomery","last_name":"","middle_name":"","birthdate":"2000-05-10","birthplace":"Johannesburg","country":"de","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"bowl","role_str":""},{"pid":84689,"title":"Pat Brown","short_name":"PR Brown","first_name":"Pat Brown","last_name":"","middle_name":"","birthdate":"1998-08-23","birthplace":"Peterborough, Cambridgeshire","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":"","instagram_profile":"https:\/\/www.instagram.com\/patbrowny\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":93372,"title":"Daniel Sams","short_name":"DR Sams","first_name":"Daniel Sams","last_name":"","middle_name":"","birthdate":"1992-10-27","birthplace":" Milperra, New South Wales","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/dansams\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"all","role_str":""},{"pid":93521,"title":"Dillon Pennington","short_name":"D Pennington","first_name":"Dillon Pennington","last_name":"","middle_name":"","birthdate":"1999-02-26","birthplace":"Shrewsbury, Shropshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/DillonPenningt4","instagram_profile":"https:\/\/www.instagram.com\/dillonp___\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":93953,"title":"Lyndon James","short_name":"LW James","first_name":"Lyndon James","last_name":"","middle_name":"","birthdate":"1997-12-27","birthplace":" Worksop","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":94962,"title":"Harry Came","short_name":"H Came","first_name":"Harry Came","last_name":"","middle_name":"","birthdate":"1998-08-27","birthplace":"Hampshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/HarryCame4","instagram_profile":"https:\/\/www.instagram.com\/harrycame4\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":94963,"title":"Jack Morley","short_name":"J Morley","first_name":"Jack Morley","last_name":"","middle_name":"","birthdate":"2001-06-25","birthplace":"Rochdale, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":94965,"title":"Jack Haynes","short_name":"J Haynes","first_name":"Jack Haynes","last_name":"","middle_name":"","birthdate":"2001-01-30","birthplace":"Worcester","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/jack_haynes1","instagram_profile":"https:\/\/www.instagram.com\/jack.hayness\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":94986,"title":"Liam Patterson-White","short_name":"LP White","first_name":"Liam Patterson-White","last_name":"","middle_name":"","birthdate":"1998-11-08","birthplace":"Sunderland, Co Durham","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":101484,"title":"Ben William Aitchison","short_name":"B W Aitchison","first_name":"Ben William Aitchison","last_name":"","middle_name":"","birthdate":"1999-07-06","birthplace":"Southport, 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":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Benaitchison123","instagram_profile":"https:\/\/www.instagram.com\/baitchison13\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":108415,"title":"Sam King","short_name":"S King","first_name":"Sam King","last_name":"","middle_name":"","birthdate":"2003-01-12","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108416,"title":"Benjamin Martindale","short_name":"B Martindale","first_name":"Benjamin Martindale","last_name":"","middle_name":"","birthdate":"2002-12-12","birthplace":"Nottingham","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108441,"title":"Robert Lord","short_name":"R Lord","first_name":"Robert Lord","last_name":"","middle_name":"","birthdate":"2001-05-04","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108586,"title":"Nick Potts","short_name":"N Potts","first_name":"Nick Potts","last_name":"","middle_name":"","birthdate":"2002-07-17","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":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/nickwpotts\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":109363,"title":"Mitchell Wagstaff","short_name":"M Wagstaff","first_name":"Mitchell Wagstaff","last_name":"","middle_name":"","birthdate":"2003-09-02","birthplace":"Derby","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/mitchellwaggy?lang=en","instagram_profile":"https:\/\/www.instagram.com\/mitchellwagstaff\/?hl=en","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":109543,"title":"James Hayes","short_name":"JPH Hayes","first_name":"James Hayes","last_name":"","middle_name":"","birthdate":"2001-06-27","birthplace":"Haywards Heath, Sussex","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":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":118504,"title":"Allah Mohammad Ghazanfar","short_name":"AM Ghazanfar","first_name":"Allah Mohammad Ghazanfar","last_name":"","middle_name":"","birthdate":"2007-07-15","birthplace":"","country":"af","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":7.5,"facebook_profile":"https:\/\/www.facebook.com\/Ghazanfar050\/","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Afghanistan","role":"bowl","role_str":""},{"pid":130162,"title":"Harry Moore","short_name":"HJ Moore","first_name":"Harry Moore","last_name":"","middle_name":"","birthdate":"2007-04-26","birthplace":"Houston, Florida","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":"https:\/\/twitter.com\/ha66y2004","instagram_profile":"https:\/\/www.instagram.com\/harrymoore72\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":130480,"title":"Tom Giles","short_name":"T Giles","first_name":"Tom Giles","last_name":"","middle_name":"","birthdate":"2006-05-17","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":130481,"title":"Travis Holland","short_name":"T Holland","first_name":"Travis Holland","last_name":"","middle_name":"","birthdate":"2006-01-21","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":131217,"title":"Farhan Ahmed","short_name":"F Ahmed","first_name":"Farhan Ahmed","last_name":"","middle_name":"","birthdate":"2008-02-22","birthplace":"Nottingham","country":"en","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":137369,"title":"Freddie McCann","short_name":"F McCann","first_name":"Freddie McCann","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":141343,"title":"Yousaf Bin Naeem","short_name":"YB Naeem","first_name":"Yousaf Bin Naeem","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":149077,"title":"Sam Seecharan","short_name":"Sam Seecharan","first_name":"Sam Seecharan","last_name":"","middle_name":"","birthdate":"2006-08-16","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":149078,"title":"Francis Moore","short_name":"F Moore","first_name":"Francis Moore","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""}]},"etag":"49d715ab4907988f637599f8b078a8fd","modified":"2025-08-01 08:54:56","datetime":"2025-08-01 08:54:56","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86848 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:91b2f18e-9b8f-4e40-8623-dd84e4c180ec
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86848 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86848,3,'{"status":"ok","response":{"match_id":86848,"title":"Derbyshire vs Nottinghamshire","short_title":"DER vs NOT","subtitle":"Match 28","match_number":"28","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Nottinghamshire won by 7 wickets (DLS method)","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":104949,"name":"Derbyshire","short_name":"DER","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/derbyshire-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/derbyshire-logo.png","scores_full":"162\/9 (20 ov)","scores":"162\/9","overs":"20"},"teamb":{"team_id":6035,"name":"Nottinghamshire","short_name":"NOT","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/nottinghamshire-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/nottinghamshire-logo.png","scores_full":"120\/3 (13.5 ov)","scores":"120\/3","overs":"13.5"},"date_start":"2025-06-06 18:00:00","date_end":"2025-06-07 04:00:00","timestamp_start":1749232800,"timestamp_end":1749268800,"date_start_ist":"2025-06-06 23:30:00","date_end_ist":"2025-06-07 09:30:00","venue":{"venue_id":"49","name":"County Ground","location":"Derby","country":"England","timezone":""},"umpires":"Michael Gough (England), Neil Pratt (England)","referee":"James Whitaker (England)","equation":"","live":"","result":"NOT won by 7 wickets (DLS method)","result_type":2,"win_margin":"7 wickets (DLS method)","winning_team_id":6035,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-06 00:04:17","verify_time":"2025-06-07 03:02:58","match_dls_affected":"true","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":12.41,"humidity":74,"visibility":10000,"wind_speed":"6.87","clouds":100},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Nottinghamshire elected to bowl","winner":6035,"decision":2}},"etag":"f088667b2b9ede722ab660497f29e474","modified":"2025-08-01 08:54:57","datetime":"2025-08-01 08:54:57","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":86848,"title":"Derbyshire vs Nottinghamshire","short_title":"DER vs NOT","subtitle":"Match 28","match_number":"28","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Nottinghamshire won by 7 wickets (DLS method)","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":104949,"name":"Derbyshire","short_name":"DER","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/derbyshire-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/derbyshire-logo.png","scores_full":"162\/9 (20 ov)","scores":"162\/9","overs":"20"},"teamb":{"team_id":6035,"name":"Nottinghamshire","short_name":"NOT","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/nottinghamshire-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/nottinghamshire-logo.png","scores_full":"120\/3 (13.5 ov)","scores":"120\/3","overs":"13.5"},"date_start":"2025-06-06 18:00:00","date_end":"2025-06-07 04:00:00","timestamp_start":1749232800,"timestamp_end":1749268800,"date_start_ist":"2025-06-06 23:30:00","date_end_ist":"2025-06-07 09:30:00","venue":{"venue_id":"49","name":"County Ground","location":"Derby","country":"England","timezone":""},"umpires":"Michael Gough (England), Neil Pratt (England)","referee":"James Whitaker (England)","equation":"","live":"","result":"NOT won by 7 wickets (DLS method)","result_type":2,"win_margin":"7 wickets (DLS method)","winning_team_id":6035,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-06 00:04:17","verify_time":"2025-06-07 03:02:58","match_dls_affected":"true","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":12.41,"humidity":74,"visibility":10000,"wind_speed":"6.87","clouds":100},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Nottinghamshire elected to bowl","winner":6035,"decision":2}},"etag":"f088667b2b9ede722ab660497f29e474","modified":"2025-08-01 08:54:57","datetime":"2025-08-01 08:54:57","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86848 AND DataTypeId = 3 END Live Report & Scorecard of Derbyshire vs Nottinghamshire Match 28