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 32 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 12413 | all | New South Wales | 3 | 17 | 5 | 7 | 99 | 5.67 |
| 12418 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 12421 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 12428 | all | New South Wales | 32 | 156 | 1 | 7 | 850 | 4.88 |
| 12429 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 12430 | all | New South Wales | 2 | 12 | 5 | 7 | 74 | 6 |
| 12431 | all | New South Wales | 3 | 15 | 5 | 5 | 75 | 5 |
| 12436 | all | New South Wales | 2 | 13 | 5 | 8 | 89 | 6.5 |
| 12439 | all | New South Wales | 10 | 62 | 5 | 9 | 408 | 6.2 |
| 12440 | all | New South Wales | 177 | 1,051 | 1 | 9 | 6,981 | 5.94 |
| 12441 | all | New South Wales | 2 | 10 | 5 | 5 | 50 | 5 |
| 12449 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 12452 | all | New South Wales | 2 | 15 | 7 | 8 | 113 | 7.5 |
| 12453 | all | New South Wales | 3 | 15 | 5 | 5 | 75 | 5 |
| 12462 | all | New South Wales | 1 | 9 | 9 | 9 | 81 | 9 |
| 12468 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 12469 | all | New South Wales | 2 | 9 | 4 | 5 | 41 | 4.5 |
| 12470 | all | New South Wales | 1 | 9 | 9 | 9 | 81 | 9 |
| 12471 | all | New South Wales | 54 | 326 | 3 | 9 | 2,118 | 6.04 |
| 12480 | all | New South Wales | 3 | 17 | 5 | 7 | 99 | 5.67 |
| 12482 | all | New South Wales | 5 | 33 | 5 | 8 | 227 | 6.6 |
| 12484 | all | New South Wales | 719 | 4,234 | 1 | 9 | 26,914 | 5.89 |
| 12491 | all | New South Wales | 51 | 267 | 3 | 8 | 1,429 | 5.24 |
| 12492 | all | New South Wales | 12 | 69 | 2 | 9 | 437 | 5.75 |
| 12493 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |