VCT PACIFIC 2023

Data from VCT PACIFIC 2023, when PRX won the series

@kaggle.kierru_vctpacific_2023

Table List

8 tables(128.18 KB)

Eco

N 1v1

Stats

Pick Ban

Stats

@kaggle.kierru_vctpacific_2023.stats

39.56 KB
1330 rows
27 columns

player_name Player Name	team Team	opponent Opponent	rating Rating	acs Acs	kill Kill	death Death	assist Assist	kast_percent Kast Percent	adr Adr	hs_percent Hs Percent	first_kill First Kill	first_death First Death	agent Agent	map Map	score_team Score Team	score_opp Score Opp	score_t Score T	score_ct Score Ct	total_round Total Round	ot Ot	win_lose Win Lose	tourney_type Tourney Type	game_id Game Id	player_id Player Id	match_id Match Id	role_agent Role Agent
Laz	ZETA	DRX	1.19	239	15	11	6	72%	146	16%	1		Sova	Ascent	5	13	1	4	18	No	lose	League Play: Week 1	119512	999	184456	Initiator
TENNN	ZETA	DRX	0.84	234	15	14	6	61%	145	32%	1	4	Killjoy	Ascent	5	13	1	4	18	No	lose	League Play: Week 1	119512	1395	184456	Sentinel
Dep	ZETA	DRX	0.68	173	10	15	2	67%	123	18%	4	2	Jett	Ascent	5	13	1	4	18	No	lose	League Play: Week 1	119512	424	184456	Duelist
crow	ZETA	DRX	0.63	142	8	15	4	83%	92	29%	3	2	Kayo	Ascent	5	13	1	4	18	No	lose	League Play: Week 1	119512	1000	184456	Initiator
SugarZ3ro	ZETA	DRX	0.57	114	7	16	8	61%	63	13%		1	Omen	Ascent	5	13	1	4	18	No	lose	League Play: Week 1	119512	6668	184456	Controller
MaKo	DRX	ZETA	1.67	257	15	9	20	83%	172	30%	1	2	Omen	Ascent	13	5	8	5	18	No	win	League Play: Week 1	119512	4462	184456	Controller
Foxy9	DRX	ZETA	1.3	275	18	11	4	72%	167	17%	5	4	Jett	Ascent	13	5	8	5	18	No	win	League Play: Week 1	119512	11600	184456	Duelist
stax	DRX	ZETA	1.27	299	17	15	8	83%	190	28%	2	1	Kayo	Ascent	13	5	8	5	18	No	win	League Play: Week 1	119512	485	184456	Initiator
Zest	DRX	ZETA	1.06	168	11	10	3	67%	95	31%	1		Sova	Ascent	13	5	8	5	18	No	win	League Play: Week 1	119512	772	184456	Initiator
Rb	DRX	ZETA	0.87	125	10	10		67%	63	19%		2	Killjoy	Ascent	13	5	8	5	18	No	win	League Play: Week 1	119512	488	184456	Sentinel


CREATE TABLE stats (
  "player_name" VARCHAR,
  "team" VARCHAR,
  "opponent" VARCHAR,
  "rating" DOUBLE,
  "acs" BIGINT,
  "kill" BIGINT,
  "death" BIGINT,
  "assist" BIGINT,
  "kast_percent" VARCHAR,
  "adr" BIGINT,
  "hs_percent" VARCHAR,
  "first_kill" BIGINT,
  "first_death" BIGINT,
  "agent" VARCHAR,
  "map" VARCHAR,
  "score_team" BIGINT,
  "score_opp" BIGINT,
  "score_t" BIGINT,
  "score_ct" BIGINT,
  "total_round" BIGINT,
  "ot" VARCHAR,
  "win_lose" VARCHAR,
  "tourney_type" VARCHAR,
  "game_id" BIGINT,
  "player_id" BIGINT,
  "match_id" BIGINT,
  "role_agent" VARCHAR
);