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

45 rows where recovered = 402 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
54622 54622 2021-03-07 China Liaoning     406 2 402 2 41.2956 122.6085 2021-03-08 05:24:48 Liaoning, China
3667439 3667439 2021-03-06 China Liaoning     406 2 402 2 41.2956 122.6085 2021-03-07 05:21:54 Liaoning, China
1616060 1616060 2021-03-05 China Liaoning     406 2 402 2 41.2956 122.6085 2021-03-06 04:23:41 Liaoning, China
2207471 2207471 2021-03-04 China Liaoning     406 2 402 2 41.2956 122.6085 2021-03-05 05:26:29 Liaoning, China
1089892 1089892 2021-03-03 China Liaoning     406 2 402 2 41.2956 122.6085 2021-03-04 05:24:24 Liaoning, China
3253964 3253964 2021-03-02 China Liaoning     406 2 402 2 41.2956 122.6085 2021-03-03 05:23:28 Liaoning, China
998256 998256 2021-03-01 China Liaoning     406 2 402 2 41.2956 122.6085 2021-03-02 05:23:30 Liaoning, China
2367314 2367314 2021-02-28 China Liaoning     406 2 402 2 41.2956 122.6085 2021-03-01 05:23:01 Liaoning, China
3066039 3066039 2021-02-27 Japan Tokushima     450 16 402 32 33.919178 134.242091 2021-02-28 05:22:20 Tokushima, Japan
3065816 3065816 2021-02-27 China Liaoning     406 2 402 2 41.2956 122.6085 2021-02-28 05:22:20 Liaoning, China
2183400 2183400 2021-02-26 China Liaoning     406 2 402 2 41.2956 122.6085 2021-02-27 05:22:28 Liaoning, China
1857822 1857822 2021-02-25 China Liaoning     406 2 402 2 41.2956 122.6085 2021-02-26 05:22:40 Liaoning, China
280000 280000 2021-02-24 China Liaoning     406 2 402 2 41.2956 122.6085 2021-02-25 05:24:57 Liaoning, China
1936268 1936268 2021-02-23 China Liaoning     406 2 402 2 41.2956 122.6085 2021-02-24 05:29:16 Liaoning, China
927740 927740 2020-12-21 Japan Yamaguchi     468 2 402 64 34.201190000000004 131.573293 2020-12-22 05:22:33 Yamaguchi, Japan
1006339 1006339 2020-12-06 Japan Wakayama     503 7 402 94 33.911879 135.505446 2020-12-07 05:26:14 Wakayama, Japan
74859 74859 2020-12-03 Canada New Brunswick     520 7 402 111 46.5653 -66.4619 2020-12-04 05:27:27 New Brunswick, Canada
923725 923725 2020-11-26 Japan Toyama     453 26 402 25 36.637464 137.26934599999998 2020-11-27 05:26:53 Toyama, Japan
821577 821577 2020-11-19 Japan Fukushima     458 6 402 50 37.378867 140.223295 2020-11-20 05:26:28 Fukushima, Japan
1026175 1026175 2020-10-17 China Shaanxi     436 3 402 31 35.1917 108.8701 2020-10-18 04:24:25 Shaanxi, China
2856670 2856670 2020-10-16 China Shaanxi     434 3 402 29 35.1917 108.8701 2020-10-17 04:24:12 Shaanxi, China
786200 786200 2020-10-15 China Shaanxi     433 3 402 28 35.1917 108.8701 2020-10-16 04:24:01 Shaanxi, China
78911 78911 2020-10-14 China Shaanxi     433 3 402 28 35.1917 108.8701 2020-10-15 04:24:28 Shaanxi, China
2665449 2665449 2020-09-04 Malaysia Sabah     433 8 402 23 5.9788 116.0753 2020-09-05 04:28:19 Sabah, Malaysia
609708 609708 2020-08-29 Japan Kumamoto     509 7 402 100 32.608154 130.74523100000002 2020-08-30 04:28:22 Kumamoto, Japan
2299462 2299462 2020-08-22 Japan Ibaraki     498 11 402 85 36.303588 140.319591 2020-08-23 04:27:48 Ibaraki, Japan
2299459 2299459 2020-08-22 Japan Hiroshima     450 3 402 45 34.605309000000005 132.788719 2020-08-23 04:27:48 Hiroshima, Japan
1479566 1479566 2020-08-21 Japan Hiroshima     448 3 402 43 34.605309000000005 132.788719 2020-08-22 04:27:49 Hiroshima, Japan
3484315 3484315 2020-08-20 Japan Hiroshima     444 3 402 39 34.605309000000005 132.788719 2020-08-21 04:27:41 Hiroshima, Japan
3484264 3484264 2020-08-20 India Mizoram     895 0 402 493 23.309381 92.83822 2020-08-21 04:27:41 Mizoram, India
841227 841227 2020-08-17 Ukraine Poltava Oblast     557 15 402 140 49.5883 34.5514 2020-08-18 04:27:56 Poltava Oblast, Ukraine
2158675 2158675 2020-07-14 Russia Jewish Autonomous Okrug     487 6 402 79 48.57527615 132.66307460000002 2020-07-15 04:34:39 Jewish Autonomous Okrug, Russia
2222570 2222570 2020-07-08 India Chandigarh     513 7 402 104 30.733839 76.76827800000002 2020-07-09 04:34:23 Chandigarh, India
2974868 2974868 2020-06-30 Togo       650 14 402 234 8.6195 0.8248 2020-07-01 04:33:52 Togo
1136535 1136535 2020-06-26 Yemen       1089 293 402 394 15.552726999999999 48.516388 2020-06-27 04:33:35 Yemen
3249311 3249311 2020-06-21 Russia Karelia Republic     991 2 402 587 62.61940309999999 33.4920267 2020-06-22 04:33:20 Karelia Republic, Russia
1196168 1196168 2020-06-17 Central African Republic       2564 18 402 2144 6.6111 20.9394 2020-06-18 04:33:18 Central African Republic
1273450 1273450 2020-06-11 Russia Kamchatka Krai     1306 10 402 894 57.1914882 160.03838190000005 2020-06-12 05:09:52 Kamchatka Krai, Russia
2712552 2712552 2020-05-28 Paraguay       900 11 402 487 -23.4425 -58.4438 2020-05-29 02:32:50 Paraguay
1041246 1041246 2020-05-26 Mexico Queretaro     742 84 402 256 20.5888 -100.3899 2020-05-27 02:32:31 Queretaro, Mexico
1105122 1105122 2020-05-25 Kenya       1286 52 402 832 -0.0236 37.9062 2020-05-26 02:32:35 Kenya
1864991 1864991 2020-05-22 Gabon       1728 12 402 1314 -0.8037 11.6094 2020-05-23 02:32:42 Gabon
268216 268216 2020-05-21 Mexico Aguascalientes     586 21 402 163 21.8853 -102.2916 2020-05-22 02:36:51 Aguascalientes, Mexico
3847455 3847455 2020-05-13 Malaysia Sarawak     544 17 402 125 1.5533 110.3592 2020-05-14 03:32:28 Sarawak, Malaysia
50268 50268 2020-04-17 Armenia       1201 19 402 780 40.0691 45.0382 2020-04-17 23:30:32 Armenia

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