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 9 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 10586 | all | New South Wales | 1 | 7 | 7 | 7 | 49 | 7 |
| 10587 | all | New South Wales | 26 | 130 | 2 | 9 | 716 | 5 |
| 10588 | all | New South Wales | 2 | 14 | 5 | 9 | 106 | 7 |
| 10589 | all | New South Wales | 1,838 | 9,512 | 1 | 9 | 54,864 | 5.18 |
| 10591 | all | New South Wales | 44 | 252 | 2 | 9 | 1,546 | 5.73 |
| 10594 | all | New South Wales | 8 | 42 | 5 | 7 | 224 | 5.25 |
| 10596 | all | New South Wales | 60 | 337 | 1 | 9 | 2,039 | 5.62 |
| 10598 | all | New South Wales | 10 | 66 | 5 | 9 | 454 | 6.6 |
| 10600 | all | New South Wales | 10 | 55 | 3 | 8 | 335 | 5.5 |
| 10603 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 10604 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 10605 | all | New South Wales | 85 | 436 | 1 | 9 | 2,516 | 5.13 |
| 10609 | all | New South Wales | 2 | 14 | 7 | 7 | 98 | 7 |
| 10618 | all | New South Wales | 75 | 433 | 1 | 9 | 2,743 | 5.77 |
| 10633 | all | New South Wales | 7 | 35 | 5 | 5 | 175 | 5 |
| 10639 | all | New South Wales | 1 | 4 | 4 | 4 | 16 | 4 |
| 10643 | all | New South Wales | 8 | 42 | 5 | 7 | 224 | 5.25 |
| 10646 | all | New South Wales | 12 | 54 | 1 | 7 | 270 | 4.5 |
| 10653 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 10659 | all | New South Wales | 100 | 596 | 1 | 9 | 3,888 | 5.96 |
| 10660 | all | New South Wales | 2 | 10 | 5 | 5 | 50 | 5 |
| 10667 | all | New South Wales | 287 | 1,661 | 1 | 9 | 10,693 | 5.79 |
| 10668 | all | New South Wales | 2 | 10 | 5 | 5 | 50 | 5 |
| 10669 | all | New South Wales | 84 | 480 | 1 | 9 | 2,890 | 5.71 |
| 10670 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |