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 271 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 51448 | crime | Western Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 51614 | crime | Western Australia | 6 | 28 | 2 | 7 | 148 | 4.67 |
| 51667 | crime | Western Australia | 1 | 5 | 5 | 5 | 25 | 5 |
| 60017 | crime | Tasmania | 4 | 7 | 1 | 4 | 19 | 1.75 |
| 60021 | crime | Tasmania | 1 | 5 | 5 | 5 | 25 | 5 |
| 60034 | crime | Tasmania | 1 | 4 | 4 | 4 | 16 | 4 |
| 60059 | crime | Tasmania | 2 | 3 | 1 | 2 | 5 | 1.5 |
| 60120 | crime | Tasmania | 1 | 5 | 5 | 5 | 25 | 5 |
| 60143 | crime | Tasmania | 20 | 61 | 1 | 7 | 263 | 3.05 |
| 60146 | crime | Tasmania | 1 | 7 | 7 | 7 | 49 | 7 |
| 60153 | crime | Tasmania | 1 | 2 | 2 | 2 | 4 | 2 |
| 60156 | crime | Tasmania | 2 | 15 | 6 | 9 | 117 | 7.5 |
| 60157 | crime | Tasmania | 1 | 1 | 1 | 1 | 1 | 1 |
| 60225 | crime | Tasmania | 2 | 6 | 1 | 5 | 26 | 3 |
| 60248 | crime | Tasmania | 7 | 31 | 1 | 9 | 197 | 4.43 |
| 60253 | crime | Tasmania | 2 | 6 | 1 | 5 | 26 | 3 |
| 60254 | crime | Tasmania | 7 | 35 | 2 | 9 | 235 | 5 |
| 60276 | crime | Tasmania | 164 | 554 | 1 | 9 | 2,694 | 3.38 |
| 60285 | crime | Tasmania | 1 | 1 | 1 | 1 | 1 | 1 |
| 60316 | crime | Tasmania | 2 | 8 | 3 | 5 | 34 | 4 |
| 60318 | crime | Tasmania | 1 | 4 | 4 | 4 | 16 | 4 |
| 60322 | crime | Tasmania | 53 | 212 | 1 | 9 | 1,156 | 4 |
| 60324 | crime | Tasmania | 1 | 5 | 5 | 5 | 25 | 5 |
| 60392 | crime | Tasmania | 1 | 5 | 5 | 5 | 25 | 5 |
| 60450 | crime | Tasmania | 2 | 8 | 2 | 6 | 40 | 4 |