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 187 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 51595 | all | Western Australia | 8 | 49 | 5 | 9 | 323 | 6.12 |
| 51597 | all | Western Australia | 3 | 15 | 5 | 5 | 75 | 5 |
| 51600 | all | Western Australia | 3 | 24 | 8 | 8 | 192 | 8 |
| 51601 | all | Western Australia | 285 | 1,520 | 3 | 9 | 8,406 | 5.33 |
| 51602 | all | Western Australia | 2 | 8 | 3 | 5 | 34 | 4 |
| 51604 | all | Western Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 51605 | all | Western Australia | 2 | 12 | 5 | 7 | 74 | 6 |
| 51612 | all | Western Australia | 10 | 57 | 5 | 7 | 333 | 5.7 |
| 51613 | all | Western Australia | 2 | 9 | 4 | 5 | 41 | 4.5 |
| 51614 | all | Western Australia | 63 | 356 | 1 | 9 | 2,252 | 5.65 |
| 51617 | all | Western Australia | 61 | 308 | 3 | 8 | 1,570 | 5.05 |
| 51618 | all | Western Australia | 32 | 179 | 4 | 8 | 1,045 | 5.59 |
| 51619 | all | Western Australia | 46 | 239 | 4 | 8 | 1,267 | 5.2 |
| 51622 | all | Western Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 51624 | all | Western Australia | 2 | 13 | 5 | 8 | 89 | 6.5 |
| 51626 | all | Western Australia | 3 | 18 | 5 | 7 | 110 | 6 |
| 51632 | all | Western Australia | 29 | 158 | 2 | 8 | 934 | 5.45 |
| 51636 | all | Western Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 51640 | all | Western Australia | 7 | 41 | 5 | 7 | 247 | 5.86 |
| 51645 | all | Western Australia | 4 | 24 | 5 | 8 | 150 | 6 |
| 51646 | all | Western Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 51649 | all | Western Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 51651 | all | Western Australia | 24 | 157 | 4 | 9 | 1,083 | 6.54 |
| 51654 | all | Western Australia | 28 | 173 | 4 | 9 | 1,129 | 6.18 |
| 51655 | all | Western Australia | 1 | 5 | 5 | 5 | 25 | 5 |