Formula 2 Championship (updated After Every Race)
FIA official information (all 'F2' seasons)
@kaggle.alarchemn_formula_2_dataset
FIA official information (all 'F2' seasons)
@kaggle.alarchemn_formula_2_dataset
The FIA Formula 2 Championship is a second-tier single-seater championship organized by the Fédération Internationale de l'Automobile (FIA). The championship was introduced in 2017, following the rebranding of the long-term Formula One feeder series GP2.
In addition to being the championship that awards the most points for the FIA Superlicence, it has been the previous step for many F1 drivers such as Charles Leclerc, George Russell, Lando Norris, Yuki Tsunoda, Guanyu Zhou and others.
The information is divided into 5 files that correspond to each event. Not all events take place every week (for example the sprint race). The columns are:
LAPS: Total laps traveled by the pilotTIME: Total event time GAP: Distance from pilot to race leader (seconds)INT: Distance to the next pilot (seconds)KPH: Speed (mean)BEST: Best time lapLAP: Lap for the best timePOS: Final position of the eventCAR: Car numberPILOT NAME: Pilot nameTEAM: ConstructorCIRCUIT: Circuit nameTYPE: Type of the eventROUND: Round (from 1 to total races per season)DATE: Date of the feature raceLAP SET ON: Hot lap (fastest) for the QualiQUALI TYPE: multi-session indicator of qualiYou can visit the source code of the data pipeline in GitHub
CREATE TABLE feature_race (
"laps" BIGINT,
"time" VARCHAR,
"gap" VARCHAR,
"int" VARCHAR -- INT.,
"kph" DOUBLE,
"best" VARCHAR,
"lap" DOUBLE,
"pos" DOUBLE,
"car" BIGINT,
"pilot_name" VARCHAR,
"team" VARCHAR,
"circuit" VARCHAR,
"type" VARCHAR,
"round" VARCHAR,
"date" TIMESTAMP
);CREATE TABLE free_practice (
"laps" VARCHAR,
"time" VARCHAR,
"gap" VARCHAR,
"int" VARCHAR -- INT.,
"kph" VARCHAR,
"pos" DOUBLE,
"car" BIGINT,
"pilot_name" VARCHAR,
"team" VARCHAR,
"circuit" VARCHAR,
"type" VARCHAR,
"lap_set_on" VARCHAR,
"round" VARCHAR,
"date" TIMESTAMP
);CREATE TABLE qualifying_session (
"laps" BIGINT,
"time" VARCHAR,
"gap" VARCHAR,
"int" VARCHAR -- INT.,
"kph" VARCHAR,
"pos" DOUBLE,
"car" BIGINT,
"pilot_name" VARCHAR,
"team" VARCHAR,
"circuit" VARCHAR,
"type" VARCHAR,
"lap_set_on" VARCHAR,
"round" VARCHAR,
"date" TIMESTAMP,
"quali_type" VARCHAR
);CREATE TABLE sprint_race (
"laps" BIGINT,
"time" VARCHAR,
"gap" VARCHAR,
"int" VARCHAR -- INT.,
"kph" DOUBLE,
"best" VARCHAR,
"lap" VARCHAR,
"pos" DOUBLE,
"car" BIGINT,
"pilot_name" VARCHAR,
"team" VARCHAR,
"circuit" VARCHAR,
"type" VARCHAR,
"round" VARCHAR,
"date" TIMESTAMP
);CREATE TABLE sprint_race_2 (
"laps" BIGINT,
"time" VARCHAR,
"gap" VARCHAR,
"int" VARCHAR -- INT.,
"kph" DOUBLE,
"best" VARCHAR,
"lap" DOUBLE,
"pos" DOUBLE,
"car" BIGINT,
"pilot_name" VARCHAR,
"team" VARCHAR,
"circuit" VARCHAR,
"type" VARCHAR,
"round" VARCHAR,
"date" TIMESTAMP
);Anyone who has the link will be able to view this.