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 127 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 31892 | all | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 31895 | all | Queensland | 30 | 184 | 3 | 9 | 1,218 | 6.13 |
| 31896 | all | Queensland | 1 | 3 | 3 | 3 | 9 | 3 |
| 31904 | all | Queensland | 63 | 385 | 1 | 9 | 2,579 | 6.11 |
| 31905 | all | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 31910 | all | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 31912 | all | Queensland | 667 | 3,677 | 1 | 9 | 21,999 | 5.51 |
| 31913 | all | Queensland | 7 | 39 | 3 | 8 | 237 | 5.57 |
| 31915 | all | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 31917 | all | Queensland | 34 | 186 | 5 | 9 | 1,058 | 5.47 |
| 31922 | all | Queensland | 3 | 15 | 2 | 8 | 93 | 5 |
| 31929 | all | Queensland | 24 | 120 | 1 | 9 | 640 | 5 |
| 31932 | all | Queensland | 2 | 18 | 9 | 9 | 162 | 9 |
| 31936 | all | Queensland | 2,835 | 16,608 | 1 | 9 | 103,954 | 5.86 |
| 31937 | all | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 31938 | all | Queensland | 14 | 76 | 4 | 9 | 436 | 5.43 |
| 31940 | all | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 31944 | all | Queensland | 5 | 26 | 5 | 6 | 136 | 5.2 |
| 31945 | all | Queensland | 1 | 9 | 9 | 9 | 81 | 9 |
| 31946 | all | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 31948 | all | Queensland | 6 | 30 | 3 | 6 | 156 | 5 |
| 31950 | all | Queensland | 2 | 14 | 5 | 9 | 106 | 7 |
| 31952 | all | Queensland | 59 | 360 | 3 | 9 | 2,374 | 6.1 |
| 31965 | all | Queensland | 2 | 14 | 5 | 9 | 106 | 7 |
| 31967 | all | Queensland | 3 | 15 | 5 | 5 | 75 | 5 |