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

518 rows where country_or_region = "Malaysia" sorted by country_or_region

View and edit SQL

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

country_or_region

  • Malaysia · 518

province_or_state

Link rowid day country_or_region ▼ province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
382 2021-02-27 Malaysia       298315 1121 270166 27028 4.210483999999999 101.975766 2021-02-28 05:22:20 Malaysia
7561 2020-06-04 Malaysia       8247 115 6559 1573 4.210483999999999 101.97576600000001 2020-06-05 02:33:06 Malaysia
8008 2020-08-11 Malaysia       9103 125 8809 169 4.210483999999999 101.975766 2020-08-12 04:27:29 Malaysia
11962 2020-09-27 Malaysia       10919 134 9835 950 4.210484 101.975766 2020-09-28 04:23:00 Malaysia
18719 2020-05-12 Malaysia       6742 109 5223 1410 4.210483999999999 101.975766 2020-05-13 03:32:26 Malaysia
19188 2021-05-31 Malaysia       572357 2796 490038 79523 4.210483999999999 101.975766 2021-06-01 04:23:09 Malaysia
23174 2021-05-05 Malaysia       424376 1591 389846 32939 4.210483999999999 101.975766 2021-05-06 04:20:38 Malaysia
27160 2021-02-08 Malaysia       245552 896 192679 51977 4.210483999999999 101.975766 2021-02-09 05:23:30 Malaysia
33691 2020-04-13 Malaysia       4817 77 2276 2464 4.210483999999999 101.97576600000001 2020-04-13 23:07:34 Malaysia
34153 2020-11-20 Malaysia       52638 329 39088 13221 4.210483999999999 101.975766 2020-11-21 05:25:51 Malaysia
38124 2020-09-20 Malaysia       10219 130 9355 734 4.210484 101.975766 2020-09-21 04:23:00 Malaysia
42103 2021-06-16 Malaysia       673026 4142 600935 67949 4.210483999999999 101.975766 2021-06-17 04:22:36 Malaysia
46087 2020-12-21 Malaysia       95327 438 78393 16496 4.210483999999999 101.975766 2020-12-22 05:22:33 Malaysia
50058 2020-09-04 Malaysia       9385 128 9092 165 4.210483999999999 101.975766 2020-09-05 04:28:19 Malaysia
57253 2020-06-05 Malaysia       8266 116 6610 1540 4.210483999999999 101.975766 2020-06-06 02:33:00 Malaysia
57715 2021-05-20 Malaysia       492302 2099 440032 50171 4.210483999999999 101.975766 2021-05-21 04:20:43 Malaysia
65008 2020-06-22 Malaysia       8587 121 8177 289 4.210483999999999 101.97576600000001 2020-06-23 04:33:22 Malaysia
65467 2021-02-13 Malaysia       261805 958 209289 51558 4.210483999999999 101.975766 2021-02-14 05:23:43 Malaysia
69452 2020-11-14 Malaysia       46209 306 33772 12131 4.210483999999999 101.975766 2020-11-15 05:26:53 Malaysia
76415 2020-03-28 Malaysia       2320 27 320 1973 4.210484 101.975766 3/28/20 23:05 Malaysia
76873 2020-11-15 Malaysia       47417 309 34785 12323 4.210483999999999 101.975766 2020-11-16 05:25:57 Malaysia
80860 2021-05-28 Malaysia       549514 2552 474139 72823 4.210483999999999 101.975766 2021-05-29 04:20:41 Malaysia
84846 2021-03-17 Malaysia       327253 1220 310958 15075 4.210483999999999 101.975766 2021-03-18 05:26:22 Malaysia
88833 2021-05-08 Malaysia       436944 1657 398723 36564 4.210483999999999 101.975766 2021-05-09 04:20:35 Malaysia
95806 2020-03-30 Malaysia       2626 37 479 2110 4.210484 101.975766 3/30/20 22:52 Malaysia
99235 2020-03-26 Malaysia       2031 23 215 1793 4.210483999999999 101.97576600000001 2020-03-26 23:48:18 Malaysia
99693 2020-11-17 Malaysia       49730 318 36624 12788 4.210483999999999 101.975766 2020-11-18 05:40:31 Malaysia
106970 2020-06-13 Malaysia       8445 120 7311 1014 4.210483999999999 101.97576600000001 2020-06-14 03:33:15 Malaysia
107428 2020-12-07 Malaysia       74294 384 62306 11604 4.210483999999999 101.975766 2020-12-08 05:27:42 Malaysia
113813 2020-04-07 Malaysia       3963 63 1321 2579 4.210483999999999 101.97576600000001 2020-04-07 23:04:29 Malaysia
116900 2020-04-20 Malaysia       5425 89 3295 2041 4.210483999999999 101.97576600000001 2020-04-20 23:36:27 Malaysia
120713 2020-07-05 Malaysia       8663 121 8465 77 4.210483999999999 101.97576600000001 2020-07-06 04:33:57 Malaysia
120829 2020-02-21 Malaysia       22 0 15       2020-02-19T09:33:03  
121263 2021-05-09 Malaysia       440677 1683 401934 37060 4.210483999999999 101.975766 2021-05-10 04:20:38 Malaysia
125250 2021-04-01 Malaysia       346678 1278 331001 14399 4.210483999999999 101.975766 2021-04-02 04:20:36 Malaysia
129237 2021-05-11 Malaysia       448457 1722 408236 38499 4.210483999999999 101.975766 2021-05-12 04:21:29 Malaysia
132887 2020-03-04 Malaysia       50 0 22   2.5 112.5 2020-03-04T13:03:08  
133389 2021-02-28 Malaysia       300752 1130 273417 26205 4.210483999999999 101.975766 2021-03-01 05:23:01 Malaysia
137035 2020-01-23 Malaysia       0 0 0       1/23/20 17:00  
137067 2020-03-20 Malaysia       1030 3 87   4.2105 101.9758 2020-03-20T18:13:09  
137731 2021-03-09 Malaysia       316269 1186 296379 18704 4.210483999999999 101.975766 2021-03-10 05:24:35 Malaysia
141717 2021-01-08 Malaysia       131108 537 105431 25140 4.210483999999999 101.975766 2021-01-09 05:22:18 Malaysia
145689 2020-10-27 Malaysia       28640 238 18499 9903 4.210483999999999 101.975766 2020-10-28 04:24:39 Malaysia
149671 2021-05-24 Malaysia       518600 2309 456273 60018 4.210483999999999 101.975766 2021-05-25 04:21:08 Malaysia
153317 2020-02-25 Malaysia       22 0 18       2020-02-24T11:53:02  
153743 2020-10-02 Malaysia       11771 136 10095 1540 4.210483999999999 101.975766 2020-10-03 04:23:40 Malaysia
160451 2020-05-01 Malaysia       6071 103 4210 1758 4.210483999999999 101.97576600000001 2020-05-02 02:32:27 Malaysia
160915 2020-12-19 Malaysia       91969 433 76242 15294 4.210483999999999 101.975766 2020-12-20 05:27:32 Malaysia
164901 2021-03-04 Malaysia       307943 1153 283629 23161 4.210483999999999 101.975766 2021-03-05 05:26:29 Malaysia
168886 2020-11-24 Malaysia       58847 341 44153 14353 4.210483999999999 101.975766 2020-11-25 05:27:20 Malaysia
175718 2020-05-16 Malaysia       6872 113 5512 1247 4.210483999999999 101.97576600000001 2020-05-17 02:32:32 Malaysia
176183 2020-12-17 Malaysia       89133 432 74030 14671 4.210483999999999 101.975766 2020-12-18 05:28:18 Malaysia
180154 2020-08-29 Malaysia       9317 125 9038 154 4.210483999999999 101.975766 2020-08-30 04:28:22 Malaysia
184114 2020-10-07 Malaysia       13993 141 10501 3351 4.210483999999999 101.975766 2020-10-08 04:23:56 Malaysia
191575 2020-07-31 Malaysia       8976 125 8644 207 4.210483999999999 101.975766 2020-08-01 04:36:27 Malaysia
195222 2020-06-01 Malaysia       7857 115 6404 1338 4.210483999999999 101.97576600000001 2020-06-02 02:33:08 Malaysia
195671 2020-10-04 Malaysia       12381 137 10283 1961 4.210483999999999 101.975766 2020-10-05 04:23:33 Malaysia
199311 2020-03-07 Malaysia       93 0 23   2.5 112.5 2020-03-07T17:53:03  
199866 2020-10-12 Malaysia       16220 159 11022 5039 4.210483999999999 101.975766 2020-10-13 04:24:02 Malaysia
206564 2020-04-30 Malaysia       6002 102 4171 1729 4.210483999999999 101.97576600000001 2020-05-01 02:32:28 Malaysia
207029 2021-01-05 Malaysia       122845 509 99449 22887 4.210483999999999 101.975766 2021-01-06 05:22:16 Malaysia
211000 2020-09-18 Malaysia       10147 129 9264 754 4.210484 101.975766 2020-09-19 04:22:00 Malaysia
214978 2021-04-04 Malaysia       350959 1288 335162 14509 4.210483999999999 101.975766 2021-04-05 04:20:35 Malaysia
218963 2020-12-01 Malaysia       67169 363 56311 10495 4.210483999999999 101.975766 2020-12-02 05:27:41 Malaysia
222947 2021-01-01 Malaysia       115078 474 91171 23433 4.210483999999999 101.975766 2021-01-02 05:22:33 Malaysia
226589 2020-02-09 Malaysia       16 0 1       2020-02-08T10:23:04  
227011 2021-06-21 Malaysia       701019 4477 633624 62918 4.210483999999999 101.975766 2021-06-22 04:21:34 Malaysia
230997 2021-05-17 Malaysia       474556 1947 429103 43506 4.210483999999999 101.975766 2021-05-18 04:20:33 Malaysia
234985 2021-06-24 Malaysia       716847 4721 650964 61162 4.210483999999999 101.975766 2021-06-25 04:21:33 Malaysia
242274 2020-06-20 Malaysia       8556 121 8146 289 4.210483999999999 101.97576600000001 2020-06-21 04:33:19 Malaysia
242389 2020-02-05 Malaysia       12 0 0       2020-02-05T15:43:02  
245515 2020-04-28 Malaysia       5851 100 4032 1719 4.210483999999999 101.97576600000001 2020-04-29 02:32:29 Malaysia
245981 2021-06-06 Malaysia       616815 3378 526809 86628 4.210483999999999 101.975766 2021-06-07 04:22:51 Malaysia
249965 2020-12-06 Malaysia       72694 382 61273 11039 4.210483999999999 101.975766 2020-12-07 05:26:14 Malaysia
253951 2021-03-16 Malaysia       326034 1218 309612 15204 4.210483999999999 101.975766 2021-03-17 05:25:07 Malaysia
261417 2020-07-29 Malaysia       8956 124 8612 220 4.210483999999999 101.975766 2020-07-30 04:35:05 Malaysia
261881 2020-11-25 Malaysia       59817 345 46501 12971 4.210483999999999 101.975766 2020-11-26 05:27:44 Malaysia
265865 2020-12-10 Malaysia       78499 396 66236 11867 4.210483999999999 101.975766 2020-12-11 05:26:59 Malaysia
272438 2020-04-17 Malaysia       5251 86 2967 2198 4.210483999999999 101.97576600000001 2020-04-17 23:30:32 Malaysia
272904 2021-06-10 Malaysia       639562 3684 556030 79848 4.210483999999999 101.975766 2021-06-11 04:23:20 Malaysia
280223 2020-06-28 Malaysia       8634 121 8318 195 4.210483999999999 101.97576600000001 2020-06-29 04:33:44 Malaysia
280682 2021-02-10 Malaysia       251604 923 198495 52186 4.210483999999999 101.975766 2021-02-11 05:23:55 Malaysia
287519 2020-05-17 Malaysia       6894 113 5571 1210 4.210483999999999 101.97576600000001 2020-05-18 02:32:21 Malaysia
287985 2021-01-31 Malaysia       214959 760 166049 48150 4.210483999999999 101.975766 2021-02-01 05:22:53 Malaysia
291972 2021-02-17 Malaysia       272163 1005 229762 41396 4.210483999999999 101.975766 2021-02-18 05:22:58 Malaysia
298928 2020-03-25 Malaysia       1796 20 199 1577 4.210483999999999 101.97576600000001 2020-03-25 23:33:04 Malaysia
299388 2021-03-06 Malaysia       311777 1166 289452 21159 4.210483999999999 101.975766 2021-03-07 05:21:54 Malaysia
303376 2021-06-18 Malaysia       685204 4276 615326 65602 4.210483999999999 101.975766 2021-06-19 04:22:33 Malaysia
307361 2021-01-17 Malaysia       158434 601 120051 37782 4.210483999999999 101.975766 2021-01-18 05:22:34 Malaysia
311334 2020-09-23 Malaysia       10505 133 9602 770 4.210484 101.975766 2020-09-24 04:23:00 Malaysia
315298 2020-08-19 Malaysia       9235 125 8925 185 4.210483999999999 101.975766 2020-08-20 04:27:43 Malaysia
319272 2021-06-13 Malaysia       657508 3908 580276 73324 4.210483999999999 101.975766 2021-06-14 04:22:46 Malaysia
323257 2021-01-24 Malaysia       183801 678 141446 41677 4.210483999999999 101.975766 2021-01-25 05:22:16 Malaysia
330467 2020-06-09 Malaysia       8336 117 6975 1244 4.210483999999999 101.975766 2020-06-10 04:07:00 Malaysia
330914 2020-08-12 Malaysia       9114 125 8817 172 4.210483999999999 101.975766 2020-08-13 04:29:15 Malaysia
334881 2021-04-27 Malaysia       398451 1462 371575 25414 4.210483999999999 101.975766 2021-04-28 04:20:32 Malaysia
342344 2020-07-28 Malaysia       8943 124 8607 212 4.210483999999999 101.975766 2020-07-29 04:35:11 Malaysia
342810 2021-02-20 Malaysia       280272 1051 244753 34468 4.210483999999999 101.975766 2021-02-21 05:24:33 Malaysia
349868 2020-05-31 Malaysia       7819 115 6353 1351 4.210483999999999 101.97576600000001 2020-06-01 02:32:46 Malaysia
350333 2021-04-06 Malaysia       353329 1300 337868 14161 4.210483999999999 101.975766 2021-04-07 04:20:53 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]);