Which AI data-center milestones are still in the future?
Practice CASE, CURRENT_DATE and JOIN with Epoch AI site milestones and capacity estimates.
01 / THE QUESTION
Question
Which milestones in Epoch AI's timeline are dated after today? Label each milestone using the query's current date, then compare the IT power estimates and countries of the sites involved.
epoch_ai_data_centers.data_center = epoch_ai_data_center_timelines.data_center · one site to many dated milestones
04 / ANALYST GUIDE
Guide
Analysis requirements
Join epoch_ai_data_center_timelines to epoch_ai_data_centers on data_center.
Use CURRENT_DATE and CASE to label future versus on_or_before_today. Do not hard-code today's date.
A past date does not prove that an estimated event occurred. Explain that distinction in your findings.
it_power_mw is IT power capacity; facility_power_mw also includes cooling and facility overhead. Neither is electricity consumption.
Each row is a milestone snapshot. Do not sum capacities across dates or sum repeated current_h100_equivalents lookups.
The export contains selected sites, not all AI data centers. A 2030 milestone for one site does not make this a complete projection through 2030.
Suggested query
Expand suggested query
SQL / STARTER QUERY
SELECT
t.data_center,
s.country,
t.date,
CASE
WHEN CAST(t.date AS DATE) > CURRENT_DATE THEN 'future'
ELSE 'on_or_before_today'
END AS date_label,
t.it_power_mw,
t.construction_status
FROM epoch_ai_data_center_timelines AS t
JOIN epoch_ai_data_centers AS s USING (data_center)
ORDER BY t.date DESC, t.data_center
LIMIT 30;