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

Games By Players

@kaggle.dylanmonfret_rlcs_202122.games_by_players

36.04 MB
106795 rows
103 columns
Only the first 100 columns are shown

game_id Game Id	color Color	team_id Team Id	team_region Team Region	player_id Player Id	player_tag Player Tag	core_shots Core Shots	core_goals Core Goals	core_saves Core Saves	core_assists Core Assists	core_score Core Score	core_shooting_percentage Core Shooting Percentage	boost_bpm Boost Bpm	boost_bcpm Boost Bcpm	boost_avg_amount Boost Avg Amount	boost_amount_collected Boost Amount Collected	boost_amount_stolen Boost Amount Stolen	boost_amount_collected_big Boost Amount Collected Big	boost_amount_stolen_big Boost Amount Stolen Big	boost_amount_collected_small Boost Amount Collected Small	boost_amount_stolen_small Boost Amount Stolen Small	boost_count_collected_big Boost Count Collected Big	boost_count_stolen_big Boost Count Stolen Big	boost_count_collected_small Boost Count Collected Small	boost_count_stolen_small Boost Count Stolen Small	boost_amount_overfill Boost Amount Overfill	boost_amount_overfill_stolen Boost Amount Overfill Stolen	boost_amount_used_while_supersonic Boost Amount Used While Supersonic	boost_time_zero_boost Boost Time Zero Boost	boost_percent_zero_boost Boost Percent Zero Boost	boost_time_full_boost Boost Time Full Boost	boost_percent_full_boost Boost Percent Full Boost	boost_time_boost_0_25 Boost Time Boost 0–25	boost_time_boost_25_50 Boost Time Boost 25–50	boost_time_boost_50_75 Boost Time Boost 50–75	boost_time_boost_75_100 Boost Time Boost 75–100	boost_percent_boost_0_25 Boost Percent Boost 0–25	boost_percent_boost_25_50 Boost Percent Boost 25–50	boost_percent_boost_50_75 Boost Percent Boost 50–75	boost_percent_boost_75_100 Boost Percent Boost 75–100	movement_avg_speed Movement Avg Speed	movement_total_distance Movement Total Distance	movement_time_supersonic_speed Movement Time Supersonic Speed	movement_time_boost_speed Movement Time Boost Speed	movement_time_slow_speed Movement Time Slow Speed	movement_time_ground Movement Time Ground	movement_time_low_air Movement Time Low Air	movement_time_high_air Movement Time High Air	movement_time_powerslide Movement Time Powerslide	movement_count_powerslide Movement Count Powerslide	movement_avg_powerslide_duration Movement Avg Powerslide Duration	movement_avg_speed_percentage Movement Avg Speed Percentage	movement_percent_slow_speed Movement Percent Slow Speed	movement_percent_boost_speed Movement Percent Boost Speed	movement_percent_supersonic_speed Movement Percent Supersonic Speed	movement_percent_ground Movement Percent Ground	movement_percent_low_air Movement Percent Low Air	movement_percent_high_air Movement Percent High Air	positioning_avg_distance_to_ball Positioning Avg Distance To Ball	positioning_avg_distance_to_ball_possession Positioning Avg Distance To Ball Possession	positioning_avg_distance_to_ball_no_possession Positioning Avg Distance To Ball No Possession	positioning_avg_distance_to_mates Positioning Avg Distance To Mates	positioning_time_defensive_third Positioning Time Defensive Third	positioning_time_neutral_third Positioning Time Neutral Third	positioning_time_offensive_third Positioning Time Offensive Third	positioning_time_defensive_half Positioning Time Defensive Half	positioning_time_offensive_half Positioning Time Offensive Half	positioning_time_behind_ball Positioning Time Behind Ball	positioning_time_in_front_ball Positioning Time In Front Ball	positioning_time_most_back Positioning Time Most Back	positioning_time_most_forward Positioning Time Most Forward	positioning_goals_against_while_last_defender Positioning Goals Against While Last Defender	positioning_time_closest_to_ball Positioning Time Closest To Ball	positioning_time_farthest_from_ball Positioning Time Farthest From Ball	positioning_percent_defensive_third Positioning Percent Defensive Third	positioning_percent_offensive_third Positioning Percent Offensive Third	positioning_percent_neutral_third Positioning Percent Neutral Third	positioning_percent_defensive_half Positioning Percent Defensive Half	positioning_percent_offensive_half Positioning Percent Offensive Half	positioning_percent_behind_ball Positioning Percent Behind Ball	positioning_percent_in_front_ball Positioning Percent In Front Ball	positioning_percent_most_back Positioning Percent Most Back	positioning_percent_most_forward Positioning Percent Most Forward	positioning_percent_closest_to_ball Positioning Percent Closest To Ball	positioning_percent_farthest_from_ball Positioning Percent Farthest From Ball	demo_inflicted Demo Inflicted	demo_taken Demo Taken	advanced_goal_participation Advanced Goal Participation	advanced_rating Advanced Rating	advanced_mvp Advanced Mvp	winner Winner	platform Platform	platform_id Platform Id	car_id Car Id	car_name Car Name	steering_sensitivity Steering Sensitivity	camera_fov Camera Fov	camera_height Camera Height	camera_pitch Camera Pitch	camera_distance Camera Distance
616004f3143c37878b238690	blue	6020bc8ef1e4807cc700391a	Oceania	5f3d8fdd95f40596eae2412e	Amphis	4	1	1		348	25	374	385.0158	45.92	2071	299	1509	183	562	116	20	2	45	10	243	16	172	32.19	9.973972	55.88	17.314247	122.85	62.7	47.71	96.02	37.308674	19.041546	14.489188	29.160593	1446	460974	38.15	123.21	173.01	170.99	128.7	34.67	6.04	66	0.09	62.869564	51.742085	36.8484	11.409517	51.139492	38.491447	10.369063	2848	2790	2850	3624	193.98	87.76	52.63	242.43	91.94	264.12	70.25	131.7	92.1		114.6	105	58.01358	15.740048	26.246374	72.50352	27.496487	78.99034	21.00966	40.806843	28.536903	35.50846	32.533928			50	0.916465350598469	true	true	steam	76561198180452118	4284	Fennec	3.05	110	100	-3	260
616004f3143c37878b238690	blue	6020bc8ef1e4807cc700391a	Oceania	5f3d8fdd95f40596eae23e01	Torsos	5		2	1	343		450	448.96823	51.26	2415	763	1466	400	949	363	16	4	87	34	169	5	304	35.93	11.132801	27.82	8.619942	110.91	55.35	76.29	85.73	33.78518	16.860605	23.239305	26.114899	1619	518367	75.39	127.57	131.52	168.23	150.2	16.05	6.15	89	0.07	70.391304	39.32074	38.1398	22.539465	50.295986	44.90553	4.798493	2829	2507	3124	3630	155.44	108.19	70.84	205.38	129.09	234.91	99.57	91.5	117.5		107.4	106.7	46.473526	21.179775	32.3467	61.40461	38.59539	70.2314	29.768595	28.350996	36.407017	33.27756	33.06067	1		50	0.9664396859422244		true	steam	76561198052159821	403	Dominus	1	110	100	-2	250
616004f3143c37878b238690	blue	6020bc8ef1e4807cc700391a	Oceania	5f3d8fdd95f40596eae23e53	Express	4	1			230	25	318	337.4233	47.91	1815	359	969	100	846	259	12	1	76	24	279	21	141	34.42	10.664931	36.14	11.197868	105.07	70.56	53.52	84.05	33.547253	22.528734	17.088121	26.835886	1462	454065	48.74	106.09	170.59	189.69	122.53	13.19	7.24	94	0.08	63.565216	52.42149	32.60095	14.977569	58.292614	37.654037	4.053348	3047	2685	3455	3835	164.31	95.11	66.01	212.25	113.17	228.04	97.38	102	117.6	1	104.8	117.2	50.490124	20.283932	29.225948	65.223404	34.7766	70.0756	29.924406	31.60439	36.438	32.47196	36.31406		3	50	0.7812243396737132		true	steam	76561198065500375	4284	Fennec	1.3	110	100	-3	260
616004f3143c37878b238690	orange	614c8930f8090ec745286474	Oceania	604e562901d675f81a96b270	mel kin	2		6		469		435	446.73734	53.41	2403	380	1721	197	682	183	22	3	62	17	227	68	376	47.33	14.665056	28.71	8.895706	119	55.34	59.07	97.36	35.976658	16.730658	17.85833	29.43435	1588	507457	57.64	144.69	132.18	207.05	105.44	22.01	10.21	83	0.12	69.04348	39.51451	43.25431	17.231173	61.898357	31.521673	6.57997	3097	2898	3308	3767	158.44	114.75	61.31	220.21	114.3	259.02	75.49	128.4	90.2	1	96.7	111.7	47.36622	18.32885	34.30493	65.83061	34.16938	77.43266	22.567339	39.784344	27.948195	29.9622	34.609905	2			0.8243007573250327			steam	76561199067761149	403	Dominus	1.51	110	90	-4	280
616004f3143c37878b238690	orange	614c8930f8090ec745286474	Oceania	5f7ca648ea8a0f0714fb9a20	Laxin	1		3		353		445	458.82135	48.43	2468	429	1730	158	738	271	21	2	61	19	389	41	340	35.27	10.928302	51.28	15.888951	109.12	86.83	64.55	71.62	32.855595	26.144165	19.435747	21.564497	1616	515947	72.27	127.63	134.54	172.99	134.68	26.76	6.86	47	0.15	70.26087	40.228443	38.162304	21.609257	51.726818	40.271503	8.001675	3039	2978	3133	3862	156.7	118.06	59.68	220.85	113.58	251.9	82.54	118.5	108.2		112	119	46.854443	17.844755	35.3008	66.037735	33.962265	75.31994	24.680061	36.71686	33.52544	34.702858	36.871788				0.457923139642106			steam	76561199073713301	23	Octane	1.75	110	90	-5	270
616004f3143c37878b238690	orange	614c8930f8090ec745286474	Oceania	5f3d8fdd95f40596eae24503	Baked Potato	1	1	1		246	100	433	445.99368	50.55	2399	535	1743	353	656	182	24	5	59	16	677	146	352	40.46	12.536407	33.45	10.36438	110.35	60.98	73.73	76.9	34.274445	18.94024	22.900362	23.884954	1632	515994	76.85	125.46	129.07	173.97	142.07	15.34	8.69	86	0.1	70.95652	38.949245	37.85986	23.190899	52.498642	42.872234	4.6291265	2757	2651	2907	3774	141.9	96.44	93.04	192.33	139.05	229.77	101.61	77.9	128.4	1	115.1	97.1	42.820927	28.076529	29.102541	58.03911	41.96089	69.33732	30.662683	24.137077	39.784344	35.663383	30.086138	1	1	100	1.2787049002988158			steam	76561198189882928	4284	Fennec	2	110	90	-5	270
616004f7143c37878b238697	blue	6020bc8ef1e4807cc700391a	Oceania	5f3d8fdd95f40596eae2412e	Amphis	4	2	1		499	50	421	409.25873	53.65	2328	530	1742	292	586	238	22	4	53	21	489	107	452	25.81	7.562262	54.26	15.898038	91.61	77.43	60.45	115.31	26.569027	22.456497	17.531902	33.442577	1597	530662	75.43	121.61	161.61	196.88	133.29	28.48	6	71	0.08	69.434784	45.060646	33.90771	21.031647	54.894745	37.164364	7.9408894	3045	2931	3254	3914	165.85	99.72	93.07	219.81	138.84	260.06	98.59	117.9	110.5		102.9	125.2	46.244144	25.950813	27.80504	61.288166	38.711838	72.5108	27.489197	34.54439	32.37621	30.14943	36.68327	2	1	50	1.3373297768656138	true	true	steam	76561198180452118	4284	Fennec	3.05	110	100	-3	260
616004f7143c37878b238697	blue	6020bc8ef1e4807cc700391a	Oceania	5f3d8fdd95f40596eae23e01	Torsos	2	1		2	414	50	443	480.1055	55.37	2731	886	1910	621	821	265	25	7	72	24	618	98	356	60.24	17.650162	37.48	10.981542	108.87	65.16	56.19	119.41	31.138632	18.636847	16.071276	34.153248	1630	546844	83.67	135.15	142.67	173.92	155.41	32.16	5.59	91	0.06	70.86957	39.467205	37.386925	23.145868	48.111977	42.991505	8.896511	2733	2718	2762	4001	165.03	105.25	91.21	213.75	147.74	259.64	101.85	125.5	122.9	1	135.1	100.3	45.652718	25.23168	29.115606	59.13027	40.869736	71.82495	28.17505	36.77117	36.009377	39.583946	29.387636	1		75	1.4978991929819068		true	steam	76561198052159821	403	Dominus	1	110	100	-2	250
616004f7143c37878b238697	blue	6020bc8ef1e4807cc700391a	Oceania	5f3d8fdd95f40596eae23e53	Express	4	1	2	1	370	25	362	373.57166	50.24	2125	410	1200	100	925	310	13	1	77	28	152	7	311	35.06	10.272489	28.15	8.247876	110.03	76.05	59.45	95.48	32.265915	22.3014	17.433506	27.999178	1507	503930	54.02	123.55	183.68	219.87	124.88	16.5	9.05	121	0.07	65.521736	50.84568	34.200695	14.953634	60.863667	34.56886	4.567474	3144	3092	3204	3885	177.07	103.54	80.64	226.18	135.07	260.31	100.94	105.2	107.1	1	103.1	122.5	49.01591	22.322489	28.661589	62.610382	37.38962	72.05813	27.941868	30.823324	31.380018	30.208029	35.892178	2		50	1.2868205021985035		true	steam	76561198065500375	4284	Fennec	1.3	110	100	-3	260
616004f7143c37878b238697	orange	614c8930f8090ec745286474	Oceania	5f3d8fdd95f40596eae24503	Baked Potato	2	2	2		455	100	433	447.40698	49.89	2545	197	1755		790	197	21		69	18	350		301	20.58	6.029886	18.12	5.3091125	99.69	103.77	67.01	74.66	28.884768	30.06693	19.415873	21.63243	1552	509929	75.48	110.43	169.68	189.28	147.27	19.05	8.2	90	0.09	67.478264	47.717876	31.05543	21.226696	53.22835	41.414513	5.357143	3128	3106	3163	3944	179.97	116.81	58.82	233.76	121.84	247.69	107.91	99.3	126.1	1	120.3	102.8	50.610237	16.541058	32.848705	65.736786	34.263218	69.654106	30.345894	29.094639	36.946968	35.247585	30.12013		2	100	1.7175877065097929			steam	76561198189882928	4284	Fennec	2	110	90	-5	270


