johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
42 rows where recovered = 589 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3744761 | 3744761 | 2021-07-12 | Malaysia | Perlis | 608 | 8 | 589 | 11 | 6.4449 | 100.2048 | 2021-07-13 04:21:18 | Perlis, Malaysia | ||
3663274 | 3663274 | 2021-07-11 | Malaysia | Perlis | 608 | 8 | 589 | 11 | 6.4449 | 100.2048 | 2021-07-12 04:21:34 | Perlis, Malaysia | ||
2422690 | 2422690 | 2021-06-23 | China | Chongqing | 598 | 6 | 589 | 3 | 30.0572 | 107.874 | 2021-06-24 04:21:55 | Chongqing, China | ||
562767 | 562767 | 2021-06-22 | China | Chongqing | 598 | 6 | 589 | 3 | 30.0572 | 107.874 | 2021-06-23 04:21:46 | Chongqing, China | ||
3358469 | 3358469 | 2021-06-21 | China | Chongqing | 598 | 6 | 589 | 3 | 30.0572 | 107.874 | 2021-06-22 04:21:34 | Chongqing, China | ||
2884168 | 2884168 | 2021-06-20 | China | Chongqing | 598 | 6 | 589 | 3 | 30.0572 | 107.874 | 2021-06-21 04:21:41 | Chongqing, China | ||
107251 | 107251 | 2021-06-19 | China | Chongqing | 598 | 6 | 589 | 3 | 30.0572 | 107.874 | 2021-06-20 04:21:48 | Chongqing, China | ||
1125394 | 1125394 | 2021-06-18 | China | Chongqing | 598 | 6 | 589 | 3 | 30.0572 | 107.874 | 2021-06-19 04:22:33 | Chongqing, China | ||
2910972 | 2910972 | 2021-06-17 | China | Chongqing | 598 | 6 | 589 | 3 | 30.0572 | 107.874 | 2021-06-18 04:22:16 | Chongqing, China | ||
3030090 | 3030090 | 2021-06-16 | China | Chongqing | 598 | 6 | 589 | 3 | 30.0572 | 107.874 | 2021-06-17 04:22:36 | Chongqing, China | ||
2339196 | 2339196 | 2021-06-15 | China | Chongqing | 598 | 6 | 589 | 3 | 30.0572 | 107.874 | 2021-06-16 04:22:32 | Chongqing, China | ||
1563892 | 1563892 | 2021-06-14 | China | Chongqing | 598 | 6 | 589 | 3 | 30.0572 | 107.874 | 2021-06-15 04:22:22 | Chongqing, China | ||
3381175 | 3381175 | 2021-06-13 | China | Chongqing | 598 | 6 | 589 | 3 | 30.0572 | 107.874 | 2021-06-14 04:22:46 | Chongqing, China | ||
1708112 | 1708112 | 2021-06-02 | China | Fujian | 625 | 1 | 589 | 35 | 26.0789 | 117.9874 | 2021-06-03 04:23:32 | Fujian, China | ||
1952514 | 1952514 | 2021-05-21 | Japan | Akita | 733 | 11 | 589 | 133 | 39.748679 | 140.408228 | 2021-05-22 04:20:45 | Akita, Japan | ||
2390592 | 2390592 | 2021-05-18 | China | Shaanxi | 606 | 3 | 589 | 14 | 35.1917 | 108.8701 | 2021-05-19 04:20:42 | Shaanxi, China | ||
237269 | 237269 | 2021-01-18 | Japan | Niigata | 766 | 5 | 589 | 172 | 37.521819 | 138.918647 | 2021-01-19 05:22:15 | Niigata, Japan | ||
3651596 | 3651596 | 2020-10-24 | Japan | Nara | 617 | 9 | 589 | 19 | 34.317451 | 135.871644 | 2020-10-25 04:24:36 | Nara, Japan | ||
1053851 | 1053851 | 2020-10-23 | Japan | Nara | 616 | 9 | 589 | 18 | 34.317451 | 135.871644 | 2020-10-24 04:24:46 | Nara, Japan | ||
3931985 | 3931985 | 2020-08-30 | India | Mizoram | 1011 | 0 | 589 | 422 | 23.309381 | 92.83822 | 2020-08-31 04:28:27 | Mizoram, India | ||
3612065 | 3612065 | 2020-08-06 | Colombia | Boyaca | 1376 | 33 | 589 | 754 | 5.4545 | -73.362 | 2020-08-07 04:35:11 | Boyaca, Colombia | ||
367717 | 367717 | 2020-07-16 | Congo (Brazzaville) | 2358 | 48 | 589 | 1721 | -0.228 | 15.8277 | 2020-07-17 04:34:50 | Congo (Brazzaville) | |||
2748385 | 2748385 | 2020-07-15 | Congo (Brazzaville) | 2222 | 47 | 589 | 1586 | -0.228 | 15.8277 | 2020-07-16 04:44:59 | Congo (Brazzaville) | |||
2159029 | 2159029 | 2020-07-14 | Congo (Brazzaville) | 2028 | 47 | 589 | 1392 | -0.228 | 15.8277 | 2020-07-15 04:34:39 | Congo (Brazzaville) | |||
2158895 | 2158895 | 2020-07-14 | China | Sichuan | 599 | 3 | 589 | 7 | 30.6171 | 102.7103 | 2020-07-15 04:34:39 | Sichuan, China | ||
3491670 | 3491670 | 2020-07-13 | Congo (Brazzaville) | 2028 | 47 | 589 | 1392 | -0.228 | 15.8277 | 2020-07-14 04:34:46 | Congo (Brazzaville) | |||
3737933 | 3737933 | 2020-07-12 | Congo (Brazzaville) | 2028 | 47 | 589 | 1392 | -0.228 | 15.8277 | 2020-07-13 04:43:04 | Congo (Brazzaville) | |||
3436328 | 3436328 | 2020-07-11 | Congo (Brazzaville) | 2028 | 47 | 589 | 1392 | -0.228 | 15.8277 | 2020-07-12 04:34:30 | Congo (Brazzaville) | |||
3435875 | 3435875 | 2020-07-11 | Ukraine | Cherkasy Oblast | 738 | 29 | 589 | 120 | 49.4444 | 32.0598 | 2020-07-12 04:34:30 | Cherkasy Oblast, Ukraine | ||
3237826 | 3237826 | 2020-07-10 | Congo (Brazzaville) | 2028 | 47 | 589 | 1392 | -0.228 | 15.8277 | 2020-07-11 04:34:26 | Congo (Brazzaville) | |||
529895 | 529895 | 2020-07-04 | Ukraine | Khmelnytskyi Oblast | 828 | 19 | 589 | 220 | 49.423 | 26.9871 | 2020-07-05 04:33:46 | Khmelnytskyi Oblast, Ukraine | ||
302876 | 302876 | 2020-07-01 | China | Beijing | 923 | 9 | 589 | 325 | 40.1824 | 116.4142 | 2020-07-02 04:33:46 | Beijing, China | ||
3249419 | 3249419 | 2020-06-21 | Russia | Novgorod Oblast | 2417 | 20 | 589 | 1808 | 58.2843833 | 32.5169757 | 2020-06-22 04:33:20 | Novgorod Oblast, Russia | ||
1273494 | 1273494 | 2020-06-11 | Ukraine | Lviv Oblast | 2414 | 87 | 589 | 1738 | 49.8397 | 24.0297 | 2020-06-12 05:09:52 | Lviv Oblast, Ukraine | ||
1210569 | 1210569 | 2020-06-09 | Colombia | Antioquia | 1574 | 10 | 589 | 975 | 7.1986 | -75.3412 | 2020-06-10 04:07:00 | Antioquia, Colombia | ||
216996 | 216996 | 2020-06-08 | Colombia | Antioquia | 1574 | 10 | 589 | 975 | 7.1986 | -75.3412 | 2020-06-09 03:33:03 | Antioquia, Colombia | ||
271760 | 271760 | 2020-04-28 | North Macedonia | 1421 | 71 | 589 | 761 | 41.6086 | 21.7453 | 2020-04-29 02:32:29 | North Macedonia | |||
860198 | 860198 | 2020-04-15 | Egypt | 2505 | 183 | 589 | 1733 | 26.820553000000004 | 30.802497999999996 | 2020-04-15 22:56:32 | Egypt | |||
3338114 | 3338114 | 2020-04-14 | Egypt | 2350 | 178 | 589 | 1583 | 26.820553000000004 | 30.802497999999996 | 2020-04-14 23:33:12 | Egypt | |||
43211 | 43211 | 2020-04-13 | Egypt | 2190 | 164 | 589 | 1437 | 26.820553000000004 | 30.802497999999996 | 2020-04-13 23:07:34 | Egypt | |||
2578237 | 2578237 | 2020-04-12 | Egypt | 2065 | 159 | 589 | 1317 | 26.820553 | 30.802498 | 2020-04-12 23:17:00 | Egypt | |||
62473 | 62473 | 2020-03-07 | Italy | 5883 | 233 | 589 | 43.0 | 12.0 | 2020-03-07T17:33: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]);