Scenarios
Scenario 2: crime vs sentiment
Offence totals joined with suburb tweet sentiment pooled to each Victorian LGA (revival analysis).
page 1 of 4 CSV
| lga_codeTEXT | lga_nameTEXT | totalINTEGER | iqr_keptINTEGER | tweets_allINTEGER | avg_allREAL | sal_countINTEGER | tweets_crimeINTEGER | avg_crimeREAL |
|---|---|---|---|---|---|---|---|---|
| 20110 | Alpine (S) | 399 | 1 | 660 | 5.9878788 | 13 | 3 | 2 |
| 20260 | Ararat (RC) | 927 | 1 | 1,226 | 5.6166395 | 19 | 14 | 2.5714286 |
| 20570 | Ballarat (C) | 8,156 | 1 | 18,995 | 5.1952093 | 14 | 485 | 4.2515464 |
| 20660 | Banyule (C) | 7,024 | 1 | 22 | 6.2272727 | 5 | 0 | null |
| 20740 | Bass Coast (S) | 1,784 | 1 | 2,044 | 5.7744618 | 23 | 7 | 4 |
| 20830 | Baw Baw (S) | 3,200 | 1 | 1,802 | 5.4317425 | 37 | 21 | 3.2380952 |
| 20910 | Bayside (C) | 3,570 | 1 | 6 | 6.5 | 1 | 0 | null |
| 21010 | Benalla (RC) | 881 | 1 | 707 | 5.7128713 | 15 | 12 | 4.0833333 |
| 21110 | Boroondara (C) | 5,568 | 1 | 29 | 5.8965517 | 2 | 0 | null |
| 21180 | Brimbank (C) | 14,670 | 1 | 35 | 6.3714286 | 6 | 0 | null |
| 21270 | Buloke (S) | 216 | 1 | 1,105 | 5.1303167 | 17 | 2 | 2 |
| 21370 | Campaspe (S) | 2,924 | 1 | 2,047 | 5.4797264 | 13 | 12 | 3.5 |
| 21450 | Cardinia (S) | 4,627 | 1 | 3,623 | 5.654154 | 20 | 22 | 4.1818182 |
| 22250 | Gannawarra (S) | 585 | 1 | 148 | 5.5067568 | 14 | 0 | null |
| 21610 | Casey (C) | 16,344 | 0 | 238 | 5.9201681 | 15 | 0 | null |
| 21670 | Central Goldfields (S) | 918 | 1 | 238 | 5.8445378 | 10 | 3 | 5.3333333 |
| 21750 | Colac-Otway (S) | 1,325 | 1 | 689 | 5.7866473 | 18 | 1 | 1 |
| 21830 | Corangamite (S) | 488 | 1 | 679 | 5.5272459 | 19 | 1 | 3 |
| 21890 | Darebin (C) | 11,267 | 1 | 172 | 5.755814 | 5 | 0 | null |
| 22110 | East Gippsland (S) | 3,215 | 1 | 1,496 | 5.4064171 | 51 | 24 | 3.25 |
| 22170 | Frankston (C) | 11,165 | 1 | 74 | 5.5810811 | 3 | 5 | 1.8 |
| 22490 | Golden Plains (S) | 510 | 1 | 287 | 5.4216028 | 21 | 1 | 1 |
| 22620 | Greater Bendigo (C) | 8,116 | 1 | 5,134 | 5.7693806 | 24 | 22 | 5.1818182 |
| 22410 | Glenelg (S) | 963 | 1 | 304 | 6.0394737 | 16 | 1 | 5 |
| 22310 | Glen Eira (C) | 4,901 | 1 | 1,652 | 5.4612591 | 7 | 4 | 2.75 |