johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
59 rows where country_or_region = "Malaysia", deaths = 188 and province_or_state = "Perlis" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3908065 | 3908065 | 2022-08-11 | Malaysia | Perlis | 18022 | 188 | 0 | 6.4449 | 100.2048 | 2022-08-12 04:20:54 | Perlis, Malaysia | |||
1346382 | 1346382 | 2022-08-10 | Malaysia | Perlis | 18016 | 188 | 0 | 6.4449 | 100.2048 | 2022-08-11 04:20:49 | Perlis, Malaysia | |||
1086137 | 1086137 | 2022-08-09 | Malaysia | Perlis | 18000 | 188 | 0 | 6.4449 | 100.2048 | 2022-08-10 04:20:57 | Perlis, Malaysia | |||
3543552 | 3543552 | 2022-08-08 | Malaysia | Perlis | 17990 | 188 | 0 | 6.4449 | 100.2048 | 2022-08-09 04:20:34 | Perlis, Malaysia | |||
1069955 | 1069955 | 2022-08-07 | Malaysia | Perlis | 17986 | 188 | 0 | 6.4449 | 100.2048 | 2022-08-08 04:21:08 | Perlis, Malaysia | |||
1940543 | 1940543 | 2022-08-06 | Malaysia | Perlis | 17977 | 188 | 0 | 6.4449 | 100.2048 | 2022-08-07 04:20:54 | Perlis, Malaysia | |||
880342 | 880342 | 2022-08-05 | Malaysia | Perlis | 17965 | 188 | 0 | 6.4449 | 100.2048 | 2022-08-06 04:20:56 | Perlis, Malaysia | |||
2008753 | 2008753 | 2022-08-04 | Malaysia | Perlis | 17953 | 188 | 0 | 6.4449 | 100.2048 | 2022-08-05 04:20:52 | Perlis, Malaysia | |||
1098180 | 1098180 | 2022-08-03 | Malaysia | Perlis | 17932 | 188 | 0 | 6.4449 | 100.2048 | 2022-08-04 04:20:58 | Perlis, Malaysia | |||
1405105 | 1405105 | 2022-08-02 | Malaysia | Perlis | 17908 | 188 | 0 | 6.4449 | 100.2048 | 2022-08-03 04:20:59 | Perlis, Malaysia | |||
3617143 | 3617143 | 2022-08-01 | Malaysia | Perlis | 17896 | 188 | 0 | 6.4449 | 100.2048 | 2022-08-02 04:20:53 | Perlis, Malaysia | |||
3871623 | 3871623 | 2022-07-31 | Malaysia | Perlis | 17890 | 188 | 0 | 6.4449 | 100.2048 | 2022-08-01 04:21:03 | Perlis, Malaysia | |||
674377 | 674377 | 2022-07-30 | Malaysia | Perlis | 17887 | 188 | 0 | 6.4449 | 100.2048 | 2022-07-31 04:21:02 | Perlis, Malaysia | |||
1783576 | 1783576 | 2022-07-29 | Malaysia | Perlis | 17872 | 188 | 0 | 6.4449 | 100.2048 | 2022-07-30 04:20:42 | Perlis, Malaysia | |||
1065939 | 1065939 | 2022-07-28 | Malaysia | Perlis | 17866 | 188 | 0 | 6.4449 | 100.2048 | 2022-07-29 04:20:45 | Perlis, Malaysia | |||
2335458 | 2335458 | 2022-07-27 | Malaysia | Perlis | 17854 | 188 | 0 | 6.4449 | 100.2048 | 2022-07-28 04:20:56 | Perlis, Malaysia | |||
1487648 | 1487648 | 2022-07-26 | Malaysia | Perlis | 17848 | 188 | 0 | 6.4449 | 100.2048 | 2022-07-27 04:21:04 | Perlis, Malaysia | |||
2594094 | 2594094 | 2022-07-25 | Malaysia | Perlis | 17834 | 188 | 0 | 6.4449 | 100.2048 | 2022-07-26 04:20:58 | Perlis, Malaysia | |||
896209 | 896209 | 2022-07-24 | Malaysia | Perlis | 17828 | 188 | 0 | 6.4449 | 100.2048 | 2022-07-25 04:20:51 | Perlis, Malaysia | |||
91203 | 91203 | 2022-07-23 | Malaysia | Perlis | 17822 | 188 | 0 | 6.4449 | 100.2048 | 2022-07-24 04:20:47 | Perlis, Malaysia | |||
900225 | 900225 | 2022-07-22 | Malaysia | Perlis | 17813 | 188 | 0 | 6.4449 | 100.2048 | 2022-07-23 04:20:53 | Perlis, Malaysia | |||
670361 | 670361 | 2022-07-21 | Malaysia | Perlis | 17806 | 188 | 0 | 6.4449 | 100.2048 | 2022-07-22 04:21:15 | Perlis, Malaysia | |||
1608324 | 1608324 | 2022-07-20 | Malaysia | Perlis | 17793 | 188 | 0 | 6.4449 | 100.2048 | 2022-07-21 04:21:10 | Perlis, Malaysia | |||
958957 | 958957 | 2022-07-19 | Malaysia | Perlis | 17785 | 188 | 0 | 6.4449 | 100.2048 | 2022-07-20 04:20:59 | Perlis, Malaysia | |||
3210344 | 3210344 | 2022-07-18 | Malaysia | Perlis | 17745 | 188 | 0 | 6.4449 | 100.2048 | 2022-07-19 04:20:58 | Perlis, Malaysia | |||
3405519 | 3405519 | 2022-07-17 | Malaysia | Perlis | 17740 | 188 | 0 | 6.4449 | 100.2048 | 2022-07-18 04:20:59 | Perlis, Malaysia | |||
2151719 | 2151719 | 2022-07-16 | Malaysia | Perlis | 17732 | 188 | 0 | 6.4449 | 100.2048 | 2022-07-17 04:21:15 | Perlis, Malaysia | |||
2418952 | 2418952 | 2022-07-15 | Malaysia | Perlis | 17723 | 188 | 0 | 6.4449 | 100.2048 | 2022-07-16 04:21:05 | Perlis, Malaysia | |||
3429027 | 3429027 | 2022-07-14 | Malaysia | Perlis | 17715 | 188 | 0 | 6.4449 | 100.2048 | 2022-07-15 04:20:53 | Perlis, Malaysia | |||
3109547 | 3109547 | 2022-07-13 | Malaysia | Perlis | 17704 | 188 | 0 | 6.4449 | 100.2048 | 2022-07-14 04:20:57 | Perlis, Malaysia | |||
629970 | 629970 | 2022-07-12 | Malaysia | Perlis | 17690 | 188 | 0 | 6.4449 | 100.2048 | 2022-07-13 04:20:58 | Perlis, Malaysia | |||
1211614 | 1211614 | 2022-07-11 | Malaysia | Perlis | 17687 | 188 | 0 | 6.4449 | 100.2048 | 2022-07-12 04:20:51 | Perlis, Malaysia | |||
2789096 | 2789096 | 2022-07-10 | Malaysia | Perlis | 17686 | 188 | 0 | 6.4449 | 100.2048 | 2022-07-11 04:20:46 | Perlis, Malaysia | |||
142049 | 142049 | 2022-07-09 | Malaysia | Perlis | 17682 | 188 | 0 | 6.4449 | 100.2048 | 2022-07-10 04:20:54 | Perlis, Malaysia | |||
1417149 | 1417149 | 2022-07-08 | Malaysia | Perlis | 17674 | 188 | 0 | 6.4449 | 100.2048 | 2022-07-09 04:20:59 | Perlis, Malaysia | |||
2741074 | 2741074 | 2022-07-07 | Malaysia | Perlis | 17648 | 188 | 0 | 6.4449 | 100.2048 | 2022-07-08 04:20:56 | Perlis, Malaysia | |||
1199869 | 1199869 | 2022-07-06 | Malaysia | Perlis | 17641 | 188 | 0 | 6.4449 | 100.2048 | 2022-07-07 04:20:55 | Perlis, Malaysia | |||
3966612 | 3966612 | 2022-07-05 | Malaysia | Perlis | 17630 | 188 | 0 | 6.4449 | 100.2048 | 2022-07-06 04:20:58 | Perlis, Malaysia | |||
3078123 | 3078123 | 2022-07-04 | Malaysia | Perlis | 17620 | 188 | 0 | 6.4449 | 100.2048 | 2022-07-05 04:20:45 | Perlis, Malaysia | |||
1767405 | 1767405 | 2022-07-03 | Malaysia | Perlis | 17615 | 188 | 0 | 6.4449 | 100.2048 | 2022-07-04 04:20:54 | Perlis, Malaysia | |||
3365391 | 3365391 | 2022-07-02 | Malaysia | Perlis | 17610 | 188 | 0 | 6.4449 | 100.2048 | 2022-07-03 04:20:59 | Perlis, Malaysia | |||
593720 | 593720 | 2022-07-01 | Malaysia | Perlis | 17601 | 188 | 0 | 6.4449 | 100.2048 | 2022-07-02 04:21:16 | Perlis, Malaysia | |||
3940121 | 3940121 | 2022-06-30 | Malaysia | Perlis | 17596 | 188 | 0 | 6.4449 | 100.2048 | 2022-07-01 04:21:10 | Perlis, Malaysia | |||
2490079 | 2490079 | 2022-06-29 | Malaysia | Perlis | 17586 | 188 | 0 | 6.4449 | 100.2048 | 2022-06-30 04:21:01 | Perlis, Malaysia | |||
2239461 | 2239461 | 2022-06-28 | Malaysia | Perlis | 17578 | 188 | 0 | 6.4449 | 100.2048 | 2022-06-29 04:20:59 | Perlis, Malaysia | |||
2147703 | 2147703 | 2022-06-27 | Malaysia | Perlis | 17570 | 188 | 0 | 6.4449 | 100.2048 | 2022-06-28 04:20:58 | Perlis, Malaysia | |||
475504 | 475504 | 2022-06-26 | Malaysia | Perlis | 17559 | 188 | 0 | 6.4449 | 100.2048 | 2022-06-27 04:21:00 | Perlis, Malaysia | |||
938879 | 938879 | 2022-06-25 | Malaysia | Perlis | 17552 | 188 | 0 | 6.4449 | 100.2048 | 2022-06-26 04:21:02 | Perlis, Malaysia | |||
3346699 | 3346699 | 2022-06-24 | Malaysia | Perlis | 17542 | 188 | 0 | 6.4449 | 100.2048 | 2022-06-25 04:20:57 | Perlis, Malaysia | |||
1648440 | 1648440 | 2022-06-23 | Malaysia | Perlis | 17535 | 188 | 0 | 6.4449 | 100.2048 | 2022-06-24 04:20:58 | Perlis, Malaysia | |||
2187675 | 2187675 | 2022-06-22 | Malaysia | Perlis | 17529 | 188 | 0 | 6.4449 | 100.2048 | 2022-06-23 04:20:55 | Perlis, Malaysia | |||
166106 | 166106 | 2022-06-21 | Malaysia | Perlis | 17523 | 188 | 0 | 6.4449 | 100.2048 | 2022-06-22 04:20:54 | Perlis, Malaysia | |||
1763389 | 1763389 | 2022-06-20 | Malaysia | Perlis | 17519 | 188 | 0 | 6.4449 | 100.2048 | 2022-06-21 04:20:56 | Perlis, Malaysia | |||
3269575 | 3269575 | 2022-06-19 | Malaysia | Perlis | 17511 | 188 | 0 | 6.4449 | 100.2048 | 2022-06-20 04:21:01 | Perlis, Malaysia | |||
3397487 | 3397487 | 2022-06-18 | Malaysia | Perlis | 17508 | 188 | 0 | 6.4449 | 100.2048 | 2022-06-19 04:20:51 | Perlis, Malaysia | |||
2311364 | 2311364 | 2022-06-17 | Malaysia | Perlis | 17507 | 188 | 0 | 6.4449 | 100.2048 | 2022-06-18 04:21:10 | Perlis, Malaysia | |||
558868 | 558868 | 2022-06-16 | Malaysia | Perlis | 17503 | 188 | 0 | 6.4449 | 100.2048 | 2022-06-17 04:20:56 | Perlis, Malaysia | |||
3982670 | 3982670 | 2022-06-15 | Malaysia | Perlis | 17499 | 188 | 0 | 6.4449 | 100.2048 | 2022-06-16 04:20:55 | Perlis, Malaysia | |||
946911 | 946911 | 2022-06-14 | Malaysia | Perlis | 17490 | 188 | 0 | 6.4449 | 100.2048 | 2022-06-15 04:20:54 | 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]);