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 159 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 41224 | all | South Australia | 2 | 13 | 5 | 8 | 89 | 6.5 |
| 41233 | all | South Australia | 5 | 31 | 5 | 9 | 205 | 6.2 |
| 41235 | all | South Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 41238 | all | South Australia | 7 | 43 | 5 | 8 | 273 | 6.14 |
| 41241 | all | South Australia | 2 | 10 | 3 | 7 | 58 | 5 |
| 41248 | all | South Australia | 45 | 245 | 1 | 9 | 1,445 | 5.44 |
| 41252 | all | South Australia | 1 | 9 | 9 | 9 | 81 | 9 |
| 41253 | all | South Australia | 13 | 83 | 3 | 9 | 567 | 6.38 |
| 41261 | all | South Australia | 2 | 10 | 5 | 5 | 50 | 5 |
| 41263 | all | South Australia | 15 | 88 | 3 | 8 | 568 | 5.87 |
| 41264 | all | South Australia | 91 | 503 | 2 | 9 | 3,029 | 5.53 |
| 41277 | all | South Australia | 9 | 57 | 5 | 7 | 367 | 6.33 |
| 41281 | all | South Australia | 223 | 1,134 | 1 | 9 | 6,512 | 5.09 |
| 41282 | all | South Australia | 17 | 108 | 4 | 9 | 728 | 6.35 |
| 41287 | all | South Australia | 8 | 55 | 5 | 9 | 397 | 6.88 |
| 41291 | all | South Australia | 1 | 7 | 7 | 7 | 49 | 7 |
| 41292 | all | South Australia | 1 | 6 | 6 | 6 | 36 | 6 |
| 41300 | all | South Australia | 2 | 11 | 5 | 6 | 61 | 5.5 |
| 41302 | all | South Australia | 2 | 14 | 6 | 8 | 100 | 7 |
| 41303 | all | South Australia | 1 | 8 | 8 | 8 | 64 | 8 |
| 41305 | all | South Australia | 4 | 20 | 5 | 5 | 100 | 5 |
| 41311 | all | South Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 41316 | all | South Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 41319 | all | South Australia | 4 | 18 | 3 | 5 | 84 | 4.5 |
| 41323 | all | South Australia | 10 | 62 | 5 | 8 | 402 | 6.2 |