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

2,764 rows where country_or_region = "Australia" sorted by day descending

✎ View and edit SQL

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

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

country_or_region

  • Australia · 2,764 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
298303 298303 2021-01-21 Australia Australian Capital Territory     118 3 115 0 -35.4735 149.0124 2021-01-22 05:22:10 Australian Capital Territory, Australia
298304 298304 2021-01-21 Australia New South Wales     5083 54 3236 1793 -33.8688 151.2093 2021-01-22 05:22:10 New South Wales, Australia
298305 298305 2021-01-21 Australia Northern Territory     97 0 89 8 -12.4634 130.8456 2021-01-22 05:22:10 Northern Territory, Australia
298306 298306 2021-01-21 Australia Queensland     1303 6 1261 36 -27.4698 153.0251 2021-01-22 05:22:10 Queensland, Australia
298307 298307 2021-01-21 Australia South Australia     596 4 587 5 -34.9285 138.6007 2021-01-22 05:22:10 South Australia, Australia
298308 298308 2021-01-21 Australia Tasmania     234 13 221 0 -42.8821 147.3272 2021-01-22 05:22:10 Tasmania, Australia
298309 298309 2021-01-21 Australia Victoria     20434 820 19583 31 -37.8136 144.9631 2021-01-22 05:22:10 Victoria, Australia
298310 298310 2021-01-21 Australia Western Australia     890 9 869 12 -31.9505 115.8605 2021-01-22 05:22:10 Western Australia, Australia
889355 889355 2021-01-20 Australia Australian Capital Territory     118 3 115 0 -35.4735 149.0124 2021-01-21 05:22:01 Australian Capital Territory, Australia
889356 889356 2021-01-20 Australia New South Wales     5084 54 3236 1794 -33.8688 151.2093 2021-01-21 05:22:01 New South Wales, Australia
889357 889357 2021-01-20 Australia Northern Territory     96 0 87 9 -12.4634 130.8456 2021-01-21 05:22:01 Northern Territory, Australia
889358 889358 2021-01-20 Australia Queensland     1300 6 1261 33 -27.4698 153.0251 2021-01-21 05:22:01 Queensland, Australia
889359 889359 2021-01-20 Australia South Australia     596 4 587 5 -34.9285 138.6007 2021-01-21 05:22:01 South Australia, Australia
889360 889360 2021-01-20 Australia Tasmania     234 13 221 0 -42.8821 147.3272 2021-01-21 05:22:01 Tasmania, Australia
889361 889361 2021-01-20 Australia Victoria     20433 820 19579 34 -37.8136 144.9631 2021-01-21 05:22:01 Victoria, Australia
889362 889362 2021-01-20 Australia Western Australia     888 9 866 13 -31.9505 115.8605 2021-01-21 05:22:01 Western Australia, Australia
317922 317922 2021-01-19 Australia Australian Capital Territory     118 3 115 0 -35.4735 149.0124 2021-01-20 05:21:54 Australian Capital Territory, Australia
317923 317923 2021-01-19 Australia New South Wales     5079 54 3234 1791 -33.8688 151.2093 2021-01-20 05:21:54 New South Wales, Australia
317924 317924 2021-01-19 Australia Northern Territory     95 0 87 8 -12.4634 130.8456 2021-01-20 05:21:54 Northern Territory, Australia
317925 317925 2021-01-19 Australia Queensland     1299 6 1258 35 -27.4698 153.0251 2021-01-20 05:21:54 Queensland, Australia
317926 317926 2021-01-19 Australia South Australia     594 4 584 6 -34.9285 138.6007 2021-01-20 05:21:54 South Australia, Australia
317927 317927 2021-01-19 Australia Tasmania     234 13 221 0 -42.8821 147.3272 2021-01-20 05:21:54 Tasmania, Australia
317928 317928 2021-01-19 Australia Victoria     20433 820 19579 34 -37.8136 144.9631 2021-01-20 05:21:54 Victoria, Australia
317929 317929 2021-01-19 Australia Western Australia     888 9 865 14 -31.9505 115.8605 2021-01-20 05:21:54 Western Australia, Australia
569908 569908 2021-01-18 Australia Australian Capital Territory     118 3 115 0 -35.4735 149.0124 2021-01-19 05:22:15 Australian Capital Territory, Australia
569909 569909 2021-01-18 Australia New South Wales     5076 54 3233 1789 -33.8688 151.2093 2021-01-19 05:22:15 New South Wales, Australia
569910 569910 2021-01-18 Australia Northern Territory     93 0 86 7 -12.4634 130.8456 2021-01-19 05:22:15 Northern Territory, Australia
569911 569911 2021-01-18 Australia Queensland     1297 6 1255 36 -27.4698 153.0251 2021-01-19 05:22:15 Queensland, Australia
569912 569912 2021-01-18 Australia South Australia     593 4 578 11 -34.9285 138.6007 2021-01-19 05:22:15 South Australia, Australia
569913 569913 2021-01-18 Australia Tasmania     234 13 221 0 -42.8821 147.3272 2021-01-19 05:22:15 Tasmania, Australia
569914 569914 2021-01-18 Australia Victoria     20432 820 19578 34 -37.8136 144.9631 2021-01-19 05:22:15 Victoria, Australia
569915 569915 2021-01-18 Australia Western Australia     888 9 865 14 -31.9505 115.8605 2021-01-19 05:22:15 Western Australia, Australia
534471 534471 2021-01-17 Australia Australian Capital Territory     118 3 115 0 -35.4735 149.0124 2021-01-18 05:22:34 Australian Capital Territory, Australia
534472 534472 2021-01-17 Australia New South Wales     5074 54 3229 1791 -33.8688 151.2093 2021-01-18 05:22:34 New South Wales, Australia
534473 534473 2021-01-17 Australia Northern Territory     93 0 84 9 -12.4634 130.8456 2021-01-18 05:22:34 Northern Territory, Australia
534474 534474 2021-01-17 Australia Queensland     1294 6 1254 34 -27.4698 153.0251 2021-01-18 05:22:34 Queensland, Australia
534475 534475 2021-01-17 Australia South Australia     593 4 578 11 -34.9285 138.6007 2021-01-18 05:22:34 South Australia, Australia
534476 534476 2021-01-17 Australia Tasmania     234 13 221 0 -42.8821 147.3272 2021-01-18 05:22:34 Tasmania, Australia
534477 534477 2021-01-17 Australia Victoria     20428 820 19575 33 -37.8136 144.9631 2021-01-18 05:22:34 Victoria, Australia
534478 534478 2021-01-17 Australia Western Australia     887 9 865 13 -31.9505 115.8605 2021-01-18 05:22:34 Western Australia, Australia
615259 615259 2021-01-16 Australia Australian Capital Territory     118 3 115 0 -35.4735 149.0124 2021-01-17 05:22:17 Australian Capital Territory, Australia
615260 615260 2021-01-16 Australia New South Wales     5066 54 3229 1783 -33.8688 151.2093 2021-01-17 05:22:17 New South Wales, Australia
615261 615261 2021-01-16 Australia Northern Territory     93 0 79 14 -12.4634 130.8456 2021-01-17 05:22:17 Northern Territory, Australia
615262 615262 2021-01-16 Australia Queensland     1293 6 1253 34 -27.4698 153.0251 2021-01-17 05:22:17 Queensland, Australia
615263 615263 2021-01-16 Australia South Australia     593 4 578 11 -34.9285 138.6007 2021-01-17 05:22:17 South Australia, Australia
615264 615264 2021-01-16 Australia Tasmania     234 13 221 0 -42.8821 147.3272 2021-01-17 05:22:17 Tasmania, Australia
615265 615265 2021-01-16 Australia Victoria     20424 820 19574 30 -37.8136 144.9631 2021-01-17 05:22:17 Victoria, Australia
615266 615266 2021-01-16 Australia Western Australia     887 9 864 14 -31.9505 115.8605 2021-01-17 05:22:17 Western Australia, Australia
180400 180400 2021-01-15 Australia Australian Capital Territory     118 3 115 0 -35.4735 149.0124 2021-01-16 05:22:40 Australian Capital Territory, Australia
180401 180401 2021-01-15 Australia New South Wales     5057 54 3229 1774 -33.8688 151.2093 2021-01-16 05:22:40 New South Wales, Australia
180402 180402 2021-01-15 Australia Northern Territory     93 0 74 19 -12.4634 130.8456 2021-01-16 05:22:40 Northern Territory, Australia
180403 180403 2021-01-15 Australia Queensland     1291 6 1248 37 -27.4698 153.0251 2021-01-16 05:22:40 Queensland, Australia
180404 180404 2021-01-15 Australia South Australia     593 4 577 12 -34.9285 138.6007 2021-01-16 05:22:40 South Australia, Australia
180405 180405 2021-01-15 Australia Tasmania     234 13 221 0 -42.8821 147.3272 2021-01-16 05:22:40 Tasmania, Australia
180406 180406 2021-01-15 Australia Victoria     20417 820 19571 26 -37.8136 144.9631 2021-01-16 05:22:40 Victoria, Australia
180407 180407 2021-01-15 Australia Western Australia     886 9 862 15 -31.9505 115.8605 2021-01-16 05:22:40 Western Australia, Australia
593092 593092 2021-01-14 Australia Australian Capital Territory     118 3 115 0 -35.4735 149.0124 2021-01-15 05:22:24 Australian Capital Territory, Australia
593093 593093 2021-01-14 Australia New South Wales     5045 54 3227 1764 -33.8688 151.2093 2021-01-15 05:22:24 New South Wales, Australia
593094 593094 2021-01-14 Australia Northern Territory     93 0 74 19 -12.4634 130.8456 2021-01-15 05:22:24 Northern Territory, Australia
593095 593095 2021-01-14 Australia Queensland     1290 6 1247 37 -27.4698 153.0251 2021-01-15 05:22:24 Queensland, Australia
593096 593096 2021-01-14 Australia South Australia     591 4 577 10 -34.9285 138.6007 2021-01-15 05:22:24 South Australia, Australia
593097 593097 2021-01-14 Australia Tasmania     234 13 221 0 -42.8821 147.3272 2021-01-15 05:22:24 Tasmania, Australia
593098 593098 2021-01-14 Australia Victoria     20414 820 19566 28 -37.8136 144.9631 2021-01-15 05:22:24 Victoria, Australia
593099 593099 2021-01-14 Australia Western Australia     884 9 857 18 -31.9505 115.8605 2021-01-15 05:22:24 Western Australia, Australia
724463 724463 2021-01-13 Australia Australian Capital Territory     118 3 115 0 -35.4735 149.0124 2021-01-14 05:22:32 Australian Capital Territory, Australia
724464 724464 2021-01-13 Australia New South Wales     5043 54 3225 1764 -33.8688 151.2093 2021-01-14 05:22:32 New South Wales, Australia
724465 724465 2021-01-13 Australia Northern Territory     93 0 74 19 -12.4634 130.8456 2021-01-14 05:22:32 Northern Territory, Australia
724466 724466 2021-01-13 Australia Queensland     1287 6 1245 36 -27.4698 153.0251 2021-01-14 05:22:32 Queensland, Australia
724467 724467 2021-01-13 Australia South Australia     590 4 575 11 -34.9285 138.6007 2021-01-14 05:22:32 South Australia, Australia
724468 724468 2021-01-13 Australia Tasmania     234 13 221 0 -42.8821 147.3272 2021-01-14 05:22:32 Tasmania, Australia
724469 724469 2021-01-13 Australia Victoria     20414 820 19565 29 -37.8136 144.9631 2021-01-14 05:22:32 Victoria, Australia
724470 724470 2021-01-13 Australia Western Australia     881 9 855 17 -31.9505 115.8605 2021-01-14 05:22:32 Western Australia, Australia
56798 56798 2021-01-12 Australia Australian Capital Territory     118 3 115 0 -35.4735 149.0124 2021-01-13 05:22:15 Australian Capital Territory, Australia
56799 56799 2021-01-12 Australia New South Wales     5041 54 3222 1765 -33.8688 151.2093 2021-01-13 05:22:15 New South Wales, Australia
56800 56800 2021-01-12 Australia Northern Territory     91 0 74 17 -12.4634 130.8456 2021-01-13 05:22:15 Northern Territory, Australia
56801 56801 2021-01-12 Australia Queensland     1283 6 1245 32 -27.4698 153.0251 2021-01-13 05:22:15 Queensland, Australia
56802 56802 2021-01-12 Australia South Australia     590 4 574 12 -34.9285 138.6007 2021-01-13 05:22:15 South Australia, Australia
56803 56803 2021-01-12 Australia Tasmania     234 13 221 0 -42.8821 147.3272 2021-01-13 05:22:15 Tasmania, Australia
56804 56804 2021-01-12 Australia Victoria     20414 820 19559 35 -37.8136 144.9631 2021-01-13 05:22:15 Victoria, Australia
56805 56805 2021-01-12 Australia Western Australia     879 9 855 15 -31.9505 115.8605 2021-01-13 05:22:15 Western Australia, Australia
264999 264999 2021-01-11 Australia Australian Capital Territory     118 3 115 0 -35.4735 149.0124 2021-01-12 05:22:15 Australian Capital Territory, Australia
265000 265000 2021-01-11 Australia New South Wales     5034 54 3216 1764 -33.8688 151.2093 2021-01-12 05:22:15 New South Wales, Australia
265001 265001 2021-01-11 Australia Northern Territory     90 0 71 19 -12.4634 130.8456 2021-01-12 05:22:15 Northern Territory, Australia
265002 265002 2021-01-11 Australia Queensland     1281 6 1243 32 -27.4698 153.0251 2021-01-12 05:22:15 Queensland, Australia
265003 265003 2021-01-11 Australia South Australia     588 4 569 15 -34.9285 138.6007 2021-01-12 05:22:15 South Australia, Australia
265004 265004 2021-01-11 Australia Tasmania     234 13 221 0 -42.8821 147.3272 2021-01-12 05:22:15 Tasmania, Australia
265005 265005 2021-01-11 Australia Victoria     20411 820 19553 38 -37.8136 144.9631 2021-01-12 05:22:15 Victoria, Australia
265006 265006 2021-01-11 Australia Western Australia     878 9 855 14 -31.9505 115.8605 2021-01-12 05:22:15 Western Australia, Australia
780970 780970 2021-01-10 Australia Australian Capital Territory     118 3 115 0 -35.4735 149.0124 2021-01-11 05:21:50 Australian Capital Territory, Australia
780971 780971 2021-01-10 Australia New South Wales     5018 54 3216 1748 -33.8688 151.2093 2021-01-11 05:21:50 New South Wales, Australia
780972 780972 2021-01-10 Australia Northern Territory     90 0 71 19 -12.4634 130.8456 2021-01-11 05:21:50 Northern Territory, Australia
780973 780973 2021-01-10 Australia Queensland     1278 6 1243 29 -27.4698 153.0251 2021-01-11 05:21:50 Queensland, Australia
780974 780974 2021-01-10 Australia South Australia     588 4 569 15 -34.9285 138.6007 2021-01-11 05:21:50 South Australia, Australia
780975 780975 2021-01-10 Australia Tasmania     234 13 221 0 -42.8821 147.3272 2021-01-11 05:21:50 Tasmania, Australia
780976 780976 2021-01-10 Australia Victoria     20411 820 19551 40 -37.8136 144.9631 2021-01-11 05:21:50 Victoria, Australia
780977 780977 2021-01-10 Australia Western Australia     877 9 851 17 -31.9505 115.8605 2021-01-11 05:21:50 Western Australia, Australia
134414 134414 2021-01-09 Australia Australian Capital Territory     118 3 115 0 -35.4735 149.0124 2021-01-10 05:22:12 Australian Capital Territory, Australia
134415 134415 2021-01-09 Australia New South Wales     5007 54 3215 1738 -33.8688 151.2093 2021-01-10 05:22:12 New South Wales, Australia
134416 134416 2021-01-09 Australia Northern Territory     90 0 71 19 -12.4634 130.8456 2021-01-10 05:22:12 Northern Territory, Australia
134417 134417 2021-01-09 Australia Queensland     1274 6 1241 27 -27.4698 153.0251 2021-01-10 05:22:12 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]);