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 69 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 20688 | all | Victoria | 4 | 20 | 5 | 5 | 100 | 5 |
| 20690 | all | Victoria | 3 | 19 | 5 | 9 | 131 | 6.33 |
| 20691 | all | Victoria | 6 | 36 | 5 | 8 | 228 | 6 |
| 20692 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 20701 | all | Victoria | 2 | 10 | 5 | 5 | 50 | 5 |
| 20702 | all | Victoria | 330 | 1,794 | 1 | 9 | 10,374 | 5.44 |
| 20706 | all | Victoria | 2 | 10 | 5 | 5 | 50 | 5 |
| 20707 | all | Victoria | 25 | 129 | 1 | 8 | 729 | 5.16 |
| 20711 | all | Victoria | 10 | 48 | 3 | 5 | 234 | 4.8 |
| 20715 | all | Victoria | 3 | 22 | 5 | 9 | 170 | 7.33 |
| 20719 | all | Victoria | 7 | 38 | 4 | 7 | 214 | 5.43 |
| 20721 | all | Victoria | 1,368 | 7,518 | 1 | 9 | 46,170 | 5.5 |
| 20722 | all | Victoria | 2 | 10 | 5 | 5 | 50 | 5 |
| 20723 | all | Victoria | 5 | 27 | 4 | 8 | 155 | 5.4 |
| 20729 | all | Victoria | 5 | 25 | 5 | 5 | 125 | 5 |
| 20730 | all | Victoria | 1 | 7 | 7 | 7 | 49 | 7 |
| 20736 | all | Victoria | 21 | 133 | 5 | 8 | 879 | 6.33 |
| 20738 | all | Victoria | 13 | 73 | 2 | 9 | 453 | 5.62 |
| 20741 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 20742 | all | Victoria | 6 | 36 | 5 | 7 | 220 | 6 |
| 20743 | all | Victoria | 5 | 25 | 5 | 5 | 125 | 5 |
| 20744 | all | Victoria | 3 | 18 | 5 | 7 | 110 | 6 |
| 20745 | all | Victoria | 2 | 10 | 5 | 5 | 50 | 5 |
| 20746 | all | Victoria | 3 | 17 | 5 | 7 | 99 | 5.67 |
| 20754 | all | Victoria | 120 | 684 | 1 | 9 | 4,336 | 5.7 |