Updated: 2026-04-03 | Database: research-pipeline.db
| Table | Filter | Rows | Schedule |
|---|---|---|---|
| sports_odds_snapshots | sport=motorsports, source=kalshi | 27,087 | Every 30min |
35 series prefixes tracked across F1, NASCAR, IndyCar, MotoGP.
| Table | Rows | Key Columns | Schedule |
|---|---|---|---|
| f1_sessions | 126 | session_key, session_type, circuit_short_name, date_start | Daily 11AM |
| f1_drivers | 22 | driver_number, full_name, team_name, country_code | Daily 11AM |
| f1_qualifying | 22 | session_key, driver_number, position, q1/q2/q3_time, gap_to_pole_sec | Daily 11AM |
| f1_race_results | 22 | session_key, driver_number, position, grid_position, positions_gained, status | Daily 11AM |
| f1_pit_stops | 29 | session_key, driver_number, lap_number, pit_duration_sec | Daily 11AM |
| Table | Rows | Key Columns | Schedule |
|---|---|---|---|
| f1_standings | 22 | year, driver_name, team, points, position, wins | Daily 11AM |
| f1_constructor_standings | 11 | year, constructor_name, points, position, wins | Daily 11AM |
| f1_reliability | 24 | driver_name, team, total_races, dnf_count, mechanical_dnf, crash_dnf, dnf_rate | Daily 11AM |
| Table | Rows | Key Columns | Schedule |
|---|---|---|---|
| nascar_standings | 39 | year, series, driver_name, team, points, position, wins, top5s, top10s | Daily 11AM |
| nascar_race_results | 335 | year, race_name, track_name, track_type, driver_name, start_pos, finish_pos, laps_led | Daily 11AM |
| Table | Filter | Rows | Schedule |
|---|---|---|---|
| sports_odds_snapshots | sport=motorsports, source=pinnacle | — | Adaptive |
| Data | Source | Status |
|---|---|---|
| IndyCar results/standings | No free API identified | Deferred |
| MotoGP results/standings | motogp.com (paid DataPass) | Deferred |
| F1 practice long-run data | OpenF1 laps endpoint | Future build |
| Circuit-specific coefficients | Manual + historical | Future build |
| Weather per circuit | AccuWeather/NWS | Future build |
| Edge scanner | — | Future build |