Events by source

Custom SQL query (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 s.name = :source
  AND e.latitude IS NOT NULL
  AND e.longitude IS NOT NULL
ORDER BY 
  CASE WHEN e.datetime_utc IS NOT NULL AND e.datetime_utc != '' THEN 0 ELSE 1 END,
  e.credibility_score DESC
LIMIT 5000

Query parameters

source

Edit SQL