daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
2,441 rows where active = 43 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: last_update (date)
These facets timed out: province_or_state
country_or_region >30
- US 2,103
- Japan 58
- China 53
- Malaysia 21
- Colombia 20
- United Kingdom 15
- India 14
- Germany 13
- Bahamas 12
- Italy 9
- Russia 9
- Canada 8
- Mauritius 7
- New Zealand 7
- Bhutan 6
- Chile 6
- Taiwan* 5
- Vietnam 4
- Zambia 4
- Australia 3
- Cambodia 3
- Denmark 3
- Guinea-Bissau 3
- Iceland 3
- Monaco 3
- Mongolia 3
- Barbados 2
- Chad 2
- Comoros 2
- Eritrea 2
- …
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-08-03 | Colombia | Vichada | 2847 | 46 | 2758 | 43 | 4.4234 | -69.2878 | 2021-08-04 04:21:25 | Vichada, Colombia | ||
2021-08-03 | China | Sichuan | 1158 | 3 | 1112 | 43 | 30.6171 | 102.7103 | 2021-08-04 04:21:25 | Sichuan, China | ||
2021-08-03 | China | Hunan | 1111 | 4 | 1064 | 43 | 27.6104 | 111.7088 | 2021-08-04 04:21:25 | Hunan, China | ||
2021-08-02 | China | Sichuan | 1157 | 3 | 1111 | 43 | 30.6171 | 102.7103 | 2021-08-03 04:21:39 | Sichuan, China | ||
2021-08-01 | China | Sichuan | 1154 | 3 | 1108 | 43 | 30.6171 | 102.7103 | 2021-08-02 04:21:36 | Sichuan, China | ||
2021-07-30 | Colombia | Amazonas | 6601 | 250 | 6308 | 43 | -1.4429 | -71.5724 | 2021-07-31 04:21:35 | Amazonas, Colombia | ||
2021-07-30 | China | Sichuan | 1151 | 3 | 1105 | 43 | 30.6171 | 102.7103 | 2021-07-31 04:21:35 | Sichuan, China | ||
2021-07-29 | China | Sichuan | 1150 | 3 | 1104 | 43 | 30.6171 | 102.7103 | 2021-07-30 04:21:34 | Sichuan, China | ||
2021-07-28 | China | Sichuan | 1149 | 3 | 1103 | 43 | 30.6171 | 102.7103 | 2021-07-29 04:21:33 | Sichuan, China | ||
2021-07-27 | New Zealand | 2864 | 28 | 2795 | 43 | -40.9006 | 174.886 | 2021-07-28 04:21:39 | New Zealand | |||
2021-07-26 | Malaysia | Perlis | 660 | 8 | 609 | 43 | 6.4449 | 100.2048 | 2021-07-27 04:21:18 | Perlis, Malaysia | ||
2021-07-26 | Japan | Yamaguchi | 3218 | 80 | 3095 | 43 | 34.201190000000004 | 131.573293 | 2021-07-27 04:21:18 | Yamaguchi, Japan | ||
2021-07-26 | Japan | Akita | 996 | 20 | 933 | 43 | 39.748679 | 140.408228 | 2021-07-27 04:21:18 | Akita, Japan | ||
2021-07-22 | Japan | Oita | 3545 | 64 | 3438 | 43 | 33.200697 | 131.43323999999998 | 2021-07-23 04:21:29 | Oita, Japan | ||
2021-07-21 | Chile | Aysen | 8029 | 68 | 7918 | 43 | -45.9864 | -73.7669 | 2021-07-22 04:21:19 | Aysen, Chile | ||
2021-07-20 | Japan | Oita | 3542 | 64 | 3435 | 43 | 33.200697 | 131.43323999999998 | 2021-07-21 04:21:40 | Oita, Japan | ||
2021-07-20 | Japan | Mie | 5490 | 113 | 5334 | 43 | 34.508018 | 136.376013 | 2021-07-21 04:21:40 | Mie, Japan | ||
2021-07-19 | Japan | Tokushima | 1705 | 63 | 1599 | 43 | 33.919178 | 134.242091 | 2021-07-20 04:21:48 | Tokushima, Japan | ||
2021-07-19 | Japan | Ehime | 2796 | 75 | 2678 | 43 | 33.624835 | 132.856842 | 2021-07-20 04:21:48 | Ehime, Japan | ||
2021-07-17 | Comoros | 4009 | 147 | 3819 | 43 | -11.6455 | 43.3333 | 2021-07-18 04:22:07 | Comoros | |||
2021-07-16 | Comoros | 4009 | 147 | 3819 | 43 | -11.6455 | 43.3333 | 2021-07-17 04:22:22 | Comoros | |||
2021-07-16 | China | Fujian | 704 | 1 | 660 | 43 | 26.0789 | 117.9874 | 2021-07-17 04:22:22 | Fujian, China | ||
2021-07-13 | Netherlands | Aruba | 11180 | 108 | 11029 | 43 | 12.5211 | -69.9683 | 2021-07-14 04:21:35 | Aruba, Netherlands | ||
2021-07-13 | Japan | Akita | 944 | 20 | 881 | 43 | 39.748679 | 140.408228 | 2021-07-14 04:21:35 | Akita, Japan | ||
2021-07-12 | New Zealand | 2786 | 28 | 2717 | 43 | -40.9006 | 174.886 | 2021-07-13 04:21:18 | New Zealand | |||
2021-07-12 | Monaco | 2624 | 33 | 2548 | 43 | 43.7333 | 7.4167 | 2021-07-13 04:21:18 | Monaco | |||
2021-07-11 | China | Sichuan | 1118 | 3 | 1072 | 43 | 30.6171 | 102.7103 | 2021-07-12 04:21:34 | Sichuan, China | ||
2021-07-10 | Colombia | Vichada | 2518 | 41 | 2434 | 43 | 4.4234 | -69.2878 | 2021-07-11 04:21:43 | Vichada, Colombia | ||
2021-07-10 | China | Fujian | 692 | 1 | 648 | 43 | 26.0789 | 117.9874 | 2021-07-11 04:21:43 | Fujian, China | ||
2021-07-08 | Japan | Gunma | 8066 | 154 | 7869 | 43 | 36.504479 | 138.985605 | 2021-07-09 04:21:21 | Gunma, Japan | ||
2021-07-07 | Japan | Gunma | 8060 | 154 | 7863 | 43 | 36.504479 | 138.985605 | 2021-07-08 04:21:26 | Gunma, Japan | ||
2021-07-06 | United Kingdom | Isle of Man | 1643 | 29 | 1571 | 43 | 54.2361 | -4.5481 | 2021-07-07 04:21:20 | Isle of Man, United Kingdom | ||
2021-07-06 | Japan | Nara | 8260 | 132 | 8085 | 43 | 34.317451 | 135.871644 | 2021-07-07 04:21:20 | Nara, Japan | ||
2021-07-06 | Colombia | Vichada | 2502 | 40 | 2419 | 43 | 4.4234 | -69.2878 | 2021-07-07 04:21:20 | Vichada, Colombia | ||
2021-07-02 | India | Dadra and Nagar Haveli and Daman and Diu | 10565 | 4 | 10518 | 43 | 20.194742 | 73.080901 | 2021-07-03 04:21:37 | Dadra and Nagar Haveli and Daman and Diu, India | ||
2021-07-01 | India | Dadra and Nagar Haveli and Daman and Diu | 10561 | 4 | 10514 | 43 | 20.194742 | 73.080901 | 2021-07-02 04:21:47 | Dadra and Nagar Haveli and Daman and Diu, India | ||
2021-06-26 | Australia | Victoria | 20708 | 820 | 19845 | 43 | -37.8136 | 144.9631 | 2021-06-27 04:21:39 | Victoria, Australia | ||
2021-06-25 | Colombia | Vichada | 2406 | 37 | 2326 | 43 | 4.4234 | -69.2878 | 2021-06-26 04:21:43 | Vichada, Colombia | ||
2021-06-24 | Russia | Chukotka Autonomous Okrug | 797 | 8 | 746 | 43 | 66.0006475 | 169.4900869 | 2021-06-25 04:21:33 | Chukotka Autonomous Okrug, Russia | ||
2021-06-22 | Russia | Nenets Autonomous Okrug | 1162 | 5 | 1114 | 43 | 68.27557185 | 57.1686375 | 2021-06-23 04:21:46 | Nenets Autonomous Okrug, Russia | ||
2021-06-20 | Australia | Queensland | 1670 | 7 | 1620 | 43 | -27.4698 | 153.0251 | 2021-06-21 04:21:41 | Queensland, Australia | ||
2021-06-19 | Japan | Fukui | 1096 | 34 | 1019 | 43 | 35.846614 | 136.22465400000002 | 2021-06-20 04:21:48 | Fukui, Japan | ||
2021-06-16 | Japan | Miyazaki | 3053 | 27 | 2983 | 43 | 32.193203999999994 | 131.299374 | 2021-06-17 04:22:36 | Miyazaki, Japan | ||
2021-06-15 | Japan | Miyazaki | 3053 | 27 | 2983 | 43 | 32.193203999999994 | 131.299374 | 2021-06-16 04:22:32 | Miyazaki, Japan | ||
2021-06-14 | Japan | Miyazaki | 3053 | 27 | 2983 | 43 | 32.193203999999994 | 131.299374 | 2021-06-15 04:22:22 | Miyazaki, Japan | ||
2021-06-14 | Canada | Newfoundland and Labrador | 1379 | 7 | 1329 | 43 | 53.1355 | -57.6604 | 2021-06-15 04:22:22 | Newfoundland and Labrador, Canada | ||
2021-06-13 | Japan | Miyazaki | 3053 | 27 | 2983 | 43 | 32.193203999999994 | 131.299374 | 2021-06-14 04:22:46 | Miyazaki, Japan | ||
2021-06-12 | Malaysia | Perlis | 553 | 6 | 504 | 43 | 6.4449 | 100.2048 | 2021-06-13 04:22:44 | Perlis, Malaysia | ||
2021-06-03 | Denmark | Faroe Islands | 731 | 1 | 687 | 43 | 61.8926 | -6.9118 | 2021-06-04 04:23:37 | Faroe Islands, Denmark | ||
2021-05-29 | China | Guangdong | 2432 | 8 | 2381 | 43 | 23.3417 | 113.4244 | 2021-05-30 04:20:55 | Guangdong, China | ||
2021-05-29 | Barbados | 4012 | 47 | 3922 | 43 | 13.1939 | -59.5432 | 2021-05-30 04:20:55 | Barbados | |||
2021-05-24 | China | Guangdong | 2412 | 8 | 2361 | 43 | 23.3417 | 113.4244 | 2021-05-25 04:21:08 | Guangdong, China | ||
2021-05-21 | China | Guangdong | 2406 | 8 | 2355 | 43 | 23.3417 | 113.4244 | 2021-05-22 04:20:45 | Guangdong, China | ||
2021-05-17 | China | Guangdong | 2397 | 8 | 2346 | 43 | 23.3417 | 113.4244 | 2021-05-18 04:20:33 | Guangdong, China | ||
2021-05-16 | Chad | 4904 | 173 | 4688 | 43 | 15.4542 | 18.7322 | 2021-05-17 04:20:34 | Chad | |||
2021-05-10 | Russia | Jewish Autonomous Okrug | 4472 | 135 | 4294 | 43 | 48.57527615 | 132.66307460000002 | 2021-05-11 04:20:41 | Jewish Autonomous Okrug, Russia | ||
2021-05-09 | Russia | Jewish Autonomous Okrug | 4472 | 135 | 4294 | 43 | 48.57527615 | 132.66307460000002 | 2021-05-10 04:20:38 | Jewish Autonomous Okrug, Russia | ||
2021-05-08 | Colombia | Amazonas | 6192 | 238 | 5911 | 43 | -1.4429 | -71.5724 | 2021-05-09 04:20:35 | Amazonas, Colombia | ||
2021-05-07 | Monaco | 2477 | 32 | 2402 | 43 | 43.7333 | 7.4167 | 2021-05-08 04:21:04 | Monaco | |||
2021-05-03 | Japan | Shimane | 357 | 0 | 314 | 43 | 35.07076 | 132.55406399999998 | 2021-05-04 04:20:34 | Shimane, Japan | ||
2021-04-30 | Barbados | 3855 | 44 | 3768 | 43 | 13.1939 | -59.5432 | 2021-05-01 04:20:47 | Barbados | |||
2021-04-25 | Taiwan* | 1100 | 12 | 1045 | 43 | 23.7 | 121.0 | 2021-04-26 04:21:04 | Taiwan* | |||
2021-04-19 | China | Guangdong | 2319 | 8 | 2268 | 43 | 23.3417 | 113.4244 | 2021-04-20 04:20:41 | Guangdong, China | ||
2021-04-13 | Japan | Kumamoto | 3551 | 74 | 3434 | 43 | 32.608154 | 130.74523100000002 | 2021-04-14 04:20:41 | Kumamoto, Japan | ||
2021-04-11 | Japan | Yamaguchi | 1461 | 43 | 1375 | 43 | 34.201190000000004 | 131.573293 | 2021-04-12 04:21:00 | Yamaguchi, Japan | ||
2021-04-10 | Canada | Nova Scotia | 1763 | 66 | 1655 | 43 | 44.682 | -63.7443 | 2021-04-11 04:20:56 | Nova Scotia, Canada | ||
2021-04-03 | Taiwan* | 1045 | 10 | 992 | 43 | 23.7 | 121.0 | 2021-04-04 04:20:49 | Taiwan* | |||
2021-04-01 | Taiwan* | 1036 | 10 | 983 | 43 | 23.7 | 121.0 | 2021-04-02 04:20:36 | Taiwan* | |||
2021-03-30 | India | Andaman and Nicobar Islands | 5081 | 62 | 4976 | 43 | 11.225999 | 92.968178 | 2021-03-31 04:26:25 | Andaman and Nicobar Islands, India | ||
2021-03-30 | China | Shanghai | 1882 | 7 | 1832 | 43 | 31.202 | 121.4491 | 2021-03-31 04:26:25 | Shanghai, China | ||
2021-03-29 | India | Sikkim | 6227 | 135 | 6049 | 43 | 27.571671 | 88.472712 | 2021-03-30 04:26:23 | Sikkim, India | ||
2021-03-25 | China | Shanghai | 1870 | 7 | 1820 | 43 | 31.202 | 121.4491 | 2021-03-26 05:26:55 | Shanghai, China | ||
2021-03-24 | India | Tripura | 33480 | 392 | 33045 | 43 | 23.746783 | 91.743565 | 2021-03-25 05:27:00 | Tripura, India | ||
2021-03-24 | India | Sikkim | 6210 | 135 | 6032 | 43 | 27.571671 | 88.472712 | 2021-03-25 05:27:00 | Sikkim, India | ||
2021-03-23 | Japan | Ehime | 1110 | 24 | 1043 | 43 | 33.624835 | 132.856842 | 2021-03-24 05:25:40 | Ehime, Japan | ||
2021-03-23 | India | Tripura | 33479 | 392 | 33044 | 43 | 23.746783 | 91.743565 | 2021-03-24 05:25:40 | Tripura, India | ||
2021-03-17 | Canada | New Brunswick | 1477 | 30 | 1404 | 43 | 46.5653 | -66.4619 | 2021-03-18 05:26:22 | New Brunswick, Canada | ||
2021-03-16 | India | Ladakh | 9863 | 130 | 9690 | 43 | 34.1526 | 77.5771 | 2021-03-17 05:25:07 | Ladakh, India | ||
2021-03-14 | Japan | Aomori | 859 | 20 | 796 | 43 | 40.781541 | 140.828896 | 2021-03-15 05:25:51 | Aomori, Japan | ||
2021-03-11 | Liberia | 2026 | 85 | 1898 | 43 | 6.4280550000000005 | -9.429499 | 2021-03-12 05:26:50 | Liberia | |||
2021-03-11 | China | Guangdong | 2240 | 8 | 2189 | 43 | 23.3417 | 113.4244 | 2021-03-12 05:26:50 | Guangdong, China | ||
2021-03-10 | Mauritius | 641 | 10 | 588 | 43 | -20.348404 | 57.552152 | 2021-03-11 05:25:48 | Mauritius | |||
2021-03-09 | Mauritius | 641 | 10 | 588 | 43 | -20.348404 | 57.552152 | 2021-03-10 05:24:35 | Mauritius | |||
2021-03-09 | India | Ladakh | 9835 | 130 | 9662 | 43 | 34.1526 | 77.5771 | 2021-03-10 05:24:35 | Ladakh, India | ||
2021-03-08 | Mauritius | 641 | 10 | 588 | 43 | -20.348404 | 57.552152 | 2021-03-09 05:28:19 | Mauritius | |||
2021-03-07 | Mauritius | 639 | 10 | 588 | 43 | -20.348404 | 57.552152 | 2021-03-08 05:24:48 | Mauritius | |||
2021-03-06 | US | Colorado | San Juan | 8111 | 45 | 0 | 0 | 43 | 37.76248981 | -107.67632890000002 | 2021-03-07 05:21:54 | San Juan, Colorado, US |
2021-03-06 | Japan | Mie | 2564 | 57 | 2464 | 43 | 34.508018 | 136.376013 | 2021-03-07 05:21:54 | Mie, Japan | ||
2021-03-06 | Japan | Hiroshima | 5045 | 103 | 4899 | 43 | 34.605309000000005 | 132.788719 | 2021-03-07 05:21:54 | Hiroshima, Japan | ||
2021-03-06 | China | Guangdong | 2229 | 8 | 2178 | 43 | 23.3417 | 113.4244 | 2021-03-07 05:21:54 | Guangdong, China | ||
2021-03-05 | US | Colorado | San Juan | 8111 | 45 | 0 | 0 | 43 | 37.76248981 | -107.67632890000002 | 2021-03-06 04:23:41 | San Juan, Colorado, US |
2021-03-05 | Japan | Mie | 2554 | 57 | 2454 | 43 | 34.508018 | 136.376013 | 2021-03-06 04:23:41 | Mie, Japan | ||
2021-03-04 | US | Colorado | San Juan | 8111 | 45 | 0 | 0 | 43 | 37.76248981 | -107.67632890000002 | 2021-03-05 05:26:29 | San Juan, Colorado, US |
2021-03-04 | India | Ladakh | 9824 | 130 | 9651 | 43 | 34.1526 | 77.5771 | 2021-03-05 05:26:29 | Ladakh, India | ||
2021-03-03 | US | Colorado | San Juan | 8111 | 45 | 0 | 0 | 43 | 37.76248981 | -107.67632890000002 | 2021-03-04 05:24:24 | San Juan, Colorado, US |
2021-03-02 | US | Colorado | San Juan | 8111 | 45 | 0 | 0 | 43 | 37.76248981 | -107.67632890000002 | 2021-03-03 05:23:28 | San Juan, Colorado, US |
2021-02-28 | Japan | Kumamoto | 3443 | 72 | 3328 | 43 | 32.608154 | 130.74523100000002 | 2021-03-01 05:23:01 | Kumamoto, Japan | ||
2021-02-27 | Japan | Kumamoto | 3439 | 72 | 3324 | 43 | 32.608154 | 130.74523100000002 | 2021-02-28 05:22:20 | Kumamoto, Japan | ||
2021-02-27 | China | Guangdong | 2206 | 8 | 2155 | 43 | 23.3417 | 113.4244 | 2021-02-28 05:22:20 | Guangdong, China | ||
2021-02-25 | Japan | Kagoshima | 1758 | 26 | 1689 | 43 | 31.009484000000004 | 130.430665 | 2021-02-26 05:22:40 | Kagoshima, Japan |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;