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 227 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 21531 | income | Victoria | 11 | 62 | 2 | 8 | 376 | 5.64 |
| 21542 | income | Victoria | 61 | 341 | 1 | 9 | 2,305 | 5.59 |
| 21562 | income | Victoria | 8 | 55 | 5 | 9 | 395 | 6.88 |
| 21571 | income | Victoria | 2 | 10 | 3 | 7 | 58 | 5 |
| 21584 | income | Victoria | 3 | 19 | 5 | 9 | 131 | 6.33 |
| 21585 | income | Victoria | 2 | 10 | 3 | 7 | 58 | 5 |
| 21603 | income | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 21604 | income | Victoria | 1 | 8 | 8 | 8 | 64 | 8 |
| 21618 | income | Victoria | 4 | 32 | 8 | 8 | 256 | 8 |
| 21629 | income | Victoria | 1 | 8 | 8 | 8 | 64 | 8 |
| 21637 | income | Victoria | 2 | 8 | 2 | 6 | 40 | 4 |
| 21640 | income | Victoria | 23,281 | 135,538 | 1 | 9 | 900,176 | 5.82 |
| 21653 | income | Victoria | 2 | 13 | 5 | 8 | 89 | 6.5 |
| 21657 | income | Victoria | 1 | 8 | 8 | 8 | 64 | 8 |
| 21667 | income | Victoria | 2 | 14 | 5 | 9 | 106 | 7 |
| 21673 | income | Victoria | 4 | 22 | 5 | 7 | 124 | 5.5 |
| 21682 | income | Victoria | 32 | 215 | 1 | 9 | 1,589 | 6.72 |
| 21685 | income | Victoria | 1 | 3 | 3 | 3 | 9 | 3 |
| 21702 | income | Victoria | 11 | 58 | 3 | 8 | 320 | 5.27 |
| 21716 | income | Victoria | 14 | 80 | 1 | 9 | 546 | 5.71 |
| 21726 | income | Victoria | 1 | 4 | 4 | 4 | 16 | 4 |
| 21746 | income | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 21748 | income | Victoria | 1 | 9 | 9 | 9 | 81 | 9 |
| 21752 | income | Victoria | 1 | 6 | 6 | 6 | 36 | 6 |
| 21769 | income | Victoria | 22 | 123 | 1 | 9 | 813 | 5.59 |