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.
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.
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.
%% sql fastest_lap << WITH cte as (SELECT race_name, CONCAT (forename, ' ', surname) AS driver_name, MIN (l. milliseconds) as time_milli, RANK OVER (PARTITION BY race_name ORDER BY MIN (l. milliseconds)) as seqnum FROM lap_times AS l INNER JOIN races AS r ON l. raceId = r. raceId INNER JOIN drivers AS d ON l. driverId = d. driverId GROUP BY ...
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.
8 mar 2019 · SQL Server has several different date and time functions and trying to remember every function is not that easy. So, I put together this tutorial that shows the different date and time functions all in one place along with examples to make finding what you are looking for much easier.
