Postgres: Find by email in array of JSON objects

gistfile1.txt

// Inspiration: http://stackoverflow.com/a/19868697/1221591
select
  *
from
  events,
  json_array_elements(events.raw->'attendees') as attendees
where
  attendees->>'email' = 'dave@davebryand.com';