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 52 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 14059 | all | New South Wales | 4 | 20 | 4 | 7 | 106 | 5 |
| 14065 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 14070 | all | New South Wales | 63 | 334 | 2 | 9 | 1,952 | 5.3 |
| 14071 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 14075 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 14076 | all | New South Wales | 44 | 230 | 3 | 9 | 1,234 | 5.23 |
| 14079 | all | New South Wales | 26 | 155 | 3 | 9 | 993 | 5.96 |
| 14081 | all | New South Wales | 3 | 15 | 5 | 5 | 75 | 5 |
| 14082 | all | New South Wales | 2 | 14 | 7 | 7 | 98 | 7 |
| 14083 | all | New South Wales | 30 | 147 | 2 | 5 | 729 | 4.9 |
| 14085 | all | New South Wales | 6 | 31 | 2 | 8 | 179 | 5.17 |
| 14087 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 14089 | all | New South Wales | 2 | 14 | 6 | 8 | 100 | 7 |
| 14091 | all | New South Wales | 5 | 28 | 4 | 9 | 172 | 5.6 |
| 14092 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 14093 | all | New South Wales | 46 | 256 | 2 | 9 | 1,558 | 5.57 |
| 14094 | all | New South Wales | 16 | 86 | 4 | 7 | 476 | 5.38 |
| 14098 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 14100 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 14102 | all | New South Wales | 1 | 6 | 6 | 6 | 36 | 6 |
| 14103 | all | New South Wales | 11 | 61 | 4 | 8 | 351 | 5.55 |
| 14104 | all | New South Wales | 3 | 13 | 2 | 7 | 69 | 4.33 |
| 14105 | all | New South Wales | 1 | 7 | 7 | 7 | 49 | 7 |
| 14106 | all | New South Wales | 31 | 168 | 2 | 9 | 974 | 5.42 |
| 14107 | all | New South Wales | 2 | 14 | 5 | 9 | 106 | 7 |