johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
56 rows where recovered = 309 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1440361 | 1440361 | 2021-07-07 | Canada | Yukon | 447 | 5 | 309 | 133 | 64.2823 | -135.0 | 2021-07-08 04:21:26 | Yukon, Canada | ||
3054021 | 3054021 | 2021-05-13 | China | Yunnan | 348 | 2 | 309 | 37 | 24.974 | 101.487 | 2021-05-14 04:20:41 | Yunnan, China | ||
1616197 | 1616197 | 2021-03-05 | India | Lakshadweep | 425 | 1 | 309 | 115 | 13.6999972 | 72.18333259999999 | 2021-03-06 04:23:41 | Lakshadweep, India | ||
2207608 | 2207608 | 2021-03-04 | India | Lakshadweep | 425 | 1 | 309 | 115 | 13.6999972 | 72.18333259999999 | 2021-03-05 05:26:29 | Lakshadweep, India | ||
1089767 | 1089767 | 2021-03-03 | Antigua and Barbuda | 769 | 19 | 309 | 441 | 17.0608 | -61.7964 | 2021-03-04 05:24:24 | Antigua and Barbuda | |||
1759123 | 1759123 | 2021-01-24 | China | Tianjin | 338 | 3 | 309 | 26 | 39.3054 | 117.323 | 2021-01-25 05:22:16 | Tianjin, China | ||
2426730 | 2426730 | 2021-01-23 | China | Tianjin | 336 | 3 | 309 | 24 | 39.3054 | 117.323 | 2021-01-24 05:22:35 | Tianjin, China | ||
2466632 | 2466632 | 2021-01-22 | China | Tianjin | 335 | 3 | 309 | 23 | 39.3054 | 117.323 | 2021-01-23 05:22:03 | Tianjin, China | ||
190334 | 190334 | 2021-01-11 | Saint Lucia | 462 | 5 | 309 | 148 | 13.9094 | -60.9789 | 2021-01-12 05:22:15 | Saint Lucia | |||
2626137 | 2626137 | 2021-01-10 | Saint Lucia | 438 | 5 | 309 | 124 | 13.9094 | -60.9789 | 2021-01-11 05:21:50 | Saint Lucia | |||
3900225 | 3900225 | 2021-01-09 | Saint Lucia | 438 | 5 | 309 | 124 | 13.9094 | -60.9789 | 2021-01-10 05:22:12 | Saint Lucia | |||
154248 | 154248 | 2021-01-08 | Saint Lucia | 395 | 5 | 309 | 81 | 13.9094 | -60.9789 | 2021-01-09 05:22:18 | Saint Lucia | |||
2127998 | 2127998 | 2020-12-17 | Japan | Fukui | 337 | 11 | 309 | 17 | 35.846614 | 136.22465400000002 | 2020-12-18 05:28:18 | Fukui, Japan | ||
3847551 | 3847551 | 2020-12-13 | Cambodia | 359 | 0 | 309 | 50 | 11.55 | 104.9167 | 2020-12-14 05:26:27 | Cambodia | |||
2975043 | 2975043 | 2020-12-09 | China | Inner Mongolia | 337 | 1 | 309 | 27 | 44.0935 | 113.9448 | 2020-12-10 05:26:19 | Inner Mongolia, China | ||
2883880 | 2883880 | 2020-11-15 | Malaysia | Melaka | 362 | 6 | 309 | 47 | 2.1896 | 102.2501 | 2020-11-16 05:25:57 | Melaka, Malaysia | ||
2497790 | 2497790 | 2020-11-03 | Canada | New Brunswick | 344 | 6 | 309 | 29 | 46.5653 | -66.4619 | 2020-11-04 05:25:09 | New Brunswick, Canada | ||
8339 | 8339 | 2020-10-25 | Japan | Fukushima | 386 | 6 | 309 | 71 | 37.378867 | 140.223295 | 2020-10-26 04:25:02 | Fukushima, Japan | ||
3781805 | 3781805 | 2020-10-13 | France | St Martin | 466 | 8 | 309 | 149 | 18.0708 | -63.0501 | 2020-10-14 04:24:05 | St Martin, France | ||
2291345 | 2291345 | 2020-10-12 | France | St Martin | 466 | 8 | 309 | 149 | 18.0708 | -63.0501 | 2020-10-13 04:24:02 | St Martin, France | ||
3785798 | 3785798 | 2020-10-11 | France | St Martin | 466 | 8 | 309 | 149 | 18.0708 | -63.0501 | 2020-10-12 04:23:45 | St Martin, France | ||
2601936 | 2601936 | 2020-10-10 | France | St Martin | 412 | 8 | 309 | 95 | 18.0708 | -63.0501 | 2020-10-11 04:23:46 | St Martin, France | ||
817469 | 817469 | 2020-10-09 | France | St Martin | 412 | 8 | 309 | 95 | 18.0708 | -63.0501 | 2020-10-10 04:23:57 | St Martin, France | ||
2689584 | 2689584 | 2020-10-08 | France | St Martin | 412 | 8 | 309 | 95 | 18.0708 | -63.0501 | 2020-10-09 04:23:59 | St Martin, France | ||
1041726 | 1041726 | 2020-10-07 | France | St Martin | 412 | 8 | 309 | 95 | 18.0708 | -63.0501 | 2020-10-08 04:23:56 | St Martin, France | ||
3117387 | 3117387 | 2020-10-06 | France | St Martin | 412 | 8 | 309 | 95 | 18.0708 | -63.0501 | 2020-10-07 04:23:40 | St Martin, France | ||
3801799 | 3801799 | 2020-10-05 | France | St Martin | 412 | 8 | 309 | 95 | 18.0708 | -63.0501 | 2020-10-06 04:23:33 | St Martin, France | ||
1822689 | 1822689 | 2020-10-04 | France | St Martin | 412 | 8 | 309 | 95 | 18.0708 | -63.0501 | 2020-10-05 04:23:33 | St Martin, France | ||
2514073 | 2514073 | 2020-10-03 | France | St Martin | 412 | 8 | 309 | 95 | 18.0708 | -63.0501 | 2020-10-04 04:23:44 | St Martin, France | ||
3389291 | 3389291 | 2020-10-02 | France | St Martin | 383 | 8 | 309 | 66 | 18.0708 | -63.0501 | 2020-10-03 04:23:40 | St Martin, France | ||
2379532 | 2379532 | 2020-10-01 | France | St Martin | 383 | 8 | 309 | 66 | 18.0708 | -63.0501 | 2020-10-02 04:23:51 | St Martin, France | ||
2653656 | 2653656 | 2020-09-23 | Eritrea | 364 | 0 | 309 | 55 | 15.1794 | 39.7823 | 2020-09-24 04:23:00 | Eritrea | |||
3316105 | 3316105 | 2020-09-22 | Eritrea | 364 | 0 | 309 | 55 | 15.1794 | 39.7823 | 2020-09-23 04:23:00 | Eritrea | |||
669918 | 669918 | 2020-09-16 | United Kingdom | Gibraltar | 340 | 0 | 309 | 31 | 36.1408 | -5.3536 | 2020-09-17 04:22:00 | Gibraltar, United Kingdom | ||
2175161 | 2175161 | 2020-09-09 | Ukraine | Kherson Oblast | 538 | 14 | 309 | 215 | 46.6354 | 32.6169 | 2020-09-10 04:29:01 | Kherson Oblast, Ukraine | ||
1920302 | 1920302 | 2020-08-10 | Japan | Gifu | 472 | 7 | 309 | 156 | 35.778671 | 137.055925 | 2020-08-11 04:35:08 | Gifu, Japan | ||
458868 | 458868 | 2020-08-07 | Burma | 359 | 6 | 309 | 44 | 21.9162 | 95.956 | 2020-08-08 04:34:53 | Burma | |||
1707360 | 1707360 | 2020-07-21 | Ukraine | Chernihiv Oblast | 649 | 15 | 309 | 325 | 51.4982 | 31.2893 | 2020-07-22 04:34:42 | Chernihiv Oblast, Ukraine | ||
326851 | 326851 | 2020-07-20 | Ukraine | Chernihiv Oblast | 642 | 14 | 309 | 319 | 51.4982 | 31.2893 | 2020-07-21 04:38:46 | Chernihiv Oblast, Ukraine | ||
121756 | 121756 | 2020-07-19 | Ukraine | Chernihiv Oblast | 642 | 14 | 309 | 319 | 51.4982 | 31.2893 | 2020-07-20 05:34:40 | Chernihiv Oblast, Ukraine | ||
3205145 | 3205145 | 2020-07-18 | Ukraine | Chernihiv Oblast | 632 | 14 | 309 | 309 | 51.4982 | 31.2893 | 2020-07-19 04:34:58 | Chernihiv Oblast, Ukraine | ||
2708447 | 2708447 | 2020-07-17 | Ukraine | Chernihiv Oblast | 632 | 14 | 309 | 309 | 51.4982 | 31.2893 | 2020-07-18 04:34:45 | Chernihiv Oblast, Ukraine | ||
415405 | 415405 | 2020-07-05 | Ukraine | Mykolaiv Oblast | 458 | 10 | 309 | 139 | 46.975 | 31.9946 | 2020-07-06 04:33:57 | Mykolaiv Oblast, Ukraine | ||
2974606 | 2974606 | 2020-06-30 | China | Shaanxi | 320 | 3 | 309 | 8 | 35.1917 | 108.8701 | 2020-07-01 04:33:52 | Shaanxi, China | ||
2039682 | 2039682 | 2020-06-27 | Mexico | Colima | 502 | 63 | 309 | 130 | 19.1223 | -104.0072 | 2020-06-28 04:34:04 | Colima, Mexico | ||
1135944 | 1135944 | 2020-06-26 | Colombia | Cesar | 791 | 22 | 309 | 460 | 9.3373 | -73.6536 | 2020-06-27 04:33:35 | Cesar, Colombia | ||
1793924 | 1793924 | 2020-05-31 | United Kingdom | Isle of Man | 336 | 24 | 309 | 3 | 54.2361 | -4.5481 | 2020-06-01 02:32:46 | Isle of Man, United Kingdom | ||
3638817 | 3638817 | 2020-05-30 | United Kingdom | Isle of Man | 336 | 24 | 309 | 3 | 54.2361 | -4.5481 | 2020-05-31 02:32:45 | Isle of Man, United Kingdom | ||
1790358 | 1790358 | 2020-05-29 | United Kingdom | Isle of Man | 336 | 24 | 309 | 3 | 54.2361 | -4.5481 | 2020-05-30 02:32:48 | Isle of Man, United Kingdom | ||
268590 | 268590 | 2020-05-21 | Sudan | 3138 | 121 | 309 | 2708 | 12.8628 | 30.2176 | 2020-05-22 02:36:51 | Sudan | |||
1404606 | 1404606 | 2020-05-14 | Montenegro | 324 | 9 | 309 | 6 | 42.708678000000006 | 19.37439 | 2020-05-15 02:33:02 | Montenegro | |||
3459673 | 3459673 | 2020-05-10 | Georgia | 635 | 10 | 309 | 316 | 42.3154 | 43.3569 | 2020-05-11 02:32:30 | Georgia | |||
1199264 | 1199264 | 2020-04-22 | Andorra | 723 | 37 | 309 | 377 | 42.5063 | 1.5218 | 2020-04-22 23:30:32 | Andorra | |||
522367 | 522367 | 2020-04-21 | Cuba | 1137 | 38 | 309 | 790 | 21.521757 | -77.78116700000002 | 2020-04-21 23:30:30 | Cuba | |||
1250154 | 1250154 | 2020-04-10 | China | Hong Kong | 989 | 4 | 309 | 676 | 22.3 | 114.2 | 2020-04-10 10:12:56 | Hong Kong, China | ||
3740627 | 3740627 | 2020-04-03 | Iceland | 1364 | 4 | 309 | 1051 | 64.9631 | -19.0208 | 2020-04-03 22:46:20 | Iceland |
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]);