johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
35 rows where country_or_region = "Malaysia", deaths = 5 and province_or_state = "Sabah" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: active, last_update (date)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2864381 | 2864381 | 2020-06-10 | Malaysia | Sabah | 356 | 5 | 325 | 26 | 5.9788 | 116.0753 | 2020-06-11 03:33:41 | Sabah, Malaysia | ||
1211200 | 1211200 | 2020-06-09 | Malaysia | Sabah | 356 | 5 | 324 | 27 | 5.9788 | 116.0753 | 2020-06-10 04:07:00 | Sabah, Malaysia | ||
217627 | 217627 | 2020-06-08 | Malaysia | Sabah | 356 | 5 | 324 | 27 | 5.9788 | 116.0753 | 2020-06-09 03:33:03 | Sabah, Malaysia | ||
2800424 | 2800424 | 2020-06-07 | Malaysia | Sabah | 354 | 5 | 324 | 25 | 5.9788 | 116.0753 | 2020-06-08 03:33:22 | Sabah, Malaysia | ||
574480 | 574480 | 2020-06-06 | Malaysia | Sabah | 352 | 5 | 324 | 23 | 5.9788 | 116.0753 | 2020-06-07 03:53:30 | Sabah, Malaysia | ||
1270177 | 1270177 | 2020-06-05 | Malaysia | Sabah | 352 | 5 | 323 | 24 | 5.9788 | 116.0753 | 2020-06-06 02:33:00 | Sabah, Malaysia | ||
1281638 | 1281638 | 2020-06-04 | Malaysia | Sabah | 349 | 5 | 322 | 22 | 5.9788 | 116.0753 | 2020-06-05 02:33:06 | Sabah, Malaysia | ||
3867193 | 3867193 | 2020-06-03 | Malaysia | Sabah | 349 | 5 | 320 | 24 | 5.9788 | 116.0753 | 2020-06-04 02:33:14 | Sabah, Malaysia | ||
2556235 | 2556235 | 2020-06-02 | Malaysia | Sabah | 349 | 5 | 320 | 24 | 5.9788 | 116.0753 | 2020-06-03 02:33:13 | Sabah, Malaysia | ||
805772 | 805772 | 2020-06-01 | Malaysia | Sabah | 348 | 5 | 320 | 23 | 5.9788 | 116.0753 | 2020-06-02 02:33:08 | Sabah, Malaysia | ||
1794308 | 1794308 | 2020-05-31 | Malaysia | Sabah | 347 | 5 | 317 | 25 | 5.9788 | 116.0753 | 2020-06-01 02:32:46 | Sabah, Malaysia | ||
3639201 | 3639201 | 2020-05-30 | Malaysia | Sabah | 347 | 5 | 314 | 28 | 5.9788 | 116.0753 | 2020-05-31 02:32:45 | Sabah, Malaysia | ||
1790741 | 1790741 | 2020-05-29 | Malaysia | Sabah | 347 | 5 | 307 | 35 | 5.9788 | 116.0753 | 2020-05-30 02:32:48 | Sabah, Malaysia | ||
2712620 | 2712620 | 2020-05-28 | Malaysia | Sabah | 345 | 5 | 304 | 36 | 5.9788 | 116.0753 | 2020-05-29 02:32:50 | Sabah, Malaysia | ||
2548539 | 2548539 | 2020-05-27 | Malaysia | Sabah | 345 | 5 | 296 | 44 | 5.9788 | 116.0753 | 2020-05-28 02:32:31 | Sabah, Malaysia | ||
1041502 | 1041502 | 2020-05-26 | Malaysia | Sabah | 344 | 5 | 296 | 43 | 5.9788 | 116.0753 | 2020-05-27 02:32:31 | Sabah, Malaysia | ||
1105232 | 1105232 | 2020-05-25 | Malaysia | Sabah | 344 | 5 | 295 | 44 | 5.9788 | 116.0753 | 2020-05-26 02:32:35 | Sabah, Malaysia | ||
875912 | 875912 | 2020-05-24 | Malaysia | Sabah | 344 | 5 | 295 | 44 | 5.9788 | 116.0753 | 2020-05-25 02:32:44 | Sabah, Malaysia | ||
998103 | 998103 | 2020-05-23 | Malaysia | Sabah | 342 | 5 | 295 | 42 | 5.9788 | 116.0753 | 2020-05-24 02:32:43 | Sabah, Malaysia | ||
1865126 | 1865126 | 2020-05-22 | Malaysia | Sabah | 341 | 5 | 295 | 41 | 5.9788 | 116.0753 | 2020-05-23 02:32:42 | Sabah, Malaysia | ||
268632 | 268632 | 2020-05-21 | Malaysia | Sabah | 339 | 5 | 294 | 40 | 5.9788 | 116.0753 | 2020-05-22 02:36:51 | Sabah, Malaysia | ||
1432215 | 1432215 | 2020-05-20 | Malaysia | Sabah | 339 | 5 | 293 | 41 | 5.9788 | 116.0753 | 2020-05-21 02:32:48 | Sabah, Malaysia | ||
2390435 | 2390435 | 2020-05-19 | Malaysia | Sabah | 338 | 5 | 293 | 40 | 5.9788 | 116.0753 | 2020-05-20 02:32:19 | Sabah, Malaysia | ||
3261173 | 3261173 | 2020-05-18 | Malaysia | Sabah | 332 | 5 | 293 | 34 | 5.9788 | 116.0753 | 2020-05-19 02:32:18 | Sabah, Malaysia | ||
3416567 | 3416567 | 2020-05-17 | Malaysia | Sabah | 332 | 5 | 292 | 35 | 5.9788 | 116.0753 | 2020-05-18 02:32:21 | Sabah, Malaysia | ||
1829801 | 1829801 | 2020-05-16 | Malaysia | Sabah | 332 | 5 | 291 | 36 | 5.9788 | 116.0753 | 2020-05-17 02:32:32 | Sabah, Malaysia | ||
3276517 | 3276517 | 2020-05-15 | Malaysia | Sabah | 331 | 5 | 291 | 35 | 5.9788 | 116.0753 | 2020-05-16 02:32:19 | Sabah, Malaysia | ||
1404691 | 1404691 | 2020-05-14 | Malaysia | Sabah | 331 | 5 | 289 | 37 | 5.9788 | 116.0753 | 2020-05-15 02:33:02 | Sabah, Malaysia | ||
3847454 | 3847454 | 2020-05-13 | Malaysia | Sabah | 331 | 5 | 289 | 37 | 5.9788 | 116.0753 | 2020-05-14 03:32:28 | Sabah, Malaysia | ||
2581660 | 2581660 | 2020-05-12 | Malaysia | Sabah | 329 | 5 | 289 | 35 | 5.9788 | 116.0753 | 2020-05-13 03:32:26 | Sabah, Malaysia | ||
3331194 | 3331194 | 2020-05-11 | Malaysia | Sabah | 328 | 5 | 288 | 35 | 5.9788 | 116.0753 | 2020-05-12 03:32:27 | Sabah, Malaysia | ||
3459809 | 3459809 | 2020-05-10 | Malaysia | Sabah | 318 | 5 | 281 | 32 | 5.9788 | 116.0753 | 2020-05-11 02:32:30 | Sabah, Malaysia | ||
2899350 | 2899350 | 2020-05-09 | Malaysia | Sabah | 318 | 5 | 281 | 32 | 5.9788 | 116.0753 | 2020-05-10 02:32:30 | Sabah, Malaysia | ||
114399 | 114399 | 2020-05-08 | Malaysia | Sabah | 318 | 5 | 275 | 38 | 5.9788 | 116.0753 | 2020-05-09 02:32:35 | Sabah, Malaysia | ||
3295842 | 3295842 | 2020-05-07 | Malaysia | Sabah | 318 | 5 | 273 | 40 | 5.9788 | 116.0753 | 2020-05-08 02:32:32 | Sabah, 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]);