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 70 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 20756 | all | Victoria | 65 | 385 | 2 | 9 | 2,485 | 5.92 |
| 20757 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 20760 | all | Victoria | 16 | 102 | 5 | 9 | 686 | 6.38 |
| 20762 | all | Victoria | 13 | 76 | 4 | 9 | 478 | 5.85 |
| 20764 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 20766 | all | Victoria | 97 | 548 | 1 | 9 | 3,396 | 5.65 |
| 20768 | all | Victoria | 5 | 33 | 5 | 9 | 227 | 6.6 |
| 20770 | all | Victoria | 665 | 3,385 | 2 | 9 | 17,775 | 5.09 |
| 20771 | all | Victoria | 27 | 135 | 2 | 8 | 759 | 5 |
| 20773 | all | Victoria | 3 | 16 | 4 | 7 | 90 | 5.33 |
| 20777 | all | Victoria | 30 | 149 | 2 | 9 | 775 | 4.97 |
| 20779 | all | Victoria | 9 | 51 | 5 | 8 | 303 | 5.67 |
| 20782 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 20783 | all | Victoria | 16 | 84 | 1 | 8 | 484 | 5.25 |
| 20788 | all | Victoria | 20 | 122 | 4 | 9 | 790 | 6.1 |
| 20790 | all | Victoria | 369 | 1,821 | 1 | 9 | 10,011 | 4.93 |
| 20798 | all | Victoria | 73 | 425 | 3 | 9 | 2,619 | 5.82 |
| 20802 | all | Victoria | 2,696 | 16,352 | 1 | 9 | 108,740 | 6.07 |
| 20804 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 20809 | all | Victoria | 25 | 146 | 4 | 9 | 890 | 5.84 |
| 20812 | all | Victoria | 12 | 69 | 4 | 9 | 421 | 5.75 |
| 20813 | all | Victoria | 8 | 46 | 5 | 8 | 274 | 5.75 |
| 20814 | all | Victoria | 10 | 69 | 3 | 9 | 509 | 6.9 |
| 20822 | all | Victoria | 1 | 7 | 7 | 7 | 49 | 7 |
| 20823 | all | Victoria | 17 | 104 | 2 | 9 | 690 | 6.12 |