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 40 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 13070 | all | New South Wales | 75 | 471 | 3 | 9 | 3,135 | 6.28 |
| 13071 | all | New South Wales | 9 | 58 | 4 | 9 | 402 | 6.44 |
| 13072 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 13073 | all | New South Wales | 2 | 10 | 5 | 5 | 50 | 5 |
| 13075 | all | New South Wales | 12 | 79 | 5 | 9 | 547 | 6.58 |
| 13079 | all | New South Wales | 96 | 502 | 1 | 9 | 2,910 | 5.23 |
| 13081 | all | New South Wales | 73 | 422 | 1 | 9 | 2,700 | 5.78 |
| 13084 | all | New South Wales | 116 | 640 | 1 | 9 | 3,804 | 5.52 |
| 13086 | all | New South Wales | 22 | 122 | 4 | 9 | 710 | 5.55 |
| 13091 | all | New South Wales | 3 | 16 | 4 | 8 | 96 | 5.33 |
| 13094 | all | New South Wales | 6 | 28 | 3 | 5 | 134 | 4.67 |
| 13103 | all | New South Wales | 2,654 | 16,031 | 1 | 9 | 105,123 | 6.04 |
| 13106 | all | New South Wales | 10 | 57 | 5 | 8 | 337 | 5.7 |
| 13112 | all | New South Wales | 4 | 21 | 5 | 6 | 111 | 5.25 |
| 13114 | all | New South Wales | 3 | 19 | 5 | 7 | 123 | 6.33 |
| 13120 | all | New South Wales | 1 | 9 | 9 | 9 | 81 | 9 |
| 13125 | all | New South Wales | 2 | 10 | 5 | 5 | 50 | 5 |
| 13136 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 13138 | all | New South Wales | 24 | 121 | 3 | 7 | 619 | 5.04 |
| 13142 | all | New South Wales | 7 | 37 | 5 | 7 | 199 | 5.29 |
| 13151 | all | New South Wales | 154 | 897 | 1 | 9 | 5,623 | 5.82 |
| 13159 | all | New South Wales | 4 | 25 | 5 | 8 | 163 | 6.25 |
| 13162 | all | New South Wales | 682 | 3,887 | 1 | 9 | 25,277 | 5.7 |
| 13166 | all | New South Wales | 6 | 33 | 4 | 7 | 189 | 5.5 |
| 13167 | all | New South Wales | 90 | 538 | 2 | 9 | 3,464 | 5.98 |