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 12 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 10812 | all | New South Wales | 10 | 62 | 5 | 8 | 406 | 6.2 |
| 10814 | all | New South Wales | 3 | 19 | 5 | 8 | 125 | 6.33 |
| 10817 | all | New South Wales | 3 | 17 | 5 | 7 | 99 | 5.67 |
| 10830 | all | New South Wales | 13 | 77 | 3 | 9 | 493 | 5.92 |
| 10831 | all | New South Wales | 2 | 11 | 5 | 6 | 61 | 5.5 |
| 10838 | all | New South Wales | 1 | 4 | 4 | 4 | 16 | 4 |
| 10839 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 10842 | all | New South Wales | 415 | 2,344 | 1 | 9 | 14,172 | 5.65 |
| 10847 | all | New South Wales | 4 | 17 | 2 | 5 | 79 | 4.25 |
| 10849 | all | New South Wales | 3 | 20 | 5 | 8 | 138 | 6.67 |
| 10851 | all | New South Wales | 2 | 18 | 9 | 9 | 162 | 9 |
| 10852 | all | New South Wales | 3 | 22 | 5 | 9 | 170 | 7.33 |
| 10853 | all | New South Wales | 9 | 51 | 4 | 8 | 303 | 5.67 |
| 10854 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 10856 | all | New South Wales | 9 | 48 | 3 | 9 | 276 | 5.33 |
| 10858 | all | New South Wales | 2 | 10 | 5 | 5 | 50 | 5 |
| 10861 | all | New South Wales | 4 | 23 | 4 | 9 | 147 | 5.75 |
| 10866 | all | New South Wales | 1 | 7 | 7 | 7 | 49 | 7 |
| 10873 | all | New South Wales | 28 | 147 | 3 | 9 | 805 | 5.25 |
| 10877 | all | New South Wales | 937 | 5,302 | 1 | 9 | 33,602 | 5.66 |
| 10883 | all | New South Wales | 6 | 45 | 5 | 9 | 347 | 7.5 |
| 10891 | all | New South Wales | 112 | 650 | 1 | 9 | 4,100 | 5.8 |
| 10893 | all | New South Wales | 2 | 10 | 5 | 5 | 50 | 5 |
| 10894 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 10897 | all | New South Wales | 16 | 94 | 4 | 9 | 590 | 5.88 |