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 211 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 11239 | income | New South Wales | 2 | 17 | 8 | 9 | 145 | 8.5 |
| 11243 | income | New South Wales | 2 | 16 | 8 | 8 | 128 | 8 |
| 11296 | income | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 11299 | income | New South Wales | 28 | 178 | 3 | 9 | 1,238 | 6.36 |
| 11363 | income | New South Wales | 1 | 3 | 3 | 3 | 9 | 3 |
| 11378 | income | New South Wales | 8 | 51 | 4 | 9 | 345 | 6.38 |
| 11396 | income | New South Wales | 1 | 8 | 8 | 8 | 64 | 8 |
| 11418 | income | New South Wales | 2 | 14 | 5 | 9 | 106 | 7 |
| 11423 | income | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 11442 | income | New South Wales | 1 | 1 | 1 | 1 | 1 | 1 |
| 11447 | income | New South Wales | 11 | 66 | 3 | 8 | 426 | 6 |
| 11457 | income | New South Wales | 1 | 2 | 2 | 2 | 4 | 2 |
| 11466 | income | New South Wales | 1 | 9 | 9 | 9 | 81 | 9 |
| 11472 | income | New South Wales | 30 | 131 | 2 | 8 | 649 | 4.37 |
| 11521 | income | New South Wales | 2 | 16 | 7 | 9 | 130 | 8 |
| 11523 | income | New South Wales | 10 | 52 | 3 | 7 | 290 | 5.2 |
| 11539 | income | New South Wales | 3 | 20 | 5 | 8 | 138 | 6.67 |
| 11577 | income | New South Wales | 1 | 8 | 8 | 8 | 64 | 8 |
| 11580 | income | New South Wales | 8 | 54 | 5 | 7 | 368 | 6.75 |
| 11586 | income | New South Wales | 1 | 4 | 4 | 4 | 16 | 4 |
| 11598 | income | New South Wales | 2 | 18 | 9 | 9 | 162 | 9 |
| 11603 | income | New South Wales | 3 | 20 | 3 | 9 | 154 | 6.67 |
| 11610 | income | New South Wales | 8 | 43 | 1 | 9 | 299 | 5.38 |
| 11611 | income | New South Wales | 2 | 15 | 6 | 9 | 117 | 7.5 |
| 11636 | income | New South Wales | 2 | 13 | 5 | 8 | 89 | 6.5 |