johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
30 rows where recovered = 479 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 15
- Japan 9
- Taiwan* 4
- China 3
- Australia 2
- Italy 2
- Austria 1
- Cabo Verde 1
- Denmark 1
- Germany 1
- Jordan 1
- Libya 1
- Malaysia 1
- Mali 1
- Netherlands 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3137593 | 3137593 | 2021-07-23 | Japan | Tottori | 633 | 2 | 479 | 152 | 35.359069 | 133.863619 | 2021-07-24 00:21:36 | Tottori, Japan | ||
1448624 | 1448624 | 2021-06-03 | Japan | Shimane | 543 | 0 | 479 | 64 | 35.07076 | 132.55406399999998 | 2021-06-04 04:23:37 | Shimane, Japan | ||
1338280 | 1338280 | 2021-02-15 | Japan | Fukui | 530 | 25 | 479 | 26 | 35.846614 | 136.22465400000002 | 2021-02-16 05:24:38 | Fukui, Japan | ||
3879580 | 3879580 | 2021-01-14 | Japan | Ehime | 762 | 13 | 479 | 270 | 33.624835 | 132.856842 | 2021-01-15 05:22:24 | Ehime, Japan | ||
1600243 | 1600243 | 2020-12-10 | Japan | Miyazaki | 578 | 3 | 479 | 96 | 32.193203999999994 | 131.299374 | 2020-12-11 05:26:59 | Miyazaki, Japan | ||
2347247 | 2347247 | 2020-12-07 | China | Shaanxi | 502 | 3 | 479 | 20 | 35.1917 | 108.8701 | 2020-12-08 05:27:42 | Shaanxi, China | ||
210116 | 210116 | 2020-10-29 | Denmark | Faroe Islands | 494 | 0 | 479 | 15 | 61.8926 | -6.9118 | 2020-10-30 04:24:49 | Faroe Islands, Denmark | ||
754015 | 754015 | 2020-10-28 | Australia | South Australia | 495 | 4 | 479 | 12 | -34.9285 | 138.6007 | 2020-10-29 04:24:49 | South Australia, Australia | ||
1452300 | 1452300 | 2020-10-27 | Australia | South Australia | 494 | 4 | 479 | 11 | -34.9285 | 138.6007 | 2020-10-28 04:24:39 | South Australia, Australia | ||
2191714 | 2191714 | 2020-10-21 | Netherlands | Curacao | 785 | 1 | 479 | 305 | 12.1696 | -68.99 | 2020-10-22 04:24:27 | Curacao, Netherlands | ||
1794653 | 1794653 | 2020-10-19 | Japan | Miyagi | 529 | 2 | 479 | 48 | 38.446859 | 140.927086 | 2020-10-20 04:24:22 | Miyagi, Japan | ||
2514181 | 2514181 | 2020-10-03 | Japan | Hiroshima | 602 | 3 | 479 | 120 | 34.605309000000005 | 132.788719 | 2020-10-04 04:23:44 | Hiroshima, Japan | ||
3389399 | 3389399 | 2020-10-02 | Japan | Hiroshima | 588 | 3 | 479 | 106 | 34.605309000000005 | 132.788719 | 2020-10-03 04:23:40 | Hiroshima, Japan | ||
2581970 | 2581970 | 2020-09-27 | Italy | Molise | 644 | 24 | 479 | 141 | 41.55774754 | 14.65916051 | 2020-09-28 04:23:00 | Molise, Italy | ||
2614022 | 2614022 | 2020-09-26 | Italy | Molise | 637 | 23 | 479 | 135 | 41.55774754 | 14.65916051 | 2020-09-27 04:23:00 | Molise, Italy | ||
3316543 | 3316543 | 2020-09-22 | Taiwan* | 509 | 7 | 479 | 23 | 23.7 | 121.0 | 2020-09-23 04:23:00 | Taiwan* | |||
2837142 | 2837142 | 2020-09-21 | Taiwan* | 509 | 7 | 479 | 23 | 23.7 | 121.0 | 2020-09-22 04:23:00 | Taiwan* | |||
3093746 | 3093746 | 2020-09-20 | Taiwan* | 507 | 7 | 479 | 21 | 23.7 | 121.0 | 2020-09-21 04:23:00 | Taiwan* | |||
2455096 | 2455096 | 2020-09-19 | Taiwan* | 506 | 7 | 479 | 20 | 23.7 | 121.0 | 2020-09-20 04:22:00 | Taiwan* | |||
2991280 | 2991280 | 2020-08-24 | Japan | Gifu | 543 | 9 | 479 | 55 | 35.778671 | 137.055925 | 2020-08-25 04:28:02 | Gifu, Japan | ||
1707879 | 1707879 | 2020-07-21 | Libya | 2088 | 50 | 479 | 1559 | 26.3351 | 17.228331 | 2020-07-22 04:34:42 | Libya | |||
2748304 | 2748304 | 2020-07-15 | Germany | Unknown | 1000 | 0 | 479 | 521 | 2020-07-16 04:44:59 | Unknown, Germany | ||||
2701024 | 2701024 | 2020-06-24 | Cabo Verde | 999 | 8 | 479 | 512 | 16.5388 | -23.0418 | 2020-06-25 05:26:54 | Cabo Verde | |||
2548540 | 2548540 | 2020-05-27 | Malaysia | Sarawak | 552 | 17 | 479 | 56 | 1.5533 | 110.3592 | 2020-05-28 02:32:31 | Sarawak, Malaysia | ||
1105120 | 1105120 | 2020-05-25 | Jordan | 711 | 9 | 479 | 223 | 31.24 | 36.51 | 2020-05-26 02:32:35 | Jordan | |||
2390123 | 2390123 | 2020-05-19 | United Kingdom | Channel Islands | 0 | 0 | 479 | 32 | 49.3723 | -2.3644 | 2020-05-20 02:32:19 | Channel Islands, United Kingdom | ||
1829708 | 1829708 | 2020-05-16 | Mali | 835 | 48 | 479 | 308 | 17.570692 | -3.996166000000001 | 2020-05-17 02:32:32 | Mali | |||
1199203 | 1199203 | 2020-04-22 | China | Heilongjiang | 921 | 13 | 479 | 429 | 47.861999999999995 | 127.7615 | 2020-04-22 10:15:03 | Heilongjiang, China | ||
2578103 | 2578103 | 2020-04-12 | China | Beijing | 589 | 8 | 479 | 102 | 40.1824 | 116.4142 | 2020-04-12 02:25:00 | Beijing, China | ||
2875677 | 2875677 | 2020-03-29 | Austria | 8100 | 101 | 479 | 8223 | 47.5162 | 14.5501 | 3/29/20 23:08 | Austria |
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]);