Rocket League Championship Series 2021-2022

RLCS 2021-22 Dataset - Games details collected with octane.gg & ballchasing.com

@kaggle.dylanmonfret_rlcs_202122

Table List

6 tables(55.5 MB)

Main

Main

@kaggle.dylanmonfret_rlcs_202122.main

1.26 MB
18740 rows
36 columns

event_id Event Id	event Event	event_split Event Split	event_region Event Region	event_slug Event Slug	event_start_date Event Start Date	event_end_date Event End Date	event_tier Event Tier	event_phase Event Phase	stage Stage	stage_start_date Stage Start Date	stage_end_date Stage End Date	stage_is_qualifier Stage Is Qualifier	liquipedia_link Liquipedia Link	location_venue Location Venue	location_city Location City	location_country Location Country	match_id Match Id	match_slug Match Slug	match_number Match Number	match_round Match Round	match_date Match Date	match_format Match Format	game_id Game Id	game_number Game Number	game_date Game Date	game_duration Game Duration	map_id Map Id	map_name Map Name	overtime Overtime	ballchasing_id Ballchasing Id
614b7046f8090ec74528642d	Regional 1	Fall	Oceania	https://octane.gg/events/642d-rlcs-2021-22-fall-oceania-regional-1	2021-10-07 23:00:00+00:00	2021-10-17 22:30:00+00:00	Qualifier	Invitational Qualifier	Swiss Stage	2021-10-08 06:00:00+00:00	2021-10-08 22:30:00+00:00	true	https://liquipedia.net/rocketleague/Rocket_League_Championship_Series/2021-22/Fall/Oceania/1/Invitational_Qualifier	nan	nan	nan	6159ad3d143c37878b2384a9	https://octane.gg/matches/84a9-ground-zero-gaming-vs-ranga-roundup	1	Round 1	2021-10-08 06:00:00+00:00	best-of-5	616004f3143c37878b238690	1	2021-10-08 06:08:23+00:00	300	stadium_p	DFH Stadium	False	15f12bd9-f4a6-4cea-a2dc-610cd9dd976b
614b7046f8090ec74528642d	Regional 1	Fall	Oceania	https://octane.gg/events/642d-rlcs-2021-22-fall-oceania-regional-1	2021-10-07 23:00:00+00:00	2021-10-17 22:30:00+00:00	Qualifier	Invitational Qualifier	Swiss Stage	2021-10-08 06:00:00+00:00	2021-10-08 22:30:00+00:00	true	https://liquipedia.net/rocketleague/Rocket_League_Championship_Series/2021-22/Fall/Oceania/1/Invitational_Qualifier	nan	nan	nan	6159ad3d143c37878b2384a9	https://octane.gg/matches/84a9-ground-zero-gaming-vs-ranga-roundup	1	Round 1	2021-10-08 06:00:00+00:00	best-of-5	616004f7143c37878b238697	2	2021-10-08 06:16:09+00:00	300	stadium_p	DFH Stadium	False	2f01deab-3f2f-412f-a70e-72b39b3b204a
614b7046f8090ec74528642d	Regional 1	Fall	Oceania	https://octane.gg/events/642d-rlcs-2021-22-fall-oceania-regional-1	2021-10-07 23:00:00+00:00	2021-10-17 22:30:00+00:00	Qualifier	Invitational Qualifier	Swiss Stage	2021-10-08 06:00:00+00:00	2021-10-08 22:30:00+00:00	true	https://liquipedia.net/rocketleague/Rocket_League_Championship_Series/2021-22/Fall/Oceania/1/Invitational_Qualifier	nan	nan	nan	6159ad3d143c37878b2384a9	https://octane.gg/matches/84a9-ground-zero-gaming-vs-ranga-roundup	1	Round 1	2021-10-08 06:00:00+00:00	best-of-5	616004fc143c37878b23869e	3	2021-10-08 06:23:31+00:00	326	stadium_p	DFH Stadium	True	3b0fc17c-6f8d-4e94-a625-e0fa988d7cc0
614b7046f8090ec74528642d	Regional 1	Fall	Oceania	https://octane.gg/events/642d-rlcs-2021-22-fall-oceania-regional-1	2021-10-07 23:00:00+00:00	2021-10-17 22:30:00+00:00	Qualifier	Invitational Qualifier	Swiss Stage	2021-10-08 06:00:00+00:00	2021-10-08 22:30:00+00:00	true	https://liquipedia.net/rocketleague/Rocket_League_Championship_Series/2021-22/Fall/Oceania/1/Invitational_Qualifier	nan	nan	nan	6159ad3d143c37878b2384aa	https://octane.gg/matches/84aa-renegades-vs-trident-esports	2	Round 1	2021-10-08 06:00:00+00:00	best-of-5	61614e40f8090ec74528706b	1	2021-10-08 06:10:54+00:00	300	stadium_p	DFH Stadium	False	6e5e523a-3299-42d1-8b34-7ac0baa1b771
614b7046f8090ec74528642d	Regional 1	Fall	Oceania	https://octane.gg/events/642d-rlcs-2021-22-fall-oceania-regional-1	2021-10-07 23:00:00+00:00	2021-10-17 22:30:00+00:00	Qualifier	Invitational Qualifier	Swiss Stage	2021-10-08 06:00:00+00:00	2021-10-08 22:30:00+00:00	true	https://liquipedia.net/rocketleague/Rocket_League_Championship_Series/2021-22/Fall/Oceania/1/Invitational_Qualifier	nan	nan	nan	6159ad3d143c37878b2384aa	https://octane.gg/matches/84aa-renegades-vs-trident-esports	2	Round 1	2021-10-08 06:00:00+00:00	best-of-5	61614e45143c37878b2387b8	2	2021-10-08 06:18:58+00:00	300	stadium_p	DFH Stadium	False	95bfed45-3271-407b-9188-a278dfa8f66e
614b7046f8090ec74528642d	Regional 1	Fall	Oceania	https://octane.gg/events/642d-rlcs-2021-22-fall-oceania-regional-1	2021-10-07 23:00:00+00:00	2021-10-17 22:30:00+00:00	Qualifier	Invitational Qualifier	Swiss Stage	2021-10-08 06:00:00+00:00	2021-10-08 22:30:00+00:00	true	https://liquipedia.net/rocketleague/Rocket_League_Championship_Series/2021-22/Fall/Oceania/1/Invitational_Qualifier	nan	nan	nan	6159ad3d143c37878b2384aa	https://octane.gg/matches/84aa-renegades-vs-trident-esports	2	Round 1	2021-10-08 06:00:00+00:00	best-of-5	61614e4a143c37878b2387bf	3	2021-10-08 06:26:28+00:00	300	stadium_p	DFH Stadium	False	fc03d314-c17f-4d50-a3b7-f2da81b2dba3
614b7046f8090ec74528642d	Regional 1	Fall	Oceania	https://octane.gg/events/642d-rlcs-2021-22-fall-oceania-regional-1	2021-10-07 23:00:00+00:00	2021-10-17 22:30:00+00:00	Qualifier	Invitational Qualifier	Swiss Stage	2021-10-08 06:00:00+00:00	2021-10-08 22:30:00+00:00	true	https://liquipedia.net/rocketleague/Rocket_League_Championship_Series/2021-22/Fall/Oceania/1/Invitational_Qualifier	nan	nan	nan	6159ad3d143c37878b2384ab	https://octane.gg/matches/84ab-dire-wolves-vs-team-eros	3	Round 1	2021-10-08 06:00:00+00:00	best-of-5	616150a6f8090ec74528710c	1	2021-10-08 06:06:28+00:00	300	stadium_p	DFH Stadium	False	c742de92-3625-46f7-80e1-b5686d50a4ec
614b7046f8090ec74528642d	Regional 1	Fall	Oceania	https://octane.gg/events/642d-rlcs-2021-22-fall-oceania-regional-1	2021-10-07 23:00:00+00:00	2021-10-17 22:30:00+00:00	Qualifier	Invitational Qualifier	Swiss Stage	2021-10-08 06:00:00+00:00	2021-10-08 22:30:00+00:00	true	https://liquipedia.net/rocketleague/Rocket_League_Championship_Series/2021-22/Fall/Oceania/1/Invitational_Qualifier	nan	nan	nan	6159ad3d143c37878b2384ab	https://octane.gg/matches/84ab-dire-wolves-vs-team-eros	3	Round 1	2021-10-08 06:00:00+00:00	best-of-5	616150aa143c37878b238860	2	2021-10-08 06:14:06+00:00	300	stadium_p	DFH Stadium	False	a2c14d49-cd7f-4969-bf00-bb6da63e33af
614b7046f8090ec74528642d	Regional 1	Fall	Oceania	https://octane.gg/events/642d-rlcs-2021-22-fall-oceania-regional-1	2021-10-07 23:00:00+00:00	2021-10-17 22:30:00+00:00	Qualifier	Invitational Qualifier	Swiss Stage	2021-10-08 06:00:00+00:00	2021-10-08 22:30:00+00:00	true	https://liquipedia.net/rocketleague/Rocket_League_Championship_Series/2021-22/Fall/Oceania/1/Invitational_Qualifier	nan	nan	nan	6159ad3d143c37878b2384ab	https://octane.gg/matches/84ab-dire-wolves-vs-team-eros	3	Round 1	2021-10-08 06:00:00+00:00	best-of-5	616150ae143c37878b238867	3	2021-10-08 06:23:00+00:00	462	stadium_p	DFH Stadium	True	16266154-7a8f-43e8-9685-c29735861f42
614b7046f8090ec74528642d	Regional 1	Fall	Oceania	https://octane.gg/events/642d-rlcs-2021-22-fall-oceania-regional-1	2021-10-07 23:00:00+00:00	2021-10-17 22:30:00+00:00	Qualifier	Invitational Qualifier	Swiss Stage	2021-10-08 06:00:00+00:00	2021-10-08 22:30:00+00:00	true	https://liquipedia.net/rocketleague/Rocket_League_Championship_Series/2021-22/Fall/Oceania/1/Invitational_Qualifier	nan	nan	nan	6159ad3d143c37878b2384ab	https://octane.gg/matches/84ab-dire-wolves-vs-team-eros	3	Round 1	2021-10-08 06:00:00+00:00	best-of-5	616150b3f8090ec745287113	4	2021-10-08 06:29:44+00:00	300	stadium_p	DFH Stadium	False	08de2364-775f-4bb8-bbe1-446eeea83517


CREATE TABLE main (
  "event_id" VARCHAR,
  "event" VARCHAR,
  "event_split" VARCHAR,
  "event_region" VARCHAR,
  "event_slug" VARCHAR,
  "event_start_date" VARCHAR,
  "event_end_date" VARCHAR,
  "event_tier" VARCHAR,
  "event_phase" VARCHAR,
  "prize_money" DOUBLE,
  "stage_step" BIGINT,
  "stage" VARCHAR,
  "stage_start_date" VARCHAR,
  "stage_end_date" VARCHAR,
  "stage_is_lan" BOOLEAN,
  "stage_is_qualifier" BOOLEAN,
  "liquipedia_link" VARCHAR,
  "location_venue" VARCHAR,
  "location_city" VARCHAR,
  "location_country" VARCHAR,
  "match_id" VARCHAR,
  "match_slug" VARCHAR,
  "match_number" BIGINT,
  "match_round" VARCHAR,
  "match_date" VARCHAR,
  "match_format" VARCHAR,
  "reverse_sweep_attempt" BOOLEAN,
  "reverse_sweep" BOOLEAN,
  "game_id" VARCHAR,
  "game_number" DOUBLE,
  "game_date" VARCHAR,
  "game_duration" DOUBLE,
  "map_id" VARCHAR,
  "map_name" VARCHAR,
  "overtime" VARCHAR,
  "ballchasing_id" VARCHAR
);