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:03648afc-8a8e-465e-952b-89d9cda61fe5 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90240 AND DataTypeId = 2) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90240,2,'{"status":"ok","response":{"match_id":90240,"title":"Hampshire Women vs Durham Women","short_title":"HAM-W vs DUR-W","subtitle":"Match 14","match_number":"14","format":8,"format_str":"Women T20","status":2,"status_str":"Completed","status_note":"Durham Women won by 1 run (DLS method)","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129426,"title":"Vitality Blast Women","abbr":"Vitality Blast Women ","type":"tournament","category":"women","match_format":"woment20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-07-27","country":"en","total_matches":"57","total_rounds":"2","total_teams":"15"},"teama":{"team_id":19277,"name":"Hampshire Women","short_name":"HAM-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/12\/Hampshire-Women.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/12\/Hampshire-Women.png","scores_full":"33\/2 (6 ov)","scores":"33\/2","overs":"6"},"teamb":{"team_id":19270,"name":"Durham Women","short_name":"DUR-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/09\/Rectangle-3493-25.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/09\/Rectangle-3493-25.png","scores_full":"119\/6 (20 ov)","scores":"119\/6","overs":"20"},"date_start":"2025-06-07 13:30:00","date_end":"2025-06-07 23:30:00","timestamp_start":1749303000,"timestamp_end":1749339000,"date_start_ist":"2025-06-07 19:00:00","date_end_ist":"2025-06-08 05:00:00","venue":{"venue_id":"56","name":"Arundel Castle Cricket Club Ground","location":"Arundel","country":"England","timezone":""},"umpires":"","referee":"","equation":"","live":"","result":"DUR-W won by 1 run (DLS method)","result_type":2,"win_margin":"1 run (DLS method)","winning_team_id":19270,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-06 17:00:22","verify_time":"2025-06-07 22:43:42","match_dls_affected":"true","live_inning_number":"","day":"0","session":"0","weather":{"weather":"","weather_desc":"","temp":"","humidity":"","visibility":"","wind_speed":"","clouds":""},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Hampshire Women elected to bowl","winner":19277,"decision":2},"current_over":"","previous_over":"","man_of_the_match":"","man_of_the_series":"","is_followon":0,"team_batting_first":"","team_batting_second":"","last_five_overs":"","innings":[{"iid":197606,"number":1,"name":"Durham Women Inning","short_name":"DUR-W Inning","status":2,"issuperover":"false","result":4,"batting_team_id":19270,"fielding_team_id":19277,"scores":"119\/6","scores_full":"119\/6 (20 ov)","batsmen":[{"name":"Suzie Bates","batsman_id":"44247","batting":"false","position":"","role":"bat","role_str":"","runs":"34","balls_faced":"33","fours":"4","sixes":"0","run0":"14","run1":"12","run2":"3","run3":"0","run5":"0","how_out":"st RM Southby b R Tyson","dismissal":"stumped","strike_rate":"103.03","bowler_id":"51502","first_fielder_id":"61327","second_fielder_id":"","third_fielder_id":""},{"name":"Katherine Fraser","batsman_id":"95778","batting":"false","position":"","role":"bowl","role_str":"","runs":"4","balls_faced":"10","fours":"0","sixes":"0","run0":"7","run1":"2","run2":"1","run3":"0","run5":"0","how_out":"c F Kemp b FR Davies","dismissal":"caught","strike_rate":"40.00","bowler_id":"51734","first_fielder_id":"102782","second_fielder_id":"","third_fielder_id":""},{"name":"Hollie Armitage","batsman_id":"58162","batting":"false","position":"","role":"bat","role_str":"(C)","runs":"18","balls_faced":"23","fours":"1","sixes":"0","run0":"10","run1":"10","run2":"2","run3":"0","run5":"0","how_out":"b M Taylor","dismissal":"bowled","strike_rate":"78.26","bowler_id":"107883","first_fielder_id":"","second_fielder_id":"","third_fielder_id":""},{"name":"Mady Villiers","batsman_id":"51467","batting":"false","position":"","role":"all","role_str":"","runs":"14","balls_faced":"14","fours":"1","sixes":"0","run0":"2","run1":"10","run2":"0","run3":"0","run5":"0","how_out":"c ME Bouchier b C Knott","dismissal":"caught","strike_rate":"100.00","bowler_id":"85320","first_fielder_id":"61333","second_fielder_id":"","third_fielder_id":""},{"name":"Bess Heath","batsman_id":"51911","batting":"true","position":"non striker","role":"wk","role_str":"(WK)","runs":"29","balls_faced":"24","fours":"0","sixes":"1","run0":"4","run1":"15","run2":"4","run3":"0","run5":"0","how_out":"Not out","dismissal":"","strike_rate":"120.83","bowler_id":"0","first_fielder_id":"","second_fielder_id":"","third_fielder_id":""},{"name":"Abigail Glen","batsman_id":"116260","batting":"false","position":"","role":"all","role_str":"","runs":"5","balls_faced":"6","fours":"0","sixes":"0","run0":"2","run1":"3","run2":"1","run3":"0","run5":"0","how_out":"st RM Southby b R Tyson","dismissal":"stumped","strike_rate":"83.33","bowler_id":"51502","first_fielder_id":"61327","second_fielder_id":"","third_fielder_id":""},{"name":"Emma Marlow","batsman_id":"116259","batting":"true","position":"striker","role":"bat","role_str":"","runs":"8","balls_faced":"11","fours":"1","sixes":"0","run0":"7","run1":"2","run2":"1","run3":"0","run5":"0","how_out":"b FR Davies","dismissal":"bowled","strike_rate":"72.73","bowler_id":"51734","first_fielder_id":"","second_fielder_id":"","third_fielder_id":""}],"bowlers":[{"name":"Freya Davies","bowler_id":"51734","bowling":"true","position":"active bowler","overs":"4","maidens":"0","runs_conceded":"20","wickets":"2","noballs":"0","wides":"1","econ":"5.00","run0":"11","bowledcount":"1","lbwcount":"0"},{"name":"Daisy Gibb","bowler_id":"107886","bowling":"false","position":"","overs":"2","maidens":"0","runs_conceded":"5","wickets":"0","noballs":"0","wides":"0","econ":"2.50","run0":"7","bowledcount":"0","lbwcount":"0"},{"name":"Rebecca Tyson","bowler_id":"51502","bowling":"false","position":"","overs":"4","maidens":"0","runs_conceded":"28","wickets":"2","noballs":"0","wides":"0","econ":"7.00","run0":"10","bowledcount":"0","lbwcount":"0"},{"name":"Charli Knott","bowler_id":"85320","bowling":"false","position":"last bowler","overs":"4","maidens":"0","runs_conceded":"22","wickets":"1","noballs":"0","wides":"0","econ":"5.50","run0":"10","bowledcount":"0","lbwcount":"0"},{"name":"Mary Taylor","bowler_id":"107883","bowling":"false","position":"","overs":"2","maidens":"0","runs_conceded":"13","wickets":"1","noballs":"0","wides":"2","econ":"6.50","run0":"5","bowledcount":"1","lbwcount":"0"},{"name":"Georgia Adams","bowler_id":"51733","bowling":"false","position":"","overs":"4","maidens":"0","runs_conceded":"28","wickets":"0","noballs":"0","wides":"1","econ":"7.00","run0":"4","bowledcount":"0","lbwcount":"0"}],"fielder":[{"fielder_id":"61327","fielder_name":"Rhianna Southby","catches":0,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":2,"is_substitute":"false"},{"fielder_id":"102782","fielder_name":"Freya Kemp","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"61333","fielder_name":"Maia Bouchier","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"fows":[{"name":"Katherine Fraser","batsman_id":"95778","runs":"4","balls":"10","how_out":"c F Kemp b FR Davies","score_at_dismissal":24,"overs_at_dismissal":"4.1","bowler_id":"51734","dismissal":"caught","number":1},{"name":"Suzie Bates","batsman_id":"44247","runs":"34","balls":"33","how_out":"st RM Southby b R Tyson","score_at_dismissal":54,"overs_at_dismissal":"9.2","bowler_id":"51502","dismissal":"stumped","number":2},{"name":"Hollie Armitage","batsman_id":"58162","runs":"18","balls":"23","how_out":"b M Taylor","score_at_dismissal":68,"overs_at_dismissal":"11.4","bowler_id":"107883","dismissal":"bowled","number":3},{"name":"Mady Villiers","batsman_id":"51467","runs":"14","balls":"14","how_out":"c ME Bouchier b C Knott","score_at_dismissal":84,"overs_at_dismissal":"14.3","bowler_id":"85320","dismissal":"caught","number":4},{"name":"Abigail Glen","batsman_id":"116260","runs":"5","balls":"6","how_out":"st RM Southby b R Tyson","score_at_dismissal":92,"overs_at_dismissal":"16.1","bowler_id":"51502","dismissal":"stumped","number":5},{"name":"Emma Marlow","batsman_id":"116259","runs":"8","balls":"11","how_out":"b FR Davies","score_at_dismissal":119,"overs_at_dismissal":"19.6","bowler_id":"51734","dismissal":"bowled","number":6}],"last_wicket":{"name":"Emma Marlow","batsman_id":"116259","runs":"8","balls":"11","how_out":"b FR Davies","score_at_dismissal":119,"overs_at_dismissal":"19.6","bowler_id":"51734","dismissal":"bowled","number":6},"extra_runs":{"byes":1,"legbyes":2,"wides":4,"noballs":0,"penalty":"0","total":7},"equations":{"runs":119,"wickets":6,"overs":"20","bowlers_used":6,"runrate":"5.95"},"current_partnership":{"runs":27,"balls":23,"overs":3.5,"batsmen":[{"name":"Emma Marlow","batsman_id":116259,"runs":8,"balls":11},{"name":"Bess Heath","batsman_id":51911,"runs":19,"balls":12}]},"did_not_bat":[{"player_id":"116258","name":"Phoebe Turner"},{"player_id":"137961","name":"Trudy Johnson"},{"player_id":"146141","name":"Grace Thompson"},{"player_id":"51493","name":"Katie Levick"}],"max_over":"20","target":"0"},{"iid":197616,"number":2,"name":"Hampshire Women Inning","short_name":"HAM-W Inning","status":2,"issuperover":"false","result":4,"batting_team_id":19277,"fielding_team_id":19270,"scores":"33\/2","scores_full":"33\/2 (6 ov)","batsmen":[{"name":"Maia Bouchier","batsman_id":"61333","batting":"true","position":"non striker","role":"bat","role_str":"","runs":"22","balls_faced":"21","fours":"4","sixes":"0","run0":"11","run1":"6","run2":"0","run3":"0","run5":"0","how_out":"Not out","dismissal":"","strike_rate":"104.76","bowler_id":"0","first_fielder_id":"","second_fielder_id":"","third_fielder_id":""},{"name":"Ella McCaughan","batsman_id":"102764","batting":"false","position":"","role":"bat","role_str":"","runs":"4","balls_faced":"7","fours":"0","sixes":"0","run0":"4","run1":"2","run2":"1","run3":"0","run5":"0","how_out":"c E Marlow b MK Villiers","dismissal":"caught","strike_rate":"57.14","bowler_id":"51467","first_fielder_id":"116259","second_fielder_id":"","third_fielder_id":""},{"name":"Charli Knott","batsman_id":"85320","batting":"false","position":"","role":"all","role_str":"","runs":"0","balls_faced":"1","fours":"0","sixes":"0","run0":"1","run1":"0","run2":"0","run3":"0","run5":"0","how_out":"b KA Levick","dismissal":"bowled","strike_rate":"0.00","bowler_id":"51493","first_fielder_id":"","second_fielder_id":"","third_fielder_id":""},{"name":"Freya Kemp","batsman_id":"102782","batting":"true","position":"striker","role":"all","role_str":"","runs":"4","balls_faced":"8","fours":"0","sixes":"0","run0":"4","run1":"2","run2":"1","run3":"0","run5":"0","how_out":"Not out","dismissal":"","strike_rate":"50.00","bowler_id":"0","first_fielder_id":"","second_fielder_id":"","third_fielder_id":""}],"bowlers":[{"name":"Grace Thompson","bowler_id":"146141","bowling":"true","position":"active bowler","overs":"2","maidens":"0","runs_conceded":"8","wickets":"0","noballs":"0","wides":"2","econ":"4.00","run0":"7","bowledcount":"0","lbwcount":"0"},{"name":"Mady Villiers","bowler_id":"51467","bowling":"false","position":"","overs":"2","maidens":"0","runs_conceded":"13","wickets":"1","noballs":"0","wides":"0","econ":"6.50","run0":"5","bowledcount":"0","lbwcount":"0"},{"name":"Katie Levick","bowler_id":"51493","bowling":"false","position":"","overs":"1","maidens":"0","runs_conceded":"3","wickets":"1","noballs":"0","wides":"0","econ":"3.00","run0":"5","bowledcount":"1","lbwcount":"0"},{"name":"Trudy Johnson","bowler_id":"137961","bowling":"false","position":"last bowler","overs":"1","maidens":"0","runs_conceded":"8","wickets":"0","noballs":"0","wides":"0","econ":"8.00","run0":"4","bowledcount":"0","lbwcount":"0"}],"fielder":[{"fielder_id":"116259","fielder_name":"Emma Marlow","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"fows":[{"name":"Ella McCaughan","batsman_id":"102764","runs":"4","balls":"7","how_out":"c E Marlow b MK Villiers","score_at_dismissal":8,"overs_at_dismissal":"1.6","bowler_id":"51467","dismissal":"caught","number":1},{"name":"Charli Knott","batsman_id":"85320","runs":"0","balls":"1","how_out":"b KA Levick","score_at_dismissal":9,"overs_at_dismissal":"2.3","bowler_id":"51493","dismissal":"bowled","number":2}],"last_wicket":{"name":"Charli Knott","batsman_id":"85320","runs":"0","balls":"1","how_out":"b KA Levick","score_at_dismissal":9,"overs_at_dismissal":"2.3","bowler_id":"51493","dismissal":"bowled","number":2},"extra_runs":{"byes":0,"legbyes":1,"wides":2,"noballs":0,"penalty":"0","total":3},"equations":{"runs":33,"wickets":2,"overs":"6","bowlers_used":4,"runrate":"5.50"},"current_partnership":{"runs":24,"balls":21,"overs":3.3,"batsmen":[{"name":"Freya Kemp","batsman_id":102782,"runs":4,"balls":7},{"name":"Maia Bouchier","batsman_id":61333,"runs":19,"balls":14}]},"did_not_bat":[{"player_id":"51733","name":"Georgia Adams"},{"player_id":"61327","name":"Rhianna Southby"},{"player_id":"90942","name":"Naomi Dattani"},{"player_id":"107883","name":"Mary Taylor"},{"player_id":"51734","name":"Freya Davies"},{"player_id":"107886","name":"Daisy Gibb"},{"player_id":"51502","name":"Rebecca Tyson"}],"max_over":"6","target":"35"}],"players":[{"pid":44247,"title":"Suzie Bates","short_name":"SW Bates","first_name":"Suzie Bates","last_name":"","middle_name":"","birthdate":"1987-09-16","birthplace":"Dunedin, Otago","country":"nz","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/SuzieWBates","instagram_profile":"https:\/\/www.instagram.com\/suziebates\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bat","role_str":""},{"pid":44686,"title":"Ellyse Perry","short_name":"EA Perry","first_name":"Ellyse Perry","last_name":"","middle_name":"","birthdate":"1990-11-03","birthplace":"Wahroonga, Sydney, New South Wales","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/ellyseperryofficial\/","twitter_profile":"https:\/\/twitter.com\/EllysePerry","instagram_profile":"https:\/\/www.instagram.com\/ellyseperry\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":51467,"title":"Mady Villiers","short_name":"MK Villiers","first_name":"Mady Villiers","last_name":"","middle_name":"","birthdate":"1998-08-26","birthplace":" Havering, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/mady.villiers\/","twitter_profile":"https:\/\/twitter.com\/VilliersMady","instagram_profile":"https:\/\/www.instagram.com\/madyvilliers\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":51493,"title":"Katie Levick","short_name":"KA Levick","first_name":"Katie Levick","last_name":"","middle_name":"","birthdate":"1991-07-17","birthplace":"Sheffield, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Katie_Lev","instagram_profile":"https:\/\/www.instagram.com\/katie_lev\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":51502,"title":"Rebecca Tyson","short_name":"R Tyson","first_name":"Rebecca Tyson","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":51656,"title":"Linsey Smith","short_name":"LCN Smith","first_name":"Linsey Smith","last_name":"","middle_name":"","birthdate":"1995-03-10","birthplace":"Hillingdon, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/LinseySmith95","instagram_profile":"https:\/\/www.instagram.com\/linseysm\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51663,"title":"Lauren Bell","short_name":"LK Bell","first_name":"Lauren Bell","last_name":"","middle_name":"","birthdate":"2001-01-02","birthplace":" Swindon, Wiltshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/_laurenbell2","instagram_profile":"https:\/\/www.instagram.com\/l.belll_\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51672,"title":"Emily Windsor","short_name":"EL Windsor","first_name":"Emily Windsor","last_name":"","middle_name":"","birthdate":"1997-09-14","birthplace":"Portsmouth","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/emzwinsa","instagram_profile":"https:\/\/www.instagram.com\/emzwinsa\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51733,"title":"Georgia Adams","short_name":"GL Adams","first_name":"Georgia Adams","last_name":"","middle_name":"","birthdate":"1993-10-04","birthplace":" Chesterfield, Derbyshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/GeorgiaAdams01","instagram_profile":"https:\/\/www.instagram.com\/gadams01\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":"(C)"},{"pid":51734,"title":"Freya Davies","short_name":"FR Davies","first_name":"Freya Davies","last_name":"","middle_name":"","birthdate":"1995-10-27","birthplace":"Chichester, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/FreyaRuth","instagram_profile":"https:\/\/www.instagram.com\/freyaruth\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":51911,"title":"Bess Heath","short_name":"BAM Heath","first_name":"Bess Heath","last_name":"","middle_name":"","birthdate":"2001-08-20","birthplace":"Chesterfield, Derbyshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/bess.heath\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/bessy.10\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":58162,"title":"Hollie Armitage","short_name":"H Armitage","first_name":"Hollie Armitage","last_name":"","middle_name":"","birthdate":"1997-06-14","birthplace":"Huddersfield, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/holliearmo\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"pid":61327,"title":"Rhianna Southby","short_name":"RM Southby","first_name":"Rhianna Southby","last_name":"","middle_name":"","birthdate":"2000-08-16","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper ","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/rhianna_southby","instagram_profile":"https:\/\/www.instagram.com\/rhianna_southby\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":61333,"title":"Maia Bouchier","short_name":"ME Bouchier","first_name":"Maia Bouchier","last_name":"","middle_name":"","birthdate":"1998-12-05","birthplace":"Kensington, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/maia.bouchier.5\/","twitter_profile":"https:\/\/twitter.com\/maiabouchier","instagram_profile":"https:\/\/www.instagram.com\/maiabouchier\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":85320,"title":"Charli Knott","short_name":"C Knott","first_name":"Charli Knott","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"all","role_str":""},{"pid":90942,"title":"Naomi Dattani","short_name":"ND Dattani","first_name":"Naomi Dattani","last_name":"","middle_name":"","birthdate":"1994-04-28","birthplace":"Ealing, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/NaomiDattani","instagram_profile":"https:\/\/www.instagram.com\/naomi.dattani\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":95778,"title":"Katherine Fraser","short_name":"K Fraser","first_name":"Katherine Fraser","last_name":"","middle_name":"","birthdate":"2005-04-09","birthplace":"","country":"sct","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Scotland","role":"bowl","role_str":""},{"pid":102557,"title":"Lauren Filer","short_name":"L Filer","first_name":"Lauren Filer","last_name":"","middle_name":"","birthdate":"2000-12-22","birthplace":" Bristol","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/laurenfiler14","instagram_profile":"https:\/\/www.instagram.com\/lauren_filer\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":102764,"title":"Ella McCaughan","short_name":"E McCaughan","first_name":"Ella McCaughan","last_name":"","middle_name":"","birthdate":"2002-09-26","birthplace":"Southampton, Hampshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/ella_mccaughan","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":102766,"title":"Nancy Harman","short_name":"N Harman","first_name":"Nancy Harman","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":102768,"title":"Sophia Turner","short_name":"S Turner","first_name":"Sophia Turner","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":102782,"title":"Freya Kemp","short_name":"F Kemp","first_name":"Freya Kemp","last_name":"","middle_name":"","birthdate":"2005-04-21","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/KempFreya","instagram_profile":"https:\/\/www.instagram.com\/freyagkemp\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":102803,"title":"Leah Dobson","short_name":"L Dobson","first_name":"Leah Dobson","last_name":"","middle_name":"","birthdate":"2001-10-06","birthplace":"Scarborough, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/_leahdobson","instagram_profile":"https:\/\/www.instagram.com\/leah__dobson\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":103050,"title":"Mia Rogers","short_name":"M Rogers","first_name":"Mia Rogers","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":107871,"title":"Megan Sturge","short_name":"M Sturge","first_name":"Megan Sturge","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":107883,"title":"Mary Taylor","short_name":"M Taylor","first_name":"Mary Taylor","last_name":"","middle_name":"","birthdate":"2004-10-07","birthplace":"Eastbourne, England","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":107886,"title":"Daisy Gibb","short_name":"D Gibb","first_name":"Daisy Gibb","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":110339,"title":"Daisy Mullan","short_name":"D Mullan","first_name":"Daisy Mullan","last_name":"","middle_name":"","birthdate":"2002-11-29","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":116258,"title":"Phoebe Turner","short_name":"P Turner","first_name":"Phoebe Turner","last_name":"","middle_name":"","birthdate":"2003-08-08","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":116259,"title":"Emma Marlow","short_name":"E Marlow","first_name":"Emma Marlow","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":116260,"title":"Abigail Glen","short_name":"A Glen","first_name":"Abigail Glen","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":119591,"title":"Lizzie Scott","short_name":"LE Scott","first_name":"Lizzie Scott","last_name":"","middle_name":"","birthdate":"2004-09-01","birthplace":" Hexham, Northumberland","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lizziescott04","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":128845,"title":"Ava Lee","short_name":"A Lee","first_name":"Ava Lee","last_name":"","middle_name":"","birthdate":"2005-08-26","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":128846,"title":"Abi Norgrove","short_name":"A Norgrove","first_name":"Abi Norgrove","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":137961,"title":"Trudy Johnson","short_name":"T Johnson","first_name":"Trudy Johnson","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":139765,"title":"Poppy G Tulloch","short_name":"P Tulloch","first_name":"Poppy G Tulloch","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":146141,"title":"Grace Thompson","short_name":"Grace Thompson","first_name":"Grace Thompson","last_name":"","middle_name":"","birthdate":"2007-05-30","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""}],"pre_match_odds":[],"day_remaining_over":"","match_notes":[["Durham Women inning 1","Powerplay 1 (0.1 - 6) Run 35, wicket 1","Durham Women: 50 runs in 8.3 overs.","Durham Women: 100 runs in 17.2 overs.","Innings Break: Durham Women - 119\/6 overs 20 (balls 120)."],["Hampshire Women inning 2","Powerplay 1 (0.1 - 6) Run 33, wicket 2"]]},"etag":"50d5c213070d9656c3da6639316b34b9","modified":"2025-06-25 23:31:19","datetime":"2025-06-25 23:31:19","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":90240,"title":"Hampshire Women vs Durham Women","short_title":"HAM-W vs DUR-W","subtitle":"Match 14","match_number":"14","format":8,"format_str":"Women T20","status":2,"status_str":"Completed","status_note":"Durham Women won by 1 run (DLS method)","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129426,"title":"Vitality Blast Women","abbr":"Vitality Blast Women ","type":"tournament","category":"women","match_format":"woment20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-07-27","country":"en","total_matches":"57","total_rounds":"2","total_teams":"15"},"teama":{"team_id":19277,"name":"Hampshire Women","short_name":"HAM-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/12\/Hampshire-Women.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/12\/Hampshire-Women.png","scores_full":"33\/2 (6 ov)","scores":"33\/2","overs":"6"},"teamb":{"team_id":19270,"name":"Durham Women","short_name":"DUR-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/09\/Rectangle-3493-25.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/09\/Rectangle-3493-25.png","scores_full":"119\/6 (20 ov)","scores":"119\/6","overs":"20"},"date_start":"2025-06-07 13:30:00","date_end":"2025-06-07 23:30:00","timestamp_start":1749303000,"timestamp_end":1749339000,"date_start_ist":"2025-06-07 19:00:00","date_end_ist":"2025-06-08 05:00:00","venue":{"venue_id":"56","name":"Arundel Castle Cricket Club Ground","location":"Arundel","country":"England","timezone":""},"umpires":"","referee":"","equation":"","live":"","result":"DUR-W won by 1 run (DLS method)","result_type":2,"win_margin":"1 run (DLS method)","winning_team_id":19270,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-06 17:00:22","verify_time":"2025-06-07 22:43:42","match_dls_affected":"true","live_inning_number":"","day":"0","session":"0","weather":{"weather":"","weather_desc":"","temp":"","humidity":"","visibility":"","wind_speed":"","clouds":""},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Hampshire Women elected to bowl","winner":19277,"decision":2},"current_over":"","previous_over":"","man_of_the_match":"","man_of_the_series":"","is_followon":0,"team_batting_first":"","team_batting_second":"","last_five_overs":"","innings":[{"iid":197606,"number":1,"name":"Durham Women Inning","short_name":"DUR-W Inning","status":2,"issuperover":"false","result":4,"batting_team_id":19270,"fielding_team_id":19277,"scores":"119\/6","scores_full":"119\/6 (20 ov)","batsmen":[{"name":"Suzie Bates","batsman_id":"44247","batting":"false","position":"","role":"bat","role_str":"","runs":"34","balls_faced":"33","fours":"4","sixes":"0","run0":"14","run1":"12","run2":"3","run3":"0","run5":"0","how_out":"st RM Southby b R Tyson","dismissal":"stumped","strike_rate":"103.03","bowler_id":"51502","first_fielder_id":"61327","second_fielder_id":"","third_fielder_id":""},{"name":"Katherine Fraser","batsman_id":"95778","batting":"false","position":"","role":"bowl","role_str":"","runs":"4","balls_faced":"10","fours":"0","sixes":"0","run0":"7","run1":"2","run2":"1","run3":"0","run5":"0","how_out":"c F Kemp b FR Davies","dismissal":"caught","strike_rate":"40.00","bowler_id":"51734","first_fielder_id":"102782","second_fielder_id":"","third_fielder_id":""},{"name":"Hollie Armitage","batsman_id":"58162","batting":"false","position":"","role":"bat","role_str":"(C)","runs":"18","balls_faced":"23","fours":"1","sixes":"0","run0":"10","run1":"10","run2":"2","run3":"0","run5":"0","how_out":"b M Taylor","dismissal":"bowled","strike_rate":"78.26","bowler_id":"107883","first_fielder_id":"","second_fielder_id":"","third_fielder_id":""},{"name":"Mady Villiers","batsman_id":"51467","batting":"false","position":"","role":"all","role_str":"","runs":"14","balls_faced":"14","fours":"1","sixes":"0","run0":"2","run1":"10","run2":"0","run3":"0","run5":"0","how_out":"c ME Bouchier b C Knott","dismissal":"caught","strike_rate":"100.00","bowler_id":"85320","first_fielder_id":"61333","second_fielder_id":"","third_fielder_id":""},{"name":"Bess Heath","batsman_id":"51911","batting":"true","position":"non striker","role":"wk","role_str":"(WK)","runs":"29","balls_faced":"24","fours":"0","sixes":"1","run0":"4","run1":"15","run2":"4","run3":"0","run5":"0","how_out":"Not out","dismissal":"","strike_rate":"120.83","bowler_id":"0","first_fielder_id":"","second_fielder_id":"","third_fielder_id":""},{"name":"Abigail Glen","batsman_id":"116260","batting":"false","position":"","role":"all","role_str":"","runs":"5","balls_faced":"6","fours":"0","sixes":"0","run0":"2","run1":"3","run2":"1","run3":"0","run5":"0","how_out":"st RM Southby b R Tyson","dismissal":"stumped","strike_rate":"83.33","bowler_id":"51502","first_fielder_id":"61327","second_fielder_id":"","third_fielder_id":""},{"name":"Emma Marlow","batsman_id":"116259","batting":"true","position":"striker","role":"bat","role_str":"","runs":"8","balls_faced":"11","fours":"1","sixes":"0","run0":"7","run1":"2","run2":"1","run3":"0","run5":"0","how_out":"b FR Davies","dismissal":"bowled","strike_rate":"72.73","bowler_id":"51734","first_fielder_id":"","second_fielder_id":"","third_fielder_id":""}],"bowlers":[{"name":"Freya Davies","bowler_id":"51734","bowling":"true","position":"active bowler","overs":"4","maidens":"0","runs_conceded":"20","wickets":"2","noballs":"0","wides":"1","econ":"5.00","run0":"11","bowledcount":"1","lbwcount":"0"},{"name":"Daisy Gibb","bowler_id":"107886","bowling":"false","position":"","overs":"2","maidens":"0","runs_conceded":"5","wickets":"0","noballs":"0","wides":"0","econ":"2.50","run0":"7","bowledcount":"0","lbwcount":"0"},{"name":"Rebecca Tyson","bowler_id":"51502","bowling":"false","position":"","overs":"4","maidens":"0","runs_conceded":"28","wickets":"2","noballs":"0","wides":"0","econ":"7.00","run0":"10","bowledcount":"0","lbwcount":"0"},{"name":"Charli Knott","bowler_id":"85320","bowling":"false","position":"last bowler","overs":"4","maidens":"0","runs_conceded":"22","wickets":"1","noballs":"0","wides":"0","econ":"5.50","run0":"10","bowledcount":"0","lbwcount":"0"},{"name":"Mary Taylor","bowler_id":"107883","bowling":"false","position":"","overs":"2","maidens":"0","runs_conceded":"13","wickets":"1","noballs":"0","wides":"2","econ":"6.50","run0":"5","bowledcount":"1","lbwcount":"0"},{"name":"Georgia Adams","bowler_id":"51733","bowling":"false","position":"","overs":"4","maidens":"0","runs_conceded":"28","wickets":"0","noballs":"0","wides":"1","econ":"7.00","run0":"4","bowledcount":"0","lbwcount":"0"}],"fielder":[{"fielder_id":"61327","fielder_name":"Rhianna Southby","catches":0,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":2,"is_substitute":"false"},{"fielder_id":"102782","fielder_name":"Freya Kemp","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"61333","fielder_name":"Maia Bouchier","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"fows":[{"name":"Katherine Fraser","batsman_id":"95778","runs":"4","balls":"10","how_out":"c F Kemp b FR Davies","score_at_dismissal":24,"overs_at_dismissal":"4.1","bowler_id":"51734","dismissal":"caught","number":1},{"name":"Suzie Bates","batsman_id":"44247","runs":"34","balls":"33","how_out":"st RM Southby b R Tyson","score_at_dismissal":54,"overs_at_dismissal":"9.2","bowler_id":"51502","dismissal":"stumped","number":2},{"name":"Hollie Armitage","batsman_id":"58162","runs":"18","balls":"23","how_out":"b M Taylor","score_at_dismissal":68,"overs_at_dismissal":"11.4","bowler_id":"107883","dismissal":"bowled","number":3},{"name":"Mady Villiers","batsman_id":"51467","runs":"14","balls":"14","how_out":"c ME Bouchier b C Knott","score_at_dismissal":84,"overs_at_dismissal":"14.3","bowler_id":"85320","dismissal":"caught","number":4},{"name":"Abigail Glen","batsman_id":"116260","runs":"5","balls":"6","how_out":"st RM Southby b R Tyson","score_at_dismissal":92,"overs_at_dismissal":"16.1","bowler_id":"51502","dismissal":"stumped","number":5},{"name":"Emma Marlow","batsman_id":"116259","runs":"8","balls":"11","how_out":"b FR Davies","score_at_dismissal":119,"overs_at_dismissal":"19.6","bowler_id":"51734","dismissal":"bowled","number":6}],"last_wicket":{"name":"Emma Marlow","batsman_id":"116259","runs":"8","balls":"11","how_out":"b FR Davies","score_at_dismissal":119,"overs_at_dismissal":"19.6","bowler_id":"51734","dismissal":"bowled","number":6},"extra_runs":{"byes":1,"legbyes":2,"wides":4,"noballs":0,"penalty":"0","total":7},"equations":{"runs":119,"wickets":6,"overs":"20","bowlers_used":6,"runrate":"5.95"},"current_partnership":{"runs":27,"balls":23,"overs":3.5,"batsmen":[{"name":"Emma Marlow","batsman_id":116259,"runs":8,"balls":11},{"name":"Bess Heath","batsman_id":51911,"runs":19,"balls":12}]},"did_not_bat":[{"player_id":"116258","name":"Phoebe Turner"},{"player_id":"137961","name":"Trudy Johnson"},{"player_id":"146141","name":"Grace Thompson"},{"player_id":"51493","name":"Katie Levick"}],"max_over":"20","target":"0"},{"iid":197616,"number":2,"name":"Hampshire Women Inning","short_name":"HAM-W Inning","status":2,"issuperover":"false","result":4,"batting_team_id":19277,"fielding_team_id":19270,"scores":"33\/2","scores_full":"33\/2 (6 ov)","batsmen":[{"name":"Maia Bouchier","batsman_id":"61333","batting":"true","position":"non striker","role":"bat","role_str":"","runs":"22","balls_faced":"21","fours":"4","sixes":"0","run0":"11","run1":"6","run2":"0","run3":"0","run5":"0","how_out":"Not out","dismissal":"","strike_rate":"104.76","bowler_id":"0","first_fielder_id":"","second_fielder_id":"","third_fielder_id":""},{"name":"Ella McCaughan","batsman_id":"102764","batting":"false","position":"","role":"bat","role_str":"","runs":"4","balls_faced":"7","fours":"0","sixes":"0","run0":"4","run1":"2","run2":"1","run3":"0","run5":"0","how_out":"c E Marlow b MK Villiers","dismissal":"caught","strike_rate":"57.14","bowler_id":"51467","first_fielder_id":"116259","second_fielder_id":"","third_fielder_id":""},{"name":"Charli Knott","batsman_id":"85320","batting":"false","position":"","role":"all","role_str":"","runs":"0","balls_faced":"1","fours":"0","sixes":"0","run0":"1","run1":"0","run2":"0","run3":"0","run5":"0","how_out":"b KA Levick","dismissal":"bowled","strike_rate":"0.00","bowler_id":"51493","first_fielder_id":"","second_fielder_id":"","third_fielder_id":""},{"name":"Freya Kemp","batsman_id":"102782","batting":"true","position":"striker","role":"all","role_str":"","runs":"4","balls_faced":"8","fours":"0","sixes":"0","run0":"4","run1":"2","run2":"1","run3":"0","run5":"0","how_out":"Not out","dismissal":"","strike_rate":"50.00","bowler_id":"0","first_fielder_id":"","second_fielder_id":"","third_fielder_id":""}],"bowlers":[{"name":"Grace Thompson","bowler_id":"146141","bowling":"true","position":"active bowler","overs":"2","maidens":"0","runs_conceded":"8","wickets":"0","noballs":"0","wides":"2","econ":"4.00","run0":"7","bowledcount":"0","lbwcount":"0"},{"name":"Mady Villiers","bowler_id":"51467","bowling":"false","position":"","overs":"2","maidens":"0","runs_conceded":"13","wickets":"1","noballs":"0","wides":"0","econ":"6.50","run0":"5","bowledcount":"0","lbwcount":"0"},{"name":"Katie Levick","bowler_id":"51493","bowling":"false","position":"","overs":"1","maidens":"0","runs_conceded":"3","wickets":"1","noballs":"0","wides":"0","econ":"3.00","run0":"5","bowledcount":"1","lbwcount":"0"},{"name":"Trudy Johnson","bowler_id":"137961","bowling":"false","position":"last bowler","overs":"1","maidens":"0","runs_conceded":"8","wickets":"0","noballs":"0","wides":"0","econ":"8.00","run0":"4","bowledcount":"0","lbwcount":"0"}],"fielder":[{"fielder_id":"116259","fielder_name":"Emma Marlow","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"fows":[{"name":"Ella McCaughan","batsman_id":"102764","runs":"4","balls":"7","how_out":"c E Marlow b MK Villiers","score_at_dismissal":8,"overs_at_dismissal":"1.6","bowler_id":"51467","dismissal":"caught","number":1},{"name":"Charli Knott","batsman_id":"85320","runs":"0","balls":"1","how_out":"b KA Levick","score_at_dismissal":9,"overs_at_dismissal":"2.3","bowler_id":"51493","dismissal":"bowled","number":2}],"last_wicket":{"name":"Charli Knott","batsman_id":"85320","runs":"0","balls":"1","how_out":"b KA Levick","score_at_dismissal":9,"overs_at_dismissal":"2.3","bowler_id":"51493","dismissal":"bowled","number":2},"extra_runs":{"byes":0,"legbyes":1,"wides":2,"noballs":0,"penalty":"0","total":3},"equations":{"runs":33,"wickets":2,"overs":"6","bowlers_used":4,"runrate":"5.50"},"current_partnership":{"runs":24,"balls":21,"overs":3.3,"batsmen":[{"name":"Freya Kemp","batsman_id":102782,"runs":4,"balls":7},{"name":"Maia Bouchier","batsman_id":61333,"runs":19,"balls":14}]},"did_not_bat":[{"player_id":"51733","name":"Georgia Adams"},{"player_id":"61327","name":"Rhianna Southby"},{"player_id":"90942","name":"Naomi Dattani"},{"player_id":"107883","name":"Mary Taylor"},{"player_id":"51734","name":"Freya Davies"},{"player_id":"107886","name":"Daisy Gibb"},{"player_id":"51502","name":"Rebecca Tyson"}],"max_over":"6","target":"35"}],"players":[{"pid":44247,"title":"Suzie Bates","short_name":"SW Bates","first_name":"Suzie Bates","last_name":"","middle_name":"","birthdate":"1987-09-16","birthplace":"Dunedin, Otago","country":"nz","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/SuzieWBates","instagram_profile":"https:\/\/www.instagram.com\/suziebates\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bat","role_str":""},{"pid":44686,"title":"Ellyse Perry","short_name":"EA Perry","first_name":"Ellyse Perry","last_name":"","middle_name":"","birthdate":"1990-11-03","birthplace":"Wahroonga, Sydney, New South Wales","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/ellyseperryofficial\/","twitter_profile":"https:\/\/twitter.com\/EllysePerry","instagram_profile":"https:\/\/www.instagram.com\/ellyseperry\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":51467,"title":"Mady Villiers","short_name":"MK Villiers","first_name":"Mady Villiers","last_name":"","middle_name":"","birthdate":"1998-08-26","birthplace":" Havering, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/mady.villiers\/","twitter_profile":"https:\/\/twitter.com\/VilliersMady","instagram_profile":"https:\/\/www.instagram.com\/madyvilliers\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":51493,"title":"Katie Levick","short_name":"KA Levick","first_name":"Katie Levick","last_name":"","middle_name":"","birthdate":"1991-07-17","birthplace":"Sheffield, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Katie_Lev","instagram_profile":"https:\/\/www.instagram.com\/katie_lev\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":51502,"title":"Rebecca Tyson","short_name":"R Tyson","first_name":"Rebecca Tyson","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":51656,"title":"Linsey Smith","short_name":"LCN Smith","first_name":"Linsey Smith","last_name":"","middle_name":"","birthdate":"1995-03-10","birthplace":"Hillingdon, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/LinseySmith95","instagram_profile":"https:\/\/www.instagram.com\/linseysm\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51663,"title":"Lauren Bell","short_name":"LK Bell","first_name":"Lauren Bell","last_name":"","middle_name":"","birthdate":"2001-01-02","birthplace":" Swindon, Wiltshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/_laurenbell2","instagram_profile":"https:\/\/www.instagram.com\/l.belll_\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51672,"title":"Emily Windsor","short_name":"EL Windsor","first_name":"Emily Windsor","last_name":"","middle_name":"","birthdate":"1997-09-14","birthplace":"Portsmouth","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/emzwinsa","instagram_profile":"https:\/\/www.instagram.com\/emzwinsa\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":51733,"title":"Georgia Adams","short_name":"GL Adams","first_name":"Georgia Adams","last_name":"","middle_name":"","birthdate":"1993-10-04","birthplace":" Chesterfield, Derbyshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/GeorgiaAdams01","instagram_profile":"https:\/\/www.instagram.com\/gadams01\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":"(C)"},{"pid":51734,"title":"Freya Davies","short_name":"FR Davies","first_name":"Freya Davies","last_name":"","middle_name":"","birthdate":"1995-10-27","birthplace":"Chichester, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/FreyaRuth","instagram_profile":"https:\/\/www.instagram.com\/freyaruth\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":51911,"title":"Bess Heath","short_name":"BAM Heath","first_name":"Bess Heath","last_name":"","middle_name":"","birthdate":"2001-08-20","birthplace":"Chesterfield, Derbyshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/bess.heath\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/bessy.10\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":58162,"title":"Hollie Armitage","short_name":"H Armitage","first_name":"Hollie Armitage","last_name":"","middle_name":"","birthdate":"1997-06-14","birthplace":"Huddersfield, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/holliearmo\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"pid":61327,"title":"Rhianna Southby","short_name":"RM Southby","first_name":"Rhianna Southby","last_name":"","middle_name":"","birthdate":"2000-08-16","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper ","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/rhianna_southby","instagram_profile":"https:\/\/www.instagram.com\/rhianna_southby\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":61333,"title":"Maia Bouchier","short_name":"ME Bouchier","first_name":"Maia Bouchier","last_name":"","middle_name":"","birthdate":"1998-12-05","birthplace":"Kensington, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/maia.bouchier.5\/","twitter_profile":"https:\/\/twitter.com\/maiabouchier","instagram_profile":"https:\/\/www.instagram.com\/maiabouchier\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":85320,"title":"Charli Knott","short_name":"C Knott","first_name":"Charli Knott","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"all","role_str":""},{"pid":90942,"title":"Naomi Dattani","short_name":"ND Dattani","first_name":"Naomi Dattani","last_name":"","middle_name":"","birthdate":"1994-04-28","birthplace":"Ealing, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/NaomiDattani","instagram_profile":"https:\/\/www.instagram.com\/naomi.dattani\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":95778,"title":"Katherine Fraser","short_name":"K Fraser","first_name":"Katherine Fraser","last_name":"","middle_name":"","birthdate":"2005-04-09","birthplace":"","country":"sct","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Scotland","role":"bowl","role_str":""},{"pid":102557,"title":"Lauren Filer","short_name":"L Filer","first_name":"Lauren Filer","last_name":"","middle_name":"","birthdate":"2000-12-22","birthplace":" Bristol","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/laurenfiler14","instagram_profile":"https:\/\/www.instagram.com\/lauren_filer\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":102764,"title":"Ella McCaughan","short_name":"E McCaughan","first_name":"Ella McCaughan","last_name":"","middle_name":"","birthdate":"2002-09-26","birthplace":"Southampton, Hampshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/ella_mccaughan","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":102766,"title":"Nancy Harman","short_name":"N Harman","first_name":"Nancy Harman","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":102768,"title":"Sophia Turner","short_name":"S Turner","first_name":"Sophia Turner","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":102782,"title":"Freya Kemp","short_name":"F Kemp","first_name":"Freya Kemp","last_name":"","middle_name":"","birthdate":"2005-04-21","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/KempFreya","instagram_profile":"https:\/\/www.instagram.com\/freyagkemp\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":102803,"title":"Leah Dobson","short_name":"L Dobson","first_name":"Leah Dobson","last_name":"","middle_name":"","birthdate":"2001-10-06","birthplace":"Scarborough, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/_leahdobson","instagram_profile":"https:\/\/www.instagram.com\/leah__dobson\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":103050,"title":"Mia Rogers","short_name":"M Rogers","first_name":"Mia Rogers","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":107871,"title":"Megan Sturge","short_name":"M Sturge","first_name":"Megan Sturge","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":107883,"title":"Mary Taylor","short_name":"M Taylor","first_name":"Mary Taylor","last_name":"","middle_name":"","birthdate":"2004-10-07","birthplace":"Eastbourne, England","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":107886,"title":"Daisy Gibb","short_name":"D Gibb","first_name":"Daisy Gibb","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":110339,"title":"Daisy Mullan","short_name":"D Mullan","first_name":"Daisy Mullan","last_name":"","middle_name":"","birthdate":"2002-11-29","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":116258,"title":"Phoebe Turner","short_name":"P Turner","first_name":"Phoebe Turner","last_name":"","middle_name":"","birthdate":"2003-08-08","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":116259,"title":"Emma Marlow","short_name":"E Marlow","first_name":"Emma Marlow","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":116260,"title":"Abigail Glen","short_name":"A Glen","first_name":"Abigail Glen","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":119591,"title":"Lizzie Scott","short_name":"LE Scott","first_name":"Lizzie Scott","last_name":"","middle_name":"","birthdate":"2004-09-01","birthplace":" Hexham, Northumberland","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lizziescott04","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":128845,"title":"Ava Lee","short_name":"A Lee","first_name":"Ava Lee","last_name":"","middle_name":"","birthdate":"2005-08-26","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":128846,"title":"Abi Norgrove","short_name":"A Norgrove","first_name":"Abi Norgrove","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":137961,"title":"Trudy Johnson","short_name":"T Johnson","first_name":"Trudy Johnson","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":139765,"title":"Poppy G Tulloch","short_name":"P Tulloch","first_name":"Poppy G Tulloch","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":146141,"title":"Grace Thompson","short_name":"Grace Thompson","first_name":"Grace Thompson","last_name":"","middle_name":"","birthdate":"2007-05-30","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""}],"pre_match_odds":[],"day_remaining_over":"","match_notes":[["Durham Women inning 1","Powerplay 1 (0.1 - 6) Run 35, wicket 1","Durham Women: 50 runs in 8.3 overs.","Durham Women: 100 runs in 17.2 overs.","Innings Break: Durham Women - 119\/6 overs 20 (balls 120)."],["Hampshire Women inning 2","Powerplay 1 (0.1 - 6) Run 33, wicket 2"]]},"etag":"50d5c213070d9656c3da6639316b34b9","modified":"2025-06-25 23:31:19","datetime":"2025-06-25 23:31:19","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90240 AND DataTypeId = 2 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:03648afc-8a8e-465e-952b-89d9cda61fe5 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90240 AND DataTypeId = 8) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90240,8,'{"status":"ok","response":{"teama":{"team_id":19277,"squads":[{"player_id":"61333","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Maia Bouchier"},{"player_id":"102764","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Ella McCaughan"},{"player_id":"85320","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"true","name":"Charli Knott"},{"player_id":"51733","substitute":"false","out":"false","in":"false","role_str":"(C)","role":"all","playing11":"true","name":"Georgia Adams"},{"player_id":"102782","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"true","name":"Freya Kemp"},{"player_id":"61327","substitute":"false","out":"false","in":"false","role_str":"(WK)","role":"wk","playing11":"true","name":"Rhianna Southby"},{"player_id":"90942","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"true","name":"Naomi Dattani"},{"player_id":"107883","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Mary Taylor"},{"player_id":"51734","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Freya Davies"},{"player_id":"107886","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Daisy Gibb"},{"player_id":"51502","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Rebecca Tyson"},{"player_id":"107871","substitute":"false","out":"false","in":"false","role_str":"","role":"wk","playing11":"false","name":"Megan Sturge"},{"player_id":"128846","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"false","name":"Abi Norgrove"},{"player_id":"110339","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"false","name":"Daisy Mullan"},{"player_id":"139765","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"false","name":"Poppy G Tulloch"},{"player_id":"102766","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"false","name":"Nancy Harman"},{"player_id":"128845","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"false","name":"Ava Lee"},{"player_id":"44686","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"false","name":"Ellyse Perry"},{"player_id":"51663","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"false","name":"Lauren Bell"},{"player_id":"51656","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"false","name":"Linsey Smith"}]},"teamb":{"team_id":19270,"squads":[{"player_id":"44247","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Suzie Bates"},{"player_id":"95778","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Katherine Fraser"},{"player_id":"58162","substitute":"false","out":"false","in":"false","role_str":"(C)","role":"bat","playing11":"true","name":"Hollie Armitage"},{"player_id":"51467","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"true","name":"Mady Villiers"},{"player_id":"51911","substitute":"false","out":"false","in":"false","role_str":"(WK)","role":"wk","playing11":"true","name":"Bess Heath"},{"player_id":"116259","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Emma Marlow"},{"player_id":"116260","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"true","name":"Abigail Glen"},{"player_id":"116258","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"true","name":"Phoebe Turner"},{"player_id":"137961","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Trudy Johnson"},{"player_id":"146141","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Grace Thompson"},{"player_id":"51493","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Katie Levick"},{"player_id":"103050","substitute":"false","out":"false","in":"false","role_str":"","role":"wk","playing11":"false","name":"Mia Rogers"},{"player_id":"102803","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"false","name":"Leah Dobson"},{"player_id":"51672","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"false","name":"Emily Windsor"},{"player_id":"102557","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"false","name":"Lauren Filer"},{"player_id":"102768","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"false","name":"Sophia Turner"},{"player_id":"119591","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"false","name":"Lizzie Scott"}]},"teams":[{"tid":19270,"title":"Durham Women","abbr":"DUR-W","alt_name":"Durham Women","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/09\/Rectangle-3493-25.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/09\/Rectangle-3493-25.png","country":"en","sex":"male","team_owner":"","head_coach":""},{"tid":19277,"title":"Hampshire Women","abbr":"HAM-W","alt_name":"HAM-W","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/12\/Hampshire-Women.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/12\/Hampshire-Women.png","country":"en","sex":"female","team_owner":"","head_coach":""}],"players":[{"pid":44247,"title":"Suzie Bates","short_name":"SW Bates","first_name":"Suzie Bates","last_name":"","middle_name":"","birthdate":"1987-09-16","birthplace":"Dunedin, Otago","country":"nz","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/SuzieWBates","instagram_profile":"https:\/\/www.instagram.com\/suziebates\/","debut_data":"","thumb_url":"","nationality":"New Zealand"},{"pid":44686,"title":"Ellyse Perry","short_name":"EA Perry","first_name":"Ellyse Perry","last_name":"","middle_name":"","birthdate":"1990-11-03","birthplace":"Wahroonga, Sydney, New South Wales","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/ellyseperryofficial\/","twitter_profile":"https:\/\/twitter.com\/EllysePerry","instagram_profile":"https:\/\/www.instagram.com\/ellyseperry\/","debut_data":"","thumb_url":"","nationality":"Australia"},{"pid":51467,"title":"Mady Villiers","short_name":"MK Villiers","first_name":"Mady Villiers","last_name":"","middle_name":"","birthdate":"1998-08-26","birthplace":" Havering, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/mady.villiers\/","twitter_profile":"https:\/\/twitter.com\/VilliersMady","instagram_profile":"https:\/\/www.instagram.com\/madyvilliers\/","debut_data":"","thumb_url":"","nationality":"England"},{"pid":51493,"title":"Katie Levick","short_name":"KA Levick","first_name":"Katie Levick","last_name":"","middle_name":"","birthdate":"1991-07-17","birthplace":"Sheffield, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Katie_Lev","instagram_profile":"https:\/\/www.instagram.com\/katie_lev\/","debut_data":"","thumb_url":"","nationality":"England"},{"pid":51502,"title":"Rebecca Tyson","short_name":"R Tyson","first_name":"Rebecca Tyson","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":51656,"title":"Linsey Smith","short_name":"LCN Smith","first_name":"Linsey Smith","last_name":"","middle_name":"","birthdate":"1995-03-10","birthplace":"Hillingdon, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/LinseySmith95","instagram_profile":"https:\/\/www.instagram.com\/linseysm\/","debut_data":"","thumb_url":"","nationality":"England"},{"pid":51663,"title":"Lauren Bell","short_name":"LK Bell","first_name":"Lauren Bell","last_name":"","middle_name":"","birthdate":"2001-01-02","birthplace":" Swindon, Wiltshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/_laurenbell2","instagram_profile":"https:\/\/www.instagram.com\/l.belll_\/","debut_data":"","thumb_url":"","nationality":"England"},{"pid":51672,"title":"Emily Windsor","short_name":"EL Windsor","first_name":"Emily Windsor","last_name":"","middle_name":"","birthdate":"1997-09-14","birthplace":"Portsmouth","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/emzwinsa","instagram_profile":"https:\/\/www.instagram.com\/emzwinsa\/","debut_data":"","thumb_url":"","nationality":"England"},{"pid":51733,"title":"Georgia Adams","short_name":"GL Adams","first_name":"Georgia Adams","last_name":"","middle_name":"","birthdate":"1993-10-04","birthplace":" Chesterfield, Derbyshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/GeorgiaAdams01","instagram_profile":"https:\/\/www.instagram.com\/gadams01\/","debut_data":"","thumb_url":"","nationality":"England"},{"pid":51734,"title":"Freya Davies","short_name":"FR Davies","first_name":"Freya Davies","last_name":"","middle_name":"","birthdate":"1995-10-27","birthplace":"Chichester, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/FreyaRuth","instagram_profile":"https:\/\/www.instagram.com\/freyaruth\/","debut_data":"","thumb_url":"","nationality":"England"},{"pid":51911,"title":"Bess Heath","short_name":"BAM Heath","first_name":"Bess Heath","last_name":"","middle_name":"","birthdate":"2001-08-20","birthplace":"Chesterfield, Derbyshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/bess.heath\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/bessy.10\/","debut_data":"","thumb_url":"","nationality":"England"},{"pid":58162,"title":"Hollie Armitage","short_name":"H Armitage","first_name":"Hollie Armitage","last_name":"","middle_name":"","birthdate":"1997-06-14","birthplace":"Huddersfield, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/holliearmo\/","debut_data":"","thumb_url":"","nationality":"England"},{"pid":61327,"title":"Rhianna Southby","short_name":"RM Southby","first_name":"Rhianna Southby","last_name":"","middle_name":"","birthdate":"2000-08-16","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper ","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/rhianna_southby","instagram_profile":"https:\/\/www.instagram.com\/rhianna_southby\/","debut_data":"","thumb_url":"","nationality":"England"},{"pid":61333,"title":"Maia Bouchier","short_name":"ME Bouchier","first_name":"Maia Bouchier","last_name":"","middle_name":"","birthdate":"1998-12-05","birthplace":"Kensington, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/maia.bouchier.5\/","twitter_profile":"https:\/\/twitter.com\/maiabouchier","instagram_profile":"https:\/\/www.instagram.com\/maiabouchier\/","debut_data":"","thumb_url":"","nationality":"England"},{"pid":85320,"title":"Charli Knott","short_name":"C Knott","first_name":"Charli Knott","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"Australia"},{"pid":90942,"title":"Naomi Dattani","short_name":"ND Dattani","first_name":"Naomi Dattani","last_name":"","middle_name":"","birthdate":"1994-04-28","birthplace":"Ealing, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/NaomiDattani","instagram_profile":"https:\/\/www.instagram.com\/naomi.dattani\/","debut_data":"","thumb_url":"","nationality":"England"},{"pid":95778,"title":"Katherine Fraser","short_name":"K Fraser","first_name":"Katherine Fraser","last_name":"","middle_name":"","birthdate":"2005-04-09","birthplace":"","country":"sct","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"Scotland"},{"pid":102557,"title":"Lauren Filer","short_name":"L Filer","first_name":"Lauren Filer","last_name":"","middle_name":"","birthdate":"2000-12-22","birthplace":" Bristol","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/laurenfiler14","instagram_profile":"https:\/\/www.instagram.com\/lauren_filer\/","debut_data":"","thumb_url":"","nationality":"England"},{"pid":102764,"title":"Ella McCaughan","short_name":"E McCaughan","first_name":"Ella McCaughan","last_name":"","middle_name":"","birthdate":"2002-09-26","birthplace":"Southampton, Hampshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/ella_mccaughan","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":102766,"title":"Nancy Harman","short_name":"N Harman","first_name":"Nancy Harman","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":102768,"title":"Sophia Turner","short_name":"S Turner","first_name":"Sophia Turner","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":102782,"title":"Freya Kemp","short_name":"F Kemp","first_name":"Freya Kemp","last_name":"","middle_name":"","birthdate":"2005-04-21","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/KempFreya","instagram_profile":"https:\/\/www.instagram.com\/freyagkemp\/","debut_data":"","thumb_url":"","nationality":"England"},{"pid":102803,"title":"Leah Dobson","short_name":"L Dobson","first_name":"Leah Dobson","last_name":"","middle_name":"","birthdate":"2001-10-06","birthplace":"Scarborough, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/_leahdobson","instagram_profile":"https:\/\/www.instagram.com\/leah__dobson\/","debut_data":"","thumb_url":"","nationality":"England"},{"pid":103050,"title":"Mia Rogers","short_name":"M Rogers","first_name":"Mia Rogers","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":107871,"title":"Megan Sturge","short_name":"M Sturge","first_name":"Megan Sturge","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":107883,"title":"Mary Taylor","short_name":"M Taylor","first_name":"Mary Taylor","last_name":"","middle_name":"","birthdate":"2004-10-07","birthplace":"Eastbourne, England","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":107886,"title":"Daisy Gibb","short_name":"D Gibb","first_name":"Daisy Gibb","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":110339,"title":"Daisy Mullan","short_name":"D Mullan","first_name":"Daisy Mullan","last_name":"","middle_name":"","birthdate":"2002-11-29","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":116258,"title":"Phoebe Turner","short_name":"P Turner","first_name":"Phoebe Turner","last_name":"","middle_name":"","birthdate":"2003-08-08","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":116259,"title":"Emma Marlow","short_name":"E Marlow","first_name":"Emma Marlow","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":116260,"title":"Abigail Glen","short_name":"A Glen","first_name":"Abigail Glen","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":119591,"title":"Lizzie Scott","short_name":"LE Scott","first_name":"Lizzie Scott","last_name":"","middle_name":"","birthdate":"2004-09-01","birthplace":" Hexham, Northumberland","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lizziescott04","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":128845,"title":"Ava Lee","short_name":"A Lee","first_name":"Ava Lee","last_name":"","middle_name":"","birthdate":"2005-08-26","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":128846,"title":"Abi Norgrove","short_name":"A Norgrove","first_name":"Abi Norgrove","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":137961,"title":"Trudy Johnson","short_name":"T Johnson","first_name":"Trudy Johnson","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":139765,"title":"Poppy G Tulloch","short_name":"P Tulloch","first_name":"Poppy G Tulloch","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":146141,"title":"Grace Thompson","short_name":"Grace Thompson","first_name":"Grace Thompson","last_name":"","middle_name":"","birthdate":"2007-05-30","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"}]},"etag":"50d5c213070d9656c3da6639316b34b9","modified":"2025-06-25 23:31:19","datetime":"2025-06-25 23:31:19","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"teama":{"team_id":19277,"squads":[{"player_id":"61333","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Maia Bouchier"},{"player_id":"102764","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Ella McCaughan"},{"player_id":"85320","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"true","name":"Charli Knott"},{"player_id":"51733","substitute":"false","out":"false","in":"false","role_str":"(C)","role":"all","playing11":"true","name":"Georgia Adams"},{"player_id":"102782","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"true","name":"Freya Kemp"},{"player_id":"61327","substitute":"false","out":"false","in":"false","role_str":"(WK)","role":"wk","playing11":"true","name":"Rhianna Southby"},{"player_id":"90942","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"true","name":"Naomi Dattani"},{"player_id":"107883","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Mary Taylor"},{"player_id":"51734","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Freya Davies"},{"player_id":"107886","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Daisy Gibb"},{"player_id":"51502","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Rebecca Tyson"},{"player_id":"107871","substitute":"false","out":"false","in":"false","role_str":"","role":"wk","playing11":"false","name":"Megan Sturge"},{"player_id":"128846","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"false","name":"Abi Norgrove"},{"player_id":"110339","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"false","name":"Daisy Mullan"},{"player_id":"139765","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"false","name":"Poppy G Tulloch"},{"player_id":"102766","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"false","name":"Nancy Harman"},{"player_id":"128845","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"false","name":"Ava Lee"},{"player_id":"44686","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"false","name":"Ellyse Perry"},{"player_id":"51663","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"false","name":"Lauren Bell"},{"player_id":"51656","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"false","name":"Linsey Smith"}]},"teamb":{"team_id":19270,"squads":[{"player_id":"44247","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Suzie Bates"},{"player_id":"95778","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Katherine Fraser"},{"player_id":"58162","substitute":"false","out":"false","in":"false","role_str":"(C)","role":"bat","playing11":"true","name":"Hollie Armitage"},{"player_id":"51467","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"true","name":"Mady Villiers"},{"player_id":"51911","substitute":"false","out":"false","in":"false","role_str":"(WK)","role":"wk","playing11":"true","name":"Bess Heath"},{"player_id":"116259","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Emma Marlow"},{"player_id":"116260","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"true","name":"Abigail Glen"},{"player_id":"116258","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"true","name":"Phoebe Turner"},{"player_id":"137961","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Trudy Johnson"},{"player_id":"146141","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Grace Thompson"},{"player_id":"51493","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Katie Levick"},{"player_id":"103050","substitute":"false","out":"false","in":"false","role_str":"","role":"wk","playing11":"false","name":"Mia Rogers"},{"player_id":"102803","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"false","name":"Leah Dobson"},{"player_id":"51672","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"false","name":"Emily Windsor"},{"player_id":"102557","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"false","name":"Lauren Filer"},{"player_id":"102768","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"false","name":"Sophia Turner"},{"player_id":"119591","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"false","name":"Lizzie Scott"}]},"teams":[{"tid":19270,"title":"Durham Women","abbr":"DUR-W","alt_name":"Durham Women","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/09\/Rectangle-3493-25.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/09\/Rectangle-3493-25.png","country":"en","sex":"male","team_owner":"","head_coach":""},{"tid":19277,"title":"Hampshire Women","abbr":"HAM-W","alt_name":"HAM-W","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/12\/Hampshire-Women.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/12\/Hampshire-Women.png","country":"en","sex":"female","team_owner":"","head_coach":""}],"players":[{"pid":44247,"title":"Suzie Bates","short_name":"SW Bates","first_name":"Suzie Bates","last_name":"","middle_name":"","birthdate":"1987-09-16","birthplace":"Dunedin, Otago","country":"nz","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/SuzieWBates","instagram_profile":"https:\/\/www.instagram.com\/suziebates\/","debut_data":"","thumb_url":"","nationality":"New Zealand"},{"pid":44686,"title":"Ellyse Perry","short_name":"EA Perry","first_name":"Ellyse Perry","last_name":"","middle_name":"","birthdate":"1990-11-03","birthplace":"Wahroonga, Sydney, New South Wales","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/ellyseperryofficial\/","twitter_profile":"https:\/\/twitter.com\/EllysePerry","instagram_profile":"https:\/\/www.instagram.com\/ellyseperry\/","debut_data":"","thumb_url":"","nationality":"Australia"},{"pid":51467,"title":"Mady Villiers","short_name":"MK Villiers","first_name":"Mady Villiers","last_name":"","middle_name":"","birthdate":"1998-08-26","birthplace":" Havering, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/mady.villiers\/","twitter_profile":"https:\/\/twitter.com\/VilliersMady","instagram_profile":"https:\/\/www.instagram.com\/madyvilliers\/","debut_data":"","thumb_url":"","nationality":"England"},{"pid":51493,"title":"Katie Levick","short_name":"KA Levick","first_name":"Katie Levick","last_name":"","middle_name":"","birthdate":"1991-07-17","birthplace":"Sheffield, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Katie_Lev","instagram_profile":"https:\/\/www.instagram.com\/katie_lev\/","debut_data":"","thumb_url":"","nationality":"England"},{"pid":51502,"title":"Rebecca Tyson","short_name":"R Tyson","first_name":"Rebecca Tyson","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":51656,"title":"Linsey Smith","short_name":"LCN Smith","first_name":"Linsey Smith","last_name":"","middle_name":"","birthdate":"1995-03-10","birthplace":"Hillingdon, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/LinseySmith95","instagram_profile":"https:\/\/www.instagram.com\/linseysm\/","debut_data":"","thumb_url":"","nationality":"England"},{"pid":51663,"title":"Lauren Bell","short_name":"LK Bell","first_name":"Lauren Bell","last_name":"","middle_name":"","birthdate":"2001-01-02","birthplace":" Swindon, Wiltshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/_laurenbell2","instagram_profile":"https:\/\/www.instagram.com\/l.belll_\/","debut_data":"","thumb_url":"","nationality":"England"},{"pid":51672,"title":"Emily Windsor","short_name":"EL Windsor","first_name":"Emily Windsor","last_name":"","middle_name":"","birthdate":"1997-09-14","birthplace":"Portsmouth","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/emzwinsa","instagram_profile":"https:\/\/www.instagram.com\/emzwinsa\/","debut_data":"","thumb_url":"","nationality":"England"},{"pid":51733,"title":"Georgia Adams","short_name":"GL Adams","first_name":"Georgia Adams","last_name":"","middle_name":"","birthdate":"1993-10-04","birthplace":" Chesterfield, Derbyshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/GeorgiaAdams01","instagram_profile":"https:\/\/www.instagram.com\/gadams01\/","debut_data":"","thumb_url":"","nationality":"England"},{"pid":51734,"title":"Freya Davies","short_name":"FR Davies","first_name":"Freya Davies","last_name":"","middle_name":"","birthdate":"1995-10-27","birthplace":"Chichester, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/FreyaRuth","instagram_profile":"https:\/\/www.instagram.com\/freyaruth\/","debut_data":"","thumb_url":"","nationality":"England"},{"pid":51911,"title":"Bess Heath","short_name":"BAM Heath","first_name":"Bess Heath","last_name":"","middle_name":"","birthdate":"2001-08-20","birthplace":"Chesterfield, Derbyshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/bess.heath\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/bessy.10\/","debut_data":"","thumb_url":"","nationality":"England"},{"pid":58162,"title":"Hollie Armitage","short_name":"H Armitage","first_name":"Hollie Armitage","last_name":"","middle_name":"","birthdate":"1997-06-14","birthplace":"Huddersfield, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/holliearmo\/","debut_data":"","thumb_url":"","nationality":"England"},{"pid":61327,"title":"Rhianna Southby","short_name":"RM Southby","first_name":"Rhianna Southby","last_name":"","middle_name":"","birthdate":"2000-08-16","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper ","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/rhianna_southby","instagram_profile":"https:\/\/www.instagram.com\/rhianna_southby\/","debut_data":"","thumb_url":"","nationality":"England"},{"pid":61333,"title":"Maia Bouchier","short_name":"ME Bouchier","first_name":"Maia Bouchier","last_name":"","middle_name":"","birthdate":"1998-12-05","birthplace":"Kensington, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"https:\/\/www.facebook.com\/maia.bouchier.5\/","twitter_profile":"https:\/\/twitter.com\/maiabouchier","instagram_profile":"https:\/\/www.instagram.com\/maiabouchier\/","debut_data":"","thumb_url":"","nationality":"England"},{"pid":85320,"title":"Charli Knott","short_name":"C Knott","first_name":"Charli Knott","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"Australia"},{"pid":90942,"title":"Naomi Dattani","short_name":"ND Dattani","first_name":"Naomi Dattani","last_name":"","middle_name":"","birthdate":"1994-04-28","birthplace":"Ealing, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/NaomiDattani","instagram_profile":"https:\/\/www.instagram.com\/naomi.dattani\/","debut_data":"","thumb_url":"","nationality":"England"},{"pid":95778,"title":"Katherine Fraser","short_name":"K Fraser","first_name":"Katherine Fraser","last_name":"","middle_name":"","birthdate":"2005-04-09","birthplace":"","country":"sct","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"Scotland"},{"pid":102557,"title":"Lauren Filer","short_name":"L Filer","first_name":"Lauren Filer","last_name":"","middle_name":"","birthdate":"2000-12-22","birthplace":" Bristol","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/laurenfiler14","instagram_profile":"https:\/\/www.instagram.com\/lauren_filer\/","debut_data":"","thumb_url":"","nationality":"England"},{"pid":102764,"title":"Ella McCaughan","short_name":"E McCaughan","first_name":"Ella McCaughan","last_name":"","middle_name":"","birthdate":"2002-09-26","birthplace":"Southampton, Hampshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/ella_mccaughan","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":102766,"title":"Nancy Harman","short_name":"N Harman","first_name":"Nancy Harman","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":102768,"title":"Sophia Turner","short_name":"S Turner","first_name":"Sophia Turner","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":102782,"title":"Freya Kemp","short_name":"F Kemp","first_name":"Freya Kemp","last_name":"","middle_name":"","birthdate":"2005-04-21","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/KempFreya","instagram_profile":"https:\/\/www.instagram.com\/freyagkemp\/","debut_data":"","thumb_url":"","nationality":"England"},{"pid":102803,"title":"Leah Dobson","short_name":"L Dobson","first_name":"Leah Dobson","last_name":"","middle_name":"","birthdate":"2001-10-06","birthplace":"Scarborough, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/_leahdobson","instagram_profile":"https:\/\/www.instagram.com\/leah__dobson\/","debut_data":"","thumb_url":"","nationality":"England"},{"pid":103050,"title":"Mia Rogers","short_name":"M Rogers","first_name":"Mia Rogers","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":107871,"title":"Megan Sturge","short_name":"M Sturge","first_name":"Megan Sturge","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":107883,"title":"Mary Taylor","short_name":"M Taylor","first_name":"Mary Taylor","last_name":"","middle_name":"","birthdate":"2004-10-07","birthplace":"Eastbourne, England","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":107886,"title":"Daisy Gibb","short_name":"D Gibb","first_name":"Daisy Gibb","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":110339,"title":"Daisy Mullan","short_name":"D Mullan","first_name":"Daisy Mullan","last_name":"","middle_name":"","birthdate":"2002-11-29","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":116258,"title":"Phoebe Turner","short_name":"P Turner","first_name":"Phoebe Turner","last_name":"","middle_name":"","birthdate":"2003-08-08","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":116259,"title":"Emma Marlow","short_name":"E Marlow","first_name":"Emma Marlow","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":116260,"title":"Abigail Glen","short_name":"A Glen","first_name":"Abigail Glen","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":119591,"title":"Lizzie Scott","short_name":"LE Scott","first_name":"Lizzie Scott","last_name":"","middle_name":"","birthdate":"2004-09-01","birthplace":" Hexham, Northumberland","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lizziescott04","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":128845,"title":"Ava Lee","short_name":"A Lee","first_name":"Ava Lee","last_name":"","middle_name":"","birthdate":"2005-08-26","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":128846,"title":"Abi Norgrove","short_name":"A Norgrove","first_name":"Abi Norgrove","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":137961,"title":"Trudy Johnson","short_name":"T Johnson","first_name":"Trudy Johnson","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":139765,"title":"Poppy G Tulloch","short_name":"P Tulloch","first_name":"Poppy G Tulloch","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":146141,"title":"Grace Thompson","short_name":"Grace Thompson","first_name":"Grace Thompson","last_name":"","middle_name":"","birthdate":"2007-05-30","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"}]},"etag":"50d5c213070d9656c3da6639316b34b9","modified":"2025-06-25 23:31:19","datetime":"2025-06-25 23:31:19","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90240 AND DataTypeId = 8 END
Playing XI for Hampshire Women vs Durham Women Match 14 2025