johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
26 rows where recovered = 567 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 14
- Japan 6
- Canada 4
- China 3
- Cruise Ship 2
- Russia 2
- Angola 1
- Australia 1
- Colombia 1
- Congo (Kinshasa) 1
- Malaysia 1
- Netherlands 1
- Rwanda 1
- Ukraine 1
- United Kingdom 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1306192 | 1306192 | 2021-07-27 | Japan | Shimane | 683 | 2 | 567 | 114 | 35.07076 | 132.55406399999998 | 2021-07-28 04:21:39 | Shimane, Japan | ||
3218335 | 3218335 | 2021-07-26 | Japan | Shimane | 675 | 2 | 567 | 106 | 35.07076 | 132.55406399999998 | 2021-07-27 04:21:18 | Shimane, Japan | ||
2255505 | 2255505 | 2021-05-19 | Canada | Nunavut | 634 | 4 | 567 | 63 | 70.2998 | -83.1076 | 2021-05-20 04:21:05 | Nunavut, Canada | ||
2020544 | 2020544 | 2021-04-20 | China | Shaanxi | 587 | 3 | 567 | 17 | 35.1917 | 108.8701 | 2021-04-21 04:21:14 | Shaanxi, China | ||
3253963 | 3253963 | 2021-03-02 | China | Jilin | 573 | 3 | 567 | 3 | 43.6661 | 126.1923 | 2021-03-03 05:23:28 | Jilin, China | ||
3034003 | 3034003 | 2021-01-05 | Australia | South Australia | 582 | 4 | 567 | 11 | -34.9285 | 138.6007 | 2021-01-06 05:22:16 | South Australia, Australia | ||
3230220 | 3230220 | 2021-01-03 | Canada | New Brunswick | 618 | 9 | 567 | 42 | 46.5653 | -66.4619 | 2021-01-04 05:22:02 | New Brunswick, Canada | ||
2227290 | 2227290 | 2021-01-02 | Canada | New Brunswick | 611 | 9 | 567 | 35 | 46.5653 | -66.4619 | 2021-01-03 05:22:52 | New Brunswick, Canada | ||
1136654 | 1136654 | 2021-01-01 | Canada | New Brunswick | 601 | 9 | 567 | 25 | 46.5653 | -66.4619 | 2021-01-02 05:22:33 | New Brunswick, Canada | ||
2935249 | 2935249 | 2020-11-28 | Japan | Kagoshima | 623 | 13 | 567 | 43 | 31.009484000000004 | 130.430665 | 2020-11-29 05:25:55 | Kagoshima, Japan | ||
392252 | 392252 | 2020-11-27 | Japan | Kagoshima | 621 | 13 | 567 | 41 | 31.009484000000004 | 130.430665 | 2020-11-28 05:25:50 | Kagoshima, Japan | ||
892143 | 892143 | 2020-11-05 | Japan | Miyagi | 821 | 3 | 567 | 251 | 38.446859 | 140.927086 | 2020-11-06 05:24:55 | Miyagi, Japan | ||
1177532 | 1177532 | 2020-10-22 | Japan | Shizuoka | 585 | 2 | 567 | 16 | 34.916975 | 138.40778400000002 | 2020-10-23 04:24:46 | Shizuoka, Japan | ||
2379755 | 2379755 | 2020-10-01 | Netherlands | Sint Maarten | 668 | 22 | 567 | 79 | 18.0425 | -63.0548 | 2020-10-02 04:23:51 | Sint Maarten, Netherlands | ||
2852486 | 2852486 | 2020-09-18 | United Kingdom | Turks and Caicos Islands | 667 | 5 | 567 | 95 | 21.694 | -71.7979 | 2020-09-19 04:22:00 | Turks and Caicos Islands, United Kingdom | ||
1523019 | 1523019 | 2020-08-28 | Colombia | Arauca | 898 | 14 | 567 | 317 | 7.0762 | -70.7105 | 2020-08-29 04:28:19 | Arauca, Colombia | ||
3923495 | 3923495 | 2020-08-09 | Angola | 1672 | 75 | 567 | 1030 | -11.2027 | 17.8739 | 2020-08-10 04:34:55 | Angola | |||
1928859 | 1928859 | 2020-07-30 | Malaysia | Sarawak | 677 | 19 | 567 | 91 | 1.5533 | 110.3592 | 2020-07-31 04:35:18 | Sarawak, Malaysia | ||
2564025 | 2564025 | 2020-07-24 | Ukraine | Zaporizhia Oblast | 712 | 21 | 567 | 124 | 47.8388 | 35.1396 | 2020-07-25 04:47:39 | Zaporizhia Oblast, Ukraine | ||
3491136 | 3491136 | 2020-07-13 | Russia | Altai Republic | 1099 | 1 | 567 | 531 | 50.7114101 | 86.8572186 | 2020-07-14 04:34:46 | Altai Republic, Russia | ||
415753 | 415753 | 2020-07-05 | Rwanda | 1105 | 3 | 567 | 535 | -1.9403 | 29.8739 | 2020-07-06 04:33:57 | Rwanda | |||
1196037 | 1196037 | 2020-06-17 | China | Sichuan | 589 | 3 | 567 | 19 | 30.6171 | 102.7103 | 2020-06-18 04:33:18 | Sichuan, China | ||
1273791 | 1273791 | 2020-06-11 | Congo (Kinshasa) | 4515 | 98 | 567 | 3850 | -4.0383 | 21.7587 | 2020-06-12 05:09:52 | Congo (Kinshasa) | |||
1210993 | 1210993 | 2020-06-09 | Russia | Vologda Oblast | 1137 | 11 | 567 | 559 | 60.0391461 | 43.1215213 | 2020-06-10 04:07:00 | Vologda Oblast, Russia | ||
2147043 | 2147043 | 2020-03-23 | Cruise Ship | Diamond Princess | 712 | 8 | 567 | 137 | 0.0 | 0.0 | 2020-03-23 23:19:21 | Diamond Princess, Cruise Ship | ||
2910661 | 2910661 | 2020-03-22 | Cruise Ship | Diamond Princess | 712 | 8 | 567 | 137 | 0.0 | 0.0 | 3/22/20 23:45 | Diamond Princess, Cruise Ship |
Advanced export
JSON shape: default, array, newline-delimited
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]);