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:2ef8b2aa-6dec-45d6-8f87-c82a735e4ba0
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90759 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90759,1,'{"status":"ok","response":{"mid":90759,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Canada won by 6 wickets","day_remaining_over":"","team_batting":"Canada","team_bowling":"Bermuda","live_inning_number":2,"live_score":{"runs":132,"overs":15.5,"wickets":4,"target":132,"runrate":8.34,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Nicholas Kirton","batsman_id":52190,"runs":17,"balls_faced":10,"fours":1,"sixes":1,"strike_rate":"170.00"},{"name":"Harsh Thaker","batsman_id":1126,"runs":32,"balls_faced":30,"fours":4,"sixes":0,"strike_rate":"106.67"}],"bowlers":[{"name":"Delray Rawlins","bowler_id":51262,"overs":3.5,"runs_conceded":29,"wickets":0,"maidens":0,"econ":"7.83"},{"name":"Derrick Brangman","bowler_id":59265,"overs":3,"runs_conceded":15,"wickets":1,"maidens":0,"econ":"5.00"}],"commentaries":[{"event_id":"12199551","event":"ball","batsman_id":"1126","bowler_id":"95851","over":"11","ball":"5","score":2,"commentary":"Chare Smith to Harsh Thaker, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750630368,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12199552","event":"ball","batsman_id":"1126","bowler_id":"95851","over":"11","ball":"6","score":0,"commentary":"Chare Smith to Harsh Thaker, no run,","noball_dismissal":false,"text":"","timestamp":1750630372,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":12,"runs":10,"score":"99\/3","bats":[{"runs":18,"balls_faced":19,"fours":2,"sixes":0,"batsman_id":1126},{"runs":16,"balls_faced":15,"fours":2,"sixes":0,"batsman_id":96416}],"bowls":[{"runs_conceded":35,"maidens":0,"wickets":0,"bowler_id":95851,"overs":3},{"runs_conceded":5,"maidens":0,"wickets":0,"bowler_id":59265,"overs":1}],"commentary":"End of over 12 (10 runs), Canada 99\/3"},{"event_id":"12199555","event":"ball","batsman_id":"96416","bowler_id":"59265","over":"12","ball":"1","score":0,"commentary":"Derrick Brangman to Kanwarpal Tathgur, no run,","noball_dismissal":false,"text":"","timestamp":1750630416,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12199557","event":"wicket","batsman_id":"96416","bowler_id":"59265","over":"12","ball":"2","score":"w","commentary":"Derrick Brangman to Kanwarpal Tathgur, no run, c Jarryd Richardson b DL Brangman,","noball_dismissal":false,"text":"","timestamp":1750630476,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"96416","how_out":"c Jarryd Richardson b DL Brangman","batsman_runs":"16","batsman_balls":"17"},{"event_id":"12199560","event":"ball","batsman_id":"52190","bowler_id":"59265","over":"12","ball":"3","score":1,"commentary":"Derrick Brangman to Nicholas Kirton, 1 run,","noball_dismissal":false,"text":"","timestamp":1750630550,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12199562","event":"ball","batsman_id":"1126","bowler_id":"59265","over":"12","ball":"4","score":0,"commentary":"Derrick Brangman to Harsh Thaker, no run,","noball_dismissal":false,"text":"","timestamp":1750630581,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12199563","event":"ball","batsman_id":"1126","bowler_id":"59265","over":"12","ball":"5","score":1,"commentary":"Derrick Brangman to Harsh Thaker, 1 run,","noball_dismissal":false,"text":"","timestamp":1750630595,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12199566","event":"ball","batsman_id":"52190","bowler_id":"59265","over":"12","ball":"6","score":1,"commentary":"Derrick Brangman to Nicholas Kirton, 1 run,","noball_dismissal":false,"text":"","timestamp":1750630690,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":13,"runs":3,"score":"102\/4","bats":[{"runs":2,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":52190},{"runs":19,"balls_faced":21,"fours":2,"sixes":0,"batsman_id":1126}],"bowls":[{"runs_conceded":8,"maidens":0,"wickets":1,"bowler_id":59265,"overs":2},{"runs_conceded":35,"maidens":0,"wickets":0,"bowler_id":95851,"overs":3}],"commentary":"End of over 13 (3 runs), Canada 102\/4"},{"event_id":"12199567","event":"ball","batsman_id":"52190","bowler_id":"112009","over":"13","ball":"1","score":"1wd","commentary":"Dominic Sabir to Nicholas Kirton, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750630732,"run":1,"noball_run":"0","wide_run":"1","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12199569","event":"ball","batsman_id":"52190","bowler_id":"112009","over":"13","ball":"1","score":1,"commentary":"Dominic Sabir to Nicholas Kirton, 1 run,","noball_dismissal":false,"text":"","timestamp":1750630735,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12199570","event":"ball","batsman_id":"1126","bowler_id":"112009","over":"13","ball":"2","score":0,"commentary":"Dominic Sabir to Harsh Thaker, no run,","noball_dismissal":false,"text":"","timestamp":1750630763,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12199571","event":"ball","batsman_id":"1126","bowler_id":"112009","over":"13","ball":"3","score":4,"commentary":"Dominic Sabir to Harsh Thaker, Four,","noball_dismissal":false,"text":"","timestamp":1750630766,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12199573","event":"ball","batsman_id":"1126","bowler_id":"112009","over":"13","ball":"4","score":1,"commentary":"Dominic Sabir to Harsh Thaker, 1 run,","noball_dismissal":false,"text":"","timestamp":1750630789,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12199574","event":"ball","batsman_id":"52190","bowler_id":"112009","over":"13","ball":"5","score":6,"commentary":"Dominic Sabir to Nicholas Kirton, Six,","noball_dismissal":false,"text":"","timestamp":1750630809,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12199578","event":"ball","batsman_id":"52190","bowler_id":"112009","over":"13","ball":"6","score":2,"commentary":"Dominic Sabir to Nicholas Kirton, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750630858,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":14,"runs":15,"score":"117\/4","bats":[{"runs":11,"balls_faced":5,"fours":0,"sixes":1,"batsman_id":52190},{"runs":24,"balls_faced":24,"fours":3,"sixes":0,"batsman_id":1126}],"bowls":[{"runs_conceded":28,"maidens":0,"wickets":2,"bowler_id":112009,"overs":4},{"runs_conceded":8,"maidens":0,"wickets":1,"bowler_id":59265,"overs":2}],"commentary":"End of over 14 (15 runs), Canada 117\/4"},{"event_id":"12199582","event":"ball","batsman_id":"1126","bowler_id":"59265","over":"14","ball":"1","score":1,"commentary":"Derrick Brangman to Harsh Thaker, 1 run,","noball_dismissal":false,"text":"","timestamp":1750630921,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12199584","event":"ball","batsman_id":"52190","bowler_id":"59265","over":"14","ball":"2","score":1,"commentary":"Derrick Brangman to Nicholas Kirton, 1 run,","noball_dismissal":false,"text":"","timestamp":1750630952,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12199585","event":"ball","batsman_id":"1126","bowler_id":"59265","over":"14","ball":"3","score":0,"commentary":"Derrick Brangman to Harsh Thaker, no run,","noball_dismissal":false,"text":"","timestamp":1750630966,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12199587","event":"ball","batsman_id":"1126","bowler_id":"59265","over":"14","ball":"4","score":1,"commentary":"Derrick Brangman to Harsh Thaker, 1 run,","noball_dismissal":false,"text":"","timestamp":1750630978,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12199588","event":"ball","batsman_id":"52190","bowler_id":"59265","over":"14","ball":"5","score":4,"commentary":"Derrick Brangman to Nicholas Kirton, Four,","noball_dismissal":false,"text":"","timestamp":1750630997,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12199590","event":"ball","batsman_id":"52190","bowler_id":"59265","over":"14","ball":"6","score":0,"commentary":"Derrick Brangman to Nicholas Kirton, no run,","noball_dismissal":false,"text":"","timestamp":1750631041,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":15,"runs":7,"score":"124\/4","bats":[{"runs":16,"balls_faced":8,"fours":1,"sixes":1,"batsman_id":52190},{"runs":26,"balls_faced":27,"fours":3,"sixes":0,"batsman_id":1126}],"bowls":[{"runs_conceded":15,"maidens":0,"wickets":1,"bowler_id":59265,"overs":3},{"runs_conceded":28,"maidens":0,"wickets":2,"bowler_id":112009,"overs":4}],"commentary":"End of over 15 (7 runs), Canada 124\/4"},{"event_id":"12199593","event":"ball","batsman_id":"1126","bowler_id":"51262","over":"15","ball":"1","score":1,"commentary":"Delray Rawlins to Harsh Thaker, 1 run,","noball_dismissal":false,"text":"","timestamp":1750631420,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12199602","event":"ball","batsman_id":"52190","bowler_id":"51262","over":"15","ball":"2","score":0,"commentary":"Delray Rawlins to Nicholas Kirton, no run,","noball_dismissal":false,"text":"","timestamp":1750631423,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12199603","event":"ball","batsman_id":"52190","bowler_id":"51262","over":"15","ball":"3","score":"2nb","commentary":"Delray Rawlins to Nicholas Kirton, 2 no ball,","noball_dismissal":false,"text":"","timestamp":1750633220,"run":2,"noball_run":"1","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":true,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12199604","event":"ball","batsman_id":"1126","bowler_id":"51262","over":"15","ball":"3","score":0,"commentary":"Delray Rawlins to Harsh Thaker, no run,","noball_dismissal":false,"text":"","timestamp":1750633065,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12199605","event":"ball","batsman_id":"1126","bowler_id":"51262","over":"15","ball":"4","score":4,"commentary":"Delray Rawlins to Harsh Thaker, Four,","noball_dismissal":false,"text":"","timestamp":1750633070,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12199632","event":"ball","batsman_id":"1126","bowler_id":"51262","over":"15","ball":"5","score":1,"commentary":"Delray Rawlins to Harsh Thaker, 1 run,","noball_dismissal":false,"text":"","timestamp":1750633077,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false}],"day":"0","session":"0","live_inning":{"iid":198585,"number":2,"name":"Canada Inning","short_name":"CAN Inning","status":2,"issuperover":"false","result":3,"batting_team_id":6791,"fielding_team_id":9138,"scores":"132\/4","scores_full":"132\/4 (15.5 ov)","fielder":[{"fielder_id":"131207","fielder_name":"Onias-Bascome","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"95851","fielder_name":"Chare Smith","catches":0,"runout_thrower":1,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"51262","fielder_name":"Delray Rawlins","catches":0,"runout_thrower":0,"runout_catcher":1,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"124818","fielder_name":"Jarryd Richardson","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":[],"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Kanwarpal Tathgur","batsman_id":"96416","runs":"16","balls":"17","how_out":"c Jarryd Richardson b DL Brangman","score_at_dismissal":99,"overs_at_dismissal":"12.2","bowler_id":"59265","dismissal":"caught","number":4},"extra_runs":{"byes":1,"legbyes":0,"wides":7,"noballs":0,"penalty":"0","total":8},"equations":{"runs":132,"wickets":4,"overs":"15.5","bowlers_used":5,"runrate":"8.34"},"current_partnership":{"runs":33,"balls":22,"overs":3.4,"batsmen":[{"name":"Nicholas Kirton","batsman_id":52190,"runs":17,"balls":10},{"name":"Harsh Thaker","batsman_id":1126,"runs":14,"balls":12}]},"did_not_bat":[{"player_id":"96319","name":"Saad Zafar"},{"player_id":"147987","name":"Shivam Sharma"},{"player_id":"90992","name":"Jaskaran Singh"},{"player_id":"96421","name":"Kaleem Sana"},{"player_id":"93722","name":"Dillon Heyliger"}],"max_over":"20","target":"132","recent_scores":"1,4,0,2,0,1,0,4,1,0,1,1,2,6,1,4,0,1","last_five_overs":"43\/1 8.06","last_ten_overs":"68\/2 6.58"},"teams":[{"tid":6791,"title":"Canada","abbr":"CAN","alt_name":"Canada","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/CANADA.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/CANADA.png","country":"ca","sex":"male","team_owner":"","head_coach":"Pubudu Dassanayake","scores_full":"132\/4 (15.5 ov)","scores":"132\/4","overs":"15.5"},{"tid":9138,"title":"Bermuda","abbr":"BER","alt_name":"Bermuda","type":"country","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/04\/RBH@2x-1.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/04\/RBH@2x-1.png","country":"bm","sex":"male","team_owner":"","head_coach":"","scores_full":"131\/10 (18.3 ov)","scores":"131\/10","overs":"18.3"}],"players":[{"pid":1126,"title":"Harsh Thaker","short_name":"H Thaker","first_name":"Harsh Thaker","last_name":"","middle_name":"","birthdate":"1997-10-24","birthplace":"","country":"ca","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Canada","role":"all","role_str":""},{"pid":49185,"title":"Navneet Dhaliwal","short_name":"NS Dhaliwal","first_name":"Navneet Dhaliwal","last_name":"","middle_name":"","birthdate":"1988-10-10","birthplace":"","country":"ca","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","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":"Canada","role":"squad","role_str":""},{"pid":51262,"title":"Delray Rawlins","short_name":"DMW Rawlins","first_name":"Delray Rawlins","last_name":"","middle_name":"","birthdate":"1997-09-14","birthplace":"","country":"bm","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/delraw09","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Bermuda","role":"all","role_str":""},{"pid":52190,"title":"Nicholas Kirton","short_name":"Nicholas Kirton","first_name":"Nicholas Kirton","last_name":"","middle_name":"","birthdate":"1998-05-06","birthplace":"","country":"ca","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Canada","role":"bat","role_str":"(C)"},{"pid":52559,"title":"Tre Manders","short_name":"T Manders","first_name":"Tre Manders","last_name":"","middle_name":"","birthdate":"1995-01-30","birthplace":"","country":"bm","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Bermuda","role":"bat","role_str":""},{"pid":56134,"title":"Terryn Fray","short_name":"T Fray","first_name":"Terryn Fray","last_name":"","middle_name":"","birthdate":"1991-06-30","birthplace":"","country":"bm","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Bermuda","role":"bat","role_str":"(C)"},{"pid":59265,"title":"Derrick Brangman","short_name":"DL Brangman","first_name":"Derrick Brangman","last_name":"","middle_name":"","birthdate":"1987-08-24","birthplace":"","country":"bm","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Bermuda","role":"bowl","role_str":""},{"pid":62386,"title":"Alex Dore","short_name":"AD Dore","first_name":"Alex Dore","last_name":"","middle_name":"","birthdate":"1997-05-27","birthplace":"","country":"bm","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","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":"Bermuda","role":"bat","role_str":""},{"pid":90558,"title":"Pargat Singh","short_name":"Pargat Singh","first_name":"Pargat Singh","last_name":"","middle_name":"","birthdate":"1992-04-13","birthplace":"","country":"ca","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":"Canada","role":"bat","role_str":""},{"pid":90992,"title":"Jaskaran Singh","short_name":"Jaskaran Singh","first_name":"Jaskaran Singh","last_name":"","middle_name":"","birthdate":"1989-09-04","birthplace":"","country":"in","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":92646,"title":"Kevon Fubler","short_name":"K Fubler","first_name":"Kevon Fubler","last_name":"","middle_name":"","birthdate":"1992-03-29","birthplace":"","country":"bm","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Bermuda","role":"squad","role_str":""},{"pid":93722,"title":"Dillon Heyliger","short_name":"D Heyliger","first_name":"Dillon Heyliger","last_name":"","middle_name":"","birthdate":"1989-10-21","birthplace":"","country":"ca","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Canada","role":"bowl","role_str":""},{"pid":94979,"title":"Ravinderpal Singh","short_name":"R Singh","first_name":"Ravinderpal Singh","last_name":"","middle_name":"","birthdate":"1988-10-14","birthplace":"","country":"ca","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":"Canada","role":"squad","role_str":""},{"pid":95851,"title":"Chare Smith","short_name":"C Smith","first_name":"Chare Smith","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"bm","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":"Bermuda","role":"bowl","role_str":""},{"pid":95854,"title":"Sinclair Smith","short_name":"S Smith","first_name":"Sinclair Smith","last_name":"","middle_name":"","birthdate":"1991-09-27","birthplace":"","country":"bm","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Bermuda","role":"squad","role_str":""},{"pid":95856,"title":"Zeko Burgess","short_name":"Z Burgess","first_name":"Zeko Burgess","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"bm","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":"Bermuda","role":"all","role_str":""},{"pid":96319,"title":"Saad Zafar","short_name":"S Zafar","first_name":"Saad Zafar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ca","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Canada","role":"all","role_str":""},{"pid":96416,"title":"Kanwarpal Tathgur","short_name":"K Tathgur","first_name":"Kanwarpal Tathgur","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ca","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Canada","role":"wk","role_str":"(WK)"},{"pid":96417,"title":"Shreyas Movva","short_name":"S Movva","first_name":"Shreyas Movva","last_name":"","middle_name":"","birthdate":"1993-09-04","birthplace":"","country":"ca","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":"Canada","role":"squad","role_str":""},{"pid":96421,"title":"Kaleem Sana","short_name":"K Sana","first_name":"Kaleem Sana","last_name":"","middle_name":"","birthdate":"1994-01-01","birthplace":"","country":"ca","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium Fast","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":"Canada","role":"bowl","role_str":""},{"pid":96773,"title":"Mihir Patel","short_name":"M Patel","first_name":"Mihir Patel","last_name":"","middle_name":"","birthdate":"2002-11-01","birthplace":"","country":"ca","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Canada","role":"squad","role_str":""},{"pid":104951,"title":"Ansh Patel","short_name":"A Patel","first_name":"Ansh Patel","last_name":"","middle_name":"","birthdate":"2002-02-19","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","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":"India","role":"squad","role_str":""},{"pid":112009,"title":"Dominic Sabir","short_name":"Dominic Sabir","first_name":"Dominic Sabir","last_name":"","middle_name":"","birthdate":"2003-06-05","birthplace":"","country":"bm","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Bermuda","role":"all","role_str":""},{"pid":117913,"title":"Aaron Johnson","short_name":"Aaron Johnson","first_name":"Aaron Johnson","last_name":"","middle_name":"","birthdate":"1991-03-16","birthplace":"","country":"ca","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Canada","role":"squad","role_str":""},{"pid":124818,"title":"Jarryd Richardson","short_name":"Jarryd Richardson","first_name":"Jarryd Richardson","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"bm","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Bermuda","role":"wk","role_str":"(WK)"},{"pid":128466,"title":"Dilpreet Bajwa","short_name":"D Bajwa","first_name":"Dilpreet Bajwa","last_name":"","middle_name":"","birthdate":"2003-01-26","birthplace":"","country":"ca","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":"Canada","role":"bat","role_str":""},{"pid":130124,"title":"Yuvraj Samra","short_name":"Y Samra","first_name":"Yuvraj Samra","last_name":"","middle_name":"","birthdate":"2006-09-29","birthplace":"","country":"ca","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Canada","role":"bat","role_str":""},{"pid":130153,"title":"Jermal Proctor","short_name":"J Proctor","first_name":"Jermal Proctor","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"bm","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":"Bermuda","role":"squad","role_str":""},{"pid":131207,"title":"Onias-Bascome","short_name":"Onias-Bascome","first_name":"Onias-Bascome","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"bm","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":"Bermuda","role":"bat","role_str":""},{"pid":136313,"title":"Marcus Scotland","short_name":"M Scotland","first_name":"Marcus Scotland","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"bm","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Bermuda","role":"squad","role_str":""},{"pid":138251,"title":"Parveen Kumar Dhull","short_name":"P Dhull","first_name":"Parveen Kumar Dhull","last_name":"","middle_name":"","birthdate":"1994-05-29","birthplace":"","country":"ca","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":"Canada","role":"squad","role_str":""},{"pid":145342,"title":"Jonte Smith","short_name":"J Smith","first_name":"Jonte Smith","last_name":"","middle_name":"","birthdate":"1994-07-10","birthplace":"","country":"bm","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Bermuda","role":"bowl","role_str":""},{"pid":147985,"title":"Ali Nadeem","short_name":"A Nadeem","first_name":"Ali Nadeem","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ca","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":"Canada","role":"squad","role_str":""},{"pid":147987,"title":"Shivam Sharma","short_name":"S Sharma","first_name":"Shivam Sharma","last_name":"","middle_name":"","birthdate":"1998-03-27","birthplace":"","country":"ca","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Canada","role":"all","role_str":""}]},"etag":"221c7f63e6e117af4dbbce6b30055e97","modified":"2025-07-14 07:49:15","datetime":"2025-07-14 07:49:15","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":90759,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Canada won by 6 wickets","day_remaining_over":"","team_batting":"Canada","team_bowling":"Bermuda","live_inning_number":2,"live_score":{"runs":132,"overs":15.5,"wickets":4,"target":132,"runrate":8.34,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Nicholas Kirton","batsman_id":52190,"runs":17,"balls_faced":10,"fours":1,"sixes":1,"strike_rate":"170.00"},{"name":"Harsh Thaker","batsman_id":1126,"runs":32,"balls_faced":30,"fours":4,"sixes":0,"strike_rate":"106.67"}],"bowlers":[{"name":"Delray Rawlins","bowler_id":51262,"overs":3.5,"runs_conceded":29,"wickets":0,"maidens":0,"econ":"7.83"},{"name":"Derrick Brangman","bowler_id":59265,"overs":3,"runs_conceded":15,"wickets":1,"maidens":0,"econ":"5.00"}],"commentaries":[{"event_id":"12199551","event":"ball","batsman_id":"1126","bowler_id":"95851","over":"11","ball":"5","score":2,"commentary":"Chare Smith to Harsh Thaker, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750630368,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12199552","event":"ball","batsman_id":"1126","bowler_id":"95851","over":"11","ball":"6","score":0,"commentary":"Chare Smith to Harsh Thaker, no run,","noball_dismissal":false,"text":"","timestamp":1750630372,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":12,"runs":10,"score":"99\/3","bats":[{"runs":18,"balls_faced":19,"fours":2,"sixes":0,"batsman_id":1126},{"runs":16,"balls_faced":15,"fours":2,"sixes":0,"batsman_id":96416}],"bowls":[{"runs_conceded":35,"maidens":0,"wickets":0,"bowler_id":95851,"overs":3},{"runs_conceded":5,"maidens":0,"wickets":0,"bowler_id":59265,"overs":1}],"commentary":"End of over 12 (10 runs), Canada 99\/3"},{"event_id":"12199555","event":"ball","batsman_id":"96416","bowler_id":"59265","over":"12","ball":"1","score":0,"commentary":"Derrick Brangman to Kanwarpal Tathgur, no run,","noball_dismissal":false,"text":"","timestamp":1750630416,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12199557","event":"wicket","batsman_id":"96416","bowler_id":"59265","over":"12","ball":"2","score":"w","commentary":"Derrick Brangman to Kanwarpal Tathgur, no run, c Jarryd Richardson b DL Brangman,","noball_dismissal":false,"text":"","timestamp":1750630476,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"96416","how_out":"c Jarryd Richardson b DL Brangman","batsman_runs":"16","batsman_balls":"17"},{"event_id":"12199560","event":"ball","batsman_id":"52190","bowler_id":"59265","over":"12","ball":"3","score":1,"commentary":"Derrick Brangman to Nicholas Kirton, 1 run,","noball_dismissal":false,"text":"","timestamp":1750630550,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12199562","event":"ball","batsman_id":"1126","bowler_id":"59265","over":"12","ball":"4","score":0,"commentary":"Derrick Brangman to Harsh Thaker, no run,","noball_dismissal":false,"text":"","timestamp":1750630581,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12199563","event":"ball","batsman_id":"1126","bowler_id":"59265","over":"12","ball":"5","score":1,"commentary":"Derrick Brangman to Harsh Thaker, 1 run,","noball_dismissal":false,"text":"","timestamp":1750630595,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12199566","event":"ball","batsman_id":"52190","bowler_id":"59265","over":"12","ball":"6","score":1,"commentary":"Derrick Brangman to Nicholas Kirton, 1 run,","noball_dismissal":false,"text":"","timestamp":1750630690,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":13,"runs":3,"score":"102\/4","bats":[{"runs":2,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":52190},{"runs":19,"balls_faced":21,"fours":2,"sixes":0,"batsman_id":1126}],"bowls":[{"runs_conceded":8,"maidens":0,"wickets":1,"bowler_id":59265,"overs":2},{"runs_conceded":35,"maidens":0,"wickets":0,"bowler_id":95851,"overs":3}],"commentary":"End of over 13 (3 runs), Canada 102\/4"},{"event_id":"12199567","event":"ball","batsman_id":"52190","bowler_id":"112009","over":"13","ball":"1","score":"1wd","commentary":"Dominic Sabir to Nicholas Kirton, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750630732,"run":1,"noball_run":"0","wide_run":"1","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12199569","event":"ball","batsman_id":"52190","bowler_id":"112009","over":"13","ball":"1","score":1,"commentary":"Dominic Sabir to Nicholas Kirton, 1 run,","noball_dismissal":false,"text":"","timestamp":1750630735,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12199570","event":"ball","batsman_id":"1126","bowler_id":"112009","over":"13","ball":"2","score":0,"commentary":"Dominic Sabir to Harsh Thaker, no run,","noball_dismissal":false,"text":"","timestamp":1750630763,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12199571","event":"ball","batsman_id":"1126","bowler_id":"112009","over":"13","ball":"3","score":4,"commentary":"Dominic Sabir to Harsh Thaker, Four,","noball_dismissal":false,"text":"","timestamp":1750630766,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12199573","event":"ball","batsman_id":"1126","bowler_id":"112009","over":"13","ball":"4","score":1,"commentary":"Dominic Sabir to Harsh Thaker, 1 run,","noball_dismissal":false,"text":"","timestamp":1750630789,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12199574","event":"ball","batsman_id":"52190","bowler_id":"112009","over":"13","ball":"5","score":6,"commentary":"Dominic Sabir to Nicholas Kirton, Six,","noball_dismissal":false,"text":"","timestamp":1750630809,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12199578","event":"ball","batsman_id":"52190","bowler_id":"112009","over":"13","ball":"6","score":2,"commentary":"Dominic Sabir to Nicholas Kirton, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750630858,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":14,"runs":15,"score":"117\/4","bats":[{"runs":11,"balls_faced":5,"fours":0,"sixes":1,"batsman_id":52190},{"runs":24,"balls_faced":24,"fours":3,"sixes":0,"batsman_id":1126}],"bowls":[{"runs_conceded":28,"maidens":0,"wickets":2,"bowler_id":112009,"overs":4},{"runs_conceded":8,"maidens":0,"wickets":1,"bowler_id":59265,"overs":2}],"commentary":"End of over 14 (15 runs), Canada 117\/4"},{"event_id":"12199582","event":"ball","batsman_id":"1126","bowler_id":"59265","over":"14","ball":"1","score":1,"commentary":"Derrick Brangman to Harsh Thaker, 1 run,","noball_dismissal":false,"text":"","timestamp":1750630921,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12199584","event":"ball","batsman_id":"52190","bowler_id":"59265","over":"14","ball":"2","score":1,"commentary":"Derrick Brangman to Nicholas Kirton, 1 run,","noball_dismissal":false,"text":"","timestamp":1750630952,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12199585","event":"ball","batsman_id":"1126","bowler_id":"59265","over":"14","ball":"3","score":0,"commentary":"Derrick Brangman to Harsh Thaker, no run,","noball_dismissal":false,"text":"","timestamp":1750630966,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12199587","event":"ball","batsman_id":"1126","bowler_id":"59265","over":"14","ball":"4","score":1,"commentary":"Derrick Brangman to Harsh Thaker, 1 run,","noball_dismissal":false,"text":"","timestamp":1750630978,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12199588","event":"ball","batsman_id":"52190","bowler_id":"59265","over":"14","ball":"5","score":4,"commentary":"Derrick Brangman to Nicholas Kirton, Four,","noball_dismissal":false,"text":"","timestamp":1750630997,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12199590","event":"ball","batsman_id":"52190","bowler_id":"59265","over":"14","ball":"6","score":0,"commentary":"Derrick Brangman to Nicholas Kirton, no run,","noball_dismissal":false,"text":"","timestamp":1750631041,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":15,"runs":7,"score":"124\/4","bats":[{"runs":16,"balls_faced":8,"fours":1,"sixes":1,"batsman_id":52190},{"runs":26,"balls_faced":27,"fours":3,"sixes":0,"batsman_id":1126}],"bowls":[{"runs_conceded":15,"maidens":0,"wickets":1,"bowler_id":59265,"overs":3},{"runs_conceded":28,"maidens":0,"wickets":2,"bowler_id":112009,"overs":4}],"commentary":"End of over 15 (7 runs), Canada 124\/4"},{"event_id":"12199593","event":"ball","batsman_id":"1126","bowler_id":"51262","over":"15","ball":"1","score":1,"commentary":"Delray Rawlins to Harsh Thaker, 1 run,","noball_dismissal":false,"text":"","timestamp":1750631420,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12199602","event":"ball","batsman_id":"52190","bowler_id":"51262","over":"15","ball":"2","score":0,"commentary":"Delray Rawlins to Nicholas Kirton, no run,","noball_dismissal":false,"text":"","timestamp":1750631423,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12199603","event":"ball","batsman_id":"52190","bowler_id":"51262","over":"15","ball":"3","score":"2nb","commentary":"Delray Rawlins to Nicholas Kirton, 2 no ball,","noball_dismissal":false,"text":"","timestamp":1750633220,"run":2,"noball_run":"1","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":true,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12199604","event":"ball","batsman_id":"1126","bowler_id":"51262","over":"15","ball":"3","score":0,"commentary":"Delray Rawlins to Harsh Thaker, no run,","noball_dismissal":false,"text":"","timestamp":1750633065,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12199605","event":"ball","batsman_id":"1126","bowler_id":"51262","over":"15","ball":"4","score":4,"commentary":"Delray Rawlins to Harsh Thaker, Four,","noball_dismissal":false,"text":"","timestamp":1750633070,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12199632","event":"ball","batsman_id":"1126","bowler_id":"51262","over":"15","ball":"5","score":1,"commentary":"Delray Rawlins to Harsh Thaker, 1 run,","noball_dismissal":false,"text":"","timestamp":1750633077,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false}],"day":"0","session":"0","live_inning":{"iid":198585,"number":2,"name":"Canada Inning","short_name":"CAN Inning","status":2,"issuperover":"false","result":3,"batting_team_id":6791,"fielding_team_id":9138,"scores":"132\/4","scores_full":"132\/4 (15.5 ov)","fielder":[{"fielder_id":"131207","fielder_name":"Onias-Bascome","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"95851","fielder_name":"Chare Smith","catches":0,"runout_thrower":1,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"51262","fielder_name":"Delray Rawlins","catches":0,"runout_thrower":0,"runout_catcher":1,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"124818","fielder_name":"Jarryd Richardson","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":[],"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Kanwarpal Tathgur","batsman_id":"96416","runs":"16","balls":"17","how_out":"c Jarryd Richardson b DL Brangman","score_at_dismissal":99,"overs_at_dismissal":"12.2","bowler_id":"59265","dismissal":"caught","number":4},"extra_runs":{"byes":1,"legbyes":0,"wides":7,"noballs":0,"penalty":"0","total":8},"equations":{"runs":132,"wickets":4,"overs":"15.5","bowlers_used":5,"runrate":"8.34"},"current_partnership":{"runs":33,"balls":22,"overs":3.4,"batsmen":[{"name":"Nicholas Kirton","batsman_id":52190,"runs":17,"balls":10},{"name":"Harsh Thaker","batsman_id":1126,"runs":14,"balls":12}]},"did_not_bat":[{"player_id":"96319","name":"Saad Zafar"},{"player_id":"147987","name":"Shivam Sharma"},{"player_id":"90992","name":"Jaskaran Singh"},{"player_id":"96421","name":"Kaleem Sana"},{"player_id":"93722","name":"Dillon Heyliger"}],"max_over":"20","target":"132","recent_scores":"1,4,0,2,0,1,0,4,1,0,1,1,2,6,1,4,0,1","last_five_overs":"43\/1 8.06","last_ten_overs":"68\/2 6.58"},"teams":[{"tid":6791,"title":"Canada","abbr":"CAN","alt_name":"Canada","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/CANADA.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/CANADA.png","country":"ca","sex":"male","team_owner":"","head_coach":"Pubudu Dassanayake","scores_full":"132\/4 (15.5 ov)","scores":"132\/4","overs":"15.5"},{"tid":9138,"title":"Bermuda","abbr":"BER","alt_name":"Bermuda","type":"country","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/04\/RBH@2x-1.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/04\/RBH@2x-1.png","country":"bm","sex":"male","team_owner":"","head_coach":"","scores_full":"131\/10 (18.3 ov)","scores":"131\/10","overs":"18.3"}],"players":[{"pid":1126,"title":"Harsh Thaker","short_name":"H Thaker","first_name":"Harsh Thaker","last_name":"","middle_name":"","birthdate":"1997-10-24","birthplace":"","country":"ca","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Canada","role":"all","role_str":""},{"pid":49185,"title":"Navneet Dhaliwal","short_name":"NS Dhaliwal","first_name":"Navneet Dhaliwal","last_name":"","middle_name":"","birthdate":"1988-10-10","birthplace":"","country":"ca","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","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":"Canada","role":"squad","role_str":""},{"pid":51262,"title":"Delray Rawlins","short_name":"DMW Rawlins","first_name":"Delray Rawlins","last_name":"","middle_name":"","birthdate":"1997-09-14","birthplace":"","country":"bm","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/delraw09","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Bermuda","role":"all","role_str":""},{"pid":52190,"title":"Nicholas Kirton","short_name":"Nicholas Kirton","first_name":"Nicholas Kirton","last_name":"","middle_name":"","birthdate":"1998-05-06","birthplace":"","country":"ca","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Canada","role":"bat","role_str":"(C)"},{"pid":52559,"title":"Tre Manders","short_name":"T Manders","first_name":"Tre Manders","last_name":"","middle_name":"","birthdate":"1995-01-30","birthplace":"","country":"bm","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Bermuda","role":"bat","role_str":""},{"pid":56134,"title":"Terryn Fray","short_name":"T Fray","first_name":"Terryn Fray","last_name":"","middle_name":"","birthdate":"1991-06-30","birthplace":"","country":"bm","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Bermuda","role":"bat","role_str":"(C)"},{"pid":59265,"title":"Derrick Brangman","short_name":"DL Brangman","first_name":"Derrick Brangman","last_name":"","middle_name":"","birthdate":"1987-08-24","birthplace":"","country":"bm","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Bermuda","role":"bowl","role_str":""},{"pid":62386,"title":"Alex Dore","short_name":"AD Dore","first_name":"Alex Dore","last_name":"","middle_name":"","birthdate":"1997-05-27","birthplace":"","country":"bm","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","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":"Bermuda","role":"bat","role_str":""},{"pid":90558,"title":"Pargat Singh","short_name":"Pargat Singh","first_name":"Pargat Singh","last_name":"","middle_name":"","birthdate":"1992-04-13","birthplace":"","country":"ca","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":"Canada","role":"bat","role_str":""},{"pid":90992,"title":"Jaskaran Singh","short_name":"Jaskaran Singh","first_name":"Jaskaran Singh","last_name":"","middle_name":"","birthdate":"1989-09-04","birthplace":"","country":"in","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":92646,"title":"Kevon Fubler","short_name":"K Fubler","first_name":"Kevon Fubler","last_name":"","middle_name":"","birthdate":"1992-03-29","birthplace":"","country":"bm","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Bermuda","role":"squad","role_str":""},{"pid":93722,"title":"Dillon Heyliger","short_name":"D Heyliger","first_name":"Dillon Heyliger","last_name":"","middle_name":"","birthdate":"1989-10-21","birthplace":"","country":"ca","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Canada","role":"bowl","role_str":""},{"pid":94979,"title":"Ravinderpal Singh","short_name":"R Singh","first_name":"Ravinderpal Singh","last_name":"","middle_name":"","birthdate":"1988-10-14","birthplace":"","country":"ca","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":"Canada","role":"squad","role_str":""},{"pid":95851,"title":"Chare Smith","short_name":"C Smith","first_name":"Chare Smith","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"bm","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":"Bermuda","role":"bowl","role_str":""},{"pid":95854,"title":"Sinclair Smith","short_name":"S Smith","first_name":"Sinclair Smith","last_name":"","middle_name":"","birthdate":"1991-09-27","birthplace":"","country":"bm","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Bermuda","role":"squad","role_str":""},{"pid":95856,"title":"Zeko Burgess","short_name":"Z Burgess","first_name":"Zeko Burgess","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"bm","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":"Bermuda","role":"all","role_str":""},{"pid":96319,"title":"Saad Zafar","short_name":"S Zafar","first_name":"Saad Zafar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ca","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Canada","role":"all","role_str":""},{"pid":96416,"title":"Kanwarpal Tathgur","short_name":"K Tathgur","first_name":"Kanwarpal Tathgur","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ca","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Canada","role":"wk","role_str":"(WK)"},{"pid":96417,"title":"Shreyas Movva","short_name":"S Movva","first_name":"Shreyas Movva","last_name":"","middle_name":"","birthdate":"1993-09-04","birthplace":"","country":"ca","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":"Canada","role":"squad","role_str":""},{"pid":96421,"title":"Kaleem Sana","short_name":"K Sana","first_name":"Kaleem Sana","last_name":"","middle_name":"","birthdate":"1994-01-01","birthplace":"","country":"ca","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium Fast","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":"Canada","role":"bowl","role_str":""},{"pid":96773,"title":"Mihir Patel","short_name":"M Patel","first_name":"Mihir Patel","last_name":"","middle_name":"","birthdate":"2002-11-01","birthplace":"","country":"ca","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Canada","role":"squad","role_str":""},{"pid":104951,"title":"Ansh Patel","short_name":"A Patel","first_name":"Ansh Patel","last_name":"","middle_name":"","birthdate":"2002-02-19","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","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":"India","role":"squad","role_str":""},{"pid":112009,"title":"Dominic Sabir","short_name":"Dominic Sabir","first_name":"Dominic Sabir","last_name":"","middle_name":"","birthdate":"2003-06-05","birthplace":"","country":"bm","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Bermuda","role":"all","role_str":""},{"pid":117913,"title":"Aaron Johnson","short_name":"Aaron Johnson","first_name":"Aaron Johnson","last_name":"","middle_name":"","birthdate":"1991-03-16","birthplace":"","country":"ca","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Canada","role":"squad","role_str":""},{"pid":124818,"title":"Jarryd Richardson","short_name":"Jarryd Richardson","first_name":"Jarryd Richardson","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"bm","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Bermuda","role":"wk","role_str":"(WK)"},{"pid":128466,"title":"Dilpreet Bajwa","short_name":"D Bajwa","first_name":"Dilpreet Bajwa","last_name":"","middle_name":"","birthdate":"2003-01-26","birthplace":"","country":"ca","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":"Canada","role":"bat","role_str":""},{"pid":130124,"title":"Yuvraj Samra","short_name":"Y Samra","first_name":"Yuvraj Samra","last_name":"","middle_name":"","birthdate":"2006-09-29","birthplace":"","country":"ca","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Canada","role":"bat","role_str":""},{"pid":130153,"title":"Jermal Proctor","short_name":"J Proctor","first_name":"Jermal Proctor","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"bm","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":"Bermuda","role":"squad","role_str":""},{"pid":131207,"title":"Onias-Bascome","short_name":"Onias-Bascome","first_name":"Onias-Bascome","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"bm","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":"Bermuda","role":"bat","role_str":""},{"pid":136313,"title":"Marcus Scotland","short_name":"M Scotland","first_name":"Marcus Scotland","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"bm","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Bermuda","role":"squad","role_str":""},{"pid":138251,"title":"Parveen Kumar Dhull","short_name":"P Dhull","first_name":"Parveen Kumar Dhull","last_name":"","middle_name":"","birthdate":"1994-05-29","birthplace":"","country":"ca","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":"Canada","role":"squad","role_str":""},{"pid":145342,"title":"Jonte Smith","short_name":"J Smith","first_name":"Jonte Smith","last_name":"","middle_name":"","birthdate":"1994-07-10","birthplace":"","country":"bm","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Bermuda","role":"bowl","role_str":""},{"pid":147985,"title":"Ali Nadeem","short_name":"A Nadeem","first_name":"Ali Nadeem","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ca","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":"Canada","role":"squad","role_str":""},{"pid":147987,"title":"Shivam Sharma","short_name":"S Sharma","first_name":"Shivam Sharma","last_name":"","middle_name":"","birthdate":"1998-03-27","birthplace":"","country":"ca","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Canada","role":"all","role_str":""}]},"etag":"221c7f63e6e117af4dbbce6b30055e97","modified":"2025-07-14 07:49:15","datetime":"2025-07-14 07:49:15","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90759 AND DataTypeId = 1 END
System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'StatusId'.
Invalid column name 'ErrorLog'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Etoz.ConnectData.DataAccess.ExecuteQuery(String query) in c:\inetpub\wwwroot\cricdirect.com\api\v6\App_Code\db\data_access.cs:line 117
ClientConnectionId:2ef8b2aa-6dec-45d6-8f87-c82a735e4ba0
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90759 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90759,3,'{"status":"ok","response":{"match_id":90759,"title":"Canada vs Bermuda","short_title":"CAN vs BER","subtitle":"Match 12","match_number":"12","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Canada won by 6 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129634,"title":"ICC Mens T20 World Cup Americas Regional Final","abbr":"ICC Mens T20 World Cup Americas Regional Final","type":"tournament","category":"international","match_format":"t20","season":"2025","status":"live","datestart":"2025-06-15","dateend":"2025-06-23","country":"int","total_matches":"12","total_rounds":"1","total_teams":"4"},"teama":{"team_id":6791,"name":"Canada","short_name":"CAN","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/CANADA.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/CANADA.png","scores_full":"132\/4 (15.5 ov)","scores":"132\/4","overs":"15.5"},"teamb":{"team_id":9138,"name":"Bermuda","short_name":"BER","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/04\/RBH@2x-1.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/04\/RBH@2x-1.png","scores_full":"131\/10 (18.3 ov)","scores":"131\/10","overs":"18.3"},"date_start":"2025-06-22 19:30:00","date_end":"2025-06-23 05:30:00","timestamp_start":1750620600,"timestamp_end":1750656600,"date_start_ist":"2025-06-23 01:00:00","date_end_ist":"2025-06-23 11:00:00","venue":{"venue_id":"294","name":"Maple Leaf North-West Ground (A)","location":"King City","country":"Canada","timezone":""},"umpires":" Deighton Butler (West Indies), Zahid Bassarath (West Indies), Rohan Shah (Canada, TV)","referee":"Arnold Maddela (Canada)","equation":"","live":"","result":"CAN won by 6 wickets","result_type":1,"win_margin":"6 wickets","winning_team_id":6791,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-20 12:20:51","verify_time":"2025-06-23 04:38:28","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":29.43,"humidity":63,"visibility":10000,"wind_speed":"10.20","clouds":86},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Bermuda elected to bat","winner":9138,"decision":1}},"etag":"fe698785d805cfd7cf3dc6b6b1f4a16c","modified":"2025-07-14 07:49:16","datetime":"2025-07-14 07:49:16","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":90759,"title":"Canada vs Bermuda","short_title":"CAN vs BER","subtitle":"Match 12","match_number":"12","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Canada won by 6 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129634,"title":"ICC Mens T20 World Cup Americas Regional Final","abbr":"ICC Mens T20 World Cup Americas Regional Final","type":"tournament","category":"international","match_format":"t20","season":"2025","status":"live","datestart":"2025-06-15","dateend":"2025-06-23","country":"int","total_matches":"12","total_rounds":"1","total_teams":"4"},"teama":{"team_id":6791,"name":"Canada","short_name":"CAN","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/CANADA.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/CANADA.png","scores_full":"132\/4 (15.5 ov)","scores":"132\/4","overs":"15.5"},"teamb":{"team_id":9138,"name":"Bermuda","short_name":"BER","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/04\/RBH@2x-1.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/04\/RBH@2x-1.png","scores_full":"131\/10 (18.3 ov)","scores":"131\/10","overs":"18.3"},"date_start":"2025-06-22 19:30:00","date_end":"2025-06-23 05:30:00","timestamp_start":1750620600,"timestamp_end":1750656600,"date_start_ist":"2025-06-23 01:00:00","date_end_ist":"2025-06-23 11:00:00","venue":{"venue_id":"294","name":"Maple Leaf North-West Ground (A)","location":"King City","country":"Canada","timezone":""},"umpires":" Deighton Butler (West Indies), Zahid Bassarath (West Indies), Rohan Shah (Canada, TV)","referee":"Arnold Maddela (Canada)","equation":"","live":"","result":"CAN won by 6 wickets","result_type":1,"win_margin":"6 wickets","winning_team_id":6791,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-20 12:20:51","verify_time":"2025-06-23 04:38:28","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":29.43,"humidity":63,"visibility":10000,"wind_speed":"10.20","clouds":86},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Bermuda elected to bat","winner":9138,"decision":1}},"etag":"fe698785d805cfd7cf3dc6b6b1f4a16c","modified":"2025-07-14 07:49:16","datetime":"2025-07-14 07:49:16","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90759 AND DataTypeId = 3 END Live Report & Scorecard of Canada vs Bermuda Match 12
Canada vs Bermuda, Live Cricket Commentary