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 47 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 13648 | all | New South Wales | 600 | 3,166 | 1 | 9 | 18,358 | 5.28 |
| 13651 | all | New South Wales | 3,806 | 19,308 | 1 | 9 | 111,536 | 5.07 |
| 13656 | all | New South Wales | 7 | 40 | 5 | 8 | 238 | 5.71 |
| 13661 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 13675 | all | New South Wales | 3 | 20 | 5 | 8 | 138 | 6.67 |
| 13686 | all | New South Wales | 2 | 11 | 5 | 6 | 61 | 5.5 |
| 13692 | all | New South Wales | 7 | 44 | 5 | 8 | 286 | 6.29 |
| 13696 | all | New South Wales | 5 | 35 | 6 | 8 | 247 | 7 |
| 13697 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 13698 | all | New South Wales | 3 | 15 | 5 | 5 | 75 | 5 |
| 13699 | all | New South Wales | 269 | 1,399 | 1 | 9 | 8,193 | 5.2 |
| 13703 | all | New South Wales | 2 | 13 | 5 | 8 | 89 | 6.5 |
| 13710 | all | New South Wales | 1 | 7 | 7 | 7 | 49 | 7 |
| 13714 | all | New South Wales | 3 | 22 | 5 | 9 | 170 | 7.33 |
| 13715 | all | New South Wales | 52 | 311 | 5 | 9 | 1,941 | 5.98 |
| 13717 | all | New South Wales | 3 | 20 | 5 | 8 | 138 | 6.67 |
| 13719 | all | New South Wales | 3 | 19 | 5 | 7 | 123 | 6.33 |
| 13730 | all | New South Wales | 591,015 | 3,270,692 | 1 | 9 | 19,682,316 | 5.53 |
| 13731 | all | New South Wales | 10 | 65 | 5 | 9 | 447 | 6.5 |
| 13732 | all | New South Wales | 4 | 28 | 4 | 9 | 210 | 7 |
| 13741 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 13742 | all | New South Wales | 90 | 504 | 3 | 9 | 2,984 | 5.6 |
| 13747 | all | New South Wales | 18 | 87 | 2 | 5 | 429 | 4.83 |
| 13751 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 13753 | all | New South Wales | 10 | 66 | 3 | 9 | 480 | 6.6 |