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 20 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 11486 | all | New South Wales | 6 | 39 | 5 | 9 | 265 | 6.5 |
| 11495 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 11499 | all | New South Wales | 5 | 24 | 3 | 6 | 120 | 4.8 |
| 11502 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 11505 | all | New South Wales | 2 | 12 | 5 | 7 | 74 | 6 |
| 11511 | all | New South Wales | 3 | 19 | 5 | 9 | 131 | 6.33 |
| 11515 | all | New South Wales | 2 | 12 | 5 | 7 | 74 | 6 |
| 11516 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 11521 | all | New South Wales | 35 | 199 | 2 | 9 | 1,199 | 5.69 |
| 11522 | all | New South Wales | 5 | 31 | 5 | 9 | 205 | 6.2 |
| 11523 | all | New South Wales | 901 | 4,549 | 1 | 9 | 23,815 | 5.05 |
| 11524 | all | New South Wales | 1 | 7 | 7 | 7 | 49 | 7 |
| 11526 | all | New South Wales | 4 | 27 | 5 | 9 | 195 | 6.75 |
| 11530 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 11532 | all | New South Wales | 4 | 20 | 5 | 5 | 100 | 5 |
| 11533 | all | New South Wales | 9 | 55 | 3 | 9 | 361 | 6.11 |
| 11534 | all | New South Wales | 11 | 62 | 5 | 8 | 360 | 5.64 |
| 11539 | all | New South Wales | 134 | 742 | 1 | 9 | 4,406 | 5.54 |
| 11562 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 11566 | all | New South Wales | 10 | 56 | 5 | 7 | 320 | 5.6 |
| 11574 | all | New South Wales | 2 | 10 | 5 | 5 | 50 | 5 |
| 11577 | all | New South Wales | 6 | 40 | 5 | 8 | 274 | 6.67 |
| 11580 | all | New South Wales | 16 | 98 | 5 | 9 | 624 | 6.12 |
| 11582 | all | New South Wales | 1 | 8 | 8 | 8 | 64 | 8 |
| 11585 | all | New South Wales | 17 | 122 | 3 | 9 | 918 | 7.18 |