High Credibility Cases

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.credibility_score >= 5 AND e.latitude IS NOT NULL AND e.longitude IS NOT NULL ORDER BY e.credibility_score DESC LIMIT 5000

Edit SQL