johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,035 rows where country_or_region = "Australia" and province_or_state = "Western Australia" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2728720 | 2728720 | 2020-09-15 | Australia | Western Australia | 659 | 9 | 646 | 4 | -31.9505 | 115.8605 | 2020-09-16 04:22:53 | Western Australia, Australia | ||
343992 | 343992 | 2020-09-14 | Australia | Western Australia | 659 | 9 | 646 | 4 | -31.9505 | 115.8605 | 2020-09-15 03:22:50 | Western Australia, Australia | ||
2868431 | 2868431 | 2020-09-13 | Australia | Western Australia | 659 | 9 | 646 | 4 | -31.9505 | 115.8605 | 2020-09-14 04:26:00 | Western Australia, Australia | ||
546470 | 546470 | 2020-09-12 | Australia | Western Australia | 659 | 9 | 646 | 4 | -31.9505 | 115.8605 | 2020-09-13 04:30:52 | Western Australia, Australia | ||
1444299 | 1444299 | 2020-09-11 | Australia | Western Australia | 659 | 9 | 646 | 4 | -31.9505 | 115.8605 | 2020-09-12 04:25:05 | Western Australia, Australia | ||
1172900 | 1172900 | 2020-09-10 | Australia | Western Australia | 659 | 9 | 646 | 4 | -31.9505 | 115.8605 | 2020-09-11 04:46:23 | Western Australia, Australia | ||
2171265 | 2171265 | 2020-09-09 | Australia | Western Australia | 659 | 9 | 646 | 4 | -31.9505 | 115.8605 | 2020-09-10 04:29:01 | Western Australia, Australia | ||
1243474 | 1243474 | 2020-09-08 | Australia | Western Australia | 658 | 9 | 644 | 5 | -31.9505 | 115.8605 | 2020-09-09 04:28:48 | Western Australia, Australia | ||
427053 | 427053 | 2020-09-07 | Australia | Western Australia | 658 | 9 | 644 | 5 | -31.9505 | 115.8605 | 2020-09-08 04:28:25 | Western Australia, Australia | ||
3161338 | 3161338 | 2020-09-06 | Australia | Western Australia | 656 | 9 | 644 | 3 | -31.9505 | 115.8605 | 2020-09-07 04:28:30 | Western Australia, Australia | ||
813293 | 813293 | 2020-09-05 | Australia | Western Australia | 655 | 9 | 644 | 2 | -31.9505 | 115.8605 | 2020-09-06 04:28:33 | Western Australia, Australia | ||
2661493 | 2661493 | 2020-09-04 | Australia | Western Australia | 655 | 9 | 644 | 2 | -31.9505 | 115.8605 | 2020-09-05 04:28:19 | Western Australia, Australia | ||
1354033 | 1354033 | 2020-09-03 | Australia | Western Australia | 655 | 9 | 643 | 3 | -31.9505 | 115.8605 | 2020-09-04 04:28:26 | Western Australia, Australia | ||
1105270 | 1105270 | 2020-09-02 | Australia | Western Australia | 655 | 9 | 641 | 5 | -31.9505 | 115.8605 | 2020-09-03 04:28:22 | Western Australia, Australia | ||
2059599 | 2059599 | 2020-09-01 | Australia | Western Australia | 655 | 9 | 641 | 5 | -31.9505 | 115.8605 | 2020-09-02 04:28:25 | Western Australia, Australia | ||
193784 | 193784 | 2020-08-31 | Australia | Western Australia | 655 | 9 | 641 | 5 | -31.9505 | 115.8605 | 2020-09-01 04:28:31 | Western Australia, Australia | ||
3931743 | 3931743 | 2020-08-30 | Australia | Western Australia | 655 | 9 | 641 | 5 | -31.9505 | 115.8605 | 2020-08-31 04:28:27 | Western Australia, Australia | ||
609405 | 609405 | 2020-08-29 | Australia | Western Australia | 655 | 9 | 641 | 5 | -31.9505 | 115.8605 | 2020-08-30 04:28:22 | Western Australia, Australia | ||
1522900 | 1522900 | 2020-08-28 | Australia | Western Australia | 655 | 9 | 637 | 9 | -31.9505 | 115.8605 | 2020-08-29 04:28:19 | Western Australia, Australia | ||
2509901 | 2509901 | 2020-08-27 | Australia | Western Australia | 655 | 9 | 637 | 9 | -31.9505 | 115.8605 | 2020-08-28 04:28:11 | Western Australia, Australia | ||
1996361 | 1996361 | 2020-08-26 | Australia | Western Australia | 653 | 9 | 637 | 7 | -31.9505 | 115.8605 | 2020-08-27 04:28:15 | Western Australia, Australia | ||
3562285 | 3562285 | 2020-08-25 | Australia | Western Australia | 653 | 9 | 636 | 8 | -31.9505 | 115.8605 | 2020-08-26 04:28:11 | Western Australia, Australia | ||
2990989 | 2990989 | 2020-08-24 | Australia | Western Australia | 653 | 9 | 635 | 9 | -31.9505 | 115.8605 | 2020-08-25 04:28:02 | Western Australia, Australia | ||
2215384 | 2215384 | 2020-08-23 | Australia | Western Australia | 652 | 9 | 634 | 9 | -31.9505 | 115.8605 | 2020-08-24 04:27:56 | Western Australia, Australia | ||
2299166 | 2299166 | 2020-08-22 | Australia | Western Australia | 652 | 9 | 634 | 9 | -31.9505 | 115.8605 | 2020-08-23 04:27:48 | Western Australia, Australia | ||
1479273 | 1479273 | 2020-08-21 | Australia | Western Australia | 651 | 9 | 633 | 9 | -31.9505 | 115.8605 | 2020-08-22 04:27:49 | Western Australia, Australia | ||
3484022 | 3484022 | 2020-08-20 | Australia | Western Australia | 651 | 9 | 633 | 9 | -31.9505 | 115.8605 | 2020-08-21 04:27:41 | Western Australia, Australia | ||
205971 | 205971 | 2020-08-19 | Australia | Western Australia | 651 | 9 | 633 | 9 | -31.9505 | 115.8605 | 2020-08-20 04:27:43 | Western Australia, Australia | ||
3177725 | 3177725 | 2020-08-18 | Australia | Western Australia | 647 | 9 | 633 | 5 | -31.9505 | 115.8605 | 2020-08-19 04:27:00 | Western Australia, Australia | ||
837329 | 837329 | 2020-08-17 | Australia | Western Australia | 647 | 9 | 633 | 5 | -31.9505 | 115.8605 | 2020-08-18 04:27:56 | Western Australia, Australia | ||
1555687 | 1555687 | 2020-08-16 | Australia | Western Australia | 646 | 9 | 633 | 4 | -31.9505 | 115.8605 | 2020-08-17 04:27:20 | Western Australia, Australia | ||
145689 | 145689 | 2020-08-15 | Australia | Western Australia | 646 | 9 | 633 | 4 | -31.9505 | 115.8605 | 2020-08-16 04:27:42 | Western Australia, Australia | ||
1611964 | 1611964 | 2020-08-14 | Australia | Western Australia | 646 | 9 | 632 | 5 | -31.9505 | 115.8605 | 2020-08-15 04:27:31 | Western Australia, Australia | ||
582548 | 582548 | 2020-08-13 | Australia | Western Australia | 645 | 9 | 632 | 4 | -31.9505 | 115.8605 | 2020-08-14 04:51:19 | Western Australia, Australia | ||
3531167 | 3531167 | 2020-08-12 | Australia | Western Australia | 644 | 9 | 632 | 3 | -31.9505 | 115.8605 | 2020-08-13 04:29:15 | Western Australia, Australia | ||
662016 | 662016 | 2020-08-11 | Australia | Western Australia | 642 | 9 | 632 | 1 | -31.9505 | 115.8605 | 2020-08-12 04:27:29 | Western Australia, Australia | ||
1920664 | 1920664 | 2020-08-10 | Australia | Western Australia | 642 | 9 | 630 | 3 | -31.9505 | 115.8605 | 2020-08-11 04:35:08 | Western Australia, Australia | ||
3923473 | 3923473 | 2020-08-09 | Australia | Western Australia | 642 | 9 | 629 | 4 | -31.9505 | 115.8605 | 2020-08-10 04:34:55 | Western Australia, Australia | ||
371641 | 371641 | 2020-08-08 | Australia | Western Australia | 642 | 9 | 629 | 4 | -31.9505 | 115.8605 | 2020-08-09 04:34:54 | Western Australia, Australia | ||
458825 | 458825 | 2020-08-07 | Australia | Western Australia | 642 | 9 | 628 | 5 | -31.9505 | 115.8605 | 2020-08-08 04:34:53 | Western Australia, Australia | ||
3612510 | 3612510 | 2020-08-06 | Australia | Western Australia | 642 | 9 | 627 | 6 | -31.9505 | 115.8605 | 2020-08-07 04:35:11 | Western Australia, Australia | ||
3793340 | 3793340 | 2020-08-05 | Australia | Western Australia | 670 | 9 | 654 | 7 | -31.9505 | 115.8605 | 2020-08-06 04:35:02 | Western Australia, Australia | ||
98576 | 98576 | 2020-08-04 | Australia | Western Australia | 670 | 9 | 654 | 7 | -31.9505 | 115.8605 | 2020-08-05 04:34:43 | Western Australia, Australia | ||
2740459 | 2740459 | 2020-08-03 | Australia | Western Australia | 669 | 9 | 654 | 6 | -31.9505 | 115.8605 | 2020-08-04 04:41:59 | Western Australia, Australia | ||
2808211 | 2808211 | 2020-08-02 | Australia | Western Australia | 669 | 9 | 654 | 6 | -31.9505 | 115.8605 | 2020-08-03 04:34:35 | Western Australia, Australia | ||
753779 | 753779 | 2020-08-01 | Australia | Western Australia | 641 | 9 | 652 | 0 | -31.9505 | 115.8605 | 2020-08-02 04:34:47 | Western Australia, Australia | ||
3264944 | 3264944 | 2020-07-31 | Australia | Western Australia | 666 | 9 | 650 | 7 | -31.9505 | 115.8605 | 2020-08-01 04:36:27 | Western Australia, Australia | ||
1928650 | 1928650 | 2020-07-30 | Australia | Western Australia | 665 | 9 | 650 | 6 | -31.9505 | 115.8605 | 2020-07-31 04:35:18 | Western Australia, Australia | ||
2958818 | 2958818 | 2020-07-29 | Australia | Western Australia | 661 | 9 | 647 | 5 | -31.9505 | 115.8605 | 2020-07-30 04:35:05 | Western Australia, Australia | ||
3185435 | 3185435 | 2020-07-28 | Australia | Western Australia | 661 | 9 | 647 | 5 | -31.9505 | 115.8605 | 2020-07-29 04:35:11 | Western Australia, Australia | ||
177485 | 177485 | 2020-07-27 | Australia | Western Australia | 659 | 9 | 647 | 3 | -31.9505 | 115.8605 | 2020-07-28 04:58:43 | Western Australia, Australia | ||
442798 | 442798 | 2020-07-26 | Australia | Western Australia | 658 | 9 | 647 | 2 | -31.9505 | 115.8605 | 2020-07-27 04:35:02 | Western Australia, Australia | ||
1503041 | 1503041 | 2020-07-25 | Australia | Western Australia | 658 | 9 | 644 | 5 | -31.9505 | 115.8605 | 2020-07-26 04:35:00 | Western Australia, Australia | ||
2564012 | 2564012 | 2020-07-24 | Australia | Western Australia | 656 | 9 | 642 | 5 | -31.9505 | 115.8605 | 2020-07-25 04:47:39 | Western Australia, Australia | ||
62214 | 62214 | 2020-07-23 | Australia | Western Australia | 654 | 9 | 631 | 14 | -31.9505 | 115.8605 | 2020-07-24 05:30:40 | Western Australia, Australia | ||
845032 | 845032 | 2020-07-22 | Australia | Western Australia | 654 | 9 | 631 | 14 | -31.9505 | 115.8605 | 2020-07-23 05:15:04 | Western Australia, Australia | ||
1707771 | 1707771 | 2020-07-21 | Australia | Western Australia | 651 | 9 | 625 | 17 | -31.9505 | 115.8605 | 2020-07-22 04:34:42 | Western Australia, Australia | ||
327262 | 327262 | 2020-07-20 | Australia | Western Australia | 651 | 9 | 625 | 17 | -31.9505 | 115.8605 | 2020-07-21 04:38:46 | Western Australia, Australia | ||
122167 | 122167 | 2020-07-19 | Australia | Western Australia | 651 | 9 | 622 | 20 | -31.9505 | 115.8605 | 2020-07-20 05:34:40 | Western Australia, Australia | ||
3205556 | 3205556 | 2020-07-18 | Australia | Western Australia | 651 | 9 | 618 | 24 | -31.9505 | 115.8605 | 2020-07-19 04:34:58 | Western Australia, Australia | ||
2708859 | 2708859 | 2020-07-17 | Australia | Western Australia | 651 | 9 | 617 | 25 | -31.9505 | 115.8605 | 2020-07-18 04:34:45 | Western Australia, Australia | ||
367668 | 367668 | 2020-07-16 | Australia | Western Australia | 646 | 9 | 610 | 27 | -31.9505 | 115.8605 | 2020-07-17 04:34:50 | Western Australia, Australia | ||
2748336 | 2748336 | 2020-07-15 | Australia | Western Australia | 646 | 9 | 610 | 27 | -31.9505 | 115.8605 | 2020-07-16 04:44:59 | Western Australia, Australia | ||
2158980 | 2158980 | 2020-07-14 | Australia | Western Australia | 636 | 9 | 606 | 21 | -31.9505 | 115.8605 | 2020-07-15 04:34:39 | Western Australia, Australia | ||
3491621 | 3491621 | 2020-07-13 | Australia | Western Australia | 636 | 9 | 606 | 21 | -31.9505 | 115.8605 | 2020-07-14 04:34:46 | Western Australia, Australia | ||
3737884 | 3737884 | 2020-07-12 | Australia | Western Australia | 635 | 9 | 606 | 20 | -31.9505 | 115.8605 | 2020-07-13 04:43:04 | Western Australia, Australia | ||
3436279 | 3436279 | 2020-07-11 | Australia | Western Australia | 635 | 9 | 604 | 22 | -31.9505 | 115.8605 | 2020-07-12 04:34:30 | Western Australia, Australia | ||
3237777 | 3237777 | 2020-07-10 | Australia | Western Australia | 634 | 9 | 604 | 21 | -31.9505 | 115.8605 | 2020-07-11 04:34:26 | Western Australia, Australia | ||
1005762 | 1005762 | 2020-07-09 | Australia | Western Australia | 627 | 9 | 602 | 16 | -31.9505 | 115.8605 | 2020-07-10 04:34:24 | Western Australia, Australia | ||
2222977 | 2222977 | 2020-07-08 | Australia | Western Australia | 624 | 9 | 602 | 13 | -31.9505 | 115.8605 | 2020-07-09 04:34:23 | Western Australia, Australia | ||
887586 | 887586 | 2020-07-07 | Australia | Western Australia | 624 | 9 | 602 | 13 | -31.9505 | 115.8605 | 2020-07-08 05:33:48 | Western Australia, Australia | ||
2685146 | 2685146 | 2020-07-06 | Australia | Western Australia | 621 | 9 | 600 | 12 | -31.9505 | 115.8605 | 2020-07-07 04:34:00 | Western Australia, Australia | ||
415611 | 415611 | 2020-07-05 | Australia | Western Australia | 618 | 9 | 600 | 9 | -31.9505 | 115.8605 | 2020-07-06 04:33:57 | Western Australia, Australia | ||
530173 | 530173 | 2020-07-04 | Australia | Western Australia | 612 | 9 | 600 | 3 | -31.9505 | 115.8605 | 2020-07-05 04:33:46 | Western Australia, Australia | ||
2234834 | 2234834 | 2020-07-03 | Australia | Western Australia | 611 | 9 | 598 | 4 | -31.9505 | 115.8605 | 2020-07-04 04:33:51 | Western Australia, Australia | ||
3045629 | 3045629 | 2020-07-02 | Australia | Western Australia | 611 | 9 | 598 | 4 | -31.9505 | 115.8605 | 2020-07-03 04:33:54 | Western Australia, Australia | ||
303320 | 303320 | 2020-07-01 | Australia | Western Australia | 611 | 9 | 598 | 4 | -31.9505 | 115.8605 | 2020-07-02 04:33:46 | Western Australia, Australia | ||
2974698 | 2974698 | 2020-06-30 | Australia | Western Australia | 611 | 9 | 598 | 4 | -31.9505 | 115.8605 | 2020-07-01 04:33:52 | Western Australia, Australia | ||
2633175 | 2633175 | 2020-06-29 | Australia | Western Australia | 611 | 9 | 598 | 4 | -31.9505 | 115.8605 | 2020-06-30 04:33:48 | Western Australia, Australia | ||
2306738 | 2306738 | 2020-06-28 | Australia | Western Australia | 609 | 9 | 595 | 5 | -31.9505 | 115.8605 | 2020-06-29 04:33:44 | Western Australia, Australia | ||
2040073 | 2040073 | 2020-06-27 | Australia | Western Australia | 609 | 9 | 595 | 5 | -31.9505 | 115.8605 | 2020-06-28 04:34:04 | Western Australia, Australia | ||
1136354 | 1136354 | 2020-06-26 | Australia | Western Australia | 608 | 9 | 595 | 4 | -31.9505 | 115.8605 | 2020-06-27 04:33:35 | Western Australia, Australia | ||
2625341 | 2625341 | 2020-06-25 | Australia | Western Australia | 608 | 9 | 595 | 4 | -31.9505 | 115.8605 | 2020-06-26 04:33:43 | Western Australia, Australia | ||
2700981 | 2700981 | 2020-06-24 | Australia | Western Australia | 608 | 9 | 595 | 4 | -31.9505 | 115.8605 | 2020-06-25 05:26:54 | Western Australia, Australia | ||
1522666 | 1522666 | 2020-06-23 | Australia | Western Australia | 607 | 9 | 594 | 4 | -31.9505 | 115.8605 | 2020-06-24 04:33:28 | Western Australia, Australia | ||
1510860 | 1510860 | 2020-06-22 | Australia | Western Australia | 607 | 9 | 594 | 4 | -31.9505 | 115.8605 | 2020-06-23 04:33:22 | Western Australia, Australia | ||
3249599 | 3249599 | 2020-06-21 | Australia | Western Australia | 605 | 9 | 593 | 3 | -31.9505 | 115.8605 | 2020-06-22 04:33:20 | Western Australia, Australia | ||
2438192 | 2438192 | 2020-06-20 | Australia | Western Australia | 605 | 9 | 593 | 3 | -31.9505 | 115.8605 | 2020-06-21 04:33:19 | Western Australia, Australia | ||
1691770 | 1691770 | 2020-06-19 | Australia | Western Australia | 604 | 9 | 592 | 3 | -31.9505 | 115.8605 | 2020-06-20 04:33:19 | Western Australia, Australia | ||
3682919 | 3682919 | 2020-06-18 | Australia | Western Australia | 603 | 9 | 592 | 2 | -31.9505 | 115.8605 | 2020-06-19 04:33:17 | Western Australia, Australia | ||
1196122 | 1196122 | 2020-06-17 | Australia | Western Australia | 603 | 9 | 592 | 2 | -31.9505 | 115.8605 | 2020-06-18 04:33:18 | Western Australia, Australia | ||
2386885 | 2386885 | 2020-06-16 | Australia | Western Australia | 602 | 9 | 592 | 1 | -31.9505 | 115.8605 | 2020-06-17 04:33:21 | Western Australia, Australia | ||
287448 | 287448 | 2020-06-15 | Australia | Western Australia | 602 | 9 | 591 | 2 | -31.9505 | 115.8605 | 2020-06-16 04:33:09 | Western Australia, Australia | ||
1837399 | 1837399 | 2020-06-14 | Australia | Western Australia | 602 | 9 | 591 | 2 | -31.9505 | 115.8605 | 2020-06-15 03:33:14 | Western Australia, Australia | ||
3061451 | 3061451 | 2020-06-13 | Australia | Western Australia | 602 | 9 | 582 | 11 | -31.9505 | 115.8605 | 2020-06-14 03:33:15 | Western Australia, Australia | ||
737771 | 737771 | 2020-06-12 | Australia | Western Australia | 602 | 9 | 575 | 18 | -31.9505 | 115.8605 | 2020-06-13 03:33:14 | Western Australia, Australia | ||
1273741 | 1273741 | 2020-06-11 | Australia | Western Australia | 602 | 9 | 575 | 18 | -31.9505 | 115.8605 | 2020-06-12 05:09:52 | Western Australia, Australia | ||
2864180 | 2864180 | 2020-06-10 | Australia | Western Australia | 601 | 9 | 571 | 21 | -31.9505 | 115.8605 | 2020-06-11 03:33:41 | Western Australia, Australia | ||
1210997 | 1210997 | 2020-06-09 | Australia | Western Australia | 599 | 9 | 560 | 30 | -31.9505 | 115.8605 | 2020-06-10 04:07:00 | Western Australia, Australia | ||
217424 | 217424 | 2020-06-08 | Australia | Western Australia | 599 | 9 | 560 | 30 | -31.9505 | 115.8605 | 2020-06-09 03:33:03 | Western Australia, Australia |
Advanced export
JSON shape: default, array, newline-delimited
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]);