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 58 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 14479 | all | New South Wales | 3 | 21 | 5 | 9 | 155 | 7 |
| 14480 | all | New South Wales | 1 | 3 | 3 | 3 | 9 | 3 |
| 14486 | all | New South Wales | 336 | 1,810 | 1 | 9 | 10,178 | 5.39 |
| 14488 | all | New South Wales | 1 | 8 | 8 | 8 | 64 | 8 |
| 14493 | all | New South Wales | 2 | 10 | 5 | 5 | 50 | 5 |
| 14495 | all | New South Wales | 3 | 14 | 4 | 5 | 66 | 4.67 |
| 14504 | all | New South Wales | 1 | 2 | 2 | 2 | 4 | 2 |
| 14511 | all | New South Wales | 68 | 380 | 1 | 9 | 2,392 | 5.59 |
| 14520 | all | New South Wales | 4,035 | 22,297 | 1 | 9 | 135,981 | 5.53 |
| 14524 | all | New South Wales | 3 | 19 | 5 | 9 | 131 | 6.33 |
| 14525 | all | New South Wales | 10 | 67 | 5 | 9 | 469 | 6.7 |
| 14526 | all | New South Wales | 3 | 21 | 5 | 9 | 155 | 7 |
| 14528 | all | New South Wales | 97 | 546 | 1 | 9 | 3,430 | 5.63 |
| 14529 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 14535 | all | New South Wales | 2 | 13 | 5 | 8 | 89 | 6.5 |
| 14536 | all | New South Wales | 44 | 249 | 1 | 9 | 1,559 | 5.66 |
| 14540 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 14542 | all | New South Wales | 41 | 213 | 1 | 9 | 1,245 | 5.2 |
| 20004 | all | Victoria | 4 | 21 | 5 | 6 | 111 | 5.25 |
| 20006 | all | Victoria | 18 | 103 | 3 | 8 | 619 | 5.72 |
| 20008 | all | Victoria | 2 | 10 | 5 | 5 | 50 | 5 |
| 20010 | all | Victoria | 92 | 495 | 2 | 9 | 2,775 | 5.38 |
| 20011 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 20012 | all | Victoria | 4 | 22 | 5 | 6 | 122 | 5.5 |
| 20013 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |