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 75 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 21115 | all | Victoria | 7 | 43 | 5 | 8 | 277 | 6.14 |
| 21116 | all | Victoria | 2 | 11 | 5 | 6 | 61 | 5.5 |
| 21117 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 21118 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 21121 | all | Victoria | 2 | 10 | 5 | 5 | 50 | 5 |
| 21123 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 21125 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 21127 | all | Victoria | 309 | 1,980 | 1 | 9 | 13,520 | 6.41 |
| 21129 | all | Victoria | 327 | 1,753 | 1 | 9 | 10,251 | 5.36 |
| 21134 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 21137 | all | Victoria | 136 | 705 | 1 | 9 | 3,987 | 5.18 |
| 21139 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 21142 | all | Victoria | 14 | 83 | 2 | 9 | 577 | 5.93 |
| 21143 | all | Victoria | 6 | 31 | 4 | 7 | 165 | 5.17 |
| 21146 | all | Victoria | 1 | 7 | 7 | 7 | 49 | 7 |
| 21147 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 21148 | all | Victoria | 10 | 64 | 3 | 9 | 450 | 6.4 |
| 21150 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 21155 | all | Victoria | 7 | 43 | 5 | 8 | 277 | 6.14 |
| 21158 | all | Victoria | 202 | 1,101 | 1 | 9 | 6,691 | 5.45 |
| 21160 | all | Victoria | 25 | 142 | 3 | 9 | 848 | 5.68 |
| 21163 | all | Victoria | 23 | 126 | 3 | 8 | 732 | 5.48 |
| 21164 | all | Victoria | 3 | 17 | 5 | 6 | 97 | 5.67 |
| 21165 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 21166 | all | Victoria | 4 | 31 | 7 | 8 | 241 | 7.75 |