johns_hopkins_csse_daily_reports

Table actions
⚠️ 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

4,964 rows where country_or_region = "Australia" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: latitude, longitude, combined_key, day (date), last_update (date)

country_or_region

  • Australia · 4,964 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
31962 31962 2021-10-23 Australia Australian Capital Territory     1710 11 0   -35.4735 149.0124 2021-10-24 04:21:22 Australian Capital Territory, Australia
31963 31963 2021-10-23 Australia New South Wales     73500 552 0   -33.8688 151.2093 2021-10-24 04:21:22 New South Wales, Australia
31964 31964 2021-10-23 Australia Northern Territory     225 0 0   -12.4634 130.8456 2021-10-24 04:21:22 Northern Territory, Australia
31965 31965 2021-10-23 Australia Queensland     2082 7 0   -27.4698 153.0251 2021-10-24 04:21:22 Queensland, Australia
31966 31966 2021-10-23 Australia South Australia     917 4 0   -34.9285 138.6007 2021-10-24 04:21:22 South Australia, Australia
31967 31967 2021-10-23 Australia Tasmania     237 13 0   -42.8821 147.3272 2021-10-24 04:21:22 Tasmania, Australia
31968 31968 2021-10-23 Australia Victoria     78821 1041 0   -37.8136 144.9631 2021-10-24 04:21:22 Victoria, Australia
31969 31969 2021-10-23 Australia Western Australia     1112 9 0   -31.9505 115.8605 2021-10-24 04:21:22 Western Australia, Australia
312446 312446 2021-10-22 Australia Australian Capital Territory     1701 11 0   -35.4735 149.0124 2021-10-23 04:21:32 Australian Capital Territory, Australia
312447 312447 2021-10-22 Australia New South Wales     73212 548 0   -33.8688 151.2093 2021-10-23 04:21:32 New South Wales, Australia
312448 312448 2021-10-22 Australia Northern Territory     225 0 0   -12.4634 130.8456 2021-10-23 04:21:32 Northern Territory, Australia
312449 312449 2021-10-22 Australia Queensland     2082 7 0   -27.4698 153.0251 2021-10-23 04:21:32 Queensland, Australia
312450 312450 2021-10-22 Australia South Australia     917 4 0   -34.9285 138.6007 2021-10-23 04:21:32 South Australia, Australia
312451 312451 2021-10-22 Australia Tasmania     237 13 0   -42.8821 147.3272 2021-10-23 04:21:32 Tasmania, Australia
312452 312452 2021-10-22 Australia Victoria     76915 1030 0   -37.8136 144.9631 2021-10-23 04:21:32 Victoria, Australia
312453 312453 2021-10-22 Australia Western Australia     1112 9 0   -31.9505 115.8605 2021-10-23 04:21:32 Western Australia, Australia
2134468 2134468 2021-10-21 Australia Australian Capital Territory     1677 11 0   -35.4735 149.0124 2021-10-22 04:21:14 Australian Capital Territory, Australia
2134469 2134469 2021-10-21 Australia New South Wales     72899 546 0   -33.8688 151.2093 2021-10-22 04:21:14 New South Wales, Australia
2134470 2134470 2021-10-21 Australia Northern Territory     225 0 0   -12.4634 130.8456 2021-10-22 04:21:14 Northern Territory, Australia
2134471 2134471 2021-10-21 Australia Queensland     2082 7 0   -27.4698 153.0251 2021-10-22 04:21:14 Queensland, Australia
2134472 2134472 2021-10-21 Australia South Australia     917 4 0   -34.9285 138.6007 2021-10-22 04:21:14 South Australia, Australia
2134473 2134473 2021-10-21 Australia Tasmania     237 13 0   -42.8821 147.3272 2021-10-22 04:21:14 Tasmania, Australia
2134474 2134474 2021-10-21 Australia Victoria     75340 1021 0   -37.8136 144.9631 2021-10-22 04:21:14 Victoria, Australia
2134475 2134475 2021-10-21 Australia Western Australia     1112 9 0   -31.9505 115.8605 2021-10-22 04:21:14 Western Australia, Australia
225787 225787 2021-10-20 Australia Australian Capital Territory     1664 11 0   -35.4735 149.0124 2021-10-21 04:21:18 Australian Capital Territory, Australia
225788 225788 2021-10-20 Australia New South Wales     72560 541 0   -33.8688 151.2093 2021-10-21 04:21:18 New South Wales, Australia
225789 225789 2021-10-20 Australia Northern Territory     225 0 0   -12.4634 130.8456 2021-10-21 04:21:18 Northern Territory, Australia
225790 225790 2021-10-20 Australia Queensland     2077 7 0   -27.4698 153.0251 2021-10-21 04:21:18 Queensland, Australia
225791 225791 2021-10-20 Australia South Australia     916 4 0   -34.9285 138.6007 2021-10-21 04:21:18 South Australia, Australia
225792 225792 2021-10-20 Australia Tasmania     237 13 0   -42.8821 147.3272 2021-10-21 04:21:18 Tasmania, Australia
225793 225793 2021-10-20 Australia Victoria     73151 1005 0   -37.8136 144.9631 2021-10-21 04:21:18 Victoria, Australia
225794 225794 2021-10-20 Australia Western Australia     1112 9 0   -31.9505 115.8605 2021-10-21 04:21:18 Western Australia, Australia
812627 812627 2021-10-19 Australia Australian Capital Territory     1636 11 0   -35.4735 149.0124 2021-10-20 04:21:00 Australian Capital Territory, Australia
812628 812628 2021-10-19 Australia New South Wales     72202 540 0   -33.8688 151.2093 2021-10-20 04:21:00 New South Wales, Australia
812629 812629 2021-10-19 Australia Northern Territory     225 0 0   -12.4634 130.8456 2021-10-20 04:21:00 Northern Territory, Australia
812630 812630 2021-10-19 Australia Queensland     2072 7 0   -27.4698 153.0251 2021-10-20 04:21:00 Queensland, Australia
812631 812631 2021-10-19 Australia South Australia     916 4 0   -34.9285 138.6007 2021-10-20 04:21:00 South Australia, Australia
812632 812632 2021-10-19 Australia Tasmania     237 13 0   -42.8821 147.3272 2021-10-20 04:21:00 Tasmania, Australia
812633 812633 2021-10-19 Australia Victoria     70998 993 0   -37.8136 144.9631 2021-10-20 04:21:00 Victoria, Australia
812634 812634 2021-10-19 Australia Western Australia     1112 9 0   -31.9505 115.8605 2021-10-20 04:21:00 Western Australia, Australia
1913148 1913148 2021-10-18 Australia Australian Capital Territory     1612 11 0   -35.4735 149.0124 2021-10-19 04:20:54 Australian Capital Territory, Australia
1913149 1913149 2021-10-18 Australia New South Wales     71923 533 0   -33.8688 151.2093 2021-10-19 04:20:54 New South Wales, Australia
1913150 1913150 2021-10-18 Australia Northern Territory     225 0 0   -12.4634 130.8456 2021-10-19 04:20:54 Northern Territory, Australia
1913151 1913151 2021-10-18 Australia Queensland     2071 7 0   -27.4698 153.0251 2021-10-19 04:20:54 Queensland, Australia
1913152 1913152 2021-10-18 Australia South Australia     915 4 0   -34.9285 138.6007 2021-10-19 04:20:54 South Australia, Australia
1913153 1913153 2021-10-18 Australia Tasmania     237 13 0   -42.8821 147.3272 2021-10-19 04:20:54 Tasmania, Australia
1913154 1913154 2021-10-18 Australia Victoria     69206 981 0   -37.8136 144.9631 2021-10-19 04:20:54 Victoria, Australia
1913155 1913155 2021-10-18 Australia Western Australia     1112 9 0   -31.9505 115.8605 2021-10-19 04:20:54 Western Australia, Australia
2223778 2223778 2021-10-17 Australia Australian Capital Territory     1588 11 0   -35.4735 149.0124 2021-10-18 04:21:10 Australian Capital Territory, Australia
2223779 2223779 2021-10-17 Australia New South Wales     71658 529 0   -33.8688 151.2093 2021-10-18 04:21:10 New South Wales, Australia
2223780 2223780 2021-10-17 Australia Northern Territory     225 0 0   -12.4634 130.8456 2021-10-18 04:21:10 Northern Territory, Australia
2223781 2223781 2021-10-17 Australia Queensland     2071 7 0   -27.4698 153.0251 2021-10-18 04:21:10 Queensland, Australia
2223782 2223782 2021-10-17 Australia South Australia     915 4 0   -34.9285 138.6007 2021-10-18 04:21:10 South Australia, Australia
2223783 2223783 2021-10-17 Australia Tasmania     237 13 0   -42.8821 147.3272 2021-10-18 04:21:10 Tasmania, Australia
2223784 2223784 2021-10-17 Australia Victoria     67457 970 0   -37.8136 144.9631 2021-10-18 04:21:10 Victoria, Australia
2223785 2223785 2021-10-17 Australia Western Australia     1112 9 0   -31.9505 115.8605 2021-10-18 04:21:10 Western Australia, Australia
1990678 1990678 2021-10-16 Australia Australian Capital Territory     1571 11 0   -35.4735 149.0124 2021-10-17 04:21:29 Australian Capital Territory, Australia
1990679 1990679 2021-10-16 Australia New South Wales     71399 524 0   -33.8688 151.2093 2021-10-17 04:21:29 New South Wales, Australia
1990680 1990680 2021-10-16 Australia Northern Territory     225 0 0   -12.4634 130.8456 2021-10-17 04:21:29 Northern Territory, Australia
1990681 1990681 2021-10-16 Australia Queensland     2071 7 0   -27.4698 153.0251 2021-10-17 04:21:29 Queensland, Australia
1990682 1990682 2021-10-16 Australia South Australia     915 4 0   -34.9285 138.6007 2021-10-17 04:21:29 South Australia, Australia
1990683 1990683 2021-10-16 Australia Tasmania     237 13 0   -42.8821 147.3272 2021-10-17 04:21:29 Tasmania, Australia
1990684 1990684 2021-10-16 Australia Victoria     65674 964 0   -37.8136 144.9631 2021-10-17 04:21:29 Victoria, Australia
1990685 1990685 2021-10-16 Australia Western Australia     1112 9 0   -31.9505 115.8605 2021-10-17 04:21:29 Western Australia, Australia
914812 914812 2021-10-15 Australia Australian Capital Territory     1538 11 0   -35.4735 149.0124 2021-10-16 04:21:15 Australian Capital Territory, Australia
914813 914813 2021-10-15 Australia New South Wales     71099 514 0   -33.8688 151.2093 2021-10-16 04:21:15 New South Wales, Australia
914814 914814 2021-10-15 Australia Northern Territory     224 0 0   -12.4634 130.8456 2021-10-16 04:21:15 Northern Territory, Australia
914815 914815 2021-10-15 Australia Queensland     2071 7 0   -27.4698 153.0251 2021-10-16 04:21:15 Queensland, Australia
914816 914816 2021-10-15 Australia South Australia     914 4 0   -34.9285 138.6007 2021-10-16 04:21:15 South Australia, Australia
914817 914817 2021-10-15 Australia Tasmania     237 13 0   -42.8821 147.3272 2021-10-16 04:21:15 Tasmania, Australia
914818 914818 2021-10-15 Australia Victoria     63836 957 0   -37.8136 144.9631 2021-10-16 04:21:15 Victoria, Australia
914819 914819 2021-10-15 Australia Western Australia     1112 9 0   -31.9505 115.8605 2021-10-16 04:21:15 Western Australia, Australia
2103267 2103267 2021-10-14 Australia Australian Capital Territory     1518 11 0   -35.4735 149.0124 2021-10-15 04:21:26 Australian Capital Territory, Australia
2103268 2103268 2021-10-14 Australia New South Wales     70781 512 0   -33.8688 151.2093 2021-10-15 04:21:26 New South Wales, Australia
2103269 2103269 2021-10-14 Australia Northern Territory     222 0 0   -12.4634 130.8456 2021-10-15 04:21:26 Northern Territory, Australia
2103270 2103270 2021-10-14 Australia Queensland     2068 7 0   -27.4698 153.0251 2021-10-15 04:21:26 Queensland, Australia
2103271 2103271 2021-10-14 Australia South Australia     914 4 0   -34.9285 138.6007 2021-10-15 04:21:26 South Australia, Australia
2103272 2103272 2021-10-14 Australia Tasmania     237 13 0   -42.8821 147.3272 2021-10-15 04:21:26 Tasmania, Australia
2103273 2103273 2021-10-14 Australia Victoria     61869 951 0   -37.8136 144.9631 2021-10-15 04:21:26 Victoria, Australia
2103274 2103274 2021-10-14 Australia Western Australia     1111 9 0   -31.9505 115.8605 2021-10-15 04:21:26 Western Australia, Australia
677641 677641 2021-10-13 Australia Australian Capital Territory     1483 10 0   -35.4735 149.0124 2021-10-14 04:21:29 Australian Capital Territory, Australia
677642 677642 2021-10-13 Australia New South Wales     70391 508 0   -33.8688 151.2093 2021-10-14 04:21:29 New South Wales, Australia
677643 677643 2021-10-13 Australia Northern Territory     222 0 0   -12.4634 130.8456 2021-10-14 04:21:29 Northern Territory, Australia
677644 677644 2021-10-13 Australia Queensland     2067 7 0   -27.4698 153.0251 2021-10-14 04:21:29 Queensland, Australia
677645 677645 2021-10-13 Australia South Australia     914 4 0   -34.9285 138.6007 2021-10-14 04:21:29 South Australia, Australia
677646 677646 2021-10-13 Australia Tasmania     237 13 0   -42.8821 147.3272 2021-10-14 04:21:29 Tasmania, Australia
677647 677647 2021-10-13 Australia Victoria     59763 945 0   -37.8136 144.9631 2021-10-14 04:21:29 Victoria, Australia
677648 677648 2021-10-13 Australia Western Australia     1111 9 0   -31.9505 115.8605 2021-10-14 04:21:29 Western Australia, Australia
614752 614752 2021-10-12 Australia Australian Capital Territory     1437 9 0   -35.4735 149.0124 2021-10-13 04:20:51 Australian Capital Territory, Australia
614753 614753 2021-10-12 Australia New South Wales     69993 502 0   -33.8688 151.2093 2021-10-13 04:20:51 New South Wales, Australia
614754 614754 2021-10-12 Australia Northern Territory     216 0 0   -12.4634 130.8456 2021-10-13 04:20:51 Northern Territory, Australia
614755 614755 2021-10-12 Australia Queensland     2067 7 0   -27.4698 153.0251 2021-10-13 04:20:51 Queensland, Australia
614756 614756 2021-10-12 Australia South Australia     914 4 0   -34.9285 138.6007 2021-10-13 04:20:51 South Australia, Australia
614757 614757 2021-10-12 Australia Tasmania     236 13 0   -42.8821 147.3272 2021-10-13 04:20:51 Tasmania, Australia
614758 614758 2021-10-12 Australia Victoria     57470 934 0   -37.8136 144.9631 2021-10-13 04:20:51 Victoria, Australia
614759 614759 2021-10-12 Australia Western Australia     1111 9 0   -31.9505 115.8605 2021-10-13 04:20:51 Western Australia, Australia
97254 97254 2021-10-11 Australia Australian Capital Territory     1386 9 0   -35.4735 149.0124 2021-10-12 04:21:09 Australian Capital Territory, Australia
97255 97255 2021-10-11 Australia New South Wales     69552 498 0   -33.8688 151.2093 2021-10-12 04:21:09 New South Wales, Australia
97256 97256 2021-10-11 Australia Northern Territory     215 0 0   -12.4634 130.8456 2021-10-12 04:21:09 Northern Territory, Australia
97257 97257 2021-10-11 Australia Queensland     2067 7 0   -27.4698 153.0251 2021-10-12 04:21:09 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
);
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]);