CREATE TABLE games_by_players (
  "game_id" VARCHAR,
  "color" VARCHAR,
  "team_id" VARCHAR,
  "team_region" VARCHAR,
  "player_id" VARCHAR,
  "player_tag" VARCHAR,
  "core_shots" BIGINT,
  "core_goals" BIGINT,
  "core_saves" BIGINT,
  "core_assists" BIGINT,
  "core_score" BIGINT,
  "core_shooting_percentage" DOUBLE,
  "boost_bpm" DOUBLE,
  "boost_bcpm" DOUBLE,
  "boost_avg_amount" DOUBLE,
  "boost_amount_collected" DOUBLE,
  "boost_amount_stolen" DOUBLE,
  "boost_amount_collected_big" DOUBLE,
  "boost_amount_stolen_big" DOUBLE,
  "boost_amount_collected_small" DOUBLE,
  "boost_amount_stolen_small" DOUBLE,
  "boost_count_collected_big" DOUBLE,
  "boost_count_stolen_big" DOUBLE,
  "boost_count_collected_small" DOUBLE,
  "boost_count_stolen_small" DOUBLE,
  "boost_amount_overfill" DOUBLE,
  "boost_amount_overfill_stolen" DOUBLE,
  "boost_amount_used_while_supersonic" DOUBLE,
  "boost_time_zero_boost" DOUBLE,
  "boost_percent_zero_boost" DOUBLE,
  "boost_time_full_boost" DOUBLE,
  "boost_percent_full_boost" DOUBLE,
  "boost_time_boost_0_25" DOUBLE,
  "boost_time_boost_25_50" DOUBLE,
  "boost_time_boost_50_75" DOUBLE,
  "boost_time_boost_75_100" DOUBLE,
  "boost_percent_boost_0_25" DOUBLE,
  "boost_percent_boost_25_50" DOUBLE,
  "boost_percent_boost_50_75" DOUBLE,
  "boost_percent_boost_75_100" DOUBLE,
  "movement_avg_speed" DOUBLE,
  "movement_total_distance" DOUBLE,
  "movement_time_supersonic_speed" DOUBLE,
  "movement_time_boost_speed" DOUBLE,
  "movement_time_slow_speed" DOUBLE,
  "movement_time_ground" DOUBLE,
  "movement_time_low_air" DOUBLE,
  "movement_time_high_air" DOUBLE,
  "movement_time_powerslide" DOUBLE,
  "movement_count_powerslide" DOUBLE,
  "movement_avg_powerslide_duration" DOUBLE,
  "movement_avg_speed_percentage" DOUBLE,
  "movement_percent_slow_speed" DOUBLE,
  "movement_percent_boost_speed" DOUBLE,
  "movement_percent_supersonic_speed" DOUBLE,
  "movement_percent_ground" DOUBLE,
  "movement_percent_low_air" DOUBLE,
  "movement_percent_high_air" DOUBLE,
  "positioning_avg_distance_to_ball" DOUBLE,
  "positioning_avg_distance_to_ball_possession" DOUBLE,
  "positioning_avg_distance_to_ball_no_possession" DOUBLE,
  "positioning_avg_distance_to_mates" DOUBLE,
  "positioning_time_defensive_third" DOUBLE,
  "positioning_time_neutral_third" DOUBLE,
  "positioning_time_offensive_third" DOUBLE,
  "positioning_time_defensive_half" DOUBLE,
  "positioning_time_offensive_half" DOUBLE,
  "positioning_time_behind_ball" DOUBLE,
  "positioning_time_in_front_ball" DOUBLE,
  "positioning_time_most_back" DOUBLE,
  "positioning_time_most_forward" DOUBLE,
  "positioning_goals_against_while_last_defender" DOUBLE,
  "positioning_time_closest_to_ball" DOUBLE,
  "positioning_time_farthest_from_ball" DOUBLE,
  "positioning_percent_defensive_third" DOUBLE,
  "positioning_percent_offensive_third" DOUBLE,
  "positioning_percent_neutral_third" DOUBLE,
  "positioning_percent_defensive_half" DOUBLE,
  "positioning_percent_offensive_half" DOUBLE,
  "positioning_percent_behind_ball" DOUBLE,
  "positioning_percent_in_front_ball" DOUBLE,
  "positioning_percent_most_back" DOUBLE,
  "positioning_percent_most_forward" DOUBLE,
  "positioning_percent_closest_to_ball" DOUBLE,
  "positioning_percent_farthest_from_ball" DOUBLE,
  "demo_inflicted" DOUBLE,
  "demo_taken" DOUBLE,
  "advanced_goal_participation" DOUBLE,
  "advanced_rating" DOUBLE,
  "advanced_mvp" BOOLEAN,
  "winner" BOOLEAN,
  "platform" VARCHAR,
  "platform_id" VARCHAR,
  "car_id" DOUBLE,
  "car_name" VARCHAR,
  "steering_sensitivity" DOUBLE,
  "camera_fov" DOUBLE,
  "camera_height" DOUBLE,
  "camera_pitch" DOUBLE,
  "camera_distance" DOUBLE
);