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 226 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 21227 | income | Victoria | 1 | 6 | 6 | 6 | 36 | 6 |
| 21229 | income | Victoria | 16 | 71 | 1 | 7 | 381 | 4.44 |
| 21234 | income | Victoria | 12 | 64 | 1 | 8 | 388 | 5.33 |
| 21235 | income | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 21252 | income | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 21295 | income | Victoria | 9 | 52 | 1 | 9 | 358 | 5.78 |
| 21314 | income | Victoria | 2 | 17 | 8 | 9 | 145 | 8.5 |
| 21339 | income | Victoria | 2 | 17 | 8 | 9 | 145 | 8.5 |
| 21345 | income | Victoria | 3 | 20 | 5 | 8 | 138 | 6.67 |
| 21352 | income | Victoria | 6 | 28 | 2 | 9 | 172 | 4.67 |
| 21365 | income | Victoria | 3 | 19 | 2 | 9 | 149 | 6.33 |
| 21391 | income | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 21393 | income | Victoria | 3 | 25 | 8 | 9 | 209 | 8.33 |
| 21396 | income | Victoria | 118 | 706 | 1 | 9 | 4,734 | 5.98 |
| 21399 | income | Victoria | 2 | 12 | 3 | 9 | 90 | 6 |
| 21412 | income | Victoria | 3 | 19 | 3 | 8 | 137 | 6.33 |
| 21414 | income | Victoria | 11 | 84 | 3 | 9 | 686 | 7.64 |
| 21425 | income | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 21427 | income | Victoria | 2 | 15 | 6 | 9 | 117 | 7.5 |
| 21449 | income | Victoria | 9 | 47 | 3 | 8 | 281 | 5.22 |
| 21456 | income | Victoria | 2 | 15 | 6 | 9 | 117 | 7.5 |
| 21469 | income | Victoria | 119 | 741 | 1 | 9 | 5,029 | 6.23 |
| 21490 | income | Victoria | 7 | 58 | 7 | 9 | 484 | 8.29 |
| 21493 | income | Victoria | 2 | 11 | 3 | 8 | 73 | 5.5 |
| 21520 | income | Victoria | 16 | 97 | 5 | 8 | 611 | 6.06 |