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 177 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 50802 | all | Western Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 50806 | all | Western Australia | 4 | 30 | 6 | 9 | 234 | 7.5 |
| 50808 | all | Western Australia | 1 | 4 | 4 | 4 | 16 | 4 |
| 50810 | all | Western Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 50821 | all | Western Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 50822 | all | Western Australia | 2 | 10 | 5 | 5 | 50 | 5 |
| 50824 | all | Western Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 50830 | all | Western Australia | 60 | 338 | 3 | 9 | 2,018 | 5.63 |
| 50831 | all | Western Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 50836 | all | Western Australia | 23 | 113 | 3 | 8 | 583 | 4.91 |
| 50837 | all | Western Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 50839 | all | Western Australia | 1 | 8 | 8 | 8 | 64 | 8 |
| 50840 | all | Western Australia | 16 | 98 | 5 | 9 | 638 | 6.12 |
| 50842 | all | Western Australia | 4 | 28 | 7 | 7 | 196 | 7 |
| 50843 | all | Western Australia | 4 | 20 | 5 | 5 | 100 | 5 |
| 50844 | all | Western Australia | 11 | 65 | 5 | 8 | 397 | 5.91 |
| 50846 | all | Western Australia | 15 | 76 | 1 | 8 | 448 | 5.07 |
| 50847 | all | Western Australia | 7 | 43 | 5 | 9 | 287 | 6.14 |
| 50849 | all | Western Australia | 4 | 21 | 5 | 6 | 111 | 5.25 |
| 50854 | all | Western Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 50855 | all | Western Australia | 14 | 70 | 5 | 5 | 350 | 5 |
| 50866 | all | Western Australia | 5 | 31 | 5 | 7 | 197 | 6.2 |
| 50867 | all | Western Australia | 2 | 12 | 5 | 7 | 74 | 6 |
| 50870 | all | Western Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 50872 | all | Western Australia | 1 | 5 | 5 | 5 | 25 | 5 |