gistfile1.txt

politips=#  
select a.data->>'title', s.*, now() - a.created from news.article a, sentiment(data->>'cleaned_text') s where data->>'cleaned_text' is not null and s.polarity > 0.2 order by created desc limit 10;
                                                            ?column?                                                             |     polarity      |   subjectivity    |    ?column?     
---------------------------------------------------------------------------------------------------------------------------------+-------------------+-------------------+-----------------
 Cruz wins most delegates at stake Saturday in Wyoming                                                                           | 0.433333333333333 |               0.3 | 00:05:57.679898
 Jeanette Rubio personally thanks volunteers in Orlando                                                                          | 0.219773783127442 |  0.51091120261852 | 00:08:33.568056
 California hoping to use science to battle drought                                                                              |              0.25 |              0.25 | 00:12:31.792361
 FReeper Canteen ~ Sunday Chapel ~ PRAYER ~ 13 March 2016                                                                        | 0.231372549019608 | 0.511274509803922 | 00:21:29.347957
 How President Reagan dealt with the Berkeley protesters in 1969                                                                 |               0.6 |                 1 | 00:32:23.271873
 GOP Head Asks Both Sides to Reduce Violence at Trump Rallies                                                                    |  0.20328320802005 | 0.402230576441103 | 00:46:05.59782
 How Black, Latino And Muslim College Students Organized To Stop Trump's Rally In Chicago                                        | 0.219047619047619 | 0.645238095238095 | 00:48:29.114753
 Astronomy Picture of the Day -- The Flash Spectrum of the Sun                                                                   | 0.442857142857143 | 0.792857142857143 | 00:48:29.114753
 Instapundit » Blog Archive » AT AMAZON, Baseball Bats, Gloves & More From Wilson & DeMarini. Plus, save on software and more a… | 0.333333333333333 | 0.416666666666667 | 01:14:15.751584
 How Will Our 10th District National Delegates Vote at the Convention?                                                           | 0.233333333333333 |            0.4875 | 01:16:36.090467
(10 rows)

politips=#  
select a.data->>'title', s.*, now() - a.created from news.article a, sentiment(data->>'cleaned_text') s where data->>'cleaned_text' is not null and s.polarity < -0.2 order by created desc limit 10;
                                                    ?column?                                                    |      polarity      |   subjectivity    |    ?column?     
----------------------------------------------------------------------------------------------------------------+--------------------+-------------------+-----------------
 Refugee deal will cement Erdoğan's control                                                                     |               -0.3 |               0.1 | 01:52:56.275418
 U.S. Says North Korean Submarine Missing - Slashdot                                                            | -0.219444444444444 | 0.216666666666667 | 02:41:10.760506
 Israelis shut down Palestinian Islamic Jihad TV station that was encouraging “Palestinians” to attack Israelis | -0.274305555555556 |  0.46656746031746 | 02:50:14.965164
 Ted Cruz Loses Pominent Support After Siding With Violent Leftists Over Donald Trump                           | -0.241666666666667 | 0.382407407407407 | 03:15:58.220428
 9-year-old girl struck by SUV, killed in Estes Park parking lot                                                |           -0.26875 |            0.5375 | 03:43:35.096304
 Code for pedophiles ends up on children’s toys                                                                 | -0.264697802197802 | 0.547252747252747 | 03:54:28.426087
 Elderly Couple Make Death Pact, Wife And Dog Shot Dead, Then It’s His Turn- And THIS Happens!                  | -0.251587301587302 | 0.344312169312169 | 04:29:03.620203
 AP News - No charges for ex-St. Paul officer who wrote protester post                                          | -0.221428571428571 | 0.273809523809524 | 04:44:46.482669
 'The Turing Test' Announcement Trailer                                                                         |               -0.4 |               0.4 | 05:09:41.174539
 Al Sharpton slams ‘violent, despicable’ Donald Trump                                                           | -0.233333333333333 | 0.587878787878788 | 05:11:02.40474
(10 rows)