johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
2,528 rows where active = 53 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,206
- Japan 71
- China 26
- United Kingdom 20
- Colombia 19
- Malaysia 18
- India 17
- Russia 14
- Australia 13
- Italy 11
- Ukraine 10
- Barbados 7
- Germany 7
- Mexico 7
- Canada 6
- Eritrea 5
- Netherlands 5
- Uganda 5
- Chile 4
- France 4
- New Zealand 4
- Cambodia 3
- Chad 3
- Niger 3
- Botswana 2
- Denmark 2
- Fiji 2
- Georgia 2
- Grenada 2
- Liberia 2
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
335555 | 335555 | 2021-08-04 | United Kingdom | Bermuda | 2589 | 33 | 2503 | 53 | 32.3078 | -64.7505 | 2021-08-05 04:21:51 | Bermuda, United Kingdom | ||
332176 | 332176 | 2021-08-04 | Saint Vincent and the Grenadines | 2298 | 12 | 2233 | 53 | 12.9843 | -61.2872 | 2021-08-05 04:21:51 | Saint Vincent and the Grenadines | |||
331907 | 331907 | 2021-08-04 | Japan | Akita | 1038 | 20 | 965 | 53 | 39.748679 | 140.408228 | 2021-08-05 04:21:51 | Akita, Japan | ||
3471826 | 3471826 | 2021-08-03 | United Kingdom | Bermuda | 2589 | 33 | 2503 | 53 | 32.3078 | -64.7505 | 2021-08-04 04:21:25 | Bermuda, United Kingdom | ||
3015140 | 3015140 | 2021-08-01 | Chile | Magallanes | 29134 | 485 | 28596 | 53 | -52.368 | -70.9863 | 2021-08-02 04:21:36 | Magallanes, Chile | ||
3296036 | 3296036 | 2021-07-30 | Colombia | San Andres y Providencia | 6724 | 133 | 6538 | 53 | 12.5567 | -81.7185 | 2021-07-31 04:21:35 | San Andres y Providencia, Colombia | ||
3385414 | 3385414 | 2021-07-29 | Japan | Nagano | 5218 | 94 | 5071 | 53 | 36.132134 | 138.045528 | 2021-07-30 04:21:34 | Nagano, Japan | ||
408159 | 408159 | 2021-07-28 | Colombia | Vichada | 2820 | 45 | 2722 | 53 | 4.4234 | -69.2878 | 2021-07-29 04:21:33 | Vichada, Colombia | ||
1382150 | 1382150 | 2021-07-25 | Ukraine | Volyn Oblast | 62272 | 1204 | 61015 | 53 | 50.7472 | 25.3254 | 2021-07-26 04:21:28 | Volyn Oblast, Ukraine | ||
3479952 | 3479952 | 2021-07-22 | Ukraine | Ternopil Oblast | 70139 | 1204 | 68882 | 53 | 49.5535 | 25.5948 | 2021-07-23 04:21:29 | Ternopil Oblast, Ukraine | ||
3476351 | 3476351 | 2021-07-22 | Japan | Tokushima | 1721 | 63 | 1605 | 53 | 33.919178 | 134.242091 | 2021-07-23 04:21:29 | Tokushima, Japan | ||
3476080 | 3476080 | 2021-07-22 | Canada | Newfoundland and Labrador | 1437 | 7 | 1377 | 53 | 53.1355 | -57.6604 | 2021-07-23 04:21:29 | Newfoundland and Labrador, Canada | ||
3331567 | 3331567 | 2021-07-21 | Japan | Shimane | 625 | 2 | 570 | 53 | 35.07076 | 132.55406399999998 | 2021-07-22 04:21:19 | Shimane, Japan | ||
3331534 | 3331534 | 2021-07-21 | Japan | Ehime | 2808 | 75 | 2680 | 53 | 33.624835 | 132.856842 | 2021-07-22 04:21:19 | Ehime, Japan | ||
3331299 | 3331299 | 2021-07-21 | Canada | Newfoundland and Labrador | 1437 | 7 | 1377 | 53 | 53.1355 | -57.6604 | 2021-07-22 04:21:19 | Newfoundland and Labrador, Canada | ||
3331228 | 3331228 | 2021-07-21 | Australia | Queensland | 1761 | 7 | 1701 | 53 | -27.4698 | 153.0251 | 2021-07-22 04:21:19 | Queensland, Australia | ||
2371559 | 2371559 | 2021-07-20 | Japan | Yamanashi | 2197 | 21 | 2123 | 53 | 35.612364 | 138.61148899999998 | 2021-07-21 04:21:40 | Yamanashi, Japan | ||
2371280 | 2371280 | 2021-07-20 | Canada | Newfoundland and Labrador | 1437 | 7 | 1377 | 53 | 53.1355 | -57.6604 | 2021-07-21 04:21:40 | Newfoundland and Labrador, Canada | ||
2371209 | 2371209 | 2021-07-20 | Australia | Queensland | 1761 | 7 | 1701 | 53 | -27.4698 | 153.0251 | 2021-07-21 04:21:40 | Queensland, Australia | ||
3706171 | 3706171 | 2021-07-17 | Japan | Yamagata | 2084 | 47 | 1984 | 53 | 38.448396 | 140.102154 | 2021-07-18 04:22:07 | Yamagata, Japan | ||
3706066 | 3706066 | 2021-07-17 | India | Chandigarh | 61870 | 809 | 61008 | 53 | 30.733839 | 76.76827800000002 | 2021-07-18 04:22:07 | Chandigarh, India | ||
2947402 | 2947402 | 2021-07-16 | Japan | Yamagata | 2081 | 47 | 1981 | 53 | 38.448396 | 140.102154 | 2021-07-17 04:22:22 | Yamagata, Japan | ||
2693716 | 2693716 | 2021-07-06 | Japan | Niigata | 3434 | 52 | 3329 | 53 | 37.521819 | 138.918647 | 2021-07-07 04:21:20 | Niigata, Japan | ||
1932427 | 1932427 | 2021-07-05 | Italy | P.A. Trento | 45791 | 1363 | 44375 | 53 | 46.06893511 | 11.12123097 | 2021-07-06 04:21:32 | P.A. Trento, Italy | ||
1932260 | 1932260 | 2021-07-05 | China | Shanghai | 2222 | 7 | 2162 | 53 | 31.202 | 121.4491 | 2021-07-06 04:21:32 | Shanghai, China | ||
1164939 | 1164939 | 2021-07-04 | Canada | Nova Scotia | 5853 | 92 | 5708 | 53 | 44.682 | -63.7443 | 2021-07-05 04:21:28 | Nova Scotia, Canada | ||
2764763 | 2764763 | 2021-07-01 | China | Yunnan | 419 | 2 | 364 | 53 | 24.974 | 101.487 | 2021-07-02 04:21:47 | Yunnan, China | ||
2764621 | 2764621 | 2021-07-01 | Albania | 132523 | 2456 | 130014 | 53 | 41.1533 | 20.1683 | 2021-07-02 04:21:47 | Albania | |||
1893156 | 1893156 | 2021-06-30 | Japan | Iwate | 1679 | 46 | 1580 | 53 | 39.593287 | 141.361777 | 2021-07-01 04:21:19 | Iwate, Japan | ||
1892971 | 1892971 | 2021-06-30 | China | Yunnan | 419 | 2 | 364 | 53 | 24.974 | 101.487 | 2021-07-01 04:21:19 | Yunnan, China | ||
400279 | 400279 | 2021-06-29 | Japan | Iwate | 1670 | 46 | 1571 | 53 | 39.593287 | 141.361777 | 2021-06-30 04:21:41 | Iwate, Japan | ||
400065 | 400065 | 2021-06-29 | China | Fujian | 677 | 1 | 623 | 53 | 26.0789 | 117.9874 | 2021-06-30 04:21:41 | Fujian, China | ||
3958735 | 3958735 | 2021-06-26 | Russia | Nenets Autonomous Okrug | 1186 | 5 | 1128 | 53 | 68.27557185 | 57.1686375 | 2021-06-27 04:21:39 | Nenets Autonomous Okrug, Russia | ||
3958533 | 3958533 | 2021-06-26 | Japan | Nara | 8133 | 129 | 7951 | 53 | 34.317451 | 135.871644 | 2021-06-27 04:21:39 | Nara, Japan | ||
3958521 | 3958521 | 2021-06-26 | Japan | Iwate | 1659 | 46 | 1560 | 53 | 39.593287 | 141.361777 | 2021-06-27 04:21:39 | Iwate, Japan | ||
2884397 | 2884397 | 2021-06-20 | Japan | Oita | 3481 | 61 | 3367 | 53 | 33.200697 | 131.43323999999998 | 2021-06-21 04:21:41 | Oita, Japan | ||
1564117 | 1564117 | 2021-06-14 | Japan | Nagano | 4936 | 89 | 4794 | 53 | 36.132134 | 138.045528 | 2021-06-15 04:22:22 | Nagano, Japan | ||
1563793 | 1563793 | 2021-06-14 | Australia | Victoria | 20668 | 820 | 19795 | 53 | -37.8136 | 144.9631 | 2021-06-15 04:22:22 | Victoria, Australia | ||
522722 | 522722 | 2021-06-09 | Colombia | Vichada | 2095 | 31 | 2011 | 53 | 4.4234 | -69.2878 | 2021-06-10 04:23:17 | Vichada, Colombia | ||
2586025 | 2586025 | 2021-06-05 | Japan | Shimane | 545 | 0 | 492 | 53 | 35.07076 | 132.55406399999998 | 2021-06-06 04:24:03 | Shimane, Japan | ||
2585992 | 2585992 | 2021-06-05 | Japan | Ehime | 2726 | 74 | 2599 | 53 | 33.624835 | 132.856842 | 2021-06-06 04:24:03 | Ehime, Japan | ||
1188806 | 1188806 | 2021-05-31 | Liberia | 2179 | 86 | 2040 | 53 | 6.4280550000000005 | -9.429499 | 2021-06-01 04:23:09 | Liberia | |||
3089123 | 3089123 | 2021-05-30 | Australia | Victoria | 20598 | 820 | 19725 | 53 | -37.8136 | 144.9631 | 2021-05-31 03:08:59 | Victoria, Australia | ||
1416737 | 1416737 | 2021-05-24 | Malaysia | Perlis | 443 | 4 | 386 | 53 | 6.4449 | 100.2048 | 2021-05-25 04:21:08 | Perlis, Malaysia | ||
1413062 | 1413062 | 2021-05-24 | Japan | Fukui | 1024 | 34 | 937 | 53 | 35.846614 | 136.22465400000002 | 2021-05-25 04:21:08 | Fukui, Japan | ||
1913044 | 1913044 | 2021-05-20 | Colombia | Amazonas | 6300 | 238 | 6009 | 53 | -1.4429 | -71.5724 | 2021-05-21 04:20:43 | Amazonas, Colombia | ||
2390603 | 2390603 | 2021-05-18 | Colombia | Amazonas | 6296 | 238 | 6005 | 53 | -1.4429 | -71.5724 | 2021-05-19 04:20:42 | Amazonas, Colombia | ||
1872993 | 1872993 | 2021-05-15 | Japan | Shimane | 424 | 0 | 371 | 53 | 35.07076 | 132.55406399999998 | 2021-05-16 04:20:49 | Shimane, Japan | ||
1872846 | 1872846 | 2021-05-15 | Fiji | 166 | 4 | 109 | 53 | -17.7134 | 178.065 | 2021-05-16 04:20:49 | Fiji | |||
1872759 | 1872759 | 2021-05-15 | China | Guangdong | 2392 | 8 | 2331 | 53 | 23.3417 | 113.4244 | 2021-05-16 04:20:49 | Guangdong, China | ||
1081962 | 1081962 | 2021-05-14 | Japan | Shimane | 414 | 0 | 361 | 53 | 35.07076 | 132.55406399999998 | 2021-05-15 04:20:58 | Shimane, Japan | ||
1081815 | 1081815 | 2021-05-14 | Fiji | 166 | 4 | 109 | 53 | -17.7134 | 178.065 | 2021-05-15 04:20:58 | Fiji | |||
1552013 | 1552013 | 2021-05-08 | Japan | Tottori | 394 | 2 | 339 | 53 | 35.359069 | 133.863619 | 2021-05-09 04:20:35 | Tottori, Japan | ||
3113288 | 3113288 | 2021-05-06 | China | Guangdong | 2365 | 8 | 2304 | 53 | 23.3417 | 113.4244 | 2021-05-07 04:20:40 | Guangdong, China | ||
3113193 | 3113193 | 2021-05-06 | Barbados | 3929 | 45 | 3831 | 53 | 13.1939 | -59.5432 | 2021-05-07 04:20:40 | Barbados | |||
2761028 | 2761028 | 2021-05-03 | Monaco | 2465 | 32 | 2380 | 53 | 43.7333 | 7.4167 | 2021-05-04 04:20:34 | Monaco | |||
2824615 | 2824615 | 2021-05-01 | China | Yunnan | 344 | 2 | 289 | 53 | 24.974 | 101.487 | 2021-05-02 04:20:48 | Yunnan, China | ||
380462 | 380462 | 2021-04-30 | San Marino | 5060 | 90 | 4917 | 53 | 43.9424 | 12.4578 | 2021-05-01 04:20:47 | San Marino | |||
1636515 | 1636515 | 2021-04-29 | Russia | Jewish Autonomous Okrug | 4468 | 130 | 4285 | 53 | 48.57527615 | 132.66307460000002 | 2021-04-30 04:21:03 | Jewish Autonomous Okrug, Russia | ||
3393594 | 3393594 | 2021-04-28 | Russia | Jewish Autonomous Okrug | 4468 | 130 | 4285 | 53 | 48.57527615 | 132.66307460000002 | 2021-04-29 04:20:55 | Jewish Autonomous Okrug, Russia | ||
3393092 | 3393092 | 2021-04-28 | Australia | Northern Territory | 165 | 0 | 112 | 53 | -12.4634 | 130.8456 | 2021-04-29 04:20:55 | Northern Territory, Australia | ||
3702130 | 3702130 | 2021-04-27 | Japan | Kochi | 1010 | 19 | 938 | 53 | 33.422519 | 133.367307 | 2021-04-28 04:20:32 | Kochi, Japan | ||
3701808 | 3701808 | 2021-04-27 | Australia | Northern Territory | 165 | 0 | 112 | 53 | -12.4634 | 130.8456 | 2021-04-28 04:20:32 | Northern Territory, Australia | ||
887952 | 887952 | 2021-04-26 | Colombia | Amazonas | 6103 | 235 | 5815 | 53 | -1.4429 | -71.5724 | 2021-04-27 04:20:52 | Amazonas, Colombia | ||
887817 | 887817 | 2021-04-26 | Australia | Northern Territory | 164 | 0 | 111 | 53 | -12.4634 | 130.8456 | 2021-04-27 04:20:52 | Northern Territory, Australia | ||
954697 | 954697 | 2021-04-25 | Colombia | Amazonas | 6101 | 235 | 5813 | 53 | -1.4429 | -71.5724 | 2021-04-26 04:21:04 | Amazonas, Colombia | ||
954562 | 954562 | 2021-04-25 | Australia | Northern Territory | 164 | 0 | 111 | 53 | -12.4634 | 130.8456 | 2021-04-26 04:21:04 | Northern Territory, Australia | ||
170061 | 170061 | 2021-04-16 | Japan | Kagoshima | 1946 | 28 | 1865 | 53 | 31.009484000000004 | 130.430665 | 2021-04-17 04:20:40 | Kagoshima, Japan | ||
170045 | 170045 | 2021-04-16 | Japan | Akita | 356 | 9 | 294 | 53 | 39.748679 | 140.408228 | 2021-04-17 04:20:40 | Akita, Japan | ||
2571727 | 2571727 | 2021-04-13 | Japan | Yamanashi | 1036 | 19 | 964 | 53 | 35.612364 | 138.61148899999998 | 2021-04-14 04:20:41 | Yamanashi, Japan | ||
36253 | 36253 | 2021-04-12 | China | Shanghai | 1926 | 7 | 1866 | 53 | 31.202 | 121.4491 | 2021-04-13 04:20:37 | Shanghai, China | ||
605723 | 605723 | 2021-04-09 | Japan | Saga | 1253 | 13 | 1187 | 53 | 33.286977 | 130.115738 | 2021-04-10 04:20:59 | Saga, Japan | ||
2247349 | 2247349 | 2021-04-07 | India | Lakshadweep | 770 | 1 | 716 | 53 | 13.6999972 | 72.18333259999999 | 2021-04-08 04:21:13 | Lakshadweep, India | ||
3085236 | 3085236 | 2021-04-05 | India | Andaman and Nicobar Islands | 5116 | 62 | 5001 | 53 | 11.225999 | 92.968178 | 2021-04-06 04:20:32 | Andaman and Nicobar Islands, India | ||
391911 | 391911 | 2021-04-04 | Malaysia | W.P. Putrajaya | 1172 | 8 | 1111 | 53 | 2.9264 | 101.6964 | 2021-04-05 04:20:35 | W.P. Putrajaya, Malaysia | ||
3710153 | 3710153 | 2021-04-03 | Japan | Ishikawa | 1941 | 64 | 1824 | 53 | 36.769464 | 136.771027 | 2021-04-04 04:20:49 | Ishikawa, Japan | ||
637966 | 637966 | 2021-03-31 | Japan | Tottori | 260 | 2 | 205 | 53 | 35.359069 | 133.863619 | 2021-04-01 04:27:05 | Tottori, Japan | ||
1223181 | 1223181 | 2021-03-27 | Uganda | 40767 | 335 | 40379 | 53 | 1.373333 | 32.290275 | 2021-03-28 05:28:10 | Uganda | |||
2780951 | 2780951 | 2021-03-24 | India | Manipur | 29362 | 374 | 28935 | 53 | 24.738975 | 93.882541 | 2021-03-25 05:27:00 | Manipur, India | ||
1744504 | 1744504 | 2021-03-20 | India | Sikkim | 6204 | 135 | 6016 | 53 | 27.571671 | 88.472712 | 2021-03-21 05:25:44 | Sikkim, India | ||
3420872 | 3420872 | 2021-03-19 | India | Ladakh | 9881 | 130 | 9698 | 53 | 34.1526 | 77.5771 | 2021-03-20 05:25:46 | Ladakh, India | ||
3670247 | 3670247 | 2021-03-06 | US | Oregon | Sherman | 41055 | 53 | 0 | 0 | 53 | 45.41501554 | -120.6827834 | 2021-03-07 05:21:54 | Sherman, Oregon, US |
3670230 | 3670230 | 2021-03-06 | US | Oregon | Gilliam | 41021 | 54 | 1 | 0 | 53 | 45.37160076 | -120.2048869 | 2021-03-07 05:21:54 | Gilliam, Oregon, US |
3670000 | 3670000 | 2021-03-06 | US | North Dakota | Billings | 38007 | 54 | 0 | 0 | 53 | 47.02366884 | -103.3762965 | 2021-03-07 05:21:54 | Billings, North Dakota, US |
1618868 | 1618868 | 2021-03-05 | US | Oregon | Sherman | 41055 | 53 | 0 | 0 | 53 | 45.41501554 | -120.6827834 | 2021-03-06 04:23:41 | Sherman, Oregon, US |
1618851 | 1618851 | 2021-03-05 | US | Oregon | Gilliam | 41021 | 54 | 1 | 0 | 53 | 45.37160076 | -120.2048869 | 2021-03-06 04:23:41 | Gilliam, Oregon, US |
1618621 | 1618621 | 2021-03-05 | US | North Dakota | Billings | 38007 | 54 | 0 | 0 | 53 | 47.02366884 | -103.3762965 | 2021-03-06 04:23:41 | Billings, North Dakota, US |
1616109 | 1616109 | 2021-03-05 | Comoros | 3587 | 145 | 3389 | 53 | -11.6455 | 43.3333 | 2021-03-06 04:23:41 | Comoros | |||
2210279 | 2210279 | 2021-03-04 | US | Oregon | Sherman | 41055 | 53 | 0 | 0 | 53 | 45.41501554 | -120.6827834 | 2021-03-05 05:26:29 | Sherman, Oregon, US |
2210262 | 2210262 | 2021-03-04 | US | Oregon | Gilliam | 41021 | 54 | 1 | 0 | 53 | 45.37160076 | -120.2048869 | 2021-03-05 05:26:29 | Gilliam, Oregon, US |
2210032 | 2210032 | 2021-03-04 | US | North Dakota | Billings | 38007 | 54 | 0 | 0 | 53 | 47.02366884 | -103.3762965 | 2021-03-05 05:26:29 | Billings, North Dakota, US |
2208576 | 2208576 | 2021-03-04 | US | Idaho | Clark | 16033 | 53 | 0 | 0 | 53 | 44.28496071 | -112.3505704 | 2021-03-05 05:26:29 | Clark, Idaho, US |
1092700 | 1092700 | 2021-03-03 | US | Oregon | Sherman | 41055 | 53 | 0 | 0 | 53 | 45.41501554 | -120.6827834 | 2021-03-04 05:24:24 | Sherman, Oregon, US |
1092683 | 1092683 | 2021-03-03 | US | Oregon | Gilliam | 41021 | 54 | 1 | 0 | 53 | 45.37160076 | -120.2048869 | 2021-03-04 05:24:24 | Gilliam, Oregon, US |
1092453 | 1092453 | 2021-03-03 | US | North Dakota | Billings | 38007 | 54 | 0 | 0 | 53 | 47.02366884 | -103.3762965 | 2021-03-04 05:24:24 | Billings, North Dakota, US |
1090997 | 1090997 | 2021-03-03 | US | Idaho | Clark | 16033 | 53 | 0 | 0 | 53 | 44.28496071 | -112.3505704 | 2021-03-04 05:24:24 | Clark, Idaho, US |
3256772 | 3256772 | 2021-03-02 | US | Oregon | Sherman | 41055 | 53 | 0 | 0 | 53 | 45.41501554 | -120.6827834 | 2021-03-03 05:23:28 | Sherman, Oregon, US |
3256755 | 3256755 | 2021-03-02 | US | Oregon | Gilliam | 41021 | 54 | 1 | 0 | 53 | 45.37160076 | -120.2048869 | 2021-03-03 05:23:28 | Gilliam, Oregon, US |
3256525 | 3256525 | 2021-03-02 | US | North Dakota | Billings | 38007 | 54 | 0 | 0 | 53 | 47.02366884 | -103.3762965 | 2021-03-03 05:23:28 | Billings, North Dakota, US |
3255069 | 3255069 | 2021-03-02 | US | Idaho | Clark | 16033 | 53 | 0 | 0 | 53 | 44.28496071 | -112.3505704 | 2021-03-03 05:23:28 | Clark, Idaho, US |
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]);