johns_hopkins_csse_daily_reports

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

1,228 rows where country_or_region = "Australia" sorted by day descending

View and edit SQL

country_or_region

  • Australia · 1,228
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
180847 2020-07-13 Australia Australian Capital Territory     113 3 105 5 -35.4735 149.0124 2020-07-14 04:34:46 Australian Capital Territory, Australia
181107 2020-07-13 Australia New South Wales     3505 49 2988 468 -33.8688 151.2093 2020-07-14 04:34:46 New South Wales, Australia
181119 2020-07-13 Australia Northern Territory     31 0 29 2 -12.4634 130.8456 2020-07-14 04:34:46 Northern Territory, Australia
181168 2020-07-13 Australia Queensland     1071 6 1058 7 -27.4698 153.0251 2020-07-14 04:34:46 Queensland, Australia
181226 2020-07-13 Australia South Australia     443 4 439 0 -34.9285 138.6007 2020-07-14 04:34:46 South Australia, Australia
181239 2020-07-13 Australia Tasmania     228 13 215 0 -42.8821 147.3272 2020-07-14 04:34:46 Tasmania, Australia
181290 2020-07-13 Australia Victoria     4224 24 2395 1805 -37.8136 144.9631 2020-07-14 04:34:46 Victoria, Australia
181301 2020-07-13 Australia Western Australia     636 9 606 21 -31.9505 115.8605 2020-07-14 04:34:46 Western Australia, Australia
321552 2020-07-12 Australia Australian Capital Territory     113 3 105 5 -35.4735 149.0124 2020-07-13 04:43:04 Australian Capital Territory, Australia
321813 2020-07-12 Australia New South Wales     3492 49 2988 455 -33.8688 151.2093 2020-07-13 04:43:04 New South Wales, Australia
321825 2020-07-12 Australia Northern Territory     31 0 29 2 -12.4634 130.8456 2020-07-13 04:43:04 Northern Territory, Australia
321874 2020-07-12 Australia Queensland     1071 6 1058 7 -27.4698 153.0251 2020-07-13 04:43:04 Queensland, Australia
321932 2020-07-12 Australia South Australia     443 4 439 0 -34.9285 138.6007 2020-07-13 04:43:04 South Australia, Australia
321945 2020-07-12 Australia Tasmania     228 13 215 0 -42.8821 147.3272 2020-07-13 04:43:04 Tasmania, Australia
321996 2020-07-12 Australia Victoria     3967 24 2329 1614 -37.8136 144.9631 2020-07-13 04:43:04 Victoria, Australia
322007 2020-07-12 Australia Western Australia     635 9 606 20 -31.9505 115.8605 2020-07-13 04:43:04 Western Australia, Australia
274944 2020-07-11 Australia Australian Capital Territory     113 3 105 5 -35.4735 149.0124 2020-07-12 04:34:30 Australian Capital Territory, Australia
275205 2020-07-11 Australia New South Wales     3478 49 2988 441 -33.8688 151.2093 2020-07-12 04:34:30 New South Wales, Australia
275217 2020-07-11 Australia Northern Territory     31 0 29 2 -12.4634 130.8456 2020-07-12 04:34:30 Northern Territory, Australia
275266 2020-07-11 Australia Queensland     1070 6 1058 6 -27.4698 153.0251 2020-07-12 04:34:30 Queensland, Australia
275324 2020-07-11 Australia South Australia     443 4 439 0 -34.9285 138.6007 2020-07-12 04:34:30 South Australia, Australia
275337 2020-07-11 Australia Tasmania     228 13 215 0 -42.8821 147.3272 2020-07-12 04:34:30 Tasmania, Australia
275388 2020-07-11 Australia Victoria     3799 24 2289 1486 -37.8136 144.9631 2020-07-12 04:34:30 Victoria, Australia
275399 2020-07-11 Australia Western Australia     635 9 604 22 -31.9505 115.8605 2020-07-12 04:34:30 Western Australia, Australia
9916 2020-07-10 Australia Australian Capital Territory     113 3 105 5 -35.4735 149.0124 2020-07-11 04:34:26 Australian Capital Territory, Australia
10177 2020-07-10 Australia New South Wales     3474 49 2997 428 -33.8688 151.2093 2020-07-11 04:34:26 New South Wales, Australia
10189 2020-07-10 Australia Northern Territory     31 0 29 2 -12.4634 130.8456 2020-07-11 04:34:26 Northern Territory, Australia
10238 2020-07-10 Australia Queensland     1070 6 1058 6 -27.4698 153.0251 2020-07-11 04:34:26 Queensland, Australia
10296 2020-07-10 Australia South Australia     443 4 439 0 -34.9285 138.6007 2020-07-11 04:34:26 South Australia, Australia
10309 2020-07-10 Australia Tasmania     228 13 215 0 -42.8821 147.3272 2020-07-11 04:34:26 Tasmania, Australia
10360 2020-07-10 Australia Victoria     3560 23 2286 1251 -37.8136 144.9631 2020-07-11 04:34:26 Victoria, Australia
10371 2020-07-10 Australia Western Australia     634 9 604 21 -31.9505 115.8605 2020-07-11 04:34:26 Western Australia, Australia
342129 2020-07-09 Australia Australian Capital Territory     113 3 105 5 -35.4735 149.0124 2020-07-10 04:34:24 Australian Capital Territory, Australia
342390 2020-07-09 Australia New South Wales     3467 49 2987 431 -33.8688 151.2093 2020-07-10 04:34:24 New South Wales, Australia
342402 2020-07-09 Australia Northern Territory     31 0 29 2 -12.4634 130.8456 2020-07-10 04:34:24 Northern Territory, Australia
342451 2020-07-09 Australia Queensland     1068 6 1057 5 -27.4698 153.0251 2020-07-10 04:34:24 Queensland, Australia
342509 2020-07-09 Australia South Australia     443 4 439 0 -34.9285 138.6007 2020-07-10 04:34:24 South Australia, Australia
342522 2020-07-09 Australia Tasmania     228 13 215 0 -42.8821 147.3272 2020-07-10 04:34:24 Tasmania, Australia
342573 2020-07-09 Australia Victoria     3397 22 2142 1233 -37.8136 144.9631 2020-07-10 04:34:24 Victoria, Australia
342584 2020-07-09 Australia Western Australia     627 9 602 16 -31.9505 115.8605 2020-07-10 04:34:24 Western Australia, Australia
253860 2020-07-08 Australia Australian Capital Territory     112 3 105 4 -35.4735 149.0124 2020-07-09 04:34:23 Australian Capital Territory, Australia
254121 2020-07-08 Australia New South Wales     3453 49 2986 418 -33.8688 151.2093 2020-07-09 04:34:23 New South Wales, Australia
254133 2020-07-08 Australia Northern Territory     30 0 29 1 -12.4634 130.8456 2020-07-09 04:34:23 Northern Territory, Australia
254182 2020-07-08 Australia Queensland     1068 6 1057 5 -27.4698 153.0251 2020-07-09 04:34:23 Queensland, Australia
254240 2020-07-08 Australia South Australia     443 4 437 2 -34.9285 138.6007 2020-07-09 04:34:23 South Australia, Australia
254253 2020-07-08 Australia Tasmania     228 13 215 0 -42.8821 147.3272 2020-07-09 04:34:23 Tasmania, Australia
254303 2020-07-08 Australia Victoria     3098 22 2142 934 -37.8136 144.9631 2020-07-09 04:34:23 Victoria, Australia
254314 2020-07-08 Australia Western Australia     624 9 602 13 -31.9505 115.8605 2020-07-09 04:34:23 Western Australia, Australia
249979 2020-07-07 Australia Australian Capital Territory     111 3 105 3 -35.4735 149.0124 2020-07-08 05:33:48 Australian Capital Territory, Australia
250240 2020-07-07 Australia New South Wales     3440 49 2986 405 -33.8688 151.2093 2020-07-08 05:33:48 New South Wales, Australia
250252 2020-07-07 Australia Northern Territory     30 0 29 1 -12.4634 130.8456 2020-07-08 05:33:48 Northern Territory, Australia
250301 2020-07-07 Australia Queensland     1068 6 1056 6 -27.4698 153.0251 2020-07-08 05:33:48 Queensland, Australia
250359 2020-07-07 Australia South Australia     443 4 436 3 -34.9285 138.6007 2020-07-08 05:33:48 South Australia, Australia
250372 2020-07-07 Australia Tasmania     228 13 215 0 -42.8821 147.3272 2020-07-08 05:33:48 Tasmania, Australia
250422 2020-07-07 Australia Victoria     2942 22 2058 862 -37.8136 144.9631 2020-07-08 05:33:48 Victoria, Australia
250433 2020-07-07 Australia Western Australia     624 9 602 13 -31.9505 115.8605 2020-07-08 05:33:48 Western Australia, Australia
59755 2020-07-06 Australia Australian Capital Territory     108 3 105 0 -35.4735 149.0124 2020-07-07 04:34:00 Australian Capital Territory, Australia
60016 2020-07-06 Australia New South Wales     3433 49 2987 397 -33.8688 151.2093 2020-07-07 04:34:00 New South Wales, Australia
60028 2020-07-06 Australia Northern Territory     30 0 29 1 -12.4634 130.8456 2020-07-07 04:34:00 Northern Territory, Australia
60077 2020-07-06 Australia Queensland     1068 6 1055 7 -27.4698 153.0251 2020-07-07 04:34:00 Queensland, Australia
60135 2020-07-06 Australia South Australia     443 4 436 3 -34.9285 138.6007 2020-07-07 04:34:00 South Australia, Australia
60148 2020-07-06 Australia Tasmania     228 13 215 0 -42.8821 147.3272 2020-07-07 04:34:00 Tasmania, Australia
60198 2020-07-06 Australia Victoria     2824 22 2028 774 -37.8136 144.9631 2020-07-07 04:34:00 Victoria, Australia
60209 2020-07-06 Australia Western Australia     621 9 600 12 -31.9505 115.8605 2020-07-07 04:34:00 Western Australia, Australia
370243 2020-07-05 Australia Australian Capital Territory     108 3 105 0 -35.4735 149.0124 2020-07-06 04:33:57 Australian Capital Territory, Australia
370504 2020-07-05 Australia New South Wales     3429 49 2988 392 -33.8688 151.2093 2020-07-06 04:33:57 New South Wales, Australia
370516 2020-07-05 Australia Northern Territory     30 0 29 1 -12.4634 130.8456 2020-07-06 04:33:57 Northern Territory, Australia
370565 2020-07-05 Australia Queensland     1067 6 1055 6 -27.4698 153.0251 2020-07-06 04:33:57 Queensland, Australia
370623 2020-07-05 Australia South Australia     443 4 436 3 -34.9285 138.6007 2020-07-06 04:33:57 South Australia, Australia
370636 2020-07-05 Australia Tasmania     228 13 215 0 -42.8821 147.3272 2020-07-06 04:33:57 Tasmania, Australia
370686 2020-07-05 Australia Victoria     2660 22 1992 646 -37.8136 144.9631 2020-07-06 04:33:57 Victoria, Australia
370697 2020-07-05 Australia Western Australia     618 9 600 9 -31.9505 115.8605 2020-07-06 04:33:57 Western Australia, Australia
338325 2020-07-04 Australia Australian Capital Territory     108 3 105 0 -35.4735 149.0124 2020-07-05 04:33:46 Australian Capital Territory, Australia
338586 2020-07-04 Australia New South Wales     3419 49 2988 382 -33.8688 151.2093 2020-07-05 04:33:46 New South Wales, Australia
338598 2020-07-04 Australia Northern Territory     30 0 29 1 -12.4634 130.8456 2020-07-05 04:33:46 Northern Territory, Australia
338647 2020-07-04 Australia Queensland     1067 6 1055 6 -27.4698 153.0251 2020-07-05 04:33:46 Queensland, Australia
338705 2020-07-04 Australia South Australia     443 4 436 3 -34.9285 138.6007 2020-07-05 04:33:46 South Australia, Australia
338718 2020-07-04 Australia Tasmania     228 13 215 0 -42.8821 147.3272 2020-07-05 04:33:46 Tasmania, Australia
338768 2020-07-04 Australia Victoria     2536 20 1971 545 -37.8136 144.9631 2020-07-05 04:33:46 Victoria, Australia
338779 2020-07-04 Australia Western Australia     612 9 600 3 -31.9505 115.8605 2020-07-05 04:33:46 Western Australia, Australia
271135 2020-07-03 Australia Australian Capital Territory     108 3 105 0 -35.4735 149.0124 2020-07-04 04:33:51 Australian Capital Territory, Australia
271396 2020-07-03 Australia New South Wales     3405 49 2977 379 -33.8688 151.2093 2020-07-04 04:33:51 New South Wales, Australia
271408 2020-07-03 Australia Northern Territory     30 0 29 1 -12.4634 130.8456 2020-07-04 04:33:51 Northern Territory, Australia
271457 2020-07-03 Australia Queensland     1067 6 1055 6 -27.4698 153.0251 2020-07-04 04:33:51 Queensland, Australia
271515 2020-07-03 Australia South Australia     443 4 436 3 -34.9285 138.6007 2020-07-04 04:33:51 South Australia, Australia
271528 2020-07-03 Australia Tasmania     228 13 215 0 -42.8821 147.3272 2020-07-04 04:33:51 Tasmania, Australia
271578 2020-07-03 Australia Victoria     2368 20 1904 444 -37.8136 144.9631 2020-07-04 04:33:51 Victoria, Australia
271589 2020-07-03 Australia Western Australia     611 9 598 4 -31.9505 115.8605 2020-07-04 04:33:51 Western Australia, Australia
214907 2020-07-02 Australia Australian Capital Territory     108 3 105 0 -35.4735 149.0124 2020-07-03 04:33:54 Australian Capital Territory, Australia
215168 2020-07-02 Australia New South Wales     3211 49 2789 373 -33.8688 151.2093 2020-07-03 04:33:54 New South Wales, Australia
215180 2020-07-02 Australia Northern Territory     30 0 29 1 -12.4634 130.8456 2020-07-03 04:33:54 Northern Territory, Australia
215229 2020-07-02 Australia Queensland     1067 6 1054 7 -27.4698 153.0251 2020-07-03 04:33:54 Queensland, Australia
215287 2020-07-02 Australia South Australia     443 4 436 3 -34.9285 138.6007 2020-07-03 04:33:54 South Australia, Australia
215300 2020-07-02 Australia Tasmania     228 13 215 0 -42.8821 147.3272 2020-07-03 04:33:54 Tasmania, Australia
215351 2020-07-02 Australia Victoria     2368 20 1904 444 -37.8136 144.9631 2020-07-03 04:33:54 Victoria, Australia
215362 2020-07-02 Australia Western Australia     611 9 598 4 -31.9505 115.8605 2020-07-03 04:33:54 Western Australia, Australia
167333 2020-07-01 Australia Australian Capital Territory     108 3 105 0 -35.4735 149.0124 2020-07-02 04:33:46 Australian Capital Territory, Australia
167594 2020-07-01 Australia New South Wales     3211 49 2787 375 -33.8688 151.2093 2020-07-02 04:33:46 New South Wales, Australia
167606 2020-07-01 Australia Northern Territory     30 0 29 1 -12.4634 130.8456 2020-07-02 04:33:46 Northern Territory, Australia
167655 2020-07-01 Australia Queensland     1067 6 1054 7 -27.4698 153.0251 2020-07-02 04:33:46 Queensland, Australia

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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] INTEGER,
   [latitude] TEXT,
   [longitude] TEXT,
   [last_update] TEXT,
   [combined_key] TEXT
);
Powered by Datasette · Query took 2448.799ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette