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 175 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 50683 | all | Western Australia | 1 | 9 | 9 | 9 | 81 | 9 |
| 50684 | all | Western Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 50686 | all | Western Australia | 6 | 32 | 1 | 8 | 198 | 5.33 |
| 50691 | all | Western Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 50692 | all | Western Australia | 5 | 33 | 5 | 8 | 223 | 6.6 |
| 50699 | all | Western Australia | 1 | 1 | 1 | 1 | 1 | 1 |
| 50700 | all | Western Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 50701 | all | Western Australia | 11 | 55 | 3 | 7 | 289 | 5 |
| 50702 | all | Western Australia | 8 | 42 | 3 | 7 | 236 | 5.25 |
| 50704 | all | Western Australia | 4 | 32 | 5 | 9 | 268 | 8 |
| 50707 | all | Western Australia | 5 | 40 | 5 | 9 | 332 | 8 |
| 50708 | all | Western Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 50709 | all | Western Australia | 95 | 525 | 1 | 9 | 3,119 | 5.53 |
| 50711 | all | Western Australia | 3 | 22 | 5 | 9 | 170 | 7.33 |
| 50712 | all | Western Australia | 345 | 1,859 | 1 | 9 | 10,845 | 5.39 |
| 50714 | all | Western Australia | 1 | 8 | 8 | 8 | 64 | 8 |
| 50716 | all | Western Australia | 5 | 30 | 1 | 8 | 214 | 6 |
| 50717 | all | Western Australia | 13 | 69 | 5 | 8 | 375 | 5.31 |
| 50718 | all | Western Australia | 4 | 24 | 5 | 9 | 156 | 6 |
| 50719 | all | Western Australia | 1 | 9 | 9 | 9 | 81 | 9 |
| 50726 | all | Western Australia | 46 | 243 | 2 | 7 | 1,319 | 5.28 |
| 50731 | all | Western Australia | 1 | 7 | 7 | 7 | 49 | 7 |
| 50732 | all | Western Australia | 4 | 24 | 5 | 7 | 148 | 6 |
| 50733 | all | Western Australia | 1 | 7 | 7 | 7 | 49 | 7 |
| 50735 | all | Western Australia | 1 | 5 | 5 | 5 | 25 | 5 |