Search results
F1DB is the most comprehensive free open source database with all-time Formula 1 racing data and statistics. Whether you are building a custom website, mobile application or just using F1DB to query data, here is what we provide: All drivers; All constructors (including chassis) All engine manufacturers (including engines) All tyre manufacturers
Performance Analysis: Using SQL and Tableau, the project delves into various aspects of Formula 1 racing, such as driver performance across seasons, race track statistics, and the impact of rule changes.
1 maj 2012 · We grab rows where the date column is on or after the most recent midnight (today's date with time 00:00:00), and before the next midnight (tomorrow's date with time 00:00:00, but excluding anything with that exact value). For pure date types, we can do a simple comparison with today's date.
Project based on Formula 1 World Championship (1950 - 2022). The dataset consists of all information on the Formula 1 races, drivers, constructors, qualifying, circuits, lap times, pit stops, championships from 1950 till the latest 2021 season.
%% sql f1_drivers_win_count << Select driver_name, COUNT (driver_name) AS frequency FROM (SELECT concat (forename, ' ', surname) AS driver_name FROM results AS r INNER JOIN constructors AS c ON r. constructorId = c. constructorId INNER JOIN drivers AS d ON r. driverId = d. driverId INNER JOIN races AS rc ON r. raceId = rc. raceId WHERE ...
23 sie 2024 · Multiple CASE WHEN statements allow you to implement conditional logic in SQL queries, allowing for the evaluation of multiple conditions and the execution of different actions based on those conditions.
OpenF1 is a free and open-source API that provides real-time and historical Formula 1 data. The API offers a wealth of information, including lap timings, car telemetry, radio communications, and more. Whether you're looking to create interactive dashboards, dive deep into race analysis, or even develop connected objects that light up every ...
