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:2deebb0f-6e77-427c-b585-b07941178c48
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90961 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90961,1,'{"status":"ok","response":{"mid":90961,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"England A Women won by 6 runs","day_remaining_over":"","team_batting":"New Zealand A Women","team_bowling":"England A Women","live_inning_number":2,"live_score":{"runs":291,"overs":50,"wickets":9,"target":298,"runrate":5.82,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Bree Illing","batsman_id":113880,"runs":1,"balls_faced":1,"fours":0,"sixes":0,"strike_rate":"100.00"},{"name":"Emma Black","batsman_id":94414,"runs":32,"balls_faced":29,"fours":5,"sixes":0,"strike_rate":"110.34"}],"bowlers":[{"name":"Phoebe Turner","bowler_id":116258,"overs":10,"runs_conceded":67,"wickets":3,"maidens":1,"econ":"6.70"},{"name":"Jodi Grewcock","bowler_id":116396,"overs":9,"runs_conceded":42,"wickets":2,"maidens":1,"econ":"4.67"}],"commentaries":[{"event_id":"12208300","event":"ball","batsman_id":"94414","bowler_id":"146141","over":"45","ball":"6","score":4,"commentary":"Grace Thompson to Emma Black, Four,","noball_dismissal":false,"text":"","timestamp":1750696952,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event":"overend","over":46,"runs":7,"score":"255\/7","bats":[{"runs":13,"balls_faced":17,"fours":2,"sixes":0,"batsman_id":94414},{"runs":19,"balls_faced":20,"fours":1,"sixes":0,"batsman_id":44268}],"bowls":[{"runs_conceded":34,"maidens":0,"wickets":2,"bowler_id":146141,"overs":9},{"runs_conceded":26,"maidens":1,"wickets":2,"bowler_id":116396,"overs":7}],"commentary":"End of over 46 (7 runs), New Zealand A Women 255\/7"},{"event_id":"12208305","event":"ball","batsman_id":"44268","bowler_id":"116396","over":"46","ball":"1","score":"1lb","commentary":"Jodi Grewcock to Hannah Rowe, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1750696955,"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":"12208306","event":"ball","batsman_id":"94414","bowler_id":"116396","over":"46","ball":"2","score":0,"commentary":"Jodi Grewcock to Emma Black, no run,","noball_dismissal":false,"text":"","timestamp":1750696957,"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":"12208307","event":"ball","batsman_id":"94414","bowler_id":"116396","over":"46","ball":"3","score":1,"commentary":"Jodi Grewcock to Emma Black, 1 run,","noball_dismissal":false,"text":"","timestamp":1750696959,"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":"12208308","event":"ball","batsman_id":"44268","bowler_id":"116396","over":"46","ball":"4","score":1,"commentary":"Jodi Grewcock to Hannah Rowe, 1 run,","noball_dismissal":false,"text":"","timestamp":1750696962,"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":"12208311","event":"ball","batsman_id":"94414","bowler_id":"116396","over":"46","ball":"5","score":1,"commentary":"Jodi Grewcock to Emma Black, 1 run,","noball_dismissal":false,"text":"","timestamp":1750696965,"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":"12208314","event":"ball","batsman_id":"44268","bowler_id":"116396","over":"46","ball":"6","score":0,"commentary":"Jodi Grewcock to Hannah Rowe, no run,","noball_dismissal":false,"text":"","timestamp":1750696968,"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":47,"runs":4,"score":"259\/7","bats":[{"runs":20,"balls_faced":23,"fours":1,"sixes":0,"batsman_id":44268},{"runs":15,"balls_faced":20,"fours":2,"sixes":0,"batsman_id":94414}],"bowls":[{"runs_conceded":29,"maidens":1,"wickets":2,"bowler_id":116396,"overs":8},{"runs_conceded":34,"maidens":0,"wickets":2,"bowler_id":146141,"overs":9}],"commentary":"End of over 47 (4 runs), New Zealand A Women 259\/7"},{"event_id":"12208382","event":"ball","batsman_id":"94414","bowler_id":"116258","over":"47","ball":"1","score":1,"commentary":"Phoebe Turner to Emma Black, 1 run,","noball_dismissal":false,"text":"","timestamp":1750697130,"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":"12208384","event":"ball","batsman_id":"44268","bowler_id":"116258","over":"47","ball":"2","score":0,"commentary":"Phoebe Turner to Hannah Rowe, no run,","noball_dismissal":false,"text":"","timestamp":1750697142,"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":"12208386","event":"ball","batsman_id":"44268","bowler_id":"116258","over":"47","ball":"3","score":1,"commentary":"Phoebe Turner to Hannah Rowe, 1 run,","noball_dismissal":false,"text":"","timestamp":1750697144,"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":"12208388","event":"ball","batsman_id":"94414","bowler_id":"116258","over":"47","ball":"4","score":0,"commentary":"Phoebe Turner to Emma Black, no run,","noball_dismissal":false,"text":"","timestamp":1750697147,"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":"12208390","event":"ball","batsman_id":"94414","bowler_id":"116258","over":"47","ball":"5","score":4,"commentary":"Phoebe Turner to Emma Black, Four,","noball_dismissal":false,"text":"","timestamp":1750697153,"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":"12208403","event":"ball","batsman_id":"94414","bowler_id":"116258","over":"47","ball":"6","score":1,"commentary":"Phoebe Turner to Emma Black, 1 run,","noball_dismissal":false,"text":"","timestamp":1750697207,"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":48,"runs":7,"score":"266\/7","bats":[{"runs":21,"balls_faced":24,"fours":3,"sixes":0,"batsman_id":94414},{"runs":21,"balls_faced":25,"fours":1,"sixes":0,"batsman_id":44268}],"bowls":[{"runs_conceded":55,"maidens":1,"wickets":2,"bowler_id":116258,"overs":9},{"runs_conceded":29,"maidens":1,"wickets":2,"bowler_id":116396,"overs":8}],"commentary":"End of over 48 (7 runs), New Zealand A Women 266\/7"},{"event_id":"12208433","event":"ball","batsman_id":"94414","bowler_id":"116396","over":"48","ball":"1","score":4,"commentary":"Jodi Grewcock to Emma Black, Four,","noball_dismissal":false,"text":"","timestamp":1750697298,"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":"12208458","event":"ball","batsman_id":"94414","bowler_id":"116396","over":"48","ball":"2","score":0,"commentary":"Jodi Grewcock to Emma Black, no run,","noball_dismissal":false,"text":"","timestamp":1750697380,"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":"12208460","event":"ball","batsman_id":"94414","bowler_id":"116396","over":"48","ball":"3","score":"1wd","commentary":"Jodi Grewcock to Emma Black, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750697387,"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":"12208462","event":"ball","batsman_id":"94414","bowler_id":"116396","over":"48","ball":"3","score":2,"commentary":"Jodi Grewcock to Emma Black, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750697410,"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":"12208464","event":"ball","batsman_id":"94414","bowler_id":"116396","over":"48","ball":"4","score":4,"commentary":"Jodi Grewcock to Emma Black, Four,","noball_dismissal":false,"text":"","timestamp":1750697415,"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":"12208477","event":"ball","batsman_id":"94414","bowler_id":"116396","over":"48","ball":"5","score":1,"commentary":"Jodi Grewcock to Emma Black, 1 run,","noball_dismissal":false,"text":"","timestamp":1750697426,"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":"12208479","event":"ball","batsman_id":"44268","bowler_id":"116396","over":"48","ball":"6","score":1,"commentary":"Jodi Grewcock to Hannah Rowe, 1 run,","noball_dismissal":false,"text":"","timestamp":1750697431,"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":49,"runs":13,"score":"279\/7","bats":[{"runs":22,"balls_faced":26,"fours":1,"sixes":0,"batsman_id":44268},{"runs":32,"balls_faced":29,"fours":5,"sixes":0,"batsman_id":94414}],"bowls":[{"runs_conceded":42,"maidens":1,"wickets":2,"bowler_id":116396,"overs":9},{"runs_conceded":55,"maidens":1,"wickets":2,"bowler_id":116258,"overs":9}],"commentary":"End of over 49 (13 runs), New Zealand A Women 279\/7"},{"event_id":"12208508","event":"ball","batsman_id":"44268","bowler_id":"116258","over":"49","ball":"1","score":4,"commentary":"Phoebe Turner to Hannah Rowe, Four,","noball_dismissal":false,"text":"","timestamp":1750697516,"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":"12208509","event":"ball","batsman_id":"44268","bowler_id":"116258","over":"49","ball":"2","score":4,"commentary":"Phoebe Turner to Hannah Rowe, Four,","noball_dismissal":false,"text":"","timestamp":1750697520,"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":"12208536","event":"wicket","batsman_id":"44268","bowler_id":"116258","over":"49","ball":"3","score":"w","commentary":"Phoebe Turner to Hannah Rowe, no run, c F Kemp b P Turner,","noball_dismissal":false,"text":"","timestamp":1750697656,"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":"44268","how_out":"c F Kemp b P Turner","batsman_runs":"30","batsman_balls":"29"},{"event_id":"12208553","event":"ball","batsman_id":"96657","bowler_id":"116258","over":"49","ball":"4","score":2,"commentary":"Phoebe Turner to Amie Hucker, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750697753,"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":"12208555","event":"wicket","batsman_id":"96657","bowler_id":"116258","over":"49","ball":"5","score":"w","commentary":"Phoebe Turner to Amie Hucker, 1 run, runout (RM Southby \/ F Kemp),","noball_dismissal":false,"text":"","timestamp":1750697967,"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,"wicket_batsman_id":"96657","how_out":"runout (RM Southby \/ F Kemp)","batsman_runs":"3","batsman_balls":"2"},{"event_id":"12208560","event":"ball","batsman_id":"113880","bowler_id":"116258","over":"49","ball":"6","score":1,"commentary":"Phoebe Turner to Bree Illing, 1 run,","noball_dismissal":false,"text":"","timestamp":1750697959,"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":50,"runs":12,"score":"291\/9","bats":[{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":113880},{"runs":32,"balls_faced":29,"fours":5,"sixes":0,"batsman_id":94414}],"bowls":[{"runs_conceded":67,"maidens":1,"wickets":3,"bowler_id":116258,"overs":10},{"runs_conceded":42,"maidens":1,"wickets":2,"bowler_id":116396,"overs":9}],"commentary":"End of over 50 (12 runs), New Zealand A Women 291\/9"}],"day":"0","session":"0","live_inning":{"iid":198623,"number":2,"name":"New Zealand A Women Inning","short_name":"NZ-A-W Inning","status":2,"issuperover":"false","result":4,"batting_team_id":128354,"fielding_team_id":122919,"scores":"291\/9","scores_full":"291\/9 (50 ov)","fielder":[{"fielder_id":"61327","fielder_name":"Rhianna Southby","catches":1,"runout_thrower":0,"runout_catcher":1,"runout_direct_hit":0,"stumping":1,"is_substitute":"false"},{"fielder_id":"137963","fielder_name":"Tilly Corteen Coleman","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"122220","fielder_name":"Charis Pavely","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"102782","fielder_name":"Freya Kemp","catches":1,"runout_thrower":1,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"116396","fielder_name":"Jodi Grewcock","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"10"}},"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":"Amie Hucker","batsman_id":"96657","runs":"3","balls":"2","how_out":"runout (RM Southby \/ F Kemp)","score_at_dismissal":290,"overs_at_dismissal":"49.5","bowler_id":"0","dismissal":"runout","number":9},"extra_runs":{"byes":3,"legbyes":1,"wides":3,"noballs":1,"penalty":"0","total":8},"equations":{"runs":291,"wickets":9,"overs":"50","bowlers_used":7,"runrate":"5.82"},"current_partnership":{"runs":1,"balls":1,"overs":0.1,"batsmen":[{"name":"Bree Illing","batsman_id":113880,"runs":1,"balls":1},{"name":"Emma Black","batsman_id":94414,"runs":0,"balls":0}]},"did_not_bat":[],"max_over":"50","target":"298","recent_scores":"1,w,2,w,4,4,1,1,4,2,1,0,4,1,4,0,1,0","last_five_overs":"43\/2 8.32","last_ten_overs":"62\/4 6.10"},"teams":[{"tid":122919,"title":"England A Women","abbr":"EN-A-W","alt_name":"England A Women","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/England.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/England.png","country":"en","sex":"female","team_owner":"","head_coach":"","scores_full":"297\/4 (50 ov)","scores":"297\/4","overs":"50"},{"tid":128354,"title":"New Zealand A Women","abbr":"NZ-A-W","alt_name":"New Zealand A Women","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/New-zealand.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/New-zealand.png","country":"nz","sex":"female","team_owner":"","head_coach":"","scores_full":"291\/9 (50 ov)","scores":"291\/9","overs":"50"}],"players":[{"pid":44268,"title":"Hannah Rowe","short_name":"HM Rowe","first_name":"Hannah Rowe","last_name":"","middle_name":"","birthdate":"1996-10-03","birthplace":"Palmerston North","country":"nz","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":8.5,"facebook_profile":"https:\/\/www.facebook.com\/Hannah.R.Rowe\/","twitter_profile":"https:\/\/twitter.com\/hmrowey","instagram_profile":"https:\/\/www.instagram.com\/hannahrowe3\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bowl","role_str":""},{"pid":46694,"title":"Jess Watkin","short_name":"JM Watkin","first_name":"Jess Watkin","last_name":"","middle_name":"","birthdate":"1998-05-07","birthplace":"","country":"nz","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":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"all","role_str":""},{"pid":46746,"title":"Bella James","short_name":"IR James","first_name":"Bella James","last_name":"","middle_name":"","birthdate":"1999-01-27","birthplace":"","country":"nz","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bat","role_str":"(C)"},{"pid":46808,"title":"Polly Inglis","short_name":"PM Inglis","first_name":"Polly Inglis","last_name":"","middle_name":"","birthdate":"1996-05-31","birthplace":"","country":"nz","primary_team":[],"logo_url":"","playing_role":"wk","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":"New Zealand","role":"squad","role_str":""},{"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,"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":94414,"title":"Emma Black","short_name":"E Black","first_name":"Emma Black","last_name":"","middle_name":"","birthdate":"2001-08-08","birthplace":"","country":"nz","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":"New Zealand","role":"bowl","role_str":""},{"pid":94423,"title":"Nensi Patel","short_name":"NH Patel","first_name":"Nensi Patel","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"nz","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":"New Zealand","role":"squad","role_str":""},{"pid":94639,"title":"Mahika Gaur","short_name":"M Gaur","first_name":"Mahika Gaur","last_name":"","middle_name":"","birthdate":"2006-03-09","birthplace":"Reading, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/mahika.gaur.90\/","twitter_profile":"https:\/\/twitter.com\/mahikagaur","instagram_profile":"https:\/\/www.instagram.com\/mahikagaur_\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":96657,"title":"Amie Hucker","short_name":"A Hucker","first_name":"Amie Hucker","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"nz","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":"New Zealand","role":"all","role_str":""},{"pid":96870,"title":"Izzy Gaze","short_name":"I Gaze","first_name":"Izzy Gaze","last_name":"","middle_name":"","birthdate":"2004-05-08","birthplace":"Haarlem","country":"nz","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/izzy_gaze\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"wk","role_str":"(WK)"},{"pid":97319,"title":"Georgia Plimmer","short_name":"G Plimmer","first_name":"Georgia Plimmer","last_name":"","middle_name":"","birthdate":"2004-02-08","birthplace":"Wellington","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bat","role_str":""},{"pid":102763,"title":"Grace Scrivens","short_name":"G Scrivens","first_name":"Grace Scrivens","last_name":"","middle_name":"","birthdate":"2003-11-13","birthplace":" Kent, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/grace.scrivens\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/graciescriv\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":"(C)"},{"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":"bat","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":"bat","role_str":""},{"pid":102945,"title":"Hannah Baker","short_name":"H Baker","first_name":"Hannah Baker","last_name":"","middle_name":"","birthdate":"2004-02-03","birthplace":"West Midlands, England","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/hannahbakeerr\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":102946,"title":"Grace Potts","short_name":"G Potts","first_name":"Grace Potts","last_name":"","middle_name":"","birthdate":"2002-07-12","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/gracepotts01","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":104617,"title":"Molly Penfold","short_name":"M Penfold","first_name":"Molly Penfold","last_name":"","middle_name":"","birthdate":"2001-06-15","birthplace":"London","country":"nz","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/molly.penfold\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"squad","role_str":""},{"pid":107880,"title":"Alexa Stonehouse","short_name":"A Stonehouse","first_name":"Alexa Stonehouse","last_name":"","middle_name":"","birthdate":"2004-05-12","birthplace":"Ashford, England","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/AlexaStonehouse","instagram_profile":"https:\/\/www.instagram.com\/alexa_stonehouse","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":110318,"title":"Davina Perrin","short_name":"D Perrin","first_name":"Davina Perrin","last_name":"","middle_name":"","birthdate":"2006-09-08","birthplace":"Wolverhampton","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":110321,"title":"Emma Jones","short_name":"E Jones","first_name":"Emma Jones","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":110326,"title":"Seren Smale","short_name":"S Smale","first_name":"Seren Smale","last_name":"","middle_name":"","birthdate":"2004-12-13","birthplace":" Wrexham, Denbighshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/SmaleSeren","instagram_profile":"https:\/\/www.instagram.com\/seren.s_\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":""},{"pid":113878,"title":"Anna Browning","short_name":"A Browning","first_name":"Anna Browning","last_name":"","middle_name":"","birthdate":"2003-10-24","birthplace":"","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"squad","role_str":""},{"pid":113880,"title":"Bree Illing","short_name":"B Illing","first_name":"Bree Illing","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"nz","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":"New Zealand","role":"bowl","role_str":""},{"pid":113881,"title":"Izzy Sharp","short_name":"I Sharp","first_name":"Izzy Sharp","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"nz","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":"New Zealand","role":"wk","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":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":116396,"title":"Jodi Grewcock","short_name":"J Grewcock","first_name":"Jodi Grewcock","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":121919,"title":"Flora Devonshire","short_name":"F Devonshire","first_name":"Flora Devonshire","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"nz","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":"New Zealand","role":"all","role_str":""},{"pid":122220,"title":"Charis Pavely","short_name":"C Pavely","first_name":"Charis Pavely","last_name":"","middle_name":"","birthdate":"2004-10-24","birthplace":"Redditch","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/CharisPavely","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":123130,"title":"Emma McLeod","short_name":"E McLeod","first_name":"Emma McLeod","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"nz","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bat","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":137963,"title":"Tilly Corteen Coleman","short_name":"TC Coleman","first_name":"Tilly Corteen Coleman","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""}]},"etag":"95639a8d2d3481c079d1f68138b44a51","modified":"2025-07-12 05:46:04","datetime":"2025-07-12 05:46:04","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":90961,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"England A Women won by 6 runs","day_remaining_over":"","team_batting":"New Zealand A Women","team_bowling":"England A Women","live_inning_number":2,"live_score":{"runs":291,"overs":50,"wickets":9,"target":298,"runrate":5.82,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Bree Illing","batsman_id":113880,"runs":1,"balls_faced":1,"fours":0,"sixes":0,"strike_rate":"100.00"},{"name":"Emma Black","batsman_id":94414,"runs":32,"balls_faced":29,"fours":5,"sixes":0,"strike_rate":"110.34"}],"bowlers":[{"name":"Phoebe Turner","bowler_id":116258,"overs":10,"runs_conceded":67,"wickets":3,"maidens":1,"econ":"6.70"},{"name":"Jodi Grewcock","bowler_id":116396,"overs":9,"runs_conceded":42,"wickets":2,"maidens":1,"econ":"4.67"}],"commentaries":[{"event_id":"12208300","event":"ball","batsman_id":"94414","bowler_id":"146141","over":"45","ball":"6","score":4,"commentary":"Grace Thompson to Emma Black, Four,","noball_dismissal":false,"text":"","timestamp":1750696952,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event":"overend","over":46,"runs":7,"score":"255\/7","bats":[{"runs":13,"balls_faced":17,"fours":2,"sixes":0,"batsman_id":94414},{"runs":19,"balls_faced":20,"fours":1,"sixes":0,"batsman_id":44268}],"bowls":[{"runs_conceded":34,"maidens":0,"wickets":2,"bowler_id":146141,"overs":9},{"runs_conceded":26,"maidens":1,"wickets":2,"bowler_id":116396,"overs":7}],"commentary":"End of over 46 (7 runs), New Zealand A Women 255\/7"},{"event_id":"12208305","event":"ball","batsman_id":"44268","bowler_id":"116396","over":"46","ball":"1","score":"1lb","commentary":"Jodi Grewcock to Hannah Rowe, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1750696955,"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":"12208306","event":"ball","batsman_id":"94414","bowler_id":"116396","over":"46","ball":"2","score":0,"commentary":"Jodi Grewcock to Emma Black, no run,","noball_dismissal":false,"text":"","timestamp":1750696957,"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":"12208307","event":"ball","batsman_id":"94414","bowler_id":"116396","over":"46","ball":"3","score":1,"commentary":"Jodi Grewcock to Emma Black, 1 run,","noball_dismissal":false,"text":"","timestamp":1750696959,"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":"12208308","event":"ball","batsman_id":"44268","bowler_id":"116396","over":"46","ball":"4","score":1,"commentary":"Jodi Grewcock to Hannah Rowe, 1 run,","noball_dismissal":false,"text":"","timestamp":1750696962,"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":"12208311","event":"ball","batsman_id":"94414","bowler_id":"116396","over":"46","ball":"5","score":1,"commentary":"Jodi Grewcock to Emma Black, 1 run,","noball_dismissal":false,"text":"","timestamp":1750696965,"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":"12208314","event":"ball","batsman_id":"44268","bowler_id":"116396","over":"46","ball":"6","score":0,"commentary":"Jodi Grewcock to Hannah Rowe, no run,","noball_dismissal":false,"text":"","timestamp":1750696968,"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":47,"runs":4,"score":"259\/7","bats":[{"runs":20,"balls_faced":23,"fours":1,"sixes":0,"batsman_id":44268},{"runs":15,"balls_faced":20,"fours":2,"sixes":0,"batsman_id":94414}],"bowls":[{"runs_conceded":29,"maidens":1,"wickets":2,"bowler_id":116396,"overs":8},{"runs_conceded":34,"maidens":0,"wickets":2,"bowler_id":146141,"overs":9}],"commentary":"End of over 47 (4 runs), New Zealand A Women 259\/7"},{"event_id":"12208382","event":"ball","batsman_id":"94414","bowler_id":"116258","over":"47","ball":"1","score":1,"commentary":"Phoebe Turner to Emma Black, 1 run,","noball_dismissal":false,"text":"","timestamp":1750697130,"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":"12208384","event":"ball","batsman_id":"44268","bowler_id":"116258","over":"47","ball":"2","score":0,"commentary":"Phoebe Turner to Hannah Rowe, no run,","noball_dismissal":false,"text":"","timestamp":1750697142,"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":"12208386","event":"ball","batsman_id":"44268","bowler_id":"116258","over":"47","ball":"3","score":1,"commentary":"Phoebe Turner to Hannah Rowe, 1 run,","noball_dismissal":false,"text":"","timestamp":1750697144,"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":"12208388","event":"ball","batsman_id":"94414","bowler_id":"116258","over":"47","ball":"4","score":0,"commentary":"Phoebe Turner to Emma Black, no run,","noball_dismissal":false,"text":"","timestamp":1750697147,"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":"12208390","event":"ball","batsman_id":"94414","bowler_id":"116258","over":"47","ball":"5","score":4,"commentary":"Phoebe Turner to Emma Black, Four,","noball_dismissal":false,"text":"","timestamp":1750697153,"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":"12208403","event":"ball","batsman_id":"94414","bowler_id":"116258","over":"47","ball":"6","score":1,"commentary":"Phoebe Turner to Emma Black, 1 run,","noball_dismissal":false,"text":"","timestamp":1750697207,"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":48,"runs":7,"score":"266\/7","bats":[{"runs":21,"balls_faced":24,"fours":3,"sixes":0,"batsman_id":94414},{"runs":21,"balls_faced":25,"fours":1,"sixes":0,"batsman_id":44268}],"bowls":[{"runs_conceded":55,"maidens":1,"wickets":2,"bowler_id":116258,"overs":9},{"runs_conceded":29,"maidens":1,"wickets":2,"bowler_id":116396,"overs":8}],"commentary":"End of over 48 (7 runs), New Zealand A Women 266\/7"},{"event_id":"12208433","event":"ball","batsman_id":"94414","bowler_id":"116396","over":"48","ball":"1","score":4,"commentary":"Jodi Grewcock to Emma Black, Four,","noball_dismissal":false,"text":"","timestamp":1750697298,"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":"12208458","event":"ball","batsman_id":"94414","bowler_id":"116396","over":"48","ball":"2","score":0,"commentary":"Jodi Grewcock to Emma Black, no run,","noball_dismissal":false,"text":"","timestamp":1750697380,"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":"12208460","event":"ball","batsman_id":"94414","bowler_id":"116396","over":"48","ball":"3","score":"1wd","commentary":"Jodi Grewcock to Emma Black, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750697387,"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":"12208462","event":"ball","batsman_id":"94414","bowler_id":"116396","over":"48","ball":"3","score":2,"commentary":"Jodi Grewcock to Emma Black, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750697410,"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":"12208464","event":"ball","batsman_id":"94414","bowler_id":"116396","over":"48","ball":"4","score":4,"commentary":"Jodi Grewcock to Emma Black, Four,","noball_dismissal":false,"text":"","timestamp":1750697415,"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":"12208477","event":"ball","batsman_id":"94414","bowler_id":"116396","over":"48","ball":"5","score":1,"commentary":"Jodi Grewcock to Emma Black, 1 run,","noball_dismissal":false,"text":"","timestamp":1750697426,"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":"12208479","event":"ball","batsman_id":"44268","bowler_id":"116396","over":"48","ball":"6","score":1,"commentary":"Jodi Grewcock to Hannah Rowe, 1 run,","noball_dismissal":false,"text":"","timestamp":1750697431,"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":49,"runs":13,"score":"279\/7","bats":[{"runs":22,"balls_faced":26,"fours":1,"sixes":0,"batsman_id":44268},{"runs":32,"balls_faced":29,"fours":5,"sixes":0,"batsman_id":94414}],"bowls":[{"runs_conceded":42,"maidens":1,"wickets":2,"bowler_id":116396,"overs":9},{"runs_conceded":55,"maidens":1,"wickets":2,"bowler_id":116258,"overs":9}],"commentary":"End of over 49 (13 runs), New Zealand A Women 279\/7"},{"event_id":"12208508","event":"ball","batsman_id":"44268","bowler_id":"116258","over":"49","ball":"1","score":4,"commentary":"Phoebe Turner to Hannah Rowe, Four,","noball_dismissal":false,"text":"","timestamp":1750697516,"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":"12208509","event":"ball","batsman_id":"44268","bowler_id":"116258","over":"49","ball":"2","score":4,"commentary":"Phoebe Turner to Hannah Rowe, Four,","noball_dismissal":false,"text":"","timestamp":1750697520,"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":"12208536","event":"wicket","batsman_id":"44268","bowler_id":"116258","over":"49","ball":"3","score":"w","commentary":"Phoebe Turner to Hannah Rowe, no run, c F Kemp b P Turner,","noball_dismissal":false,"text":"","timestamp":1750697656,"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":"44268","how_out":"c F Kemp b P Turner","batsman_runs":"30","batsman_balls":"29"},{"event_id":"12208553","event":"ball","batsman_id":"96657","bowler_id":"116258","over":"49","ball":"4","score":2,"commentary":"Phoebe Turner to Amie Hucker, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750697753,"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":"12208555","event":"wicket","batsman_id":"96657","bowler_id":"116258","over":"49","ball":"5","score":"w","commentary":"Phoebe Turner to Amie Hucker, 1 run, runout (RM Southby \/ F Kemp),","noball_dismissal":false,"text":"","timestamp":1750697967,"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,"wicket_batsman_id":"96657","how_out":"runout (RM Southby \/ F Kemp)","batsman_runs":"3","batsman_balls":"2"},{"event_id":"12208560","event":"ball","batsman_id":"113880","bowler_id":"116258","over":"49","ball":"6","score":1,"commentary":"Phoebe Turner to Bree Illing, 1 run,","noball_dismissal":false,"text":"","timestamp":1750697959,"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":50,"runs":12,"score":"291\/9","bats":[{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":113880},{"runs":32,"balls_faced":29,"fours":5,"sixes":0,"batsman_id":94414}],"bowls":[{"runs_conceded":67,"maidens":1,"wickets":3,"bowler_id":116258,"overs":10},{"runs_conceded":42,"maidens":1,"wickets":2,"bowler_id":116396,"overs":9}],"commentary":"End of over 50 (12 runs), New Zealand A Women 291\/9"}],"day":"0","session":"0","live_inning":{"iid":198623,"number":2,"name":"New Zealand A Women Inning","short_name":"NZ-A-W Inning","status":2,"issuperover":"false","result":4,"batting_team_id":128354,"fielding_team_id":122919,"scores":"291\/9","scores_full":"291\/9 (50 ov)","fielder":[{"fielder_id":"61327","fielder_name":"Rhianna Southby","catches":1,"runout_thrower":0,"runout_catcher":1,"runout_direct_hit":0,"stumping":1,"is_substitute":"false"},{"fielder_id":"137963","fielder_name":"Tilly Corteen Coleman","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"122220","fielder_name":"Charis Pavely","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"102782","fielder_name":"Freya Kemp","catches":1,"runout_thrower":1,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"116396","fielder_name":"Jodi Grewcock","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"10"}},"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":"Amie Hucker","batsman_id":"96657","runs":"3","balls":"2","how_out":"runout (RM Southby \/ F Kemp)","score_at_dismissal":290,"overs_at_dismissal":"49.5","bowler_id":"0","dismissal":"runout","number":9},"extra_runs":{"byes":3,"legbyes":1,"wides":3,"noballs":1,"penalty":"0","total":8},"equations":{"runs":291,"wickets":9,"overs":"50","bowlers_used":7,"runrate":"5.82"},"current_partnership":{"runs":1,"balls":1,"overs":0.1,"batsmen":[{"name":"Bree Illing","batsman_id":113880,"runs":1,"balls":1},{"name":"Emma Black","batsman_id":94414,"runs":0,"balls":0}]},"did_not_bat":[],"max_over":"50","target":"298","recent_scores":"1,w,2,w,4,4,1,1,4,2,1,0,4,1,4,0,1,0","last_five_overs":"43\/2 8.32","last_ten_overs":"62\/4 6.10"},"teams":[{"tid":122919,"title":"England A Women","abbr":"EN-A-W","alt_name":"England A Women","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/England.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/England.png","country":"en","sex":"female","team_owner":"","head_coach":"","scores_full":"297\/4 (50 ov)","scores":"297\/4","overs":"50"},{"tid":128354,"title":"New Zealand A Women","abbr":"NZ-A-W","alt_name":"New Zealand A Women","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/New-zealand.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/New-zealand.png","country":"nz","sex":"female","team_owner":"","head_coach":"","scores_full":"291\/9 (50 ov)","scores":"291\/9","overs":"50"}],"players":[{"pid":44268,"title":"Hannah Rowe","short_name":"HM Rowe","first_name":"Hannah Rowe","last_name":"","middle_name":"","birthdate":"1996-10-03","birthplace":"Palmerston North","country":"nz","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":8.5,"facebook_profile":"https:\/\/www.facebook.com\/Hannah.R.Rowe\/","twitter_profile":"https:\/\/twitter.com\/hmrowey","instagram_profile":"https:\/\/www.instagram.com\/hannahrowe3\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bowl","role_str":""},{"pid":46694,"title":"Jess Watkin","short_name":"JM Watkin","first_name":"Jess Watkin","last_name":"","middle_name":"","birthdate":"1998-05-07","birthplace":"","country":"nz","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":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"all","role_str":""},{"pid":46746,"title":"Bella James","short_name":"IR James","first_name":"Bella James","last_name":"","middle_name":"","birthdate":"1999-01-27","birthplace":"","country":"nz","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bat","role_str":"(C)"},{"pid":46808,"title":"Polly Inglis","short_name":"PM Inglis","first_name":"Polly Inglis","last_name":"","middle_name":"","birthdate":"1996-05-31","birthplace":"","country":"nz","primary_team":[],"logo_url":"","playing_role":"wk","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":"New Zealand","role":"squad","role_str":""},{"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,"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":94414,"title":"Emma Black","short_name":"E Black","first_name":"Emma Black","last_name":"","middle_name":"","birthdate":"2001-08-08","birthplace":"","country":"nz","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":"New Zealand","role":"bowl","role_str":""},{"pid":94423,"title":"Nensi Patel","short_name":"NH Patel","first_name":"Nensi Patel","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"nz","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":"New Zealand","role":"squad","role_str":""},{"pid":94639,"title":"Mahika Gaur","short_name":"M Gaur","first_name":"Mahika Gaur","last_name":"","middle_name":"","birthdate":"2006-03-09","birthplace":"Reading, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/mahika.gaur.90\/","twitter_profile":"https:\/\/twitter.com\/mahikagaur","instagram_profile":"https:\/\/www.instagram.com\/mahikagaur_\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":96657,"title":"Amie Hucker","short_name":"A Hucker","first_name":"Amie Hucker","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"nz","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":"New Zealand","role":"all","role_str":""},{"pid":96870,"title":"Izzy Gaze","short_name":"I Gaze","first_name":"Izzy Gaze","last_name":"","middle_name":"","birthdate":"2004-05-08","birthplace":"Haarlem","country":"nz","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/izzy_gaze\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"wk","role_str":"(WK)"},{"pid":97319,"title":"Georgia Plimmer","short_name":"G Plimmer","first_name":"Georgia Plimmer","last_name":"","middle_name":"","birthdate":"2004-02-08","birthplace":"Wellington","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bat","role_str":""},{"pid":102763,"title":"Grace Scrivens","short_name":"G Scrivens","first_name":"Grace Scrivens","last_name":"","middle_name":"","birthdate":"2003-11-13","birthplace":" Kent, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/grace.scrivens\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/graciescriv\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":"(C)"},{"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":"bat","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":"bat","role_str":""},{"pid":102945,"title":"Hannah Baker","short_name":"H Baker","first_name":"Hannah Baker","last_name":"","middle_name":"","birthdate":"2004-02-03","birthplace":"West Midlands, England","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/hannahbakeerr\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":102946,"title":"Grace Potts","short_name":"G Potts","first_name":"Grace Potts","last_name":"","middle_name":"","birthdate":"2002-07-12","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/gracepotts01","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":104617,"title":"Molly Penfold","short_name":"M Penfold","first_name":"Molly Penfold","last_name":"","middle_name":"","birthdate":"2001-06-15","birthplace":"London","country":"nz","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/molly.penfold\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"squad","role_str":""},{"pid":107880,"title":"Alexa Stonehouse","short_name":"A Stonehouse","first_name":"Alexa Stonehouse","last_name":"","middle_name":"","birthdate":"2004-05-12","birthplace":"Ashford, England","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/AlexaStonehouse","instagram_profile":"https:\/\/www.instagram.com\/alexa_stonehouse","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":110318,"title":"Davina Perrin","short_name":"D Perrin","first_name":"Davina Perrin","last_name":"","middle_name":"","birthdate":"2006-09-08","birthplace":"Wolverhampton","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":110321,"title":"Emma Jones","short_name":"E Jones","first_name":"Emma Jones","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":110326,"title":"Seren Smale","short_name":"S Smale","first_name":"Seren Smale","last_name":"","middle_name":"","birthdate":"2004-12-13","birthplace":" Wrexham, Denbighshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/SmaleSeren","instagram_profile":"https:\/\/www.instagram.com\/seren.s_\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":""},{"pid":113878,"title":"Anna Browning","short_name":"A Browning","first_name":"Anna Browning","last_name":"","middle_name":"","birthdate":"2003-10-24","birthplace":"","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"squad","role_str":""},{"pid":113880,"title":"Bree Illing","short_name":"B Illing","first_name":"Bree Illing","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"nz","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":"New Zealand","role":"bowl","role_str":""},{"pid":113881,"title":"Izzy Sharp","short_name":"I Sharp","first_name":"Izzy Sharp","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"nz","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":"New Zealand","role":"wk","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":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":116396,"title":"Jodi Grewcock","short_name":"J Grewcock","first_name":"Jodi Grewcock","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":121919,"title":"Flora Devonshire","short_name":"F Devonshire","first_name":"Flora Devonshire","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"nz","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":"New Zealand","role":"all","role_str":""},{"pid":122220,"title":"Charis Pavely","short_name":"C Pavely","first_name":"Charis Pavely","last_name":"","middle_name":"","birthdate":"2004-10-24","birthplace":"Redditch","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/CharisPavely","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":123130,"title":"Emma McLeod","short_name":"E McLeod","first_name":"Emma McLeod","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"nz","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bat","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":137963,"title":"Tilly Corteen Coleman","short_name":"TC Coleman","first_name":"Tilly Corteen Coleman","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""}]},"etag":"95639a8d2d3481c079d1f68138b44a51","modified":"2025-07-12 05:46:04","datetime":"2025-07-12 05:46:04","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90961 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:2deebb0f-6e77-427c-b585-b07941178c48
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90961 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90961,3,'{"status":"ok","response":{"match_id":90961,"title":"England A Women vs New Zealand A Women","short_title":"EN-A-W vs NZ-A-W","subtitle":"Match 1","match_number":"1","format":4,"format_str":"List A","status":2,"status_str":"Completed","status_note":"England A Women won by 6 runs","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129647,"title":"New Zealand A Women tour of England","abbr":"EN-A-W vs NZ-A-W","type":"tour","category":"women","match_format":"mixed","season":"2025","status":"live","datestart":"2025-06-23","dateend":"2025-07-07","country":"int","total_matches":"2","total_rounds":"1","total_teams":"2"},"teama":{"team_id":122919,"name":"England A Women","short_name":"EN-A-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/England.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/England.png","scores_full":"297\/4 (50 ov)","scores":"297\/4","overs":"50"},"teamb":{"team_id":128354,"name":"New Zealand A Women","short_name":"NZ-A-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/New-zealand.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/New-zealand.png","scores_full":"291\/9 (50 ov)","scores":"291\/9","overs":"50"},"date_start":"2025-06-23 10:00:00","date_end":"2025-06-24 04:00:00","timestamp_start":1750672800,"timestamp_end":1750737600,"date_start_ist":"2025-06-23 15:30:00","date_end_ist":"2025-06-24 09:30:00","venue":{"venue_id":"49","name":"County Ground","location":"Derby","country":"England","timezone":""},"umpires":"Gabi Brown (England), Jasmine Naeem (England)","referee":"","equation":"","live":"","result":"EN-A-W won by 6 runs","result_type":1,"win_margin":"6 runs","winning_team_id":122919,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-22 22:36:08","verify_time":"2025-06-23 22:43:24","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"broken clouds","temp":19.94,"humidity":51,"visibility":10000,"wind_speed":"17.92","clouds":73},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"New Zealand A Women elected to bowl","winner":128354,"decision":2}},"etag":"4248eca21498c745c3caefda9ea99457","modified":"2025-07-12 05:46:05","datetime":"2025-07-12 05:46:05","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":90961,"title":"England A Women vs New Zealand A Women","short_title":"EN-A-W vs NZ-A-W","subtitle":"Match 1","match_number":"1","format":4,"format_str":"List A","status":2,"status_str":"Completed","status_note":"England A Women won by 6 runs","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129647,"title":"New Zealand A Women tour of England","abbr":"EN-A-W vs NZ-A-W","type":"tour","category":"women","match_format":"mixed","season":"2025","status":"live","datestart":"2025-06-23","dateend":"2025-07-07","country":"int","total_matches":"2","total_rounds":"1","total_teams":"2"},"teama":{"team_id":122919,"name":"England A Women","short_name":"EN-A-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/England.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/England.png","scores_full":"297\/4 (50 ov)","scores":"297\/4","overs":"50"},"teamb":{"team_id":128354,"name":"New Zealand A Women","short_name":"NZ-A-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/New-zealand.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/New-zealand.png","scores_full":"291\/9 (50 ov)","scores":"291\/9","overs":"50"},"date_start":"2025-06-23 10:00:00","date_end":"2025-06-24 04:00:00","timestamp_start":1750672800,"timestamp_end":1750737600,"date_start_ist":"2025-06-23 15:30:00","date_end_ist":"2025-06-24 09:30:00","venue":{"venue_id":"49","name":"County Ground","location":"Derby","country":"England","timezone":""},"umpires":"Gabi Brown (England), Jasmine Naeem (England)","referee":"","equation":"","live":"","result":"EN-A-W won by 6 runs","result_type":1,"win_margin":"6 runs","winning_team_id":122919,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-22 22:36:08","verify_time":"2025-06-23 22:43:24","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"broken clouds","temp":19.94,"humidity":51,"visibility":10000,"wind_speed":"17.92","clouds":73},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"New Zealand A Women elected to bowl","winner":128354,"decision":2}},"etag":"4248eca21498c745c3caefda9ea99457","modified":"2025-07-12 05:46:05","datetime":"2025-07-12 05:46:05","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90961 AND DataTypeId = 3 END Live Report & Scorecard of England A Women vs New Zealand A Women Match 1
England A Women vs New Zealand A Women, Live Cricket Commentary