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 213 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 11919 | income | New South Wales | 2 | 12 | 5 | 7 | 74 | 6 |
| 11927 | income | New South Wales | 7 | 36 | 1 | 9 | 248 | 5.14 |
| 11973 | income | New South Wales | 5 | 37 | 5 | 9 | 285 | 7.4 |
| 11974 | income | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 11976 | income | New South Wales | 1 | 7 | 7 | 7 | 49 | 7 |
| 11983 | income | New South Wales | 5 | 35 | 5 | 9 | 259 | 7 |
| 11990 | income | New South Wales | 2 | 9 | 3 | 6 | 45 | 4.5 |
| 11999 | income | New South Wales | 5 | 32 | 4 | 9 | 220 | 6.4 |
| 12007 | income | New South Wales | 5 | 23 | 1 | 8 | 139 | 4.6 |
| 12020 | income | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 12036 | income | New South Wales | 9 | 71 | 7 | 9 | 565 | 7.89 |
| 12039 | income | New South Wales | 11 | 65 | 2 | 9 | 423 | 5.91 |
| 12053 | income | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 12103 | income | New South Wales | 16 | 91 | 2 | 9 | 591 | 5.69 |
| 12104 | income | New South Wales | 42 | 247 | 1 | 9 | 1,629 | 5.88 |
| 12124 | income | New South Wales | 44 | 248 | 1 | 9 | 1,582 | 5.64 |
| 12127 | income | New South Wales | 1 | 2 | 2 | 2 | 4 | 2 |
| 12153 | income | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 12162 | income | New South Wales | 1 | 8 | 8 | 8 | 64 | 8 |
| 12174 | income | New South Wales | 1 | 9 | 9 | 9 | 81 | 9 |
| 12182 | income | New South Wales | 6 | 33 | 5 | 7 | 185 | 5.5 |
| 12224 | income | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 12226 | income | New South Wales | 12 | 63 | 1 | 8 | 373 | 5.25 |
| 12238 | income | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 12249 | income | New South Wales | 1 | 8 | 8 | 8 | 64 | 8 |