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 100 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 22788 | all | Victoria | 5 | 29 | 5 | 9 | 181 | 5.8 |
| 22800 | all | Victoria | 22 | 139 | 4 | 9 | 921 | 6.32 |
| 22802 | all | Victoria | 20 | 100 | 2 | 9 | 570 | 5 |
| 22806 | all | Victoria | 2 | 10 | 5 | 5 | 50 | 5 |
| 22812 | all | Victoria | 1 | 6 | 6 | 6 | 36 | 6 |
| 22815 | all | Victoria | 6 | 34 | 5 | 9 | 206 | 5.67 |
| 22818 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 22819 | all | Victoria | 1,862 | 10,297 | 1 | 9 | 61,849 | 5.53 |
| 22820 | all | Victoria | 13 | 64 | 3 | 8 | 332 | 4.92 |
| 22823 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 22824 | all | Victoria | 294 | 1,634 | 3 | 9 | 9,542 | 5.56 |
| 22829 | all | Victoria | 216 | 1,238 | 1 | 9 | 7,804 | 5.73 |
| 22832 | all | Victoria | 4 | 22 | 5 | 7 | 124 | 5.5 |
| 22833 | all | Victoria | 173 | 949 | 1 | 9 | 5,805 | 5.49 |
| 22838 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 22841 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 22842 | all | Victoria | 4 | 23 | 5 | 8 | 139 | 5.75 |
| 22843 | all | Victoria | 3 | 16 | 5 | 6 | 86 | 5.33 |
| 22848 | all | Victoria | 70 | 397 | 2 | 9 | 2,425 | 5.67 |
| 22851 | all | Victoria | 3 | 16 | 5 | 6 | 86 | 5.33 |
| 22853 | all | Victoria | 2 | 12 | 5 | 7 | 74 | 6 |
| 22855 | all | Victoria | 2 | 10 | 5 | 5 | 50 | 5 |
| 22857 | all | Victoria | 42 | 241 | 1 | 9 | 1,553 | 5.74 |
| 22861 | all | Victoria | 3 | 15 | 5 | 5 | 75 | 5 |
| 22862 | all | Victoria | 1 | 4 | 4 | 4 | 16 | 4 |