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 248 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 50574 | income | Western Australia | 3 | 17 | 3 | 7 | 107 | 5.67 |
| 50577 | income | Western Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 50590 | income | Western Australia | 3 | 19 | 5 | 9 | 131 | 6.33 |
| 50605 | income | Western Australia | 1 | 7 | 7 | 7 | 49 | 7 |
| 50615 | income | Western Australia | 1 | 3 | 3 | 3 | 9 | 3 |
| 50637 | income | Western Australia | 1 | 8 | 8 | 8 | 64 | 8 |
| 50654 | income | Western Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 50699 | income | Western Australia | 1 | 1 | 1 | 1 | 1 | 1 |
| 50709 | income | Western Australia | 2 | 13 | 5 | 8 | 89 | 6.5 |
| 50712 | income | Western Australia | 16 | 90 | 4 | 8 | 534 | 5.62 |
| 50716 | income | Western Australia | 1 | 6 | 6 | 6 | 36 | 6 |
| 50718 | income | Western Australia | 1 | 9 | 9 | 9 | 81 | 9 |
| 50726 | income | Western Australia | 1 | 7 | 7 | 7 | 49 | 7 |
| 50737 | income | Western Australia | 39 | 227 | 1 | 9 | 1,531 | 5.82 |
| 50742 | income | Western Australia | 8 | 36 | 1 | 8 | 210 | 4.5 |
| 50747 | income | Western Australia | 1 | 9 | 9 | 9 | 81 | 9 |
| 50762 | income | Western Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 50769 | income | Western Australia | 1 | 9 | 9 | 9 | 81 | 9 |
| 50799 | income | Western Australia | 9 | 60 | 5 | 8 | 414 | 6.67 |
| 50806 | income | Western Australia | 3 | 21 | 6 | 9 | 153 | 7 |
| 50830 | income | Western Australia | 1 | 7 | 7 | 7 | 49 | 7 |
| 50840 | income | Western Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 50846 | income | Western Australia | 1 | 3 | 3 | 3 | 9 | 3 |
| 50891 | income | Western Australia | 2 | 12 | 5 | 7 | 74 | 6 |
| 50893 | income | Western Australia | 1 | 9 | 9 | 9 | 81 | 9 |