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 95 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 22466 | all | Victoria | 1 | 9 | 9 | 9 | 81 | 9 |
| 22467 | all | Victoria | 755 | 4,174 | 1 | 9 | 25,058 | 5.53 |
| 22469 | all | Victoria | 11 | 58 | 5 | 8 | 314 | 5.27 |
| 22470 | all | Victoria | 66 | 412 | 2 | 9 | 2,764 | 6.24 |
| 22476 | all | Victoria | 3 | 15 | 2 | 8 | 93 | 5 |
| 22477 | all | Victoria | 1 | 7 | 7 | 7 | 49 | 7 |
| 22479 | all | Victoria | 16 | 84 | 2 | 8 | 464 | 5.25 |
| 22483 | all | Victoria | 26 | 132 | 1 | 9 | 794 | 5.08 |
| 22488 | all | Victoria | 138 | 878 | 1 | 9 | 6,120 | 6.36 |
| 22489 | all | Victoria | 7 | 37 | 5 | 7 | 199 | 5.29 |
| 22495 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 22496 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 22499 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 22502 | all | Victoria | 10 | 51 | 5 | 6 | 261 | 5.1 |
| 22504 | all | Victoria | 20 | 84 | 1 | 8 | 474 | 4.2 |
| 22505 | all | Victoria | 25 | 129 | 3 | 9 | 689 | 5.16 |
| 22507 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 22508 | all | Victoria | 133 | 769 | 1 | 9 | 4,963 | 5.78 |
| 22510 | all | Victoria | 3 | 22 | 5 | 9 | 170 | 7.33 |
| 22516 | all | Victoria | 5 | 27 | 5 | 6 | 147 | 5.4 |
| 22518 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 22521 | all | Victoria | 3 | 17 | 5 | 7 | 99 | 5.67 |
| 22523 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 22525 | all | Victoria | 2 | 10 | 5 | 5 | 50 | 5 |
| 22526 | all | Victoria | 5 | 28 | 4 | 7 | 164 | 5.6 |