johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
75 rows where recovered = 406 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1771160 | 1771160 | 2021-05-23 | China | Liaoning | 425 | 2 | 406 | 17 | 41.2956 | 122.6085 | 2021-05-24 04:20:53 | Liaoning, China | ||
726315 | 726315 | 2021-05-22 | China | Liaoning | 425 | 2 | 406 | 17 | 41.2956 | 122.6085 | 2021-05-23 04:20:51 | Liaoning, China | ||
1952330 | 1952330 | 2021-05-21 | China | Liaoning | 424 | 2 | 406 | 16 | 41.2956 | 122.6085 | 2021-05-22 04:20:45 | Liaoning, China | ||
1913029 | 1913029 | 2021-05-20 | China | Liaoning | 423 | 2 | 406 | 15 | 41.2956 | 122.6085 | 2021-05-21 04:20:43 | Liaoning, China | ||
2255550 | 2255550 | 2021-05-19 | China | Liaoning | 423 | 2 | 406 | 15 | 41.2956 | 122.6085 | 2021-05-20 04:21:05 | Liaoning, China | ||
2390588 | 2390588 | 2021-05-18 | China | Liaoning | 422 | 2 | 406 | 14 | 41.2956 | 122.6085 | 2021-05-19 04:20:42 | Liaoning, China | ||
3574413 | 3574413 | 2021-05-17 | China | Liaoning | 422 | 2 | 406 | 14 | 41.2956 | 122.6085 | 2021-05-18 04:20:33 | Liaoning, China | ||
2939143 | 2939143 | 2021-05-16 | China | Liaoning | 418 | 2 | 406 | 10 | 41.2956 | 122.6085 | 2021-05-17 04:20:34 | Liaoning, China | ||
1872773 | 1872773 | 2021-05-15 | China | Liaoning | 415 | 2 | 406 | 7 | 41.2956 | 122.6085 | 2021-05-16 04:20:49 | Liaoning, China | ||
1081742 | 1081742 | 2021-05-14 | China | Liaoning | 411 | 2 | 406 | 3 | 41.2956 | 122.6085 | 2021-05-15 04:20:58 | Liaoning, China | ||
3054008 | 3054008 | 2021-05-13 | China | Liaoning | 408 | 2 | 406 | 0 | 41.2956 | 122.6085 | 2021-05-14 04:20:41 | Liaoning, China | ||
2004478 | 2004478 | 2021-05-12 | China | Liaoning | 408 | 2 | 406 | 0 | 41.2956 | 122.6085 | 2021-05-13 04:20:51 | Liaoning, China | ||
3954309 | 3954309 | 2021-05-11 | China | Liaoning | 408 | 2 | 406 | 0 | 41.2956 | 122.6085 | 2021-05-12 04:21:29 | Liaoning, China | ||
2820588 | 2820588 | 2021-05-10 | China | Liaoning | 408 | 2 | 406 | 0 | 41.2956 | 122.6085 | 2021-05-11 04:20:41 | Liaoning, China | ||
1424920 | 1424920 | 2021-05-09 | China | Liaoning | 408 | 2 | 406 | 0 | 41.2956 | 122.6085 | 2021-05-10 04:20:38 | Liaoning, China | ||
1551788 | 1551788 | 2021-05-08 | China | Liaoning | 408 | 2 | 406 | 0 | 41.2956 | 122.6085 | 2021-05-09 04:20:35 | Liaoning, China | ||
2501846 | 2501846 | 2021-05-07 | China | Liaoning | 408 | 2 | 406 | 0 | 41.2956 | 122.6085 | 2021-05-08 04:21:04 | Liaoning, China | ||
3113302 | 3113302 | 2021-05-06 | China | Liaoning | 408 | 2 | 406 | 0 | 41.2956 | 122.6085 | 2021-05-07 04:20:40 | Liaoning, China | ||
645769 | 645769 | 2021-05-05 | China | Liaoning | 408 | 2 | 406 | 0 | 41.2956 | 122.6085 | 2021-05-06 04:20:38 | Liaoning, China | ||
3675469 | 3675469 | 2021-05-04 | China | Liaoning | 408 | 2 | 406 | 0 | 41.2956 | 122.6085 | 2021-05-05 04:20:43 | Liaoning, China | ||
2760736 | 2760736 | 2021-05-03 | China | Liaoning | 408 | 2 | 406 | 0 | 41.2956 | 122.6085 | 2021-05-04 04:20:34 | Liaoning, China | ||
2450589 | 2450589 | 2021-05-02 | China | Liaoning | 408 | 2 | 406 | 0 | 41.2956 | 122.6085 | 2021-05-03 04:20:39 | Liaoning, China | ||
2824602 | 2824602 | 2021-05-01 | China | Liaoning | 408 | 2 | 406 | 0 | 41.2956 | 122.6085 | 2021-05-02 04:20:48 | Liaoning, China | ||
380010 | 380010 | 2021-04-30 | China | Liaoning | 408 | 2 | 406 | 0 | 41.2956 | 122.6085 | 2021-05-01 04:20:47 | Liaoning, China | ||
1636133 | 1636133 | 2021-04-29 | China | Liaoning | 408 | 2 | 406 | 0 | 41.2956 | 122.6085 | 2021-04-30 04:21:03 | Liaoning, China | ||
3393212 | 3393212 | 2021-04-28 | China | Liaoning | 408 | 2 | 406 | 0 | 41.2956 | 122.6085 | 2021-04-29 04:20:55 | Liaoning, China | ||
3701928 | 3701928 | 2021-04-27 | China | Liaoning | 408 | 2 | 406 | 0 | 41.2956 | 122.6085 | 2021-04-28 04:20:32 | Liaoning, China | ||
887937 | 887937 | 2021-04-26 | China | Liaoning | 408 | 2 | 406 | 0 | 41.2956 | 122.6085 | 2021-04-27 04:20:52 | Liaoning, China | ||
954682 | 954682 | 2021-04-25 | China | Liaoning | 408 | 2 | 406 | 0 | 41.2956 | 122.6085 | 2021-04-26 04:21:04 | Liaoning, China | ||
3923829 | 3923829 | 2021-04-24 | China | Liaoning | 408 | 2 | 406 | 0 | 41.2956 | 122.6085 | 2021-04-25 04:20:32 | Liaoning, China | ||
1408860 | 1408860 | 2021-04-23 | China | Liaoning | 408 | 2 | 406 | 0 | 41.2956 | 122.6085 | 2021-04-24 04:20:38 | Liaoning, China | ||
1567923 | 1567923 | 2021-04-22 | China | Liaoning | 408 | 2 | 406 | 0 | 41.2956 | 122.6085 | 2021-04-23 04:20:52 | Liaoning, China | ||
3982227 | 3982227 | 2021-02-10 | United Kingdom | Isle of Man | 436 | 25 | 406 | 5 | 54.2361 | -4.5481 | 2021-02-11 05:23:55 | Isle of Man, United Kingdom | ||
1531547 | 1531547 | 2021-02-09 | United Kingdom | Isle of Man | 436 | 25 | 406 | 5 | 54.2361 | -4.5481 | 2021-02-10 05:22:41 | Isle of Man, United Kingdom | ||
617338 | 617338 | 2021-02-08 | United Kingdom | Isle of Man | 435 | 25 | 406 | 4 | 54.2361 | -4.5481 | 2021-02-09 05:23:30 | Isle of Man, United Kingdom | ||
3695524 | 3695524 | 2020-12-31 | Japan | Saga | 468 | 3 | 406 | 59 | 33.286977 | 130.115738 | 2021-01-01 05:23:07 | Saga, Japan | ||
3773552 | 3773552 | 2020-12-22 | Malaysia | Melaka | 708 | 6 | 406 | 296 | 2.1896 | 102.2501 | 2020-12-23 05:22:03 | Melaka, Malaysia | ||
3149641 | 3149641 | 2020-12-16 | Japan | Yamanashi | 463 | 9 | 406 | 48 | 35.612364 | 138.61148899999998 | 2020-12-17 05:28:12 | Yamanashi, Japan | ||
392278 | 392278 | 2020-11-27 | Japan | Toyama | 457 | 26 | 406 | 25 | 36.637464 | 137.26934599999998 | 2020-11-28 05:25:50 | Toyama, Japan | ||
3189995 | 3189995 | 2020-11-22 | Japan | Fukushima | 476 | 6 | 406 | 64 | 37.378867 | 140.223295 | 2020-11-23 05:25:26 | Fukushima, Japan | ||
3836489 | 3836489 | 2020-11-21 | Japan | Fukushima | 474 | 6 | 406 | 62 | 37.378867 | 140.223295 | 2020-11-22 05:25:45 | Fukushima, Japan | ||
762137 | 762137 | 2020-10-18 | China | Shaanxi | 438 | 3 | 406 | 29 | 35.1917 | 108.8701 | 2020-10-19 04:24:16 | Shaanxi, China | ||
2856650 | 2856650 | 2020-10-16 | China | Fujian | 417 | 1 | 406 | 10 | 26.0789 | 117.9874 | 2020-10-17 04:24:12 | Fujian, China | ||
786180 | 786180 | 2020-10-15 | China | Fujian | 417 | 1 | 406 | 10 | 26.0789 | 117.9874 | 2020-10-16 04:24:01 | Fujian, China | ||
78891 | 78891 | 2020-10-14 | China | Fujian | 416 | 1 | 406 | 9 | 26.0789 | 117.9874 | 2020-10-15 04:24:28 | Fujian, China | ||
3781706 | 3781706 | 2020-10-13 | China | Fujian | 416 | 1 | 406 | 9 | 26.0789 | 117.9874 | 2020-10-14 04:24:05 | Fujian, China | ||
2291246 | 2291246 | 2020-10-12 | China | Fujian | 416 | 1 | 406 | 9 | 26.0789 | 117.9874 | 2020-10-13 04:24:02 | Fujian, China | ||
2689469 | 2689469 | 2020-10-08 | Chile | Aysen | 608 | 1 | 406 | 201 | -45.9864 | -73.7669 | 2020-10-09 04:23:59 | Aysen, Chile | ||
3117524 | 3117524 | 2020-10-06 | Japan | Tochigi | 441 | 1 | 406 | 34 | 36.689912 | 139.819213 | 2020-10-07 04:23:40 | Tochigi, Japan | ||
2653635 | 2653635 | 2020-09-23 | Colombia | Vichada | 463 | 4 | 406 | 53 | 4.4234 | -69.2878 | 2020-09-24 04:23:00 | Vichada, Colombia | ||
1109177 | 1109177 | 2020-09-02 | Ukraine | Sevastopol* | 524 | 18 | 406 | 100 | 44.6054 | 33.522 | 2020-09-03 04:28:22 | Sevastopol*, Ukraine | ||
2510198 | 2510198 | 2020-08-27 | Japan | Ishikawa | 605 | 33 | 406 | 166 | 36.769464 | 136.771027 | 2020-08-28 04:28:11 | Ishikawa, Japan | ||
2510163 | 2510163 | 2020-08-27 | Italy | Basilicata | 514 | 28 | 406 | 80 | 40.63947052 | 15.80514834 | 2020-08-28 04:28:11 | Basilicata, Italy | ||
1996623 | 1996623 | 2020-08-26 | Italy | Basilicata | 508 | 28 | 406 | 74 | 40.63947052 | 15.80514834 | 2020-08-27 04:28:15 | Basilicata, Italy | ||
458741 | 458741 | 2020-08-07 | India | Sikkim | 854 | 1 | 406 | 447 | 27.571671 | 88.472712 | 2020-08-08 04:34:53 | Sikkim, India | ||
3205248 | 3205248 | 2020-07-18 | Russia | Jewish Autonomous Okrug | 503 | 7 | 406 | 90 | 48.57527615 | 132.66307460000002 | 2020-07-19 04:34:58 | Jewish Autonomous Okrug, Russia | ||
2708549 | 2708549 | 2020-07-17 | Russia | Jewish Autonomous Okrug | 499 | 7 | 406 | 86 | 48.57527615 | 132.66307460000002 | 2020-07-18 04:34:45 | Jewish Autonomous Okrug, Russia | ||
3867148 | 3867148 | 2020-06-03 | Somalia | 2146 | 79 | 406 | 1661 | 5.152149 | 46.199616 | 2020-06-04 02:33:14 | Somalia | |||
3639109 | 3639109 | 2020-05-30 | Maldives | 1672 | 5 | 406 | 1261 | 3.2028 | 73.2207 | 2020-05-31 02:32:45 | Maldives | |||
1790263 | 1790263 | 2020-05-29 | Colombia | Bolivar | 2661 | 133 | 406 | 2122 | 8.6704 | -74.03 | 2020-05-30 02:32:48 | Bolivar, Colombia | ||
268236 | 268236 | 2020-05-21 | Mexico | Baja California Sur | 502 | 29 | 406 | 67 | 26.0444 | -111.6661 | 2020-05-22 02:36:51 | Baja California Sur, Mexico | ||
2110785 | 2110785 | 2020-05-06 | United Kingdom | Channel Islands | 0 | 0 | 406 | 99 | 49.3723 | -2.3644 | 2020-05-07 02:32:28 | Channel Islands, United Kingdom | ||
1931825 | 1931825 | 2020-05-05 | United Kingdom | Channel Islands | 0 | 0 | 406 | 99 | 49.3723 | -2.3644 | 2020-05-06 02:32:31 | Channel Islands, United Kingdom | ||
3084936 | 3084936 | 2020-05-04 | Tunisia | 1018 | 43 | 406 | 569 | 33.886917 | 9.537499 | 2020-05-05 02:32:34 | Tunisia | |||
3084688 | 3084688 | 2020-05-04 | United Kingdom | Channel Islands | 0 | 0 | 406 | 97 | 49.3723 | -2.3644 | 2020-05-05 02:32:34 | Channel Islands, United Kingdom | ||
2278547 | 2278547 | 2020-05-03 | United Kingdom | Channel Islands | 0 | 0 | 406 | 97 | 49.3723 | -2.3644 | 2020-05-04 02:32:28 | Channel Islands, United Kingdom | ||
2043223 | 2043223 | 2020-05-02 | United Kingdom | Channel Islands | 0 | 0 | 406 | 96 | 49.3723 | -2.3644 | 2020-05-03 02:32:28 | Channel Islands, United Kingdom | ||
1184117 | 1184117 | 2020-05-01 | United Kingdom | Channel Islands | 0 | 0 | 406 | 91 | 49.3723 | -2.3644 | 2020-05-02 02:32:27 | Channel Islands, United Kingdom | ||
860281 | 860281 | 2020-04-15 | Qatar | 3711 | 7 | 406 | 3298 | 25.3548 | 51.1839 | 2020-04-15 22:56:32 | Qatar | |||
3562201 | 3562201 | 2020-04-08 | Singapore | 1623 | 6 | 406 | 1211 | 1.2833 | 103.8333 | 2020-04-08 22:51:39 | Singapore | |||
3021712 | 3021712 | 2020-04-07 | China | Shanghai | 538 | 6 | 406 | 126 | 31.201999999999998 | 121.4491 | 2020-04-07 06:21:55 | Shanghai, China | ||
3627545 | 3627545 | 2020-04-06 | Russia | 6343 | 47 | 406 | 5890 | 61.52401 | 105.318756 | 4/6/20 23:21 | Russia | |||
3627544 | 3627544 | 2020-04-06 | Romania | 4057 | 176 | 406 | 3475 | 45.9432 | 24.9668 | 4/6/20 23:21 | Romania | |||
919066 | 919066 | 2020-03-26 | China | Beijing | 566 | 8 | 406 | 152 | 40.1824 | 116.4142 | 2020-03-26 06:49:10 | Beijing, China | ||
98815 | 98815 | 2020-03-04 | Mainland China | Sichuan | 538 | 3 | 406 | 30.6171 | 102.7103 | 2020-03-04T12:53: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]);