johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
26 rows where recovered = 706 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1487236 | 1487236 | 2021-08-13 | Malaysia | Perlis | 960 | 13 | 706 | 241 | 6.4449 | 100.2048 | 2021-08-14 04:21:25 | Perlis, Malaysia | ||
3003119 | 3003119 | 2021-04-06 | China | Jiangsu | 715 | 0 | 706 | 9 | 32.9711 | 119.455 | 2021-04-07 04:20:53 | Jiangsu, China | ||
2677828 | 2677828 | 2021-02-13 | Japan | Aomori | 801 | 16 | 706 | 79 | 40.781541 | 140.828896 | 2021-02-14 05:23:43 | Aomori, Japan | ||
340541 | 340541 | 2021-02-03 | Saint Lucia | 1479 | 16 | 706 | 757 | 13.9094 | -60.9789 | 2021-02-04 05:22:26 | Saint Lucia | |||
3570220 | 3570220 | 2020-11-29 | United Kingdom | Turks and Caicos Islands | 748 | 6 | 706 | 36 | 21.694000000000006 | -71.7979 | 2020-11-30 05:26:13 | Turks and Caicos Islands, United Kingdom | ||
2938885 | 2938885 | 2020-11-28 | United Kingdom | Turks and Caicos Islands | 748 | 6 | 706 | 36 | 21.694000000000006 | -71.7979 | 2020-11-29 05:25:55 | Turks and Caicos Islands, United Kingdom | ||
754018 | 754018 | 2020-10-28 | Australia | Western Australia | 765 | 9 | 706 | 50 | -31.9505 | 115.8605 | 2020-10-29 04:24:49 | Western Australia, Australia | ||
1452303 | 1452303 | 2020-10-27 | Australia | Western Australia | 765 | 9 | 706 | 50 | -31.9505 | 115.8605 | 2020-10-28 04:24:39 | Western Australia, Australia | ||
1030029 | 1030029 | 2020-10-17 | Malaysia | Sarawak | 763 | 19 | 706 | 38 | 1.5533 | 110.3592 | 2020-10-18 04:24:25 | Sarawak, Malaysia | ||
669884 | 669884 | 2020-09-16 | Ukraine | Chernihiv Oblast | 2922 | 40 | 706 | 2176 | 51.4982 | 31.2893 | 2020-09-17 04:22:00 | Chernihiv Oblast, Ukraine | ||
2665393 | 2665393 | 2020-09-04 | Ukraine | Kirovohrad Oblast | 841 | 47 | 706 | 88 | 48.5079 | 32.2623 | 2020-09-05 04:28:19 | Kirovohrad Oblast, Ukraine | ||
2740041 | 2740041 | 2020-08-03 | India | Chandigarh | 1159 | 19 | 706 | 434 | 30.733839 | 76.76827800000002 | 2020-08-04 04:41:59 | Chandigarh, India | ||
61908 | 61908 | 2020-07-23 | Japan | Hyogo | 918 | 45 | 706 | 167 | 35.039913 | 134.828057 | 2020-07-24 05:30:40 | Hyogo, Japan | ||
327357 | 327357 | 2020-07-20 | Jamaica | 809 | 10 | 706 | 93 | 18.1096 | -77.2975 | 2020-07-21 04:38:46 | Jamaica | |||
2708364 | 2708364 | 2020-07-17 | Russia | Altai Republic | 1197 | 1 | 706 | 490 | 50.7114101 | 86.8572186 | 2020-07-18 04:34:45 | Altai Republic, Russia | ||
530184 | 530184 | 2020-07-04 | Mexico | Zacatecas | 1057 | 110 | 706 | 241 | 22.7709 | -102.5832 | 2020-07-05 04:33:46 | Zacatecas, Mexico | ||
2306821 | 2306821 | 2020-06-28 | Haiti | 5722 | 98 | 706 | 4918 | 18.9712 | -72.2852 | 2020-06-29 04:33:44 | Haiti | |||
2040156 | 2040156 | 2020-06-27 | Haiti | 5543 | 96 | 706 | 4741 | 18.9712 | -72.2852 | 2020-06-28 04:34:04 | Haiti | |||
2386897 | 2386897 | 2020-06-16 | Ukraine | Zakarpattia Oblast | 1726 | 42 | 706 | 978 | 48.6208 | 22.2879 | 2020-06-17 04:33:21 | Zakarpattia Oblast, Ukraine | ||
3061089 | 3061089 | 2020-06-13 | Japan | Fukuoka | 822 | 32 | 706 | 84 | 33.526032 | 130.666949 | 2020-06-14 03:33:15 | Fukuoka, Japan | ||
1273788 | 1273788 | 2020-06-11 | Chad | 848 | 72 | 706 | 70 | 15.4542 | 18.7322 | 2020-06-12 05:09:52 | Chad | |||
2864227 | 2864227 | 2020-06-10 | Chad | 846 | 72 | 706 | 68 | 15.4542 | 18.7322 | 2020-06-11 03:33:41 | Chad | |||
1211044 | 1211044 | 2020-06-09 | Chad | 844 | 71 | 706 | 67 | 15.4542 | 18.7322 | 2020-06-10 04:07:00 | Chad | |||
574374 | 574374 | 2020-06-06 | Kenya | 2600 | 83 | 706 | 1811 | -0.0236 | 37.9062 | 2020-06-07 03:53:30 | Kenya | |||
3639074 | 3639074 | 2020-05-30 | Guatemala | 4739 | 102 | 706 | 3931 | 15.7835 | -90.2308 | 2020-05-31 02:32:45 | Guatemala | |||
3503027 | 3503027 | 2020-04-25 | Malaysia | W.P. Kuala Lumpur | 1150 | 15 | 706 | 429 | 3.139 | 101.6869 | 2020-04-26 02:30:51 | W.P. Kuala Lumpur, Malaysia |
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]);