johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,073 rows where country_or_region = "Malaysia" and province_or_state = "Selangor" sorted by combined_key
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
261182 | 261182 | 2020-03-03 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2020-03-03T11:43:02 | ||||
339942 | 339942 | 2020-03-21 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2020-03-21T10:13:08 | ||||
415893 | 415893 | 2020-01-26 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 1/26/20 16:00 | ||||
479240 | 479240 | 2020-02-25 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2020-02-25T15:23:04 | ||||
562633 | 562633 | 2020-03-01 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2020-03-01T10:13:19 | ||||
566754 | 566754 | 2020-02-06 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2020-02-06T23:23:02 | ||||
617512 | 617512 | 2020-02-27 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2020-02-27T12:13:14 | ||||
657964 | 657964 | 2020-03-09 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2020-03-09T14:33:03 | ||||
864438 | 864438 | 2020-01-23 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 1/23/20 17:00 | ||||
1085725 | 1085725 | 2020-02-22 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2020-02-22T23:33:06 | ||||
1152788 | 1152788 | 2020-03-02 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2020-03-02T15:03:23 | ||||
1177174 | 1177174 | 2020-03-18 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2020-03-18T12:13:09 | ||||
1192536 | 1192536 | 2020-02-14 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2020-02-14T23:33:02 | ||||
1243438 | 1243438 | 2020-02-17 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2020-02-17T23:13:06 | ||||
1305820 | 1305820 | 2020-01-28 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 1/28/20 23:00 | ||||
1366127 | 1366127 | 2020-02-08 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2020-02-08T23:33:06 | ||||
1463734 | 1463734 | 2020-03-15 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2020-03-15T18:20:18 | ||||
1527178 | 1527178 | 2020-03-19 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2020-03-19T10:13:14 | ||||
1527469 | 1527469 | 2020-03-08 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2020-03-08T14:43:03 | ||||
1527563 | 1527563 | 2020-01-30 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 1/30/20 16:00 | ||||
1559742 | 1559742 | 2020-02-13 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2020-02-13T14:13:06 | ||||
1720133 | 1720133 | 2020-02-19 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2020-02-19T23:23:02 | ||||
1783164 | 1783164 | 2020-02-18 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2020-02-18T23:13:11 | ||||
1802394 | 1802394 | 2020-01-22 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 1/22/2020 17:00 | ||||
1888791 | 1888791 | 2020-02-16 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2020-02-16T23:53:01 | ||||
2091747 | 2091747 | 2020-02-05 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2020-02-05T23:13:12 | ||||
2111350 | 2111350 | 2020-03-14 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2020-03-14T10:13:09 | ||||
2127661 | 2127661 | 2020-03-11 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2020-03-11T10:53:02 | ||||
2135807 | 2135807 | 2020-02-21 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2020-02-21T13:03:09 | ||||
2255399 | 2255399 | 2020-03-16 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2020-03-16T14:38:45 | ||||
2263541 | 2263541 | 2020-02-20 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2020-02-20T23:43:02 | ||||
2283093 | 2283093 | 2020-03-12 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2020-03-12T09:53:06 | ||||
2379310 | 2379310 | 2020-02-02 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2020-02-02T23:43:02 | ||||
2509865 | 2509865 | 2020-02-26 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2020-02-26T14:13:10 | ||||
2567331 | 2567331 | 2020-02-12 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2020-02-12T14:13:08 | ||||
2860625 | 2860625 | 2020-02-03 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2020-02-03T23:23:03 | ||||
2884034 | 2884034 | 2020-02-28 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2020-02-28T00:43:01 | ||||
2938991 | 2938991 | 2020-01-25 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 1/25/20 17:00 | ||||
3089088 | 3089088 | 2020-02-10 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2020-02-10T23:33:02 | ||||
3173438 | 3173438 | 2020-02-23 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2020-02-23T11:33:03 | ||||
3177689 | 3177689 | 2020-03-06 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2020-03-06T14:23:04 | ||||
3197790 | 3197790 | 2020-02-11 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2020-02-11T23:33:02 | ||||
3205916 | 3205916 | 2020-02-29 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2020-02-29T12:13:10 | ||||
3222086 | 3222086 | 2020-02-07 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2020-02-07T23:43:02 | ||||
3362457 | 3362457 | 2020-02-09 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2020-02-09T23:33:02 | ||||
3413222 | 3413222 | 2020-02-01 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2/1/2020 11:53 | ||||
3471963 | 3471963 | 2020-02-04 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2020-02-04T23:43:01 | ||||
3551299 | 3551299 | 2020-02-24 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2020-02-24T11:13:09 | ||||
3734234 | 3734234 | 2020-03-20 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2020-03-20T07:43:02 | ||||
3753035 | 3753035 | 2020-03-10 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2020-03-10T15:13:05 | ||||
3753122 | 3753122 | 2020-01-27 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 1/27/20 23:59 | ||||
3761252 | 3761252 | 2020-01-31 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 1/31/2020 23:59 | ||||
3765529 | 3765529 | 2020-03-13 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2020-03-13T11:09:03 | ||||
3891597 | 3891597 | 2020-03-17 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2020-03-17T11:53:10 | ||||
394 | 394 | 2021-12-02 | Malaysia | Selangor | 756781 | 9808 | 0 | 3.0738 | 101.5183 | 2021-12-03 04:23:05 | Selangor, Malaysia | |||
4410 | 4410 | 2021-10-28 | Malaysia | Selangor | 710823 | 9584 | 0 | 3.0738 | 101.5183 | 2021-10-29 04:22:03 | Selangor, Malaysia | |||
12011 | 12011 | 2020-10-25 | Malaysia | Selangor | 3970 | 25 | 3036 | 909 | 3.0738 | 101.5183 | 2020-10-26 04:25:02 | Selangor, Malaysia | ||
16025 | 16025 | 2021-01-26 | Malaysia | Selangor | 56666 | 124 | 44583 | 11959 | 3.0738 | 101.5183 | 2021-01-27 05:23:41 | Selangor, Malaysia | ||
20040 | 20040 | 2021-09-18 | Malaysia | Selangor | 656283 | 8237 | 613451 | 34595 | 3.0738 | 101.5183 | 2021-09-19 04:21:34 | Selangor, Malaysia | ||
24054 | 24054 | 2021-05-28 | Malaysia | Selangor | 179504 | 707 | 154908 | 23889 | 3.0738 | 101.5183 | 2021-05-29 04:20:41 | Selangor, Malaysia | ||
24465 | 24465 | 2022-03-20 | Malaysia | Selangor | 1093911 | 10442 | 0 | 3.0738 | 101.5183 | 2022-03-21 04:20:50 | Selangor, Malaysia | |||
28480 | 28480 | 2021-11-11 | Malaysia | Selangor | 727146 | 9667 | 0 | 3.0738 | 101.5183 | 2021-11-12 04:22:01 | Selangor, Malaysia | |||
36100 | 36100 | 2021-08-25 | Malaysia | Selangor | 572798 | 5289 | 482983 | 84526 | 3.0738 | 101.5183 | 2021-08-26 04:21:28 | Selangor, Malaysia | ||
40114 | 40114 | 2021-04-12 | Malaysia | Selangor | 120360 | 346 | 115062 | 4952 | 3.0738 | 101.5183 | 2021-04-13 04:20:37 | Selangor, Malaysia | ||
43358 | 43358 | 2020-04-13 | Malaysia | Selangor | 1240 | 10 | 741 | 489 | 3.0738 | 101.5183 | 2020-04-13 23:07:54 | Selangor, Malaysia | ||
43772 | 43772 | 2021-11-02 | Malaysia | Selangor | 716462 | 9613 | 0 | 3.0738 | 101.5183 | 2021-11-03 06:22:09 | Selangor, Malaysia | |||
50457 | 50457 | 2020-04-17 | Malaysia | Selangor | 1333 | 13 | 880 | 440 | 3.0738 | 101.5183 | 2020-04-17 23:30:52 | Selangor, Malaysia | ||
54475 | 54475 | 2021-05-29 | Malaysia | Selangor | 182340 | 734 | 156707 | 24899 | 3.0738 | 101.5183 | 2021-05-30 04:20:55 | Selangor, Malaysia | ||
58489 | 58489 | 2021-03-07 | Malaysia | Selangor | 104656 | 304 | 96880 | 7472 | 3.0738 | 101.5183 | 2021-03-08 05:24:48 | Selangor, Malaysia | ||
62454 | 62454 | 2020-07-23 | Malaysia | Selangor | 2113 | 24 | 2055 | 34 | 3.0738 | 101.5183 | 2020-07-24 05:30:40 | Selangor, Malaysia | ||
63127 | 63127 | 2022-11-12 | Malaysia | Selangor | 1516109 | 10893 | 0 | 3.0738 | 101.5183 | 2022-11-13 04:21:14 | Selangor, Malaysia | |||
70745 | 70745 | 2021-09-01 | Malaysia | Selangor | 607708 | 6050 | 526286 | 75372 | 3.0738 | 101.5183 | 2021-09-02 04:21:15 | Selangor, Malaysia | ||
71155 | 71155 | 2022-02-07 | Malaysia | Selangor | 829397 | 10066 | 0 | 3.0738 | 101.5183 | 2022-02-08 04:21:15 | Selangor, Malaysia | |||
78772 | 78772 | 2020-12-03 | Malaysia | Selangor | 15538 | 30 | 12042 | 3466 | 3.0738 | 101.5183 | 2020-12-04 05:27:27 | Selangor, Malaysia | ||
82765 | 82765 | 2020-10-14 | Malaysia | Selangor | 2815 | 24 | 2313 | 478 | 3.0738 | 101.5183 | 2020-10-15 04:24:28 | Selangor, Malaysia | ||
86779 | 86779 | 2021-05-25 | Malaysia | Selangor | 172322 | 646 | 150262 | 21414 | 3.0738 | 101.5183 | 2021-05-26 04:20:35 | Selangor, Malaysia | ||
87189 | 87189 | 2021-11-09 | Malaysia | Selangor | 724102 | 9657 | 0 | 3.0738 | 101.5183 | 2021-11-10 04:21:38 | Selangor, Malaysia | |||
91207 | 91207 | 2022-07-23 | Malaysia | Selangor | 1417527 | 10746 | 0 | 3.0738 | 101.5183 | 2022-07-24 04:20:47 | Selangor, Malaysia | |||
98784 | 98784 | 2020-08-04 | Malaysia | Selangor | 2131 | 24 | 2084 | 23 | 3.0738 | 101.5183 | 2020-08-05 04:34:43 | Selangor, Malaysia | ||
99390 | 99390 | 2022-01-14 | Malaysia | Selangor | 798036 | 10010 | 0 | 3.0738 | 101.5183 | 2022-01-15 04:21:07 | Selangor, Malaysia | |||
107010 | 107010 | 2021-08-15 | Malaysia | Selangor | 512656 | 4535 | 412343 | 95778 | 3.0738 | 101.5183 | 2021-08-16 04:21:31 | Selangor, Malaysia | ||
111135 | 111135 | 2021-06-19 | Malaysia | Selangor | 226457 | 1262 | 202324 | 22871 | 3.0738 | 101.5183 | 2021-06-20 04:21:48 | Selangor, Malaysia | ||
114401 | 114401 | 2020-05-08 | Malaysia | Selangor | 1587 | 20 | 1205 | 362 | 3.0738 | 101.5183 | 2020-05-09 02:32:35 | Selangor, Malaysia | ||
114817 | 114817 | 2022-09-06 | Malaysia | Selangor | 1463986 | 10828 | 0 | 3.0738 | 101.5183 | 2022-09-07 04:20:59 | Selangor, Malaysia | |||
122377 | 122377 | 2020-07-19 | Malaysia | Selangor | 2104 | 24 | 2042 | 38 | 3.0738 | 101.5183 | 2020-07-20 05:34:40 | Selangor, Malaysia | ||
126387 | 126387 | 2020-11-18 | Malaysia | Selangor | 8191 | 27 | 6336 | 1828 | 3.0738 | 101.5183 | 2020-11-19 05:25:23 | Selangor, Malaysia | ||
126797 | 126797 | 2022-01-09 | Malaysia | Selangor | 793684 | 9994 | 0 | 3.0738 | 101.5183 | 2022-01-10 04:22:07 | Selangor, Malaysia | |||
130815 | 130815 | 2022-10-04 | Malaysia | Selangor | 1478820 | 10854 | 0 | 3.0738 | 101.5183 | 2022-10-05 04:23:06 | Selangor, Malaysia | |||
137621 | 137621 | 2020-04-29 | Malaysia | Selangor | 1406 | 18 | 1103 | 285 | 3.0738 | 101.5183 | 2020-04-30 02:32:27 | Selangor, Malaysia | ||
138035 | 138035 | 2021-12-04 | Malaysia | Selangor | 759847 | 9812 | 0 | 3.0738 | 101.5183 | 2021-12-05 04:22:25 | Selangor, Malaysia | |||
142053 | 142053 | 2022-07-09 | Malaysia | Selangor | 1398597 | 10693 | 0 | 3.0738 | 101.5183 | 2022-07-10 04:20:54 | Selangor, Malaysia | |||
149638 | 149638 | 2020-08-15 | Malaysia | Selangor | 2145 | 24 | 2097 | 24 | 3.0738 | 101.5183 | 2020-08-16 04:27:42 | Selangor, Malaysia | ||
150048 | 150048 | 2021-11-29 | Malaysia | Selangor | 752376 | 9777 | 0 | 3.0738 | 101.5183 | 2021-11-30 04:22:53 | Selangor, Malaysia | |||
157666 | 157666 | 2021-01-08 | Malaysia | Selangor | 38435 | 71 | 28807 | 9557 | 3.0738 | 101.5183 | 2021-01-09 05:22:18 | Selangor, Malaysia | ||
158077 | 158077 | 2022-03-29 | Malaysia | Selangor | 1174635 | 10517 | 0 | 3.0738 | 101.5183 | 2022-03-30 04:20:45 | Selangor, Malaysia | |||
162092 | 162092 | 2021-11-19 | Malaysia | Selangor | 738926 | 9723 | 0 | 3.0738 | 101.5183 | 2021-11-20 04:22:17 | Selangor, Malaysia | |||
166110 | 166110 | 2022-06-21 | Malaysia | Selangor | 1382520 | 10679 | 0 | 3.0738 | 101.5183 | 2022-06-22 04:20:54 | Selangor, Malaysia | |||
173728 | 173728 | 2021-04-16 | Malaysia | Selangor | 122409 | 354 | 116785 | 5270 | 3.0738 | 101.5183 | 2021-04-17 04:20:40 | Selangor, Malaysia | ||
177696 | 177696 | 2020-07-27 | Malaysia | Selangor | 2120 | 24 | 2065 | 31 | 3.0738 | 101.5183 | 2020-07-28 04:58:43 | Selangor, Malaysia | ||
181710 | 181710 | 2021-09-02 | Malaysia | Selangor | 611781 | 6111 | 533277 | 72393 | 3.0738 | 101.5183 | 2021-09-03 04:21:20 | Selangor, 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]);