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:dc207bcf-5c1b-4cca-8b75-f9e5e1d0e78f
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86880 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86880,1,'{"status":"ok","response":{"mid":86880,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Gloucestershire won by 7 wickets","day_remaining_over":"","team_batting":"Gloucestershire","team_bowling":"Kent","live_inning_number":2,"live_score":{"runs":160,"overs":18.2,"wickets":3,"target":158,"runrate":8.73,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Jack Taylor","batsman_id":49747,"runs":54,"balls_faced":36,"fours":4,"sixes":2,"strike_rate":"150.00"},{"name":"Ollie Price","batsman_id":107312,"runs":41,"balls_faced":31,"fours":1,"sixes":1,"strike_rate":"132.26"}],"bowlers":[{"name":"Wes Agar","bowler_id":48523,"overs":3.2,"runs_conceded":36,"wickets":0,"maidens":0,"econ":"10.80"},{"name":"Tom Stewart Rogers","bowler_id":57478,"overs":4,"runs_conceded":30,"wickets":1,"maidens":0,"econ":"7.50"}],"commentaries":[{"event":"overend","over":14,"runs":12,"score":"117\/3","bats":[{"runs":26,"balls_faced":20,"fours":0,"sixes":1,"batsman_id":107312},{"runs":26,"balls_faced":21,"fours":1,"sixes":1,"batsman_id":49747}],"bowls":[{"runs_conceded":27,"maidens":0,"wickets":1,"bowler_id":93789,"overs":4},{"runs_conceded":28,"maidens":0,"wickets":1,"bowler_id":95553,"overs":3}],"commentary":"End of over 14 (12 runs), Gloucestershire 117\/3"},{"event_id":"12169458","event":"ball","batsman_id":"107312","bowler_id":"57478","over":"14","ball":"1","score":1,"commentary":"Tom Stewart Rogers to Ollie Price, 1 run,","noball_dismissal":false,"text":"","timestamp":1750277238,"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":"12169462","event":"ball","batsman_id":"49747","bowler_id":"57478","over":"14","ball":"2","score":1,"commentary":"Tom Stewart Rogers to Jack Taylor, 1 run,","noball_dismissal":false,"text":"","timestamp":1750277259,"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":"12169467","event":"ball","batsman_id":"107312","bowler_id":"57478","over":"14","ball":"3","score":2,"commentary":"Tom Stewart Rogers to Ollie Price, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750277332,"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":"12169468","event":"ball","batsman_id":"107312","bowler_id":"57478","over":"14","ball":"4","score":0,"commentary":"Tom Stewart Rogers to Ollie Price, no run,","noball_dismissal":false,"text":"","timestamp":1750277335,"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":"12169475","event":"ball","batsman_id":"107312","bowler_id":"57478","over":"14","ball":"5","score":1,"commentary":"Tom Stewart Rogers to Ollie Price, 1 run,","noball_dismissal":false,"text":"","timestamp":1750277439,"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":"12169476","event":"ball","batsman_id":"49747","bowler_id":"57478","over":"14","ball":"6","score":1,"commentary":"Tom Stewart Rogers to Jack Taylor, 1 run,","noball_dismissal":false,"text":"","timestamp":1750277442,"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":15,"runs":6,"score":"123\/3","bats":[{"runs":28,"balls_faced":23,"fours":1,"sixes":1,"batsman_id":49747},{"runs":30,"balls_faced":24,"fours":0,"sixes":1,"batsman_id":107312}],"bowls":[{"runs_conceded":20,"maidens":0,"wickets":1,"bowler_id":57478,"overs":3},{"runs_conceded":27,"maidens":0,"wickets":1,"bowler_id":93789,"overs":4}],"commentary":"End of over 15 (6 runs), Gloucestershire 123\/3"},{"event_id":"12169479","event":"ball","batsman_id":"49747","bowler_id":"90888","over":"15","ball":"1","score":0,"commentary":"Fred Klaassen to Jack Taylor, no run,","noball_dismissal":false,"text":"","timestamp":1750277483,"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":"12169482","event":"ball","batsman_id":"49747","bowler_id":"90888","over":"15","ball":"2","score":2,"commentary":"Fred Klaassen to Jack Taylor, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750277501,"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":"12169489","event":"ball","batsman_id":"49747","bowler_id":"90888","over":"15","ball":"3","score":1,"commentary":"Fred Klaassen to Jack Taylor, 1 run,","noball_dismissal":false,"text":"","timestamp":1750277581,"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":"12169490","event":"ball","batsman_id":"107312","bowler_id":"90888","over":"15","ball":"4","score":4,"commentary":"Fred Klaassen to Ollie Price, Four,","noball_dismissal":false,"text":"","timestamp":1750277587,"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":"12169498","event":"ball","batsman_id":"107312","bowler_id":"90888","over":"15","ball":"5","score":1,"commentary":"Fred Klaassen to Ollie Price, 1 run,","noball_dismissal":false,"text":"","timestamp":1750277669,"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":"12169499","event":"ball","batsman_id":"49747","bowler_id":"90888","over":"15","ball":"6","score":4,"commentary":"Fred Klaassen to Jack Taylor, Four,","noball_dismissal":false,"text":"","timestamp":1750277673,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event":"overend","over":16,"runs":12,"score":"135\/3","bats":[{"runs":35,"balls_faced":27,"fours":2,"sixes":1,"batsman_id":49747},{"runs":35,"balls_faced":26,"fours":1,"sixes":1,"batsman_id":107312}],"bowls":[{"runs_conceded":30,"maidens":0,"wickets":0,"bowler_id":90888,"overs":3},{"runs_conceded":20,"maidens":0,"wickets":1,"bowler_id":57478,"overs":3}],"commentary":"End of over 16 (12 runs), Gloucestershire 135\/3"},{"event_id":"12169508","event":"ball","batsman_id":"107312","bowler_id":"48523","over":"16","ball":"1","score":1,"commentary":"Wes Agar to Ollie Price, 1 run,","noball_dismissal":false,"text":"","timestamp":1750277725,"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":"12169510","event":"ball","batsman_id":"49747","bowler_id":"48523","over":"16","ball":"2","score":6,"commentary":"Wes Agar to Jack Taylor, Six,","noball_dismissal":false,"text":"","timestamp":1750277734,"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":"12169513","event":"ball","batsman_id":"49747","bowler_id":"48523","over":"16","ball":"3","score":0,"commentary":"Wes Agar to Jack Taylor, no run,","noball_dismissal":false,"text":"","timestamp":1750277851,"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":"12169515","event":"ball","batsman_id":"49747","bowler_id":"48523","over":"16","ball":"4","score":1,"commentary":"Wes Agar to Jack Taylor, 1 run,","noball_dismissal":false,"text":"","timestamp":1750277854,"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":"12169517","event":"ball","batsman_id":"107312","bowler_id":"48523","over":"16","ball":"5","score":1,"commentary":"Wes Agar to Ollie Price, 1 run,","noball_dismissal":false,"text":"","timestamp":1750278178,"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":"12169521","event":"ball","batsman_id":"49747","bowler_id":"48523","over":"16","ball":"6","score":1,"commentary":"Wes Agar to Jack Taylor, 1 run,","noball_dismissal":false,"text":"","timestamp":1750278180,"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":17,"runs":10,"score":"145\/3","bats":[{"runs":43,"balls_faced":31,"fours":2,"sixes":2,"batsman_id":49747},{"runs":37,"balls_faced":28,"fours":1,"sixes":1,"batsman_id":107312}],"bowls":[{"runs_conceded":30,"maidens":0,"wickets":0,"bowler_id":48523,"overs":3},{"runs_conceded":30,"maidens":0,"wickets":0,"bowler_id":90888,"overs":3}],"commentary":"End of over 17 (10 runs), Gloucestershire 145\/3"},{"event_id":"12169529","event":"ball","batsman_id":"49747","bowler_id":"57478","over":"17","ball":"1","score":1,"commentary":"Tom Stewart Rogers to Jack Taylor, 1 run,","noball_dismissal":false,"text":"","timestamp":1750278183,"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":"12169540","event":"ball","batsman_id":"107312","bowler_id":"57478","over":"17","ball":"2","score":2,"commentary":"Tom Stewart Rogers to Ollie Price, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750278187,"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":"12169542","event":"ball","batsman_id":"107312","bowler_id":"57478","over":"17","ball":"3","score":1,"commentary":"Tom Stewart Rogers to Ollie Price, 1 run,","noball_dismissal":false,"text":"","timestamp":1750278208,"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":"12169544","event":"ball","batsman_id":"49747","bowler_id":"57478","over":"17","ball":"4","score":4,"commentary":"Tom Stewart Rogers to Jack Taylor, Four,","noball_dismissal":false,"text":"","timestamp":1750278211,"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":"12169552","event":"ball","batsman_id":"49747","bowler_id":"57478","over":"17","ball":"5","score":0,"commentary":"Tom Stewart Rogers to Jack Taylor, no run,","noball_dismissal":false,"text":"","timestamp":1750278215,"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":"12169554","event":"ball","batsman_id":"49747","bowler_id":"57478","over":"17","ball":"6","score":2,"commentary":"Tom Stewart Rogers to Jack Taylor, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750278217,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":18,"runs":10,"score":"155\/3","bats":[{"runs":50,"balls_faced":35,"fours":3,"sixes":2,"batsman_id":49747},{"runs":40,"balls_faced":30,"fours":1,"sixes":1,"batsman_id":107312}],"bowls":[{"runs_conceded":30,"maidens":0,"wickets":1,"bowler_id":57478,"overs":4},{"runs_conceded":30,"maidens":0,"wickets":0,"bowler_id":48523,"overs":3}],"commentary":"End of over 18 (10 runs), Gloucestershire 155\/3"},{"event_id":"12169557","event":"ball","batsman_id":"107312","bowler_id":"48523","over":"18","ball":"1","score":1,"commentary":"Wes Agar to Ollie Price, 1 run,","noball_dismissal":false,"text":"","timestamp":1750278257,"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":"12169558","event":"ball","batsman_id":"49747","bowler_id":"48523","over":"18","ball":"2","score":4,"commentary":"Wes Agar to Jack Taylor, Four,","noball_dismissal":false,"text":"","timestamp":1750278261,"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}],"day":"0","session":"0","live_inning":{"iid":198335,"number":2,"name":"Gloucestershire Inning","short_name":"GLO Inning","status":2,"issuperover":"false","result":3,"batting_team_id":7017,"fielding_team_id":104948,"scores":"160\/3","scores_full":"160\/3 (18.2 ov)","fielder":[{"fielder_id":"57478","fielder_name":"Tom Stewart Rogers","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"1943","fielder_name":"Sam Billings","catches":2,"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":"Miles Hammond","batsman_id":"49812","runs":"25","balls":"19","how_out":"c TS Rogers b MW Parkinson","score_at_dismissal":62,"overs_at_dismissal":"7.2","bowler_id":"93789","dismissal":"caught","number":3},"extra_runs":{"byes":0,"legbyes":0,"wides":2,"noballs":2,"penalty":"0","total":4},"equations":{"runs":160,"wickets":3,"overs":"18.2","bowlers_used":6,"runrate":"8.73"},"current_partnership":{"runs":98,"balls":67,"overs":11.1,"batsmen":[{"name":"Jack Taylor","batsman_id":49747,"runs":54,"balls":36},{"name":"Ollie Price","batsman_id":107312,"runs":41,"balls":31}]},"did_not_bat":[{"player_id":"88692","name":"Ben Charlesworth"},{"player_id":"47533","name":"Graeme van Buuren"},{"player_id":"50007","name":"Josh Shaw"},{"player_id":"16594","name":"Matt Taylor"},{"player_id":"49526","name":"David Payne"},{"player_id":"101483","name":"Ajeet Singh Dale"}],"max_over":"20","target":"158","recent_scores":"4,1,2,0,4,1,2,1,1,1,1,0,6,1,4,1,4,1","last_five_overs":"53\/0 10.60","last_ten_overs":"96\/0 9.29"},"teams":[{"tid":7017,"title":"Gloucestershire","abbr":"GLO","alt_name":"GLO","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-GLO@2x.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-GLO@2x.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"160\/3 (18.2 ov)","scores":"160\/3","overs":"18.2"},{"tid":104948,"title":"Kent","abbr":"KET","alt_name":"KET","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Kent.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Kent.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"157\/9 (20 ov)","scores":"157\/9","overs":"20"}],"players":[{"pid":847,"title":"Marchant de Lange","short_name":"MD Lange","first_name":"Marchant de Lange","last_name":"","middle_name":"","birthdate":"1990-10-13","birthplace":"Tzaneen, Limpopo","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Marchant90","instagram_profile":"https:\/\/www.instagram.com\/marchant.delange\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":1943,"title":"Sam Billings","short_name":"S Billings","first_name":"Sam Billings","last_name":"","middle_name":"","birthdate":"1991-06-15","birthplace":"Pembury, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/sambillingscricket\/","twitter_profile":"https:\/\/twitter.com\/sambillings","instagram_profile":"https:\/\/www.instagram.com\/sambillings\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK\/C)"},{"pid":10616,"title":"Jack Leaning","short_name":"JA Leaning","first_name":"Jack Leaning","last_name":"","middle_name":"","birthdate":"1993-10-18","birthplace":"Bristol","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"https:\/\/www.facebook.com\/jack.leaning.7\/","twitter_profile":"https:\/\/twitter.com\/JackLeaning1","instagram_profile":"https:\/\/www.instagram.com\/jack_leaning\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":16594,"title":"Matt Taylor","short_name":"MD Taylor","first_name":"Matt Taylor","last_name":"","middle_name":"","birthdate":"1994-07-08","birthplace":"Banbury, Oxfordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":16644,"title":"Matthew Quinn","short_name":"MR Quinn","first_name":"Matthew Quinn","last_name":"","middle_name":"","birthdate":"1993-02-28","birthplace":"Auckland","country":"nz","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/CoachQuinn19","instagram_profile":"https:\/\/www.instagram.com\/matthewrquinn\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"squad","role_str":""},{"pid":43395,"title":"Daniel Bell-Drummond","short_name":"DJ Bell-Drummond","first_name":"Daniel Bell-Drummond","last_name":"","middle_name":"","birthdate":"1993-08-04","birthplace":"Lewisham, London","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/deebzz23","instagram_profile":"https:\/\/www.instagram.com\/deebzz23\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":43563,"title":"Cameron Bancroft","short_name":"CT Bancroft","first_name":"Cameron Bancroft","last_name":"","middle_name":"","birthdate":"1992-11-19","birthplace":" Attadale, Australia","country":"au","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper ","recent_match":18968,"recent_appearance":1514244600,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/cbancroft4\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"wk","role_str":"(WK)"},{"pid":47533,"title":"Graeme van Buuren","short_name":"GL Buuren","first_name":"Graeme van Buuren","last_name":"","middle_name":"","birthdate":"1990-08-22","birthplace":"Pretoria, Transvaal","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/graemegvb\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":48416,"title":"Nathan Gilchrist","short_name":"NN Gilchrist","first_name":"Nathan Gilchrist","last_name":"","middle_name":"","birthdate":"2000-06-11","birthplace":"Harare","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"https:\/\/www.facebook.com\/nathan.gilchrist.94\/","twitter_profile":"https:\/\/twitter.com\/nathgilchrist","instagram_profile":"https:\/\/www.instagram.com\/nathanngilchrist\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":48523,"title":"Wes Agar","short_name":"WA Agar","first_name":"Wes Agar","last_name":"","middle_name":"","birthdate":"1997-02-05","birthplace":"Malvern, Victoria","country":"au","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/wesagar13\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"bowl","role_str":""},{"pid":49519,"title":"Chris Dent","short_name":"CDJ Dent","first_name":"Chris Dent","last_name":"","middle_name":"","birthdate":"1991-01-20","birthplace":"Bristol","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"Occasional Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Cdent15","instagram_profile":"https:\/\/www.instagram.com\/chrisdent15\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49526,"title":"David Payne","short_name":"DA Payne","first_name":"David Payne","last_name":"","middle_name":"","birthdate":"1991-02-15","birthplace":"Poole, Dorset","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/DavidPayne_14","instagram_profile":"https:\/\/www.instagram.com\/sidpayne14\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":49613,"title":"Joe Denly","short_name":"JL Denly","first_name":"Joe Denly","last_name":"","middle_name":"","birthdate":"1986-03-16","birthplace":"Canterbury, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/joed1986","instagram_profile":"https:\/\/www.instagram.com\/joe.denly\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49747,"title":"Jack Taylor","short_name":"JMR Taylor","first_name":"Jack Taylor","last_name":"","middle_name":"","birthdate":"1991-11-12","birthplace":"Banbury, Oxfordshire","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"pid":49809,"title":"Harry Finch","short_name":"HZ Finch","first_name":"Harry Finch","last_name":"","middle_name":"","birthdate":"1995-02-10","birthplace":"Hastings, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/f1nchy07","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":""},{"pid":49812,"title":"Miles Hammond","short_name":"MAH Hammond","first_name":"Miles Hammond","last_name":"","middle_name":"","birthdate":"1996-01-11","birthplace":"Cheltenham, Gloucestershire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/milesAHH","instagram_profile":"https:\/\/www.instagram.com\/hammo_gram\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":50007,"title":"Josh Shaw","short_name":"J Shaw","first_name":"Josh Shaw","last_name":"","middle_name":"","birthdate":"1996-01-03","birthplace":"Wakefield, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/joshuashaw1","instagram_profile":"https:\/\/www.instagram.com\/joshshaw5931\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":50425,"title":"James Bracey","short_name":"JR Bracey","first_name":"James Bracey","last_name":"","middle_name":"","birthdate":"1997-05-03","birthplace":"Bristol","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/james_bracey\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50774,"title":"Zak Crawley","short_name":"Z Crawley","first_name":"Zak Crawley","last_name":"","middle_name":"","birthdate":"1998-02-03","birthplace":"Bromley, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/CrawleyZak\/","twitter_profile":"https:\/\/twitter.com\/ZakCrawleyFan","instagram_profile":"https:\/\/www.instagram.com\/crawley1993\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":57478,"title":"Tom Stewart Rogers","short_name":"TS Rogers","first_name":"Tom Stewart Rogers","last_name":"","middle_name":"","birthdate":"1994-03-03","birthplace":"Bruce, Australian Capital Territory","country":"au","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/tomyrogers\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"bowl","role_str":""},{"pid":58686,"title":"Tom Smith","short_name":"TC Smith","first_name":"Tom Smith","last_name":"","middle_name":"","birthdate":"1987-08-29","birthplace":"Liverpool","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/tmjsmith6\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":84301,"title":"D''Arcy Short","short_name":"DJM Short","first_name":"D''Arcy Short","last_name":"","middle_name":"","birthdate":"1990-08-09","birthplace":" Katherine, Northern Territory","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":18958,"recent_appearance":1517646000,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/shortyjnr23\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"all","role_str":""},{"pid":88692,"title":"Ben Charlesworth","short_name":"BG Charlesworth","first_name":"Ben Charlesworth","last_name":"","middle_name":"","birthdate":"2000-11-19","birthplace":"Oxford","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/bencharlesworth_\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":90888,"title":"Fred Klaassen","short_name":"FJ Klaassen","first_name":"Fred Klaassen","last_name":"","middle_name":"","birthdate":"1992-11-13","birthplace":" Haywards Heath, Sussex","country":"nl","primary_team":{"tid":1824,"name":"","short_name":""},"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/freddieklaassen","instagram_profile":"https:\/\/www.instagram.com\/fredklaassen\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"bowl","role_str":""},{"pid":92837,"title":"Michael Cohen","short_name":"MA Cohen","first_name":"Michael Cohen","last_name":"","middle_name":"","birthdate":"1998-08-04","birthplace":"","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":92940,"title":"Grant Stewart","short_name":"G Stewart","first_name":"Grant Stewart","last_name":"","middle_name":"","birthdate":"1994-02-19","birthplace":"Kalgoorlie, Western Australia","country":"it","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/gstewart195\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Italy","role":"all","role_str":""},{"pid":93130,"title":"Cameron Green","short_name":"C Green","first_name":"Cameron Green","last_name":"","middle_name":"","birthdate":"1999-06-03","birthplace":"Perth, 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":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/CameronGreen_","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":93789,"title":"Matt Parkinson","short_name":"MW Parkinson","first_name":"Matt Parkinson","last_name":"","middle_name":"","birthdate":"1996-10-24","birthplace":"Bolton, Lancashire","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":7.5,"facebook_profile":"https:\/\/www.facebook.com\/matt.read.7311\/","twitter_profile":"https:\/\/twitter.com\/mattyparky96","instagram_profile":"https:\/\/www.instagram.com\/77parky\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":94983,"title":"Marcus O''Riordan","short_name":"M O''Riordan","first_name":"Marcus O''Riordan","last_name":"","middle_name":"","birthdate":"1998-01-25","birthplace":" Pembury, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95478,"title":"Tom Price","short_name":"TJ Price","first_name":"Tom Price","last_name":"","middle_name":"","birthdate":"2000-01-02","birthplace":"Oxford, United Kingdom","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":95553,"title":"Joey Evison","short_name":"J Evison","first_name":"Joey Evison","last_name":"","middle_name":"","birthdate":"2001-11-14","birthplace":" Peterborough, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/EvisonJoey","instagram_profile":"https:\/\/www.instagram.com\/joeyevison\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":95891,"title":"George Garrett","short_name":"G Garrett","first_name":"George Garrett","last_name":"","middle_name":"","birthdate":"2000-03-04","birthplace":" Harpenden, Hertfordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium Fast","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":96058,"title":"Ben Compton","short_name":"B Compton","first_name":"Ben Compton","last_name":"","middle_name":"","birthdate":"1994-03-29","birthplace":"Durban, Natal","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":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/bcompt4","instagram_profile":"https:\/\/www.instagram.com\/bencompton42\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":101483,"title":"Ajeet Singh Dale","short_name":"Ajeet Singh Dale","first_name":"Ajeet Singh Dale","last_name":"","middle_name":"","birthdate":"2000-07-02","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":107311,"title":"Dominic Goodman","short_name":"DC Goodman","first_name":"Dominic Goodman","last_name":"","middle_name":"","birthdate":"2000-10-23","birthplace":"Ashford, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/domgoodman_\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":107312,"title":"Ollie Price","short_name":"O Price","first_name":"Ollie Price","last_name":"","middle_name":"","birthdate":"2001-06-12","birthplace":"Oxford","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":107792,"title":"Tawanda Muyeye","short_name":"T Muyeye","first_name":"Tawanda Muyeye","last_name":"","middle_name":"","birthdate":"2001-03-05","birthplace":"Harare, Mashonaland","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/tawanda.muyeye\/","twitter_profile":"https:\/\/twitter.com\/MuyeyeTawanda","instagram_profile":"https:\/\/www.instagram.com\/tawanda.muyeye\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":108444,"title":"Chris Benjamin","short_name":"C Benjamin","first_name":"Chris Benjamin","last_name":"","middle_name":"","birthdate":"1999-04-29","birthplace":"Johannesburg, Gauteng","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/chrisbenj_12","instagram_profile":"https:\/\/www.instagram.com\/chris.benjamin\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":109132,"title":"Jas Singh","short_name":"J Singh","first_name":"Jas Singh","last_name":"","middle_name":"","birthdate":"2002-09-19","birthplace":"Denmark Hill, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":110606,"title":"Zaman Akhter","short_name":"Z Akhter","first_name":"Zaman Akhter","last_name":"","middle_name":"","birthdate":"1999-03-12","birthplace":"Cambridge","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":116662,"title":"Luke Charlesworth","short_name":"LA Charlesworth","first_name":"Luke Charlesworth","last_name":"","middle_name":"","birthdate":"2003-04-04","birthplace":"Oxford","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":118935,"title":"Tommy Boorman","short_name":"Tommy Boorman","first_name":"Tommy Boorman","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":127440,"title":"Joe Phillips","short_name":"JP Phillips","first_name":"Joe Phillips","last_name":"","middle_name":"","birthdate":"2003-11-09","birthplace":"Truro, Cornwall","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":130195,"title":"Jaydn Denly","short_name":"JK Denly","first_name":"Jaydn Denly","last_name":"","middle_name":"","birthdate":"2006-01-05","birthplace":"","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":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":130759,"title":"Ahmed Mujtaba Syed","short_name":"A Mujtaba Syed","first_name":"Ahmed Mujtaba Syed","last_name":"","middle_name":"","birthdate":"2004-09-26","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":130760,"title":"Edward Middleton","short_name":"Ed Middleton","first_name":"Edward Middleton","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":139986,"title":"Archie Bailey","short_name":"A Bailey","first_name":"Archie Bailey","last_name":"","middle_name":"","birthdate":"2005-06-28","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":141025,"title":"Ekansh Singh","short_name":"E Singh","first_name":"Ekansh Singh","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":148657,"title":"Corey Flintoff","short_name":"C Flintoff","first_name":"Corey Flintoff","last_name":"","middle_name":"","birthdate":"2006-03-08","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":149124,"title":"Aman Rao","short_name":"Aman Rao","first_name":"Aman Rao","last_name":"","middle_name":"","birthdate":"2004-06-22","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""}]},"etag":"7fbb426f4e76549fcb44765b23d3b19b","modified":"2025-07-17 19:46:55","datetime":"2025-07-17 19:46:55","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":86880,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Gloucestershire won by 7 wickets","day_remaining_over":"","team_batting":"Gloucestershire","team_bowling":"Kent","live_inning_number":2,"live_score":{"runs":160,"overs":18.2,"wickets":3,"target":158,"runrate":8.73,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Jack Taylor","batsman_id":49747,"runs":54,"balls_faced":36,"fours":4,"sixes":2,"strike_rate":"150.00"},{"name":"Ollie Price","batsman_id":107312,"runs":41,"balls_faced":31,"fours":1,"sixes":1,"strike_rate":"132.26"}],"bowlers":[{"name":"Wes Agar","bowler_id":48523,"overs":3.2,"runs_conceded":36,"wickets":0,"maidens":0,"econ":"10.80"},{"name":"Tom Stewart Rogers","bowler_id":57478,"overs":4,"runs_conceded":30,"wickets":1,"maidens":0,"econ":"7.50"}],"commentaries":[{"event":"overend","over":14,"runs":12,"score":"117\/3","bats":[{"runs":26,"balls_faced":20,"fours":0,"sixes":1,"batsman_id":107312},{"runs":26,"balls_faced":21,"fours":1,"sixes":1,"batsman_id":49747}],"bowls":[{"runs_conceded":27,"maidens":0,"wickets":1,"bowler_id":93789,"overs":4},{"runs_conceded":28,"maidens":0,"wickets":1,"bowler_id":95553,"overs":3}],"commentary":"End of over 14 (12 runs), Gloucestershire 117\/3"},{"event_id":"12169458","event":"ball","batsman_id":"107312","bowler_id":"57478","over":"14","ball":"1","score":1,"commentary":"Tom Stewart Rogers to Ollie Price, 1 run,","noball_dismissal":false,"text":"","timestamp":1750277238,"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":"12169462","event":"ball","batsman_id":"49747","bowler_id":"57478","over":"14","ball":"2","score":1,"commentary":"Tom Stewart Rogers to Jack Taylor, 1 run,","noball_dismissal":false,"text":"","timestamp":1750277259,"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":"12169467","event":"ball","batsman_id":"107312","bowler_id":"57478","over":"14","ball":"3","score":2,"commentary":"Tom Stewart Rogers to Ollie Price, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750277332,"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":"12169468","event":"ball","batsman_id":"107312","bowler_id":"57478","over":"14","ball":"4","score":0,"commentary":"Tom Stewart Rogers to Ollie Price, no run,","noball_dismissal":false,"text":"","timestamp":1750277335,"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":"12169475","event":"ball","batsman_id":"107312","bowler_id":"57478","over":"14","ball":"5","score":1,"commentary":"Tom Stewart Rogers to Ollie Price, 1 run,","noball_dismissal":false,"text":"","timestamp":1750277439,"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":"12169476","event":"ball","batsman_id":"49747","bowler_id":"57478","over":"14","ball":"6","score":1,"commentary":"Tom Stewart Rogers to Jack Taylor, 1 run,","noball_dismissal":false,"text":"","timestamp":1750277442,"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":15,"runs":6,"score":"123\/3","bats":[{"runs":28,"balls_faced":23,"fours":1,"sixes":1,"batsman_id":49747},{"runs":30,"balls_faced":24,"fours":0,"sixes":1,"batsman_id":107312}],"bowls":[{"runs_conceded":20,"maidens":0,"wickets":1,"bowler_id":57478,"overs":3},{"runs_conceded":27,"maidens":0,"wickets":1,"bowler_id":93789,"overs":4}],"commentary":"End of over 15 (6 runs), Gloucestershire 123\/3"},{"event_id":"12169479","event":"ball","batsman_id":"49747","bowler_id":"90888","over":"15","ball":"1","score":0,"commentary":"Fred Klaassen to Jack Taylor, no run,","noball_dismissal":false,"text":"","timestamp":1750277483,"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":"12169482","event":"ball","batsman_id":"49747","bowler_id":"90888","over":"15","ball":"2","score":2,"commentary":"Fred Klaassen to Jack Taylor, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750277501,"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":"12169489","event":"ball","batsman_id":"49747","bowler_id":"90888","over":"15","ball":"3","score":1,"commentary":"Fred Klaassen to Jack Taylor, 1 run,","noball_dismissal":false,"text":"","timestamp":1750277581,"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":"12169490","event":"ball","batsman_id":"107312","bowler_id":"90888","over":"15","ball":"4","score":4,"commentary":"Fred Klaassen to Ollie Price, Four,","noball_dismissal":false,"text":"","timestamp":1750277587,"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":"12169498","event":"ball","batsman_id":"107312","bowler_id":"90888","over":"15","ball":"5","score":1,"commentary":"Fred Klaassen to Ollie Price, 1 run,","noball_dismissal":false,"text":"","timestamp":1750277669,"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":"12169499","event":"ball","batsman_id":"49747","bowler_id":"90888","over":"15","ball":"6","score":4,"commentary":"Fred Klaassen to Jack Taylor, Four,","noball_dismissal":false,"text":"","timestamp":1750277673,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event":"overend","over":16,"runs":12,"score":"135\/3","bats":[{"runs":35,"balls_faced":27,"fours":2,"sixes":1,"batsman_id":49747},{"runs":35,"balls_faced":26,"fours":1,"sixes":1,"batsman_id":107312}],"bowls":[{"runs_conceded":30,"maidens":0,"wickets":0,"bowler_id":90888,"overs":3},{"runs_conceded":20,"maidens":0,"wickets":1,"bowler_id":57478,"overs":3}],"commentary":"End of over 16 (12 runs), Gloucestershire 135\/3"},{"event_id":"12169508","event":"ball","batsman_id":"107312","bowler_id":"48523","over":"16","ball":"1","score":1,"commentary":"Wes Agar to Ollie Price, 1 run,","noball_dismissal":false,"text":"","timestamp":1750277725,"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":"12169510","event":"ball","batsman_id":"49747","bowler_id":"48523","over":"16","ball":"2","score":6,"commentary":"Wes Agar to Jack Taylor, Six,","noball_dismissal":false,"text":"","timestamp":1750277734,"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":"12169513","event":"ball","batsman_id":"49747","bowler_id":"48523","over":"16","ball":"3","score":0,"commentary":"Wes Agar to Jack Taylor, no run,","noball_dismissal":false,"text":"","timestamp":1750277851,"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":"12169515","event":"ball","batsman_id":"49747","bowler_id":"48523","over":"16","ball":"4","score":1,"commentary":"Wes Agar to Jack Taylor, 1 run,","noball_dismissal":false,"text":"","timestamp":1750277854,"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":"12169517","event":"ball","batsman_id":"107312","bowler_id":"48523","over":"16","ball":"5","score":1,"commentary":"Wes Agar to Ollie Price, 1 run,","noball_dismissal":false,"text":"","timestamp":1750278178,"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":"12169521","event":"ball","batsman_id":"49747","bowler_id":"48523","over":"16","ball":"6","score":1,"commentary":"Wes Agar to Jack Taylor, 1 run,","noball_dismissal":false,"text":"","timestamp":1750278180,"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":17,"runs":10,"score":"145\/3","bats":[{"runs":43,"balls_faced":31,"fours":2,"sixes":2,"batsman_id":49747},{"runs":37,"balls_faced":28,"fours":1,"sixes":1,"batsman_id":107312}],"bowls":[{"runs_conceded":30,"maidens":0,"wickets":0,"bowler_id":48523,"overs":3},{"runs_conceded":30,"maidens":0,"wickets":0,"bowler_id":90888,"overs":3}],"commentary":"End of over 17 (10 runs), Gloucestershire 145\/3"},{"event_id":"12169529","event":"ball","batsman_id":"49747","bowler_id":"57478","over":"17","ball":"1","score":1,"commentary":"Tom Stewart Rogers to Jack Taylor, 1 run,","noball_dismissal":false,"text":"","timestamp":1750278183,"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":"12169540","event":"ball","batsman_id":"107312","bowler_id":"57478","over":"17","ball":"2","score":2,"commentary":"Tom Stewart Rogers to Ollie Price, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750278187,"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":"12169542","event":"ball","batsman_id":"107312","bowler_id":"57478","over":"17","ball":"3","score":1,"commentary":"Tom Stewart Rogers to Ollie Price, 1 run,","noball_dismissal":false,"text":"","timestamp":1750278208,"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":"12169544","event":"ball","batsman_id":"49747","bowler_id":"57478","over":"17","ball":"4","score":4,"commentary":"Tom Stewart Rogers to Jack Taylor, Four,","noball_dismissal":false,"text":"","timestamp":1750278211,"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":"12169552","event":"ball","batsman_id":"49747","bowler_id":"57478","over":"17","ball":"5","score":0,"commentary":"Tom Stewart Rogers to Jack Taylor, no run,","noball_dismissal":false,"text":"","timestamp":1750278215,"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":"12169554","event":"ball","batsman_id":"49747","bowler_id":"57478","over":"17","ball":"6","score":2,"commentary":"Tom Stewart Rogers to Jack Taylor, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750278217,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":18,"runs":10,"score":"155\/3","bats":[{"runs":50,"balls_faced":35,"fours":3,"sixes":2,"batsman_id":49747},{"runs":40,"balls_faced":30,"fours":1,"sixes":1,"batsman_id":107312}],"bowls":[{"runs_conceded":30,"maidens":0,"wickets":1,"bowler_id":57478,"overs":4},{"runs_conceded":30,"maidens":0,"wickets":0,"bowler_id":48523,"overs":3}],"commentary":"End of over 18 (10 runs), Gloucestershire 155\/3"},{"event_id":"12169557","event":"ball","batsman_id":"107312","bowler_id":"48523","over":"18","ball":"1","score":1,"commentary":"Wes Agar to Ollie Price, 1 run,","noball_dismissal":false,"text":"","timestamp":1750278257,"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":"12169558","event":"ball","batsman_id":"49747","bowler_id":"48523","over":"18","ball":"2","score":4,"commentary":"Wes Agar to Jack Taylor, Four,","noball_dismissal":false,"text":"","timestamp":1750278261,"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}],"day":"0","session":"0","live_inning":{"iid":198335,"number":2,"name":"Gloucestershire Inning","short_name":"GLO Inning","status":2,"issuperover":"false","result":3,"batting_team_id":7017,"fielding_team_id":104948,"scores":"160\/3","scores_full":"160\/3 (18.2 ov)","fielder":[{"fielder_id":"57478","fielder_name":"Tom Stewart Rogers","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"1943","fielder_name":"Sam Billings","catches":2,"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":"Miles Hammond","batsman_id":"49812","runs":"25","balls":"19","how_out":"c TS Rogers b MW Parkinson","score_at_dismissal":62,"overs_at_dismissal":"7.2","bowler_id":"93789","dismissal":"caught","number":3},"extra_runs":{"byes":0,"legbyes":0,"wides":2,"noballs":2,"penalty":"0","total":4},"equations":{"runs":160,"wickets":3,"overs":"18.2","bowlers_used":6,"runrate":"8.73"},"current_partnership":{"runs":98,"balls":67,"overs":11.1,"batsmen":[{"name":"Jack Taylor","batsman_id":49747,"runs":54,"balls":36},{"name":"Ollie Price","batsman_id":107312,"runs":41,"balls":31}]},"did_not_bat":[{"player_id":"88692","name":"Ben Charlesworth"},{"player_id":"47533","name":"Graeme van Buuren"},{"player_id":"50007","name":"Josh Shaw"},{"player_id":"16594","name":"Matt Taylor"},{"player_id":"49526","name":"David Payne"},{"player_id":"101483","name":"Ajeet Singh Dale"}],"max_over":"20","target":"158","recent_scores":"4,1,2,0,4,1,2,1,1,1,1,0,6,1,4,1,4,1","last_five_overs":"53\/0 10.60","last_ten_overs":"96\/0 9.29"},"teams":[{"tid":7017,"title":"Gloucestershire","abbr":"GLO","alt_name":"GLO","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-GLO@2x.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-GLO@2x.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"160\/3 (18.2 ov)","scores":"160\/3","overs":"18.2"},{"tid":104948,"title":"Kent","abbr":"KET","alt_name":"KET","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Kent.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Kent.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"157\/9 (20 ov)","scores":"157\/9","overs":"20"}],"players":[{"pid":847,"title":"Marchant de Lange","short_name":"MD Lange","first_name":"Marchant de Lange","last_name":"","middle_name":"","birthdate":"1990-10-13","birthplace":"Tzaneen, Limpopo","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Marchant90","instagram_profile":"https:\/\/www.instagram.com\/marchant.delange\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":1943,"title":"Sam Billings","short_name":"S Billings","first_name":"Sam Billings","last_name":"","middle_name":"","birthdate":"1991-06-15","birthplace":"Pembury, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/sambillingscricket\/","twitter_profile":"https:\/\/twitter.com\/sambillings","instagram_profile":"https:\/\/www.instagram.com\/sambillings\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK\/C)"},{"pid":10616,"title":"Jack Leaning","short_name":"JA Leaning","first_name":"Jack Leaning","last_name":"","middle_name":"","birthdate":"1993-10-18","birthplace":"Bristol","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"https:\/\/www.facebook.com\/jack.leaning.7\/","twitter_profile":"https:\/\/twitter.com\/JackLeaning1","instagram_profile":"https:\/\/www.instagram.com\/jack_leaning\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":16594,"title":"Matt Taylor","short_name":"MD Taylor","first_name":"Matt Taylor","last_name":"","middle_name":"","birthdate":"1994-07-08","birthplace":"Banbury, Oxfordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":16644,"title":"Matthew Quinn","short_name":"MR Quinn","first_name":"Matthew Quinn","last_name":"","middle_name":"","birthdate":"1993-02-28","birthplace":"Auckland","country":"nz","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/CoachQuinn19","instagram_profile":"https:\/\/www.instagram.com\/matthewrquinn\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"squad","role_str":""},{"pid":43395,"title":"Daniel Bell-Drummond","short_name":"DJ Bell-Drummond","first_name":"Daniel Bell-Drummond","last_name":"","middle_name":"","birthdate":"1993-08-04","birthplace":"Lewisham, London","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/deebzz23","instagram_profile":"https:\/\/www.instagram.com\/deebzz23\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":43563,"title":"Cameron Bancroft","short_name":"CT Bancroft","first_name":"Cameron Bancroft","last_name":"","middle_name":"","birthdate":"1992-11-19","birthplace":" Attadale, Australia","country":"au","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper ","recent_match":18968,"recent_appearance":1514244600,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/cbancroft4\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"wk","role_str":"(WK)"},{"pid":47533,"title":"Graeme van Buuren","short_name":"GL Buuren","first_name":"Graeme van Buuren","last_name":"","middle_name":"","birthdate":"1990-08-22","birthplace":"Pretoria, Transvaal","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/graemegvb\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":48416,"title":"Nathan Gilchrist","short_name":"NN Gilchrist","first_name":"Nathan Gilchrist","last_name":"","middle_name":"","birthdate":"2000-06-11","birthplace":"Harare","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"https:\/\/www.facebook.com\/nathan.gilchrist.94\/","twitter_profile":"https:\/\/twitter.com\/nathgilchrist","instagram_profile":"https:\/\/www.instagram.com\/nathanngilchrist\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":48523,"title":"Wes Agar","short_name":"WA Agar","first_name":"Wes Agar","last_name":"","middle_name":"","birthdate":"1997-02-05","birthplace":"Malvern, Victoria","country":"au","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/wesagar13\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"bowl","role_str":""},{"pid":49519,"title":"Chris Dent","short_name":"CDJ Dent","first_name":"Chris Dent","last_name":"","middle_name":"","birthdate":"1991-01-20","birthplace":"Bristol","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"Occasional Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Cdent15","instagram_profile":"https:\/\/www.instagram.com\/chrisdent15\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49526,"title":"David Payne","short_name":"DA Payne","first_name":"David Payne","last_name":"","middle_name":"","birthdate":"1991-02-15","birthplace":"Poole, Dorset","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/DavidPayne_14","instagram_profile":"https:\/\/www.instagram.com\/sidpayne14\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":49613,"title":"Joe Denly","short_name":"JL Denly","first_name":"Joe Denly","last_name":"","middle_name":"","birthdate":"1986-03-16","birthplace":"Canterbury, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/joed1986","instagram_profile":"https:\/\/www.instagram.com\/joe.denly\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49747,"title":"Jack Taylor","short_name":"JMR Taylor","first_name":"Jack Taylor","last_name":"","middle_name":"","birthdate":"1991-11-12","birthplace":"Banbury, Oxfordshire","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"pid":49809,"title":"Harry Finch","short_name":"HZ Finch","first_name":"Harry Finch","last_name":"","middle_name":"","birthdate":"1995-02-10","birthplace":"Hastings, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/f1nchy07","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":""},{"pid":49812,"title":"Miles Hammond","short_name":"MAH Hammond","first_name":"Miles Hammond","last_name":"","middle_name":"","birthdate":"1996-01-11","birthplace":"Cheltenham, Gloucestershire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/milesAHH","instagram_profile":"https:\/\/www.instagram.com\/hammo_gram\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":50007,"title":"Josh Shaw","short_name":"J Shaw","first_name":"Josh Shaw","last_name":"","middle_name":"","birthdate":"1996-01-03","birthplace":"Wakefield, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/joshuashaw1","instagram_profile":"https:\/\/www.instagram.com\/joshshaw5931\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":50425,"title":"James Bracey","short_name":"JR Bracey","first_name":"James Bracey","last_name":"","middle_name":"","birthdate":"1997-05-03","birthplace":"Bristol","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/james_bracey\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50774,"title":"Zak Crawley","short_name":"Z Crawley","first_name":"Zak Crawley","last_name":"","middle_name":"","birthdate":"1998-02-03","birthplace":"Bromley, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/CrawleyZak\/","twitter_profile":"https:\/\/twitter.com\/ZakCrawleyFan","instagram_profile":"https:\/\/www.instagram.com\/crawley1993\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":57478,"title":"Tom Stewart Rogers","short_name":"TS Rogers","first_name":"Tom Stewart Rogers","last_name":"","middle_name":"","birthdate":"1994-03-03","birthplace":"Bruce, Australian Capital Territory","country":"au","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/tomyrogers\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"bowl","role_str":""},{"pid":58686,"title":"Tom Smith","short_name":"TC Smith","first_name":"Tom Smith","last_name":"","middle_name":"","birthdate":"1987-08-29","birthplace":"Liverpool","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/tmjsmith6\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":84301,"title":"D''Arcy Short","short_name":"DJM Short","first_name":"D''Arcy Short","last_name":"","middle_name":"","birthdate":"1990-08-09","birthplace":" Katherine, Northern Territory","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":18958,"recent_appearance":1517646000,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/shortyjnr23\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"all","role_str":""},{"pid":88692,"title":"Ben Charlesworth","short_name":"BG Charlesworth","first_name":"Ben Charlesworth","last_name":"","middle_name":"","birthdate":"2000-11-19","birthplace":"Oxford","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/bencharlesworth_\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":90888,"title":"Fred Klaassen","short_name":"FJ Klaassen","first_name":"Fred Klaassen","last_name":"","middle_name":"","birthdate":"1992-11-13","birthplace":" Haywards Heath, Sussex","country":"nl","primary_team":{"tid":1824,"name":"","short_name":""},"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/freddieklaassen","instagram_profile":"https:\/\/www.instagram.com\/fredklaassen\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"bowl","role_str":""},{"pid":92837,"title":"Michael Cohen","short_name":"MA Cohen","first_name":"Michael Cohen","last_name":"","middle_name":"","birthdate":"1998-08-04","birthplace":"","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":92940,"title":"Grant Stewart","short_name":"G Stewart","first_name":"Grant Stewart","last_name":"","middle_name":"","birthdate":"1994-02-19","birthplace":"Kalgoorlie, Western Australia","country":"it","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/gstewart195\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Italy","role":"all","role_str":""},{"pid":93130,"title":"Cameron Green","short_name":"C Green","first_name":"Cameron Green","last_name":"","middle_name":"","birthdate":"1999-06-03","birthplace":"Perth, 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":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/CameronGreen_","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":93789,"title":"Matt Parkinson","short_name":"MW Parkinson","first_name":"Matt Parkinson","last_name":"","middle_name":"","birthdate":"1996-10-24","birthplace":"Bolton, Lancashire","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":7.5,"facebook_profile":"https:\/\/www.facebook.com\/matt.read.7311\/","twitter_profile":"https:\/\/twitter.com\/mattyparky96","instagram_profile":"https:\/\/www.instagram.com\/77parky\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":94983,"title":"Marcus O''Riordan","short_name":"M O''Riordan","first_name":"Marcus O''Riordan","last_name":"","middle_name":"","birthdate":"1998-01-25","birthplace":" Pembury, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95478,"title":"Tom Price","short_name":"TJ Price","first_name":"Tom Price","last_name":"","middle_name":"","birthdate":"2000-01-02","birthplace":"Oxford, United Kingdom","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":95553,"title":"Joey Evison","short_name":"J Evison","first_name":"Joey Evison","last_name":"","middle_name":"","birthdate":"2001-11-14","birthplace":" Peterborough, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/EvisonJoey","instagram_profile":"https:\/\/www.instagram.com\/joeyevison\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":95891,"title":"George Garrett","short_name":"G Garrett","first_name":"George Garrett","last_name":"","middle_name":"","birthdate":"2000-03-04","birthplace":" Harpenden, Hertfordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium Fast","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":96058,"title":"Ben Compton","short_name":"B Compton","first_name":"Ben Compton","last_name":"","middle_name":"","birthdate":"1994-03-29","birthplace":"Durban, Natal","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":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/bcompt4","instagram_profile":"https:\/\/www.instagram.com\/bencompton42\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":101483,"title":"Ajeet Singh Dale","short_name":"Ajeet Singh Dale","first_name":"Ajeet Singh Dale","last_name":"","middle_name":"","birthdate":"2000-07-02","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":107311,"title":"Dominic Goodman","short_name":"DC Goodman","first_name":"Dominic Goodman","last_name":"","middle_name":"","birthdate":"2000-10-23","birthplace":"Ashford, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/domgoodman_\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":107312,"title":"Ollie Price","short_name":"O Price","first_name":"Ollie Price","last_name":"","middle_name":"","birthdate":"2001-06-12","birthplace":"Oxford","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":107792,"title":"Tawanda Muyeye","short_name":"T Muyeye","first_name":"Tawanda Muyeye","last_name":"","middle_name":"","birthdate":"2001-03-05","birthplace":"Harare, Mashonaland","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/tawanda.muyeye\/","twitter_profile":"https:\/\/twitter.com\/MuyeyeTawanda","instagram_profile":"https:\/\/www.instagram.com\/tawanda.muyeye\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":108444,"title":"Chris Benjamin","short_name":"C Benjamin","first_name":"Chris Benjamin","last_name":"","middle_name":"","birthdate":"1999-04-29","birthplace":"Johannesburg, Gauteng","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/chrisbenj_12","instagram_profile":"https:\/\/www.instagram.com\/chris.benjamin\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":109132,"title":"Jas Singh","short_name":"J Singh","first_name":"Jas Singh","last_name":"","middle_name":"","birthdate":"2002-09-19","birthplace":"Denmark Hill, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":110606,"title":"Zaman Akhter","short_name":"Z Akhter","first_name":"Zaman Akhter","last_name":"","middle_name":"","birthdate":"1999-03-12","birthplace":"Cambridge","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":116662,"title":"Luke Charlesworth","short_name":"LA Charlesworth","first_name":"Luke Charlesworth","last_name":"","middle_name":"","birthdate":"2003-04-04","birthplace":"Oxford","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":118935,"title":"Tommy Boorman","short_name":"Tommy Boorman","first_name":"Tommy Boorman","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":127440,"title":"Joe Phillips","short_name":"JP Phillips","first_name":"Joe Phillips","last_name":"","middle_name":"","birthdate":"2003-11-09","birthplace":"Truro, Cornwall","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":130195,"title":"Jaydn Denly","short_name":"JK Denly","first_name":"Jaydn Denly","last_name":"","middle_name":"","birthdate":"2006-01-05","birthplace":"","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":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":130759,"title":"Ahmed Mujtaba Syed","short_name":"A Mujtaba Syed","first_name":"Ahmed Mujtaba Syed","last_name":"","middle_name":"","birthdate":"2004-09-26","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":130760,"title":"Edward Middleton","short_name":"Ed Middleton","first_name":"Edward Middleton","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":139986,"title":"Archie Bailey","short_name":"A Bailey","first_name":"Archie Bailey","last_name":"","middle_name":"","birthdate":"2005-06-28","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":141025,"title":"Ekansh Singh","short_name":"E Singh","first_name":"Ekansh Singh","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":148657,"title":"Corey Flintoff","short_name":"C Flintoff","first_name":"Corey Flintoff","last_name":"","middle_name":"","birthdate":"2006-03-08","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":149124,"title":"Aman Rao","short_name":"Aman Rao","first_name":"Aman Rao","last_name":"","middle_name":"","birthdate":"2004-06-22","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""}]},"etag":"7fbb426f4e76549fcb44765b23d3b19b","modified":"2025-07-17 19:46:55","datetime":"2025-07-17 19:46:55","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86880 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:dc207bcf-5c1b-4cca-8b75-f9e5e1d0e78f
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86880 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86880,3,'{"status":"ok","response":{"match_id":86880,"title":"Kent vs Gloucestershire","short_title":"KET vs GLO","subtitle":"Match 60","match_number":"60","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Gloucestershire won by 7 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129425,"title":"Vitality Blast","abbr":"Vitality Blast","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-09-13","country":"en","total_matches":"133","total_rounds":"2","total_teams":"18"},"teama":{"team_id":104948,"name":"Kent","short_name":"KET","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Kent.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Kent.png","scores_full":"157\/9 (20 ov)","scores":"157\/9","overs":"20"},"teamb":{"team_id":7017,"name":"Gloucestershire","short_name":"GLO","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-GLO@2x.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-GLO@2x.png","scores_full":"160\/3 (18.2 ov)","scores":"160\/3","overs":"18.2"},"date_start":"2025-06-18 17:30:00","date_end":"2025-06-19 03:30:00","timestamp_start":1750267800,"timestamp_end":1750303800,"date_start_ist":"2025-06-18 23:00:00","date_end_ist":"2025-06-19 09:00:00","venue":{"venue_id":"50","name":"St Lawrence Ground","location":"Canterbury","country":"England","timezone":""},"umpires":"Nigel Llong (England), Mark Newell (England)","referee":"Peter Such (England)","equation":"","live":"","result":"GLO won by 7 wickets","result_type":2,"win_margin":"7 wickets","winning_team_id":7017,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-15 21:53:35","verify_time":"2025-06-19 02:08:38","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clear","weather_desc":"clear sky","temp":20.21,"humidity":76,"visibility":10000,"wind_speed":"6.78","clouds":8},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Kent elected to bat","winner":104948,"decision":1}},"etag":"ab7004d4d608b2e06b42967a730c61b6","modified":"2025-07-17 19:46:56","datetime":"2025-07-17 19:46:56","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":86880,"title":"Kent vs Gloucestershire","short_title":"KET vs GLO","subtitle":"Match 60","match_number":"60","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Gloucestershire won by 7 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129425,"title":"Vitality Blast","abbr":"Vitality Blast","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-09-13","country":"en","total_matches":"133","total_rounds":"2","total_teams":"18"},"teama":{"team_id":104948,"name":"Kent","short_name":"KET","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Kent.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Kent.png","scores_full":"157\/9 (20 ov)","scores":"157\/9","overs":"20"},"teamb":{"team_id":7017,"name":"Gloucestershire","short_name":"GLO","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-GLO@2x.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-GLO@2x.png","scores_full":"160\/3 (18.2 ov)","scores":"160\/3","overs":"18.2"},"date_start":"2025-06-18 17:30:00","date_end":"2025-06-19 03:30:00","timestamp_start":1750267800,"timestamp_end":1750303800,"date_start_ist":"2025-06-18 23:00:00","date_end_ist":"2025-06-19 09:00:00","venue":{"venue_id":"50","name":"St Lawrence Ground","location":"Canterbury","country":"England","timezone":""},"umpires":"Nigel Llong (England), Mark Newell (England)","referee":"Peter Such (England)","equation":"","live":"","result":"GLO won by 7 wickets","result_type":2,"win_margin":"7 wickets","winning_team_id":7017,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-15 21:53:35","verify_time":"2025-06-19 02:08:38","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clear","weather_desc":"clear sky","temp":20.21,"humidity":76,"visibility":10000,"wind_speed":"6.78","clouds":8},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Kent elected to bat","winner":104948,"decision":1}},"etag":"ab7004d4d608b2e06b42967a730c61b6","modified":"2025-07-17 19:46:56","datetime":"2025-07-17 19:46:56","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86880 AND DataTypeId = 3 END Live Report & Scorecard of Kent vs Gloucestershire Match 60
Kent vs Gloucestershire, Live Cricket Commentary