daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
36 rows where recovered = 506 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-07-29 | Canada | Yukon | 589 | 7 | 506 | 76 | 64.2823 | -135.0 | 2021-07-30 04:21:34 | Yukon, Canada | ||
2021-02-27 | Japan | Iwate | 554 | 30 | 506 | 18 | 39.593287 | 141.361777 | 2021-02-28 05:22:20 | Iwate, Japan | ||
2020-12-15 | Denmark | Faroe Islands | 530 | 0 | 506 | 24 | 61.8926 | -6.9118 | 2020-12-16 05:28:04 | Faroe Islands, Denmark | ||
2020-12-14 | Denmark | Faroe Islands | 528 | 0 | 506 | 22 | 61.8926 | -6.9118 | 2020-12-15 05:26:38 | Faroe Islands, Denmark | ||
2020-12-13 | Denmark | Faroe Islands | 528 | 0 | 506 | 22 | 61.8926 | -6.9118 | 2020-12-14 05:26:27 | Faroe Islands, Denmark | ||
2020-12-12 | Denmark | Faroe Islands | 525 | 0 | 506 | 19 | 61.8926 | -6.9118 | 2020-12-13 05:27:20 | Faroe Islands, Denmark | ||
2020-11-26 | Japan | Nagano | 654 | 6 | 506 | 142 | 36.132134 | 138.045528 | 2020-11-27 05:26:53 | Nagano, Japan | ||
2020-11-16 | Australia | South Australia | 547 | 4 | 506 | 37 | -34.9285 | 138.6007 | 2020-11-17 05:25:54 | South Australia, Australia | ||
2020-10-22 | Japan | Shiga | 533 | 9 | 506 | 18 | 35.21582700000001 | 136.138064 | 2020-10-23 04:24:46 | Shiga, Japan | ||
2020-10-21 | Japan | Shiga | 531 | 9 | 506 | 16 | 35.21582700000001 | 136.138064 | 2020-10-22 04:24:27 | Shiga, Japan | ||
2020-10-20 | Japan | Shiga | 530 | 9 | 506 | 15 | 35.21582700000001 | 136.138064 | 2020-10-21 04:24:14 | Shiga, Japan | ||
2020-10-03 | Colombia | Vichada | 556 | 5 | 506 | 45 | 4.4234 | -69.2878 | 2020-10-04 04:23:44 | Vichada, Colombia | ||
2020-10-02 | Colombia | Vichada | 533 | 5 | 506 | 22 | 4.4234 | -69.2878 | 2020-10-03 04:23:40 | Vichada, Colombia | ||
2020-09-25 | Ukraine | Kherson Oblast | 954 | 22 | 506 | 426 | 46.6354 | 32.6169 | 2020-09-26 04:23:00 | Kherson Oblast, Ukraine | ||
2020-09-20 | Malaysia | Sabah | 1081 | 10 | 506 | 565 | 5.9788 | 116.0753 | 2020-09-21 04:23:00 | Sabah, Malaysia | ||
2020-09-11 | Japan | Kumamoto | 564 | 8 | 506 | 50 | 32.608154 | 130.74523100000002 | 2020-09-12 04:25:05 | Kumamoto, Japan | ||
2020-08-29 | Japan | Gifu | 555 | 10 | 506 | 39 | 35.778671 | 137.055925 | 2020-08-30 04:28:22 | Gifu, Japan | ||
2020-08-17 | Ukraine | Mykolaiv Oblast | 819 | 18 | 506 | 295 | 46.975 | 31.9946 | 2020-08-18 04:27:56 | Mykolaiv Oblast, Ukraine | ||
2020-08-16 | Ukraine | Mykolaiv Oblast | 808 | 18 | 506 | 284 | 46.975 | 31.9946 | 2020-08-17 04:27:20 | Mykolaiv Oblast, Ukraine | ||
2020-08-15 | Ukraine | Mykolaiv Oblast | 797 | 18 | 506 | 273 | 46.975 | 31.9946 | 2020-08-16 04:27:42 | Mykolaiv Oblast, Ukraine | ||
2020-08-14 | Ukraine | Mykolaiv Oblast | 770 | 18 | 506 | 246 | 46.975 | 31.9946 | 2020-08-15 04:27:31 | Mykolaiv Oblast, Ukraine | ||
2020-08-05 | Angola | 1395 | 62 | 506 | 827 | -11.2027 | 17.8739 | 2020-08-06 04:35:02 | Angola | |||
2020-07-27 | Japan | Aichi | 1182 | 35 | 506 | 641 | 35.035551 | 137.211621 | 2020-07-28 04:58:43 | Aichi, Japan | ||
2020-07-21 | Mozambique | 1536 | 11 | 506 | 1019 | -18.665695 | 35.529562 | 2020-07-22 04:34:42 | Mozambique | |||
2020-07-03 | Russia | Kurgan Oblast | 864 | 1 | 506 | 357 | 55.7655302 | 64.5632681 | 2020-07-04 04:33:51 | Kurgan Oblast, Russia | ||
2020-06-12 | Russia | Pskov Oblast | 1535 | 16 | 506 | 1013 | 57.5358729 | 28.8586826 | 2020-06-13 03:33:14 | Pskov Oblast, Russia | ||
2020-06-10 | Somalia | 2452 | 85 | 506 | 1861 | 5.152149 | 46.199616 | 2020-06-11 03:33:41 | Somalia | |||
2020-06-09 | Russia | Kostroma Oblast | 953 | 12 | 506 | 435 | 58.424756 | 44.253327299999995 | 2020-06-10 04:07:00 | Kostroma Oblast, Russia | ||
2020-06-06 | Ukraine | Lviv Oblast | 2053 | 67 | 506 | 1480 | 49.8397 | 24.0297 | 2020-06-07 03:53:30 | Lviv Oblast, Ukraine | ||
2020-06-04 | Russia | Irkutsk Oblast | 2447 | 15 | 506 | 1926 | 56.6370122 | 104.719221 | 2020-06-05 02:33:06 | Irkutsk Oblast, Russia | ||
2020-05-28 | Mexico | San Luis Potosi | 815 | 49 | 506 | 260 | 22.1565 | -100.9855 | 2020-05-29 02:32:50 | San Luis Potosi, Mexico | ||
2020-05-27 | Honduras | 4640 | 194 | 506 | 3940 | 15.2 | -86.2419 | 2020-05-28 02:32:31 | Honduras | |||
2020-05-26 | Mexico | Tlaxcala | 858 | 134 | 506 | 218 | 19.3139 | -98.2404 | 2020-05-27 02:32:31 | Tlaxcala, Mexico | ||
2020-05-08 | Uruguay | 694 | 18 | 506 | 170 | -32.5228 | -55.7658 | 2020-05-09 02:32:35 | Uruguay | |||
2020-04-30 | Burkina Faso | 645 | 43 | 506 | 96 | 12.2383 | -1.5616 | 2020-05-01 02:32:28 | Burkina Faso | |||
2020-04-08 | India | 5916 | 178 | 506 | 5232 | 20.593684 | 78.96288 | 2020-04-08 22:51:39 | India |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;