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 126 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 31825 | all | Queensland | 122 | 648 | 2 | 9 | 3,680 | 5.31 |
| 31826 | all | Queensland | 8 | 39 | 4 | 5 | 191 | 4.88 |
| 31827 | all | Queensland | 1 | 6 | 6 | 6 | 36 | 6 |
| 31833 | all | Queensland | 61 | 328 | 1 | 9 | 1,946 | 5.38 |
| 31835 | all | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 31836 | all | Queensland | 7 | 37 | 5 | 7 | 199 | 5.29 |
| 31840 | all | Queensland | 18 | 105 | 4 | 9 | 645 | 5.83 |
| 31843 | all | Queensland | 2 | 10 | 5 | 5 | 50 | 5 |
| 31849 | all | Queensland | 2 | 12 | 3 | 9 | 90 | 6 |
| 31856 | all | Queensland | 3 | 15 | 5 | 5 | 75 | 5 |
| 31859 | all | Queensland | 6 | 35 | 5 | 8 | 213 | 5.83 |
| 31860 | all | Queensland | 14 | 82 | 3 | 9 | 518 | 5.86 |
| 31861 | all | Queensland | 2 | 7 | 2 | 5 | 29 | 3.5 |
| 31864 | all | Queensland | 2 | 8 | 4 | 4 | 32 | 4 |
| 31865 | all | Queensland | 83 | 435 | 3 | 9 | 2,347 | 5.24 |
| 31866 | all | Queensland | 3 | 17 | 5 | 7 | 99 | 5.67 |
| 31869 | all | Queensland | 6 | 33 | 3 | 9 | 201 | 5.5 |
| 31870 | all | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 31871 | all | Queensland | 44 | 327 | 4 | 9 | 2,513 | 7.43 |
| 31875 | all | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 31879 | all | Queensland | 3 | 17 | 5 | 7 | 99 | 5.67 |
| 31883 | all | Queensland | 94 | 555 | 1 | 9 | 3,525 | 5.9 |
| 31885 | all | Queensland | 3 | 19 | 5 | 7 | 123 | 6.33 |
| 31888 | all | Queensland | 12 | 69 | 4 | 9 | 421 | 5.75 |
| 31891 | all | Queensland | 6 | 41 | 5 | 9 | 301 | 6.83 |