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 120 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 31385 | all | Queensland | 1 | 6 | 6 | 6 | 36 | 6 |
| 31387 | all | Queensland | 13 | 87 | 5 | 9 | 619 | 6.69 |
| 31388 | all | Queensland | 66 | 348 | 1 | 9 | 2,080 | 5.27 |
| 31389 | all | Queensland | 24 | 143 | 3 | 9 | 913 | 5.96 |
| 31390 | all | Queensland | 12 | 70 | 4 | 9 | 434 | 5.83 |
| 31392 | all | Queensland | 4 | 18 | 3 | 5 | 84 | 4.5 |
| 31394 | all | Queensland | 13 | 69 | 5 | 9 | 381 | 5.31 |
| 31395 | all | Queensland | 8 | 51 | 5 | 8 | 341 | 6.38 |
| 31398 | all | Queensland | 332 | 1,768 | 1 | 9 | 10,350 | 5.33 |
| 31400 | all | Queensland | 1 | 9 | 9 | 9 | 81 | 9 |
| 31402 | all | Queensland | 2 | 15 | 6 | 9 | 117 | 7.5 |
| 31404 | all | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 31405 | all | Queensland | 124 | 773 | 2 | 9 | 5,055 | 6.23 |
| 31412 | all | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 31413 | all | Queensland | 1 | 9 | 9 | 9 | 81 | 9 |
| 31416 | all | Queensland | 4 | 22 | 5 | 7 | 124 | 5.5 |
| 31417 | all | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 31420 | all | Queensland | 1 | 8 | 8 | 8 | 64 | 8 |
| 31421 | all | Queensland | 2 | 10 | 5 | 5 | 50 | 5 |
| 31424 | all | Queensland | 257 | 1,339 | 1 | 9 | 7,767 | 5.21 |
| 31425 | all | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 31426 | all | Queensland | 1 | 6 | 6 | 6 | 36 | 6 |
| 31429 | all | Queensland | 2 | 10 | 5 | 5 | 50 | 5 |
| 31437 | all | Queensland | 1 | 7 | 7 | 7 | 49 | 7 |
| 31440 | all | Queensland | 219 | 1,251 | 1 | 9 | 8,245 | 5.71 |