daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
3,067 rows where active = 37 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,648
- Japan 80
- China 45
- Colombia 34
- France 22
- Malaysia 19
- India 14
- Canada 12
- Germany 10
- Libya 10
- Mauritius 10
- Sao Tome and Principe 10
- Ukraine 10
- Denmark 9
- Russia 9
- Australia 8
- Bhutan 8
- Eritrea 8
- United Kingdom 8
- Burundi 6
- Italy 6
- Belize 5
- Burkina Faso 5
- Chile 5
- Netherlands 5
- San Marino 5
- Uganda 5
- New Zealand 4
- Taiwan* 4
- Barbados 3
- …
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-08-03 | Burkina Faso | 13591 | 169 | 13385 | 37 | 12.2383 | -1.5616 | 2021-08-04 04:21:25 | Burkina Faso | |||
2021-08-02 | Burkina Faso | 13591 | 169 | 13385 | 37 | 12.2383 | -1.5616 | 2021-08-03 04:21:39 | Burkina Faso | |||
2021-08-01 | New Zealand | 2877 | 28 | 2814 | 37 | -40.9006 | 174.886 | 2021-08-02 04:21:36 | New Zealand | |||
2021-07-29 | India | Chandigarh | 61948 | 809 | 61102 | 37 | 30.733839 | 76.76827800000002 | 2021-07-30 04:21:34 | Chandigarh, India | ||
2021-07-28 | Denmark | Greenland | 108 | 0 | 71 | 37 | 71.7069 | -42.6043 | 2021-07-29 04:21:33 | Greenland, Denmark | ||
2021-07-27 | India | Chandigarh | 61938 | 809 | 61092 | 37 | 30.733839 | 76.76827800000002 | 2021-07-28 04:21:39 | Chandigarh, India | ||
2021-07-25 | Chile | Aysen | 8046 | 70 | 7939 | 37 | -45.9864 | -73.7669 | 2021-07-26 04:21:28 | Aysen, Chile | ||
2021-07-22 | United Kingdom | Turks and Caicos Islands | 2459 | 18 | 2404 | 37 | 21.694000000000006 | -71.7979 | 2021-07-23 04:21:29 | Turks and Caicos Islands, United Kingdom | ||
2021-07-22 | Japan | Miyazaki | 3137 | 27 | 3073 | 37 | 32.193203999999994 | 131.299374 | 2021-07-23 04:21:29 | Miyazaki, Japan | ||
2021-07-20 | Sao Tome and Principe | 2410 | 37 | 2336 | 37 | 0.1864 | 6.6131 | 2021-07-21 04:21:40 | Sao Tome and Principe | |||
2021-07-19 | United Kingdom | Turks and Caicos Islands | 2455 | 18 | 2400 | 37 | 21.694000000000006 | -71.7979 | 2021-07-20 04:21:48 | Turks and Caicos Islands, United Kingdom | ||
2021-07-19 | Sao Tome and Principe | 2410 | 37 | 2336 | 37 | 0.1864 | 6.6131 | 2021-07-20 04:21:48 | Sao Tome and Principe | |||
2021-07-19 | Japan | Toyama | 2087 | 38 | 2012 | 37 | 36.637464 | 137.26934599999998 | 2021-07-20 04:21:48 | Toyama, Japan | ||
2021-07-18 | Sao Tome and Principe | 2410 | 37 | 2336 | 37 | 0.1864 | 6.6131 | 2021-07-19 04:21:24 | Sao Tome and Principe | |||
2021-07-17 | Sao Tome and Principe | 2410 | 37 | 2336 | 37 | 0.1864 | 6.6131 | 2021-07-18 04:22:07 | Sao Tome and Principe | |||
2021-07-16 | Sao Tome and Principe | 2406 | 37 | 2332 | 37 | 0.1864 | 6.6131 | 2021-07-17 04:22:22 | Sao Tome and Principe | |||
2021-07-16 | Barbados | 4241 | 48 | 4156 | 37 | 13.1939 | -59.5432 | 2021-07-17 04:22:22 | Barbados | |||
2021-07-15 | Japan | Nagasaki | 3244 | 69 | 3138 | 37 | 33.235712 | 129.608033 | 2021-07-16 04:21:22 | Nagasaki, Japan | ||
2021-07-12 | Canada | Nova Scotia | 5869 | 92 | 5742 | 37 | 44.682 | -63.7443 | 2021-07-13 04:21:18 | Nova Scotia, Canada | ||
2021-06-30 | Japan | Miyazaki | 3083 | 27 | 3019 | 37 | 32.193203999999994 | 131.299374 | 2021-07-01 04:21:19 | Miyazaki, Japan | ||
2021-06-29 | Italy | Valle d'Aosta | 11688 | 473 | 11178 | 37 | 45.73750286 | 7.320149366 | 2021-06-30 04:21:41 | Valle d'Aosta, Italy | ||
2021-06-26 | Italy | Valle d'Aosta | 11683 | 473 | 11173 | 37 | 45.73750286 | 7.320149366 | 2021-06-27 04:21:39 | Valle d'Aosta, Italy | ||
2021-06-25 | Japan | Kagoshima | 3647 | 38 | 3572 | 37 | 31.009484000000004 | 130.430665 | 2021-06-26 04:21:43 | Kagoshima, Japan | ||
2021-06-25 | Italy | Valle d'Aosta | 11683 | 473 | 11173 | 37 | 45.73750286 | 7.320149366 | 2021-06-26 04:21:43 | Valle d'Aosta, Italy | ||
2021-06-23 | Japan | Nara | 8078 | 127 | 7914 | 37 | 34.317451 | 135.871644 | 2021-06-24 04:21:55 | Nara, Japan | ||
2021-06-23 | Colombia | Guainia | 2032 | 23 | 1972 | 37 | 2.5854 | -68.5247 | 2021-06-24 04:21:55 | Guainia, Colombia | ||
2021-06-20 | Colombia | Amazonas | 6375 | 243 | 6095 | 37 | -1.4429 | -71.5724 | 2021-06-21 04:21:41 | Amazonas, Colombia | ||
2021-06-18 | Japan | Aomori | 2452 | 31 | 2384 | 37 | 40.781541 | 140.828896 | 2021-06-19 04:22:33 | Aomori, Japan | ||
2021-06-16 | Australia | Queensland | 1661 | 7 | 1617 | 37 | -27.4698 | 153.0251 | 2021-06-17 04:22:36 | Queensland, Australia | ||
2021-06-15 | Colombia | Amazonas | 6366 | 242 | 6087 | 37 | -1.4429 | -71.5724 | 2021-06-16 04:22:32 | Amazonas, Colombia | ||
2021-06-14 | Colombia | Amazonas | 6366 | 242 | 6087 | 37 | -1.4429 | -71.5724 | 2021-06-15 04:22:22 | Amazonas, Colombia | ||
2021-06-13 | China | Fujian | 637 | 1 | 599 | 37 | 26.0789 | 117.9874 | 2021-06-14 04:22:46 | Fujian, China | ||
2021-06-12 | China | Fujian | 637 | 1 | 599 | 37 | 26.0789 | 117.9874 | 2021-06-13 04:22:44 | Fujian, China | ||
2021-06-10 | Colombia | Guainia | 1870 | 22 | 1811 | 37 | 2.5854 | -68.5247 | 2021-06-11 04:23:20 | Guainia, Colombia | ||
2021-06-10 | China | Fujian | 635 | 1 | 597 | 37 | 26.0789 | 117.9874 | 2021-06-11 04:23:20 | Fujian, China | ||
2021-06-09 | Japan | Saga | 2534 | 23 | 2474 | 37 | 33.286977 | 130.115738 | 2021-06-10 04:23:17 | Saga, Japan | ||
2021-06-09 | Colombia | Amazonas | 6359 | 242 | 6080 | 37 | -1.4429 | -71.5724 | 2021-06-10 04:23:17 | Amazonas, Colombia | ||
2021-06-08 | Denmark | Faroe Islands | 747 | 1 | 709 | 37 | 61.8926 | -6.9118 | 2021-06-09 04:23:31 | Faroe Islands, Denmark | ||
2021-06-06 | China | Fujian | 629 | 1 | 591 | 37 | 26.0789 | 117.9874 | 2021-06-07 04:22:51 | Fujian, China | ||
2021-06-05 | Colombia | Amazonas | 6349 | 241 | 6071 | 37 | -1.4429 | -71.5724 | 2021-06-06 04:24:03 | Amazonas, Colombia | ||
2021-06-05 | China | Sichuan | 1039 | 3 | 999 | 37 | 30.6171 | 102.7103 | 2021-06-06 04:24:03 | Sichuan, China | ||
2021-06-05 | China | Fujian | 629 | 1 | 591 | 37 | 26.0789 | 117.9874 | 2021-06-06 04:24:03 | Fujian, China | ||
2021-06-04 | China | Fujian | 628 | 1 | 590 | 37 | 26.0789 | 117.9874 | 2021-06-05 04:23:03 | Fujian, China | ||
2021-06-03 | Russia | Jewish Autonomous Okrug | 4501 | 143 | 4321 | 37 | 48.57527615 | 132.66307460000002 | 2021-06-04 04:23:37 | Jewish Autonomous Okrug, Russia | ||
2021-06-03 | Japan | Tottori | 466 | 2 | 427 | 37 | 35.359069 | 133.863619 | 2021-06-04 04:23:37 | Tottori, Japan | ||
2021-06-03 | Colombia | Amazonas | 6348 | 241 | 6070 | 37 | -1.4429 | -71.5724 | 2021-06-04 04:23:37 | Amazonas, Colombia | ||
2021-06-02 | Russia | Jewish Autonomous Okrug | 4499 | 142 | 4320 | 37 | 48.57527615 | 132.66307460000002 | 2021-06-03 04:23:32 | Jewish Autonomous Okrug, Russia | ||
2021-06-01 | Russia | Jewish Autonomous Okrug | 4498 | 142 | 4319 | 37 | 48.57527615 | 132.66307460000002 | 2021-06-02 04:24:34 | Jewish Autonomous Okrug, Russia | ||
2021-05-28 | Denmark | Faroe Islands | 707 | 1 | 669 | 37 | 61.8926 | -6.9118 | 2021-05-29 04:20:41 | Faroe Islands, Denmark | ||
2021-05-28 | Colombia | Vaupes | 1523 | 14 | 1472 | 37 | 0.8554 | -70.812 | 2021-05-29 04:20:41 | Vaupes, Colombia | ||
2021-05-27 | Barbados | 4006 | 47 | 3922 | 37 | 13.1939 | -59.5432 | 2021-05-28 04:20:36 | Barbados | |||
2021-05-25 | Colombia | Vaupes | 1498 | 14 | 1447 | 37 | 0.8554 | -70.812 | 2021-05-26 04:20:35 | Vaupes, Colombia | ||
2021-05-24 | China | Zhejiang | 1362 | 1 | 1324 | 37 | 29.1832 | 120.0934 | 2021-05-25 04:21:08 | Zhejiang, China | ||
2021-05-23 | China | Zhejiang | 1362 | 1 | 1324 | 37 | 29.1832 | 120.0934 | 2021-05-24 04:20:53 | Zhejiang, China | ||
2021-05-22 | China | Zhejiang | 1362 | 1 | 1324 | 37 | 29.1832 | 120.0934 | 2021-05-23 04:20:51 | Zhejiang, China | ||
2021-05-19 | Russia | Jewish Autonomous Okrug | 4482 | 140 | 4305 | 37 | 48.57527615 | 132.66307460000002 | 2021-05-20 04:21:05 | Jewish Autonomous Okrug, Russia | ||
2021-05-19 | China | Guangdong | 2399 | 8 | 2354 | 37 | 23.3417 | 113.4244 | 2021-05-20 04:21:05 | Guangdong, China | ||
2021-05-16 | Malaysia | W.P. Labuan | 2516 | 13 | 2466 | 37 | 5.2831 | 115.2308 | 2021-05-17 04:20:34 | W.P. Labuan, Malaysia | ||
2021-05-13 | China | Yunnan | 348 | 2 | 309 | 37 | 24.974 | 101.487 | 2021-05-14 04:20:41 | Yunnan, China | ||
2021-05-12 | Eswatini | 18492 | 671 | 17784 | 37 | -26.5225 | 31.4659 | 2021-05-13 04:20:51 | Eswatini | |||
2021-05-08 | Fiji | 136 | 3 | 96 | 37 | -17.7134 | 178.065 | 2021-05-09 04:20:35 | Fiji | |||
2021-05-06 | Japan | Shimane | 366 | 0 | 329 | 37 | 35.07076 | 132.55406399999998 | 2021-05-07 04:20:40 | Shimane, Japan | ||
2021-05-05 | Japan | Shimane | 365 | 0 | 328 | 37 | 35.07076 | 132.55406399999998 | 2021-05-06 04:20:38 | Shimane, Japan | ||
2021-05-04 | Australia | Queensland | 1568 | 7 | 1524 | 37 | -27.4698 | 153.0251 | 2021-05-05 04:20:43 | Queensland, Australia | ||
2021-05-01 | Canada | Newfoundland and Labrador | 1081 | 6 | 1038 | 37 | 53.1355 | -57.6604 | 2021-05-02 04:20:48 | Newfoundland and Labrador, Canada | ||
2021-04-30 | Canada | Newfoundland and Labrador | 1076 | 6 | 1033 | 37 | 53.1355 | -57.6604 | 2021-05-01 04:20:47 | Newfoundland and Labrador, Canada | ||
2021-04-28 | Barbados | 3831 | 44 | 3750 | 37 | 13.1939 | -59.5432 | 2021-04-29 04:20:55 | Barbados | |||
2021-04-23 | Canada | Nunavut | 441 | 4 | 400 | 37 | 70.2998 | -83.1076 | 2021-04-24 04:20:38 | Nunavut, Canada | ||
2021-04-13 | Malaysia | W.P. Labuan | 2413 | 12 | 2364 | 37 | 5.2831 | 115.2308 | 2021-04-14 04:20:41 | W.P. Labuan, Malaysia | ||
2021-04-13 | Netherlands | Sint Maarten | 2188 | 27 | 2124 | 37 | 18.0425 | -63.0548 | 2021-04-14 04:20:41 | Sint Maarten, Netherlands | ||
2021-04-10 | Japan | Kochi | 946 | 19 | 890 | 37 | 33.422519 | 133.367307 | 2021-04-11 04:20:56 | Kochi, Japan | ||
2021-04-09 | Japan | Kochi | 946 | 19 | 890 | 37 | 33.422519 | 133.367307 | 2021-04-10 04:20:59 | Kochi, Japan | ||
2021-04-08 | Japan | Kochi | 945 | 19 | 889 | 37 | 33.422519 | 133.367307 | 2021-04-09 04:21:13 | Kochi, Japan | ||
2021-04-07 | Canada | Nova Scotia | 1749 | 66 | 1646 | 37 | 44.682 | -63.7443 | 2021-04-08 04:21:13 | Nova Scotia, Canada | ||
2021-04-06 | Japan | Kumamoto | 3526 | 74 | 3415 | 37 | 32.608154 | 130.74523100000002 | 2021-04-07 04:20:53 | Kumamoto, Japan | ||
2021-04-05 | Malaysia | Terengganu | 3622 | 13 | 3572 | 37 | 5.3117 | 103.1324 | 2021-04-06 04:20:32 | Terengganu, Malaysia | ||
2021-04-03 | Germany | Unknown | 37 | 0 | 0 | 37 | 2021-04-04 04:20:49 | Unknown, Germany | ||||
2021-04-01 | India | Mizoram | 4484 | 11 | 4436 | 37 | 23.309381 | 92.83822 | 2021-04-02 04:20:36 | Mizoram, India | ||
2021-04-01 | India | Lakshadweep | 726 | 1 | 688 | 37 | 13.6999972 | 72.18333259999999 | 2021-04-02 04:20:36 | Lakshadweep, India | ||
2021-03-31 | Russia | Chukotka Autonomous Okrug | 733 | 5 | 691 | 37 | 66.0006475 | 169.4900869 | 2021-04-01 04:27:05 | Chukotka Autonomous Okrug, Russia | ||
2021-03-30 | Belize | 12415 | 317 | 12061 | 37 | 17.1899 | -88.4976 | 2021-03-31 04:26:25 | Belize | |||
2021-03-29 | Uganda | 40820 | 335 | 40448 | 37 | 1.373333 | 32.290275 | 2021-03-30 04:26:23 | Uganda | |||
2021-03-29 | Saint Lucia | 4202 | 58 | 4107 | 37 | 13.9094 | -60.9789 | 2021-03-30 04:26:23 | Saint Lucia | |||
2021-03-29 | Belize | 12415 | 317 | 12061 | 37 | 17.1899 | -88.4976 | 2021-03-30 04:26:23 | Belize | |||
2021-03-28 | Uganda | 40794 | 335 | 40422 | 37 | 1.373333 | 32.290275 | 2021-03-29 04:28:35 | Uganda | |||
2021-03-28 | Belize | 12415 | 317 | 12061 | 37 | 17.1899 | -88.4976 | 2021-03-29 04:28:35 | Belize | |||
2021-03-27 | Pakistan | Gilgit-Baltistan | 4999 | 103 | 4859 | 37 | 35.792146 | 74.982138 | 2021-03-28 05:28:10 | Gilgit-Baltistan, Pakistan | ||
2021-03-27 | Belize | 12415 | 317 | 12061 | 37 | 17.1899 | -88.4976 | 2021-03-28 05:28:10 | Belize | |||
2021-03-26 | Uganda | 40751 | 335 | 40379 | 37 | 1.373333 | 32.290275 | 2021-03-27 05:25:04 | Uganda | |||
2021-03-26 | Belize | 12415 | 317 | 12061 | 37 | 17.1899 | -88.4976 | 2021-03-27 05:25:04 | Belize | |||
2021-03-22 | China | Shanghai | 1856 | 7 | 1812 | 37 | 31.202 | 121.4491 | 2021-03-23 05:26:18 | Shanghai, China | ||
2021-03-17 | France | New Caledonia | 95 | 0 | 58 | 37 | -20.904305 | 165.618042 | 2021-03-18 05:26:22 | New Caledonia, France | ||
2021-03-16 | France | New Caledonia | 95 | 0 | 58 | 37 | -20.904305 | 165.618042 | 2021-03-17 05:25:07 | New Caledonia, France | ||
2021-03-15 | Japan | Wakayama | 1179 | 18 | 1124 | 37 | 33.911879 | 135.505446 | 2021-03-16 05:25:13 | Wakayama, Japan | ||
2021-03-15 | Canada | New Brunswick | 1471 | 30 | 1404 | 37 | 46.5653 | -66.4619 | 2021-03-16 05:25:13 | New Brunswick, Canada | ||
2021-03-13 | Japan | Hiroshima | 5062 | 103 | 4922 | 37 | 34.605309000000005 | 132.788719 | 2021-03-14 05:25:37 | Hiroshima, Japan | ||
2021-03-13 | Japan | Aomori | 852 | 20 | 795 | 37 | 40.781541 | 140.828896 | 2021-03-14 05:25:37 | Aomori, Japan | ||
2021-03-08 | Japan | Kumamoto | 3457 | 73 | 3347 | 37 | 32.608154 | 130.74523100000002 | 2021-03-09 05:28:19 | Kumamoto, Japan | ||
2021-03-08 | Canada | New Brunswick | 1460 | 28 | 1395 | 37 | 46.5653 | -66.4619 | 2021-03-09 05:28:19 | New Brunswick, Canada | ||
2021-03-07 | Japan | Kumamoto | 3457 | 73 | 3347 | 37 | 32.608154 | 130.74523100000002 | 2021-03-08 05:24:48 | Kumamoto, Japan |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;