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

7,356 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, day (date), last_update (date)

country_or_region 1

  • Australia · 7,356 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
647257 647257 2022-08-18 Australia Australian Capital Territory     199919 117 0   -35.4735 149.0124 2022-08-19 04:20:54 Australian Capital Territory, Australia
647258 647258 2022-08-18 Australia New South Wales     3372497 4646 0   -33.8688 151.2093 2022-08-19 04:20:54 New South Wales, Australia
647259 647259 2022-08-18 Australia Northern Territory     94532 63 0   -12.4634 130.8456 2022-08-19 04:20:54 Northern Territory, Australia
647260 647260 2022-08-18 Australia Queensland     1588222 1825 0   -27.4698 153.0251 2022-08-19 04:20:54 Queensland, Australia
647261 647261 2022-08-18 Australia South Australia     744489 773 0   -34.9285 138.6007 2022-08-19 04:20:54 South Australia, Australia
647262 647262 2022-08-18 Australia Tasmania     242568 174 0   -42.8821 147.3272 2022-08-19 04:20:54 Tasmania, Australia
647263 647263 2022-08-18 Australia Victoria     2531624 5063 0   -37.8136 144.9631 2022-08-19 04:20:54 Victoria, Australia
647264 647264 2022-08-18 Australia Western Australia     1113823 568 0   -31.9505 115.8605 2022-08-19 04:20:54 Western Australia, Australia
2706029 2706029 2022-08-17 Australia Australian Capital Territory     199673 116 0   -35.4735 149.0124 2022-08-18 04:21:11 Australian Capital Territory, Australia
2706030 2706030 2022-08-17 Australia New South Wales     3365632 4624 0   -33.8688 151.2093 2022-08-18 04:21:11 New South Wales, Australia
2706031 2706031 2022-08-17 Australia Northern Territory     94396 60 0   -12.4634 130.8456 2022-08-18 04:21:11 Northern Territory, Australia
2706032 2706032 2022-08-17 Australia Queensland     1585477 1811 0   -27.4698 153.0251 2022-08-18 04:21:11 Queensland, Australia
2706033 2706033 2022-08-17 Australia South Australia     743393 771 0   -34.9285 138.6007 2022-08-18 04:21:11 South Australia, Australia
2706034 2706034 2022-08-17 Australia Tasmania     242172 172 0   -42.8821 147.3272 2022-08-18 04:21:11 Tasmania, Australia
2706035 2706035 2022-08-17 Australia Victoria     2527767 5036 0   -37.8136 144.9631 2022-08-18 04:21:11 Victoria, Australia
2706036 2706036 2022-08-17 Australia Western Australia     1112078 563 0   -31.9505 115.8605 2022-08-18 04:21:11 Western Australia, Australia
2395696 2395696 2022-08-16 Australia Australian Capital Territory     199292 116 0   -35.4735 149.0124 2022-08-17 04:20:59 Australian Capital Territory, Australia
2395697 2395697 2022-08-16 Australia New South Wales     3357506 4581 0   -33.8688 151.2093 2022-08-17 04:20:59 New South Wales, Australia
2395698 2395698 2022-08-16 Australia Northern Territory     94396 59 0   -12.4634 130.8456 2022-08-17 04:20:59 Northern Territory, Australia
2395699 2395699 2022-08-16 Australia Queensland     1582419 1791 0   -27.4698 153.0251 2022-08-17 04:20:59 Queensland, Australia
2395700 2395700 2022-08-16 Australia South Australia     740679 759 0   -34.9285 138.6007 2022-08-17 04:20:59 South Australia, Australia
2395701 2395701 2022-08-16 Australia Tasmania     241732 170 0   -42.8821 147.3272 2022-08-17 04:20:59 Tasmania, Australia
2395702 2395702 2022-08-16 Australia Victoria     2523433 4990 0   -37.8136 144.9631 2022-08-17 04:20:59 Victoria, Australia
2395703 2395703 2022-08-16 Australia Western Australia     1110117 558 0   -31.9505 115.8605 2022-08-17 04:20:59 Western Australia, Australia
2356408 2356408 2022-08-15 Australia Australian Capital Territory     198866 114 0   -35.4735 149.0124 2022-08-16 04:20:58 Australian Capital Territory, Australia
2356409 2356409 2022-08-15 Australia New South Wales     3349487 4555 0   -33.8688 151.2093 2022-08-16 04:20:58 New South Wales, Australia
2356410 2356410 2022-08-15 Australia Northern Territory     94032 59 0   -12.4634 130.8456 2022-08-16 04:20:58 Northern Territory, Australia
2356411 2356411 2022-08-15 Australia Queensland     1579334 1774 0   -27.4698 153.0251 2022-08-16 04:20:58 Queensland, Australia
2356412 2356412 2022-08-15 Australia South Australia     739234 754 0   -34.9285 138.6007 2022-08-16 04:20:58 South Australia, Australia
2356413 2356413 2022-08-15 Australia Tasmania     241256 169 0   -42.8821 147.3272 2022-08-16 04:20:58 Tasmania, Australia
2356414 2356414 2022-08-15 Australia Victoria     2518798 4975 0   -37.8136 144.9631 2022-08-16 04:20:58 Victoria, Australia
2356415 2356415 2022-08-15 Australia Western Australia     1107738 554 0   -31.9505 115.8605 2022-08-16 04:20:58 Western Australia, Australia
1834876 1834876 2022-08-14 Australia Australian Capital Territory     198480 110 0   -35.4735 149.0124 2022-08-15 04:20:59 Australian Capital Territory, Australia
1834877 1834877 2022-08-14 Australia New South Wales     3342373 4531 0   -33.8688 151.2093 2022-08-15 04:20:59 New South Wales, Australia
1834878 1834878 2022-08-14 Australia Northern Territory     94032 59 0   -12.4634 130.8456 2022-08-15 04:20:59 Northern Territory, Australia
1834879 1834879 2022-08-14 Australia Queensland     1576102 1757 0   -27.4698 153.0251 2022-08-15 04:20:59 Queensland, Australia
1834880 1834880 2022-08-14 Australia South Australia     739189 754 0   -34.9285 138.6007 2022-08-15 04:20:59 South Australia, Australia
1834881 1834881 2022-08-14 Australia Tasmania     240744 167 0   -42.8821 147.3272 2022-08-15 04:20:59 Tasmania, Australia
1834882 1834882 2022-08-14 Australia Victoria     2513940 4955 0   -37.8136 144.9631 2022-08-15 04:20:59 Victoria, Australia
1834883 1834883 2022-08-14 Australia Western Australia     1105636 553 0   -31.9505 115.8605 2022-08-15 04:20:59 Western Australia, Australia
1608762 1608762 2022-08-13 Australia Australian Capital Territory     198193 110 0   -35.4735 149.0124 2022-08-14 04:20:55 Australian Capital Territory, Australia
1608763 1608763 2022-08-13 Australia New South Wales     3336902 4525 0   -33.8688 151.2093 2022-08-14 04:20:55 New South Wales, Australia
1608764 1608764 2022-08-13 Australia Northern Territory     93934 59 0   -12.4634 130.8456 2022-08-14 04:20:55 Northern Territory, Australia
1608765 1608765 2022-08-13 Australia Queensland     1574198 1757 0   -27.4698 153.0251 2022-08-14 04:20:55 Queensland, Australia
1608766 1608766 2022-08-13 Australia South Australia     736959 753 0   -34.9285 138.6007 2022-08-14 04:20:55 South Australia, Australia
1608767 1608767 2022-08-13 Australia Tasmania     240346 167 0   -42.8821 147.3272 2022-08-14 04:20:55 Tasmania, Australia
1608768 1608768 2022-08-13 Australia Victoria     2510325 4940 0   -37.8136 144.9631 2022-08-14 04:20:55 Victoria, Australia
1608769 1608769 2022-08-13 Australia Western Australia     1104096 551 0   -31.9505 115.8605 2022-08-14 04:20:55 Western Australia, Australia
997693 997693 2022-08-12 Australia Australian Capital Territory     197883 110 0   -35.4735 149.0124 2022-08-13 04:20:52 Australian Capital Territory, Australia
997694 997694 2022-08-12 Australia New South Wales     3329963 4516 0   -33.8688 151.2093 2022-08-13 04:20:52 New South Wales, Australia
997695 997695 2022-08-12 Australia Northern Territory     93823 59 0   -12.4634 130.8456 2022-08-13 04:20:52 Northern Territory, Australia
997696 997696 2022-08-12 Australia Queensland     1572252 1757 0   -27.4698 153.0251 2022-08-13 04:20:52 Queensland, Australia
997697 997697 2022-08-12 Australia South Australia     735513 745 0   -34.9285 138.6007 2022-08-13 04:20:52 South Australia, Australia
997698 997698 2022-08-12 Australia Tasmania     239977 166 0   -42.8821 147.3272 2022-08-13 04:20:52 Tasmania, Australia
997699 997699 2022-08-12 Australia Victoria     2506892 4916 0   -37.8136 144.9631 2022-08-13 04:20:52 Victoria, Australia
997700 997700 2022-08-12 Australia Western Australia     1102537 551 0   -31.9505 115.8605 2022-08-13 04:20:52 Western Australia, Australia
3320505 3320505 2022-08-11 Australia Australian Capital Territory     197561 109 0   -35.4735 149.0124 2022-08-12 04:20:54 Australian Capital Territory, Australia
3320506 3320506 2022-08-11 Australia New South Wales     3321760 4481 0   -33.8688 151.2093 2022-08-12 04:20:54 New South Wales, Australia
3320507 3320507 2022-08-11 Australia Northern Territory     93660 59 0   -12.4634 130.8456 2022-08-12 04:20:54 Northern Territory, Australia
3320508 3320508 2022-08-11 Australia Queensland     1569096 1741 0   -27.4698 153.0251 2022-08-12 04:20:54 Queensland, Australia
3320509 3320509 2022-08-11 Australia South Australia     735513 745 0   -34.9285 138.6007 2022-08-12 04:20:54 South Australia, Australia
3320510 3320510 2022-08-11 Australia Tasmania     239466 162 0   -42.8821 147.3272 2022-08-12 04:20:54 Tasmania, Australia
3320511 3320511 2022-08-11 Australia Victoria     2502612 4894 0   -37.8136 144.9631 2022-08-12 04:20:54 Victoria, Australia
3320512 3320512 2022-08-11 Australia Western Australia     1100493 548 0   -31.9505 115.8605 2022-08-12 04:20:54 Western Australia, Australia
2698007 2698007 2022-08-10 Australia Australian Capital Territory     197094 108 0   -35.4735 149.0124 2022-08-11 04:20:49 Australian Capital Territory, Australia
2698008 2698008 2022-08-10 Australia New South Wales     3312255 4446 0   -33.8688 151.2093 2022-08-11 04:20:49 New South Wales, Australia
2698009 2698009 2022-08-10 Australia Northern Territory     93315 58 0   -12.4634 130.8456 2022-08-11 04:20:49 Northern Territory, Australia
2698010 2698010 2022-08-10 Australia Queensland     1565788 1723 0   -27.4698 153.0251 2022-08-11 04:20:49 Queensland, Australia
2698011 2698011 2022-08-10 Australia South Australia     732008 732 0   -34.9285 138.6007 2022-08-11 04:20:49 South Australia, Australia
2698012 2698012 2022-08-10 Australia Tasmania     238961 161 0   -42.8821 147.3272 2022-08-11 04:20:49 Tasmania, Australia
2698013 2698013 2022-08-10 Australia Victoria     2492023 4844 0   -37.8136 144.9631 2022-08-11 04:20:49 Victoria, Australia
2698014 2698014 2022-08-10 Australia Western Australia     1098190 545 0   -31.9505 115.8605 2022-08-11 04:20:49 Western Australia, Australia
966404 966404 2022-08-09 Australia Australian Capital Territory     196642 107 0   -35.4735 149.0124 2022-08-10 04:20:57 Australian Capital Territory, Australia
966405 966405 2022-08-09 Australia New South Wales     3301777 4417 0   -33.8688 151.2093 2022-08-10 04:20:57 New South Wales, Australia
966406 966406 2022-08-09 Australia Northern Territory     93124 57 0   -12.4634 130.8456 2022-08-10 04:20:57 Northern Territory, Australia
966407 966407 2022-08-09 Australia Queensland     1562443 1712 0   -27.4698 153.0251 2022-08-10 04:20:57 Queensland, Australia
966408 966408 2022-08-09 Australia South Australia     729945 723 0   -34.9285 138.6007 2022-08-10 04:20:57 South Australia, Australia
966409 966409 2022-08-09 Australia Tasmania     238296 160 0   -42.8821 147.3272 2022-08-10 04:20:57 Tasmania, Australia
966410 966410 2022-08-09 Australia Victoria     2492023 4846 0   -37.8136 144.9631 2022-08-10 04:20:57 Victoria, Australia
966411 966411 2022-08-09 Australia Western Australia     1095467 538 0   -31.9505 115.8605 2022-08-10 04:20:57 Western Australia, Australia
1505699 1505699 2022-08-08 Australia Australian Capital Territory     196098 106 0   -35.4735 149.0124 2022-08-09 04:20:34 Australian Capital Territory, Australia
1505700 1505700 2022-08-08 Australia New South Wales     3290453 4387 0   -33.8688 151.2093 2022-08-09 04:20:34 New South Wales, Australia
1505701 1505701 2022-08-08 Australia Northern Territory     93124 57 0   -12.4634 130.8456 2022-08-09 04:20:34 Northern Territory, Australia
1505702 1505702 2022-08-08 Australia Queensland     1558656 1677 0   -27.4698 153.0251 2022-08-09 04:20:34 Queensland, Australia
1505703 1505703 2022-08-08 Australia South Australia     729945 723 0   -34.9285 138.6007 2022-08-09 04:20:34 South Australia, Australia
1505704 1505704 2022-08-08 Australia Tasmania     237634 159 0   -42.8821 147.3272 2022-08-09 04:20:34 Tasmania, Australia
1505705 1505705 2022-08-08 Australia Victoria     2486176 4795 0   -37.8136 144.9631 2022-08-09 04:20:34 Victoria, Australia
1505706 1505706 2022-08-08 Australia Western Australia     1092607 535 0   -31.9505 115.8605 2022-08-09 04:20:34 Western Australia, Australia
2919273 2919273 2022-08-07 Australia Australian Capital Territory     195621 102 0   -35.4735 149.0124 2022-08-08 04:21:08 Australian Capital Territory, Australia
2919274 2919274 2022-08-07 Australia New South Wales     3280561 4362 0   -33.8688 151.2093 2022-08-08 04:21:08 New South Wales, Australia
2919275 2919275 2022-08-07 Australia Northern Territory     92929 57 0   -12.4634 130.8456 2022-08-08 04:21:08 Northern Territory, Australia
2919276 2919276 2022-08-07 Australia Queensland     1554522 1653 0   -27.4698 153.0251 2022-08-08 04:21:08 Queensland, Australia
2919277 2919277 2022-08-07 Australia South Australia     727990 719 0   -34.9285 138.6007 2022-08-08 04:21:08 South Australia, Australia
2919278 2919278 2022-08-07 Australia Tasmania     236989 156 0   -42.8821 147.3272 2022-08-08 04:21:08 Tasmania, Australia
2919279 2919279 2022-08-07 Australia Victoria     2479796 4751 0   -37.8136 144.9631 2022-08-08 04:21:08 Victoria, Australia
2919280 2919280 2022-08-07 Australia Western Australia     1087681 535 0   -31.9505 115.8605 2022-08-08 04:21:08 Western Australia, Australia
607807 607807 2022-08-06 Australia Australian Capital Territory     195115 101 0   -35.4735 149.0124 2022-08-07 04:20:54 Australian Capital Territory, Australia
607808 607808 2022-08-06 Australia New South Wales     3272928 4358 0   -33.8688 151.2093 2022-08-07 04:20:54 New South Wales, Australia
607809 607809 2022-08-06 Australia Northern Territory     92641 56 0   -12.4634 130.8456 2022-08-07 04:20:54 Northern Territory, Australia
607810 607810 2022-08-06 Australia Queensland     1552018 1653 0   -27.4698 153.0251 2022-08-07 04:20:54 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]);