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 111 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 30670 | all | Queensland | 14 | 72 | 4 | 9 | 390 | 5.14 |
| 30671 | all | Queensland | 2 | 10 | 5 | 5 | 50 | 5 |
| 30675 | all | Queensland | 32 | 182 | 1 | 9 | 1,152 | 5.69 |
| 30676 | all | Queensland | 2 | 10 | 5 | 5 | 50 | 5 |
| 30677 | all | Queensland | 2 | 10 | 5 | 5 | 50 | 5 |
| 30678 | all | Queensland | 4 | 26 | 5 | 9 | 180 | 6.5 |
| 30683 | all | Queensland | 16 | 81 | 3 | 7 | 419 | 5.06 |
| 30685 | all | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 30686 | all | Queensland | 7 | 41 | 5 | 9 | 255 | 5.86 |
| 30687 | all | Queensland | 4 | 28 | 5 | 9 | 212 | 7 |
| 30688 | all | Queensland | 2 | 10 | 3 | 7 | 58 | 5 |
| 30691 | all | Queensland | 3 | 16 | 2 | 7 | 102 | 5.33 |
| 30700 | all | Queensland | 4 | 21 | 5 | 6 | 111 | 5.25 |
| 30702 | all | Queensland | 18 | 127 | 3 | 9 | 953 | 7.06 |
| 30705 | all | Queensland | 61 | 316 | 1 | 9 | 1,860 | 5.18 |
| 30707 | all | Queensland | 8 | 43 | 5 | 7 | 235 | 5.38 |
| 30712 | all | Queensland | 2 | 9 | 4 | 5 | 41 | 4.5 |
| 30713 | all | Queensland | 2 | 12 | 5 | 7 | 74 | 6 |
| 30717 | all | Queensland | 2 | 10 | 5 | 5 | 50 | 5 |
| 30720 | all | Queensland | 3 | 12 | 2 | 5 | 54 | 4 |
| 30723 | all | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 30728 | all | Queensland | 4 | 20 | 5 | 5 | 100 | 5 |
| 30734 | all | Queensland | 2 | 10 | 5 | 5 | 50 | 5 |
| 30735 | all | Queensland | 3 | 20 | 5 | 8 | 138 | 6.67 |
| 30737 | all | Queensland | 2 | 10 | 5 | 5 | 50 | 5 |