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 42 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 13221 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 13223 | all | New South Wales | 3 | 23 | 7 | 9 | 179 | 7.67 |
| 13229 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 13239 | all | New South Wales | 2 | 10 | 5 | 5 | 50 | 5 |
| 13240 | all | New South Wales | 2 | 15 | 6 | 9 | 117 | 7.5 |
| 13244 | all | New South Wales | 1 | 7 | 7 | 7 | 49 | 7 |
| 13248 | all | New South Wales | 146 | 880 | 4 | 9 | 5,624 | 6.03 |
| 13260 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 13262 | all | New South Wales | 967 | 5,489 | 1 | 9 | 34,775 | 5.68 |
| 13263 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 13268 | all | New South Wales | 1 | 9 | 9 | 9 | 81 | 9 |
| 13269 | all | New South Wales | 242 | 1,337 | 1 | 9 | 7,977 | 5.52 |
| 13270 | all | New South Wales | 1 | 9 | 9 | 9 | 81 | 9 |
| 13272 | all | New South Wales | 2 | 10 | 2 | 8 | 68 | 5 |
| 13274 | all | New South Wales | 2 | 14 | 7 | 7 | 98 | 7 |
| 13285 | all | New South Wales | 1 | 7 | 7 | 7 | 49 | 7 |
| 13290 | all | New South Wales | 1 | 2 | 2 | 2 | 4 | 2 |
| 13294 | all | New South Wales | 8 | 53 | 5 | 8 | 359 | 6.62 |
| 13297 | all | New South Wales | 50 | 305 | 2 | 9 | 1,981 | 6.1 |
| 13304 | all | New South Wales | 2,185 | 12,045 | 1 | 9 | 73,987 | 5.51 |
| 13314 | all | New South Wales | 16 | 96 | 4 | 9 | 612 | 6 |
| 13316 | all | New South Wales | 2 | 10 | 5 | 5 | 50 | 5 |
| 13320 | all | New South Wales | 40 | 269 | 2 | 9 | 1,953 | 6.72 |
| 13322 | all | New South Wales | 2 | 11 | 5 | 6 | 61 | 5.5 |
| 13325 | all | New South Wales | 70 | 447 | 1 | 9 | 3,085 | 6.39 |