SELECT s.text,"right"(s.place.full_name,2) as state
FROM twitter_source."twitter-stream.json" s
WHERE lang = 'en'
AND s.place.country_code = 'US'
AND
  (regexp_like (s.place.full_name,'.*(WA|WI|WV|FL|WY|NH|NJ|NM|NA|NC|ND|NE|NY|RI|NV|GU|CO|CA|GA|CT|OK|OH|KS|SC|KY|OR|SD|DE|DC|HI|PR|TX|LA|TN|PA|VA|VI|AK|AL|AS|AR|VT|IL|IN|IA|AZ|ID|ME|MD|MA|UT|MO|MN|MI|MT|MP|MS)$')
  OR
  regexp_like (s."user".location,'.*(WA|WI|WV|FL|WY|NH|NJ|NM|NA|NC|ND|NE|NY|RI|NV|GU|CO|CA|GA|CT|OK|OH|KS|SC|KY|OR|SD|DE|DC|HI|PR|TX|LA|TN|PA|VA|VI|AK|AL|AS|AR|VT|IL|IN|IA|AZ|ID|ME|MD|MA|UT|MO|MN|MI|MT|MP|MS)$')
)