johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
39 rows where recovered = 413 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3218128 | 3218128 | 2021-07-26 | China | Yunnan | 740 | 2 | 413 | 325 | 24.974 | 101.487 | 2021-07-27 04:21:18 | Yunnan, China | ||
1806787 | 1806787 | 2021-05-27 | Japan | Tottori | 463 | 2 | 413 | 48 | 35.359069 | 133.863619 | 2021-05-28 04:20:36 | Tottori, Japan | ||
887892 | 887892 | 2021-04-26 | Canada | Nunavut | 464 | 4 | 413 | 47 | 70.2998 | -83.1076 | 2021-04-27 04:20:52 | Nunavut, Canada | ||
2207694 | 2207694 | 2021-03-04 | Japan | Tokushima | 457 | 16 | 413 | 28 | 33.919178 | 134.242091 | 2021-03-05 05:26:29 | Tokushima, Japan | ||
1090115 | 1090115 | 2021-03-03 | Japan | Tokushima | 453 | 16 | 413 | 24 | 33.919178 | 134.242091 | 2021-03-04 05:24:24 | Tokushima, Japan | ||
2371142 | 2371142 | 2021-02-28 | United Kingdom | Cayman Islands | 444 | 2 | 413 | 29 | 19.3133 | -81.2546 | 2021-03-01 05:23:01 | Cayman Islands, United Kingdom | ||
3069644 | 3069644 | 2021-02-27 | United Kingdom | Cayman Islands | 444 | 2 | 413 | 29 | 19.3133 | -81.2546 | 2021-02-28 05:22:20 | Cayman Islands, United Kingdom | ||
2187228 | 2187228 | 2021-02-26 | United Kingdom | Cayman Islands | 444 | 2 | 413 | 29 | 19.3133 | -81.2546 | 2021-02-27 05:22:28 | Cayman Islands, United Kingdom | ||
439045 | 439045 | 2021-01-21 | Malaysia | W.P. Putrajaya | 669 | 6 | 413 | 250 | 2.9264 | 101.6964 | 2021-01-22 05:22:10 | W.P. Putrajaya, Malaysia | ||
2223556 | 2223556 | 2020-12-26 | Japan | Yamaguchi | 516 | 3 | 413 | 100 | 34.201190000000004 | 131.573293 | 2020-12-27 05:22:55 | Yamaguchi, Japan | ||
1972594 | 1972594 | 2020-11-25 | Japan | Fukushima | 480 | 6 | 413 | 61 | 37.378867 | 140.223295 | 2020-11-26 05:27:44 | Fukushima, Japan | ||
2498092 | 2498092 | 2020-11-03 | Mauritius | 451 | 10 | 413 | 28 | -20.348404 | 57.552152 | 2020-11-04 05:25:09 | Mauritius | |||
2497822 | 2497822 | 2020-11-03 | China | Fujian | 443 | 1 | 413 | 29 | 26.0789 | 117.9874 | 2020-11-04 05:25:09 | Fujian, China | ||
3304267 | 3304267 | 2020-11-02 | Mauritius | 446 | 10 | 413 | 28 | -20.348404 | 57.552152 | 2020-11-03 06:00:16 | Mauritius | |||
2291460 | 2291460 | 2020-10-12 | Japan | Kagoshima | 456 | 12 | 413 | 31 | 31.009484000000004 | 130.430665 | 2020-10-13 04:24:02 | Kagoshima, Japan | ||
3789537 | 3789537 | 2020-10-11 | United Kingdom | Gibraltar | 485 | 0 | 413 | 72 | 36.1408 | -5.3536 | 2020-10-12 04:23:45 | Gibraltar, United Kingdom | ||
3785913 | 3785913 | 2020-10-11 | Japan | Kagoshima | 455 | 12 | 413 | 30 | 31.009484000000004 | 130.430665 | 2020-10-12 04:23:45 | Kagoshima, Japan | ||
2602051 | 2602051 | 2020-10-10 | Japan | Kagoshima | 449 | 12 | 413 | 24 | 31.009484000000004 | 130.430665 | 2020-10-11 04:23:46 | Kagoshima, Japan | ||
817584 | 817584 | 2020-10-09 | Japan | Kagoshima | 447 | 12 | 413 | 22 | 31.009484000000004 | 130.430665 | 2020-10-10 04:23:57 | Kagoshima, Japan | ||
2379652 | 2379652 | 2020-10-01 | Japan | Mie | 523 | 7 | 413 | 103 | 34.508018 | 136.376013 | 2020-10-02 04:23:51 | Mie, Japan | ||
2836693 | 2836693 | 2020-09-21 | Denmark | Faroe Islands | 437 | 0 | 413 | 24 | 61.8926 | -6.9118 | 2020-09-22 04:23:00 | Faroe Islands, Denmark | ||
3161600 | 3161600 | 2020-09-06 | Italy | Basilicata | 564 | 28 | 413 | 123 | 40.63947052 | 15.80514834 | 2020-09-07 04:28:30 | Basilicata, Italy | ||
3932046 | 3932046 | 2020-08-30 | Japan | Kumamoto | 511 | 7 | 413 | 91 | 32.608154 | 130.74523100000002 | 2020-08-31 04:28:27 | Kumamoto, Japan | ||
209871 | 209871 | 2020-08-19 | Ukraine | Poltava Oblast | 582 | 15 | 413 | 154 | 49.5883 | 34.5514 | 2020-08-20 04:27:43 | Poltava Oblast, Ukraine | ||
2958492 | 2958492 | 2020-07-29 | Colombia | Huila | 778 | 20 | 413 | 345 | 2.5359 | -75.5277 | 2020-07-30 04:35:05 | Huila, Colombia | ||
3435871 | 3435871 | 2020-07-11 | India | Chandigarh | 555 | 7 | 413 | 135 | 30.733839 | 76.76827800000002 | 2020-07-12 04:34:30 | Chandigarh, India | ||
2040215 | 2040215 | 2020-06-27 | Rwanda | 878 | 2 | 413 | 463 | -1.9403 | 29.8739 | 2020-06-28 04:34:04 | Rwanda | |||
3249642 | 3249642 | 2020-06-21 | Cabo Verde | 890 | 8 | 413 | 469 | 16.5388 | -23.0418 | 2020-06-22 04:33:20 | Cabo Verde | |||
2437864 | 2437864 | 2020-06-20 | India | Himachal Pradesh | 656 | 8 | 413 | 235 | 31.927213000000002 | 77.233081 | 2020-06-21 04:33:19 | Himachal Pradesh, India | ||
737480 | 737480 | 2020-06-12 | Russia | Kamchatka Krai | 1360 | 10 | 413 | 937 | 57.1914882 | 160.03838190000005 | 2020-06-13 03:33:14 | Kamchatka Krai, Russia | ||
1269724 | 1269724 | 2020-06-05 | Ukraine | Kirovohrad Oblast | 538 | 27 | 413 | 98 | 48.5079 | 32.2623 | 2020-06-06 02:33:00 | Kirovohrad Oblast, Ukraine | ||
2555608 | 2555608 | 2020-06-02 | Russia | Adygea Republic | 890 | 9 | 413 | 468 | 44.6939006 | 40.1520421 | 2020-06-03 02:33:13 | Adygea Republic, Russia | ||
1790673 | 1790673 | 2020-05-29 | Paraguay | 917 | 11 | 413 | 493 | -23.4425 | -58.4438 | 2020-05-30 02:32:48 | Paraguay | |||
2712461 | 2712461 | 2020-05-28 | Chad | 726 | 65 | 413 | 248 | 15.4542 | 18.7322 | 2020-05-29 02:32:50 | Chad | |||
997888 | 997888 | 2020-05-23 | Mexico | Tlaxcala | 749 | 121 | 413 | 215 | 19.3139 | -98.2404 | 2020-05-24 02:32:43 | Tlaxcala, Mexico | ||
3261060 | 3261060 | 2020-05-18 | Jordan | 629 | 9 | 413 | 207 | 31.24 | 36.51 | 2020-05-19 02:32:18 | Jordan | |||
3295749 | 3295749 | 2020-05-07 | Malta | 486 | 5 | 413 | 68 | 35.9375 | 14.3754 | 2020-05-08 02:32:32 | Malta | |||
1931943 | 1931943 | 2020-05-05 | Costa Rica | 755 | 6 | 413 | 336 | 9.7489 | -83.7534 | 2020-05-06 02:32:31 | Costa Rica | |||
1720047 | 1720047 | 2020-02-19 | Mainland China | Anhui | 986 | 6 | 413 | 31.8257 | 117.2264 | 2020-02-19T14:13:03 |
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]);