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 168 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 50220 | all | Western Australia | 5 | 28 | 4 | 8 | 166 | 5.6 |
| 50224 | all | Western Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 50225 | all | Western Australia | 1 | 3 | 3 | 3 | 9 | 3 |
| 50226 | all | Western Australia | 50 | 287 | 2 | 9 | 1,765 | 5.74 |
| 50228 | all | Western Australia | 2,891 | 16,888 | 1 | 9 | 108,806 | 5.84 |
| 50230 | all | Western Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 50231 | all | Western Australia | 8 | 47 | 5 | 8 | 287 | 5.88 |
| 50233 | all | Western Australia | 4 | 22 | 5 | 7 | 124 | 5.5 |
| 50236 | all | Western Australia | 1 | 9 | 9 | 9 | 81 | 9 |
| 50239 | all | Western Australia | 2 | 9 | 4 | 5 | 41 | 4.5 |
| 50242 | all | Western Australia | 2 | 13 | 5 | 8 | 89 | 6.5 |
| 50246 | all | Western Australia | 22 | 133 | 5 | 8 | 833 | 6.05 |
| 50247 | all | Western Australia | 1 | 3 | 3 | 3 | 9 | 3 |
| 50248 | all | Western Australia | 4 | 16 | 1 | 7 | 84 | 4 |
| 50249 | all | Western Australia | 2 | 14 | 7 | 7 | 98 | 7 |
| 50250 | all | Western Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 50251 | all | Western Australia | 15 | 93 | 5 | 8 | 609 | 6.2 |
| 50253 | all | Western Australia | 9 | 49 | 5 | 7 | 273 | 5.44 |
| 50260 | all | Western Australia | 8 | 50 | 5 | 9 | 328 | 6.25 |
| 50263 | all | Western Australia | 5 | 27 | 3 | 9 | 165 | 5.4 |
| 50265 | all | Western Australia | 25 | 140 | 4 | 9 | 812 | 5.6 |
| 50266 | all | Western Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 50267 | all | Western Australia | 73 | 396 | 2 | 9 | 2,360 | 5.42 |
| 50272 | all | Western Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 50277 | all | Western Australia | 6 | 35 | 5 | 8 | 213 | 5.83 |