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:759dcd5a-ea41-4c80-ba98-cbe8f98f3be7
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90244 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90244,1,'{"status":"ok","response":{"mid":90244,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Warwickshire Women won by 7 wickets","day_remaining_over":"","team_batting":"Warwickshire Women","team_bowling":"Durham Women","live_inning_number":2,"live_score":{"runs":165,"overs":18.2,"wickets":3,"target":163,"runrate":9,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Charis Pavely","batsman_id":122220,"runs":30,"balls_faced":24,"fours":4,"sixes":0,"strike_rate":"125.00"},{"name":"Laura Harris","batsman_id":47698,"runs":0,"balls_faced":1,"fours":0,"sixes":0,"strike_rate":"0.00"}],"bowlers":[{"name":"Katherine Fraser","bowler_id":95778,"overs":0.2,"runs_conceded":4,"wickets":0,"maidens":0,"econ":"12.00"},{"name":"Mady Villiers","bowler_id":51467,"overs":4,"runs_conceded":36,"wickets":1,"maidens":0,"econ":"9.00"}],"commentaries":[{"event_id":"12119511","event":"ball","batsman_id":"95766","bowler_id":"116258","over":"14","ball":"1","score":1,"commentary":"Phoebe Turner to Natasha Wraith, 1 run,","noball_dismissal":false,"text":"","timestamp":1749657634,"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":"12119514","event":"ball","batsman_id":"122220","bowler_id":"116258","over":"14","ball":"2","score":0,"commentary":"Phoebe Turner to Charis Pavely, no run,","noball_dismissal":false,"text":"","timestamp":1749657664,"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":"12119518","event":"ball","batsman_id":"122220","bowler_id":"116258","over":"14","ball":"3","score":1,"commentary":"Phoebe Turner to Charis Pavely, 1 run,","noball_dismissal":false,"text":"","timestamp":1749657715,"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":"12119523","event":"ball","batsman_id":"95766","bowler_id":"116258","over":"14","ball":"4","score":1,"commentary":"Phoebe Turner to Natasha Wraith, 1 run,","noball_dismissal":false,"text":"","timestamp":1749657719,"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":"12119528","event":"ball","batsman_id":"122220","bowler_id":"116258","over":"14","ball":"5","score":0,"commentary":"Phoebe Turner to Charis Pavely, no run,","noball_dismissal":false,"text":"","timestamp":1749657749,"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":"12119534","event":"ball","batsman_id":"122220","bowler_id":"116258","over":"14","ball":"6","score":4,"commentary":"Phoebe Turner to Charis Pavely, Four,","noball_dismissal":false,"text":"","timestamp":1749657807,"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":15,"runs":7,"score":"136\/2","bats":[{"runs":23,"balls_faced":18,"fours":3,"sixes":0,"batsman_id":122220},{"runs":35,"balls_faced":24,"fours":4,"sixes":0,"batsman_id":95766}],"bowls":[{"runs_conceded":24,"maidens":0,"wickets":0,"bowler_id":116258,"overs":3},{"runs_conceded":29,"maidens":0,"wickets":0,"bowler_id":51467,"overs":3}],"commentary":"End of over 15 (7 runs), Warwickshire Women 136\/2"},{"event_id":"12119545","event":"ball","batsman_id":"95766","bowler_id":"51493","over":"15","ball":"1","score":1,"commentary":"Katie Levick to Natasha Wraith, 1 run,","noball_dismissal":false,"text":"","timestamp":1749657833,"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":"12119555","event":"ball","batsman_id":"122220","bowler_id":"51493","over":"15","ball":"2","score":1,"commentary":"Katie Levick to Charis Pavely, 1 run,","noball_dismissal":false,"text":"","timestamp":1749657892,"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":"12119558","event":"ball","batsman_id":"95766","bowler_id":"51493","over":"15","ball":"3","score":4,"commentary":"Katie Levick to Natasha Wraith, Four,","noball_dismissal":false,"text":"","timestamp":1749657895,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12119561","event":"ball","batsman_id":"95766","bowler_id":"51493","over":"15","ball":"4","score":0,"commentary":"Katie Levick to Natasha Wraith, no run,","noball_dismissal":false,"text":"","timestamp":1749657905,"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":"12119567","event":"ball","batsman_id":"95766","bowler_id":"51493","over":"15","ball":"5","score":1,"commentary":"Katie Levick to Natasha Wraith, 1 run,","noball_dismissal":false,"text":"","timestamp":1749657946,"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":"12119568","event":"ball","batsman_id":"122220","bowler_id":"51493","over":"15","ball":"6","score":0,"commentary":"Katie Levick to Charis Pavely, no run,","noball_dismissal":false,"text":"","timestamp":1749657958,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":16,"runs":7,"score":"143\/2","bats":[{"runs":24,"balls_faced":20,"fours":3,"sixes":0,"batsman_id":122220},{"runs":41,"balls_faced":28,"fours":5,"sixes":0,"batsman_id":95766}],"bowls":[{"runs_conceded":30,"maidens":0,"wickets":2,"bowler_id":51493,"overs":4},{"runs_conceded":24,"maidens":0,"wickets":0,"bowler_id":116258,"overs":3}],"commentary":"End of over 16 (7 runs), Warwickshire Women 143\/2"},{"event_id":"12119585","event":"ball","batsman_id":"95766","bowler_id":"137961","over":"16","ball":"1","score":"1wd","commentary":"Trudy Johnson to Natasha Wraith, 1 wide,","noball_dismissal":false,"text":"","timestamp":1749658053,"run":1,"noball_run":"0","wide_run":"1","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12119589","event":"ball","batsman_id":"95766","bowler_id":"137961","over":"16","ball":"1","score":2,"commentary":"Trudy Johnson to Natasha Wraith, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749658074,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12119600","event":"ball","batsman_id":"95766","bowler_id":"137961","over":"16","ball":"2","score":2,"commentary":"Trudy Johnson to Natasha Wraith, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749658123,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12119601","event":"ball","batsman_id":"95766","bowler_id":"137961","over":"16","ball":"3","score":1,"commentary":"Trudy Johnson to Natasha Wraith, 1 run,","noball_dismissal":false,"text":"","timestamp":1749658126,"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":"12119609","event":"ball","batsman_id":"122220","bowler_id":"137961","over":"16","ball":"4","score":1,"commentary":"Trudy Johnson to Charis Pavely, 1 run,","noball_dismissal":false,"text":"","timestamp":1749658176,"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":"12119613","event":"ball","batsman_id":"95766","bowler_id":"137961","over":"16","ball":"5","score":0,"commentary":"Trudy Johnson to Natasha Wraith, no run,","noball_dismissal":false,"text":"","timestamp":1749658217,"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":"12119619","event":"ball","batsman_id":"95766","bowler_id":"137961","over":"16","ball":"6","score":4,"commentary":"Trudy Johnson to Natasha Wraith, Four,","noball_dismissal":false,"text":"","timestamp":1749658228,"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":17,"runs":11,"score":"154\/2","bats":[{"runs":50,"balls_faced":33,"fours":6,"sixes":0,"batsman_id":95766},{"runs":25,"balls_faced":21,"fours":3,"sixes":0,"batsman_id":122220}],"bowls":[{"runs_conceded":34,"maidens":0,"wickets":0,"bowler_id":137961,"overs":3},{"runs_conceded":30,"maidens":0,"wickets":2,"bowler_id":51493,"overs":4}],"commentary":"End of over 17 (11 runs), Warwickshire Women 154\/2"},{"event_id":"12119627","event":"ball","batsman_id":"122220","bowler_id":"51467","over":"17","ball":"1","score":1,"commentary":"Mady Villiers to Charis Pavely, 1 run,","noball_dismissal":false,"text":"","timestamp":1749658361,"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":"12119632","event":"ball","batsman_id":"95766","bowler_id":"51467","over":"17","ball":"2","score":4,"commentary":"Mady Villiers to Natasha Wraith, Four,","noball_dismissal":false,"text":"","timestamp":1749658365,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12119638","event":"ball","batsman_id":"95766","bowler_id":"51467","over":"17","ball":"3","score":2,"commentary":"Mady Villiers to Natasha Wraith, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749658398,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12119661","event":"wicket","batsman_id":"95766","bowler_id":"51467","over":"17","ball":"4","score":"w","commentary":"Mady Villiers to Natasha Wraith, no run, st BAM Heath b MK Villiers,","noball_dismissal":false,"text":"","timestamp":1749658527,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"95766","how_out":"st BAM Heath b MK Villiers","batsman_runs":"56","batsman_balls":"36"},{"event_id":"12119664","event":"ball","batsman_id":"47698","bowler_id":"51467","over":"17","ball":"5","score":0,"commentary":"Mady Villiers to Laura Harris, no run,","noball_dismissal":false,"text":"","timestamp":1749658532,"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":"12119688","event":"ball","batsman_id":"47698","bowler_id":"51467","over":"17","ball":"6","score":0,"commentary":"Mady Villiers to Laura Harris, no run,","noball_dismissal":false,"text":"","timestamp":1749658836,"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":18,"runs":7,"score":"161\/3","bats":[{"runs":0,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":47698},{"runs":26,"balls_faced":22,"fours":3,"sixes":0,"batsman_id":122220}],"bowls":[{"runs_conceded":36,"maidens":0,"wickets":1,"bowler_id":51467,"overs":4},{"runs_conceded":34,"maidens":0,"wickets":0,"bowler_id":137961,"overs":3}],"commentary":"End of over 18 (7 runs), Warwickshire Women 161\/3"},{"event_id":"12119692","event":"ball","batsman_id":"122220","bowler_id":"95778","over":"18","ball":"1","score":0,"commentary":"Katherine Fraser to Charis Pavely, no run,","noball_dismissal":false,"text":"","timestamp":1749658840,"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":"12119694","event":"ball","batsman_id":"122220","bowler_id":"95778","over":"18","ball":"2","score":4,"commentary":"Katherine Fraser to Charis Pavely, Four,","noball_dismissal":false,"text":"","timestamp":1749658843,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false}],"day":"0","session":"0","live_inning":{"iid":197837,"number":2,"name":"Warwickshire Women Inning","short_name":"WAS-W Inning","status":2,"issuperover":"false","result":3,"batting_team_id":19223,"fielding_team_id":19270,"scores":"165\/3","scores_full":"165\/3 (18.2 ov)","fielder":[{"fielder_id":"58162","fielder_name":"Hollie Armitage","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"102803","fielder_name":"Leah Dobson","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"51911","fielder_name":"Bess Heath","catches":0,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":1,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Natasha Wraith","batsman_id":"95766","runs":"56","balls":"36","how_out":"st BAM Heath b MK Villiers","score_at_dismissal":161,"overs_at_dismissal":"17.4","bowler_id":"51467","dismissal":"stumped","number":3},"extra_runs":{"byes":0,"legbyes":0,"wides":8,"noballs":0,"penalty":"0","total":8},"equations":{"runs":165,"wickets":3,"overs":"18.2","bowlers_used":7,"runrate":"9.00"},"current_partnership":{"runs":4,"balls":4,"overs":0.4,"batsmen":[{"name":"Laura Harris","batsman_id":47698,"runs":0,"balls":2},{"name":"Charis Pavely","batsman_id":122220,"runs":4,"balls":2}]},"did_not_bat":[{"player_id":"51398","name":"Emily Arlott"},{"player_id":"51431","name":"Georgia Davis"},{"player_id":"108154","name":"Issy Wong"},{"player_id":"107884","name":"Millie Taylor"},{"player_id":"51844","name":"Bethan Ellis"},{"player_id":"102945","name":"Hannah Baker"}],"max_over":"20","target":"163","recent_scores":"4,0,0,0,w,2,4,1,4,0,1,1,2,2,1,0,1,0","last_five_overs":"45\/1 8.44","last_ten_overs":"86\/2 8.19"},"teams":[{"tid":19223,"title":"Warwickshire Women","abbr":"WAS-W","alt_name":"Warwickshire Women","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/09\/Rectangle-3493-10.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/09\/Rectangle-3493-10.png","country":"en","sex":"female","team_owner":"","head_coach":"","scores_full":"165\/3 (18.2 ov)","scores":"165\/3","overs":"18.2"},{"tid":19270,"title":"Durham Women","abbr":"DUR-W","alt_name":"Durham Women","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/09\/Rectangle-3493-25.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/09\/Rectangle-3493-25.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"162\/5 (20 ov)","scores":"162\/5","overs":"20"}],"players":[{"pid":44247,"title":"Suzie Bates","short_name":"SW Bates","first_name":"Suzie Bates","last_name":"","middle_name":"","birthdate":"1987-09-16","birthplace":"Dunedin, Otago","country":"nz","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":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/SuzieWBates","instagram_profile":"https:\/\/www.instagram.com\/suziebates\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bat","role_str":""},{"pid":44532,"title":"Sterre Kalis","short_name":"SL Kalis","first_name":"Sterre Kalis","last_name":"","middle_name":"","birthdate":"1999-08-30","birthplace":"The Hague, Netherlands","country":"nl","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"https:\/\/www.facebook.com\/sterre.kalis\/","twitter_profile":"https:\/\/twitter.com\/sterdester","instagram_profile":"https:\/\/www.instagram.com\/sterdester30\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"squad","role_str":""},{"pid":47698,"title":"Laura Harris","short_name":"L Harris","first_name":"Laura Harris","last_name":"","middle_name":"","birthdate":"1990-08-18","birthplace":"Ipswich, Queensland","country":"au","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":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/larristheharris","instagram_profile":"https:\/\/www.instagram.com\/lauraharris968\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"bat","role_str":""},{"pid":51398,"title":"Emily Arlott","short_name":"Emily Arlott","first_name":"Emily Arlott","last_name":"","middle_name":"","birthdate":"1998-02-23","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/EmArlott","instagram_profile":"https:\/\/www.instagram.com\/emily_arlott\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":51431,"title":"Georgia Davis","short_name":"GK Davis","first_name":"Georgia Davis","last_name":"","middle_name":"","birthdate":"1999-06-03","birthplace":"Birmingham, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":"(C)"},{"pid":51467,"title":"Mady Villiers","short_name":"MK Villiers","first_name":"Mady Villiers","last_name":"","middle_name":"","birthdate":"1998-08-26","birthplace":" Havering, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/mady.villiers\/","twitter_profile":"https:\/\/twitter.com\/VilliersMady","instagram_profile":"https:\/\/www.instagram.com\/madyvilliers\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":51493,"title":"Katie Levick","short_name":"KA Levick","first_name":"Katie Levick","last_name":"","middle_name":"","birthdate":"1991-07-17","birthplace":"Sheffield, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Katie_Lev","instagram_profile":"https:\/\/www.instagram.com\/katie_lev\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":51668,"title":"Katie George","short_name":"KL George","first_name":"Katie George","last_name":"","middle_name":"","birthdate":"1999-04-07","birthplace":"Haywards Heath, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/KaTie_George46","instagram_profile":"https:\/\/www.instagram.com\/katie_george99\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51672,"title":"Emily Windsor","short_name":"EL Windsor","first_name":"Emily Windsor","last_name":"","middle_name":"","birthdate":"1997-09-14","birthplace":"Portsmouth","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\/emzwinsa","instagram_profile":"https:\/\/www.instagram.com\/emzwinsa\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51844,"title":"Bethan Ellis","short_name":"B Ellis","first_name":"Bethan Ellis","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":51911,"title":"Bess Heath","short_name":"BAM Heath","first_name":"Bess Heath","last_name":"","middle_name":"","birthdate":"2001-08-20","birthplace":"Chesterfield, Derbyshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/bess.heath\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/bessy.10\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":51923,"title":"Abigail Freeborn","short_name":"AJ Freeborn","first_name":"Abigail Freeborn","last_name":"","middle_name":"","birthdate":"1996-11-12","birthplace":"Eastbourne, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/abbey_freeborn","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":58162,"title":"Hollie Armitage","short_name":"H Armitage","first_name":"Hollie Armitage","last_name":"","middle_name":"","birthdate":"1997-06-14","birthplace":"Huddersfield, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/holliearmo\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"pid":93800,"title":"Hannah Rainey","short_name":"HRA Rainey","first_name":"Hannah Rainey","last_name":"","middle_name":"","birthdate":"1997-06-02","birthplace":"London","country":"sct","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/_hrainey","instagram_profile":"https:\/\/www.instagram.com\/rainey_hannah\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Scotland","role":"squad","role_str":""},{"pid":95766,"title":"Natasha Wraith","short_name":"N Wraith","first_name":"Natasha Wraith","last_name":"","middle_name":"","birthdate":"2001-10-03","birthplace":"Bristol","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/natwraith01\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":95778,"title":"Katherine Fraser","short_name":"K Fraser","first_name":"Katherine Fraser","last_name":"","middle_name":"","birthdate":"2005-04-09","birthplace":"","country":"sct","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":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Scotland","role":"bowl","role_str":""},{"pid":102553,"title":"Chloe Brewer","short_name":"C Brewer","first_name":"Chloe Brewer","last_name":"","middle_name":"","birthdate":"2002-07-12","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Ch103_b","instagram_profile":"https:\/\/www.instagram.com\/chloebrewer\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":102557,"title":"Lauren Filer","short_name":"L Filer","first_name":"Lauren Filer","last_name":"","middle_name":"","birthdate":"2000-12-22","birthplace":" Bristol","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/laurenfiler14","instagram_profile":"https:\/\/www.instagram.com\/lauren_filer\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":102768,"title":"Sophia Turner","short_name":"S Turner","first_name":"Sophia Turner","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":102803,"title":"Leah Dobson","short_name":"L Dobson","first_name":"Leah Dobson","last_name":"","middle_name":"","birthdate":"2001-10-06","birthplace":"Scarborough, 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.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/_leahdobson","instagram_profile":"https:\/\/www.instagram.com\/leah__dobson\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":102945,"title":"Hannah Baker","short_name":"H Baker","first_name":"Hannah Baker","last_name":"","middle_name":"","birthdate":"2004-02-03","birthplace":"West Midlands, England","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/hannahbakeerr\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":103050,"title":"Mia Rogers","short_name":"M Rogers","first_name":"Mia Rogers","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":""},{"pid":107884,"title":"Millie Taylor","short_name":"M Taylor","first_name":"Millie Taylor","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":108154,"title":"Issy Wong","short_name":"I Wong","first_name":"Issy Wong","last_name":"","middle_name":"","birthdate":"2002-05-15","birthplace":"Chelsea, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Wongi95","instagram_profile":"https:\/\/www.instagram.com\/wongi95\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":110318,"title":"Davina Perrin","short_name":"D Perrin","first_name":"Davina Perrin","last_name":"","middle_name":"","birthdate":"2006-09-08","birthplace":"Wolverhampton","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":116258,"title":"Phoebe Turner","short_name":"P Turner","first_name":"Phoebe Turner","last_name":"","middle_name":"","birthdate":"2003-08-08","birthplace":"","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":116259,"title":"Emma Marlow","short_name":"E Marlow","first_name":"Emma Marlow","last_name":"","middle_name":"","birthdate":"","birthplace":"","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":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":116260,"title":"Abigail Glen","short_name":"A Glen","first_name":"Abigail Glen","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":119591,"title":"Lizzie Scott","short_name":"LE Scott","first_name":"Lizzie Scott","last_name":"","middle_name":"","birthdate":"2004-09-01","birthplace":" Hexham, Northumberland","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\/lizziescott04","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":122220,"title":"Charis Pavely","short_name":"C Pavely","first_name":"Charis Pavely","last_name":"","middle_name":"","birthdate":"2004-10-24","birthplace":"Redditch","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/CharisPavely","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":128844,"title":"Amu Surenkumar","short_name":"A Surenkumar","first_name":"Amu Surenkumar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":130427,"title":"Hannah Hardwick","short_name":"H Hardwick","first_name":"Hannah Hardwick","last_name":"","middle_name":"","birthdate":"2004-05-01","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":134388,"title":"Meg Austin","short_name":"M Austin","first_name":"Meg Austin","last_name":"","middle_name":"","birthdate":"2004-07-09","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":137961,"title":"Trudy Johnson","short_name":"T Johnson","first_name":"Trudy Johnson","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":146141,"title":"Grace Thompson","short_name":"Grace Thompson","first_name":"Grace Thompson","last_name":"","middle_name":"","birthdate":"2007-05-30","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""}]},"etag":"b220ad74878a3ead52a3fbf2586b31c2","modified":"2025-06-14 03:53:15","datetime":"2025-06-14 03:53:15","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":90244,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Warwickshire Women won by 7 wickets","day_remaining_over":"","team_batting":"Warwickshire Women","team_bowling":"Durham Women","live_inning_number":2,"live_score":{"runs":165,"overs":18.2,"wickets":3,"target":163,"runrate":9,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Charis Pavely","batsman_id":122220,"runs":30,"balls_faced":24,"fours":4,"sixes":0,"strike_rate":"125.00"},{"name":"Laura Harris","batsman_id":47698,"runs":0,"balls_faced":1,"fours":0,"sixes":0,"strike_rate":"0.00"}],"bowlers":[{"name":"Katherine Fraser","bowler_id":95778,"overs":0.2,"runs_conceded":4,"wickets":0,"maidens":0,"econ":"12.00"},{"name":"Mady Villiers","bowler_id":51467,"overs":4,"runs_conceded":36,"wickets":1,"maidens":0,"econ":"9.00"}],"commentaries":[{"event_id":"12119511","event":"ball","batsman_id":"95766","bowler_id":"116258","over":"14","ball":"1","score":1,"commentary":"Phoebe Turner to Natasha Wraith, 1 run,","noball_dismissal":false,"text":"","timestamp":1749657634,"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":"12119514","event":"ball","batsman_id":"122220","bowler_id":"116258","over":"14","ball":"2","score":0,"commentary":"Phoebe Turner to Charis Pavely, no run,","noball_dismissal":false,"text":"","timestamp":1749657664,"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":"12119518","event":"ball","batsman_id":"122220","bowler_id":"116258","over":"14","ball":"3","score":1,"commentary":"Phoebe Turner to Charis Pavely, 1 run,","noball_dismissal":false,"text":"","timestamp":1749657715,"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":"12119523","event":"ball","batsman_id":"95766","bowler_id":"116258","over":"14","ball":"4","score":1,"commentary":"Phoebe Turner to Natasha Wraith, 1 run,","noball_dismissal":false,"text":"","timestamp":1749657719,"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":"12119528","event":"ball","batsman_id":"122220","bowler_id":"116258","over":"14","ball":"5","score":0,"commentary":"Phoebe Turner to Charis Pavely, no run,","noball_dismissal":false,"text":"","timestamp":1749657749,"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":"12119534","event":"ball","batsman_id":"122220","bowler_id":"116258","over":"14","ball":"6","score":4,"commentary":"Phoebe Turner to Charis Pavely, Four,","noball_dismissal":false,"text":"","timestamp":1749657807,"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":15,"runs":7,"score":"136\/2","bats":[{"runs":23,"balls_faced":18,"fours":3,"sixes":0,"batsman_id":122220},{"runs":35,"balls_faced":24,"fours":4,"sixes":0,"batsman_id":95766}],"bowls":[{"runs_conceded":24,"maidens":0,"wickets":0,"bowler_id":116258,"overs":3},{"runs_conceded":29,"maidens":0,"wickets":0,"bowler_id":51467,"overs":3}],"commentary":"End of over 15 (7 runs), Warwickshire Women 136\/2"},{"event_id":"12119545","event":"ball","batsman_id":"95766","bowler_id":"51493","over":"15","ball":"1","score":1,"commentary":"Katie Levick to Natasha Wraith, 1 run,","noball_dismissal":false,"text":"","timestamp":1749657833,"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":"12119555","event":"ball","batsman_id":"122220","bowler_id":"51493","over":"15","ball":"2","score":1,"commentary":"Katie Levick to Charis Pavely, 1 run,","noball_dismissal":false,"text":"","timestamp":1749657892,"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":"12119558","event":"ball","batsman_id":"95766","bowler_id":"51493","over":"15","ball":"3","score":4,"commentary":"Katie Levick to Natasha Wraith, Four,","noball_dismissal":false,"text":"","timestamp":1749657895,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12119561","event":"ball","batsman_id":"95766","bowler_id":"51493","over":"15","ball":"4","score":0,"commentary":"Katie Levick to Natasha Wraith, no run,","noball_dismissal":false,"text":"","timestamp":1749657905,"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":"12119567","event":"ball","batsman_id":"95766","bowler_id":"51493","over":"15","ball":"5","score":1,"commentary":"Katie Levick to Natasha Wraith, 1 run,","noball_dismissal":false,"text":"","timestamp":1749657946,"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":"12119568","event":"ball","batsman_id":"122220","bowler_id":"51493","over":"15","ball":"6","score":0,"commentary":"Katie Levick to Charis Pavely, no run,","noball_dismissal":false,"text":"","timestamp":1749657958,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":16,"runs":7,"score":"143\/2","bats":[{"runs":24,"balls_faced":20,"fours":3,"sixes":0,"batsman_id":122220},{"runs":41,"balls_faced":28,"fours":5,"sixes":0,"batsman_id":95766}],"bowls":[{"runs_conceded":30,"maidens":0,"wickets":2,"bowler_id":51493,"overs":4},{"runs_conceded":24,"maidens":0,"wickets":0,"bowler_id":116258,"overs":3}],"commentary":"End of over 16 (7 runs), Warwickshire Women 143\/2"},{"event_id":"12119585","event":"ball","batsman_id":"95766","bowler_id":"137961","over":"16","ball":"1","score":"1wd","commentary":"Trudy Johnson to Natasha Wraith, 1 wide,","noball_dismissal":false,"text":"","timestamp":1749658053,"run":1,"noball_run":"0","wide_run":"1","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12119589","event":"ball","batsman_id":"95766","bowler_id":"137961","over":"16","ball":"1","score":2,"commentary":"Trudy Johnson to Natasha Wraith, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749658074,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12119600","event":"ball","batsman_id":"95766","bowler_id":"137961","over":"16","ball":"2","score":2,"commentary":"Trudy Johnson to Natasha Wraith, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749658123,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12119601","event":"ball","batsman_id":"95766","bowler_id":"137961","over":"16","ball":"3","score":1,"commentary":"Trudy Johnson to Natasha Wraith, 1 run,","noball_dismissal":false,"text":"","timestamp":1749658126,"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":"12119609","event":"ball","batsman_id":"122220","bowler_id":"137961","over":"16","ball":"4","score":1,"commentary":"Trudy Johnson to Charis Pavely, 1 run,","noball_dismissal":false,"text":"","timestamp":1749658176,"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":"12119613","event":"ball","batsman_id":"95766","bowler_id":"137961","over":"16","ball":"5","score":0,"commentary":"Trudy Johnson to Natasha Wraith, no run,","noball_dismissal":false,"text":"","timestamp":1749658217,"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":"12119619","event":"ball","batsman_id":"95766","bowler_id":"137961","over":"16","ball":"6","score":4,"commentary":"Trudy Johnson to Natasha Wraith, Four,","noball_dismissal":false,"text":"","timestamp":1749658228,"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":17,"runs":11,"score":"154\/2","bats":[{"runs":50,"balls_faced":33,"fours":6,"sixes":0,"batsman_id":95766},{"runs":25,"balls_faced":21,"fours":3,"sixes":0,"batsman_id":122220}],"bowls":[{"runs_conceded":34,"maidens":0,"wickets":0,"bowler_id":137961,"overs":3},{"runs_conceded":30,"maidens":0,"wickets":2,"bowler_id":51493,"overs":4}],"commentary":"End of over 17 (11 runs), Warwickshire Women 154\/2"},{"event_id":"12119627","event":"ball","batsman_id":"122220","bowler_id":"51467","over":"17","ball":"1","score":1,"commentary":"Mady Villiers to Charis Pavely, 1 run,","noball_dismissal":false,"text":"","timestamp":1749658361,"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":"12119632","event":"ball","batsman_id":"95766","bowler_id":"51467","over":"17","ball":"2","score":4,"commentary":"Mady Villiers to Natasha Wraith, Four,","noball_dismissal":false,"text":"","timestamp":1749658365,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12119638","event":"ball","batsman_id":"95766","bowler_id":"51467","over":"17","ball":"3","score":2,"commentary":"Mady Villiers to Natasha Wraith, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749658398,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12119661","event":"wicket","batsman_id":"95766","bowler_id":"51467","over":"17","ball":"4","score":"w","commentary":"Mady Villiers to Natasha Wraith, no run, st BAM Heath b MK Villiers,","noball_dismissal":false,"text":"","timestamp":1749658527,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"95766","how_out":"st BAM Heath b MK Villiers","batsman_runs":"56","batsman_balls":"36"},{"event_id":"12119664","event":"ball","batsman_id":"47698","bowler_id":"51467","over":"17","ball":"5","score":0,"commentary":"Mady Villiers to Laura Harris, no run,","noball_dismissal":false,"text":"","timestamp":1749658532,"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":"12119688","event":"ball","batsman_id":"47698","bowler_id":"51467","over":"17","ball":"6","score":0,"commentary":"Mady Villiers to Laura Harris, no run,","noball_dismissal":false,"text":"","timestamp":1749658836,"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":18,"runs":7,"score":"161\/3","bats":[{"runs":0,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":47698},{"runs":26,"balls_faced":22,"fours":3,"sixes":0,"batsman_id":122220}],"bowls":[{"runs_conceded":36,"maidens":0,"wickets":1,"bowler_id":51467,"overs":4},{"runs_conceded":34,"maidens":0,"wickets":0,"bowler_id":137961,"overs":3}],"commentary":"End of over 18 (7 runs), Warwickshire Women 161\/3"},{"event_id":"12119692","event":"ball","batsman_id":"122220","bowler_id":"95778","over":"18","ball":"1","score":0,"commentary":"Katherine Fraser to Charis Pavely, no run,","noball_dismissal":false,"text":"","timestamp":1749658840,"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":"12119694","event":"ball","batsman_id":"122220","bowler_id":"95778","over":"18","ball":"2","score":4,"commentary":"Katherine Fraser to Charis Pavely, Four,","noball_dismissal":false,"text":"","timestamp":1749658843,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false}],"day":"0","session":"0","live_inning":{"iid":197837,"number":2,"name":"Warwickshire Women Inning","short_name":"WAS-W Inning","status":2,"issuperover":"false","result":3,"batting_team_id":19223,"fielding_team_id":19270,"scores":"165\/3","scores_full":"165\/3 (18.2 ov)","fielder":[{"fielder_id":"58162","fielder_name":"Hollie Armitage","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"102803","fielder_name":"Leah Dobson","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"51911","fielder_name":"Bess Heath","catches":0,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":1,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Natasha Wraith","batsman_id":"95766","runs":"56","balls":"36","how_out":"st BAM Heath b MK Villiers","score_at_dismissal":161,"overs_at_dismissal":"17.4","bowler_id":"51467","dismissal":"stumped","number":3},"extra_runs":{"byes":0,"legbyes":0,"wides":8,"noballs":0,"penalty":"0","total":8},"equations":{"runs":165,"wickets":3,"overs":"18.2","bowlers_used":7,"runrate":"9.00"},"current_partnership":{"runs":4,"balls":4,"overs":0.4,"batsmen":[{"name":"Laura Harris","batsman_id":47698,"runs":0,"balls":2},{"name":"Charis Pavely","batsman_id":122220,"runs":4,"balls":2}]},"did_not_bat":[{"player_id":"51398","name":"Emily Arlott"},{"player_id":"51431","name":"Georgia Davis"},{"player_id":"108154","name":"Issy Wong"},{"player_id":"107884","name":"Millie Taylor"},{"player_id":"51844","name":"Bethan Ellis"},{"player_id":"102945","name":"Hannah Baker"}],"max_over":"20","target":"163","recent_scores":"4,0,0,0,w,2,4,1,4,0,1,1,2,2,1,0,1,0","last_five_overs":"45\/1 8.44","last_ten_overs":"86\/2 8.19"},"teams":[{"tid":19223,"title":"Warwickshire Women","abbr":"WAS-W","alt_name":"Warwickshire Women","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/09\/Rectangle-3493-10.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/09\/Rectangle-3493-10.png","country":"en","sex":"female","team_owner":"","head_coach":"","scores_full":"165\/3 (18.2 ov)","scores":"165\/3","overs":"18.2"},{"tid":19270,"title":"Durham Women","abbr":"DUR-W","alt_name":"Durham Women","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/09\/Rectangle-3493-25.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/09\/Rectangle-3493-25.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"162\/5 (20 ov)","scores":"162\/5","overs":"20"}],"players":[{"pid":44247,"title":"Suzie Bates","short_name":"SW Bates","first_name":"Suzie Bates","last_name":"","middle_name":"","birthdate":"1987-09-16","birthplace":"Dunedin, Otago","country":"nz","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":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/SuzieWBates","instagram_profile":"https:\/\/www.instagram.com\/suziebates\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bat","role_str":""},{"pid":44532,"title":"Sterre Kalis","short_name":"SL Kalis","first_name":"Sterre Kalis","last_name":"","middle_name":"","birthdate":"1999-08-30","birthplace":"The Hague, Netherlands","country":"nl","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"https:\/\/www.facebook.com\/sterre.kalis\/","twitter_profile":"https:\/\/twitter.com\/sterdester","instagram_profile":"https:\/\/www.instagram.com\/sterdester30\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"squad","role_str":""},{"pid":47698,"title":"Laura Harris","short_name":"L Harris","first_name":"Laura Harris","last_name":"","middle_name":"","birthdate":"1990-08-18","birthplace":"Ipswich, Queensland","country":"au","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":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/larristheharris","instagram_profile":"https:\/\/www.instagram.com\/lauraharris968\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"bat","role_str":""},{"pid":51398,"title":"Emily Arlott","short_name":"Emily Arlott","first_name":"Emily Arlott","last_name":"","middle_name":"","birthdate":"1998-02-23","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/EmArlott","instagram_profile":"https:\/\/www.instagram.com\/emily_arlott\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":51431,"title":"Georgia Davis","short_name":"GK Davis","first_name":"Georgia Davis","last_name":"","middle_name":"","birthdate":"1999-06-03","birthplace":"Birmingham, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":"(C)"},{"pid":51467,"title":"Mady Villiers","short_name":"MK Villiers","first_name":"Mady Villiers","last_name":"","middle_name":"","birthdate":"1998-08-26","birthplace":" Havering, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/mady.villiers\/","twitter_profile":"https:\/\/twitter.com\/VilliersMady","instagram_profile":"https:\/\/www.instagram.com\/madyvilliers\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":51493,"title":"Katie Levick","short_name":"KA Levick","first_name":"Katie Levick","last_name":"","middle_name":"","birthdate":"1991-07-17","birthplace":"Sheffield, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Katie_Lev","instagram_profile":"https:\/\/www.instagram.com\/katie_lev\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":51668,"title":"Katie George","short_name":"KL George","first_name":"Katie George","last_name":"","middle_name":"","birthdate":"1999-04-07","birthplace":"Haywards Heath, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/KaTie_George46","instagram_profile":"https:\/\/www.instagram.com\/katie_george99\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51672,"title":"Emily Windsor","short_name":"EL Windsor","first_name":"Emily Windsor","last_name":"","middle_name":"","birthdate":"1997-09-14","birthplace":"Portsmouth","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\/emzwinsa","instagram_profile":"https:\/\/www.instagram.com\/emzwinsa\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51844,"title":"Bethan Ellis","short_name":"B Ellis","first_name":"Bethan Ellis","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":51911,"title":"Bess Heath","short_name":"BAM Heath","first_name":"Bess Heath","last_name":"","middle_name":"","birthdate":"2001-08-20","birthplace":"Chesterfield, Derbyshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/bess.heath\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/bessy.10\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":51923,"title":"Abigail Freeborn","short_name":"AJ Freeborn","first_name":"Abigail Freeborn","last_name":"","middle_name":"","birthdate":"1996-11-12","birthplace":"Eastbourne, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/abbey_freeborn","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":58162,"title":"Hollie Armitage","short_name":"H Armitage","first_name":"Hollie Armitage","last_name":"","middle_name":"","birthdate":"1997-06-14","birthplace":"Huddersfield, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/holliearmo\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"pid":93800,"title":"Hannah Rainey","short_name":"HRA Rainey","first_name":"Hannah Rainey","last_name":"","middle_name":"","birthdate":"1997-06-02","birthplace":"London","country":"sct","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/_hrainey","instagram_profile":"https:\/\/www.instagram.com\/rainey_hannah\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Scotland","role":"squad","role_str":""},{"pid":95766,"title":"Natasha Wraith","short_name":"N Wraith","first_name":"Natasha Wraith","last_name":"","middle_name":"","birthdate":"2001-10-03","birthplace":"Bristol","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/natwraith01\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":95778,"title":"Katherine Fraser","short_name":"K Fraser","first_name":"Katherine Fraser","last_name":"","middle_name":"","birthdate":"2005-04-09","birthplace":"","country":"sct","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":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Scotland","role":"bowl","role_str":""},{"pid":102553,"title":"Chloe Brewer","short_name":"C Brewer","first_name":"Chloe Brewer","last_name":"","middle_name":"","birthdate":"2002-07-12","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Ch103_b","instagram_profile":"https:\/\/www.instagram.com\/chloebrewer\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":102557,"title":"Lauren Filer","short_name":"L Filer","first_name":"Lauren Filer","last_name":"","middle_name":"","birthdate":"2000-12-22","birthplace":" Bristol","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/laurenfiler14","instagram_profile":"https:\/\/www.instagram.com\/lauren_filer\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":102768,"title":"Sophia Turner","short_name":"S Turner","first_name":"Sophia Turner","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":102803,"title":"Leah Dobson","short_name":"L Dobson","first_name":"Leah Dobson","last_name":"","middle_name":"","birthdate":"2001-10-06","birthplace":"Scarborough, 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.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/_leahdobson","instagram_profile":"https:\/\/www.instagram.com\/leah__dobson\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":102945,"title":"Hannah Baker","short_name":"H Baker","first_name":"Hannah Baker","last_name":"","middle_name":"","birthdate":"2004-02-03","birthplace":"West Midlands, England","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/hannahbakeerr\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":103050,"title":"Mia Rogers","short_name":"M Rogers","first_name":"Mia Rogers","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":""},{"pid":107884,"title":"Millie Taylor","short_name":"M Taylor","first_name":"Millie Taylor","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":108154,"title":"Issy Wong","short_name":"I Wong","first_name":"Issy Wong","last_name":"","middle_name":"","birthdate":"2002-05-15","birthplace":"Chelsea, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Wongi95","instagram_profile":"https:\/\/www.instagram.com\/wongi95\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":110318,"title":"Davina Perrin","short_name":"D Perrin","first_name":"Davina Perrin","last_name":"","middle_name":"","birthdate":"2006-09-08","birthplace":"Wolverhampton","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":116258,"title":"Phoebe Turner","short_name":"P Turner","first_name":"Phoebe Turner","last_name":"","middle_name":"","birthdate":"2003-08-08","birthplace":"","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":116259,"title":"Emma Marlow","short_name":"E Marlow","first_name":"Emma Marlow","last_name":"","middle_name":"","birthdate":"","birthplace":"","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":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":116260,"title":"Abigail Glen","short_name":"A Glen","first_name":"Abigail Glen","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":119591,"title":"Lizzie Scott","short_name":"LE Scott","first_name":"Lizzie Scott","last_name":"","middle_name":"","birthdate":"2004-09-01","birthplace":" Hexham, Northumberland","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\/lizziescott04","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":122220,"title":"Charis Pavely","short_name":"C Pavely","first_name":"Charis Pavely","last_name":"","middle_name":"","birthdate":"2004-10-24","birthplace":"Redditch","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/CharisPavely","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":128844,"title":"Amu Surenkumar","short_name":"A Surenkumar","first_name":"Amu Surenkumar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":130427,"title":"Hannah Hardwick","short_name":"H Hardwick","first_name":"Hannah Hardwick","last_name":"","middle_name":"","birthdate":"2004-05-01","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":134388,"title":"Meg Austin","short_name":"M Austin","first_name":"Meg Austin","last_name":"","middle_name":"","birthdate":"2004-07-09","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":137961,"title":"Trudy Johnson","short_name":"T Johnson","first_name":"Trudy Johnson","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":146141,"title":"Grace Thompson","short_name":"Grace Thompson","first_name":"Grace Thompson","last_name":"","middle_name":"","birthdate":"2007-05-30","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""}]},"etag":"b220ad74878a3ead52a3fbf2586b31c2","modified":"2025-06-14 03:53:15","datetime":"2025-06-14 03:53:15","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90244 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:82dc9219-4dcd-4812-8842-2ba7fe3815b2
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90244 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90244,3,'{"status":"ok","response":{"match_id":90244,"title":"Durham Women vs Warwickshire Women","short_title":"DUR-W vs WAS-W","subtitle":"Match 18","match_number":"18","format":8,"format_str":"Women T20","status":2,"status_str":"Completed","status_note":"Warwickshire Women won by 7 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129426,"title":"Vitality Blast Women","abbr":"Vitality Blast Women ","type":"tournament","category":"women","match_format":"woment20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-07-27","country":"en","total_matches":"57","total_rounds":"2","total_teams":"15"},"teama":{"team_id":19270,"name":"Durham Women","short_name":"DUR-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/09\/Rectangle-3493-25.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/09\/Rectangle-3493-25.png","scores_full":"162\/5 (20 ov)","scores":"162\/5","overs":"20"},"teamb":{"team_id":19223,"name":"Warwickshire Women","short_name":"WAS-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/09\/Rectangle-3493-10.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/09\/Rectangle-3493-10.png","scores_full":"165\/3 (18.2 ov)","scores":"165\/3","overs":"18.2"},"date_start":"2025-06-11 13:30:00","date_end":"2025-06-11 23:30:00","timestamp_start":1749648600,"timestamp_end":1749684600,"date_start_ist":"2025-06-11 19:00:00","date_end_ist":"2025-06-12 05:00:00","venue":{"venue_id":"39","name":"Riverside Ground, Chester-le-Street","location":"Chester-le-Street","country":"England","timezone":""},"umpires":"Simon Widdup (England), Jasmine Naeem (England)","referee":"Helen Pack (England)","equation":"","live":"","result":"WAS-W won by 7 wickets","result_type":2,"win_margin":"7 wickets","winning_team_id":19223,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-11 00:41:46","verify_time":"2025-06-11 22:20:17","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"scattered clouds","temp":13.51,"humidity":84,"visibility":10000,"wind_speed":"16.04","clouds":41},"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"Low Scoring","pace_bowling_condition":"Average","spine_bowling_condition":"Average"},"toss":{"text":"Durham Women elected to bat","winner":19270,"decision":1}},"etag":"32ad2b675ff65346fe7750eb86fa2a2f","modified":"2025-06-14 03:53:16","datetime":"2025-06-14 03:53:16","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":90244,"title":"Durham Women vs Warwickshire Women","short_title":"DUR-W vs WAS-W","subtitle":"Match 18","match_number":"18","format":8,"format_str":"Women T20","status":2,"status_str":"Completed","status_note":"Warwickshire Women won by 7 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129426,"title":"Vitality Blast Women","abbr":"Vitality Blast Women ","type":"tournament","category":"women","match_format":"woment20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-07-27","country":"en","total_matches":"57","total_rounds":"2","total_teams":"15"},"teama":{"team_id":19270,"name":"Durham Women","short_name":"DUR-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/09\/Rectangle-3493-25.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/09\/Rectangle-3493-25.png","scores_full":"162\/5 (20 ov)","scores":"162\/5","overs":"20"},"teamb":{"team_id":19223,"name":"Warwickshire Women","short_name":"WAS-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/09\/Rectangle-3493-10.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/09\/Rectangle-3493-10.png","scores_full":"165\/3 (18.2 ov)","scores":"165\/3","overs":"18.2"},"date_start":"2025-06-11 13:30:00","date_end":"2025-06-11 23:30:00","timestamp_start":1749648600,"timestamp_end":1749684600,"date_start_ist":"2025-06-11 19:00:00","date_end_ist":"2025-06-12 05:00:00","venue":{"venue_id":"39","name":"Riverside Ground, Chester-le-Street","location":"Chester-le-Street","country":"England","timezone":""},"umpires":"Simon Widdup (England), Jasmine Naeem (England)","referee":"Helen Pack (England)","equation":"","live":"","result":"WAS-W won by 7 wickets","result_type":2,"win_margin":"7 wickets","winning_team_id":19223,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-11 00:41:46","verify_time":"2025-06-11 22:20:17","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"scattered clouds","temp":13.51,"humidity":84,"visibility":10000,"wind_speed":"16.04","clouds":41},"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"Low Scoring","pace_bowling_condition":"Average","spine_bowling_condition":"Average"},"toss":{"text":"Durham Women elected to bat","winner":19270,"decision":1}},"etag":"32ad2b675ff65346fe7750eb86fa2a2f","modified":"2025-06-14 03:53:16","datetime":"2025-06-14 03:53:16","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90244 AND DataTypeId = 3 END Live Report & Scorecard of Durham Women vs Warwickshire Women Match 18
Durham Women vs Warwickshire Women, Live Cricket Commentary