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 7 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 10436 | all | New South Wales | 3 | 15 | 5 | 5 | 75 | 5 |
| 10440 | all | New South Wales | 1 | 8 | 8 | 8 | 64 | 8 |
| 10441 | all | New South Wales | 8 | 48 | 5 | 8 | 298 | 6 |
| 10446 | all | New South Wales | 2 | 13 | 5 | 8 | 89 | 6.5 |
| 10447 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 10452 | all | New South Wales | 9 | 52 | 5 | 8 | 314 | 5.78 |
| 10454 | all | New South Wales | 16 | 80 | 2 | 8 | 428 | 5 |
| 10455 | all | New South Wales | 4 | 18 | 3 | 5 | 84 | 4.5 |
| 10456 | all | New South Wales | 36 | 216 | 1 | 9 | 1,410 | 6 |
| 10457 | all | New South Wales | 1 | 7 | 7 | 7 | 49 | 7 |
| 10462 | all | New South Wales | 298 | 1,725 | 1 | 9 | 10,753 | 5.79 |
| 10466 | all | New South Wales | 2 | 10 | 5 | 5 | 50 | 5 |
| 10468 | all | New South Wales | 79 | 458 | 1 | 9 | 2,988 | 5.8 |
| 10469 | all | New South Wales | 12 | 70 | 5 | 9 | 434 | 5.83 |
| 10472 | all | New South Wales | 6 | 31 | 5 | 6 | 161 | 5.17 |
| 10475 | all | New South Wales | 6 | 32 | 5 | 7 | 174 | 5.33 |
| 10476 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 10480 | all | New South Wales | 5 | 24 | 1 | 7 | 136 | 4.8 |
| 10483 | all | New South Wales | 4 | 20 | 5 | 5 | 100 | 5 |
| 10484 | all | New South Wales | 3 | 17 | 5 | 7 | 99 | 5.67 |
| 10485 | all | New South Wales | 34 | 191 | 3 | 9 | 1,151 | 5.62 |
| 10494 | all | New South Wales | 1 | 9 | 9 | 9 | 81 | 9 |
| 10499 | all | New South Wales | 2 | 10 | 5 | 5 | 50 | 5 |
| 10500 | all | New South Wales | 1 | 9 | 9 | 9 | 81 | 9 |
| 10501 | all | New South Wales | 9 | 55 | 3 | 9 | 375 | 6.11 |