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 229 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 22123 | income | Victoria | 1 | 8 | 8 | 8 | 64 | 8 |
| 22137 | income | Victoria | 8 | 43 | 1 | 9 | 301 | 5.38 |
| 22160 | income | Victoria | 8 | 55 | 5 | 9 | 391 | 6.88 |
| 22164 | income | Victoria | 1 | 9 | 9 | 9 | 81 | 9 |
| 22179 | income | Victoria | 3 | 19 | 5 | 9 | 131 | 6.33 |
| 22184 | income | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |
| 22186 | income | Victoria | 6 | 41 | 5 | 9 | 291 | 6.83 |
| 22193 | income | Victoria | 3 | 23 | 7 | 8 | 177 | 7.67 |
| 22199 | income | Victoria | 2 | 16 | 7 | 9 | 130 | 8 |
| 22215 | income | Victoria | 26 | 94 | 1 | 9 | 476 | 3.62 |
| 22217 | income | Victoria | 10 | 54 | 1 | 9 | 354 | 5.4 |
| 22218 | income | Victoria | 1 | 4 | 4 | 4 | 16 | 4 |
| 22226 | income | Victoria | 23 | 137 | 3 | 9 | 903 | 5.96 |
| 22236 | income | Victoria | 2 | 16 | 7 | 9 | 130 | 8 |
| 22246 | income | Victoria | 4 | 22 | 5 | 7 | 124 | 5.5 |
| 22250 | income | Victoria | 1 | 7 | 7 | 7 | 49 | 7 |
| 22263 | income | Victoria | 18 | 105 | 2 | 9 | 733 | 5.83 |
| 22265 | income | Victoria | 8 | 21 | 1 | 6 | 93 | 2.62 |
| 22275 | income | Victoria | 75 | 497 | 1 | 9 | 3,633 | 6.63 |
| 22294 | income | Victoria | 4 | 21 | 3 | 8 | 125 | 5.25 |
| 22299 | income | Victoria | 1 | 6 | 6 | 6 | 36 | 6 |
| 22301 | income | Victoria | 1 | 8 | 8 | 8 | 64 | 8 |
| 22315 | income | Victoria | 4 | 22 | 5 | 7 | 124 | 5.5 |
| 22319 | income | Victoria | 1 | 9 | 9 | 9 | 81 | 9 |
| 22331 | income | Victoria | 1 | 5 | 5 | 5 | 25 | 5 |