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

38 rows where recovered = 534 sorted by day descending

✎ View and edit SQL

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

These facets timed out: province_or_state

Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
181861 181861 2021-02-21 China Shaanxi     547 3 534 10 35.1917 108.8701 2021-02-22 05:24:21 Shaanxi, China
742135 742135 2021-02-20 China Shaanxi     547 3 534 10 35.1917 108.8701 2021-02-21 05:24:33 Shaanxi, China
471233 471233 2021-02-19 China Shaanxi     547 3 534 10 35.1917 108.8701 2021-02-20 05:22:51 Shaanxi, China
1152943 1152943 2021-02-18 China Shaanxi     547 3 534 10 35.1917 108.8701 2021-02-19 05:24:16 Shaanxi, China
3539261 3539261 2021-02-12 China Fujian     548 1 534 13 26.0789 117.9874 2021-02-13 05:22:12 Fujian, China
774391 774391 2021-01-12 Japan Toyama     743 26 534 183 36.637464 137.26934599999998 2021-01-13 05:22:15 Toyama, Japan
3691249 3691249 2020-12-24 Canada New Brunswick     587 8 534 45 46.5653 -66.4619 2020-12-25 05:22:48 New Brunswick, Canada
2931228 2931228 2020-12-19 Japan Fukushima     697 10 534 153 37.378867 140.223295 2020-12-20 05:27:32 Fukushima, Japan
2935257 2935257 2020-11-28 Japan Nagano     691 6 534 151 36.132134 138.045528 2020-11-29 05:25:55 Nagano, Japan
3651591 3651591 2020-10-24 Japan Mie     555 7 534 14 34.508018 136.376013 2020-10-25 04:24:36 Mie, Japan
1053939 1053939 2020-10-23 Netherlands Curacao     818 1 534 283 12.1696 -68.99 2020-10-24 04:24:46 Curacao, Netherlands
79067 79067 2020-10-14 Italy Basilicata     1075 37 534 504 40.63947052 15.80514834 2020-10-15 04:24:28 Basilicata, Italy
546766 546766 2020-09-12 Japan Ibaraki     609 15 534 60 36.303588 140.319591 2020-09-13 04:30:52 Ibaraki, Japan
1996840 1996840 2020-08-26 Russia Jewish Autonomous Okrug     602 9 534 59 48.57527615 132.66307460000002 2020-08-27 04:28:15 Jewish Autonomous Okrug, Russia
1996574 1996574 2020-08-26 Guyana       1093 31 534 528 4.860416000000002 -58.93018000000001 2020-08-27 04:28:15 Guyana
3562764 3562764 2020-08-25 Russia Jewish Autonomous Okrug     598 9 534 55 48.57527615 132.66307460000002 2020-08-26 04:28:11 Jewish Autonomous Okrug, Russia
2991468 2991468 2020-08-24 Russia Jewish Autonomous Okrug     594 9 534 51 48.57527615 132.66307460000002 2020-08-25 04:28:02 Jewish Autonomous Okrug, Russia
2215863 2215863 2020-08-23 Russia Jewish Autonomous Okrug     592 9 534 49 48.57527615 132.66307460000002 2020-08-24 04:27:56 Jewish Autonomous Okrug, Russia
2299645 2299645 2020-08-22 Russia Jewish Autonomous Okrug     590 9 534 47 48.57527615 132.66307460000002 2020-08-23 04:27:48 Jewish Autonomous Okrug, Russia
662264 662264 2020-08-11 India Sikkim     913 1 534 378 27.571671 88.472712 2020-08-12 04:27:29 Sikkim, India
1707648 1707648 2020-07-21 Colombia Risaralda     1077 21 534 522 5.3158 -75.9928 2020-07-22 04:34:42 Risaralda, Colombia
122274 122274 2020-07-19 Liberia       1088 70 534 484 6.4280550000000005 -9.429499 2020-07-20 05:34:40 Liberia
2748506 2748506 2020-07-15 Togo       740 15 534 191 8.6195 0.8248 2020-07-16 04:44:59 Togo
3491571 3491571 2020-07-13 Colombia Tolima     1470 31 534 905 4.0925 -75.1545 2020-07-14 04:34:46 Tolima, Colombia
887345 887345 2020-07-07 Russia Magadan Oblast     947 4 534 409 62.48858785 153.9903764 2020-07-08 05:33:48 Magadan Oblast, Russia
1691971 1691971 2020-06-19 Malaysia Sarawak     566 17 534 15 1.5533 110.3592 2020-06-20 04:33:19 Sarawak, Malaysia
3683120 3683120 2020-06-18 Malaysia Sarawak     565 17 534 14 1.5533 110.3592 2020-06-19 04:33:17 Sarawak, Malaysia
1195977 1195977 2020-06-17 Russia Pskov Oblast     1996 19 534 1443 57.5358729 28.8586826 2020-06-18 04:33:18 Pskov Oblast, Russia
1837032 1837032 2020-06-14 France French Guiana     1255 3 534 718 4.0 -53.0 2020-06-15 03:33:14 French Guiana, France
1794218 1794218 2020-05-31 Malta       618 9 534 75 35.9375 14.3754 2020-06-01 02:32:46 Malta
2548324 2548324 2020-05-27 Mexico Tlaxcala     944 135 534 275 19.3139 -98.2404 2020-05-28 02:32:31 Tlaxcala, Mexico
114196 114196 2020-05-08 Australia Western Australia     552 9 534 9 -31.9505 115.8605 2020-05-09 02:32:35 Western Australia, Australia
3295639 3295639 2020-05-07 Australia Western Australia     552 9 534 9 -31.9505 115.8605 2020-05-08 02:32:32 Western Australia, Australia
2110986 2110986 2020-05-06 Nigeria       3145 103 534 2508 9.082 8.6753 2020-05-07 02:32:28 Nigeria
3084888 3084888 2020-05-04 Niger       755 37 534 184 17.607789 8.081666 2020-05-05 02:32:34 Niger
1199244 1199244 2020-04-22 China Shanghai     639 7 534 98 31.201999999999998 121.4491 2020-04-22 07:14:57 Shanghai, China
50405 50405 2020-04-17 Serbia       5690 110 534 5046 44.0165 21.0059 2020-04-17 23:30:32 Serbia
3021924 3021924 2020-04-07 Malaysia Selangor     1011 8 534 469 3.0738 101.5183 2020-04-07 23:04:49 Selangor, 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]);