johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
34 rows where recovered = 442 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 12
- Japan 9
- Australia 4
- Ukraine 4
- United Kingdom 4
- West Bank and Gaza 3
- China 2
- Malaysia 2
- Russia 2
- Burkina Faso 1
- Mainland China 1
- Mexico 1
- Uruguay 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
522899 | 522899 | 2021-06-09 | Japan | Tottori | 466 | 2 | 442 | 22 | 35.359069 | 133.863619 | 2021-06-10 04:23:17 | Tottori, Japan | ||
3372974 | 3372974 | 2021-03-21 | United Kingdom | Cayman Islands | 475 | 2 | 442 | 31 | 19.3133 | -81.2546 | 2021-03-22 05:25:43 | Cayman Islands, United Kingdom | ||
1748184 | 1748184 | 2021-03-20 | United Kingdom | Cayman Islands | 475 | 2 | 442 | 31 | 19.3133 | -81.2546 | 2021-03-21 05:25:44 | Cayman Islands, United Kingdom | ||
3424564 | 3424564 | 2021-03-19 | United Kingdom | Cayman Islands | 475 | 2 | 442 | 31 | 19.3133 | -81.2546 | 2021-03-20 05:25:46 | Cayman Islands, United Kingdom | ||
3456502 | 3456502 | 2021-03-18 | United Kingdom | Cayman Islands | 475 | 2 | 442 | 31 | 19.3133 | -81.2546 | 2021-03-19 05:26:09 | Cayman Islands, United Kingdom | ||
2637539 | 2637539 | 2021-02-11 | China | Jilin | 573 | 3 | 442 | 128 | 43.6661 | 126.1923 | 2021-02-12 05:23:29 | Jilin, China | ||
1588222 | 1588222 | 2021-02-05 | Japan | Yamagata | 519 | 13 | 442 | 64 | 38.448396 | 140.102154 | 2021-02-06 05:23:55 | Yamagata, Japan | ||
3153270 | 3153270 | 2020-12-16 | Malaysia | Pahang | 854 | 7 | 442 | 405 | 3.8126 | 103.3256 | 2020-12-17 05:28:12 | Pahang, Malaysia | ||
2935035 | 2935035 | 2020-11-28 | China | Fujian | 487 | 1 | 442 | 44 | 26.0789 | 117.9874 | 2020-11-29 05:25:55 | Fujian, China | ||
3190213 | 3190213 | 2020-11-22 | Russia | Nenets Autonomous Okrug | 628 | 0 | 442 | 186 | 68.27557185 | 57.1686375 | 2020-11-23 05:25:26 | Nenets Autonomous Okrug, Russia | ||
1053863 | 1053863 | 2020-10-23 | Japan | Tochigi | 476 | 1 | 442 | 33 | 36.689912 | 139.819213 | 2020-10-24 04:24:46 | Tochigi, Japan | ||
1177533 | 1177533 | 2020-10-22 | Japan | Tochigi | 473 | 1 | 442 | 30 | 36.689912 | 139.819213 | 2020-10-23 04:24:46 | Tochigi, Japan | ||
2191638 | 2191638 | 2020-10-21 | Japan | Tochigi | 473 | 1 | 442 | 30 | 36.689912 | 139.819213 | 2020-10-22 04:24:27 | Tochigi, Japan | ||
79111 | 79111 | 2020-10-14 | Japan | Miyagi | 504 | 2 | 442 | 60 | 38.446859 | 140.927086 | 2020-10-15 04:24:28 | Miyagi, Japan | ||
2840431 | 2840431 | 2020-09-21 | Ukraine | Kherson Oblast | 818 | 20 | 442 | 356 | 46.6354 | 32.6169 | 2020-09-22 04:23:00 | Kherson Oblast, Ukraine | ||
2175172 | 2175172 | 2020-09-09 | Ukraine | Sevastopol* | 590 | 20 | 442 | 128 | 44.6054 | 33.522 | 2020-09-10 04:29:01 | Sevastopol*, Ukraine | ||
2661786 | 2661786 | 2020-09-04 | Japan | Hiroshima | 459 | 3 | 442 | 14 | 34.605309000000005 | 132.788719 | 2020-09-05 04:28:19 | Hiroshima, Japan | ||
1354354 | 1354354 | 2020-09-03 | Japan | Shizuoka | 485 | 1 | 442 | 42 | 34.916975 | 138.40778400000002 | 2020-09-04 04:28:26 | Shizuoka, Japan | ||
3932053 | 3932053 | 2020-08-30 | Japan | Nara | 509 | 5 | 442 | 62 | 34.317451 | 135.871644 | 2020-08-31 04:28:27 | Nara, Japan | ||
2234847 | 2234847 | 2020-07-03 | Ukraine | Zaporizhia Oblast | 579 | 17 | 442 | 120 | 47.8388 | 35.1396 | 2020-07-04 04:33:51 | Zaporizhia Oblast, Ukraine | ||
3045642 | 3045642 | 2020-07-02 | Ukraine | Zaporizhia Oblast | 576 | 17 | 442 | 117 | 47.8388 | 35.1396 | 2020-07-03 04:33:54 | Zaporizhia Oblast, Ukraine | ||
2701161 | 2701161 | 2020-06-24 | West Bank and Gaza | 1328 | 3 | 442 | 883 | 31.9522 | 35.2332 | 2020-06-25 05:26:54 | West Bank and Gaza | |||
1522846 | 1522846 | 2020-06-23 | West Bank and Gaza | 1169 | 3 | 442 | 724 | 31.9522 | 35.2332 | 2020-06-24 04:33:28 | West Bank and Gaza | |||
1511040 | 1511040 | 2020-06-22 | West Bank and Gaza | 1001 | 3 | 442 | 556 | 31.9522 | 35.2332 | 2020-06-23 04:33:22 | West Bank and Gaza | |||
1510871 | 1510871 | 2020-06-22 | Mexico | Zacatecas | 706 | 75 | 442 | 189 | 22.7709 | -102.5832 | 2020-06-23 04:33:22 | Zacatecas, Mexico | ||
1195836 | 1195836 | 2020-06-17 | Russia | Kemerovo Oblast | 1079 | 7 | 442 | 630 | 54.53357809999999 | 87.342861 | 2020-06-18 04:33:18 | Kemerovo Oblast, Russia | ||
3416568 | 3416568 | 2020-05-17 | Malaysia | Sarawak | 544 | 17 | 442 | 85 | 1.5533 | 110.3592 | 2020-05-18 02:32:21 | Sarawak, Malaysia | ||
2278801 | 2278801 | 2020-05-03 | Uruguay | 655 | 17 | 442 | 196 | -32.5228 | -55.7658 | 2020-05-04 02:32:28 | Uruguay | |||
3502846 | 3502846 | 2020-04-25 | Burkina Faso | 629 | 41 | 442 | 146 | 12.2383 | -1.5616 | 2020-04-26 02:30:31 | Burkina Faso | |||
50234 | 50234 | 2020-04-17 | Australia | Queensland | 1007 | 5 | 442 | 560 | -27.4698 | 153.0251 | 2020-04-17 23:38:48 | Queensland, Australia | ||
934228 | 934228 | 2020-04-16 | Australia | Queensland | 1001 | 5 | 442 | 554 | -27.4698 | 153.0251 | 2020-04-16 23:38:19 | Queensland, Australia | ||
860122 | 860122 | 2020-04-15 | Australia | Queensland | 999 | 5 | 442 | 552 | -27.4698 | 153.0251 | 2020-04-15 23:04:26 | Queensland, Australia | ||
3338038 | 3338038 | 2020-04-14 | Australia | Queensland | 998 | 5 | 442 | 551 | -27.4698 | 153.0251 | 2020-04-14 23:41:11 | Queensland, Australia | ||
3177491 | 3177491 | 2020-03-06 | Mainland China | Sichuan | 539 | 3 | 442 | 30.6171 | 102.7103 | 2020-03-06T12: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]);