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 24 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 11831 | all | New South Wales | 309 | 1,988 | 2 | 9 | 13,520 | 6.43 |
| 11832 | all | New South Wales | 11 | 56 | 3 | 8 | 298 | 5.09 |
| 11833 | all | New South Wales | 8 | 46 | 5 | 8 | 274 | 5.75 |
| 11835 | all | New South Wales | 3 | 18 | 5 | 8 | 114 | 6 |
| 11838 | all | New South Wales | 2 | 13 | 5 | 8 | 89 | 6.5 |
| 11839 | all | New South Wales | 11 | 74 | 4 | 9 | 532 | 6.73 |
| 11853 | all | New South Wales | 20 | 86 | 2 | 7 | 404 | 4.3 |
| 11854 | all | New South Wales | 8 | 44 | 5 | 7 | 248 | 5.5 |
| 11858 | all | New South Wales | 20 | 115 | 1 | 9 | 735 | 5.75 |
| 11861 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 11865 | all | New South Wales | 37 | 212 | 1 | 9 | 1,366 | 5.73 |
| 11867 | all | New South Wales | 1 | 8 | 8 | 8 | 64 | 8 |
| 11868 | all | New South Wales | 4 | 20 | 5 | 5 | 100 | 5 |
| 11869 | all | New South Wales | 2 | 14 | 5 | 9 | 106 | 7 |
| 11872 | all | New South Wales | 6 | 32 | 2 | 7 | 188 | 5.33 |
| 11875 | all | New South Wales | 9 | 47 | 5 | 7 | 249 | 5.22 |
| 11876 | all | New South Wales | 7 | 41 | 1 | 9 | 295 | 5.86 |
| 11880 | all | New South Wales | 3,376 | 25,936 | 1 | 9 | 204,990 | 7.68 |
| 11881 | all | New South Wales | 41 | 234 | 1 | 9 | 1,464 | 5.71 |
| 11882 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 11884 | all | New South Wales | 63 | 340 | 2 | 9 | 1,980 | 5.4 |
| 11886 | all | New South Wales | 1 | 8 | 8 | 8 | 64 | 8 |
| 11888 | all | New South Wales | 1 | 7 | 7 | 7 | 49 | 7 |
| 11891 | all | New South Wales | 2 | 13 | 5 | 8 | 89 | 6.5 |
| 11895 | all | New South Wales | 4 | 20 | 5 | 5 | 100 | 5 |