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 104 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 30133 | all | Queensland | 2 | 15 | 7 | 8 | 113 | 7.5 |
| 30135 | all | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 30137 | all | Queensland | 2 | 16 | 8 | 8 | 128 | 8 |
| 30141 | all | Queensland | 11 | 72 | 4 | 8 | 488 | 6.55 |
| 30142 | all | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 30148 | all | Queensland | 5 | 27 | 5 | 7 | 149 | 5.4 |
| 30151 | all | Queensland | 15 | 80 | 2 | 9 | 492 | 5.33 |
| 30153 | all | Queensland | 32 | 175 | 1 | 9 | 1,055 | 5.47 |
| 30154 | all | Queensland | 4 | 26 | 5 | 8 | 178 | 6.5 |
| 30157 | all | Queensland | 198 | 1,147 | 1 | 9 | 7,339 | 5.79 |
| 30158 | all | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 30161 | all | Queensland | 3 | 15 | 5 | 5 | 75 | 5 |
| 30173 | all | Queensland | 2 | 14 | 5 | 9 | 106 | 7 |
| 30176 | all | Queensland | 17 | 100 | 4 | 8 | 614 | 5.88 |
| 30180 | all | Queensland | 4 | 21 | 5 | 6 | 111 | 5.25 |
| 30190 | all | Queensland | 706 | 3,672 | 1 | 9 | 22,516 | 5.2 |
| 30193 | all | Queensland | 29 | 178 | 1 | 9 | 1,244 | 6.14 |
| 30195 | all | Queensland | 5 | 28 | 5 | 7 | 160 | 5.6 |
| 30196 | all | Queensland | 1 | 7 | 7 | 7 | 49 | 7 |
| 30198 | all | Queensland | 36 | 205 | 3 | 9 | 1,245 | 5.69 |
| 30202 | all | Queensland | 11 | 81 | 3 | 9 | 643 | 7.36 |
| 30203 | all | Queensland | 34 | 178 | 1 | 9 | 990 | 5.24 |
| 30205 | all | Queensland | 122 | 666 | 1 | 9 | 4,086 | 5.46 |
| 30207 | all | Queensland | 2 | 8 | 3 | 5 | 34 | 4 |
| 30211 | all | Queensland | 3 | 16 | 5 | 6 | 86 | 5.33 |