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 117 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 31179 | all | Queensland | 9 | 54 | 5 | 9 | 344 | 6 |
| 31180 | all | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 31181 | all | Queensland | 14 | 74 | 5 | 9 | 406 | 5.29 |
| 31182 | all | Queensland | 10 | 62 | 5 | 9 | 410 | 6.2 |
| 31183 | all | Queensland | 2 | 9 | 4 | 5 | 41 | 4.5 |
| 31187 | all | Queensland | 5 | 23 | 3 | 5 | 109 | 4.6 |
| 31196 | all | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 31197 | all | Queensland | 13 | 72 | 3 | 9 | 440 | 5.54 |
| 31202 | all | Queensland | 52 | 313 | 2 | 9 | 2,023 | 6.02 |
| 31213 | all | Queensland | 18 | 100 | 2 | 8 | 590 | 5.56 |
| 31214 | all | Queensland | 7 | 41 | 5 | 8 | 249 | 5.86 |
| 31217 | all | Queensland | 15 | 105 | 5 | 9 | 755 | 7 |
| 31219 | all | Queensland | 25 | 159 | 3 | 9 | 1,097 | 6.36 |
| 31224 | all | Queensland | 3 | 21 | 6 | 9 | 153 | 7 |
| 31227 | all | Queensland | 58 | 301 | 1 | 8 | 1,775 | 5.19 |
| 31235 | all | Queensland | 6 | 40 | 5 | 9 | 278 | 6.67 |
| 31236 | all | Queensland | 3 | 18 | 5 | 8 | 114 | 6 |
| 31238 | all | Queensland | 1 | 5 | 5 | 5 | 25 | 5 |
| 31241 | all | Queensland | 1 | 4 | 4 | 4 | 16 | 4 |
| 31242 | all | Queensland | 7 | 43 | 5 | 7 | 271 | 6.14 |
| 31245 | all | Queensland | 5 | 30 | 5 | 8 | 188 | 6 |
| 31249 | all | Queensland | 2 | 10 | 5 | 5 | 50 | 5 |
| 31250 | all | Queensland | 1,215 | 6,802 | 1 | 9 | 42,330 | 5.6 |
| 31251 | all | Queensland | 1 | 8 | 8 | 8 | 64 | 8 |
| 31254 | all | Queensland | 14 | 82 | 4 | 9 | 508 | 5.86 |