Sentiment
Twitter sentiment by suburb (SAL)
CouchDB MapReduce _stats per suburb and topic (all tweets, income keywords, crime keywords), Feb-Jul 2022, every Australian state. Rows are keyed by SAL code: join regions_sal for names.
page 118 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 31256 | all | Queensland | 5 | 25 | 5 | 5 | 125 | 5 |
| 31258 | all | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 31260 | all | Queensland | 3 | 15 | 5 | 5 | 75 | 5 |
| 31269 | all | Queensland | 2 | 13 | 5 | 8 | 89 | 6.5 |
| 31270 | all | Queensland | 5 | 40 | 5 | 9 | 332 | 8 |
| 31280 | all | Queensland | 1,981 | 11,875 | 1 | 9 | 78,803 | 5.99 |
| 31282 | all | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 31283 | all | Queensland | 2 | 10 | 2 | 8 | 68 | 5 |
| 31285 | all | Queensland | 7 | 42 | 5 | 8 | 260 | 6 |
| 31286 | all | Queensland | 115 | 648 | 2 | 9 | 3,934 | 5.63 |
| 31289 | all | Queensland | 682 | 3,857 | 1 | 9 | 23,619 | 5.66 |
| 31293 | all | Queensland | 2 | 10 | 5 | 5 | 50 | 5 |
| 31297 | all | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 31300 | all | Queensland | 2 | 15 | 7 | 8 | 113 | 7.5 |
| 31301 | all | Queensland | 2 | 14 | 5 | 9 | 106 | 7 |
| 31303 | all | Queensland | 2 | 14 | 7 | 7 | 98 | 7 |
| 31305 | all | Queensland | 15 | 107 | 3 | 9 | 821 | 7.13 |
| 31306 | all | Queensland | 80 | 417 | 1 | 9 | 2,595 | 5.21 |
| 31307 | all | Queensland | 3 | 15 | 5 | 5 | 75 | 5 |
| 31309 | all | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 31315 | all | Queensland | 5 | 32 | 5 | 9 | 220 | 6.4 |
| 31316 | all | Queensland | 3 | 17 | 5 | 7 | 99 | 5.67 |
| 31318 | all | Queensland | 1 | 8 | 8 | 8 | 64 | 8 |
| 31321 | all | Queensland | 3 | 16 | 3 | 8 | 98 | 5.33 |
| 31322 | all | Queensland | 1 | 7 | 7 | 7 | 49 | 7 |