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:dd8fd2f0-368f-4b7c-884e-2f3ac85f62b6
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90349 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90349,1,'{"status":"ok","response":{"mid":90349,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Match Tie (DLS method)","day_remaining_over":"","team_batting":"Essex Women","team_bowling":"Surrey Women","live_inning_number":2,"live_score":{"runs":93,"overs":10,"wickets":5,"target":94,"runrate":9.3,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Joanne Gardner","batsman_id":51436,"runs":6,"balls_faced":3,"fours":1,"sixes":0,"strike_rate":"200.00"},{"name":"Sophia Smale","batsman_id":116256,"runs":1,"balls_faced":1,"fours":0,"sixes":0,"strike_rate":"100.00"}],"bowlers":[{"name":"Grace Harris","bowler_id":44682,"overs":2,"runs_conceded":22,"wickets":2,"maidens":0,"econ":"11.00"},{"name":"Phoebe Franklin","bowler_id":51920,"overs":2,"runs_conceded":15,"wickets":0,"maidens":0,"econ":"7.50"}],"commentaries":[{"event_id":"12294392","event":"ball","batsman_id":"10508","bowler_id":"102554","over":"5","ball":"5","score":4,"commentary":"Danielle Gregory to Lauren Winfield Hill, Four,","noball_dismissal":false,"text":"","timestamp":1751811061,"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":"12294394","event":"ball","batsman_id":"10508","bowler_id":"102554","over":"5","ball":"6","score":1,"commentary":"Danielle Gregory to Lauren Winfield Hill, 1 run,","noball_dismissal":false,"text":"","timestamp":1751811064,"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":6,"runs":14,"score":"58\/1","bats":[{"runs":48,"balls_faced":24,"fours":9,"sixes":0,"batsman_id":10508},{"runs":9,"balls_faced":10,"fours":1,"sixes":0,"batsman_id":96091}],"bowls":[{"runs_conceded":14,"maidens":0,"wickets":0,"bowler_id":102554,"overs":1},{"runs_conceded":4,"maidens":0,"wickets":0,"bowler_id":51920,"overs":1}],"commentary":"End of over 6 (14 runs), Essex Women 58\/1"},{"event_id":"12294396","event":"ball","batsman_id":"10508","bowler_id":"58700","over":"6","ball":"1","score":0,"commentary":"Priyanaz Chatterji to Lauren Winfield Hill, no run,","noball_dismissal":false,"text":"","timestamp":1751811067,"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":"12294398","event":"ball","batsman_id":"10508","bowler_id":"58700","over":"6","ball":"2","score":1,"commentary":"Priyanaz Chatterji to Lauren Winfield Hill, 1 run,","noball_dismissal":false,"text":"","timestamp":1751811070,"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":"12294400","event":"ball","batsman_id":"96091","bowler_id":"58700","over":"6","ball":"3","score":1,"commentary":"Priyanaz Chatterji to Madeline Penna, 1 run,","noball_dismissal":false,"text":"","timestamp":1751811386,"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":"12294455","event":"wicket","batsman_id":"10508","bowler_id":"58700","over":"6","ball":"4","score":"w","commentary":"Priyanaz Chatterji to Lauren Winfield Hill, no run, c GM Harris b PA Chatterji,","noball_dismissal":false,"text":"","timestamp":1751811390,"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":"10508","how_out":"c GM Harris b PA Chatterji","batsman_runs":"49","batsman_balls":"27"},{"event_id":"12294492","event":"ball","batsman_id":"51465","bowler_id":"58700","over":"6","ball":"5","score":4,"commentary":"Priyanaz Chatterji to Cordelia Griffith, Four,","noball_dismissal":false,"text":"","timestamp":1751811393,"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":"12294500","event":"ball","batsman_id":"51465","bowler_id":"58700","over":"6","ball":"6","score":1,"commentary":"Priyanaz Chatterji to Cordelia Griffith, 1 run,","noball_dismissal":false,"text":"","timestamp":1751811397,"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":7,"runs":7,"score":"65\/2","bats":[{"runs":5,"balls_faced":2,"fours":1,"sixes":0,"batsman_id":51465},{"runs":10,"balls_faced":11,"fours":1,"sixes":0,"batsman_id":96091}],"bowls":[{"runs_conceded":12,"maidens":0,"wickets":2,"bowler_id":58700,"overs":2},{"runs_conceded":14,"maidens":0,"wickets":0,"bowler_id":102554,"overs":1}],"commentary":"End of over 7 (7 runs), Essex Women 65\/2"},{"event_id":"12294504","event":"ball","batsman_id":"51465","bowler_id":"51355","over":"7","ball":"1","score":2,"commentary":"Bryony Smith to Cordelia Griffith, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751811400,"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":"12294506","event":"ball","batsman_id":"51465","bowler_id":"51355","over":"7","ball":"2","score":"1lb","commentary":"Bryony Smith to Cordelia Griffith, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1751811403,"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":"12294508","event":"ball","batsman_id":"96091","bowler_id":"51355","over":"7","ball":"3","score":1,"commentary":"Bryony Smith to Madeline Penna, 1 run,","noball_dismissal":false,"text":"","timestamp":1751811407,"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":"12294509","event":"ball","batsman_id":"51465","bowler_id":"51355","over":"7","ball":"4","score":1,"commentary":"Bryony Smith to Cordelia Griffith, 1 run,","noball_dismissal":false,"text":"","timestamp":1751811410,"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":"12294511","event":"ball","batsman_id":"96091","bowler_id":"51355","over":"7","ball":"5","score":1,"commentary":"Bryony Smith to Madeline Penna, 1 run,","noball_dismissal":false,"text":"","timestamp":1751811414,"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":"12294513","event":"ball","batsman_id":"51465","bowler_id":"51355","over":"7","ball":"6","score":4,"commentary":"Bryony Smith to Cordelia Griffith, Four,","noball_dismissal":false,"text":"","timestamp":1751811419,"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":8,"runs":10,"score":"75\/2","bats":[{"runs":12,"balls_faced":6,"fours":2,"sixes":0,"batsman_id":51465},{"runs":12,"balls_faced":13,"fours":1,"sixes":0,"batsman_id":96091}],"bowls":[{"runs_conceded":15,"maidens":0,"wickets":0,"bowler_id":51355,"overs":2},{"runs_conceded":12,"maidens":0,"wickets":2,"bowler_id":58700,"overs":2}],"commentary":"End of over 8 (10 runs), Essex Women 75\/2"},{"event_id":"12294525","event":"ball","batsman_id":"96091","bowler_id":"51920","over":"8","ball":"1","score":4,"commentary":"Phoebe Franklin to Madeline Penna, Four,","noball_dismissal":false,"text":"","timestamp":1751811422,"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":"12294527","event":"ball","batsman_id":"96091","bowler_id":"51920","over":"8","ball":"2","score":0,"commentary":"Phoebe Franklin to Madeline Penna, no run,","noball_dismissal":false,"text":"","timestamp":1751811429,"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":"12294529","event":"ball","batsman_id":"96091","bowler_id":"51920","over":"8","ball":"3","score":4,"commentary":"Phoebe Franklin to Madeline Penna, Four,","noball_dismissal":false,"text":"","timestamp":1751811432,"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":"12294530","event":"ball","batsman_id":"96091","bowler_id":"51920","over":"8","ball":"4","score":1,"commentary":"Phoebe Franklin to Madeline Penna, 1 run,","noball_dismissal":false,"text":"","timestamp":1751811436,"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":"12294533","event":"ball","batsman_id":"51465","bowler_id":"51920","over":"8","ball":"5","score":1,"commentary":"Phoebe Franklin to Cordelia Griffith, 1 run,","noball_dismissal":false,"text":"","timestamp":1751811439,"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":"12294535","event":"ball","batsman_id":"96091","bowler_id":"51920","over":"8","ball":"6","score":1,"commentary":"Phoebe Franklin to Madeline Penna, 1 run,","noball_dismissal":false,"text":"","timestamp":1751811786,"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":9,"runs":11,"score":"86\/2","bats":[{"runs":22,"balls_faced":18,"fours":3,"sixes":0,"batsman_id":96091},{"runs":13,"balls_faced":7,"fours":2,"sixes":0,"batsman_id":51465}],"bowls":[{"runs_conceded":15,"maidens":0,"wickets":0,"bowler_id":51920,"overs":2},{"runs_conceded":15,"maidens":0,"wickets":0,"bowler_id":51355,"overs":2}],"commentary":"End of over 9 (11 runs), Essex Women 86\/2"},{"event_id":"12294630","event":"wicket","batsman_id":"96091","bowler_id":"44682","over":"9","ball":"1","score":"w","commentary":"Grace Harris to Madeline Penna, no run, c PA Franklin b GM Harris,","noball_dismissal":false,"text":"","timestamp":1751811789,"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":"96091","how_out":"c PA Franklin b GM Harris","batsman_runs":"22","batsman_balls":"19"},{"event_id":"12294633","event":"ball","batsman_id":"51436","bowler_id":"44682","over":"9","ball":"2","score":4,"commentary":"Grace Harris to Joanne Gardner, Four,","noball_dismissal":false,"text":"","timestamp":1751811792,"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":"12294636","event":"ball","batsman_id":"51436","bowler_id":"44682","over":"9","ball":"3","score":1,"commentary":"Grace Harris to Joanne Gardner, 1 run,","noball_dismissal":false,"text":"","timestamp":1751811796,"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":"12294656","event":"wicket","batsman_id":"51465","bowler_id":"44682","over":"9","ball":"4","score":"w","commentary":"Grace Harris to Cordelia Griffith, no run, st KM Chathli b GM Harris,","noball_dismissal":false,"text":"","timestamp":1751811798,"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":"51465","how_out":"st KM Chathli b GM Harris","batsman_runs":"13","batsman_balls":"8"},{"event_id":"12294658","event":"ball","batsman_id":"116256","bowler_id":"44682","over":"9","ball":"5","score":1,"commentary":"Grace Harris to Sophia Smale, 1 run,","noball_dismissal":false,"text":"","timestamp":1751811801,"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":"12294672","event":"wicket","batsman_id":"51436","bowler_id":"44682","over":"9","ball":"6","score":"w","commentary":"Grace Harris to Joanne Gardner, 1 run, runout (KM Chathli \/ PA Franklin),","noball_dismissal":false,"text":"","timestamp":1751811819,"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":"51436","how_out":"runout (KM Chathli \/ PA Franklin)","batsman_runs":"6","batsman_balls":"3"},{"event":"overend","over":10,"runs":7,"score":"93\/5","bats":[{"runs":6,"balls_faced":3,"fours":1,"sixes":0,"batsman_id":51436},{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":116256}],"bowls":[{"runs_conceded":22,"maidens":0,"wickets":2,"bowler_id":44682,"overs":2},{"runs_conceded":15,"maidens":0,"wickets":0,"bowler_id":51920,"overs":2}],"commentary":"End of over 10 (7 runs), Essex Women 93\/5"}],"day":"0","session":"0","live_inning":{"iid":199199,"number":2,"name":"Essex Women Inning","short_name":"ESS-W Inning","status":2,"issuperover":"false","result":3,"batting_team_id":19231,"fielding_team_id":19199,"scores":"93\/5","scores_full":"93\/5 (10 ov)","fielder":[{"fielder_id":"44682","fielder_name":"Grace Harris","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"102554","fielder_name":"Danielle Gregory","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"51920","fielder_name":"Phoebe Franklin","catches":1,"runout_thrower":1,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"110319","fielder_name":"Kira Chathli","catches":0,"runout_thrower":0,"runout_catcher":1,"runout_direct_hit":0,"stumping":1,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Joanne Gardner","batsman_id":"51436","runs":"6","balls":"3","how_out":"runout (KM Chathli \/ PA Franklin)","score_at_dismissal":93,"overs_at_dismissal":"9.6","bowler_id":"0","dismissal":"runout","number":5},"extra_runs":{"byes":0,"legbyes":1,"wides":0,"noballs":0,"penalty":"0","total":1},"equations":{"runs":93,"wickets":5,"overs":"10","bowlers_used":6,"runrate":"9.30"},"current_partnership":{"runs":2,"balls":2,"overs":0.2,"batsmen":[{"name":"Sophia Smale","batsman_id":116256,"runs":1,"balls":1},{"name":"Joanne Gardner","batsman_id":51436,"runs":1,"balls":1}]},"did_not_bat":[{"player_id":"51452","name":"Amara Carr"},{"player_id":"51928","name":"Kate Coppack"},{"player_id":"107856","name":"Esmae Macgregor"},{"player_id":"44477","name":"Abtaha Maqsood"},{"player_id":"93882","name":"Eva Gray"}],"max_over":"10","target":"94","recent_scores":"w,1,w,1,4,w,1,1,1,4,0,4,4,1,1,1,1,2","last_five_overs":"49\/4 9.80","last_ten_overs":"93\/5 9.30"},"teams":[{"tid":19199,"title":"Surrey Women","abbr":"SUR-W","alt_name":"SUR-W","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/12\/Surrey-Women.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/12\/Surrey-Women.png","country":"en","sex":"female","team_owner":"","head_coach":"","scores_full":"159\/5 (20 ov)","scores":"159\/5","overs":"20"},{"tid":19231,"title":"Essex Women","abbr":"ESS-W","alt_name":"ESS-W","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2021\/05\/New_Eagles_Logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2021\/05\/New_Eagles_Logo.png","country":"en","sex":"female","team_owner":"","head_coach":"","scores_full":"93\/5 (10 ov)","scores":"93\/5","overs":"10"}],"players":[{"pid":10508,"title":"Lauren Winfield Hill","short_name":"LW Hill","first_name":"Lauren Winfield Hill","last_name":"","middle_name":"","birthdate":"1990-08-16","birthplace":"York, United Kingdom","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":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Lauren_Winfield","instagram_profile":"https:\/\/www.instagram.com\/laurenwinfield58\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":44477,"title":"Abtaha Maqsood","short_name":"AM Maqsood","first_name":"Abtaha Maqsood","last_name":"","middle_name":"","birthdate":"1999-06-11","birthplace":"Glasgow","country":"sct","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/abtaha_m","instagram_profile":"https:\/\/www.instagram.com\/abtaha_m\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Scotland","role":"bowl","role_str":""},{"pid":44682,"title":"Grace Harris","short_name":"GM Harris","first_name":"Grace Harris","last_name":"","middle_name":"","birthdate":"1993-09-18","birthplace":"Ipswich, Australia","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/189Grace","instagram_profile":"https:\/\/www.instagram.com\/graceh_189","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Australia","role":"all","role_str":""},{"pid":44766,"title":"Danielle Wyatt","short_name":"DN Wyatt","first_name":"Danielle Wyatt","last_name":"","middle_name":"","birthdate":"1991-04-22","birthplace":"Stoke-on-Trent, Staffordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Danni_Wyatt","instagram_profile":"https:\/\/www.instagram.com\/danniwyatt28\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":44775,"title":"Tash Farrant","short_name":"NE Farrant","first_name":"Tash Farrant","last_name":"","middle_name":"","birthdate":"1996-05-29","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51355,"title":"Bryony Smith","short_name":"BF Smith","first_name":"Bryony Smith","last_name":"","middle_name":"","birthdate":"1997-12-12","birthplace":"Sutton, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/CranioSacralScotland\/","twitter_profile":"https:\/\/twitter.com\/BrySmith97","instagram_profile":"https:\/\/www.instagram.com\/bryonysmith97\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"pid":51366,"title":"Paige Scholfield","short_name":"PJ Scholfield","first_name":"Paige Scholfield","last_name":"","middle_name":"","birthdate":"1995-12-19","birthplace":"Durban, South Africa","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/PaigeSchol","instagram_profile":"https:\/\/www.instagram.com\/paigescholf\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51436,"title":"Joanne Gardner","short_name":"J Gardner","first_name":"Joanne Gardner","last_name":"","middle_name":"","birthdate":"1997-03-25","birthplace":"Newport, Isle of Wight","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/JoGardner_14","instagram_profile":"https:\/\/www.instagram.com\/jogardner_14\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":51452,"title":"Amara Carr","short_name":"AD Carr","first_name":"Amara Carr","last_name":"","middle_name":"","birthdate":"1994-04-17","birthplace":"Plymouth, Devon","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/amara_carr\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":""},{"pid":51453,"title":"Aylish Cranstone","short_name":"A Cranstone","first_name":"Aylish Cranstone","last_name":"","middle_name":"","birthdate":"1994-08-28","birthplace":"Guildford, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/AylishCranstone","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51465,"title":"Cordelia Griffith","short_name":"CL Griffith","first_name":"Cordelia Griffith","last_name":"","middle_name":"","birthdate":"1995-09-19","birthplace":"Islington, London","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/cordeliagriff","instagram_profile":"https:\/\/www.instagram.com\/cordelia_griffith\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":51471,"title":"Kelly Castle","short_name":"KS Castle","first_name":"Kelly Castle","last_name":"","middle_name":"","birthdate":"1997-09-04","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":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51480,"title":"Alice Davidson-Richards","short_name":"AN Davidson-Richards","first_name":"Alice Davidson-Richards","last_name":"","middle_name":"","birthdate":"1994-05-29","birthplace":"Tunbridge Wells, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/alice.davidsonrichards\/","twitter_profile":"https:\/\/twitter.com\/alicedr24","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":51739,"title":"Sophia Dunkley","short_name":"SIR Dunkley","first_name":"Sophia Dunkley","last_name":"","middle_name":"","birthdate":"1998-07-16","birthplace":" Lambeth, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/dunkleysophia","instagram_profile":"https:\/\/www.instagram.com\/sophiadunkley\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51793,"title":"Alice Macleod","short_name":"AJ Macleod","first_name":"Alice Macleod","last_name":"","middle_name":"","birthdate":"1994-05-14","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":51920,"title":"Phoebe Franklin","short_name":"PA Franklin","first_name":"Phoebe Franklin","last_name":"","middle_name":"","birthdate":"1998-02-18","birthplace":"Greenwich, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/phoebe.franklin\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":51928,"title":"Kate Coppack","short_name":"KL Coppack","first_name":"Kate Coppack","last_name":"","middle_name":"","birthdate":"1994-08-30","birthplace":"Chester, Cheshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/copsshots\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":58700,"title":"Priyanaz Chatterji","short_name":"PA Chatterji","first_name":"Priyanaz Chatterji","last_name":"","middle_name":"","birthdate":"1993-08-12","birthplace":"Dundee, Angus, Scotland","country":"sct","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":"https:\/\/twitter.com\/priyanazc","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Scotland","role":"bat","role_str":""},{"pid":93878,"title":"Alice Monaghan","short_name":"AZ Monaghan","first_name":"Alice Monaghan","last_name":"","middle_name":"","birthdate":"2000-03-20","birthplace":" Basingstoke, Hampshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/alicemonaghan_\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":93882,"title":"Eva Gray","short_name":"E Gray","first_name":"Eva Gray","last_name":"","middle_name":"","birthdate":"2000-05-24","birthplace":"Surrey, England","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/evagray134","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":"(C)"},{"pid":93927,"title":"Sophie Munro","short_name":"S Munro","first_name":"Sophie Munro","last_name":"","middle_name":"","birthdate":"2001-08-31","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":96091,"title":"Madeline Penna","short_name":"M Penna","first_name":"Madeline Penna","last_name":"","middle_name":"","birthdate":"2000-08-30","birthplace":"","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Australia","role":"all","role_str":""},{"pid":102552,"title":"Alice Capsey","short_name":"A Capsey","first_name":"Alice Capsey","last_name":"","middle_name":"","birthdate":"2004-08-11","birthplace":" Redhill, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/AliceCapsey","instagram_profile":"https:\/\/www.instagram.com\/alicecapsey_\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":102554,"title":"Danielle Gregory","short_name":"D Gregory","first_name":"Danielle Gregory","last_name":"","middle_name":"","birthdate":"1998-12-04","birthplace":" Frimley, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","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":9,"facebook_profile":"https:\/\/www.facebook.com\/grace.scrivens\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/graciescriv\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":102780,"title":"Ariana Dowse","short_name":"A Dowse","first_name":"Ariana Dowse","last_name":"","middle_name":"","birthdate":"2001-02-08","birthplace":"","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":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":107856,"title":"Esmae Macgregor","short_name":"E Macgregor","first_name":"Esmae Macgregor","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":107860,"title":"Madeleine Blinkhorn Jones","short_name":"MB Jones","first_name":"Madeleine Blinkhorn 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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","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":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/AlexaStonehouse","instagram_profile":"https:\/\/www.instagram.com\/alexa_stonehouse","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":109739,"title":"Florence Miller","short_name":"Florence Miller","first_name":"Florence Miller","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":110319,"title":"Kira Chathli","short_name":"KM Chathli","first_name":"Kira Chathli","last_name":"","middle_name":"","birthdate":"1999-07-29","birthplace":"Southwark, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper ","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/kira_chathli\/with_replies","instagram_profile":"https:\/\/www.instagram.com\/kira_chathli\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":110320,"title":"Kalea Moore","short_name":"K Moore","first_name":"Kalea Moore","last_name":"","middle_name":"","birthdate":"2003-03-27","birthplace":" Greenwich, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/KallyM27","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":110338,"title":"Ryana Macdonald-Gay","short_name":"R Macdonald-Gay","first_name":"Ryana Macdonald-Gay","last_name":"","middle_name":"","birthdate":"2004-02-12","birthplace":"Maidstone, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":116256,"title":"Sophia Smale","short_name":"SAE Smale","first_name":"Sophia Smale","last_name":"","middle_name":"","birthdate":"2004-12-08","birthplace":"Newport, Monmouthshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/sophiasmale","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":119593,"title":"Jemima Spence","short_name":"J Spence","first_name":"Jemima Spence","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":123129,"title":"Charlotte Lambert","short_name":"C Lambert","first_name":"Charlotte Lambert","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":128842,"title":"Emily Burke","short_name":"E Burke","first_name":"Emily Burke","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":129018,"title":"Bethan Miles","short_name":"B Miles","first_name":"Bethan Miles","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":137960,"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":"","bowling_type":"","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":141144,"title":"Rachel King","short_name":"R King","first_name":"Rachel King","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""}]},"etag":"7c6a35051320504d804279dfa5e010aa","modified":"2025-07-15 10:27:43","datetime":"2025-07-15 10:27:43","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":90349,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Match Tie (DLS method)","day_remaining_over":"","team_batting":"Essex Women","team_bowling":"Surrey Women","live_inning_number":2,"live_score":{"runs":93,"overs":10,"wickets":5,"target":94,"runrate":9.3,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Joanne Gardner","batsman_id":51436,"runs":6,"balls_faced":3,"fours":1,"sixes":0,"strike_rate":"200.00"},{"name":"Sophia Smale","batsman_id":116256,"runs":1,"balls_faced":1,"fours":0,"sixes":0,"strike_rate":"100.00"}],"bowlers":[{"name":"Grace Harris","bowler_id":44682,"overs":2,"runs_conceded":22,"wickets":2,"maidens":0,"econ":"11.00"},{"name":"Phoebe Franklin","bowler_id":51920,"overs":2,"runs_conceded":15,"wickets":0,"maidens":0,"econ":"7.50"}],"commentaries":[{"event_id":"12294392","event":"ball","batsman_id":"10508","bowler_id":"102554","over":"5","ball":"5","score":4,"commentary":"Danielle Gregory to Lauren Winfield Hill, Four,","noball_dismissal":false,"text":"","timestamp":1751811061,"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":"12294394","event":"ball","batsman_id":"10508","bowler_id":"102554","over":"5","ball":"6","score":1,"commentary":"Danielle Gregory to Lauren Winfield Hill, 1 run,","noball_dismissal":false,"text":"","timestamp":1751811064,"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":6,"runs":14,"score":"58\/1","bats":[{"runs":48,"balls_faced":24,"fours":9,"sixes":0,"batsman_id":10508},{"runs":9,"balls_faced":10,"fours":1,"sixes":0,"batsman_id":96091}],"bowls":[{"runs_conceded":14,"maidens":0,"wickets":0,"bowler_id":102554,"overs":1},{"runs_conceded":4,"maidens":0,"wickets":0,"bowler_id":51920,"overs":1}],"commentary":"End of over 6 (14 runs), Essex Women 58\/1"},{"event_id":"12294396","event":"ball","batsman_id":"10508","bowler_id":"58700","over":"6","ball":"1","score":0,"commentary":"Priyanaz Chatterji to Lauren Winfield Hill, no run,","noball_dismissal":false,"text":"","timestamp":1751811067,"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":"12294398","event":"ball","batsman_id":"10508","bowler_id":"58700","over":"6","ball":"2","score":1,"commentary":"Priyanaz Chatterji to Lauren Winfield Hill, 1 run,","noball_dismissal":false,"text":"","timestamp":1751811070,"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":"12294400","event":"ball","batsman_id":"96091","bowler_id":"58700","over":"6","ball":"3","score":1,"commentary":"Priyanaz Chatterji to Madeline Penna, 1 run,","noball_dismissal":false,"text":"","timestamp":1751811386,"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":"12294455","event":"wicket","batsman_id":"10508","bowler_id":"58700","over":"6","ball":"4","score":"w","commentary":"Priyanaz Chatterji to Lauren Winfield Hill, no run, c GM Harris b PA Chatterji,","noball_dismissal":false,"text":"","timestamp":1751811390,"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":"10508","how_out":"c GM Harris b PA Chatterji","batsman_runs":"49","batsman_balls":"27"},{"event_id":"12294492","event":"ball","batsman_id":"51465","bowler_id":"58700","over":"6","ball":"5","score":4,"commentary":"Priyanaz Chatterji to Cordelia Griffith, Four,","noball_dismissal":false,"text":"","timestamp":1751811393,"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":"12294500","event":"ball","batsman_id":"51465","bowler_id":"58700","over":"6","ball":"6","score":1,"commentary":"Priyanaz Chatterji to Cordelia Griffith, 1 run,","noball_dismissal":false,"text":"","timestamp":1751811397,"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":7,"runs":7,"score":"65\/2","bats":[{"runs":5,"balls_faced":2,"fours":1,"sixes":0,"batsman_id":51465},{"runs":10,"balls_faced":11,"fours":1,"sixes":0,"batsman_id":96091}],"bowls":[{"runs_conceded":12,"maidens":0,"wickets":2,"bowler_id":58700,"overs":2},{"runs_conceded":14,"maidens":0,"wickets":0,"bowler_id":102554,"overs":1}],"commentary":"End of over 7 (7 runs), Essex Women 65\/2"},{"event_id":"12294504","event":"ball","batsman_id":"51465","bowler_id":"51355","over":"7","ball":"1","score":2,"commentary":"Bryony Smith to Cordelia Griffith, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751811400,"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":"12294506","event":"ball","batsman_id":"51465","bowler_id":"51355","over":"7","ball":"2","score":"1lb","commentary":"Bryony Smith to Cordelia Griffith, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1751811403,"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":"12294508","event":"ball","batsman_id":"96091","bowler_id":"51355","over":"7","ball":"3","score":1,"commentary":"Bryony Smith to Madeline Penna, 1 run,","noball_dismissal":false,"text":"","timestamp":1751811407,"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":"12294509","event":"ball","batsman_id":"51465","bowler_id":"51355","over":"7","ball":"4","score":1,"commentary":"Bryony Smith to Cordelia Griffith, 1 run,","noball_dismissal":false,"text":"","timestamp":1751811410,"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":"12294511","event":"ball","batsman_id":"96091","bowler_id":"51355","over":"7","ball":"5","score":1,"commentary":"Bryony Smith to Madeline Penna, 1 run,","noball_dismissal":false,"text":"","timestamp":1751811414,"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":"12294513","event":"ball","batsman_id":"51465","bowler_id":"51355","over":"7","ball":"6","score":4,"commentary":"Bryony Smith to Cordelia Griffith, Four,","noball_dismissal":false,"text":"","timestamp":1751811419,"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":8,"runs":10,"score":"75\/2","bats":[{"runs":12,"balls_faced":6,"fours":2,"sixes":0,"batsman_id":51465},{"runs":12,"balls_faced":13,"fours":1,"sixes":0,"batsman_id":96091}],"bowls":[{"runs_conceded":15,"maidens":0,"wickets":0,"bowler_id":51355,"overs":2},{"runs_conceded":12,"maidens":0,"wickets":2,"bowler_id":58700,"overs":2}],"commentary":"End of over 8 (10 runs), Essex Women 75\/2"},{"event_id":"12294525","event":"ball","batsman_id":"96091","bowler_id":"51920","over":"8","ball":"1","score":4,"commentary":"Phoebe Franklin to Madeline Penna, Four,","noball_dismissal":false,"text":"","timestamp":1751811422,"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":"12294527","event":"ball","batsman_id":"96091","bowler_id":"51920","over":"8","ball":"2","score":0,"commentary":"Phoebe Franklin to Madeline Penna, no run,","noball_dismissal":false,"text":"","timestamp":1751811429,"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":"12294529","event":"ball","batsman_id":"96091","bowler_id":"51920","over":"8","ball":"3","score":4,"commentary":"Phoebe Franklin to Madeline Penna, Four,","noball_dismissal":false,"text":"","timestamp":1751811432,"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":"12294530","event":"ball","batsman_id":"96091","bowler_id":"51920","over":"8","ball":"4","score":1,"commentary":"Phoebe Franklin to Madeline Penna, 1 run,","noball_dismissal":false,"text":"","timestamp":1751811436,"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":"12294533","event":"ball","batsman_id":"51465","bowler_id":"51920","over":"8","ball":"5","score":1,"commentary":"Phoebe Franklin to Cordelia Griffith, 1 run,","noball_dismissal":false,"text":"","timestamp":1751811439,"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":"12294535","event":"ball","batsman_id":"96091","bowler_id":"51920","over":"8","ball":"6","score":1,"commentary":"Phoebe Franklin to Madeline Penna, 1 run,","noball_dismissal":false,"text":"","timestamp":1751811786,"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":9,"runs":11,"score":"86\/2","bats":[{"runs":22,"balls_faced":18,"fours":3,"sixes":0,"batsman_id":96091},{"runs":13,"balls_faced":7,"fours":2,"sixes":0,"batsman_id":51465}],"bowls":[{"runs_conceded":15,"maidens":0,"wickets":0,"bowler_id":51920,"overs":2},{"runs_conceded":15,"maidens":0,"wickets":0,"bowler_id":51355,"overs":2}],"commentary":"End of over 9 (11 runs), Essex Women 86\/2"},{"event_id":"12294630","event":"wicket","batsman_id":"96091","bowler_id":"44682","over":"9","ball":"1","score":"w","commentary":"Grace Harris to Madeline Penna, no run, c PA Franklin b GM Harris,","noball_dismissal":false,"text":"","timestamp":1751811789,"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":"96091","how_out":"c PA Franklin b GM Harris","batsman_runs":"22","batsman_balls":"19"},{"event_id":"12294633","event":"ball","batsman_id":"51436","bowler_id":"44682","over":"9","ball":"2","score":4,"commentary":"Grace Harris to Joanne Gardner, Four,","noball_dismissal":false,"text":"","timestamp":1751811792,"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":"12294636","event":"ball","batsman_id":"51436","bowler_id":"44682","over":"9","ball":"3","score":1,"commentary":"Grace Harris to Joanne Gardner, 1 run,","noball_dismissal":false,"text":"","timestamp":1751811796,"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":"12294656","event":"wicket","batsman_id":"51465","bowler_id":"44682","over":"9","ball":"4","score":"w","commentary":"Grace Harris to Cordelia Griffith, no run, st KM Chathli b GM Harris,","noball_dismissal":false,"text":"","timestamp":1751811798,"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":"51465","how_out":"st KM Chathli b GM Harris","batsman_runs":"13","batsman_balls":"8"},{"event_id":"12294658","event":"ball","batsman_id":"116256","bowler_id":"44682","over":"9","ball":"5","score":1,"commentary":"Grace Harris to Sophia Smale, 1 run,","noball_dismissal":false,"text":"","timestamp":1751811801,"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":"12294672","event":"wicket","batsman_id":"51436","bowler_id":"44682","over":"9","ball":"6","score":"w","commentary":"Grace Harris to Joanne Gardner, 1 run, runout (KM Chathli \/ PA Franklin),","noball_dismissal":false,"text":"","timestamp":1751811819,"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":"51436","how_out":"runout (KM Chathli \/ PA Franklin)","batsman_runs":"6","batsman_balls":"3"},{"event":"overend","over":10,"runs":7,"score":"93\/5","bats":[{"runs":6,"balls_faced":3,"fours":1,"sixes":0,"batsman_id":51436},{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":116256}],"bowls":[{"runs_conceded":22,"maidens":0,"wickets":2,"bowler_id":44682,"overs":2},{"runs_conceded":15,"maidens":0,"wickets":0,"bowler_id":51920,"overs":2}],"commentary":"End of over 10 (7 runs), Essex Women 93\/5"}],"day":"0","session":"0","live_inning":{"iid":199199,"number":2,"name":"Essex Women Inning","short_name":"ESS-W Inning","status":2,"issuperover":"false","result":3,"batting_team_id":19231,"fielding_team_id":19199,"scores":"93\/5","scores_full":"93\/5 (10 ov)","fielder":[{"fielder_id":"44682","fielder_name":"Grace Harris","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"102554","fielder_name":"Danielle Gregory","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"51920","fielder_name":"Phoebe Franklin","catches":1,"runout_thrower":1,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"110319","fielder_name":"Kira Chathli","catches":0,"runout_thrower":0,"runout_catcher":1,"runout_direct_hit":0,"stumping":1,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Joanne Gardner","batsman_id":"51436","runs":"6","balls":"3","how_out":"runout (KM Chathli \/ PA Franklin)","score_at_dismissal":93,"overs_at_dismissal":"9.6","bowler_id":"0","dismissal":"runout","number":5},"extra_runs":{"byes":0,"legbyes":1,"wides":0,"noballs":0,"penalty":"0","total":1},"equations":{"runs":93,"wickets":5,"overs":"10","bowlers_used":6,"runrate":"9.30"},"current_partnership":{"runs":2,"balls":2,"overs":0.2,"batsmen":[{"name":"Sophia Smale","batsman_id":116256,"runs":1,"balls":1},{"name":"Joanne Gardner","batsman_id":51436,"runs":1,"balls":1}]},"did_not_bat":[{"player_id":"51452","name":"Amara Carr"},{"player_id":"51928","name":"Kate Coppack"},{"player_id":"107856","name":"Esmae Macgregor"},{"player_id":"44477","name":"Abtaha Maqsood"},{"player_id":"93882","name":"Eva Gray"}],"max_over":"10","target":"94","recent_scores":"w,1,w,1,4,w,1,1,1,4,0,4,4,1,1,1,1,2","last_five_overs":"49\/4 9.80","last_ten_overs":"93\/5 9.30"},"teams":[{"tid":19199,"title":"Surrey Women","abbr":"SUR-W","alt_name":"SUR-W","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/12\/Surrey-Women.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/12\/Surrey-Women.png","country":"en","sex":"female","team_owner":"","head_coach":"","scores_full":"159\/5 (20 ov)","scores":"159\/5","overs":"20"},{"tid":19231,"title":"Essex Women","abbr":"ESS-W","alt_name":"ESS-W","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2021\/05\/New_Eagles_Logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2021\/05\/New_Eagles_Logo.png","country":"en","sex":"female","team_owner":"","head_coach":"","scores_full":"93\/5 (10 ov)","scores":"93\/5","overs":"10"}],"players":[{"pid":10508,"title":"Lauren Winfield Hill","short_name":"LW Hill","first_name":"Lauren Winfield Hill","last_name":"","middle_name":"","birthdate":"1990-08-16","birthplace":"York, United Kingdom","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":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Lauren_Winfield","instagram_profile":"https:\/\/www.instagram.com\/laurenwinfield58\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":44477,"title":"Abtaha Maqsood","short_name":"AM Maqsood","first_name":"Abtaha Maqsood","last_name":"","middle_name":"","birthdate":"1999-06-11","birthplace":"Glasgow","country":"sct","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/abtaha_m","instagram_profile":"https:\/\/www.instagram.com\/abtaha_m\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Scotland","role":"bowl","role_str":""},{"pid":44682,"title":"Grace Harris","short_name":"GM Harris","first_name":"Grace Harris","last_name":"","middle_name":"","birthdate":"1993-09-18","birthplace":"Ipswich, Australia","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/189Grace","instagram_profile":"https:\/\/www.instagram.com\/graceh_189","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Australia","role":"all","role_str":""},{"pid":44766,"title":"Danielle Wyatt","short_name":"DN Wyatt","first_name":"Danielle Wyatt","last_name":"","middle_name":"","birthdate":"1991-04-22","birthplace":"Stoke-on-Trent, Staffordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Danni_Wyatt","instagram_profile":"https:\/\/www.instagram.com\/danniwyatt28\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":44775,"title":"Tash Farrant","short_name":"NE Farrant","first_name":"Tash Farrant","last_name":"","middle_name":"","birthdate":"1996-05-29","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51355,"title":"Bryony Smith","short_name":"BF Smith","first_name":"Bryony Smith","last_name":"","middle_name":"","birthdate":"1997-12-12","birthplace":"Sutton, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/CranioSacralScotland\/","twitter_profile":"https:\/\/twitter.com\/BrySmith97","instagram_profile":"https:\/\/www.instagram.com\/bryonysmith97\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"pid":51366,"title":"Paige Scholfield","short_name":"PJ Scholfield","first_name":"Paige Scholfield","last_name":"","middle_name":"","birthdate":"1995-12-19","birthplace":"Durban, South Africa","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/PaigeSchol","instagram_profile":"https:\/\/www.instagram.com\/paigescholf\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51436,"title":"Joanne Gardner","short_name":"J Gardner","first_name":"Joanne Gardner","last_name":"","middle_name":"","birthdate":"1997-03-25","birthplace":"Newport, Isle of Wight","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/JoGardner_14","instagram_profile":"https:\/\/www.instagram.com\/jogardner_14\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":51452,"title":"Amara Carr","short_name":"AD Carr","first_name":"Amara Carr","last_name":"","middle_name":"","birthdate":"1994-04-17","birthplace":"Plymouth, Devon","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/amara_carr\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":""},{"pid":51453,"title":"Aylish Cranstone","short_name":"A Cranstone","first_name":"Aylish Cranstone","last_name":"","middle_name":"","birthdate":"1994-08-28","birthplace":"Guildford, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/AylishCranstone","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51465,"title":"Cordelia Griffith","short_name":"CL Griffith","first_name":"Cordelia Griffith","last_name":"","middle_name":"","birthdate":"1995-09-19","birthplace":"Islington, London","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/cordeliagriff","instagram_profile":"https:\/\/www.instagram.com\/cordelia_griffith\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":51471,"title":"Kelly Castle","short_name":"KS Castle","first_name":"Kelly Castle","last_name":"","middle_name":"","birthdate":"1997-09-04","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":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51480,"title":"Alice Davidson-Richards","short_name":"AN Davidson-Richards","first_name":"Alice Davidson-Richards","last_name":"","middle_name":"","birthdate":"1994-05-29","birthplace":"Tunbridge Wells, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/alice.davidsonrichards\/","twitter_profile":"https:\/\/twitter.com\/alicedr24","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":51739,"title":"Sophia Dunkley","short_name":"SIR Dunkley","first_name":"Sophia Dunkley","last_name":"","middle_name":"","birthdate":"1998-07-16","birthplace":" Lambeth, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/dunkleysophia","instagram_profile":"https:\/\/www.instagram.com\/sophiadunkley\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51793,"title":"Alice Macleod","short_name":"AJ Macleod","first_name":"Alice Macleod","last_name":"","middle_name":"","birthdate":"1994-05-14","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":51920,"title":"Phoebe Franklin","short_name":"PA Franklin","first_name":"Phoebe Franklin","last_name":"","middle_name":"","birthdate":"1998-02-18","birthplace":"Greenwich, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/phoebe.franklin\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":51928,"title":"Kate Coppack","short_name":"KL Coppack","first_name":"Kate Coppack","last_name":"","middle_name":"","birthdate":"1994-08-30","birthplace":"Chester, Cheshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/copsshots\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":58700,"title":"Priyanaz Chatterji","short_name":"PA Chatterji","first_name":"Priyanaz Chatterji","last_name":"","middle_name":"","birthdate":"1993-08-12","birthplace":"Dundee, Angus, Scotland","country":"sct","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":"https:\/\/twitter.com\/priyanazc","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Scotland","role":"bat","role_str":""},{"pid":93878,"title":"Alice Monaghan","short_name":"AZ Monaghan","first_name":"Alice Monaghan","last_name":"","middle_name":"","birthdate":"2000-03-20","birthplace":" Basingstoke, Hampshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/alicemonaghan_\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":93882,"title":"Eva Gray","short_name":"E Gray","first_name":"Eva Gray","last_name":"","middle_name":"","birthdate":"2000-05-24","birthplace":"Surrey, England","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/evagray134","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":"(C)"},{"pid":93927,"title":"Sophie Munro","short_name":"S Munro","first_name":"Sophie Munro","last_name":"","middle_name":"","birthdate":"2001-08-31","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":96091,"title":"Madeline Penna","short_name":"M Penna","first_name":"Madeline Penna","last_name":"","middle_name":"","birthdate":"2000-08-30","birthplace":"","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Australia","role":"all","role_str":""},{"pid":102552,"title":"Alice Capsey","short_name":"A Capsey","first_name":"Alice Capsey","last_name":"","middle_name":"","birthdate":"2004-08-11","birthplace":" Redhill, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/AliceCapsey","instagram_profile":"https:\/\/www.instagram.com\/alicecapsey_\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":102554,"title":"Danielle Gregory","short_name":"D Gregory","first_name":"Danielle Gregory","last_name":"","middle_name":"","birthdate":"1998-12-04","birthplace":" Frimley, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","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":9,"facebook_profile":"https:\/\/www.facebook.com\/grace.scrivens\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/graciescriv\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":102780,"title":"Ariana Dowse","short_name":"A Dowse","first_name":"Ariana Dowse","last_name":"","middle_name":"","birthdate":"2001-02-08","birthplace":"","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":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":107856,"title":"Esmae Macgregor","short_name":"E Macgregor","first_name":"Esmae Macgregor","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":107860,"title":"Madeleine Blinkhorn Jones","short_name":"MB Jones","first_name":"Madeleine Blinkhorn 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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","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":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/AlexaStonehouse","instagram_profile":"https:\/\/www.instagram.com\/alexa_stonehouse","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":109739,"title":"Florence Miller","short_name":"Florence Miller","first_name":"Florence Miller","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":110319,"title":"Kira Chathli","short_name":"KM Chathli","first_name":"Kira Chathli","last_name":"","middle_name":"","birthdate":"1999-07-29","birthplace":"Southwark, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper ","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/kira_chathli\/with_replies","instagram_profile":"https:\/\/www.instagram.com\/kira_chathli\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":110320,"title":"Kalea Moore","short_name":"K Moore","first_name":"Kalea Moore","last_name":"","middle_name":"","birthdate":"2003-03-27","birthplace":" Greenwich, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/KallyM27","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":110338,"title":"Ryana Macdonald-Gay","short_name":"R Macdonald-Gay","first_name":"Ryana Macdonald-Gay","last_name":"","middle_name":"","birthdate":"2004-02-12","birthplace":"Maidstone, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":116256,"title":"Sophia Smale","short_name":"SAE Smale","first_name":"Sophia Smale","last_name":"","middle_name":"","birthdate":"2004-12-08","birthplace":"Newport, Monmouthshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/sophiasmale","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":119593,"title":"Jemima Spence","short_name":"J Spence","first_name":"Jemima Spence","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":123129,"title":"Charlotte Lambert","short_name":"C Lambert","first_name":"Charlotte Lambert","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":128842,"title":"Emily Burke","short_name":"E Burke","first_name":"Emily Burke","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":129018,"title":"Bethan Miles","short_name":"B Miles","first_name":"Bethan Miles","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":137960,"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":"","bowling_type":"","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":141144,"title":"Rachel King","short_name":"R King","first_name":"Rachel King","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""}]},"etag":"7c6a35051320504d804279dfa5e010aa","modified":"2025-07-15 10:27:43","datetime":"2025-07-15 10:27:43","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90349 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:dd8fd2f0-368f-4b7c-884e-2f3ac85f62b6
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90349 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90349,3,'{"status":"ok","response":{"match_id":90349,"title":"Surrey Women vs Essex Women","short_title":"SUR-W vs ESS-W","subtitle":"Match 40","match_number":"40","format":8,"format_str":"Women T20","status":2,"status_str":"Completed","status_note":"Match Tie (DLS method)","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129426,"title":"Vitality Blast Women","abbr":"Vitality Blast Women ","type":"tournament","category":"women","match_format":"woment20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-07-27","country":"en","total_matches":"57","total_rounds":"2","total_teams":"15"},"teama":{"team_id":19199,"name":"Surrey Women","short_name":"SUR-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/12\/Surrey-Women.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/12\/Surrey-Women.png","scores_full":"159\/5 (20 ov)","scores":"159\/5","overs":"20"},"teamb":{"team_id":19231,"name":"Essex Women","short_name":"ESS-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2021\/05\/New_Eagles_Logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2021\/05\/New_Eagles_Logo.png","scores_full":"93\/5 (10 ov)","scores":"93\/5","overs":"10"},"date_start":"2025-07-06 11:00:00","date_end":"2025-07-06 21:00:00","timestamp_start":1751799600,"timestamp_end":1751835600,"date_start_ist":"2025-07-06 16:30:00","date_end_ist":"2025-07-07 02:30:00","venue":{"venue_id":"3","name":"Kennington Oval","location":"London","country":"England","timezone":""},"umpires":"Neil Bainton (England), Gabi Brown (England)","referee":"Peter Such (England)","equation":"Match Tie (DLS method)","live":"","result":"Match Tie (DLS method)","result_type":5,"win_margin":"","winning_team_id":0,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-07-04 20:42:31","verify_time":"2025-07-06 20:23:56","match_dls_affected":"true","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"broken clouds","temp":20.78,"humidity":76,"visibility":10000,"wind_speed":"8.70","clouds":66},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Essex Women elected to bowl","winner":19231,"decision":2}},"etag":"1d044afaf741405234f4f39bb303d205","modified":"2025-07-15 10:27:44","datetime":"2025-07-15 10:27:44","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":90349,"title":"Surrey Women vs Essex Women","short_title":"SUR-W vs ESS-W","subtitle":"Match 40","match_number":"40","format":8,"format_str":"Women T20","status":2,"status_str":"Completed","status_note":"Match Tie (DLS method)","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129426,"title":"Vitality Blast Women","abbr":"Vitality Blast Women ","type":"tournament","category":"women","match_format":"woment20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-07-27","country":"en","total_matches":"57","total_rounds":"2","total_teams":"15"},"teama":{"team_id":19199,"name":"Surrey Women","short_name":"SUR-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/12\/Surrey-Women.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/12\/Surrey-Women.png","scores_full":"159\/5 (20 ov)","scores":"159\/5","overs":"20"},"teamb":{"team_id":19231,"name":"Essex Women","short_name":"ESS-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2021\/05\/New_Eagles_Logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2021\/05\/New_Eagles_Logo.png","scores_full":"93\/5 (10 ov)","scores":"93\/5","overs":"10"},"date_start":"2025-07-06 11:00:00","date_end":"2025-07-06 21:00:00","timestamp_start":1751799600,"timestamp_end":1751835600,"date_start_ist":"2025-07-06 16:30:00","date_end_ist":"2025-07-07 02:30:00","venue":{"venue_id":"3","name":"Kennington Oval","location":"London","country":"England","timezone":""},"umpires":"Neil Bainton (England), Gabi Brown (England)","referee":"Peter Such (England)","equation":"Match Tie (DLS method)","live":"","result":"Match Tie (DLS method)","result_type":5,"win_margin":"","winning_team_id":0,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-07-04 20:42:31","verify_time":"2025-07-06 20:23:56","match_dls_affected":"true","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"broken clouds","temp":20.78,"humidity":76,"visibility":10000,"wind_speed":"8.70","clouds":66},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Essex Women elected to bowl","winner":19231,"decision":2}},"etag":"1d044afaf741405234f4f39bb303d205","modified":"2025-07-15 10:27:44","datetime":"2025-07-15 10:27:44","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90349 AND DataTypeId = 3 END Live Report & Scorecard of Surrey Women vs Essex Women Match 40
Surrey Women vs Essex Women, Live Cricket Commentary