SQL playground

Run DuckDB queries against the 9.8 MB parquet directly in your browser. Nothing is sent to a server — the data and the engine load on this page on first Run, then everything is local.

DuckDB not loaded yet — first run will fetch ~10 MB.
Schema reference click to expand

Single table loaded as perf (alias for the parquet file). Columns:

  • event — human label, e.g. 'marathon'
  • event_slug — id, e.g. 'w_maraok'
  • sex — 'men' | 'women' | 'mixed'
  • legality — 'legal' | 'non-legal'
  • family — 'track_time' | 'field_distance' | 'combined_points' | 'relay' | …
  • section — sub-list label inside an event page (canonical list contains rank=1)
  • rank, mark_raw, mark_value (numeric: seconds / metres / points)
  • mark_annotation (e.g. 'A', '+', '*'), wind
  • name, country (IOC code), dob (date), dob_precision
  • position, venue, date (perf date)
  • source_url — anchor link to the source section on alltime-athletics.com
  • source_line — the raw text line each row was parsed from (for verification)