⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

507 rows where country_or_region = "Malaysia" sorted by combined_key

View and edit SQL

Suggested facets: latitude, longitude, day (date), last_update (date)

country_or_region

  • Malaysia · 507

province_or_state

Link rowid day country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key ▼
67080 2020-02-27 Malaysia       23 0 18       2020-02-27T15:13:13  
126668 2020-02-28 Malaysia       23 0 18       2020-02-27T15:13:13  
126778 2020-03-14 Malaysia       238 0 35   4.2105 101.9758 2020-03-14T16:13:55  
134267 2020-02-10 Malaysia       18 0 1       2020-02-10T03:03:09  
150261 2020-03-02 Malaysia       29 0 18   2.5 112.5 2020-03-01T12:53:02  
166108 2020-02-16 Malaysia       22 0 7       2020-02-15T23:43:02  
195291 2020-02-11 Malaysia       18 0 3       2020-02-11T03:13:13  
261741 2020-03-04 Malaysia       50 0 22   2.5 112.5 2020-03-04T13:03:08  
297171 2020-03-05 Malaysia       50 0 22   2.5 112.5 2020-03-04T13:03:08  
320646 2020-01-30 Malaysia       8 0 0       1/30/20 16:00  
410990 2020-03-21 Malaysia       1183 4 114   4.2105 101.9758 2020-03-21T11:43:06  
415244 2020-03-18 Malaysia       790 2 60   4.2105 101.9758 2020-03-18T10:33:04  
415547 2020-03-09 Malaysia       117 0 24   2.5 112.5 2020-03-09T09:43:03  
511431 2020-02-08 Malaysia       16 0 1       2020-02-08T10:23:04  
523449 2020-03-15 Malaysia       428 0 42   4.2105 101.9758 2020-03-15T18:20:18  
585631 2020-03-13 Malaysia       197 0 26   4.2105 101.9758 2020-03-11T20:00:00  
642929 2020-03-03 Malaysia       36 0 22   2.5 112.5 2020-03-03T12:33:02  
643074 2020-02-03 Malaysia       8 0 0       2020-01-31T08:15:53  
758548 2020-03-20 Malaysia       1030 3 87   4.2105 101.9758 2020-03-20T18:13:09  
840962 2020-01-28 Malaysia       4 0 0       1/28/20 23:00  
859148 2020-02-14 Malaysia       19 0 3       2020-02-13T10:53:02  
885727 2020-02-23 Malaysia       22 0 15       2020-02-19T09:33:03  
919663 2020-03-17 Malaysia       673 2 49   4.2105 101.9758 2020-03-17T15:33:06  
962451 2020-02-24 Malaysia       22 0 18       2020-02-24T11:53:02  
1065352 2020-03-12 Malaysia       149 0 26   2.5 112.5 2020-03-11T11:33:08  
1069550 2020-02-19 Malaysia       22 0 15       2020-02-19T09:33:03  
1069627 2020-02-18 Malaysia       22 0 13       2020-02-18T16:23:02  
1069711 2020-03-07 Malaysia       93 0 23   2.5 112.5 2020-03-07T17:53:03  
1081320 2020-03-01 Malaysia       29 0 18   2.5 112.5 2020-03-01T12:53:02  
1120417 2020-02-01 Malaysia       8 0 0       1/31/2020 8:15  
1132427 2020-01-27 Malaysia       4 0 0       1/27/20 23:59  
1165910 2020-02-15 Malaysia       22 0 7       2020-02-15T23:43:02  
1199898 2020-02-07 Malaysia       12 0 1       2020-02-07T09:13:21  
1226308 2020-01-29 Malaysia       7 0 0       1/29/20 19:30  
1226363 2020-03-10 Malaysia       129 0 24   2.5 112.5 2020-03-10T16:33:13  
1246318 2020-03-06 Malaysia       83 0 22   2.5 112.5 2020-03-06T12:33:03  
1277571 2020-02-13 Malaysia       19 0 3       2020-02-13T10:53:02  
1314473 2020-02-20 Malaysia       22 0 15       2020-02-19T09:33:03  
1363608 2020-01-23 Malaysia       0 0 0       1/23/20 17:00  
1367610 2020-02-22 Malaysia       22 0 15       2020-02-19T09:33:03  
1426713 2020-02-06 Malaysia       12 0 0       2020-02-05T15:43:02  
1426791 2020-03-08 Malaysia       99 0 24   2.5 112.5 2020-03-08T14:43:03  
1446899 2020-02-29 Malaysia       25 0 18       2020-02-29T04:03:18  
1481270 2020-02-17 Malaysia       22 0 7       2020-02-15T23:43:02  
1508088 2020-02-09 Malaysia       16 0 1       2020-02-08T10:23:04  
1524100 2020-01-26 Malaysia       4 0 0       1/26/20 16:00  
1532114 2020-02-26 Malaysia       22 0 18       2020-02-24T11:53:02  
1535384 2020-03-11 Malaysia       149 0 26   2.5 112.5 2020-03-11T11:33:08  
1541617 2020-01-25 Malaysia       3 0 0       1/25/20 17:00  
1544854 2020-01-31 Malaysia       8 0 0       1/31/2020 23:59  
1559729 2020-02-12 Malaysia       18 0 3       2020-02-11T03:13:13  
1574746 2020-03-16 Malaysia       566 0 42   4.2105 101.9758 2020-03-16T14:38:45  
1613089 2020-02-04 Malaysia       10 0 0       2020-02-04T07:33:02  
1625078 2020-03-19 Malaysia       900 2 75   4.2105 101.9758 2020-03-19T10:13:15  
1645106 2020-02-21 Malaysia       22 0 15       2020-02-19T09:33:03  
1645192 2020-02-05 Malaysia       12 0 0       2020-02-05T15:43:02  
1645267 2020-02-02 Malaysia       8 0 0       2020-01-31T08:15:53  
1709744 2020-02-25 Malaysia       22 0 18       2020-02-24T11:53:02  
2996 2020-04-19 Malaysia       5389 89 3197 2103 4.210484 101.975766 2020-04-19 23:40:41 Malaysia
3444 2020-10-26 Malaysia       27805 236 17825 9744 4.210483999999999 101.975766 2020-10-27 04:24:45 Malaysia
10409 2020-03-30 Malaysia       2626 37 479 2110 4.210484 101.975766 3/30/20 22:52 Malaysia
14250 2020-07-17 Malaysia       8755 122 8541 92 4.210483999999999 101.97576600000001 2020-07-18 04:34:45 Malaysia
14711 2021-04-30 Malaysia       408713 1506 377980 29227 4.210483999999999 101.975766 2021-05-01 04:20:47 Malaysia
21355 2020-04-24 Malaysia       5691 96 3663 1932 4.210483999999999 101.97576600000001 2020-04-25 06:30:33 Malaysia
21811 2020-10-13 Malaysia       16880 163 11372 5345 4.210483999999999 101.975766 2020-10-14 04:24:05 Malaysia
28563 2020-05-11 Malaysia       6726 109 5113 1504 4.210483999999999 101.975766 2020-05-12 03:32:27 Malaysia
29025 2020-11-23 Malaysia       56659 337 42480 13842 4.210483999999999 101.975766 2020-11-24 05:27:31 Malaysia
33008 2021-04-12 Malaysia       362173 1333 345005 15835 4.210483999999999 101.975766 2021-04-13 04:20:37 Malaysia
36978 2020-10-27 Malaysia       28640 238 18499 9903 4.210483999999999 101.975766 2020-10-28 04:24:39 Malaysia
44436 2020-07-30 Malaysia       8964 124 8617 223 4.210483999999999 101.975766 2020-07-31 04:35:18 Malaysia
47672 2020-05-09 Malaysia       6589 108 4929 1552 4.210483999999999 101.975766 2020-05-10 02:32:30 Malaysia
48135 2020-12-19 Malaysia       91969 433 76242 15294 4.210483999999999 101.975766 2020-12-20 05:27:32 Malaysia
55185 2020-05-29 Malaysia       7732 115 6235 1382 4.210483999999999 101.97576600000001 2020-05-30 02:32:48 Malaysia
55647 2021-03-16 Malaysia       326034 1218 309612 15204 4.210483999999999 101.975766 2021-03-17 05:25:07 Malaysia
59629 2020-12-07 Malaysia       74294 384 62306 11604 4.210483999999999 101.975766 2020-12-08 05:27:42 Malaysia
66960 2020-07-05 Malaysia       8663 121 8465 77 4.210483999999999 101.97576600000001 2020-07-06 04:33:57 Malaysia
67526 2021-05-29 Malaysia       558534 2650 479666 76218 4.210483999999999 101.975766 2021-05-30 04:20:55 Malaysia
71509 2021-05-05 Malaysia       424376 1591 389846 32939 4.210483999999999 101.975766 2021-05-06 04:20:38 Malaysia
78967 2020-07-27 Malaysia       8904 124 8601 179 4.210483999999999 101.975766 2020-07-28 04:58:43 Malaysia
79417 2020-10-28 Malaysia       29441 246 19072 10123 4.210483999999999 101.975766 2020-10-29 04:24:49 Malaysia
83382 2020-09-16 Malaysia       10031 128 9235 668 4.210484 101.975766 2020-09-17 04:22:00 Malaysia
87343 2020-10-09 Malaysia       14722 152 10707 3863 4.210483999999999 101.975766 2020-10-10 04:23:57 Malaysia
91317 2020-12-06 Malaysia       72694 382 61273 11039 4.210483999999999 101.975766 2020-12-07 05:26:14 Malaysia
95297 2020-11-18 Malaysia       50390 322 37254 12814 4.210483999999999 101.975766 2020-11-19 05:25:23 Malaysia
99280 2021-05-23 Malaysia       512091 2248 452821 57022 4.210483999999999 101.975766 2021-05-24 04:20:53 Malaysia
106749 2020-08-08 Malaysia       9070 125 8775 170 4.210483999999999 101.975766 2020-08-09 04:34:54 Malaysia
107209 2020-11-29 Malaysia       64485 357 52647 11481 4.210483999999999 101.975766 2020-11-30 05:26:13 Malaysia
111176 2020-08-11 Malaysia       9103 125 8809 169 4.210483999999999 101.975766 2020-08-12 04:27:29 Malaysia
118604 2020-07-18 Malaysia       8764 122 8546 96 4.210483999999999 101.97576600000001 2020-07-19 04:34:58 Malaysia
119051 2020-08-20 Malaysia       9240 125 8932 183 4.210483999999999 101.975766 2020-08-21 04:27:41 Malaysia
123021 2021-04-05 Malaysia       352029 1295 336456 14278 4.210483999999999 101.975766 2021-04-06 04:20:32 Malaysia
130349 2020-03-28 Malaysia       2320 27 320 1973 4.210484 101.975766 3/28/20 23:05 Malaysia
134154 2020-07-04 Malaysia       8658 121 8461 76 4.210483999999999 101.97576600000001 2020-07-05 04:33:46 Malaysia
134672 2020-10-05 Malaysia       12813 137 10340 2336 4.210483999999999 101.975766 2020-10-06 04:23:33 Malaysia
138645 2020-11-13 Malaysia       45095 304 32969 11822 4.210483999999999 101.975766 2020-11-14 05:25:37 Malaysia
142627 2021-02-03 Malaysia       226912 809 177794 48309 4.210483999999999 101.975766 2021-02-04 05:22:26 Malaysia
146611 2021-02-09 Malaysia       248316 909 196566 50841 4.210483999999999 101.975766 2021-02-10 05:22:41 Malaysia
150739 2021-03-25 Malaysia       338168 1248 322416 14504 4.210483999999999 101.975766 2021-03-26 05:26:55 Malaysia
158029 2020-06-22 Malaysia       8587 121 8177 289 4.210483999999999 101.97576600000001 2020-06-23 04:33:22 Malaysia
158487 2021-06-05 Malaysia       610574 3291 521676 85607 4.210483999999999 101.975766 2021-06-06 04:24:03 Malaysia

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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] INTEGER,
   [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]);