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 178 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 50873 | all | Western Australia | 24 | 125 | 3 | 8 | 667 | 5.21 |
| 50884 | all | Western Australia | 6 | 37 | 5 | 9 | 241 | 6.17 |
| 50890 | all | Western Australia | 9 | 59 | 3 | 9 | 427 | 6.56 |
| 50891 | all | Western Australia | 33 | 180 | 2 | 9 | 1,098 | 5.45 |
| 50893 | all | Western Australia | 7 | 42 | 4 | 9 | 272 | 6 |
| 50895 | all | Western Australia | 4 | 25 | 5 | 8 | 163 | 6.25 |
| 50899 | all | Western Australia | 40 | 235 | 3 | 9 | 1,471 | 5.88 |
| 50901 | all | Western Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 50902 | all | Western Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 50905 | all | Western Australia | 3 | 17 | 5 | 7 | 99 | 5.67 |
| 50911 | all | Western Australia | 36 | 189 | 2 | 9 | 1,081 | 5.25 |
| 50915 | all | Western Australia | 3 | 17 | 1 | 9 | 131 | 5.67 |
| 50916 | all | Western Australia | 21 | 155 | 2 | 9 | 1,225 | 7.38 |
| 50918 | all | Western Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 50921 | all | Western Australia | 14 | 75 | 5 | 8 | 413 | 5.36 |
| 50924 | all | Western Australia | 4 | 20 | 5 | 5 | 100 | 5 |
| 50926 | all | Western Australia | 18 | 110 | 4 | 8 | 706 | 6.11 |
| 50934 | all | Western Australia | 2 | 13 | 5 | 8 | 89 | 6.5 |
| 50938 | all | Western Australia | 27 | 159 | 4 | 8 | 975 | 5.89 |
| 50941 | all | Western Australia | 2 | 8 | 3 | 5 | 34 | 4 |
| 50946 | all | Western Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 50947 | all | Western Australia | 12 | 59 | 2 | 7 | 309 | 4.92 |
| 50948 | all | Western Australia | 1 | 8 | 8 | 8 | 64 | 8 |
| 50949 | all | Western Australia | 1 | 8 | 8 | 8 | 64 | 8 |
| 50954 | all | Western Australia | 2 | 14 | 6 | 8 | 100 | 7 |