johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
68 rows where country_or_region = "Malaysia", deaths = 192 and province_or_state = "Perlis" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2438802 | 2438802 | 2022-11-07 | Malaysia | Perlis | 18637 | 192 | 0 | 6.4449 | 100.2048 | 2022-11-08 04:21:21 | Perlis, Malaysia | |||
1049900 | 1049900 | 2022-11-06 | Malaysia | Perlis | 18632 | 192 | 0 | 6.4449 | 100.2048 | 2022-11-07 04:21:26 | Perlis, Malaysia | |||
617924 | 617924 | 2022-11-05 | Malaysia | Perlis | 18629 | 192 | 0 | 6.4449 | 100.2048 | 2022-11-06 04:21:24 | Perlis, Malaysia | |||
1022428 | 1022428 | 2022-11-04 | Malaysia | Perlis | 18622 | 192 | 0 | 6.4449 | 100.2048 | 2022-11-05 04:21:52 | Perlis, Malaysia | |||
431419 | 431419 | 2022-11-03 | Malaysia | Perlis | 18617 | 192 | 0 | 6.4449 | 100.2048 | 2022-11-04 04:22:11 | Perlis, Malaysia | |||
849661 | 849661 | 2022-11-02 | Malaysia | Perlis | 18612 | 192 | 0 | 6.4449 | 100.2048 | 2022-11-03 04:22:05 | Perlis, Malaysia | |||
710512 | 710512 | 2022-11-01 | Malaysia | Perlis | 18609 | 192 | 0 | 6.4449 | 100.2048 | 2022-11-02 04:22:09 | Perlis, Malaysia | |||
3284961 | 3284961 | 2022-10-31 | Malaysia | Perlis | 18607 | 192 | 0 | 6.4449 | 100.2048 | 2022-11-01 04:22:36 | Perlis, Malaysia | |||
319994 | 319994 | 2022-10-30 | Malaysia | Perlis | 18605 | 192 | 0 | 6.4449 | 100.2048 | 2022-10-31 04:21:36 | Perlis, Malaysia | |||
912270 | 912270 | 2022-10-29 | Malaysia | Perlis | 18598 | 192 | 0 | 6.4449 | 100.2048 | 2022-10-30 04:22:14 | Perlis, Malaysia | |||
1366539 | 1366539 | 2022-10-28 | Malaysia | Perlis | 18594 | 192 | 0 | 6.4449 | 100.2048 | 2022-10-29 04:21:13 | Perlis, Malaysia | |||
3038394 | 3038394 | 2022-10-27 | Malaysia | Perlis | 18586 | 192 | 0 | 6.4449 | 100.2048 | 2022-10-28 04:22:31 | Perlis, Malaysia | |||
538814 | 538814 | 2022-10-26 | Malaysia | Perlis | 18577 | 192 | 0 | 6.4449 | 100.2048 | 2022-10-27 04:22:01 | Perlis, Malaysia | |||
1830215 | 1830215 | 2022-10-25 | Malaysia | Perlis | 18572 | 192 | 0 | 6.4449 | 100.2048 | 2022-10-26 04:22:19 | Perlis, Malaysia | |||
794476 | 794476 | 2022-10-24 | Malaysia | Perlis | 18568 | 192 | 0 | 6.4449 | 100.2048 | 2022-10-25 04:21:53 | Perlis, Malaysia | |||
3276931 | 3276931 | 2022-10-23 | Malaysia | Perlis | 18561 | 192 | 0 | 6.4449 | 100.2048 | 2022-10-24 04:22:29 | Perlis, Malaysia | |||
2267969 | 2267969 | 2022-10-22 | Malaysia | Perlis | 18555 | 192 | 0 | 6.4449 | 100.2048 | 2022-10-23 04:22:46 | Perlis, Malaysia | |||
1592269 | 1592269 | 2022-10-21 | Malaysia | Perlis | 18545 | 192 | 0 | 6.4449 | 100.2048 | 2022-10-22 04:22:53 | Perlis, Malaysia | |||
2271985 | 2271985 | 2022-10-20 | Malaysia | Perlis | 18536 | 192 | 0 | 6.4449 | 100.2048 | 2022-10-21 04:22:23 | Perlis, Malaysia | |||
198320 | 198320 | 2022-10-19 | Malaysia | Perlis | 18532 | 192 | 0 | 6.4449 | 100.2048 | 2022-10-20 04:22:59 | Perlis, Malaysia | |||
2756981 | 2756981 | 2022-10-18 | Malaysia | Perlis | 18526 | 192 | 0 | 6.4449 | 100.2048 | 2022-10-19 04:22:26 | Perlis, Malaysia | |||
2024815 | 2024815 | 2022-10-17 | Malaysia | Perlis | 18519 | 192 | 0 | 6.4449 | 100.2048 | 2022-10-18 04:22:42 | Perlis, Malaysia | |||
2159593 | 2159593 | 2022-10-16 | Malaysia | Perlis | 18518 | 192 | 0 | 6.4449 | 100.2048 | 2022-10-17 04:20:31 | Perlis, Malaysia | |||
515790 | 515790 | 2022-10-15 | Malaysia | Perlis | 18513 | 192 | 0 | 6.4449 | 100.2048 | 2022-10-16 04:22:39 | Perlis, Malaysia | |||
2032847 | 2032847 | 2022-10-14 | Malaysia | Perlis | 18509 | 192 | 0 | 6.4449 | 100.2048 | 2022-10-15 04:22:00 | Perlis, Malaysia | |||
3753535 | 3753535 | 2022-10-13 | Malaysia | Perlis | 18505 | 192 | 0 | 6.4449 | 100.2048 | 2022-10-14 04:22:28 | Perlis, Malaysia | |||
3214360 | 3214360 | 2022-10-12 | Malaysia | Perlis | 18499 | 192 | 0 | 6.4449 | 100.2048 | 2022-10-13 04:22:39 | Perlis, Malaysia | |||
3250209 | 3250209 | 2022-10-11 | Malaysia | Perlis | 18499 | 192 | 0 | 6.4449 | 100.2048 | 2022-10-12 04:22:51 | Perlis, Malaysia | |||
2967468 | 2967468 | 2022-10-10 | Malaysia | Perlis | 18498 | 192 | 0 | 6.4449 | 100.2048 | 2022-10-11 04:23:05 | Perlis, Malaysia | |||
3097504 | 3097504 | 2022-10-09 | Malaysia | Perlis | 18498 | 192 | 0 | 6.4449 | 100.2048 | 2022-10-10 04:22:32 | Perlis, Malaysia | |||
4002729 | 4002729 | 2022-10-08 | Malaysia | Perlis | 18496 | 192 | 0 | 6.4449 | 100.2048 | 2022-10-09 04:21:16 | Perlis, Malaysia | |||
396326 | 396326 | 2022-10-07 | Malaysia | Perlis | 18493 | 192 | 0 | 6.4449 | 100.2048 | 2022-10-08 04:22:56 | Perlis, Malaysia | |||
2529443 | 2529443 | 2022-10-06 | Malaysia | Perlis | 18487 | 192 | 0 | 6.4449 | 100.2048 | 2022-10-07 04:23:08 | Perlis, Malaysia | |||
1810837 | 1810837 | 2022-10-05 | Malaysia | Perlis | 18479 | 192 | 0 | 6.4449 | 100.2048 | 2022-10-06 04:21:22 | Perlis, Malaysia | |||
130811 | 130811 | 2022-10-04 | Malaysia | Perlis | 18476 | 192 | 0 | 6.4449 | 100.2048 | 2022-10-05 04:23:06 | Perlis, Malaysia | |||
2685758 | 2685758 | 2022-10-03 | Malaysia | Perlis | 18471 | 192 | 0 | 6.4449 | 100.2048 | 2022-10-04 04:22:55 | Perlis, Malaysia | |||
2259825 | 2259825 | 2022-10-02 | Malaysia | Perlis | 18466 | 192 | 0 | 6.4449 | 100.2048 | 2022-10-03 04:23:11 | Perlis, Malaysia | |||
2995351 | 2995351 | 2022-10-01 | Malaysia | Perlis | 18480 | 192 | 0 | 6.4449 | 100.2048 | 2022-10-02 04:21:23 | Perlis, Malaysia | |||
853677 | 853677 | 2022-09-30 | Malaysia | Perlis | 18459 | 192 | 0 | 6.4449 | 100.2048 | 2022-10-01 04:23:01 | Perlis, Malaysia | |||
2375603 | 2375603 | 2022-09-29 | Malaysia | Perlis | 18454 | 192 | 0 | 6.4449 | 100.2048 | 2022-09-30 04:23:09 | Perlis, Malaysia | |||
1560154 | 1560154 | 2022-09-28 | Malaysia | Perlis | 18450 | 192 | 0 | 6.4449 | 100.2048 | 2022-09-29 04:22:34 | Perlis, Malaysia | |||
3994697 | 3994697 | 2022-09-27 | Malaysia | Perlis | 18448 | 192 | 0 | 6.4449 | 100.2048 | 2022-09-28 04:23:01 | Perlis, Malaysia | |||
2769025 | 2769025 | 2022-09-26 | Malaysia | Perlis | 18445 | 192 | 0 | 6.4449 | 100.2048 | 2022-09-27 04:23:01 | Perlis, Malaysia | |||
1976678 | 1976678 | 2022-09-25 | Malaysia | Perlis | 18437 | 192 | 0 | 6.4449 | 100.2048 | 2022-09-26 04:20:52 | Perlis, Malaysia | |||
2649845 | 2649845 | 2022-09-24 | Malaysia | Perlis | 18426 | 192 | 0 | 6.4449 | 100.2048 | 2022-09-25 04:23:31 | Perlis, Malaysia | |||
384285 | 384285 | 2022-09-23 | Malaysia | Perlis | 18421 | 192 | 0 | 6.4449 | 100.2048 | 2022-09-24 04:21:40 | Perlis, Malaysia | |||
1624351 | 1624351 | 2022-09-22 | Malaysia | Perlis | 18415 | 192 | 0 | 6.4449 | 100.2048 | 2022-09-23 04:23:13 | Perlis, Malaysia | |||
1370555 | 1370555 | 2022-09-21 | Malaysia | Perlis | 18406 | 192 | 0 | 6.4449 | 100.2048 | 2022-09-22 04:22:56 | Perlis, Malaysia | |||
2016785 | 2016785 | 2022-09-20 | Malaysia | Perlis | 18396 | 192 | 0 | 6.4449 | 100.2048 | 2022-09-21 04:23:22 | Perlis, Malaysia | |||
3570658 | 3570658 | 2022-09-19 | Malaysia | Perlis | 18389 | 192 | 0 | 6.4449 | 100.2048 | 2022-09-20 04:22:48 | Perlis, Malaysia | |||
419397 | 419397 | 2022-09-18 | Malaysia | Perlis | 18384 | 192 | 0 | 6.4449 | 100.2048 | 2022-09-19 04:21:49 | Perlis, Malaysia | |||
3373421 | 3373421 | 2022-09-17 | Malaysia | Perlis | 18383 | 192 | 0 | 6.4449 | 100.2048 | 2022-09-18 04:22:50 | Perlis, Malaysia | |||
2355529 | 2355529 | 2022-09-16 | Malaysia | Perlis | 18376 | 192 | 0 | 6.4449 | 100.2048 | 2022-09-17 04:20:19 | Perlis, Malaysia | |||
3986686 | 3986686 | 2022-09-15 | Malaysia | Perlis | 18359 | 192 | 0 | 6.4449 | 100.2048 | 2022-09-16 04:21:19 | Perlis, Malaysia | |||
1889203 | 1889203 | 2022-09-14 | Malaysia | Perlis | 18350 | 192 | 0 | 6.4449 | 100.2048 | 2022-09-15 04:21:02 | Perlis, Malaysia | |||
372258 | 372258 | 2022-09-13 | Malaysia | Perlis | 18341 | 192 | 0 | 6.4449 | 100.2048 | 2022-09-14 04:20:44 | Perlis, Malaysia | |||
2394863 | 2394863 | 2022-09-12 | Malaysia | Perlis | 18334 | 192 | 0 | 6.4449 | 100.2048 | 2022-09-13 04:20:57 | Perlis, Malaysia | |||
3765941 | 3765941 | 2022-09-11 | Malaysia | Perlis | 18318 | 192 | 0 | 6.4449 | 100.2048 | 2022-09-12 04:20:58 | Perlis, Malaysia | |||
3824516 | 3824516 | 2022-09-10 | Malaysia | Perlis | 18306 | 192 | 0 | 6.4449 | 100.2048 | 2022-09-11 04:20:50 | Perlis, Malaysia | |||
962973 | 962973 | 2022-09-09 | Malaysia | Perlis | 18286 | 192 | 0 | 6.4449 | 100.2048 | 2022-09-10 04:21:10 | Perlis, Malaysia | |||
253375 | 253375 | 2022-09-08 | Malaysia | Perlis | 18278 | 192 | 0 | 6.4449 | 100.2048 | 2022-09-09 04:21:11 | Perlis, Malaysia | |||
3745173 | 3745173 | 2022-09-07 | Malaysia | Perlis | 18271 | 192 | 0 | 6.4449 | 100.2048 | 2022-09-08 04:21:02 | Perlis, Malaysia | |||
114813 | 114813 | 2022-09-06 | Malaysia | Perlis | 18260 | 192 | 0 | 6.4449 | 100.2048 | 2022-09-07 04:20:59 | Perlis, Malaysia | |||
2633785 | 2633785 | 2022-09-05 | Malaysia | Perlis | 18257 | 192 | 0 | 6.4449 | 100.2048 | 2022-09-06 04:21:02 | Perlis, Malaysia | |||
2987349 | 2987349 | 2022-09-04 | Malaysia | Perlis | 18250 | 192 | 0 | 6.4449 | 100.2048 | 2022-09-05 04:21:01 | Perlis, Malaysia | |||
2713034 | 2713034 | 2022-09-03 | Malaysia | Perlis | 18240 | 192 | 0 | 6.4449 | 100.2048 | 2022-09-04 04:21:22 | Perlis, Malaysia | |||
1393739 | 1393739 | 2022-09-02 | Malaysia | Perlis | 18234 | 192 | 0 | 6.4449 | 100.2048 | 2022-09-03 04:21:04 | Perlis, Malaysia | |||
3547568 | 3547568 | 2022-09-01 | Malaysia | Perlis | 18225 | 192 | 0 | 6.4449 | 100.2048 | 2022-09-02 04:21:07 | Perlis, 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]);