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 262 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 20802 | crime | Victoria | 1 | 2 | 2 | 2 | 4 | 2 |
| 20838 | crime | Victoria | 2 | 2 | 1 | 1 | 2 | 1 |
| 20906 | crime | Victoria | 21 | 83 | 1 | 8 | 395 | 3.95 |
| 20930 | crime | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 20940 | crime | Victoria | 7 | 7 | 1 | 1 | 7 | 1 |
| 20947 | crime | Victoria | 5 | 9 | 1 | 2 | 17 | 1.8 |
| 20966 | crime | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 20973 | crime | Victoria | 122 | 498 | 1 | 9 | 2,828 | 4.08 |
| 20996 | crime | Victoria | 1 | 2 | 2 | 2 | 4 | 2 |
| 20999 | crime | Victoria | 1 | 1 | 1 | 1 | 1 | 1 |
| 21001 | crime | Victoria | 3 | 17 | 2 | 9 | 121 | 5.67 |
| 21089 | crime | Victoria | 1 | 1 | 1 | 1 | 1 | 1 |
| 21129 | crime | Victoria | 2 | 7 | 2 | 5 | 29 | 3.5 |
| 21193 | crime | Victoria | 27 | 100 | 1 | 9 | 508 | 3.7 |
| 21206 | crime | Victoria | 6 | 24 | 1 | 8 | 130 | 4 |
| 21229 | crime | Victoria | 6 | 35 | 1 | 8 | 243 | 5.83 |
| 21234 | crime | Victoria | 1 | 1 | 1 | 1 | 1 | 1 |
| 21235 | crime | Victoria | 1 | 1 | 1 | 1 | 1 | 1 |
| 21345 | crime | Victoria | 1 | 8 | 8 | 8 | 64 | 8 |
| 21352 | crime | Victoria | 4 | 12 | 1 | 4 | 42 | 3 |
| 21354 | crime | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 21396 | crime | Victoria | 11 | 59 | 2 | 9 | 355 | 5.36 |
| 21414 | crime | Victoria | 1 | 8 | 8 | 8 | 64 | 8 |
| 21449 | crime | Victoria | 12 | 37 | 1 | 7 | 135 | 3.08 |
| 21465 | crime | Victoria | 1 | 3 | 3 | 3 | 9 | 3 |