johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
99 rows where recovered = 259 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2183584 | 2183584 | 2021-02-26 | Japan | Akita | 269 | 6 | 259 | 4 | 39.748679 | 140.408228 | 2021-02-27 05:22:28 | Akita, Japan | ||
774364 | 774364 | 2021-01-12 | Japan | Kagawa | 447 | 4 | 259 | 184 | 34.217292 | 133.969047 | 2021-01-13 05:22:15 | Kagawa, Japan | ||
1065535 | 1065535 | 2021-01-04 | Malaysia | W.P. Putrajaya | 320 | 3 | 259 | 58 | 2.9264 | 101.6964 | 2021-01-05 05:21:49 | W.P. Putrajaya, Malaysia | ||
766094 | 766094 | 2020-12-29 | Canada | Nunavut | 266 | 1 | 259 | 6 | 70.2998 | -83.1076 | 2020-12-30 05:22:34 | Nunavut, Canada | ||
2975232 | 2975232 | 2020-12-09 | Japan | Ehime | 353 | 7 | 259 | 87 | 33.624835 | 132.856842 | 2020-12-10 05:26:19 | Ehime, Japan | ||
3859859 | 3859859 | 2020-12-04 | Japan | Niigata | 350 | 0 | 259 | 91 | 37.521819 | 138.918647 | 2020-12-05 05:27:36 | Niigata, Japan | ||
2537201 | 2537201 | 2020-12-01 | China | Guangxi | 263 | 2 | 259 | 2 | 23.8298 | 108.7881 | 2020-12-02 05:27:41 | Guangxi, China | ||
1583970 | 1583970 | 2020-11-30 | China | Guangxi | 263 | 2 | 259 | 2 | 23.8298 | 108.7881 | 2020-12-01 05:26:18 | Guangxi, China | ||
821762 | 821762 | 2020-11-19 | Russia | Chukotka Autonomous Okrug | 313 | 3 | 259 | 51 | 66.0006475 | 169.4900869 | 2020-11-20 05:26:28 | Chukotka Autonomous Okrug, Russia | ||
3169667 | 3169667 | 2020-11-16 | Japan | Okayama | 399 | 10 | 259 | 130 | 34.89246 | 133.826252 | 2020-11-17 05:25:54 | Okayama, Japan | ||
2880235 | 2880235 | 2020-11-15 | Japan | Okayama | 396 | 10 | 259 | 127 | 34.89246 | 133.826252 | 2020-11-16 05:25:57 | Okayama, Japan | ||
2915213 | 2915213 | 2020-11-14 | Japan | Okayama | 379 | 10 | 259 | 110 | 34.89246 | 133.826252 | 2020-11-15 05:26:53 | Okayama, Japan | ||
2785035 | 2785035 | 2020-11-13 | Japan | Okayama | 367 | 10 | 259 | 98 | 34.89246 | 133.826252 | 2020-11-14 05:25:37 | Okayama, Japan | ||
891948 | 891948 | 2020-11-05 | China | Tianjin | 275 | 3 | 259 | 13 | 39.3054 | 117.323 | 2020-11-06 05:24:55 | Tianjin, China | ||
762321 | 762321 | 2020-10-18 | Japan | Fukushima | 362 | 6 | 259 | 97 | 37.378867 | 140.223295 | 2020-10-19 04:24:16 | Fukushima, Japan | ||
1026359 | 1026359 | 2020-10-17 | Japan | Fukushima | 359 | 6 | 259 | 94 | 37.378867 | 140.223295 | 2020-10-18 04:24:25 | Fukushima, Japan | ||
1045631 | 1045631 | 2020-09-30 | China | Inner Mongolia | 266 | 1 | 259 | 6 | 44.0935 | 113.9448 | 2020-10-01 04:23:42 | Inner Mongolia, China | ||
966712 | 966712 | 2020-09-29 | China | Inner Mongolia | 266 | 1 | 259 | 6 | 44.0935 | 113.9448 | 2020-09-30 04:23:33 | Inner Mongolia, China | ||
1515209 | 1515209 | 2020-09-28 | China | Inner Mongolia | 266 | 1 | 259 | 6 | 44.0935 | 113.9448 | 2020-09-29 04:23:42 | Inner Mongolia, China | ||
2581797 | 2581797 | 2020-09-27 | China | Inner Mongolia | 266 | 1 | 259 | 6 | 44.0935 | 113.9448 | 2020-09-28 04:23:00 | Inner Mongolia, China | ||
2613849 | 2613849 | 2020-09-26 | China | Inner Mongolia | 263 | 1 | 259 | 3 | 44.0935 | 113.9448 | 2020-09-27 04:23:00 | Inner Mongolia, China | ||
2812564 | 2812564 | 2020-09-25 | China | Inner Mongolia | 263 | 1 | 259 | 3 | 44.0935 | 113.9448 | 2020-09-26 04:23:00 | Inner Mongolia, China | ||
2605841 | 2605841 | 2020-09-24 | China | Inner Mongolia | 263 | 1 | 259 | 3 | 44.0935 | 113.9448 | 2020-09-25 04:23:00 | Inner Mongolia, China | ||
2653584 | 2653584 | 2020-09-23 | China | Inner Mongolia | 263 | 1 | 259 | 3 | 44.0935 | 113.9448 | 2020-09-24 04:23:00 | Inner Mongolia, China | ||
3316033 | 3316033 | 2020-09-22 | China | Inner Mongolia | 263 | 1 | 259 | 3 | 44.0935 | 113.9448 | 2020-09-23 04:23:00 | Inner Mongolia, China | ||
2836632 | 2836632 | 2020-09-21 | China | Inner Mongolia | 263 | 1 | 259 | 3 | 44.0935 | 113.9448 | 2020-09-22 04:23:00 | Inner Mongolia, China | ||
3093237 | 3093237 | 2020-09-20 | China | Inner Mongolia | 263 | 1 | 259 | 3 | 44.0935 | 113.9448 | 2020-09-21 04:23:00 | Inner Mongolia, China | ||
2454587 | 2454587 | 2020-09-19 | China | Inner Mongolia | 261 | 1 | 259 | 1 | 44.0935 | 113.9448 | 2020-09-20 04:22:00 | Inner Mongolia, China | ||
2848656 | 2848656 | 2020-09-18 | China | Inner Mongolia | 261 | 1 | 259 | 1 | 44.0935 | 113.9448 | 2020-09-19 04:22:00 | Inner Mongolia, China | ||
1121405 | 1121405 | 2020-09-17 | China | Inner Mongolia | 261 | 1 | 259 | 1 | 44.0935 | 113.9448 | 2020-09-18 05:05:00 | Inner Mongolia, China | ||
666094 | 666094 | 2020-09-16 | China | Inner Mongolia | 261 | 1 | 259 | 1 | 44.0935 | 113.9448 | 2020-09-17 04:22:00 | Inner Mongolia, China | ||
2728819 | 2728819 | 2020-09-15 | China | Inner Mongolia | 261 | 1 | 259 | 1 | 44.0935 | 113.9448 | 2020-09-16 04:22:53 | Inner Mongolia, China | ||
344091 | 344091 | 2020-09-14 | China | Inner Mongolia | 261 | 1 | 259 | 1 | 44.0935 | 113.9448 | 2020-09-15 03:22:50 | Inner Mongolia, China | ||
2868530 | 2868530 | 2020-09-13 | China | Inner Mongolia | 261 | 1 | 259 | 1 | 44.0935 | 113.9448 | 2020-09-14 04:26:00 | Inner Mongolia, China | ||
546569 | 546569 | 2020-09-12 | China | Inner Mongolia | 261 | 1 | 259 | 1 | 44.0935 | 113.9448 | 2020-09-13 04:30:52 | Inner Mongolia, China | ||
1444398 | 1444398 | 2020-09-11 | China | Inner Mongolia | 261 | 1 | 259 | 1 | 44.0935 | 113.9448 | 2020-09-12 04:25:05 | Inner Mongolia, China | ||
1172999 | 1172999 | 2020-09-10 | China | Inner Mongolia | 261 | 1 | 259 | 1 | 44.0935 | 113.9448 | 2020-09-11 04:46:23 | Inner Mongolia, China | ||
2171364 | 2171364 | 2020-09-09 | China | Inner Mongolia | 261 | 1 | 259 | 1 | 44.0935 | 113.9448 | 2020-09-10 04:29:01 | Inner Mongolia, China | ||
1243573 | 1243573 | 2020-09-08 | China | Inner Mongolia | 261 | 1 | 259 | 1 | 44.0935 | 113.9448 | 2020-09-09 04:28:48 | Inner Mongolia, China | ||
427152 | 427152 | 2020-09-07 | China | Inner Mongolia | 261 | 1 | 259 | 1 | 44.0935 | 113.9448 | 2020-09-08 04:28:25 | Inner Mongolia, China | ||
3161441 | 3161441 | 2020-09-06 | China | Liaoning | 263 | 2 | 259 | 2 | 41.2956 | 122.6085 | 2020-09-07 04:28:30 | Liaoning, China | ||
3161437 | 3161437 | 2020-09-06 | China | Inner Mongolia | 261 | 1 | 259 | 1 | 44.0935 | 113.9448 | 2020-09-07 04:28:30 | Inner Mongolia, China | ||
813396 | 813396 | 2020-09-05 | China | Liaoning | 263 | 2 | 259 | 2 | 41.2956 | 122.6085 | 2020-09-06 04:28:33 | Liaoning, China | ||
813392 | 813392 | 2020-09-05 | China | Inner Mongolia | 261 | 1 | 259 | 1 | 44.0935 | 113.9448 | 2020-09-06 04:28:33 | Inner Mongolia, China | ||
2661596 | 2661596 | 2020-09-04 | China | Liaoning | 263 | 2 | 259 | 2 | 41.2956 | 122.6085 | 2020-09-05 04:28:19 | Liaoning, China | ||
2661592 | 2661592 | 2020-09-04 | China | Inner Mongolia | 261 | 1 | 259 | 1 | 44.0935 | 113.9448 | 2020-09-05 04:28:19 | Inner Mongolia, China | ||
1354136 | 1354136 | 2020-09-03 | China | Liaoning | 263 | 2 | 259 | 2 | 41.2956 | 122.6085 | 2020-09-04 04:28:26 | Liaoning, China | ||
1354132 | 1354132 | 2020-09-03 | China | Inner Mongolia | 261 | 1 | 259 | 1 | 44.0935 | 113.9448 | 2020-09-04 04:28:26 | Inner Mongolia, China | ||
1105373 | 1105373 | 2020-09-02 | China | Liaoning | 263 | 2 | 259 | 2 | 41.2956 | 122.6085 | 2020-09-03 04:28:22 | Liaoning, China | ||
1105369 | 1105369 | 2020-09-02 | China | Inner Mongolia | 261 | 1 | 259 | 1 | 44.0935 | 113.9448 | 2020-09-03 04:28:22 | Inner Mongolia, China | ||
2059702 | 2059702 | 2020-09-01 | China | Liaoning | 262 | 2 | 259 | 1 | 41.2956 | 122.6085 | 2020-09-02 04:28:25 | Liaoning, China | ||
193887 | 193887 | 2020-08-31 | China | Liaoning | 262 | 2 | 259 | 1 | 41.2956 | 122.6085 | 2020-09-01 04:28:31 | Liaoning, China | ||
3931846 | 3931846 | 2020-08-30 | China | Liaoning | 262 | 2 | 259 | 1 | 41.2956 | 122.6085 | 2020-08-31 04:28:27 | Liaoning, China | ||
609508 | 609508 | 2020-08-29 | China | Liaoning | 262 | 2 | 259 | 1 | 41.2956 | 122.6085 | 2020-08-30 04:28:22 | Liaoning, China | ||
3562607 | 3562607 | 2020-08-25 | Japan | Tochigi | 289 | 1 | 259 | 29 | 36.689912 | 139.819213 | 2020-08-26 04:28:11 | Tochigi, Japan | ||
2991315 | 2991315 | 2020-08-24 | Japan | Toyama | 342 | 23 | 259 | 60 | 36.637464 | 137.26934599999998 | 2020-08-25 04:28:02 | Toyama, Japan | ||
2303115 | 2303115 | 2020-08-22 | Malaysia | Perak | 268 | 6 | 259 | 3 | 4.5921 | 101.0901 | 2020-08-23 04:27:48 | Perak, Malaysia | ||
1483221 | 1483221 | 2020-08-21 | Malaysia | Perak | 268 | 6 | 259 | 3 | 4.5921 | 101.0901 | 2020-08-22 04:27:49 | Perak, Malaysia | ||
3487970 | 3487970 | 2020-08-20 | Malaysia | Perak | 268 | 6 | 259 | 3 | 4.5921 | 101.0901 | 2020-08-21 04:27:41 | Perak, Malaysia | ||
209919 | 209919 | 2020-08-19 | Malaysia | Perak | 268 | 6 | 259 | 3 | 4.5921 | 101.0901 | 2020-08-20 04:27:43 | Perak, Malaysia | ||
3181671 | 3181671 | 2020-08-18 | Malaysia | Perak | 268 | 6 | 259 | 3 | 4.5921 | 101.0901 | 2020-08-19 04:27:00 | Perak, Malaysia | ||
2740261 | 2740261 | 2020-08-03 | Canada | Newfoundland and Labrador | 266 | 3 | 259 | 4 | 53.1355 | -57.6604 | 2020-08-04 04:41:59 | Newfoundland and Labrador, Canada | ||
2808013 | 2808013 | 2020-08-02 | Canada | Newfoundland and Labrador | 266 | 3 | 259 | 4 | 53.1355 | -57.6604 | 2020-08-03 04:34:35 | Newfoundland and Labrador, Canada | ||
753581 | 753581 | 2020-08-01 | Canada | Newfoundland and Labrador | 266 | 3 | 259 | 4 | 53.1355 | -57.6604 | 2020-08-02 04:34:47 | Newfoundland and Labrador, Canada | ||
3264746 | 3264746 | 2020-07-31 | Canada | Newfoundland and Labrador | 266 | 3 | 259 | 4 | 53.1355 | -57.6604 | 2020-08-01 04:36:27 | Newfoundland and Labrador, Canada | ||
1928453 | 1928453 | 2020-07-30 | Canada | Newfoundland and Labrador | 266 | 3 | 259 | 4 | 53.1355 | -57.6604 | 2020-07-31 04:35:18 | Newfoundland and Labrador, Canada | ||
2958621 | 2958621 | 2020-07-29 | Canada | Newfoundland and Labrador | 266 | 3 | 259 | 4 | 53.1355 | -57.6604 | 2020-07-30 04:35:05 | Newfoundland and Labrador, Canada | ||
3185237 | 3185237 | 2020-07-28 | Canada | Newfoundland and Labrador | 266 | 3 | 259 | 4 | 53.1355 | -57.6604 | 2020-07-29 04:35:11 | Newfoundland and Labrador, Canada | ||
177288 | 177288 | 2020-07-27 | Canada | Newfoundland and Labrador | 266 | 3 | 259 | 4 | 53.1355 | -57.6604 | 2020-07-28 04:58:43 | Newfoundland and Labrador, Canada | ||
442601 | 442601 | 2020-07-26 | Canada | Newfoundland and Labrador | 266 | 3 | 259 | 4 | 53.1355 | -57.6604 | 2020-07-27 04:35:02 | Newfoundland and Labrador, Canada | ||
1502845 | 1502845 | 2020-07-25 | Canada | Newfoundland and Labrador | 265 | 3 | 259 | 3 | 53.1355 | -57.6604 | 2020-07-26 04:35:00 | Newfoundland and Labrador, Canada | ||
2563815 | 2563815 | 2020-07-24 | Canada | Newfoundland and Labrador | 265 | 3 | 259 | 3 | 53.1355 | -57.6604 | 2020-07-25 04:47:39 | Newfoundland and Labrador, Canada | ||
62029 | 62029 | 2020-07-23 | Canada | Newfoundland and Labrador | 264 | 3 | 259 | 2 | 53.1355 | -57.6604 | 2020-07-24 05:30:40 | Newfoundland and Labrador, Canada | ||
844835 | 844835 | 2020-07-22 | Canada | Newfoundland and Labrador | 264 | 3 | 259 | 2 | 53.1355 | -57.6604 | 2020-07-23 05:15:04 | Newfoundland and Labrador, Canada | ||
1707574 | 1707574 | 2020-07-21 | Canada | Newfoundland and Labrador | 263 | 3 | 259 | 1 | 53.1355 | -57.6604 | 2020-07-22 04:34:42 | Newfoundland and Labrador, Canada | ||
327065 | 327065 | 2020-07-20 | Canada | Newfoundland and Labrador | 262 | 3 | 259 | 0 | 53.1355 | -57.6604 | 2020-07-21 04:38:46 | Newfoundland and Labrador, Canada | ||
121970 | 121970 | 2020-07-19 | Canada | Newfoundland and Labrador | 262 | 3 | 259 | 0 | 53.1355 | -57.6604 | 2020-07-20 05:34:40 | Newfoundland and Labrador, Canada | ||
3205359 | 3205359 | 2020-07-18 | Canada | Newfoundland and Labrador | 262 | 3 | 259 | 0 | 53.1355 | -57.6604 | 2020-07-19 04:34:58 | Newfoundland and Labrador, Canada | ||
2708660 | 2708660 | 2020-07-17 | Canada | Newfoundland and Labrador | 262 | 3 | 259 | 0 | 53.1355 | -57.6604 | 2020-07-18 04:34:45 | Newfoundland and Labrador, Canada | ||
3237342 | 3237342 | 2020-07-10 | Colombia | Boyaca | 460 | 18 | 259 | 183 | 5.4545 | -73.362 | 2020-07-11 04:34:26 | Boyaca, Colombia | ||
2701093 | 2701093 | 2020-06-24 | Malawi | 941 | 11 | 259 | 671 | -13.254307999999998 | 34.301525 | 2020-06-25 05:26:54 | Malawi | |||
1195973 | 1195973 | 2020-06-17 | Ukraine | Poltava Oblast | 281 | 13 | 259 | 9 | 49.5883 | 34.5514 | 2020-06-18 04:33:18 | Poltava Oblast, Ukraine | ||
2386953 | 2386953 | 2020-06-16 | Eswatini | 520 | 4 | 259 | 257 | -26.5225 | 31.4659 | 2020-06-17 04:33:21 | Eswatini | |||
3866748 | 3866748 | 2020-06-03 | Ukraine | Khmelnytskyi Oblast | 469 | 11 | 259 | 199 | 49.423 | 26.9871 | 2020-06-04 02:33:14 | Khmelnytskyi Oblast, Ukraine | ||
3866660 | 3866660 | 2020-06-03 | Ukraine | Crimea Republic* | 392 | 4 | 259 | 129 | 45.2835 | 34.2008 | 2020-06-04 02:33:14 | Crimea Republic*, Ukraine | ||
2555784 | 2555784 | 2020-06-02 | Russia | Kemerovo Oblast | 589 | 7 | 259 | 323 | 54.53357809999999 | 87.342861 | 2020-06-03 02:33:13 | Kemerovo Oblast, Russia | ||
805565 | 805565 | 2020-06-01 | Ukraine | Volyn Oblast | 932 | 26 | 259 | 647 | 50.7472 | 25.3254 | 2020-06-02 02:33:08 | Volyn Oblast, Ukraine | ||
3261169 | 3261169 | 2020-05-18 | Malaysia | Pahang | 339 | 7 | 259 | 73 | 3.8126 | 103.3256 | 2020-05-19 02:32:18 | Pahang, Malaysia | ||
2581612 | 2581612 | 2020-05-12 | Slovenia | 1461 | 102 | 259 | 1100 | 46.1512 | 14.9955 | 2020-05-13 03:32:26 | Slovenia | |||
2581549 | 2581549 | 2020-05-12 | Kenya | 715 | 36 | 259 | 420 | -0.0236 | 37.9062 | 2020-05-13 03:32:26 | Kenya | |||
3084822 | 3084822 | 2020-05-04 | Estonia | 1703 | 55 | 259 | 1389 | 58.5953 | 25.0136 | 2020-05-05 02:32:34 | Estonia | |||
2278823 | 2278823 | 2020-05-03 | Malaysia | Sabah | 317 | 4 | 259 | 54 | 5.9788 | 116.0753 | 2020-05-04 02:32:28 | Sabah, Malaysia | ||
2278681 | 2278681 | 2020-05-03 | Estonia | 1700 | 55 | 259 | 1386 | 58.5953 | 25.0136 | 2020-05-04 02:32:28 | Estonia | |||
2043499 | 2043499 | 2020-05-02 | Malaysia | Sabah | 316 | 4 | 259 | 53 | 5.9788 | 116.0753 | 2020-05-03 02:32:28 | Sabah, Malaysia | ||
1184393 | 1184393 | 2020-05-01 | Malaysia | Sabah | 316 | 4 | 259 | 53 | 5.9788 | 116.0753 | 2020-05-02 02:32:27 | Sabah, Malaysia | ||
934339 | 934339 | 2020-04-16 | Jordan | 402 | 7 | 259 | 136 | 31.24 | 36.51 | 2020-04-16 23:30:31 | Jordan | |||
3627535 | 3627535 | 2020-04-06 | Pakistan | 3766 | 53 | 259 | 3454 | 30.3753 | 69.3451 | 4/6/20 23:21 | Pakistan | |||
3627460 | 3627460 | 2020-04-06 | Egypt | 1322 | 85 | 259 | 978 | 26.820553 | 30.802498 | 4/6/20 23:21 | Egypt | |||
1750820 | 1750820 | 2020-04-04 | Iraq | 878 | 56 | 259 | 563 | 33.223191 | 43.679291 | 4/4/20 23:34 | Iraq |
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]);