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 169 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 50278 | all | Western Australia | 12 | 72 | 4 | 8 | 458 | 6 |
| 50279 | all | Western Australia | 17 | 93 | 3 | 9 | 553 | 5.47 |
| 50287 | all | Western Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 50288 | all | Western Australia | 4 | 23 | 5 | 8 | 139 | 5.75 |
| 50290 | all | Western Australia | 7 | 36 | 4 | 7 | 190 | 5.14 |
| 50291 | all | Western Australia | 2 | 7 | 3 | 4 | 25 | 3.5 |
| 50295 | all | Western Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 50300 | all | Western Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 50301 | all | Western Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 50305 | all | Western Australia | 3 | 15 | 5 | 5 | 75 | 5 |
| 50310 | all | Western Australia | 51 | 296 | 1 | 9 | 1,864 | 5.8 |
| 50314 | all | Western Australia | 21 | 130 | 3 | 9 | 876 | 6.19 |
| 50317 | all | Western Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 50320 | all | Western Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 50322 | all | Western Australia | 1 | 6 | 6 | 6 | 36 | 6 |
| 50326 | all | Western Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 50327 | all | Western Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 50330 | all | Western Australia | 1 | 7 | 7 | 7 | 49 | 7 |
| 50334 | all | Western Australia | 1 | 9 | 9 | 9 | 81 | 9 |
| 50338 | all | Western Australia | 29 | 157 | 3 | 9 | 915 | 5.41 |
| 50340 | all | Western Australia | 3 | 21 | 5 | 9 | 155 | 7 |
| 50341 | all | Western Australia | 2 | 10 | 5 | 5 | 50 | 5 |
| 50342 | all | Western Australia | 2 | 10 | 5 | 5 | 50 | 5 |
| 50343 | all | Western Australia | 44 | 247 | 3 | 9 | 1,467 | 5.61 |
| 50347 | all | Western Australia | 42 | 232 | 3 | 8 | 1,342 | 5.52 |