# TracingInsights — Formula 1 Data Browser

> Open Formula 1 dataset catalog with 57 tables, 1,123,627 rows, and 8.59 MB of Parquet data, last updated 2026-07-31T02:48:56.640Z. Every table is exposed as a static HTML page with embedded schema.org Dataset metadata, a Markdown catalog at /f1db.md, structured Parquet downloads, and an AI-engine-friendly meta tag profile. Designed for direct LLM ingestion, retrieval augmented generation (RAG), and citation in generative search engines.

## Catalog

- [F1 Data Browser](http://localhost:5173/f1db): Browse all 57 tables with the in-browser DuckDB explorer.
- [Data Catalog (Markdown)](http://localhost:5173/f1db.md): Full schema, DDL, and column descriptions for every table. Optimised for direct LLM ingestion.
- [Sitemap](http://localhost:5173/sitemap.xml): Machine-readable index of every static page and per-table URL.

## Per-table dataset pages

Each entry below is a static HTML page with embedded JSON-LD Dataset metadata (schema.org/Dataset), the full column schema in the body, and a direct Parquet download link.

- [chassis](http://localhost:5173/f1db/chassis): 1,153 rows, 4 columns, 14.7 KB
- [circuits](http://localhost:5173/f1db/circuits): 78 rows, 13 columns, 7.48 KB
- [circuits_layouts](http://localhost:5173/f1db/circuits-layouts): 160 rows, 5 columns, 3.23 KB
- [constructors](http://localhost:5173/f1db/constructors): 187 rows, 22 columns, 12.1 KB
- [constructors_chronology](http://localhost:5173/f1db/constructors-chronology): 217 rows, 5 columns, 2.68 KB
- [continents](http://localhost:5173/f1db/continents): 7 rows, 4 columns, 852.0 B
- [countries](http://localhost:5173/f1db/countries): 249 rows, 7 columns, 7.64 KB
- [drivers](http://localhost:5173/f1db/drivers): 917 rows, 32 columns, 64.0 KB
- [drivers_family_relationships](http://localhost:5173/f1db/drivers-family-relationships): 86 rows, 4 columns, 2.33 KB
- [engine_manufacturers](http://localhost:5173/f1db/engine-manufacturers): 78 rows, 20 columns, 6.78 KB
- [engines](http://localhost:5173/f1db/engines): 424 rows, 7 columns, 9.54 KB
- [entrants](http://localhost:5173/f1db/entrants): 830 rows, 2 columns, 15.1 KB
- [grands_prix](http://localhost:5173/f1db/grands-prix): 54 rows, 7 columns, 3.63 KB
- [races](http://localhost:5173/f1db/races): 1,171 rows, 47 columns, 36.7 KB
- [races_constructor_standings](http://localhost:5173/f1db/races-constructor-standings): 10,610 rows, 11 columns, 41.0 KB
- [races_driver_of_the_day_results](http://localhost:5173/f1db/races-driver-of-the-day-results): 874 rows, 12 columns, 9.02 KB
- [races_driver_standings](http://localhost:5173/f1db/races-driver-standings): 21,449 rows, 10 columns, 71.5 KB
- [races_fastest_laps](http://localhost:5173/f1db/races-fastest-laps): 17,085 rows, 18 columns, 326.2 KB
- [races_free_practice_1_results](http://localhost:5173/f1db/races-free-practice-1-results): 16,076 rows, 18 columns, 288.1 KB
- [races_free_practice_2_results](http://localhost:5173/f1db/races-free-practice-2-results): 15,509 rows, 18 columns, 274.9 KB
- [races_free_practice_3_results](http://localhost:5173/f1db/races-free-practice-3-results): 8,823 rows, 18 columns, 154.0 KB
- [races_free_practice_4_results](http://localhost:5173/f1db/races-free-practice-4-results): 706 rows, 18 columns, 17.4 KB
- [races_lap_times](http://localhost:5173/f1db/races-lap-times): 876,525 rows, 6 columns, 5.09 MB
- [races_pit_stops](http://localhost:5173/f1db/races-pit-stops): 22,430 rows, 15 columns, 223.0 KB
- [races_pre_qualifying_results](http://localhost:5173/f1db/races-pre-qualifying-results): 647 rows, 24 columns, 17.9 KB
- [races_qualifying_1_results](http://localhost:5173/f1db/races-qualifying-1-results): 7,707 rows, 24 columns, 144.0 KB
- [races_qualifying_2_results](http://localhost:5173/f1db/races-qualifying-2-results): 7,541 rows, 24 columns, 141.3 KB
- [races_qualifying_results](http://localhost:5173/f1db/races-qualifying-results): 26,954 rows, 24 columns, 522.1 KB
- [races_race_results](http://localhost:5173/f1db/races-race-results): 27,533 rows, 34 columns, 429.7 KB
- [races_red_flags](http://localhost:5173/f1db/races-red-flags): 98 rows, 7 columns, 6.59 KB
- [races_safety_cars](http://localhost:5173/f1db/races-safety-cars): 369 rows, 7 columns, 4.06 KB
- [races_sprint_qualifying_results](http://localhost:5173/f1db/races-sprint-qualifying-results): 444 rows, 24 columns, 14.2 KB
- [races_sprint_race_results](http://localhost:5173/f1db/races-sprint-race-results): 568 rows, 34 columns, 22.1 KB
- [races_sprint_starting_grid_positions](http://localhost:5173/f1db/races-sprint-starting-grid-positions): 567 rows, 17 columns, 10.4 KB
- [races_starting_grid_positions](http://localhost:5173/f1db/races-starting-grid-positions): 25,770 rows, 17 columns, 260.5 KB
- [races_warming_up_results](http://localhost:5173/f1db/races-warming-up-results): 7,683 rows, 18 columns, 143.1 KB
- [seasons](http://localhost:5173/f1db/seasons): 77 rows, 1 columns, 335.0 B
- [seasons_constructor_standings](http://localhost:5173/f1db/seasons-constructor-standings): 721 rows, 8 columns, 6.07 KB
- [seasons_constructors](http://localhost:5173/f1db/seasons-constructors): 1,079 rows, 19 columns, 17.8 KB
- [seasons_driver_standings](http://localhost:5173/f1db/seasons-driver-standings): 1,680 rows, 7 columns, 12.3 KB
- [seasons_drivers](http://localhost:5173/f1db/seasons-drivers): 3,415 rows, 19 columns, 42.8 KB
- [seasons_engine_manufacturers](http://localhost:5173/f1db/seasons-engine-manufacturers): 560 rows, 18 columns, 12.2 KB
- [seasons_entrants](http://localhost:5173/f1db/seasons-entrants): 1,799 rows, 3 columns, 11.8 KB
- [seasons_entrants_chassis](http://localhost:5173/f1db/seasons-entrants-chassis): 2,292 rows, 5 columns, 25.0 KB
- [seasons_entrants_constructors](http://localhost:5173/f1db/seasons-entrants-constructors): 1,925 rows, 4 columns, 15.8 KB
- [seasons_entrants_drivers](http://localhost:5173/f1db/seasons-entrants-drivers): 3,880 rows, 8 columns, 49.7 KB
- [seasons_entrants_engines](http://localhost:5173/f1db/seasons-entrants-engines): 2,027 rows, 5 columns, 21.7 KB
- [seasons_entrants_tyre_manufacturers](http://localhost:5173/f1db/seasons-entrants-tyre-manufacturers): 1,955 rows, 5 columns, 16.7 KB
- [seasons_eras](http://localhost:5173/f1db/seasons-eras): 77 rows, 6 columns, 15.8 KB
- [seasons_points_overrides](http://localhost:5173/f1db/seasons-points-overrides): 7 rows, 7 columns, 2.22 KB
- [seasons_points_systems](http://localhost:5173/f1db/seasons-points-systems): 77 rows, 16 columns, 4.38 KB
- [seasons_qualifying_formats](http://localhost:5173/f1db/seasons-qualifying-formats): 77 rows, 8 columns, 3.68 KB
- [seasons_sporting_regulations](http://localhost:5173/f1db/seasons-sporting-regulations): 77 rows, 13 columns, 3.42 KB
- [seasons_sprint_points_systems](http://localhost:5173/f1db/seasons-sprint-points-systems): 77 rows, 12 columns, 3.29 KB
- [seasons_technical_regulations](http://localhost:5173/f1db/seasons-technical-regulations): 77 rows, 18 columns, 4.88 KB
- [seasons_tyre_manufacturers](http://localhost:5173/f1db/seasons-tyre-manufacturers): 160 rows, 15 columns, 5.49 KB
- [tyre_manufacturers](http://localhost:5173/f1db/tyre-manufacturers): 9 rows, 16 columns, 3.14 KB

## F1 Stats Encyclopedia

A comprehensive, prerendered statistics encyclopedia covering every driver, constructor, race, circuit, and season in Formula 1 history. All pages are static HTML with embedded schema.org structured data (Person, SportsTeam, SportingEvent, etc.).

- [F1 Stats Home](http://localhost:5173/stats): Landing page with latest race, season summary, and all-time greats leaderboard.
- [Drivers](http://localhost:5173/stats/drivers): All F1 drivers with career statistics (wins, podiums, poles, championships).
- [Constructors](http://localhost:5173/stats/constructors): All F1 constructors with team records.
- [Seasons](http://localhost:5173/stats/seasons): Every championship season with standings and entrants.
- [Races](http://localhost:5173/stats/races): Every Grand Prix race with full results, qualifying, sprint, and session data.
- [Circuits](http://localhost:5173/stats/circuits): All circuits with race history, winners, and lap records.
- [Compare](http://localhost:5173/stats/compare): Head-to-head driver and constructor comparisons with season-by-season breakdowns.
- [Grands Prix](http://localhost:5173/stats/grands-prix): Every Grand Prix event with all-time winners and polesitters.
- [Standings](http://localhost:5173/stats/standings): Historical World Drivers’ and Constructors’ Championship standings.
- [On This Day](http://localhost:5173/stats/on-this-day): Historical calendar of F1 events for every day of the year, including Grand Prix races, driver birthdays, championship decisions, milestones, and race incidents.
- [Search Index](http://localhost:5173/stats/data/search-index.json): Machine-readable JSON index of all entity names, types, and URLs for programmatic lookup.

### Records & Leaderboards

29 all-time record domains, each with multiple leaderboards, methodology notes, and chronological event lists. Every page is static HTML with embedded structured data.

**By entity:**
- [Driver Records](http://localhost:5173/stats/records/drivers): 84 records — wins, podiums, poles, championships, fastest laps, points, streaks, lead, sprint, and more.
- [Constructor Records](http://localhost:5173/stats/records/constructors): Team wins, 1-2 finishes, championships, pole positions, and more.
- [Circuit Records](http://localhost:5173/stats/records/circuits): 26 records — most races, wins by driver, closest finishes, safety cars, and more.
- [Country Records](http://localhost:5173/stats/records/countries): Nationality-based achievements.
- [Engine Records](http://localhost:5173/stats/records/engines): Power unit performance records.
- [Chassis Records](http://localhost:5173/stats/records/chassis): Car chassis performance records.
- [Tyre Records](http://localhost:5173/stats/records/tyres): Tyre manufacturer records.
- [Number Records](http://localhost:5173/stats/records/numbers): 13 records — achievements by car number (championships, wins, poles, fastest laps, points, podiums).
- [Grand Prix Records](http://localhost:5173/stats/records/grands-prix): 23 records — decisive results, lap/km records, finishers, speed, gaps, nations, safety cars.

**By achievement:**
- [Win Records](http://localhost:5173/stats/records/wins): Consecutive wins, wins per circuit, wins by age, gap to second.
- [Podium Records](http://localhost:5173/stats/records/podiums): Consecutive podiums, duo records, podiums per team.
- [Pole Records](http://localhost:5173/stats/records/poles): Consecutive poles, win rate from pole, poles by age.
- [Qualifying Records](http://localhost:5173/stats/records/qualifying): Q3 appearances, Q1 exits, consecutive qualifying streaks.
- [First Row Records](http://localhost:5173/stats/records/first-rows): Front row starts, lockouts, consecutive first rows.
- [Championship Records](http://localhost:5173/stats/records/championships): WDC/WCC titles, chronology, by age, vice-champion.
- [Fastest Lap Records](http://localhost:5173/stats/records/fastest-laps): Fastest laps by number, chronology, by age, consecutive, by GP/circuit.
- [Lead Records](http://localhost:5173/stats/records/lead): Laps led, km led, GP led, start-to-finish, consecutive leads.
- [Points Records](http://localhost:5173/stats/records/points): Points scoring records and firsts.
- [Lap Records](http://localhost:5173/stats/records/laps): Fastest laps and lap-related records.
- [Pit Stop Records](http://localhost:5173/stats/records/pit-stops): Pit stop speed and strategy records.
- [Sprint Records](http://localhost:5173/stats/records/sprints): Sprint race performance records.
- [GP Entry Records](http://localhost:5173/stats/records/gp-entries): Most GPs, consecutive GPs, GPs without win.
- [Head-to-Head Records](http://localhost:5173/stats/records/h2h): Teammate qualifying & race H2H, streaks.
- [Youngest & Oldest](http://localhost:5173/stats/records/youngest-oldest): Age-based records.
- [Streaks](http://localhost:5173/stats/records/streaks): Consecutive wins, podiums, points finishes.
- [Milestones](http://localhost:5173/stats/records/milestones): Career and historical milestones.
- [Season Records](http://localhost:5173/stats/records/seasons): Most wins, poles, and points in a single season.
- [Race Records](http://localhost:5173/stats/records/races): Most starters, closest finishes, and more.
- [Miscellaneous Records](http://localhost:5173/stats/records/misc): Hat tricks, grand slams, finishes, retirements, position gain, women, family.

### Stats Data Downloads

Pre-computed JSON files for programmatic consumption. Each record domain JSON contains ranked leaderboards with methodology notes, entity names, values, URLs, and chronological event lists.

- [Records Index](http://localhost:5173/stats/records): Browse all 29 record domains with interactive leaderboards.
- [Search Index](http://localhost:5173/stats/data/search-index.json): Machine-readable JSON index of all entity names, types, and URLs for programmatic lookup.

## F1 Regulations & Points Systems

Comprehensive historical F1 regulations data covering 1950–2026. Points systems, qualifying formats, technical regulations, sporting rules, and era narratives for every season.

- [Regulations Home](http://localhost:5173/stats/regulations): Full timeline with era narratives, points history, and qualifying format evolution.
- Per-season regulations: e.g. http://localhost:5173/stats/seasons/2026/regulations for the current regulations.

## Fan Ratings

Community race and sprint ratings (1–10 overall plus optional driver, team, and award detail). Season catalogs and event pages are server-rendered; race metadata is served as static JSON under /rate-data/.

- [Ratings home](http://localhost:5173/rate): Latest events, trending scores, and recent public ratings.
- [Season archive](http://localhost:5173/rate): Jump to any championship season catalog (e.g. http://localhost:5173/rate/2025).

## Optional

- [Parquet dumps](http://localhost:5173/f1db/): Bulk-download-ready columnar data per table. Each file is content-addressed by manifest etag, so versions are stable.
- [About TracingInsights](http://localhost:5173/about): App purpose, Google Sign-In data use, and privacy links (OAuth branding surface).
- [Chat](http://localhost:5173/chat): Ask natural-language Formula 1 stats questions; in-browser DuckDB; bring-your-own-key.