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 170 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 50352 | all | Western Australia | 3 | 21 | 6 | 8 | 149 | 7 |
| 50353 | all | Western Australia | 12 | 70 | 3 | 8 | 434 | 5.83 |
| 50354 | all | Western Australia | 2 | 10 | 5 | 5 | 50 | 5 |
| 50357 | all | Western Australia | 2 | 12 | 4 | 8 | 80 | 6 |
| 50359 | all | Western Australia | 10 | 55 | 2 | 9 | 341 | 5.5 |
| 50363 | all | Western Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 50364 | all | Western Australia | 2 | 9 | 4 | 5 | 41 | 4.5 |
| 50367 | all | Western Australia | 3 | 19 | 5 | 7 | 123 | 6.33 |
| 50372 | all | Western Australia | 2 | 10 | 4 | 6 | 52 | 5 |
| 50374 | all | Western Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 50375 | all | Western Australia | 163 | 960 | 2 | 9 | 6,072 | 5.89 |
| 50376 | all | Western Australia | 1 | 6 | 6 | 6 | 36 | 6 |
| 50377 | all | Western Australia | 3 | 15 | 5 | 5 | 75 | 5 |
| 50378 | all | Western Australia | 84 | 444 | 3 | 9 | 2,426 | 5.29 |
| 50382 | all | Western Australia | 6 | 36 | 5 | 8 | 224 | 6 |
| 50385 | all | Western Australia | 1 | 4 | 4 | 4 | 16 | 4 |
| 50386 | all | Western Australia | 4 | 29 | 5 | 8 | 217 | 7.25 |
| 50388 | all | Western Australia | 4 | 23 | 5 | 8 | 139 | 5.75 |
| 50397 | all | Western Australia | 3 | 19 | 5 | 9 | 131 | 6.33 |
| 50400 | all | Western Australia | 1 | 9 | 9 | 9 | 81 | 9 |
| 50402 | all | Western Australia | 7 | 38 | 5 | 8 | 214 | 5.43 |
| 50403 | all | Western Australia | 22 | 122 | 2 | 9 | 750 | 5.55 |
| 50404 | all | Western Australia | 215 | 1,273 | 1 | 9 | 8,273 | 5.92 |
| 50405 | all | Western Australia | 16 | 94 | 3 | 9 | 596 | 5.88 |
| 50409 | all | Western Australia | 2 | 7 | 2 | 5 | 29 | 3.5 |