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 = 90240 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90240,1,'{"status":"ok","response":{"mid":90240,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Durham Women won by 1 run (DLS method)","day_remaining_over":"","team_batting":"Hampshire Women","team_bowling":"Durham Women","live_inning_number":2,"live_score":{"runs":33,"overs":6,"wickets":2,"target":35,"runrate":5.5,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Freya Kemp","batsman_id":102782,"runs":4,"balls_faced":8,"fours":0,"sixes":0,"strike_rate":"50.00"},{"name":"Maia Bouchier","batsman_id":61333,"runs":22,"balls_faced":21,"fours":4,"sixes":0,"strike_rate":"104.76"}],"bowlers":[{"name":"Grace Thompson","bowler_id":146141,"overs":2,"runs_conceded":8,"wickets":0,"maidens":0,"econ":"4.00"},{"name":"Trudy Johnson","bowler_id":137961,"overs":1,"runs_conceded":8,"wickets":0,"maidens":0,"econ":"8.00"}],"commentaries":[{"event_id":"12094074","event":"ball","batsman_id":"102764","bowler_id":"51467","over":"1","ball":"5","score":0,"commentary":"Mady Villiers to Ella McCaughan, no run,","noball_dismissal":false,"text":"","timestamp":1749309037,"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":"12094090","event":"wicket","batsman_id":"102764","bowler_id":"51467","over":"1","ball":"6","score":"w","commentary":"Mady Villiers to Ella McCaughan, no run, c E Marlow b MK Villiers,","noball_dismissal":false,"text":"","timestamp":1749309078,"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":"102764","how_out":"c E Marlow b MK Villiers","batsman_runs":"4","batsman_balls":"7"},{"event":"overend","over":2,"runs":2,"score":"8\/1","bats":[{"runs":4,"balls_faced":7,"fours":0,"sixes":0,"batsman_id":102764},{"runs":2,"balls_faced":5,"fours":0,"sixes":0,"batsman_id":61333}],"bowls":[{"runs_conceded":2,"maidens":0,"wickets":1,"bowler_id":51467,"overs":1},{"runs_conceded":6,"maidens":0,"wickets":0,"bowler_id":146141,"overs":1}],"commentary":"End of over 2 (2 runs), Hampshire Women 8\/1"},{"event_id":"12094120","event":"ball","batsman_id":"61333","bowler_id":"51493","over":"2","ball":"1","score":0,"commentary":"Katie Levick to Maia Bouchier, no run,","noball_dismissal":false,"text":"","timestamp":1749309217,"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":"12094122","event":"ball","batsman_id":"61333","bowler_id":"51493","over":"2","ball":"2","score":1,"commentary":"Katie Levick to Maia Bouchier, 1 run,","noball_dismissal":false,"text":"","timestamp":1749309220,"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":"12094129","event":"wicket","batsman_id":"85320","bowler_id":"51493","over":"2","ball":"3","score":"w","commentary":"Katie Levick to Charli Knott, no run, b KA Levick,","noball_dismissal":false,"text":"","timestamp":1749309223,"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":"85320","how_out":"b KA Levick","batsman_runs":"0","batsman_balls":"1"},{"event_id":"12094145","event":"ball","batsman_id":"102782","bowler_id":"51493","over":"2","ball":"4","score":0,"commentary":"Katie Levick to Freya Kemp, no run,","noball_dismissal":false,"text":"","timestamp":1749309266,"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":"12094158","event":"ball","batsman_id":"102782","bowler_id":"51493","over":"2","ball":"5","score":2,"commentary":"Katie Levick to Freya Kemp, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749309313,"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":"12094182","event":"ball","batsman_id":"102782","bowler_id":"51493","over":"2","ball":"6","score":0,"commentary":"Katie Levick to Freya Kemp, no run,","noball_dismissal":false,"text":"","timestamp":1749309392,"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":3,"runs":3,"score":"11\/2","bats":[{"runs":2,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":102782},{"runs":3,"balls_faced":7,"fours":0,"sixes":0,"batsman_id":61333}],"bowls":[{"runs_conceded":3,"maidens":0,"wickets":1,"bowler_id":51493,"overs":1},{"runs_conceded":2,"maidens":0,"wickets":1,"bowler_id":51467,"overs":1}],"commentary":"End of over 3 (3 runs), Hampshire Women 11\/2"},{"event_id":"12094191","event":"ball","batsman_id":"61333","bowler_id":"51467","over":"3","ball":"1","score":4,"commentary":"Mady Villiers to Maia Bouchier, Four,","noball_dismissal":false,"text":"","timestamp":1749309396,"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":"12094199","event":"ball","batsman_id":"61333","bowler_id":"51467","over":"3","ball":"2","score":4,"commentary":"Mady Villiers to Maia Bouchier, Four,","noball_dismissal":false,"text":"","timestamp":1749309435,"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":"12094210","event":"ball","batsman_id":"61333","bowler_id":"51467","over":"3","ball":"3","score":0,"commentary":"Mady Villiers to Maia Bouchier, no run,","noball_dismissal":false,"text":"","timestamp":1749309506,"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":"12094211","event":"ball","batsman_id":"61333","bowler_id":"51467","over":"3","ball":"4","score":1,"commentary":"Mady Villiers to Maia Bouchier, 1 run,","noball_dismissal":false,"text":"","timestamp":1749309515,"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":"12094212","event":"ball","batsman_id":"102782","bowler_id":"51467","over":"3","ball":"5","score":1,"commentary":"Mady Villiers to Freya Kemp, 1 run,","noball_dismissal":false,"text":"","timestamp":1749310454,"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":"12094222","event":"ball","batsman_id":"61333","bowler_id":"51467","over":"3","ball":"6","score":1,"commentary":"Mady Villiers to Maia Bouchier, 1 run,","noball_dismissal":false,"text":"","timestamp":1749309551,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":4,"runs":11,"score":"22\/2","bats":[{"runs":13,"balls_faced":12,"fours":2,"sixes":0,"batsman_id":61333},{"runs":3,"balls_faced":4,"fours":0,"sixes":0,"batsman_id":102782}],"bowls":[{"runs_conceded":13,"maidens":0,"wickets":1,"bowler_id":51467,"overs":2},{"runs_conceded":3,"maidens":0,"wickets":1,"bowler_id":51493,"overs":1}],"commentary":"End of over 4 (11 runs), Hampshire Women 22\/2"},{"event_id":"12094278","event":"ball","batsman_id":"61333","bowler_id":"137961","over":"4","ball":"1","score":0,"commentary":"Trudy Johnson to Maia Bouchier, no run,","noball_dismissal":false,"text":"","timestamp":1749309955,"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":"12094279","event":"ball","batsman_id":"61333","bowler_id":"137961","over":"4","ball":"2","score":0,"commentary":"Trudy Johnson to Maia Bouchier, no run,","noball_dismissal":false,"text":"","timestamp":1749309957,"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":"12094280","event":"ball","batsman_id":"61333","bowler_id":"137961","over":"4","ball":"3","score":4,"commentary":"Trudy Johnson to Maia Bouchier, Four,","noball_dismissal":false,"text":"","timestamp":1749309983,"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":"12094281","event":"ball","batsman_id":"61333","bowler_id":"137961","over":"4","ball":"4","score":4,"commentary":"Trudy Johnson to Maia Bouchier, Four,","noball_dismissal":false,"text":"","timestamp":1749309986,"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":"12094283","event":"ball","batsman_id":"61333","bowler_id":"137961","over":"4","ball":"5","score":0,"commentary":"Trudy Johnson to Maia Bouchier, no run,","noball_dismissal":false,"text":"","timestamp":1749309990,"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":"12094284","event":"ball","batsman_id":"61333","bowler_id":"137961","over":"4","ball":"6","score":0,"commentary":"Trudy Johnson to Maia Bouchier, no run,","noball_dismissal":false,"text":"","timestamp":1749309994,"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":5,"runs":8,"score":"30\/2","bats":[{"runs":21,"balls_faced":18,"fours":4,"sixes":0,"batsman_id":61333},{"runs":3,"balls_faced":4,"fours":0,"sixes":0,"batsman_id":102782}],"bowls":[{"runs_conceded":8,"maidens":0,"wickets":0,"bowler_id":137961,"overs":1},{"runs_conceded":13,"maidens":0,"wickets":1,"bowler_id":51467,"overs":2}],"commentary":"End of over 5 (8 runs), Hampshire Women 30\/2"},{"event_id":"12094296","event":"ball","batsman_id":"102782","bowler_id":"146141","over":"5","ball":"1","score":0,"commentary":"Grace Thompson to Freya Kemp, no run,","noball_dismissal":false,"text":"","timestamp":1749310054,"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":"12094299","event":"ball","batsman_id":"102782","bowler_id":"146141","over":"5","ball":"2","score":1,"commentary":"Grace Thompson to Freya Kemp, 1 run,","noball_dismissal":false,"text":"","timestamp":1749310057,"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":"12094301","event":"ball","batsman_id":"61333","bowler_id":"146141","over":"5","ball":"3","score":0,"commentary":"Grace Thompson to Maia Bouchier, no run,","noball_dismissal":false,"text":"","timestamp":1749310060,"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":"12094304","event":"ball","batsman_id":"61333","bowler_id":"146141","over":"5","ball":"4","score":0,"commentary":"Grace Thompson to Maia Bouchier, no run,","noball_dismissal":false,"text":"","timestamp":1749310064,"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":"12094307","event":"ball","batsman_id":"61333","bowler_id":"146141","over":"5","ball":"5","score":1,"commentary":"Grace Thompson to Maia Bouchier, 1 run,","noball_dismissal":false,"text":"","timestamp":1749310067,"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":"12094309","event":"ball","batsman_id":"102782","bowler_id":"146141","over":"5","ball":"6","score":"1lb","commentary":"Grace Thompson to Freya Kemp, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1749315885,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"1","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":6,"runs":3,"score":"33\/2","bats":[{"runs":4,"balls_faced":7,"fours":0,"sixes":0,"batsman_id":102782},{"runs":22,"balls_faced":21,"fours":4,"sixes":0,"batsman_id":61333}],"bowls":[{"runs_conceded":8,"maidens":0,"wickets":0,"bowler_id":146141,"overs":2},{"runs_conceded":8,"maidens":0,"wickets":0,"bowler_id":137961,"overs":1}],"commentary":"End of over 6 (3 runs), Hampshire Women 33\/2"}],"day":"0","session":"0","live_inning":{"iid":197616,"number":2,"name":"Hampshire Women Inning","short_name":"HAM-W Inning","status":2,"issuperover":"false","result":4,"batting_team_id":19277,"fielding_team_id":19270,"scores":"33\/2","scores_full":"33\/2 (6 ov)","fielder":[{"fielder_id":"116259","fielder_name":"Emma Marlow","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Charli Knott","batsman_id":"85320","runs":"0","balls":"1","how_out":"b KA Levick","score_at_dismissal":9,"overs_at_dismissal":"2.3","bowler_id":"51493","dismissal":"bowled","number":2},"extra_runs":{"byes":0,"legbyes":1,"wides":2,"noballs":0,"penalty":"0","total":3},"equations":{"runs":33,"wickets":2,"overs":"6","bowlers_used":4,"runrate":"5.50"},"current_partnership":{"runs":24,"balls":21,"overs":3.3,"batsmen":[{"name":"Freya Kemp","batsman_id":102782,"runs":4,"balls":7},{"name":"Maia Bouchier","batsman_id":61333,"runs":19,"balls":14}]},"did_not_bat":[{"player_id":"51733","name":"Georgia Adams"},{"player_id":"61327","name":"Rhianna Southby"},{"player_id":"90942","name":"Naomi Dattani"},{"player_id":"107883","name":"Mary Taylor"},{"player_id":"51734","name":"Freya Davies"},{"player_id":"107886","name":"Daisy Gibb"},{"player_id":"51502","name":"Rebecca Tyson"}],"max_over":"6","target":"35","recent_scores":"1,1,0,0,1,0,0,0,4,4,0,0,1,1,1,0,4,4","last_five_overs":"27\/2 5.40","last_ten_overs":"33\/2 5.21"},"teams":[{"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":"119\/6 (20 ov)","scores":"119\/6","overs":"20"},{"tid":19277,"title":"Hampshire Women","abbr":"HAM-W","alt_name":"HAM-W","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/12\/Hampshire-Women.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/12\/Hampshire-Women.png","country":"en","sex":"female","team_owner":"","head_coach":"","scores_full":"33\/2 (6 ov)","scores":"33\/2","overs":"6"}],"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":44686,"title":"Ellyse Perry","short_name":"EA Perry","first_name":"Ellyse Perry","last_name":"","middle_name":"","birthdate":"1990-11-03","birthplace":"Wahroonga, Sydney, New South Wales","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/ellyseperryofficial\/","twitter_profile":"https:\/\/twitter.com\/EllysePerry","instagram_profile":"https:\/\/www.instagram.com\/ellyseperry\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"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":51502,"title":"Rebecca Tyson","short_name":"R Tyson","first_name":"Rebecca Tyson","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":51656,"title":"Linsey Smith","short_name":"LCN Smith","first_name":"Linsey Smith","last_name":"","middle_name":"","birthdate":"1995-03-10","birthplace":"Hillingdon, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/LinseySmith95","instagram_profile":"https:\/\/www.instagram.com\/linseysm\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51663,"title":"Lauren Bell","short_name":"LK Bell","first_name":"Lauren Bell","last_name":"","middle_name":"","birthdate":"2001-01-02","birthplace":" Swindon, Wiltshire","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.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/_laurenbell2","instagram_profile":"https:\/\/www.instagram.com\/l.belll_\/","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":51733,"title":"Georgia Adams","short_name":"GL Adams","first_name":"Georgia Adams","last_name":"","middle_name":"","birthdate":"1993-10-04","birthplace":" Chesterfield, Derbyshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/GeorgiaAdams01","instagram_profile":"https:\/\/www.instagram.com\/gadams01\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":"(C)"},{"pid":51734,"title":"Freya Davies","short_name":"FR Davies","first_name":"Freya Davies","last_name":"","middle_name":"","birthdate":"1995-10-27","birthplace":"Chichester, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/FreyaRuth","instagram_profile":"https:\/\/www.instagram.com\/freyaruth\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","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":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":61327,"title":"Rhianna Southby","short_name":"RM Southby","first_name":"Rhianna Southby","last_name":"","middle_name":"","birthdate":"2000-08-16","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper ","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/rhianna_southby","instagram_profile":"https:\/\/www.instagram.com\/rhianna_southby\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":61333,"title":"Maia Bouchier","short_name":"ME Bouchier","first_name":"Maia Bouchier","last_name":"","middle_name":"","birthdate":"1998-12-05","birthplace":"Kensington, Middlesex","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":9,"facebook_profile":"https:\/\/www.facebook.com\/maia.bouchier.5\/","twitter_profile":"https:\/\/twitter.com\/maiabouchier","instagram_profile":"https:\/\/www.instagram.com\/maiabouchier\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":85320,"title":"Charli Knott","short_name":"C Knott","first_name":"Charli Knott","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"all","role_str":""},{"pid":90942,"title":"Naomi Dattani","short_name":"ND Dattani","first_name":"Naomi Dattani","last_name":"","middle_name":"","birthdate":"1994-04-28","birthplace":"Ealing, Middlesex","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\/NaomiDattani","instagram_profile":"https:\/\/www.instagram.com\/naomi.dattani\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"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":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":102764,"title":"Ella McCaughan","short_name":"E McCaughan","first_name":"Ella McCaughan","last_name":"","middle_name":"","birthdate":"2002-09-26","birthplace":"Southampton, Hampshire","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":"https:\/\/twitter.com\/ella_mccaughan","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":102766,"title":"Nancy Harman","short_name":"N Harman","first_name":"Nancy Harman","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","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":102782,"title":"Freya Kemp","short_name":"F Kemp","first_name":"Freya Kemp","last_name":"","middle_name":"","birthdate":"2005-04-21","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/KempFreya","instagram_profile":"https:\/\/www.instagram.com\/freyagkemp\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","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":"squad","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":"squad","role_str":""},{"pid":107871,"title":"Megan Sturge","short_name":"M Sturge","first_name":"Megan Sturge","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":107883,"title":"Mary Taylor","short_name":"M Taylor","first_name":"Mary Taylor","last_name":"","middle_name":"","birthdate":"2004-10-07","birthplace":"Eastbourne, England","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":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":107886,"title":"Daisy Gibb","short_name":"D Gibb","first_name":"Daisy Gibb","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":110339,"title":"Daisy Mullan","short_name":"D Mullan","first_name":"Daisy Mullan","last_name":"","middle_name":"","birthdate":"2002-11-29","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":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":"bat","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":"all","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":128845,"title":"Ava Lee","short_name":"A Lee","first_name":"Ava Lee","last_name":"","middle_name":"","birthdate":"2005-08-26","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":128846,"title":"Abi Norgrove","short_name":"A Norgrove","first_name":"Abi Norgrove","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":139765,"title":"Poppy G Tulloch","short_name":"P Tulloch","first_name":"Poppy G Tulloch","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","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":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":"4e6a8ca0522ea9669dbbdd0641dfcf1c","modified":"2025-06-14 04:03:43","datetime":"2025-06-14 04:03:43","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":90240,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Durham Women won by 1 run (DLS method)","day_remaining_over":"","team_batting":"Hampshire Women","team_bowling":"Durham Women","live_inning_number":2,"live_score":{"runs":33,"overs":6,"wickets":2,"target":35,"runrate":5.5,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Freya Kemp","batsman_id":102782,"runs":4,"balls_faced":8,"fours":0,"sixes":0,"strike_rate":"50.00"},{"name":"Maia Bouchier","batsman_id":61333,"runs":22,"balls_faced":21,"fours":4,"sixes":0,"strike_rate":"104.76"}],"bowlers":[{"name":"Grace Thompson","bowler_id":146141,"overs":2,"runs_conceded":8,"wickets":0,"maidens":0,"econ":"4.00"},{"name":"Trudy Johnson","bowler_id":137961,"overs":1,"runs_conceded":8,"wickets":0,"maidens":0,"econ":"8.00"}],"commentaries":[{"event_id":"12094074","event":"ball","batsman_id":"102764","bowler_id":"51467","over":"1","ball":"5","score":0,"commentary":"Mady Villiers to Ella McCaughan, no run,","noball_dismissal":false,"text":"","timestamp":1749309037,"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":"12094090","event":"wicket","batsman_id":"102764","bowler_id":"51467","over":"1","ball":"6","score":"w","commentary":"Mady Villiers to Ella McCaughan, no run, c E Marlow b MK Villiers,","noball_dismissal":false,"text":"","timestamp":1749309078,"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":"102764","how_out":"c E Marlow b MK Villiers","batsman_runs":"4","batsman_balls":"7"},{"event":"overend","over":2,"runs":2,"score":"8\/1","bats":[{"runs":4,"balls_faced":7,"fours":0,"sixes":0,"batsman_id":102764},{"runs":2,"balls_faced":5,"fours":0,"sixes":0,"batsman_id":61333}],"bowls":[{"runs_conceded":2,"maidens":0,"wickets":1,"bowler_id":51467,"overs":1},{"runs_conceded":6,"maidens":0,"wickets":0,"bowler_id":146141,"overs":1}],"commentary":"End of over 2 (2 runs), Hampshire Women 8\/1"},{"event_id":"12094120","event":"ball","batsman_id":"61333","bowler_id":"51493","over":"2","ball":"1","score":0,"commentary":"Katie Levick to Maia Bouchier, no run,","noball_dismissal":false,"text":"","timestamp":1749309217,"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":"12094122","event":"ball","batsman_id":"61333","bowler_id":"51493","over":"2","ball":"2","score":1,"commentary":"Katie Levick to Maia Bouchier, 1 run,","noball_dismissal":false,"text":"","timestamp":1749309220,"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":"12094129","event":"wicket","batsman_id":"85320","bowler_id":"51493","over":"2","ball":"3","score":"w","commentary":"Katie Levick to Charli Knott, no run, b KA Levick,","noball_dismissal":false,"text":"","timestamp":1749309223,"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":"85320","how_out":"b KA Levick","batsman_runs":"0","batsman_balls":"1"},{"event_id":"12094145","event":"ball","batsman_id":"102782","bowler_id":"51493","over":"2","ball":"4","score":0,"commentary":"Katie Levick to Freya Kemp, no run,","noball_dismissal":false,"text":"","timestamp":1749309266,"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":"12094158","event":"ball","batsman_id":"102782","bowler_id":"51493","over":"2","ball":"5","score":2,"commentary":"Katie Levick to Freya Kemp, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749309313,"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":"12094182","event":"ball","batsman_id":"102782","bowler_id":"51493","over":"2","ball":"6","score":0,"commentary":"Katie Levick to Freya Kemp, no run,","noball_dismissal":false,"text":"","timestamp":1749309392,"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":3,"runs":3,"score":"11\/2","bats":[{"runs":2,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":102782},{"runs":3,"balls_faced":7,"fours":0,"sixes":0,"batsman_id":61333}],"bowls":[{"runs_conceded":3,"maidens":0,"wickets":1,"bowler_id":51493,"overs":1},{"runs_conceded":2,"maidens":0,"wickets":1,"bowler_id":51467,"overs":1}],"commentary":"End of over 3 (3 runs), Hampshire Women 11\/2"},{"event_id":"12094191","event":"ball","batsman_id":"61333","bowler_id":"51467","over":"3","ball":"1","score":4,"commentary":"Mady Villiers to Maia Bouchier, Four,","noball_dismissal":false,"text":"","timestamp":1749309396,"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":"12094199","event":"ball","batsman_id":"61333","bowler_id":"51467","over":"3","ball":"2","score":4,"commentary":"Mady Villiers to Maia Bouchier, Four,","noball_dismissal":false,"text":"","timestamp":1749309435,"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":"12094210","event":"ball","batsman_id":"61333","bowler_id":"51467","over":"3","ball":"3","score":0,"commentary":"Mady Villiers to Maia Bouchier, no run,","noball_dismissal":false,"text":"","timestamp":1749309506,"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":"12094211","event":"ball","batsman_id":"61333","bowler_id":"51467","over":"3","ball":"4","score":1,"commentary":"Mady Villiers to Maia Bouchier, 1 run,","noball_dismissal":false,"text":"","timestamp":1749309515,"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":"12094212","event":"ball","batsman_id":"102782","bowler_id":"51467","over":"3","ball":"5","score":1,"commentary":"Mady Villiers to Freya Kemp, 1 run,","noball_dismissal":false,"text":"","timestamp":1749310454,"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":"12094222","event":"ball","batsman_id":"61333","bowler_id":"51467","over":"3","ball":"6","score":1,"commentary":"Mady Villiers to Maia Bouchier, 1 run,","noball_dismissal":false,"text":"","timestamp":1749309551,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":4,"runs":11,"score":"22\/2","bats":[{"runs":13,"balls_faced":12,"fours":2,"sixes":0,"batsman_id":61333},{"runs":3,"balls_faced":4,"fours":0,"sixes":0,"batsman_id":102782}],"bowls":[{"runs_conceded":13,"maidens":0,"wickets":1,"bowler_id":51467,"overs":2},{"runs_conceded":3,"maidens":0,"wickets":1,"bowler_id":51493,"overs":1}],"commentary":"End of over 4 (11 runs), Hampshire Women 22\/2"},{"event_id":"12094278","event":"ball","batsman_id":"61333","bowler_id":"137961","over":"4","ball":"1","score":0,"commentary":"Trudy Johnson to Maia Bouchier, no run,","noball_dismissal":false,"text":"","timestamp":1749309955,"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":"12094279","event":"ball","batsman_id":"61333","bowler_id":"137961","over":"4","ball":"2","score":0,"commentary":"Trudy Johnson to Maia Bouchier, no run,","noball_dismissal":false,"text":"","timestamp":1749309957,"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":"12094280","event":"ball","batsman_id":"61333","bowler_id":"137961","over":"4","ball":"3","score":4,"commentary":"Trudy Johnson to Maia Bouchier, Four,","noball_dismissal":false,"text":"","timestamp":1749309983,"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":"12094281","event":"ball","batsman_id":"61333","bowler_id":"137961","over":"4","ball":"4","score":4,"commentary":"Trudy Johnson to Maia Bouchier, Four,","noball_dismissal":false,"text":"","timestamp":1749309986,"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":"12094283","event":"ball","batsman_id":"61333","bowler_id":"137961","over":"4","ball":"5","score":0,"commentary":"Trudy Johnson to Maia Bouchier, no run,","noball_dismissal":false,"text":"","timestamp":1749309990,"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":"12094284","event":"ball","batsman_id":"61333","bowler_id":"137961","over":"4","ball":"6","score":0,"commentary":"Trudy Johnson to Maia Bouchier, no run,","noball_dismissal":false,"text":"","timestamp":1749309994,"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":5,"runs":8,"score":"30\/2","bats":[{"runs":21,"balls_faced":18,"fours":4,"sixes":0,"batsman_id":61333},{"runs":3,"balls_faced":4,"fours":0,"sixes":0,"batsman_id":102782}],"bowls":[{"runs_conceded":8,"maidens":0,"wickets":0,"bowler_id":137961,"overs":1},{"runs_conceded":13,"maidens":0,"wickets":1,"bowler_id":51467,"overs":2}],"commentary":"End of over 5 (8 runs), Hampshire Women 30\/2"},{"event_id":"12094296","event":"ball","batsman_id":"102782","bowler_id":"146141","over":"5","ball":"1","score":0,"commentary":"Grace Thompson to Freya Kemp, no run,","noball_dismissal":false,"text":"","timestamp":1749310054,"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":"12094299","event":"ball","batsman_id":"102782","bowler_id":"146141","over":"5","ball":"2","score":1,"commentary":"Grace Thompson to Freya Kemp, 1 run,","noball_dismissal":false,"text":"","timestamp":1749310057,"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":"12094301","event":"ball","batsman_id":"61333","bowler_id":"146141","over":"5","ball":"3","score":0,"commentary":"Grace Thompson to Maia Bouchier, no run,","noball_dismissal":false,"text":"","timestamp":1749310060,"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":"12094304","event":"ball","batsman_id":"61333","bowler_id":"146141","over":"5","ball":"4","score":0,"commentary":"Grace Thompson to Maia Bouchier, no run,","noball_dismissal":false,"text":"","timestamp":1749310064,"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":"12094307","event":"ball","batsman_id":"61333","bowler_id":"146141","over":"5","ball":"5","score":1,"commentary":"Grace Thompson to Maia Bouchier, 1 run,","noball_dismissal":false,"text":"","timestamp":1749310067,"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":"12094309","event":"ball","batsman_id":"102782","bowler_id":"146141","over":"5","ball":"6","score":"1lb","commentary":"Grace Thompson to Freya Kemp, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1749315885,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"1","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":6,"runs":3,"score":"33\/2","bats":[{"runs":4,"balls_faced":7,"fours":0,"sixes":0,"batsman_id":102782},{"runs":22,"balls_faced":21,"fours":4,"sixes":0,"batsman_id":61333}],"bowls":[{"runs_conceded":8,"maidens":0,"wickets":0,"bowler_id":146141,"overs":2},{"runs_conceded":8,"maidens":0,"wickets":0,"bowler_id":137961,"overs":1}],"commentary":"End of over 6 (3 runs), Hampshire Women 33\/2"}],"day":"0","session":"0","live_inning":{"iid":197616,"number":2,"name":"Hampshire Women Inning","short_name":"HAM-W Inning","status":2,"issuperover":"false","result":4,"batting_team_id":19277,"fielding_team_id":19270,"scores":"33\/2","scores_full":"33\/2 (6 ov)","fielder":[{"fielder_id":"116259","fielder_name":"Emma Marlow","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Charli Knott","batsman_id":"85320","runs":"0","balls":"1","how_out":"b KA Levick","score_at_dismissal":9,"overs_at_dismissal":"2.3","bowler_id":"51493","dismissal":"bowled","number":2},"extra_runs":{"byes":0,"legbyes":1,"wides":2,"noballs":0,"penalty":"0","total":3},"equations":{"runs":33,"wickets":2,"overs":"6","bowlers_used":4,"runrate":"5.50"},"current_partnership":{"runs":24,"balls":21,"overs":3.3,"batsmen":[{"name":"Freya Kemp","batsman_id":102782,"runs":4,"balls":7},{"name":"Maia Bouchier","batsman_id":61333,"runs":19,"balls":14}]},"did_not_bat":[{"player_id":"51733","name":"Georgia Adams"},{"player_id":"61327","name":"Rhianna Southby"},{"player_id":"90942","name":"Naomi Dattani"},{"player_id":"107883","name":"Mary Taylor"},{"player_id":"51734","name":"Freya Davies"},{"player_id":"107886","name":"Daisy Gibb"},{"player_id":"51502","name":"Rebecca Tyson"}],"max_over":"6","target":"35","recent_scores":"1,1,0,0,1,0,0,0,4,4,0,0,1,1,1,0,4,4","last_five_overs":"27\/2 5.40","last_ten_overs":"33\/2 5.21"},"teams":[{"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":"119\/6 (20 ov)","scores":"119\/6","overs":"20"},{"tid":19277,"title":"Hampshire Women","abbr":"HAM-W","alt_name":"HAM-W","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/12\/Hampshire-Women.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/12\/Hampshire-Women.png","country":"en","sex":"female","team_owner":"","head_coach":"","scores_full":"33\/2 (6 ov)","scores":"33\/2","overs":"6"}],"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":44686,"title":"Ellyse Perry","short_name":"EA Perry","first_name":"Ellyse Perry","last_name":"","middle_name":"","birthdate":"1990-11-03","birthplace":"Wahroonga, Sydney, New South Wales","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/ellyseperryofficial\/","twitter_profile":"https:\/\/twitter.com\/EllysePerry","instagram_profile":"https:\/\/www.instagram.com\/ellyseperry\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"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":51502,"title":"Rebecca Tyson","short_name":"R Tyson","first_name":"Rebecca Tyson","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":51656,"title":"Linsey Smith","short_name":"LCN Smith","first_name":"Linsey Smith","last_name":"","middle_name":"","birthdate":"1995-03-10","birthplace":"Hillingdon, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/LinseySmith95","instagram_profile":"https:\/\/www.instagram.com\/linseysm\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51663,"title":"Lauren Bell","short_name":"LK Bell","first_name":"Lauren Bell","last_name":"","middle_name":"","birthdate":"2001-01-02","birthplace":" Swindon, Wiltshire","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.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/_laurenbell2","instagram_profile":"https:\/\/www.instagram.com\/l.belll_\/","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":51733,"title":"Georgia Adams","short_name":"GL Adams","first_name":"Georgia Adams","last_name":"","middle_name":"","birthdate":"1993-10-04","birthplace":" Chesterfield, Derbyshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/GeorgiaAdams01","instagram_profile":"https:\/\/www.instagram.com\/gadams01\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":"(C)"},{"pid":51734,"title":"Freya Davies","short_name":"FR Davies","first_name":"Freya Davies","last_name":"","middle_name":"","birthdate":"1995-10-27","birthplace":"Chichester, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/FreyaRuth","instagram_profile":"https:\/\/www.instagram.com\/freyaruth\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","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":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":61327,"title":"Rhianna Southby","short_name":"RM Southby","first_name":"Rhianna Southby","last_name":"","middle_name":"","birthdate":"2000-08-16","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper ","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/rhianna_southby","instagram_profile":"https:\/\/www.instagram.com\/rhianna_southby\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":61333,"title":"Maia Bouchier","short_name":"ME Bouchier","first_name":"Maia Bouchier","last_name":"","middle_name":"","birthdate":"1998-12-05","birthplace":"Kensington, Middlesex","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":9,"facebook_profile":"https:\/\/www.facebook.com\/maia.bouchier.5\/","twitter_profile":"https:\/\/twitter.com\/maiabouchier","instagram_profile":"https:\/\/www.instagram.com\/maiabouchier\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":85320,"title":"Charli Knott","short_name":"C Knott","first_name":"Charli Knott","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"all","role_str":""},{"pid":90942,"title":"Naomi Dattani","short_name":"ND Dattani","first_name":"Naomi Dattani","last_name":"","middle_name":"","birthdate":"1994-04-28","birthplace":"Ealing, Middlesex","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\/NaomiDattani","instagram_profile":"https:\/\/www.instagram.com\/naomi.dattani\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"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":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":102764,"title":"Ella McCaughan","short_name":"E McCaughan","first_name":"Ella McCaughan","last_name":"","middle_name":"","birthdate":"2002-09-26","birthplace":"Southampton, Hampshire","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":"https:\/\/twitter.com\/ella_mccaughan","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":102766,"title":"Nancy Harman","short_name":"N Harman","first_name":"Nancy Harman","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","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":102782,"title":"Freya Kemp","short_name":"F Kemp","first_name":"Freya Kemp","last_name":"","middle_name":"","birthdate":"2005-04-21","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/KempFreya","instagram_profile":"https:\/\/www.instagram.com\/freyagkemp\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","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":"squad","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":"squad","role_str":""},{"pid":107871,"title":"Megan Sturge","short_name":"M Sturge","first_name":"Megan Sturge","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":107883,"title":"Mary Taylor","short_name":"M Taylor","first_name":"Mary Taylor","last_name":"","middle_name":"","birthdate":"2004-10-07","birthplace":"Eastbourne, England","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":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":107886,"title":"Daisy Gibb","short_name":"D Gibb","first_name":"Daisy Gibb","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":110339,"title":"Daisy Mullan","short_name":"D Mullan","first_name":"Daisy Mullan","last_name":"","middle_name":"","birthdate":"2002-11-29","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":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":"bat","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":"all","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":128845,"title":"Ava Lee","short_name":"A Lee","first_name":"Ava Lee","last_name":"","middle_name":"","birthdate":"2005-08-26","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":128846,"title":"Abi Norgrove","short_name":"A Norgrove","first_name":"Abi Norgrove","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":139765,"title":"Poppy G Tulloch","short_name":"P Tulloch","first_name":"Poppy G Tulloch","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","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":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","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":"4e6a8ca0522ea9669dbbdd0641dfcf1c","modified":"2025-06-14 04:03:43","datetime":"2025-06-14 04:03:43","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90240 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:759dcd5a-ea41-4c80-ba98-cbe8f98f3be7
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90240 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90240,3,'{"status":"ok","response":{"match_id":90240,"title":"Hampshire Women vs Durham Women","short_title":"HAM-W vs DUR-W","subtitle":"Match 14","match_number":"14","format":8,"format_str":"Women T20","status":2,"status_str":"Completed","status_note":"Durham Women won by 1 run (DLS method)","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":19277,"name":"Hampshire Women","short_name":"HAM-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/12\/Hampshire-Women.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/12\/Hampshire-Women.png","scores_full":"33\/2 (6 ov)","scores":"33\/2","overs":"6"},"teamb":{"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":"119\/6 (20 ov)","scores":"119\/6","overs":"20"},"date_start":"2025-06-07 13:30:00","date_end":"2025-06-07 23:30:00","timestamp_start":1749303000,"timestamp_end":1749339000,"date_start_ist":"2025-06-07 19:00:00","date_end_ist":"2025-06-08 05:00:00","venue":{"venue_id":"56","name":"Arundel Castle Cricket Club Ground","location":"Arundel","country":"England","timezone":""},"umpires":"","referee":"","equation":"","live":"","result":"DUR-W won by 1 run (DLS method)","result_type":2,"win_margin":"1 run (DLS method)","winning_team_id":19270,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-06 17:00:22","verify_time":"2025-06-07 22:43:42","match_dls_affected":"true","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"","weather_desc":"","temp":"","humidity":"","visibility":"","wind_speed":"","clouds":""},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Hampshire Women elected to bowl","winner":19277,"decision":2}},"etag":"4e6a8ca0522ea9669dbbdd0641dfcf1c","modified":"2025-06-14 04:03:43","datetime":"2025-06-14 04:03:43","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":90240,"title":"Hampshire Women vs Durham Women","short_title":"HAM-W vs DUR-W","subtitle":"Match 14","match_number":"14","format":8,"format_str":"Women T20","status":2,"status_str":"Completed","status_note":"Durham Women won by 1 run (DLS method)","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":19277,"name":"Hampshire Women","short_name":"HAM-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/12\/Hampshire-Women.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/12\/Hampshire-Women.png","scores_full":"33\/2 (6 ov)","scores":"33\/2","overs":"6"},"teamb":{"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":"119\/6 (20 ov)","scores":"119\/6","overs":"20"},"date_start":"2025-06-07 13:30:00","date_end":"2025-06-07 23:30:00","timestamp_start":1749303000,"timestamp_end":1749339000,"date_start_ist":"2025-06-07 19:00:00","date_end_ist":"2025-06-08 05:00:00","venue":{"venue_id":"56","name":"Arundel Castle Cricket Club Ground","location":"Arundel","country":"England","timezone":""},"umpires":"","referee":"","equation":"","live":"","result":"DUR-W won by 1 run (DLS method)","result_type":2,"win_margin":"1 run (DLS method)","winning_team_id":19270,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-06 17:00:22","verify_time":"2025-06-07 22:43:42","match_dls_affected":"true","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"","weather_desc":"","temp":"","humidity":"","visibility":"","wind_speed":"","clouds":""},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Hampshire Women elected to bowl","winner":19277,"decision":2}},"etag":"4e6a8ca0522ea9669dbbdd0641dfcf1c","modified":"2025-06-14 04:03:43","datetime":"2025-06-14 04:03:43","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90240 AND DataTypeId = 3 END Live Report & Scorecard of Hampshire Women vs Durham Women Match 14
Hampshire Women vs Durham Women, Live Cricket Commentary