johns_hopkins_csse_daily_reports

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

1,073 rows where country_or_region = "Malaysia" and province_or_state = "Pulau Pinang" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

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

province_or_state 1

  • Pulau Pinang · 1,073 ✖

country_or_region 1

  • Malaysia · 1,073 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2752966 2752966 2022-12-29 Malaysia Pulau Pinang     306830 2061 0   5.4141 100.3288 2022-12-30 04:21:04 Pulau Pinang, Malaysia
1073972 1073972 2022-12-28 Malaysia Pulau Pinang     306786 2061 0   5.4141 100.3288 2022-12-29 04:21:01 Pulau Pinang, Malaysia
327969 327969 2022-12-27 Malaysia Pulau Pinang     306754 2061 0   5.4141 100.3288 2022-12-28 04:21:04 Pulau Pinang, Malaysia
218042 218042 2022-12-26 Malaysia Pulau Pinang     306721 2060 0   5.4141 100.3288 2022-12-27 04:21:07 Pulau Pinang, Malaysia
3222499 3222499 2022-12-25 Malaysia Pulau Pinang     306672 2059 0   5.4141 100.3288 2022-12-26 04:21:06 Pulau Pinang, Malaysia
1018413 1018413 2022-12-24 Malaysia Pulau Pinang     306616 2059 0   5.4141 100.3288 2022-12-25 04:21:04 Pulau Pinang, Malaysia
690436 690436 2022-12-23 Malaysia Pulau Pinang     306575 2059 0   5.4141 100.3288 2022-12-24 04:21:02 Pulau Pinang, Malaysia
2179646 2179646 2022-12-22 Malaysia Pulau Pinang     306522 2058 0   5.4141 100.3288 2022-12-23 04:21:04 Pulau Pinang, Malaysia
451450 451450 2022-12-21 Malaysia Pulau Pinang     306475 2057 0   5.4141 100.3288 2022-12-22 04:20:56 Pulau Pinang, Malaysia
2951449 2951449 2022-12-20 Malaysia Pulau Pinang     306427 2056 0   5.4141 100.3288 2022-12-21 04:21:03 Pulau Pinang, Malaysia
3173851 3173851 2022-12-19 Malaysia Pulau Pinang     306393 2056 0   5.4141 100.3288 2022-12-20 04:21:04 Pulau Pinang, Malaysia
1628368 1628368 2022-12-18 Malaysia Pulau Pinang     306345 2056 0   5.4141 100.3288 2022-12-19 04:21:03 Pulau Pinang, Malaysia
503747 503747 2022-12-17 Malaysia Pulau Pinang     306298 2056 0   5.4141 100.3288 2022-12-18 04:21:03 Pulau Pinang, Malaysia
3324319 3324319 2022-12-16 Malaysia Pulau Pinang     306235 2056 0   5.4141 100.3288 2022-12-17 04:21:04 Pulau Pinang, Malaysia
542831 542831 2022-12-15 Malaysia Pulau Pinang     306153 2054 0   5.4141 100.3288 2022-12-16 04:21:01 Pulau Pinang, Malaysia
348359 348359 2022-12-14 Malaysia Pulau Pinang     306094 2054 0   5.4141 100.3288 2022-12-15 04:20:58 Pulau Pinang, Malaysia
307947 307947 2022-12-13 Malaysia Pulau Pinang     306033 2054 0   5.4141 100.3288 2022-12-14 04:21:04 Pulau Pinang, Malaysia
1149008 1149008 2022-12-12 Malaysia Pulau Pinang     305983 2054 0   5.4141 100.3288 2022-12-13 04:21:01 Pulau Pinang, Malaysia
868862 868862 2022-12-11 Malaysia Pulau Pinang     305928 2054 0   5.4141 100.3288 2022-12-12 04:21:01 Pulau Pinang, Malaysia
257392 257392 2022-12-10 Malaysia Pulau Pinang     305856 2051 0   5.4141 100.3288 2022-12-11 04:20:50 Pulau Pinang, Malaysia
3936106 3936106 2022-12-09 Malaysia Pulau Pinang     305753 2051 0   5.4141 100.3288 2022-12-10 04:21:02 Pulau Pinang, Malaysia
3377438 3377438 2022-12-08 Malaysia Pulau Pinang     305620 2051 0   5.4141 100.3288 2022-12-09 04:21:05 Pulau Pinang, Malaysia
1984709 1984709 2022-12-07 Malaysia Pulau Pinang     305490 2051 0   5.4141 100.3288 2022-12-08 04:21:07 Pulau Pinang, Malaysia
3714232 3714232 2022-12-06 Malaysia Pulau Pinang     305367 2051 0   5.4141 100.3288 2022-12-07 04:20:58 Pulau Pinang, Malaysia
2414937 2414937 2022-12-05 Malaysia Pulau Pinang     305280 2051 0   5.4141 100.3288 2022-12-06 04:21:03 Pulau Pinang, Malaysia
718545 718545 2022-12-04 Malaysia Pulau Pinang     305198 2051 0   5.4141 100.3288 2022-12-05 04:20:58 Pulau Pinang, Malaysia
2816834 2816834 2022-12-03 Malaysia Pulau Pinang     305106 2050 0   5.4141 100.3288 2022-12-04 04:20:56 Pulau Pinang, Malaysia
833690 833690 2022-12-02 Malaysia Pulau Pinang     305003 2050 0   5.4141 100.3288 2022-12-03 04:21:02 Pulau Pinang, Malaysia
2136220 2136220 2022-12-01 Malaysia Pulau Pinang     304901 2050 0   5.4141 100.3288 2022-12-02 04:21:07 Pulau Pinang, Malaysia
1964636 1964636 2022-11-30 Malaysia Pulau Pinang     304768 2049 0   5.4141 100.3288 2022-12-01 04:21:03 Pulau Pinang, Malaysia
2556650 2556650 2022-11-29 Malaysia Pulau Pinang     304686 2047 0   5.4141 100.3288 2022-11-30 04:21:07 Pulau Pinang, Malaysia
1239724 1239724 2022-11-28 Malaysia Pulau Pinang     304605 2047 0   5.4141 100.3288 2022-11-29 04:21:05 Pulau Pinang, Malaysia
3551712 3551712 2022-11-27 Malaysia Pulau Pinang     304524 2047 0   5.4141 100.3288 2022-11-28 04:21:02 Pulau Pinang, Malaysia
2100192 2100192 2022-11-26 Malaysia Pulau Pinang     304390 2047 0   5.4141 100.3288 2022-11-27 04:21:05 Pulau Pinang, Malaysia
487683 487683 2022-11-25 Malaysia Pulau Pinang     304270 2047 0   5.4141 100.3288 2022-11-26 04:21:11 Pulau Pinang, Malaysia
3523512 3523512 2022-11-24 Malaysia Pulau Pinang     304092 2047 0   5.4141 100.3288 2022-11-25 04:21:06 Pulau Pinang, Malaysia
3312295 3312295 2022-11-23 Malaysia Pulau Pinang     303908 2047 0   5.4141 100.3288 2022-11-24 04:21:09 Pulau Pinang, Malaysia
1620336 1620336 2022-11-22 Malaysia Pulau Pinang     303728 2047 0   5.4141 100.3288 2022-11-23 04:21:06 Pulau Pinang, Malaysia
3460224 3460224 2022-11-21 Malaysia Pulau Pinang     303633 2047 0   5.4141 100.3288 2022-11-22 04:20:47 Pulau Pinang, Malaysia
1640409 1640409 2022-11-20 Malaysia Pulau Pinang     303564 2046 0   5.4141 100.3288 2022-11-21 04:21:05 Pulau Pinang, Malaysia
2063966 2063966 2022-11-19 Malaysia Pulau Pinang     303416 2045 0   5.4141 100.3288 2022-11-20 04:21:08 Pulau Pinang, Malaysia
1755360 1755360 2022-11-18 Malaysia Pulau Pinang     303280 2045 0   5.4141 100.3288 2022-11-19 04:21:14 Pulau Pinang, Malaysia
3026353 3026353 2022-11-17 Malaysia Pulau Pinang     303094 2043 0   5.4141 100.3288 2022-11-18 04:21:15 Pulau Pinang, Malaysia
2486064 2486064 2022-11-16 Malaysia Pulau Pinang     302878 2043 0   5.4141 100.3288 2022-11-17 04:21:11 Pulau Pinang, Malaysia
292075 292075 2022-11-15 Malaysia Pulau Pinang     302705 2042 0   5.4141 100.3288 2022-11-16 04:21:09 Pulau Pinang, Malaysia
3597105 3597105 2022-11-14 Malaysia Pulau Pinang     302613 2039 0   5.4141 100.3288 2022-11-15 04:21:16 Pulau Pinang, Malaysia
311963 311963 2022-11-13 Malaysia Pulau Pinang     302543 2038 0   5.4141 100.3288 2022-11-14 04:21:09 Pulau Pinang, Malaysia
63124 63124 2022-11-12 Malaysia Pulau Pinang     302408 2038 0   5.4141 100.3288 2022-11-13 04:21:14 Pulau Pinang, Malaysia
2927286 2927286 2022-11-11 Malaysia Pulau Pinang     302218 2036 0   5.4141 100.3288 2022-11-12 04:20:41 Pulau Pinang, Malaysia
2506122 2506122 2022-11-10 Malaysia Pulau Pinang     302058 2036 0   5.4141 100.3288 2022-11-11 04:21:22 Pulau Pinang, Malaysia
2430997 2430997 2022-11-09 Malaysia Pulau Pinang     301821 2036 0   5.4141 100.3288 2022-11-10 04:21:16 Pulau Pinang, Malaysia
479653 479653 2022-11-08 Malaysia Pulau Pinang     301676 2036 0   5.4141 100.3288 2022-11-09 04:21:22 Pulau Pinang, Malaysia
2438803 2438803 2022-11-07 Malaysia Pulau Pinang     301574 2036 0   5.4141 100.3288 2022-11-08 04:21:21 Pulau Pinang, Malaysia
1049901 1049901 2022-11-06 Malaysia Pulau Pinang     301442 2034 0   5.4141 100.3288 2022-11-07 04:21:26 Pulau Pinang, Malaysia
617925 617925 2022-11-05 Malaysia Pulau Pinang     301235 2034 0   5.4141 100.3288 2022-11-06 04:21:24 Pulau Pinang, Malaysia
1022429 1022429 2022-11-04 Malaysia Pulau Pinang     301007 2034 0   5.4141 100.3288 2022-11-05 04:21:52 Pulau Pinang, Malaysia
431420 431420 2022-11-03 Malaysia Pulau Pinang     300755 2034 0   5.4141 100.3288 2022-11-04 04:22:11 Pulau Pinang, Malaysia
849662 849662 2022-11-02 Malaysia Pulau Pinang     300523 2034 0   5.4141 100.3288 2022-11-03 04:22:05 Pulau Pinang, Malaysia
710513 710513 2022-11-01 Malaysia Pulau Pinang     300366 2034 0   5.4141 100.3288 2022-11-02 04:22:09 Pulau Pinang, Malaysia
3284962 3284962 2022-10-31 Malaysia Pulau Pinang     300257 2033 0   5.4141 100.3288 2022-11-01 04:22:36 Pulau Pinang, Malaysia
319995 319995 2022-10-30 Malaysia Pulau Pinang     300117 2033 0   5.4141 100.3288 2022-10-31 04:21:36 Pulau Pinang, Malaysia
912271 912271 2022-10-29 Malaysia Pulau Pinang     299944 2032 0   5.4141 100.3288 2022-10-30 04:22:14 Pulau Pinang, Malaysia
1366540 1366540 2022-10-28 Malaysia Pulau Pinang     299788 2032 0   5.4141 100.3288 2022-10-29 04:21:13 Pulau Pinang, Malaysia
3038395 3038395 2022-10-27 Malaysia Pulau Pinang     299648 2032 0   5.4141 100.3288 2022-10-28 04:22:31 Pulau Pinang, Malaysia
538815 538815 2022-10-26 Malaysia Pulau Pinang     299544 2031 0   5.4141 100.3288 2022-10-27 04:22:01 Pulau Pinang, Malaysia
1830216 1830216 2022-10-25 Malaysia Pulau Pinang     299488 2031 0   5.4141 100.3288 2022-10-26 04:22:19 Pulau Pinang, Malaysia
794477 794477 2022-10-24 Malaysia Pulau Pinang     299429 2031 0   5.4141 100.3288 2022-10-25 04:21:53 Pulau Pinang, Malaysia
3276932 3276932 2022-10-23 Malaysia Pulau Pinang     299324 2031 0   5.4141 100.3288 2022-10-24 04:22:29 Pulau Pinang, Malaysia
2267970 2267970 2022-10-22 Malaysia Pulau Pinang     299193 2031 0   5.4141 100.3288 2022-10-23 04:22:46 Pulau Pinang, Malaysia
1592270 1592270 2022-10-21 Malaysia Pulau Pinang     299063 2031 0   5.4141 100.3288 2022-10-22 04:22:53 Pulau Pinang, Malaysia
2271986 2271986 2022-10-20 Malaysia Pulau Pinang     298956 2031 0   5.4141 100.3288 2022-10-21 04:22:23 Pulau Pinang, Malaysia
198321 198321 2022-10-19 Malaysia Pulau Pinang     298858 2031 0   5.4141 100.3288 2022-10-20 04:22:59 Pulau Pinang, Malaysia
2756982 2756982 2022-10-18 Malaysia Pulau Pinang     298785 2031 0   5.4141 100.3288 2022-10-19 04:22:26 Pulau Pinang, Malaysia
2024816 2024816 2022-10-17 Malaysia Pulau Pinang     298725 2031 0   5.4141 100.3288 2022-10-18 04:22:42 Pulau Pinang, Malaysia
2159594 2159594 2022-10-16 Malaysia Pulau Pinang     298644 2031 0   5.4141 100.3288 2022-10-17 04:20:31 Pulau Pinang, Malaysia
515791 515791 2022-10-15 Malaysia Pulau Pinang     298585 2031 0   5.4141 100.3288 2022-10-16 04:22:39 Pulau Pinang, Malaysia
2032848 2032848 2022-10-14 Malaysia Pulau Pinang     298489 2031 0   5.4141 100.3288 2022-10-15 04:22:00 Pulau Pinang, Malaysia
3753536 3753536 2022-10-13 Malaysia Pulau Pinang     298393 2030 0   5.4141 100.3288 2022-10-14 04:22:28 Pulau Pinang, Malaysia
3214361 3214361 2022-10-12 Malaysia Pulau Pinang     298288 2030 0   5.4141 100.3288 2022-10-13 04:22:39 Pulau Pinang, Malaysia
3250210 3250210 2022-10-11 Malaysia Pulau Pinang     298237 2030 0   5.4141 100.3288 2022-10-12 04:22:51 Pulau Pinang, Malaysia
2967469 2967469 2022-10-10 Malaysia Pulau Pinang     298184 2030 0   5.4141 100.3288 2022-10-11 04:23:05 Pulau Pinang, Malaysia
3097505 3097505 2022-10-09 Malaysia Pulau Pinang     298121 2029 0   5.4141 100.3288 2022-10-10 04:22:32 Pulau Pinang, Malaysia
4002730 4002730 2022-10-08 Malaysia Pulau Pinang     298052 2029 0   5.4141 100.3288 2022-10-09 04:21:16 Pulau Pinang, Malaysia
396327 396327 2022-10-07 Malaysia Pulau Pinang     297965 2029 0   5.4141 100.3288 2022-10-08 04:22:56 Pulau Pinang, Malaysia
2529444 2529444 2022-10-06 Malaysia Pulau Pinang     297871 2029 0   5.4141 100.3288 2022-10-07 04:23:08 Pulau Pinang, Malaysia
1810838 1810838 2022-10-05 Malaysia Pulau Pinang     297786 2029 0   5.4141 100.3288 2022-10-06 04:21:22 Pulau Pinang, Malaysia
130812 130812 2022-10-04 Malaysia Pulau Pinang     297712 2029 0   5.4141 100.3288 2022-10-05 04:23:06 Pulau Pinang, Malaysia
2685759 2685759 2022-10-03 Malaysia Pulau Pinang     297728 2029 0   5.4141 100.3288 2022-10-04 04:22:55 Pulau Pinang, Malaysia
2259826 2259826 2022-10-02 Malaysia Pulau Pinang     297728 2029 0   5.4141 100.3288 2022-10-03 04:23:11 Pulau Pinang, Malaysia
2995352 2995352 2022-10-01 Malaysia Pulau Pinang     297728 2029 0   5.4141 100.3288 2022-10-02 04:21:23 Pulau Pinang, Malaysia
853678 853678 2022-09-30 Malaysia Pulau Pinang     297398 2029 0   5.4141 100.3288 2022-10-01 04:23:01 Pulau Pinang, Malaysia
2375604 2375604 2022-09-29 Malaysia Pulau Pinang     297281 2029 0   5.4141 100.3288 2022-09-30 04:23:09 Pulau Pinang, Malaysia
1560155 1560155 2022-09-28 Malaysia Pulau Pinang     297177 2029 0   5.4141 100.3288 2022-09-29 04:22:34 Pulau Pinang, Malaysia
3994698 3994698 2022-09-27 Malaysia Pulau Pinang     297099 2029 0   5.4141 100.3288 2022-09-28 04:23:01 Pulau Pinang, Malaysia
2769026 2769026 2022-09-26 Malaysia Pulau Pinang     297023 2029 0   5.4141 100.3288 2022-09-27 04:23:01 Pulau Pinang, Malaysia
1976679 1976679 2022-09-25 Malaysia Pulau Pinang     296967 2029 0   5.4141 100.3288 2022-09-26 04:20:52 Pulau Pinang, Malaysia
2649846 2649846 2022-09-24 Malaysia Pulau Pinang     296890 2029 0   5.4141 100.3288 2022-09-25 04:23:31 Pulau Pinang, Malaysia
384286 384286 2022-09-23 Malaysia Pulau Pinang     296792 2029 0   5.4141 100.3288 2022-09-24 04:21:40 Pulau Pinang, Malaysia
1624352 1624352 2022-09-22 Malaysia Pulau Pinang     296684 2029 0   5.4141 100.3288 2022-09-23 04:23:13 Pulau Pinang, Malaysia
1370556 1370556 2022-09-21 Malaysia Pulau Pinang     296581 2029 0   5.4141 100.3288 2022-09-22 04:22:56 Pulau Pinang, 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] TEXT,
   [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]);