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 255 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 70251 | income | Northern Territory | 4 | 24 | 3 | 8 | 158 | 6 |
| 70302 | income | Northern Territory | 5 | 32 | 4 | 9 | 220 | 6.4 |
| 80003 | income | Australian Capital Territory | 2,386 | 14,400 | 1 | 9 | 98,004 | 6.04 |
| 80005 | income | Australian Capital Territory | 3 | 13 | 4 | 5 | 57 | 4.33 |
| 80024 | income | Australian Capital Territory | 1 | 8 | 8 | 8 | 64 | 8 |
| 80027 | income | Australian Capital Territory | 5 | 27 | 5 | 6 | 147 | 5.4 |
| 80030 | income | Australian Capital Territory | 5 | 20 | 1 | 6 | 102 | 4 |
| 80038 | income | Australian Capital Territory | 61 | 351 | 1 | 9 | 2,265 | 5.75 |
| 80040 | income | Australian Capital Territory | 2 | 14 | 5 | 9 | 106 | 7 |
| 80043 | income | Australian Capital Territory | 3 | 19 | 5 | 7 | 123 | 6.33 |
| 80044 | income | Australian Capital Territory | 3 | 26 | 8 | 9 | 226 | 8.67 |
| 80048 | income | Australian Capital Territory | 1 | 9 | 9 | 9 | 81 | 9 |
| 80070 | income | Australian Capital Territory | 12 | 83 | 3 | 9 | 619 | 6.92 |
| 80091 | income | Australian Capital Territory | 147 | 824 | 1 | 9 | 5,280 | 5.61 |
| 80093 | income | Australian Capital Territory | 1 | 5 | 5 | 5 | 25 | 5 |
| 80100 | income | Australian Capital Territory | 1 | 9 | 9 | 9 | 81 | 9 |
| 80111 | income | Australian Capital Territory | 1 | 5 | 5 | 5 | 25 | 5 |
| 80112 | income | Australian Capital Territory | 1 | 5 | 5 | 5 | 25 | 5 |
| 80116 | income | Australian Capital Territory | 5 | 23 | 1 | 6 | 123 | 4.6 |
| 80126 | income | Australian Capital Territory | 2 | 14 | 5 | 9 | 106 | 7 |
| 80134 | income | Australian Capital Territory | 1 | 8 | 8 | 8 | 64 | 8 |
| 90003 | income | Other Territories | 1 | 5 | 5 | 5 | 25 | 5 |
| 10024 | crime | New South Wales | 1 | 8 | 8 | 8 | 64 | 8 |
| 10027 | crime | New South Wales | 4 | 22 | 3 | 8 | 146 | 5.5 |
| 10033 | crime | New South Wales | 18 | 69 | 1 | 8 | 337 | 3.83 |