gistfile1.txt

select a.data->>'title', s.* from news.article a, sentiment(data->>'cleaned_text') s where data->>'cleaned_text' is not null and s.polarity < -0.2 order by created limit 10;                                       
                              ?column?                              |      polarity      |   subjectivity    
--------------------------------------------------------------------+--------------------+-------------------
 What the Battle of Waterloo means to us                            | -0.266666666666667 |               0.8
 Dallas police headquarters shooting suspect had violent history    |            -0.2625 |            0.4625
 Behind the biggest break-in of the 1970's - Video                  |               -0.4 |               0.7
 United passengers forced to sleep in military barracks             | -0.266666666666667 |               0.4
 Perry releases bizarre Hillary cartoon ad                          | -0.223333333333333 | 0.346666666666667
 Connecticut probes school response to kindergartener who broke arm |               -0.4 |               0.4
 Life or death battle against flesh-eating bacteria                 | -0.333333333333333 | 0.466666666666667
 Two teens lose limbs in North Carolina shark attacks               | -0.331818181818182 | 0.727272727272727
 1 injured after shots fired at Arkansas Air Force base             | -0.465833333333333 | 0.673333333333333
 At least 2 injured in shooting at Air Force base in Arkansas       | -0.418872549019608 | 0.600980392156863
(10 rows)

Time: 5576.384 ms
politips=#   
select a.data->>'title', s.* from news.article a, sentiment(data->>'cleaned_text') s where data->>'cleaned_text' is not null and s.polarity > 0.2 order by created limit 10;
                            ?column?                            |     polarity      |   subjectivity    
----------------------------------------------------------------+-------------------+-------------------
 Black bear mauls teen on camping trip - Video                  | 0.316666666666667 | 0.591666666666667
 Husband catches 'upskirting' suspect in Walmart - Video        | 0.416666666666667 | 0.583333333333333
 Great Escapes- the Algarve - Video                             |               0.4 | 0.658333333333333
 Stunning video shows the power of makeup - Video               |               0.5 |               0.5
 The Annie Leibovitz of the Victorian era - .com                | 0.329838709677419 | 0.521505376344086
 Bill Clinton weighs in on GOP's 2016 field - Politics.com      | 0.250393939393939 | 0.442962703962704
 What we're stealing from hotels the most - Video               |               0.5 |               0.5
 In Iowa, Dems flock to both Clinton and Sanders - Politics.com | 0.210178571428571 | 0.463829365079365
 5 Seconds of Summer's Michael Clifford burned in show - .com   | 0.253373015873016 |  0.33531746031746
 The vacation spots we call home - .com                         | 0.233238040785211 | 0.531670478368592
(10 rows)

Time: 462.451 ms