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 54 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 14169 | all | New South Wales | 6 | 48 | 5 | 9 | 396 | 8 |
| 14170 | all | New South Wales | 1 | 7 | 7 | 7 | 49 | 7 |
| 14171 | all | New South Wales | 3 | 15 | 5 | 5 | 75 | 5 |
| 14172 | all | New South Wales | 14 | 115 | 1 | 9 | 1,003 | 8.21 |
| 14176 | all | New South Wales | 40 | 219 | 2 | 8 | 1,259 | 5.48 |
| 14189 | all | New South Wales | 34 | 190 | 1 | 9 | 1,174 | 5.59 |
| 14190 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 14191 | all | New South Wales | 2 | 10 | 5 | 5 | 50 | 5 |
| 14193 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 14194 | all | New South Wales | 13 | 67 | 5 | 7 | 349 | 5.15 |
| 14200 | all | New South Wales | 26 | 150 | 3 | 9 | 918 | 5.77 |
| 14203 | all | New South Wales | 545 | 2,949 | 1 | 9 | 17,757 | 5.41 |
| 14205 | all | New South Wales | 5 | 26 | 5 | 6 | 136 | 5.2 |
| 14214 | all | New South Wales | 155 | 874 | 2 | 9 | 5,304 | 5.64 |
| 14218 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 14219 | all | New South Wales | 4 | 27 | 5 | 8 | 189 | 6.75 |
| 14220 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 14226 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 14227 | all | New South Wales | 17 | 91 | 5 | 7 | 497 | 5.35 |
| 14228 | all | New South Wales | 19 | 112 | 3 | 9 | 706 | 5.89 |
| 14230 | all | New South Wales | 1 | 6 | 6 | 6 | 36 | 6 |
| 14238 | all | New South Wales | 83 | 462 | 1 | 9 | 2,896 | 5.57 |
| 14243 | all | New South Wales | 11 | 59 | 5 | 8 | 325 | 5.36 |
| 14244 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 14245 | all | New South Wales | 186 | 939 | 2 | 8 | 4,777 | 5.05 |