daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
2,491 rows where active = 47 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date)
These facets timed out: province_or_state
country_or_region >30
- US 2,179
- Japan 69
- China 25
- Colombia 22
- Malaysia 22
- United Kingdom 17
- Canada 11
- France 11
- India 11
- Italy 10
- Russia 8
- Germany 7
- Ukraine 7
- Chile 6
- Djibouti 6
- Netherlands 6
- Bahamas 5
- Chad 5
- Equatorial Guinea 5
- Guinea-Bissau 5
- Liberia 5
- Australia 4
- Comoros 4
- Vietnam 4
- Jamaica 3
- Monaco 3
- New Zealand 3
- Papua New Guinea 3
- Barbados 2
- Cambodia 2
- …
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-08-04 | Gabon | 25440 | 165 | 25228 | 47 | -0.8037 | 11.6094 | 2021-08-05 04:21:51 | Gabon | |||
2021-08-03 | China | Fujian | 748 | 1 | 700 | 47 | 26.0789 | 117.9874 | 2021-08-04 04:21:25 | Fujian, China | ||
2021-07-24 | China | Jiangsu | 790 | 0 | 743 | 47 | 32.9711 | 119.455 | 2021-07-25 04:22:12 | Jiangsu, China | ||
2021-07-23 | Chile | Aysen | 8035 | 69 | 7919 | 47 | -45.9864 | -73.7669 | 2021-07-24 00:21:36 | Aysen, Chile | ||
2021-07-22 | Japan | Mie | 5539 | 113 | 5379 | 47 | 34.508018 | 136.376013 | 2021-07-23 04:21:29 | Mie, Japan | ||
2021-07-21 | Ukraine | Ternopil Oblast | 70133 | 1204 | 68882 | 47 | 49.5535 | 25.5948 | 2021-07-22 04:21:19 | Ternopil Oblast, Ukraine | ||
2021-07-19 | Japan | Kumamoto | 6533 | 120 | 6366 | 47 | 32.608154 | 130.74523100000002 | 2021-07-20 04:21:48 | Kumamoto, Japan | ||
2021-07-18 | New Zealand | 2817 | 28 | 2744 | 47 | -40.9006 | 174.886 | 2021-07-19 04:21:24 | New Zealand | |||
2021-07-18 | Japan | Kumamoto | 6532 | 119 | 6366 | 47 | 32.608154 | 130.74523100000002 | 2021-07-19 04:21:24 | Kumamoto, Japan | ||
2021-07-17 | Barbados | 4251 | 48 | 4156 | 47 | 13.1939 | -59.5432 | 2021-07-18 04:22:07 | Barbados | |||
2021-07-14 | Japan | Yamagata | 2072 | 47 | 1978 | 47 | 38.448396 | 140.102154 | 2021-07-15 04:21:48 | Yamagata, Japan | ||
2021-07-12 | Japan | Yamagata | 2067 | 47 | 1973 | 47 | 38.448396 | 140.102154 | 2021-07-13 04:21:18 | Yamagata, Japan | ||
2021-07-11 | Monaco | 2622 | 33 | 2542 | 47 | 43.7333 | 7.4167 | 2021-07-12 04:21:34 | Monaco | |||
2021-07-10 | Monaco | 2622 | 33 | 2542 | 47 | 43.7333 | 7.4167 | 2021-07-11 04:21:43 | Monaco | |||
2021-07-09 | Italy | P.A. Trento | 45803 | 1363 | 44393 | 47 | 46.06893511 | 11.12123097 | 2021-07-10 04:21:25 | P.A. Trento, Italy | ||
2021-07-09 | Colombia | Vichada | 2517 | 41 | 2429 | 47 | 4.4234 | -69.2878 | 2021-07-10 04:21:25 | Vichada, Colombia | ||
2021-07-09 | China | Fujian | 692 | 1 | 644 | 47 | 26.0789 | 117.9874 | 2021-07-10 04:21:25 | Fujian, China | ||
2021-07-07 | Japan | Yamaguchi | 3163 | 80 | 3036 | 47 | 34.201190000000004 | 131.573293 | 2021-07-08 04:21:26 | Yamaguchi, Japan | ||
2021-07-07 | Italy | P.A. Trento | 45796 | 1363 | 44386 | 47 | 46.06893511 | 11.12123097 | 2021-07-08 04:21:26 | P.A. Trento, Italy | ||
2021-07-04 | Colombia | Amazonas | 6414 | 244 | 6123 | 47 | -1.4429 | -71.5724 | 2021-07-05 04:21:28 | Amazonas, Colombia | ||
2021-07-02 | China | Shanghai | 2211 | 7 | 2157 | 47 | 31.202 | 121.4491 | 2021-07-03 04:21:37 | Shanghai, China | ||
2021-07-02 | Canada | Nova Scotia | 5842 | 92 | 5703 | 47 | 44.682 | -63.7443 | 2021-07-03 04:21:37 | Nova Scotia, Canada | ||
2021-07-01 | Colombia | Amazonas | 6405 | 244 | 6114 | 47 | -1.4429 | -71.5724 | 2021-07-02 04:21:47 | Amazonas, Colombia | ||
2021-07-01 | China | Shanghai | 2207 | 7 | 2153 | 47 | 31.202 | 121.4491 | 2021-07-02 04:21:47 | Shanghai, China | ||
2021-06-30 | Colombia | Amazonas | 6400 | 244 | 6109 | 47 | -1.4429 | -71.5724 | 2021-07-01 04:21:19 | Amazonas, Colombia | ||
2021-06-29 | Japan | Aomori | 2490 | 31 | 2412 | 47 | 40.781541 | 140.828896 | 2021-06-30 04:21:41 | Aomori, Japan | ||
2021-06-27 | Russia | Chukotka Autonomous Okrug | 806 | 8 | 751 | 47 | 66.0006475 | 169.4900869 | 2021-06-28 04:21:29 | Chukotka Autonomous Okrug, Russia | ||
2021-06-27 | China | Zhejiang | 1385 | 1 | 1337 | 47 | 29.1832 | 120.0934 | 2021-06-28 04:21:29 | Zhejiang, China | ||
2021-06-26 | China | Zhejiang | 1385 | 1 | 1337 | 47 | 29.1832 | 120.0934 | 2021-06-27 04:21:39 | Zhejiang, China | ||
2021-06-25 | China | Zhejiang | 1385 | 1 | 1337 | 47 | 29.1832 | 120.0934 | 2021-06-26 04:21:43 | Zhejiang, China | ||
2021-06-24 | Japan | Oita | 3489 | 62 | 3380 | 47 | 33.200697 | 131.43323999999998 | 2021-06-25 04:21:33 | Oita, Japan | ||
2021-06-23 | Japan | Oita | 3487 | 62 | 3378 | 47 | 33.200697 | 131.43323999999998 | 2021-06-24 04:21:55 | Oita, Japan | ||
2021-06-23 | China | Fujian | 661 | 1 | 613 | 47 | 26.0789 | 117.9874 | 2021-06-24 04:21:55 | Fujian, China | ||
2021-06-21 | Colombia | Vichada | 2311 | 36 | 2228 | 47 | 4.4234 | -69.2878 | 2021-06-22 04:21:34 | Vichada, Colombia | ||
2021-06-12 | Japan | Nara | 7942 | 120 | 7775 | 47 | 34.317451 | 135.871644 | 2021-06-13 04:22:44 | Nara, Japan | ||
2021-06-11 | Malaysia | Perlis | 548 | 6 | 495 | 47 | 6.4449 | 100.2048 | 2021-06-12 04:22:22 | Perlis, Malaysia | ||
2021-06-06 | Japan | Shimane | 545 | 0 | 498 | 47 | 35.07076 | 132.55406399999998 | 2021-06-07 04:22:51 | Shimane, Japan | ||
2021-06-04 | Denmark | Faroe Islands | 739 | 1 | 691 | 47 | 61.8926 | -6.9118 | 2021-06-05 04:23:03 | Faroe Islands, Denmark | ||
2021-06-01 | Netherlands | Aruba | 10993 | 107 | 10839 | 47 | 12.5211 | -69.9683 | 2021-06-02 04:24:34 | Aruba, Netherlands | ||
2021-05-28 | Japan | Tottori | 463 | 2 | 414 | 47 | 35.359069 | 133.863619 | 2021-05-29 04:20:41 | Tottori, Japan | ||
2021-05-27 | Colombia | Amazonas | 6325 | 240 | 6038 | 47 | -1.4429 | -71.5724 | 2021-05-28 04:20:36 | Amazonas, Colombia | ||
2021-05-26 | Colombia | Amazonas | 6319 | 240 | 6032 | 47 | -1.4429 | -71.5724 | 2021-05-27 04:20:59 | Amazonas, Colombia | ||
2021-05-24 | Colombia | Guainia | 1641 | 22 | 1572 | 47 | 2.5854 | -68.5247 | 2021-05-25 04:21:08 | Guainia, Colombia | ||
2021-05-18 | Eswatini | 18525 | 672 | 17806 | 47 | -26.5225 | 31.4659 | 2021-05-19 04:20:42 | Eswatini | |||
2021-05-18 | Colombia | Guainia | 1550 | 22 | 1481 | 47 | 2.5854 | -68.5247 | 2021-05-19 04:20:42 | Guainia, Colombia | ||
2021-05-16 | Japan | Kochi | 1150 | 20 | 1083 | 47 | 33.422519 | 133.367307 | 2021-05-17 04:20:34 | Kochi, Japan | ||
2021-05-16 | Colombia | Amazonas | 6274 | 238 | 5989 | 47 | -1.4429 | -71.5724 | 2021-05-17 04:20:34 | Amazonas, Colombia | ||
2021-05-14 | Eswatini | 18511 | 671 | 17793 | 47 | -26.5225 | 31.4659 | 2021-05-15 04:20:58 | Eswatini | |||
2021-05-14 | Chad | 4897 | 173 | 4677 | 47 | 15.4542 | 18.7322 | 2021-05-15 04:20:58 | Chad | |||
2021-05-13 | Japan | Shimane | 406 | 0 | 359 | 47 | 35.07076 | 132.55406399999998 | 2021-05-14 04:20:41 | Shimane, Japan | ||
2021-05-11 | Colombia | Amazonas | 6202 | 238 | 5917 | 47 | -1.4429 | -71.5724 | 2021-05-12 04:21:29 | Amazonas, Colombia | ||
2021-05-06 | Russia | Jewish Autonomous Okrug | 4470 | 133 | 4290 | 47 | 48.57527615 | 132.66307460000002 | 2021-05-07 04:20:40 | Jewish Autonomous Okrug, Russia | ||
2021-05-06 | Canada | Northwest Territories | 98 | 0 | 57 | 47 | 64.8255 | -124.8457 | 2021-05-07 04:20:40 | Northwest Territories,Canada | ||
2021-05-05 | Japan | Tottori | 380 | 2 | 331 | 47 | 35.359069 | 133.863619 | 2021-05-06 04:20:38 | Tottori, Japan | ||
2021-05-05 | China | Yunnan | 347 | 2 | 298 | 47 | 24.974 | 101.487 | 2021-05-06 04:20:38 | Yunnan, China | ||
2021-04-30 | Australia | Queensland | 1561 | 7 | 1507 | 47 | -27.4698 | 153.0251 | 2021-05-01 04:20:47 | Queensland, Australia | ||
2021-04-26 | Canada | Nunavut | 464 | 4 | 413 | 47 | 70.2998 | -83.1076 | 2021-04-27 04:20:52 | Nunavut, Canada | ||
2021-04-25 | Canada | Nunavut | 455 | 4 | 404 | 47 | 70.2998 | -83.1076 | 2021-04-26 04:21:04 | Nunavut, Canada | ||
2021-04-21 | Russia | Nenets Autonomous Okrug | 1093 | 4 | 1042 | 47 | 68.27557185 | 57.1686375 | 2021-04-22 04:20:53 | Nenets Autonomous Okrug, Russia | ||
2021-04-18 | Japan | Oita | 1378 | 22 | 1309 | 47 | 33.200697 | 131.43323999999998 | 2021-04-19 04:20:57 | Oita, Japan | ||
2021-04-18 | China | Guangdong | 2319 | 8 | 2264 | 47 | 23.3417 | 113.4244 | 2021-04-19 04:20:57 | Guangdong, China | ||
2021-04-17 | Japan | Oita | 1373 | 22 | 1304 | 47 | 33.200697 | 131.43323999999998 | 2021-04-18 04:20:41 | Oita, Japan | ||
2021-04-17 | China | Guangdong | 2317 | 8 | 2262 | 47 | 23.3417 | 113.4244 | 2021-04-18 04:20:41 | Guangdong, China | ||
2021-04-14 | Japan | Akita | 344 | 9 | 288 | 47 | 39.748679 | 140.408228 | 2021-04-15 04:20:54 | Akita, Japan | ||
2021-04-11 | Sao Tome and Principe | 2266 | 35 | 2184 | 47 | 0.1864 | 6.6131 | 2021-04-12 04:21:00 | Sao Tome and Principe | |||
2021-04-10 | Japan | Yamaguchi | 1458 | 43 | 1368 | 47 | 34.201190000000004 | 131.573293 | 2021-04-11 04:20:56 | Yamaguchi, Japan | ||
2021-04-04 | Japan | Kagoshima | 1855 | 28 | 1780 | 47 | 31.009484000000004 | 130.430665 | 2021-04-05 04:20:35 | Kagoshima, Japan | ||
2021-04-04 | China | Shanghai | 1900 | 7 | 1846 | 47 | 31.202 | 121.4491 | 2021-04-05 04:20:35 | Shanghai, China | ||
2021-03-31 | India | Sikkim | 6235 | 135 | 6053 | 47 | 27.571671 | 88.472712 | 2021-04-01 04:27:05 | Sikkim, India | ||
2021-03-28 | India | Tripura | 33491 | 392 | 33052 | 47 | 23.746783 | 91.743565 | 2021-03-29 04:28:35 | Tripura, India | ||
2021-03-27 | China | Shanghai | 1878 | 7 | 1824 | 47 | 31.202 | 121.4491 | 2021-03-28 05:28:10 | Shanghai, China | ||
2021-03-23 | Belize | 12410 | 316 | 12047 | 47 | 17.1899 | -88.4976 | 2021-03-24 05:25:40 | Belize | |||
2021-03-22 | Comoros | 3666 | 146 | 3473 | 47 | -11.6455 | 43.3333 | 2021-03-23 05:26:18 | Comoros | |||
2021-03-21 | Comoros | 3666 | 146 | 3473 | 47 | -11.6455 | 43.3333 | 2021-03-22 05:25:43 | Comoros | |||
2021-03-20 | Comoros | 3666 | 146 | 3473 | 47 | -11.6455 | 43.3333 | 2021-03-21 05:25:44 | Comoros | |||
2021-03-19 | Japan | Saga | 1155 | 11 | 1097 | 47 | 33.286977 | 130.115738 | 2021-03-20 05:25:46 | Saga, Japan | ||
2021-03-17 | Comoros | 3652 | 146 | 3459 | 47 | -11.6455 | 43.3333 | 2021-03-18 05:26:22 | Comoros | |||
2021-03-15 | Japan | Aomori | 863 | 20 | 796 | 47 | 40.781541 | 140.828896 | 2021-03-16 05:25:13 | Aomori, Japan | ||
2021-03-13 | India | Sikkim | 6184 | 135 | 6002 | 47 | 27.571671 | 88.472712 | 2021-03-14 05:25:37 | Sikkim, India | ||
2021-03-08 | Liberia | 2024 | 85 | 1892 | 47 | 6.4280550000000005 | -9.429499 | 2021-03-09 05:28:19 | Liberia | |||
2021-03-07 | Liberia | 2024 | 85 | 1892 | 47 | 6.4280550000000005 | -9.429499 | 2021-03-08 05:24:48 | Liberia | |||
2021-03-05 | Malaysia | W.P. Putrajaya | 1083 | 8 | 1028 | 47 | 2.9264 | 101.6964 | 2021-03-06 04:23:41 | W.P. Putrajaya, Malaysia | ||
2021-03-04 | China | Guangdong | 2222 | 8 | 2167 | 47 | 23.3417 | 113.4244 | 2021-03-05 05:26:29 | Guangdong, China | ||
2021-03-03 | US | Nebraska | Keya Paha | 31103 | 47 | 0 | 0 | 47 | 42.87990694 | -99.71343729 | 2021-03-04 05:24:24 | Keya Paha, Nebraska, US |
2021-03-03 | Japan | Saga | 1069 | 8 | 1014 | 47 | 33.286977 | 130.115738 | 2021-03-04 05:24:24 | Saga, Japan | ||
2021-03-03 | Japan | Hiroshima | 5036 | 102 | 4887 | 47 | 34.605309000000005 | 132.788719 | 2021-03-04 05:24:24 | Hiroshima, Japan | ||
2021-03-03 | China | Guangdong | 2221 | 8 | 2166 | 47 | 23.3417 | 113.4244 | 2021-03-04 05:24:24 | Guangdong, China | ||
2021-03-02 | US | Nebraska | Keya Paha | 31103 | 47 | 0 | 0 | 47 | 42.87990694 | -99.71343729 | 2021-03-03 05:23:28 | Keya Paha, Nebraska, US |
2021-03-01 | US | Nebraska | Keya Paha | 31103 | 47 | 0 | 0 | 47 | 42.87990694 | -99.71343729 | 2021-03-02 05:23:30 | Keya Paha, Nebraska, US |
2021-02-28 | US | Nebraska | Keya Paha | 31103 | 47 | 0 | 0 | 47 | 42.87990694 | -99.71343729 | 2021-03-01 05:23:01 | Keya Paha, Nebraska, US |
2021-02-27 | US | Nebraska | Keya Paha | 31103 | 47 | 0 | 0 | 47 | 42.87990694 | -99.71343729 | 2021-02-28 05:22:20 | Keya Paha, Nebraska, US |
2021-02-26 | Japan | Kumamoto | 3439 | 72 | 3320 | 47 | 32.608154 | 130.74523100000002 | 2021-02-27 05:22:28 | Kumamoto, Japan | ||
2021-02-24 | Japan | Nagasaki | 1609 | 36 | 1526 | 47 | 33.235712 | 129.608033 | 2021-02-25 05:24:57 | Nagasaki, Japan | ||
2021-02-24 | India | Sikkim | 6132 | 135 | 5950 | 47 | 27.571671 | 88.472712 | 2021-02-25 05:24:57 | Sikkim, India | ||
2021-02-23 | US | Nebraska | Keya Paha | 31103 | 47 | 0 | 0 | 47 | 42.87990694 | -99.71343729 | 2021-02-24 05:29:16 | Keya Paha, Nebraska, US |
2021-02-23 | US | Colorado | Unassigned | 90008 | 59 | 0 | 0 | 47 | 40.87595412 | 0.0 | 2021-02-24 05:29:16 | Unassigned, Colorado, US |
2021-02-23 | Netherlands | Sint Maarten | 2047 | 27 | 1973 | 47 | 18.0425 | -63.0548 | 2021-02-24 05:29:16 | Sint Maarten, Netherlands | ||
2021-02-23 | India | Tripura | 33400 | 391 | 32962 | 47 | 23.746783 | 91.743565 | 2021-02-24 05:29:16 | Tripura, India | ||
2021-02-23 | India | Sikkim | 6132 | 135 | 5950 | 47 | 27.571671 | 88.472712 | 2021-02-24 05:29:16 | Sikkim, India | ||
2021-02-23 | China | Guangdong | 2196 | 8 | 2141 | 47 | 23.3417 | 113.4244 | 2021-02-24 05:29:16 | Guangdong, China |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;