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 101 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 22870 | all | Victoria | 1 | 6 | 6 | 6 | 36 | 6 |
| 22873 | all | Victoria | 65 | 372 | 1 | 9 | 2,482 | 5.72 |
| 22875 | all | Victoria | 203 | 1,085 | 1 | 9 | 6,379 | 5.34 |
| 22877 | all | Victoria | 11 | 63 | 4 | 8 | 377 | 5.73 |
| 22882 | all | Victoria | 2 | 10 | 5 | 5 | 50 | 5 |
| 22883 | all | Victoria | 2 | 7 | 2 | 5 | 29 | 3.5 |
| 22886 | all | Victoria | 1 | 7 | 7 | 7 | 49 | 7 |
| 22889 | all | Victoria | 19 | 122 | 4 | 9 | 822 | 6.42 |
| 22892 | all | Victoria | 1 | 6 | 6 | 6 | 36 | 6 |
| 22893 | all | Victoria | 9 | 48 | 3 | 8 | 278 | 5.33 |
| 22896 | all | Victoria | 4 | 23 | 4 | 7 | 139 | 5.75 |
| 22900 | all | Victoria | 4 | 28 | 5 | 9 | 212 | 7 |
| 22902 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 22904 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 22908 | all | Victoria | 2 | 14 | 7 | 7 | 98 | 7 |
| 22913 | all | Victoria | 17 | 96 | 2 | 9 | 588 | 5.65 |
| 22915 | all | Victoria | 8 | 47 | 5 | 9 | 291 | 5.88 |
| 22916 | all | Victoria | 2 | 13 | 5 | 8 | 89 | 6.5 |
| 22917 | all | Victoria | 55 | 341 | 1 | 9 | 2,319 | 6.2 |
| 22919 | all | Victoria | 1,327 | 7,626 | 1 | 9 | 50,056 | 5.75 |
| 22921 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 22924 | all | Victoria | 21 | 125 | 5 | 9 | 781 | 5.95 |
| 22925 | all | Victoria | 5 | 26 | 5 | 6 | 136 | 5.2 |
| 22930 | all | Victoria | 10 | 67 | 5 | 9 | 479 | 6.7 |
| 22934 | all | Victoria | 3 | 17 | 1 | 9 | 131 | 5.67 |