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:6ac64cf9-426c-40c6-af7b-97d61ea5efbc Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 88188 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (88188,1,'{"status":"ok","response":{"mid":88188,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Match Drawn","day_remaining_over":"-6","team_batting":"Derbyshire","team_bowling":"Gloucestershire","live_inning_number":4,"live_score":{"runs":296,"overs":66.5,"wickets":8,"target":316,"runrate":4.43,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Anuj Dal","batsman_id":50528,"runs":36,"balls_faced":68,"fours":2,"sixes":0,"strike_rate":"52.94"},{"name":"Ben William Aitchison","batsman_id":101484,"runs":7,"balls_faced":15,"fours":1,"sixes":0,"strike_rate":"46.67"}],"bowlers":[{"name":"Graeme van Buuren","bowler_id":47533,"overs":18.5,"runs_conceded":64,"wickets":4,"maidens":1,"econ":"3.40"},{"name":"Todd Murphy","bowler_id":95486,"overs":27,"runs_conceded":114,"wickets":2,"maidens":2,"econ":"4.22"}],"commentaries":[{"event_id":"12227131","event":"ball","batsman_id":"101484","bowler_id":"47533","over":"62","ball":"3","score":0,"commentary":"Graeme van Buuren to Ben William Aitchison, no run,","noball_dismissal":false,"text":"","timestamp":1750871246,"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":"12227139","event":"ball","batsman_id":"101484","bowler_id":"47533","over":"62","ball":"4","score":0,"commentary":"Graeme van Buuren to Ben William Aitchison, no run,","noball_dismissal":false,"text":"","timestamp":1750871266,"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":"12227143","event":"ball","batsman_id":"101484","bowler_id":"47533","over":"62","ball":"5","score":1,"commentary":"Graeme van Buuren to Ben William Aitchison, 1 run,","noball_dismissal":false,"text":"","timestamp":1750871270,"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":"12227144","event":"ball","batsman_id":"50528","bowler_id":"47533","over":"62","ball":"6","score":0,"commentary":"Graeme van Buuren to Anuj Dal, no run,","noball_dismissal":false,"text":"","timestamp":1750871273,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":63,"runs":2,"score":"288\/8","bats":[{"runs":33,"balls_faced":51,"fours":2,"sixes":0,"batsman_id":50528},{"runs":2,"balls_faced":9,"fours":0,"sixes":0,"batsman_id":101484}],"bowls":[{"runs_conceded":59,"maidens":1,"wickets":4,"bowler_id":47533,"overs":17},{"runs_conceded":111,"maidens":2,"wickets":2,"bowler_id":95486,"overs":25}],"commentary":"End of over 63 (2 runs), Derbyshire 288\/8"},{"event_id":"12227161","event":"ball","batsman_id":"101484","bowler_id":"95486","over":"63","ball":"1","score":0,"commentary":"Todd Murphy to Ben William Aitchison, no run,","noball_dismissal":false,"text":"","timestamp":1750871352,"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":"12227167","event":"ball","batsman_id":"101484","bowler_id":"95486","over":"63","ball":"2","score":1,"commentary":"Todd Murphy to Ben William Aitchison, 1 run,","noball_dismissal":false,"text":"","timestamp":1750871401,"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":"12227173","event":"ball","batsman_id":"50528","bowler_id":"95486","over":"63","ball":"3","score":0,"commentary":"Todd Murphy to Anuj Dal, no run,","noball_dismissal":false,"text":"","timestamp":1750871443,"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":"12227180","event":"ball","batsman_id":"50528","bowler_id":"95486","over":"63","ball":"4","score":0,"commentary":"Todd Murphy to Anuj Dal, no run,","noball_dismissal":false,"text":"","timestamp":1750871486,"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":"12227181","event":"ball","batsman_id":"50528","bowler_id":"95486","over":"63","ball":"5","score":1,"commentary":"Todd Murphy to Anuj Dal, 1 run,","noball_dismissal":false,"text":"","timestamp":1750871491,"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":"12227188","event":"ball","batsman_id":"101484","bowler_id":"95486","over":"63","ball":"6","score":0,"commentary":"Todd Murphy to Ben William Aitchison, no run,","noball_dismissal":false,"text":"","timestamp":1750871536,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":64,"runs":2,"score":"290\/8","bats":[{"runs":3,"balls_faced":12,"fours":0,"sixes":0,"batsman_id":101484},{"runs":34,"balls_faced":54,"fours":2,"sixes":0,"batsman_id":50528}],"bowls":[{"runs_conceded":113,"maidens":2,"wickets":2,"bowler_id":95486,"overs":26},{"runs_conceded":59,"maidens":1,"wickets":4,"bowler_id":47533,"overs":17}],"commentary":"End of over 64 (2 runs), Derbyshire 290\/8"},{"event_id":"12227200","event":"ball","batsman_id":"50528","bowler_id":"47533","over":"64","ball":"1","score":0,"commentary":"Graeme van Buuren to Anuj Dal, no run,","noball_dismissal":false,"text":"","timestamp":1750871616,"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":"12227212","event":"ball","batsman_id":"50528","bowler_id":"47533","over":"64","ball":"2","score":0,"commentary":"Graeme van Buuren to Anuj Dal, no run,","noball_dismissal":false,"text":"","timestamp":1750871735,"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":"12227213","event":"ball","batsman_id":"50528","bowler_id":"47533","over":"64","ball":"3","score":0,"commentary":"Graeme van Buuren to Anuj Dal, no run,","noball_dismissal":false,"text":"","timestamp":1750871742,"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":"12227214","event":"ball","batsman_id":"50528","bowler_id":"47533","over":"64","ball":"4","score":1,"commentary":"Graeme van Buuren to Anuj Dal, 1 run,","noball_dismissal":false,"text":"","timestamp":1750871746,"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":"12227215","event":"ball","batsman_id":"101484","bowler_id":"47533","over":"64","ball":"5","score":0,"commentary":"Graeme van Buuren to Ben William Aitchison, no run,","noball_dismissal":false,"text":"","timestamp":1750871750,"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":"12227219","event":"ball","batsman_id":"101484","bowler_id":"47533","over":"64","ball":"6","score":4,"commentary":"Graeme van Buuren to Ben William Aitchison, Four,","noball_dismissal":false,"text":"","timestamp":1750871760,"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":65,"runs":5,"score":"295\/8","bats":[{"runs":7,"balls_faced":14,"fours":1,"sixes":0,"batsman_id":101484},{"runs":35,"balls_faced":58,"fours":2,"sixes":0,"batsman_id":50528}],"bowls":[{"runs_conceded":64,"maidens":1,"wickets":4,"bowler_id":47533,"overs":18},{"runs_conceded":113,"maidens":2,"wickets":2,"bowler_id":95486,"overs":26}],"commentary":"End of over 65 (5 runs), Derbyshire 295\/8"},{"event_id":"12227227","event":"ball","batsman_id":"50528","bowler_id":"95486","over":"65","ball":"1","score":0,"commentary":"Todd Murphy to Anuj Dal, no run,","noball_dismissal":false,"text":"","timestamp":1750871882,"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":"12227229","event":"ball","batsman_id":"50528","bowler_id":"95486","over":"65","ball":"2","score":0,"commentary":"Todd Murphy to Anuj Dal, no run,","noball_dismissal":false,"text":"","timestamp":1750871891,"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":"12227230","event":"ball","batsman_id":"50528","bowler_id":"95486","over":"65","ball":"3","score":0,"commentary":"Todd Murphy to Anuj Dal, no run,","noball_dismissal":false,"text":"","timestamp":1750871895,"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":"12227241","event":"ball","batsman_id":"50528","bowler_id":"95486","over":"65","ball":"4","score":0,"commentary":"Todd Murphy to Anuj Dal, no run,","noball_dismissal":false,"text":"","timestamp":1750871961,"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":"12227248","event":"ball","batsman_id":"50528","bowler_id":"95486","over":"65","ball":"5","score":1,"commentary":"Todd Murphy to Anuj Dal, 1 run,","noball_dismissal":false,"text":"","timestamp":1750872004,"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":"12227253","event":"ball","batsman_id":"101484","bowler_id":"95486","over":"65","ball":"6","score":0,"commentary":"Todd Murphy to Ben William Aitchison, no run,","noball_dismissal":false,"text":"","timestamp":1750872035,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":66,"runs":1,"score":"296\/8","bats":[{"runs":7,"balls_faced":15,"fours":1,"sixes":0,"batsman_id":101484},{"runs":36,"balls_faced":63,"fours":2,"sixes":0,"batsman_id":50528}],"bowls":[{"runs_conceded":114,"maidens":2,"wickets":2,"bowler_id":95486,"overs":27},{"runs_conceded":64,"maidens":1,"wickets":4,"bowler_id":47533,"overs":18}],"commentary":"End of over 66 (1 runs), Derbyshire 296\/8"},{"event_id":"12227265","event":"ball","batsman_id":"50528","bowler_id":"47533","over":"66","ball":"1","score":0,"commentary":"Graeme van Buuren to Anuj Dal, no run,","noball_dismissal":false,"text":"","timestamp":1750872735,"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":"12227266","event":"ball","batsman_id":"50528","bowler_id":"47533","over":"66","ball":"2","score":0,"commentary":"Graeme van Buuren to Anuj Dal, no run,","noball_dismissal":false,"text":"","timestamp":1750872739,"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":"12227267","event":"ball","batsman_id":"50528","bowler_id":"47533","over":"66","ball":"3","score":0,"commentary":"Graeme van Buuren to Anuj Dal, no run,","noball_dismissal":false,"text":"","timestamp":1750872741,"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":"12227268","event":"ball","batsman_id":"50528","bowler_id":"47533","over":"66","ball":"4","score":0,"commentary":"Graeme van Buuren to Anuj Dal, no run,","noball_dismissal":false,"text":"","timestamp":1750872744,"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":"12227269","event":"ball","batsman_id":"50528","bowler_id":"47533","over":"66","ball":"5","score":0,"commentary":"Graeme van Buuren to Anuj Dal, no run,","noball_dismissal":false,"text":"","timestamp":1750872747,"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}],"day":"4","session":"0","live_inning":{"iid":198728,"number":4,"name":" Derbyshire 2nd Inning","short_name":" DER 2nd Inning","status":2,"issuperover":"false","result":4,"batting_team_id":104949,"fielding_team_id":7017,"scores":"296\/8","scores_full":"296\/8 (66.5 ov)","fielder":[{"fielder_id":"49812","fielder_name":"Miles Hammond","catches":3,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"50425","fielder_name":"James Bracey","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"127440","fielder_name":"Joe Phillips","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":[],"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"David Lloyd","batsman_id":"7735","runs":"9","balls":"20","how_out":"lbw b GL Buuren","score_at_dismissal":283,"overs_at_dismissal":"60.3","bowler_id":"47533","dismissal":"lbw","number":8},"extra_runs":{"byes":4,"legbyes":3,"wides":1,"noballs":0,"penalty":"0","total":8},"equations":{"runs":296,"wickets":8,"overs":"66.5","bowlers_used":6,"runrate":"4.43"},"current_partnership":{"runs":13,"balls":38,"overs":6.2,"batsmen":[{"name":"Ben William Aitchison","batsman_id":101484,"runs":7,"balls":15},{"name":"Anuj Dal","batsman_id":50528,"runs":6,"balls":23}]},"did_not_bat":[{"player_id":"94963","name":"Jack Morley"}],"max_over":"0","target":"316","recent_scores":"0,0,0,0,0,0,1,0,0,0,0,4,0,1,0,0,0,0","last_five_overs":"10\/0 2.00","last_ten_overs":"25\/1 2.50"},"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":"187\/10 (59.2 ov) & 526\/6d (147 ov)","scores":"187\/10 & 526\/6d","overs":"59.2 & 147"},{"tid":104949,"title":"Derbyshire","abbr":"DER","alt_name":"DER","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/derbyshire-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/derbyshire-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"398\/10 (105.5 ov) & 296\/8 (66.5 ov)","scores":"398\/10 & 296\/8","overs":"105.5 & 66.5"}],"players":[{"pid":69,"title":"Suranga Lakmal","short_name":"S Lakmal","first_name":"Suranga Lakmal","last_name":"","middle_name":"","birthdate":"1987-03-10","birthplace":"Matara","country":"lk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/SurangaLakmalOfficial\/","twitter_profile":"https:\/\/twitter.com\/surangalk1987","instagram_profile":"https:\/\/www.instagram.com\/surangal709\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Sri Lanka","role":"squad","role_str":""},{"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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":1818,"title":"Mark Watt","short_name":"M Watt","first_name":"Mark Watt","last_name":"","middle_name":"","birthdate":"1996-07-29","birthplace":"Eastern General Hospital, Edinburgh","country":"sct","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":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/markwatt123","instagram_profile":"https:\/\/www.instagram.com\/mark_watt1\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Scotland","role":"squad","role_str":""},{"pid":1909,"title":"Paul van Meekeren","short_name":"P Meekeren","first_name":"Paul van Meekeren","last_name":"","middle_name":"","birthdate":"1993-01-15","birthplace":"Amsterdam, Netherlands","country":"nl","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/paulvanmeekeren","instagram_profile":"https:\/\/www.instagram.com\/pvm47\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"squad","role_str":""},{"pid":7735,"title":"David Lloyd","short_name":"DL Lloyd","first_name":"David Lloyd","last_name":"","middle_name":"","birthdate":"1992-06-15","birthplace":"St Asaph, Flintshire, Wales","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/davidlloyduk\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"wk","role_str":"(C)"},{"pid":43580,"title":"Marcus Harris","short_name":"MS Harris","first_name":"Marcus Harris","last_name":"","middle_name":"","birthdate":"1992-07-21","birthplace":"Perth, Australia","country":"au","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/marcusharris14\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":46310,"title":"Blair Tickner","short_name":"BM Tickner","first_name":"Blair Tickner","last_name":"","middle_name":"","birthdate":"1993-10-13","birthplace":"Napier, Hawke''s Bay","country":"nz","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/blair.tickner\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/ticks93\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"squad","role_str":""},{"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":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":48428,"title":"Luis Reece","short_name":"LM Reece","first_name":"Luis Reece","last_name":"","middle_name":"","birthdate":"1990-08-04","birthplace":"Taunton, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lreece17","instagram_profile":"https:\/\/www.instagram.com\/louisreece\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":48498,"title":"Caleb Jewell","short_name":"CP Jewell","first_name":"Caleb Jewell","last_name":"","middle_name":"","birthdate":"1997-04-21","birthplace":"Hobart, Tasmania","country":"au","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/caleb.jewell.148\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/cjewell_32\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"bat","role_str":""},{"pid":48508,"title":"Brooke Guest","short_name":"BD Guest","first_name":"Brooke Guest","last_name":"","middle_name":"","birthdate":"1997-05-14","birthplace":"Whitworth Park, Manchester, England","country":"au","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/guesty211\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"wk","role_str":"(WK)"},{"pid":48641,"title":"Wayne Madsen","short_name":"WL Madsen","first_name":"Wayne Madsen","last_name":"","middle_name":"","birthdate":"1984-01-02","birthplace":"Durban","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/waynemadders77","instagram_profile":"https:\/\/www.instagram.com\/waynemadsen77\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"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":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49607,"title":"Billy Godleman","short_name":"BA Godleman","first_name":"Billy Godleman","last_name":"","middle_name":"","birthdate":"1989-02-11","birthplace":"Camden, London","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/billboi00","instagram_profile":"","debut_data":"","bowling_type":"Spin","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":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49808,"title":"Zak Chappell","short_name":"ZJ Chappell","first_name":"Zak Chappell","last_name":"","middle_name":"","birthdate":"1996-08-21","birthplace":"Grantham, Lincolnshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/chappooo","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","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":"","bowling_type":"Spin","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":50433,"title":"Alex Thomson","short_name":"AT Thomson","first_name":"Alex Thomson","last_name":"","middle_name":"","birthdate":"1993-10-30","birthplace":"Stoke-on-Trent, Staffordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/alextomo","instagram_profile":"https:\/\/www.instagram.com\/alex_thomson_racing\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":50528,"title":"Anuj Dal","short_name":"AK Dal","first_name":"Anuj Dal","last_name":"","middle_name":"","birthdate":"1996-07-08","birthplace":"Newcastle-under-Lyme, Staffordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/AnujDal","instagram_profile":"https:\/\/www.instagram.com\/anujdal0\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":51064,"title":"Martin Andersson","short_name":"MK Andersson","first_name":"Martin Andersson","last_name":"","middle_name":"","birthdate":"1996-09-06","birthplace":"Reading, Berkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/MartinAnderss11","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":62695,"title":"Matthew Lamb","short_name":"M Lamb","first_name":"Matthew Lamb","last_name":"","middle_name":"","birthdate":"1996-07-19","birthplace":"Wolverhampton, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/MattLamb96","instagram_profile":"https:\/\/www.instagram.com\/lambagramz\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":90974,"title":"Henry Brookes","short_name":"HJH Brookes","first_name":"Henry Brookes","last_name":"","middle_name":"","birthdate":"1999-08-21","birthplace":"Solihull, Warwickshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BrookesHenry","instagram_profile":"https:\/\/www.instagram.com\/henry.brookes\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":94962,"title":"Harry Came","short_name":"H Came","first_name":"Harry Came","last_name":"","middle_name":"","birthdate":"1998-08-27","birthplace":"Hampshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/HarryCame4","instagram_profile":"https:\/\/www.instagram.com\/harrycame4\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":94963,"title":"Jack Morley","short_name":"J Morley","first_name":"Jack Morley","last_name":"","middle_name":"","birthdate":"2001-06-25","birthplace":"Rochdale, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":95302,"title":"Haider Ali","short_name":"H Ali","first_name":"Haider Ali","last_name":"","middle_name":"","birthdate":"2000-10-02","birthplace":"Attock","country":"pk","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/iamhaideraly","instagram_profile":"https:\/\/www.instagram.com\/malik_haideralikhan\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Pakistan","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95486,"title":"Todd Murphy","short_name":"TR Murphy","first_name":"Todd Murphy","last_name":"","middle_name":"","birthdate":"2000-11-15","birthplace":" Echuca, Victoria","country":"au","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/todd.murphy.5682\/","twitter_profile":"https:\/\/twitter.com\/ToddMur82405592","instagram_profile":"https:\/\/www.instagram.com\/toddmurphy9\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Australia","role":"bowl","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":101484,"title":"Ben William Aitchison","short_name":"B W Aitchison","first_name":"Ben William Aitchison","last_name":"","middle_name":"","birthdate":"1999-07-06","birthplace":"Southport, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Benaitchison123","instagram_profile":"https:\/\/www.instagram.com\/baitchison13\/","debut_data":"","bowling_type":"Pace","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":"","bowling_type":"Pace","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":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":109363,"title":"Mitchell Wagstaff","short_name":"M Wagstaff","first_name":"Mitchell Wagstaff","last_name":"","middle_name":"","birthdate":"2003-09-02","birthplace":"Derby","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/mitchellwaggy?lang=en","instagram_profile":"https:\/\/www.instagram.com\/mitchellwagstaff\/?hl=en","debut_data":"","bowling_type":"Spin","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":118504,"title":"Allah Mohammad Ghazanfar","short_name":"AM Ghazanfar","first_name":"Allah Mohammad Ghazanfar","last_name":"","middle_name":"","birthdate":"2007-07-15","birthplace":"","country":"af","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/Ghazanfar050\/","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Afghanistan","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":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":130162,"title":"Harry Moore","short_name":"HJ Moore","first_name":"Harry Moore","last_name":"","middle_name":"","birthdate":"2007-04-26","birthplace":"Houston, Florida","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/ha66y2004","instagram_profile":"https:\/\/www.instagram.com\/harrymoore72\/","debut_data":"","bowling_type":"Pace","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""}]},"etag":"cdaaea36e50c886e058fb2817fe7ee7e","modified":"2025-07-13 05:41:49","datetime":"2025-07-13 05:41:49","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":88188,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Match Drawn","day_remaining_over":"-6","team_batting":"Derbyshire","team_bowling":"Gloucestershire","live_inning_number":4,"live_score":{"runs":296,"overs":66.5,"wickets":8,"target":316,"runrate":4.43,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Anuj Dal","batsman_id":50528,"runs":36,"balls_faced":68,"fours":2,"sixes":0,"strike_rate":"52.94"},{"name":"Ben William Aitchison","batsman_id":101484,"runs":7,"balls_faced":15,"fours":1,"sixes":0,"strike_rate":"46.67"}],"bowlers":[{"name":"Graeme van Buuren","bowler_id":47533,"overs":18.5,"runs_conceded":64,"wickets":4,"maidens":1,"econ":"3.40"},{"name":"Todd Murphy","bowler_id":95486,"overs":27,"runs_conceded":114,"wickets":2,"maidens":2,"econ":"4.22"}],"commentaries":[{"event_id":"12227131","event":"ball","batsman_id":"101484","bowler_id":"47533","over":"62","ball":"3","score":0,"commentary":"Graeme van Buuren to Ben William Aitchison, no run,","noball_dismissal":false,"text":"","timestamp":1750871246,"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":"12227139","event":"ball","batsman_id":"101484","bowler_id":"47533","over":"62","ball":"4","score":0,"commentary":"Graeme van Buuren to Ben William Aitchison, no run,","noball_dismissal":false,"text":"","timestamp":1750871266,"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":"12227143","event":"ball","batsman_id":"101484","bowler_id":"47533","over":"62","ball":"5","score":1,"commentary":"Graeme van Buuren to Ben William Aitchison, 1 run,","noball_dismissal":false,"text":"","timestamp":1750871270,"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":"12227144","event":"ball","batsman_id":"50528","bowler_id":"47533","over":"62","ball":"6","score":0,"commentary":"Graeme van Buuren to Anuj Dal, no run,","noball_dismissal":false,"text":"","timestamp":1750871273,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":63,"runs":2,"score":"288\/8","bats":[{"runs":33,"balls_faced":51,"fours":2,"sixes":0,"batsman_id":50528},{"runs":2,"balls_faced":9,"fours":0,"sixes":0,"batsman_id":101484}],"bowls":[{"runs_conceded":59,"maidens":1,"wickets":4,"bowler_id":47533,"overs":17},{"runs_conceded":111,"maidens":2,"wickets":2,"bowler_id":95486,"overs":25}],"commentary":"End of over 63 (2 runs), Derbyshire 288\/8"},{"event_id":"12227161","event":"ball","batsman_id":"101484","bowler_id":"95486","over":"63","ball":"1","score":0,"commentary":"Todd Murphy to Ben William Aitchison, no run,","noball_dismissal":false,"text":"","timestamp":1750871352,"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":"12227167","event":"ball","batsman_id":"101484","bowler_id":"95486","over":"63","ball":"2","score":1,"commentary":"Todd Murphy to Ben William Aitchison, 1 run,","noball_dismissal":false,"text":"","timestamp":1750871401,"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":"12227173","event":"ball","batsman_id":"50528","bowler_id":"95486","over":"63","ball":"3","score":0,"commentary":"Todd Murphy to Anuj Dal, no run,","noball_dismissal":false,"text":"","timestamp":1750871443,"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":"12227180","event":"ball","batsman_id":"50528","bowler_id":"95486","over":"63","ball":"4","score":0,"commentary":"Todd Murphy to Anuj Dal, no run,","noball_dismissal":false,"text":"","timestamp":1750871486,"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":"12227181","event":"ball","batsman_id":"50528","bowler_id":"95486","over":"63","ball":"5","score":1,"commentary":"Todd Murphy to Anuj Dal, 1 run,","noball_dismissal":false,"text":"","timestamp":1750871491,"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":"12227188","event":"ball","batsman_id":"101484","bowler_id":"95486","over":"63","ball":"6","score":0,"commentary":"Todd Murphy to Ben William Aitchison, no run,","noball_dismissal":false,"text":"","timestamp":1750871536,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":64,"runs":2,"score":"290\/8","bats":[{"runs":3,"balls_faced":12,"fours":0,"sixes":0,"batsman_id":101484},{"runs":34,"balls_faced":54,"fours":2,"sixes":0,"batsman_id":50528}],"bowls":[{"runs_conceded":113,"maidens":2,"wickets":2,"bowler_id":95486,"overs":26},{"runs_conceded":59,"maidens":1,"wickets":4,"bowler_id":47533,"overs":17}],"commentary":"End of over 64 (2 runs), Derbyshire 290\/8"},{"event_id":"12227200","event":"ball","batsman_id":"50528","bowler_id":"47533","over":"64","ball":"1","score":0,"commentary":"Graeme van Buuren to Anuj Dal, no run,","noball_dismissal":false,"text":"","timestamp":1750871616,"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":"12227212","event":"ball","batsman_id":"50528","bowler_id":"47533","over":"64","ball":"2","score":0,"commentary":"Graeme van Buuren to Anuj Dal, no run,","noball_dismissal":false,"text":"","timestamp":1750871735,"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":"12227213","event":"ball","batsman_id":"50528","bowler_id":"47533","over":"64","ball":"3","score":0,"commentary":"Graeme van Buuren to Anuj Dal, no run,","noball_dismissal":false,"text":"","timestamp":1750871742,"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":"12227214","event":"ball","batsman_id":"50528","bowler_id":"47533","over":"64","ball":"4","score":1,"commentary":"Graeme van Buuren to Anuj Dal, 1 run,","noball_dismissal":false,"text":"","timestamp":1750871746,"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":"12227215","event":"ball","batsman_id":"101484","bowler_id":"47533","over":"64","ball":"5","score":0,"commentary":"Graeme van Buuren to Ben William Aitchison, no run,","noball_dismissal":false,"text":"","timestamp":1750871750,"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":"12227219","event":"ball","batsman_id":"101484","bowler_id":"47533","over":"64","ball":"6","score":4,"commentary":"Graeme van Buuren to Ben William Aitchison, Four,","noball_dismissal":false,"text":"","timestamp":1750871760,"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":65,"runs":5,"score":"295\/8","bats":[{"runs":7,"balls_faced":14,"fours":1,"sixes":0,"batsman_id":101484},{"runs":35,"balls_faced":58,"fours":2,"sixes":0,"batsman_id":50528}],"bowls":[{"runs_conceded":64,"maidens":1,"wickets":4,"bowler_id":47533,"overs":18},{"runs_conceded":113,"maidens":2,"wickets":2,"bowler_id":95486,"overs":26}],"commentary":"End of over 65 (5 runs), Derbyshire 295\/8"},{"event_id":"12227227","event":"ball","batsman_id":"50528","bowler_id":"95486","over":"65","ball":"1","score":0,"commentary":"Todd Murphy to Anuj Dal, no run,","noball_dismissal":false,"text":"","timestamp":1750871882,"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":"12227229","event":"ball","batsman_id":"50528","bowler_id":"95486","over":"65","ball":"2","score":0,"commentary":"Todd Murphy to Anuj Dal, no run,","noball_dismissal":false,"text":"","timestamp":1750871891,"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":"12227230","event":"ball","batsman_id":"50528","bowler_id":"95486","over":"65","ball":"3","score":0,"commentary":"Todd Murphy to Anuj Dal, no run,","noball_dismissal":false,"text":"","timestamp":1750871895,"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":"12227241","event":"ball","batsman_id":"50528","bowler_id":"95486","over":"65","ball":"4","score":0,"commentary":"Todd Murphy to Anuj Dal, no run,","noball_dismissal":false,"text":"","timestamp":1750871961,"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":"12227248","event":"ball","batsman_id":"50528","bowler_id":"95486","over":"65","ball":"5","score":1,"commentary":"Todd Murphy to Anuj Dal, 1 run,","noball_dismissal":false,"text":"","timestamp":1750872004,"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":"12227253","event":"ball","batsman_id":"101484","bowler_id":"95486","over":"65","ball":"6","score":0,"commentary":"Todd Murphy to Ben William Aitchison, no run,","noball_dismissal":false,"text":"","timestamp":1750872035,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":66,"runs":1,"score":"296\/8","bats":[{"runs":7,"balls_faced":15,"fours":1,"sixes":0,"batsman_id":101484},{"runs":36,"balls_faced":63,"fours":2,"sixes":0,"batsman_id":50528}],"bowls":[{"runs_conceded":114,"maidens":2,"wickets":2,"bowler_id":95486,"overs":27},{"runs_conceded":64,"maidens":1,"wickets":4,"bowler_id":47533,"overs":18}],"commentary":"End of over 66 (1 runs), Derbyshire 296\/8"},{"event_id":"12227265","event":"ball","batsman_id":"50528","bowler_id":"47533","over":"66","ball":"1","score":0,"commentary":"Graeme van Buuren to Anuj Dal, no run,","noball_dismissal":false,"text":"","timestamp":1750872735,"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":"12227266","event":"ball","batsman_id":"50528","bowler_id":"47533","over":"66","ball":"2","score":0,"commentary":"Graeme van Buuren to Anuj Dal, no run,","noball_dismissal":false,"text":"","timestamp":1750872739,"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":"12227267","event":"ball","batsman_id":"50528","bowler_id":"47533","over":"66","ball":"3","score":0,"commentary":"Graeme van Buuren to Anuj Dal, no run,","noball_dismissal":false,"text":"","timestamp":1750872741,"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":"12227268","event":"ball","batsman_id":"50528","bowler_id":"47533","over":"66","ball":"4","score":0,"commentary":"Graeme van Buuren to Anuj Dal, no run,","noball_dismissal":false,"text":"","timestamp":1750872744,"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":"12227269","event":"ball","batsman_id":"50528","bowler_id":"47533","over":"66","ball":"5","score":0,"commentary":"Graeme van Buuren to Anuj Dal, no run,","noball_dismissal":false,"text":"","timestamp":1750872747,"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}],"day":"4","session":"0","live_inning":{"iid":198728,"number":4,"name":" Derbyshire 2nd Inning","short_name":" DER 2nd Inning","status":2,"issuperover":"false","result":4,"batting_team_id":104949,"fielding_team_id":7017,"scores":"296\/8","scores_full":"296\/8 (66.5 ov)","fielder":[{"fielder_id":"49812","fielder_name":"Miles Hammond","catches":3,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"50425","fielder_name":"James Bracey","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"127440","fielder_name":"Joe Phillips","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":[],"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"David Lloyd","batsman_id":"7735","runs":"9","balls":"20","how_out":"lbw b GL Buuren","score_at_dismissal":283,"overs_at_dismissal":"60.3","bowler_id":"47533","dismissal":"lbw","number":8},"extra_runs":{"byes":4,"legbyes":3,"wides":1,"noballs":0,"penalty":"0","total":8},"equations":{"runs":296,"wickets":8,"overs":"66.5","bowlers_used":6,"runrate":"4.43"},"current_partnership":{"runs":13,"balls":38,"overs":6.2,"batsmen":[{"name":"Ben William Aitchison","batsman_id":101484,"runs":7,"balls":15},{"name":"Anuj Dal","batsman_id":50528,"runs":6,"balls":23}]},"did_not_bat":[{"player_id":"94963","name":"Jack Morley"}],"max_over":"0","target":"316","recent_scores":"0,0,0,0,0,0,1,0,0,0,0,4,0,1,0,0,0,0","last_five_overs":"10\/0 2.00","last_ten_overs":"25\/1 2.50"},"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":"187\/10 (59.2 ov) & 526\/6d (147 ov)","scores":"187\/10 & 526\/6d","overs":"59.2 & 147"},{"tid":104949,"title":"Derbyshire","abbr":"DER","alt_name":"DER","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/derbyshire-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/derbyshire-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"398\/10 (105.5 ov) & 296\/8 (66.5 ov)","scores":"398\/10 & 296\/8","overs":"105.5 & 66.5"}],"players":[{"pid":69,"title":"Suranga Lakmal","short_name":"S Lakmal","first_name":"Suranga Lakmal","last_name":"","middle_name":"","birthdate":"1987-03-10","birthplace":"Matara","country":"lk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/SurangaLakmalOfficial\/","twitter_profile":"https:\/\/twitter.com\/surangalk1987","instagram_profile":"https:\/\/www.instagram.com\/surangal709\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Sri Lanka","role":"squad","role_str":""},{"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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":1818,"title":"Mark Watt","short_name":"M Watt","first_name":"Mark Watt","last_name":"","middle_name":"","birthdate":"1996-07-29","birthplace":"Eastern General Hospital, Edinburgh","country":"sct","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":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/markwatt123","instagram_profile":"https:\/\/www.instagram.com\/mark_watt1\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Scotland","role":"squad","role_str":""},{"pid":1909,"title":"Paul van Meekeren","short_name":"P Meekeren","first_name":"Paul van Meekeren","last_name":"","middle_name":"","birthdate":"1993-01-15","birthplace":"Amsterdam, Netherlands","country":"nl","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/paulvanmeekeren","instagram_profile":"https:\/\/www.instagram.com\/pvm47\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"squad","role_str":""},{"pid":7735,"title":"David Lloyd","short_name":"DL Lloyd","first_name":"David Lloyd","last_name":"","middle_name":"","birthdate":"1992-06-15","birthplace":"St Asaph, Flintshire, Wales","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/davidlloyduk\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"wk","role_str":"(C)"},{"pid":43580,"title":"Marcus Harris","short_name":"MS Harris","first_name":"Marcus Harris","last_name":"","middle_name":"","birthdate":"1992-07-21","birthplace":"Perth, Australia","country":"au","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/marcusharris14\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":46310,"title":"Blair Tickner","short_name":"BM Tickner","first_name":"Blair Tickner","last_name":"","middle_name":"","birthdate":"1993-10-13","birthplace":"Napier, Hawke''s Bay","country":"nz","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/blair.tickner\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/ticks93\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"squad","role_str":""},{"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":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":48428,"title":"Luis Reece","short_name":"LM Reece","first_name":"Luis Reece","last_name":"","middle_name":"","birthdate":"1990-08-04","birthplace":"Taunton, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lreece17","instagram_profile":"https:\/\/www.instagram.com\/louisreece\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":48498,"title":"Caleb Jewell","short_name":"CP Jewell","first_name":"Caleb Jewell","last_name":"","middle_name":"","birthdate":"1997-04-21","birthplace":"Hobart, Tasmania","country":"au","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/caleb.jewell.148\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/cjewell_32\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"bat","role_str":""},{"pid":48508,"title":"Brooke Guest","short_name":"BD Guest","first_name":"Brooke Guest","last_name":"","middle_name":"","birthdate":"1997-05-14","birthplace":"Whitworth Park, Manchester, England","country":"au","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/guesty211\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"wk","role_str":"(WK)"},{"pid":48641,"title":"Wayne Madsen","short_name":"WL Madsen","first_name":"Wayne Madsen","last_name":"","middle_name":"","birthdate":"1984-01-02","birthplace":"Durban","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/waynemadders77","instagram_profile":"https:\/\/www.instagram.com\/waynemadsen77\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"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":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49607,"title":"Billy Godleman","short_name":"BA Godleman","first_name":"Billy Godleman","last_name":"","middle_name":"","birthdate":"1989-02-11","birthplace":"Camden, London","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/billboi00","instagram_profile":"","debut_data":"","bowling_type":"Spin","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":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49808,"title":"Zak Chappell","short_name":"ZJ Chappell","first_name":"Zak Chappell","last_name":"","middle_name":"","birthdate":"1996-08-21","birthplace":"Grantham, Lincolnshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/chappooo","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","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":"","bowling_type":"Spin","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":50433,"title":"Alex Thomson","short_name":"AT Thomson","first_name":"Alex Thomson","last_name":"","middle_name":"","birthdate":"1993-10-30","birthplace":"Stoke-on-Trent, Staffordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/alextomo","instagram_profile":"https:\/\/www.instagram.com\/alex_thomson_racing\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":50528,"title":"Anuj Dal","short_name":"AK Dal","first_name":"Anuj Dal","last_name":"","middle_name":"","birthdate":"1996-07-08","birthplace":"Newcastle-under-Lyme, Staffordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/AnujDal","instagram_profile":"https:\/\/www.instagram.com\/anujdal0\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":51064,"title":"Martin Andersson","short_name":"MK Andersson","first_name":"Martin Andersson","last_name":"","middle_name":"","birthdate":"1996-09-06","birthplace":"Reading, Berkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/MartinAnderss11","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":62695,"title":"Matthew Lamb","short_name":"M Lamb","first_name":"Matthew Lamb","last_name":"","middle_name":"","birthdate":"1996-07-19","birthplace":"Wolverhampton, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/MattLamb96","instagram_profile":"https:\/\/www.instagram.com\/lambagramz\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":90974,"title":"Henry Brookes","short_name":"HJH Brookes","first_name":"Henry Brookes","last_name":"","middle_name":"","birthdate":"1999-08-21","birthplace":"Solihull, Warwickshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BrookesHenry","instagram_profile":"https:\/\/www.instagram.com\/henry.brookes\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":94962,"title":"Harry Came","short_name":"H Came","first_name":"Harry Came","last_name":"","middle_name":"","birthdate":"1998-08-27","birthplace":"Hampshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/HarryCame4","instagram_profile":"https:\/\/www.instagram.com\/harrycame4\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":94963,"title":"Jack Morley","short_name":"J Morley","first_name":"Jack Morley","last_name":"","middle_name":"","birthdate":"2001-06-25","birthplace":"Rochdale, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":95302,"title":"Haider Ali","short_name":"H Ali","first_name":"Haider Ali","last_name":"","middle_name":"","birthdate":"2000-10-02","birthplace":"Attock","country":"pk","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/iamhaideraly","instagram_profile":"https:\/\/www.instagram.com\/malik_haideralikhan\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Pakistan","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":95486,"title":"Todd Murphy","short_name":"TR Murphy","first_name":"Todd Murphy","last_name":"","middle_name":"","birthdate":"2000-11-15","birthplace":" Echuca, Victoria","country":"au","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/todd.murphy.5682\/","twitter_profile":"https:\/\/twitter.com\/ToddMur82405592","instagram_profile":"https:\/\/www.instagram.com\/toddmurphy9\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Australia","role":"bowl","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":101484,"title":"Ben William Aitchison","short_name":"B W Aitchison","first_name":"Ben William Aitchison","last_name":"","middle_name":"","birthdate":"1999-07-06","birthplace":"Southport, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Benaitchison123","instagram_profile":"https:\/\/www.instagram.com\/baitchison13\/","debut_data":"","bowling_type":"Pace","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":"","bowling_type":"Pace","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":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":109363,"title":"Mitchell Wagstaff","short_name":"M Wagstaff","first_name":"Mitchell Wagstaff","last_name":"","middle_name":"","birthdate":"2003-09-02","birthplace":"Derby","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/mitchellwaggy?lang=en","instagram_profile":"https:\/\/www.instagram.com\/mitchellwagstaff\/?hl=en","debut_data":"","bowling_type":"Spin","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":118504,"title":"Allah Mohammad Ghazanfar","short_name":"AM Ghazanfar","first_name":"Allah Mohammad Ghazanfar","last_name":"","middle_name":"","birthdate":"2007-07-15","birthplace":"","country":"af","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/Ghazanfar050\/","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Afghanistan","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":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":130162,"title":"Harry Moore","short_name":"HJ Moore","first_name":"Harry Moore","last_name":"","middle_name":"","birthdate":"2007-04-26","birthplace":"Houston, Florida","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/ha66y2004","instagram_profile":"https:\/\/www.instagram.com\/harrymoore72\/","debut_data":"","bowling_type":"Pace","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""}]},"etag":"cdaaea36e50c886e058fb2817fe7ee7e","modified":"2025-07-13 05:41:49","datetime":"2025-07-13 05:41:49","api_version":"3.0"}', Modified = GetDate() WHERE Id = 88188 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:6ac64cf9-426c-40c6-af7b-97d61ea5efbc Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 88188 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (88188,3,'{"status":"ok","response":{"match_id":88188,"title":"Gloucestershire vs Derbyshire","short_title":"GLO vs DER","subtitle":"31st Match","match_number":"31","format":5,"format_str":"First Class","status":2,"status_str":"Completed","status_note":"Match Drawn","verified":"false","pre_squad":"false","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129482,"title":"County Championship Division Two","abbr":"County Championship 2025 DIV-II","type":"tournament","category":"domestic","match_format":"firstclass","season":"2025","status":"live","datestart":"2025-04-04","dateend":"2025-09-27","country":"en","total_matches":"56","total_rounds":"1","total_teams":"8"},"teama":{"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":"187\/10 (59.2 ov) & 526\/6d (147 ov)","scores":"187\/10 & 526\/6d","overs":"59.2 & 147"},"teamb":{"team_id":104949,"name":"Derbyshire","short_name":"DER","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/derbyshire-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/derbyshire-logo.png","scores_full":"398\/10 (105.5 ov) & 296\/8 (66.5 ov)","scores":"398\/10 & 296\/8","overs":"105.5 & 66.5"},"date_start":"2025-06-22 10:00:00","date_end":"2025-06-27 10:00:00","timestamp_start":1750586400,"timestamp_end":1751018400,"date_start_ist":"2025-06-22 15:30:00","date_end_ist":"2025-06-27 15:30:00","venue":{"venue_id":"38","name":"County Ground, Bristol","location":"Bristol","country":"England","timezone":""},"umpires":"","referee":"","equation":"Match Drawn","live":"","result":"Match Drawn","result_type":3,"win_margin":"","winning_team_id":0,"commentary":1,"wagon":2,"latest_inning_number":4,"presquad_time":"","verify_time":"","match_dls_affected":"false","live_inning_number":4,"day":"4","session":"0","weather":[],"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Gloucestershire elected to bat","winner":7017,"decision":1}},"etag":"53b32b1981c3671331ab6a6e4c21589e","modified":"2025-07-13 05:41:50","datetime":"2025-07-13 05:41:50","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":88188,"title":"Gloucestershire vs Derbyshire","short_title":"GLO vs DER","subtitle":"31st Match","match_number":"31","format":5,"format_str":"First Class","status":2,"status_str":"Completed","status_note":"Match Drawn","verified":"false","pre_squad":"false","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129482,"title":"County Championship Division Two","abbr":"County Championship 2025 DIV-II","type":"tournament","category":"domestic","match_format":"firstclass","season":"2025","status":"live","datestart":"2025-04-04","dateend":"2025-09-27","country":"en","total_matches":"56","total_rounds":"1","total_teams":"8"},"teama":{"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":"187\/10 (59.2 ov) & 526\/6d (147 ov)","scores":"187\/10 & 526\/6d","overs":"59.2 & 147"},"teamb":{"team_id":104949,"name":"Derbyshire","short_name":"DER","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/derbyshire-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/derbyshire-logo.png","scores_full":"398\/10 (105.5 ov) & 296\/8 (66.5 ov)","scores":"398\/10 & 296\/8","overs":"105.5 & 66.5"},"date_start":"2025-06-22 10:00:00","date_end":"2025-06-27 10:00:00","timestamp_start":1750586400,"timestamp_end":1751018400,"date_start_ist":"2025-06-22 15:30:00","date_end_ist":"2025-06-27 15:30:00","venue":{"venue_id":"38","name":"County Ground, Bristol","location":"Bristol","country":"England","timezone":""},"umpires":"","referee":"","equation":"Match Drawn","live":"","result":"Match Drawn","result_type":3,"win_margin":"","winning_team_id":0,"commentary":1,"wagon":2,"latest_inning_number":4,"presquad_time":"","verify_time":"","match_dls_affected":"false","live_inning_number":4,"day":"4","session":"0","weather":[],"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Gloucestershire elected to bat","winner":7017,"decision":1}},"etag":"53b32b1981c3671331ab6a6e4c21589e","modified":"2025-07-13 05:41:50","datetime":"2025-07-13 05:41:50","api_version":"3.0"}', Modified = GetDate() WHERE Id = 88188 AND DataTypeId = 3 END
Live Report & Scorecard of Gloucestershire vs Derbyshire 31st Match

Hong Kong Women

Kuwait Women

LIVE06 May Match 6

Thailand Women

United Arab Emirates Women

LIVEToday3rd Test

England387/10 (112.3 ov) & *2/0 (1 ov)

India387/10 (119.2 ov)

Stumps : Day 3 - England lead by 2 runs.

LIVEToday1st Youth Test

England Under-19s

India Under-19s*450/7 (87.5 ov)

Stumps : Day 1 - India Under-19s elected to bat

LIVEToday3rd Test

West Indies*16/1 (9 ov)

Australia225/10 (70.3 ov)

Stumps : Day 1 - West Indies trail by 209 runs.

LIVEToday1st Unofficial Test

Australia A

Sri Lanka A*161/6 (51 ov)

Tea Break : Day 1 - Australia A elected to bowl

LIVETodayMatch 11

Nabarang Club185/6 (20 ov)

City Cricket Club0/0 ( ov)

Innings Break : City Cricket Club need 186 runs in 20 remaining overs

ScheduledTodayMatch 12

South Korea

Indonesia

Scheduled13 July Match 5

Belgium Jeanekens-W

French Eiffels-W

Scheduled13 July Final

Gibraltar

Bulgaria

Scheduled13 July Match 4

Germany

Belgium

Scheduled13 July 3rd place play-off

Malawi

Germany

Scheduled13 July Match 12

Gauhati Town Club

Nabajyoti Club

Scheduled13 July Match 14

Karaikal Kniights

Yanam Royals

Scheduled13 July Match 6

Belgium Belforts-W

Luxembourg Mullerthals-W

Scheduled13 July Match 5

Germany

Belgium

Scheduled13 July Match 50

Surrey Women

Somerset Women

Scheduled13 July Match 58

Worcestershire Women

Leicestershire Women

Scheduled13 July Match 48

Hampshire Women

Warwickshire Women

Scheduled13 July Match 49

Lancashire Women

Durham Women

Live Cricket Match Centre

Gloucestershire vs Derbyshire, 31st Match, County Championship Division Two

Completed

County Championship Division Two, Completed

Gloucestershire

GLO

187/10 (59.2 ov) & 526/6d (147 ov)

Derbyshire

DER

398/10 (105.5 ov) & 296/8 (66.5 ov)

Match Drawn

BATTERS	R	B	4S	6S	SR
Anuj Dal *	36	68	2	0	52.94
Ben William Aitchison	7	15	1	0	46.67

BOWLERS	O	M	R	W	ECON
Graeme van Buuren *	18.5	1	64	4	3.40
Todd Murphy	27	2	114	2	4.22

Current Partnership: 13 run (6.2 ov) | Last Wicket: David Lloyd 9 (20) | Fall of Wicket: 283/8 (60.3 ov)

CRR: 4.43

Recent: ••••••1••••4•1••••

Gloucestershire vs Derbyshire, Live Cricket Commentary

66.5

Graeme van Buuren to Anuj Dal, no run,

66.4

Graeme van Buuren to Anuj Dal, no run,

66.3

Graeme van Buuren to Anuj Dal, no run,

66.2

Graeme van Buuren to Anuj Dal, no run,

66.1

Graeme van Buuren to Anuj Dal, no run,

End of over 66 (1 runs)

Ben William Aitchison 7 (15)

Anuj Dal 36 (63)

Derbyshire 296/8

Todd Murphy 27-2-114-2

Graeme van Buuren 18-1-64-4

65.6

Todd Murphy to Ben William Aitchison, no run,

65.5

Todd Murphy to Anuj Dal, 1 run,

65.4

Todd Murphy to Anuj Dal, no run,

65.3

Todd Murphy to Anuj Dal, no run,

65.2

Todd Murphy to Anuj Dal, no run,

65.1

Todd Murphy to Anuj Dal, no run,

End of over 65 (5 runs)

Ben William Aitchison 7 (14)

Anuj Dal 35 (58)

Derbyshire 295/8

Graeme van Buuren 18-1-64-4

Todd Murphy 26-2-113-2

64.6

Graeme van Buuren to Ben William Aitchison, Four,

64.5

Graeme van Buuren to Ben William Aitchison, no run,

64.4

Graeme van Buuren to Anuj Dal, 1 run,

64.3

Graeme van Buuren to Anuj Dal, no run,

64.2

Graeme van Buuren to Anuj Dal, no run,

64.1

Graeme van Buuren to Anuj Dal, no run,

End of over 64 (2 runs)

Ben William Aitchison 3 (12)

Anuj Dal 34 (54)

Derbyshire 290/8

Todd Murphy 26-2-113-2

Graeme van Buuren 17-1-59-4

63.6

Todd Murphy to Ben William Aitchison, no run,

63.5

Todd Murphy to Anuj Dal, 1 run,

63.4

Todd Murphy to Anuj Dal, no run,

63.3

Todd Murphy to Anuj Dal, no run,

63.2

Todd Murphy to Ben William Aitchison, 1 run,

63.1

Todd Murphy to Ben William Aitchison, no run,

End of over 63 (2 runs)

Anuj Dal 33 (51)

Ben William Aitchison 2 (9)

Derbyshire 288/8

Graeme van Buuren 17-1-59-4

Todd Murphy 25-2-111-2

62.6

Graeme van Buuren to Anuj Dal, no run,

62.5

Graeme van Buuren to Ben William Aitchison, 1 run,

62.4

Graeme van Buuren to Ben William Aitchison, no run,

62.3

Graeme van Buuren to Ben William Aitchison, no run,

Date

Sunday, June 22, 2025 11:00

Venue

County Ground, Bristol, Bristol

Toss

Gloucestershire elected to bat

Umpires

Match Referee

× Close