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 230 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 22354 | income | Victoria | 1 | 8 | 8 | 8 | 64 | 8 |
| 22391 | income | Victoria | 55 | 344 | 3 | 9 | 2,354 | 6.25 |
| 22398 | income | Victoria | 2 | 13 | 5 | 8 | 89 | 6.5 |
| 22406 | income | Victoria | 42 | 237 | 1 | 9 | 1,477 | 5.64 |
| 22458 | income | Victoria | 1 | 7 | 7 | 7 | 49 | 7 |
| 22467 | income | Victoria | 25 | 146 | 2 | 9 | 946 | 5.84 |
| 22470 | income | Victoria | 3 | 21 | 5 | 9 | 155 | 7 |
| 22479 | income | Victoria | 2 | 10 | 5 | 5 | 50 | 5 |
| 22488 | income | Victoria | 1 | 8 | 8 | 8 | 64 | 8 |
| 22508 | income | Victoria | 7 | 36 | 1 | 9 | 228 | 5.14 |
| 22546 | income | Victoria | 1 | 9 | 9 | 9 | 81 | 9 |
| 22547 | income | Victoria | 1 | 8 | 8 | 8 | 64 | 8 |
| 22550 | income | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 22551 | income | Victoria | 45 | 294 | 1 | 9 | 2,118 | 6.53 |
| 22565 | income | Victoria | 4 | 28 | 6 | 9 | 202 | 7 |
| 22569 | income | Victoria | 89 | 523 | 1 | 9 | 3,423 | 5.88 |
| 22577 | income | Victoria | 4 | 23 | 5 | 7 | 135 | 5.75 |
| 22625 | income | Victoria | 5 | 36 | 5 | 8 | 266 | 7.2 |
| 22627 | income | Victoria | 1 | 6 | 6 | 6 | 36 | 6 |
| 22644 | income | Victoria | 2 | 12 | 5 | 7 | 74 | 6 |
| 22661 | income | Victoria | 52 | 307 | 2 | 9 | 1,987 | 5.9 |
| 22680 | income | Victoria | 28 | 156 | 3 | 9 | 962 | 5.57 |
| 22685 | income | Victoria | 2 | 14 | 5 | 9 | 106 | 7 |
| 22689 | income | Victoria | 10 | 59 | 4 | 9 | 375 | 5.9 |
| 22698 | income | Victoria | 60 | 357 | 1 | 9 | 2,381 | 5.95 |