Esports Performance Rankings And Results
Performance Rankings and Results from Multiple Esports Platforms
@kaggle.thedevastator_unlocking_collegiate_esports_performance_with_bu
Performance Rankings and Results from Multiple Esports Platforms
@kaggle.thedevastator_unlocking_collegiate_esports_performance_with_bu
CREATE TABLE cs_week1 (
"unnamed_0" BIGINT,
"team_1" VARCHAR,
"university" VARCHAR
);
CREATE TABLE cs_week1_currentrankings (
"unnamed_0" VARCHAR,
"points" DOUBLE
);
CREATE TABLE cs_week2 (
"unnamed_0" BIGINT,
"team_1" VARCHAR,
"university" VARCHAR
);
CREATE TABLE cs_week2_currentrankings (
"unnamed_0" VARCHAR,
"points" DOUBLE
);
CREATE TABLE cs_week3 (
"unnamed_0" BIGINT,
"team_1" VARCHAR,
"university" VARCHAR
);
CREATE TABLE cs_week3_currentrankings (
"unnamed_0" VARCHAR,
"points" DOUBLE
);
CREATE TABLE dota_week1 (
"unnamed_0" BIGINT,
"team_1" VARCHAR,
"university" VARCHAR
);
CREATE TABLE dota_week1_currentrankings (
"unnamed_0" VARCHAR,
"points" DOUBLE
);
CREATE TABLE dota_week2 (
"unnamed_0" BIGINT,
"team_1" VARCHAR,
"university" VARCHAR
);
CREATE TABLE dota_week2_currentrankings (
"unnamed_0" VARCHAR,
"points" DOUBLE
);
CREATE TABLE dota_week3 (
"unnamed_0" BIGINT,
"team_1" VARCHAR,
"university" VARCHAR
);
CREATE TABLE dota_week3_currentrankings (
"unnamed_0" VARCHAR,
"points" DOUBLE
);
CREATE TABLE fortnite_week_1 (
"team_1" VARCHAR,
"university" VARCHAR
);
CREATE TABLE fortnite_week_2 (
"team_1" VARCHAR,
"university" VARCHAR
);
CREATE TABLE fortnite_finalrankings (
"unnamed_0" VARCHAR,
"points" DOUBLE
);
CREATE TABLE fortnite_week1_currentrankings (
"unnamed_0" VARCHAR,
"points" DOUBLE
);
CREATE TABLE ggs_week3 (
"unnamed_0" BIGINT,
"team_1" DOUBLE,
"university" VARCHAR
);
CREATE TABLE ggs_week3_currentrankings (
"unnamed_0" VARCHAR,
"points" DOUBLE
);
CREATE TABLE ggs_week3_positions (
"guilty_gear" DOUBLE,
"university" VARCHAR,
"username" VARCHAR,
"week_1" DOUBLE,
"week_2" DOUBLE,
"week_3" DOUBLE,
"week_4" VARCHAR,
"week_5" VARCHAR,
"overall" DOUBLE,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"position" VARCHAR,
"points_earnt" DOUBLE,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR
);
CREATE TABLE loln_week1 (
"unnamed_0" BIGINT,
"team_1" VARCHAR,
"university" VARCHAR
);
CREATE TABLE loln_week1_currentrankings (
"unnamed_0" VARCHAR,
"points" DOUBLE
);
CREATE TABLE loln_week2 (
"unnamed_0" BIGINT,
"team_1" VARCHAR,
"university" VARCHAR
);
CREATE TABLE loln_week2_currentrankings (
"unnamed_0" VARCHAR,
"points" DOUBLE
);
CREATE TABLE loln_week3 (
"unnamed_0" BIGINT,
"team_1" VARCHAR,
"university" VARCHAR
);
CREATE TABLE lols_week1 (
"unnamed_0" BIGINT,
"team_1" VARCHAR,
"university" VARCHAR
);
CREATE TABLE lols_week1_currentrankings (
"unnamed_0" VARCHAR,
"points" DOUBLE
);
CREATE TABLE lols_week2 (
"unnamed_0" BIGINT,
"team_1" VARCHAR,
"university" VARCHAR
);
CREATE TABLE lols_week2_currentrankings (
"unnamed_0" VARCHAR,
"points" DOUBLE
);
CREATE TABLE lols_week3 (
"unnamed_0" BIGINT,
"team_1" VARCHAR,
"university" VARCHAR
);
CREATE TABLE lol_week3 (
"unnamed_0" BIGINT,
"team_1" VARCHAR,
"university" VARCHAR
);
CREATE TABLE lol_week3_currentrankings (
"unnamed_0" VARCHAR,
"points" DOUBLE
);
CREATE TABLE ow_week1 (
"unnamed_0" BIGINT,
"team_1" VARCHAR,
"university" VARCHAR
);
CREATE TABLE ow_week2 (
"unnamed_0" BIGINT,
"team_1" VARCHAR,
"university" VARCHAR
);
CREATE TABLE ow_week3 (
"unnamed_0" BIGINT,
"team_1" VARCHAR,
"university" VARCHAR
);
CREATE TABLE ow_week3_currentrankings (
"unnamed_0" VARCHAR,
"points" DOUBLE
);
CREATE TABLE r6_week1 (
"unnamed_0" BIGINT,
"team_1" VARCHAR,
"university" VARCHAR
);
CREATE TABLE r6_week1_currentrankings (
"unnamed_0" VARCHAR,
"points" DOUBLE
);
CREATE TABLE r6_week2 (
"unnamed_0" BIGINT,
"team_1" VARCHAR,
"university" VARCHAR
);
CREATE TABLE r6_week2_currentrankings (
"unnamed_0" VARCHAR,
"points" DOUBLE
);
CREATE TABLE r6_week3 (
"unnamed_0" BIGINT,
"team_1" VARCHAR,
"university" VARCHAR
);
CREATE TABLE r6_week3_currentrankings (
"unnamed_0" VARCHAR,
"points" DOUBLE
);
CREATE TABLE rln_week1 (
"unnamed_0" BIGINT,
"team_1" VARCHAR,
"university" VARCHAR
);
CREATE TABLE rln_week1_currentrankings (
"unnamed_0" VARCHAR,
"points" DOUBLE
);
CREATE TABLE rln_week2 (
"unnamed_0" BIGINT,
"team_1" VARCHAR,
"university" VARCHAR
);
CREATE TABLE rln_week2_currentrankings (
"unnamed_0" VARCHAR,
"points" DOUBLE
);
CREATE TABLE rln_week3 (
"unnamed_0" BIGINT,
"team_1" VARCHAR,
"university" VARCHAR
);
CREATE TABLE rls_week1 (
"unnamed_0" BIGINT,
"team_1" VARCHAR,
"university" VARCHAR
);
CREATE TABLE rls_week1_currentrankings (
"unnamed_0" VARCHAR,
"points" DOUBLE
);
CREATE TABLE rls_week2 (
"unnamed_0" BIGINT,
"team_1" VARCHAR,
"university" VARCHAR
);
CREATE TABLE rls_week2_currentrankings (
"unnamed_0" VARCHAR,
"points" DOUBLE
);
CREATE TABLE rls_week3 (
"unnamed_0" BIGINT,
"team_1" VARCHAR,
"university" VARCHAR
);
CREATE TABLE rl_week3 (
"unnamed_0" BIGINT,
"team_1" VARCHAR,
"university" VARCHAR
);
CREATE TABLE rl_week3_currentrankings (
"unnamed_0" VARCHAR,
"points" DOUBLE
);
CREATE TABLE seedings (
"unnamed_0" BIGINT,
"team_name" VARCHAR,
"team_url" VARCHAR,
"university" VARCHAR,
"seeds" DOUBLE,
"uni_seeds" BIGINT
);
CREATE TABLE sfv_week3 (
"unnamed_0" BIGINT,
"team_1" DOUBLE,
"university" VARCHAR
);
CREATE TABLE sfv_week3_positions (
"sfv" DOUBLE,
"university" VARCHAR,
"username" VARCHAR,
"week_1" DOUBLE,
"week_2" DOUBLE,
"week_3" DOUBLE,
"week_4" VARCHAR,
"week_5" VARCHAR,
"overall" DOUBLE,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"position" VARCHAR,
"points_earnt" DOUBLE,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR
);
CREATE TABLE teams_week3 (
"standings" BIGINT,
"team_1" VARCHAR,
"university" VARCHAR
);
CREATE TABLE teams_week3_currentrankings (
"unnamed_0" VARCHAR,
"points" DOUBLE
);
CREATE TABLE tekken_week3 (
"unnamed_0" BIGINT,
"team_1" DOUBLE,
"university" VARCHAR
);
CREATE TABLE tekken_week3_currentrankings (
"unnamed_0" VARCHAR,
"points" DOUBLE
);
CREATE TABLE tekken_week3_positions (
"tekken" DOUBLE,
"university" VARCHAR,
"username" VARCHAR,
"week_1" DOUBLE,
"week_2" DOUBLE,
"week_3" DOUBLE,
"week_4" VARCHAR,
"week_5" VARCHAR,
"overall" DOUBLE,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"position" VARCHAR,
"points_earnt" DOUBLE,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" DOUBLE
);
CREATE TABLE tft_week3 (
"unnamed_0" BIGINT,
"team_1" VARCHAR,
"university" VARCHAR
);
CREATE TABLE tft_week3_currentrankings (
"unnamed_0" VARCHAR,
"points" DOUBLE
);
CREATE TABLE total_week1_currentrankings (
"university" VARCHAR,
"points" DOUBLE
);
CREATE TABLE total_week2_currentrankings (
"university" VARCHAR,
"points" DOUBLE
);
CREATE TABLE total_week3_currentrankings (
"university" VARCHAR,
"points" DOUBLE
);
CREATE TABLE val_week1 (
"unnamed_0" BIGINT,
"team_1" VARCHAR,
"university" VARCHAR
);
CREATE TABLE val_week1_currentrankings (
"unnamed_0" VARCHAR,
"points" DOUBLE
);
CREATE TABLE val_week2 (
"unnamed_0" BIGINT,
"team_1" VARCHAR,
"university" VARCHAR
);
CREATE TABLE val_week2_currentrankings (
"unnamed_0" VARCHAR,
"points" DOUBLE
);
CREATE TABLE val_week3 (
"unnamed_0" BIGINT,
"team_1" VARCHAR,
"university" VARCHAR
);
CREATE TABLE val_week3_currentrankings (
"unnamed_0" VARCHAR,
"points" DOUBLE
);
CREATE TABLE week_3_positions (
"standings" BIGINT,
"team" VARCHAR,
"points" BIGINT,
"omwp" VARCHAR
);
CREATE TABLE week1_all_games (
"university" VARCHAR,
"total_points" DOUBLE,
"overwatch" DOUBLE,
"r6_siege" DOUBLE,
"dota_2" DOUBLE,
"valorant" DOUBLE,
"cs_go" DOUBLE,
"rocket_league" DOUBLE,
"league_of_legends" DOUBLE
);
CREATE TABLE week2_all_games (
"university" VARCHAR,
"total_points" DOUBLE,
"overwatch" DOUBLE,
"r6_siege" DOUBLE,
"dota_2" DOUBLE,
"valorant" DOUBLE,
"cs_go" DOUBLE,
"rocket_league" DOUBLE,
"league_of_legends" DOUBLE,
"fortnite" DOUBLE
);
CREATE TABLE week3_all_games (
"university" VARCHAR,
"total_points" DOUBLE,
"overwatch" DOUBLE,
"r6_siege" DOUBLE,
"dota_2" DOUBLE,
"cs_go" DOUBLE,
"valorant" DOUBLE,
"rocket_league" DOUBLE,
"league_of_legends" DOUBLE,
"smash_teams" DOUBLE,
"fortnite" DOUBLE,
"tekken_7_ufg" DOUBLE,
"guilty_gear_strive_ufg" DOUBLE
);
CREATE TABLE w_week1_currentrankings (
"unnamed_0" VARCHAR,
"points" DOUBLE
);
CREATE TABLE w_week2_currentrankings (
"unnamed_0" VARCHAR,
"points" DOUBLE
);
Anyone who has the link will be able to view this.