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 108 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 30440 | all | Queensland | 11 | 63 | 5 | 8 | 377 | 5.73 |
| 30443 | all | Queensland | 2 | 12 | 5 | 7 | 74 | 6 |
| 30444 | all | Queensland | 61 | 356 | 1 | 9 | 2,222 | 5.84 |
| 30449 | all | Queensland | 16 | 91 | 1 | 9 | 607 | 5.69 |
| 30451 | all | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 30455 | all | Queensland | 168 | 959 | 2 | 9 | 5,807 | 5.71 |
| 30461 | all | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 30467 | all | Queensland | 2 | 14 | 5 | 9 | 106 | 7 |
| 30471 | all | Queensland | 20 | 114 | 2 | 9 | 710 | 5.7 |
| 30479 | all | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 30480 | all | Queensland | 2 | 13 | 5 | 8 | 89 | 6.5 |
| 30481 | all | Queensland | 1 | 6 | 6 | 6 | 36 | 6 |
| 30486 | all | Queensland | 14 | 71 | 3 | 7 | 373 | 5.07 |
| 30491 | all | Queensland | 27 | 153 | 4 | 9 | 903 | 5.67 |
| 30492 | all | Queensland | 15 | 101 | 3 | 9 | 749 | 6.73 |
| 30496 | all | Queensland | 2 | 12 | 5 | 7 | 74 | 6 |
| 30497 | all | Queensland | 3 | 15 | 5 | 5 | 75 | 5 |
| 30500 | all | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 30502 | all | Queensland | 4 | 22 | 5 | 7 | 124 | 5.5 |
| 30504 | all | Queensland | 4 | 23 | 5 | 8 | 139 | 5.75 |
| 30506 | all | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 30509 | all | Queensland | 1 | 8 | 8 | 8 | 64 | 8 |
| 30521 | all | Queensland | 468 | 2,622 | 1 | 9 | 15,960 | 5.6 |
| 30523 | all | Queensland | 19 | 109 | 2 | 9 | 679 | 5.74 |
| 30524 | all | Queensland | 5 | 28 | 5 | 7 | 160 | 5.6 |