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 18 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 11323 | all | New South Wales | 63 | 362 | 1 | 9 | 2,302 | 5.75 |
| 11328 | all | New South Wales | 1 | 7 | 7 | 7 | 49 | 7 |
| 11329 | all | New South Wales | 2 | 13 | 5 | 8 | 89 | 6.5 |
| 11334 | all | New South Wales | 1 | 7 | 7 | 7 | 49 | 7 |
| 11338 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 11341 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 11346 | all | New South Wales | 3 | 15 | 5 | 5 | 75 | 5 |
| 11354 | all | New South Wales | 2 | 14 | 6 | 8 | 100 | 7 |
| 11363 | all | New South Wales | 4 | 18 | 3 | 7 | 92 | 4.5 |
| 11369 | all | New South Wales | 3 | 17 | 3 | 9 | 115 | 5.67 |
| 11370 | all | New South Wales | 4 | 19 | 4 | 5 | 91 | 4.75 |
| 11374 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 11375 | all | New South Wales | 31 | 160 | 3 | 8 | 844 | 5.16 |
| 11378 | all | New South Wales | 120 | 711 | 1 | 9 | 4,545 | 5.92 |
| 11382 | all | New South Wales | 4 | 19 | 4 | 5 | 91 | 4.75 |
| 11383 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 11384 | all | New South Wales | 1 | 8 | 8 | 8 | 64 | 8 |
| 11385 | all | New South Wales | 5 | 30 | 5 | 8 | 188 | 6 |
| 11393 | all | New South Wales | 1 | 7 | 7 | 7 | 49 | 7 |
| 11396 | all | New South Wales | 5 | 29 | 4 | 8 | 179 | 5.8 |
| 11401 | all | New South Wales | 2 | 12 | 5 | 7 | 74 | 6 |
| 11404 | all | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 11406 | all | New South Wales | 30 | 165 | 3 | 8 | 945 | 5.5 |
| 11407 | all | New South Wales | 2 | 10 | 5 | 5 | 50 | 5 |
| 11414 | all | New South Wales | 5 | 28 | 5 | 8 | 164 | 5.6 |