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 50 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 13908 | all | New South Wales | 9 | 51 | 2 | 8 | 315 | 5.67 |
| 13912 | all | New South Wales | 4 | 20 | 5 | 5 | 100 | 5 |
| 13914 | all | New South Wales | 3 | 15 | 5 | 5 | 75 | 5 |
| 13929 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 13930 | all | New South Wales | 1 | 8 | 8 | 8 | 64 | 8 |
| 13936 | all | New South Wales | 274 | 1,502 | 1 | 9 | 8,954 | 5.48 |
| 13939 | all | New South Wales | 1,435 | 7,992 | 1 | 9 | 49,526 | 5.57 |
| 13941 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 13943 | all | New South Wales | 4 | 32 | 7 | 9 | 260 | 8 |
| 13946 | all | New South Wales | 9 | 46 | 1 | 8 | 266 | 5.11 |
| 13947 | all | New South Wales | 4 | 26 | 5 | 8 | 178 | 6.5 |
| 13950 | all | New South Wales | 8,365 | 44,006 | 1 | 9 | 261,384 | 5.26 |
| 13951 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 13958 | all | New South Wales | 102 | 532 | 1 | 9 | 3,196 | 5.22 |
| 13960 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 13964 | all | New South Wales | 3 | 15 | 5 | 5 | 75 | 5 |
| 13965 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 13968 | all | New South Wales | 3 | 19 | 5 | 9 | 131 | 6.33 |
| 13972 | all | New South Wales | 4 | 19 | 2 | 8 | 109 | 4.75 |
| 13973 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 13975 | all | New South Wales | 1 | 9 | 9 | 9 | 81 | 9 |
| 13978 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 13979 | all | New South Wales | 240 | 1,295 | 1 | 9 | 7,773 | 5.4 |
| 13982 | all | New South Wales | 3 | 15 | 5 | 5 | 75 | 5 |
| 13983 | all | New South Wales | 10 | 48 | 3 | 5 | 234 | 4.8 |