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 223 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 20375 | income | Victoria | 1 | 6 | 6 | 6 | 36 | 6 |
| 20386 | income | Victoria | 1 | 4 | 4 | 4 | 16 | 4 |
| 20409 | income | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 20439 | income | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 20460 | income | Victoria | 9 | 49 | 1 | 9 | 345 | 5.44 |
| 20472 | income | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 20492 | income | Victoria | 3 | 13 | 3 | 5 | 59 | 4.33 |
| 20496 | income | Victoria | 1 | 8 | 8 | 8 | 64 | 8 |
| 20498 | income | Victoria | 13 | 70 | 1 | 9 | 420 | 5.38 |
| 20516 | income | Victoria | 209 | 1,192 | 1 | 9 | 7,570 | 5.7 |
| 20521 | income | Victoria | 9 | 65 | 5 | 8 | 479 | 7.22 |
| 20528 | income | Victoria | 2 | 14 | 5 | 9 | 106 | 7 |
| 20561 | income | Victoria | 1 | 8 | 8 | 8 | 64 | 8 |
| 20567 | income | Victoria | 2 | 13 | 5 | 8 | 89 | 6.5 |
| 20569 | income | Victoria | 10 | 81 | 6 | 9 | 669 | 8.1 |
| 20580 | income | Victoria | 40 | 273 | 1 | 9 | 2,133 | 6.82 |
| 20582 | income | Victoria | 1 | 8 | 8 | 8 | 64 | 8 |
| 20591 | income | Victoria | 14 | 82 | 2 | 9 | 538 | 5.86 |
| 20596 | income | Victoria | 1 | 9 | 9 | 9 | 81 | 9 |
| 20607 | income | Victoria | 4 | 25 | 3 | 9 | 179 | 6.25 |
| 20614 | income | Victoria | 144 | 724 | 1 | 9 | 3,682 | 5.03 |
| 20648 | income | Victoria | 1 | 7 | 7 | 7 | 49 | 7 |
| 20657 | income | Victoria | 33 | 194 | 2 | 9 | 1,264 | 5.88 |
| 20661 | income | Victoria | 1 | 6 | 6 | 6 | 36 | 6 |
| 20662 | income | Victoria | 3 | 19 | 5 | 8 | 125 | 6.33 |