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

8,420 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: longitude, combined_key, day (date), last_update (date)

country_or_region 1

  • Australia · 8,420 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2752583 2752583 2022-12-29 Australia Australian Capital Territory     224902 138 0   -35.4735 149.0124 2022-12-30 04:21:04 Australian Capital Territory, Australia
2752584 2752584 2022-12-29 Australia New South Wales     3825104 5804 0   -33.8688 151.2093 2022-12-30 04:21:04 New South Wales, Australia
2752585 2752585 2022-12-29 Australia Northern Territory     103002 84 0   -12.4634 130.8456 2022-12-30 04:21:04 Northern Territory, Australia
2752586 2752586 2022-12-29 Australia Queensland     1743616 2405 0   -27.4698 153.0251 2022-12-30 04:21:04 Queensland, Australia
2752587 2752587 2022-12-29 Australia South Australia     862043 1155 0   -34.9285 138.6007 2022-12-30 04:21:04 South Australia, Australia
2752588 2752588 2022-12-29 Australia Tasmania     277091 222 0   -42.8821 147.3272 2022-12-30 04:21:04 Tasmania, Australia
2752589 2752589 2022-12-29 Australia Victoria     2833882 6382 0   -37.8136 144.9631 2022-12-30 04:21:04 Victoria, Australia
2752590 2752590 2022-12-29 Australia Western Australia     1255595 837 0   -31.9505 115.8605 2022-12-30 04:21:04 Western Australia, Australia
1073589 1073589 2022-12-28 Australia Australian Capital Territory     224902 138 0   -35.4735 149.0124 2022-12-29 04:21:01 Australian Capital Territory, Australia
1073590 1073590 2022-12-28 Australia New South Wales     3797451 5772 0   -33.8688 151.2093 2022-12-29 04:21:01 New South Wales, Australia
1073591 1073591 2022-12-28 Australia Northern Territory     102787 84 0   -12.4634 130.8456 2022-12-29 04:21:01 Northern Territory, Australia
1073592 1073592 2022-12-28 Australia Queensland     1743616 2405 0   -27.4698 153.0251 2022-12-29 04:21:01 Queensland, Australia
1073593 1073593 2022-12-28 Australia South Australia     853367 1144 0   -34.9285 138.6007 2022-12-29 04:21:01 South Australia, Australia
1073594 1073594 2022-12-28 Australia Tasmania     277091 222 0   -42.8821 147.3272 2022-12-29 04:21:01 Tasmania, Australia
1073595 1073595 2022-12-28 Australia Victoria     2830731 6362 0   -37.8136 144.9631 2022-12-29 04:21:01 Victoria, Australia
1073596 1073596 2022-12-28 Australia Western Australia     1255595 837 0   -31.9505 115.8605 2022-12-29 04:21:01 Western Australia, Australia
327586 327586 2022-12-27 Australia Australian Capital Territory     224902 138 0   -35.4735 149.0124 2022-12-28 04:21:04 Australian Capital Territory, Australia
327587 327587 2022-12-27 Australia New South Wales     3797451 5772 0   -33.8688 151.2093 2022-12-28 04:21:04 New South Wales, Australia
327588 327588 2022-12-27 Australia Northern Territory     102787 84 0   -12.4634 130.8456 2022-12-28 04:21:04 Northern Territory, Australia
327589 327589 2022-12-27 Australia Queensland     1743616 2405 0   -27.4698 153.0251 2022-12-28 04:21:04 Queensland, Australia
327590 327590 2022-12-27 Australia South Australia     853367 1144 0   -34.9285 138.6007 2022-12-28 04:21:04 South Australia, Australia
327591 327591 2022-12-27 Australia Tasmania     277091 222 0   -42.8821 147.3272 2022-12-28 04:21:04 Tasmania, Australia
327592 327592 2022-12-27 Australia Victoria     2827994 6338 0   -37.8136 144.9631 2022-12-28 04:21:04 Victoria, Australia
327593 327593 2022-12-27 Australia Western Australia     1255595 837 0   -31.9505 115.8605 2022-12-28 04:21:04 Western Australia, Australia
217659 217659 2022-12-26 Australia Australian Capital Territory     224902 138 0   -35.4735 149.0124 2022-12-27 04:21:07 Australian Capital Territory, Australia
217660 217660 2022-12-26 Australia New South Wales     3797451 5772 0   -33.8688 151.2093 2022-12-27 04:21:07 New South Wales, Australia
217661 217661 2022-12-26 Australia Northern Territory     102787 84 0   -12.4634 130.8456 2022-12-27 04:21:07 Northern Territory, Australia
217662 217662 2022-12-26 Australia Queensland     1743616 2405 0   -27.4698 153.0251 2022-12-27 04:21:07 Queensland, Australia
217663 217663 2022-12-26 Australia South Australia     853367 1144 0   -34.9285 138.6007 2022-12-27 04:21:07 South Australia, Australia
217664 217664 2022-12-26 Australia Tasmania     277091 222 0   -42.8821 147.3272 2022-12-27 04:21:07 Tasmania, Australia
217665 217665 2022-12-26 Australia Victoria     2825877 6338 0   -37.8136 144.9631 2022-12-27 04:21:07 Victoria, Australia
217666 217666 2022-12-26 Australia Western Australia     1255595 837 0   -31.9505 115.8605 2022-12-27 04:21:07 Western Australia, Australia
3222116 3222116 2022-12-25 Australia Australian Capital Territory     224902 138 0   -35.4735 149.0124 2022-12-26 04:21:06 Australian Capital Territory, Australia
3222117 3222117 2022-12-25 Australia New South Wales     3797451 5772 0   -33.8688 151.2093 2022-12-26 04:21:06 New South Wales, Australia
3222118 3222118 2022-12-25 Australia Northern Territory     102787 84 0   -12.4634 130.8456 2022-12-26 04:21:06 Northern Territory, Australia
3222119 3222119 2022-12-25 Australia Queensland     1743616 2405 0   -27.4698 153.0251 2022-12-26 04:21:06 Queensland, Australia
3222120 3222120 2022-12-25 Australia South Australia     853367 1144 0   -34.9285 138.6007 2022-12-26 04:21:06 South Australia, Australia
3222121 3222121 2022-12-25 Australia Tasmania     277091 222 0   -42.8821 147.3272 2022-12-26 04:21:06 Tasmania, Australia
3222122 3222122 2022-12-25 Australia Victoria     2823987 6338 0   -37.8136 144.9631 2022-12-26 04:21:06 Victoria, Australia
3222123 3222123 2022-12-25 Australia Western Australia     1255595 837 0   -31.9505 115.8605 2022-12-26 04:21:06 Western Australia, Australia
1018030 1018030 2022-12-24 Australia Australian Capital Territory     224902 138 0   -35.4735 149.0124 2022-12-25 04:21:04 Australian Capital Territory, Australia
1018031 1018031 2022-12-24 Australia New South Wales     3797451 5772 0   -33.8688 151.2093 2022-12-25 04:21:04 New South Wales, Australia
1018032 1018032 2022-12-24 Australia Northern Territory     102787 84 0   -12.4634 130.8456 2022-12-25 04:21:04 Northern Territory, Australia
1018033 1018033 2022-12-24 Australia Queensland     1743616 2405 0   -27.4698 153.0251 2022-12-25 04:21:04 Queensland, Australia
1018034 1018034 2022-12-24 Australia South Australia     853367 1144 0   -34.9285 138.6007 2022-12-25 04:21:04 South Australia, Australia
1018035 1018035 2022-12-24 Australia Tasmania     277091 222 0   -42.8821 147.3272 2022-12-25 04:21:04 Tasmania, Australia
1018036 1018036 2022-12-24 Australia Victoria     2822382 6338 0   -37.8136 144.9631 2022-12-25 04:21:04 Victoria, Australia
1018037 1018037 2022-12-24 Australia Western Australia     1255595 837 0   -31.9505 115.8605 2022-12-25 04:21:04 Western Australia, Australia
690053 690053 2022-12-23 Australia Australian Capital Territory     224902 138 0   -35.4735 149.0124 2022-12-24 04:21:02 Australian Capital Territory, Australia
690054 690054 2022-12-23 Australia New South Wales     3797451 5772 0   -33.8688 151.2093 2022-12-24 04:21:02 New South Wales, Australia
690055 690055 2022-12-23 Australia Northern Territory     102787 84 0   -12.4634 130.8456 2022-12-24 04:21:02 Northern Territory, Australia
690056 690056 2022-12-23 Australia Queensland     1743616 2405 0   -27.4698 153.0251 2022-12-24 04:21:02 Queensland, Australia
690057 690057 2022-12-23 Australia South Australia     853367 1144 0   -34.9285 138.6007 2022-12-24 04:21:02 South Australia, Australia
690058 690058 2022-12-23 Australia Tasmania     277091 222 0   -42.8821 147.3272 2022-12-24 04:21:02 Tasmania, Australia
690059 690059 2022-12-23 Australia Victoria     2820140 6338 0   -37.8136 144.9631 2022-12-24 04:21:02 Victoria, Australia
690060 690060 2022-12-23 Australia Western Australia     1255595 837 0   -31.9505 115.8605 2022-12-24 04:21:02 Western Australia, Australia
2179263 2179263 2022-12-22 Australia Australian Capital Territory     224902 138 0   -35.4735 149.0124 2022-12-23 04:21:04 Australian Capital Territory, Australia
2179264 2179264 2022-12-22 Australia New South Wales     3797451 5772 0   -33.8688 151.2093 2022-12-23 04:21:04 New South Wales, Australia
2179265 2179265 2022-12-22 Australia Northern Territory     102787 84 0   -12.4634 130.8456 2022-12-23 04:21:04 Northern Territory, Australia
2179266 2179266 2022-12-22 Australia Queensland     1743616 2405 0   -27.4698 153.0251 2022-12-23 04:21:04 Queensland, Australia
2179267 2179267 2022-12-22 Australia South Australia     853367 1144 0   -34.9285 138.6007 2022-12-23 04:21:04 South Australia, Australia
2179268 2179268 2022-12-22 Australia Tasmania     273019 216 0   -42.8821 147.3272 2022-12-23 04:21:04 Tasmania, Australia
2179269 2179269 2022-12-22 Australia Victoria     2817370 6316 0   -37.8136 144.9631 2022-12-23 04:21:04 Victoria, Australia
2179270 2179270 2022-12-22 Australia Western Australia     1255595 841 0   -31.9505 115.8605 2022-12-23 04:21:04 Western Australia, Australia
451067 451067 2022-12-21 Australia Australian Capital Territory     221718 136 0   -35.4735 149.0124 2022-12-22 04:20:56 Australian Capital Territory, Australia
451068 451068 2022-12-21 Australia New South Wales     3759120 5694 0   -33.8688 151.2093 2022-12-22 04:20:56 New South Wales, Australia
451069 451069 2022-12-21 Australia Northern Territory     102149 84 0   -12.4634 130.8456 2022-12-22 04:20:56 Northern Territory, Australia
451070 451070 2022-12-21 Australia Queensland     1729903 2394 0   -27.4698 153.0251 2022-12-22 04:20:56 Queensland, Australia
451071 451071 2022-12-21 Australia South Australia     842328 1126 0   -34.9285 138.6007 2022-12-22 04:20:56 South Australia, Australia
451072 451072 2022-12-21 Australia Tasmania     273019 216 0   -42.8821 147.3272 2022-12-22 04:20:56 Tasmania, Australia
451073 451073 2022-12-21 Australia Victoria     2813883 6299 0   -37.8136 144.9631 2022-12-22 04:20:56 Victoria, Australia
451074 451074 2022-12-21 Australia Western Australia     1244838 807 0   -31.9505 115.8605 2022-12-22 04:20:56 Western Australia, Australia
2951066 2951066 2022-12-20 Australia Australian Capital Territory     221718 136 0   -35.4735 149.0124 2022-12-21 04:21:03 Australian Capital Territory, Australia
2951067 2951067 2022-12-20 Australia New South Wales     3759120 5694 0   -33.8688 151.2093 2022-12-21 04:21:03 New South Wales, Australia
2951068 2951068 2022-12-20 Australia Northern Territory     102149 84 0   -12.4634 130.8456 2022-12-21 04:21:03 Northern Territory, Australia
2951069 2951069 2022-12-20 Australia Queensland     1729903 2394 0   -27.4698 153.0251 2022-12-21 04:21:03 Queensland, Australia
2951070 2951070 2022-12-20 Australia South Australia     842328 1126 0   -34.9285 138.6007 2022-12-21 04:21:03 South Australia, Australia
2951071 2951071 2022-12-20 Australia Tasmania     273019 216 0   -42.8821 147.3272 2022-12-21 04:21:03 Tasmania, Australia
2951072 2951072 2022-12-20 Australia Victoria     2810305 6277 0   -37.8136 144.9631 2022-12-21 04:21:03 Victoria, Australia
2951073 2951073 2022-12-20 Australia Western Australia     1244838 807 0   -31.9505 115.8605 2022-12-21 04:21:03 Western Australia, Australia
3173468 3173468 2022-12-19 Australia Australian Capital Territory     221718 136 0   -35.4735 149.0124 2022-12-20 04:21:04 Australian Capital Territory, Australia
3173469 3173469 2022-12-19 Australia New South Wales     3759120 5694 0   -33.8688 151.2093 2022-12-20 04:21:04 New South Wales, Australia
3173470 3173470 2022-12-19 Australia Northern Territory     102149 84 0   -12.4634 130.8456 2022-12-20 04:21:04 Northern Territory, Australia
3173471 3173471 2022-12-19 Australia Queensland     1729903 2394 0   -27.4698 153.0251 2022-12-20 04:21:04 Queensland, Australia
3173472 3173472 2022-12-19 Australia South Australia     842328 1126 0   -34.9285 138.6007 2022-12-20 04:21:04 South Australia, Australia
3173473 3173473 2022-12-19 Australia Tasmania     273019 216 0   -42.8821 147.3272 2022-12-20 04:21:04 Tasmania, Australia
3173474 3173474 2022-12-19 Australia Victoria     2806129 6255 0   -37.8136 144.9631 2022-12-20 04:21:04 Victoria, Australia
3173475 3173475 2022-12-19 Australia Western Australia     1244838 807 0   -31.9505 115.8605 2022-12-20 04:21:04 Western Australia, Australia
1627985 1627985 2022-12-18 Australia Australian Capital Territory     221718 136 0   -35.4735 149.0124 2022-12-19 04:21:03 Australian Capital Territory, Australia
1627986 1627986 2022-12-18 Australia New South Wales     3759120 5694 0   -33.8688 151.2093 2022-12-19 04:21:03 New South Wales, Australia
1627987 1627987 2022-12-18 Australia Northern Territory     102149 84 0   -12.4634 130.8456 2022-12-19 04:21:03 Northern Territory, Australia
1627988 1627988 2022-12-18 Australia Queensland     1729903 2394 0   -27.4698 153.0251 2022-12-19 04:21:03 Queensland, Australia
1627989 1627989 2022-12-18 Australia South Australia     842328 1126 0   -34.9285 138.6007 2022-12-19 04:21:03 South Australia, Australia
1627990 1627990 2022-12-18 Australia Tasmania     273019 216 0   -42.8821 147.3272 2022-12-19 04:21:03 Tasmania, Australia
1627991 1627991 2022-12-18 Australia Victoria     2802299 6235 0   -37.8136 144.9631 2022-12-19 04:21:03 Victoria, Australia
1627992 1627992 2022-12-18 Australia Western Australia     1244838 807 0   -31.9505 115.8605 2022-12-19 04:21:03 Western Australia, Australia
503364 503364 2022-12-17 Australia Australian Capital Territory     221718 136 0   -35.4735 149.0124 2022-12-18 04:21:03 Australian Capital Territory, Australia
503365 503365 2022-12-17 Australia New South Wales     3759120 5694 0   -33.8688 151.2093 2022-12-18 04:21:03 New South Wales, Australia
503366 503366 2022-12-17 Australia Northern Territory     102149 84 0   -12.4634 130.8456 2022-12-18 04:21:03 Northern Territory, Australia
503367 503367 2022-12-17 Australia Queensland     1729903 2394 0   -27.4698 153.0251 2022-12-18 04:21:03 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] 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]);