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 234 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 30675 | income | Queensland | 1 | 7 | 7 | 7 | 49 | 7 |
| 30678 | income | Queensland | 1 | 7 | 7 | 7 | 49 | 7 |
| 30702 | income | Queensland | 5 | 43 | 7 | 9 | 373 | 8.6 |
| 30741 | income | Queensland | 55 | 325 | 1 | 9 | 2,165 | 5.91 |
| 30745 | income | Queensland | 1 | 9 | 9 | 9 | 81 | 9 |
| 30757 | income | Queensland | 1 | 2 | 2 | 2 | 4 | 2 |
| 30759 | income | Queensland | 1 | 9 | 9 | 9 | 81 | 9 |
| 30767 | income | Queensland | 2 | 6 | 2 | 4 | 20 | 3 |
| 30768 | income | Queensland | 1 | 9 | 9 | 9 | 81 | 9 |
| 30786 | income | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 30792 | income | Queensland | 11 | 62 | 3 | 8 | 380 | 5.64 |
| 30816 | income | Queensland | 1 | 3 | 3 | 3 | 9 | 3 |
| 30818 | income | Queensland | 1 | 7 | 7 | 7 | 49 | 7 |
| 30846 | income | Queensland | 1 | 9 | 9 | 9 | 81 | 9 |
| 30866 | income | Queensland | 8 | 38 | 2 | 8 | 204 | 4.75 |
| 30904 | income | Queensland | 9 | 53 | 2 | 8 | 341 | 5.89 |
| 30907 | income | Queensland | 1 | 8 | 8 | 8 | 64 | 8 |
| 30945 | income | Queensland | 1 | 9 | 9 | 9 | 81 | 9 |
| 30946 | income | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 30973 | income | Queensland | 29 | 180 | 3 | 9 | 1,204 | 6.21 |
| 30983 | income | Queensland | 2 | 13 | 6 | 7 | 85 | 6.5 |
| 30984 | income | Queensland | 2 | 9 | 4 | 5 | 41 | 4.5 |
| 30996 | income | Queensland | 2 | 10 | 2 | 8 | 68 | 5 |
| 31074 | income | Queensland | 1 | 7 | 7 | 7 | 49 | 7 |
| 31104 | income | Queensland | 4 | 22 | 2 | 8 | 142 | 5.5 |