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 160 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 41325 | all | South Australia | 2 | 12 | 5 | 7 | 74 | 6 |
| 41327 | all | South Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 41329 | all | South Australia | 14 | 88 | 5 | 9 | 584 | 6.29 |
| 41332 | all | South Australia | 2 | 13 | 5 | 8 | 89 | 6.5 |
| 41333 | all | South Australia | 23 | 131 | 4 | 9 | 783 | 5.7 |
| 41334 | all | South Australia | 3 | 15 | 4 | 6 | 77 | 5 |
| 41340 | all | South Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 41342 | all | South Australia | 4 | 26 | 5 | 8 | 178 | 6.5 |
| 41345 | all | South Australia | 5 | 30 | 5 | 8 | 188 | 6 |
| 41349 | all | South Australia | 53 | 260 | 1 | 9 | 1,514 | 4.91 |
| 41350 | all | South Australia | 2 | 12 | 6 | 6 | 72 | 6 |
| 41351 | all | South Australia | 1 | 6 | 6 | 6 | 36 | 6 |
| 41357 | all | South Australia | 4 | 22 | 5 | 7 | 124 | 5.5 |
| 41358 | all | South Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 41360 | all | South Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 41362 | all | South Australia | 1 | 8 | 8 | 8 | 64 | 8 |
| 41364 | all | South Australia | 8 | 43 | 2 | 7 | 249 | 5.38 |
| 41369 | all | South Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 41371 | all | South Australia | 61 | 368 | 2 | 9 | 2,376 | 6.03 |
| 41375 | all | South Australia | 13 | 85 | 3 | 9 | 611 | 6.54 |
| 41377 | all | South Australia | 6 | 31 | 4 | 7 | 165 | 5.17 |
| 41378 | all | South Australia | 11 | 60 | 2 | 8 | 356 | 5.45 |
| 41380 | all | South Australia | 1 | 2 | 2 | 2 | 4 | 2 |
| 41386 | all | South Australia | 3 | 20 | 5 | 8 | 138 | 6.67 |
| 41387 | all | South Australia | 5 | 27 | 3 | 9 | 165 | 5.4 |