johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
55 rows where recovered = 675 sorted by day descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1712215 | 1712215 | 2021-06-25 | Fiji | 3063 | 14 | 675 | 2374 | -17.7134 | 178.065 | 2021-06-26 04:21:43 | Fiji | |||
2104004 | 2104004 | 2021-06-01 | Denmark | Faroe Islands | 721 | 1 | 675 | 45 | 61.8926 | -6.9118 | 2021-06-02 04:24:34 | Faroe Islands, Denmark | ||
3923711 | 3923711 | 2021-04-24 | Australia | South Australia | 704 | 4 | 675 | 25 | -34.9285 | 138.6007 | 2021-04-25 04:20:32 | South Australia, Australia | ||
1408742 | 1408742 | 2021-04-23 | Australia | South Australia | 703 | 4 | 675 | 24 | -34.9285 | 138.6007 | 2021-04-24 04:20:38 | South Australia, Australia | ||
2287069 | 2287069 | 2021-02-14 | United Kingdom | Bermuda | 694 | 12 | 675 | 7 | 32.3078 | -64.7505 | 2021-02-15 05:24:49 | Bermuda, United Kingdom | ||
2681469 | 2681469 | 2021-02-13 | United Kingdom | Bermuda | 694 | 12 | 675 | 7 | 32.3078 | -64.7505 | 2021-02-14 05:23:43 | Bermuda, United Kingdom | ||
3543102 | 3543102 | 2021-02-12 | United Kingdom | Bermuda | 694 | 12 | 675 | 7 | 32.3078 | -64.7505 | 2021-02-13 05:22:12 | Bermuda, United Kingdom | ||
2127895 | 2127895 | 2020-12-17 | France | St Martin | 899 | 12 | 675 | 212 | 18.0708 | -63.0501 | 2020-12-18 05:28:18 | St Martin, France | ||
3149818 | 3149818 | 2020-12-16 | Russia | Nenets Autonomous Okrug | 729 | 0 | 675 | 54 | 68.27557185 | 57.1686375 | 2020-12-17 05:28:12 | Nenets Autonomous Okrug, Russia | ||
3149495 | 3149495 | 2020-12-16 | France | St Martin | 899 | 12 | 675 | 212 | 18.0708 | -63.0501 | 2020-12-17 05:28:12 | St Martin, France | ||
3149409 | 3149409 | 2020-12-16 | China | Jiangsu | 684 | 0 | 675 | 9 | 32.9711 | 119.455 | 2020-12-17 05:28:12 | Jiangsu, China | ||
1034599 | 1034599 | 2020-12-15 | Russia | Nenets Autonomous Okrug | 726 | 0 | 675 | 51 | 68.27557185 | 57.1686375 | 2020-12-16 05:28:04 | Nenets Autonomous Okrug, Russia | ||
1034276 | 1034276 | 2020-12-15 | France | St Martin | 899 | 12 | 675 | 212 | 18.0708 | -63.0501 | 2020-12-16 05:28:04 | St Martin, France | ||
1034190 | 1034190 | 2020-12-15 | China | Jiangsu | 684 | 0 | 675 | 9 | 32.9711 | 119.455 | 2020-12-16 05:28:04 | Jiangsu, China | ||
1751493 | 1751493 | 2020-12-14 | Russia | Nenets Autonomous Okrug | 723 | 0 | 675 | 48 | 68.27557185 | 57.1686375 | 2020-12-15 05:26:38 | Nenets Autonomous Okrug, Russia | ||
1751170 | 1751170 | 2020-12-14 | France | St Martin | 838 | 12 | 675 | 151 | 18.0708 | -63.0501 | 2020-12-15 05:26:38 | St Martin, France | ||
1751084 | 1751084 | 2020-12-14 | China | Jiangsu | 684 | 0 | 675 | 9 | 32.9711 | 119.455 | 2020-12-15 05:26:38 | Jiangsu, China | ||
3847690 | 3847690 | 2020-12-13 | France | St Martin | 838 | 12 | 675 | 151 | 18.0708 | -63.0501 | 2020-12-14 05:26:27 | St Martin, France | ||
3847604 | 3847604 | 2020-12-13 | China | Jiangsu | 684 | 0 | 675 | 9 | 32.9711 | 119.455 | 2020-12-14 05:26:27 | Jiangsu, China | ||
845472 | 845472 | 2020-12-12 | France | St Martin | 838 | 12 | 675 | 151 | 18.0708 | -63.0501 | 2020-12-13 05:27:20 | St Martin, France | ||
845386 | 845386 | 2020-12-12 | China | Jiangsu | 684 | 0 | 675 | 9 | 32.9711 | 119.455 | 2020-12-13 05:27:20 | Jiangsu, China | ||
860579 | 860579 | 2020-12-11 | France | St Martin | 838 | 12 | 675 | 151 | 18.0708 | -63.0501 | 2020-12-12 05:26:19 | St Martin, France | ||
860493 | 860493 | 2020-12-11 | China | Jiangsu | 683 | 0 | 675 | 8 | 32.9711 | 119.455 | 2020-12-12 05:26:19 | Jiangsu, China | ||
1600121 | 1600121 | 2020-12-10 | France | St Martin | 838 | 12 | 675 | 151 | 18.0708 | -63.0501 | 2020-12-11 05:26:59 | St Martin, France | ||
1600035 | 1600035 | 2020-12-10 | China | Jiangsu | 681 | 0 | 675 | 6 | 32.9711 | 119.455 | 2020-12-11 05:26:59 | Jiangsu, China | ||
2975130 | 2975130 | 2020-12-09 | France | St Martin | 838 | 12 | 675 | 151 | 18.0708 | -63.0501 | 2020-12-10 05:26:19 | St Martin, France | ||
2975044 | 2975044 | 2020-12-09 | China | Jiangsu | 681 | 0 | 675 | 6 | 32.9711 | 119.455 | 2020-12-10 05:26:19 | Jiangsu, China | ||
1818690 | 1818690 | 2020-12-08 | France | St Martin | 838 | 12 | 675 | 151 | 18.0708 | -63.0501 | 2020-12-09 05:28:01 | St Martin, France | ||
1818604 | 1818604 | 2020-12-08 | China | Jiangsu | 681 | 0 | 675 | 6 | 32.9711 | 119.455 | 2020-12-09 05:28:01 | Jiangsu, China | ||
864778 | 864778 | 2020-11-12 | Japan | Gifu | 785 | 12 | 675 | 98 | 35.778671 | 137.055925 | 2020-11-13 05:25:30 | Gifu, Japan | ||
210228 | 210228 | 2020-10-29 | Italy | Molise | 1498 | 32 | 675 | 791 | 41.55774754 | 14.65916051 | 2020-10-30 04:24:49 | Molise, Italy | ||
3990735 | 3990735 | 2020-10-20 | Netherlands | Sint Maarten | 756 | 22 | 675 | 59 | 18.0425 | -63.0548 | 2020-10-21 04:24:14 | Sint Maarten, Netherlands | ||
1794755 | 1794755 | 2020-10-19 | Netherlands | Sint Maarten | 756 | 22 | 675 | 59 | 18.0425 | -63.0548 | 2020-10-20 04:24:22 | Sint Maarten, Netherlands | ||
1515590 | 1515590 | 2020-09-28 | Russia | Jewish Autonomous Okrug | 898 | 13 | 675 | 210 | 48.57527615 | 132.66307460000002 | 2020-09-29 04:23:42 | Jewish Autonomous Okrug, Russia | ||
3319892 | 3319892 | 2020-09-22 | Malaysia | Sabah | 1190 | 11 | 675 | 504 | 5.9788 | 116.0753 | 2020-09-23 04:23:00 | Sabah, Malaysia | ||
1176857 | 1176857 | 2020-09-10 | Malaysia | Sarawak | 700 | 19 | 675 | 6 | 1.5533 | 110.3592 | 2020-09-11 04:46:23 | Sarawak, Malaysia | ||
2175222 | 2175222 | 2020-09-09 | Malaysia | Sarawak | 700 | 19 | 675 | 6 | 1.5533 | 110.3592 | 2020-09-10 04:29:01 | Sarawak, Malaysia | ||
1247431 | 1247431 | 2020-09-08 | Malaysia | Sarawak | 699 | 19 | 675 | 5 | 1.5533 | 110.3592 | 2020-09-09 04:28:48 | Sarawak, Malaysia | ||
1555928 | 1555928 | 2020-08-16 | India | Meghalaya | 1374 | 6 | 675 | 693 | 25.536934 | 91.278882 | 2020-08-17 04:27:20 | Meghalaya, India | ||
371758 | 371758 | 2020-08-08 | Malta | 1035 | 9 | 675 | 351 | 35.9375 | 14.3754 | 2020-08-09 04:34:54 | Malta | |||
458942 | 458942 | 2020-08-07 | Malta | 995 | 9 | 675 | 311 | 35.9375 | 14.3754 | 2020-08-08 04:34:53 | Malta | |||
367281 | 367281 | 2020-07-16 | Ukraine | Crimea Republic* | 900 | 12 | 675 | 213 | 45.2835 | 34.2008 | 2020-07-17 04:34:50 | Crimea Republic*, Ukraine | ||
3491802 | 3491802 | 2020-07-13 | Yemen | 1498 | 424 | 675 | 399 | 15.552726999999999 | 48.516388 | 2020-07-14 04:34:46 | Yemen | |||
3436472 | 3436472 | 2020-07-11 | Malaysia | Johor | 702 | 19 | 675 | 8 | 1.4854 | 103.7618 | 2020-07-12 04:34:30 | Johor, Malaysia | ||
3237970 | 3237970 | 2020-07-10 | Malaysia | Johor | 700 | 19 | 675 | 6 | 1.4854 | 103.7618 | 2020-07-11 04:34:26 | Johor, Malaysia | ||
1005955 | 1005955 | 2020-07-09 | Malaysia | Johor | 699 | 19 | 675 | 5 | 1.4854 | 103.7618 | 2020-07-10 04:34:24 | Johor, Malaysia | ||
2223170 | 2223170 | 2020-07-08 | Malaysia | Johor | 697 | 19 | 675 | 3 | 1.4854 | 103.7618 | 2020-07-09 04:34:23 | Johor, Malaysia | ||
2974608 | 2974608 | 2020-06-30 | China | Shanghai | 712 | 7 | 675 | 30 | 31.202 | 121.4491 | 2020-07-01 04:33:52 | Shanghai, China | ||
2633085 | 2633085 | 2020-06-29 | China | Shanghai | 712 | 7 | 675 | 30 | 31.202 | 121.4491 | 2020-06-30 04:33:48 | Shanghai, China | ||
2306648 | 2306648 | 2020-06-28 | China | Shanghai | 708 | 7 | 675 | 26 | 31.202 | 121.4491 | 2020-06-29 04:33:44 | Shanghai, China | ||
2039983 | 2039983 | 2020-06-27 | China | Shanghai | 707 | 7 | 675 | 25 | 31.201999999999998 | 121.4491 | 2020-06-28 04:34:04 | Shanghai, China | ||
737783 | 737783 | 2020-06-12 | Ukraine | Zakarpattia Oblast | 1506 | 38 | 675 | 793 | 48.6208 | 22.2879 | 2020-06-13 03:33:14 | Zakarpattia Oblast, Ukraine | ||
1431922 | 1431922 | 2020-05-20 | Mexico | Morelos | 1115 | 205 | 675 | 235 | 18.6813 | -99.1013 | 2020-05-21 02:32:48 | Morelos, Mexico | ||
3459702 | 3459702 | 2020-05-10 | Kyrgyzstan | 1002 | 12 | 675 | 315 | 41.20438 | 74.766098 | 2020-05-11 02:32:30 | Kyrgyzstan | |||
919162 | 919162 | 2020-03-26 | Belgium | 6235 | 220 | 675 | 5340 | 50.8333 | 4.469936 | 2020-03-26 23:48:18 | Belgium |
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]);