johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,073 rows where 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
2343488 | 2343488 | 2022-08-31 | Malaysia | Perlis | 18215 | 191 | 0 | 6.4449 | 100.2048 | 2022-09-01 04:21:03 | Perlis, Malaysia | |||
3773968 | 3773968 | 2022-08-30 | Malaysia | Perlis | 18199 | 191 | 0 | 6.4449 | 100.2048 | 2022-08-31 04:20:57 | Perlis, Malaysia | |||
1680564 | 1680564 | 2022-08-29 | Malaysia | Perlis | 18194 | 191 | 0 | 6.4449 | 100.2048 | 2022-08-30 04:21:03 | Perlis, Malaysia | |||
1877048 | 1877048 | 2022-08-28 | Malaysia | Perlis | 18187 | 189 | 0 | 6.4449 | 100.2048 | 2022-08-29 04:21:06 | Perlis, Malaysia | |||
2096175 | 2096175 | 2022-08-27 | Malaysia | Perlis | 18179 | 189 | 0 | 6.4449 | 100.2048 | 2022-08-28 04:21:02 | Perlis, Malaysia | |||
1531990 | 1531990 | 2022-08-26 | Malaysia | Perlis | 18174 | 189 | 0 | 6.4449 | 100.2048 | 2022-08-27 04:20:57 | Perlis, Malaysia | |||
2828877 | 2828877 | 2022-08-25 | Malaysia | Perlis | 18162 | 189 | 0 | 6.4449 | 100.2048 | 2022-08-26 04:21:02 | Perlis, Malaysia | |||
2323410 | 2323410 | 2022-08-24 | Malaysia | Perlis | 18150 | 189 | 0 | 6.4449 | 100.2048 | 2022-08-25 04:21:13 | Perlis, Malaysia | |||
1250819 | 1250819 | 2022-08-23 | Malaysia | Perlis | 18140 | 189 | 0 | 6.4449 | 100.2048 | 2022-08-24 04:20:46 | Perlis, Malaysia | |||
2852923 | 2852923 | 2022-08-22 | Malaysia | Perlis | 18127 | 189 | 0 | 6.4449 | 100.2048 | 2022-08-23 04:20:56 | Perlis, Malaysia | |||
2402895 | 2402895 | 2022-08-21 | Malaysia | Perlis | 18117 | 189 | 0 | 6.4449 | 100.2048 | 2022-08-22 04:20:38 | Perlis, Malaysia | |||
3797973 | 3797973 | 2022-08-20 | Malaysia | Perlis | 18108 | 189 | 0 | 6.4449 | 100.2048 | 2022-08-21 04:20:44 | Perlis, Malaysia | |||
2363559 | 2363559 | 2022-08-19 | Malaysia | Perlis | 18099 | 189 | 0 | 6.4449 | 100.2048 | 2022-08-20 04:21:01 | Perlis, Malaysia | |||
1161230 | 1161230 | 2022-08-18 | Malaysia | Perlis | 18096 | 189 | 0 | 6.4449 | 100.2048 | 2022-08-19 04:20:54 | Perlis, Malaysia | |||
3950554 | 3950554 | 2022-08-17 | Malaysia | Perlis | 18090 | 189 | 0 | 6.4449 | 100.2048 | 2022-08-18 04:21:11 | Perlis, Malaysia | |||
991056 | 991056 | 2022-08-16 | Malaysia | Perlis | 18073 | 189 | 0 | 6.4449 | 100.2048 | 2022-08-17 04:20:59 | Perlis, Malaysia | |||
2494095 | 2494095 | 2022-08-15 | Malaysia | Perlis | 18068 | 189 | 0 | 6.4449 | 100.2048 | 2022-08-16 04:20:58 | Perlis, Malaysia | |||
3647645 | 3647645 | 2022-08-14 | Malaysia | Perlis | 18060 | 189 | 0 | 6.4449 | 100.2048 | 2022-08-15 04:20:59 | Perlis, Malaysia | |||
1968651 | 1968651 | 2022-08-13 | Malaysia | Perlis | 18048 | 189 | 0 | 6.4449 | 100.2048 | 2022-08-14 04:20:55 | Perlis, Malaysia | |||
2888460 | 2888460 | 2022-08-12 | Malaysia | Perlis | 18035 | 189 | 0 | 6.4449 | 100.2048 | 2022-08-13 04:20:52 | Perlis, Malaysia | |||
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 | |||
2979319 | 2979319 | 2022-06-13 | Malaysia | Perlis | 17484 | 187 | 0 | 6.4449 | 100.2048 | 2022-06-14 04:20:52 | 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]);