johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
24 rows where country_or_region = "Brunei" and recovered = 145 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, active, day (date), last_update (date)
country_or_region 1
- Brunei · 24 ✖
province_or_state 0
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
74846 | 74846 | 2020-12-03 | Brunei | 151 | 3 | 145 | 3 | 4.5353 | 114.7277 | 2020-12-04 05:27:27 | Brunei | |||
738058 | 738058 | 2020-12-02 | Brunei | 151 | 3 | 145 | 3 | 4.5353 | 114.7277 | 2020-12-03 05:28:22 | Brunei | |||
2537152 | 2537152 | 2020-12-01 | Brunei | 151 | 3 | 145 | 3 | 4.5353 | 114.7277 | 2020-12-02 05:27:41 | Brunei | |||
1583921 | 1583921 | 2020-11-30 | Brunei | 150 | 3 | 145 | 2 | 4.5353 | 114.7277 | 2020-12-01 05:26:18 | Brunei | |||
3566324 | 3566324 | 2020-11-29 | Brunei | 150 | 3 | 145 | 2 | 4.5353 | 114.7277 | 2020-11-30 05:26:13 | Brunei | |||
2934989 | 2934989 | 2020-11-28 | Brunei | 150 | 3 | 145 | 2 | 4.5353 | 114.7277 | 2020-11-29 05:25:55 | Brunei | |||
391992 | 391992 | 2020-11-27 | Brunei | 150 | 3 | 145 | 2 | 4.5353 | 114.7277 | 2020-11-28 05:25:50 | Brunei | |||
923439 | 923439 | 2020-11-26 | Brunei | 150 | 3 | 145 | 2 | 4.5353 | 114.7277 | 2020-11-27 05:26:53 | Brunei | |||
1972344 | 1972344 | 2020-11-25 | Brunei | 150 | 3 | 145 | 2 | 4.5353 | 114.7277 | 2020-11-26 05:27:44 | Brunei | |||
1350075 | 1350075 | 2020-11-24 | Brunei | 150 | 3 | 145 | 2 | 4.5353 | 114.7277 | 2020-11-25 05:27:20 | Brunei | |||
678070 | 678070 | 2020-11-23 | Brunei | 149 | 3 | 145 | 1 | 4.5353 | 114.7277 | 2020-11-24 05:27:31 | Brunei | |||
3189746 | 3189746 | 2020-11-22 | Brunei | 148 | 3 | 145 | 0 | 4.5353 | 114.7277 | 2020-11-23 05:25:26 | Brunei | |||
3836240 | 3836240 | 2020-11-21 | Brunei | 148 | 3 | 145 | 0 | 4.5353 | 114.7277 | 2020-11-22 05:25:45 | Brunei | |||
2701268 | 2701268 | 2020-11-20 | Brunei | 148 | 3 | 145 | 0 | 4.5353 | 114.7277 | 2020-11-21 05:25:51 | Brunei | |||
821328 | 821328 | 2020-11-19 | Brunei | 148 | 3 | 145 | 0 | 4.5353 | 114.7277 | 2020-11-20 05:26:28 | Brunei | |||
122462 | 122462 | 2020-11-18 | Brunei | 148 | 3 | 145 | 0 | 4.5353 | 114.7277 | 2020-11-19 05:25:23 | Brunei | |||
3338350 | 3338350 | 2020-11-17 | Brunei | 148 | 3 | 145 | 0 | 4.5353 | 114.7277 | 2020-11-18 05:40:31 | Brunei | |||
3169395 | 3169395 | 2020-11-16 | Brunei | 148 | 3 | 145 | 0 | 4.5353 | 114.7277 | 2020-11-17 05:25:54 | Brunei | |||
2879963 | 2879963 | 2020-11-15 | Brunei | 148 | 3 | 145 | 0 | 4.5353 | 114.7277 | 2020-11-16 05:25:57 | Brunei | |||
2914941 | 2914941 | 2020-11-14 | Brunei | 148 | 3 | 145 | 0 | 4.5353 | 114.7277 | 2020-11-15 05:26:53 | Brunei | |||
2784763 | 2784763 | 2020-11-13 | Brunei | 148 | 3 | 145 | 0 | 4.5353 | 114.7277 | 2020-11-14 05:25:37 | Brunei | |||
864528 | 864528 | 2020-11-12 | Brunei | 148 | 3 | 145 | 0 | 4.5353 | 114.7277 | 2020-11-13 05:25:30 | Brunei | |||
3440573 | 3440573 | 2020-11-11 | Brunei | 148 | 3 | 145 | 0 | 4.5353 | 114.7277 | 2020-11-12 05:25:55 | Brunei | |||
271913 | 271913 | 2020-11-10 | Brunei | 148 | 3 | 145 | 0 | 4.5353 | 114.7277 | 2020-11-11 05:25:30 | Brunei |
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]);