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 264 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 22215 | crime | Victoria | 9 | 39 | 1 | 9 | 247 | 4.33 |
| 22217 | crime | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 22226 | crime | Victoria | 1 | 8 | 8 | 8 | 64 | 8 |
| 22263 | crime | Victoria | 2 | 3 | 1 | 2 | 5 | 1.5 |
| 22265 | crime | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 22275 | crime | Victoria | 3 | 8 | 2 | 4 | 24 | 2.67 |
| 22326 | crime | Victoria | 1 | 6 | 6 | 6 | 36 | 6 |
| 22391 | crime | Victoria | 11 | 49 | 1 | 7 | 255 | 4.45 |
| 22406 | crime | Victoria | 9 | 26 | 1 | 8 | 120 | 2.89 |
| 22476 | crime | Victoria | 1 | 2 | 2 | 2 | 4 | 2 |
| 22483 | crime | Victoria | 2 | 6 | 1 | 5 | 26 | 3 |
| 22551 | crime | Victoria | 6 | 30 | 1 | 8 | 186 | 5 |
| 22565 | crime | Victoria | 1 | 4 | 4 | 4 | 16 | 4 |
| 22569 | crime | Victoria | 24 | 85 | 1 | 9 | 441 | 3.54 |
| 22582 | crime | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 22596 | crime | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 22644 | crime | Victoria | 1 | 1 | 1 | 1 | 1 | 1 |
| 22661 | crime | Victoria | 12 | 65 | 2 | 8 | 387 | 5.42 |
| 22680 | crime | Victoria | 3 | 9 | 1 | 5 | 35 | 3 |
| 22689 | crime | Victoria | 2 | 6 | 3 | 3 | 18 | 3 |
| 22698 | crime | Victoria | 6 | 20 | 1 | 7 | 88 | 3.33 |
| 22710 | crime | Victoria | 11 | 47 | 1 | 9 | 287 | 4.27 |
| 22750 | crime | Victoria | 1 | 9 | 9 | 9 | 81 | 9 |
| 22819 | crime | Victoria | 4 | 10 | 1 | 4 | 30 | 2.5 |
| 22820 | crime | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |