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 144 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 40036 | all | South Australia | 16 | 85 | 5 | 7 | 459 | 5.31 |
| 40039 | all | South Australia | 31 | 165 | 2 | 9 | 991 | 5.32 |
| 40040 | all | South Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 40042 | all | South Australia | 5 | 24 | 2 | 7 | 128 | 4.8 |
| 40043 | all | South Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 40044 | all | South Australia | 6 | 41 | 5 | 9 | 293 | 6.83 |
| 40047 | all | South Australia | 4 | 23 | 5 | 8 | 139 | 5.75 |
| 40048 | all | South Australia | 2 | 13 | 5 | 8 | 89 | 6.5 |
| 40049 | all | South Australia | 2 | 14 | 5 | 9 | 106 | 7 |
| 40051 | all | South Australia | 205 | 1,021 | 1 | 9 | 5,655 | 4.98 |
| 40062 | all | South Australia | 20 | 130 | 4 | 9 | 890 | 6.5 |
| 40066 | all | South Australia | 50 | 262 | 1 | 9 | 1,524 | 5.24 |
| 40067 | all | South Australia | 1 | 7 | 7 | 7 | 49 | 7 |
| 40072 | all | South Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 40073 | all | South Australia | 13 | 83 | 3 | 9 | 569 | 6.38 |
| 40075 | all | South Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 40079 | all | South Australia | 13 | 69 | 3 | 9 | 387 | 5.31 |
| 40081 | all | South Australia | 12 | 63 | 2 | 8 | 357 | 5.25 |
| 40082 | all | South Australia | 7 | 37 | 1 | 9 | 231 | 5.29 |
| 40089 | all | South Australia | 7 | 39 | 3 | 8 | 237 | 5.57 |
| 40096 | all | South Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 40098 | all | South Australia | 207 | 1,086 | 1 | 9 | 6,180 | 5.25 |
| 40099 | all | South Australia | 11 | 56 | 5 | 6 | 286 | 5.09 |
| 40109 | all | South Australia | 428 | 2,222 | 1 | 9 | 12,352 | 5.19 |
| 40110 | all | South Australia | 5 | 33 | 5 | 7 | 221 | 6.6 |