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

850 rows where country_or_region = "Korea, North" sorted by day descending

✎ View and edit SQL

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

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

country_or_region 1

  • Korea, North · 850 ✖

province_or_state 0

Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
1733506 1733506 2022-05-20 Korea, North       1 6 0   40.3399 127.5101 2022-05-21 04:20:58 Korea, North
2572924 2572924 2022-05-19 Korea, North       1 6 0   40.3399 127.5101 2022-05-20 04:20:57 Korea, North
1432310 1432310 2022-05-18 Korea, North       1 6 0   40.3399 127.5101 2022-05-19 04:20:54 Korea, North
1599586 1599586 2022-05-17 Korea, North       1 62 0   40.3399 127.5101 2022-05-18 04:20:50 Korea, North
2425704 2425704 2022-05-16 Korea, North       1 56 0   40.3399 127.5101 2022-05-17 04:20:59 Korea, North
1317028 1317028 2022-05-15 Korea, North       1 21 0   40.3399 127.5101 2022-05-16 04:20:47 Korea, North
2635855 2635855 2022-05-14 Korea, North       1 21 0 0 40.3399 127.5101 2022-05-15 04:20:53 Korea, North
2675037 2675037 2022-05-13 Korea, North       0 0 0 0 40.3399 127.5101 2022-05-14 04:20:48 Korea, North
1899906 1899906 2022-05-12 Korea, North       0 0 0 0 40.3399 127.5101 2022-05-13 04:20:51 Korea, North
1372855 1372855 2022-05-11 Korea, North       0 0 0 0 40.3399 127.5101 2022-05-12 04:20:54 Korea, North
1982627 1982627 2022-05-10 Korea, North       0 0 0 0 40.3399 127.5101 2022-05-11 04:20:48 Korea, North
1057087 1057087 2022-05-09 Korea, North       0 0 0 0 40.3399 127.5101 2022-05-10 04:20:50 Korea, North
2460885 2460885 2022-05-08 Korea, North       0 0 0 0 40.3399 127.5101 2022-05-09 04:20:54 Korea, North
1130948 1130948 2022-05-07 Korea, North       0 0 0 0 40.3399 127.5101 2022-05-08 04:20:49 Korea, North
1919959 1919959 2022-05-06 Korea, North       0 0 0 0 40.3399 127.5101 2022-05-07 04:21:09 Korea, North
3011624 3011624 2022-05-05 Korea, North       0 0 0 0 40.3399 127.5101 2022-05-06 04:21:00 Korea, North
2069807 2069807 2022-05-04 Korea, North       0 0 0 0 40.3399 127.5101 2022-05-05 04:20:55 Korea, North
1713091 1713091 2022-05-03 Korea, North       0 0 0 0 40.3399 127.5101 2022-05-04 04:20:59 Korea, North
1388890 1388890 2022-05-02 Korea, North       0 0 0 0 40.3399 127.5101 2022-05-03 04:21:00 Korea, North
516920 516920 2022-05-01 Korea, North       0 0 0 0 40.3399 127.5101 2022-05-02 04:21:10 Korea, North
615350 615350 2022-04-30 Korea, North       0 0 0 0 40.3399 127.5101 2022-05-01 04:20:57 Korea, North
322490 322490 2022-04-29 Korea, North       0 0 0 0 40.3399 127.5101 2022-04-30 04:21:05 Korea, North
2975558 2975558 2022-04-28 Korea, North       0 0 0 0 40.3399 127.5101 2022-04-29 04:20:59 Korea, North
1024964 1024964 2022-04-27 Korea, North       0 0 0 0 40.3399 127.5101 2022-04-28 04:20:47 Korea, North
1008879 1008879 2022-04-26 Korea, North       0 0 0 0 40.3399 127.5101 2022-04-27 04:20:52 Korea, North
1049067 1049067 2022-04-25 Korea, North       0 0 0 0 40.3399 127.5101 2022-04-26 04:20:51 Korea, North
1833669 1833669 2022-04-24 Korea, North       0 0 0 0 40.3399 127.5101 2022-04-25 04:20:56 Korea, North
2612341 2612341 2022-04-23 Korea, North       0 0 0 0 40.3399 127.5101 2022-04-24 04:20:56 Korea, North
792175 792175 2022-04-22 Korea, North       0 0 0 0 40.3399 127.5101 2022-04-23 04:20:50 Korea, North
3089955 3089955 2022-04-21 Korea, North       0 0 0 0 40.3399 127.5101 2022-04-22 04:20:45 Korea, North
1634503 1634503 2022-04-20 Korea, North       0 0 0 0 40.3399 127.5101 2022-04-21 04:20:46 Korea, North
202255 202255 2022-04-19 Korea, North       0 0 0 0 40.3399 127.5101 2022-04-20 04:20:45 Korea, North
2730336 2730336 2022-04-18 Korea, North       0 0 0 0 40.3399 127.5101 2022-04-19 04:21:00 Korea, North
743916 743916 2022-04-17 Korea, North       0 0 0 0 40.3399 127.5101 2022-04-18 04:21:12 Korea, North
2298121 2298121 2022-04-16 Korea, North       0 0 0 0 40.3399 127.5101 2022-04-17 04:20:59 Korea, North
2496893 2496893 2022-04-15 Korea, North       0 0 0 0 40.3399 127.5101 2022-04-16 04:20:48 Korea, North
1221092 1221092 2022-04-14 Korea, North       0 0 0 0 40.3399 127.5101 2022-04-15 04:20:57 Korea, North
1138969 1138969 2022-04-13 Korea, North       0 0 0 0 40.3399 127.5101 2022-04-13 23:21:06 Korea, North
1491019 1491019 2022-04-12 Korea, North       0 0 0 0 40.3399 127.5101 2022-04-13 04:21:03 Korea, North
194235 194235 2022-04-11 Korea, North       0 0 0 0 40.3399 127.5101 2022-04-12 04:20:49 Korea, North
2991602 2991602 2022-04-10 Korea, North       0 0 0 0 40.3399 127.5101 2022-04-11 04:21:02 Korea, North
1478988 1478988 2022-04-09 Korea, North       0 0 0 0 40.3399 127.5101 2022-04-10 04:20:52 Korea, North
1206739 1206739 2022-04-08 Korea, North       0 0 0 0 40.3399 127.5101 2022-04-09 04:20:42 Korea, North
2125470 2125470 2022-04-07 Korea, North       0 0 0 0 40.3399 127.5101 2022-04-08 04:20:48 Korea, North
634635 634635 2022-04-06 Korea, North       0 0 0 0 40.3399 127.5101 2022-04-07 04:20:53 Korea, North
2987591 2987591 2022-04-05 Korea, North       0 0 0 0 40.3399 127.5101 2022-04-06 04:20:49 Korea, North
306448 306448 2022-04-04 Korea, North       0 0 0 0 40.3399 127.5101 2022-04-05 04:20:48 Korea, North
314470 314470 2022-04-03 Korea, North       0 0 0 0 40.3399 127.5101 2022-04-04 04:20:51 Korea, North
816172 816172 2022-04-02 Korea, North       0 0 0 0 40.3399 127.5101 2022-04-03 04:20:48 Korea, North
2698874 2698874 2022-04-01 Korea, North       0 0 0 0 40.3399 127.5101 2022-04-02 04:20:47 Korea, North
2627835 2627835 2022-03-31 Korea, North       0 0 0 0 40.3399 127.5101 2022-04-01 04:20:28 Korea, North
2413801 2413801 2022-03-30 Korea, North       0 0 0 0 40.3399 127.5101 2022-03-31 04:20:56 Korea, North
2113655 2113655 2022-03-29 Korea, North       0 0 0 0 40.3399 127.5101 2022-03-30 04:20:45 Korea, North
1397111 1397111 2022-03-28 Korea, North       0 0 0 0 40.3399 127.5101 2022-03-29 04:20:46 Korea, North
548228 548228 2022-03-27 Korea, North       0 0 0 0 40.3399 127.5101 2022-03-28 04:20:33 Korea, North
1028975 1028975 2022-03-26 Korea, North       0 0 0 0 40.3399 127.5101 2022-03-27 04:20:47 Korea, North
35936 35936 2022-03-25 Korea, North       0 0 0 0 40.3399 127.5101 2022-03-26 04:20:23 Korea, North
4011 4011 2022-03-24 Korea, North       0 0 0 0 40.3399 127.5101 2022-03-25 04:20:46 Korea, North
1482999 1482999 2022-03-23 Korea, North       0 0 0 0 40.3399 127.5101 2022-03-24 04:20:43 Korea, North
994169 994169 2022-03-22 Korea, North       0 0 0 0 40.3399 127.5101 2022-03-23 04:20:48 Korea, North
1947968 1947968 2022-03-21 Korea, North       0 0 0 0 40.3399 127.5101 2022-03-22 04:20:54 Korea, North
2350601 2350601 2022-03-20 Korea, North       0 0 0 0 40.3399 127.5101 2022-03-21 04:20:50 Korea, North
130466 130466 2022-03-19 Korea, North       0 0 0 0 40.3399 127.5101 2022-03-20 04:20:45 Korea, North
906088 906088 2022-03-18 Korea, North       0 0 0 0 40.3399 127.5101 2022-03-19 04:20:47 Korea, North
1085126 1085126 2022-03-17 Korea, North       0 0 0 0 40.3399 127.5101 2022-03-18 04:20:55 Korea, North
2326118 2326118 2022-03-16 Korea, North       0 0 0 0 40.3399 127.5101 2022-03-17 04:20:56 Korea, North
2358604 2358604 2022-03-15 Korea, North       0 0 0 0 40.3399 127.5101 2022-03-16 04:20:50 Korea, North
536195 536195 2022-03-14 Korea, North       0 0 0 0 40.3399 127.5101 2022-03-15 04:20:47 Korea, North
170377 170377 2022-03-13 Korea, North       0 0 0 0 40.3399 127.5101 2022-03-14 04:20:46 Korea, North
298426 298426 2022-03-12 Korea, North       0 0 0 0 40.3399 127.5101 2022-03-13 04:20:49 Korea, North
560259 560259 2022-03-11 Korea, North       0 0 0 0 40.3399 127.5101 2022-03-12 04:20:50 Korea, North
2136815 2136815 2022-03-10 Korea, North       0 0 0 0 40.3399 127.5101 2022-03-11 04:20:50 Korea, North
302437 302437 2022-03-09 Korea, North       0 0 0 0 40.3399 127.5101 2022-03-10 04:20:48 Korea, North
2485035 2485035 2022-03-08 Korea, North       0 0 0 0 40.3399 127.5101 2022-03-09 04:20:59 Korea, North
1268918 1268918 2022-03-07 Korea, North       0 0 0 0 40.3399 127.5101 2022-03-08 04:20:54 Korea, North
435336 435336 2022-03-06 Korea, North       0 0 0 0 40.3399 127.5101 2022-03-07 04:20:47 Korea, North
1568139 1568139 2022-03-05 Korea, North       0 0 0 0 40.3399 127.5101 2022-03-06 04:20:49 Korea, North
1907928 1907928 2022-03-04 Korea, North       0 0 0 0 40.3399 127.5101 2022-03-05 04:21:10 Korea, North
1466959 1466959 2022-03-03 Korea, North       0 0 0 0 40.3399 127.5101 2022-03-04 04:21:09 Korea, North
1784245 1784245 2022-03-02 Korea, North       0 0 0 0 40.3399 127.5101 2022-03-03 04:21:01 Korea, North
1622273 1622273 2022-03-01 Korea, North       0 0 0 0 40.3399 127.5101 2022-03-02 04:21:07 Korea, North
103192 103192 2022-02-28 Korea, North       0 0 0 0 40.3399 127.5101 2022-03-01 04:21:09 Korea, North
728448 728448 2022-02-27 Korea, North       0 0 0 0 40.3399 127.5101 2022-02-28 04:21:05 Korea, North
751712 751712 2022-02-26 Korea, North       0 0 0 0 40.3399 127.5101 2022-02-27 04:21:04 Korea, North
1963548 1963548 2022-02-25 Korea, North       0 0 0 0 40.3399 127.5101 2022-02-26 04:21:12 Korea, North
2979569 2979569 2022-02-24 Korea, North       0 0 0 0 40.3399 127.5101 2022-02-25 04:21:11 Korea, North
2117666 2117666 2022-02-23 Korea, North       0 0 0 0 40.3399 127.5101 2022-02-24 04:21:14 Korea, North
419567 419567 2022-02-22 Korea, North       0 0 0 0 40.3399 127.5101 2022-02-23 04:21:09 Korea, North
2683057 2683057 2022-02-21 Korea, North       0 0 0 0 40.3399 127.5101 2022-02-22 04:21:01 Korea, North
508922 508922 2022-02-20 Korea, North       0 0 0 0 40.3399 127.5101 2022-02-21 04:21:05 Korea, North
1182374 1182374 2022-02-19 Korea, North       0 0 0 0 40.3399 127.5101 2022-02-20 04:21:00 Korea, North
1431942 1431942 2022-02-18 Korea, North       0 0 0 0 40.3399 127.5101 2022-02-19 04:21:11 Korea, North
2500904 2500904 2022-02-17 Korea, North       0 0 0 0 40.3399 127.5101 2022-02-18 04:21:04 Korea, North
2322107 2322107 2022-02-16 Korea, North       0 0 0 0 40.3399 127.5101 2022-02-17 04:20:56 Korea, North
2844752 2844752 2022-02-15 Korea, North       0 0 0 0 40.3399 127.5101 2022-02-16 04:21:10 Korea, North
958223 958223 2022-02-14 Korea, North       0 0 0 0 40.3399 127.5101 2022-02-15 04:21:09 Korea, North
2659886 2659886 2022-02-13 Korea, North       0 0 0 0 40.3399 127.5101 2022-02-14 04:20:51 Korea, North
1217081 1217081 2022-02-12 Korea, North       0 0 0 0 40.3399 127.5101 2022-02-13 04:21:00 Korea, North
1943957 1943957 2022-02-11 Korea, North       0 0 0 0 40.3399 127.5101 2022-02-12 04:21:06 Korea, North
1514820 1514820 2022-02-10 Korea, North       0 0 0 0 40.3399 127.5101 2022-02-11 04:21:09 Korea, North

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