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:ed5f5656-6685-43bd-8e9d-897a840bdd43
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90174 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90174,1,'{"status":"ok","response":{"mid":90174,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Sweden Women won by 18 runs","day_remaining_over":"","team_batting":"Jersey Women","team_bowling":"Sweden Women","live_inning_number":2,"live_score":{"runs":110,"overs":18,"wickets":10,"target":129,"runrate":6.11,"required_runrate":9.5},"commentary":1,"wagon":2,"batsmen":[{"name":"Aimee Aikenhead","batsman_id":127551,"runs":58,"balls_faced":53,"fours":8,"sixes":0,"strike_rate":"109.43"},{"name":"Olivia Bastin","batsman_id":145394,"runs":0,"balls_faced":7,"fours":0,"sixes":0,"strike_rate":"0.00"}],"bowlers":[{"name":"Gaya Jayaweera","bowler_id":149026,"overs":2,"runs_conceded":11,"wickets":4,"maidens":1,"econ":"5.50"},{"name":"Anya Vaidya","bowler_id":116708,"overs":3,"runs_conceded":11,"wickets":2,"maidens":0,"econ":"3.67"}],"commentaries":[{"event_id":"12041153","event":"ball","batsman_id":"127551","bowler_id":"116708","over":"14","ball":"3","score":1,"commentary":"Anya Vaidya to Aimee Aikenhead, 1 run,","noball_dismissal":false,"text":"","timestamp":1748516570,"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":"12041154","event":"ball","batsman_id":"115785","bowler_id":"116708","over":"14","ball":"4","score":0,"commentary":"Anya Vaidya to Chloe Greechan, no run,","noball_dismissal":false,"text":"","timestamp":1748516626,"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":"12041155","event":"ball","batsman_id":"115785","bowler_id":"116708","over":"14","ball":"5","score":"1wd","commentary":"Anya Vaidya to Chloe Greechan, 1 wide,","noball_dismissal":false,"text":"","timestamp":1748516648,"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":"12041156","event":"wicket","batsman_id":"115785","bowler_id":"116708","over":"14","ball":"5","score":"w","commentary":"Anya Vaidya to Chloe Greechan, no run, c G Shukla b A Vaidya,","noball_dismissal":false,"text":"","timestamp":1748516709,"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":"115785","how_out":"c G Shukla b A Vaidya","batsman_runs":"3","batsman_balls":"7"},{"event_id":"12041157","event":"ball","batsman_id":"148986","bowler_id":"116708","over":"14","ball":"6","score":"1lb","commentary":"Anya Vaidya to Annabel Mossop, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1748516826,"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":15,"runs":4,"score":"92\/6","bats":[{"runs":0,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":148986},{"runs":45,"balls_faced":44,"fours":6,"sixes":0,"batsman_id":127551}],"bowls":[{"runs_conceded":5,"maidens":0,"wickets":2,"bowler_id":116708,"overs":2},{"runs_conceded":22,"maidens":0,"wickets":1,"bowler_id":121384,"overs":4}],"commentary":"End of over 15 (4 runs), Jersey Women 92\/6"},{"event_id":"12041158","event":"wicket","batsman_id":"148986","bowler_id":"149026","over":"15","ball":"1","score":"w","commentary":"Gaya Jayaweera to Annabel Mossop, no run, c K Rana b Gaya Jayaweera,","noball_dismissal":false,"text":"","timestamp":1748516967,"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":"148986","how_out":"c K Rana b Gaya Jayaweera","batsman_runs":"0","batsman_balls":"2"},{"event_id":"12041164","event":"wicket","batsman_id":"148670","bowler_id":"149026","over":"15","ball":"2","score":"w","commentary":"Gaya Jayaweera to Nia Greig, no run, c A Vaidya b Gaya Jayaweera,","noball_dismissal":false,"text":"","timestamp":1748516997,"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":"148670","how_out":"c A Vaidya b Gaya Jayaweera","batsman_runs":"0","batsman_balls":"1"},{"event_id":"12041166","event":"wicket","batsman_id":"148676","bowler_id":"149026","over":"15","ball":"3","score":"w","commentary":"Gaya Jayaweera to Kate Follain, no run, b Gaya Jayaweera,","noball_dismissal":false,"text":"","timestamp":1748517409,"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":"148676","how_out":"b Gaya Jayaweera","batsman_runs":"0","batsman_balls":"1"},{"event_id":"12041173","event":"ball","batsman_id":"145394","bowler_id":"149026","over":"15","ball":"4","score":0,"commentary":"Gaya Jayaweera to Olivia Bastin, no run,","noball_dismissal":false,"text":"","timestamp":1748517510,"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":"12041174","event":"ball","batsman_id":"145394","bowler_id":"149026","over":"15","ball":"5","score":0,"commentary":"Gaya Jayaweera to Olivia Bastin, no run,","noball_dismissal":false,"text":"","timestamp":1748517515,"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":"12041175","event":"ball","batsman_id":"145394","bowler_id":"149026","over":"15","ball":"6","score":0,"commentary":"Gaya Jayaweera to Olivia Bastin, no run,","noball_dismissal":false,"text":"","timestamp":1748517518,"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":0,"score":"92\/9","bats":[{"runs":0,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":145394},{"runs":45,"balls_faced":44,"fours":6,"sixes":0,"batsman_id":127551}],"bowls":[{"runs_conceded":0,"maidens":1,"wickets":3,"bowler_id":149026,"overs":1},{"runs_conceded":5,"maidens":0,"wickets":2,"bowler_id":116708,"overs":2}],"commentary":"End of over 16 (0 runs), Jersey Women 92\/9"},{"event_id":"12041176","event":"ball","batsman_id":"127551","bowler_id":"116708","over":"16","ball":"1","score":"1wd","commentary":"Anya Vaidya to Aimee Aikenhead, 1 wide,","noball_dismissal":false,"text":"","timestamp":1748517520,"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":"12041177","event":"ball","batsman_id":"127551","bowler_id":"116708","over":"16","ball":"1","score":1,"commentary":"Anya Vaidya to Aimee Aikenhead, 1 run,","noball_dismissal":false,"text":"","timestamp":1748517524,"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":"12041179","event":"ball","batsman_id":"145394","bowler_id":"116708","over":"16","ball":"2","score":"1wd","commentary":"Anya Vaidya to Olivia Bastin, 1 wide,","noball_dismissal":false,"text":"","timestamp":1748517527,"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":"12041181","event":"ball","batsman_id":"145394","bowler_id":"116708","over":"16","ball":"2","score":"1lb","commentary":"Anya Vaidya to Olivia Bastin, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1748517537,"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_id":"12041186","event":"ball","batsman_id":"127551","bowler_id":"116708","over":"16","ball":"3","score":0,"commentary":"Anya Vaidya to Aimee Aikenhead, no run,","noball_dismissal":false,"text":"","timestamp":1748517587,"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":"12041188","event":"ball","batsman_id":"127551","bowler_id":"116708","over":"16","ball":"4","score":"1nb","commentary":"Anya Vaidya to Aimee Aikenhead, 1 no ball,","noball_dismissal":false,"text":"","timestamp":1748517593,"run":1,"noball_run":"1","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":true,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12041190","event":"ball","batsman_id":"127551","bowler_id":"116708","over":"16","ball":"4","score":1,"commentary":"Anya Vaidya to Aimee Aikenhead, 1 run,","noball_dismissal":false,"text":"","timestamp":1748517596,"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":"12041192","event":"ball","batsman_id":"145394","bowler_id":"116708","over":"16","ball":"5","score":"1wd","commentary":"Anya Vaidya to Olivia Bastin, 1 wide,","noball_dismissal":false,"text":"","timestamp":1748517599,"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":"12041193","event":"ball","batsman_id":"145394","bowler_id":"116708","over":"16","ball":"5","score":0,"commentary":"Anya Vaidya to Olivia Bastin, no run,","noball_dismissal":false,"text":"","timestamp":1748517602,"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":"12041194","event":"ball","batsman_id":"145394","bowler_id":"116708","over":"16","ball":"6","score":0,"commentary":"Anya Vaidya to Olivia Bastin, no run,","noball_dismissal":false,"text":"","timestamp":1748517607,"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":17,"runs":7,"score":"99\/9","bats":[{"runs":0,"balls_faced":6,"fours":0,"sixes":0,"batsman_id":145394},{"runs":47,"balls_faced":48,"fours":6,"sixes":0,"batsman_id":127551}],"bowls":[{"runs_conceded":11,"maidens":0,"wickets":2,"bowler_id":116708,"overs":3},{"runs_conceded":0,"maidens":1,"wickets":3,"bowler_id":149026,"overs":1}],"commentary":"End of over 17 (7 runs), Jersey Women 99\/9"},{"event_id":"12041198","event":"ball","batsman_id":"127551","bowler_id":"149026","over":"17","ball":"1","score":2,"commentary":"Gaya Jayaweera to Aimee Aikenhead, 2 runs,","noball_dismissal":false,"text":"","timestamp":1748517645,"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":"12041199","event":"ball","batsman_id":"127551","bowler_id":"149026","over":"17","ball":"2","score":0,"commentary":"Gaya Jayaweera to Aimee Aikenhead, no run,","noball_dismissal":false,"text":"","timestamp":1748517656,"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":"12041200","event":"ball","batsman_id":"127551","bowler_id":"149026","over":"17","ball":"3","score":4,"commentary":"Gaya Jayaweera to Aimee Aikenhead, Four,","noball_dismissal":false,"text":"","timestamp":1748517700,"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":"12041201","event":"ball","batsman_id":"127551","bowler_id":"149026","over":"17","ball":"4","score":4,"commentary":"Gaya Jayaweera to Aimee Aikenhead, Four,","noball_dismissal":false,"text":"","timestamp":1748517737,"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":"12041207","event":"ball","batsman_id":"127551","bowler_id":"149026","over":"17","ball":"5","score":1,"commentary":"Gaya Jayaweera to Aimee Aikenhead, 1 run,","noball_dismissal":false,"text":"","timestamp":1748517846,"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":"12041209","event":"wicket","batsman_id":"145394","bowler_id":"149026","over":"17","ball":"6","score":"w","commentary":"Gaya Jayaweera to Olivia Bastin, no run, c K Rana b Gaya Jayaweera,","noball_dismissal":false,"text":"","timestamp":1748518016,"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":"145394","how_out":"c K Rana b Gaya Jayaweera","batsman_runs":"0","batsman_balls":"7"},{"event":"overend","over":18,"runs":11,"score":"110\/10","bats":[{"runs":0,"balls_faced":7,"fours":0,"sixes":0,"batsman_id":145394},{"runs":58,"balls_faced":53,"fours":8,"sixes":0,"batsman_id":127551}],"bowls":[{"runs_conceded":11,"maidens":1,"wickets":4,"bowler_id":149026,"overs":2},{"runs_conceded":11,"maidens":0,"wickets":2,"bowler_id":116708,"overs":3}],"commentary":"End of over 18 (11 runs), Jersey Women 110\/10"}],"day":"0","session":"0","live_inning":{"iid":197134,"number":2,"name":"Jersey Women Inning","short_name":"JER-W Inning","status":2,"issuperover":"false","result":1,"batting_team_id":124545,"fielding_team_id":124852,"scores":"110\/10","scores_full":"110\/10 (18 ov)","fielder":[{"fielder_id":"149026","fielder_name":"Gaya Jayaweera","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"100690","fielder_name":"Gunjan Shukla","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"116703","fielder_name":"Kanchan Rana","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"116708","fielder_name":"Anya Vaidya","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":"Olivia Bastin","batsman_id":"145394","runs":"0","balls":"7","how_out":"c K Rana b Gaya Jayaweera","score_at_dismissal":110,"overs_at_dismissal":"17.6","bowler_id":"149026","dismissal":"caught","number":10},"extra_runs":{"byes":1,"legbyes":2,"wides":22,"noballs":3,"penalty":"0","total":28},"equations":{"runs":110,"wickets":10,"overs":"18","bowlers_used":6,"runrate":"6.11"},"current_partnership":{"runs":18,"balls":16,"overs":2.4,"batsmen":[{"name":"Olivia Bastin","batsman_id":145394,"runs":0,"balls":7},{"name":"Aimee Aikenhead","batsman_id":127551,"runs":13,"balls":9}]},"did_not_bat":[],"max_over":"20","target":"129","recent_scores":"w,1,4,4,0,2,0,0,1,1,1,0,1,1,1,1,0,0","last_five_overs":"28\/5 4.80","last_ten_overs":"60\/7 5.22"},"teams":[{"tid":124545,"title":"Jersey Women","abbr":"JER-W","alt_name":"Jersey Women","type":"country","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/JER-CR1@2x.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/JER-CR1@2x.png","country":"je","sex":"female","team_owner":"","head_coach":"","scores_full":"110\/10 (18 ov)","scores":"110\/10","overs":"18"},{"tid":124852,"title":"Sweden Women","abbr":"SWE-W","alt_name":"Sweden Women","type":"country","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Sweden.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Sweden.png","country":"se","sex":"female","team_owner":"","head_coach":"","scores_full":"128\/8 (20 ov)","scores":"128\/8","overs":"20"}],"players":[{"pid":100690,"title":"Gunjan Shukla","short_name":"G Shukla","first_name":"Gunjan Shukla","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"se","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","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":"Sweden","role":"bowl","role_str":""},{"pid":110127,"title":"Fatima Zahra","short_name":"F Zahra","first_name":"Fatima Zahra","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"se","primary_team":[],"logo_url":"","playing_role":"bowl","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":"Sweden","role":"squad","role_str":""},{"pid":115773,"title":"Grace Wetherall","short_name":"G Wetherall","first_name":"Grace Wetherall","last_name":"","middle_name":"","birthdate":"2006-11-11","birthplace":"","country":"je","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"","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":"Jersey","role":"all","role_str":""},{"pid":115774,"title":"Mia Maguire","short_name":"M Maguire","first_name":"Mia Maguire","last_name":"","middle_name":"","birthdate":"2007-01-16","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","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":"International","role":"wk","role_str":"(WK)"},{"pid":115775,"title":"Georgia Mallett","short_name":"G Mallett","first_name":"Georgia Mallett","last_name":"","middle_name":"","birthdate":"2005-03-12","birthplace":"","country":"int","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"squad","role_str":""},{"pid":115777,"title":"Maria Da Rocha","short_name":"M D Rocha","first_name":"Maria Da Rocha","last_name":"","middle_name":"","birthdate":"2000-01-12","birthplace":"","country":"je","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":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Jersey","role":"squad","role_str":""},{"pid":115778,"title":"Lily Greig","short_name":"L Greig","first_name":"Lily Greig","last_name":"","middle_name":"","birthdate":"2005-01-12","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"squad","role_str":""},{"pid":115781,"title":"Trinity Smith","short_name":"T Smith","first_name":"Trinity Smith","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"je","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":"Jersey","role":"all","role_str":""},{"pid":115782,"title":"Analise Merritt","short_name":"A Merritt","first_name":"Analise Merritt","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","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":"International","role":"all","role_str":""},{"pid":115785,"title":"Chloe Greechan","short_name":"C Greechan","first_name":"Chloe Greechan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"bowl","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":"International","role":"bowl","role_str":"(C)"},{"pid":116702,"title":"Meghana Alugunoolla","short_name":"M Alugunoolla","first_name":"Meghana Alugunoolla","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"se","primary_team":[],"logo_url":"","playing_role":"wk","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":"Sweden","role":"squad","role_str":""},{"pid":116703,"title":"Kanchan Rana","short_name":"K Rana","first_name":"Kanchan Rana","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"se","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","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":"Sweden","role":"all","role_str":""},{"pid":116704,"title":"Abhilasha Singh","short_name":"A Singh","first_name":"Abhilasha Singh","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"se","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":"Sweden","role":"squad","role_str":""},{"pid":116706,"title":"Eman Asim","short_name":"E Asim","first_name":"Eman Asim","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"se","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":"Sweden","role":"bat","role_str":""},{"pid":116707,"title":"Rashmi Samashekar","short_name":"R Samashekar","first_name":"Rashmi Samashekar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"se","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":"Sweden","role":"bat","role_str":"(WK)"},{"pid":116708,"title":"Anya Vaidya","short_name":"A Vaidya","first_name":"Anya Vaidya","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"se","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","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":"Sweden","role":"all","role_str":""},{"pid":116710,"title":"Surya Ravuri","short_name":"S Ravuri","first_name":"Surya Ravuri","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"se","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","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":"Sweden","role":"squad","role_str":""},{"pid":121382,"title":"Elsa Thelander","short_name":"E Thelander","first_name":"Elsa Thelander","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"se","primary_team":[],"logo_url":"","playing_role":"wk","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":"Sweden","role":"wk","role_str":""},{"pid":121384,"title":"Imali Jayasooriya","short_name":"I Jayasooriya","first_name":"Imali Jayasooriya","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"se","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Sweden","role":"all","role_str":""},{"pid":124054,"title":"Hareer Chamto","short_name":"H Chamto","first_name":"Hareer Chamto","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"se","primary_team":[],"logo_url":"","playing_role":"bowl","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":"Sweden","role":"bowl","role_str":""},{"pid":127551,"title":"Aimee Aikenhead","short_name":"A Aikenhead","first_name":"Aimee Aikenhead","last_name":"","middle_name":"","birthdate":"2023-06-22","birthplace":"","country":"je","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","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":"Jersey","role":"bat","role_str":""},{"pid":127561,"title":"Florence Tanguy","short_name":"F Tanguy","first_name":"Florence Tanguy","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"je","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":"Jersey","role":"bowl","role_str":""},{"pid":127590,"title":"Ekaterina Bogdanova","short_name":"E Bogdanova","first_name":"Ekaterina Bogdanova","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"se","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Sweden","role":"squad","role_str":""},{"pid":145394,"title":"Olivia Bastin","short_name":"O Bastin","first_name":"Olivia Bastin","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"je","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","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":"Jersey","role":"bowl","role_str":""},{"pid":148669,"title":"Tallulah Spry","short_name":"T Spry","first_name":"Tallulah Spry","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"je","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":"Jersey","role":"squad","role_str":""},{"pid":148670,"title":"Nia Greig","short_name":"N Greig","first_name":"Nia Greig","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"je","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":"Jersey","role":"bat","role_str":""},{"pid":148676,"title":"Kate Follain","short_name":"K Follain","first_name":"Kate Follain","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"je","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":"Jersey","role":"bat","role_str":""},{"pid":148828,"title":"Malyun Yusuf","short_name":"M Yusuf","first_name":"Malyun Yusuf","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"se","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Sweden","role":"all","role_str":"(C)"},{"pid":148831,"title":"Zara Mohammad","short_name":"Z Mohammad","first_name":"Zara Mohammad","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"se","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":"Sweden","role":"bowl","role_str":""},{"pid":148986,"title":"Annabel Mossop","short_name":"A Mossop","first_name":"Annabel Mossop","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"je","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":"Jersey","role":"bowl","role_str":""},{"pid":149026,"title":"Gaya Jayaweera","short_name":"Gaya Jayaweera","first_name":"Gaya Jayaweera","last_name":"","middle_name":"","birthdate":"1984-12-26","birthplace":"","country":"se","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":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Sweden","role":"bat","role_str":""},{"pid":149028,"title":"Shreya Hariharan","short_name":"S Hariharan","first_name":"Shreya Hariharan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"se","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":"Sweden","role":"squad","role_str":""}]},"etag":"a67d085abe711558861760ee60c10459","modified":"2025-06-13 12:45:15","datetime":"2025-06-13 12:45:15","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":90174,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Sweden Women won by 18 runs","day_remaining_over":"","team_batting":"Jersey Women","team_bowling":"Sweden Women","live_inning_number":2,"live_score":{"runs":110,"overs":18,"wickets":10,"target":129,"runrate":6.11,"required_runrate":9.5},"commentary":1,"wagon":2,"batsmen":[{"name":"Aimee Aikenhead","batsman_id":127551,"runs":58,"balls_faced":53,"fours":8,"sixes":0,"strike_rate":"109.43"},{"name":"Olivia Bastin","batsman_id":145394,"runs":0,"balls_faced":7,"fours":0,"sixes":0,"strike_rate":"0.00"}],"bowlers":[{"name":"Gaya Jayaweera","bowler_id":149026,"overs":2,"runs_conceded":11,"wickets":4,"maidens":1,"econ":"5.50"},{"name":"Anya Vaidya","bowler_id":116708,"overs":3,"runs_conceded":11,"wickets":2,"maidens":0,"econ":"3.67"}],"commentaries":[{"event_id":"12041153","event":"ball","batsman_id":"127551","bowler_id":"116708","over":"14","ball":"3","score":1,"commentary":"Anya Vaidya to Aimee Aikenhead, 1 run,","noball_dismissal":false,"text":"","timestamp":1748516570,"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":"12041154","event":"ball","batsman_id":"115785","bowler_id":"116708","over":"14","ball":"4","score":0,"commentary":"Anya Vaidya to Chloe Greechan, no run,","noball_dismissal":false,"text":"","timestamp":1748516626,"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":"12041155","event":"ball","batsman_id":"115785","bowler_id":"116708","over":"14","ball":"5","score":"1wd","commentary":"Anya Vaidya to Chloe Greechan, 1 wide,","noball_dismissal":false,"text":"","timestamp":1748516648,"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":"12041156","event":"wicket","batsman_id":"115785","bowler_id":"116708","over":"14","ball":"5","score":"w","commentary":"Anya Vaidya to Chloe Greechan, no run, c G Shukla b A Vaidya,","noball_dismissal":false,"text":"","timestamp":1748516709,"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":"115785","how_out":"c G Shukla b A Vaidya","batsman_runs":"3","batsman_balls":"7"},{"event_id":"12041157","event":"ball","batsman_id":"148986","bowler_id":"116708","over":"14","ball":"6","score":"1lb","commentary":"Anya Vaidya to Annabel Mossop, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1748516826,"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":15,"runs":4,"score":"92\/6","bats":[{"runs":0,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":148986},{"runs":45,"balls_faced":44,"fours":6,"sixes":0,"batsman_id":127551}],"bowls":[{"runs_conceded":5,"maidens":0,"wickets":2,"bowler_id":116708,"overs":2},{"runs_conceded":22,"maidens":0,"wickets":1,"bowler_id":121384,"overs":4}],"commentary":"End of over 15 (4 runs), Jersey Women 92\/6"},{"event_id":"12041158","event":"wicket","batsman_id":"148986","bowler_id":"149026","over":"15","ball":"1","score":"w","commentary":"Gaya Jayaweera to Annabel Mossop, no run, c K Rana b Gaya Jayaweera,","noball_dismissal":false,"text":"","timestamp":1748516967,"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":"148986","how_out":"c K Rana b Gaya Jayaweera","batsman_runs":"0","batsman_balls":"2"},{"event_id":"12041164","event":"wicket","batsman_id":"148670","bowler_id":"149026","over":"15","ball":"2","score":"w","commentary":"Gaya Jayaweera to Nia Greig, no run, c A Vaidya b Gaya Jayaweera,","noball_dismissal":false,"text":"","timestamp":1748516997,"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":"148670","how_out":"c A Vaidya b Gaya Jayaweera","batsman_runs":"0","batsman_balls":"1"},{"event_id":"12041166","event":"wicket","batsman_id":"148676","bowler_id":"149026","over":"15","ball":"3","score":"w","commentary":"Gaya Jayaweera to Kate Follain, no run, b Gaya Jayaweera,","noball_dismissal":false,"text":"","timestamp":1748517409,"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":"148676","how_out":"b Gaya Jayaweera","batsman_runs":"0","batsman_balls":"1"},{"event_id":"12041173","event":"ball","batsman_id":"145394","bowler_id":"149026","over":"15","ball":"4","score":0,"commentary":"Gaya Jayaweera to Olivia Bastin, no run,","noball_dismissal":false,"text":"","timestamp":1748517510,"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":"12041174","event":"ball","batsman_id":"145394","bowler_id":"149026","over":"15","ball":"5","score":0,"commentary":"Gaya Jayaweera to Olivia Bastin, no run,","noball_dismissal":false,"text":"","timestamp":1748517515,"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":"12041175","event":"ball","batsman_id":"145394","bowler_id":"149026","over":"15","ball":"6","score":0,"commentary":"Gaya Jayaweera to Olivia Bastin, no run,","noball_dismissal":false,"text":"","timestamp":1748517518,"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":0,"score":"92\/9","bats":[{"runs":0,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":145394},{"runs":45,"balls_faced":44,"fours":6,"sixes":0,"batsman_id":127551}],"bowls":[{"runs_conceded":0,"maidens":1,"wickets":3,"bowler_id":149026,"overs":1},{"runs_conceded":5,"maidens":0,"wickets":2,"bowler_id":116708,"overs":2}],"commentary":"End of over 16 (0 runs), Jersey Women 92\/9"},{"event_id":"12041176","event":"ball","batsman_id":"127551","bowler_id":"116708","over":"16","ball":"1","score":"1wd","commentary":"Anya Vaidya to Aimee Aikenhead, 1 wide,","noball_dismissal":false,"text":"","timestamp":1748517520,"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":"12041177","event":"ball","batsman_id":"127551","bowler_id":"116708","over":"16","ball":"1","score":1,"commentary":"Anya Vaidya to Aimee Aikenhead, 1 run,","noball_dismissal":false,"text":"","timestamp":1748517524,"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":"12041179","event":"ball","batsman_id":"145394","bowler_id":"116708","over":"16","ball":"2","score":"1wd","commentary":"Anya Vaidya to Olivia Bastin, 1 wide,","noball_dismissal":false,"text":"","timestamp":1748517527,"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":"12041181","event":"ball","batsman_id":"145394","bowler_id":"116708","over":"16","ball":"2","score":"1lb","commentary":"Anya Vaidya to Olivia Bastin, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1748517537,"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_id":"12041186","event":"ball","batsman_id":"127551","bowler_id":"116708","over":"16","ball":"3","score":0,"commentary":"Anya Vaidya to Aimee Aikenhead, no run,","noball_dismissal":false,"text":"","timestamp":1748517587,"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":"12041188","event":"ball","batsman_id":"127551","bowler_id":"116708","over":"16","ball":"4","score":"1nb","commentary":"Anya Vaidya to Aimee Aikenhead, 1 no ball,","noball_dismissal":false,"text":"","timestamp":1748517593,"run":1,"noball_run":"1","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":true,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12041190","event":"ball","batsman_id":"127551","bowler_id":"116708","over":"16","ball":"4","score":1,"commentary":"Anya Vaidya to Aimee Aikenhead, 1 run,","noball_dismissal":false,"text":"","timestamp":1748517596,"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":"12041192","event":"ball","batsman_id":"145394","bowler_id":"116708","over":"16","ball":"5","score":"1wd","commentary":"Anya Vaidya to Olivia Bastin, 1 wide,","noball_dismissal":false,"text":"","timestamp":1748517599,"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":"12041193","event":"ball","batsman_id":"145394","bowler_id":"116708","over":"16","ball":"5","score":0,"commentary":"Anya Vaidya to Olivia Bastin, no run,","noball_dismissal":false,"text":"","timestamp":1748517602,"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":"12041194","event":"ball","batsman_id":"145394","bowler_id":"116708","over":"16","ball":"6","score":0,"commentary":"Anya Vaidya to Olivia Bastin, no run,","noball_dismissal":false,"text":"","timestamp":1748517607,"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":17,"runs":7,"score":"99\/9","bats":[{"runs":0,"balls_faced":6,"fours":0,"sixes":0,"batsman_id":145394},{"runs":47,"balls_faced":48,"fours":6,"sixes":0,"batsman_id":127551}],"bowls":[{"runs_conceded":11,"maidens":0,"wickets":2,"bowler_id":116708,"overs":3},{"runs_conceded":0,"maidens":1,"wickets":3,"bowler_id":149026,"overs":1}],"commentary":"End of over 17 (7 runs), Jersey Women 99\/9"},{"event_id":"12041198","event":"ball","batsman_id":"127551","bowler_id":"149026","over":"17","ball":"1","score":2,"commentary":"Gaya Jayaweera to Aimee Aikenhead, 2 runs,","noball_dismissal":false,"text":"","timestamp":1748517645,"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":"12041199","event":"ball","batsman_id":"127551","bowler_id":"149026","over":"17","ball":"2","score":0,"commentary":"Gaya Jayaweera to Aimee Aikenhead, no run,","noball_dismissal":false,"text":"","timestamp":1748517656,"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":"12041200","event":"ball","batsman_id":"127551","bowler_id":"149026","over":"17","ball":"3","score":4,"commentary":"Gaya Jayaweera to Aimee Aikenhead, Four,","noball_dismissal":false,"text":"","timestamp":1748517700,"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":"12041201","event":"ball","batsman_id":"127551","bowler_id":"149026","over":"17","ball":"4","score":4,"commentary":"Gaya Jayaweera to Aimee Aikenhead, Four,","noball_dismissal":false,"text":"","timestamp":1748517737,"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":"12041207","event":"ball","batsman_id":"127551","bowler_id":"149026","over":"17","ball":"5","score":1,"commentary":"Gaya Jayaweera to Aimee Aikenhead, 1 run,","noball_dismissal":false,"text":"","timestamp":1748517846,"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":"12041209","event":"wicket","batsman_id":"145394","bowler_id":"149026","over":"17","ball":"6","score":"w","commentary":"Gaya Jayaweera to Olivia Bastin, no run, c K Rana b Gaya Jayaweera,","noball_dismissal":false,"text":"","timestamp":1748518016,"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":"145394","how_out":"c K Rana b Gaya Jayaweera","batsman_runs":"0","batsman_balls":"7"},{"event":"overend","over":18,"runs":11,"score":"110\/10","bats":[{"runs":0,"balls_faced":7,"fours":0,"sixes":0,"batsman_id":145394},{"runs":58,"balls_faced":53,"fours":8,"sixes":0,"batsman_id":127551}],"bowls":[{"runs_conceded":11,"maidens":1,"wickets":4,"bowler_id":149026,"overs":2},{"runs_conceded":11,"maidens":0,"wickets":2,"bowler_id":116708,"overs":3}],"commentary":"End of over 18 (11 runs), Jersey Women 110\/10"}],"day":"0","session":"0","live_inning":{"iid":197134,"number":2,"name":"Jersey Women Inning","short_name":"JER-W Inning","status":2,"issuperover":"false","result":1,"batting_team_id":124545,"fielding_team_id":124852,"scores":"110\/10","scores_full":"110\/10 (18 ov)","fielder":[{"fielder_id":"149026","fielder_name":"Gaya Jayaweera","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"100690","fielder_name":"Gunjan Shukla","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"116703","fielder_name":"Kanchan Rana","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"116708","fielder_name":"Anya Vaidya","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":"Olivia Bastin","batsman_id":"145394","runs":"0","balls":"7","how_out":"c K Rana b Gaya Jayaweera","score_at_dismissal":110,"overs_at_dismissal":"17.6","bowler_id":"149026","dismissal":"caught","number":10},"extra_runs":{"byes":1,"legbyes":2,"wides":22,"noballs":3,"penalty":"0","total":28},"equations":{"runs":110,"wickets":10,"overs":"18","bowlers_used":6,"runrate":"6.11"},"current_partnership":{"runs":18,"balls":16,"overs":2.4,"batsmen":[{"name":"Olivia Bastin","batsman_id":145394,"runs":0,"balls":7},{"name":"Aimee Aikenhead","batsman_id":127551,"runs":13,"balls":9}]},"did_not_bat":[],"max_over":"20","target":"129","recent_scores":"w,1,4,4,0,2,0,0,1,1,1,0,1,1,1,1,0,0","last_five_overs":"28\/5 4.80","last_ten_overs":"60\/7 5.22"},"teams":[{"tid":124545,"title":"Jersey Women","abbr":"JER-W","alt_name":"Jersey Women","type":"country","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/JER-CR1@2x.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/JER-CR1@2x.png","country":"je","sex":"female","team_owner":"","head_coach":"","scores_full":"110\/10 (18 ov)","scores":"110\/10","overs":"18"},{"tid":124852,"title":"Sweden Women","abbr":"SWE-W","alt_name":"Sweden Women","type":"country","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Sweden.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Sweden.png","country":"se","sex":"female","team_owner":"","head_coach":"","scores_full":"128\/8 (20 ov)","scores":"128\/8","overs":"20"}],"players":[{"pid":100690,"title":"Gunjan Shukla","short_name":"G Shukla","first_name":"Gunjan Shukla","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"se","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","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":"Sweden","role":"bowl","role_str":""},{"pid":110127,"title":"Fatima Zahra","short_name":"F Zahra","first_name":"Fatima Zahra","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"se","primary_team":[],"logo_url":"","playing_role":"bowl","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":"Sweden","role":"squad","role_str":""},{"pid":115773,"title":"Grace Wetherall","short_name":"G Wetherall","first_name":"Grace Wetherall","last_name":"","middle_name":"","birthdate":"2006-11-11","birthplace":"","country":"je","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"","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":"Jersey","role":"all","role_str":""},{"pid":115774,"title":"Mia Maguire","short_name":"M Maguire","first_name":"Mia Maguire","last_name":"","middle_name":"","birthdate":"2007-01-16","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","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":"International","role":"wk","role_str":"(WK)"},{"pid":115775,"title":"Georgia Mallett","short_name":"G Mallett","first_name":"Georgia Mallett","last_name":"","middle_name":"","birthdate":"2005-03-12","birthplace":"","country":"int","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"squad","role_str":""},{"pid":115777,"title":"Maria Da Rocha","short_name":"M D Rocha","first_name":"Maria Da Rocha","last_name":"","middle_name":"","birthdate":"2000-01-12","birthplace":"","country":"je","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":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Jersey","role":"squad","role_str":""},{"pid":115778,"title":"Lily Greig","short_name":"L Greig","first_name":"Lily Greig","last_name":"","middle_name":"","birthdate":"2005-01-12","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"squad","role_str":""},{"pid":115781,"title":"Trinity Smith","short_name":"T Smith","first_name":"Trinity Smith","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"je","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":"Jersey","role":"all","role_str":""},{"pid":115782,"title":"Analise Merritt","short_name":"A Merritt","first_name":"Analise Merritt","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","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":"International","role":"all","role_str":""},{"pid":115785,"title":"Chloe Greechan","short_name":"C Greechan","first_name":"Chloe Greechan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"bowl","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":"International","role":"bowl","role_str":"(C)"},{"pid":116702,"title":"Meghana Alugunoolla","short_name":"M Alugunoolla","first_name":"Meghana Alugunoolla","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"se","primary_team":[],"logo_url":"","playing_role":"wk","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":"Sweden","role":"squad","role_str":""},{"pid":116703,"title":"Kanchan Rana","short_name":"K Rana","first_name":"Kanchan Rana","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"se","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","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":"Sweden","role":"all","role_str":""},{"pid":116704,"title":"Abhilasha Singh","short_name":"A Singh","first_name":"Abhilasha Singh","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"se","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":"Sweden","role":"squad","role_str":""},{"pid":116706,"title":"Eman Asim","short_name":"E Asim","first_name":"Eman Asim","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"se","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":"Sweden","role":"bat","role_str":""},{"pid":116707,"title":"Rashmi Samashekar","short_name":"R Samashekar","first_name":"Rashmi Samashekar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"se","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":"Sweden","role":"bat","role_str":"(WK)"},{"pid":116708,"title":"Anya Vaidya","short_name":"A Vaidya","first_name":"Anya Vaidya","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"se","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","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":"Sweden","role":"all","role_str":""},{"pid":116710,"title":"Surya Ravuri","short_name":"S Ravuri","first_name":"Surya Ravuri","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"se","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","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":"Sweden","role":"squad","role_str":""},{"pid":121382,"title":"Elsa Thelander","short_name":"E Thelander","first_name":"Elsa Thelander","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"se","primary_team":[],"logo_url":"","playing_role":"wk","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":"Sweden","role":"wk","role_str":""},{"pid":121384,"title":"Imali Jayasooriya","short_name":"I Jayasooriya","first_name":"Imali Jayasooriya","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"se","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Sweden","role":"all","role_str":""},{"pid":124054,"title":"Hareer Chamto","short_name":"H Chamto","first_name":"Hareer Chamto","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"se","primary_team":[],"logo_url":"","playing_role":"bowl","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":"Sweden","role":"bowl","role_str":""},{"pid":127551,"title":"Aimee Aikenhead","short_name":"A Aikenhead","first_name":"Aimee Aikenhead","last_name":"","middle_name":"","birthdate":"2023-06-22","birthplace":"","country":"je","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","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":"Jersey","role":"bat","role_str":""},{"pid":127561,"title":"Florence Tanguy","short_name":"F Tanguy","first_name":"Florence Tanguy","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"je","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":"Jersey","role":"bowl","role_str":""},{"pid":127590,"title":"Ekaterina Bogdanova","short_name":"E Bogdanova","first_name":"Ekaterina Bogdanova","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"se","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Sweden","role":"squad","role_str":""},{"pid":145394,"title":"Olivia Bastin","short_name":"O Bastin","first_name":"Olivia Bastin","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"je","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","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":"Jersey","role":"bowl","role_str":""},{"pid":148669,"title":"Tallulah Spry","short_name":"T Spry","first_name":"Tallulah Spry","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"je","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":"Jersey","role":"squad","role_str":""},{"pid":148670,"title":"Nia Greig","short_name":"N Greig","first_name":"Nia Greig","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"je","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":"Jersey","role":"bat","role_str":""},{"pid":148676,"title":"Kate Follain","short_name":"K Follain","first_name":"Kate Follain","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"je","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":"Jersey","role":"bat","role_str":""},{"pid":148828,"title":"Malyun Yusuf","short_name":"M Yusuf","first_name":"Malyun Yusuf","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"se","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Sweden","role":"all","role_str":"(C)"},{"pid":148831,"title":"Zara Mohammad","short_name":"Z Mohammad","first_name":"Zara Mohammad","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"se","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":"Sweden","role":"bowl","role_str":""},{"pid":148986,"title":"Annabel Mossop","short_name":"A Mossop","first_name":"Annabel Mossop","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"je","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":"Jersey","role":"bowl","role_str":""},{"pid":149026,"title":"Gaya Jayaweera","short_name":"Gaya Jayaweera","first_name":"Gaya Jayaweera","last_name":"","middle_name":"","birthdate":"1984-12-26","birthplace":"","country":"se","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":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Sweden","role":"bat","role_str":""},{"pid":149028,"title":"Shreya Hariharan","short_name":"S Hariharan","first_name":"Shreya Hariharan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"se","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":"Sweden","role":"squad","role_str":""}]},"etag":"a67d085abe711558861760ee60c10459","modified":"2025-06-13 12:45:15","datetime":"2025-06-13 12:45:15","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90174 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:ed5f5656-6685-43bd-8e9d-897a840bdd43
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90174 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90174,3,'{"status":"ok","response":{"match_id":90174,"title":"Jersey Women vs Sweden Women","short_title":"JER-W vs SWE-W","subtitle":"Match 13","match_number":"13","format":8,"format_str":"Women T20","status":2,"status_str":"Completed","status_note":"Sweden Women won by 18 runs","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129599,"title":"ICC Womens T20 World Cup Europe Qualifier Division 2","abbr":"ICC Womens T20 World Cup Europe Qualifier ","type":"tournament","category":"women","match_format":"woment20","season":"2025","status":"live","datestart":"2025-05-25","dateend":"2025-05-29","country":"int","total_matches":"15","total_rounds":"1","total_teams":"6"},"teama":{"team_id":124545,"name":"Jersey Women","short_name":"JER-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/JER-CR1@2x.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/JER-CR1@2x.png","scores_full":"110\/10 (18 ov)","scores":"110\/10","overs":"18"},"teamb":{"team_id":124852,"name":"Sweden Women","short_name":"SWE-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Sweden.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Sweden.png","scores_full":"128\/8 (20 ov)","scores":"128\/8","overs":"20"},"date_start":"2025-05-29 08:15:00","date_end":"2025-05-29 18:15:00","timestamp_start":1748506500,"timestamp_end":1748542500,"date_start_ist":"2025-05-29 13:45:00","date_end_ist":"2025-05-29 23:45:00","venue":{"venue_id":"1213565","name":"Simar Cricket Ground","location":"Rome","country":"Italy","timezone":""},"umpires":"Shanaka Fernando (Italy), Maulik Prabhudesai (Netherlands)","referee":"Stuart Hodgson (Jersey)","equation":"","live":"","result":"SWE-W won by 18 runs","result_type":2,"win_margin":"18 runs","winning_team_id":124852,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-05-26 16:07:25","verify_time":"2025-05-29 17:29:03","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":32.26,"humidity":60,"visibility":10000,"wind_speed":"18.90","clouds":100},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Sweden Women elected to bat","winner":124852,"decision":1}},"etag":"d66661259f77ac290defc2777a9b4e80","modified":"2025-06-13 12:45:16","datetime":"2025-06-13 12:45:16","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":90174,"title":"Jersey Women vs Sweden Women","short_title":"JER-W vs SWE-W","subtitle":"Match 13","match_number":"13","format":8,"format_str":"Women T20","status":2,"status_str":"Completed","status_note":"Sweden Women won by 18 runs","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129599,"title":"ICC Womens T20 World Cup Europe Qualifier Division 2","abbr":"ICC Womens T20 World Cup Europe Qualifier ","type":"tournament","category":"women","match_format":"woment20","season":"2025","status":"live","datestart":"2025-05-25","dateend":"2025-05-29","country":"int","total_matches":"15","total_rounds":"1","total_teams":"6"},"teama":{"team_id":124545,"name":"Jersey Women","short_name":"JER-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/JER-CR1@2x.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/JER-CR1@2x.png","scores_full":"110\/10 (18 ov)","scores":"110\/10","overs":"18"},"teamb":{"team_id":124852,"name":"Sweden Women","short_name":"SWE-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Sweden.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Sweden.png","scores_full":"128\/8 (20 ov)","scores":"128\/8","overs":"20"},"date_start":"2025-05-29 08:15:00","date_end":"2025-05-29 18:15:00","timestamp_start":1748506500,"timestamp_end":1748542500,"date_start_ist":"2025-05-29 13:45:00","date_end_ist":"2025-05-29 23:45:00","venue":{"venue_id":"1213565","name":"Simar Cricket Ground","location":"Rome","country":"Italy","timezone":""},"umpires":"Shanaka Fernando (Italy), Maulik Prabhudesai (Netherlands)","referee":"Stuart Hodgson (Jersey)","equation":"","live":"","result":"SWE-W won by 18 runs","result_type":2,"win_margin":"18 runs","winning_team_id":124852,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-05-26 16:07:25","verify_time":"2025-05-29 17:29:03","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":32.26,"humidity":60,"visibility":10000,"wind_speed":"18.90","clouds":100},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Sweden Women elected to bat","winner":124852,"decision":1}},"etag":"d66661259f77ac290defc2777a9b4e80","modified":"2025-06-13 12:45:16","datetime":"2025-06-13 12:45:16","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90174 AND DataTypeId = 3 END Live Report & Scorecard of Jersey Women vs Sweden Women Match 13
Jersey Women vs Sweden Women, Live Cricket Commentary