Scenarios
Scenario 2: crime vs sentiment
Offence totals joined with suburb tweet sentiment pooled to each Victorian LGA (revival analysis).
page 3 of 4 CSV
| lga_codeTEXT | lga_nameTEXT | totalINTEGER | iqr_keptINTEGER | tweets_allINTEGER | avg_allREAL | sal_countINTEGER | tweets_crimeINTEGER | avg_crimeREAL |
|---|---|---|---|---|---|---|---|---|
| 25150 | Moorabool (S) | 1,636 | 1 | 449 | 6.3608018 | 19 | 0 | null |
| 25250 | Moreland (C) | 11,376 | 1 | 82 | 5.902439 | 5 | 0 | null |
| 25340 | Mornington Peninsula (S) | 8,176 | 1 | 387 | 5.4883721 | 22 | 2 | 5 |
| 25430 | Mount Alexander (S) | 756 | 1 | 8,551 | 5.6367676 | 16 | 26 | 4.0384615 |
| 25490 | Moyne (S) | 460 | 1 | 3,314 | 5.5437538 | 19 | 13 | 5.3076923 |
| 25620 | Murrindindi (S) | 594 | 1 | 422 | 5.5616114 | 20 | 1 | 1 |
| 25710 | Nillumbik (S) | 1,628 | 1 | 73 | 6.4383562 | 8 | 0 | null |
| 25810 | Northern Grampians (S) | 768 | 1 | 441 | 6.2199546 | 16 | 0 | null |
| 25900 | Port Phillip (C) | 9,691 | 0 | 26 | 6.1538462 | 2 | 0 | null |
| 25990 | Pyrenees (S) | 421 | 1 | 534 | 6.0917603 | 17 | 2 | 7 |
| 26080 | Queenscliffe (B) | 117 | 1 | 0 | null | 0 | 0 | null |
| 26170 | South Gippsland (S) | 1,002 | 1 | 1,166 | 5.7958834 | 30 | 8 | 1.25 |
| 26260 | Southern Grampians (S) | 1,116 | 1 | 1,053 | 5.2991453 | 19 | 6 | 3.5 |
| 26350 | Stonnington (C) | 8,199 | 1 | 72 | 6.5972222 | 3 | 0 | null |
| 26430 | Strathbogie (S) | 446 | 1 | 973 | 5.5693731 | 12 | 5 | 2.2 |
| 26490 | Surf Coast (S) | 892 | 1 | 3,150 | 5.5215873 | 16 | 12 | 4 |
| 26610 | Swan Hill (RC) | 1,871 | 1 | 1,819 | 5.3001649 | 12 | 9 | 2.8888889 |
| 26670 | Towong (S) | 173 | 1 | 68 | 5.6470588 | 15 | 0 | null |
| 26700 | Wangaratta (RC) | 1,644 | 1 | 1,170 | 5.4581197 | 16 | 4 | 3.75 |
| 26730 | Warrnambool (C) | 3,017 | 1 | 2,864 | 5.7140363 | 4 | 11 | 4.2727273 |
| 26810 | Wellington (S) | 2,936 | 1 | 1,159 | 5.8697153 | 44 | 1 | 8 |
| 26890 | West Wimmera (S) | 125 | 1 | 363 | 5.4958678 | 11 | 0 | null |
| 26980 | Whitehorse (C) | 6,375 | 1 | 38 | 5.9473684 | 6 | 0 | null |
| 27070 | Whittlesea (C) | 11,952 | 1 | 80 | 4.8375 | 8 | 1 | 5 |
| 27170 | Wodonga (RC) | 2,432 | 1 | 1,895 | 5.5277045 | 7 | 4 | 2.5 |