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:def22ef6-bbe6-4363-97ff-1bda161ef17f
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86851 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86851,1,'{"status":"ok","response":{"mid":86851,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Yorkshire won by 106 runs","day_remaining_over":"","team_batting":"Leicestershire","team_bowling":"Yorkshire","live_inning_number":2,"live_score":{"runs":107,"overs":16.5,"wickets":10,"target":214,"runrate":6.36,"required_runrate":33.79},"commentary":1,"wagon":2,"batsmen":[{"name":"Matt Salisbury","batsman_id":50555,"runs":0,"balls_faced":1,"fours":0,"sixes":0,"strike_rate":"0.00"},{"name":"Roman Walker","batsman_id":93526,"runs":6,"balls_faced":6,"fours":0,"sixes":0,"strike_rate":"100.00"}],"bowlers":[{"name":"Jafer Chohan","bowler_id":120400,"overs":3.5,"runs_conceded":27,"wickets":4,"maidens":0,"econ":"7.04"},{"name":"Daniel Moriarty","bowler_id":45911,"overs":2,"runs_conceded":15,"wickets":1,"maidens":0,"econ":"7.50"}],"commentaries":[{"event_id":"12104111","event":"ball","batsman_id":"1905","bowler_id":"120400","over":"12","ball":"5","score":6,"commentary":"Jafer Chohan to Logan van Beek, Six,","noball_dismissal":false,"text":"","timestamp":1749401687,"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":"12104120","event":"ball","batsman_id":"1905","bowler_id":"120400","over":"12","ball":"6","score":1,"commentary":"Jafer Chohan to Logan van Beek, 1 run,","noball_dismissal":false,"text":"","timestamp":1749401712,"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":13,"runs":15,"score":"82\/7","bats":[{"runs":10,"balls_faced":7,"fours":0,"sixes":1,"batsman_id":1905},{"runs":11,"balls_faced":6,"fours":0,"sixes":1,"batsman_id":93523}],"bowls":[{"runs_conceded":20,"maidens":0,"wickets":2,"bowler_id":120400,"overs":3},{"runs_conceded":25,"maidens":0,"wickets":2,"bowler_id":50392,"overs":4}],"commentary":"End of over 13 (15 runs), Leicestershire 82\/7"},{"event_id":"12104147","event":"ball","batsman_id":"1905","bowler_id":"45911","over":"13","ball":"1","score":1,"commentary":"Daniel Moriarty to Logan van Beek, 1 run,","noball_dismissal":false,"text":"","timestamp":1749401841,"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":"12104150","event":"ball","batsman_id":"93523","bowler_id":"45911","over":"13","ball":"2","score":0,"commentary":"Daniel Moriarty to Tom Scriven, no run,","noball_dismissal":false,"text":"","timestamp":1749401881,"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":"12104152","event":"ball","batsman_id":"93523","bowler_id":"45911","over":"13","ball":"3","score":1,"commentary":"Daniel Moriarty to Tom Scriven, 1 run,","noball_dismissal":false,"text":"","timestamp":1749401885,"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":"12104154","event":"ball","batsman_id":"1905","bowler_id":"45911","over":"13","ball":"4","score":1,"commentary":"Daniel Moriarty to Logan van Beek, 1 run,","noball_dismissal":false,"text":"","timestamp":1749401890,"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":"12104156","event":"ball","batsman_id":"93523","bowler_id":"45911","over":"13","ball":"5","score":0,"commentary":"Daniel Moriarty to Tom Scriven, no run,","noball_dismissal":false,"text":"","timestamp":1749401894,"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":"12104189","event":"wicket","batsman_id":"93523","bowler_id":"45911","over":"13","ball":"6","score":"w","commentary":"Daniel Moriarty to Tom Scriven, no run, c W Luxton b DT Moriarty,","noball_dismissal":false,"text":"","timestamp":1749402035,"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":"93523","how_out":"c W Luxton b DT Moriarty","batsman_runs":"12","batsman_balls":"10"},{"event":"overend","over":14,"runs":3,"score":"85\/8","bats":[{"runs":12,"balls_faced":10,"fours":0,"sixes":1,"batsman_id":93523},{"runs":12,"balls_faced":9,"fours":0,"sixes":1,"batsman_id":1905}],"bowls":[{"runs_conceded":3,"maidens":0,"wickets":1,"bowler_id":45911,"overs":1},{"runs_conceded":20,"maidens":0,"wickets":2,"bowler_id":120400,"overs":3}],"commentary":"End of over 14 (3 runs), Leicestershire 85\/8"},{"event_id":"12104195","event":"ball","batsman_id":"1905","bowler_id":"96733","over":"14","ball":"1","score":"1wd","commentary":"William O''Rourke to Logan van Beek, 1 wide,","noball_dismissal":false,"text":"","timestamp":1749402083,"run":1,"noball_run":"0","wide_run":"1","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12104201","event":"ball","batsman_id":"1905","bowler_id":"96733","over":"14","ball":"1","score":0,"commentary":"William O''Rourke to Logan van Beek, no run,","noball_dismissal":false,"text":"","timestamp":1749402090,"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":"12104202","event":"ball","batsman_id":"1905","bowler_id":"96733","over":"14","ball":"2","score":1,"commentary":"William O''Rourke to Logan van Beek, 1 run,","noball_dismissal":false,"text":"","timestamp":1749402097,"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":"12104208","event":"ball","batsman_id":"93526","bowler_id":"96733","over":"14","ball":"3","score":0,"commentary":"William O''Rourke to Roman Walker, no run,","noball_dismissal":false,"text":"","timestamp":1749402120,"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":"12104210","event":"ball","batsman_id":"93526","bowler_id":"96733","over":"14","ball":"4","score":1,"commentary":"William O''Rourke to Roman Walker, 1 run,","noball_dismissal":false,"text":"","timestamp":1749402124,"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":"12104225","event":"ball","batsman_id":"1905","bowler_id":"96733","over":"14","ball":"5","score":0,"commentary":"William O''Rourke to Logan van Beek, no run,","noball_dismissal":false,"text":"","timestamp":1749402199,"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":"12104226","event":"ball","batsman_id":"1905","bowler_id":"96733","over":"14","ball":"6","score":0,"commentary":"William O''Rourke to Logan van Beek, no run,","noball_dismissal":false,"text":"","timestamp":1749402203,"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":15,"runs":3,"score":"88\/8","bats":[{"runs":13,"balls_faced":13,"fours":0,"sixes":1,"batsman_id":1905},{"runs":1,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":93526}],"bowls":[{"runs_conceded":12,"maidens":0,"wickets":1,"bowler_id":96733,"overs":3},{"runs_conceded":3,"maidens":0,"wickets":1,"bowler_id":45911,"overs":1}],"commentary":"End of over 15 (3 runs), Leicestershire 88\/8"},{"event_id":"12104245","event":"ball","batsman_id":"93526","bowler_id":"45911","over":"15","ball":"1","score":2,"commentary":"Daniel Moriarty to Roman Walker, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749402316,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12104247","event":"ball","batsman_id":"93526","bowler_id":"45911","over":"15","ball":"2","score":1,"commentary":"Daniel Moriarty to Roman Walker, 1 run,","noball_dismissal":false,"text":"","timestamp":1749402324,"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":"12104248","event":"ball","batsman_id":"1905","bowler_id":"45911","over":"15","ball":"3","score":6,"commentary":"Daniel Moriarty to Logan van Beek, Six,","noball_dismissal":false,"text":"","timestamp":1749402327,"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":"12104249","event":"ball","batsman_id":"1905","bowler_id":"45911","over":"15","ball":"4","score":1,"commentary":"Daniel Moriarty to Logan van Beek, 1 run,","noball_dismissal":false,"text":"","timestamp":1749402330,"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":"12104254","event":"ball","batsman_id":"93526","bowler_id":"45911","over":"15","ball":"5","score":1,"commentary":"Daniel Moriarty to Roman Walker, 1 run,","noball_dismissal":false,"text":"","timestamp":1749402345,"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":"12104258","event":"ball","batsman_id":"1905","bowler_id":"45911","over":"15","ball":"6","score":"1wd","commentary":"Daniel Moriarty to Logan van Beek, 1 wide,","noball_dismissal":false,"text":"","timestamp":1749402370,"run":1,"noball_run":"0","wide_run":"1","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12104261","event":"ball","batsman_id":"1905","bowler_id":"45911","over":"15","ball":"6","score":0,"commentary":"Daniel Moriarty to Logan van Beek, no run,","noball_dismissal":false,"text":"","timestamp":1749402390,"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":16,"runs":12,"score":"100\/8","bats":[{"runs":20,"balls_faced":16,"fours":0,"sixes":2,"batsman_id":1905},{"runs":5,"balls_faced":5,"fours":0,"sixes":0,"batsman_id":93526}],"bowls":[{"runs_conceded":15,"maidens":0,"wickets":1,"bowler_id":45911,"overs":2},{"runs_conceded":12,"maidens":0,"wickets":1,"bowler_id":96733,"overs":3}],"commentary":"End of over 16 (12 runs), Leicestershire 100\/8"},{"event_id":"12104276","event":"ball","batsman_id":"93526","bowler_id":"120400","over":"16","ball":"1","score":1,"commentary":"Jafer Chohan to Roman Walker, 1 run,","noball_dismissal":false,"text":"","timestamp":1749402511,"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":"12104277","event":"ball","batsman_id":"1905","bowler_id":"120400","over":"16","ball":"2","score":2,"commentary":"Jafer Chohan to Logan van Beek, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749402515,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12104282","event":"ball","batsman_id":"1905","bowler_id":"120400","over":"16","ball":"3","score":4,"commentary":"Jafer Chohan to Logan van Beek, Four,","noball_dismissal":false,"text":"","timestamp":1749402519,"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":"12104299","event":"wicket","batsman_id":"1905","bowler_id":"120400","over":"16","ball":"4","score":"w","commentary":"Jafer Chohan to Logan van Beek, no run, st H Duke b JA Chohan,","noball_dismissal":false,"text":"","timestamp":1749402584,"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":"1905","how_out":"st H Duke b JA Chohan","batsman_runs":"26","batsman_balls":"19"},{"event_id":"12104315","event":"wicket","batsman_id":"50555","bowler_id":"120400","over":"16","ball":"5","score":"w","commentary":"Jafer Chohan to Matt Salisbury, no run, b JA Chohan,","noball_dismissal":false,"text":"","timestamp":1749402676,"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":"50555","how_out":"b JA Chohan","batsman_runs":"0","batsman_balls":"1"}],"day":"0","session":"0","live_inning":{"iid":197697,"number":2,"name":"Leicestershire Inning","short_name":"LEI Inning","status":2,"issuperover":"false","result":1,"batting_team_id":104947,"fielding_team_id":7050,"scores":"107\/10","scores_full":"107\/10 (16.5 ov)","fielder":[{"fielder_id":"10610","fielder_name":"Adam Lyth","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"50392","fielder_name":"Dom Bess","catches":3,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"45911","fielder_name":"Daniel Moriarty","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"96606","fielder_name":"Harry Duke","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":1,"is_substitute":"false"},{"fielder_id":"109356","fielder_name":"William Luxton","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Matt Salisbury","batsman_id":"50555","runs":"0","balls":"1","how_out":"b JA Chohan","score_at_dismissal":107,"overs_at_dismissal":"16.5","bowler_id":"120400","dismissal":"bowled","number":10},"extra_runs":{"byes":0,"legbyes":3,"wides":3,"noballs":0,"penalty":"0","total":6},"equations":{"runs":107,"wickets":10,"overs":"16.5","bowlers_used":7,"runrate":"6.36"},"current_partnership":{"runs":0,"balls":1,"overs":0.1,"batsmen":[{"name":"Matt Salisbury","batsman_id":50555,"runs":0,"balls":1},{"name":"Roman Walker","batsman_id":93526,"runs":0,"balls":0}]},"did_not_bat":[],"max_over":"20","target":"214","recent_scores":"w,w,4,2,1,0,1,1,1,6,1,2,0,0,1,0,1,0","last_five_overs":"41\/3 7.69","last_ten_overs":"70\/7 6.67"},"teams":[{"tid":7050,"title":"Yorkshire","abbr":"YOR","alt_name":"YOR","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/yorkshire-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/yorkshire-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"213\/7 (20 ov)","scores":"213\/7","overs":"20"},{"tid":104947,"title":"Leicestershire","abbr":"LEI","alt_name":"Leicestershire","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/leicestershire-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/leicestershire-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"107\/10 (16.5 ov)","scores":"107\/10","overs":"16.5"}],"players":[{"pid":99,"title":"Joe Root","short_name":"J Root","first_name":"Joe Root","last_name":"","middle_name":"","birthdate":"1990-12-30","birthplace":"Sheffield, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":18968,"recent_appearance":1514244600,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/JoeRootOfficial\/","twitter_profile":"https:\/\/twitter.com\/root66","instagram_profile":"https:\/\/www.instagram.com\/root66\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":1905,"title":"Logan van Beek","short_name":"L Beek","first_name":"Logan van Beek","last_name":"","middle_name":"","birthdate":"1990-09-07","birthplace":"Christchurch, Canterbury","country":"nl","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":"","twitter_profile":"https:\/\/twitter.com\/loganvanbeek","instagram_profile":"https:\/\/www.instagram.com\/loganvanbeek\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"bowl","role_str":""},{"pid":1933,"title":"Adil Rashid","short_name":"A Rashid","first_name":"Adil Rashid","last_name":"","middle_name":"","birthdate":"1988-02-17","birthplace":" Bradford, Yorkshire","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":8.5,"facebook_profile":"https:\/\/www.facebook.com\/AdilRashid95\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/adilrashid\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":10610,"title":"Adam Lyth","short_name":"A Lyth","first_name":"Adam Lyth","last_name":"","middle_name":"","birthdate":"1987-09-25","birthplace":"Whitby, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/lythy09\/","twitter_profile":"https:\/\/twitter.com\/lythy09","instagram_profile":"https:\/\/www.instagram.com\/lythy09\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":43358,"title":"Dawid Malan","short_name":"D Malan","first_name":"Dawid Malan","last_name":"","middle_name":"","birthdate":"1987-09-03","birthplace":"Roehampton, England","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":9,"facebook_profile":"https:\/\/www.facebook.com\/D.Malanofficial\/","twitter_profile":"https:\/\/twitter.com\/dmalan29","instagram_profile":"https:\/\/www.instagram.com\/djmalan29\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"pid":43491,"title":"Peter Handscomb","short_name":"PSP Handscomb","first_name":"Peter Handscomb","last_name":"","middle_name":"","birthdate":"1991-04-26","birthplace":"Melbourne, Victoria","country":"au","primary_team":[],"logo_url":"","playing_role":"bat","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\/phandscomb54\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":44100,"title":"Jonny Bairstow","short_name":"J Bairstow","first_name":"Jonny Bairstow","last_name":"","middle_name":"","birthdate":"1989-09-26","birthplace":" Bradford, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/jbairstow21\/","twitter_profile":"https:\/\/twitter.com\/jbairstow21","instagram_profile":"https:\/\/www.instagram.com\/jbairstow21\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":45911,"title":"Daniel Moriarty","short_name":"DT Moriarty","first_name":"Daniel Moriarty","last_name":"","middle_name":"","birthdate":"1999-12-02","birthplace":"Reigate, Surrey","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":48449,"title":"Ben Coad","short_name":"BO Coad","first_name":"Ben Coad","last_name":"","middle_name":"","birthdate":"1994-01-10","birthplace":"Harrogate, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BenCoad10","instagram_profile":"https:\/\/www.instagram.com\/bencoad10\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":48660,"title":"Ben Cox","short_name":"OB Cox","first_name":"Ben Cox","last_name":"","middle_name":"","birthdate":"1992-02-02","birthplace":"Wordsley, Stourbridge, Worcestershire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper ","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BenCox10","instagram_profile":"https:\/\/www.instagram.com\/bencox10\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":49035,"title":"Chris Wright","short_name":"CJC Wright","first_name":"Chris Wright","last_name":"","middle_name":"","birthdate":"1985-07-14","birthplace":"Chipping Norton, Oxfordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49076,"title":"Shan Masood","short_name":"SM Khan","first_name":"Shan Masood","last_name":"","middle_name":"","birthdate":"1989-10-14","birthplace":"Kuwait","country":"pk","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/shanmasood214\/","twitter_profile":"https:\/\/twitter.com\/shani_official","instagram_profile":"https:\/\/www.instagram.com\/shani_official89\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bat","role_str":""},{"pid":49803,"title":"Lewis Hill","short_name":"LS Hill","first_name":"Lewis Hill","last_name":"","middle_name":"","birthdate":"1990-10-05","birthplace":"Leicester, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/ljhill23?lang=en","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":""},{"pid":49914,"title":"Sam Wood","short_name":"SKW Wood","first_name":"Sam Wood","last_name":"","middle_name":"","birthdate":"1993-04-03","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50392,"title":"Dom Bess","short_name":"Dom Bess","first_name":"Dom Bess","last_name":"","middle_name":"","birthdate":"1997-07-22","birthplace":"Exeter, Devon","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/dombess99\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":50505,"title":"Jonathan Tattersall","short_name":"JA Tattersall","first_name":"Jonathan Tattersall","last_name":"","middle_name":"","birthdate":"1994-12-15","birthplace":" Harrogate, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50507,"title":"Jordan Thompson","short_name":"JA Thompson","first_name":"Jordan Thompson","last_name":"","middle_name":"","birthdate":"1996-10-09","birthplace":"Leeds, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Tommo455","instagram_profile":"https:\/\/www.instagram.com\/jordan.a.thompson\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50555,"title":"Matt Salisbury","short_name":"MET Salisbury","first_name":"Matt Salisbury","last_name":"","middle_name":"","birthdate":"1993-04-18","birthplace":"Chelmsford, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/MattJSalisbury","instagram_profile":"https:\/\/twitter.com\/MattJSalisbury","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":50683,"title":"Louis Kimber","short_name":"LPJ Kimber","first_name":"Louis Kimber","last_name":"","middle_name":"","birthdate":"1997-02-24","birthplace":"Scunthorpe, Lincolnshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/louiskimber17\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"pid":50809,"title":"Harry Swindells","short_name":"Harry Swindells","first_name":"Harry Swindells","last_name":"","middle_name":"","birthdate":"1999-02-21","birthplace":"Leicester","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/phandscomb54\/?hl=en","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":55109,"title":"Ian Holland","short_name":"I Holland","first_name":"Ian Holland","last_name":"","middle_name":"","birthdate":"1990-10-03","birthplace":"Stevens Point, Wisconsin","country":"us","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United States","role":"squad","role_str":""},{"pid":57644,"title":"Matt Milnes","short_name":"M Milnes","first_name":"Matt Milnes","last_name":"","middle_name":"","birthdate":"1994-07-29","birthplace":" Nottingham","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/mmilnes84","instagram_profile":"https:\/\/www.instagram.com\/matt_milnes\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":61872,"title":"Jack White","short_name":"cJ White","first_name":"Jack White","last_name":"","middle_name":"","birthdate":"1992-02-19","birthplace":" Kendal","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":90887,"title":"Harry Brook","short_name":"H Brook","first_name":"Harry Brook","last_name":"","middle_name":"","birthdate":"1999-02-22","birthplace":"Keighley, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/HarryBroook\/","twitter_profile":"https:\/\/twitter.com\/Harry_Brook_88","instagram_profile":"https:\/\/www.instagram.com\/harry_brook88\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":90934,"title":"Liam Trevaskis","short_name":"L Trevaskis","first_name":"Liam Trevaskis","last_name":"","middle_name":"","birthdate":"1999-04-18","birthplace":"Carlisle, Cumberland","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,"facebook_profile":"https:\/\/www.facebook.com\/liam.trevaskis.9\/","twitter_profile":"https:\/\/twitter.com\/LiamTrevaskis","instagram_profile":"https:\/\/www.instagram.com\/liamtrevaskis80\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":93358,"title":"Will Sutherland","short_name":"W Sutherland","first_name":"Will Sutherland","last_name":"","middle_name":"","birthdate":"1999-10-27","birthplace":"Melbourne, Australia","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":23792,"recent_appearance":1515891600,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/will_suth12","instagram_profile":"https:\/\/www.instagram.com\/willsutherland12\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":93523,"title":"Tom Scriven","short_name":"TAR Scriven","first_name":"Tom Scriven","last_name":"","middle_name":"","birthdate":"1998-11-18","birthplace":"Oxford, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":93526,"title":"Roman Walker","short_name":"RI Walker","first_name":"Roman Walker","last_name":"","middle_name":"","birthdate":"2000-08-06","birthplace":" Wrexham, Clwyd","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\/romanwalker17?lang=en","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":93785,"title":"Ben Mike","short_name":"BWM Mike","first_name":"Ben Mike","last_name":"","middle_name":"","birthdate":"1998-08-24","birthplace":" Nottingham","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/benmikee\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":93879,"title":"Rishi Patel","short_name":"RK Patel","first_name":"Rishi Patel","last_name":"","middle_name":"","birthdate":"1998-07-26","birthplace":"Chigwell, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/rishi175?ref_src=twsrc%5Egoogle%7Ctwcamp%5Eserp%7Ctwgr%5Eauthor","instagram_profile":"https:\/\/www.instagram.com\/rishithedesigner\/?hl=en","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":95555,"title":"George Hill","short_name":"G Hill","first_name":"George Hill","last_name":"","middle_name":"","birthdate":"2001-01-24","birthplace":"Keighley, 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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95593,"title":"Finlay Bean","short_name":"F Bean","first_name":"Finlay Bean","last_name":"","middle_name":"","birthdate":"2002-04-16","birthplace":" Harrogate, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","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":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95640,"title":"Soloman Budinger","short_name":"S Budinger","first_name":"Soloman Budinger","last_name":"","middle_name":"","birthdate":"1999-08-21","birthplace":"Colchester, Essex","country":"en","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":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lordbudinger?lang=en","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":96059,"title":"Matthew Revis","short_name":"M Revis","first_name":"Matthew Revis","last_name":"","middle_name":"","birthdate":"2001-11-15","birthplace":" Steeton, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/matty.revis_\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":96605,"title":"Scott Currie","short_name":"S Currie","first_name":"Scott Currie","last_name":"","middle_name":"","birthdate":"2001-05-02","birthplace":"Poole, Dorset","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":96606,"title":"Harry Duke","short_name":"H Duke","first_name":"Harry Duke","last_name":"","middle_name":"","birthdate":"2001-09-01","birthplace":"Pinderfields, Wakefield","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":96733,"title":"William O''Rourke","short_name":"WO Rourke","first_name":"William O''Rourke","last_name":"","middle_name":"","birthdate":"2001-08-06","birthplace":"Surrey","country":"nz","primary_team":{"tid":1068,"name":"","short_name":""},"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\/willorourke_\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bowl","role_str":""},{"pid":96959,"title":"Rehan Ahmed","short_name":"R Ahmed","first_name":"Rehan Ahmed","last_name":"","middle_name":"","birthdate":"2004-08-13","birthplace":"Nottingham","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/rehanahmed__16","instagram_profile":"https:\/\/www.instagram.com\/rehanahmed__16\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":102295,"title":"James Wharton","short_name":"J Wharton","first_name":"James Wharton","last_name":"","middle_name":"","birthdate":"2001-02-01","birthplace":" Huddersfield","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":109356,"title":"William Luxton","short_name":"W Luxton","first_name":"William Luxton","last_name":"","middle_name":"","birthdate":"2003-05-06","birthplace":"Keighley, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":112710,"title":"Benjamin Cliff","short_name":"BM Cliff","first_name":"Benjamin Cliff","last_name":"","middle_name":"","birthdate":"2002-10-23","birthplace":" Halifax, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BenjaminCliff1","instagram_profile":"https:\/\/www.instagram.com\/bencliff23\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":120400,"title":"Jafer Chohan","short_name":"JA Chohan","first_name":"Jafer Chohan","last_name":"","middle_name":"","birthdate":"2002-07-11","birthplace":"Camden, Middlesex, England","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/chohanjafar\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":126255,"title":"Josh Hull","short_name":"JO Hull","first_name":"Josh Hull","last_name":"","middle_name":"","birthdate":"2004-08-20","birthplace":" Huntingdon, Cambridgeshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":127225,"title":"Yash Vagadia","short_name":"Y Vagadia","first_name":"Yash Vagadia","last_name":"","middle_name":"","birthdate":"2005-01-01","birthplace":" Newcastle","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":140958,"title":"Alex Green","short_name":"A Green","first_name":"Alex Green","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":""},{"pid":141670,"title":"Noah M Kelly","short_name":"N M Kelly","first_name":"Noah M Kelly","last_name":"","middle_name":"","birthdate":"2005-09-21","birthplace":"","country":"en","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":146172,"title":"Alex Wade","short_name":"A Wade","first_name":"Alex Wade","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":""},{"pid":147420,"title":"Jawad Akhtar","short_name":"J Akhtar","first_name":"Jawad Akhtar","last_name":"","middle_name":"","birthdate":"2005-11-19","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""}]},"etag":"36f604b096b62926d1e7c21a5aef2b4e","modified":"2025-07-29 18:04:29","datetime":"2025-07-29 18:04:29","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":86851,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Yorkshire won by 106 runs","day_remaining_over":"","team_batting":"Leicestershire","team_bowling":"Yorkshire","live_inning_number":2,"live_score":{"runs":107,"overs":16.5,"wickets":10,"target":214,"runrate":6.36,"required_runrate":33.79},"commentary":1,"wagon":2,"batsmen":[{"name":"Matt Salisbury","batsman_id":50555,"runs":0,"balls_faced":1,"fours":0,"sixes":0,"strike_rate":"0.00"},{"name":"Roman Walker","batsman_id":93526,"runs":6,"balls_faced":6,"fours":0,"sixes":0,"strike_rate":"100.00"}],"bowlers":[{"name":"Jafer Chohan","bowler_id":120400,"overs":3.5,"runs_conceded":27,"wickets":4,"maidens":0,"econ":"7.04"},{"name":"Daniel Moriarty","bowler_id":45911,"overs":2,"runs_conceded":15,"wickets":1,"maidens":0,"econ":"7.50"}],"commentaries":[{"event_id":"12104111","event":"ball","batsman_id":"1905","bowler_id":"120400","over":"12","ball":"5","score":6,"commentary":"Jafer Chohan to Logan van Beek, Six,","noball_dismissal":false,"text":"","timestamp":1749401687,"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":"12104120","event":"ball","batsman_id":"1905","bowler_id":"120400","over":"12","ball":"6","score":1,"commentary":"Jafer Chohan to Logan van Beek, 1 run,","noball_dismissal":false,"text":"","timestamp":1749401712,"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":13,"runs":15,"score":"82\/7","bats":[{"runs":10,"balls_faced":7,"fours":0,"sixes":1,"batsman_id":1905},{"runs":11,"balls_faced":6,"fours":0,"sixes":1,"batsman_id":93523}],"bowls":[{"runs_conceded":20,"maidens":0,"wickets":2,"bowler_id":120400,"overs":3},{"runs_conceded":25,"maidens":0,"wickets":2,"bowler_id":50392,"overs":4}],"commentary":"End of over 13 (15 runs), Leicestershire 82\/7"},{"event_id":"12104147","event":"ball","batsman_id":"1905","bowler_id":"45911","over":"13","ball":"1","score":1,"commentary":"Daniel Moriarty to Logan van Beek, 1 run,","noball_dismissal":false,"text":"","timestamp":1749401841,"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":"12104150","event":"ball","batsman_id":"93523","bowler_id":"45911","over":"13","ball":"2","score":0,"commentary":"Daniel Moriarty to Tom Scriven, no run,","noball_dismissal":false,"text":"","timestamp":1749401881,"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":"12104152","event":"ball","batsman_id":"93523","bowler_id":"45911","over":"13","ball":"3","score":1,"commentary":"Daniel Moriarty to Tom Scriven, 1 run,","noball_dismissal":false,"text":"","timestamp":1749401885,"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":"12104154","event":"ball","batsman_id":"1905","bowler_id":"45911","over":"13","ball":"4","score":1,"commentary":"Daniel Moriarty to Logan van Beek, 1 run,","noball_dismissal":false,"text":"","timestamp":1749401890,"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":"12104156","event":"ball","batsman_id":"93523","bowler_id":"45911","over":"13","ball":"5","score":0,"commentary":"Daniel Moriarty to Tom Scriven, no run,","noball_dismissal":false,"text":"","timestamp":1749401894,"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":"12104189","event":"wicket","batsman_id":"93523","bowler_id":"45911","over":"13","ball":"6","score":"w","commentary":"Daniel Moriarty to Tom Scriven, no run, c W Luxton b DT Moriarty,","noball_dismissal":false,"text":"","timestamp":1749402035,"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":"93523","how_out":"c W Luxton b DT Moriarty","batsman_runs":"12","batsman_balls":"10"},{"event":"overend","over":14,"runs":3,"score":"85\/8","bats":[{"runs":12,"balls_faced":10,"fours":0,"sixes":1,"batsman_id":93523},{"runs":12,"balls_faced":9,"fours":0,"sixes":1,"batsman_id":1905}],"bowls":[{"runs_conceded":3,"maidens":0,"wickets":1,"bowler_id":45911,"overs":1},{"runs_conceded":20,"maidens":0,"wickets":2,"bowler_id":120400,"overs":3}],"commentary":"End of over 14 (3 runs), Leicestershire 85\/8"},{"event_id":"12104195","event":"ball","batsman_id":"1905","bowler_id":"96733","over":"14","ball":"1","score":"1wd","commentary":"William O''Rourke to Logan van Beek, 1 wide,","noball_dismissal":false,"text":"","timestamp":1749402083,"run":1,"noball_run":"0","wide_run":"1","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12104201","event":"ball","batsman_id":"1905","bowler_id":"96733","over":"14","ball":"1","score":0,"commentary":"William O''Rourke to Logan van Beek, no run,","noball_dismissal":false,"text":"","timestamp":1749402090,"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":"12104202","event":"ball","batsman_id":"1905","bowler_id":"96733","over":"14","ball":"2","score":1,"commentary":"William O''Rourke to Logan van Beek, 1 run,","noball_dismissal":false,"text":"","timestamp":1749402097,"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":"12104208","event":"ball","batsman_id":"93526","bowler_id":"96733","over":"14","ball":"3","score":0,"commentary":"William O''Rourke to Roman Walker, no run,","noball_dismissal":false,"text":"","timestamp":1749402120,"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":"12104210","event":"ball","batsman_id":"93526","bowler_id":"96733","over":"14","ball":"4","score":1,"commentary":"William O''Rourke to Roman Walker, 1 run,","noball_dismissal":false,"text":"","timestamp":1749402124,"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":"12104225","event":"ball","batsman_id":"1905","bowler_id":"96733","over":"14","ball":"5","score":0,"commentary":"William O''Rourke to Logan van Beek, no run,","noball_dismissal":false,"text":"","timestamp":1749402199,"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":"12104226","event":"ball","batsman_id":"1905","bowler_id":"96733","over":"14","ball":"6","score":0,"commentary":"William O''Rourke to Logan van Beek, no run,","noball_dismissal":false,"text":"","timestamp":1749402203,"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":15,"runs":3,"score":"88\/8","bats":[{"runs":13,"balls_faced":13,"fours":0,"sixes":1,"batsman_id":1905},{"runs":1,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":93526}],"bowls":[{"runs_conceded":12,"maidens":0,"wickets":1,"bowler_id":96733,"overs":3},{"runs_conceded":3,"maidens":0,"wickets":1,"bowler_id":45911,"overs":1}],"commentary":"End of over 15 (3 runs), Leicestershire 88\/8"},{"event_id":"12104245","event":"ball","batsman_id":"93526","bowler_id":"45911","over":"15","ball":"1","score":2,"commentary":"Daniel Moriarty to Roman Walker, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749402316,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12104247","event":"ball","batsman_id":"93526","bowler_id":"45911","over":"15","ball":"2","score":1,"commentary":"Daniel Moriarty to Roman Walker, 1 run,","noball_dismissal":false,"text":"","timestamp":1749402324,"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":"12104248","event":"ball","batsman_id":"1905","bowler_id":"45911","over":"15","ball":"3","score":6,"commentary":"Daniel Moriarty to Logan van Beek, Six,","noball_dismissal":false,"text":"","timestamp":1749402327,"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":"12104249","event":"ball","batsman_id":"1905","bowler_id":"45911","over":"15","ball":"4","score":1,"commentary":"Daniel Moriarty to Logan van Beek, 1 run,","noball_dismissal":false,"text":"","timestamp":1749402330,"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":"12104254","event":"ball","batsman_id":"93526","bowler_id":"45911","over":"15","ball":"5","score":1,"commentary":"Daniel Moriarty to Roman Walker, 1 run,","noball_dismissal":false,"text":"","timestamp":1749402345,"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":"12104258","event":"ball","batsman_id":"1905","bowler_id":"45911","over":"15","ball":"6","score":"1wd","commentary":"Daniel Moriarty to Logan van Beek, 1 wide,","noball_dismissal":false,"text":"","timestamp":1749402370,"run":1,"noball_run":"0","wide_run":"1","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12104261","event":"ball","batsman_id":"1905","bowler_id":"45911","over":"15","ball":"6","score":0,"commentary":"Daniel Moriarty to Logan van Beek, no run,","noball_dismissal":false,"text":"","timestamp":1749402390,"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":16,"runs":12,"score":"100\/8","bats":[{"runs":20,"balls_faced":16,"fours":0,"sixes":2,"batsman_id":1905},{"runs":5,"balls_faced":5,"fours":0,"sixes":0,"batsman_id":93526}],"bowls":[{"runs_conceded":15,"maidens":0,"wickets":1,"bowler_id":45911,"overs":2},{"runs_conceded":12,"maidens":0,"wickets":1,"bowler_id":96733,"overs":3}],"commentary":"End of over 16 (12 runs), Leicestershire 100\/8"},{"event_id":"12104276","event":"ball","batsman_id":"93526","bowler_id":"120400","over":"16","ball":"1","score":1,"commentary":"Jafer Chohan to Roman Walker, 1 run,","noball_dismissal":false,"text":"","timestamp":1749402511,"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":"12104277","event":"ball","batsman_id":"1905","bowler_id":"120400","over":"16","ball":"2","score":2,"commentary":"Jafer Chohan to Logan van Beek, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749402515,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12104282","event":"ball","batsman_id":"1905","bowler_id":"120400","over":"16","ball":"3","score":4,"commentary":"Jafer Chohan to Logan van Beek, Four,","noball_dismissal":false,"text":"","timestamp":1749402519,"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":"12104299","event":"wicket","batsman_id":"1905","bowler_id":"120400","over":"16","ball":"4","score":"w","commentary":"Jafer Chohan to Logan van Beek, no run, st H Duke b JA Chohan,","noball_dismissal":false,"text":"","timestamp":1749402584,"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":"1905","how_out":"st H Duke b JA Chohan","batsman_runs":"26","batsman_balls":"19"},{"event_id":"12104315","event":"wicket","batsman_id":"50555","bowler_id":"120400","over":"16","ball":"5","score":"w","commentary":"Jafer Chohan to Matt Salisbury, no run, b JA Chohan,","noball_dismissal":false,"text":"","timestamp":1749402676,"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":"50555","how_out":"b JA Chohan","batsman_runs":"0","batsman_balls":"1"}],"day":"0","session":"0","live_inning":{"iid":197697,"number":2,"name":"Leicestershire Inning","short_name":"LEI Inning","status":2,"issuperover":"false","result":1,"batting_team_id":104947,"fielding_team_id":7050,"scores":"107\/10","scores_full":"107\/10 (16.5 ov)","fielder":[{"fielder_id":"10610","fielder_name":"Adam Lyth","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"50392","fielder_name":"Dom Bess","catches":3,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"45911","fielder_name":"Daniel Moriarty","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"96606","fielder_name":"Harry Duke","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":1,"is_substitute":"false"},{"fielder_id":"109356","fielder_name":"William Luxton","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Matt Salisbury","batsman_id":"50555","runs":"0","balls":"1","how_out":"b JA Chohan","score_at_dismissal":107,"overs_at_dismissal":"16.5","bowler_id":"120400","dismissal":"bowled","number":10},"extra_runs":{"byes":0,"legbyes":3,"wides":3,"noballs":0,"penalty":"0","total":6},"equations":{"runs":107,"wickets":10,"overs":"16.5","bowlers_used":7,"runrate":"6.36"},"current_partnership":{"runs":0,"balls":1,"overs":0.1,"batsmen":[{"name":"Matt Salisbury","batsman_id":50555,"runs":0,"balls":1},{"name":"Roman Walker","batsman_id":93526,"runs":0,"balls":0}]},"did_not_bat":[],"max_over":"20","target":"214","recent_scores":"w,w,4,2,1,0,1,1,1,6,1,2,0,0,1,0,1,0","last_five_overs":"41\/3 7.69","last_ten_overs":"70\/7 6.67"},"teams":[{"tid":7050,"title":"Yorkshire","abbr":"YOR","alt_name":"YOR","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/yorkshire-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/yorkshire-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"213\/7 (20 ov)","scores":"213\/7","overs":"20"},{"tid":104947,"title":"Leicestershire","abbr":"LEI","alt_name":"Leicestershire","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/leicestershire-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/leicestershire-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"107\/10 (16.5 ov)","scores":"107\/10","overs":"16.5"}],"players":[{"pid":99,"title":"Joe Root","short_name":"J Root","first_name":"Joe Root","last_name":"","middle_name":"","birthdate":"1990-12-30","birthplace":"Sheffield, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":18968,"recent_appearance":1514244600,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/JoeRootOfficial\/","twitter_profile":"https:\/\/twitter.com\/root66","instagram_profile":"https:\/\/www.instagram.com\/root66\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":1905,"title":"Logan van Beek","short_name":"L Beek","first_name":"Logan van Beek","last_name":"","middle_name":"","birthdate":"1990-09-07","birthplace":"Christchurch, Canterbury","country":"nl","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":"","twitter_profile":"https:\/\/twitter.com\/loganvanbeek","instagram_profile":"https:\/\/www.instagram.com\/loganvanbeek\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"bowl","role_str":""},{"pid":1933,"title":"Adil Rashid","short_name":"A Rashid","first_name":"Adil Rashid","last_name":"","middle_name":"","birthdate":"1988-02-17","birthplace":" Bradford, Yorkshire","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":8.5,"facebook_profile":"https:\/\/www.facebook.com\/AdilRashid95\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/adilrashid\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":10610,"title":"Adam Lyth","short_name":"A Lyth","first_name":"Adam Lyth","last_name":"","middle_name":"","birthdate":"1987-09-25","birthplace":"Whitby, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/lythy09\/","twitter_profile":"https:\/\/twitter.com\/lythy09","instagram_profile":"https:\/\/www.instagram.com\/lythy09\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":43358,"title":"Dawid Malan","short_name":"D Malan","first_name":"Dawid Malan","last_name":"","middle_name":"","birthdate":"1987-09-03","birthplace":"Roehampton, England","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":9,"facebook_profile":"https:\/\/www.facebook.com\/D.Malanofficial\/","twitter_profile":"https:\/\/twitter.com\/dmalan29","instagram_profile":"https:\/\/www.instagram.com\/djmalan29\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"pid":43491,"title":"Peter Handscomb","short_name":"PSP Handscomb","first_name":"Peter Handscomb","last_name":"","middle_name":"","birthdate":"1991-04-26","birthplace":"Melbourne, Victoria","country":"au","primary_team":[],"logo_url":"","playing_role":"bat","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\/phandscomb54\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":44100,"title":"Jonny Bairstow","short_name":"J Bairstow","first_name":"Jonny Bairstow","last_name":"","middle_name":"","birthdate":"1989-09-26","birthplace":" Bradford, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/jbairstow21\/","twitter_profile":"https:\/\/twitter.com\/jbairstow21","instagram_profile":"https:\/\/www.instagram.com\/jbairstow21\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":45911,"title":"Daniel Moriarty","short_name":"DT Moriarty","first_name":"Daniel Moriarty","last_name":"","middle_name":"","birthdate":"1999-12-02","birthplace":"Reigate, Surrey","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":48449,"title":"Ben Coad","short_name":"BO Coad","first_name":"Ben Coad","last_name":"","middle_name":"","birthdate":"1994-01-10","birthplace":"Harrogate, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BenCoad10","instagram_profile":"https:\/\/www.instagram.com\/bencoad10\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":48660,"title":"Ben Cox","short_name":"OB Cox","first_name":"Ben Cox","last_name":"","middle_name":"","birthdate":"1992-02-02","birthplace":"Wordsley, Stourbridge, Worcestershire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper ","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BenCox10","instagram_profile":"https:\/\/www.instagram.com\/bencox10\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":49035,"title":"Chris Wright","short_name":"CJC Wright","first_name":"Chris Wright","last_name":"","middle_name":"","birthdate":"1985-07-14","birthplace":"Chipping Norton, Oxfordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49076,"title":"Shan Masood","short_name":"SM Khan","first_name":"Shan Masood","last_name":"","middle_name":"","birthdate":"1989-10-14","birthplace":"Kuwait","country":"pk","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/shanmasood214\/","twitter_profile":"https:\/\/twitter.com\/shani_official","instagram_profile":"https:\/\/www.instagram.com\/shani_official89\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bat","role_str":""},{"pid":49803,"title":"Lewis Hill","short_name":"LS Hill","first_name":"Lewis Hill","last_name":"","middle_name":"","birthdate":"1990-10-05","birthplace":"Leicester, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/ljhill23?lang=en","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":""},{"pid":49914,"title":"Sam Wood","short_name":"SKW Wood","first_name":"Sam Wood","last_name":"","middle_name":"","birthdate":"1993-04-03","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50392,"title":"Dom Bess","short_name":"Dom Bess","first_name":"Dom Bess","last_name":"","middle_name":"","birthdate":"1997-07-22","birthplace":"Exeter, Devon","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/dombess99\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":50505,"title":"Jonathan Tattersall","short_name":"JA Tattersall","first_name":"Jonathan Tattersall","last_name":"","middle_name":"","birthdate":"1994-12-15","birthplace":" Harrogate, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50507,"title":"Jordan Thompson","short_name":"JA Thompson","first_name":"Jordan Thompson","last_name":"","middle_name":"","birthdate":"1996-10-09","birthplace":"Leeds, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Tommo455","instagram_profile":"https:\/\/www.instagram.com\/jordan.a.thompson\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50555,"title":"Matt Salisbury","short_name":"MET Salisbury","first_name":"Matt Salisbury","last_name":"","middle_name":"","birthdate":"1993-04-18","birthplace":"Chelmsford, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/MattJSalisbury","instagram_profile":"https:\/\/twitter.com\/MattJSalisbury","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":50683,"title":"Louis Kimber","short_name":"LPJ Kimber","first_name":"Louis Kimber","last_name":"","middle_name":"","birthdate":"1997-02-24","birthplace":"Scunthorpe, Lincolnshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/louiskimber17\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"pid":50809,"title":"Harry Swindells","short_name":"Harry Swindells","first_name":"Harry Swindells","last_name":"","middle_name":"","birthdate":"1999-02-21","birthplace":"Leicester","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/phandscomb54\/?hl=en","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":55109,"title":"Ian Holland","short_name":"I Holland","first_name":"Ian Holland","last_name":"","middle_name":"","birthdate":"1990-10-03","birthplace":"Stevens Point, Wisconsin","country":"us","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United States","role":"squad","role_str":""},{"pid":57644,"title":"Matt Milnes","short_name":"M Milnes","first_name":"Matt Milnes","last_name":"","middle_name":"","birthdate":"1994-07-29","birthplace":" Nottingham","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/mmilnes84","instagram_profile":"https:\/\/www.instagram.com\/matt_milnes\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":61872,"title":"Jack White","short_name":"cJ White","first_name":"Jack White","last_name":"","middle_name":"","birthdate":"1992-02-19","birthplace":" Kendal","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":90887,"title":"Harry Brook","short_name":"H Brook","first_name":"Harry Brook","last_name":"","middle_name":"","birthdate":"1999-02-22","birthplace":"Keighley, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/HarryBroook\/","twitter_profile":"https:\/\/twitter.com\/Harry_Brook_88","instagram_profile":"https:\/\/www.instagram.com\/harry_brook88\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":90934,"title":"Liam Trevaskis","short_name":"L Trevaskis","first_name":"Liam Trevaskis","last_name":"","middle_name":"","birthdate":"1999-04-18","birthplace":"Carlisle, Cumberland","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,"facebook_profile":"https:\/\/www.facebook.com\/liam.trevaskis.9\/","twitter_profile":"https:\/\/twitter.com\/LiamTrevaskis","instagram_profile":"https:\/\/www.instagram.com\/liamtrevaskis80\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":93358,"title":"Will Sutherland","short_name":"W Sutherland","first_name":"Will Sutherland","last_name":"","middle_name":"","birthdate":"1999-10-27","birthplace":"Melbourne, Australia","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":23792,"recent_appearance":1515891600,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/will_suth12","instagram_profile":"https:\/\/www.instagram.com\/willsutherland12\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":93523,"title":"Tom Scriven","short_name":"TAR Scriven","first_name":"Tom Scriven","last_name":"","middle_name":"","birthdate":"1998-11-18","birthplace":"Oxford, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":93526,"title":"Roman Walker","short_name":"RI Walker","first_name":"Roman Walker","last_name":"","middle_name":"","birthdate":"2000-08-06","birthplace":" Wrexham, Clwyd","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\/romanwalker17?lang=en","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":93785,"title":"Ben Mike","short_name":"BWM Mike","first_name":"Ben Mike","last_name":"","middle_name":"","birthdate":"1998-08-24","birthplace":" Nottingham","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/benmikee\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":93879,"title":"Rishi Patel","short_name":"RK Patel","first_name":"Rishi Patel","last_name":"","middle_name":"","birthdate":"1998-07-26","birthplace":"Chigwell, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/rishi175?ref_src=twsrc%5Egoogle%7Ctwcamp%5Eserp%7Ctwgr%5Eauthor","instagram_profile":"https:\/\/www.instagram.com\/rishithedesigner\/?hl=en","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":95555,"title":"George Hill","short_name":"G Hill","first_name":"George Hill","last_name":"","middle_name":"","birthdate":"2001-01-24","birthplace":"Keighley, 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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95593,"title":"Finlay Bean","short_name":"F Bean","first_name":"Finlay Bean","last_name":"","middle_name":"","birthdate":"2002-04-16","birthplace":" Harrogate, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","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":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95640,"title":"Soloman Budinger","short_name":"S Budinger","first_name":"Soloman Budinger","last_name":"","middle_name":"","birthdate":"1999-08-21","birthplace":"Colchester, Essex","country":"en","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":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lordbudinger?lang=en","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":96059,"title":"Matthew Revis","short_name":"M Revis","first_name":"Matthew Revis","last_name":"","middle_name":"","birthdate":"2001-11-15","birthplace":" Steeton, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/matty.revis_\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":96605,"title":"Scott Currie","short_name":"S Currie","first_name":"Scott Currie","last_name":"","middle_name":"","birthdate":"2001-05-02","birthplace":"Poole, Dorset","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":96606,"title":"Harry Duke","short_name":"H Duke","first_name":"Harry Duke","last_name":"","middle_name":"","birthdate":"2001-09-01","birthplace":"Pinderfields, Wakefield","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":96733,"title":"William O''Rourke","short_name":"WO Rourke","first_name":"William O''Rourke","last_name":"","middle_name":"","birthdate":"2001-08-06","birthplace":"Surrey","country":"nz","primary_team":{"tid":1068,"name":"","short_name":""},"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\/willorourke_\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bowl","role_str":""},{"pid":96959,"title":"Rehan Ahmed","short_name":"R Ahmed","first_name":"Rehan Ahmed","last_name":"","middle_name":"","birthdate":"2004-08-13","birthplace":"Nottingham","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/rehanahmed__16","instagram_profile":"https:\/\/www.instagram.com\/rehanahmed__16\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":102295,"title":"James Wharton","short_name":"J Wharton","first_name":"James Wharton","last_name":"","middle_name":"","birthdate":"2001-02-01","birthplace":" Huddersfield","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":109356,"title":"William Luxton","short_name":"W Luxton","first_name":"William Luxton","last_name":"","middle_name":"","birthdate":"2003-05-06","birthplace":"Keighley, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":112710,"title":"Benjamin Cliff","short_name":"BM Cliff","first_name":"Benjamin Cliff","last_name":"","middle_name":"","birthdate":"2002-10-23","birthplace":" Halifax, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BenjaminCliff1","instagram_profile":"https:\/\/www.instagram.com\/bencliff23\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":120400,"title":"Jafer Chohan","short_name":"JA Chohan","first_name":"Jafer Chohan","last_name":"","middle_name":"","birthdate":"2002-07-11","birthplace":"Camden, Middlesex, England","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/chohanjafar\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":126255,"title":"Josh Hull","short_name":"JO Hull","first_name":"Josh Hull","last_name":"","middle_name":"","birthdate":"2004-08-20","birthplace":" Huntingdon, Cambridgeshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":127225,"title":"Yash Vagadia","short_name":"Y Vagadia","first_name":"Yash Vagadia","last_name":"","middle_name":"","birthdate":"2005-01-01","birthplace":" Newcastle","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":140958,"title":"Alex Green","short_name":"A Green","first_name":"Alex Green","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":""},{"pid":141670,"title":"Noah M Kelly","short_name":"N M Kelly","first_name":"Noah M Kelly","last_name":"","middle_name":"","birthdate":"2005-09-21","birthplace":"","country":"en","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":146172,"title":"Alex Wade","short_name":"A Wade","first_name":"Alex Wade","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":""},{"pid":147420,"title":"Jawad Akhtar","short_name":"J Akhtar","first_name":"Jawad Akhtar","last_name":"","middle_name":"","birthdate":"2005-11-19","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""}]},"etag":"36f604b096b62926d1e7c21a5aef2b4e","modified":"2025-07-29 18:04:29","datetime":"2025-07-29 18:04:29","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86851 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:a4be6ac3-3456-4013-bf42-68cf189b1f76
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86851 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86851,3,'{"status":"ok","response":{"match_id":86851,"title":"Yorkshire vs Leicestershire","short_title":"YOR vs LEI","subtitle":"Match 31","match_number":"31","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Yorkshire won by 106 runs","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129425,"title":"Vitality Blast","abbr":"Vitality Blast","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-09-13","country":"en","total_matches":"133","total_rounds":"2","total_teams":"18"},"teama":{"team_id":7050,"name":"Yorkshire","short_name":"YOR","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/yorkshire-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/yorkshire-logo.png","scores_full":"213\/7 (20 ov)","scores":"213\/7","overs":"20"},"teamb":{"team_id":104947,"name":"Leicestershire","short_name":"LEI","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/leicestershire-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/leicestershire-logo.png","scores_full":"107\/10 (16.5 ov)","scores":"107\/10","overs":"16.5"},"date_start":"2025-06-08 14:00:00","date_end":"2025-06-09 00:00:00","timestamp_start":1749391200,"timestamp_end":1749427200,"date_start_ist":"2025-06-08 19:30:00","date_end_ist":"2025-06-09 05:30:00","venue":{"venue_id":"5","name":"Headingley","location":"Leeds","country":"England","timezone":""},"umpires":"","referee":"","equation":"","live":"","result":"YOR won by 106 runs","result_type":1,"win_margin":"106 runs","winning_team_id":7050,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-07 20:05:15","verify_time":"2025-06-08 23:02:11","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":14.97,"humidity":67,"visibility":10000,"wind_speed":"12.73","clouds":88},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Leicestershire elected to bowl","winner":104947,"decision":2}},"etag":"61fab4ed54c9b18c186555e089817eb7","modified":"2025-07-29 18:04:30","datetime":"2025-07-29 18:04:30","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":86851,"title":"Yorkshire vs Leicestershire","short_title":"YOR vs LEI","subtitle":"Match 31","match_number":"31","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Yorkshire won by 106 runs","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129425,"title":"Vitality Blast","abbr":"Vitality Blast","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-09-13","country":"en","total_matches":"133","total_rounds":"2","total_teams":"18"},"teama":{"team_id":7050,"name":"Yorkshire","short_name":"YOR","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/yorkshire-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/yorkshire-logo.png","scores_full":"213\/7 (20 ov)","scores":"213\/7","overs":"20"},"teamb":{"team_id":104947,"name":"Leicestershire","short_name":"LEI","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/leicestershire-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/leicestershire-logo.png","scores_full":"107\/10 (16.5 ov)","scores":"107\/10","overs":"16.5"},"date_start":"2025-06-08 14:00:00","date_end":"2025-06-09 00:00:00","timestamp_start":1749391200,"timestamp_end":1749427200,"date_start_ist":"2025-06-08 19:30:00","date_end_ist":"2025-06-09 05:30:00","venue":{"venue_id":"5","name":"Headingley","location":"Leeds","country":"England","timezone":""},"umpires":"","referee":"","equation":"","live":"","result":"YOR won by 106 runs","result_type":1,"win_margin":"106 runs","winning_team_id":7050,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-07 20:05:15","verify_time":"2025-06-08 23:02:11","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":14.97,"humidity":67,"visibility":10000,"wind_speed":"12.73","clouds":88},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Leicestershire elected to bowl","winner":104947,"decision":2}},"etag":"61fab4ed54c9b18c186555e089817eb7","modified":"2025-07-29 18:04:30","datetime":"2025-07-29 18:04:30","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86851 AND DataTypeId = 3 END Live Report & Scorecard of Yorkshire vs Leicestershire Match 31
Yorkshire vs Leicestershire, Live Cricket Commentary