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 263 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 21469 | crime | Victoria | 12 | 62 | 1 | 9 | 414 | 5.17 |
| 21523 | crime | Victoria | 1 | 6 | 6 | 6 | 36 | 6 |
| 21531 | crime | Victoria | 6 | 21 | 2 | 5 | 83 | 3.5 |
| 21542 | crime | Victoria | 6 | 18 | 1 | 5 | 72 | 3 |
| 21585 | crime | Victoria | 1 | 3 | 3 | 3 | 9 | 3 |
| 21618 | crime | Victoria | 3 | 16 | 4 | 7 | 90 | 5.33 |
| 21640 | crime | Victoria | 4,026 | 14,110 | 1 | 9 | 71,372 | 3.5 |
| 21673 | crime | Victoria | 1 | 8 | 8 | 8 | 64 | 8 |
| 21682 | crime | Victoria | 6 | 28 | 1 | 8 | 168 | 4.67 |
| 21702 | crime | Victoria | 1 | 3 | 3 | 3 | 9 | 3 |
| 21716 | crime | Victoria | 2 | 3 | 1 | 2 | 5 | 1.5 |
| 21800 | crime | Victoria | 1 | 9 | 9 | 9 | 81 | 9 |
| 21849 | crime | Victoria | 2 | 4 | 2 | 2 | 8 | 2 |
| 21863 | crime | Victoria | 2 | 4 | 1 | 3 | 10 | 2 |
| 21867 | crime | Victoria | 5 | 11 | 1 | 3 | 29 | 2.2 |
| 21984 | crime | Victoria | 10 | 39 | 1 | 8 | 213 | 3.9 |
| 22006 | crime | Victoria | 16 | 62 | 1 | 8 | 298 | 3.88 |
| 22027 | crime | Victoria | 5 | 25 | 1 | 8 | 155 | 5 |
| 22049 | crime | Victoria | 1 | 1 | 1 | 1 | 1 | 1 |
| 22105 | crime | Victoria | 2 | 10 | 5 | 5 | 50 | 5 |
| 22109 | crime | Victoria | 20 | 81 | 1 | 9 | 431 | 4.05 |
| 22110 | crime | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 22137 | crime | Victoria | 4 | 13 | 1 | 8 | 73 | 3.25 |
| 22186 | crime | Victoria | 1 | 9 | 9 | 9 | 81 | 9 |
| 22198 | crime | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |