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 146 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 40197 | all | South Australia | 3 | 19 | 5 | 7 | 123 | 6.33 |
| 40200 | all | South Australia | 7 | 37 | 2 | 8 | 217 | 5.29 |
| 40201 | all | South Australia | 1 | 7 | 7 | 7 | 49 | 7 |
| 40203 | all | South Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 40210 | all | South Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 40215 | all | South Australia | 6 | 32 | 5 | 7 | 174 | 5.33 |
| 40221 | all | South Australia | 6 | 30 | 5 | 5 | 150 | 5 |
| 40227 | all | South Australia | 17 | 108 | 3 | 9 | 734 | 6.35 |
| 40228 | all | South Australia | 5 | 25 | 5 | 5 | 125 | 5 |
| 40229 | all | South Australia | 23 | 120 | 2 | 9 | 692 | 5.22 |
| 40237 | all | South Australia | 520 | 2,874 | 1 | 9 | 17,060 | 5.53 |
| 40243 | all | South Australia | 1 | 8 | 8 | 8 | 64 | 8 |
| 40249 | all | South Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 40259 | all | South Australia | 58 | 312 | 1 | 9 | 1,814 | 5.38 |
| 40262 | all | South Australia | 3 | 27 | 9 | 9 | 243 | 9 |
| 40267 | all | South Australia | 34 | 191 | 5 | 9 | 1,123 | 5.62 |
| 40268 | all | South Australia | 1 | 7 | 7 | 7 | 49 | 7 |
| 40269 | all | South Australia | 14 | 86 | 5 | 8 | 546 | 6.14 |
| 40273 | all | South Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 40275 | all | South Australia | 2 | 10 | 5 | 5 | 50 | 5 |
| 40276 | all | South Australia | 1 | 9 | 9 | 9 | 81 | 9 |
| 40277 | all | South Australia | 5 | 25 | 5 | 5 | 125 | 5 |
| 40278 | all | South Australia | 33 | 191 | 2 | 9 | 1,187 | 5.79 |
| 40280 | all | South Australia | 52 | 288 | 2 | 9 | 1,702 | 5.54 |
| 40281 | all | South Australia | 1 | 9 | 9 | 9 | 81 | 9 |