2023 F1 Season
Official results across all races
@kaggle.jdaustralia_2023_f1_season
Official results across all races
@kaggle.jdaustralia_2023_f1_season
This dataset separates points between the 3 different avenues drivers have to score points 1) regular Race, 2) Sprint Race and 3) Fastest Lap.
Which driver from the bottom 10 scored more fastest laps points than several of the top 10 drivers?
Were the Sprint Races worth the effort? Did they change the results?
Which teams did better at the sprint races than the regular ones?
CREATE TABLE f1_2023_fastest_lap (
"driver" VARCHAR,
"bhr" DOUBLE,
"sau" DOUBLE,
"aus" DOUBLE,
"aze" DOUBLE,
"mia" DOUBLE,
"mon" DOUBLE,
"esp" DOUBLE,
"can" DOUBLE,
"aut" DOUBLE,
"gbr" DOUBLE,
"hun" DOUBLE,
"bel" DOUBLE,
"ned" DOUBLE,
"ita" DOUBLE,
"sin" DOUBLE,
"jpn" DOUBLE,
"qat" DOUBLE,
"usa" DOUBLE,
"mxc" DOUBLE,
"sap" DOUBLE,
"lvg" DOUBLE,
"abu" DOUBLE
);CREATE TABLE f1_2023_regular (
"driver" VARCHAR,
"team" VARCHAR,
"bhr" VARCHAR,
"sau" VARCHAR,
"aus" VARCHAR,
"aze" VARCHAR,
"mia" DOUBLE,
"mon" VARCHAR,
"esp" DOUBLE,
"can" VARCHAR,
"aut" VARCHAR,
"gbr" VARCHAR,
"hun" VARCHAR,
"bel" DOUBLE,
"ned" VARCHAR,
"ita" VARCHAR,
"sin" VARCHAR,
"jpn" VARCHAR,
"qat" VARCHAR,
"usa" VARCHAR,
"mxc" VARCHAR,
"sap" VARCHAR,
"lvg" VARCHAR,
"abu" DOUBLE
);CREATE TABLE f1_2023_sprints (
"driver" VARCHAR,
"aze" DOUBLE,
"aut" DOUBLE,
"bel" DOUBLE,
"qat" DOUBLE,
"usa" DOUBLE,
"sap" DOUBLE
);CREATE TABLE scoring (
"place" BIGINT,
"race" BIGINT,
"sprint" DOUBLE,
"fastest_lap" DOUBLE
);CREATE TABLE wind_tunnel_allowance (
"rank" BIGINT,
"time" VARCHAR
);Anyone who has the link will be able to view this.