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 137 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 32713 | all | Queensland | 1,925 | 10,738 | 1 | 9 | 66,232 | 5.58 |
| 32717 | all | Queensland | 1 | 9 | 9 | 9 | 81 | 9 |
| 32720 | all | Queensland | 10 | 50 | 5 | 5 | 250 | 5 |
| 32721 | all | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 32724 | all | Queensland | 1 | 9 | 9 | 9 | 81 | 9 |
| 32725 | all | Queensland | 12 | 80 | 5 | 9 | 570 | 6.67 |
| 32730 | all | Queensland | 7 | 30 | 2 | 5 | 138 | 4.29 |
| 32731 | all | Queensland | 237 | 1,282 | 1 | 9 | 7,392 | 5.41 |
| 32733 | all | Queensland | 1 | 7 | 7 | 7 | 49 | 7 |
| 32736 | all | Queensland | 2 | 9 | 4 | 5 | 41 | 4.5 |
| 32742 | all | Queensland | 144 | 772 | 1 | 9 | 4,534 | 5.36 |
| 32745 | all | Queensland | 4 | 25 | 5 | 8 | 163 | 6.25 |
| 32747 | all | Queensland | 2 | 10 | 5 | 5 | 50 | 5 |
| 32748 | all | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 32751 | all | Queensland | 7 | 31 | 2 | 8 | 175 | 4.43 |
| 32754 | all | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 32755 | all | Queensland | 19 | 105 | 1 | 9 | 695 | 5.53 |
| 32757 | all | Queensland | 1 | 7 | 7 | 7 | 49 | 7 |
| 32761 | all | Queensland | 4 | 22 | 5 | 7 | 124 | 5.5 |
| 32770 | all | Queensland | 7 | 39 | 4 | 7 | 225 | 5.57 |
| 32774 | all | Queensland | 8 | 44 | 4 | 7 | 250 | 5.5 |
| 32775 | all | Queensland | 26 | 153 | 3 | 9 | 945 | 5.88 |
| 32777 | all | Queensland | 4 | 26 | 5 | 8 | 174 | 6.5 |
| 32779 | all | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 32781 | all | Queensland | 32 | 171 | 3 | 8 | 979 | 5.34 |