⚠️ 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 active

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  
1100452 2020-07-09 Malaysia       8683 121 8499 63 4.210483999999999 101.97576600000001 2020-07-10 04:34:24 Malaysia
238058 2020-07-10 Malaysia       8696 121 8511 64 4.210483999999999 101.97576600000001 2020-07-11 04:34:26 Malaysia
369109 2020-07-11 Malaysia       8704 122 8515 67 4.210483999999999 101.97576600000001 2020-07-12 04:34:30 Malaysia
1325873 2020-07-08 Malaysia       8677 121 8486 70 4.210483999999999 101.97576600000001 2020-07-09 04:34:23 Malaysia
919558 2020-07-06 Malaysia       8668 121 8476 71 4.210483999999999 101.97576600000001 2020-07-07 04:34:00 Malaysia
778491 2020-07-07 Malaysia       8674 121 8481 72 4.210483999999999 101.97576600000001 2020-07-08 05:33:48 Malaysia
134154 2020-07-04 Malaysia       8658 121 8461 76 4.210483999999999 101.97576600000001 2020-07-05 04:33:46 Malaysia
66960 2020-07-05 Malaysia       8663 121 8465 77 4.210483999999999 101.97576600000001 2020-07-06 04:33:57 Malaysia
682200 2020-07-12 Malaysia       8718 122 8519 77 4.210483999999999 101.97576600000001 2020-07-13 04:43:04 Malaysia
1234264 2020-07-16 Malaysia       8737 122 8538 77 4.210483999999999 101.975766 2020-07-17 04:34:50 Malaysia
646833 2020-07-03 Malaysia       8648 121 8446 81 4.210483999999999 101.97576600000001 2020-07-04 04:33:51 Malaysia
372929 2020-07-13 Malaysia       8725 122 8520 83 4.210483999999999 101.97576600000001 2020-07-14 04:34:46 Malaysia
578215 2020-07-14 Malaysia       8729 122 8524 83 4.210483999999999 101.97576600000001 2020-07-15 04:34:39 Malaysia
833090 2020-07-02 Malaysia       8643 121 8437 85 4.210483999999999 101.975766 2020-07-03 04:33:54 Malaysia
1682570 2020-07-15 Malaysia       8734 122 8526 86 4.210483999999999 101.975766 2020-07-16 04:44:59 Malaysia
14250 2020-07-17 Malaysia       8755 122 8541 92 4.210483999999999 101.97576600000001 2020-07-18 04:34:45 Malaysia
118604 2020-07-18 Malaysia       8764 122 8546 96 4.210483999999999 101.97576600000001 2020-07-19 04:34:58 Malaysia
441804 2020-07-19 Malaysia       8779 123 8553 103 4.210483999999999 101.97576600000001 2020-07-20 05:34:40 Malaysia
1092566 2020-07-20 Malaysia       8800 123 8555 122 4.210483999999999 101.97576600000001 2020-07-21 04:38:46 Malaysia
1152027 2020-07-21 Malaysia       8815 123 8562 130 4.210483999999999 101.97576600000001 2020-07-22 04:34:42 Malaysia
249690 2020-07-22 Malaysia       8831 123 8566 142 4.210483999999999 101.975766 2020-07-23 05:15:04 Malaysia
654519 2020-07-23 Malaysia       8840 123 8574 143 4.210483999999999 101.97576600000001 2020-07-24 05:30:40 Malaysia
1144121 2020-07-01 Malaysia       8640 121 8375 144 4.210483999999999 101.97576600000001 2020-07-02 04:33:46 Malaysia
524044 2020-09-05 Malaysia       9391 128 9113 150 4.210483999999999 101.975766 2020-09-06 04:28:33 Malaysia
353837 2020-08-28 Malaysia       9306 125 9030 151 4.210483999999999 101.975766 2020-08-29 04:28:19 Malaysia
666932 2020-09-01 Malaysia       9354 128 9075 151 4.210483999999999 101.975766 2020-09-02 04:28:25 Malaysia
170500 2020-09-02 Malaysia       9360 128 9079 153 4.210483999999999 101.975766 2020-09-03 04:28:22 Malaysia
446218 2020-08-29 Malaysia       9317 125 9038 154 4.210483999999999 101.975766 2020-08-30 04:28:22 Malaysia
1399228 2020-09-06 Malaysia       9397 128 9115 154 4.210483999999999 101.975766 2020-09-07 04:28:30 Malaysia
254122 2020-08-31 Malaysia       9340 127 9054 159 4.210483999999999 101.975766 2020-09-01 04:28:31 Malaysia
1363982 2020-08-30 Malaysia       9334 126 9048 160 4.210483999999999 101.975766 2020-08-31 04:28:27 Malaysia
896735 2020-07-24 Malaysia       8861 123 8577 161 4.210483999999999 101.975766 2020-07-25 04:47:39 Malaysia
1104852 2020-09-03 Malaysia       9374 128 9083 163 4.210483999999999 101.975766 2020-09-04 04:28:26 Malaysia
806185 2020-06-30 Malaysia       8639 121 8354 164 4.210483999999999 101.97576600000001 2020-07-01 04:33:52 Malaysia
608142 2020-09-04 Malaysia       9385 128 9092 165 4.210483999999999 101.975766 2020-09-05 04:28:19 Malaysia
1701655 2020-08-10 Malaysia       9094 125 8803 166 4.210483999999999 101.975766 2020-08-11 04:35:08 Malaysia
1341756 2020-07-25 Malaysia       8884 123 8594 167 4.210483999999999 101.975766 2020-07-26 04:35:00 Malaysia
111176 2020-08-11 Malaysia       9103 125 8809 169 4.210483999999999 101.975766 2020-08-12 04:27:29 Malaysia
106749 2020-08-08 Malaysia       9070 125 8775 170 4.210483999999999 101.975766 2020-08-09 04:34:54 Malaysia
551031 2020-08-12 Malaysia       9114 125 8817 172 4.210483999999999 101.975766 2020-08-13 04:29:15 Malaysia
485464 2020-07-26 Malaysia       8897 124 8600 173 4.210483999999999 101.975766 2020-07-27 04:35:02 Malaysia
570405 2020-08-09 Malaysia       9083 125 8784 174 4.210483999999999 101.975766 2020-08-10 04:34:55 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]);