johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
33 rows where active = 2 and province_or_state = "W.P. Labuan" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, recovered, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2816428 | 2816428 | 2020-09-25 | Malaysia | W.P. Labuan | 25 | 0 | 23 | 2 | 5.2831 | 115.2308 | 2020-09-26 04:23:00 | W.P. Labuan, Malaysia | ||
2609705 | 2609705 | 2020-09-24 | Malaysia | W.P. Labuan | 25 | 0 | 23 | 2 | 5.2831 | 115.2308 | 2020-09-25 04:23:00 | W.P. Labuan, Malaysia | ||
2657448 | 2657448 | 2020-09-23 | Malaysia | W.P. Labuan | 25 | 0 | 23 | 2 | 5.2831 | 115.2308 | 2020-09-24 04:23:00 | W.P. Labuan, Malaysia | ||
3319897 | 3319897 | 2020-09-22 | Malaysia | W.P. Labuan | 25 | 0 | 23 | 2 | 5.2831 | 115.2308 | 2020-09-23 04:23:00 | W.P. Labuan, Malaysia | ||
2840496 | 2840496 | 2020-09-21 | Malaysia | W.P. Labuan | 25 | 0 | 23 | 2 | 5.2831 | 115.2308 | 2020-09-22 04:23:00 | W.P. Labuan, Malaysia | ||
3097099 | 3097099 | 2020-09-20 | Malaysia | W.P. Labuan | 25 | 0 | 23 | 2 | 5.2831 | 115.2308 | 2020-09-21 04:23:00 | W.P. Labuan, Malaysia | ||
197745 | 197745 | 2020-08-31 | Malaysia | W.P. Labuan | 23 | 0 | 21 | 2 | 5.2831 | 115.2308 | 2020-09-01 04:28:31 | W.P. Labuan, Malaysia | ||
3935700 | 3935700 | 2020-08-30 | Malaysia | W.P. Labuan | 23 | 0 | 21 | 2 | 5.2831 | 115.2308 | 2020-08-31 04:28:27 | W.P. Labuan, Malaysia | ||
613362 | 613362 | 2020-08-29 | Malaysia | W.P. Labuan | 23 | 0 | 21 | 2 | 5.2831 | 115.2308 | 2020-08-30 04:28:22 | W.P. Labuan, Malaysia | ||
1526857 | 1526857 | 2020-08-28 | Malaysia | W.P. Labuan | 23 | 0 | 21 | 2 | 5.2831 | 115.2308 | 2020-08-29 04:28:19 | W.P. Labuan, Malaysia | ||
2513858 | 2513858 | 2020-08-27 | Malaysia | W.P. Labuan | 23 | 0 | 21 | 2 | 5.2831 | 115.2308 | 2020-08-28 04:28:11 | W.P. Labuan, Malaysia | ||
2000318 | 2000318 | 2020-08-26 | Malaysia | W.P. Labuan | 23 | 0 | 21 | 2 | 5.2831 | 115.2308 | 2020-08-27 04:28:15 | W.P. Labuan, Malaysia | ||
3566242 | 3566242 | 2020-08-25 | Malaysia | W.P. Labuan | 23 | 0 | 21 | 2 | 5.2831 | 115.2308 | 2020-08-26 04:28:11 | W.P. Labuan, Malaysia | ||
2994946 | 2994946 | 2020-08-24 | Malaysia | W.P. Labuan | 23 | 0 | 21 | 2 | 5.2831 | 115.2308 | 2020-08-25 04:28:02 | W.P. Labuan, Malaysia | ||
2219341 | 2219341 | 2020-08-23 | Malaysia | W.P. Labuan | 23 | 0 | 21 | 2 | 5.2831 | 115.2308 | 2020-08-24 04:27:56 | W.P. Labuan, Malaysia | ||
2303123 | 2303123 | 2020-08-22 | Malaysia | W.P. Labuan | 23 | 0 | 21 | 2 | 5.2831 | 115.2308 | 2020-08-23 04:27:48 | W.P. Labuan, Malaysia | ||
1483229 | 1483229 | 2020-08-21 | Malaysia | W.P. Labuan | 23 | 0 | 21 | 2 | 5.2831 | 115.2308 | 2020-08-22 04:27:49 | W.P. Labuan, Malaysia | ||
3487978 | 3487978 | 2020-08-20 | Malaysia | W.P. Labuan | 23 | 0 | 21 | 2 | 5.2831 | 115.2308 | 2020-08-21 04:27:41 | W.P. Labuan, Malaysia | ||
3181679 | 3181679 | 2020-08-18 | Malaysia | W.P. Labuan | 22 | 0 | 20 | 2 | 5.2831 | 115.2308 | 2020-08-19 04:27:00 | W.P. Labuan, Malaysia | ||
841283 | 841283 | 2020-08-17 | Malaysia | W.P. Labuan | 22 | 0 | 20 | 2 | 5.2831 | 115.2308 | 2020-08-18 04:27:56 | W.P. Labuan, Malaysia | ||
2808421 | 2808421 | 2020-08-02 | Malaysia | W.P. Labuan | 19 | 0 | 17 | 2 | 5.2831 | 115.2308 | 2020-08-03 04:34:35 | W.P. Labuan, Malaysia | ||
753989 | 753989 | 2020-08-01 | Malaysia | W.P. Labuan | 19 | 0 | 17 | 2 | 5.2831 | 115.2308 | 2020-08-02 04:34:47 | W.P. Labuan, Malaysia | ||
3265154 | 3265154 | 2020-07-31 | Malaysia | W.P. Labuan | 19 | 0 | 17 | 2 | 5.2831 | 115.2308 | 2020-08-01 04:36:27 | W.P. Labuan, Malaysia | ||
1928863 | 1928863 | 2020-07-30 | Malaysia | W.P. Labuan | 19 | 0 | 17 | 2 | 5.2831 | 115.2308 | 2020-07-31 04:35:18 | W.P. Labuan, Malaysia | ||
2959031 | 2959031 | 2020-07-29 | Malaysia | W.P. Labuan | 19 | 0 | 17 | 2 | 5.2831 | 115.2308 | 2020-07-30 04:35:05 | W.P. Labuan, Malaysia | ||
3185648 | 3185648 | 2020-07-28 | Malaysia | W.P. Labuan | 19 | 0 | 17 | 2 | 5.2831 | 115.2308 | 2020-07-29 04:35:11 | W.P. Labuan, Malaysia | ||
1184398 | 1184398 | 2020-05-01 | Malaysia | W.P. Labuan | 16 | 0 | 14 | 2 | 5.2831 | 115.2308 | 2020-05-02 02:32:27 | W.P. Labuan, Malaysia | ||
228879 | 228879 | 2020-04-30 | Malaysia | W.P. Labuan | 16 | 0 | 14 | 2 | 5.2831 | 115.2308 | 2020-05-01 02:32:28 | W.P. Labuan, Malaysia | ||
137624 | 137624 | 2020-04-29 | Malaysia | W.P. Labuan | 16 | 0 | 14 | 2 | 5.2831 | 115.2308 | 2020-04-30 02:32:27 | W.P. Labuan, Malaysia | ||
271838 | 271838 | 2020-04-28 | Malaysia | W.P. Labuan | 16 | 0 | 14 | 2 | 5.2831 | 115.2308 | 2020-04-29 02:32:29 | W.P. Labuan, Malaysia | ||
3589501 | 3589501 | 2020-04-27 | Malaysia | W.P. Labuan | 16 | 0 | 14 | 2 | 5.2831 | 115.2308 | 2020-04-28 02:30:51 | W.P. Labuan, Malaysia | ||
3592679 | 3592679 | 2020-04-26 | Malaysia | W.P. Labuan | 16 | 0 | 14 | 2 | 5.2831 | 115.2308 | 2020-04-27 02:30:52 | W.P. Labuan, Malaysia | ||
3503028 | 3503028 | 2020-04-25 | Malaysia | W.P. Labuan | 16 | 0 | 14 | 2 | 5.2831 | 115.2308 | 2020-04-26 02:30:51 | W.P. Labuan, Malaysia |
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]);