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

3,100 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 · 3,100 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
900377 900377 2021-03-04 Australia Australian Capital Territory     120 3 115 2 -35.4735 149.0124 2021-03-05 05:26:29 Australian Capital Territory, Australia
900378 900378 2021-03-04 Australia New South Wales     5205 54 0 5151 -33.8688 151.2093 2021-03-05 05:26:29 New South Wales, Australia
900379 900379 2021-03-04 Australia Northern Territory     105 0 104 1 -12.4634 130.8456 2021-03-05 05:26:29 Northern Territory, Australia
900380 900380 2021-03-04 Australia Queensland     1344 6 1316 22 -27.4698 153.0251 2021-03-05 05:26:29 Queensland, Australia
900381 900381 2021-03-04 Australia South Australia     618 4 610 4 -34.9285 138.6007 2021-03-05 05:26:29 South Australia, Australia
900382 900382 2021-03-04 Australia Tasmania     234 13 221 0 -42.8821 147.3272 2021-03-05 05:26:29 Tasmania, Australia
900383 900383 2021-03-04 Australia Victoria     20481 820 19656 5 -37.8136 144.9631 2021-03-05 05:26:29 Victoria, Australia
900384 900384 2021-03-04 Australia Western Australia     914 9 902 3 -31.9505 115.8605 2021-03-05 05:26:29 Western Australia, Australia
908102 908102 2021-03-03 Australia Australian Capital Territory     120 3 115 2 -35.4735 149.0124 2021-03-04 05:24:24 Australian Capital Territory, Australia
908103 908103 2021-03-03 Australia New South Wales     5193 54 0 5139 -33.8688 151.2093 2021-03-04 05:24:24 New South Wales, Australia
908104 908104 2021-03-03 Australia Northern Territory     105 0 104 1 -12.4634 130.8456 2021-03-04 05:24:24 Northern Territory, Australia
908105 908105 2021-03-03 Australia Queensland     1342 6 1314 22 -27.4698 153.0251 2021-03-04 05:24:24 Queensland, Australia
908106 908106 2021-03-03 Australia South Australia     618 4 610 4 -34.9285 138.6007 2021-03-04 05:24:24 South Australia, Australia
908107 908107 2021-03-03 Australia Tasmania     234 13 221 0 -42.8821 147.3272 2021-03-04 05:24:24 Tasmania, Australia
908108 908108 2021-03-03 Australia Victoria     20481 820 19654 7 -37.8136 144.9631 2021-03-04 05:24:24 Victoria, Australia
908109 908109 2021-03-03 Australia Western Australia     914 9 902 3 -31.9505 115.8605 2021-03-04 05:24:24 Western Australia, Australia
66502 66502 2021-03-02 Australia Australian Capital Territory     120 3 115 2 -35.4735 149.0124 2021-03-03 05:23:28 Australian Capital Territory, Australia
66503 66503 2021-03-02 Australia New South Wales     5189 54 0 5135 -33.8688 151.2093 2021-03-03 05:23:28 New South Wales, Australia
66504 66504 2021-03-02 Australia Northern Territory     105 0 103 2 -12.4634 130.8456 2021-03-03 05:23:28 Northern Territory, Australia
66505 66505 2021-03-02 Australia Queensland     1335 6 1314 15 -27.4698 153.0251 2021-03-03 05:23:28 Queensland, Australia
66506 66506 2021-03-02 Australia South Australia     618 4 610 4 -34.9285 138.6007 2021-03-03 05:23:28 South Australia, Australia
66507 66507 2021-03-02 Australia Tasmania     234 13 221 0 -42.8821 147.3272 2021-03-03 05:23:28 Tasmania, Australia
66508 66508 2021-03-02 Australia Victoria     20481 820 19653 8 -37.8136 144.9631 2021-03-03 05:23:28 Victoria, Australia
66509 66509 2021-03-02 Australia Western Australia     914 9 901 4 -31.9505 115.8605 2021-03-03 05:23:28 Western Australia, Australia
1295061 1295061 2021-03-01 Australia Australian Capital Territory     118 3 115 0 -35.4735 149.0124 2021-03-02 05:23:30 Australian Capital Territory, Australia
1295062 1295062 2021-03-01 Australia New South Wales     5183 54 0 5129 -33.8688 151.2093 2021-03-02 05:23:30 New South Wales, Australia
1295063 1295063 2021-03-01 Australia Northern Territory     105 0 103 2 -12.4634 130.8456 2021-03-02 05:23:30 Northern Territory, Australia
1295064 1295064 2021-03-01 Australia Queensland     1335 6 1313 16 -27.4698 153.0251 2021-03-02 05:23:30 Queensland, Australia
1295065 1295065 2021-03-01 Australia South Australia     617 4 610 3 -34.9285 138.6007 2021-03-02 05:23:30 South Australia, Australia
1295066 1295066 2021-03-01 Australia Tasmania     234 13 221 0 -42.8821 147.3272 2021-03-02 05:23:30 Tasmania, Australia
1295067 1295067 2021-03-01 Australia Victoria     20481 820 19651 10 -37.8136 144.9631 2021-03-02 05:23:30 Victoria, Australia
1295068 1295068 2021-03-01 Australia Western Australia     913 9 901 3 -31.9505 115.8605 2021-03-02 05:23:30 Western Australia, Australia
579495 579495 2021-02-28 Australia Australian Capital Territory     118 3 115 0 -35.4735 149.0124 2021-03-01 05:23:01 Australian Capital Territory, Australia
579496 579496 2021-02-28 Australia New South Wales     5180 54 0 5126 -33.8688 151.2093 2021-03-01 05:23:01 New South Wales, Australia
579497 579497 2021-02-28 Australia Northern Territory     105 0 103 2 -12.4634 130.8456 2021-03-01 05:23:01 Northern Territory, Australia
579498 579498 2021-02-28 Australia Queensland     1331 6 1313 12 -27.4698 153.0251 2021-03-01 05:23:01 Queensland, Australia
579499 579499 2021-02-28 Australia South Australia     616 4 606 6 -34.9285 138.6007 2021-03-01 05:23:01 South Australia, Australia
579500 579500 2021-02-28 Australia Tasmania     234 13 221 0 -42.8821 147.3272 2021-03-01 05:23:01 Tasmania, Australia
579501 579501 2021-02-28 Australia Victoria     20481 820 19650 11 -37.8136 144.9631 2021-03-01 05:23:01 Victoria, Australia
579502 579502 2021-02-28 Australia Western Australia     913 9 901 3 -31.9505 115.8605 2021-03-01 05:23:01 Western Australia, Australia
680221 680221 2021-02-27 Australia Australian Capital Territory     118 3 115 0 -35.4735 149.0124 2021-02-28 05:22:20 Australian Capital Territory, Australia
680222 680222 2021-02-27 Australia New South Wales     5177 54 0 5123 -33.8688 151.2093 2021-02-28 05:22:20 New South Wales, Australia
680223 680223 2021-02-27 Australia Northern Territory     105 0 103 2 -12.4634 130.8456 2021-02-28 05:22:20 Northern Territory, Australia
680224 680224 2021-02-27 Australia Queensland     1329 6 1311 12 -27.4698 153.0251 2021-02-28 05:22:20 Queensland, Australia
680225 680225 2021-02-27 Australia South Australia     613 4 606 3 -34.9285 138.6007 2021-02-28 05:22:20 South Australia, Australia
680226 680226 2021-02-27 Australia Tasmania     234 13 221 0 -42.8821 147.3272 2021-02-28 05:22:20 Tasmania, Australia
680227 680227 2021-02-27 Australia Victoria     20481 820 19646 15 -37.8136 144.9631 2021-02-28 05:22:20 Victoria, Australia
680228 680228 2021-02-27 Australia Western Australia     913 9 901 3 -31.9505 115.8605 2021-02-28 05:22:20 Western Australia, Australia
873249 873249 2021-02-26 Australia Australian Capital Territory     118 3 115 0 -35.4735 149.0124 2021-02-27 05:22:28 Australian Capital Territory, Australia
873250 873250 2021-02-26 Australia New South Wales     5172 54 0 5118 -33.8688 151.2093 2021-02-27 05:22:28 New South Wales, Australia
873251 873251 2021-02-26 Australia Northern Territory     105 0 103 2 -12.4634 130.8456 2021-02-27 05:22:28 Northern Territory, Australia
873252 873252 2021-02-26 Australia Queensland     1329 6 1310 13 -27.4698 153.0251 2021-02-27 05:22:28 Queensland, Australia
873253 873253 2021-02-26 Australia South Australia     613 4 606 3 -34.9285 138.6007 2021-02-27 05:22:28 South Australia, Australia
873254 873254 2021-02-26 Australia Tasmania     234 13 221 0 -42.8821 147.3272 2021-02-27 05:22:28 Tasmania, Australia
873255 873255 2021-02-26 Australia Victoria     20481 820 19646 15 -37.8136 144.9631 2021-02-27 05:22:28 Victoria, Australia
873256 873256 2021-02-26 Australia Western Australia     913 9 901 3 -31.9505 115.8605 2021-02-27 05:22:28 Western Australia, Australia
387904 387904 2021-02-25 Australia Australian Capital Territory     118 3 115 0 -35.4735 149.0124 2021-02-26 05:22:40 Australian Capital Territory, Australia
387905 387905 2021-02-25 Australia New South Wales     5166 54 0 5112 -33.8688 151.2093 2021-02-26 05:22:40 New South Wales, Australia
387906 387906 2021-02-25 Australia Northern Territory     104 0 103 1 -12.4634 130.8456 2021-02-26 05:22:40 Northern Territory, Australia
387907 387907 2021-02-25 Australia Queensland     1328 6 1310 12 -27.4698 153.0251 2021-02-26 05:22:40 Queensland, Australia
387908 387908 2021-02-25 Australia South Australia     613 4 606 3 -34.9285 138.6007 2021-02-26 05:22:40 South Australia, Australia
387909 387909 2021-02-25 Australia Tasmania     234 13 221 0 -42.8821 147.3272 2021-02-26 05:22:40 Tasmania, Australia
387910 387910 2021-02-25 Australia Victoria     20481 820 19644 17 -37.8136 144.9631 2021-02-26 05:22:40 Victoria, Australia
387911 387911 2021-02-25 Australia Western Australia     913 9 901 3 -31.9505 115.8605 2021-02-26 05:22:40 Western Australia, Australia
454335 454335 2021-02-24 Australia Australian Capital Territory     118 3 115 0 -35.4735 149.0124 2021-02-25 05:24:57 Australian Capital Territory, Australia
454336 454336 2021-02-24 Australia New South Wales     5162 54 0 5108 -33.8688 151.2093 2021-02-25 05:24:57 New South Wales, Australia
454337 454337 2021-02-24 Australia Northern Territory     104 0 102 2 -12.4634 130.8456 2021-02-25 05:24:57 Northern Territory, Australia
454338 454338 2021-02-24 Australia Queensland     1324 6 1309 9 -27.4698 153.0251 2021-02-25 05:24:57 Queensland, Australia
454339 454339 2021-02-24 Australia South Australia     613 4 606 3 -34.9285 138.6007 2021-02-25 05:24:57 South Australia, Australia
454340 454340 2021-02-24 Australia Tasmania     234 13 221 0 -42.8821 147.3272 2021-02-25 05:24:57 Tasmania, Australia
454341 454341 2021-02-24 Australia Victoria     20479 820 19643 16 -37.8136 144.9631 2021-02-25 05:24:57 Victoria, Australia
454342 454342 2021-02-24 Australia Western Australia     913 9 901 3 -31.9505 115.8605 2021-02-25 05:24:57 Western Australia, Australia
1059498 1059498 2021-02-23 Australia Australian Capital Territory     118 3 115 0 -35.4735 149.0124 2021-02-24 05:29:16 Australian Capital Territory, Australia
1059499 1059499 2021-02-23 Australia New South Wales     5155 54 0 5101 -33.8688 151.2093 2021-02-24 05:29:16 New South Wales, Australia
1059500 1059500 2021-02-23 Australia Northern Territory     104 0 102 2 -12.4634 130.8456 2021-02-24 05:29:16 Northern Territory, Australia
1059501 1059501 2021-02-23 Australia Queensland     1323 6 1309 8 -27.4698 153.0251 2021-02-24 05:29:16 Queensland, Australia
1059502 1059502 2021-02-23 Australia South Australia     613 4 605 4 -34.9285 138.6007 2021-02-24 05:29:16 South Australia, Australia
1059503 1059503 2021-02-23 Australia Tasmania     234 13 221 0 -42.8821 147.3272 2021-02-24 05:29:16 Tasmania, Australia
1059504 1059504 2021-02-23 Australia Victoria     20479 820 19639 20 -37.8136 144.9631 2021-02-24 05:29:16 Victoria, Australia
1059505 1059505 2021-02-23 Australia Western Australia     913 9 901 3 -31.9505 115.8605 2021-02-24 05:29:16 Western Australia, Australia
1236505 1236505 2021-02-22 Australia Australian Capital Territory     118 3 115 0 -35.4735 149.0124 2021-02-23 05:23:41 Australian Capital Territory, Australia
1236506 1236506 2021-02-22 Australia New South Wales     5154 54 0 5100 -33.8688 151.2093 2021-02-23 05:23:41 New South Wales, Australia
1236507 1236507 2021-02-22 Australia Northern Territory     104 0 101 3 -12.4634 130.8456 2021-02-23 05:23:41 Northern Territory, Australia
1236508 1236508 2021-02-22 Australia Queensland     1323 6 1309 8 -27.4698 153.0251 2021-02-23 05:23:41 Queensland, Australia
1236509 1236509 2021-02-22 Australia South Australia     612 4 604 4 -34.9285 138.6007 2021-02-23 05:23:41 South Australia, Australia
1236510 1236510 2021-02-22 Australia Tasmania     234 13 221 0 -42.8821 147.3272 2021-02-23 05:23:41 Tasmania, Australia
1236511 1236511 2021-02-22 Australia Victoria     20479 820 19634 25 -37.8136 144.9631 2021-02-23 05:23:41 Victoria, Australia
1236512 1236512 2021-02-22 Australia Western Australia     913 9 901 3 -31.9505 115.8605 2021-02-23 05:23:41 Western Australia, Australia
1248443 1248443 2021-02-21 Australia Australian Capital Territory     118 3 115 0 -35.4735 149.0124 2021-02-22 05:24:21 Australian Capital Territory, Australia
1248444 1248444 2021-02-21 Australia New South Wales     5150 54 0 5096 -33.8688 151.2093 2021-02-22 05:24:21 New South Wales, Australia
1248445 1248445 2021-02-21 Australia Northern Territory     104 0 101 3 -12.4634 130.8456 2021-02-22 05:24:21 Northern Territory, Australia
1248446 1248446 2021-02-21 Australia Queensland     1323 6 1309 8 -27.4698 153.0251 2021-02-22 05:24:21 Queensland, Australia
1248447 1248447 2021-02-21 Australia South Australia     610 4 603 3 -34.9285 138.6007 2021-02-22 05:24:21 South Australia, Australia
1248448 1248448 2021-02-21 Australia Tasmania     234 13 221 0 -42.8821 147.3272 2021-02-22 05:24:21 Tasmania, Australia
1248449 1248449 2021-02-21 Australia Victoria     20479 820 19634 25 -37.8136 144.9631 2021-02-22 05:24:21 Victoria, Australia
1248450 1248450 2021-02-21 Australia Western Australia     912 9 899 4 -31.9505 115.8605 2021-02-22 05:24:21 Western Australia, Australia
599417 599417 2021-02-20 Australia Australian Capital Territory     118 3 115 0 -35.4735 149.0124 2021-02-21 05:24:33 Australian Capital Territory, Australia
599418 599418 2021-02-20 Australia New South Wales     5149 54 0 5095 -33.8688 151.2093 2021-02-21 05:24:33 New South Wales, Australia
599419 599419 2021-02-20 Australia Northern Territory     104 0 101 3 -12.4634 130.8456 2021-02-21 05:24:33 Northern Territory, Australia
599420 599420 2021-02-20 Australia Queensland     1321 6 1309 6 -27.4698 153.0251 2021-02-21 05:24:33 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]);