Balanced random sample

Custom SQL query returning 5,000 rows (hide)

SELECT e.id, e.datetime_utc, CAST(SUBSTR(e.datetime_utc,1,4) AS INTEGER) as year,
e.city, e.state, e.country, e.latitude, e.longitude, e.shape,
e.duration_seconds, e.description, e.credibility_score, e.witness_type,
s.name as source, s.tier as source_tier
FROM events e
JOIN reports r ON r.event_id = e.id
JOIN sources s ON s.id = r.source_id
WHERE e.latitude IS NOT NULL AND e.longitude IS NOT NULL
ORDER BY RANDOM()
LIMIT 5000

Edit SQL