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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3069715 | 3069715 | 2021-11-23 | Australia | Western Australia | 1121 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-24 04:22:14 | Western Australia, Australia | |||
3748813 | 3748813 | 2021-11-22 | Australia | Western Australia | 1121 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-23 04:22:39 | Western Australia, Australia | |||
1014020 | 1014020 | 2021-11-21 | Australia | Western Australia | 1120 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-22 04:22:20 | Western Australia, Australia | |||
722184 | 722184 | 2021-11-20 | Australia | Western Australia | 1119 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-21 04:22:13 | Western Australia, Australia | |||
161714 | 161714 | 2021-11-19 | Australia | Western Australia | 1118 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-20 04:22:17 | Western Australia, Australia | |||
3288601 | 3288601 | 2021-11-18 | Australia | Western Australia | 1117 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-19 04:21:40 | Western Australia, Australia | |||
447057 | 447057 | 2021-11-17 | Australia | Western Australia | 1116 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-18 04:21:33 | Western Australia, Australia | |||
3342307 | 3342307 | 2021-11-16 | Australia | Western Australia | 1116 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-17 04:21:48 | Western Australia, Australia | |||
2287143 | 2287143 | 2021-11-15 | Australia | Western Australia | 1113 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-16 04:21:10 | Western Australia, Australia | |||
1321917 | 1321917 | 2021-11-14 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-15 04:21:36 | Western Australia, Australia | |||
686043 | 686043 | 2021-11-13 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-14 04:21:31 | Western Australia, Australia | |||
714152 | 714152 | 2021-11-12 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-13 04:21:38 | Western Australia, Australia | |||
28102 | 28102 | 2021-11-11 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-12 04:22:01 | Western Australia, Australia | |||
2844541 | 2844541 | 2021-11-10 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-11 04:21:45 | Western Australia, Australia | |||
86811 | 86811 | 2021-11-09 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-10 04:21:38 | Western Australia, Australia | |||
3639239 | 3639239 | 2021-11-08 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-09 04:21:36 | Western Australia, Australia | |||
2000347 | 2000347 | 2021-11-07 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-08 04:21:43 | Western Australia, Australia | |||
495338 | 495338 | 2021-11-06 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-07 04:21:53 | Western Australia, Australia | |||
3121193 | 3121193 | 2021-11-05 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-06 04:21:51 | Western Australia, Australia | |||
698091 | 698091 | 2021-11-04 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-05 04:21:54 | Western Australia, Australia | |||
275869 | 275869 | 2021-11-03 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-04 04:22:20 | Western Australia, Australia | |||
43394 | 43394 | 2021-11-02 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-03 06:22:09 | Western Australia, Australia | |||
3511090 | 3511090 | 2021-11-01 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-02 04:22:03 | Western Australia, Australia | |||
287682 | 287682 | 2021-10-31 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-01 04:22:01 | Western Australia, Australia | |||
2720688 | 2720688 | 2021-10-30 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-10-31 04:22:08 | Western Australia, Australia | |||
566790 | 566790 | 2021-10-29 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-10-30 04:22:03 | Western Australia, Australia | |||
4032 | 4032 | 2021-10-28 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-10-29 04:22:03 | Western Australia, Australia | |||
534422 | 534422 | 2021-10-27 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-10-28 04:22:08 | Western Australia, Australia | |||
3491859 | 3491859 | 2021-10-26 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-10-27 04:22:32 | Western Australia, Australia | |||
3793581 | 3793581 | 2021-10-25 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-10-26 04:22:09 | Western Australia, Australia | |||
682027 | 682027 | 2021-10-24 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-10-25 04:22:31 | Western Australia, Australia | |||
770035 | 770035 | 2021-10-23 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-10-24 04:21:22 | Western Australia, Australia | |||
653682 | 653682 | 2021-10-22 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-10-23 04:21:32 | Western Australia, Australia | |||
2123429 | 2123429 | 2021-10-21 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-10-22 04:21:14 | Western Australia, Australia | |||
443041 | 443041 | 2021-10-20 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-10-21 04:21:18 | Western Australia, Australia | |||
597360 | 597360 | 2021-10-19 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-10-20 04:21:00 | Western Australia, Australia | |||
2043537 | 2043537 | 2021-10-18 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-10-19 04:20:54 | Western Australia, Australia | |||
1908898 | 1908898 | 2021-10-17 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-10-18 04:21:10 | Western Australia, Australia | |||
934487 | 934487 | 2021-10-16 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-10-17 04:21:29 | Western Australia, Australia | |||
2943042 | 2943042 | 2021-10-15 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-10-16 04:21:15 | Western Australia, Australia | |||
491322 | 491322 | 2021-10-14 | Australia | Western Australia | 1111 | 9 | 0 | -31.9505 | 115.8605 | 2021-10-15 04:21:26 | Western Australia, Australia | |||
633610 | 633610 | 2021-10-13 | Australia | Western Australia | 1111 | 9 | 0 | -31.9505 | 115.8605 | 2021-10-14 04:21:29 | Western Australia, Australia | |||
1491288 | 1491288 | 2021-10-12 | Australia | Western Australia | 1111 | 9 | 0 | -31.9505 | 115.8605 | 2021-10-13 04:20:51 | Western Australia, Australia | |||
3007021 | 3007021 | 2021-10-11 | Australia | Western Australia | 1110 | 9 | 0 | -31.9505 | 115.8605 | 2021-10-12 04:21:09 | Western Australia, Australia | |||
423037 | 423037 | 2021-10-10 | Australia | Western Australia | 1110 | 9 | 0 | -31.9505 | 115.8605 | 2021-10-11 04:21:31 | Western Australia, Australia | |||
2875894 | 2875894 | 2021-10-09 | Australia | Western Australia | 1110 | 9 | 0 | -31.9505 | 115.8605 | 2021-10-10 04:21:38 | Western Australia, Australia | |||
2959060 | 2959060 | 2021-10-08 | Australia | Western Australia | 1110 | 9 | 0 | -31.9505 | 115.8605 | 2021-10-09 04:21:34 | Western Australia, Australia | |||
467098 | 467098 | 2021-10-07 | Australia | Western Australia | 1110 | 9 | 0 | -31.9505 | 115.8605 | 2021-10-08 04:21:25 | Western Australia, Australia | |||
2458478 | 2458478 | 2021-10-06 | Australia | Western Australia | 1110 | 9 | 0 | -31.9505 | 115.8605 | 2021-10-07 04:21:36 | Western Australia, Australia | |||
3832172 | 3832172 | 2021-10-05 | Australia | Western Australia | 1110 | 9 | 0 | -31.9505 | 115.8605 | 2021-10-06 04:21:33 | Western Australia, Australia | |||
986665 | 986665 | 2021-10-04 | Australia | Western Australia | 1109 | 9 | 0 | -31.9505 | 115.8605 | 2021-10-05 04:21:27 | Western Australia, Australia | |||
1273975 | 1273975 | 2021-10-03 | Australia | Western Australia | 1099 | 9 | 0 | -31.9505 | 115.8605 | 2021-10-04 04:21:31 | Western Australia, Australia | |||
3927728 | 3927728 | 2021-10-02 | Australia | Western Australia | 1096 | 9 | 0 | -31.9505 | 115.8605 | 2021-10-03 04:21:24 | Western Australia, Australia | |||
2131708 | 2131708 | 2021-10-01 | Australia | Western Australia | 1096 | 9 | 0 | -31.9505 | 115.8605 | 2021-10-02 04:21:25 | Western Australia, Australia | |||
2772665 | 2772665 | 2021-09-30 | Australia | Western Australia | 1096 | 9 | 0 | -31.9505 | 115.8605 | 2021-10-01 04:21:35 | Western Australia, Australia | |||
706121 | 706121 | 2021-09-29 | Australia | Western Australia | 1096 | 9 | 0 | -31.9505 | 115.8605 | 2021-09-30 04:21:20 | Western Australia, Australia | |||
1333963 | 1333963 | 2021-09-28 | Australia | Western Australia | 1096 | 9 | 0 | -31.9505 | 115.8605 | 2021-09-29 04:21:45 | Western Australia, Australia | |||
1235332 | 1235332 | 2021-09-27 | Australia | Western Australia | 1096 | 9 | 0 | -31.9505 | 115.8605 | 2021-09-28 04:21:28 | Western Australia, Australia | |||
2075633 | 2075633 | 2021-09-26 | Australia | Western Australia | 1095 | 9 | 0 | -31.9505 | 115.8605 | 2021-09-27 04:21:16 | Western Australia, Australia | |||
1724185 | 1724185 | 2021-09-25 | Australia | Western Australia | 1095 | 9 | 0 | -31.9505 | 115.8605 | 2021-09-26 04:21:29 | Western Australia, Australia | |||
1920905 | 1920905 | 2021-09-24 | Australia | Western Australia | 1095 | 9 | 0 | -31.9505 | 115.8605 | 2021-09-25 04:21:31 | Western Australia, Australia | |||
601376 | 601376 | 2021-09-23 | Australia | Western Australia | 1094 | 9 | 0 | -31.9505 | 115.8605 | 2021-09-24 04:21:44 | Western Australia, Australia | |||
3011037 | 3011037 | 2021-09-22 | Australia | Western Australia | 1094 | 9 | 0 | -31.9505 | 115.8605 | 2021-09-23 04:21:43 | Western Australia, Australia | |||
3757175 | 3757175 | 2021-09-21 | Australia | Western Australia | 1094 | 9 | 0 | -31.9505 | 115.8605 | 2021-09-22 04:21:45 | Western Australia, Australia | |||
809278 | 809278 | 2021-09-20 | Australia | Western Australia | 1094 | 9 | 0 | -31.9505 | 115.8605 | 2021-09-21 04:21:26 | Western Australia, Australia | |||
1814477 | 1814477 | 2021-09-19 | Australia | Western Australia | 1093 | 9 | 0 | -31.9505 | 115.8605 | 2021-09-20 04:21:22 | Western Australia, Australia | |||
16057 | 16057 | 2021-09-18 | Australia | Western Australia | 1092 | 9 | 0 | -31.9505 | 115.8605 | 2021-09-19 04:21:34 | Western Australia, Australia | |||
2617742 | 2617742 | 2021-09-17 | Australia | Western Australia | 1092 | 9 | 0 | -31.9505 | 115.8605 | 2021-09-18 04:21:24 | Western Australia, Australia | |||
2808450 | 2808450 | 2021-09-16 | Australia | Western Australia | 1089 | 9 | 0 | -31.9505 | 115.8605 | 2021-09-17 04:21:46 | Western Australia, Australia | |||
1374195 | 1374195 | 2021-09-15 | Australia | Western Australia | 1089 | 9 | 0 | -31.9505 | 115.8605 | 2021-09-16 04:22:19 | Western Australia, Australia | |||
2462494 | 2462494 | 2021-09-14 | Australia | Western Australia | 1089 | 9 | 0 | -31.9505 | 115.8605 | 2021-09-15 03:22:37 | Western Australia, Australia | |||
1385333 | 1385333 | 2021-09-13 | Australia | Western Australia | 1089 | 9 | 0 | -31.9505 | 115.8605 | 2021-09-14 04:21:41 | Western Australia, Australia | |||
1884702 | 1884702 | 2021-09-12 | Australia | Western Australia | 1089 | 9 | 0 | -31.9505 | 115.8605 | 2021-09-13 04:21:15 | Western Australia, Australia | |||
3805605 | 3805605 | 2021-09-11 | Australia | Western Australia | 1089 | 9 | 0 | -31.9505 | 115.8605 | 2021-09-12 04:21:13 | Western Australia, Australia | |||
3448545 | 3448545 | 2021-09-10 | Australia | Western Australia | 1088 | 9 | 0 | -31.9505 | 115.8605 | 2021-09-11 04:21:30 | Western Australia, Australia | |||
1262491 | 1262491 | 2021-09-09 | Australia | Western Australia | 1088 | 9 | 0 | -31.9505 | 115.8605 | 2021-09-10 04:21:20 | Western Australia, Australia | |||
2278861 | 2278861 | 2021-09-08 | Australia | Western Australia | 1088 | 9 | 0 | -31.9505 | 115.8605 | 2021-09-09 04:21:27 | Western Australia, Australia | |||
641640 | 641640 | 2021-09-07 | Australia | Western Australia | 1087 | 9 | 0 | -31.9505 | 115.8605 | 2021-09-08 04:21:31 | Western Australia, Australia | |||
3193703 | 3193703 | 2021-09-06 | Australia | Western Australia | 1087 | 9 | 0 | -31.9505 | 115.8605 | 2021-09-07 04:21:35 | Western Australia, Australia | |||
3280571 | 3280571 | 2021-09-05 | Australia | Western Australia | 1086 | 9 | 0 | -31.9505 | 115.8605 | 2021-09-06 04:21:22 | Western Australia, Australia | |||
248985 | 248985 | 2021-09-04 | Australia | Western Australia | 1086 | 9 | 0 | -31.9505 | 115.8605 | 2021-09-05 04:21:33 | Western Australia, Australia | |||
3974266 | 3974266 | 2021-09-03 | Australia | Western Australia | 1086 | 9 | 0 | -31.9505 | 115.8605 | 2021-09-04 04:21:28 | Western Australia, Australia | |||
177728 | 177728 | 2021-09-02 | Australia | Western Australia | 1086 | 9 | 0 | -31.9505 | 115.8605 | 2021-09-03 04:21:20 | Western Australia, Australia | |||
66763 | 66763 | 2021-09-01 | Australia | Western Australia | 1086 | 9 | 0 | -31.9505 | 115.8605 | 2021-09-02 04:21:15 | Western Australia, Australia | |||
2067605 | 2067605 | 2021-08-31 | Australia | Western Australia | 1086 | 9 | 0 | -31.9505 | 115.8605 | 2021-09-01 04:21:38 | Western Australia, Australia | |||
1775059 | 1775059 | 2021-08-30 | Australia | Western Australia | 1086 | 9 | 0 | -31.9505 | 115.8605 | 2021-08-31 04:21:46 | Western Australia, Australia | |||
3891633 | 3891633 | 2021-08-29 | Australia | Western Australia | 1086 | 9 | 0 | -31.9505 | 115.8605 | 2021-08-30 04:21:23 | Western Australia, Australia | |||
2792736 | 2792736 | 2021-08-28 | Australia | Western Australia | 1086 | 9 | 0 | -31.9505 | 115.8605 | 2021-08-29 04:21:14 | Western Australia, Australia | |||
2922895 | 2922895 | 2021-08-27 | Australia | Western Australia | 1084 | 9 | 0 | -31.9505 | 115.8605 | 2021-08-28 04:21:28 | Western Australia, Australia | |||
1595909 | 1595909 | 2021-08-26 | Australia | Western Australia | 1084 | 9 | 0 | -31.9505 | 115.8605 | 2021-08-27 04:21:37 | Western Australia, Australia | |||
32118 | 32118 | 2021-08-25 | Australia | Western Australia | 1084 | 9 | 0 | -31.9505 | 115.8605 | 2021-08-26 04:21:28 | Western Australia, Australia | |||
3105157 | 3105157 | 2021-08-24 | Australia | Western Australia | 1064 | 9 | 0 | -31.9505 | 115.8605 | 2021-08-25 04:21:41 | Western Australia, Australia | |||
3165328 | 3165328 | 2021-08-23 | Australia | Western Australia | 1064 | 9 | 0 | -31.9505 | 115.8605 | 2021-08-24 04:21:19 | Western Australia, Australia | |||
2175255 | 2175255 | 2021-08-22 | Australia | Western Australia | 1063 | 9 | 0 | -31.9505 | 115.8605 | 2021-08-23 04:21:27 | Western Australia, Australia | |||
3555351 | 3555351 | 2021-08-21 | Australia | Western Australia | 1063 | 9 | 0 | -31.9505 | 115.8605 | 2021-08-22 04:21:29 | Western Australia, Australia | |||
1853693 | 1853693 | 2021-08-20 | Australia | Western Australia | 1063 | 9 | 0 | -31.9505 | 115.8605 | 2021-08-21 04:21:38 | Western Australia, Australia | |||
511400 | 511400 | 2021-08-19 | Australia | Western Australia | 1062 | 10 | 0 | -31.9505 | 115.8605 | 2021-08-20 04:21:33 | Western Australia, Australia | |||
2517879 | 2517879 | 2021-08-18 | Australia | Western Australia | 1062 | 10 | 0 | -31.9505 | 115.8605 | 2021-08-19 04:21:15 | Western Australia, Australia | |||
244971 | 244971 | 2021-08-17 | Australia | Western Australia | 1061 | 9 | 0 | -31.9505 | 115.8605 | 2021-08-18 04:21:35 | Western Australia, Australia | |||
1603934 | 1603934 | 2021-08-16 | Australia | Western Australia | 1061 | 9 | 0 | -31.9505 | 115.8605 | 2021-08-17 04:21:49 | 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]);