daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
3,743 rows where active = 28 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
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-08-03 | Denmark | Faroe Islands | 987 | 2 | 957 | 28 | 61.8926 | -6.9118 | 2021-08-04 04:21:25 | Faroe Islands, Denmark | ||
2021-08-02 | Denmark | Faroe Islands | 985 | 2 | 955 | 28 | 61.8926 | -6.9118 | 2021-08-03 04:21:39 | Faroe Islands, Denmark | ||
2021-08-02 | China | Hunan | 1096 | 4 | 1064 | 28 | 27.6104 | 111.7088 | 2021-08-03 04:21:39 | Hunan, China | ||
2021-08-02 | Australia | South Australia | 863 | 4 | 831 | 28 | -34.9285 | 138.6007 | 2021-08-03 04:21:39 | South Australia, Australia | ||
2021-08-01 | Australia | South Australia | 862 | 4 | 830 | 28 | -34.9285 | 138.6007 | 2021-08-02 04:21:36 | South Australia, Australia | ||
2021-07-28 | Australia | South Australia | 859 | 4 | 827 | 28 | -34.9285 | 138.6007 | 2021-07-29 04:21:33 | South Australia, Australia | ||
2021-07-27 | Japan | Yamagata | 2098 | 47 | 2023 | 28 | 38.448396 | 140.102154 | 2021-07-28 04:21:39 | Yamagata, Japan | ||
2021-07-27 | Burkina Faso | 13556 | 169 | 13359 | 28 | 12.2383 | -1.5616 | 2021-07-28 04:21:39 | Burkina Faso | |||
2021-07-25 | United Kingdom | Turks and Caicos Islands | 2464 | 18 | 2418 | 28 | 21.694000000000006 | -71.7979 | 2021-07-26 04:21:28 | Turks and Caicos Islands, United Kingdom | ||
2021-07-25 | Japan | Saga | 2638 | 24 | 2586 | 28 | 33.286977 | 130.115738 | 2021-07-26 04:21:28 | Saga, Japan | ||
2021-07-24 | Netherlands | Bonaire, Sint Eustatius and Saba | 1692 | 17 | 1647 | 28 | 12.1784 | -68.2385 | 2021-07-25 04:22:12 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
2021-07-24 | Japan | Saga | 2636 | 24 | 2584 | 28 | 33.286977 | 130.115738 | 2021-07-25 04:22:12 | Saga, Japan | ||
2021-07-23 | Japan | Kagawa | 2151 | 32 | 2091 | 28 | 34.217292 | 133.969047 | 2021-07-24 00:21:36 | Kagawa, Japan | ||
2021-07-22 | Italy | Valle d'Aosta | 11720 | 473 | 11219 | 28 | 45.73750286 | 7.320149366 | 2021-07-23 04:21:29 | Valle d'Aosta, Italy | ||
2021-07-20 | Japan | Miyazaki | 3125 | 27 | 3070 | 28 | 32.193203999999994 | 131.299374 | 2021-07-21 04:21:40 | Miyazaki, Japan | ||
2021-07-20 | Italy | Valle d'Aosta | 11715 | 473 | 11214 | 28 | 45.73750286 | 7.320149366 | 2021-07-21 04:21:40 | Valle d'Aosta, Italy | ||
2021-07-18 | Japan | Mie | 5465 | 113 | 5324 | 28 | 34.508018 | 136.376013 | 2021-07-19 04:21:24 | Mie, Japan | ||
2021-07-17 | United Kingdom | Turks and Caicos Islands | 2446 | 18 | 2400 | 28 | 21.694000000000006 | -71.7979 | 2021-07-18 04:22:07 | Turks and Caicos Islands, United Kingdom | ||
2021-07-17 | Japan | Oita | 3523 | 64 | 3431 | 28 | 33.200697 | 131.43323999999998 | 2021-07-18 04:22:07 | Oita, Japan | ||
2021-07-17 | Colombia | Vichada | 2745 | 45 | 2672 | 28 | 4.4234 | -69.2878 | 2021-07-18 04:22:07 | Vichada, Colombia | ||
2021-07-16 | United Kingdom | Turks and Caicos Islands | 2446 | 18 | 2400 | 28 | 21.694000000000006 | -71.7979 | 2021-07-17 04:22:22 | Turks and Caicos Islands, United Kingdom | ||
2021-07-16 | China | Hubei | 68188 | 4512 | 63648 | 28 | 30.9756 | 112.2707 | 2021-07-17 04:22:22 | Hubei, China | ||
2021-07-16 | Burkina Faso | 13532 | 169 | 13335 | 28 | 12.2383 | -1.5616 | 2021-07-17 04:22:22 | Burkina Faso | |||
2021-07-15 | Colombia | Vichada | 2720 | 45 | 2647 | 28 | 4.4234 | -69.2878 | 2021-07-16 04:21:22 | Vichada, Colombia | ||
2021-07-15 | China | Hubei | 68188 | 4512 | 63648 | 28 | 30.9756 | 112.2707 | 2021-07-16 04:21:22 | Hubei, China | ||
2021-07-14 | Japan | Toyama | 2068 | 38 | 2002 | 28 | 36.637464 | 137.26934599999998 | 2021-07-15 04:21:48 | Toyama, Japan | ||
2021-07-14 | Japan | Kumamoto | 6505 | 119 | 6358 | 28 | 32.608154 | 130.74523100000002 | 2021-07-15 04:21:48 | Kumamoto, Japan | ||
2021-07-14 | China | Hubei | 68188 | 4512 | 63648 | 28 | 30.9756 | 112.2707 | 2021-07-15 04:21:48 | Hubei, China | ||
2021-07-14 | Canada | Nova Scotia | 5870 | 92 | 5750 | 28 | 44.682 | -63.7443 | 2021-07-15 04:21:48 | Nova Scotia, Canada | ||
2021-07-13 | Sao Tome and Principe | 2392 | 37 | 2327 | 28 | 0.1864 | 6.6131 | 2021-07-14 04:21:35 | Sao Tome and Principe | |||
2021-07-13 | Japan | Toyama | 2066 | 38 | 2000 | 28 | 36.637464 | 137.26934599999998 | 2021-07-14 04:21:35 | Toyama, Japan | ||
2021-07-13 | China | Hubei | 68188 | 4512 | 63648 | 28 | 30.9756 | 112.2707 | 2021-07-14 04:21:35 | Hubei, China | ||
2021-07-12 | Sao Tome and Principe | 2392 | 37 | 2327 | 28 | 0.1864 | 6.6131 | 2021-07-13 04:21:18 | Sao Tome and Principe | |||
2021-07-12 | China | Hubei | 68188 | 4512 | 63648 | 28 | 30.9756 | 112.2707 | 2021-07-13 04:21:18 | Hubei, China | ||
2021-07-12 | Burkina Faso | 13520 | 168 | 13324 | 28 | 12.2383 | -1.5616 | 2021-07-13 04:21:18 | Burkina Faso | |||
2021-07-11 | Sao Tome and Principe | 2392 | 37 | 2327 | 28 | 0.1864 | 6.6131 | 2021-07-12 04:21:34 | Sao Tome and Principe | |||
2021-07-11 | Japan | Miyazaki | 3103 | 27 | 3048 | 28 | 32.193203999999994 | 131.299374 | 2021-07-12 04:21:34 | Miyazaki, Japan | ||
2021-07-10 | Sao Tome and Principe | 2392 | 37 | 2327 | 28 | 0.1864 | 6.6131 | 2021-07-11 04:21:43 | Sao Tome and Principe | |||
2021-07-10 | Japan | Kagoshima | 3731 | 39 | 3664 | 28 | 31.009484000000004 | 130.430665 | 2021-07-11 04:21:43 | Kagoshima, Japan | ||
2021-07-09 | Japan | Yamagata | 2044 | 47 | 1969 | 28 | 38.448396 | 140.102154 | 2021-07-10 04:21:25 | Yamagata, Japan | ||
2021-07-09 | Japan | Kumamoto | 6494 | 119 | 6347 | 28 | 32.608154 | 130.74523100000002 | 2021-07-10 04:21:25 | Kumamoto, Japan | ||
2021-07-09 | Japan | Kagoshima | 3727 | 39 | 3660 | 28 | 31.009484000000004 | 130.430665 | 2021-07-10 04:21:25 | Kagoshima, Japan | ||
2021-07-08 | Netherlands | Aruba | 11144 | 107 | 11009 | 28 | 12.5211 | -69.9683 | 2021-07-09 04:21:21 | Aruba, Netherlands | ||
2021-07-08 | Monaco | 2603 | 33 | 2542 | 28 | 43.7333 | 7.4167 | 2021-07-09 04:21:21 | Monaco | |||
2021-07-07 | Netherlands | Aruba | 11144 | 107 | 11009 | 28 | 12.5211 | -69.9683 | 2021-07-08 04:21:26 | Aruba, Netherlands | ||
2021-07-06 | Netherlands | Aruba | 11144 | 107 | 11009 | 28 | 12.5211 | -69.9683 | 2021-07-07 04:21:20 | Aruba, Netherlands | ||
2021-07-06 | Japan | Kagoshima | 3706 | 39 | 3639 | 28 | 31.009484000000004 | 130.430665 | 2021-07-07 04:21:20 | Kagoshima, Japan | ||
2021-07-05 | Netherlands | Aruba | 11144 | 107 | 11009 | 28 | 12.5211 | -69.9683 | 2021-07-06 04:21:32 | Aruba, Netherlands | ||
2021-07-04 | Netherlands | Aruba | 11144 | 107 | 11009 | 28 | 12.5211 | -69.9683 | 2021-07-05 04:21:28 | Aruba, Netherlands | ||
2021-07-03 | Netherlands | Aruba | 11144 | 107 | 11009 | 28 | 12.5211 | -69.9683 | 2021-07-04 04:21:38 | Aruba, Netherlands | ||
2021-07-02 | Netherlands | Aruba | 11144 | 107 | 11009 | 28 | 12.5211 | -69.9683 | 2021-07-03 04:21:37 | Aruba, Netherlands | ||
2021-07-01 | United Kingdom | Gibraltar | 4351 | 94 | 4229 | 28 | 36.1408 | -5.3536 | 2021-07-02 04:21:47 | Gibraltar, United Kingdom | ||
2021-07-01 | Netherlands | Aruba | 11140 | 107 | 11005 | 28 | 12.5211 | -69.9683 | 2021-07-02 04:21:47 | Aruba, Netherlands | ||
2021-06-30 | United Kingdom | Gibraltar | 4348 | 94 | 4226 | 28 | 36.1408 | -5.3536 | 2021-07-01 04:21:19 | Gibraltar, United Kingdom | ||
2021-06-30 | Australia | Victoria | 20712 | 820 | 19864 | 28 | -37.8136 | 144.9631 | 2021-07-01 04:21:19 | Victoria, Australia | ||
2021-06-29 | United Kingdom | Gibraltar | 4348 | 94 | 4226 | 28 | 36.1408 | -5.3536 | 2021-06-30 04:21:41 | Gibraltar, United Kingdom | ||
2021-06-29 | Monaco | 2576 | 33 | 2515 | 28 | 43.7333 | 7.4167 | 2021-06-30 04:21:41 | Monaco | |||
2021-06-28 | Netherlands | Aruba | 11132 | 107 | 10997 | 28 | 12.5211 | -69.9683 | 2021-06-29 04:21:28 | Aruba, Netherlands | ||
2021-06-28 | Monaco | 2575 | 33 | 2514 | 28 | 43.7333 | 7.4167 | 2021-06-29 04:21:28 | Monaco | |||
2021-06-28 | Japan | Miyazaki | 3074 | 27 | 3019 | 28 | 32.193203999999994 | 131.299374 | 2021-06-29 04:21:28 | Miyazaki, Japan | ||
2021-06-27 | New Zealand | 2738 | 28 | 2684 | 28 | -40.9006 | 174.886 | 2021-06-28 04:21:29 | New Zealand | |||
2021-06-27 | Malta | 30606 | 420 | 30158 | 28 | 35.9375 | 14.3754 | 2021-06-28 04:21:29 | Malta | |||
2021-06-26 | United Kingdom | Gibraltar | 4339 | 94 | 4217 | 28 | 36.1408 | -5.3536 | 2021-06-27 04:21:39 | Gibraltar, United Kingdom | ||
2021-06-24 | France | French Polynesia | 18992 | 142 | 18822 | 28 | -17.6797 | -149.4068 | 2021-06-25 04:21:33 | French Polynesia, France | ||
2021-06-22 | Malaysia | Perlis | 574 | 7 | 539 | 28 | 6.4449 | 100.2048 | 2021-06-23 04:21:46 | Perlis, Malaysia | ||
2021-06-21 | Malaysia | Perlis | 572 | 6 | 538 | 28 | 6.4449 | 100.2048 | 2021-06-22 04:21:34 | Perlis, Malaysia | ||
2021-06-20 | Netherlands | Aruba | 11108 | 107 | 10973 | 28 | 12.5211 | -69.9683 | 2021-06-21 04:21:41 | Aruba, Netherlands | ||
2021-06-20 | China | Sichuan | 1059 | 3 | 1028 | 28 | 30.6171 | 102.7103 | 2021-06-21 04:21:41 | Sichuan, China | ||
2021-06-17 | Netherlands | Aruba | 11099 | 107 | 10964 | 28 | 12.5211 | -69.9683 | 2021-06-18 04:22:16 | Aruba, Netherlands | ||
2021-06-17 | France | French Polynesia | 18957 | 142 | 18787 | 28 | -17.6797 | -149.4068 | 2021-06-18 04:22:16 | French Polynesia, France | ||
2021-06-15 | Netherlands | Curacao | 12296 | 123 | 12145 | 28 | 12.1696 | -68.99 | 2021-06-16 04:22:32 | Curacao, Netherlands | ||
2021-06-15 | Denmark | Faroe Islands | 757 | 1 | 728 | 28 | 61.8926 | -6.9118 | 2021-06-16 04:22:32 | Faroe Islands, Denmark | ||
2021-06-14 | Benin | 8109 | 102 | 7979 | 28 | 9.3077 | 2.3158 | 2021-06-15 04:22:22 | Benin | |||
2021-06-13 | Denmark | Faroe Islands | 756 | 1 | 727 | 28 | 61.8926 | -6.9118 | 2021-06-14 04:22:46 | Faroe Islands, Denmark | ||
2021-06-13 | Benin | 8109 | 102 | 7979 | 28 | 9.3077 | 2.3158 | 2021-06-14 04:22:46 | Benin | |||
2021-06-12 | Benin | 8109 | 102 | 7979 | 28 | 9.3077 | 2.3158 | 2021-06-13 04:22:44 | Benin | |||
2021-06-11 | Benin | 8109 | 102 | 7979 | 28 | 9.3077 | 2.3158 | 2021-06-12 04:22:22 | Benin | |||
2021-06-10 | Netherlands | Curacao | 12291 | 123 | 12140 | 28 | 12.1696 | -68.99 | 2021-06-11 04:23:20 | Curacao, Netherlands | ||
2021-06-10 | Netherlands | Aruba | 11069 | 107 | 10934 | 28 | 12.5211 | -69.9683 | 2021-06-11 04:23:20 | Aruba, Netherlands | ||
2021-06-10 | Benin | 8109 | 102 | 7979 | 28 | 9.3077 | 2.3158 | 2021-06-11 04:23:20 | Benin | |||
2021-06-09 | Benin | 8109 | 102 | 7979 | 28 | 9.3077 | 2.3158 | 2021-06-10 04:23:17 | Benin | |||
2021-06-08 | Australia | Queensland | 1634 | 7 | 1599 | 28 | -27.4698 | 153.0251 | 2021-06-09 04:23:31 | Queensland, Australia | ||
2021-06-07 | Russia | Chukotka Autonomous Okrug | 773 | 7 | 738 | 28 | 66.0006475 | 169.4900869 | 2021-06-08 04:22:35 | Chukotka Autonomous Okrug, Russia | ||
2021-06-07 | Japan | Akita | 760 | 18 | 714 | 28 | 39.748679 | 140.408228 | 2021-06-08 04:22:35 | Akita, Japan | ||
2021-06-06 | Russia | Chukotka Autonomous Okrug | 773 | 7 | 738 | 28 | 66.0006475 | 169.4900869 | 2021-06-07 04:22:51 | Chukotka Autonomous Okrug, Russia | ||
2021-06-05 | Japan | Fukui | 1053 | 34 | 991 | 28 | 35.846614 | 136.22465400000002 | 2021-06-06 04:24:03 | Fukui, Japan | ||
2021-06-03 | Colombia | Vaupes | 1561 | 14 | 1519 | 28 | 0.8554 | -70.812 | 2021-06-04 04:23:37 | Vaupes, Colombia | ||
2021-05-31 | Russia | Chukotka Autonomous Okrug | 768 | 7 | 733 | 28 | 66.0006475 | 169.4900869 | 2021-06-01 04:23:09 | Chukotka Autonomous Okrug, Russia | ||
2021-05-30 | Russia | Chukotka Autonomous Okrug | 768 | 7 | 733 | 28 | 66.0006475 | 169.4900869 | 2021-05-31 03:08:59 | Chukotka Autonomous Okrug, Russia | ||
2021-05-29 | Netherlands | Curacao | 12271 | 122 | 12121 | 28 | 12.1696 | -68.99 | 2021-05-30 04:20:55 | Curacao, Netherlands | ||
2021-05-25 | China | Fujian | 616 | 1 | 587 | 28 | 26.0789 | 117.9874 | 2021-05-26 04:20:35 | Fujian, China | ||
2021-05-23 | Canada | Nunavut | 638 | 4 | 606 | 28 | 70.2998 | -83.1076 | 2021-05-24 04:20:53 | Nunavut, Canada | ||
2021-05-22 | China | Fujian | 612 | 1 | 583 | 28 | 26.0789 | 117.9874 | 2021-05-23 04:20:51 | Fujian, China | ||
2021-05-20 | Djibouti | 11485 | 152 | 11305 | 28 | 11.8251 | 42.5903 | 2021-05-21 04:20:43 | Djibouti | |||
2021-05-20 | China | Yunnan | 351 | 2 | 321 | 28 | 24.974 | 101.487 | 2021-05-21 04:20:43 | Yunnan, China | ||
2021-05-20 | Chad | 4918 | 173 | 4717 | 28 | 15.4542 | 18.7322 | 2021-05-21 04:20:43 | Chad | |||
2021-05-18 | China | Sichuan | 1004 | 3 | 973 | 28 | 30.6171 | 102.7103 | 2021-05-19 04:20:42 | Sichuan, China | ||
2021-05-18 | Chad | 4905 | 173 | 4704 | 28 | 15.4542 | 18.7322 | 2021-05-19 04:20:42 | Chad | |||
2021-05-17 | Colombia | Vichada | 1633 | 25 | 1580 | 28 | 4.4234 | -69.2878 | 2021-05-18 04:20:33 | Vichada, Colombia | ||
2021-05-15 | China | Sichuan | 1001 | 3 | 970 | 28 | 30.6171 | 102.7103 | 2021-05-16 04:20:49 | Sichuan, China |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;