Longest streak of world records (same event, same type)
StreakA consecutive chain of WRs in one event-type (single or average) all set by the same cuber. The streak breaks the moment anyone else sets a WR in that event-type.
Example: a cuber improves their own 3x3 single WR 5 times in a row with nobody else WR-ing in between — a length-5 streak.
By the numbers
> 1
Inclusion floor
At least 2 consecutive to qualify
日期 + 成绩
Same-day tiebreak
Same date sorted by result desc
Years
Sort key
End - start span
停办项目
Special case
Endpoint = event's final comp
Data source
SQL only pulls all regional_*_record = WR rows plus necessary joins (persons sub_id = 1, competitions). Streak detection lives in JS transform(): for each (event, type), sort by date and scan — same cuber as the previous WR? count += 1. Different cuber? Start a new streak.
Discontinued events (333ft / magic / mmagic / 333mbo) terminate the final streak at the event's last comp (prefetched in toJson) — not "still active", since no new WR can occur.
sql
SELECT regional_single_record, regional_average_record,
best single, average,
person.name, competition.start_date,
event_id, competition.cell_name
FROM results
JOIN persons ON persons.wca_id = person_id AND persons.sub_id = 1
JOIN competitions ON competitions.id = competition_id
WHERE regional_single_record = 'WR'
OR regional_average_record = 'WR'Algorithm / pipeline
1
Pull every WR row
Includes both single + average WRs, each row carrying event + person + date + comp.
2
Split by (event, type)
Streaks don't cross events or cross single↔average: 3x3 single and 3x3 average track independently.
3
Sort + sequential scan
Same-day tiebreak sorts result desc (worse first, better last) — same-day multiple WRs are by definition stepwise improvements.
4
Different cuber = streak break
If
current.person === prev.person, count += 1; otherwise close out, recording endDate + lastCompetition.5
Sort by years, output
years = (end − start) / 365.25. Only
count > 1 qualifies; sorted desc; discontinued events apply the special endpoint.Caveats & edges
- Streaks don't require strict improvement: WCA's
regional_*_record = WRmarker only attaches when it's actually a new WR, so every row is by definition a WR-tier improvement. - One cuber WR-streaking in two events simultaneously → split into 2 separate streaks (per-event isolated).
- "Active" streaks use today for the years calc; numbers shift as the streak continues — or ends.
- Discontinued events follow the
DISCONTINUED_EVENTS = [333ft, magic, mmagic, 333mbo]path — final WR holders' streaks close at the event's last competition.