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 258 of 272 CSV
| sal_codeTEXT | topicTEXT | stateTEXT | tweet_countINTEGER | score_sumINTEGER | score_minINTEGER | score_maxINTEGER | score_sumsqrINTEGER | avg_scoreREAL |
|---|---|---|---|---|---|---|---|---|
| 11818 | crime | New South Wales | 1 | 3 | 3 | 3 | 9 | 3 |
| 11917 | crime | New South Wales | 32 | 115 | 1 | 9 | 587 | 3.59 |
| 11983 | crime | New South Wales | 5 | 17 | 2 | 5 | 63 | 3.4 |
| 12039 | crime | New South Wales | 1 | 8 | 8 | 8 | 64 | 8 |
| 12084 | crime | New South Wales | 1 | 2 | 2 | 2 | 4 | 2 |
| 12103 | crime | New South Wales | 1 | 3 | 3 | 3 | 9 | 3 |
| 12104 | crime | New South Wales | 5 | 25 | 1 | 9 | 175 | 5 |
| 12124 | crime | New South Wales | 1 | 3 | 3 | 3 | 9 | 3 |
| 12127 | crime | New South Wales | 2 | 7 | 2 | 5 | 29 | 3.5 |
| 12229 | crime | New South Wales | 2 | 4 | 2 | 2 | 8 | 2 |
| 12309 | crime | New South Wales | 62 | 79 | 1 | 5 | 137 | 1.27 |
| 12334 | crime | New South Wales | 2 | 5 | 1 | 4 | 17 | 2.5 |
| 12356 | crime | New South Wales | 537 | 1,128 | 1 | 9 | 3,762 | 2.1 |
| 12358 | crime | New South Wales | 2 | 7 | 2 | 5 | 29 | 3.5 |
| 12370 | crime | New South Wales | 1 | 8 | 8 | 8 | 64 | 8 |
| 12484 | crime | New South Wales | 2 | 8 | 1 | 7 | 50 | 4 |
| 12579 | crime | New South Wales | 9 | 35 | 2 | 7 | 167 | 3.89 |
| 12586 | crime | New South Wales | 3 | 15 | 2 | 8 | 93 | 5 |
| 12589 | crime | New South Wales | 1 | 3 | 3 | 3 | 9 | 3 |
| 12716 | crime | New South Wales | 1 | 9 | 9 | 9 | 81 | 9 |
| 12734 | crime | New South Wales | 2 | 2 | 1 | 1 | 2 | 1 |
| 12749 | crime | New South Wales | 1 | 5 | 5 | 5 | 25 | 5 |
| 12750 | crime | New South Wales | 5 | 19 | 1 | 8 | 99 | 3.8 |
| 12811 | crime | New South Wales | 1 | 3 | 3 | 3 | 9 | 3 |
| 12823 | crime | New South Wales | 2 | 7 | 2 | 5 | 29 | 3.5 |