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 233 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 30379 | income | Queensland | 9,300 | 53,509 | 1 | 9 | 353,175 | 5.75 |
| 30380 | income | Queensland | 1 | 9 | 9 | 9 | 81 | 9 |
| 30425 | income | Queensland | 1 | 7 | 7 | 7 | 49 | 7 |
| 30437 | income | Queensland | 1 | 7 | 7 | 7 | 49 | 7 |
| 30440 | income | Queensland | 1 | 8 | 8 | 8 | 64 | 8 |
| 30449 | income | Queensland | 1 | 3 | 3 | 3 | 9 | 3 |
| 30455 | income | Queensland | 2 | 14 | 7 | 7 | 98 | 7 |
| 30471 | income | Queensland | 1 | 3 | 3 | 3 | 9 | 3 |
| 30479 | income | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 30492 | income | Queensland | 1 | 9 | 9 | 9 | 81 | 9 |
| 30521 | income | Queensland | 13 | 86 | 1 | 9 | 638 | 6.62 |
| 30525 | income | Queensland | 1 | 8 | 8 | 8 | 64 | 8 |
| 30553 | income | Queensland | 1 | 9 | 9 | 9 | 81 | 9 |
| 30560 | income | Queensland | 1 | 8 | 8 | 8 | 64 | 8 |
| 30571 | income | Queensland | 5 | 27 | 3 | 9 | 165 | 5.4 |
| 30585 | income | Queensland | 9 | 54 | 2 | 9 | 378 | 6 |
| 30593 | income | Queensland | 3 | 18 | 4 | 9 | 122 | 6 |
| 30600 | income | Queensland | 6 | 35 | 3 | 8 | 221 | 5.83 |
| 30624 | income | Queensland | 2 | 15 | 7 | 8 | 113 | 7.5 |
| 30628 | income | Queensland | 5 | 37 | 5 | 9 | 293 | 7.4 |
| 30634 | income | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 30650 | income | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 30652 | income | Queensland | 1 | 9 | 9 | 9 | 81 | 9 |
| 30654 | income | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 30661 | income | Queensland | 1 | 9 | 9 | 9 | 81 | 9 |