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

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  
134267 2020-02-10 Malaysia       18 0 1       2020-02-10T03:03:09  
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  
320646 2020-01-30 Malaysia       8 0 0       1/30/20 16:00  
511431 2020-02-08 Malaysia       16 0 1       2020-02-08T10:23:04  
643074 2020-02-03 Malaysia       8 0 0       2020-01-31T08:15:53  
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  
962451 2020-02-24 Malaysia       22 0 18       2020-02-24T11:53:02  
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  
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  
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  
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  
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  
1613089 2020-02-04 Malaysia       10 0 0       2020-02-04T07:33:02  
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  
150261 2020-03-02 Malaysia       29 0 18   2.5 112.5 2020-03-01T12:53:02  
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  
415547 2020-03-09 Malaysia       117 0 24   2.5 112.5 2020-03-09T09:43:03  
642929 2020-03-03 Malaysia       36 0 22   2.5 112.5 2020-03-03T12:33:02  
1065352 2020-03-12 Malaysia       149 0 26   2.5 112.5 2020-03-11T11:33:08  
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  
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  
1426791 2020-03-08 Malaysia       99 0 24   2.5 112.5 2020-03-08T14:43:03  
1535384 2020-03-11 Malaysia       149 0 26   2.5 112.5 2020-03-11T11:33:08  
3444 2020-10-26 Malaysia       27805 236 17825 9744 4.210483999999999 101.975766 2020-10-27 04:24:45 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
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
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
162469 2021-01-25 Malaysia       186849 689 145084 41076 4.210483999999999 101.975766 2021-01-26 05:22:02 Malaysia
166531 2021-02-24 Malaysia       291774 1088 260009 30677 4.210483999999999 101.975766 2021-02-25 05:24:57 Malaysia
170500 2020-09-02 Malaysia       9360 128 9079 153 4.210483999999999 101.975766 2020-09-03 04:28:22 Malaysia
180350 2020-06-04 Malaysia       8247 115 6559 1573 4.210483999999999 101.97576600000001 2020-06-05 02:33:06 Malaysia
184098 2020-06-12 Malaysia       8402 119 7168 1115 4.210483999999999 101.97576600000001 2020-06-13 03:33:14 Malaysia
187229 2020-04-26 Malaysia       5780 98 3862 1820 4.210483999999999 101.97576600000001 2020-04-27 02:30:33 Malaysia
187698 2021-01-30 Malaysia       209661 746 161527 47388 4.210483999999999 101.975766 2021-01-31 05:22:42 Malaysia
191668 2020-08-17 Malaysia       9212 125 8876 211 4.210483999999999 101.975766 2020-08-18 04:27:56 Malaysia
195712 2021-05-28 Malaysia       549514 2552 474139 72823 4.210483999999999 101.975766 2021-05-29 04:20:41 Malaysia
202661 2020-03-24 Malaysia       1624 16 183 1425 4.210483999999999 101.97576600000001 2020-03-24 23:37:15 Malaysia
203116 2021-05-24 Malaysia       518600 2309 456273 60018 4.210483999999999 101.975766 2021-05-25 04:21:08 Malaysia
210582 2020-08-04 Malaysia       9002 125 8684 193 4.210483999999999 101.975766 2020-08-05 04:34:43 Malaysia
211042 2021-02-17 Malaysia       272163 1005 229762 41396 4.210483999999999 101.975766 2021-02-18 05:22:58 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]);