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 125 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 31759 | all | Queensland | 7 | 38 | 4 | 7 | 214 | 5.43 |
| 31760 | all | Queensland | 4 | 26 | 5 | 8 | 178 | 6.5 |
| 31761 | all | Queensland | 5 | 31 | 5 | 9 | 205 | 6.2 |
| 31763 | all | Queensland | 425 | 2,337 | 1 | 9 | 14,225 | 5.5 |
| 31765 | all | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 31766 | all | Queensland | 42 | 249 | 3 | 9 | 1,581 | 5.93 |
| 31767 | all | Queensland | 5 | 40 | 7 | 9 | 324 | 8 |
| 31771 | all | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 31772 | all | Queensland | 15 | 101 | 5 | 9 | 713 | 6.73 |
| 31775 | all | Queensland | 2 | 13 | 5 | 8 | 89 | 6.5 |
| 31776 | all | Queensland | 1 | 4 | 4 | 4 | 16 | 4 |
| 31778 | all | Queensland | 2,091 | 11,617 | 1 | 9 | 70,277 | 5.56 |
| 31779 | all | Queensland | 2 | 10 | 5 | 5 | 50 | 5 |
| 31785 | all | Queensland | 386 | 2,082 | 1 | 9 | 12,164 | 5.39 |
| 31790 | all | Queensland | 5 | 36 | 5 | 9 | 270 | 7.2 |
| 31794 | all | Queensland | 4 | 21 | 5 | 6 | 111 | 5.25 |
| 31795 | all | Queensland | 1 | 9 | 9 | 9 | 81 | 9 |
| 31803 | all | Queensland | 1 | 9 | 9 | 9 | 81 | 9 |
| 31808 | all | Queensland | 1 | 8 | 8 | 8 | 64 | 8 |
| 31811 | all | Queensland | 33 | 213 | 4 | 9 | 1,443 | 6.45 |
| 31812 | all | Queensland | 3 | 23 | 7 | 8 | 177 | 7.67 |
| 31813 | all | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 31818 | all | Queensland | 3 | 15 | 5 | 5 | 75 | 5 |
| 31819 | all | Queensland | 171 | 989 | 2 | 9 | 6,097 | 5.78 |
| 31822 | all | Queensland | 4 | 16 | 3 | 5 | 68 | 4 |