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

Matches By Players

@kaggle.dylanmonfret_rlcs_202122.matches_by_players

11.18 MB
26176 rows
90 columns

match_id Match Id	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	score Score	winner Winner
6159ad3d143c37878b2384a9	6020bc8ef1e4807cc700391a	Oceania	5f3d8fdd95f40596eae2412e	Amphis	9	3	4		1119	33.33333333333333	1192	1227.67603	147.1	7014	1473	5013	831	2001	642	64	10	175	57	1217	189	1029	96.72	9.410592	154.53	15.158013000000002	357.11	210.62	183.16	286.85	34.367967	20.293845	17.548250333333332	27.78994033333333	4634	1555370	183.1	390.11	496.21	576.48	408.3200000000001	84.61000000000001	18.98	221	0.25	67.15941933333333	46.577708	36.452000000000005	16.970291666666668	53.818887	38.177336333333336	8.003778033333333	9124	8449	9634	11462	514.91	319.44000000000005	235.06	681.09	388.33	796.19	273.23	369	338.4		330	361.9	48.486190666666666	21.810520333333333	29.703288	63.978205333333335	36.021796	74.589115	25.410882666666662	36.11094633333334	32.80828433333333	32.24450733333333	35.198802	2	2	33.33333333333333	0.8635897243705898	3	true
6159ad3d143c37878b2384a9	6020bc8ef1e4807cc700391a	Oceania	5f3d8fdd95f40596eae23e01	Torsos	13	2	2	5	1209	15.384615384615383	1394	1457.44233	159.8	8334	2568	5922	1691	2412	877	74	19	220	79	1585	232	1137	149.9	14.541561666666666	111.74	10.809835	334.25	199.85	210.34000000000003	312.17	31.716968999999995	18.816024	19.956797	29.51020833333333	4900	1654179	241.3	421.65	412.52	511.92	475.67	87.86999999999999	18.78	277	0.2	71.01449466666666	38.41284566666667	39.13516966666666	22.45198433333333	47.71477266666667	44.236601666666665	8.048624	8436	8051	8907	11498	467.72	336.47	271.26	615.49	459.97	766.68	308.79	310.3	362.1	1	382.5	333.4	43.64277466666667	25.063184000000003	31.29404433333333	57.425548	42.574454	71.25462	28.74537833333333	30.298074666666665	35.34444133333333	37.17780133333333	32.454502	2		77.77777777777779	1.3505002701790778	3	true
6159ad3d143c37878b2384a9	6020bc8ef1e4807cc700391a	Oceania	5f3d8fdd95f40596eae23e53	Express	12	4	2	2	1077	33.33333333333333	1039	1071.63803	147.44	6116	1269	3425	426	2691	843	41	5	234	76	795	101	610	98.98	9.695380666666669	104.64	10.197178999999998	324.79	233.44	191.97	264.08	32.09222933333333	22.98163	18.820601666666665	26.105536	4472	1485149	154.37	369.74	536.05	631.65	390.15	38.35	25.48	342	0.22	64.811592	50.645939	34.77089733333333	14.583170666666666	59.53990566666667	36.81359566666666	3.646497266666667	9079	8771	9412	11531	515.71	317.32	227.13	671.41	388.75	776.9100000000001	283.25	365.1	329.1	4	316.29999999999995	349.1	48.727744666666666	21.38503366666667	29.887221	63.404322	36.59568000000001	73.13139000000001	26.868613	35.34802966666666	32.21873466666667	30.87436233333333	34.14185466666667	2	5	66.66666666666666	1.2329701497214296	3	true
6159ad3d143c37878b2384a9	614c8930f8090ec745286474	Oceania	5f7ca648ea8a0f0714fb9a20	Laxin	5	1	8	1	1086	20	1388	1458.91027	140.51	8329	1355	6151	712	2178	643	77	8	182	51	1635	95	1348	140.22	13.571320333333333	136.77	13.364037666666666	409.1	224.72000000000003	155.64	258.93	38.82737266666667	21.57422366666667	14.928377	24.670027666666662	4890	1638271	255.21	386.92	427.21	546.98	453.02	69.34	22.6	169	0.4	70.86956466666668	39.871989	36.25013466666667	23.877881	51.12699366666667	42.336237	6.536765066666668	9433	8803	9864	11897	552.4599999999999	342.4	174.48	737.9300000000001	331.39	767.63	301.71000000000004	343.8	362.9	3	346.5	371.2	51.49969633333333	16.385159333333334	32.11514433333334	68.92927166666668	31.070729666666665	71.94428666666667	28.05571466666667	33.660595	35.30661666666666	33.799467	36.263424333333326	1	2	40	0.8066917503515579
6159ad3d143c37878b2384a9	614c8930f8090ec745286474	Oceania	5f3d8fdd95f40596eae24503	Baked Potato	4	3	4		948	75	1276	1327.96231	154.28	7566	1416	5230	763	2336	653	66	10	211	58	1405	235	836	93.34	9.162817333333336	79.03	7.752903000000001	303.72	254	207.3	276.84000000000003	29.385293	24.273926	20.02548733333333	26.315296333333333	4793	1600293	216.66	389.54	460.26	575.1	438.88	52.48	27.8	286	0.29	69.463768	43.075623666666665	36.46794666666667	20.456431	53.85112833333333	41.231099	4.917772933333333	8527	8139	8896	11371	516.4	339.42	210.65	692.6500000000001	373.81	744.58	321.89	303.79999999999995	360.2	3	368	284.1	48.23068866666667	20.03647733333333	31.732833	64.67312866666667	35.32687266666667	69.793544	30.206457	29.400720000000003	35.309531666666665	35.846261	27.821551	3	3	60	1.0779828559566502
6159ad3d143c37878b2384a9	614c8930f8090ec745286474	Oceania	604e562901d675f81a96b270	mel kin	6	1	9	2	1105	16.666666666666664	1238	1295.08936	147.62	7375	879	5272	436	2103	443	60	6	189	39	514	129	705	163.86	15.958719	97.2	9.446478666666666	347.52000000000004	256.64	185.39	263.81	33.064602666666666	24.18524366666667	17.643032	25.107119333333333	4571	1536204	142.61	435.13	495.03	650.6	368.44	53.71000000000001	32.36	247	0.39	66.24637533333335	45.97739166666667	40.61789666666667	13.404713666666666	60.67130699999999	34.28896133333333	5.0397302	9386	8608	10039	11602	552.22	378.89	141.65	778.98	293.79	806.05	266.7	392.2	305.7	3	311.8	384.1	51.35870933333333	13.31446333333333	35.326829000000004	72.42823466666665	27.571763	75.26231033333333	24.737688	38.306270000000005	29.683877666666664	30.39049033333333	37.26207233333333	3	1	60	0.9871190711068346
6159ad3d143c37878b2384aa	6020bc70f1e4807cc70023fb	Oceania	5f3d8fdd95f40596eae24077	Fever	13	5	6	9	1971	38.46153846153847	1206	1331.29212	158.76	8017	1440	5412	593	2605	847	68	7	234	71	1395	130	749	83.4	7.670554333333333	106.73	9.824756333333337	311.92	276.55	200.34000000000003	348.77	27.44771633333333	24.238693666666663	17.592479333333333	30.721116666666664	4822	1702092	197.79	481.77	483.94999999999993	599.95	481.98	81.6	25.49	231	0.33	69.88405866666666	41.574272666666666	41.413769333333335	17.011961333333332	51.54795533333333	41.41399733333333	7.0380457000000005	8514	8401	8656	11662	480.54	433.98	249.00000000000003	704.81	458.72	940.35	223.18	434.50000000000006	295.3	2	393.7000000000001	327.9	41.30532233333333	21.40049833333333	37.29417866666666	60.57260533333334	39.427393	80.82934166666666	19.17066	40.03621833333333	27.155714666666668	36.237765	30.21401533333333	5	1	66.66666666666666	2.248581732361062	3	true
6159ad3d143c37878b2384aa	6020bc70f1e4807cc70023fb	Oceania	5f3d8fdd95f40596eae23e36	Kamii	14	4	3	6	1381	28.57142857142857	1290	1443.59769	161.28	8715	2344	6142	1473	2573	871	81	19	239	81	2020	453	818	105.13	9.695212666666666	135.07999999999998	12.3979285	369.75	267.55	148.34	353.91	32.446976	23.49386233333333	12.985106	31.07405733333333	4819	1695622	202.83	468.36	492.53	642.52	431.66	89.52	27.11	233	0.35	69.84057800000001	42.387134	40.185628	17.427235999999997	55.19134433333334	37.09717933333334	7.711475566666667	9425	9075	9852	11789	459.29	415.98	288.44	673.5	490.15	888.19	275.52	375	310.7	1	330.1	388.4	39.50385366666666	24.78010466666667	35.71603966666667	57.903525	42.096475	76.37557966666667	23.624415	34.576085666666664	28.605074	30.40530833333333	35.777341	3	1	47.61904761904761	1.6199790880596066	3	true
6159ad3d143c37878b2384aa	6020bc70f1e4807cc70023fb	Oceania	5f3d8fdd95f40596eae23e59	CJCJ	19	12	1	6	2319	63.1578947368421	1349	1452.65314	149.53	8762	2731	6568	1876	2194	855	74	22	203	78	874	345	1152	132.92000000000002	12.246809	69.54	6.397288033333332	405.59	276.41	168.73000000000002	278	35.862002	24.582719	14.909396333333332	24.645880666666667	4882	1700298	199.48	481.07	470.5	611.8	472.1	67.16	27.69	303	0.27	70.75362466666667	40.83783333333333	41.802709666666665	17.359453	53.213962	40.953786	5.832250533333333	9307	9024	9761	12095	398.54	397.19999999999993	355.32	594.34	556.74	787.5200000000001	363.55	276.1	465.6	1	347.6	369.5	34.620326	30.89667533333333	34.482994999999995	51.63508433333333	48.36491433333333	68.41662833333334	31.583367	25.35809433333333	42.932479	32.03197533333333	33.997749	3	5	85.71428571428571	2.648210742501055	3	true
6159ad3d143c37878b2384aa	6156d4db143c37878b238367	Oceania	5f5ae860c6cbf591c568a505	Viic	7	1	4	2	956	14.285714285714285	1151	1220.1578	133.49	7354	1151	5607	749	1747	402	64	9	146	27	737	150	797	181.97	16.730108333333334	113.22	10.453285466666664	422.75	272.66	163.11	246.38	38.28466466666666	24.647093	14.823013333333334	22.245234	4912	1711383	212.38	477.42	462.0700000000001	639.2099999999999	458.81000000000006	53.84	14.07	147	0.28	71.188408	40.133596	41.448752000000006	18.417649	55.50577733333333	39.83342266666667	4.660803866666667	8371	8116	8560	10587	668.29	332.57000000000005	151	865.27	286.58000000000004	781.4200000000001	370.45	355.3	330.6	9	367.6	333.6	58.123091666666674	13.055768466666668	28.82114233333333	75.19556533333333	24.804433666666668	67.84245866666667	32.157545666666664	32.753691	30.41645133333333	33.83726766666667	30.699959000000003	4	4	75	0.8034424832560458


CREATE TABLE matches_by_players (
  "match_id" VARCHAR,
  "team_id" VARCHAR,
  "team_region" VARCHAR,
  "player_id" VARCHAR,
  "player_tag" VARCHAR,
  "core_shots" DOUBLE,
  "core_goals" DOUBLE,
  "core_saves" DOUBLE,
  "core_assists" DOUBLE,
  "core_score" DOUBLE,
  "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,
  "score" DOUBLE,
  "winner" BOOLEAN
);