Scenarios
Scenario 2: crime vs sentiment
Offence totals joined with suburb tweet sentiment pooled to each Victorian LGA (revival analysis).
page 4 of 4 CSV
| lga_codeTEXT | lga_nameTEXT | totalINTEGER | iqr_keptINTEGER | tweets_allINTEGER | avg_allREAL | sal_countINTEGER | tweets_crimeINTEGER | avg_crimeREAL |
|---|---|---|---|---|---|---|---|---|
| 27260 | Wyndham (C) | 11,413 | 1 | 206 | 6.3640777 | 7 | 1 | 9 |
| 27350 | Yarra (C) | 11,154 | 1 | 21 | 6.5238095 | 1 | 0 | null |
| 27450 | Yarra Ranges (S) | 5,781 | 1 | 874 | 5.604119 | 32 | 6 | 2.6666667 |
| 27630 | Yarriambiack (S) | 321 | 1 | 55 | 5.8727273 | 17 | 0 | null |