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

17 rows where country_or_region = "Malaysia" and day = "2022-09-21" sorted by day descending

✎ View and edit SQL

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

Suggested facets: last_update (date)

country_or_region 1

  • Malaysia · 17 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
1370548 1370548 2022-09-21 Malaysia Johor     393390 4624 0   1.4854 103.7618 2022-09-22 04:22:56 Johor, Malaysia
1370549 1370549 2022-09-21 Malaysia Kedah     309251 2674 0   6.1184 100.3685 2022-09-22 04:22:56 Kedah, Malaysia
1370550 1370550 2022-09-21 Malaysia Kelantan     253290 1422 0   6.1254 102.2381 2022-09-22 04:22:56 Kelantan, Malaysia
1370551 1370551 2022-09-21 Malaysia Melaka     134736 1184 0   2.1896 102.2501 2022-09-22 04:22:56 Melaka, Malaysia
1370552 1370552 2022-09-21 Malaysia Negeri Sembilan     221285 1509 0   2.7258 101.9424 2022-09-22 04:22:56 Negeri Sembilan, Malaysia
1370553 1370553 2022-09-21 Malaysia Pahang     177217 1005 0   3.8126 103.3256 2022-09-22 04:22:56 Pahang, Malaysia
1370554 1370554 2022-09-21 Malaysia Perak     226339 2031 0   4.5921 101.0901 2022-09-22 04:22:56 Perak, Malaysia
1370555 1370555 2022-09-21 Malaysia Perlis     18406 192 0   6.4449 100.2048 2022-09-22 04:22:56 Perlis, 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
1370557 1370557 2022-09-21 Malaysia Sabah     393493 3157 0   5.9788 116.0753 2022-09-22 04:22:56 Sabah, Malaysia
1370558 1370558 2022-09-21 Malaysia Sarawak     314848 1763 0   1.5533 110.3592 2022-09-22 04:22:56 Sarawak, Malaysia
1370559 1370559 2022-09-21 Malaysia Selangor     1472034 10840 0   3.0738 101.5183 2022-09-22 04:22:56 Selangor, Malaysia
1370560 1370560 2022-09-21 Malaysia Terengganu     129436 881 0   5.3117 103.1324 2022-09-22 04:22:56 Terengganu, Malaysia
1370561 1370561 2022-09-21 Malaysia Unknown     0 0 0       2022-09-22 04:22:56 Unknown, Malaysia
1370562 1370562 2022-09-21 Malaysia W.P. Kuala Lumpur     434218 2832 0   3.139 101.6869 2022-09-22 04:22:56 W.P. Kuala Lumpur, Malaysia
1370563 1370563 2022-09-21 Malaysia W.P. Labuan     22237 157 0   5.2831 115.2308 2022-09-22 04:22:56 W.P. Labuan, Malaysia
1370564 1370564 2022-09-21 Malaysia W.P. Putrajaya     27214 30 0   2.9264 101.6964 2022-09-22 04:22:56 W.P. Putrajaya, Malaysia

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]);