johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
81 rows where recovered = 374 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3574633 | 3574633 | 2021-05-17 | Japan | Shimane | 437 | 0 | 374 | 63 | 35.07076 | 132.55406399999998 | 2021-05-18 04:20:33 | Shimane, Japan | ||
2943006 | 2943006 | 2021-05-16 | Malaysia | Perlis | 391 | 3 | 374 | 14 | 6.4449 | 100.2048 | 2021-05-17 04:20:34 | Perlis, Malaysia | ||
2760745 | 2760745 | 2021-05-03 | China | Tianjin | 385 | 3 | 374 | 8 | 39.3054 | 117.323 | 2021-05-04 04:20:34 | Tianjin, China | ||
2450598 | 2450598 | 2021-05-02 | China | Tianjin | 385 | 3 | 374 | 8 | 39.3054 | 117.323 | 2021-05-03 04:20:39 | Tianjin, China | ||
2824786 | 2824786 | 2021-05-01 | Japan | Akita | 480 | 9 | 374 | 97 | 39.748679 | 140.408228 | 2021-05-02 04:20:48 | Akita, Japan | ||
2824611 | 2824611 | 2021-05-01 | China | Tianjin | 385 | 3 | 374 | 8 | 39.3054 | 117.323 | 2021-05-02 04:20:48 | Tianjin, China | ||
380019 | 380019 | 2021-04-30 | China | Tianjin | 385 | 3 | 374 | 8 | 39.3054 | 117.323 | 2021-05-01 04:20:47 | Tianjin, China | ||
1636142 | 1636142 | 2021-04-29 | China | Tianjin | 385 | 3 | 374 | 8 | 39.3054 | 117.323 | 2021-04-30 04:21:03 | Tianjin, China | ||
3393221 | 3393221 | 2021-04-28 | China | Tianjin | 385 | 3 | 374 | 8 | 39.3054 | 117.323 | 2021-04-29 04:20:55 | Tianjin, China | ||
2548688 | 2548688 | 2021-04-15 | China | Inner Mongolia | 377 | 1 | 374 | 2 | 44.0935 | 113.9448 | 2021-04-16 04:20:46 | Inner Mongolia, China | ||
1841758 | 1841758 | 2021-04-14 | China | Inner Mongolia | 377 | 1 | 374 | 2 | 44.0935 | 113.9448 | 2021-04-15 04:20:54 | Inner Mongolia, China | ||
2571492 | 2571492 | 2021-04-13 | China | Inner Mongolia | 377 | 1 | 374 | 2 | 44.0935 | 113.9448 | 2021-04-14 04:20:41 | Inner Mongolia, China | ||
36243 | 36243 | 2021-04-12 | China | Inner Mongolia | 377 | 1 | 374 | 2 | 44.0935 | 113.9448 | 2021-04-13 04:20:37 | Inner Mongolia, China | ||
3883402 | 3883402 | 2021-04-11 | China | Inner Mongolia | 377 | 1 | 374 | 2 | 44.0935 | 113.9448 | 2021-04-12 04:21:00 | Inner Mongolia, China | ||
2983070 | 2983070 | 2021-04-10 | China | Inner Mongolia | 377 | 1 | 374 | 2 | 44.0935 | 113.9448 | 2021-04-11 04:20:56 | Inner Mongolia, China | ||
1732267 | 1732267 | 2021-03-14 | Canada | Nunavut | 383 | 1 | 374 | 8 | 70.2998 | -83.1076 | 2021-03-15 05:25:51 | Nunavut, Canada | ||
1579924 | 1579924 | 2021-03-13 | Canada | Nunavut | 383 | 1 | 374 | 8 | 70.2998 | -83.1076 | 2021-03-14 05:25:37 | Nunavut, Canada | ||
352250 | 352250 | 2021-03-11 | India | Lakshadweep | 569 | 1 | 374 | 194 | 13.6999972 | 72.18333259999999 | 2021-03-12 05:26:50 | Lakshadweep, India | ||
471452 | 471452 | 2021-02-19 | Japan | Tokushima | 446 | 16 | 374 | 56 | 33.919178 | 134.242091 | 2021-02-20 05:22:51 | Tokushima, Japan | ||
2466623 | 2466623 | 2021-01-22 | China | Liaoning | 396 | 2 | 374 | 20 | 41.2956 | 122.6085 | 2021-01-23 05:22:03 | Liaoning, China | ||
189831 | 189831 | 2021-01-11 | Cambodia | 392 | 0 | 374 | 18 | 11.55 | 104.9167 | 2021-01-12 05:22:15 | Cambodia | |||
2625634 | 2625634 | 2021-01-10 | Cambodia | 391 | 0 | 374 | 17 | 11.55 | 104.9167 | 2021-01-11 05:21:50 | Cambodia | |||
3034073 | 3034073 | 2021-01-05 | Canada | Newfoundland and Labrador | 392 | 4 | 374 | 14 | 53.1355 | -57.6604 | 2021-01-06 05:22:16 | Newfoundland and Labrador, Canada | ||
1061618 | 1061618 | 2021-01-04 | Canada | Newfoundland and Labrador | 391 | 4 | 374 | 13 | 53.1355 | -57.6604 | 2021-01-05 05:21:49 | Newfoundland and Labrador, Canada | ||
3230221 | 3230221 | 2021-01-03 | Canada | Newfoundland and Labrador | 390 | 4 | 374 | 12 | 53.1355 | -57.6604 | 2021-01-04 05:22:02 | Newfoundland and Labrador, Canada | ||
1822463 | 1822463 | 2020-12-08 | Malaysia | Melaka | 394 | 6 | 374 | 14 | 2.1896 | 102.2501 | 2020-12-09 05:28:01 | Melaka, Malaysia | ||
2351099 | 2351099 | 2020-12-07 | Malaysia | Melaka | 394 | 6 | 374 | 14 | 2.1896 | 102.2501 | 2020-12-08 05:27:42 | Melaka, Malaysia | ||
1583934 | 1583934 | 2020-11-30 | Canada | New Brunswick | 501 | 7 | 374 | 120 | 46.5653 | -66.4619 | 2020-12-01 05:26:18 | New Brunswick, Canada | ||
923706 | 923706 | 2020-11-26 | Japan | Miyazaki | 457 | 1 | 374 | 82 | 32.193203999999994 | 131.299374 | 2020-11-27 05:26:53 | Miyazaki, Japan | ||
1972611 | 1972611 | 2020-11-25 | Japan | Miyazaki | 448 | 1 | 374 | 73 | 32.193203999999994 | 131.299374 | 2020-11-26 05:27:44 | Miyazaki, Japan | ||
3440822 | 3440822 | 2020-11-11 | Japan | Fukushima | 419 | 6 | 374 | 39 | 37.378867 | 140.223295 | 2020-11-12 05:25:55 | Fukushima, Japan | ||
272162 | 272162 | 2020-11-10 | Japan | Fukushima | 418 | 6 | 374 | 38 | 37.378867 | 140.223295 | 2020-11-11 05:25:30 | Fukushima, Japan | ||
1988639 | 1988639 | 2020-11-09 | Japan | Fukushima | 418 | 6 | 374 | 38 | 37.378867 | 140.223295 | 2020-11-10 05:40:07 | Fukushima, Japan | ||
2295114 | 2295114 | 2020-10-12 | Malaysia | Pahang | 388 | 7 | 374 | 7 | 3.8126 | 103.3256 | 2020-10-13 04:24:02 | Pahang, Malaysia | ||
2581805 | 2581805 | 2020-09-27 | China | Shaanxi | 403 | 3 | 374 | 26 | 35.1917 | 108.8701 | 2020-09-28 04:23:00 | Shaanxi, China | ||
2613857 | 2613857 | 2020-09-26 | China | Shaanxi | 403 | 3 | 374 | 26 | 35.1917 | 108.8701 | 2020-09-27 04:23:00 | Shaanxi, China | ||
2812572 | 2812572 | 2020-09-25 | China | Shaanxi | 403 | 3 | 374 | 26 | 35.1917 | 108.8701 | 2020-09-26 04:23:00 | Shaanxi, China | ||
2605849 | 2605849 | 2020-09-24 | China | Shaanxi | 402 | 3 | 374 | 25 | 35.1917 | 108.8701 | 2020-09-25 04:23:00 | Shaanxi, China | ||
2653592 | 2653592 | 2020-09-23 | China | Shaanxi | 402 | 3 | 374 | 25 | 35.1917 | 108.8701 | 2020-09-24 04:23:00 | Shaanxi, China | ||
2454814 | 2454814 | 2020-09-19 | Japan | Toyama | 410 | 25 | 374 | 11 | 36.637464 | 137.269346 | 2020-09-20 04:22:00 | Toyama, Japan | ||
2454534 | 2454534 | 2020-09-19 | Burundi | 473 | 1 | 374 | 98 | -3.3731 | 29.9189 | 2020-09-20 04:22:00 | Burundi | |||
2848603 | 2848603 | 2020-09-18 | Burundi | 473 | 1 | 374 | 98 | -3.3731 | 29.9189 | 2020-09-19 04:22:00 | Burundi | |||
1121352 | 1121352 | 2020-09-17 | Burundi | 473 | 1 | 374 | 98 | -3.3731 | 29.9189 | 2020-09-18 05:05:00 | Burundi | |||
666300 | 666300 | 2020-09-16 | Japan | Mie | 466 | 5 | 374 | 87 | 34.508018 | 136.376013 | 2020-09-17 04:22:00 | Mie, Japan | ||
666041 | 666041 | 2020-09-16 | Burundi | 472 | 1 | 374 | 97 | -3.3731 | 29.9189 | 2020-09-17 04:22:00 | Burundi | |||
2728766 | 2728766 | 2020-09-15 | Burundi | 472 | 1 | 374 | 97 | -3.3731 | 29.9189 | 2020-09-16 04:22:53 | Burundi | |||
344038 | 344038 | 2020-09-14 | Burundi | 472 | 1 | 374 | 97 | -3.3731 | 29.9189 | 2020-09-15 03:22:50 | Burundi | |||
2868477 | 2868477 | 2020-09-13 | Burundi | 472 | 1 | 374 | 97 | -3.3731 | 29.9189 | 2020-09-14 04:26:00 | Burundi | |||
546516 | 546516 | 2020-09-12 | Burundi | 471 | 1 | 374 | 96 | -3.3731 | 29.9189 | 2020-09-13 04:30:52 | Burundi | |||
1444345 | 1444345 | 2020-09-11 | Burundi | 469 | 1 | 374 | 94 | -3.3731 | 29.9189 | 2020-09-12 04:25:05 | Burundi | |||
1172987 | 1172987 | 2020-09-10 | China | Fujian | 387 | 1 | 374 | 12 | 26.0789 | 117.9874 | 2020-09-11 04:46:23 | Fujian, China | ||
1172946 | 1172946 | 2020-09-10 | Burundi | 469 | 1 | 374 | 94 | -3.3731 | 29.9189 | 2020-09-11 04:46:23 | Burundi | |||
2171311 | 2171311 | 2020-09-09 | Burundi | 466 | 1 | 374 | 91 | -3.3731 | 29.9189 | 2020-09-10 04:29:01 | Burundi | |||
1243520 | 1243520 | 2020-09-08 | Burundi | 466 | 1 | 374 | 91 | -3.3731 | 29.9189 | 2020-09-09 04:28:48 | Burundi | |||
427099 | 427099 | 2020-09-07 | Burundi | 466 | 1 | 374 | 91 | -3.3731 | 29.9189 | 2020-09-08 04:28:25 | Burundi | |||
1105429 | 1105429 | 2020-09-02 | Denmark | Faroe Islands | 411 | 0 | 374 | 37 | 61.8926 | -6.9118 | 2020-09-03 04:28:22 | Faroe Islands, Denmark | ||
2059758 | 2059758 | 2020-09-01 | Denmark | Faroe Islands | 411 | 0 | 374 | 37 | 61.8926 | -6.9118 | 2020-09-02 04:28:25 | Faroe Islands, Denmark | ||
193943 | 193943 | 2020-08-31 | Denmark | Faroe Islands | 411 | 0 | 374 | 37 | 61.8926 | -6.9118 | 2020-09-01 04:28:31 | Faroe Islands, Denmark | ||
1479594 | 1479594 | 2020-08-21 | Japan | Shizuoka | 430 | 1 | 374 | 55 | 34.916975 | 138.40778400000002 | 2020-08-22 04:27:49 | Shizuoka, Japan | ||
98120 | 98120 | 2020-08-04 | Italy | Basilicata | 453 | 28 | 374 | 51 | 40.63947052 | 15.80514834 | 2020-08-05 04:34:43 | Basilicata, Italy | ||
2740639 | 2740639 | 2020-08-03 | Vietnam | 652 | 7 | 374 | 271 | 14.058324 | 108.277199 | 2020-08-04 04:41:59 | Vietnam | |||
2740003 | 2740003 | 2020-08-03 | Italy | Basilicata | 453 | 28 | 374 | 51 | 40.63947052 | 15.80514834 | 2020-08-04 04:41:59 | Basilicata, Italy | ||
2807755 | 2807755 | 2020-08-02 | Italy | Basilicata | 453 | 28 | 374 | 51 | 40.63947052 | 15.80514834 | 2020-08-03 04:34:35 | Basilicata, Italy | ||
753323 | 753323 | 2020-08-01 | Italy | Basilicata | 452 | 28 | 374 | 50 | 40.63947052 | 15.80514834 | 2020-08-02 04:34:47 | Basilicata, Italy | ||
3264488 | 3264488 | 2020-07-31 | Italy | Basilicata | 452 | 28 | 374 | 50 | 40.63947052 | 15.80514834 | 2020-08-01 04:36:27 | Basilicata, Italy | ||
1928195 | 1928195 | 2020-07-30 | Italy | Basilicata | 449 | 28 | 374 | 47 | 40.63947052 | 15.80514834 | 2020-07-31 04:35:18 | Basilicata, Italy | ||
2958363 | 2958363 | 2020-07-29 | Italy | Basilicata | 449 | 28 | 374 | 47 | 40.63947052 | 15.80514834 | 2020-07-30 04:35:05 | Basilicata, Italy | ||
3184979 | 3184979 | 2020-07-28 | Italy | Basilicata | 449 | 28 | 374 | 47 | 40.63947052 | 15.80514834 | 2020-07-29 04:35:11 | Basilicata, Italy | ||
177694 | 177694 | 2020-07-27 | Malaysia | Sabah | 390 | 7 | 374 | 9 | 5.9788 | 116.0753 | 2020-07-28 04:58:43 | Sabah, Malaysia | ||
177031 | 177031 | 2020-07-27 | Italy | Basilicata | 449 | 28 | 374 | 47 | 40.63947052 | 15.80514834 | 2020-07-28 04:58:43 | Basilicata, Italy | ||
442344 | 442344 | 2020-07-26 | Italy | Basilicata | 448 | 28 | 374 | 46 | 40.63947052 | 15.80514834 | 2020-07-27 04:35:02 | Basilicata, Italy | ||
1502588 | 1502588 | 2020-07-25 | Italy | Basilicata | 448 | 28 | 374 | 46 | 40.63947052 | 15.80514834 | 2020-07-26 04:35:00 | Basilicata, Italy | ||
2158535 | 2158535 | 2020-07-14 | Italy | Basilicata | 406 | 27 | 374 | 5 | 40.63947052 | 15.80514834 | 2020-07-15 04:34:39 | Basilicata, Italy | ||
3491176 | 3491176 | 2020-07-13 | Italy | Basilicata | 406 | 27 | 374 | 5 | 40.63947052 | 15.80514834 | 2020-07-14 04:34:46 | Basilicata, Italy | ||
3737438 | 3737438 | 2020-07-12 | Italy | Basilicata | 406 | 27 | 374 | 5 | 40.63947052 | 15.80514834 | 2020-07-13 04:43:04 | Basilicata, Italy | ||
3435833 | 3435833 | 2020-07-11 | Italy | Basilicata | 406 | 27 | 374 | 5 | 40.63947052 | 15.80514834 | 2020-07-12 04:34:30 | Basilicata, Italy | ||
3682515 | 3682515 | 2020-06-18 | Ukraine | Cherkasy Oblast | 568 | 21 | 374 | 173 | 49.4444 | 32.0598 | 2020-06-19 04:33:17 | Cherkasy Oblast, Ukraine | ||
2863893 | 2863893 | 2020-06-10 | Russia | Kamchatka Krai | 1255 | 10 | 374 | 871 | 57.191488199999995 | 160.03838190000005 | 2020-06-11 03:33:41 | Kamchatka Krai, Russia | ||
3847306 | 3847306 | 2020-05-13 | El Salvador | 1037 | 20 | 374 | 643 | 13.7942 | -88.8965 | 2020-05-14 03:32:28 | El Salvador | |||
3502942 | 3502942 | 2020-04-25 | North Macedonia | 1367 | 59 | 374 | 934 | 41.6086 | 21.7453 | 2020-04-26 02:30:31 | North Macedonia | |||
589232 | 589232 | 2020-04-05 | Romania | 3864 | 151 | 374 | 3339 | 45.9432 | 24.9668 | 2020-04-05 23:06:26 | Romania |
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]);