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 98 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 22651 | all | Victoria | 7 | 38 | 5 | 8 | 214 | 5.43 |
| 22653 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 22656 | all | Victoria | 1 | 9 | 9 | 9 | 81 | 9 |
| 22661 | all | Victoria | 1,317 | 7,510 | 1 | 9 | 45,684 | 5.7 |
| 22663 | all | Victoria | 8 | 41 | 5 | 6 | 211 | 5.12 |
| 22666 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 22668 | all | Victoria | 2 | 10 | 5 | 5 | 50 | 5 |
| 22670 | all | Victoria | 1 | 8 | 8 | 8 | 64 | 8 |
| 22671 | all | Victoria | 13 | 73 | 3 | 9 | 435 | 5.62 |
| 22672 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 22673 | all | Victoria | 4 | 26 | 5 | 9 | 180 | 6.5 |
| 22676 | all | Victoria | 9 | 59 | 4 | 9 | 411 | 6.56 |
| 22680 | all | Victoria | 1,046 | 5,641 | 1 | 9 | 33,245 | 5.39 |
| 22681 | all | Victoria | 2 | 10 | 5 | 5 | 50 | 5 |
| 22685 | all | Victoria | 46 | 276 | 3 | 9 | 1,774 | 6 |
| 22688 | all | Victoria | 2 | 13 | 5 | 8 | 89 | 6.5 |
| 22689 | all | Victoria | 130 | 709 | 1 | 9 | 4,307 | 5.45 |
| 22690 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 22695 | all | Victoria | 11 | 67 | 3 | 8 | 439 | 6.09 |
| 22697 | all | Victoria | 2 | 12 | 5 | 7 | 74 | 6 |
| 22698 | all | Victoria | 1,090 | 5,997 | 1 | 9 | 35,675 | 5.5 |
| 22702 | all | Victoria | 9 | 59 | 4 | 9 | 415 | 6.56 |
| 22706 | all | Victoria | 6 | 32 | 5 | 7 | 174 | 5.33 |
| 22707 | all | Victoria | 2 | 11 | 5 | 6 | 61 | 5.5 |
| 22708 | all | Victoria | 4 | 20 | 5 | 5 | 100 | 5 |