daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
2,906 rows where active = 38 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
- US 2,480
- Japan 76
- United Kingdom 72
- China 52
- Malaysia 29
- Colombia 17
- India 13
- Russia 13
- Canada 12
- Australia 11
- Bhutan 8
- Germany 8
- Netherlands 8
- Ukraine 8
- Sao Tome and Principe 6
- Monaco 5
- Niger 5
- Cambodia 4
- Comoros 4
- Congo (Brazzaville) 4
- Guinea-Bissau 4
- Mexico 4
- Nepal 4
- Chad 3
- Denmark 3
- France 3
- Libya 3
- Madagascar 3
- Central African Republic 2
- Chile 2
- …
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-08-04 | China | Henan | 1355 | 22 | 1295 | 38 | 33.882 | 113.614 | 2021-08-05 04:21:51 | Henan, China | ||
2021-08-02 | Canada | New Brunswick | 2383 | 46 | 2299 | 38 | 46.5653 | -66.4619 | 2021-08-03 04:21:39 | New Brunswick, Canada | ||
2021-08-01 | Canada | New Brunswick | 2383 | 46 | 2299 | 38 | 46.5653 | -66.4619 | 2021-08-02 04:21:36 | New Brunswick, Canada | ||
2021-07-31 | Denmark | Faroe Islands | 983 | 2 | 943 | 38 | 61.8926 | -6.9118 | 2021-08-01 04:21:50 | Faroe Islands, Denmark | ||
2021-07-30 | Japan | Akita | 1013 | 20 | 955 | 38 | 39.748679 | 140.408228 | 2021-07-31 04:21:35 | Akita, Japan | ||
2021-07-29 | San Marino | 5133 | 90 | 5005 | 38 | 43.9424 | 12.4578 | 2021-07-30 04:21:34 | San Marino | |||
2021-07-28 | San Marino | 5133 | 90 | 5005 | 38 | 43.9424 | 12.4578 | 2021-07-29 04:21:33 | San Marino | |||
2021-07-25 | China | Sichuan | 1139 | 3 | 1098 | 38 | 30.6171 | 102.7103 | 2021-07-26 04:21:28 | Sichuan, China | ||
2021-07-24 | Japan | Yamaguchi | 3206 | 80 | 3088 | 38 | 34.201190000000004 | 131.573293 | 2021-07-25 04:22:12 | Yamaguchi, Japan | ||
2021-07-23 | Sao Tome and Principe | 2420 | 37 | 2345 | 38 | 0.1864 | 6.6131 | 2021-07-24 00:21:36 | Sao Tome and Principe | |||
2021-07-22 | Saint Kitts and Nevis | 560 | 3 | 519 | 38 | 17.357822 | -62.782998 | 2021-07-23 04:21:29 | Saint Kitts and Nevis | |||
2021-07-20 | China | Sichuan | 1126 | 3 | 1085 | 38 | 30.6171 | 102.7103 | 2021-07-21 04:21:40 | Sichuan, China | ||
2021-07-19 | China | Sichuan | 1126 | 3 | 1085 | 38 | 30.6171 | 102.7103 | 2021-07-20 04:21:48 | Sichuan, China | ||
2021-07-18 | China | Sichuan | 1125 | 3 | 1084 | 38 | 30.6171 | 102.7103 | 2021-07-19 04:21:24 | Sichuan, China | ||
2021-07-17 | Japan | Aomori | 2572 | 31 | 2503 | 38 | 40.781541 | 140.828896 | 2021-07-18 04:22:07 | Aomori, Japan | ||
2021-07-12 | Japan | Yamaguchi | 3175 | 80 | 3057 | 38 | 34.201190000000004 | 131.573293 | 2021-07-13 04:21:18 | Yamaguchi, Japan | ||
2021-07-08 | Colombia | Vichada | 2507 | 40 | 2429 | 38 | 4.4234 | -69.2878 | 2021-07-09 04:21:21 | Vichada, Colombia | ||
2021-07-08 | China | Sichuan | 1111 | 3 | 1070 | 38 | 30.6171 | 102.7103 | 2021-07-09 04:21:21 | Sichuan, China | ||
2021-07-07 | Japan | Okayama | 7603 | 126 | 7439 | 38 | 34.89246 | 133.826252 | 2021-07-08 04:21:26 | Okayama, Japan | ||
2021-07-07 | India | Dadra and Nagar Haveli and Daman and Diu | 10576 | 4 | 10534 | 38 | 20.194742 | 73.080901 | 2021-07-08 04:21:26 | Dadra and Nagar Haveli and Daman and Diu, India | ||
2021-07-05 | United Kingdom | Isle of Man | 1638 | 29 | 1571 | 38 | 54.2361 | -4.5481 | 2021-07-06 04:21:32 | Isle of Man, United Kingdom | ||
2021-07-04 | United Kingdom | Isle of Man | 1638 | 29 | 1571 | 38 | 54.2361 | -4.5481 | 2021-07-05 04:21:28 | Isle of Man, United Kingdom | ||
2021-07-04 | India | Dadra and Nagar Haveli and Daman and Diu | 10569 | 4 | 10527 | 38 | 20.194742 | 73.080901 | 2021-07-05 04:21:28 | Dadra and Nagar Haveli and Daman and Diu, India | ||
2021-07-03 | Japan | Niigata | 3414 | 52 | 3324 | 38 | 37.521819 | 138.918647 | 2021-07-04 04:21:38 | Niigata, Japan | ||
2021-07-03 | Japan | Ishikawa | 3949 | 115 | 3796 | 38 | 36.769464 | 136.771027 | 2021-07-04 04:21:38 | Ishikawa, Japan | ||
2021-07-02 | Netherlands | Sint Maarten | 2618 | 33 | 2547 | 38 | 18.0425 | -63.0548 | 2021-07-03 04:21:37 | Sint Maarten, Netherlands | ||
2021-07-02 | Japan | Toyama | 2042 | 38 | 1966 | 38 | 36.637464 | 137.26934599999998 | 2021-07-03 04:21:37 | Toyama, Japan | ||
2021-07-02 | Japan | Niigata | 3408 | 52 | 3318 | 38 | 37.521819 | 138.918647 | 2021-07-03 04:21:37 | Niigata, Japan | ||
2021-07-02 | Japan | Miyazaki | 3092 | 27 | 3027 | 38 | 32.193203999999994 | 131.299374 | 2021-07-03 04:21:37 | Miyazaki, Japan | ||
2021-07-01 | Netherlands | Sint Maarten | 2618 | 33 | 2547 | 38 | 18.0425 | -63.0548 | 2021-07-02 04:21:47 | Sint Maarten, Netherlands | ||
2021-06-30 | Netherlands | Sint Maarten | 2618 | 33 | 2547 | 38 | 18.0425 | -63.0548 | 2021-07-01 04:21:19 | Sint Maarten, Netherlands | ||
2021-06-26 | Monaco | 2570 | 33 | 2499 | 38 | 43.7333 | 7.4167 | 2021-06-27 04:21:39 | Monaco | |||
2021-06-25 | Monaco | 2570 | 33 | 2499 | 38 | 43.7333 | 7.4167 | 2021-06-26 04:21:43 | Monaco | |||
2021-06-24 | Colombia | Amazonas | 6382 | 244 | 6100 | 38 | -1.4429 | -71.5724 | 2021-06-25 04:21:33 | Amazonas, Colombia | ||
2021-06-23 | Russia | Chukotka Autonomous Okrug | 792 | 8 | 746 | 38 | 66.0006475 | 169.4900869 | 2021-06-24 04:21:55 | Chukotka Autonomous Okrug, Russia | ||
2021-06-23 | Italy | Valle d'Aosta | 11676 | 473 | 11165 | 38 | 45.73750286 | 7.320149366 | 2021-06-24 04:21:55 | Valle d'Aosta, Italy | ||
2021-06-22 | United Kingdom | British Virgin Islands | 248 | 1 | 209 | 38 | 18.4207 | -64.64 | 2021-06-23 04:21:46 | British Virgin Islands, United Kingdom | ||
2021-06-21 | United Kingdom | British Virgin Islands | 248 | 1 | 209 | 38 | 18.4207 | -64.64 | 2021-06-22 04:21:34 | British Virgin Islands, United Kingdom | ||
2021-06-21 | Japan | Yamagata | 2020 | 47 | 1935 | 38 | 38.448396 | 140.102154 | 2021-06-22 04:21:34 | Yamagata, Japan | ||
2021-06-21 | Japan | Gifu | 9189 | 183 | 8968 | 38 | 35.778671 | 137.055925 | 2021-06-22 04:21:34 | Gifu, Japan | ||
2021-06-21 | Colombia | Amazonas | 6376 | 243 | 6095 | 38 | -1.4429 | -71.5724 | 2021-06-22 04:21:34 | Amazonas, Colombia | ||
2021-06-20 | United Kingdom | British Virgin Islands | 248 | 1 | 209 | 38 | 18.4207 | -64.64 | 2021-06-21 04:21:41 | British Virgin Islands, United Kingdom | ||
2021-06-20 | Japan | Yamagata | 2020 | 47 | 1935 | 38 | 38.448396 | 140.102154 | 2021-06-21 04:21:41 | Yamagata, Japan | ||
2021-06-19 | United Kingdom | British Virgin Islands | 248 | 1 | 209 | 38 | 18.4207 | -64.64 | 2021-06-20 04:21:48 | British Virgin Islands, United Kingdom | ||
2021-06-19 | Colombia | Amazonas | 6375 | 243 | 6094 | 38 | -1.4429 | -71.5724 | 2021-06-20 04:21:48 | Amazonas, Colombia | ||
2021-06-19 | Australia | Queensland | 1665 | 7 | 1620 | 38 | -27.4698 | 153.0251 | 2021-06-20 04:21:48 | Queensland, Australia | ||
2021-06-18 | United Kingdom | British Virgin Islands | 248 | 1 | 209 | 38 | 18.4207 | -64.64 | 2021-06-19 04:22:33 | British Virgin Islands, United Kingdom | ||
2021-06-18 | Netherlands | Curacao | 12314 | 125 | 12151 | 38 | 12.1696 | -68.99 | 2021-06-19 04:22:33 | Curacao, Netherlands | ||
2021-06-18 | Japan | Fukui | 1088 | 34 | 1016 | 38 | 35.846614 | 136.22465400000002 | 2021-06-19 04:22:33 | Fukui, Japan | ||
2021-06-18 | Colombia | Amazonas | 6374 | 242 | 6094 | 38 | -1.4429 | -71.5724 | 2021-06-19 04:22:33 | Amazonas, Colombia | ||
2021-06-17 | United Kingdom | British Virgin Islands | 248 | 1 | 209 | 38 | 18.4207 | -64.64 | 2021-06-18 04:22:16 | British Virgin Islands, United Kingdom | ||
2021-06-17 | China | Zhejiang | 1376 | 1 | 1337 | 38 | 29.1832 | 120.0934 | 2021-06-18 04:22:16 | Zhejiang, China | ||
2021-06-16 | United Kingdom | British Virgin Islands | 248 | 1 | 209 | 38 | 18.4207 | -64.64 | 2021-06-17 04:22:36 | British Virgin Islands, United Kingdom | ||
2021-06-15 | United Kingdom | British Virgin Islands | 248 | 1 | 209 | 38 | 18.4207 | -64.64 | 2021-06-16 04:22:32 | British Virgin Islands, United Kingdom | ||
2021-06-14 | United Kingdom | British Virgin Islands | 248 | 1 | 209 | 38 | 18.4207 | -64.64 | 2021-06-15 04:22:22 | British Virgin Islands, United Kingdom | ||
2021-06-13 | United Kingdom | British Virgin Islands | 248 | 1 | 209 | 38 | 18.4207 | -64.64 | 2021-06-14 04:22:46 | British Virgin Islands, United Kingdom | ||
2021-06-13 | Colombia | Amazonas | 6366 | 242 | 6086 | 38 | -1.4429 | -71.5724 | 2021-06-14 04:22:46 | Amazonas, Colombia | ||
2021-06-12 | United Kingdom | British Virgin Islands | 248 | 1 | 209 | 38 | 18.4207 | -64.64 | 2021-06-13 04:22:44 | British Virgin Islands, United Kingdom | ||
2021-06-11 | United Kingdom | British Virgin Islands | 248 | 1 | 209 | 38 | 18.4207 | -64.64 | 2021-06-12 04:22:22 | British Virgin Islands, United Kingdom | ||
2021-06-11 | China | Fujian | 636 | 1 | 597 | 38 | 26.0789 | 117.9874 | 2021-06-12 04:22:22 | Fujian, China | ||
2021-06-10 | United Kingdom | British Virgin Islands | 248 | 1 | 209 | 38 | 18.4207 | -64.64 | 2021-06-11 04:23:20 | British Virgin Islands, United Kingdom | ||
2021-06-10 | Japan | Miyazaki | 3044 | 27 | 2979 | 38 | 32.193203999999994 | 131.299374 | 2021-06-11 04:23:20 | Miyazaki, Japan | ||
2021-06-09 | United Kingdom | British Virgin Islands | 248 | 1 | 209 | 38 | 18.4207 | -64.64 | 2021-06-10 04:23:17 | British Virgin Islands, United Kingdom | ||
2021-06-08 | United Kingdom | British Virgin Islands | 248 | 1 | 209 | 38 | 18.4207 | -64.64 | 2021-06-09 04:23:31 | British Virgin Islands, United Kingdom | ||
2021-06-07 | United Kingdom | British Virgin Islands | 248 | 1 | 209 | 38 | 18.4207 | -64.64 | 2021-06-08 04:22:35 | British Virgin Islands, United Kingdom | ||
2021-06-06 | United Kingdom | British Virgin Islands | 248 | 1 | 209 | 38 | 18.4207 | -64.64 | 2021-06-07 04:22:51 | British Virgin Islands, United Kingdom | ||
2021-06-05 | United Kingdom | British Virgin Islands | 248 | 1 | 209 | 38 | 18.4207 | -64.64 | 2021-06-06 04:24:03 | British Virgin Islands, United Kingdom | ||
2021-06-04 | United Kingdom | British Virgin Islands | 248 | 1 | 209 | 38 | 18.4207 | -64.64 | 2021-06-05 04:23:03 | British Virgin Islands, United Kingdom | ||
2021-06-03 | United Kingdom | British Virgin Islands | 248 | 1 | 209 | 38 | 18.4207 | -64.64 | 2021-06-04 04:23:37 | British Virgin Islands, United Kingdom | ||
2021-06-02 | United Kingdom | British Virgin Islands | 248 | 1 | 209 | 38 | 18.4207 | -64.64 | 2021-06-03 04:23:32 | British Virgin Islands, United Kingdom | ||
2021-06-01 | United Kingdom | British Virgin Islands | 248 | 1 | 209 | 38 | 18.4207 | -64.64 | 2021-06-02 04:24:34 | British Virgin Islands, United Kingdom | ||
2021-05-31 | United Kingdom | British Virgin Islands | 248 | 1 | 209 | 38 | 18.4207 | -64.64 | 2021-06-01 04:23:09 | British Virgin Islands, United Kingdom | ||
2021-05-30 | United Kingdom | British Virgin Islands | 248 | 1 | 209 | 38 | 18.4207 | -64.64 | 2021-05-31 03:08:59 | British Virgin Islands, United Kingdom | ||
2021-05-29 | United Kingdom | British Virgin Islands | 248 | 1 | 209 | 38 | 18.4207 | -64.64 | 2021-05-30 04:20:55 | British Virgin Islands, United Kingdom | ||
2021-05-28 | United Kingdom | British Virgin Islands | 248 | 1 | 209 | 38 | 18.4207 | -64.64 | 2021-05-29 04:20:41 | British Virgin Islands, United Kingdom | ||
2021-05-27 | United Kingdom | British Virgin Islands | 248 | 1 | 209 | 38 | 18.4207 | -64.64 | 2021-05-28 04:20:36 | British Virgin Islands, United Kingdom | ||
2021-05-27 | China | Zhejiang | 1363 | 1 | 1324 | 38 | 29.1832 | 120.0934 | 2021-05-28 04:20:36 | Zhejiang, China | ||
2021-05-26 | United Kingdom | British Virgin Islands | 248 | 1 | 209 | 38 | 18.4207 | -64.64 | 2021-05-27 04:20:59 | British Virgin Islands, United Kingdom | ||
2021-05-26 | China | Zhejiang | 1363 | 1 | 1324 | 38 | 29.1832 | 120.0934 | 2021-05-27 04:20:59 | Zhejiang, China | ||
2021-05-25 | United Kingdom | British Virgin Islands | 248 | 1 | 209 | 38 | 18.4207 | -64.64 | 2021-05-26 04:20:35 | British Virgin Islands, United Kingdom | ||
2021-05-25 | China | Zhejiang | 1363 | 1 | 1324 | 38 | 29.1832 | 120.0934 | 2021-05-26 04:20:35 | Zhejiang, China | ||
2021-05-24 | United Kingdom | British Virgin Islands | 248 | 1 | 209 | 38 | 18.4207 | -64.64 | 2021-05-25 04:21:08 | British Virgin Islands, United Kingdom | ||
2021-05-23 | United Kingdom | British Virgin Islands | 248 | 1 | 209 | 38 | 18.4207 | -64.64 | 2021-05-24 04:20:53 | British Virgin Islands, United Kingdom | ||
2021-05-22 | United Kingdom | British Virgin Islands | 248 | 1 | 209 | 38 | 18.4207 | -64.64 | 2021-05-23 04:20:51 | British Virgin Islands, United Kingdom | ||
2021-05-21 | United Kingdom | British Virgin Islands | 248 | 1 | 209 | 38 | 18.4207 | -64.64 | 2021-05-22 04:20:45 | British Virgin Islands, United Kingdom | ||
2021-05-20 | United Kingdom | British Virgin Islands | 248 | 1 | 209 | 38 | 18.4207 | -64.64 | 2021-05-21 04:20:43 | British Virgin Islands, United Kingdom | ||
2021-05-20 | China | Guangdong | 2400 | 8 | 2354 | 38 | 23.3417 | 113.4244 | 2021-05-21 04:20:43 | Guangdong, China | ||
2021-05-19 | United Kingdom | British Virgin Islands | 248 | 1 | 209 | 38 | 18.4207 | -64.64 | 2021-05-20 04:21:05 | British Virgin Islands, United Kingdom | ||
2021-05-18 | United Kingdom | British Virgin Islands | 248 | 1 | 209 | 38 | 18.4207 | -64.64 | 2021-05-19 04:20:42 | British Virgin Islands, United Kingdom | ||
2021-05-17 | United Kingdom | British Virgin Islands | 248 | 1 | 209 | 38 | 18.4207 | -64.64 | 2021-05-18 04:20:33 | British Virgin Islands, United Kingdom | ||
2021-05-16 | United Kingdom | British Virgin Islands | 248 | 1 | 209 | 38 | 18.4207 | -64.64 | 2021-05-17 04:20:34 | British Virgin Islands, United Kingdom | ||
2021-05-16 | Canada | Northwest Territories | 121 | 0 | 83 | 38 | 64.8255 | -124.8457 | 2021-05-17 04:20:34 | Northwest Territories,Canada | ||
2021-05-15 | United Kingdom | British Virgin Islands | 248 | 1 | 209 | 38 | 18.4207 | -64.64 | 2021-05-16 04:20:49 | British Virgin Islands, United Kingdom | ||
2021-05-15 | Canada | Northwest Territories | 121 | 0 | 83 | 38 | 64.8255 | -124.8457 | 2021-05-16 04:20:49 | Northwest Territories,Canada | ||
2021-05-14 | Canada | Northwest Territories | 121 | 0 | 83 | 38 | 64.8255 | -124.8457 | 2021-05-15 04:20:58 | Northwest Territories,Canada | ||
2021-05-13 | Russia | Jewish Autonomous Okrug | 4474 | 138 | 4298 | 38 | 48.57527615 | 132.66307460000002 | 2021-05-14 04:20:41 | Jewish Autonomous Okrug, Russia | ||
2021-05-09 | Fiji | 139 | 3 | 98 | 38 | -17.7134 | 178.065 | 2021-05-10 04:20:38 | Fiji | |||
2021-05-08 | Uganda | 42308 | 346 | 41924 | 38 | 1.373333 | 32.290275 | 2021-05-09 04:20:35 | Uganda | |||
2021-05-04 | Uganda | 42032 | 342 | 41652 | 38 | 1.373333 | 32.290275 | 2021-05-05 04:20:43 | Uganda | |||
2021-04-28 | Eswatini | 18452 | 671 | 17743 | 38 | -26.5225 | 31.4659 | 2021-04-29 04:20:55 | Eswatini |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;