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 96 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 22527 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 22528 | all | Victoria | 1 | 9 | 9 | 9 | 81 | 9 |
| 22530 | all | Victoria | 1 | 7 | 7 | 7 | 49 | 7 |
| 22531 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 22533 | all | Victoria | 3 | 16 | 5 | 6 | 86 | 5.33 |
| 22536 | all | Victoria | 24 | 130 | 5 | 9 | 726 | 5.42 |
| 22537 | all | Victoria | 3 | 16 | 5 | 6 | 86 | 5.33 |
| 22538 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 22539 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 22542 | all | Victoria | 8 | 42 | 5 | 7 | 224 | 5.25 |
| 22544 | all | Victoria | 10 | 54 | 3 | 9 | 320 | 5.4 |
| 22545 | all | Victoria | 1 | 9 | 9 | 9 | 81 | 9 |
| 22546 | all | Victoria | 15 | 66 | 1 | 9 | 330 | 4.4 |
| 22547 | all | Victoria | 13 | 87 | 3 | 9 | 629 | 6.69 |
| 22549 | all | Victoria | 13 | 65 | 5 | 5 | 325 | 5 |
| 22550 | all | Victoria | 3 | 15 | 5 | 5 | 75 | 5 |
| 22551 | all | Victoria | 1,559 | 8,630 | 1 | 9 | 52,134 | 5.54 |
| 22554 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 22562 | all | Victoria | 6 | 34 | 5 | 7 | 198 | 5.67 |
| 22563 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 22565 | all | Victoria | 103 | 627 | 1 | 9 | 4,221 | 6.09 |
| 22566 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 22567 | all | Victoria | 2 | 11 | 5 | 6 | 61 | 5.5 |
| 22568 | all | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 22569 | all | Victoria | 3,108 | 16,988 | 1 | 9 | 101,570 | 5.47 |