Scenarios
Scenario 2: crime vs sentiment
Offence totals joined with suburb tweet sentiment pooled to each Victorian LGA (revival analysis).
page 2 of 4 CSV
| lga_codeTEXT | lga_nameTEXT | totalINTEGER | iqr_keptINTEGER | tweets_allINTEGER | avg_allREAL | sal_countINTEGER | tweets_crimeINTEGER | avg_crimeREAL |
|---|---|---|---|---|---|---|---|---|
| 22670 | Greater Dandenong (C) | 14,234 | 0 | 77 | 6.1428571 | 3 | 1 | 1 |
| 22750 | Greater Geelong (C) | 15,906 | 0 | 29,482 | 5.5537955 | 27 | 161 | 4.2111801 |
| 22830 | Greater Shepparton (C) | 6,241 | 1 | 2,681 | 5.7799329 | 14 | 4 | 2.5 |
| 22910 | Hepburn (S) | 623 | 1 | 2,543 | 5.4463232 | 25 | 18 | 3.8888889 |
| 22980 | Hindmarsh (S) | 251 | 1 | 514 | 5.5350195 | 8 | 4 | 3.25 |
| 23110 | Hobsons Bay (C) | 4,852 | 1 | 9 | 6.5555556 | 3 | 0 | null |
| 23190 | Horsham (RC) | 1,442 | 1 | 606 | 5.5280528 | 8 | 6 | 4 |
| 23270 | Hume (C) | 15,661 | 0 | 2,784 | 5.4698276 | 12 | 11 | 4.4545455 |
| 23350 | Indigo (S) | 371 | 1 | 632 | 5.8781646 | 12 | 2 | 3 |
| 23430 | Kingston (C) | 8,646 | 0 | 111 | 5.5135135 | 12 | 0 | null |
| 23670 | Knox (C) | 8,103 | 1 | 92 | 6.1521739 | 8 | 0 | null |
| 23810 | Latrobe (C) | 9,958 | 1 | 3,919 | 5.5154376 | 16 | 27 | 3.4444444 |
| 23940 | Loddon (S) | 389 | 1 | 2,931 | 5.563289 | 14 | 6 | 3.5 |
| 24130 | Macedon Ranges (S) | 1,785 | 1 | 1,190 | 5.7294118 | 17 | 5 | 5.6 |
| 24210 | Manningham (C) | 3,421 | 1 | 107 | 5.2056075 | 5 | 2 | 3 |
| 24250 | Mansfield (S) | 326 | 1 | 150 | 5.64 | 13 | 0 | null |
| 24330 | Maribyrnong (C) | 6,680 | 1 | 150 | 6.04 | 6 | 0 | null |
| 24410 | Maroondah (C) | 6,055 | 1 | 3 | 6.3333333 | 3 | 0 | null |
| 24600 | Melbourne (C) | 26,694 | 0 | 587,188 | 5.5370648 | 5 | 4,026 | 3.5047193 |
| 24650 | Melton (S) | 8,367 | 1 | 3,608 | 5.7228381 | 10 | 29 | 3.9310345 |
| 24780 | Mildura (RC) | 5,516 | 1 | 1,123 | 5.7497774 | 19 | 6 | 4.6666667 |
| 24850 | Mitchell (S) | 3,049 | 1 | 1,892 | 5.5676533 | 15 | 17 | 4.8235294 |
| 24900 | Moira (S) | 1,685 | 1 | 2,121 | 5.6982555 | 20 | 33 | 2.6060606 |
| 24970 | Monash (C) | 8,029 | 1 | 175 | 5.9885714 | 9 | 2 | 6 |
| 25060 | Moonee Valley (C) | 6,506 | 1 | 249 | 6.313253 | 7 | 0 | null |