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 135 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 32540 | all | Queensland | 170 | 852 | 1 | 9 | 5,160 | 5.01 |
| 32542 | all | Queensland | 2 | 8 | 3 | 5 | 34 | 4 |
| 32547 | all | Queensland | 16 | 94 | 2 | 9 | 610 | 5.88 |
| 32548 | all | Queensland | 2 | 10 | 5 | 5 | 50 | 5 |
| 32549 | all | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 32552 | all | Queensland | 21,584 | 119,291 | 1 | 9 | 725,885 | 5.53 |
| 32553 | all | Queensland | 17 | 99 | 2 | 9 | 625 | 5.82 |
| 32556 | all | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 32557 | all | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 32558 | all | Queensland | 13 | 75 | 5 | 8 | 453 | 5.77 |
| 32559 | all | Queensland | 2 | 10 | 5 | 5 | 50 | 5 |
| 32560 | all | Queensland | 10 | 72 | 2 | 9 | 562 | 7.2 |
| 32561 | all | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 32583 | all | Queensland | 5 | 28 | 5 | 8 | 164 | 5.6 |
| 32588 | all | Queensland | 89 | 574 | 2 | 9 | 3,990 | 6.45 |
| 32592 | all | Queensland | 2 | 8 | 1 | 7 | 50 | 4 |
| 32596 | all | Queensland | 81 | 445 | 2 | 9 | 2,617 | 5.49 |
| 32610 | all | Queensland | 7 | 38 | 3 | 8 | 222 | 5.43 |
| 32612 | all | Queensland | 2 | 12 | 5 | 7 | 74 | 6 |
| 32623 | all | Queensland | 1 | 9 | 9 | 9 | 81 | 9 |
| 32625 | all | Queensland | 35 | 205 | 5 | 9 | 1,265 | 5.86 |
| 32631 | all | Queensland | 3 | 15 | 5 | 5 | 75 | 5 |
| 32633 | all | Queensland | 99 | 532 | 2 | 9 | 3,078 | 5.37 |
| 32644 | all | Queensland | 13 | 88 | 5 | 9 | 612 | 6.77 |
| 32645 | all | Queensland | 3 | 21 | 4 | 9 | 161 | 7 |