johns_hopkins_csse_daily_reports

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

172 rows where country_or_region = "Malaysia" sorted by day descending

View and edit SQL

country_or_region

  • Malaysia · 172

province_or_state

Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
181414 2020-07-13 Malaysia       8725 122 8520 83 4.210483999999999 101.97576600000001 2020-07-14 04:34:46 Malaysia
322120 2020-07-12 Malaysia       8718 122 8519 77 4.210483999999999 101.97576600000001 2020-07-13 04:43:04 Malaysia
275512 2020-07-11 Malaysia       8704 122 8515 67 4.210483999999999 101.97576600000001 2020-07-12 04:34:30 Malaysia
10484 2020-07-10 Malaysia       8696 121 8511 64 4.210483999999999 101.97576600000001 2020-07-11 04:34:26 Malaysia
342697 2020-07-09 Malaysia       8683 121 8499 63 4.210483999999999 101.97576600000001 2020-07-10 04:34:24 Malaysia
254427 2020-07-08 Malaysia       8677 121 8486 70 4.210483999999999 101.97576600000001 2020-07-09 04:34:23 Malaysia
250546 2020-07-07 Malaysia       8674 121 8481 72 4.210483999999999 101.97576600000001 2020-07-08 05:33:48 Malaysia
60322 2020-07-06 Malaysia       8668 121 8476 71 4.210483999999999 101.97576600000001 2020-07-07 04:34:00 Malaysia
370810 2020-07-05 Malaysia       8663 121 8465 77 4.210483999999999 101.97576600000001 2020-07-06 04:33:57 Malaysia
338892 2020-07-04 Malaysia       8658 121 8461 76 4.210483999999999 101.97576600000001 2020-07-05 04:33:46 Malaysia
271702 2020-07-03 Malaysia       8648 121 8446 81 4.210483999999999 101.97576600000001 2020-07-04 04:33:51 Malaysia
215475 2020-07-02 Malaysia       8643 121 8437 85 4.210483999999999 101.975766 2020-07-03 04:33:54 Malaysia
167901 2020-07-01 Malaysia       8640 121 8375 144 4.210483999999999 101.97576600000001 2020-07-02 04:33:46 Malaysia
356750 2020-06-30 Malaysia       8639 121 8354 164 4.210483999999999 101.97576600000001 2020-07-01 04:33:52 Malaysia
53898 2020-06-29 Malaysia       8637 121 8334 182 4.210483999999999 101.975766 2020-06-30 04:33:48 Malaysia
64406 2020-06-28 Malaysia       8634 121 8318 195 4.210483999999999 101.97576600000001 2020-06-29 04:33:44 Malaysia
87857 2020-06-27 Malaysia       8616 121 8308 187 4.210483999999999 101.97576600000001 2020-06-28 04:34:04 Malaysia
102045 2020-06-26 Malaysia       8606 121 8294 191 4.210483999999999 101.97576600000001 2020-06-27 04:33:35 Malaysia
394130 2020-06-25 Malaysia       8600 121 8271 208 4.210483999999999 101.97576600000001 2020-06-26 04:33:43 Malaysia
123398 2020-06-24 Malaysia       8596 121 8231 244 4.210483999999999 101.97576600000001 2020-06-25 05:26:54 Malaysia
113000 2020-06-23 Malaysia       8590 121 8186 283 4.210483999999999 101.97576600000001 2020-06-24 04:33:28 Malaysia
191479 2020-06-22 Malaysia       8587 121 8177 289 4.210483999999999 101.97576600000001 2020-06-23 04:33:22 Malaysia
198316 2020-06-21 Malaysia       8572 121 8156 295 4.210483999999999 101.97576600000001 2020-06-22 04:33:20 Malaysia
246745 2020-06-20 Malaysia       8556 121 8146 289 4.210483999999999 101.97576600000001 2020-06-21 04:33:19 Malaysia
94488 2020-06-19 Malaysia       8535 121 8070 344 4.210483999999999 101.97576600000001 2020-06-20 04:33:19 Malaysia
6533 2020-06-18 Malaysia       8529 121 8000 408 4.210483999999999 101.97576600000001 2020-06-19 04:33:17 Malaysia
43203 2020-06-17 Malaysia       8515 121 7873 521 4.210483999999999 101.97576600000001 2020-06-18 04:33:18 Malaysia
242992 2020-06-16 Malaysia       8505 121 7733 651 4.210483999999999 101.97576600000001 2020-06-17 04:33:21 Malaysia
138700 2020-06-15 Malaysia       8494 121 7400 973 4.210483999999999 101.97576600000001 2020-06-16 04:33:09 Malaysia
360739 2020-06-14 Malaysia       8453 121 7346 986 4.210483999999999 101.97576600000001 2020-06-15 03:33:14 Malaysia
232828 2020-06-13 Malaysia       8445 120 7311 1014 4.210483999999999 101.97576600000001 2020-06-14 03:33:15 Malaysia
160389 2020-06-12 Malaysia       8402 119 7168 1115 4.210483999999999 101.97576600000001 2020-06-13 03:33:14 Malaysia
164112 2020-06-11 Malaysia       8369 118 7065 1186 4.210483999999999 101.97576600000001 2020-06-12 05:09:52 Malaysia
156376 2020-06-10 Malaysia       8338 118 7014 1206 4.210483999999999 101.975766 2020-06-11 03:33:41 Malaysia
294285 2020-06-09 Malaysia       8336 117 6975 1244 4.210483999999999 101.975766 2020-06-10 04:07:00 Malaysia
106005 2020-06-08 Malaysia       8329 117 6694 1518 4.210483999999999 101.975766 2020-06-09 03:33:03 Malaysia
152587 2020-06-07 Malaysia       8322 117 6674 1531 4.210483999999999 101.975766 2020-06-08 03:33:22 Malaysia
282973 2020-06-06 Malaysia       8303 117 6635 1551 4.210483999999999 101.975766 2020-06-07 03:53:30 Malaysia
279181 2020-06-05 Malaysia       8266 116 6610 1540 4.210483999999999 101.975766 2020-06-06 02:33:00 Malaysia
177600 2020-06-04 Malaysia       8247 115 6559 1573 4.210483999999999 101.97576600000001 2020-06-05 02:33:06 Malaysia
349700 2020-06-03 Malaysia       7970 115 6531 1324 4.210483999999999 101.97576600000001 2020-06-04 02:33:14 Malaysia
314685 2020-06-02 Malaysia       7877 115 6470 1292 4.210483999999999 101.97576600000001 2020-06-03 02:33:13 Malaysia
205022 2020-06-01 Malaysia       7857 115 6404 1338 4.210483999999999 101.97576600000001 2020-06-02 02:33:08 Malaysia
98009 2020-05-31 Malaysia       7819 115 6353 1351 4.210483999999999 101.97576600000001 2020-06-01 02:32:46 Malaysia
264457 2020-05-30 Malaysia       7762 115 6330 1317 4.210483999999999 101.97576600000001 2020-05-31 02:32:45 Malaysia
219133 2020-05-29 Malaysia       7732 115 6235 1382 4.210483999999999 101.97576600000001 2020-05-30 02:32:48 Malaysia
26492 2020-05-28 Malaysia       7629 115 6169 1345 4.210483999999999 101.97576600000001 2020-05-29 02:32:50 Malaysia
325605 2020-05-27 Malaysia       7619 115 6083 1421 4.210483999999999 101.975766 2020-05-28 02:32:31 Malaysia
50107 2020-05-26 Malaysia       7604 115 6041 1448 4.210483999999999 101.975766 2020-05-27 02:32:31 Malaysia
260931 2020-05-25 Malaysia       7417 115 5979 1323 4.210483999999999 101.975766 2020-05-26 02:32:35 Malaysia
211677 2020-05-24 Malaysia       7245 115 5945 1185 4.210483999999999 101.975766 2020-05-25 02:32:44 Malaysia
134948 2020-05-23 Malaysia       7185 115 5912 1158 4.210483999999999 101.975766 2020-05-24 02:32:43 Malaysia
22973 2020-05-22 Malaysia       7137 115 5859 1163 4.210483999999999 101.975766 2020-05-23 02:32:42 Malaysia
318303 2020-05-21 Malaysia       7059 114 5796 1149 4.210483999999999 101.975766 2020-05-22 02:36:51 Malaysia
119618 2020-05-20 Malaysia       7009 114 5706 1189 4.210483999999999 101.975766 2020-05-21 02:32:48 Malaysia
229080 2020-05-19 Malaysia       6978 114 5646 1218 4.210483999999999 101.97576600000001 2020-05-20 02:32:19 Malaysia
346052 2020-05-18 Malaysia       6941 113 5615 1213 4.210483999999999 101.97576600000001 2020-05-19 02:32:18 Malaysia
29797 2020-05-17 Malaysia       6894 113 5571 1210 4.210483999999999 101.97576600000001 2020-05-18 02:32:21 Malaysia
290340 2020-05-16 Malaysia       6872 113 5512 1247 4.210483999999999 101.97576600000001 2020-05-17 02:32:32 Malaysia
236121 2020-05-15 Malaysia       6855 112 5439 1304 4.210483999999999 101.97576600000001 2020-05-16 02:32:19 Malaysia
173951 2020-05-14 Malaysia       6819 112 5351 1356 4.210483999999999 101.97576600000001 2020-05-15 02:33:02 Malaysia
46548 2020-05-13 Malaysia       6779 111 5281 1387 4.210483999999999 101.975766 2020-05-14 03:32:28 Malaysia
286459 2020-05-12 Malaysia       6742 109 5223 1410 4.210483999999999 101.975766 2020-05-13 03:32:26 Malaysia
304421 2020-05-11 Malaysia       6726 109 5113 1504 4.210483999999999 101.975766 2020-05-12 03:32:27 Malaysia
328837 2020-05-10 Malaysia       6656 108 5025 1523 4.210483999999999 101.975766 2020-05-11 02:32:30 Malaysia
109231 2020-05-09 Malaysia       6589 108 4929 1552 4.210483999999999 101.975766 2020-05-10 02:32:30 Malaysia
116222 2020-05-08 Malaysia       6535 107 4864 1564 4.210483999999999 101.975766 2020-05-09 02:32:35 Malaysia
332060 2020-05-07 Malaysia       6467 107 4776 1584 4.210483999999999 101.97576600000001 2020-05-08 02:32:32 Malaysia
145768 2020-05-06 Malaysia       6428 107 4702 1619 4.210483999999999 101.97576600000001 2020-05-07 02:32:28 Malaysia
380156 2020-05-05 Malaysia       6383 106 4567 1710 4.210483999999999 101.97576600000001 2020-05-06 02:32:31 Malaysia
307622 2020-05-04 Malaysia       6353 105 4484 1764 4.210483999999999 101.97576600000001 2020-05-05 02:32:34 Malaysia
390083 2020-05-03 Malaysia       6298 105 4413 1780 4.210483999999999 101.97576600000001 2020-05-04 02:32:28 Malaysia
363923 2020-05-02 Malaysia       6176 103 4326 1747 4.210483999999999 101.97576600000001 2020-05-03 02:32:28 Malaysia
71025 2020-05-01 Malaysia       6071 103 4210 1758 4.210483999999999 101.97576600000001 2020-05-02 02:32:27 Malaysia
208266 2020-04-30 Malaysia       6002 102 4171 1729 4.210483999999999 101.97576600000001 2020-05-01 02:32:28 Malaysia
267623 2020-04-29 Malaysia       5945 100 4087 1758 4.210483999999999 101.97576600000001 2020-04-30 02:32:27 Malaysia
184574 2020-04-28 Malaysia       5851 100 4032 1719 4.210483999999999 101.97576600000001 2020-04-29 02:32:29 Malaysia
352948 2020-04-27 Malaysia       5820 99 3957 1764 4.210483999999999 101.97576600000001 2020-04-28 02:30:32 Malaysia
142545 2020-04-26 Malaysia       5780 98 3862 1820 4.210483999999999 101.97576600000001 2020-04-27 02:30:33 Malaysia
222329 2020-04-25 Malaysia       5742 98 3762 1882 4.210483999999999 101.97576600000001 2020-04-26 02:30:31 Malaysia
386787 2020-04-24 Malaysia       5691 96 3663 1932 4.210483999999999 101.97576600000001 2020-04-25 06:30:33 Malaysia
239233 2020-04-23 Malaysia       5603 95 3542 1966 4.210483999999999 101.97576600000001 2020-04-24 03:30:31 Malaysia
257521 2020-04-22 Malaysia       5532 93 3452 1987 4.210483999999999 101.97576600000001 2020-04-22 23:30:32 Malaysia
376948 2020-04-21 Malaysia       5482 92 3349 2041 4.210483999999999 101.97576600000001 2020-04-21 23:30:30 Malaysia
367005 2020-04-20 Malaysia       5425 89 3295 2041 4.210483999999999 101.97576600000001 2020-04-20 23:36:27 Malaysia
201381 2020-04-19 Malaysia       5389 89 3197 2103 4.210484 101.975766 2020-04-19 23:40:41 Malaysia
373857 2020-04-18 Malaysia       5305 88 3102 2115 4.210484 101.975766 2020-04-18 22:32:28 Malaysia
77501 2020-04-17 Malaysia       5251 86 2967 2198 4.210483999999999 101.97576600000001 2020-04-17 23:30:32 Malaysia
148911 2020-04-16 Malaysia       5182 84 2766 2332 4.210483999999999 101.97576600000001 2020-04-16 23:30:31 Malaysia
19408 2020-04-15 Malaysia       5072 83 2647 2342 4.210483999999999 101.97576600000001 2020-04-15 22:56:32 Malaysia
84067 2020-04-14 Malaysia       4987 82 2478 2427 4.210483999999999 101.97576600000001 2020-04-14 23:33:12 Malaysia
32923 2020-04-13 Malaysia       4817 77 2276 2464 4.210483999999999 101.97576600000001 2020-04-13 23:07:34 Malaysia
126378 2020-04-12 Malaysia       4683 76 2108 2499 4.210484 101.975766 2020-04-12 23:17:00 Malaysia
35959 2020-04-11 Malaysia       4530 73 1995 2462 4.210483999999999 101.97576600000001 2020-04-11 22:45:13 Malaysia
194412 2020-04-10 Malaysia       4346 70 1830 2446 4.210483999999999 101.97576600000001 2020-04-10 22:53:48 Malaysia
80825 2020-04-09 Malaysia       4228 67 1608 2553 4.210483999999999 101.97576600000001 2020-04-09 23:02:19 Malaysia
90733 2020-04-08 Malaysia       4119 65 1487 2567 4.210483999999999 101.97576600000001 2020-04-08 22:51:39 Malaysia
2779 2020-04-07 Malaysia       3963 63 1321 2579 4.210483999999999 101.97576600000001 2020-04-07 23:04:29 Malaysia
335088 2020-04-06 Malaysia       3793 62 1241 2490 4.210484 101.975766 4/6/20 23:21 Malaysia
170658 2020-04-05 Malaysia       3662 61 1005 2596 4.210483999999999 101.97576600000001 2020-04-05 23:06:26 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
);
Powered by Datasette · Query took 2380.986ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette