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 142 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 33139 | all | Queensland | 8 | 46 | 5 | 7 | 270 | 5.75 |
| 33141 | all | Queensland | 4 | 20 | 2 | 9 | 126 | 5 |
| 33144 | all | Queensland | 29 | 158 | 2 | 9 | 956 | 5.45 |
| 33145 | all | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 33149 | all | Queensland | 2 | 8 | 3 | 5 | 34 | 4 |
| 33150 | all | Queensland | 5 | 35 | 5 | 9 | 261 | 7 |
| 33151 | all | Queensland | 2 | 10 | 5 | 5 | 50 | 5 |
| 33157 | all | Queensland | 7 | 43 | 4 | 8 | 277 | 6.14 |
| 33161 | all | Queensland | 15,442 | 84,674 | 1 | 9 | 499,598 | 5.48 |
| 33163 | all | Queensland | 4 | 24 | 5 | 9 | 156 | 6 |
| 33166 | all | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 33169 | all | Queensland | 3 | 15 | 5 | 5 | 75 | 5 |
| 33171 | all | Queensland | 2 | 10 | 5 | 5 | 50 | 5 |
| 33173 | all | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 33182 | all | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 33187 | all | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 33188 | all | Queensland | 34 | 213 | 5 | 9 | 1,391 | 6.26 |
| 33190 | all | Queensland | 97 | 535 | 1 | 9 | 3,421 | 5.52 |
| 33193 | all | Queensland | 23 | 132 | 2 | 9 | 822 | 5.74 |
| 33195 | all | Queensland | 4 | 23 | 4 | 7 | 139 | 5.75 |
| 33197 | all | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 33198 | all | Queensland | 2 | 14 | 6 | 8 | 100 | 7 |
| 33202 | all | Queensland | 56 | 360 | 1 | 9 | 2,484 | 6.43 |
| 33204 | all | Queensland | 3 | 12 | 3 | 5 | 50 | 4 |
| 33207 | all | Queensland | 12 | 75 | 5 | 9 | 495 | 6.25 |