johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,033 rows where country_or_region = "Australia" and province_or_state = "Tasmania" sorted by confirmed
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1691708 | 1691708 | 2020-06-19 | Australia | Tasmania | 228 | 13 | 215 | 0 | -42.8821 | 147.3272 | 2020-06-20 04:33:19 | Tasmania, Australia | ||
1790509 | 1790509 | 2020-05-29 | Australia | Tasmania | 228 | 13 | 205 | 10 | -42.8821 | 147.3272 | 2020-05-30 02:32:48 | Tasmania, Australia | ||
1794075 | 1794075 | 2020-05-31 | Australia | Tasmania | 228 | 13 | 207 | 8 | -42.8821 | 147.3272 | 2020-06-01 02:32:46 | Tasmania, Australia | ||
1829588 | 1829588 | 2020-05-16 | Australia | Tasmania | 228 | 13 | 192 | 23 | -42.8821 | 147.3272 | 2020-05-17 02:32:32 | Tasmania, Australia | ||
1837337 | 1837337 | 2020-06-14 | Australia | Tasmania | 228 | 13 | 213 | 2 | -42.8821 | 147.3272 | 2020-06-15 03:33:14 | Tasmania, Australia | ||
1864907 | 1864907 | 2020-05-22 | Australia | Tasmania | 228 | 13 | 199 | 16 | -42.8821 | 147.3272 | 2020-05-23 02:32:42 | Tasmania, Australia | ||
2040011 | 2040011 | 2020-06-27 | Australia | Tasmania | 228 | 13 | 215 | 0 | -42.8821 | 147.3272 | 2020-06-28 04:34:04 | Tasmania, Australia | ||
2158918 | 2158918 | 2020-07-14 | Australia | Tasmania | 228 | 13 | 215 | 0 | -42.8821 | 147.3272 | 2020-07-15 04:34:39 | Tasmania, Australia | ||
2222916 | 2222916 | 2020-07-08 | Australia | Tasmania | 228 | 13 | 215 | 0 | -42.8821 | 147.3272 | 2020-07-09 04:34:23 | Tasmania, Australia | ||
2234773 | 2234773 | 2020-07-03 | Australia | Tasmania | 228 | 13 | 215 | 0 | -42.8821 | 147.3272 | 2020-07-04 04:33:51 | Tasmania, Australia | ||
2306676 | 2306676 | 2020-06-28 | Australia | Tasmania | 228 | 13 | 215 | 0 | -42.8821 | 147.3272 | 2020-06-29 04:33:44 | Tasmania, Australia | ||
2386823 | 2386823 | 2020-06-16 | Australia | Tasmania | 228 | 13 | 213 | 2 | -42.8821 | 147.3272 | 2020-06-17 04:33:21 | Tasmania, Australia | ||
2390222 | 2390222 | 2020-05-19 | Australia | Tasmania | 228 | 13 | 195 | 20 | -42.8821 | 147.3272 | 2020-05-20 02:32:19 | Tasmania, Australia | ||
2438130 | 2438130 | 2020-06-20 | Australia | Tasmania | 228 | 13 | 215 | 0 | -42.8821 | 147.3272 | 2020-06-21 04:33:19 | Tasmania, Australia | ||
2548320 | 2548320 | 2020-05-27 | Australia | Tasmania | 228 | 13 | 203 | 12 | -42.8821 | 147.3272 | 2020-05-28 02:32:31 | Tasmania, Australia | ||
2555982 | 2555982 | 2020-06-02 | Australia | Tasmania | 228 | 13 | 208 | 7 | -42.8821 | 147.3272 | 2020-06-03 02:33:13 | Tasmania, Australia | ||
2625279 | 2625279 | 2020-06-25 | Australia | Tasmania | 228 | 13 | 215 | 0 | -42.8821 | 147.3272 | 2020-06-26 04:33:43 | Tasmania, Australia | ||
2633113 | 2633113 | 2020-06-29 | Australia | Tasmania | 228 | 13 | 215 | 0 | -42.8821 | 147.3272 | 2020-06-30 04:33:48 | Tasmania, Australia | ||
2685085 | 2685085 | 2020-07-06 | Australia | Tasmania | 228 | 13 | 215 | 0 | -42.8821 | 147.3272 | 2020-07-07 04:34:00 | Tasmania, Australia | ||
2700919 | 2700919 | 2020-06-24 | Australia | Tasmania | 228 | 13 | 215 | 0 | -42.8821 | 147.3272 | 2020-06-25 05:26:54 | Tasmania, Australia | ||
2708796 | 2708796 | 2020-07-17 | Australia | Tasmania | 228 | 13 | 215 | 0 | -42.8821 | 147.3272 | 2020-07-18 04:34:45 | Tasmania, Australia | ||
2712388 | 2712388 | 2020-05-28 | Australia | Tasmania | 228 | 13 | 203 | 12 | -42.8821 | 147.3272 | 2020-05-29 02:32:50 | Tasmania, Australia | ||
2748274 | 2748274 | 2020-07-15 | Australia | Tasmania | 228 | 13 | 215 | 0 | -42.8821 | 147.3272 | 2020-07-16 04:44:59 | Tasmania, Australia | ||
2800166 | 2800166 | 2020-06-07 | Australia | Tasmania | 228 | 13 | 209 | 6 | -42.8821 | 147.3272 | 2020-06-08 03:33:22 | Tasmania, Australia | ||
2864120 | 2864120 | 2020-06-10 | Australia | Tasmania | 228 | 13 | 209 | 6 | -42.8821 | 147.3272 | 2020-06-11 03:33:41 | Tasmania, Australia | ||
2974636 | 2974636 | 2020-06-30 | Australia | Tasmania | 228 | 13 | 215 | 0 | -42.8821 | 147.3272 | 2020-07-01 04:33:52 | Tasmania, Australia | ||
3045567 | 3045567 | 2020-07-02 | Australia | Tasmania | 228 | 13 | 215 | 0 | -42.8821 | 147.3272 | 2020-07-03 04:33:54 | Tasmania, Australia | ||
3061389 | 3061389 | 2020-06-13 | Australia | Tasmania | 228 | 13 | 213 | 2 | -42.8821 | 147.3272 | 2020-06-14 03:33:15 | Tasmania, Australia | ||
3205494 | 3205494 | 2020-07-18 | Australia | Tasmania | 228 | 13 | 215 | 0 | -42.8821 | 147.3272 | 2020-07-19 04:34:58 | Tasmania, Australia | ||
3237715 | 3237715 | 2020-07-10 | Australia | Tasmania | 228 | 13 | 215 | 0 | -42.8821 | 147.3272 | 2020-07-11 04:34:26 | Tasmania, Australia | ||
3249537 | 3249537 | 2020-06-21 | Australia | Tasmania | 228 | 13 | 215 | 0 | -42.8821 | 147.3272 | 2020-06-22 04:33:20 | Tasmania, Australia | ||
3260960 | 3260960 | 2020-05-18 | Australia | Tasmania | 228 | 13 | 195 | 20 | -42.8821 | 147.3272 | 2020-05-19 02:32:18 | Tasmania, Australia | ||
3276304 | 3276304 | 2020-05-15 | Australia | Tasmania | 228 | 13 | 191 | 24 | -42.8821 | 147.3272 | 2020-05-16 02:32:19 | Tasmania, Australia | ||
3416354 | 3416354 | 2020-05-17 | Australia | Tasmania | 228 | 13 | 194 | 21 | -42.8821 | 147.3272 | 2020-05-18 02:32:21 | Tasmania, Australia | ||
3436217 | 3436217 | 2020-07-11 | Australia | Tasmania | 228 | 13 | 215 | 0 | -42.8821 | 147.3272 | 2020-07-12 04:34:30 | Tasmania, Australia | ||
3491559 | 3491559 | 2020-07-13 | Australia | Tasmania | 228 | 13 | 215 | 0 | -42.8821 | 147.3272 | 2020-07-14 04:34:46 | Tasmania, Australia | ||
3638968 | 3638968 | 2020-05-30 | Australia | Tasmania | 228 | 13 | 206 | 9 | -42.8821 | 147.3272 | 2020-05-31 02:32:45 | Tasmania, Australia | ||
3682857 | 3682857 | 2020-06-18 | Australia | Tasmania | 228 | 13 | 215 | 0 | -42.8821 | 147.3272 | 2020-06-19 04:33:17 | Tasmania, Australia | ||
3737822 | 3737822 | 2020-07-12 | Australia | Tasmania | 228 | 13 | 215 | 0 | -42.8821 | 147.3272 | 2020-07-13 04:43:04 | Tasmania, Australia | ||
3866940 | 3866940 | 2020-06-03 | Australia | Tasmania | 228 | 13 | 208 | 7 | -42.8821 | 147.3272 | 2020-06-04 02:33:14 | Tasmania, Australia | ||
62154 | 62154 | 2020-07-23 | Australia | Tasmania | 229 | 13 | 215 | 1 | -42.8821 | 147.3272 | 2020-07-24 05:30:40 | Tasmania, Australia | ||
98513 | 98513 | 2020-08-04 | Australia | Tasmania | 229 | 13 | 216 | 0 | -42.8821 | 147.3272 | 2020-08-05 04:34:43 | Tasmania, Australia | ||
177423 | 177423 | 2020-07-27 | Australia | Tasmania | 229 | 13 | 215 | 1 | -42.8821 | 147.3272 | 2020-07-28 04:58:43 | Tasmania, Australia | ||
327200 | 327200 | 2020-07-20 | Australia | Tasmania | 229 | 13 | 215 | 1 | -42.8821 | 147.3272 | 2020-07-21 04:38:46 | Tasmania, Australia | ||
371578 | 371578 | 2020-08-08 | Australia | Tasmania | 229 | 13 | 216 | 0 | -42.8821 | 147.3272 | 2020-08-09 04:34:54 | Tasmania, Australia | ||
442736 | 442736 | 2020-07-26 | Australia | Tasmania | 229 | 13 | 215 | 1 | -42.8821 | 147.3272 | 2020-07-27 04:35:02 | Tasmania, Australia | ||
458762 | 458762 | 2020-08-07 | Australia | Tasmania | 229 | 13 | 216 | 0 | -42.8821 | 147.3272 | 2020-08-08 04:34:53 | Tasmania, Australia | ||
753716 | 753716 | 2020-08-01 | Australia | Tasmania | 229 | 13 | 216 | 0 | -42.8821 | 147.3272 | 2020-08-02 04:34:47 | Tasmania, Australia | ||
844970 | 844970 | 2020-07-22 | Australia | Tasmania | 229 | 13 | 215 | 1 | -42.8821 | 147.3272 | 2020-07-23 05:15:04 | Tasmania, Australia | ||
1502980 | 1502980 | 2020-07-25 | Australia | Tasmania | 229 | 13 | 215 | 1 | -42.8821 | 147.3272 | 2020-07-26 04:35:00 | Tasmania, Australia | ||
1707709 | 1707709 | 2020-07-21 | Australia | Tasmania | 229 | 13 | 215 | 1 | -42.8821 | 147.3272 | 2020-07-22 04:34:42 | Tasmania, Australia | ||
1920601 | 1920601 | 2020-08-10 | Australia | Tasmania | 229 | 13 | 216 | 0 | -42.8821 | 147.3272 | 2020-08-11 04:35:08 | Tasmania, Australia | ||
1928588 | 1928588 | 2020-07-30 | Australia | Tasmania | 229 | 13 | 215 | 1 | -42.8821 | 147.3272 | 2020-07-31 04:35:18 | Tasmania, Australia | ||
2563950 | 2563950 | 2020-07-24 | Australia | Tasmania | 229 | 13 | 215 | 1 | -42.8821 | 147.3272 | 2020-07-25 04:47:39 | Tasmania, Australia | ||
2740396 | 2740396 | 2020-08-03 | Australia | Tasmania | 229 | 13 | 216 | 0 | -42.8821 | 147.3272 | 2020-08-04 04:41:59 | Tasmania, Australia | ||
2808148 | 2808148 | 2020-08-02 | Australia | Tasmania | 229 | 13 | 216 | 0 | -42.8821 | 147.3272 | 2020-08-03 04:34:35 | Tasmania, Australia | ||
2958756 | 2958756 | 2020-07-29 | Australia | Tasmania | 229 | 13 | 215 | 1 | -42.8821 | 147.3272 | 2020-07-30 04:35:05 | Tasmania, Australia | ||
3185372 | 3185372 | 2020-07-28 | Australia | Tasmania | 229 | 13 | 215 | 1 | -42.8821 | 147.3272 | 2020-07-29 04:35:11 | Tasmania, Australia | ||
3264881 | 3264881 | 2020-07-31 | Australia | Tasmania | 229 | 13 | 216 | 0 | -42.8821 | 147.3272 | 2020-08-01 04:36:27 | Tasmania, Australia | ||
3612447 | 3612447 | 2020-08-06 | Australia | Tasmania | 229 | 13 | 216 | 0 | -42.8821 | 147.3272 | 2020-08-07 04:35:11 | Tasmania, Australia | ||
3793277 | 3793277 | 2020-08-05 | Australia | Tasmania | 229 | 13 | 216 | 0 | -42.8821 | 147.3272 | 2020-08-06 04:35:02 | Tasmania, Australia | ||
3923410 | 3923410 | 2020-08-09 | Australia | Tasmania | 229 | 13 | 216 | 0 | -42.8821 | 147.3272 | 2020-08-10 04:34:55 | Tasmania, Australia | ||
8046 | 8046 | 2020-10-25 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-10-26 04:25:02 | Tasmania, Australia | ||
74791 | 74791 | 2020-12-03 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-12-04 05:27:27 | Tasmania, Australia | ||
78802 | 78802 | 2020-10-14 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-10-15 04:24:28 | Tasmania, Australia | ||
122407 | 122407 | 2020-11-18 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-11-19 05:25:23 | Tasmania, Australia | ||
145687 | 145687 | 2020-08-15 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-16 04:27:42 | Tasmania, Australia | ||
193782 | 193782 | 2020-08-31 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-09-01 04:28:31 | Tasmania, Australia | ||
205969 | 205969 | 2020-08-19 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-20 04:27:43 | Tasmania, Australia | ||
209954 | 209954 | 2020-10-29 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-10-30 04:24:49 | Tasmania, Australia | ||
271869 | 271869 | 2020-11-10 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-11-11 05:25:30 | Tasmania, Australia | ||
343990 | 343990 | 2020-09-14 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-09-15 03:22:50 | Tasmania, Australia | ||
375896 | 375896 | 2020-11-06 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-11-07 05:24:52 | Tasmania, Australia | ||
391937 | 391937 | 2020-11-27 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-11-28 05:25:50 | Tasmania, Australia | ||
427051 | 427051 | 2020-09-07 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-09-08 04:28:25 | Tasmania, Australia | ||
546468 | 546468 | 2020-09-12 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-09-13 04:30:52 | Tasmania, Australia | ||
582546 | 582546 | 2020-08-13 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-14 04:51:19 | Tasmania, Australia | ||
609403 | 609403 | 2020-08-29 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-30 04:28:22 | Tasmania, Australia | ||
662014 | 662014 | 2020-08-11 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-12 04:27:29 | Tasmania, Australia | ||
665993 | 665993 | 2020-09-16 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-09-17 04:22:00 | Tasmania, Australia | ||
678015 | 678015 | 2020-11-23 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-11-24 05:27:31 | Tasmania, Australia | ||
738003 | 738003 | 2020-12-02 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-12-03 05:28:22 | Tasmania, Australia | ||
754016 | 754016 | 2020-10-28 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-10-29 04:24:49 | Tasmania, Australia | ||
762028 | 762028 | 2020-10-18 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-10-19 04:24:16 | Tasmania, Australia | ||
786091 | 786091 | 2020-10-15 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-10-16 04:24:01 | Tasmania, Australia | ||
813291 | 813291 | 2020-09-05 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-09-06 04:28:33 | Tasmania, Australia | ||
817281 | 817281 | 2020-10-09 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-10-10 04:23:57 | Tasmania, Australia | ||
821273 | 821273 | 2020-11-19 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-11-20 05:26:28 | Tasmania, Australia | ||
837327 | 837327 | 2020-08-17 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-18 04:27:56 | Tasmania, Australia | ||
864473 | 864473 | 2020-11-12 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-11-13 05:25:30 | Tasmania, Australia | ||
891834 | 891834 | 2020-11-05 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-11-06 05:24:55 | Tasmania, Australia | ||
923384 | 923384 | 2020-11-26 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-11-27 05:26:53 | Tasmania, Australia | ||
966611 | 966611 | 2020-09-29 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-09-30 04:23:33 | Tasmania, Australia | ||
1005996 | 1005996 | 2020-12-06 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-12-07 05:26:14 | Tasmania, Australia | ||
1026066 | 1026066 | 2020-10-17 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-10-18 04:24:25 | Tasmania, Australia | ||
1041538 | 1041538 | 2020-10-07 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-10-08 04:23:56 | Tasmania, Australia | ||
1045530 | 1045530 | 2020-09-30 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-10-01 04:23:42 | Tasmania, Australia | ||
1053538 | 1053538 | 2020-10-23 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-10-24 04:24:46 | Tasmania, Australia | ||
1105268 | 1105268 | 2020-09-02 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-09-03 04:28:22 | Tasmania, Australia | ||
1121304 | 1121304 | 2020-09-17 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-09-18 05:05:00 | Tasmania, 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]);