Pro-Kabaddi-Season-1-7-Stats
Dataset with statistics about Pro Kabaddi
@kaggle.sripaadsrinivasan_prokabadiseassion17stats
Ds Team
@kaggle.sripaadsrinivasan_prokabadiseassion17stats.ds_team
- 2.3 MB
- 1368 rows
- 34 columns
unnamed_0Unnamed: 0 | idId | match_idMatch Id | nameName | scoreScore | short_nameShort Name | squadSquad | state_of_playState Of Play | state_of_play_is_raiding_nowState Of Play.is Raiding Now | state_of_play_last_raid_idState Of Play.last Raid.id | state_of_play_last_raid_resultState Of Play.last Raid.result | state_of_play_playersState Of Play.players | state_of_play_players_on_courtState Of Play.players On Court | stats_all_outsStats.all Outs | stats_declareStats.declare | stats_points_all_outStats.points.all Out | stats_points_declareStats.points.declare | stats_points_extrasStats.points.extras | stats_points_raid_points_raid_bonusStats.points.raid Points.raid Bonus | stats_points_raid_points_totalStats.points.raid Points.total | stats_points_raid_points_touchStats.points.raid Points.touch | stats_points_tackle_points_captureStats.points.tackle Points.capture | stats_points_tackle_points_capture_bonusStats.points.tackle Points.capture Bonus | stats_points_tackle_points_totalStats.points.tackle Points.total | stats_points_totalStats.points.total | stats_raids_emptyStats.raids.Empty | stats_raids_successfulStats.raids.successful | stats_raids_super_raidsStats.raids.super Raids | stats_raids_totalStats.raids.total | stats_raids_unsuccessfulStats.raids.unsuccessful | stats_tackles_successfulStats.tackles.successful | stats_tackles_super_tacklesStats.tackles.super Tackles | stats_tackles_totalStats.tackles.total | stats_tackles_unsuccessfulStats.tackles.unsuccessful |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3 | 1 | Jaipur Pink Panthers | 28 | JAI | [{'id': 15, 'name': 'Sanjay Shrestha', 'short_name': 'Sanjay Shrestha', 'skill': '', 'role': '', 'red_card': False, 'yellow_card': False, 'green_card': False, 'jersey': 88, 'played': True, 'captain': False, 'on_court': True, 'starter': True, 'top_raider': False, 'points': {'total': 0, 'raid_points':… | False | nan | [{'id': 0, 'is_raiding_now': False, 'on_court': False}] | 2 | 2 | 3 | 25 | 22 | 1 | 1 | 28 | 10 | 20 | 40 | 10 | 1 | 24 | 23 | ||||||||||
| 1 | 5 | 1 | U Mumba | 44 | MUM | [{'id': 54, 'name': 'Jeeva Kumar', 'short_name': 'Jeeva Kumar', 'skill': '', 'role': '', 'red_card': False, 'yellow_card': False, 'green_card': False, 'jersey': 6, 'played': True, 'captain': False, 'on_court': True, 'starter': True, 'top_raider': False, 'points': {'total': 0, 'raid_points': {'total'… | False | nan | [{'id': 0, 'is_raiding_now': False, 'on_court': False}] | 4 | 4 | 5 | 28 | 23 | 12 | 12 | 44 | 15 | 21 | 40 | 4 | 10 | 32 | 22 | |||||||||
| 2 | 10 | Dabang Delhi K.C. | 39 | DEL | [{'id': 4, 'name': 'Ehsan Zamani Fard', 'short_name': 'Ehsan Zamani Fard', 'skill': '', 'role': '', 'red_card': False, 'yellow_card': False, 'green_card': False, 'jersey': 1, 'played': True, 'captain': False, 'on_court': True, 'starter': True, 'top_raider': False, 'points': {'total': 0, 'raid_points… | False | nan | [{'id': 0, 'is_raiding_now': False, 'on_court': False}] | 4 | 4 | 5 | 26 | 21 | 9 | 9 | 39 | 8 | 24 | 44 | 12 | 8 | 27 | 19 | ||||||||||
| 1 | 4 | 10 | Bengal Warriors | 40 | KOL | [{'id': 5, 'name': 'Farhad Kamal Gharibi', 'short_name': 'Farhad Kamal Gharibi', 'skill': '', 'role': '', 'red_card': False, 'yellow_card': False, 'green_card': False, 'jersey': 99, 'played': False, 'captain': False, 'on_court': False, 'starter': False, 'top_raider': False, 'points': {'total': 0, 'r… | False | nan | [{'id': 0, 'is_raiding_now': False, 'on_court': False}] | 4 | 4 | 6 | 25 | 19 | 11 | 11 | 40 | 20 | 16 | 45 | 9 | 11 | 32 | 21 | |||||||||
| 2 | 100 | Dabang Delhi | 45 | DEL | [{'id': 58, 'name': 'Kashiling Adake', 'short_name': '', 'skill': '', 'role': '', 'red_card': False, 'yellow_card': False, 'green_card': True, 'jersey': 11, 'played': True, 'captain': False, 'on_court': False, 'starter': True, 'top_raider': True, 'points': {'total': 13, 'raid_points': {'total': 13, … | nan | nan | nan | 1 | 6 | 1 | 1 | 23 | 22 | 13 | 2 | 15 | 45 | 25 | 13 | 45 | 7 | 13 | 25 | 12 | ||||||||
| 1 | 6 | 100 | Patna Pirates | 26 | PAT | [{'id': 142, 'name': 'Sandeep Narwal', 'short_name': '', 'skill': '', 'role': '', 'red_card': False, 'yellow_card': False, 'green_card': False, 'jersey': 10, 'played': True, 'captain': True, 'on_court': True, 'starter': True, 'top_raider': False, 'points': {'total': 4, 'raid_points': {'total': 0, 't… | nan | nan | nan | 3 | 4 | 16 | 12 | 6 | 1 | 7 | 26 | 15 | 15 | 44 | 14 | 6 | 28 | 22 | |||||||||
| 2 | 101 | Dabang Delhi | 21 | DEL | [{'id': 58, 'name': 'Kashiling Adake', 'short_name': '', 'skill': '', 'role': '', 'red_card': False, 'yellow_card': False, 'green_card': False, 'jersey': 11, 'played': True, 'captain': False, 'on_court': True, 'starter': True, 'top_raider': True, 'points': {'total': 9, 'raid_points': {'total': 9, 't… | nan | nan | nan | 1 | 3 | 12 | 9 | 6 | 2 | 8 | 21 | 16 | 10 | 39 | 13 | 6 | 33 | 27 | ||||||||||
| 1 | 3 | 101 | Jaipur Pink Panthers | 51 | JAI | [{'id': 160, 'name': 'Ran Singh', 'short_name': '', 'skill': '', 'role': '', 'red_card': False, 'yellow_card': False, 'green_card': False, 'jersey': 33, 'played': True, 'captain': False, 'on_court': True, 'starter': True, 'top_raider': False, 'points': {'total': 4, 'raid_points': {'total': 0, 'touch… | nan | nan | nan | 5 | 10 | 1 | 1 | 28 | 27 | 12 | 12 | 51 | 16 | 18 | 40 | 6 | 12 | 21 | 9 | ||||||||
| 3 | 102 | Jaipur Pink Panthers | 31 | JAI | [{'id': 86, 'name': 'Rajesh Narwal', 'short_name': '', 'skill': '', 'role': '', 'red_card': False, 'yellow_card': False, 'green_card': True, 'jersey': 11, 'played': True, 'captain': False, 'on_court': True, 'starter': True, 'top_raider': False, 'points': {'total': 6, 'raid_points': {'total': 5, 'tou… | nan | nan | nan | 2 | 4 | 15 | 15 | 12 | 12 | 31 | 24 | 14 | 44 | 6 | 12 | 21 | 9 | |||||||||||
| 1 | 7 | 102 | Puneri Paltan | 18 | PUN | [{'id': 67, 'name': 'Mahipal Narwal', 'short_name': '', 'skill': '', 'role': '', 'red_card': False, 'yellow_card': False, 'green_card': False, 'jersey': 2, 'played': True, 'captain': False, 'on_court': True, 'starter': True, 'top_raider': True, 'points': {'total': 4, 'raid_points': {'total': 4, 'tou… | nan | nan | nan | 1 | 2 | 11 | 9 | 6 | 6 | 18 | 22 | 10 | 44 | 12 | 6 | 21 | 15 |
CREATE TABLE ds_team (
"unnamed_0" BIGINT,
"id" BIGINT,
"match_id" BIGINT,
"name" VARCHAR,
"score" BIGINT,
"short_name" VARCHAR,
"squad" VARCHAR,
"state_of_play" VARCHAR,
"state_of_play_is_raiding_now" VARCHAR,
"state_of_play_last_raid_id" DOUBLE,
"state_of_play_last_raid_result" VARCHAR,
"state_of_play_players" VARCHAR,
"state_of_play_players_on_court" DOUBLE,
"stats_all_outs" BIGINT,
"stats_declare" BIGINT,
"stats_points_all_out" BIGINT,
"stats_points_declare" BIGINT,
"stats_points_extras" BIGINT,
"stats_points_raid_points_raid_bonus" BIGINT,
"stats_points_raid_points_total" BIGINT,
"stats_points_raid_points_touch" BIGINT,
"stats_points_tackle_points_capture" BIGINT,
"stats_points_tackle_points_capture_bonus" BIGINT,
"stats_points_tackle_points_total" BIGINT,
"stats_points_total" BIGINT,
"stats_raids_empty" BIGINT,
"stats_raids_successful" BIGINT,
"stats_raids_super_raids" DOUBLE,
"stats_raids_total" BIGINT,
"stats_raids_unsuccessful" BIGINT,
"stats_tackles_successful" BIGINT,
"stats_tackles_super_tackles" DOUBLE,
"stats_tackles_total" BIGINT,
"stats_tackles_unsuccessful" BIGINT
);