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 92 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 22248 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 22250 | all | Victoria | 1 | 7 | 7 | 7 | 49 | 7 |
| 22251 | all | Victoria | 3 | 15 | 5 | 5 | 75 | 5 |
| 22253 | all | Victoria | 7 | 43 | 6 | 7 | 265 | 6.14 |
| 22254 | all | Victoria | 2 | 15 | 7 | 8 | 113 | 7.5 |
| 22261 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 22262 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 22263 | all | Victoria | 329 | 1,872 | 1 | 9 | 12,206 | 5.69 |
| 22265 | all | Victoria | 197 | 1,043 | 1 | 9 | 6,073 | 5.29 |
| 22270 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 22271 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 22272 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 22273 | all | Victoria | 1 | 6 | 6 | 6 | 36 | 6 |
| 22274 | all | Victoria | 1 | 7 | 7 | 7 | 49 | 7 |
| 22275 | all | Victoria | 1,859 | 10,949 | 1 | 9 | 69,983 | 5.89 |
| 22278 | all | Victoria | 4 | 22 | 5 | 7 | 124 | 5.5 |
| 22279 | all | Victoria | 13 | 94 | 5 | 9 | 714 | 7.23 |
| 22281 | all | Victoria | 5 | 33 | 5 | 9 | 229 | 6.6 |
| 22287 | all | Victoria | 3 | 17 | 5 | 7 | 99 | 5.67 |
| 22290 | all | Victoria | 3 | 18 | 5 | 8 | 114 | 6 |
| 22293 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 22294 | all | Victoria | 26 | 130 | 2 | 9 | 722 | 5 |
| 22295 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 22299 | all | Victoria | 7 | 37 | 5 | 6 | 197 | 5.29 |
| 22301 | all | Victoria | 32 | 206 | 3 | 9 | 1,410 | 6.44 |