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 36 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 12733 | all | New South Wales | 250 | 1,318 | 1 | 9 | 7,510 | 5.27 |
| 12734 | all | New South Wales | 353 | 2,032 | 1 | 9 | 12,784 | 5.76 |
| 12738 | all | New South Wales | 48 | 280 | 2 | 9 | 1,774 | 5.83 |
| 12739 | all | New South Wales | 7 | 35 | 2 | 7 | 205 | 5 |
| 12741 | all | New South Wales | 2 | 13 | 5 | 8 | 89 | 6.5 |
| 12745 | all | New South Wales | 104 | 633 | 1 | 9 | 4,239 | 6.09 |
| 12747 | all | New South Wales | 523 | 3,026 | 1 | 9 | 19,090 | 5.79 |
| 12749 | all | New South Wales | 51 | 287 | 1 | 9 | 1,795 | 5.63 |
| 12750 | all | New South Wales | 661 | 3,639 | 1 | 9 | 22,051 | 5.51 |
| 12753 | all | New South Wales | 4 | 23 | 3 | 9 | 163 | 5.75 |
| 12754 | all | New South Wales | 1 | 8 | 8 | 8 | 64 | 8 |
| 12767 | all | New South Wales | 1 | 3 | 3 | 3 | 9 | 3 |
| 12769 | all | New South Wales | 7 | 46 | 5 | 8 | 316 | 6.57 |
| 12779 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 12784 | all | New South Wales | 38 | 185 | 2 | 8 | 971 | 4.87 |
| 12805 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 12806 | all | New South Wales | 16 | 73 | 2 | 5 | 347 | 4.56 |
| 12811 | all | New South Wales | 7 | 41 | 3 | 8 | 261 | 5.86 |
| 12814 | all | New South Wales | 6 | 35 | 5 | 8 | 213 | 5.83 |
| 12818 | all | New South Wales | 1 | 6 | 6 | 6 | 36 | 6 |
| 12820 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 12821 | all | New South Wales | 3 | 13 | 3 | 5 | 59 | 4.33 |
| 12823 | all | New South Wales | 256 | 1,465 | 1 | 9 | 9,323 | 5.72 |
| 12824 | all | New South Wales | 1 | 8 | 8 | 8 | 64 | 8 |
| 12825 | all | New South Wales | 82 | 523 | 3 | 9 | 3,507 | 6.38 |