johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,068 rows where country_or_region = "Australia" and province_or_state = "Victoria" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3069714 | 3069714 | 2021-11-23 | Australia | Victoria | 114943 | 1301 | 0 | -37.8136 | 144.9631 | 2021-11-24 04:22:14 | Victoria, Australia | |||
3748812 | 3748812 | 2021-11-22 | Australia | Victoria | 113755 | 1298 | 0 | -37.8136 | 144.9631 | 2021-11-23 04:22:39 | Victoria, Australia | |||
1014019 | 1014019 | 2021-11-21 | Australia | Victoria | 112942 | 1280 | 0 | -37.8136 | 144.9631 | 2021-11-22 04:22:20 | Victoria, Australia | |||
722183 | 722183 | 2021-11-20 | Australia | Victoria | 111926 | 1277 | 0 | -37.8136 | 144.9631 | 2021-11-21 04:22:13 | Victoria, Australia | |||
161713 | 161713 | 2021-11-19 | Australia | Victoria | 110662 | 1273 | 0 | -37.8136 | 144.9631 | 2021-11-20 04:22:17 | Victoria, Australia | |||
3288600 | 3288600 | 2021-11-18 | Australia | Victoria | 109495 | 1268 | 0 | -37.8136 | 144.9631 | 2021-11-19 04:21:40 | Victoria, Australia | |||
447056 | 447056 | 2021-11-17 | Australia | Victoria | 108231 | 1260 | 0 | -37.8136 | 144.9631 | 2021-11-18 04:21:33 | Victoria, Australia | |||
3342306 | 3342306 | 2021-11-16 | Australia | Victoria | 107245 | 1248 | 0 | -37.8136 | 144.9631 | 2021-11-17 04:21:48 | Victoria, Australia | |||
2287142 | 2287142 | 2021-11-15 | Australia | Victoria | 106262 | 1239 | 0 | -37.8136 | 144.9631 | 2021-11-16 04:21:10 | Victoria, Australia | |||
1321916 | 1321916 | 2021-11-14 | Australia | Victoria | 105484 | 1231 | 0 | -37.8136 | 144.9631 | 2021-11-15 04:21:36 | Victoria, Australia | |||
686042 | 686042 | 2021-11-13 | Australia | Victoria | 104665 | 1226 | 0 | -37.8136 | 144.9631 | 2021-11-14 04:21:31 | Victoria, Australia | |||
714151 | 714151 | 2021-11-12 | Australia | Victoria | 103760 | 1222 | 0 | -37.8136 | 144.9631 | 2021-11-13 04:21:38 | Victoria, Australia | |||
28101 | 28101 | 2021-11-11 | Australia | Victoria | 102566 | 1218 | 0 | -37.8136 | 144.9631 | 2021-11-12 04:22:01 | Victoria, Australia | |||
2844540 | 2844540 | 2021-11-10 | Australia | Victoria | 101451 | 1209 | 0 | -37.8136 | 144.9631 | 2021-11-11 04:21:45 | Victoria, Australia | |||
86810 | 86810 | 2021-11-09 | Australia | Victoria | 100162 | 1206 | 0 | -37.8136 | 144.9631 | 2021-11-10 04:21:38 | Victoria, Australia | |||
3639238 | 3639238 | 2021-11-08 | Australia | Victoria | 99183 | 1192 | 0 | -37.8136 | 144.9631 | 2021-11-09 04:21:36 | Victoria, Australia | |||
2000346 | 2000346 | 2021-11-07 | Australia | Victoria | 98130 | 1182 | 0 | -37.8136 | 144.9631 | 2021-11-08 04:21:43 | Victoria, Australia | |||
495337 | 495337 | 2021-11-06 | Australia | Victoria | 97043 | 1177 | 0 | -37.8136 | 144.9631 | 2021-11-07 04:21:53 | Victoria, Australia | |||
3121192 | 3121192 | 2021-11-05 | Australia | Victoria | 95917 | 1168 | 0 | -37.8136 | 144.9631 | 2021-11-06 04:21:51 | Victoria, Australia | |||
698090 | 698090 | 2021-11-04 | Australia | Victoria | 94669 | 1161 | 0 | -37.8136 | 144.9631 | 2021-11-05 04:21:54 | Victoria, Australia | |||
275868 | 275868 | 2021-11-03 | Australia | Victoria | 93339 | 1151 | 0 | -37.8136 | 144.9631 | 2021-11-04 04:22:20 | Victoria, Australia | |||
43393 | 43393 | 2021-11-02 | Australia | Victoria | 92126 | 1142 | 0 | -37.8136 | 144.9631 | 2021-11-03 06:22:09 | Victoria, Australia | |||
3511089 | 3511089 | 2021-11-01 | Australia | Victoria | 91217 | 1134 | 0 | -37.8136 | 144.9631 | 2021-11-02 04:22:03 | Victoria, Australia | |||
287681 | 287681 | 2021-10-31 | Australia | Victoria | 90261 | 1125 | 0 | -37.8136 | 144.9631 | 2021-11-01 04:22:01 | Victoria, Australia | |||
2720687 | 2720687 | 2021-10-30 | Australia | Victoria | 88930 | 1123 | 0 | -37.8136 | 144.9631 | 2021-10-31 04:22:08 | Victoria, Australia | |||
566789 | 566789 | 2021-10-29 | Australia | Victoria | 87918 | 1111 | 0 | -37.8136 | 144.9631 | 2021-10-30 04:22:03 | Victoria, Australia | |||
4031 | 4031 | 2021-10-28 | Australia | Victoria | 86563 | 1100 | 0 | -37.8136 | 144.9631 | 2021-10-29 04:22:03 | Victoria, Australia | |||
534421 | 534421 | 2021-10-27 | Australia | Victoria | 84942 | 1090 | 0 | -37.8136 | 144.9631 | 2021-10-28 04:22:08 | Victoria, Australia | |||
3491858 | 3491858 | 2021-10-26 | Australia | Victoria | 83185 | 1065 | 0 | -37.8136 | 144.9631 | 2021-10-27 04:22:32 | Victoria, Australia | |||
3793580 | 3793580 | 2021-10-25 | Australia | Victoria | 81651 | 1052 | 0 | -37.8136 | 144.9631 | 2021-10-26 04:22:09 | Victoria, Australia | |||
682026 | 682026 | 2021-10-24 | Australia | Victoria | 80152 | 1048 | 0 | -37.8136 | 144.9631 | 2021-10-25 04:22:31 | Victoria, Australia | |||
770034 | 770034 | 2021-10-23 | Australia | Victoria | 78763 | 1041 | 0 | -37.8136 | 144.9631 | 2021-10-24 04:21:22 | Victoria, Australia | |||
653681 | 653681 | 2021-10-22 | Australia | Victoria | 76886 | 1030 | 0 | -37.8136 | 144.9631 | 2021-10-23 04:21:32 | Victoria, Australia | |||
2123428 | 2123428 | 2021-10-21 | Australia | Victoria | 75340 | 1021 | 0 | -37.8136 | 144.9631 | 2021-10-22 04:21:14 | Victoria, Australia | |||
443040 | 443040 | 2021-10-20 | Australia | Victoria | 73151 | 1005 | 0 | -37.8136 | 144.9631 | 2021-10-21 04:21:18 | Victoria, Australia | |||
597359 | 597359 | 2021-10-19 | Australia | Victoria | 70998 | 993 | 0 | -37.8136 | 144.9631 | 2021-10-20 04:21:00 | Victoria, Australia | |||
2043536 | 2043536 | 2021-10-18 | Australia | Victoria | 69206 | 981 | 0 | -37.8136 | 144.9631 | 2021-10-19 04:20:54 | Victoria, Australia | |||
1908897 | 1908897 | 2021-10-17 | Australia | Victoria | 67457 | 970 | 0 | -37.8136 | 144.9631 | 2021-10-18 04:21:10 | Victoria, Australia | |||
934486 | 934486 | 2021-10-16 | Australia | Victoria | 65674 | 964 | 0 | -37.8136 | 144.9631 | 2021-10-17 04:21:29 | Victoria, Australia | |||
2943041 | 2943041 | 2021-10-15 | Australia | Victoria | 63836 | 957 | 0 | -37.8136 | 144.9631 | 2021-10-16 04:21:15 | Victoria, Australia | |||
491321 | 491321 | 2021-10-14 | Australia | Victoria | 61869 | 951 | 0 | -37.8136 | 144.9631 | 2021-10-15 04:21:26 | Victoria, Australia | |||
633609 | 633609 | 2021-10-13 | Australia | Victoria | 59763 | 945 | 0 | -37.8136 | 144.9631 | 2021-10-14 04:21:29 | Victoria, Australia | |||
1491287 | 1491287 | 2021-10-12 | Australia | Victoria | 57470 | 934 | 0 | -37.8136 | 144.9631 | 2021-10-13 04:20:51 | Victoria, Australia | |||
3007020 | 3007020 | 2021-10-11 | Australia | Victoria | 55936 | 921 | 0 | -37.8136 | 144.9631 | 2021-10-12 04:21:09 | Victoria, Australia | |||
423036 | 423036 | 2021-10-10 | Australia | Victoria | 54470 | 913 | 0 | -37.8136 | 144.9631 | 2021-10-11 04:21:31 | Victoria, Australia | |||
2875893 | 2875893 | 2021-10-09 | Australia | Victoria | 52902 | 905 | 0 | -37.8136 | 144.9631 | 2021-10-10 04:21:38 | Victoria, Australia | |||
2959059 | 2959059 | 2021-10-08 | Australia | Victoria | 51012 | 900 | 0 | -37.8136 | 144.9631 | 2021-10-09 04:21:34 | Victoria, Australia | |||
467097 | 467097 | 2021-10-07 | Australia | Victoria | 49104 | 895 | 0 | -37.8136 | 144.9631 | 2021-10-08 04:21:25 | Victoria, Australia | |||
2458477 | 2458477 | 2021-10-06 | Australia | Victoria | 47266 | 890 | 0 | -37.8136 | 144.9631 | 2021-10-07 04:21:36 | Victoria, Australia | |||
3832171 | 3832171 | 2021-10-05 | Australia | Victoria | 45664 | 888 | 0 | -37.8136 | 144.9631 | 2021-10-06 04:21:33 | Victoria, Australia | |||
986664 | 986664 | 2021-10-04 | Australia | Victoria | 44251 | 877 | 0 | -37.8136 | 144.9631 | 2021-10-05 04:21:27 | Victoria, Australia | |||
1273974 | 1273974 | 2021-10-03 | Australia | Victoria | 42505 | 873 | 0 | -37.8136 | 144.9631 | 2021-10-04 04:21:31 | Victoria, Australia | |||
3927727 | 3927727 | 2021-10-02 | Australia | Victoria | 41128 | 869 | 0 | -37.8136 | 144.9631 | 2021-10-03 04:21:24 | Victoria, Australia | |||
2131707 | 2131707 | 2021-10-01 | Australia | Victoria | 39952 | 866 | 0 | -37.8136 | 144.9631 | 2021-10-02 04:21:25 | Victoria, Australia | |||
2772664 | 2772664 | 2021-09-30 | Australia | Victoria | 38476 | 864 | 0 | -37.8136 | 144.9631 | 2021-10-01 04:21:35 | Victoria, Australia | |||
706120 | 706120 | 2021-09-29 | Australia | Victoria | 37333 | 861 | 0 | -37.8136 | 144.9631 | 2021-09-30 04:21:20 | Victoria, Australia | |||
1333962 | 1333962 | 2021-09-28 | Australia | Victoria | 35904 | 856 | 0 | -37.8136 | 144.9631 | 2021-09-29 04:21:45 | Victoria, Australia | |||
1235331 | 1235331 | 2021-09-27 | Australia | Victoria | 34975 | 849 | 0 | -37.8136 | 144.9631 | 2021-09-28 04:21:28 | Victoria, Australia | |||
2075632 | 2075632 | 2021-09-26 | Australia | Victoria | 33967 | 845 | 0 | -37.8136 | 144.9631 | 2021-09-27 04:21:16 | Victoria, Australia | |||
1724184 | 1724184 | 2021-09-25 | Australia | Victoria | 33294 | 844 | 0 | -37.8136 | 144.9631 | 2021-09-26 04:21:29 | Victoria, Australia | |||
1920904 | 1920904 | 2021-09-24 | Australia | Victoria | 32515 | 842 | 0 | -37.8136 | 144.9631 | 2021-09-25 04:21:31 | Victoria, Australia | |||
601375 | 601375 | 2021-09-23 | Australia | Victoria | 31679 | 841 | 0 | -37.8136 | 144.9631 | 2021-09-24 04:21:44 | Victoria, Australia | |||
3011036 | 3011036 | 2021-09-22 | Australia | Victoria | 30961 | 840 | 0 | -37.8136 | 144.9631 | 2021-09-23 04:21:43 | Victoria, Australia | |||
3757174 | 3757174 | 2021-09-21 | Australia | Victoria | 30216 | 836 | 0 | -37.8136 | 144.9631 | 2021-09-22 04:21:45 | Victoria, Australia | |||
809277 | 809277 | 2021-09-20 | Australia | Victoria | 29596 | 833 | 0 | -37.8136 | 144.9631 | 2021-09-21 04:21:26 | Victoria, Australia | |||
1814476 | 1814476 | 2021-09-19 | Australia | Victoria | 29008 | 832 | 0 | -37.8136 | 144.9631 | 2021-09-20 04:21:22 | Victoria, Australia | |||
16056 | 16056 | 2021-09-18 | Australia | Victoria | 28456 | 831 | 0 | -37.8136 | 144.9631 | 2021-09-19 04:21:34 | Victoria, Australia | |||
2617741 | 2617741 | 2021-09-17 | Australia | Victoria | 27968 | 830 | 0 | -37.8136 | 144.9631 | 2021-09-18 04:21:24 | Victoria, Australia | |||
2808449 | 2808449 | 2021-09-16 | Australia | Victoria | 27439 | 829 | 0 | -37.8136 | 144.9631 | 2021-09-17 04:21:46 | Victoria, Australia | |||
1374194 | 1374194 | 2021-09-15 | Australia | Victoria | 26942 | 828 | 0 | -37.8136 | 144.9631 | 2021-09-16 04:22:19 | Victoria, Australia | |||
2462493 | 2462493 | 2021-09-14 | Australia | Victoria | 26439 | 828 | 0 | -37.8136 | 144.9631 | 2021-09-15 03:22:37 | Victoria, Australia | |||
1385332 | 1385332 | 2021-09-13 | Australia | Victoria | 26036 | 826 | 0 | -37.8136 | 144.9631 | 2021-09-14 04:21:41 | Victoria, Australia | |||
1884701 | 1884701 | 2021-09-12 | Australia | Victoria | 25591 | 824 | 0 | -37.8136 | 144.9631 | 2021-09-13 04:21:15 | Victoria, Australia | |||
3805604 | 3805604 | 2021-09-11 | Australia | Victoria | 25128 | 824 | 0 | -37.8136 | 144.9631 | 2021-09-12 04:21:13 | Victoria, Australia | |||
3448544 | 3448544 | 2021-09-10 | Australia | Victoria | 24747 | 824 | 0 | -37.8136 | 144.9631 | 2021-09-11 04:21:30 | Victoria, Australia | |||
1262490 | 1262490 | 2021-09-09 | Australia | Victoria | 24297 | 824 | 0 | -37.8136 | 144.9631 | 2021-09-10 04:21:20 | Victoria, Australia | |||
2278860 | 2278860 | 2021-09-08 | Australia | Victoria | 23964 | 823 | 0 | -37.8136 | 144.9631 | 2021-09-09 04:21:27 | Victoria, Australia | |||
641639 | 641639 | 2021-09-07 | Australia | Victoria | 23641 | 823 | 0 | -37.8136 | 144.9631 | 2021-09-08 04:21:31 | Victoria, Australia | |||
3193702 | 3193702 | 2021-09-06 | Australia | Victoria | 23429 | 823 | 0 | -37.8136 | 144.9631 | 2021-09-07 04:21:35 | Victoria, Australia | |||
3280570 | 3280570 | 2021-09-05 | Australia | Victoria | 23188 | 823 | 0 | -37.8136 | 144.9631 | 2021-09-06 04:21:22 | Victoria, Australia | |||
248984 | 248984 | 2021-09-04 | Australia | Victoria | 22942 | 823 | 0 | -37.8136 | 144.9631 | 2021-09-05 04:21:33 | Victoria, Australia | |||
3974265 | 3974265 | 2021-09-03 | Australia | Victoria | 22759 | 823 | 0 | -37.8136 | 144.9631 | 2021-09-04 04:21:28 | Victoria, Australia | |||
177727 | 177727 | 2021-09-02 | Australia | Victoria | 22570 | 823 | 0 | -37.8136 | 144.9631 | 2021-09-03 04:21:20 | Victoria, Australia | |||
66762 | 66762 | 2021-09-01 | Australia | Victoria | 22361 | 822 | 0 | -37.8136 | 144.9631 | 2021-09-02 04:21:15 | Victoria, Australia | |||
2067604 | 2067604 | 2021-08-31 | Australia | Victoria | 22187 | 822 | 0 | -37.8136 | 144.9631 | 2021-09-01 04:21:38 | Victoria, Australia | |||
1775058 | 1775058 | 2021-08-30 | Australia | Victoria | 22071 | 820 | 0 | -37.8136 | 144.9631 | 2021-08-31 04:21:46 | Victoria, Australia | |||
3891632 | 3891632 | 2021-08-29 | Australia | Victoria | 21996 | 820 | 0 | -37.8136 | 144.9631 | 2021-08-30 04:21:23 | Victoria, Australia | |||
2792735 | 2792735 | 2021-08-28 | Australia | Victoria | 21926 | 820 | 0 | -37.8136 | 144.9631 | 2021-08-29 04:21:14 | Victoria, Australia | |||
2922894 | 2922894 | 2021-08-27 | Australia | Victoria | 21835 | 820 | 0 | -37.8136 | 144.9631 | 2021-08-28 04:21:28 | Victoria, Australia | |||
1595908 | 1595908 | 2021-08-26 | Australia | Victoria | 21772 | 820 | 0 | -37.8136 | 144.9631 | 2021-08-27 04:21:37 | Victoria, Australia | |||
32117 | 32117 | 2021-08-25 | Australia | Victoria | 21694 | 820 | 0 | -37.8136 | 144.9631 | 2021-08-26 04:21:28 | Victoria, Australia | |||
3105156 | 3105156 | 2021-08-24 | Australia | Victoria | 21618 | 820 | 0 | -37.8136 | 144.9631 | 2021-08-25 04:21:41 | Victoria, Australia | |||
3165327 | 3165327 | 2021-08-23 | Australia | Victoria | 21577 | 820 | 0 | -37.8136 | 144.9631 | 2021-08-24 04:21:19 | Victoria, Australia | |||
2175254 | 2175254 | 2021-08-22 | Australia | Victoria | 21526 | 820 | 0 | -37.8136 | 144.9631 | 2021-08-23 04:21:27 | Victoria, Australia | |||
3555350 | 3555350 | 2021-08-21 | Australia | Victoria | 21455 | 820 | 0 | -37.8136 | 144.9631 | 2021-08-22 04:21:29 | Victoria, Australia | |||
1853692 | 1853692 | 2021-08-20 | Australia | Victoria | 21389 | 820 | 0 | -37.8136 | 144.9631 | 2021-08-21 04:21:38 | Victoria, Australia | |||
511399 | 511399 | 2021-08-19 | Australia | Victoria | 21328 | 820 | 0 | -37.8136 | 144.9631 | 2021-08-20 04:21:33 | Victoria, Australia | |||
2517878 | 2517878 | 2021-08-18 | Australia | Victoria | 21271 | 820 | 0 | -37.8136 | 144.9631 | 2021-08-19 04:21:15 | Victoria, Australia | |||
244970 | 244970 | 2021-08-17 | Australia | Victoria | 21215 | 820 | 0 | -37.8136 | 144.9631 | 2021-08-18 04:21:35 | Victoria, Australia | |||
1603933 | 1603933 | 2021-08-16 | Australia | Victoria | 21191 | 820 | 0 | -37.8136 | 144.9631 | 2021-08-17 04:21:49 | Victoria, Australia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);