johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
37 rows where active = 1, country_or_region = "Australia" and province_or_state = "Northern Territory" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3029987 | 3029987 | 2021-06-16 | Australia | Northern Territory | 175 | 0 | 174 | 1 | -12.4634 | 130.8456 | 2021-06-17 04:22:36 | Northern Territory, Australia | ||
2716669 | 2716669 | 2021-06-10 | Australia | Northern Territory | 174 | 0 | 173 | 1 | -12.4634 | 130.8456 | 2021-06-11 04:23:20 | Northern Territory, Australia | ||
1219265 | 1219265 | 2021-03-27 | Australia | Northern Territory | 107 | 0 | 106 | 1 | -12.4634 | 130.8456 | 2021-03-28 05:28:10 | Northern Territory, Australia | ||
1980313 | 1980313 | 2021-03-25 | Australia | Northern Territory | 106 | 0 | 105 | 1 | -12.4634 | 130.8456 | 2021-03-26 05:26:55 | Northern Territory, Australia | ||
2780691 | 2780691 | 2021-03-24 | Australia | Northern Territory | 106 | 0 | 105 | 1 | -12.4634 | 130.8456 | 2021-03-25 05:27:00 | Northern Territory, Australia | ||
1798336 | 1798336 | 2021-03-23 | Australia | Northern Territory | 106 | 0 | 105 | 1 | -12.4634 | 130.8456 | 2021-03-24 05:25:40 | Northern Territory, Australia | ||
1203504 | 1203504 | 2021-03-22 | Australia | Northern Territory | 106 | 0 | 105 | 1 | -12.4634 | 130.8456 | 2021-03-23 05:26:18 | Northern Territory, Australia | ||
3369026 | 3369026 | 2021-03-21 | Australia | Northern Territory | 106 | 0 | 105 | 1 | -12.4634 | 130.8456 | 2021-03-22 05:25:43 | Northern Territory, Australia | ||
1744236 | 1744236 | 2021-03-20 | Australia | Northern Territory | 106 | 0 | 105 | 1 | -12.4634 | 130.8456 | 2021-03-21 05:25:44 | Northern Territory, Australia | ||
3420616 | 3420616 | 2021-03-19 | Australia | Northern Territory | 106 | 0 | 105 | 1 | -12.4634 | 130.8456 | 2021-03-20 05:25:46 | Northern Territory, Australia | ||
3452554 | 3452554 | 2021-03-18 | Australia | Northern Territory | 106 | 0 | 105 | 1 | -12.4634 | 130.8456 | 2021-03-19 05:26:09 | Northern Territory, Australia | ||
3620778 | 3620778 | 2021-03-17 | Australia | Northern Territory | 106 | 0 | 105 | 1 | -12.4634 | 130.8456 | 2021-03-18 05:26:22 | Northern Territory, Australia | ||
702102 | 702102 | 2021-03-16 | Australia | Northern Territory | 106 | 0 | 105 | 1 | -12.4634 | 130.8456 | 2021-03-17 05:25:07 | Northern Territory, Australia | ||
2207351 | 2207351 | 2021-03-04 | Australia | Northern Territory | 105 | 0 | 104 | 1 | -12.4634 | 130.8456 | 2021-03-05 05:26:29 | Northern Territory, Australia | ||
1089772 | 1089772 | 2021-03-03 | Australia | Northern Territory | 105 | 0 | 104 | 1 | -12.4634 | 130.8456 | 2021-03-04 05:24:24 | Northern Territory, Australia | ||
1857702 | 1857702 | 2021-02-25 | Australia | Northern Territory | 104 | 0 | 103 | 1 | -12.4634 | 130.8456 | 2021-02-26 05:22:40 | Northern Territory, Australia | ||
790081 | 790081 | 2021-02-04 | Australia | Northern Territory | 99 | 0 | 98 | 1 | -12.4634 | 130.8456 | 2021-02-05 05:22:38 | Northern Territory, Australia | ||
339973 | 339973 | 2021-02-03 | Australia | Northern Territory | 99 | 0 | 98 | 1 | -12.4634 | 130.8456 | 2021-02-04 05:22:26 | Northern Territory, Australia | ||
1684199 | 1684199 | 2021-02-02 | Australia | Northern Territory | 98 | 0 | 97 | 1 | -12.4634 | 130.8456 | 2021-02-03 05:22:52 | Northern Territory, Australia | ||
1928466 | 1928466 | 2020-07-30 | Australia | Northern Territory | 31 | 0 | 30 | 1 | -12.4634 | 130.8456 | 2020-07-31 04:35:18 | Northern Territory, Australia | ||
2958634 | 2958634 | 2020-07-29 | Australia | Northern Territory | 31 | 0 | 30 | 1 | -12.4634 | 130.8456 | 2020-07-30 04:35:05 | Northern Territory, Australia | ||
3185250 | 3185250 | 2020-07-28 | Australia | Northern Territory | 31 | 0 | 30 | 1 | -12.4634 | 130.8456 | 2020-07-29 04:35:11 | Northern Territory, Australia | ||
177301 | 177301 | 2020-07-27 | Australia | Northern Territory | 31 | 0 | 30 | 1 | -12.4634 | 130.8456 | 2020-07-28 04:58:43 | Northern Territory, Australia | ||
442614 | 442614 | 2020-07-26 | Australia | Northern Territory | 31 | 0 | 30 | 1 | -12.4634 | 130.8456 | 2020-07-27 04:35:02 | Northern Territory, Australia | ||
1502858 | 1502858 | 2020-07-25 | Australia | Northern Territory | 31 | 0 | 30 | 1 | -12.4634 | 130.8456 | 2020-07-26 04:35:00 | Northern Territory, Australia | ||
2563828 | 2563828 | 2020-07-24 | Australia | Northern Territory | 31 | 0 | 30 | 1 | -12.4634 | 130.8456 | 2020-07-25 04:47:39 | Northern Territory, Australia | ||
62042 | 62042 | 2020-07-23 | Australia | Northern Territory | 31 | 0 | 30 | 1 | -12.4634 | 130.8456 | 2020-07-24 05:30:40 | Northern Territory, Australia | ||
844848 | 844848 | 2020-07-22 | Australia | Northern Territory | 31 | 0 | 30 | 1 | -12.4634 | 130.8456 | 2020-07-23 05:15:04 | Northern Territory, Australia | ||
1707587 | 1707587 | 2020-07-21 | Australia | Northern Territory | 31 | 0 | 30 | 1 | -12.4634 | 130.8456 | 2020-07-22 04:34:42 | Northern Territory, Australia | ||
2222794 | 2222794 | 2020-07-08 | Australia | Northern Territory | 30 | 0 | 29 | 1 | -12.4634 | 130.8456 | 2020-07-09 04:34:23 | Northern Territory, Australia | ||
887403 | 887403 | 2020-07-07 | Australia | Northern Territory | 30 | 0 | 29 | 1 | -12.4634 | 130.8456 | 2020-07-08 05:33:48 | Northern Territory, Australia | ||
2684963 | 2684963 | 2020-07-06 | Australia | Northern Territory | 30 | 0 | 29 | 1 | -12.4634 | 130.8456 | 2020-07-07 04:34:00 | Northern Territory, Australia | ||
415428 | 415428 | 2020-07-05 | Australia | Northern Territory | 30 | 0 | 29 | 1 | -12.4634 | 130.8456 | 2020-07-06 04:33:57 | Northern Territory, Australia | ||
529990 | 529990 | 2020-07-04 | Australia | Northern Territory | 30 | 0 | 29 | 1 | -12.4634 | 130.8456 | 2020-07-05 04:33:46 | Northern Territory, Australia | ||
2234651 | 2234651 | 2020-07-03 | Australia | Northern Territory | 30 | 0 | 29 | 1 | -12.4634 | 130.8456 | 2020-07-04 04:33:51 | Northern Territory, Australia | ||
3045445 | 3045445 | 2020-07-02 | Australia | Northern Territory | 30 | 0 | 29 | 1 | -12.4634 | 130.8456 | 2020-07-03 04:33:54 | Northern Territory, Australia | ||
303136 | 303136 | 2020-07-01 | Australia | Northern Territory | 30 | 0 | 29 | 1 | -12.4634 | 130.8456 | 2020-07-02 04:33:46 | Northern Territory, 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]);