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 64 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 20345 | all | Victoria | 137 | 733 | 2 | 9 | 4,093 | 5.35 |
| 20348 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 20350 | all | Victoria | 6 | 35 | 3 | 8 | 221 | 5.83 |
| 20354 | all | Victoria | 3 | 15 | 5 | 5 | 75 | 5 |
| 20360 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 20363 | all | Victoria | 2 | 11 | 3 | 8 | 73 | 5.5 |
| 20364 | all | Victoria | 7 | 39 | 4 | 9 | 233 | 5.57 |
| 20365 | all | Victoria | 5 | 30 | 5 | 8 | 188 | 6 |
| 20366 | all | Victoria | 9 | 53 | 4 | 8 | 329 | 5.89 |
| 20368 | all | Victoria | 2 | 14 | 5 | 9 | 106 | 7 |
| 20369 | all | Victoria | 3 | 16 | 5 | 6 | 86 | 5.33 |
| 20373 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 20375 | all | Victoria | 27 | 140 | 4 | 7 | 734 | 5.19 |
| 20378 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 20380 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 20381 | all | Victoria | 5 | 26 | 4 | 7 | 140 | 5.2 |
| 20386 | all | Victoria | 44 | 226 | 3 | 9 | 1,238 | 5.14 |
| 20387 | all | Victoria | 1 | 7 | 7 | 7 | 49 | 7 |
| 20391 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 20392 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 20395 | all | Victoria | 5 | 31 | 3 | 8 | 211 | 6.2 |
| 20402 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 20409 | all | Victoria | 18 | 101 | 4 | 9 | 593 | 5.61 |
| 20411 | all | Victoria | 5 | 28 | 2 | 8 | 182 | 5.6 |
| 20418 | all | Victoria | 21 | 137 | 5 | 9 | 951 | 6.52 |