Top 20 verbs.

sqlite> select count,phrase from phrases where pos = ‘V’ order by count desc limit 20;
count|phrase
19340|said/VBD
18704|says/VBZ
14604|is/VBZ
8383|was/VBD
6424|say/VBP
5495|writes/VBZ
5306|are/VBP
4992|be/VB
2672|were/VBD
2672|killing/VBG
2578|died/VBD

2476|has/VBZ
2034|accused/VBN
1928|including/VBG
1925|killed/VBN
1793|had/VBD
1734|’s/VBZ
1729|according/VBG
1610|saying/VBG
1563|found/VBD

Eco-anxiety

10 articles from the last month containing the phrase `climate change’ with the highest `fear’ rating.

rossetti@Wakatipu:~/door$ sqlite3 door_wordlist.db "SELECT ratings_1.q3, articles.title FROM articles LEFT JOIN ratings_1 ON articles.id = ratings_1.id where articles.date_utc > date(2008-5-7) AND articles.content LIKE '%climate change%' ORDER BY ratings_1.q3 DESC LIMIT 10;"

0.685783020643|Blogwatch: the La Nina situation
0.488184223473|White House thaws over polar bear
0.47334045077|Your Views:  What MPs drive
0.467275269602|More than a billion trees planted this year: UN
0.459957990744|Water plan speech not criticism, says Treasury boss
0.455275970518|Millions of 'climate change migrants' will overwhelm Europe, says report
0.453333437261|Norway to show US global warming affect on Arctic islands
0.45237335196|'Out of ideas' - PM fails to catch Labor
0.445142297835|NZ forests falling
0.443097177169|River report points to dam trouble

And results for the word `weather’

0.546797083867|Climate change set to erode house values
0.483457646351|Photos:  First snow brings chaos to London, across Europe
0.476200389826|Wild weather chaos in New South Wales
0.469760177924|Flood emergency eases in Hunter Valley
0.433045967141|Premier confident of power availability
0.424738123771|Black ice in south, gale warning for north
0.423129126153|Two dead in European mudslides, floods: reports
0.4219486054|Pasha report blames poor seamanship
0.414978076786|Bad weather: more ships issue distress calls
0.413745027142|Rare Snowstorm