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 33 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 12495 | all | New South Wales | 6 | 33 | 5 | 8 | 189 | 5.5 |
| 12496 | all | New South Wales | 10 | 65 | 5 | 9 | 449 | 6.5 |
| 12501 | all | New South Wales | 2 | 10 | 5 | 5 | 50 | 5 |
| 12506 | all | New South Wales | 2 | 14 | 5 | 9 | 106 | 7 |
| 12509 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 12511 | all | New South Wales | 49 | 296 | 4 | 9 | 1,874 | 6.04 |
| 12512 | all | New South Wales | 10 | 52 | 5 | 7 | 274 | 5.2 |
| 12514 | all | New South Wales | 57 | 357 | 2 | 9 | 2,415 | 6.26 |
| 12516 | all | New South Wales | 2 | 10 | 5 | 5 | 50 | 5 |
| 12521 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 12523 | all | New South Wales | 23 | 141 | 1 | 9 | 967 | 6.13 |
| 12527 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 12529 | all | New South Wales | 64 | 353 | 2 | 9 | 2,079 | 5.52 |
| 12531 | all | New South Wales | 6 | 34 | 5 | 9 | 206 | 5.67 |
| 12532 | all | New South Wales | 5 | 29 | 5 | 8 | 175 | 5.8 |
| 12534 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 12535 | all | New South Wales | 2 | 13 | 5 | 8 | 89 | 6.5 |
| 12536 | all | New South Wales | 4 | 16 | 3 | 5 | 68 | 4 |
| 12547 | all | New South Wales | 1 | 4 | 4 | 4 | 16 | 4 |
| 12553 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 12557 | all | New South Wales | 5 | 25 | 5 | 5 | 125 | 5 |
| 12563 | all | New South Wales | 43 | 240 | 2 | 9 | 1,444 | 5.58 |
| 12564 | all | New South Wales | 77 | 422 | 2 | 9 | 2,504 | 5.48 |
| 12567 | all | New South Wales | 5 | 29 | 5 | 9 | 181 | 5.8 |
| 12577 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |