home / covid

Menu
  • GraphQL API

johns_hopkins_csse_daily_reports

Table actions
  • GraphQL API for 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

1,073 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 · 1,073 ✖

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
2752941 2752941 2022-12-29 Korea, North       1 6 0   40.3399 127.5101 2022-12-30 04:21:04 Korea, North
1073947 1073947 2022-12-28 Korea, North       1 6 0   40.3399 127.5101 2022-12-29 04:21:01 Korea, North
327944 327944 2022-12-27 Korea, North       1 6 0   40.3399 127.5101 2022-12-28 04:21:04 Korea, North
218017 218017 2022-12-26 Korea, North       1 6 0   40.3399 127.5101 2022-12-27 04:21:07 Korea, North
3222474 3222474 2022-12-25 Korea, North       1 6 0   40.3399 127.5101 2022-12-26 04:21:06 Korea, North
1018388 1018388 2022-12-24 Korea, North       1 6 0   40.3399 127.5101 2022-12-25 04:21:04 Korea, North
690411 690411 2022-12-23 Korea, North       1 6 0   40.3399 127.5101 2022-12-24 04:21:02 Korea, North
2179621 2179621 2022-12-22 Korea, North       1 6 0   40.3399 127.5101 2022-12-23 04:21:04 Korea, North
451425 451425 2022-12-21 Korea, North       1 6 0   40.3399 127.5101 2022-12-22 04:20:56 Korea, North
2951424 2951424 2022-12-20 Korea, North       1 6 0   40.3399 127.5101 2022-12-21 04:21:03 Korea, North
3173826 3173826 2022-12-19 Korea, North       1 6 0   40.3399 127.5101 2022-12-20 04:21:04 Korea, North
1628343 1628343 2022-12-18 Korea, North       1 6 0   40.3399 127.5101 2022-12-19 04:21:03 Korea, North
503722 503722 2022-12-17 Korea, North       1 6 0   40.3399 127.5101 2022-12-18 04:21:03 Korea, North
3324294 3324294 2022-12-16 Korea, North       1 6 0   40.3399 127.5101 2022-12-17 04:21:04 Korea, North
542806 542806 2022-12-15 Korea, North       1 6 0   40.3399 127.5101 2022-12-16 04:21:01 Korea, North
348334 348334 2022-12-14 Korea, North       1 6 0   40.3399 127.5101 2022-12-15 04:20:58 Korea, North
307922 307922 2022-12-13 Korea, North       1 6 0   40.3399 127.5101 2022-12-14 04:21:04 Korea, North
1148983 1148983 2022-12-12 Korea, North       1 6 0   40.3399 127.5101 2022-12-13 04:21:01 Korea, North
868837 868837 2022-12-11 Korea, North       1 6 0   40.3399 127.5101 2022-12-12 04:21:01 Korea, North
257367 257367 2022-12-10 Korea, North       1 6 0   40.3399 127.5101 2022-12-11 04:20:50 Korea, North
3936081 3936081 2022-12-09 Korea, North       1 6 0   40.3399 127.5101 2022-12-10 04:21:02 Korea, North
3377413 3377413 2022-12-08 Korea, North       1 6 0   40.3399 127.5101 2022-12-09 04:21:05 Korea, North
1984684 1984684 2022-12-07 Korea, North       1 6 0   40.3399 127.5101 2022-12-08 04:21:07 Korea, North
3714207 3714207 2022-12-06 Korea, North       1 6 0   40.3399 127.5101 2022-12-07 04:20:58 Korea, North
2414912 2414912 2022-12-05 Korea, North       1 6 0   40.3399 127.5101 2022-12-06 04:21:03 Korea, North
718520 718520 2022-12-04 Korea, North       1 6 0   40.3399 127.5101 2022-12-05 04:20:58 Korea, North
2816809 2816809 2022-12-03 Korea, North       1 6 0   40.3399 127.5101 2022-12-04 04:20:56 Korea, North
833665 833665 2022-12-02 Korea, North       1 6 0   40.3399 127.5101 2022-12-03 04:21:02 Korea, North
2136195 2136195 2022-12-01 Korea, North       1 6 0   40.3399 127.5101 2022-12-02 04:21:07 Korea, North
1964611 1964611 2022-11-30 Korea, North       1 6 0   40.3399 127.5101 2022-12-01 04:21:03 Korea, North
2556625 2556625 2022-11-29 Korea, North       1 6 0   40.3399 127.5101 2022-11-30 04:21:07 Korea, North
1239699 1239699 2022-11-28 Korea, North       1 6 0   40.3399 127.5101 2022-11-29 04:21:05 Korea, North
3551687 3551687 2022-11-27 Korea, North       1 6 0   40.3399 127.5101 2022-11-28 04:21:02 Korea, North
2100167 2100167 2022-11-26 Korea, North       1 6 0   40.3399 127.5101 2022-11-27 04:21:05 Korea, North
487658 487658 2022-11-25 Korea, North       1 6 0   40.3399 127.5101 2022-11-26 04:21:11 Korea, North
3523487 3523487 2022-11-24 Korea, North       1 6 0   40.3399 127.5101 2022-11-25 04:21:06 Korea, North
3312270 3312270 2022-11-23 Korea, North       1 6 0   40.3399 127.5101 2022-11-24 04:21:09 Korea, North
1620311 1620311 2022-11-22 Korea, North       1 6 0   40.3399 127.5101 2022-11-23 04:21:06 Korea, North
3460199 3460199 2022-11-21 Korea, North       1 6 0   40.3399 127.5101 2022-11-22 04:20:47 Korea, North
1640384 1640384 2022-11-20 Korea, North       1 6 0   40.3399 127.5101 2022-11-21 04:21:05 Korea, North
2063941 2063941 2022-11-19 Korea, North       1 6 0   40.3399 127.5101 2022-11-20 04:21:08 Korea, North
1755335 1755335 2022-11-18 Korea, North       1 6 0   40.3399 127.5101 2022-11-19 04:21:14 Korea, North
3026328 3026328 2022-11-17 Korea, North       1 6 0   40.3399 127.5101 2022-11-18 04:21:15 Korea, North
2486039 2486039 2022-11-16 Korea, North       1 6 0   40.3399 127.5101 2022-11-17 04:21:11 Korea, North
292050 292050 2022-11-15 Korea, North       1 6 0   40.3399 127.5101 2022-11-16 04:21:09 Korea, North
3597080 3597080 2022-11-14 Korea, North       1 6 0   40.3399 127.5101 2022-11-15 04:21:16 Korea, North
311938 311938 2022-11-13 Korea, North       1 6 0   40.3399 127.5101 2022-11-14 04:21:09 Korea, North
63099 63099 2022-11-12 Korea, North       1 6 0   40.3399 127.5101 2022-11-13 04:21:14 Korea, North
2927261 2927261 2022-11-11 Korea, North       1 6 0   40.3399 127.5101 2022-11-12 04:20:41 Korea, North
2506097 2506097 2022-11-10 Korea, North       1 6 0   40.3399 127.5101 2022-11-11 04:21:22 Korea, North
2430972 2430972 2022-11-09 Korea, North       1 6 0   40.3399 127.5101 2022-11-10 04:21:16 Korea, North
479628 479628 2022-11-08 Korea, North       1 6 0   40.3399 127.5101 2022-11-09 04:21:22 Korea, North
2438778 2438778 2022-11-07 Korea, North       1 6 0   40.3399 127.5101 2022-11-08 04:21:21 Korea, North
1049876 1049876 2022-11-06 Korea, North       1 6 0   40.3399 127.5101 2022-11-07 04:21:26 Korea, North
617900 617900 2022-11-05 Korea, North       1 6 0   40.3399 127.5101 2022-11-06 04:21:24 Korea, North
1022404 1022404 2022-11-04 Korea, North       1 6 0   40.3399 127.5101 2022-11-05 04:21:52 Korea, North
431395 431395 2022-11-03 Korea, North       1 6 0   40.3399 127.5101 2022-11-04 04:22:11 Korea, North
849637 849637 2022-11-02 Korea, North       1 6 0   40.3399 127.5101 2022-11-03 04:22:05 Korea, North
710488 710488 2022-11-01 Korea, North       1 6 0   40.3399 127.5101 2022-11-02 04:22:09 Korea, North
3284937 3284937 2022-10-31 Korea, North       1 6 0   40.3399 127.5101 2022-11-01 04:22:36 Korea, North
319970 319970 2022-10-30 Korea, North       1 6 0   40.3399 127.5101 2022-10-31 04:21:36 Korea, North
912246 912246 2022-10-29 Korea, North       1 6 0   40.3399 127.5101 2022-10-30 04:22:14 Korea, North
1366515 1366515 2022-10-28 Korea, North       1 6 0   40.3399 127.5101 2022-10-29 04:21:13 Korea, North
3038370 3038370 2022-10-27 Korea, North       1 6 0   40.3399 127.5101 2022-10-28 04:22:31 Korea, North
538790 538790 2022-10-26 Korea, North       1 6 0   40.3399 127.5101 2022-10-27 04:22:01 Korea, North
1830191 1830191 2022-10-25 Korea, North       1 6 0   40.3399 127.5101 2022-10-26 04:22:19 Korea, North
794452 794452 2022-10-24 Korea, North       1 6 0   40.3399 127.5101 2022-10-25 04:21:53 Korea, North
3276907 3276907 2022-10-23 Korea, North       1 6 0   40.3399 127.5101 2022-10-24 04:22:29 Korea, North
2267945 2267945 2022-10-22 Korea, North       1 6 0   40.3399 127.5101 2022-10-23 04:22:46 Korea, North
1592245 1592245 2022-10-21 Korea, North       1 6 0   40.3399 127.5101 2022-10-22 04:22:53 Korea, North
2271961 2271961 2022-10-20 Korea, North       1 6 0   40.3399 127.5101 2022-10-21 04:22:23 Korea, North
198296 198296 2022-10-19 Korea, North       1 6 0   40.3399 127.5101 2022-10-20 04:22:59 Korea, North
2756957 2756957 2022-10-18 Korea, North       1 6 0   40.3399 127.5101 2022-10-19 04:22:26 Korea, North
2024791 2024791 2022-10-17 Korea, North       1 6 0   40.3399 127.5101 2022-10-18 04:22:42 Korea, North
2159569 2159569 2022-10-16 Korea, North       1 6 0   40.3399 127.5101 2022-10-17 04:20:31 Korea, North
515766 515766 2022-10-15 Korea, North       1 6 0   40.3399 127.5101 2022-10-16 04:22:39 Korea, North
2032823 2032823 2022-10-14 Korea, North       1 6 0   40.3399 127.5101 2022-10-15 04:22:00 Korea, North
3753511 3753511 2022-10-13 Korea, North       1 6 0   40.3399 127.5101 2022-10-14 04:22:28 Korea, North
3214336 3214336 2022-10-12 Korea, North       1 6 0   40.3399 127.5101 2022-10-13 04:22:39 Korea, North
3250185 3250185 2022-10-11 Korea, North       1 6 0   40.3399 127.5101 2022-10-12 04:22:51 Korea, North
2967444 2967444 2022-10-10 Korea, North       1 6 0   40.3399 127.5101 2022-10-11 04:23:05 Korea, North
3097480 3097480 2022-10-09 Korea, North       1 6 0   40.3399 127.5101 2022-10-10 04:22:32 Korea, North
4002705 4002705 2022-10-08 Korea, North       1 6 0   40.3399 127.5101 2022-10-09 04:21:16 Korea, North
396302 396302 2022-10-07 Korea, North       1 6 0   40.3399 127.5101 2022-10-08 04:22:56 Korea, North
2529419 2529419 2022-10-06 Korea, North       1 6 0   40.3399 127.5101 2022-10-07 04:23:08 Korea, North
1810813 1810813 2022-10-05 Korea, North       1 6 0   40.3399 127.5101 2022-10-06 04:21:22 Korea, North
130787 130787 2022-10-04 Korea, North       1 6 0   40.3399 127.5101 2022-10-05 04:23:06 Korea, North
2685734 2685734 2022-10-03 Korea, North       1 6 0   40.3399 127.5101 2022-10-04 04:22:55 Korea, North
2259801 2259801 2022-10-02 Korea, North       1 6 0   40.3399 127.5101 2022-10-03 04:23:11 Korea, North
2995327 2995327 2022-10-01 Korea, North       1 6 0   40.3399 127.5101 2022-10-02 04:21:23 Korea, North
853653 853653 2022-09-30 Korea, North       1 6 0   40.3399 127.5101 2022-10-01 04:23:01 Korea, North
2375579 2375579 2022-09-29 Korea, North       1 6 0   40.3399 127.5101 2022-09-30 04:23:09 Korea, North
1560130 1560130 2022-09-28 Korea, North       1 6 0   40.3399 127.5101 2022-09-29 04:22:34 Korea, North
3994673 3994673 2022-09-27 Korea, North       1 6 0   40.3399 127.5101 2022-09-28 04:23:01 Korea, North
2769001 2769001 2022-09-26 Korea, North       1 6 0   40.3399 127.5101 2022-09-27 04:23:01 Korea, North
1976654 1976654 2022-09-25 Korea, North       1 6 0   40.3399 127.5101 2022-09-26 04:20:52 Korea, North
2649821 2649821 2022-09-24 Korea, North       1 6 0   40.3399 127.5101 2022-09-25 04:23:31 Korea, North
384261 384261 2022-09-23 Korea, North       1 6 0   40.3399 127.5101 2022-09-24 04:21:40 Korea, North
1624327 1624327 2022-09-22 Korea, North       1 6 0   40.3399 127.5101 2022-09-23 04:23:13 Korea, North
1370531 1370531 2022-09-21 Korea, North       1 6 0   40.3399 127.5101 2022-09-22 04:22:56 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]);
Powered by Datasette · Queries took 226.686ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette