johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
21 rows where deaths = 52 and province_or_state = "Northern Territory" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2239081 | 2239081 | 2022-06-28 | Australia | Northern Territory | 77720 | 52 | 0 | -12.4634 | 130.8456 | 2022-06-29 04:20:59 | Northern Territory, Australia | |||
2147323 | 2147323 | 2022-06-27 | Australia | Northern Territory | 77419 | 52 | 0 | -12.4634 | 130.8456 | 2022-06-28 04:20:58 | Northern Territory, Australia | |||
475124 | 475124 | 2022-06-26 | Australia | Northern Territory | 77419 | 52 | 0 | -12.4634 | 130.8456 | 2022-06-27 04:21:00 | Northern Territory, Australia | |||
938499 | 938499 | 2022-06-25 | Australia | Northern Territory | 77210 | 52 | 0 | -12.4634 | 130.8456 | 2022-06-26 04:21:02 | Northern Territory, Australia | |||
3346319 | 3346319 | 2022-06-24 | Australia | Northern Territory | 76993 | 52 | 0 | -12.4634 | 130.8456 | 2022-06-25 04:20:57 | Northern Territory, Australia | |||
1648060 | 1648060 | 2022-06-23 | Australia | Northern Territory | 76541 | 52 | 0 | -12.4634 | 130.8456 | 2022-06-24 04:20:58 | Northern Territory, Australia | |||
2187295 | 2187295 | 2022-06-22 | Australia | Northern Territory | 76541 | 52 | 0 | -12.4634 | 130.8456 | 2022-06-23 04:20:55 | Northern Territory, Australia | |||
165726 | 165726 | 2022-06-21 | Australia | Northern Territory | 76283 | 52 | 0 | -12.4634 | 130.8456 | 2022-06-22 04:20:54 | Northern Territory, Australia | |||
1763009 | 1763009 | 2022-06-20 | Australia | Northern Territory | 76039 | 52 | 0 | -12.4634 | 130.8456 | 2022-06-21 04:20:56 | Northern Territory, Australia | |||
3269195 | 3269195 | 2022-06-19 | Australia | Northern Territory | 75814 | 52 | 0 | -12.4634 | 130.8456 | 2022-06-20 04:21:01 | Northern Territory, Australia | |||
3397107 | 3397107 | 2022-06-18 | Australia | Northern Territory | 75649 | 52 | 0 | -12.4634 | 130.8456 | 2022-06-19 04:20:51 | Northern Territory, Australia | |||
2310984 | 2310984 | 2022-06-17 | Australia | Northern Territory | 75469 | 52 | 0 | -12.4634 | 130.8456 | 2022-06-18 04:21:10 | Northern Territory, Australia | |||
558488 | 558488 | 2022-06-16 | Australia | Northern Territory | 74982 | 52 | 0 | -12.4634 | 130.8456 | 2022-06-17 04:20:56 | Northern Territory, Australia | |||
3982290 | 3982290 | 2022-06-15 | Australia | Northern Territory | 74722 | 52 | 0 | -12.4634 | 130.8456 | 2022-06-16 04:20:55 | Northern Territory, Australia | |||
946531 | 946531 | 2022-06-14 | Australia | Northern Territory | 74722 | 52 | 0 | -12.4634 | 130.8456 | 2022-06-15 04:20:54 | Northern Territory, Australia | |||
2978939 | 2978939 | 2022-06-13 | Australia | Northern Territory | 74485 | 52 | 0 | -12.4634 | 130.8456 | 2022-06-14 04:20:52 | Northern Territory, Australia | |||
2235065 | 2235065 | 2022-06-12 | Australia | Northern Territory | 74317 | 52 | 0 | -12.4634 | 130.8456 | 2022-06-13 04:21:14 | Northern Territory, Australia | |||
3141263 | 3141263 | 2022-06-11 | Australia | Northern Territory | 74209 | 52 | 0 | -12.4634 | 130.8456 | 2022-06-12 04:20:53 | Northern Territory, Australia | |||
1944179 | 1944179 | 2022-06-10 | Australia | Northern Territory | 74046 | 52 | 0 | -12.4634 | 130.8456 | 2022-06-11 04:21:01 | Northern Territory, Australia | |||
3157318 | 3157318 | 2022-06-09 | Australia | Northern Territory | 73665 | 52 | 0 | -12.4634 | 130.8456 | 2022-06-10 04:20:55 | Northern Territory, Australia | |||
1420785 | 1420785 | 2022-06-08 | Australia | Northern Territory | 73665 | 52 | 0 | -12.4634 | 130.8456 | 2022-06-09 04:20:54 | 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]);