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 164 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 41638 | all | South Australia | 4 | 22 | 5 | 7 | 124 | 5.5 |
| 41641 | all | South Australia | 31 | 160 | 3 | 7 | 846 | 5.16 |
| 41642 | all | South Australia | 41 | 231 | 3 | 9 | 1,409 | 5.63 |
| 41646 | all | South Australia | 1 | 8 | 8 | 8 | 64 | 8 |
| 41656 | all | South Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 41659 | all | South Australia | 1 | 7 | 7 | 7 | 49 | 7 |
| 41661 | all | South Australia | 3 | 21 | 5 | 8 | 153 | 7 |
| 41663 | all | South Australia | 1 | 7 | 7 | 7 | 49 | 7 |
| 41667 | all | South Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 41669 | all | South Australia | 2 | 10 | 5 | 5 | 50 | 5 |
| 41670 | all | South Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 41672 | all | South Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 41675 | all | South Australia | 6 | 36 | 4 | 8 | 226 | 6 |
| 41677 | all | South Australia | 2 | 10 | 5 | 5 | 50 | 5 |
| 41681 | all | South Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 41689 | all | South Australia | 2 | 10 | 5 | 5 | 50 | 5 |
| 41695 | all | South Australia | 1 | 3 | 3 | 3 | 9 | 3 |
| 50002 | all | Western Australia | 4 | 23 | 4 | 7 | 139 | 5.75 |
| 50006 | all | Western Australia | 4,902 | 26,774 | 1 | 9 | 160,650 | 5.46 |
| 50009 | all | Western Australia | 2 | 11 | 2 | 9 | 85 | 5.5 |
| 50011 | all | Western Australia | 4 | 21 | 5 | 6 | 111 | 5.25 |
| 50013 | all | Western Australia | 2 | 11 | 5 | 6 | 61 | 5.5 |
| 50017 | all | Western Australia | 10 | 61 | 5 | 9 | 393 | 6.1 |
| 50022 | all | Western Australia | 3 | 20 | 5 | 8 | 138 | 6.67 |
| 50023 | all | Western Australia | 3 | 18 | 5 | 7 | 110 | 6 |