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 81 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 21531 | all | Victoria | 2,885 | 16,058 | 1 | 9 | 94,692 | 5.57 |
| 21535 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 21537 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 21538 | all | Victoria | 5 | 33 | 5 | 9 | 229 | 6.6 |
| 21541 | all | Victoria | 3 | 19 | 5 | 9 | 131 | 6.33 |
| 21542 | all | Victoria | 1,060 | 5,742 | 1 | 9 | 34,956 | 5.42 |
| 21550 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 21553 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 21557 | all | Victoria | 3 | 7 | 1 | 5 | 27 | 2.33 |
| 21558 | all | Victoria | 15 | 80 | 5 | 8 | 438 | 5.33 |
| 21560 | all | Victoria | 4 | 19 | 4 | 5 | 91 | 4.75 |
| 21561 | all | Victoria | 9 | 59 | 4 | 9 | 419 | 6.56 |
| 21562 | all | Victoria | 175 | 1,068 | 1 | 9 | 7,142 | 6.1 |
| 21565 | all | Victoria | 1 | 6 | 6 | 6 | 36 | 6 |
| 21570 | all | Victoria | 6 | 31 | 5 | 6 | 161 | 5.17 |
| 21571 | all | Victoria | 73 | 407 | 3 | 9 | 2,403 | 5.58 |
| 21575 | all | Victoria | 1 | 7 | 7 | 7 | 49 | 7 |
| 21576 | all | Victoria | 2 | 10 | 5 | 5 | 50 | 5 |
| 21578 | all | Victoria | 11 | 64 | 4 | 8 | 392 | 5.82 |
| 21579 | all | Victoria | 2 | 10 | 5 | 5 | 50 | 5 |
| 21583 | all | Victoria | 60 | 314 | 2 | 8 | 1,770 | 5.23 |
| 21584 | all | Victoria | 121 | 677 | 2 | 9 | 4,151 | 5.6 |
| 21585 | all | Victoria | 18 | 87 | 2 | 7 | 465 | 4.83 |
| 21588 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 21589 | all | Victoria | 2 | 11 | 5 | 6 | 61 | 5.5 |